eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_DETERMINE_CHC_CTFN dependencies on BEN_EPE_CACHE

Line 576: l_epe ben_epe_cache.g_pilepe_inst_row;

572: --
573: l_epe c_epe%rowtype;
574: */
575: --
576: l_epe ben_epe_cache.g_pilepe_inst_row;
577: --
578: cursor c_lre_oipl is
579: select lre.ler_rqrs_enrt_ctfn_id,
580: lre.ctfn_rqd_when_rl

Line 701: if ben_epe_cache.g_currcobjepe_row.elig_per_elctbl_chc_id is not null then

697: -- 3) If OIPL, and no cert.created in 1) and 2) then go ahead with 4) and 5).
698: -- 4) Create life event level plan certification.
699: -- 5) Create Plan level certification.
700: --
701: if ben_epe_cache.g_currcobjepe_row.elig_per_elctbl_chc_id is not null then
702: --
703: l_epe.elig_per_elctbl_chc_id := ben_epe_cache.g_currcobjepe_row.elig_per_elctbl_chc_id;
704: l_epe.object_version_number := ben_epe_cache.g_currcobjepe_row.object_version_number;
705: l_epe.pl_id := ben_epe_cache.g_currcobjepe_row.pl_id;

Line 703: l_epe.elig_per_elctbl_chc_id := ben_epe_cache.g_currcobjepe_row.elig_per_elctbl_chc_id;

699: -- 5) Create Plan level certification.
700: --
701: if ben_epe_cache.g_currcobjepe_row.elig_per_elctbl_chc_id is not null then
702: --
703: l_epe.elig_per_elctbl_chc_id := ben_epe_cache.g_currcobjepe_row.elig_per_elctbl_chc_id;
704: l_epe.object_version_number := ben_epe_cache.g_currcobjepe_row.object_version_number;
705: l_epe.pl_id := ben_epe_cache.g_currcobjepe_row.pl_id;
706: l_epe.ler_id := ben_epe_cache.g_currcobjepe_row.ler_id;
707: l_epe.oipl_id := ben_epe_cache.g_currcobjepe_row.oipl_id;

Line 704: l_epe.object_version_number := ben_epe_cache.g_currcobjepe_row.object_version_number;

700: --
701: if ben_epe_cache.g_currcobjepe_row.elig_per_elctbl_chc_id is not null then
702: --
703: l_epe.elig_per_elctbl_chc_id := ben_epe_cache.g_currcobjepe_row.elig_per_elctbl_chc_id;
704: l_epe.object_version_number := ben_epe_cache.g_currcobjepe_row.object_version_number;
705: l_epe.pl_id := ben_epe_cache.g_currcobjepe_row.pl_id;
706: l_epe.ler_id := ben_epe_cache.g_currcobjepe_row.ler_id;
707: l_epe.oipl_id := ben_epe_cache.g_currcobjepe_row.oipl_id;
708: l_epe.business_group_id := ben_epe_cache.g_currcobjepe_row.business_group_id;

Line 705: l_epe.pl_id := ben_epe_cache.g_currcobjepe_row.pl_id;

701: if ben_epe_cache.g_currcobjepe_row.elig_per_elctbl_chc_id is not null then
702: --
703: l_epe.elig_per_elctbl_chc_id := ben_epe_cache.g_currcobjepe_row.elig_per_elctbl_chc_id;
704: l_epe.object_version_number := ben_epe_cache.g_currcobjepe_row.object_version_number;
705: l_epe.pl_id := ben_epe_cache.g_currcobjepe_row.pl_id;
706: l_epe.ler_id := ben_epe_cache.g_currcobjepe_row.ler_id;
707: l_epe.oipl_id := ben_epe_cache.g_currcobjepe_row.oipl_id;
708: l_epe.business_group_id := ben_epe_cache.g_currcobjepe_row.business_group_id;
709: l_epe.comp_lvl_cd := ben_epe_cache.g_currcobjepe_row.comp_lvl_cd;

Line 706: l_epe.ler_id := ben_epe_cache.g_currcobjepe_row.ler_id;

702: --
703: l_epe.elig_per_elctbl_chc_id := ben_epe_cache.g_currcobjepe_row.elig_per_elctbl_chc_id;
704: l_epe.object_version_number := ben_epe_cache.g_currcobjepe_row.object_version_number;
705: l_epe.pl_id := ben_epe_cache.g_currcobjepe_row.pl_id;
706: l_epe.ler_id := ben_epe_cache.g_currcobjepe_row.ler_id;
707: l_epe.oipl_id := ben_epe_cache.g_currcobjepe_row.oipl_id;
708: l_epe.business_group_id := ben_epe_cache.g_currcobjepe_row.business_group_id;
709: l_epe.comp_lvl_cd := ben_epe_cache.g_currcobjepe_row.comp_lvl_cd;
710: l_epe.pgm_id := ben_epe_cache.g_currcobjepe_row.pgm_id;

Line 707: l_epe.oipl_id := ben_epe_cache.g_currcobjepe_row.oipl_id;

703: l_epe.elig_per_elctbl_chc_id := ben_epe_cache.g_currcobjepe_row.elig_per_elctbl_chc_id;
704: l_epe.object_version_number := ben_epe_cache.g_currcobjepe_row.object_version_number;
705: l_epe.pl_id := ben_epe_cache.g_currcobjepe_row.pl_id;
706: l_epe.ler_id := ben_epe_cache.g_currcobjepe_row.ler_id;
707: l_epe.oipl_id := ben_epe_cache.g_currcobjepe_row.oipl_id;
708: l_epe.business_group_id := ben_epe_cache.g_currcobjepe_row.business_group_id;
709: l_epe.comp_lvl_cd := ben_epe_cache.g_currcobjepe_row.comp_lvl_cd;
710: l_epe.pgm_id := ben_epe_cache.g_currcobjepe_row.pgm_id;
711: l_epe.pl_typ_id := ben_epe_cache.g_currcobjepe_row.pl_typ_id;

