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.
PACKAGE: APPS.BEN_CEP_CACHE

Source


1 PACKAGE ben_cep_cache AUTHID CURRENT_USER AS
2 /* $Header: bencepch.pkh 120.1 2006/01/12 21:00:56 mhoyes noship $ */
3 --
4 type g_cobcep_cache_rec is record
5   (id number
6   ,pgm_id ben_prtn_elig_f.pgm_id%type
7   ,ptip_id ben_prtn_elig_f.ptip_id%type
8   ,plip_id ben_prtn_elig_f.plip_id%type
9   ,pl_id ben_prtn_elig_f.pl_id%type
10   ,oipl_id ben_prtn_elig_f.oipl_id%type
11   -- Grade/Step
12   ,vrbl_rt_prfl_id       ben_vrbl_rt_prfl_f.vrbl_rt_prfl_id%type
13   ,prtn_elig_id ben_prtn_elig_f.prtn_elig_id%type
14   ,trk_scr_for_inelg_flag ben_prtn_elig_f.trk_scr_for_inelg_flag%type
15   ,compute_score_flag ben_prtn_elig_prfl_f.compute_score_flag%type
16   ,mndtry_flag ben_prtn_elig_prfl_f.mndtry_flag%type
17   ,eligy_prfl_id ben_eligy_prfl_f.eligy_prfl_id%type
18   ,asmt_to_use_cd ben_eligy_prfl_f.asmt_to_use_cd%type
19   ,elig_enrld_plip_flag varchar2(30)
20   ,elig_cbr_quald_bnf_flag varchar2(30)
21   ,elig_enrld_ptip_flag varchar2(30)
22   ,elig_dpnt_cvrd_plip_flag varchar2(30)
23   ,elig_dpnt_cvrd_ptip_flag varchar2(30)
24   ,elig_dpnt_cvrd_pgm_flag varchar2(30)
25   ,elig_job_flag varchar2(30)
26   ,elig_hrly_slrd_flag varchar2(30)
27   ,elig_pstl_cd_flag varchar2(30)
28   ,elig_lbr_mmbr_flag varchar2(30)
29   ,elig_lgl_enty_flag varchar2(30)
30   ,elig_benfts_grp_flag varchar2(30)
31   ,elig_wk_loc_flag varchar2(30)
32   ,elig_brgng_unit_flag varchar2(30)
33   ,elig_age_flag varchar2(30)
34   ,elig_los_flag varchar2(30)
35   ,elig_per_typ_flag varchar2(30)
36   ,elig_fl_tm_pt_tm_flag varchar2(30)
37   ,elig_ee_stat_flag varchar2(30)
38   ,elig_grd_flag varchar2(30)
39   ,elig_pct_fl_tm_flag varchar2(30)
40   ,elig_asnt_set_flag varchar2(30)
41   ,elig_hrs_wkd_flag varchar2(30)
42   ,elig_comp_lvl_flag varchar2(30)
43   ,elig_org_unit_flag varchar2(30)
44   ,elig_loa_rsn_flag varchar2(30)
45   ,elig_pyrl_flag varchar2(30)
46   ,elig_schedd_hrs_flag varchar2(30)
47   ,elig_py_bss_flag varchar2(30)
48   ,eligy_prfl_rl_flag varchar2(30)
49   ,elig_cmbn_age_los_flag varchar2(30)
50   ,cntng_prtn_elig_prfl_flag varchar2(30)
51   ,elig_prtt_pl_flag varchar2(30)
52   ,elig_ppl_grp_flag varchar2(30)
53   ,elig_svc_area_flag varchar2(30)
54   ,elig_ptip_prte_flag varchar2(30)
55   ,elig_no_othr_cvg_flag varchar2(30)
56   ,elig_enrld_pl_flag varchar2(30)
57   ,elig_enrld_oipl_flag varchar2(30)
58   ,elig_enrld_pgm_flag varchar2(30)
59   ,elig_dpnt_cvrd_pl_flag varchar2(30)
60   ,elig_lvg_rsn_flag varchar2(30)
61   ,elig_optd_mdcr_flag varchar2(30)
62   ,elig_tbco_use_flag varchar2(30)
63   ,elig_dpnt_othr_ptip_flag varchar2(30)
64   ,ELIG_GNDR_FLAG varchar2(30)
65   ,ELIG_MRTL_STS_FLAG varchar2(30)
66   ,ELIG_DSBLTY_CTG_FLAG varchar2(30)
67   ,ELIG_DSBLTY_RSN_FLAG varchar2(30)
68   ,ELIG_DSBLTY_DGR_FLAG varchar2(30)
69   ,ELIG_SUPPL_ROLE_FLAG varchar2(30)
70   ,ELIG_QUAL_TITL_FLAG varchar2(30)
71   ,ELIG_PSTN_FLAG varchar2(30)
72   ,ELIG_PRBTN_PERD_FLAG varchar2(30)
73   ,ELIG_SP_CLNG_PRG_PT_FLAG varchar2(30)
74   ,BNFT_CAGR_PRTN_CD varchar2(30)
75   ,elig_dsbld_flag varchar2(30)
76   ,elig_ttl_cvg_vol_flag varchar2(30)
77   ,elig_ttl_prtt_flag varchar2(30)
78   ,elig_comptncy_flag varchar2(30)
79   ,elig_hlth_cvg_flag varchar2(30)
80   ,elig_anthr_pl_flag varchar2(30)
81   ,elig_qua_in_gr_flag varchar2(30)
82   ,elig_perf_rtng_flag varchar2(30)
83   ,elig_crit_values_flag varchar2(30)
84   );
85 --
86 type g_cobcep_odcache is varray(1000000) of g_cobcep_cache_rec;
87 --
88 g_copcep_odlookup ben_cache.g_cache_lookup_table;
89 g_copcep_nxelenum number;
90 g_copcep_odinst    g_cobcep_odcache :=  g_cobcep_odcache();
91 g_copcep_odcached pls_integer := 0;
92 --
93 g_hash_key  pls_integer := 1299827;
94 g_hash_jump pls_integer := 100;
95 --
96 procedure clear_down_cache;
97 --
98 procedure cobcep_odgetdets
99   (p_effective_date  in     date
100   ,p_pgm_id          in     number
101   ,p_pl_id           in     number
102   ,p_oipl_id         in     number
103   ,p_plip_id         in     number
104   ,p_ptip_id         in     number
105   -- Grade/Step
106   ,p_vrbl_rt_prfl_id in     number
107   --
108   ,p_inst_set        in out nocopy  g_cobcep_odcache
109   );
110 --
111 END ben_cep_cache;