[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
1224: l_cvg_eff_dt date;
1225: l_fonm_rt_strt_dt date;
1226:
1227: -- Getting mode for bug 3274902
1228: l_env ben_env_object.g_global_env_rec_type;
1229: l_mode l_env.mode_cd%TYPE;
1230: l_prv_rt_strt_dt date; -- 5748126
1231: l_prv_rt_end_dt date; -- 5748126
1232: l_vapro_entr_val_at_enrt_flag varchar2(10) := 'N'; --11065081
2076: hr_utility.set_location (' Checking acty base rate values ',60);
2077: --
2078: -- cwb now allows null values for min/max/incrmt so no need to validate
2079: --
2080: ben_env_object.get(p_rec => l_env);
2081: if (l_abr.entr_val_at_enrt_flag = 'Y' and l_abr.entr_ann_val_flag = 'N')
2082: and nvl(l_env.mode_cd,'~') <> 'W' then
2083:
2084: if l_abr.mn_elcn_val is null then
2178: --
2179: -- get the dflt_enrt_cd/rule
2180: --
2181: hr_utility.set_location ('BER_DDEC '||l_package,10);
2182: ben_env_object.get(p_rec => l_env);
2183: hr_utility.set_location('l_env.mode_cd' || l_env.mode_cd,13);
2184: if nvl(l_env.mode_cd,'~') <> 'D' then --cant set this code in 'D' Plans -- ICM
2185: --
2186: ben_enrolment_requirements.determine_dflt_enrt_cd
4044: -- As a workaround to fix the issue with minimal code impact, p_iss_val paramter
4045: -- has been chosen and the l_cmcd_dflt val has been returned in the p_iss_val
4046: -- We here check that the mode is not CWB since CWB only uses iss_val
4047:
4048: ben_env_object.get(p_rec => l_env);
4049: hr_utility.set_location(' ben_env_object: Mode ' || l_env.mode_cd, 10);
4050:
4051: if l_env.mode_cd <> 'W' and p_iss_val is null then
4052: p_iss_val := l_cmcd_dflt_val ;
4045: -- has been chosen and the l_cmcd_dflt val has been returned in the p_iss_val
4046: -- We here check that the mode is not CWB since CWB only uses iss_val
4047:
4048: ben_env_object.get(p_rec => l_env);
4049: hr_utility.set_location(' ben_env_object: Mode ' || l_env.mode_cd, 10);
4050:
4051: if l_env.mode_cd <> 'W' and p_iss_val is null then
4052: p_iss_val := l_cmcd_dflt_val ;
4053: end if;
4368: --
4369: hr_utility.set_location('l_trace_param : '|| l_trace_param, 5);
4370: hr_utility.set_location ('Entering '||l_package,10);
4371: --
4372: ben_env_object.init(p_business_group_id => p_business_group_id,
4373: p_effective_date => p_effective_date,
4374: p_thread_id => 1,
4375: p_chunk_size => 1,
4376: p_threads => 1,