stcwp
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
STCW.TR_INSPECTION_MDATE
Parameters
Name
Type
Mode
Definition
TRIGGER "STCW"."TR_INSPECTION_MDATE" BEFORE INSERT OR UPDATE OF INSPECTION_ID, ASSESSMENT, START_DATE, COUNTRY_ID, END_DATE, FINAL_REPORT_DATE, ENUM_STATUS_ID, PROCESS_COLLECTION_ID, PROCESS_COLLECTION_MET_ID, VERSION_ID ON INSPECTION FOR EACH ROW BEGIN :new."MDATE" := SYSTIMESTAMP; END;