stcwp
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
STCW.TR_LEGAL_REQUIREMENT_H
Parameters
Name
Type
Mode
Definition
TRIGGER "STCW"."TR_LEGAL_REQUIREMENT_H" AFTER INSERT OR UPDATE OR DELETE ON LEGAL_REQUIREMENT REFERENCING OLD AS early NEW AS late FOR EACH row DECLARE action VARCHAR2(75); BEGIN IF INSERTING THEN action := 'INSERTING'; INSERT INTO STCW_HISTORY.LEGAL_REQUIREMENT_H(LEGAL_REQUIREMENT_ID,NUM,CONTENT,LEGAL_REQUIREMENT_TYPE_ID,LEGAL_DOCUMENT_ID,NAME,CHILD_OF_ID,ENUM_STATUS_ID,VERSION_ID,HIERARCHY_CODE,CUSER,CDATE, MUSER, MDATE, action) VALUES(:late.LEGAL_REQUIREMENT_ID,:late.NUM,:late.CONTENT, :late.LEGAL_REQUIREMENT_TYPE_ID,:late.LEGAL_DOCUMENT_ID,:late.NAME,:late.CHILD_OF_ID,:late.ENUM_STATUS_ID,:late.VERSION_ID,:late.HIERARCHY_CODE,:late.CUSER, :late.CDATE,:late.MUSER,:late.MDATE, action); ELSIF UPDATING THEN IF :late.ENUM_STATUS_ID = 2 THEN action := 'DELETING'; ELSE action := 'UPDATING'; END IF; INSERT INTO STCW_HISTORY.LEGAL_REQUIREMENT_H(LEGAL_REQUIREMENT_ID,NUM,CONTENT,LEGAL_REQUIREMENT_TYPE_ID,LEGAL_DOCUMENT_ID,NAME,CHILD_OF_ID,ENUM_STATUS_ID,VERSION_ID,HIERARCHY_CODE,CUSER,CDATE, MUSER, MDATE, action) VALUES(:late.LEGAL_REQUIREMENT_ID,:late.NUM,:late.CONTENT, :late.LEGAL_REQUIREMENT_TYPE_ID,:late.LEGAL_DOCUMENT_ID,:late.NAME,:late.CHILD_OF_ID,:late.ENUM_STATUS_ID,:late.VERSION_ID,:late.HIERARCHY_CODE,:late.CUSER, :late.CDATE,:late.MUSER,:late.MDATE, action); ELSE action := 'DELETING'; INSERT INTO STCW_HISTORY.LEGAL_REQUIREMENT_H(LEGAL_REQUIREMENT_ID,NUM,CONTENT,LEGAL_REQUIREMENT_TYPE_ID,LEGAL_DOCUMENT_ID,NAME,CHILD_OF_ID,ENUM_STATUS_ID,VERSION_ID,HIERARCHY_CODE,CUSER,CDATE, MUSER, MDATE, action) VALUES(:early.LEGAL_REQUIREMENT_ID,:early.NUM,:early.CONTENT, :early.LEGAL_REQUIREMENT_TYPE_ID,:early.LEGAL_DOCUMENT_ID,:early.NAME,:early.CHILD_OF_ID,:early.ENUM_STATUS_ID,:early.VERSION_ID,:early.HIERARCHY_CODE,:early.CUSER, :early.CDATE,:early.MUSER,:early.MDATE, action); END IF; END;