24:
25: procedure rosetta_table_copy_in_p2(t out nocopy okl_drs_pvt.drs_tbl_type, a0 JTF_NUMBER_TABLE
26: , a1 JTF_NUMBER_TABLE
27: , a2 JTF_NUMBER_TABLE
28: , a3 JTF_VARCHAR2_TABLE_100
29: , a4 JTF_VARCHAR2_TABLE_100
30: , a5 JTF_VARCHAR2_TABLE_500
31: , a6 JTF_VARCHAR2_TABLE_500
32: , a7 JTF_VARCHAR2_TABLE_500
25: procedure rosetta_table_copy_in_p2(t out nocopy okl_drs_pvt.drs_tbl_type, a0 JTF_NUMBER_TABLE
26: , a1 JTF_NUMBER_TABLE
27: , a2 JTF_NUMBER_TABLE
28: , a3 JTF_VARCHAR2_TABLE_100
29: , a4 JTF_VARCHAR2_TABLE_100
30: , a5 JTF_VARCHAR2_TABLE_500
31: , a6 JTF_VARCHAR2_TABLE_500
32: , a7 JTF_VARCHAR2_TABLE_500
33: , a8 JTF_VARCHAR2_TABLE_500
91: end rosetta_table_copy_in_p2;
92: procedure rosetta_table_copy_out_p2(t okl_drs_pvt.drs_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
93: , a1 out nocopy JTF_NUMBER_TABLE
94: , a2 out nocopy JTF_NUMBER_TABLE
95: , a3 out nocopy JTF_VARCHAR2_TABLE_100
96: , a4 out nocopy JTF_VARCHAR2_TABLE_100
97: , a5 out nocopy JTF_VARCHAR2_TABLE_500
98: , a6 out nocopy JTF_VARCHAR2_TABLE_500
99: , a7 out nocopy JTF_VARCHAR2_TABLE_500
92: procedure rosetta_table_copy_out_p2(t okl_drs_pvt.drs_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
93: , a1 out nocopy JTF_NUMBER_TABLE
94: , a2 out nocopy JTF_NUMBER_TABLE
95: , a3 out nocopy JTF_VARCHAR2_TABLE_100
96: , a4 out nocopy JTF_VARCHAR2_TABLE_100
97: , a5 out nocopy JTF_VARCHAR2_TABLE_500
98: , a6 out nocopy JTF_VARCHAR2_TABLE_500
99: , a7 out nocopy JTF_VARCHAR2_TABLE_500
100: , a8 out nocopy JTF_VARCHAR2_TABLE_500
120: if t is null or t.count = 0 then
121: a0 := JTF_NUMBER_TABLE();
122: a1 := JTF_NUMBER_TABLE();
123: a2 := JTF_NUMBER_TABLE();
124: a3 := JTF_VARCHAR2_TABLE_100();
125: a4 := JTF_VARCHAR2_TABLE_100();
126: a5 := JTF_VARCHAR2_TABLE_500();
127: a6 := JTF_VARCHAR2_TABLE_500();
128: a7 := JTF_VARCHAR2_TABLE_500();
121: a0 := JTF_NUMBER_TABLE();
122: a1 := JTF_NUMBER_TABLE();
123: a2 := JTF_NUMBER_TABLE();
124: a3 := JTF_VARCHAR2_TABLE_100();
125: a4 := JTF_VARCHAR2_TABLE_100();
126: a5 := JTF_VARCHAR2_TABLE_500();
127: a6 := JTF_VARCHAR2_TABLE_500();
128: a7 := JTF_VARCHAR2_TABLE_500();
129: a8 := JTF_VARCHAR2_TABLE_500();
146: else
147: a0 := JTF_NUMBER_TABLE();
148: a1 := JTF_NUMBER_TABLE();
149: a2 := JTF_NUMBER_TABLE();
150: a3 := JTF_VARCHAR2_TABLE_100();
151: a4 := JTF_VARCHAR2_TABLE_100();
152: a5 := JTF_VARCHAR2_TABLE_500();
153: a6 := JTF_VARCHAR2_TABLE_500();
154: a7 := JTF_VARCHAR2_TABLE_500();
147: a0 := JTF_NUMBER_TABLE();
148: a1 := JTF_NUMBER_TABLE();
149: a2 := JTF_NUMBER_TABLE();
150: a3 := JTF_VARCHAR2_TABLE_100();
151: a4 := JTF_VARCHAR2_TABLE_100();
152: a5 := JTF_VARCHAR2_TABLE_500();
153: a6 := JTF_VARCHAR2_TABLE_500();
154: a7 := JTF_VARCHAR2_TABLE_500();
155: a8 := JTF_VARCHAR2_TABLE_500();
379: , x_msg_data out nocopy VARCHAR2
380: , p5_a0 JTF_NUMBER_TABLE
381: , p5_a1 JTF_NUMBER_TABLE
382: , p5_a2 JTF_NUMBER_TABLE
383: , p5_a3 JTF_VARCHAR2_TABLE_100
384: , p5_a4 JTF_VARCHAR2_TABLE_100
385: , p5_a5 JTF_VARCHAR2_TABLE_500
386: , p5_a6 JTF_VARCHAR2_TABLE_500
387: , p5_a7 JTF_VARCHAR2_TABLE_500
380: , p5_a0 JTF_NUMBER_TABLE
381: , p5_a1 JTF_NUMBER_TABLE
382: , p5_a2 JTF_NUMBER_TABLE
383: , p5_a3 JTF_VARCHAR2_TABLE_100
384: , p5_a4 JTF_VARCHAR2_TABLE_100
385: , p5_a5 JTF_VARCHAR2_TABLE_500
386: , p5_a6 JTF_VARCHAR2_TABLE_500
387: , p5_a7 JTF_VARCHAR2_TABLE_500
388: , p5_a8 JTF_VARCHAR2_TABLE_500
404: , p5_a24 JTF_NUMBER_TABLE
405: , p6_a0 out nocopy JTF_NUMBER_TABLE
406: , p6_a1 out nocopy JTF_NUMBER_TABLE
407: , p6_a2 out nocopy JTF_NUMBER_TABLE
408: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
409: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
410: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500
411: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
412: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
405: , p6_a0 out nocopy JTF_NUMBER_TABLE
406: , p6_a1 out nocopy JTF_NUMBER_TABLE
407: , p6_a2 out nocopy JTF_NUMBER_TABLE
408: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
409: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
410: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500
411: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
412: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
413: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
605: , x_msg_data out nocopy VARCHAR2
606: , p5_a0 JTF_NUMBER_TABLE
607: , p5_a1 JTF_NUMBER_TABLE
608: , p5_a2 JTF_NUMBER_TABLE
609: , p5_a3 JTF_VARCHAR2_TABLE_100
610: , p5_a4 JTF_VARCHAR2_TABLE_100
611: , p5_a5 JTF_VARCHAR2_TABLE_500
612: , p5_a6 JTF_VARCHAR2_TABLE_500
613: , p5_a7 JTF_VARCHAR2_TABLE_500
606: , p5_a0 JTF_NUMBER_TABLE
607: , p5_a1 JTF_NUMBER_TABLE
608: , p5_a2 JTF_NUMBER_TABLE
609: , p5_a3 JTF_VARCHAR2_TABLE_100
610: , p5_a4 JTF_VARCHAR2_TABLE_100
611: , p5_a5 JTF_VARCHAR2_TABLE_500
612: , p5_a6 JTF_VARCHAR2_TABLE_500
613: , p5_a7 JTF_VARCHAR2_TABLE_500
614: , p5_a8 JTF_VARCHAR2_TABLE_500
830: , x_msg_data out nocopy VARCHAR2
831: , p5_a0 JTF_NUMBER_TABLE
832: , p5_a1 JTF_NUMBER_TABLE
833: , p5_a2 JTF_NUMBER_TABLE
834: , p5_a3 JTF_VARCHAR2_TABLE_100
835: , p5_a4 JTF_VARCHAR2_TABLE_100
836: , p5_a5 JTF_VARCHAR2_TABLE_500
837: , p5_a6 JTF_VARCHAR2_TABLE_500
838: , p5_a7 JTF_VARCHAR2_TABLE_500
831: , p5_a0 JTF_NUMBER_TABLE
832: , p5_a1 JTF_NUMBER_TABLE
833: , p5_a2 JTF_NUMBER_TABLE
834: , p5_a3 JTF_VARCHAR2_TABLE_100
835: , p5_a4 JTF_VARCHAR2_TABLE_100
836: , p5_a5 JTF_VARCHAR2_TABLE_500
837: , p5_a6 JTF_VARCHAR2_TABLE_500
838: , p5_a7 JTF_VARCHAR2_TABLE_500
839: , p5_a8 JTF_VARCHAR2_TABLE_500
855: , p5_a24 JTF_NUMBER_TABLE
856: , p6_a0 out nocopy JTF_NUMBER_TABLE
857: , p6_a1 out nocopy JTF_NUMBER_TABLE
858: , p6_a2 out nocopy JTF_NUMBER_TABLE
859: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
860: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
861: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500
862: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
863: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
856: , p6_a0 out nocopy JTF_NUMBER_TABLE
857: , p6_a1 out nocopy JTF_NUMBER_TABLE
858: , p6_a2 out nocopy JTF_NUMBER_TABLE
859: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
860: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
861: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500
862: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
863: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
864: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
1056: , x_msg_data out nocopy VARCHAR2
1057: , p5_a0 JTF_NUMBER_TABLE
1058: , p5_a1 JTF_NUMBER_TABLE
1059: , p5_a2 JTF_NUMBER_TABLE
1060: , p5_a3 JTF_VARCHAR2_TABLE_100
1061: , p5_a4 JTF_VARCHAR2_TABLE_100
1062: , p5_a5 JTF_VARCHAR2_TABLE_500
1063: , p5_a6 JTF_VARCHAR2_TABLE_500
1064: , p5_a7 JTF_VARCHAR2_TABLE_500
1057: , p5_a0 JTF_NUMBER_TABLE
1058: , p5_a1 JTF_NUMBER_TABLE
1059: , p5_a2 JTF_NUMBER_TABLE
1060: , p5_a3 JTF_VARCHAR2_TABLE_100
1061: , p5_a4 JTF_VARCHAR2_TABLE_100
1062: , p5_a5 JTF_VARCHAR2_TABLE_500
1063: , p5_a6 JTF_VARCHAR2_TABLE_500
1064: , p5_a7 JTF_VARCHAR2_TABLE_500
1065: , p5_a8 JTF_VARCHAR2_TABLE_500
1227: , x_msg_data out nocopy VARCHAR2
1228: , p5_a0 JTF_NUMBER_TABLE
1229: , p5_a1 JTF_NUMBER_TABLE
1230: , p5_a2 JTF_NUMBER_TABLE
1231: , p5_a3 JTF_VARCHAR2_TABLE_100
1232: , p5_a4 JTF_VARCHAR2_TABLE_100
1233: , p5_a5 JTF_VARCHAR2_TABLE_500
1234: , p5_a6 JTF_VARCHAR2_TABLE_500
1235: , p5_a7 JTF_VARCHAR2_TABLE_500
1228: , p5_a0 JTF_NUMBER_TABLE
1229: , p5_a1 JTF_NUMBER_TABLE
1230: , p5_a2 JTF_NUMBER_TABLE
1231: , p5_a3 JTF_VARCHAR2_TABLE_100
1232: , p5_a4 JTF_VARCHAR2_TABLE_100
1233: , p5_a5 JTF_VARCHAR2_TABLE_500
1234: , p5_a6 JTF_VARCHAR2_TABLE_500
1235: , p5_a7 JTF_VARCHAR2_TABLE_500
1236: , p5_a8 JTF_VARCHAR2_TABLE_500