stcwp
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
STCW.TR_FRAUDULENT_CERTIF_MDATE
Parameters
Name
Type
Mode
Definition
TRIGGER "STCW"."TR_FRAUDULENT_CERTIF_MDATE" BEFORE INSERT OR UPDATE OF FRAUDULENT_CERTIFICATE_ID, SHIP_FLAG, ENUM_FRAUD_TYPE_ID, ENUM_METHOD_DETECTION_ID, ALLEGED_ISSUING_ENTITY, ENUM_ACTION_TAKEN_ID, OBSERVATION, FRAUDULENT_CERTIFICATE_DATE, STCW_REFERENCE_ID, COUNTRY_ID, ENUM_STATUS_ID, VERSION_ID ON FRAUDULENT_CERTIFICATE FOR EACH ROW BEGIN :new."MDATE" := SYSTIMESTAMP; END;