stcwp
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
STCW.TR_ENUM_ACTION_TAKEN_H
Parameters
Name
Type
Mode
Definition
TRIGGER "STCW"."TR_ENUM_ACTION_TAKEN_H" AFTER INSERT OR UPDATE OR DELETE ON ENUM_ACTION_TAKEN 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_ACTION_TAKEN_H (ENUM_ACTION_TAKEN_ID, NAME,DESCRIPTION,VERSION_ID, CUSER,CDATE, MUSER,MDATE, action) VALUES(:late.ENUM_ACTION_TAKEN_ID,:late.NAME,:late.DESCRIPTION,:late.VERSION_ID,:late.CUSER, :late.CDATE,:late.MUSER, :late.MDATE, action ); ELSIF UPDATING THEN action := 'UPDATING'; INSERT INTO STCW_HISTORY.ENUM_ACTION_TAKEN_H (ENUM_ACTION_TAKEN_ID, NAME,DESCRIPTION,VERSION_ID, CUSER,CDATE, MUSER,MDATE, action) VALUES(:late.ENUM_ACTION_TAKEN_ID,:late.NAME,:late.DESCRIPTION,:late.VERSION_ID,:late.CUSER, :late.CDATE,:late.MUSER, :late.MDATE, action ); ELSE action := 'DELETING'; INSERT INTO STCW_HISTORY.ENUM_ACTION_TAKEN_H (ENUM_ACTION_TAKEN_ID, NAME,DESCRIPTION,VERSION_ID, CUSER,CDATE, MUSER,MDATE, action) VALUES(:early.ENUM_ACTION_TAKEN_ID,:early.NAME,:early.DESCRIPTION,:early.VERSION_ID,:early.CUSER, :early.CDATE,:early.MUSER, :early.MDATE, action ); END IF; END;