3: procedure rosetta_table_copy_in_p3(t out nocopy cn_calc_formulas_pvt.input_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: ) as
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: ) as
15: ddindx binary_integer; indx binary_integer;
16: begin
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: ) as
15: ddindx binary_integer; indx binary_integer;
16: begin
17: if a0 is not null and a0.count > 0 then
42: procedure rosetta_table_copy_out_p3(t cn_calc_formulas_pvt.input_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
43: , a1 out nocopy JTF_NUMBER_TABLE
44: , a2 out nocopy JTF_NUMBER_TABLE
45: , a3 out nocopy JTF_NUMBER_TABLE
46: , a4 out nocopy JTF_VARCHAR2_TABLE_100
47: , a5 out nocopy JTF_VARCHAR2_TABLE_100
48: , a6 out nocopy JTF_VARCHAR2_TABLE_100
49: , a7 out nocopy JTF_VARCHAR2_TABLE_100
50: , a8 out nocopy JTF_NUMBER_TABLE
43: , a1 out nocopy JTF_NUMBER_TABLE
44: , a2 out nocopy JTF_NUMBER_TABLE
45: , a3 out nocopy JTF_NUMBER_TABLE
46: , a4 out nocopy JTF_VARCHAR2_TABLE_100
47: , a5 out nocopy JTF_VARCHAR2_TABLE_100
48: , a6 out nocopy JTF_VARCHAR2_TABLE_100
49: , a7 out nocopy JTF_VARCHAR2_TABLE_100
50: , a8 out nocopy JTF_NUMBER_TABLE
51: , a9 out nocopy JTF_VARCHAR2_TABLE_100
44: , a2 out nocopy JTF_NUMBER_TABLE
45: , a3 out nocopy JTF_NUMBER_TABLE
46: , a4 out nocopy JTF_VARCHAR2_TABLE_100
47: , a5 out nocopy JTF_VARCHAR2_TABLE_100
48: , a6 out nocopy JTF_VARCHAR2_TABLE_100
49: , a7 out nocopy JTF_VARCHAR2_TABLE_100
50: , a8 out nocopy JTF_NUMBER_TABLE
51: , a9 out nocopy JTF_VARCHAR2_TABLE_100
52: , a10 out nocopy JTF_VARCHAR2_TABLE_100
45: , a3 out nocopy JTF_NUMBER_TABLE
46: , a4 out nocopy JTF_VARCHAR2_TABLE_100
47: , a5 out nocopy JTF_VARCHAR2_TABLE_100
48: , a6 out nocopy JTF_VARCHAR2_TABLE_100
49: , a7 out nocopy JTF_VARCHAR2_TABLE_100
50: , a8 out nocopy JTF_NUMBER_TABLE
51: , a9 out nocopy JTF_VARCHAR2_TABLE_100
52: , a10 out nocopy JTF_VARCHAR2_TABLE_100
53: ) as
47: , a5 out nocopy JTF_VARCHAR2_TABLE_100
48: , a6 out nocopy JTF_VARCHAR2_TABLE_100
49: , a7 out nocopy JTF_VARCHAR2_TABLE_100
50: , a8 out nocopy JTF_NUMBER_TABLE
51: , a9 out nocopy JTF_VARCHAR2_TABLE_100
52: , a10 out nocopy JTF_VARCHAR2_TABLE_100
53: ) as
54: ddindx binary_integer; indx binary_integer;
55: begin
48: , a6 out nocopy JTF_VARCHAR2_TABLE_100
49: , a7 out nocopy JTF_VARCHAR2_TABLE_100
50: , a8 out nocopy JTF_NUMBER_TABLE
51: , a9 out nocopy JTF_VARCHAR2_TABLE_100
52: , a10 out nocopy JTF_VARCHAR2_TABLE_100
53: ) as
54: ddindx binary_integer; indx binary_integer;
55: begin
56: if t is null or t.count = 0 then
57: a0 := JTF_NUMBER_TABLE();
58: a1 := JTF_NUMBER_TABLE();
59: a2 := JTF_NUMBER_TABLE();
60: a3 := JTF_NUMBER_TABLE();
61: a4 := JTF_VARCHAR2_TABLE_100();
62: a5 := JTF_VARCHAR2_TABLE_100();
63: a6 := JTF_VARCHAR2_TABLE_100();
64: a7 := JTF_VARCHAR2_TABLE_100();
65: a8 := JTF_NUMBER_TABLE();
58: a1 := JTF_NUMBER_TABLE();
59: a2 := JTF_NUMBER_TABLE();
60: a3 := JTF_NUMBER_TABLE();
61: a4 := JTF_VARCHAR2_TABLE_100();
62: a5 := JTF_VARCHAR2_TABLE_100();
63: a6 := JTF_VARCHAR2_TABLE_100();
64: a7 := JTF_VARCHAR2_TABLE_100();
65: a8 := JTF_NUMBER_TABLE();
66: a9 := JTF_VARCHAR2_TABLE_100();
59: a2 := JTF_NUMBER_TABLE();
60: a3 := JTF_NUMBER_TABLE();
61: a4 := JTF_VARCHAR2_TABLE_100();
62: a5 := JTF_VARCHAR2_TABLE_100();
63: a6 := JTF_VARCHAR2_TABLE_100();
64: a7 := JTF_VARCHAR2_TABLE_100();
65: a8 := JTF_NUMBER_TABLE();
66: a9 := JTF_VARCHAR2_TABLE_100();
67: a10 := JTF_VARCHAR2_TABLE_100();
60: a3 := JTF_NUMBER_TABLE();
61: a4 := JTF_VARCHAR2_TABLE_100();
62: a5 := JTF_VARCHAR2_TABLE_100();
63: a6 := JTF_VARCHAR2_TABLE_100();
64: a7 := JTF_VARCHAR2_TABLE_100();
65: a8 := JTF_NUMBER_TABLE();
66: a9 := JTF_VARCHAR2_TABLE_100();
67: a10 := JTF_VARCHAR2_TABLE_100();
68: else
62: a5 := JTF_VARCHAR2_TABLE_100();
63: a6 := JTF_VARCHAR2_TABLE_100();
64: a7 := JTF_VARCHAR2_TABLE_100();
65: a8 := JTF_NUMBER_TABLE();
66: a9 := JTF_VARCHAR2_TABLE_100();
67: a10 := JTF_VARCHAR2_TABLE_100();
68: else
69: a0 := JTF_NUMBER_TABLE();
70: a1 := JTF_NUMBER_TABLE();
63: a6 := JTF_VARCHAR2_TABLE_100();
64: a7 := JTF_VARCHAR2_TABLE_100();
65: a8 := JTF_NUMBER_TABLE();
66: a9 := JTF_VARCHAR2_TABLE_100();
67: a10 := JTF_VARCHAR2_TABLE_100();
68: else
69: a0 := JTF_NUMBER_TABLE();
70: a1 := JTF_NUMBER_TABLE();
71: a2 := JTF_NUMBER_TABLE();
69: a0 := JTF_NUMBER_TABLE();
70: a1 := JTF_NUMBER_TABLE();
71: a2 := JTF_NUMBER_TABLE();
72: a3 := JTF_NUMBER_TABLE();
73: a4 := JTF_VARCHAR2_TABLE_100();
74: a5 := JTF_VARCHAR2_TABLE_100();
75: a6 := JTF_VARCHAR2_TABLE_100();
76: a7 := JTF_VARCHAR2_TABLE_100();
77: a8 := JTF_NUMBER_TABLE();
70: a1 := JTF_NUMBER_TABLE();
71: a2 := JTF_NUMBER_TABLE();
72: a3 := JTF_NUMBER_TABLE();
73: a4 := JTF_VARCHAR2_TABLE_100();
74: a5 := JTF_VARCHAR2_TABLE_100();
75: a6 := JTF_VARCHAR2_TABLE_100();
76: a7 := JTF_VARCHAR2_TABLE_100();
77: a8 := JTF_NUMBER_TABLE();
78: a9 := JTF_VARCHAR2_TABLE_100();
71: a2 := JTF_NUMBER_TABLE();
72: a3 := JTF_NUMBER_TABLE();
73: a4 := JTF_VARCHAR2_TABLE_100();
74: a5 := JTF_VARCHAR2_TABLE_100();
75: a6 := JTF_VARCHAR2_TABLE_100();
76: a7 := JTF_VARCHAR2_TABLE_100();
77: a8 := JTF_NUMBER_TABLE();
78: a9 := JTF_VARCHAR2_TABLE_100();
79: a10 := JTF_VARCHAR2_TABLE_100();
72: a3 := JTF_NUMBER_TABLE();
73: a4 := JTF_VARCHAR2_TABLE_100();
74: a5 := JTF_VARCHAR2_TABLE_100();
75: a6 := JTF_VARCHAR2_TABLE_100();
76: a7 := JTF_VARCHAR2_TABLE_100();
77: a8 := JTF_NUMBER_TABLE();
78: a9 := JTF_VARCHAR2_TABLE_100();
79: a10 := JTF_VARCHAR2_TABLE_100();
80: if t.count > 0 then
74: a5 := JTF_VARCHAR2_TABLE_100();
75: a6 := JTF_VARCHAR2_TABLE_100();
76: a7 := JTF_VARCHAR2_TABLE_100();
77: a8 := JTF_NUMBER_TABLE();
78: a9 := JTF_VARCHAR2_TABLE_100();
79: a10 := JTF_VARCHAR2_TABLE_100();
80: if t.count > 0 then
81: a0.extend(t.count);
82: a1.extend(t.count);
75: a6 := JTF_VARCHAR2_TABLE_100();
76: a7 := JTF_VARCHAR2_TABLE_100();
77: a8 := JTF_NUMBER_TABLE();
78: a9 := JTF_VARCHAR2_TABLE_100();
79: a10 := JTF_VARCHAR2_TABLE_100();
80: if t.count > 0 then
81: a0.extend(t.count);
82: a1.extend(t.count);
83: a2.extend(t.count);
116: procedure rosetta_table_copy_in_p4(t out nocopy cn_calc_formulas_pvt.rt_assign_tbl_type, a0 JTF_NUMBER_TABLE
117: , a1 JTF_NUMBER_TABLE
118: , a2 JTF_DATE_TABLE
119: , a3 JTF_DATE_TABLE
120: , a4 JTF_VARCHAR2_TABLE_100
121: , a5 JTF_VARCHAR2_TABLE_100
122: , a6 JTF_NUMBER_TABLE
123: ) as
124: ddindx binary_integer; indx binary_integer;
117: , a1 JTF_NUMBER_TABLE
118: , a2 JTF_DATE_TABLE
119: , a3 JTF_DATE_TABLE
120: , a4 JTF_VARCHAR2_TABLE_100
121: , a5 JTF_VARCHAR2_TABLE_100
122: , a6 JTF_NUMBER_TABLE
123: ) as
124: ddindx binary_integer; indx binary_integer;
125: begin
147: procedure rosetta_table_copy_out_p4(t cn_calc_formulas_pvt.rt_assign_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
148: , a1 out nocopy JTF_NUMBER_TABLE
149: , a2 out nocopy JTF_DATE_TABLE
150: , a3 out nocopy JTF_DATE_TABLE
151: , a4 out nocopy JTF_VARCHAR2_TABLE_100
152: , a5 out nocopy JTF_VARCHAR2_TABLE_100
153: , a6 out nocopy JTF_NUMBER_TABLE
154: ) as
155: ddindx binary_integer; indx binary_integer;
148: , a1 out nocopy JTF_NUMBER_TABLE
149: , a2 out nocopy JTF_DATE_TABLE
150: , a3 out nocopy JTF_DATE_TABLE
151: , a4 out nocopy JTF_VARCHAR2_TABLE_100
152: , a5 out nocopy JTF_VARCHAR2_TABLE_100
153: , a6 out nocopy JTF_NUMBER_TABLE
154: ) as
155: ddindx binary_integer; indx binary_integer;
156: begin
158: a0 := JTF_NUMBER_TABLE();
159: a1 := JTF_NUMBER_TABLE();
160: a2 := JTF_DATE_TABLE();
161: a3 := JTF_DATE_TABLE();
162: a4 := JTF_VARCHAR2_TABLE_100();
163: a5 := JTF_VARCHAR2_TABLE_100();
164: a6 := JTF_NUMBER_TABLE();
165: else
166: a0 := JTF_NUMBER_TABLE();
159: a1 := JTF_NUMBER_TABLE();
160: a2 := JTF_DATE_TABLE();
161: a3 := JTF_DATE_TABLE();
162: a4 := JTF_VARCHAR2_TABLE_100();
163: a5 := JTF_VARCHAR2_TABLE_100();
164: a6 := JTF_NUMBER_TABLE();
165: else
166: a0 := JTF_NUMBER_TABLE();
167: a1 := JTF_NUMBER_TABLE();
166: a0 := JTF_NUMBER_TABLE();
167: a1 := JTF_NUMBER_TABLE();
168: a2 := JTF_DATE_TABLE();
169: a3 := JTF_DATE_TABLE();
170: a4 := JTF_VARCHAR2_TABLE_100();
171: a5 := JTF_VARCHAR2_TABLE_100();
172: a6 := JTF_NUMBER_TABLE();
173: if t.count > 0 then
174: a0.extend(t.count);
167: a1 := JTF_NUMBER_TABLE();
168: a2 := JTF_DATE_TABLE();
169: a3 := JTF_DATE_TABLE();
170: a4 := JTF_VARCHAR2_TABLE_100();
171: a5 := JTF_VARCHAR2_TABLE_100();
172: a6 := JTF_NUMBER_TABLE();
173: if t.count > 0 then
174: a0.extend(t.count);
175: a1.extend(t.count);
197: end if;
198: end if;
199: end rosetta_table_copy_out_p4;
200:
201: procedure rosetta_table_copy_in_p5(t out nocopy cn_calc_formulas_pvt.parent_expression_tbl_type, a0 JTF_VARCHAR2_TABLE_100) as
202: ddindx binary_integer; indx binary_integer;
203: begin
204: if a0 is not null and a0.count > 0 then
205: if a0.count > 0 then
215: end loop;
216: end if;
217: end if;
218: end rosetta_table_copy_in_p5;
219: procedure rosetta_table_copy_out_p5(t cn_calc_formulas_pvt.parent_expression_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100) as
220: ddindx binary_integer; indx binary_integer;
221: begin
222: if t is null or t.count = 0 then
223: a0 := JTF_VARCHAR2_TABLE_100();
219: procedure rosetta_table_copy_out_p5(t cn_calc_formulas_pvt.parent_expression_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100) as
220: ddindx binary_integer; indx binary_integer;
221: begin
222: if t is null or t.count = 0 then
223: a0 := JTF_VARCHAR2_TABLE_100();
224: else
225: a0 := JTF_VARCHAR2_TABLE_100();
226: if t.count > 0 then
227: a0.extend(t.count);
221: begin
222: if t is null or t.count = 0 then
223: a0 := JTF_VARCHAR2_TABLE_100();
224: else
225: a0 := JTF_VARCHAR2_TABLE_100();
226: if t.count > 0 then
227: a0.extend(t.count);
228: ddindx := t.first;
229: indx := 1;
239: end if;
240: end rosetta_table_copy_out_p5;
241:
242: procedure rosetta_table_copy_in_p6(t out nocopy cn_calc_formulas_pvt.formula_tbl_type, a0 JTF_NUMBER_TABLE
243: , a1 JTF_VARCHAR2_TABLE_100
244: , a2 JTF_VARCHAR2_TABLE_100
245: , a3 JTF_VARCHAR2_TABLE_100
246: , a4 JTF_VARCHAR2_TABLE_100
247: , a5 JTF_VARCHAR2_TABLE_100
240: end rosetta_table_copy_out_p5;
241:
242: procedure rosetta_table_copy_in_p6(t out nocopy cn_calc_formulas_pvt.formula_tbl_type, a0 JTF_NUMBER_TABLE
243: , a1 JTF_VARCHAR2_TABLE_100
244: , a2 JTF_VARCHAR2_TABLE_100
245: , a3 JTF_VARCHAR2_TABLE_100
246: , a4 JTF_VARCHAR2_TABLE_100
247: , a5 JTF_VARCHAR2_TABLE_100
248: , a6 JTF_NUMBER_TABLE
241:
242: procedure rosetta_table_copy_in_p6(t out nocopy cn_calc_formulas_pvt.formula_tbl_type, a0 JTF_NUMBER_TABLE
243: , a1 JTF_VARCHAR2_TABLE_100
244: , a2 JTF_VARCHAR2_TABLE_100
245: , a3 JTF_VARCHAR2_TABLE_100
246: , a4 JTF_VARCHAR2_TABLE_100
247: , a5 JTF_VARCHAR2_TABLE_100
248: , a6 JTF_NUMBER_TABLE
249: , a7 JTF_VARCHAR2_TABLE_100
242: procedure rosetta_table_copy_in_p6(t out nocopy cn_calc_formulas_pvt.formula_tbl_type, a0 JTF_NUMBER_TABLE
243: , a1 JTF_VARCHAR2_TABLE_100
244: , a2 JTF_VARCHAR2_TABLE_100
245: , a3 JTF_VARCHAR2_TABLE_100
246: , a4 JTF_VARCHAR2_TABLE_100
247: , a5 JTF_VARCHAR2_TABLE_100
248: , a6 JTF_NUMBER_TABLE
249: , a7 JTF_VARCHAR2_TABLE_100
250: , a8 JTF_VARCHAR2_TABLE_100
243: , a1 JTF_VARCHAR2_TABLE_100
244: , a2 JTF_VARCHAR2_TABLE_100
245: , a3 JTF_VARCHAR2_TABLE_100
246: , a4 JTF_VARCHAR2_TABLE_100
247: , a5 JTF_VARCHAR2_TABLE_100
248: , a6 JTF_NUMBER_TABLE
249: , a7 JTF_VARCHAR2_TABLE_100
250: , a8 JTF_VARCHAR2_TABLE_100
251: , a9 JTF_VARCHAR2_TABLE_100
245: , a3 JTF_VARCHAR2_TABLE_100
246: , a4 JTF_VARCHAR2_TABLE_100
247: , a5 JTF_VARCHAR2_TABLE_100
248: , a6 JTF_NUMBER_TABLE
249: , a7 JTF_VARCHAR2_TABLE_100
250: , a8 JTF_VARCHAR2_TABLE_100
251: , a9 JTF_VARCHAR2_TABLE_100
252: , a10 JTF_VARCHAR2_TABLE_100
253: , a11 JTF_VARCHAR2_TABLE_100
246: , a4 JTF_VARCHAR2_TABLE_100
247: , a5 JTF_VARCHAR2_TABLE_100
248: , a6 JTF_NUMBER_TABLE
249: , a7 JTF_VARCHAR2_TABLE_100
250: , a8 JTF_VARCHAR2_TABLE_100
251: , a9 JTF_VARCHAR2_TABLE_100
252: , a10 JTF_VARCHAR2_TABLE_100
253: , a11 JTF_VARCHAR2_TABLE_100
254: , a12 JTF_NUMBER_TABLE
247: , a5 JTF_VARCHAR2_TABLE_100
248: , a6 JTF_NUMBER_TABLE
249: , a7 JTF_VARCHAR2_TABLE_100
250: , a8 JTF_VARCHAR2_TABLE_100
251: , a9 JTF_VARCHAR2_TABLE_100
252: , a10 JTF_VARCHAR2_TABLE_100
253: , a11 JTF_VARCHAR2_TABLE_100
254: , a12 JTF_NUMBER_TABLE
255: , a13 JTF_NUMBER_TABLE
248: , a6 JTF_NUMBER_TABLE
249: , a7 JTF_VARCHAR2_TABLE_100
250: , a8 JTF_VARCHAR2_TABLE_100
251: , a9 JTF_VARCHAR2_TABLE_100
252: , a10 JTF_VARCHAR2_TABLE_100
253: , a11 JTF_VARCHAR2_TABLE_100
254: , a12 JTF_NUMBER_TABLE
255: , a13 JTF_NUMBER_TABLE
256: , a14 JTF_NUMBER_TABLE
249: , a7 JTF_VARCHAR2_TABLE_100
250: , a8 JTF_VARCHAR2_TABLE_100
251: , a9 JTF_VARCHAR2_TABLE_100
252: , a10 JTF_VARCHAR2_TABLE_100
253: , a11 JTF_VARCHAR2_TABLE_100
254: , a12 JTF_NUMBER_TABLE
255: , a13 JTF_NUMBER_TABLE
256: , a14 JTF_NUMBER_TABLE
257: , a15 JTF_NUMBER_TABLE
288: end if;
289: end if;
290: end rosetta_table_copy_in_p6;
291: procedure rosetta_table_copy_out_p6(t cn_calc_formulas_pvt.formula_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
292: , a1 out nocopy JTF_VARCHAR2_TABLE_100
293: , a2 out nocopy JTF_VARCHAR2_TABLE_100
294: , a3 out nocopy JTF_VARCHAR2_TABLE_100
295: , a4 out nocopy JTF_VARCHAR2_TABLE_100
296: , a5 out nocopy JTF_VARCHAR2_TABLE_100
289: end if;
290: end rosetta_table_copy_in_p6;
291: procedure rosetta_table_copy_out_p6(t cn_calc_formulas_pvt.formula_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
292: , a1 out nocopy JTF_VARCHAR2_TABLE_100
293: , a2 out nocopy JTF_VARCHAR2_TABLE_100
294: , a3 out nocopy JTF_VARCHAR2_TABLE_100
295: , a4 out nocopy JTF_VARCHAR2_TABLE_100
296: , a5 out nocopy JTF_VARCHAR2_TABLE_100
297: , a6 out nocopy JTF_NUMBER_TABLE
290: end rosetta_table_copy_in_p6;
291: procedure rosetta_table_copy_out_p6(t cn_calc_formulas_pvt.formula_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
292: , a1 out nocopy JTF_VARCHAR2_TABLE_100
293: , a2 out nocopy JTF_VARCHAR2_TABLE_100
294: , a3 out nocopy JTF_VARCHAR2_TABLE_100
295: , a4 out nocopy JTF_VARCHAR2_TABLE_100
296: , a5 out nocopy JTF_VARCHAR2_TABLE_100
297: , a6 out nocopy JTF_NUMBER_TABLE
298: , a7 out nocopy JTF_VARCHAR2_TABLE_100
291: procedure rosetta_table_copy_out_p6(t cn_calc_formulas_pvt.formula_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
292: , a1 out nocopy JTF_VARCHAR2_TABLE_100
293: , a2 out nocopy JTF_VARCHAR2_TABLE_100
294: , a3 out nocopy JTF_VARCHAR2_TABLE_100
295: , a4 out nocopy JTF_VARCHAR2_TABLE_100
296: , a5 out nocopy JTF_VARCHAR2_TABLE_100
297: , a6 out nocopy JTF_NUMBER_TABLE
298: , a7 out nocopy JTF_VARCHAR2_TABLE_100
299: , a8 out nocopy JTF_VARCHAR2_TABLE_100
292: , a1 out nocopy JTF_VARCHAR2_TABLE_100
293: , a2 out nocopy JTF_VARCHAR2_TABLE_100
294: , a3 out nocopy JTF_VARCHAR2_TABLE_100
295: , a4 out nocopy JTF_VARCHAR2_TABLE_100
296: , a5 out nocopy JTF_VARCHAR2_TABLE_100
297: , a6 out nocopy JTF_NUMBER_TABLE
298: , a7 out nocopy JTF_VARCHAR2_TABLE_100
299: , a8 out nocopy JTF_VARCHAR2_TABLE_100
300: , a9 out nocopy JTF_VARCHAR2_TABLE_100
294: , a3 out nocopy JTF_VARCHAR2_TABLE_100
295: , a4 out nocopy JTF_VARCHAR2_TABLE_100
296: , a5 out nocopy JTF_VARCHAR2_TABLE_100
297: , a6 out nocopy JTF_NUMBER_TABLE
298: , a7 out nocopy JTF_VARCHAR2_TABLE_100
299: , a8 out nocopy JTF_VARCHAR2_TABLE_100
300: , a9 out nocopy JTF_VARCHAR2_TABLE_100
301: , a10 out nocopy JTF_VARCHAR2_TABLE_100
302: , a11 out nocopy JTF_VARCHAR2_TABLE_100
295: , a4 out nocopy JTF_VARCHAR2_TABLE_100
296: , a5 out nocopy JTF_VARCHAR2_TABLE_100
297: , a6 out nocopy JTF_NUMBER_TABLE
298: , a7 out nocopy JTF_VARCHAR2_TABLE_100
299: , a8 out nocopy JTF_VARCHAR2_TABLE_100
300: , a9 out nocopy JTF_VARCHAR2_TABLE_100
301: , a10 out nocopy JTF_VARCHAR2_TABLE_100
302: , a11 out nocopy JTF_VARCHAR2_TABLE_100
303: , a12 out nocopy JTF_NUMBER_TABLE
296: , a5 out nocopy JTF_VARCHAR2_TABLE_100
297: , a6 out nocopy JTF_NUMBER_TABLE
298: , a7 out nocopy JTF_VARCHAR2_TABLE_100
299: , a8 out nocopy JTF_VARCHAR2_TABLE_100
300: , a9 out nocopy JTF_VARCHAR2_TABLE_100
301: , a10 out nocopy JTF_VARCHAR2_TABLE_100
302: , a11 out nocopy JTF_VARCHAR2_TABLE_100
303: , a12 out nocopy JTF_NUMBER_TABLE
304: , a13 out nocopy JTF_NUMBER_TABLE
297: , a6 out nocopy JTF_NUMBER_TABLE
298: , a7 out nocopy JTF_VARCHAR2_TABLE_100
299: , a8 out nocopy JTF_VARCHAR2_TABLE_100
300: , a9 out nocopy JTF_VARCHAR2_TABLE_100
301: , a10 out nocopy JTF_VARCHAR2_TABLE_100
302: , a11 out nocopy JTF_VARCHAR2_TABLE_100
303: , a12 out nocopy JTF_NUMBER_TABLE
304: , a13 out nocopy JTF_NUMBER_TABLE
305: , a14 out nocopy JTF_NUMBER_TABLE
298: , a7 out nocopy JTF_VARCHAR2_TABLE_100
299: , a8 out nocopy JTF_VARCHAR2_TABLE_100
300: , a9 out nocopy JTF_VARCHAR2_TABLE_100
301: , a10 out nocopy JTF_VARCHAR2_TABLE_100
302: , a11 out nocopy JTF_VARCHAR2_TABLE_100
303: , a12 out nocopy JTF_NUMBER_TABLE
304: , a13 out nocopy JTF_NUMBER_TABLE
305: , a14 out nocopy JTF_NUMBER_TABLE
306: , a15 out nocopy JTF_NUMBER_TABLE
308: ddindx binary_integer; indx binary_integer;
309: begin
310: if t is null or t.count = 0 then
311: a0 := JTF_NUMBER_TABLE();
312: a1 := JTF_VARCHAR2_TABLE_100();
313: a2 := JTF_VARCHAR2_TABLE_100();
314: a3 := JTF_VARCHAR2_TABLE_100();
315: a4 := JTF_VARCHAR2_TABLE_100();
316: a5 := JTF_VARCHAR2_TABLE_100();
309: begin
310: if t is null or t.count = 0 then
311: a0 := JTF_NUMBER_TABLE();
312: a1 := JTF_VARCHAR2_TABLE_100();
313: a2 := JTF_VARCHAR2_TABLE_100();
314: a3 := JTF_VARCHAR2_TABLE_100();
315: a4 := JTF_VARCHAR2_TABLE_100();
316: a5 := JTF_VARCHAR2_TABLE_100();
317: a6 := JTF_NUMBER_TABLE();
310: if t is null or t.count = 0 then
311: a0 := JTF_NUMBER_TABLE();
312: a1 := JTF_VARCHAR2_TABLE_100();
313: a2 := JTF_VARCHAR2_TABLE_100();
314: a3 := JTF_VARCHAR2_TABLE_100();
315: a4 := JTF_VARCHAR2_TABLE_100();
316: a5 := JTF_VARCHAR2_TABLE_100();
317: a6 := JTF_NUMBER_TABLE();
318: a7 := JTF_VARCHAR2_TABLE_100();
311: a0 := JTF_NUMBER_TABLE();
312: a1 := JTF_VARCHAR2_TABLE_100();
313: a2 := JTF_VARCHAR2_TABLE_100();
314: a3 := JTF_VARCHAR2_TABLE_100();
315: a4 := JTF_VARCHAR2_TABLE_100();
316: a5 := JTF_VARCHAR2_TABLE_100();
317: a6 := JTF_NUMBER_TABLE();
318: a7 := JTF_VARCHAR2_TABLE_100();
319: a8 := JTF_VARCHAR2_TABLE_100();
312: a1 := JTF_VARCHAR2_TABLE_100();
313: a2 := JTF_VARCHAR2_TABLE_100();
314: a3 := JTF_VARCHAR2_TABLE_100();
315: a4 := JTF_VARCHAR2_TABLE_100();
316: a5 := JTF_VARCHAR2_TABLE_100();
317: a6 := JTF_NUMBER_TABLE();
318: a7 := JTF_VARCHAR2_TABLE_100();
319: a8 := JTF_VARCHAR2_TABLE_100();
320: a9 := JTF_VARCHAR2_TABLE_100();
314: a3 := JTF_VARCHAR2_TABLE_100();
315: a4 := JTF_VARCHAR2_TABLE_100();
316: a5 := JTF_VARCHAR2_TABLE_100();
317: a6 := JTF_NUMBER_TABLE();
318: a7 := JTF_VARCHAR2_TABLE_100();
319: a8 := JTF_VARCHAR2_TABLE_100();
320: a9 := JTF_VARCHAR2_TABLE_100();
321: a10 := JTF_VARCHAR2_TABLE_100();
322: a11 := JTF_VARCHAR2_TABLE_100();
315: a4 := JTF_VARCHAR2_TABLE_100();
316: a5 := JTF_VARCHAR2_TABLE_100();
317: a6 := JTF_NUMBER_TABLE();
318: a7 := JTF_VARCHAR2_TABLE_100();
319: a8 := JTF_VARCHAR2_TABLE_100();
320: a9 := JTF_VARCHAR2_TABLE_100();
321: a10 := JTF_VARCHAR2_TABLE_100();
322: a11 := JTF_VARCHAR2_TABLE_100();
323: a12 := JTF_NUMBER_TABLE();
316: a5 := JTF_VARCHAR2_TABLE_100();
317: a6 := JTF_NUMBER_TABLE();
318: a7 := JTF_VARCHAR2_TABLE_100();
319: a8 := JTF_VARCHAR2_TABLE_100();
320: a9 := JTF_VARCHAR2_TABLE_100();
321: a10 := JTF_VARCHAR2_TABLE_100();
322: a11 := JTF_VARCHAR2_TABLE_100();
323: a12 := JTF_NUMBER_TABLE();
324: a13 := JTF_NUMBER_TABLE();
317: a6 := JTF_NUMBER_TABLE();
318: a7 := JTF_VARCHAR2_TABLE_100();
319: a8 := JTF_VARCHAR2_TABLE_100();
320: a9 := JTF_VARCHAR2_TABLE_100();
321: a10 := JTF_VARCHAR2_TABLE_100();
322: a11 := JTF_VARCHAR2_TABLE_100();
323: a12 := JTF_NUMBER_TABLE();
324: a13 := JTF_NUMBER_TABLE();
325: a14 := JTF_NUMBER_TABLE();
318: a7 := JTF_VARCHAR2_TABLE_100();
319: a8 := JTF_VARCHAR2_TABLE_100();
320: a9 := JTF_VARCHAR2_TABLE_100();
321: a10 := JTF_VARCHAR2_TABLE_100();
322: a11 := JTF_VARCHAR2_TABLE_100();
323: a12 := JTF_NUMBER_TABLE();
324: a13 := JTF_NUMBER_TABLE();
325: a14 := JTF_NUMBER_TABLE();
326: a15 := JTF_NUMBER_TABLE();
325: a14 := JTF_NUMBER_TABLE();
326: a15 := JTF_NUMBER_TABLE();
327: else
328: a0 := JTF_NUMBER_TABLE();
329: a1 := JTF_VARCHAR2_TABLE_100();
330: a2 := JTF_VARCHAR2_TABLE_100();
331: a3 := JTF_VARCHAR2_TABLE_100();
332: a4 := JTF_VARCHAR2_TABLE_100();
333: a5 := JTF_VARCHAR2_TABLE_100();
326: a15 := JTF_NUMBER_TABLE();
327: else
328: a0 := JTF_NUMBER_TABLE();
329: a1 := JTF_VARCHAR2_TABLE_100();
330: a2 := JTF_VARCHAR2_TABLE_100();
331: a3 := JTF_VARCHAR2_TABLE_100();
332: a4 := JTF_VARCHAR2_TABLE_100();
333: a5 := JTF_VARCHAR2_TABLE_100();
334: a6 := JTF_NUMBER_TABLE();
327: else
328: a0 := JTF_NUMBER_TABLE();
329: a1 := JTF_VARCHAR2_TABLE_100();
330: a2 := JTF_VARCHAR2_TABLE_100();
331: a3 := JTF_VARCHAR2_TABLE_100();
332: a4 := JTF_VARCHAR2_TABLE_100();
333: a5 := JTF_VARCHAR2_TABLE_100();
334: a6 := JTF_NUMBER_TABLE();
335: a7 := JTF_VARCHAR2_TABLE_100();
328: a0 := JTF_NUMBER_TABLE();
329: a1 := JTF_VARCHAR2_TABLE_100();
330: a2 := JTF_VARCHAR2_TABLE_100();
331: a3 := JTF_VARCHAR2_TABLE_100();
332: a4 := JTF_VARCHAR2_TABLE_100();
333: a5 := JTF_VARCHAR2_TABLE_100();
334: a6 := JTF_NUMBER_TABLE();
335: a7 := JTF_VARCHAR2_TABLE_100();
336: a8 := JTF_VARCHAR2_TABLE_100();
329: a1 := JTF_VARCHAR2_TABLE_100();
330: a2 := JTF_VARCHAR2_TABLE_100();
331: a3 := JTF_VARCHAR2_TABLE_100();
332: a4 := JTF_VARCHAR2_TABLE_100();
333: a5 := JTF_VARCHAR2_TABLE_100();
334: a6 := JTF_NUMBER_TABLE();
335: a7 := JTF_VARCHAR2_TABLE_100();
336: a8 := JTF_VARCHAR2_TABLE_100();
337: a9 := JTF_VARCHAR2_TABLE_100();
331: a3 := JTF_VARCHAR2_TABLE_100();
332: a4 := JTF_VARCHAR2_TABLE_100();
333: a5 := JTF_VARCHAR2_TABLE_100();
334: a6 := JTF_NUMBER_TABLE();
335: a7 := JTF_VARCHAR2_TABLE_100();
336: a8 := JTF_VARCHAR2_TABLE_100();
337: a9 := JTF_VARCHAR2_TABLE_100();
338: a10 := JTF_VARCHAR2_TABLE_100();
339: a11 := JTF_VARCHAR2_TABLE_100();
332: a4 := JTF_VARCHAR2_TABLE_100();
333: a5 := JTF_VARCHAR2_TABLE_100();
334: a6 := JTF_NUMBER_TABLE();
335: a7 := JTF_VARCHAR2_TABLE_100();
336: a8 := JTF_VARCHAR2_TABLE_100();
337: a9 := JTF_VARCHAR2_TABLE_100();
338: a10 := JTF_VARCHAR2_TABLE_100();
339: a11 := JTF_VARCHAR2_TABLE_100();
340: a12 := JTF_NUMBER_TABLE();
333: a5 := JTF_VARCHAR2_TABLE_100();
334: a6 := JTF_NUMBER_TABLE();
335: a7 := JTF_VARCHAR2_TABLE_100();
336: a8 := JTF_VARCHAR2_TABLE_100();
337: a9 := JTF_VARCHAR2_TABLE_100();
338: a10 := JTF_VARCHAR2_TABLE_100();
339: a11 := JTF_VARCHAR2_TABLE_100();
340: a12 := JTF_NUMBER_TABLE();
341: a13 := JTF_NUMBER_TABLE();
334: a6 := JTF_NUMBER_TABLE();
335: a7 := JTF_VARCHAR2_TABLE_100();
336: a8 := JTF_VARCHAR2_TABLE_100();
337: a9 := JTF_VARCHAR2_TABLE_100();
338: a10 := JTF_VARCHAR2_TABLE_100();
339: a11 := JTF_VARCHAR2_TABLE_100();
340: a12 := JTF_NUMBER_TABLE();
341: a13 := JTF_NUMBER_TABLE();
342: a14 := JTF_NUMBER_TABLE();
335: a7 := JTF_VARCHAR2_TABLE_100();
336: a8 := JTF_VARCHAR2_TABLE_100();
337: a9 := JTF_VARCHAR2_TABLE_100();
338: a10 := JTF_VARCHAR2_TABLE_100();
339: a11 := JTF_VARCHAR2_TABLE_100();
340: a12 := JTF_NUMBER_TABLE();
341: a13 := JTF_NUMBER_TABLE();
342: a14 := JTF_NUMBER_TABLE();
343: a15 := JTF_NUMBER_TABLE();
408: , p18_a0 JTF_NUMBER_TABLE
409: , p18_a1 JTF_NUMBER_TABLE
410: , p18_a2 JTF_NUMBER_TABLE
411: , p18_a3 JTF_NUMBER_TABLE
412: , p18_a4 JTF_VARCHAR2_TABLE_100
413: , p18_a5 JTF_VARCHAR2_TABLE_100
414: , p18_a6 JTF_VARCHAR2_TABLE_100
415: , p18_a7 JTF_VARCHAR2_TABLE_100
416: , p18_a8 JTF_NUMBER_TABLE
409: , p18_a1 JTF_NUMBER_TABLE
410: , p18_a2 JTF_NUMBER_TABLE
411: , p18_a3 JTF_NUMBER_TABLE
412: , p18_a4 JTF_VARCHAR2_TABLE_100
413: , p18_a5 JTF_VARCHAR2_TABLE_100
414: , p18_a6 JTF_VARCHAR2_TABLE_100
415: , p18_a7 JTF_VARCHAR2_TABLE_100
416: , p18_a8 JTF_NUMBER_TABLE
417: , p18_a9 JTF_VARCHAR2_TABLE_100
410: , p18_a2 JTF_NUMBER_TABLE
411: , p18_a3 JTF_NUMBER_TABLE
412: , p18_a4 JTF_VARCHAR2_TABLE_100
413: , p18_a5 JTF_VARCHAR2_TABLE_100
414: , p18_a6 JTF_VARCHAR2_TABLE_100
415: , p18_a7 JTF_VARCHAR2_TABLE_100
416: , p18_a8 JTF_NUMBER_TABLE
417: , p18_a9 JTF_VARCHAR2_TABLE_100
418: , p18_a10 JTF_VARCHAR2_TABLE_100
411: , p18_a3 JTF_NUMBER_TABLE
412: , p18_a4 JTF_VARCHAR2_TABLE_100
413: , p18_a5 JTF_VARCHAR2_TABLE_100
414: , p18_a6 JTF_VARCHAR2_TABLE_100
415: , p18_a7 JTF_VARCHAR2_TABLE_100
416: , p18_a8 JTF_NUMBER_TABLE
417: , p18_a9 JTF_VARCHAR2_TABLE_100
418: , p18_a10 JTF_VARCHAR2_TABLE_100
419: , p19_a0 JTF_NUMBER_TABLE
413: , p18_a5 JTF_VARCHAR2_TABLE_100
414: , p18_a6 JTF_VARCHAR2_TABLE_100
415: , p18_a7 JTF_VARCHAR2_TABLE_100
416: , p18_a8 JTF_NUMBER_TABLE
417: , p18_a9 JTF_VARCHAR2_TABLE_100
418: , p18_a10 JTF_VARCHAR2_TABLE_100
419: , p19_a0 JTF_NUMBER_TABLE
420: , p19_a1 JTF_NUMBER_TABLE
421: , p19_a2 JTF_DATE_TABLE
414: , p18_a6 JTF_VARCHAR2_TABLE_100
415: , p18_a7 JTF_VARCHAR2_TABLE_100
416: , p18_a8 JTF_NUMBER_TABLE
417: , p18_a9 JTF_VARCHAR2_TABLE_100
418: , p18_a10 JTF_VARCHAR2_TABLE_100
419: , p19_a0 JTF_NUMBER_TABLE
420: , p19_a1 JTF_NUMBER_TABLE
421: , p19_a2 JTF_DATE_TABLE
422: , p19_a3 JTF_DATE_TABLE
419: , p19_a0 JTF_NUMBER_TABLE
420: , p19_a1 JTF_NUMBER_TABLE
421: , p19_a2 JTF_DATE_TABLE
422: , p19_a3 JTF_DATE_TABLE
423: , p19_a4 JTF_VARCHAR2_TABLE_100
424: , p19_a5 JTF_VARCHAR2_TABLE_100
425: , p19_a6 JTF_NUMBER_TABLE
426: , p_org_id NUMBER
427: , x_calc_formula_id in out nocopy NUMBER
420: , p19_a1 JTF_NUMBER_TABLE
421: , p19_a2 JTF_DATE_TABLE
422: , p19_a3 JTF_DATE_TABLE
423: , p19_a4 JTF_VARCHAR2_TABLE_100
424: , p19_a5 JTF_VARCHAR2_TABLE_100
425: , p19_a6 JTF_NUMBER_TABLE
426: , p_org_id NUMBER
427: , x_calc_formula_id in out nocopy NUMBER
428: , x_formula_status out nocopy VARCHAR2
563: , p20_a0 JTF_NUMBER_TABLE
564: , p20_a1 JTF_NUMBER_TABLE
565: , p20_a2 JTF_NUMBER_TABLE
566: , p20_a3 JTF_NUMBER_TABLE
567: , p20_a4 JTF_VARCHAR2_TABLE_100
568: , p20_a5 JTF_VARCHAR2_TABLE_100
569: , p20_a6 JTF_VARCHAR2_TABLE_100
570: , p20_a7 JTF_VARCHAR2_TABLE_100
571: , p20_a8 JTF_NUMBER_TABLE
564: , p20_a1 JTF_NUMBER_TABLE
565: , p20_a2 JTF_NUMBER_TABLE
566: , p20_a3 JTF_NUMBER_TABLE
567: , p20_a4 JTF_VARCHAR2_TABLE_100
568: , p20_a5 JTF_VARCHAR2_TABLE_100
569: , p20_a6 JTF_VARCHAR2_TABLE_100
570: , p20_a7 JTF_VARCHAR2_TABLE_100
571: , p20_a8 JTF_NUMBER_TABLE
572: , p20_a9 JTF_VARCHAR2_TABLE_100
565: , p20_a2 JTF_NUMBER_TABLE
566: , p20_a3 JTF_NUMBER_TABLE
567: , p20_a4 JTF_VARCHAR2_TABLE_100
568: , p20_a5 JTF_VARCHAR2_TABLE_100
569: , p20_a6 JTF_VARCHAR2_TABLE_100
570: , p20_a7 JTF_VARCHAR2_TABLE_100
571: , p20_a8 JTF_NUMBER_TABLE
572: , p20_a9 JTF_VARCHAR2_TABLE_100
573: , p20_a10 JTF_VARCHAR2_TABLE_100
566: , p20_a3 JTF_NUMBER_TABLE
567: , p20_a4 JTF_VARCHAR2_TABLE_100
568: , p20_a5 JTF_VARCHAR2_TABLE_100
569: , p20_a6 JTF_VARCHAR2_TABLE_100
570: , p20_a7 JTF_VARCHAR2_TABLE_100
571: , p20_a8 JTF_NUMBER_TABLE
572: , p20_a9 JTF_VARCHAR2_TABLE_100
573: , p20_a10 JTF_VARCHAR2_TABLE_100
574: , p21_a0 JTF_NUMBER_TABLE
568: , p20_a5 JTF_VARCHAR2_TABLE_100
569: , p20_a6 JTF_VARCHAR2_TABLE_100
570: , p20_a7 JTF_VARCHAR2_TABLE_100
571: , p20_a8 JTF_NUMBER_TABLE
572: , p20_a9 JTF_VARCHAR2_TABLE_100
573: , p20_a10 JTF_VARCHAR2_TABLE_100
574: , p21_a0 JTF_NUMBER_TABLE
575: , p21_a1 JTF_NUMBER_TABLE
576: , p21_a2 JTF_DATE_TABLE
569: , p20_a6 JTF_VARCHAR2_TABLE_100
570: , p20_a7 JTF_VARCHAR2_TABLE_100
571: , p20_a8 JTF_NUMBER_TABLE
572: , p20_a9 JTF_VARCHAR2_TABLE_100
573: , p20_a10 JTF_VARCHAR2_TABLE_100
574: , p21_a0 JTF_NUMBER_TABLE
575: , p21_a1 JTF_NUMBER_TABLE
576: , p21_a2 JTF_DATE_TABLE
577: , p21_a3 JTF_DATE_TABLE
574: , p21_a0 JTF_NUMBER_TABLE
575: , p21_a1 JTF_NUMBER_TABLE
576: , p21_a2 JTF_DATE_TABLE
577: , p21_a3 JTF_DATE_TABLE
578: , p21_a4 JTF_VARCHAR2_TABLE_100
579: , p21_a5 JTF_VARCHAR2_TABLE_100
580: , p21_a6 JTF_NUMBER_TABLE
581: , p_org_id NUMBER
582: , p_object_version_number in out nocopy NUMBER
575: , p21_a1 JTF_NUMBER_TABLE
576: , p21_a2 JTF_DATE_TABLE
577: , p21_a3 JTF_DATE_TABLE
578: , p21_a4 JTF_VARCHAR2_TABLE_100
579: , p21_a5 JTF_VARCHAR2_TABLE_100
580: , p21_a6 JTF_NUMBER_TABLE
581: , p_org_id NUMBER
582: , p_object_version_number in out nocopy NUMBER
583: , x_formula_status out nocopy VARCHAR2