stcwp
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
STCW.TR_PROCESS_H
Parameters
Name
Type
Mode
Definition
TRIGGER "STCW"."TR_PROCESS_H" AFTER INSERT OR UPDATE OR DELETE ON PROCESS REFERENCING OLD AS early NEW AS late FOR EACH row DECLARE action VARCHAR2(75); BEGIN IF INSERTING THEN action := 'INSERTING'; INSERT INTO STCW_HISTORY.PROCESS_H( PROCESS_ID, DESCRIPTION, END_DATE,START_DATE, NAME, ENUM_STATUS_ID, VERSION_ID,CUSER,CDATE, MUSER,MDATE, ENUM_LEGAL_ENTITY_ID, action) VALUES( :late.PROCESS_ID, :late.DESCRIPTION, :late.END_DATE, :late.START_DATE, :late.NAME, :late.ENUM_STATUS_ID,:late.VERSION_ID, :late.CUSER, :late.CDATE, :late.MUSER, :late.MDATE, :late.ENUM_LEGAL_ENTITY_ID, action); ELSIF UPDATING THEN action := 'UPDATING'; INSERT INTO STCW_HISTORY.PROCESS_H( PROCESS_ID, DESCRIPTION, END_DATE,START_DATE, NAME, ENUM_STATUS_ID, VERSION_ID,CUSER,CDATE, MUSER,MDATE, ENUM_LEGAL_ENTITY_ID, action) VALUES( :late.PROCESS_ID, :late.DESCRIPTION, :late.END_DATE, :late.START_DATE, :late.NAME, :late.ENUM_STATUS_ID,:late.VERSION_ID, :late.CUSER, :late.CDATE, :late.MUSER, :late.MDATE, :late.ENUM_LEGAL_ENTITY_ID, action); ELSE action := 'DELETING'; INSERT INTO STCW_HISTORY.PROCESS_H( PROCESS_ID, DESCRIPTION, END_DATE,START_DATE, NAME, ENUM_STATUS_ID, VERSION_ID,CUSER,CDATE, MUSER,MDATE, ENUM_LEGAL_ENTITY_ID, action) VALUES( :early.PROCESS_ID, :early.DESCRIPTION, :early.END_DATE, :early.START_DATE, :early.NAME, :early.ENUM_STATUS_ID,:early.VERSION_ID, :early.CUSER, :early.CDATE, :early.MUSER, :early.MDATE, :early.ENUM_LEGAL_ENTITY_ID, action); END IF; END;