APPS.BEN_EVALUATE_ELIG_CONC dependencies on BEN_BATCH_RANGES

Line 58: l_range_id ben_batch_ranges.range_id%type;

54: l_proc varchar2(80) := g_package||'.do_multithread';
55: l_person_id ben_person_actions.person_id%type;
56: l_person_action_id ben_person_actions.person_action_id%type;
57: l_object_version_number ben_person_actions.object_version_number%type;
58: l_range_id ben_batch_ranges.range_id%type;
59: l_record_number number := 0;
60: l_start_person_action_id number := 0;
61: l_end_person_action_id number := 0;
62: l_actn varchar2(80);

Line 76: From ben_batch_ranges ran

72: Cursor c_range_thread is
73: Select ran.range_id
74: ,ran.starting_person_action_id
75: ,ran.ending_person_action_id
76: From ben_batch_ranges ran
77: Where ran.range_status_cd = 'U'
78: And ran.BENEFIT_ACTION_ID = P_BENEFIT_ACTION_ID
79: And rownum < 2
80: For update of ran.range_status_cd;

Line 214: update ben_batch_ranges ran

210: hr_utility.set_location('range Found',10);
211: --
212: close c_range_thread;
213: --
214: update ben_batch_ranges ran
215: set ran.range_status_cd = 'P'
216: where ran.range_id = l_range_id;
217: --
218: commit;

Line 543: l_range_id ben_batch_ranges.range_id%type;

539: l_object_version_number ben_benefit_actions.object_version_number%type;
540: l_person_id per_people_f.person_id%type;
541: l_person_action_id ben_person_actions.person_action_id%type;
542: l_ler_id ben_ler_f.ler_id%type;
543: l_range_id ben_batch_ranges.range_id%type;
544: l_chunk_size number := 20;
545: l_threads number := 1;
546: l_start_person_action_id number := 0;
547: l_end_person_action_id number := 0;

Line 623: -- Delete/clear ranges from ben_batch_ranges table

619: ,p_program_update_date => sysdate);
620: --
621: benutils.g_benefit_action_id := l_benefit_action_id;
622: --
623: -- Delete/clear ranges from ben_batch_ranges table
624: --
625: Delete from ben_batch_ranges
626: Where benefit_action_id = l_benefit_action_id;
627: --

Line 625: Delete from ben_batch_ranges

621: benutils.g_benefit_action_id := l_benefit_action_id;
622: --
623: -- Delete/clear ranges from ben_batch_ranges table
624: --
625: Delete from ben_batch_ranges
626: Where benefit_action_id = l_benefit_action_id;
627: --
628: -- Now lets create person actions for all the people we are going to
629: -- process in the Back-out life event run

Line 690: Ben_batch_ranges_api.create_batch_ranges

686: If l_num_row = l_chunk_size then
687: --
688: -- Create a range of data to be multithreaded.
689: --
690: Ben_batch_ranges_api.create_batch_ranges
691: (p_validate => false
692: ,p_benefit_action_id => l_benefit_action_id
693: ,p_range_id => l_range_id
694: ,p_range_status_cd => 'U'

Line 717: Ben_batch_ranges_api.create_batch_ranges

713: hr_utility.set_location('l_num_row='||to_char(l_num_row),18);
714: --
715: If l_num_row <> 0 then
716: --
717: Ben_batch_ranges_api.create_batch_ranges
718: (p_validate => false
719: ,p_benefit_action_id => l_benefit_action_id
720: ,p_range_id => l_range_id
721: ,p_range_status_cd => 'U'