APPS.XDP_PURGE dependencies on XDP_FMC_AUD_TRAIL_DETS

Line 278: SELECT COUNT(*) INTO l_temp FROM XDP_FMC_AUD_TRAIL_DETS WHERE FMC_ID IN

274: 'WHERE WORKITEM_INSTANCE_ID = '
275: ||c_fw.WORKITEM_INSTANCE_ID,'XDP_FOUND_REC',2);
276:
277: IF l_temp <> 0 THEN
278: SELECT COUNT(*) INTO l_temp FROM XDP_FMC_AUD_TRAIL_DETS WHERE FMC_ID IN
279: (SELECT FMC_ID FROM XDP_FMC_AUDIT_TRAILS
280: WHERE WORKITEM_INSTANCE_ID = c_fw.WORKITEM_INSTANCE_ID);
281:
282: RECORDS_PURGED_MSGS(l_counter,'XDP_FMC_AUD_TRAIL_DETS '||

Line 282: RECORDS_PURGED_MSGS(l_counter,'XDP_FMC_AUD_TRAIL_DETS '||

278: SELECT COUNT(*) INTO l_temp FROM XDP_FMC_AUD_TRAIL_DETS WHERE FMC_ID IN
279: (SELECT FMC_ID FROM XDP_FMC_AUDIT_TRAILS
280: WHERE WORKITEM_INSTANCE_ID = c_fw.WORKITEM_INSTANCE_ID);
281:
282: RECORDS_PURGED_MSGS(l_counter,'XDP_FMC_AUD_TRAIL_DETS '||
283: 'WHERE WORKITEM_INSTANCE_ID = '
284: ||c_fw.WORKITEM_INSTANCE_ID,'XDP_FOUND_REC',3);
285: END IF;
286: END LOOP;

Line 473: SELECT COUNT(*) INTO l_temp FROM XDP_FMC_AUD_TRAIL_DETS

469: END IF;
470: END LOOP;
471:
472: IF ((bAudit = 'TRUE') AND (p_run_mode = 'PURGE')) or (p_run_mode = 'VERIFY') THEN
473: SELECT COUNT(*) INTO l_temp FROM XDP_FMC_AUD_TRAIL_DETS
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);

Line 503: DELETE FROM XDP_FMC_AUD_TRAIL_DETS

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
503: DELETE FROM XDP_FMC_AUD_TRAIL_DETS
504: WHERE FMC_ID IN
505: (SELECT FMC_ID FROM XDP_FMC_AUDIT_TRAILS
506: WHERE WORKITEM_INSTANCE_ID
507: = l_worklist.WORKITEM_INSTANCE_ID);