stcwp
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
STCW.TR_PROC_PROC_COLLECTION_H
Parameters
Name
Type
Mode
Definition
TRIGGER "STCW"."TR_PROC_PROC_COLLECTION_H" AFTER INSERT OR UPDATE OR DELETE ON PROCESS_PROCESS_COLLECTION REFERENCING OLD AS early NEW AS late FOR EACH row DECLARE action VARCHAR2(75); BEGIN IF INSERTING THEN action := 'INSERTING'; INSERT INTO STCW_HISTORY.PROCESS_PROCESS_COLLECTION_H(PROCESS_COLLECTION_ID, process_id, PROCESS_PROCESS_COLLECTION_ID, action ) VALUES( :late.PROCESS_COLLECTION_ID,:late.process_id,:late.PROCESS_PROCESS_COLLECTION_ID, action); ELSIF UPDATING THEN action := 'UPDATING'; INSERT INTO STCW_HISTORY.PROCESS_PROCESS_COLLECTION_H(PROCESS_COLLECTION_ID, process_id, PROCESS_PROCESS_COLLECTION_ID, action ) VALUES( :late.PROCESS_COLLECTION_ID,:late.process_id,:late.PROCESS_PROCESS_COLLECTION_ID, action); ELSE action := 'DELETING'; INSERT INTO STCW_HISTORY.PROCESS_PROCESS_COLLECTION_H(PROCESS_COLLECTION_ID, process_id, PROCESS_PROCESS_COLLECTION_ID, action ) VALUES( :early.PROCESS_COLLECTION_ID,:early.process_id,:early.PROCESS_PROCESS_COLLECTION_ID, action); END IF; END;