APPS.XDP_DRC_UTIL_PVT dependencies on XDP_FA_RUNTIME_LIST

Line 319: from xdp_fa_runtime_list

315: order by wfg.provisioning_seq;
316:
317: cursor lc_fa_list is
318: select fa_instance_id
319: from xdp_fa_runtime_list
320: where
321: workitem_instance_id = p_workitem_instance_id;
322:
323: lv_proc varchar2(80);

Line 553: xdp_fa_runtime_list frt,

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

Line 588: UPDATE xdp_fa_runtime_list

584: p_object_key => p_fa_instance_id,
585: p_message_name => 'XDP_FA_PROV_ERROR',
586: p_message_parameters => x_parameters);
587:
588: UPDATE xdp_fa_runtime_list
589: set status_code = 'ERROR',
590: state = 'COMPLETED',
591: last_update_date = sysdate,
592: last_updated_by = FND_GLOBAL.USER_ID,

Line 668: UPDATE xdp_fa_runtime_list

664: p_object_key => p_fa_instance_id,
665: p_message_name => 'XDP_NO_TEST_CHANNEL',
666: p_message_parameters => x_parameters);
667:
668: UPDATE xdp_fa_runtime_list
669: set status_code = 'ERROR',
670: state = 'COMPLETED',
671: last_update_date = sysdate,
672: last_updated_by = FND_GLOBAL.USER_ID,

Line 697: UPDATE xdp_fa_runtime_list

693: p_object_key => p_fa_instance_id,
694: p_message_name => 'XDP_TEST_CHANNEL_BUSY',
695: p_message_parameters => x_parameters);
696:
697: UPDATE xdp_fa_runtime_list
698: set status_code = 'ERROR',
699: state = 'COMPLETED',
700: last_update_date = sysdate,
701: last_updated_by = FND_GLOBAL.USER_ID,

Line 724: UPDATE xdp_fa_runtime_list

720: p_fa_item_key => NULL,
721: p_return_code => return_code,
722: p_error_description => error_description);
723: IF return_code = 0 THEN
724: UPDATE xdp_fa_runtime_list
725: set status_code = 'COMPLETED',
726: state = 'COMPLETED',
727: last_update_date = sysdate,
728: last_updated_by = FND_GLOBAL.USER_ID,

Line 752: UPDATE xdp_fa_runtime_list

748: p_object_key => p_fa_instance_id,
749: p_message_name => 'XDP_FA_PROV_ERROR',
750: p_message_parameters => x_parameters);
751:
752: UPDATE xdp_fa_runtime_list
753: set status_code = 'ERROR',
754: state = 'COMPLETED',
755: last_update_date = sysdate,
756: last_updated_by = FND_GLOBAL.USER_ID,

Line 791: UPDATE xdp_fa_runtime_list

787: p_object_key => p_fa_instance_id,
788: p_message_name => 'XDP_FA_PROV_ERROR',
789: p_message_parameters => x_parameters);
790:
791: UPDATE xdp_fa_runtime_list
792: set status_code = 'ERROR',
793: state = 'COMPLETED',
794: last_update_date = sysdate,
795: last_updated_by = FND_GLOBAL.USER_ID,