APPS.XDP_PURGE dependencies on XDP_WI_RELATIONSHIPS

Line 232: SELECT COUNT(*) INTO l_temp FROM XDP_WI_RELATIONSHIPS

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;
234:
235: RECORDS_PURGED_MSGS(l_counter,'XDP_WI_RELATIONSHIPS '||
236: 'WHERE WORKITEM_INSTANCE_ID = '

Line 235: RECORDS_PURGED_MSGS(l_counter,'XDP_WI_RELATIONSHIPS '||

231: LOOP
232: SELECT COUNT(*) INTO l_temp FROM XDP_WI_RELATIONSHIPS
233: WHERE WORKITEM_INSTANCE_ID = c_fw.WORKITEM_INSTANCE_ID;
234:
235: RECORDS_PURGED_MSGS(l_counter,'XDP_WI_RELATIONSHIPS '||
236: 'WHERE WORKITEM_INSTANCE_ID = '
237: ||c_fw.WORKITEM_INSTANCE_ID,'XDP_FOUND_REC',2);
238:
239: SELECT COUNT(*) INTO l_temp FROM XDP_WORKLIST_DETAILS

Line 491: SELECT COUNT(*) INTO l_temp FROM XDP_WI_RELATIONSHIPS

487: WHERE WORKITEM_INSTANCE_ID = l_worklist.WORKITEM_INSTANCE_ID;
488: RECORDS_PURGED_MSGS(l_temp,'XDP_FMC_AUDIT_TRAILS WHERE WORKITEM_INSTANCE_ID = '
489: ||l_worklist.WORKITEM_INSTANCE_ID,l_rec_name,1);
490:
491: SELECT COUNT(*) INTO l_temp FROM XDP_WI_RELATIONSHIPS
492: WHERE WORKITEM_INSTANCE_ID = l_worklist.WORKITEM_INSTANCE_ID;
493: RECORDS_PURGED_MSGS(l_temp,'XDP_WI_RELATIONSHIPS WHERE WORKITEM_INSTANCE_ID = '
494: ||l_worklist.WORKITEM_INSTANCE_ID,l_rec_name,1);
495:

Line 493: RECORDS_PURGED_MSGS(l_temp,'XDP_WI_RELATIONSHIPS WHERE WORKITEM_INSTANCE_ID = '

489: ||l_worklist.WORKITEM_INSTANCE_ID,l_rec_name,1);
490:
491: SELECT COUNT(*) INTO l_temp FROM XDP_WI_RELATIONSHIPS
492: WHERE WORKITEM_INSTANCE_ID = l_worklist.WORKITEM_INSTANCE_ID;
493: RECORDS_PURGED_MSGS(l_temp,'XDP_WI_RELATIONSHIPS WHERE WORKITEM_INSTANCE_ID = '
494: ||l_worklist.WORKITEM_INSTANCE_ID,l_rec_name,1);
495:
496: SELECT COUNT(*) INTO l_temp FROM XDP_WORKLIST_DETAILS
497: WHERE WORKITEM_INSTANCE_ID = l_worklist.WORKITEM_INSTANCE_ID;

Line 515: DELETE FROM XDP_WI_RELATIONSHIPS

511:
512: DELETE FROM XDP_FMC_AUDIT_TRAILS
513: WHERE WORKITEM_INSTANCE_ID = l_worklist.WORKITEM_INSTANCE_ID;
514:
515: DELETE FROM XDP_WI_RELATIONSHIPS
516: WHERE WORKITEM_INSTANCE_ID = l_worklist.WORKITEM_INSTANCE_ID;
517:
518: DELETE FROM XDP_WORKLIST_DETAILS
519: WHERE WORKITEM_INSTANCE_ID = l_worklist.WORKITEM_INSTANCE_ID;