APPS.XDP_PURGE dependencies on XDP_WORKLIST_DETAILS

Line 239: SELECT COUNT(*) INTO l_temp FROM XDP_WORKLIST_DETAILS

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
240: WHERE WORKITEM_INSTANCE_ID = c_fw.WORKITEM_INSTANCE_ID;
241:
242: RECORDS_PURGED_MSGS(l_counter,'XDP_WORKLIST_DETAILS '||
243: 'WHERE WORKITEM_INSTANCE_ID = '

Line 242: RECORDS_PURGED_MSGS(l_counter,'XDP_WORKLIST_DETAILS '||

238:
239: SELECT COUNT(*) INTO l_temp FROM XDP_WORKLIST_DETAILS
240: WHERE WORKITEM_INSTANCE_ID = c_fw.WORKITEM_INSTANCE_ID;
241:
242: RECORDS_PURGED_MSGS(l_counter,'XDP_WORKLIST_DETAILS '||
243: 'WHERE WORKITEM_INSTANCE_ID = '
244: ||c_fw.WORKITEM_INSTANCE_ID,'XDP_FOUND_REC',2);
245:
246: SELECT COUNT(*) INTO l_temp FROM XDP_FA_RUNTIME_LIST

Line 496: SELECT COUNT(*) INTO l_temp FROM XDP_WORKLIST_DETAILS

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;
498: RECORDS_PURGED_MSGS(l_temp,'XDP_WORKLIST_DETAILS WHERE WORKITEM_INSTANCE_ID = '
499: ||l_worklist.WORKITEM_INSTANCE_ID,l_rec_name,1);
500: END IF;

Line 498: RECORDS_PURGED_MSGS(l_temp,'XDP_WORKLIST_DETAILS 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;
498: RECORDS_PURGED_MSGS(l_temp,'XDP_WORKLIST_DETAILS WHERE WORKITEM_INSTANCE_ID = '
499: ||l_worklist.WORKITEM_INSTANCE_ID,l_rec_name,1);
500: END IF;
501: -- Purging if it is in run mode
502: IF p_run_mode = 'PURGE' THEN

Line 518: DELETE FROM XDP_WORKLIST_DETAILS

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;
520:
521: DELETE FROM XDP_FULFILL_WORKLIST
522: WHERE WORKITEM_INSTANCE_ID = l_worklist.WORKITEM_INSTANCE_ID;