21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_cld_pvt.cldv_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_500
28: , a6 JTF_VARCHAR2_TABLE_500
29: , a7 JTF_VARCHAR2_TABLE_500
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_cld_pvt.cldv_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_500
28: , a6 JTF_VARCHAR2_TABLE_500
29: , a7 JTF_VARCHAR2_TABLE_500
30: , a8 JTF_VARCHAR2_TABLE_500
48: , a26 JTF_DATE_TABLE
49: , a27 JTF_NUMBER_TABLE
50: , a28 JTF_DATE_TABLE
51: , a29 JTF_NUMBER_TABLE
52: , a30 JTF_VARCHAR2_TABLE_100
53: , a31 JTF_VARCHAR2_TABLE_100
54: , a32 JTF_VARCHAR2_TABLE_500
55: , a33 JTF_VARCHAR2_TABLE_500
56: , a34 JTF_NUMBER_TABLE
49: , a27 JTF_NUMBER_TABLE
50: , a28 JTF_DATE_TABLE
51: , a29 JTF_NUMBER_TABLE
52: , a30 JTF_VARCHAR2_TABLE_100
53: , a31 JTF_VARCHAR2_TABLE_100
54: , a32 JTF_VARCHAR2_TABLE_500
55: , a33 JTF_VARCHAR2_TABLE_500
56: , a34 JTF_NUMBER_TABLE
57: , a35 JTF_NUMBER_TABLE
54: , a32 JTF_VARCHAR2_TABLE_500
55: , a33 JTF_VARCHAR2_TABLE_500
56: , a34 JTF_NUMBER_TABLE
57: , a35 JTF_NUMBER_TABLE
58: , a36 JTF_VARCHAR2_TABLE_100
59: , a37 JTF_VARCHAR2_TABLE_2000
60: , a38 JTF_VARCHAR2_TABLE_100
61: , a39 JTF_VARCHAR2_TABLE_100
62: ) as
56: , a34 JTF_NUMBER_TABLE
57: , a35 JTF_NUMBER_TABLE
58: , a36 JTF_VARCHAR2_TABLE_100
59: , a37 JTF_VARCHAR2_TABLE_2000
60: , a38 JTF_VARCHAR2_TABLE_100
61: , a39 JTF_VARCHAR2_TABLE_100
62: ) as
63: ddindx binary_integer; indx binary_integer;
64: begin
57: , a35 JTF_NUMBER_TABLE
58: , a36 JTF_VARCHAR2_TABLE_100
59: , a37 JTF_VARCHAR2_TABLE_2000
60: , a38 JTF_VARCHAR2_TABLE_100
61: , a39 JTF_VARCHAR2_TABLE_100
62: ) as
63: ddindx binary_integer; indx binary_integer;
64: begin
65: if a0 is not null and a0.count > 0 then
118: end rosetta_table_copy_in_p2;
119: procedure rosetta_table_copy_out_p2(t okl_cld_pvt.cldv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
120: , a1 out nocopy JTF_NUMBER_TABLE
121: , a2 out nocopy JTF_NUMBER_TABLE
122: , a3 out nocopy JTF_VARCHAR2_TABLE_100
123: , a4 out nocopy JTF_VARCHAR2_TABLE_100
124: , a5 out nocopy JTF_VARCHAR2_TABLE_500
125: , a6 out nocopy JTF_VARCHAR2_TABLE_500
126: , a7 out nocopy JTF_VARCHAR2_TABLE_500
119: procedure rosetta_table_copy_out_p2(t okl_cld_pvt.cldv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
120: , a1 out nocopy JTF_NUMBER_TABLE
121: , a2 out nocopy JTF_NUMBER_TABLE
122: , a3 out nocopy JTF_VARCHAR2_TABLE_100
123: , a4 out nocopy JTF_VARCHAR2_TABLE_100
124: , a5 out nocopy JTF_VARCHAR2_TABLE_500
125: , a6 out nocopy JTF_VARCHAR2_TABLE_500
126: , a7 out nocopy JTF_VARCHAR2_TABLE_500
127: , a8 out nocopy JTF_VARCHAR2_TABLE_500
145: , a26 out nocopy JTF_DATE_TABLE
146: , a27 out nocopy JTF_NUMBER_TABLE
147: , a28 out nocopy JTF_DATE_TABLE
148: , a29 out nocopy JTF_NUMBER_TABLE
149: , a30 out nocopy JTF_VARCHAR2_TABLE_100
150: , a31 out nocopy JTF_VARCHAR2_TABLE_100
151: , a32 out nocopy JTF_VARCHAR2_TABLE_500
152: , a33 out nocopy JTF_VARCHAR2_TABLE_500
153: , a34 out nocopy JTF_NUMBER_TABLE
146: , a27 out nocopy JTF_NUMBER_TABLE
147: , a28 out nocopy JTF_DATE_TABLE
148: , a29 out nocopy JTF_NUMBER_TABLE
149: , a30 out nocopy JTF_VARCHAR2_TABLE_100
150: , a31 out nocopy JTF_VARCHAR2_TABLE_100
151: , a32 out nocopy JTF_VARCHAR2_TABLE_500
152: , a33 out nocopy JTF_VARCHAR2_TABLE_500
153: , a34 out nocopy JTF_NUMBER_TABLE
154: , a35 out nocopy JTF_NUMBER_TABLE
151: , a32 out nocopy JTF_VARCHAR2_TABLE_500
152: , a33 out nocopy JTF_VARCHAR2_TABLE_500
153: , a34 out nocopy JTF_NUMBER_TABLE
154: , a35 out nocopy JTF_NUMBER_TABLE
155: , a36 out nocopy JTF_VARCHAR2_TABLE_100
156: , a37 out nocopy JTF_VARCHAR2_TABLE_2000
157: , a38 out nocopy JTF_VARCHAR2_TABLE_100
158: , a39 out nocopy JTF_VARCHAR2_TABLE_100
159: ) as
153: , a34 out nocopy JTF_NUMBER_TABLE
154: , a35 out nocopy JTF_NUMBER_TABLE
155: , a36 out nocopy JTF_VARCHAR2_TABLE_100
156: , a37 out nocopy JTF_VARCHAR2_TABLE_2000
157: , a38 out nocopy JTF_VARCHAR2_TABLE_100
158: , a39 out nocopy JTF_VARCHAR2_TABLE_100
159: ) as
160: ddindx binary_integer; indx binary_integer;
161: begin
154: , a35 out nocopy JTF_NUMBER_TABLE
155: , a36 out nocopy JTF_VARCHAR2_TABLE_100
156: , a37 out nocopy JTF_VARCHAR2_TABLE_2000
157: , a38 out nocopy JTF_VARCHAR2_TABLE_100
158: , a39 out nocopy JTF_VARCHAR2_TABLE_100
159: ) as
160: ddindx binary_integer; indx binary_integer;
161: begin
162: if t is null or t.count = 0 then
162: if t is null or t.count = 0 then
163: a0 := JTF_NUMBER_TABLE();
164: a1 := JTF_NUMBER_TABLE();
165: a2 := JTF_NUMBER_TABLE();
166: a3 := JTF_VARCHAR2_TABLE_100();
167: a4 := JTF_VARCHAR2_TABLE_100();
168: a5 := JTF_VARCHAR2_TABLE_500();
169: a6 := JTF_VARCHAR2_TABLE_500();
170: a7 := JTF_VARCHAR2_TABLE_500();
163: a0 := JTF_NUMBER_TABLE();
164: a1 := JTF_NUMBER_TABLE();
165: a2 := JTF_NUMBER_TABLE();
166: a3 := JTF_VARCHAR2_TABLE_100();
167: a4 := JTF_VARCHAR2_TABLE_100();
168: a5 := JTF_VARCHAR2_TABLE_500();
169: a6 := JTF_VARCHAR2_TABLE_500();
170: a7 := JTF_VARCHAR2_TABLE_500();
171: a8 := JTF_VARCHAR2_TABLE_500();
189: a26 := JTF_DATE_TABLE();
190: a27 := JTF_NUMBER_TABLE();
191: a28 := JTF_DATE_TABLE();
192: a29 := JTF_NUMBER_TABLE();
193: a30 := JTF_VARCHAR2_TABLE_100();
194: a31 := JTF_VARCHAR2_TABLE_100();
195: a32 := JTF_VARCHAR2_TABLE_500();
196: a33 := JTF_VARCHAR2_TABLE_500();
197: a34 := JTF_NUMBER_TABLE();
190: a27 := JTF_NUMBER_TABLE();
191: a28 := JTF_DATE_TABLE();
192: a29 := JTF_NUMBER_TABLE();
193: a30 := JTF_VARCHAR2_TABLE_100();
194: a31 := JTF_VARCHAR2_TABLE_100();
195: a32 := JTF_VARCHAR2_TABLE_500();
196: a33 := JTF_VARCHAR2_TABLE_500();
197: a34 := JTF_NUMBER_TABLE();
198: a35 := JTF_NUMBER_TABLE();
195: a32 := JTF_VARCHAR2_TABLE_500();
196: a33 := JTF_VARCHAR2_TABLE_500();
197: a34 := JTF_NUMBER_TABLE();
198: a35 := JTF_NUMBER_TABLE();
199: a36 := JTF_VARCHAR2_TABLE_100();
200: a37 := JTF_VARCHAR2_TABLE_2000();
201: a38 := JTF_VARCHAR2_TABLE_100();
202: a39 := JTF_VARCHAR2_TABLE_100();
203: else
197: a34 := JTF_NUMBER_TABLE();
198: a35 := JTF_NUMBER_TABLE();
199: a36 := JTF_VARCHAR2_TABLE_100();
200: a37 := JTF_VARCHAR2_TABLE_2000();
201: a38 := JTF_VARCHAR2_TABLE_100();
202: a39 := JTF_VARCHAR2_TABLE_100();
203: else
204: a0 := JTF_NUMBER_TABLE();
205: a1 := JTF_NUMBER_TABLE();
198: a35 := JTF_NUMBER_TABLE();
199: a36 := JTF_VARCHAR2_TABLE_100();
200: a37 := JTF_VARCHAR2_TABLE_2000();
201: a38 := JTF_VARCHAR2_TABLE_100();
202: a39 := JTF_VARCHAR2_TABLE_100();
203: else
204: a0 := JTF_NUMBER_TABLE();
205: a1 := JTF_NUMBER_TABLE();
206: a2 := JTF_NUMBER_TABLE();
203: else
204: a0 := JTF_NUMBER_TABLE();
205: a1 := JTF_NUMBER_TABLE();
206: a2 := JTF_NUMBER_TABLE();
207: a3 := JTF_VARCHAR2_TABLE_100();
208: a4 := JTF_VARCHAR2_TABLE_100();
209: a5 := JTF_VARCHAR2_TABLE_500();
210: a6 := JTF_VARCHAR2_TABLE_500();
211: a7 := JTF_VARCHAR2_TABLE_500();
204: a0 := JTF_NUMBER_TABLE();
205: a1 := JTF_NUMBER_TABLE();
206: a2 := JTF_NUMBER_TABLE();
207: a3 := JTF_VARCHAR2_TABLE_100();
208: a4 := JTF_VARCHAR2_TABLE_100();
209: a5 := JTF_VARCHAR2_TABLE_500();
210: a6 := JTF_VARCHAR2_TABLE_500();
211: a7 := JTF_VARCHAR2_TABLE_500();
212: a8 := JTF_VARCHAR2_TABLE_500();
230: a26 := JTF_DATE_TABLE();
231: a27 := JTF_NUMBER_TABLE();
232: a28 := JTF_DATE_TABLE();
233: a29 := JTF_NUMBER_TABLE();
234: a30 := JTF_VARCHAR2_TABLE_100();
235: a31 := JTF_VARCHAR2_TABLE_100();
236: a32 := JTF_VARCHAR2_TABLE_500();
237: a33 := JTF_VARCHAR2_TABLE_500();
238: a34 := JTF_NUMBER_TABLE();
231: a27 := JTF_NUMBER_TABLE();
232: a28 := JTF_DATE_TABLE();
233: a29 := JTF_NUMBER_TABLE();
234: a30 := JTF_VARCHAR2_TABLE_100();
235: a31 := JTF_VARCHAR2_TABLE_100();
236: a32 := JTF_VARCHAR2_TABLE_500();
237: a33 := JTF_VARCHAR2_TABLE_500();
238: a34 := JTF_NUMBER_TABLE();
239: a35 := JTF_NUMBER_TABLE();
236: a32 := JTF_VARCHAR2_TABLE_500();
237: a33 := JTF_VARCHAR2_TABLE_500();
238: a34 := JTF_NUMBER_TABLE();
239: a35 := JTF_NUMBER_TABLE();
240: a36 := JTF_VARCHAR2_TABLE_100();
241: a37 := JTF_VARCHAR2_TABLE_2000();
242: a38 := JTF_VARCHAR2_TABLE_100();
243: a39 := JTF_VARCHAR2_TABLE_100();
244: if t.count > 0 then
238: a34 := JTF_NUMBER_TABLE();
239: a35 := JTF_NUMBER_TABLE();
240: a36 := JTF_VARCHAR2_TABLE_100();
241: a37 := JTF_VARCHAR2_TABLE_2000();
242: a38 := JTF_VARCHAR2_TABLE_100();
243: a39 := JTF_VARCHAR2_TABLE_100();
244: if t.count > 0 then
245: a0.extend(t.count);
246: a1.extend(t.count);
239: a35 := JTF_NUMBER_TABLE();
240: a36 := JTF_VARCHAR2_TABLE_100();
241: a37 := JTF_VARCHAR2_TABLE_2000();
242: a38 := JTF_VARCHAR2_TABLE_100();
243: a39 := JTF_VARCHAR2_TABLE_100();
244: if t.count > 0 then
245: a0.extend(t.count);
246: a1.extend(t.count);
247: a2.extend(t.count);
337:
338: procedure rosetta_table_copy_in_p5(t out nocopy okl_cld_pvt.cld_tbl_type, a0 JTF_NUMBER_TABLE
339: , a1 JTF_NUMBER_TABLE
340: , a2 JTF_NUMBER_TABLE
341: , a3 JTF_VARCHAR2_TABLE_100
342: , a4 JTF_VARCHAR2_TABLE_100
343: , a5 JTF_VARCHAR2_TABLE_500
344: , a6 JTF_VARCHAR2_TABLE_500
345: , a7 JTF_VARCHAR2_TABLE_500
338: procedure rosetta_table_copy_in_p5(t out nocopy okl_cld_pvt.cld_tbl_type, a0 JTF_NUMBER_TABLE
339: , a1 JTF_NUMBER_TABLE
340: , a2 JTF_NUMBER_TABLE
341: , a3 JTF_VARCHAR2_TABLE_100
342: , a4 JTF_VARCHAR2_TABLE_100
343: , a5 JTF_VARCHAR2_TABLE_500
344: , a6 JTF_VARCHAR2_TABLE_500
345: , a7 JTF_VARCHAR2_TABLE_500
346: , a8 JTF_VARCHAR2_TABLE_500
364: , a26 JTF_DATE_TABLE
365: , a27 JTF_NUMBER_TABLE
366: , a28 JTF_DATE_TABLE
367: , a29 JTF_NUMBER_TABLE
368: , a30 JTF_VARCHAR2_TABLE_100
369: , a31 JTF_VARCHAR2_TABLE_100
370: , a32 JTF_VARCHAR2_TABLE_500
371: , a33 JTF_VARCHAR2_TABLE_500
372: , a34 JTF_NUMBER_TABLE
365: , a27 JTF_NUMBER_TABLE
366: , a28 JTF_DATE_TABLE
367: , a29 JTF_NUMBER_TABLE
368: , a30 JTF_VARCHAR2_TABLE_100
369: , a31 JTF_VARCHAR2_TABLE_100
370: , a32 JTF_VARCHAR2_TABLE_500
371: , a33 JTF_VARCHAR2_TABLE_500
372: , a34 JTF_NUMBER_TABLE
373: , a35 JTF_NUMBER_TABLE
370: , a32 JTF_VARCHAR2_TABLE_500
371: , a33 JTF_VARCHAR2_TABLE_500
372: , a34 JTF_NUMBER_TABLE
373: , a35 JTF_NUMBER_TABLE
374: , a36 JTF_VARCHAR2_TABLE_100
375: , a37 JTF_VARCHAR2_TABLE_2000
376: , a38 JTF_VARCHAR2_TABLE_100
377: , a39 JTF_VARCHAR2_TABLE_100
378: ) as
372: , a34 JTF_NUMBER_TABLE
373: , a35 JTF_NUMBER_TABLE
374: , a36 JTF_VARCHAR2_TABLE_100
375: , a37 JTF_VARCHAR2_TABLE_2000
376: , a38 JTF_VARCHAR2_TABLE_100
377: , a39 JTF_VARCHAR2_TABLE_100
378: ) as
379: ddindx binary_integer; indx binary_integer;
380: begin
373: , a35 JTF_NUMBER_TABLE
374: , a36 JTF_VARCHAR2_TABLE_100
375: , a37 JTF_VARCHAR2_TABLE_2000
376: , a38 JTF_VARCHAR2_TABLE_100
377: , a39 JTF_VARCHAR2_TABLE_100
378: ) as
379: ddindx binary_integer; indx binary_integer;
380: begin
381: if a0 is not null and a0.count > 0 then
434: end rosetta_table_copy_in_p5;
435: procedure rosetta_table_copy_out_p5(t okl_cld_pvt.cld_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
436: , a1 out nocopy JTF_NUMBER_TABLE
437: , a2 out nocopy JTF_NUMBER_TABLE
438: , a3 out nocopy JTF_VARCHAR2_TABLE_100
439: , a4 out nocopy JTF_VARCHAR2_TABLE_100
440: , a5 out nocopy JTF_VARCHAR2_TABLE_500
441: , a6 out nocopy JTF_VARCHAR2_TABLE_500
442: , a7 out nocopy JTF_VARCHAR2_TABLE_500
435: procedure rosetta_table_copy_out_p5(t okl_cld_pvt.cld_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
436: , a1 out nocopy JTF_NUMBER_TABLE
437: , a2 out nocopy JTF_NUMBER_TABLE
438: , a3 out nocopy JTF_VARCHAR2_TABLE_100
439: , a4 out nocopy JTF_VARCHAR2_TABLE_100
440: , a5 out nocopy JTF_VARCHAR2_TABLE_500
441: , a6 out nocopy JTF_VARCHAR2_TABLE_500
442: , a7 out nocopy JTF_VARCHAR2_TABLE_500
443: , a8 out nocopy JTF_VARCHAR2_TABLE_500
461: , a26 out nocopy JTF_DATE_TABLE
462: , a27 out nocopy JTF_NUMBER_TABLE
463: , a28 out nocopy JTF_DATE_TABLE
464: , a29 out nocopy JTF_NUMBER_TABLE
465: , a30 out nocopy JTF_VARCHAR2_TABLE_100
466: , a31 out nocopy JTF_VARCHAR2_TABLE_100
467: , a32 out nocopy JTF_VARCHAR2_TABLE_500
468: , a33 out nocopy JTF_VARCHAR2_TABLE_500
469: , a34 out nocopy JTF_NUMBER_TABLE
462: , a27 out nocopy JTF_NUMBER_TABLE
463: , a28 out nocopy JTF_DATE_TABLE
464: , a29 out nocopy JTF_NUMBER_TABLE
465: , a30 out nocopy JTF_VARCHAR2_TABLE_100
466: , a31 out nocopy JTF_VARCHAR2_TABLE_100
467: , a32 out nocopy JTF_VARCHAR2_TABLE_500
468: , a33 out nocopy JTF_VARCHAR2_TABLE_500
469: , a34 out nocopy JTF_NUMBER_TABLE
470: , a35 out nocopy JTF_NUMBER_TABLE
467: , a32 out nocopy JTF_VARCHAR2_TABLE_500
468: , a33 out nocopy JTF_VARCHAR2_TABLE_500
469: , a34 out nocopy JTF_NUMBER_TABLE
470: , a35 out nocopy JTF_NUMBER_TABLE
471: , a36 out nocopy JTF_VARCHAR2_TABLE_100
472: , a37 out nocopy JTF_VARCHAR2_TABLE_2000
473: , a38 out nocopy JTF_VARCHAR2_TABLE_100
474: , a39 out nocopy JTF_VARCHAR2_TABLE_100
475: ) as
469: , a34 out nocopy JTF_NUMBER_TABLE
470: , a35 out nocopy JTF_NUMBER_TABLE
471: , a36 out nocopy JTF_VARCHAR2_TABLE_100
472: , a37 out nocopy JTF_VARCHAR2_TABLE_2000
473: , a38 out nocopy JTF_VARCHAR2_TABLE_100
474: , a39 out nocopy JTF_VARCHAR2_TABLE_100
475: ) as
476: ddindx binary_integer; indx binary_integer;
477: begin
470: , a35 out nocopy JTF_NUMBER_TABLE
471: , a36 out nocopy JTF_VARCHAR2_TABLE_100
472: , a37 out nocopy JTF_VARCHAR2_TABLE_2000
473: , a38 out nocopy JTF_VARCHAR2_TABLE_100
474: , a39 out nocopy JTF_VARCHAR2_TABLE_100
475: ) as
476: ddindx binary_integer; indx binary_integer;
477: begin
478: if t is null or t.count = 0 then
478: if t is null or t.count = 0 then
479: a0 := JTF_NUMBER_TABLE();
480: a1 := JTF_NUMBER_TABLE();
481: a2 := JTF_NUMBER_TABLE();
482: a3 := JTF_VARCHAR2_TABLE_100();
483: a4 := JTF_VARCHAR2_TABLE_100();
484: a5 := JTF_VARCHAR2_TABLE_500();
485: a6 := JTF_VARCHAR2_TABLE_500();
486: a7 := JTF_VARCHAR2_TABLE_500();
479: a0 := JTF_NUMBER_TABLE();
480: a1 := JTF_NUMBER_TABLE();
481: a2 := JTF_NUMBER_TABLE();
482: a3 := JTF_VARCHAR2_TABLE_100();
483: a4 := JTF_VARCHAR2_TABLE_100();
484: a5 := JTF_VARCHAR2_TABLE_500();
485: a6 := JTF_VARCHAR2_TABLE_500();
486: a7 := JTF_VARCHAR2_TABLE_500();
487: a8 := JTF_VARCHAR2_TABLE_500();
505: a26 := JTF_DATE_TABLE();
506: a27 := JTF_NUMBER_TABLE();
507: a28 := JTF_DATE_TABLE();
508: a29 := JTF_NUMBER_TABLE();
509: a30 := JTF_VARCHAR2_TABLE_100();
510: a31 := JTF_VARCHAR2_TABLE_100();
511: a32 := JTF_VARCHAR2_TABLE_500();
512: a33 := JTF_VARCHAR2_TABLE_500();
513: a34 := JTF_NUMBER_TABLE();
506: a27 := JTF_NUMBER_TABLE();
507: a28 := JTF_DATE_TABLE();
508: a29 := JTF_NUMBER_TABLE();
509: a30 := JTF_VARCHAR2_TABLE_100();
510: a31 := JTF_VARCHAR2_TABLE_100();
511: a32 := JTF_VARCHAR2_TABLE_500();
512: a33 := JTF_VARCHAR2_TABLE_500();
513: a34 := JTF_NUMBER_TABLE();
514: a35 := JTF_NUMBER_TABLE();
511: a32 := JTF_VARCHAR2_TABLE_500();
512: a33 := JTF_VARCHAR2_TABLE_500();
513: a34 := JTF_NUMBER_TABLE();
514: a35 := JTF_NUMBER_TABLE();
515: a36 := JTF_VARCHAR2_TABLE_100();
516: a37 := JTF_VARCHAR2_TABLE_2000();
517: a38 := JTF_VARCHAR2_TABLE_100();
518: a39 := JTF_VARCHAR2_TABLE_100();
519: else
513: a34 := JTF_NUMBER_TABLE();
514: a35 := JTF_NUMBER_TABLE();
515: a36 := JTF_VARCHAR2_TABLE_100();
516: a37 := JTF_VARCHAR2_TABLE_2000();
517: a38 := JTF_VARCHAR2_TABLE_100();
518: a39 := JTF_VARCHAR2_TABLE_100();
519: else
520: a0 := JTF_NUMBER_TABLE();
521: a1 := JTF_NUMBER_TABLE();
514: a35 := JTF_NUMBER_TABLE();
515: a36 := JTF_VARCHAR2_TABLE_100();
516: a37 := JTF_VARCHAR2_TABLE_2000();
517: a38 := JTF_VARCHAR2_TABLE_100();
518: a39 := JTF_VARCHAR2_TABLE_100();
519: else
520: a0 := JTF_NUMBER_TABLE();
521: a1 := JTF_NUMBER_TABLE();
522: a2 := JTF_NUMBER_TABLE();
519: else
520: a0 := JTF_NUMBER_TABLE();
521: a1 := JTF_NUMBER_TABLE();
522: a2 := JTF_NUMBER_TABLE();
523: a3 := JTF_VARCHAR2_TABLE_100();
524: a4 := JTF_VARCHAR2_TABLE_100();
525: a5 := JTF_VARCHAR2_TABLE_500();
526: a6 := JTF_VARCHAR2_TABLE_500();
527: a7 := JTF_VARCHAR2_TABLE_500();
520: a0 := JTF_NUMBER_TABLE();
521: a1 := JTF_NUMBER_TABLE();
522: a2 := JTF_NUMBER_TABLE();
523: a3 := JTF_VARCHAR2_TABLE_100();
524: a4 := JTF_VARCHAR2_TABLE_100();
525: a5 := JTF_VARCHAR2_TABLE_500();
526: a6 := JTF_VARCHAR2_TABLE_500();
527: a7 := JTF_VARCHAR2_TABLE_500();
528: a8 := JTF_VARCHAR2_TABLE_500();
546: a26 := JTF_DATE_TABLE();
547: a27 := JTF_NUMBER_TABLE();
548: a28 := JTF_DATE_TABLE();
549: a29 := JTF_NUMBER_TABLE();
550: a30 := JTF_VARCHAR2_TABLE_100();
551: a31 := JTF_VARCHAR2_TABLE_100();
552: a32 := JTF_VARCHAR2_TABLE_500();
553: a33 := JTF_VARCHAR2_TABLE_500();
554: a34 := JTF_NUMBER_TABLE();
547: a27 := JTF_NUMBER_TABLE();
548: a28 := JTF_DATE_TABLE();
549: a29 := JTF_NUMBER_TABLE();
550: a30 := JTF_VARCHAR2_TABLE_100();
551: a31 := JTF_VARCHAR2_TABLE_100();
552: a32 := JTF_VARCHAR2_TABLE_500();
553: a33 := JTF_VARCHAR2_TABLE_500();
554: a34 := JTF_NUMBER_TABLE();
555: a35 := JTF_NUMBER_TABLE();
552: a32 := JTF_VARCHAR2_TABLE_500();
553: a33 := JTF_VARCHAR2_TABLE_500();
554: a34 := JTF_NUMBER_TABLE();
555: a35 := JTF_NUMBER_TABLE();
556: a36 := JTF_VARCHAR2_TABLE_100();
557: a37 := JTF_VARCHAR2_TABLE_2000();
558: a38 := JTF_VARCHAR2_TABLE_100();
559: a39 := JTF_VARCHAR2_TABLE_100();
560: if t.count > 0 then
554: a34 := JTF_NUMBER_TABLE();
555: a35 := JTF_NUMBER_TABLE();
556: a36 := JTF_VARCHAR2_TABLE_100();
557: a37 := JTF_VARCHAR2_TABLE_2000();
558: a38 := JTF_VARCHAR2_TABLE_100();
559: a39 := JTF_VARCHAR2_TABLE_100();
560: if t.count > 0 then
561: a0.extend(t.count);
562: a1.extend(t.count);
555: a35 := JTF_NUMBER_TABLE();
556: a36 := JTF_VARCHAR2_TABLE_100();
557: a37 := JTF_VARCHAR2_TABLE_2000();
558: a38 := JTF_VARCHAR2_TABLE_100();
559: a39 := JTF_VARCHAR2_TABLE_100();
560: if t.count > 0 then
561: a0.extend(t.count);
562: a1.extend(t.count);
563: a2.extend(t.count);
857: , x_msg_data out nocopy VARCHAR2
858: , p5_a0 JTF_NUMBER_TABLE
859: , p5_a1 JTF_NUMBER_TABLE
860: , p5_a2 JTF_NUMBER_TABLE
861: , p5_a3 JTF_VARCHAR2_TABLE_100
862: , p5_a4 JTF_VARCHAR2_TABLE_100
863: , p5_a5 JTF_VARCHAR2_TABLE_500
864: , p5_a6 JTF_VARCHAR2_TABLE_500
865: , p5_a7 JTF_VARCHAR2_TABLE_500
858: , p5_a0 JTF_NUMBER_TABLE
859: , p5_a1 JTF_NUMBER_TABLE
860: , p5_a2 JTF_NUMBER_TABLE
861: , p5_a3 JTF_VARCHAR2_TABLE_100
862: , p5_a4 JTF_VARCHAR2_TABLE_100
863: , p5_a5 JTF_VARCHAR2_TABLE_500
864: , p5_a6 JTF_VARCHAR2_TABLE_500
865: , p5_a7 JTF_VARCHAR2_TABLE_500
866: , p5_a8 JTF_VARCHAR2_TABLE_500
884: , p5_a26 JTF_DATE_TABLE
885: , p5_a27 JTF_NUMBER_TABLE
886: , p5_a28 JTF_DATE_TABLE
887: , p5_a29 JTF_NUMBER_TABLE
888: , p5_a30 JTF_VARCHAR2_TABLE_100
889: , p5_a31 JTF_VARCHAR2_TABLE_100
890: , p5_a32 JTF_VARCHAR2_TABLE_500
891: , p5_a33 JTF_VARCHAR2_TABLE_500
892: , p5_a34 JTF_NUMBER_TABLE
885: , p5_a27 JTF_NUMBER_TABLE
886: , p5_a28 JTF_DATE_TABLE
887: , p5_a29 JTF_NUMBER_TABLE
888: , p5_a30 JTF_VARCHAR2_TABLE_100
889: , p5_a31 JTF_VARCHAR2_TABLE_100
890: , p5_a32 JTF_VARCHAR2_TABLE_500
891: , p5_a33 JTF_VARCHAR2_TABLE_500
892: , p5_a34 JTF_NUMBER_TABLE
893: , p5_a35 JTF_NUMBER_TABLE
890: , p5_a32 JTF_VARCHAR2_TABLE_500
891: , p5_a33 JTF_VARCHAR2_TABLE_500
892: , p5_a34 JTF_NUMBER_TABLE
893: , p5_a35 JTF_NUMBER_TABLE
894: , p5_a36 JTF_VARCHAR2_TABLE_100
895: , p5_a37 JTF_VARCHAR2_TABLE_2000
896: , p5_a38 JTF_VARCHAR2_TABLE_100
897: , p5_a39 JTF_VARCHAR2_TABLE_100
898: , p6_a0 out nocopy JTF_NUMBER_TABLE
892: , p5_a34 JTF_NUMBER_TABLE
893: , p5_a35 JTF_NUMBER_TABLE
894: , p5_a36 JTF_VARCHAR2_TABLE_100
895: , p5_a37 JTF_VARCHAR2_TABLE_2000
896: , p5_a38 JTF_VARCHAR2_TABLE_100
897: , p5_a39 JTF_VARCHAR2_TABLE_100
898: , p6_a0 out nocopy JTF_NUMBER_TABLE
899: , p6_a1 out nocopy JTF_NUMBER_TABLE
900: , p6_a2 out nocopy JTF_NUMBER_TABLE
893: , p5_a35 JTF_NUMBER_TABLE
894: , p5_a36 JTF_VARCHAR2_TABLE_100
895: , p5_a37 JTF_VARCHAR2_TABLE_2000
896: , p5_a38 JTF_VARCHAR2_TABLE_100
897: , p5_a39 JTF_VARCHAR2_TABLE_100
898: , p6_a0 out nocopy JTF_NUMBER_TABLE
899: , p6_a1 out nocopy JTF_NUMBER_TABLE
900: , p6_a2 out nocopy JTF_NUMBER_TABLE
901: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
897: , p5_a39 JTF_VARCHAR2_TABLE_100
898: , p6_a0 out nocopy JTF_NUMBER_TABLE
899: , p6_a1 out nocopy JTF_NUMBER_TABLE
900: , p6_a2 out nocopy JTF_NUMBER_TABLE
901: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
902: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
903: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500
904: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
905: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
898: , p6_a0 out nocopy JTF_NUMBER_TABLE
899: , p6_a1 out nocopy JTF_NUMBER_TABLE
900: , p6_a2 out nocopy JTF_NUMBER_TABLE
901: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
902: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
903: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500
904: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
905: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
906: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
924: , p6_a26 out nocopy JTF_DATE_TABLE
925: , p6_a27 out nocopy JTF_NUMBER_TABLE
926: , p6_a28 out nocopy JTF_DATE_TABLE
927: , p6_a29 out nocopy JTF_NUMBER_TABLE
928: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
929: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100
930: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
931: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
932: , p6_a34 out nocopy JTF_NUMBER_TABLE
925: , p6_a27 out nocopy JTF_NUMBER_TABLE
926: , p6_a28 out nocopy JTF_DATE_TABLE
927: , p6_a29 out nocopy JTF_NUMBER_TABLE
928: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
929: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100
930: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
931: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
932: , p6_a34 out nocopy JTF_NUMBER_TABLE
933: , p6_a35 out nocopy JTF_NUMBER_TABLE
930: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
931: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
932: , p6_a34 out nocopy JTF_NUMBER_TABLE
933: , p6_a35 out nocopy JTF_NUMBER_TABLE
934: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
935: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_2000
936: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
937: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
938: , p7_a0 in out nocopy JTF_NUMBER_TABLE
932: , p6_a34 out nocopy JTF_NUMBER_TABLE
933: , p6_a35 out nocopy JTF_NUMBER_TABLE
934: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
935: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_2000
936: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
937: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
938: , p7_a0 in out nocopy JTF_NUMBER_TABLE
939: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
940: , p7_a2 in out nocopy JTF_NUMBER_TABLE
933: , p6_a35 out nocopy JTF_NUMBER_TABLE
934: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
935: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_2000
936: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
937: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
938: , p7_a0 in out nocopy JTF_NUMBER_TABLE
939: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
940: , p7_a2 in out nocopy JTF_NUMBER_TABLE
941: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
935: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_2000
936: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
937: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
938: , p7_a0 in out nocopy JTF_NUMBER_TABLE
939: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
940: , p7_a2 in out nocopy JTF_NUMBER_TABLE
941: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
942: , p7_a4 in out nocopy JTF_NUMBER_TABLE
943: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
939: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
940: , p7_a2 in out nocopy JTF_NUMBER_TABLE
941: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
942: , p7_a4 in out nocopy JTF_NUMBER_TABLE
943: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
944: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
945: )
946:
947: as
940: , p7_a2 in out nocopy JTF_NUMBER_TABLE
941: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
942: , p7_a4 in out nocopy JTF_NUMBER_TABLE
943: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
944: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
945: )
946:
947: as
948: ddp_cldv_tbl okl_cld_pvt.cldv_tbl_type;
1085: , x_msg_data out nocopy VARCHAR2
1086: , p5_a0 JTF_NUMBER_TABLE
1087: , p5_a1 JTF_NUMBER_TABLE
1088: , p5_a2 JTF_NUMBER_TABLE
1089: , p5_a3 JTF_VARCHAR2_TABLE_100
1090: , p5_a4 JTF_VARCHAR2_TABLE_100
1091: , p5_a5 JTF_VARCHAR2_TABLE_500
1092: , p5_a6 JTF_VARCHAR2_TABLE_500
1093: , p5_a7 JTF_VARCHAR2_TABLE_500
1086: , p5_a0 JTF_NUMBER_TABLE
1087: , p5_a1 JTF_NUMBER_TABLE
1088: , p5_a2 JTF_NUMBER_TABLE
1089: , p5_a3 JTF_VARCHAR2_TABLE_100
1090: , p5_a4 JTF_VARCHAR2_TABLE_100
1091: , p5_a5 JTF_VARCHAR2_TABLE_500
1092: , p5_a6 JTF_VARCHAR2_TABLE_500
1093: , p5_a7 JTF_VARCHAR2_TABLE_500
1094: , p5_a8 JTF_VARCHAR2_TABLE_500
1112: , p5_a26 JTF_DATE_TABLE
1113: , p5_a27 JTF_NUMBER_TABLE
1114: , p5_a28 JTF_DATE_TABLE
1115: , p5_a29 JTF_NUMBER_TABLE
1116: , p5_a30 JTF_VARCHAR2_TABLE_100
1117: , p5_a31 JTF_VARCHAR2_TABLE_100
1118: , p5_a32 JTF_VARCHAR2_TABLE_500
1119: , p5_a33 JTF_VARCHAR2_TABLE_500
1120: , p5_a34 JTF_NUMBER_TABLE
1113: , p5_a27 JTF_NUMBER_TABLE
1114: , p5_a28 JTF_DATE_TABLE
1115: , p5_a29 JTF_NUMBER_TABLE
1116: , p5_a30 JTF_VARCHAR2_TABLE_100
1117: , p5_a31 JTF_VARCHAR2_TABLE_100
1118: , p5_a32 JTF_VARCHAR2_TABLE_500
1119: , p5_a33 JTF_VARCHAR2_TABLE_500
1120: , p5_a34 JTF_NUMBER_TABLE
1121: , p5_a35 JTF_NUMBER_TABLE
1118: , p5_a32 JTF_VARCHAR2_TABLE_500
1119: , p5_a33 JTF_VARCHAR2_TABLE_500
1120: , p5_a34 JTF_NUMBER_TABLE
1121: , p5_a35 JTF_NUMBER_TABLE
1122: , p5_a36 JTF_VARCHAR2_TABLE_100
1123: , p5_a37 JTF_VARCHAR2_TABLE_2000
1124: , p5_a38 JTF_VARCHAR2_TABLE_100
1125: , p5_a39 JTF_VARCHAR2_TABLE_100
1126: , p6_a0 out nocopy JTF_NUMBER_TABLE
1120: , p5_a34 JTF_NUMBER_TABLE
1121: , p5_a35 JTF_NUMBER_TABLE
1122: , p5_a36 JTF_VARCHAR2_TABLE_100
1123: , p5_a37 JTF_VARCHAR2_TABLE_2000
1124: , p5_a38 JTF_VARCHAR2_TABLE_100
1125: , p5_a39 JTF_VARCHAR2_TABLE_100
1126: , p6_a0 out nocopy JTF_NUMBER_TABLE
1127: , p6_a1 out nocopy JTF_NUMBER_TABLE
1128: , p6_a2 out nocopy JTF_NUMBER_TABLE
1121: , p5_a35 JTF_NUMBER_TABLE
1122: , p5_a36 JTF_VARCHAR2_TABLE_100
1123: , p5_a37 JTF_VARCHAR2_TABLE_2000
1124: , p5_a38 JTF_VARCHAR2_TABLE_100
1125: , p5_a39 JTF_VARCHAR2_TABLE_100
1126: , p6_a0 out nocopy JTF_NUMBER_TABLE
1127: , p6_a1 out nocopy JTF_NUMBER_TABLE
1128: , p6_a2 out nocopy JTF_NUMBER_TABLE
1129: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1125: , p5_a39 JTF_VARCHAR2_TABLE_100
1126: , p6_a0 out nocopy JTF_NUMBER_TABLE
1127: , p6_a1 out nocopy JTF_NUMBER_TABLE
1128: , p6_a2 out nocopy JTF_NUMBER_TABLE
1129: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1130: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1131: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500
1132: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
1133: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
1126: , p6_a0 out nocopy JTF_NUMBER_TABLE
1127: , p6_a1 out nocopy JTF_NUMBER_TABLE
1128: , p6_a2 out nocopy JTF_NUMBER_TABLE
1129: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1130: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1131: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500
1132: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
1133: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
1134: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
1152: , p6_a26 out nocopy JTF_DATE_TABLE
1153: , p6_a27 out nocopy JTF_NUMBER_TABLE
1154: , p6_a28 out nocopy JTF_DATE_TABLE
1155: , p6_a29 out nocopy JTF_NUMBER_TABLE
1156: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
1157: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100
1158: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
1159: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
1160: , p6_a34 out nocopy JTF_NUMBER_TABLE
1153: , p6_a27 out nocopy JTF_NUMBER_TABLE
1154: , p6_a28 out nocopy JTF_DATE_TABLE
1155: , p6_a29 out nocopy JTF_NUMBER_TABLE
1156: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
1157: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100
1158: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
1159: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
1160: , p6_a34 out nocopy JTF_NUMBER_TABLE
1161: , p6_a35 out nocopy JTF_NUMBER_TABLE
1158: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
1159: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
1160: , p6_a34 out nocopy JTF_NUMBER_TABLE
1161: , p6_a35 out nocopy JTF_NUMBER_TABLE
1162: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
1163: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_2000
1164: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
1165: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
1166: )
1160: , p6_a34 out nocopy JTF_NUMBER_TABLE
1161: , p6_a35 out nocopy JTF_NUMBER_TABLE
1162: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
1163: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_2000
1164: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
1165: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
1166: )
1167:
1168: as
1161: , p6_a35 out nocopy JTF_NUMBER_TABLE
1162: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
1163: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_2000
1164: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
1165: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
1166: )
1167:
1168: as
1169: ddp_cldv_tbl okl_cld_pvt.cldv_tbl_type;
1401: , x_msg_data out nocopy VARCHAR2
1402: , p5_a0 JTF_NUMBER_TABLE
1403: , p5_a1 JTF_NUMBER_TABLE
1404: , p5_a2 JTF_NUMBER_TABLE
1405: , p5_a3 JTF_VARCHAR2_TABLE_100
1406: , p5_a4 JTF_VARCHAR2_TABLE_100
1407: , p5_a5 JTF_VARCHAR2_TABLE_500
1408: , p5_a6 JTF_VARCHAR2_TABLE_500
1409: , p5_a7 JTF_VARCHAR2_TABLE_500
1402: , p5_a0 JTF_NUMBER_TABLE
1403: , p5_a1 JTF_NUMBER_TABLE
1404: , p5_a2 JTF_NUMBER_TABLE
1405: , p5_a3 JTF_VARCHAR2_TABLE_100
1406: , p5_a4 JTF_VARCHAR2_TABLE_100
1407: , p5_a5 JTF_VARCHAR2_TABLE_500
1408: , p5_a6 JTF_VARCHAR2_TABLE_500
1409: , p5_a7 JTF_VARCHAR2_TABLE_500
1410: , p5_a8 JTF_VARCHAR2_TABLE_500
1428: , p5_a26 JTF_DATE_TABLE
1429: , p5_a27 JTF_NUMBER_TABLE
1430: , p5_a28 JTF_DATE_TABLE
1431: , p5_a29 JTF_NUMBER_TABLE
1432: , p5_a30 JTF_VARCHAR2_TABLE_100
1433: , p5_a31 JTF_VARCHAR2_TABLE_100
1434: , p5_a32 JTF_VARCHAR2_TABLE_500
1435: , p5_a33 JTF_VARCHAR2_TABLE_500
1436: , p5_a34 JTF_NUMBER_TABLE
1429: , p5_a27 JTF_NUMBER_TABLE
1430: , p5_a28 JTF_DATE_TABLE
1431: , p5_a29 JTF_NUMBER_TABLE
1432: , p5_a30 JTF_VARCHAR2_TABLE_100
1433: , p5_a31 JTF_VARCHAR2_TABLE_100
1434: , p5_a32 JTF_VARCHAR2_TABLE_500
1435: , p5_a33 JTF_VARCHAR2_TABLE_500
1436: , p5_a34 JTF_NUMBER_TABLE
1437: , p5_a35 JTF_NUMBER_TABLE
1434: , p5_a32 JTF_VARCHAR2_TABLE_500
1435: , p5_a33 JTF_VARCHAR2_TABLE_500
1436: , p5_a34 JTF_NUMBER_TABLE
1437: , p5_a35 JTF_NUMBER_TABLE
1438: , p5_a36 JTF_VARCHAR2_TABLE_100
1439: , p5_a37 JTF_VARCHAR2_TABLE_2000
1440: , p5_a38 JTF_VARCHAR2_TABLE_100
1441: , p5_a39 JTF_VARCHAR2_TABLE_100
1442: , p6_a0 in out nocopy JTF_NUMBER_TABLE
1436: , p5_a34 JTF_NUMBER_TABLE
1437: , p5_a35 JTF_NUMBER_TABLE
1438: , p5_a36 JTF_VARCHAR2_TABLE_100
1439: , p5_a37 JTF_VARCHAR2_TABLE_2000
1440: , p5_a38 JTF_VARCHAR2_TABLE_100
1441: , p5_a39 JTF_VARCHAR2_TABLE_100
1442: , p6_a0 in out nocopy JTF_NUMBER_TABLE
1443: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1444: , p6_a2 in out nocopy JTF_NUMBER_TABLE
1437: , p5_a35 JTF_NUMBER_TABLE
1438: , p5_a36 JTF_VARCHAR2_TABLE_100
1439: , p5_a37 JTF_VARCHAR2_TABLE_2000
1440: , p5_a38 JTF_VARCHAR2_TABLE_100
1441: , p5_a39 JTF_VARCHAR2_TABLE_100
1442: , p6_a0 in out nocopy JTF_NUMBER_TABLE
1443: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1444: , p6_a2 in out nocopy JTF_NUMBER_TABLE
1445: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1439: , p5_a37 JTF_VARCHAR2_TABLE_2000
1440: , p5_a38 JTF_VARCHAR2_TABLE_100
1441: , p5_a39 JTF_VARCHAR2_TABLE_100
1442: , p6_a0 in out nocopy JTF_NUMBER_TABLE
1443: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1444: , p6_a2 in out nocopy JTF_NUMBER_TABLE
1445: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1446: , p6_a4 in out nocopy JTF_NUMBER_TABLE
1447: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1443: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1444: , p6_a2 in out nocopy JTF_NUMBER_TABLE
1445: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1446: , p6_a4 in out nocopy JTF_NUMBER_TABLE
1447: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1448: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
1449: )
1450:
1451: as
1444: , p6_a2 in out nocopy JTF_NUMBER_TABLE
1445: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1446: , p6_a4 in out nocopy JTF_NUMBER_TABLE
1447: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1448: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
1449: )
1450:
1451: as
1452: ddp_cldv_tbl okl_cld_pvt.cldv_tbl_type;
1544: , x_msg_data out nocopy VARCHAR2
1545: , p5_a0 JTF_NUMBER_TABLE
1546: , p5_a1 JTF_NUMBER_TABLE
1547: , p5_a2 JTF_NUMBER_TABLE
1548: , p5_a3 JTF_VARCHAR2_TABLE_100
1549: , p5_a4 JTF_VARCHAR2_TABLE_100
1550: , p5_a5 JTF_VARCHAR2_TABLE_500
1551: , p5_a6 JTF_VARCHAR2_TABLE_500
1552: , p5_a7 JTF_VARCHAR2_TABLE_500
1545: , p5_a0 JTF_NUMBER_TABLE
1546: , p5_a1 JTF_NUMBER_TABLE
1547: , p5_a2 JTF_NUMBER_TABLE
1548: , p5_a3 JTF_VARCHAR2_TABLE_100
1549: , p5_a4 JTF_VARCHAR2_TABLE_100
1550: , p5_a5 JTF_VARCHAR2_TABLE_500
1551: , p5_a6 JTF_VARCHAR2_TABLE_500
1552: , p5_a7 JTF_VARCHAR2_TABLE_500
1553: , p5_a8 JTF_VARCHAR2_TABLE_500
1571: , p5_a26 JTF_DATE_TABLE
1572: , p5_a27 JTF_NUMBER_TABLE
1573: , p5_a28 JTF_DATE_TABLE
1574: , p5_a29 JTF_NUMBER_TABLE
1575: , p5_a30 JTF_VARCHAR2_TABLE_100
1576: , p5_a31 JTF_VARCHAR2_TABLE_100
1577: , p5_a32 JTF_VARCHAR2_TABLE_500
1578: , p5_a33 JTF_VARCHAR2_TABLE_500
1579: , p5_a34 JTF_NUMBER_TABLE
1572: , p5_a27 JTF_NUMBER_TABLE
1573: , p5_a28 JTF_DATE_TABLE
1574: , p5_a29 JTF_NUMBER_TABLE
1575: , p5_a30 JTF_VARCHAR2_TABLE_100
1576: , p5_a31 JTF_VARCHAR2_TABLE_100
1577: , p5_a32 JTF_VARCHAR2_TABLE_500
1578: , p5_a33 JTF_VARCHAR2_TABLE_500
1579: , p5_a34 JTF_NUMBER_TABLE
1580: , p5_a35 JTF_NUMBER_TABLE
1577: , p5_a32 JTF_VARCHAR2_TABLE_500
1578: , p5_a33 JTF_VARCHAR2_TABLE_500
1579: , p5_a34 JTF_NUMBER_TABLE
1580: , p5_a35 JTF_NUMBER_TABLE
1581: , p5_a36 JTF_VARCHAR2_TABLE_100
1582: , p5_a37 JTF_VARCHAR2_TABLE_2000
1583: , p5_a38 JTF_VARCHAR2_TABLE_100
1584: , p5_a39 JTF_VARCHAR2_TABLE_100
1585: )
1579: , p5_a34 JTF_NUMBER_TABLE
1580: , p5_a35 JTF_NUMBER_TABLE
1581: , p5_a36 JTF_VARCHAR2_TABLE_100
1582: , p5_a37 JTF_VARCHAR2_TABLE_2000
1583: , p5_a38 JTF_VARCHAR2_TABLE_100
1584: , p5_a39 JTF_VARCHAR2_TABLE_100
1585: )
1586:
1587: as
1580: , p5_a35 JTF_NUMBER_TABLE
1581: , p5_a36 JTF_VARCHAR2_TABLE_100
1582: , p5_a37 JTF_VARCHAR2_TABLE_2000
1583: , p5_a38 JTF_VARCHAR2_TABLE_100
1584: , p5_a39 JTF_VARCHAR2_TABLE_100
1585: )
1586:
1587: as
1588: ddp_cldv_tbl okl_cld_pvt.cldv_tbl_type;
1859: , x_msg_data out nocopy VARCHAR2
1860: , p5_a0 JTF_NUMBER_TABLE
1861: , p5_a1 JTF_NUMBER_TABLE
1862: , p5_a2 JTF_NUMBER_TABLE
1863: , p5_a3 JTF_VARCHAR2_TABLE_100
1864: , p5_a4 JTF_VARCHAR2_TABLE_100
1865: , p5_a5 JTF_VARCHAR2_TABLE_500
1866: , p5_a6 JTF_VARCHAR2_TABLE_500
1867: , p5_a7 JTF_VARCHAR2_TABLE_500
1860: , p5_a0 JTF_NUMBER_TABLE
1861: , p5_a1 JTF_NUMBER_TABLE
1862: , p5_a2 JTF_NUMBER_TABLE
1863: , p5_a3 JTF_VARCHAR2_TABLE_100
1864: , p5_a4 JTF_VARCHAR2_TABLE_100
1865: , p5_a5 JTF_VARCHAR2_TABLE_500
1866: , p5_a6 JTF_VARCHAR2_TABLE_500
1867: , p5_a7 JTF_VARCHAR2_TABLE_500
1868: , p5_a8 JTF_VARCHAR2_TABLE_500
1886: , p5_a26 JTF_DATE_TABLE
1887: , p5_a27 JTF_NUMBER_TABLE
1888: , p5_a28 JTF_DATE_TABLE
1889: , p5_a29 JTF_NUMBER_TABLE
1890: , p5_a30 JTF_VARCHAR2_TABLE_100
1891: , p5_a31 JTF_VARCHAR2_TABLE_100
1892: , p5_a32 JTF_VARCHAR2_TABLE_500
1893: , p5_a33 JTF_VARCHAR2_TABLE_500
1894: , p5_a34 JTF_NUMBER_TABLE
1887: , p5_a27 JTF_NUMBER_TABLE
1888: , p5_a28 JTF_DATE_TABLE
1889: , p5_a29 JTF_NUMBER_TABLE
1890: , p5_a30 JTF_VARCHAR2_TABLE_100
1891: , p5_a31 JTF_VARCHAR2_TABLE_100
1892: , p5_a32 JTF_VARCHAR2_TABLE_500
1893: , p5_a33 JTF_VARCHAR2_TABLE_500
1894: , p5_a34 JTF_NUMBER_TABLE
1895: , p5_a35 JTF_NUMBER_TABLE
1892: , p5_a32 JTF_VARCHAR2_TABLE_500
1893: , p5_a33 JTF_VARCHAR2_TABLE_500
1894: , p5_a34 JTF_NUMBER_TABLE
1895: , p5_a35 JTF_NUMBER_TABLE
1896: , p5_a36 JTF_VARCHAR2_TABLE_100
1897: , p5_a37 JTF_VARCHAR2_TABLE_2000
1898: , p5_a38 JTF_VARCHAR2_TABLE_100
1899: , p5_a39 JTF_VARCHAR2_TABLE_100
1900: , p6_a0 out nocopy JTF_NUMBER_TABLE
1894: , p5_a34 JTF_NUMBER_TABLE
1895: , p5_a35 JTF_NUMBER_TABLE
1896: , p5_a36 JTF_VARCHAR2_TABLE_100
1897: , p5_a37 JTF_VARCHAR2_TABLE_2000
1898: , p5_a38 JTF_VARCHAR2_TABLE_100
1899: , p5_a39 JTF_VARCHAR2_TABLE_100
1900: , p6_a0 out nocopy JTF_NUMBER_TABLE
1901: , p6_a1 out nocopy JTF_NUMBER_TABLE
1902: , p6_a2 out nocopy JTF_NUMBER_TABLE
1895: , p5_a35 JTF_NUMBER_TABLE
1896: , p5_a36 JTF_VARCHAR2_TABLE_100
1897: , p5_a37 JTF_VARCHAR2_TABLE_2000
1898: , p5_a38 JTF_VARCHAR2_TABLE_100
1899: , p5_a39 JTF_VARCHAR2_TABLE_100
1900: , p6_a0 out nocopy JTF_NUMBER_TABLE
1901: , p6_a1 out nocopy JTF_NUMBER_TABLE
1902: , p6_a2 out nocopy JTF_NUMBER_TABLE
1903: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1899: , p5_a39 JTF_VARCHAR2_TABLE_100
1900: , p6_a0 out nocopy JTF_NUMBER_TABLE
1901: , p6_a1 out nocopy JTF_NUMBER_TABLE
1902: , p6_a2 out nocopy JTF_NUMBER_TABLE
1903: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1904: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1905: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500
1906: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
1907: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
1900: , p6_a0 out nocopy JTF_NUMBER_TABLE
1901: , p6_a1 out nocopy JTF_NUMBER_TABLE
1902: , p6_a2 out nocopy JTF_NUMBER_TABLE
1903: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1904: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1905: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500
1906: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
1907: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
1908: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
1926: , p6_a26 out nocopy JTF_DATE_TABLE
1927: , p6_a27 out nocopy JTF_NUMBER_TABLE
1928: , p6_a28 out nocopy JTF_DATE_TABLE
1929: , p6_a29 out nocopy JTF_NUMBER_TABLE
1930: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
1931: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100
1932: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
1933: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
1934: , p6_a34 out nocopy JTF_NUMBER_TABLE
1927: , p6_a27 out nocopy JTF_NUMBER_TABLE
1928: , p6_a28 out nocopy JTF_DATE_TABLE
1929: , p6_a29 out nocopy JTF_NUMBER_TABLE
1930: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
1931: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100
1932: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
1933: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
1934: , p6_a34 out nocopy JTF_NUMBER_TABLE
1935: , p6_a35 out nocopy JTF_NUMBER_TABLE
1932: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
1933: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
1934: , p6_a34 out nocopy JTF_NUMBER_TABLE
1935: , p6_a35 out nocopy JTF_NUMBER_TABLE
1936: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
1937: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_2000
1938: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
1939: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
1940: , p7_a0 in out nocopy JTF_NUMBER_TABLE
1934: , p6_a34 out nocopy JTF_NUMBER_TABLE
1935: , p6_a35 out nocopy JTF_NUMBER_TABLE
1936: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
1937: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_2000
1938: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
1939: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
1940: , p7_a0 in out nocopy JTF_NUMBER_TABLE
1941: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1942: , p7_a2 in out nocopy JTF_NUMBER_TABLE
1935: , p6_a35 out nocopy JTF_NUMBER_TABLE
1936: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
1937: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_2000
1938: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
1939: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
1940: , p7_a0 in out nocopy JTF_NUMBER_TABLE
1941: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1942: , p7_a2 in out nocopy JTF_NUMBER_TABLE
1943: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1937: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_2000
1938: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
1939: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
1940: , p7_a0 in out nocopy JTF_NUMBER_TABLE
1941: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1942: , p7_a2 in out nocopy JTF_NUMBER_TABLE
1943: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1944: , p7_a4 in out nocopy JTF_NUMBER_TABLE
1945: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1941: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1942: , p7_a2 in out nocopy JTF_NUMBER_TABLE
1943: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1944: , p7_a4 in out nocopy JTF_NUMBER_TABLE
1945: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1946: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
1947: )
1948:
1949: as
1942: , p7_a2 in out nocopy JTF_NUMBER_TABLE
1943: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
1944: , p7_a4 in out nocopy JTF_NUMBER_TABLE
1945: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1946: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
1947: )
1948:
1949: as
1950: ddp_cldv_tbl okl_cld_pvt.cldv_tbl_type;
2087: , x_msg_data out nocopy VARCHAR2
2088: , p5_a0 JTF_NUMBER_TABLE
2089: , p5_a1 JTF_NUMBER_TABLE
2090: , p5_a2 JTF_NUMBER_TABLE
2091: , p5_a3 JTF_VARCHAR2_TABLE_100
2092: , p5_a4 JTF_VARCHAR2_TABLE_100
2093: , p5_a5 JTF_VARCHAR2_TABLE_500
2094: , p5_a6 JTF_VARCHAR2_TABLE_500
2095: , p5_a7 JTF_VARCHAR2_TABLE_500
2088: , p5_a0 JTF_NUMBER_TABLE
2089: , p5_a1 JTF_NUMBER_TABLE
2090: , p5_a2 JTF_NUMBER_TABLE
2091: , p5_a3 JTF_VARCHAR2_TABLE_100
2092: , p5_a4 JTF_VARCHAR2_TABLE_100
2093: , p5_a5 JTF_VARCHAR2_TABLE_500
2094: , p5_a6 JTF_VARCHAR2_TABLE_500
2095: , p5_a7 JTF_VARCHAR2_TABLE_500
2096: , p5_a8 JTF_VARCHAR2_TABLE_500
2114: , p5_a26 JTF_DATE_TABLE
2115: , p5_a27 JTF_NUMBER_TABLE
2116: , p5_a28 JTF_DATE_TABLE
2117: , p5_a29 JTF_NUMBER_TABLE
2118: , p5_a30 JTF_VARCHAR2_TABLE_100
2119: , p5_a31 JTF_VARCHAR2_TABLE_100
2120: , p5_a32 JTF_VARCHAR2_TABLE_500
2121: , p5_a33 JTF_VARCHAR2_TABLE_500
2122: , p5_a34 JTF_NUMBER_TABLE
2115: , p5_a27 JTF_NUMBER_TABLE
2116: , p5_a28 JTF_DATE_TABLE
2117: , p5_a29 JTF_NUMBER_TABLE
2118: , p5_a30 JTF_VARCHAR2_TABLE_100
2119: , p5_a31 JTF_VARCHAR2_TABLE_100
2120: , p5_a32 JTF_VARCHAR2_TABLE_500
2121: , p5_a33 JTF_VARCHAR2_TABLE_500
2122: , p5_a34 JTF_NUMBER_TABLE
2123: , p5_a35 JTF_NUMBER_TABLE
2120: , p5_a32 JTF_VARCHAR2_TABLE_500
2121: , p5_a33 JTF_VARCHAR2_TABLE_500
2122: , p5_a34 JTF_NUMBER_TABLE
2123: , p5_a35 JTF_NUMBER_TABLE
2124: , p5_a36 JTF_VARCHAR2_TABLE_100
2125: , p5_a37 JTF_VARCHAR2_TABLE_2000
2126: , p5_a38 JTF_VARCHAR2_TABLE_100
2127: , p5_a39 JTF_VARCHAR2_TABLE_100
2128: , p6_a0 out nocopy JTF_NUMBER_TABLE
2122: , p5_a34 JTF_NUMBER_TABLE
2123: , p5_a35 JTF_NUMBER_TABLE
2124: , p5_a36 JTF_VARCHAR2_TABLE_100
2125: , p5_a37 JTF_VARCHAR2_TABLE_2000
2126: , p5_a38 JTF_VARCHAR2_TABLE_100
2127: , p5_a39 JTF_VARCHAR2_TABLE_100
2128: , p6_a0 out nocopy JTF_NUMBER_TABLE
2129: , p6_a1 out nocopy JTF_NUMBER_TABLE
2130: , p6_a2 out nocopy JTF_NUMBER_TABLE
2123: , p5_a35 JTF_NUMBER_TABLE
2124: , p5_a36 JTF_VARCHAR2_TABLE_100
2125: , p5_a37 JTF_VARCHAR2_TABLE_2000
2126: , p5_a38 JTF_VARCHAR2_TABLE_100
2127: , p5_a39 JTF_VARCHAR2_TABLE_100
2128: , p6_a0 out nocopy JTF_NUMBER_TABLE
2129: , p6_a1 out nocopy JTF_NUMBER_TABLE
2130: , p6_a2 out nocopy JTF_NUMBER_TABLE
2131: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
2127: , p5_a39 JTF_VARCHAR2_TABLE_100
2128: , p6_a0 out nocopy JTF_NUMBER_TABLE
2129: , p6_a1 out nocopy JTF_NUMBER_TABLE
2130: , p6_a2 out nocopy JTF_NUMBER_TABLE
2131: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
2132: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
2133: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500
2134: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
2135: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
2128: , p6_a0 out nocopy JTF_NUMBER_TABLE
2129: , p6_a1 out nocopy JTF_NUMBER_TABLE
2130: , p6_a2 out nocopy JTF_NUMBER_TABLE
2131: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
2132: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
2133: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500
2134: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
2135: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
2136: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
2154: , p6_a26 out nocopy JTF_DATE_TABLE
2155: , p6_a27 out nocopy JTF_NUMBER_TABLE
2156: , p6_a28 out nocopy JTF_DATE_TABLE
2157: , p6_a29 out nocopy JTF_NUMBER_TABLE
2158: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
2159: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100
2160: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
2161: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
2162: , p6_a34 out nocopy JTF_NUMBER_TABLE
2155: , p6_a27 out nocopy JTF_NUMBER_TABLE
2156: , p6_a28 out nocopy JTF_DATE_TABLE
2157: , p6_a29 out nocopy JTF_NUMBER_TABLE
2158: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
2159: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100
2160: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
2161: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
2162: , p6_a34 out nocopy JTF_NUMBER_TABLE
2163: , p6_a35 out nocopy JTF_NUMBER_TABLE
2160: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
2161: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
2162: , p6_a34 out nocopy JTF_NUMBER_TABLE
2163: , p6_a35 out nocopy JTF_NUMBER_TABLE
2164: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
2165: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_2000
2166: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
2167: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
2168: )
2162: , p6_a34 out nocopy JTF_NUMBER_TABLE
2163: , p6_a35 out nocopy JTF_NUMBER_TABLE
2164: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
2165: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_2000
2166: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
2167: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
2168: )
2169:
2170: as
2163: , p6_a35 out nocopy JTF_NUMBER_TABLE
2164: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
2165: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_2000
2166: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
2167: , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
2168: )
2169:
2170: as
2171: ddp_cldv_tbl okl_cld_pvt.cldv_tbl_type;
2403: , x_msg_data out nocopy VARCHAR2
2404: , p5_a0 JTF_NUMBER_TABLE
2405: , p5_a1 JTF_NUMBER_TABLE
2406: , p5_a2 JTF_NUMBER_TABLE
2407: , p5_a3 JTF_VARCHAR2_TABLE_100
2408: , p5_a4 JTF_VARCHAR2_TABLE_100
2409: , p5_a5 JTF_VARCHAR2_TABLE_500
2410: , p5_a6 JTF_VARCHAR2_TABLE_500
2411: , p5_a7 JTF_VARCHAR2_TABLE_500
2404: , p5_a0 JTF_NUMBER_TABLE
2405: , p5_a1 JTF_NUMBER_TABLE
2406: , p5_a2 JTF_NUMBER_TABLE
2407: , p5_a3 JTF_VARCHAR2_TABLE_100
2408: , p5_a4 JTF_VARCHAR2_TABLE_100
2409: , p5_a5 JTF_VARCHAR2_TABLE_500
2410: , p5_a6 JTF_VARCHAR2_TABLE_500
2411: , p5_a7 JTF_VARCHAR2_TABLE_500
2412: , p5_a8 JTF_VARCHAR2_TABLE_500
2430: , p5_a26 JTF_DATE_TABLE
2431: , p5_a27 JTF_NUMBER_TABLE
2432: , p5_a28 JTF_DATE_TABLE
2433: , p5_a29 JTF_NUMBER_TABLE
2434: , p5_a30 JTF_VARCHAR2_TABLE_100
2435: , p5_a31 JTF_VARCHAR2_TABLE_100
2436: , p5_a32 JTF_VARCHAR2_TABLE_500
2437: , p5_a33 JTF_VARCHAR2_TABLE_500
2438: , p5_a34 JTF_NUMBER_TABLE
2431: , p5_a27 JTF_NUMBER_TABLE
2432: , p5_a28 JTF_DATE_TABLE
2433: , p5_a29 JTF_NUMBER_TABLE
2434: , p5_a30 JTF_VARCHAR2_TABLE_100
2435: , p5_a31 JTF_VARCHAR2_TABLE_100
2436: , p5_a32 JTF_VARCHAR2_TABLE_500
2437: , p5_a33 JTF_VARCHAR2_TABLE_500
2438: , p5_a34 JTF_NUMBER_TABLE
2439: , p5_a35 JTF_NUMBER_TABLE
2436: , p5_a32 JTF_VARCHAR2_TABLE_500
2437: , p5_a33 JTF_VARCHAR2_TABLE_500
2438: , p5_a34 JTF_NUMBER_TABLE
2439: , p5_a35 JTF_NUMBER_TABLE
2440: , p5_a36 JTF_VARCHAR2_TABLE_100
2441: , p5_a37 JTF_VARCHAR2_TABLE_2000
2442: , p5_a38 JTF_VARCHAR2_TABLE_100
2443: , p5_a39 JTF_VARCHAR2_TABLE_100
2444: , p6_a0 in out nocopy JTF_NUMBER_TABLE
2438: , p5_a34 JTF_NUMBER_TABLE
2439: , p5_a35 JTF_NUMBER_TABLE
2440: , p5_a36 JTF_VARCHAR2_TABLE_100
2441: , p5_a37 JTF_VARCHAR2_TABLE_2000
2442: , p5_a38 JTF_VARCHAR2_TABLE_100
2443: , p5_a39 JTF_VARCHAR2_TABLE_100
2444: , p6_a0 in out nocopy JTF_NUMBER_TABLE
2445: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
2446: , p6_a2 in out nocopy JTF_NUMBER_TABLE
2439: , p5_a35 JTF_NUMBER_TABLE
2440: , p5_a36 JTF_VARCHAR2_TABLE_100
2441: , p5_a37 JTF_VARCHAR2_TABLE_2000
2442: , p5_a38 JTF_VARCHAR2_TABLE_100
2443: , p5_a39 JTF_VARCHAR2_TABLE_100
2444: , p6_a0 in out nocopy JTF_NUMBER_TABLE
2445: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
2446: , p6_a2 in out nocopy JTF_NUMBER_TABLE
2447: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
2441: , p5_a37 JTF_VARCHAR2_TABLE_2000
2442: , p5_a38 JTF_VARCHAR2_TABLE_100
2443: , p5_a39 JTF_VARCHAR2_TABLE_100
2444: , p6_a0 in out nocopy JTF_NUMBER_TABLE
2445: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
2446: , p6_a2 in out nocopy JTF_NUMBER_TABLE
2447: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
2448: , p6_a4 in out nocopy JTF_NUMBER_TABLE
2449: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
2445: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
2446: , p6_a2 in out nocopy JTF_NUMBER_TABLE
2447: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
2448: , p6_a4 in out nocopy JTF_NUMBER_TABLE
2449: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
2450: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
2451: )
2452:
2453: as
2446: , p6_a2 in out nocopy JTF_NUMBER_TABLE
2447: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
2448: , p6_a4 in out nocopy JTF_NUMBER_TABLE
2449: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
2450: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
2451: )
2452:
2453: as
2454: ddp_cldv_tbl okl_cld_pvt.cldv_tbl_type;
2546: , x_msg_data out nocopy VARCHAR2
2547: , p5_a0 JTF_NUMBER_TABLE
2548: , p5_a1 JTF_NUMBER_TABLE
2549: , p5_a2 JTF_NUMBER_TABLE
2550: , p5_a3 JTF_VARCHAR2_TABLE_100
2551: , p5_a4 JTF_VARCHAR2_TABLE_100
2552: , p5_a5 JTF_VARCHAR2_TABLE_500
2553: , p5_a6 JTF_VARCHAR2_TABLE_500
2554: , p5_a7 JTF_VARCHAR2_TABLE_500
2547: , p5_a0 JTF_NUMBER_TABLE
2548: , p5_a1 JTF_NUMBER_TABLE
2549: , p5_a2 JTF_NUMBER_TABLE
2550: , p5_a3 JTF_VARCHAR2_TABLE_100
2551: , p5_a4 JTF_VARCHAR2_TABLE_100
2552: , p5_a5 JTF_VARCHAR2_TABLE_500
2553: , p5_a6 JTF_VARCHAR2_TABLE_500
2554: , p5_a7 JTF_VARCHAR2_TABLE_500
2555: , p5_a8 JTF_VARCHAR2_TABLE_500
2573: , p5_a26 JTF_DATE_TABLE
2574: , p5_a27 JTF_NUMBER_TABLE
2575: , p5_a28 JTF_DATE_TABLE
2576: , p5_a29 JTF_NUMBER_TABLE
2577: , p5_a30 JTF_VARCHAR2_TABLE_100
2578: , p5_a31 JTF_VARCHAR2_TABLE_100
2579: , p5_a32 JTF_VARCHAR2_TABLE_500
2580: , p5_a33 JTF_VARCHAR2_TABLE_500
2581: , p5_a34 JTF_NUMBER_TABLE
2574: , p5_a27 JTF_NUMBER_TABLE
2575: , p5_a28 JTF_DATE_TABLE
2576: , p5_a29 JTF_NUMBER_TABLE
2577: , p5_a30 JTF_VARCHAR2_TABLE_100
2578: , p5_a31 JTF_VARCHAR2_TABLE_100
2579: , p5_a32 JTF_VARCHAR2_TABLE_500
2580: , p5_a33 JTF_VARCHAR2_TABLE_500
2581: , p5_a34 JTF_NUMBER_TABLE
2582: , p5_a35 JTF_NUMBER_TABLE
2579: , p5_a32 JTF_VARCHAR2_TABLE_500
2580: , p5_a33 JTF_VARCHAR2_TABLE_500
2581: , p5_a34 JTF_NUMBER_TABLE
2582: , p5_a35 JTF_NUMBER_TABLE
2583: , p5_a36 JTF_VARCHAR2_TABLE_100
2584: , p5_a37 JTF_VARCHAR2_TABLE_2000
2585: , p5_a38 JTF_VARCHAR2_TABLE_100
2586: , p5_a39 JTF_VARCHAR2_TABLE_100
2587: )
2581: , p5_a34 JTF_NUMBER_TABLE
2582: , p5_a35 JTF_NUMBER_TABLE
2583: , p5_a36 JTF_VARCHAR2_TABLE_100
2584: , p5_a37 JTF_VARCHAR2_TABLE_2000
2585: , p5_a38 JTF_VARCHAR2_TABLE_100
2586: , p5_a39 JTF_VARCHAR2_TABLE_100
2587: )
2588:
2589: as
2582: , p5_a35 JTF_NUMBER_TABLE
2583: , p5_a36 JTF_VARCHAR2_TABLE_100
2584: , p5_a37 JTF_VARCHAR2_TABLE_2000
2585: , p5_a38 JTF_VARCHAR2_TABLE_100
2586: , p5_a39 JTF_VARCHAR2_TABLE_100
2587: )
2588:
2589: as
2590: ddp_cldv_tbl okl_cld_pvt.cldv_tbl_type;
2777: , x_msg_data out nocopy VARCHAR2
2778: , p5_a0 JTF_NUMBER_TABLE
2779: , p5_a1 JTF_NUMBER_TABLE
2780: , p5_a2 JTF_NUMBER_TABLE
2781: , p5_a3 JTF_VARCHAR2_TABLE_100
2782: , p5_a4 JTF_VARCHAR2_TABLE_100
2783: , p5_a5 JTF_VARCHAR2_TABLE_500
2784: , p5_a6 JTF_VARCHAR2_TABLE_500
2785: , p5_a7 JTF_VARCHAR2_TABLE_500
2778: , p5_a0 JTF_NUMBER_TABLE
2779: , p5_a1 JTF_NUMBER_TABLE
2780: , p5_a2 JTF_NUMBER_TABLE
2781: , p5_a3 JTF_VARCHAR2_TABLE_100
2782: , p5_a4 JTF_VARCHAR2_TABLE_100
2783: , p5_a5 JTF_VARCHAR2_TABLE_500
2784: , p5_a6 JTF_VARCHAR2_TABLE_500
2785: , p5_a7 JTF_VARCHAR2_TABLE_500
2786: , p5_a8 JTF_VARCHAR2_TABLE_500
2804: , p5_a26 JTF_DATE_TABLE
2805: , p5_a27 JTF_NUMBER_TABLE
2806: , p5_a28 JTF_DATE_TABLE
2807: , p5_a29 JTF_NUMBER_TABLE
2808: , p5_a30 JTF_VARCHAR2_TABLE_100
2809: , p5_a31 JTF_VARCHAR2_TABLE_100
2810: , p5_a32 JTF_VARCHAR2_TABLE_500
2811: , p5_a33 JTF_VARCHAR2_TABLE_500
2812: , p5_a34 JTF_NUMBER_TABLE
2805: , p5_a27 JTF_NUMBER_TABLE
2806: , p5_a28 JTF_DATE_TABLE
2807: , p5_a29 JTF_NUMBER_TABLE
2808: , p5_a30 JTF_VARCHAR2_TABLE_100
2809: , p5_a31 JTF_VARCHAR2_TABLE_100
2810: , p5_a32 JTF_VARCHAR2_TABLE_500
2811: , p5_a33 JTF_VARCHAR2_TABLE_500
2812: , p5_a34 JTF_NUMBER_TABLE
2813: , p5_a35 JTF_NUMBER_TABLE
2810: , p5_a32 JTF_VARCHAR2_TABLE_500
2811: , p5_a33 JTF_VARCHAR2_TABLE_500
2812: , p5_a34 JTF_NUMBER_TABLE
2813: , p5_a35 JTF_NUMBER_TABLE
2814: , p5_a36 JTF_VARCHAR2_TABLE_100
2815: , p5_a37 JTF_VARCHAR2_TABLE_2000
2816: , p5_a38 JTF_VARCHAR2_TABLE_100
2817: , p5_a39 JTF_VARCHAR2_TABLE_100
2818: , p6_a0 in out nocopy JTF_NUMBER_TABLE
2812: , p5_a34 JTF_NUMBER_TABLE
2813: , p5_a35 JTF_NUMBER_TABLE
2814: , p5_a36 JTF_VARCHAR2_TABLE_100
2815: , p5_a37 JTF_VARCHAR2_TABLE_2000
2816: , p5_a38 JTF_VARCHAR2_TABLE_100
2817: , p5_a39 JTF_VARCHAR2_TABLE_100
2818: , p6_a0 in out nocopy JTF_NUMBER_TABLE
2819: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
2820: , p6_a2 in out nocopy JTF_NUMBER_TABLE
2813: , p5_a35 JTF_NUMBER_TABLE
2814: , p5_a36 JTF_VARCHAR2_TABLE_100
2815: , p5_a37 JTF_VARCHAR2_TABLE_2000
2816: , p5_a38 JTF_VARCHAR2_TABLE_100
2817: , p5_a39 JTF_VARCHAR2_TABLE_100
2818: , p6_a0 in out nocopy JTF_NUMBER_TABLE
2819: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
2820: , p6_a2 in out nocopy JTF_NUMBER_TABLE
2821: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
2815: , p5_a37 JTF_VARCHAR2_TABLE_2000
2816: , p5_a38 JTF_VARCHAR2_TABLE_100
2817: , p5_a39 JTF_VARCHAR2_TABLE_100
2818: , p6_a0 in out nocopy JTF_NUMBER_TABLE
2819: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
2820: , p6_a2 in out nocopy JTF_NUMBER_TABLE
2821: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
2822: , p6_a4 in out nocopy JTF_NUMBER_TABLE
2823: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
2819: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
2820: , p6_a2 in out nocopy JTF_NUMBER_TABLE
2821: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
2822: , p6_a4 in out nocopy JTF_NUMBER_TABLE
2823: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
2824: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
2825: )
2826:
2827: as
2820: , p6_a2 in out nocopy JTF_NUMBER_TABLE
2821: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
2822: , p6_a4 in out nocopy JTF_NUMBER_TABLE
2823: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
2824: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
2825: )
2826:
2827: as
2828: ddp_cldv_tbl okl_cld_pvt.cldv_tbl_type;
2920: , x_msg_data out nocopy VARCHAR2
2921: , p5_a0 JTF_NUMBER_TABLE
2922: , p5_a1 JTF_NUMBER_TABLE
2923: , p5_a2 JTF_NUMBER_TABLE
2924: , p5_a3 JTF_VARCHAR2_TABLE_100
2925: , p5_a4 JTF_VARCHAR2_TABLE_100
2926: , p5_a5 JTF_VARCHAR2_TABLE_500
2927: , p5_a6 JTF_VARCHAR2_TABLE_500
2928: , p5_a7 JTF_VARCHAR2_TABLE_500
2921: , p5_a0 JTF_NUMBER_TABLE
2922: , p5_a1 JTF_NUMBER_TABLE
2923: , p5_a2 JTF_NUMBER_TABLE
2924: , p5_a3 JTF_VARCHAR2_TABLE_100
2925: , p5_a4 JTF_VARCHAR2_TABLE_100
2926: , p5_a5 JTF_VARCHAR2_TABLE_500
2927: , p5_a6 JTF_VARCHAR2_TABLE_500
2928: , p5_a7 JTF_VARCHAR2_TABLE_500
2929: , p5_a8 JTF_VARCHAR2_TABLE_500
2947: , p5_a26 JTF_DATE_TABLE
2948: , p5_a27 JTF_NUMBER_TABLE
2949: , p5_a28 JTF_DATE_TABLE
2950: , p5_a29 JTF_NUMBER_TABLE
2951: , p5_a30 JTF_VARCHAR2_TABLE_100
2952: , p5_a31 JTF_VARCHAR2_TABLE_100
2953: , p5_a32 JTF_VARCHAR2_TABLE_500
2954: , p5_a33 JTF_VARCHAR2_TABLE_500
2955: , p5_a34 JTF_NUMBER_TABLE
2948: , p5_a27 JTF_NUMBER_TABLE
2949: , p5_a28 JTF_DATE_TABLE
2950: , p5_a29 JTF_NUMBER_TABLE
2951: , p5_a30 JTF_VARCHAR2_TABLE_100
2952: , p5_a31 JTF_VARCHAR2_TABLE_100
2953: , p5_a32 JTF_VARCHAR2_TABLE_500
2954: , p5_a33 JTF_VARCHAR2_TABLE_500
2955: , p5_a34 JTF_NUMBER_TABLE
2956: , p5_a35 JTF_NUMBER_TABLE
2953: , p5_a32 JTF_VARCHAR2_TABLE_500
2954: , p5_a33 JTF_VARCHAR2_TABLE_500
2955: , p5_a34 JTF_NUMBER_TABLE
2956: , p5_a35 JTF_NUMBER_TABLE
2957: , p5_a36 JTF_VARCHAR2_TABLE_100
2958: , p5_a37 JTF_VARCHAR2_TABLE_2000
2959: , p5_a38 JTF_VARCHAR2_TABLE_100
2960: , p5_a39 JTF_VARCHAR2_TABLE_100
2961: )
2955: , p5_a34 JTF_NUMBER_TABLE
2956: , p5_a35 JTF_NUMBER_TABLE
2957: , p5_a36 JTF_VARCHAR2_TABLE_100
2958: , p5_a37 JTF_VARCHAR2_TABLE_2000
2959: , p5_a38 JTF_VARCHAR2_TABLE_100
2960: , p5_a39 JTF_VARCHAR2_TABLE_100
2961: )
2962:
2963: as
2956: , p5_a35 JTF_NUMBER_TABLE
2957: , p5_a36 JTF_VARCHAR2_TABLE_100
2958: , p5_a37 JTF_VARCHAR2_TABLE_2000
2959: , p5_a38 JTF_VARCHAR2_TABLE_100
2960: , p5_a39 JTF_VARCHAR2_TABLE_100
2961: )
2962:
2963: as
2964: ddp_cldv_tbl okl_cld_pvt.cldv_tbl_type;