stcwp
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
STCW.TR_ENUM_CERTIFICATE_TYPE_H
Parameters
Name
Type
Mode
Definition
TRIGGER "STCW"."TR_ENUM_CERTIFICATE_TYPE_H" AFTER INSERT OR UPDATE OR DELETE ON ENUM_CERTIFICATE_TYPE REFERENCING OLD AS early NEW AS late FOR EACH row DECLARE action VARCHAR2(75); BEGIN IF INSERTING THEN action := 'INSERTING'; INSERT INTO STCW_HISTORY.ENUM_CERTIFICATE_TYPE_H (ENUM_CERTIFICATE_TYPE_ID,NAME,DESCRIPTION, EXT_INFO_TYPE, VERSION_ID,CUSER,CDATE, MUSER,MDATE, action) VALUES(:late.ENUM_CERTIFICATE_TYPE_ID,:late.NAME, :late.DESCRIPTION, :late.EXT_INFO_TYPE, :late.VERSION_ID,:late.CUSER,:late.CDATE,:late.MUSER,:late.MDATE, action); ELSIF UPDATING THEN action := 'UPDATING'; INSERT INTO STCW_HISTORY.ENUM_CERTIFICATE_TYPE_H (ENUM_CERTIFICATE_TYPE_ID,NAME,DESCRIPTION, EXT_INFO_TYPE, VERSION_ID,CUSER,CDATE, MUSER,MDATE, action) VALUES(:late.ENUM_CERTIFICATE_TYPE_ID,:late.NAME, :late.DESCRIPTION, :late.EXT_INFO_TYPE, :late.VERSION_ID,:late.CUSER,:late.CDATE,:late.MUSER,:late.MDATE, action); ELSE action := 'DELETING'; INSERT INTO STCW_HISTORY.ENUM_CERTIFICATE_TYPE_H (ENUM_CERTIFICATE_TYPE_ID,NAME,DESCRIPTION, EXT_INFO_TYPE, VERSION_ID,CUSER,CDATE, MUSER,MDATE, action) VALUES(:early.ENUM_CERTIFICATE_TYPE_ID,:early.NAME, :early.DESCRIPTION, :early.EXT_INFO_TYPE, :early.VERSION_ID,:early.CUSER,:early.CDATE,:early.MUSER,:early.MDATE, action); END IF; END;