APPS.XDP_PURGE dependencies on XDP_LINE_RELATIONSHIPS

Line 216: SELECT COUNT(*) INTO l_no_records FROM XDP_LINE_RELATIONSHIPS

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;
218:
219: RECORDS_PURGED_MSGS(l_counter,'XDP_LINE_RELATIONSHIPS WHERE LINE_ITEM_ID = '
220: ||c_item.LINE_ITEM_ID,'XDP_FOUND_REC',1);

Line 219: RECORDS_PURGED_MSGS(l_counter,'XDP_LINE_RELATIONSHIPS WHERE LINE_ITEM_ID = '

215:
216: SELECT COUNT(*) INTO l_no_records FROM XDP_LINE_RELATIONSHIPS
217: WHERE LINE_ITEM_ID = c_item.LINE_ITEM_ID;
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;

Line 575: FROM XDP_LINE_RELATIONSHIPS

571: ||l_line_item.line_item_id,l_rec_name,1);
572:
573: SELECT COUNT(*)
574: INTO l_temp
575: FROM XDP_LINE_RELATIONSHIPS
576: WHERE line_item_id = l_line_item.line_item_id;
577:
578: RECORDS_PURGED_MSGS(l_temp,'XDP_LINE_RELATIONSHIPS WHERE LINE_ITEM_ID = '
579: ||l_line_item.line_item_id,l_rec_name,1);

Line 578: RECORDS_PURGED_MSGS(l_temp,'XDP_LINE_RELATIONSHIPS WHERE LINE_ITEM_ID = '

574: INTO l_temp
575: FROM XDP_LINE_RELATIONSHIPS
576: WHERE line_item_id = l_line_item.line_item_id;
577:
578: RECORDS_PURGED_MSGS(l_temp,'XDP_LINE_RELATIONSHIPS WHERE LINE_ITEM_ID = '
579: ||l_line_item.line_item_id,l_rec_name,1);
580: END IF;
581:
582: IF p_run_mode = 'PURGE' THEN

Line 587: DELETE FROM XDP_LINE_RELATIONSHIPS

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;
589:
590: DELETE FROM XDP_ORDER_LINE_ITEMS WHERE CURRENT OF c_line_item;
591: END IF;