[Home] [Help]
PACKAGE: APPS.BEN_COBJ_CACHE
Source
1 package ben_cobj_cache AUTHID CURRENT_USER as
2 /* $Header: becobjch.pkh 120.2 2006/03/13 17:12:36 kmahendr noship $*/
3 --
4 /*
5 +==============================================================================+
6 | Copyright (c) 1997 Oracle Corporation |
7 | Redwood Shores, California, USA |
8 | All rights reserved. |
9 +==============================================================================+
10 --
11 History
12 Version Date Who What?
13 --------- --------- ---------- --------------------------------------------
14 115.0 28-Jun-99 mhoyes Created.
15 115.1 13-Jul-00 mhoyes Added pgm,ptip,plip,prel and etpr caches.
16 115.2 17-May-01 maagrawa Added columns to pgm,pl,plip,ptip,oipl
17 records.
18 115.3 22-May-01 mhoyes - Upgraded comp object caches to be context
19 sensitive. Hence when the refresh routine is
20 not called then the cache will use SQL.
21 115.4 26-Jul-01 ikasire Bug1895874 added nip_dflt_flag to ben_pl_f
22 table needs to be cached for bendenrr
23 115.7 29-Nov-05 abparekh Bug 4766118 - Added ALWS_QDRO_FLAG to G_PL_INST_ROW
24 115.8 13-Mar-06 kmahendr bug#5082245 - added svgs_pl_flag to g_pl_inst_ro
25 -----------------------------------------------------------------------------
26 */
27 --
28 type g_oiplip_inst_row is record
29 (oiplip_id ben_oiplip_f.oiplip_id%type
30 ,plip_id ben_oiplip_f.plip_id%type
31 ,oipl_id ben_oiplip_f.oipl_id%type
32 );
33 --
34 type g_oiplip_inst_tbl is table of g_oiplip_inst_row
35 index by binary_integer;
36 --
37 g_oiplip_lookup ben_cache.g_cache_lookup_table;
38 g_oiplip_instance g_oiplip_inst_tbl;
39 g_oiplip_currow g_oiplip_inst_row;
40 g_oiplip_cached pls_integer := 0;
41 --
42 procedure get_oiplip_dets
43 (p_business_group_id in number
44 ,p_effective_date in date
45 ,p_oiplip_id in number default null
46 ,p_inst_row in out NOCOPY g_oiplip_inst_row
47 );
48 --
49 type g_opt_inst_row is record
50 (opt_id ben_opt_f.opt_id%type
51 ,name ben_opt_f.name%type
52 ,effective_start_date ben_opt_f.effective_start_date%type
53 ,effective_end_date ben_opt_f.effective_end_date%type
54 ,rqd_perd_enrt_nenrt_uom ben_opt_f.rqd_perd_enrt_nenrt_uom%type
55 ,rqd_perd_enrt_nenrt_val ben_opt_f.rqd_perd_enrt_nenrt_val%type
56 ,rqd_perd_enrt_nenrt_rl ben_opt_f.rqd_perd_enrt_nenrt_rl%type
57 );
58 --
59 type g_opt_inst_tbl is table of g_opt_inst_row
60 index by binary_integer;
61 --
62 g_opt_lookup ben_cache.g_cache_lookup_table;
63 g_opt_instance g_opt_inst_tbl;
64 g_opt_currow g_opt_inst_row;
65 g_opt_cached pls_integer := 0;
66 --
67 procedure get_opt_dets
68 (p_business_group_id in number
69 ,p_effective_date in date
70 ,p_opt_id in number default null
71 ,p_inst_row in out NOCOPY g_opt_inst_row
72 );
73 --
74 type g_oipl_inst_row is record
75 (oipl_id ben_oipl_f.oipl_id%type
76 ,effective_start_date ben_oipl_f.effective_start_date%type
77 ,effective_end_date ben_oipl_f.effective_end_date%type
78 ,opt_id ben_oipl_f.opt_id%type
79 ,pl_id ben_oipl_f.pl_id%type
80 ,trk_inelig_per_flag ben_oipl_f.trk_inelig_per_flag%type
81 ,ordr_num ben_oipl_f.ordr_num%type
82 ,elig_apls_flag ben_oipl_f.elig_apls_flag%type
83 ,prtn_elig_ovrid_alwd_flag ben_oipl_f.prtn_elig_ovrid_alwd_flag%type
84 ,vrfy_fmly_mmbr_cd ben_oipl_f.vrfy_fmly_mmbr_cd%type
85 ,vrfy_fmly_mmbr_rl ben_oipl_f.vrfy_fmly_mmbr_rl%type
86 ,per_cvrd_cd ben_oipl_f.per_cvrd_cd%type
87 ,dflt_flag ben_oipl_f.dflt_flag%type
88 ,mndtry_flag ben_oipl_f.mndtry_flag%type
89 ,mndtry_rl ben_oipl_f.mndtry_rl%type
90 ,auto_enrt_flag ben_oipl_f.auto_enrt_flag%type
91 ,auto_enrt_mthd_rl ben_oipl_f.auto_enrt_mthd_rl%type
92 ,enrt_cd ben_oipl_f.enrt_cd%type
93 ,enrt_rl ben_oipl_f.enrt_rl%type
94 ,dflt_enrt_cd ben_oipl_f.dflt_enrt_cd%type
95 ,dflt_enrt_det_rl ben_oipl_f.dflt_enrt_det_rl%type
96 ,rqd_perd_enrt_nenrt_uom ben_oipl_f.rqd_perd_enrt_nenrt_uom%type
97 ,rqd_perd_enrt_nenrt_val ben_oipl_f.rqd_perd_enrt_nenrt_val%type
98 ,rqd_perd_enrt_nenrt_rl ben_oipl_f.rqd_perd_enrt_nenrt_rl%type
99 ,actl_prem_id ben_oipl_f.actl_prem_id%type
100 ,postelcn_edit_rl ben_oipl_f.postelcn_edit_rl%type
101 );
102 --
103 type g_oipl_inst_tbl is table of g_oipl_inst_row
104 index by binary_integer;
105 --
106 g_oipl_lookup ben_cache.g_cache_lookup_table;
107 g_oipl_instance g_oipl_inst_tbl;
108 g_oipl_currow g_oipl_inst_row;
109 g_oipl_cached pls_integer := 0;
110 --
111 procedure get_oipl_dets
112 (p_business_group_id in number
113 ,p_effective_date in date
114 ,p_oipl_id in number default null
115 ,p_inst_row in out NOCOPY g_oipl_inst_row
116 );
117 --
118 type g_pgm_inst_row is record
119 (pgm_id ben_pgm_f.pgm_id%type
120 ,effective_start_date ben_pgm_f.effective_start_date%type
121 ,effective_end_date ben_pgm_f.effective_end_date%type
122 ,enrt_cvg_strt_dt_cd ben_pgm_f.enrt_cvg_strt_dt_cd%type
123 ,enrt_cvg_strt_dt_rl ben_pgm_f.enrt_cvg_strt_dt_rl%type
124 ,enrt_cvg_end_dt_cd ben_pgm_f.enrt_cvg_end_dt_cd%type
125 ,enrt_cvg_end_dt_rl ben_pgm_f.enrt_cvg_end_dt_rl%type
126 ,rt_strt_dt_cd ben_pgm_f.rt_strt_dt_cd%type
127 ,rt_strt_dt_rl ben_pgm_f.rt_strt_dt_rl%type
128 ,rt_end_dt_cd ben_pgm_f.rt_end_dt_cd%type
129 ,rt_end_dt_rl ben_pgm_f.rt_end_dt_rl%type
130 ,elig_apls_flag ben_pgm_f.elig_apls_flag%type
131 ,prtn_elig_ovrid_alwd_flag ben_pgm_f.prtn_elig_ovrid_alwd_flag%type
132 ,trk_inelig_per_flag ben_pgm_f.trk_inelig_per_flag%type
133 ,vrfy_fmly_mmbr_cd ben_pgm_f.vrfy_fmly_mmbr_cd%type
134 ,vrfy_fmly_mmbr_rl ben_pgm_f.vrfy_fmly_mmbr_rl%type
135 ,dpnt_dsgn_lvl_cd ben_pgm_f.dpnt_dsgn_lvl_cd%type
136 ,dpnt_dsgn_cd ben_pgm_f.dpnt_dsgn_cd%type
137 ,dpnt_cvg_strt_dt_cd ben_pgm_f.dpnt_cvg_strt_dt_cd%type
138 ,dpnt_cvg_strt_dt_rl ben_pgm_f.dpnt_cvg_strt_dt_rl%type
139 ,dpnt_cvg_end_dt_cd ben_pgm_f.dpnt_cvg_end_dt_cd%type
140 ,dpnt_cvg_end_dt_rl ben_pgm_f.dpnt_cvg_end_dt_rl%type
141 ,pgm_typ_cd ben_pgm_f.pgm_typ_cd%type
142 );
143 --
144 type g_pgm_inst_tbl is table of g_pgm_inst_row
145 index by binary_integer;
146 --
147 g_pgm_lookup ben_cache.g_cache_lookup_table;
148 g_pgm_instance g_pgm_inst_tbl;
149 g_pgm_currow g_pgm_inst_row;
150 g_pgm_cached pls_integer := 0;
151 --
152 g_pgm_default_row g_pgm_inst_row;
153 --
154 procedure get_pgm_dets
155 (p_business_group_id in number
156 ,p_effective_date in date
157 ,p_pgm_id in number default null
158 ,p_inst_row in out NOCOPY g_pgm_inst_row
159 );
160 --
161 type g_ptip_inst_row is record
162 (ptip_id ben_ptip_f.ptip_id%type
163 ,effective_start_date ben_ptip_f.effective_start_date%type
164 ,effective_end_date ben_ptip_f.effective_end_date%type
165 ,enrt_cvg_strt_dt_cd ben_ptip_f.enrt_cvg_strt_dt_cd%type
166 ,enrt_cvg_strt_dt_rl ben_ptip_f.enrt_cvg_strt_dt_rl%type
167 ,enrt_cvg_end_dt_cd ben_ptip_f.enrt_cvg_end_dt_cd%type
168 ,enrt_cvg_end_dt_rl ben_ptip_f.enrt_cvg_end_dt_rl%type
169 ,rt_strt_dt_cd ben_ptip_f.rt_strt_dt_cd%type
170 ,rt_strt_dt_rl ben_ptip_f.rt_strt_dt_rl%type
171 ,rt_end_dt_cd ben_ptip_f.rt_end_dt_cd%type
172 ,rt_end_dt_rl ben_ptip_f.rt_end_dt_rl%type
173 ,elig_apls_flag ben_ptip_f.elig_apls_flag%type
174 ,prtn_elig_ovrid_alwd_flag ben_ptip_f.prtn_elig_ovrid_alwd_flag%type
175 ,trk_inelig_per_flag ben_ptip_f.trk_inelig_per_flag%type
176 ,ordr_num ben_ptip_f.ordr_num%type
177 ,vrfy_fmly_mmbr_cd ben_ptip_f.vrfy_fmly_mmbr_cd%type
178 ,vrfy_fmly_mmbr_rl ben_ptip_f.vrfy_fmly_mmbr_rl%type
179 ,rqd_perd_enrt_nenrt_tm_uom ben_ptip_f.rqd_perd_enrt_nenrt_tm_uom%type
180 ,rqd_perd_enrt_nenrt_val ben_ptip_f.rqd_perd_enrt_nenrt_val%type
181 ,rqd_perd_enrt_nenrt_rl ben_ptip_f.rqd_perd_enrt_nenrt_rl%type
182 ,dpnt_dsgn_cd ben_ptip_f.dpnt_dsgn_cd%type
183 ,dpnt_cvg_strt_dt_cd ben_ptip_f.dpnt_cvg_strt_dt_cd%type
184 ,dpnt_cvg_strt_dt_rl ben_ptip_f.dpnt_cvg_strt_dt_rl%type
185 ,dpnt_cvg_end_dt_cd ben_ptip_f.dpnt_cvg_end_dt_cd%type
186 ,dpnt_cvg_end_dt_rl ben_ptip_f.dpnt_cvg_end_dt_rl%type
187 ,postelcn_edit_rl ben_ptip_f.postelcn_edit_rl%type
188 );
189 --
190 type g_ptip_inst_tbl is table of g_ptip_inst_row
191 index by binary_integer;
192 --
193 g_ptip_lookup ben_cache.g_cache_lookup_table;
194 g_ptip_instance g_ptip_inst_tbl;
195 g_ptip_currow g_ptip_inst_row;
196 g_ptip_cached pls_integer := 0;
197 --
198 g_ptip_default_row g_ptip_inst_row;
199 --
200 procedure get_ptip_dets
201 (p_business_group_id in number
202 ,p_effective_date in date
203 ,p_ptip_id in number default null
204 ,p_inst_row in out NOCOPY g_ptip_inst_row
205 );
206 --
207 type g_plip_inst_row is record
208 (plip_id ben_plip_f.plip_id%type
209 ,effective_start_date ben_plip_f.effective_start_date%type
210 ,effective_end_date ben_plip_f.effective_end_date%type
211 ,enrt_cvg_strt_dt_cd ben_plip_f.enrt_cvg_strt_dt_cd%type
212 ,enrt_cvg_strt_dt_rl ben_plip_f.enrt_cvg_strt_dt_rl%type
213 ,enrt_cvg_end_dt_cd ben_plip_f.enrt_cvg_end_dt_cd%type
214 ,enrt_cvg_end_dt_rl ben_plip_f.enrt_cvg_end_dt_rl%type
215 ,rt_strt_dt_cd ben_plip_f.rt_strt_dt_cd%type
216 ,rt_strt_dt_rl ben_plip_f.rt_strt_dt_rl%type
217 ,rt_end_dt_cd ben_plip_f.rt_end_dt_cd%type
218 ,rt_end_dt_rl ben_plip_f.rt_end_dt_rl%type
219 ,elig_apls_flag ben_plip_f.elig_apls_flag%type
220 ,prtn_elig_ovrid_alwd_flag ben_plip_f.prtn_elig_ovrid_alwd_flag%type
221 ,trk_inelig_per_flag ben_plip_f.trk_inelig_per_flag%type
222 ,ordr_num ben_plip_f.ordr_num%type
223 ,vrfy_fmly_mmbr_cd ben_plip_f.vrfy_fmly_mmbr_cd%type
224 ,vrfy_fmly_mmbr_rl ben_plip_f.vrfy_fmly_mmbr_rl%type
225 ,bnft_or_option_rstrctn_cd ben_plip_f.bnft_or_option_rstrctn_cd%type
226 ,pl_id ben_plip_f.pl_id%type
227 ,pgm_id ben_plip_f.pgm_id%type
228 ,cvg_incr_r_decr_only_cd ben_plip_f.cvg_incr_r_decr_only_cd%type
229 ,mx_cvg_mlt_incr_num ben_plip_f.mx_cvg_mlt_incr_num%type
230 ,mx_cvg_mlt_incr_wcf_num ben_plip_f.mx_cvg_mlt_incr_wcf_num%type
231 ,postelcn_edit_rl ben_plip_f.postelcn_edit_rl%type
232 );
233 --
234 type g_plip_inst_tbl is table of g_plip_inst_row
235 index by binary_integer;
236 --
237 g_plip_lookup ben_cache.g_cache_lookup_table;
238 g_plip_instance g_plip_inst_tbl;
239 g_plip_currow g_plip_inst_row;
240 g_plip_cached pls_integer := 0;
241 --
242 g_plip_default_row g_plip_inst_row;
243 --
244 procedure get_plip_dets
245 (p_business_group_id in number
246 ,p_effective_date in date
247 ,p_plip_id in number default null
248 ,p_inst_row in out NOCOPY g_plip_inst_row
249 );
250 --
251 type g_pl_inst_row is record
252 (pl_id ben_pl_f.pl_id%type
253 ,effective_start_date ben_pl_f.effective_start_date%type
254 ,effective_end_date ben_pl_f.effective_end_date%type
255 ,enrt_cvg_strt_dt_cd ben_pl_f.enrt_cvg_strt_dt_cd%type
256 ,enrt_cvg_strt_dt_rl ben_pl_f.enrt_cvg_strt_dt_rl%type
257 ,enrt_cvg_end_dt_cd ben_pl_f.enrt_cvg_end_dt_cd%type
258 ,enrt_cvg_end_dt_rl ben_pl_f.enrt_cvg_end_dt_rl%type
259 ,rt_strt_dt_cd ben_pl_f.rt_strt_dt_cd%type
260 ,rt_strt_dt_rl ben_pl_f.rt_strt_dt_rl%type
261 ,rt_end_dt_cd ben_pl_f.rt_end_dt_cd%type
262 ,rt_end_dt_rl ben_pl_f.rt_end_dt_rl%type
263 ,elig_apls_flag ben_pl_f.elig_apls_flag%type
264 ,prtn_elig_ovrid_alwd_flag ben_pl_f.prtn_elig_ovrid_alwd_flag%type
265 ,per_cvrd_cd ben_pl_f.per_cvrd_cd%type
266 ,pl_typ_id ben_pl_f.pl_typ_id%type
267 ,trk_inelig_per_flag ben_pl_f.trk_inelig_per_flag%type
268 ,ordr_num ben_pl_f.ordr_num%type
269 ,mx_wtg_dt_to_use_cd ben_pl_f.mx_wtg_dt_to_use_cd%type
270 ,mx_wtg_dt_to_use_rl ben_pl_f.mx_wtg_dt_to_use_rl%type
271 ,mx_wtg_perd_rl ben_pl_f.mx_wtg_perd_rl%type
272 ,mx_wtg_perd_prte_uom ben_pl_f.mx_wtg_perd_prte_uom%type
273 ,mx_wtg_perd_prte_val ben_pl_f.mx_wtg_perd_prte_val%type
274 ,vrfy_fmly_mmbr_cd ben_pl_f.vrfy_fmly_mmbr_cd%type
275 ,vrfy_fmly_mmbr_rl ben_pl_f.vrfy_fmly_mmbr_rl%type
276 ,bnft_or_option_rstrctn_cd ben_pl_f.bnft_or_option_rstrctn_cd%type
277 ,nip_dflt_enrt_cd ben_pl_f.nip_dflt_enrt_cd%type
278 ,nip_dflt_enrt_det_rl ben_pl_f.nip_dflt_enrt_det_rl%type
279 ,rqd_perd_enrt_nenrt_uom ben_pl_f.rqd_perd_enrt_nenrt_uom%type
280 ,rqd_perd_enrt_nenrt_val ben_pl_f.rqd_perd_enrt_nenrt_val%type
281 ,rqd_perd_enrt_nenrt_rl ben_pl_f.rqd_perd_enrt_nenrt_rl%type
282 ,cvg_incr_r_decr_only_cd ben_pl_f.cvg_incr_r_decr_only_cd%type
283 ,mx_cvg_mlt_incr_num ben_pl_f.mx_cvg_mlt_incr_num%type
284 ,mx_cvg_mlt_incr_wcf_num ben_pl_f.mx_cvg_mlt_incr_wcf_num%type
285 ,name ben_pl_f.name%type
286 ,actl_prem_id ben_pl_f.actl_prem_id%type
287 ,bnf_dsgn_cd ben_pl_f.bnf_dsgn_cd%type
288 ,enrt_pl_opt_flag ben_pl_f.enrt_pl_opt_flag%type
289 ,dpnt_cvg_strt_dt_cd ben_pl_f.dpnt_cvg_strt_dt_cd%type
290 ,dpnt_cvg_strt_dt_rl ben_pl_f.dpnt_cvg_strt_dt_rl%type
291 ,dpnt_cvg_end_dt_cd ben_pl_f.dpnt_cvg_end_dt_cd%type
292 ,dpnt_cvg_end_dt_rl ben_pl_f.dpnt_cvg_end_dt_rl%type
293 ,alws_qmcso_flag ben_pl_f.alws_qmcso_flag%type
294 ,alws_qdro_flag ben_pl_f.alws_qdro_flag%type
295 ,dpnt_dsgn_cd ben_pl_f.dpnt_dsgn_cd%type
296 ,postelcn_edit_rl ben_pl_f.postelcn_edit_rl%type
297 ,dpnt_cvd_by_othr_apls_flag ben_pl_f.dpnt_cvd_by_othr_apls_flag%type
298 ,nip_dflt_flag ben_pl_f.nip_dflt_flag%type
299 ,svgs_pl_flag ben_pl_f.svgs_pl_flag%type
300 );
301 --
302 type g_pl_inst_tbl is table of g_pl_inst_row
303 index by binary_integer;
304 --
305 g_pl_lookup ben_cache.g_cache_lookup_table;
306 g_pl_instance g_pl_inst_tbl;
307 g_pl_currow g_pl_inst_row;
308 g_pl_cached pls_integer := 0;
309 --
310 g_pl_default_row g_pl_inst_row;
311 --
312 procedure get_pl_dets
313 (p_business_group_id in number
314 ,p_effective_date in date
315 ,p_pl_id in number default null
316 ,p_inst_row in out NOCOPY g_pl_inst_row
317 );
318 --
319 type g_etpr_inst_row is record
320 (elig_to_prte_rsn_id ben_elig_to_prte_rsn_f.elig_to_prte_rsn_id%type
321 ,effective_start_date ben_elig_to_prte_rsn_f.effective_start_date%type
322 ,effective_end_date ben_elig_to_prte_rsn_f.effective_end_date%type
323 ,ler_id ben_elig_to_prte_rsn_f.ler_id%type
324 ,pgm_id ben_elig_to_prte_rsn_f.pgm_id%type
325 ,ptip_id ben_elig_to_prte_rsn_f.ptip_id%type
326 ,plip_id ben_elig_to_prte_rsn_f.plip_id%type
327 ,pl_id ben_elig_to_prte_rsn_f.pl_id%type
328 ,oipl_id ben_elig_to_prte_rsn_f.oipl_id%type
329 ,wait_perd_dt_to_use_cd ben_elig_to_prte_rsn_f.wait_perd_dt_to_use_cd%type
330 ,wait_perd_dt_to_use_rl ben_elig_to_prte_rsn_f.wait_perd_dt_to_use_rl%type
331 ,wait_perd_rl ben_elig_to_prte_rsn_f.wait_perd_rl%type
332 ,wait_perd_uom ben_elig_to_prte_rsn_f.wait_perd_uom%type
333 ,wait_perd_val ben_elig_to_prte_rsn_f.wait_perd_val%type
334 ,prtn_eff_strt_dt_rl ben_elig_to_prte_rsn_f.prtn_eff_strt_dt_rl%type
335 ,prtn_eff_end_dt_rl ben_elig_to_prte_rsn_f.prtn_eff_end_dt_rl%type
336 ,prtn_eff_strt_dt_cd ben_elig_to_prte_rsn_f.prtn_eff_strt_dt_cd%type
337 ,prtn_eff_end_dt_cd ben_elig_to_prte_rsn_f.prtn_eff_end_dt_cd%type
338 ,elig_inelig_cd ben_elig_to_prte_rsn_f.elig_inelig_cd%type
339 ,ignr_prtn_ovrid_flag ben_elig_to_prte_rsn_f.ignr_prtn_ovrid_flag%type
340 ,vrfy_fmly_mmbr_cd ben_elig_to_prte_rsn_f.vrfy_fmly_mmbr_cd%type
341 ,vrfy_fmly_mmbr_rl ben_elig_to_prte_rsn_f.vrfy_fmly_mmbr_rl%type
342 );
343 --
344 type g_etpr_inst_tbl is table of g_etpr_inst_row
345 index by binary_integer;
346 --
347 g_etpr_lookup ben_cache.g_cache_lookup_table;
348 g_etpr_instance g_etpr_inst_tbl;
349 g_pgmetpr_currow g_etpr_inst_row;
350 g_ptipetpr_currow g_etpr_inst_row;
351 g_plipetpr_currow g_etpr_inst_row;
352 g_pletpr_currow g_etpr_inst_row;
353 g_oipletpr_currow g_etpr_inst_row;
354 g_etpr_cached boolean := FALSE;
355 --
356 procedure get_etpr_dets
357 (p_business_group_id in number
358 ,p_effective_date in date
359 ,p_ler_id in number default null
360 ,p_pgm_id in number default null
361 ,p_ptip_id in number default null
362 ,p_plip_id in number default null
363 ,p_pl_id in number default null
364 ,p_oipl_id in number default null
365 ,p_inst_row in out NOCOPY g_etpr_inst_row
366 );
367 --
368 type g_prel_inst_row is record
369 (prtn_elig_id ben_prtn_elig_f.prtn_elig_id%type
370 ,effective_start_date ben_prtn_elig_f.effective_start_date%type
371 ,effective_end_date ben_prtn_elig_f.effective_end_date%type
372 ,pgm_id ben_prtn_elig_f.pgm_id%type
373 ,ptip_id ben_prtn_elig_f.ptip_id%type
374 ,plip_id ben_prtn_elig_f.plip_id%type
375 ,pl_id ben_prtn_elig_f.pl_id%type
376 ,oipl_id ben_prtn_elig_f.oipl_id%type
377 ,wait_perd_dt_to_use_cd ben_prtn_elig_f.wait_perd_dt_to_use_cd%type
378 ,wait_perd_dt_to_use_rl ben_prtn_elig_f.wait_perd_dt_to_use_rl%type
379 ,wait_perd_rl ben_prtn_elig_f.wait_perd_rl%type
380 ,wait_perd_uom ben_prtn_elig_f.wait_perd_uom%type
381 ,wait_perd_val ben_prtn_elig_f.wait_perd_val%type
382 ,prtn_eff_strt_dt_rl ben_prtn_elig_f.prtn_eff_strt_dt_rl%type
383 ,prtn_eff_end_dt_rl ben_prtn_elig_f.prtn_eff_end_dt_rl%type
384 ,prtn_eff_strt_dt_cd ben_prtn_elig_f.prtn_eff_strt_dt_cd%type
385 ,prtn_eff_end_dt_cd ben_prtn_elig_f.prtn_eff_end_dt_cd%type
386 );
387 --
388 type g_prel_inst_tbl is table of g_prel_inst_row
389 index by binary_integer;
390 --
391 g_prel_lookup ben_cache.g_cache_lookup_table;
392 g_prel_instance g_prel_inst_tbl;
393 g_pgmprel_currow g_prel_inst_row;
394 g_ptipprel_currow g_prel_inst_row;
395 g_plipprel_currow g_prel_inst_row;
396 g_plprel_currow g_prel_inst_row;
397 g_oiplprel_currow g_prel_inst_row;
398 g_prel_cached boolean := FALSE;
399 --
400 procedure get_prel_dets
401 (p_business_group_id in number
402 ,p_effective_date in date
403 ,p_pgm_id in number default null
404 ,p_ptip_id in number default null
405 ,p_plip_id in number default null
406 ,p_pl_id in number default null
407 ,p_oipl_id in number default null
408 ,p_inst_row in out NOCOPY g_prel_inst_row
409 );
410 --
411 ------------------------------------------------------------------------
412 -- DELETE CACHED DATA
413 ------------------------------------------------------------------------
414 procedure clear_down_cache;
415 --
416 procedure set_no_cache_context;
417 --
418 END ben_cobj_cache;