[Home] [Help]
1510: l_person_id ben_person_actions.person_id%type;
1511: l_person_action_id ben_person_actions.person_action_id%type;
1512: l_object_version_number ben_person_actions.object_version_number%type;
1513: l_ler_id ben_person_actions.ler_id%type;
1514: l_range_id ben_batch_ranges.range_id%type;
1515: l_record_number number := 0;
1516: l_start_person_action_id number := 0;
1517: l_end_person_action_id number := 0;
1518: l_actn varchar2(80);
1527: is
1528: select ran.range_id
1529: ,ran.starting_person_action_id
1530: ,ran.ending_person_action_id
1531: from ben_batch_ranges ran
1532: where ran.range_status_cd = 'U'
1533: and ran.benefit_action_id = p_benefit_action_id
1534: and rownum < 2
1535: for update of ran.range_status_cd;
1648: close c_range_thread;
1649: --
1650: -- Update the range status code to processed 'P'
1651: --
1652: update ben_batch_ranges ran
1653: set ran.range_status_cd = 'P'
1654: where ran.range_id = l_range_id;
1655: --
1656: hr_utility.set_location('Updated range ' || to_char(l_range_id) ||
2192: benutils.g_thread_id := 99;
2193: --
2194: l_actn := 'Removing batch ranges ';
2195: --
2196: delete from ben_batch_ranges
2197: where benefit_action_id = l_benefit_action_id;
2198: --
2199: -- Loop through rows in ben_per_in_ler_f based on the parameters passed and
2200: -- create person actions for the selected people.
2262: --
2263: -- The number of person actions that got created equals the chunk
2264: -- size. Create a batch range for the person actions.
2265: --
2266: ben_batch_ranges_api.create_batch_ranges
2267: (p_validate => FALSE
2268: ,p_effective_date => l_effective_date
2269: ,p_benefit_action_id => l_benefit_action_id
2270: ,p_range_id => l_range_id
2289: --
2290: if l_person_actn_cnt > 0 and
2291: mod(l_person_actn_cnt, l_chunk_size) <> 0 then
2292: --
2293: ben_batch_ranges_api.create_batch_ranges
2294: (p_validate => FALSE
2295: ,p_effective_date => l_effective_date
2296: ,p_benefit_action_id => l_benefit_action_id
2297: ,p_range_id => l_range_id