stcwp
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
STCW.TR_CERTIF_ENDORSEMENT_MDATE
Parameters
Name
Type
Mode
Definition
TRIGGER "STCW"."TR_CERTIF_ENDORSEMENT_MDATE" BEFORE INSERT OR UPDATE OF CERTIFICATE_ENDORSEMENT_ID, STCW_REFERENCE_ID_1, STCW_REFERENCE_ID_2, STCW_REFERENCE_ID_3, ENUM_CERTIFICATE_TYPE_ID ,LEGAL_ENTITY_ID , DOCUMENT_ID, NAME,VERSION_ID ON CERTIFICATE_ENDORSEMENT FOR EACH ROW BEGIN :new."MDATE" := SYSTIMESTAMP; END;