[Home] [Help]
2608: select rge.chunk_number,
2609: rge.starting_person_id,
2610: rge.ending_person_id
2611: into range_info
2612: from pay_population_ranges rge
2613: where rge.payroll_action_id = p_info.pact_id
2614: and rge.range_status = 'U'
2615: and rownum < 2
2616: for update of rge.chunk_number;
2619: hr_utility.set_location(c_indent, 3);
2620: end if;
2621: -- If we reach here, we have a range row
2622: -- and we therefore wish to lock it.
2623: update pay_population_ranges pop
2624: set pop.range_status = 'P'
2625: where pop.payroll_action_id = p_info.pact_id
2626: and pop.chunk_number = range_info.chunk_number;
2627: --
2841: -- this range row is finished with.
2842: if g_debug then
2843: hr_utility.set_location('assact_dml', 20);
2844: end if;
2845: delete from pay_population_ranges range
2846: where range.payroll_action_id = p_info.pact_id
2847: and range.chunk_number = range_info.chunk_number;
2848: --
2849: if g_debug then
3048: -- then insert a special row.
3049: if g_debug then
3050: hr_utility.set_location('single_thread_range', 10);
3051: end if;
3052: delete from pay_population_ranges range
3053: where range.payroll_action_id = l_payroll_action_id;
3054: --
3055: if g_debug then
3056: hr_utility.set_location('single_thread_range', 20);
3056: hr_utility.set_location('single_thread_range', 20);
3057: end if;
3058:
3059: if (p_info.object_type is null) then
3060: insert into pay_population_ranges (
3061: payroll_action_id,
3062: chunk_number,
3063: starting_person_id,
3064: ending_person_id,
3077: and act.payroll_action_id = pac.payroll_action_id
3078: and asg.assignment_id = act.assignment_id
3079: group by pac.payroll_action_id;
3080: else
3081: insert into pay_population_ranges (
3082: payroll_action_id,
3083: chunk_number,
3084: starting_person_id,
3085: ending_person_id,