APPS.XDPCORE_FA dependencies on XDP_ADAPTER_JOB_QUEUE

Line 205: insert into XDP_ADAPTER_JOB_QUEUE (

201: l_ReProcessEnqTime := SYSDATE;
202: end if;
203:
204:
205: insert into XDP_ADAPTER_JOB_QUEUE (
206: JOB_ID,
207: FE_ID,
208: ORDER_ID,
209: WORKITEM_INSTANCE_ID,

Line 222: values (XDP_ADAPTER_JOB_QUEUE_S.NEXTVAL,

218: last_updated_by,
219: last_update_date,
220: last_update_login
221: )
222: values (XDP_ADAPTER_JOB_QUEUE_S.NEXTVAL,
223: l_FeID,
224: l_OrderID,
225: l_WIInstanceID,
226: l_FAInstanceID,

Line 3658: from XDP_ADAPTER_JOB_QUEUE

3654: is
3655:
3656: cursor c_AdapterJobQueue(p_FeID number, p_ChannelUsageCode varchar2) is
3657: select ROWID
3658: from XDP_ADAPTER_JOB_QUEUE
3659: where FE_ID = p_FeID
3660: and channel_usage_code = p_ChannelUsageCode
3661: and SYSTEM_HOLD = 'N'
3662: order by QUEUED_ON ASC;

Line 3799: from XDP_ADAPTER_JOB_QUEUE

3795: */
3796: BEGIN
3797: select WF_ITEM_TYPE, WF_ITEM_KEY, ROWID, ORDER_ID, WORKITEM_INSTANCE_ID, FA_INSTANCE_ID
3798: into l_New_itemtype, l_New_itemkey, l_rowID, l_OrderID, l_WIInstanceID, l_FAInstanceID
3799: from XDP_ADAPTER_JOB_QUEUE
3800: where ROWID = idarr(i)
3801: for update NOWAIT;
3802:
3803: /* Check if the FA Waiting has been CANCELED

Line 3814: delete from XDP_ADAPTER_JOB_QUEUE

3810: GOTO l_EndofLoop;
3811: else
3812: eligible := FALSE;
3813:
3814: delete from XDP_ADAPTER_JOB_QUEUE
3815: where ROWID = l_rowid;
3816: end if;
3817:
3818: EXCEPTION

Line 3839: delete from XDP_ADAPTER_JOB_QUEUE

3835: BEGIN
3836:
3837: SAVEPOINT HandOverPoint;
3838:
3839: delete from XDP_ADAPTER_JOB_QUEUE
3840: where ROWID = l_rowid;
3841:
3842: /* Need to Enqueue in the AQ */
3843:

Line 4007: from XDP_ADAPTER_JOB_QUEUE

4003: is
4004:
4005: cursor c_AdapterJobQueue(p_FeID number, p_ChannelUsageCode varchar2) is
4006: select ROWID
4007: from XDP_ADAPTER_JOB_QUEUE
4008: where FE_ID = p_FeID
4009: and channel_usage_code = p_ChannelUsageCode
4010: and SYSTEM_HOLD = 'N'
4011: order by QUEUED_ON ASC;

Line 4158: from XDP_ADAPTER_JOB_QUEUE

4154: */
4155: BEGIN
4156: select WF_ITEM_TYPE, WF_ITEM_KEY, ROWID, ORDER_ID, WORKITEM_INSTANCE_ID, FA_INSTANCE_ID
4157: into l_New_itemtype, l_New_itemkey, l_rowID, l_OrderID, l_WIInstanceID, l_FAInstanceID
4158: from XDP_ADAPTER_JOB_QUEUE
4159: where ROWID = idarr(i)
4160: for update NOWAIT;
4161:
4162: /* Check if the FA Waiting has been CANCELED

Line 4173: delete from XDP_ADAPTER_JOB_QUEUE

4169: GOTO l_EndofLoop;
4170: else
4171: eligible := FALSE;
4172:
4173: delete from XDP_ADAPTER_JOB_QUEUE
4174: where ROWID = l_rowid;
4175: end if;
4176:
4177: EXCEPTION

Line 4198: delete from XDP_ADAPTER_JOB_QUEUE

4194: BEGIN
4195:
4196: SAVEPOINT HandOverPoint;
4197:
4198: delete from XDP_ADAPTER_JOB_QUEUE
4199: where ROWID = l_rowid;
4200:
4201: /* Need to Enqueue in the AQ */
4202:

Line 5546: UPDATE xdp_adapter_job_queue

5542: -- with System Hold status 'Y' then update them to 'N' so that they
5543: -- will be picked up in Handover Process..
5544: IF (lv_error_count > lv_error_threshold) THEN
5545: -- reset System Hold to 'N' so that adapter will pick it up..
5546: UPDATE xdp_adapter_job_queue
5547: SET system_hold = 'N',
5548: last_updated_by = FND_GLOBAL.USER_ID,
5549: last_update_date = sysdate,
5550: last_update_login = FND_GLOBAL.USER_ID