stcwp
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
STCW.TR_INSPECTION_H
Parameters
Name
Type
Mode
Definition
TRIGGER "STCW"."TR_INSPECTION_H" AFTER INSERT OR UPDATE OR DELETE ON INSPECTION 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_H(INSPECTION_ID,ASSESSMENT,START_DATE,END_DATE, FINAL_REPORT_DATE,PROCESS_COLLECTION_ID,PROCESS_COLLECTION_MET_ID,ENUM_STATUS_ID, VERSION_ID,CUSER,CDATE,MUSER,MDATE,COUNTRY_ID, action) VALUES(:late.INSPECTION_ID,:late.ASSESSMENT,:late.START_DATE,:late.END_DATE,:late.FINAL_REPORT_DATE,:late.PROCESS_COLLECTION_ID,:late.PROCESS_COLLECTION_MET_ID,:late.ENUM_STATUS_ID, :late.VERSION_ID,:late.CUSER,:late.CDATE,:late.MUSER,:late.MDATE,:late.COUNTRY_ID, action); ELSIF UPDATING THEN IF :late.ENUM_STATUS_ID = 2 THEN action := 'DELETING'; ELSE action := 'UPDATING'; END IF; INSERT INTO STCW_HISTORY.INSPECTION_H(INSPECTION_ID,ASSESSMENT,START_DATE,END_DATE, FINAL_REPORT_DATE,PROCESS_COLLECTION_ID,PROCESS_COLLECTION_MET_ID,ENUM_STATUS_ID, VERSION_ID,CUSER,CDATE,MUSER,MDATE,COUNTRY_ID, action) VALUES(:late.INSPECTION_ID,:late.ASSESSMENT,:late.START_DATE,:late.END_DATE,:late.FINAL_REPORT_DATE,:late.PROCESS_COLLECTION_ID,:late.PROCESS_COLLECTION_MET_ID,:late.ENUM_STATUS_ID, :late.VERSION_ID,:late.CUSER,:late.CDATE,:late.MUSER,:late.MDATE,:late.COUNTRY_ID, action); ELSE action := 'DELETING'; INSERT INTO STCW_HISTORY.INSPECTION_H(INSPECTION_ID,ASSESSMENT,START_DATE,END_DATE, FINAL_REPORT_DATE,PROCESS_COLLECTION_ID,PROCESS_COLLECTION_MET_ID,ENUM_STATUS_ID, VERSION_ID,CUSER,CDATE,MUSER,MDATE,COUNTRY_ID, action) VALUES(:early.INSPECTION_ID,:early.ASSESSMENT,:early.START_DATE,:early.END_DATE,:early.FINAL_REPORT_DATE,:early.PROCESS_COLLECTION_ID,:early.PROCESS_COLLECTION_MET_ID,:early.ENUM_STATUS_ID, :early.VERSION_ID,:early.CUSER,:early.CDATE,:early.MUSER,:early.MDATE,:early.COUNTRY_ID, action); END IF; END;