APPS.BEN_MANAGE_OPEN_ENRT_WNDW dependencies on BEN_BATCH_RANGES

Line 320: l_range_id ben_batch_ranges.range_id%type;

316: l_person_id ben_person_actions.person_id%type;
317: l_person_action_id ben_person_actions.person_action_id%type;
318: l_object_version_number ben_person_actions.object_version_number%type;
319: l_ler_id ben_person_actions.ler_id%type;
320: l_range_id ben_batch_ranges.range_id%type;
321: l_record_number number := 0;
322: l_start_person_action_id number := 0;
323: l_end_person_action_id number := 0;
324: l_popl_cnt number(5):= 0;

Line 339: From ben_batch_ranges ran

335: Cursor c_range_thread is
336: Select ran.range_id
337: ,ran.starting_person_action_id
338: ,ran.ending_person_action_id
339: From ben_batch_ranges ran
340: Where ran.range_status_cd = 'U'
341: And ran.BENEFIT_ACTION_ID = P_BENEFIT_ACTION_ID
342: And rownum < 2
343: For update of ran.range_status_cd;

Line 494: update ben_batch_ranges ran

490: hr_utility.set_location('range Found',10);
491: --
492: close c_range_thread;
493: --
494: update ben_batch_ranges ran
495: set ran.range_status_cd = 'P'
496: where ran.range_id = l_range_id;
497: --
498: commit;

Line 974: l_range_id ben_batch_ranges.range_id%type;

970: l_object_version_number ben_benefit_actions.object_version_number%type;
971: l_person_id per_people_f.person_id%type;
972: l_person_action_id ben_person_actions.person_action_id%type;
973: l_ler_id ben_ler_f.ler_id%type;
974: l_range_id ben_batch_ranges.range_id%type;
975: l_chunk_size number := 20;
976: l_threads number := 1;
977: l_start_person_action_id number := 0;
978: l_end_person_action_id number := 0;

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

1091: hr_utility.set_location (' l_benefit_action_id : '||l_benefit_action_id,20);
1092: hr_utility.set_location (l_proc||' Dn Create BFT ',20);
1093: end if;
1094: --
1095: -- Delete/clear ranges from ben_batch_ranges table
1096: --
1097: Delete from ben_batch_ranges
1098: Where benefit_action_id = l_benefit_action_id;
1099: --

Line 1097: Delete from ben_batch_ranges

1093: end if;
1094: --
1095: -- Delete/clear ranges from ben_batch_ranges table
1096: --
1097: Delete from ben_batch_ranges
1098: Where benefit_action_id = l_benefit_action_id;
1099: --
1100: -- Now lets create person actions for all the people we are going to process
1101: --

Line 1164: Ben_batch_ranges_api.create_batch_ranges

1160: If l_num_row = l_chunk_size then
1161: --
1162: -- Create a range of data to be multithreaded.
1163: --
1164: Ben_batch_ranges_api.create_batch_ranges
1165: (p_validate => false
1166: ,p_benefit_action_id => l_benefit_action_id
1167: ,p_range_id => l_range_id
1168: ,p_range_status_cd => 'U'

Line 1191: Ben_batch_ranges_api.create_batch_ranges

1187: hr_utility.set_location('l_num_row='||to_char(l_num_row),18);
1188: --
1189: If l_num_row <> 0 then
1190: --
1191: Ben_batch_ranges_api.create_batch_ranges
1192: (p_validate => false
1193: ,p_benefit_action_id => l_benefit_action_id
1194: ,p_range_id => l_range_id
1195: ,p_range_status_cd => 'U'