21: if n=b then return a; end if;
22: return n;
23: end;
24:
25: procedure rosetta_table_copy_in_p1(t out nocopy cse_deployment_grp.txn_instances_tbl, a0 JTF_NUMBER_TABLE
26: , a1 JTF_VARCHAR2_TABLE_100
27: , a2 JTF_VARCHAR2_TABLE_100
28: , a3 JTF_VARCHAR2_TABLE_100
29: , a4 JTF_NUMBER_TABLE
25: procedure rosetta_table_copy_in_p1(t out nocopy cse_deployment_grp.txn_instances_tbl, a0 JTF_NUMBER_TABLE
26: , a1 JTF_VARCHAR2_TABLE_100
27: , a2 JTF_VARCHAR2_TABLE_100
28: , a3 JTF_VARCHAR2_TABLE_100
29: , a4 JTF_NUMBER_TABLE
30: , a5 JTF_NUMBER_TABLE
31: , a6 JTF_NUMBER_TABLE
32: , a7 JTF_VARCHAR2_TABLE_100
33: , a8 JTF_DATE_TABLE
26: , a1 JTF_VARCHAR2_TABLE_100
27: , a2 JTF_VARCHAR2_TABLE_100
28: , a3 JTF_VARCHAR2_TABLE_100
29: , a4 JTF_NUMBER_TABLE
30: , a5 JTF_NUMBER_TABLE
31: , a6 JTF_NUMBER_TABLE
32: , a7 JTF_VARCHAR2_TABLE_100
33: , a8 JTF_DATE_TABLE
34: , a9 JTF_DATE_TABLE
27: , a2 JTF_VARCHAR2_TABLE_100
28: , a3 JTF_VARCHAR2_TABLE_100
29: , a4 JTF_NUMBER_TABLE
30: , a5 JTF_NUMBER_TABLE
31: , a6 JTF_NUMBER_TABLE
32: , a7 JTF_VARCHAR2_TABLE_100
33: , a8 JTF_DATE_TABLE
34: , a9 JTF_DATE_TABLE
35: , a10 JTF_NUMBER_TABLE
31: , a6 JTF_NUMBER_TABLE
32: , a7 JTF_VARCHAR2_TABLE_100
33: , a8 JTF_DATE_TABLE
34: , a9 JTF_DATE_TABLE
35: , a10 JTF_NUMBER_TABLE
36: , a11 JTF_VARCHAR2_TABLE_100
37: , a12 JTF_NUMBER_TABLE
38: ) as
39: ddindx binary_integer; indx binary_integer;
33: , a8 JTF_DATE_TABLE
34: , a9 JTF_DATE_TABLE
35: , a10 JTF_NUMBER_TABLE
36: , a11 JTF_VARCHAR2_TABLE_100
37: , a12 JTF_NUMBER_TABLE
38: ) as
39: ddindx binary_integer; indx binary_integer;
40: begin
41: if a0 is not null and a0.count > 0 then
64: end loop;
65: end if;
66: end if;
67: end rosetta_table_copy_in_p1;
68: procedure rosetta_table_copy_out_p1(t cse_deployment_grp.txn_instances_tbl, a0 out nocopy JTF_NUMBER_TABLE
69: , a1 out nocopy JTF_VARCHAR2_TABLE_100
70: , a2 out nocopy JTF_VARCHAR2_TABLE_100
71: , a3 out nocopy JTF_VARCHAR2_TABLE_100
72: , a4 out nocopy JTF_NUMBER_TABLE
68: procedure rosetta_table_copy_out_p1(t cse_deployment_grp.txn_instances_tbl, a0 out nocopy JTF_NUMBER_TABLE
69: , a1 out nocopy JTF_VARCHAR2_TABLE_100
70: , a2 out nocopy JTF_VARCHAR2_TABLE_100
71: , a3 out nocopy JTF_VARCHAR2_TABLE_100
72: , a4 out nocopy JTF_NUMBER_TABLE
73: , a5 out nocopy JTF_NUMBER_TABLE
74: , a6 out nocopy JTF_NUMBER_TABLE
75: , a7 out nocopy JTF_VARCHAR2_TABLE_100
76: , a8 out nocopy JTF_DATE_TABLE
69: , a1 out nocopy JTF_VARCHAR2_TABLE_100
70: , a2 out nocopy JTF_VARCHAR2_TABLE_100
71: , a3 out nocopy JTF_VARCHAR2_TABLE_100
72: , a4 out nocopy JTF_NUMBER_TABLE
73: , a5 out nocopy JTF_NUMBER_TABLE
74: , a6 out nocopy JTF_NUMBER_TABLE
75: , a7 out nocopy JTF_VARCHAR2_TABLE_100
76: , a8 out nocopy JTF_DATE_TABLE
77: , a9 out nocopy JTF_DATE_TABLE
70: , a2 out nocopy JTF_VARCHAR2_TABLE_100
71: , a3 out nocopy JTF_VARCHAR2_TABLE_100
72: , a4 out nocopy JTF_NUMBER_TABLE
73: , a5 out nocopy JTF_NUMBER_TABLE
74: , a6 out nocopy JTF_NUMBER_TABLE
75: , a7 out nocopy JTF_VARCHAR2_TABLE_100
76: , a8 out nocopy JTF_DATE_TABLE
77: , a9 out nocopy JTF_DATE_TABLE
78: , a10 out nocopy JTF_NUMBER_TABLE
74: , a6 out nocopy JTF_NUMBER_TABLE
75: , a7 out nocopy JTF_VARCHAR2_TABLE_100
76: , a8 out nocopy JTF_DATE_TABLE
77: , a9 out nocopy JTF_DATE_TABLE
78: , a10 out nocopy JTF_NUMBER_TABLE
79: , a11 out nocopy JTF_VARCHAR2_TABLE_100
80: , a12 out nocopy JTF_NUMBER_TABLE
81: ) as
82: ddindx binary_integer; indx binary_integer;
76: , a8 out nocopy JTF_DATE_TABLE
77: , a9 out nocopy JTF_DATE_TABLE
78: , a10 out nocopy JTF_NUMBER_TABLE
79: , a11 out nocopy JTF_VARCHAR2_TABLE_100
80: , a12 out nocopy JTF_NUMBER_TABLE
81: ) as
82: ddindx binary_integer; indx binary_integer;
83: begin
84: if t is null or t.count = 0 then
81: ) as
82: ddindx binary_integer; indx binary_integer;
83: begin
84: if t is null or t.count = 0 then
85: a0 := JTF_NUMBER_TABLE();
86: a1 := JTF_VARCHAR2_TABLE_100();
87: a2 := JTF_VARCHAR2_TABLE_100();
88: a3 := JTF_VARCHAR2_TABLE_100();
89: a4 := JTF_NUMBER_TABLE();
85: a0 := JTF_NUMBER_TABLE();
86: a1 := JTF_VARCHAR2_TABLE_100();
87: a2 := JTF_VARCHAR2_TABLE_100();
88: a3 := JTF_VARCHAR2_TABLE_100();
89: a4 := JTF_NUMBER_TABLE();
90: a5 := JTF_NUMBER_TABLE();
91: a6 := JTF_NUMBER_TABLE();
92: a7 := JTF_VARCHAR2_TABLE_100();
93: a8 := JTF_DATE_TABLE();
86: a1 := JTF_VARCHAR2_TABLE_100();
87: a2 := JTF_VARCHAR2_TABLE_100();
88: a3 := JTF_VARCHAR2_TABLE_100();
89: a4 := JTF_NUMBER_TABLE();
90: a5 := JTF_NUMBER_TABLE();
91: a6 := JTF_NUMBER_TABLE();
92: a7 := JTF_VARCHAR2_TABLE_100();
93: a8 := JTF_DATE_TABLE();
94: a9 := JTF_DATE_TABLE();
87: a2 := JTF_VARCHAR2_TABLE_100();
88: a3 := JTF_VARCHAR2_TABLE_100();
89: a4 := JTF_NUMBER_TABLE();
90: a5 := JTF_NUMBER_TABLE();
91: a6 := JTF_NUMBER_TABLE();
92: a7 := JTF_VARCHAR2_TABLE_100();
93: a8 := JTF_DATE_TABLE();
94: a9 := JTF_DATE_TABLE();
95: a10 := JTF_NUMBER_TABLE();
91: a6 := JTF_NUMBER_TABLE();
92: a7 := JTF_VARCHAR2_TABLE_100();
93: a8 := JTF_DATE_TABLE();
94: a9 := JTF_DATE_TABLE();
95: a10 := JTF_NUMBER_TABLE();
96: a11 := JTF_VARCHAR2_TABLE_100();
97: a12 := JTF_NUMBER_TABLE();
98: else
99: a0 := JTF_NUMBER_TABLE();
93: a8 := JTF_DATE_TABLE();
94: a9 := JTF_DATE_TABLE();
95: a10 := JTF_NUMBER_TABLE();
96: a11 := JTF_VARCHAR2_TABLE_100();
97: a12 := JTF_NUMBER_TABLE();
98: else
99: a0 := JTF_NUMBER_TABLE();
100: a1 := JTF_VARCHAR2_TABLE_100();
101: a2 := JTF_VARCHAR2_TABLE_100();
95: a10 := JTF_NUMBER_TABLE();
96: a11 := JTF_VARCHAR2_TABLE_100();
97: a12 := JTF_NUMBER_TABLE();
98: else
99: a0 := JTF_NUMBER_TABLE();
100: a1 := JTF_VARCHAR2_TABLE_100();
101: a2 := JTF_VARCHAR2_TABLE_100();
102: a3 := JTF_VARCHAR2_TABLE_100();
103: a4 := JTF_NUMBER_TABLE();
99: a0 := JTF_NUMBER_TABLE();
100: a1 := JTF_VARCHAR2_TABLE_100();
101: a2 := JTF_VARCHAR2_TABLE_100();
102: a3 := JTF_VARCHAR2_TABLE_100();
103: a4 := JTF_NUMBER_TABLE();
104: a5 := JTF_NUMBER_TABLE();
105: a6 := JTF_NUMBER_TABLE();
106: a7 := JTF_VARCHAR2_TABLE_100();
107: a8 := JTF_DATE_TABLE();
100: a1 := JTF_VARCHAR2_TABLE_100();
101: a2 := JTF_VARCHAR2_TABLE_100();
102: a3 := JTF_VARCHAR2_TABLE_100();
103: a4 := JTF_NUMBER_TABLE();
104: a5 := JTF_NUMBER_TABLE();
105: a6 := JTF_NUMBER_TABLE();
106: a7 := JTF_VARCHAR2_TABLE_100();
107: a8 := JTF_DATE_TABLE();
108: a9 := JTF_DATE_TABLE();
101: a2 := JTF_VARCHAR2_TABLE_100();
102: a3 := JTF_VARCHAR2_TABLE_100();
103: a4 := JTF_NUMBER_TABLE();
104: a5 := JTF_NUMBER_TABLE();
105: a6 := JTF_NUMBER_TABLE();
106: a7 := JTF_VARCHAR2_TABLE_100();
107: a8 := JTF_DATE_TABLE();
108: a9 := JTF_DATE_TABLE();
109: a10 := JTF_NUMBER_TABLE();
105: a6 := JTF_NUMBER_TABLE();
106: a7 := JTF_VARCHAR2_TABLE_100();
107: a8 := JTF_DATE_TABLE();
108: a9 := JTF_DATE_TABLE();
109: a10 := JTF_NUMBER_TABLE();
110: a11 := JTF_VARCHAR2_TABLE_100();
111: a12 := JTF_NUMBER_TABLE();
112: if t.count > 0 then
113: a0.extend(t.count);
107: a8 := JTF_DATE_TABLE();
108: a9 := JTF_DATE_TABLE();
109: a10 := JTF_NUMBER_TABLE();
110: a11 := JTF_VARCHAR2_TABLE_100();
111: a12 := JTF_NUMBER_TABLE();
112: if t.count > 0 then
113: a0.extend(t.count);
114: a1.extend(t.count);
115: a2.extend(t.count);
148: end if;
149: end if;
150: end rosetta_table_copy_out_p1;
151:
152: procedure rosetta_table_copy_in_p3(t out nocopy cse_deployment_grp.dest_location_tbl, a0 JTF_NUMBER_TABLE
153: , a1 JTF_VARCHAR2_TABLE_100
154: , a2 JTF_NUMBER_TABLE
155: , a3 JTF_VARCHAR2_TABLE_100
156: , a4 JTF_NUMBER_TABLE
150: end rosetta_table_copy_out_p1;
151:
152: procedure rosetta_table_copy_in_p3(t out nocopy cse_deployment_grp.dest_location_tbl, a0 JTF_NUMBER_TABLE
153: , a1 JTF_VARCHAR2_TABLE_100
154: , a2 JTF_NUMBER_TABLE
155: , a3 JTF_VARCHAR2_TABLE_100
156: , a4 JTF_NUMBER_TABLE
157: , a5 JTF_NUMBER_TABLE
158: , a6 JTF_VARCHAR2_TABLE_100
152: procedure rosetta_table_copy_in_p3(t out nocopy cse_deployment_grp.dest_location_tbl, a0 JTF_NUMBER_TABLE
153: , a1 JTF_VARCHAR2_TABLE_100
154: , a2 JTF_NUMBER_TABLE
155: , a3 JTF_VARCHAR2_TABLE_100
156: , a4 JTF_NUMBER_TABLE
157: , a5 JTF_NUMBER_TABLE
158: , a6 JTF_VARCHAR2_TABLE_100
159: , a7 JTF_VARCHAR2_TABLE_100
160: , a8 JTF_NUMBER_TABLE
153: , a1 JTF_VARCHAR2_TABLE_100
154: , a2 JTF_NUMBER_TABLE
155: , a3 JTF_VARCHAR2_TABLE_100
156: , a4 JTF_NUMBER_TABLE
157: , a5 JTF_NUMBER_TABLE
158: , a6 JTF_VARCHAR2_TABLE_100
159: , a7 JTF_VARCHAR2_TABLE_100
160: , a8 JTF_NUMBER_TABLE
161: , a9 JTF_NUMBER_TABLE
156: , a4 JTF_NUMBER_TABLE
157: , a5 JTF_NUMBER_TABLE
158: , a6 JTF_VARCHAR2_TABLE_100
159: , a7 JTF_VARCHAR2_TABLE_100
160: , a8 JTF_NUMBER_TABLE
161: , a9 JTF_NUMBER_TABLE
162: ) as
163: ddindx binary_integer; indx binary_integer;
164: begin
157: , a5 JTF_NUMBER_TABLE
158: , a6 JTF_VARCHAR2_TABLE_100
159: , a7 JTF_VARCHAR2_TABLE_100
160: , a8 JTF_NUMBER_TABLE
161: , a9 JTF_NUMBER_TABLE
162: ) as
163: ddindx binary_integer; indx binary_integer;
164: begin
165: if a0 is not null and a0.count > 0 then
185: end loop;
186: end if;
187: end if;
188: end rosetta_table_copy_in_p3;
189: procedure rosetta_table_copy_out_p3(t cse_deployment_grp.dest_location_tbl, a0 out nocopy JTF_NUMBER_TABLE
190: , a1 out nocopy JTF_VARCHAR2_TABLE_100
191: , a2 out nocopy JTF_NUMBER_TABLE
192: , a3 out nocopy JTF_VARCHAR2_TABLE_100
193: , a4 out nocopy JTF_NUMBER_TABLE
187: end if;
188: end rosetta_table_copy_in_p3;
189: procedure rosetta_table_copy_out_p3(t cse_deployment_grp.dest_location_tbl, a0 out nocopy JTF_NUMBER_TABLE
190: , a1 out nocopy JTF_VARCHAR2_TABLE_100
191: , a2 out nocopy JTF_NUMBER_TABLE
192: , a3 out nocopy JTF_VARCHAR2_TABLE_100
193: , a4 out nocopy JTF_NUMBER_TABLE
194: , a5 out nocopy JTF_NUMBER_TABLE
195: , a6 out nocopy JTF_VARCHAR2_TABLE_100
189: procedure rosetta_table_copy_out_p3(t cse_deployment_grp.dest_location_tbl, a0 out nocopy JTF_NUMBER_TABLE
190: , a1 out nocopy JTF_VARCHAR2_TABLE_100
191: , a2 out nocopy JTF_NUMBER_TABLE
192: , a3 out nocopy JTF_VARCHAR2_TABLE_100
193: , a4 out nocopy JTF_NUMBER_TABLE
194: , a5 out nocopy JTF_NUMBER_TABLE
195: , a6 out nocopy JTF_VARCHAR2_TABLE_100
196: , a7 out nocopy JTF_VARCHAR2_TABLE_100
197: , a8 out nocopy JTF_NUMBER_TABLE
190: , a1 out nocopy JTF_VARCHAR2_TABLE_100
191: , a2 out nocopy JTF_NUMBER_TABLE
192: , a3 out nocopy JTF_VARCHAR2_TABLE_100
193: , a4 out nocopy JTF_NUMBER_TABLE
194: , a5 out nocopy JTF_NUMBER_TABLE
195: , a6 out nocopy JTF_VARCHAR2_TABLE_100
196: , a7 out nocopy JTF_VARCHAR2_TABLE_100
197: , a8 out nocopy JTF_NUMBER_TABLE
198: , a9 out nocopy JTF_NUMBER_TABLE
193: , a4 out nocopy JTF_NUMBER_TABLE
194: , a5 out nocopy JTF_NUMBER_TABLE
195: , a6 out nocopy JTF_VARCHAR2_TABLE_100
196: , a7 out nocopy JTF_VARCHAR2_TABLE_100
197: , a8 out nocopy JTF_NUMBER_TABLE
198: , a9 out nocopy JTF_NUMBER_TABLE
199: ) as
200: ddindx binary_integer; indx binary_integer;
201: begin
194: , a5 out nocopy JTF_NUMBER_TABLE
195: , a6 out nocopy JTF_VARCHAR2_TABLE_100
196: , a7 out nocopy JTF_VARCHAR2_TABLE_100
197: , a8 out nocopy JTF_NUMBER_TABLE
198: , a9 out nocopy JTF_NUMBER_TABLE
199: ) as
200: ddindx binary_integer; indx binary_integer;
201: begin
202: if t is null or t.count = 0 then
199: ) as
200: ddindx binary_integer; indx binary_integer;
201: begin
202: if t is null or t.count = 0 then
203: a0 := JTF_NUMBER_TABLE();
204: a1 := JTF_VARCHAR2_TABLE_100();
205: a2 := JTF_NUMBER_TABLE();
206: a3 := JTF_VARCHAR2_TABLE_100();
207: a4 := JTF_NUMBER_TABLE();
201: begin
202: if t is null or t.count = 0 then
203: a0 := JTF_NUMBER_TABLE();
204: a1 := JTF_VARCHAR2_TABLE_100();
205: a2 := JTF_NUMBER_TABLE();
206: a3 := JTF_VARCHAR2_TABLE_100();
207: a4 := JTF_NUMBER_TABLE();
208: a5 := JTF_NUMBER_TABLE();
209: a6 := JTF_VARCHAR2_TABLE_100();
203: a0 := JTF_NUMBER_TABLE();
204: a1 := JTF_VARCHAR2_TABLE_100();
205: a2 := JTF_NUMBER_TABLE();
206: a3 := JTF_VARCHAR2_TABLE_100();
207: a4 := JTF_NUMBER_TABLE();
208: a5 := JTF_NUMBER_TABLE();
209: a6 := JTF_VARCHAR2_TABLE_100();
210: a7 := JTF_VARCHAR2_TABLE_100();
211: a8 := JTF_NUMBER_TABLE();
204: a1 := JTF_VARCHAR2_TABLE_100();
205: a2 := JTF_NUMBER_TABLE();
206: a3 := JTF_VARCHAR2_TABLE_100();
207: a4 := JTF_NUMBER_TABLE();
208: a5 := JTF_NUMBER_TABLE();
209: a6 := JTF_VARCHAR2_TABLE_100();
210: a7 := JTF_VARCHAR2_TABLE_100();
211: a8 := JTF_NUMBER_TABLE();
212: a9 := JTF_NUMBER_TABLE();
207: a4 := JTF_NUMBER_TABLE();
208: a5 := JTF_NUMBER_TABLE();
209: a6 := JTF_VARCHAR2_TABLE_100();
210: a7 := JTF_VARCHAR2_TABLE_100();
211: a8 := JTF_NUMBER_TABLE();
212: a9 := JTF_NUMBER_TABLE();
213: else
214: a0 := JTF_NUMBER_TABLE();
215: a1 := JTF_VARCHAR2_TABLE_100();
208: a5 := JTF_NUMBER_TABLE();
209: a6 := JTF_VARCHAR2_TABLE_100();
210: a7 := JTF_VARCHAR2_TABLE_100();
211: a8 := JTF_NUMBER_TABLE();
212: a9 := JTF_NUMBER_TABLE();
213: else
214: a0 := JTF_NUMBER_TABLE();
215: a1 := JTF_VARCHAR2_TABLE_100();
216: a2 := JTF_NUMBER_TABLE();
210: a7 := JTF_VARCHAR2_TABLE_100();
211: a8 := JTF_NUMBER_TABLE();
212: a9 := JTF_NUMBER_TABLE();
213: else
214: a0 := JTF_NUMBER_TABLE();
215: a1 := JTF_VARCHAR2_TABLE_100();
216: a2 := JTF_NUMBER_TABLE();
217: a3 := JTF_VARCHAR2_TABLE_100();
218: a4 := JTF_NUMBER_TABLE();
212: a9 := JTF_NUMBER_TABLE();
213: else
214: a0 := JTF_NUMBER_TABLE();
215: a1 := JTF_VARCHAR2_TABLE_100();
216: a2 := JTF_NUMBER_TABLE();
217: a3 := JTF_VARCHAR2_TABLE_100();
218: a4 := JTF_NUMBER_TABLE();
219: a5 := JTF_NUMBER_TABLE();
220: a6 := JTF_VARCHAR2_TABLE_100();
214: a0 := JTF_NUMBER_TABLE();
215: a1 := JTF_VARCHAR2_TABLE_100();
216: a2 := JTF_NUMBER_TABLE();
217: a3 := JTF_VARCHAR2_TABLE_100();
218: a4 := JTF_NUMBER_TABLE();
219: a5 := JTF_NUMBER_TABLE();
220: a6 := JTF_VARCHAR2_TABLE_100();
221: a7 := JTF_VARCHAR2_TABLE_100();
222: a8 := JTF_NUMBER_TABLE();
215: a1 := JTF_VARCHAR2_TABLE_100();
216: a2 := JTF_NUMBER_TABLE();
217: a3 := JTF_VARCHAR2_TABLE_100();
218: a4 := JTF_NUMBER_TABLE();
219: a5 := JTF_NUMBER_TABLE();
220: a6 := JTF_VARCHAR2_TABLE_100();
221: a7 := JTF_VARCHAR2_TABLE_100();
222: a8 := JTF_NUMBER_TABLE();
223: a9 := JTF_NUMBER_TABLE();
218: a4 := JTF_NUMBER_TABLE();
219: a5 := JTF_NUMBER_TABLE();
220: a6 := JTF_VARCHAR2_TABLE_100();
221: a7 := JTF_VARCHAR2_TABLE_100();
222: a8 := JTF_NUMBER_TABLE();
223: a9 := JTF_NUMBER_TABLE();
224: if t.count > 0 then
225: a0.extend(t.count);
226: a1.extend(t.count);
219: a5 := JTF_NUMBER_TABLE();
220: a6 := JTF_VARCHAR2_TABLE_100();
221: a7 := JTF_VARCHAR2_TABLE_100();
222: a8 := JTF_NUMBER_TABLE();
223: a9 := JTF_NUMBER_TABLE();
224: if t.count > 0 then
225: a0.extend(t.count);
226: a1.extend(t.count);
227: a2.extend(t.count);
254: end if;
255: end if;
256: end rosetta_table_copy_out_p3;
257:
258: procedure rosetta_table_copy_in_p5(t out nocopy cse_deployment_grp.txn_ext_attrib_values_tbl, a0 JTF_NUMBER_TABLE
259: , a1 JTF_NUMBER_TABLE
260: , a2 JTF_NUMBER_TABLE
261: , a3 JTF_NUMBER_TABLE
262: , a4 JTF_VARCHAR2_TABLE_100
255: end if;
256: end rosetta_table_copy_out_p3;
257:
258: procedure rosetta_table_copy_in_p5(t out nocopy cse_deployment_grp.txn_ext_attrib_values_tbl, a0 JTF_NUMBER_TABLE
259: , a1 JTF_NUMBER_TABLE
260: , a2 JTF_NUMBER_TABLE
261: , a3 JTF_NUMBER_TABLE
262: , a4 JTF_VARCHAR2_TABLE_100
263: , a5 JTF_VARCHAR2_TABLE_300
256: end rosetta_table_copy_out_p3;
257:
258: procedure rosetta_table_copy_in_p5(t out nocopy cse_deployment_grp.txn_ext_attrib_values_tbl, a0 JTF_NUMBER_TABLE
259: , a1 JTF_NUMBER_TABLE
260: , a2 JTF_NUMBER_TABLE
261: , a3 JTF_NUMBER_TABLE
262: , a4 JTF_VARCHAR2_TABLE_100
263: , a5 JTF_VARCHAR2_TABLE_300
264: , a6 JTF_DATE_TABLE
257:
258: procedure rosetta_table_copy_in_p5(t out nocopy cse_deployment_grp.txn_ext_attrib_values_tbl, a0 JTF_NUMBER_TABLE
259: , a1 JTF_NUMBER_TABLE
260: , a2 JTF_NUMBER_TABLE
261: , a3 JTF_NUMBER_TABLE
262: , a4 JTF_VARCHAR2_TABLE_100
263: , a5 JTF_VARCHAR2_TABLE_300
264: , a6 JTF_DATE_TABLE
265: , a7 JTF_DATE_TABLE
262: , a4 JTF_VARCHAR2_TABLE_100
263: , a5 JTF_VARCHAR2_TABLE_300
264: , a6 JTF_DATE_TABLE
265: , a7 JTF_DATE_TABLE
266: , a8 JTF_NUMBER_TABLE
267: ) as
268: ddindx binary_integer; indx binary_integer;
269: begin
270: if a0 is not null and a0.count > 0 then
289: end loop;
290: end if;
291: end if;
292: end rosetta_table_copy_in_p5;
293: procedure rosetta_table_copy_out_p5(t cse_deployment_grp.txn_ext_attrib_values_tbl, a0 out nocopy JTF_NUMBER_TABLE
294: , a1 out nocopy JTF_NUMBER_TABLE
295: , a2 out nocopy JTF_NUMBER_TABLE
296: , a3 out nocopy JTF_NUMBER_TABLE
297: , a4 out nocopy JTF_VARCHAR2_TABLE_100
290: end if;
291: end if;
292: end rosetta_table_copy_in_p5;
293: procedure rosetta_table_copy_out_p5(t cse_deployment_grp.txn_ext_attrib_values_tbl, a0 out nocopy JTF_NUMBER_TABLE
294: , a1 out nocopy JTF_NUMBER_TABLE
295: , a2 out nocopy JTF_NUMBER_TABLE
296: , a3 out nocopy JTF_NUMBER_TABLE
297: , a4 out nocopy JTF_VARCHAR2_TABLE_100
298: , a5 out nocopy JTF_VARCHAR2_TABLE_300
291: end if;
292: end rosetta_table_copy_in_p5;
293: procedure rosetta_table_copy_out_p5(t cse_deployment_grp.txn_ext_attrib_values_tbl, a0 out nocopy JTF_NUMBER_TABLE
294: , a1 out nocopy JTF_NUMBER_TABLE
295: , a2 out nocopy JTF_NUMBER_TABLE
296: , a3 out nocopy JTF_NUMBER_TABLE
297: , a4 out nocopy JTF_VARCHAR2_TABLE_100
298: , a5 out nocopy JTF_VARCHAR2_TABLE_300
299: , a6 out nocopy JTF_DATE_TABLE
292: end rosetta_table_copy_in_p5;
293: procedure rosetta_table_copy_out_p5(t cse_deployment_grp.txn_ext_attrib_values_tbl, a0 out nocopy JTF_NUMBER_TABLE
294: , a1 out nocopy JTF_NUMBER_TABLE
295: , a2 out nocopy JTF_NUMBER_TABLE
296: , a3 out nocopy JTF_NUMBER_TABLE
297: , a4 out nocopy JTF_VARCHAR2_TABLE_100
298: , a5 out nocopy JTF_VARCHAR2_TABLE_300
299: , a6 out nocopy JTF_DATE_TABLE
300: , a7 out nocopy JTF_DATE_TABLE
297: , a4 out nocopy JTF_VARCHAR2_TABLE_100
298: , a5 out nocopy JTF_VARCHAR2_TABLE_300
299: , a6 out nocopy JTF_DATE_TABLE
300: , a7 out nocopy JTF_DATE_TABLE
301: , a8 out nocopy JTF_NUMBER_TABLE
302: ) as
303: ddindx binary_integer; indx binary_integer;
304: begin
305: if t is null or t.count = 0 then
302: ) as
303: ddindx binary_integer; indx binary_integer;
304: begin
305: if t is null or t.count = 0 then
306: a0 := JTF_NUMBER_TABLE();
307: a1 := JTF_NUMBER_TABLE();
308: a2 := JTF_NUMBER_TABLE();
309: a3 := JTF_NUMBER_TABLE();
310: a4 := JTF_VARCHAR2_TABLE_100();
303: ddindx binary_integer; indx binary_integer;
304: begin
305: if t is null or t.count = 0 then
306: a0 := JTF_NUMBER_TABLE();
307: a1 := JTF_NUMBER_TABLE();
308: a2 := JTF_NUMBER_TABLE();
309: a3 := JTF_NUMBER_TABLE();
310: a4 := JTF_VARCHAR2_TABLE_100();
311: a5 := JTF_VARCHAR2_TABLE_300();
304: begin
305: if t is null or t.count = 0 then
306: a0 := JTF_NUMBER_TABLE();
307: a1 := JTF_NUMBER_TABLE();
308: a2 := JTF_NUMBER_TABLE();
309: a3 := JTF_NUMBER_TABLE();
310: a4 := JTF_VARCHAR2_TABLE_100();
311: a5 := JTF_VARCHAR2_TABLE_300();
312: a6 := JTF_DATE_TABLE();
305: if t is null or t.count = 0 then
306: a0 := JTF_NUMBER_TABLE();
307: a1 := JTF_NUMBER_TABLE();
308: a2 := JTF_NUMBER_TABLE();
309: a3 := JTF_NUMBER_TABLE();
310: a4 := JTF_VARCHAR2_TABLE_100();
311: a5 := JTF_VARCHAR2_TABLE_300();
312: a6 := JTF_DATE_TABLE();
313: a7 := JTF_DATE_TABLE();
310: a4 := JTF_VARCHAR2_TABLE_100();
311: a5 := JTF_VARCHAR2_TABLE_300();
312: a6 := JTF_DATE_TABLE();
313: a7 := JTF_DATE_TABLE();
314: a8 := JTF_NUMBER_TABLE();
315: else
316: a0 := JTF_NUMBER_TABLE();
317: a1 := JTF_NUMBER_TABLE();
318: a2 := JTF_NUMBER_TABLE();
312: a6 := JTF_DATE_TABLE();
313: a7 := JTF_DATE_TABLE();
314: a8 := JTF_NUMBER_TABLE();
315: else
316: a0 := JTF_NUMBER_TABLE();
317: a1 := JTF_NUMBER_TABLE();
318: a2 := JTF_NUMBER_TABLE();
319: a3 := JTF_NUMBER_TABLE();
320: a4 := JTF_VARCHAR2_TABLE_100();
313: a7 := JTF_DATE_TABLE();
314: a8 := JTF_NUMBER_TABLE();
315: else
316: a0 := JTF_NUMBER_TABLE();
317: a1 := JTF_NUMBER_TABLE();
318: a2 := JTF_NUMBER_TABLE();
319: a3 := JTF_NUMBER_TABLE();
320: a4 := JTF_VARCHAR2_TABLE_100();
321: a5 := JTF_VARCHAR2_TABLE_300();
314: a8 := JTF_NUMBER_TABLE();
315: else
316: a0 := JTF_NUMBER_TABLE();
317: a1 := JTF_NUMBER_TABLE();
318: a2 := JTF_NUMBER_TABLE();
319: a3 := JTF_NUMBER_TABLE();
320: a4 := JTF_VARCHAR2_TABLE_100();
321: a5 := JTF_VARCHAR2_TABLE_300();
322: a6 := JTF_DATE_TABLE();
315: else
316: a0 := JTF_NUMBER_TABLE();
317: a1 := JTF_NUMBER_TABLE();
318: a2 := JTF_NUMBER_TABLE();
319: a3 := JTF_NUMBER_TABLE();
320: a4 := JTF_VARCHAR2_TABLE_100();
321: a5 := JTF_VARCHAR2_TABLE_300();
322: a6 := JTF_DATE_TABLE();
323: a7 := JTF_DATE_TABLE();
320: a4 := JTF_VARCHAR2_TABLE_100();
321: a5 := JTF_VARCHAR2_TABLE_300();
322: a6 := JTF_DATE_TABLE();
323: a7 := JTF_DATE_TABLE();
324: a8 := JTF_NUMBER_TABLE();
325: if t.count > 0 then
326: a0.extend(t.count);
327: a1.extend(t.count);
328: a2.extend(t.count);
353: end if;
354: end if;
355: end rosetta_table_copy_out_p5;
356:
357: procedure rosetta_table_copy_in_p7(t out nocopy cse_deployment_grp.transaction_tbl, a0 JTF_NUMBER_TABLE
358: , a1 JTF_DATE_TABLE
359: , a2 JTF_DATE_TABLE
360: , a3 JTF_NUMBER_TABLE
361: , a4 JTF_NUMBER_TABLE
356:
357: procedure rosetta_table_copy_in_p7(t out nocopy cse_deployment_grp.transaction_tbl, a0 JTF_NUMBER_TABLE
358: , a1 JTF_DATE_TABLE
359: , a2 JTF_DATE_TABLE
360: , a3 JTF_NUMBER_TABLE
361: , a4 JTF_NUMBER_TABLE
362: , a5 JTF_NUMBER_TABLE
363: , a6 JTF_VARCHAR2_TABLE_100
364: , a7 JTF_NUMBER_TABLE
357: procedure rosetta_table_copy_in_p7(t out nocopy cse_deployment_grp.transaction_tbl, a0 JTF_NUMBER_TABLE
358: , a1 JTF_DATE_TABLE
359: , a2 JTF_DATE_TABLE
360: , a3 JTF_NUMBER_TABLE
361: , a4 JTF_NUMBER_TABLE
362: , a5 JTF_NUMBER_TABLE
363: , a6 JTF_VARCHAR2_TABLE_100
364: , a7 JTF_NUMBER_TABLE
365: , a8 JTF_VARCHAR2_TABLE_100
358: , a1 JTF_DATE_TABLE
359: , a2 JTF_DATE_TABLE
360: , a3 JTF_NUMBER_TABLE
361: , a4 JTF_NUMBER_TABLE
362: , a5 JTF_NUMBER_TABLE
363: , a6 JTF_VARCHAR2_TABLE_100
364: , a7 JTF_NUMBER_TABLE
365: , a8 JTF_VARCHAR2_TABLE_100
366: , a9 JTF_NUMBER_TABLE
360: , a3 JTF_NUMBER_TABLE
361: , a4 JTF_NUMBER_TABLE
362: , a5 JTF_NUMBER_TABLE
363: , a6 JTF_VARCHAR2_TABLE_100
364: , a7 JTF_NUMBER_TABLE
365: , a8 JTF_VARCHAR2_TABLE_100
366: , a9 JTF_NUMBER_TABLE
367: , a10 JTF_NUMBER_TABLE
368: , a11 JTF_NUMBER_TABLE
362: , a5 JTF_NUMBER_TABLE
363: , a6 JTF_VARCHAR2_TABLE_100
364: , a7 JTF_NUMBER_TABLE
365: , a8 JTF_VARCHAR2_TABLE_100
366: , a9 JTF_NUMBER_TABLE
367: , a10 JTF_NUMBER_TABLE
368: , a11 JTF_NUMBER_TABLE
369: , a12 JTF_NUMBER_TABLE
370: , a13 JTF_VARCHAR2_TABLE_100
363: , a6 JTF_VARCHAR2_TABLE_100
364: , a7 JTF_NUMBER_TABLE
365: , a8 JTF_VARCHAR2_TABLE_100
366: , a9 JTF_NUMBER_TABLE
367: , a10 JTF_NUMBER_TABLE
368: , a11 JTF_NUMBER_TABLE
369: , a12 JTF_NUMBER_TABLE
370: , a13 JTF_VARCHAR2_TABLE_100
371: , a14 JTF_VARCHAR2_TABLE_100
364: , a7 JTF_NUMBER_TABLE
365: , a8 JTF_VARCHAR2_TABLE_100
366: , a9 JTF_NUMBER_TABLE
367: , a10 JTF_NUMBER_TABLE
368: , a11 JTF_NUMBER_TABLE
369: , a12 JTF_NUMBER_TABLE
370: , a13 JTF_VARCHAR2_TABLE_100
371: , a14 JTF_VARCHAR2_TABLE_100
372: ) as
365: , a8 JTF_VARCHAR2_TABLE_100
366: , a9 JTF_NUMBER_TABLE
367: , a10 JTF_NUMBER_TABLE
368: , a11 JTF_NUMBER_TABLE
369: , a12 JTF_NUMBER_TABLE
370: , a13 JTF_VARCHAR2_TABLE_100
371: , a14 JTF_VARCHAR2_TABLE_100
372: ) as
373: ddindx binary_integer; indx binary_integer;
400: end loop;
401: end if;
402: end if;
403: end rosetta_table_copy_in_p7;
404: procedure rosetta_table_copy_out_p7(t cse_deployment_grp.transaction_tbl, a0 out nocopy JTF_NUMBER_TABLE
405: , a1 out nocopy JTF_DATE_TABLE
406: , a2 out nocopy JTF_DATE_TABLE
407: , a3 out nocopy JTF_NUMBER_TABLE
408: , a4 out nocopy JTF_NUMBER_TABLE
403: end rosetta_table_copy_in_p7;
404: procedure rosetta_table_copy_out_p7(t cse_deployment_grp.transaction_tbl, a0 out nocopy JTF_NUMBER_TABLE
405: , a1 out nocopy JTF_DATE_TABLE
406: , a2 out nocopy JTF_DATE_TABLE
407: , a3 out nocopy JTF_NUMBER_TABLE
408: , a4 out nocopy JTF_NUMBER_TABLE
409: , a5 out nocopy JTF_NUMBER_TABLE
410: , a6 out nocopy JTF_VARCHAR2_TABLE_100
411: , a7 out nocopy JTF_NUMBER_TABLE
404: procedure rosetta_table_copy_out_p7(t cse_deployment_grp.transaction_tbl, a0 out nocopy JTF_NUMBER_TABLE
405: , a1 out nocopy JTF_DATE_TABLE
406: , a2 out nocopy JTF_DATE_TABLE
407: , a3 out nocopy JTF_NUMBER_TABLE
408: , a4 out nocopy JTF_NUMBER_TABLE
409: , a5 out nocopy JTF_NUMBER_TABLE
410: , a6 out nocopy JTF_VARCHAR2_TABLE_100
411: , a7 out nocopy JTF_NUMBER_TABLE
412: , a8 out nocopy JTF_VARCHAR2_TABLE_100
405: , a1 out nocopy JTF_DATE_TABLE
406: , a2 out nocopy JTF_DATE_TABLE
407: , a3 out nocopy JTF_NUMBER_TABLE
408: , a4 out nocopy JTF_NUMBER_TABLE
409: , a5 out nocopy JTF_NUMBER_TABLE
410: , a6 out nocopy JTF_VARCHAR2_TABLE_100
411: , a7 out nocopy JTF_NUMBER_TABLE
412: , a8 out nocopy JTF_VARCHAR2_TABLE_100
413: , a9 out nocopy JTF_NUMBER_TABLE
407: , a3 out nocopy JTF_NUMBER_TABLE
408: , a4 out nocopy JTF_NUMBER_TABLE
409: , a5 out nocopy JTF_NUMBER_TABLE
410: , a6 out nocopy JTF_VARCHAR2_TABLE_100
411: , a7 out nocopy JTF_NUMBER_TABLE
412: , a8 out nocopy JTF_VARCHAR2_TABLE_100
413: , a9 out nocopy JTF_NUMBER_TABLE
414: , a10 out nocopy JTF_NUMBER_TABLE
415: , a11 out nocopy JTF_NUMBER_TABLE
409: , a5 out nocopy JTF_NUMBER_TABLE
410: , a6 out nocopy JTF_VARCHAR2_TABLE_100
411: , a7 out nocopy JTF_NUMBER_TABLE
412: , a8 out nocopy JTF_VARCHAR2_TABLE_100
413: , a9 out nocopy JTF_NUMBER_TABLE
414: , a10 out nocopy JTF_NUMBER_TABLE
415: , a11 out nocopy JTF_NUMBER_TABLE
416: , a12 out nocopy JTF_NUMBER_TABLE
417: , a13 out nocopy JTF_VARCHAR2_TABLE_100
410: , a6 out nocopy JTF_VARCHAR2_TABLE_100
411: , a7 out nocopy JTF_NUMBER_TABLE
412: , a8 out nocopy JTF_VARCHAR2_TABLE_100
413: , a9 out nocopy JTF_NUMBER_TABLE
414: , a10 out nocopy JTF_NUMBER_TABLE
415: , a11 out nocopy JTF_NUMBER_TABLE
416: , a12 out nocopy JTF_NUMBER_TABLE
417: , a13 out nocopy JTF_VARCHAR2_TABLE_100
418: , a14 out nocopy JTF_VARCHAR2_TABLE_100
411: , a7 out nocopy JTF_NUMBER_TABLE
412: , a8 out nocopy JTF_VARCHAR2_TABLE_100
413: , a9 out nocopy JTF_NUMBER_TABLE
414: , a10 out nocopy JTF_NUMBER_TABLE
415: , a11 out nocopy JTF_NUMBER_TABLE
416: , a12 out nocopy JTF_NUMBER_TABLE
417: , a13 out nocopy JTF_VARCHAR2_TABLE_100
418: , a14 out nocopy JTF_VARCHAR2_TABLE_100
419: ) as
412: , a8 out nocopy JTF_VARCHAR2_TABLE_100
413: , a9 out nocopy JTF_NUMBER_TABLE
414: , a10 out nocopy JTF_NUMBER_TABLE
415: , a11 out nocopy JTF_NUMBER_TABLE
416: , a12 out nocopy JTF_NUMBER_TABLE
417: , a13 out nocopy JTF_VARCHAR2_TABLE_100
418: , a14 out nocopy JTF_VARCHAR2_TABLE_100
419: ) as
420: ddindx binary_integer; indx binary_integer;
419: ) as
420: ddindx binary_integer; indx binary_integer;
421: begin
422: if t is null or t.count = 0 then
423: a0 := JTF_NUMBER_TABLE();
424: a1 := JTF_DATE_TABLE();
425: a2 := JTF_DATE_TABLE();
426: a3 := JTF_NUMBER_TABLE();
427: a4 := JTF_NUMBER_TABLE();
422: if t is null or t.count = 0 then
423: a0 := JTF_NUMBER_TABLE();
424: a1 := JTF_DATE_TABLE();
425: a2 := JTF_DATE_TABLE();
426: a3 := JTF_NUMBER_TABLE();
427: a4 := JTF_NUMBER_TABLE();
428: a5 := JTF_NUMBER_TABLE();
429: a6 := JTF_VARCHAR2_TABLE_100();
430: a7 := JTF_NUMBER_TABLE();
423: a0 := JTF_NUMBER_TABLE();
424: a1 := JTF_DATE_TABLE();
425: a2 := JTF_DATE_TABLE();
426: a3 := JTF_NUMBER_TABLE();
427: a4 := JTF_NUMBER_TABLE();
428: a5 := JTF_NUMBER_TABLE();
429: a6 := JTF_VARCHAR2_TABLE_100();
430: a7 := JTF_NUMBER_TABLE();
431: a8 := JTF_VARCHAR2_TABLE_100();
424: a1 := JTF_DATE_TABLE();
425: a2 := JTF_DATE_TABLE();
426: a3 := JTF_NUMBER_TABLE();
427: a4 := JTF_NUMBER_TABLE();
428: a5 := JTF_NUMBER_TABLE();
429: a6 := JTF_VARCHAR2_TABLE_100();
430: a7 := JTF_NUMBER_TABLE();
431: a8 := JTF_VARCHAR2_TABLE_100();
432: a9 := JTF_NUMBER_TABLE();
426: a3 := JTF_NUMBER_TABLE();
427: a4 := JTF_NUMBER_TABLE();
428: a5 := JTF_NUMBER_TABLE();
429: a6 := JTF_VARCHAR2_TABLE_100();
430: a7 := JTF_NUMBER_TABLE();
431: a8 := JTF_VARCHAR2_TABLE_100();
432: a9 := JTF_NUMBER_TABLE();
433: a10 := JTF_NUMBER_TABLE();
434: a11 := JTF_NUMBER_TABLE();
428: a5 := JTF_NUMBER_TABLE();
429: a6 := JTF_VARCHAR2_TABLE_100();
430: a7 := JTF_NUMBER_TABLE();
431: a8 := JTF_VARCHAR2_TABLE_100();
432: a9 := JTF_NUMBER_TABLE();
433: a10 := JTF_NUMBER_TABLE();
434: a11 := JTF_NUMBER_TABLE();
435: a12 := JTF_NUMBER_TABLE();
436: a13 := JTF_VARCHAR2_TABLE_100();
429: a6 := JTF_VARCHAR2_TABLE_100();
430: a7 := JTF_NUMBER_TABLE();
431: a8 := JTF_VARCHAR2_TABLE_100();
432: a9 := JTF_NUMBER_TABLE();
433: a10 := JTF_NUMBER_TABLE();
434: a11 := JTF_NUMBER_TABLE();
435: a12 := JTF_NUMBER_TABLE();
436: a13 := JTF_VARCHAR2_TABLE_100();
437: a14 := JTF_VARCHAR2_TABLE_100();
430: a7 := JTF_NUMBER_TABLE();
431: a8 := JTF_VARCHAR2_TABLE_100();
432: a9 := JTF_NUMBER_TABLE();
433: a10 := JTF_NUMBER_TABLE();
434: a11 := JTF_NUMBER_TABLE();
435: a12 := JTF_NUMBER_TABLE();
436: a13 := JTF_VARCHAR2_TABLE_100();
437: a14 := JTF_VARCHAR2_TABLE_100();
438: else
431: a8 := JTF_VARCHAR2_TABLE_100();
432: a9 := JTF_NUMBER_TABLE();
433: a10 := JTF_NUMBER_TABLE();
434: a11 := JTF_NUMBER_TABLE();
435: a12 := JTF_NUMBER_TABLE();
436: a13 := JTF_VARCHAR2_TABLE_100();
437: a14 := JTF_VARCHAR2_TABLE_100();
438: else
439: a0 := JTF_NUMBER_TABLE();
435: a12 := JTF_NUMBER_TABLE();
436: a13 := JTF_VARCHAR2_TABLE_100();
437: a14 := JTF_VARCHAR2_TABLE_100();
438: else
439: a0 := JTF_NUMBER_TABLE();
440: a1 := JTF_DATE_TABLE();
441: a2 := JTF_DATE_TABLE();
442: a3 := JTF_NUMBER_TABLE();
443: a4 := JTF_NUMBER_TABLE();
438: else
439: a0 := JTF_NUMBER_TABLE();
440: a1 := JTF_DATE_TABLE();
441: a2 := JTF_DATE_TABLE();
442: a3 := JTF_NUMBER_TABLE();
443: a4 := JTF_NUMBER_TABLE();
444: a5 := JTF_NUMBER_TABLE();
445: a6 := JTF_VARCHAR2_TABLE_100();
446: a7 := JTF_NUMBER_TABLE();
439: a0 := JTF_NUMBER_TABLE();
440: a1 := JTF_DATE_TABLE();
441: a2 := JTF_DATE_TABLE();
442: a3 := JTF_NUMBER_TABLE();
443: a4 := JTF_NUMBER_TABLE();
444: a5 := JTF_NUMBER_TABLE();
445: a6 := JTF_VARCHAR2_TABLE_100();
446: a7 := JTF_NUMBER_TABLE();
447: a8 := JTF_VARCHAR2_TABLE_100();
440: a1 := JTF_DATE_TABLE();
441: a2 := JTF_DATE_TABLE();
442: a3 := JTF_NUMBER_TABLE();
443: a4 := JTF_NUMBER_TABLE();
444: a5 := JTF_NUMBER_TABLE();
445: a6 := JTF_VARCHAR2_TABLE_100();
446: a7 := JTF_NUMBER_TABLE();
447: a8 := JTF_VARCHAR2_TABLE_100();
448: a9 := JTF_NUMBER_TABLE();
442: a3 := JTF_NUMBER_TABLE();
443: a4 := JTF_NUMBER_TABLE();
444: a5 := JTF_NUMBER_TABLE();
445: a6 := JTF_VARCHAR2_TABLE_100();
446: a7 := JTF_NUMBER_TABLE();
447: a8 := JTF_VARCHAR2_TABLE_100();
448: a9 := JTF_NUMBER_TABLE();
449: a10 := JTF_NUMBER_TABLE();
450: a11 := JTF_NUMBER_TABLE();
444: a5 := JTF_NUMBER_TABLE();
445: a6 := JTF_VARCHAR2_TABLE_100();
446: a7 := JTF_NUMBER_TABLE();
447: a8 := JTF_VARCHAR2_TABLE_100();
448: a9 := JTF_NUMBER_TABLE();
449: a10 := JTF_NUMBER_TABLE();
450: a11 := JTF_NUMBER_TABLE();
451: a12 := JTF_NUMBER_TABLE();
452: a13 := JTF_VARCHAR2_TABLE_100();
445: a6 := JTF_VARCHAR2_TABLE_100();
446: a7 := JTF_NUMBER_TABLE();
447: a8 := JTF_VARCHAR2_TABLE_100();
448: a9 := JTF_NUMBER_TABLE();
449: a10 := JTF_NUMBER_TABLE();
450: a11 := JTF_NUMBER_TABLE();
451: a12 := JTF_NUMBER_TABLE();
452: a13 := JTF_VARCHAR2_TABLE_100();
453: a14 := JTF_VARCHAR2_TABLE_100();
446: a7 := JTF_NUMBER_TABLE();
447: a8 := JTF_VARCHAR2_TABLE_100();
448: a9 := JTF_NUMBER_TABLE();
449: a10 := JTF_NUMBER_TABLE();
450: a11 := JTF_NUMBER_TABLE();
451: a12 := JTF_NUMBER_TABLE();
452: a13 := JTF_VARCHAR2_TABLE_100();
453: a14 := JTF_VARCHAR2_TABLE_100();
454: if t.count > 0 then
447: a8 := JTF_VARCHAR2_TABLE_100();
448: a9 := JTF_NUMBER_TABLE();
449: a10 := JTF_NUMBER_TABLE();
450: a11 := JTF_NUMBER_TABLE();
451: a12 := JTF_NUMBER_TABLE();
452: a13 := JTF_VARCHAR2_TABLE_100();
453: a14 := JTF_VARCHAR2_TABLE_100();
454: if t.count > 0 then
455: a0.extend(t.count);
494: end if;
495: end if;
496: end rosetta_table_copy_out_p7;
497:
498: procedure process_transaction(p0_a0 JTF_NUMBER_TABLE
499: , p0_a1 JTF_VARCHAR2_TABLE_100
500: , p0_a2 JTF_VARCHAR2_TABLE_100
501: , p0_a3 JTF_VARCHAR2_TABLE_100
502: , p0_a4 JTF_NUMBER_TABLE
498: procedure process_transaction(p0_a0 JTF_NUMBER_TABLE
499: , p0_a1 JTF_VARCHAR2_TABLE_100
500: , p0_a2 JTF_VARCHAR2_TABLE_100
501: , p0_a3 JTF_VARCHAR2_TABLE_100
502: , p0_a4 JTF_NUMBER_TABLE
503: , p0_a5 JTF_NUMBER_TABLE
504: , p0_a6 JTF_NUMBER_TABLE
505: , p0_a7 JTF_VARCHAR2_TABLE_100
506: , p0_a8 JTF_DATE_TABLE
499: , p0_a1 JTF_VARCHAR2_TABLE_100
500: , p0_a2 JTF_VARCHAR2_TABLE_100
501: , p0_a3 JTF_VARCHAR2_TABLE_100
502: , p0_a4 JTF_NUMBER_TABLE
503: , p0_a5 JTF_NUMBER_TABLE
504: , p0_a6 JTF_NUMBER_TABLE
505: , p0_a7 JTF_VARCHAR2_TABLE_100
506: , p0_a8 JTF_DATE_TABLE
507: , p0_a9 JTF_DATE_TABLE
500: , p0_a2 JTF_VARCHAR2_TABLE_100
501: , p0_a3 JTF_VARCHAR2_TABLE_100
502: , p0_a4 JTF_NUMBER_TABLE
503: , p0_a5 JTF_NUMBER_TABLE
504: , p0_a6 JTF_NUMBER_TABLE
505: , p0_a7 JTF_VARCHAR2_TABLE_100
506: , p0_a8 JTF_DATE_TABLE
507: , p0_a9 JTF_DATE_TABLE
508: , p0_a10 JTF_NUMBER_TABLE
504: , p0_a6 JTF_NUMBER_TABLE
505: , p0_a7 JTF_VARCHAR2_TABLE_100
506: , p0_a8 JTF_DATE_TABLE
507: , p0_a9 JTF_DATE_TABLE
508: , p0_a10 JTF_NUMBER_TABLE
509: , p0_a11 JTF_VARCHAR2_TABLE_100
510: , p0_a12 JTF_NUMBER_TABLE
511: , p1_a0 JTF_NUMBER_TABLE
512: , p1_a1 JTF_VARCHAR2_TABLE_100
506: , p0_a8 JTF_DATE_TABLE
507: , p0_a9 JTF_DATE_TABLE
508: , p0_a10 JTF_NUMBER_TABLE
509: , p0_a11 JTF_VARCHAR2_TABLE_100
510: , p0_a12 JTF_NUMBER_TABLE
511: , p1_a0 JTF_NUMBER_TABLE
512: , p1_a1 JTF_VARCHAR2_TABLE_100
513: , p1_a2 JTF_NUMBER_TABLE
514: , p1_a3 JTF_VARCHAR2_TABLE_100
507: , p0_a9 JTF_DATE_TABLE
508: , p0_a10 JTF_NUMBER_TABLE
509: , p0_a11 JTF_VARCHAR2_TABLE_100
510: , p0_a12 JTF_NUMBER_TABLE
511: , p1_a0 JTF_NUMBER_TABLE
512: , p1_a1 JTF_VARCHAR2_TABLE_100
513: , p1_a2 JTF_NUMBER_TABLE
514: , p1_a3 JTF_VARCHAR2_TABLE_100
515: , p1_a4 JTF_NUMBER_TABLE
509: , p0_a11 JTF_VARCHAR2_TABLE_100
510: , p0_a12 JTF_NUMBER_TABLE
511: , p1_a0 JTF_NUMBER_TABLE
512: , p1_a1 JTF_VARCHAR2_TABLE_100
513: , p1_a2 JTF_NUMBER_TABLE
514: , p1_a3 JTF_VARCHAR2_TABLE_100
515: , p1_a4 JTF_NUMBER_TABLE
516: , p1_a5 JTF_NUMBER_TABLE
517: , p1_a6 JTF_VARCHAR2_TABLE_100
511: , p1_a0 JTF_NUMBER_TABLE
512: , p1_a1 JTF_VARCHAR2_TABLE_100
513: , p1_a2 JTF_NUMBER_TABLE
514: , p1_a3 JTF_VARCHAR2_TABLE_100
515: , p1_a4 JTF_NUMBER_TABLE
516: , p1_a5 JTF_NUMBER_TABLE
517: , p1_a6 JTF_VARCHAR2_TABLE_100
518: , p1_a7 JTF_VARCHAR2_TABLE_100
519: , p1_a8 JTF_NUMBER_TABLE
512: , p1_a1 JTF_VARCHAR2_TABLE_100
513: , p1_a2 JTF_NUMBER_TABLE
514: , p1_a3 JTF_VARCHAR2_TABLE_100
515: , p1_a4 JTF_NUMBER_TABLE
516: , p1_a5 JTF_NUMBER_TABLE
517: , p1_a6 JTF_VARCHAR2_TABLE_100
518: , p1_a7 JTF_VARCHAR2_TABLE_100
519: , p1_a8 JTF_NUMBER_TABLE
520: , p1_a9 JTF_NUMBER_TABLE
515: , p1_a4 JTF_NUMBER_TABLE
516: , p1_a5 JTF_NUMBER_TABLE
517: , p1_a6 JTF_VARCHAR2_TABLE_100
518: , p1_a7 JTF_VARCHAR2_TABLE_100
519: , p1_a8 JTF_NUMBER_TABLE
520: , p1_a9 JTF_NUMBER_TABLE
521: , p2_a0 in out nocopy JTF_NUMBER_TABLE
522: , p2_a1 in out nocopy JTF_NUMBER_TABLE
523: , p2_a2 in out nocopy JTF_NUMBER_TABLE
516: , p1_a5 JTF_NUMBER_TABLE
517: , p1_a6 JTF_VARCHAR2_TABLE_100
518: , p1_a7 JTF_VARCHAR2_TABLE_100
519: , p1_a8 JTF_NUMBER_TABLE
520: , p1_a9 JTF_NUMBER_TABLE
521: , p2_a0 in out nocopy JTF_NUMBER_TABLE
522: , p2_a1 in out nocopy JTF_NUMBER_TABLE
523: , p2_a2 in out nocopy JTF_NUMBER_TABLE
524: , p2_a3 in out nocopy JTF_NUMBER_TABLE
517: , p1_a6 JTF_VARCHAR2_TABLE_100
518: , p1_a7 JTF_VARCHAR2_TABLE_100
519: , p1_a8 JTF_NUMBER_TABLE
520: , p1_a9 JTF_NUMBER_TABLE
521: , p2_a0 in out nocopy JTF_NUMBER_TABLE
522: , p2_a1 in out nocopy JTF_NUMBER_TABLE
523: , p2_a2 in out nocopy JTF_NUMBER_TABLE
524: , p2_a3 in out nocopy JTF_NUMBER_TABLE
525: , p2_a4 in out nocopy JTF_VARCHAR2_TABLE_100
518: , p1_a7 JTF_VARCHAR2_TABLE_100
519: , p1_a8 JTF_NUMBER_TABLE
520: , p1_a9 JTF_NUMBER_TABLE
521: , p2_a0 in out nocopy JTF_NUMBER_TABLE
522: , p2_a1 in out nocopy JTF_NUMBER_TABLE
523: , p2_a2 in out nocopy JTF_NUMBER_TABLE
524: , p2_a3 in out nocopy JTF_NUMBER_TABLE
525: , p2_a4 in out nocopy JTF_VARCHAR2_TABLE_100
526: , p2_a5 in out nocopy JTF_VARCHAR2_TABLE_300
519: , p1_a8 JTF_NUMBER_TABLE
520: , p1_a9 JTF_NUMBER_TABLE
521: , p2_a0 in out nocopy JTF_NUMBER_TABLE
522: , p2_a1 in out nocopy JTF_NUMBER_TABLE
523: , p2_a2 in out nocopy JTF_NUMBER_TABLE
524: , p2_a3 in out nocopy JTF_NUMBER_TABLE
525: , p2_a4 in out nocopy JTF_VARCHAR2_TABLE_100
526: , p2_a5 in out nocopy JTF_VARCHAR2_TABLE_300
527: , p2_a6 in out nocopy JTF_DATE_TABLE
520: , p1_a9 JTF_NUMBER_TABLE
521: , p2_a0 in out nocopy JTF_NUMBER_TABLE
522: , p2_a1 in out nocopy JTF_NUMBER_TABLE
523: , p2_a2 in out nocopy JTF_NUMBER_TABLE
524: , p2_a3 in out nocopy JTF_NUMBER_TABLE
525: , p2_a4 in out nocopy JTF_VARCHAR2_TABLE_100
526: , p2_a5 in out nocopy JTF_VARCHAR2_TABLE_300
527: , p2_a6 in out nocopy JTF_DATE_TABLE
528: , p2_a7 in out nocopy JTF_DATE_TABLE
525: , p2_a4 in out nocopy JTF_VARCHAR2_TABLE_100
526: , p2_a5 in out nocopy JTF_VARCHAR2_TABLE_300
527: , p2_a6 in out nocopy JTF_DATE_TABLE
528: , p2_a7 in out nocopy JTF_DATE_TABLE
529: , p2_a8 in out nocopy JTF_NUMBER_TABLE
530: , p3_a0 in out nocopy JTF_NUMBER_TABLE
531: , p3_a1 in out nocopy JTF_DATE_TABLE
532: , p3_a2 in out nocopy JTF_DATE_TABLE
533: , p3_a3 in out nocopy JTF_NUMBER_TABLE
526: , p2_a5 in out nocopy JTF_VARCHAR2_TABLE_300
527: , p2_a6 in out nocopy JTF_DATE_TABLE
528: , p2_a7 in out nocopy JTF_DATE_TABLE
529: , p2_a8 in out nocopy JTF_NUMBER_TABLE
530: , p3_a0 in out nocopy JTF_NUMBER_TABLE
531: , p3_a1 in out nocopy JTF_DATE_TABLE
532: , p3_a2 in out nocopy JTF_DATE_TABLE
533: , p3_a3 in out nocopy JTF_NUMBER_TABLE
534: , p3_a4 in out nocopy JTF_NUMBER_TABLE
529: , p2_a8 in out nocopy JTF_NUMBER_TABLE
530: , p3_a0 in out nocopy JTF_NUMBER_TABLE
531: , p3_a1 in out nocopy JTF_DATE_TABLE
532: , p3_a2 in out nocopy JTF_DATE_TABLE
533: , p3_a3 in out nocopy JTF_NUMBER_TABLE
534: , p3_a4 in out nocopy JTF_NUMBER_TABLE
535: , p3_a5 in out nocopy JTF_NUMBER_TABLE
536: , p3_a6 in out nocopy JTF_VARCHAR2_TABLE_100
537: , p3_a7 in out nocopy JTF_NUMBER_TABLE
530: , p3_a0 in out nocopy JTF_NUMBER_TABLE
531: , p3_a1 in out nocopy JTF_DATE_TABLE
532: , p3_a2 in out nocopy JTF_DATE_TABLE
533: , p3_a3 in out nocopy JTF_NUMBER_TABLE
534: , p3_a4 in out nocopy JTF_NUMBER_TABLE
535: , p3_a5 in out nocopy JTF_NUMBER_TABLE
536: , p3_a6 in out nocopy JTF_VARCHAR2_TABLE_100
537: , p3_a7 in out nocopy JTF_NUMBER_TABLE
538: , p3_a8 in out nocopy JTF_VARCHAR2_TABLE_100
531: , p3_a1 in out nocopy JTF_DATE_TABLE
532: , p3_a2 in out nocopy JTF_DATE_TABLE
533: , p3_a3 in out nocopy JTF_NUMBER_TABLE
534: , p3_a4 in out nocopy JTF_NUMBER_TABLE
535: , p3_a5 in out nocopy JTF_NUMBER_TABLE
536: , p3_a6 in out nocopy JTF_VARCHAR2_TABLE_100
537: , p3_a7 in out nocopy JTF_NUMBER_TABLE
538: , p3_a8 in out nocopy JTF_VARCHAR2_TABLE_100
539: , p3_a9 in out nocopy JTF_NUMBER_TABLE
533: , p3_a3 in out nocopy JTF_NUMBER_TABLE
534: , p3_a4 in out nocopy JTF_NUMBER_TABLE
535: , p3_a5 in out nocopy JTF_NUMBER_TABLE
536: , p3_a6 in out nocopy JTF_VARCHAR2_TABLE_100
537: , p3_a7 in out nocopy JTF_NUMBER_TABLE
538: , p3_a8 in out nocopy JTF_VARCHAR2_TABLE_100
539: , p3_a9 in out nocopy JTF_NUMBER_TABLE
540: , p3_a10 in out nocopy JTF_NUMBER_TABLE
541: , p3_a11 in out nocopy JTF_NUMBER_TABLE
535: , p3_a5 in out nocopy JTF_NUMBER_TABLE
536: , p3_a6 in out nocopy JTF_VARCHAR2_TABLE_100
537: , p3_a7 in out nocopy JTF_NUMBER_TABLE
538: , p3_a8 in out nocopy JTF_VARCHAR2_TABLE_100
539: , p3_a9 in out nocopy JTF_NUMBER_TABLE
540: , p3_a10 in out nocopy JTF_NUMBER_TABLE
541: , p3_a11 in out nocopy JTF_NUMBER_TABLE
542: , p3_a12 in out nocopy JTF_NUMBER_TABLE
543: , p3_a13 in out nocopy JTF_VARCHAR2_TABLE_100
536: , p3_a6 in out nocopy JTF_VARCHAR2_TABLE_100
537: , p3_a7 in out nocopy JTF_NUMBER_TABLE
538: , p3_a8 in out nocopy JTF_VARCHAR2_TABLE_100
539: , p3_a9 in out nocopy JTF_NUMBER_TABLE
540: , p3_a10 in out nocopy JTF_NUMBER_TABLE
541: , p3_a11 in out nocopy JTF_NUMBER_TABLE
542: , p3_a12 in out nocopy JTF_NUMBER_TABLE
543: , p3_a13 in out nocopy JTF_VARCHAR2_TABLE_100
544: , p3_a14 in out nocopy JTF_VARCHAR2_TABLE_100
537: , p3_a7 in out nocopy JTF_NUMBER_TABLE
538: , p3_a8 in out nocopy JTF_VARCHAR2_TABLE_100
539: , p3_a9 in out nocopy JTF_NUMBER_TABLE
540: , p3_a10 in out nocopy JTF_NUMBER_TABLE
541: , p3_a11 in out nocopy JTF_NUMBER_TABLE
542: , p3_a12 in out nocopy JTF_NUMBER_TABLE
543: , p3_a13 in out nocopy JTF_VARCHAR2_TABLE_100
544: , p3_a14 in out nocopy JTF_VARCHAR2_TABLE_100
545: , x_return_status out nocopy VARCHAR2
538: , p3_a8 in out nocopy JTF_VARCHAR2_TABLE_100
539: , p3_a9 in out nocopy JTF_NUMBER_TABLE
540: , p3_a10 in out nocopy JTF_NUMBER_TABLE
541: , p3_a11 in out nocopy JTF_NUMBER_TABLE
542: , p3_a12 in out nocopy JTF_NUMBER_TABLE
543: , p3_a13 in out nocopy JTF_VARCHAR2_TABLE_100
544: , p3_a14 in out nocopy JTF_VARCHAR2_TABLE_100
545: , x_return_status out nocopy VARCHAR2
546: , x_error_msg out nocopy VARCHAR2