DBA Data[Home] [Help]

APPS.BEN_EFC_ADJUSTMENTS dependencies on BEN_EPE_CACHE

Line 518: l_tmpepe_row ben_epe_cache.g_pilepe_inst_row;

514: ,p_faterr_type out nocopy varchar2
515: )
516: is
517: --
518: l_tmpepe_row ben_epe_cache.g_pilepe_inst_row;
519: l_currepe_row ben_determine_rates.g_curr_epe_rec;
520: --
521: cursor c_epedets
522: (c_epe_id in number

Line 636: ben_epe_cache.EPE_GetEPEDets

632: end if;
633: --
634: if nvl(p_detect_mode,'ZZZ') = 'EPEINFO' then
635: --
636: ben_epe_cache.EPE_GetEPEDets
637: (p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id
638: ,p_per_in_ler_id => l_epedets.per_in_ler_id
639: ,p_inst_row => l_tmpepe_row
640: );

Line 691: ben_epe_cache.ENBEPE_GetEPEDets

687: end if;
688: --
689: if nvl(p_detect_mode,'ZZZ') = 'EPEINFO' then
690: --
691: ben_epe_cache.ENBEPE_GetEPEDets
692: (p_enrt_bnft_id => p_enrt_bnft_id
693: ,p_per_in_ler_id => l_enbdets.per_in_ler_id
694: ,p_inst_row => l_tmpepe_row
695: );

Line 3374: ben_epe_cache.g_currcobjepe_row.pl_id := l_efc_row.pl_id;

3370: );
3371: --
3372: -- Set up electable choice context
3373: --
3374: ben_epe_cache.g_currcobjepe_row.pl_id := l_efc_row.pl_id;
3375: ben_epe_cache.g_currcobjepe_row.plip_id := l_efc_row.plip_id;
3376: ben_epe_cache.g_currcobjepe_row.oipl_id := l_efc_row.oipl_id;
3377: --
3378: -- Add a row to fnd sessions

Line 3375: ben_epe_cache.g_currcobjepe_row.plip_id := l_efc_row.plip_id;

3371: --
3372: -- Set up electable choice context
3373: --
3374: ben_epe_cache.g_currcobjepe_row.pl_id := l_efc_row.pl_id;
3375: ben_epe_cache.g_currcobjepe_row.plip_id := l_efc_row.plip_id;
3376: ben_epe_cache.g_currcobjepe_row.oipl_id := l_efc_row.oipl_id;
3377: --
3378: -- Add a row to fnd sessions
3379: --

Line 3376: ben_epe_cache.g_currcobjepe_row.oipl_id := l_efc_row.oipl_id;

3372: -- Set up electable choice context
3373: --
3374: ben_epe_cache.g_currcobjepe_row.pl_id := l_efc_row.pl_id;
3375: ben_epe_cache.g_currcobjepe_row.plip_id := l_efc_row.plip_id;
3376: ben_epe_cache.g_currcobjepe_row.oipl_id := l_efc_row.oipl_id;
3377: --
3378: -- Add a row to fnd sessions
3379: --
3380: Insert_fndsession_row

Line 3388: ben_epe_cache.g_currcobjepe_row.elig_per_elctbl_chc_id := l_efc_row.elig_per_elctbl_chc_id;

3384: begin
3385: --
3386: begin
3387: --
3388: ben_epe_cache.g_currcobjepe_row.elig_per_elctbl_chc_id := l_efc_row.elig_per_elctbl_chc_id;
3389: ben_epe_cache.g_currcobjepe_row.business_group_id := l_efc_row.business_group_id;
3390: ben_epe_cache.g_currcobjepe_row.pgm_id := l_efc_row.pgm_id;
3391: ben_epe_cache.g_currcobjepe_row.pl_id := l_efc_row.pl_id;
3392: ben_epe_cache.g_currcobjepe_row.pl_typ_id := l_efc_row.pl_typ_id;

Line 3389: ben_epe_cache.g_currcobjepe_row.business_group_id := l_efc_row.business_group_id;

