[Home] [Help]
278: be calculated irrespective of whether calculate for
279: enrollment flag is checked or not
280: 11-Oct-2002 vsethi 115.113 Rates Sequence no enhancements. Modified to cater
281: to new column ord_num on ben_acty_base_rt_f
282: 24-Oct-2002 shdas 115.114 Added ben_env_object.init to main_w
283: 13-Nov-2002 vsethi 115.115 Bug 1210355, if variable rate is detected the mlt code
284: attached to the variable profile should be displayed
285: for the rate
286: 09-DEC-2002 hnarayan 115.116 Bug 2691169 - added order by clause to cursor c_asg
1175: l_cvg_eff_dt date;
1176: l_fonm_rt_strt_dt date;
1177:
1178: -- Getting mode for bug 3274902
1179: l_env ben_env_object.g_global_env_rec_type;
1180: l_mode l_env.mode_cd%TYPE;
1181: l_prv_rt_strt_dt date; -- 5748126
1182: l_prv_rt_end_dt date; -- 5748126
1183:
2016: hr_utility.set_location (' Checking acty base rate values ',60);
2017: --
2018: -- cwb now allows null values for min/max/incrmt so no need to validate
2019: --
2020: ben_env_object.get(p_rec => l_env);
2021: if (l_abr.entr_val_at_enrt_flag = 'Y' and l_abr.entr_ann_val_flag = 'N')
2022: and nvl(l_env.mode_cd,'~') <> 'W' then
2023:
2024: if l_abr.mn_elcn_val is null then
2118: --
2119: -- get the dflt_enrt_cd/rule
2120: --
2121: hr_utility.set_location ('BER_DDEC '||l_package,10);
2122: ben_env_object.get(p_rec => l_env);
2123: hr_utility.set_location('l_env.mode_cd' || l_env.mode_cd,13);
2124: if nvl(l_env.mode_cd,'~') <> 'D' then --cant set this code in 'D' Plans -- ICM
2125: --
2126: ben_enrolment_requirements.determine_dflt_enrt_cd
3845: -- As a workaround to fix the issue with minimal code impact, p_iss_val paramter
3846: -- has been chosen and the l_cmcd_dflt val has been returned in the p_iss_val
3847: -- We here check that the mode is not CWB since CWB only uses iss_val
3848:
3849: ben_env_object.get(p_rec => l_env);
3850: hr_utility.set_location(' ben_env_object: Mode ' || l_env.mode_cd, 10);
3851:
3852: if l_env.mode_cd <> 'W' and p_iss_val is null then
3853: p_iss_val := l_cmcd_dflt_val ;
3846: -- has been chosen and the l_cmcd_dflt val has been returned in the p_iss_val
3847: -- We here check that the mode is not CWB since CWB only uses iss_val
3848:
3849: ben_env_object.get(p_rec => l_env);
3850: hr_utility.set_location(' ben_env_object: Mode ' || l_env.mode_cd, 10);
3851:
3852: if l_env.mode_cd <> 'W' and p_iss_val is null then
3853: p_iss_val := l_cmcd_dflt_val ;
3854: end if;
4169: --
4170: hr_utility.set_location('l_trace_param : '|| l_trace_param, 5);
4171: hr_utility.set_location ('Entering '||l_package,10);
4172: --
4173: ben_env_object.init(p_business_group_id => p_business_group_id,
4174: p_effective_date => p_effective_date,
4175: p_thread_id => 1,
4176: p_chunk_size => 1,
4177: p_threads => 1,