[Home] [Help]
55: 24-jan-06 ssarkar 115.24 Bug 4958846 : Eligibilty fix for only IREC.
56: 20-Apr-06 bmanyam 115.25 Bug 5173693 : Numeric Value error in benmngle.g_output string.
57: Truncated the string
58: 09-May-06 gsehgal 115.26 Bug 4558945 : change get_quartile to ben_cwb_person_info_pkg.get_grd_quartile
59: 27-Jun-06 swjain 115.27 Bug 5331889 : Added person_id in call to benutils.formula in procedure check_rule_elig
60: 25-Sep-06 stee 115.28 Bug 5550851 : Fix check_elig_dpnt_cvrd_othr_pgm cursor
61: to use the calculated date to determine
62: eligibility instead of the fonm date.
63: 07-Sep-07 rtagarra 115.29 Bug 6399423 : Used proper variable for Assignment checking for FONM case.
91: p_score_tab(l_count).eligy_prfl_id := p_eligy_prfl_id;
92: p_score_tab(l_count).crit_tab_short_name := p_tab_short_name;
93: p_score_tab(l_count).crit_tab_pk_id := p_pk_id;
94: p_score_tab(l_count).computed_score := p_computed_score;
95: p_score_tab(l_count).benefit_action_id := benutils.g_benefit_action_id;
96:
97: hr_utility.set_location('Leaving: '||l_proc,10);
98:
99: end write;
2310: end if;
2311: --
2312: -- New param1 added for bug # 2679854
2313: l_output :=
2314: benutils.formula
2315: (p_formula_id => l_inst_dets(l_insttorrw_num).formula_id,
2316: p_assignment_id => p_assignment_id,
2317: p_business_group_id => p_business_group_id,
2318: p_pgm_id => p_pgm_id,
4197: --
4198: hr_utility.set_location('criteria #' || l_insttorrw_num,20);
4199: --
4200: if l_inst_dets(l_insttorrw_num).schedd_hrs_rl is not null then
4201: l_output := benutils.formula
4202: (p_formula_id => l_inst_dets(l_insttorrw_num).schedd_hrs_rl
4203: ,p_effective_date => nvl(p_lf_evt_ocrd_dt,p_effective_date)
4204: ,p_business_group_id => p_business_group_id
4205: ,p_assignment_id => p_assignment_id
4343: --
4344: if (l_normal_hours is not null
4345: and l_inst_dets(l_insttorrw_num).rounding_cd is not null) then
4346: --
4347: l_normal_hours := benutils.do_rounding
4348: (p_rounding_cd => l_inst_dets(l_insttorrw_num).rounding_cd
4349: ,p_rounding_rl => l_inst_dets(l_insttorrw_num).rounding_rl
4350: ,p_value => l_normal_hours
4351: ,p_effective_date => nvl(p_lf_evt_ocrd_dt
5573: fnd_message.raise_error;
5574: --
5575: end if;
5576: --
5577: l_outputs := benutils.formula
5578: (p_formula_id => l_inst_dets(l_count).formula_id,
5579: p_assignment_id => l_ass_rec.assignment_id,
5580: p_effective_date => p_effective_date,
5581: p_param1 => 'BEN_IV_RT_STRT_DT',
9084: and ITEM_NAME = 'ASSIGNMENT_ID'
9085: and usage = 'U';
9086: -- 4958846
9087: l_env_rec ben_env_object.g_global_env_rec_type;
9088: l_benmngle_parm_rec benutils.g_batch_param_rec;
9089: -- Procedure to assign overridden values
9090: --
9091: procedure assign_overriden_values
9092: (p_per_rec in out nocopy per_all_people_f%rowtype,
9519: -- Applicant assignment only
9520: --
9521: -- Bug 6509099
9522: ben_env_object.get(p_rec => l_env_rec);
9523: benutils.get_batch_parameters(p_benefit_action_id => l_env_rec.benefit_action_id
9524: ,p_rec => l_benmngle_parm_rec);
9525:
9526: if l_benmngle_parm_rec.mode_cd = 'I' then
9527: --
9553: --
9554: hr_utility.set_location('Getting all assignments',10);
9555: -- 4958846 ssarkar for irec
9556: ben_env_object.get(p_rec => l_env_rec);
9557: benutils.get_batch_parameters(p_benefit_action_id => l_env_rec.benefit_action_id
9558: ,p_rec => l_benmngle_parm_rec);
9559:
9560: hr_utility.set_location('l_benmngle_parm_rec.mode_cd :' || l_benmngle_parm_rec.mode_cd,99);
9561:
9642: -- Applicant assignment only
9643: --
9644: -- Bug 6509099
9645: ben_env_object.get(p_rec => l_env_rec);
9646: benutils.get_batch_parameters(p_benefit_action_id => l_env_rec.benefit_action_id
9647: ,p_rec => l_benmngle_parm_rec);
9648:
9649: if l_benmngle_parm_rec.mode_cd = 'I' then
9650: --