TRIGGER: APPS.GR_DISPATCH_HISTORY_TG

Source

Description

GR_DISPATCH_HISTORY_TG
AFTER  INSERT ON GR_DISPATCH_HISTORY
FOR EACH ROW

Type

AFTER EACH ROW

Event

INSERT

Column

When

Referencing

REFERENCING NEW AS NEW OLD AS OLD

Body

BEGIN
   IF :new.creation_source <> 0 THEN
      --Call API to send the dispatch history information to 3rd party only if the
      --creation source is 1 - internal application or 2 - form..
      GR_WF_UTIL_PVT.SEND_OUTBOUND_DOCUMENT('GR','GRDDO',:new.dispatch_history_id);
   END IF;
exception
  when OTHERS then
        raise_application_error(-20000,SQLERRM);

END;