APPS.XDP_ORDER_SYNC dependencies on XDP_FULFILL_WORKLIST

Line 94: UPDATE xdp_fulfill_worklist

90:
91: BEGIN
92: IF p_status IN ('IN PROGRESS','ERROR') THEN
93:
94: UPDATE xdp_fulfill_worklist
95: SET status_code = p_status ,
96: last_update_date = sysdate,
97: last_updated_by = fnd_global.user_id,
98: last_update_login = fnd_global.login_id

Line 101: UPDATE xdp_fulfill_worklist

97: last_updated_by = fnd_global.user_id,
98: last_update_login = fnd_global.login_id
99: WHERE workitem_instance_id = p_workitem_instance_id ;
100: ELSE
101: UPDATE xdp_fulfill_worklist
102: SET status_code = p_status ,
103: completion_date = sysdate ,
104: last_update_date = sysdate,
105: last_updated_by = fnd_global.user_id,

Line 253: (SELECT workitem_instance_id FROM xdp_fulfill_worklist

249:
250:
251: -- Execute all workitems in sequence
252: FOR c_workitem_instance in
253: (SELECT workitem_instance_id FROM xdp_fulfill_worklist
254: WHERE line_item_id=p_lineItem_id order by wi_sequence)
255: LOOP
256: Execute_Workitem_Sync(
257: p_order_id => p_order_id,

Line 276: XDP_FULFILL_WORKLIST

272: -- Check if any workitem was in error status
273: BEGIN
274: SELECT 'N' INTO lv_done FROM dual
275: WHERE EXISTS( SELECT 'x' FROM
276: XDP_FULFILL_WORKLIST
277: WHERE line_item_id = p_lineItem_id AND
278: status_code = 'ERROR');
279: EXCEPTION
280: WHEN no_data_found THEN

Line 318: XDP_FULFILL_WORKLIST fwt

314: wfg.fulfillment_action_id,
315: wfg.provisioning_seq
316: FROM
317: xdp_wi_fa_mapping wfg,
318: XDP_FULFILL_WORKLIST fwt
319: WHERE
320: fwt.workitem_id = wfg.workitem_id and
321: fwt.workitem_instance_id = p_workitem_instance_id
322: ORDER BY wfg.provisioning_seq;

Line 379: xdp_fulfill_worklist fwt

375: lv_user_wf_process,
376: lv_user_wi_proc
377: FROM
378: xdp_workitems wim,
379: xdp_fulfill_worklist fwt
380: WHERE
381: wim.workitem_id = fwt.workitem_id AND
382: fwt.workitem_instance_id = p_workitem_instance_id;
383:

Line 507: UPDATE XDP_FULFILL_WORKLIST

503: END IF;
504: RAISE e_exec_wi_failure;
505: END IF;
506:
507: UPDATE XDP_FULFILL_WORKLIST
508: SET WF_ITEM_TYPE = lv_user_item_type,
509: WF_ITEM_KEY = lv_user_item_key,
510: LAST_UPDATE_DATE = SYSDATE, LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
511: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

Line 553: update XDP_FULFILL_WORKLIST

549: LineitemID => p_lineitem_id,
550: WIInstanceID => p_workitem_instance_id,
551: FAInstanceID => null);
552:
553: update XDP_FULFILL_WORKLIST
554: set WF_ITEM_TYPE = lv_user_item_type,
555: WF_ITEM_KEY = lv_user_item_key,
556: LAST_UPDATE_DATE = sysdate,
557: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

Line 692: XDP_FULFILL_WORKLIST fwt

688: lv_fa_id,
689: lv_line_item_id
690: FROM XDP_FULFILL_ACTIONS fan,
691: xdp_fa_runtime_list frt,
692: XDP_FULFILL_WORKLIST fwt
693: WHERE
694: fan.fulfillment_action_id = frt.fulfillment_action_id and
695: fwt.workitem_instance_id = frt.workitem_instance_id and
696: frt.fa_instance_id = p_fa_instance_id;