20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_aet_pvt.aet_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_DATE_TABLE
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_DATE_TABLE
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_VARCHAR2_TABLE_100
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_NUMBER_TABLE
25: , a3 JTF_DATE_TABLE
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_VARCHAR2_TABLE_100
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_DATE_TABLE
73: end if;
74: end rosetta_table_copy_in_p2;
75: procedure rosetta_table_copy_out_p2(t okl_aet_pvt.aet_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
76: , a1 out nocopy JTF_NUMBER_TABLE
77: , a2 out nocopy JTF_VARCHAR2_TABLE_100
78: , a3 out nocopy JTF_DATE_TABLE
79: , a4 out nocopy JTF_NUMBER_TABLE
80: , a5 out nocopy JTF_VARCHAR2_TABLE_100
81: , a6 out nocopy JTF_NUMBER_TABLE
76: , a1 out nocopy JTF_NUMBER_TABLE
77: , a2 out nocopy JTF_VARCHAR2_TABLE_100
78: , a3 out nocopy JTF_DATE_TABLE
79: , a4 out nocopy JTF_NUMBER_TABLE
80: , a5 out nocopy JTF_VARCHAR2_TABLE_100
81: , a6 out nocopy JTF_NUMBER_TABLE
82: , a7 out nocopy JTF_VARCHAR2_TABLE_100
83: , a8 out nocopy JTF_NUMBER_TABLE
84: , a9 out nocopy JTF_NUMBER_TABLE
78: , a3 out nocopy JTF_DATE_TABLE
79: , a4 out nocopy JTF_NUMBER_TABLE
80: , a5 out nocopy JTF_VARCHAR2_TABLE_100
81: , a6 out nocopy JTF_NUMBER_TABLE
82: , a7 out nocopy JTF_VARCHAR2_TABLE_100
83: , a8 out nocopy JTF_NUMBER_TABLE
84: , a9 out nocopy JTF_NUMBER_TABLE
85: , a10 out nocopy JTF_NUMBER_TABLE
86: , a11 out nocopy JTF_DATE_TABLE
95: begin
96: if t is null or t.count = 0 then
97: a0 := JTF_NUMBER_TABLE();
98: a1 := JTF_NUMBER_TABLE();
99: a2 := JTF_VARCHAR2_TABLE_100();
100: a3 := JTF_DATE_TABLE();
101: a4 := JTF_NUMBER_TABLE();
102: a5 := JTF_VARCHAR2_TABLE_100();
103: a6 := JTF_NUMBER_TABLE();
98: a1 := JTF_NUMBER_TABLE();
99: a2 := JTF_VARCHAR2_TABLE_100();
100: a3 := JTF_DATE_TABLE();
101: a4 := JTF_NUMBER_TABLE();
102: a5 := JTF_VARCHAR2_TABLE_100();
103: a6 := JTF_NUMBER_TABLE();
104: a7 := JTF_VARCHAR2_TABLE_100();
105: a8 := JTF_NUMBER_TABLE();
106: a9 := JTF_NUMBER_TABLE();
100: a3 := JTF_DATE_TABLE();
101: a4 := JTF_NUMBER_TABLE();
102: a5 := JTF_VARCHAR2_TABLE_100();
103: a6 := JTF_NUMBER_TABLE();
104: a7 := JTF_VARCHAR2_TABLE_100();
105: a8 := JTF_NUMBER_TABLE();
106: a9 := JTF_NUMBER_TABLE();
107: a10 := JTF_NUMBER_TABLE();
108: a11 := JTF_DATE_TABLE();
114: a17 := JTF_NUMBER_TABLE();
115: else
116: a0 := JTF_NUMBER_TABLE();
117: a1 := JTF_NUMBER_TABLE();
118: a2 := JTF_VARCHAR2_TABLE_100();
119: a3 := JTF_DATE_TABLE();
120: a4 := JTF_NUMBER_TABLE();
121: a5 := JTF_VARCHAR2_TABLE_100();
122: a6 := JTF_NUMBER_TABLE();
117: a1 := JTF_NUMBER_TABLE();
118: a2 := JTF_VARCHAR2_TABLE_100();
119: a3 := JTF_DATE_TABLE();
120: a4 := JTF_NUMBER_TABLE();
121: a5 := JTF_VARCHAR2_TABLE_100();
122: a6 := JTF_NUMBER_TABLE();
123: a7 := JTF_VARCHAR2_TABLE_100();
124: a8 := JTF_NUMBER_TABLE();
125: a9 := JTF_NUMBER_TABLE();
119: a3 := JTF_DATE_TABLE();
120: a4 := JTF_NUMBER_TABLE();
121: a5 := JTF_VARCHAR2_TABLE_100();
122: a6 := JTF_NUMBER_TABLE();
123: a7 := JTF_VARCHAR2_TABLE_100();
124: a8 := JTF_NUMBER_TABLE();
125: a9 := JTF_NUMBER_TABLE();
126: a10 := JTF_NUMBER_TABLE();
127: a11 := JTF_DATE_TABLE();
183:
184: procedure rosetta_table_copy_in_p5(t out nocopy okl_aet_pvt.aetv_tbl_type, a0 JTF_NUMBER_TABLE
185: , a1 JTF_NUMBER_TABLE
186: , a2 JTF_NUMBER_TABLE
187: , a3 JTF_VARCHAR2_TABLE_100
188: , a4 JTF_DATE_TABLE
189: , a5 JTF_NUMBER_TABLE
190: , a6 JTF_VARCHAR2_TABLE_100
191: , a7 JTF_NUMBER_TABLE
186: , a2 JTF_NUMBER_TABLE
187: , a3 JTF_VARCHAR2_TABLE_100
188: , a4 JTF_DATE_TABLE
189: , a5 JTF_NUMBER_TABLE
190: , a6 JTF_VARCHAR2_TABLE_100
191: , a7 JTF_NUMBER_TABLE
192: , a8 JTF_VARCHAR2_TABLE_100
193: , a9 JTF_NUMBER_TABLE
194: , a10 JTF_NUMBER_TABLE
188: , a4 JTF_DATE_TABLE
189: , a5 JTF_NUMBER_TABLE
190: , a6 JTF_VARCHAR2_TABLE_100
191: , a7 JTF_NUMBER_TABLE
192: , a8 JTF_VARCHAR2_TABLE_100
193: , a9 JTF_NUMBER_TABLE
194: , a10 JTF_NUMBER_TABLE
195: , a11 JTF_DATE_TABLE
196: , a12 JTF_NUMBER_TABLE
236: end rosetta_table_copy_in_p5;
237: procedure rosetta_table_copy_out_p5(t okl_aet_pvt.aetv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
238: , a1 out nocopy JTF_NUMBER_TABLE
239: , a2 out nocopy JTF_NUMBER_TABLE
240: , a3 out nocopy JTF_VARCHAR2_TABLE_100
241: , a4 out nocopy JTF_DATE_TABLE
242: , a5 out nocopy JTF_NUMBER_TABLE
243: , a6 out nocopy JTF_VARCHAR2_TABLE_100
244: , a7 out nocopy JTF_NUMBER_TABLE
239: , a2 out nocopy JTF_NUMBER_TABLE
240: , a3 out nocopy JTF_VARCHAR2_TABLE_100
241: , a4 out nocopy JTF_DATE_TABLE
242: , a5 out nocopy JTF_NUMBER_TABLE
243: , a6 out nocopy JTF_VARCHAR2_TABLE_100
244: , a7 out nocopy JTF_NUMBER_TABLE
245: , a8 out nocopy JTF_VARCHAR2_TABLE_100
246: , a9 out nocopy JTF_NUMBER_TABLE
247: , a10 out nocopy JTF_NUMBER_TABLE
241: , a4 out nocopy JTF_DATE_TABLE
242: , a5 out nocopy JTF_NUMBER_TABLE
243: , a6 out nocopy JTF_VARCHAR2_TABLE_100
244: , a7 out nocopy JTF_NUMBER_TABLE
245: , a8 out nocopy JTF_VARCHAR2_TABLE_100
246: , a9 out nocopy JTF_NUMBER_TABLE
247: , a10 out nocopy JTF_NUMBER_TABLE
248: , a11 out nocopy JTF_DATE_TABLE
249: , a12 out nocopy JTF_NUMBER_TABLE
258: if t is null or t.count = 0 then
259: a0 := JTF_NUMBER_TABLE();
260: a1 := JTF_NUMBER_TABLE();
261: a2 := JTF_NUMBER_TABLE();
262: a3 := JTF_VARCHAR2_TABLE_100();
263: a4 := JTF_DATE_TABLE();
264: a5 := JTF_NUMBER_TABLE();
265: a6 := JTF_VARCHAR2_TABLE_100();
266: a7 := JTF_NUMBER_TABLE();
261: a2 := JTF_NUMBER_TABLE();
262: a3 := JTF_VARCHAR2_TABLE_100();
263: a4 := JTF_DATE_TABLE();
264: a5 := JTF_NUMBER_TABLE();
265: a6 := JTF_VARCHAR2_TABLE_100();
266: a7 := JTF_NUMBER_TABLE();
267: a8 := JTF_VARCHAR2_TABLE_100();
268: a9 := JTF_NUMBER_TABLE();
269: a10 := JTF_NUMBER_TABLE();
263: a4 := JTF_DATE_TABLE();
264: a5 := JTF_NUMBER_TABLE();
265: a6 := JTF_VARCHAR2_TABLE_100();
266: a7 := JTF_NUMBER_TABLE();
267: a8 := JTF_VARCHAR2_TABLE_100();
268: a9 := JTF_NUMBER_TABLE();
269: a10 := JTF_NUMBER_TABLE();
270: a11 := JTF_DATE_TABLE();
271: a12 := JTF_NUMBER_TABLE();
277: else
278: a0 := JTF_NUMBER_TABLE();
279: a1 := JTF_NUMBER_TABLE();
280: a2 := JTF_NUMBER_TABLE();
281: a3 := JTF_VARCHAR2_TABLE_100();
282: a4 := JTF_DATE_TABLE();
283: a5 := JTF_NUMBER_TABLE();
284: a6 := JTF_VARCHAR2_TABLE_100();
285: a7 := JTF_NUMBER_TABLE();
280: a2 := JTF_NUMBER_TABLE();
281: a3 := JTF_VARCHAR2_TABLE_100();
282: a4 := JTF_DATE_TABLE();
283: a5 := JTF_NUMBER_TABLE();
284: a6 := JTF_VARCHAR2_TABLE_100();
285: a7 := JTF_NUMBER_TABLE();
286: a8 := JTF_VARCHAR2_TABLE_100();
287: a9 := JTF_NUMBER_TABLE();
288: a10 := JTF_NUMBER_TABLE();
282: a4 := JTF_DATE_TABLE();
283: a5 := JTF_NUMBER_TABLE();
284: a6 := JTF_VARCHAR2_TABLE_100();
285: a7 := JTF_NUMBER_TABLE();
286: a8 := JTF_VARCHAR2_TABLE_100();
287: a9 := JTF_NUMBER_TABLE();
288: a10 := JTF_NUMBER_TABLE();
289: a11 := JTF_DATE_TABLE();
290: a12 := JTF_NUMBER_TABLE();
461: , x_msg_data out nocopy VARCHAR2
462: , p5_a0 JTF_NUMBER_TABLE
463: , p5_a1 JTF_NUMBER_TABLE
464: , p5_a2 JTF_NUMBER_TABLE
465: , p5_a3 JTF_VARCHAR2_TABLE_100
466: , p5_a4 JTF_DATE_TABLE
467: , p5_a5 JTF_NUMBER_TABLE
468: , p5_a6 JTF_VARCHAR2_TABLE_100
469: , p5_a7 JTF_NUMBER_TABLE
464: , p5_a2 JTF_NUMBER_TABLE
465: , p5_a3 JTF_VARCHAR2_TABLE_100
466: , p5_a4 JTF_DATE_TABLE
467: , p5_a5 JTF_NUMBER_TABLE
468: , p5_a6 JTF_VARCHAR2_TABLE_100
469: , p5_a7 JTF_NUMBER_TABLE
470: , p5_a8 JTF_VARCHAR2_TABLE_100
471: , p5_a9 JTF_NUMBER_TABLE
472: , p5_a10 JTF_NUMBER_TABLE
466: , p5_a4 JTF_DATE_TABLE
467: , p5_a5 JTF_NUMBER_TABLE
468: , p5_a6 JTF_VARCHAR2_TABLE_100
469: , p5_a7 JTF_NUMBER_TABLE
470: , p5_a8 JTF_VARCHAR2_TABLE_100
471: , p5_a9 JTF_NUMBER_TABLE
472: , p5_a10 JTF_NUMBER_TABLE
473: , p5_a11 JTF_DATE_TABLE
474: , p5_a12 JTF_NUMBER_TABLE
479: , p5_a17 JTF_NUMBER_TABLE
480: , p6_a0 out nocopy JTF_NUMBER_TABLE
481: , p6_a1 out nocopy JTF_NUMBER_TABLE
482: , p6_a2 out nocopy JTF_NUMBER_TABLE
483: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
484: , p6_a4 out nocopy JTF_DATE_TABLE
485: , p6_a5 out nocopy JTF_NUMBER_TABLE
486: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
487: , p6_a7 out nocopy JTF_NUMBER_TABLE
482: , p6_a2 out nocopy JTF_NUMBER_TABLE
483: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
484: , p6_a4 out nocopy JTF_DATE_TABLE
485: , p6_a5 out nocopy JTF_NUMBER_TABLE
486: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
487: , p6_a7 out nocopy JTF_NUMBER_TABLE
488: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
489: , p6_a9 out nocopy JTF_NUMBER_TABLE
490: , p6_a10 out nocopy JTF_NUMBER_TABLE
484: , p6_a4 out nocopy JTF_DATE_TABLE
485: , p6_a5 out nocopy JTF_NUMBER_TABLE
486: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
487: , p6_a7 out nocopy JTF_NUMBER_TABLE
488: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
489: , p6_a9 out nocopy JTF_NUMBER_TABLE
490: , p6_a10 out nocopy JTF_NUMBER_TABLE
491: , p6_a11 out nocopy JTF_DATE_TABLE
492: , p6_a12 out nocopy JTF_NUMBER_TABLE
645: , x_msg_data out nocopy VARCHAR2
646: , p5_a0 JTF_NUMBER_TABLE
647: , p5_a1 JTF_NUMBER_TABLE
648: , p5_a2 JTF_NUMBER_TABLE
649: , p5_a3 JTF_VARCHAR2_TABLE_100
650: , p5_a4 JTF_DATE_TABLE
651: , p5_a5 JTF_NUMBER_TABLE
652: , p5_a6 JTF_VARCHAR2_TABLE_100
653: , p5_a7 JTF_NUMBER_TABLE
648: , p5_a2 JTF_NUMBER_TABLE
649: , p5_a3 JTF_VARCHAR2_TABLE_100
650: , p5_a4 JTF_DATE_TABLE
651: , p5_a5 JTF_NUMBER_TABLE
652: , p5_a6 JTF_VARCHAR2_TABLE_100
653: , p5_a7 JTF_NUMBER_TABLE
654: , p5_a8 JTF_VARCHAR2_TABLE_100
655: , p5_a9 JTF_NUMBER_TABLE
656: , p5_a10 JTF_NUMBER_TABLE
650: , p5_a4 JTF_DATE_TABLE
651: , p5_a5 JTF_NUMBER_TABLE
652: , p5_a6 JTF_VARCHAR2_TABLE_100
653: , p5_a7 JTF_NUMBER_TABLE
654: , p5_a8 JTF_VARCHAR2_TABLE_100
655: , p5_a9 JTF_NUMBER_TABLE
656: , p5_a10 JTF_NUMBER_TABLE
657: , p5_a11 JTF_DATE_TABLE
658: , p5_a12 JTF_NUMBER_TABLE
828: , x_msg_data out nocopy VARCHAR2
829: , p5_a0 JTF_NUMBER_TABLE
830: , p5_a1 JTF_NUMBER_TABLE
831: , p5_a2 JTF_NUMBER_TABLE
832: , p5_a3 JTF_VARCHAR2_TABLE_100
833: , p5_a4 JTF_DATE_TABLE
834: , p5_a5 JTF_NUMBER_TABLE
835: , p5_a6 JTF_VARCHAR2_TABLE_100
836: , p5_a7 JTF_NUMBER_TABLE
831: , p5_a2 JTF_NUMBER_TABLE
832: , p5_a3 JTF_VARCHAR2_TABLE_100
833: , p5_a4 JTF_DATE_TABLE
834: , p5_a5 JTF_NUMBER_TABLE
835: , p5_a6 JTF_VARCHAR2_TABLE_100
836: , p5_a7 JTF_NUMBER_TABLE
837: , p5_a8 JTF_VARCHAR2_TABLE_100
838: , p5_a9 JTF_NUMBER_TABLE
839: , p5_a10 JTF_NUMBER_TABLE
833: , p5_a4 JTF_DATE_TABLE
834: , p5_a5 JTF_NUMBER_TABLE
835: , p5_a6 JTF_VARCHAR2_TABLE_100
836: , p5_a7 JTF_NUMBER_TABLE
837: , p5_a8 JTF_VARCHAR2_TABLE_100
838: , p5_a9 JTF_NUMBER_TABLE
839: , p5_a10 JTF_NUMBER_TABLE
840: , p5_a11 JTF_DATE_TABLE
841: , p5_a12 JTF_NUMBER_TABLE
846: , p5_a17 JTF_NUMBER_TABLE
847: , p6_a0 out nocopy JTF_NUMBER_TABLE
848: , p6_a1 out nocopy JTF_NUMBER_TABLE
849: , p6_a2 out nocopy JTF_NUMBER_TABLE
850: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
851: , p6_a4 out nocopy JTF_DATE_TABLE
852: , p6_a5 out nocopy JTF_NUMBER_TABLE
853: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
854: , p6_a7 out nocopy JTF_NUMBER_TABLE
849: , p6_a2 out nocopy JTF_NUMBER_TABLE
850: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
851: , p6_a4 out nocopy JTF_DATE_TABLE
852: , p6_a5 out nocopy JTF_NUMBER_TABLE
853: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
854: , p6_a7 out nocopy JTF_NUMBER_TABLE
855: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
856: , p6_a9 out nocopy JTF_NUMBER_TABLE
857: , p6_a10 out nocopy JTF_NUMBER_TABLE
851: , p6_a4 out nocopy JTF_DATE_TABLE
852: , p6_a5 out nocopy JTF_NUMBER_TABLE
853: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
854: , p6_a7 out nocopy JTF_NUMBER_TABLE
855: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
856: , p6_a9 out nocopy JTF_NUMBER_TABLE
857: , p6_a10 out nocopy JTF_NUMBER_TABLE
858: , p6_a11 out nocopy JTF_DATE_TABLE
859: , p6_a12 out nocopy JTF_NUMBER_TABLE
1012: , x_msg_data out nocopy VARCHAR2
1013: , p5_a0 JTF_NUMBER_TABLE
1014: , p5_a1 JTF_NUMBER_TABLE
1015: , p5_a2 JTF_NUMBER_TABLE
1016: , p5_a3 JTF_VARCHAR2_TABLE_100
1017: , p5_a4 JTF_DATE_TABLE
1018: , p5_a5 JTF_NUMBER_TABLE
1019: , p5_a6 JTF_VARCHAR2_TABLE_100
1020: , p5_a7 JTF_NUMBER_TABLE
1015: , p5_a2 JTF_NUMBER_TABLE
1016: , p5_a3 JTF_VARCHAR2_TABLE_100
1017: , p5_a4 JTF_DATE_TABLE
1018: , p5_a5 JTF_NUMBER_TABLE
1019: , p5_a6 JTF_VARCHAR2_TABLE_100
1020: , p5_a7 JTF_NUMBER_TABLE
1021: , p5_a8 JTF_VARCHAR2_TABLE_100
1022: , p5_a9 JTF_NUMBER_TABLE
1023: , p5_a10 JTF_NUMBER_TABLE
1017: , p5_a4 JTF_DATE_TABLE
1018: , p5_a5 JTF_NUMBER_TABLE
1019: , p5_a6 JTF_VARCHAR2_TABLE_100
1020: , p5_a7 JTF_NUMBER_TABLE
1021: , p5_a8 JTF_VARCHAR2_TABLE_100
1022: , p5_a9 JTF_NUMBER_TABLE
1023: , p5_a10 JTF_NUMBER_TABLE
1024: , p5_a11 JTF_DATE_TABLE
1025: , p5_a12 JTF_NUMBER_TABLE
1155: , x_msg_data out nocopy VARCHAR2
1156: , p5_a0 JTF_NUMBER_TABLE
1157: , p5_a1 JTF_NUMBER_TABLE
1158: , p5_a2 JTF_NUMBER_TABLE
1159: , p5_a3 JTF_VARCHAR2_TABLE_100
1160: , p5_a4 JTF_DATE_TABLE
1161: , p5_a5 JTF_NUMBER_TABLE
1162: , p5_a6 JTF_VARCHAR2_TABLE_100
1163: , p5_a7 JTF_NUMBER_TABLE
1158: , p5_a2 JTF_NUMBER_TABLE
1159: , p5_a3 JTF_VARCHAR2_TABLE_100
1160: , p5_a4 JTF_DATE_TABLE
1161: , p5_a5 JTF_NUMBER_TABLE
1162: , p5_a6 JTF_VARCHAR2_TABLE_100
1163: , p5_a7 JTF_NUMBER_TABLE
1164: , p5_a8 JTF_VARCHAR2_TABLE_100
1165: , p5_a9 JTF_NUMBER_TABLE
1166: , p5_a10 JTF_NUMBER_TABLE
1160: , p5_a4 JTF_DATE_TABLE
1161: , p5_a5 JTF_NUMBER_TABLE
1162: , p5_a6 JTF_VARCHAR2_TABLE_100
1163: , p5_a7 JTF_NUMBER_TABLE
1164: , p5_a8 JTF_VARCHAR2_TABLE_100
1165: , p5_a9 JTF_NUMBER_TABLE
1166: , p5_a10 JTF_NUMBER_TABLE
1167: , p5_a11 JTF_DATE_TABLE
1168: , p5_a12 JTF_NUMBER_TABLE