/*****************************************************************************
*
* Filename              - hbmd_triggers.sql
*
* Project Name          - UltraTrak Database
*
* Description           - Triggers for HBMD Table
*                         data from both these tables on the same page
*
* Language              - Oracle PL/SQL
*
* File History          - For the development history run the Show History report in PVCS
*
* Copyright Ultra Electronics Airport Systems, 2006
*
*****************************************************************************/

CREATE OR REPLACE TRIGGER ti_hbmd
BEFORE INSERT ON hbmd
FOR EACH ROW
BEGIN

   -- Set ROW_CREATE_TIME if not already set.

   IF :new.row_create_time IS NULL THEN
      :new.row_create_time := SYSDATE;
   END IF;

END;
/

