APPS.EDR_UTILITIES dependencies on EDR_ERECORDS

Line 457: DELETE EDR_ERECORDS where ERECORD_SIGNATURE_STATUS not in ('PENDING');

453: BEGIN
454:
455: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_UTIL_PLS_CLEAN_TEMP') );
456:
457: DELETE EDR_ERECORDS where ERECORD_SIGNATURE_STATUS not in ('PENDING');
458:
459: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_CLEAN_EREC');
460: fnd_message.set_token( 'CLN_NUMREC', SQL%ROWCOUNT);
461: fnd_file.put_line(fnd_file.output, fnd_message.get);

Line 463: DELETE EDR_ESIGNATURES where EVENT_ID not in (SELECT EVENT_ID from EDR_ERECORDS);

459: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_CLEAN_EREC');
460: fnd_message.set_token( 'CLN_NUMREC', SQL%ROWCOUNT);
461: fnd_file.put_line(fnd_file.output, fnd_message.get);
462:
463: DELETE EDR_ESIGNATURES where EVENT_ID not in (SELECT EVENT_ID from EDR_ERECORDS);
464:
465: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_CLEAN_ESIG');
466: fnd_message.set_token( 'CLN_NUMSIG', SQL%ROWCOUNT);
467: fnd_file.put_line(fnd_file.output, fnd_message.get);

Line 473: DELETE EDR_REDLINE_TRANS_DATA where EVENT_ID not in (SELECT EVENT_ID from EDR_ERECORDS);

469: -- Bug 3761813 rvsingh start
470: --Bug 4306292: Start
471: --Commenting the changes made for the red lining project.
472:
473: DELETE EDR_REDLINE_TRANS_DATA where EVENT_ID not in (SELECT EVENT_ID from EDR_ERECORDS);
474:
475: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_CLEAN_REDLINE');
476: fnd_message.set_token( 'CLN_NUMREDLINE', SQL%ROWCOUNT);
477: fnd_file.put_line(fnd_file.output, fnd_message.get);