1: package okl_sty_pvt_w as
2: /* $Header: OKLISTYS.pls 120.3 2008/01/29 17:21:59 gkadarka ship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_sty_pvt.sty_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_200
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100
43: , a40 JTF_NUMBER_TABLE
44: );
45: procedure rosetta_table_copy_out_p2(t okl_sty_pvt.sty_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
46: , a1 out nocopy JTF_VARCHAR2_TABLE_100
47: , a2 out nocopy JTF_VARCHAR2_TABLE_200
48: , a3 out nocopy JTF_VARCHAR2_TABLE_100
49: , a4 out nocopy JTF_VARCHAR2_TABLE_100
50: , a5 out nocopy JTF_NUMBER_TABLE
51: , a6 out nocopy JTF_VARCHAR2_TABLE_100
88: procedure rosetta_table_copy_in_p5(t out nocopy okl_sty_pvt.okl_strm_type_tl_tbl_type, a0 JTF_NUMBER_TABLE
89: , a1 JTF_VARCHAR2_TABLE_100
90: , a2 JTF_VARCHAR2_TABLE_100
91: , a3 JTF_VARCHAR2_TABLE_100
92: , a4 JTF_VARCHAR2_TABLE_200
93: , a5 JTF_VARCHAR2_TABLE_2000
94: , a6 JTF_NUMBER_TABLE
95: , a7 JTF_DATE_TABLE
96: , a8 JTF_NUMBER_TABLE
89: , a1 JTF_VARCHAR2_TABLE_100
90: , a2 JTF_VARCHAR2_TABLE_100
91: , a3 JTF_VARCHAR2_TABLE_100
92: , a4 JTF_VARCHAR2_TABLE_200
93: , a5 JTF_VARCHAR2_TABLE_2000
94: , a6 JTF_NUMBER_TABLE
95: , a7 JTF_DATE_TABLE
96: , a8 JTF_NUMBER_TABLE
97: , a9 JTF_DATE_TABLE
101: procedure rosetta_table_copy_out_p5(t okl_sty_pvt.okl_strm_type_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
102: , a1 out nocopy JTF_VARCHAR2_TABLE_100
103: , a2 out nocopy JTF_VARCHAR2_TABLE_100
104: , a3 out nocopy JTF_VARCHAR2_TABLE_100
105: , a4 out nocopy JTF_VARCHAR2_TABLE_200
106: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
107: , a6 out nocopy JTF_NUMBER_TABLE
108: , a7 out nocopy JTF_DATE_TABLE
109: , a8 out nocopy JTF_NUMBER_TABLE
102: , a1 out nocopy JTF_VARCHAR2_TABLE_100
103: , a2 out nocopy JTF_VARCHAR2_TABLE_100
104: , a3 out nocopy JTF_VARCHAR2_TABLE_100
105: , a4 out nocopy JTF_VARCHAR2_TABLE_200
106: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
107: , a6 out nocopy JTF_NUMBER_TABLE
108: , a7 out nocopy JTF_DATE_TABLE
109: , a8 out nocopy JTF_NUMBER_TABLE
110: , a9 out nocopy JTF_DATE_TABLE
112: , a11 out nocopy JTF_VARCHAR2_TABLE_600
113: );
114:
115: procedure rosetta_table_copy_in_p8(t out nocopy okl_sty_pvt.styv_tbl_type, a0 JTF_NUMBER_TABLE
116: , a1 JTF_VARCHAR2_TABLE_200
117: , a2 JTF_VARCHAR2_TABLE_100
118: , a3 JTF_NUMBER_TABLE
119: , a4 JTF_VARCHAR2_TABLE_200
120: , a5 JTF_VARCHAR2_TABLE_100
115: procedure rosetta_table_copy_in_p8(t out nocopy okl_sty_pvt.styv_tbl_type, a0 JTF_NUMBER_TABLE
116: , a1 JTF_VARCHAR2_TABLE_200
117: , a2 JTF_VARCHAR2_TABLE_100
118: , a3 JTF_NUMBER_TABLE
119: , a4 JTF_VARCHAR2_TABLE_200
120: , a5 JTF_VARCHAR2_TABLE_100
121: , a6 JTF_VARCHAR2_TABLE_100
122: , a7 JTF_VARCHAR2_TABLE_2000
123: , a8 JTF_DATE_TABLE
118: , a3 JTF_NUMBER_TABLE
119: , a4 JTF_VARCHAR2_TABLE_200
120: , a5 JTF_VARCHAR2_TABLE_100
121: , a6 JTF_VARCHAR2_TABLE_100
122: , a7 JTF_VARCHAR2_TABLE_2000
123: , a8 JTF_DATE_TABLE
124: , a9 JTF_DATE_TABLE
125: , a10 JTF_VARCHAR2_TABLE_100
126: , a11 JTF_VARCHAR2_TABLE_100
158: , a43 JTF_VARCHAR2_TABLE_600
159: , a44 JTF_NUMBER_TABLE
160: );
161: procedure rosetta_table_copy_out_p8(t okl_sty_pvt.styv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
162: , a1 out nocopy JTF_VARCHAR2_TABLE_200
163: , a2 out nocopy JTF_VARCHAR2_TABLE_100
164: , a3 out nocopy JTF_NUMBER_TABLE
165: , a4 out nocopy JTF_VARCHAR2_TABLE_200
166: , a5 out nocopy JTF_VARCHAR2_TABLE_100
161: procedure rosetta_table_copy_out_p8(t okl_sty_pvt.styv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
162: , a1 out nocopy JTF_VARCHAR2_TABLE_200
163: , a2 out nocopy JTF_VARCHAR2_TABLE_100
164: , a3 out nocopy JTF_NUMBER_TABLE
165: , a4 out nocopy JTF_VARCHAR2_TABLE_200
166: , a5 out nocopy JTF_VARCHAR2_TABLE_100
167: , a6 out nocopy JTF_VARCHAR2_TABLE_100
168: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
169: , a8 out nocopy JTF_DATE_TABLE
164: , a3 out nocopy JTF_NUMBER_TABLE
165: , a4 out nocopy JTF_VARCHAR2_TABLE_200
166: , a5 out nocopy JTF_VARCHAR2_TABLE_100
167: , a6 out nocopy JTF_VARCHAR2_TABLE_100
168: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
169: , a8 out nocopy JTF_DATE_TABLE
170: , a9 out nocopy JTF_DATE_TABLE
171: , a10 out nocopy JTF_VARCHAR2_TABLE_100
172: , a11 out nocopy JTF_VARCHAR2_TABLE_100
306: , x_return_status out nocopy VARCHAR2
307: , x_msg_count out nocopy NUMBER
308: , x_msg_data out nocopy VARCHAR2
309: , p5_a0 JTF_NUMBER_TABLE
310: , p5_a1 JTF_VARCHAR2_TABLE_200
311: , p5_a2 JTF_VARCHAR2_TABLE_100
312: , p5_a3 JTF_NUMBER_TABLE
313: , p5_a4 JTF_VARCHAR2_TABLE_200
314: , p5_a5 JTF_VARCHAR2_TABLE_100
309: , p5_a0 JTF_NUMBER_TABLE
310: , p5_a1 JTF_VARCHAR2_TABLE_200
311: , p5_a2 JTF_VARCHAR2_TABLE_100
312: , p5_a3 JTF_NUMBER_TABLE
313: , p5_a4 JTF_VARCHAR2_TABLE_200
314: , p5_a5 JTF_VARCHAR2_TABLE_100
315: , p5_a6 JTF_VARCHAR2_TABLE_100
316: , p5_a7 JTF_VARCHAR2_TABLE_2000
317: , p5_a8 JTF_DATE_TABLE
312: , p5_a3 JTF_NUMBER_TABLE
313: , p5_a4 JTF_VARCHAR2_TABLE_200
314: , p5_a5 JTF_VARCHAR2_TABLE_100
315: , p5_a6 JTF_VARCHAR2_TABLE_100
316: , p5_a7 JTF_VARCHAR2_TABLE_2000
317: , p5_a8 JTF_DATE_TABLE
318: , p5_a9 JTF_DATE_TABLE
319: , p5_a10 JTF_VARCHAR2_TABLE_100
320: , p5_a11 JTF_VARCHAR2_TABLE_100
351: , p5_a42 JTF_VARCHAR2_TABLE_100
352: , p5_a43 JTF_VARCHAR2_TABLE_600
353: , p5_a44 JTF_NUMBER_TABLE
354: , p6_a0 out nocopy JTF_NUMBER_TABLE
355: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
356: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
357: , p6_a3 out nocopy JTF_NUMBER_TABLE
358: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
359: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
354: , p6_a0 out nocopy JTF_NUMBER_TABLE
355: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
356: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
357: , p6_a3 out nocopy JTF_NUMBER_TABLE
358: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
359: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
360: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
361: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000
362: , p6_a8 out nocopy JTF_DATE_TABLE
357: , p6_a3 out nocopy JTF_NUMBER_TABLE
358: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
359: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
360: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
361: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000
362: , p6_a8 out nocopy JTF_DATE_TABLE
363: , p6_a9 out nocopy JTF_DATE_TABLE
364: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
365: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
453: , x_return_status out nocopy VARCHAR2
454: , x_msg_count out nocopy NUMBER
455: , x_msg_data out nocopy VARCHAR2
456: , p5_a0 JTF_NUMBER_TABLE
457: , p5_a1 JTF_VARCHAR2_TABLE_200
458: , p5_a2 JTF_VARCHAR2_TABLE_100
459: , p5_a3 JTF_NUMBER_TABLE
460: , p5_a4 JTF_VARCHAR2_TABLE_200
461: , p5_a5 JTF_VARCHAR2_TABLE_100
456: , p5_a0 JTF_NUMBER_TABLE
457: , p5_a1 JTF_VARCHAR2_TABLE_200
458: , p5_a2 JTF_VARCHAR2_TABLE_100
459: , p5_a3 JTF_NUMBER_TABLE
460: , p5_a4 JTF_VARCHAR2_TABLE_200
461: , p5_a5 JTF_VARCHAR2_TABLE_100
462: , p5_a6 JTF_VARCHAR2_TABLE_100
463: , p5_a7 JTF_VARCHAR2_TABLE_2000
464: , p5_a8 JTF_DATE_TABLE
459: , p5_a3 JTF_NUMBER_TABLE
460: , p5_a4 JTF_VARCHAR2_TABLE_200
461: , p5_a5 JTF_VARCHAR2_TABLE_100
462: , p5_a6 JTF_VARCHAR2_TABLE_100
463: , p5_a7 JTF_VARCHAR2_TABLE_2000
464: , p5_a8 JTF_DATE_TABLE
465: , p5_a9 JTF_DATE_TABLE
466: , p5_a10 JTF_VARCHAR2_TABLE_100
467: , p5_a11 JTF_VARCHAR2_TABLE_100
600: , x_return_status out nocopy VARCHAR2
601: , x_msg_count out nocopy NUMBER
602: , x_msg_data out nocopy VARCHAR2
603: , p5_a0 JTF_NUMBER_TABLE
604: , p5_a1 JTF_VARCHAR2_TABLE_200
605: , p5_a2 JTF_VARCHAR2_TABLE_100
606: , p5_a3 JTF_NUMBER_TABLE
607: , p5_a4 JTF_VARCHAR2_TABLE_200
608: , p5_a5 JTF_VARCHAR2_TABLE_100
603: , p5_a0 JTF_NUMBER_TABLE
604: , p5_a1 JTF_VARCHAR2_TABLE_200
605: , p5_a2 JTF_VARCHAR2_TABLE_100
606: , p5_a3 JTF_NUMBER_TABLE
607: , p5_a4 JTF_VARCHAR2_TABLE_200
608: , p5_a5 JTF_VARCHAR2_TABLE_100
609: , p5_a6 JTF_VARCHAR2_TABLE_100
610: , p5_a7 JTF_VARCHAR2_TABLE_2000
611: , p5_a8 JTF_DATE_TABLE
606: , p5_a3 JTF_NUMBER_TABLE
607: , p5_a4 JTF_VARCHAR2_TABLE_200
608: , p5_a5 JTF_VARCHAR2_TABLE_100
609: , p5_a6 JTF_VARCHAR2_TABLE_100
610: , p5_a7 JTF_VARCHAR2_TABLE_2000
611: , p5_a8 JTF_DATE_TABLE
612: , p5_a9 JTF_DATE_TABLE
613: , p5_a10 JTF_VARCHAR2_TABLE_100
614: , p5_a11 JTF_VARCHAR2_TABLE_100
645: , p5_a42 JTF_VARCHAR2_TABLE_100
646: , p5_a43 JTF_VARCHAR2_TABLE_600
647: , p5_a44 JTF_NUMBER_TABLE
648: , p6_a0 out nocopy JTF_NUMBER_TABLE
649: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
650: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
651: , p6_a3 out nocopy JTF_NUMBER_TABLE
652: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
653: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
648: , p6_a0 out nocopy JTF_NUMBER_TABLE
649: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
650: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
651: , p6_a3 out nocopy JTF_NUMBER_TABLE
652: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
653: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
654: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
655: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000
656: , p6_a8 out nocopy JTF_DATE_TABLE
651: , p6_a3 out nocopy JTF_NUMBER_TABLE
652: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
653: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
654: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
655: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000
656: , p6_a8 out nocopy JTF_DATE_TABLE
657: , p6_a9 out nocopy JTF_DATE_TABLE
658: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
659: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
747: , x_return_status out nocopy VARCHAR2
748: , x_msg_count out nocopy NUMBER
749: , x_msg_data out nocopy VARCHAR2
750: , p5_a0 JTF_NUMBER_TABLE
751: , p5_a1 JTF_VARCHAR2_TABLE_200
752: , p5_a2 JTF_VARCHAR2_TABLE_100
753: , p5_a3 JTF_NUMBER_TABLE
754: , p5_a4 JTF_VARCHAR2_TABLE_200
755: , p5_a5 JTF_VARCHAR2_TABLE_100
750: , p5_a0 JTF_NUMBER_TABLE
751: , p5_a1 JTF_VARCHAR2_TABLE_200
752: , p5_a2 JTF_VARCHAR2_TABLE_100
753: , p5_a3 JTF_NUMBER_TABLE
754: , p5_a4 JTF_VARCHAR2_TABLE_200
755: , p5_a5 JTF_VARCHAR2_TABLE_100
756: , p5_a6 JTF_VARCHAR2_TABLE_100
757: , p5_a7 JTF_VARCHAR2_TABLE_2000
758: , p5_a8 JTF_DATE_TABLE
753: , p5_a3 JTF_NUMBER_TABLE
754: , p5_a4 JTF_VARCHAR2_TABLE_200
755: , p5_a5 JTF_VARCHAR2_TABLE_100
756: , p5_a6 JTF_VARCHAR2_TABLE_100
757: , p5_a7 JTF_VARCHAR2_TABLE_2000
758: , p5_a8 JTF_DATE_TABLE
759: , p5_a9 JTF_DATE_TABLE
760: , p5_a10 JTF_VARCHAR2_TABLE_100
761: , p5_a11 JTF_VARCHAR2_TABLE_100
849: , x_return_status out nocopy VARCHAR2
850: , x_msg_count out nocopy NUMBER
851: , x_msg_data out nocopy VARCHAR2
852: , p5_a0 JTF_NUMBER_TABLE
853: , p5_a1 JTF_VARCHAR2_TABLE_200
854: , p5_a2 JTF_VARCHAR2_TABLE_100
855: , p5_a3 JTF_NUMBER_TABLE
856: , p5_a4 JTF_VARCHAR2_TABLE_200
857: , p5_a5 JTF_VARCHAR2_TABLE_100
852: , p5_a0 JTF_NUMBER_TABLE
853: , p5_a1 JTF_VARCHAR2_TABLE_200
854: , p5_a2 JTF_VARCHAR2_TABLE_100
855: , p5_a3 JTF_NUMBER_TABLE
856: , p5_a4 JTF_VARCHAR2_TABLE_200
857: , p5_a5 JTF_VARCHAR2_TABLE_100
858: , p5_a6 JTF_VARCHAR2_TABLE_100
859: , p5_a7 JTF_VARCHAR2_TABLE_2000
860: , p5_a8 JTF_DATE_TABLE
855: , p5_a3 JTF_NUMBER_TABLE
856: , p5_a4 JTF_VARCHAR2_TABLE_200
857: , p5_a5 JTF_VARCHAR2_TABLE_100
858: , p5_a6 JTF_VARCHAR2_TABLE_100
859: , p5_a7 JTF_VARCHAR2_TABLE_2000
860: , p5_a8 JTF_DATE_TABLE
861: , p5_a9 JTF_DATE_TABLE
862: , p5_a10 JTF_VARCHAR2_TABLE_100
863: , p5_a11 JTF_VARCHAR2_TABLE_100