[Home] [Help]
977: 22-Dec-03 Indrasen 115.333 CWBGLOBAL New Procedure
978: 10-Jan-04 tjesumic 115.334 new cursor c9 added in check_business_rule to validate
979: the cwb task for the budget flag
980: 20-Jan-04 ikasire 115.335/338 ben_pep_cache.clear_down_cache called after call to
981: ben_enrolment_requirements.update_defaults as it uses
982: a different effective date
983: 21-Jan-04 ikasire 115.339 Added p_trace_plans_flag to CWBGLOBAL procedure
984:
985: 02-Feb-04 pbodla 115.340 GLOBALCWB : Error
1123: 15-Feb-10 krupani 120.28.12010000.10 Bug 10350428: While processing IREC life event, date tracked assignment
1124: record columns were getting updated with current assignment record.
1125: Fixed the same.
1126: 27-Apr-11 krupani 120.28.12010000.11 Bug 12360677 : Forward port of 11i bug 12354919
1127: 07-Jul-11 velvanop 120.28.12010000.12 Bug 12711900 : Commented ben_enrolment_requirements.g_auto_choice_created check. Profile 'Ben:Check Enrollment limits' should be validated
1128: even though automatic enrollments are assigned for Life Event. Only when there is no electability
1129: profile validation should happen
1130: 13-Sep-11 usaraswa 120.28.12010000.13 Bug 12715758 : In Process_comp_objects while calling ben_comp_obj_filter.filter_comp_objects sending
1131: p_effective_date instead of nvl(l_rec.lf_evt_ocrd_dt,p_effective_date).
4420: -- Now get the manager for l_mgr_person_id.
4421: --
4422: -- But 2172036 addition of assignment_id to epe
4423: --
4424: ben_enrolment_requirements.get_cwb_manager_and_assignment(
4425: p_person_id => l_mgr_person_id,
4426: p_hrchy_to_use_cd =>
4427: ben_enrolment_requirements.g_ple_hrchy_to_use_cd,
4428: p_pos_structure_version_id =>
4423: --
4424: ben_enrolment_requirements.get_cwb_manager_and_assignment(
4425: p_person_id => l_mgr_person_id,
4426: p_hrchy_to_use_cd =>
4427: ben_enrolment_requirements.g_ple_hrchy_to_use_cd,
4428: p_pos_structure_version_id =>
4429: ben_enrolment_requirements.g_ple_pos_structure_version_id,
4430: p_effective_date => l_effective_date,
4431: p_manager_id => l_mgr_person_id_temp,
4425: p_person_id => l_mgr_person_id,
4426: p_hrchy_to_use_cd =>
4427: ben_enrolment_requirements.g_ple_hrchy_to_use_cd,
4428: p_pos_structure_version_id =>
4429: ben_enrolment_requirements.g_ple_pos_structure_version_id,
4430: p_effective_date => l_effective_date,
4431: p_manager_id => l_mgr_person_id_temp,
4432: p_assignment_id => l_assignment_id );
4433: --
4932: --
4933: -- Now get the manager for l_mgr_person_id.
4934: --
4935:
4936: --l_mgr_person_id_temp := ben_enrolment_requirements.get_manager_id(
4937: -- p_person_id => l_mgr_person_id,
4938: -- p_hrchy_to_use_cd =>
4939: -- ben_enrolment_requirements.g_ple_hrchy_to_use_cd,
4940: -- p_pos_structure_version_id =>
4935:
4936: --l_mgr_person_id_temp := ben_enrolment_requirements.get_manager_id(
4937: -- p_person_id => l_mgr_person_id,
4938: -- p_hrchy_to_use_cd =>
4939: -- ben_enrolment_requirements.g_ple_hrchy_to_use_cd,
4940: -- p_pos_structure_version_id =>
4941: -- ben_enrolment_requirements.g_ple_pos_structure_version_id,
4942: -- p_effective_date => l_effective_date);
4943:
4937: -- p_person_id => l_mgr_person_id,
4938: -- p_hrchy_to_use_cd =>
4939: -- ben_enrolment_requirements.g_ple_hrchy_to_use_cd,
4940: -- p_pos_structure_version_id =>
4941: -- ben_enrolment_requirements.g_ple_pos_structure_version_id,
4942: -- p_effective_date => l_effective_date);
4943:
4944: -- But 2172036 addition of assignment_id to epe
4945: --
4942: -- p_effective_date => l_effective_date);
4943:
4944: -- But 2172036 addition of assignment_id to epe
4945: --
4946: ben_enrolment_requirements.get_cwb_manager_and_assignment(
4947: p_person_id => l_mgr_person_id,
4948: p_hrchy_to_use_cd =>
4949: ben_enrolment_requirements.g_ple_hrchy_to_use_cd,
4950: p_pos_structure_version_id =>
4945: --
4946: ben_enrolment_requirements.get_cwb_manager_and_assignment(
4947: p_person_id => l_mgr_person_id,
4948: p_hrchy_to_use_cd =>
4949: ben_enrolment_requirements.g_ple_hrchy_to_use_cd,
4950: p_pos_structure_version_id =>
4951: ben_enrolment_requirements.g_ple_pos_structure_version_id,
4952: p_effective_date => l_effective_date,
4953: p_manager_id => l_mgr_person_id_temp,
4947: p_person_id => l_mgr_person_id,
4948: p_hrchy_to_use_cd =>
4949: ben_enrolment_requirements.g_ple_hrchy_to_use_cd,
4950: p_pos_structure_version_id =>
4951: ben_enrolment_requirements.g_ple_pos_structure_version_id,
4952: p_effective_date => l_effective_date,
4953: p_manager_id => l_mgr_person_id_temp,
4954: p_assignment_id => l_assignment_id );
4955: --
10031: end if;
10032: --
10033: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
10034: fnd_message.set_token('PROC','benutils.get_batch_parameters');
10035: ben_enrolment_requirements.g_electable_choice_created := false;
10036: ben_enrolment_requirements.g_any_choice_created := false;
10037: ben_enrolment_requirements.g_auto_choice_created := false;
10038: ben_determine_dpnt_eligibility.g_dpnt_ineligible := false;
10039: --
10032: --
10033: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
10034: fnd_message.set_token('PROC','benutils.get_batch_parameters');
10035: ben_enrolment_requirements.g_electable_choice_created := false;
10036: ben_enrolment_requirements.g_any_choice_created := false;
10037: ben_enrolment_requirements.g_auto_choice_created := false;
10038: ben_determine_dpnt_eligibility.g_dpnt_ineligible := false;
10039: --
10040: elsif l_param_rec.lmt_prpnip_by_org_flag = 'Y'
10033: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
10034: fnd_message.set_token('PROC','benutils.get_batch_parameters');
10035: ben_enrolment_requirements.g_electable_choice_created := false;
10036: ben_enrolment_requirements.g_any_choice_created := false;
10037: ben_enrolment_requirements.g_auto_choice_created := false;
10038: ben_determine_dpnt_eligibility.g_dpnt_ineligible := false;
10039: --
10040: elsif l_param_rec.lmt_prpnip_by_org_flag = 'Y'
10041: and p_mode in ('A','P','S','T') then
11860: if g_debug then
11861: hr_utility.set_location (l_package||' FND Bf BENDENRR ',85);
11862: end if;
11863: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
11864: fnd_message.set_token('PROC','ben_enrolment_requirements');
11865: --
11866: -- p_mode changed to l_mode in following line by Gopal Venkataraman
11867: -- 3/27/01 bug 1636071
11868: --
11877: --
11878: if g_debug then
11879: hr_utility.set_location (l_package||' FND Af BENDENRR ',100);
11880: end if;
11881: ben_enrolment_requirements.enrolment_requirements
11882: (p_comp_obj_tree_row => l_comp_obj_tree_row
11883: -- p_mode changed to l_mode in following line by Gopal Venkataraman 3/27/01 bug 1636071
11884: ,p_run_mode => l_mode
11885: ,p_business_group_id => p_business_group_id
12016: hr_utility.set_location (l_package||' FND Bf BENDENRR ',86);
12017: hr_utility.set_location ('l_oipl_id' ||l_oipl_id,87);
12018: end if;
12019: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
12020: fnd_message.set_token('PROC','ben_enrolment_requirements');
12021: --
12022: ben_enrolment_requirements.enrolment_requirements
12023: (p_comp_obj_tree_row => l_comp_obj_tree_row
12024: ,p_run_mode => 'U' --l_mode
12018: end if;
12019: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
12020: fnd_message.set_token('PROC','ben_enrolment_requirements');
12021: --
12022: ben_enrolment_requirements.enrolment_requirements
12023: (p_comp_obj_tree_row => l_comp_obj_tree_row
12024: ,p_run_mode => 'U' --l_mode
12025: ,p_business_group_id => p_business_group_id
12026: ,p_effective_date => p_effective_date
12282: --
12283: -- If defaults have changed due to deenrollments then
12284: -- check to see if choice defaults have changed.
12285: --
12286: if ben_enrolment_requirements.g_any_choice_created then
12287: if l_mode <> 'D' then
12288: ben_enrolment_requirements.update_defaults
12289: (p_run_mode => l_mode
12290: ,p_business_group_id => p_business_group_id
12284: -- check to see if choice defaults have changed.
12285: --
12286: if ben_enrolment_requirements.g_any_choice_created then
12287: if l_mode <> 'D' then
12288: ben_enrolment_requirements.update_defaults
12289: (p_run_mode => l_mode
12290: ,p_business_group_id => p_business_group_id
12291: ,p_effective_date => p_effective_date
12292: ,p_lf_evt_ocrd_dt => l_rec.lf_evt_ocrd_dt
12343: -- Clear electability caches
12344: --
12345: ben_epe_cache.clear_down_cache;
12346: --
12347: -- Clear Elig per Cache as ben_enrolment_requirements.update_defaults
12348: -- build the cache for previous eligibility.
12349: -- And in the benrates we need the current elig records.
12350: --
12351: ben_pep_cache.clear_down_cache;
12357: -- Do premium stuff if choices are created.
12358: --
12359: -- CWB Changes. ABSENCES ,GRADE/STEP : No need to run premium logic
12360: --
12361: if ben_enrolment_requirements.g_any_choice_created
12362: and l_mode not in( 'W', 'M', 'G','I','D') -- added irec
12363: then
12364: if g_debug then
12365: hr_utility.set_location (l_package||'.ben_determine_actual_premium ',10);
12537: --
12538: if g_debug then
12539: hr_utility.set_location ('BENAUTEN '||l_package,10);
12540: end if;
12541: if ben_enrolment_requirements.g_auto_choice_created
12542: and l_mode not in ('W','D')
12543: then
12544: ben_automatic_enrollments.main(
12545: p_person_id => p_person_id,
12691: -- ABSENCES : Close the life event.
12692: --
12693: if l_mode = 'L' or l_mode = 'C' or l_mode = 'M' then
12694: if (p_ler_id is not null and
12695: not ben_enrolment_requirements.g_electable_choice_created
12696: /*Bug 12711900 : Commented below condition. Profile 'Ben:Check Enrollment limits' should be validated
12697: even though automatic enrollments are assigned for Life Event. Only when there is no electability
12698: profile validation should happen*/
12699: -- and not ben_enrolment_requirements.g_auto_choice_created
12695: not ben_enrolment_requirements.g_electable_choice_created
12696: /*Bug 12711900 : Commented below condition. Profile 'Ben:Check Enrollment limits' should be validated
12697: even though automatic enrollments are assigned for Life Event. Only when there is no electability
12698: profile validation should happen*/
12699: -- and not ben_enrolment_requirements.g_auto_choice_created
12700: ) or (l_mode = 'M')
12701: then
12702: --
12703: -- Set life event to processed, only update the per_in_ler_stat_cd
12722: end if;
12723:
12724: /* Bug 12711900 : If there is no electability life event will directly move to Processed state. So calling
12725: benutils.get_active_life_event will not return life event. Added below code to get the Life event details*/
12726: if(not ben_enrolment_requirements.g_electable_choice_created) then
12727: hr_utility.set_location('Getting pil_id ',10);
12728: declare
12729: cursor c_get_pil_id is
12730: select pil.per_in_ler_id,
12853: --
12854: end if;
12855: --
12856: if (p_ler_id is not null and
12857: ben_enrolment_requirements.g_electable_choice_created ) or
12858: l_mode = 'M' -- ABSENCES : close life event in absences mode.
12859: then
12860: open c_pil_elctbl_chc_popl(l_rec.per_in_ler_id);
12861: loop
12880: --
12881: -- CWB Changes. -- ABSENCES : no restore logic.
12882: -- added irec
12883: if g_bckdt_per_in_ler_id is not null and
12884: ben_enrolment_requirements.g_electable_choice_created and
12885: l_mode not in ('W', 'M','I','D')
12886: then
12887: --
12888: ben_lf_evt_clps_restore.p_lf_evt_clps_restore
12927: --
12928: --- # 2899702 if the setup is autoenrollment Person Type usages are not create
12929: --- because the multi edit is not called , Person Type usages created in multiedit
12930: --- this is called for autoenrollment to created person type usaged
12931: if ben_enrolment_requirements.g_auto_choice_created
12932: and l_mode <> 'W' then
12933:
12934: ben_prtt_enrt_result_api.g_enrollment_change := true ;
12935: end if ;