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