3385: --
3386: begin
3387: --
3388: ben_epe_cache.g_currcobjepe_row.elig_per_elctbl_chc_id := l_efc_row.elig_per_elctbl_chc_id;
3389: ben_epe_cache.g_currcobjepe_row.business_group_id := l_efc_row.business_group_id;
3390: ben_epe_cache.g_currcobjepe_row.pgm_id := l_efc_row.pgm_id;
3391: ben_epe_cache.g_currcobjepe_row.pl_id := l_efc_row.pl_id;
3392: ben_epe_cache.g_currcobjepe_row.pl_typ_id := l_efc_row.pl_typ_id;
3393: ben_epe_cache.g_currcobjepe_row.ptip_id := l_efc_row.ptip_id;

Line 3390: ben_epe_cache.g_currcobjepe_row.pgm_id := l_efc_row.pgm_id;

3386: begin
3387: --
3388: ben_epe_cache.g_currcobjepe_row.elig_per_elctbl_chc_id := l_efc_row.elig_per_elctbl_chc_id;
3389: ben_epe_cache.g_currcobjepe_row.business_group_id := l_efc_row.business_group_id;
3390: ben_epe_cache.g_currcobjepe_row.pgm_id := l_efc_row.pgm_id;
3391: ben_epe_cache.g_currcobjepe_row.pl_id := l_efc_row.pl_id;
3392: ben_epe_cache.g_currcobjepe_row.pl_typ_id := l_efc_row.pl_typ_id;
3393: ben_epe_cache.g_currcobjepe_row.ptip_id := l_efc_row.ptip_id;
3394: ben_epe_cache.g_currcobjepe_row.plip_id := l_efc_row.plip_id;

Line 3391: ben_epe_cache.g_currcobjepe_row.pl_id := l_efc_row.pl_id;

3387: --
3388: ben_epe_cache.g_currcobjepe_row.elig_per_elctbl_chc_id := l_efc_row.elig_per_elctbl_chc_id;
3389: ben_epe_cache.g_currcobjepe_row.business_group_id := l_efc_row.business_group_id;
3390: ben_epe_cache.g_currcobjepe_row.pgm_id := l_efc_row.pgm_id;
3391: ben_epe_cache.g_currcobjepe_row.pl_id := l_efc_row.pl_id;
3392: ben_epe_cache.g_currcobjepe_row.pl_typ_id := l_efc_row.pl_typ_id;
3393: ben_epe_cache.g_currcobjepe_row.ptip_id := l_efc_row.ptip_id;
3394: ben_epe_cache.g_currcobjepe_row.plip_id := l_efc_row.plip_id;
3395: ben_epe_cache.g_currcobjepe_row.oipl_id := l_efc_row.oipl_id;

Line 3392: ben_epe_cache.g_currcobjepe_row.pl_typ_id := l_efc_row.pl_typ_id;

3388: ben_epe_cache.g_currcobjepe_row.elig_per_elctbl_chc_id := l_efc_row.elig_per_elctbl_chc_id;
3389: ben_epe_cache.g_currcobjepe_row.business_group_id := l_efc_row.business_group_id;
3390: ben_epe_cache.g_currcobjepe_row.pgm_id := l_efc_row.pgm_id;
3391: ben_epe_cache.g_currcobjepe_row.pl_id := l_efc_row.pl_id;
3392: ben_epe_cache.g_currcobjepe_row.pl_typ_id := l_efc_row.pl_typ_id;
3393: ben_epe_cache.g_currcobjepe_row.ptip_id := l_efc_row.ptip_id;
3394: ben_epe_cache.g_currcobjepe_row.plip_id := l_efc_row.plip_id;
3395: ben_epe_cache.g_currcobjepe_row.oipl_id := l_efc_row.oipl_id;
3396: ben_epe_cache.g_currcobjepe_row.prtt_enrt_rslt_id := l_efc_row.prtt_enrt_rslt_id;

Line 3393: ben_epe_cache.g_currcobjepe_row.ptip_id := l_efc_row.ptip_id;

3389: ben_epe_cache.g_currcobjepe_row.business_group_id := l_efc_row.business_group_id;
3390: ben_epe_cache.g_currcobjepe_row.pgm_id := l_efc_row.pgm_id;
3391: ben_epe_cache.g_currcobjepe_row.pl_id := l_efc_row.pl_id;
3392: ben_epe_cache.g_currcobjepe_row.pl_typ_id := l_efc_row.pl_typ_id;
3393: ben_epe_cache.g_currcobjepe_row.ptip_id := l_efc_row.ptip_id;
3394: ben_epe_cache.g_currcobjepe_row.plip_id := l_efc_row.plip_id;
3395: ben_epe_cache.g_currcobjepe_row.oipl_id := l_efc_row.oipl_id;
3396: ben_epe_cache.g_currcobjepe_row.prtt_enrt_rslt_id := l_efc_row.prtt_enrt_rslt_id;
3397: ben_epe_cache.g_currcobjepe_row.ler_id := l_efc_row.ler_id;

