<?xml version = '1.0' encoding = 'UTF-8'?>
<TriggerOraclev10g class="oracle.dbtools.crest.model.design.storage.oracle.v10g.TriggerOraclev10g" name="OUTBOUND_NCPDP_MSG_TRG" directorySegmentName="seg_0" id="3AC31774-799A-EFFA-30BF-5C4034C29FA9">
<sourceConnName>local_erx</sourceConnName>
<sourceObjSchema>ERX</sourceObjSchema>
<sourceObjName>OUTBOUND_NCPDP_MSG_TRG</sourceObjName>
<createdBy>DNS   WandlJ</createdBy>
<createdTime>2016-07-06 19:35:04 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<actions>INSERT, UPDATE</actions>
<body>BEGIN &lt;br/&gt;IF UPDATING THEN&lt;br/&gt;  :NEW.UPDATE_DATE := SYSDATE;&lt;br/&gt;ELSE&lt;br/&gt;  :NEW.CREATED_DATE := SYSDATE;&lt;br/&gt;    IF :NEW.OUTBOUND_NCPDP_MSG_ID IS NULL THEN&lt;br/&gt;    :NEW.OUTBOUND_NCPDP_MSG_ID := OUTBOUND_NCPDP_MSG_ID_SEQ.NEXTVAL;&lt;br/&gt;    END IF;&lt;br/&gt;END IF;&lt;br/&gt;END;</body>
<triggerTime>BEFORE</triggerTime>
<owner>D9046BB6-4F49-0E5D-466F-6A8BD6405589</owner>
<table>EB9BFD57-8E77-797F-7F33-95F4931FBDAA</table>
</TriggerOraclev10g>