APPS.XDP_PURGE dependencies on XDP_FULFILL_WORKLIST

Line 222: SELECT COUNT(*) INTO l_no_records FROM XDP_FULFILL_WORKLIST

218:
219: RECORDS_PURGED_MSGS(l_counter,'XDP_LINE_RELATIONSHIPS WHERE LINE_ITEM_ID = '
220: ||c_item.LINE_ITEM_ID,'XDP_FOUND_REC',1);
221:
222: SELECT COUNT(*) INTO l_no_records FROM XDP_FULFILL_WORKLIST
223: WHERE LINE_ITEM_ID = c_item.LINE_ITEM_ID;
224:
225: RECORDS_PURGED_MSGS(l_counter,'XDP_FULFILL_WORKLIST WHERE LINE_ITEM_ID = '
226: ||c_item.LINE_ITEM_ID,'XDP_FOUND_REC',1);

Line 225: RECORDS_PURGED_MSGS(l_counter,'XDP_FULFILL_WORKLIST WHERE LINE_ITEM_ID = '

221:
222: SELECT COUNT(*) INTO l_no_records FROM XDP_FULFILL_WORKLIST
223: WHERE LINE_ITEM_ID = c_item.LINE_ITEM_ID;
224:
225: RECORDS_PURGED_MSGS(l_counter,'XDP_FULFILL_WORKLIST WHERE LINE_ITEM_ID = '
226: ||c_item.LINE_ITEM_ID,'XDP_FOUND_REC',1);
227:
228: IF l_no_records <> 0 THEN
229: FOR c_fw IN (SELECT WORKITEM_INSTANCE_ID FROM XDP_FULFILL_WORKLIST

Line 229: FOR c_fw IN (SELECT WORKITEM_INSTANCE_ID FROM XDP_FULFILL_WORKLIST

225: RECORDS_PURGED_MSGS(l_counter,'XDP_FULFILL_WORKLIST WHERE LINE_ITEM_ID = '
226: ||c_item.LINE_ITEM_ID,'XDP_FOUND_REC',1);
227:
228: IF l_no_records <> 0 THEN
229: FOR c_fw IN (SELECT WORKITEM_INSTANCE_ID FROM XDP_FULFILL_WORKLIST
230: WHERE LINE_ITEM_ID = C_ITEM.LINE_ITEM_ID)
231: LOOP
232: SELECT COUNT(*) INTO l_temp FROM XDP_WI_RELATIONSHIPS
233: WHERE WORKITEM_INSTANCE_ID = c_fw.WORKITEM_INSTANCE_ID;

Line 434: SELECT WORKITEM_INSTANCE_ID FROM XDP_FULFILL_WORKLIST WHERE

430: p_line_item_id IN XDP_ORDER_LINE_ITEMS.LINE_ITEM_ID%TYPE,
431: p_run_mode IN VARCHAR2
432: ) IS
433: CURSOR c_fulfill_worklist IS
434: SELECT WORKITEM_INSTANCE_ID FROM XDP_FULFILL_WORKLIST WHERE
435: line_item_id = p_line_item_id
436: FOR UPDATE NOWAIT;
437:
438: CURSOR c_fulfill_action(p_workitem_instance_id XDP_FULFILL_WORKLIST.WORKITEM_INSTANCE_ID%TYPE) IS

Line 438: CURSOR c_fulfill_action(p_workitem_instance_id XDP_FULFILL_WORKLIST.WORKITEM_INSTANCE_ID%TYPE) IS

434: SELECT WORKITEM_INSTANCE_ID FROM XDP_FULFILL_WORKLIST WHERE
435: line_item_id = p_line_item_id
436: FOR UPDATE NOWAIT;
437:
438: CURSOR c_fulfill_action(p_workitem_instance_id XDP_FULFILL_WORKLIST.WORKITEM_INSTANCE_ID%TYPE) IS
439: SELECT FA_INSTANCE_ID FROM XDP_FA_RUNTIME_LIST
440: WHERE WORKITEM_INSTANCE_ID = p_workitem_instance_id
441: FOR UPDATE NOWAIT;
442:

Line 521: DELETE FROM XDP_FULFILL_WORKLIST

517:
518: DELETE FROM XDP_WORKLIST_DETAILS
519: WHERE WORKITEM_INSTANCE_ID = l_worklist.WORKITEM_INSTANCE_ID;
520:
521: DELETE FROM XDP_FULFILL_WORKLIST
522: WHERE WORKITEM_INSTANCE_ID = l_worklist.WORKITEM_INSTANCE_ID;
523: END IF;
524:
525: l_wi_counter := l_wi_counter+1;

Line 528: RECORDS_PURGED_MSGS(l_wi_counter,'XDP_FULFILL_WORKLIST WHERE LINE_ITEM_ID = '

524:
525: l_wi_counter := l_wi_counter+1;
526:
527: END LOOP;
528: RECORDS_PURGED_MSGS(l_wi_counter,'XDP_FULFILL_WORKLIST WHERE LINE_ITEM_ID = '
529: ||p_line_item_id,l_rec_name,0);
530: EXCEPTION
531: WHEN OTHERS THEN
532: PURGE_ERRORS(SUBSTR(SQLERRM, 1, 512),P_ABORT => TRUE);