[Home] [Help]
1: PACKAGE BODY ben_elp_cache as
2: /* $Header: benelpch.pkb 120.4 2011/12/09 08:50:06 usaraswa ship $ */
3: --
4: -- Declare globals
5: --
2: /* $Header: benelpch.pkb 120.4 2011/12/09 08:50:06 usaraswa ship $ */
3: --
4: -- Declare globals
5: --
6: g_package varchar2(50) := 'ben_elp_cache.';
7: g_hash_key number := ben_hash_utility.get_hash_key;
8: g_hash_jump number := ben_hash_utility.get_hash_jump;
9: --
10: -- cobcep
9: --
10: -- cobcep
11: --
12: g_cobcep_lookup ben_cache.g_cache_lookup_table;
13: g_cobcep_inst ben_elp_cache.g_cobcep_cache;
14: g_cobcep_cached boolean := FALSE;
15: --
16: -- eligibility profile person type by eligibility profile
17: --
15: --
16: -- eligibility profile person type by eligibility profile
17: --
18: g_cache_elpept_lookup ben_cache.g_cache_lookup_table;
19: g_cache_elpept_inst ben_elp_cache.g_cache_elpept_instor;
20: --
21: -- eligibility profile people group by eligibility profile
22: --
23: g_cache_elpepg_lookup ben_cache.g_cache_lookup_table;
20: --
21: -- eligibility profile people group by eligibility profile
22: --
23: g_cache_elpepg_lookup ben_cache.g_cache_lookup_table;
24: g_cache_elpepg_inst ben_elp_cache.g_cache_elpepg_instor;
25: --
26: -- eligibility profile rule by eligibility profile
27: --
28: g_cache_elperl_lookup ben_cache.g_cache_lookup_table;
25: --
26: -- eligibility profile rule by eligibility profile
27: --
28: g_cache_elperl_lookup ben_cache.g_cache_lookup_table;
29: g_cache_elperl_inst ben_elp_cache.g_cache_elperl_instor;
30: --
31: -- eligibility profile assignment status type by eligibility profile
32: --
33: g_cache_elpees_lookup ben_cache.g_cache_lookup_table;
30: --
31: -- eligibility profile assignment status type by eligibility profile
32: --
33: g_cache_elpees_lookup ben_cache.g_cache_lookup_table;
34: g_cache_elpees_inst ben_elp_cache.g_cache_elpees_instor;
35: --
36: -- eligibility profile length of service by eligibility profile
37: --
38: g_cache_elpels_lookup ben_cache.g_cache_lookup_table;
35: --
36: -- eligibility profile length of service by eligibility profile
37: --
38: g_cache_elpels_lookup ben_cache.g_cache_lookup_table;
39: g_cache_elpels_inst ben_elp_cache.g_cache_elpels_instor;
40: --
41: -- eligibility profile age/los combination by eligibility profile
42: --
43: g_cache_elpecp_lookup ben_cache.g_cache_lookup_table;
40: --
41: -- eligibility profile age/los combination by eligibility profile
42: --
43: g_cache_elpecp_lookup ben_cache.g_cache_lookup_table;
44: g_cache_elpecp_inst ben_elp_cache.g_cache_elpecp_instor;
45: --
46: -- eligibility profile location by eligibility profile
47: --
48: g_cache_elpewl_lookup ben_cache.g_cache_lookup_table;
45: --
46: -- eligibility profile location by eligibility profile
47: --
48: g_cache_elpewl_lookup ben_cache.g_cache_lookup_table;
49: g_cache_elpewl_inst ben_elp_cache.g_cache_elpewl_instor;
50: --
51: -- eligibility profile assignment set by eligibility profile
52: --
53: g_cache_elpean_lookup ben_cache.g_cache_lookup_table;
50: --
51: -- eligibility profile assignment set by eligibility profile
52: --
53: g_cache_elpean_lookup ben_cache.g_cache_lookup_table;
54: g_cache_elpean_inst ben_elp_cache.g_cache_elpean_instor;
55: --
56: -- eligibility profile organization by eligibility profile
57: --
58: g_cache_elpeou_lookup ben_cache.g_cache_lookup_table;
55: --
56: -- eligibility profile organization by eligibility profile
57: --
58: g_cache_elpeou_lookup ben_cache.g_cache_lookup_table;
59: g_cache_elpeou_inst ben_elp_cache.g_cache_elpeou_instor;
60: --
61: -- eligibility profile pay frequency by eligibility profile
62: --
63: g_cache_elpehs_lookup ben_cache.g_cache_lookup_table;
60: --
61: -- eligibility profile pay frequency by eligibility profile
62: --
63: g_cache_elpehs_lookup ben_cache.g_cache_lookup_table;
64: g_cache_elpehs_inst ben_elp_cache.g_cache_elpehs_instor;
65: --
66: -- eligibility profile full/part time by eligibility profile
67: --
68: g_cache_elpefp_lookup ben_cache.g_cache_lookup_table;
65: --
66: -- eligibility profile full/part time by eligibility profile
67: --
68: g_cache_elpefp_lookup ben_cache.g_cache_lookup_table;
69: g_cache_elpefp_inst ben_elp_cache.g_cache_elpefp_instor;
70: --
71: -- eligibility profile scheduled hours by eligibility profile
72: --
73: g_cache_elpesh_lookup ben_cache.g_cache_lookup_table;
70: --
71: -- eligibility profile scheduled hours by eligibility profile
72: --
73: g_cache_elpesh_lookup ben_cache.g_cache_lookup_table;
74: g_cache_elpesh_inst ben_elp_cache.g_cache_elpesh_instor;
75: --
76: -- eligibility profile compensation level by eligibility profile
77: --
78: g_cache_elpecl_lookup ben_cache.g_cache_lookup_table;
75: --
76: -- eligibility profile compensation level by eligibility profile
77: --
78: g_cache_elpecl_lookup ben_cache.g_cache_lookup_table;
79: g_cache_elpecl_inst ben_elp_cache.g_cache_elpecl_instor;
80: --
81: -- eligibility profile hours worked by eligibility profile
82: --
83: g_cache_elpehw_lookup ben_cache.g_cache_lookup_table;
80: --
81: -- eligibility profile hours worked by eligibility profile
82: --
83: g_cache_elpehw_lookup ben_cache.g_cache_lookup_table;
84: g_cache_elpehw_inst ben_elp_cache.g_cache_elpehw_instor;
85: --
86: -- eligibility profile full time by eligibility profile
87: --
88: g_cache_elpepf_lookup ben_cache.g_cache_lookup_table;
85: --
86: -- eligibility profile full time by eligibility profile
87: --
88: g_cache_elpepf_lookup ben_cache.g_cache_lookup_table;
89: g_cache_elpepf_inst ben_elp_cache.g_cache_elpepf_instor;
90: --
91: -- eligibility profile grade by eligibility profile
92: --
93: g_cache_elpegr_lookup ben_cache.g_cache_lookup_table;
90: --
91: -- eligibility profile grade by eligibility profile
92: --
93: g_cache_elpegr_lookup ben_cache.g_cache_lookup_table;
94: g_cache_elpegr_inst ben_elp_cache.g_cache_elpegr_instor;
95: --
96: -- eligibility profile sex by eligibility profile
97: --
98: g_cache_elpegn_lookup ben_cache.g_cache_lookup_table;
95: --
96: -- eligibility profile sex by eligibility profile
97: --
98: g_cache_elpegn_lookup ben_cache.g_cache_lookup_table;
99: g_cache_elpegn_inst ben_elp_cache.g_cache_elpegn_instor;
100: --
101: -- eligibility profile job by eligibility profile
102: --
103: g_cache_elpejp_lookup ben_cache.g_cache_lookup_table;
100: --
101: -- eligibility profile job by eligibility profile
102: --
103: g_cache_elpejp_lookup ben_cache.g_cache_lookup_table;
104: g_cache_elpejp_inst ben_elp_cache.g_cache_elpejp_instor;
105: --
106: -- eligibility profile pay basis by eligibility profile
107: --
108: g_cache_elpepb_lookup ben_cache.g_cache_lookup_table;
105: --
106: -- eligibility profile pay basis by eligibility profile
107: --
108: g_cache_elpepb_lookup ben_cache.g_cache_lookup_table;
109: g_cache_elpepb_inst ben_elp_cache.g_cache_elpepb_instor;
110: --
111: -- eligibility profile service area by eligibility profile
112: --
113: g_cache_elpesa_lookup ben_cache.g_cache_lookup_table;
110: --
111: -- eligibility profile service area by eligibility profile
112: --
113: g_cache_elpesa_lookup ben_cache.g_cache_lookup_table;
114: g_cache_elpesa_inst ben_elp_cache.g_cache_elpesa_instor;
115: --
116: -- eligibility profile payroll by eligibility profile
117: --
118: g_cache_elpepy_lookup ben_cache.g_cache_lookup_table;
115: --
116: -- eligibility profile payroll by eligibility profile
117: --
118: g_cache_elpepy_lookup ben_cache.g_cache_lookup_table;
119: g_cache_elpepy_inst ben_elp_cache.g_cache_elpepy_instor;
120: --
121: -- eligibility profile bargaining unit by eligibility profile
122: --
123: g_cache_elpebu_lookup ben_cache.g_cache_lookup_table;
120: --
121: -- eligibility profile bargaining unit by eligibility profile
122: --
123: g_cache_elpebu_lookup ben_cache.g_cache_lookup_table;
124: g_cache_elpebu_inst ben_elp_cache.g_cache_elpebu_instor;
125: --
126: -- eligibility profile labour union membership by eligibility profile
127: --
128: g_cache_elpelu_lookup ben_cache.g_cache_lookup_table;
125: --
126: -- eligibility profile labour union membership by eligibility profile
127: --
128: g_cache_elpelu_lookup ben_cache.g_cache_lookup_table;
129: g_cache_elpelu_inst ben_elp_cache.g_cache_elpelu_instor;
130: --
131: -- eligibility profile leave of absence reason by eligibility profile
132: --
133: g_cache_elpelr_lookup ben_cache.g_cache_lookup_table;
130: --
131: -- eligibility profile leave of absence reason by eligibility profile
132: --
133: g_cache_elpelr_lookup ben_cache.g_cache_lookup_table;
134: g_cache_elpelr_inst ben_elp_cache.g_cache_elpelr_instor;
135: --
136: -- eligibility profile age details by eligibility profile
137: --
138: g_cache_elpeap_lookup ben_cache.g_cache_lookup_table;
135: --
136: -- eligibility profile age details by eligibility profile
137: --
138: g_cache_elpeap_lookup ben_cache.g_cache_lookup_table;
139: g_cache_elpeap_inst ben_elp_cache.g_cache_elpeap_instor;
140: --
141: -- eligibility profile zip code range by eligibility profile
142: --
143: g_cache_elpepz_lookup ben_cache.g_cache_lookup_table;
140: --
141: -- eligibility profile zip code range by eligibility profile
142: --
143: g_cache_elpepz_lookup ben_cache.g_cache_lookup_table;
144: g_cache_elpepz_inst ben_elp_cache.g_cache_elpepz_instor;
145: --
146: -- eligibility profile benefits group by eligibility profile
147: --
148: g_cache_elpebn_lookup ben_cache.g_cache_lookup_table;
145: --
146: -- eligibility profile benefits group by eligibility profile
147: --
148: g_cache_elpebn_lookup ben_cache.g_cache_lookup_table;
149: g_cache_elpebn_inst ben_elp_cache.g_cache_elpebn_instor;
150: --
151: -- eligibility profile legal entity by eligibility profile
152: --
153: g_cache_elpeln_lookup ben_cache.g_cache_lookup_table;
150: --
151: -- eligibility profile legal entity by eligibility profile
152: --
153: g_cache_elpeln_lookup ben_cache.g_cache_lookup_table;
154: g_cache_elpeln_inst ben_elp_cache.g_cache_elpeln_instor;
155: --
156: -- eligibility profile other plan by eligibility profile
157: --
158: g_cache_elpepp_lookup ben_cache.g_cache_lookup_table;
155: --
156: -- eligibility profile other plan by eligibility profile
157: --
158: g_cache_elpepp_lookup ben_cache.g_cache_lookup_table;
159: g_cache_elpepp_inst ben_elp_cache.g_cache_elpepp_instor;
160: --
161: -- eligibility profile elig other ptip by eligibility profile
162: --
163: g_cache_elpeoy_lookup ben_cache.g_cache_lookup_table;
160: --
161: -- eligibility profile elig other ptip by eligibility profile
162: --
163: g_cache_elpeoy_lookup ben_cache.g_cache_lookup_table;
164: g_cache_elpeoy_inst ben_elp_cache.g_cache_elpeoy_instor;
165: --
166: -- eligibility profile no other coverage participate by eligibility profile
167: --
168: g_cache_elpetd_lookup ben_cache.g_cache_lookup_table;
165: --
166: -- eligibility profile no other coverage participate by eligibility profile
167: --
168: g_cache_elpetd_lookup ben_cache.g_cache_lookup_table;
169: g_cache_elpetd_inst ben_elp_cache.g_cache_elpetd_instor;
170: --
171: -- eligibility profile no other dpnt coverage participate by elig profile
172: --
173: g_cache_elpeno_lookup ben_cache.g_cache_lookup_table;
170: --
171: -- eligibility profile no other dpnt coverage participate by elig profile
172: --
173: g_cache_elpeno_lookup ben_cache.g_cache_lookup_table;
174: g_cache_elpeno_inst ben_elp_cache.g_cache_elpeno_instor;
175: --
176: -- eligibility profile enrolled another plan by eligibility profile
177: --
178: g_cache_elpeep_lookup ben_cache.g_cache_lookup_table;
175: --
176: -- eligibility profile enrolled another plan by eligibility profile
177: --
178: g_cache_elpeep_lookup ben_cache.g_cache_lookup_table;
179: g_cache_elpeep_inst ben_elp_cache.g_cache_elpeep_instor;
180: --
181: -- eligibility profile enrolled in another oipl by eligibility profile
182: --
183: g_cache_elpeei_lookup ben_cache.g_cache_lookup_table;
180: --
181: -- eligibility profile enrolled in another oipl by eligibility profile
182: --
183: g_cache_elpeei_lookup ben_cache.g_cache_lookup_table;
184: g_cache_elpeei_inst ben_elp_cache.g_cache_elpeei_instor;
185: --
186: -- eligibility profile enrolled in another pgm by eligibility profile
187: --
188: g_cache_elpeeg_lookup ben_cache.g_cache_lookup_table;
185: --
186: -- eligibility profile enrolled in another pgm by eligibility profile
187: --
188: g_cache_elpeeg_lookup ben_cache.g_cache_lookup_table;
189: g_cache_elpeeg_inst ben_elp_cache.g_cache_elpeeg_instor;
190: --
191: -- eligibility profile dependent covered other plan by eligibility profile
192: --
193: g_cache_elpedp_lookup ben_cache.g_cache_lookup_table;
190: --
191: -- eligibility profile dependent covered other plan by eligibility profile
192: --
193: g_cache_elpedp_lookup ben_cache.g_cache_lookup_table;
194: g_cache_elpedp_inst ben_elp_cache.g_cache_elpedp_instor;
195: --
196: -- eligibility profile leaving reason participate by eligibility profile
197: --
198: g_cache_elpelv_lookup ben_cache.g_cache_lookup_table;
195: --
196: -- eligibility profile leaving reason participate by eligibility profile
197: --
198: g_cache_elpelv_lookup ben_cache.g_cache_lookup_table;
199: g_cache_elpelv_inst ben_elp_cache.g_cache_elpelv_instor;
200: --
201: -- eligibility profile opted for medicare participate by eligibility profile
202: --
203: g_cache_elpeom_lookup ben_cache.g_cache_lookup_table;
200: --
201: -- eligibility profile opted for medicare participate by eligibility profile
202: --
203: g_cache_elpeom_lookup ben_cache.g_cache_lookup_table;
204: g_cache_elpeom_inst ben_elp_cache.g_cache_elpeom_instor;
205: --
206: -- eligibility profile enrolled in another plip by eligibility profile
207: --
208: g_cache_elpeai_lookup ben_cache.g_cache_lookup_table;
205: --
206: -- eligibility profile enrolled in another plip by eligibility profile
207: --
208: g_cache_elpeai_lookup ben_cache.g_cache_lookup_table;
209: g_cache_elpeai_inst ben_elp_cache.g_cache_elpeai_instor;
210: --
211: -- eligibility profile dependent covered othr plip by eligibility profile
212: --
213: g_cache_elpedi_lookup ben_cache.g_cache_lookup_table;
210: --
211: -- eligibility profile dependent covered othr plip by eligibility profile
212: --
213: g_cache_elpedi_lookup ben_cache.g_cache_lookup_table;
214: g_cache_elpedi_inst ben_elp_cache.g_cache_elpedi_instor;
215: --
216: -- eligibility profile enrolled another ptip by eligibility profile
217: --
218: g_cache_elpeet_lookup ben_cache.g_cache_lookup_table;
215: --
216: -- eligibility profile enrolled another ptip by eligibility profile
217: --
218: g_cache_elpeet_lookup ben_cache.g_cache_lookup_table;
219: g_cache_elpeet_inst ben_elp_cache.g_cache_elpeet_instor;
220: --
221: -- eligibility profile dependent covered in other ptip by eligibility profile
222: --
223: g_cache_elpedt_lookup ben_cache.g_cache_lookup_table;
220: --
221: -- eligibility profile dependent covered in other ptip by eligibility profile
222: --
223: g_cache_elpedt_lookup ben_cache.g_cache_lookup_table;
224: g_cache_elpedt_inst ben_elp_cache.g_cache_elpedt_instor;
225: --
226: -- eligibility profile dependent covered in other program by eligibility profile
227: --
228: g_cache_elpedg_lookup ben_cache.g_cache_lookup_table;
225: --
226: -- eligibility profile dependent covered in other program by eligibility profile
227: --
228: g_cache_elpedg_lookup ben_cache.g_cache_lookup_table;
229: g_cache_elpedg_inst ben_elp_cache.g_cache_elpedg_instor;
230: --
231: -- eligibility profile cobra qualified beneficiary by eligibility profile
232: --
233: g_cache_elpecq_lookup ben_cache.g_cache_lookup_table;
230: --
231: -- eligibility profile cobra qualified beneficiary by eligibility profile
232: --
233: g_cache_elpecq_lookup ben_cache.g_cache_lookup_table;
234: g_cache_elpecq_inst ben_elp_cache.g_cache_elpecq_instor;
235: --
236: g_copcep_odlookup ben_cache.g_cache_lookup_table;
237: g_copcep_nxelenum number;
238: g_copcep_odinst ben_elp_cache.g_cobcep_odcache := ben_elp_cache.g_cobcep_odcache();
234: g_cache_elpecq_inst ben_elp_cache.g_cache_elpecq_instor;
235: --
236: g_copcep_odlookup ben_cache.g_cache_lookup_table;
237: g_copcep_nxelenum number;
238: g_copcep_odinst ben_elp_cache.g_cobcep_odcache := ben_elp_cache.g_cobcep_odcache();
239: g_copcep_odcached pls_integer := 0;
240: --
241: procedure write_cobcep_cache
242: (p_business_group_id in number
387: --
388: l_hv := mod(nvl(row.pgm_id,1)+nvl(row.ptip_id,2)+nvl(row.plip_id,3)
389: +nvl(row.pl_id,4)+nvl(row.oipl_id,5),ben_hash_utility.get_hash_key);
390: --
391: while ben_elp_cache.g_cobcep_lookup.exists(l_hv)
392: loop
393: --
394: l_hv := l_hv+g_hash_jump;
395: --
394: l_hv := l_hv+g_hash_jump;
395: --
396: end loop;
397: --
398: ben_elp_cache.g_cobcep_lookup(l_hv).id := row.pgm_id;
399: ben_elp_cache.g_cobcep_lookup(l_hv).fk_id := row.ptip_id;
400: ben_elp_cache.g_cobcep_lookup(l_hv).fk1_id := row.plip_id;
401: ben_elp_cache.g_cobcep_lookup(l_hv).fk2_id := row.pl_id;
402: ben_elp_cache.g_cobcep_lookup(l_hv).fk3_id := row.oipl_id;
395: --
396: end loop;
397: --
398: ben_elp_cache.g_cobcep_lookup(l_hv).id := row.pgm_id;
399: ben_elp_cache.g_cobcep_lookup(l_hv).fk_id := row.ptip_id;
400: ben_elp_cache.g_cobcep_lookup(l_hv).fk1_id := row.plip_id;
401: ben_elp_cache.g_cobcep_lookup(l_hv).fk2_id := row.pl_id;
402: ben_elp_cache.g_cobcep_lookup(l_hv).fk3_id := row.oipl_id;
403: --
396: end loop;
397: --
398: ben_elp_cache.g_cobcep_lookup(l_hv).id := row.pgm_id;
399: ben_elp_cache.g_cobcep_lookup(l_hv).fk_id := row.ptip_id;
400: ben_elp_cache.g_cobcep_lookup(l_hv).fk1_id := row.plip_id;
401: ben_elp_cache.g_cobcep_lookup(l_hv).fk2_id := row.pl_id;
402: ben_elp_cache.g_cobcep_lookup(l_hv).fk3_id := row.oipl_id;
403: --
404: end loop;
397: --
398: ben_elp_cache.g_cobcep_lookup(l_hv).id := row.pgm_id;
399: ben_elp_cache.g_cobcep_lookup(l_hv).fk_id := row.ptip_id;
400: ben_elp_cache.g_cobcep_lookup(l_hv).fk1_id := row.plip_id;
401: ben_elp_cache.g_cobcep_lookup(l_hv).fk2_id := row.pl_id;
402: ben_elp_cache.g_cobcep_lookup(l_hv).fk3_id := row.oipl_id;
403: --
404: end loop;
405: --
398: ben_elp_cache.g_cobcep_lookup(l_hv).id := row.pgm_id;
399: ben_elp_cache.g_cobcep_lookup(l_hv).fk_id := row.ptip_id;
400: ben_elp_cache.g_cobcep_lookup(l_hv).fk1_id := row.plip_id;
401: ben_elp_cache.g_cobcep_lookup(l_hv).fk2_id := row.pl_id;
402: ben_elp_cache.g_cobcep_lookup(l_hv).fk3_id := row.oipl_id;
403: --
404: end loop;
405: --
406: -- hr_utility.set_location(' Dn Look '||l_proc,10);
407: --
408: l_torrwnum := 0;
409: l_prev_hv := -1;
410: --
411: if ben_elp_cache.g_cobcep_lookup.count > 0 then
412: --
413: for objinst in c_instance
414: (c_business_group_id => p_business_group_id
415: ,c_effective_date => p_effective_date
420: --
421: l_hv := mod(nvl(objinst.pgm_id,1)+nvl(objinst.ptip_id,2)+nvl(objinst.plip_id,3)
422: +nvl(objinst.pl_id,4)+nvl(objinst.oipl_id,5),ben_hash_utility.get_hash_key);
423: --
424: if nvl(ben_elp_cache.g_cobcep_lookup(l_hv).id,-1) = nvl(objinst.pgm_id,-1)
425: and nvl(ben_elp_cache.g_cobcep_lookup(l_hv).fk_id,-1) = nvl(objinst.ptip_id,-1)
426: and nvl(ben_elp_cache.g_cobcep_lookup(l_hv).fk1_id,-1) = nvl(objinst.plip_id,-1)
427: and nvl(ben_elp_cache.g_cobcep_lookup(l_hv).fk2_id,-1) = nvl(objinst.pl_id,-1)
428: and nvl(ben_elp_cache.g_cobcep_lookup(l_hv).fk3_id,-1) = nvl(objinst.oipl_id,-1)
421: l_hv := mod(nvl(objinst.pgm_id,1)+nvl(objinst.ptip_id,2)+nvl(objinst.plip_id,3)
422: +nvl(objinst.pl_id,4)+nvl(objinst.oipl_id,5),ben_hash_utility.get_hash_key);
423: --
424: if nvl(ben_elp_cache.g_cobcep_lookup(l_hv).id,-1) = nvl(objinst.pgm_id,-1)
425: and nvl(ben_elp_cache.g_cobcep_lookup(l_hv).fk_id,-1) = nvl(objinst.ptip_id,-1)
426: and nvl(ben_elp_cache.g_cobcep_lookup(l_hv).fk1_id,-1) = nvl(objinst.plip_id,-1)
427: and nvl(ben_elp_cache.g_cobcep_lookup(l_hv).fk2_id,-1) = nvl(objinst.pl_id,-1)
428: and nvl(ben_elp_cache.g_cobcep_lookup(l_hv).fk3_id,-1) = nvl(objinst.oipl_id,-1)
429: then
422: +nvl(objinst.pl_id,4)+nvl(objinst.oipl_id,5),ben_hash_utility.get_hash_key);
423: --
424: if nvl(ben_elp_cache.g_cobcep_lookup(l_hv).id,-1) = nvl(objinst.pgm_id,-1)
425: and nvl(ben_elp_cache.g_cobcep_lookup(l_hv).fk_id,-1) = nvl(objinst.ptip_id,-1)
426: and nvl(ben_elp_cache.g_cobcep_lookup(l_hv).fk1_id,-1) = nvl(objinst.plip_id,-1)
427: and nvl(ben_elp_cache.g_cobcep_lookup(l_hv).fk2_id,-1) = nvl(objinst.pl_id,-1)
428: and nvl(ben_elp_cache.g_cobcep_lookup(l_hv).fk3_id,-1) = nvl(objinst.oipl_id,-1)
429: then
430: --
423: --
424: if nvl(ben_elp_cache.g_cobcep_lookup(l_hv).id,-1) = nvl(objinst.pgm_id,-1)
425: and nvl(ben_elp_cache.g_cobcep_lookup(l_hv).fk_id,-1) = nvl(objinst.ptip_id,-1)
426: and nvl(ben_elp_cache.g_cobcep_lookup(l_hv).fk1_id,-1) = nvl(objinst.plip_id,-1)
427: and nvl(ben_elp_cache.g_cobcep_lookup(l_hv).fk2_id,-1) = nvl(objinst.pl_id,-1)
428: and nvl(ben_elp_cache.g_cobcep_lookup(l_hv).fk3_id,-1) = nvl(objinst.oipl_id,-1)
429: then
430: --
431: null;
424: if nvl(ben_elp_cache.g_cobcep_lookup(l_hv).id,-1) = nvl(objinst.pgm_id,-1)
425: and nvl(ben_elp_cache.g_cobcep_lookup(l_hv).fk_id,-1) = nvl(objinst.ptip_id,-1)
426: and nvl(ben_elp_cache.g_cobcep_lookup(l_hv).fk1_id,-1) = nvl(objinst.plip_id,-1)
427: and nvl(ben_elp_cache.g_cobcep_lookup(l_hv).fk2_id,-1) = nvl(objinst.pl_id,-1)
428: and nvl(ben_elp_cache.g_cobcep_lookup(l_hv).fk3_id,-1) = nvl(objinst.oipl_id,-1)
429: then
430: --
431: null;
432: --
435: l_hv := l_hv+g_hash_jump;
436: --
437: loop
438: --
439: if nvl(ben_elp_cache.g_cobcep_lookup(l_hv).id,-1) = nvl(objinst.pgm_id,-1)
440: and nvl(ben_elp_cache.g_cobcep_lookup(l_hv).fk_id,-1) = nvl(objinst.ptip_id,-1)
441: and nvl(ben_elp_cache.g_cobcep_lookup(l_hv).fk1_id,-1) = nvl(objinst.plip_id,-1)
442: and nvl(ben_elp_cache.g_cobcep_lookup(l_hv).fk2_id,-1) = nvl(objinst.pl_id,-1)
443: and nvl(ben_elp_cache.g_cobcep_lookup(l_hv).fk3_id,-1) = nvl(objinst.oipl_id,-1)
436: --
437: loop
438: --
439: if nvl(ben_elp_cache.g_cobcep_lookup(l_hv).id,-1) = nvl(objinst.pgm_id,-1)
440: and nvl(ben_elp_cache.g_cobcep_lookup(l_hv).fk_id,-1) = nvl(objinst.ptip_id,-1)
441: and nvl(ben_elp_cache.g_cobcep_lookup(l_hv).fk1_id,-1) = nvl(objinst.plip_id,-1)
442: and nvl(ben_elp_cache.g_cobcep_lookup(l_hv).fk2_id,-1) = nvl(objinst.pl_id,-1)
443: and nvl(ben_elp_cache.g_cobcep_lookup(l_hv).fk3_id,-1) = nvl(objinst.oipl_id,-1)
444: then
437: loop
438: --
439: if nvl(ben_elp_cache.g_cobcep_lookup(l_hv).id,-1) = nvl(objinst.pgm_id,-1)
440: and nvl(ben_elp_cache.g_cobcep_lookup(l_hv).fk_id,-1) = nvl(objinst.ptip_id,-1)
441: and nvl(ben_elp_cache.g_cobcep_lookup(l_hv).fk1_id,-1) = nvl(objinst.plip_id,-1)
442: and nvl(ben_elp_cache.g_cobcep_lookup(l_hv).fk2_id,-1) = nvl(objinst.pl_id,-1)
443: and nvl(ben_elp_cache.g_cobcep_lookup(l_hv).fk3_id,-1) = nvl(objinst.oipl_id,-1)
444: then
445: --
438: --
439: if nvl(ben_elp_cache.g_cobcep_lookup(l_hv).id,-1) = nvl(objinst.pgm_id,-1)
440: and nvl(ben_elp_cache.g_cobcep_lookup(l_hv).fk_id,-1) = nvl(objinst.ptip_id,-1)
441: and nvl(ben_elp_cache.g_cobcep_lookup(l_hv).fk1_id,-1) = nvl(objinst.plip_id,-1)
442: and nvl(ben_elp_cache.g_cobcep_lookup(l_hv).fk2_id,-1) = nvl(objinst.pl_id,-1)
443: and nvl(ben_elp_cache.g_cobcep_lookup(l_hv).fk3_id,-1) = nvl(objinst.oipl_id,-1)
444: then
445: --
446: exit;
439: if nvl(ben_elp_cache.g_cobcep_lookup(l_hv).id,-1) = nvl(objinst.pgm_id,-1)
440: and nvl(ben_elp_cache.g_cobcep_lookup(l_hv).fk_id,-1) = nvl(objinst.ptip_id,-1)
441: and nvl(ben_elp_cache.g_cobcep_lookup(l_hv).fk1_id,-1) = nvl(objinst.plip_id,-1)
442: and nvl(ben_elp_cache.g_cobcep_lookup(l_hv).fk2_id,-1) = nvl(objinst.pl_id,-1)
443: and nvl(ben_elp_cache.g_cobcep_lookup(l_hv).fk3_id,-1) = nvl(objinst.oipl_id,-1)
444: then
445: --
446: exit;
447: --
455: --
456: end if;
457: --
458: if l_prev_hv = -1 then
459: ben_elp_cache.g_cobcep_lookup(l_hv).starttorele_num := l_torrwnum;
460: elsif l_hv <> l_prev_hv then
461: ben_elp_cache.g_cobcep_lookup(l_prev_hv).endtorele_num := l_torrwnum-1;
462: ben_elp_cache.g_cobcep_lookup(l_hv).starttorele_num := l_torrwnum;
463: end if;
457: --
458: if l_prev_hv = -1 then
459: ben_elp_cache.g_cobcep_lookup(l_hv).starttorele_num := l_torrwnum;
460: elsif l_hv <> l_prev_hv then
461: ben_elp_cache.g_cobcep_lookup(l_prev_hv).endtorele_num := l_torrwnum-1;
462: ben_elp_cache.g_cobcep_lookup(l_hv).starttorele_num := l_torrwnum;
463: end if;
464: --
465: -- hr_utility.set_location(' Assign inst '||l_proc,10);
458: if l_prev_hv = -1 then
459: ben_elp_cache.g_cobcep_lookup(l_hv).starttorele_num := l_torrwnum;
460: elsif l_hv <> l_prev_hv then
461: ben_elp_cache.g_cobcep_lookup(l_prev_hv).endtorele_num := l_torrwnum-1;
462: ben_elp_cache.g_cobcep_lookup(l_hv).starttorele_num := l_torrwnum;
463: end if;
464: --
465: -- hr_utility.set_location(' Assign inst '||l_proc,10);
466: --
543: l_prev_hv := l_hv;
544: --
545: end loop;
546: --
547: ben_elp_cache.g_cobcep_lookup(l_prev_hv).endtorele_num := l_torrwnum-1;
548: --
549: end if;
550: --
551: -- hr_utility.set_location(' Leaving '||l_proc,10);
559: ,p_oipl_id in number default hr_api.g_number
560: ,p_plip_id in number default hr_api.g_number
561: ,p_ptip_id in number default hr_api.g_number
562: --
563: ,p_inst_set out nocopy ben_elp_cache.g_cobcep_cache
564: ,p_inst_count out nocopy number
565: )
566: is
567: --
592: +nvl(p_pl_id,4)+nvl(p_oipl_id,5),ben_hash_utility.get_hash_key);
593: --
594: -- Check if hashed value is already allocated
595: --
596: if ben_elp_cache.g_cobcep_lookup.exists(l_hv) then
597: --
598: if nvl(g_cobcep_lookup(l_hv).id,-1) = nvl(p_pgm_id,-1)
599: and nvl(g_cobcep_lookup(l_hv).fk_id,-1) = nvl(p_ptip_id,-1)
600: and nvl(g_cobcep_lookup(l_hv).fk1_id,-1) = nvl(p_plip_id,-1)
1356: ,p_oipl_id in number default hr_api.g_number
1357: ,p_plip_id in number default hr_api.g_number
1358: ,p_ptip_id in number default hr_api.g_number
1359: --
1360: ,p_inst_set in out nocopy ben_elp_cache.g_cobcep_odcache
1361: )
1362: is
1363: --
1364: l_proc varchar2(72) := g_package||'cobcep_odgetdets';
1362: is
1363: --
1364: l_proc varchar2(72) := g_package||'cobcep_odgetdets';
1365: --
1366: l_inst_set ben_elp_cache.g_cobcep_odcache := ben_elp_cache.g_cobcep_odcache();
1367: --
1368: l_hv pls_integer;
1369: l_not_hash_found boolean;
1370: l_insttorrw_num pls_integer;
1483: ,p_effective_date in date
1484: ,p_eligy_prfl_id in number default hr_api.g_number
1485: ,p_cache_code in varchar2 default hr_api.g_varchar2
1486: --
1487: ,p_inst_set out nocopy ben_elp_cache.g_elpelc_cache
1488: ,p_inst_count out nocopy number
1489: )
1490: is
1491: --
1512: begin
1513: --
1514: -- Check if the lookup cache is populated
1515: --
1516: if (p_cache_code = 'ELPEPT' and ben_elp_cache.g_elpept_lookup.count = 0)
1517: or (p_cache_code = 'ELPEES' and ben_elp_cache.g_elpees_lookup.count = 0)
1518: or (p_cache_code = 'ELPESA' and ben_elp_cache.g_elpesa_lookup.count = 0)
1519: or (p_cache_code = 'ELPEHS' and ben_elp_cache.g_elpehs_lookup.count = 0)
1520: or (p_cache_code = 'ELPELS' and ben_elp_cache.g_elpels_lookup.count = 0)
1513: --
1514: -- Check if the lookup cache is populated
1515: --
1516: if (p_cache_code = 'ELPEPT' and ben_elp_cache.g_elpept_lookup.count = 0)
1517: or (p_cache_code = 'ELPEES' and ben_elp_cache.g_elpees_lookup.count = 0)
1518: or (p_cache_code = 'ELPESA' and ben_elp_cache.g_elpesa_lookup.count = 0)
1519: or (p_cache_code = 'ELPEHS' and ben_elp_cache.g_elpehs_lookup.count = 0)
1520: or (p_cache_code = 'ELPELS' and ben_elp_cache.g_elpels_lookup.count = 0)
1521: or (p_cache_code = 'ELPECP' and ben_elp_cache.g_elpecp_lookup.count = 0)
1514: -- Check if the lookup cache is populated
1515: --
1516: if (p_cache_code = 'ELPEPT' and ben_elp_cache.g_elpept_lookup.count = 0)
1517: or (p_cache_code = 'ELPEES' and ben_elp_cache.g_elpees_lookup.count = 0)
1518: or (p_cache_code = 'ELPESA' and ben_elp_cache.g_elpesa_lookup.count = 0)
1519: or (p_cache_code = 'ELPEHS' and ben_elp_cache.g_elpehs_lookup.count = 0)
1520: or (p_cache_code = 'ELPELS' and ben_elp_cache.g_elpels_lookup.count = 0)
1521: or (p_cache_code = 'ELPECP' and ben_elp_cache.g_elpecp_lookup.count = 0)
1522: then
1515: --
1516: if (p_cache_code = 'ELPEPT' and ben_elp_cache.g_elpept_lookup.count = 0)
1517: or (p_cache_code = 'ELPEES' and ben_elp_cache.g_elpees_lookup.count = 0)
1518: or (p_cache_code = 'ELPESA' and ben_elp_cache.g_elpesa_lookup.count = 0)
1519: or (p_cache_code = 'ELPEHS' and ben_elp_cache.g_elpehs_lookup.count = 0)
1520: or (p_cache_code = 'ELPELS' and ben_elp_cache.g_elpels_lookup.count = 0)
1521: or (p_cache_code = 'ELPECP' and ben_elp_cache.g_elpecp_lookup.count = 0)
1522: then
1523: --
1516: if (p_cache_code = 'ELPEPT' and ben_elp_cache.g_elpept_lookup.count = 0)
1517: or (p_cache_code = 'ELPEES' and ben_elp_cache.g_elpees_lookup.count = 0)
1518: or (p_cache_code = 'ELPESA' and ben_elp_cache.g_elpesa_lookup.count = 0)
1519: or (p_cache_code = 'ELPEHS' and ben_elp_cache.g_elpehs_lookup.count = 0)
1520: or (p_cache_code = 'ELPELS' and ben_elp_cache.g_elpels_lookup.count = 0)
1521: or (p_cache_code = 'ELPECP' and ben_elp_cache.g_elpecp_lookup.count = 0)
1522: then
1523: --
1524: -- Column and cache details
1517: or (p_cache_code = 'ELPEES' and ben_elp_cache.g_elpees_lookup.count = 0)
1518: or (p_cache_code = 'ELPESA' and ben_elp_cache.g_elpesa_lookup.count = 0)
1519: or (p_cache_code = 'ELPEHS' and ben_elp_cache.g_elpehs_lookup.count = 0)
1520: or (p_cache_code = 'ELPELS' and ben_elp_cache.g_elpels_lookup.count = 0)
1521: or (p_cache_code = 'ELPECP' and ben_elp_cache.g_elpecp_lookup.count = 0)
1522: then
1523: --
1524: -- Column and cache details
1525: --
1526: if p_cache_code = 'ELPEPT' then
1527: --
1528: l_mastertab_name := 'ben_eligy_prfl_f';
1529: l_masterpkcol_name := 'eligy_prfl_id';
1530: l_lkup_name := 'ben_elp_cache.g_elpept_lookup';
1531: l_inst_name := 'ben_elp_cache.g_elpept_inst';
1532: l_tabdet_set(0).tab_name := 'ben_elig_per_typ_prte_f';
1533: --
1534: elsif p_cache_code = 'ELPEES' then
1527: --
1528: l_mastertab_name := 'ben_eligy_prfl_f';
1529: l_masterpkcol_name := 'eligy_prfl_id';
1530: l_lkup_name := 'ben_elp_cache.g_elpept_lookup';
1531: l_inst_name := 'ben_elp_cache.g_elpept_inst';
1532: l_tabdet_set(0).tab_name := 'ben_elig_per_typ_prte_f';
1533: --
1534: elsif p_cache_code = 'ELPEES' then
1535: --
1534: elsif p_cache_code = 'ELPEES' then
1535: --
1536: l_mastertab_name := 'ben_eligy_prfl_f';
1537: l_masterpkcol_name := 'eligy_prfl_id';
1538: l_lkup_name := 'ben_elp_cache.g_elpees_lookup';
1539: l_inst_name := 'ben_elp_cache.g_elpees_inst';
1540: l_tabdet_set(0).tab_name := 'ben_elig_ee_stat_prte_f';
1541: --
1542: elsif p_cache_code = 'ELPESA' then
1535: --
1536: l_mastertab_name := 'ben_eligy_prfl_f';
1537: l_masterpkcol_name := 'eligy_prfl_id';
1538: l_lkup_name := 'ben_elp_cache.g_elpees_lookup';
1539: l_inst_name := 'ben_elp_cache.g_elpees_inst';
1540: l_tabdet_set(0).tab_name := 'ben_elig_ee_stat_prte_f';
1541: --
1542: elsif p_cache_code = 'ELPESA' then
1543: --
1542: elsif p_cache_code = 'ELPESA' then
1543: --
1544: l_mastertab_name := 'ben_eligy_prfl_f';
1545: l_masterpkcol_name := 'eligy_prfl_id';
1546: l_lkup_name := 'ben_elp_cache.g_elpesa_lookup';
1547: l_inst_name := 'ben_elp_cache.g_elpesa_inst';
1548: l_tabdet_set(0).tab_name := 'ben_elig_svc_area_prte_f';
1549: l_tabdet_set(0).tab_jncolnm := 'svc_area_id';
1550: l_tabdet_set(1).tab_name := 'ben_svc_area_pstl_zip_rng_f';
1543: --
1544: l_mastertab_name := 'ben_eligy_prfl_f';
1545: l_masterpkcol_name := 'eligy_prfl_id';
1546: l_lkup_name := 'ben_elp_cache.g_elpesa_lookup';
1547: l_inst_name := 'ben_elp_cache.g_elpesa_inst';
1548: l_tabdet_set(0).tab_name := 'ben_elig_svc_area_prte_f';
1549: l_tabdet_set(0).tab_jncolnm := 'svc_area_id';
1550: l_tabdet_set(1).tab_name := 'ben_svc_area_pstl_zip_rng_f';
1551: l_tabdet_set(1).tab_jncolnm := 'pstl_zip_rng_id';
1554: elsif p_cache_code = 'ELPEHS' then
1555: --
1556: l_mastertab_name := 'ben_eligy_prfl_f';
1557: l_masterpkcol_name := 'eligy_prfl_id';
1558: l_lkup_name := 'ben_elp_cache.g_elpehs_lookup';
1559: l_inst_name := 'ben_elp_cache.g_elpehs_inst';
1560: l_tabdet_set(0).tab_name := 'ben_elig_hrly_slrd_prte_f';
1561: --
1562: elsif p_cache_code = 'ELPELS' then
1555: --
1556: l_mastertab_name := 'ben_eligy_prfl_f';
1557: l_masterpkcol_name := 'eligy_prfl_id';
1558: l_lkup_name := 'ben_elp_cache.g_elpehs_lookup';
1559: l_inst_name := 'ben_elp_cache.g_elpehs_inst';
1560: l_tabdet_set(0).tab_name := 'ben_elig_hrly_slrd_prte_f';
1561: --
1562: elsif p_cache_code = 'ELPELS' then
1563: --
1562: elsif p_cache_code = 'ELPELS' then
1563: --
1564: l_mastertab_name := 'ben_eligy_prfl_f';
1565: l_masterpkcol_name := 'eligy_prfl_id';
1566: l_lkup_name := 'ben_elp_cache.g_elpels_lookup';
1567: l_inst_name := 'ben_elp_cache.g_elpels_inst';
1568: l_tabdet_set(0).tab_name := 'ben_elig_los_prte_f';
1569: l_tabdet_set(0).tab_jncolnm := 'los_fctr_id';
1570: l_tabdet_set(1).tab_name := 'ben_los_fctr';
1563: --
1564: l_mastertab_name := 'ben_eligy_prfl_f';
1565: l_masterpkcol_name := 'eligy_prfl_id';
1566: l_lkup_name := 'ben_elp_cache.g_elpels_lookup';
1567: l_inst_name := 'ben_elp_cache.g_elpels_inst';
1568: l_tabdet_set(0).tab_name := 'ben_elig_los_prte_f';
1569: l_tabdet_set(0).tab_jncolnm := 'los_fctr_id';
1570: l_tabdet_set(1).tab_name := 'ben_los_fctr';
1571: l_tabdet_set(1).tab_datetype := 'nondt';
1573: elsif p_cache_code = 'ELPECP' then
1574: --
1575: l_mastertab_name := 'ben_eligy_prfl_f';
1576: l_masterpkcol_name := 'eligy_prfl_id';
1577: l_lkup_name := 'ben_elp_cache.g_elpecp_lookup';
1578: l_inst_name := 'ben_elp_cache.g_elpecp_inst';
1579: l_tabdet_set(0).tab_name := 'ben_elig_cmbn_age_los_prte_f';
1580: l_tabdet_set(0).tab_jncolnm := 'cmbn_age_los_fctr_id';
1581: l_tabdet_set(1).tab_name := 'ben_cmbn_age_los_fctr';
1574: --
1575: l_mastertab_name := 'ben_eligy_prfl_f';
1576: l_masterpkcol_name := 'eligy_prfl_id';
1577: l_lkup_name := 'ben_elp_cache.g_elpecp_lookup';
1578: l_inst_name := 'ben_elp_cache.g_elpecp_inst';
1579: l_tabdet_set(0).tab_name := 'ben_elig_cmbn_age_los_prte_f';
1580: l_tabdet_set(0).tab_jncolnm := 'cmbn_age_los_fctr_id';
1581: l_tabdet_set(1).tab_name := 'ben_cmbn_age_los_fctr';
1582: l_tabdet_set(1).tab_datetype := 'nondt';
2235: (p_effective_date in date,
2236: p_business_group_id in number,
2237: p_eligy_prfl_id in number,
2238: p_refresh_cache in boolean default FALSE,
2239: p_inst_set out nocopy ben_elp_cache.g_cache_elpepg_instor,
2240: p_inst_count out nocopy number) is
2241: --
2242: l_proc varchar2(72) := 'elpepg_getcacdets';
2243: l_torrwnum pls_integer;
2262: if g_cache_elpepg_lookup.count = 0 then
2263: --
2264: -- Build the cache
2265: --
2266: ben_elp_cache.elpepg_writecache
2267: (p_effective_date => p_effective_date,
2268: p_refresh_cache => p_refresh_cache);
2269: --
2270: end if;
2496: (p_effective_date in date,
2497: p_business_group_id in number,
2498: p_eligy_prfl_id in number,
2499: p_refresh_cache in boolean default FALSE,
2500: p_inst_set out nocopy ben_elp_cache.g_cache_elpept_instor,
2501: p_inst_count out nocopy number) is
2502: --
2503: l_proc varchar2(72) := 'elpept_getcacdets';
2504: l_torrwnum pls_integer;
2523: if g_cache_elpept_lookup.count = 0 then
2524: --
2525: -- Build the cache
2526: --
2527: ben_elp_cache.elpept_writecache
2528: (p_effective_date => p_effective_date,
2529: p_refresh_cache => p_refresh_cache);
2530: --
2531: end if;
2751: (p_effective_date in date,
2752: p_business_group_id in number,
2753: p_eligy_prfl_id in number,
2754: p_refresh_cache in boolean default FALSE,
2755: p_inst_set out nocopy ben_elp_cache.g_cache_elpean_instor,
2756: p_inst_count out nocopy number) is
2757: --
2758: l_proc varchar2(72) := 'elpean_getcacdets';
2759: l_torrwnum pls_integer;
2778: if g_cache_elpean_lookup.count = 0 then
2779: --
2780: -- Build the cache
2781: --
2782: ben_elp_cache.elpean_writecache
2783: (p_effective_date => p_effective_date,
2784: p_refresh_cache => p_refresh_cache);
2785: --
2786: end if;
3001: (p_effective_date in date,
3002: p_business_group_id in number,
3003: p_eligy_prfl_id in number,
3004: p_refresh_cache in boolean default FALSE,
3005: p_inst_set out nocopy ben_elp_cache.g_cache_elperl_instor,
3006: p_inst_count out nocopy number) is
3007: --
3008: l_proc varchar2(72) := 'elperl_getcacdets';
3009: l_torrwnum pls_integer;
3028: if g_cache_elperl_lookup.count = 0 then
3029: --
3030: -- Build the cache
3031: --
3032: ben_elp_cache.elperl_writecache
3033: (p_effective_date => p_effective_date,
3034: p_refresh_cache => p_refresh_cache);
3035: --
3036: end if;
3255: (p_effective_date in date,
3256: p_business_group_id in number,
3257: p_eligy_prfl_id in number,
3258: p_refresh_cache in boolean default FALSE,
3259: p_inst_set out nocopy ben_elp_cache.g_cache_elpees_instor,
3260: p_inst_count out nocopy number) is
3261: --
3262: l_proc varchar2(72) := 'elpees_getcacdets';
3263: l_torrwnum pls_integer;
3282: if g_cache_elpees_lookup.count = 0 then
3283: --
3284: -- Build the cache
3285: --
3286: ben_elp_cache.elpees_writecache
3287: (p_effective_date => p_effective_date,
3288: p_refresh_cache => p_refresh_cache);
3289: --
3290: end if;
3528: (p_effective_date in date,
3529: p_business_group_id in number,
3530: p_eligy_prfl_id in number,
3531: p_refresh_cache in boolean default FALSE,
3532: p_inst_set out nocopy ben_elp_cache.g_cache_elpesa_instor,
3533: p_inst_count out nocopy number) is
3534: --
3535: l_proc varchar2(72) := 'elpesa_getcacdets';
3536: l_torrwnum pls_integer;
3555: if g_cache_elpesa_lookup.count = 0 then
3556: --
3557: -- Build the cache
3558: --
3559: ben_elp_cache.elpesa_writecache
3560: (p_effective_date => p_effective_date,
3561: p_refresh_cache => p_refresh_cache);
3562: --
3563: end if;
3798: (p_effective_date in date,
3799: p_business_group_id in number,
3800: p_eligy_prfl_id in number,
3801: p_refresh_cache in boolean default FALSE,
3802: p_inst_set out nocopy ben_elp_cache.g_cache_elpels_instor,
3803: p_inst_count out nocopy number) is
3804: --
3805: l_proc varchar2(72) := 'elpels_getcacdets';
3806: l_torrwnum pls_integer;
3825: if g_cache_elpels_lookup.count = 0 then
3826: --
3827: -- Build the cache
3828: --
3829: ben_elp_cache.elpels_writecache
3830: (p_effective_date => p_effective_date,
3831: p_refresh_cache => p_refresh_cache);
3832: --
3833: end if;
4068: (p_effective_date in date,
4069: p_business_group_id in number,
4070: p_eligy_prfl_id in number,
4071: p_refresh_cache in boolean default FALSE,
4072: p_inst_set out nocopy ben_elp_cache.g_cache_elpecp_instor,
4073: p_inst_count out nocopy number) is
4074: --
4075: l_proc varchar2(72) := 'elpecp_getcacdets';
4076: l_torrwnum pls_integer;
4095: if g_cache_elpecp_lookup.count = 0 then
4096: --
4097: -- Build the cache
4098: --
4099: ben_elp_cache.elpecp_writecache
4100: (p_effective_date => p_effective_date,
4101: p_refresh_cache => p_refresh_cache);
4102: --
4103: end if;
4322: (p_effective_date in date,
4323: p_business_group_id in number,
4324: p_eligy_prfl_id in number,
4325: p_refresh_cache in boolean default FALSE,
4326: p_inst_set out nocopy ben_elp_cache.g_cache_elpewl_instor,
4327: p_inst_count out nocopy number) is
4328: --
4329: l_proc varchar2(72) := 'elpewl_getcacdets';
4330: l_torrwnum pls_integer;
4349: if g_cache_elpewl_lookup.count = 0 then
4350: --
4351: -- Build the cache
4352: --
4353: ben_elp_cache.elpewl_writecache
4354: (p_effective_date => p_effective_date,
4355: p_refresh_cache => p_refresh_cache);
4356: --
4357: end if;
4576: (p_effective_date in date,
4577: p_business_group_id in number,
4578: p_eligy_prfl_id in number,
4579: p_refresh_cache in boolean default FALSE,
4580: p_inst_set out nocopy ben_elp_cache.g_cache_elpeou_instor,
4581: p_inst_count out nocopy number) is
4582: --
4583: l_proc varchar2(72) := 'elpeou_getcacdets';
4584: l_torrwnum pls_integer;
4603: if g_cache_elpeou_lookup.count = 0 then
4604: --
4605: -- Build the cache
4606: --
4607: ben_elp_cache.elpeou_writecache
4608: (p_effective_date => p_effective_date,
4609: p_refresh_cache => p_refresh_cache);
4610: --
4611: end if;
4829: (p_effective_date in date,
4830: p_business_group_id in number,
4831: p_eligy_prfl_id in number,
4832: p_refresh_cache in boolean default FALSE,
4833: p_inst_set out nocopy ben_elp_cache.g_cache_elpehs_instor,
4834: p_inst_count out nocopy number) is
4835: --
4836: l_proc varchar2(72) := 'elpehs_getcacdets';
4837: l_torrwnum pls_integer;
4857: if g_cache_elpehs_lookup.count = 0 then
4858: --
4859: -- Build the cache
4860: --
4861: ben_elp_cache.elpehs_writecache
4862: (p_effective_date => p_effective_date,
4863: p_refresh_cache => p_refresh_cache);
4864: --
4865: end if;
5087: (p_effective_date in date,
5088: p_business_group_id in number,
5089: p_eligy_prfl_id in number,
5090: p_refresh_cache in boolean default FALSE,
5091: p_inst_set out nocopy ben_elp_cache.g_cache_elpefp_instor,
5092: p_inst_count out nocopy number) is
5093: --
5094: l_proc varchar2(72) := 'elpefp_getcacdets';
5095: l_torrwnum pls_integer;
5114: if g_cache_elpefp_lookup.count = 0 then
5115: --
5116: -- Build the cache
5117: --
5118: ben_elp_cache.elpefp_writecache
5119: (p_effective_date => p_effective_date,
5120: p_refresh_cache => p_refresh_cache);
5121: --
5122: end if;
5355: (p_effective_date in date,
5356: p_business_group_id in number,
5357: p_eligy_prfl_id in number,
5358: p_refresh_cache in boolean default FALSE,
5359: p_inst_set out nocopy ben_elp_cache.g_cache_elpesh_instor,
5360: p_inst_count out nocopy number) is
5361: --
5362: l_proc varchar2(72) := 'elpesh_getcacdets';
5363: l_torrwnum pls_integer;
5382: if g_cache_elpesh_lookup.count = 0 then
5383: --
5384: -- Build the cache
5385: --
5386: ben_elp_cache.elpesh_writecache
5387: (p_effective_date => p_effective_date,
5388: p_refresh_cache => p_refresh_cache);
5389: --
5390: end if;
5625: p_business_group_id in number,
5626: p_eligy_prfl_id in number,
5627: p_hrs_src_cd in varchar2 default null,
5628: p_refresh_cache in boolean default FALSE,
5629: p_inst_set out nocopy ben_elp_cache.g_cache_elpehw_instor,
5630: p_inst_count out nocopy number) is
5631: --
5632: l_proc varchar2(72) := 'elpehw_getcacdets';
5633: l_torrwnum pls_integer;
5652: if g_cache_elpehw_lookup.count = 0 then
5653: --
5654: -- Build the cache
5655: --
5656: ben_elp_cache.elpehw_writecache
5657: (p_effective_date => p_effective_date,
5658: p_refresh_cache => p_refresh_cache);
5659: --
5660: end if;
5899: p_business_group_id in number,
5900: p_eligy_prfl_id in number,
5901: p_comp_src_cd in varchar2 default null,
5902: p_refresh_cache in boolean default FALSE,
5903: p_inst_set out nocopy ben_elp_cache.g_cache_elpecl_instor,
5904: p_inst_count out nocopy number) is
5905: --
5906: l_proc varchar2(72) := 'elpecl_getcacdets';
5907: l_torrwnum pls_integer;
5926: if g_cache_elpecl_lookup.count = 0 then
5927: --
5928: -- Build the cache
5929: --
5930: ben_elp_cache.elpecl_writecache
5931: (p_effective_date => p_effective_date,
5932: p_refresh_cache => p_refresh_cache);
5933: --
5934: end if;
6170: (p_effective_date in date,
6171: p_business_group_id in number,
6172: p_eligy_prfl_id in number,
6173: p_refresh_cache in boolean default FALSE,
6174: p_inst_set out nocopy ben_elp_cache.g_cache_elpepf_instor,
6175: p_inst_count out nocopy number) is
6176: --
6177: l_proc varchar2(72) := 'elpepf_getcacdets';
6178: l_torrwnum pls_integer;
6197: if g_cache_elpepf_lookup.count = 0 then
6198: --
6199: -- Build the cache
6200: --
6201: ben_elp_cache.elpepf_writecache
6202: (p_effective_date => p_effective_date,
6203: p_refresh_cache => p_refresh_cache);
6204: --
6205: end if;
6424: (p_effective_date in date,
6425: p_business_group_id in number,
6426: p_eligy_prfl_id in number,
6427: p_refresh_cache in boolean default FALSE,
6428: p_inst_set out nocopy ben_elp_cache.g_cache_elpegr_instor,
6429: p_inst_count out nocopy number) is
6430: --
6431: l_proc varchar2(72) := 'elpegr_getcacdets';
6432: l_torrwnum pls_integer;
6451: if g_cache_elpegr_lookup.count = 0 then
6452: --
6453: -- Build the cache
6454: --
6455: ben_elp_cache.elpegr_writecache
6456: (p_effective_date => p_effective_date,
6457: p_refresh_cache => p_refresh_cache);
6458: --
6459: end if;
6678: (p_effective_date in date,
6679: p_business_group_id in number,
6680: p_eligy_prfl_id in number,
6681: p_refresh_cache in boolean default FALSE,
6682: p_inst_set out nocopy ben_elp_cache.g_cache_elpegn_instor,
6683: p_inst_count out nocopy number) is
6684: --
6685: l_proc varchar2(72) := 'elpegn_getcacdets';
6686: l_torrwnum pls_integer;
6705: if g_cache_elpegn_lookup.count = 0 then
6706: --
6707: -- Build the cache
6708: --
6709: ben_elp_cache.elpegn_writecache
6710: (p_effective_date => p_effective_date,
6711: p_refresh_cache => p_refresh_cache);
6712: --
6713: end if;
6929: (p_effective_date in date,
6930: p_business_group_id in number,
6931: p_eligy_prfl_id in number,
6932: p_refresh_cache in boolean default FALSE,
6933: p_inst_set out nocopy ben_elp_cache.g_cache_elpejp_instor,
6934: p_inst_count out nocopy number) is
6935: --
6936: l_proc varchar2(72) := 'elpejp_getcacdets';
6937: l_torrwnum pls_integer;
6956: if g_cache_elpejp_lookup.count = 0 then
6957: --
6958: -- Build the cache
6959: --
6960: ben_elp_cache.elpejp_writecache
6961: (p_effective_date => p_effective_date,
6962: p_refresh_cache => p_refresh_cache);
6963: --
6964: end if;
7183: (p_effective_date in date,
7184: p_business_group_id in number,
7185: p_eligy_prfl_id in number,
7186: p_refresh_cache in boolean default FALSE,
7187: p_inst_set out nocopy ben_elp_cache.g_cache_elpepb_instor,
7188: p_inst_count out nocopy number) is
7189: --
7190: l_proc varchar2(72) := 'elpepb_getcacdets';
7191: l_torrwnum pls_integer;
7210: if g_cache_elpepb_lookup.count = 0 then
7211: --
7212: -- Build the cache
7213: --
7214: ben_elp_cache.elpepb_writecache
7215: (p_effective_date => p_effective_date,
7216: p_refresh_cache => p_refresh_cache);
7217: --
7218: end if;
7436: (p_effective_date in date,
7437: p_business_group_id in number,
7438: p_eligy_prfl_id in number,
7439: p_refresh_cache in boolean default FALSE,
7440: p_inst_set out nocopy ben_elp_cache.g_cache_elpepy_instor,
7441: p_inst_count out nocopy number) is
7442: --
7443: l_proc varchar2(72) := 'elpepy_getcacdets';
7444: l_torrwnum pls_integer;
7463: if g_cache_elpepy_lookup.count = 0 then
7464: --
7465: -- Build the cache
7466: --
7467: ben_elp_cache.elpepy_writecache
7468: (p_effective_date => p_effective_date,
7469: p_refresh_cache => p_refresh_cache);
7470: --
7471: end if;
7690: (p_effective_date in date,
7691: p_business_group_id in number,
7692: p_eligy_prfl_id in number,
7693: p_refresh_cache in boolean default FALSE,
7694: p_inst_set out nocopy ben_elp_cache.g_cache_elpebu_instor,
7695: p_inst_count out nocopy number) is
7696: --
7697: l_proc varchar2(72) := 'elpebu_getcacdets';
7698: l_torrwnum pls_integer;
7717: if g_cache_elpebu_lookup.count = 0 then
7718: --
7719: -- Build the cache
7720: --
7721: ben_elp_cache.elpebu_writecache
7722: (p_effective_date => p_effective_date,
7723: p_refresh_cache => p_refresh_cache);
7724: --
7725: end if;
7944: (p_effective_date in date,
7945: p_business_group_id in number,
7946: p_eligy_prfl_id in number,
7947: p_refresh_cache in boolean default FALSE,
7948: p_inst_set out nocopy ben_elp_cache.g_cache_elpelu_instor,
7949: p_inst_count out nocopy number) is
7950: --
7951: l_proc varchar2(72) := 'elpelu_getcacdets';
7952: l_torrwnum pls_integer;
7971: if g_cache_elpelu_lookup.count = 0 then
7972: --
7973: -- Build the cache
7974: --
7975: ben_elp_cache.elpelu_writecache
7976: (p_effective_date => p_effective_date,
7977: p_refresh_cache => p_refresh_cache);
7978: --
7979: end if;
8200: (p_effective_date in date,
8201: p_business_group_id in number,
8202: p_eligy_prfl_id in number,
8203: p_refresh_cache in boolean default FALSE,
8204: p_inst_set out nocopy ben_elp_cache.g_cache_elpelr_instor,
8205: p_inst_count out nocopy number) is
8206: --
8207: l_proc varchar2(72) := 'elpelr_getcacdets';
8208: l_torrwnum pls_integer;
8227: if g_cache_elpelr_lookup.count = 0 then
8228: --
8229: -- Build the cache
8230: --
8231: ben_elp_cache.elpelr_writecache
8232: (p_effective_date => p_effective_date,
8233: p_refresh_cache => p_refresh_cache);
8234: --
8235: end if;
8467: (p_effective_date in date,
8468: p_business_group_id in number,
8469: p_eligy_prfl_id in number,
8470: p_refresh_cache in boolean default FALSE,
8471: p_inst_set out nocopy ben_elp_cache.g_cache_elpeap_instor,
8472: p_inst_count out nocopy number) is
8473: --
8474: l_proc varchar2(72) := 'elpeap_getcacdets';
8475: l_torrwnum pls_integer;
8494: if g_cache_elpeap_lookup.count = 0 then
8495: --
8496: -- Build the cache
8497: --
8498: ben_elp_cache.elpeap_writecache
8499: (p_effective_date => p_effective_date,
8500: p_refresh_cache => p_refresh_cache);
8501: --
8502: end if;
8735: (p_effective_date in date,
8736: p_business_group_id in number,
8737: p_eligy_prfl_id in number,
8738: p_refresh_cache in boolean default FALSE,
8739: p_inst_set out nocopy ben_elp_cache.g_cache_elpepz_instor,
8740: p_inst_count out nocopy number) is
8741: --
8742: l_proc varchar2(72) := 'elpepz_getcacdets';
8743: l_torrwnum pls_integer;
8762: if g_cache_elpepz_lookup.count = 0 then
8763: --
8764: -- Build the cache
8765: --
8766: ben_elp_cache.elpepz_writecache
8767: (p_effective_date => p_effective_date,
8768: p_refresh_cache => p_refresh_cache);
8769: --
8770: end if;
8989: (p_effective_date in date,
8990: p_business_group_id in number,
8991: p_eligy_prfl_id in number,
8992: p_refresh_cache in boolean default FALSE,
8993: p_inst_set out nocopy ben_elp_cache.g_cache_elpebn_instor,
8994: p_inst_count out nocopy number) is
8995: --
8996: l_proc varchar2(72) := 'elpebn_getcacdets';
8997: l_torrwnum pls_integer;
9016: if g_cache_elpebn_lookup.count = 0 then
9017: --
9018: -- Build the cache
9019: --
9020: ben_elp_cache.elpebn_writecache
9021: (p_effective_date => p_effective_date,
9022: p_refresh_cache => p_refresh_cache);
9023: --
9024: end if;
9249: (p_effective_date in date,
9250: p_business_group_id in number,
9251: p_eligy_prfl_id in number,
9252: p_refresh_cache in boolean default FALSE,
9253: p_inst_set out nocopy ben_elp_cache.g_cache_elpeln_instor,
9254: p_inst_count out nocopy number) is
9255: --
9256: l_proc varchar2(72) := 'elpeln_getcacdets';
9257: l_torrwnum pls_integer;
9276: if g_cache_elpeln_lookup.count = 0 then
9277: --
9278: -- Build the cache
9279: --
9280: ben_elp_cache.elpeln_writecache
9281: (p_effective_date => p_effective_date,
9282: p_refresh_cache => p_refresh_cache);
9283: --
9284: end if;
9495: (p_effective_date in date,
9496: p_business_group_id in number,
9497: p_eligy_prfl_id in number,
9498: p_refresh_cache in boolean default FALSE,
9499: p_inst_set out nocopy ben_elp_cache.g_cache_elpepp_instor,
9500: p_inst_count out nocopy number) is
9501: --
9502: l_proc varchar2(72) := 'elpepp_getcacdets';
9503: l_torrwnum pls_integer;
9522: if g_cache_elpepp_lookup.count = 0 then
9523: --
9524: -- Build the cache
9525: --
9526: ben_elp_cache.elpepp_writecache
9527: (p_effective_date => p_effective_date,
9528: p_refresh_cache => p_refresh_cache);
9529: --
9530: end if;
9744: (p_effective_date in date,
9745: p_business_group_id in number,
9746: p_eligy_prfl_id in number,
9747: p_refresh_cache in boolean default FALSE,
9748: p_inst_set out nocopy ben_elp_cache.g_cache_elpeoy_instor,
9749: p_inst_count out nocopy number) is
9750: --
9751: l_proc varchar2(72) := 'elpeoy_getcacdets';
9752: l_torrwnum pls_integer;
9771: if g_cache_elpeoy_lookup.count = 0 then
9772: --
9773: -- Build the cache
9774: --
9775: ben_elp_cache.elpeoy_writecache
9776: (p_effective_date => p_effective_date,
9777: p_refresh_cache => p_refresh_cache);
9778: --
9779: end if;
9994: (p_effective_date in date,
9995: p_business_group_id in number,
9996: p_eligy_prfl_id in number,
9997: p_refresh_cache in boolean default FALSE,
9998: p_inst_set out nocopy ben_elp_cache.g_cache_elpetd_instor,
9999: p_inst_count out nocopy number) is
10000: --
10001: l_proc varchar2(72) := 'elpetd_getcacdets';
10002: l_torrwnum pls_integer;
10021: if g_cache_elpetd_lookup.count = 0 then
10022: --
10023: -- Build the cache
10024: --
10025: ben_elp_cache.elpetd_writecache
10026: (p_effective_date => p_effective_date,
10027: p_refresh_cache => p_refresh_cache);
10028: --
10029: end if;
10239: (p_effective_date in date,
10240: p_business_group_id in number,
10241: p_eligy_prfl_id in number,
10242: p_refresh_cache in boolean default FALSE,
10243: p_inst_set out nocopy ben_elp_cache.g_cache_elpeno_instor,
10244: p_inst_count out nocopy number) is
10245: --
10246: l_proc varchar2(72) := 'elpeno_getcacdets';
10247: l_torrwnum pls_integer;
10266: if g_cache_elpeno_lookup.count = 0 then
10267: --
10268: -- Build the cache
10269: --
10270: ben_elp_cache.elpeno_writecache
10271: (p_effective_date => p_effective_date,
10272: p_refresh_cache => p_refresh_cache);
10273: --
10274: end if;
10487: (p_effective_date in date,
10488: p_business_group_id in number,
10489: p_eligy_prfl_id in number,
10490: p_refresh_cache in boolean default FALSE,
10491: p_inst_set out nocopy ben_elp_cache.g_cache_elpeep_instor,
10492: p_inst_count out nocopy number) is
10493: --
10494: l_proc varchar2(72) := 'elpeep_getcacdets';
10495: l_torrwnum pls_integer;
10514: if g_cache_elpeep_lookup.count = 0 then
10515: --
10516: -- Build the cache
10517: --
10518: ben_elp_cache.elpeep_writecache
10519: (p_effective_date => p_effective_date,
10520: p_refresh_cache => p_refresh_cache);
10521: --
10522: end if;
10735: (p_effective_date in date,
10736: p_business_group_id in number,
10737: p_eligy_prfl_id in number,
10738: p_refresh_cache in boolean default FALSE,
10739: p_inst_set out nocopy ben_elp_cache.g_cache_elpeei_instor,
10740: p_inst_count out nocopy number) is
10741: --
10742: l_proc varchar2(72) := 'elpeei_getcacdets';
10743: l_torrwnum pls_integer;
10762: if g_cache_elpeei_lookup.count = 0 then
10763: --
10764: -- Build the cache
10765: --
10766: ben_elp_cache.elpeei_writecache
10767: (p_effective_date => p_effective_date,
10768: p_refresh_cache => p_refresh_cache);
10769: --
10770: end if;
10983: (p_effective_date in date,
10984: p_business_group_id in number,
10985: p_eligy_prfl_id in number,
10986: p_refresh_cache in boolean default FALSE,
10987: p_inst_set out nocopy ben_elp_cache.g_cache_elpeeg_instor,
10988: p_inst_count out nocopy number) is
10989: --
10990: l_proc varchar2(72) := 'elpeeg_getcacdets';
10991: l_torrwnum pls_integer;
11010: if g_cache_elpeeg_lookup.count = 0 then
11011: --
11012: -- Build the cache
11013: --
11014: ben_elp_cache.elpeeg_writecache
11015: (p_effective_date => p_effective_date,
11016: p_refresh_cache => p_refresh_cache);
11017: --
11018: end if;
11231: (p_effective_date in date,
11232: p_business_group_id in number,
11233: p_eligy_prfl_id in number,
11234: p_refresh_cache in boolean default FALSE,
11235: p_inst_set out nocopy ben_elp_cache.g_cache_elpedp_instor,
11236: p_inst_count out nocopy number) is
11237: --
11238: l_proc varchar2(72) := 'elpedp_getcacdets';
11239: l_torrwnum pls_integer;
11258: if g_cache_elpedp_lookup.count = 0 then
11259: --
11260: -- Build the cache
11261: --
11262: ben_elp_cache.elpedp_writecache
11263: (p_effective_date => p_effective_date,
11264: p_refresh_cache => p_refresh_cache);
11265: --
11266: end if;
11485: (p_effective_date in date,
11486: p_business_group_id in number,
11487: p_eligy_prfl_id in number,
11488: p_refresh_cache in boolean default FALSE,
11489: p_inst_set out nocopy ben_elp_cache.g_cache_elpelv_instor,
11490: p_inst_count out nocopy number) is
11491: --
11492: l_proc varchar2(72) := 'elpelv_getcacdets';
11493: l_torrwnum pls_integer;
11512: if g_cache_elpelv_lookup.count = 0 then
11513: --
11514: -- Build the cache
11515: --
11516: ben_elp_cache.elpelv_writecache
11517: (p_effective_date => p_effective_date,
11518: p_refresh_cache => p_refresh_cache);
11519: --
11520: end if;
11730: (p_effective_date in date,
11731: p_business_group_id in number,
11732: p_eligy_prfl_id in number,
11733: p_refresh_cache in boolean default FALSE,
11734: p_inst_set out nocopy ben_elp_cache.g_cache_elpeom_instor,
11735: p_inst_count out nocopy number) is
11736: --
11737: l_proc varchar2(72) := 'elpeom_getcacdets';
11738: l_torrwnum pls_integer;
11757: if g_cache_elpeom_lookup.count = 0 then
11758: --
11759: -- Build the cache
11760: --
11761: ben_elp_cache.elpeom_writecache
11762: (p_effective_date => p_effective_date,
11763: p_refresh_cache => p_refresh_cache);
11764: --
11765: end if;
11977: (p_effective_date in date,
11978: p_business_group_id in number,
11979: p_eligy_prfl_id in number,
11980: p_refresh_cache in boolean default FALSE,
11981: p_inst_set out nocopy ben_elp_cache.g_cache_elpeai_instor,
11982: p_inst_count out nocopy number) is
11983: --
11984: l_proc varchar2(72) := 'elpeai_getcacdets';
11985: l_torrwnum pls_integer;
12004: if g_cache_elpeai_lookup.count = 0 then
12005: --
12006: -- Build the cache
12007: --
12008: ben_elp_cache.elpeai_writecache
12009: (p_effective_date => p_effective_date,
12010: p_refresh_cache => p_refresh_cache);
12011: --
12012: end if;
12224: (p_effective_date in date,
12225: p_business_group_id in number,
12226: p_eligy_prfl_id in number,
12227: p_refresh_cache in boolean default FALSE,
12228: p_inst_set out nocopy ben_elp_cache.g_cache_elpedi_instor,
12229: p_inst_count out nocopy number) is
12230: --
12231: l_proc varchar2(72) := 'elpedi_getcacdets';
12232: l_torrwnum pls_integer;
12251: if g_cache_elpedi_lookup.count = 0 then
12252: --
12253: -- Build the cache
12254: --
12255: ben_elp_cache.elpedi_writecache
12256: (p_effective_date => p_effective_date,
12257: p_refresh_cache => p_refresh_cache);
12258: --
12259: end if;
12473: (p_effective_date in date,
12474: p_business_group_id in number,
12475: p_eligy_prfl_id in number,
12476: p_refresh_cache in boolean default FALSE,
12477: p_inst_set out nocopy ben_elp_cache.g_cache_elpeet_instor,
12478: p_inst_count out nocopy number) is
12479: --
12480: l_proc varchar2(72) := 'elpeet_getcacdets';
12481: l_torrwnum pls_integer;
12500: if g_cache_elpeet_lookup.count = 0 then
12501: --
12502: -- Build the cache
12503: --
12504: ben_elp_cache.elpeet_writecache
12505: (p_effective_date => p_effective_date,
12506: p_refresh_cache => p_refresh_cache);
12507: --
12508: end if;
12722: (p_effective_date in date,
12723: p_business_group_id in number,
12724: p_eligy_prfl_id in number,
12725: p_refresh_cache in boolean default FALSE,
12726: p_inst_set out nocopy ben_elp_cache.g_cache_elpedt_instor,
12727: p_inst_count out nocopy number) is
12728: --
12729: l_proc varchar2(72) := 'elpedt_getcacdets';
12730: l_torrwnum pls_integer;
12749: if g_cache_elpedt_lookup.count = 0 then
12750: --
12751: -- Build the cache
12752: --
12753: ben_elp_cache.elpedt_writecache
12754: (p_effective_date => p_effective_date,
12755: p_refresh_cache => p_refresh_cache);
12756: --
12757: end if;
12969: (p_effective_date in date,
12970: p_business_group_id in number,
12971: p_eligy_prfl_id in number,
12972: p_refresh_cache in boolean default FALSE,
12973: p_inst_set out nocopy ben_elp_cache.g_cache_elpedg_instor,
12974: p_inst_count out nocopy number) is
12975: --
12976: l_proc varchar2(72) := 'elpedg_getcacdets';
12977: l_torrwnum pls_integer;
12996: if g_cache_elpedg_lookup.count = 0 then
12997: --
12998: -- Build the cache
12999: --
13000: ben_elp_cache.elpedg_writecache
13001: (p_effective_date => p_effective_date,
13002: p_refresh_cache => p_refresh_cache);
13003: --
13004: end if;
13224: (p_effective_date in date,
13225: p_business_group_id in number,
13226: p_eligy_prfl_id in number,
13227: p_refresh_cache in boolean default FALSE,
13228: p_inst_set out nocopy ben_elp_cache.g_cache_elpecq_instor,
13229: p_inst_count out nocopy number) is
13230: --
13231: l_proc varchar2(72) := 'elpecq_getcacdets';
13232: l_torrwnum pls_integer;
13251: if g_cache_elpecq_lookup.count = 0 then
13252: --
13253: -- Build the cache
13254: --
13255: ben_elp_cache.elpecq_writecache
13256: (p_effective_date => p_effective_date,
13257: p_refresh_cache => p_refresh_cache);
13258: --
13259: end if;
14034: end;
14035: --
14036: end clear_down_cache;
14037: --
14038: end ben_elp_cache;
14039: --