Line 3394: ben_epe_cache.g_currcobjepe_row.plip_id := l_efc_row.plip_id;

3390: ben_epe_cache.g_currcobjepe_row.pgm_id := l_efc_row.pgm_id;
3391: ben_epe_cache.g_currcobjepe_row.pl_id := l_efc_row.pl_id;
3392: ben_epe_cache.g_currcobjepe_row.pl_typ_id := l_efc_row.pl_typ_id;
3393: ben_epe_cache.g_currcobjepe_row.ptip_id := l_efc_row.ptip_id;
3394: ben_epe_cache.g_currcobjepe_row.plip_id := l_efc_row.plip_id;
3395: ben_epe_cache.g_currcobjepe_row.oipl_id := l_efc_row.oipl_id;
3396: ben_epe_cache.g_currcobjepe_row.prtt_enrt_rslt_id := l_efc_row.prtt_enrt_rslt_id;
3397: ben_epe_cache.g_currcobjepe_row.ler_id := l_efc_row.ler_id;
3398: ben_epe_cache.g_currcobjepe_row.object_version_number := l_efc_row.epe_ovn;

Line 3395: ben_epe_cache.g_currcobjepe_row.oipl_id := l_efc_row.oipl_id;

3391: ben_epe_cache.g_currcobjepe_row.pl_id := l_efc_row.pl_id;
3392: ben_epe_cache.g_currcobjepe_row.pl_typ_id := l_efc_row.pl_typ_id;
3393: ben_epe_cache.g_currcobjepe_row.ptip_id := l_efc_row.ptip_id;
3394: ben_epe_cache.g_currcobjepe_row.plip_id := l_efc_row.plip_id;
3395: ben_epe_cache.g_currcobjepe_row.oipl_id := l_efc_row.oipl_id;
3396: ben_epe_cache.g_currcobjepe_row.prtt_enrt_rslt_id := l_efc_row.prtt_enrt_rslt_id;
3397: ben_epe_cache.g_currcobjepe_row.ler_id := l_efc_row.ler_id;
3398: ben_epe_cache.g_currcobjepe_row.object_version_number := l_efc_row.epe_ovn;
3399: ben_epe_cache.g_currcobjepe_row.elctbl_flag := l_efc_row.elctbl_flag;

Line 3396: ben_epe_cache.g_currcobjepe_row.prtt_enrt_rslt_id := l_efc_row.prtt_enrt_rslt_id;

3392: ben_epe_cache.g_currcobjepe_row.pl_typ_id := l_efc_row.pl_typ_id;
3393: ben_epe_cache.g_currcobjepe_row.ptip_id := l_efc_row.ptip_id;
3394: ben_epe_cache.g_currcobjepe_row.plip_id := l_efc_row.plip_id;
3395: ben_epe_cache.g_currcobjepe_row.oipl_id := l_efc_row.oipl_id;
3396: ben_epe_cache.g_currcobjepe_row.prtt_enrt_rslt_id := l_efc_row.prtt_enrt_rslt_id;
3397: ben_epe_cache.g_currcobjepe_row.ler_id := l_efc_row.ler_id;
3398: ben_epe_cache.g_currcobjepe_row.object_version_number := l_efc_row.epe_ovn;
3399: ben_epe_cache.g_currcobjepe_row.elctbl_flag := l_efc_row.elctbl_flag;
3400: ben_epe_cache.g_currcobjepe_row.per_in_ler_id := l_efc_row.per_in_ler_id;

Line 3397: ben_epe_cache.g_currcobjepe_row.ler_id := l_efc_row.ler_id;

