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