stcwp
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
STCW.TR_FINDING_H
Parameters
Name
Type
Mode
Definition
TRIGGER "STCW"."TR_FINDING_H" AFTER INSERT OR UPDATE OR DELETE ON FINDING REFERENCING OLD AS early NEW AS late FOR EACH row DECLARE action VARCHAR2(75); BEGIN IF INSERTING THEN action := 'INSERTING'; INSERT INTO STCW_HISTORY.FINDING_H (FINDING_ID,COMENT,CORRECTED,CORRECTIVE_ACTIONS,DEADLINE, ENUM_FINDING_TYPE_ID,INSPECTION_LEGAL_ENTITY_ID,MEASURE,SECTION_REPORT,ENUM_STATUS_ID, VERSION_ID,CUSER,CDATE, MUSER,MDATE,LEGAL_REQUIREMENT_PROCESS_ID, action) VALUES(:late.FINDING_ID,:late.COMENT,:late.CORRECTED, :late.CORRECTIVE_ACTIONS, :late.DEADLINE,:late.ENUM_FINDING_TYPE_ID,:late.INSPECTION_LEGAL_ENTITY_ID,:late.MEASURE, :late.SECTION_REPORT, :late.ENUM_STATUS_ID,:late.VERSION_ID,:late.CUSER,:late.CDATE,:late.MUSER,:late.MDATE,:late.LEGAL_REQUIREMENT_PROCESS_ID, action); ELSIF UPDATING THEN action := 'UPDATING'; INSERT INTO STCW_HISTORY.FINDING_H (FINDING_ID,COMENT,CORRECTED,CORRECTIVE_ACTIONS,DEADLINE, ENUM_FINDING_TYPE_ID,INSPECTION_LEGAL_ENTITY_ID,MEASURE,SECTION_REPORT,ENUM_STATUS_ID, VERSION_ID,CUSER,CDATE, MUSER,MDATE,LEGAL_REQUIREMENT_PROCESS_ID, action) VALUES(:late.FINDING_ID,:late.COMENT,:late.CORRECTED, :late.CORRECTIVE_ACTIONS, :late.DEADLINE,:late.ENUM_FINDING_TYPE_ID,:late.INSPECTION_LEGAL_ENTITY_ID,:late.MEASURE, :late.SECTION_REPORT, :late.ENUM_STATUS_ID,:late.VERSION_ID,:late.CUSER,:late.CDATE,:late.MUSER,:late.MDATE,:late.LEGAL_REQUIREMENT_PROCESS_ID, action); ELSE action := 'DELETING'; INSERT INTO STCW_HISTORY.FINDING_H (FINDING_ID,COMENT,CORRECTED,CORRECTIVE_ACTIONS,DEADLINE, ENUM_FINDING_TYPE_ID,INSPECTION_LEGAL_ENTITY_ID,MEASURE,SECTION_REPORT,ENUM_STATUS_ID, VERSION_ID,CUSER,CDATE, MUSER,MDATE,LEGAL_REQUIREMENT_PROCESS_ID, action) VALUES(:early.FINDING_ID,:early.COMENT,:early.CORRECTED, :early.CORRECTIVE_ACTIONS, :early.DEADLINE,:early.ENUM_FINDING_TYPE_ID,:early.INSPECTION_LEGAL_ENTITY_ID,:early.MEASURE, :early.SECTION_REPORT, :early.ENUM_STATUS_ID,:early.VERSION_ID,:early.CUSER,:early.CDATE,:early.MUSER,:early.MDATE,:early.LEGAL_REQUIREMENT_PROCESS_ID, action); END IF; END;