stcwp
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
STCW.TR_LEGAL_REQ_PROC_H
Parameters
Name
Type
Mode
Definition
TRIGGER "STCW"."TR_LEGAL_REQ_PROC_H" AFTER INSERT OR UPDATE OR DELETE ON LEGAL_REQUIREMENT_PROCESS 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_PROCESS_H(LEGAL_REQUIREMENT_ID,LEGAL_REQUIREMENT_PROCESS_ID,PROCESS_ID, action) VALUES(:late.LEGAL_REQUIREMENT_ID,:late.LEGAL_REQUIREMENT_PROCESS_ID, :late.PROCESS_ID, action ); ELSIF UPDATING THEN action := 'UPDATING'; INSERT INTO STCW_HISTORY.LEGAL_REQUIREMENT_PROCESS_H(LEGAL_REQUIREMENT_ID,LEGAL_REQUIREMENT_PROCESS_ID,PROCESS_ID, action) VALUES(:late.LEGAL_REQUIREMENT_ID,:late.LEGAL_REQUIREMENT_PROCESS_ID, :late.PROCESS_ID, action ); ELSE action := 'DELETING'; INSERT INTO STCW_HISTORY.LEGAL_REQUIREMENT_PROCESS_H(LEGAL_REQUIREMENT_ID,LEGAL_REQUIREMENT_PROCESS_ID,PROCESS_ID, action) VALUES(:early.LEGAL_REQUIREMENT_ID,:early.LEGAL_REQUIREMENT_PROCESS_ID, :early.PROCESS_ID, action ); END IF; END;