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 578: l_epe ben_epe_cache.g_pilepe_inst_row;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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