[Home] [Help]
79: 04 Mar 99 jcarpent 115.29 Don't end old enrollment if it is
80: the interim enrollment.
81: 24 Mar 99 jcarpent 115.31 Always call manage_enrt_bnft.
82: Delete/end date rate on bnft_amt chg
83: 29 Mar 99 thayden 115.32 Added call to ben_ext_chlg.
84: 05 Apr 99 mhoyes 115.33 Un-datetrack per_in_ler_f changes.
85: 06 May 99 jcarpent 115.34 Write new prv if suspended
86: 19 May 99 lmcdonal 115.35 Overloaded election_information to chg
87: which save point to set and rollback.
6485: close c_unrestricted;
6486: ------write to extract log
6487: hr_utility.set_location('l_unrestricted : '||l_unrestricted.typ_cd,1);
6488: if l_unrestricted.typ_cd = 'SCHEDDU' then
6489: ben_ext_chlg.log_benefit_chg
6490: (p_action => 'REINSTATE'
6491: ,p_pl_id => l_global_epe_rec.pl_id
6492: ,p_old_pl_id => l_old_pl_id
6493: ,p_oipl_id => l_global_epe_rec.oipl_id
7424: --
7425: if l_global_epe_rec.pl_id <> nvl(l_old_pl_id,l_global_epe_rec.pl_id) or
7426: l_global_epe_rec.oipl_id <>
7427: nvl(l_old_oipl_id,l_global_epe_rec.oipl_id) then
7428: ben_ext_chlg.log_benefit_chg
7429: (p_action => 'UPDATE' --plan and option changes
7430: ,p_pl_id => l_global_epe_rec.pl_id
7431: ,p_old_pl_id => l_old_pl_id
7432: ,p_oipl_id => l_global_epe_rec.oipl_id
7442: ,p_business_group_id => l_global_epe_rec.business_group_id
7443: ,p_effective_date => p_effective_date
7444: );
7445: else
7446: ben_ext_chlg.log_benefit_chg
7447: (p_action => 'CREATE' -- new enrollment
7448: ,p_pl_id => l_global_epe_rec.pl_id
7449: ,p_old_pl_id => l_old_pl_id
7450: ,p_oipl_id => l_global_epe_rec.oipl_id
7460: ,p_effective_date => p_effective_date
7461: );
7462: end if;
7463: --
7464: ben_ext_chlg.log_benefit_chg
7465: (p_action => l_action
7466: ,p_pl_id => l_global_epe_rec.pl_id
7467: ,p_old_pl_id => l_old_pl_id
7468: ,p_oipl_id => l_global_epe_rec.oipl_id