[Home] [Help]
85: 115.21 20-Aug-2001 stee Bug 1348235: Fix duplicate qual bnf row
86: when a dependent is added after the initial
87: qualifying event.
88: 115.22 29-Aug-2001 pbodla bug:1949361 jurisdiction code is
89: derived inside benutils.formula
90: 115.23 30-NOV-2001 stee Back out nocopy changes made in version 115.20.
91: The c_get_max_poe cursor may retrieve
92: the wrong period of enrollment if COBRA
93: by plan type is implemented. Also, for
159: 115.49 28-dec-2005 stee Only terminate cobra eligibility in chk_cobra_eligibility
160: if the person was previously enrolled in COBRA
161: benefits. Bug 4338471.
162: 115.50 15-Feb-2005 bmanyam 4881917 PERF Fix: XBuild1 Drop
163: 115.51 30-Jun-2006 swjain 5331889 Added person_id param to benutils.formula call in
164: 115.52 08-Nov-2006 stee When creating quald_bnf for a dependent, get
165: the cvrd_emp_person_id with a person type
166: usage of 'PRTN'.
167: 115.53 22-Feb-2008 rtagarra Bug 6840074
690: close c_pgm_ptip;
691: end if;
692: --
693: l_outputs :=
694: benutils.formula
695: -- RCHASE wwbug 1480395 pass mx_poe_det_dt_rl
696: (p_formula_id => l_poe_rec.mx_poe_det_dt_rl, --l_poe_rec.mx_poe_rl,
697: p_effective_date => p_lf_evt_ocrd_dt,
698: p_assignment_id => l_state_rec.assignment_id,
977: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
978: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
979: fnd_message.set_token('LF_EVT_OCRD_DT',to_char(p_lf_evt_ocrd_dt));
980: if fnd_global.conc_request_id <> -1 then
981: benutils.write(fnd_message.get);
982: end if;
983: end if;
984: --
985: else
994: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
995: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
996: fnd_message.set_token('LF_EVT_OCRD_DT',to_char(p_lf_evt_ocrd_dt));
997: if fnd_global.conc_request_id <> -1 then
998: benutils.write(fnd_message.get);
999: end if;
1000: end if;
1001: close c_get_init_ler;
1002: --
1083: fetch c_regn into l_regn_id;
1084: close c_regn;
1085: --
1086: l_outputs :=
1087: benutils.formula
1088: (p_formula_id => p_mx_poe_rl,
1089: p_effective_date => p_effective_date,
1090: p_assignment_id => l_state_rec.assignment_id,
1091: p_organization_id => l_state_rec.organization_id,
1104: --
1105: hr_utility.set_location('p_cbr_elig_perd_strt_dt : ' || p_cbr_elig_perd_strt_dt, 10);
1106: hr_utility.set_location('p_mx_poe_uom : ' || p_mx_poe_uom, 10);
1107: hr_utility.set_location('p_mx_poe_val : ' || p_mx_poe_val, 10);
1108: l_return_date := benutils.derive_date
1109: (p_date => p_cbr_elig_perd_strt_dt
1110: ,p_uom => p_mx_poe_uom
1111: ,p_min => null
1112: ,p_max => p_mx_poe_val
1534: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1535: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
1536: fnd_message.set_token('LF_EVT_OCRD_DT',to_char(p_lf_evt_ocrd_dt));
1537: if fnd_global.conc_request_id <> -1 then
1538: benutils.write(fnd_message.get);
1539: end if;
1540: --
1541: end if;
1542: l_pgm_id := l_epe_rec.pgm_id;
1607: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
1608: fnd_message.set_token('LF_EVT_OCRD_DT',to_char(p_lf_evt_ocrd_dt));
1609: --
1610: if fnd_global.conc_request_id <> -1 then
1611: benutils.write(fnd_message.get);
1612: end if;
1613: end if;
1614: --
1615: l_ptip_id := l_epe_rec.ptip_id;
3435: if (p_rndg_cd is not null or
3436: p_rndg_rl is not null) and
3437: p_amount is not null then
3438: --
3439: l_return_amt := benutils.do_rounding
3440: (p_rounding_cd => p_rndg_cd,
3441: p_rounding_rl => p_rndg_rl,
3442: p_value => p_amount,
3443: p_effective_date => p_effective_date);