753: delay :=0;
754: else
755: delay := round((beginning - sysdate)*24*60*60 + 0.5);
756: end if;
757: wf_queue.enqueue_event
758: (queuename=>wf_queue.DeferredQueue,
759: itemtype=> itemtype,
760: itemkey=>create_status.itemkey,
761: actid=>create_status.actid,
754: else
755: delay := round((beginning - sysdate)*24*60*60 + 0.5);
756: end if;
757: wf_queue.enqueue_event
758: (queuename=>wf_queue.DeferredQueue,
759: itemtype=> itemtype,
760: itemkey=>create_status.itemkey,
761: actid=>create_status.actid,
762: delay=>delay,
765: -- msg_id :=null;
766: elsif act_ftype = 'EXTERNAL' then
767: -- this is a callout so write to OUTBOUND queue
768: -- do not set the correlation here for compatibility reason
769: wf_queue.enqueue_event
770: (queuename=>wf_queue.OutboundQueue,
771: itemtype=> create_status.itemtype,
772: itemkey=>create_status.itemkey,
773: actid=>create_status.actid,
766: elsif act_ftype = 'EXTERNAL' then
767: -- this is a callout so write to OUTBOUND queue
768: -- do not set the correlation here for compatibility reason
769: wf_queue.enqueue_event
770: (queuename=>wf_queue.OutboundQueue,
771: itemtype=> create_status.itemtype,
772: itemkey=>create_status.itemkey,
773: actid=>create_status.actid,
774: funcname=>act_fname,
771: itemtype=> create_status.itemtype,
772: itemkey=>create_status.itemkey,
773: actid=>create_status.actid,
774: funcname=>act_fname,
775: paramlist=>wf_queue.get_param_list(itemtype,itemkey,actid),
776: message_handle=>msg_id);
777: else
778: -- this is a callout so write to OUTBOUND queue for other type
779: wf_queue.enqueue_event
775: paramlist=>wf_queue.get_param_list(itemtype,itemkey,actid),
776: message_handle=>msg_id);
777: else
778: -- this is a callout so write to OUTBOUND queue for other type
779: wf_queue.enqueue_event
780: (queuename=>wf_queue.OutboundQueue,
781: itemtype=> create_status.itemtype,
782: itemkey=>create_status.itemkey,
783: actid=>create_status.actid,
776: message_handle=>msg_id);
777: else
778: -- this is a callout so write to OUTBOUND queue for other type
779: wf_queue.enqueue_event
780: (queuename=>wf_queue.OutboundQueue,
781: itemtype=> create_status.itemtype,
782: itemkey=>create_status.itemkey,
783: actid=>create_status.actid,
784: correlation=>act_ftype,
782: itemkey=>create_status.itemkey,
783: actid=>create_status.actid,
784: correlation=>act_ftype,
785: funcname=>act_fname,
786: paramlist=>wf_queue.get_param_list(itemtype,itemkey,actid),
787: message_handle=>msg_id);
788: end if;
789: exception
790: when others then