APPS.XDP_PURGE dependencies on XDP_ORDER_LINE_ITEMS

Line 200: SELECT COUNT(*) INTO l_no_records FROM XDP_ORDER_LINE_ITEMS

196: RECORDS_PURGED_MSGS(l_no_records,'WF_ITEMS WHERE ORDER_ID = '||p_order_id,
197: 'XDP_FOUND_REC',0);
198: END IF;
199:
200: SELECT COUNT(*) INTO l_no_records FROM XDP_ORDER_LINE_ITEMS
201: WHERE ORDER_ID = p_order_id;
202:
203: RECORDS_PURGED_MSGS(l_no_records,'XDP_ORDER_LINE_ITEMS WHERE ORDER_ID = '||p_order_id,
204: 'XDP_FOUND_REC',0);

Line 203: RECORDS_PURGED_MSGS(l_no_records,'XDP_ORDER_LINE_ITEMS WHERE ORDER_ID = '||p_order_id,

199:
200: SELECT COUNT(*) INTO l_no_records FROM XDP_ORDER_LINE_ITEMS
201: WHERE ORDER_ID = p_order_id;
202:
203: RECORDS_PURGED_MSGS(l_no_records,'XDP_ORDER_LINE_ITEMS WHERE ORDER_ID = '||p_order_id,
204: 'XDP_FOUND_REC',0);
205:
206: IF l_no_records <> 0 THEN
207: FOR c_item IN (SELECT LINE_ITEM_ID FROM XDP_ORDER_LINE_ITEMS

Line 207: FOR c_item IN (SELECT LINE_ITEM_ID FROM XDP_ORDER_LINE_ITEMS

203: RECORDS_PURGED_MSGS(l_no_records,'XDP_ORDER_LINE_ITEMS WHERE ORDER_ID = '||p_order_id,
204: 'XDP_FOUND_REC',0);
205:
206: IF l_no_records <> 0 THEN
207: FOR c_item IN (SELECT LINE_ITEM_ID FROM XDP_ORDER_LINE_ITEMS
208: WHERE ORDER_ID = p_order_id)
209: LOOP
210: SELECT COUNT(*) INTO l_no_records FROM XDP_ORDER_LINEITEM_DETS
211: WHERE LINE_ITEM_ID = c_item.LINE_ITEM_ID;

Line 430: p_line_item_id IN XDP_ORDER_LINE_ITEMS.LINE_ITEM_ID%TYPE,

426: -- Internal procedure for deleting fulfile worklist for a given line item
427: -- Name DELETE_FULFILL_WORKLIST
428:
429: PROCEDURE DELETE_FULFILL_WORKLIST(
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

Line 548: FROM XDP_ORDER_LINE_ITEMS

544: ) IS
545:
546: CURSOR c_line_item IS
547: SELECT LINE_ITEM_ID
548: FROM XDP_ORDER_LINE_ITEMS
549: WHERE order_id = p_order_id
550: FOR UPDATE OF LINE_ITEM_ID NOWAIT;
551:
552: l_temp NUMBER := 0;

Line 590: DELETE FROM XDP_ORDER_LINE_ITEMS WHERE CURRENT OF c_line_item;

586:
587: DELETE FROM XDP_LINE_RELATIONSHIPS
588: WHERE line_item_id = l_line_item.line_item_id;
589:
590: DELETE FROM XDP_ORDER_LINE_ITEMS WHERE CURRENT OF c_line_item;
591: END IF;
592: l_li_number := l_li_number+1;
593: END LOOP;
594: RECORDS_PURGED_MSGS(l_li_number,'XDP_ORDER_LINE_ITEMS WHERE ORDER_ID = '

Line 594: RECORDS_PURGED_MSGS(l_li_number,'XDP_ORDER_LINE_ITEMS WHERE ORDER_ID = '

590: DELETE FROM XDP_ORDER_LINE_ITEMS WHERE CURRENT OF c_line_item;
591: END IF;
592: l_li_number := l_li_number+1;
593: END LOOP;
594: RECORDS_PURGED_MSGS(l_li_number,'XDP_ORDER_LINE_ITEMS WHERE ORDER_ID = '
595: ||p_order_id,l_rec_name,0);
596: EXCEPTION
597: WHEN OTHERS THEN
598: PURGE_ERRORS(SUBSTR(SQLERRM, 1, 512),P_ABORT => TRUE);