[Home] [Help]
2594: /*Bug 8604243: Added 'if' condition. While backing out a LE,if previous LE does not have
2595: electability and no enrollments results then per_in_ler_id of the LE for which enrollment results are ended is passed to the procedure
2596: In this case there will be future LE and error will be raised.Added 'if' condition so that control will not enter in the above
2597: scenario*/
2598: if ( ben_back_out_life_event.g_no_reopen_flag = 'N') then
2599: open c_get_future_per_in_ler;
2600: fetch c_get_future_per_in_ler into l_exists;
2601:
2602: if c_get_future_per_in_ler%found then
2611: -- Step 2 : Open all the pil electable choice popl rows.
2612: --
2613: for l_pel_rec in c_get_pil_elctbl_chc_popl loop
2614: /*Bug 8604243: Added 'if' condition.*/
2615: if ( ben_back_out_life_event.g_no_reopen_flag = 'N') then
2616: ben_pil_elctbl_chc_popl_api.update_pil_elctbl_chc_popl
2617: (p_validate => p_validate
2618: ,p_pil_elctbl_chc_popl_id => l_pel_rec.pil_elctbl_chc_popl_id
2619: ,p_pil_elctbl_popl_stat_cd => 'STRTD'
2676: l_object_version_number := p_object_version_number;
2677: --
2678: /*Bug 8604243: Added 'if' condition. While backing out the LE,if previous LE does not have
2679: electability and no enrollments results then previous LE status will not be updated to 'STRTD' status.*/
2680: if ( ben_back_out_life_event.g_no_reopen_flag = 'N') then
2681: ben_person_life_event_api.update_person_life_event
2682: (p_validate => p_validate
2683: ,p_per_in_ler_id => p_per_in_ler_id
2684: ,p_per_in_ler_stat_cd => 'STRTD'