eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EDR_ERES_EVENT_PVT dependencies on EDR_PROCESS_ERECORDS_T

Line 872: --If eres_process_id is not null then delete from edr_process_erecords_t and

868: L_TEMP_DATE DATE;
869: L_TEMP_DATA_LIFE_NUM NUMBER;
870: BEGIN
871:
872: --If eres_process_id is not null then delete from edr_process_erecords_t and
873: --edr_eres_manager_t tables
874: if P_ERES_PROCESS_ID is not null then
875:
876: --Bug 3893101: Start

Line 881: from EDR_PROCESS_ERECORDS_T records

877: --Delete from the EDR parameters table as well.
878:
879: delete from EDR_ERESPARAMETERS_T params
880: where params.PARENT_ID in (select ERECORD_SEQUENCE_ID
881: from EDR_PROCESS_ERECORDS_T records
882: where records.ERES_PROCESS_ID = P_ERES_PROCESS_ID
883: ) and params.parent_type = 'ERECORD';
884:
885: delete from EDR_ERESPARAMETERS_T where parent_id = p_eres_process_id

Line 888: delete from EDR_PROCESS_ERECORDS_T where ERES_PROCESS_ID = P_ERES_PROCESS_ID;

884:
885: delete from EDR_ERESPARAMETERS_T where parent_id = p_eres_process_id
886: and parent_type = 'ERESMANAGER';
887: --Bug 3893101: End
888: delete from EDR_PROCESS_ERECORDS_T where ERES_PROCESS_ID = P_ERES_PROCESS_ID;
889: delete from EDR_ERESMANAGER_T where ERES_PROCESS_ID = P_ERES_PROCESS_ID;
890:
891: else
892: --If eres_process_id is null then delete temp data based on the profile values

Line 913: from EDR_PROCESS_ERECORDS_T records

909: --Bug 3893101: Start
910: --Delete the EDR parameters table as well
911: delete from EDR_ERESPARAMETERS_T params
912: where params.PARENT_ID in (select records.ERECORD_SEQUENCE_ID
913: from EDR_PROCESS_ERECORDS_T records
914: where records.CREATION_DATE <= L_TEMP_DATE
915: ) and params.parent_type = 'ERECORD';
916:
917: delete from EDR_ERESPARAMETERS_T params

Line 929: delete from EDR_PROCESS_ERECORDS_T where CREATION_DATE <= L_TEMP_DATE;

925: fnd_message.set_name('EDR', 'EDR_TEMP_ERESMANAGER_CLEANUP');
926: fnd_message.set_token( 'CLN_ERESMANAGER', SQL%ROWCOUNT);
927: fnd_file.put_line(fnd_file.output, fnd_message.get);
928:
929: delete from EDR_PROCESS_ERECORDS_T where CREATION_DATE <= L_TEMP_DATE;
930: fnd_message.set_name('EDR', 'EDR_TEMP_ERECORDS_CLEANUP');
931: fnd_message.set_token( 'CLN_ERECORDS', SQL%ROWCOUNT);
932: fnd_file.put_line(fnd_file.output, fnd_message.get);
933: