stcwp
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
STCW.TR_CERTIF_ENDORSEMENT_H
Parameters
Name
Type
Mode
Definition
TRIGGER "STCW"."TR_CERTIF_ENDORSEMENT_H" AFTER INSERT OR UPDATE OR DELETE ON CERTIFICATE_ENDORSEMENT REFERENCING OLD AS early NEW AS late FOR EACH row DECLARE action VARCHAR2(75); BEGIN IF INSERTING THEN action := 'INSERTING'; INSERT INTO STCW_HISTORY.CERTIFICATE_ENDORSEMENT_H (CERTIFICATE_ENDORSEMENT_ID, ENUM_CERTIFICATE_TYPE_ID, LEGAL_ENTITY_ID, NAME, STCW_REFERENCE_ID_1, STCW_REFERENCE_ID_2, STCW_REFERENCE_ID_3, version_id, cuser, cdate, muser, mdate, action) VALUES(:late.CERTIFICATE_ENDORSEMENT_ID, :late.ENUM_CERTIFICATE_TYPE_ID, :late.LEGAL_ENTITY_ID, :late.NAME, :late.STCW_REFERENCE_ID_1, :late.STCW_REFERENCE_ID_2, :late.STCW_REFERENCE_ID_3, :late.version_id, :late.cuser, :late.cdate, :late.muser, :late.mdate, action); ELSIF UPDATING THEN action := 'UPDATING'; INSERT INTO STCW_HISTORY.CERTIFICATE_ENDORSEMENT_H (CERTIFICATE_ENDORSEMENT_ID, ENUM_CERTIFICATE_TYPE_ID, LEGAL_ENTITY_ID, NAME, STCW_REFERENCE_ID_1, STCW_REFERENCE_ID_2, STCW_REFERENCE_ID_3, version_id, cuser, cdate, muser, mdate, action) VALUES(:late.CERTIFICATE_ENDORSEMENT_ID, :late.ENUM_CERTIFICATE_TYPE_ID, :late.LEGAL_ENTITY_ID, :late.NAME, :late.STCW_REFERENCE_ID_1, :late.STCW_REFERENCE_ID_2, :late.STCW_REFERENCE_ID_3, :late.version_id, :late.cuser, :late.cdate, :late.muser, :late.mdate, action); ELSE action := 'DELETING'; INSERT INTO STCW_HISTORY.CERTIFICATE_ENDORSEMENT_H (CERTIFICATE_ENDORSEMENT_ID, ENUM_CERTIFICATE_TYPE_ID, LEGAL_ENTITY_ID, NAME, STCW_REFERENCE_ID_1, STCW_REFERENCE_ID_2, STCW_REFERENCE_ID_3, version_id, cuser, cdate, muser, mdate, action) VALUES(:early.CERTIFICATE_ENDORSEMENT_ID, :early.ENUM_CERTIFICATE_TYPE_ID, :early.LEGAL_ENTITY_ID, :early.NAME, :early.STCW_REFERENCE_ID_1, :early.STCW_REFERENCE_ID_2, :early.STCW_REFERENCE_ID_3, :early.version_id, :early.cuser, :early.cdate, :early.muser, :early.mdate, action); END IF; END;