APPS.XDP_AQ_UTILITIES dependencies on XDP_ADAPTER_JOB_QUEUE

Line 3787: select nvl(min(queued_on), sysdate)-1 into l_ReProcessEnqTime from xdp_adapter_job_queue;

3783: -- Set Dequeue time out to be 1 second
3784: lv_DequeueOptions.wait := 1;
3785: lv_queue_timed_out := 'N';
3786:
3787: select nvl(min(queued_on), sysdate)-1 into l_ReProcessEnqTime from xdp_adapter_job_queue;
3788:
3789: WHILE 1=1 LOOP
3790:
3791: BEGIN

Line 3811: insert into XDP_ADAPTER_JOB_QUEUE (

3807:
3808: select FE_ID into l_FeID from xdp_fes
3809: where fulfillment_element_name = lv_wf_object.FE_NAME;
3810:
3811: insert into XDP_ADAPTER_JOB_QUEUE (
3812: JOB_ID,
3813: FE_ID,
3814: ORDER_ID,
3815: WORKITEM_INSTANCE_ID,

Line 3828: values (XDP_ADAPTER_JOB_QUEUE_S.NEXTVAL,

3824: last_updated_by,
3825: last_update_date,
3826: last_update_login
3827: )
3828: values (XDP_ADAPTER_JOB_QUEUE_S.NEXTVAL,
3829: l_FeID,
3830: lv_wf_object.ORDER_ID,
3831: lv_wf_object.WORKITEM_INSTANCE_ID,
3832: lv_wf_object.FA_INSTANCE_ID,