APPS.BEN_IREC_BACK_OUT_CONC dependencies on BEN_BATCH_RANGES

Line 61: l_range_id ben_batch_ranges.range_id%type;

57: l_person_id ben_person_actions.person_id%type;
58: l_person_action_id ben_person_actions.person_action_id%type;
59: l_object_version_number ben_person_actions.object_version_number%type;
60: l_ler_id ben_person_actions.ler_id%type;
61: l_range_id ben_batch_ranges.range_id%type;
62: l_record_number number := 0;
63: l_start_person_action_id number := 0;
64: l_end_person_action_id number := 0;
65: l_actn varchar2(80);

Line 82: From ben_batch_ranges ran

78: Cursor c_range_thread is
79: Select ran.range_id
80: ,ran.starting_person_action_id
81: ,ran.ending_person_action_id
82: From ben_batch_ranges ran
83: Where ran.range_status_cd = 'U'
84: And ran.BENEFIT_ACTION_ID = P_BENEFIT_ACTION_ID
85: And rownum < 2
86: For update of ran.range_status_cd;

Line 240: update ben_batch_ranges ran

236: hr_utility.set_location('range Found',10);
237: --
238: close c_range_thread;
239: --
240: update ben_batch_ranges ran
241: set ran.range_status_cd = 'P'
242: where ran.range_id = l_range_id;
243: --
244: commit;

Line 473: l_range_id ben_batch_ranges.range_id%type;

469: l_object_version_number ben_benefit_actions.object_version_number%type;
470: l_person_id per_people_f.person_id%type;
471: l_person_action_id ben_person_actions.person_action_id%type;
472: l_ler_id ben_ler_f.ler_id%type;
473: l_range_id ben_batch_ranges.range_id%type;
474: l_chunk_size number := 20;
475: l_threads number := 1;
476: l_start_person_action_id number := 0;
477: l_end_person_action_id number := 0;

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

659: --
660: benutils.g_benefit_action_id := l_benefit_action_id;
661: --
662: hr_utility.set_location ('l_benefit_action_id created is '||l_benefit_action_id,30);
663: -- Delete/clear ranges from ben_batch_ranges table
664: --
665: Delete from ben_batch_ranges
666: Where benefit_action_id = l_benefit_action_id;
667: --

Line 665: Delete from ben_batch_ranges

661: --
662: hr_utility.set_location ('l_benefit_action_id created is '||l_benefit_action_id,30);
663: -- Delete/clear ranges from ben_batch_ranges table
664: --
665: Delete from ben_batch_ranges
666: Where benefit_action_id = l_benefit_action_id;
667: --
668: -- Now lets create person actions for all the people we are going to
669: -- process in the Back-out life event run

Line 747: Ben_batch_ranges_api.create_batch_ranges

743: If l_num_row = l_chunk_size then
744: --
745: -- Create a range of data to be multithreaded.
746: --
747: Ben_batch_ranges_api.create_batch_ranges
748: (p_validate => false
749: ,p_benefit_action_id => l_benefit_action_id
750: ,p_range_id => l_range_id
751: ,p_range_status_cd => 'U'

Line 777: Ben_batch_ranges_api.create_batch_ranges

773: hr_utility.set_location('l_num_row='||to_char(l_num_row),48);
774: --
775: If l_num_row <> 0 then
776: --
777: Ben_batch_ranges_api.create_batch_ranges
778: (p_validate => false
779: ,p_benefit_action_id => l_benefit_action_id
780: ,p_range_id => l_range_id
781: ,p_range_status_cd => 'U'