APPS.OTA_ELIG_PROFILE_UTIL dependencies on OTA_BATCH_RANGES

Line 879: l_range_id OTA_BATCH_RANGES.range_id%TYPE;

875: ,p_enable_logging IN varchar2 DEFAULT 'N'
876: ,p_chunk_size IN number
877: ,p_thread_count IN number) IS
878: l_effective_date date;
879: l_range_id OTA_BATCH_RANGES.range_id%TYPE;
880: l_record_number number DEFAULT 0;
881: l_start_person_action_id number DEFAULT 0;
882: l_end_person_action_id number DEFAULT 0;
883: l_actn varchar2(80);

Line 895: FROM OTA_BATCH_RANGES ran

891: CURSOR c_range_thread IS
892: SELECT ran.range_id
893: ,ran.starting_person_action_id
894: ,ran.ending_person_action_id
895: FROM OTA_BATCH_RANGES ran
896: WHERE ran.range_status_cd = 'U'
897: AND ran.batch_source_cd = 'EP'
898: AND ran.BATCH_ACTION_ID = p_action_id
899: AND rownum < 2

Line 1034: UPDATE OTA_BATCH_RANGES ran

1030: END IF;
1031:
1032: CLOSE c_range_thread;
1033:
1034: UPDATE OTA_BATCH_RANGES ran
1035: SET ran.range_status_cd = 'P'
1036: WHERE ran.range_id = l_range_id;
1037:
1038: COMMIT;