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_mst_pvt.mstv_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_200
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_VARCHAR2_TABLE_200
26: , a4 JTF_VARCHAR2_TABLE_600
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_mst_pvt.mstv_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_200
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_VARCHAR2_TABLE_200
26: , a4 JTF_VARCHAR2_TABLE_600
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_200
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_VARCHAR2_TABLE_200
26: , a4 JTF_VARCHAR2_TABLE_600
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_VARCHAR2_TABLE_100
30: , a8 JTF_VARCHAR2_TABLE_100
31: , a9 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_VARCHAR2_TABLE_200
26: , a4 JTF_VARCHAR2_TABLE_600
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_VARCHAR2_TABLE_100
30: , a8 JTF_VARCHAR2_TABLE_100
31: , a9 JTF_VARCHAR2_TABLE_100
32: , a10 JTF_VARCHAR2_TABLE_500
43: , a21 JTF_VARCHAR2_TABLE_500
44: , a22 JTF_VARCHAR2_TABLE_500
45: , a23 JTF_VARCHAR2_TABLE_500
46: , a24 JTF_VARCHAR2_TABLE_500
47: , a25 JTF_NUMBER_TABLE
48: , a26 JTF_DATE_TABLE
49: , a27 JTF_NUMBER_TABLE
50: , a28 JTF_DATE_TABLE
51: , a29 JTF_NUMBER_TABLE
45: , a23 JTF_VARCHAR2_TABLE_500
46: , a24 JTF_VARCHAR2_TABLE_500
47: , a25 JTF_NUMBER_TABLE
48: , a26 JTF_DATE_TABLE
49: , a27 JTF_NUMBER_TABLE
50: , a28 JTF_DATE_TABLE
51: , a29 JTF_NUMBER_TABLE
52: , a30 JTF_DATE_TABLE
53: ) as
47: , a25 JTF_NUMBER_TABLE
48: , a26 JTF_DATE_TABLE
49: , a27 JTF_NUMBER_TABLE
50: , a28 JTF_DATE_TABLE
51: , a29 JTF_NUMBER_TABLE
52: , a30 JTF_DATE_TABLE
53: ) as
54: ddindx binary_integer; indx binary_integer;
55: begin
97: end loop;
98: end if;
99: end if;
100: end rosetta_table_copy_in_p2;
101: procedure rosetta_table_copy_out_p2(t okl_mst_pvt.mstv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
102: , a1 out nocopy JTF_VARCHAR2_TABLE_200
103: , a2 out nocopy JTF_NUMBER_TABLE
104: , a3 out nocopy JTF_VARCHAR2_TABLE_200
105: , a4 out nocopy JTF_VARCHAR2_TABLE_600
99: end if;
100: end rosetta_table_copy_in_p2;
101: procedure rosetta_table_copy_out_p2(t okl_mst_pvt.mstv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
102: , a1 out nocopy JTF_VARCHAR2_TABLE_200
103: , a2 out nocopy JTF_NUMBER_TABLE
104: , a3 out nocopy JTF_VARCHAR2_TABLE_200
105: , a4 out nocopy JTF_VARCHAR2_TABLE_600
106: , a5 out nocopy JTF_NUMBER_TABLE
107: , a6 out nocopy JTF_NUMBER_TABLE
102: , a1 out nocopy JTF_VARCHAR2_TABLE_200
103: , a2 out nocopy JTF_NUMBER_TABLE
104: , a3 out nocopy JTF_VARCHAR2_TABLE_200
105: , a4 out nocopy JTF_VARCHAR2_TABLE_600
106: , a5 out nocopy JTF_NUMBER_TABLE
107: , a6 out nocopy JTF_NUMBER_TABLE
108: , a7 out nocopy JTF_VARCHAR2_TABLE_100
109: , a8 out nocopy JTF_VARCHAR2_TABLE_100
110: , a9 out nocopy JTF_VARCHAR2_TABLE_100
103: , a2 out nocopy JTF_NUMBER_TABLE
104: , a3 out nocopy JTF_VARCHAR2_TABLE_200
105: , a4 out nocopy JTF_VARCHAR2_TABLE_600
106: , a5 out nocopy JTF_NUMBER_TABLE
107: , a6 out nocopy JTF_NUMBER_TABLE
108: , a7 out nocopy JTF_VARCHAR2_TABLE_100
109: , a8 out nocopy JTF_VARCHAR2_TABLE_100
110: , a9 out nocopy JTF_VARCHAR2_TABLE_100
111: , a10 out nocopy JTF_VARCHAR2_TABLE_500
122: , a21 out nocopy JTF_VARCHAR2_TABLE_500
123: , a22 out nocopy JTF_VARCHAR2_TABLE_500
124: , a23 out nocopy JTF_VARCHAR2_TABLE_500
125: , a24 out nocopy JTF_VARCHAR2_TABLE_500
126: , a25 out nocopy JTF_NUMBER_TABLE
127: , a26 out nocopy JTF_DATE_TABLE
128: , a27 out nocopy JTF_NUMBER_TABLE
129: , a28 out nocopy JTF_DATE_TABLE
130: , a29 out nocopy JTF_NUMBER_TABLE
124: , a23 out nocopy JTF_VARCHAR2_TABLE_500
125: , a24 out nocopy JTF_VARCHAR2_TABLE_500
126: , a25 out nocopy JTF_NUMBER_TABLE
127: , a26 out nocopy JTF_DATE_TABLE
128: , a27 out nocopy JTF_NUMBER_TABLE
129: , a28 out nocopy JTF_DATE_TABLE
130: , a29 out nocopy JTF_NUMBER_TABLE
131: , a30 out nocopy JTF_DATE_TABLE
132: ) as
126: , a25 out nocopy JTF_NUMBER_TABLE
127: , a26 out nocopy JTF_DATE_TABLE
128: , a27 out nocopy JTF_NUMBER_TABLE
129: , a28 out nocopy JTF_DATE_TABLE
130: , a29 out nocopy JTF_NUMBER_TABLE
131: , a30 out nocopy JTF_DATE_TABLE
132: ) as
133: ddindx binary_integer; indx binary_integer;
134: begin
132: ) as
133: ddindx binary_integer; indx binary_integer;
134: begin
135: if t is null or t.count = 0 then
136: a0 := JTF_NUMBER_TABLE();
137: a1 := JTF_VARCHAR2_TABLE_200();
138: a2 := JTF_NUMBER_TABLE();
139: a3 := JTF_VARCHAR2_TABLE_200();
140: a4 := JTF_VARCHAR2_TABLE_600();
134: begin
135: if t is null or t.count = 0 then
136: a0 := JTF_NUMBER_TABLE();
137: a1 := JTF_VARCHAR2_TABLE_200();
138: a2 := JTF_NUMBER_TABLE();
139: a3 := JTF_VARCHAR2_TABLE_200();
140: a4 := JTF_VARCHAR2_TABLE_600();
141: a5 := JTF_NUMBER_TABLE();
142: a6 := JTF_NUMBER_TABLE();
137: a1 := JTF_VARCHAR2_TABLE_200();
138: a2 := JTF_NUMBER_TABLE();
139: a3 := JTF_VARCHAR2_TABLE_200();
140: a4 := JTF_VARCHAR2_TABLE_600();
141: a5 := JTF_NUMBER_TABLE();
142: a6 := JTF_NUMBER_TABLE();
143: a7 := JTF_VARCHAR2_TABLE_100();
144: a8 := JTF_VARCHAR2_TABLE_100();
145: a9 := JTF_VARCHAR2_TABLE_100();
138: a2 := JTF_NUMBER_TABLE();
139: a3 := JTF_VARCHAR2_TABLE_200();
140: a4 := JTF_VARCHAR2_TABLE_600();
141: a5 := JTF_NUMBER_TABLE();
142: a6 := JTF_NUMBER_TABLE();
143: a7 := JTF_VARCHAR2_TABLE_100();
144: a8 := JTF_VARCHAR2_TABLE_100();
145: a9 := JTF_VARCHAR2_TABLE_100();
146: a10 := JTF_VARCHAR2_TABLE_500();
157: a21 := JTF_VARCHAR2_TABLE_500();
158: a22 := JTF_VARCHAR2_TABLE_500();
159: a23 := JTF_VARCHAR2_TABLE_500();
160: a24 := JTF_VARCHAR2_TABLE_500();
161: a25 := JTF_NUMBER_TABLE();
162: a26 := JTF_DATE_TABLE();
163: a27 := JTF_NUMBER_TABLE();
164: a28 := JTF_DATE_TABLE();
165: a29 := JTF_NUMBER_TABLE();
159: a23 := JTF_VARCHAR2_TABLE_500();
160: a24 := JTF_VARCHAR2_TABLE_500();
161: a25 := JTF_NUMBER_TABLE();
162: a26 := JTF_DATE_TABLE();
163: a27 := JTF_NUMBER_TABLE();
164: a28 := JTF_DATE_TABLE();
165: a29 := JTF_NUMBER_TABLE();
166: a30 := JTF_DATE_TABLE();
167: else
161: a25 := JTF_NUMBER_TABLE();
162: a26 := JTF_DATE_TABLE();
163: a27 := JTF_NUMBER_TABLE();
164: a28 := JTF_DATE_TABLE();
165: a29 := JTF_NUMBER_TABLE();
166: a30 := JTF_DATE_TABLE();
167: else
168: a0 := JTF_NUMBER_TABLE();
169: a1 := JTF_VARCHAR2_TABLE_200();
164: a28 := JTF_DATE_TABLE();
165: a29 := JTF_NUMBER_TABLE();
166: a30 := JTF_DATE_TABLE();
167: else
168: a0 := JTF_NUMBER_TABLE();
169: a1 := JTF_VARCHAR2_TABLE_200();
170: a2 := JTF_NUMBER_TABLE();
171: a3 := JTF_VARCHAR2_TABLE_200();
172: a4 := JTF_VARCHAR2_TABLE_600();
166: a30 := JTF_DATE_TABLE();
167: else
168: a0 := JTF_NUMBER_TABLE();
169: a1 := JTF_VARCHAR2_TABLE_200();
170: a2 := JTF_NUMBER_TABLE();
171: a3 := JTF_VARCHAR2_TABLE_200();
172: a4 := JTF_VARCHAR2_TABLE_600();
173: a5 := JTF_NUMBER_TABLE();
174: a6 := JTF_NUMBER_TABLE();
169: a1 := JTF_VARCHAR2_TABLE_200();
170: a2 := JTF_NUMBER_TABLE();
171: a3 := JTF_VARCHAR2_TABLE_200();
172: a4 := JTF_VARCHAR2_TABLE_600();
173: a5 := JTF_NUMBER_TABLE();
174: a6 := JTF_NUMBER_TABLE();
175: a7 := JTF_VARCHAR2_TABLE_100();
176: a8 := JTF_VARCHAR2_TABLE_100();
177: a9 := JTF_VARCHAR2_TABLE_100();
170: a2 := JTF_NUMBER_TABLE();
171: a3 := JTF_VARCHAR2_TABLE_200();
172: a4 := JTF_VARCHAR2_TABLE_600();
173: a5 := JTF_NUMBER_TABLE();
174: a6 := JTF_NUMBER_TABLE();
175: a7 := JTF_VARCHAR2_TABLE_100();
176: a8 := JTF_VARCHAR2_TABLE_100();
177: a9 := JTF_VARCHAR2_TABLE_100();
178: a10 := JTF_VARCHAR2_TABLE_500();
189: a21 := JTF_VARCHAR2_TABLE_500();
190: a22 := JTF_VARCHAR2_TABLE_500();
191: a23 := JTF_VARCHAR2_TABLE_500();
192: a24 := JTF_VARCHAR2_TABLE_500();
193: a25 := JTF_NUMBER_TABLE();
194: a26 := JTF_DATE_TABLE();
195: a27 := JTF_NUMBER_TABLE();
196: a28 := JTF_DATE_TABLE();
197: a29 := JTF_NUMBER_TABLE();
191: a23 := JTF_VARCHAR2_TABLE_500();
192: a24 := JTF_VARCHAR2_TABLE_500();
193: a25 := JTF_NUMBER_TABLE();
194: a26 := JTF_DATE_TABLE();
195: a27 := JTF_NUMBER_TABLE();
196: a28 := JTF_DATE_TABLE();
197: a29 := JTF_NUMBER_TABLE();
198: a30 := JTF_DATE_TABLE();
199: if t.count > 0 then
193: a25 := JTF_NUMBER_TABLE();
194: a26 := JTF_DATE_TABLE();
195: a27 := JTF_NUMBER_TABLE();
196: a28 := JTF_DATE_TABLE();
197: a29 := JTF_NUMBER_TABLE();
198: a30 := JTF_DATE_TABLE();
199: if t.count > 0 then
200: a0.extend(t.count);
201: a1.extend(t.count);
271: end if;
272: end if;
273: end rosetta_table_copy_out_p2;
274:
275: procedure rosetta_table_copy_in_p5(t out nocopy okl_mst_pvt.mst_tbl_type, a0 JTF_NUMBER_TABLE
276: , a1 JTF_VARCHAR2_TABLE_200
277: , a2 JTF_NUMBER_TABLE
278: , a3 JTF_VARCHAR2_TABLE_200
279: , a4 JTF_VARCHAR2_TABLE_600
273: end rosetta_table_copy_out_p2;
274:
275: procedure rosetta_table_copy_in_p5(t out nocopy okl_mst_pvt.mst_tbl_type, a0 JTF_NUMBER_TABLE
276: , a1 JTF_VARCHAR2_TABLE_200
277: , a2 JTF_NUMBER_TABLE
278: , a3 JTF_VARCHAR2_TABLE_200
279: , a4 JTF_VARCHAR2_TABLE_600
280: , a5 JTF_NUMBER_TABLE
281: , a6 JTF_NUMBER_TABLE
276: , a1 JTF_VARCHAR2_TABLE_200
277: , a2 JTF_NUMBER_TABLE
278: , a3 JTF_VARCHAR2_TABLE_200
279: , a4 JTF_VARCHAR2_TABLE_600
280: , a5 JTF_NUMBER_TABLE
281: , a6 JTF_NUMBER_TABLE
282: , a7 JTF_VARCHAR2_TABLE_100
283: , a8 JTF_VARCHAR2_TABLE_100
284: , a9 JTF_VARCHAR2_TABLE_100
277: , a2 JTF_NUMBER_TABLE
278: , a3 JTF_VARCHAR2_TABLE_200
279: , a4 JTF_VARCHAR2_TABLE_600
280: , a5 JTF_NUMBER_TABLE
281: , a6 JTF_NUMBER_TABLE
282: , a7 JTF_VARCHAR2_TABLE_100
283: , a8 JTF_VARCHAR2_TABLE_100
284: , a9 JTF_VARCHAR2_TABLE_100
285: , a10 JTF_VARCHAR2_TABLE_500
296: , a21 JTF_VARCHAR2_TABLE_500
297: , a22 JTF_VARCHAR2_TABLE_500
298: , a23 JTF_VARCHAR2_TABLE_500
299: , a24 JTF_VARCHAR2_TABLE_500
300: , a25 JTF_NUMBER_TABLE
301: , a26 JTF_DATE_TABLE
302: , a27 JTF_NUMBER_TABLE
303: , a28 JTF_DATE_TABLE
304: , a29 JTF_NUMBER_TABLE
298: , a23 JTF_VARCHAR2_TABLE_500
299: , a24 JTF_VARCHAR2_TABLE_500
300: , a25 JTF_NUMBER_TABLE
301: , a26 JTF_DATE_TABLE
302: , a27 JTF_NUMBER_TABLE
303: , a28 JTF_DATE_TABLE
304: , a29 JTF_NUMBER_TABLE
305: , a30 JTF_DATE_TABLE
306: ) as
300: , a25 JTF_NUMBER_TABLE
301: , a26 JTF_DATE_TABLE
302: , a27 JTF_NUMBER_TABLE
303: , a28 JTF_DATE_TABLE
304: , a29 JTF_NUMBER_TABLE
305: , a30 JTF_DATE_TABLE
306: ) as
307: ddindx binary_integer; indx binary_integer;
308: begin
350: end loop;
351: end if;
352: end if;
353: end rosetta_table_copy_in_p5;
354: procedure rosetta_table_copy_out_p5(t okl_mst_pvt.mst_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
355: , a1 out nocopy JTF_VARCHAR2_TABLE_200
356: , a2 out nocopy JTF_NUMBER_TABLE
357: , a3 out nocopy JTF_VARCHAR2_TABLE_200
358: , a4 out nocopy JTF_VARCHAR2_TABLE_600
352: end if;
353: end rosetta_table_copy_in_p5;
354: procedure rosetta_table_copy_out_p5(t okl_mst_pvt.mst_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
355: , a1 out nocopy JTF_VARCHAR2_TABLE_200
356: , a2 out nocopy JTF_NUMBER_TABLE
357: , a3 out nocopy JTF_VARCHAR2_TABLE_200
358: , a4 out nocopy JTF_VARCHAR2_TABLE_600
359: , a5 out nocopy JTF_NUMBER_TABLE
360: , a6 out nocopy JTF_NUMBER_TABLE
355: , a1 out nocopy JTF_VARCHAR2_TABLE_200
356: , a2 out nocopy JTF_NUMBER_TABLE
357: , a3 out nocopy JTF_VARCHAR2_TABLE_200
358: , a4 out nocopy JTF_VARCHAR2_TABLE_600
359: , a5 out nocopy JTF_NUMBER_TABLE
360: , a6 out nocopy JTF_NUMBER_TABLE
361: , a7 out nocopy JTF_VARCHAR2_TABLE_100
362: , a8 out nocopy JTF_VARCHAR2_TABLE_100
363: , a9 out nocopy JTF_VARCHAR2_TABLE_100
356: , a2 out nocopy JTF_NUMBER_TABLE
357: , a3 out nocopy JTF_VARCHAR2_TABLE_200
358: , a4 out nocopy JTF_VARCHAR2_TABLE_600
359: , a5 out nocopy JTF_NUMBER_TABLE
360: , a6 out nocopy JTF_NUMBER_TABLE
361: , a7 out nocopy JTF_VARCHAR2_TABLE_100
362: , a8 out nocopy JTF_VARCHAR2_TABLE_100
363: , a9 out nocopy JTF_VARCHAR2_TABLE_100
364: , a10 out nocopy JTF_VARCHAR2_TABLE_500
375: , a21 out nocopy JTF_VARCHAR2_TABLE_500
376: , a22 out nocopy JTF_VARCHAR2_TABLE_500
377: , a23 out nocopy JTF_VARCHAR2_TABLE_500
378: , a24 out nocopy JTF_VARCHAR2_TABLE_500
379: , a25 out nocopy JTF_NUMBER_TABLE
380: , a26 out nocopy JTF_DATE_TABLE
381: , a27 out nocopy JTF_NUMBER_TABLE
382: , a28 out nocopy JTF_DATE_TABLE
383: , a29 out nocopy JTF_NUMBER_TABLE
377: , a23 out nocopy JTF_VARCHAR2_TABLE_500
378: , a24 out nocopy JTF_VARCHAR2_TABLE_500
379: , a25 out nocopy JTF_NUMBER_TABLE
380: , a26 out nocopy JTF_DATE_TABLE
381: , a27 out nocopy JTF_NUMBER_TABLE
382: , a28 out nocopy JTF_DATE_TABLE
383: , a29 out nocopy JTF_NUMBER_TABLE
384: , a30 out nocopy JTF_DATE_TABLE
385: ) as
379: , a25 out nocopy JTF_NUMBER_TABLE
380: , a26 out nocopy JTF_DATE_TABLE
381: , a27 out nocopy JTF_NUMBER_TABLE
382: , a28 out nocopy JTF_DATE_TABLE
383: , a29 out nocopy JTF_NUMBER_TABLE
384: , a30 out nocopy JTF_DATE_TABLE
385: ) as
386: ddindx binary_integer; indx binary_integer;
387: begin
385: ) as
386: ddindx binary_integer; indx binary_integer;
387: begin
388: if t is null or t.count = 0 then
389: a0 := JTF_NUMBER_TABLE();
390: a1 := JTF_VARCHAR2_TABLE_200();
391: a2 := JTF_NUMBER_TABLE();
392: a3 := JTF_VARCHAR2_TABLE_200();
393: a4 := JTF_VARCHAR2_TABLE_600();
387: begin
388: if t is null or t.count = 0 then
389: a0 := JTF_NUMBER_TABLE();
390: a1 := JTF_VARCHAR2_TABLE_200();
391: a2 := JTF_NUMBER_TABLE();
392: a3 := JTF_VARCHAR2_TABLE_200();
393: a4 := JTF_VARCHAR2_TABLE_600();
394: a5 := JTF_NUMBER_TABLE();
395: a6 := JTF_NUMBER_TABLE();
390: a1 := JTF_VARCHAR2_TABLE_200();
391: a2 := JTF_NUMBER_TABLE();
392: a3 := JTF_VARCHAR2_TABLE_200();
393: a4 := JTF_VARCHAR2_TABLE_600();
394: a5 := JTF_NUMBER_TABLE();
395: a6 := JTF_NUMBER_TABLE();
396: a7 := JTF_VARCHAR2_TABLE_100();
397: a8 := JTF_VARCHAR2_TABLE_100();
398: a9 := JTF_VARCHAR2_TABLE_100();
391: a2 := JTF_NUMBER_TABLE();
392: a3 := JTF_VARCHAR2_TABLE_200();
393: a4 := JTF_VARCHAR2_TABLE_600();
394: a5 := JTF_NUMBER_TABLE();
395: a6 := JTF_NUMBER_TABLE();
396: a7 := JTF_VARCHAR2_TABLE_100();
397: a8 := JTF_VARCHAR2_TABLE_100();
398: a9 := JTF_VARCHAR2_TABLE_100();
399: a10 := JTF_VARCHAR2_TABLE_500();
410: a21 := JTF_VARCHAR2_TABLE_500();
411: a22 := JTF_VARCHAR2_TABLE_500();
412: a23 := JTF_VARCHAR2_TABLE_500();
413: a24 := JTF_VARCHAR2_TABLE_500();
414: a25 := JTF_NUMBER_TABLE();
415: a26 := JTF_DATE_TABLE();
416: a27 := JTF_NUMBER_TABLE();
417: a28 := JTF_DATE_TABLE();
418: a29 := JTF_NUMBER_TABLE();
412: a23 := JTF_VARCHAR2_TABLE_500();
413: a24 := JTF_VARCHAR2_TABLE_500();
414: a25 := JTF_NUMBER_TABLE();
415: a26 := JTF_DATE_TABLE();
416: a27 := JTF_NUMBER_TABLE();
417: a28 := JTF_DATE_TABLE();
418: a29 := JTF_NUMBER_TABLE();
419: a30 := JTF_DATE_TABLE();
420: else
414: a25 := JTF_NUMBER_TABLE();
415: a26 := JTF_DATE_TABLE();
416: a27 := JTF_NUMBER_TABLE();
417: a28 := JTF_DATE_TABLE();
418: a29 := JTF_NUMBER_TABLE();
419: a30 := JTF_DATE_TABLE();
420: else
421: a0 := JTF_NUMBER_TABLE();
422: a1 := JTF_VARCHAR2_TABLE_200();
417: a28 := JTF_DATE_TABLE();
418: a29 := JTF_NUMBER_TABLE();
419: a30 := JTF_DATE_TABLE();
420: else
421: a0 := JTF_NUMBER_TABLE();
422: a1 := JTF_VARCHAR2_TABLE_200();
423: a2 := JTF_NUMBER_TABLE();
424: a3 := JTF_VARCHAR2_TABLE_200();
425: a4 := JTF_VARCHAR2_TABLE_600();
419: a30 := JTF_DATE_TABLE();
420: else
421: a0 := JTF_NUMBER_TABLE();
422: a1 := JTF_VARCHAR2_TABLE_200();
423: a2 := JTF_NUMBER_TABLE();
424: a3 := JTF_VARCHAR2_TABLE_200();
425: a4 := JTF_VARCHAR2_TABLE_600();
426: a5 := JTF_NUMBER_TABLE();
427: a6 := JTF_NUMBER_TABLE();
422: a1 := JTF_VARCHAR2_TABLE_200();
423: a2 := JTF_NUMBER_TABLE();
424: a3 := JTF_VARCHAR2_TABLE_200();
425: a4 := JTF_VARCHAR2_TABLE_600();
426: a5 := JTF_NUMBER_TABLE();
427: a6 := JTF_NUMBER_TABLE();
428: a7 := JTF_VARCHAR2_TABLE_100();
429: a8 := JTF_VARCHAR2_TABLE_100();
430: a9 := JTF_VARCHAR2_TABLE_100();
423: a2 := JTF_NUMBER_TABLE();
424: a3 := JTF_VARCHAR2_TABLE_200();
425: a4 := JTF_VARCHAR2_TABLE_600();
426: a5 := JTF_NUMBER_TABLE();
427: a6 := JTF_NUMBER_TABLE();
428: a7 := JTF_VARCHAR2_TABLE_100();
429: a8 := JTF_VARCHAR2_TABLE_100();
430: a9 := JTF_VARCHAR2_TABLE_100();
431: a10 := JTF_VARCHAR2_TABLE_500();
442: a21 := JTF_VARCHAR2_TABLE_500();
443: a22 := JTF_VARCHAR2_TABLE_500();
444: a23 := JTF_VARCHAR2_TABLE_500();
445: a24 := JTF_VARCHAR2_TABLE_500();
446: a25 := JTF_NUMBER_TABLE();
447: a26 := JTF_DATE_TABLE();
448: a27 := JTF_NUMBER_TABLE();
449: a28 := JTF_DATE_TABLE();
450: a29 := JTF_NUMBER_TABLE();
444: a23 := JTF_VARCHAR2_TABLE_500();
445: a24 := JTF_VARCHAR2_TABLE_500();
446: a25 := JTF_NUMBER_TABLE();
447: a26 := JTF_DATE_TABLE();
448: a27 := JTF_NUMBER_TABLE();
449: a28 := JTF_DATE_TABLE();
450: a29 := JTF_NUMBER_TABLE();
451: a30 := JTF_DATE_TABLE();
452: if t.count > 0 then
446: a25 := JTF_NUMBER_TABLE();
447: a26 := JTF_DATE_TABLE();
448: a27 := JTF_NUMBER_TABLE();
449: a28 := JTF_DATE_TABLE();
450: a29 := JTF_NUMBER_TABLE();
451: a30 := JTF_DATE_TABLE();
452: if t.count > 0 then
453: a0.extend(t.count);
454: a1.extend(t.count);
692: , p_init_msg_list VARCHAR2
693: , x_return_status out nocopy VARCHAR2
694: , x_msg_count out nocopy NUMBER
695: , x_msg_data out nocopy VARCHAR2
696: , p5_a0 JTF_NUMBER_TABLE
697: , p5_a1 JTF_VARCHAR2_TABLE_200
698: , p5_a2 JTF_NUMBER_TABLE
699: , p5_a3 JTF_VARCHAR2_TABLE_200
700: , p5_a4 JTF_VARCHAR2_TABLE_600
694: , x_msg_count out nocopy NUMBER
695: , x_msg_data out nocopy VARCHAR2
696: , p5_a0 JTF_NUMBER_TABLE
697: , p5_a1 JTF_VARCHAR2_TABLE_200
698: , p5_a2 JTF_NUMBER_TABLE
699: , p5_a3 JTF_VARCHAR2_TABLE_200
700: , p5_a4 JTF_VARCHAR2_TABLE_600
701: , p5_a5 JTF_NUMBER_TABLE
702: , p5_a6 JTF_NUMBER_TABLE
697: , p5_a1 JTF_VARCHAR2_TABLE_200
698: , p5_a2 JTF_NUMBER_TABLE
699: , p5_a3 JTF_VARCHAR2_TABLE_200
700: , p5_a4 JTF_VARCHAR2_TABLE_600
701: , p5_a5 JTF_NUMBER_TABLE
702: , p5_a6 JTF_NUMBER_TABLE
703: , p5_a7 JTF_VARCHAR2_TABLE_100
704: , p5_a8 JTF_VARCHAR2_TABLE_100
705: , p5_a9 JTF_VARCHAR2_TABLE_100
698: , p5_a2 JTF_NUMBER_TABLE
699: , p5_a3 JTF_VARCHAR2_TABLE_200
700: , p5_a4 JTF_VARCHAR2_TABLE_600
701: , p5_a5 JTF_NUMBER_TABLE
702: , p5_a6 JTF_NUMBER_TABLE
703: , p5_a7 JTF_VARCHAR2_TABLE_100
704: , p5_a8 JTF_VARCHAR2_TABLE_100
705: , p5_a9 JTF_VARCHAR2_TABLE_100
706: , p5_a10 JTF_VARCHAR2_TABLE_500
717: , p5_a21 JTF_VARCHAR2_TABLE_500
718: , p5_a22 JTF_VARCHAR2_TABLE_500
719: , p5_a23 JTF_VARCHAR2_TABLE_500
720: , p5_a24 JTF_VARCHAR2_TABLE_500
721: , p5_a25 JTF_NUMBER_TABLE
722: , p5_a26 JTF_DATE_TABLE
723: , p5_a27 JTF_NUMBER_TABLE
724: , p5_a28 JTF_DATE_TABLE
725: , p5_a29 JTF_NUMBER_TABLE
719: , p5_a23 JTF_VARCHAR2_TABLE_500
720: , p5_a24 JTF_VARCHAR2_TABLE_500
721: , p5_a25 JTF_NUMBER_TABLE
722: , p5_a26 JTF_DATE_TABLE
723: , p5_a27 JTF_NUMBER_TABLE
724: , p5_a28 JTF_DATE_TABLE
725: , p5_a29 JTF_NUMBER_TABLE
726: , p5_a30 JTF_DATE_TABLE
727: , p6_a0 out nocopy JTF_NUMBER_TABLE
721: , p5_a25 JTF_NUMBER_TABLE
722: , p5_a26 JTF_DATE_TABLE
723: , p5_a27 JTF_NUMBER_TABLE
724: , p5_a28 JTF_DATE_TABLE
725: , p5_a29 JTF_NUMBER_TABLE
726: , p5_a30 JTF_DATE_TABLE
727: , p6_a0 out nocopy JTF_NUMBER_TABLE
728: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
729: , p6_a2 out nocopy JTF_NUMBER_TABLE
723: , p5_a27 JTF_NUMBER_TABLE
724: , p5_a28 JTF_DATE_TABLE
725: , p5_a29 JTF_NUMBER_TABLE
726: , p5_a30 JTF_DATE_TABLE
727: , p6_a0 out nocopy JTF_NUMBER_TABLE
728: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
729: , p6_a2 out nocopy JTF_NUMBER_TABLE
730: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
731: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_600
725: , p5_a29 JTF_NUMBER_TABLE
726: , p5_a30 JTF_DATE_TABLE
727: , p6_a0 out nocopy JTF_NUMBER_TABLE
728: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
729: , p6_a2 out nocopy JTF_NUMBER_TABLE
730: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
731: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_600
732: , p6_a5 out nocopy JTF_NUMBER_TABLE
733: , p6_a6 out nocopy JTF_NUMBER_TABLE
728: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
729: , p6_a2 out nocopy JTF_NUMBER_TABLE
730: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
731: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_600
732: , p6_a5 out nocopy JTF_NUMBER_TABLE
733: , p6_a6 out nocopy JTF_NUMBER_TABLE
734: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
735: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
736: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
729: , p6_a2 out nocopy JTF_NUMBER_TABLE
730: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
731: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_600
732: , p6_a5 out nocopy JTF_NUMBER_TABLE
733: , p6_a6 out nocopy JTF_NUMBER_TABLE
734: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
735: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
736: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
737: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500
748: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
749: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
750: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
751: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
752: , p6_a25 out nocopy JTF_NUMBER_TABLE
753: , p6_a26 out nocopy JTF_DATE_TABLE
754: , p6_a27 out nocopy JTF_NUMBER_TABLE
755: , p6_a28 out nocopy JTF_DATE_TABLE
756: , p6_a29 out nocopy JTF_NUMBER_TABLE
750: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
751: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
752: , p6_a25 out nocopy JTF_NUMBER_TABLE
753: , p6_a26 out nocopy JTF_DATE_TABLE
754: , p6_a27 out nocopy JTF_NUMBER_TABLE
755: , p6_a28 out nocopy JTF_DATE_TABLE
756: , p6_a29 out nocopy JTF_NUMBER_TABLE
757: , p6_a30 out nocopy JTF_DATE_TABLE
758: )
752: , p6_a25 out nocopy JTF_NUMBER_TABLE
753: , p6_a26 out nocopy JTF_DATE_TABLE
754: , p6_a27 out nocopy JTF_NUMBER_TABLE
755: , p6_a28 out nocopy JTF_DATE_TABLE
756: , p6_a29 out nocopy JTF_NUMBER_TABLE
757: , p6_a30 out nocopy JTF_DATE_TABLE
758: )
759:
760: as
954: , p_init_msg_list VARCHAR2
955: , x_return_status out nocopy VARCHAR2
956: , x_msg_count out nocopy NUMBER
957: , x_msg_data out nocopy VARCHAR2
958: , p5_a0 JTF_NUMBER_TABLE
959: , p5_a1 JTF_VARCHAR2_TABLE_200
960: , p5_a2 JTF_NUMBER_TABLE
961: , p5_a3 JTF_VARCHAR2_TABLE_200
962: , p5_a4 JTF_VARCHAR2_TABLE_600
956: , x_msg_count out nocopy NUMBER
957: , x_msg_data out nocopy VARCHAR2
958: , p5_a0 JTF_NUMBER_TABLE
959: , p5_a1 JTF_VARCHAR2_TABLE_200
960: , p5_a2 JTF_NUMBER_TABLE
961: , p5_a3 JTF_VARCHAR2_TABLE_200
962: , p5_a4 JTF_VARCHAR2_TABLE_600
963: , p5_a5 JTF_NUMBER_TABLE
964: , p5_a6 JTF_NUMBER_TABLE
959: , p5_a1 JTF_VARCHAR2_TABLE_200
960: , p5_a2 JTF_NUMBER_TABLE
961: , p5_a3 JTF_VARCHAR2_TABLE_200
962: , p5_a4 JTF_VARCHAR2_TABLE_600
963: , p5_a5 JTF_NUMBER_TABLE
964: , p5_a6 JTF_NUMBER_TABLE
965: , p5_a7 JTF_VARCHAR2_TABLE_100
966: , p5_a8 JTF_VARCHAR2_TABLE_100
967: , p5_a9 JTF_VARCHAR2_TABLE_100
960: , p5_a2 JTF_NUMBER_TABLE
961: , p5_a3 JTF_VARCHAR2_TABLE_200
962: , p5_a4 JTF_VARCHAR2_TABLE_600
963: , p5_a5 JTF_NUMBER_TABLE
964: , p5_a6 JTF_NUMBER_TABLE
965: , p5_a7 JTF_VARCHAR2_TABLE_100
966: , p5_a8 JTF_VARCHAR2_TABLE_100
967: , p5_a9 JTF_VARCHAR2_TABLE_100
968: , p5_a10 JTF_VARCHAR2_TABLE_500
979: , p5_a21 JTF_VARCHAR2_TABLE_500
980: , p5_a22 JTF_VARCHAR2_TABLE_500
981: , p5_a23 JTF_VARCHAR2_TABLE_500
982: , p5_a24 JTF_VARCHAR2_TABLE_500
983: , p5_a25 JTF_NUMBER_TABLE
984: , p5_a26 JTF_DATE_TABLE
985: , p5_a27 JTF_NUMBER_TABLE
986: , p5_a28 JTF_DATE_TABLE
987: , p5_a29 JTF_NUMBER_TABLE
981: , p5_a23 JTF_VARCHAR2_TABLE_500
982: , p5_a24 JTF_VARCHAR2_TABLE_500
983: , p5_a25 JTF_NUMBER_TABLE
984: , p5_a26 JTF_DATE_TABLE
985: , p5_a27 JTF_NUMBER_TABLE
986: , p5_a28 JTF_DATE_TABLE
987: , p5_a29 JTF_NUMBER_TABLE
988: , p5_a30 JTF_DATE_TABLE
989: )
983: , p5_a25 JTF_NUMBER_TABLE
984: , p5_a26 JTF_DATE_TABLE
985: , p5_a27 JTF_NUMBER_TABLE
986: , p5_a28 JTF_DATE_TABLE
987: , p5_a29 JTF_NUMBER_TABLE
988: , p5_a30 JTF_DATE_TABLE
989: )
990:
991: as
1215: , p_init_msg_list VARCHAR2
1216: , x_return_status out nocopy VARCHAR2
1217: , x_msg_count out nocopy NUMBER
1218: , x_msg_data out nocopy VARCHAR2
1219: , p5_a0 JTF_NUMBER_TABLE
1220: , p5_a1 JTF_VARCHAR2_TABLE_200
1221: , p5_a2 JTF_NUMBER_TABLE
1222: , p5_a3 JTF_VARCHAR2_TABLE_200
1223: , p5_a4 JTF_VARCHAR2_TABLE_600
1217: , x_msg_count out nocopy NUMBER
1218: , x_msg_data out nocopy VARCHAR2
1219: , p5_a0 JTF_NUMBER_TABLE
1220: , p5_a1 JTF_VARCHAR2_TABLE_200
1221: , p5_a2 JTF_NUMBER_TABLE
1222: , p5_a3 JTF_VARCHAR2_TABLE_200
1223: , p5_a4 JTF_VARCHAR2_TABLE_600
1224: , p5_a5 JTF_NUMBER_TABLE
1225: , p5_a6 JTF_NUMBER_TABLE
1220: , p5_a1 JTF_VARCHAR2_TABLE_200
1221: , p5_a2 JTF_NUMBER_TABLE
1222: , p5_a3 JTF_VARCHAR2_TABLE_200
1223: , p5_a4 JTF_VARCHAR2_TABLE_600
1224: , p5_a5 JTF_NUMBER_TABLE
1225: , p5_a6 JTF_NUMBER_TABLE
1226: , p5_a7 JTF_VARCHAR2_TABLE_100
1227: , p5_a8 JTF_VARCHAR2_TABLE_100
1228: , p5_a9 JTF_VARCHAR2_TABLE_100
1221: , p5_a2 JTF_NUMBER_TABLE
1222: , p5_a3 JTF_VARCHAR2_TABLE_200
1223: , p5_a4 JTF_VARCHAR2_TABLE_600
1224: , p5_a5 JTF_NUMBER_TABLE
1225: , p5_a6 JTF_NUMBER_TABLE
1226: , p5_a7 JTF_VARCHAR2_TABLE_100
1227: , p5_a8 JTF_VARCHAR2_TABLE_100
1228: , p5_a9 JTF_VARCHAR2_TABLE_100
1229: , p5_a10 JTF_VARCHAR2_TABLE_500
1240: , p5_a21 JTF_VARCHAR2_TABLE_500
1241: , p5_a22 JTF_VARCHAR2_TABLE_500
1242: , p5_a23 JTF_VARCHAR2_TABLE_500
1243: , p5_a24 JTF_VARCHAR2_TABLE_500
1244: , p5_a25 JTF_NUMBER_TABLE
1245: , p5_a26 JTF_DATE_TABLE
1246: , p5_a27 JTF_NUMBER_TABLE
1247: , p5_a28 JTF_DATE_TABLE
1248: , p5_a29 JTF_NUMBER_TABLE
1242: , p5_a23 JTF_VARCHAR2_TABLE_500
1243: , p5_a24 JTF_VARCHAR2_TABLE_500
1244: , p5_a25 JTF_NUMBER_TABLE
1245: , p5_a26 JTF_DATE_TABLE
1246: , p5_a27 JTF_NUMBER_TABLE
1247: , p5_a28 JTF_DATE_TABLE
1248: , p5_a29 JTF_NUMBER_TABLE
1249: , p5_a30 JTF_DATE_TABLE
1250: , p6_a0 out nocopy JTF_NUMBER_TABLE
1244: , p5_a25 JTF_NUMBER_TABLE
1245: , p5_a26 JTF_DATE_TABLE
1246: , p5_a27 JTF_NUMBER_TABLE
1247: , p5_a28 JTF_DATE_TABLE
1248: , p5_a29 JTF_NUMBER_TABLE
1249: , p5_a30 JTF_DATE_TABLE
1250: , p6_a0 out nocopy JTF_NUMBER_TABLE
1251: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
1252: , p6_a2 out nocopy JTF_NUMBER_TABLE
1246: , p5_a27 JTF_NUMBER_TABLE
1247: , p5_a28 JTF_DATE_TABLE
1248: , p5_a29 JTF_NUMBER_TABLE
1249: , p5_a30 JTF_DATE_TABLE
1250: , p6_a0 out nocopy JTF_NUMBER_TABLE
1251: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
1252: , p6_a2 out nocopy JTF_NUMBER_TABLE
1253: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
1254: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_600
1248: , p5_a29 JTF_NUMBER_TABLE
1249: , p5_a30 JTF_DATE_TABLE
1250: , p6_a0 out nocopy JTF_NUMBER_TABLE
1251: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
1252: , p6_a2 out nocopy JTF_NUMBER_TABLE
1253: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
1254: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_600
1255: , p6_a5 out nocopy JTF_NUMBER_TABLE
1256: , p6_a6 out nocopy JTF_NUMBER_TABLE
1251: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
1252: , p6_a2 out nocopy JTF_NUMBER_TABLE
1253: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
1254: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_600
1255: , p6_a5 out nocopy JTF_NUMBER_TABLE
1256: , p6_a6 out nocopy JTF_NUMBER_TABLE
1257: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
1258: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
1259: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1252: , p6_a2 out nocopy JTF_NUMBER_TABLE
1253: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
1254: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_600
1255: , p6_a5 out nocopy JTF_NUMBER_TABLE
1256: , p6_a6 out nocopy JTF_NUMBER_TABLE
1257: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
1258: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
1259: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1260: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500
1271: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
1272: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
1273: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
1274: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
1275: , p6_a25 out nocopy JTF_NUMBER_TABLE
1276: , p6_a26 out nocopy JTF_DATE_TABLE
1277: , p6_a27 out nocopy JTF_NUMBER_TABLE
1278: , p6_a28 out nocopy JTF_DATE_TABLE
1279: , p6_a29 out nocopy JTF_NUMBER_TABLE
1273: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
1274: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
1275: , p6_a25 out nocopy JTF_NUMBER_TABLE
1276: , p6_a26 out nocopy JTF_DATE_TABLE
1277: , p6_a27 out nocopy JTF_NUMBER_TABLE
1278: , p6_a28 out nocopy JTF_DATE_TABLE
1279: , p6_a29 out nocopy JTF_NUMBER_TABLE
1280: , p6_a30 out nocopy JTF_DATE_TABLE
1281: )
1275: , p6_a25 out nocopy JTF_NUMBER_TABLE
1276: , p6_a26 out nocopy JTF_DATE_TABLE
1277: , p6_a27 out nocopy JTF_NUMBER_TABLE
1278: , p6_a28 out nocopy JTF_DATE_TABLE
1279: , p6_a29 out nocopy JTF_NUMBER_TABLE
1280: , p6_a30 out nocopy JTF_DATE_TABLE
1281: )
1282:
1283: as
1477: , p_init_msg_list VARCHAR2
1478: , x_return_status out nocopy VARCHAR2
1479: , x_msg_count out nocopy NUMBER
1480: , x_msg_data out nocopy VARCHAR2
1481: , p5_a0 JTF_NUMBER_TABLE
1482: , p5_a1 JTF_VARCHAR2_TABLE_200
1483: , p5_a2 JTF_NUMBER_TABLE
1484: , p5_a3 JTF_VARCHAR2_TABLE_200
1485: , p5_a4 JTF_VARCHAR2_TABLE_600
1479: , x_msg_count out nocopy NUMBER
1480: , x_msg_data out nocopy VARCHAR2
1481: , p5_a0 JTF_NUMBER_TABLE
1482: , p5_a1 JTF_VARCHAR2_TABLE_200
1483: , p5_a2 JTF_NUMBER_TABLE
1484: , p5_a3 JTF_VARCHAR2_TABLE_200
1485: , p5_a4 JTF_VARCHAR2_TABLE_600
1486: , p5_a5 JTF_NUMBER_TABLE
1487: , p5_a6 JTF_NUMBER_TABLE
1482: , p5_a1 JTF_VARCHAR2_TABLE_200
1483: , p5_a2 JTF_NUMBER_TABLE
1484: , p5_a3 JTF_VARCHAR2_TABLE_200
1485: , p5_a4 JTF_VARCHAR2_TABLE_600
1486: , p5_a5 JTF_NUMBER_TABLE
1487: , p5_a6 JTF_NUMBER_TABLE
1488: , p5_a7 JTF_VARCHAR2_TABLE_100
1489: , p5_a8 JTF_VARCHAR2_TABLE_100
1490: , p5_a9 JTF_VARCHAR2_TABLE_100
1483: , p5_a2 JTF_NUMBER_TABLE
1484: , p5_a3 JTF_VARCHAR2_TABLE_200
1485: , p5_a4 JTF_VARCHAR2_TABLE_600
1486: , p5_a5 JTF_NUMBER_TABLE
1487: , p5_a6 JTF_NUMBER_TABLE
1488: , p5_a7 JTF_VARCHAR2_TABLE_100
1489: , p5_a8 JTF_VARCHAR2_TABLE_100
1490: , p5_a9 JTF_VARCHAR2_TABLE_100
1491: , p5_a10 JTF_VARCHAR2_TABLE_500
1502: , p5_a21 JTF_VARCHAR2_TABLE_500
1503: , p5_a22 JTF_VARCHAR2_TABLE_500
1504: , p5_a23 JTF_VARCHAR2_TABLE_500
1505: , p5_a24 JTF_VARCHAR2_TABLE_500
1506: , p5_a25 JTF_NUMBER_TABLE
1507: , p5_a26 JTF_DATE_TABLE
1508: , p5_a27 JTF_NUMBER_TABLE
1509: , p5_a28 JTF_DATE_TABLE
1510: , p5_a29 JTF_NUMBER_TABLE
1504: , p5_a23 JTF_VARCHAR2_TABLE_500
1505: , p5_a24 JTF_VARCHAR2_TABLE_500
1506: , p5_a25 JTF_NUMBER_TABLE
1507: , p5_a26 JTF_DATE_TABLE
1508: , p5_a27 JTF_NUMBER_TABLE
1509: , p5_a28 JTF_DATE_TABLE
1510: , p5_a29 JTF_NUMBER_TABLE
1511: , p5_a30 JTF_DATE_TABLE
1512: )
1506: , p5_a25 JTF_NUMBER_TABLE
1507: , p5_a26 JTF_DATE_TABLE
1508: , p5_a27 JTF_NUMBER_TABLE
1509: , p5_a28 JTF_DATE_TABLE
1510: , p5_a29 JTF_NUMBER_TABLE
1511: , p5_a30 JTF_DATE_TABLE
1512: )
1513:
1514: as
1672: , p_init_msg_list VARCHAR2
1673: , x_return_status out nocopy VARCHAR2
1674: , x_msg_count out nocopy NUMBER
1675: , x_msg_data out nocopy VARCHAR2
1676: , p5_a0 JTF_NUMBER_TABLE
1677: , p5_a1 JTF_VARCHAR2_TABLE_200
1678: , p5_a2 JTF_NUMBER_TABLE
1679: , p5_a3 JTF_VARCHAR2_TABLE_200
1680: , p5_a4 JTF_VARCHAR2_TABLE_600
1674: , x_msg_count out nocopy NUMBER
1675: , x_msg_data out nocopy VARCHAR2
1676: , p5_a0 JTF_NUMBER_TABLE
1677: , p5_a1 JTF_VARCHAR2_TABLE_200
1678: , p5_a2 JTF_NUMBER_TABLE
1679: , p5_a3 JTF_VARCHAR2_TABLE_200
1680: , p5_a4 JTF_VARCHAR2_TABLE_600
1681: , p5_a5 JTF_NUMBER_TABLE
1682: , p5_a6 JTF_NUMBER_TABLE
1677: , p5_a1 JTF_VARCHAR2_TABLE_200
1678: , p5_a2 JTF_NUMBER_TABLE
1679: , p5_a3 JTF_VARCHAR2_TABLE_200
1680: , p5_a4 JTF_VARCHAR2_TABLE_600
1681: , p5_a5 JTF_NUMBER_TABLE
1682: , p5_a6 JTF_NUMBER_TABLE
1683: , p5_a7 JTF_VARCHAR2_TABLE_100
1684: , p5_a8 JTF_VARCHAR2_TABLE_100
1685: , p5_a9 JTF_VARCHAR2_TABLE_100
1678: , p5_a2 JTF_NUMBER_TABLE
1679: , p5_a3 JTF_VARCHAR2_TABLE_200
1680: , p5_a4 JTF_VARCHAR2_TABLE_600
1681: , p5_a5 JTF_NUMBER_TABLE
1682: , p5_a6 JTF_NUMBER_TABLE
1683: , p5_a7 JTF_VARCHAR2_TABLE_100
1684: , p5_a8 JTF_VARCHAR2_TABLE_100
1685: , p5_a9 JTF_VARCHAR2_TABLE_100
1686: , p5_a10 JTF_VARCHAR2_TABLE_500
1697: , p5_a21 JTF_VARCHAR2_TABLE_500
1698: , p5_a22 JTF_VARCHAR2_TABLE_500
1699: , p5_a23 JTF_VARCHAR2_TABLE_500
1700: , p5_a24 JTF_VARCHAR2_TABLE_500
1701: , p5_a25 JTF_NUMBER_TABLE
1702: , p5_a26 JTF_DATE_TABLE
1703: , p5_a27 JTF_NUMBER_TABLE
1704: , p5_a28 JTF_DATE_TABLE
1705: , p5_a29 JTF_NUMBER_TABLE
1699: , p5_a23 JTF_VARCHAR2_TABLE_500
1700: , p5_a24 JTF_VARCHAR2_TABLE_500
1701: , p5_a25 JTF_NUMBER_TABLE
1702: , p5_a26 JTF_DATE_TABLE
1703: , p5_a27 JTF_NUMBER_TABLE
1704: , p5_a28 JTF_DATE_TABLE
1705: , p5_a29 JTF_NUMBER_TABLE
1706: , p5_a30 JTF_DATE_TABLE
1707: )
1701: , p5_a25 JTF_NUMBER_TABLE
1702: , p5_a26 JTF_DATE_TABLE
1703: , p5_a27 JTF_NUMBER_TABLE
1704: , p5_a28 JTF_DATE_TABLE
1705: , p5_a29 JTF_NUMBER_TABLE
1706: , p5_a30 JTF_DATE_TABLE
1707: )
1708:
1709: as