[Home] [Help]
275: * 115.124 select electable choice that falls under the program
276: * for which enrollment is suspended. This it to avoid
277: * suspended and interim falling into different programs
278: * 05-Apr-2005 abparekh 115.125 Bug 4141269 pass p_input_value_id and p_element_type_id
279: * as null to ben_element_entry.create_enrollment_element
280: * 14-Apr-2005 ikasire 115.126 Added new parameter to manage_enrt_bnft call
281: * 20-Jun-2005 mmudigon 115.127 Bug 4352871. Added logic to delete element
282: * entries when pen is suspended.
283: * 29-Jun-2005 ikasire 115.128 Bug 4422667 getting into loop issue
3463: if c_prv_sspndd%notfound then
3464: exit;
3465: end if;
3466:
3467: ben_element_entry.end_enrollment_element
3468: (p_business_group_id => p_business_group_id
3469: ,p_person_id => l_pen.person_id
3470: ,p_enrt_rslt_id => p_prtt_enrt_rslt_id
3471: ,p_acty_ref_perd => l_prv_sspndd.acty_ref_perd_cd
4529: -- Bug 4141269 We will pass p_input_value_id and p_element_type_id as null
4530: -- so that they get correctly re-queried in benelmen.pkb
4531: -- based on life event occurred date or rate start date
4532: if l_prv.element_entry_value_id is null then
4533: ben_element_entry.create_enrollment_element
4534: (p_business_group_id => p_business_group_id
4535: ,p_prtt_rt_val_id => l_prv.prtt_rt_val_id
4536: ,p_person_id => l_pen.person_id
4537: ,p_acty_ref_perd => l_prv.acty_ref_perd_cd
4555: fetch c_ee into l_ee_end_date;
4556: close c_ee;
4557: if l_ee_end_date <> hr_api.g_eot and
4558: l_prv.rt_end_dt = hr_api.g_eot then
4559: ben_element_entry.reopen_closed_enrollment(
4560: p_business_group_id => p_business_group_id
4561: ,p_person_id => l_pen.person_id
4562: ,p_prtt_rt_val_id => l_prv.prtt_rt_val_id
4563: ,p_acty_base_rt_id => l_prv.acty_base_rt_id