18: if n=b then return a; end if;
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy ozf_disc_line_pvt.ozf_offer_line_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy ozf_disc_line_pvt.ozf_offer_line_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_100
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy ozf_disc_line_pvt.ozf_offer_line_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_VARCHAR2_TABLE_100
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy ozf_disc_line_pvt.ozf_offer_line_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_VARCHAR2_TABLE_100
29: , a7 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_VARCHAR2_TABLE_100
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_VARCHAR2_TABLE_100
31: , a9 JTF_VARCHAR2_TABLE_100
32: , a10 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_VARCHAR2_TABLE_100
30: , a8 JTF_VARCHAR2_TABLE_100
31: , a9 JTF_VARCHAR2_TABLE_100
32: , a10 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_VARCHAR2_TABLE_100
34: , a12 JTF_NUMBER_TABLE
35: , a13 JTF_VARCHAR2_TABLE_100
36: , a14 JTF_NUMBER_TABLE
37: , a15 JTF_NUMBER_TABLE
38: , a16 JTF_NUMBER_TABLE
32: , a10 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_VARCHAR2_TABLE_100
34: , a12 JTF_NUMBER_TABLE
35: , a13 JTF_VARCHAR2_TABLE_100
36: , a14 JTF_NUMBER_TABLE
37: , a15 JTF_NUMBER_TABLE
38: , a16 JTF_NUMBER_TABLE
39: , a17 JTF_NUMBER_TABLE
40: , a18 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_VARCHAR2_TABLE_100
34: , a12 JTF_NUMBER_TABLE
35: , a13 JTF_VARCHAR2_TABLE_100
36: , a14 JTF_NUMBER_TABLE
37: , a15 JTF_NUMBER_TABLE
38: , a16 JTF_NUMBER_TABLE
39: , a17 JTF_NUMBER_TABLE
40: , a18 JTF_VARCHAR2_TABLE_100
41: , a19 JTF_DATE_TABLE
34: , a12 JTF_NUMBER_TABLE
35: , a13 JTF_VARCHAR2_TABLE_100
36: , a14 JTF_NUMBER_TABLE
37: , a15 JTF_NUMBER_TABLE
38: , a16 JTF_NUMBER_TABLE
39: , a17 JTF_NUMBER_TABLE
40: , a18 JTF_VARCHAR2_TABLE_100
41: , a19 JTF_DATE_TABLE
42: , a20 JTF_DATE_TABLE
35: , a13 JTF_VARCHAR2_TABLE_100
36: , a14 JTF_NUMBER_TABLE
37: , a15 JTF_NUMBER_TABLE
38: , a16 JTF_NUMBER_TABLE
39: , a17 JTF_NUMBER_TABLE
40: , a18 JTF_VARCHAR2_TABLE_100
41: , a19 JTF_DATE_TABLE
42: , a20 JTF_DATE_TABLE
43: , a21 JTF_VARCHAR2_TABLE_100
41: , a19 JTF_DATE_TABLE
42: , a20 JTF_DATE_TABLE
43: , a21 JTF_VARCHAR2_TABLE_100
44: , a22 JTF_DATE_TABLE
45: , a23 JTF_NUMBER_TABLE
46: , a24 JTF_DATE_TABLE
47: , a25 JTF_NUMBER_TABLE
48: , a26 JTF_NUMBER_TABLE
49: , a27 JTF_NUMBER_TABLE
43: , a21 JTF_VARCHAR2_TABLE_100
44: , a22 JTF_DATE_TABLE
45: , a23 JTF_NUMBER_TABLE
46: , a24 JTF_DATE_TABLE
47: , a25 JTF_NUMBER_TABLE
48: , a26 JTF_NUMBER_TABLE
49: , a27 JTF_NUMBER_TABLE
50: , a28 JTF_VARCHAR2_TABLE_100
51: , a29 JTF_VARCHAR2_TABLE_300
44: , a22 JTF_DATE_TABLE
45: , a23 JTF_NUMBER_TABLE
46: , a24 JTF_DATE_TABLE
47: , a25 JTF_NUMBER_TABLE
48: , a26 JTF_NUMBER_TABLE
49: , a27 JTF_NUMBER_TABLE
50: , a28 JTF_VARCHAR2_TABLE_100
51: , a29 JTF_VARCHAR2_TABLE_300
52: , a30 JTF_VARCHAR2_TABLE_300
45: , a23 JTF_NUMBER_TABLE
46: , a24 JTF_DATE_TABLE
47: , a25 JTF_NUMBER_TABLE
48: , a26 JTF_NUMBER_TABLE
49: , a27 JTF_NUMBER_TABLE
50: , a28 JTF_VARCHAR2_TABLE_100
51: , a29 JTF_VARCHAR2_TABLE_300
52: , a30 JTF_VARCHAR2_TABLE_300
53: , a31 JTF_VARCHAR2_TABLE_300
62: , a40 JTF_VARCHAR2_TABLE_300
63: , a41 JTF_VARCHAR2_TABLE_300
64: , a42 JTF_VARCHAR2_TABLE_300
65: , a43 JTF_VARCHAR2_TABLE_300
66: , a44 JTF_NUMBER_TABLE
67: ) as
68: ddindx binary_integer; indx binary_integer;
69: begin
70: if a0 is not null and a0.count > 0 then
125: end loop;
126: end if;
127: end if;
128: end rosetta_table_copy_in_p2;
129: procedure rosetta_table_copy_out_p2(t ozf_disc_line_pvt.ozf_offer_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
130: , a1 out nocopy JTF_NUMBER_TABLE
131: , a2 out nocopy JTF_NUMBER_TABLE
132: , a3 out nocopy JTF_NUMBER_TABLE
133: , a4 out nocopy JTF_VARCHAR2_TABLE_100
126: end if;
127: end if;
128: end rosetta_table_copy_in_p2;
129: procedure rosetta_table_copy_out_p2(t ozf_disc_line_pvt.ozf_offer_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
130: , a1 out nocopy JTF_NUMBER_TABLE
131: , a2 out nocopy JTF_NUMBER_TABLE
132: , a3 out nocopy JTF_NUMBER_TABLE
133: , a4 out nocopy JTF_VARCHAR2_TABLE_100
134: , a5 out nocopy JTF_VARCHAR2_TABLE_100
127: end if;
128: end rosetta_table_copy_in_p2;
129: procedure rosetta_table_copy_out_p2(t ozf_disc_line_pvt.ozf_offer_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
130: , a1 out nocopy JTF_NUMBER_TABLE
131: , a2 out nocopy JTF_NUMBER_TABLE
132: , a3 out nocopy JTF_NUMBER_TABLE
133: , a4 out nocopy JTF_VARCHAR2_TABLE_100
134: , a5 out nocopy JTF_VARCHAR2_TABLE_100
135: , a6 out nocopy JTF_VARCHAR2_TABLE_100
128: end rosetta_table_copy_in_p2;
129: procedure rosetta_table_copy_out_p2(t ozf_disc_line_pvt.ozf_offer_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
130: , a1 out nocopy JTF_NUMBER_TABLE
131: , a2 out nocopy JTF_NUMBER_TABLE
132: , a3 out nocopy JTF_NUMBER_TABLE
133: , a4 out nocopy JTF_VARCHAR2_TABLE_100
134: , a5 out nocopy JTF_VARCHAR2_TABLE_100
135: , a6 out nocopy JTF_VARCHAR2_TABLE_100
136: , a7 out nocopy JTF_NUMBER_TABLE
132: , a3 out nocopy JTF_NUMBER_TABLE
133: , a4 out nocopy JTF_VARCHAR2_TABLE_100
134: , a5 out nocopy JTF_VARCHAR2_TABLE_100
135: , a6 out nocopy JTF_VARCHAR2_TABLE_100
136: , a7 out nocopy JTF_NUMBER_TABLE
137: , a8 out nocopy JTF_VARCHAR2_TABLE_100
138: , a9 out nocopy JTF_VARCHAR2_TABLE_100
139: , a10 out nocopy JTF_VARCHAR2_TABLE_100
140: , a11 out nocopy JTF_VARCHAR2_TABLE_100
137: , a8 out nocopy JTF_VARCHAR2_TABLE_100
138: , a9 out nocopy JTF_VARCHAR2_TABLE_100
139: , a10 out nocopy JTF_VARCHAR2_TABLE_100
140: , a11 out nocopy JTF_VARCHAR2_TABLE_100
141: , a12 out nocopy JTF_NUMBER_TABLE
142: , a13 out nocopy JTF_VARCHAR2_TABLE_100
143: , a14 out nocopy JTF_NUMBER_TABLE
144: , a15 out nocopy JTF_NUMBER_TABLE
145: , a16 out nocopy JTF_NUMBER_TABLE
139: , a10 out nocopy JTF_VARCHAR2_TABLE_100
140: , a11 out nocopy JTF_VARCHAR2_TABLE_100
141: , a12 out nocopy JTF_NUMBER_TABLE
142: , a13 out nocopy JTF_VARCHAR2_TABLE_100
143: , a14 out nocopy JTF_NUMBER_TABLE
144: , a15 out nocopy JTF_NUMBER_TABLE
145: , a16 out nocopy JTF_NUMBER_TABLE
146: , a17 out nocopy JTF_NUMBER_TABLE
147: , a18 out nocopy JTF_VARCHAR2_TABLE_100
140: , a11 out nocopy JTF_VARCHAR2_TABLE_100
141: , a12 out nocopy JTF_NUMBER_TABLE
142: , a13 out nocopy JTF_VARCHAR2_TABLE_100
143: , a14 out nocopy JTF_NUMBER_TABLE
144: , a15 out nocopy JTF_NUMBER_TABLE
145: , a16 out nocopy JTF_NUMBER_TABLE
146: , a17 out nocopy JTF_NUMBER_TABLE
147: , a18 out nocopy JTF_VARCHAR2_TABLE_100
148: , a19 out nocopy JTF_DATE_TABLE
141: , a12 out nocopy JTF_NUMBER_TABLE
142: , a13 out nocopy JTF_VARCHAR2_TABLE_100
143: , a14 out nocopy JTF_NUMBER_TABLE
144: , a15 out nocopy JTF_NUMBER_TABLE
145: , a16 out nocopy JTF_NUMBER_TABLE
146: , a17 out nocopy JTF_NUMBER_TABLE
147: , a18 out nocopy JTF_VARCHAR2_TABLE_100
148: , a19 out nocopy JTF_DATE_TABLE
149: , a20 out nocopy JTF_DATE_TABLE
142: , a13 out nocopy JTF_VARCHAR2_TABLE_100
143: , a14 out nocopy JTF_NUMBER_TABLE
144: , a15 out nocopy JTF_NUMBER_TABLE
145: , a16 out nocopy JTF_NUMBER_TABLE
146: , a17 out nocopy JTF_NUMBER_TABLE
147: , a18 out nocopy JTF_VARCHAR2_TABLE_100
148: , a19 out nocopy JTF_DATE_TABLE
149: , a20 out nocopy JTF_DATE_TABLE
150: , a21 out nocopy JTF_VARCHAR2_TABLE_100
148: , a19 out nocopy JTF_DATE_TABLE
149: , a20 out nocopy JTF_DATE_TABLE
150: , a21 out nocopy JTF_VARCHAR2_TABLE_100
151: , a22 out nocopy JTF_DATE_TABLE
152: , a23 out nocopy JTF_NUMBER_TABLE
153: , a24 out nocopy JTF_DATE_TABLE
154: , a25 out nocopy JTF_NUMBER_TABLE
155: , a26 out nocopy JTF_NUMBER_TABLE
156: , a27 out nocopy JTF_NUMBER_TABLE
150: , a21 out nocopy JTF_VARCHAR2_TABLE_100
151: , a22 out nocopy JTF_DATE_TABLE
152: , a23 out nocopy JTF_NUMBER_TABLE
153: , a24 out nocopy JTF_DATE_TABLE
154: , a25 out nocopy JTF_NUMBER_TABLE
155: , a26 out nocopy JTF_NUMBER_TABLE
156: , a27 out nocopy JTF_NUMBER_TABLE
157: , a28 out nocopy JTF_VARCHAR2_TABLE_100
158: , a29 out nocopy JTF_VARCHAR2_TABLE_300
151: , a22 out nocopy JTF_DATE_TABLE
152: , a23 out nocopy JTF_NUMBER_TABLE
153: , a24 out nocopy JTF_DATE_TABLE
154: , a25 out nocopy JTF_NUMBER_TABLE
155: , a26 out nocopy JTF_NUMBER_TABLE
156: , a27 out nocopy JTF_NUMBER_TABLE
157: , a28 out nocopy JTF_VARCHAR2_TABLE_100
158: , a29 out nocopy JTF_VARCHAR2_TABLE_300
159: , a30 out nocopy JTF_VARCHAR2_TABLE_300
152: , a23 out nocopy JTF_NUMBER_TABLE
153: , a24 out nocopy JTF_DATE_TABLE
154: , a25 out nocopy JTF_NUMBER_TABLE
155: , a26 out nocopy JTF_NUMBER_TABLE
156: , a27 out nocopy JTF_NUMBER_TABLE
157: , a28 out nocopy JTF_VARCHAR2_TABLE_100
158: , a29 out nocopy JTF_VARCHAR2_TABLE_300
159: , a30 out nocopy JTF_VARCHAR2_TABLE_300
160: , a31 out nocopy JTF_VARCHAR2_TABLE_300
169: , a40 out nocopy JTF_VARCHAR2_TABLE_300
170: , a41 out nocopy JTF_VARCHAR2_TABLE_300
171: , a42 out nocopy JTF_VARCHAR2_TABLE_300
172: , a43 out nocopy JTF_VARCHAR2_TABLE_300
173: , a44 out nocopy JTF_NUMBER_TABLE
174: ) as
175: ddindx binary_integer; indx binary_integer;
176: begin
177: if t is null or t.count = 0 then
174: ) as
175: ddindx binary_integer; indx binary_integer;
176: begin
177: if t is null or t.count = 0 then
178: a0 := JTF_NUMBER_TABLE();
179: a1 := JTF_NUMBER_TABLE();
180: a2 := JTF_NUMBER_TABLE();
181: a3 := JTF_NUMBER_TABLE();
182: a4 := JTF_VARCHAR2_TABLE_100();
175: ddindx binary_integer; indx binary_integer;
176: begin
177: if t is null or t.count = 0 then
178: a0 := JTF_NUMBER_TABLE();
179: a1 := JTF_NUMBER_TABLE();
180: a2 := JTF_NUMBER_TABLE();
181: a3 := JTF_NUMBER_TABLE();
182: a4 := JTF_VARCHAR2_TABLE_100();
183: a5 := JTF_VARCHAR2_TABLE_100();
176: begin
177: if t is null or t.count = 0 then
178: a0 := JTF_NUMBER_TABLE();
179: a1 := JTF_NUMBER_TABLE();
180: a2 := JTF_NUMBER_TABLE();
181: a3 := JTF_NUMBER_TABLE();
182: a4 := JTF_VARCHAR2_TABLE_100();
183: a5 := JTF_VARCHAR2_TABLE_100();
184: a6 := JTF_VARCHAR2_TABLE_100();
177: if t is null or t.count = 0 then
178: a0 := JTF_NUMBER_TABLE();
179: a1 := JTF_NUMBER_TABLE();
180: a2 := JTF_NUMBER_TABLE();
181: a3 := JTF_NUMBER_TABLE();
182: a4 := JTF_VARCHAR2_TABLE_100();
183: a5 := JTF_VARCHAR2_TABLE_100();
184: a6 := JTF_VARCHAR2_TABLE_100();
185: a7 := JTF_NUMBER_TABLE();
181: a3 := JTF_NUMBER_TABLE();
182: a4 := JTF_VARCHAR2_TABLE_100();
183: a5 := JTF_VARCHAR2_TABLE_100();
184: a6 := JTF_VARCHAR2_TABLE_100();
185: a7 := JTF_NUMBER_TABLE();
186: a8 := JTF_VARCHAR2_TABLE_100();
187: a9 := JTF_VARCHAR2_TABLE_100();
188: a10 := JTF_VARCHAR2_TABLE_100();
189: a11 := JTF_VARCHAR2_TABLE_100();
186: a8 := JTF_VARCHAR2_TABLE_100();
187: a9 := JTF_VARCHAR2_TABLE_100();
188: a10 := JTF_VARCHAR2_TABLE_100();
189: a11 := JTF_VARCHAR2_TABLE_100();
190: a12 := JTF_NUMBER_TABLE();
191: a13 := JTF_VARCHAR2_TABLE_100();
192: a14 := JTF_NUMBER_TABLE();
193: a15 := JTF_NUMBER_TABLE();
194: a16 := JTF_NUMBER_TABLE();
188: a10 := JTF_VARCHAR2_TABLE_100();
189: a11 := JTF_VARCHAR2_TABLE_100();
190: a12 := JTF_NUMBER_TABLE();
191: a13 := JTF_VARCHAR2_TABLE_100();
192: a14 := JTF_NUMBER_TABLE();
193: a15 := JTF_NUMBER_TABLE();
194: a16 := JTF_NUMBER_TABLE();
195: a17 := JTF_NUMBER_TABLE();
196: a18 := JTF_VARCHAR2_TABLE_100();
189: a11 := JTF_VARCHAR2_TABLE_100();
190: a12 := JTF_NUMBER_TABLE();
191: a13 := JTF_VARCHAR2_TABLE_100();
192: a14 := JTF_NUMBER_TABLE();
193: a15 := JTF_NUMBER_TABLE();
194: a16 := JTF_NUMBER_TABLE();
195: a17 := JTF_NUMBER_TABLE();
196: a18 := JTF_VARCHAR2_TABLE_100();
197: a19 := JTF_DATE_TABLE();
190: a12 := JTF_NUMBER_TABLE();
191: a13 := JTF_VARCHAR2_TABLE_100();
192: a14 := JTF_NUMBER_TABLE();
193: a15 := JTF_NUMBER_TABLE();
194: a16 := JTF_NUMBER_TABLE();
195: a17 := JTF_NUMBER_TABLE();
196: a18 := JTF_VARCHAR2_TABLE_100();
197: a19 := JTF_DATE_TABLE();
198: a20 := JTF_DATE_TABLE();
191: a13 := JTF_VARCHAR2_TABLE_100();
192: a14 := JTF_NUMBER_TABLE();
193: a15 := JTF_NUMBER_TABLE();
194: a16 := JTF_NUMBER_TABLE();
195: a17 := JTF_NUMBER_TABLE();
196: a18 := JTF_VARCHAR2_TABLE_100();
197: a19 := JTF_DATE_TABLE();
198: a20 := JTF_DATE_TABLE();
199: a21 := JTF_VARCHAR2_TABLE_100();
197: a19 := JTF_DATE_TABLE();
198: a20 := JTF_DATE_TABLE();
199: a21 := JTF_VARCHAR2_TABLE_100();
200: a22 := JTF_DATE_TABLE();
201: a23 := JTF_NUMBER_TABLE();
202: a24 := JTF_DATE_TABLE();
203: a25 := JTF_NUMBER_TABLE();
204: a26 := JTF_NUMBER_TABLE();
205: a27 := JTF_NUMBER_TABLE();
199: a21 := JTF_VARCHAR2_TABLE_100();
200: a22 := JTF_DATE_TABLE();
201: a23 := JTF_NUMBER_TABLE();
202: a24 := JTF_DATE_TABLE();
203: a25 := JTF_NUMBER_TABLE();
204: a26 := JTF_NUMBER_TABLE();
205: a27 := JTF_NUMBER_TABLE();
206: a28 := JTF_VARCHAR2_TABLE_100();
207: a29 := JTF_VARCHAR2_TABLE_300();
200: a22 := JTF_DATE_TABLE();
201: a23 := JTF_NUMBER_TABLE();
202: a24 := JTF_DATE_TABLE();
203: a25 := JTF_NUMBER_TABLE();
204: a26 := JTF_NUMBER_TABLE();
205: a27 := JTF_NUMBER_TABLE();
206: a28 := JTF_VARCHAR2_TABLE_100();
207: a29 := JTF_VARCHAR2_TABLE_300();
208: a30 := JTF_VARCHAR2_TABLE_300();
201: a23 := JTF_NUMBER_TABLE();
202: a24 := JTF_DATE_TABLE();
203: a25 := JTF_NUMBER_TABLE();
204: a26 := JTF_NUMBER_TABLE();
205: a27 := JTF_NUMBER_TABLE();
206: a28 := JTF_VARCHAR2_TABLE_100();
207: a29 := JTF_VARCHAR2_TABLE_300();
208: a30 := JTF_VARCHAR2_TABLE_300();
209: a31 := JTF_VARCHAR2_TABLE_300();
218: a40 := JTF_VARCHAR2_TABLE_300();
219: a41 := JTF_VARCHAR2_TABLE_300();
220: a42 := JTF_VARCHAR2_TABLE_300();
221: a43 := JTF_VARCHAR2_TABLE_300();
222: a44 := JTF_NUMBER_TABLE();
223: else
224: a0 := JTF_NUMBER_TABLE();
225: a1 := JTF_NUMBER_TABLE();
226: a2 := JTF_NUMBER_TABLE();
220: a42 := JTF_VARCHAR2_TABLE_300();
221: a43 := JTF_VARCHAR2_TABLE_300();
222: a44 := JTF_NUMBER_TABLE();
223: else
224: a0 := JTF_NUMBER_TABLE();
225: a1 := JTF_NUMBER_TABLE();
226: a2 := JTF_NUMBER_TABLE();
227: a3 := JTF_NUMBER_TABLE();
228: a4 := JTF_VARCHAR2_TABLE_100();
221: a43 := JTF_VARCHAR2_TABLE_300();
222: a44 := JTF_NUMBER_TABLE();
223: else
224: a0 := JTF_NUMBER_TABLE();
225: a1 := JTF_NUMBER_TABLE();
226: a2 := JTF_NUMBER_TABLE();
227: a3 := JTF_NUMBER_TABLE();
228: a4 := JTF_VARCHAR2_TABLE_100();
229: a5 := JTF_VARCHAR2_TABLE_100();
222: a44 := JTF_NUMBER_TABLE();
223: else
224: a0 := JTF_NUMBER_TABLE();
225: a1 := JTF_NUMBER_TABLE();
226: a2 := JTF_NUMBER_TABLE();
227: a3 := JTF_NUMBER_TABLE();
228: a4 := JTF_VARCHAR2_TABLE_100();
229: a5 := JTF_VARCHAR2_TABLE_100();
230: a6 := JTF_VARCHAR2_TABLE_100();
223: else
224: a0 := JTF_NUMBER_TABLE();
225: a1 := JTF_NUMBER_TABLE();
226: a2 := JTF_NUMBER_TABLE();
227: a3 := JTF_NUMBER_TABLE();
228: a4 := JTF_VARCHAR2_TABLE_100();
229: a5 := JTF_VARCHAR2_TABLE_100();
230: a6 := JTF_VARCHAR2_TABLE_100();
231: a7 := JTF_NUMBER_TABLE();
227: a3 := JTF_NUMBER_TABLE();
228: a4 := JTF_VARCHAR2_TABLE_100();
229: a5 := JTF_VARCHAR2_TABLE_100();
230: a6 := JTF_VARCHAR2_TABLE_100();
231: a7 := JTF_NUMBER_TABLE();
232: a8 := JTF_VARCHAR2_TABLE_100();
233: a9 := JTF_VARCHAR2_TABLE_100();
234: a10 := JTF_VARCHAR2_TABLE_100();
235: a11 := JTF_VARCHAR2_TABLE_100();
232: a8 := JTF_VARCHAR2_TABLE_100();
233: a9 := JTF_VARCHAR2_TABLE_100();
234: a10 := JTF_VARCHAR2_TABLE_100();
235: a11 := JTF_VARCHAR2_TABLE_100();
236: a12 := JTF_NUMBER_TABLE();
237: a13 := JTF_VARCHAR2_TABLE_100();
238: a14 := JTF_NUMBER_TABLE();
239: a15 := JTF_NUMBER_TABLE();
240: a16 := JTF_NUMBER_TABLE();
234: a10 := JTF_VARCHAR2_TABLE_100();
235: a11 := JTF_VARCHAR2_TABLE_100();
236: a12 := JTF_NUMBER_TABLE();
237: a13 := JTF_VARCHAR2_TABLE_100();
238: a14 := JTF_NUMBER_TABLE();
239: a15 := JTF_NUMBER_TABLE();
240: a16 := JTF_NUMBER_TABLE();
241: a17 := JTF_NUMBER_TABLE();
242: a18 := JTF_VARCHAR2_TABLE_100();
235: a11 := JTF_VARCHAR2_TABLE_100();
236: a12 := JTF_NUMBER_TABLE();
237: a13 := JTF_VARCHAR2_TABLE_100();
238: a14 := JTF_NUMBER_TABLE();
239: a15 := JTF_NUMBER_TABLE();
240: a16 := JTF_NUMBER_TABLE();
241: a17 := JTF_NUMBER_TABLE();
242: a18 := JTF_VARCHAR2_TABLE_100();
243: a19 := JTF_DATE_TABLE();
236: a12 := JTF_NUMBER_TABLE();
237: a13 := JTF_VARCHAR2_TABLE_100();
238: a14 := JTF_NUMBER_TABLE();
239: a15 := JTF_NUMBER_TABLE();
240: a16 := JTF_NUMBER_TABLE();
241: a17 := JTF_NUMBER_TABLE();
242: a18 := JTF_VARCHAR2_TABLE_100();
243: a19 := JTF_DATE_TABLE();
244: a20 := JTF_DATE_TABLE();
237: a13 := JTF_VARCHAR2_TABLE_100();
238: a14 := JTF_NUMBER_TABLE();
239: a15 := JTF_NUMBER_TABLE();
240: a16 := JTF_NUMBER_TABLE();
241: a17 := JTF_NUMBER_TABLE();
242: a18 := JTF_VARCHAR2_TABLE_100();
243: a19 := JTF_DATE_TABLE();
244: a20 := JTF_DATE_TABLE();
245: a21 := JTF_VARCHAR2_TABLE_100();
243: a19 := JTF_DATE_TABLE();
244: a20 := JTF_DATE_TABLE();
245: a21 := JTF_VARCHAR2_TABLE_100();
246: a22 := JTF_DATE_TABLE();
247: a23 := JTF_NUMBER_TABLE();
248: a24 := JTF_DATE_TABLE();
249: a25 := JTF_NUMBER_TABLE();
250: a26 := JTF_NUMBER_TABLE();
251: a27 := JTF_NUMBER_TABLE();
245: a21 := JTF_VARCHAR2_TABLE_100();
246: a22 := JTF_DATE_TABLE();
247: a23 := JTF_NUMBER_TABLE();
248: a24 := JTF_DATE_TABLE();
249: a25 := JTF_NUMBER_TABLE();
250: a26 := JTF_NUMBER_TABLE();
251: a27 := JTF_NUMBER_TABLE();
252: a28 := JTF_VARCHAR2_TABLE_100();
253: a29 := JTF_VARCHAR2_TABLE_300();
246: a22 := JTF_DATE_TABLE();
247: a23 := JTF_NUMBER_TABLE();
248: a24 := JTF_DATE_TABLE();
249: a25 := JTF_NUMBER_TABLE();
250: a26 := JTF_NUMBER_TABLE();
251: a27 := JTF_NUMBER_TABLE();
252: a28 := JTF_VARCHAR2_TABLE_100();
253: a29 := JTF_VARCHAR2_TABLE_300();
254: a30 := JTF_VARCHAR2_TABLE_300();
247: a23 := JTF_NUMBER_TABLE();
248: a24 := JTF_DATE_TABLE();
249: a25 := JTF_NUMBER_TABLE();
250: a26 := JTF_NUMBER_TABLE();
251: a27 := JTF_NUMBER_TABLE();
252: a28 := JTF_VARCHAR2_TABLE_100();
253: a29 := JTF_VARCHAR2_TABLE_300();
254: a30 := JTF_VARCHAR2_TABLE_300();
255: a31 := JTF_VARCHAR2_TABLE_300();
264: a40 := JTF_VARCHAR2_TABLE_300();
265: a41 := JTF_VARCHAR2_TABLE_300();
266: a42 := JTF_VARCHAR2_TABLE_300();
267: a43 := JTF_VARCHAR2_TABLE_300();
268: a44 := JTF_NUMBER_TABLE();
269: if t.count > 0 then
270: a0.extend(t.count);
271: a1.extend(t.count);
272: a2.extend(t.count);
369: end if;
370: end if;
371: end rosetta_table_copy_out_p2;
372:
373: procedure rosetta_table_copy_in_p6(t out nocopy ozf_disc_line_pvt.ozf_offer_tier_tbl_type, a0 JTF_NUMBER_TABLE
374: , a1 JTF_NUMBER_TABLE
375: , a2 JTF_NUMBER_TABLE
376: , a3 JTF_NUMBER_TABLE
377: , a4 JTF_NUMBER_TABLE
370: end if;
371: end rosetta_table_copy_out_p2;
372:
373: procedure rosetta_table_copy_in_p6(t out nocopy ozf_disc_line_pvt.ozf_offer_tier_tbl_type, a0 JTF_NUMBER_TABLE
374: , a1 JTF_NUMBER_TABLE
375: , a2 JTF_NUMBER_TABLE
376: , a3 JTF_NUMBER_TABLE
377: , a4 JTF_NUMBER_TABLE
378: , a5 JTF_VARCHAR2_TABLE_100
371: end rosetta_table_copy_out_p2;
372:
373: procedure rosetta_table_copy_in_p6(t out nocopy ozf_disc_line_pvt.ozf_offer_tier_tbl_type, a0 JTF_NUMBER_TABLE
374: , a1 JTF_NUMBER_TABLE
375: , a2 JTF_NUMBER_TABLE
376: , a3 JTF_NUMBER_TABLE
377: , a4 JTF_NUMBER_TABLE
378: , a5 JTF_VARCHAR2_TABLE_100
379: , a6 JTF_VARCHAR2_TABLE_100
372:
373: procedure rosetta_table_copy_in_p6(t out nocopy ozf_disc_line_pvt.ozf_offer_tier_tbl_type, a0 JTF_NUMBER_TABLE
374: , a1 JTF_NUMBER_TABLE
375: , a2 JTF_NUMBER_TABLE
376: , a3 JTF_NUMBER_TABLE
377: , a4 JTF_NUMBER_TABLE
378: , a5 JTF_VARCHAR2_TABLE_100
379: , a6 JTF_VARCHAR2_TABLE_100
380: , a7 JTF_VARCHAR2_TABLE_100
373: procedure rosetta_table_copy_in_p6(t out nocopy ozf_disc_line_pvt.ozf_offer_tier_tbl_type, a0 JTF_NUMBER_TABLE
374: , a1 JTF_NUMBER_TABLE
375: , a2 JTF_NUMBER_TABLE
376: , a3 JTF_NUMBER_TABLE
377: , a4 JTF_NUMBER_TABLE
378: , a5 JTF_VARCHAR2_TABLE_100
379: , a6 JTF_VARCHAR2_TABLE_100
380: , a7 JTF_VARCHAR2_TABLE_100
381: , a8 JTF_NUMBER_TABLE
377: , a4 JTF_NUMBER_TABLE
378: , a5 JTF_VARCHAR2_TABLE_100
379: , a6 JTF_VARCHAR2_TABLE_100
380: , a7 JTF_VARCHAR2_TABLE_100
381: , a8 JTF_NUMBER_TABLE
382: , a9 JTF_VARCHAR2_TABLE_100
383: , a10 JTF_DATE_TABLE
384: , a11 JTF_DATE_TABLE
385: , a12 JTF_VARCHAR2_TABLE_100
382: , a9 JTF_VARCHAR2_TABLE_100
383: , a10 JTF_DATE_TABLE
384: , a11 JTF_DATE_TABLE
385: , a12 JTF_VARCHAR2_TABLE_100
386: , a13 JTF_NUMBER_TABLE
387: , a14 JTF_VARCHAR2_TABLE_100
388: , a15 JTF_VARCHAR2_TABLE_300
389: , a16 JTF_VARCHAR2_TABLE_300
390: , a17 JTF_VARCHAR2_TABLE_300
446: end loop;
447: end if;
448: end if;
449: end rosetta_table_copy_in_p6;
450: procedure rosetta_table_copy_out_p6(t ozf_disc_line_pvt.ozf_offer_tier_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
451: , a1 out nocopy JTF_NUMBER_TABLE
452: , a2 out nocopy JTF_NUMBER_TABLE
453: , a3 out nocopy JTF_NUMBER_TABLE
454: , a4 out nocopy JTF_NUMBER_TABLE
447: end if;
448: end if;
449: end rosetta_table_copy_in_p6;
450: procedure rosetta_table_copy_out_p6(t ozf_disc_line_pvt.ozf_offer_tier_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
451: , a1 out nocopy JTF_NUMBER_TABLE
452: , a2 out nocopy JTF_NUMBER_TABLE
453: , a3 out nocopy JTF_NUMBER_TABLE
454: , a4 out nocopy JTF_NUMBER_TABLE
455: , a5 out nocopy JTF_VARCHAR2_TABLE_100
448: end if;
449: end rosetta_table_copy_in_p6;
450: procedure rosetta_table_copy_out_p6(t ozf_disc_line_pvt.ozf_offer_tier_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
451: , a1 out nocopy JTF_NUMBER_TABLE
452: , a2 out nocopy JTF_NUMBER_TABLE
453: , a3 out nocopy JTF_NUMBER_TABLE
454: , a4 out nocopy JTF_NUMBER_TABLE
455: , a5 out nocopy JTF_VARCHAR2_TABLE_100
456: , a6 out nocopy JTF_VARCHAR2_TABLE_100
449: end rosetta_table_copy_in_p6;
450: procedure rosetta_table_copy_out_p6(t ozf_disc_line_pvt.ozf_offer_tier_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
451: , a1 out nocopy JTF_NUMBER_TABLE
452: , a2 out nocopy JTF_NUMBER_TABLE
453: , a3 out nocopy JTF_NUMBER_TABLE
454: , a4 out nocopy JTF_NUMBER_TABLE
455: , a5 out nocopy JTF_VARCHAR2_TABLE_100
456: , a6 out nocopy JTF_VARCHAR2_TABLE_100
457: , a7 out nocopy JTF_VARCHAR2_TABLE_100
450: procedure rosetta_table_copy_out_p6(t ozf_disc_line_pvt.ozf_offer_tier_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
451: , a1 out nocopy JTF_NUMBER_TABLE
452: , a2 out nocopy JTF_NUMBER_TABLE
453: , a3 out nocopy JTF_NUMBER_TABLE
454: , a4 out nocopy JTF_NUMBER_TABLE
455: , a5 out nocopy JTF_VARCHAR2_TABLE_100
456: , a6 out nocopy JTF_VARCHAR2_TABLE_100
457: , a7 out nocopy JTF_VARCHAR2_TABLE_100
458: , a8 out nocopy JTF_NUMBER_TABLE
454: , a4 out nocopy JTF_NUMBER_TABLE
455: , a5 out nocopy JTF_VARCHAR2_TABLE_100
456: , a6 out nocopy JTF_VARCHAR2_TABLE_100
457: , a7 out nocopy JTF_VARCHAR2_TABLE_100
458: , a8 out nocopy JTF_NUMBER_TABLE
459: , a9 out nocopy JTF_VARCHAR2_TABLE_100
460: , a10 out nocopy JTF_DATE_TABLE
461: , a11 out nocopy JTF_DATE_TABLE
462: , a12 out nocopy JTF_VARCHAR2_TABLE_100
459: , a9 out nocopy JTF_VARCHAR2_TABLE_100
460: , a10 out nocopy JTF_DATE_TABLE
461: , a11 out nocopy JTF_DATE_TABLE
462: , a12 out nocopy JTF_VARCHAR2_TABLE_100
463: , a13 out nocopy JTF_NUMBER_TABLE
464: , a14 out nocopy JTF_VARCHAR2_TABLE_100
465: , a15 out nocopy JTF_VARCHAR2_TABLE_300
466: , a16 out nocopy JTF_VARCHAR2_TABLE_300
467: , a17 out nocopy JTF_VARCHAR2_TABLE_300
480: ) as
481: ddindx binary_integer; indx binary_integer;
482: begin
483: if t is null or t.count = 0 then
484: a0 := JTF_NUMBER_TABLE();
485: a1 := JTF_NUMBER_TABLE();
486: a2 := JTF_NUMBER_TABLE();
487: a3 := JTF_NUMBER_TABLE();
488: a4 := JTF_NUMBER_TABLE();
481: ddindx binary_integer; indx binary_integer;
482: begin
483: if t is null or t.count = 0 then
484: a0 := JTF_NUMBER_TABLE();
485: a1 := JTF_NUMBER_TABLE();
486: a2 := JTF_NUMBER_TABLE();
487: a3 := JTF_NUMBER_TABLE();
488: a4 := JTF_NUMBER_TABLE();
489: a5 := JTF_VARCHAR2_TABLE_100();
482: begin
483: if t is null or t.count = 0 then
484: a0 := JTF_NUMBER_TABLE();
485: a1 := JTF_NUMBER_TABLE();
486: a2 := JTF_NUMBER_TABLE();
487: a3 := JTF_NUMBER_TABLE();
488: a4 := JTF_NUMBER_TABLE();
489: a5 := JTF_VARCHAR2_TABLE_100();
490: a6 := JTF_VARCHAR2_TABLE_100();
483: if t is null or t.count = 0 then
484: a0 := JTF_NUMBER_TABLE();
485: a1 := JTF_NUMBER_TABLE();
486: a2 := JTF_NUMBER_TABLE();
487: a3 := JTF_NUMBER_TABLE();
488: a4 := JTF_NUMBER_TABLE();
489: a5 := JTF_VARCHAR2_TABLE_100();
490: a6 := JTF_VARCHAR2_TABLE_100();
491: a7 := JTF_VARCHAR2_TABLE_100();
484: a0 := JTF_NUMBER_TABLE();
485: a1 := JTF_NUMBER_TABLE();
486: a2 := JTF_NUMBER_TABLE();
487: a3 := JTF_NUMBER_TABLE();
488: a4 := JTF_NUMBER_TABLE();
489: a5 := JTF_VARCHAR2_TABLE_100();
490: a6 := JTF_VARCHAR2_TABLE_100();
491: a7 := JTF_VARCHAR2_TABLE_100();
492: a8 := JTF_NUMBER_TABLE();
488: a4 := JTF_NUMBER_TABLE();
489: a5 := JTF_VARCHAR2_TABLE_100();
490: a6 := JTF_VARCHAR2_TABLE_100();
491: a7 := JTF_VARCHAR2_TABLE_100();
492: a8 := JTF_NUMBER_TABLE();
493: a9 := JTF_VARCHAR2_TABLE_100();
494: a10 := JTF_DATE_TABLE();
495: a11 := JTF_DATE_TABLE();
496: a12 := JTF_VARCHAR2_TABLE_100();
493: a9 := JTF_VARCHAR2_TABLE_100();
494: a10 := JTF_DATE_TABLE();
495: a11 := JTF_DATE_TABLE();
496: a12 := JTF_VARCHAR2_TABLE_100();
497: a13 := JTF_NUMBER_TABLE();
498: a14 := JTF_VARCHAR2_TABLE_100();
499: a15 := JTF_VARCHAR2_TABLE_300();
500: a16 := JTF_VARCHAR2_TABLE_300();
501: a17 := JTF_VARCHAR2_TABLE_300();
511: a27 := JTF_VARCHAR2_TABLE_300();
512: a28 := JTF_VARCHAR2_TABLE_300();
513: a29 := JTF_VARCHAR2_TABLE_300();
514: else
515: a0 := JTF_NUMBER_TABLE();
516: a1 := JTF_NUMBER_TABLE();
517: a2 := JTF_NUMBER_TABLE();
518: a3 := JTF_NUMBER_TABLE();
519: a4 := JTF_NUMBER_TABLE();
512: a28 := JTF_VARCHAR2_TABLE_300();
513: a29 := JTF_VARCHAR2_TABLE_300();
514: else
515: a0 := JTF_NUMBER_TABLE();
516: a1 := JTF_NUMBER_TABLE();
517: a2 := JTF_NUMBER_TABLE();
518: a3 := JTF_NUMBER_TABLE();
519: a4 := JTF_NUMBER_TABLE();
520: a5 := JTF_VARCHAR2_TABLE_100();
513: a29 := JTF_VARCHAR2_TABLE_300();
514: else
515: a0 := JTF_NUMBER_TABLE();
516: a1 := JTF_NUMBER_TABLE();
517: a2 := JTF_NUMBER_TABLE();
518: a3 := JTF_NUMBER_TABLE();
519: a4 := JTF_NUMBER_TABLE();
520: a5 := JTF_VARCHAR2_TABLE_100();
521: a6 := JTF_VARCHAR2_TABLE_100();
514: else
515: a0 := JTF_NUMBER_TABLE();
516: a1 := JTF_NUMBER_TABLE();
517: a2 := JTF_NUMBER_TABLE();
518: a3 := JTF_NUMBER_TABLE();
519: a4 := JTF_NUMBER_TABLE();
520: a5 := JTF_VARCHAR2_TABLE_100();
521: a6 := JTF_VARCHAR2_TABLE_100();
522: a7 := JTF_VARCHAR2_TABLE_100();
515: a0 := JTF_NUMBER_TABLE();
516: a1 := JTF_NUMBER_TABLE();
517: a2 := JTF_NUMBER_TABLE();
518: a3 := JTF_NUMBER_TABLE();
519: a4 := JTF_NUMBER_TABLE();
520: a5 := JTF_VARCHAR2_TABLE_100();
521: a6 := JTF_VARCHAR2_TABLE_100();
522: a7 := JTF_VARCHAR2_TABLE_100();
523: a8 := JTF_NUMBER_TABLE();
519: a4 := JTF_NUMBER_TABLE();
520: a5 := JTF_VARCHAR2_TABLE_100();
521: a6 := JTF_VARCHAR2_TABLE_100();
522: a7 := JTF_VARCHAR2_TABLE_100();
523: a8 := JTF_NUMBER_TABLE();
524: a9 := JTF_VARCHAR2_TABLE_100();
525: a10 := JTF_DATE_TABLE();
526: a11 := JTF_DATE_TABLE();
527: a12 := JTF_VARCHAR2_TABLE_100();
524: a9 := JTF_VARCHAR2_TABLE_100();
525: a10 := JTF_DATE_TABLE();
526: a11 := JTF_DATE_TABLE();
527: a12 := JTF_VARCHAR2_TABLE_100();
528: a13 := JTF_NUMBER_TABLE();
529: a14 := JTF_VARCHAR2_TABLE_100();
530: a15 := JTF_VARCHAR2_TABLE_300();
531: a16 := JTF_VARCHAR2_TABLE_300();
532: a17 := JTF_VARCHAR2_TABLE_300();
615: end if;
616: end if;
617: end rosetta_table_copy_out_p6;
618:
619: procedure rosetta_table_copy_in_p9(t out nocopy ozf_disc_line_pvt.ozf_discount_line_tbl, a0 JTF_NUMBER_TABLE
620: , a1 JTF_NUMBER_TABLE
621: , a2 JTF_NUMBER_TABLE
622: , a3 JTF_NUMBER_TABLE
623: , a4 JTF_VARCHAR2_TABLE_100
616: end if;
617: end rosetta_table_copy_out_p6;
618:
619: procedure rosetta_table_copy_in_p9(t out nocopy ozf_disc_line_pvt.ozf_discount_line_tbl, a0 JTF_NUMBER_TABLE
620: , a1 JTF_NUMBER_TABLE
621: , a2 JTF_NUMBER_TABLE
622: , a3 JTF_NUMBER_TABLE
623: , a4 JTF_VARCHAR2_TABLE_100
624: , a5 JTF_VARCHAR2_TABLE_100
617: end rosetta_table_copy_out_p6;
618:
619: procedure rosetta_table_copy_in_p9(t out nocopy ozf_disc_line_pvt.ozf_discount_line_tbl, a0 JTF_NUMBER_TABLE
620: , a1 JTF_NUMBER_TABLE
621: , a2 JTF_NUMBER_TABLE
622: , a3 JTF_NUMBER_TABLE
623: , a4 JTF_VARCHAR2_TABLE_100
624: , a5 JTF_VARCHAR2_TABLE_100
625: , a6 JTF_VARCHAR2_TABLE_100
618:
619: procedure rosetta_table_copy_in_p9(t out nocopy ozf_disc_line_pvt.ozf_discount_line_tbl, a0 JTF_NUMBER_TABLE
620: , a1 JTF_NUMBER_TABLE
621: , a2 JTF_NUMBER_TABLE
622: , a3 JTF_NUMBER_TABLE
623: , a4 JTF_VARCHAR2_TABLE_100
624: , a5 JTF_VARCHAR2_TABLE_100
625: , a6 JTF_VARCHAR2_TABLE_100
626: , a7 JTF_NUMBER_TABLE
622: , a3 JTF_NUMBER_TABLE
623: , a4 JTF_VARCHAR2_TABLE_100
624: , a5 JTF_VARCHAR2_TABLE_100
625: , a6 JTF_VARCHAR2_TABLE_100
626: , a7 JTF_NUMBER_TABLE
627: , a8 JTF_VARCHAR2_TABLE_100
628: , a9 JTF_VARCHAR2_TABLE_100
629: , a10 JTF_VARCHAR2_TABLE_100
630: , a11 JTF_VARCHAR2_TABLE_100
627: , a8 JTF_VARCHAR2_TABLE_100
628: , a9 JTF_VARCHAR2_TABLE_100
629: , a10 JTF_VARCHAR2_TABLE_100
630: , a11 JTF_VARCHAR2_TABLE_100
631: , a12 JTF_NUMBER_TABLE
632: , a13 JTF_VARCHAR2_TABLE_100
633: , a14 JTF_NUMBER_TABLE
634: , a15 JTF_NUMBER_TABLE
635: , a16 JTF_NUMBER_TABLE
629: , a10 JTF_VARCHAR2_TABLE_100
630: , a11 JTF_VARCHAR2_TABLE_100
631: , a12 JTF_NUMBER_TABLE
632: , a13 JTF_VARCHAR2_TABLE_100
633: , a14 JTF_NUMBER_TABLE
634: , a15 JTF_NUMBER_TABLE
635: , a16 JTF_NUMBER_TABLE
636: , a17 JTF_NUMBER_TABLE
637: , a18 JTF_VARCHAR2_TABLE_100
630: , a11 JTF_VARCHAR2_TABLE_100
631: , a12 JTF_NUMBER_TABLE
632: , a13 JTF_VARCHAR2_TABLE_100
633: , a14 JTF_NUMBER_TABLE
634: , a15 JTF_NUMBER_TABLE
635: , a16 JTF_NUMBER_TABLE
636: , a17 JTF_NUMBER_TABLE
637: , a18 JTF_VARCHAR2_TABLE_100
638: , a19 JTF_DATE_TABLE
631: , a12 JTF_NUMBER_TABLE
632: , a13 JTF_VARCHAR2_TABLE_100
633: , a14 JTF_NUMBER_TABLE
634: , a15 JTF_NUMBER_TABLE
635: , a16 JTF_NUMBER_TABLE
636: , a17 JTF_NUMBER_TABLE
637: , a18 JTF_VARCHAR2_TABLE_100
638: , a19 JTF_DATE_TABLE
639: , a20 JTF_DATE_TABLE
632: , a13 JTF_VARCHAR2_TABLE_100
633: , a14 JTF_NUMBER_TABLE
634: , a15 JTF_NUMBER_TABLE
635: , a16 JTF_NUMBER_TABLE
636: , a17 JTF_NUMBER_TABLE
637: , a18 JTF_VARCHAR2_TABLE_100
638: , a19 JTF_DATE_TABLE
639: , a20 JTF_DATE_TABLE
640: , a21 JTF_VARCHAR2_TABLE_100
638: , a19 JTF_DATE_TABLE
639: , a20 JTF_DATE_TABLE
640: , a21 JTF_VARCHAR2_TABLE_100
641: , a22 JTF_DATE_TABLE
642: , a23 JTF_NUMBER_TABLE
643: , a24 JTF_DATE_TABLE
644: , a25 JTF_NUMBER_TABLE
645: , a26 JTF_NUMBER_TABLE
646: , a27 JTF_NUMBER_TABLE
640: , a21 JTF_VARCHAR2_TABLE_100
641: , a22 JTF_DATE_TABLE
642: , a23 JTF_NUMBER_TABLE
643: , a24 JTF_DATE_TABLE
644: , a25 JTF_NUMBER_TABLE
645: , a26 JTF_NUMBER_TABLE
646: , a27 JTF_NUMBER_TABLE
647: , a28 JTF_NUMBER_TABLE
648: , a29 JTF_NUMBER_TABLE
641: , a22 JTF_DATE_TABLE
642: , a23 JTF_NUMBER_TABLE
643: , a24 JTF_DATE_TABLE
644: , a25 JTF_NUMBER_TABLE
645: , a26 JTF_NUMBER_TABLE
646: , a27 JTF_NUMBER_TABLE
647: , a28 JTF_NUMBER_TABLE
648: , a29 JTF_NUMBER_TABLE
649: , a30 JTF_NUMBER_TABLE
642: , a23 JTF_NUMBER_TABLE
643: , a24 JTF_DATE_TABLE
644: , a25 JTF_NUMBER_TABLE
645: , a26 JTF_NUMBER_TABLE
646: , a27 JTF_NUMBER_TABLE
647: , a28 JTF_NUMBER_TABLE
648: , a29 JTF_NUMBER_TABLE
649: , a30 JTF_NUMBER_TABLE
650: , a31 JTF_VARCHAR2_TABLE_100
643: , a24 JTF_DATE_TABLE
644: , a25 JTF_NUMBER_TABLE
645: , a26 JTF_NUMBER_TABLE
646: , a27 JTF_NUMBER_TABLE
647: , a28 JTF_NUMBER_TABLE
648: , a29 JTF_NUMBER_TABLE
649: , a30 JTF_NUMBER_TABLE
650: , a31 JTF_VARCHAR2_TABLE_100
651: , a32 JTF_NUMBER_TABLE
644: , a25 JTF_NUMBER_TABLE
645: , a26 JTF_NUMBER_TABLE
646: , a27 JTF_NUMBER_TABLE
647: , a28 JTF_NUMBER_TABLE
648: , a29 JTF_NUMBER_TABLE
649: , a30 JTF_NUMBER_TABLE
650: , a31 JTF_VARCHAR2_TABLE_100
651: , a32 JTF_NUMBER_TABLE
652: , a33 JTF_VARCHAR2_TABLE_100
645: , a26 JTF_NUMBER_TABLE
646: , a27 JTF_NUMBER_TABLE
647: , a28 JTF_NUMBER_TABLE
648: , a29 JTF_NUMBER_TABLE
649: , a30 JTF_NUMBER_TABLE
650: , a31 JTF_VARCHAR2_TABLE_100
651: , a32 JTF_NUMBER_TABLE
652: , a33 JTF_VARCHAR2_TABLE_100
653: , a34 JTF_VARCHAR2_TABLE_100
647: , a28 JTF_NUMBER_TABLE
648: , a29 JTF_NUMBER_TABLE
649: , a30 JTF_NUMBER_TABLE
650: , a31 JTF_VARCHAR2_TABLE_100
651: , a32 JTF_NUMBER_TABLE
652: , a33 JTF_VARCHAR2_TABLE_100
653: , a34 JTF_VARCHAR2_TABLE_100
654: , a35 JTF_VARCHAR2_TABLE_300
655: , a36 JTF_VARCHAR2_TABLE_300
732: end loop;
733: end if;
734: end if;
735: end rosetta_table_copy_in_p9;
736: procedure rosetta_table_copy_out_p9(t ozf_disc_line_pvt.ozf_discount_line_tbl, a0 out nocopy JTF_NUMBER_TABLE
737: , a1 out nocopy JTF_NUMBER_TABLE
738: , a2 out nocopy JTF_NUMBER_TABLE
739: , a3 out nocopy JTF_NUMBER_TABLE
740: , a4 out nocopy JTF_VARCHAR2_TABLE_100
733: end if;
734: end if;
735: end rosetta_table_copy_in_p9;
736: procedure rosetta_table_copy_out_p9(t ozf_disc_line_pvt.ozf_discount_line_tbl, a0 out nocopy JTF_NUMBER_TABLE
737: , a1 out nocopy JTF_NUMBER_TABLE
738: , a2 out nocopy JTF_NUMBER_TABLE
739: , a3 out nocopy JTF_NUMBER_TABLE
740: , a4 out nocopy JTF_VARCHAR2_TABLE_100
741: , a5 out nocopy JTF_VARCHAR2_TABLE_100
734: end if;
735: end rosetta_table_copy_in_p9;
736: procedure rosetta_table_copy_out_p9(t ozf_disc_line_pvt.ozf_discount_line_tbl, a0 out nocopy JTF_NUMBER_TABLE
737: , a1 out nocopy JTF_NUMBER_TABLE
738: , a2 out nocopy JTF_NUMBER_TABLE
739: , a3 out nocopy JTF_NUMBER_TABLE
740: , a4 out nocopy JTF_VARCHAR2_TABLE_100
741: , a5 out nocopy JTF_VARCHAR2_TABLE_100
742: , a6 out nocopy JTF_VARCHAR2_TABLE_100
735: end rosetta_table_copy_in_p9;
736: procedure rosetta_table_copy_out_p9(t ozf_disc_line_pvt.ozf_discount_line_tbl, a0 out nocopy JTF_NUMBER_TABLE
737: , a1 out nocopy JTF_NUMBER_TABLE
738: , a2 out nocopy JTF_NUMBER_TABLE
739: , a3 out nocopy JTF_NUMBER_TABLE
740: , a4 out nocopy JTF_VARCHAR2_TABLE_100
741: , a5 out nocopy JTF_VARCHAR2_TABLE_100
742: , a6 out nocopy JTF_VARCHAR2_TABLE_100
743: , a7 out nocopy JTF_NUMBER_TABLE
739: , a3 out nocopy JTF_NUMBER_TABLE
740: , a4 out nocopy JTF_VARCHAR2_TABLE_100
741: , a5 out nocopy JTF_VARCHAR2_TABLE_100
742: , a6 out nocopy JTF_VARCHAR2_TABLE_100
743: , a7 out nocopy JTF_NUMBER_TABLE
744: , a8 out nocopy JTF_VARCHAR2_TABLE_100
745: , a9 out nocopy JTF_VARCHAR2_TABLE_100
746: , a10 out nocopy JTF_VARCHAR2_TABLE_100
747: , a11 out nocopy JTF_VARCHAR2_TABLE_100
744: , a8 out nocopy JTF_VARCHAR2_TABLE_100
745: , a9 out nocopy JTF_VARCHAR2_TABLE_100
746: , a10 out nocopy JTF_VARCHAR2_TABLE_100
747: , a11 out nocopy JTF_VARCHAR2_TABLE_100
748: , a12 out nocopy JTF_NUMBER_TABLE
749: , a13 out nocopy JTF_VARCHAR2_TABLE_100
750: , a14 out nocopy JTF_NUMBER_TABLE
751: , a15 out nocopy JTF_NUMBER_TABLE
752: , a16 out nocopy JTF_NUMBER_TABLE
746: , a10 out nocopy JTF_VARCHAR2_TABLE_100
747: , a11 out nocopy JTF_VARCHAR2_TABLE_100
748: , a12 out nocopy JTF_NUMBER_TABLE
749: , a13 out nocopy JTF_VARCHAR2_TABLE_100
750: , a14 out nocopy JTF_NUMBER_TABLE
751: , a15 out nocopy JTF_NUMBER_TABLE
752: , a16 out nocopy JTF_NUMBER_TABLE
753: , a17 out nocopy JTF_NUMBER_TABLE
754: , a18 out nocopy JTF_VARCHAR2_TABLE_100
747: , a11 out nocopy JTF_VARCHAR2_TABLE_100
748: , a12 out nocopy JTF_NUMBER_TABLE
749: , a13 out nocopy JTF_VARCHAR2_TABLE_100
750: , a14 out nocopy JTF_NUMBER_TABLE
751: , a15 out nocopy JTF_NUMBER_TABLE
752: , a16 out nocopy JTF_NUMBER_TABLE
753: , a17 out nocopy JTF_NUMBER_TABLE
754: , a18 out nocopy JTF_VARCHAR2_TABLE_100
755: , a19 out nocopy JTF_DATE_TABLE
748: , a12 out nocopy JTF_NUMBER_TABLE
749: , a13 out nocopy JTF_VARCHAR2_TABLE_100
750: , a14 out nocopy JTF_NUMBER_TABLE
751: , a15 out nocopy JTF_NUMBER_TABLE
752: , a16 out nocopy JTF_NUMBER_TABLE
753: , a17 out nocopy JTF_NUMBER_TABLE
754: , a18 out nocopy JTF_VARCHAR2_TABLE_100
755: , a19 out nocopy JTF_DATE_TABLE
756: , a20 out nocopy JTF_DATE_TABLE
749: , a13 out nocopy JTF_VARCHAR2_TABLE_100
750: , a14 out nocopy JTF_NUMBER_TABLE
751: , a15 out nocopy JTF_NUMBER_TABLE
752: , a16 out nocopy JTF_NUMBER_TABLE
753: , a17 out nocopy JTF_NUMBER_TABLE
754: , a18 out nocopy JTF_VARCHAR2_TABLE_100
755: , a19 out nocopy JTF_DATE_TABLE
756: , a20 out nocopy JTF_DATE_TABLE
757: , a21 out nocopy JTF_VARCHAR2_TABLE_100
755: , a19 out nocopy JTF_DATE_TABLE
756: , a20 out nocopy JTF_DATE_TABLE
757: , a21 out nocopy JTF_VARCHAR2_TABLE_100
758: , a22 out nocopy JTF_DATE_TABLE
759: , a23 out nocopy JTF_NUMBER_TABLE
760: , a24 out nocopy JTF_DATE_TABLE
761: , a25 out nocopy JTF_NUMBER_TABLE
762: , a26 out nocopy JTF_NUMBER_TABLE
763: , a27 out nocopy JTF_NUMBER_TABLE
757: , a21 out nocopy JTF_VARCHAR2_TABLE_100
758: , a22 out nocopy JTF_DATE_TABLE
759: , a23 out nocopy JTF_NUMBER_TABLE
760: , a24 out nocopy JTF_DATE_TABLE
761: , a25 out nocopy JTF_NUMBER_TABLE
762: , a26 out nocopy JTF_NUMBER_TABLE
763: , a27 out nocopy JTF_NUMBER_TABLE
764: , a28 out nocopy JTF_NUMBER_TABLE
765: , a29 out nocopy JTF_NUMBER_TABLE
758: , a22 out nocopy JTF_DATE_TABLE
759: , a23 out nocopy JTF_NUMBER_TABLE
760: , a24 out nocopy JTF_DATE_TABLE
761: , a25 out nocopy JTF_NUMBER_TABLE
762: , a26 out nocopy JTF_NUMBER_TABLE
763: , a27 out nocopy JTF_NUMBER_TABLE
764: , a28 out nocopy JTF_NUMBER_TABLE
765: , a29 out nocopy JTF_NUMBER_TABLE
766: , a30 out nocopy JTF_NUMBER_TABLE
759: , a23 out nocopy JTF_NUMBER_TABLE
760: , a24 out nocopy JTF_DATE_TABLE
761: , a25 out nocopy JTF_NUMBER_TABLE
762: , a26 out nocopy JTF_NUMBER_TABLE
763: , a27 out nocopy JTF_NUMBER_TABLE
764: , a28 out nocopy JTF_NUMBER_TABLE
765: , a29 out nocopy JTF_NUMBER_TABLE
766: , a30 out nocopy JTF_NUMBER_TABLE
767: , a31 out nocopy JTF_VARCHAR2_TABLE_100
760: , a24 out nocopy JTF_DATE_TABLE
761: , a25 out nocopy JTF_NUMBER_TABLE
762: , a26 out nocopy JTF_NUMBER_TABLE
763: , a27 out nocopy JTF_NUMBER_TABLE
764: , a28 out nocopy JTF_NUMBER_TABLE
765: , a29 out nocopy JTF_NUMBER_TABLE
766: , a30 out nocopy JTF_NUMBER_TABLE
767: , a31 out nocopy JTF_VARCHAR2_TABLE_100
768: , a32 out nocopy JTF_NUMBER_TABLE
761: , a25 out nocopy JTF_NUMBER_TABLE
762: , a26 out nocopy JTF_NUMBER_TABLE
763: , a27 out nocopy JTF_NUMBER_TABLE
764: , a28 out nocopy JTF_NUMBER_TABLE
765: , a29 out nocopy JTF_NUMBER_TABLE
766: , a30 out nocopy JTF_NUMBER_TABLE
767: , a31 out nocopy JTF_VARCHAR2_TABLE_100
768: , a32 out nocopy JTF_NUMBER_TABLE
769: , a33 out nocopy JTF_VARCHAR2_TABLE_100
762: , a26 out nocopy JTF_NUMBER_TABLE
763: , a27 out nocopy JTF_NUMBER_TABLE
764: , a28 out nocopy JTF_NUMBER_TABLE
765: , a29 out nocopy JTF_NUMBER_TABLE
766: , a30 out nocopy JTF_NUMBER_TABLE
767: , a31 out nocopy JTF_VARCHAR2_TABLE_100
768: , a32 out nocopy JTF_NUMBER_TABLE
769: , a33 out nocopy JTF_VARCHAR2_TABLE_100
770: , a34 out nocopy JTF_VARCHAR2_TABLE_100
764: , a28 out nocopy JTF_NUMBER_TABLE
765: , a29 out nocopy JTF_NUMBER_TABLE
766: , a30 out nocopy JTF_NUMBER_TABLE
767: , a31 out nocopy JTF_VARCHAR2_TABLE_100
768: , a32 out nocopy JTF_NUMBER_TABLE
769: , a33 out nocopy JTF_VARCHAR2_TABLE_100
770: , a34 out nocopy JTF_VARCHAR2_TABLE_100
771: , a35 out nocopy JTF_VARCHAR2_TABLE_300
772: , a36 out nocopy JTF_VARCHAR2_TABLE_300
786: ) as
787: ddindx binary_integer; indx binary_integer;
788: begin
789: if t is null or t.count = 0 then
790: a0 := JTF_NUMBER_TABLE();
791: a1 := JTF_NUMBER_TABLE();
792: a2 := JTF_NUMBER_TABLE();
793: a3 := JTF_NUMBER_TABLE();
794: a4 := JTF_VARCHAR2_TABLE_100();
787: ddindx binary_integer; indx binary_integer;
788: begin
789: if t is null or t.count = 0 then
790: a0 := JTF_NUMBER_TABLE();
791: a1 := JTF_NUMBER_TABLE();
792: a2 := JTF_NUMBER_TABLE();
793: a3 := JTF_NUMBER_TABLE();
794: a4 := JTF_VARCHAR2_TABLE_100();
795: a5 := JTF_VARCHAR2_TABLE_100();
788: begin
789: if t is null or t.count = 0 then
790: a0 := JTF_NUMBER_TABLE();
791: a1 := JTF_NUMBER_TABLE();
792: a2 := JTF_NUMBER_TABLE();
793: a3 := JTF_NUMBER_TABLE();
794: a4 := JTF_VARCHAR2_TABLE_100();
795: a5 := JTF_VARCHAR2_TABLE_100();
796: a6 := JTF_VARCHAR2_TABLE_100();
789: if t is null or t.count = 0 then
790: a0 := JTF_NUMBER_TABLE();
791: a1 := JTF_NUMBER_TABLE();
792: a2 := JTF_NUMBER_TABLE();
793: a3 := JTF_NUMBER_TABLE();
794: a4 := JTF_VARCHAR2_TABLE_100();
795: a5 := JTF_VARCHAR2_TABLE_100();
796: a6 := JTF_VARCHAR2_TABLE_100();
797: a7 := JTF_NUMBER_TABLE();
793: a3 := JTF_NUMBER_TABLE();
794: a4 := JTF_VARCHAR2_TABLE_100();
795: a5 := JTF_VARCHAR2_TABLE_100();
796: a6 := JTF_VARCHAR2_TABLE_100();
797: a7 := JTF_NUMBER_TABLE();
798: a8 := JTF_VARCHAR2_TABLE_100();
799: a9 := JTF_VARCHAR2_TABLE_100();
800: a10 := JTF_VARCHAR2_TABLE_100();
801: a11 := JTF_VARCHAR2_TABLE_100();
798: a8 := JTF_VARCHAR2_TABLE_100();
799: a9 := JTF_VARCHAR2_TABLE_100();
800: a10 := JTF_VARCHAR2_TABLE_100();
801: a11 := JTF_VARCHAR2_TABLE_100();
802: a12 := JTF_NUMBER_TABLE();
803: a13 := JTF_VARCHAR2_TABLE_100();
804: a14 := JTF_NUMBER_TABLE();
805: a15 := JTF_NUMBER_TABLE();
806: a16 := JTF_NUMBER_TABLE();
800: a10 := JTF_VARCHAR2_TABLE_100();
801: a11 := JTF_VARCHAR2_TABLE_100();
802: a12 := JTF_NUMBER_TABLE();
803: a13 := JTF_VARCHAR2_TABLE_100();
804: a14 := JTF_NUMBER_TABLE();
805: a15 := JTF_NUMBER_TABLE();
806: a16 := JTF_NUMBER_TABLE();
807: a17 := JTF_NUMBER_TABLE();
808: a18 := JTF_VARCHAR2_TABLE_100();
801: a11 := JTF_VARCHAR2_TABLE_100();
802: a12 := JTF_NUMBER_TABLE();
803: a13 := JTF_VARCHAR2_TABLE_100();
804: a14 := JTF_NUMBER_TABLE();
805: a15 := JTF_NUMBER_TABLE();
806: a16 := JTF_NUMBER_TABLE();
807: a17 := JTF_NUMBER_TABLE();
808: a18 := JTF_VARCHAR2_TABLE_100();
809: a19 := JTF_DATE_TABLE();
802: a12 := JTF_NUMBER_TABLE();
803: a13 := JTF_VARCHAR2_TABLE_100();
804: a14 := JTF_NUMBER_TABLE();
805: a15 := JTF_NUMBER_TABLE();
806: a16 := JTF_NUMBER_TABLE();
807: a17 := JTF_NUMBER_TABLE();
808: a18 := JTF_VARCHAR2_TABLE_100();
809: a19 := JTF_DATE_TABLE();
810: a20 := JTF_DATE_TABLE();
803: a13 := JTF_VARCHAR2_TABLE_100();
804: a14 := JTF_NUMBER_TABLE();
805: a15 := JTF_NUMBER_TABLE();
806: a16 := JTF_NUMBER_TABLE();
807: a17 := JTF_NUMBER_TABLE();
808: a18 := JTF_VARCHAR2_TABLE_100();
809: a19 := JTF_DATE_TABLE();
810: a20 := JTF_DATE_TABLE();
811: a21 := JTF_VARCHAR2_TABLE_100();
809: a19 := JTF_DATE_TABLE();
810: a20 := JTF_DATE_TABLE();
811: a21 := JTF_VARCHAR2_TABLE_100();
812: a22 := JTF_DATE_TABLE();
813: a23 := JTF_NUMBER_TABLE();
814: a24 := JTF_DATE_TABLE();
815: a25 := JTF_NUMBER_TABLE();
816: a26 := JTF_NUMBER_TABLE();
817: a27 := JTF_NUMBER_TABLE();
811: a21 := JTF_VARCHAR2_TABLE_100();
812: a22 := JTF_DATE_TABLE();
813: a23 := JTF_NUMBER_TABLE();
814: a24 := JTF_DATE_TABLE();
815: a25 := JTF_NUMBER_TABLE();
816: a26 := JTF_NUMBER_TABLE();
817: a27 := JTF_NUMBER_TABLE();
818: a28 := JTF_NUMBER_TABLE();
819: a29 := JTF_NUMBER_TABLE();
812: a22 := JTF_DATE_TABLE();
813: a23 := JTF_NUMBER_TABLE();
814: a24 := JTF_DATE_TABLE();
815: a25 := JTF_NUMBER_TABLE();
816: a26 := JTF_NUMBER_TABLE();
817: a27 := JTF_NUMBER_TABLE();
818: a28 := JTF_NUMBER_TABLE();
819: a29 := JTF_NUMBER_TABLE();
820: a30 := JTF_NUMBER_TABLE();
813: a23 := JTF_NUMBER_TABLE();
814: a24 := JTF_DATE_TABLE();
815: a25 := JTF_NUMBER_TABLE();
816: a26 := JTF_NUMBER_TABLE();
817: a27 := JTF_NUMBER_TABLE();
818: a28 := JTF_NUMBER_TABLE();
819: a29 := JTF_NUMBER_TABLE();
820: a30 := JTF_NUMBER_TABLE();
821: a31 := JTF_VARCHAR2_TABLE_100();
814: a24 := JTF_DATE_TABLE();
815: a25 := JTF_NUMBER_TABLE();
816: a26 := JTF_NUMBER_TABLE();
817: a27 := JTF_NUMBER_TABLE();
818: a28 := JTF_NUMBER_TABLE();
819: a29 := JTF_NUMBER_TABLE();
820: a30 := JTF_NUMBER_TABLE();
821: a31 := JTF_VARCHAR2_TABLE_100();
822: a32 := JTF_NUMBER_TABLE();
815: a25 := JTF_NUMBER_TABLE();
816: a26 := JTF_NUMBER_TABLE();
817: a27 := JTF_NUMBER_TABLE();
818: a28 := JTF_NUMBER_TABLE();
819: a29 := JTF_NUMBER_TABLE();
820: a30 := JTF_NUMBER_TABLE();
821: a31 := JTF_VARCHAR2_TABLE_100();
822: a32 := JTF_NUMBER_TABLE();
823: a33 := JTF_VARCHAR2_TABLE_100();
816: a26 := JTF_NUMBER_TABLE();
817: a27 := JTF_NUMBER_TABLE();
818: a28 := JTF_NUMBER_TABLE();
819: a29 := JTF_NUMBER_TABLE();
820: a30 := JTF_NUMBER_TABLE();
821: a31 := JTF_VARCHAR2_TABLE_100();
822: a32 := JTF_NUMBER_TABLE();
823: a33 := JTF_VARCHAR2_TABLE_100();
824: a34 := JTF_VARCHAR2_TABLE_100();
818: a28 := JTF_NUMBER_TABLE();
819: a29 := JTF_NUMBER_TABLE();
820: a30 := JTF_NUMBER_TABLE();
821: a31 := JTF_VARCHAR2_TABLE_100();
822: a32 := JTF_NUMBER_TABLE();
823: a33 := JTF_VARCHAR2_TABLE_100();
824: a34 := JTF_VARCHAR2_TABLE_100();
825: a35 := JTF_VARCHAR2_TABLE_300();
826: a36 := JTF_VARCHAR2_TABLE_300();
837: a47 := JTF_VARCHAR2_TABLE_300();
838: a48 := JTF_VARCHAR2_TABLE_300();
839: a49 := JTF_VARCHAR2_TABLE_300();
840: else
841: a0 := JTF_NUMBER_TABLE();
842: a1 := JTF_NUMBER_TABLE();
843: a2 := JTF_NUMBER_TABLE();
844: a3 := JTF_NUMBER_TABLE();
845: a4 := JTF_VARCHAR2_TABLE_100();
838: a48 := JTF_VARCHAR2_TABLE_300();
839: a49 := JTF_VARCHAR2_TABLE_300();
840: else
841: a0 := JTF_NUMBER_TABLE();
842: a1 := JTF_NUMBER_TABLE();
843: a2 := JTF_NUMBER_TABLE();
844: a3 := JTF_NUMBER_TABLE();
845: a4 := JTF_VARCHAR2_TABLE_100();
846: a5 := JTF_VARCHAR2_TABLE_100();
839: a49 := JTF_VARCHAR2_TABLE_300();
840: else
841: a0 := JTF_NUMBER_TABLE();
842: a1 := JTF_NUMBER_TABLE();
843: a2 := JTF_NUMBER_TABLE();
844: a3 := JTF_NUMBER_TABLE();
845: a4 := JTF_VARCHAR2_TABLE_100();
846: a5 := JTF_VARCHAR2_TABLE_100();
847: a6 := JTF_VARCHAR2_TABLE_100();
840: else
841: a0 := JTF_NUMBER_TABLE();
842: a1 := JTF_NUMBER_TABLE();
843: a2 := JTF_NUMBER_TABLE();
844: a3 := JTF_NUMBER_TABLE();
845: a4 := JTF_VARCHAR2_TABLE_100();
846: a5 := JTF_VARCHAR2_TABLE_100();
847: a6 := JTF_VARCHAR2_TABLE_100();
848: a7 := JTF_NUMBER_TABLE();
844: a3 := JTF_NUMBER_TABLE();
845: a4 := JTF_VARCHAR2_TABLE_100();
846: a5 := JTF_VARCHAR2_TABLE_100();
847: a6 := JTF_VARCHAR2_TABLE_100();
848: a7 := JTF_NUMBER_TABLE();
849: a8 := JTF_VARCHAR2_TABLE_100();
850: a9 := JTF_VARCHAR2_TABLE_100();
851: a10 := JTF_VARCHAR2_TABLE_100();
852: a11 := JTF_VARCHAR2_TABLE_100();
849: a8 := JTF_VARCHAR2_TABLE_100();
850: a9 := JTF_VARCHAR2_TABLE_100();
851: a10 := JTF_VARCHAR2_TABLE_100();
852: a11 := JTF_VARCHAR2_TABLE_100();
853: a12 := JTF_NUMBER_TABLE();
854: a13 := JTF_VARCHAR2_TABLE_100();
855: a14 := JTF_NUMBER_TABLE();
856: a15 := JTF_NUMBER_TABLE();
857: a16 := JTF_NUMBER_TABLE();
851: a10 := JTF_VARCHAR2_TABLE_100();
852: a11 := JTF_VARCHAR2_TABLE_100();
853: a12 := JTF_NUMBER_TABLE();
854: a13 := JTF_VARCHAR2_TABLE_100();
855: a14 := JTF_NUMBER_TABLE();
856: a15 := JTF_NUMBER_TABLE();
857: a16 := JTF_NUMBER_TABLE();
858: a17 := JTF_NUMBER_TABLE();
859: a18 := JTF_VARCHAR2_TABLE_100();
852: a11 := JTF_VARCHAR2_TABLE_100();
853: a12 := JTF_NUMBER_TABLE();
854: a13 := JTF_VARCHAR2_TABLE_100();
855: a14 := JTF_NUMBER_TABLE();
856: a15 := JTF_NUMBER_TABLE();
857: a16 := JTF_NUMBER_TABLE();
858: a17 := JTF_NUMBER_TABLE();
859: a18 := JTF_VARCHAR2_TABLE_100();
860: a19 := JTF_DATE_TABLE();
853: a12 := JTF_NUMBER_TABLE();
854: a13 := JTF_VARCHAR2_TABLE_100();
855: a14 := JTF_NUMBER_TABLE();
856: a15 := JTF_NUMBER_TABLE();
857: a16 := JTF_NUMBER_TABLE();
858: a17 := JTF_NUMBER_TABLE();
859: a18 := JTF_VARCHAR2_TABLE_100();
860: a19 := JTF_DATE_TABLE();
861: a20 := JTF_DATE_TABLE();
854: a13 := JTF_VARCHAR2_TABLE_100();
855: a14 := JTF_NUMBER_TABLE();
856: a15 := JTF_NUMBER_TABLE();
857: a16 := JTF_NUMBER_TABLE();
858: a17 := JTF_NUMBER_TABLE();
859: a18 := JTF_VARCHAR2_TABLE_100();
860: a19 := JTF_DATE_TABLE();
861: a20 := JTF_DATE_TABLE();
862: a21 := JTF_VARCHAR2_TABLE_100();
860: a19 := JTF_DATE_TABLE();
861: a20 := JTF_DATE_TABLE();
862: a21 := JTF_VARCHAR2_TABLE_100();
863: a22 := JTF_DATE_TABLE();
864: a23 := JTF_NUMBER_TABLE();
865: a24 := JTF_DATE_TABLE();
866: a25 := JTF_NUMBER_TABLE();
867: a26 := JTF_NUMBER_TABLE();
868: a27 := JTF_NUMBER_TABLE();
862: a21 := JTF_VARCHAR2_TABLE_100();
863: a22 := JTF_DATE_TABLE();
864: a23 := JTF_NUMBER_TABLE();
865: a24 := JTF_DATE_TABLE();
866: a25 := JTF_NUMBER_TABLE();
867: a26 := JTF_NUMBER_TABLE();
868: a27 := JTF_NUMBER_TABLE();
869: a28 := JTF_NUMBER_TABLE();
870: a29 := JTF_NUMBER_TABLE();
863: a22 := JTF_DATE_TABLE();
864: a23 := JTF_NUMBER_TABLE();
865: a24 := JTF_DATE_TABLE();
866: a25 := JTF_NUMBER_TABLE();
867: a26 := JTF_NUMBER_TABLE();
868: a27 := JTF_NUMBER_TABLE();
869: a28 := JTF_NUMBER_TABLE();
870: a29 := JTF_NUMBER_TABLE();
871: a30 := JTF_NUMBER_TABLE();
864: a23 := JTF_NUMBER_TABLE();
865: a24 := JTF_DATE_TABLE();
866: a25 := JTF_NUMBER_TABLE();
867: a26 := JTF_NUMBER_TABLE();
868: a27 := JTF_NUMBER_TABLE();
869: a28 := JTF_NUMBER_TABLE();
870: a29 := JTF_NUMBER_TABLE();
871: a30 := JTF_NUMBER_TABLE();
872: a31 := JTF_VARCHAR2_TABLE_100();
865: a24 := JTF_DATE_TABLE();
866: a25 := JTF_NUMBER_TABLE();
867: a26 := JTF_NUMBER_TABLE();
868: a27 := JTF_NUMBER_TABLE();
869: a28 := JTF_NUMBER_TABLE();
870: a29 := JTF_NUMBER_TABLE();
871: a30 := JTF_NUMBER_TABLE();
872: a31 := JTF_VARCHAR2_TABLE_100();
873: a32 := JTF_NUMBER_TABLE();
866: a25 := JTF_NUMBER_TABLE();
867: a26 := JTF_NUMBER_TABLE();
868: a27 := JTF_NUMBER_TABLE();
869: a28 := JTF_NUMBER_TABLE();
870: a29 := JTF_NUMBER_TABLE();
871: a30 := JTF_NUMBER_TABLE();
872: a31 := JTF_VARCHAR2_TABLE_100();
873: a32 := JTF_NUMBER_TABLE();
874: a33 := JTF_VARCHAR2_TABLE_100();
867: a26 := JTF_NUMBER_TABLE();
868: a27 := JTF_NUMBER_TABLE();
869: a28 := JTF_NUMBER_TABLE();
870: a29 := JTF_NUMBER_TABLE();
871: a30 := JTF_NUMBER_TABLE();
872: a31 := JTF_VARCHAR2_TABLE_100();
873: a32 := JTF_NUMBER_TABLE();
874: a33 := JTF_VARCHAR2_TABLE_100();
875: a34 := JTF_VARCHAR2_TABLE_100();
869: a28 := JTF_NUMBER_TABLE();
870: a29 := JTF_NUMBER_TABLE();
871: a30 := JTF_NUMBER_TABLE();
872: a31 := JTF_VARCHAR2_TABLE_100();
873: a32 := JTF_NUMBER_TABLE();
874: a33 := JTF_VARCHAR2_TABLE_100();
875: a34 := JTF_VARCHAR2_TABLE_100();
876: a35 := JTF_VARCHAR2_TABLE_300();
877: a36 := JTF_VARCHAR2_TABLE_300();
1001: end if;
1002: end if;
1003: end rosetta_table_copy_out_p9;
1004:
1005: procedure rosetta_table_copy_in_p12(t out nocopy ozf_disc_line_pvt.prod_rec_tbl_type, a0 JTF_NUMBER_TABLE
1006: , a1 JTF_NUMBER_TABLE
1007: , a2 JTF_VARCHAR2_TABLE_100
1008: , a3 JTF_NUMBER_TABLE
1009: , a4 JTF_VARCHAR2_TABLE_100
1002: end if;
1003: end rosetta_table_copy_out_p9;
1004:
1005: procedure rosetta_table_copy_in_p12(t out nocopy ozf_disc_line_pvt.prod_rec_tbl_type, a0 JTF_NUMBER_TABLE
1006: , a1 JTF_NUMBER_TABLE
1007: , a2 JTF_VARCHAR2_TABLE_100
1008: , a3 JTF_NUMBER_TABLE
1009: , a4 JTF_VARCHAR2_TABLE_100
1010: , a5 JTF_VARCHAR2_TABLE_100
1004:
1005: procedure rosetta_table_copy_in_p12(t out nocopy ozf_disc_line_pvt.prod_rec_tbl_type, a0 JTF_NUMBER_TABLE
1006: , a1 JTF_NUMBER_TABLE
1007: , a2 JTF_VARCHAR2_TABLE_100
1008: , a3 JTF_NUMBER_TABLE
1009: , a4 JTF_VARCHAR2_TABLE_100
1010: , a5 JTF_VARCHAR2_TABLE_100
1011: , a6 JTF_DATE_TABLE
1012: , a7 JTF_DATE_TABLE
1009: , a4 JTF_VARCHAR2_TABLE_100
1010: , a5 JTF_VARCHAR2_TABLE_100
1011: , a6 JTF_DATE_TABLE
1012: , a7 JTF_DATE_TABLE
1013: , a8 JTF_NUMBER_TABLE
1014: , a9 JTF_NUMBER_TABLE
1015: , a10 JTF_DATE_TABLE
1016: , a11 JTF_NUMBER_TABLE
1017: , a12 JTF_DATE_TABLE
1010: , a5 JTF_VARCHAR2_TABLE_100
1011: , a6 JTF_DATE_TABLE
1012: , a7 JTF_DATE_TABLE
1013: , a8 JTF_NUMBER_TABLE
1014: , a9 JTF_NUMBER_TABLE
1015: , a10 JTF_DATE_TABLE
1016: , a11 JTF_NUMBER_TABLE
1017: , a12 JTF_DATE_TABLE
1018: , a13 JTF_NUMBER_TABLE
1012: , a7 JTF_DATE_TABLE
1013: , a8 JTF_NUMBER_TABLE
1014: , a9 JTF_NUMBER_TABLE
1015: , a10 JTF_DATE_TABLE
1016: , a11 JTF_NUMBER_TABLE
1017: , a12 JTF_DATE_TABLE
1018: , a13 JTF_NUMBER_TABLE
1019: , a14 JTF_NUMBER_TABLE
1020: , a15 JTF_NUMBER_TABLE
1014: , a9 JTF_NUMBER_TABLE
1015: , a10 JTF_DATE_TABLE
1016: , a11 JTF_NUMBER_TABLE
1017: , a12 JTF_DATE_TABLE
1018: , a13 JTF_NUMBER_TABLE
1019: , a14 JTF_NUMBER_TABLE
1020: , a15 JTF_NUMBER_TABLE
1021: ) as
1022: ddindx binary_integer; indx binary_integer;
1015: , a10 JTF_DATE_TABLE
1016: , a11 JTF_NUMBER_TABLE
1017: , a12 JTF_DATE_TABLE
1018: , a13 JTF_NUMBER_TABLE
1019: , a14 JTF_NUMBER_TABLE
1020: , a15 JTF_NUMBER_TABLE
1021: ) as
1022: ddindx binary_integer; indx binary_integer;
1023: begin
1016: , a11 JTF_NUMBER_TABLE
1017: , a12 JTF_DATE_TABLE
1018: , a13 JTF_NUMBER_TABLE
1019: , a14 JTF_NUMBER_TABLE
1020: , a15 JTF_NUMBER_TABLE
1021: ) as
1022: ddindx binary_integer; indx binary_integer;
1023: begin
1024: if a0 is not null and a0.count > 0 then
1050: end loop;
1051: end if;
1052: end if;
1053: end rosetta_table_copy_in_p12;
1054: procedure rosetta_table_copy_out_p12(t ozf_disc_line_pvt.prod_rec_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
1055: , a1 out nocopy JTF_NUMBER_TABLE
1056: , a2 out nocopy JTF_VARCHAR2_TABLE_100
1057: , a3 out nocopy JTF_NUMBER_TABLE
1058: , a4 out nocopy JTF_VARCHAR2_TABLE_100
1051: end if;
1052: end if;
1053: end rosetta_table_copy_in_p12;
1054: procedure rosetta_table_copy_out_p12(t ozf_disc_line_pvt.prod_rec_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
1055: , a1 out nocopy JTF_NUMBER_TABLE
1056: , a2 out nocopy JTF_VARCHAR2_TABLE_100
1057: , a3 out nocopy JTF_NUMBER_TABLE
1058: , a4 out nocopy JTF_VARCHAR2_TABLE_100
1059: , a5 out nocopy JTF_VARCHAR2_TABLE_100
1053: end rosetta_table_copy_in_p12;
1054: procedure rosetta_table_copy_out_p12(t ozf_disc_line_pvt.prod_rec_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
1055: , a1 out nocopy JTF_NUMBER_TABLE
1056: , a2 out nocopy JTF_VARCHAR2_TABLE_100
1057: , a3 out nocopy JTF_NUMBER_TABLE
1058: , a4 out nocopy JTF_VARCHAR2_TABLE_100
1059: , a5 out nocopy JTF_VARCHAR2_TABLE_100
1060: , a6 out nocopy JTF_DATE_TABLE
1061: , a7 out nocopy JTF_DATE_TABLE
1058: , a4 out nocopy JTF_VARCHAR2_TABLE_100
1059: , a5 out nocopy JTF_VARCHAR2_TABLE_100
1060: , a6 out nocopy JTF_DATE_TABLE
1061: , a7 out nocopy JTF_DATE_TABLE
1062: , a8 out nocopy JTF_NUMBER_TABLE
1063: , a9 out nocopy JTF_NUMBER_TABLE
1064: , a10 out nocopy JTF_DATE_TABLE
1065: , a11 out nocopy JTF_NUMBER_TABLE
1066: , a12 out nocopy JTF_DATE_TABLE
1059: , a5 out nocopy JTF_VARCHAR2_TABLE_100
1060: , a6 out nocopy JTF_DATE_TABLE
1061: , a7 out nocopy JTF_DATE_TABLE
1062: , a8 out nocopy JTF_NUMBER_TABLE
1063: , a9 out nocopy JTF_NUMBER_TABLE
1064: , a10 out nocopy JTF_DATE_TABLE
1065: , a11 out nocopy JTF_NUMBER_TABLE
1066: , a12 out nocopy JTF_DATE_TABLE
1067: , a13 out nocopy JTF_NUMBER_TABLE
1061: , a7 out nocopy JTF_DATE_TABLE
1062: , a8 out nocopy JTF_NUMBER_TABLE
1063: , a9 out nocopy JTF_NUMBER_TABLE
1064: , a10 out nocopy JTF_DATE_TABLE
1065: , a11 out nocopy JTF_NUMBER_TABLE
1066: , a12 out nocopy JTF_DATE_TABLE
1067: , a13 out nocopy JTF_NUMBER_TABLE
1068: , a14 out nocopy JTF_NUMBER_TABLE
1069: , a15 out nocopy JTF_NUMBER_TABLE
1063: , a9 out nocopy JTF_NUMBER_TABLE
1064: , a10 out nocopy JTF_DATE_TABLE
1065: , a11 out nocopy JTF_NUMBER_TABLE
1066: , a12 out nocopy JTF_DATE_TABLE
1067: , a13 out nocopy JTF_NUMBER_TABLE
1068: , a14 out nocopy JTF_NUMBER_TABLE
1069: , a15 out nocopy JTF_NUMBER_TABLE
1070: ) as
1071: ddindx binary_integer; indx binary_integer;
1064: , a10 out nocopy JTF_DATE_TABLE
1065: , a11 out nocopy JTF_NUMBER_TABLE
1066: , a12 out nocopy JTF_DATE_TABLE
1067: , a13 out nocopy JTF_NUMBER_TABLE
1068: , a14 out nocopy JTF_NUMBER_TABLE
1069: , a15 out nocopy JTF_NUMBER_TABLE
1070: ) as
1071: ddindx binary_integer; indx binary_integer;
1072: begin
1065: , a11 out nocopy JTF_NUMBER_TABLE
1066: , a12 out nocopy JTF_DATE_TABLE
1067: , a13 out nocopy JTF_NUMBER_TABLE
1068: , a14 out nocopy JTF_NUMBER_TABLE
1069: , a15 out nocopy JTF_NUMBER_TABLE
1070: ) as
1071: ddindx binary_integer; indx binary_integer;
1072: begin
1073: if t is null or t.count = 0 then
1070: ) as
1071: ddindx binary_integer; indx binary_integer;
1072: begin
1073: if t is null or t.count = 0 then
1074: a0 := JTF_NUMBER_TABLE();
1075: a1 := JTF_NUMBER_TABLE();
1076: a2 := JTF_VARCHAR2_TABLE_100();
1077: a3 := JTF_NUMBER_TABLE();
1078: a4 := JTF_VARCHAR2_TABLE_100();
1071: ddindx binary_integer; indx binary_integer;
1072: begin
1073: if t is null or t.count = 0 then
1074: a0 := JTF_NUMBER_TABLE();
1075: a1 := JTF_NUMBER_TABLE();
1076: a2 := JTF_VARCHAR2_TABLE_100();
1077: a3 := JTF_NUMBER_TABLE();
1078: a4 := JTF_VARCHAR2_TABLE_100();
1079: a5 := JTF_VARCHAR2_TABLE_100();
1073: if t is null or t.count = 0 then
1074: a0 := JTF_NUMBER_TABLE();
1075: a1 := JTF_NUMBER_TABLE();
1076: a2 := JTF_VARCHAR2_TABLE_100();
1077: a3 := JTF_NUMBER_TABLE();
1078: a4 := JTF_VARCHAR2_TABLE_100();
1079: a5 := JTF_VARCHAR2_TABLE_100();
1080: a6 := JTF_DATE_TABLE();
1081: a7 := JTF_DATE_TABLE();
1078: a4 := JTF_VARCHAR2_TABLE_100();
1079: a5 := JTF_VARCHAR2_TABLE_100();
1080: a6 := JTF_DATE_TABLE();
1081: a7 := JTF_DATE_TABLE();
1082: a8 := JTF_NUMBER_TABLE();
1083: a9 := JTF_NUMBER_TABLE();
1084: a10 := JTF_DATE_TABLE();
1085: a11 := JTF_NUMBER_TABLE();
1086: a12 := JTF_DATE_TABLE();
1079: a5 := JTF_VARCHAR2_TABLE_100();
1080: a6 := JTF_DATE_TABLE();
1081: a7 := JTF_DATE_TABLE();
1082: a8 := JTF_NUMBER_TABLE();
1083: a9 := JTF_NUMBER_TABLE();
1084: a10 := JTF_DATE_TABLE();
1085: a11 := JTF_NUMBER_TABLE();
1086: a12 := JTF_DATE_TABLE();
1087: a13 := JTF_NUMBER_TABLE();
1081: a7 := JTF_DATE_TABLE();
1082: a8 := JTF_NUMBER_TABLE();
1083: a9 := JTF_NUMBER_TABLE();
1084: a10 := JTF_DATE_TABLE();
1085: a11 := JTF_NUMBER_TABLE();
1086: a12 := JTF_DATE_TABLE();
1087: a13 := JTF_NUMBER_TABLE();
1088: a14 := JTF_NUMBER_TABLE();
1089: a15 := JTF_NUMBER_TABLE();
1083: a9 := JTF_NUMBER_TABLE();
1084: a10 := JTF_DATE_TABLE();
1085: a11 := JTF_NUMBER_TABLE();
1086: a12 := JTF_DATE_TABLE();
1087: a13 := JTF_NUMBER_TABLE();
1088: a14 := JTF_NUMBER_TABLE();
1089: a15 := JTF_NUMBER_TABLE();
1090: else
1091: a0 := JTF_NUMBER_TABLE();
1084: a10 := JTF_DATE_TABLE();
1085: a11 := JTF_NUMBER_TABLE();
1086: a12 := JTF_DATE_TABLE();
1087: a13 := JTF_NUMBER_TABLE();
1088: a14 := JTF_NUMBER_TABLE();
1089: a15 := JTF_NUMBER_TABLE();
1090: else
1091: a0 := JTF_NUMBER_TABLE();
1092: a1 := JTF_NUMBER_TABLE();
1085: a11 := JTF_NUMBER_TABLE();
1086: a12 := JTF_DATE_TABLE();
1087: a13 := JTF_NUMBER_TABLE();
1088: a14 := JTF_NUMBER_TABLE();
1089: a15 := JTF_NUMBER_TABLE();
1090: else
1091: a0 := JTF_NUMBER_TABLE();
1092: a1 := JTF_NUMBER_TABLE();
1093: a2 := JTF_VARCHAR2_TABLE_100();
1087: a13 := JTF_NUMBER_TABLE();
1088: a14 := JTF_NUMBER_TABLE();
1089: a15 := JTF_NUMBER_TABLE();
1090: else
1091: a0 := JTF_NUMBER_TABLE();
1092: a1 := JTF_NUMBER_TABLE();
1093: a2 := JTF_VARCHAR2_TABLE_100();
1094: a3 := JTF_NUMBER_TABLE();
1095: a4 := JTF_VARCHAR2_TABLE_100();
1088: a14 := JTF_NUMBER_TABLE();
1089: a15 := JTF_NUMBER_TABLE();
1090: else
1091: a0 := JTF_NUMBER_TABLE();
1092: a1 := JTF_NUMBER_TABLE();
1093: a2 := JTF_VARCHAR2_TABLE_100();
1094: a3 := JTF_NUMBER_TABLE();
1095: a4 := JTF_VARCHAR2_TABLE_100();
1096: a5 := JTF_VARCHAR2_TABLE_100();
1090: else
1091: a0 := JTF_NUMBER_TABLE();
1092: a1 := JTF_NUMBER_TABLE();
1093: a2 := JTF_VARCHAR2_TABLE_100();
1094: a3 := JTF_NUMBER_TABLE();
1095: a4 := JTF_VARCHAR2_TABLE_100();
1096: a5 := JTF_VARCHAR2_TABLE_100();
1097: a6 := JTF_DATE_TABLE();
1098: a7 := JTF_DATE_TABLE();
1095: a4 := JTF_VARCHAR2_TABLE_100();
1096: a5 := JTF_VARCHAR2_TABLE_100();
1097: a6 := JTF_DATE_TABLE();
1098: a7 := JTF_DATE_TABLE();
1099: a8 := JTF_NUMBER_TABLE();
1100: a9 := JTF_NUMBER_TABLE();
1101: a10 := JTF_DATE_TABLE();
1102: a11 := JTF_NUMBER_TABLE();
1103: a12 := JTF_DATE_TABLE();
1096: a5 := JTF_VARCHAR2_TABLE_100();
1097: a6 := JTF_DATE_TABLE();
1098: a7 := JTF_DATE_TABLE();
1099: a8 := JTF_NUMBER_TABLE();
1100: a9 := JTF_NUMBER_TABLE();
1101: a10 := JTF_DATE_TABLE();
1102: a11 := JTF_NUMBER_TABLE();
1103: a12 := JTF_DATE_TABLE();
1104: a13 := JTF_NUMBER_TABLE();
1098: a7 := JTF_DATE_TABLE();
1099: a8 := JTF_NUMBER_TABLE();
1100: a9 := JTF_NUMBER_TABLE();
1101: a10 := JTF_DATE_TABLE();
1102: a11 := JTF_NUMBER_TABLE();
1103: a12 := JTF_DATE_TABLE();
1104: a13 := JTF_NUMBER_TABLE();
1105: a14 := JTF_NUMBER_TABLE();
1106: a15 := JTF_NUMBER_TABLE();
1100: a9 := JTF_NUMBER_TABLE();
1101: a10 := JTF_DATE_TABLE();
1102: a11 := JTF_NUMBER_TABLE();
1103: a12 := JTF_DATE_TABLE();
1104: a13 := JTF_NUMBER_TABLE();
1105: a14 := JTF_NUMBER_TABLE();
1106: a15 := JTF_NUMBER_TABLE();
1107: if t.count > 0 then
1108: a0.extend(t.count);
1101: a10 := JTF_DATE_TABLE();
1102: a11 := JTF_NUMBER_TABLE();
1103: a12 := JTF_DATE_TABLE();
1104: a13 := JTF_NUMBER_TABLE();
1105: a14 := JTF_NUMBER_TABLE();
1106: a15 := JTF_NUMBER_TABLE();
1107: if t.count > 0 then
1108: a0.extend(t.count);
1109: a1.extend(t.count);
1102: a11 := JTF_NUMBER_TABLE();
1103: a12 := JTF_DATE_TABLE();
1104: a13 := JTF_NUMBER_TABLE();
1105: a14 := JTF_NUMBER_TABLE();
1106: a15 := JTF_NUMBER_TABLE();
1107: if t.count > 0 then
1108: a0.extend(t.count);
1109: a1.extend(t.count);
1110: a2.extend(t.count);
1149: end if;
1150: end if;
1151: end rosetta_table_copy_out_p12;
1152:
1153: procedure rosetta_table_copy_in_p15(t out nocopy ozf_disc_line_pvt.excl_rec_tbl_type, a0 JTF_NUMBER_TABLE
1154: , a1 JTF_NUMBER_TABLE
1155: , a2 JTF_VARCHAR2_TABLE_100
1156: , a3 JTF_NUMBER_TABLE
1157: , a4 JTF_NUMBER_TABLE
1150: end if;
1151: end rosetta_table_copy_out_p12;
1152:
1153: procedure rosetta_table_copy_in_p15(t out nocopy ozf_disc_line_pvt.excl_rec_tbl_type, a0 JTF_NUMBER_TABLE
1154: , a1 JTF_NUMBER_TABLE
1155: , a2 JTF_VARCHAR2_TABLE_100
1156: , a3 JTF_NUMBER_TABLE
1157: , a4 JTF_NUMBER_TABLE
1158: , a5 JTF_DATE_TABLE
1152:
1153: procedure rosetta_table_copy_in_p15(t out nocopy ozf_disc_line_pvt.excl_rec_tbl_type, a0 JTF_NUMBER_TABLE
1154: , a1 JTF_NUMBER_TABLE
1155: , a2 JTF_VARCHAR2_TABLE_100
1156: , a3 JTF_NUMBER_TABLE
1157: , a4 JTF_NUMBER_TABLE
1158: , a5 JTF_DATE_TABLE
1159: , a6 JTF_DATE_TABLE
1160: ) as
1153: procedure rosetta_table_copy_in_p15(t out nocopy ozf_disc_line_pvt.excl_rec_tbl_type, a0 JTF_NUMBER_TABLE
1154: , a1 JTF_NUMBER_TABLE
1155: , a2 JTF_VARCHAR2_TABLE_100
1156: , a3 JTF_NUMBER_TABLE
1157: , a4 JTF_NUMBER_TABLE
1158: , a5 JTF_DATE_TABLE
1159: , a6 JTF_DATE_TABLE
1160: ) as
1161: ddindx binary_integer; indx binary_integer;
1180: end loop;
1181: end if;
1182: end if;
1183: end rosetta_table_copy_in_p15;
1184: procedure rosetta_table_copy_out_p15(t ozf_disc_line_pvt.excl_rec_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
1185: , a1 out nocopy JTF_NUMBER_TABLE
1186: , a2 out nocopy JTF_VARCHAR2_TABLE_100
1187: , a3 out nocopy JTF_NUMBER_TABLE
1188: , a4 out nocopy JTF_NUMBER_TABLE
1181: end if;
1182: end if;
1183: end rosetta_table_copy_in_p15;
1184: procedure rosetta_table_copy_out_p15(t ozf_disc_line_pvt.excl_rec_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
1185: , a1 out nocopy JTF_NUMBER_TABLE
1186: , a2 out nocopy JTF_VARCHAR2_TABLE_100
1187: , a3 out nocopy JTF_NUMBER_TABLE
1188: , a4 out nocopy JTF_NUMBER_TABLE
1189: , a5 out nocopy JTF_DATE_TABLE
1183: end rosetta_table_copy_in_p15;
1184: procedure rosetta_table_copy_out_p15(t ozf_disc_line_pvt.excl_rec_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
1185: , a1 out nocopy JTF_NUMBER_TABLE
1186: , a2 out nocopy JTF_VARCHAR2_TABLE_100
1187: , a3 out nocopy JTF_NUMBER_TABLE
1188: , a4 out nocopy JTF_NUMBER_TABLE
1189: , a5 out nocopy JTF_DATE_TABLE
1190: , a6 out nocopy JTF_DATE_TABLE
1191: ) as
1184: procedure rosetta_table_copy_out_p15(t ozf_disc_line_pvt.excl_rec_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
1185: , a1 out nocopy JTF_NUMBER_TABLE
1186: , a2 out nocopy JTF_VARCHAR2_TABLE_100
1187: , a3 out nocopy JTF_NUMBER_TABLE
1188: , a4 out nocopy JTF_NUMBER_TABLE
1189: , a5 out nocopy JTF_DATE_TABLE
1190: , a6 out nocopy JTF_DATE_TABLE
1191: ) as
1192: ddindx binary_integer; indx binary_integer;
1191: ) as
1192: ddindx binary_integer; indx binary_integer;
1193: begin
1194: if t is null or t.count = 0 then
1195: a0 := JTF_NUMBER_TABLE();
1196: a1 := JTF_NUMBER_TABLE();
1197: a2 := JTF_VARCHAR2_TABLE_100();
1198: a3 := JTF_NUMBER_TABLE();
1199: a4 := JTF_NUMBER_TABLE();
1192: ddindx binary_integer; indx binary_integer;
1193: begin
1194: if t is null or t.count = 0 then
1195: a0 := JTF_NUMBER_TABLE();
1196: a1 := JTF_NUMBER_TABLE();
1197: a2 := JTF_VARCHAR2_TABLE_100();
1198: a3 := JTF_NUMBER_TABLE();
1199: a4 := JTF_NUMBER_TABLE();
1200: a5 := JTF_DATE_TABLE();
1194: if t is null or t.count = 0 then
1195: a0 := JTF_NUMBER_TABLE();
1196: a1 := JTF_NUMBER_TABLE();
1197: a2 := JTF_VARCHAR2_TABLE_100();
1198: a3 := JTF_NUMBER_TABLE();
1199: a4 := JTF_NUMBER_TABLE();
1200: a5 := JTF_DATE_TABLE();
1201: a6 := JTF_DATE_TABLE();
1202: else
1195: a0 := JTF_NUMBER_TABLE();
1196: a1 := JTF_NUMBER_TABLE();
1197: a2 := JTF_VARCHAR2_TABLE_100();
1198: a3 := JTF_NUMBER_TABLE();
1199: a4 := JTF_NUMBER_TABLE();
1200: a5 := JTF_DATE_TABLE();
1201: a6 := JTF_DATE_TABLE();
1202: else
1203: a0 := JTF_NUMBER_TABLE();
1199: a4 := JTF_NUMBER_TABLE();
1200: a5 := JTF_DATE_TABLE();
1201: a6 := JTF_DATE_TABLE();
1202: else
1203: a0 := JTF_NUMBER_TABLE();
1204: a1 := JTF_NUMBER_TABLE();
1205: a2 := JTF_VARCHAR2_TABLE_100();
1206: a3 := JTF_NUMBER_TABLE();
1207: a4 := JTF_NUMBER_TABLE();
1200: a5 := JTF_DATE_TABLE();
1201: a6 := JTF_DATE_TABLE();
1202: else
1203: a0 := JTF_NUMBER_TABLE();
1204: a1 := JTF_NUMBER_TABLE();
1205: a2 := JTF_VARCHAR2_TABLE_100();
1206: a3 := JTF_NUMBER_TABLE();
1207: a4 := JTF_NUMBER_TABLE();
1208: a5 := JTF_DATE_TABLE();
1202: else
1203: a0 := JTF_NUMBER_TABLE();
1204: a1 := JTF_NUMBER_TABLE();
1205: a2 := JTF_VARCHAR2_TABLE_100();
1206: a3 := JTF_NUMBER_TABLE();
1207: a4 := JTF_NUMBER_TABLE();
1208: a5 := JTF_DATE_TABLE();
1209: a6 := JTF_DATE_TABLE();
1210: if t.count > 0 then
1203: a0 := JTF_NUMBER_TABLE();
1204: a1 := JTF_NUMBER_TABLE();
1205: a2 := JTF_VARCHAR2_TABLE_100();
1206: a3 := JTF_NUMBER_TABLE();
1207: a4 := JTF_NUMBER_TABLE();
1208: a5 := JTF_DATE_TABLE();
1209: a6 := JTF_DATE_TABLE();
1210: if t.count > 0 then
1211: a0.extend(t.count);
1234: end if;
1235: end if;
1236: end rosetta_table_copy_out_p15;
1237:
1238: procedure rosetta_table_copy_in_p18(t out nocopy ozf_disc_line_pvt.prod_reln_tbl_type, a0 JTF_NUMBER_TABLE
1239: , a1 JTF_NUMBER_TABLE
1240: , a2 JTF_NUMBER_TABLE
1241: , a3 JTF_DATE_TABLE
1242: , a4 JTF_NUMBER_TABLE
1235: end if;
1236: end rosetta_table_copy_out_p15;
1237:
1238: procedure rosetta_table_copy_in_p18(t out nocopy ozf_disc_line_pvt.prod_reln_tbl_type, a0 JTF_NUMBER_TABLE
1239: , a1 JTF_NUMBER_TABLE
1240: , a2 JTF_NUMBER_TABLE
1241: , a3 JTF_DATE_TABLE
1242: , a4 JTF_NUMBER_TABLE
1243: , a5 JTF_DATE_TABLE
1236: end rosetta_table_copy_out_p15;
1237:
1238: procedure rosetta_table_copy_in_p18(t out nocopy ozf_disc_line_pvt.prod_reln_tbl_type, a0 JTF_NUMBER_TABLE
1239: , a1 JTF_NUMBER_TABLE
1240: , a2 JTF_NUMBER_TABLE
1241: , a3 JTF_DATE_TABLE
1242: , a4 JTF_NUMBER_TABLE
1243: , a5 JTF_DATE_TABLE
1244: , a6 JTF_NUMBER_TABLE
1238: procedure rosetta_table_copy_in_p18(t out nocopy ozf_disc_line_pvt.prod_reln_tbl_type, a0 JTF_NUMBER_TABLE
1239: , a1 JTF_NUMBER_TABLE
1240: , a2 JTF_NUMBER_TABLE
1241: , a3 JTF_DATE_TABLE
1242: , a4 JTF_NUMBER_TABLE
1243: , a5 JTF_DATE_TABLE
1244: , a6 JTF_NUMBER_TABLE
1245: , a7 JTF_NUMBER_TABLE
1246: , a8 JTF_NUMBER_TABLE
1240: , a2 JTF_NUMBER_TABLE
1241: , a3 JTF_DATE_TABLE
1242: , a4 JTF_NUMBER_TABLE
1243: , a5 JTF_DATE_TABLE
1244: , a6 JTF_NUMBER_TABLE
1245: , a7 JTF_NUMBER_TABLE
1246: , a8 JTF_NUMBER_TABLE
1247: ) as
1248: ddindx binary_integer; indx binary_integer;
1241: , a3 JTF_DATE_TABLE
1242: , a4 JTF_NUMBER_TABLE
1243: , a5 JTF_DATE_TABLE
1244: , a6 JTF_NUMBER_TABLE
1245: , a7 JTF_NUMBER_TABLE
1246: , a8 JTF_NUMBER_TABLE
1247: ) as
1248: ddindx binary_integer; indx binary_integer;
1249: begin
1242: , a4 JTF_NUMBER_TABLE
1243: , a5 JTF_DATE_TABLE
1244: , a6 JTF_NUMBER_TABLE
1245: , a7 JTF_NUMBER_TABLE
1246: , a8 JTF_NUMBER_TABLE
1247: ) as
1248: ddindx binary_integer; indx binary_integer;
1249: begin
1250: if a0 is not null and a0.count > 0 then
1269: end loop;
1270: end if;
1271: end if;
1272: end rosetta_table_copy_in_p18;
1273: procedure rosetta_table_copy_out_p18(t ozf_disc_line_pvt.prod_reln_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
1274: , a1 out nocopy JTF_NUMBER_TABLE
1275: , a2 out nocopy JTF_NUMBER_TABLE
1276: , a3 out nocopy JTF_DATE_TABLE
1277: , a4 out nocopy JTF_NUMBER_TABLE
1270: end if;
1271: end if;
1272: end rosetta_table_copy_in_p18;
1273: procedure rosetta_table_copy_out_p18(t ozf_disc_line_pvt.prod_reln_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
1274: , a1 out nocopy JTF_NUMBER_TABLE
1275: , a2 out nocopy JTF_NUMBER_TABLE
1276: , a3 out nocopy JTF_DATE_TABLE
1277: , a4 out nocopy JTF_NUMBER_TABLE
1278: , a5 out nocopy JTF_DATE_TABLE
1271: end if;
1272: end rosetta_table_copy_in_p18;
1273: procedure rosetta_table_copy_out_p18(t ozf_disc_line_pvt.prod_reln_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
1274: , a1 out nocopy JTF_NUMBER_TABLE
1275: , a2 out nocopy JTF_NUMBER_TABLE
1276: , a3 out nocopy JTF_DATE_TABLE
1277: , a4 out nocopy JTF_NUMBER_TABLE
1278: , a5 out nocopy JTF_DATE_TABLE
1279: , a6 out nocopy JTF_NUMBER_TABLE
1273: procedure rosetta_table_copy_out_p18(t ozf_disc_line_pvt.prod_reln_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
1274: , a1 out nocopy JTF_NUMBER_TABLE
1275: , a2 out nocopy JTF_NUMBER_TABLE
1276: , a3 out nocopy JTF_DATE_TABLE
1277: , a4 out nocopy JTF_NUMBER_TABLE
1278: , a5 out nocopy JTF_DATE_TABLE
1279: , a6 out nocopy JTF_NUMBER_TABLE
1280: , a7 out nocopy JTF_NUMBER_TABLE
1281: , a8 out nocopy JTF_NUMBER_TABLE
1275: , a2 out nocopy JTF_NUMBER_TABLE
1276: , a3 out nocopy JTF_DATE_TABLE
1277: , a4 out nocopy JTF_NUMBER_TABLE
1278: , a5 out nocopy JTF_DATE_TABLE
1279: , a6 out nocopy JTF_NUMBER_TABLE
1280: , a7 out nocopy JTF_NUMBER_TABLE
1281: , a8 out nocopy JTF_NUMBER_TABLE
1282: ) as
1283: ddindx binary_integer; indx binary_integer;
1276: , a3 out nocopy JTF_DATE_TABLE
1277: , a4 out nocopy JTF_NUMBER_TABLE
1278: , a5 out nocopy JTF_DATE_TABLE
1279: , a6 out nocopy JTF_NUMBER_TABLE
1280: , a7 out nocopy JTF_NUMBER_TABLE
1281: , a8 out nocopy JTF_NUMBER_TABLE
1282: ) as
1283: ddindx binary_integer; indx binary_integer;
1284: begin
1277: , a4 out nocopy JTF_NUMBER_TABLE
1278: , a5 out nocopy JTF_DATE_TABLE
1279: , a6 out nocopy JTF_NUMBER_TABLE
1280: , a7 out nocopy JTF_NUMBER_TABLE
1281: , a8 out nocopy JTF_NUMBER_TABLE
1282: ) as
1283: ddindx binary_integer; indx binary_integer;
1284: begin
1285: if t is null or t.count = 0 then
1282: ) as
1283: ddindx binary_integer; indx binary_integer;
1284: begin
1285: if t is null or t.count = 0 then
1286: a0 := JTF_NUMBER_TABLE();
1287: a1 := JTF_NUMBER_TABLE();
1288: a2 := JTF_NUMBER_TABLE();
1289: a3 := JTF_DATE_TABLE();
1290: a4 := JTF_NUMBER_TABLE();
1283: ddindx binary_integer; indx binary_integer;
1284: begin
1285: if t is null or t.count = 0 then
1286: a0 := JTF_NUMBER_TABLE();
1287: a1 := JTF_NUMBER_TABLE();
1288: a2 := JTF_NUMBER_TABLE();
1289: a3 := JTF_DATE_TABLE();
1290: a4 := JTF_NUMBER_TABLE();
1291: a5 := JTF_DATE_TABLE();
1284: begin
1285: if t is null or t.count = 0 then
1286: a0 := JTF_NUMBER_TABLE();
1287: a1 := JTF_NUMBER_TABLE();
1288: a2 := JTF_NUMBER_TABLE();
1289: a3 := JTF_DATE_TABLE();
1290: a4 := JTF_NUMBER_TABLE();
1291: a5 := JTF_DATE_TABLE();
1292: a6 := JTF_NUMBER_TABLE();
1286: a0 := JTF_NUMBER_TABLE();
1287: a1 := JTF_NUMBER_TABLE();
1288: a2 := JTF_NUMBER_TABLE();
1289: a3 := JTF_DATE_TABLE();
1290: a4 := JTF_NUMBER_TABLE();
1291: a5 := JTF_DATE_TABLE();
1292: a6 := JTF_NUMBER_TABLE();
1293: a7 := JTF_NUMBER_TABLE();
1294: a8 := JTF_NUMBER_TABLE();
1288: a2 := JTF_NUMBER_TABLE();
1289: a3 := JTF_DATE_TABLE();
1290: a4 := JTF_NUMBER_TABLE();
1291: a5 := JTF_DATE_TABLE();
1292: a6 := JTF_NUMBER_TABLE();
1293: a7 := JTF_NUMBER_TABLE();
1294: a8 := JTF_NUMBER_TABLE();
1295: else
1296: a0 := JTF_NUMBER_TABLE();
1289: a3 := JTF_DATE_TABLE();
1290: a4 := JTF_NUMBER_TABLE();
1291: a5 := JTF_DATE_TABLE();
1292: a6 := JTF_NUMBER_TABLE();
1293: a7 := JTF_NUMBER_TABLE();
1294: a8 := JTF_NUMBER_TABLE();
1295: else
1296: a0 := JTF_NUMBER_TABLE();
1297: a1 := JTF_NUMBER_TABLE();
1290: a4 := JTF_NUMBER_TABLE();
1291: a5 := JTF_DATE_TABLE();
1292: a6 := JTF_NUMBER_TABLE();
1293: a7 := JTF_NUMBER_TABLE();
1294: a8 := JTF_NUMBER_TABLE();
1295: else
1296: a0 := JTF_NUMBER_TABLE();
1297: a1 := JTF_NUMBER_TABLE();
1298: a2 := JTF_NUMBER_TABLE();
1292: a6 := JTF_NUMBER_TABLE();
1293: a7 := JTF_NUMBER_TABLE();
1294: a8 := JTF_NUMBER_TABLE();
1295: else
1296: a0 := JTF_NUMBER_TABLE();
1297: a1 := JTF_NUMBER_TABLE();
1298: a2 := JTF_NUMBER_TABLE();
1299: a3 := JTF_DATE_TABLE();
1300: a4 := JTF_NUMBER_TABLE();
1293: a7 := JTF_NUMBER_TABLE();
1294: a8 := JTF_NUMBER_TABLE();
1295: else
1296: a0 := JTF_NUMBER_TABLE();
1297: a1 := JTF_NUMBER_TABLE();
1298: a2 := JTF_NUMBER_TABLE();
1299: a3 := JTF_DATE_TABLE();
1300: a4 := JTF_NUMBER_TABLE();
1301: a5 := JTF_DATE_TABLE();
1294: a8 := JTF_NUMBER_TABLE();
1295: else
1296: a0 := JTF_NUMBER_TABLE();
1297: a1 := JTF_NUMBER_TABLE();
1298: a2 := JTF_NUMBER_TABLE();
1299: a3 := JTF_DATE_TABLE();
1300: a4 := JTF_NUMBER_TABLE();
1301: a5 := JTF_DATE_TABLE();
1302: a6 := JTF_NUMBER_TABLE();
1296: a0 := JTF_NUMBER_TABLE();
1297: a1 := JTF_NUMBER_TABLE();
1298: a2 := JTF_NUMBER_TABLE();
1299: a3 := JTF_DATE_TABLE();
1300: a4 := JTF_NUMBER_TABLE();
1301: a5 := JTF_DATE_TABLE();
1302: a6 := JTF_NUMBER_TABLE();
1303: a7 := JTF_NUMBER_TABLE();
1304: a8 := JTF_NUMBER_TABLE();
1298: a2 := JTF_NUMBER_TABLE();
1299: a3 := JTF_DATE_TABLE();
1300: a4 := JTF_NUMBER_TABLE();
1301: a5 := JTF_DATE_TABLE();
1302: a6 := JTF_NUMBER_TABLE();
1303: a7 := JTF_NUMBER_TABLE();
1304: a8 := JTF_NUMBER_TABLE();
1305: if t.count > 0 then
1306: a0.extend(t.count);
1299: a3 := JTF_DATE_TABLE();
1300: a4 := JTF_NUMBER_TABLE();
1301: a5 := JTF_DATE_TABLE();
1302: a6 := JTF_NUMBER_TABLE();
1303: a7 := JTF_NUMBER_TABLE();
1304: a8 := JTF_NUMBER_TABLE();
1305: if t.count > 0 then
1306: a0.extend(t.count);
1307: a1.extend(t.count);
1300: a4 := JTF_NUMBER_TABLE();
1301: a5 := JTF_DATE_TABLE();
1302: a6 := JTF_NUMBER_TABLE();
1303: a7 := JTF_NUMBER_TABLE();
1304: a8 := JTF_NUMBER_TABLE();
1305: if t.count > 0 then
1306: a0.extend(t.count);
1307: a1.extend(t.count);
1308: a2.extend(t.count);