APPS.EDR_ERES_EVENT_PVT dependencies on EDR_ERESPARAMETERS_T

Line 879: delete from EDR_ERESPARAMETERS_T params

875:
876: --Bug 3893101: Start
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';

Line 885: delete from EDR_ERESPARAMETERS_T where parent_id = p_eres_process_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
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;

Line 911: delete from EDR_ERESPARAMETERS_T params

907: L_TEMP_DATE := L_TEMP_DATE - L_TEMP_DATA_LIFE_NUM;
908:
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';

Line 917: delete from EDR_ERESPARAMETERS_T params

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