[Home] [Help]
618: ) is
619: -- Local variable declaration
620: --
621: l_proc varchar2(80) := g_package||'.do_multithread';
622: l_person_id ben_person_actions.person_id%type;
623: l_person_action_id ben_person_actions.person_action_id%type;
624: l_object_version_number ben_person_actions.object_version_number%type;
625: l_ler_id ben_person_actions.ler_id%type;
626: l_range_id ben_batch_ranges.range_id%type;
619: -- Local variable declaration
620: --
621: l_proc varchar2(80) := g_package||'.do_multithread';
622: l_person_id ben_person_actions.person_id%type;
623: l_person_action_id ben_person_actions.person_action_id%type;
624: l_object_version_number ben_person_actions.object_version_number%type;
625: l_ler_id ben_person_actions.ler_id%type;
626: l_range_id ben_batch_ranges.range_id%type;
627: l_record_number number := 0;
620: --
621: l_proc varchar2(80) := g_package||'.do_multithread';
622: l_person_id ben_person_actions.person_id%type;
623: l_person_action_id ben_person_actions.person_action_id%type;
624: l_object_version_number ben_person_actions.object_version_number%type;
625: l_ler_id ben_person_actions.ler_id%type;
626: l_range_id ben_batch_ranges.range_id%type;
627: l_record_number number := 0;
628: l_start_person_action_id number := 0;
621: l_proc varchar2(80) := g_package||'.do_multithread';
622: l_person_id ben_person_actions.person_id%type;
623: l_person_action_id ben_person_actions.person_action_id%type;
624: l_object_version_number ben_person_actions.object_version_number%type;
625: l_ler_id ben_person_actions.ler_id%type;
626: l_range_id ben_batch_ranges.range_id%type;
627: l_record_number number := 0;
628: l_start_person_action_id number := 0;
629: l_end_person_action_id number := 0;
652: --
653: cursor c_person_thread is
654: select ben.person_id,
655: ben.person_action_id
656: from ben_person_actions ben
657: where ben.benefit_action_id = p_benefit_action_id
658: and ben.action_status_cd not in ('P','E')
659: and ben.person_action_id
660: between l_start_person_action_id
936: close c_ler_thread;
937: --
938: -- If we get here it was successful.
939: --
940: update ben_person_actions
941: set action_status_cd = 'P'
942: where person_id = l_person_id
943: and benefit_action_id = p_benefit_action_id;
944: --
967: --
968: rollback to last_place;
969: benutils.rollback_cache;
970: --
971: update ben_person_actions
972: set action_status_cd = 'E'
973: where person_id = l_person_id
974: and benefit_action_id = p_benefit_action_id;
975: --
1093: l_request_id number;
1094: l_benefit_action_id ben_benefit_actions.benefit_action_id%type;
1095: l_object_version_number ben_benefit_actions.object_version_number%type;
1096: l_person_id per_people_f.person_id%type;
1097: l_person_action_id ben_person_actions.person_action_id%type;
1098: l_ler_id ben_ler_f.ler_id%type;
1099: l_range_id ben_batch_ranges.range_id%type;
1100: l_chunk_size number := 20;
1101: l_threads number := 1;
1168: -- Bug 4758468 : join condition is missing in c_group_pils.
1169:
1170: cursor c_group_pils(cv_group_bg_id in number) is
1171: Select pil.per_in_ler_id
1172: from ben_person_actions act,
1173: ben_per_in_ler pil
1174: where act.benefit_action_id = l_benefit_action_id
1175: and act.action_status_cd = 'P'
1176: and act.person_id = pil.person_id
1353: --
1354: If l_person_ok = 'Y' then
1355: --
1356: hr_utility.set_location ('person passed selection rule '||l_person_id,35);
1357: Ben_person_actions_api.create_person_actions
1358: (p_validate => false
1359: ,p_person_action_id => l_person_action_id
1360: ,p_person_id => l_person_id
1361: ,p_ler_id => l_ler_id