[Home] [Help]
1: PACKAGE BODY ben_elp_cache as
2: /* $Header: benelpch.pkb 120.1 2005/06/22 04:33:08 ssarkar noship $ */
3: --
4: -- Declare globals
5: --
2: /* $Header: benelpch.pkb 120.1 2005/06/22 04:33:08 ssarkar noship $ */
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;
2487: (p_effective_date in date,
2488: p_business_group_id in number,
2489: p_eligy_prfl_id in number,
2490: p_refresh_cache in boolean default FALSE,
2491: p_inst_set out nocopy ben_elp_cache.g_cache_elpept_instor,
2492: p_inst_count out nocopy number) is
2493: --
2494: l_proc varchar2(72) := 'elpept_getcacdets';
2495: l_torrwnum pls_integer;
2514: if g_cache_elpept_lookup.count = 0 then
2515: --
2516: -- Build the cache
2517: --
2518: ben_elp_cache.elpept_writecache
2519: (p_effective_date => p_effective_date,
2520: p_refresh_cache => p_refresh_cache);
2521: --
2522: end if;
2734: (p_effective_date in date,
2735: p_business_group_id in number,
2736: p_eligy_prfl_id in number,
2737: p_refresh_cache in boolean default FALSE,
2738: p_inst_set out nocopy ben_elp_cache.g_cache_elpean_instor,
2739: p_inst_count out nocopy number) is
2740: --
2741: l_proc varchar2(72) := 'elpean_getcacdets';
2742: l_torrwnum pls_integer;
2761: if g_cache_elpean_lookup.count = 0 then
2762: --
2763: -- Build the cache
2764: --
2765: ben_elp_cache.elpean_writecache
2766: (p_effective_date => p_effective_date,
2767: p_refresh_cache => p_refresh_cache);
2768: --
2769: end if;
2976: (p_effective_date in date,
2977: p_business_group_id in number,
2978: p_eligy_prfl_id in number,
2979: p_refresh_cache in boolean default FALSE,
2980: p_inst_set out nocopy ben_elp_cache.g_cache_elperl_instor,
2981: p_inst_count out nocopy number) is
2982: --
2983: l_proc varchar2(72) := 'elperl_getcacdets';
2984: l_torrwnum pls_integer;
3003: if g_cache_elperl_lookup.count = 0 then
3004: --
3005: -- Build the cache
3006: --
3007: ben_elp_cache.elperl_writecache
3008: (p_effective_date => p_effective_date,
3009: p_refresh_cache => p_refresh_cache);
3010: --
3011: end if;
3221: (p_effective_date in date,
3222: p_business_group_id in number,
3223: p_eligy_prfl_id in number,
3224: p_refresh_cache in boolean default FALSE,
3225: p_inst_set out nocopy ben_elp_cache.g_cache_elpees_instor,
3226: p_inst_count out nocopy number) is
3227: --
3228: l_proc varchar2(72) := 'elpees_getcacdets';
3229: l_torrwnum pls_integer;
3248: if g_cache_elpees_lookup.count = 0 then
3249: --
3250: -- Build the cache
3251: --
3252: ben_elp_cache.elpees_writecache
3253: (p_effective_date => p_effective_date,
3254: p_refresh_cache => p_refresh_cache);
3255: --
3256: end if;
3485: (p_effective_date in date,
3486: p_business_group_id in number,
3487: p_eligy_prfl_id in number,
3488: p_refresh_cache in boolean default FALSE,
3489: p_inst_set out nocopy ben_elp_cache.g_cache_elpesa_instor,
3490: p_inst_count out nocopy number) is
3491: --
3492: l_proc varchar2(72) := 'elpesa_getcacdets';
3493: l_torrwnum pls_integer;
3512: if g_cache_elpesa_lookup.count = 0 then
3513: --
3514: -- Build the cache
3515: --
3516: ben_elp_cache.elpesa_writecache
3517: (p_effective_date => p_effective_date,
3518: p_refresh_cache => p_refresh_cache);
3519: --
3520: end if;
3746: (p_effective_date in date,
3747: p_business_group_id in number,
3748: p_eligy_prfl_id in number,
3749: p_refresh_cache in boolean default FALSE,
3750: p_inst_set out nocopy ben_elp_cache.g_cache_elpels_instor,
3751: p_inst_count out nocopy number) is
3752: --
3753: l_proc varchar2(72) := 'elpels_getcacdets';
3754: l_torrwnum pls_integer;
3773: if g_cache_elpels_lookup.count = 0 then
3774: --
3775: -- Build the cache
3776: --
3777: ben_elp_cache.elpels_writecache
3778: (p_effective_date => p_effective_date,
3779: p_refresh_cache => p_refresh_cache);
3780: --
3781: end if;
4007: (p_effective_date in date,
4008: p_business_group_id in number,
4009: p_eligy_prfl_id in number,
4010: p_refresh_cache in boolean default FALSE,
4011: p_inst_set out nocopy ben_elp_cache.g_cache_elpecp_instor,
4012: p_inst_count out nocopy number) is
4013: --
4014: l_proc varchar2(72) := 'elpecp_getcacdets';
4015: l_torrwnum pls_integer;
4034: if g_cache_elpecp_lookup.count = 0 then
4035: --
4036: -- Build the cache
4037: --
4038: ben_elp_cache.elpecp_writecache
4039: (p_effective_date => p_effective_date,
4040: p_refresh_cache => p_refresh_cache);
4041: --
4042: end if;
4252: (p_effective_date in date,
4253: p_business_group_id in number,
4254: p_eligy_prfl_id in number,
4255: p_refresh_cache in boolean default FALSE,
4256: p_inst_set out nocopy ben_elp_cache.g_cache_elpewl_instor,
4257: p_inst_count out nocopy number) is
4258: --
4259: l_proc varchar2(72) := 'elpewl_getcacdets';
4260: l_torrwnum pls_integer;
4279: if g_cache_elpewl_lookup.count = 0 then
4280: --
4281: -- Build the cache
4282: --
4283: ben_elp_cache.elpewl_writecache
4284: (p_effective_date => p_effective_date,
4285: p_refresh_cache => p_refresh_cache);
4286: --
4287: end if;
4497: (p_effective_date in date,
4498: p_business_group_id in number,
4499: p_eligy_prfl_id in number,
4500: p_refresh_cache in boolean default FALSE,
4501: p_inst_set out nocopy ben_elp_cache.g_cache_elpeou_instor,
4502: p_inst_count out nocopy number) is
4503: --
4504: l_proc varchar2(72) := 'elpeou_getcacdets';
4505: l_torrwnum pls_integer;
4524: if g_cache_elpeou_lookup.count = 0 then
4525: --
4526: -- Build the cache
4527: --
4528: ben_elp_cache.elpeou_writecache
4529: (p_effective_date => p_effective_date,
4530: p_refresh_cache => p_refresh_cache);
4531: --
4532: end if;
4741: (p_effective_date in date,
4742: p_business_group_id in number,
4743: p_eligy_prfl_id in number,
4744: p_refresh_cache in boolean default FALSE,
4745: p_inst_set out nocopy ben_elp_cache.g_cache_elpehs_instor,
4746: p_inst_count out nocopy number) is
4747: --
4748: l_proc varchar2(72) := 'elpehs_getcacdets';
4749: l_torrwnum pls_integer;
4769: if g_cache_elpehs_lookup.count = 0 then
4770: --
4771: -- Build the cache
4772: --
4773: ben_elp_cache.elpehs_writecache
4774: (p_effective_date => p_effective_date,
4775: p_refresh_cache => p_refresh_cache);
4776: --
4777: end if;
4990: (p_effective_date in date,
4991: p_business_group_id in number,
4992: p_eligy_prfl_id in number,
4993: p_refresh_cache in boolean default FALSE,
4994: p_inst_set out nocopy ben_elp_cache.g_cache_elpefp_instor,
4995: p_inst_count out nocopy number) is
4996: --
4997: l_proc varchar2(72) := 'elpefp_getcacdets';
4998: l_torrwnum pls_integer;
5017: if g_cache_elpefp_lookup.count = 0 then
5018: --
5019: -- Build the cache
5020: --
5021: ben_elp_cache.elpefp_writecache
5022: (p_effective_date => p_effective_date,
5023: p_refresh_cache => p_refresh_cache);
5024: --
5025: end if;
5249: (p_effective_date in date,
5250: p_business_group_id in number,
5251: p_eligy_prfl_id in number,
5252: p_refresh_cache in boolean default FALSE,
5253: p_inst_set out nocopy ben_elp_cache.g_cache_elpesh_instor,
5254: p_inst_count out nocopy number) is
5255: --
5256: l_proc varchar2(72) := 'elpesh_getcacdets';
5257: l_torrwnum pls_integer;
5276: if g_cache_elpesh_lookup.count = 0 then
5277: --
5278: -- Build the cache
5279: --
5280: ben_elp_cache.elpesh_writecache
5281: (p_effective_date => p_effective_date,
5282: p_refresh_cache => p_refresh_cache);
5283: --
5284: end if;
5510: p_business_group_id in number,
5511: p_eligy_prfl_id in number,
5512: p_hrs_src_cd in varchar2 default null,
5513: p_refresh_cache in boolean default FALSE,
5514: p_inst_set out nocopy ben_elp_cache.g_cache_elpehw_instor,
5515: p_inst_count out nocopy number) is
5516: --
5517: l_proc varchar2(72) := 'elpehw_getcacdets';
5518: l_torrwnum pls_integer;
5537: if g_cache_elpehw_lookup.count = 0 then
5538: --
5539: -- Build the cache
5540: --
5541: ben_elp_cache.elpehw_writecache
5542: (p_effective_date => p_effective_date,
5543: p_refresh_cache => p_refresh_cache);
5544: --
5545: end if;
5775: p_business_group_id in number,
5776: p_eligy_prfl_id in number,
5777: p_comp_src_cd in varchar2 default null,
5778: p_refresh_cache in boolean default FALSE,
5779: p_inst_set out nocopy ben_elp_cache.g_cache_elpecl_instor,
5780: p_inst_count out nocopy number) is
5781: --
5782: l_proc varchar2(72) := 'elpecl_getcacdets';
5783: l_torrwnum pls_integer;
5802: if g_cache_elpecl_lookup.count = 0 then
5803: --
5804: -- Build the cache
5805: --
5806: ben_elp_cache.elpecl_writecache
5807: (p_effective_date => p_effective_date,
5808: p_refresh_cache => p_refresh_cache);
5809: --
5810: end if;
6037: (p_effective_date in date,
6038: p_business_group_id in number,
6039: p_eligy_prfl_id in number,
6040: p_refresh_cache in boolean default FALSE,
6041: p_inst_set out nocopy ben_elp_cache.g_cache_elpepf_instor,
6042: p_inst_count out nocopy number) is
6043: --
6044: l_proc varchar2(72) := 'elpepf_getcacdets';
6045: l_torrwnum pls_integer;
6064: if g_cache_elpepf_lookup.count = 0 then
6065: --
6066: -- Build the cache
6067: --
6068: ben_elp_cache.elpepf_writecache
6069: (p_effective_date => p_effective_date,
6070: p_refresh_cache => p_refresh_cache);
6071: --
6072: end if;
6282: (p_effective_date in date,
6283: p_business_group_id in number,
6284: p_eligy_prfl_id in number,
6285: p_refresh_cache in boolean default FALSE,
6286: p_inst_set out nocopy ben_elp_cache.g_cache_elpegr_instor,
6287: p_inst_count out nocopy number) is
6288: --
6289: l_proc varchar2(72) := 'elpegr_getcacdets';
6290: l_torrwnum pls_integer;
6309: if g_cache_elpegr_lookup.count = 0 then
6310: --
6311: -- Build the cache
6312: --
6313: ben_elp_cache.elpegr_writecache
6314: (p_effective_date => p_effective_date,
6315: p_refresh_cache => p_refresh_cache);
6316: --
6317: end if;
6527: (p_effective_date in date,
6528: p_business_group_id in number,
6529: p_eligy_prfl_id in number,
6530: p_refresh_cache in boolean default FALSE,
6531: p_inst_set out nocopy ben_elp_cache.g_cache_elpegn_instor,
6532: p_inst_count out nocopy number) is
6533: --
6534: l_proc varchar2(72) := 'elpegn_getcacdets';
6535: l_torrwnum pls_integer;
6554: if g_cache_elpegn_lookup.count = 0 then
6555: --
6556: -- Build the cache
6557: --
6558: ben_elp_cache.elpegn_writecache
6559: (p_effective_date => p_effective_date,
6560: p_refresh_cache => p_refresh_cache);
6561: --
6562: end if;
6769: (p_effective_date in date,
6770: p_business_group_id in number,
6771: p_eligy_prfl_id in number,
6772: p_refresh_cache in boolean default FALSE,
6773: p_inst_set out nocopy ben_elp_cache.g_cache_elpejp_instor,
6774: p_inst_count out nocopy number) is
6775: --
6776: l_proc varchar2(72) := 'elpejp_getcacdets';
6777: l_torrwnum pls_integer;
6796: if g_cache_elpejp_lookup.count = 0 then
6797: --
6798: -- Build the cache
6799: --
6800: ben_elp_cache.elpejp_writecache
6801: (p_effective_date => p_effective_date,
6802: p_refresh_cache => p_refresh_cache);
6803: --
6804: end if;
7014: (p_effective_date in date,
7015: p_business_group_id in number,
7016: p_eligy_prfl_id in number,
7017: p_refresh_cache in boolean default FALSE,
7018: p_inst_set out nocopy ben_elp_cache.g_cache_elpepb_instor,
7019: p_inst_count out nocopy number) is
7020: --
7021: l_proc varchar2(72) := 'elpepb_getcacdets';
7022: l_torrwnum pls_integer;
7041: if g_cache_elpepb_lookup.count = 0 then
7042: --
7043: -- Build the cache
7044: --
7045: ben_elp_cache.elpepb_writecache
7046: (p_effective_date => p_effective_date,
7047: p_refresh_cache => p_refresh_cache);
7048: --
7049: end if;
7258: (p_effective_date in date,
7259: p_business_group_id in number,
7260: p_eligy_prfl_id in number,
7261: p_refresh_cache in boolean default FALSE,
7262: p_inst_set out nocopy ben_elp_cache.g_cache_elpepy_instor,
7263: p_inst_count out nocopy number) is
7264: --
7265: l_proc varchar2(72) := 'elpepy_getcacdets';
7266: l_torrwnum pls_integer;
7285: if g_cache_elpepy_lookup.count = 0 then
7286: --
7287: -- Build the cache
7288: --
7289: ben_elp_cache.elpepy_writecache
7290: (p_effective_date => p_effective_date,
7291: p_refresh_cache => p_refresh_cache);
7292: --
7293: end if;
7503: (p_effective_date in date,
7504: p_business_group_id in number,
7505: p_eligy_prfl_id in number,
7506: p_refresh_cache in boolean default FALSE,
7507: p_inst_set out nocopy ben_elp_cache.g_cache_elpebu_instor,
7508: p_inst_count out nocopy number) is
7509: --
7510: l_proc varchar2(72) := 'elpebu_getcacdets';
7511: l_torrwnum pls_integer;
7530: if g_cache_elpebu_lookup.count = 0 then
7531: --
7532: -- Build the cache
7533: --
7534: ben_elp_cache.elpebu_writecache
7535: (p_effective_date => p_effective_date,
7536: p_refresh_cache => p_refresh_cache);
7537: --
7538: end if;
7748: (p_effective_date in date,
7749: p_business_group_id in number,
7750: p_eligy_prfl_id in number,
7751: p_refresh_cache in boolean default FALSE,
7752: p_inst_set out nocopy ben_elp_cache.g_cache_elpelu_instor,
7753: p_inst_count out nocopy number) is
7754: --
7755: l_proc varchar2(72) := 'elpelu_getcacdets';
7756: l_torrwnum pls_integer;
7775: if g_cache_elpelu_lookup.count = 0 then
7776: --
7777: -- Build the cache
7778: --
7779: ben_elp_cache.elpelu_writecache
7780: (p_effective_date => p_effective_date,
7781: p_refresh_cache => p_refresh_cache);
7782: --
7783: end if;
7995: (p_effective_date in date,
7996: p_business_group_id in number,
7997: p_eligy_prfl_id in number,
7998: p_refresh_cache in boolean default FALSE,
7999: p_inst_set out nocopy ben_elp_cache.g_cache_elpelr_instor,
8000: p_inst_count out nocopy number) is
8001: --
8002: l_proc varchar2(72) := 'elpelr_getcacdets';
8003: l_torrwnum pls_integer;
8022: if g_cache_elpelr_lookup.count = 0 then
8023: --
8024: -- Build the cache
8025: --
8026: ben_elp_cache.elpelr_writecache
8027: (p_effective_date => p_effective_date,
8028: p_refresh_cache => p_refresh_cache);
8029: --
8030: end if;
8253: (p_effective_date in date,
8254: p_business_group_id in number,
8255: p_eligy_prfl_id in number,
8256: p_refresh_cache in boolean default FALSE,
8257: p_inst_set out nocopy ben_elp_cache.g_cache_elpeap_instor,
8258: p_inst_count out nocopy number) is
8259: --
8260: l_proc varchar2(72) := 'elpeap_getcacdets';
8261: l_torrwnum pls_integer;
8280: if g_cache_elpeap_lookup.count = 0 then
8281: --
8282: -- Build the cache
8283: --
8284: ben_elp_cache.elpeap_writecache
8285: (p_effective_date => p_effective_date,
8286: p_refresh_cache => p_refresh_cache);
8287: --
8288: end if;
8512: (p_effective_date in date,
8513: p_business_group_id in number,
8514: p_eligy_prfl_id in number,
8515: p_refresh_cache in boolean default FALSE,
8516: p_inst_set out nocopy ben_elp_cache.g_cache_elpepz_instor,
8517: p_inst_count out nocopy number) is
8518: --
8519: l_proc varchar2(72) := 'elpepz_getcacdets';
8520: l_torrwnum pls_integer;
8539: if g_cache_elpepz_lookup.count = 0 then
8540: --
8541: -- Build the cache
8542: --
8543: ben_elp_cache.elpepz_writecache
8544: (p_effective_date => p_effective_date,
8545: p_refresh_cache => p_refresh_cache);
8546: --
8547: end if;
8757: (p_effective_date in date,
8758: p_business_group_id in number,
8759: p_eligy_prfl_id in number,
8760: p_refresh_cache in boolean default FALSE,
8761: p_inst_set out nocopy ben_elp_cache.g_cache_elpebn_instor,
8762: p_inst_count out nocopy number) is
8763: --
8764: l_proc varchar2(72) := 'elpebn_getcacdets';
8765: l_torrwnum pls_integer;
8784: if g_cache_elpebn_lookup.count = 0 then
8785: --
8786: -- Build the cache
8787: --
8788: ben_elp_cache.elpebn_writecache
8789: (p_effective_date => p_effective_date,
8790: p_refresh_cache => p_refresh_cache);
8791: --
8792: end if;
9008: (p_effective_date in date,
9009: p_business_group_id in number,
9010: p_eligy_prfl_id in number,
9011: p_refresh_cache in boolean default FALSE,
9012: p_inst_set out nocopy ben_elp_cache.g_cache_elpeln_instor,
9013: p_inst_count out nocopy number) is
9014: --
9015: l_proc varchar2(72) := 'elpeln_getcacdets';
9016: l_torrwnum pls_integer;
9035: if g_cache_elpeln_lookup.count = 0 then
9036: --
9037: -- Build the cache
9038: --
9039: ben_elp_cache.elpeln_writecache
9040: (p_effective_date => p_effective_date,
9041: p_refresh_cache => p_refresh_cache);
9042: --
9043: end if;
9245: (p_effective_date in date,
9246: p_business_group_id in number,
9247: p_eligy_prfl_id in number,
9248: p_refresh_cache in boolean default FALSE,
9249: p_inst_set out nocopy ben_elp_cache.g_cache_elpepp_instor,
9250: p_inst_count out nocopy number) is
9251: --
9252: l_proc varchar2(72) := 'elpepp_getcacdets';
9253: l_torrwnum pls_integer;
9272: if g_cache_elpepp_lookup.count = 0 then
9273: --
9274: -- Build the cache
9275: --
9276: ben_elp_cache.elpepp_writecache
9277: (p_effective_date => p_effective_date,
9278: p_refresh_cache => p_refresh_cache);
9279: --
9280: end if;
9485: (p_effective_date in date,
9486: p_business_group_id in number,
9487: p_eligy_prfl_id in number,
9488: p_refresh_cache in boolean default FALSE,
9489: p_inst_set out nocopy ben_elp_cache.g_cache_elpeoy_instor,
9490: p_inst_count out nocopy number) is
9491: --
9492: l_proc varchar2(72) := 'elpeoy_getcacdets';
9493: l_torrwnum pls_integer;
9512: if g_cache_elpeoy_lookup.count = 0 then
9513: --
9514: -- Build the cache
9515: --
9516: ben_elp_cache.elpeoy_writecache
9517: (p_effective_date => p_effective_date,
9518: p_refresh_cache => p_refresh_cache);
9519: --
9520: end if;
9726: (p_effective_date in date,
9727: p_business_group_id in number,
9728: p_eligy_prfl_id in number,
9729: p_refresh_cache in boolean default FALSE,
9730: p_inst_set out nocopy ben_elp_cache.g_cache_elpetd_instor,
9731: p_inst_count out nocopy number) is
9732: --
9733: l_proc varchar2(72) := 'elpetd_getcacdets';
9734: l_torrwnum pls_integer;
9753: if g_cache_elpetd_lookup.count = 0 then
9754: --
9755: -- Build the cache
9756: --
9757: ben_elp_cache.elpetd_writecache
9758: (p_effective_date => p_effective_date,
9759: p_refresh_cache => p_refresh_cache);
9760: --
9761: end if;
9962: (p_effective_date in date,
9963: p_business_group_id in number,
9964: p_eligy_prfl_id in number,
9965: p_refresh_cache in boolean default FALSE,
9966: p_inst_set out nocopy ben_elp_cache.g_cache_elpeno_instor,
9967: p_inst_count out nocopy number) is
9968: --
9969: l_proc varchar2(72) := 'elpeno_getcacdets';
9970: l_torrwnum pls_integer;
9989: if g_cache_elpeno_lookup.count = 0 then
9990: --
9991: -- Build the cache
9992: --
9993: ben_elp_cache.elpeno_writecache
9994: (p_effective_date => p_effective_date,
9995: p_refresh_cache => p_refresh_cache);
9996: --
9997: end if;
10201: (p_effective_date in date,
10202: p_business_group_id in number,
10203: p_eligy_prfl_id in number,
10204: p_refresh_cache in boolean default FALSE,
10205: p_inst_set out nocopy ben_elp_cache.g_cache_elpeep_instor,
10206: p_inst_count out nocopy number) is
10207: --
10208: l_proc varchar2(72) := 'elpeep_getcacdets';
10209: l_torrwnum pls_integer;
10228: if g_cache_elpeep_lookup.count = 0 then
10229: --
10230: -- Build the cache
10231: --
10232: ben_elp_cache.elpeep_writecache
10233: (p_effective_date => p_effective_date,
10234: p_refresh_cache => p_refresh_cache);
10235: --
10236: end if;
10440: (p_effective_date in date,
10441: p_business_group_id in number,
10442: p_eligy_prfl_id in number,
10443: p_refresh_cache in boolean default FALSE,
10444: p_inst_set out nocopy ben_elp_cache.g_cache_elpeei_instor,
10445: p_inst_count out nocopy number) is
10446: --
10447: l_proc varchar2(72) := 'elpeei_getcacdets';
10448: l_torrwnum pls_integer;
10467: if g_cache_elpeei_lookup.count = 0 then
10468: --
10469: -- Build the cache
10470: --
10471: ben_elp_cache.elpeei_writecache
10472: (p_effective_date => p_effective_date,
10473: p_refresh_cache => p_refresh_cache);
10474: --
10475: end if;
10679: (p_effective_date in date,
10680: p_business_group_id in number,
10681: p_eligy_prfl_id in number,
10682: p_refresh_cache in boolean default FALSE,
10683: p_inst_set out nocopy ben_elp_cache.g_cache_elpeeg_instor,
10684: p_inst_count out nocopy number) is
10685: --
10686: l_proc varchar2(72) := 'elpeeg_getcacdets';
10687: l_torrwnum pls_integer;
10706: if g_cache_elpeeg_lookup.count = 0 then
10707: --
10708: -- Build the cache
10709: --
10710: ben_elp_cache.elpeeg_writecache
10711: (p_effective_date => p_effective_date,
10712: p_refresh_cache => p_refresh_cache);
10713: --
10714: end if;
10918: (p_effective_date in date,
10919: p_business_group_id in number,
10920: p_eligy_prfl_id in number,
10921: p_refresh_cache in boolean default FALSE,
10922: p_inst_set out nocopy ben_elp_cache.g_cache_elpedp_instor,
10923: p_inst_count out nocopy number) is
10924: --
10925: l_proc varchar2(72) := 'elpedp_getcacdets';
10926: l_torrwnum pls_integer;
10945: if g_cache_elpedp_lookup.count = 0 then
10946: --
10947: -- Build the cache
10948: --
10949: ben_elp_cache.elpedp_writecache
10950: (p_effective_date => p_effective_date,
10951: p_refresh_cache => p_refresh_cache);
10952: --
10953: end if;
11163: (p_effective_date in date,
11164: p_business_group_id in number,
11165: p_eligy_prfl_id in number,
11166: p_refresh_cache in boolean default FALSE,
11167: p_inst_set out nocopy ben_elp_cache.g_cache_elpelv_instor,
11168: p_inst_count out nocopy number) is
11169: --
11170: l_proc varchar2(72) := 'elpelv_getcacdets';
11171: l_torrwnum pls_integer;
11190: if g_cache_elpelv_lookup.count = 0 then
11191: --
11192: -- Build the cache
11193: --
11194: ben_elp_cache.elpelv_writecache
11195: (p_effective_date => p_effective_date,
11196: p_refresh_cache => p_refresh_cache);
11197: --
11198: end if;
11399: (p_effective_date in date,
11400: p_business_group_id in number,
11401: p_eligy_prfl_id in number,
11402: p_refresh_cache in boolean default FALSE,
11403: p_inst_set out nocopy ben_elp_cache.g_cache_elpeom_instor,
11404: p_inst_count out nocopy number) is
11405: --
11406: l_proc varchar2(72) := 'elpeom_getcacdets';
11407: l_torrwnum pls_integer;
11426: if g_cache_elpeom_lookup.count = 0 then
11427: --
11428: -- Build the cache
11429: --
11430: ben_elp_cache.elpeom_writecache
11431: (p_effective_date => p_effective_date,
11432: p_refresh_cache => p_refresh_cache);
11433: --
11434: end if;
11637: (p_effective_date in date,
11638: p_business_group_id in number,
11639: p_eligy_prfl_id in number,
11640: p_refresh_cache in boolean default FALSE,
11641: p_inst_set out nocopy ben_elp_cache.g_cache_elpeai_instor,
11642: p_inst_count out nocopy number) is
11643: --
11644: l_proc varchar2(72) := 'elpeai_getcacdets';
11645: l_torrwnum pls_integer;
11664: if g_cache_elpeai_lookup.count = 0 then
11665: --
11666: -- Build the cache
11667: --
11668: ben_elp_cache.elpeai_writecache
11669: (p_effective_date => p_effective_date,
11670: p_refresh_cache => p_refresh_cache);
11671: --
11672: end if;
11875: (p_effective_date in date,
11876: p_business_group_id in number,
11877: p_eligy_prfl_id in number,
11878: p_refresh_cache in boolean default FALSE,
11879: p_inst_set out nocopy ben_elp_cache.g_cache_elpedi_instor,
11880: p_inst_count out nocopy number) is
11881: --
11882: l_proc varchar2(72) := 'elpedi_getcacdets';
11883: l_torrwnum pls_integer;
11902: if g_cache_elpedi_lookup.count = 0 then
11903: --
11904: -- Build the cache
11905: --
11906: ben_elp_cache.elpedi_writecache
11907: (p_effective_date => p_effective_date,
11908: p_refresh_cache => p_refresh_cache);
11909: --
11910: end if;
12115: (p_effective_date in date,
12116: p_business_group_id in number,
12117: p_eligy_prfl_id in number,
12118: p_refresh_cache in boolean default FALSE,
12119: p_inst_set out nocopy ben_elp_cache.g_cache_elpeet_instor,
12120: p_inst_count out nocopy number) is
12121: --
12122: l_proc varchar2(72) := 'elpeet_getcacdets';
12123: l_torrwnum pls_integer;
12142: if g_cache_elpeet_lookup.count = 0 then
12143: --
12144: -- Build the cache
12145: --
12146: ben_elp_cache.elpeet_writecache
12147: (p_effective_date => p_effective_date,
12148: p_refresh_cache => p_refresh_cache);
12149: --
12150: end if;
12355: (p_effective_date in date,
12356: p_business_group_id in number,
12357: p_eligy_prfl_id in number,
12358: p_refresh_cache in boolean default FALSE,
12359: p_inst_set out nocopy ben_elp_cache.g_cache_elpedt_instor,
12360: p_inst_count out nocopy number) is
12361: --
12362: l_proc varchar2(72) := 'elpedt_getcacdets';
12363: l_torrwnum pls_integer;
12382: if g_cache_elpedt_lookup.count = 0 then
12383: --
12384: -- Build the cache
12385: --
12386: ben_elp_cache.elpedt_writecache
12387: (p_effective_date => p_effective_date,
12388: p_refresh_cache => p_refresh_cache);
12389: --
12390: end if;
12593: (p_effective_date in date,
12594: p_business_group_id in number,
12595: p_eligy_prfl_id in number,
12596: p_refresh_cache in boolean default FALSE,
12597: p_inst_set out nocopy ben_elp_cache.g_cache_elpedg_instor,
12598: p_inst_count out nocopy number) is
12599: --
12600: l_proc varchar2(72) := 'elpedg_getcacdets';
12601: l_torrwnum pls_integer;
12620: if g_cache_elpedg_lookup.count = 0 then
12621: --
12622: -- Build the cache
12623: --
12624: ben_elp_cache.elpedg_writecache
12625: (p_effective_date => p_effective_date,
12626: p_refresh_cache => p_refresh_cache);
12627: --
12628: end if;
12839: (p_effective_date in date,
12840: p_business_group_id in number,
12841: p_eligy_prfl_id in number,
12842: p_refresh_cache in boolean default FALSE,
12843: p_inst_set out nocopy ben_elp_cache.g_cache_elpecq_instor,
12844: p_inst_count out nocopy number) is
12845: --
12846: l_proc varchar2(72) := 'elpecq_getcacdets';
12847: l_torrwnum pls_integer;
12866: if g_cache_elpecq_lookup.count = 0 then
12867: --
12868: -- Build the cache
12869: --
12870: ben_elp_cache.elpecq_writecache
12871: (p_effective_date => p_effective_date,
12872: p_refresh_cache => p_refresh_cache);
12873: --
12874: end if;
13640: end;
13641: --
13642: end clear_down_cache;
13643: --
13644: end ben_elp_cache;
13645: --