APPS.XDP_PURGE dependencies on XDP_FE_CMD_AUD_TRAILS

Line 262: SELECT COUNT(*) INTO l_temp FROM XDP_FE_CMD_AUD_TRAILS

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:
265: RECORDS_PURGED_MSGS(l_counter,'XDP_FE_CMD_AUD_TRAILS WHERE FA_INSTANCE_ID = '
266: ||c_fa.FA_INSTANCE_ID,'XDP_FOUND_REC',3);

Line 265: RECORDS_PURGED_MSGS(l_counter,'XDP_FE_CMD_AUD_TRAILS 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:
265: RECORDS_PURGED_MSGS(l_counter,'XDP_FE_CMD_AUD_TRAILS WHERE FA_INSTANCE_ID = '
266: ||c_fa.FA_INSTANCE_ID,'XDP_FOUND_REC',3);
267: END LOOP;
268: END IF;
269:

Line 460: SELECT COUNT(*) INTO l_temp FROM XDP_FE_CMD_AUD_TRAILS

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;
462: RECORDS_PURGED_MSGS(l_temp,'XDP_FE_CMD_AUD_TRAILS WHERE FA_INSTANCE_ID = '
463: ||l_fa.FA_INSTANCE_ID,l_rec_name,1);
464: END IF;

Line 462: RECORDS_PURGED_MSGS(l_temp,'XDP_FE_CMD_AUD_TRAILS 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;
462: RECORDS_PURGED_MSGS(l_temp,'XDP_FE_CMD_AUD_TRAILS WHERE FA_INSTANCE_ID = '
463: ||l_fa.FA_INSTANCE_ID,l_rec_name,1);
464: END IF;
465:
466: IF p_run_mode = 'PURGE' THEN

Line 468: DELETE FROM XDP_FE_CMD_AUD_TRAILS WHERE FA_INSTANCE_ID = l_fa.FA_INSTANCE_ID;

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:
472: IF ((bAudit = 'TRUE') AND (p_run_mode = 'PURGE')) or (p_run_mode = 'VERIFY') THEN

Line 478: RECORDS_PURGED_MSGS(l_temp ,'XDP_FE_CMD_AUD_TRAILS WHERE WORKITEM_INSTANCE_ID = '

474: WHERE FMC_ID IN
475: (SELECT FMC_ID FROM XDP_FMC_AUDIT_TRAILS
476: WHERE WORKITEM_INSTANCE_ID
477: = l_worklist.WORKITEM_INSTANCE_ID);
478: RECORDS_PURGED_MSGS(l_temp ,'XDP_FE_CMD_AUD_TRAILS WHERE WORKITEM_INSTANCE_ID = '
479: ||l_worklist.WORKITEM_INSTANCE_ID,l_rec_name,1);
480:
481: SELECT COUNT(*) INTO l_temp FROM XDP_FA_RUNTIME_LIST
482: WHERE WORKITEM_INSTANCE_ID = l_worklist.WORKITEM_INSTANCE_ID;