[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.
102: p_score_tab(l_count).eligy_prfl_id := p_eligy_prfl_id;
103: p_score_tab(l_count).crit_tab_short_name := p_tab_short_name;
104: p_score_tab(l_count).crit_tab_pk_id := p_pk_id;
105: p_score_tab(l_count).computed_score := p_computed_score;
106: p_score_tab(l_count).benefit_action_id := benutils.g_benefit_action_id;
107:
108: hr_utility.set_location('Leaving: '||l_proc,10);
109:
110: end write;
2321: end if;
2322: --
2323: -- New param1 added for bug # 2679854
2324: l_output :=
2325: benutils.formula
2326: (p_formula_id => l_inst_dets(l_insttorrw_num).formula_id,
2327: p_assignment_id => p_assignment_id,
2328: p_business_group_id => p_business_group_id,
2329: p_pgm_id => p_pgm_id,
4208: --
4209: hr_utility.set_location('criteria #' || l_insttorrw_num,20);
4210: --
4211: if l_inst_dets(l_insttorrw_num).schedd_hrs_rl is not null then
4212: l_output := benutils.formula
4213: (p_formula_id => l_inst_dets(l_insttorrw_num).schedd_hrs_rl
4214: ,p_effective_date => nvl(p_lf_evt_ocrd_dt,p_effective_date)
4215: ,p_business_group_id => p_business_group_id
4216: ,p_assignment_id => p_assignment_id
4354: --
4355: if (l_normal_hours is not null
4356: and l_inst_dets(l_insttorrw_num).rounding_cd is not null) then
4357: --
4358: l_normal_hours := benutils.do_rounding
4359: (p_rounding_cd => l_inst_dets(l_insttorrw_num).rounding_cd
4360: ,p_rounding_rl => l_inst_dets(l_insttorrw_num).rounding_rl
4361: ,p_value => l_normal_hours
4362: ,p_effective_date => nvl(p_lf_evt_ocrd_dt
5585: fnd_message.raise_error;
5586: --
5587: end if;
5588: --
5589: l_outputs := benutils.formula
5590: (p_formula_id => l_inst_dets(l_count).formula_id,
5591: p_assignment_id => l_ass_rec.assignment_id,
5592: p_effective_date => p_effective_date,
5593: p_param1 => 'BEN_IV_RT_STRT_DT',
9103: and ITEM_NAME = 'ASSIGNMENT_ID'
9104: and usage = 'U';
9105: -- 4958846
9106: l_env_rec ben_env_object.g_global_env_rec_type;
9107: l_benmngle_parm_rec benutils.g_batch_param_rec;
9108: -- Procedure to assign overridden values
9109: --
9110: procedure assign_overriden_values
9111: (p_per_rec in out nocopy per_all_people_f%rowtype,
9538: -- Applicant assignment only
9539: --
9540: -- Bug 6509099
9541: ben_env_object.get(p_rec => l_env_rec);
9542: benutils.get_batch_parameters(p_benefit_action_id => l_env_rec.benefit_action_id
9543: ,p_rec => l_benmngle_parm_rec);
9544:
9545: if l_benmngle_parm_rec.mode_cd = 'I' then
9546: --
9572: --
9573: hr_utility.set_location('Getting all assignments',10);
9574: -- 4958846 ssarkar for irec
9575: ben_env_object.get(p_rec => l_env_rec);
9576: benutils.get_batch_parameters(p_benefit_action_id => l_env_rec.benefit_action_id
9577: ,p_rec => l_benmngle_parm_rec);
9578:
9579: hr_utility.set_location('l_benmngle_parm_rec.mode_cd :' || l_benmngle_parm_rec.mode_cd,99);
9580:
9661: -- Applicant assignment only
9662: --
9663: -- Bug 6509099
9664: ben_env_object.get(p_rec => l_env_rec);
9665: benutils.get_batch_parameters(p_benefit_action_id => l_env_rec.benefit_action_id
9666: ,p_rec => l_benmngle_parm_rec);
9667:
9668: if l_benmngle_parm_rec.mode_cd = 'I' then
9669: --