APPS.XDP_PURGE dependencies on XDP_ORDER_LINEITEM_DETS

Line 210: SELECT COUNT(*) INTO l_no_records FROM XDP_ORDER_LINEITEM_DETS

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;
212:
213: RECORDS_PURGED_MSGS(l_no_records,'XDP_ORDER_LINEITEM_DETS WHERE LINE_ITEM_ID = '
214: ||c_item.LINE_ITEM_ID,'XDP_FOUND_REC',1);

Line 213: RECORDS_PURGED_MSGS(l_no_records,'XDP_ORDER_LINEITEM_DETS WHERE LINE_ITEM_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;
212:
213: RECORDS_PURGED_MSGS(l_no_records,'XDP_ORDER_LINEITEM_DETS WHERE LINE_ITEM_ID = '
214: ||c_item.LINE_ITEM_ID,'XDP_FOUND_REC',1);
215:
216: SELECT COUNT(*) INTO l_no_records FROM XDP_LINE_RELATIONSHIPS
217: WHERE LINE_ITEM_ID = c_item.LINE_ITEM_ID;

Line 567: FROM XDP_ORDER_LINEITEM_DETS

563: IF ((bAudit = 'TRUE') AND (p_run_mode = 'PURGE')) or (p_run_mode = 'VERIFY') THEN
564:
565: SELECT COUNT(*)
566: INTO l_temp
567: FROM XDP_ORDER_LINEITEM_DETS
568: WHERE line_item_id = l_line_item.line_item_id;
569:
570: RECORDS_PURGED_MSGS(l_temp, 'XDP_ORDER_LINEITEM_DETS WHERE LINE_ITEM_ID = '
571: ||l_line_item.line_item_id,l_rec_name,1);

Line 570: RECORDS_PURGED_MSGS(l_temp, 'XDP_ORDER_LINEITEM_DETS WHERE LINE_ITEM_ID = '

566: INTO l_temp
567: FROM XDP_ORDER_LINEITEM_DETS
568: WHERE line_item_id = l_line_item.line_item_id;
569:
570: RECORDS_PURGED_MSGS(l_temp, 'XDP_ORDER_LINEITEM_DETS WHERE LINE_ITEM_ID = '
571: ||l_line_item.line_item_id,l_rec_name,1);
572:
573: SELECT COUNT(*)
574: INTO l_temp

Line 584: DELETE FROM XDP_ORDER_LINEITEM_DETS

580: END IF;
581:
582: IF p_run_mode = 'PURGE' THEN
583:
584: DELETE FROM XDP_ORDER_LINEITEM_DETS
585: WHERE line_item_id = l_line_item.line_item_id;
586:
587: DELETE FROM XDP_LINE_RELATIONSHIPS
588: WHERE line_item_id = l_line_item.line_item_id;