3: procedure rosetta_table_copy_in_p2(t out nocopy okl_vcr_pvt.vcrv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_DATE_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_DATE_TABLE
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_DATE_TABLE
13: , a10 JTF_DATE_TABLE
14: , a11 JTF_DATE_TABLE
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_VARCHAR2_TABLE_500
17: , a14 JTF_VARCHAR2_TABLE_500
18: , a15 JTF_VARCHAR2_TABLE_500
19: , a16 JTF_VARCHAR2_TABLE_500
94: procedure rosetta_table_copy_out_p2(t okl_vcr_pvt.vcrv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
95: , a1 out nocopy JTF_NUMBER_TABLE
96: , a2 out nocopy JTF_NUMBER_TABLE
97: , a3 out nocopy JTF_NUMBER_TABLE
98: , a4 out nocopy JTF_VARCHAR2_TABLE_100
99: , a5 out nocopy JTF_VARCHAR2_TABLE_100
100: , a6 out nocopy JTF_DATE_TABLE
101: , a7 out nocopy JTF_DATE_TABLE
102: , a8 out nocopy JTF_DATE_TABLE
95: , a1 out nocopy JTF_NUMBER_TABLE
96: , a2 out nocopy JTF_NUMBER_TABLE
97: , a3 out nocopy JTF_NUMBER_TABLE
98: , a4 out nocopy JTF_VARCHAR2_TABLE_100
99: , a5 out nocopy JTF_VARCHAR2_TABLE_100
100: , a6 out nocopy JTF_DATE_TABLE
101: , a7 out nocopy JTF_DATE_TABLE
102: , a8 out nocopy JTF_DATE_TABLE
103: , a9 out nocopy JTF_DATE_TABLE
102: , a8 out nocopy JTF_DATE_TABLE
103: , a9 out nocopy JTF_DATE_TABLE
104: , a10 out nocopy JTF_DATE_TABLE
105: , a11 out nocopy JTF_DATE_TABLE
106: , a12 out nocopy JTF_VARCHAR2_TABLE_100
107: , a13 out nocopy JTF_VARCHAR2_TABLE_500
108: , a14 out nocopy JTF_VARCHAR2_TABLE_500
109: , a15 out nocopy JTF_VARCHAR2_TABLE_500
110: , a16 out nocopy JTF_VARCHAR2_TABLE_500
135: a0 := JTF_NUMBER_TABLE();
136: a1 := JTF_NUMBER_TABLE();
137: a2 := JTF_NUMBER_TABLE();
138: a3 := JTF_NUMBER_TABLE();
139: a4 := JTF_VARCHAR2_TABLE_100();
140: a5 := JTF_VARCHAR2_TABLE_100();
141: a6 := JTF_DATE_TABLE();
142: a7 := JTF_DATE_TABLE();
143: a8 := JTF_DATE_TABLE();
136: a1 := JTF_NUMBER_TABLE();
137: a2 := JTF_NUMBER_TABLE();
138: a3 := JTF_NUMBER_TABLE();
139: a4 := JTF_VARCHAR2_TABLE_100();
140: a5 := JTF_VARCHAR2_TABLE_100();
141: a6 := JTF_DATE_TABLE();
142: a7 := JTF_DATE_TABLE();
143: a8 := JTF_DATE_TABLE();
144: a9 := JTF_DATE_TABLE();
143: a8 := JTF_DATE_TABLE();
144: a9 := JTF_DATE_TABLE();
145: a10 := JTF_DATE_TABLE();
146: a11 := JTF_DATE_TABLE();
147: a12 := JTF_VARCHAR2_TABLE_100();
148: a13 := JTF_VARCHAR2_TABLE_500();
149: a14 := JTF_VARCHAR2_TABLE_500();
150: a15 := JTF_VARCHAR2_TABLE_500();
151: a16 := JTF_VARCHAR2_TABLE_500();
173: a0 := JTF_NUMBER_TABLE();
174: a1 := JTF_NUMBER_TABLE();
175: a2 := JTF_NUMBER_TABLE();
176: a3 := JTF_NUMBER_TABLE();
177: a4 := JTF_VARCHAR2_TABLE_100();
178: a5 := JTF_VARCHAR2_TABLE_100();
179: a6 := JTF_DATE_TABLE();
180: a7 := JTF_DATE_TABLE();
181: a8 := JTF_DATE_TABLE();
174: a1 := JTF_NUMBER_TABLE();
175: a2 := JTF_NUMBER_TABLE();
176: a3 := JTF_NUMBER_TABLE();
177: a4 := JTF_VARCHAR2_TABLE_100();
178: a5 := JTF_VARCHAR2_TABLE_100();
179: a6 := JTF_DATE_TABLE();
180: a7 := JTF_DATE_TABLE();
181: a8 := JTF_DATE_TABLE();
182: a9 := JTF_DATE_TABLE();
181: a8 := JTF_DATE_TABLE();
182: a9 := JTF_DATE_TABLE();
183: a10 := JTF_DATE_TABLE();
184: a11 := JTF_DATE_TABLE();
185: a12 := JTF_VARCHAR2_TABLE_100();
186: a13 := JTF_VARCHAR2_TABLE_500();
187: a14 := JTF_VARCHAR2_TABLE_500();
188: a15 := JTF_VARCHAR2_TABLE_500();
189: a16 := JTF_VARCHAR2_TABLE_500();
298: procedure rosetta_table_copy_in_p5(t out nocopy okl_vcr_pvt.vcr_tbl_type, a0 JTF_NUMBER_TABLE
299: , a1 JTF_NUMBER_TABLE
300: , a2 JTF_NUMBER_TABLE
301: , a3 JTF_NUMBER_TABLE
302: , a4 JTF_VARCHAR2_TABLE_100
303: , a5 JTF_VARCHAR2_TABLE_100
304: , a6 JTF_DATE_TABLE
305: , a7 JTF_DATE_TABLE
306: , a8 JTF_DATE_TABLE
299: , a1 JTF_NUMBER_TABLE
300: , a2 JTF_NUMBER_TABLE
301: , a3 JTF_NUMBER_TABLE
302: , a4 JTF_VARCHAR2_TABLE_100
303: , a5 JTF_VARCHAR2_TABLE_100
304: , a6 JTF_DATE_TABLE
305: , a7 JTF_DATE_TABLE
306: , a8 JTF_DATE_TABLE
307: , a9 JTF_DATE_TABLE
306: , a8 JTF_DATE_TABLE
307: , a9 JTF_DATE_TABLE
308: , a10 JTF_DATE_TABLE
309: , a11 JTF_DATE_TABLE
310: , a12 JTF_VARCHAR2_TABLE_100
311: , a13 JTF_VARCHAR2_TABLE_500
312: , a14 JTF_VARCHAR2_TABLE_500
313: , a15 JTF_VARCHAR2_TABLE_500
314: , a16 JTF_VARCHAR2_TABLE_500
389: procedure rosetta_table_copy_out_p5(t okl_vcr_pvt.vcr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
390: , a1 out nocopy JTF_NUMBER_TABLE
391: , a2 out nocopy JTF_NUMBER_TABLE
392: , a3 out nocopy JTF_NUMBER_TABLE
393: , a4 out nocopy JTF_VARCHAR2_TABLE_100
394: , a5 out nocopy JTF_VARCHAR2_TABLE_100
395: , a6 out nocopy JTF_DATE_TABLE
396: , a7 out nocopy JTF_DATE_TABLE
397: , a8 out nocopy JTF_DATE_TABLE
390: , a1 out nocopy JTF_NUMBER_TABLE
391: , a2 out nocopy JTF_NUMBER_TABLE
392: , a3 out nocopy JTF_NUMBER_TABLE
393: , a4 out nocopy JTF_VARCHAR2_TABLE_100
394: , a5 out nocopy JTF_VARCHAR2_TABLE_100
395: , a6 out nocopy JTF_DATE_TABLE
396: , a7 out nocopy JTF_DATE_TABLE
397: , a8 out nocopy JTF_DATE_TABLE
398: , a9 out nocopy JTF_DATE_TABLE
397: , a8 out nocopy JTF_DATE_TABLE
398: , a9 out nocopy JTF_DATE_TABLE
399: , a10 out nocopy JTF_DATE_TABLE
400: , a11 out nocopy JTF_DATE_TABLE
401: , a12 out nocopy JTF_VARCHAR2_TABLE_100
402: , a13 out nocopy JTF_VARCHAR2_TABLE_500
403: , a14 out nocopy JTF_VARCHAR2_TABLE_500
404: , a15 out nocopy JTF_VARCHAR2_TABLE_500
405: , a16 out nocopy JTF_VARCHAR2_TABLE_500
430: a0 := JTF_NUMBER_TABLE();
431: a1 := JTF_NUMBER_TABLE();
432: a2 := JTF_NUMBER_TABLE();
433: a3 := JTF_NUMBER_TABLE();
434: a4 := JTF_VARCHAR2_TABLE_100();
435: a5 := JTF_VARCHAR2_TABLE_100();
436: a6 := JTF_DATE_TABLE();
437: a7 := JTF_DATE_TABLE();
438: a8 := JTF_DATE_TABLE();
431: a1 := JTF_NUMBER_TABLE();
432: a2 := JTF_NUMBER_TABLE();
433: a3 := JTF_NUMBER_TABLE();
434: a4 := JTF_VARCHAR2_TABLE_100();
435: a5 := JTF_VARCHAR2_TABLE_100();
436: a6 := JTF_DATE_TABLE();
437: a7 := JTF_DATE_TABLE();
438: a8 := JTF_DATE_TABLE();
439: a9 := JTF_DATE_TABLE();
438: a8 := JTF_DATE_TABLE();
439: a9 := JTF_DATE_TABLE();
440: a10 := JTF_DATE_TABLE();
441: a11 := JTF_DATE_TABLE();
442: a12 := JTF_VARCHAR2_TABLE_100();
443: a13 := JTF_VARCHAR2_TABLE_500();
444: a14 := JTF_VARCHAR2_TABLE_500();
445: a15 := JTF_VARCHAR2_TABLE_500();
446: a16 := JTF_VARCHAR2_TABLE_500();
468: a0 := JTF_NUMBER_TABLE();
469: a1 := JTF_NUMBER_TABLE();
470: a2 := JTF_NUMBER_TABLE();
471: a3 := JTF_NUMBER_TABLE();
472: a4 := JTF_VARCHAR2_TABLE_100();
473: a5 := JTF_VARCHAR2_TABLE_100();
474: a6 := JTF_DATE_TABLE();
475: a7 := JTF_DATE_TABLE();
476: a8 := JTF_DATE_TABLE();
469: a1 := JTF_NUMBER_TABLE();
470: a2 := JTF_NUMBER_TABLE();
471: a3 := JTF_NUMBER_TABLE();
472: a4 := JTF_VARCHAR2_TABLE_100();
473: a5 := JTF_VARCHAR2_TABLE_100();
474: a6 := JTF_DATE_TABLE();
475: a7 := JTF_DATE_TABLE();
476: a8 := JTF_DATE_TABLE();
477: a9 := JTF_DATE_TABLE();
476: a8 := JTF_DATE_TABLE();
477: a9 := JTF_DATE_TABLE();
478: a10 := JTF_DATE_TABLE();
479: a11 := JTF_DATE_TABLE();
480: a12 := JTF_VARCHAR2_TABLE_100();
481: a13 := JTF_VARCHAR2_TABLE_500();
482: a14 := JTF_VARCHAR2_TABLE_500();
483: a15 := JTF_VARCHAR2_TABLE_500();
484: a16 := JTF_VARCHAR2_TABLE_500();
785: , p5_a0 JTF_NUMBER_TABLE
786: , p5_a1 JTF_NUMBER_TABLE
787: , p5_a2 JTF_NUMBER_TABLE
788: , p5_a3 JTF_NUMBER_TABLE
789: , p5_a4 JTF_VARCHAR2_TABLE_100
790: , p5_a5 JTF_VARCHAR2_TABLE_100
791: , p5_a6 JTF_DATE_TABLE
792: , p5_a7 JTF_DATE_TABLE
793: , p5_a8 JTF_DATE_TABLE
786: , p5_a1 JTF_NUMBER_TABLE
787: , p5_a2 JTF_NUMBER_TABLE
788: , p5_a3 JTF_NUMBER_TABLE
789: , p5_a4 JTF_VARCHAR2_TABLE_100
790: , p5_a5 JTF_VARCHAR2_TABLE_100
791: , p5_a6 JTF_DATE_TABLE
792: , p5_a7 JTF_DATE_TABLE
793: , p5_a8 JTF_DATE_TABLE
794: , p5_a9 JTF_DATE_TABLE
793: , p5_a8 JTF_DATE_TABLE
794: , p5_a9 JTF_DATE_TABLE
795: , p5_a10 JTF_DATE_TABLE
796: , p5_a11 JTF_DATE_TABLE
797: , p5_a12 JTF_VARCHAR2_TABLE_100
798: , p5_a13 JTF_VARCHAR2_TABLE_500
799: , p5_a14 JTF_VARCHAR2_TABLE_500
800: , p5_a15 JTF_VARCHAR2_TABLE_500
801: , p5_a16 JTF_VARCHAR2_TABLE_500
822: , p6_a0 out nocopy JTF_NUMBER_TABLE
823: , p6_a1 out nocopy JTF_NUMBER_TABLE
824: , p6_a2 out nocopy JTF_NUMBER_TABLE
825: , p6_a3 out nocopy JTF_NUMBER_TABLE
826: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
827: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
828: , p6_a6 out nocopy JTF_DATE_TABLE
829: , p6_a7 out nocopy JTF_DATE_TABLE
830: , p6_a8 out nocopy JTF_DATE_TABLE
823: , p6_a1 out nocopy JTF_NUMBER_TABLE
824: , p6_a2 out nocopy JTF_NUMBER_TABLE
825: , p6_a3 out nocopy JTF_NUMBER_TABLE
826: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
827: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
828: , p6_a6 out nocopy JTF_DATE_TABLE
829: , p6_a7 out nocopy JTF_DATE_TABLE
830: , p6_a8 out nocopy JTF_DATE_TABLE
831: , p6_a9 out nocopy JTF_DATE_TABLE
830: , p6_a8 out nocopy JTF_DATE_TABLE
831: , p6_a9 out nocopy JTF_DATE_TABLE
832: , p6_a10 out nocopy JTF_DATE_TABLE
833: , p6_a11 out nocopy JTF_DATE_TABLE
834: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
835: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
836: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
837: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
838: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
856: , p6_a34 out nocopy JTF_NUMBER_TABLE
857: , p6_a35 out nocopy JTF_DATE_TABLE
858: , p6_a36 out nocopy JTF_NUMBER_TABLE
859: , p7_a0 in out nocopy JTF_NUMBER_TABLE
860: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
861: , p7_a2 in out nocopy JTF_NUMBER_TABLE
862: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
863: , p7_a4 in out nocopy JTF_NUMBER_TABLE
864: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
860: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
861: , p7_a2 in out nocopy JTF_NUMBER_TABLE
862: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
863: , p7_a4 in out nocopy JTF_NUMBER_TABLE
864: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
865: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
866: )
867:
868: as
861: , p7_a2 in out nocopy JTF_NUMBER_TABLE
862: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
863: , p7_a4 in out nocopy JTF_NUMBER_TABLE
864: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
865: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
866: )
867:
868: as
869: ddp_vcrv_tbl okl_vcr_pvt.vcrv_tbl_type;
1001: , p5_a0 JTF_NUMBER_TABLE
1002: , p5_a1 JTF_NUMBER_TABLE
1003: , p5_a2 JTF_NUMBER_TABLE
1004: , p5_a3 JTF_NUMBER_TABLE
1005: , p5_a4 JTF_VARCHAR2_TABLE_100
1006: , p5_a5 JTF_VARCHAR2_TABLE_100
1007: , p5_a6 JTF_DATE_TABLE
1008: , p5_a7 JTF_DATE_TABLE
1009: , p5_a8 JTF_DATE_TABLE
1002: , p5_a1 JTF_NUMBER_TABLE
1003: , p5_a2 JTF_NUMBER_TABLE
1004: , p5_a3 JTF_NUMBER_TABLE
1005: , p5_a4 JTF_VARCHAR2_TABLE_100
1006: , p5_a5 JTF_VARCHAR2_TABLE_100
1007: , p5_a6 JTF_DATE_TABLE
1008: , p5_a7 JTF_DATE_TABLE
1009: , p5_a8 JTF_DATE_TABLE
1010: , p5_a9 JTF_DATE_TABLE
1009: , p5_a8 JTF_DATE_TABLE
1010: , p5_a9 JTF_DATE_TABLE
1011: , p5_a10 JTF_DATE_TABLE
1012: , p5_a11 JTF_DATE_TABLE
1013: , p5_a12 JTF_VARCHAR2_TABLE_100
1014: , p5_a13 JTF_VARCHAR2_TABLE_500
1015: , p5_a14 JTF_VARCHAR2_TABLE_500
1016: , p5_a15 JTF_VARCHAR2_TABLE_500
1017: , p5_a16 JTF_VARCHAR2_TABLE_500
1038: , p6_a0 out nocopy JTF_NUMBER_TABLE
1039: , p6_a1 out nocopy JTF_NUMBER_TABLE
1040: , p6_a2 out nocopy JTF_NUMBER_TABLE
1041: , p6_a3 out nocopy JTF_NUMBER_TABLE
1042: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1043: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1044: , p6_a6 out nocopy JTF_DATE_TABLE
1045: , p6_a7 out nocopy JTF_DATE_TABLE
1046: , p6_a8 out nocopy JTF_DATE_TABLE
1039: , p6_a1 out nocopy JTF_NUMBER_TABLE
1040: , p6_a2 out nocopy JTF_NUMBER_TABLE
1041: , p6_a3 out nocopy JTF_NUMBER_TABLE
1042: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1043: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1044: , p6_a6 out nocopy JTF_DATE_TABLE
1045: , p6_a7 out nocopy JTF_DATE_TABLE
1046: , p6_a8 out nocopy JTF_DATE_TABLE
1047: , p6_a9 out nocopy JTF_DATE_TABLE
1046: , p6_a8 out nocopy JTF_DATE_TABLE
1047: , p6_a9 out nocopy JTF_DATE_TABLE
1048: , p6_a10 out nocopy JTF_DATE_TABLE
1049: , p6_a11 out nocopy JTF_DATE_TABLE
1050: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
1051: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
1052: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
1053: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
1054: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
1299: , p5_a0 JTF_NUMBER_TABLE
1300: , p5_a1 JTF_NUMBER_TABLE
1301: , p5_a2 JTF_NUMBER_TABLE
1302: , p5_a3 JTF_NUMBER_TABLE
1303: , p5_a4 JTF_VARCHAR2_TABLE_100
1304: , p5_a5 JTF_VARCHAR2_TABLE_100
1305: , p5_a6 JTF_DATE_TABLE
1306: , p5_a7 JTF_DATE_TABLE
1307: , p5_a8 JTF_DATE_TABLE
1300: , p5_a1 JTF_NUMBER_TABLE
1301: , p5_a2 JTF_NUMBER_TABLE
1302: , p5_a3 JTF_NUMBER_TABLE
1303: , p5_a4 JTF_VARCHAR2_TABLE_100
1304: , p5_a5 JTF_VARCHAR2_TABLE_100
1305: , p5_a6 JTF_DATE_TABLE
1306: , p5_a7 JTF_DATE_TABLE
1307: , p5_a8 JTF_DATE_TABLE
1308: , p5_a9 JTF_DATE_TABLE
1307: , p5_a8 JTF_DATE_TABLE
1308: , p5_a9 JTF_DATE_TABLE
1309: , p5_a10 JTF_DATE_TABLE
1310: , p5_a11 JTF_DATE_TABLE
1311: , p5_a12 JTF_VARCHAR2_TABLE_100
1312: , p5_a13 JTF_VARCHAR2_TABLE_500
1313: , p5_a14 JTF_VARCHAR2_TABLE_500
1314: , p5_a15 JTF_VARCHAR2_TABLE_500
1315: , p5_a16 JTF_VARCHAR2_TABLE_500
1333: , p5_a34 JTF_NUMBER_TABLE
1334: , p5_a35 JTF_DATE_TABLE
1335: , p5_a36 JTF_NUMBER_TABLE
1336: , p6_a0 in out nocopy JTF_NUMBER_TABLE
1337: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1338: , p6_a2 in out nocopy JTF_NUMBER_TABLE
1339: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1340: , p6_a4 in out nocopy JTF_NUMBER_TABLE
1341: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1337: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1338: , p6_a2 in out nocopy JTF_NUMBER_TABLE
1339: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1340: , p6_a4 in out nocopy JTF_NUMBER_TABLE
1341: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1342: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
1343: )
1344:
1345: as
1338: , p6_a2 in out nocopy JTF_NUMBER_TABLE
1339: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1340: , p6_a4 in out nocopy JTF_NUMBER_TABLE
1341: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1342: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
1343: )
1344:
1345: as
1346: ddp_vcrv_tbl okl_vcr_pvt.vcrv_tbl_type;
1436: , p5_a0 JTF_NUMBER_TABLE
1437: , p5_a1 JTF_NUMBER_TABLE
1438: , p5_a2 JTF_NUMBER_TABLE
1439: , p5_a3 JTF_NUMBER_TABLE
1440: , p5_a4 JTF_VARCHAR2_TABLE_100
1441: , p5_a5 JTF_VARCHAR2_TABLE_100
1442: , p5_a6 JTF_DATE_TABLE
1443: , p5_a7 JTF_DATE_TABLE
1444: , p5_a8 JTF_DATE_TABLE
1437: , p5_a1 JTF_NUMBER_TABLE
1438: , p5_a2 JTF_NUMBER_TABLE
1439: , p5_a3 JTF_NUMBER_TABLE
1440: , p5_a4 JTF_VARCHAR2_TABLE_100
1441: , p5_a5 JTF_VARCHAR2_TABLE_100
1442: , p5_a6 JTF_DATE_TABLE
1443: , p5_a7 JTF_DATE_TABLE
1444: , p5_a8 JTF_DATE_TABLE
1445: , p5_a9 JTF_DATE_TABLE
1444: , p5_a8 JTF_DATE_TABLE
1445: , p5_a9 JTF_DATE_TABLE
1446: , p5_a10 JTF_DATE_TABLE
1447: , p5_a11 JTF_DATE_TABLE
1448: , p5_a12 JTF_VARCHAR2_TABLE_100
1449: , p5_a13 JTF_VARCHAR2_TABLE_500
1450: , p5_a14 JTF_VARCHAR2_TABLE_500
1451: , p5_a15 JTF_VARCHAR2_TABLE_500
1452: , p5_a16 JTF_VARCHAR2_TABLE_500
1733: , p5_a0 JTF_NUMBER_TABLE
1734: , p5_a1 JTF_NUMBER_TABLE
1735: , p5_a2 JTF_NUMBER_TABLE
1736: , p5_a3 JTF_NUMBER_TABLE
1737: , p5_a4 JTF_VARCHAR2_TABLE_100
1738: , p5_a5 JTF_VARCHAR2_TABLE_100
1739: , p5_a6 JTF_DATE_TABLE
1740: , p5_a7 JTF_DATE_TABLE
1741: , p5_a8 JTF_DATE_TABLE
1734: , p5_a1 JTF_NUMBER_TABLE
1735: , p5_a2 JTF_NUMBER_TABLE
1736: , p5_a3 JTF_NUMBER_TABLE
1737: , p5_a4 JTF_VARCHAR2_TABLE_100
1738: , p5_a5 JTF_VARCHAR2_TABLE_100
1739: , p5_a6 JTF_DATE_TABLE
1740: , p5_a7 JTF_DATE_TABLE
1741: , p5_a8 JTF_DATE_TABLE
1742: , p5_a9 JTF_DATE_TABLE
1741: , p5_a8 JTF_DATE_TABLE
1742: , p5_a9 JTF_DATE_TABLE
1743: , p5_a10 JTF_DATE_TABLE
1744: , p5_a11 JTF_DATE_TABLE
1745: , p5_a12 JTF_VARCHAR2_TABLE_100
1746: , p5_a13 JTF_VARCHAR2_TABLE_500
1747: , p5_a14 JTF_VARCHAR2_TABLE_500
1748: , p5_a15 JTF_VARCHAR2_TABLE_500
1749: , p5_a16 JTF_VARCHAR2_TABLE_500
1770: , p6_a0 out nocopy JTF_NUMBER_TABLE
1771: , p6_a1 out nocopy JTF_NUMBER_TABLE
1772: , p6_a2 out nocopy JTF_NUMBER_TABLE
1773: , p6_a3 out nocopy JTF_NUMBER_TABLE
1774: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1775: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1776: , p6_a6 out nocopy JTF_DATE_TABLE
1777: , p6_a7 out nocopy JTF_DATE_TABLE
1778: , p6_a8 out nocopy JTF_DATE_TABLE
1771: , p6_a1 out nocopy JTF_NUMBER_TABLE
1772: , p6_a2 out nocopy JTF_NUMBER_TABLE
1773: , p6_a3 out nocopy JTF_NUMBER_TABLE
1774: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1775: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1776: , p6_a6 out nocopy JTF_DATE_TABLE
1777: , p6_a7 out nocopy JTF_DATE_TABLE
1778: , p6_a8 out nocopy JTF_DATE_TABLE
1779: , p6_a9 out nocopy JTF_DATE_TABLE
1778: , p6_a8 out nocopy JTF_DATE_TABLE
1779: , p6_a9 out nocopy JTF_DATE_TABLE
1780: , p6_a10 out nocopy JTF_DATE_TABLE
1781: , p6_a11 out nocopy JTF_DATE_TABLE
1782: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
1783: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
1784: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
1785: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
1786: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
1804: , p6_a34 out nocopy JTF_NUMBER_TABLE
1805: , p6_a35 out nocopy JTF_DATE_TABLE
1806: , p6_a36 out nocopy JTF_NUMBER_TABLE
1807: , p7_a0 in out nocopy JTF_NUMBER_TABLE
1808: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1809: , p7_a2 in out nocopy JTF_NUMBER_TABLE
1810: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1811: , p7_a4 in out nocopy JTF_NUMBER_TABLE
1812: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1808: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1809: , p7_a2 in out nocopy JTF_NUMBER_TABLE
1810: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1811: , p7_a4 in out nocopy JTF_NUMBER_TABLE
1812: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1813: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
1814: )
1815:
1816: as
1809: , p7_a2 in out nocopy JTF_NUMBER_TABLE
1810: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1811: , p7_a4 in out nocopy JTF_NUMBER_TABLE
1812: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1813: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
1814: )
1815:
1816: as
1817: ddp_vcrv_tbl okl_vcr_pvt.vcrv_tbl_type;
1949: , p5_a0 JTF_NUMBER_TABLE
1950: , p5_a1 JTF_NUMBER_TABLE
1951: , p5_a2 JTF_NUMBER_TABLE
1952: , p5_a3 JTF_NUMBER_TABLE
1953: , p5_a4 JTF_VARCHAR2_TABLE_100
1954: , p5_a5 JTF_VARCHAR2_TABLE_100
1955: , p5_a6 JTF_DATE_TABLE
1956: , p5_a7 JTF_DATE_TABLE
1957: , p5_a8 JTF_DATE_TABLE
1950: , p5_a1 JTF_NUMBER_TABLE
1951: , p5_a2 JTF_NUMBER_TABLE
1952: , p5_a3 JTF_NUMBER_TABLE
1953: , p5_a4 JTF_VARCHAR2_TABLE_100
1954: , p5_a5 JTF_VARCHAR2_TABLE_100
1955: , p5_a6 JTF_DATE_TABLE
1956: , p5_a7 JTF_DATE_TABLE
1957: , p5_a8 JTF_DATE_TABLE
1958: , p5_a9 JTF_DATE_TABLE
1957: , p5_a8 JTF_DATE_TABLE
1958: , p5_a9 JTF_DATE_TABLE
1959: , p5_a10 JTF_DATE_TABLE
1960: , p5_a11 JTF_DATE_TABLE
1961: , p5_a12 JTF_VARCHAR2_TABLE_100
1962: , p5_a13 JTF_VARCHAR2_TABLE_500
1963: , p5_a14 JTF_VARCHAR2_TABLE_500
1964: , p5_a15 JTF_VARCHAR2_TABLE_500
1965: , p5_a16 JTF_VARCHAR2_TABLE_500
1986: , p6_a0 out nocopy JTF_NUMBER_TABLE
1987: , p6_a1 out nocopy JTF_NUMBER_TABLE
1988: , p6_a2 out nocopy JTF_NUMBER_TABLE
1989: , p6_a3 out nocopy JTF_NUMBER_TABLE
1990: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1991: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1992: , p6_a6 out nocopy JTF_DATE_TABLE
1993: , p6_a7 out nocopy JTF_DATE_TABLE
1994: , p6_a8 out nocopy JTF_DATE_TABLE
1987: , p6_a1 out nocopy JTF_NUMBER_TABLE
1988: , p6_a2 out nocopy JTF_NUMBER_TABLE
1989: , p6_a3 out nocopy JTF_NUMBER_TABLE
1990: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1991: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1992: , p6_a6 out nocopy JTF_DATE_TABLE
1993: , p6_a7 out nocopy JTF_DATE_TABLE
1994: , p6_a8 out nocopy JTF_DATE_TABLE
1995: , p6_a9 out nocopy JTF_DATE_TABLE
1994: , p6_a8 out nocopy JTF_DATE_TABLE
1995: , p6_a9 out nocopy JTF_DATE_TABLE
1996: , p6_a10 out nocopy JTF_DATE_TABLE
1997: , p6_a11 out nocopy JTF_DATE_TABLE
1998: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
1999: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
2000: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
2001: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
2002: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
2247: , p5_a0 JTF_NUMBER_TABLE
2248: , p5_a1 JTF_NUMBER_TABLE
2249: , p5_a2 JTF_NUMBER_TABLE
2250: , p5_a3 JTF_NUMBER_TABLE
2251: , p5_a4 JTF_VARCHAR2_TABLE_100
2252: , p5_a5 JTF_VARCHAR2_TABLE_100
2253: , p5_a6 JTF_DATE_TABLE
2254: , p5_a7 JTF_DATE_TABLE
2255: , p5_a8 JTF_DATE_TABLE
2248: , p5_a1 JTF_NUMBER_TABLE
2249: , p5_a2 JTF_NUMBER_TABLE
2250: , p5_a3 JTF_NUMBER_TABLE
2251: , p5_a4 JTF_VARCHAR2_TABLE_100
2252: , p5_a5 JTF_VARCHAR2_TABLE_100
2253: , p5_a6 JTF_DATE_TABLE
2254: , p5_a7 JTF_DATE_TABLE
2255: , p5_a8 JTF_DATE_TABLE
2256: , p5_a9 JTF_DATE_TABLE
2255: , p5_a8 JTF_DATE_TABLE
2256: , p5_a9 JTF_DATE_TABLE
2257: , p5_a10 JTF_DATE_TABLE
2258: , p5_a11 JTF_DATE_TABLE
2259: , p5_a12 JTF_VARCHAR2_TABLE_100
2260: , p5_a13 JTF_VARCHAR2_TABLE_500
2261: , p5_a14 JTF_VARCHAR2_TABLE_500
2262: , p5_a15 JTF_VARCHAR2_TABLE_500
2263: , p5_a16 JTF_VARCHAR2_TABLE_500
2281: , p5_a34 JTF_NUMBER_TABLE
2282: , p5_a35 JTF_DATE_TABLE
2283: , p5_a36 JTF_NUMBER_TABLE
2284: , p6_a0 in out nocopy JTF_NUMBER_TABLE
2285: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
2286: , p6_a2 in out nocopy JTF_NUMBER_TABLE
2287: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
2288: , p6_a4 in out nocopy JTF_NUMBER_TABLE
2289: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
2285: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
2286: , p6_a2 in out nocopy JTF_NUMBER_TABLE
2287: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
2288: , p6_a4 in out nocopy JTF_NUMBER_TABLE
2289: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
2290: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
2291: )
2292:
2293: as
2286: , p6_a2 in out nocopy JTF_NUMBER_TABLE
2287: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
2288: , p6_a4 in out nocopy JTF_NUMBER_TABLE
2289: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
2290: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
2291: )
2292:
2293: as
2294: ddp_vcrv_tbl okl_vcr_pvt.vcrv_tbl_type;
2384: , p5_a0 JTF_NUMBER_TABLE
2385: , p5_a1 JTF_NUMBER_TABLE
2386: , p5_a2 JTF_NUMBER_TABLE
2387: , p5_a3 JTF_NUMBER_TABLE
2388: , p5_a4 JTF_VARCHAR2_TABLE_100
2389: , p5_a5 JTF_VARCHAR2_TABLE_100
2390: , p5_a6 JTF_DATE_TABLE
2391: , p5_a7 JTF_DATE_TABLE
2392: , p5_a8 JTF_DATE_TABLE
2385: , p5_a1 JTF_NUMBER_TABLE
2386: , p5_a2 JTF_NUMBER_TABLE
2387: , p5_a3 JTF_NUMBER_TABLE
2388: , p5_a4 JTF_VARCHAR2_TABLE_100
2389: , p5_a5 JTF_VARCHAR2_TABLE_100
2390: , p5_a6 JTF_DATE_TABLE
2391: , p5_a7 JTF_DATE_TABLE
2392: , p5_a8 JTF_DATE_TABLE
2393: , p5_a9 JTF_DATE_TABLE
2392: , p5_a8 JTF_DATE_TABLE
2393: , p5_a9 JTF_DATE_TABLE
2394: , p5_a10 JTF_DATE_TABLE
2395: , p5_a11 JTF_DATE_TABLE
2396: , p5_a12 JTF_VARCHAR2_TABLE_100
2397: , p5_a13 JTF_VARCHAR2_TABLE_500
2398: , p5_a14 JTF_VARCHAR2_TABLE_500
2399: , p5_a15 JTF_VARCHAR2_TABLE_500
2400: , p5_a16 JTF_VARCHAR2_TABLE_500
2603: , p5_a0 JTF_NUMBER_TABLE
2604: , p5_a1 JTF_NUMBER_TABLE
2605: , p5_a2 JTF_NUMBER_TABLE
2606: , p5_a3 JTF_NUMBER_TABLE
2607: , p5_a4 JTF_VARCHAR2_TABLE_100
2608: , p5_a5 JTF_VARCHAR2_TABLE_100
2609: , p5_a6 JTF_DATE_TABLE
2610: , p5_a7 JTF_DATE_TABLE
2611: , p5_a8 JTF_DATE_TABLE
2604: , p5_a1 JTF_NUMBER_TABLE
2605: , p5_a2 JTF_NUMBER_TABLE
2606: , p5_a3 JTF_NUMBER_TABLE
2607: , p5_a4 JTF_VARCHAR2_TABLE_100
2608: , p5_a5 JTF_VARCHAR2_TABLE_100
2609: , p5_a6 JTF_DATE_TABLE
2610: , p5_a7 JTF_DATE_TABLE
2611: , p5_a8 JTF_DATE_TABLE
2612: , p5_a9 JTF_DATE_TABLE
2611: , p5_a8 JTF_DATE_TABLE
2612: , p5_a9 JTF_DATE_TABLE
2613: , p5_a10 JTF_DATE_TABLE
2614: , p5_a11 JTF_DATE_TABLE
2615: , p5_a12 JTF_VARCHAR2_TABLE_100
2616: , p5_a13 JTF_VARCHAR2_TABLE_500
2617: , p5_a14 JTF_VARCHAR2_TABLE_500
2618: , p5_a15 JTF_VARCHAR2_TABLE_500
2619: , p5_a16 JTF_VARCHAR2_TABLE_500
2637: , p5_a34 JTF_NUMBER_TABLE
2638: , p5_a35 JTF_DATE_TABLE
2639: , p5_a36 JTF_NUMBER_TABLE
2640: , p6_a0 in out nocopy JTF_NUMBER_TABLE
2641: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
2642: , p6_a2 in out nocopy JTF_NUMBER_TABLE
2643: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
2644: , p6_a4 in out nocopy JTF_NUMBER_TABLE
2645: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
2641: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
2642: , p6_a2 in out nocopy JTF_NUMBER_TABLE
2643: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
2644: , p6_a4 in out nocopy JTF_NUMBER_TABLE
2645: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
2646: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
2647: )
2648:
2649: as
2642: , p6_a2 in out nocopy JTF_NUMBER_TABLE
2643: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
2644: , p6_a4 in out nocopy JTF_NUMBER_TABLE
2645: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
2646: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
2647: )
2648:
2649: as
2650: ddp_vcrv_tbl okl_vcr_pvt.vcrv_tbl_type;
2740: , p5_a0 JTF_NUMBER_TABLE
2741: , p5_a1 JTF_NUMBER_TABLE
2742: , p5_a2 JTF_NUMBER_TABLE
2743: , p5_a3 JTF_NUMBER_TABLE
2744: , p5_a4 JTF_VARCHAR2_TABLE_100
2745: , p5_a5 JTF_VARCHAR2_TABLE_100
2746: , p5_a6 JTF_DATE_TABLE
2747: , p5_a7 JTF_DATE_TABLE
2748: , p5_a8 JTF_DATE_TABLE
2741: , p5_a1 JTF_NUMBER_TABLE
2742: , p5_a2 JTF_NUMBER_TABLE
2743: , p5_a3 JTF_NUMBER_TABLE
2744: , p5_a4 JTF_VARCHAR2_TABLE_100
2745: , p5_a5 JTF_VARCHAR2_TABLE_100
2746: , p5_a6 JTF_DATE_TABLE
2747: , p5_a7 JTF_DATE_TABLE
2748: , p5_a8 JTF_DATE_TABLE
2749: , p5_a9 JTF_DATE_TABLE
2748: , p5_a8 JTF_DATE_TABLE
2749: , p5_a9 JTF_DATE_TABLE
2750: , p5_a10 JTF_DATE_TABLE
2751: , p5_a11 JTF_DATE_TABLE
2752: , p5_a12 JTF_VARCHAR2_TABLE_100
2753: , p5_a13 JTF_VARCHAR2_TABLE_500
2754: , p5_a14 JTF_VARCHAR2_TABLE_500
2755: , p5_a15 JTF_VARCHAR2_TABLE_500
2756: , p5_a16 JTF_VARCHAR2_TABLE_500