stcwp
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
STCW.TR_INSPECTION_LEGAL_ENTITY_H
Parameters
Name
Type
Mode
Definition
TRIGGER "STCW"."TR_INSPECTION_LEGAL_ENTITY_H" AFTER INSERT OR UPDATE OR DELETE ON INSPECTION_LEGAL_ENTITY REFERENCING OLD AS early NEW AS late FOR EACH row DECLARE action VARCHAR2(75); BEGIN IF INSERTING THEN action := 'INSERTING'; INSERT INTO STCW_HISTORY.INSPECTION_LEGAL_ENTITY_H(INSPECTION_LEGAL_ENTITY_ID,INSPECTION_ID, LEGAL_ENTITY_ID, VERSION_ID, CUSER, CDATE, MUSER, MDATE, action ) VALUES (:late.INSPECTION_LEGAL_ENTITY_ID, :late.INSPECTION_ID,:late.LEGAL_ENTITY_ID,:late.VERSION_ID,:late.CUSER, :late.CDATE,:late.MUSER,:late.MDATE, action); ELSIF UPDATING THEN action := 'UPDATING'; INSERT INTO STCW_HISTORY.INSPECTION_LEGAL_ENTITY_H(INSPECTION_LEGAL_ENTITY_ID,INSPECTION_ID, LEGAL_ENTITY_ID, VERSION_ID, CUSER, CDATE, MUSER, MDATE, action ) VALUES (:late.INSPECTION_LEGAL_ENTITY_ID, :late.INSPECTION_ID,:late.LEGAL_ENTITY_ID,:late.VERSION_ID,:late.CUSER, :late.CDATE,:late.MUSER,:late.MDATE, action); ELSE action := 'DELETING'; INSERT INTO STCW_HISTORY.INSPECTION_LEGAL_ENTITY_H(INSPECTION_LEGAL_ENTITY_ID,INSPECTION_ID, LEGAL_ENTITY_ID, VERSION_ID, CUSER, CDATE, MUSER, MDATE, action ) VALUES (:early.INSPECTION_LEGAL_ENTITY_ID, :early.INSPECTION_ID,:early.LEGAL_ENTITY_ID,:early.VERSION_ID,:early.CUSER, :early.CDATE,:early.MUSER,:early.MDATE, action); END IF; END;