[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
672: close c_pgm_ptip;
673: end if;
674: --
675: l_outputs :=
676: benutils.formula
677: -- RCHASE wwbug 1480395 pass mx_poe_det_dt_rl
678: (p_formula_id => l_poe_rec.mx_poe_det_dt_rl, --l_poe_rec.mx_poe_rl,
679: p_effective_date => p_lf_evt_ocrd_dt,
680: p_assignment_id => l_state_rec.assignment_id,
959: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
960: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
961: fnd_message.set_token('LF_EVT_OCRD_DT',to_char(p_lf_evt_ocrd_dt));
962: if fnd_global.conc_request_id <> -1 then
963: benutils.write(fnd_message.get);
964: end if;
965: end if;
966: --
967: else
976: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
977: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
978: fnd_message.set_token('LF_EVT_OCRD_DT',to_char(p_lf_evt_ocrd_dt));
979: if fnd_global.conc_request_id <> -1 then
980: benutils.write(fnd_message.get);
981: end if;
982: end if;
983: close c_get_init_ler;
984: --
1065: fetch c_regn into l_regn_id;
1066: close c_regn;
1067: --
1068: l_outputs :=
1069: benutils.formula
1070: (p_formula_id => p_mx_poe_rl,
1071: p_effective_date => p_effective_date,
1072: p_assignment_id => l_state_rec.assignment_id,
1073: p_organization_id => l_state_rec.organization_id,
1086: --
1087: hr_utility.set_location('p_cbr_elig_perd_strt_dt : ' || p_cbr_elig_perd_strt_dt, 10);
1088: hr_utility.set_location('p_mx_poe_uom : ' || p_mx_poe_uom, 10);
1089: hr_utility.set_location('p_mx_poe_val : ' || p_mx_poe_val, 10);
1090: l_return_date := benutils.derive_date
1091: (p_date => p_cbr_elig_perd_strt_dt
1092: ,p_uom => p_mx_poe_uom
1093: ,p_min => null
1094: ,p_max => p_mx_poe_val
1449: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1450: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
1451: fnd_message.set_token('LF_EVT_OCRD_DT',to_char(p_lf_evt_ocrd_dt));
1452: if fnd_global.conc_request_id <> -1 then
1453: benutils.write(fnd_message.get);
1454: end if;
1455: --
1456: end if;
1457: l_pgm_id := l_epe_rec.pgm_id;
1522: fnd_message.set_token('PER_IN_LER_ID',to_char(p_per_in_ler_id));
1523: fnd_message.set_token('LF_EVT_OCRD_DT',to_char(p_lf_evt_ocrd_dt));
1524: --
1525: if fnd_global.conc_request_id <> -1 then
1526: benutils.write(fnd_message.get);
1527: end if;
1528: end if;
1529: --
1530: l_ptip_id := l_epe_rec.ptip_id;
3076: if (p_rndg_cd is not null or
3077: p_rndg_rl is not null) and
3078: p_amount is not null then
3079: --
3080: l_return_amt := benutils.do_rounding
3081: (p_rounding_cd => p_rndg_cd,
3082: p_rounding_rl => p_rndg_rl,
3083: p_value => p_amount,
3084: p_effective_date => p_effective_date);