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 3500: ben_provider_pools.remove_bnft_prvdd_ldgr

3496: end loop;
3497: close c_prv_sspndd;
3498:
3499:
3500: ben_provider_pools.remove_bnft_prvdd_ldgr
3501: (p_prtt_enrt_rslt_id => p_prtt_enrt_rslt_id
3502: ,p_effective_date => p_effective_date
3503: ,p_business_group_id => p_business_group_id
3504: ,p_validate => FALSE

Line 4349: ben_provider_pools.remove_bnft_prvdd_ldgr

4345: ,p_pl_id => l_interim.pl_id
4346: ,p_person_id => l_interim.person_id
4347: );
4348: --Bug 2185509 Delete the interim ledger entries
4349: ben_provider_pools.remove_bnft_prvdd_ldgr
4350: (p_prtt_enrt_rslt_id => l_interim.prtt_enrt_rslt_id
4351: ,p_effective_date => p_effective_date
4352: ,p_business_group_id => p_business_group_id
4353: ,p_validate => FALSE

Line 4582: ben_provider_pools.create_debit_ledger_entry

4578: close c_enrt_rt;
4579: --
4580: if l_decr_bnft_prvdr_pool_id is not null then
4581: --
4582: ben_provider_pools.create_debit_ledger_entry
4583: (p_person_id => l_pen.person_id
4584: ,p_per_in_ler_id => l_per_in_ler_id
4585: ,p_elig_per_elctbl_chc_id => l_elig_per_elctbl_chc_id
4586: ,p_prtt_enrt_rslt_id => p_prtt_enrt_rslt_id

Line 4759: ben_provider_pools.accumulate_pools

4755: -- Bug : 2088231
4756: -- As the enrollment is unsuspended, go create the
4757: -- credit ledger entry.
4758: --
4759: ben_provider_pools.accumulate_pools
4760: (p_validate => FALSE
4761: ,p_person_id => l_pen.person_id
4762: ,p_elig_per_elctbl_chc_id => l_elig_per_elctbl_chc_id
4763: ,p_business_group_id => p_business_group_id

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

4769: -- in addition to this, when the enrollment gets unsuspended we need
4770: -- to do other flex credits processing like forfeiture, distribution,
4771: -- rollover and "updation of prtt_rt_value of flex shell plan enrt_rslt
4772: -- row", due to the unsuspension. Hence making a call to
4773: -- ben_provider_pools.total_plans will handle all of the above.
4774: --
4775: l_prtt_enrt_rslt_id := p_prtt_enrt_rslt_id ;
4776: ben_provider_pools.total_pools
4777: (p_validate => FALSE

Line 4776: ben_provider_pools.total_pools

4772: -- row", due to the unsuspension. Hence making a call to
4773: -- ben_provider_pools.total_plans will handle all of the above.
4774: --
4775: l_prtt_enrt_rslt_id := p_prtt_enrt_rslt_id ;
4776: ben_provider_pools.total_pools
4777: (p_validate => FALSE
4778: ,p_prtt_enrt_rslt_id => l_prtt_enrt_rslt_id
4779: ,p_prtt_rt_val_id => l_prtt_rt_val_id
4780: ,p_acty_ref_perd_cd => l_acty_ref_perd_cd