stcwp
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
STCW.TR_LEGAL_DOCUMENT_H
Parameters
Name
Type
Mode
Definition
TRIGGER "STCW"."TR_LEGAL_DOCUMENT_H" AFTER INSERT OR UPDATE OR DELETE ON LEGAL_DOCUMENT 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_DOCUMENT_H( LEGAL_DOCUMENT_ID,name,cdate, cuser, description, enum_status_id, mdate, muser, parent_id, start_date, version_id, action) values( :late.LEGAL_DOCUMENT_ID,:late.name, :late.cdate, :late.cuser,:late.description, :late.enum_status_id, :late.mdate, :late.muser, :late.parent_id, :late.start_date,:late.version_id, action); ELSIF UPDATING THEN IF :late.ENUM_STATUS_ID = 2 THEN action := 'DELETING'; ELSE action := 'UPDATING'; END IF; INSERT INTO STCW_HISTORY.LEGAL_DOCUMENT_H( LEGAL_DOCUMENT_ID,name,cdate, cuser, description, enum_status_id, mdate, muser, parent_id, start_date, version_id, action) values( :late.LEGAL_DOCUMENT_ID,:late.name, :late.cdate, :late.cuser,:late.description, :late.enum_status_id, :late.mdate, :late.muser, :late.parent_id, :late.start_date,:late.version_id, action); ELSE action := 'DELETING'; INSERT INTO STCW_HISTORY.LEGAL_DOCUMENT_H( LEGAL_DOCUMENT_ID,name,cdate, cuser, description, enum_status_id, mdate, muser, parent_id, start_date, version_id, action) values( :early.LEGAL_DOCUMENT_ID,:early.name, :early.cdate, :early.cuser,:early.description, :early.enum_status_id, :early.mdate, :early.muser, :early.parent_id, :early.start_date,:early.version_id, action); END IF; END;