[Home] [Help]
1470: l_person_id ben_person_actions.person_id%type;
1471: l_person_action_id ben_person_actions.person_action_id%type;
1472: l_object_version_number ben_person_actions.object_version_number%type;
1473: l_ler_id ben_person_actions.ler_id%type;
1474: l_range_id ben_batch_ranges.range_id%type;
1475: l_record_number number := 0;
1476: l_start_person_action_id number := 0;
1477: l_end_person_action_id number := 0;
1478: l_actn varchar2(80);
1487: is
1488: select ran.range_id
1489: ,ran.starting_person_action_id
1490: ,ran.ending_person_action_id
1491: from ben_batch_ranges ran
1492: where ran.range_status_cd = 'U'
1493: and ran.benefit_action_id = p_benefit_action_id
1494: and rownum < 2
1495: for update of ran.range_status_cd;
1608: close c_range_thread;
1609: --
1610: -- Update the range status code to processed 'P'
1611: --
1612: update ben_batch_ranges ran
1613: set ran.range_status_cd = 'P'
1614: where ran.range_id = l_range_id;
1615: --
1616: hr_utility.set_location('Updated range ' || to_char(l_range_id) ||
2152: benutils.g_thread_id := 99;
2153: --
2154: l_actn := 'Removing batch ranges ';
2155: --
2156: delete from ben_batch_ranges
2157: where benefit_action_id = l_benefit_action_id;
2158: --
2159: -- Loop through rows in ben_per_in_ler_f based on the parameters passed and
2160: -- create person actions for the selected people.
2222: --
2223: -- The number of person actions that got created equals the chunk
2224: -- size. Create a batch range for the person actions.
2225: --
2226: ben_batch_ranges_api.create_batch_ranges
2227: (p_validate => FALSE
2228: ,p_effective_date => l_effective_date
2229: ,p_benefit_action_id => l_benefit_action_id
2230: ,p_range_id => l_range_id
2249: --
2250: if l_person_actn_cnt > 0 and
2251: mod(l_person_actn_cnt, l_chunk_size) <> 0 then
2252: --
2253: ben_batch_ranges_api.create_batch_ranges
2254: (p_validate => FALSE
2255: ,p_effective_date => l_effective_date
2256: ,p_benefit_action_id => l_benefit_action_id
2257: ,p_range_id => l_range_id