APPS.XDP_ORDER_SYNC dependencies on XDP_FA_RUNTIME_LIST

Line 125: UPDATE xdp_fa_runtime_list

121:
122: BEGIN
123: IF p_status IN ('IN PROGRESS','ERROR') THEN
124:
125: UPDATE xdp_fa_runtime_list
126: SET status_code = p_status ,
127: last_update_date = sysdate,
128: last_updated_by = fnd_global.user_id,
129: last_update_login = fnd_global.login_id

Line 132: UPDATE xdp_fa_runtime_list

128: last_updated_by = fnd_global.user_id,
129: last_update_login = fnd_global.login_id
130: WHERE fa_instance_id = p_fa_instance_id ;
131: ELSE
132: UPDATE xdp_fa_runtime_list
133: SET status_code = p_status ,
134: completion_date = sysdate ,
135: last_update_date = sysdate,
136: last_updated_by = fnd_global.user_id,

Line 326: FROM xdp_fa_runtime_list

322: ORDER BY wfg.provisioning_seq;
323:
324: CURSOR lc_fa_list IS
325: SELECT fa_instance_id
326: FROM xdp_fa_runtime_list
327: WHERE
328: workitem_instance_id = p_workitem_instance_id
329: ORDER BY provisioning_sequence;
330:

Line 385: -- populate xdp_fa_runtime_list

381: wim.workitem_id = fwt.workitem_id AND
382: fwt.workitem_instance_id = p_workitem_instance_id;
383:
384: IF lv_type = 'STATIC' THEN
385: -- populate xdp_fa_runtime_list
386: FOR lv_fa_rec IN lc_fa_map LOOP
387: lv_fa_id := XDP_ENG_UTIL.Add_FA_toWI(
388: p_wi_instance_id => p_workitem_instance_id,
389: p_fulfillment_action_id => lv_fa_rec.fulfillment_action_id);

Line 392: -- populate xdp_fa_runtime_list with its dynamic mapping procedure

388: p_wi_instance_id => p_workitem_instance_id,
389: p_fulfillment_action_id => lv_fa_rec.fulfillment_action_id);
390: END LOOP;
391: ELSIF lv_type = 'DYNAMIC' then
392: -- populate xdp_fa_runtime_list with its dynamic mapping procedure
393: IF lv_proc IS NOT NULL THEN
394: XDP_UTILITIES.CallFAMapProc(
395: p_procedure_name => lv_proc,
396: p_order_id => p_order_id,

Line 691: xdp_fa_runtime_list frt,

687: lv_order_id,
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