stcwp
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
STCW.TR_DISPENSATION_MDATE
Parameters
Name
Type
Mode
Definition
TRIGGER "STCW"."TR_DISPENSATION_MDATE" BEFORE INSERT OR UPDATE OF DISPENSATION_ID, COUNTRY_ID, YEAR, N_DISPENSATIONS, STCW_REFERENCE_id ,ENUM_STATUS_ID,VERSION_ID ON DISPENSATION FOR EACH ROW BEGIN :new."MDATE" := SYSTIMESTAMP; END;