APPS.EDR_ERES_EVENT_PVT dependencies on EDR_ERESMANAGER_T

Line 836: select EDR_ERESMANAGER_T_S.nextval into X_ERES_PROCESS_ID from dual;

832: X_ERES_PROCESS_ID OUT NOCOPY NUMBER)
833: IS
834: BEGIN
835: --get the next pk value from sequence
836: select EDR_ERESMANAGER_T_S.nextval into X_ERES_PROCESS_ID from dual;
837:
838: --insert all the values in db
839: insert into EDR_ERESMANAGER_T(ERES_PROCESS_ID,
840: RETURN_URL,

Line 839: insert into EDR_ERESMANAGER_T(ERES_PROCESS_ID,

835: --get the next pk value from sequence
836: select EDR_ERESMANAGER_T_S.nextval into X_ERES_PROCESS_ID from dual;
837:
838: --insert all the values in db
839: insert into EDR_ERESMANAGER_T(ERES_PROCESS_ID,
840: RETURN_URL,
841: RETURN_FUNCTION,
842: OVERALL_STATUS,
843: CREATED_BY,

Line 889: delete from EDR_ERESMANAGER_T where ERES_PROCESS_ID = P_ERES_PROCESS_ID;

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
893: L_TEMP_DATE := sysdate;

Line 919: from EDR_ERESMANAGER_T manager

915: ) and params.parent_type = 'ERECORD';
916:
917: delete from EDR_ERESPARAMETERS_T params
918: where params.PARENT_ID in (select manager.ERES_PROCESS_ID
919: from EDR_ERESMANAGER_T manager
920: where manager.CREATION_DATE <= L_TEMP_DATE
921: ) and params.parent_type = 'ERESMANAGER';
922: --Bug 3893101: End
923:

Line 924: delete from EDR_ERESMANAGER_T where CREATION_DATE <= L_TEMP_DATE;

920: where manager.CREATION_DATE <= L_TEMP_DATE
921: ) and params.parent_type = 'ERESMANAGER';
922: --Bug 3893101: End
923:
924: delete from EDR_ERESMANAGER_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: