[Home] [Help]
114: 27 May 98 gperry 110.14 Added calls to formula cover
115: routine.
116: 06 Jun 98 jmohapat 110.15 Added call to deenroll for newly ineligible
117: 07 Jun 98 jmohapatra 110.16 procedure name changed to
118: ben_newly_ineligible.main
119: 10 Jun 98 lmcdonal 110.17 made header line after create line.
120: 12 Jun 98 gperry 110.18 Fixed update modes so we can
121: handle update_overrides.
122: 14 Jun 98 gperry 110.19 Fixed log messages.
126: ben_eligibile_person_api.create_eligible
127: _person and update)
128: 23 Jul 98 thayden 110.21 Added Inelg rsn cd.
129: 23 Oct 98 gperry 115.11 Added in extra call to
130: ben_newly_ineligible to handle
131: plans as well as programs.
132: 26 Oct 98 gperry 115.12 Corrected ben_elig_per_f so
133: pgm_id is populated if pl_id has
134: a program parent.
357: 30-Jan-06 mhoyes 115.118 Bug#4968123 - moved out cursors
358: to ben_determine_eligibility4.
359: 28-Jun-06 swjain 115.119 Bug 5331889 Added person_id param in call to
360: benutils.formula in procedure get_start_end_dates
361: 24-Jul-06 kmahendr 115.120 Bug#5404392-added ben_newly_ineligible call
362: in the case of first time ineligible.
363: 25-aug-06 ssarkar 115.121 bug# 5478994 - passed ler_id to update_perf_eligible_person
364: 11-Dec-06 rgajula 115.122 Bug 5682845 - passed the l_envplipid to the call to ben_pep_Cache.get_pilepo_dets.
365: 07-Feb-07 kmahendr 115.124 Fidelity Enh to update inelig rows and
3205: ben_icm_life_events.g_cache_epo_object(l_count_icm1).prtn_ovridn_thru_dt := null;
3206: --
3207: END IF;
3208: --ICM
3209: -- ben_newly_ineligible does not handle levels other than
3210: -- plan,option in plan, or program. Don't call it if not
3211: -- necessary.
3212: --
3213: if p_score_tab.count > 0 then
3234: p_pgm_id is not null) then
3235: --
3236: if nvl(ben_manage_life_events.g_defer_deenrol_flag,'N') <> 'Y' then -- Defer ENH
3237: --
3238: ben_newly_ineligible.main
3239: (p_person_id => p_person_id,
3240: p_pl_id => l_pl_id,
3241: p_pgm_id => nvl(p_pgm_id,l_envpgm_id),
3242: p_oipl_id => p_oipl_id,
3252: if p_ptip_id is not null then
3253: if nvl(ben_manage_life_events.g_defer_deenrol_flag,'N') <> 'Y' then -- Defer ENH
3254: --
3255: for l_rec in c_get_pl_from_ptip(nvl(l_fonm_cvg_strt_dt,p_effective_date)) loop
3256: ben_newly_ineligible.main
3257: (p_person_id => p_person_id,
3258: p_pl_id => l_rec.pl_id,
3259: p_pgm_id => nvl(p_pgm_id,l_envpgm_id),
3260: p_oipl_id => p_oipl_id,
4081: -- the subsequent finds first ineligible
4082: if p_pgm_id is not null then
4083: if nvl(ben_manage_life_events.g_defer_deenrol_flag,'N') <> 'Y' then -- Defer ENH
4084: --
4085: ben_newly_ineligible.main
4086: (p_person_id => p_person_id,
4087: p_pl_id => null,
4088: p_pgm_id => p_pgm_id,
4089: p_oipl_id => null,
4425: p_oipl_id is not null or
4426: p_pgm_id is not null) then
4427:
4428: if nvl(ben_manage_life_events.g_defer_deenrol_flag,'N') <> 'Y' then -- Defer ENH
4429: ben_newly_ineligible.main
4430: (p_person_id => p_person_id,
4431: p_pl_id => l_pl_id,
4432: p_pgm_id => nvl(p_pgm_id,l_envpgm_id),
4433: p_oipl_id => p_oipl_id,
4443: --
4444: if p_ptip_id is not null then
4445: if nvl(ben_manage_life_events.g_defer_deenrol_flag,'N') <> 'Y' then -- Defer ENH
4446: for l_rec in c_get_pl_from_ptip(nvl(l_fonm_cvg_strt_dt,p_effective_date)) loop
4447: ben_newly_ineligible.main
4448: (p_person_id => p_person_id,
4449: p_pl_id => l_rec.pl_id,
4450: p_pgm_id => nvl(p_pgm_id,l_envpgm_id),
4451: p_oipl_id => p_oipl_id,
5608: ,p_effective_date => l_effective_dt
5609: ,p_elig_per_id => l_elig_per_id);
5610: end if;
5611: --
5612: -- ben_newly_ineligible does not handle levels other than
5613: -- plan,option in plan, or program. Don't call it if not
5614: -- necessary.
5615: --
5616: if p_plip_id is not null then
5625: if (l_pl_id is not null or
5626: p_oipl_id is not null or
5627: p_pgm_id is not null) then
5628: if nvl(ben_manage_life_events.g_defer_deenrol_flag,'N') <> 'Y' then -- Defer ENH
5629: ben_newly_ineligible.main
5630: (p_person_id => p_person_id,
5631: p_pl_id => l_pl_id,
5632: p_pgm_id => nvl(p_pgm_id,l_envpgm_id),
5633: p_oipl_id => p_oipl_id,
5643: --
5644: if p_ptip_id is not null then
5645: if nvl(ben_manage_life_events.g_defer_deenrol_flag,'N') <> 'Y' then -- Defer ENH
5646: for l_rec in c_get_pl_from_ptip(nvl(l_fonm_cvg_strt_dt,p_effective_date)) loop
5647: ben_newly_ineligible.main
5648: (p_person_id => p_person_id,
5649: p_pl_id => l_rec.pl_id,
5650: p_pgm_id => nvl(p_pgm_id,l_envpgm_id),
5651: p_oipl_id => p_oipl_id,