1: package okl_idi_pvt_w as
2: /* $Header: OKLIIDIS.pls 120.1 2005/07/13 09:26:36 asawanka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_idi_pvt.idi_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_200
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_200
9: , a6 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_200
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_200
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_2000
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_DATE_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_200
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_2000
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_DATE_TABLE
13: , a10 JTF_DATE_TABLE
14: , a11 JTF_NUMBER_TABLE
37: , a34 JTF_NUMBER_TABLE
38: );
39: procedure rosetta_table_copy_out_p2(t okl_idi_pvt.idi_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
40: , a1 out nocopy JTF_NUMBER_TABLE
41: , a2 out nocopy JTF_VARCHAR2_TABLE_200
42: , a3 out nocopy JTF_NUMBER_TABLE
43: , a4 out nocopy JTF_NUMBER_TABLE
44: , a5 out nocopy JTF_VARCHAR2_TABLE_200
45: , a6 out nocopy JTF_NUMBER_TABLE
40: , a1 out nocopy JTF_NUMBER_TABLE
41: , a2 out nocopy JTF_VARCHAR2_TABLE_200
42: , a3 out nocopy JTF_NUMBER_TABLE
43: , a4 out nocopy JTF_NUMBER_TABLE
44: , a5 out nocopy JTF_VARCHAR2_TABLE_200
45: , a6 out nocopy JTF_NUMBER_TABLE
46: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
47: , a8 out nocopy JTF_NUMBER_TABLE
48: , a9 out nocopy JTF_DATE_TABLE
42: , a3 out nocopy JTF_NUMBER_TABLE
43: , a4 out nocopy JTF_NUMBER_TABLE
44: , a5 out nocopy JTF_VARCHAR2_TABLE_200
45: , a6 out nocopy JTF_NUMBER_TABLE
46: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
47: , a8 out nocopy JTF_NUMBER_TABLE
48: , a9 out nocopy JTF_DATE_TABLE
49: , a10 out nocopy JTF_DATE_TABLE
50: , a11 out nocopy JTF_NUMBER_TABLE
74: );
75:
76: procedure rosetta_table_copy_in_p5(t out nocopy okl_idi_pvt.idiv_tbl_type, a0 JTF_NUMBER_TABLE
77: , a1 JTF_NUMBER_TABLE
78: , a2 JTF_VARCHAR2_TABLE_200
79: , a3 JTF_NUMBER_TABLE
80: , a4 JTF_NUMBER_TABLE
81: , a5 JTF_VARCHAR2_TABLE_200
82: , a6 JTF_VARCHAR2_TABLE_2000
77: , a1 JTF_NUMBER_TABLE
78: , a2 JTF_VARCHAR2_TABLE_200
79: , a3 JTF_NUMBER_TABLE
80: , a4 JTF_NUMBER_TABLE
81: , a5 JTF_VARCHAR2_TABLE_200
82: , a6 JTF_VARCHAR2_TABLE_2000
83: , a7 JTF_NUMBER_TABLE
84: , a8 JTF_DATE_TABLE
85: , a9 JTF_DATE_TABLE
78: , a2 JTF_VARCHAR2_TABLE_200
79: , a3 JTF_NUMBER_TABLE
80: , a4 JTF_NUMBER_TABLE
81: , a5 JTF_VARCHAR2_TABLE_200
82: , a6 JTF_VARCHAR2_TABLE_2000
83: , a7 JTF_NUMBER_TABLE
84: , a8 JTF_DATE_TABLE
85: , a9 JTF_DATE_TABLE
86: , a10 JTF_VARCHAR2_TABLE_100
110: , a34 JTF_NUMBER_TABLE
111: );
112: procedure rosetta_table_copy_out_p5(t okl_idi_pvt.idiv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
113: , a1 out nocopy JTF_NUMBER_TABLE
114: , a2 out nocopy JTF_VARCHAR2_TABLE_200
115: , a3 out nocopy JTF_NUMBER_TABLE
116: , a4 out nocopy JTF_NUMBER_TABLE
117: , a5 out nocopy JTF_VARCHAR2_TABLE_200
118: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
113: , a1 out nocopy JTF_NUMBER_TABLE
114: , a2 out nocopy JTF_VARCHAR2_TABLE_200
115: , a3 out nocopy JTF_NUMBER_TABLE
116: , a4 out nocopy JTF_NUMBER_TABLE
117: , a5 out nocopy JTF_VARCHAR2_TABLE_200
118: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
119: , a7 out nocopy JTF_NUMBER_TABLE
120: , a8 out nocopy JTF_DATE_TABLE
121: , a9 out nocopy JTF_DATE_TABLE
114: , a2 out nocopy JTF_VARCHAR2_TABLE_200
115: , a3 out nocopy JTF_NUMBER_TABLE
116: , a4 out nocopy JTF_NUMBER_TABLE
117: , a5 out nocopy JTF_VARCHAR2_TABLE_200
118: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
119: , a7 out nocopy JTF_NUMBER_TABLE
120: , a8 out nocopy JTF_DATE_TABLE
121: , a9 out nocopy JTF_DATE_TABLE
122: , a10 out nocopy JTF_VARCHAR2_TABLE_100
228: , x_msg_count out nocopy NUMBER
229: , x_msg_data out nocopy VARCHAR2
230: , p5_a0 JTF_NUMBER_TABLE
231: , p5_a1 JTF_NUMBER_TABLE
232: , p5_a2 JTF_VARCHAR2_TABLE_200
233: , p5_a3 JTF_NUMBER_TABLE
234: , p5_a4 JTF_NUMBER_TABLE
235: , p5_a5 JTF_VARCHAR2_TABLE_200
236: , p5_a6 JTF_VARCHAR2_TABLE_2000
231: , p5_a1 JTF_NUMBER_TABLE
232: , p5_a2 JTF_VARCHAR2_TABLE_200
233: , p5_a3 JTF_NUMBER_TABLE
234: , p5_a4 JTF_NUMBER_TABLE
235: , p5_a5 JTF_VARCHAR2_TABLE_200
236: , p5_a6 JTF_VARCHAR2_TABLE_2000
237: , p5_a7 JTF_NUMBER_TABLE
238: , p5_a8 JTF_DATE_TABLE
239: , p5_a9 JTF_DATE_TABLE
232: , p5_a2 JTF_VARCHAR2_TABLE_200
233: , p5_a3 JTF_NUMBER_TABLE
234: , p5_a4 JTF_NUMBER_TABLE
235: , p5_a5 JTF_VARCHAR2_TABLE_200
236: , p5_a6 JTF_VARCHAR2_TABLE_2000
237: , p5_a7 JTF_NUMBER_TABLE
238: , p5_a8 JTF_DATE_TABLE
239: , p5_a9 JTF_DATE_TABLE
240: , p5_a10 JTF_VARCHAR2_TABLE_100
263: , p5_a33 JTF_DATE_TABLE
264: , p5_a34 JTF_NUMBER_TABLE
265: , p6_a0 out nocopy JTF_NUMBER_TABLE
266: , p6_a1 out nocopy JTF_NUMBER_TABLE
267: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
268: , p6_a3 out nocopy JTF_NUMBER_TABLE
269: , p6_a4 out nocopy JTF_NUMBER_TABLE
270: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
271: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
266: , p6_a1 out nocopy JTF_NUMBER_TABLE
267: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
268: , p6_a3 out nocopy JTF_NUMBER_TABLE
269: , p6_a4 out nocopy JTF_NUMBER_TABLE
270: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
271: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
272: , p6_a7 out nocopy JTF_NUMBER_TABLE
273: , p6_a8 out nocopy JTF_DATE_TABLE
274: , p6_a9 out nocopy JTF_DATE_TABLE
267: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
268: , p6_a3 out nocopy JTF_NUMBER_TABLE
269: , p6_a4 out nocopy JTF_NUMBER_TABLE
270: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
271: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
272: , p6_a7 out nocopy JTF_NUMBER_TABLE
273: , p6_a8 out nocopy JTF_DATE_TABLE
274: , p6_a9 out nocopy JTF_DATE_TABLE
275: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
345: , x_msg_count out nocopy NUMBER
346: , x_msg_data out nocopy VARCHAR2
347: , p5_a0 JTF_NUMBER_TABLE
348: , p5_a1 JTF_NUMBER_TABLE
349: , p5_a2 JTF_VARCHAR2_TABLE_200
350: , p5_a3 JTF_NUMBER_TABLE
351: , p5_a4 JTF_NUMBER_TABLE
352: , p5_a5 JTF_VARCHAR2_TABLE_200
353: , p5_a6 JTF_VARCHAR2_TABLE_2000
348: , p5_a1 JTF_NUMBER_TABLE
349: , p5_a2 JTF_VARCHAR2_TABLE_200
350: , p5_a3 JTF_NUMBER_TABLE
351: , p5_a4 JTF_NUMBER_TABLE
352: , p5_a5 JTF_VARCHAR2_TABLE_200
353: , p5_a6 JTF_VARCHAR2_TABLE_2000
354: , p5_a7 JTF_NUMBER_TABLE
355: , p5_a8 JTF_DATE_TABLE
356: , p5_a9 JTF_DATE_TABLE
349: , p5_a2 JTF_VARCHAR2_TABLE_200
350: , p5_a3 JTF_NUMBER_TABLE
351: , p5_a4 JTF_NUMBER_TABLE
352: , p5_a5 JTF_VARCHAR2_TABLE_200
353: , p5_a6 JTF_VARCHAR2_TABLE_2000
354: , p5_a7 JTF_NUMBER_TABLE
355: , p5_a8 JTF_DATE_TABLE
356: , p5_a9 JTF_DATE_TABLE
357: , p5_a10 JTF_VARCHAR2_TABLE_100
462: , x_msg_count out nocopy NUMBER
463: , x_msg_data out nocopy VARCHAR2
464: , p5_a0 JTF_NUMBER_TABLE
465: , p5_a1 JTF_NUMBER_TABLE
466: , p5_a2 JTF_VARCHAR2_TABLE_200
467: , p5_a3 JTF_NUMBER_TABLE
468: , p5_a4 JTF_NUMBER_TABLE
469: , p5_a5 JTF_VARCHAR2_TABLE_200
470: , p5_a6 JTF_VARCHAR2_TABLE_2000
465: , p5_a1 JTF_NUMBER_TABLE
466: , p5_a2 JTF_VARCHAR2_TABLE_200
467: , p5_a3 JTF_NUMBER_TABLE
468: , p5_a4 JTF_NUMBER_TABLE
469: , p5_a5 JTF_VARCHAR2_TABLE_200
470: , p5_a6 JTF_VARCHAR2_TABLE_2000
471: , p5_a7 JTF_NUMBER_TABLE
472: , p5_a8 JTF_DATE_TABLE
473: , p5_a9 JTF_DATE_TABLE
466: , p5_a2 JTF_VARCHAR2_TABLE_200
467: , p5_a3 JTF_NUMBER_TABLE
468: , p5_a4 JTF_NUMBER_TABLE
469: , p5_a5 JTF_VARCHAR2_TABLE_200
470: , p5_a6 JTF_VARCHAR2_TABLE_2000
471: , p5_a7 JTF_NUMBER_TABLE
472: , p5_a8 JTF_DATE_TABLE
473: , p5_a9 JTF_DATE_TABLE
474: , p5_a10 JTF_VARCHAR2_TABLE_100
497: , p5_a33 JTF_DATE_TABLE
498: , p5_a34 JTF_NUMBER_TABLE
499: , p6_a0 out nocopy JTF_NUMBER_TABLE
500: , p6_a1 out nocopy JTF_NUMBER_TABLE
501: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
502: , p6_a3 out nocopy JTF_NUMBER_TABLE
503: , p6_a4 out nocopy JTF_NUMBER_TABLE
504: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
505: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
500: , p6_a1 out nocopy JTF_NUMBER_TABLE
501: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
502: , p6_a3 out nocopy JTF_NUMBER_TABLE
503: , p6_a4 out nocopy JTF_NUMBER_TABLE
504: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
505: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
506: , p6_a7 out nocopy JTF_NUMBER_TABLE
507: , p6_a8 out nocopy JTF_DATE_TABLE
508: , p6_a9 out nocopy JTF_DATE_TABLE
501: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
502: , p6_a3 out nocopy JTF_NUMBER_TABLE
503: , p6_a4 out nocopy JTF_NUMBER_TABLE
504: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
505: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
506: , p6_a7 out nocopy JTF_NUMBER_TABLE
507: , p6_a8 out nocopy JTF_DATE_TABLE
508: , p6_a9 out nocopy JTF_DATE_TABLE
509: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
579: , x_msg_count out nocopy NUMBER
580: , x_msg_data out nocopy VARCHAR2
581: , p5_a0 JTF_NUMBER_TABLE
582: , p5_a1 JTF_NUMBER_TABLE
583: , p5_a2 JTF_VARCHAR2_TABLE_200
584: , p5_a3 JTF_NUMBER_TABLE
585: , p5_a4 JTF_NUMBER_TABLE
586: , p5_a5 JTF_VARCHAR2_TABLE_200
587: , p5_a6 JTF_VARCHAR2_TABLE_2000
582: , p5_a1 JTF_NUMBER_TABLE
583: , p5_a2 JTF_VARCHAR2_TABLE_200
584: , p5_a3 JTF_NUMBER_TABLE
585: , p5_a4 JTF_NUMBER_TABLE
586: , p5_a5 JTF_VARCHAR2_TABLE_200
587: , p5_a6 JTF_VARCHAR2_TABLE_2000
588: , p5_a7 JTF_NUMBER_TABLE
589: , p5_a8 JTF_DATE_TABLE
590: , p5_a9 JTF_DATE_TABLE
583: , p5_a2 JTF_VARCHAR2_TABLE_200
584: , p5_a3 JTF_NUMBER_TABLE
585: , p5_a4 JTF_NUMBER_TABLE
586: , p5_a5 JTF_VARCHAR2_TABLE_200
587: , p5_a6 JTF_VARCHAR2_TABLE_2000
588: , p5_a7 JTF_NUMBER_TABLE
589: , p5_a8 JTF_DATE_TABLE
590: , p5_a9 JTF_DATE_TABLE
591: , p5_a10 JTF_VARCHAR2_TABLE_100
661: , x_msg_count out nocopy NUMBER
662: , x_msg_data out nocopy VARCHAR2
663: , p5_a0 JTF_NUMBER_TABLE
664: , p5_a1 JTF_NUMBER_TABLE
665: , p5_a2 JTF_VARCHAR2_TABLE_200
666: , p5_a3 JTF_NUMBER_TABLE
667: , p5_a4 JTF_NUMBER_TABLE
668: , p5_a5 JTF_VARCHAR2_TABLE_200
669: , p5_a6 JTF_VARCHAR2_TABLE_2000
664: , p5_a1 JTF_NUMBER_TABLE
665: , p5_a2 JTF_VARCHAR2_TABLE_200
666: , p5_a3 JTF_NUMBER_TABLE
667: , p5_a4 JTF_NUMBER_TABLE
668: , p5_a5 JTF_VARCHAR2_TABLE_200
669: , p5_a6 JTF_VARCHAR2_TABLE_2000
670: , p5_a7 JTF_NUMBER_TABLE
671: , p5_a8 JTF_DATE_TABLE
672: , p5_a9 JTF_DATE_TABLE
665: , p5_a2 JTF_VARCHAR2_TABLE_200
666: , p5_a3 JTF_NUMBER_TABLE
667: , p5_a4 JTF_NUMBER_TABLE
668: , p5_a5 JTF_VARCHAR2_TABLE_200
669: , p5_a6 JTF_VARCHAR2_TABLE_2000
670: , p5_a7 JTF_NUMBER_TABLE
671: , p5_a8 JTF_DATE_TABLE
672: , p5_a9 JTF_DATE_TABLE
673: , p5_a10 JTF_VARCHAR2_TABLE_100