[Home] [Help]
PACKAGE: APPS.OKS_ENTITLEMENTS_PUB_W
Source
1 package oks_entitlements_pub_w as
2 /* $Header: OKSWENTS.pls 120.3 2005/12/22 10:53 jvarghes noship $ */
3 procedure rosetta_table_copy_in_p4(t out nocopy oks_entitlements_pub.apl_tbl_type, a0 JTF_NUMBER_TABLE
4 , a1 JTF_NUMBER_TABLE
5 , a2 JTF_NUMBER_TABLE
6 , a3 JTF_NUMBER_TABLE
7 , a4 JTF_NUMBER_TABLE
8 , a5 JTF_NUMBER_TABLE
9 , a6 JTF_NUMBER_TABLE
10 );
11 procedure rosetta_table_copy_out_p4(t oks_entitlements_pub.apl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
12 , a1 out nocopy JTF_NUMBER_TABLE
13 , a2 out nocopy JTF_NUMBER_TABLE
14 , a3 out nocopy JTF_NUMBER_TABLE
15 , a4 out nocopy JTF_NUMBER_TABLE
16 , a5 out nocopy JTF_NUMBER_TABLE
17 , a6 out nocopy JTF_NUMBER_TABLE
18 );
19
20 procedure rosetta_table_copy_in_p16(t out nocopy oks_entitlements_pub.hdr_tbl_type, a0 JTF_NUMBER_TABLE
21 , a1 JTF_NUMBER_TABLE
22 , a2 JTF_VARCHAR2_TABLE_200
23 , a3 JTF_VARCHAR2_TABLE_200
24 , a4 JTF_VARCHAR2_TABLE_600
25 , a5 JTF_NUMBER_TABLE
26 , a6 JTF_VARCHAR2_TABLE_100
27 , a7 JTF_VARCHAR2_TABLE_100
28 , a8 JTF_NUMBER_TABLE
29 , a9 JTF_VARCHAR2_TABLE_100
30 , a10 JTF_VARCHAR2_TABLE_200
31 , a11 JTF_NUMBER_TABLE
32 , a12 JTF_VARCHAR2_TABLE_100
33 , a13 JTF_DATE_TABLE
34 , a14 JTF_DATE_TABLE
35 , a15 JTF_NUMBER_TABLE
36 , a16 JTF_NUMBER_TABLE
37 , a17 JTF_NUMBER_TABLE
38 , a18 JTF_NUMBER_TABLE
39 , a19 JTF_NUMBER_TABLE
40 , a20 JTF_VARCHAR2_TABLE_100
41 , a21 JTF_NUMBER_TABLE
42 , a22 JTF_NUMBER_TABLE
43 , a23 JTF_NUMBER_TABLE
44 , a24 JTF_VARCHAR2_TABLE_200
45 , a25 JTF_NUMBER_TABLE
46 , a26 JTF_VARCHAR2_TABLE_100
47 , a27 JTF_VARCHAR2_TABLE_100
48 , a28 JTF_NUMBER_TABLE
49 , a29 JTF_DATE_TABLE
50 , a30 JTF_DATE_TABLE
51 , a31 JTF_NUMBER_TABLE
52 , a32 JTF_NUMBER_TABLE
53 , a33 JTF_CLOB_TABLE
54 , a34 JTF_CLOB_TABLE
55 , a35 JTF_VARCHAR2_TABLE_500
56 , a36 JTF_VARCHAR2_TABLE_500
57 , a37 JTF_VARCHAR2_TABLE_500
58 );
59 procedure rosetta_table_copy_out_p16(t oks_entitlements_pub.hdr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
60 , a1 out nocopy JTF_NUMBER_TABLE
61 , a2 out nocopy JTF_VARCHAR2_TABLE_200
62 , a3 out nocopy JTF_VARCHAR2_TABLE_200
63 , a4 out nocopy JTF_VARCHAR2_TABLE_600
64 , a5 out nocopy JTF_NUMBER_TABLE
65 , a6 out nocopy JTF_VARCHAR2_TABLE_100
66 , a7 out nocopy JTF_VARCHAR2_TABLE_100
67 , a8 out nocopy JTF_NUMBER_TABLE
68 , a9 out nocopy JTF_VARCHAR2_TABLE_100
69 , a10 out nocopy JTF_VARCHAR2_TABLE_200
70 , a11 out nocopy JTF_NUMBER_TABLE
71 , a12 out nocopy JTF_VARCHAR2_TABLE_100
72 , a13 out nocopy JTF_DATE_TABLE
73 , a14 out nocopy JTF_DATE_TABLE
74 , a15 out nocopy JTF_NUMBER_TABLE
75 , a16 out nocopy JTF_NUMBER_TABLE
76 , a17 out nocopy JTF_NUMBER_TABLE
77 , a18 out nocopy JTF_NUMBER_TABLE
78 , a19 out nocopy JTF_NUMBER_TABLE
79 , a20 out nocopy JTF_VARCHAR2_TABLE_100
80 , a21 out nocopy JTF_NUMBER_TABLE
81 , a22 out nocopy JTF_NUMBER_TABLE
82 , a23 out nocopy JTF_NUMBER_TABLE
83 , a24 out nocopy JTF_VARCHAR2_TABLE_200
84 , a25 out nocopy JTF_NUMBER_TABLE
85 , a26 out nocopy JTF_VARCHAR2_TABLE_100
86 , a27 out nocopy JTF_VARCHAR2_TABLE_100
87 , a28 out nocopy JTF_NUMBER_TABLE
88 , a29 out nocopy JTF_DATE_TABLE
89 , a30 out nocopy JTF_DATE_TABLE
90 , a31 out nocopy JTF_NUMBER_TABLE
91 , a32 out nocopy JTF_NUMBER_TABLE
92 , a33 out nocopy JTF_CLOB_TABLE
93 , a34 out nocopy JTF_CLOB_TABLE
94 , a35 out nocopy JTF_VARCHAR2_TABLE_500
95 , a36 out nocopy JTF_VARCHAR2_TABLE_500
96 , a37 out nocopy JTF_VARCHAR2_TABLE_500
97 );
98
99 procedure rosetta_table_copy_in_p19(t out nocopy oks_entitlements_pub.line_tbl_type, a0 JTF_NUMBER_TABLE
100 , a1 JTF_NUMBER_TABLE
101 , a2 JTF_NUMBER_TABLE
102 , a3 JTF_VARCHAR2_TABLE_100
103 , a4 JTF_NUMBER_TABLE
104 , a5 JTF_VARCHAR2_TABLE_100
105 , a6 JTF_DATE_TABLE
106 , a7 JTF_DATE_TABLE
107 , a8 JTF_VARCHAR2_TABLE_200
108 , a9 JTF_NUMBER_TABLE
109 , a10 JTF_NUMBER_TABLE
110 , a11 JTF_NUMBER_TABLE
111 , a12 JTF_NUMBER_TABLE
112 , a13 JTF_NUMBER_TABLE
113 , a14 JTF_NUMBER_TABLE
114 , a15 JTF_NUMBER_TABLE
115 , a16 JTF_VARCHAR2_TABLE_100
116 , a17 JTF_VARCHAR2_TABLE_100
117 , a18 JTF_NUMBER_TABLE
118 , a19 JTF_DATE_TABLE
119 , a20 JTF_DATE_TABLE
120 , a21 JTF_DATE_TABLE
121 );
122 procedure rosetta_table_copy_out_p19(t oks_entitlements_pub.line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
123 , a1 out nocopy JTF_NUMBER_TABLE
124 , a2 out nocopy JTF_NUMBER_TABLE
125 , a3 out nocopy JTF_VARCHAR2_TABLE_100
126 , a4 out nocopy JTF_NUMBER_TABLE
127 , a5 out nocopy JTF_VARCHAR2_TABLE_100
128 , a6 out nocopy JTF_DATE_TABLE
129 , a7 out nocopy JTF_DATE_TABLE
130 , a8 out nocopy JTF_VARCHAR2_TABLE_200
131 , a9 out nocopy JTF_NUMBER_TABLE
132 , a10 out nocopy JTF_NUMBER_TABLE
133 , a11 out nocopy JTF_NUMBER_TABLE
134 , a12 out nocopy JTF_NUMBER_TABLE
135 , a13 out nocopy JTF_NUMBER_TABLE
136 , a14 out nocopy JTF_NUMBER_TABLE
137 , a15 out nocopy JTF_NUMBER_TABLE
138 , a16 out nocopy JTF_VARCHAR2_TABLE_100
139 , a17 out nocopy JTF_VARCHAR2_TABLE_100
140 , a18 out nocopy JTF_NUMBER_TABLE
141 , a19 out nocopy JTF_DATE_TABLE
142 , a20 out nocopy JTF_DATE_TABLE
143 , a21 out nocopy JTF_DATE_TABLE
144 );
145
146 procedure rosetta_table_copy_in_p22(t out nocopy oks_entitlements_pub.clvl_tbl_type, a0 JTF_VARCHAR2_TABLE_100
147 , a1 JTF_NUMBER_TABLE
148 , a2 JTF_NUMBER_TABLE
149 , a3 JTF_NUMBER_TABLE
150 , a4 JTF_VARCHAR2_TABLE_200
151 , a5 JTF_NUMBER_TABLE
152 , a6 JTF_VARCHAR2_TABLE_300
153 , a7 JTF_NUMBER_TABLE
154 , a8 JTF_VARCHAR2_TABLE_300
155 , a9 JTF_NUMBER_TABLE
156 , a10 JTF_VARCHAR2_TABLE_300
157 , a11 JTF_NUMBER_TABLE
158 , a12 JTF_VARCHAR2_TABLE_300
159 , a13 JTF_NUMBER_TABLE
160 , a14 JTF_VARCHAR2_TABLE_300
161 , a15 JTF_NUMBER_TABLE
162 , a16 JTF_VARCHAR2_TABLE_500
163 , a17 JTF_NUMBER_TABLE
164 , a18 JTF_NUMBER_TABLE
165 , a19 JTF_NUMBER_TABLE
166 , a20 JTF_VARCHAR2_TABLE_200
167 , a21 JTF_VARCHAR2_TABLE_100
168 , a22 JTF_NUMBER_TABLE
169 , a23 JTF_VARCHAR2_TABLE_100
170 , a24 JTF_NUMBER_TABLE
171 , a25 JTF_VARCHAR2_TABLE_100
172 , a26 JTF_NUMBER_TABLE
173 , a27 JTF_VARCHAR2_TABLE_100
174 , a28 JTF_NUMBER_TABLE
175 , a29 JTF_VARCHAR2_TABLE_100
176 , a30 JTF_NUMBER_TABLE
177 , a31 JTF_VARCHAR2_TABLE_100
178 , a32 JTF_NUMBER_TABLE
179 , a33 JTF_VARCHAR2_TABLE_100
180 , a34 JTF_VARCHAR2_TABLE_100
181 );
182 procedure rosetta_table_copy_out_p22(t oks_entitlements_pub.clvl_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
183 , a1 out nocopy JTF_NUMBER_TABLE
184 , a2 out nocopy JTF_NUMBER_TABLE
185 , a3 out nocopy JTF_NUMBER_TABLE
186 , a4 out nocopy JTF_VARCHAR2_TABLE_200
187 , a5 out nocopy JTF_NUMBER_TABLE
188 , a6 out nocopy JTF_VARCHAR2_TABLE_300
189 , a7 out nocopy JTF_NUMBER_TABLE
190 , a8 out nocopy JTF_VARCHAR2_TABLE_300
191 , a9 out nocopy JTF_NUMBER_TABLE
192 , a10 out nocopy JTF_VARCHAR2_TABLE_300
193 , a11 out nocopy JTF_NUMBER_TABLE
194 , a12 out nocopy JTF_VARCHAR2_TABLE_300
195 , a13 out nocopy JTF_NUMBER_TABLE
196 , a14 out nocopy JTF_VARCHAR2_TABLE_300
197 , a15 out nocopy JTF_NUMBER_TABLE
198 , a16 out nocopy JTF_VARCHAR2_TABLE_500
199 , a17 out nocopy JTF_NUMBER_TABLE
200 , a18 out nocopy JTF_NUMBER_TABLE
201 , a19 out nocopy JTF_NUMBER_TABLE
202 , a20 out nocopy JTF_VARCHAR2_TABLE_200
203 , a21 out nocopy JTF_VARCHAR2_TABLE_100
204 , a22 out nocopy JTF_NUMBER_TABLE
205 , a23 out nocopy JTF_VARCHAR2_TABLE_100
206 , a24 out nocopy JTF_NUMBER_TABLE
207 , a25 out nocopy JTF_VARCHAR2_TABLE_100
208 , a26 out nocopy JTF_NUMBER_TABLE
209 , a27 out nocopy JTF_VARCHAR2_TABLE_100
210 , a28 out nocopy JTF_NUMBER_TABLE
211 , a29 out nocopy JTF_VARCHAR2_TABLE_100
212 , a30 out nocopy JTF_NUMBER_TABLE
213 , a31 out nocopy JTF_VARCHAR2_TABLE_100
214 , a32 out nocopy JTF_NUMBER_TABLE
215 , a33 out nocopy JTF_VARCHAR2_TABLE_100
216 , a34 out nocopy JTF_VARCHAR2_TABLE_100
217 );
218
219 procedure rosetta_table_copy_in_p26(t out nocopy oks_entitlements_pub.ent_cont_tbl, a0 JTF_NUMBER_TABLE
220 , a1 JTF_VARCHAR2_TABLE_200
221 , a2 JTF_VARCHAR2_TABLE_200
222 , a3 JTF_NUMBER_TABLE
223 , a4 JTF_VARCHAR2_TABLE_300
224 , a5 JTF_VARCHAR2_TABLE_300
225 , a6 JTF_NUMBER_TABLE
226 , a7 JTF_VARCHAR2_TABLE_200
227 , a8 JTF_VARCHAR2_TABLE_2000
228 , a9 JTF_VARCHAR2_TABLE_100
229 , a10 JTF_VARCHAR2_TABLE_100
230 , a11 JTF_NUMBER_TABLE
231 , a12 JTF_NUMBER_TABLE
232 , a13 JTF_VARCHAR2_TABLE_200
233 , a14 JTF_VARCHAR2_TABLE_100
234 , a15 JTF_DATE_TABLE
235 , a16 JTF_DATE_TABLE
236 , a17 JTF_NUMBER_TABLE
237 , a18 JTF_VARCHAR2_TABLE_100
238 , a19 JTF_VARCHAR2_TABLE_100
239 );
240 procedure rosetta_table_copy_out_p26(t oks_entitlements_pub.ent_cont_tbl, a0 out nocopy JTF_NUMBER_TABLE
241 , a1 out nocopy JTF_VARCHAR2_TABLE_200
242 , a2 out nocopy JTF_VARCHAR2_TABLE_200
243 , a3 out nocopy JTF_NUMBER_TABLE
244 , a4 out nocopy JTF_VARCHAR2_TABLE_300
245 , a5 out nocopy JTF_VARCHAR2_TABLE_300
246 , a6 out nocopy JTF_NUMBER_TABLE
247 , a7 out nocopy JTF_VARCHAR2_TABLE_200
248 , a8 out nocopy JTF_VARCHAR2_TABLE_2000
249 , a9 out nocopy JTF_VARCHAR2_TABLE_100
250 , a10 out nocopy JTF_VARCHAR2_TABLE_100
251 , a11 out nocopy JTF_NUMBER_TABLE
252 , a12 out nocopy JTF_NUMBER_TABLE
253 , a13 out nocopy JTF_VARCHAR2_TABLE_200
254 , a14 out nocopy JTF_VARCHAR2_TABLE_100
255 , a15 out nocopy JTF_DATE_TABLE
256 , a16 out nocopy JTF_DATE_TABLE
257 , a17 out nocopy JTF_NUMBER_TABLE
258 , a18 out nocopy JTF_VARCHAR2_TABLE_100
259 , a19 out nocopy JTF_VARCHAR2_TABLE_100
260 );
261
262 procedure rosetta_table_copy_in_p30(t out nocopy oks_entitlements_pub.get_contop_tbl, a0 JTF_NUMBER_TABLE
263 , a1 JTF_VARCHAR2_TABLE_200
264 , a2 JTF_VARCHAR2_TABLE_200
265 , a3 JTF_VARCHAR2_TABLE_100
266 , a4 JTF_NUMBER_TABLE
267 , a5 JTF_VARCHAR2_TABLE_300
268 , a6 JTF_VARCHAR2_TABLE_300
269 , a7 JTF_NUMBER_TABLE
270 , a8 JTF_VARCHAR2_TABLE_200
271 , a9 JTF_VARCHAR2_TABLE_2000
272 , a10 JTF_VARCHAR2_TABLE_100
273 , a11 JTF_VARCHAR2_TABLE_100
274 , a12 JTF_NUMBER_TABLE
275 , a13 JTF_DATE_TABLE
276 , a14 JTF_DATE_TABLE
277 , a15 JTF_VARCHAR2_TABLE_100
278 , a16 JTF_VARCHAR2_TABLE_100
279 , a17 JTF_DATE_TABLE
280 , a18 JTF_DATE_TABLE
281 , a19 JTF_VARCHAR2_TABLE_100
282 , a20 JTF_VARCHAR2_TABLE_2000
283 , a21 JTF_DATE_TABLE
284 , a22 JTF_VARCHAR2_TABLE_100
285 , a23 JTF_VARCHAR2_TABLE_500
286 , a24 JTF_VARCHAR2_TABLE_100
287 , a25 JTF_VARCHAR2_TABLE_500
288 , a26 JTF_VARCHAR2_TABLE_100
289 , a27 JTF_NUMBER_TABLE
290 );
291 procedure rosetta_table_copy_out_p30(t oks_entitlements_pub.get_contop_tbl, a0 out nocopy JTF_NUMBER_TABLE
292 , a1 out nocopy JTF_VARCHAR2_TABLE_200
293 , a2 out nocopy JTF_VARCHAR2_TABLE_200
294 , a3 out nocopy JTF_VARCHAR2_TABLE_100
295 , a4 out nocopy JTF_NUMBER_TABLE
296 , a5 out nocopy JTF_VARCHAR2_TABLE_300
297 , a6 out nocopy JTF_VARCHAR2_TABLE_300
298 , a7 out nocopy JTF_NUMBER_TABLE
299 , a8 out nocopy JTF_VARCHAR2_TABLE_200
300 , a9 out nocopy JTF_VARCHAR2_TABLE_2000
301 , a10 out nocopy JTF_VARCHAR2_TABLE_100
302 , a11 out nocopy JTF_VARCHAR2_TABLE_100
303 , a12 out nocopy JTF_NUMBER_TABLE
304 , a13 out nocopy JTF_DATE_TABLE
305 , a14 out nocopy JTF_DATE_TABLE
306 , a15 out nocopy JTF_VARCHAR2_TABLE_100
307 , a16 out nocopy JTF_VARCHAR2_TABLE_100
308 , a17 out nocopy JTF_DATE_TABLE
309 , a18 out nocopy JTF_DATE_TABLE
310 , a19 out nocopy JTF_VARCHAR2_TABLE_100
311 , a20 out nocopy JTF_VARCHAR2_TABLE_2000
312 , a21 out nocopy JTF_DATE_TABLE
313 , a22 out nocopy JTF_VARCHAR2_TABLE_100
314 , a23 out nocopy JTF_VARCHAR2_TABLE_500
315 , a24 out nocopy JTF_VARCHAR2_TABLE_100
316 , a25 out nocopy JTF_VARCHAR2_TABLE_500
317 , a26 out nocopy JTF_VARCHAR2_TABLE_100
318 , a27 out nocopy JTF_NUMBER_TABLE
319 );
320
321 procedure rosetta_table_copy_in_p34(t out nocopy oks_entitlements_pub.output_tbl_ib, a0 JTF_NUMBER_TABLE
322 , a1 JTF_VARCHAR2_TABLE_200
323 , a2 JTF_VARCHAR2_TABLE_200
324 , a3 JTF_VARCHAR2_TABLE_100
325 , a4 JTF_NUMBER_TABLE
326 , a5 JTF_VARCHAR2_TABLE_300
327 , a6 JTF_VARCHAR2_TABLE_300
328 , a7 JTF_NUMBER_TABLE
329 , a8 JTF_VARCHAR2_TABLE_200
330 , a9 JTF_VARCHAR2_TABLE_2000
331 , a10 JTF_VARCHAR2_TABLE_100
332 , a11 JTF_NUMBER_TABLE
333 , a12 JTF_DATE_TABLE
334 , a13 JTF_DATE_TABLE
335 , a14 JTF_VARCHAR2_TABLE_100
336 , a15 JTF_VARCHAR2_TABLE_100
337 , a16 JTF_DATE_TABLE
338 , a17 JTF_DATE_TABLE
339 , a18 JTF_VARCHAR2_TABLE_100
340 , a19 JTF_VARCHAR2_TABLE_2000
341 , a20 JTF_DATE_TABLE
342 , a21 JTF_NUMBER_TABLE
343 );
344 procedure rosetta_table_copy_out_p34(t oks_entitlements_pub.output_tbl_ib, a0 out nocopy JTF_NUMBER_TABLE
345 , a1 out nocopy JTF_VARCHAR2_TABLE_200
346 , a2 out nocopy JTF_VARCHAR2_TABLE_200
347 , a3 out nocopy JTF_VARCHAR2_TABLE_100
348 , a4 out nocopy JTF_NUMBER_TABLE
349 , a5 out nocopy JTF_VARCHAR2_TABLE_300
350 , a6 out nocopy JTF_VARCHAR2_TABLE_300
351 , a7 out nocopy JTF_NUMBER_TABLE
352 , a8 out nocopy JTF_VARCHAR2_TABLE_200
353 , a9 out nocopy JTF_VARCHAR2_TABLE_2000
354 , a10 out nocopy JTF_VARCHAR2_TABLE_100
355 , a11 out nocopy JTF_NUMBER_TABLE
356 , a12 out nocopy JTF_DATE_TABLE
357 , a13 out nocopy JTF_DATE_TABLE
358 , a14 out nocopy JTF_VARCHAR2_TABLE_100
359 , a15 out nocopy JTF_VARCHAR2_TABLE_100
360 , a16 out nocopy JTF_DATE_TABLE
361 , a17 out nocopy JTF_DATE_TABLE
362 , a18 out nocopy JTF_VARCHAR2_TABLE_100
363 , a19 out nocopy JTF_VARCHAR2_TABLE_2000
364 , a20 out nocopy JTF_DATE_TABLE
365 , a21 out nocopy JTF_NUMBER_TABLE
366 );
367
368 procedure rosetta_table_copy_in_p38(t out nocopy oks_entitlements_pub.output_tbl_entfrm, a0 JTF_NUMBER_TABLE
369 , a1 JTF_VARCHAR2_TABLE_200
370 , a2 JTF_VARCHAR2_TABLE_200
371 , a3 JTF_VARCHAR2_TABLE_300
372 , a4 JTF_VARCHAR2_TABLE_600
373 , a5 JTF_VARCHAR2_TABLE_100
374 , a6 JTF_DATE_TABLE
375 , a7 JTF_DATE_TABLE
376 , a8 JTF_DATE_TABLE
377 );
378 procedure rosetta_table_copy_out_p38(t oks_entitlements_pub.output_tbl_entfrm, a0 out nocopy JTF_NUMBER_TABLE
379 , a1 out nocopy JTF_VARCHAR2_TABLE_200
380 , a2 out nocopy JTF_VARCHAR2_TABLE_200
381 , a3 out nocopy JTF_VARCHAR2_TABLE_300
382 , a4 out nocopy JTF_VARCHAR2_TABLE_600
383 , a5 out nocopy JTF_VARCHAR2_TABLE_100
384 , a6 out nocopy JTF_DATE_TABLE
385 , a7 out nocopy JTF_DATE_TABLE
386 , a8 out nocopy JTF_DATE_TABLE
387 );
388
389 procedure rosetta_table_copy_in_p41(t out nocopy oks_entitlements_pub.covlevel_tbl_type, a0 JTF_VARCHAR2_TABLE_100
390 , a1 JTF_NUMBER_TABLE
391 , a2 JTF_NUMBER_TABLE
392 , a3 JTF_VARCHAR2_TABLE_100
393 );
394 procedure rosetta_table_copy_out_p41(t oks_entitlements_pub.covlevel_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
395 , a1 out nocopy JTF_NUMBER_TABLE
396 , a2 out nocopy JTF_NUMBER_TABLE
397 , a3 out nocopy JTF_VARCHAR2_TABLE_100
398 );
399
400 procedure rosetta_table_copy_in_p44(t out nocopy oks_entitlements_pub.covlvl_id_tbl, a0 JTF_NUMBER_TABLE
401 , a1 JTF_VARCHAR2_TABLE_100
402 );
403 procedure rosetta_table_copy_out_p44(t oks_entitlements_pub.covlvl_id_tbl, a0 out nocopy JTF_NUMBER_TABLE
404 , a1 out nocopy JTF_VARCHAR2_TABLE_100
405 );
406
407 procedure rosetta_table_copy_in_p47(t out nocopy oks_entitlements_pub.output_tbl_contract, a0 JTF_VARCHAR2_TABLE_200
408 , a1 JTF_VARCHAR2_TABLE_200
409 , a2 JTF_VARCHAR2_TABLE_100
410 , a3 JTF_VARCHAR2_TABLE_100
411 , a4 JTF_VARCHAR2_TABLE_300
412 , a5 JTF_VARCHAR2_TABLE_2000
413 , a6 JTF_DATE_TABLE
414 , a7 JTF_DATE_TABLE
415 , a8 JTF_DATE_TABLE
416 , a9 JTF_NUMBER_TABLE
417 , a10 JTF_VARCHAR2_TABLE_100
418 , a11 JTF_VARCHAR2_TABLE_100
419 , a12 JTF_VARCHAR2_TABLE_100
420 );
421 procedure rosetta_table_copy_out_p47(t oks_entitlements_pub.output_tbl_contract, a0 out nocopy JTF_VARCHAR2_TABLE_200
422 , a1 out nocopy JTF_VARCHAR2_TABLE_200
423 , a2 out nocopy JTF_VARCHAR2_TABLE_100
424 , a3 out nocopy JTF_VARCHAR2_TABLE_100
425 , a4 out nocopy JTF_VARCHAR2_TABLE_300
426 , a5 out nocopy JTF_VARCHAR2_TABLE_2000
427 , a6 out nocopy JTF_DATE_TABLE
428 , a7 out nocopy JTF_DATE_TABLE
429 , a8 out nocopy JTF_DATE_TABLE
430 , a9 out nocopy JTF_NUMBER_TABLE
431 , a10 out nocopy JTF_VARCHAR2_TABLE_100
432 , a11 out nocopy JTF_VARCHAR2_TABLE_100
433 , a12 out nocopy JTF_VARCHAR2_TABLE_100
434 );
435
436 procedure rosetta_table_copy_in_p60(t out nocopy oks_entitlements_pub.ent_contact_tbl, a0 JTF_NUMBER_TABLE
437 , a1 JTF_NUMBER_TABLE
438 , a2 JTF_NUMBER_TABLE
439 , a3 JTF_VARCHAR2_TABLE_100
440 , a4 JTF_NUMBER_TABLE
441 , a5 JTF_VARCHAR2_TABLE_100
442 , a6 JTF_VARCHAR2_TABLE_100
443 );
444 procedure rosetta_table_copy_out_p60(t oks_entitlements_pub.ent_contact_tbl, a0 out nocopy JTF_NUMBER_TABLE
445 , a1 out nocopy JTF_NUMBER_TABLE
446 , a2 out nocopy JTF_NUMBER_TABLE
447 , a3 out nocopy JTF_VARCHAR2_TABLE_100
448 , a4 out nocopy JTF_NUMBER_TABLE
449 , a5 out nocopy JTF_VARCHAR2_TABLE_100
450 , a6 out nocopy JTF_VARCHAR2_TABLE_100
451 );
452
453 procedure rosetta_table_copy_in_p63(t out nocopy oks_entitlements_pub.prfeng_tbl_type, a0 JTF_NUMBER_TABLE
454 , a1 JTF_NUMBER_TABLE
455 , a2 JTF_VARCHAR2_TABLE_100
456 , a3 JTF_VARCHAR2_TABLE_100
457 , a4 JTF_VARCHAR2_TABLE_100
458 );
459 procedure rosetta_table_copy_out_p63(t oks_entitlements_pub.prfeng_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
460 , a1 out nocopy JTF_NUMBER_TABLE
461 , a2 out nocopy JTF_VARCHAR2_TABLE_100
462 , a3 out nocopy JTF_VARCHAR2_TABLE_100
463 , a4 out nocopy JTF_VARCHAR2_TABLE_100
464 );
465
466 procedure rosetta_table_copy_in_p70(t out nocopy oks_entitlements_pub.output_tbl_bp, a0 JTF_NUMBER_TABLE
467 , a1 JTF_NUMBER_TABLE
468 , a2 JTF_DATE_TABLE
469 , a3 JTF_DATE_TABLE
470 );
471 procedure rosetta_table_copy_out_p70(t oks_entitlements_pub.output_tbl_bp, a0 out nocopy JTF_NUMBER_TABLE
472 , a1 out nocopy JTF_NUMBER_TABLE
473 , a2 out nocopy JTF_DATE_TABLE
474 , a3 out nocopy JTF_DATE_TABLE
475 );
476
477 procedure rosetta_table_copy_in_p73(t out nocopy oks_entitlements_pub.output_tbl_bt, a0 JTF_NUMBER_TABLE
478 , a1 JTF_NUMBER_TABLE
479 , a2 JTF_NUMBER_TABLE
480 , a3 JTF_NUMBER_TABLE
481 );
482 procedure rosetta_table_copy_out_p73(t oks_entitlements_pub.output_tbl_bt, a0 out nocopy JTF_NUMBER_TABLE
483 , a1 out nocopy JTF_NUMBER_TABLE
484 , a2 out nocopy JTF_NUMBER_TABLE
485 , a3 out nocopy JTF_NUMBER_TABLE
486 );
487
488 procedure rosetta_table_copy_in_p75(t out nocopy oks_entitlements_pub.output_tbl_br, a0 JTF_NUMBER_TABLE
489 , a1 JTF_NUMBER_TABLE
490 , a2 JTF_NUMBER_TABLE
491 , a3 JTF_VARCHAR2_TABLE_100
492 , a4 JTF_NUMBER_TABLE
493 , a5 JTF_VARCHAR2_TABLE_100
494 , a6 JTF_NUMBER_TABLE
495 , a7 JTF_NUMBER_TABLE
496 , a8 JTF_NUMBER_TABLE
497 , a9 JTF_NUMBER_TABLE
498 , a10 JTF_NUMBER_TABLE
499 , a11 JTF_VARCHAR2_TABLE_100
500 , a12 JTF_VARCHAR2_TABLE_100
501 , a13 JTF_VARCHAR2_TABLE_100
502 , a14 JTF_VARCHAR2_TABLE_100
503 , a15 JTF_VARCHAR2_TABLE_100
504 , a16 JTF_VARCHAR2_TABLE_100
505 , a17 JTF_VARCHAR2_TABLE_100
506 , a18 JTF_NUMBER_TABLE
507 , a19 JTF_NUMBER_TABLE
508 , a20 JTF_VARCHAR2_TABLE_100
509 );
510 procedure rosetta_table_copy_out_p75(t oks_entitlements_pub.output_tbl_br, a0 out nocopy JTF_NUMBER_TABLE
511 , a1 out nocopy JTF_NUMBER_TABLE
512 , a2 out nocopy JTF_NUMBER_TABLE
513 , a3 out nocopy JTF_VARCHAR2_TABLE_100
514 , a4 out nocopy JTF_NUMBER_TABLE
515 , a5 out nocopy JTF_VARCHAR2_TABLE_100
516 , a6 out nocopy JTF_NUMBER_TABLE
517 , a7 out nocopy JTF_NUMBER_TABLE
518 , a8 out nocopy JTF_NUMBER_TABLE
519 , a9 out nocopy JTF_NUMBER_TABLE
520 , a10 out nocopy JTF_NUMBER_TABLE
521 , a11 out nocopy JTF_VARCHAR2_TABLE_100
522 , a12 out nocopy JTF_VARCHAR2_TABLE_100
523 , a13 out nocopy JTF_VARCHAR2_TABLE_100
524 , a14 out nocopy JTF_VARCHAR2_TABLE_100
525 , a15 out nocopy JTF_VARCHAR2_TABLE_100
526 , a16 out nocopy JTF_VARCHAR2_TABLE_100
527 , a17 out nocopy JTF_VARCHAR2_TABLE_100
528 , a18 out nocopy JTF_NUMBER_TABLE
529 , a19 out nocopy JTF_NUMBER_TABLE
530 , a20 out nocopy JTF_VARCHAR2_TABLE_100
531 );
532
533 procedure rosetta_table_copy_in_p79(t out nocopy oks_entitlements_pub.srchline_inpcontlinerec_tbl, a0 JTF_NUMBER_TABLE
534 , a1 JTF_VARCHAR2_TABLE_100
535 , a2 JTF_VARCHAR2_TABLE_100
536 , a3 JTF_DATE_TABLE
537 , a4 JTF_DATE_TABLE
538 , a5 JTF_DATE_TABLE
539 , a6 JTF_DATE_TABLE
540 , a7 JTF_NUMBER_TABLE
541 , a8 JTF_NUMBER_TABLE
542 , a9 JTF_VARCHAR2_TABLE_100
543 );
544 procedure rosetta_table_copy_out_p79(t oks_entitlements_pub.srchline_inpcontlinerec_tbl, a0 out nocopy JTF_NUMBER_TABLE
545 , a1 out nocopy JTF_VARCHAR2_TABLE_100
546 , a2 out nocopy JTF_VARCHAR2_TABLE_100
547 , a3 out nocopy JTF_DATE_TABLE
548 , a4 out nocopy JTF_DATE_TABLE
549 , a5 out nocopy JTF_DATE_TABLE
550 , a6 out nocopy JTF_DATE_TABLE
551 , a7 out nocopy JTF_NUMBER_TABLE
552 , a8 out nocopy JTF_NUMBER_TABLE
553 , a9 out nocopy JTF_VARCHAR2_TABLE_100
554 );
555
556 procedure rosetta_table_copy_in_p81(t out nocopy oks_entitlements_pub.srchline_covlvl_id_tbl, a0 JTF_NUMBER_TABLE
557 , a1 JTF_NUMBER_TABLE
558 , a2 JTF_VARCHAR2_TABLE_100
559 );
560 procedure rosetta_table_copy_out_p81(t oks_entitlements_pub.srchline_covlvl_id_tbl, a0 out nocopy JTF_NUMBER_TABLE
561 , a1 out nocopy JTF_NUMBER_TABLE
562 , a2 out nocopy JTF_VARCHAR2_TABLE_100
563 );
564
565 procedure rosetta_table_copy_in_p83(t out nocopy oks_entitlements_pub.output_tbl_contractline, a0 JTF_VARCHAR2_TABLE_200
566 , a1 JTF_VARCHAR2_TABLE_200
567 , a2 JTF_VARCHAR2_TABLE_200
568 , a3 JTF_VARCHAR2_TABLE_200
569 , a4 JTF_VARCHAR2_TABLE_2000
570 , a5 JTF_VARCHAR2_TABLE_2000
571 , a6 JTF_DATE_TABLE
572 , a7 JTF_DATE_TABLE
573 , a8 JTF_VARCHAR2_TABLE_100
574 , a9 JTF_VARCHAR2_TABLE_200
575 , a10 JTF_NUMBER_TABLE
576 , a11 JTF_NUMBER_TABLE
577 , a12 JTF_NUMBER_TABLE
578 , a13 JTF_NUMBER_TABLE
579 , a14 JTF_NUMBER_TABLE
580 , a15 JTF_VARCHAR2_TABLE_100
581 , a16 JTF_NUMBER_TABLE
582 , a17 JTF_VARCHAR2_TABLE_300
583 );
584 procedure rosetta_table_copy_out_p83(t oks_entitlements_pub.output_tbl_contractline, a0 out nocopy JTF_VARCHAR2_TABLE_200
585 , a1 out nocopy JTF_VARCHAR2_TABLE_200
586 , a2 out nocopy JTF_VARCHAR2_TABLE_200
587 , a3 out nocopy JTF_VARCHAR2_TABLE_200
588 , a4 out nocopy JTF_VARCHAR2_TABLE_2000
589 , a5 out nocopy JTF_VARCHAR2_TABLE_2000
590 , a6 out nocopy JTF_DATE_TABLE
591 , a7 out nocopy JTF_DATE_TABLE
592 , a8 out nocopy JTF_VARCHAR2_TABLE_100
593 , a9 out nocopy JTF_VARCHAR2_TABLE_200
594 , a10 out nocopy JTF_NUMBER_TABLE
595 , a11 out nocopy JTF_NUMBER_TABLE
596 , a12 out nocopy JTF_NUMBER_TABLE
597 , a13 out nocopy JTF_NUMBER_TABLE
598 , a14 out nocopy JTF_NUMBER_TABLE
599 , a15 out nocopy JTF_VARCHAR2_TABLE_100
600 , a16 out nocopy JTF_NUMBER_TABLE
601 , a17 out nocopy JTF_VARCHAR2_TABLE_300
602 );
603
604 procedure get_all_contracts(p_api_version NUMBER
605 , p_init_msg_list VARCHAR2
606 , p2_a0 NUMBER
607 , p2_a1 VARCHAR2
608 , p2_a2 VARCHAR2
609 , p2_a3 DATE
610 , p2_a4 NUMBER
611 , x_return_status out nocopy VARCHAR2
612 , x_msg_count out nocopy NUMBER
613 , x_msg_data out nocopy VARCHAR2
614 , p6_a0 out nocopy JTF_NUMBER_TABLE
615 , p6_a1 out nocopy JTF_NUMBER_TABLE
616 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
617 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
618 , p6_a4 out nocopy JTF_VARCHAR2_TABLE_600
619 , p6_a5 out nocopy JTF_NUMBER_TABLE
620 , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
621 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
622 , p6_a8 out nocopy JTF_NUMBER_TABLE
623 , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
624 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_200
625 , p6_a11 out nocopy JTF_NUMBER_TABLE
626 , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
627 , p6_a13 out nocopy JTF_DATE_TABLE
628 , p6_a14 out nocopy JTF_DATE_TABLE
629 , p6_a15 out nocopy JTF_NUMBER_TABLE
630 , p6_a16 out nocopy JTF_NUMBER_TABLE
631 , p6_a17 out nocopy JTF_NUMBER_TABLE
632 , p6_a18 out nocopy JTF_NUMBER_TABLE
633 , p6_a19 out nocopy JTF_NUMBER_TABLE
634 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
635 , p6_a21 out nocopy JTF_NUMBER_TABLE
636 , p6_a22 out nocopy JTF_NUMBER_TABLE
637 , p6_a23 out nocopy JTF_NUMBER_TABLE
638 , p6_a24 out nocopy JTF_VARCHAR2_TABLE_200
639 , p6_a25 out nocopy JTF_NUMBER_TABLE
640 , p6_a26 out nocopy JTF_VARCHAR2_TABLE_100
641 , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100
642 , p6_a28 out nocopy JTF_NUMBER_TABLE
643 , p6_a29 out nocopy JTF_DATE_TABLE
644 , p6_a30 out nocopy JTF_DATE_TABLE
645 , p6_a31 out nocopy JTF_NUMBER_TABLE
646 , p6_a32 out nocopy JTF_NUMBER_TABLE
647 , p6_a33 out nocopy JTF_CLOB_TABLE
648 , p6_a34 out nocopy JTF_CLOB_TABLE
649 , p6_a35 out nocopy JTF_VARCHAR2_TABLE_500
650 , p6_a36 out nocopy JTF_VARCHAR2_TABLE_500
651 , p6_a37 out nocopy JTF_VARCHAR2_TABLE_500
652 );
653 procedure get_contract_details(p_api_version NUMBER
654 , p_init_msg_list VARCHAR2
655 , p_contract_line_id NUMBER
656 , x_return_status out nocopy VARCHAR2
657 , x_msg_count out nocopy NUMBER
658 , x_msg_data out nocopy VARCHAR2
659 , p6_a0 out nocopy JTF_NUMBER_TABLE
660 , p6_a1 out nocopy JTF_NUMBER_TABLE
661 , p6_a2 out nocopy JTF_NUMBER_TABLE
662 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
663 , p6_a4 out nocopy JTF_NUMBER_TABLE
664 , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
665 , p6_a6 out nocopy JTF_DATE_TABLE
666 , p6_a7 out nocopy JTF_DATE_TABLE
667 , p6_a8 out nocopy JTF_VARCHAR2_TABLE_200
668 , p6_a9 out nocopy JTF_NUMBER_TABLE
669 , p6_a10 out nocopy JTF_NUMBER_TABLE
670 , p6_a11 out nocopy JTF_NUMBER_TABLE
671 , p6_a12 out nocopy JTF_NUMBER_TABLE
672 , p6_a13 out nocopy JTF_NUMBER_TABLE
673 , p6_a14 out nocopy JTF_NUMBER_TABLE
674 , p6_a15 out nocopy JTF_NUMBER_TABLE
675 , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
676 , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
677 , p6_a18 out nocopy JTF_NUMBER_TABLE
678 , p6_a19 out nocopy JTF_DATE_TABLE
679 , p6_a20 out nocopy JTF_DATE_TABLE
680 , p6_a21 out nocopy JTF_DATE_TABLE
681 );
682 procedure get_coverage_levels(p_api_version NUMBER
683 , p_init_msg_list VARCHAR2
684 , p_contract_line_id NUMBER
685 , x_return_status out nocopy VARCHAR2
686 , x_msg_count out nocopy NUMBER
687 , x_msg_data out nocopy VARCHAR2
688 , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
689 , p6_a1 out nocopy JTF_NUMBER_TABLE
690 , p6_a2 out nocopy JTF_NUMBER_TABLE
691 , p6_a3 out nocopy JTF_NUMBER_TABLE
692 , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
693 , p6_a5 out nocopy JTF_NUMBER_TABLE
694 , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
695 , p6_a7 out nocopy JTF_NUMBER_TABLE
696 , p6_a8 out nocopy JTF_VARCHAR2_TABLE_300
697 , p6_a9 out nocopy JTF_NUMBER_TABLE
698 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_300
699 , p6_a11 out nocopy JTF_NUMBER_TABLE
700 , p6_a12 out nocopy JTF_VARCHAR2_TABLE_300
701 , p6_a13 out nocopy JTF_NUMBER_TABLE
702 , p6_a14 out nocopy JTF_VARCHAR2_TABLE_300
703 , p6_a15 out nocopy JTF_NUMBER_TABLE
704 , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
705 , p6_a17 out nocopy JTF_NUMBER_TABLE
706 , p6_a18 out nocopy JTF_NUMBER_TABLE
707 , p6_a19 out nocopy JTF_NUMBER_TABLE
708 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_200
709 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
710 , p6_a22 out nocopy JTF_NUMBER_TABLE
711 , p6_a23 out nocopy JTF_VARCHAR2_TABLE_100
712 , p6_a24 out nocopy JTF_NUMBER_TABLE
713 , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
714 , p6_a26 out nocopy JTF_NUMBER_TABLE
715 , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100
716 , p6_a28 out nocopy JTF_NUMBER_TABLE
717 , p6_a29 out nocopy JTF_VARCHAR2_TABLE_100
718 , p6_a30 out nocopy JTF_NUMBER_TABLE
719 , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100
720 , p6_a32 out nocopy JTF_NUMBER_TABLE
721 , p6_a33 out nocopy JTF_VARCHAR2_TABLE_100
722 , p6_a34 out nocopy JTF_VARCHAR2_TABLE_100
723 );
724 procedure get_contracts(p_api_version NUMBER
725 , p_init_msg_list VARCHAR2
726 , p2_a0 VARCHAR2
727 , p2_a1 VARCHAR2
728 , p2_a2 NUMBER
729 , p2_a3 NUMBER
730 , p2_a4 NUMBER
731 , p2_a5 NUMBER
732 , p2_a6 NUMBER
733 , p2_a7 NUMBER
734 , p2_a8 NUMBER
735 , p2_a9 DATE
736 , p2_a10 VARCHAR2
737 , x_return_status out nocopy VARCHAR2
738 , x_msg_count out nocopy NUMBER
739 , x_msg_data out nocopy VARCHAR2
740 , p6_a0 out nocopy JTF_NUMBER_TABLE
741 , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
742 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
743 , p6_a3 out nocopy JTF_NUMBER_TABLE
744 , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300
745 , p6_a5 out nocopy JTF_VARCHAR2_TABLE_300
746 , p6_a6 out nocopy JTF_NUMBER_TABLE
747 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_200
748 , p6_a8 out nocopy JTF_VARCHAR2_TABLE_2000
749 , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
750 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
751 , p6_a11 out nocopy JTF_NUMBER_TABLE
752 , p6_a12 out nocopy JTF_NUMBER_TABLE
753 , p6_a13 out nocopy JTF_VARCHAR2_TABLE_200
754 , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
755 , p6_a15 out nocopy JTF_DATE_TABLE
756 , p6_a16 out nocopy JTF_DATE_TABLE
757 , p6_a17 out nocopy JTF_NUMBER_TABLE
758 , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
759 , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
760 );
761 procedure get_contracts(p_api_version NUMBER
762 , p_init_msg_list VARCHAR2
763 , p2_a0 VARCHAR2
764 , p2_a1 VARCHAR2
765 , p2_a2 NUMBER
766 , p2_a3 NUMBER
767 , p2_a4 NUMBER
768 , p2_a5 NUMBER
769 , p2_a6 NUMBER
770 , p2_a7 NUMBER
771 , p2_a8 NUMBER
772 , p2_a9 DATE
773 , p2_a10 DATE
774 , p2_a11 NUMBER
775 , p2_a12 NUMBER
776 , p2_a13 NUMBER
777 , p2_a14 VARCHAR2
778 , p2_a15 VARCHAR2
779 , p2_a16 VARCHAR2
780 , p2_a17 VARCHAR2
781 , x_return_status out nocopy VARCHAR2
782 , x_msg_count out nocopy NUMBER
783 , x_msg_data out nocopy VARCHAR2
784 , p6_a0 out nocopy JTF_NUMBER_TABLE
785 , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
786 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
787 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
788 , p6_a4 out nocopy JTF_NUMBER_TABLE
789 , p6_a5 out nocopy JTF_VARCHAR2_TABLE_300
790 , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
791 , p6_a7 out nocopy JTF_NUMBER_TABLE
792 , p6_a8 out nocopy JTF_VARCHAR2_TABLE_200
793 , p6_a9 out nocopy JTF_VARCHAR2_TABLE_2000
794 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
795 , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
796 , p6_a12 out nocopy JTF_NUMBER_TABLE
797 , p6_a13 out nocopy JTF_DATE_TABLE
798 , p6_a14 out nocopy JTF_DATE_TABLE
799 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
800 , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
801 , p6_a17 out nocopy JTF_DATE_TABLE
802 , p6_a18 out nocopy JTF_DATE_TABLE
803 , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
804 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_2000
805 , p6_a21 out nocopy JTF_DATE_TABLE
806 , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
807 , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
808 , p6_a24 out nocopy JTF_VARCHAR2_TABLE_100
809 , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
810 , p6_a26 out nocopy JTF_VARCHAR2_TABLE_100
811 , p6_a27 out nocopy JTF_NUMBER_TABLE
812 );
813 procedure get_contracts(p_api_version NUMBER
814 , p_init_msg_list VARCHAR2
815 , p2_a0 VARCHAR2
816 , p2_a1 VARCHAR2
817 , p2_a2 NUMBER
818 , p2_a3 NUMBER
819 , p2_a4 NUMBER
820 , p2_a5 NUMBER
821 , p2_a6 NUMBER
822 , p2_a7 NUMBER
823 , p2_a8 NUMBER
824 , p2_a9 NUMBER
825 , p2_a10 NUMBER
826 , p2_a11 NUMBER
827 , p2_a12 VARCHAR2
828 , p2_a13 VARCHAR2
829 , p2_a14 VARCHAR2
830 , x_return_status out nocopy VARCHAR2
831 , x_msg_count out nocopy NUMBER
832 , x_msg_data out nocopy VARCHAR2
833 , p6_a0 out nocopy JTF_NUMBER_TABLE
834 , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
835 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
836 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
837 , p6_a4 out nocopy JTF_NUMBER_TABLE
838 , p6_a5 out nocopy JTF_VARCHAR2_TABLE_300
839 , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
840 , p6_a7 out nocopy JTF_NUMBER_TABLE
841 , p6_a8 out nocopy JTF_VARCHAR2_TABLE_200
842 , p6_a9 out nocopy JTF_VARCHAR2_TABLE_2000
843 , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
844 , p6_a11 out nocopy JTF_NUMBER_TABLE
845 , p6_a12 out nocopy JTF_DATE_TABLE
846 , p6_a13 out nocopy JTF_DATE_TABLE
847 , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
848 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
849 , p6_a16 out nocopy JTF_DATE_TABLE
850 , p6_a17 out nocopy JTF_DATE_TABLE
851 , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
852 , p6_a19 out nocopy JTF_VARCHAR2_TABLE_2000
853 , p6_a20 out nocopy JTF_DATE_TABLE
854 , p6_a21 out nocopy JTF_NUMBER_TABLE
855 );
856 procedure get_contracts(p_api_version NUMBER
857 , p_init_msg_list VARCHAR2
858 , p2_a0 VARCHAR2
859 , p2_a1 VARCHAR2
860 , p2_a2 NUMBER
861 , p2_a3 NUMBER
862 , p2_a4 NUMBER
863 , p2_a5 NUMBER
864 , p2_a6 NUMBER
865 , p2_a7 NUMBER
866 , p2_a8 NUMBER
867 , p2_a9 NUMBER
868 , p2_a10 DATE
869 , p2_a11 VARCHAR2
870 , x_return_status out nocopy VARCHAR2
871 , x_msg_count out nocopy NUMBER
872 , x_msg_data out nocopy VARCHAR2
873 , p6_a0 out nocopy JTF_NUMBER_TABLE
874 , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
875 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
876 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_300
877 , p6_a4 out nocopy JTF_VARCHAR2_TABLE_600
878 , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
879 , p6_a6 out nocopy JTF_DATE_TABLE
880 , p6_a7 out nocopy JTF_DATE_TABLE
881 , p6_a8 out nocopy JTF_DATE_TABLE
882 );
883 procedure validate_contract_line(p_api_version NUMBER
884 , p_init_msg_list VARCHAR2
885 , p_contract_line_id NUMBER
886 , p_busiproc_id NUMBER
887 , p_request_date date
888 , p5_a0 JTF_VARCHAR2_TABLE_100
889 , p5_a1 JTF_NUMBER_TABLE
890 , p5_a2 JTF_NUMBER_TABLE
891 , p5_a3 JTF_VARCHAR2_TABLE_100
892 , p_verify_combination VARCHAR2
893 , x_return_status out nocopy VARCHAR2
894 , x_msg_count out nocopy NUMBER
895 , x_msg_data out nocopy VARCHAR2
896 , p10_a0 out nocopy JTF_VARCHAR2_TABLE_100
897 , p10_a1 out nocopy JTF_NUMBER_TABLE
898 , p10_a2 out nocopy JTF_NUMBER_TABLE
899 , p10_a3 out nocopy JTF_VARCHAR2_TABLE_100
900 , x_combination_valid out nocopy VARCHAR2
901 );
902 procedure search_contracts(p_api_version NUMBER
903 , p_init_msg_list VARCHAR2
904 , p2_a0 VARCHAR2
905 , p2_a1 VARCHAR2
906 , p2_a2 VARCHAR2
907 , p2_a3 DATE
908 , p2_a4 DATE
909 , p2_a5 DATE
910 , p2_a6 DATE
911 , p2_a7 DATE
912 , p2_a8 DATE
913 , p2_a9 NUMBER
914 , p2_a10 DATE
915 , p2_a11 VARCHAR2
916 , p3_a0 JTF_NUMBER_TABLE
917 , p3_a1 JTF_VARCHAR2_TABLE_100
918 , x_return_status out nocopy VARCHAR2
919 , x_msg_count out nocopy NUMBER
920 , x_msg_data out nocopy VARCHAR2
921 , p7_a0 out nocopy JTF_VARCHAR2_TABLE_200
922 , p7_a1 out nocopy JTF_VARCHAR2_TABLE_200
923 , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
924 , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
925 , p7_a4 out nocopy JTF_VARCHAR2_TABLE_300
926 , p7_a5 out nocopy JTF_VARCHAR2_TABLE_2000
927 , p7_a6 out nocopy JTF_DATE_TABLE
928 , p7_a7 out nocopy JTF_DATE_TABLE
929 , p7_a8 out nocopy JTF_DATE_TABLE
930 , p7_a9 out nocopy JTF_NUMBER_TABLE
931 , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
932 , p7_a11 out nocopy JTF_VARCHAR2_TABLE_100
933 , p7_a12 out nocopy JTF_VARCHAR2_TABLE_100
934 );
935 procedure get_react_resolve_by_time(p_api_version NUMBER
936 , p_init_msg_list VARCHAR2
937 , p2_a0 NUMBER
938 , p2_a1 NUMBER
939 , p2_a2 NUMBER
940 , p2_a3 DATE
941 , p2_a4 NUMBER
942 , p2_a5 VARCHAR2
943 , p2_a6 VARCHAR2
944 , p2_a7 VARCHAR2
945 , p2_a8 VARCHAR2
946 , x_return_status out nocopy VARCHAR2
947 , x_msg_count out nocopy NUMBER
948 , x_msg_data out nocopy VARCHAR2
949 , p6_a0 out nocopy NUMBER
950 , p6_a1 out nocopy VARCHAR2
951 , p6_a2 out nocopy DATE
952 , p6_a3 out nocopy DATE
953 , p7_a0 out nocopy NUMBER
954 , p7_a1 out nocopy VARCHAR2
955 , p7_a2 out nocopy DATE
956 , p7_a3 out nocopy DATE
957 );
958 procedure get_coverage_type(p_api_version NUMBER
959 , p_init_msg_list VARCHAR2
960 , p_contract_line_id NUMBER
961 , x_return_status out nocopy VARCHAR2
962 , x_msg_count out nocopy NUMBER
963 , x_msg_data out nocopy VARCHAR2
964 , p6_a0 out nocopy VARCHAR2
965 , p6_a1 out nocopy VARCHAR2
966 , p6_a2 out nocopy NUMBER
967 );
968 procedure get_highimp_cp_contract(p_api_version NUMBER
969 , p_init_msg_list VARCHAR2
970 , p_customer_product_id NUMBER
971 , x_return_status out nocopy VARCHAR2
972 , x_msg_count out nocopy NUMBER
973 , x_msg_data out nocopy VARCHAR2
974 , p6_a0 out nocopy VARCHAR2
975 , p6_a1 out nocopy VARCHAR2
976 , p6_a2 out nocopy VARCHAR2
977 , p6_a3 out nocopy DATE
978 , p6_a4 out nocopy DATE
979 , p6_a5 out nocopy NUMBER
980 , p6_a6 out nocopy VARCHAR2
981 , p6_a7 out nocopy NUMBER
982 );
983 procedure check_coverage_times(p_api_version NUMBER
984 , p_init_msg_list VARCHAR2
985 , p_business_process_id NUMBER
986 , p_request_date date
987 , p_time_zone_id NUMBER
988 , p_dates_in_input_tz VARCHAR2
989 , p_contract_line_id NUMBER
990 , x_return_status out nocopy VARCHAR2
991 , x_msg_count out nocopy NUMBER
992 , x_msg_data out nocopy VARCHAR2
993 , x_covered_yn out nocopy VARCHAR2
994 );
995 procedure check_reaction_times(p_api_version NUMBER
996 , p_init_msg_list VARCHAR2
997 , p_business_process_id NUMBER
998 , p_request_date date
999 , p_sr_severity NUMBER
1000 , p_time_zone_id NUMBER
1001 , p_dates_in_input_tz VARCHAR2
1002 , p_contract_line_id NUMBER
1003 , x_return_status out nocopy VARCHAR2
1004 , x_msg_count out nocopy NUMBER
1005 , x_msg_data out nocopy VARCHAR2
1006 , x_react_within out nocopy NUMBER
1007 , x_react_tuom out nocopy VARCHAR2
1008 , x_react_by_date out nocopy DATE
1009 );
1010 procedure get_contacts(p_api_version NUMBER
1011 , p_init_msg_list VARCHAR2
1012 , p_contract_id NUMBER
1013 , p_contract_line_id NUMBER
1014 , x_return_status out nocopy VARCHAR2
1015 , x_msg_count out nocopy NUMBER
1016 , x_msg_data out nocopy VARCHAR2
1017 , p7_a0 out nocopy JTF_NUMBER_TABLE
1018 , p7_a1 out nocopy JTF_NUMBER_TABLE
1019 , p7_a2 out nocopy JTF_NUMBER_TABLE
1020 , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
1021 , p7_a4 out nocopy JTF_NUMBER_TABLE
1022 , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
1023 , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100
1024 );
1025 procedure get_preferred_engineers(p_api_version NUMBER
1026 , p_init_msg_list VARCHAR2
1027 , p_contract_line_id NUMBER
1028 , p_business_process_id NUMBER
1029 , p_request_date date
1030 , x_return_status out nocopy VARCHAR2
1031 , x_msg_count out nocopy NUMBER
1032 , x_msg_data out nocopy VARCHAR2
1033 , p8_a0 out nocopy JTF_NUMBER_TABLE
1034 , p8_a1 out nocopy JTF_NUMBER_TABLE
1035 , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
1036 , p8_a3 out nocopy JTF_VARCHAR2_TABLE_100
1037 , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100
1038 );
1039 procedure oks_validate_system(p_api_version NUMBER
1040 , p_init_msg_list VARCHAR2
1041 , p_system_id NUMBER
1042 , p_request_date date
1043 , p_update_only_check VARCHAR2
1044 , x_return_status out nocopy VARCHAR2
1045 , x_msg_count out nocopy NUMBER
1046 , x_msg_data out nocopy VARCHAR2
1047 , x_system_valid out nocopy VARCHAR2
1048 );
1049 procedure default_contline_system(p_api_version NUMBER
1050 , p_init_msg_list VARCHAR2
1051 , p_system_id NUMBER
1052 , p_request_date date
1053 , x_return_status out nocopy VARCHAR2
1054 , x_msg_count out nocopy NUMBER
1055 , x_msg_data out nocopy VARCHAR2
1056 , p7_a0 out nocopy NUMBER
1057 , p7_a1 out nocopy VARCHAR2
1058 , p7_a2 out nocopy VARCHAR2
1059 , p7_a3 out nocopy VARCHAR2
1060 , p7_a4 out nocopy NUMBER
1061 , p7_a5 out nocopy VARCHAR2
1062 , p7_a6 out nocopy VARCHAR2
1063 , p7_a7 out nocopy NUMBER
1064 , p7_a8 out nocopy VARCHAR2
1065 , p7_a9 out nocopy VARCHAR2
1066 , p7_a10 out nocopy VARCHAR2
1067 , p7_a11 out nocopy VARCHAR2
1068 , p7_a12 out nocopy NUMBER
1069 , p7_a13 out nocopy DATE
1070 , p7_a14 out nocopy DATE
1071 , p7_a15 out nocopy VARCHAR2
1072 , p7_a16 out nocopy VARCHAR2
1073 , p7_a17 out nocopy DATE
1074 , p7_a18 out nocopy DATE
1075 , p7_a19 out nocopy VARCHAR2
1076 , p7_a20 out nocopy VARCHAR2
1077 , p7_a21 out nocopy DATE
1078 , p7_a22 out nocopy VARCHAR2
1079 , p7_a23 out nocopy VARCHAR2
1080 , p7_a24 out nocopy VARCHAR2
1081 , p7_a25 out nocopy VARCHAR2
1082 , p7_a26 out nocopy VARCHAR2
1083 , p7_a27 out nocopy NUMBER
1084 );
1085 procedure get_cov_txn_groups(p_api_version NUMBER
1086 , p_init_msg_list VARCHAR2
1087 , p2_a0 NUMBER
1088 , p2_a1 VARCHAR2
1089 , p2_a2 VARCHAR2
1090 , p2_a3 VARCHAR2
1091 , p2_a4 VARCHAR2
1092 , x_return_status out nocopy VARCHAR2
1093 , x_msg_count out nocopy NUMBER
1094 , x_msg_data out nocopy VARCHAR2
1095 , p6_a0 out nocopy JTF_NUMBER_TABLE
1096 , p6_a1 out nocopy JTF_NUMBER_TABLE
1097 , p6_a2 out nocopy JTF_DATE_TABLE
1098 , p6_a3 out nocopy JTF_DATE_TABLE
1099 );
1100 procedure get_txn_billing_types(p_api_version NUMBER
1101 , p_init_msg_list VARCHAR2
1102 , p_cov_txngrp_line_id NUMBER
1103 , p_return_bill_rates_yn VARCHAR2
1104 , x_return_status out nocopy VARCHAR2
1105 , x_msg_count out nocopy NUMBER
1106 , x_msg_data out nocopy VARCHAR2
1107 , p7_a0 out nocopy JTF_NUMBER_TABLE
1108 , p7_a1 out nocopy JTF_NUMBER_TABLE
1109 , p7_a2 out nocopy JTF_NUMBER_TABLE
1110 , p7_a3 out nocopy JTF_NUMBER_TABLE
1111 , p8_a0 out nocopy JTF_NUMBER_TABLE
1112 , p8_a1 out nocopy JTF_NUMBER_TABLE
1113 , p8_a2 out nocopy JTF_NUMBER_TABLE
1114 , p8_a3 out nocopy JTF_VARCHAR2_TABLE_100
1115 , p8_a4 out nocopy JTF_NUMBER_TABLE
1116 , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
1117 , p8_a6 out nocopy JTF_NUMBER_TABLE
1118 , p8_a7 out nocopy JTF_NUMBER_TABLE
1119 , p8_a8 out nocopy JTF_NUMBER_TABLE
1120 , p8_a9 out nocopy JTF_NUMBER_TABLE
1121 , p8_a10 out nocopy JTF_NUMBER_TABLE
1122 , p8_a11 out nocopy JTF_VARCHAR2_TABLE_100
1123 , p8_a12 out nocopy JTF_VARCHAR2_TABLE_100
1124 , p8_a13 out nocopy JTF_VARCHAR2_TABLE_100
1125 , p8_a14 out nocopy JTF_VARCHAR2_TABLE_100
1126 , p8_a15 out nocopy JTF_VARCHAR2_TABLE_100
1127 , p8_a16 out nocopy JTF_VARCHAR2_TABLE_100
1128 , p8_a17 out nocopy JTF_VARCHAR2_TABLE_100
1129 , p8_a18 out nocopy JTF_NUMBER_TABLE
1130 , p8_a19 out nocopy JTF_NUMBER_TABLE
1131 , p8_a20 out nocopy JTF_VARCHAR2_TABLE_100
1132 );
1133 procedure search_contract_lines(p_api_version NUMBER
1134 , p_init_msg_list VARCHAR2
1135 , p2_a0 NUMBER
1136 , p2_a1 VARCHAR2
1137 , p2_a2 VARCHAR2
1138 , p2_a3 VARCHAR2
1139 , p2_a4 DATE
1140 , p2_a5 DATE
1141 , p2_a6 DATE
1142 , p2_a7 DATE
1143 , p2_a8 DATE
1144 , p2_a9 DATE
1145 , p2_a10 NUMBER
1146 , p2_a11 VARCHAR2
1147 , p2_a12 DATE
1148 , p2_a13 VARCHAR2
1149 , p2_a14 NUMBER
1150 , p2_a15 NUMBER
1151 , p3_a0 NUMBER
1152 , p3_a1 VARCHAR2
1153 , p3_a2 VARCHAR2
1154 , p3_a3 DATE
1155 , p3_a4 DATE
1156 , p3_a5 DATE
1157 , p3_a6 DATE
1158 , p3_a7 NUMBER
1159 , p3_a8 NUMBER
1160 , p3_a9 VARCHAR2
1161 , p4_a0 JTF_NUMBER_TABLE
1162 , p4_a1 JTF_NUMBER_TABLE
1163 , p4_a2 JTF_VARCHAR2_TABLE_100
1164 , x_return_status out nocopy VARCHAR2
1165 , x_msg_count out nocopy NUMBER
1166 , x_msg_data out nocopy VARCHAR2
1167 , p8_a0 out nocopy JTF_VARCHAR2_TABLE_200
1168 , p8_a1 out nocopy JTF_VARCHAR2_TABLE_200
1169 , p8_a2 out nocopy JTF_VARCHAR2_TABLE_200
1170 , p8_a3 out nocopy JTF_VARCHAR2_TABLE_200
1171 , p8_a4 out nocopy JTF_VARCHAR2_TABLE_2000
1172 , p8_a5 out nocopy JTF_VARCHAR2_TABLE_2000
1173 , p8_a6 out nocopy JTF_DATE_TABLE
1174 , p8_a7 out nocopy JTF_DATE_TABLE
1175 , p8_a8 out nocopy JTF_VARCHAR2_TABLE_100
1176 , p8_a9 out nocopy JTF_VARCHAR2_TABLE_200
1177 , p8_a10 out nocopy JTF_NUMBER_TABLE
1178 , p8_a11 out nocopy JTF_NUMBER_TABLE
1179 , p8_a12 out nocopy JTF_NUMBER_TABLE
1180 , p8_a13 out nocopy JTF_NUMBER_TABLE
1181 , p8_a14 out nocopy JTF_NUMBER_TABLE
1182 , p8_a15 out nocopy JTF_VARCHAR2_TABLE_100
1183 , p8_a16 out nocopy JTF_NUMBER_TABLE
1184 , p8_a17 out nocopy JTF_VARCHAR2_TABLE_300
1185 );
1186 end oks_entitlements_pub_w;