APPS.XDP_PURGE dependencies on XDP_FMC_AUDIT_TRAILS

Line 270: SELECT COUNT(*) INTO l_temp FROM XDP_FMC_AUDIT_TRAILS

266: ||c_fa.FA_INSTANCE_ID,'XDP_FOUND_REC',3);
267: END LOOP;
268: END IF;
269:
270: SELECT COUNT(*) INTO l_temp FROM XDP_FMC_AUDIT_TRAILS
271: WHERE WORKITEM_INSTANCE_ID = c_fw.WORKITEM_INSTANCE_ID;
272:
273: RECORDS_PURGED_MSGS(l_counter,'XDP_FMC_AUDIT_TRAILS '||
274: 'WHERE WORKITEM_INSTANCE_ID = '

Line 273: RECORDS_PURGED_MSGS(l_counter,'XDP_FMC_AUDIT_TRAILS '||

269:
270: SELECT COUNT(*) INTO l_temp FROM XDP_FMC_AUDIT_TRAILS
271: WHERE WORKITEM_INSTANCE_ID = c_fw.WORKITEM_INSTANCE_ID;
272:
273: RECORDS_PURGED_MSGS(l_counter,'XDP_FMC_AUDIT_TRAILS '||
274: 'WHERE WORKITEM_INSTANCE_ID = '
275: ||c_fw.WORKITEM_INSTANCE_ID,'XDP_FOUND_REC',2);
276:
277: IF l_temp <> 0 THEN

Line 279: (SELECT FMC_ID FROM XDP_FMC_AUDIT_TRAILS

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 '||
283: 'WHERE WORKITEM_INSTANCE_ID = '

Line 475: (SELECT FMC_ID FROM XDP_FMC_AUDIT_TRAILS

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);
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);

Line 486: SELECT COUNT(*) INTO l_temp FROM XDP_FMC_AUDIT_TRAILS

482: WHERE WORKITEM_INSTANCE_ID = l_worklist.WORKITEM_INSTANCE_ID;
483: RECORDS_PURGED_MSGS(l_temp, 'XDP_FA_RUNTIME_LIST WHERE WORKITEM_INSTANCE_ID = '
484: ||l_worklist.WORKITEM_INSTANCE_ID,l_rec_name,1);
485:
486: SELECT COUNT(*) INTO l_temp FROM XDP_FMC_AUDIT_TRAILS
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:

Line 488: RECORDS_PURGED_MSGS(l_temp,'XDP_FMC_AUDIT_TRAILS WHERE WORKITEM_INSTANCE_ID = '

484: ||l_worklist.WORKITEM_INSTANCE_ID,l_rec_name,1);
485:
486: SELECT COUNT(*) INTO l_temp FROM XDP_FMC_AUDIT_TRAILS
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;

Line 505: (SELECT FMC_ID FROM XDP_FMC_AUDIT_TRAILS

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);
508:
509: DELETE FROM XDP_FA_RUNTIME_LIST

Line 512: DELETE FROM XDP_FMC_AUDIT_TRAILS

508:
509: DELETE FROM XDP_FA_RUNTIME_LIST
510: WHERE WORKITEM_INSTANCE_ID = l_worklist.WORKITEM_INSTANCE_ID;
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;