DBA Data[Home] [Help]

APPS.EDR_UTILITIES dependencies on EDR_COLLATE_PRINT_TEMP

Line 505: (SELECT REQUEST_ID FROM EDR_COLLATE_PRINT_TEMP

501: -- Bug 3776079 : Added delete statements to cleanup edr
502: -- print utility temporary data.
503:
504: DELETE FROM EDR_PREPARE_DOCUMENT_TEMP WHERE REQUEST_ID IN
505: (SELECT REQUEST_ID FROM EDR_COLLATE_PRINT_TEMP
506: WHERE CREATION_DATE < (SYSDATE - 2) );
507: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_CLEAN_PREP');
508: fnd_message.set_token( 'CLN_NUMQRY', SQL%ROWCOUNT);
509: fnd_file.put_line(fnd_file.output, fnd_message.get);

Line 511: DELETE FROM EDR_COLLATE_PRINT_TEMP where CREATION_DATE < (SYSDATE - 2);

507: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_CLEAN_PREP');
508: fnd_message.set_token( 'CLN_NUMQRY', SQL%ROWCOUNT);
509: fnd_file.put_line(fnd_file.output, fnd_message.get);
510:
511: DELETE FROM EDR_COLLATE_PRINT_TEMP where CREATION_DATE < (SYSDATE - 2);
512: fnd_message.set_name('EDR', 'EDR_UTIL_PLS_CLEAN_COLL');
513: fnd_message.set_token( 'CLN_NUMQRY', SQL%ROWCOUNT);
514: fnd_file.put_line(fnd_file.output, fnd_message.get);
515: