18: if n=b then return a; end if;
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p1(t out nocopy okl_ins_quote_pvt.ipyv_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_VARCHAR2_TABLE_300
25: , a3 JTF_VARCHAR2_TABLE_600
26: , a4 JTF_VARCHAR2_TABLE_300
27: , a5 JTF_VARCHAR2_TABLE_300
28: , a6 JTF_VARCHAR2_TABLE_300
29: , a7 JTF_VARCHAR2_TABLE_300
30: , a8 JTF_VARCHAR2_TABLE_100
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_NUMBER_TABLE
34: , a12 JTF_NUMBER_TABLE
35: , a13 JTF_NUMBER_TABLE
28: , a6 JTF_VARCHAR2_TABLE_300
29: , a7 JTF_VARCHAR2_TABLE_300
30: , a8 JTF_VARCHAR2_TABLE_100
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_NUMBER_TABLE
34: , a12 JTF_NUMBER_TABLE
35: , a13 JTF_NUMBER_TABLE
36: , a14 JTF_VARCHAR2_TABLE_100
29: , a7 JTF_VARCHAR2_TABLE_300
30: , a8 JTF_VARCHAR2_TABLE_100
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_NUMBER_TABLE
34: , a12 JTF_NUMBER_TABLE
35: , a13 JTF_NUMBER_TABLE
36: , a14 JTF_VARCHAR2_TABLE_100
37: , a15 JTF_VARCHAR2_TABLE_100
30: , a8 JTF_VARCHAR2_TABLE_100
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_NUMBER_TABLE
34: , a12 JTF_NUMBER_TABLE
35: , a13 JTF_NUMBER_TABLE
36: , a14 JTF_VARCHAR2_TABLE_100
37: , a15 JTF_VARCHAR2_TABLE_100
38: , a16 JTF_VARCHAR2_TABLE_100
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_NUMBER_TABLE
34: , a12 JTF_NUMBER_TABLE
35: , a13 JTF_NUMBER_TABLE
36: , a14 JTF_VARCHAR2_TABLE_100
37: , a15 JTF_VARCHAR2_TABLE_100
38: , a16 JTF_VARCHAR2_TABLE_100
39: , a17 JTF_VARCHAR2_TABLE_100
51: , a29 JTF_VARCHAR2_TABLE_100
52: , a30 JTF_VARCHAR2_TABLE_100
53: , a31 JTF_VARCHAR2_TABLE_100
54: , a32 JTF_VARCHAR2_TABLE_100
55: , a33 JTF_NUMBER_TABLE
56: , a34 JTF_NUMBER_TABLE
57: , a35 JTF_NUMBER_TABLE
58: , a36 JTF_NUMBER_TABLE
59: , a37 JTF_NUMBER_TABLE
52: , a30 JTF_VARCHAR2_TABLE_100
53: , a31 JTF_VARCHAR2_TABLE_100
54: , a32 JTF_VARCHAR2_TABLE_100
55: , a33 JTF_NUMBER_TABLE
56: , a34 JTF_NUMBER_TABLE
57: , a35 JTF_NUMBER_TABLE
58: , a36 JTF_NUMBER_TABLE
59: , a37 JTF_NUMBER_TABLE
60: , a38 JTF_NUMBER_TABLE
53: , a31 JTF_VARCHAR2_TABLE_100
54: , a32 JTF_VARCHAR2_TABLE_100
55: , a33 JTF_NUMBER_TABLE
56: , a34 JTF_NUMBER_TABLE
57: , a35 JTF_NUMBER_TABLE
58: , a36 JTF_NUMBER_TABLE
59: , a37 JTF_NUMBER_TABLE
60: , a38 JTF_NUMBER_TABLE
61: , a39 JTF_VARCHAR2_TABLE_300
54: , a32 JTF_VARCHAR2_TABLE_100
55: , a33 JTF_NUMBER_TABLE
56: , a34 JTF_NUMBER_TABLE
57: , a35 JTF_NUMBER_TABLE
58: , a36 JTF_NUMBER_TABLE
59: , a37 JTF_NUMBER_TABLE
60: , a38 JTF_NUMBER_TABLE
61: , a39 JTF_VARCHAR2_TABLE_300
62: , a40 JTF_VARCHAR2_TABLE_100
55: , a33 JTF_NUMBER_TABLE
56: , a34 JTF_NUMBER_TABLE
57: , a35 JTF_NUMBER_TABLE
58: , a36 JTF_NUMBER_TABLE
59: , a37 JTF_NUMBER_TABLE
60: , a38 JTF_NUMBER_TABLE
61: , a39 JTF_VARCHAR2_TABLE_300
62: , a40 JTF_VARCHAR2_TABLE_100
63: , a41 JTF_NUMBER_TABLE
56: , a34 JTF_NUMBER_TABLE
57: , a35 JTF_NUMBER_TABLE
58: , a36 JTF_NUMBER_TABLE
59: , a37 JTF_NUMBER_TABLE
60: , a38 JTF_NUMBER_TABLE
61: , a39 JTF_VARCHAR2_TABLE_300
62: , a40 JTF_VARCHAR2_TABLE_100
63: , a41 JTF_NUMBER_TABLE
64: , a42 JTF_VARCHAR2_TABLE_100
59: , a37 JTF_NUMBER_TABLE
60: , a38 JTF_NUMBER_TABLE
61: , a39 JTF_VARCHAR2_TABLE_300
62: , a40 JTF_VARCHAR2_TABLE_100
63: , a41 JTF_NUMBER_TABLE
64: , a42 JTF_VARCHAR2_TABLE_100
65: , a43 JTF_NUMBER_TABLE
66: , a44 JTF_NUMBER_TABLE
67: , a45 JTF_NUMBER_TABLE
61: , a39 JTF_VARCHAR2_TABLE_300
62: , a40 JTF_VARCHAR2_TABLE_100
63: , a41 JTF_NUMBER_TABLE
64: , a42 JTF_VARCHAR2_TABLE_100
65: , a43 JTF_NUMBER_TABLE
66: , a44 JTF_NUMBER_TABLE
67: , a45 JTF_NUMBER_TABLE
68: , a46 JTF_NUMBER_TABLE
69: , a47 JTF_VARCHAR2_TABLE_100
62: , a40 JTF_VARCHAR2_TABLE_100
63: , a41 JTF_NUMBER_TABLE
64: , a42 JTF_VARCHAR2_TABLE_100
65: , a43 JTF_NUMBER_TABLE
66: , a44 JTF_NUMBER_TABLE
67: , a45 JTF_NUMBER_TABLE
68: , a46 JTF_NUMBER_TABLE
69: , a47 JTF_VARCHAR2_TABLE_100
70: , a48 JTF_VARCHAR2_TABLE_100
63: , a41 JTF_NUMBER_TABLE
64: , a42 JTF_VARCHAR2_TABLE_100
65: , a43 JTF_NUMBER_TABLE
66: , a44 JTF_NUMBER_TABLE
67: , a45 JTF_NUMBER_TABLE
68: , a46 JTF_NUMBER_TABLE
69: , a47 JTF_VARCHAR2_TABLE_100
70: , a48 JTF_VARCHAR2_TABLE_100
71: , a49 JTF_VARCHAR2_TABLE_500
64: , a42 JTF_VARCHAR2_TABLE_100
65: , a43 JTF_NUMBER_TABLE
66: , a44 JTF_NUMBER_TABLE
67: , a45 JTF_NUMBER_TABLE
68: , a46 JTF_NUMBER_TABLE
69: , a47 JTF_VARCHAR2_TABLE_100
70: , a48 JTF_VARCHAR2_TABLE_100
71: , a49 JTF_VARCHAR2_TABLE_500
72: , a50 JTF_VARCHAR2_TABLE_500
82: , a60 JTF_VARCHAR2_TABLE_500
83: , a61 JTF_VARCHAR2_TABLE_500
84: , a62 JTF_VARCHAR2_TABLE_500
85: , a63 JTF_VARCHAR2_TABLE_500
86: , a64 JTF_NUMBER_TABLE
87: , a65 JTF_NUMBER_TABLE
88: , a66 JTF_DATE_TABLE
89: , a67 JTF_NUMBER_TABLE
90: , a68 JTF_NUMBER_TABLE
83: , a61 JTF_VARCHAR2_TABLE_500
84: , a62 JTF_VARCHAR2_TABLE_500
85: , a63 JTF_VARCHAR2_TABLE_500
86: , a64 JTF_NUMBER_TABLE
87: , a65 JTF_NUMBER_TABLE
88: , a66 JTF_DATE_TABLE
89: , a67 JTF_NUMBER_TABLE
90: , a68 JTF_NUMBER_TABLE
91: , a69 JTF_NUMBER_TABLE
85: , a63 JTF_VARCHAR2_TABLE_500
86: , a64 JTF_NUMBER_TABLE
87: , a65 JTF_NUMBER_TABLE
88: , a66 JTF_DATE_TABLE
89: , a67 JTF_NUMBER_TABLE
90: , a68 JTF_NUMBER_TABLE
91: , a69 JTF_NUMBER_TABLE
92: , a70 JTF_NUMBER_TABLE
93: , a71 JTF_DATE_TABLE
86: , a64 JTF_NUMBER_TABLE
87: , a65 JTF_NUMBER_TABLE
88: , a66 JTF_DATE_TABLE
89: , a67 JTF_NUMBER_TABLE
90: , a68 JTF_NUMBER_TABLE
91: , a69 JTF_NUMBER_TABLE
92: , a70 JTF_NUMBER_TABLE
93: , a71 JTF_DATE_TABLE
94: , a72 JTF_NUMBER_TABLE
87: , a65 JTF_NUMBER_TABLE
88: , a66 JTF_DATE_TABLE
89: , a67 JTF_NUMBER_TABLE
90: , a68 JTF_NUMBER_TABLE
91: , a69 JTF_NUMBER_TABLE
92: , a70 JTF_NUMBER_TABLE
93: , a71 JTF_DATE_TABLE
94: , a72 JTF_NUMBER_TABLE
95: , a73 JTF_DATE_TABLE
88: , a66 JTF_DATE_TABLE
89: , a67 JTF_NUMBER_TABLE
90: , a68 JTF_NUMBER_TABLE
91: , a69 JTF_NUMBER_TABLE
92: , a70 JTF_NUMBER_TABLE
93: , a71 JTF_DATE_TABLE
94: , a72 JTF_NUMBER_TABLE
95: , a73 JTF_DATE_TABLE
96: , a74 JTF_NUMBER_TABLE
90: , a68 JTF_NUMBER_TABLE
91: , a69 JTF_NUMBER_TABLE
92: , a70 JTF_NUMBER_TABLE
93: , a71 JTF_DATE_TABLE
94: , a72 JTF_NUMBER_TABLE
95: , a73 JTF_DATE_TABLE
96: , a74 JTF_NUMBER_TABLE
97: , a75 JTF_NUMBER_TABLE
98: ) as
92: , a70 JTF_NUMBER_TABLE
93: , a71 JTF_DATE_TABLE
94: , a72 JTF_NUMBER_TABLE
95: , a73 JTF_DATE_TABLE
96: , a74 JTF_NUMBER_TABLE
97: , a75 JTF_NUMBER_TABLE
98: ) as
99: ddindx binary_integer; indx binary_integer;
100: begin
93: , a71 JTF_DATE_TABLE
94: , a72 JTF_NUMBER_TABLE
95: , a73 JTF_DATE_TABLE
96: , a74 JTF_NUMBER_TABLE
97: , a75 JTF_NUMBER_TABLE
98: ) as
99: ddindx binary_integer; indx binary_integer;
100: begin
101: if a0 is not null and a0.count > 0 then
187: end loop;
188: end if;
189: end if;
190: end rosetta_table_copy_in_p1;
191: procedure rosetta_table_copy_out_p1(t okl_ins_quote_pvt.ipyv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
192: , a1 out nocopy JTF_VARCHAR2_TABLE_100
193: , a2 out nocopy JTF_VARCHAR2_TABLE_300
194: , a3 out nocopy JTF_VARCHAR2_TABLE_600
195: , a4 out nocopy JTF_VARCHAR2_TABLE_300
196: , a5 out nocopy JTF_VARCHAR2_TABLE_300
197: , a6 out nocopy JTF_VARCHAR2_TABLE_300
198: , a7 out nocopy JTF_VARCHAR2_TABLE_300
199: , a8 out nocopy JTF_VARCHAR2_TABLE_100
200: , a9 out nocopy JTF_NUMBER_TABLE
201: , a10 out nocopy JTF_NUMBER_TABLE
202: , a11 out nocopy JTF_NUMBER_TABLE
203: , a12 out nocopy JTF_NUMBER_TABLE
204: , a13 out nocopy JTF_NUMBER_TABLE
197: , a6 out nocopy JTF_VARCHAR2_TABLE_300
198: , a7 out nocopy JTF_VARCHAR2_TABLE_300
199: , a8 out nocopy JTF_VARCHAR2_TABLE_100
200: , a9 out nocopy JTF_NUMBER_TABLE
201: , a10 out nocopy JTF_NUMBER_TABLE
202: , a11 out nocopy JTF_NUMBER_TABLE
203: , a12 out nocopy JTF_NUMBER_TABLE
204: , a13 out nocopy JTF_NUMBER_TABLE
205: , a14 out nocopy JTF_VARCHAR2_TABLE_100
198: , a7 out nocopy JTF_VARCHAR2_TABLE_300
199: , a8 out nocopy JTF_VARCHAR2_TABLE_100
200: , a9 out nocopy JTF_NUMBER_TABLE
201: , a10 out nocopy JTF_NUMBER_TABLE
202: , a11 out nocopy JTF_NUMBER_TABLE
203: , a12 out nocopy JTF_NUMBER_TABLE
204: , a13 out nocopy JTF_NUMBER_TABLE
205: , a14 out nocopy JTF_VARCHAR2_TABLE_100
206: , a15 out nocopy JTF_VARCHAR2_TABLE_100
199: , a8 out nocopy JTF_VARCHAR2_TABLE_100
200: , a9 out nocopy JTF_NUMBER_TABLE
201: , a10 out nocopy JTF_NUMBER_TABLE
202: , a11 out nocopy JTF_NUMBER_TABLE
203: , a12 out nocopy JTF_NUMBER_TABLE
204: , a13 out nocopy JTF_NUMBER_TABLE
205: , a14 out nocopy JTF_VARCHAR2_TABLE_100
206: , a15 out nocopy JTF_VARCHAR2_TABLE_100
207: , a16 out nocopy JTF_VARCHAR2_TABLE_100
200: , a9 out nocopy JTF_NUMBER_TABLE
201: , a10 out nocopy JTF_NUMBER_TABLE
202: , a11 out nocopy JTF_NUMBER_TABLE
203: , a12 out nocopy JTF_NUMBER_TABLE
204: , a13 out nocopy JTF_NUMBER_TABLE
205: , a14 out nocopy JTF_VARCHAR2_TABLE_100
206: , a15 out nocopy JTF_VARCHAR2_TABLE_100
207: , a16 out nocopy JTF_VARCHAR2_TABLE_100
208: , a17 out nocopy JTF_VARCHAR2_TABLE_100
220: , a29 out nocopy JTF_VARCHAR2_TABLE_100
221: , a30 out nocopy JTF_VARCHAR2_TABLE_100
222: , a31 out nocopy JTF_VARCHAR2_TABLE_100
223: , a32 out nocopy JTF_VARCHAR2_TABLE_100
224: , a33 out nocopy JTF_NUMBER_TABLE
225: , a34 out nocopy JTF_NUMBER_TABLE
226: , a35 out nocopy JTF_NUMBER_TABLE
227: , a36 out nocopy JTF_NUMBER_TABLE
228: , a37 out nocopy JTF_NUMBER_TABLE
221: , a30 out nocopy JTF_VARCHAR2_TABLE_100
222: , a31 out nocopy JTF_VARCHAR2_TABLE_100
223: , a32 out nocopy JTF_VARCHAR2_TABLE_100
224: , a33 out nocopy JTF_NUMBER_TABLE
225: , a34 out nocopy JTF_NUMBER_TABLE
226: , a35 out nocopy JTF_NUMBER_TABLE
227: , a36 out nocopy JTF_NUMBER_TABLE
228: , a37 out nocopy JTF_NUMBER_TABLE
229: , a38 out nocopy JTF_NUMBER_TABLE
222: , a31 out nocopy JTF_VARCHAR2_TABLE_100
223: , a32 out nocopy JTF_VARCHAR2_TABLE_100
224: , a33 out nocopy JTF_NUMBER_TABLE
225: , a34 out nocopy JTF_NUMBER_TABLE
226: , a35 out nocopy JTF_NUMBER_TABLE
227: , a36 out nocopy JTF_NUMBER_TABLE
228: , a37 out nocopy JTF_NUMBER_TABLE
229: , a38 out nocopy JTF_NUMBER_TABLE
230: , a39 out nocopy JTF_VARCHAR2_TABLE_300
223: , a32 out nocopy JTF_VARCHAR2_TABLE_100
224: , a33 out nocopy JTF_NUMBER_TABLE
225: , a34 out nocopy JTF_NUMBER_TABLE
226: , a35 out nocopy JTF_NUMBER_TABLE
227: , a36 out nocopy JTF_NUMBER_TABLE
228: , a37 out nocopy JTF_NUMBER_TABLE
229: , a38 out nocopy JTF_NUMBER_TABLE
230: , a39 out nocopy JTF_VARCHAR2_TABLE_300
231: , a40 out nocopy JTF_VARCHAR2_TABLE_100
224: , a33 out nocopy JTF_NUMBER_TABLE
225: , a34 out nocopy JTF_NUMBER_TABLE
226: , a35 out nocopy JTF_NUMBER_TABLE
227: , a36 out nocopy JTF_NUMBER_TABLE
228: , a37 out nocopy JTF_NUMBER_TABLE
229: , a38 out nocopy JTF_NUMBER_TABLE
230: , a39 out nocopy JTF_VARCHAR2_TABLE_300
231: , a40 out nocopy JTF_VARCHAR2_TABLE_100
232: , a41 out nocopy JTF_NUMBER_TABLE
225: , a34 out nocopy JTF_NUMBER_TABLE
226: , a35 out nocopy JTF_NUMBER_TABLE
227: , a36 out nocopy JTF_NUMBER_TABLE
228: , a37 out nocopy JTF_NUMBER_TABLE
229: , a38 out nocopy JTF_NUMBER_TABLE
230: , a39 out nocopy JTF_VARCHAR2_TABLE_300
231: , a40 out nocopy JTF_VARCHAR2_TABLE_100
232: , a41 out nocopy JTF_NUMBER_TABLE
233: , a42 out nocopy JTF_VARCHAR2_TABLE_100
228: , a37 out nocopy JTF_NUMBER_TABLE
229: , a38 out nocopy JTF_NUMBER_TABLE
230: , a39 out nocopy JTF_VARCHAR2_TABLE_300
231: , a40 out nocopy JTF_VARCHAR2_TABLE_100
232: , a41 out nocopy JTF_NUMBER_TABLE
233: , a42 out nocopy JTF_VARCHAR2_TABLE_100
234: , a43 out nocopy JTF_NUMBER_TABLE
235: , a44 out nocopy JTF_NUMBER_TABLE
236: , a45 out nocopy JTF_NUMBER_TABLE
230: , a39 out nocopy JTF_VARCHAR2_TABLE_300
231: , a40 out nocopy JTF_VARCHAR2_TABLE_100
232: , a41 out nocopy JTF_NUMBER_TABLE
233: , a42 out nocopy JTF_VARCHAR2_TABLE_100
234: , a43 out nocopy JTF_NUMBER_TABLE
235: , a44 out nocopy JTF_NUMBER_TABLE
236: , a45 out nocopy JTF_NUMBER_TABLE
237: , a46 out nocopy JTF_NUMBER_TABLE
238: , a47 out nocopy JTF_VARCHAR2_TABLE_100
231: , a40 out nocopy JTF_VARCHAR2_TABLE_100
232: , a41 out nocopy JTF_NUMBER_TABLE
233: , a42 out nocopy JTF_VARCHAR2_TABLE_100
234: , a43 out nocopy JTF_NUMBER_TABLE
235: , a44 out nocopy JTF_NUMBER_TABLE
236: , a45 out nocopy JTF_NUMBER_TABLE
237: , a46 out nocopy JTF_NUMBER_TABLE
238: , a47 out nocopy JTF_VARCHAR2_TABLE_100
239: , a48 out nocopy JTF_VARCHAR2_TABLE_100
232: , a41 out nocopy JTF_NUMBER_TABLE
233: , a42 out nocopy JTF_VARCHAR2_TABLE_100
234: , a43 out nocopy JTF_NUMBER_TABLE
235: , a44 out nocopy JTF_NUMBER_TABLE
236: , a45 out nocopy JTF_NUMBER_TABLE
237: , a46 out nocopy JTF_NUMBER_TABLE
238: , a47 out nocopy JTF_VARCHAR2_TABLE_100
239: , a48 out nocopy JTF_VARCHAR2_TABLE_100
240: , a49 out nocopy JTF_VARCHAR2_TABLE_500
233: , a42 out nocopy JTF_VARCHAR2_TABLE_100
234: , a43 out nocopy JTF_NUMBER_TABLE
235: , a44 out nocopy JTF_NUMBER_TABLE
236: , a45 out nocopy JTF_NUMBER_TABLE
237: , a46 out nocopy JTF_NUMBER_TABLE
238: , a47 out nocopy JTF_VARCHAR2_TABLE_100
239: , a48 out nocopy JTF_VARCHAR2_TABLE_100
240: , a49 out nocopy JTF_VARCHAR2_TABLE_500
241: , a50 out nocopy JTF_VARCHAR2_TABLE_500
251: , a60 out nocopy JTF_VARCHAR2_TABLE_500
252: , a61 out nocopy JTF_VARCHAR2_TABLE_500
253: , a62 out nocopy JTF_VARCHAR2_TABLE_500
254: , a63 out nocopy JTF_VARCHAR2_TABLE_500
255: , a64 out nocopy JTF_NUMBER_TABLE
256: , a65 out nocopy JTF_NUMBER_TABLE
257: , a66 out nocopy JTF_DATE_TABLE
258: , a67 out nocopy JTF_NUMBER_TABLE
259: , a68 out nocopy JTF_NUMBER_TABLE
252: , a61 out nocopy JTF_VARCHAR2_TABLE_500
253: , a62 out nocopy JTF_VARCHAR2_TABLE_500
254: , a63 out nocopy JTF_VARCHAR2_TABLE_500
255: , a64 out nocopy JTF_NUMBER_TABLE
256: , a65 out nocopy JTF_NUMBER_TABLE
257: , a66 out nocopy JTF_DATE_TABLE
258: , a67 out nocopy JTF_NUMBER_TABLE
259: , a68 out nocopy JTF_NUMBER_TABLE
260: , a69 out nocopy JTF_NUMBER_TABLE
254: , a63 out nocopy JTF_VARCHAR2_TABLE_500
255: , a64 out nocopy JTF_NUMBER_TABLE
256: , a65 out nocopy JTF_NUMBER_TABLE
257: , a66 out nocopy JTF_DATE_TABLE
258: , a67 out nocopy JTF_NUMBER_TABLE
259: , a68 out nocopy JTF_NUMBER_TABLE
260: , a69 out nocopy JTF_NUMBER_TABLE
261: , a70 out nocopy JTF_NUMBER_TABLE
262: , a71 out nocopy JTF_DATE_TABLE
255: , a64 out nocopy JTF_NUMBER_TABLE
256: , a65 out nocopy JTF_NUMBER_TABLE
257: , a66 out nocopy JTF_DATE_TABLE
258: , a67 out nocopy JTF_NUMBER_TABLE
259: , a68 out nocopy JTF_NUMBER_TABLE
260: , a69 out nocopy JTF_NUMBER_TABLE
261: , a70 out nocopy JTF_NUMBER_TABLE
262: , a71 out nocopy JTF_DATE_TABLE
263: , a72 out nocopy JTF_NUMBER_TABLE
256: , a65 out nocopy JTF_NUMBER_TABLE
257: , a66 out nocopy JTF_DATE_TABLE
258: , a67 out nocopy JTF_NUMBER_TABLE
259: , a68 out nocopy JTF_NUMBER_TABLE
260: , a69 out nocopy JTF_NUMBER_TABLE
261: , a70 out nocopy JTF_NUMBER_TABLE
262: , a71 out nocopy JTF_DATE_TABLE
263: , a72 out nocopy JTF_NUMBER_TABLE
264: , a73 out nocopy JTF_DATE_TABLE
257: , a66 out nocopy JTF_DATE_TABLE
258: , a67 out nocopy JTF_NUMBER_TABLE
259: , a68 out nocopy JTF_NUMBER_TABLE
260: , a69 out nocopy JTF_NUMBER_TABLE
261: , a70 out nocopy JTF_NUMBER_TABLE
262: , a71 out nocopy JTF_DATE_TABLE
263: , a72 out nocopy JTF_NUMBER_TABLE
264: , a73 out nocopy JTF_DATE_TABLE
265: , a74 out nocopy JTF_NUMBER_TABLE
259: , a68 out nocopy JTF_NUMBER_TABLE
260: , a69 out nocopy JTF_NUMBER_TABLE
261: , a70 out nocopy JTF_NUMBER_TABLE
262: , a71 out nocopy JTF_DATE_TABLE
263: , a72 out nocopy JTF_NUMBER_TABLE
264: , a73 out nocopy JTF_DATE_TABLE
265: , a74 out nocopy JTF_NUMBER_TABLE
266: , a75 out nocopy JTF_NUMBER_TABLE
267: ) as
261: , a70 out nocopy JTF_NUMBER_TABLE
262: , a71 out nocopy JTF_DATE_TABLE
263: , a72 out nocopy JTF_NUMBER_TABLE
264: , a73 out nocopy JTF_DATE_TABLE
265: , a74 out nocopy JTF_NUMBER_TABLE
266: , a75 out nocopy JTF_NUMBER_TABLE
267: ) as
268: ddindx binary_integer; indx binary_integer;
269: begin
262: , a71 out nocopy JTF_DATE_TABLE
263: , a72 out nocopy JTF_NUMBER_TABLE
264: , a73 out nocopy JTF_DATE_TABLE
265: , a74 out nocopy JTF_NUMBER_TABLE
266: , a75 out nocopy JTF_NUMBER_TABLE
267: ) as
268: ddindx binary_integer; indx binary_integer;
269: begin
270: if t is null or t.count = 0 then
267: ) as
268: ddindx binary_integer; indx binary_integer;
269: begin
270: if t is null or t.count = 0 then
271: a0 := JTF_NUMBER_TABLE();
272: a1 := JTF_VARCHAR2_TABLE_100();
273: a2 := JTF_VARCHAR2_TABLE_300();
274: a3 := JTF_VARCHAR2_TABLE_600();
275: a4 := JTF_VARCHAR2_TABLE_300();
276: a5 := JTF_VARCHAR2_TABLE_300();
277: a6 := JTF_VARCHAR2_TABLE_300();
278: a7 := JTF_VARCHAR2_TABLE_300();
279: a8 := JTF_VARCHAR2_TABLE_100();
280: a9 := JTF_NUMBER_TABLE();
281: a10 := JTF_NUMBER_TABLE();
282: a11 := JTF_NUMBER_TABLE();
283: a12 := JTF_NUMBER_TABLE();
284: a13 := JTF_NUMBER_TABLE();
277: a6 := JTF_VARCHAR2_TABLE_300();
278: a7 := JTF_VARCHAR2_TABLE_300();
279: a8 := JTF_VARCHAR2_TABLE_100();
280: a9 := JTF_NUMBER_TABLE();
281: a10 := JTF_NUMBER_TABLE();
282: a11 := JTF_NUMBER_TABLE();
283: a12 := JTF_NUMBER_TABLE();
284: a13 := JTF_NUMBER_TABLE();
285: a14 := JTF_VARCHAR2_TABLE_100();
278: a7 := JTF_VARCHAR2_TABLE_300();
279: a8 := JTF_VARCHAR2_TABLE_100();
280: a9 := JTF_NUMBER_TABLE();
281: a10 := JTF_NUMBER_TABLE();
282: a11 := JTF_NUMBER_TABLE();
283: a12 := JTF_NUMBER_TABLE();
284: a13 := JTF_NUMBER_TABLE();
285: a14 := JTF_VARCHAR2_TABLE_100();
286: a15 := JTF_VARCHAR2_TABLE_100();
279: a8 := JTF_VARCHAR2_TABLE_100();
280: a9 := JTF_NUMBER_TABLE();
281: a10 := JTF_NUMBER_TABLE();
282: a11 := JTF_NUMBER_TABLE();
283: a12 := JTF_NUMBER_TABLE();
284: a13 := JTF_NUMBER_TABLE();
285: a14 := JTF_VARCHAR2_TABLE_100();
286: a15 := JTF_VARCHAR2_TABLE_100();
287: a16 := JTF_VARCHAR2_TABLE_100();
280: a9 := JTF_NUMBER_TABLE();
281: a10 := JTF_NUMBER_TABLE();
282: a11 := JTF_NUMBER_TABLE();
283: a12 := JTF_NUMBER_TABLE();
284: a13 := JTF_NUMBER_TABLE();
285: a14 := JTF_VARCHAR2_TABLE_100();
286: a15 := JTF_VARCHAR2_TABLE_100();
287: a16 := JTF_VARCHAR2_TABLE_100();
288: a17 := JTF_VARCHAR2_TABLE_100();
300: a29 := JTF_VARCHAR2_TABLE_100();
301: a30 := JTF_VARCHAR2_TABLE_100();
302: a31 := JTF_VARCHAR2_TABLE_100();
303: a32 := JTF_VARCHAR2_TABLE_100();
304: a33 := JTF_NUMBER_TABLE();
305: a34 := JTF_NUMBER_TABLE();
306: a35 := JTF_NUMBER_TABLE();
307: a36 := JTF_NUMBER_TABLE();
308: a37 := JTF_NUMBER_TABLE();
301: a30 := JTF_VARCHAR2_TABLE_100();
302: a31 := JTF_VARCHAR2_TABLE_100();
303: a32 := JTF_VARCHAR2_TABLE_100();
304: a33 := JTF_NUMBER_TABLE();
305: a34 := JTF_NUMBER_TABLE();
306: a35 := JTF_NUMBER_TABLE();
307: a36 := JTF_NUMBER_TABLE();
308: a37 := JTF_NUMBER_TABLE();
309: a38 := JTF_NUMBER_TABLE();
302: a31 := JTF_VARCHAR2_TABLE_100();
303: a32 := JTF_VARCHAR2_TABLE_100();
304: a33 := JTF_NUMBER_TABLE();
305: a34 := JTF_NUMBER_TABLE();
306: a35 := JTF_NUMBER_TABLE();
307: a36 := JTF_NUMBER_TABLE();
308: a37 := JTF_NUMBER_TABLE();
309: a38 := JTF_NUMBER_TABLE();
310: a39 := JTF_VARCHAR2_TABLE_300();
303: a32 := JTF_VARCHAR2_TABLE_100();
304: a33 := JTF_NUMBER_TABLE();
305: a34 := JTF_NUMBER_TABLE();
306: a35 := JTF_NUMBER_TABLE();
307: a36 := JTF_NUMBER_TABLE();
308: a37 := JTF_NUMBER_TABLE();
309: a38 := JTF_NUMBER_TABLE();
310: a39 := JTF_VARCHAR2_TABLE_300();
311: a40 := JTF_VARCHAR2_TABLE_100();
304: a33 := JTF_NUMBER_TABLE();
305: a34 := JTF_NUMBER_TABLE();
306: a35 := JTF_NUMBER_TABLE();
307: a36 := JTF_NUMBER_TABLE();
308: a37 := JTF_NUMBER_TABLE();
309: a38 := JTF_NUMBER_TABLE();
310: a39 := JTF_VARCHAR2_TABLE_300();
311: a40 := JTF_VARCHAR2_TABLE_100();
312: a41 := JTF_NUMBER_TABLE();
305: a34 := JTF_NUMBER_TABLE();
306: a35 := JTF_NUMBER_TABLE();
307: a36 := JTF_NUMBER_TABLE();
308: a37 := JTF_NUMBER_TABLE();
309: a38 := JTF_NUMBER_TABLE();
310: a39 := JTF_VARCHAR2_TABLE_300();
311: a40 := JTF_VARCHAR2_TABLE_100();
312: a41 := JTF_NUMBER_TABLE();
313: a42 := JTF_VARCHAR2_TABLE_100();
308: a37 := JTF_NUMBER_TABLE();
309: a38 := JTF_NUMBER_TABLE();
310: a39 := JTF_VARCHAR2_TABLE_300();
311: a40 := JTF_VARCHAR2_TABLE_100();
312: a41 := JTF_NUMBER_TABLE();
313: a42 := JTF_VARCHAR2_TABLE_100();
314: a43 := JTF_NUMBER_TABLE();
315: a44 := JTF_NUMBER_TABLE();
316: a45 := JTF_NUMBER_TABLE();
310: a39 := JTF_VARCHAR2_TABLE_300();
311: a40 := JTF_VARCHAR2_TABLE_100();
312: a41 := JTF_NUMBER_TABLE();
313: a42 := JTF_VARCHAR2_TABLE_100();
314: a43 := JTF_NUMBER_TABLE();
315: a44 := JTF_NUMBER_TABLE();
316: a45 := JTF_NUMBER_TABLE();
317: a46 := JTF_NUMBER_TABLE();
318: a47 := JTF_VARCHAR2_TABLE_100();
311: a40 := JTF_VARCHAR2_TABLE_100();
312: a41 := JTF_NUMBER_TABLE();
313: a42 := JTF_VARCHAR2_TABLE_100();
314: a43 := JTF_NUMBER_TABLE();
315: a44 := JTF_NUMBER_TABLE();
316: a45 := JTF_NUMBER_TABLE();
317: a46 := JTF_NUMBER_TABLE();
318: a47 := JTF_VARCHAR2_TABLE_100();
319: a48 := JTF_VARCHAR2_TABLE_100();
312: a41 := JTF_NUMBER_TABLE();
313: a42 := JTF_VARCHAR2_TABLE_100();
314: a43 := JTF_NUMBER_TABLE();
315: a44 := JTF_NUMBER_TABLE();
316: a45 := JTF_NUMBER_TABLE();
317: a46 := JTF_NUMBER_TABLE();
318: a47 := JTF_VARCHAR2_TABLE_100();
319: a48 := JTF_VARCHAR2_TABLE_100();
320: a49 := JTF_VARCHAR2_TABLE_500();
313: a42 := JTF_VARCHAR2_TABLE_100();
314: a43 := JTF_NUMBER_TABLE();
315: a44 := JTF_NUMBER_TABLE();
316: a45 := JTF_NUMBER_TABLE();
317: a46 := JTF_NUMBER_TABLE();
318: a47 := JTF_VARCHAR2_TABLE_100();
319: a48 := JTF_VARCHAR2_TABLE_100();
320: a49 := JTF_VARCHAR2_TABLE_500();
321: a50 := JTF_VARCHAR2_TABLE_500();
331: a60 := JTF_VARCHAR2_TABLE_500();
332: a61 := JTF_VARCHAR2_TABLE_500();
333: a62 := JTF_VARCHAR2_TABLE_500();
334: a63 := JTF_VARCHAR2_TABLE_500();
335: a64 := JTF_NUMBER_TABLE();
336: a65 := JTF_NUMBER_TABLE();
337: a66 := JTF_DATE_TABLE();
338: a67 := JTF_NUMBER_TABLE();
339: a68 := JTF_NUMBER_TABLE();
332: a61 := JTF_VARCHAR2_TABLE_500();
333: a62 := JTF_VARCHAR2_TABLE_500();
334: a63 := JTF_VARCHAR2_TABLE_500();
335: a64 := JTF_NUMBER_TABLE();
336: a65 := JTF_NUMBER_TABLE();
337: a66 := JTF_DATE_TABLE();
338: a67 := JTF_NUMBER_TABLE();
339: a68 := JTF_NUMBER_TABLE();
340: a69 := JTF_NUMBER_TABLE();
334: a63 := JTF_VARCHAR2_TABLE_500();
335: a64 := JTF_NUMBER_TABLE();
336: a65 := JTF_NUMBER_TABLE();
337: a66 := JTF_DATE_TABLE();
338: a67 := JTF_NUMBER_TABLE();
339: a68 := JTF_NUMBER_TABLE();
340: a69 := JTF_NUMBER_TABLE();
341: a70 := JTF_NUMBER_TABLE();
342: a71 := JTF_DATE_TABLE();
335: a64 := JTF_NUMBER_TABLE();
336: a65 := JTF_NUMBER_TABLE();
337: a66 := JTF_DATE_TABLE();
338: a67 := JTF_NUMBER_TABLE();
339: a68 := JTF_NUMBER_TABLE();
340: a69 := JTF_NUMBER_TABLE();
341: a70 := JTF_NUMBER_TABLE();
342: a71 := JTF_DATE_TABLE();
343: a72 := JTF_NUMBER_TABLE();
336: a65 := JTF_NUMBER_TABLE();
337: a66 := JTF_DATE_TABLE();
338: a67 := JTF_NUMBER_TABLE();
339: a68 := JTF_NUMBER_TABLE();
340: a69 := JTF_NUMBER_TABLE();
341: a70 := JTF_NUMBER_TABLE();
342: a71 := JTF_DATE_TABLE();
343: a72 := JTF_NUMBER_TABLE();
344: a73 := JTF_DATE_TABLE();
337: a66 := JTF_DATE_TABLE();
338: a67 := JTF_NUMBER_TABLE();
339: a68 := JTF_NUMBER_TABLE();
340: a69 := JTF_NUMBER_TABLE();
341: a70 := JTF_NUMBER_TABLE();
342: a71 := JTF_DATE_TABLE();
343: a72 := JTF_NUMBER_TABLE();
344: a73 := JTF_DATE_TABLE();
345: a74 := JTF_NUMBER_TABLE();
339: a68 := JTF_NUMBER_TABLE();
340: a69 := JTF_NUMBER_TABLE();
341: a70 := JTF_NUMBER_TABLE();
342: a71 := JTF_DATE_TABLE();
343: a72 := JTF_NUMBER_TABLE();
344: a73 := JTF_DATE_TABLE();
345: a74 := JTF_NUMBER_TABLE();
346: a75 := JTF_NUMBER_TABLE();
347: else
341: a70 := JTF_NUMBER_TABLE();
342: a71 := JTF_DATE_TABLE();
343: a72 := JTF_NUMBER_TABLE();
344: a73 := JTF_DATE_TABLE();
345: a74 := JTF_NUMBER_TABLE();
346: a75 := JTF_NUMBER_TABLE();
347: else
348: a0 := JTF_NUMBER_TABLE();
349: a1 := JTF_VARCHAR2_TABLE_100();
342: a71 := JTF_DATE_TABLE();
343: a72 := JTF_NUMBER_TABLE();
344: a73 := JTF_DATE_TABLE();
345: a74 := JTF_NUMBER_TABLE();
346: a75 := JTF_NUMBER_TABLE();
347: else
348: a0 := JTF_NUMBER_TABLE();
349: a1 := JTF_VARCHAR2_TABLE_100();
350: a2 := JTF_VARCHAR2_TABLE_300();
344: a73 := JTF_DATE_TABLE();
345: a74 := JTF_NUMBER_TABLE();
346: a75 := JTF_NUMBER_TABLE();
347: else
348: a0 := JTF_NUMBER_TABLE();
349: a1 := JTF_VARCHAR2_TABLE_100();
350: a2 := JTF_VARCHAR2_TABLE_300();
351: a3 := JTF_VARCHAR2_TABLE_600();
352: a4 := JTF_VARCHAR2_TABLE_300();
353: a5 := JTF_VARCHAR2_TABLE_300();
354: a6 := JTF_VARCHAR2_TABLE_300();
355: a7 := JTF_VARCHAR2_TABLE_300();
356: a8 := JTF_VARCHAR2_TABLE_100();
357: a9 := JTF_NUMBER_TABLE();
358: a10 := JTF_NUMBER_TABLE();
359: a11 := JTF_NUMBER_TABLE();
360: a12 := JTF_NUMBER_TABLE();
361: a13 := JTF_NUMBER_TABLE();
354: a6 := JTF_VARCHAR2_TABLE_300();
355: a7 := JTF_VARCHAR2_TABLE_300();
356: a8 := JTF_VARCHAR2_TABLE_100();
357: a9 := JTF_NUMBER_TABLE();
358: a10 := JTF_NUMBER_TABLE();
359: a11 := JTF_NUMBER_TABLE();
360: a12 := JTF_NUMBER_TABLE();
361: a13 := JTF_NUMBER_TABLE();
362: a14 := JTF_VARCHAR2_TABLE_100();
355: a7 := JTF_VARCHAR2_TABLE_300();
356: a8 := JTF_VARCHAR2_TABLE_100();
357: a9 := JTF_NUMBER_TABLE();
358: a10 := JTF_NUMBER_TABLE();
359: a11 := JTF_NUMBER_TABLE();
360: a12 := JTF_NUMBER_TABLE();
361: a13 := JTF_NUMBER_TABLE();
362: a14 := JTF_VARCHAR2_TABLE_100();
363: a15 := JTF_VARCHAR2_TABLE_100();
356: a8 := JTF_VARCHAR2_TABLE_100();
357: a9 := JTF_NUMBER_TABLE();
358: a10 := JTF_NUMBER_TABLE();
359: a11 := JTF_NUMBER_TABLE();
360: a12 := JTF_NUMBER_TABLE();
361: a13 := JTF_NUMBER_TABLE();
362: a14 := JTF_VARCHAR2_TABLE_100();
363: a15 := JTF_VARCHAR2_TABLE_100();
364: a16 := JTF_VARCHAR2_TABLE_100();
357: a9 := JTF_NUMBER_TABLE();
358: a10 := JTF_NUMBER_TABLE();
359: a11 := JTF_NUMBER_TABLE();
360: a12 := JTF_NUMBER_TABLE();
361: a13 := JTF_NUMBER_TABLE();
362: a14 := JTF_VARCHAR2_TABLE_100();
363: a15 := JTF_VARCHAR2_TABLE_100();
364: a16 := JTF_VARCHAR2_TABLE_100();
365: a17 := JTF_VARCHAR2_TABLE_100();
377: a29 := JTF_VARCHAR2_TABLE_100();
378: a30 := JTF_VARCHAR2_TABLE_100();
379: a31 := JTF_VARCHAR2_TABLE_100();
380: a32 := JTF_VARCHAR2_TABLE_100();
381: a33 := JTF_NUMBER_TABLE();
382: a34 := JTF_NUMBER_TABLE();
383: a35 := JTF_NUMBER_TABLE();
384: a36 := JTF_NUMBER_TABLE();
385: a37 := JTF_NUMBER_TABLE();
378: a30 := JTF_VARCHAR2_TABLE_100();
379: a31 := JTF_VARCHAR2_TABLE_100();
380: a32 := JTF_VARCHAR2_TABLE_100();
381: a33 := JTF_NUMBER_TABLE();
382: a34 := JTF_NUMBER_TABLE();
383: a35 := JTF_NUMBER_TABLE();
384: a36 := JTF_NUMBER_TABLE();
385: a37 := JTF_NUMBER_TABLE();
386: a38 := JTF_NUMBER_TABLE();
379: a31 := JTF_VARCHAR2_TABLE_100();
380: a32 := JTF_VARCHAR2_TABLE_100();
381: a33 := JTF_NUMBER_TABLE();
382: a34 := JTF_NUMBER_TABLE();
383: a35 := JTF_NUMBER_TABLE();
384: a36 := JTF_NUMBER_TABLE();
385: a37 := JTF_NUMBER_TABLE();
386: a38 := JTF_NUMBER_TABLE();
387: a39 := JTF_VARCHAR2_TABLE_300();
380: a32 := JTF_VARCHAR2_TABLE_100();
381: a33 := JTF_NUMBER_TABLE();
382: a34 := JTF_NUMBER_TABLE();
383: a35 := JTF_NUMBER_TABLE();
384: a36 := JTF_NUMBER_TABLE();
385: a37 := JTF_NUMBER_TABLE();
386: a38 := JTF_NUMBER_TABLE();
387: a39 := JTF_VARCHAR2_TABLE_300();
388: a40 := JTF_VARCHAR2_TABLE_100();
381: a33 := JTF_NUMBER_TABLE();
382: a34 := JTF_NUMBER_TABLE();
383: a35 := JTF_NUMBER_TABLE();
384: a36 := JTF_NUMBER_TABLE();
385: a37 := JTF_NUMBER_TABLE();
386: a38 := JTF_NUMBER_TABLE();
387: a39 := JTF_VARCHAR2_TABLE_300();
388: a40 := JTF_VARCHAR2_TABLE_100();
389: a41 := JTF_NUMBER_TABLE();
382: a34 := JTF_NUMBER_TABLE();
383: a35 := JTF_NUMBER_TABLE();
384: a36 := JTF_NUMBER_TABLE();
385: a37 := JTF_NUMBER_TABLE();
386: a38 := JTF_NUMBER_TABLE();
387: a39 := JTF_VARCHAR2_TABLE_300();
388: a40 := JTF_VARCHAR2_TABLE_100();
389: a41 := JTF_NUMBER_TABLE();
390: a42 := JTF_VARCHAR2_TABLE_100();
385: a37 := JTF_NUMBER_TABLE();
386: a38 := JTF_NUMBER_TABLE();
387: a39 := JTF_VARCHAR2_TABLE_300();
388: a40 := JTF_VARCHAR2_TABLE_100();
389: a41 := JTF_NUMBER_TABLE();
390: a42 := JTF_VARCHAR2_TABLE_100();
391: a43 := JTF_NUMBER_TABLE();
392: a44 := JTF_NUMBER_TABLE();
393: a45 := JTF_NUMBER_TABLE();
387: a39 := JTF_VARCHAR2_TABLE_300();
388: a40 := JTF_VARCHAR2_TABLE_100();
389: a41 := JTF_NUMBER_TABLE();
390: a42 := JTF_VARCHAR2_TABLE_100();
391: a43 := JTF_NUMBER_TABLE();
392: a44 := JTF_NUMBER_TABLE();
393: a45 := JTF_NUMBER_TABLE();
394: a46 := JTF_NUMBER_TABLE();
395: a47 := JTF_VARCHAR2_TABLE_100();
388: a40 := JTF_VARCHAR2_TABLE_100();
389: a41 := JTF_NUMBER_TABLE();
390: a42 := JTF_VARCHAR2_TABLE_100();
391: a43 := JTF_NUMBER_TABLE();
392: a44 := JTF_NUMBER_TABLE();
393: a45 := JTF_NUMBER_TABLE();
394: a46 := JTF_NUMBER_TABLE();
395: a47 := JTF_VARCHAR2_TABLE_100();
396: a48 := JTF_VARCHAR2_TABLE_100();
389: a41 := JTF_NUMBER_TABLE();
390: a42 := JTF_VARCHAR2_TABLE_100();
391: a43 := JTF_NUMBER_TABLE();
392: a44 := JTF_NUMBER_TABLE();
393: a45 := JTF_NUMBER_TABLE();
394: a46 := JTF_NUMBER_TABLE();
395: a47 := JTF_VARCHAR2_TABLE_100();
396: a48 := JTF_VARCHAR2_TABLE_100();
397: a49 := JTF_VARCHAR2_TABLE_500();
390: a42 := JTF_VARCHAR2_TABLE_100();
391: a43 := JTF_NUMBER_TABLE();
392: a44 := JTF_NUMBER_TABLE();
393: a45 := JTF_NUMBER_TABLE();
394: a46 := JTF_NUMBER_TABLE();
395: a47 := JTF_VARCHAR2_TABLE_100();
396: a48 := JTF_VARCHAR2_TABLE_100();
397: a49 := JTF_VARCHAR2_TABLE_500();
398: a50 := JTF_VARCHAR2_TABLE_500();
408: a60 := JTF_VARCHAR2_TABLE_500();
409: a61 := JTF_VARCHAR2_TABLE_500();
410: a62 := JTF_VARCHAR2_TABLE_500();
411: a63 := JTF_VARCHAR2_TABLE_500();
412: a64 := JTF_NUMBER_TABLE();
413: a65 := JTF_NUMBER_TABLE();
414: a66 := JTF_DATE_TABLE();
415: a67 := JTF_NUMBER_TABLE();
416: a68 := JTF_NUMBER_TABLE();
409: a61 := JTF_VARCHAR2_TABLE_500();
410: a62 := JTF_VARCHAR2_TABLE_500();
411: a63 := JTF_VARCHAR2_TABLE_500();
412: a64 := JTF_NUMBER_TABLE();
413: a65 := JTF_NUMBER_TABLE();
414: a66 := JTF_DATE_TABLE();
415: a67 := JTF_NUMBER_TABLE();
416: a68 := JTF_NUMBER_TABLE();
417: a69 := JTF_NUMBER_TABLE();
411: a63 := JTF_VARCHAR2_TABLE_500();
412: a64 := JTF_NUMBER_TABLE();
413: a65 := JTF_NUMBER_TABLE();
414: a66 := JTF_DATE_TABLE();
415: a67 := JTF_NUMBER_TABLE();
416: a68 := JTF_NUMBER_TABLE();
417: a69 := JTF_NUMBER_TABLE();
418: a70 := JTF_NUMBER_TABLE();
419: a71 := JTF_DATE_TABLE();
412: a64 := JTF_NUMBER_TABLE();
413: a65 := JTF_NUMBER_TABLE();
414: a66 := JTF_DATE_TABLE();
415: a67 := JTF_NUMBER_TABLE();
416: a68 := JTF_NUMBER_TABLE();
417: a69 := JTF_NUMBER_TABLE();
418: a70 := JTF_NUMBER_TABLE();
419: a71 := JTF_DATE_TABLE();
420: a72 := JTF_NUMBER_TABLE();
413: a65 := JTF_NUMBER_TABLE();
414: a66 := JTF_DATE_TABLE();
415: a67 := JTF_NUMBER_TABLE();
416: a68 := JTF_NUMBER_TABLE();
417: a69 := JTF_NUMBER_TABLE();
418: a70 := JTF_NUMBER_TABLE();
419: a71 := JTF_DATE_TABLE();
420: a72 := JTF_NUMBER_TABLE();
421: a73 := JTF_DATE_TABLE();
414: a66 := JTF_DATE_TABLE();
415: a67 := JTF_NUMBER_TABLE();
416: a68 := JTF_NUMBER_TABLE();
417: a69 := JTF_NUMBER_TABLE();
418: a70 := JTF_NUMBER_TABLE();
419: a71 := JTF_DATE_TABLE();
420: a72 := JTF_NUMBER_TABLE();
421: a73 := JTF_DATE_TABLE();
422: a74 := JTF_NUMBER_TABLE();
416: a68 := JTF_NUMBER_TABLE();
417: a69 := JTF_NUMBER_TABLE();
418: a70 := JTF_NUMBER_TABLE();
419: a71 := JTF_DATE_TABLE();
420: a72 := JTF_NUMBER_TABLE();
421: a73 := JTF_DATE_TABLE();
422: a74 := JTF_NUMBER_TABLE();
423: a75 := JTF_NUMBER_TABLE();
424: if t.count > 0 then
418: a70 := JTF_NUMBER_TABLE();
419: a71 := JTF_DATE_TABLE();
420: a72 := JTF_NUMBER_TABLE();
421: a73 := JTF_DATE_TABLE();
422: a74 := JTF_NUMBER_TABLE();
423: a75 := JTF_NUMBER_TABLE();
424: if t.count > 0 then
425: a0.extend(t.count);
426: a1.extend(t.count);
419: a71 := JTF_DATE_TABLE();
420: a72 := JTF_NUMBER_TABLE();
421: a73 := JTF_DATE_TABLE();
422: a74 := JTF_NUMBER_TABLE();
423: a75 := JTF_NUMBER_TABLE();
424: if t.count > 0 then
425: a0.extend(t.count);
426: a1.extend(t.count);
427: a2.extend(t.count);
586: end if;
587: end if;
588: end rosetta_table_copy_out_p1;
589:
590: procedure rosetta_table_copy_in_p3(t out nocopy okl_ins_quote_pvt.inav_tbl_type, a0 JTF_NUMBER_TABLE
591: , a1 JTF_NUMBER_TABLE
592: , a2 JTF_NUMBER_TABLE
593: , a3 JTF_NUMBER_TABLE
594: , a4 JTF_NUMBER_TABLE
587: end if;
588: end rosetta_table_copy_out_p1;
589:
590: procedure rosetta_table_copy_in_p3(t out nocopy okl_ins_quote_pvt.inav_tbl_type, a0 JTF_NUMBER_TABLE
591: , a1 JTF_NUMBER_TABLE
592: , a2 JTF_NUMBER_TABLE
593: , a3 JTF_NUMBER_TABLE
594: , a4 JTF_NUMBER_TABLE
595: , a5 JTF_NUMBER_TABLE
588: end rosetta_table_copy_out_p1;
589:
590: procedure rosetta_table_copy_in_p3(t out nocopy okl_ins_quote_pvt.inav_tbl_type, a0 JTF_NUMBER_TABLE
591: , a1 JTF_NUMBER_TABLE
592: , a2 JTF_NUMBER_TABLE
593: , a3 JTF_NUMBER_TABLE
594: , a4 JTF_NUMBER_TABLE
595: , a5 JTF_NUMBER_TABLE
596: , a6 JTF_NUMBER_TABLE
589:
590: procedure rosetta_table_copy_in_p3(t out nocopy okl_ins_quote_pvt.inav_tbl_type, a0 JTF_NUMBER_TABLE
591: , a1 JTF_NUMBER_TABLE
592: , a2 JTF_NUMBER_TABLE
593: , a3 JTF_NUMBER_TABLE
594: , a4 JTF_NUMBER_TABLE
595: , a5 JTF_NUMBER_TABLE
596: , a6 JTF_NUMBER_TABLE
597: , a7 JTF_VARCHAR2_TABLE_100
590: procedure rosetta_table_copy_in_p3(t out nocopy okl_ins_quote_pvt.inav_tbl_type, a0 JTF_NUMBER_TABLE
591: , a1 JTF_NUMBER_TABLE
592: , a2 JTF_NUMBER_TABLE
593: , a3 JTF_NUMBER_TABLE
594: , a4 JTF_NUMBER_TABLE
595: , a5 JTF_NUMBER_TABLE
596: , a6 JTF_NUMBER_TABLE
597: , a7 JTF_VARCHAR2_TABLE_100
598: , a8 JTF_VARCHAR2_TABLE_500
591: , a1 JTF_NUMBER_TABLE
592: , a2 JTF_NUMBER_TABLE
593: , a3 JTF_NUMBER_TABLE
594: , a4 JTF_NUMBER_TABLE
595: , a5 JTF_NUMBER_TABLE
596: , a6 JTF_NUMBER_TABLE
597: , a7 JTF_VARCHAR2_TABLE_100
598: , a8 JTF_VARCHAR2_TABLE_500
599: , a9 JTF_VARCHAR2_TABLE_500
592: , a2 JTF_NUMBER_TABLE
593: , a3 JTF_NUMBER_TABLE
594: , a4 JTF_NUMBER_TABLE
595: , a5 JTF_NUMBER_TABLE
596: , a6 JTF_NUMBER_TABLE
597: , a7 JTF_VARCHAR2_TABLE_100
598: , a8 JTF_VARCHAR2_TABLE_500
599: , a9 JTF_VARCHAR2_TABLE_500
600: , a10 JTF_VARCHAR2_TABLE_500
609: , a19 JTF_VARCHAR2_TABLE_500
610: , a20 JTF_VARCHAR2_TABLE_500
611: , a21 JTF_VARCHAR2_TABLE_500
612: , a22 JTF_VARCHAR2_TABLE_500
613: , a23 JTF_NUMBER_TABLE
614: , a24 JTF_NUMBER_TABLE
615: , a25 JTF_NUMBER_TABLE
616: , a26 JTF_NUMBER_TABLE
617: , a27 JTF_DATE_TABLE
610: , a20 JTF_VARCHAR2_TABLE_500
611: , a21 JTF_VARCHAR2_TABLE_500
612: , a22 JTF_VARCHAR2_TABLE_500
613: , a23 JTF_NUMBER_TABLE
614: , a24 JTF_NUMBER_TABLE
615: , a25 JTF_NUMBER_TABLE
616: , a26 JTF_NUMBER_TABLE
617: , a27 JTF_DATE_TABLE
618: , a28 JTF_NUMBER_TABLE
611: , a21 JTF_VARCHAR2_TABLE_500
612: , a22 JTF_VARCHAR2_TABLE_500
613: , a23 JTF_NUMBER_TABLE
614: , a24 JTF_NUMBER_TABLE
615: , a25 JTF_NUMBER_TABLE
616: , a26 JTF_NUMBER_TABLE
617: , a27 JTF_DATE_TABLE
618: , a28 JTF_NUMBER_TABLE
619: , a29 JTF_DATE_TABLE
612: , a22 JTF_VARCHAR2_TABLE_500
613: , a23 JTF_NUMBER_TABLE
614: , a24 JTF_NUMBER_TABLE
615: , a25 JTF_NUMBER_TABLE
616: , a26 JTF_NUMBER_TABLE
617: , a27 JTF_DATE_TABLE
618: , a28 JTF_NUMBER_TABLE
619: , a29 JTF_DATE_TABLE
620: , a30 JTF_NUMBER_TABLE
614: , a24 JTF_NUMBER_TABLE
615: , a25 JTF_NUMBER_TABLE
616: , a26 JTF_NUMBER_TABLE
617: , a27 JTF_DATE_TABLE
618: , a28 JTF_NUMBER_TABLE
619: , a29 JTF_DATE_TABLE
620: , a30 JTF_NUMBER_TABLE
621: , a31 JTF_DATE_TABLE
622: , a32 JTF_NUMBER_TABLE
616: , a26 JTF_NUMBER_TABLE
617: , a27 JTF_DATE_TABLE
618: , a28 JTF_NUMBER_TABLE
619: , a29 JTF_DATE_TABLE
620: , a30 JTF_NUMBER_TABLE
621: , a31 JTF_DATE_TABLE
622: , a32 JTF_NUMBER_TABLE
623: ) as
624: ddindx binary_integer; indx binary_integer;
618: , a28 JTF_NUMBER_TABLE
619: , a29 JTF_DATE_TABLE
620: , a30 JTF_NUMBER_TABLE
621: , a31 JTF_DATE_TABLE
622: , a32 JTF_NUMBER_TABLE
623: ) as
624: ddindx binary_integer; indx binary_integer;
625: begin
626: if a0 is not null and a0.count > 0 then
669: end loop;
670: end if;
671: end if;
672: end rosetta_table_copy_in_p3;
673: procedure rosetta_table_copy_out_p3(t okl_ins_quote_pvt.inav_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
674: , a1 out nocopy JTF_NUMBER_TABLE
675: , a2 out nocopy JTF_NUMBER_TABLE
676: , a3 out nocopy JTF_NUMBER_TABLE
677: , a4 out nocopy JTF_NUMBER_TABLE
670: end if;
671: end if;
672: end rosetta_table_copy_in_p3;
673: procedure rosetta_table_copy_out_p3(t okl_ins_quote_pvt.inav_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
674: , a1 out nocopy JTF_NUMBER_TABLE
675: , a2 out nocopy JTF_NUMBER_TABLE
676: , a3 out nocopy JTF_NUMBER_TABLE
677: , a4 out nocopy JTF_NUMBER_TABLE
678: , a5 out nocopy JTF_NUMBER_TABLE
671: end if;
672: end rosetta_table_copy_in_p3;
673: procedure rosetta_table_copy_out_p3(t okl_ins_quote_pvt.inav_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
674: , a1 out nocopy JTF_NUMBER_TABLE
675: , a2 out nocopy JTF_NUMBER_TABLE
676: , a3 out nocopy JTF_NUMBER_TABLE
677: , a4 out nocopy JTF_NUMBER_TABLE
678: , a5 out nocopy JTF_NUMBER_TABLE
679: , a6 out nocopy JTF_NUMBER_TABLE
672: end rosetta_table_copy_in_p3;
673: procedure rosetta_table_copy_out_p3(t okl_ins_quote_pvt.inav_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
674: , a1 out nocopy JTF_NUMBER_TABLE
675: , a2 out nocopy JTF_NUMBER_TABLE
676: , a3 out nocopy JTF_NUMBER_TABLE
677: , a4 out nocopy JTF_NUMBER_TABLE
678: , a5 out nocopy JTF_NUMBER_TABLE
679: , a6 out nocopy JTF_NUMBER_TABLE
680: , a7 out nocopy JTF_VARCHAR2_TABLE_100
673: procedure rosetta_table_copy_out_p3(t okl_ins_quote_pvt.inav_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
674: , a1 out nocopy JTF_NUMBER_TABLE
675: , a2 out nocopy JTF_NUMBER_TABLE
676: , a3 out nocopy JTF_NUMBER_TABLE
677: , a4 out nocopy JTF_NUMBER_TABLE
678: , a5 out nocopy JTF_NUMBER_TABLE
679: , a6 out nocopy JTF_NUMBER_TABLE
680: , a7 out nocopy JTF_VARCHAR2_TABLE_100
681: , a8 out nocopy JTF_VARCHAR2_TABLE_500
674: , a1 out nocopy JTF_NUMBER_TABLE
675: , a2 out nocopy JTF_NUMBER_TABLE
676: , a3 out nocopy JTF_NUMBER_TABLE
677: , a4 out nocopy JTF_NUMBER_TABLE
678: , a5 out nocopy JTF_NUMBER_TABLE
679: , a6 out nocopy JTF_NUMBER_TABLE
680: , a7 out nocopy JTF_VARCHAR2_TABLE_100
681: , a8 out nocopy JTF_VARCHAR2_TABLE_500
682: , a9 out nocopy JTF_VARCHAR2_TABLE_500
675: , a2 out nocopy JTF_NUMBER_TABLE
676: , a3 out nocopy JTF_NUMBER_TABLE
677: , a4 out nocopy JTF_NUMBER_TABLE
678: , a5 out nocopy JTF_NUMBER_TABLE
679: , a6 out nocopy JTF_NUMBER_TABLE
680: , a7 out nocopy JTF_VARCHAR2_TABLE_100
681: , a8 out nocopy JTF_VARCHAR2_TABLE_500
682: , a9 out nocopy JTF_VARCHAR2_TABLE_500
683: , a10 out nocopy JTF_VARCHAR2_TABLE_500
692: , a19 out nocopy JTF_VARCHAR2_TABLE_500
693: , a20 out nocopy JTF_VARCHAR2_TABLE_500
694: , a21 out nocopy JTF_VARCHAR2_TABLE_500
695: , a22 out nocopy JTF_VARCHAR2_TABLE_500
696: , a23 out nocopy JTF_NUMBER_TABLE
697: , a24 out nocopy JTF_NUMBER_TABLE
698: , a25 out nocopy JTF_NUMBER_TABLE
699: , a26 out nocopy JTF_NUMBER_TABLE
700: , a27 out nocopy JTF_DATE_TABLE
693: , a20 out nocopy JTF_VARCHAR2_TABLE_500
694: , a21 out nocopy JTF_VARCHAR2_TABLE_500
695: , a22 out nocopy JTF_VARCHAR2_TABLE_500
696: , a23 out nocopy JTF_NUMBER_TABLE
697: , a24 out nocopy JTF_NUMBER_TABLE
698: , a25 out nocopy JTF_NUMBER_TABLE
699: , a26 out nocopy JTF_NUMBER_TABLE
700: , a27 out nocopy JTF_DATE_TABLE
701: , a28 out nocopy JTF_NUMBER_TABLE
694: , a21 out nocopy JTF_VARCHAR2_TABLE_500
695: , a22 out nocopy JTF_VARCHAR2_TABLE_500
696: , a23 out nocopy JTF_NUMBER_TABLE
697: , a24 out nocopy JTF_NUMBER_TABLE
698: , a25 out nocopy JTF_NUMBER_TABLE
699: , a26 out nocopy JTF_NUMBER_TABLE
700: , a27 out nocopy JTF_DATE_TABLE
701: , a28 out nocopy JTF_NUMBER_TABLE
702: , a29 out nocopy JTF_DATE_TABLE
695: , a22 out nocopy JTF_VARCHAR2_TABLE_500
696: , a23 out nocopy JTF_NUMBER_TABLE
697: , a24 out nocopy JTF_NUMBER_TABLE
698: , a25 out nocopy JTF_NUMBER_TABLE
699: , a26 out nocopy JTF_NUMBER_TABLE
700: , a27 out nocopy JTF_DATE_TABLE
701: , a28 out nocopy JTF_NUMBER_TABLE
702: , a29 out nocopy JTF_DATE_TABLE
703: , a30 out nocopy JTF_NUMBER_TABLE
697: , a24 out nocopy JTF_NUMBER_TABLE
698: , a25 out nocopy JTF_NUMBER_TABLE
699: , a26 out nocopy JTF_NUMBER_TABLE
700: , a27 out nocopy JTF_DATE_TABLE
701: , a28 out nocopy JTF_NUMBER_TABLE
702: , a29 out nocopy JTF_DATE_TABLE
703: , a30 out nocopy JTF_NUMBER_TABLE
704: , a31 out nocopy JTF_DATE_TABLE
705: , a32 out nocopy JTF_NUMBER_TABLE
699: , a26 out nocopy JTF_NUMBER_TABLE
700: , a27 out nocopy JTF_DATE_TABLE
701: , a28 out nocopy JTF_NUMBER_TABLE
702: , a29 out nocopy JTF_DATE_TABLE
703: , a30 out nocopy JTF_NUMBER_TABLE
704: , a31 out nocopy JTF_DATE_TABLE
705: , a32 out nocopy JTF_NUMBER_TABLE
706: ) as
707: ddindx binary_integer; indx binary_integer;
701: , a28 out nocopy JTF_NUMBER_TABLE
702: , a29 out nocopy JTF_DATE_TABLE
703: , a30 out nocopy JTF_NUMBER_TABLE
704: , a31 out nocopy JTF_DATE_TABLE
705: , a32 out nocopy JTF_NUMBER_TABLE
706: ) as
707: ddindx binary_integer; indx binary_integer;
708: begin
709: if t is null or t.count = 0 then
706: ) as
707: ddindx binary_integer; indx binary_integer;
708: begin
709: if t is null or t.count = 0 then
710: a0 := JTF_NUMBER_TABLE();
711: a1 := JTF_NUMBER_TABLE();
712: a2 := JTF_NUMBER_TABLE();
713: a3 := JTF_NUMBER_TABLE();
714: a4 := JTF_NUMBER_TABLE();
707: ddindx binary_integer; indx binary_integer;
708: begin
709: if t is null or t.count = 0 then
710: a0 := JTF_NUMBER_TABLE();
711: a1 := JTF_NUMBER_TABLE();
712: a2 := JTF_NUMBER_TABLE();
713: a3 := JTF_NUMBER_TABLE();
714: a4 := JTF_NUMBER_TABLE();
715: a5 := JTF_NUMBER_TABLE();
708: begin
709: if t is null or t.count = 0 then
710: a0 := JTF_NUMBER_TABLE();
711: a1 := JTF_NUMBER_TABLE();
712: a2 := JTF_NUMBER_TABLE();
713: a3 := JTF_NUMBER_TABLE();
714: a4 := JTF_NUMBER_TABLE();
715: a5 := JTF_NUMBER_TABLE();
716: a6 := JTF_NUMBER_TABLE();
709: if t is null or t.count = 0 then
710: a0 := JTF_NUMBER_TABLE();
711: a1 := JTF_NUMBER_TABLE();
712: a2 := JTF_NUMBER_TABLE();
713: a3 := JTF_NUMBER_TABLE();
714: a4 := JTF_NUMBER_TABLE();
715: a5 := JTF_NUMBER_TABLE();
716: a6 := JTF_NUMBER_TABLE();
717: a7 := JTF_VARCHAR2_TABLE_100();
710: a0 := JTF_NUMBER_TABLE();
711: a1 := JTF_NUMBER_TABLE();
712: a2 := JTF_NUMBER_TABLE();
713: a3 := JTF_NUMBER_TABLE();
714: a4 := JTF_NUMBER_TABLE();
715: a5 := JTF_NUMBER_TABLE();
716: a6 := JTF_NUMBER_TABLE();
717: a7 := JTF_VARCHAR2_TABLE_100();
718: a8 := JTF_VARCHAR2_TABLE_500();
711: a1 := JTF_NUMBER_TABLE();
712: a2 := JTF_NUMBER_TABLE();
713: a3 := JTF_NUMBER_TABLE();
714: a4 := JTF_NUMBER_TABLE();
715: a5 := JTF_NUMBER_TABLE();
716: a6 := JTF_NUMBER_TABLE();
717: a7 := JTF_VARCHAR2_TABLE_100();
718: a8 := JTF_VARCHAR2_TABLE_500();
719: a9 := JTF_VARCHAR2_TABLE_500();
712: a2 := JTF_NUMBER_TABLE();
713: a3 := JTF_NUMBER_TABLE();
714: a4 := JTF_NUMBER_TABLE();
715: a5 := JTF_NUMBER_TABLE();
716: a6 := JTF_NUMBER_TABLE();
717: a7 := JTF_VARCHAR2_TABLE_100();
718: a8 := JTF_VARCHAR2_TABLE_500();
719: a9 := JTF_VARCHAR2_TABLE_500();
720: a10 := JTF_VARCHAR2_TABLE_500();
729: a19 := JTF_VARCHAR2_TABLE_500();
730: a20 := JTF_VARCHAR2_TABLE_500();
731: a21 := JTF_VARCHAR2_TABLE_500();
732: a22 := JTF_VARCHAR2_TABLE_500();
733: a23 := JTF_NUMBER_TABLE();
734: a24 := JTF_NUMBER_TABLE();
735: a25 := JTF_NUMBER_TABLE();
736: a26 := JTF_NUMBER_TABLE();
737: a27 := JTF_DATE_TABLE();
730: a20 := JTF_VARCHAR2_TABLE_500();
731: a21 := JTF_VARCHAR2_TABLE_500();
732: a22 := JTF_VARCHAR2_TABLE_500();
733: a23 := JTF_NUMBER_TABLE();
734: a24 := JTF_NUMBER_TABLE();
735: a25 := JTF_NUMBER_TABLE();
736: a26 := JTF_NUMBER_TABLE();
737: a27 := JTF_DATE_TABLE();
738: a28 := JTF_NUMBER_TABLE();
731: a21 := JTF_VARCHAR2_TABLE_500();
732: a22 := JTF_VARCHAR2_TABLE_500();
733: a23 := JTF_NUMBER_TABLE();
734: a24 := JTF_NUMBER_TABLE();
735: a25 := JTF_NUMBER_TABLE();
736: a26 := JTF_NUMBER_TABLE();
737: a27 := JTF_DATE_TABLE();
738: a28 := JTF_NUMBER_TABLE();
739: a29 := JTF_DATE_TABLE();
732: a22 := JTF_VARCHAR2_TABLE_500();
733: a23 := JTF_NUMBER_TABLE();
734: a24 := JTF_NUMBER_TABLE();
735: a25 := JTF_NUMBER_TABLE();
736: a26 := JTF_NUMBER_TABLE();
737: a27 := JTF_DATE_TABLE();
738: a28 := JTF_NUMBER_TABLE();
739: a29 := JTF_DATE_TABLE();
740: a30 := JTF_NUMBER_TABLE();
734: a24 := JTF_NUMBER_TABLE();
735: a25 := JTF_NUMBER_TABLE();
736: a26 := JTF_NUMBER_TABLE();
737: a27 := JTF_DATE_TABLE();
738: a28 := JTF_NUMBER_TABLE();
739: a29 := JTF_DATE_TABLE();
740: a30 := JTF_NUMBER_TABLE();
741: a31 := JTF_DATE_TABLE();
742: a32 := JTF_NUMBER_TABLE();
736: a26 := JTF_NUMBER_TABLE();
737: a27 := JTF_DATE_TABLE();
738: a28 := JTF_NUMBER_TABLE();
739: a29 := JTF_DATE_TABLE();
740: a30 := JTF_NUMBER_TABLE();
741: a31 := JTF_DATE_TABLE();
742: a32 := JTF_NUMBER_TABLE();
743: else
744: a0 := JTF_NUMBER_TABLE();
738: a28 := JTF_NUMBER_TABLE();
739: a29 := JTF_DATE_TABLE();
740: a30 := JTF_NUMBER_TABLE();
741: a31 := JTF_DATE_TABLE();
742: a32 := JTF_NUMBER_TABLE();
743: else
744: a0 := JTF_NUMBER_TABLE();
745: a1 := JTF_NUMBER_TABLE();
746: a2 := JTF_NUMBER_TABLE();
740: a30 := JTF_NUMBER_TABLE();
741: a31 := JTF_DATE_TABLE();
742: a32 := JTF_NUMBER_TABLE();
743: else
744: a0 := JTF_NUMBER_TABLE();
745: a1 := JTF_NUMBER_TABLE();
746: a2 := JTF_NUMBER_TABLE();
747: a3 := JTF_NUMBER_TABLE();
748: a4 := JTF_NUMBER_TABLE();
741: a31 := JTF_DATE_TABLE();
742: a32 := JTF_NUMBER_TABLE();
743: else
744: a0 := JTF_NUMBER_TABLE();
745: a1 := JTF_NUMBER_TABLE();
746: a2 := JTF_NUMBER_TABLE();
747: a3 := JTF_NUMBER_TABLE();
748: a4 := JTF_NUMBER_TABLE();
749: a5 := JTF_NUMBER_TABLE();
742: a32 := JTF_NUMBER_TABLE();
743: else
744: a0 := JTF_NUMBER_TABLE();
745: a1 := JTF_NUMBER_TABLE();
746: a2 := JTF_NUMBER_TABLE();
747: a3 := JTF_NUMBER_TABLE();
748: a4 := JTF_NUMBER_TABLE();
749: a5 := JTF_NUMBER_TABLE();
750: a6 := JTF_NUMBER_TABLE();
743: else
744: a0 := JTF_NUMBER_TABLE();
745: a1 := JTF_NUMBER_TABLE();
746: a2 := JTF_NUMBER_TABLE();
747: a3 := JTF_NUMBER_TABLE();
748: a4 := JTF_NUMBER_TABLE();
749: a5 := JTF_NUMBER_TABLE();
750: a6 := JTF_NUMBER_TABLE();
751: a7 := JTF_VARCHAR2_TABLE_100();
744: a0 := JTF_NUMBER_TABLE();
745: a1 := JTF_NUMBER_TABLE();
746: a2 := JTF_NUMBER_TABLE();
747: a3 := JTF_NUMBER_TABLE();
748: a4 := JTF_NUMBER_TABLE();
749: a5 := JTF_NUMBER_TABLE();
750: a6 := JTF_NUMBER_TABLE();
751: a7 := JTF_VARCHAR2_TABLE_100();
752: a8 := JTF_VARCHAR2_TABLE_500();
745: a1 := JTF_NUMBER_TABLE();
746: a2 := JTF_NUMBER_TABLE();
747: a3 := JTF_NUMBER_TABLE();
748: a4 := JTF_NUMBER_TABLE();
749: a5 := JTF_NUMBER_TABLE();
750: a6 := JTF_NUMBER_TABLE();
751: a7 := JTF_VARCHAR2_TABLE_100();
752: a8 := JTF_VARCHAR2_TABLE_500();
753: a9 := JTF_VARCHAR2_TABLE_500();
746: a2 := JTF_NUMBER_TABLE();
747: a3 := JTF_NUMBER_TABLE();
748: a4 := JTF_NUMBER_TABLE();
749: a5 := JTF_NUMBER_TABLE();
750: a6 := JTF_NUMBER_TABLE();
751: a7 := JTF_VARCHAR2_TABLE_100();
752: a8 := JTF_VARCHAR2_TABLE_500();
753: a9 := JTF_VARCHAR2_TABLE_500();
754: a10 := JTF_VARCHAR2_TABLE_500();
763: a19 := JTF_VARCHAR2_TABLE_500();
764: a20 := JTF_VARCHAR2_TABLE_500();
765: a21 := JTF_VARCHAR2_TABLE_500();
766: a22 := JTF_VARCHAR2_TABLE_500();
767: a23 := JTF_NUMBER_TABLE();
768: a24 := JTF_NUMBER_TABLE();
769: a25 := JTF_NUMBER_TABLE();
770: a26 := JTF_NUMBER_TABLE();
771: a27 := JTF_DATE_TABLE();
764: a20 := JTF_VARCHAR2_TABLE_500();
765: a21 := JTF_VARCHAR2_TABLE_500();
766: a22 := JTF_VARCHAR2_TABLE_500();
767: a23 := JTF_NUMBER_TABLE();
768: a24 := JTF_NUMBER_TABLE();
769: a25 := JTF_NUMBER_TABLE();
770: a26 := JTF_NUMBER_TABLE();
771: a27 := JTF_DATE_TABLE();
772: a28 := JTF_NUMBER_TABLE();
765: a21 := JTF_VARCHAR2_TABLE_500();
766: a22 := JTF_VARCHAR2_TABLE_500();
767: a23 := JTF_NUMBER_TABLE();
768: a24 := JTF_NUMBER_TABLE();
769: a25 := JTF_NUMBER_TABLE();
770: a26 := JTF_NUMBER_TABLE();
771: a27 := JTF_DATE_TABLE();
772: a28 := JTF_NUMBER_TABLE();
773: a29 := JTF_DATE_TABLE();
766: a22 := JTF_VARCHAR2_TABLE_500();
767: a23 := JTF_NUMBER_TABLE();
768: a24 := JTF_NUMBER_TABLE();
769: a25 := JTF_NUMBER_TABLE();
770: a26 := JTF_NUMBER_TABLE();
771: a27 := JTF_DATE_TABLE();
772: a28 := JTF_NUMBER_TABLE();
773: a29 := JTF_DATE_TABLE();
774: a30 := JTF_NUMBER_TABLE();
768: a24 := JTF_NUMBER_TABLE();
769: a25 := JTF_NUMBER_TABLE();
770: a26 := JTF_NUMBER_TABLE();
771: a27 := JTF_DATE_TABLE();
772: a28 := JTF_NUMBER_TABLE();
773: a29 := JTF_DATE_TABLE();
774: a30 := JTF_NUMBER_TABLE();
775: a31 := JTF_DATE_TABLE();
776: a32 := JTF_NUMBER_TABLE();
770: a26 := JTF_NUMBER_TABLE();
771: a27 := JTF_DATE_TABLE();
772: a28 := JTF_NUMBER_TABLE();
773: a29 := JTF_DATE_TABLE();
774: a30 := JTF_NUMBER_TABLE();
775: a31 := JTF_DATE_TABLE();
776: a32 := JTF_NUMBER_TABLE();
777: if t.count > 0 then
778: a0.extend(t.count);
772: a28 := JTF_NUMBER_TABLE();
773: a29 := JTF_DATE_TABLE();
774: a30 := JTF_NUMBER_TABLE();
775: a31 := JTF_DATE_TABLE();
776: a32 := JTF_NUMBER_TABLE();
777: if t.count > 0 then
778: a0.extend(t.count);
779: a1.extend(t.count);
780: a2.extend(t.count);
853: end if;
854: end if;
855: end rosetta_table_copy_out_p3;
856:
857: procedure rosetta_table_copy_in_p5(t out nocopy okl_ins_quote_pvt.iasset_tbl_type, a0 JTF_NUMBER_TABLE
858: , a1 JTF_NUMBER_TABLE
859: , a2 JTF_NUMBER_TABLE
860: ) as
861: ddindx binary_integer; indx binary_integer;
854: end if;
855: end rosetta_table_copy_out_p3;
856:
857: procedure rosetta_table_copy_in_p5(t out nocopy okl_ins_quote_pvt.iasset_tbl_type, a0 JTF_NUMBER_TABLE
858: , a1 JTF_NUMBER_TABLE
859: , a2 JTF_NUMBER_TABLE
860: ) as
861: ddindx binary_integer; indx binary_integer;
862: begin
855: end rosetta_table_copy_out_p3;
856:
857: procedure rosetta_table_copy_in_p5(t out nocopy okl_ins_quote_pvt.iasset_tbl_type, a0 JTF_NUMBER_TABLE
858: , a1 JTF_NUMBER_TABLE
859: , a2 JTF_NUMBER_TABLE
860: ) as
861: ddindx binary_integer; indx binary_integer;
862: begin
863: if a0 is not null and a0.count > 0 then
876: end loop;
877: end if;
878: end if;
879: end rosetta_table_copy_in_p5;
880: procedure rosetta_table_copy_out_p5(t okl_ins_quote_pvt.iasset_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
881: , a1 out nocopy JTF_NUMBER_TABLE
882: , a2 out nocopy JTF_NUMBER_TABLE
883: ) as
884: ddindx binary_integer; indx binary_integer;
877: end if;
878: end if;
879: end rosetta_table_copy_in_p5;
880: procedure rosetta_table_copy_out_p5(t okl_ins_quote_pvt.iasset_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
881: , a1 out nocopy JTF_NUMBER_TABLE
882: , a2 out nocopy JTF_NUMBER_TABLE
883: ) as
884: ddindx binary_integer; indx binary_integer;
885: begin
878: end if;
879: end rosetta_table_copy_in_p5;
880: procedure rosetta_table_copy_out_p5(t okl_ins_quote_pvt.iasset_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
881: , a1 out nocopy JTF_NUMBER_TABLE
882: , a2 out nocopy JTF_NUMBER_TABLE
883: ) as
884: ddindx binary_integer; indx binary_integer;
885: begin
886: if t is null or t.count = 0 then
883: ) as
884: ddindx binary_integer; indx binary_integer;
885: begin
886: if t is null or t.count = 0 then
887: a0 := JTF_NUMBER_TABLE();
888: a1 := JTF_NUMBER_TABLE();
889: a2 := JTF_NUMBER_TABLE();
890: else
891: a0 := JTF_NUMBER_TABLE();
884: ddindx binary_integer; indx binary_integer;
885: begin
886: if t is null or t.count = 0 then
887: a0 := JTF_NUMBER_TABLE();
888: a1 := JTF_NUMBER_TABLE();
889: a2 := JTF_NUMBER_TABLE();
890: else
891: a0 := JTF_NUMBER_TABLE();
892: a1 := JTF_NUMBER_TABLE();
885: begin
886: if t is null or t.count = 0 then
887: a0 := JTF_NUMBER_TABLE();
888: a1 := JTF_NUMBER_TABLE();
889: a2 := JTF_NUMBER_TABLE();
890: else
891: a0 := JTF_NUMBER_TABLE();
892: a1 := JTF_NUMBER_TABLE();
893: a2 := JTF_NUMBER_TABLE();
887: a0 := JTF_NUMBER_TABLE();
888: a1 := JTF_NUMBER_TABLE();
889: a2 := JTF_NUMBER_TABLE();
890: else
891: a0 := JTF_NUMBER_TABLE();
892: a1 := JTF_NUMBER_TABLE();
893: a2 := JTF_NUMBER_TABLE();
894: if t.count > 0 then
895: a0.extend(t.count);
888: a1 := JTF_NUMBER_TABLE();
889: a2 := JTF_NUMBER_TABLE();
890: else
891: a0 := JTF_NUMBER_TABLE();
892: a1 := JTF_NUMBER_TABLE();
893: a2 := JTF_NUMBER_TABLE();
894: if t.count > 0 then
895: a0.extend(t.count);
896: a1.extend(t.count);
889: a2 := JTF_NUMBER_TABLE();
890: else
891: a0 := JTF_NUMBER_TABLE();
892: a1 := JTF_NUMBER_TABLE();
893: a2 := JTF_NUMBER_TABLE();
894: if t.count > 0 then
895: a0.extend(t.count);
896: a1.extend(t.count);
897: a2.extend(t.count);
960: end if;
961: end if;
962: end rosetta_table_copy_out_p7;
963:
964: procedure rosetta_table_copy_in_p9(t out nocopy okl_ins_quote_pvt.payment_tbl_type, a0 JTF_NUMBER_TABLE
965: , a1 JTF_DATE_TABLE
966: ) as
967: ddindx binary_integer; indx binary_integer;
968: begin
981: end loop;
982: end if;
983: end if;
984: end rosetta_table_copy_in_p9;
985: procedure rosetta_table_copy_out_p9(t okl_ins_quote_pvt.payment_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
986: , a1 out nocopy JTF_DATE_TABLE
987: ) as
988: ddindx binary_integer; indx binary_integer;
989: begin
987: ) as
988: ddindx binary_integer; indx binary_integer;
989: begin
990: if t is null or t.count = 0 then
991: a0 := JTF_NUMBER_TABLE();
992: a1 := JTF_DATE_TABLE();
993: else
994: a0 := JTF_NUMBER_TABLE();
995: a1 := JTF_DATE_TABLE();
990: if t is null or t.count = 0 then
991: a0 := JTF_NUMBER_TABLE();
992: a1 := JTF_DATE_TABLE();
993: else
994: a0 := JTF_NUMBER_TABLE();
995: a1 := JTF_DATE_TABLE();
996: if t.count > 0 then
997: a0.extend(t.count);
998: a1.extend(t.count);
1010: end if;
1011: end if;
1012: end rosetta_table_copy_out_p9;
1013:
1014: procedure rosetta_table_copy_in_p11(t out nocopy okl_ins_quote_pvt.insexp_tbl_type, a0 JTF_NUMBER_TABLE
1015: , a1 JTF_NUMBER_TABLE
1016: ) as
1017: ddindx binary_integer; indx binary_integer;
1018: begin
1011: end if;
1012: end rosetta_table_copy_out_p9;
1013:
1014: procedure rosetta_table_copy_in_p11(t out nocopy okl_ins_quote_pvt.insexp_tbl_type, a0 JTF_NUMBER_TABLE
1015: , a1 JTF_NUMBER_TABLE
1016: ) as
1017: ddindx binary_integer; indx binary_integer;
1018: begin
1019: if a0 is not null and a0.count > 0 then
1031: end loop;
1032: end if;
1033: end if;
1034: end rosetta_table_copy_in_p11;
1035: procedure rosetta_table_copy_out_p11(t okl_ins_quote_pvt.insexp_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
1036: , a1 out nocopy JTF_NUMBER_TABLE
1037: ) as
1038: ddindx binary_integer; indx binary_integer;
1039: begin
1032: end if;
1033: end if;
1034: end rosetta_table_copy_in_p11;
1035: procedure rosetta_table_copy_out_p11(t okl_ins_quote_pvt.insexp_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
1036: , a1 out nocopy JTF_NUMBER_TABLE
1037: ) as
1038: ddindx binary_integer; indx binary_integer;
1039: begin
1040: if t is null or t.count = 0 then
1037: ) as
1038: ddindx binary_integer; indx binary_integer;
1039: begin
1040: if t is null or t.count = 0 then
1041: a0 := JTF_NUMBER_TABLE();
1042: a1 := JTF_NUMBER_TABLE();
1043: else
1044: a0 := JTF_NUMBER_TABLE();
1045: a1 := JTF_NUMBER_TABLE();
1038: ddindx binary_integer; indx binary_integer;
1039: begin
1040: if t is null or t.count = 0 then
1041: a0 := JTF_NUMBER_TABLE();
1042: a1 := JTF_NUMBER_TABLE();
1043: else
1044: a0 := JTF_NUMBER_TABLE();
1045: a1 := JTF_NUMBER_TABLE();
1046: if t.count > 0 then
1040: if t is null or t.count = 0 then
1041: a0 := JTF_NUMBER_TABLE();
1042: a1 := JTF_NUMBER_TABLE();
1043: else
1044: a0 := JTF_NUMBER_TABLE();
1045: a1 := JTF_NUMBER_TABLE();
1046: if t.count > 0 then
1047: a0.extend(t.count);
1048: a1.extend(t.count);
1041: a0 := JTF_NUMBER_TABLE();
1042: a1 := JTF_NUMBER_TABLE();
1043: else
1044: a0 := JTF_NUMBER_TABLE();
1045: a1 := JTF_NUMBER_TABLE();
1046: if t.count > 0 then
1047: a0.extend(t.count);
1048: a1.extend(t.count);
1049: ddindx := t.first;
1787: , p5_a73 in out nocopy DATE
1788: , p5_a74 in out nocopy NUMBER
1789: , p5_a75 in out nocopy NUMBER
1790: , x_message out nocopy VARCHAR2
1791: , p7_a0 out nocopy JTF_NUMBER_TABLE
1792: , p7_a1 out nocopy JTF_NUMBER_TABLE
1793: , p7_a2 out nocopy JTF_NUMBER_TABLE
1794: )
1795:
1788: , p5_a74 in out nocopy NUMBER
1789: , p5_a75 in out nocopy NUMBER
1790: , x_message out nocopy VARCHAR2
1791: , p7_a0 out nocopy JTF_NUMBER_TABLE
1792: , p7_a1 out nocopy JTF_NUMBER_TABLE
1793: , p7_a2 out nocopy JTF_NUMBER_TABLE
1794: )
1795:
1796: as
1789: , p5_a75 in out nocopy NUMBER
1790: , x_message out nocopy VARCHAR2
1791: , p7_a0 out nocopy JTF_NUMBER_TABLE
1792: , p7_a1 out nocopy JTF_NUMBER_TABLE
1793: , p7_a2 out nocopy JTF_NUMBER_TABLE
1794: )
1795:
1796: as
1797: ddpx_ipyv_rec okl_ins_quote_pvt.ipyv_rec_type;