1587: -- Do not call the caching code if called from CWB benmngle mode
1588: --
1589: if nvl(p_mode, 'OAB') <> 'W' then
1590: --
1591: if nvl(ben_epe_cache.g_currcobjepe_row.pl_id,hr_api.g_number) = nvl(p_pl_id,hr_api.g_number)
1592: and nvl(ben_epe_cache.g_currcobjepe_row.plip_id,hr_api.g_number) = nvl(p_plip_id,hr_api.g_number)
1593: and ben_epe_cache.g_currcobjepe_row.oipl_id is not null
1594: and p_oipl_id is null
1595: then
1588: --
1589: if nvl(p_mode, 'OAB') <> 'W' then
1590: --
1591: if nvl(ben_epe_cache.g_currcobjepe_row.pl_id,hr_api.g_number) = nvl(p_pl_id,hr_api.g_number)
1592: and nvl(ben_epe_cache.g_currcobjepe_row.plip_id,hr_api.g_number) = nvl(p_plip_id,hr_api.g_number)
1593: and ben_epe_cache.g_currcobjepe_row.oipl_id is not null
1594: and p_oipl_id is null
1595: then
1596: --
1589: if nvl(p_mode, 'OAB') <> 'W' then
1590: --
1591: if nvl(ben_epe_cache.g_currcobjepe_row.pl_id,hr_api.g_number) = nvl(p_pl_id,hr_api.g_number)
1592: and nvl(ben_epe_cache.g_currcobjepe_row.plip_id,hr_api.g_number) = nvl(p_plip_id,hr_api.g_number)
1593: and ben_epe_cache.g_currcobjepe_row.oipl_id is not null
1594: and p_oipl_id is null
1595: then
1596: --
1597: null;
1599: else
1600: --
1601: -- BENCVRGE
1602: --
1603: ben_epe_cache.g_currcobjepe_row.elig_per_elctbl_chc_id := l_elig_per_elctbl_chc_id;
1604: ben_epe_cache.g_currcobjepe_row.pl_id := p_pl_id;
1605: ben_epe_cache.g_currcobjepe_row.plip_id := p_plip_id;
1606: ben_epe_cache.g_currcobjepe_row.oipl_id := p_oipl_id;
1607: --
1600: --
1601: -- BENCVRGE
1602: --
1603: ben_epe_cache.g_currcobjepe_row.elig_per_elctbl_chc_id := l_elig_per_elctbl_chc_id;
1604: ben_epe_cache.g_currcobjepe_row.pl_id := p_pl_id;
1605: ben_epe_cache.g_currcobjepe_row.plip_id := p_plip_id;
1606: ben_epe_cache.g_currcobjepe_row.oipl_id := p_oipl_id;
1607: --
1608: -- BENDEPEN
1601: -- BENCVRGE
1602: --
1603: ben_epe_cache.g_currcobjepe_row.elig_per_elctbl_chc_id := l_elig_per_elctbl_chc_id;
1604: ben_epe_cache.g_currcobjepe_row.pl_id := p_pl_id;
1605: ben_epe_cache.g_currcobjepe_row.plip_id := p_plip_id;
1606: ben_epe_cache.g_currcobjepe_row.oipl_id := p_oipl_id;
1607: --
1608: -- BENDEPEN
1609: --
1602: --
1603: ben_epe_cache.g_currcobjepe_row.elig_per_elctbl_chc_id := l_elig_per_elctbl_chc_id;
1604: ben_epe_cache.g_currcobjepe_row.pl_id := p_pl_id;
1605: ben_epe_cache.g_currcobjepe_row.plip_id := p_plip_id;
1606: ben_epe_cache.g_currcobjepe_row.oipl_id := p_oipl_id;
1607: --
1608: -- BENDEPEN
1609: --
1610: ben_epe_cache.g_currcobjepe_row.elctbl_flag := p_elctbl_flag;
1606: ben_epe_cache.g_currcobjepe_row.oipl_id := p_oipl_id;
1607: --
1608: -- BENDEPEN
1609: --
1610: ben_epe_cache.g_currcobjepe_row.elctbl_flag := p_elctbl_flag;
1611: ben_epe_cache.g_currcobjepe_row.per_in_ler_id := p_per_in_ler_id;
1612: ben_epe_cache.g_currcobjepe_row.business_group_id := p_business_group_id;
1613: ben_epe_cache.g_currcobjepe_row.object_version_number := l_object_version_number;
1614: --
1607: --
1608: -- BENDEPEN
1609: --
1610: ben_epe_cache.g_currcobjepe_row.elctbl_flag := p_elctbl_flag;
1611: ben_epe_cache.g_currcobjepe_row.per_in_ler_id := p_per_in_ler_id;
1612: ben_epe_cache.g_currcobjepe_row.business_group_id := p_business_group_id;
1613: ben_epe_cache.g_currcobjepe_row.object_version_number := l_object_version_number;
1614: --
1615: -- BENCHCTF
1608: -- BENDEPEN
1609: --
1610: ben_epe_cache.g_currcobjepe_row.elctbl_flag := p_elctbl_flag;
1611: ben_epe_cache.g_currcobjepe_row.per_in_ler_id := p_per_in_ler_id;
1612: ben_epe_cache.g_currcobjepe_row.business_group_id := p_business_group_id;
1613: ben_epe_cache.g_currcobjepe_row.object_version_number := l_object_version_number;
1614: --
1615: -- BENCHCTF
1616: --
1609: --
1610: ben_epe_cache.g_currcobjepe_row.elctbl_flag := p_elctbl_flag;
1611: ben_epe_cache.g_currcobjepe_row.per_in_ler_id := p_per_in_ler_id;
1612: ben_epe_cache.g_currcobjepe_row.business_group_id := p_business_group_id;
1613: ben_epe_cache.g_currcobjepe_row.object_version_number := l_object_version_number;
1614: --
1615: -- BENCHCTF
1616: --
1617: ben_epe_cache.g_currcobjepe_row.comp_lvl_cd := p_comp_lvl_cd;
1613: ben_epe_cache.g_currcobjepe_row.object_version_number := l_object_version_number;
1614: --
1615: -- BENCHCTF
1616: --
1617: ben_epe_cache.g_currcobjepe_row.comp_lvl_cd := p_comp_lvl_cd;
1618: ben_epe_cache.g_currcobjepe_row.pgm_id := p_pgm_id;
1619: ben_epe_cache.g_currcobjepe_row.pl_typ_id := p_pl_typ_id;
1620: ben_epe_cache.g_currcobjepe_row.ctfn_rqd_flag := p_ctfn_rqd_flag;
1621: --
1614: --
1615: -- BENCHCTF
1616: --
1617: ben_epe_cache.g_currcobjepe_row.comp_lvl_cd := p_comp_lvl_cd;
1618: ben_epe_cache.g_currcobjepe_row.pgm_id := p_pgm_id;
1619: ben_epe_cache.g_currcobjepe_row.pl_typ_id := p_pl_typ_id;
1620: ben_epe_cache.g_currcobjepe_row.ctfn_rqd_flag := p_ctfn_rqd_flag;
1621: --
1622: end if;
1615: -- BENCHCTF
1616: --
1617: ben_epe_cache.g_currcobjepe_row.comp_lvl_cd := p_comp_lvl_cd;
1618: ben_epe_cache.g_currcobjepe_row.pgm_id := p_pgm_id;
1619: ben_epe_cache.g_currcobjepe_row.pl_typ_id := p_pl_typ_id;
1620: ben_epe_cache.g_currcobjepe_row.ctfn_rqd_flag := p_ctfn_rqd_flag;
1621: --
1622: end if;
1623: --
1616: --
1617: ben_epe_cache.g_currcobjepe_row.comp_lvl_cd := p_comp_lvl_cd;
1618: ben_epe_cache.g_currcobjepe_row.pgm_id := p_pgm_id;
1619: ben_epe_cache.g_currcobjepe_row.pl_typ_id := p_pl_typ_id;
1620: ben_epe_cache.g_currcobjepe_row.ctfn_rqd_flag := p_ctfn_rqd_flag;
1621: --
1622: end if;
1623: --
1624: end if;
2639: end if;
2640: --
2641: -- Set EPE comp object context values
2642: --
2643: if ben_epe_cache.g_currcobjepe_row.elig_per_elctbl_chc_id is not null then
2644: --
2645: -- BENDEPEN
2646: --
2647: ben_epe_cache.g_currcobjepe_row.alws_dpnt_dsgn_flag := l_rec.alws_dpnt_dsgn_flag;
2643: if ben_epe_cache.g_currcobjepe_row.elig_per_elctbl_chc_id is not null then
2644: --
2645: -- BENDEPEN
2646: --
2647: ben_epe_cache.g_currcobjepe_row.alws_dpnt_dsgn_flag := l_rec.alws_dpnt_dsgn_flag;
2648: ben_epe_cache.g_currcobjepe_row.object_version_number := l_object_version_number;
2649: ben_epe_cache.g_currcobjepe_row.dpnt_dsgn_cd := l_rec.dpnt_dsgn_cd;
2650: ben_epe_cache.g_currcobjepe_row.ler_chg_dpnt_cvg_cd := l_rec.ler_chg_dpnt_cvg_cd;
2651: ben_epe_cache.g_currcobjepe_row.dpnt_cvg_strt_dt_cd := l_rec.dpnt_cvg_strt_dt_cd;
2644: --
2645: -- BENDEPEN
2646: --
2647: ben_epe_cache.g_currcobjepe_row.alws_dpnt_dsgn_flag := l_rec.alws_dpnt_dsgn_flag;
2648: ben_epe_cache.g_currcobjepe_row.object_version_number := l_object_version_number;
2649: ben_epe_cache.g_currcobjepe_row.dpnt_dsgn_cd := l_rec.dpnt_dsgn_cd;
2650: ben_epe_cache.g_currcobjepe_row.ler_chg_dpnt_cvg_cd := l_rec.ler_chg_dpnt_cvg_cd;
2651: ben_epe_cache.g_currcobjepe_row.dpnt_cvg_strt_dt_cd := l_rec.dpnt_cvg_strt_dt_cd;
2652: ben_epe_cache.g_currcobjepe_row.dpnt_cvg_strt_dt_rl := l_rec.dpnt_cvg_strt_dt_rl;
2645: -- BENDEPEN
2646: --
2647: ben_epe_cache.g_currcobjepe_row.alws_dpnt_dsgn_flag := l_rec.alws_dpnt_dsgn_flag;
2648: ben_epe_cache.g_currcobjepe_row.object_version_number := l_object_version_number;
2649: ben_epe_cache.g_currcobjepe_row.dpnt_dsgn_cd := l_rec.dpnt_dsgn_cd;
2650: ben_epe_cache.g_currcobjepe_row.ler_chg_dpnt_cvg_cd := l_rec.ler_chg_dpnt_cvg_cd;
2651: ben_epe_cache.g_currcobjepe_row.dpnt_cvg_strt_dt_cd := l_rec.dpnt_cvg_strt_dt_cd;
2652: ben_epe_cache.g_currcobjepe_row.dpnt_cvg_strt_dt_rl := l_rec.dpnt_cvg_strt_dt_rl;
2653: --
2646: --
2647: ben_epe_cache.g_currcobjepe_row.alws_dpnt_dsgn_flag := l_rec.alws_dpnt_dsgn_flag;
2648: ben_epe_cache.g_currcobjepe_row.object_version_number := l_object_version_number;
2649: ben_epe_cache.g_currcobjepe_row.dpnt_dsgn_cd := l_rec.dpnt_dsgn_cd;
2650: ben_epe_cache.g_currcobjepe_row.ler_chg_dpnt_cvg_cd := l_rec.ler_chg_dpnt_cvg_cd;
2651: ben_epe_cache.g_currcobjepe_row.dpnt_cvg_strt_dt_cd := l_rec.dpnt_cvg_strt_dt_cd;
2652: ben_epe_cache.g_currcobjepe_row.dpnt_cvg_strt_dt_rl := l_rec.dpnt_cvg_strt_dt_rl;
2653: --
2654: -- BENCHCTF
2647: ben_epe_cache.g_currcobjepe_row.alws_dpnt_dsgn_flag := l_rec.alws_dpnt_dsgn_flag;
2648: ben_epe_cache.g_currcobjepe_row.object_version_number := l_object_version_number;
2649: ben_epe_cache.g_currcobjepe_row.dpnt_dsgn_cd := l_rec.dpnt_dsgn_cd;
2650: ben_epe_cache.g_currcobjepe_row.ler_chg_dpnt_cvg_cd := l_rec.ler_chg_dpnt_cvg_cd;
2651: ben_epe_cache.g_currcobjepe_row.dpnt_cvg_strt_dt_cd := l_rec.dpnt_cvg_strt_dt_cd;
2652: ben_epe_cache.g_currcobjepe_row.dpnt_cvg_strt_dt_rl := l_rec.dpnt_cvg_strt_dt_rl;
2653: --
2654: -- BENCHCTF
2655: --
2648: ben_epe_cache.g_currcobjepe_row.object_version_number := l_object_version_number;
2649: ben_epe_cache.g_currcobjepe_row.dpnt_dsgn_cd := l_rec.dpnt_dsgn_cd;
2650: ben_epe_cache.g_currcobjepe_row.ler_chg_dpnt_cvg_cd := l_rec.ler_chg_dpnt_cvg_cd;
2651: ben_epe_cache.g_currcobjepe_row.dpnt_cvg_strt_dt_cd := l_rec.dpnt_cvg_strt_dt_cd;
2652: ben_epe_cache.g_currcobjepe_row.dpnt_cvg_strt_dt_rl := l_rec.dpnt_cvg_strt_dt_rl;
2653: --
2654: -- BENCHCTF
2655: --
2656: ben_epe_cache.g_currcobjepe_row.ctfn_rqd_flag := l_rec.ctfn_rqd_flag;
2652: ben_epe_cache.g_currcobjepe_row.dpnt_cvg_strt_dt_rl := l_rec.dpnt_cvg_strt_dt_rl;
2653: --
2654: -- BENCHCTF
2655: --
2656: ben_epe_cache.g_currcobjepe_row.ctfn_rqd_flag := l_rec.ctfn_rqd_flag;
2657: --
2658: -- BENCVRGE
2659: --
2660: ben_epe_cache.g_currcobjepe_row.elctbl_flag := l_rec.elctbl_flag;
2656: ben_epe_cache.g_currcobjepe_row.ctfn_rqd_flag := l_rec.ctfn_rqd_flag;
2657: --
2658: -- BENCVRGE
2659: --
2660: ben_epe_cache.g_currcobjepe_row.elctbl_flag := l_rec.elctbl_flag;
2661: ben_epe_cache.g_currcobjepe_row.dflt_flag := l_rec.dflt_flag;
2662: --
2663: end if;
2664: --
2657: --
2658: -- BENCVRGE
2659: --
2660: ben_epe_cache.g_currcobjepe_row.elctbl_flag := l_rec.elctbl_flag;
2661: ben_epe_cache.g_currcobjepe_row.dflt_flag := l_rec.dflt_flag;
2662: --
2663: end if;
2664: --
2665: -- Set all output arguments