APPS.XDP_DRC_UTIL_PVT dependencies on XDP_FULFILL_WORKLIST

Line 192: XDP_FULFILL_WORKLIST

188: Begin
189: select 'N' into lv_done
190: from dual
191: where exists( select 'x' from
192: XDP_FULFILL_WORKLIST
193: where line_item_id = lv_line_id and
194: status_code = 'ERROR');
195: exception
196: when no_data_found then

Line 311: XDP_FULFILL_WORKLIST fwt

307: wfg.fulfillment_action_id,
308: wfg.provisioning_seq
309: from
310: xdp_wi_fa_mapping wfg,
311: XDP_FULFILL_WORKLIST fwt
312: where
313: fwt.workitem_id = wfg.workitem_id and
314: fwt.workitem_instance_id = p_workitem_instance_id
315: order by wfg.provisioning_seq;

Line 352: XDP_FULFILL_WORKLIST fwt

348: lv_wi,
349: lv_line_item_id
350: from
351: xdp_workitems wim,
352: XDP_FULFILL_WORKLIST fwt
353: where
354: wim.workitem_id = fwt.workitem_id and
355: fwt.workitem_instance_id = p_workitem_instance_id;
356:

Line 389: UPDATE XDP_FULFILL_WORKLIST

385: p_object_key => p_workitem_instance_id,
386: p_message_name => 'XDP_WI_PROV_ERROR',
387: p_message_parameters => x_parameters);
388:
389: UPDATE XDP_FULFILL_WORKLIST
390: set status_code = 'ERROR',
391: -- error_ref_id = lv_ref_id,
392: last_update_date = sysdate,
393: last_updated_by = FND_GLOBAL.USER_ID,

Line 423: UPDATE XDP_FULFILL_WORKLIST

419: p_object_key => p_workitem_instance_id,
420: p_message_name => 'XDP_WI_PROV_ERROR',
421: p_message_parameters => x_parameters);
422:
423: UPDATE XDP_FULFILL_WORKLIST
424: set status_code = 'ERROR',
425: -- error_ref_id = lv_ref_id,
426: last_update_date = sysdate,
427: last_updated_by = FND_GLOBAL.USER_ID,

Line 447: update XDP_FULFILL_WORKLIST

443: end if;
444: end loop;
445:
446: IF lv_fa_fail = TRUE THEN
447: update XDP_FULFILL_WORKLIST
448: set status_code = 'ERROR',
449: state = 'COMPLETED',
450: last_update_date = sysdate,
451: last_updated_by = FND_GLOBAL.USER_ID,

Line 455: update XDP_FULFILL_WORKLIST

451: last_updated_by = FND_GLOBAL.USER_ID,
452: last_update_login = FND_GLOBAL.LOGIN_ID
453: where workitem_instance_id = p_workitem_instance_id;
454: ELSE
455: update XDP_FULFILL_WORKLIST
456: set status_code = 'COMPLETED',
457: state = 'COMPLETED',
458: last_update_date = sysdate,
459: last_updated_by = FND_GLOBAL.USER_ID,

Line 489: UPDATE XDP_FULFILL_WORKLIST

485: p_object_key => p_workitem_instance_id,
486: p_message_name => 'XDP_WI_PROV_ERROR',
487: p_message_parameters => x_parameters);
488:
489: UPDATE XDP_FULFILL_WORKLIST
490: set status_code = 'ERROR',
491: state = 'COMPLETED',
492: last_update_date = sysdate,
493: last_updated_by = FND_GLOBAL.USER_ID,

Line 554: XDP_FULFILL_WORKLIST fwt

550: lv_fa_id,
551: lv_line_item_id
552: from XDP_FULFILL_ACTIONS fan,
553: xdp_fa_runtime_list frt,
554: XDP_FULFILL_WORKLIST fwt
555: where
556: fan.fulfillment_action_id = frt.fulfillment_action_id and
557: fwt.workitem_instance_id = frt.workitem_instance_id and
558: frt.fa_instance_id = p_fa_instance_id;