stcwp
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
STCW.TR_FRAUDULENT_CERTIF_H
Parameters
Name
Type
Mode
Definition
TRIGGER "STCW"."TR_FRAUDULENT_CERTIF_H" AFTER INSERT OR UPDATE OR DELETE ON FRAUDULENT_CERTIFICATE REFERENCING OLD AS early NEW AS late FOR EACH row DECLARE action VARCHAR2(75); BEGIN IF INSERTING THEN action := 'INSERTING'; INSERT INTO STCW_HISTORY.FRAUDULENT_CERTIFICATE_H(FRAUDULENT_CERTIFICATE_ID,SHIP_FLAG,ENUM_FRAUD_TYPE_ID,ENUM_METHOD_DETECTION_ID,DETECTING_ENTITY,ALLEGED_ISSUING_ENTITY,ENUM_ACTION_TAKEN_ID,OBSERVATION,FRAUDULENT_CERTIFICATE_DATE,STCW_REFERENCE_ID,COUNTRY_ID,ENUM_STATUS_ID,VERSION_ID,CDATE,CUSER,MUSER, MDATE,ENUM_CERTIFICATE_TYPE_ID,action) VALUES(:late.FRAUDULENT_CERTIFICATE_ID,:late.SHIP_FLAG,:late.ENUM_FRAUD_TYPE_ID,:late.ENUM_METHOD_DETECTION_ID,:late.DETECTING_ENTITY,:late.ALLEGED_ISSUING_ENTITY,:late.ENUM_ACTION_TAKEN_ID,:late.OBSERVATION,:late.FRAUDULENT_CERTIFICATE_DATE,:late.STCW_REFERENCE_ID,:late.COUNTRY_ID,:late.ENUM_STATUS_ID,:late.VERSION_ID,:late.CDATE,:late.CUSER,:late.MUSER,:late.MDATE,:late.ENUM_CERTIFICATE_TYPE_ID,action); ELSIF UPDATING THEN action := 'UPDATING'; INSERT INTO STCW_HISTORY.FRAUDULENT_CERTIFICATE_H(FRAUDULENT_CERTIFICATE_ID,SHIP_FLAG,ENUM_FRAUD_TYPE_ID,ENUM_METHOD_DETECTION_ID,DETECTING_ENTITY,ALLEGED_ISSUING_ENTITY,ENUM_ACTION_TAKEN_ID,OBSERVATION,FRAUDULENT_CERTIFICATE_DATE,STCW_REFERENCE_ID,COUNTRY_ID,ENUM_STATUS_ID,VERSION_ID,CDATE,CUSER,MUSER, MDATE,ENUM_CERTIFICATE_TYPE_ID,action) VALUES(:late.FRAUDULENT_CERTIFICATE_ID,:late.SHIP_FLAG,:late.ENUM_FRAUD_TYPE_ID,:late.ENUM_METHOD_DETECTION_ID,:late.DETECTING_ENTITY,:late.ALLEGED_ISSUING_ENTITY,:late.ENUM_ACTION_TAKEN_ID,:late.OBSERVATION,:late.FRAUDULENT_CERTIFICATE_DATE,:late.STCW_REFERENCE_ID,:late.COUNTRY_ID,:late.ENUM_STATUS_ID,:late.VERSION_ID,:late.CDATE,:late.CUSER,:late.MUSER,:late.MDATE,:late.ENUM_CERTIFICATE_TYPE_ID,action); ELSE action := 'DELETING'; INSERT INTO STCW_HISTORY.FRAUDULENT_CERTIFICATE_H(FRAUDULENT_CERTIFICATE_ID,SHIP_FLAG,ENUM_FRAUD_TYPE_ID,ENUM_METHOD_DETECTION_ID,DETECTING_ENTITY,ALLEGED_ISSUING_ENTITY,ENUM_ACTION_TAKEN_ID,OBSERVATION,FRAUDULENT_CERTIFICATE_DATE,STCW_REFERENCE_ID,COUNTRY_ID,ENUM_STATUS_ID,VERSION_ID,CDATE,CUSER,MUSER, MDATE,ENUM_CERTIFICATE_TYPE_ID,action) VALUES(:early.FRAUDULENT_CERTIFICATE_ID,:early.SHIP_FLAG,:early.ENUM_FRAUD_TYPE_ID,:early.ENUM_METHOD_DETECTION_ID,:early.DETECTING_ENTITY,:early.ALLEGED_ISSUING_ENTITY,:early.ENUM_ACTION_TAKEN_ID,:early.OBSERVATION,:early.FRAUDULENT_CERTIFICATE_DATE,:early.STCW_REFERENCE_ID,:early.COUNTRY_ID,:early.ENUM_STATUS_ID,:early.VERSION_ID,:early.CDATE,:early.CUSER,:early.MUSER,:early.MDATE,:early.ENUM_CERTIFICATE_TYPE_ID,action); END IF; END;