stcwp
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
STCW.TR_LEGAL_ENTITY_H
Parameters
Name
Type
Mode
Definition
TRIGGER "STCW"."TR_LEGAL_ENTITY_H" AFTER INSERT OR UPDATE OR DELETE ON LEGAL_ENTITY 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_ENTITY_H(LEGAL_ENTITY_ID,ABBREVIATION,ADDRESS,CERTIFICATES_ENDORSEMENTS,DIPLOMAS_TAB,COC_TAB,ENDORSEMENTS_TAB,COPS_TAB,OTHER_TAB,COUNTRY_ID,DESCRIPTION, EMAIL,ENUM_LEGAL_ENTITY_ID,FAX,MAIN_RESPONSIBILITIES,NAME,PHONE,QUALITY_STANDARDS_SYSTEM,STRUCTURE,ENUM_STATUS_ID,VERSION_ID,CUSER,CDATE, MUSER,MDATE, action ) VALUES(:late.LEGAL_ENTITY_ID, :late.ABBREVIATION,:late.ADDRESS, :late.CERTIFICATES_ENDORSEMENTS, :late.DIPLOMAS_TAB, :late.COC_TAB, :late.ENDORSEMENTS_TAB, :late.COPS_TAB, :late.OTHER_TAB, :late.COUNTRY_ID,:late.DESCRIPTION,:late.EMAIL, :late.ENUM_LEGAL_ENTITY_ID,:late.FAX,:late.MAIN_RESPONSIBILITIES,:late.NAME,:late.PHONE, :late.QUALITY_STANDARDS_SYSTEM,:late.STRUCTURE,: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.LEGAL_ENTITY_H(LEGAL_ENTITY_ID,ABBREVIATION,ADDRESS,CERTIFICATES_ENDORSEMENTS,DIPLOMAS_TAB,COC_TAB,ENDORSEMENTS_TAB,COPS_TAB,OTHER_TAB,COUNTRY_ID,DESCRIPTION, EMAIL,ENUM_LEGAL_ENTITY_ID,FAX,MAIN_RESPONSIBILITIES,NAME,PHONE,QUALITY_STANDARDS_SYSTEM,STRUCTURE,ENUM_STATUS_ID,VERSION_ID,CUSER,CDATE, MUSER,MDATE, action ) VALUES(:late.LEGAL_ENTITY_ID, :late.ABBREVIATION,:late.ADDRESS, :late.CERTIFICATES_ENDORSEMENTS, :late.DIPLOMAS_TAB, :late.COC_TAB, :late.ENDORSEMENTS_TAB, :late.COPS_TAB, :late.OTHER_TAB, :late.COUNTRY_ID,:late.DESCRIPTION,:late.EMAIL, :late.ENUM_LEGAL_ENTITY_ID,:late.FAX,:late.MAIN_RESPONSIBILITIES,:late.NAME,:late.PHONE, :late.QUALITY_STANDARDS_SYSTEM,:late.STRUCTURE,:late.ENUM_STATUS_ID, :late.VERSION_ID,:late.CUSER,:late.CDATE,:late.MUSER,:late.MDATE, action); ELSE action := 'DELETING'; INSERT INTO STCW_HISTORY.LEGAL_ENTITY_H(LEGAL_ENTITY_ID,ABBREVIATION,ADDRESS,CERTIFICATES_ENDORSEMENTS,DIPLOMAS_TAB,COC_TAB,ENDORSEMENTS_TAB,COPS_TAB,OTHER_TAB,COUNTRY_ID,DESCRIPTION, EMAIL,ENUM_LEGAL_ENTITY_ID,FAX,MAIN_RESPONSIBILITIES,NAME,PHONE,QUALITY_STANDARDS_SYSTEM,STRUCTURE,ENUM_STATUS_ID,VERSION_ID,CUSER,CDATE, MUSER,MDATE, action ) VALUES(:early.LEGAL_ENTITY_ID, :early.ABBREVIATION,:early.ADDRESS, :early.CERTIFICATES_ENDORSEMENTS,:early.DIPLOMAS_TAB, :early.COC_TAB, :early.ENDORSEMENTS_TAB, :early.COPS_TAB, :early.OTHER_TAB,:early.COUNTRY_ID,:early.DESCRIPTION,:early.EMAIL, :early.ENUM_LEGAL_ENTITY_ID,:early.FAX,:early.MAIN_RESPONSIBILITIES,:early.NAME,:early.PHONE, :early.QUALITY_STANDARDS_SYSTEM,:early.STRUCTURE,:early.ENUM_STATUS_ID, :early.VERSION_ID,:early.CUSER,:early.CDATE,:early.MUSER,:early.MDATE, action); END IF; END;