1: package okl_srv_pvt_w as
2: /* $Header: OKLISRVS.pls 120.0 2005/07/07 10:41:04 viselvar noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_srv_pvt.okl_srv_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_VARCHAR2_TABLE_500
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_VARCHAR2_TABLE_500
18: , a15 JTF_VARCHAR2_TABLE_500
19: , a16 JTF_VARCHAR2_TABLE_500
20: , a17 JTF_VARCHAR2_TABLE_500
36: , a33 JTF_NUMBER_TABLE
37: );
38: procedure rosetta_table_copy_out_p1(t okl_srv_pvt.okl_srv_tbl, a0 out nocopy JTF_NUMBER_TABLE
39: , a1 out nocopy JTF_NUMBER_TABLE
40: , a2 out nocopy JTF_VARCHAR2_TABLE_100
41: , a3 out nocopy JTF_NUMBER_TABLE
42: , a4 out nocopy JTF_DATE_TABLE
43: , a5 out nocopy JTF_DATE_TABLE
44: , a6 out nocopy JTF_VARCHAR2_TABLE_100
40: , a2 out nocopy JTF_VARCHAR2_TABLE_100
41: , a3 out nocopy JTF_NUMBER_TABLE
42: , a4 out nocopy JTF_DATE_TABLE
43: , a5 out nocopy JTF_DATE_TABLE
44: , a6 out nocopy JTF_VARCHAR2_TABLE_100
45: , a7 out nocopy JTF_NUMBER_TABLE
46: , a8 out nocopy JTF_NUMBER_TABLE
47: , a9 out nocopy JTF_NUMBER_TABLE
48: , a10 out nocopy JTF_VARCHAR2_TABLE_100
44: , a6 out nocopy JTF_VARCHAR2_TABLE_100
45: , a7 out nocopy JTF_NUMBER_TABLE
46: , a8 out nocopy JTF_NUMBER_TABLE
47: , a9 out nocopy JTF_NUMBER_TABLE
48: , a10 out nocopy JTF_VARCHAR2_TABLE_100
49: , a11 out nocopy JTF_NUMBER_TABLE
50: , a12 out nocopy JTF_NUMBER_TABLE
51: , a13 out nocopy JTF_VARCHAR2_TABLE_100
52: , a14 out nocopy JTF_VARCHAR2_TABLE_500
47: , a9 out nocopy JTF_NUMBER_TABLE
48: , a10 out nocopy JTF_VARCHAR2_TABLE_100
49: , a11 out nocopy JTF_NUMBER_TABLE
50: , a12 out nocopy JTF_NUMBER_TABLE
51: , a13 out nocopy JTF_VARCHAR2_TABLE_100
52: , a14 out nocopy JTF_VARCHAR2_TABLE_500
53: , a15 out nocopy JTF_VARCHAR2_TABLE_500
54: , a16 out nocopy JTF_VARCHAR2_TABLE_500
55: , a17 out nocopy JTF_VARCHAR2_TABLE_500
151: , x_msg_count out nocopy NUMBER
152: , x_msg_data out nocopy VARCHAR2
153: , p5_a0 JTF_NUMBER_TABLE
154: , p5_a1 JTF_NUMBER_TABLE
155: , p5_a2 JTF_VARCHAR2_TABLE_100
156: , p5_a3 JTF_NUMBER_TABLE
157: , p5_a4 JTF_DATE_TABLE
158: , p5_a5 JTF_DATE_TABLE
159: , p5_a6 JTF_VARCHAR2_TABLE_100
155: , p5_a2 JTF_VARCHAR2_TABLE_100
156: , p5_a3 JTF_NUMBER_TABLE
157: , p5_a4 JTF_DATE_TABLE
158: , p5_a5 JTF_DATE_TABLE
159: , p5_a6 JTF_VARCHAR2_TABLE_100
160: , p5_a7 JTF_NUMBER_TABLE
161: , p5_a8 JTF_NUMBER_TABLE
162: , p5_a9 JTF_NUMBER_TABLE
163: , p5_a10 JTF_VARCHAR2_TABLE_100
159: , p5_a6 JTF_VARCHAR2_TABLE_100
160: , p5_a7 JTF_NUMBER_TABLE
161: , p5_a8 JTF_NUMBER_TABLE
162: , p5_a9 JTF_NUMBER_TABLE
163: , p5_a10 JTF_VARCHAR2_TABLE_100
164: , p5_a11 JTF_NUMBER_TABLE
165: , p5_a12 JTF_NUMBER_TABLE
166: , p5_a13 JTF_VARCHAR2_TABLE_100
167: , p5_a14 JTF_VARCHAR2_TABLE_500
162: , p5_a9 JTF_NUMBER_TABLE
163: , p5_a10 JTF_VARCHAR2_TABLE_100
164: , p5_a11 JTF_NUMBER_TABLE
165: , p5_a12 JTF_NUMBER_TABLE
166: , p5_a13 JTF_VARCHAR2_TABLE_100
167: , p5_a14 JTF_VARCHAR2_TABLE_500
168: , p5_a15 JTF_VARCHAR2_TABLE_500
169: , p5_a16 JTF_VARCHAR2_TABLE_500
170: , p5_a17 JTF_VARCHAR2_TABLE_500
185: , p5_a32 JTF_DATE_TABLE
186: , p5_a33 JTF_NUMBER_TABLE
187: , p6_a0 out nocopy JTF_NUMBER_TABLE
188: , p6_a1 out nocopy JTF_NUMBER_TABLE
189: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
190: , p6_a3 out nocopy JTF_NUMBER_TABLE
191: , p6_a4 out nocopy JTF_DATE_TABLE
192: , p6_a5 out nocopy JTF_DATE_TABLE
193: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
189: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
190: , p6_a3 out nocopy JTF_NUMBER_TABLE
191: , p6_a4 out nocopy JTF_DATE_TABLE
192: , p6_a5 out nocopy JTF_DATE_TABLE
193: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
194: , p6_a7 out nocopy JTF_NUMBER_TABLE
195: , p6_a8 out nocopy JTF_NUMBER_TABLE
196: , p6_a9 out nocopy JTF_NUMBER_TABLE
197: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
193: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
194: , p6_a7 out nocopy JTF_NUMBER_TABLE
195: , p6_a8 out nocopy JTF_NUMBER_TABLE
196: , p6_a9 out nocopy JTF_NUMBER_TABLE
197: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
198: , p6_a11 out nocopy JTF_NUMBER_TABLE
199: , p6_a12 out nocopy JTF_NUMBER_TABLE
200: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
201: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
196: , p6_a9 out nocopy JTF_NUMBER_TABLE
197: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
198: , p6_a11 out nocopy JTF_NUMBER_TABLE
199: , p6_a12 out nocopy JTF_NUMBER_TABLE
200: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
201: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
202: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
203: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
204: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
299: , x_msg_count out nocopy NUMBER
300: , x_msg_data out nocopy VARCHAR2
301: , p5_a0 JTF_NUMBER_TABLE
302: , p5_a1 JTF_NUMBER_TABLE
303: , p5_a2 JTF_VARCHAR2_TABLE_100
304: , p5_a3 JTF_NUMBER_TABLE
305: , p5_a4 JTF_DATE_TABLE
306: , p5_a5 JTF_DATE_TABLE
307: , p5_a6 JTF_VARCHAR2_TABLE_100
303: , p5_a2 JTF_VARCHAR2_TABLE_100
304: , p5_a3 JTF_NUMBER_TABLE
305: , p5_a4 JTF_DATE_TABLE
306: , p5_a5 JTF_DATE_TABLE
307: , p5_a6 JTF_VARCHAR2_TABLE_100
308: , p5_a7 JTF_NUMBER_TABLE
309: , p5_a8 JTF_NUMBER_TABLE
310: , p5_a9 JTF_NUMBER_TABLE
311: , p5_a10 JTF_VARCHAR2_TABLE_100
307: , p5_a6 JTF_VARCHAR2_TABLE_100
308: , p5_a7 JTF_NUMBER_TABLE
309: , p5_a8 JTF_NUMBER_TABLE
310: , p5_a9 JTF_NUMBER_TABLE
311: , p5_a10 JTF_VARCHAR2_TABLE_100
312: , p5_a11 JTF_NUMBER_TABLE
313: , p5_a12 JTF_NUMBER_TABLE
314: , p5_a13 JTF_VARCHAR2_TABLE_100
315: , p5_a14 JTF_VARCHAR2_TABLE_500
310: , p5_a9 JTF_NUMBER_TABLE
311: , p5_a10 JTF_VARCHAR2_TABLE_100
312: , p5_a11 JTF_NUMBER_TABLE
313: , p5_a12 JTF_NUMBER_TABLE
314: , p5_a13 JTF_VARCHAR2_TABLE_100
315: , p5_a14 JTF_VARCHAR2_TABLE_500
316: , p5_a15 JTF_VARCHAR2_TABLE_500
317: , p5_a16 JTF_VARCHAR2_TABLE_500
318: , p5_a17 JTF_VARCHAR2_TABLE_500
333: , p5_a32 JTF_DATE_TABLE
334: , p5_a33 JTF_NUMBER_TABLE
335: , p6_a0 out nocopy JTF_NUMBER_TABLE
336: , p6_a1 out nocopy JTF_NUMBER_TABLE
337: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
338: , p6_a3 out nocopy JTF_NUMBER_TABLE
339: , p6_a4 out nocopy JTF_DATE_TABLE
340: , p6_a5 out nocopy JTF_DATE_TABLE
341: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
337: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
338: , p6_a3 out nocopy JTF_NUMBER_TABLE
339: , p6_a4 out nocopy JTF_DATE_TABLE
340: , p6_a5 out nocopy JTF_DATE_TABLE
341: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
342: , p6_a7 out nocopy JTF_NUMBER_TABLE
343: , p6_a8 out nocopy JTF_NUMBER_TABLE
344: , p6_a9 out nocopy JTF_NUMBER_TABLE
345: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
341: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
342: , p6_a7 out nocopy JTF_NUMBER_TABLE
343: , p6_a8 out nocopy JTF_NUMBER_TABLE
344: , p6_a9 out nocopy JTF_NUMBER_TABLE
345: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
346: , p6_a11 out nocopy JTF_NUMBER_TABLE
347: , p6_a12 out nocopy JTF_NUMBER_TABLE
348: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
349: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
344: , p6_a9 out nocopy JTF_NUMBER_TABLE
345: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
346: , p6_a11 out nocopy JTF_NUMBER_TABLE
347: , p6_a12 out nocopy JTF_NUMBER_TABLE
348: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
349: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
350: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
351: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
352: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
413: , x_msg_count out nocopy NUMBER
414: , x_msg_data out nocopy VARCHAR2
415: , p5_a0 JTF_NUMBER_TABLE
416: , p5_a1 JTF_NUMBER_TABLE
417: , p5_a2 JTF_VARCHAR2_TABLE_100
418: , p5_a3 JTF_NUMBER_TABLE
419: , p5_a4 JTF_DATE_TABLE
420: , p5_a5 JTF_DATE_TABLE
421: , p5_a6 JTF_VARCHAR2_TABLE_100
417: , p5_a2 JTF_VARCHAR2_TABLE_100
418: , p5_a3 JTF_NUMBER_TABLE
419: , p5_a4 JTF_DATE_TABLE
420: , p5_a5 JTF_DATE_TABLE
421: , p5_a6 JTF_VARCHAR2_TABLE_100
422: , p5_a7 JTF_NUMBER_TABLE
423: , p5_a8 JTF_NUMBER_TABLE
424: , p5_a9 JTF_NUMBER_TABLE
425: , p5_a10 JTF_VARCHAR2_TABLE_100
421: , p5_a6 JTF_VARCHAR2_TABLE_100
422: , p5_a7 JTF_NUMBER_TABLE
423: , p5_a8 JTF_NUMBER_TABLE
424: , p5_a9 JTF_NUMBER_TABLE
425: , p5_a10 JTF_VARCHAR2_TABLE_100
426: , p5_a11 JTF_NUMBER_TABLE
427: , p5_a12 JTF_NUMBER_TABLE
428: , p5_a13 JTF_VARCHAR2_TABLE_100
429: , p5_a14 JTF_VARCHAR2_TABLE_500
424: , p5_a9 JTF_NUMBER_TABLE
425: , p5_a10 JTF_VARCHAR2_TABLE_100
426: , p5_a11 JTF_NUMBER_TABLE
427: , p5_a12 JTF_NUMBER_TABLE
428: , p5_a13 JTF_VARCHAR2_TABLE_100
429: , p5_a14 JTF_VARCHAR2_TABLE_500
430: , p5_a15 JTF_VARCHAR2_TABLE_500
431: , p5_a16 JTF_VARCHAR2_TABLE_500
432: , p5_a17 JTF_VARCHAR2_TABLE_500