3393: ben_epe_cache.g_currcobjepe_row.ptip_id := l_efc_row.ptip_id;
3394: ben_epe_cache.g_currcobjepe_row.plip_id := l_efc_row.plip_id;
3395: ben_epe_cache.g_currcobjepe_row.oipl_id := l_efc_row.oipl_id;
3396: ben_epe_cache.g_currcobjepe_row.prtt_enrt_rslt_id := l_efc_row.prtt_enrt_rslt_id;
3397: ben_epe_cache.g_currcobjepe_row.ler_id := l_efc_row.ler_id;
3398: ben_epe_cache.g_currcobjepe_row.object_version_number := l_efc_row.epe_ovn;
3399: ben_epe_cache.g_currcobjepe_row.elctbl_flag := l_efc_row.elctbl_flag;
3400: ben_epe_cache.g_currcobjepe_row.per_in_ler_id := l_efc_row.per_in_ler_id;
3401: --

Line 3398: ben_epe_cache.g_currcobjepe_row.object_version_number := l_efc_row.epe_ovn;

3394: ben_epe_cache.g_currcobjepe_row.plip_id := l_efc_row.plip_id;
3395: ben_epe_cache.g_currcobjepe_row.oipl_id := l_efc_row.oipl_id;
3396: ben_epe_cache.g_currcobjepe_row.prtt_enrt_rslt_id := l_efc_row.prtt_enrt_rslt_id;
3397: ben_epe_cache.g_currcobjepe_row.ler_id := l_efc_row.ler_id;
3398: ben_epe_cache.g_currcobjepe_row.object_version_number := l_efc_row.epe_ovn;
3399: ben_epe_cache.g_currcobjepe_row.elctbl_flag := l_efc_row.elctbl_flag;
3400: ben_epe_cache.g_currcobjepe_row.per_in_ler_id := l_efc_row.per_in_ler_id;
3401: --
3402: ben_determine_coverage.main

Line 3399: ben_epe_cache.g_currcobjepe_row.elctbl_flag := l_efc_row.elctbl_flag;

3395: ben_epe_cache.g_currcobjepe_row.oipl_id := l_efc_row.oipl_id;
3396: ben_epe_cache.g_currcobjepe_row.prtt_enrt_rslt_id := l_efc_row.prtt_enrt_rslt_id;
3397: ben_epe_cache.g_currcobjepe_row.ler_id := l_efc_row.ler_id;
3398: ben_epe_cache.g_currcobjepe_row.object_version_number := l_efc_row.epe_ovn;
3399: ben_epe_cache.g_currcobjepe_row.elctbl_flag := l_efc_row.elctbl_flag;
3400: ben_epe_cache.g_currcobjepe_row.per_in_ler_id := l_efc_row.per_in_ler_id;
3401: --
3402: ben_determine_coverage.main
3403: (p_calculate_only_mode => TRUE

Line 3400: ben_epe_cache.g_currcobjepe_row.per_in_ler_id := l_efc_row.per_in_ler_id;

3396: ben_epe_cache.g_currcobjepe_row.prtt_enrt_rslt_id := l_efc_row.prtt_enrt_rslt_id;
3397: ben_epe_cache.g_currcobjepe_row.ler_id := l_efc_row.ler_id;
3398: ben_epe_cache.g_currcobjepe_row.object_version_number := l_efc_row.epe_ovn;
3399: ben_epe_cache.g_currcobjepe_row.elctbl_flag := l_efc_row.elctbl_flag;
3400: ben_epe_cache.g_currcobjepe_row.per_in_ler_id := l_efc_row.per_in_ler_id;
3401: --
3402: ben_determine_coverage.main
3403: (p_calculate_only_mode => TRUE
3404: ,p_elig_per_elctbl_chc_id => l_efc_row.elig_per_elctbl_chc_id

Line 4148: ben_epe_cache.clear_down_cache;

4144: open c_efc_rows FOR l_sql_str;
4145: --
4146: end if;
4147: --
4148: ben_epe_cache.clear_down_cache;
4149: --
4150: loop
4151: FETCH c_efc_rows INTO l_efc_row;
4152: EXIT WHEN c_efc_rows%NOTFOUND;

Line 4938: ben_epe_cache.clear_down_cache;

4934: open c_efc_rows FOR l_sql_str;
4935: --
4936: end if;
4937: --
4938: ben_epe_cache.clear_down_cache;
4939: --
4940: loop
4941: --
4942: FETCH c_efc_rows INTO l_efc_row;