Line 708: l_epe.business_group_id := ben_epe_cache.g_currcobjepe_row.business_group_id;

704: l_epe.object_version_number := ben_epe_cache.g_currcobjepe_row.object_version_number;
705: l_epe.pl_id := ben_epe_cache.g_currcobjepe_row.pl_id;
706: l_epe.ler_id := ben_epe_cache.g_currcobjepe_row.ler_id;
707: l_epe.oipl_id := ben_epe_cache.g_currcobjepe_row.oipl_id;
708: l_epe.business_group_id := ben_epe_cache.g_currcobjepe_row.business_group_id;
709: l_epe.comp_lvl_cd := ben_epe_cache.g_currcobjepe_row.comp_lvl_cd;
710: l_epe.pgm_id := ben_epe_cache.g_currcobjepe_row.pgm_id;
711: l_epe.pl_typ_id := ben_epe_cache.g_currcobjepe_row.pl_typ_id;
712: l_epe.opt_id := ben_epe_cache.g_currcobjepe_row.opt_id;

Line 709: l_epe.comp_lvl_cd := ben_epe_cache.g_currcobjepe_row.comp_lvl_cd;

705: l_epe.pl_id := ben_epe_cache.g_currcobjepe_row.pl_id;
706: l_epe.ler_id := ben_epe_cache.g_currcobjepe_row.ler_id;
707: l_epe.oipl_id := ben_epe_cache.g_currcobjepe_row.oipl_id;
708: l_epe.business_group_id := ben_epe_cache.g_currcobjepe_row.business_group_id;
709: l_epe.comp_lvl_cd := ben_epe_cache.g_currcobjepe_row.comp_lvl_cd;
710: l_epe.pgm_id := ben_epe_cache.g_currcobjepe_row.pgm_id;
711: l_epe.pl_typ_id := ben_epe_cache.g_currcobjepe_row.pl_typ_id;
712: l_epe.opt_id := ben_epe_cache.g_currcobjepe_row.opt_id;
713: l_epe.ctfn_rqd_flag := ben_epe_cache.g_currcobjepe_row.ctfn_rqd_flag;

Line 710: l_epe.pgm_id := ben_epe_cache.g_currcobjepe_row.pgm_id;

706: l_epe.ler_id := ben_epe_cache.g_currcobjepe_row.ler_id;
707: l_epe.oipl_id := ben_epe_cache.g_currcobjepe_row.oipl_id;
708: l_epe.business_group_id := ben_epe_cache.g_currcobjepe_row.business_group_id;
709: l_epe.comp_lvl_cd := ben_epe_cache.g_currcobjepe_row.comp_lvl_cd;
710: l_epe.pgm_id := ben_epe_cache.g_currcobjepe_row.pgm_id;
711: l_epe.pl_typ_id := ben_epe_cache.g_currcobjepe_row.pl_typ_id;
712: l_epe.opt_id := ben_epe_cache.g_currcobjepe_row.opt_id;
713: l_epe.ctfn_rqd_flag := ben_epe_cache.g_currcobjepe_row.ctfn_rqd_flag;
714: --

Line 711: l_epe.pl_typ_id := ben_epe_cache.g_currcobjepe_row.pl_typ_id;

707: l_epe.oipl_id := ben_epe_cache.g_currcobjepe_row.oipl_id;
708: l_epe.business_group_id := ben_epe_cache.g_currcobjepe_row.business_group_id;
709: l_epe.comp_lvl_cd := ben_epe_cache.g_currcobjepe_row.comp_lvl_cd;
710: l_epe.pgm_id := ben_epe_cache.g_currcobjepe_row.pgm_id;
711: l_epe.pl_typ_id := ben_epe_cache.g_currcobjepe_row.pl_typ_id;
712: l_epe.opt_id := ben_epe_cache.g_currcobjepe_row.opt_id;
713: l_epe.ctfn_rqd_flag := ben_epe_cache.g_currcobjepe_row.ctfn_rqd_flag;
714: --
715: /*

Line 712: l_epe.opt_id := ben_epe_cache.g_currcobjepe_row.opt_id;

708: l_epe.business_group_id := ben_epe_cache.g_currcobjepe_row.business_group_id;
709: l_epe.comp_lvl_cd := ben_epe_cache.g_currcobjepe_row.comp_lvl_cd;
710: l_epe.pgm_id := ben_epe_cache.g_currcobjepe_row.pgm_id;
711: l_epe.pl_typ_id := ben_epe_cache.g_currcobjepe_row.pl_typ_id;
712: l_epe.opt_id := ben_epe_cache.g_currcobjepe_row.opt_id;
713: l_epe.ctfn_rqd_flag := ben_epe_cache.g_currcobjepe_row.ctfn_rqd_flag;
714: --
715: /*
716: open c_epe;

Line 713: l_epe.ctfn_rqd_flag := ben_epe_cache.g_currcobjepe_row.ctfn_rqd_flag;

709: l_epe.comp_lvl_cd := ben_epe_cache.g_currcobjepe_row.comp_lvl_cd;
710: l_epe.pgm_id := ben_epe_cache.g_currcobjepe_row.pgm_id;
711: l_epe.pl_typ_id := ben_epe_cache.g_currcobjepe_row.pl_typ_id;
712: l_epe.opt_id := ben_epe_cache.g_currcobjepe_row.opt_id;
713: l_epe.ctfn_rqd_flag := ben_epe_cache.g_currcobjepe_row.ctfn_rqd_flag;
714: --
715: /*
716: open c_epe;
717: fetch c_epe into l_epe;