22: procedure rosetta_table_copy_in_p2(t out nocopy okl_cgr_pvt.cgr_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_200
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_DATE_TABLE
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_DATE_TABLE
29: , a7 JTF_NUMBER_TABLE
30: ) as
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_DATE_TABLE
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_DATE_TABLE
29: , a7 JTF_NUMBER_TABLE
30: ) as
31: ddindx binary_integer; indx binary_integer;
32: begin
55: procedure rosetta_table_copy_out_p2(t okl_cgr_pvt.cgr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
56: , a1 out nocopy JTF_VARCHAR2_TABLE_200
57: , a2 out nocopy JTF_NUMBER_TABLE
58: , a3 out nocopy JTF_NUMBER_TABLE
59: , a4 out nocopy JTF_DATE_TABLE
60: , a5 out nocopy JTF_NUMBER_TABLE
61: , a6 out nocopy JTF_DATE_TABLE
62: , a7 out nocopy JTF_NUMBER_TABLE
63: ) as
57: , a2 out nocopy JTF_NUMBER_TABLE
58: , a3 out nocopy JTF_NUMBER_TABLE
59: , a4 out nocopy JTF_DATE_TABLE
60: , a5 out nocopy JTF_NUMBER_TABLE
61: , a6 out nocopy JTF_DATE_TABLE
62: , a7 out nocopy JTF_NUMBER_TABLE
63: ) as
64: ddindx binary_integer; indx binary_integer;
65: begin
67: a0 := JTF_NUMBER_TABLE();
68: a1 := JTF_VARCHAR2_TABLE_200();
69: a2 := JTF_NUMBER_TABLE();
70: a3 := JTF_NUMBER_TABLE();
71: a4 := JTF_DATE_TABLE();
72: a5 := JTF_NUMBER_TABLE();
73: a6 := JTF_DATE_TABLE();
74: a7 := JTF_NUMBER_TABLE();
75: else
69: a2 := JTF_NUMBER_TABLE();
70: a3 := JTF_NUMBER_TABLE();
71: a4 := JTF_DATE_TABLE();
72: a5 := JTF_NUMBER_TABLE();
73: a6 := JTF_DATE_TABLE();
74: a7 := JTF_NUMBER_TABLE();
75: else
76: a0 := JTF_NUMBER_TABLE();
77: a1 := JTF_VARCHAR2_TABLE_200();
76: a0 := JTF_NUMBER_TABLE();
77: a1 := JTF_VARCHAR2_TABLE_200();
78: a2 := JTF_NUMBER_TABLE();
79: a3 := JTF_NUMBER_TABLE();
80: a4 := JTF_DATE_TABLE();
81: a5 := JTF_NUMBER_TABLE();
82: a6 := JTF_DATE_TABLE();
83: a7 := JTF_NUMBER_TABLE();
84: if t.count > 0 then
78: a2 := JTF_NUMBER_TABLE();
79: a3 := JTF_NUMBER_TABLE();
80: a4 := JTF_DATE_TABLE();
81: a5 := JTF_NUMBER_TABLE();
82: a6 := JTF_DATE_TABLE();
83: a7 := JTF_NUMBER_TABLE();
84: if t.count > 0 then
85: a0.extend(t.count);
86: a1.extend(t.count);
116: , a2 JTF_VARCHAR2_TABLE_100
117: , a3 JTF_VARCHAR2_TABLE_100
118: , a4 JTF_VARCHAR2_TABLE_2000
119: , a5 JTF_NUMBER_TABLE
120: , a6 JTF_DATE_TABLE
121: , a7 JTF_NUMBER_TABLE
122: , a8 JTF_DATE_TABLE
123: , a9 JTF_NUMBER_TABLE
124: ) as
118: , a4 JTF_VARCHAR2_TABLE_2000
119: , a5 JTF_NUMBER_TABLE
120: , a6 JTF_DATE_TABLE
121: , a7 JTF_NUMBER_TABLE
122: , a8 JTF_DATE_TABLE
123: , a9 JTF_NUMBER_TABLE
124: ) as
125: ddindx binary_integer; indx binary_integer;
126: begin
153: , a2 out nocopy JTF_VARCHAR2_TABLE_100
154: , a3 out nocopy JTF_VARCHAR2_TABLE_100
155: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
156: , a5 out nocopy JTF_NUMBER_TABLE
157: , a6 out nocopy JTF_DATE_TABLE
158: , a7 out nocopy JTF_NUMBER_TABLE
159: , a8 out nocopy JTF_DATE_TABLE
160: , a9 out nocopy JTF_NUMBER_TABLE
161: ) as
155: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
156: , a5 out nocopy JTF_NUMBER_TABLE
157: , a6 out nocopy JTF_DATE_TABLE
158: , a7 out nocopy JTF_NUMBER_TABLE
159: , a8 out nocopy JTF_DATE_TABLE
160: , a9 out nocopy JTF_NUMBER_TABLE
161: ) as
162: ddindx binary_integer; indx binary_integer;
163: begin
167: a2 := JTF_VARCHAR2_TABLE_100();
168: a3 := JTF_VARCHAR2_TABLE_100();
169: a4 := JTF_VARCHAR2_TABLE_2000();
170: a5 := JTF_NUMBER_TABLE();
171: a6 := JTF_DATE_TABLE();
172: a7 := JTF_NUMBER_TABLE();
173: a8 := JTF_DATE_TABLE();
174: a9 := JTF_NUMBER_TABLE();
175: else
169: a4 := JTF_VARCHAR2_TABLE_2000();
170: a5 := JTF_NUMBER_TABLE();
171: a6 := JTF_DATE_TABLE();
172: a7 := JTF_NUMBER_TABLE();
173: a8 := JTF_DATE_TABLE();
174: a9 := JTF_NUMBER_TABLE();
175: else
176: a0 := JTF_NUMBER_TABLE();
177: a1 := JTF_VARCHAR2_TABLE_100();
178: a2 := JTF_VARCHAR2_TABLE_100();
179: a3 := JTF_VARCHAR2_TABLE_100();
180: a4 := JTF_VARCHAR2_TABLE_2000();
181: a5 := JTF_NUMBER_TABLE();
182: a6 := JTF_DATE_TABLE();
183: a7 := JTF_NUMBER_TABLE();
184: a8 := JTF_DATE_TABLE();
185: a9 := JTF_NUMBER_TABLE();
186: if t.count > 0 then
180: a4 := JTF_VARCHAR2_TABLE_2000();
181: a5 := JTF_NUMBER_TABLE();
182: a6 := JTF_DATE_TABLE();
183: a7 := JTF_NUMBER_TABLE();
184: a8 := JTF_DATE_TABLE();
185: a9 := JTF_NUMBER_TABLE();
186: if t.count > 0 then
187: a0.extend(t.count);
188: a1.extend(t.count);
222: , a2 JTF_VARCHAR2_TABLE_100
223: , a3 JTF_VARCHAR2_TABLE_200
224: , a4 JTF_VARCHAR2_TABLE_2000
225: , a5 JTF_NUMBER_TABLE
226: , a6 JTF_DATE_TABLE
227: , a7 JTF_NUMBER_TABLE
228: , a8 JTF_DATE_TABLE
229: , a9 JTF_NUMBER_TABLE
230: ) as
224: , a4 JTF_VARCHAR2_TABLE_2000
225: , a5 JTF_NUMBER_TABLE
226: , a6 JTF_DATE_TABLE
227: , a7 JTF_NUMBER_TABLE
228: , a8 JTF_DATE_TABLE
229: , a9 JTF_NUMBER_TABLE
230: ) as
231: ddindx binary_integer; indx binary_integer;
232: begin
259: , a2 out nocopy JTF_VARCHAR2_TABLE_100
260: , a3 out nocopy JTF_VARCHAR2_TABLE_200
261: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
262: , a5 out nocopy JTF_NUMBER_TABLE
263: , a6 out nocopy JTF_DATE_TABLE
264: , a7 out nocopy JTF_NUMBER_TABLE
265: , a8 out nocopy JTF_DATE_TABLE
266: , a9 out nocopy JTF_NUMBER_TABLE
267: ) as
261: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
262: , a5 out nocopy JTF_NUMBER_TABLE
263: , a6 out nocopy JTF_DATE_TABLE
264: , a7 out nocopy JTF_NUMBER_TABLE
265: , a8 out nocopy JTF_DATE_TABLE
266: , a9 out nocopy JTF_NUMBER_TABLE
267: ) as
268: ddindx binary_integer; indx binary_integer;
269: begin
273: a2 := JTF_VARCHAR2_TABLE_100();
274: a3 := JTF_VARCHAR2_TABLE_200();
275: a4 := JTF_VARCHAR2_TABLE_2000();
276: a5 := JTF_NUMBER_TABLE();
277: a6 := JTF_DATE_TABLE();
278: a7 := JTF_NUMBER_TABLE();
279: a8 := JTF_DATE_TABLE();
280: a9 := JTF_NUMBER_TABLE();
281: else
275: a4 := JTF_VARCHAR2_TABLE_2000();
276: a5 := JTF_NUMBER_TABLE();
277: a6 := JTF_DATE_TABLE();
278: a7 := JTF_NUMBER_TABLE();
279: a8 := JTF_DATE_TABLE();
280: a9 := JTF_NUMBER_TABLE();
281: else
282: a0 := JTF_NUMBER_TABLE();
283: a1 := JTF_NUMBER_TABLE();
284: a2 := JTF_VARCHAR2_TABLE_100();
285: a3 := JTF_VARCHAR2_TABLE_200();
286: a4 := JTF_VARCHAR2_TABLE_2000();
287: a5 := JTF_NUMBER_TABLE();
288: a6 := JTF_DATE_TABLE();
289: a7 := JTF_NUMBER_TABLE();
290: a8 := JTF_DATE_TABLE();
291: a9 := JTF_NUMBER_TABLE();
292: if t.count > 0 then
286: a4 := JTF_VARCHAR2_TABLE_2000();
287: a5 := JTF_NUMBER_TABLE();
288: a6 := JTF_DATE_TABLE();
289: a7 := JTF_NUMBER_TABLE();
290: a8 := JTF_DATE_TABLE();
291: a9 := JTF_NUMBER_TABLE();
292: if t.count > 0 then
293: a0.extend(t.count);
294: a1.extend(t.count);
412: , p5_a2 JTF_VARCHAR2_TABLE_100
413: , p5_a3 JTF_VARCHAR2_TABLE_200
414: , p5_a4 JTF_VARCHAR2_TABLE_2000
415: , p5_a5 JTF_NUMBER_TABLE
416: , p5_a6 JTF_DATE_TABLE
417: , p5_a7 JTF_NUMBER_TABLE
418: , p5_a8 JTF_DATE_TABLE
419: , p5_a9 JTF_NUMBER_TABLE
420: , p6_a0 out nocopy JTF_NUMBER_TABLE
414: , p5_a4 JTF_VARCHAR2_TABLE_2000
415: , p5_a5 JTF_NUMBER_TABLE
416: , p5_a6 JTF_DATE_TABLE
417: , p5_a7 JTF_NUMBER_TABLE
418: , p5_a8 JTF_DATE_TABLE
419: , p5_a9 JTF_NUMBER_TABLE
420: , p6_a0 out nocopy JTF_NUMBER_TABLE
421: , p6_a1 out nocopy JTF_NUMBER_TABLE
422: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
422: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
423: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
424: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
425: , p6_a5 out nocopy JTF_NUMBER_TABLE
426: , p6_a6 out nocopy JTF_DATE_TABLE
427: , p6_a7 out nocopy JTF_NUMBER_TABLE
428: , p6_a8 out nocopy JTF_DATE_TABLE
429: , p6_a9 out nocopy JTF_NUMBER_TABLE
430: )
424: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
425: , p6_a5 out nocopy JTF_NUMBER_TABLE
426: , p6_a6 out nocopy JTF_DATE_TABLE
427: , p6_a7 out nocopy JTF_NUMBER_TABLE
428: , p6_a8 out nocopy JTF_DATE_TABLE
429: , p6_a9 out nocopy JTF_NUMBER_TABLE
430: )
431:
432: as
548: , p5_a2 JTF_VARCHAR2_TABLE_100
549: , p5_a3 JTF_VARCHAR2_TABLE_200
550: , p5_a4 JTF_VARCHAR2_TABLE_2000
551: , p5_a5 JTF_NUMBER_TABLE
552: , p5_a6 JTF_DATE_TABLE
553: , p5_a7 JTF_NUMBER_TABLE
554: , p5_a8 JTF_DATE_TABLE
555: , p5_a9 JTF_NUMBER_TABLE
556: )
550: , p5_a4 JTF_VARCHAR2_TABLE_2000
551: , p5_a5 JTF_NUMBER_TABLE
552: , p5_a6 JTF_DATE_TABLE
553: , p5_a7 JTF_NUMBER_TABLE
554: , p5_a8 JTF_DATE_TABLE
555: , p5_a9 JTF_NUMBER_TABLE
556: )
557:
558: as
683: , p5_a2 JTF_VARCHAR2_TABLE_100
684: , p5_a3 JTF_VARCHAR2_TABLE_200
685: , p5_a4 JTF_VARCHAR2_TABLE_2000
686: , p5_a5 JTF_NUMBER_TABLE
687: , p5_a6 JTF_DATE_TABLE
688: , p5_a7 JTF_NUMBER_TABLE
689: , p5_a8 JTF_DATE_TABLE
690: , p5_a9 JTF_NUMBER_TABLE
691: , p6_a0 out nocopy JTF_NUMBER_TABLE
685: , p5_a4 JTF_VARCHAR2_TABLE_2000
686: , p5_a5 JTF_NUMBER_TABLE
687: , p5_a6 JTF_DATE_TABLE
688: , p5_a7 JTF_NUMBER_TABLE
689: , p5_a8 JTF_DATE_TABLE
690: , p5_a9 JTF_NUMBER_TABLE
691: , p6_a0 out nocopy JTF_NUMBER_TABLE
692: , p6_a1 out nocopy JTF_NUMBER_TABLE
693: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
693: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
694: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
695: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
696: , p6_a5 out nocopy JTF_NUMBER_TABLE
697: , p6_a6 out nocopy JTF_DATE_TABLE
698: , p6_a7 out nocopy JTF_NUMBER_TABLE
699: , p6_a8 out nocopy JTF_DATE_TABLE
700: , p6_a9 out nocopy JTF_NUMBER_TABLE
701: )
695: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
696: , p6_a5 out nocopy JTF_NUMBER_TABLE
697: , p6_a6 out nocopy JTF_DATE_TABLE
698: , p6_a7 out nocopy JTF_NUMBER_TABLE
699: , p6_a8 out nocopy JTF_DATE_TABLE
700: , p6_a9 out nocopy JTF_NUMBER_TABLE
701: )
702:
703: as
819: , p5_a2 JTF_VARCHAR2_TABLE_100
820: , p5_a3 JTF_VARCHAR2_TABLE_200
821: , p5_a4 JTF_VARCHAR2_TABLE_2000
822: , p5_a5 JTF_NUMBER_TABLE
823: , p5_a6 JTF_DATE_TABLE
824: , p5_a7 JTF_NUMBER_TABLE
825: , p5_a8 JTF_DATE_TABLE
826: , p5_a9 JTF_NUMBER_TABLE
827: )
821: , p5_a4 JTF_VARCHAR2_TABLE_2000
822: , p5_a5 JTF_NUMBER_TABLE
823: , p5_a6 JTF_DATE_TABLE
824: , p5_a7 JTF_NUMBER_TABLE
825: , p5_a8 JTF_DATE_TABLE
826: , p5_a9 JTF_NUMBER_TABLE
827: )
828:
829: as
930: , p5_a2 JTF_VARCHAR2_TABLE_100
931: , p5_a3 JTF_VARCHAR2_TABLE_200
932: , p5_a4 JTF_VARCHAR2_TABLE_2000
933: , p5_a5 JTF_NUMBER_TABLE
934: , p5_a6 JTF_DATE_TABLE
935: , p5_a7 JTF_NUMBER_TABLE
936: , p5_a8 JTF_DATE_TABLE
937: , p5_a9 JTF_NUMBER_TABLE
938: )
932: , p5_a4 JTF_VARCHAR2_TABLE_2000
933: , p5_a5 JTF_NUMBER_TABLE
934: , p5_a6 JTF_DATE_TABLE
935: , p5_a7 JTF_NUMBER_TABLE
936: , p5_a8 JTF_DATE_TABLE
937: , p5_a9 JTF_NUMBER_TABLE
938: )
939:
940: as