APPS.BEN_BACK_OUT_CONC dependencies on BEN_BATCH_RANGES

Line 98: l_range_id ben_batch_ranges.range_id%type;

94: l_person_id ben_person_actions.person_id%type;
95: l_person_action_id ben_person_actions.person_action_id%type;
96: l_object_version_number ben_person_actions.object_version_number%type;
97: l_ler_id ben_person_actions.ler_id%type;
98: l_range_id ben_batch_ranges.range_id%type;
99: l_record_number number := 0;
100: l_start_person_action_id number := 0;
101: l_end_person_action_id number := 0;
102: l_actn varchar2(80);

Line 116: From ben_batch_ranges ran

112: Cursor c_range_thread is
113: Select ran.range_id
114: ,ran.starting_person_action_id
115: ,ran.ending_person_action_id
116: From ben_batch_ranges ran
117: Where ran.range_status_cd = 'U'
118: And ran.BENEFIT_ACTION_ID = P_BENEFIT_ACTION_ID
119: And rownum < 2
120: For update of ran.range_status_cd;

Line 392: update ben_batch_ranges ran

388: hr_utility.set_location('range Found',10);
389: --
390: close c_range_thread;
391: --
392: update ben_batch_ranges ran
393: set ran.range_status_cd = 'P'
394: where ran.range_id = l_range_id;
395: --
396: commit;

Line 928: l_range_id ben_batch_ranges.range_id%type;

924: l_object_version_number ben_benefit_actions.object_version_number%type;
925: l_person_id per_people_f.person_id%type;
926: l_person_action_id ben_person_actions.person_action_id%type;
927: l_ler_id ben_ler_f.ler_id%type;
928: l_range_id ben_batch_ranges.range_id%type;
929: l_chunk_size number := 20;
930: l_threads number := 1;
931: l_start_person_action_id number := 0;
932: l_end_person_action_id number := 0;

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

1013: ,p_ptnl_ler_for_per_stat_cd => p_bckt_stat_cd);
1014: --
1015: benutils.g_benefit_action_id := l_benefit_action_id;
1016: --
1017: -- Delete/clear ranges from ben_batch_ranges table
1018: --
1019: Delete from ben_batch_ranges
1020: Where benefit_action_id = l_benefit_action_id;
1021: --

Line 1019: Delete from ben_batch_ranges

1015: benutils.g_benefit_action_id := l_benefit_action_id;
1016: --
1017: -- Delete/clear ranges from ben_batch_ranges table
1018: --
1019: Delete from ben_batch_ranges
1020: Where benefit_action_id = l_benefit_action_id;
1021: --
1022: -- Now lets create person actions for all the people we are going to
1023: -- process in the Back-out life event run

Line 1088: Ben_batch_ranges_api.create_batch_ranges

1084: If l_num_row = l_chunk_size then
1085: --
1086: -- Create a range of data to be multithreaded.
1087: --
1088: Ben_batch_ranges_api.create_batch_ranges
1089: (p_validate => false
1090: ,p_benefit_action_id => l_benefit_action_id
1091: ,p_range_id => l_range_id
1092: ,p_range_status_cd => 'U'

Line 1115: Ben_batch_ranges_api.create_batch_ranges

1111: hr_utility.set_location('l_num_row='||to_char(l_num_row),18);
1112: --
1113: If l_num_row <> 0 then
1114: --
1115: Ben_batch_ranges_api.create_batch_ranges
1116: (p_validate => false
1117: ,p_benefit_action_id => l_benefit_action_id
1118: ,p_range_id => l_range_id
1119: ,p_range_status_cd => 'U'