3: procedure rosetta_table_copy_in_p1(t out nocopy okl_ecl_pvt.okl_ecl_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_DATE_TABLE
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_DATE_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_DATE_TABLE
15: , a12 JTF_NUMBER_TABLE
16: ) as
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_DATE_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_DATE_TABLE
15: , a12 JTF_NUMBER_TABLE
16: ) as
17: ddindx binary_integer; indx binary_integer;
18: begin
46: procedure rosetta_table_copy_out_p1(t okl_ecl_pvt.okl_ecl_tbl, a0 out nocopy JTF_NUMBER_TABLE
47: , a1 out nocopy JTF_NUMBER_TABLE
48: , a2 out nocopy JTF_NUMBER_TABLE
49: , a3 out nocopy JTF_NUMBER_TABLE
50: , a4 out nocopy JTF_DATE_TABLE
51: , a5 out nocopy JTF_DATE_TABLE
52: , a6 out nocopy JTF_VARCHAR2_TABLE_100
53: , a7 out nocopy JTF_VARCHAR2_TABLE_100
54: , a8 out nocopy JTF_NUMBER_TABLE
47: , a1 out nocopy JTF_NUMBER_TABLE
48: , a2 out nocopy JTF_NUMBER_TABLE
49: , a3 out nocopy JTF_NUMBER_TABLE
50: , a4 out nocopy JTF_DATE_TABLE
51: , a5 out nocopy JTF_DATE_TABLE
52: , a6 out nocopy JTF_VARCHAR2_TABLE_100
53: , a7 out nocopy JTF_VARCHAR2_TABLE_100
54: , a8 out nocopy JTF_NUMBER_TABLE
55: , a9 out nocopy JTF_DATE_TABLE
51: , a5 out nocopy JTF_DATE_TABLE
52: , a6 out nocopy JTF_VARCHAR2_TABLE_100
53: , a7 out nocopy JTF_VARCHAR2_TABLE_100
54: , a8 out nocopy JTF_NUMBER_TABLE
55: , a9 out nocopy JTF_DATE_TABLE
56: , a10 out nocopy JTF_NUMBER_TABLE
57: , a11 out nocopy JTF_DATE_TABLE
58: , a12 out nocopy JTF_NUMBER_TABLE
59: ) as
53: , a7 out nocopy JTF_VARCHAR2_TABLE_100
54: , a8 out nocopy JTF_NUMBER_TABLE
55: , a9 out nocopy JTF_DATE_TABLE
56: , a10 out nocopy JTF_NUMBER_TABLE
57: , a11 out nocopy JTF_DATE_TABLE
58: , a12 out nocopy JTF_NUMBER_TABLE
59: ) as
60: ddindx binary_integer; indx binary_integer;
61: begin
63: a0 := JTF_NUMBER_TABLE();
64: a1 := JTF_NUMBER_TABLE();
65: a2 := JTF_NUMBER_TABLE();
66: a3 := JTF_NUMBER_TABLE();
67: a4 := JTF_DATE_TABLE();
68: a5 := JTF_DATE_TABLE();
69: a6 := JTF_VARCHAR2_TABLE_100();
70: a7 := JTF_VARCHAR2_TABLE_100();
71: a8 := JTF_NUMBER_TABLE();
64: a1 := JTF_NUMBER_TABLE();
65: a2 := JTF_NUMBER_TABLE();
66: a3 := JTF_NUMBER_TABLE();
67: a4 := JTF_DATE_TABLE();
68: a5 := JTF_DATE_TABLE();
69: a6 := JTF_VARCHAR2_TABLE_100();
70: a7 := JTF_VARCHAR2_TABLE_100();
71: a8 := JTF_NUMBER_TABLE();
72: a9 := JTF_DATE_TABLE();
68: a5 := JTF_DATE_TABLE();
69: a6 := JTF_VARCHAR2_TABLE_100();
70: a7 := JTF_VARCHAR2_TABLE_100();
71: a8 := JTF_NUMBER_TABLE();
72: a9 := JTF_DATE_TABLE();
73: a10 := JTF_NUMBER_TABLE();
74: a11 := JTF_DATE_TABLE();
75: a12 := JTF_NUMBER_TABLE();
76: else
70: a7 := JTF_VARCHAR2_TABLE_100();
71: a8 := JTF_NUMBER_TABLE();
72: a9 := JTF_DATE_TABLE();
73: a10 := JTF_NUMBER_TABLE();
74: a11 := JTF_DATE_TABLE();
75: a12 := JTF_NUMBER_TABLE();
76: else
77: a0 := JTF_NUMBER_TABLE();
78: a1 := JTF_NUMBER_TABLE();
77: a0 := JTF_NUMBER_TABLE();
78: a1 := JTF_NUMBER_TABLE();
79: a2 := JTF_NUMBER_TABLE();
80: a3 := JTF_NUMBER_TABLE();
81: a4 := JTF_DATE_TABLE();
82: a5 := JTF_DATE_TABLE();
83: a6 := JTF_VARCHAR2_TABLE_100();
84: a7 := JTF_VARCHAR2_TABLE_100();
85: a8 := JTF_NUMBER_TABLE();
78: a1 := JTF_NUMBER_TABLE();
79: a2 := JTF_NUMBER_TABLE();
80: a3 := JTF_NUMBER_TABLE();
81: a4 := JTF_DATE_TABLE();
82: a5 := JTF_DATE_TABLE();
83: a6 := JTF_VARCHAR2_TABLE_100();
84: a7 := JTF_VARCHAR2_TABLE_100();
85: a8 := JTF_NUMBER_TABLE();
86: a9 := JTF_DATE_TABLE();
82: a5 := JTF_DATE_TABLE();
83: a6 := JTF_VARCHAR2_TABLE_100();
84: a7 := JTF_VARCHAR2_TABLE_100();
85: a8 := JTF_NUMBER_TABLE();
86: a9 := JTF_DATE_TABLE();
87: a10 := JTF_NUMBER_TABLE();
88: a11 := JTF_DATE_TABLE();
89: a12 := JTF_NUMBER_TABLE();
90: if t.count > 0 then
84: a7 := JTF_VARCHAR2_TABLE_100();
85: a8 := JTF_NUMBER_TABLE();
86: a9 := JTF_DATE_TABLE();
87: a10 := JTF_NUMBER_TABLE();
88: a11 := JTF_DATE_TABLE();
89: a12 := JTF_NUMBER_TABLE();
90: if t.count > 0 then
91: a0.extend(t.count);
92: a1.extend(t.count);
226: , p5_a0 JTF_NUMBER_TABLE
227: , p5_a1 JTF_NUMBER_TABLE
228: , p5_a2 JTF_NUMBER_TABLE
229: , p5_a3 JTF_NUMBER_TABLE
230: , p5_a4 JTF_DATE_TABLE
231: , p5_a5 JTF_DATE_TABLE
232: , p5_a6 JTF_VARCHAR2_TABLE_100
233: , p5_a7 JTF_VARCHAR2_TABLE_100
234: , p5_a8 JTF_NUMBER_TABLE
227: , p5_a1 JTF_NUMBER_TABLE
228: , p5_a2 JTF_NUMBER_TABLE
229: , p5_a3 JTF_NUMBER_TABLE
230: , p5_a4 JTF_DATE_TABLE
231: , p5_a5 JTF_DATE_TABLE
232: , p5_a6 JTF_VARCHAR2_TABLE_100
233: , p5_a7 JTF_VARCHAR2_TABLE_100
234: , p5_a8 JTF_NUMBER_TABLE
235: , p5_a9 JTF_DATE_TABLE
231: , p5_a5 JTF_DATE_TABLE
232: , p5_a6 JTF_VARCHAR2_TABLE_100
233: , p5_a7 JTF_VARCHAR2_TABLE_100
234: , p5_a8 JTF_NUMBER_TABLE
235: , p5_a9 JTF_DATE_TABLE
236: , p5_a10 JTF_NUMBER_TABLE
237: , p5_a11 JTF_DATE_TABLE
238: , p5_a12 JTF_NUMBER_TABLE
239: , p6_a0 out nocopy JTF_NUMBER_TABLE
233: , p5_a7 JTF_VARCHAR2_TABLE_100
234: , p5_a8 JTF_NUMBER_TABLE
235: , p5_a9 JTF_DATE_TABLE
236: , p5_a10 JTF_NUMBER_TABLE
237: , p5_a11 JTF_DATE_TABLE
238: , p5_a12 JTF_NUMBER_TABLE
239: , p6_a0 out nocopy JTF_NUMBER_TABLE
240: , p6_a1 out nocopy JTF_NUMBER_TABLE
241: , p6_a2 out nocopy JTF_NUMBER_TABLE
239: , p6_a0 out nocopy JTF_NUMBER_TABLE
240: , p6_a1 out nocopy JTF_NUMBER_TABLE
241: , p6_a2 out nocopy JTF_NUMBER_TABLE
242: , p6_a3 out nocopy JTF_NUMBER_TABLE
243: , p6_a4 out nocopy JTF_DATE_TABLE
244: , p6_a5 out nocopy JTF_DATE_TABLE
245: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
246: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
247: , p6_a8 out nocopy JTF_NUMBER_TABLE
240: , p6_a1 out nocopy JTF_NUMBER_TABLE
241: , p6_a2 out nocopy JTF_NUMBER_TABLE
242: , p6_a3 out nocopy JTF_NUMBER_TABLE
243: , p6_a4 out nocopy JTF_DATE_TABLE
244: , p6_a5 out nocopy JTF_DATE_TABLE
245: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
246: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
247: , p6_a8 out nocopy JTF_NUMBER_TABLE
248: , p6_a9 out nocopy JTF_DATE_TABLE
244: , p6_a5 out nocopy JTF_DATE_TABLE
245: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
246: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
247: , p6_a8 out nocopy JTF_NUMBER_TABLE
248: , p6_a9 out nocopy JTF_DATE_TABLE
249: , p6_a10 out nocopy JTF_NUMBER_TABLE
250: , p6_a11 out nocopy JTF_DATE_TABLE
251: , p6_a12 out nocopy JTF_NUMBER_TABLE
252: )
246: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
247: , p6_a8 out nocopy JTF_NUMBER_TABLE
248: , p6_a9 out nocopy JTF_DATE_TABLE
249: , p6_a10 out nocopy JTF_NUMBER_TABLE
250: , p6_a11 out nocopy JTF_DATE_TABLE
251: , p6_a12 out nocopy JTF_NUMBER_TABLE
252: )
253:
254: as
410: , p5_a0 JTF_NUMBER_TABLE
411: , p5_a1 JTF_NUMBER_TABLE
412: , p5_a2 JTF_NUMBER_TABLE
413: , p5_a3 JTF_NUMBER_TABLE
414: , p5_a4 JTF_DATE_TABLE
415: , p5_a5 JTF_DATE_TABLE
416: , p5_a6 JTF_VARCHAR2_TABLE_100
417: , p5_a7 JTF_VARCHAR2_TABLE_100
418: , p5_a8 JTF_NUMBER_TABLE
411: , p5_a1 JTF_NUMBER_TABLE
412: , p5_a2 JTF_NUMBER_TABLE
413: , p5_a3 JTF_NUMBER_TABLE
414: , p5_a4 JTF_DATE_TABLE
415: , p5_a5 JTF_DATE_TABLE
416: , p5_a6 JTF_VARCHAR2_TABLE_100
417: , p5_a7 JTF_VARCHAR2_TABLE_100
418: , p5_a8 JTF_NUMBER_TABLE
419: , p5_a9 JTF_DATE_TABLE
415: , p5_a5 JTF_DATE_TABLE
416: , p5_a6 JTF_VARCHAR2_TABLE_100
417: , p5_a7 JTF_VARCHAR2_TABLE_100
418: , p5_a8 JTF_NUMBER_TABLE
419: , p5_a9 JTF_DATE_TABLE
420: , p5_a10 JTF_NUMBER_TABLE
421: , p5_a11 JTF_DATE_TABLE
422: , p5_a12 JTF_NUMBER_TABLE
423: , p6_a0 out nocopy JTF_NUMBER_TABLE
417: , p5_a7 JTF_VARCHAR2_TABLE_100
418: , p5_a8 JTF_NUMBER_TABLE
419: , p5_a9 JTF_DATE_TABLE
420: , p5_a10 JTF_NUMBER_TABLE
421: , p5_a11 JTF_DATE_TABLE
422: , p5_a12 JTF_NUMBER_TABLE
423: , p6_a0 out nocopy JTF_NUMBER_TABLE
424: , p6_a1 out nocopy JTF_NUMBER_TABLE
425: , p6_a2 out nocopy JTF_NUMBER_TABLE
423: , p6_a0 out nocopy JTF_NUMBER_TABLE
424: , p6_a1 out nocopy JTF_NUMBER_TABLE
425: , p6_a2 out nocopy JTF_NUMBER_TABLE
426: , p6_a3 out nocopy JTF_NUMBER_TABLE
427: , p6_a4 out nocopy JTF_DATE_TABLE
428: , p6_a5 out nocopy JTF_DATE_TABLE
429: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
430: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
431: , p6_a8 out nocopy JTF_NUMBER_TABLE
424: , p6_a1 out nocopy JTF_NUMBER_TABLE
425: , p6_a2 out nocopy JTF_NUMBER_TABLE
426: , p6_a3 out nocopy JTF_NUMBER_TABLE
427: , p6_a4 out nocopy JTF_DATE_TABLE
428: , p6_a5 out nocopy JTF_DATE_TABLE
429: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
430: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
431: , p6_a8 out nocopy JTF_NUMBER_TABLE
432: , p6_a9 out nocopy JTF_DATE_TABLE
428: , p6_a5 out nocopy JTF_DATE_TABLE
429: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
430: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
431: , p6_a8 out nocopy JTF_NUMBER_TABLE
432: , p6_a9 out nocopy JTF_DATE_TABLE
433: , p6_a10 out nocopy JTF_NUMBER_TABLE
434: , p6_a11 out nocopy JTF_DATE_TABLE
435: , p6_a12 out nocopy JTF_NUMBER_TABLE
436: )
430: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
431: , p6_a8 out nocopy JTF_NUMBER_TABLE
432: , p6_a9 out nocopy JTF_DATE_TABLE
433: , p6_a10 out nocopy JTF_NUMBER_TABLE
434: , p6_a11 out nocopy JTF_DATE_TABLE
435: , p6_a12 out nocopy JTF_NUMBER_TABLE
436: )
437:
438: as
564: , p5_a0 JTF_NUMBER_TABLE
565: , p5_a1 JTF_NUMBER_TABLE
566: , p5_a2 JTF_NUMBER_TABLE
567: , p5_a3 JTF_NUMBER_TABLE
568: , p5_a4 JTF_DATE_TABLE
569: , p5_a5 JTF_DATE_TABLE
570: , p5_a6 JTF_VARCHAR2_TABLE_100
571: , p5_a7 JTF_VARCHAR2_TABLE_100
572: , p5_a8 JTF_NUMBER_TABLE
565: , p5_a1 JTF_NUMBER_TABLE
566: , p5_a2 JTF_NUMBER_TABLE
567: , p5_a3 JTF_NUMBER_TABLE
568: , p5_a4 JTF_DATE_TABLE
569: , p5_a5 JTF_DATE_TABLE
570: , p5_a6 JTF_VARCHAR2_TABLE_100
571: , p5_a7 JTF_VARCHAR2_TABLE_100
572: , p5_a8 JTF_NUMBER_TABLE
573: , p5_a9 JTF_DATE_TABLE
569: , p5_a5 JTF_DATE_TABLE
570: , p5_a6 JTF_VARCHAR2_TABLE_100
571: , p5_a7 JTF_VARCHAR2_TABLE_100
572: , p5_a8 JTF_NUMBER_TABLE
573: , p5_a9 JTF_DATE_TABLE
574: , p5_a10 JTF_NUMBER_TABLE
575: , p5_a11 JTF_DATE_TABLE
576: , p5_a12 JTF_NUMBER_TABLE
577: )
571: , p5_a7 JTF_VARCHAR2_TABLE_100
572: , p5_a8 JTF_NUMBER_TABLE
573: , p5_a9 JTF_DATE_TABLE
574: , p5_a10 JTF_NUMBER_TABLE
575: , p5_a11 JTF_DATE_TABLE
576: , p5_a12 JTF_NUMBER_TABLE
577: )
578:
579: as