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 okl_rpc_pvt.okl_repair_costs_tl_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_300
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_300
27: , a5 JTF_VARCHAR2_TABLE_2000
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_DATE_TABLE
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_DATE_TABLE
32: , a10 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_300
27: , a5 JTF_VARCHAR2_TABLE_2000
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_DATE_TABLE
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_DATE_TABLE
32: , a10 JTF_NUMBER_TABLE
33: ) as
34: ddindx binary_integer; indx binary_integer;
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_DATE_TABLE
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_DATE_TABLE
32: , a10 JTF_NUMBER_TABLE
33: ) as
34: ddindx binary_integer; indx binary_integer;
35: begin
36: if a0 is not null and a0.count > 0 then
57: end loop;
58: end if;
59: end if;
60: end rosetta_table_copy_in_p2;
61: procedure rosetta_table_copy_out_p2(t okl_rpc_pvt.okl_repair_costs_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
62: , a1 out nocopy JTF_VARCHAR2_TABLE_100
63: , a2 out nocopy JTF_VARCHAR2_TABLE_100
64: , a3 out nocopy JTF_VARCHAR2_TABLE_100
65: , a4 out nocopy JTF_VARCHAR2_TABLE_300
63: , a2 out nocopy JTF_VARCHAR2_TABLE_100
64: , a3 out nocopy JTF_VARCHAR2_TABLE_100
65: , a4 out nocopy JTF_VARCHAR2_TABLE_300
66: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
67: , a6 out nocopy JTF_NUMBER_TABLE
68: , a7 out nocopy JTF_DATE_TABLE
69: , a8 out nocopy JTF_NUMBER_TABLE
70: , a9 out nocopy JTF_DATE_TABLE
71: , a10 out nocopy JTF_NUMBER_TABLE
65: , a4 out nocopy JTF_VARCHAR2_TABLE_300
66: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
67: , a6 out nocopy JTF_NUMBER_TABLE
68: , a7 out nocopy JTF_DATE_TABLE
69: , a8 out nocopy JTF_NUMBER_TABLE
70: , a9 out nocopy JTF_DATE_TABLE
71: , a10 out nocopy JTF_NUMBER_TABLE
72: ) as
73: ddindx binary_integer; indx binary_integer;
67: , a6 out nocopy JTF_NUMBER_TABLE
68: , a7 out nocopy JTF_DATE_TABLE
69: , a8 out nocopy JTF_NUMBER_TABLE
70: , a9 out nocopy JTF_DATE_TABLE
71: , a10 out nocopy JTF_NUMBER_TABLE
72: ) as
73: ddindx binary_integer; indx binary_integer;
74: begin
75: if t is null or t.count = 0 then
72: ) as
73: ddindx binary_integer; indx binary_integer;
74: begin
75: if t is null or t.count = 0 then
76: a0 := JTF_NUMBER_TABLE();
77: a1 := JTF_VARCHAR2_TABLE_100();
78: a2 := JTF_VARCHAR2_TABLE_100();
79: a3 := JTF_VARCHAR2_TABLE_100();
80: a4 := JTF_VARCHAR2_TABLE_300();
78: a2 := JTF_VARCHAR2_TABLE_100();
79: a3 := JTF_VARCHAR2_TABLE_100();
80: a4 := JTF_VARCHAR2_TABLE_300();
81: a5 := JTF_VARCHAR2_TABLE_2000();
82: a6 := JTF_NUMBER_TABLE();
83: a7 := JTF_DATE_TABLE();
84: a8 := JTF_NUMBER_TABLE();
85: a9 := JTF_DATE_TABLE();
86: a10 := JTF_NUMBER_TABLE();
80: a4 := JTF_VARCHAR2_TABLE_300();
81: a5 := JTF_VARCHAR2_TABLE_2000();
82: a6 := JTF_NUMBER_TABLE();
83: a7 := JTF_DATE_TABLE();
84: a8 := JTF_NUMBER_TABLE();
85: a9 := JTF_DATE_TABLE();
86: a10 := JTF_NUMBER_TABLE();
87: else
88: a0 := JTF_NUMBER_TABLE();
82: a6 := JTF_NUMBER_TABLE();
83: a7 := JTF_DATE_TABLE();
84: a8 := JTF_NUMBER_TABLE();
85: a9 := JTF_DATE_TABLE();
86: a10 := JTF_NUMBER_TABLE();
87: else
88: a0 := JTF_NUMBER_TABLE();
89: a1 := JTF_VARCHAR2_TABLE_100();
90: a2 := JTF_VARCHAR2_TABLE_100();
84: a8 := JTF_NUMBER_TABLE();
85: a9 := JTF_DATE_TABLE();
86: a10 := JTF_NUMBER_TABLE();
87: else
88: a0 := JTF_NUMBER_TABLE();
89: a1 := JTF_VARCHAR2_TABLE_100();
90: a2 := JTF_VARCHAR2_TABLE_100();
91: a3 := JTF_VARCHAR2_TABLE_100();
92: a4 := JTF_VARCHAR2_TABLE_300();
90: a2 := JTF_VARCHAR2_TABLE_100();
91: a3 := JTF_VARCHAR2_TABLE_100();
92: a4 := JTF_VARCHAR2_TABLE_300();
93: a5 := JTF_VARCHAR2_TABLE_2000();
94: a6 := JTF_NUMBER_TABLE();
95: a7 := JTF_DATE_TABLE();
96: a8 := JTF_NUMBER_TABLE();
97: a9 := JTF_DATE_TABLE();
98: a10 := JTF_NUMBER_TABLE();
92: a4 := JTF_VARCHAR2_TABLE_300();
93: a5 := JTF_VARCHAR2_TABLE_2000();
94: a6 := JTF_NUMBER_TABLE();
95: a7 := JTF_DATE_TABLE();
96: a8 := JTF_NUMBER_TABLE();
97: a9 := JTF_DATE_TABLE();
98: a10 := JTF_NUMBER_TABLE();
99: if t.count > 0 then
100: a0.extend(t.count);
94: a6 := JTF_NUMBER_TABLE();
95: a7 := JTF_DATE_TABLE();
96: a8 := JTF_NUMBER_TABLE();
97: a9 := JTF_DATE_TABLE();
98: a10 := JTF_NUMBER_TABLE();
99: if t.count > 0 then
100: a0.extend(t.count);
101: a1.extend(t.count);
102: a2.extend(t.count);
131: end if;
132: end if;
133: end rosetta_table_copy_out_p2;
134:
135: procedure rosetta_table_copy_in_p5(t out nocopy okl_rpc_pvt.rpc_tbl_type, a0 JTF_NUMBER_TABLE
136: , a1 JTF_NUMBER_TABLE
137: , a2 JTF_VARCHAR2_TABLE_100
138: , a3 JTF_NUMBER_TABLE
139: , a4 JTF_NUMBER_TABLE
132: end if;
133: end rosetta_table_copy_out_p2;
134:
135: procedure rosetta_table_copy_in_p5(t out nocopy okl_rpc_pvt.rpc_tbl_type, a0 JTF_NUMBER_TABLE
136: , a1 JTF_NUMBER_TABLE
137: , a2 JTF_VARCHAR2_TABLE_100
138: , a3 JTF_NUMBER_TABLE
139: , a4 JTF_NUMBER_TABLE
140: , a5 JTF_NUMBER_TABLE
134:
135: procedure rosetta_table_copy_in_p5(t out nocopy okl_rpc_pvt.rpc_tbl_type, a0 JTF_NUMBER_TABLE
136: , a1 JTF_NUMBER_TABLE
137: , a2 JTF_VARCHAR2_TABLE_100
138: , a3 JTF_NUMBER_TABLE
139: , a4 JTF_NUMBER_TABLE
140: , a5 JTF_NUMBER_TABLE
141: , a6 JTF_DATE_TABLE
142: , a7 JTF_NUMBER_TABLE
135: procedure rosetta_table_copy_in_p5(t out nocopy okl_rpc_pvt.rpc_tbl_type, a0 JTF_NUMBER_TABLE
136: , a1 JTF_NUMBER_TABLE
137: , a2 JTF_VARCHAR2_TABLE_100
138: , a3 JTF_NUMBER_TABLE
139: , a4 JTF_NUMBER_TABLE
140: , a5 JTF_NUMBER_TABLE
141: , a6 JTF_DATE_TABLE
142: , a7 JTF_NUMBER_TABLE
143: , a8 JTF_DATE_TABLE
136: , a1 JTF_NUMBER_TABLE
137: , a2 JTF_VARCHAR2_TABLE_100
138: , a3 JTF_NUMBER_TABLE
139: , a4 JTF_NUMBER_TABLE
140: , a5 JTF_NUMBER_TABLE
141: , a6 JTF_DATE_TABLE
142: , a7 JTF_NUMBER_TABLE
143: , a8 JTF_DATE_TABLE
144: , a9 JTF_NUMBER_TABLE
138: , a3 JTF_NUMBER_TABLE
139: , a4 JTF_NUMBER_TABLE
140: , a5 JTF_NUMBER_TABLE
141: , a6 JTF_DATE_TABLE
142: , a7 JTF_NUMBER_TABLE
143: , a8 JTF_DATE_TABLE
144: , a9 JTF_NUMBER_TABLE
145: , a10 JTF_VARCHAR2_TABLE_100
146: , a11 JTF_VARCHAR2_TABLE_100
140: , a5 JTF_NUMBER_TABLE
141: , a6 JTF_DATE_TABLE
142: , a7 JTF_NUMBER_TABLE
143: , a8 JTF_DATE_TABLE
144: , a9 JTF_NUMBER_TABLE
145: , a10 JTF_VARCHAR2_TABLE_100
146: , a11 JTF_VARCHAR2_TABLE_100
147: , a12 JTF_VARCHAR2_TABLE_100
148: , a13 JTF_NUMBER_TABLE
144: , a9 JTF_NUMBER_TABLE
145: , a10 JTF_VARCHAR2_TABLE_100
146: , a11 JTF_VARCHAR2_TABLE_100
147: , a12 JTF_VARCHAR2_TABLE_100
148: , a13 JTF_NUMBER_TABLE
149: , a14 JTF_DATE_TABLE
150: ) as
151: ddindx binary_integer; indx binary_integer;
152: begin
178: end loop;
179: end if;
180: end if;
181: end rosetta_table_copy_in_p5;
182: procedure rosetta_table_copy_out_p5(t okl_rpc_pvt.rpc_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
183: , a1 out nocopy JTF_NUMBER_TABLE
184: , a2 out nocopy JTF_VARCHAR2_TABLE_100
185: , a3 out nocopy JTF_NUMBER_TABLE
186: , a4 out nocopy JTF_NUMBER_TABLE
179: end if;
180: end if;
181: end rosetta_table_copy_in_p5;
182: procedure rosetta_table_copy_out_p5(t okl_rpc_pvt.rpc_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
183: , a1 out nocopy JTF_NUMBER_TABLE
184: , a2 out nocopy JTF_VARCHAR2_TABLE_100
185: , a3 out nocopy JTF_NUMBER_TABLE
186: , a4 out nocopy JTF_NUMBER_TABLE
187: , a5 out nocopy JTF_NUMBER_TABLE
181: end rosetta_table_copy_in_p5;
182: procedure rosetta_table_copy_out_p5(t okl_rpc_pvt.rpc_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
183: , a1 out nocopy JTF_NUMBER_TABLE
184: , a2 out nocopy JTF_VARCHAR2_TABLE_100
185: , a3 out nocopy JTF_NUMBER_TABLE
186: , a4 out nocopy JTF_NUMBER_TABLE
187: , a5 out nocopy JTF_NUMBER_TABLE
188: , a6 out nocopy JTF_DATE_TABLE
189: , a7 out nocopy JTF_NUMBER_TABLE
182: procedure rosetta_table_copy_out_p5(t okl_rpc_pvt.rpc_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
183: , a1 out nocopy JTF_NUMBER_TABLE
184: , a2 out nocopy JTF_VARCHAR2_TABLE_100
185: , a3 out nocopy JTF_NUMBER_TABLE
186: , a4 out nocopy JTF_NUMBER_TABLE
187: , a5 out nocopy JTF_NUMBER_TABLE
188: , a6 out nocopy JTF_DATE_TABLE
189: , a7 out nocopy JTF_NUMBER_TABLE
190: , a8 out nocopy JTF_DATE_TABLE
183: , a1 out nocopy JTF_NUMBER_TABLE
184: , a2 out nocopy JTF_VARCHAR2_TABLE_100
185: , a3 out nocopy JTF_NUMBER_TABLE
186: , a4 out nocopy JTF_NUMBER_TABLE
187: , a5 out nocopy JTF_NUMBER_TABLE
188: , a6 out nocopy JTF_DATE_TABLE
189: , a7 out nocopy JTF_NUMBER_TABLE
190: , a8 out nocopy JTF_DATE_TABLE
191: , a9 out nocopy JTF_NUMBER_TABLE
185: , a3 out nocopy JTF_NUMBER_TABLE
186: , a4 out nocopy JTF_NUMBER_TABLE
187: , a5 out nocopy JTF_NUMBER_TABLE
188: , a6 out nocopy JTF_DATE_TABLE
189: , a7 out nocopy JTF_NUMBER_TABLE
190: , a8 out nocopy JTF_DATE_TABLE
191: , a9 out nocopy JTF_NUMBER_TABLE
192: , a10 out nocopy JTF_VARCHAR2_TABLE_100
193: , a11 out nocopy JTF_VARCHAR2_TABLE_100
187: , a5 out nocopy JTF_NUMBER_TABLE
188: , a6 out nocopy JTF_DATE_TABLE
189: , a7 out nocopy JTF_NUMBER_TABLE
190: , a8 out nocopy JTF_DATE_TABLE
191: , a9 out nocopy JTF_NUMBER_TABLE
192: , a10 out nocopy JTF_VARCHAR2_TABLE_100
193: , a11 out nocopy JTF_VARCHAR2_TABLE_100
194: , a12 out nocopy JTF_VARCHAR2_TABLE_100
195: , a13 out nocopy JTF_NUMBER_TABLE
191: , a9 out nocopy JTF_NUMBER_TABLE
192: , a10 out nocopy JTF_VARCHAR2_TABLE_100
193: , a11 out nocopy JTF_VARCHAR2_TABLE_100
194: , a12 out nocopy JTF_VARCHAR2_TABLE_100
195: , a13 out nocopy JTF_NUMBER_TABLE
196: , a14 out nocopy JTF_DATE_TABLE
197: ) as
198: ddindx binary_integer; indx binary_integer;
199: begin
197: ) as
198: ddindx binary_integer; indx binary_integer;
199: begin
200: if t is null or t.count = 0 then
201: a0 := JTF_NUMBER_TABLE();
202: a1 := JTF_NUMBER_TABLE();
203: a2 := JTF_VARCHAR2_TABLE_100();
204: a3 := JTF_NUMBER_TABLE();
205: a4 := JTF_NUMBER_TABLE();
198: ddindx binary_integer; indx binary_integer;
199: begin
200: if t is null or t.count = 0 then
201: a0 := JTF_NUMBER_TABLE();
202: a1 := JTF_NUMBER_TABLE();
203: a2 := JTF_VARCHAR2_TABLE_100();
204: a3 := JTF_NUMBER_TABLE();
205: a4 := JTF_NUMBER_TABLE();
206: a5 := JTF_NUMBER_TABLE();
200: if t is null or t.count = 0 then
201: a0 := JTF_NUMBER_TABLE();
202: a1 := JTF_NUMBER_TABLE();
203: a2 := JTF_VARCHAR2_TABLE_100();
204: a3 := JTF_NUMBER_TABLE();
205: a4 := JTF_NUMBER_TABLE();
206: a5 := JTF_NUMBER_TABLE();
207: a6 := JTF_DATE_TABLE();
208: a7 := JTF_NUMBER_TABLE();
201: a0 := JTF_NUMBER_TABLE();
202: a1 := JTF_NUMBER_TABLE();
203: a2 := JTF_VARCHAR2_TABLE_100();
204: a3 := JTF_NUMBER_TABLE();
205: a4 := JTF_NUMBER_TABLE();
206: a5 := JTF_NUMBER_TABLE();
207: a6 := JTF_DATE_TABLE();
208: a7 := JTF_NUMBER_TABLE();
209: a8 := JTF_DATE_TABLE();
202: a1 := JTF_NUMBER_TABLE();
203: a2 := JTF_VARCHAR2_TABLE_100();
204: a3 := JTF_NUMBER_TABLE();
205: a4 := JTF_NUMBER_TABLE();
206: a5 := JTF_NUMBER_TABLE();
207: a6 := JTF_DATE_TABLE();
208: a7 := JTF_NUMBER_TABLE();
209: a8 := JTF_DATE_TABLE();
210: a9 := JTF_NUMBER_TABLE();
204: a3 := JTF_NUMBER_TABLE();
205: a4 := JTF_NUMBER_TABLE();
206: a5 := JTF_NUMBER_TABLE();
207: a6 := JTF_DATE_TABLE();
208: a7 := JTF_NUMBER_TABLE();
209: a8 := JTF_DATE_TABLE();
210: a9 := JTF_NUMBER_TABLE();
211: a10 := JTF_VARCHAR2_TABLE_100();
212: a11 := JTF_VARCHAR2_TABLE_100();
206: a5 := JTF_NUMBER_TABLE();
207: a6 := JTF_DATE_TABLE();
208: a7 := JTF_NUMBER_TABLE();
209: a8 := JTF_DATE_TABLE();
210: a9 := JTF_NUMBER_TABLE();
211: a10 := JTF_VARCHAR2_TABLE_100();
212: a11 := JTF_VARCHAR2_TABLE_100();
213: a12 := JTF_VARCHAR2_TABLE_100();
214: a13 := JTF_NUMBER_TABLE();
210: a9 := JTF_NUMBER_TABLE();
211: a10 := JTF_VARCHAR2_TABLE_100();
212: a11 := JTF_VARCHAR2_TABLE_100();
213: a12 := JTF_VARCHAR2_TABLE_100();
214: a13 := JTF_NUMBER_TABLE();
215: a14 := JTF_DATE_TABLE();
216: else
217: a0 := JTF_NUMBER_TABLE();
218: a1 := JTF_NUMBER_TABLE();
213: a12 := JTF_VARCHAR2_TABLE_100();
214: a13 := JTF_NUMBER_TABLE();
215: a14 := JTF_DATE_TABLE();
216: else
217: a0 := JTF_NUMBER_TABLE();
218: a1 := JTF_NUMBER_TABLE();
219: a2 := JTF_VARCHAR2_TABLE_100();
220: a3 := JTF_NUMBER_TABLE();
221: a4 := JTF_NUMBER_TABLE();
214: a13 := JTF_NUMBER_TABLE();
215: a14 := JTF_DATE_TABLE();
216: else
217: a0 := JTF_NUMBER_TABLE();
218: a1 := JTF_NUMBER_TABLE();
219: a2 := JTF_VARCHAR2_TABLE_100();
220: a3 := JTF_NUMBER_TABLE();
221: a4 := JTF_NUMBER_TABLE();
222: a5 := JTF_NUMBER_TABLE();
216: else
217: a0 := JTF_NUMBER_TABLE();
218: a1 := JTF_NUMBER_TABLE();
219: a2 := JTF_VARCHAR2_TABLE_100();
220: a3 := JTF_NUMBER_TABLE();
221: a4 := JTF_NUMBER_TABLE();
222: a5 := JTF_NUMBER_TABLE();
223: a6 := JTF_DATE_TABLE();
224: a7 := JTF_NUMBER_TABLE();
217: a0 := JTF_NUMBER_TABLE();
218: a1 := JTF_NUMBER_TABLE();
219: a2 := JTF_VARCHAR2_TABLE_100();
220: a3 := JTF_NUMBER_TABLE();
221: a4 := JTF_NUMBER_TABLE();
222: a5 := JTF_NUMBER_TABLE();
223: a6 := JTF_DATE_TABLE();
224: a7 := JTF_NUMBER_TABLE();
225: a8 := JTF_DATE_TABLE();
218: a1 := JTF_NUMBER_TABLE();
219: a2 := JTF_VARCHAR2_TABLE_100();
220: a3 := JTF_NUMBER_TABLE();
221: a4 := JTF_NUMBER_TABLE();
222: a5 := JTF_NUMBER_TABLE();
223: a6 := JTF_DATE_TABLE();
224: a7 := JTF_NUMBER_TABLE();
225: a8 := JTF_DATE_TABLE();
226: a9 := JTF_NUMBER_TABLE();
220: a3 := JTF_NUMBER_TABLE();
221: a4 := JTF_NUMBER_TABLE();
222: a5 := JTF_NUMBER_TABLE();
223: a6 := JTF_DATE_TABLE();
224: a7 := JTF_NUMBER_TABLE();
225: a8 := JTF_DATE_TABLE();
226: a9 := JTF_NUMBER_TABLE();
227: a10 := JTF_VARCHAR2_TABLE_100();
228: a11 := JTF_VARCHAR2_TABLE_100();
222: a5 := JTF_NUMBER_TABLE();
223: a6 := JTF_DATE_TABLE();
224: a7 := JTF_NUMBER_TABLE();
225: a8 := JTF_DATE_TABLE();
226: a9 := JTF_NUMBER_TABLE();
227: a10 := JTF_VARCHAR2_TABLE_100();
228: a11 := JTF_VARCHAR2_TABLE_100();
229: a12 := JTF_VARCHAR2_TABLE_100();
230: a13 := JTF_NUMBER_TABLE();
226: a9 := JTF_NUMBER_TABLE();
227: a10 := JTF_VARCHAR2_TABLE_100();
228: a11 := JTF_VARCHAR2_TABLE_100();
229: a12 := JTF_VARCHAR2_TABLE_100();
230: a13 := JTF_NUMBER_TABLE();
231: a14 := JTF_DATE_TABLE();
232: if t.count > 0 then
233: a0.extend(t.count);
234: a1.extend(t.count);
272: end if;
273: end if;
274: end rosetta_table_copy_out_p5;
275:
276: procedure rosetta_table_copy_in_p8(t out nocopy okl_rpc_pvt.rpcv_tbl_type, a0 JTF_NUMBER_TABLE
277: , a1 JTF_NUMBER_TABLE
278: , a2 JTF_VARCHAR2_TABLE_100
279: , a3 JTF_VARCHAR2_TABLE_100
280: , a4 JTF_NUMBER_TABLE
273: end if;
274: end rosetta_table_copy_out_p5;
275:
276: procedure rosetta_table_copy_in_p8(t out nocopy okl_rpc_pvt.rpcv_tbl_type, a0 JTF_NUMBER_TABLE
277: , a1 JTF_NUMBER_TABLE
278: , a2 JTF_VARCHAR2_TABLE_100
279: , a3 JTF_VARCHAR2_TABLE_100
280: , a4 JTF_NUMBER_TABLE
281: , a5 JTF_VARCHAR2_TABLE_300
276: procedure rosetta_table_copy_in_p8(t out nocopy okl_rpc_pvt.rpcv_tbl_type, a0 JTF_NUMBER_TABLE
277: , a1 JTF_NUMBER_TABLE
278: , a2 JTF_VARCHAR2_TABLE_100
279: , a3 JTF_VARCHAR2_TABLE_100
280: , a4 JTF_NUMBER_TABLE
281: , a5 JTF_VARCHAR2_TABLE_300
282: , a6 JTF_VARCHAR2_TABLE_2000
283: , a7 JTF_NUMBER_TABLE
284: , a8 JTF_NUMBER_TABLE
279: , a3 JTF_VARCHAR2_TABLE_100
280: , a4 JTF_NUMBER_TABLE
281: , a5 JTF_VARCHAR2_TABLE_300
282: , a6 JTF_VARCHAR2_TABLE_2000
283: , a7 JTF_NUMBER_TABLE
284: , a8 JTF_NUMBER_TABLE
285: , a9 JTF_DATE_TABLE
286: , a10 JTF_NUMBER_TABLE
287: , a11 JTF_DATE_TABLE
280: , a4 JTF_NUMBER_TABLE
281: , a5 JTF_VARCHAR2_TABLE_300
282: , a6 JTF_VARCHAR2_TABLE_2000
283: , a7 JTF_NUMBER_TABLE
284: , a8 JTF_NUMBER_TABLE
285: , a9 JTF_DATE_TABLE
286: , a10 JTF_NUMBER_TABLE
287: , a11 JTF_DATE_TABLE
288: , a12 JTF_NUMBER_TABLE
282: , a6 JTF_VARCHAR2_TABLE_2000
283: , a7 JTF_NUMBER_TABLE
284: , a8 JTF_NUMBER_TABLE
285: , a9 JTF_DATE_TABLE
286: , a10 JTF_NUMBER_TABLE
287: , a11 JTF_DATE_TABLE
288: , a12 JTF_NUMBER_TABLE
289: , a13 JTF_VARCHAR2_TABLE_100
290: , a14 JTF_VARCHAR2_TABLE_100
284: , a8 JTF_NUMBER_TABLE
285: , a9 JTF_DATE_TABLE
286: , a10 JTF_NUMBER_TABLE
287: , a11 JTF_DATE_TABLE
288: , a12 JTF_NUMBER_TABLE
289: , a13 JTF_VARCHAR2_TABLE_100
290: , a14 JTF_VARCHAR2_TABLE_100
291: , a15 JTF_VARCHAR2_TABLE_100
292: , a16 JTF_NUMBER_TABLE
288: , a12 JTF_NUMBER_TABLE
289: , a13 JTF_VARCHAR2_TABLE_100
290: , a14 JTF_VARCHAR2_TABLE_100
291: , a15 JTF_VARCHAR2_TABLE_100
292: , a16 JTF_NUMBER_TABLE
293: , a17 JTF_DATE_TABLE
294: ) as
295: ddindx binary_integer; indx binary_integer;
296: begin
325: end loop;
326: end if;
327: end if;
328: end rosetta_table_copy_in_p8;
329: procedure rosetta_table_copy_out_p8(t okl_rpc_pvt.rpcv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
330: , a1 out nocopy JTF_NUMBER_TABLE
331: , a2 out nocopy JTF_VARCHAR2_TABLE_100
332: , a3 out nocopy JTF_VARCHAR2_TABLE_100
333: , a4 out nocopy JTF_NUMBER_TABLE
326: end if;
327: end if;
328: end rosetta_table_copy_in_p8;
329: procedure rosetta_table_copy_out_p8(t okl_rpc_pvt.rpcv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
330: , a1 out nocopy JTF_NUMBER_TABLE
331: , a2 out nocopy JTF_VARCHAR2_TABLE_100
332: , a3 out nocopy JTF_VARCHAR2_TABLE_100
333: , a4 out nocopy JTF_NUMBER_TABLE
334: , a5 out nocopy JTF_VARCHAR2_TABLE_300
329: procedure rosetta_table_copy_out_p8(t okl_rpc_pvt.rpcv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
330: , a1 out nocopy JTF_NUMBER_TABLE
331: , a2 out nocopy JTF_VARCHAR2_TABLE_100
332: , a3 out nocopy JTF_VARCHAR2_TABLE_100
333: , a4 out nocopy JTF_NUMBER_TABLE
334: , a5 out nocopy JTF_VARCHAR2_TABLE_300
335: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
336: , a7 out nocopy JTF_NUMBER_TABLE
337: , a8 out nocopy JTF_NUMBER_TABLE
332: , a3 out nocopy JTF_VARCHAR2_TABLE_100
333: , a4 out nocopy JTF_NUMBER_TABLE
334: , a5 out nocopy JTF_VARCHAR2_TABLE_300
335: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
336: , a7 out nocopy JTF_NUMBER_TABLE
337: , a8 out nocopy JTF_NUMBER_TABLE
338: , a9 out nocopy JTF_DATE_TABLE
339: , a10 out nocopy JTF_NUMBER_TABLE
340: , a11 out nocopy JTF_DATE_TABLE
333: , a4 out nocopy JTF_NUMBER_TABLE
334: , a5 out nocopy JTF_VARCHAR2_TABLE_300
335: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
336: , a7 out nocopy JTF_NUMBER_TABLE
337: , a8 out nocopy JTF_NUMBER_TABLE
338: , a9 out nocopy JTF_DATE_TABLE
339: , a10 out nocopy JTF_NUMBER_TABLE
340: , a11 out nocopy JTF_DATE_TABLE
341: , a12 out nocopy JTF_NUMBER_TABLE
335: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
336: , a7 out nocopy JTF_NUMBER_TABLE
337: , a8 out nocopy JTF_NUMBER_TABLE
338: , a9 out nocopy JTF_DATE_TABLE
339: , a10 out nocopy JTF_NUMBER_TABLE
340: , a11 out nocopy JTF_DATE_TABLE
341: , a12 out nocopy JTF_NUMBER_TABLE
342: , a13 out nocopy JTF_VARCHAR2_TABLE_100
343: , a14 out nocopy JTF_VARCHAR2_TABLE_100
337: , a8 out nocopy JTF_NUMBER_TABLE
338: , a9 out nocopy JTF_DATE_TABLE
339: , a10 out nocopy JTF_NUMBER_TABLE
340: , a11 out nocopy JTF_DATE_TABLE
341: , a12 out nocopy JTF_NUMBER_TABLE
342: , a13 out nocopy JTF_VARCHAR2_TABLE_100
343: , a14 out nocopy JTF_VARCHAR2_TABLE_100
344: , a15 out nocopy JTF_VARCHAR2_TABLE_100
345: , a16 out nocopy JTF_NUMBER_TABLE
341: , a12 out nocopy JTF_NUMBER_TABLE
342: , a13 out nocopy JTF_VARCHAR2_TABLE_100
343: , a14 out nocopy JTF_VARCHAR2_TABLE_100
344: , a15 out nocopy JTF_VARCHAR2_TABLE_100
345: , a16 out nocopy JTF_NUMBER_TABLE
346: , a17 out nocopy JTF_DATE_TABLE
347: ) as
348: ddindx binary_integer; indx binary_integer;
349: begin
347: ) as
348: ddindx binary_integer; indx binary_integer;
349: begin
350: if t is null or t.count = 0 then
351: a0 := JTF_NUMBER_TABLE();
352: a1 := JTF_NUMBER_TABLE();
353: a2 := JTF_VARCHAR2_TABLE_100();
354: a3 := JTF_VARCHAR2_TABLE_100();
355: a4 := JTF_NUMBER_TABLE();
348: ddindx binary_integer; indx binary_integer;
349: begin
350: if t is null or t.count = 0 then
351: a0 := JTF_NUMBER_TABLE();
352: a1 := JTF_NUMBER_TABLE();
353: a2 := JTF_VARCHAR2_TABLE_100();
354: a3 := JTF_VARCHAR2_TABLE_100();
355: a4 := JTF_NUMBER_TABLE();
356: a5 := JTF_VARCHAR2_TABLE_300();
351: a0 := JTF_NUMBER_TABLE();
352: a1 := JTF_NUMBER_TABLE();
353: a2 := JTF_VARCHAR2_TABLE_100();
354: a3 := JTF_VARCHAR2_TABLE_100();
355: a4 := JTF_NUMBER_TABLE();
356: a5 := JTF_VARCHAR2_TABLE_300();
357: a6 := JTF_VARCHAR2_TABLE_2000();
358: a7 := JTF_NUMBER_TABLE();
359: a8 := JTF_NUMBER_TABLE();
354: a3 := JTF_VARCHAR2_TABLE_100();
355: a4 := JTF_NUMBER_TABLE();
356: a5 := JTF_VARCHAR2_TABLE_300();
357: a6 := JTF_VARCHAR2_TABLE_2000();
358: a7 := JTF_NUMBER_TABLE();
359: a8 := JTF_NUMBER_TABLE();
360: a9 := JTF_DATE_TABLE();
361: a10 := JTF_NUMBER_TABLE();
362: a11 := JTF_DATE_TABLE();
355: a4 := JTF_NUMBER_TABLE();
356: a5 := JTF_VARCHAR2_TABLE_300();
357: a6 := JTF_VARCHAR2_TABLE_2000();
358: a7 := JTF_NUMBER_TABLE();
359: a8 := JTF_NUMBER_TABLE();
360: a9 := JTF_DATE_TABLE();
361: a10 := JTF_NUMBER_TABLE();
362: a11 := JTF_DATE_TABLE();
363: a12 := JTF_NUMBER_TABLE();
357: a6 := JTF_VARCHAR2_TABLE_2000();
358: a7 := JTF_NUMBER_TABLE();
359: a8 := JTF_NUMBER_TABLE();
360: a9 := JTF_DATE_TABLE();
361: a10 := JTF_NUMBER_TABLE();
362: a11 := JTF_DATE_TABLE();
363: a12 := JTF_NUMBER_TABLE();
364: a13 := JTF_VARCHAR2_TABLE_100();
365: a14 := JTF_VARCHAR2_TABLE_100();
359: a8 := JTF_NUMBER_TABLE();
360: a9 := JTF_DATE_TABLE();
361: a10 := JTF_NUMBER_TABLE();
362: a11 := JTF_DATE_TABLE();
363: a12 := JTF_NUMBER_TABLE();
364: a13 := JTF_VARCHAR2_TABLE_100();
365: a14 := JTF_VARCHAR2_TABLE_100();
366: a15 := JTF_VARCHAR2_TABLE_100();
367: a16 := JTF_NUMBER_TABLE();
363: a12 := JTF_NUMBER_TABLE();
364: a13 := JTF_VARCHAR2_TABLE_100();
365: a14 := JTF_VARCHAR2_TABLE_100();
366: a15 := JTF_VARCHAR2_TABLE_100();
367: a16 := JTF_NUMBER_TABLE();
368: a17 := JTF_DATE_TABLE();
369: else
370: a0 := JTF_NUMBER_TABLE();
371: a1 := JTF_NUMBER_TABLE();
366: a15 := JTF_VARCHAR2_TABLE_100();
367: a16 := JTF_NUMBER_TABLE();
368: a17 := JTF_DATE_TABLE();
369: else
370: a0 := JTF_NUMBER_TABLE();
371: a1 := JTF_NUMBER_TABLE();
372: a2 := JTF_VARCHAR2_TABLE_100();
373: a3 := JTF_VARCHAR2_TABLE_100();
374: a4 := JTF_NUMBER_TABLE();
367: a16 := JTF_NUMBER_TABLE();
368: a17 := JTF_DATE_TABLE();
369: else
370: a0 := JTF_NUMBER_TABLE();
371: a1 := JTF_NUMBER_TABLE();
372: a2 := JTF_VARCHAR2_TABLE_100();
373: a3 := JTF_VARCHAR2_TABLE_100();
374: a4 := JTF_NUMBER_TABLE();
375: a5 := JTF_VARCHAR2_TABLE_300();
370: a0 := JTF_NUMBER_TABLE();
371: a1 := JTF_NUMBER_TABLE();
372: a2 := JTF_VARCHAR2_TABLE_100();
373: a3 := JTF_VARCHAR2_TABLE_100();
374: a4 := JTF_NUMBER_TABLE();
375: a5 := JTF_VARCHAR2_TABLE_300();
376: a6 := JTF_VARCHAR2_TABLE_2000();
377: a7 := JTF_NUMBER_TABLE();
378: a8 := JTF_NUMBER_TABLE();
373: a3 := JTF_VARCHAR2_TABLE_100();
374: a4 := JTF_NUMBER_TABLE();
375: a5 := JTF_VARCHAR2_TABLE_300();
376: a6 := JTF_VARCHAR2_TABLE_2000();
377: a7 := JTF_NUMBER_TABLE();
378: a8 := JTF_NUMBER_TABLE();
379: a9 := JTF_DATE_TABLE();
380: a10 := JTF_NUMBER_TABLE();
381: a11 := JTF_DATE_TABLE();
374: a4 := JTF_NUMBER_TABLE();
375: a5 := JTF_VARCHAR2_TABLE_300();
376: a6 := JTF_VARCHAR2_TABLE_2000();
377: a7 := JTF_NUMBER_TABLE();
378: a8 := JTF_NUMBER_TABLE();
379: a9 := JTF_DATE_TABLE();
380: a10 := JTF_NUMBER_TABLE();
381: a11 := JTF_DATE_TABLE();
382: a12 := JTF_NUMBER_TABLE();
376: a6 := JTF_VARCHAR2_TABLE_2000();
377: a7 := JTF_NUMBER_TABLE();
378: a8 := JTF_NUMBER_TABLE();
379: a9 := JTF_DATE_TABLE();
380: a10 := JTF_NUMBER_TABLE();
381: a11 := JTF_DATE_TABLE();
382: a12 := JTF_NUMBER_TABLE();
383: a13 := JTF_VARCHAR2_TABLE_100();
384: a14 := JTF_VARCHAR2_TABLE_100();
378: a8 := JTF_NUMBER_TABLE();
379: a9 := JTF_DATE_TABLE();
380: a10 := JTF_NUMBER_TABLE();
381: a11 := JTF_DATE_TABLE();
382: a12 := JTF_NUMBER_TABLE();
383: a13 := JTF_VARCHAR2_TABLE_100();
384: a14 := JTF_VARCHAR2_TABLE_100();
385: a15 := JTF_VARCHAR2_TABLE_100();
386: a16 := JTF_NUMBER_TABLE();
382: a12 := JTF_NUMBER_TABLE();
383: a13 := JTF_VARCHAR2_TABLE_100();
384: a14 := JTF_VARCHAR2_TABLE_100();
385: a15 := JTF_VARCHAR2_TABLE_100();
386: a16 := JTF_NUMBER_TABLE();
387: a17 := JTF_DATE_TABLE();
388: if t.count > 0 then
389: a0.extend(t.count);
390: a1.extend(t.count);
550: , p_init_msg_list VARCHAR2
551: , x_return_status out nocopy VARCHAR2
552: , x_msg_count out nocopy NUMBER
553: , x_msg_data out nocopy VARCHAR2
554: , p5_a0 JTF_NUMBER_TABLE
555: , p5_a1 JTF_NUMBER_TABLE
556: , p5_a2 JTF_VARCHAR2_TABLE_100
557: , p5_a3 JTF_VARCHAR2_TABLE_100
558: , p5_a4 JTF_NUMBER_TABLE
551: , x_return_status out nocopy VARCHAR2
552: , x_msg_count out nocopy NUMBER
553: , x_msg_data out nocopy VARCHAR2
554: , p5_a0 JTF_NUMBER_TABLE
555: , p5_a1 JTF_NUMBER_TABLE
556: , p5_a2 JTF_VARCHAR2_TABLE_100
557: , p5_a3 JTF_VARCHAR2_TABLE_100
558: , p5_a4 JTF_NUMBER_TABLE
559: , p5_a5 JTF_VARCHAR2_TABLE_300
554: , p5_a0 JTF_NUMBER_TABLE
555: , p5_a1 JTF_NUMBER_TABLE
556: , p5_a2 JTF_VARCHAR2_TABLE_100
557: , p5_a3 JTF_VARCHAR2_TABLE_100
558: , p5_a4 JTF_NUMBER_TABLE
559: , p5_a5 JTF_VARCHAR2_TABLE_300
560: , p5_a6 JTF_VARCHAR2_TABLE_2000
561: , p5_a7 JTF_NUMBER_TABLE
562: , p5_a8 JTF_NUMBER_TABLE
557: , p5_a3 JTF_VARCHAR2_TABLE_100
558: , p5_a4 JTF_NUMBER_TABLE
559: , p5_a5 JTF_VARCHAR2_TABLE_300
560: , p5_a6 JTF_VARCHAR2_TABLE_2000
561: , p5_a7 JTF_NUMBER_TABLE
562: , p5_a8 JTF_NUMBER_TABLE
563: , p5_a9 JTF_DATE_TABLE
564: , p5_a10 JTF_NUMBER_TABLE
565: , p5_a11 JTF_DATE_TABLE
558: , p5_a4 JTF_NUMBER_TABLE
559: , p5_a5 JTF_VARCHAR2_TABLE_300
560: , p5_a6 JTF_VARCHAR2_TABLE_2000
561: , p5_a7 JTF_NUMBER_TABLE
562: , p5_a8 JTF_NUMBER_TABLE
563: , p5_a9 JTF_DATE_TABLE
564: , p5_a10 JTF_NUMBER_TABLE
565: , p5_a11 JTF_DATE_TABLE
566: , p5_a12 JTF_NUMBER_TABLE
560: , p5_a6 JTF_VARCHAR2_TABLE_2000
561: , p5_a7 JTF_NUMBER_TABLE
562: , p5_a8 JTF_NUMBER_TABLE
563: , p5_a9 JTF_DATE_TABLE
564: , p5_a10 JTF_NUMBER_TABLE
565: , p5_a11 JTF_DATE_TABLE
566: , p5_a12 JTF_NUMBER_TABLE
567: , p5_a13 JTF_VARCHAR2_TABLE_100
568: , p5_a14 JTF_VARCHAR2_TABLE_100
562: , p5_a8 JTF_NUMBER_TABLE
563: , p5_a9 JTF_DATE_TABLE
564: , p5_a10 JTF_NUMBER_TABLE
565: , p5_a11 JTF_DATE_TABLE
566: , p5_a12 JTF_NUMBER_TABLE
567: , p5_a13 JTF_VARCHAR2_TABLE_100
568: , p5_a14 JTF_VARCHAR2_TABLE_100
569: , p5_a15 JTF_VARCHAR2_TABLE_100
570: , p5_a16 JTF_NUMBER_TABLE
566: , p5_a12 JTF_NUMBER_TABLE
567: , p5_a13 JTF_VARCHAR2_TABLE_100
568: , p5_a14 JTF_VARCHAR2_TABLE_100
569: , p5_a15 JTF_VARCHAR2_TABLE_100
570: , p5_a16 JTF_NUMBER_TABLE
571: , p5_a17 JTF_DATE_TABLE
572: , p6_a0 out nocopy JTF_NUMBER_TABLE
573: , p6_a1 out nocopy JTF_NUMBER_TABLE
574: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
568: , p5_a14 JTF_VARCHAR2_TABLE_100
569: , p5_a15 JTF_VARCHAR2_TABLE_100
570: , p5_a16 JTF_NUMBER_TABLE
571: , p5_a17 JTF_DATE_TABLE
572: , p6_a0 out nocopy JTF_NUMBER_TABLE
573: , p6_a1 out nocopy JTF_NUMBER_TABLE
574: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
575: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
576: , p6_a4 out nocopy JTF_NUMBER_TABLE
569: , p5_a15 JTF_VARCHAR2_TABLE_100
570: , p5_a16 JTF_NUMBER_TABLE
571: , p5_a17 JTF_DATE_TABLE
572: , p6_a0 out nocopy JTF_NUMBER_TABLE
573: , p6_a1 out nocopy JTF_NUMBER_TABLE
574: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
575: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
576: , p6_a4 out nocopy JTF_NUMBER_TABLE
577: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_300
572: , p6_a0 out nocopy JTF_NUMBER_TABLE
573: , p6_a1 out nocopy JTF_NUMBER_TABLE
574: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
575: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
576: , p6_a4 out nocopy JTF_NUMBER_TABLE
577: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_300
578: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
579: , p6_a7 out nocopy JTF_NUMBER_TABLE
580: , p6_a8 out nocopy JTF_NUMBER_TABLE
575: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
576: , p6_a4 out nocopy JTF_NUMBER_TABLE
577: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_300
578: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
579: , p6_a7 out nocopy JTF_NUMBER_TABLE
580: , p6_a8 out nocopy JTF_NUMBER_TABLE
581: , p6_a9 out nocopy JTF_DATE_TABLE
582: , p6_a10 out nocopy JTF_NUMBER_TABLE
583: , p6_a11 out nocopy JTF_DATE_TABLE
576: , p6_a4 out nocopy JTF_NUMBER_TABLE
577: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_300
578: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
579: , p6_a7 out nocopy JTF_NUMBER_TABLE
580: , p6_a8 out nocopy JTF_NUMBER_TABLE
581: , p6_a9 out nocopy JTF_DATE_TABLE
582: , p6_a10 out nocopy JTF_NUMBER_TABLE
583: , p6_a11 out nocopy JTF_DATE_TABLE
584: , p6_a12 out nocopy JTF_NUMBER_TABLE
578: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
579: , p6_a7 out nocopy JTF_NUMBER_TABLE
580: , p6_a8 out nocopy JTF_NUMBER_TABLE
581: , p6_a9 out nocopy JTF_DATE_TABLE
582: , p6_a10 out nocopy JTF_NUMBER_TABLE
583: , p6_a11 out nocopy JTF_DATE_TABLE
584: , p6_a12 out nocopy JTF_NUMBER_TABLE
585: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
586: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
580: , p6_a8 out nocopy JTF_NUMBER_TABLE
581: , p6_a9 out nocopy JTF_DATE_TABLE
582: , p6_a10 out nocopy JTF_NUMBER_TABLE
583: , p6_a11 out nocopy JTF_DATE_TABLE
584: , p6_a12 out nocopy JTF_NUMBER_TABLE
585: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
586: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
587: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
588: , p6_a16 out nocopy JTF_NUMBER_TABLE
584: , p6_a12 out nocopy JTF_NUMBER_TABLE
585: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
586: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
587: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
588: , p6_a16 out nocopy JTF_NUMBER_TABLE
589: , p6_a17 out nocopy JTF_DATE_TABLE
590: )
591:
592: as
734: , p_init_msg_list VARCHAR2
735: , x_return_status out nocopy VARCHAR2
736: , x_msg_count out nocopy NUMBER
737: , x_msg_data out nocopy VARCHAR2
738: , p5_a0 JTF_NUMBER_TABLE
739: , p5_a1 JTF_NUMBER_TABLE
740: , p5_a2 JTF_VARCHAR2_TABLE_100
741: , p5_a3 JTF_VARCHAR2_TABLE_100
742: , p5_a4 JTF_NUMBER_TABLE
735: , x_return_status out nocopy VARCHAR2
736: , x_msg_count out nocopy NUMBER
737: , x_msg_data out nocopy VARCHAR2
738: , p5_a0 JTF_NUMBER_TABLE
739: , p5_a1 JTF_NUMBER_TABLE
740: , p5_a2 JTF_VARCHAR2_TABLE_100
741: , p5_a3 JTF_VARCHAR2_TABLE_100
742: , p5_a4 JTF_NUMBER_TABLE
743: , p5_a5 JTF_VARCHAR2_TABLE_300
738: , p5_a0 JTF_NUMBER_TABLE
739: , p5_a1 JTF_NUMBER_TABLE
740: , p5_a2 JTF_VARCHAR2_TABLE_100
741: , p5_a3 JTF_VARCHAR2_TABLE_100
742: , p5_a4 JTF_NUMBER_TABLE
743: , p5_a5 JTF_VARCHAR2_TABLE_300
744: , p5_a6 JTF_VARCHAR2_TABLE_2000
745: , p5_a7 JTF_NUMBER_TABLE
746: , p5_a8 JTF_NUMBER_TABLE
741: , p5_a3 JTF_VARCHAR2_TABLE_100
742: , p5_a4 JTF_NUMBER_TABLE
743: , p5_a5 JTF_VARCHAR2_TABLE_300
744: , p5_a6 JTF_VARCHAR2_TABLE_2000
745: , p5_a7 JTF_NUMBER_TABLE
746: , p5_a8 JTF_NUMBER_TABLE
747: , p5_a9 JTF_DATE_TABLE
748: , p5_a10 JTF_NUMBER_TABLE
749: , p5_a11 JTF_DATE_TABLE
742: , p5_a4 JTF_NUMBER_TABLE
743: , p5_a5 JTF_VARCHAR2_TABLE_300
744: , p5_a6 JTF_VARCHAR2_TABLE_2000
745: , p5_a7 JTF_NUMBER_TABLE
746: , p5_a8 JTF_NUMBER_TABLE
747: , p5_a9 JTF_DATE_TABLE
748: , p5_a10 JTF_NUMBER_TABLE
749: , p5_a11 JTF_DATE_TABLE
750: , p5_a12 JTF_NUMBER_TABLE
744: , p5_a6 JTF_VARCHAR2_TABLE_2000
745: , p5_a7 JTF_NUMBER_TABLE
746: , p5_a8 JTF_NUMBER_TABLE
747: , p5_a9 JTF_DATE_TABLE
748: , p5_a10 JTF_NUMBER_TABLE
749: , p5_a11 JTF_DATE_TABLE
750: , p5_a12 JTF_NUMBER_TABLE
751: , p5_a13 JTF_VARCHAR2_TABLE_100
752: , p5_a14 JTF_VARCHAR2_TABLE_100
746: , p5_a8 JTF_NUMBER_TABLE
747: , p5_a9 JTF_DATE_TABLE
748: , p5_a10 JTF_NUMBER_TABLE
749: , p5_a11 JTF_DATE_TABLE
750: , p5_a12 JTF_NUMBER_TABLE
751: , p5_a13 JTF_VARCHAR2_TABLE_100
752: , p5_a14 JTF_VARCHAR2_TABLE_100
753: , p5_a15 JTF_VARCHAR2_TABLE_100
754: , p5_a16 JTF_NUMBER_TABLE
750: , p5_a12 JTF_NUMBER_TABLE
751: , p5_a13 JTF_VARCHAR2_TABLE_100
752: , p5_a14 JTF_VARCHAR2_TABLE_100
753: , p5_a15 JTF_VARCHAR2_TABLE_100
754: , p5_a16 JTF_NUMBER_TABLE
755: , p5_a17 JTF_DATE_TABLE
756: )
757:
758: as
917: , p_init_msg_list VARCHAR2
918: , x_return_status out nocopy VARCHAR2
919: , x_msg_count out nocopy NUMBER
920: , x_msg_data out nocopy VARCHAR2
921: , p5_a0 JTF_NUMBER_TABLE
922: , p5_a1 JTF_NUMBER_TABLE
923: , p5_a2 JTF_VARCHAR2_TABLE_100
924: , p5_a3 JTF_VARCHAR2_TABLE_100
925: , p5_a4 JTF_NUMBER_TABLE
918: , x_return_status out nocopy VARCHAR2
919: , x_msg_count out nocopy NUMBER
920: , x_msg_data out nocopy VARCHAR2
921: , p5_a0 JTF_NUMBER_TABLE
922: , p5_a1 JTF_NUMBER_TABLE
923: , p5_a2 JTF_VARCHAR2_TABLE_100
924: , p5_a3 JTF_VARCHAR2_TABLE_100
925: , p5_a4 JTF_NUMBER_TABLE
926: , p5_a5 JTF_VARCHAR2_TABLE_300
921: , p5_a0 JTF_NUMBER_TABLE
922: , p5_a1 JTF_NUMBER_TABLE
923: , p5_a2 JTF_VARCHAR2_TABLE_100
924: , p5_a3 JTF_VARCHAR2_TABLE_100
925: , p5_a4 JTF_NUMBER_TABLE
926: , p5_a5 JTF_VARCHAR2_TABLE_300
927: , p5_a6 JTF_VARCHAR2_TABLE_2000
928: , p5_a7 JTF_NUMBER_TABLE
929: , p5_a8 JTF_NUMBER_TABLE
924: , p5_a3 JTF_VARCHAR2_TABLE_100
925: , p5_a4 JTF_NUMBER_TABLE
926: , p5_a5 JTF_VARCHAR2_TABLE_300
927: , p5_a6 JTF_VARCHAR2_TABLE_2000
928: , p5_a7 JTF_NUMBER_TABLE
929: , p5_a8 JTF_NUMBER_TABLE
930: , p5_a9 JTF_DATE_TABLE
931: , p5_a10 JTF_NUMBER_TABLE
932: , p5_a11 JTF_DATE_TABLE
925: , p5_a4 JTF_NUMBER_TABLE
926: , p5_a5 JTF_VARCHAR2_TABLE_300
927: , p5_a6 JTF_VARCHAR2_TABLE_2000
928: , p5_a7 JTF_NUMBER_TABLE
929: , p5_a8 JTF_NUMBER_TABLE
930: , p5_a9 JTF_DATE_TABLE
931: , p5_a10 JTF_NUMBER_TABLE
932: , p5_a11 JTF_DATE_TABLE
933: , p5_a12 JTF_NUMBER_TABLE
927: , p5_a6 JTF_VARCHAR2_TABLE_2000
928: , p5_a7 JTF_NUMBER_TABLE
929: , p5_a8 JTF_NUMBER_TABLE
930: , p5_a9 JTF_DATE_TABLE
931: , p5_a10 JTF_NUMBER_TABLE
932: , p5_a11 JTF_DATE_TABLE
933: , p5_a12 JTF_NUMBER_TABLE
934: , p5_a13 JTF_VARCHAR2_TABLE_100
935: , p5_a14 JTF_VARCHAR2_TABLE_100
929: , p5_a8 JTF_NUMBER_TABLE
930: , p5_a9 JTF_DATE_TABLE
931: , p5_a10 JTF_NUMBER_TABLE
932: , p5_a11 JTF_DATE_TABLE
933: , p5_a12 JTF_NUMBER_TABLE
934: , p5_a13 JTF_VARCHAR2_TABLE_100
935: , p5_a14 JTF_VARCHAR2_TABLE_100
936: , p5_a15 JTF_VARCHAR2_TABLE_100
937: , p5_a16 JTF_NUMBER_TABLE
933: , p5_a12 JTF_NUMBER_TABLE
934: , p5_a13 JTF_VARCHAR2_TABLE_100
935: , p5_a14 JTF_VARCHAR2_TABLE_100
936: , p5_a15 JTF_VARCHAR2_TABLE_100
937: , p5_a16 JTF_NUMBER_TABLE
938: , p5_a17 JTF_DATE_TABLE
939: , p6_a0 out nocopy JTF_NUMBER_TABLE
940: , p6_a1 out nocopy JTF_NUMBER_TABLE
941: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
935: , p5_a14 JTF_VARCHAR2_TABLE_100
936: , p5_a15 JTF_VARCHAR2_TABLE_100
937: , p5_a16 JTF_NUMBER_TABLE
938: , p5_a17 JTF_DATE_TABLE
939: , p6_a0 out nocopy JTF_NUMBER_TABLE
940: , p6_a1 out nocopy JTF_NUMBER_TABLE
941: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
942: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
943: , p6_a4 out nocopy JTF_NUMBER_TABLE
936: , p5_a15 JTF_VARCHAR2_TABLE_100
937: , p5_a16 JTF_NUMBER_TABLE
938: , p5_a17 JTF_DATE_TABLE
939: , p6_a0 out nocopy JTF_NUMBER_TABLE
940: , p6_a1 out nocopy JTF_NUMBER_TABLE
941: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
942: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
943: , p6_a4 out nocopy JTF_NUMBER_TABLE
944: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_300
939: , p6_a0 out nocopy JTF_NUMBER_TABLE
940: , p6_a1 out nocopy JTF_NUMBER_TABLE
941: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
942: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
943: , p6_a4 out nocopy JTF_NUMBER_TABLE
944: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_300
945: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
946: , p6_a7 out nocopy JTF_NUMBER_TABLE
947: , p6_a8 out nocopy JTF_NUMBER_TABLE
942: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
943: , p6_a4 out nocopy JTF_NUMBER_TABLE
944: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_300
945: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
946: , p6_a7 out nocopy JTF_NUMBER_TABLE
947: , p6_a8 out nocopy JTF_NUMBER_TABLE
948: , p6_a9 out nocopy JTF_DATE_TABLE
949: , p6_a10 out nocopy JTF_NUMBER_TABLE
950: , p6_a11 out nocopy JTF_DATE_TABLE
943: , p6_a4 out nocopy JTF_NUMBER_TABLE
944: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_300
945: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
946: , p6_a7 out nocopy JTF_NUMBER_TABLE
947: , p6_a8 out nocopy JTF_NUMBER_TABLE
948: , p6_a9 out nocopy JTF_DATE_TABLE
949: , p6_a10 out nocopy JTF_NUMBER_TABLE
950: , p6_a11 out nocopy JTF_DATE_TABLE
951: , p6_a12 out nocopy JTF_NUMBER_TABLE
945: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
946: , p6_a7 out nocopy JTF_NUMBER_TABLE
947: , p6_a8 out nocopy JTF_NUMBER_TABLE
948: , p6_a9 out nocopy JTF_DATE_TABLE
949: , p6_a10 out nocopy JTF_NUMBER_TABLE
950: , p6_a11 out nocopy JTF_DATE_TABLE
951: , p6_a12 out nocopy JTF_NUMBER_TABLE
952: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
953: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
947: , p6_a8 out nocopy JTF_NUMBER_TABLE
948: , p6_a9 out nocopy JTF_DATE_TABLE
949: , p6_a10 out nocopy JTF_NUMBER_TABLE
950: , p6_a11 out nocopy JTF_DATE_TABLE
951: , p6_a12 out nocopy JTF_NUMBER_TABLE
952: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
953: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
954: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
955: , p6_a16 out nocopy JTF_NUMBER_TABLE
951: , p6_a12 out nocopy JTF_NUMBER_TABLE
952: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
953: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
954: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
955: , p6_a16 out nocopy JTF_NUMBER_TABLE
956: , p6_a17 out nocopy JTF_DATE_TABLE
957: )
958:
959: as
1101: , p_init_msg_list VARCHAR2
1102: , x_return_status out nocopy VARCHAR2
1103: , x_msg_count out nocopy NUMBER
1104: , x_msg_data out nocopy VARCHAR2
1105: , p5_a0 JTF_NUMBER_TABLE
1106: , p5_a1 JTF_NUMBER_TABLE
1107: , p5_a2 JTF_VARCHAR2_TABLE_100
1108: , p5_a3 JTF_VARCHAR2_TABLE_100
1109: , p5_a4 JTF_NUMBER_TABLE
1102: , x_return_status out nocopy VARCHAR2
1103: , x_msg_count out nocopy NUMBER
1104: , x_msg_data out nocopy VARCHAR2
1105: , p5_a0 JTF_NUMBER_TABLE
1106: , p5_a1 JTF_NUMBER_TABLE
1107: , p5_a2 JTF_VARCHAR2_TABLE_100
1108: , p5_a3 JTF_VARCHAR2_TABLE_100
1109: , p5_a4 JTF_NUMBER_TABLE
1110: , p5_a5 JTF_VARCHAR2_TABLE_300
1105: , p5_a0 JTF_NUMBER_TABLE
1106: , p5_a1 JTF_NUMBER_TABLE
1107: , p5_a2 JTF_VARCHAR2_TABLE_100
1108: , p5_a3 JTF_VARCHAR2_TABLE_100
1109: , p5_a4 JTF_NUMBER_TABLE
1110: , p5_a5 JTF_VARCHAR2_TABLE_300
1111: , p5_a6 JTF_VARCHAR2_TABLE_2000
1112: , p5_a7 JTF_NUMBER_TABLE
1113: , p5_a8 JTF_NUMBER_TABLE
1108: , p5_a3 JTF_VARCHAR2_TABLE_100
1109: , p5_a4 JTF_NUMBER_TABLE
1110: , p5_a5 JTF_VARCHAR2_TABLE_300
1111: , p5_a6 JTF_VARCHAR2_TABLE_2000
1112: , p5_a7 JTF_NUMBER_TABLE
1113: , p5_a8 JTF_NUMBER_TABLE
1114: , p5_a9 JTF_DATE_TABLE
1115: , p5_a10 JTF_NUMBER_TABLE
1116: , p5_a11 JTF_DATE_TABLE
1109: , p5_a4 JTF_NUMBER_TABLE
1110: , p5_a5 JTF_VARCHAR2_TABLE_300
1111: , p5_a6 JTF_VARCHAR2_TABLE_2000
1112: , p5_a7 JTF_NUMBER_TABLE
1113: , p5_a8 JTF_NUMBER_TABLE
1114: , p5_a9 JTF_DATE_TABLE
1115: , p5_a10 JTF_NUMBER_TABLE
1116: , p5_a11 JTF_DATE_TABLE
1117: , p5_a12 JTF_NUMBER_TABLE
1111: , p5_a6 JTF_VARCHAR2_TABLE_2000
1112: , p5_a7 JTF_NUMBER_TABLE
1113: , p5_a8 JTF_NUMBER_TABLE
1114: , p5_a9 JTF_DATE_TABLE
1115: , p5_a10 JTF_NUMBER_TABLE
1116: , p5_a11 JTF_DATE_TABLE
1117: , p5_a12 JTF_NUMBER_TABLE
1118: , p5_a13 JTF_VARCHAR2_TABLE_100
1119: , p5_a14 JTF_VARCHAR2_TABLE_100
1113: , p5_a8 JTF_NUMBER_TABLE
1114: , p5_a9 JTF_DATE_TABLE
1115: , p5_a10 JTF_NUMBER_TABLE
1116: , p5_a11 JTF_DATE_TABLE
1117: , p5_a12 JTF_NUMBER_TABLE
1118: , p5_a13 JTF_VARCHAR2_TABLE_100
1119: , p5_a14 JTF_VARCHAR2_TABLE_100
1120: , p5_a15 JTF_VARCHAR2_TABLE_100
1121: , p5_a16 JTF_NUMBER_TABLE
1117: , p5_a12 JTF_NUMBER_TABLE
1118: , p5_a13 JTF_VARCHAR2_TABLE_100
1119: , p5_a14 JTF_VARCHAR2_TABLE_100
1120: , p5_a15 JTF_VARCHAR2_TABLE_100
1121: , p5_a16 JTF_NUMBER_TABLE
1122: , p5_a17 JTF_DATE_TABLE
1123: )
1124:
1125: as
1244: , p_init_msg_list VARCHAR2
1245: , x_return_status out nocopy VARCHAR2
1246: , x_msg_count out nocopy NUMBER
1247: , x_msg_data out nocopy VARCHAR2
1248: , p5_a0 JTF_NUMBER_TABLE
1249: , p5_a1 JTF_NUMBER_TABLE
1250: , p5_a2 JTF_VARCHAR2_TABLE_100
1251: , p5_a3 JTF_VARCHAR2_TABLE_100
1252: , p5_a4 JTF_NUMBER_TABLE
1245: , x_return_status out nocopy VARCHAR2
1246: , x_msg_count out nocopy NUMBER
1247: , x_msg_data out nocopy VARCHAR2
1248: , p5_a0 JTF_NUMBER_TABLE
1249: , p5_a1 JTF_NUMBER_TABLE
1250: , p5_a2 JTF_VARCHAR2_TABLE_100
1251: , p5_a3 JTF_VARCHAR2_TABLE_100
1252: , p5_a4 JTF_NUMBER_TABLE
1253: , p5_a5 JTF_VARCHAR2_TABLE_300
1248: , p5_a0 JTF_NUMBER_TABLE
1249: , p5_a1 JTF_NUMBER_TABLE
1250: , p5_a2 JTF_VARCHAR2_TABLE_100
1251: , p5_a3 JTF_VARCHAR2_TABLE_100
1252: , p5_a4 JTF_NUMBER_TABLE
1253: , p5_a5 JTF_VARCHAR2_TABLE_300
1254: , p5_a6 JTF_VARCHAR2_TABLE_2000
1255: , p5_a7 JTF_NUMBER_TABLE
1256: , p5_a8 JTF_NUMBER_TABLE
1251: , p5_a3 JTF_VARCHAR2_TABLE_100
1252: , p5_a4 JTF_NUMBER_TABLE
1253: , p5_a5 JTF_VARCHAR2_TABLE_300
1254: , p5_a6 JTF_VARCHAR2_TABLE_2000
1255: , p5_a7 JTF_NUMBER_TABLE
1256: , p5_a8 JTF_NUMBER_TABLE
1257: , p5_a9 JTF_DATE_TABLE
1258: , p5_a10 JTF_NUMBER_TABLE
1259: , p5_a11 JTF_DATE_TABLE
1252: , p5_a4 JTF_NUMBER_TABLE
1253: , p5_a5 JTF_VARCHAR2_TABLE_300
1254: , p5_a6 JTF_VARCHAR2_TABLE_2000
1255: , p5_a7 JTF_NUMBER_TABLE
1256: , p5_a8 JTF_NUMBER_TABLE
1257: , p5_a9 JTF_DATE_TABLE
1258: , p5_a10 JTF_NUMBER_TABLE
1259: , p5_a11 JTF_DATE_TABLE
1260: , p5_a12 JTF_NUMBER_TABLE
1254: , p5_a6 JTF_VARCHAR2_TABLE_2000
1255: , p5_a7 JTF_NUMBER_TABLE
1256: , p5_a8 JTF_NUMBER_TABLE
1257: , p5_a9 JTF_DATE_TABLE
1258: , p5_a10 JTF_NUMBER_TABLE
1259: , p5_a11 JTF_DATE_TABLE
1260: , p5_a12 JTF_NUMBER_TABLE
1261: , p5_a13 JTF_VARCHAR2_TABLE_100
1262: , p5_a14 JTF_VARCHAR2_TABLE_100
1256: , p5_a8 JTF_NUMBER_TABLE
1257: , p5_a9 JTF_DATE_TABLE
1258: , p5_a10 JTF_NUMBER_TABLE
1259: , p5_a11 JTF_DATE_TABLE
1260: , p5_a12 JTF_NUMBER_TABLE
1261: , p5_a13 JTF_VARCHAR2_TABLE_100
1262: , p5_a14 JTF_VARCHAR2_TABLE_100
1263: , p5_a15 JTF_VARCHAR2_TABLE_100
1264: , p5_a16 JTF_NUMBER_TABLE
1260: , p5_a12 JTF_NUMBER_TABLE
1261: , p5_a13 JTF_VARCHAR2_TABLE_100
1262: , p5_a14 JTF_VARCHAR2_TABLE_100
1263: , p5_a15 JTF_VARCHAR2_TABLE_100
1264: , p5_a16 JTF_NUMBER_TABLE
1265: , p5_a17 JTF_DATE_TABLE
1266: )
1267:
1268: as