[Home] [Help]
PACKAGE: APPS.BEN_RTP_CACHE
Source
1 PACKAGE ben_rtp_cache AS
2 /* $Header: benrtpch.pkh 120.0 2005/12/01 17:24:48 kmahendr noship $ */
3 --
4 type g_cobcep_cache_rec is record
5 (vrbl_rt_prfl_id number
6 ,acty_base_rt_id number
7 ,cvg_amt_calc_mthd_id number
8 ,actl_prem_id number
9 ,rt_hrly_slrd_flag varchar2(30)
10 ,rt_pstl_cd_flag varchar2(30)
11 ,rt_lbr_mmbr_flag varchar2(30)
12 ,rt_lgl_enty_flag varchar2(30)
13 ,rt_benfts_grp_flag varchar2(30)
14 ,rt_wk_loc_flag varchar2(30)
15 ,rt_brgng_unit_flag varchar2(30)
16 ,rt_age_flag varchar2(30)
17 ,rt_los_flag varchar2(30)
18 ,rt_per_typ_flag varchar2(30)
19 ,rt_fl_tm_pt_tm_flag varchar2(30)
20 ,rt_ee_stat_flag varchar2(30)
21 ,rt_grd_flag varchar2(30)
22 ,rt_pct_fl_tm_flag varchar2(30)
23 ,rt_asnt_set_flag varchar2(30)
24 ,rt_hrs_wkd_flag varchar2(30)
25 ,rt_comp_lvl_flag varchar2(30)
26 ,rt_org_unit_flag varchar2(30)
27 ,rt_loa_rsn_flag varchar2(30)
28 ,rt_pyrl_flag varchar2(30)
29 ,rt_schedd_hrs_flag varchar2(30)
30 ,rt_py_bss_flag varchar2(30)
31 ,rt_prfl_rl_flag varchar2(30)
32 ,rt_cmbn_age_los_flag varchar2(30)
33 ,rt_prtt_pl_flag varchar2(30)
34 ,rt_svc_area_flag varchar2(30)
35 ,rt_ppl_grp_flag varchar2(30)
36 ,rt_dsbld_flag varchar2(30)
37 ,rt_hlth_cvg_flag varchar2(30)
38 ,rt_poe_flag varchar2(30)
39 ,rt_ttl_cvg_vol_flag varchar2(30)
40 ,rt_ttl_prtt_flag varchar2(30)
41 ,rt_gndr_flag varchar2(30)
42 ,rt_tbco_use_flag varchar2(30)
43 ,rt_cntng_prtn_prfl_flag varchar2(30)
44 ,rt_cbr_quald_bnf_flag varchar2(30)
45 ,rt_optd_mdcr_flag varchar2(30)
46 ,rt_lvg_rsn_flag varchar2(30)
47 ,rt_pstn_flag varchar2(30)
48 ,rt_comptncy_flag varchar2(30)
49 ,rt_job_flag varchar2(30)
50 ,rt_qual_titl_flag varchar2(30)
51 ,rt_dpnt_cvrd_pl_flag varchar2(30)
52 ,rt_dpnt_cvrd_plip_flag varchar2(30)
53 ,rt_dpnt_cvrd_ptip_flag varchar2(30)
54 ,rt_dpnt_cvrd_pgm_flag varchar2(30)
55 ,rt_enrld_oipl_flag varchar2(30)
56 ,rt_enrld_pl_flag varchar2(30)
57 ,rt_enrld_plip_flag varchar2(30)
58 ,rt_enrld_ptip_flag varchar2(30)
59 ,rt_enrld_pgm_flag varchar2(30)
60 ,rt_prtt_anthr_pl_flag varchar2(30)
61 ,rt_othr_ptip_flag varchar2(30)
62 ,rt_no_othr_cvg_flag varchar2(30)
63 ,rt_dpnt_othr_ptip_flag varchar2(30)
64 ,rt_qua_in_gr_flag varchar2(30)
65 ,rt_perf_rtng_flag varchar2(30)
66 ,asmt_to_use_cd varchar2(30)
67 ,ordr_num number
68 ,rt_elig_prfl_flag varchar2(30)
69 );
70 --
71 type g_cobcep_odcache is varray(1000000) of g_cobcep_cache_rec;
72 --
73 g_copcep_odlookup ben_cache.g_cache_lookup_table;
74 g_copcep_nxelenum number;
75 g_copcep_odinst g_cobcep_odcache := g_cobcep_odcache();
76 g_copcep_odcached pls_integer := 0;
77 --
78 g_hash_key pls_integer := 1299827;
79 g_hash_jump pls_integer := 100;
80 --
81 procedure clear_down_cache;
82 --
83 procedure abravr_odgetdets
84 (p_effective_date in date
85 ,p_acty_base_rt_id in number default hr_api.g_number
86 ,p_cvg_amt_calc_mthd_id in number default hr_api.g_number
87 ,p_actl_prem_id in number default hr_api.g_number
88 ,p_inst_set in out nocopy g_cobcep_odcache
89 );
90 --
91 END ben_rtp_cache;