8: g_hash_jump number := ben_hash_utility.get_hash_jump;
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
14: g_cobcep_cached boolean := FALSE;
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: --
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;
24: g_cache_elpepg_inst ben_elp_cache.g_cache_elpepg_instor;
25: --
26: -- eligibility profile rule by eligibility profile
27: --
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;
29: g_cache_elperl_inst ben_elp_cache.g_cache_elperl_instor;
30: --
31: -- eligibility profile assignment status type by eligibility profile
32: --
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;
34: g_cache_elpees_inst ben_elp_cache.g_cache_elpees_instor;
35: --
36: -- eligibility profile length of service by eligibility profile
37: --
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;
39: g_cache_elpels_inst ben_elp_cache.g_cache_elpels_instor;
40: --
41: -- eligibility profile age/los combination by eligibility profile
42: --
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;
44: g_cache_elpecp_inst ben_elp_cache.g_cache_elpecp_instor;
45: --
46: -- eligibility profile location by eligibility profile
47: --
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;
49: g_cache_elpewl_inst ben_elp_cache.g_cache_elpewl_instor;
50: --
51: -- eligibility profile assignment set by eligibility profile
52: --
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;
54: g_cache_elpean_inst ben_elp_cache.g_cache_elpean_instor;
55: --
56: -- eligibility profile organization by eligibility profile
57: --
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;
59: g_cache_elpeou_inst ben_elp_cache.g_cache_elpeou_instor;
60: --
61: -- eligibility profile pay frequency by eligibility profile
62: --
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;
64: g_cache_elpehs_inst ben_elp_cache.g_cache_elpehs_instor;
65: --
66: -- eligibility profile full/part time by eligibility profile
67: --
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;
69: g_cache_elpefp_inst ben_elp_cache.g_cache_elpefp_instor;
70: --
71: -- eligibility profile scheduled hours by eligibility profile
72: --
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;
74: g_cache_elpesh_inst ben_elp_cache.g_cache_elpesh_instor;
75: --
76: -- eligibility profile compensation level by eligibility profile
77: --
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;
79: g_cache_elpecl_inst ben_elp_cache.g_cache_elpecl_instor;
80: --
81: -- eligibility profile hours worked by eligibility profile
82: --
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;
84: g_cache_elpehw_inst ben_elp_cache.g_cache_elpehw_instor;
85: --
86: -- eligibility profile full time by eligibility profile
87: --
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;
89: g_cache_elpepf_inst ben_elp_cache.g_cache_elpepf_instor;
90: --
91: -- eligibility profile grade by eligibility profile
92: --
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;
94: g_cache_elpegr_inst ben_elp_cache.g_cache_elpegr_instor;
95: --
96: -- eligibility profile sex by eligibility profile
97: --
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;
99: g_cache_elpegn_inst ben_elp_cache.g_cache_elpegn_instor;
100: --
101: -- eligibility profile job by eligibility profile
102: --
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;
104: g_cache_elpejp_inst ben_elp_cache.g_cache_elpejp_instor;
105: --
106: -- eligibility profile pay basis by eligibility profile
107: --
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;
109: g_cache_elpepb_inst ben_elp_cache.g_cache_elpepb_instor;
110: --
111: -- eligibility profile service area by eligibility profile
112: --
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;
114: g_cache_elpesa_inst ben_elp_cache.g_cache_elpesa_instor;
115: --
116: -- eligibility profile payroll by eligibility profile
117: --
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;
119: g_cache_elpepy_inst ben_elp_cache.g_cache_elpepy_instor;
120: --
121: -- eligibility profile bargaining unit by eligibility profile
122: --
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;
124: g_cache_elpebu_inst ben_elp_cache.g_cache_elpebu_instor;
125: --
126: -- eligibility profile labour union membership by eligibility profile
127: --
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;
129: g_cache_elpelu_inst ben_elp_cache.g_cache_elpelu_instor;
130: --
131: -- eligibility profile leave of absence reason by eligibility profile
132: --
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;
134: g_cache_elpelr_inst ben_elp_cache.g_cache_elpelr_instor;
135: --
136: -- eligibility profile age details by eligibility profile
137: --
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;
139: g_cache_elpeap_inst ben_elp_cache.g_cache_elpeap_instor;
140: --
141: -- eligibility profile zip code range by eligibility profile
142: --
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;
144: g_cache_elpepz_inst ben_elp_cache.g_cache_elpepz_instor;
145: --
146: -- eligibility profile benefits group by eligibility profile
147: --
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;
149: g_cache_elpebn_inst ben_elp_cache.g_cache_elpebn_instor;
150: --
151: -- eligibility profile legal entity by eligibility profile
152: --
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;
154: g_cache_elpeln_inst ben_elp_cache.g_cache_elpeln_instor;
155: --
156: -- eligibility profile other plan by eligibility profile
157: --
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;
159: g_cache_elpepp_inst ben_elp_cache.g_cache_elpepp_instor;
160: --
161: -- eligibility profile elig other ptip by eligibility profile
162: --
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;
164: g_cache_elpeoy_inst ben_elp_cache.g_cache_elpeoy_instor;
165: --
166: -- eligibility profile no other coverage participate by eligibility profile
167: --
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;
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: --
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;
174: g_cache_elpeno_inst ben_elp_cache.g_cache_elpeno_instor;
175: --
176: -- eligibility profile enrolled another plan by eligibility profile
177: --
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;
179: g_cache_elpeep_inst ben_elp_cache.g_cache_elpeep_instor;
180: --
181: -- eligibility profile enrolled in another oipl by eligibility profile
182: --
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;
184: g_cache_elpeei_inst ben_elp_cache.g_cache_elpeei_instor;
185: --
186: -- eligibility profile enrolled in another pgm by eligibility profile
187: --
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;
189: g_cache_elpeeg_inst ben_elp_cache.g_cache_elpeeg_instor;
190: --
191: -- eligibility profile dependent covered other plan by eligibility profile
192: --
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;
194: g_cache_elpedp_inst ben_elp_cache.g_cache_elpedp_instor;
195: --
196: -- eligibility profile leaving reason participate by eligibility profile
197: --
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;
199: g_cache_elpelv_inst ben_elp_cache.g_cache_elpelv_instor;
200: --
201: -- eligibility profile opted for medicare participate by eligibility profile
202: --
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;
204: g_cache_elpeom_inst ben_elp_cache.g_cache_elpeom_instor;
205: --
206: -- eligibility profile enrolled in another plip by eligibility profile
207: --
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;
209: g_cache_elpeai_inst ben_elp_cache.g_cache_elpeai_instor;
210: --
211: -- eligibility profile dependent covered othr plip by eligibility profile
212: --
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;
214: g_cache_elpedi_inst ben_elp_cache.g_cache_elpedi_instor;
215: --
216: -- eligibility profile enrolled another ptip by eligibility profile
217: --
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;
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: --
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;
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: --
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;
229: g_cache_elpedg_inst ben_elp_cache.g_cache_elpedg_instor;
230: --
231: -- eligibility profile cobra qualified beneficiary by eligibility profile
232: --
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;
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;
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();
239: g_copcep_odcached pls_integer := 0;
240: --
1490: is
1491: --
1492: l_proc varchar2(72) := 'elpelc_getdets';
1493: --
1494: l_instcolnm_set ben_cache.InstColNmType;
1495: l_tabdet_set ben_cache.TabDetType;
1496: --
1497: l_torrwnum pls_integer;
1498: l_insttorrw_num pls_integer;
1491: --
1492: l_proc varchar2(72) := 'elpelc_getdets';
1493: --
1494: l_instcolnm_set ben_cache.InstColNmType;
1495: l_tabdet_set ben_cache.TabDetType;
1496: --
1497: l_torrwnum pls_integer;
1498: l_insttorrw_num pls_integer;
1499: l_index pls_integer;
1676: l_instcolnm_set(l_instcolnm_num).col_type := 'SELECT';
1677: l_instcolnm_num := l_instcolnm_num+1;
1678: --
1679: end if;
1680: ben_cache.Write_BGP_Cache
1681: (p_mastertab_name => l_mastertab_name
1682: ,p_masterpkcol_name => l_masterpkcol_name
1683: ,p_tabdet_set => l_tabdet_set
1684: ,p_table1_name => l_table1_name