APPS.XDP_PURGE dependencies on XDP_FA_DETAILS

Line 257: SELECT COUNT(*) INTO l_temp FROM XDP_FA_DETAILS WHERE

253: IF l_temp <> 0 THEN
254: FOR c_fa IN (SELECT FA_INSTANCE_ID FROM XDP_FA_RUNTIME_LIST
255: WHERE WORKITEM_INSTANCE_ID = c_fw.WORKITEM_INSTANCE_ID)
256: LOOP
257: SELECT COUNT(*) INTO l_temp FROM XDP_FA_DETAILS WHERE
258: FA_INSTANCE_ID = c_fa.FA_INSTANCE_ID;
259:
260: RECORDS_PURGED_MSGS(l_counter,'XDP_FA_DETAILS WHERE FA_INSTANCE_ID = '
261: ||c_fa.FA_INSTANCE_ID,'XDP_FOUND_REC',3);

Line 260: RECORDS_PURGED_MSGS(l_counter,'XDP_FA_DETAILS WHERE FA_INSTANCE_ID = '

256: LOOP
257: SELECT COUNT(*) INTO l_temp FROM XDP_FA_DETAILS WHERE
258: FA_INSTANCE_ID = c_fa.FA_INSTANCE_ID;
259:
260: RECORDS_PURGED_MSGS(l_counter,'XDP_FA_DETAILS WHERE FA_INSTANCE_ID = '
261: ||c_fa.FA_INSTANCE_ID,'XDP_FOUND_REC',3);
262: SELECT COUNT(*) INTO l_temp FROM XDP_FE_CMD_AUD_TRAILS
263: WHERE FA_INSTANCE_ID = c_fa.FA_INSTANCE_ID;
264:

Line 455: SELECT COUNT(*) INTO l_temp FROM XDP_FA_DETAILS

451: FOR l_worklist IN c_fulfill_worklist LOOP
452: -- LOG PURGING INFORMATION
453: FOR l_fa IN c_fulfill_action(l_worklist.WORKITEM_INSTANCE_ID) LOOP
454: IF ((bAudit = 'TRUE') AND (p_run_mode = 'PURGE')) or (p_run_mode = 'VERIFY') THEN
455: SELECT COUNT(*) INTO l_temp FROM XDP_FA_DETAILS
456: WHERE FA_INSTANCE_ID = l_fa.FA_INSTANCE_ID;
457: RECORDS_PURGED_MSGS(l_temp,'XDP_FA_DETAILS WHERE FA_INSTANCE_ID = '
458: ||l_fa.FA_INSTANCE_ID,l_rec_name,1);
459:

Line 457: RECORDS_PURGED_MSGS(l_temp,'XDP_FA_DETAILS WHERE FA_INSTANCE_ID = '

453: FOR l_fa IN c_fulfill_action(l_worklist.WORKITEM_INSTANCE_ID) LOOP
454: IF ((bAudit = 'TRUE') AND (p_run_mode = 'PURGE')) or (p_run_mode = 'VERIFY') THEN
455: SELECT COUNT(*) INTO l_temp FROM XDP_FA_DETAILS
456: WHERE FA_INSTANCE_ID = l_fa.FA_INSTANCE_ID;
457: RECORDS_PURGED_MSGS(l_temp,'XDP_FA_DETAILS WHERE FA_INSTANCE_ID = '
458: ||l_fa.FA_INSTANCE_ID,l_rec_name,1);
459:
460: SELECT COUNT(*) INTO l_temp FROM XDP_FE_CMD_AUD_TRAILS
461: WHERE FA_INSTANCE_ID = l_fa.FA_INSTANCE_ID;

Line 467: DELETE FROM XDP_FA_DETAILS WHERE FA_INSTANCE_ID = l_fa.FA_INSTANCE_ID;

463: ||l_fa.FA_INSTANCE_ID,l_rec_name,1);
464: END IF;
465:
466: IF p_run_mode = 'PURGE' THEN
467: DELETE FROM XDP_FA_DETAILS WHERE FA_INSTANCE_ID = l_fa.FA_INSTANCE_ID;
468: DELETE FROM XDP_FE_CMD_AUD_TRAILS WHERE FA_INSTANCE_ID = l_fa.FA_INSTANCE_ID;
469: END IF;
470: END LOOP;
471: