21: if n=b then return a; end if;
22: return n;
23: end;
24:
25: procedure rosetta_table_copy_in_p2(t out nocopy okl_tas_pvt.tas_tbl_type, a0 JTF_NUMBER_TABLE
26: , a1 JTF_NUMBER_TABLE
27: , a2 JTF_VARCHAR2_TABLE_100
28: , a3 JTF_NUMBER_TABLE
29: , a4 JTF_VARCHAR2_TABLE_100
22: return n;
23: end;
24:
25: procedure rosetta_table_copy_in_p2(t out nocopy okl_tas_pvt.tas_tbl_type, a0 JTF_NUMBER_TABLE
26: , a1 JTF_NUMBER_TABLE
27: , a2 JTF_VARCHAR2_TABLE_100
28: , a3 JTF_NUMBER_TABLE
29: , a4 JTF_VARCHAR2_TABLE_100
30: , a5 JTF_VARCHAR2_TABLE_500
24:
25: procedure rosetta_table_copy_in_p2(t out nocopy okl_tas_pvt.tas_tbl_type, a0 JTF_NUMBER_TABLE
26: , a1 JTF_NUMBER_TABLE
27: , a2 JTF_VARCHAR2_TABLE_100
28: , a3 JTF_NUMBER_TABLE
29: , a4 JTF_VARCHAR2_TABLE_100
30: , a5 JTF_VARCHAR2_TABLE_500
31: , a6 JTF_VARCHAR2_TABLE_500
32: , a7 JTF_VARCHAR2_TABLE_500
41: , a16 JTF_VARCHAR2_TABLE_500
42: , a17 JTF_VARCHAR2_TABLE_500
43: , a18 JTF_VARCHAR2_TABLE_500
44: , a19 JTF_VARCHAR2_TABLE_500
45: , a20 JTF_NUMBER_TABLE
46: , a21 JTF_DATE_TABLE
47: , a22 JTF_NUMBER_TABLE
48: , a23 JTF_DATE_TABLE
49: , a24 JTF_NUMBER_TABLE
43: , a18 JTF_VARCHAR2_TABLE_500
44: , a19 JTF_VARCHAR2_TABLE_500
45: , a20 JTF_NUMBER_TABLE
46: , a21 JTF_DATE_TABLE
47: , a22 JTF_NUMBER_TABLE
48: , a23 JTF_DATE_TABLE
49: , a24 JTF_NUMBER_TABLE
50: , a25 JTF_VARCHAR2_TABLE_100
51: , a26 JTF_NUMBER_TABLE
45: , a20 JTF_NUMBER_TABLE
46: , a21 JTF_DATE_TABLE
47: , a22 JTF_NUMBER_TABLE
48: , a23 JTF_DATE_TABLE
49: , a24 JTF_NUMBER_TABLE
50: , a25 JTF_VARCHAR2_TABLE_100
51: , a26 JTF_NUMBER_TABLE
52: , a27 JTF_DATE_TABLE
53: , a28 JTF_NUMBER_TABLE
47: , a22 JTF_NUMBER_TABLE
48: , a23 JTF_DATE_TABLE
49: , a24 JTF_NUMBER_TABLE
50: , a25 JTF_VARCHAR2_TABLE_100
51: , a26 JTF_NUMBER_TABLE
52: , a27 JTF_DATE_TABLE
53: , a28 JTF_NUMBER_TABLE
54: , a29 JTF_VARCHAR2_TABLE_4000
55: , a30 JTF_NUMBER_TABLE
49: , a24 JTF_NUMBER_TABLE
50: , a25 JTF_VARCHAR2_TABLE_100
51: , a26 JTF_NUMBER_TABLE
52: , a27 JTF_DATE_TABLE
53: , a28 JTF_NUMBER_TABLE
54: , a29 JTF_VARCHAR2_TABLE_4000
55: , a30 JTF_NUMBER_TABLE
56: , a31 JTF_NUMBER_TABLE
57: , a32 JTF_NUMBER_TABLE
51: , a26 JTF_NUMBER_TABLE
52: , a27 JTF_DATE_TABLE
53: , a28 JTF_NUMBER_TABLE
54: , a29 JTF_VARCHAR2_TABLE_4000
55: , a30 JTF_NUMBER_TABLE
56: , a31 JTF_NUMBER_TABLE
57: , a32 JTF_NUMBER_TABLE
58: , a33 JTF_NUMBER_TABLE
59: , a34 JTF_DATE_TABLE
52: , a27 JTF_DATE_TABLE
53: , a28 JTF_NUMBER_TABLE
54: , a29 JTF_VARCHAR2_TABLE_4000
55: , a30 JTF_NUMBER_TABLE
56: , a31 JTF_NUMBER_TABLE
57: , a32 JTF_NUMBER_TABLE
58: , a33 JTF_NUMBER_TABLE
59: , a34 JTF_DATE_TABLE
60: ) as
53: , a28 JTF_NUMBER_TABLE
54: , a29 JTF_VARCHAR2_TABLE_4000
55: , a30 JTF_NUMBER_TABLE
56: , a31 JTF_NUMBER_TABLE
57: , a32 JTF_NUMBER_TABLE
58: , a33 JTF_NUMBER_TABLE
59: , a34 JTF_DATE_TABLE
60: ) as
61: ddindx binary_integer; indx binary_integer;
54: , a29 JTF_VARCHAR2_TABLE_4000
55: , a30 JTF_NUMBER_TABLE
56: , a31 JTF_NUMBER_TABLE
57: , a32 JTF_NUMBER_TABLE
58: , a33 JTF_NUMBER_TABLE
59: , a34 JTF_DATE_TABLE
60: ) as
61: ddindx binary_integer; indx binary_integer;
62: begin
108: end loop;
109: end if;
110: end if;
111: end rosetta_table_copy_in_p2;
112: procedure rosetta_table_copy_out_p2(t okl_tas_pvt.tas_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
113: , a1 out nocopy JTF_NUMBER_TABLE
114: , a2 out nocopy JTF_VARCHAR2_TABLE_100
115: , a3 out nocopy JTF_NUMBER_TABLE
116: , a4 out nocopy JTF_VARCHAR2_TABLE_100
109: end if;
110: end if;
111: end rosetta_table_copy_in_p2;
112: procedure rosetta_table_copy_out_p2(t okl_tas_pvt.tas_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
113: , a1 out nocopy JTF_NUMBER_TABLE
114: , a2 out nocopy JTF_VARCHAR2_TABLE_100
115: , a3 out nocopy JTF_NUMBER_TABLE
116: , a4 out nocopy JTF_VARCHAR2_TABLE_100
117: , a5 out nocopy JTF_VARCHAR2_TABLE_500
111: end rosetta_table_copy_in_p2;
112: procedure rosetta_table_copy_out_p2(t okl_tas_pvt.tas_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
113: , a1 out nocopy JTF_NUMBER_TABLE
114: , a2 out nocopy JTF_VARCHAR2_TABLE_100
115: , a3 out nocopy JTF_NUMBER_TABLE
116: , a4 out nocopy JTF_VARCHAR2_TABLE_100
117: , a5 out nocopy JTF_VARCHAR2_TABLE_500
118: , a6 out nocopy JTF_VARCHAR2_TABLE_500
119: , a7 out nocopy JTF_VARCHAR2_TABLE_500
128: , a16 out nocopy JTF_VARCHAR2_TABLE_500
129: , a17 out nocopy JTF_VARCHAR2_TABLE_500
130: , a18 out nocopy JTF_VARCHAR2_TABLE_500
131: , a19 out nocopy JTF_VARCHAR2_TABLE_500
132: , a20 out nocopy JTF_NUMBER_TABLE
133: , a21 out nocopy JTF_DATE_TABLE
134: , a22 out nocopy JTF_NUMBER_TABLE
135: , a23 out nocopy JTF_DATE_TABLE
136: , a24 out nocopy JTF_NUMBER_TABLE
130: , a18 out nocopy JTF_VARCHAR2_TABLE_500
131: , a19 out nocopy JTF_VARCHAR2_TABLE_500
132: , a20 out nocopy JTF_NUMBER_TABLE
133: , a21 out nocopy JTF_DATE_TABLE
134: , a22 out nocopy JTF_NUMBER_TABLE
135: , a23 out nocopy JTF_DATE_TABLE
136: , a24 out nocopy JTF_NUMBER_TABLE
137: , a25 out nocopy JTF_VARCHAR2_TABLE_100
138: , a26 out nocopy JTF_NUMBER_TABLE
132: , a20 out nocopy JTF_NUMBER_TABLE
133: , a21 out nocopy JTF_DATE_TABLE
134: , a22 out nocopy JTF_NUMBER_TABLE
135: , a23 out nocopy JTF_DATE_TABLE
136: , a24 out nocopy JTF_NUMBER_TABLE
137: , a25 out nocopy JTF_VARCHAR2_TABLE_100
138: , a26 out nocopy JTF_NUMBER_TABLE
139: , a27 out nocopy JTF_DATE_TABLE
140: , a28 out nocopy JTF_NUMBER_TABLE
134: , a22 out nocopy JTF_NUMBER_TABLE
135: , a23 out nocopy JTF_DATE_TABLE
136: , a24 out nocopy JTF_NUMBER_TABLE
137: , a25 out nocopy JTF_VARCHAR2_TABLE_100
138: , a26 out nocopy JTF_NUMBER_TABLE
139: , a27 out nocopy JTF_DATE_TABLE
140: , a28 out nocopy JTF_NUMBER_TABLE
141: , a29 out nocopy JTF_VARCHAR2_TABLE_4000
142: , a30 out nocopy JTF_NUMBER_TABLE
136: , a24 out nocopy JTF_NUMBER_TABLE
137: , a25 out nocopy JTF_VARCHAR2_TABLE_100
138: , a26 out nocopy JTF_NUMBER_TABLE
139: , a27 out nocopy JTF_DATE_TABLE
140: , a28 out nocopy JTF_NUMBER_TABLE
141: , a29 out nocopy JTF_VARCHAR2_TABLE_4000
142: , a30 out nocopy JTF_NUMBER_TABLE
143: , a31 out nocopy JTF_NUMBER_TABLE
144: , a32 out nocopy JTF_NUMBER_TABLE
138: , a26 out nocopy JTF_NUMBER_TABLE
139: , a27 out nocopy JTF_DATE_TABLE
140: , a28 out nocopy JTF_NUMBER_TABLE
141: , a29 out nocopy JTF_VARCHAR2_TABLE_4000
142: , a30 out nocopy JTF_NUMBER_TABLE
143: , a31 out nocopy JTF_NUMBER_TABLE
144: , a32 out nocopy JTF_NUMBER_TABLE
145: , a33 out nocopy JTF_NUMBER_TABLE
146: , a34 out nocopy JTF_DATE_TABLE
139: , a27 out nocopy JTF_DATE_TABLE
140: , a28 out nocopy JTF_NUMBER_TABLE
141: , a29 out nocopy JTF_VARCHAR2_TABLE_4000
142: , a30 out nocopy JTF_NUMBER_TABLE
143: , a31 out nocopy JTF_NUMBER_TABLE
144: , a32 out nocopy JTF_NUMBER_TABLE
145: , a33 out nocopy JTF_NUMBER_TABLE
146: , a34 out nocopy JTF_DATE_TABLE
147: ) as
140: , a28 out nocopy JTF_NUMBER_TABLE
141: , a29 out nocopy JTF_VARCHAR2_TABLE_4000
142: , a30 out nocopy JTF_NUMBER_TABLE
143: , a31 out nocopy JTF_NUMBER_TABLE
144: , a32 out nocopy JTF_NUMBER_TABLE
145: , a33 out nocopy JTF_NUMBER_TABLE
146: , a34 out nocopy JTF_DATE_TABLE
147: ) as
148: ddindx binary_integer; indx binary_integer;
141: , a29 out nocopy JTF_VARCHAR2_TABLE_4000
142: , a30 out nocopy JTF_NUMBER_TABLE
143: , a31 out nocopy JTF_NUMBER_TABLE
144: , a32 out nocopy JTF_NUMBER_TABLE
145: , a33 out nocopy JTF_NUMBER_TABLE
146: , a34 out nocopy JTF_DATE_TABLE
147: ) as
148: ddindx binary_integer; indx binary_integer;
149: begin
147: ) as
148: ddindx binary_integer; indx binary_integer;
149: begin
150: if t is null or t.count = 0 then
151: a0 := JTF_NUMBER_TABLE();
152: a1 := JTF_NUMBER_TABLE();
153: a2 := JTF_VARCHAR2_TABLE_100();
154: a3 := JTF_NUMBER_TABLE();
155: a4 := JTF_VARCHAR2_TABLE_100();
148: ddindx binary_integer; indx binary_integer;
149: begin
150: if t is null or t.count = 0 then
151: a0 := JTF_NUMBER_TABLE();
152: a1 := JTF_NUMBER_TABLE();
153: a2 := JTF_VARCHAR2_TABLE_100();
154: a3 := JTF_NUMBER_TABLE();
155: a4 := JTF_VARCHAR2_TABLE_100();
156: a5 := JTF_VARCHAR2_TABLE_500();
150: if t is null or t.count = 0 then
151: a0 := JTF_NUMBER_TABLE();
152: a1 := JTF_NUMBER_TABLE();
153: a2 := JTF_VARCHAR2_TABLE_100();
154: a3 := JTF_NUMBER_TABLE();
155: a4 := JTF_VARCHAR2_TABLE_100();
156: a5 := JTF_VARCHAR2_TABLE_500();
157: a6 := JTF_VARCHAR2_TABLE_500();
158: a7 := JTF_VARCHAR2_TABLE_500();
167: a16 := JTF_VARCHAR2_TABLE_500();
168: a17 := JTF_VARCHAR2_TABLE_500();
169: a18 := JTF_VARCHAR2_TABLE_500();
170: a19 := JTF_VARCHAR2_TABLE_500();
171: a20 := JTF_NUMBER_TABLE();
172: a21 := JTF_DATE_TABLE();
173: a22 := JTF_NUMBER_TABLE();
174: a23 := JTF_DATE_TABLE();
175: a24 := JTF_NUMBER_TABLE();
169: a18 := JTF_VARCHAR2_TABLE_500();
170: a19 := JTF_VARCHAR2_TABLE_500();
171: a20 := JTF_NUMBER_TABLE();
172: a21 := JTF_DATE_TABLE();
173: a22 := JTF_NUMBER_TABLE();
174: a23 := JTF_DATE_TABLE();
175: a24 := JTF_NUMBER_TABLE();
176: a25 := JTF_VARCHAR2_TABLE_100();
177: a26 := JTF_NUMBER_TABLE();
171: a20 := JTF_NUMBER_TABLE();
172: a21 := JTF_DATE_TABLE();
173: a22 := JTF_NUMBER_TABLE();
174: a23 := JTF_DATE_TABLE();
175: a24 := JTF_NUMBER_TABLE();
176: a25 := JTF_VARCHAR2_TABLE_100();
177: a26 := JTF_NUMBER_TABLE();
178: a27 := JTF_DATE_TABLE();
179: a28 := JTF_NUMBER_TABLE();
173: a22 := JTF_NUMBER_TABLE();
174: a23 := JTF_DATE_TABLE();
175: a24 := JTF_NUMBER_TABLE();
176: a25 := JTF_VARCHAR2_TABLE_100();
177: a26 := JTF_NUMBER_TABLE();
178: a27 := JTF_DATE_TABLE();
179: a28 := JTF_NUMBER_TABLE();
180: a29 := JTF_VARCHAR2_TABLE_4000();
181: a30 := JTF_NUMBER_TABLE();
175: a24 := JTF_NUMBER_TABLE();
176: a25 := JTF_VARCHAR2_TABLE_100();
177: a26 := JTF_NUMBER_TABLE();
178: a27 := JTF_DATE_TABLE();
179: a28 := JTF_NUMBER_TABLE();
180: a29 := JTF_VARCHAR2_TABLE_4000();
181: a30 := JTF_NUMBER_TABLE();
182: a31 := JTF_NUMBER_TABLE();
183: a32 := JTF_NUMBER_TABLE();
177: a26 := JTF_NUMBER_TABLE();
178: a27 := JTF_DATE_TABLE();
179: a28 := JTF_NUMBER_TABLE();
180: a29 := JTF_VARCHAR2_TABLE_4000();
181: a30 := JTF_NUMBER_TABLE();
182: a31 := JTF_NUMBER_TABLE();
183: a32 := JTF_NUMBER_TABLE();
184: a33 := JTF_NUMBER_TABLE();
185: a34 := JTF_DATE_TABLE();
178: a27 := JTF_DATE_TABLE();
179: a28 := JTF_NUMBER_TABLE();
180: a29 := JTF_VARCHAR2_TABLE_4000();
181: a30 := JTF_NUMBER_TABLE();
182: a31 := JTF_NUMBER_TABLE();
183: a32 := JTF_NUMBER_TABLE();
184: a33 := JTF_NUMBER_TABLE();
185: a34 := JTF_DATE_TABLE();
186: else
179: a28 := JTF_NUMBER_TABLE();
180: a29 := JTF_VARCHAR2_TABLE_4000();
181: a30 := JTF_NUMBER_TABLE();
182: a31 := JTF_NUMBER_TABLE();
183: a32 := JTF_NUMBER_TABLE();
184: a33 := JTF_NUMBER_TABLE();
185: a34 := JTF_DATE_TABLE();
186: else
187: a0 := JTF_NUMBER_TABLE();
180: a29 := JTF_VARCHAR2_TABLE_4000();
181: a30 := JTF_NUMBER_TABLE();
182: a31 := JTF_NUMBER_TABLE();
183: a32 := JTF_NUMBER_TABLE();
184: a33 := JTF_NUMBER_TABLE();
185: a34 := JTF_DATE_TABLE();
186: else
187: a0 := JTF_NUMBER_TABLE();
188: a1 := JTF_NUMBER_TABLE();
183: a32 := JTF_NUMBER_TABLE();
184: a33 := JTF_NUMBER_TABLE();
185: a34 := JTF_DATE_TABLE();
186: else
187: a0 := JTF_NUMBER_TABLE();
188: a1 := JTF_NUMBER_TABLE();
189: a2 := JTF_VARCHAR2_TABLE_100();
190: a3 := JTF_NUMBER_TABLE();
191: a4 := JTF_VARCHAR2_TABLE_100();
184: a33 := JTF_NUMBER_TABLE();
185: a34 := JTF_DATE_TABLE();
186: else
187: a0 := JTF_NUMBER_TABLE();
188: a1 := JTF_NUMBER_TABLE();
189: a2 := JTF_VARCHAR2_TABLE_100();
190: a3 := JTF_NUMBER_TABLE();
191: a4 := JTF_VARCHAR2_TABLE_100();
192: a5 := JTF_VARCHAR2_TABLE_500();
186: else
187: a0 := JTF_NUMBER_TABLE();
188: a1 := JTF_NUMBER_TABLE();
189: a2 := JTF_VARCHAR2_TABLE_100();
190: a3 := JTF_NUMBER_TABLE();
191: a4 := JTF_VARCHAR2_TABLE_100();
192: a5 := JTF_VARCHAR2_TABLE_500();
193: a6 := JTF_VARCHAR2_TABLE_500();
194: a7 := JTF_VARCHAR2_TABLE_500();
203: a16 := JTF_VARCHAR2_TABLE_500();
204: a17 := JTF_VARCHAR2_TABLE_500();
205: a18 := JTF_VARCHAR2_TABLE_500();
206: a19 := JTF_VARCHAR2_TABLE_500();
207: a20 := JTF_NUMBER_TABLE();
208: a21 := JTF_DATE_TABLE();
209: a22 := JTF_NUMBER_TABLE();
210: a23 := JTF_DATE_TABLE();
211: a24 := JTF_NUMBER_TABLE();
205: a18 := JTF_VARCHAR2_TABLE_500();
206: a19 := JTF_VARCHAR2_TABLE_500();
207: a20 := JTF_NUMBER_TABLE();
208: a21 := JTF_DATE_TABLE();
209: a22 := JTF_NUMBER_TABLE();
210: a23 := JTF_DATE_TABLE();
211: a24 := JTF_NUMBER_TABLE();
212: a25 := JTF_VARCHAR2_TABLE_100();
213: a26 := JTF_NUMBER_TABLE();
207: a20 := JTF_NUMBER_TABLE();
208: a21 := JTF_DATE_TABLE();
209: a22 := JTF_NUMBER_TABLE();
210: a23 := JTF_DATE_TABLE();
211: a24 := JTF_NUMBER_TABLE();
212: a25 := JTF_VARCHAR2_TABLE_100();
213: a26 := JTF_NUMBER_TABLE();
214: a27 := JTF_DATE_TABLE();
215: a28 := JTF_NUMBER_TABLE();
209: a22 := JTF_NUMBER_TABLE();
210: a23 := JTF_DATE_TABLE();
211: a24 := JTF_NUMBER_TABLE();
212: a25 := JTF_VARCHAR2_TABLE_100();
213: a26 := JTF_NUMBER_TABLE();
214: a27 := JTF_DATE_TABLE();
215: a28 := JTF_NUMBER_TABLE();
216: a29 := JTF_VARCHAR2_TABLE_4000();
217: a30 := JTF_NUMBER_TABLE();
211: a24 := JTF_NUMBER_TABLE();
212: a25 := JTF_VARCHAR2_TABLE_100();
213: a26 := JTF_NUMBER_TABLE();
214: a27 := JTF_DATE_TABLE();
215: a28 := JTF_NUMBER_TABLE();
216: a29 := JTF_VARCHAR2_TABLE_4000();
217: a30 := JTF_NUMBER_TABLE();
218: a31 := JTF_NUMBER_TABLE();
219: a32 := JTF_NUMBER_TABLE();
213: a26 := JTF_NUMBER_TABLE();
214: a27 := JTF_DATE_TABLE();
215: a28 := JTF_NUMBER_TABLE();
216: a29 := JTF_VARCHAR2_TABLE_4000();
217: a30 := JTF_NUMBER_TABLE();
218: a31 := JTF_NUMBER_TABLE();
219: a32 := JTF_NUMBER_TABLE();
220: a33 := JTF_NUMBER_TABLE();
221: a34 := JTF_DATE_TABLE();
214: a27 := JTF_DATE_TABLE();
215: a28 := JTF_NUMBER_TABLE();
216: a29 := JTF_VARCHAR2_TABLE_4000();
217: a30 := JTF_NUMBER_TABLE();
218: a31 := JTF_NUMBER_TABLE();
219: a32 := JTF_NUMBER_TABLE();
220: a33 := JTF_NUMBER_TABLE();
221: a34 := JTF_DATE_TABLE();
222: if t.count > 0 then
215: a28 := JTF_NUMBER_TABLE();
216: a29 := JTF_VARCHAR2_TABLE_4000();
217: a30 := JTF_NUMBER_TABLE();
218: a31 := JTF_NUMBER_TABLE();
219: a32 := JTF_NUMBER_TABLE();
220: a33 := JTF_NUMBER_TABLE();
221: a34 := JTF_DATE_TABLE();
222: if t.count > 0 then
223: a0.extend(t.count);
216: a29 := JTF_VARCHAR2_TABLE_4000();
217: a30 := JTF_NUMBER_TABLE();
218: a31 := JTF_NUMBER_TABLE();
219: a32 := JTF_NUMBER_TABLE();
220: a33 := JTF_NUMBER_TABLE();
221: a34 := JTF_DATE_TABLE();
222: if t.count > 0 then
223: a0.extend(t.count);
224: a1.extend(t.count);
302: end if;
303: end if;
304: end rosetta_table_copy_out_p2;
305:
306: procedure rosetta_table_copy_in_p5(t out nocopy okl_tas_pvt.tasv_tbl_type, a0 JTF_NUMBER_TABLE
307: , a1 JTF_NUMBER_TABLE
308: , a2 JTF_NUMBER_TABLE
309: , a3 JTF_VARCHAR2_TABLE_100
310: , a4 JTF_VARCHAR2_TABLE_500
303: end if;
304: end rosetta_table_copy_out_p2;
305:
306: procedure rosetta_table_copy_in_p5(t out nocopy okl_tas_pvt.tasv_tbl_type, a0 JTF_NUMBER_TABLE
307: , a1 JTF_NUMBER_TABLE
308: , a2 JTF_NUMBER_TABLE
309: , a3 JTF_VARCHAR2_TABLE_100
310: , a4 JTF_VARCHAR2_TABLE_500
311: , a5 JTF_VARCHAR2_TABLE_500
304: end rosetta_table_copy_out_p2;
305:
306: procedure rosetta_table_copy_in_p5(t out nocopy okl_tas_pvt.tasv_tbl_type, a0 JTF_NUMBER_TABLE
307: , a1 JTF_NUMBER_TABLE
308: , a2 JTF_NUMBER_TABLE
309: , a3 JTF_VARCHAR2_TABLE_100
310: , a4 JTF_VARCHAR2_TABLE_500
311: , a5 JTF_VARCHAR2_TABLE_500
312: , a6 JTF_VARCHAR2_TABLE_500
322: , a16 JTF_VARCHAR2_TABLE_500
323: , a17 JTF_VARCHAR2_TABLE_500
324: , a18 JTF_VARCHAR2_TABLE_500
325: , a19 JTF_VARCHAR2_TABLE_100
326: , a20 JTF_NUMBER_TABLE
327: , a21 JTF_DATE_TABLE
328: , a22 JTF_NUMBER_TABLE
329: , a23 JTF_DATE_TABLE
330: , a24 JTF_NUMBER_TABLE
324: , a18 JTF_VARCHAR2_TABLE_500
325: , a19 JTF_VARCHAR2_TABLE_100
326: , a20 JTF_NUMBER_TABLE
327: , a21 JTF_DATE_TABLE
328: , a22 JTF_NUMBER_TABLE
329: , a23 JTF_DATE_TABLE
330: , a24 JTF_NUMBER_TABLE
331: , a25 JTF_VARCHAR2_TABLE_100
332: , a26 JTF_NUMBER_TABLE
326: , a20 JTF_NUMBER_TABLE
327: , a21 JTF_DATE_TABLE
328: , a22 JTF_NUMBER_TABLE
329: , a23 JTF_DATE_TABLE
330: , a24 JTF_NUMBER_TABLE
331: , a25 JTF_VARCHAR2_TABLE_100
332: , a26 JTF_NUMBER_TABLE
333: , a27 JTF_DATE_TABLE
334: , a28 JTF_NUMBER_TABLE
328: , a22 JTF_NUMBER_TABLE
329: , a23 JTF_DATE_TABLE
330: , a24 JTF_NUMBER_TABLE
331: , a25 JTF_VARCHAR2_TABLE_100
332: , a26 JTF_NUMBER_TABLE
333: , a27 JTF_DATE_TABLE
334: , a28 JTF_NUMBER_TABLE
335: , a29 JTF_VARCHAR2_TABLE_4000
336: , a30 JTF_NUMBER_TABLE
330: , a24 JTF_NUMBER_TABLE
331: , a25 JTF_VARCHAR2_TABLE_100
332: , a26 JTF_NUMBER_TABLE
333: , a27 JTF_DATE_TABLE
334: , a28 JTF_NUMBER_TABLE
335: , a29 JTF_VARCHAR2_TABLE_4000
336: , a30 JTF_NUMBER_TABLE
337: , a31 JTF_NUMBER_TABLE
338: , a32 JTF_NUMBER_TABLE
332: , a26 JTF_NUMBER_TABLE
333: , a27 JTF_DATE_TABLE
334: , a28 JTF_NUMBER_TABLE
335: , a29 JTF_VARCHAR2_TABLE_4000
336: , a30 JTF_NUMBER_TABLE
337: , a31 JTF_NUMBER_TABLE
338: , a32 JTF_NUMBER_TABLE
339: , a33 JTF_NUMBER_TABLE
340: , a34 JTF_DATE_TABLE
333: , a27 JTF_DATE_TABLE
334: , a28 JTF_NUMBER_TABLE
335: , a29 JTF_VARCHAR2_TABLE_4000
336: , a30 JTF_NUMBER_TABLE
337: , a31 JTF_NUMBER_TABLE
338: , a32 JTF_NUMBER_TABLE
339: , a33 JTF_NUMBER_TABLE
340: , a34 JTF_DATE_TABLE
341: ) as
334: , a28 JTF_NUMBER_TABLE
335: , a29 JTF_VARCHAR2_TABLE_4000
336: , a30 JTF_NUMBER_TABLE
337: , a31 JTF_NUMBER_TABLE
338: , a32 JTF_NUMBER_TABLE
339: , a33 JTF_NUMBER_TABLE
340: , a34 JTF_DATE_TABLE
341: ) as
342: ddindx binary_integer; indx binary_integer;
335: , a29 JTF_VARCHAR2_TABLE_4000
336: , a30 JTF_NUMBER_TABLE
337: , a31 JTF_NUMBER_TABLE
338: , a32 JTF_NUMBER_TABLE
339: , a33 JTF_NUMBER_TABLE
340: , a34 JTF_DATE_TABLE
341: ) as
342: ddindx binary_integer; indx binary_integer;
343: begin
389: end loop;
390: end if;
391: end if;
392: end rosetta_table_copy_in_p5;
393: procedure rosetta_table_copy_out_p5(t okl_tas_pvt.tasv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
394: , a1 out nocopy JTF_NUMBER_TABLE
395: , a2 out nocopy JTF_NUMBER_TABLE
396: , a3 out nocopy JTF_VARCHAR2_TABLE_100
397: , a4 out nocopy JTF_VARCHAR2_TABLE_500
390: end if;
391: end if;
392: end rosetta_table_copy_in_p5;
393: procedure rosetta_table_copy_out_p5(t okl_tas_pvt.tasv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
394: , a1 out nocopy JTF_NUMBER_TABLE
395: , a2 out nocopy JTF_NUMBER_TABLE
396: , a3 out nocopy JTF_VARCHAR2_TABLE_100
397: , a4 out nocopy JTF_VARCHAR2_TABLE_500
398: , a5 out nocopy JTF_VARCHAR2_TABLE_500
391: end if;
392: end rosetta_table_copy_in_p5;
393: procedure rosetta_table_copy_out_p5(t okl_tas_pvt.tasv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
394: , a1 out nocopy JTF_NUMBER_TABLE
395: , a2 out nocopy JTF_NUMBER_TABLE
396: , a3 out nocopy JTF_VARCHAR2_TABLE_100
397: , a4 out nocopy JTF_VARCHAR2_TABLE_500
398: , a5 out nocopy JTF_VARCHAR2_TABLE_500
399: , a6 out nocopy JTF_VARCHAR2_TABLE_500
409: , a16 out nocopy JTF_VARCHAR2_TABLE_500
410: , a17 out nocopy JTF_VARCHAR2_TABLE_500
411: , a18 out nocopy JTF_VARCHAR2_TABLE_500
412: , a19 out nocopy JTF_VARCHAR2_TABLE_100
413: , a20 out nocopy JTF_NUMBER_TABLE
414: , a21 out nocopy JTF_DATE_TABLE
415: , a22 out nocopy JTF_NUMBER_TABLE
416: , a23 out nocopy JTF_DATE_TABLE
417: , a24 out nocopy JTF_NUMBER_TABLE
411: , a18 out nocopy JTF_VARCHAR2_TABLE_500
412: , a19 out nocopy JTF_VARCHAR2_TABLE_100
413: , a20 out nocopy JTF_NUMBER_TABLE
414: , a21 out nocopy JTF_DATE_TABLE
415: , a22 out nocopy JTF_NUMBER_TABLE
416: , a23 out nocopy JTF_DATE_TABLE
417: , a24 out nocopy JTF_NUMBER_TABLE
418: , a25 out nocopy JTF_VARCHAR2_TABLE_100
419: , a26 out nocopy JTF_NUMBER_TABLE
413: , a20 out nocopy JTF_NUMBER_TABLE
414: , a21 out nocopy JTF_DATE_TABLE
415: , a22 out nocopy JTF_NUMBER_TABLE
416: , a23 out nocopy JTF_DATE_TABLE
417: , a24 out nocopy JTF_NUMBER_TABLE
418: , a25 out nocopy JTF_VARCHAR2_TABLE_100
419: , a26 out nocopy JTF_NUMBER_TABLE
420: , a27 out nocopy JTF_DATE_TABLE
421: , a28 out nocopy JTF_NUMBER_TABLE
415: , a22 out nocopy JTF_NUMBER_TABLE
416: , a23 out nocopy JTF_DATE_TABLE
417: , a24 out nocopy JTF_NUMBER_TABLE
418: , a25 out nocopy JTF_VARCHAR2_TABLE_100
419: , a26 out nocopy JTF_NUMBER_TABLE
420: , a27 out nocopy JTF_DATE_TABLE
421: , a28 out nocopy JTF_NUMBER_TABLE
422: , a29 out nocopy JTF_VARCHAR2_TABLE_4000
423: , a30 out nocopy JTF_NUMBER_TABLE
417: , a24 out nocopy JTF_NUMBER_TABLE
418: , a25 out nocopy JTF_VARCHAR2_TABLE_100
419: , a26 out nocopy JTF_NUMBER_TABLE
420: , a27 out nocopy JTF_DATE_TABLE
421: , a28 out nocopy JTF_NUMBER_TABLE
422: , a29 out nocopy JTF_VARCHAR2_TABLE_4000
423: , a30 out nocopy JTF_NUMBER_TABLE
424: , a31 out nocopy JTF_NUMBER_TABLE
425: , a32 out nocopy JTF_NUMBER_TABLE
419: , a26 out nocopy JTF_NUMBER_TABLE
420: , a27 out nocopy JTF_DATE_TABLE
421: , a28 out nocopy JTF_NUMBER_TABLE
422: , a29 out nocopy JTF_VARCHAR2_TABLE_4000
423: , a30 out nocopy JTF_NUMBER_TABLE
424: , a31 out nocopy JTF_NUMBER_TABLE
425: , a32 out nocopy JTF_NUMBER_TABLE
426: , a33 out nocopy JTF_NUMBER_TABLE
427: , a34 out nocopy JTF_DATE_TABLE
420: , a27 out nocopy JTF_DATE_TABLE
421: , a28 out nocopy JTF_NUMBER_TABLE
422: , a29 out nocopy JTF_VARCHAR2_TABLE_4000
423: , a30 out nocopy JTF_NUMBER_TABLE
424: , a31 out nocopy JTF_NUMBER_TABLE
425: , a32 out nocopy JTF_NUMBER_TABLE
426: , a33 out nocopy JTF_NUMBER_TABLE
427: , a34 out nocopy JTF_DATE_TABLE
428: ) as
421: , a28 out nocopy JTF_NUMBER_TABLE
422: , a29 out nocopy JTF_VARCHAR2_TABLE_4000
423: , a30 out nocopy JTF_NUMBER_TABLE
424: , a31 out nocopy JTF_NUMBER_TABLE
425: , a32 out nocopy JTF_NUMBER_TABLE
426: , a33 out nocopy JTF_NUMBER_TABLE
427: , a34 out nocopy JTF_DATE_TABLE
428: ) as
429: ddindx binary_integer; indx binary_integer;
422: , a29 out nocopy JTF_VARCHAR2_TABLE_4000
423: , a30 out nocopy JTF_NUMBER_TABLE
424: , a31 out nocopy JTF_NUMBER_TABLE
425: , a32 out nocopy JTF_NUMBER_TABLE
426: , a33 out nocopy JTF_NUMBER_TABLE
427: , a34 out nocopy JTF_DATE_TABLE
428: ) as
429: ddindx binary_integer; indx binary_integer;
430: begin
428: ) as
429: ddindx binary_integer; indx binary_integer;
430: begin
431: if t is null or t.count = 0 then
432: a0 := JTF_NUMBER_TABLE();
433: a1 := JTF_NUMBER_TABLE();
434: a2 := JTF_NUMBER_TABLE();
435: a3 := JTF_VARCHAR2_TABLE_100();
436: a4 := JTF_VARCHAR2_TABLE_500();
429: ddindx binary_integer; indx binary_integer;
430: begin
431: if t is null or t.count = 0 then
432: a0 := JTF_NUMBER_TABLE();
433: a1 := JTF_NUMBER_TABLE();
434: a2 := JTF_NUMBER_TABLE();
435: a3 := JTF_VARCHAR2_TABLE_100();
436: a4 := JTF_VARCHAR2_TABLE_500();
437: a5 := JTF_VARCHAR2_TABLE_500();
430: begin
431: if t is null or t.count = 0 then
432: a0 := JTF_NUMBER_TABLE();
433: a1 := JTF_NUMBER_TABLE();
434: a2 := JTF_NUMBER_TABLE();
435: a3 := JTF_VARCHAR2_TABLE_100();
436: a4 := JTF_VARCHAR2_TABLE_500();
437: a5 := JTF_VARCHAR2_TABLE_500();
438: a6 := JTF_VARCHAR2_TABLE_500();
448: a16 := JTF_VARCHAR2_TABLE_500();
449: a17 := JTF_VARCHAR2_TABLE_500();
450: a18 := JTF_VARCHAR2_TABLE_500();
451: a19 := JTF_VARCHAR2_TABLE_100();
452: a20 := JTF_NUMBER_TABLE();
453: a21 := JTF_DATE_TABLE();
454: a22 := JTF_NUMBER_TABLE();
455: a23 := JTF_DATE_TABLE();
456: a24 := JTF_NUMBER_TABLE();
450: a18 := JTF_VARCHAR2_TABLE_500();
451: a19 := JTF_VARCHAR2_TABLE_100();
452: a20 := JTF_NUMBER_TABLE();
453: a21 := JTF_DATE_TABLE();
454: a22 := JTF_NUMBER_TABLE();
455: a23 := JTF_DATE_TABLE();
456: a24 := JTF_NUMBER_TABLE();
457: a25 := JTF_VARCHAR2_TABLE_100();
458: a26 := JTF_NUMBER_TABLE();
452: a20 := JTF_NUMBER_TABLE();
453: a21 := JTF_DATE_TABLE();
454: a22 := JTF_NUMBER_TABLE();
455: a23 := JTF_DATE_TABLE();
456: a24 := JTF_NUMBER_TABLE();
457: a25 := JTF_VARCHAR2_TABLE_100();
458: a26 := JTF_NUMBER_TABLE();
459: a27 := JTF_DATE_TABLE();
460: a28 := JTF_NUMBER_TABLE();
454: a22 := JTF_NUMBER_TABLE();
455: a23 := JTF_DATE_TABLE();
456: a24 := JTF_NUMBER_TABLE();
457: a25 := JTF_VARCHAR2_TABLE_100();
458: a26 := JTF_NUMBER_TABLE();
459: a27 := JTF_DATE_TABLE();
460: a28 := JTF_NUMBER_TABLE();
461: a29 := JTF_VARCHAR2_TABLE_4000();
462: a30 := JTF_NUMBER_TABLE();
456: a24 := JTF_NUMBER_TABLE();
457: a25 := JTF_VARCHAR2_TABLE_100();
458: a26 := JTF_NUMBER_TABLE();
459: a27 := JTF_DATE_TABLE();
460: a28 := JTF_NUMBER_TABLE();
461: a29 := JTF_VARCHAR2_TABLE_4000();
462: a30 := JTF_NUMBER_TABLE();
463: a31 := JTF_NUMBER_TABLE();
464: a32 := JTF_NUMBER_TABLE();
458: a26 := JTF_NUMBER_TABLE();
459: a27 := JTF_DATE_TABLE();
460: a28 := JTF_NUMBER_TABLE();
461: a29 := JTF_VARCHAR2_TABLE_4000();
462: a30 := JTF_NUMBER_TABLE();
463: a31 := JTF_NUMBER_TABLE();
464: a32 := JTF_NUMBER_TABLE();
465: a33 := JTF_NUMBER_TABLE();
466: a34 := JTF_DATE_TABLE();
459: a27 := JTF_DATE_TABLE();
460: a28 := JTF_NUMBER_TABLE();
461: a29 := JTF_VARCHAR2_TABLE_4000();
462: a30 := JTF_NUMBER_TABLE();
463: a31 := JTF_NUMBER_TABLE();
464: a32 := JTF_NUMBER_TABLE();
465: a33 := JTF_NUMBER_TABLE();
466: a34 := JTF_DATE_TABLE();
467: else
460: a28 := JTF_NUMBER_TABLE();
461: a29 := JTF_VARCHAR2_TABLE_4000();
462: a30 := JTF_NUMBER_TABLE();
463: a31 := JTF_NUMBER_TABLE();
464: a32 := JTF_NUMBER_TABLE();
465: a33 := JTF_NUMBER_TABLE();
466: a34 := JTF_DATE_TABLE();
467: else
468: a0 := JTF_NUMBER_TABLE();
461: a29 := JTF_VARCHAR2_TABLE_4000();
462: a30 := JTF_NUMBER_TABLE();
463: a31 := JTF_NUMBER_TABLE();
464: a32 := JTF_NUMBER_TABLE();
465: a33 := JTF_NUMBER_TABLE();
466: a34 := JTF_DATE_TABLE();
467: else
468: a0 := JTF_NUMBER_TABLE();
469: a1 := JTF_NUMBER_TABLE();
464: a32 := JTF_NUMBER_TABLE();
465: a33 := JTF_NUMBER_TABLE();
466: a34 := JTF_DATE_TABLE();
467: else
468: a0 := JTF_NUMBER_TABLE();
469: a1 := JTF_NUMBER_TABLE();
470: a2 := JTF_NUMBER_TABLE();
471: a3 := JTF_VARCHAR2_TABLE_100();
472: a4 := JTF_VARCHAR2_TABLE_500();
465: a33 := JTF_NUMBER_TABLE();
466: a34 := JTF_DATE_TABLE();
467: else
468: a0 := JTF_NUMBER_TABLE();
469: a1 := JTF_NUMBER_TABLE();
470: a2 := JTF_NUMBER_TABLE();
471: a3 := JTF_VARCHAR2_TABLE_100();
472: a4 := JTF_VARCHAR2_TABLE_500();
473: a5 := JTF_VARCHAR2_TABLE_500();
466: a34 := JTF_DATE_TABLE();
467: else
468: a0 := JTF_NUMBER_TABLE();
469: a1 := JTF_NUMBER_TABLE();
470: a2 := JTF_NUMBER_TABLE();
471: a3 := JTF_VARCHAR2_TABLE_100();
472: a4 := JTF_VARCHAR2_TABLE_500();
473: a5 := JTF_VARCHAR2_TABLE_500();
474: a6 := JTF_VARCHAR2_TABLE_500();
484: a16 := JTF_VARCHAR2_TABLE_500();
485: a17 := JTF_VARCHAR2_TABLE_500();
486: a18 := JTF_VARCHAR2_TABLE_500();
487: a19 := JTF_VARCHAR2_TABLE_100();
488: a20 := JTF_NUMBER_TABLE();
489: a21 := JTF_DATE_TABLE();
490: a22 := JTF_NUMBER_TABLE();
491: a23 := JTF_DATE_TABLE();
492: a24 := JTF_NUMBER_TABLE();
486: a18 := JTF_VARCHAR2_TABLE_500();
487: a19 := JTF_VARCHAR2_TABLE_100();
488: a20 := JTF_NUMBER_TABLE();
489: a21 := JTF_DATE_TABLE();
490: a22 := JTF_NUMBER_TABLE();
491: a23 := JTF_DATE_TABLE();
492: a24 := JTF_NUMBER_TABLE();
493: a25 := JTF_VARCHAR2_TABLE_100();
494: a26 := JTF_NUMBER_TABLE();
488: a20 := JTF_NUMBER_TABLE();
489: a21 := JTF_DATE_TABLE();
490: a22 := JTF_NUMBER_TABLE();
491: a23 := JTF_DATE_TABLE();
492: a24 := JTF_NUMBER_TABLE();
493: a25 := JTF_VARCHAR2_TABLE_100();
494: a26 := JTF_NUMBER_TABLE();
495: a27 := JTF_DATE_TABLE();
496: a28 := JTF_NUMBER_TABLE();
490: a22 := JTF_NUMBER_TABLE();
491: a23 := JTF_DATE_TABLE();
492: a24 := JTF_NUMBER_TABLE();
493: a25 := JTF_VARCHAR2_TABLE_100();
494: a26 := JTF_NUMBER_TABLE();
495: a27 := JTF_DATE_TABLE();
496: a28 := JTF_NUMBER_TABLE();
497: a29 := JTF_VARCHAR2_TABLE_4000();
498: a30 := JTF_NUMBER_TABLE();
492: a24 := JTF_NUMBER_TABLE();
493: a25 := JTF_VARCHAR2_TABLE_100();
494: a26 := JTF_NUMBER_TABLE();
495: a27 := JTF_DATE_TABLE();
496: a28 := JTF_NUMBER_TABLE();
497: a29 := JTF_VARCHAR2_TABLE_4000();
498: a30 := JTF_NUMBER_TABLE();
499: a31 := JTF_NUMBER_TABLE();
500: a32 := JTF_NUMBER_TABLE();
494: a26 := JTF_NUMBER_TABLE();
495: a27 := JTF_DATE_TABLE();
496: a28 := JTF_NUMBER_TABLE();
497: a29 := JTF_VARCHAR2_TABLE_4000();
498: a30 := JTF_NUMBER_TABLE();
499: a31 := JTF_NUMBER_TABLE();
500: a32 := JTF_NUMBER_TABLE();
501: a33 := JTF_NUMBER_TABLE();
502: a34 := JTF_DATE_TABLE();
495: a27 := JTF_DATE_TABLE();
496: a28 := JTF_NUMBER_TABLE();
497: a29 := JTF_VARCHAR2_TABLE_4000();
498: a30 := JTF_NUMBER_TABLE();
499: a31 := JTF_NUMBER_TABLE();
500: a32 := JTF_NUMBER_TABLE();
501: a33 := JTF_NUMBER_TABLE();
502: a34 := JTF_DATE_TABLE();
503: if t.count > 0 then
496: a28 := JTF_NUMBER_TABLE();
497: a29 := JTF_VARCHAR2_TABLE_4000();
498: a30 := JTF_NUMBER_TABLE();
499: a31 := JTF_NUMBER_TABLE();
500: a32 := JTF_NUMBER_TABLE();
501: a33 := JTF_NUMBER_TABLE();
502: a34 := JTF_DATE_TABLE();
503: if t.count > 0 then
504: a0.extend(t.count);
497: a29 := JTF_VARCHAR2_TABLE_4000();
498: a30 := JTF_NUMBER_TABLE();
499: a31 := JTF_NUMBER_TABLE();
500: a32 := JTF_NUMBER_TABLE();
501: a33 := JTF_NUMBER_TABLE();
502: a34 := JTF_DATE_TABLE();
503: if t.count > 0 then
504: a0.extend(t.count);
505: a1.extend(t.count);
767: , p_init_msg_list VARCHAR2
768: , x_return_status out nocopy VARCHAR2
769: , x_msg_count out nocopy NUMBER
770: , x_msg_data out nocopy VARCHAR2
771: , p5_a0 JTF_NUMBER_TABLE
772: , p5_a1 JTF_NUMBER_TABLE
773: , p5_a2 JTF_NUMBER_TABLE
774: , p5_a3 JTF_VARCHAR2_TABLE_100
775: , p5_a4 JTF_VARCHAR2_TABLE_500
768: , x_return_status out nocopy VARCHAR2
769: , x_msg_count out nocopy NUMBER
770: , x_msg_data out nocopy VARCHAR2
771: , p5_a0 JTF_NUMBER_TABLE
772: , p5_a1 JTF_NUMBER_TABLE
773: , p5_a2 JTF_NUMBER_TABLE
774: , p5_a3 JTF_VARCHAR2_TABLE_100
775: , p5_a4 JTF_VARCHAR2_TABLE_500
776: , p5_a5 JTF_VARCHAR2_TABLE_500
769: , x_msg_count out nocopy NUMBER
770: , x_msg_data out nocopy VARCHAR2
771: , p5_a0 JTF_NUMBER_TABLE
772: , p5_a1 JTF_NUMBER_TABLE
773: , p5_a2 JTF_NUMBER_TABLE
774: , p5_a3 JTF_VARCHAR2_TABLE_100
775: , p5_a4 JTF_VARCHAR2_TABLE_500
776: , p5_a5 JTF_VARCHAR2_TABLE_500
777: , p5_a6 JTF_VARCHAR2_TABLE_500
787: , p5_a16 JTF_VARCHAR2_TABLE_500
788: , p5_a17 JTF_VARCHAR2_TABLE_500
789: , p5_a18 JTF_VARCHAR2_TABLE_500
790: , p5_a19 JTF_VARCHAR2_TABLE_100
791: , p5_a20 JTF_NUMBER_TABLE
792: , p5_a21 JTF_DATE_TABLE
793: , p5_a22 JTF_NUMBER_TABLE
794: , p5_a23 JTF_DATE_TABLE
795: , p5_a24 JTF_NUMBER_TABLE
789: , p5_a18 JTF_VARCHAR2_TABLE_500
790: , p5_a19 JTF_VARCHAR2_TABLE_100
791: , p5_a20 JTF_NUMBER_TABLE
792: , p5_a21 JTF_DATE_TABLE
793: , p5_a22 JTF_NUMBER_TABLE
794: , p5_a23 JTF_DATE_TABLE
795: , p5_a24 JTF_NUMBER_TABLE
796: , p5_a25 JTF_VARCHAR2_TABLE_100
797: , p5_a26 JTF_NUMBER_TABLE
791: , p5_a20 JTF_NUMBER_TABLE
792: , p5_a21 JTF_DATE_TABLE
793: , p5_a22 JTF_NUMBER_TABLE
794: , p5_a23 JTF_DATE_TABLE
795: , p5_a24 JTF_NUMBER_TABLE
796: , p5_a25 JTF_VARCHAR2_TABLE_100
797: , p5_a26 JTF_NUMBER_TABLE
798: , p5_a27 JTF_DATE_TABLE
799: , p5_a28 JTF_NUMBER_TABLE
793: , p5_a22 JTF_NUMBER_TABLE
794: , p5_a23 JTF_DATE_TABLE
795: , p5_a24 JTF_NUMBER_TABLE
796: , p5_a25 JTF_VARCHAR2_TABLE_100
797: , p5_a26 JTF_NUMBER_TABLE
798: , p5_a27 JTF_DATE_TABLE
799: , p5_a28 JTF_NUMBER_TABLE
800: , p5_a29 JTF_VARCHAR2_TABLE_4000
801: , p5_a30 JTF_NUMBER_TABLE
795: , p5_a24 JTF_NUMBER_TABLE
796: , p5_a25 JTF_VARCHAR2_TABLE_100
797: , p5_a26 JTF_NUMBER_TABLE
798: , p5_a27 JTF_DATE_TABLE
799: , p5_a28 JTF_NUMBER_TABLE
800: , p5_a29 JTF_VARCHAR2_TABLE_4000
801: , p5_a30 JTF_NUMBER_TABLE
802: , p5_a31 JTF_NUMBER_TABLE
803: , p5_a32 JTF_NUMBER_TABLE
797: , p5_a26 JTF_NUMBER_TABLE
798: , p5_a27 JTF_DATE_TABLE
799: , p5_a28 JTF_NUMBER_TABLE
800: , p5_a29 JTF_VARCHAR2_TABLE_4000
801: , p5_a30 JTF_NUMBER_TABLE
802: , p5_a31 JTF_NUMBER_TABLE
803: , p5_a32 JTF_NUMBER_TABLE
804: , p5_a33 JTF_NUMBER_TABLE
805: , p5_a34 JTF_DATE_TABLE
798: , p5_a27 JTF_DATE_TABLE
799: , p5_a28 JTF_NUMBER_TABLE
800: , p5_a29 JTF_VARCHAR2_TABLE_4000
801: , p5_a30 JTF_NUMBER_TABLE
802: , p5_a31 JTF_NUMBER_TABLE
803: , p5_a32 JTF_NUMBER_TABLE
804: , p5_a33 JTF_NUMBER_TABLE
805: , p5_a34 JTF_DATE_TABLE
806: , p6_a0 out nocopy JTF_NUMBER_TABLE
799: , p5_a28 JTF_NUMBER_TABLE
800: , p5_a29 JTF_VARCHAR2_TABLE_4000
801: , p5_a30 JTF_NUMBER_TABLE
802: , p5_a31 JTF_NUMBER_TABLE
803: , p5_a32 JTF_NUMBER_TABLE
804: , p5_a33 JTF_NUMBER_TABLE
805: , p5_a34 JTF_DATE_TABLE
806: , p6_a0 out nocopy JTF_NUMBER_TABLE
807: , p6_a1 out nocopy JTF_NUMBER_TABLE
800: , p5_a29 JTF_VARCHAR2_TABLE_4000
801: , p5_a30 JTF_NUMBER_TABLE
802: , p5_a31 JTF_NUMBER_TABLE
803: , p5_a32 JTF_NUMBER_TABLE
804: , p5_a33 JTF_NUMBER_TABLE
805: , p5_a34 JTF_DATE_TABLE
806: , p6_a0 out nocopy JTF_NUMBER_TABLE
807: , p6_a1 out nocopy JTF_NUMBER_TABLE
808: , p6_a2 out nocopy JTF_NUMBER_TABLE
802: , p5_a31 JTF_NUMBER_TABLE
803: , p5_a32 JTF_NUMBER_TABLE
804: , p5_a33 JTF_NUMBER_TABLE
805: , p5_a34 JTF_DATE_TABLE
806: , p6_a0 out nocopy JTF_NUMBER_TABLE
807: , p6_a1 out nocopy JTF_NUMBER_TABLE
808: , p6_a2 out nocopy JTF_NUMBER_TABLE
809: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
810: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_500
803: , p5_a32 JTF_NUMBER_TABLE
804: , p5_a33 JTF_NUMBER_TABLE
805: , p5_a34 JTF_DATE_TABLE
806: , p6_a0 out nocopy JTF_NUMBER_TABLE
807: , p6_a1 out nocopy JTF_NUMBER_TABLE
808: , p6_a2 out nocopy JTF_NUMBER_TABLE
809: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
810: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_500
811: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500
804: , p5_a33 JTF_NUMBER_TABLE
805: , p5_a34 JTF_DATE_TABLE
806: , p6_a0 out nocopy JTF_NUMBER_TABLE
807: , p6_a1 out nocopy JTF_NUMBER_TABLE
808: , p6_a2 out nocopy JTF_NUMBER_TABLE
809: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
810: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_500
811: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500
812: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
822: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
823: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
824: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
825: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
826: , p6_a20 out nocopy JTF_NUMBER_TABLE
827: , p6_a21 out nocopy JTF_DATE_TABLE
828: , p6_a22 out nocopy JTF_NUMBER_TABLE
829: , p6_a23 out nocopy JTF_DATE_TABLE
830: , p6_a24 out nocopy JTF_NUMBER_TABLE
824: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
825: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
826: , p6_a20 out nocopy JTF_NUMBER_TABLE
827: , p6_a21 out nocopy JTF_DATE_TABLE
828: , p6_a22 out nocopy JTF_NUMBER_TABLE
829: , p6_a23 out nocopy JTF_DATE_TABLE
830: , p6_a24 out nocopy JTF_NUMBER_TABLE
831: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
832: , p6_a26 out nocopy JTF_NUMBER_TABLE
826: , p6_a20 out nocopy JTF_NUMBER_TABLE
827: , p6_a21 out nocopy JTF_DATE_TABLE
828: , p6_a22 out nocopy JTF_NUMBER_TABLE
829: , p6_a23 out nocopy JTF_DATE_TABLE
830: , p6_a24 out nocopy JTF_NUMBER_TABLE
831: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
832: , p6_a26 out nocopy JTF_NUMBER_TABLE
833: , p6_a27 out nocopy JTF_DATE_TABLE
834: , p6_a28 out nocopy JTF_NUMBER_TABLE
828: , p6_a22 out nocopy JTF_NUMBER_TABLE
829: , p6_a23 out nocopy JTF_DATE_TABLE
830: , p6_a24 out nocopy JTF_NUMBER_TABLE
831: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
832: , p6_a26 out nocopy JTF_NUMBER_TABLE
833: , p6_a27 out nocopy JTF_DATE_TABLE
834: , p6_a28 out nocopy JTF_NUMBER_TABLE
835: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_4000
836: , p6_a30 out nocopy JTF_NUMBER_TABLE
830: , p6_a24 out nocopy JTF_NUMBER_TABLE
831: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
832: , p6_a26 out nocopy JTF_NUMBER_TABLE
833: , p6_a27 out nocopy JTF_DATE_TABLE
834: , p6_a28 out nocopy JTF_NUMBER_TABLE
835: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_4000
836: , p6_a30 out nocopy JTF_NUMBER_TABLE
837: , p6_a31 out nocopy JTF_NUMBER_TABLE
838: , p6_a32 out nocopy JTF_NUMBER_TABLE
832: , p6_a26 out nocopy JTF_NUMBER_TABLE
833: , p6_a27 out nocopy JTF_DATE_TABLE
834: , p6_a28 out nocopy JTF_NUMBER_TABLE
835: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_4000
836: , p6_a30 out nocopy JTF_NUMBER_TABLE
837: , p6_a31 out nocopy JTF_NUMBER_TABLE
838: , p6_a32 out nocopy JTF_NUMBER_TABLE
839: , p6_a33 out nocopy JTF_NUMBER_TABLE
840: , p6_a34 out nocopy JTF_DATE_TABLE
833: , p6_a27 out nocopy JTF_DATE_TABLE
834: , p6_a28 out nocopy JTF_NUMBER_TABLE
835: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_4000
836: , p6_a30 out nocopy JTF_NUMBER_TABLE
837: , p6_a31 out nocopy JTF_NUMBER_TABLE
838: , p6_a32 out nocopy JTF_NUMBER_TABLE
839: , p6_a33 out nocopy JTF_NUMBER_TABLE
840: , p6_a34 out nocopy JTF_DATE_TABLE
841: )
834: , p6_a28 out nocopy JTF_NUMBER_TABLE
835: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_4000
836: , p6_a30 out nocopy JTF_NUMBER_TABLE
837: , p6_a31 out nocopy JTF_NUMBER_TABLE
838: , p6_a32 out nocopy JTF_NUMBER_TABLE
839: , p6_a33 out nocopy JTF_NUMBER_TABLE
840: , p6_a34 out nocopy JTF_DATE_TABLE
841: )
842:
835: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_4000
836: , p6_a30 out nocopy JTF_NUMBER_TABLE
837: , p6_a31 out nocopy JTF_NUMBER_TABLE
838: , p6_a32 out nocopy JTF_NUMBER_TABLE
839: , p6_a33 out nocopy JTF_NUMBER_TABLE
840: , p6_a34 out nocopy JTF_DATE_TABLE
841: )
842:
843: as
1053: , p_init_msg_list VARCHAR2
1054: , x_return_status out nocopy VARCHAR2
1055: , x_msg_count out nocopy NUMBER
1056: , x_msg_data out nocopy VARCHAR2
1057: , p5_a0 JTF_NUMBER_TABLE
1058: , p5_a1 JTF_NUMBER_TABLE
1059: , p5_a2 JTF_NUMBER_TABLE
1060: , p5_a3 JTF_VARCHAR2_TABLE_100
1061: , p5_a4 JTF_VARCHAR2_TABLE_500
1054: , x_return_status out nocopy VARCHAR2
1055: , x_msg_count out nocopy NUMBER
1056: , x_msg_data out nocopy VARCHAR2
1057: , p5_a0 JTF_NUMBER_TABLE
1058: , p5_a1 JTF_NUMBER_TABLE
1059: , p5_a2 JTF_NUMBER_TABLE
1060: , p5_a3 JTF_VARCHAR2_TABLE_100
1061: , p5_a4 JTF_VARCHAR2_TABLE_500
1062: , p5_a5 JTF_VARCHAR2_TABLE_500
1055: , x_msg_count out nocopy NUMBER
1056: , x_msg_data out nocopy VARCHAR2
1057: , p5_a0 JTF_NUMBER_TABLE
1058: , p5_a1 JTF_NUMBER_TABLE
1059: , p5_a2 JTF_NUMBER_TABLE
1060: , p5_a3 JTF_VARCHAR2_TABLE_100
1061: , p5_a4 JTF_VARCHAR2_TABLE_500
1062: , p5_a5 JTF_VARCHAR2_TABLE_500
1063: , p5_a6 JTF_VARCHAR2_TABLE_500
1073: , p5_a16 JTF_VARCHAR2_TABLE_500
1074: , p5_a17 JTF_VARCHAR2_TABLE_500
1075: , p5_a18 JTF_VARCHAR2_TABLE_500
1076: , p5_a19 JTF_VARCHAR2_TABLE_100
1077: , p5_a20 JTF_NUMBER_TABLE
1078: , p5_a21 JTF_DATE_TABLE
1079: , p5_a22 JTF_NUMBER_TABLE
1080: , p5_a23 JTF_DATE_TABLE
1081: , p5_a24 JTF_NUMBER_TABLE
1075: , p5_a18 JTF_VARCHAR2_TABLE_500
1076: , p5_a19 JTF_VARCHAR2_TABLE_100
1077: , p5_a20 JTF_NUMBER_TABLE
1078: , p5_a21 JTF_DATE_TABLE
1079: , p5_a22 JTF_NUMBER_TABLE
1080: , p5_a23 JTF_DATE_TABLE
1081: , p5_a24 JTF_NUMBER_TABLE
1082: , p5_a25 JTF_VARCHAR2_TABLE_100
1083: , p5_a26 JTF_NUMBER_TABLE
1077: , p5_a20 JTF_NUMBER_TABLE
1078: , p5_a21 JTF_DATE_TABLE
1079: , p5_a22 JTF_NUMBER_TABLE
1080: , p5_a23 JTF_DATE_TABLE
1081: , p5_a24 JTF_NUMBER_TABLE
1082: , p5_a25 JTF_VARCHAR2_TABLE_100
1083: , p5_a26 JTF_NUMBER_TABLE
1084: , p5_a27 JTF_DATE_TABLE
1085: , p5_a28 JTF_NUMBER_TABLE
1079: , p5_a22 JTF_NUMBER_TABLE
1080: , p5_a23 JTF_DATE_TABLE
1081: , p5_a24 JTF_NUMBER_TABLE
1082: , p5_a25 JTF_VARCHAR2_TABLE_100
1083: , p5_a26 JTF_NUMBER_TABLE
1084: , p5_a27 JTF_DATE_TABLE
1085: , p5_a28 JTF_NUMBER_TABLE
1086: , p5_a29 JTF_VARCHAR2_TABLE_4000
1087: , p5_a30 JTF_NUMBER_TABLE
1081: , p5_a24 JTF_NUMBER_TABLE
1082: , p5_a25 JTF_VARCHAR2_TABLE_100
1083: , p5_a26 JTF_NUMBER_TABLE
1084: , p5_a27 JTF_DATE_TABLE
1085: , p5_a28 JTF_NUMBER_TABLE
1086: , p5_a29 JTF_VARCHAR2_TABLE_4000
1087: , p5_a30 JTF_NUMBER_TABLE
1088: , p5_a31 JTF_NUMBER_TABLE
1089: , p5_a32 JTF_NUMBER_TABLE
1083: , p5_a26 JTF_NUMBER_TABLE
1084: , p5_a27 JTF_DATE_TABLE
1085: , p5_a28 JTF_NUMBER_TABLE
1086: , p5_a29 JTF_VARCHAR2_TABLE_4000
1087: , p5_a30 JTF_NUMBER_TABLE
1088: , p5_a31 JTF_NUMBER_TABLE
1089: , p5_a32 JTF_NUMBER_TABLE
1090: , p5_a33 JTF_NUMBER_TABLE
1091: , p5_a34 JTF_DATE_TABLE
1084: , p5_a27 JTF_DATE_TABLE
1085: , p5_a28 JTF_NUMBER_TABLE
1086: , p5_a29 JTF_VARCHAR2_TABLE_4000
1087: , p5_a30 JTF_NUMBER_TABLE
1088: , p5_a31 JTF_NUMBER_TABLE
1089: , p5_a32 JTF_NUMBER_TABLE
1090: , p5_a33 JTF_NUMBER_TABLE
1091: , p5_a34 JTF_DATE_TABLE
1092: )
1085: , p5_a28 JTF_NUMBER_TABLE
1086: , p5_a29 JTF_VARCHAR2_TABLE_4000
1087: , p5_a30 JTF_NUMBER_TABLE
1088: , p5_a31 JTF_NUMBER_TABLE
1089: , p5_a32 JTF_NUMBER_TABLE
1090: , p5_a33 JTF_NUMBER_TABLE
1091: , p5_a34 JTF_DATE_TABLE
1092: )
1093:
1086: , p5_a29 JTF_VARCHAR2_TABLE_4000
1087: , p5_a30 JTF_NUMBER_TABLE
1088: , p5_a31 JTF_NUMBER_TABLE
1089: , p5_a32 JTF_NUMBER_TABLE
1090: , p5_a33 JTF_NUMBER_TABLE
1091: , p5_a34 JTF_DATE_TABLE
1092: )
1093:
1094: as
1338: , p_init_msg_list VARCHAR2
1339: , x_return_status out nocopy VARCHAR2
1340: , x_msg_count out nocopy NUMBER
1341: , x_msg_data out nocopy VARCHAR2
1342: , p5_a0 JTF_NUMBER_TABLE
1343: , p5_a1 JTF_NUMBER_TABLE
1344: , p5_a2 JTF_NUMBER_TABLE
1345: , p5_a3 JTF_VARCHAR2_TABLE_100
1346: , p5_a4 JTF_VARCHAR2_TABLE_500
1339: , x_return_status out nocopy VARCHAR2
1340: , x_msg_count out nocopy NUMBER
1341: , x_msg_data out nocopy VARCHAR2
1342: , p5_a0 JTF_NUMBER_TABLE
1343: , p5_a1 JTF_NUMBER_TABLE
1344: , p5_a2 JTF_NUMBER_TABLE
1345: , p5_a3 JTF_VARCHAR2_TABLE_100
1346: , p5_a4 JTF_VARCHAR2_TABLE_500
1347: , p5_a5 JTF_VARCHAR2_TABLE_500
1340: , x_msg_count out nocopy NUMBER
1341: , x_msg_data out nocopy VARCHAR2
1342: , p5_a0 JTF_NUMBER_TABLE
1343: , p5_a1 JTF_NUMBER_TABLE
1344: , p5_a2 JTF_NUMBER_TABLE
1345: , p5_a3 JTF_VARCHAR2_TABLE_100
1346: , p5_a4 JTF_VARCHAR2_TABLE_500
1347: , p5_a5 JTF_VARCHAR2_TABLE_500
1348: , p5_a6 JTF_VARCHAR2_TABLE_500
1358: , p5_a16 JTF_VARCHAR2_TABLE_500
1359: , p5_a17 JTF_VARCHAR2_TABLE_500
1360: , p5_a18 JTF_VARCHAR2_TABLE_500
1361: , p5_a19 JTF_VARCHAR2_TABLE_100
1362: , p5_a20 JTF_NUMBER_TABLE
1363: , p5_a21 JTF_DATE_TABLE
1364: , p5_a22 JTF_NUMBER_TABLE
1365: , p5_a23 JTF_DATE_TABLE
1366: , p5_a24 JTF_NUMBER_TABLE
1360: , p5_a18 JTF_VARCHAR2_TABLE_500
1361: , p5_a19 JTF_VARCHAR2_TABLE_100
1362: , p5_a20 JTF_NUMBER_TABLE
1363: , p5_a21 JTF_DATE_TABLE
1364: , p5_a22 JTF_NUMBER_TABLE
1365: , p5_a23 JTF_DATE_TABLE
1366: , p5_a24 JTF_NUMBER_TABLE
1367: , p5_a25 JTF_VARCHAR2_TABLE_100
1368: , p5_a26 JTF_NUMBER_TABLE
1362: , p5_a20 JTF_NUMBER_TABLE
1363: , p5_a21 JTF_DATE_TABLE
1364: , p5_a22 JTF_NUMBER_TABLE
1365: , p5_a23 JTF_DATE_TABLE
1366: , p5_a24 JTF_NUMBER_TABLE
1367: , p5_a25 JTF_VARCHAR2_TABLE_100
1368: , p5_a26 JTF_NUMBER_TABLE
1369: , p5_a27 JTF_DATE_TABLE
1370: , p5_a28 JTF_NUMBER_TABLE
1364: , p5_a22 JTF_NUMBER_TABLE
1365: , p5_a23 JTF_DATE_TABLE
1366: , p5_a24 JTF_NUMBER_TABLE
1367: , p5_a25 JTF_VARCHAR2_TABLE_100
1368: , p5_a26 JTF_NUMBER_TABLE
1369: , p5_a27 JTF_DATE_TABLE
1370: , p5_a28 JTF_NUMBER_TABLE
1371: , p5_a29 JTF_VARCHAR2_TABLE_4000
1372: , p5_a30 JTF_NUMBER_TABLE
1366: , p5_a24 JTF_NUMBER_TABLE
1367: , p5_a25 JTF_VARCHAR2_TABLE_100
1368: , p5_a26 JTF_NUMBER_TABLE
1369: , p5_a27 JTF_DATE_TABLE
1370: , p5_a28 JTF_NUMBER_TABLE
1371: , p5_a29 JTF_VARCHAR2_TABLE_4000
1372: , p5_a30 JTF_NUMBER_TABLE
1373: , p5_a31 JTF_NUMBER_TABLE
1374: , p5_a32 JTF_NUMBER_TABLE
1368: , p5_a26 JTF_NUMBER_TABLE
1369: , p5_a27 JTF_DATE_TABLE
1370: , p5_a28 JTF_NUMBER_TABLE
1371: , p5_a29 JTF_VARCHAR2_TABLE_4000
1372: , p5_a30 JTF_NUMBER_TABLE
1373: , p5_a31 JTF_NUMBER_TABLE
1374: , p5_a32 JTF_NUMBER_TABLE
1375: , p5_a33 JTF_NUMBER_TABLE
1376: , p5_a34 JTF_DATE_TABLE
1369: , p5_a27 JTF_DATE_TABLE
1370: , p5_a28 JTF_NUMBER_TABLE
1371: , p5_a29 JTF_VARCHAR2_TABLE_4000
1372: , p5_a30 JTF_NUMBER_TABLE
1373: , p5_a31 JTF_NUMBER_TABLE
1374: , p5_a32 JTF_NUMBER_TABLE
1375: , p5_a33 JTF_NUMBER_TABLE
1376: , p5_a34 JTF_DATE_TABLE
1377: , p6_a0 out nocopy JTF_NUMBER_TABLE
1370: , p5_a28 JTF_NUMBER_TABLE
1371: , p5_a29 JTF_VARCHAR2_TABLE_4000
1372: , p5_a30 JTF_NUMBER_TABLE
1373: , p5_a31 JTF_NUMBER_TABLE
1374: , p5_a32 JTF_NUMBER_TABLE
1375: , p5_a33 JTF_NUMBER_TABLE
1376: , p5_a34 JTF_DATE_TABLE
1377: , p6_a0 out nocopy JTF_NUMBER_TABLE
1378: , p6_a1 out nocopy JTF_NUMBER_TABLE
1371: , p5_a29 JTF_VARCHAR2_TABLE_4000
1372: , p5_a30 JTF_NUMBER_TABLE
1373: , p5_a31 JTF_NUMBER_TABLE
1374: , p5_a32 JTF_NUMBER_TABLE
1375: , p5_a33 JTF_NUMBER_TABLE
1376: , p5_a34 JTF_DATE_TABLE
1377: , p6_a0 out nocopy JTF_NUMBER_TABLE
1378: , p6_a1 out nocopy JTF_NUMBER_TABLE
1379: , p6_a2 out nocopy JTF_NUMBER_TABLE
1373: , p5_a31 JTF_NUMBER_TABLE
1374: , p5_a32 JTF_NUMBER_TABLE
1375: , p5_a33 JTF_NUMBER_TABLE
1376: , p5_a34 JTF_DATE_TABLE
1377: , p6_a0 out nocopy JTF_NUMBER_TABLE
1378: , p6_a1 out nocopy JTF_NUMBER_TABLE
1379: , p6_a2 out nocopy JTF_NUMBER_TABLE
1380: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1381: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_500
1374: , p5_a32 JTF_NUMBER_TABLE
1375: , p5_a33 JTF_NUMBER_TABLE
1376: , p5_a34 JTF_DATE_TABLE
1377: , p6_a0 out nocopy JTF_NUMBER_TABLE
1378: , p6_a1 out nocopy JTF_NUMBER_TABLE
1379: , p6_a2 out nocopy JTF_NUMBER_TABLE
1380: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1381: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_500
1382: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500
1375: , p5_a33 JTF_NUMBER_TABLE
1376: , p5_a34 JTF_DATE_TABLE
1377: , p6_a0 out nocopy JTF_NUMBER_TABLE
1378: , p6_a1 out nocopy JTF_NUMBER_TABLE
1379: , p6_a2 out nocopy JTF_NUMBER_TABLE
1380: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1381: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_500
1382: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500
1383: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
1393: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
1394: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
1395: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
1396: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
1397: , p6_a20 out nocopy JTF_NUMBER_TABLE
1398: , p6_a21 out nocopy JTF_DATE_TABLE
1399: , p6_a22 out nocopy JTF_NUMBER_TABLE
1400: , p6_a23 out nocopy JTF_DATE_TABLE
1401: , p6_a24 out nocopy JTF_NUMBER_TABLE
1395: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
1396: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
1397: , p6_a20 out nocopy JTF_NUMBER_TABLE
1398: , p6_a21 out nocopy JTF_DATE_TABLE
1399: , p6_a22 out nocopy JTF_NUMBER_TABLE
1400: , p6_a23 out nocopy JTF_DATE_TABLE
1401: , p6_a24 out nocopy JTF_NUMBER_TABLE
1402: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
1403: , p6_a26 out nocopy JTF_NUMBER_TABLE
1397: , p6_a20 out nocopy JTF_NUMBER_TABLE
1398: , p6_a21 out nocopy JTF_DATE_TABLE
1399: , p6_a22 out nocopy JTF_NUMBER_TABLE
1400: , p6_a23 out nocopy JTF_DATE_TABLE
1401: , p6_a24 out nocopy JTF_NUMBER_TABLE
1402: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
1403: , p6_a26 out nocopy JTF_NUMBER_TABLE
1404: , p6_a27 out nocopy JTF_DATE_TABLE
1405: , p6_a28 out nocopy JTF_NUMBER_TABLE
1399: , p6_a22 out nocopy JTF_NUMBER_TABLE
1400: , p6_a23 out nocopy JTF_DATE_TABLE
1401: , p6_a24 out nocopy JTF_NUMBER_TABLE
1402: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
1403: , p6_a26 out nocopy JTF_NUMBER_TABLE
1404: , p6_a27 out nocopy JTF_DATE_TABLE
1405: , p6_a28 out nocopy JTF_NUMBER_TABLE
1406: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_4000
1407: , p6_a30 out nocopy JTF_NUMBER_TABLE
1401: , p6_a24 out nocopy JTF_NUMBER_TABLE
1402: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
1403: , p6_a26 out nocopy JTF_NUMBER_TABLE
1404: , p6_a27 out nocopy JTF_DATE_TABLE
1405: , p6_a28 out nocopy JTF_NUMBER_TABLE
1406: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_4000
1407: , p6_a30 out nocopy JTF_NUMBER_TABLE
1408: , p6_a31 out nocopy JTF_NUMBER_TABLE
1409: , p6_a32 out nocopy JTF_NUMBER_TABLE
1403: , p6_a26 out nocopy JTF_NUMBER_TABLE
1404: , p6_a27 out nocopy JTF_DATE_TABLE
1405: , p6_a28 out nocopy JTF_NUMBER_TABLE
1406: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_4000
1407: , p6_a30 out nocopy JTF_NUMBER_TABLE
1408: , p6_a31 out nocopy JTF_NUMBER_TABLE
1409: , p6_a32 out nocopy JTF_NUMBER_TABLE
1410: , p6_a33 out nocopy JTF_NUMBER_TABLE
1411: , p6_a34 out nocopy JTF_DATE_TABLE
1404: , p6_a27 out nocopy JTF_DATE_TABLE
1405: , p6_a28 out nocopy JTF_NUMBER_TABLE
1406: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_4000
1407: , p6_a30 out nocopy JTF_NUMBER_TABLE
1408: , p6_a31 out nocopy JTF_NUMBER_TABLE
1409: , p6_a32 out nocopy JTF_NUMBER_TABLE
1410: , p6_a33 out nocopy JTF_NUMBER_TABLE
1411: , p6_a34 out nocopy JTF_DATE_TABLE
1412: )
1405: , p6_a28 out nocopy JTF_NUMBER_TABLE
1406: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_4000
1407: , p6_a30 out nocopy JTF_NUMBER_TABLE
1408: , p6_a31 out nocopy JTF_NUMBER_TABLE
1409: , p6_a32 out nocopy JTF_NUMBER_TABLE
1410: , p6_a33 out nocopy JTF_NUMBER_TABLE
1411: , p6_a34 out nocopy JTF_DATE_TABLE
1412: )
1413:
1406: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_4000
1407: , p6_a30 out nocopy JTF_NUMBER_TABLE
1408: , p6_a31 out nocopy JTF_NUMBER_TABLE
1409: , p6_a32 out nocopy JTF_NUMBER_TABLE
1410: , p6_a33 out nocopy JTF_NUMBER_TABLE
1411: , p6_a34 out nocopy JTF_DATE_TABLE
1412: )
1413:
1414: as
1624: , p_init_msg_list VARCHAR2
1625: , x_return_status out nocopy VARCHAR2
1626: , x_msg_count out nocopy NUMBER
1627: , x_msg_data out nocopy VARCHAR2
1628: , p5_a0 JTF_NUMBER_TABLE
1629: , p5_a1 JTF_NUMBER_TABLE
1630: , p5_a2 JTF_NUMBER_TABLE
1631: , p5_a3 JTF_VARCHAR2_TABLE_100
1632: , p5_a4 JTF_VARCHAR2_TABLE_500
1625: , x_return_status out nocopy VARCHAR2
1626: , x_msg_count out nocopy NUMBER
1627: , x_msg_data out nocopy VARCHAR2
1628: , p5_a0 JTF_NUMBER_TABLE
1629: , p5_a1 JTF_NUMBER_TABLE
1630: , p5_a2 JTF_NUMBER_TABLE
1631: , p5_a3 JTF_VARCHAR2_TABLE_100
1632: , p5_a4 JTF_VARCHAR2_TABLE_500
1633: , p5_a5 JTF_VARCHAR2_TABLE_500
1626: , x_msg_count out nocopy NUMBER
1627: , x_msg_data out nocopy VARCHAR2
1628: , p5_a0 JTF_NUMBER_TABLE
1629: , p5_a1 JTF_NUMBER_TABLE
1630: , p5_a2 JTF_NUMBER_TABLE
1631: , p5_a3 JTF_VARCHAR2_TABLE_100
1632: , p5_a4 JTF_VARCHAR2_TABLE_500
1633: , p5_a5 JTF_VARCHAR2_TABLE_500
1634: , p5_a6 JTF_VARCHAR2_TABLE_500
1644: , p5_a16 JTF_VARCHAR2_TABLE_500
1645: , p5_a17 JTF_VARCHAR2_TABLE_500
1646: , p5_a18 JTF_VARCHAR2_TABLE_500
1647: , p5_a19 JTF_VARCHAR2_TABLE_100
1648: , p5_a20 JTF_NUMBER_TABLE
1649: , p5_a21 JTF_DATE_TABLE
1650: , p5_a22 JTF_NUMBER_TABLE
1651: , p5_a23 JTF_DATE_TABLE
1652: , p5_a24 JTF_NUMBER_TABLE
1646: , p5_a18 JTF_VARCHAR2_TABLE_500
1647: , p5_a19 JTF_VARCHAR2_TABLE_100
1648: , p5_a20 JTF_NUMBER_TABLE
1649: , p5_a21 JTF_DATE_TABLE
1650: , p5_a22 JTF_NUMBER_TABLE
1651: , p5_a23 JTF_DATE_TABLE
1652: , p5_a24 JTF_NUMBER_TABLE
1653: , p5_a25 JTF_VARCHAR2_TABLE_100
1654: , p5_a26 JTF_NUMBER_TABLE
1648: , p5_a20 JTF_NUMBER_TABLE
1649: , p5_a21 JTF_DATE_TABLE
1650: , p5_a22 JTF_NUMBER_TABLE
1651: , p5_a23 JTF_DATE_TABLE
1652: , p5_a24 JTF_NUMBER_TABLE
1653: , p5_a25 JTF_VARCHAR2_TABLE_100
1654: , p5_a26 JTF_NUMBER_TABLE
1655: , p5_a27 JTF_DATE_TABLE
1656: , p5_a28 JTF_NUMBER_TABLE
1650: , p5_a22 JTF_NUMBER_TABLE
1651: , p5_a23 JTF_DATE_TABLE
1652: , p5_a24 JTF_NUMBER_TABLE
1653: , p5_a25 JTF_VARCHAR2_TABLE_100
1654: , p5_a26 JTF_NUMBER_TABLE
1655: , p5_a27 JTF_DATE_TABLE
1656: , p5_a28 JTF_NUMBER_TABLE
1657: , p5_a29 JTF_VARCHAR2_TABLE_4000
1658: , p5_a30 JTF_NUMBER_TABLE
1652: , p5_a24 JTF_NUMBER_TABLE
1653: , p5_a25 JTF_VARCHAR2_TABLE_100
1654: , p5_a26 JTF_NUMBER_TABLE
1655: , p5_a27 JTF_DATE_TABLE
1656: , p5_a28 JTF_NUMBER_TABLE
1657: , p5_a29 JTF_VARCHAR2_TABLE_4000
1658: , p5_a30 JTF_NUMBER_TABLE
1659: , p5_a31 JTF_NUMBER_TABLE
1660: , p5_a32 JTF_NUMBER_TABLE
1654: , p5_a26 JTF_NUMBER_TABLE
1655: , p5_a27 JTF_DATE_TABLE
1656: , p5_a28 JTF_NUMBER_TABLE
1657: , p5_a29 JTF_VARCHAR2_TABLE_4000
1658: , p5_a30 JTF_NUMBER_TABLE
1659: , p5_a31 JTF_NUMBER_TABLE
1660: , p5_a32 JTF_NUMBER_TABLE
1661: , p5_a33 JTF_NUMBER_TABLE
1662: , p5_a34 JTF_DATE_TABLE
1655: , p5_a27 JTF_DATE_TABLE
1656: , p5_a28 JTF_NUMBER_TABLE
1657: , p5_a29 JTF_VARCHAR2_TABLE_4000
1658: , p5_a30 JTF_NUMBER_TABLE
1659: , p5_a31 JTF_NUMBER_TABLE
1660: , p5_a32 JTF_NUMBER_TABLE
1661: , p5_a33 JTF_NUMBER_TABLE
1662: , p5_a34 JTF_DATE_TABLE
1663: )
1656: , p5_a28 JTF_NUMBER_TABLE
1657: , p5_a29 JTF_VARCHAR2_TABLE_4000
1658: , p5_a30 JTF_NUMBER_TABLE
1659: , p5_a31 JTF_NUMBER_TABLE
1660: , p5_a32 JTF_NUMBER_TABLE
1661: , p5_a33 JTF_NUMBER_TABLE
1662: , p5_a34 JTF_DATE_TABLE
1663: )
1664:
1657: , p5_a29 JTF_VARCHAR2_TABLE_4000
1658: , p5_a30 JTF_NUMBER_TABLE
1659: , p5_a31 JTF_NUMBER_TABLE
1660: , p5_a32 JTF_NUMBER_TABLE
1661: , p5_a33 JTF_NUMBER_TABLE
1662: , p5_a34 JTF_DATE_TABLE
1663: )
1664:
1665: as
1835: , p_init_msg_list VARCHAR2
1836: , x_return_status out nocopy VARCHAR2
1837: , x_msg_count out nocopy NUMBER
1838: , x_msg_data out nocopy VARCHAR2
1839: , p5_a0 JTF_NUMBER_TABLE
1840: , p5_a1 JTF_NUMBER_TABLE
1841: , p5_a2 JTF_NUMBER_TABLE
1842: , p5_a3 JTF_VARCHAR2_TABLE_100
1843: , p5_a4 JTF_VARCHAR2_TABLE_500
1836: , x_return_status out nocopy VARCHAR2
1837: , x_msg_count out nocopy NUMBER
1838: , x_msg_data out nocopy VARCHAR2
1839: , p5_a0 JTF_NUMBER_TABLE
1840: , p5_a1 JTF_NUMBER_TABLE
1841: , p5_a2 JTF_NUMBER_TABLE
1842: , p5_a3 JTF_VARCHAR2_TABLE_100
1843: , p5_a4 JTF_VARCHAR2_TABLE_500
1844: , p5_a5 JTF_VARCHAR2_TABLE_500
1837: , x_msg_count out nocopy NUMBER
1838: , x_msg_data out nocopy VARCHAR2
1839: , p5_a0 JTF_NUMBER_TABLE
1840: , p5_a1 JTF_NUMBER_TABLE
1841: , p5_a2 JTF_NUMBER_TABLE
1842: , p5_a3 JTF_VARCHAR2_TABLE_100
1843: , p5_a4 JTF_VARCHAR2_TABLE_500
1844: , p5_a5 JTF_VARCHAR2_TABLE_500
1845: , p5_a6 JTF_VARCHAR2_TABLE_500
1855: , p5_a16 JTF_VARCHAR2_TABLE_500
1856: , p5_a17 JTF_VARCHAR2_TABLE_500
1857: , p5_a18 JTF_VARCHAR2_TABLE_500
1858: , p5_a19 JTF_VARCHAR2_TABLE_100
1859: , p5_a20 JTF_NUMBER_TABLE
1860: , p5_a21 JTF_DATE_TABLE
1861: , p5_a22 JTF_NUMBER_TABLE
1862: , p5_a23 JTF_DATE_TABLE
1863: , p5_a24 JTF_NUMBER_TABLE
1857: , p5_a18 JTF_VARCHAR2_TABLE_500
1858: , p5_a19 JTF_VARCHAR2_TABLE_100
1859: , p5_a20 JTF_NUMBER_TABLE
1860: , p5_a21 JTF_DATE_TABLE
1861: , p5_a22 JTF_NUMBER_TABLE
1862: , p5_a23 JTF_DATE_TABLE
1863: , p5_a24 JTF_NUMBER_TABLE
1864: , p5_a25 JTF_VARCHAR2_TABLE_100
1865: , p5_a26 JTF_NUMBER_TABLE
1859: , p5_a20 JTF_NUMBER_TABLE
1860: , p5_a21 JTF_DATE_TABLE
1861: , p5_a22 JTF_NUMBER_TABLE
1862: , p5_a23 JTF_DATE_TABLE
1863: , p5_a24 JTF_NUMBER_TABLE
1864: , p5_a25 JTF_VARCHAR2_TABLE_100
1865: , p5_a26 JTF_NUMBER_TABLE
1866: , p5_a27 JTF_DATE_TABLE
1867: , p5_a28 JTF_NUMBER_TABLE
1861: , p5_a22 JTF_NUMBER_TABLE
1862: , p5_a23 JTF_DATE_TABLE
1863: , p5_a24 JTF_NUMBER_TABLE
1864: , p5_a25 JTF_VARCHAR2_TABLE_100
1865: , p5_a26 JTF_NUMBER_TABLE
1866: , p5_a27 JTF_DATE_TABLE
1867: , p5_a28 JTF_NUMBER_TABLE
1868: , p5_a29 JTF_VARCHAR2_TABLE_4000
1869: , p5_a30 JTF_NUMBER_TABLE
1863: , p5_a24 JTF_NUMBER_TABLE
1864: , p5_a25 JTF_VARCHAR2_TABLE_100
1865: , p5_a26 JTF_NUMBER_TABLE
1866: , p5_a27 JTF_DATE_TABLE
1867: , p5_a28 JTF_NUMBER_TABLE
1868: , p5_a29 JTF_VARCHAR2_TABLE_4000
1869: , p5_a30 JTF_NUMBER_TABLE
1870: , p5_a31 JTF_NUMBER_TABLE
1871: , p5_a32 JTF_NUMBER_TABLE
1865: , p5_a26 JTF_NUMBER_TABLE
1866: , p5_a27 JTF_DATE_TABLE
1867: , p5_a28 JTF_NUMBER_TABLE
1868: , p5_a29 JTF_VARCHAR2_TABLE_4000
1869: , p5_a30 JTF_NUMBER_TABLE
1870: , p5_a31 JTF_NUMBER_TABLE
1871: , p5_a32 JTF_NUMBER_TABLE
1872: , p5_a33 JTF_NUMBER_TABLE
1873: , p5_a34 JTF_DATE_TABLE
1866: , p5_a27 JTF_DATE_TABLE
1867: , p5_a28 JTF_NUMBER_TABLE
1868: , p5_a29 JTF_VARCHAR2_TABLE_4000
1869: , p5_a30 JTF_NUMBER_TABLE
1870: , p5_a31 JTF_NUMBER_TABLE
1871: , p5_a32 JTF_NUMBER_TABLE
1872: , p5_a33 JTF_NUMBER_TABLE
1873: , p5_a34 JTF_DATE_TABLE
1874: )
1867: , p5_a28 JTF_NUMBER_TABLE
1868: , p5_a29 JTF_VARCHAR2_TABLE_4000
1869: , p5_a30 JTF_NUMBER_TABLE
1870: , p5_a31 JTF_NUMBER_TABLE
1871: , p5_a32 JTF_NUMBER_TABLE
1872: , p5_a33 JTF_NUMBER_TABLE
1873: , p5_a34 JTF_DATE_TABLE
1874: )
1875:
1868: , p5_a29 JTF_VARCHAR2_TABLE_4000
1869: , p5_a30 JTF_NUMBER_TABLE
1870: , p5_a31 JTF_NUMBER_TABLE
1871: , p5_a32 JTF_NUMBER_TABLE
1872: , p5_a33 JTF_NUMBER_TABLE
1873: , p5_a34 JTF_DATE_TABLE
1874: )
1875:
1876: as