19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_rgrp_rules_process_pvt.rgr_tbl_type, a0 JTF_VARCHAR2_TABLE_100
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_100
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_rgrp_rules_process_pvt.rgr_tbl_type, a0 JTF_VARCHAR2_TABLE_100
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_100
28: , a6 JTF_VARCHAR2_TABLE_100
31: , a9 JTF_VARCHAR2_TABLE_200
32: , a10 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_VARCHAR2_TABLE_100
34: , a12 JTF_VARCHAR2_TABLE_100
35: , a13 JTF_NUMBER_TABLE
36: , a14 JTF_NUMBER_TABLE
37: , a15 JTF_NUMBER_TABLE
38: , a16 JTF_VARCHAR2_TABLE_100
39: , a17 JTF_VARCHAR2_TABLE_2000
32: , a10 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_VARCHAR2_TABLE_100
34: , a12 JTF_VARCHAR2_TABLE_100
35: , a13 JTF_NUMBER_TABLE
36: , a14 JTF_NUMBER_TABLE
37: , a15 JTF_NUMBER_TABLE
38: , a16 JTF_VARCHAR2_TABLE_100
39: , a17 JTF_VARCHAR2_TABLE_2000
40: , a18 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_VARCHAR2_TABLE_100
34: , a12 JTF_VARCHAR2_TABLE_100
35: , a13 JTF_NUMBER_TABLE
36: , a14 JTF_NUMBER_TABLE
37: , a15 JTF_NUMBER_TABLE
38: , a16 JTF_VARCHAR2_TABLE_100
39: , a17 JTF_VARCHAR2_TABLE_2000
40: , a18 JTF_VARCHAR2_TABLE_100
41: , a19 JTF_VARCHAR2_TABLE_100
53: , a31 JTF_VARCHAR2_TABLE_500
54: , a32 JTF_VARCHAR2_TABLE_500
55: , a33 JTF_VARCHAR2_TABLE_500
56: , a34 JTF_VARCHAR2_TABLE_500
57: , a35 JTF_NUMBER_TABLE
58: , a36 JTF_DATE_TABLE
59: , a37 JTF_NUMBER_TABLE
60: , a38 JTF_DATE_TABLE
61: , a39 JTF_NUMBER_TABLE
55: , a33 JTF_VARCHAR2_TABLE_500
56: , a34 JTF_VARCHAR2_TABLE_500
57: , a35 JTF_NUMBER_TABLE
58: , a36 JTF_DATE_TABLE
59: , a37 JTF_NUMBER_TABLE
60: , a38 JTF_DATE_TABLE
61: , a39 JTF_NUMBER_TABLE
62: , a40 JTF_VARCHAR2_TABLE_100
63: , a41 JTF_VARCHAR2_TABLE_500
57: , a35 JTF_NUMBER_TABLE
58: , a36 JTF_DATE_TABLE
59: , a37 JTF_NUMBER_TABLE
60: , a38 JTF_DATE_TABLE
61: , a39 JTF_NUMBER_TABLE
62: , a40 JTF_VARCHAR2_TABLE_100
63: , a41 JTF_VARCHAR2_TABLE_500
64: , a42 JTF_VARCHAR2_TABLE_500
65: , a43 JTF_VARCHAR2_TABLE_500
78: , a56 JTF_VARCHAR2_TABLE_100
79: , a57 JTF_VARCHAR2_TABLE_100
80: , a58 JTF_VARCHAR2_TABLE_100
81: , a59 JTF_VARCHAR2_TABLE_100
82: , a60 JTF_NUMBER_TABLE
83: ) as
84: ddindx binary_integer; indx binary_integer;
85: begin
86: if a0 is not null and a0.count > 0 then
158: end if;
159: end if;
160: end rosetta_table_copy_in_p2;
161: procedure rosetta_table_copy_out_p2(t okl_rgrp_rules_process_pvt.rgr_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
162: , a1 out nocopy JTF_NUMBER_TABLE
163: , a2 out nocopy JTF_NUMBER_TABLE
164: , a3 out nocopy JTF_VARCHAR2_TABLE_100
165: , a4 out nocopy JTF_VARCHAR2_TABLE_100
166: , a5 out nocopy JTF_VARCHAR2_TABLE_100
159: end if;
160: end rosetta_table_copy_in_p2;
161: procedure rosetta_table_copy_out_p2(t okl_rgrp_rules_process_pvt.rgr_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
162: , a1 out nocopy JTF_NUMBER_TABLE
163: , a2 out nocopy JTF_NUMBER_TABLE
164: , a3 out nocopy JTF_VARCHAR2_TABLE_100
165: , a4 out nocopy JTF_VARCHAR2_TABLE_100
166: , a5 out nocopy JTF_VARCHAR2_TABLE_100
167: , a6 out nocopy JTF_VARCHAR2_TABLE_100
170: , a9 out nocopy JTF_VARCHAR2_TABLE_200
171: , a10 out nocopy JTF_VARCHAR2_TABLE_100
172: , a11 out nocopy JTF_VARCHAR2_TABLE_100
173: , a12 out nocopy JTF_VARCHAR2_TABLE_100
174: , a13 out nocopy JTF_NUMBER_TABLE
175: , a14 out nocopy JTF_NUMBER_TABLE
176: , a15 out nocopy JTF_NUMBER_TABLE
177: , a16 out nocopy JTF_VARCHAR2_TABLE_100
178: , a17 out nocopy JTF_VARCHAR2_TABLE_2000
171: , a10 out nocopy JTF_VARCHAR2_TABLE_100
172: , a11 out nocopy JTF_VARCHAR2_TABLE_100
173: , a12 out nocopy JTF_VARCHAR2_TABLE_100
174: , a13 out nocopy JTF_NUMBER_TABLE
175: , a14 out nocopy JTF_NUMBER_TABLE
176: , a15 out nocopy JTF_NUMBER_TABLE
177: , a16 out nocopy JTF_VARCHAR2_TABLE_100
178: , a17 out nocopy JTF_VARCHAR2_TABLE_2000
179: , a18 out nocopy JTF_VARCHAR2_TABLE_100
172: , a11 out nocopy JTF_VARCHAR2_TABLE_100
173: , a12 out nocopy JTF_VARCHAR2_TABLE_100
174: , a13 out nocopy JTF_NUMBER_TABLE
175: , a14 out nocopy JTF_NUMBER_TABLE
176: , a15 out nocopy JTF_NUMBER_TABLE
177: , a16 out nocopy JTF_VARCHAR2_TABLE_100
178: , a17 out nocopy JTF_VARCHAR2_TABLE_2000
179: , a18 out nocopy JTF_VARCHAR2_TABLE_100
180: , a19 out nocopy JTF_VARCHAR2_TABLE_100
192: , a31 out nocopy JTF_VARCHAR2_TABLE_500
193: , a32 out nocopy JTF_VARCHAR2_TABLE_500
194: , a33 out nocopy JTF_VARCHAR2_TABLE_500
195: , a34 out nocopy JTF_VARCHAR2_TABLE_500
196: , a35 out nocopy JTF_NUMBER_TABLE
197: , a36 out nocopy JTF_DATE_TABLE
198: , a37 out nocopy JTF_NUMBER_TABLE
199: , a38 out nocopy JTF_DATE_TABLE
200: , a39 out nocopy JTF_NUMBER_TABLE
194: , a33 out nocopy JTF_VARCHAR2_TABLE_500
195: , a34 out nocopy JTF_VARCHAR2_TABLE_500
196: , a35 out nocopy JTF_NUMBER_TABLE
197: , a36 out nocopy JTF_DATE_TABLE
198: , a37 out nocopy JTF_NUMBER_TABLE
199: , a38 out nocopy JTF_DATE_TABLE
200: , a39 out nocopy JTF_NUMBER_TABLE
201: , a40 out nocopy JTF_VARCHAR2_TABLE_100
202: , a41 out nocopy JTF_VARCHAR2_TABLE_500
196: , a35 out nocopy JTF_NUMBER_TABLE
197: , a36 out nocopy JTF_DATE_TABLE
198: , a37 out nocopy JTF_NUMBER_TABLE
199: , a38 out nocopy JTF_DATE_TABLE
200: , a39 out nocopy JTF_NUMBER_TABLE
201: , a40 out nocopy JTF_VARCHAR2_TABLE_100
202: , a41 out nocopy JTF_VARCHAR2_TABLE_500
203: , a42 out nocopy JTF_VARCHAR2_TABLE_500
204: , a43 out nocopy JTF_VARCHAR2_TABLE_500
217: , a56 out nocopy JTF_VARCHAR2_TABLE_100
218: , a57 out nocopy JTF_VARCHAR2_TABLE_100
219: , a58 out nocopy JTF_VARCHAR2_TABLE_100
220: , a59 out nocopy JTF_VARCHAR2_TABLE_100
221: , a60 out nocopy JTF_NUMBER_TABLE
222: ) as
223: ddindx binary_integer; indx binary_integer;
224: begin
225: if t is null or t.count = 0 then
223: ddindx binary_integer; indx binary_integer;
224: begin
225: if t is null or t.count = 0 then
226: a0 := JTF_VARCHAR2_TABLE_100();
227: a1 := JTF_NUMBER_TABLE();
228: a2 := JTF_NUMBER_TABLE();
229: a3 := JTF_VARCHAR2_TABLE_100();
230: a4 := JTF_VARCHAR2_TABLE_100();
231: a5 := JTF_VARCHAR2_TABLE_100();
224: begin
225: if t is null or t.count = 0 then
226: a0 := JTF_VARCHAR2_TABLE_100();
227: a1 := JTF_NUMBER_TABLE();
228: a2 := JTF_NUMBER_TABLE();
229: a3 := JTF_VARCHAR2_TABLE_100();
230: a4 := JTF_VARCHAR2_TABLE_100();
231: a5 := JTF_VARCHAR2_TABLE_100();
232: a6 := JTF_VARCHAR2_TABLE_100();
235: a9 := JTF_VARCHAR2_TABLE_200();
236: a10 := JTF_VARCHAR2_TABLE_100();
237: a11 := JTF_VARCHAR2_TABLE_100();
238: a12 := JTF_VARCHAR2_TABLE_100();
239: a13 := JTF_NUMBER_TABLE();
240: a14 := JTF_NUMBER_TABLE();
241: a15 := JTF_NUMBER_TABLE();
242: a16 := JTF_VARCHAR2_TABLE_100();
243: a17 := JTF_VARCHAR2_TABLE_2000();
236: a10 := JTF_VARCHAR2_TABLE_100();
237: a11 := JTF_VARCHAR2_TABLE_100();
238: a12 := JTF_VARCHAR2_TABLE_100();
239: a13 := JTF_NUMBER_TABLE();
240: a14 := JTF_NUMBER_TABLE();
241: a15 := JTF_NUMBER_TABLE();
242: a16 := JTF_VARCHAR2_TABLE_100();
243: a17 := JTF_VARCHAR2_TABLE_2000();
244: a18 := JTF_VARCHAR2_TABLE_100();
237: a11 := JTF_VARCHAR2_TABLE_100();
238: a12 := JTF_VARCHAR2_TABLE_100();
239: a13 := JTF_NUMBER_TABLE();
240: a14 := JTF_NUMBER_TABLE();
241: a15 := JTF_NUMBER_TABLE();
242: a16 := JTF_VARCHAR2_TABLE_100();
243: a17 := JTF_VARCHAR2_TABLE_2000();
244: a18 := JTF_VARCHAR2_TABLE_100();
245: a19 := JTF_VARCHAR2_TABLE_100();
257: a31 := JTF_VARCHAR2_TABLE_500();
258: a32 := JTF_VARCHAR2_TABLE_500();
259: a33 := JTF_VARCHAR2_TABLE_500();
260: a34 := JTF_VARCHAR2_TABLE_500();
261: a35 := JTF_NUMBER_TABLE();
262: a36 := JTF_DATE_TABLE();
263: a37 := JTF_NUMBER_TABLE();
264: a38 := JTF_DATE_TABLE();
265: a39 := JTF_NUMBER_TABLE();
259: a33 := JTF_VARCHAR2_TABLE_500();
260: a34 := JTF_VARCHAR2_TABLE_500();
261: a35 := JTF_NUMBER_TABLE();
262: a36 := JTF_DATE_TABLE();
263: a37 := JTF_NUMBER_TABLE();
264: a38 := JTF_DATE_TABLE();
265: a39 := JTF_NUMBER_TABLE();
266: a40 := JTF_VARCHAR2_TABLE_100();
267: a41 := JTF_VARCHAR2_TABLE_500();
261: a35 := JTF_NUMBER_TABLE();
262: a36 := JTF_DATE_TABLE();
263: a37 := JTF_NUMBER_TABLE();
264: a38 := JTF_DATE_TABLE();
265: a39 := JTF_NUMBER_TABLE();
266: a40 := JTF_VARCHAR2_TABLE_100();
267: a41 := JTF_VARCHAR2_TABLE_500();
268: a42 := JTF_VARCHAR2_TABLE_500();
269: a43 := JTF_VARCHAR2_TABLE_500();
282: a56 := JTF_VARCHAR2_TABLE_100();
283: a57 := JTF_VARCHAR2_TABLE_100();
284: a58 := JTF_VARCHAR2_TABLE_100();
285: a59 := JTF_VARCHAR2_TABLE_100();
286: a60 := JTF_NUMBER_TABLE();
287: else
288: a0 := JTF_VARCHAR2_TABLE_100();
289: a1 := JTF_NUMBER_TABLE();
290: a2 := JTF_NUMBER_TABLE();
285: a59 := JTF_VARCHAR2_TABLE_100();
286: a60 := JTF_NUMBER_TABLE();
287: else
288: a0 := JTF_VARCHAR2_TABLE_100();
289: a1 := JTF_NUMBER_TABLE();
290: a2 := JTF_NUMBER_TABLE();
291: a3 := JTF_VARCHAR2_TABLE_100();
292: a4 := JTF_VARCHAR2_TABLE_100();
293: a5 := JTF_VARCHAR2_TABLE_100();
286: a60 := JTF_NUMBER_TABLE();
287: else
288: a0 := JTF_VARCHAR2_TABLE_100();
289: a1 := JTF_NUMBER_TABLE();
290: a2 := JTF_NUMBER_TABLE();
291: a3 := JTF_VARCHAR2_TABLE_100();
292: a4 := JTF_VARCHAR2_TABLE_100();
293: a5 := JTF_VARCHAR2_TABLE_100();
294: a6 := JTF_VARCHAR2_TABLE_100();
297: a9 := JTF_VARCHAR2_TABLE_200();
298: a10 := JTF_VARCHAR2_TABLE_100();
299: a11 := JTF_VARCHAR2_TABLE_100();
300: a12 := JTF_VARCHAR2_TABLE_100();
301: a13 := JTF_NUMBER_TABLE();
302: a14 := JTF_NUMBER_TABLE();
303: a15 := JTF_NUMBER_TABLE();
304: a16 := JTF_VARCHAR2_TABLE_100();
305: a17 := JTF_VARCHAR2_TABLE_2000();
298: a10 := JTF_VARCHAR2_TABLE_100();
299: a11 := JTF_VARCHAR2_TABLE_100();
300: a12 := JTF_VARCHAR2_TABLE_100();
301: a13 := JTF_NUMBER_TABLE();
302: a14 := JTF_NUMBER_TABLE();
303: a15 := JTF_NUMBER_TABLE();
304: a16 := JTF_VARCHAR2_TABLE_100();
305: a17 := JTF_VARCHAR2_TABLE_2000();
306: a18 := JTF_VARCHAR2_TABLE_100();
299: a11 := JTF_VARCHAR2_TABLE_100();
300: a12 := JTF_VARCHAR2_TABLE_100();
301: a13 := JTF_NUMBER_TABLE();
302: a14 := JTF_NUMBER_TABLE();
303: a15 := JTF_NUMBER_TABLE();
304: a16 := JTF_VARCHAR2_TABLE_100();
305: a17 := JTF_VARCHAR2_TABLE_2000();
306: a18 := JTF_VARCHAR2_TABLE_100();
307: a19 := JTF_VARCHAR2_TABLE_100();
319: a31 := JTF_VARCHAR2_TABLE_500();
320: a32 := JTF_VARCHAR2_TABLE_500();
321: a33 := JTF_VARCHAR2_TABLE_500();
322: a34 := JTF_VARCHAR2_TABLE_500();
323: a35 := JTF_NUMBER_TABLE();
324: a36 := JTF_DATE_TABLE();
325: a37 := JTF_NUMBER_TABLE();
326: a38 := JTF_DATE_TABLE();
327: a39 := JTF_NUMBER_TABLE();
321: a33 := JTF_VARCHAR2_TABLE_500();
322: a34 := JTF_VARCHAR2_TABLE_500();
323: a35 := JTF_NUMBER_TABLE();
324: a36 := JTF_DATE_TABLE();
325: a37 := JTF_NUMBER_TABLE();
326: a38 := JTF_DATE_TABLE();
327: a39 := JTF_NUMBER_TABLE();
328: a40 := JTF_VARCHAR2_TABLE_100();
329: a41 := JTF_VARCHAR2_TABLE_500();
323: a35 := JTF_NUMBER_TABLE();
324: a36 := JTF_DATE_TABLE();
325: a37 := JTF_NUMBER_TABLE();
326: a38 := JTF_DATE_TABLE();
327: a39 := JTF_NUMBER_TABLE();
328: a40 := JTF_VARCHAR2_TABLE_100();
329: a41 := JTF_VARCHAR2_TABLE_500();
330: a42 := JTF_VARCHAR2_TABLE_500();
331: a43 := JTF_VARCHAR2_TABLE_500();
344: a56 := JTF_VARCHAR2_TABLE_100();
345: a57 := JTF_VARCHAR2_TABLE_100();
346: a58 := JTF_VARCHAR2_TABLE_100();
347: a59 := JTF_VARCHAR2_TABLE_100();
348: a60 := JTF_NUMBER_TABLE();
349: if t.count > 0 then
350: a0.extend(t.count);
351: a1.extend(t.count);
352: a2.extend(t.count);
481: end if;
482: end if;
483: end rosetta_table_copy_out_p2;
484:
485: procedure rosetta_table_copy_in_p3(t out nocopy okl_rgrp_rules_process_pvt.rgr_out_tbl_type, a0 JTF_NUMBER_TABLE
486: , a1 JTF_VARCHAR2_TABLE_100
487: , a2 JTF_VARCHAR2_TABLE_100
488: , a3 JTF_VARCHAR2_TABLE_100
489: ) as
506: end loop;
507: end if;
508: end if;
509: end rosetta_table_copy_in_p3;
510: procedure rosetta_table_copy_out_p3(t okl_rgrp_rules_process_pvt.rgr_out_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
511: , a1 out nocopy JTF_VARCHAR2_TABLE_100
512: , a2 out nocopy JTF_VARCHAR2_TABLE_100
513: , a3 out nocopy JTF_VARCHAR2_TABLE_100
514: ) as
514: ) as
515: ddindx binary_integer; indx binary_integer;
516: begin
517: if t is null or t.count = 0 then
518: a0 := JTF_NUMBER_TABLE();
519: a1 := JTF_VARCHAR2_TABLE_100();
520: a2 := JTF_VARCHAR2_TABLE_100();
521: a3 := JTF_VARCHAR2_TABLE_100();
522: else
519: a1 := JTF_VARCHAR2_TABLE_100();
520: a2 := JTF_VARCHAR2_TABLE_100();
521: a3 := JTF_VARCHAR2_TABLE_100();
522: else
523: a0 := JTF_NUMBER_TABLE();
524: a1 := JTF_VARCHAR2_TABLE_100();
525: a2 := JTF_VARCHAR2_TABLE_100();
526: a3 := JTF_VARCHAR2_TABLE_100();
527: if t.count > 0 then
555: , p_line_id NUMBER
556: , p_cpl_id NUMBER
557: , p_rrd_id NUMBER
558: , p9_a0 JTF_VARCHAR2_TABLE_100
559: , p9_a1 JTF_NUMBER_TABLE
560: , p9_a2 JTF_NUMBER_TABLE
561: , p9_a3 JTF_VARCHAR2_TABLE_100
562: , p9_a4 JTF_VARCHAR2_TABLE_100
563: , p9_a5 JTF_VARCHAR2_TABLE_100
556: , p_cpl_id NUMBER
557: , p_rrd_id NUMBER
558: , p9_a0 JTF_VARCHAR2_TABLE_100
559: , p9_a1 JTF_NUMBER_TABLE
560: , p9_a2 JTF_NUMBER_TABLE
561: , p9_a3 JTF_VARCHAR2_TABLE_100
562: , p9_a4 JTF_VARCHAR2_TABLE_100
563: , p9_a5 JTF_VARCHAR2_TABLE_100
564: , p9_a6 JTF_VARCHAR2_TABLE_100
567: , p9_a9 JTF_VARCHAR2_TABLE_200
568: , p9_a10 JTF_VARCHAR2_TABLE_100
569: , p9_a11 JTF_VARCHAR2_TABLE_100
570: , p9_a12 JTF_VARCHAR2_TABLE_100
571: , p9_a13 JTF_NUMBER_TABLE
572: , p9_a14 JTF_NUMBER_TABLE
573: , p9_a15 JTF_NUMBER_TABLE
574: , p9_a16 JTF_VARCHAR2_TABLE_100
575: , p9_a17 JTF_VARCHAR2_TABLE_2000
568: , p9_a10 JTF_VARCHAR2_TABLE_100
569: , p9_a11 JTF_VARCHAR2_TABLE_100
570: , p9_a12 JTF_VARCHAR2_TABLE_100
571: , p9_a13 JTF_NUMBER_TABLE
572: , p9_a14 JTF_NUMBER_TABLE
573: , p9_a15 JTF_NUMBER_TABLE
574: , p9_a16 JTF_VARCHAR2_TABLE_100
575: , p9_a17 JTF_VARCHAR2_TABLE_2000
576: , p9_a18 JTF_VARCHAR2_TABLE_100
569: , p9_a11 JTF_VARCHAR2_TABLE_100
570: , p9_a12 JTF_VARCHAR2_TABLE_100
571: , p9_a13 JTF_NUMBER_TABLE
572: , p9_a14 JTF_NUMBER_TABLE
573: , p9_a15 JTF_NUMBER_TABLE
574: , p9_a16 JTF_VARCHAR2_TABLE_100
575: , p9_a17 JTF_VARCHAR2_TABLE_2000
576: , p9_a18 JTF_VARCHAR2_TABLE_100
577: , p9_a19 JTF_VARCHAR2_TABLE_100
589: , p9_a31 JTF_VARCHAR2_TABLE_500
590: , p9_a32 JTF_VARCHAR2_TABLE_500
591: , p9_a33 JTF_VARCHAR2_TABLE_500
592: , p9_a34 JTF_VARCHAR2_TABLE_500
593: , p9_a35 JTF_NUMBER_TABLE
594: , p9_a36 JTF_DATE_TABLE
595: , p9_a37 JTF_NUMBER_TABLE
596: , p9_a38 JTF_DATE_TABLE
597: , p9_a39 JTF_NUMBER_TABLE
591: , p9_a33 JTF_VARCHAR2_TABLE_500
592: , p9_a34 JTF_VARCHAR2_TABLE_500
593: , p9_a35 JTF_NUMBER_TABLE
594: , p9_a36 JTF_DATE_TABLE
595: , p9_a37 JTF_NUMBER_TABLE
596: , p9_a38 JTF_DATE_TABLE
597: , p9_a39 JTF_NUMBER_TABLE
598: , p9_a40 JTF_VARCHAR2_TABLE_100
599: , p9_a41 JTF_VARCHAR2_TABLE_500
593: , p9_a35 JTF_NUMBER_TABLE
594: , p9_a36 JTF_DATE_TABLE
595: , p9_a37 JTF_NUMBER_TABLE
596: , p9_a38 JTF_DATE_TABLE
597: , p9_a39 JTF_NUMBER_TABLE
598: , p9_a40 JTF_VARCHAR2_TABLE_100
599: , p9_a41 JTF_VARCHAR2_TABLE_500
600: , p9_a42 JTF_VARCHAR2_TABLE_500
601: , p9_a43 JTF_VARCHAR2_TABLE_500
614: , p9_a56 JTF_VARCHAR2_TABLE_100
615: , p9_a57 JTF_VARCHAR2_TABLE_100
616: , p9_a58 JTF_VARCHAR2_TABLE_100
617: , p9_a59 JTF_VARCHAR2_TABLE_100
618: , p9_a60 JTF_NUMBER_TABLE
619: )
620:
621: as
622: ddp_rgr_tbl okl_rgrp_rules_process_pvt.rgr_tbl_type;
726: , x_msg_count out nocopy NUMBER
727: , x_msg_data out nocopy VARCHAR2
728: , p_id NUMBER
729: , p6_a0 JTF_VARCHAR2_TABLE_100
730: , p6_a1 JTF_NUMBER_TABLE
731: , p6_a2 JTF_NUMBER_TABLE
732: , p6_a3 JTF_VARCHAR2_TABLE_100
733: , p6_a4 JTF_VARCHAR2_TABLE_100
734: , p6_a5 JTF_VARCHAR2_TABLE_100
727: , x_msg_data out nocopy VARCHAR2
728: , p_id NUMBER
729: , p6_a0 JTF_VARCHAR2_TABLE_100
730: , p6_a1 JTF_NUMBER_TABLE
731: , p6_a2 JTF_NUMBER_TABLE
732: , p6_a3 JTF_VARCHAR2_TABLE_100
733: , p6_a4 JTF_VARCHAR2_TABLE_100
734: , p6_a5 JTF_VARCHAR2_TABLE_100
735: , p6_a6 JTF_VARCHAR2_TABLE_100
738: , p6_a9 JTF_VARCHAR2_TABLE_200
739: , p6_a10 JTF_VARCHAR2_TABLE_100
740: , p6_a11 JTF_VARCHAR2_TABLE_100
741: , p6_a12 JTF_VARCHAR2_TABLE_100
742: , p6_a13 JTF_NUMBER_TABLE
743: , p6_a14 JTF_NUMBER_TABLE
744: , p6_a15 JTF_NUMBER_TABLE
745: , p6_a16 JTF_VARCHAR2_TABLE_100
746: , p6_a17 JTF_VARCHAR2_TABLE_2000
739: , p6_a10 JTF_VARCHAR2_TABLE_100
740: , p6_a11 JTF_VARCHAR2_TABLE_100
741: , p6_a12 JTF_VARCHAR2_TABLE_100
742: , p6_a13 JTF_NUMBER_TABLE
743: , p6_a14 JTF_NUMBER_TABLE
744: , p6_a15 JTF_NUMBER_TABLE
745: , p6_a16 JTF_VARCHAR2_TABLE_100
746: , p6_a17 JTF_VARCHAR2_TABLE_2000
747: , p6_a18 JTF_VARCHAR2_TABLE_100
740: , p6_a11 JTF_VARCHAR2_TABLE_100
741: , p6_a12 JTF_VARCHAR2_TABLE_100
742: , p6_a13 JTF_NUMBER_TABLE
743: , p6_a14 JTF_NUMBER_TABLE
744: , p6_a15 JTF_NUMBER_TABLE
745: , p6_a16 JTF_VARCHAR2_TABLE_100
746: , p6_a17 JTF_VARCHAR2_TABLE_2000
747: , p6_a18 JTF_VARCHAR2_TABLE_100
748: , p6_a19 JTF_VARCHAR2_TABLE_100
760: , p6_a31 JTF_VARCHAR2_TABLE_500
761: , p6_a32 JTF_VARCHAR2_TABLE_500
762: , p6_a33 JTF_VARCHAR2_TABLE_500
763: , p6_a34 JTF_VARCHAR2_TABLE_500
764: , p6_a35 JTF_NUMBER_TABLE
765: , p6_a36 JTF_DATE_TABLE
766: , p6_a37 JTF_NUMBER_TABLE
767: , p6_a38 JTF_DATE_TABLE
768: , p6_a39 JTF_NUMBER_TABLE
762: , p6_a33 JTF_VARCHAR2_TABLE_500
763: , p6_a34 JTF_VARCHAR2_TABLE_500
764: , p6_a35 JTF_NUMBER_TABLE
765: , p6_a36 JTF_DATE_TABLE
766: , p6_a37 JTF_NUMBER_TABLE
767: , p6_a38 JTF_DATE_TABLE
768: , p6_a39 JTF_NUMBER_TABLE
769: , p6_a40 JTF_VARCHAR2_TABLE_100
770: , p6_a41 JTF_VARCHAR2_TABLE_500
764: , p6_a35 JTF_NUMBER_TABLE
765: , p6_a36 JTF_DATE_TABLE
766: , p6_a37 JTF_NUMBER_TABLE
767: , p6_a38 JTF_DATE_TABLE
768: , p6_a39 JTF_NUMBER_TABLE
769: , p6_a40 JTF_VARCHAR2_TABLE_100
770: , p6_a41 JTF_VARCHAR2_TABLE_500
771: , p6_a42 JTF_VARCHAR2_TABLE_500
772: , p6_a43 JTF_VARCHAR2_TABLE_500
785: , p6_a56 JTF_VARCHAR2_TABLE_100
786: , p6_a57 JTF_VARCHAR2_TABLE_100
787: , p6_a58 JTF_VARCHAR2_TABLE_100
788: , p6_a59 JTF_VARCHAR2_TABLE_100
789: , p6_a60 JTF_NUMBER_TABLE
790: , p7_a0 out nocopy JTF_NUMBER_TABLE
791: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
792: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
793: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
786: , p6_a57 JTF_VARCHAR2_TABLE_100
787: , p6_a58 JTF_VARCHAR2_TABLE_100
788: , p6_a59 JTF_VARCHAR2_TABLE_100
789: , p6_a60 JTF_NUMBER_TABLE
790: , p7_a0 out nocopy JTF_NUMBER_TABLE
791: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
792: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
793: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
794: )