APPS.XDP_ENGINE dependencies on XDP_FULFILL_WORKLIST

Line 518: XDP_FULFILL_WORKLIST

514: provisioning_date
515: into
516: lv_prov_date
517: from
518: XDP_FULFILL_WORKLIST
519: where
520: workitem_instance_id = p_wi_instance_id;
521:
522: return lv_prov_date;

Line 546: from XDP_FULFILL_WORKLIST

542: p_error_description OUT NOCOPY VARCHAR2)
543: IS
544: cursor c_update_prov_date is
545: select status_code status
546: from XDP_FULFILL_WORKLIST
547: where workitem_instance_id = p_wi_instance_id
548: for update of provisioning_date nowait;
549:
550: e_InvalidWIStatusException exception;

Line 561: update XDP_FULFILL_WORKLIST

557:
558: FOR v_update_prov_date in c_update_prov_date LOOP
559: if v_update_prov_date.status NOT in ('IN PROGRESS','SUCCESS','SUCCESS_WITH_OVERRIDE','CANCELED') then
560:
561: update XDP_FULFILL_WORKLIST
562: set last_updated_by = FND_GLOBAL.USER_ID,
563: last_update_date = sysdate,
564: last_update_login = FND_GLOBAL.LOGIN_ID,
565: provisioning_date = p_prov_date

Line 893: XDP_FULFILL_WORKLIST fwt

889: frt.fulfillment_action_id
890: from
891: xdp_fa_runtime_list frt,
892: xdp_fa_parameters fpr,
893: XDP_FULFILL_WORKLIST fwt
894: where
895: frt.fa_instance_id = p_fa_instance_id and
896: frt.workitem_instance_id = fwt.workitem_instance_id and
897: frt.fulfillment_action_id = fpr.fulfillment_action_id and

Line 1604: XDP_FULFILL_WORKLIST fwt,

1600: fwt.line_number,
1601: fwt.provisioning_date,
1602: NVL(fwt.error_ref_id,0) error_ref_id
1603: from
1604: XDP_FULFILL_WORKLIST fwt,
1605: xdp_workitems wim
1606: where
1607: fwt.order_id = p_sdp_order_id and
1608: fwt.workitem_id = wim.workitem_id;

Line 2179: xdp_fulfill_worklist fw,

2175: cursor c_GetLatestWiParam is
2176: SELECT parameter_value
2177: FROM
2178: xdp_worklist_details wd,
2179: xdp_fulfill_worklist fw,
2180: xdp_wi_parameters wp
2181: WHERE FW.line_item_id=p_line_item_id
2182: AND FW.workitem_instance_id = wd.workitem_instance_id
2183: AND wd.workitem_id = wp.workitem_id

Line 2533: xdp_fulfill_worklist

2529: IF l_workitem_id IS NULL THEN
2530: SELECT
2531: workitem_id INTO l_workitem_id
2532: FROM
2533: xdp_fulfill_worklist
2534: WHERE
2535: workitem_instance_id = p_wi_instance_id;
2536: END IF;
2537: INSERT INTO xdp_worklist_details

Line 2669: from XDP_FULFILL_WORKLIST

2665: begin
2666: if (p_line_item_id IS NULL) OR (lv_order_id IS NULL) then
2667: select order_id,line_item_id
2668: into lv_order_id, lv_line_item_id
2669: from XDP_FULFILL_WORKLIST
2670: where workitem_instance_id = p_wi_instance_id;
2671: else
2672: lv_order_id := p_order_id;
2673: lv_line_item_id := p_line_item_id;

Line 2779: FROM xdp_order_line_items oli, xdp_fulfill_worklist fwl

2775: -- context in case of wi parameter evaluation failure..
2776:
2777: CURSOR c_getWFData IS
2778: SELECT oli.wf_item_type, oli.wf_item_key
2779: FROM xdp_order_line_items oli, xdp_fulfill_worklist fwl
2780: WHERE oli.line_item_id = fwl.line_item_id
2781: AND fwl.workitem_instance_id = p_wi_instance_id;
2782:
2783: BEGIN

Line 2910: XDP_FULFILL_WORKLIST fwt,

2906:
2907: CURSOR c_GetOrderData is
2908: select order_id, frt.workitem_instance_id,fwt.line_item_id
2909: from
2910: XDP_FULFILL_WORKLIST fwt,
2911: xdp_fa_runtime_list frt
2912: where
2913: fwt.workitem_instance_id = frt.workitem_instance_id and
2914: frt.fa_instance_id = p_fa_instance_id;

Line 3356: xdp_fulfill_worklist xfw,

3352: xfw.workitem_id,
3353: wpr.evaluation_procedure,
3354: wpr.evaluation_mode
3355: FROM
3356: xdp_fulfill_worklist xfw,
3357: xdp_wi_parameters wpr
3358: WHERE
3359: xfw.workitem_instance_id = p_wi_instance_id
3360: AND xfw.workitem_id = wpr.workitem_id