stcwp
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
STCW.TR_FINDING_MDATE
Parameters
Name
Type
Mode
Definition
TRIGGER "STCW"."TR_FINDING_MDATE" BEFORE INSERT OR UPDATE OF FINDING_ID, COMENT, CORRECTED, ENUM_STATUS_ID, MEASURE, INSPECTION_LEGAL_ENTITY_ID, SECTION_REPORT, CORRECTIVE_ACTIONS, DEADLINE, ENUM_FINDING_TYPE_ID, VERSION_ID ON FINDING FOR EACH ROW BEGIN :new."MDATE" := SYSTIMESTAMP; END;