DBA Data[Home] [Help]

APPS.OKL_STY_PVT_W dependencies on JTF_VARCHAR2_TABLE_200

Line 5: , a2 JTF_VARCHAR2_TABLE_200

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

Line 47: , a2 out nocopy JTF_VARCHAR2_TABLE_200

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

Line 92: , a4 JTF_VARCHAR2_TABLE_200

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

Line 93: , a5 JTF_VARCHAR2_TABLE_2000

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

Line 105: , a4 out nocopy JTF_VARCHAR2_TABLE_200

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

Line 106: , a5 out nocopy JTF_VARCHAR2_TABLE_2000

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

Line 116: , a1 JTF_VARCHAR2_TABLE_200

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

Line 119: , a4 JTF_VARCHAR2_TABLE_200

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

Line 122: , a7 JTF_VARCHAR2_TABLE_2000

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

Line 162: , a1 out nocopy JTF_VARCHAR2_TABLE_200

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

Line 165: , a4 out nocopy JTF_VARCHAR2_TABLE_200

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

Line 168: , a7 out nocopy JTF_VARCHAR2_TABLE_2000

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

Line 310: , p5_a1 JTF_VARCHAR2_TABLE_200

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

Line 313: , p5_a4 JTF_VARCHAR2_TABLE_200

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

Line 316: , p5_a7 JTF_VARCHAR2_TABLE_2000

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

Line 355: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200

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

Line 358: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200

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

Line 361: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000

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

Line 457: , p5_a1 JTF_VARCHAR2_TABLE_200

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

Line 460: , p5_a4 JTF_VARCHAR2_TABLE_200

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

Line 463: , p5_a7 JTF_VARCHAR2_TABLE_2000

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

Line 604: , p5_a1 JTF_VARCHAR2_TABLE_200

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

Line 607: , p5_a4 JTF_VARCHAR2_TABLE_200

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

Line 610: , p5_a7 JTF_VARCHAR2_TABLE_2000

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

Line 649: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200

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

Line 652: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200

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

Line 655: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000

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

Line 751: , p5_a1 JTF_VARCHAR2_TABLE_200

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

Line 754: , p5_a4 JTF_VARCHAR2_TABLE_200

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

Line 757: , p5_a7 JTF_VARCHAR2_TABLE_2000

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

Line 853: , p5_a1 JTF_VARCHAR2_TABLE_200

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

Line 856: , p5_a4 JTF_VARCHAR2_TABLE_200

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

Line 859: , p5_a7 JTF_VARCHAR2_TABLE_2000

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