[Home] [Help]
437: benutils.g_thread_id := 99;
438: --
439: l_actn := 'Removing batch ranges ';
440: --
441: delete from ben_batch_ranges
442: where benefit_action_id = l_benefit_action_id;
443:
444: hr_utility.set_location ('Before c_person',11);
445: for l_rec in c_person
509: --
510: -- The number of person actions that got created equals the chunk
511: -- size. Create a batch range for the person actions.
512: --
513: ben_batch_ranges_api.create_batch_ranges
514: (p_validate => FALSE
515: ,p_effective_date => l_effective_date
516: ,p_benefit_action_id => l_benefit_action_id
517: ,p_range_id => l_range_id
536: --
537: if l_person_actn_cnt > 0 and
538: mod(l_person_actn_cnt, l_chunk_size) <> 0 then
539: --
540: ben_batch_ranges_api.create_batch_ranges
541: (p_validate => FALSE
542: ,p_effective_date => l_effective_date
543: ,p_benefit_action_id => l_benefit_action_id
544: ,p_range_id => l_range_id
806: l_person_id ben_person_actions.person_id%type;
807: l_person_action_id ben_person_actions.person_action_id%type;
808: l_object_version_number ben_person_actions.object_version_number%type;
809: l_ler_id ben_person_actions.ler_id%type;
810: l_range_id ben_batch_ranges.range_id%type;
811: l_record_number number := 0;
812: l_start_person_action_id number := 0;
813: l_end_person_action_id number := 0;
814: l_actn varchar2(80);
823: is
824: select ran.range_id
825: ,ran.starting_person_action_id
826: ,ran.ending_person_action_id
827: from ben_batch_ranges ran
828: where ran.range_status_cd = 'U'
829: and ran.benefit_action_id = p_benefit_action_id
830: and rownum < 2
831: for update of ran.range_status_cd;
969: close c_range_thread;
970: --
971: -- Update the range status code to processed 'P'
972: --
973: update ben_batch_ranges ran
974: set ran.range_status_cd = 'P'
975: where ran.range_id = l_range_id;
976: --
977: hr_utility.set_location('Updated range ' || to_char(l_range_id) ||