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