[Home] [Help]
PACKAGE: APPS.OKS_ENTITLEMENTS_WEB_W
Source
1 package oks_entitlements_web_w AUTHID CURRENT_USER as
2 /* $Header: OKSWENWS.pls 120.0 2005/05/25 18:14:51 appldev noship $ */
3 procedure rosetta_table_copy_in_p19(t out nocopy oks_entitlements_web.output_tbl_contract, a0 JTF_VARCHAR2_TABLE_200
4 , a1 JTF_VARCHAR2_TABLE_200
5 , a2 JTF_VARCHAR2_TABLE_100
6 , a3 JTF_VARCHAR2_TABLE_100
7 , a4 JTF_VARCHAR2_TABLE_100
8 , a5 JTF_VARCHAR2_TABLE_100
9 , a6 JTF_VARCHAR2_TABLE_300
10 , a7 JTF_VARCHAR2_TABLE_2000
11 , a8 JTF_DATE_TABLE
12 , a9 JTF_DATE_TABLE
13 , a10 JTF_DATE_TABLE
14 , a11 JTF_NUMBER_TABLE
15 , a12 JTF_VARCHAR2_TABLE_100
16 );
17 procedure rosetta_table_copy_out_p19(t oks_entitlements_web.output_tbl_contract, a0 out nocopy JTF_VARCHAR2_TABLE_200
18 , a1 out nocopy JTF_VARCHAR2_TABLE_200
19 , a2 out nocopy JTF_VARCHAR2_TABLE_100
20 , a3 out nocopy JTF_VARCHAR2_TABLE_100
21 , a4 out nocopy JTF_VARCHAR2_TABLE_100
22 , a5 out nocopy JTF_VARCHAR2_TABLE_100
23 , a6 out nocopy JTF_VARCHAR2_TABLE_300
24 , a7 out nocopy JTF_VARCHAR2_TABLE_2000
25 , a8 out nocopy JTF_DATE_TABLE
26 , a9 out nocopy JTF_DATE_TABLE
27 , a10 out nocopy JTF_DATE_TABLE
28 , a11 out nocopy JTF_NUMBER_TABLE
29 , a12 out nocopy JTF_VARCHAR2_TABLE_100
30 );
31
32 procedure rosetta_table_copy_in_p21(t out nocopy oks_entitlements_web.account_all_id_tbl_type, a0 JTF_NUMBER_TABLE
33 );
34 procedure rosetta_table_copy_out_p21(t oks_entitlements_web.account_all_id_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
35 );
36
37 procedure rosetta_table_copy_in_p23(t out nocopy oks_entitlements_web.party_sites_tbl_type, a0 JTF_NUMBER_TABLE
38 , a1 JTF_VARCHAR2_TABLE_100
39 , a2 JTF_VARCHAR2_TABLE_300
40 , a3 JTF_VARCHAR2_TABLE_300
41 );
42 procedure rosetta_table_copy_out_p23(t oks_entitlements_web.party_sites_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
43 , a1 out nocopy JTF_VARCHAR2_TABLE_100
44 , a2 out nocopy JTF_VARCHAR2_TABLE_300
45 , a3 out nocopy JTF_VARCHAR2_TABLE_300
46 );
47
48 procedure rosetta_table_copy_in_p25(t out nocopy oks_entitlements_web.party_items_tbl_type, a0 JTF_NUMBER_TABLE
49 , a1 JTF_NUMBER_TABLE
50 , a2 JTF_VARCHAR2_TABLE_300
51 , a3 JTF_VARCHAR2_TABLE_300
52 );
53 procedure rosetta_table_copy_out_p25(t oks_entitlements_web.party_items_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
54 , a1 out nocopy JTF_NUMBER_TABLE
55 , a2 out nocopy JTF_VARCHAR2_TABLE_300
56 , a3 out nocopy JTF_VARCHAR2_TABLE_300
57 );
58
59 procedure rosetta_table_copy_in_p27(t out nocopy oks_entitlements_web.party_systems_tbl_type, a0 JTF_NUMBER_TABLE
60 , a1 JTF_VARCHAR2_TABLE_100
61 , a2 JTF_VARCHAR2_TABLE_300
62 , a3 JTF_VARCHAR2_TABLE_300
63 );
64 procedure rosetta_table_copy_out_p27(t oks_entitlements_web.party_systems_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
65 , a1 out nocopy JTF_VARCHAR2_TABLE_100
66 , a2 out nocopy JTF_VARCHAR2_TABLE_300
67 , a3 out nocopy JTF_VARCHAR2_TABLE_300
68 );
69
70 procedure rosetta_table_copy_in_p29(t out nocopy oks_entitlements_web.party_products_tbl_type, a0 JTF_NUMBER_TABLE
71 , a1 JTF_VARCHAR2_TABLE_100
72 , a2 JTF_VARCHAR2_TABLE_300
73 , a3 JTF_VARCHAR2_TABLE_300
74 );
75 procedure rosetta_table_copy_out_p29(t oks_entitlements_web.party_products_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
76 , a1 out nocopy JTF_VARCHAR2_TABLE_100
77 , a2 out nocopy JTF_VARCHAR2_TABLE_300
78 , a3 out nocopy JTF_VARCHAR2_TABLE_300
79 );
80
81 procedure rosetta_table_copy_in_p31(t out nocopy oks_entitlements_web.contract_cat_tbl_type, a0 JTF_VARCHAR2_TABLE_100
82 , a1 JTF_VARCHAR2_TABLE_100
83 );
84 procedure rosetta_table_copy_out_p31(t oks_entitlements_web.contract_cat_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
85 , a1 out nocopy JTF_VARCHAR2_TABLE_100
86 );
87
88 procedure rosetta_table_copy_in_p33(t out nocopy oks_entitlements_web.contract_status_tbl_type, a0 JTF_VARCHAR2_TABLE_100
89 , a1 JTF_VARCHAR2_TABLE_100
90 );
91 procedure rosetta_table_copy_out_p33(t oks_entitlements_web.contract_status_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
92 , a1 out nocopy JTF_VARCHAR2_TABLE_100
93 );
94
95 procedure rosetta_table_copy_in_p37(t out nocopy oks_entitlements_web.party_tbl_type, a0 JTF_NUMBER_TABLE
96 , a1 JTF_VARCHAR2_TABLE_100
97 , a2 JTF_VARCHAR2_TABLE_100
98 , a3 JTF_VARCHAR2_TABLE_400
99 , a4 JTF_VARCHAR2_TABLE_100
100 , a5 JTF_VARCHAR2_TABLE_100
101 , a6 JTF_VARCHAR2_TABLE_100
102 );
103 procedure rosetta_table_copy_out_p37(t oks_entitlements_web.party_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
104 , a1 out nocopy JTF_VARCHAR2_TABLE_100
105 , a2 out nocopy JTF_VARCHAR2_TABLE_100
106 , a3 out nocopy JTF_VARCHAR2_TABLE_400
107 , a4 out nocopy JTF_VARCHAR2_TABLE_100
108 , a5 out nocopy JTF_VARCHAR2_TABLE_100
109 , a6 out nocopy JTF_VARCHAR2_TABLE_100
110 );
111
112 procedure rosetta_table_copy_in_p39(t out nocopy oks_entitlements_web.line_tbl_type, a0 JTF_NUMBER_TABLE
113 , a1 JTF_NUMBER_TABLE
114 , a2 JTF_DATE_TABLE
115 , a3 JTF_DATE_TABLE
116 , a4 JTF_VARCHAR2_TABLE_100
117 , a5 JTF_VARCHAR2_TABLE_100
118 , a6 JTF_VARCHAR2_TABLE_200
119 , a7 JTF_VARCHAR2_TABLE_300
120 , a8 JTF_VARCHAR2_TABLE_500
121 , a9 JTF_VARCHAR2_TABLE_500
122 , a10 JTF_VARCHAR2_TABLE_2000
123 , a11 JTF_VARCHAR2_TABLE_400
124 , a12 JTF_VARCHAR2_TABLE_400
125 , a13 JTF_NUMBER_TABLE
126 , a14 JTF_NUMBER_TABLE
127 , a15 JTF_VARCHAR2_TABLE_200
128 , a16 JTF_VARCHAR2_TABLE_100
129 , a17 JTF_VARCHAR2_TABLE_400
130 , a18 JTF_VARCHAR2_TABLE_300
131 , a19 JTF_VARCHAR2_TABLE_100
132 , a20 JTF_VARCHAR2_TABLE_100
133 , a21 JTF_VARCHAR2_TABLE_400
134 , a22 JTF_VARCHAR2_TABLE_300
135 , a23 JTF_VARCHAR2_TABLE_100
136 );
137 procedure rosetta_table_copy_out_p39(t oks_entitlements_web.line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
138 , a1 out nocopy JTF_NUMBER_TABLE
139 , a2 out nocopy JTF_DATE_TABLE
140 , a3 out nocopy JTF_DATE_TABLE
141 , a4 out nocopy JTF_VARCHAR2_TABLE_100
142 , a5 out nocopy JTF_VARCHAR2_TABLE_100
143 , a6 out nocopy JTF_VARCHAR2_TABLE_200
144 , a7 out nocopy JTF_VARCHAR2_TABLE_300
145 , a8 out nocopy JTF_VARCHAR2_TABLE_500
146 , a9 out nocopy JTF_VARCHAR2_TABLE_500
147 , a10 out nocopy JTF_VARCHAR2_TABLE_2000
148 , a11 out nocopy JTF_VARCHAR2_TABLE_400
149 , a12 out nocopy JTF_VARCHAR2_TABLE_400
150 , a13 out nocopy JTF_NUMBER_TABLE
151 , a14 out nocopy JTF_NUMBER_TABLE
152 , a15 out nocopy JTF_VARCHAR2_TABLE_200
153 , a16 out nocopy JTF_VARCHAR2_TABLE_100
154 , a17 out nocopy JTF_VARCHAR2_TABLE_400
155 , a18 out nocopy JTF_VARCHAR2_TABLE_300
156 , a19 out nocopy JTF_VARCHAR2_TABLE_100
157 , a20 out nocopy JTF_VARCHAR2_TABLE_100
158 , a21 out nocopy JTF_VARCHAR2_TABLE_400
159 , a22 out nocopy JTF_VARCHAR2_TABLE_300
160 , a23 out nocopy JTF_VARCHAR2_TABLE_100
161 );
162
163 procedure rosetta_table_copy_in_p41(t out nocopy oks_entitlements_web.party_contact_tbl_type, a0 JTF_NUMBER_TABLE
164 , a1 JTF_VARCHAR2_TABLE_100
165 , a2 JTF_VARCHAR2_TABLE_100
166 , a3 JTF_VARCHAR2_TABLE_100
167 , a4 JTF_DATE_TABLE
168 , a5 JTF_DATE_TABLE
169 , a6 JTF_VARCHAR2_TABLE_400
170 , a7 JTF_VARCHAR2_TABLE_100
171 , a8 JTF_VARCHAR2_TABLE_100
172 );
173 procedure rosetta_table_copy_out_p41(t oks_entitlements_web.party_contact_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
174 , a1 out nocopy JTF_VARCHAR2_TABLE_100
175 , a2 out nocopy JTF_VARCHAR2_TABLE_100
176 , a3 out nocopy JTF_VARCHAR2_TABLE_100
177 , a4 out nocopy JTF_DATE_TABLE
178 , a5 out nocopy JTF_DATE_TABLE
179 , a6 out nocopy JTF_VARCHAR2_TABLE_400
180 , a7 out nocopy JTF_VARCHAR2_TABLE_100
181 , a8 out nocopy JTF_VARCHAR2_TABLE_100
182 );
183
184 procedure rosetta_table_copy_in_p43(t out nocopy oks_entitlements_web.pty_cntct_dtls_tbl_type, a0 JTF_VARCHAR2_TABLE_100
185 , a1 JTF_VARCHAR2_TABLE_100
186 , a2 JTF_VARCHAR2_TABLE_2000
187 , a3 JTF_VARCHAR2_TABLE_100
188 , a4 JTF_VARCHAR2_TABLE_100
189 , a5 JTF_VARCHAR2_TABLE_100
190 , a6 JTF_VARCHAR2_TABLE_100
191 , a7 JTF_VARCHAR2_TABLE_100
192 );
193 procedure rosetta_table_copy_out_p43(t oks_entitlements_web.pty_cntct_dtls_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
194 , a1 out nocopy JTF_VARCHAR2_TABLE_100
195 , a2 out nocopy JTF_VARCHAR2_TABLE_2000
196 , a3 out nocopy JTF_VARCHAR2_TABLE_100
197 , a4 out nocopy JTF_VARCHAR2_TABLE_100
198 , a5 out nocopy JTF_VARCHAR2_TABLE_100
199 , a6 out nocopy JTF_VARCHAR2_TABLE_100
200 , a7 out nocopy JTF_VARCHAR2_TABLE_100
201 );
202
203 procedure rosetta_table_copy_in_p46(t out nocopy oks_entitlements_web.covered_level_tbl_type, a0 JTF_VARCHAR2_TABLE_500
204 , a1 JTF_VARCHAR2_TABLE_500
205 , a2 JTF_VARCHAR2_TABLE_500
206 , a3 JTF_DATE_TABLE
207 , a4 JTF_DATE_TABLE
208 , a5 JTF_NUMBER_TABLE
209 , a6 JTF_VARCHAR2_TABLE_500
210 , a7 JTF_VARCHAR2_TABLE_500
211 , a8 JTF_VARCHAR2_TABLE_500
212 );
213 procedure rosetta_table_copy_out_p46(t oks_entitlements_web.covered_level_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_500
214 , a1 out nocopy JTF_VARCHAR2_TABLE_500
215 , a2 out nocopy JTF_VARCHAR2_TABLE_500
216 , a3 out nocopy JTF_DATE_TABLE
217 , a4 out nocopy JTF_DATE_TABLE
218 , a5 out nocopy JTF_NUMBER_TABLE
219 , a6 out nocopy JTF_VARCHAR2_TABLE_500
220 , a7 out nocopy JTF_VARCHAR2_TABLE_500
221 , a8 out nocopy JTF_VARCHAR2_TABLE_500
222 );
223
224 procedure rosetta_table_copy_in_p48(t out nocopy oks_entitlements_web.cust_contacts_tbl_type, a0 JTF_VARCHAR2_TABLE_500
225 , a1 JTF_VARCHAR2_TABLE_500
226 , a2 JTF_VARCHAR2_TABLE_500
227 , a3 JTF_DATE_TABLE
228 , a4 JTF_DATE_TABLE
229 );
230 procedure rosetta_table_copy_out_p48(t oks_entitlements_web.cust_contacts_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_500
231 , a1 out nocopy JTF_VARCHAR2_TABLE_500
232 , a2 out nocopy JTF_VARCHAR2_TABLE_500
233 , a3 out nocopy JTF_DATE_TABLE
234 , a4 out nocopy JTF_DATE_TABLE
235 );
236
237 procedure rosetta_table_copy_in_p51(t out nocopy oks_entitlements_web.bus_proc_tbl_type, a0 JTF_NUMBER_TABLE
238 , a1 JTF_NUMBER_TABLE
239 , a2 JTF_VARCHAR2_TABLE_500
240 , a3 JTF_VARCHAR2_TABLE_500
241 , a4 JTF_VARCHAR2_TABLE_500
242 , a5 JTF_VARCHAR2_TABLE_500
243 );
244 procedure rosetta_table_copy_out_p51(t oks_entitlements_web.bus_proc_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
245 , a1 out nocopy JTF_NUMBER_TABLE
246 , a2 out nocopy JTF_VARCHAR2_TABLE_500
247 , a3 out nocopy JTF_VARCHAR2_TABLE_500
248 , a4 out nocopy JTF_VARCHAR2_TABLE_500
249 , a5 out nocopy JTF_VARCHAR2_TABLE_500
250 );
251
252 procedure rosetta_table_copy_in_p54(t out nocopy oks_entitlements_web.coverage_times_tbl_type, a0 JTF_VARCHAR2_TABLE_100
253 , a1 JTF_VARCHAR2_TABLE_100
254 , a2 JTF_VARCHAR2_TABLE_100
255 );
256 procedure rosetta_table_copy_out_p54(t oks_entitlements_web.coverage_times_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
257 , a1 out nocopy JTF_VARCHAR2_TABLE_100
258 , a2 out nocopy JTF_VARCHAR2_TABLE_100
259 );
260
261 procedure rosetta_table_copy_in_p56(t out nocopy oks_entitlements_web.reaction_times_tbl_type, a0 JTF_VARCHAR2_TABLE_500
262 , a1 JTF_VARCHAR2_TABLE_500
263 , a2 JTF_VARCHAR2_TABLE_100
264 , a3 JTF_VARCHAR2_TABLE_100
265 , a4 JTF_VARCHAR2_TABLE_100
266 , a5 JTF_VARCHAR2_TABLE_100
267 , a6 JTF_VARCHAR2_TABLE_100
268 , a7 JTF_VARCHAR2_TABLE_100
269 , a8 JTF_VARCHAR2_TABLE_100
270 , a9 JTF_VARCHAR2_TABLE_100
271 , a10 JTF_VARCHAR2_TABLE_100
272 );
273 procedure rosetta_table_copy_out_p56(t oks_entitlements_web.reaction_times_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_500
274 , a1 out nocopy JTF_VARCHAR2_TABLE_500
275 , a2 out nocopy JTF_VARCHAR2_TABLE_100
276 , a3 out nocopy JTF_VARCHAR2_TABLE_100
277 , a4 out nocopy JTF_VARCHAR2_TABLE_100
278 , a5 out nocopy JTF_VARCHAR2_TABLE_100
279 , a6 out nocopy JTF_VARCHAR2_TABLE_100
280 , a7 out nocopy JTF_VARCHAR2_TABLE_100
281 , a8 out nocopy JTF_VARCHAR2_TABLE_100
282 , a9 out nocopy JTF_VARCHAR2_TABLE_100
283 , a10 out nocopy JTF_VARCHAR2_TABLE_100
284 );
285
286 procedure rosetta_table_copy_in_p58(t out nocopy oks_entitlements_web.resolution_times_tbl_type, a0 JTF_VARCHAR2_TABLE_500
287 , a1 JTF_VARCHAR2_TABLE_500
288 , a2 JTF_VARCHAR2_TABLE_100
289 , a3 JTF_VARCHAR2_TABLE_100
290 , a4 JTF_VARCHAR2_TABLE_100
291 , a5 JTF_VARCHAR2_TABLE_100
292 , a6 JTF_VARCHAR2_TABLE_100
293 , a7 JTF_VARCHAR2_TABLE_100
294 , a8 JTF_VARCHAR2_TABLE_100
295 , a9 JTF_VARCHAR2_TABLE_100
296 , a10 JTF_VARCHAR2_TABLE_100
297 );
298 procedure rosetta_table_copy_out_p58(t oks_entitlements_web.resolution_times_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_500
299 , a1 out nocopy JTF_VARCHAR2_TABLE_500
300 , a2 out nocopy JTF_VARCHAR2_TABLE_100
301 , a3 out nocopy JTF_VARCHAR2_TABLE_100
302 , a4 out nocopy JTF_VARCHAR2_TABLE_100
303 , a5 out nocopy JTF_VARCHAR2_TABLE_100
304 , a6 out nocopy JTF_VARCHAR2_TABLE_100
305 , a7 out nocopy JTF_VARCHAR2_TABLE_100
306 , a8 out nocopy JTF_VARCHAR2_TABLE_100
307 , a9 out nocopy JTF_VARCHAR2_TABLE_100
308 , a10 out nocopy JTF_VARCHAR2_TABLE_100
309 );
310
311 procedure rosetta_table_copy_in_p60(t out nocopy oks_entitlements_web.pref_resource_tbl_type, a0 JTF_VARCHAR2_TABLE_100
312 , a1 JTF_VARCHAR2_TABLE_400
313 );
314 procedure rosetta_table_copy_out_p60(t oks_entitlements_web.pref_resource_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
315 , a1 out nocopy JTF_VARCHAR2_TABLE_400
316 );
317
318 procedure rosetta_table_copy_in_p62(t out nocopy oks_entitlements_web.bus_proc_bil_typ_tbl_type, a0 JTF_VARCHAR2_TABLE_500
319 , a1 JTF_VARCHAR2_TABLE_500
320 , a2 JTF_VARCHAR2_TABLE_500
321 , a3 JTF_VARCHAR2_TABLE_500
322 , a4 JTF_VARCHAR2_TABLE_100
323 , a5 JTF_VARCHAR2_TABLE_500
324 , a6 JTF_VARCHAR2_TABLE_500
325 );
326 procedure rosetta_table_copy_out_p62(t oks_entitlements_web.bus_proc_bil_typ_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_500
327 , a1 out nocopy JTF_VARCHAR2_TABLE_500
328 , a2 out nocopy JTF_VARCHAR2_TABLE_500
329 , a3 out nocopy JTF_VARCHAR2_TABLE_500
330 , a4 out nocopy JTF_VARCHAR2_TABLE_100
331 , a5 out nocopy JTF_VARCHAR2_TABLE_500
332 , a6 out nocopy JTF_VARCHAR2_TABLE_500
333 );
334
335 procedure rosetta_table_copy_in_p65(t out nocopy oks_entitlements_web.covered_prods_tbl_type, a0 JTF_VARCHAR2_TABLE_500
336 , a1 JTF_VARCHAR2_TABLE_500
337 , a2 JTF_VARCHAR2_TABLE_2000
338 , a3 JTF_VARCHAR2_TABLE_500
339 , a4 JTF_VARCHAR2_TABLE_500
340 , a5 JTF_VARCHAR2_TABLE_500
341 , a6 JTF_VARCHAR2_TABLE_500
342 , a7 JTF_VARCHAR2_TABLE_500
343 , a8 JTF_VARCHAR2_TABLE_500
344 , a9 JTF_VARCHAR2_TABLE_500
345 , a10 JTF_VARCHAR2_TABLE_500
346 , a11 JTF_VARCHAR2_TABLE_500
347 , a12 JTF_VARCHAR2_TABLE_500
348 , a13 JTF_VARCHAR2_TABLE_500
349 , a14 JTF_VARCHAR2_TABLE_500
350 , a15 JTF_VARCHAR2_TABLE_2000
351 , a16 JTF_VARCHAR2_TABLE_2000
352 );
353 procedure rosetta_table_copy_out_p65(t oks_entitlements_web.covered_prods_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_500
354 , a1 out nocopy JTF_VARCHAR2_TABLE_500
355 , a2 out nocopy JTF_VARCHAR2_TABLE_2000
356 , a3 out nocopy JTF_VARCHAR2_TABLE_500
357 , a4 out nocopy JTF_VARCHAR2_TABLE_500
358 , a5 out nocopy JTF_VARCHAR2_TABLE_500
359 , a6 out nocopy JTF_VARCHAR2_TABLE_500
360 , a7 out nocopy JTF_VARCHAR2_TABLE_500
361 , a8 out nocopy JTF_VARCHAR2_TABLE_500
362 , a9 out nocopy JTF_VARCHAR2_TABLE_500
363 , a10 out nocopy JTF_VARCHAR2_TABLE_500
364 , a11 out nocopy JTF_VARCHAR2_TABLE_500
365 , a12 out nocopy JTF_VARCHAR2_TABLE_500
366 , a13 out nocopy JTF_VARCHAR2_TABLE_500
367 , a14 out nocopy JTF_VARCHAR2_TABLE_500
368 , a15 out nocopy JTF_VARCHAR2_TABLE_2000
369 , a16 out nocopy JTF_VARCHAR2_TABLE_2000
370 );
371
372 procedure rosetta_table_copy_in_p67(t out nocopy oks_entitlements_web.counter_tbl_type, a0 JTF_VARCHAR2_TABLE_500
373 , a1 JTF_VARCHAR2_TABLE_500
374 , a2 JTF_VARCHAR2_TABLE_500
375 , a3 JTF_VARCHAR2_TABLE_500
376 , a4 JTF_VARCHAR2_TABLE_500
377 );
378 procedure rosetta_table_copy_out_p67(t oks_entitlements_web.counter_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_500
379 , a1 out nocopy JTF_VARCHAR2_TABLE_500
380 , a2 out nocopy JTF_VARCHAR2_TABLE_500
381 , a3 out nocopy JTF_VARCHAR2_TABLE_500
382 , a4 out nocopy JTF_VARCHAR2_TABLE_500
383 );
384
385 procedure simple_srch_rslts(p_contract_party_id NUMBER
386 , p_account_id VARCHAR2
387 , x_return_status out nocopy VARCHAR2
388 , x_msg_count out nocopy NUMBER
389 , x_msg_data out nocopy VARCHAR2
390 , p5_a0 out nocopy JTF_VARCHAR2_TABLE_200
391 , p5_a1 out nocopy JTF_VARCHAR2_TABLE_200
392 , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
393 , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
394 , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
395 , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
396 , p5_a6 out nocopy JTF_VARCHAR2_TABLE_300
397 , p5_a7 out nocopy JTF_VARCHAR2_TABLE_2000
398 , p5_a8 out nocopy JTF_DATE_TABLE
399 , p5_a9 out nocopy JTF_DATE_TABLE
400 , p5_a10 out nocopy JTF_DATE_TABLE
401 , p5_a11 out nocopy JTF_NUMBER_TABLE
402 , p5_a12 out nocopy JTF_VARCHAR2_TABLE_100
403 );
404 procedure cntrct_srch_rslts(p_contract_number VARCHAR2
405 , p_contract_status_code VARCHAR2
406 , p_start_date_from date
407 , p_start_date_to date
408 , p_end_date_from date
409 , p_end_date_to date
410 , p_date_terminated_from date
411 , p_date_terminated_to date
412 , p_contract_party_id NUMBER
413 , p_covlvl_site_id NUMBER
414 , p_covlvl_site_name VARCHAR2
415 , p_covlvl_system_id NUMBER
416 , p_covlvl_system_name VARCHAR2
417 , p_covlvl_product_id NUMBER
418 , p_covlvl_product_name VARCHAR2
419 , p_covlvl_item_id NUMBER
420 , p_covlvl_item_name VARCHAR2
421 , p_entitlement_check_yn VARCHAR2
422 , p_account_check_all VARCHAR2
423 , p_account_id VARCHAR2
424 , p_covlvl_party_id VARCHAR2
425 , p21_a0 JTF_NUMBER_TABLE
426 , x_return_status out nocopy VARCHAR2
427 , x_msg_count out nocopy NUMBER
428 , x_msg_data out nocopy VARCHAR2
429 , p25_a0 out nocopy JTF_VARCHAR2_TABLE_200
430 , p25_a1 out nocopy JTF_VARCHAR2_TABLE_200
431 , p25_a2 out nocopy JTF_VARCHAR2_TABLE_100
432 , p25_a3 out nocopy JTF_VARCHAR2_TABLE_100
433 , p25_a4 out nocopy JTF_VARCHAR2_TABLE_100
434 , p25_a5 out nocopy JTF_VARCHAR2_TABLE_100
435 , p25_a6 out nocopy JTF_VARCHAR2_TABLE_300
436 , p25_a7 out nocopy JTF_VARCHAR2_TABLE_2000
437 , p25_a8 out nocopy JTF_DATE_TABLE
438 , p25_a9 out nocopy JTF_DATE_TABLE
439 , p25_a10 out nocopy JTF_DATE_TABLE
440 , p25_a11 out nocopy JTF_NUMBER_TABLE
441 , p25_a12 out nocopy JTF_VARCHAR2_TABLE_100
442 );
443 procedure party_sites(p_party_id_arg VARCHAR2
444 , p_site_name_arg VARCHAR2
445 , x_return_status out nocopy VARCHAR2
446 , p3_a0 out nocopy JTF_NUMBER_TABLE
447 , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
448 , p3_a2 out nocopy JTF_VARCHAR2_TABLE_300
449 , p3_a3 out nocopy JTF_VARCHAR2_TABLE_300
450 );
451 function duration_period(p_start_date date
452 , p_end_date date
453 ) return number;
454 function duration_unit(p_start_date date
455 , p_end_date date
456 ) return varchar2;
457 procedure party_items(p_party_id_arg VARCHAR2
458 , p_item_name_arg VARCHAR2
459 , x_return_status out nocopy VARCHAR2
460 , p3_a0 out nocopy JTF_NUMBER_TABLE
461 , p3_a1 out nocopy JTF_NUMBER_TABLE
462 , p3_a2 out nocopy JTF_VARCHAR2_TABLE_300
463 , p3_a3 out nocopy JTF_VARCHAR2_TABLE_300
464 );
465 procedure party_systems(p_party_id_arg VARCHAR2
466 , p1_a0 JTF_NUMBER_TABLE
467 , p_system_name_arg VARCHAR2
468 , x_return_status out nocopy VARCHAR2
469 , p4_a0 out nocopy JTF_NUMBER_TABLE
470 , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
471 , p4_a2 out nocopy JTF_VARCHAR2_TABLE_300
472 , p4_a3 out nocopy JTF_VARCHAR2_TABLE_300
473 );
474 procedure party_products(p_party_id_arg VARCHAR2
475 , p1_a0 JTF_NUMBER_TABLE
476 , p_product_name_arg VARCHAR2
477 , x_return_status out nocopy VARCHAR2
478 , p4_a0 out nocopy JTF_NUMBER_TABLE
479 , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
480 , p4_a2 out nocopy JTF_VARCHAR2_TABLE_300
481 , p4_a3 out nocopy JTF_VARCHAR2_TABLE_300
482 );
483 procedure adv_search_overview(p_party_id_arg VARCHAR2
484 , x_return_status out nocopy VARCHAR2
485 , x_party_name out nocopy VARCHAR2
486 , p3_a0 out nocopy JTF_VARCHAR2_TABLE_100
487 , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
488 , p4_a0 out nocopy JTF_VARCHAR2_TABLE_100
489 , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
490 );
491 procedure contract_number_overview(p_contract_number_arg VARCHAR2
492 , p_contract_modifier_arg VARCHAR2
493 , x_return_status out nocopy VARCHAR2
494 , p3_a0 out nocopy NUMBER
495 , p3_a1 out nocopy VARCHAR2
496 , p3_a2 out nocopy VARCHAR2
497 , p3_a3 out nocopy VARCHAR2
498 , p3_a4 out nocopy VARCHAR2
499 , p3_a5 out nocopy VARCHAR2
500 , p3_a6 out nocopy NUMBER
501 , p3_a7 out nocopy VARCHAR2
502 , p3_a8 out nocopy VARCHAR2
503 , p3_a9 out nocopy VARCHAR2
504 , p3_a10 out nocopy VARCHAR2
505 , p3_a11 out nocopy VARCHAR2
506 , p3_a12 out nocopy NUMBER
507 , p3_a13 out nocopy DATE
508 , p3_a14 out nocopy DATE
509 , p3_a15 out nocopy NUMBER
510 , p3_a16 out nocopy VARCHAR2
511 , p4_a0 out nocopy NUMBER
512 , p4_a1 out nocopy VARCHAR2
513 , p4_a2 out nocopy VARCHAR2
514 , p4_a3 out nocopy VARCHAR2
515 , p4_a4 out nocopy VARCHAR2
516 , p4_a5 out nocopy VARCHAR2
517 , p4_a6 out nocopy VARCHAR2
518 , p4_a7 out nocopy VARCHAR2
519 , p4_a8 out nocopy VARCHAR2
520 , p4_a9 out nocopy VARCHAR2
521 , p4_a10 out nocopy VARCHAR2
522 , p5_a0 out nocopy JTF_NUMBER_TABLE
523 , p5_a1 out nocopy JTF_VARCHAR2_TABLE_100
524 , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
525 , p5_a3 out nocopy JTF_VARCHAR2_TABLE_400
526 , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
527 , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
528 , p5_a6 out nocopy JTF_VARCHAR2_TABLE_100
529 , p6_a0 out nocopy JTF_NUMBER_TABLE
530 , p6_a1 out nocopy JTF_NUMBER_TABLE
531 , p6_a2 out nocopy JTF_DATE_TABLE
532 , p6_a3 out nocopy JTF_DATE_TABLE
533 , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
534 , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
535 , p6_a6 out nocopy JTF_VARCHAR2_TABLE_200
536 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_300
537 , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
538 , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500
539 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_2000
540 , p6_a11 out nocopy JTF_VARCHAR2_TABLE_400
541 , p6_a12 out nocopy JTF_VARCHAR2_TABLE_400
542 , p6_a13 out nocopy JTF_NUMBER_TABLE
543 , p6_a14 out nocopy JTF_NUMBER_TABLE
544 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_200
545 , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
546 , p6_a17 out nocopy JTF_VARCHAR2_TABLE_400
547 , p6_a18 out nocopy JTF_VARCHAR2_TABLE_300
548 , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
549 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
550 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_400
551 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_300
552 , p6_a23 out nocopy JTF_VARCHAR2_TABLE_100
553 );
554 procedure contract_overview(p_contract_id_arg VARCHAR2
555 , x_return_status out nocopy VARCHAR2
556 , p2_a0 out nocopy NUMBER
557 , p2_a1 out nocopy VARCHAR2
558 , p2_a2 out nocopy VARCHAR2
559 , p2_a3 out nocopy VARCHAR2
560 , p2_a4 out nocopy VARCHAR2
561 , p2_a5 out nocopy VARCHAR2
562 , p2_a6 out nocopy NUMBER
563 , p2_a7 out nocopy VARCHAR2
564 , p2_a8 out nocopy VARCHAR2
565 , p2_a9 out nocopy VARCHAR2
566 , p2_a10 out nocopy VARCHAR2
567 , p2_a11 out nocopy VARCHAR2
568 , p2_a12 out nocopy NUMBER
569 , p2_a13 out nocopy DATE
570 , p2_a14 out nocopy DATE
571 , p2_a15 out nocopy NUMBER
572 , p2_a16 out nocopy VARCHAR2
573 , p3_a0 out nocopy NUMBER
574 , p3_a1 out nocopy VARCHAR2
575 , p3_a2 out nocopy VARCHAR2
576 , p3_a3 out nocopy VARCHAR2
577 , p3_a4 out nocopy VARCHAR2
578 , p3_a5 out nocopy VARCHAR2
579 , p3_a6 out nocopy VARCHAR2
580 , p3_a7 out nocopy VARCHAR2
581 , p3_a8 out nocopy VARCHAR2
582 , p3_a9 out nocopy VARCHAR2
583 , p3_a10 out nocopy VARCHAR2
584 , p4_a0 out nocopy JTF_NUMBER_TABLE
585 , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
586 , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
587 , p4_a3 out nocopy JTF_VARCHAR2_TABLE_400
588 , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
589 , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100
590 , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
591 , p5_a0 out nocopy JTF_NUMBER_TABLE
592 , p5_a1 out nocopy JTF_NUMBER_TABLE
593 , p5_a2 out nocopy JTF_DATE_TABLE
594 , p5_a3 out nocopy JTF_DATE_TABLE
595 , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
596 , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
597 , p5_a6 out nocopy JTF_VARCHAR2_TABLE_200
598 , p5_a7 out nocopy JTF_VARCHAR2_TABLE_300
599 , p5_a8 out nocopy JTF_VARCHAR2_TABLE_500
600 , p5_a9 out nocopy JTF_VARCHAR2_TABLE_500
601 , p5_a10 out nocopy JTF_VARCHAR2_TABLE_2000
602 , p5_a11 out nocopy JTF_VARCHAR2_TABLE_400
603 , p5_a12 out nocopy JTF_VARCHAR2_TABLE_400
604 , p5_a13 out nocopy JTF_NUMBER_TABLE
605 , p5_a14 out nocopy JTF_NUMBER_TABLE
606 , p5_a15 out nocopy JTF_VARCHAR2_TABLE_200
607 , p5_a16 out nocopy JTF_VARCHAR2_TABLE_100
608 , p5_a17 out nocopy JTF_VARCHAR2_TABLE_400
609 , p5_a18 out nocopy JTF_VARCHAR2_TABLE_300
610 , p5_a19 out nocopy JTF_VARCHAR2_TABLE_100
611 , p5_a20 out nocopy JTF_VARCHAR2_TABLE_100
612 , p5_a21 out nocopy JTF_VARCHAR2_TABLE_400
613 , p5_a22 out nocopy JTF_VARCHAR2_TABLE_300
614 , p5_a23 out nocopy JTF_VARCHAR2_TABLE_100
615 );
616 procedure party_overview(p_contract_id_arg VARCHAR2
617 , p_party_rle_code_arg VARCHAR2
618 , x_return_status out nocopy VARCHAR2
619 , p3_a0 out nocopy JTF_NUMBER_TABLE
620 , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
621 , p3_a2 out nocopy JTF_VARCHAR2_TABLE_100
622 , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100
623 , p3_a4 out nocopy JTF_DATE_TABLE
624 , p3_a5 out nocopy JTF_DATE_TABLE
625 , p3_a6 out nocopy JTF_VARCHAR2_TABLE_400
626 , p3_a7 out nocopy JTF_VARCHAR2_TABLE_100
627 , p3_a8 out nocopy JTF_VARCHAR2_TABLE_100
628 );
629 procedure party_contacts_overview(p_contact_id_arg VARCHAR2
630 , x_return_status out nocopy VARCHAR2
631 , p2_a0 out nocopy JTF_VARCHAR2_TABLE_100
632 , p2_a1 out nocopy JTF_VARCHAR2_TABLE_100
633 , p2_a2 out nocopy JTF_VARCHAR2_TABLE_2000
634 , p2_a3 out nocopy JTF_VARCHAR2_TABLE_100
635 , p2_a4 out nocopy JTF_VARCHAR2_TABLE_100
636 , p2_a5 out nocopy JTF_VARCHAR2_TABLE_100
637 , p2_a6 out nocopy JTF_VARCHAR2_TABLE_100
638 , p2_a7 out nocopy JTF_VARCHAR2_TABLE_100
639 );
640 procedure line_overview(p_line_id_arg VARCHAR2
641 , x_return_status out nocopy VARCHAR2
642 , p2_a0 out nocopy VARCHAR2
643 , p2_a1 out nocopy NUMBER
644 , p2_a2 out nocopy VARCHAR2
645 , p2_a3 out nocopy VARCHAR2
646 , p2_a4 out nocopy VARCHAR2
647 , p2_a5 out nocopy VARCHAR2
648 , p2_a6 out nocopy VARCHAR2
649 , p2_a7 out nocopy VARCHAR2
650 , p2_a8 out nocopy VARCHAR2
651 , p2_a9 out nocopy NUMBER
652 , p2_a10 out nocopy VARCHAR2
653 , p2_a11 out nocopy VARCHAR2
654 , p2_a12 out nocopy DATE
655 , p2_a13 out nocopy DATE
656 , p2_a14 out nocopy VARCHAR2
657 , p2_a15 out nocopy VARCHAR2
658 , p2_a16 out nocopy NUMBER
659 , p2_a17 out nocopy VARCHAR2
660 , p2_a18 out nocopy VARCHAR2
661 , p2_a19 out nocopy VARCHAR2
662 , p2_a20 out nocopy DATE
663 , p2_a21 out nocopy DATE
664 , p2_a22 out nocopy VARCHAR2
665 , p2_a23 out nocopy VARCHAR2
666 , p3_a0 out nocopy JTF_VARCHAR2_TABLE_500
667 , p3_a1 out nocopy JTF_VARCHAR2_TABLE_500
668 , p3_a2 out nocopy JTF_VARCHAR2_TABLE_500
669 , p3_a3 out nocopy JTF_DATE_TABLE
670 , p3_a4 out nocopy JTF_DATE_TABLE
671 , p3_a5 out nocopy JTF_NUMBER_TABLE
672 , p3_a6 out nocopy JTF_VARCHAR2_TABLE_500
673 , p3_a7 out nocopy JTF_VARCHAR2_TABLE_500
674 , p3_a8 out nocopy JTF_VARCHAR2_TABLE_500
675 , p4_a0 out nocopy JTF_VARCHAR2_TABLE_500
676 , p4_a1 out nocopy JTF_VARCHAR2_TABLE_500
677 , p4_a2 out nocopy JTF_VARCHAR2_TABLE_500
678 , p4_a3 out nocopy JTF_DATE_TABLE
679 , p4_a4 out nocopy JTF_DATE_TABLE
680 );
681 procedure coverage_overview(p_coverage_id_arg VARCHAR2
682 , p_contract_id_arg VARCHAR2
683 , x_return_status out nocopy VARCHAR2
684 , p3_a0 out nocopy NUMBER
685 , p3_a1 out nocopy VARCHAR2
686 , p3_a2 out nocopy VARCHAR2
687 , p3_a3 out nocopy VARCHAR2
688 , p4_a0 out nocopy JTF_NUMBER_TABLE
689 , p4_a1 out nocopy JTF_NUMBER_TABLE
690 , p4_a2 out nocopy JTF_VARCHAR2_TABLE_500
691 , p4_a3 out nocopy JTF_VARCHAR2_TABLE_500
692 , p4_a4 out nocopy JTF_VARCHAR2_TABLE_500
693 , p4_a5 out nocopy JTF_VARCHAR2_TABLE_500
694 );
695 procedure bus_proc_overview(p_bus_proc_id_arg VARCHAR2
696 , p_contract_id_arg VARCHAR2
697 , x_return_status out nocopy VARCHAR2
698 , p3_a0 out nocopy VARCHAR2
699 , p4_a0 out nocopy JTF_VARCHAR2_TABLE_100
700 , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
701 , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
702 , p5_a0 out nocopy JTF_VARCHAR2_TABLE_500
703 , p5_a1 out nocopy JTF_VARCHAR2_TABLE_500
704 , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
705 , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
706 , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
707 , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
708 , p5_a6 out nocopy JTF_VARCHAR2_TABLE_100
709 , p5_a7 out nocopy JTF_VARCHAR2_TABLE_100
710 , p5_a8 out nocopy JTF_VARCHAR2_TABLE_100
711 , p5_a9 out nocopy JTF_VARCHAR2_TABLE_100
712 , p5_a10 out nocopy JTF_VARCHAR2_TABLE_100
713 , p6_a0 out nocopy JTF_VARCHAR2_TABLE_500
714 , p6_a1 out nocopy JTF_VARCHAR2_TABLE_500
715 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
716 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
717 , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
718 , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
719 , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
720 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
721 , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
722 , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
723 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
724 , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
725 , p7_a1 out nocopy JTF_VARCHAR2_TABLE_400
726 , p8_a0 out nocopy JTF_VARCHAR2_TABLE_500
727 , p8_a1 out nocopy JTF_VARCHAR2_TABLE_500
728 , p8_a2 out nocopy JTF_VARCHAR2_TABLE_500
729 , p8_a3 out nocopy JTF_VARCHAR2_TABLE_500
730 , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100
731 , p8_a5 out nocopy JTF_VARCHAR2_TABLE_500
732 , p8_a6 out nocopy JTF_VARCHAR2_TABLE_500
733 );
734 procedure usage_overview(p_line_id_arg VARCHAR2
735 , x_return_status out nocopy VARCHAR2
736 , p2_a0 out nocopy VARCHAR2
737 , p2_a1 out nocopy VARCHAR2
738 , p2_a2 out nocopy VARCHAR2
739 , p2_a3 out nocopy VARCHAR2
740 , p2_a4 out nocopy VARCHAR2
741 , p2_a5 out nocopy VARCHAR2
742 , p2_a6 out nocopy VARCHAR2
743 , p2_a7 out nocopy VARCHAR2
744 , p2_a8 out nocopy NUMBER
745 , p3_a0 out nocopy JTF_VARCHAR2_TABLE_500
746 , p3_a1 out nocopy JTF_VARCHAR2_TABLE_500
747 , p3_a2 out nocopy JTF_VARCHAR2_TABLE_2000
748 , p3_a3 out nocopy JTF_VARCHAR2_TABLE_500
749 , p3_a4 out nocopy JTF_VARCHAR2_TABLE_500
750 , p3_a5 out nocopy JTF_VARCHAR2_TABLE_500
751 , p3_a6 out nocopy JTF_VARCHAR2_TABLE_500
752 , p3_a7 out nocopy JTF_VARCHAR2_TABLE_500
753 , p3_a8 out nocopy JTF_VARCHAR2_TABLE_500
754 , p3_a9 out nocopy JTF_VARCHAR2_TABLE_500
755 , p3_a10 out nocopy JTF_VARCHAR2_TABLE_500
756 , p3_a11 out nocopy JTF_VARCHAR2_TABLE_500
757 , p3_a12 out nocopy JTF_VARCHAR2_TABLE_500
758 , p3_a13 out nocopy JTF_VARCHAR2_TABLE_500
759 , p3_a14 out nocopy JTF_VARCHAR2_TABLE_500
760 , p3_a15 out nocopy JTF_VARCHAR2_TABLE_2000
761 , p3_a16 out nocopy JTF_VARCHAR2_TABLE_2000
762 );
763 procedure product_overview(p_covered_prod_id_arg VARCHAR2
764 , x_return_status out nocopy VARCHAR2
765 , p2_a0 out nocopy JTF_VARCHAR2_TABLE_500
766 , p2_a1 out nocopy JTF_VARCHAR2_TABLE_500
767 , p2_a2 out nocopy JTF_VARCHAR2_TABLE_500
768 , p2_a3 out nocopy JTF_VARCHAR2_TABLE_500
769 , p2_a4 out nocopy JTF_VARCHAR2_TABLE_500
770 );
771 end oks_entitlements_web_w;