stcwp
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
STCW.TR_FRAUDULENT_CERTIF_DOC_H
Parameters
Name
Type
Mode
Definition
TRIGGER "STCW"."TR_FRAUDULENT_CERTIF_DOC_H" AFTER INSERT OR UPDATE OR DELETE ON FRAUDULENT_CERTIFICATE_DOC 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_DOC_H(fraudulent_certificate_doc_id,fraudulent_certificate_id,document_id, ENUM_STATUS_ID, VERSION_ID,CUSER,CDATE,MUSER,MDATE, action) VALUES(:late.fraudulent_certificate_doc_id,:late.fraudulent_certificate_id,:late.document_id, :late.ENUM_STATUS_ID, :late.VERSION_ID,:late.CUSER,:late.CDATE,:late.MUSER, :late.MDATE, action); ELSIF UPDATING THEN action := 'UPDATING'; INSERT INTO STCW_HISTORY.FRAUDULENT_CERTIFICATE_DOC_H(fraudulent_certificate_doc_id,fraudulent_certificate_id,document_id, ENUM_STATUS_ID, VERSION_ID,CUSER,CDATE,MUSER,MDATE, action) VALUES(:late.fraudulent_certificate_doc_id,:late.fraudulent_certificate_id,:late.document_id, :late.ENUM_STATUS_ID, :late.VERSION_ID,:late.CUSER,:late.CDATE,:late.MUSER, :late.MDATE, action); ELSE action := 'DELETING'; INSERT INTO STCW_HISTORY.FRAUDULENT_CERTIFICATE_DOC_H(fraudulent_certificate_doc_id,fraudulent_certificate_id,document_id, ENUM_STATUS_ID, VERSION_ID,CUSER,CDATE,MUSER,MDATE, action) VALUES(:early.fraudulent_certificate_doc_id,:early.fraudulent_certificate_id,:early.document_id, :early.ENUM_STATUS_ID, :early.VERSION_ID,:early.CUSER,:early.CDATE,:early.MUSER, :early.MDATE, action); END IF; END;