[Home] [Help]
693: ) is
694: -- Local variable declaration
695: --
696: l_proc varchar2(80) := g_package||'.do_multithread';
697: l_person_id ben_person_actions.person_id%type;
698: l_person_action_id ben_person_actions.person_action_id%type;
699: l_object_version_number ben_person_actions.object_version_number%type;
700: l_ler_id ben_person_actions.ler_id%type;
701: l_range_id ben_batch_ranges.range_id%type;
694: -- Local variable declaration
695: --
696: l_proc varchar2(80) := g_package||'.do_multithread';
697: l_person_id ben_person_actions.person_id%type;
698: l_person_action_id ben_person_actions.person_action_id%type;
699: l_object_version_number ben_person_actions.object_version_number%type;
700: l_ler_id ben_person_actions.ler_id%type;
701: l_range_id ben_batch_ranges.range_id%type;
702: l_record_number number := 0;
695: --
696: l_proc varchar2(80) := g_package||'.do_multithread';
697: l_person_id ben_person_actions.person_id%type;
698: l_person_action_id ben_person_actions.person_action_id%type;
699: l_object_version_number ben_person_actions.object_version_number%type;
700: l_ler_id ben_person_actions.ler_id%type;
701: l_range_id ben_batch_ranges.range_id%type;
702: l_record_number number := 0;
703: l_start_person_action_id number := 0;
696: l_proc varchar2(80) := g_package||'.do_multithread';
697: l_person_id ben_person_actions.person_id%type;
698: l_person_action_id ben_person_actions.person_action_id%type;
699: l_object_version_number ben_person_actions.object_version_number%type;
700: l_ler_id ben_person_actions.ler_id%type;
701: l_range_id ben_batch_ranges.range_id%type;
702: l_record_number number := 0;
703: l_start_person_action_id number := 0;
704: l_end_person_action_id number := 0;
727: --
728: cursor c_person_thread is
729: select ben.person_id,
730: ben.person_action_id
731: from ben_person_actions ben
732: where ben.benefit_action_id = p_benefit_action_id
733: and ben.action_status_cd not in ('P','E')
734: and ben.person_action_id
735: between l_start_person_action_id
1011: close c_ler_thread;
1012: --
1013: -- If we get here it was successful.
1014: --
1015: update ben_person_actions
1016: set action_status_cd = 'P'
1017: where person_id = l_person_id
1018: and benefit_action_id = p_benefit_action_id;
1019: --
1042: --
1043: rollback to last_place;
1044: benutils.rollback_cache;
1045: --
1046: update ben_person_actions
1047: set action_status_cd = 'E'
1048: where person_id = l_person_id
1049: and benefit_action_id = p_benefit_action_id;
1050: --
1169: l_request_id number;
1170: l_benefit_action_id ben_benefit_actions.benefit_action_id%type;
1171: l_object_version_number ben_benefit_actions.object_version_number%type;
1172: l_person_id per_people_f.person_id%type;
1173: l_person_action_id ben_person_actions.person_action_id%type;
1174: l_ler_id ben_ler_f.ler_id%type;
1175: l_range_id ben_batch_ranges.range_id%type;
1176: l_chunk_size number := 20;
1177: l_threads number := 1;
1247: -- Bug 4758468 : join condition is missing in c_group_pils.
1248:
1249: cursor c_group_pils(cv_group_bg_id in number) is
1250: Select pil.per_in_ler_id
1251: from ben_person_actions act,
1252: ben_per_in_ler pil
1253: where act.benefit_action_id = l_benefit_action_id
1254: and act.action_status_cd = 'P'
1255: and act.person_id = pil.person_id
1433: --
1434: If l_person_ok = 'Y' then
1435: --
1436: hr_utility.set_location ('person passed selection rule '||l_person_id,35);
1437: Ben_person_actions_api.create_person_actions
1438: (p_validate => false
1439: ,p_person_action_id => l_person_action_id
1440: ,p_person_id => l_person_id
1441: ,p_ler_id => l_ler_id