APPS.BEN_REOPEN_LER_CONC dependencies on BEN_BATCH_RANGES

Line 249: DELETE FROM ben_batch_ranges

245: --
246: l_actn := 'Removing batch ranges ';
247:
248: --
249: DELETE FROM ben_batch_ranges
250: WHERE benefit_action_id = l_benefit_action_id;
251:
252: --
253: -- Loop through rows in ben_per_in_ler_f based on the parameters passed and

Line 339: ben_batch_ranges_api.create_batch_ranges

335: hr_utility.set_location ('l_range_id: '||to_char(l_range_id),60);
336: hr_utility.set_location ('l_start_person_actn_id '||to_char(l_start_person_actn_id),60);
337: hr_utility.set_location ('l_end_person_actn_id '||to_char(l_end_person_actn_id),60);
338:
339: ben_batch_ranges_api.create_batch_ranges
340: (p_validate => FALSE,
341: p_effective_date => l_effective_date,
342: p_benefit_action_id => l_benefit_action_id,
343: p_range_id => l_range_id,

Line 370: ben_batch_ranges_api.create_batch_ranges

366: IF l_person_actn_cnt > 0
367: AND MOD (l_person_actn_cnt, l_chunk_size) <> 0
368: THEN
369: --
370: ben_batch_ranges_api.create_batch_ranges
371: (p_validate => FALSE,
372: p_effective_date => l_effective_date,
373: p_benefit_action_id => l_benefit_action_id,
374: p_range_id => l_range_id,

Line 593: l_range_id ben_batch_ranges.range_id%TYPE;

589: l_person_action_id ben_person_actions.person_action_id%TYPE;
590: l_object_version_number ben_person_actions.object_version_number%TYPE;
591: l_lf_evt_ocrd_dt DATE;
592: l_ler_id ben_person_actions.ler_id%TYPE;
593: l_range_id ben_batch_ranges.range_id%TYPE;
594: l_record_number NUMBER := 0;
595: l_start_person_action_id NUMBER := 0;
596: l_end_person_action_id NUMBER := 0;
597: l_actn VARCHAR2 (80);

Line 615: FROM ben_batch_ranges ran

611: IS
612: -- to fetch all the ranges
613: SELECT ran.range_id, ran.starting_person_action_id,
614: ran.ending_person_action_id
615: FROM ben_batch_ranges ran
616: WHERE ran.range_status_cd = 'U'
617: AND ran.benefit_action_id = p_benefit_action_id
618: AND ROWNUM < 2
619: FOR UPDATE OF ran.range_status_cd;

Line 755: UPDATE ben_batch_ranges ran

751: CLOSE c_range_thread;
752: --
753: -- Update the range status code to processed 'P'
754: --
755: UPDATE ben_batch_ranges ran
756: SET ran.range_status_cd = 'P'
757: WHERE ran.range_id = l_range_id;
758: --
759: hr_utility.set_location ('Updated range '|| TO_CHAR (l_range_id)|| ' status code to P',10);