<?xml version = '1.0' encoding = 'UTF-8'?>
<TriggerOraclev10g class="oracle.dbtools.crest.model.design.storage.oracle.v10g.TriggerOraclev10g" name="PHARMACY_TRG" directorySegmentName="seg_0" id="9A3EF0BE-5803-0193-98E3-4F675D2218BC">
<sourceConnName>local_erx</sourceConnName>
<sourceObjSchema>ERX</sourceObjSchema>
<sourceObjName>PHARMACY_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.UPDATED_DATE := SYSDATE;&lt;br/&gt;ELSE&lt;br/&gt;  :NEW.CREATED_DATE := SYSDATE;&lt;br/&gt;   IF :NEW.PHARMACY_ID IS NULL THEN&lt;br/&gt;   :NEW.PHARMACY_ID := PHARMACY_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>8DF392F1-05ED-243E-53A7-2D243934B2CE</table>
</TriggerOraclev10g>