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_ity_pvt.ity_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_NUMBER_TABLE
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_ity_pvt.ity_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_VARCHAR2_TABLE_100
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_ity_pvt.ity_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_VARCHAR2_TABLE_500
29: , a7 JTF_VARCHAR2_TABLE_500
30: , a8 JTF_VARCHAR2_TABLE_500
39: , a17 JTF_VARCHAR2_TABLE_500
40: , a18 JTF_VARCHAR2_TABLE_500
41: , a19 JTF_VARCHAR2_TABLE_500
42: , a20 JTF_VARCHAR2_TABLE_500
43: , a21 JTF_NUMBER_TABLE
44: , a22 JTF_DATE_TABLE
45: , a23 JTF_NUMBER_TABLE
46: , a24 JTF_DATE_TABLE
47: , a25 JTF_NUMBER_TABLE
41: , a19 JTF_VARCHAR2_TABLE_500
42: , a20 JTF_VARCHAR2_TABLE_500
43: , a21 JTF_NUMBER_TABLE
44: , a22 JTF_DATE_TABLE
45: , a23 JTF_NUMBER_TABLE
46: , a24 JTF_DATE_TABLE
47: , a25 JTF_NUMBER_TABLE
48: ) as
49: ddindx binary_integer; indx binary_integer;
43: , a21 JTF_NUMBER_TABLE
44: , a22 JTF_DATE_TABLE
45: , a23 JTF_NUMBER_TABLE
46: , a24 JTF_DATE_TABLE
47: , a25 JTF_NUMBER_TABLE
48: ) as
49: ddindx binary_integer; indx binary_integer;
50: begin
51: if a0 is not null and a0.count > 0 then
87: end loop;
88: end if;
89: end if;
90: end rosetta_table_copy_in_p2;
91: procedure rosetta_table_copy_out_p2(t okl_ity_pvt.ity_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
92: , a1 out nocopy JTF_NUMBER_TABLE
93: , a2 out nocopy JTF_VARCHAR2_TABLE_100
94: , a3 out nocopy JTF_VARCHAR2_TABLE_100
95: , a4 out nocopy JTF_NUMBER_TABLE
88: end if;
89: end if;
90: end rosetta_table_copy_in_p2;
91: procedure rosetta_table_copy_out_p2(t okl_ity_pvt.ity_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
92: , a1 out nocopy JTF_NUMBER_TABLE
93: , a2 out nocopy JTF_VARCHAR2_TABLE_100
94: , a3 out nocopy JTF_VARCHAR2_TABLE_100
95: , a4 out nocopy JTF_NUMBER_TABLE
96: , a5 out nocopy JTF_VARCHAR2_TABLE_100
91: procedure rosetta_table_copy_out_p2(t okl_ity_pvt.ity_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
92: , a1 out nocopy JTF_NUMBER_TABLE
93: , a2 out nocopy JTF_VARCHAR2_TABLE_100
94: , a3 out nocopy JTF_VARCHAR2_TABLE_100
95: , a4 out nocopy JTF_NUMBER_TABLE
96: , a5 out nocopy JTF_VARCHAR2_TABLE_100
97: , a6 out nocopy JTF_VARCHAR2_TABLE_500
98: , a7 out nocopy JTF_VARCHAR2_TABLE_500
99: , a8 out nocopy JTF_VARCHAR2_TABLE_500
108: , a17 out nocopy JTF_VARCHAR2_TABLE_500
109: , a18 out nocopy JTF_VARCHAR2_TABLE_500
110: , a19 out nocopy JTF_VARCHAR2_TABLE_500
111: , a20 out nocopy JTF_VARCHAR2_TABLE_500
112: , a21 out nocopy JTF_NUMBER_TABLE
113: , a22 out nocopy JTF_DATE_TABLE
114: , a23 out nocopy JTF_NUMBER_TABLE
115: , a24 out nocopy JTF_DATE_TABLE
116: , a25 out nocopy JTF_NUMBER_TABLE
110: , a19 out nocopy JTF_VARCHAR2_TABLE_500
111: , a20 out nocopy JTF_VARCHAR2_TABLE_500
112: , a21 out nocopy JTF_NUMBER_TABLE
113: , a22 out nocopy JTF_DATE_TABLE
114: , a23 out nocopy JTF_NUMBER_TABLE
115: , a24 out nocopy JTF_DATE_TABLE
116: , a25 out nocopy JTF_NUMBER_TABLE
117: ) as
118: ddindx binary_integer; indx binary_integer;
112: , a21 out nocopy JTF_NUMBER_TABLE
113: , a22 out nocopy JTF_DATE_TABLE
114: , a23 out nocopy JTF_NUMBER_TABLE
115: , a24 out nocopy JTF_DATE_TABLE
116: , a25 out nocopy JTF_NUMBER_TABLE
117: ) as
118: ddindx binary_integer; indx binary_integer;
119: begin
120: if t is null or t.count = 0 then
117: ) as
118: ddindx binary_integer; indx binary_integer;
119: begin
120: if t is null or t.count = 0 then
121: a0 := JTF_NUMBER_TABLE();
122: a1 := JTF_NUMBER_TABLE();
123: a2 := JTF_VARCHAR2_TABLE_100();
124: a3 := JTF_VARCHAR2_TABLE_100();
125: a4 := JTF_NUMBER_TABLE();
118: ddindx binary_integer; indx binary_integer;
119: begin
120: if t is null or t.count = 0 then
121: a0 := JTF_NUMBER_TABLE();
122: a1 := JTF_NUMBER_TABLE();
123: a2 := JTF_VARCHAR2_TABLE_100();
124: a3 := JTF_VARCHAR2_TABLE_100();
125: a4 := JTF_NUMBER_TABLE();
126: a5 := JTF_VARCHAR2_TABLE_100();
121: a0 := JTF_NUMBER_TABLE();
122: a1 := JTF_NUMBER_TABLE();
123: a2 := JTF_VARCHAR2_TABLE_100();
124: a3 := JTF_VARCHAR2_TABLE_100();
125: a4 := JTF_NUMBER_TABLE();
126: a5 := JTF_VARCHAR2_TABLE_100();
127: a6 := JTF_VARCHAR2_TABLE_500();
128: a7 := JTF_VARCHAR2_TABLE_500();
129: a8 := JTF_VARCHAR2_TABLE_500();
138: a17 := JTF_VARCHAR2_TABLE_500();
139: a18 := JTF_VARCHAR2_TABLE_500();
140: a19 := JTF_VARCHAR2_TABLE_500();
141: a20 := JTF_VARCHAR2_TABLE_500();
142: a21 := JTF_NUMBER_TABLE();
143: a22 := JTF_DATE_TABLE();
144: a23 := JTF_NUMBER_TABLE();
145: a24 := JTF_DATE_TABLE();
146: a25 := JTF_NUMBER_TABLE();
140: a19 := JTF_VARCHAR2_TABLE_500();
141: a20 := JTF_VARCHAR2_TABLE_500();
142: a21 := JTF_NUMBER_TABLE();
143: a22 := JTF_DATE_TABLE();
144: a23 := JTF_NUMBER_TABLE();
145: a24 := JTF_DATE_TABLE();
146: a25 := JTF_NUMBER_TABLE();
147: else
148: a0 := JTF_NUMBER_TABLE();
142: a21 := JTF_NUMBER_TABLE();
143: a22 := JTF_DATE_TABLE();
144: a23 := JTF_NUMBER_TABLE();
145: a24 := JTF_DATE_TABLE();
146: a25 := JTF_NUMBER_TABLE();
147: else
148: a0 := JTF_NUMBER_TABLE();
149: a1 := JTF_NUMBER_TABLE();
150: a2 := JTF_VARCHAR2_TABLE_100();
144: a23 := JTF_NUMBER_TABLE();
145: a24 := JTF_DATE_TABLE();
146: a25 := JTF_NUMBER_TABLE();
147: else
148: a0 := JTF_NUMBER_TABLE();
149: a1 := JTF_NUMBER_TABLE();
150: a2 := JTF_VARCHAR2_TABLE_100();
151: a3 := JTF_VARCHAR2_TABLE_100();
152: a4 := JTF_NUMBER_TABLE();
145: a24 := JTF_DATE_TABLE();
146: a25 := JTF_NUMBER_TABLE();
147: else
148: a0 := JTF_NUMBER_TABLE();
149: a1 := JTF_NUMBER_TABLE();
150: a2 := JTF_VARCHAR2_TABLE_100();
151: a3 := JTF_VARCHAR2_TABLE_100();
152: a4 := JTF_NUMBER_TABLE();
153: a5 := JTF_VARCHAR2_TABLE_100();
148: a0 := JTF_NUMBER_TABLE();
149: a1 := JTF_NUMBER_TABLE();
150: a2 := JTF_VARCHAR2_TABLE_100();
151: a3 := JTF_VARCHAR2_TABLE_100();
152: a4 := JTF_NUMBER_TABLE();
153: a5 := JTF_VARCHAR2_TABLE_100();
154: a6 := JTF_VARCHAR2_TABLE_500();
155: a7 := JTF_VARCHAR2_TABLE_500();
156: a8 := JTF_VARCHAR2_TABLE_500();
165: a17 := JTF_VARCHAR2_TABLE_500();
166: a18 := JTF_VARCHAR2_TABLE_500();
167: a19 := JTF_VARCHAR2_TABLE_500();
168: a20 := JTF_VARCHAR2_TABLE_500();
169: a21 := JTF_NUMBER_TABLE();
170: a22 := JTF_DATE_TABLE();
171: a23 := JTF_NUMBER_TABLE();
172: a24 := JTF_DATE_TABLE();
173: a25 := JTF_NUMBER_TABLE();
167: a19 := JTF_VARCHAR2_TABLE_500();
168: a20 := JTF_VARCHAR2_TABLE_500();
169: a21 := JTF_NUMBER_TABLE();
170: a22 := JTF_DATE_TABLE();
171: a23 := JTF_NUMBER_TABLE();
172: a24 := JTF_DATE_TABLE();
173: a25 := JTF_NUMBER_TABLE();
174: if t.count > 0 then
175: a0.extend(t.count);
169: a21 := JTF_NUMBER_TABLE();
170: a22 := JTF_DATE_TABLE();
171: a23 := JTF_NUMBER_TABLE();
172: a24 := JTF_DATE_TABLE();
173: a25 := JTF_NUMBER_TABLE();
174: if t.count > 0 then
175: a0.extend(t.count);
176: a1.extend(t.count);
177: a2.extend(t.count);
236: end if;
237: end if;
238: end rosetta_table_copy_out_p2;
239:
240: procedure rosetta_table_copy_in_p5(t out nocopy okl_ity_pvt.okl_invoice_types_tl_tbl_type, a0 JTF_NUMBER_TABLE
241: , a1 JTF_VARCHAR2_TABLE_100
242: , a2 JTF_VARCHAR2_TABLE_100
243: , a3 JTF_VARCHAR2_TABLE_100
244: , a4 JTF_VARCHAR2_TABLE_200
242: , a2 JTF_VARCHAR2_TABLE_100
243: , a3 JTF_VARCHAR2_TABLE_100
244: , a4 JTF_VARCHAR2_TABLE_200
245: , a5 JTF_VARCHAR2_TABLE_2000
246: , a6 JTF_NUMBER_TABLE
247: , a7 JTF_DATE_TABLE
248: , a8 JTF_NUMBER_TABLE
249: , a9 JTF_DATE_TABLE
250: , a10 JTF_NUMBER_TABLE
244: , a4 JTF_VARCHAR2_TABLE_200
245: , a5 JTF_VARCHAR2_TABLE_2000
246: , a6 JTF_NUMBER_TABLE
247: , a7 JTF_DATE_TABLE
248: , a8 JTF_NUMBER_TABLE
249: , a9 JTF_DATE_TABLE
250: , a10 JTF_NUMBER_TABLE
251: ) as
252: ddindx binary_integer; indx binary_integer;
246: , a6 JTF_NUMBER_TABLE
247: , a7 JTF_DATE_TABLE
248: , a8 JTF_NUMBER_TABLE
249: , a9 JTF_DATE_TABLE
250: , a10 JTF_NUMBER_TABLE
251: ) as
252: ddindx binary_integer; indx binary_integer;
253: begin
254: if a0 is not null and a0.count > 0 then
275: end loop;
276: end if;
277: end if;
278: end rosetta_table_copy_in_p5;
279: procedure rosetta_table_copy_out_p5(t okl_ity_pvt.okl_invoice_types_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
280: , a1 out nocopy JTF_VARCHAR2_TABLE_100
281: , a2 out nocopy JTF_VARCHAR2_TABLE_100
282: , a3 out nocopy JTF_VARCHAR2_TABLE_100
283: , a4 out nocopy JTF_VARCHAR2_TABLE_200
281: , a2 out nocopy JTF_VARCHAR2_TABLE_100
282: , a3 out nocopy JTF_VARCHAR2_TABLE_100
283: , a4 out nocopy JTF_VARCHAR2_TABLE_200
284: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
285: , a6 out nocopy JTF_NUMBER_TABLE
286: , a7 out nocopy JTF_DATE_TABLE
287: , a8 out nocopy JTF_NUMBER_TABLE
288: , a9 out nocopy JTF_DATE_TABLE
289: , a10 out nocopy JTF_NUMBER_TABLE
283: , a4 out nocopy JTF_VARCHAR2_TABLE_200
284: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
285: , a6 out nocopy JTF_NUMBER_TABLE
286: , a7 out nocopy JTF_DATE_TABLE
287: , a8 out nocopy JTF_NUMBER_TABLE
288: , a9 out nocopy JTF_DATE_TABLE
289: , a10 out nocopy JTF_NUMBER_TABLE
290: ) as
291: ddindx binary_integer; indx binary_integer;
285: , a6 out nocopy JTF_NUMBER_TABLE
286: , a7 out nocopy JTF_DATE_TABLE
287: , a8 out nocopy JTF_NUMBER_TABLE
288: , a9 out nocopy JTF_DATE_TABLE
289: , a10 out nocopy JTF_NUMBER_TABLE
290: ) as
291: ddindx binary_integer; indx binary_integer;
292: begin
293: if t is null or t.count = 0 then
290: ) as
291: ddindx binary_integer; indx binary_integer;
292: begin
293: if t is null or t.count = 0 then
294: a0 := JTF_NUMBER_TABLE();
295: a1 := JTF_VARCHAR2_TABLE_100();
296: a2 := JTF_VARCHAR2_TABLE_100();
297: a3 := JTF_VARCHAR2_TABLE_100();
298: a4 := JTF_VARCHAR2_TABLE_200();
296: a2 := JTF_VARCHAR2_TABLE_100();
297: a3 := JTF_VARCHAR2_TABLE_100();
298: a4 := JTF_VARCHAR2_TABLE_200();
299: a5 := JTF_VARCHAR2_TABLE_2000();
300: a6 := JTF_NUMBER_TABLE();
301: a7 := JTF_DATE_TABLE();
302: a8 := JTF_NUMBER_TABLE();
303: a9 := JTF_DATE_TABLE();
304: a10 := JTF_NUMBER_TABLE();
298: a4 := JTF_VARCHAR2_TABLE_200();
299: a5 := JTF_VARCHAR2_TABLE_2000();
300: a6 := JTF_NUMBER_TABLE();
301: a7 := JTF_DATE_TABLE();
302: a8 := JTF_NUMBER_TABLE();
303: a9 := JTF_DATE_TABLE();
304: a10 := JTF_NUMBER_TABLE();
305: else
306: a0 := JTF_NUMBER_TABLE();
300: a6 := JTF_NUMBER_TABLE();
301: a7 := JTF_DATE_TABLE();
302: a8 := JTF_NUMBER_TABLE();
303: a9 := JTF_DATE_TABLE();
304: a10 := JTF_NUMBER_TABLE();
305: else
306: a0 := JTF_NUMBER_TABLE();
307: a1 := JTF_VARCHAR2_TABLE_100();
308: a2 := JTF_VARCHAR2_TABLE_100();
302: a8 := JTF_NUMBER_TABLE();
303: a9 := JTF_DATE_TABLE();
304: a10 := JTF_NUMBER_TABLE();
305: else
306: a0 := JTF_NUMBER_TABLE();
307: a1 := JTF_VARCHAR2_TABLE_100();
308: a2 := JTF_VARCHAR2_TABLE_100();
309: a3 := JTF_VARCHAR2_TABLE_100();
310: a4 := JTF_VARCHAR2_TABLE_200();
308: a2 := JTF_VARCHAR2_TABLE_100();
309: a3 := JTF_VARCHAR2_TABLE_100();
310: a4 := JTF_VARCHAR2_TABLE_200();
311: a5 := JTF_VARCHAR2_TABLE_2000();
312: a6 := JTF_NUMBER_TABLE();
313: a7 := JTF_DATE_TABLE();
314: a8 := JTF_NUMBER_TABLE();
315: a9 := JTF_DATE_TABLE();
316: a10 := JTF_NUMBER_TABLE();
310: a4 := JTF_VARCHAR2_TABLE_200();
311: a5 := JTF_VARCHAR2_TABLE_2000();
312: a6 := JTF_NUMBER_TABLE();
313: a7 := JTF_DATE_TABLE();
314: a8 := JTF_NUMBER_TABLE();
315: a9 := JTF_DATE_TABLE();
316: a10 := JTF_NUMBER_TABLE();
317: if t.count > 0 then
318: a0.extend(t.count);
312: a6 := JTF_NUMBER_TABLE();
313: a7 := JTF_DATE_TABLE();
314: a8 := JTF_NUMBER_TABLE();
315: a9 := JTF_DATE_TABLE();
316: a10 := JTF_NUMBER_TABLE();
317: if t.count > 0 then
318: a0.extend(t.count);
319: a1.extend(t.count);
320: a2.extend(t.count);
349: end if;
350: end if;
351: end rosetta_table_copy_out_p5;
352:
353: procedure rosetta_table_copy_in_p8(t out nocopy okl_ity_pvt.ityv_tbl_type, a0 JTF_NUMBER_TABLE
354: , a1 JTF_NUMBER_TABLE
355: , a2 JTF_VARCHAR2_TABLE_100
356: , a3 JTF_NUMBER_TABLE
357: , a4 JTF_VARCHAR2_TABLE_200
350: end if;
351: end rosetta_table_copy_out_p5;
352:
353: procedure rosetta_table_copy_in_p8(t out nocopy okl_ity_pvt.ityv_tbl_type, a0 JTF_NUMBER_TABLE
354: , a1 JTF_NUMBER_TABLE
355: , a2 JTF_VARCHAR2_TABLE_100
356: , a3 JTF_NUMBER_TABLE
357: , a4 JTF_VARCHAR2_TABLE_200
358: , a5 JTF_VARCHAR2_TABLE_2000
352:
353: procedure rosetta_table_copy_in_p8(t out nocopy okl_ity_pvt.ityv_tbl_type, a0 JTF_NUMBER_TABLE
354: , a1 JTF_NUMBER_TABLE
355: , a2 JTF_VARCHAR2_TABLE_100
356: , a3 JTF_NUMBER_TABLE
357: , a4 JTF_VARCHAR2_TABLE_200
358: , a5 JTF_VARCHAR2_TABLE_2000
359: , a6 JTF_VARCHAR2_TABLE_100
360: , a7 JTF_VARCHAR2_TABLE_100
373: , a20 JTF_VARCHAR2_TABLE_500
374: , a21 JTF_VARCHAR2_TABLE_500
375: , a22 JTF_VARCHAR2_TABLE_500
376: , a23 JTF_VARCHAR2_TABLE_500
377: , a24 JTF_NUMBER_TABLE
378: , a25 JTF_DATE_TABLE
379: , a26 JTF_NUMBER_TABLE
380: , a27 JTF_DATE_TABLE
381: , a28 JTF_NUMBER_TABLE
375: , a22 JTF_VARCHAR2_TABLE_500
376: , a23 JTF_VARCHAR2_TABLE_500
377: , a24 JTF_NUMBER_TABLE
378: , a25 JTF_DATE_TABLE
379: , a26 JTF_NUMBER_TABLE
380: , a27 JTF_DATE_TABLE
381: , a28 JTF_NUMBER_TABLE
382: ) as
383: ddindx binary_integer; indx binary_integer;
377: , a24 JTF_NUMBER_TABLE
378: , a25 JTF_DATE_TABLE
379: , a26 JTF_NUMBER_TABLE
380: , a27 JTF_DATE_TABLE
381: , a28 JTF_NUMBER_TABLE
382: ) as
383: ddindx binary_integer; indx binary_integer;
384: begin
385: if a0 is not null and a0.count > 0 then
424: end loop;
425: end if;
426: end if;
427: end rosetta_table_copy_in_p8;
428: procedure rosetta_table_copy_out_p8(t okl_ity_pvt.ityv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
429: , a1 out nocopy JTF_NUMBER_TABLE
430: , a2 out nocopy JTF_VARCHAR2_TABLE_100
431: , a3 out nocopy JTF_NUMBER_TABLE
432: , a4 out nocopy JTF_VARCHAR2_TABLE_200
425: end if;
426: end if;
427: end rosetta_table_copy_in_p8;
428: procedure rosetta_table_copy_out_p8(t okl_ity_pvt.ityv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
429: , a1 out nocopy JTF_NUMBER_TABLE
430: , a2 out nocopy JTF_VARCHAR2_TABLE_100
431: , a3 out nocopy JTF_NUMBER_TABLE
432: , a4 out nocopy JTF_VARCHAR2_TABLE_200
433: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
427: end rosetta_table_copy_in_p8;
428: procedure rosetta_table_copy_out_p8(t okl_ity_pvt.ityv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
429: , a1 out nocopy JTF_NUMBER_TABLE
430: , a2 out nocopy JTF_VARCHAR2_TABLE_100
431: , a3 out nocopy JTF_NUMBER_TABLE
432: , a4 out nocopy JTF_VARCHAR2_TABLE_200
433: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
434: , a6 out nocopy JTF_VARCHAR2_TABLE_100
435: , a7 out nocopy JTF_VARCHAR2_TABLE_100
448: , a20 out nocopy JTF_VARCHAR2_TABLE_500
449: , a21 out nocopy JTF_VARCHAR2_TABLE_500
450: , a22 out nocopy JTF_VARCHAR2_TABLE_500
451: , a23 out nocopy JTF_VARCHAR2_TABLE_500
452: , a24 out nocopy JTF_NUMBER_TABLE
453: , a25 out nocopy JTF_DATE_TABLE
454: , a26 out nocopy JTF_NUMBER_TABLE
455: , a27 out nocopy JTF_DATE_TABLE
456: , a28 out nocopy JTF_NUMBER_TABLE
450: , a22 out nocopy JTF_VARCHAR2_TABLE_500
451: , a23 out nocopy JTF_VARCHAR2_TABLE_500
452: , a24 out nocopy JTF_NUMBER_TABLE
453: , a25 out nocopy JTF_DATE_TABLE
454: , a26 out nocopy JTF_NUMBER_TABLE
455: , a27 out nocopy JTF_DATE_TABLE
456: , a28 out nocopy JTF_NUMBER_TABLE
457: ) as
458: ddindx binary_integer; indx binary_integer;
452: , a24 out nocopy JTF_NUMBER_TABLE
453: , a25 out nocopy JTF_DATE_TABLE
454: , a26 out nocopy JTF_NUMBER_TABLE
455: , a27 out nocopy JTF_DATE_TABLE
456: , a28 out nocopy JTF_NUMBER_TABLE
457: ) as
458: ddindx binary_integer; indx binary_integer;
459: begin
460: if t is null or t.count = 0 then
457: ) as
458: ddindx binary_integer; indx binary_integer;
459: begin
460: if t is null or t.count = 0 then
461: a0 := JTF_NUMBER_TABLE();
462: a1 := JTF_NUMBER_TABLE();
463: a2 := JTF_VARCHAR2_TABLE_100();
464: a3 := JTF_NUMBER_TABLE();
465: a4 := JTF_VARCHAR2_TABLE_200();
458: ddindx binary_integer; indx binary_integer;
459: begin
460: if t is null or t.count = 0 then
461: a0 := JTF_NUMBER_TABLE();
462: a1 := JTF_NUMBER_TABLE();
463: a2 := JTF_VARCHAR2_TABLE_100();
464: a3 := JTF_NUMBER_TABLE();
465: a4 := JTF_VARCHAR2_TABLE_200();
466: a5 := JTF_VARCHAR2_TABLE_2000();
460: if t is null or t.count = 0 then
461: a0 := JTF_NUMBER_TABLE();
462: a1 := JTF_NUMBER_TABLE();
463: a2 := JTF_VARCHAR2_TABLE_100();
464: a3 := JTF_NUMBER_TABLE();
465: a4 := JTF_VARCHAR2_TABLE_200();
466: a5 := JTF_VARCHAR2_TABLE_2000();
467: a6 := JTF_VARCHAR2_TABLE_100();
468: a7 := JTF_VARCHAR2_TABLE_100();
481: a20 := JTF_VARCHAR2_TABLE_500();
482: a21 := JTF_VARCHAR2_TABLE_500();
483: a22 := JTF_VARCHAR2_TABLE_500();
484: a23 := JTF_VARCHAR2_TABLE_500();
485: a24 := JTF_NUMBER_TABLE();
486: a25 := JTF_DATE_TABLE();
487: a26 := JTF_NUMBER_TABLE();
488: a27 := JTF_DATE_TABLE();
489: a28 := JTF_NUMBER_TABLE();
483: a22 := JTF_VARCHAR2_TABLE_500();
484: a23 := JTF_VARCHAR2_TABLE_500();
485: a24 := JTF_NUMBER_TABLE();
486: a25 := JTF_DATE_TABLE();
487: a26 := JTF_NUMBER_TABLE();
488: a27 := JTF_DATE_TABLE();
489: a28 := JTF_NUMBER_TABLE();
490: else
491: a0 := JTF_NUMBER_TABLE();
485: a24 := JTF_NUMBER_TABLE();
486: a25 := JTF_DATE_TABLE();
487: a26 := JTF_NUMBER_TABLE();
488: a27 := JTF_DATE_TABLE();
489: a28 := JTF_NUMBER_TABLE();
490: else
491: a0 := JTF_NUMBER_TABLE();
492: a1 := JTF_NUMBER_TABLE();
493: a2 := JTF_VARCHAR2_TABLE_100();
487: a26 := JTF_NUMBER_TABLE();
488: a27 := JTF_DATE_TABLE();
489: a28 := JTF_NUMBER_TABLE();
490: else
491: a0 := JTF_NUMBER_TABLE();
492: a1 := JTF_NUMBER_TABLE();
493: a2 := JTF_VARCHAR2_TABLE_100();
494: a3 := JTF_NUMBER_TABLE();
495: a4 := JTF_VARCHAR2_TABLE_200();
488: a27 := JTF_DATE_TABLE();
489: a28 := JTF_NUMBER_TABLE();
490: else
491: a0 := JTF_NUMBER_TABLE();
492: a1 := JTF_NUMBER_TABLE();
493: a2 := JTF_VARCHAR2_TABLE_100();
494: a3 := JTF_NUMBER_TABLE();
495: a4 := JTF_VARCHAR2_TABLE_200();
496: a5 := JTF_VARCHAR2_TABLE_2000();
490: else
491: a0 := JTF_NUMBER_TABLE();
492: a1 := JTF_NUMBER_TABLE();
493: a2 := JTF_VARCHAR2_TABLE_100();
494: a3 := JTF_NUMBER_TABLE();
495: a4 := JTF_VARCHAR2_TABLE_200();
496: a5 := JTF_VARCHAR2_TABLE_2000();
497: a6 := JTF_VARCHAR2_TABLE_100();
498: a7 := JTF_VARCHAR2_TABLE_100();
511: a20 := JTF_VARCHAR2_TABLE_500();
512: a21 := JTF_VARCHAR2_TABLE_500();
513: a22 := JTF_VARCHAR2_TABLE_500();
514: a23 := JTF_VARCHAR2_TABLE_500();
515: a24 := JTF_NUMBER_TABLE();
516: a25 := JTF_DATE_TABLE();
517: a26 := JTF_NUMBER_TABLE();
518: a27 := JTF_DATE_TABLE();
519: a28 := JTF_NUMBER_TABLE();
513: a22 := JTF_VARCHAR2_TABLE_500();
514: a23 := JTF_VARCHAR2_TABLE_500();
515: a24 := JTF_NUMBER_TABLE();
516: a25 := JTF_DATE_TABLE();
517: a26 := JTF_NUMBER_TABLE();
518: a27 := JTF_DATE_TABLE();
519: a28 := JTF_NUMBER_TABLE();
520: if t.count > 0 then
521: a0.extend(t.count);
515: a24 := JTF_NUMBER_TABLE();
516: a25 := JTF_DATE_TABLE();
517: a26 := JTF_NUMBER_TABLE();
518: a27 := JTF_DATE_TABLE();
519: a28 := JTF_NUMBER_TABLE();
520: if t.count > 0 then
521: a0.extend(t.count);
522: a1.extend(t.count);
523: a2.extend(t.count);
748: , p_init_msg_list VARCHAR2
749: , x_return_status out nocopy VARCHAR2
750: , x_msg_count out nocopy NUMBER
751: , x_msg_data out nocopy VARCHAR2
752: , p5_a0 JTF_NUMBER_TABLE
753: , p5_a1 JTF_NUMBER_TABLE
754: , p5_a2 JTF_VARCHAR2_TABLE_100
755: , p5_a3 JTF_NUMBER_TABLE
756: , p5_a4 JTF_VARCHAR2_TABLE_200
749: , x_return_status out nocopy VARCHAR2
750: , x_msg_count out nocopy NUMBER
751: , x_msg_data out nocopy VARCHAR2
752: , p5_a0 JTF_NUMBER_TABLE
753: , p5_a1 JTF_NUMBER_TABLE
754: , p5_a2 JTF_VARCHAR2_TABLE_100
755: , p5_a3 JTF_NUMBER_TABLE
756: , p5_a4 JTF_VARCHAR2_TABLE_200
757: , p5_a5 JTF_VARCHAR2_TABLE_2000
751: , x_msg_data out nocopy VARCHAR2
752: , p5_a0 JTF_NUMBER_TABLE
753: , p5_a1 JTF_NUMBER_TABLE
754: , p5_a2 JTF_VARCHAR2_TABLE_100
755: , p5_a3 JTF_NUMBER_TABLE
756: , p5_a4 JTF_VARCHAR2_TABLE_200
757: , p5_a5 JTF_VARCHAR2_TABLE_2000
758: , p5_a6 JTF_VARCHAR2_TABLE_100
759: , p5_a7 JTF_VARCHAR2_TABLE_100
772: , p5_a20 JTF_VARCHAR2_TABLE_500
773: , p5_a21 JTF_VARCHAR2_TABLE_500
774: , p5_a22 JTF_VARCHAR2_TABLE_500
775: , p5_a23 JTF_VARCHAR2_TABLE_500
776: , p5_a24 JTF_NUMBER_TABLE
777: , p5_a25 JTF_DATE_TABLE
778: , p5_a26 JTF_NUMBER_TABLE
779: , p5_a27 JTF_DATE_TABLE
780: , p5_a28 JTF_NUMBER_TABLE
774: , p5_a22 JTF_VARCHAR2_TABLE_500
775: , p5_a23 JTF_VARCHAR2_TABLE_500
776: , p5_a24 JTF_NUMBER_TABLE
777: , p5_a25 JTF_DATE_TABLE
778: , p5_a26 JTF_NUMBER_TABLE
779: , p5_a27 JTF_DATE_TABLE
780: , p5_a28 JTF_NUMBER_TABLE
781: , p6_a0 out nocopy JTF_NUMBER_TABLE
782: , p6_a1 out nocopy JTF_NUMBER_TABLE
776: , p5_a24 JTF_NUMBER_TABLE
777: , p5_a25 JTF_DATE_TABLE
778: , p5_a26 JTF_NUMBER_TABLE
779: , p5_a27 JTF_DATE_TABLE
780: , p5_a28 JTF_NUMBER_TABLE
781: , p6_a0 out nocopy JTF_NUMBER_TABLE
782: , p6_a1 out nocopy JTF_NUMBER_TABLE
783: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
784: , p6_a3 out nocopy JTF_NUMBER_TABLE
777: , p5_a25 JTF_DATE_TABLE
778: , p5_a26 JTF_NUMBER_TABLE
779: , p5_a27 JTF_DATE_TABLE
780: , p5_a28 JTF_NUMBER_TABLE
781: , p6_a0 out nocopy JTF_NUMBER_TABLE
782: , p6_a1 out nocopy JTF_NUMBER_TABLE
783: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
784: , p6_a3 out nocopy JTF_NUMBER_TABLE
785: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
778: , p5_a26 JTF_NUMBER_TABLE
779: , p5_a27 JTF_DATE_TABLE
780: , p5_a28 JTF_NUMBER_TABLE
781: , p6_a0 out nocopy JTF_NUMBER_TABLE
782: , p6_a1 out nocopy JTF_NUMBER_TABLE
783: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
784: , p6_a3 out nocopy JTF_NUMBER_TABLE
785: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
786: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
780: , p5_a28 JTF_NUMBER_TABLE
781: , p6_a0 out nocopy JTF_NUMBER_TABLE
782: , p6_a1 out nocopy JTF_NUMBER_TABLE
783: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
784: , p6_a3 out nocopy JTF_NUMBER_TABLE
785: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
786: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
787: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
788: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
801: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
802: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
803: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
804: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
805: , p6_a24 out nocopy JTF_NUMBER_TABLE
806: , p6_a25 out nocopy JTF_DATE_TABLE
807: , p6_a26 out nocopy JTF_NUMBER_TABLE
808: , p6_a27 out nocopy JTF_DATE_TABLE
809: , p6_a28 out nocopy JTF_NUMBER_TABLE
803: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
804: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
805: , p6_a24 out nocopy JTF_NUMBER_TABLE
806: , p6_a25 out nocopy JTF_DATE_TABLE
807: , p6_a26 out nocopy JTF_NUMBER_TABLE
808: , p6_a27 out nocopy JTF_DATE_TABLE
809: , p6_a28 out nocopy JTF_NUMBER_TABLE
810: )
811:
805: , p6_a24 out nocopy JTF_NUMBER_TABLE
806: , p6_a25 out nocopy JTF_DATE_TABLE
807: , p6_a26 out nocopy JTF_NUMBER_TABLE
808: , p6_a27 out nocopy JTF_DATE_TABLE
809: , p6_a28 out nocopy JTF_NUMBER_TABLE
810: )
811:
812: as
813: ddp_ityv_tbl okl_ity_pvt.ityv_tbl_type;
998: , p_init_msg_list VARCHAR2
999: , x_return_status out nocopy VARCHAR2
1000: , x_msg_count out nocopy NUMBER
1001: , x_msg_data out nocopy VARCHAR2
1002: , p5_a0 JTF_NUMBER_TABLE
1003: , p5_a1 JTF_NUMBER_TABLE
1004: , p5_a2 JTF_VARCHAR2_TABLE_100
1005: , p5_a3 JTF_NUMBER_TABLE
1006: , p5_a4 JTF_VARCHAR2_TABLE_200
999: , x_return_status out nocopy VARCHAR2
1000: , x_msg_count out nocopy NUMBER
1001: , x_msg_data out nocopy VARCHAR2
1002: , p5_a0 JTF_NUMBER_TABLE
1003: , p5_a1 JTF_NUMBER_TABLE
1004: , p5_a2 JTF_VARCHAR2_TABLE_100
1005: , p5_a3 JTF_NUMBER_TABLE
1006: , p5_a4 JTF_VARCHAR2_TABLE_200
1007: , p5_a5 JTF_VARCHAR2_TABLE_2000
1001: , x_msg_data out nocopy VARCHAR2
1002: , p5_a0 JTF_NUMBER_TABLE
1003: , p5_a1 JTF_NUMBER_TABLE
1004: , p5_a2 JTF_VARCHAR2_TABLE_100
1005: , p5_a3 JTF_NUMBER_TABLE
1006: , p5_a4 JTF_VARCHAR2_TABLE_200
1007: , p5_a5 JTF_VARCHAR2_TABLE_2000
1008: , p5_a6 JTF_VARCHAR2_TABLE_100
1009: , p5_a7 JTF_VARCHAR2_TABLE_100
1022: , p5_a20 JTF_VARCHAR2_TABLE_500
1023: , p5_a21 JTF_VARCHAR2_TABLE_500
1024: , p5_a22 JTF_VARCHAR2_TABLE_500
1025: , p5_a23 JTF_VARCHAR2_TABLE_500
1026: , p5_a24 JTF_NUMBER_TABLE
1027: , p5_a25 JTF_DATE_TABLE
1028: , p5_a26 JTF_NUMBER_TABLE
1029: , p5_a27 JTF_DATE_TABLE
1030: , p5_a28 JTF_NUMBER_TABLE
1024: , p5_a22 JTF_VARCHAR2_TABLE_500
1025: , p5_a23 JTF_VARCHAR2_TABLE_500
1026: , p5_a24 JTF_NUMBER_TABLE
1027: , p5_a25 JTF_DATE_TABLE
1028: , p5_a26 JTF_NUMBER_TABLE
1029: , p5_a27 JTF_DATE_TABLE
1030: , p5_a28 JTF_NUMBER_TABLE
1031: )
1032:
1026: , p5_a24 JTF_NUMBER_TABLE
1027: , p5_a25 JTF_DATE_TABLE
1028: , p5_a26 JTF_NUMBER_TABLE
1029: , p5_a27 JTF_DATE_TABLE
1030: , p5_a28 JTF_NUMBER_TABLE
1031: )
1032:
1033: as
1034: ddp_ityv_tbl okl_ity_pvt.ityv_tbl_type;
1247: , p_init_msg_list VARCHAR2
1248: , x_return_status out nocopy VARCHAR2
1249: , x_msg_count out nocopy NUMBER
1250: , x_msg_data out nocopy VARCHAR2
1251: , p5_a0 JTF_NUMBER_TABLE
1252: , p5_a1 JTF_NUMBER_TABLE
1253: , p5_a2 JTF_VARCHAR2_TABLE_100
1254: , p5_a3 JTF_NUMBER_TABLE
1255: , p5_a4 JTF_VARCHAR2_TABLE_200
1248: , x_return_status out nocopy VARCHAR2
1249: , x_msg_count out nocopy NUMBER
1250: , x_msg_data out nocopy VARCHAR2
1251: , p5_a0 JTF_NUMBER_TABLE
1252: , p5_a1 JTF_NUMBER_TABLE
1253: , p5_a2 JTF_VARCHAR2_TABLE_100
1254: , p5_a3 JTF_NUMBER_TABLE
1255: , p5_a4 JTF_VARCHAR2_TABLE_200
1256: , p5_a5 JTF_VARCHAR2_TABLE_2000
1250: , x_msg_data out nocopy VARCHAR2
1251: , p5_a0 JTF_NUMBER_TABLE
1252: , p5_a1 JTF_NUMBER_TABLE
1253: , p5_a2 JTF_VARCHAR2_TABLE_100
1254: , p5_a3 JTF_NUMBER_TABLE
1255: , p5_a4 JTF_VARCHAR2_TABLE_200
1256: , p5_a5 JTF_VARCHAR2_TABLE_2000
1257: , p5_a6 JTF_VARCHAR2_TABLE_100
1258: , p5_a7 JTF_VARCHAR2_TABLE_100
1271: , p5_a20 JTF_VARCHAR2_TABLE_500
1272: , p5_a21 JTF_VARCHAR2_TABLE_500
1273: , p5_a22 JTF_VARCHAR2_TABLE_500
1274: , p5_a23 JTF_VARCHAR2_TABLE_500
1275: , p5_a24 JTF_NUMBER_TABLE
1276: , p5_a25 JTF_DATE_TABLE
1277: , p5_a26 JTF_NUMBER_TABLE
1278: , p5_a27 JTF_DATE_TABLE
1279: , p5_a28 JTF_NUMBER_TABLE
1273: , p5_a22 JTF_VARCHAR2_TABLE_500
1274: , p5_a23 JTF_VARCHAR2_TABLE_500
1275: , p5_a24 JTF_NUMBER_TABLE
1276: , p5_a25 JTF_DATE_TABLE
1277: , p5_a26 JTF_NUMBER_TABLE
1278: , p5_a27 JTF_DATE_TABLE
1279: , p5_a28 JTF_NUMBER_TABLE
1280: , p6_a0 out nocopy JTF_NUMBER_TABLE
1281: , p6_a1 out nocopy JTF_NUMBER_TABLE
1275: , p5_a24 JTF_NUMBER_TABLE
1276: , p5_a25 JTF_DATE_TABLE
1277: , p5_a26 JTF_NUMBER_TABLE
1278: , p5_a27 JTF_DATE_TABLE
1279: , p5_a28 JTF_NUMBER_TABLE
1280: , p6_a0 out nocopy JTF_NUMBER_TABLE
1281: , p6_a1 out nocopy JTF_NUMBER_TABLE
1282: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1283: , p6_a3 out nocopy JTF_NUMBER_TABLE
1276: , p5_a25 JTF_DATE_TABLE
1277: , p5_a26 JTF_NUMBER_TABLE
1278: , p5_a27 JTF_DATE_TABLE
1279: , p5_a28 JTF_NUMBER_TABLE
1280: , p6_a0 out nocopy JTF_NUMBER_TABLE
1281: , p6_a1 out nocopy JTF_NUMBER_TABLE
1282: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1283: , p6_a3 out nocopy JTF_NUMBER_TABLE
1284: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
1277: , p5_a26 JTF_NUMBER_TABLE
1278: , p5_a27 JTF_DATE_TABLE
1279: , p5_a28 JTF_NUMBER_TABLE
1280: , p6_a0 out nocopy JTF_NUMBER_TABLE
1281: , p6_a1 out nocopy JTF_NUMBER_TABLE
1282: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1283: , p6_a3 out nocopy JTF_NUMBER_TABLE
1284: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
1285: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
1279: , p5_a28 JTF_NUMBER_TABLE
1280: , p6_a0 out nocopy JTF_NUMBER_TABLE
1281: , p6_a1 out nocopy JTF_NUMBER_TABLE
1282: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1283: , p6_a3 out nocopy JTF_NUMBER_TABLE
1284: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
1285: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
1286: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1287: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
1300: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
1301: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
1302: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
1303: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
1304: , p6_a24 out nocopy JTF_NUMBER_TABLE
1305: , p6_a25 out nocopy JTF_DATE_TABLE
1306: , p6_a26 out nocopy JTF_NUMBER_TABLE
1307: , p6_a27 out nocopy JTF_DATE_TABLE
1308: , p6_a28 out nocopy JTF_NUMBER_TABLE
1302: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
1303: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
1304: , p6_a24 out nocopy JTF_NUMBER_TABLE
1305: , p6_a25 out nocopy JTF_DATE_TABLE
1306: , p6_a26 out nocopy JTF_NUMBER_TABLE
1307: , p6_a27 out nocopy JTF_DATE_TABLE
1308: , p6_a28 out nocopy JTF_NUMBER_TABLE
1309: )
1310:
1304: , p6_a24 out nocopy JTF_NUMBER_TABLE
1305: , p6_a25 out nocopy JTF_DATE_TABLE
1306: , p6_a26 out nocopy JTF_NUMBER_TABLE
1307: , p6_a27 out nocopy JTF_DATE_TABLE
1308: , p6_a28 out nocopy JTF_NUMBER_TABLE
1309: )
1310:
1311: as
1312: ddp_ityv_tbl okl_ity_pvt.ityv_tbl_type;
1497: , p_init_msg_list VARCHAR2
1498: , x_return_status out nocopy VARCHAR2
1499: , x_msg_count out nocopy NUMBER
1500: , x_msg_data out nocopy VARCHAR2
1501: , p5_a0 JTF_NUMBER_TABLE
1502: , p5_a1 JTF_NUMBER_TABLE
1503: , p5_a2 JTF_VARCHAR2_TABLE_100
1504: , p5_a3 JTF_NUMBER_TABLE
1505: , p5_a4 JTF_VARCHAR2_TABLE_200
1498: , x_return_status out nocopy VARCHAR2
1499: , x_msg_count out nocopy NUMBER
1500: , x_msg_data out nocopy VARCHAR2
1501: , p5_a0 JTF_NUMBER_TABLE
1502: , p5_a1 JTF_NUMBER_TABLE
1503: , p5_a2 JTF_VARCHAR2_TABLE_100
1504: , p5_a3 JTF_NUMBER_TABLE
1505: , p5_a4 JTF_VARCHAR2_TABLE_200
1506: , p5_a5 JTF_VARCHAR2_TABLE_2000
1500: , x_msg_data out nocopy VARCHAR2
1501: , p5_a0 JTF_NUMBER_TABLE
1502: , p5_a1 JTF_NUMBER_TABLE
1503: , p5_a2 JTF_VARCHAR2_TABLE_100
1504: , p5_a3 JTF_NUMBER_TABLE
1505: , p5_a4 JTF_VARCHAR2_TABLE_200
1506: , p5_a5 JTF_VARCHAR2_TABLE_2000
1507: , p5_a6 JTF_VARCHAR2_TABLE_100
1508: , p5_a7 JTF_VARCHAR2_TABLE_100
1521: , p5_a20 JTF_VARCHAR2_TABLE_500
1522: , p5_a21 JTF_VARCHAR2_TABLE_500
1523: , p5_a22 JTF_VARCHAR2_TABLE_500
1524: , p5_a23 JTF_VARCHAR2_TABLE_500
1525: , p5_a24 JTF_NUMBER_TABLE
1526: , p5_a25 JTF_DATE_TABLE
1527: , p5_a26 JTF_NUMBER_TABLE
1528: , p5_a27 JTF_DATE_TABLE
1529: , p5_a28 JTF_NUMBER_TABLE
1523: , p5_a22 JTF_VARCHAR2_TABLE_500
1524: , p5_a23 JTF_VARCHAR2_TABLE_500
1525: , p5_a24 JTF_NUMBER_TABLE
1526: , p5_a25 JTF_DATE_TABLE
1527: , p5_a26 JTF_NUMBER_TABLE
1528: , p5_a27 JTF_DATE_TABLE
1529: , p5_a28 JTF_NUMBER_TABLE
1530: )
1531:
1525: , p5_a24 JTF_NUMBER_TABLE
1526: , p5_a25 JTF_DATE_TABLE
1527: , p5_a26 JTF_NUMBER_TABLE
1528: , p5_a27 JTF_DATE_TABLE
1529: , p5_a28 JTF_NUMBER_TABLE
1530: )
1531:
1532: as
1533: ddp_ityv_tbl okl_ity_pvt.ityv_tbl_type;
1684: , p_init_msg_list VARCHAR2
1685: , x_return_status out nocopy VARCHAR2
1686: , x_msg_count out nocopy NUMBER
1687: , x_msg_data out nocopy VARCHAR2
1688: , p5_a0 JTF_NUMBER_TABLE
1689: , p5_a1 JTF_NUMBER_TABLE
1690: , p5_a2 JTF_VARCHAR2_TABLE_100
1691: , p5_a3 JTF_NUMBER_TABLE
1692: , p5_a4 JTF_VARCHAR2_TABLE_200
1685: , x_return_status out nocopy VARCHAR2
1686: , x_msg_count out nocopy NUMBER
1687: , x_msg_data out nocopy VARCHAR2
1688: , p5_a0 JTF_NUMBER_TABLE
1689: , p5_a1 JTF_NUMBER_TABLE
1690: , p5_a2 JTF_VARCHAR2_TABLE_100
1691: , p5_a3 JTF_NUMBER_TABLE
1692: , p5_a4 JTF_VARCHAR2_TABLE_200
1693: , p5_a5 JTF_VARCHAR2_TABLE_2000
1687: , x_msg_data out nocopy VARCHAR2
1688: , p5_a0 JTF_NUMBER_TABLE
1689: , p5_a1 JTF_NUMBER_TABLE
1690: , p5_a2 JTF_VARCHAR2_TABLE_100
1691: , p5_a3 JTF_NUMBER_TABLE
1692: , p5_a4 JTF_VARCHAR2_TABLE_200
1693: , p5_a5 JTF_VARCHAR2_TABLE_2000
1694: , p5_a6 JTF_VARCHAR2_TABLE_100
1695: , p5_a7 JTF_VARCHAR2_TABLE_100
1708: , p5_a20 JTF_VARCHAR2_TABLE_500
1709: , p5_a21 JTF_VARCHAR2_TABLE_500
1710: , p5_a22 JTF_VARCHAR2_TABLE_500
1711: , p5_a23 JTF_VARCHAR2_TABLE_500
1712: , p5_a24 JTF_NUMBER_TABLE
1713: , p5_a25 JTF_DATE_TABLE
1714: , p5_a26 JTF_NUMBER_TABLE
1715: , p5_a27 JTF_DATE_TABLE
1716: , p5_a28 JTF_NUMBER_TABLE
1710: , p5_a22 JTF_VARCHAR2_TABLE_500
1711: , p5_a23 JTF_VARCHAR2_TABLE_500
1712: , p5_a24 JTF_NUMBER_TABLE
1713: , p5_a25 JTF_DATE_TABLE
1714: , p5_a26 JTF_NUMBER_TABLE
1715: , p5_a27 JTF_DATE_TABLE
1716: , p5_a28 JTF_NUMBER_TABLE
1717: )
1718:
1712: , p5_a24 JTF_NUMBER_TABLE
1713: , p5_a25 JTF_DATE_TABLE
1714: , p5_a26 JTF_NUMBER_TABLE
1715: , p5_a27 JTF_DATE_TABLE
1716: , p5_a28 JTF_NUMBER_TABLE
1717: )
1718:
1719: as
1720: ddp_ityv_tbl okl_ity_pvt.ityv_tbl_type;