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_pfl_pvt.pflv_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_300
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_DATE_TABLE
26: , a4 JTF_DATE_TABLE
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_pfl_pvt.pflv_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_300
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_DATE_TABLE
26: , a4 JTF_DATE_TABLE
27: , a5 JTF_DATE_TABLE
28: , a6 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_DATE_TABLE
27: , a5 JTF_DATE_TABLE
28: , a6 JTF_VARCHAR2_TABLE_100
29: , a7 JTF_VARCHAR2_TABLE_100
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_NUMBER_TABLE
34: , a12 JTF_VARCHAR2_TABLE_2000
27: , a5 JTF_DATE_TABLE
28: , a6 JTF_VARCHAR2_TABLE_100
29: , a7 JTF_VARCHAR2_TABLE_100
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_NUMBER_TABLE
34: , a12 JTF_VARCHAR2_TABLE_2000
35: , a13 JTF_NUMBER_TABLE
28: , a6 JTF_VARCHAR2_TABLE_100
29: , a7 JTF_VARCHAR2_TABLE_100
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_NUMBER_TABLE
34: , a12 JTF_VARCHAR2_TABLE_2000
35: , a13 JTF_NUMBER_TABLE
36: , a14 JTF_NUMBER_TABLE
29: , a7 JTF_VARCHAR2_TABLE_100
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_NUMBER_TABLE
34: , a12 JTF_VARCHAR2_TABLE_2000
35: , a13 JTF_NUMBER_TABLE
36: , a14 JTF_NUMBER_TABLE
37: , a15 JTF_NUMBER_TABLE
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_NUMBER_TABLE
34: , a12 JTF_VARCHAR2_TABLE_2000
35: , a13 JTF_NUMBER_TABLE
36: , a14 JTF_NUMBER_TABLE
37: , a15 JTF_NUMBER_TABLE
38: , a16 JTF_NUMBER_TABLE
39: , a17 JTF_DATE_TABLE
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_NUMBER_TABLE
34: , a12 JTF_VARCHAR2_TABLE_2000
35: , a13 JTF_NUMBER_TABLE
36: , a14 JTF_NUMBER_TABLE
37: , a15 JTF_NUMBER_TABLE
38: , a16 JTF_NUMBER_TABLE
39: , a17 JTF_DATE_TABLE
40: , a18 JTF_VARCHAR2_TABLE_300
33: , a11 JTF_NUMBER_TABLE
34: , a12 JTF_VARCHAR2_TABLE_2000
35: , a13 JTF_NUMBER_TABLE
36: , a14 JTF_NUMBER_TABLE
37: , a15 JTF_NUMBER_TABLE
38: , a16 JTF_NUMBER_TABLE
39: , a17 JTF_DATE_TABLE
40: , a18 JTF_VARCHAR2_TABLE_300
41: , a19 JTF_VARCHAR2_TABLE_300
34: , a12 JTF_VARCHAR2_TABLE_2000
35: , a13 JTF_NUMBER_TABLE
36: , a14 JTF_NUMBER_TABLE
37: , a15 JTF_NUMBER_TABLE
38: , a16 JTF_NUMBER_TABLE
39: , a17 JTF_DATE_TABLE
40: , a18 JTF_VARCHAR2_TABLE_300
41: , a19 JTF_VARCHAR2_TABLE_300
42: , a20 JTF_VARCHAR2_TABLE_300
52: , a30 JTF_VARCHAR2_TABLE_300
53: , a31 JTF_VARCHAR2_TABLE_300
54: , a32 JTF_VARCHAR2_TABLE_300
55: , a33 JTF_VARCHAR2_TABLE_300
56: , a34 JTF_NUMBER_TABLE
57: , a35 JTF_DATE_TABLE
58: , a36 JTF_NUMBER_TABLE
59: , a37 JTF_DATE_TABLE
60: , a38 JTF_NUMBER_TABLE
54: , a32 JTF_VARCHAR2_TABLE_300
55: , a33 JTF_VARCHAR2_TABLE_300
56: , a34 JTF_NUMBER_TABLE
57: , a35 JTF_DATE_TABLE
58: , a36 JTF_NUMBER_TABLE
59: , a37 JTF_DATE_TABLE
60: , a38 JTF_NUMBER_TABLE
61: , a39 JTF_VARCHAR2_TABLE_100
62: , a40 JTF_VARCHAR2_TABLE_100
56: , a34 JTF_NUMBER_TABLE
57: , a35 JTF_DATE_TABLE
58: , a36 JTF_NUMBER_TABLE
59: , a37 JTF_DATE_TABLE
60: , a38 JTF_NUMBER_TABLE
61: , a39 JTF_VARCHAR2_TABLE_100
62: , a40 JTF_VARCHAR2_TABLE_100
63: , a41 JTF_VARCHAR2_TABLE_100
64: , a42 JTF_NUMBER_TABLE
60: , a38 JTF_NUMBER_TABLE
61: , a39 JTF_VARCHAR2_TABLE_100
62: , a40 JTF_VARCHAR2_TABLE_100
63: , a41 JTF_VARCHAR2_TABLE_100
64: , a42 JTF_NUMBER_TABLE
65: , a43 JTF_DATE_TABLE
66: ) as
67: ddindx binary_integer; indx binary_integer;
68: begin
123: end loop;
124: end if;
125: end if;
126: end rosetta_table_copy_in_p2;
127: procedure rosetta_table_copy_out_p2(t okl_pfl_pvt.pflv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
128: , a1 out nocopy JTF_VARCHAR2_TABLE_300
129: , a2 out nocopy JTF_NUMBER_TABLE
130: , a3 out nocopy JTF_DATE_TABLE
131: , a4 out nocopy JTF_DATE_TABLE
125: end if;
126: end rosetta_table_copy_in_p2;
127: procedure rosetta_table_copy_out_p2(t okl_pfl_pvt.pflv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
128: , a1 out nocopy JTF_VARCHAR2_TABLE_300
129: , a2 out nocopy JTF_NUMBER_TABLE
130: , a3 out nocopy JTF_DATE_TABLE
131: , a4 out nocopy JTF_DATE_TABLE
132: , a5 out nocopy JTF_DATE_TABLE
133: , a6 out nocopy JTF_VARCHAR2_TABLE_100
131: , a4 out nocopy JTF_DATE_TABLE
132: , a5 out nocopy JTF_DATE_TABLE
133: , a6 out nocopy JTF_VARCHAR2_TABLE_100
134: , a7 out nocopy JTF_VARCHAR2_TABLE_100
135: , a8 out nocopy JTF_NUMBER_TABLE
136: , a9 out nocopy JTF_NUMBER_TABLE
137: , a10 out nocopy JTF_NUMBER_TABLE
138: , a11 out nocopy JTF_NUMBER_TABLE
139: , a12 out nocopy JTF_VARCHAR2_TABLE_2000
132: , a5 out nocopy JTF_DATE_TABLE
133: , a6 out nocopy JTF_VARCHAR2_TABLE_100
134: , a7 out nocopy JTF_VARCHAR2_TABLE_100
135: , a8 out nocopy JTF_NUMBER_TABLE
136: , a9 out nocopy JTF_NUMBER_TABLE
137: , a10 out nocopy JTF_NUMBER_TABLE
138: , a11 out nocopy JTF_NUMBER_TABLE
139: , a12 out nocopy JTF_VARCHAR2_TABLE_2000
140: , a13 out nocopy JTF_NUMBER_TABLE
133: , a6 out nocopy JTF_VARCHAR2_TABLE_100
134: , a7 out nocopy JTF_VARCHAR2_TABLE_100
135: , a8 out nocopy JTF_NUMBER_TABLE
136: , a9 out nocopy JTF_NUMBER_TABLE
137: , a10 out nocopy JTF_NUMBER_TABLE
138: , a11 out nocopy JTF_NUMBER_TABLE
139: , a12 out nocopy JTF_VARCHAR2_TABLE_2000
140: , a13 out nocopy JTF_NUMBER_TABLE
141: , a14 out nocopy JTF_NUMBER_TABLE
134: , a7 out nocopy JTF_VARCHAR2_TABLE_100
135: , a8 out nocopy JTF_NUMBER_TABLE
136: , a9 out nocopy JTF_NUMBER_TABLE
137: , a10 out nocopy JTF_NUMBER_TABLE
138: , a11 out nocopy JTF_NUMBER_TABLE
139: , a12 out nocopy JTF_VARCHAR2_TABLE_2000
140: , a13 out nocopy JTF_NUMBER_TABLE
141: , a14 out nocopy JTF_NUMBER_TABLE
142: , a15 out nocopy JTF_NUMBER_TABLE
136: , a9 out nocopy JTF_NUMBER_TABLE
137: , a10 out nocopy JTF_NUMBER_TABLE
138: , a11 out nocopy JTF_NUMBER_TABLE
139: , a12 out nocopy JTF_VARCHAR2_TABLE_2000
140: , a13 out nocopy JTF_NUMBER_TABLE
141: , a14 out nocopy JTF_NUMBER_TABLE
142: , a15 out nocopy JTF_NUMBER_TABLE
143: , a16 out nocopy JTF_NUMBER_TABLE
144: , a17 out nocopy JTF_DATE_TABLE
137: , a10 out nocopy JTF_NUMBER_TABLE
138: , a11 out nocopy JTF_NUMBER_TABLE
139: , a12 out nocopy JTF_VARCHAR2_TABLE_2000
140: , a13 out nocopy JTF_NUMBER_TABLE
141: , a14 out nocopy JTF_NUMBER_TABLE
142: , a15 out nocopy JTF_NUMBER_TABLE
143: , a16 out nocopy JTF_NUMBER_TABLE
144: , a17 out nocopy JTF_DATE_TABLE
145: , a18 out nocopy JTF_VARCHAR2_TABLE_300
138: , a11 out nocopy JTF_NUMBER_TABLE
139: , a12 out nocopy JTF_VARCHAR2_TABLE_2000
140: , a13 out nocopy JTF_NUMBER_TABLE
141: , a14 out nocopy JTF_NUMBER_TABLE
142: , a15 out nocopy JTF_NUMBER_TABLE
143: , a16 out nocopy JTF_NUMBER_TABLE
144: , a17 out nocopy JTF_DATE_TABLE
145: , a18 out nocopy JTF_VARCHAR2_TABLE_300
146: , a19 out nocopy JTF_VARCHAR2_TABLE_300
139: , a12 out nocopy JTF_VARCHAR2_TABLE_2000
140: , a13 out nocopy JTF_NUMBER_TABLE
141: , a14 out nocopy JTF_NUMBER_TABLE
142: , a15 out nocopy JTF_NUMBER_TABLE
143: , a16 out nocopy JTF_NUMBER_TABLE
144: , a17 out nocopy JTF_DATE_TABLE
145: , a18 out nocopy JTF_VARCHAR2_TABLE_300
146: , a19 out nocopy JTF_VARCHAR2_TABLE_300
147: , a20 out nocopy JTF_VARCHAR2_TABLE_300
157: , a30 out nocopy JTF_VARCHAR2_TABLE_300
158: , a31 out nocopy JTF_VARCHAR2_TABLE_300
159: , a32 out nocopy JTF_VARCHAR2_TABLE_300
160: , a33 out nocopy JTF_VARCHAR2_TABLE_300
161: , a34 out nocopy JTF_NUMBER_TABLE
162: , a35 out nocopy JTF_DATE_TABLE
163: , a36 out nocopy JTF_NUMBER_TABLE
164: , a37 out nocopy JTF_DATE_TABLE
165: , a38 out nocopy JTF_NUMBER_TABLE
159: , a32 out nocopy JTF_VARCHAR2_TABLE_300
160: , a33 out nocopy JTF_VARCHAR2_TABLE_300
161: , a34 out nocopy JTF_NUMBER_TABLE
162: , a35 out nocopy JTF_DATE_TABLE
163: , a36 out nocopy JTF_NUMBER_TABLE
164: , a37 out nocopy JTF_DATE_TABLE
165: , a38 out nocopy JTF_NUMBER_TABLE
166: , a39 out nocopy JTF_VARCHAR2_TABLE_100
167: , a40 out nocopy JTF_VARCHAR2_TABLE_100
161: , a34 out nocopy JTF_NUMBER_TABLE
162: , a35 out nocopy JTF_DATE_TABLE
163: , a36 out nocopy JTF_NUMBER_TABLE
164: , a37 out nocopy JTF_DATE_TABLE
165: , a38 out nocopy JTF_NUMBER_TABLE
166: , a39 out nocopy JTF_VARCHAR2_TABLE_100
167: , a40 out nocopy JTF_VARCHAR2_TABLE_100
168: , a41 out nocopy JTF_VARCHAR2_TABLE_100
169: , a42 out nocopy JTF_NUMBER_TABLE
165: , a38 out nocopy JTF_NUMBER_TABLE
166: , a39 out nocopy JTF_VARCHAR2_TABLE_100
167: , a40 out nocopy JTF_VARCHAR2_TABLE_100
168: , a41 out nocopy JTF_VARCHAR2_TABLE_100
169: , a42 out nocopy JTF_NUMBER_TABLE
170: , a43 out nocopy JTF_DATE_TABLE
171: ) as
172: ddindx binary_integer; indx binary_integer;
173: begin
171: ) as
172: ddindx binary_integer; indx binary_integer;
173: begin
174: if t is null or t.count = 0 then
175: a0 := JTF_NUMBER_TABLE();
176: a1 := JTF_VARCHAR2_TABLE_300();
177: a2 := JTF_NUMBER_TABLE();
178: a3 := JTF_DATE_TABLE();
179: a4 := JTF_DATE_TABLE();
173: begin
174: if t is null or t.count = 0 then
175: a0 := JTF_NUMBER_TABLE();
176: a1 := JTF_VARCHAR2_TABLE_300();
177: a2 := JTF_NUMBER_TABLE();
178: a3 := JTF_DATE_TABLE();
179: a4 := JTF_DATE_TABLE();
180: a5 := JTF_DATE_TABLE();
181: a6 := JTF_VARCHAR2_TABLE_100();
179: a4 := JTF_DATE_TABLE();
180: a5 := JTF_DATE_TABLE();
181: a6 := JTF_VARCHAR2_TABLE_100();
182: a7 := JTF_VARCHAR2_TABLE_100();
183: a8 := JTF_NUMBER_TABLE();
184: a9 := JTF_NUMBER_TABLE();
185: a10 := JTF_NUMBER_TABLE();
186: a11 := JTF_NUMBER_TABLE();
187: a12 := JTF_VARCHAR2_TABLE_2000();
180: a5 := JTF_DATE_TABLE();
181: a6 := JTF_VARCHAR2_TABLE_100();
182: a7 := JTF_VARCHAR2_TABLE_100();
183: a8 := JTF_NUMBER_TABLE();
184: a9 := JTF_NUMBER_TABLE();
185: a10 := JTF_NUMBER_TABLE();
186: a11 := JTF_NUMBER_TABLE();
187: a12 := JTF_VARCHAR2_TABLE_2000();
188: a13 := JTF_NUMBER_TABLE();
181: a6 := JTF_VARCHAR2_TABLE_100();
182: a7 := JTF_VARCHAR2_TABLE_100();
183: a8 := JTF_NUMBER_TABLE();
184: a9 := JTF_NUMBER_TABLE();
185: a10 := JTF_NUMBER_TABLE();
186: a11 := JTF_NUMBER_TABLE();
187: a12 := JTF_VARCHAR2_TABLE_2000();
188: a13 := JTF_NUMBER_TABLE();
189: a14 := JTF_NUMBER_TABLE();
182: a7 := JTF_VARCHAR2_TABLE_100();
183: a8 := JTF_NUMBER_TABLE();
184: a9 := JTF_NUMBER_TABLE();
185: a10 := JTF_NUMBER_TABLE();
186: a11 := JTF_NUMBER_TABLE();
187: a12 := JTF_VARCHAR2_TABLE_2000();
188: a13 := JTF_NUMBER_TABLE();
189: a14 := JTF_NUMBER_TABLE();
190: a15 := JTF_NUMBER_TABLE();
184: a9 := JTF_NUMBER_TABLE();
185: a10 := JTF_NUMBER_TABLE();
186: a11 := JTF_NUMBER_TABLE();
187: a12 := JTF_VARCHAR2_TABLE_2000();
188: a13 := JTF_NUMBER_TABLE();
189: a14 := JTF_NUMBER_TABLE();
190: a15 := JTF_NUMBER_TABLE();
191: a16 := JTF_NUMBER_TABLE();
192: a17 := JTF_DATE_TABLE();
185: a10 := JTF_NUMBER_TABLE();
186: a11 := JTF_NUMBER_TABLE();
187: a12 := JTF_VARCHAR2_TABLE_2000();
188: a13 := JTF_NUMBER_TABLE();
189: a14 := JTF_NUMBER_TABLE();
190: a15 := JTF_NUMBER_TABLE();
191: a16 := JTF_NUMBER_TABLE();
192: a17 := JTF_DATE_TABLE();
193: a18 := JTF_VARCHAR2_TABLE_300();
186: a11 := JTF_NUMBER_TABLE();
187: a12 := JTF_VARCHAR2_TABLE_2000();
188: a13 := JTF_NUMBER_TABLE();
189: a14 := JTF_NUMBER_TABLE();
190: a15 := JTF_NUMBER_TABLE();
191: a16 := JTF_NUMBER_TABLE();
192: a17 := JTF_DATE_TABLE();
193: a18 := JTF_VARCHAR2_TABLE_300();
194: a19 := JTF_VARCHAR2_TABLE_300();
187: a12 := JTF_VARCHAR2_TABLE_2000();
188: a13 := JTF_NUMBER_TABLE();
189: a14 := JTF_NUMBER_TABLE();
190: a15 := JTF_NUMBER_TABLE();
191: a16 := JTF_NUMBER_TABLE();
192: a17 := JTF_DATE_TABLE();
193: a18 := JTF_VARCHAR2_TABLE_300();
194: a19 := JTF_VARCHAR2_TABLE_300();
195: a20 := JTF_VARCHAR2_TABLE_300();
205: a30 := JTF_VARCHAR2_TABLE_300();
206: a31 := JTF_VARCHAR2_TABLE_300();
207: a32 := JTF_VARCHAR2_TABLE_300();
208: a33 := JTF_VARCHAR2_TABLE_300();
209: a34 := JTF_NUMBER_TABLE();
210: a35 := JTF_DATE_TABLE();
211: a36 := JTF_NUMBER_TABLE();
212: a37 := JTF_DATE_TABLE();
213: a38 := JTF_NUMBER_TABLE();
207: a32 := JTF_VARCHAR2_TABLE_300();
208: a33 := JTF_VARCHAR2_TABLE_300();
209: a34 := JTF_NUMBER_TABLE();
210: a35 := JTF_DATE_TABLE();
211: a36 := JTF_NUMBER_TABLE();
212: a37 := JTF_DATE_TABLE();
213: a38 := JTF_NUMBER_TABLE();
214: a39 := JTF_VARCHAR2_TABLE_100();
215: a40 := JTF_VARCHAR2_TABLE_100();
209: a34 := JTF_NUMBER_TABLE();
210: a35 := JTF_DATE_TABLE();
211: a36 := JTF_NUMBER_TABLE();
212: a37 := JTF_DATE_TABLE();
213: a38 := JTF_NUMBER_TABLE();
214: a39 := JTF_VARCHAR2_TABLE_100();
215: a40 := JTF_VARCHAR2_TABLE_100();
216: a41 := JTF_VARCHAR2_TABLE_100();
217: a42 := JTF_NUMBER_TABLE();
213: a38 := JTF_NUMBER_TABLE();
214: a39 := JTF_VARCHAR2_TABLE_100();
215: a40 := JTF_VARCHAR2_TABLE_100();
216: a41 := JTF_VARCHAR2_TABLE_100();
217: a42 := JTF_NUMBER_TABLE();
218: a43 := JTF_DATE_TABLE();
219: else
220: a0 := JTF_NUMBER_TABLE();
221: a1 := JTF_VARCHAR2_TABLE_300();
216: a41 := JTF_VARCHAR2_TABLE_100();
217: a42 := JTF_NUMBER_TABLE();
218: a43 := JTF_DATE_TABLE();
219: else
220: a0 := JTF_NUMBER_TABLE();
221: a1 := JTF_VARCHAR2_TABLE_300();
222: a2 := JTF_NUMBER_TABLE();
223: a3 := JTF_DATE_TABLE();
224: a4 := JTF_DATE_TABLE();
218: a43 := JTF_DATE_TABLE();
219: else
220: a0 := JTF_NUMBER_TABLE();
221: a1 := JTF_VARCHAR2_TABLE_300();
222: a2 := JTF_NUMBER_TABLE();
223: a3 := JTF_DATE_TABLE();
224: a4 := JTF_DATE_TABLE();
225: a5 := JTF_DATE_TABLE();
226: a6 := JTF_VARCHAR2_TABLE_100();
224: a4 := JTF_DATE_TABLE();
225: a5 := JTF_DATE_TABLE();
226: a6 := JTF_VARCHAR2_TABLE_100();
227: a7 := JTF_VARCHAR2_TABLE_100();
228: a8 := JTF_NUMBER_TABLE();
229: a9 := JTF_NUMBER_TABLE();
230: a10 := JTF_NUMBER_TABLE();
231: a11 := JTF_NUMBER_TABLE();
232: a12 := JTF_VARCHAR2_TABLE_2000();
225: a5 := JTF_DATE_TABLE();
226: a6 := JTF_VARCHAR2_TABLE_100();
227: a7 := JTF_VARCHAR2_TABLE_100();
228: a8 := JTF_NUMBER_TABLE();
229: a9 := JTF_NUMBER_TABLE();
230: a10 := JTF_NUMBER_TABLE();
231: a11 := JTF_NUMBER_TABLE();
232: a12 := JTF_VARCHAR2_TABLE_2000();
233: a13 := JTF_NUMBER_TABLE();
226: a6 := JTF_VARCHAR2_TABLE_100();
227: a7 := JTF_VARCHAR2_TABLE_100();
228: a8 := JTF_NUMBER_TABLE();
229: a9 := JTF_NUMBER_TABLE();
230: a10 := JTF_NUMBER_TABLE();
231: a11 := JTF_NUMBER_TABLE();
232: a12 := JTF_VARCHAR2_TABLE_2000();
233: a13 := JTF_NUMBER_TABLE();
234: a14 := JTF_NUMBER_TABLE();
227: a7 := JTF_VARCHAR2_TABLE_100();
228: a8 := JTF_NUMBER_TABLE();
229: a9 := JTF_NUMBER_TABLE();
230: a10 := JTF_NUMBER_TABLE();
231: a11 := JTF_NUMBER_TABLE();
232: a12 := JTF_VARCHAR2_TABLE_2000();
233: a13 := JTF_NUMBER_TABLE();
234: a14 := JTF_NUMBER_TABLE();
235: a15 := JTF_NUMBER_TABLE();
229: a9 := JTF_NUMBER_TABLE();
230: a10 := JTF_NUMBER_TABLE();
231: a11 := JTF_NUMBER_TABLE();
232: a12 := JTF_VARCHAR2_TABLE_2000();
233: a13 := JTF_NUMBER_TABLE();
234: a14 := JTF_NUMBER_TABLE();
235: a15 := JTF_NUMBER_TABLE();
236: a16 := JTF_NUMBER_TABLE();
237: a17 := JTF_DATE_TABLE();
230: a10 := JTF_NUMBER_TABLE();
231: a11 := JTF_NUMBER_TABLE();
232: a12 := JTF_VARCHAR2_TABLE_2000();
233: a13 := JTF_NUMBER_TABLE();
234: a14 := JTF_NUMBER_TABLE();
235: a15 := JTF_NUMBER_TABLE();
236: a16 := JTF_NUMBER_TABLE();
237: a17 := JTF_DATE_TABLE();
238: a18 := JTF_VARCHAR2_TABLE_300();
231: a11 := JTF_NUMBER_TABLE();
232: a12 := JTF_VARCHAR2_TABLE_2000();
233: a13 := JTF_NUMBER_TABLE();
234: a14 := JTF_NUMBER_TABLE();
235: a15 := JTF_NUMBER_TABLE();
236: a16 := JTF_NUMBER_TABLE();
237: a17 := JTF_DATE_TABLE();
238: a18 := JTF_VARCHAR2_TABLE_300();
239: a19 := JTF_VARCHAR2_TABLE_300();
232: a12 := JTF_VARCHAR2_TABLE_2000();
233: a13 := JTF_NUMBER_TABLE();
234: a14 := JTF_NUMBER_TABLE();
235: a15 := JTF_NUMBER_TABLE();
236: a16 := JTF_NUMBER_TABLE();
237: a17 := JTF_DATE_TABLE();
238: a18 := JTF_VARCHAR2_TABLE_300();
239: a19 := JTF_VARCHAR2_TABLE_300();
240: a20 := JTF_VARCHAR2_TABLE_300();
250: a30 := JTF_VARCHAR2_TABLE_300();
251: a31 := JTF_VARCHAR2_TABLE_300();
252: a32 := JTF_VARCHAR2_TABLE_300();
253: a33 := JTF_VARCHAR2_TABLE_300();
254: a34 := JTF_NUMBER_TABLE();
255: a35 := JTF_DATE_TABLE();
256: a36 := JTF_NUMBER_TABLE();
257: a37 := JTF_DATE_TABLE();
258: a38 := JTF_NUMBER_TABLE();
252: a32 := JTF_VARCHAR2_TABLE_300();
253: a33 := JTF_VARCHAR2_TABLE_300();
254: a34 := JTF_NUMBER_TABLE();
255: a35 := JTF_DATE_TABLE();
256: a36 := JTF_NUMBER_TABLE();
257: a37 := JTF_DATE_TABLE();
258: a38 := JTF_NUMBER_TABLE();
259: a39 := JTF_VARCHAR2_TABLE_100();
260: a40 := JTF_VARCHAR2_TABLE_100();
254: a34 := JTF_NUMBER_TABLE();
255: a35 := JTF_DATE_TABLE();
256: a36 := JTF_NUMBER_TABLE();
257: a37 := JTF_DATE_TABLE();
258: a38 := JTF_NUMBER_TABLE();
259: a39 := JTF_VARCHAR2_TABLE_100();
260: a40 := JTF_VARCHAR2_TABLE_100();
261: a41 := JTF_VARCHAR2_TABLE_100();
262: a42 := JTF_NUMBER_TABLE();
258: a38 := JTF_NUMBER_TABLE();
259: a39 := JTF_VARCHAR2_TABLE_100();
260: a40 := JTF_VARCHAR2_TABLE_100();
261: a41 := JTF_VARCHAR2_TABLE_100();
262: a42 := JTF_NUMBER_TABLE();
263: a43 := JTF_DATE_TABLE();
264: if t.count > 0 then
265: a0.extend(t.count);
266: a1.extend(t.count);
362: end if;
363: end if;
364: end rosetta_table_copy_out_p2;
365:
366: procedure rosetta_table_copy_in_p5(t out nocopy okl_pfl_pvt.pfl_tbl_type, a0 JTF_NUMBER_TABLE
367: , a1 JTF_NUMBER_TABLE
368: , a2 JTF_DATE_TABLE
369: , a3 JTF_DATE_TABLE
370: , a4 JTF_DATE_TABLE
363: end if;
364: end rosetta_table_copy_out_p2;
365:
366: procedure rosetta_table_copy_in_p5(t out nocopy okl_pfl_pvt.pfl_tbl_type, a0 JTF_NUMBER_TABLE
367: , a1 JTF_NUMBER_TABLE
368: , a2 JTF_DATE_TABLE
369: , a3 JTF_DATE_TABLE
370: , a4 JTF_DATE_TABLE
371: , a5 JTF_VARCHAR2_TABLE_100
369: , a3 JTF_DATE_TABLE
370: , a4 JTF_DATE_TABLE
371: , a5 JTF_VARCHAR2_TABLE_100
372: , a6 JTF_VARCHAR2_TABLE_100
373: , a7 JTF_NUMBER_TABLE
374: , a8 JTF_NUMBER_TABLE
375: , a9 JTF_NUMBER_TABLE
376: , a10 JTF_NUMBER_TABLE
377: , a11 JTF_NUMBER_TABLE
370: , a4 JTF_DATE_TABLE
371: , a5 JTF_VARCHAR2_TABLE_100
372: , a6 JTF_VARCHAR2_TABLE_100
373: , a7 JTF_NUMBER_TABLE
374: , a8 JTF_NUMBER_TABLE
375: , a9 JTF_NUMBER_TABLE
376: , a10 JTF_NUMBER_TABLE
377: , a11 JTF_NUMBER_TABLE
378: , a12 JTF_NUMBER_TABLE
371: , a5 JTF_VARCHAR2_TABLE_100
372: , a6 JTF_VARCHAR2_TABLE_100
373: , a7 JTF_NUMBER_TABLE
374: , a8 JTF_NUMBER_TABLE
375: , a9 JTF_NUMBER_TABLE
376: , a10 JTF_NUMBER_TABLE
377: , a11 JTF_NUMBER_TABLE
378: , a12 JTF_NUMBER_TABLE
379: , a13 JTF_NUMBER_TABLE
372: , a6 JTF_VARCHAR2_TABLE_100
373: , a7 JTF_NUMBER_TABLE
374: , a8 JTF_NUMBER_TABLE
375: , a9 JTF_NUMBER_TABLE
376: , a10 JTF_NUMBER_TABLE
377: , a11 JTF_NUMBER_TABLE
378: , a12 JTF_NUMBER_TABLE
379: , a13 JTF_NUMBER_TABLE
380: , a14 JTF_NUMBER_TABLE
373: , a7 JTF_NUMBER_TABLE
374: , a8 JTF_NUMBER_TABLE
375: , a9 JTF_NUMBER_TABLE
376: , a10 JTF_NUMBER_TABLE
377: , a11 JTF_NUMBER_TABLE
378: , a12 JTF_NUMBER_TABLE
379: , a13 JTF_NUMBER_TABLE
380: , a14 JTF_NUMBER_TABLE
381: , a15 JTF_DATE_TABLE
374: , a8 JTF_NUMBER_TABLE
375: , a9 JTF_NUMBER_TABLE
376: , a10 JTF_NUMBER_TABLE
377: , a11 JTF_NUMBER_TABLE
378: , a12 JTF_NUMBER_TABLE
379: , a13 JTF_NUMBER_TABLE
380: , a14 JTF_NUMBER_TABLE
381: , a15 JTF_DATE_TABLE
382: , a16 JTF_VARCHAR2_TABLE_300
375: , a9 JTF_NUMBER_TABLE
376: , a10 JTF_NUMBER_TABLE
377: , a11 JTF_NUMBER_TABLE
378: , a12 JTF_NUMBER_TABLE
379: , a13 JTF_NUMBER_TABLE
380: , a14 JTF_NUMBER_TABLE
381: , a15 JTF_DATE_TABLE
382: , a16 JTF_VARCHAR2_TABLE_300
383: , a17 JTF_VARCHAR2_TABLE_300
376: , a10 JTF_NUMBER_TABLE
377: , a11 JTF_NUMBER_TABLE
378: , a12 JTF_NUMBER_TABLE
379: , a13 JTF_NUMBER_TABLE
380: , a14 JTF_NUMBER_TABLE
381: , a15 JTF_DATE_TABLE
382: , a16 JTF_VARCHAR2_TABLE_300
383: , a17 JTF_VARCHAR2_TABLE_300
384: , a18 JTF_VARCHAR2_TABLE_300
394: , a28 JTF_VARCHAR2_TABLE_300
395: , a29 JTF_VARCHAR2_TABLE_300
396: , a30 JTF_VARCHAR2_TABLE_300
397: , a31 JTF_VARCHAR2_TABLE_300
398: , a32 JTF_NUMBER_TABLE
399: , a33 JTF_DATE_TABLE
400: , a34 JTF_NUMBER_TABLE
401: , a35 JTF_DATE_TABLE
402: , a36 JTF_NUMBER_TABLE
396: , a30 JTF_VARCHAR2_TABLE_300
397: , a31 JTF_VARCHAR2_TABLE_300
398: , a32 JTF_NUMBER_TABLE
399: , a33 JTF_DATE_TABLE
400: , a34 JTF_NUMBER_TABLE
401: , a35 JTF_DATE_TABLE
402: , a36 JTF_NUMBER_TABLE
403: , a37 JTF_VARCHAR2_TABLE_100
404: , a38 JTF_VARCHAR2_TABLE_100
398: , a32 JTF_NUMBER_TABLE
399: , a33 JTF_DATE_TABLE
400: , a34 JTF_NUMBER_TABLE
401: , a35 JTF_DATE_TABLE
402: , a36 JTF_NUMBER_TABLE
403: , a37 JTF_VARCHAR2_TABLE_100
404: , a38 JTF_VARCHAR2_TABLE_100
405: , a39 JTF_VARCHAR2_TABLE_100
406: , a40 JTF_NUMBER_TABLE
402: , a36 JTF_NUMBER_TABLE
403: , a37 JTF_VARCHAR2_TABLE_100
404: , a38 JTF_VARCHAR2_TABLE_100
405: , a39 JTF_VARCHAR2_TABLE_100
406: , a40 JTF_NUMBER_TABLE
407: , a41 JTF_DATE_TABLE
408: ) as
409: ddindx binary_integer; indx binary_integer;
410: begin
463: end loop;
464: end if;
465: end if;
466: end rosetta_table_copy_in_p5;
467: procedure rosetta_table_copy_out_p5(t okl_pfl_pvt.pfl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
468: , a1 out nocopy JTF_NUMBER_TABLE
469: , a2 out nocopy JTF_DATE_TABLE
470: , a3 out nocopy JTF_DATE_TABLE
471: , a4 out nocopy JTF_DATE_TABLE
464: end if;
465: end if;
466: end rosetta_table_copy_in_p5;
467: procedure rosetta_table_copy_out_p5(t okl_pfl_pvt.pfl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
468: , a1 out nocopy JTF_NUMBER_TABLE
469: , a2 out nocopy JTF_DATE_TABLE
470: , a3 out nocopy JTF_DATE_TABLE
471: , a4 out nocopy JTF_DATE_TABLE
472: , a5 out nocopy JTF_VARCHAR2_TABLE_100
470: , a3 out nocopy JTF_DATE_TABLE
471: , a4 out nocopy JTF_DATE_TABLE
472: , a5 out nocopy JTF_VARCHAR2_TABLE_100
473: , a6 out nocopy JTF_VARCHAR2_TABLE_100
474: , a7 out nocopy JTF_NUMBER_TABLE
475: , a8 out nocopy JTF_NUMBER_TABLE
476: , a9 out nocopy JTF_NUMBER_TABLE
477: , a10 out nocopy JTF_NUMBER_TABLE
478: , a11 out nocopy JTF_NUMBER_TABLE
471: , a4 out nocopy JTF_DATE_TABLE
472: , a5 out nocopy JTF_VARCHAR2_TABLE_100
473: , a6 out nocopy JTF_VARCHAR2_TABLE_100
474: , a7 out nocopy JTF_NUMBER_TABLE
475: , a8 out nocopy JTF_NUMBER_TABLE
476: , a9 out nocopy JTF_NUMBER_TABLE
477: , a10 out nocopy JTF_NUMBER_TABLE
478: , a11 out nocopy JTF_NUMBER_TABLE
479: , a12 out nocopy JTF_NUMBER_TABLE
472: , a5 out nocopy JTF_VARCHAR2_TABLE_100
473: , a6 out nocopy JTF_VARCHAR2_TABLE_100
474: , a7 out nocopy JTF_NUMBER_TABLE
475: , a8 out nocopy JTF_NUMBER_TABLE
476: , a9 out nocopy JTF_NUMBER_TABLE
477: , a10 out nocopy JTF_NUMBER_TABLE
478: , a11 out nocopy JTF_NUMBER_TABLE
479: , a12 out nocopy JTF_NUMBER_TABLE
480: , a13 out nocopy JTF_NUMBER_TABLE
473: , a6 out nocopy JTF_VARCHAR2_TABLE_100
474: , a7 out nocopy JTF_NUMBER_TABLE
475: , a8 out nocopy JTF_NUMBER_TABLE
476: , a9 out nocopy JTF_NUMBER_TABLE
477: , a10 out nocopy JTF_NUMBER_TABLE
478: , a11 out nocopy JTF_NUMBER_TABLE
479: , a12 out nocopy JTF_NUMBER_TABLE
480: , a13 out nocopy JTF_NUMBER_TABLE
481: , a14 out nocopy JTF_NUMBER_TABLE
474: , a7 out nocopy JTF_NUMBER_TABLE
475: , a8 out nocopy JTF_NUMBER_TABLE
476: , a9 out nocopy JTF_NUMBER_TABLE
477: , a10 out nocopy JTF_NUMBER_TABLE
478: , a11 out nocopy JTF_NUMBER_TABLE
479: , a12 out nocopy JTF_NUMBER_TABLE
480: , a13 out nocopy JTF_NUMBER_TABLE
481: , a14 out nocopy JTF_NUMBER_TABLE
482: , a15 out nocopy JTF_DATE_TABLE
475: , a8 out nocopy JTF_NUMBER_TABLE
476: , a9 out nocopy JTF_NUMBER_TABLE
477: , a10 out nocopy JTF_NUMBER_TABLE
478: , a11 out nocopy JTF_NUMBER_TABLE
479: , a12 out nocopy JTF_NUMBER_TABLE
480: , a13 out nocopy JTF_NUMBER_TABLE
481: , a14 out nocopy JTF_NUMBER_TABLE
482: , a15 out nocopy JTF_DATE_TABLE
483: , a16 out nocopy JTF_VARCHAR2_TABLE_300
476: , a9 out nocopy JTF_NUMBER_TABLE
477: , a10 out nocopy JTF_NUMBER_TABLE
478: , a11 out nocopy JTF_NUMBER_TABLE
479: , a12 out nocopy JTF_NUMBER_TABLE
480: , a13 out nocopy JTF_NUMBER_TABLE
481: , a14 out nocopy JTF_NUMBER_TABLE
482: , a15 out nocopy JTF_DATE_TABLE
483: , a16 out nocopy JTF_VARCHAR2_TABLE_300
484: , a17 out nocopy JTF_VARCHAR2_TABLE_300
477: , a10 out nocopy JTF_NUMBER_TABLE
478: , a11 out nocopy JTF_NUMBER_TABLE
479: , a12 out nocopy JTF_NUMBER_TABLE
480: , a13 out nocopy JTF_NUMBER_TABLE
481: , a14 out nocopy JTF_NUMBER_TABLE
482: , a15 out nocopy JTF_DATE_TABLE
483: , a16 out nocopy JTF_VARCHAR2_TABLE_300
484: , a17 out nocopy JTF_VARCHAR2_TABLE_300
485: , a18 out nocopy JTF_VARCHAR2_TABLE_300
495: , a28 out nocopy JTF_VARCHAR2_TABLE_300
496: , a29 out nocopy JTF_VARCHAR2_TABLE_300
497: , a30 out nocopy JTF_VARCHAR2_TABLE_300
498: , a31 out nocopy JTF_VARCHAR2_TABLE_300
499: , a32 out nocopy JTF_NUMBER_TABLE
500: , a33 out nocopy JTF_DATE_TABLE
501: , a34 out nocopy JTF_NUMBER_TABLE
502: , a35 out nocopy JTF_DATE_TABLE
503: , a36 out nocopy JTF_NUMBER_TABLE
497: , a30 out nocopy JTF_VARCHAR2_TABLE_300
498: , a31 out nocopy JTF_VARCHAR2_TABLE_300
499: , a32 out nocopy JTF_NUMBER_TABLE
500: , a33 out nocopy JTF_DATE_TABLE
501: , a34 out nocopy JTF_NUMBER_TABLE
502: , a35 out nocopy JTF_DATE_TABLE
503: , a36 out nocopy JTF_NUMBER_TABLE
504: , a37 out nocopy JTF_VARCHAR2_TABLE_100
505: , a38 out nocopy JTF_VARCHAR2_TABLE_100
499: , a32 out nocopy JTF_NUMBER_TABLE
500: , a33 out nocopy JTF_DATE_TABLE
501: , a34 out nocopy JTF_NUMBER_TABLE
502: , a35 out nocopy JTF_DATE_TABLE
503: , a36 out nocopy JTF_NUMBER_TABLE
504: , a37 out nocopy JTF_VARCHAR2_TABLE_100
505: , a38 out nocopy JTF_VARCHAR2_TABLE_100
506: , a39 out nocopy JTF_VARCHAR2_TABLE_100
507: , a40 out nocopy JTF_NUMBER_TABLE
503: , a36 out nocopy JTF_NUMBER_TABLE
504: , a37 out nocopy JTF_VARCHAR2_TABLE_100
505: , a38 out nocopy JTF_VARCHAR2_TABLE_100
506: , a39 out nocopy JTF_VARCHAR2_TABLE_100
507: , a40 out nocopy JTF_NUMBER_TABLE
508: , a41 out nocopy JTF_DATE_TABLE
509: ) as
510: ddindx binary_integer; indx binary_integer;
511: begin
509: ) as
510: ddindx binary_integer; indx binary_integer;
511: begin
512: if t is null or t.count = 0 then
513: a0 := JTF_NUMBER_TABLE();
514: a1 := JTF_NUMBER_TABLE();
515: a2 := JTF_DATE_TABLE();
516: a3 := JTF_DATE_TABLE();
517: a4 := JTF_DATE_TABLE();
510: ddindx binary_integer; indx binary_integer;
511: begin
512: if t is null or t.count = 0 then
513: a0 := JTF_NUMBER_TABLE();
514: a1 := JTF_NUMBER_TABLE();
515: a2 := JTF_DATE_TABLE();
516: a3 := JTF_DATE_TABLE();
517: a4 := JTF_DATE_TABLE();
518: a5 := JTF_VARCHAR2_TABLE_100();
516: a3 := JTF_DATE_TABLE();
517: a4 := JTF_DATE_TABLE();
518: a5 := JTF_VARCHAR2_TABLE_100();
519: a6 := JTF_VARCHAR2_TABLE_100();
520: a7 := JTF_NUMBER_TABLE();
521: a8 := JTF_NUMBER_TABLE();
522: a9 := JTF_NUMBER_TABLE();
523: a10 := JTF_NUMBER_TABLE();
524: a11 := JTF_NUMBER_TABLE();
517: a4 := JTF_DATE_TABLE();
518: a5 := JTF_VARCHAR2_TABLE_100();
519: a6 := JTF_VARCHAR2_TABLE_100();
520: a7 := JTF_NUMBER_TABLE();
521: a8 := JTF_NUMBER_TABLE();
522: a9 := JTF_NUMBER_TABLE();
523: a10 := JTF_NUMBER_TABLE();
524: a11 := JTF_NUMBER_TABLE();
525: a12 := JTF_NUMBER_TABLE();
518: a5 := JTF_VARCHAR2_TABLE_100();
519: a6 := JTF_VARCHAR2_TABLE_100();
520: a7 := JTF_NUMBER_TABLE();
521: a8 := JTF_NUMBER_TABLE();
522: a9 := JTF_NUMBER_TABLE();
523: a10 := JTF_NUMBER_TABLE();
524: a11 := JTF_NUMBER_TABLE();
525: a12 := JTF_NUMBER_TABLE();
526: a13 := JTF_NUMBER_TABLE();
519: a6 := JTF_VARCHAR2_TABLE_100();
520: a7 := JTF_NUMBER_TABLE();
521: a8 := JTF_NUMBER_TABLE();
522: a9 := JTF_NUMBER_TABLE();
523: a10 := JTF_NUMBER_TABLE();
524: a11 := JTF_NUMBER_TABLE();
525: a12 := JTF_NUMBER_TABLE();
526: a13 := JTF_NUMBER_TABLE();
527: a14 := JTF_NUMBER_TABLE();
520: a7 := JTF_NUMBER_TABLE();
521: a8 := JTF_NUMBER_TABLE();
522: a9 := JTF_NUMBER_TABLE();
523: a10 := JTF_NUMBER_TABLE();
524: a11 := JTF_NUMBER_TABLE();
525: a12 := JTF_NUMBER_TABLE();
526: a13 := JTF_NUMBER_TABLE();
527: a14 := JTF_NUMBER_TABLE();
528: a15 := JTF_DATE_TABLE();
521: a8 := JTF_NUMBER_TABLE();
522: a9 := JTF_NUMBER_TABLE();
523: a10 := JTF_NUMBER_TABLE();
524: a11 := JTF_NUMBER_TABLE();
525: a12 := JTF_NUMBER_TABLE();
526: a13 := JTF_NUMBER_TABLE();
527: a14 := JTF_NUMBER_TABLE();
528: a15 := JTF_DATE_TABLE();
529: a16 := JTF_VARCHAR2_TABLE_300();
522: a9 := JTF_NUMBER_TABLE();
523: a10 := JTF_NUMBER_TABLE();
524: a11 := JTF_NUMBER_TABLE();
525: a12 := JTF_NUMBER_TABLE();
526: a13 := JTF_NUMBER_TABLE();
527: a14 := JTF_NUMBER_TABLE();
528: a15 := JTF_DATE_TABLE();
529: a16 := JTF_VARCHAR2_TABLE_300();
530: a17 := JTF_VARCHAR2_TABLE_300();
523: a10 := JTF_NUMBER_TABLE();
524: a11 := JTF_NUMBER_TABLE();
525: a12 := JTF_NUMBER_TABLE();
526: a13 := JTF_NUMBER_TABLE();
527: a14 := JTF_NUMBER_TABLE();
528: a15 := JTF_DATE_TABLE();
529: a16 := JTF_VARCHAR2_TABLE_300();
530: a17 := JTF_VARCHAR2_TABLE_300();
531: a18 := JTF_VARCHAR2_TABLE_300();
541: a28 := JTF_VARCHAR2_TABLE_300();
542: a29 := JTF_VARCHAR2_TABLE_300();
543: a30 := JTF_VARCHAR2_TABLE_300();
544: a31 := JTF_VARCHAR2_TABLE_300();
545: a32 := JTF_NUMBER_TABLE();
546: a33 := JTF_DATE_TABLE();
547: a34 := JTF_NUMBER_TABLE();
548: a35 := JTF_DATE_TABLE();
549: a36 := JTF_NUMBER_TABLE();
543: a30 := JTF_VARCHAR2_TABLE_300();
544: a31 := JTF_VARCHAR2_TABLE_300();
545: a32 := JTF_NUMBER_TABLE();
546: a33 := JTF_DATE_TABLE();
547: a34 := JTF_NUMBER_TABLE();
548: a35 := JTF_DATE_TABLE();
549: a36 := JTF_NUMBER_TABLE();
550: a37 := JTF_VARCHAR2_TABLE_100();
551: a38 := JTF_VARCHAR2_TABLE_100();
545: a32 := JTF_NUMBER_TABLE();
546: a33 := JTF_DATE_TABLE();
547: a34 := JTF_NUMBER_TABLE();
548: a35 := JTF_DATE_TABLE();
549: a36 := JTF_NUMBER_TABLE();
550: a37 := JTF_VARCHAR2_TABLE_100();
551: a38 := JTF_VARCHAR2_TABLE_100();
552: a39 := JTF_VARCHAR2_TABLE_100();
553: a40 := JTF_NUMBER_TABLE();
549: a36 := JTF_NUMBER_TABLE();
550: a37 := JTF_VARCHAR2_TABLE_100();
551: a38 := JTF_VARCHAR2_TABLE_100();
552: a39 := JTF_VARCHAR2_TABLE_100();
553: a40 := JTF_NUMBER_TABLE();
554: a41 := JTF_DATE_TABLE();
555: else
556: a0 := JTF_NUMBER_TABLE();
557: a1 := JTF_NUMBER_TABLE();
552: a39 := JTF_VARCHAR2_TABLE_100();
553: a40 := JTF_NUMBER_TABLE();
554: a41 := JTF_DATE_TABLE();
555: else
556: a0 := JTF_NUMBER_TABLE();
557: a1 := JTF_NUMBER_TABLE();
558: a2 := JTF_DATE_TABLE();
559: a3 := JTF_DATE_TABLE();
560: a4 := JTF_DATE_TABLE();
553: a40 := JTF_NUMBER_TABLE();
554: a41 := JTF_DATE_TABLE();
555: else
556: a0 := JTF_NUMBER_TABLE();
557: a1 := JTF_NUMBER_TABLE();
558: a2 := JTF_DATE_TABLE();
559: a3 := JTF_DATE_TABLE();
560: a4 := JTF_DATE_TABLE();
561: a5 := JTF_VARCHAR2_TABLE_100();
559: a3 := JTF_DATE_TABLE();
560: a4 := JTF_DATE_TABLE();
561: a5 := JTF_VARCHAR2_TABLE_100();
562: a6 := JTF_VARCHAR2_TABLE_100();
563: a7 := JTF_NUMBER_TABLE();
564: a8 := JTF_NUMBER_TABLE();
565: a9 := JTF_NUMBER_TABLE();
566: a10 := JTF_NUMBER_TABLE();
567: a11 := JTF_NUMBER_TABLE();
560: a4 := JTF_DATE_TABLE();
561: a5 := JTF_VARCHAR2_TABLE_100();
562: a6 := JTF_VARCHAR2_TABLE_100();
563: a7 := JTF_NUMBER_TABLE();
564: a8 := JTF_NUMBER_TABLE();
565: a9 := JTF_NUMBER_TABLE();
566: a10 := JTF_NUMBER_TABLE();
567: a11 := JTF_NUMBER_TABLE();
568: a12 := JTF_NUMBER_TABLE();
561: a5 := JTF_VARCHAR2_TABLE_100();
562: a6 := JTF_VARCHAR2_TABLE_100();
563: a7 := JTF_NUMBER_TABLE();
564: a8 := JTF_NUMBER_TABLE();
565: a9 := JTF_NUMBER_TABLE();
566: a10 := JTF_NUMBER_TABLE();
567: a11 := JTF_NUMBER_TABLE();
568: a12 := JTF_NUMBER_TABLE();
569: a13 := JTF_NUMBER_TABLE();
562: a6 := JTF_VARCHAR2_TABLE_100();
563: a7 := JTF_NUMBER_TABLE();
564: a8 := JTF_NUMBER_TABLE();
565: a9 := JTF_NUMBER_TABLE();
566: a10 := JTF_NUMBER_TABLE();
567: a11 := JTF_NUMBER_TABLE();
568: a12 := JTF_NUMBER_TABLE();
569: a13 := JTF_NUMBER_TABLE();
570: a14 := JTF_NUMBER_TABLE();
563: a7 := JTF_NUMBER_TABLE();
564: a8 := JTF_NUMBER_TABLE();
565: a9 := JTF_NUMBER_TABLE();
566: a10 := JTF_NUMBER_TABLE();
567: a11 := JTF_NUMBER_TABLE();
568: a12 := JTF_NUMBER_TABLE();
569: a13 := JTF_NUMBER_TABLE();
570: a14 := JTF_NUMBER_TABLE();
571: a15 := JTF_DATE_TABLE();
564: a8 := JTF_NUMBER_TABLE();
565: a9 := JTF_NUMBER_TABLE();
566: a10 := JTF_NUMBER_TABLE();
567: a11 := JTF_NUMBER_TABLE();
568: a12 := JTF_NUMBER_TABLE();
569: a13 := JTF_NUMBER_TABLE();
570: a14 := JTF_NUMBER_TABLE();
571: a15 := JTF_DATE_TABLE();
572: a16 := JTF_VARCHAR2_TABLE_300();
565: a9 := JTF_NUMBER_TABLE();
566: a10 := JTF_NUMBER_TABLE();
567: a11 := JTF_NUMBER_TABLE();
568: a12 := JTF_NUMBER_TABLE();
569: a13 := JTF_NUMBER_TABLE();
570: a14 := JTF_NUMBER_TABLE();
571: a15 := JTF_DATE_TABLE();
572: a16 := JTF_VARCHAR2_TABLE_300();
573: a17 := JTF_VARCHAR2_TABLE_300();
566: a10 := JTF_NUMBER_TABLE();
567: a11 := JTF_NUMBER_TABLE();
568: a12 := JTF_NUMBER_TABLE();
569: a13 := JTF_NUMBER_TABLE();
570: a14 := JTF_NUMBER_TABLE();
571: a15 := JTF_DATE_TABLE();
572: a16 := JTF_VARCHAR2_TABLE_300();
573: a17 := JTF_VARCHAR2_TABLE_300();
574: a18 := JTF_VARCHAR2_TABLE_300();
584: a28 := JTF_VARCHAR2_TABLE_300();
585: a29 := JTF_VARCHAR2_TABLE_300();
586: a30 := JTF_VARCHAR2_TABLE_300();
587: a31 := JTF_VARCHAR2_TABLE_300();
588: a32 := JTF_NUMBER_TABLE();
589: a33 := JTF_DATE_TABLE();
590: a34 := JTF_NUMBER_TABLE();
591: a35 := JTF_DATE_TABLE();
592: a36 := JTF_NUMBER_TABLE();
586: a30 := JTF_VARCHAR2_TABLE_300();
587: a31 := JTF_VARCHAR2_TABLE_300();
588: a32 := JTF_NUMBER_TABLE();
589: a33 := JTF_DATE_TABLE();
590: a34 := JTF_NUMBER_TABLE();
591: a35 := JTF_DATE_TABLE();
592: a36 := JTF_NUMBER_TABLE();
593: a37 := JTF_VARCHAR2_TABLE_100();
594: a38 := JTF_VARCHAR2_TABLE_100();
588: a32 := JTF_NUMBER_TABLE();
589: a33 := JTF_DATE_TABLE();
590: a34 := JTF_NUMBER_TABLE();
591: a35 := JTF_DATE_TABLE();
592: a36 := JTF_NUMBER_TABLE();
593: a37 := JTF_VARCHAR2_TABLE_100();
594: a38 := JTF_VARCHAR2_TABLE_100();
595: a39 := JTF_VARCHAR2_TABLE_100();
596: a40 := JTF_NUMBER_TABLE();
592: a36 := JTF_NUMBER_TABLE();
593: a37 := JTF_VARCHAR2_TABLE_100();
594: a38 := JTF_VARCHAR2_TABLE_100();
595: a39 := JTF_VARCHAR2_TABLE_100();
596: a40 := JTF_NUMBER_TABLE();
597: a41 := JTF_DATE_TABLE();
598: if t.count > 0 then
599: a0.extend(t.count);
600: a1.extend(t.count);
692: end if;
693: end if;
694: end rosetta_table_copy_out_p5;
695:
696: procedure rosetta_table_copy_in_p8(t out nocopy okl_pfl_pvt.okl_prtfl_lines_tl_tbl_type, a0 JTF_NUMBER_TABLE
697: , a1 JTF_VARCHAR2_TABLE_300
698: , a2 JTF_VARCHAR2_TABLE_300
699: , a3 JTF_VARCHAR2_TABLE_300
700: , a4 JTF_VARCHAR2_TABLE_2000
697: , a1 JTF_VARCHAR2_TABLE_300
698: , a2 JTF_VARCHAR2_TABLE_300
699: , a3 JTF_VARCHAR2_TABLE_300
700: , a4 JTF_VARCHAR2_TABLE_2000
701: , a5 JTF_NUMBER_TABLE
702: , a6 JTF_DATE_TABLE
703: , a7 JTF_NUMBER_TABLE
704: , a8 JTF_DATE_TABLE
705: , a9 JTF_NUMBER_TABLE
699: , a3 JTF_VARCHAR2_TABLE_300
700: , a4 JTF_VARCHAR2_TABLE_2000
701: , a5 JTF_NUMBER_TABLE
702: , a6 JTF_DATE_TABLE
703: , a7 JTF_NUMBER_TABLE
704: , a8 JTF_DATE_TABLE
705: , a9 JTF_NUMBER_TABLE
706: ) as
707: ddindx binary_integer; indx binary_integer;
701: , a5 JTF_NUMBER_TABLE
702: , a6 JTF_DATE_TABLE
703: , a7 JTF_NUMBER_TABLE
704: , a8 JTF_DATE_TABLE
705: , a9 JTF_NUMBER_TABLE
706: ) as
707: ddindx binary_integer; indx binary_integer;
708: begin
709: if a0 is not null and a0.count > 0 then
729: end loop;
730: end if;
731: end if;
732: end rosetta_table_copy_in_p8;
733: procedure rosetta_table_copy_out_p8(t okl_pfl_pvt.okl_prtfl_lines_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
734: , a1 out nocopy JTF_VARCHAR2_TABLE_300
735: , a2 out nocopy JTF_VARCHAR2_TABLE_300
736: , a3 out nocopy JTF_VARCHAR2_TABLE_300
737: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
734: , a1 out nocopy JTF_VARCHAR2_TABLE_300
735: , a2 out nocopy JTF_VARCHAR2_TABLE_300
736: , a3 out nocopy JTF_VARCHAR2_TABLE_300
737: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
738: , a5 out nocopy JTF_NUMBER_TABLE
739: , a6 out nocopy JTF_DATE_TABLE
740: , a7 out nocopy JTF_NUMBER_TABLE
741: , a8 out nocopy JTF_DATE_TABLE
742: , a9 out nocopy JTF_NUMBER_TABLE
736: , a3 out nocopy JTF_VARCHAR2_TABLE_300
737: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
738: , a5 out nocopy JTF_NUMBER_TABLE
739: , a6 out nocopy JTF_DATE_TABLE
740: , a7 out nocopy JTF_NUMBER_TABLE
741: , a8 out nocopy JTF_DATE_TABLE
742: , a9 out nocopy JTF_NUMBER_TABLE
743: ) as
744: ddindx binary_integer; indx binary_integer;
738: , a5 out nocopy JTF_NUMBER_TABLE
739: , a6 out nocopy JTF_DATE_TABLE
740: , a7 out nocopy JTF_NUMBER_TABLE
741: , a8 out nocopy JTF_DATE_TABLE
742: , a9 out nocopy JTF_NUMBER_TABLE
743: ) as
744: ddindx binary_integer; indx binary_integer;
745: begin
746: if t is null or t.count = 0 then
743: ) as
744: ddindx binary_integer; indx binary_integer;
745: begin
746: if t is null or t.count = 0 then
747: a0 := JTF_NUMBER_TABLE();
748: a1 := JTF_VARCHAR2_TABLE_300();
749: a2 := JTF_VARCHAR2_TABLE_300();
750: a3 := JTF_VARCHAR2_TABLE_300();
751: a4 := JTF_VARCHAR2_TABLE_2000();
748: a1 := JTF_VARCHAR2_TABLE_300();
749: a2 := JTF_VARCHAR2_TABLE_300();
750: a3 := JTF_VARCHAR2_TABLE_300();
751: a4 := JTF_VARCHAR2_TABLE_2000();
752: a5 := JTF_NUMBER_TABLE();
753: a6 := JTF_DATE_TABLE();
754: a7 := JTF_NUMBER_TABLE();
755: a8 := JTF_DATE_TABLE();
756: a9 := JTF_NUMBER_TABLE();
750: a3 := JTF_VARCHAR2_TABLE_300();
751: a4 := JTF_VARCHAR2_TABLE_2000();
752: a5 := JTF_NUMBER_TABLE();
753: a6 := JTF_DATE_TABLE();
754: a7 := JTF_NUMBER_TABLE();
755: a8 := JTF_DATE_TABLE();
756: a9 := JTF_NUMBER_TABLE();
757: else
758: a0 := JTF_NUMBER_TABLE();
752: a5 := JTF_NUMBER_TABLE();
753: a6 := JTF_DATE_TABLE();
754: a7 := JTF_NUMBER_TABLE();
755: a8 := JTF_DATE_TABLE();
756: a9 := JTF_NUMBER_TABLE();
757: else
758: a0 := JTF_NUMBER_TABLE();
759: a1 := JTF_VARCHAR2_TABLE_300();
760: a2 := JTF_VARCHAR2_TABLE_300();
754: a7 := JTF_NUMBER_TABLE();
755: a8 := JTF_DATE_TABLE();
756: a9 := JTF_NUMBER_TABLE();
757: else
758: a0 := JTF_NUMBER_TABLE();
759: a1 := JTF_VARCHAR2_TABLE_300();
760: a2 := JTF_VARCHAR2_TABLE_300();
761: a3 := JTF_VARCHAR2_TABLE_300();
762: a4 := JTF_VARCHAR2_TABLE_2000();
759: a1 := JTF_VARCHAR2_TABLE_300();
760: a2 := JTF_VARCHAR2_TABLE_300();
761: a3 := JTF_VARCHAR2_TABLE_300();
762: a4 := JTF_VARCHAR2_TABLE_2000();
763: a5 := JTF_NUMBER_TABLE();
764: a6 := JTF_DATE_TABLE();
765: a7 := JTF_NUMBER_TABLE();
766: a8 := JTF_DATE_TABLE();
767: a9 := JTF_NUMBER_TABLE();
761: a3 := JTF_VARCHAR2_TABLE_300();
762: a4 := JTF_VARCHAR2_TABLE_2000();
763: a5 := JTF_NUMBER_TABLE();
764: a6 := JTF_DATE_TABLE();
765: a7 := JTF_NUMBER_TABLE();
766: a8 := JTF_DATE_TABLE();
767: a9 := JTF_NUMBER_TABLE();
768: if t.count > 0 then
769: a0.extend(t.count);
763: a5 := JTF_NUMBER_TABLE();
764: a6 := JTF_DATE_TABLE();
765: a7 := JTF_NUMBER_TABLE();
766: a8 := JTF_DATE_TABLE();
767: a9 := JTF_NUMBER_TABLE();
768: if t.count > 0 then
769: a0.extend(t.count);
770: a1.extend(t.count);
771: a2.extend(t.count);
1018: , p_init_msg_list VARCHAR2
1019: , x_return_status out nocopy VARCHAR2
1020: , x_msg_count out nocopy NUMBER
1021: , x_msg_data out nocopy VARCHAR2
1022: , p5_a0 JTF_NUMBER_TABLE
1023: , p5_a1 JTF_VARCHAR2_TABLE_300
1024: , p5_a2 JTF_NUMBER_TABLE
1025: , p5_a3 JTF_DATE_TABLE
1026: , p5_a4 JTF_DATE_TABLE
1020: , x_msg_count out nocopy NUMBER
1021: , x_msg_data out nocopy VARCHAR2
1022: , p5_a0 JTF_NUMBER_TABLE
1023: , p5_a1 JTF_VARCHAR2_TABLE_300
1024: , p5_a2 JTF_NUMBER_TABLE
1025: , p5_a3 JTF_DATE_TABLE
1026: , p5_a4 JTF_DATE_TABLE
1027: , p5_a5 JTF_DATE_TABLE
1028: , p5_a6 JTF_VARCHAR2_TABLE_100
1026: , p5_a4 JTF_DATE_TABLE
1027: , p5_a5 JTF_DATE_TABLE
1028: , p5_a6 JTF_VARCHAR2_TABLE_100
1029: , p5_a7 JTF_VARCHAR2_TABLE_100
1030: , p5_a8 JTF_NUMBER_TABLE
1031: , p5_a9 JTF_NUMBER_TABLE
1032: , p5_a10 JTF_NUMBER_TABLE
1033: , p5_a11 JTF_NUMBER_TABLE
1034: , p5_a12 JTF_VARCHAR2_TABLE_2000
1027: , p5_a5 JTF_DATE_TABLE
1028: , p5_a6 JTF_VARCHAR2_TABLE_100
1029: , p5_a7 JTF_VARCHAR2_TABLE_100
1030: , p5_a8 JTF_NUMBER_TABLE
1031: , p5_a9 JTF_NUMBER_TABLE
1032: , p5_a10 JTF_NUMBER_TABLE
1033: , p5_a11 JTF_NUMBER_TABLE
1034: , p5_a12 JTF_VARCHAR2_TABLE_2000
1035: , p5_a13 JTF_NUMBER_TABLE
1028: , p5_a6 JTF_VARCHAR2_TABLE_100
1029: , p5_a7 JTF_VARCHAR2_TABLE_100
1030: , p5_a8 JTF_NUMBER_TABLE
1031: , p5_a9 JTF_NUMBER_TABLE
1032: , p5_a10 JTF_NUMBER_TABLE
1033: , p5_a11 JTF_NUMBER_TABLE
1034: , p5_a12 JTF_VARCHAR2_TABLE_2000
1035: , p5_a13 JTF_NUMBER_TABLE
1036: , p5_a14 JTF_NUMBER_TABLE
1029: , p5_a7 JTF_VARCHAR2_TABLE_100
1030: , p5_a8 JTF_NUMBER_TABLE
1031: , p5_a9 JTF_NUMBER_TABLE
1032: , p5_a10 JTF_NUMBER_TABLE
1033: , p5_a11 JTF_NUMBER_TABLE
1034: , p5_a12 JTF_VARCHAR2_TABLE_2000
1035: , p5_a13 JTF_NUMBER_TABLE
1036: , p5_a14 JTF_NUMBER_TABLE
1037: , p5_a15 JTF_NUMBER_TABLE
1031: , p5_a9 JTF_NUMBER_TABLE
1032: , p5_a10 JTF_NUMBER_TABLE
1033: , p5_a11 JTF_NUMBER_TABLE
1034: , p5_a12 JTF_VARCHAR2_TABLE_2000
1035: , p5_a13 JTF_NUMBER_TABLE
1036: , p5_a14 JTF_NUMBER_TABLE
1037: , p5_a15 JTF_NUMBER_TABLE
1038: , p5_a16 JTF_NUMBER_TABLE
1039: , p5_a17 JTF_DATE_TABLE
1032: , p5_a10 JTF_NUMBER_TABLE
1033: , p5_a11 JTF_NUMBER_TABLE
1034: , p5_a12 JTF_VARCHAR2_TABLE_2000
1035: , p5_a13 JTF_NUMBER_TABLE
1036: , p5_a14 JTF_NUMBER_TABLE
1037: , p5_a15 JTF_NUMBER_TABLE
1038: , p5_a16 JTF_NUMBER_TABLE
1039: , p5_a17 JTF_DATE_TABLE
1040: , p5_a18 JTF_VARCHAR2_TABLE_300
1033: , p5_a11 JTF_NUMBER_TABLE
1034: , p5_a12 JTF_VARCHAR2_TABLE_2000
1035: , p5_a13 JTF_NUMBER_TABLE
1036: , p5_a14 JTF_NUMBER_TABLE
1037: , p5_a15 JTF_NUMBER_TABLE
1038: , p5_a16 JTF_NUMBER_TABLE
1039: , p5_a17 JTF_DATE_TABLE
1040: , p5_a18 JTF_VARCHAR2_TABLE_300
1041: , p5_a19 JTF_VARCHAR2_TABLE_300
1034: , p5_a12 JTF_VARCHAR2_TABLE_2000
1035: , p5_a13 JTF_NUMBER_TABLE
1036: , p5_a14 JTF_NUMBER_TABLE
1037: , p5_a15 JTF_NUMBER_TABLE
1038: , p5_a16 JTF_NUMBER_TABLE
1039: , p5_a17 JTF_DATE_TABLE
1040: , p5_a18 JTF_VARCHAR2_TABLE_300
1041: , p5_a19 JTF_VARCHAR2_TABLE_300
1042: , p5_a20 JTF_VARCHAR2_TABLE_300
1052: , p5_a30 JTF_VARCHAR2_TABLE_300
1053: , p5_a31 JTF_VARCHAR2_TABLE_300
1054: , p5_a32 JTF_VARCHAR2_TABLE_300
1055: , p5_a33 JTF_VARCHAR2_TABLE_300
1056: , p5_a34 JTF_NUMBER_TABLE
1057: , p5_a35 JTF_DATE_TABLE
1058: , p5_a36 JTF_NUMBER_TABLE
1059: , p5_a37 JTF_DATE_TABLE
1060: , p5_a38 JTF_NUMBER_TABLE
1054: , p5_a32 JTF_VARCHAR2_TABLE_300
1055: , p5_a33 JTF_VARCHAR2_TABLE_300
1056: , p5_a34 JTF_NUMBER_TABLE
1057: , p5_a35 JTF_DATE_TABLE
1058: , p5_a36 JTF_NUMBER_TABLE
1059: , p5_a37 JTF_DATE_TABLE
1060: , p5_a38 JTF_NUMBER_TABLE
1061: , p5_a39 JTF_VARCHAR2_TABLE_100
1062: , p5_a40 JTF_VARCHAR2_TABLE_100
1056: , p5_a34 JTF_NUMBER_TABLE
1057: , p5_a35 JTF_DATE_TABLE
1058: , p5_a36 JTF_NUMBER_TABLE
1059: , p5_a37 JTF_DATE_TABLE
1060: , p5_a38 JTF_NUMBER_TABLE
1061: , p5_a39 JTF_VARCHAR2_TABLE_100
1062: , p5_a40 JTF_VARCHAR2_TABLE_100
1063: , p5_a41 JTF_VARCHAR2_TABLE_100
1064: , p5_a42 JTF_NUMBER_TABLE
1060: , p5_a38 JTF_NUMBER_TABLE
1061: , p5_a39 JTF_VARCHAR2_TABLE_100
1062: , p5_a40 JTF_VARCHAR2_TABLE_100
1063: , p5_a41 JTF_VARCHAR2_TABLE_100
1064: , p5_a42 JTF_NUMBER_TABLE
1065: , p5_a43 JTF_DATE_TABLE
1066: , p6_a0 out nocopy JTF_NUMBER_TABLE
1067: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300
1068: , p6_a2 out nocopy JTF_NUMBER_TABLE
1062: , p5_a40 JTF_VARCHAR2_TABLE_100
1063: , p5_a41 JTF_VARCHAR2_TABLE_100
1064: , p5_a42 JTF_NUMBER_TABLE
1065: , p5_a43 JTF_DATE_TABLE
1066: , p6_a0 out nocopy JTF_NUMBER_TABLE
1067: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300
1068: , p6_a2 out nocopy JTF_NUMBER_TABLE
1069: , p6_a3 out nocopy JTF_DATE_TABLE
1070: , p6_a4 out nocopy JTF_DATE_TABLE
1064: , p5_a42 JTF_NUMBER_TABLE
1065: , p5_a43 JTF_DATE_TABLE
1066: , p6_a0 out nocopy JTF_NUMBER_TABLE
1067: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300
1068: , p6_a2 out nocopy JTF_NUMBER_TABLE
1069: , p6_a3 out nocopy JTF_DATE_TABLE
1070: , p6_a4 out nocopy JTF_DATE_TABLE
1071: , p6_a5 out nocopy JTF_DATE_TABLE
1072: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1070: , p6_a4 out nocopy JTF_DATE_TABLE
1071: , p6_a5 out nocopy JTF_DATE_TABLE
1072: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1073: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
1074: , p6_a8 out nocopy JTF_NUMBER_TABLE
1075: , p6_a9 out nocopy JTF_NUMBER_TABLE
1076: , p6_a10 out nocopy JTF_NUMBER_TABLE
1077: , p6_a11 out nocopy JTF_NUMBER_TABLE
1078: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_2000
1071: , p6_a5 out nocopy JTF_DATE_TABLE
1072: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1073: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
1074: , p6_a8 out nocopy JTF_NUMBER_TABLE
1075: , p6_a9 out nocopy JTF_NUMBER_TABLE
1076: , p6_a10 out nocopy JTF_NUMBER_TABLE
1077: , p6_a11 out nocopy JTF_NUMBER_TABLE
1078: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_2000
1079: , p6_a13 out nocopy JTF_NUMBER_TABLE
1072: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1073: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
1074: , p6_a8 out nocopy JTF_NUMBER_TABLE
1075: , p6_a9 out nocopy JTF_NUMBER_TABLE
1076: , p6_a10 out nocopy JTF_NUMBER_TABLE
1077: , p6_a11 out nocopy JTF_NUMBER_TABLE
1078: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_2000
1079: , p6_a13 out nocopy JTF_NUMBER_TABLE
1080: , p6_a14 out nocopy JTF_NUMBER_TABLE
1073: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
1074: , p6_a8 out nocopy JTF_NUMBER_TABLE
1075: , p6_a9 out nocopy JTF_NUMBER_TABLE
1076: , p6_a10 out nocopy JTF_NUMBER_TABLE
1077: , p6_a11 out nocopy JTF_NUMBER_TABLE
1078: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_2000
1079: , p6_a13 out nocopy JTF_NUMBER_TABLE
1080: , p6_a14 out nocopy JTF_NUMBER_TABLE
1081: , p6_a15 out nocopy JTF_NUMBER_TABLE
1075: , p6_a9 out nocopy JTF_NUMBER_TABLE
1076: , p6_a10 out nocopy JTF_NUMBER_TABLE
1077: , p6_a11 out nocopy JTF_NUMBER_TABLE
1078: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_2000
1079: , p6_a13 out nocopy JTF_NUMBER_TABLE
1080: , p6_a14 out nocopy JTF_NUMBER_TABLE
1081: , p6_a15 out nocopy JTF_NUMBER_TABLE
1082: , p6_a16 out nocopy JTF_NUMBER_TABLE
1083: , p6_a17 out nocopy JTF_DATE_TABLE
1076: , p6_a10 out nocopy JTF_NUMBER_TABLE
1077: , p6_a11 out nocopy JTF_NUMBER_TABLE
1078: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_2000
1079: , p6_a13 out nocopy JTF_NUMBER_TABLE
1080: , p6_a14 out nocopy JTF_NUMBER_TABLE
1081: , p6_a15 out nocopy JTF_NUMBER_TABLE
1082: , p6_a16 out nocopy JTF_NUMBER_TABLE
1083: , p6_a17 out nocopy JTF_DATE_TABLE
1084: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_300
1077: , p6_a11 out nocopy JTF_NUMBER_TABLE
1078: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_2000
1079: , p6_a13 out nocopy JTF_NUMBER_TABLE
1080: , p6_a14 out nocopy JTF_NUMBER_TABLE
1081: , p6_a15 out nocopy JTF_NUMBER_TABLE
1082: , p6_a16 out nocopy JTF_NUMBER_TABLE
1083: , p6_a17 out nocopy JTF_DATE_TABLE
1084: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_300
1085: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_300
1078: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_2000
1079: , p6_a13 out nocopy JTF_NUMBER_TABLE
1080: , p6_a14 out nocopy JTF_NUMBER_TABLE
1081: , p6_a15 out nocopy JTF_NUMBER_TABLE
1082: , p6_a16 out nocopy JTF_NUMBER_TABLE
1083: , p6_a17 out nocopy JTF_DATE_TABLE
1084: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_300
1085: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_300
1086: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_300
1096: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_300
1097: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_300
1098: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_300
1099: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_300
1100: , p6_a34 out nocopy JTF_NUMBER_TABLE
1101: , p6_a35 out nocopy JTF_DATE_TABLE
1102: , p6_a36 out nocopy JTF_NUMBER_TABLE
1103: , p6_a37 out nocopy JTF_DATE_TABLE
1104: , p6_a38 out nocopy JTF_NUMBER_TABLE
1098: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_300
1099: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_300
1100: , p6_a34 out nocopy JTF_NUMBER_TABLE
1101: , p6_a35 out nocopy JTF_DATE_TABLE
1102: , p6_a36 out nocopy JTF_NUMBER_TABLE
1103: , p6_a37 out nocopy JTF_DATE_TABLE
1104: , p6_a38 out nocopy JTF_NUMBER_TABLE
1105: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
1106: , p6_a40 out nocopy JTF_VARCHAR2_TABLE_100
1100: , p6_a34 out nocopy JTF_NUMBER_TABLE
1101: , p6_a35 out nocopy JTF_DATE_TABLE
1102: , p6_a36 out nocopy JTF_NUMBER_TABLE
1103: , p6_a37 out nocopy JTF_DATE_TABLE
1104: , p6_a38 out nocopy JTF_NUMBER_TABLE
1105: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
1106: , p6_a40 out nocopy JTF_VARCHAR2_TABLE_100
1107: , p6_a41 out nocopy JTF_VARCHAR2_TABLE_100
1108: , p6_a42 out nocopy JTF_NUMBER_TABLE
1104: , p6_a38 out nocopy JTF_NUMBER_TABLE
1105: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
1106: , p6_a40 out nocopy JTF_VARCHAR2_TABLE_100
1107: , p6_a41 out nocopy JTF_VARCHAR2_TABLE_100
1108: , p6_a42 out nocopy JTF_NUMBER_TABLE
1109: , p6_a43 out nocopy JTF_DATE_TABLE
1110: )
1111:
1112: as
1358: , p_init_msg_list VARCHAR2
1359: , x_return_status out nocopy VARCHAR2
1360: , x_msg_count out nocopy NUMBER
1361: , x_msg_data out nocopy VARCHAR2
1362: , p5_a0 JTF_NUMBER_TABLE
1363: , p5_a1 JTF_VARCHAR2_TABLE_300
1364: , p5_a2 JTF_NUMBER_TABLE
1365: , p5_a3 JTF_DATE_TABLE
1366: , p5_a4 JTF_DATE_TABLE
1360: , x_msg_count out nocopy NUMBER
1361: , x_msg_data out nocopy VARCHAR2
1362: , p5_a0 JTF_NUMBER_TABLE
1363: , p5_a1 JTF_VARCHAR2_TABLE_300
1364: , p5_a2 JTF_NUMBER_TABLE
1365: , p5_a3 JTF_DATE_TABLE
1366: , p5_a4 JTF_DATE_TABLE
1367: , p5_a5 JTF_DATE_TABLE
1368: , p5_a6 JTF_VARCHAR2_TABLE_100
1366: , p5_a4 JTF_DATE_TABLE
1367: , p5_a5 JTF_DATE_TABLE
1368: , p5_a6 JTF_VARCHAR2_TABLE_100
1369: , p5_a7 JTF_VARCHAR2_TABLE_100
1370: , p5_a8 JTF_NUMBER_TABLE
1371: , p5_a9 JTF_NUMBER_TABLE
1372: , p5_a10 JTF_NUMBER_TABLE
1373: , p5_a11 JTF_NUMBER_TABLE
1374: , p5_a12 JTF_VARCHAR2_TABLE_2000
1367: , p5_a5 JTF_DATE_TABLE
1368: , p5_a6 JTF_VARCHAR2_TABLE_100
1369: , p5_a7 JTF_VARCHAR2_TABLE_100
1370: , p5_a8 JTF_NUMBER_TABLE
1371: , p5_a9 JTF_NUMBER_TABLE
1372: , p5_a10 JTF_NUMBER_TABLE
1373: , p5_a11 JTF_NUMBER_TABLE
1374: , p5_a12 JTF_VARCHAR2_TABLE_2000
1375: , p5_a13 JTF_NUMBER_TABLE
1368: , p5_a6 JTF_VARCHAR2_TABLE_100
1369: , p5_a7 JTF_VARCHAR2_TABLE_100
1370: , p5_a8 JTF_NUMBER_TABLE
1371: , p5_a9 JTF_NUMBER_TABLE
1372: , p5_a10 JTF_NUMBER_TABLE
1373: , p5_a11 JTF_NUMBER_TABLE
1374: , p5_a12 JTF_VARCHAR2_TABLE_2000
1375: , p5_a13 JTF_NUMBER_TABLE
1376: , p5_a14 JTF_NUMBER_TABLE
1369: , p5_a7 JTF_VARCHAR2_TABLE_100
1370: , p5_a8 JTF_NUMBER_TABLE
1371: , p5_a9 JTF_NUMBER_TABLE
1372: , p5_a10 JTF_NUMBER_TABLE
1373: , p5_a11 JTF_NUMBER_TABLE
1374: , p5_a12 JTF_VARCHAR2_TABLE_2000
1375: , p5_a13 JTF_NUMBER_TABLE
1376: , p5_a14 JTF_NUMBER_TABLE
1377: , p5_a15 JTF_NUMBER_TABLE
1371: , p5_a9 JTF_NUMBER_TABLE
1372: , p5_a10 JTF_NUMBER_TABLE
1373: , p5_a11 JTF_NUMBER_TABLE
1374: , p5_a12 JTF_VARCHAR2_TABLE_2000
1375: , p5_a13 JTF_NUMBER_TABLE
1376: , p5_a14 JTF_NUMBER_TABLE
1377: , p5_a15 JTF_NUMBER_TABLE
1378: , p5_a16 JTF_NUMBER_TABLE
1379: , p5_a17 JTF_DATE_TABLE
1372: , p5_a10 JTF_NUMBER_TABLE
1373: , p5_a11 JTF_NUMBER_TABLE
1374: , p5_a12 JTF_VARCHAR2_TABLE_2000
1375: , p5_a13 JTF_NUMBER_TABLE
1376: , p5_a14 JTF_NUMBER_TABLE
1377: , p5_a15 JTF_NUMBER_TABLE
1378: , p5_a16 JTF_NUMBER_TABLE
1379: , p5_a17 JTF_DATE_TABLE
1380: , p5_a18 JTF_VARCHAR2_TABLE_300
1373: , p5_a11 JTF_NUMBER_TABLE
1374: , p5_a12 JTF_VARCHAR2_TABLE_2000
1375: , p5_a13 JTF_NUMBER_TABLE
1376: , p5_a14 JTF_NUMBER_TABLE
1377: , p5_a15 JTF_NUMBER_TABLE
1378: , p5_a16 JTF_NUMBER_TABLE
1379: , p5_a17 JTF_DATE_TABLE
1380: , p5_a18 JTF_VARCHAR2_TABLE_300
1381: , p5_a19 JTF_VARCHAR2_TABLE_300
1374: , p5_a12 JTF_VARCHAR2_TABLE_2000
1375: , p5_a13 JTF_NUMBER_TABLE
1376: , p5_a14 JTF_NUMBER_TABLE
1377: , p5_a15 JTF_NUMBER_TABLE
1378: , p5_a16 JTF_NUMBER_TABLE
1379: , p5_a17 JTF_DATE_TABLE
1380: , p5_a18 JTF_VARCHAR2_TABLE_300
1381: , p5_a19 JTF_VARCHAR2_TABLE_300
1382: , p5_a20 JTF_VARCHAR2_TABLE_300
1392: , p5_a30 JTF_VARCHAR2_TABLE_300
1393: , p5_a31 JTF_VARCHAR2_TABLE_300
1394: , p5_a32 JTF_VARCHAR2_TABLE_300
1395: , p5_a33 JTF_VARCHAR2_TABLE_300
1396: , p5_a34 JTF_NUMBER_TABLE
1397: , p5_a35 JTF_DATE_TABLE
1398: , p5_a36 JTF_NUMBER_TABLE
1399: , p5_a37 JTF_DATE_TABLE
1400: , p5_a38 JTF_NUMBER_TABLE
1394: , p5_a32 JTF_VARCHAR2_TABLE_300
1395: , p5_a33 JTF_VARCHAR2_TABLE_300
1396: , p5_a34 JTF_NUMBER_TABLE
1397: , p5_a35 JTF_DATE_TABLE
1398: , p5_a36 JTF_NUMBER_TABLE
1399: , p5_a37 JTF_DATE_TABLE
1400: , p5_a38 JTF_NUMBER_TABLE
1401: , p5_a39 JTF_VARCHAR2_TABLE_100
1402: , p5_a40 JTF_VARCHAR2_TABLE_100
1396: , p5_a34 JTF_NUMBER_TABLE
1397: , p5_a35 JTF_DATE_TABLE
1398: , p5_a36 JTF_NUMBER_TABLE
1399: , p5_a37 JTF_DATE_TABLE
1400: , p5_a38 JTF_NUMBER_TABLE
1401: , p5_a39 JTF_VARCHAR2_TABLE_100
1402: , p5_a40 JTF_VARCHAR2_TABLE_100
1403: , p5_a41 JTF_VARCHAR2_TABLE_100
1404: , p5_a42 JTF_NUMBER_TABLE
1400: , p5_a38 JTF_NUMBER_TABLE
1401: , p5_a39 JTF_VARCHAR2_TABLE_100
1402: , p5_a40 JTF_VARCHAR2_TABLE_100
1403: , p5_a41 JTF_VARCHAR2_TABLE_100
1404: , p5_a42 JTF_NUMBER_TABLE
1405: , p5_a43 JTF_DATE_TABLE
1406: )
1407:
1408: as
1697: , p_init_msg_list VARCHAR2
1698: , x_return_status out nocopy VARCHAR2
1699: , x_msg_count out nocopy NUMBER
1700: , x_msg_data out nocopy VARCHAR2
1701: , p5_a0 JTF_NUMBER_TABLE
1702: , p5_a1 JTF_VARCHAR2_TABLE_300
1703: , p5_a2 JTF_NUMBER_TABLE
1704: , p5_a3 JTF_DATE_TABLE
1705: , p5_a4 JTF_DATE_TABLE
1699: , x_msg_count out nocopy NUMBER
1700: , x_msg_data out nocopy VARCHAR2
1701: , p5_a0 JTF_NUMBER_TABLE
1702: , p5_a1 JTF_VARCHAR2_TABLE_300
1703: , p5_a2 JTF_NUMBER_TABLE
1704: , p5_a3 JTF_DATE_TABLE
1705: , p5_a4 JTF_DATE_TABLE
1706: , p5_a5 JTF_DATE_TABLE
1707: , p5_a6 JTF_VARCHAR2_TABLE_100
1705: , p5_a4 JTF_DATE_TABLE
1706: , p5_a5 JTF_DATE_TABLE
1707: , p5_a6 JTF_VARCHAR2_TABLE_100
1708: , p5_a7 JTF_VARCHAR2_TABLE_100
1709: , p5_a8 JTF_NUMBER_TABLE
1710: , p5_a9 JTF_NUMBER_TABLE
1711: , p5_a10 JTF_NUMBER_TABLE
1712: , p5_a11 JTF_NUMBER_TABLE
1713: , p5_a12 JTF_VARCHAR2_TABLE_2000
1706: , p5_a5 JTF_DATE_TABLE
1707: , p5_a6 JTF_VARCHAR2_TABLE_100
1708: , p5_a7 JTF_VARCHAR2_TABLE_100
1709: , p5_a8 JTF_NUMBER_TABLE
1710: , p5_a9 JTF_NUMBER_TABLE
1711: , p5_a10 JTF_NUMBER_TABLE
1712: , p5_a11 JTF_NUMBER_TABLE
1713: , p5_a12 JTF_VARCHAR2_TABLE_2000
1714: , p5_a13 JTF_NUMBER_TABLE
1707: , p5_a6 JTF_VARCHAR2_TABLE_100
1708: , p5_a7 JTF_VARCHAR2_TABLE_100
1709: , p5_a8 JTF_NUMBER_TABLE
1710: , p5_a9 JTF_NUMBER_TABLE
1711: , p5_a10 JTF_NUMBER_TABLE
1712: , p5_a11 JTF_NUMBER_TABLE
1713: , p5_a12 JTF_VARCHAR2_TABLE_2000
1714: , p5_a13 JTF_NUMBER_TABLE
1715: , p5_a14 JTF_NUMBER_TABLE
1708: , p5_a7 JTF_VARCHAR2_TABLE_100
1709: , p5_a8 JTF_NUMBER_TABLE
1710: , p5_a9 JTF_NUMBER_TABLE
1711: , p5_a10 JTF_NUMBER_TABLE
1712: , p5_a11 JTF_NUMBER_TABLE
1713: , p5_a12 JTF_VARCHAR2_TABLE_2000
1714: , p5_a13 JTF_NUMBER_TABLE
1715: , p5_a14 JTF_NUMBER_TABLE
1716: , p5_a15 JTF_NUMBER_TABLE
1710: , p5_a9 JTF_NUMBER_TABLE
1711: , p5_a10 JTF_NUMBER_TABLE
1712: , p5_a11 JTF_NUMBER_TABLE
1713: , p5_a12 JTF_VARCHAR2_TABLE_2000
1714: , p5_a13 JTF_NUMBER_TABLE
1715: , p5_a14 JTF_NUMBER_TABLE
1716: , p5_a15 JTF_NUMBER_TABLE
1717: , p5_a16 JTF_NUMBER_TABLE
1718: , p5_a17 JTF_DATE_TABLE
1711: , p5_a10 JTF_NUMBER_TABLE
1712: , p5_a11 JTF_NUMBER_TABLE
1713: , p5_a12 JTF_VARCHAR2_TABLE_2000
1714: , p5_a13 JTF_NUMBER_TABLE
1715: , p5_a14 JTF_NUMBER_TABLE
1716: , p5_a15 JTF_NUMBER_TABLE
1717: , p5_a16 JTF_NUMBER_TABLE
1718: , p5_a17 JTF_DATE_TABLE
1719: , p5_a18 JTF_VARCHAR2_TABLE_300
1712: , p5_a11 JTF_NUMBER_TABLE
1713: , p5_a12 JTF_VARCHAR2_TABLE_2000
1714: , p5_a13 JTF_NUMBER_TABLE
1715: , p5_a14 JTF_NUMBER_TABLE
1716: , p5_a15 JTF_NUMBER_TABLE
1717: , p5_a16 JTF_NUMBER_TABLE
1718: , p5_a17 JTF_DATE_TABLE
1719: , p5_a18 JTF_VARCHAR2_TABLE_300
1720: , p5_a19 JTF_VARCHAR2_TABLE_300
1713: , p5_a12 JTF_VARCHAR2_TABLE_2000
1714: , p5_a13 JTF_NUMBER_TABLE
1715: , p5_a14 JTF_NUMBER_TABLE
1716: , p5_a15 JTF_NUMBER_TABLE
1717: , p5_a16 JTF_NUMBER_TABLE
1718: , p5_a17 JTF_DATE_TABLE
1719: , p5_a18 JTF_VARCHAR2_TABLE_300
1720: , p5_a19 JTF_VARCHAR2_TABLE_300
1721: , p5_a20 JTF_VARCHAR2_TABLE_300
1731: , p5_a30 JTF_VARCHAR2_TABLE_300
1732: , p5_a31 JTF_VARCHAR2_TABLE_300
1733: , p5_a32 JTF_VARCHAR2_TABLE_300
1734: , p5_a33 JTF_VARCHAR2_TABLE_300
1735: , p5_a34 JTF_NUMBER_TABLE
1736: , p5_a35 JTF_DATE_TABLE
1737: , p5_a36 JTF_NUMBER_TABLE
1738: , p5_a37 JTF_DATE_TABLE
1739: , p5_a38 JTF_NUMBER_TABLE
1733: , p5_a32 JTF_VARCHAR2_TABLE_300
1734: , p5_a33 JTF_VARCHAR2_TABLE_300
1735: , p5_a34 JTF_NUMBER_TABLE
1736: , p5_a35 JTF_DATE_TABLE
1737: , p5_a36 JTF_NUMBER_TABLE
1738: , p5_a37 JTF_DATE_TABLE
1739: , p5_a38 JTF_NUMBER_TABLE
1740: , p5_a39 JTF_VARCHAR2_TABLE_100
1741: , p5_a40 JTF_VARCHAR2_TABLE_100
1735: , p5_a34 JTF_NUMBER_TABLE
1736: , p5_a35 JTF_DATE_TABLE
1737: , p5_a36 JTF_NUMBER_TABLE
1738: , p5_a37 JTF_DATE_TABLE
1739: , p5_a38 JTF_NUMBER_TABLE
1740: , p5_a39 JTF_VARCHAR2_TABLE_100
1741: , p5_a40 JTF_VARCHAR2_TABLE_100
1742: , p5_a41 JTF_VARCHAR2_TABLE_100
1743: , p5_a42 JTF_NUMBER_TABLE
1739: , p5_a38 JTF_NUMBER_TABLE
1740: , p5_a39 JTF_VARCHAR2_TABLE_100
1741: , p5_a40 JTF_VARCHAR2_TABLE_100
1742: , p5_a41 JTF_VARCHAR2_TABLE_100
1743: , p5_a42 JTF_NUMBER_TABLE
1744: , p5_a43 JTF_DATE_TABLE
1745: , p6_a0 out nocopy JTF_NUMBER_TABLE
1746: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300
1747: , p6_a2 out nocopy JTF_NUMBER_TABLE
1741: , p5_a40 JTF_VARCHAR2_TABLE_100
1742: , p5_a41 JTF_VARCHAR2_TABLE_100
1743: , p5_a42 JTF_NUMBER_TABLE
1744: , p5_a43 JTF_DATE_TABLE
1745: , p6_a0 out nocopy JTF_NUMBER_TABLE
1746: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300
1747: , p6_a2 out nocopy JTF_NUMBER_TABLE
1748: , p6_a3 out nocopy JTF_DATE_TABLE
1749: , p6_a4 out nocopy JTF_DATE_TABLE
1743: , p5_a42 JTF_NUMBER_TABLE
1744: , p5_a43 JTF_DATE_TABLE
1745: , p6_a0 out nocopy JTF_NUMBER_TABLE
1746: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_300
1747: , p6_a2 out nocopy JTF_NUMBER_TABLE
1748: , p6_a3 out nocopy JTF_DATE_TABLE
1749: , p6_a4 out nocopy JTF_DATE_TABLE
1750: , p6_a5 out nocopy JTF_DATE_TABLE
1751: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1749: , p6_a4 out nocopy JTF_DATE_TABLE
1750: , p6_a5 out nocopy JTF_DATE_TABLE
1751: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1752: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
1753: , p6_a8 out nocopy JTF_NUMBER_TABLE
1754: , p6_a9 out nocopy JTF_NUMBER_TABLE
1755: , p6_a10 out nocopy JTF_NUMBER_TABLE
1756: , p6_a11 out nocopy JTF_NUMBER_TABLE
1757: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_2000
1750: , p6_a5 out nocopy JTF_DATE_TABLE
1751: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1752: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
1753: , p6_a8 out nocopy JTF_NUMBER_TABLE
1754: , p6_a9 out nocopy JTF_NUMBER_TABLE
1755: , p6_a10 out nocopy JTF_NUMBER_TABLE
1756: , p6_a11 out nocopy JTF_NUMBER_TABLE
1757: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_2000
1758: , p6_a13 out nocopy JTF_NUMBER_TABLE
1751: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1752: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
1753: , p6_a8 out nocopy JTF_NUMBER_TABLE
1754: , p6_a9 out nocopy JTF_NUMBER_TABLE
1755: , p6_a10 out nocopy JTF_NUMBER_TABLE
1756: , p6_a11 out nocopy JTF_NUMBER_TABLE
1757: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_2000
1758: , p6_a13 out nocopy JTF_NUMBER_TABLE
1759: , p6_a14 out nocopy JTF_NUMBER_TABLE
1752: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
1753: , p6_a8 out nocopy JTF_NUMBER_TABLE
1754: , p6_a9 out nocopy JTF_NUMBER_TABLE
1755: , p6_a10 out nocopy JTF_NUMBER_TABLE
1756: , p6_a11 out nocopy JTF_NUMBER_TABLE
1757: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_2000
1758: , p6_a13 out nocopy JTF_NUMBER_TABLE
1759: , p6_a14 out nocopy JTF_NUMBER_TABLE
1760: , p6_a15 out nocopy JTF_NUMBER_TABLE
1754: , p6_a9 out nocopy JTF_NUMBER_TABLE
1755: , p6_a10 out nocopy JTF_NUMBER_TABLE
1756: , p6_a11 out nocopy JTF_NUMBER_TABLE
1757: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_2000
1758: , p6_a13 out nocopy JTF_NUMBER_TABLE
1759: , p6_a14 out nocopy JTF_NUMBER_TABLE
1760: , p6_a15 out nocopy JTF_NUMBER_TABLE
1761: , p6_a16 out nocopy JTF_NUMBER_TABLE
1762: , p6_a17 out nocopy JTF_DATE_TABLE
1755: , p6_a10 out nocopy JTF_NUMBER_TABLE
1756: , p6_a11 out nocopy JTF_NUMBER_TABLE
1757: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_2000
1758: , p6_a13 out nocopy JTF_NUMBER_TABLE
1759: , p6_a14 out nocopy JTF_NUMBER_TABLE
1760: , p6_a15 out nocopy JTF_NUMBER_TABLE
1761: , p6_a16 out nocopy JTF_NUMBER_TABLE
1762: , p6_a17 out nocopy JTF_DATE_TABLE
1763: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_300
1756: , p6_a11 out nocopy JTF_NUMBER_TABLE
1757: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_2000
1758: , p6_a13 out nocopy JTF_NUMBER_TABLE
1759: , p6_a14 out nocopy JTF_NUMBER_TABLE
1760: , p6_a15 out nocopy JTF_NUMBER_TABLE
1761: , p6_a16 out nocopy JTF_NUMBER_TABLE
1762: , p6_a17 out nocopy JTF_DATE_TABLE
1763: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_300
1764: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_300
1757: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_2000
1758: , p6_a13 out nocopy JTF_NUMBER_TABLE
1759: , p6_a14 out nocopy JTF_NUMBER_TABLE
1760: , p6_a15 out nocopy JTF_NUMBER_TABLE
1761: , p6_a16 out nocopy JTF_NUMBER_TABLE
1762: , p6_a17 out nocopy JTF_DATE_TABLE
1763: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_300
1764: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_300
1765: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_300
1775: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_300
1776: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_300
1777: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_300
1778: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_300
1779: , p6_a34 out nocopy JTF_NUMBER_TABLE
1780: , p6_a35 out nocopy JTF_DATE_TABLE
1781: , p6_a36 out nocopy JTF_NUMBER_TABLE
1782: , p6_a37 out nocopy JTF_DATE_TABLE
1783: , p6_a38 out nocopy JTF_NUMBER_TABLE
1777: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_300
1778: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_300
1779: , p6_a34 out nocopy JTF_NUMBER_TABLE
1780: , p6_a35 out nocopy JTF_DATE_TABLE
1781: , p6_a36 out nocopy JTF_NUMBER_TABLE
1782: , p6_a37 out nocopy JTF_DATE_TABLE
1783: , p6_a38 out nocopy JTF_NUMBER_TABLE
1784: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
1785: , p6_a40 out nocopy JTF_VARCHAR2_TABLE_100
1779: , p6_a34 out nocopy JTF_NUMBER_TABLE
1780: , p6_a35 out nocopy JTF_DATE_TABLE
1781: , p6_a36 out nocopy JTF_NUMBER_TABLE
1782: , p6_a37 out nocopy JTF_DATE_TABLE
1783: , p6_a38 out nocopy JTF_NUMBER_TABLE
1784: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
1785: , p6_a40 out nocopy JTF_VARCHAR2_TABLE_100
1786: , p6_a41 out nocopy JTF_VARCHAR2_TABLE_100
1787: , p6_a42 out nocopy JTF_NUMBER_TABLE
1783: , p6_a38 out nocopy JTF_NUMBER_TABLE
1784: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
1785: , p6_a40 out nocopy JTF_VARCHAR2_TABLE_100
1786: , p6_a41 out nocopy JTF_VARCHAR2_TABLE_100
1787: , p6_a42 out nocopy JTF_NUMBER_TABLE
1788: , p6_a43 out nocopy JTF_DATE_TABLE
1789: )
1790:
1791: as
2037: , p_init_msg_list VARCHAR2
2038: , x_return_status out nocopy VARCHAR2
2039: , x_msg_count out nocopy NUMBER
2040: , x_msg_data out nocopy VARCHAR2
2041: , p5_a0 JTF_NUMBER_TABLE
2042: , p5_a1 JTF_VARCHAR2_TABLE_300
2043: , p5_a2 JTF_NUMBER_TABLE
2044: , p5_a3 JTF_DATE_TABLE
2045: , p5_a4 JTF_DATE_TABLE
2039: , x_msg_count out nocopy NUMBER
2040: , x_msg_data out nocopy VARCHAR2
2041: , p5_a0 JTF_NUMBER_TABLE
2042: , p5_a1 JTF_VARCHAR2_TABLE_300
2043: , p5_a2 JTF_NUMBER_TABLE
2044: , p5_a3 JTF_DATE_TABLE
2045: , p5_a4 JTF_DATE_TABLE
2046: , p5_a5 JTF_DATE_TABLE
2047: , p5_a6 JTF_VARCHAR2_TABLE_100
2045: , p5_a4 JTF_DATE_TABLE
2046: , p5_a5 JTF_DATE_TABLE
2047: , p5_a6 JTF_VARCHAR2_TABLE_100
2048: , p5_a7 JTF_VARCHAR2_TABLE_100
2049: , p5_a8 JTF_NUMBER_TABLE
2050: , p5_a9 JTF_NUMBER_TABLE
2051: , p5_a10 JTF_NUMBER_TABLE
2052: , p5_a11 JTF_NUMBER_TABLE
2053: , p5_a12 JTF_VARCHAR2_TABLE_2000
2046: , p5_a5 JTF_DATE_TABLE
2047: , p5_a6 JTF_VARCHAR2_TABLE_100
2048: , p5_a7 JTF_VARCHAR2_TABLE_100
2049: , p5_a8 JTF_NUMBER_TABLE
2050: , p5_a9 JTF_NUMBER_TABLE
2051: , p5_a10 JTF_NUMBER_TABLE
2052: , p5_a11 JTF_NUMBER_TABLE
2053: , p5_a12 JTF_VARCHAR2_TABLE_2000
2054: , p5_a13 JTF_NUMBER_TABLE
2047: , p5_a6 JTF_VARCHAR2_TABLE_100
2048: , p5_a7 JTF_VARCHAR2_TABLE_100
2049: , p5_a8 JTF_NUMBER_TABLE
2050: , p5_a9 JTF_NUMBER_TABLE
2051: , p5_a10 JTF_NUMBER_TABLE
2052: , p5_a11 JTF_NUMBER_TABLE
2053: , p5_a12 JTF_VARCHAR2_TABLE_2000
2054: , p5_a13 JTF_NUMBER_TABLE
2055: , p5_a14 JTF_NUMBER_TABLE
2048: , p5_a7 JTF_VARCHAR2_TABLE_100
2049: , p5_a8 JTF_NUMBER_TABLE
2050: , p5_a9 JTF_NUMBER_TABLE
2051: , p5_a10 JTF_NUMBER_TABLE
2052: , p5_a11 JTF_NUMBER_TABLE
2053: , p5_a12 JTF_VARCHAR2_TABLE_2000
2054: , p5_a13 JTF_NUMBER_TABLE
2055: , p5_a14 JTF_NUMBER_TABLE
2056: , p5_a15 JTF_NUMBER_TABLE
2050: , p5_a9 JTF_NUMBER_TABLE
2051: , p5_a10 JTF_NUMBER_TABLE
2052: , p5_a11 JTF_NUMBER_TABLE
2053: , p5_a12 JTF_VARCHAR2_TABLE_2000
2054: , p5_a13 JTF_NUMBER_TABLE
2055: , p5_a14 JTF_NUMBER_TABLE
2056: , p5_a15 JTF_NUMBER_TABLE
2057: , p5_a16 JTF_NUMBER_TABLE
2058: , p5_a17 JTF_DATE_TABLE
2051: , p5_a10 JTF_NUMBER_TABLE
2052: , p5_a11 JTF_NUMBER_TABLE
2053: , p5_a12 JTF_VARCHAR2_TABLE_2000
2054: , p5_a13 JTF_NUMBER_TABLE
2055: , p5_a14 JTF_NUMBER_TABLE
2056: , p5_a15 JTF_NUMBER_TABLE
2057: , p5_a16 JTF_NUMBER_TABLE
2058: , p5_a17 JTF_DATE_TABLE
2059: , p5_a18 JTF_VARCHAR2_TABLE_300
2052: , p5_a11 JTF_NUMBER_TABLE
2053: , p5_a12 JTF_VARCHAR2_TABLE_2000
2054: , p5_a13 JTF_NUMBER_TABLE
2055: , p5_a14 JTF_NUMBER_TABLE
2056: , p5_a15 JTF_NUMBER_TABLE
2057: , p5_a16 JTF_NUMBER_TABLE
2058: , p5_a17 JTF_DATE_TABLE
2059: , p5_a18 JTF_VARCHAR2_TABLE_300
2060: , p5_a19 JTF_VARCHAR2_TABLE_300
2053: , p5_a12 JTF_VARCHAR2_TABLE_2000
2054: , p5_a13 JTF_NUMBER_TABLE
2055: , p5_a14 JTF_NUMBER_TABLE
2056: , p5_a15 JTF_NUMBER_TABLE
2057: , p5_a16 JTF_NUMBER_TABLE
2058: , p5_a17 JTF_DATE_TABLE
2059: , p5_a18 JTF_VARCHAR2_TABLE_300
2060: , p5_a19 JTF_VARCHAR2_TABLE_300
2061: , p5_a20 JTF_VARCHAR2_TABLE_300
2071: , p5_a30 JTF_VARCHAR2_TABLE_300
2072: , p5_a31 JTF_VARCHAR2_TABLE_300
2073: , p5_a32 JTF_VARCHAR2_TABLE_300
2074: , p5_a33 JTF_VARCHAR2_TABLE_300
2075: , p5_a34 JTF_NUMBER_TABLE
2076: , p5_a35 JTF_DATE_TABLE
2077: , p5_a36 JTF_NUMBER_TABLE
2078: , p5_a37 JTF_DATE_TABLE
2079: , p5_a38 JTF_NUMBER_TABLE
2073: , p5_a32 JTF_VARCHAR2_TABLE_300
2074: , p5_a33 JTF_VARCHAR2_TABLE_300
2075: , p5_a34 JTF_NUMBER_TABLE
2076: , p5_a35 JTF_DATE_TABLE
2077: , p5_a36 JTF_NUMBER_TABLE
2078: , p5_a37 JTF_DATE_TABLE
2079: , p5_a38 JTF_NUMBER_TABLE
2080: , p5_a39 JTF_VARCHAR2_TABLE_100
2081: , p5_a40 JTF_VARCHAR2_TABLE_100
2075: , p5_a34 JTF_NUMBER_TABLE
2076: , p5_a35 JTF_DATE_TABLE
2077: , p5_a36 JTF_NUMBER_TABLE
2078: , p5_a37 JTF_DATE_TABLE
2079: , p5_a38 JTF_NUMBER_TABLE
2080: , p5_a39 JTF_VARCHAR2_TABLE_100
2081: , p5_a40 JTF_VARCHAR2_TABLE_100
2082: , p5_a41 JTF_VARCHAR2_TABLE_100
2083: , p5_a42 JTF_NUMBER_TABLE
2079: , p5_a38 JTF_NUMBER_TABLE
2080: , p5_a39 JTF_VARCHAR2_TABLE_100
2081: , p5_a40 JTF_VARCHAR2_TABLE_100
2082: , p5_a41 JTF_VARCHAR2_TABLE_100
2083: , p5_a42 JTF_NUMBER_TABLE
2084: , p5_a43 JTF_DATE_TABLE
2085: )
2086:
2087: as
2284: , p_init_msg_list VARCHAR2
2285: , x_return_status out nocopy VARCHAR2
2286: , x_msg_count out nocopy NUMBER
2287: , x_msg_data out nocopy VARCHAR2
2288: , p5_a0 JTF_NUMBER_TABLE
2289: , p5_a1 JTF_VARCHAR2_TABLE_300
2290: , p5_a2 JTF_NUMBER_TABLE
2291: , p5_a3 JTF_DATE_TABLE
2292: , p5_a4 JTF_DATE_TABLE
2286: , x_msg_count out nocopy NUMBER
2287: , x_msg_data out nocopy VARCHAR2
2288: , p5_a0 JTF_NUMBER_TABLE
2289: , p5_a1 JTF_VARCHAR2_TABLE_300
2290: , p5_a2 JTF_NUMBER_TABLE
2291: , p5_a3 JTF_DATE_TABLE
2292: , p5_a4 JTF_DATE_TABLE
2293: , p5_a5 JTF_DATE_TABLE
2294: , p5_a6 JTF_VARCHAR2_TABLE_100
2292: , p5_a4 JTF_DATE_TABLE
2293: , p5_a5 JTF_DATE_TABLE
2294: , p5_a6 JTF_VARCHAR2_TABLE_100
2295: , p5_a7 JTF_VARCHAR2_TABLE_100
2296: , p5_a8 JTF_NUMBER_TABLE
2297: , p5_a9 JTF_NUMBER_TABLE
2298: , p5_a10 JTF_NUMBER_TABLE
2299: , p5_a11 JTF_NUMBER_TABLE
2300: , p5_a12 JTF_VARCHAR2_TABLE_2000
2293: , p5_a5 JTF_DATE_TABLE
2294: , p5_a6 JTF_VARCHAR2_TABLE_100
2295: , p5_a7 JTF_VARCHAR2_TABLE_100
2296: , p5_a8 JTF_NUMBER_TABLE
2297: , p5_a9 JTF_NUMBER_TABLE
2298: , p5_a10 JTF_NUMBER_TABLE
2299: , p5_a11 JTF_NUMBER_TABLE
2300: , p5_a12 JTF_VARCHAR2_TABLE_2000
2301: , p5_a13 JTF_NUMBER_TABLE
2294: , p5_a6 JTF_VARCHAR2_TABLE_100
2295: , p5_a7 JTF_VARCHAR2_TABLE_100
2296: , p5_a8 JTF_NUMBER_TABLE
2297: , p5_a9 JTF_NUMBER_TABLE
2298: , p5_a10 JTF_NUMBER_TABLE
2299: , p5_a11 JTF_NUMBER_TABLE
2300: , p5_a12 JTF_VARCHAR2_TABLE_2000
2301: , p5_a13 JTF_NUMBER_TABLE
2302: , p5_a14 JTF_NUMBER_TABLE
2295: , p5_a7 JTF_VARCHAR2_TABLE_100
2296: , p5_a8 JTF_NUMBER_TABLE
2297: , p5_a9 JTF_NUMBER_TABLE
2298: , p5_a10 JTF_NUMBER_TABLE
2299: , p5_a11 JTF_NUMBER_TABLE
2300: , p5_a12 JTF_VARCHAR2_TABLE_2000
2301: , p5_a13 JTF_NUMBER_TABLE
2302: , p5_a14 JTF_NUMBER_TABLE
2303: , p5_a15 JTF_NUMBER_TABLE
2297: , p5_a9 JTF_NUMBER_TABLE
2298: , p5_a10 JTF_NUMBER_TABLE
2299: , p5_a11 JTF_NUMBER_TABLE
2300: , p5_a12 JTF_VARCHAR2_TABLE_2000
2301: , p5_a13 JTF_NUMBER_TABLE
2302: , p5_a14 JTF_NUMBER_TABLE
2303: , p5_a15 JTF_NUMBER_TABLE
2304: , p5_a16 JTF_NUMBER_TABLE
2305: , p5_a17 JTF_DATE_TABLE
2298: , p5_a10 JTF_NUMBER_TABLE
2299: , p5_a11 JTF_NUMBER_TABLE
2300: , p5_a12 JTF_VARCHAR2_TABLE_2000
2301: , p5_a13 JTF_NUMBER_TABLE
2302: , p5_a14 JTF_NUMBER_TABLE
2303: , p5_a15 JTF_NUMBER_TABLE
2304: , p5_a16 JTF_NUMBER_TABLE
2305: , p5_a17 JTF_DATE_TABLE
2306: , p5_a18 JTF_VARCHAR2_TABLE_300
2299: , p5_a11 JTF_NUMBER_TABLE
2300: , p5_a12 JTF_VARCHAR2_TABLE_2000
2301: , p5_a13 JTF_NUMBER_TABLE
2302: , p5_a14 JTF_NUMBER_TABLE
2303: , p5_a15 JTF_NUMBER_TABLE
2304: , p5_a16 JTF_NUMBER_TABLE
2305: , p5_a17 JTF_DATE_TABLE
2306: , p5_a18 JTF_VARCHAR2_TABLE_300
2307: , p5_a19 JTF_VARCHAR2_TABLE_300
2300: , p5_a12 JTF_VARCHAR2_TABLE_2000
2301: , p5_a13 JTF_NUMBER_TABLE
2302: , p5_a14 JTF_NUMBER_TABLE
2303: , p5_a15 JTF_NUMBER_TABLE
2304: , p5_a16 JTF_NUMBER_TABLE
2305: , p5_a17 JTF_DATE_TABLE
2306: , p5_a18 JTF_VARCHAR2_TABLE_300
2307: , p5_a19 JTF_VARCHAR2_TABLE_300
2308: , p5_a20 JTF_VARCHAR2_TABLE_300
2318: , p5_a30 JTF_VARCHAR2_TABLE_300
2319: , p5_a31 JTF_VARCHAR2_TABLE_300
2320: , p5_a32 JTF_VARCHAR2_TABLE_300
2321: , p5_a33 JTF_VARCHAR2_TABLE_300
2322: , p5_a34 JTF_NUMBER_TABLE
2323: , p5_a35 JTF_DATE_TABLE
2324: , p5_a36 JTF_NUMBER_TABLE
2325: , p5_a37 JTF_DATE_TABLE
2326: , p5_a38 JTF_NUMBER_TABLE
2320: , p5_a32 JTF_VARCHAR2_TABLE_300
2321: , p5_a33 JTF_VARCHAR2_TABLE_300
2322: , p5_a34 JTF_NUMBER_TABLE
2323: , p5_a35 JTF_DATE_TABLE
2324: , p5_a36 JTF_NUMBER_TABLE
2325: , p5_a37 JTF_DATE_TABLE
2326: , p5_a38 JTF_NUMBER_TABLE
2327: , p5_a39 JTF_VARCHAR2_TABLE_100
2328: , p5_a40 JTF_VARCHAR2_TABLE_100
2322: , p5_a34 JTF_NUMBER_TABLE
2323: , p5_a35 JTF_DATE_TABLE
2324: , p5_a36 JTF_NUMBER_TABLE
2325: , p5_a37 JTF_DATE_TABLE
2326: , p5_a38 JTF_NUMBER_TABLE
2327: , p5_a39 JTF_VARCHAR2_TABLE_100
2328: , p5_a40 JTF_VARCHAR2_TABLE_100
2329: , p5_a41 JTF_VARCHAR2_TABLE_100
2330: , p5_a42 JTF_NUMBER_TABLE
2326: , p5_a38 JTF_NUMBER_TABLE
2327: , p5_a39 JTF_VARCHAR2_TABLE_100
2328: , p5_a40 JTF_VARCHAR2_TABLE_100
2329: , p5_a41 JTF_VARCHAR2_TABLE_100
2330: , p5_a42 JTF_NUMBER_TABLE
2331: , p5_a43 JTF_DATE_TABLE
2332: )
2333:
2334: as