[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
3317: if c_prv_sspndd%notfound then
3318: exit;
3319: end if;
3320:
3321: ben_element_entry.end_enrollment_element
3322: (p_business_group_id => p_business_group_id
3323: ,p_person_id => l_pen.person_id
3324: ,p_enrt_rslt_id => p_prtt_enrt_rslt_id
3325: ,p_acty_ref_perd => l_prv_sspndd.acty_ref_perd_cd
4323: -- Bug 4141269 We will pass p_input_value_id and p_element_type_id as null
4324: -- so that they get correctly re-queried in benelmen.pkb
4325: -- based on life event occurred date or rate start date
4326: if l_prv.element_entry_value_id is null then
4327: ben_element_entry.create_enrollment_element
4328: (p_business_group_id => p_business_group_id
4329: ,p_prtt_rt_val_id => l_prv.prtt_rt_val_id
4330: ,p_person_id => l_pen.person_id
4331: ,p_acty_ref_perd => l_prv.acty_ref_perd_cd
4349: fetch c_ee into l_ee_end_date;
4350: close c_ee;
4351: if l_ee_end_date <> hr_api.g_eot and
4352: l_prv.rt_end_dt = hr_api.g_eot then
4353: ben_element_entry.reopen_closed_enrollment(
4354: p_business_group_id => p_business_group_id
4355: ,p_person_id => l_pen.person_id
4356: ,p_prtt_rt_val_id => l_prv.prtt_rt_val_id
4357: ,p_acty_base_rt_id => l_prv.acty_base_rt_id