[Home] [Help]
2520: select rge.chunk_number,
2521: rge.starting_person_id,
2522: rge.ending_person_id
2523: into range_info
2524: from pay_population_ranges rge
2525: where rge.payroll_action_id = p_info.pact_id
2526: and rge.range_status = 'U'
2527: and rownum < 2
2528: for update of rge.chunk_number;
2531: hr_utility.set_location(c_indent, 3);
2532: end if;
2533: -- If we reach here, we have a range row
2534: -- and we therefore wish to lock it.
2535: update pay_population_ranges pop
2536: set pop.range_status = 'P'
2537: where pop.payroll_action_id = p_info.pact_id
2538: and pop.chunk_number = range_info.chunk_number;
2539: --
2720: -- this range row is finished with.
2721: if g_debug then
2722: hr_utility.set_location('assact_dml', 20);
2723: end if;
2724: delete from pay_population_ranges range
2725: where range.payroll_action_id = p_info.pact_id
2726: and range.chunk_number = range_info.chunk_number;
2727: --
2728: if g_debug then
2927: -- then insert a special row.
2928: if g_debug then
2929: hr_utility.set_location('single_thread_range', 10);
2930: end if;
2931: delete from pay_population_ranges range
2932: where range.payroll_action_id = l_payroll_action_id;
2933: --
2934: if g_debug then
2935: hr_utility.set_location('single_thread_range', 20);
2935: hr_utility.set_location('single_thread_range', 20);
2936: end if;
2937:
2938: if (p_info.object_type is null) then
2939: insert into pay_population_ranges (
2940: payroll_action_id,
2941: chunk_number,
2942: starting_person_id,
2943: ending_person_id,
2956: and act.payroll_action_id = pac.payroll_action_id
2957: and asg.assignment_id = act.assignment_id
2958: group by pac.payroll_action_id;
2959: else
2960: insert into pay_population_ranges (
2961: payroll_action_id,
2962: chunk_number,
2963: starting_person_id,
2964: ending_person_id,