APPS.BEN_SSPNDD_ENROLLMENT dependencies on BEN_PROVIDER_POOLS

Line 161: * the ben_provider_pools.remove_bnft_prvdd_ldgr

157: derived inside benutils.formula.
158: * 02-nov-2001 pbodla 115.73 bug:2088231 Called accumulate pools after
159: * unsuspend enrollment.
160: * 23-Jan-2002 ikasire 115.74 bug:2185509 when unsuspended, we are calling
161: * the ben_provider_pools.remove_bnft_prvdd_ldgr
162: * to remove the ledger entries of the interim
163: * coverage
164: * 30-Jan-2002 ikasire 115.75 Bug2191886 fixed the error where effective
165: * date is used for life event occured date in

Line 212: * call ben_provider_pools.total_pools after

208: * error. Changed to (+) to nvl in where clause
209: * 26-Sep-2002 ikasire 115.89 Bug 2595113 fixed the cursor c_current_enrt in
210: * determine_interim procedure
211: * 02-Dec-2002 hnarayan 115.90 Bug 2689926 - changed unsuspend_enrollment to
212: * call ben_provider_pools.total_pools after
213: * calling accumulate_pools.
214: * 24-dec-2002 hmani 115.91 For nocopy changes
215: * 15-May-2003 ikasire 115.92 Bug2958032 Issues in Unsuspended enrollment
216: * 1.update epe with the pen id

Line 3354: ben_provider_pools.remove_bnft_prvdd_ldgr

3350: end loop;
3351: close c_prv_sspndd;
3352:
3353:
3354: ben_provider_pools.remove_bnft_prvdd_ldgr
3355: (p_prtt_enrt_rslt_id => p_prtt_enrt_rslt_id
3356: ,p_effective_date => p_effective_date
3357: ,p_business_group_id => p_business_group_id
3358: ,p_validate => FALSE

Line 4144: ben_provider_pools.remove_bnft_prvdd_ldgr

4140: ,p_pl_id => l_interim.pl_id
4141: ,p_person_id => l_interim.person_id
4142: );
4143: --Bug 2185509 Delete the interim ledger entries
4144: ben_provider_pools.remove_bnft_prvdd_ldgr
4145: (p_prtt_enrt_rslt_id => l_interim.prtt_enrt_rslt_id
4146: ,p_effective_date => p_effective_date
4147: ,p_business_group_id => p_business_group_id
4148: ,p_validate => FALSE

Line 4376: ben_provider_pools.create_debit_ledger_entry

4372: close c_enrt_rt;
4373: --
4374: if l_decr_bnft_prvdr_pool_id is not null then
4375: --
4376: ben_provider_pools.create_debit_ledger_entry
4377: (p_person_id => l_pen.person_id
4378: ,p_per_in_ler_id => l_per_in_ler_id
4379: ,p_elig_per_elctbl_chc_id => l_elig_per_elctbl_chc_id
4380: ,p_prtt_enrt_rslt_id => p_prtt_enrt_rslt_id

Line 4550: ben_provider_pools.accumulate_pools

4546: -- Bug : 2088231
4547: -- As the enrollment is unsuspended, go create the
4548: -- credit ledger entry.
4549: --
4550: ben_provider_pools.accumulate_pools
4551: (p_validate => FALSE
4552: ,p_person_id => l_pen.person_id
4553: ,p_elig_per_elctbl_chc_id => l_elig_per_elctbl_chc_id
4554: ,p_business_group_id => p_business_group_id

Line 4564: -- ben_provider_pools.total_plans will handle all of the above.

4560: -- in addition to this, when the enrollment gets unsuspended we need
4561: -- to do other flex credits processing like forfeiture, distribution,
4562: -- rollover and "updation of prtt_rt_value of flex shell plan enrt_rslt
4563: -- row", due to the unsuspension. Hence making a call to
4564: -- ben_provider_pools.total_plans will handle all of the above.
4565: --
4566: l_prtt_enrt_rslt_id := p_prtt_enrt_rslt_id ;
4567: ben_provider_pools.total_pools
4568: (p_validate => FALSE

Line 4567: ben_provider_pools.total_pools

4563: -- row", due to the unsuspension. Hence making a call to
4564: -- ben_provider_pools.total_plans will handle all of the above.
4565: --
4566: l_prtt_enrt_rslt_id := p_prtt_enrt_rslt_id ;
4567: ben_provider_pools.total_pools
4568: (p_validate => FALSE
4569: ,p_prtt_enrt_rslt_id => l_prtt_enrt_rslt_id
4570: ,p_prtt_rt_val_id => l_prtt_rt_val_id
4571: ,p_acty_ref_perd_cd => l_acty_ref_perd_cd