1: package body okl_lease_quote_fee_pvt_w as
2: /* $Header: OKLEQUFB.pls 120.6.12020000.2 2012/08/07 12:51:06 racheruv ship $ */
3: procedure rosetta_table_copy_in_p24(t out nocopy okl_lease_quote_fee_pvt.line_relation_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
1: package body okl_lease_quote_fee_pvt_w as
2: /* $Header: OKLEQUFB.pls 120.6.12020000.2 2012/08/07 12:51:06 racheruv ship $ */
3: procedure rosetta_table_copy_in_p24(t out nocopy okl_lease_quote_fee_pvt.line_relation_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE
2: /* $Header: OKLEQUFB.pls 120.6.12020000.2 2012/08/07 12:51:06 racheruv ship $ */
3: procedure rosetta_table_copy_in_p24(t out nocopy okl_lease_quote_fee_pvt.line_relation_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_300
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_300
11: , a8 JTF_VARCHAR2_TABLE_2000
12: , a9 JTF_VARCHAR2_TABLE_2000
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_300
11: , a8 JTF_VARCHAR2_TABLE_2000
12: , a9 JTF_VARCHAR2_TABLE_2000
13: , a10 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_300
11: , a8 JTF_VARCHAR2_TABLE_2000
12: , a9 JTF_VARCHAR2_TABLE_2000
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_NUMBER_TABLE
15: ) as
16: ddindx binary_integer; indx binary_integer;
17: begin
18: if a0 is not null and a0.count > 0 then
40: end loop;
41: end if;
42: end if;
43: end rosetta_table_copy_in_p24;
44: procedure rosetta_table_copy_out_p24(t okl_lease_quote_fee_pvt.line_relation_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
45: , a1 out nocopy JTF_NUMBER_TABLE
46: , a2 out nocopy JTF_VARCHAR2_TABLE_100
47: , a3 out nocopy JTF_NUMBER_TABLE
48: , a4 out nocopy JTF_VARCHAR2_TABLE_100
41: end if;
42: end if;
43: end rosetta_table_copy_in_p24;
44: procedure rosetta_table_copy_out_p24(t okl_lease_quote_fee_pvt.line_relation_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
45: , a1 out nocopy JTF_NUMBER_TABLE
46: , a2 out nocopy JTF_VARCHAR2_TABLE_100
47: , a3 out nocopy JTF_NUMBER_TABLE
48: , a4 out nocopy JTF_VARCHAR2_TABLE_100
49: , a5 out nocopy JTF_NUMBER_TABLE
43: end rosetta_table_copy_in_p24;
44: procedure rosetta_table_copy_out_p24(t okl_lease_quote_fee_pvt.line_relation_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
45: , a1 out nocopy JTF_NUMBER_TABLE
46: , a2 out nocopy JTF_VARCHAR2_TABLE_100
47: , a3 out nocopy JTF_NUMBER_TABLE
48: , a4 out nocopy JTF_VARCHAR2_TABLE_100
49: , a5 out nocopy JTF_NUMBER_TABLE
50: , a6 out nocopy JTF_NUMBER_TABLE
51: , a7 out nocopy JTF_VARCHAR2_TABLE_300
45: , a1 out nocopy JTF_NUMBER_TABLE
46: , a2 out nocopy JTF_VARCHAR2_TABLE_100
47: , a3 out nocopy JTF_NUMBER_TABLE
48: , a4 out nocopy JTF_VARCHAR2_TABLE_100
49: , a5 out nocopy JTF_NUMBER_TABLE
50: , a6 out nocopy JTF_NUMBER_TABLE
51: , a7 out nocopy JTF_VARCHAR2_TABLE_300
52: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
53: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
46: , a2 out nocopy JTF_VARCHAR2_TABLE_100
47: , a3 out nocopy JTF_NUMBER_TABLE
48: , a4 out nocopy JTF_VARCHAR2_TABLE_100
49: , a5 out nocopy JTF_NUMBER_TABLE
50: , a6 out nocopy JTF_NUMBER_TABLE
51: , a7 out nocopy JTF_VARCHAR2_TABLE_300
52: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
53: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
54: , a10 out nocopy JTF_VARCHAR2_TABLE_100
51: , a7 out nocopy JTF_VARCHAR2_TABLE_300
52: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
53: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
54: , a10 out nocopy JTF_VARCHAR2_TABLE_100
55: , a11 out nocopy JTF_NUMBER_TABLE
56: ) as
57: ddindx binary_integer; indx binary_integer;
58: begin
59: if t is null or t.count = 0 then
56: ) as
57: ddindx binary_integer; indx binary_integer;
58: begin
59: if t is null or t.count = 0 then
60: a0 := JTF_NUMBER_TABLE();
61: a1 := JTF_NUMBER_TABLE();
62: a2 := JTF_VARCHAR2_TABLE_100();
63: a3 := JTF_NUMBER_TABLE();
64: a4 := JTF_VARCHAR2_TABLE_100();
57: ddindx binary_integer; indx binary_integer;
58: begin
59: if t is null or t.count = 0 then
60: a0 := JTF_NUMBER_TABLE();
61: a1 := JTF_NUMBER_TABLE();
62: a2 := JTF_VARCHAR2_TABLE_100();
63: a3 := JTF_NUMBER_TABLE();
64: a4 := JTF_VARCHAR2_TABLE_100();
65: a5 := JTF_NUMBER_TABLE();
59: if t is null or t.count = 0 then
60: a0 := JTF_NUMBER_TABLE();
61: a1 := JTF_NUMBER_TABLE();
62: a2 := JTF_VARCHAR2_TABLE_100();
63: a3 := JTF_NUMBER_TABLE();
64: a4 := JTF_VARCHAR2_TABLE_100();
65: a5 := JTF_NUMBER_TABLE();
66: a6 := JTF_NUMBER_TABLE();
67: a7 := JTF_VARCHAR2_TABLE_300();
61: a1 := JTF_NUMBER_TABLE();
62: a2 := JTF_VARCHAR2_TABLE_100();
63: a3 := JTF_NUMBER_TABLE();
64: a4 := JTF_VARCHAR2_TABLE_100();
65: a5 := JTF_NUMBER_TABLE();
66: a6 := JTF_NUMBER_TABLE();
67: a7 := JTF_VARCHAR2_TABLE_300();
68: a8 := JTF_VARCHAR2_TABLE_2000();
69: a9 := JTF_VARCHAR2_TABLE_2000();
62: a2 := JTF_VARCHAR2_TABLE_100();
63: a3 := JTF_NUMBER_TABLE();
64: a4 := JTF_VARCHAR2_TABLE_100();
65: a5 := JTF_NUMBER_TABLE();
66: a6 := JTF_NUMBER_TABLE();
67: a7 := JTF_VARCHAR2_TABLE_300();
68: a8 := JTF_VARCHAR2_TABLE_2000();
69: a9 := JTF_VARCHAR2_TABLE_2000();
70: a10 := JTF_VARCHAR2_TABLE_100();
67: a7 := JTF_VARCHAR2_TABLE_300();
68: a8 := JTF_VARCHAR2_TABLE_2000();
69: a9 := JTF_VARCHAR2_TABLE_2000();
70: a10 := JTF_VARCHAR2_TABLE_100();
71: a11 := JTF_NUMBER_TABLE();
72: else
73: a0 := JTF_NUMBER_TABLE();
74: a1 := JTF_NUMBER_TABLE();
75: a2 := JTF_VARCHAR2_TABLE_100();
69: a9 := JTF_VARCHAR2_TABLE_2000();
70: a10 := JTF_VARCHAR2_TABLE_100();
71: a11 := JTF_NUMBER_TABLE();
72: else
73: a0 := JTF_NUMBER_TABLE();
74: a1 := JTF_NUMBER_TABLE();
75: a2 := JTF_VARCHAR2_TABLE_100();
76: a3 := JTF_NUMBER_TABLE();
77: a4 := JTF_VARCHAR2_TABLE_100();
70: a10 := JTF_VARCHAR2_TABLE_100();
71: a11 := JTF_NUMBER_TABLE();
72: else
73: a0 := JTF_NUMBER_TABLE();
74: a1 := JTF_NUMBER_TABLE();
75: a2 := JTF_VARCHAR2_TABLE_100();
76: a3 := JTF_NUMBER_TABLE();
77: a4 := JTF_VARCHAR2_TABLE_100();
78: a5 := JTF_NUMBER_TABLE();
72: else
73: a0 := JTF_NUMBER_TABLE();
74: a1 := JTF_NUMBER_TABLE();
75: a2 := JTF_VARCHAR2_TABLE_100();
76: a3 := JTF_NUMBER_TABLE();
77: a4 := JTF_VARCHAR2_TABLE_100();
78: a5 := JTF_NUMBER_TABLE();
79: a6 := JTF_NUMBER_TABLE();
80: a7 := JTF_VARCHAR2_TABLE_300();
74: a1 := JTF_NUMBER_TABLE();
75: a2 := JTF_VARCHAR2_TABLE_100();
76: a3 := JTF_NUMBER_TABLE();
77: a4 := JTF_VARCHAR2_TABLE_100();
78: a5 := JTF_NUMBER_TABLE();
79: a6 := JTF_NUMBER_TABLE();
80: a7 := JTF_VARCHAR2_TABLE_300();
81: a8 := JTF_VARCHAR2_TABLE_2000();
82: a9 := JTF_VARCHAR2_TABLE_2000();
75: a2 := JTF_VARCHAR2_TABLE_100();
76: a3 := JTF_NUMBER_TABLE();
77: a4 := JTF_VARCHAR2_TABLE_100();
78: a5 := JTF_NUMBER_TABLE();
79: a6 := JTF_NUMBER_TABLE();
80: a7 := JTF_VARCHAR2_TABLE_300();
81: a8 := JTF_VARCHAR2_TABLE_2000();
82: a9 := JTF_VARCHAR2_TABLE_2000();
83: a10 := JTF_VARCHAR2_TABLE_100();
80: a7 := JTF_VARCHAR2_TABLE_300();
81: a8 := JTF_VARCHAR2_TABLE_2000();
82: a9 := JTF_VARCHAR2_TABLE_2000();
83: a10 := JTF_VARCHAR2_TABLE_100();
84: a11 := JTF_NUMBER_TABLE();
85: if t.count > 0 then
86: a0.extend(t.count);
87: a1.extend(t.count);
88: a2.extend(t.count);
162: , p3_a36 VARCHAR2
163: , p3_a37 VARCHAR2
164: , p3_a38 NUMBER
165: , p3_a39 VARCHAR2
166: , p4_a0 JTF_NUMBER_TABLE
167: , p4_a1 JTF_NUMBER_TABLE
168: , p4_a2 JTF_VARCHAR2_TABLE_100
169: , p4_a3 JTF_NUMBER_TABLE
170: , p4_a4 JTF_VARCHAR2_TABLE_100
163: , p3_a37 VARCHAR2
164: , p3_a38 NUMBER
165: , p3_a39 VARCHAR2
166: , p4_a0 JTF_NUMBER_TABLE
167: , p4_a1 JTF_NUMBER_TABLE
168: , p4_a2 JTF_VARCHAR2_TABLE_100
169: , p4_a3 JTF_NUMBER_TABLE
170: , p4_a4 JTF_VARCHAR2_TABLE_100
171: , p4_a5 JTF_NUMBER_TABLE
165: , p3_a39 VARCHAR2
166: , p4_a0 JTF_NUMBER_TABLE
167: , p4_a1 JTF_NUMBER_TABLE
168: , p4_a2 JTF_VARCHAR2_TABLE_100
169: , p4_a3 JTF_NUMBER_TABLE
170: , p4_a4 JTF_VARCHAR2_TABLE_100
171: , p4_a5 JTF_NUMBER_TABLE
172: , p4_a6 JTF_NUMBER_TABLE
173: , p4_a7 JTF_VARCHAR2_TABLE_300
167: , p4_a1 JTF_NUMBER_TABLE
168: , p4_a2 JTF_VARCHAR2_TABLE_100
169: , p4_a3 JTF_NUMBER_TABLE
170: , p4_a4 JTF_VARCHAR2_TABLE_100
171: , p4_a5 JTF_NUMBER_TABLE
172: , p4_a6 JTF_NUMBER_TABLE
173: , p4_a7 JTF_VARCHAR2_TABLE_300
174: , p4_a8 JTF_VARCHAR2_TABLE_2000
175: , p4_a9 JTF_VARCHAR2_TABLE_2000
168: , p4_a2 JTF_VARCHAR2_TABLE_100
169: , p4_a3 JTF_NUMBER_TABLE
170: , p4_a4 JTF_VARCHAR2_TABLE_100
171: , p4_a5 JTF_NUMBER_TABLE
172: , p4_a6 JTF_NUMBER_TABLE
173: , p4_a7 JTF_VARCHAR2_TABLE_300
174: , p4_a8 JTF_VARCHAR2_TABLE_2000
175: , p4_a9 JTF_VARCHAR2_TABLE_2000
176: , p4_a10 JTF_VARCHAR2_TABLE_100
173: , p4_a7 JTF_VARCHAR2_TABLE_300
174: , p4_a8 JTF_VARCHAR2_TABLE_2000
175: , p4_a9 JTF_VARCHAR2_TABLE_2000
176: , p4_a10 JTF_VARCHAR2_TABLE_100
177: , p4_a11 JTF_NUMBER_TABLE
178: , p5_a0 VARCHAR2
179: , p5_a1 NUMBER
180: , p5_a2 VARCHAR2
181: , p5_a3 VARCHAR2
188: , p5_a10 NUMBER
189: , p5_a11 NUMBER
190: , p5_a12 NUMBER
191: , p5_a13 NUMBER
192: , p6_a0 JTF_NUMBER_TABLE
193: , p6_a1 JTF_DATE_TABLE
194: , p6_a2 JTF_NUMBER_TABLE
195: , p6_a3 JTF_NUMBER_TABLE
196: , p6_a4 JTF_NUMBER_TABLE
190: , p5_a12 NUMBER
191: , p5_a13 NUMBER
192: , p6_a0 JTF_NUMBER_TABLE
193: , p6_a1 JTF_DATE_TABLE
194: , p6_a2 JTF_NUMBER_TABLE
195: , p6_a3 JTF_NUMBER_TABLE
196: , p6_a4 JTF_NUMBER_TABLE
197: , p6_a5 JTF_NUMBER_TABLE
198: , p6_a6 JTF_NUMBER_TABLE
191: , p5_a13 NUMBER
192: , p6_a0 JTF_NUMBER_TABLE
193: , p6_a1 JTF_DATE_TABLE
194: , p6_a2 JTF_NUMBER_TABLE
195: , p6_a3 JTF_NUMBER_TABLE
196: , p6_a4 JTF_NUMBER_TABLE
197: , p6_a5 JTF_NUMBER_TABLE
198: , p6_a6 JTF_NUMBER_TABLE
199: , p6_a7 JTF_NUMBER_TABLE
192: , p6_a0 JTF_NUMBER_TABLE
193: , p6_a1 JTF_DATE_TABLE
194: , p6_a2 JTF_NUMBER_TABLE
195: , p6_a3 JTF_NUMBER_TABLE
196: , p6_a4 JTF_NUMBER_TABLE
197: , p6_a5 JTF_NUMBER_TABLE
198: , p6_a6 JTF_NUMBER_TABLE
199: , p6_a7 JTF_NUMBER_TABLE
200: , p6_a8 JTF_VARCHAR2_TABLE_100
193: , p6_a1 JTF_DATE_TABLE
194: , p6_a2 JTF_NUMBER_TABLE
195: , p6_a3 JTF_NUMBER_TABLE
196: , p6_a4 JTF_NUMBER_TABLE
197: , p6_a5 JTF_NUMBER_TABLE
198: , p6_a6 JTF_NUMBER_TABLE
199: , p6_a7 JTF_NUMBER_TABLE
200: , p6_a8 JTF_VARCHAR2_TABLE_100
201: , p6_a9 JTF_VARCHAR2_TABLE_100
194: , p6_a2 JTF_NUMBER_TABLE
195: , p6_a3 JTF_NUMBER_TABLE
196: , p6_a4 JTF_NUMBER_TABLE
197: , p6_a5 JTF_NUMBER_TABLE
198: , p6_a6 JTF_NUMBER_TABLE
199: , p6_a7 JTF_NUMBER_TABLE
200: , p6_a8 JTF_VARCHAR2_TABLE_100
201: , p6_a9 JTF_VARCHAR2_TABLE_100
202: , p7_a0 VARCHAR2
195: , p6_a3 JTF_NUMBER_TABLE
196: , p6_a4 JTF_NUMBER_TABLE
197: , p6_a5 JTF_NUMBER_TABLE
198: , p6_a6 JTF_NUMBER_TABLE
199: , p6_a7 JTF_NUMBER_TABLE
200: , p6_a8 JTF_VARCHAR2_TABLE_100
201: , p6_a9 JTF_VARCHAR2_TABLE_100
202: , p7_a0 VARCHAR2
203: , p7_a1 NUMBER
212: , p7_a10 NUMBER
213: , p7_a11 NUMBER
214: , p7_a12 NUMBER
215: , p7_a13 NUMBER
216: , p8_a0 JTF_NUMBER_TABLE
217: , p8_a1 JTF_DATE_TABLE
218: , p8_a2 JTF_NUMBER_TABLE
219: , p8_a3 JTF_NUMBER_TABLE
220: , p8_a4 JTF_NUMBER_TABLE
214: , p7_a12 NUMBER
215: , p7_a13 NUMBER
216: , p8_a0 JTF_NUMBER_TABLE
217: , p8_a1 JTF_DATE_TABLE
218: , p8_a2 JTF_NUMBER_TABLE
219: , p8_a3 JTF_NUMBER_TABLE
220: , p8_a4 JTF_NUMBER_TABLE
221: , p8_a5 JTF_NUMBER_TABLE
222: , p8_a6 JTF_NUMBER_TABLE
215: , p7_a13 NUMBER
216: , p8_a0 JTF_NUMBER_TABLE
217: , p8_a1 JTF_DATE_TABLE
218: , p8_a2 JTF_NUMBER_TABLE
219: , p8_a3 JTF_NUMBER_TABLE
220: , p8_a4 JTF_NUMBER_TABLE
221: , p8_a5 JTF_NUMBER_TABLE
222: , p8_a6 JTF_NUMBER_TABLE
223: , p8_a7 JTF_NUMBER_TABLE
216: , p8_a0 JTF_NUMBER_TABLE
217: , p8_a1 JTF_DATE_TABLE
218: , p8_a2 JTF_NUMBER_TABLE
219: , p8_a3 JTF_NUMBER_TABLE
220: , p8_a4 JTF_NUMBER_TABLE
221: , p8_a5 JTF_NUMBER_TABLE
222: , p8_a6 JTF_NUMBER_TABLE
223: , p8_a7 JTF_NUMBER_TABLE
224: , p8_a8 JTF_VARCHAR2_TABLE_100
217: , p8_a1 JTF_DATE_TABLE
218: , p8_a2 JTF_NUMBER_TABLE
219: , p8_a3 JTF_NUMBER_TABLE
220: , p8_a4 JTF_NUMBER_TABLE
221: , p8_a5 JTF_NUMBER_TABLE
222: , p8_a6 JTF_NUMBER_TABLE
223: , p8_a7 JTF_NUMBER_TABLE
224: , p8_a8 JTF_VARCHAR2_TABLE_100
225: , p8_a9 JTF_VARCHAR2_TABLE_100
218: , p8_a2 JTF_NUMBER_TABLE
219: , p8_a3 JTF_NUMBER_TABLE
220: , p8_a4 JTF_NUMBER_TABLE
221: , p8_a5 JTF_NUMBER_TABLE
222: , p8_a6 JTF_NUMBER_TABLE
223: , p8_a7 JTF_NUMBER_TABLE
224: , p8_a8 JTF_VARCHAR2_TABLE_100
225: , p8_a9 JTF_VARCHAR2_TABLE_100
226: , x_fee_id out nocopy NUMBER
219: , p8_a3 JTF_NUMBER_TABLE
220: , p8_a4 JTF_NUMBER_TABLE
221: , p8_a5 JTF_NUMBER_TABLE
222: , p8_a6 JTF_NUMBER_TABLE
223: , p8_a7 JTF_NUMBER_TABLE
224: , p8_a8 JTF_VARCHAR2_TABLE_100
225: , p8_a9 JTF_VARCHAR2_TABLE_100
226: , x_fee_id out nocopy NUMBER
227: , x_return_status out nocopy VARCHAR2
555: , p3_a36 VARCHAR2
556: , p3_a37 VARCHAR2
557: , p3_a38 NUMBER
558: , p3_a39 VARCHAR2
559: , p4_a0 JTF_NUMBER_TABLE
560: , p4_a1 JTF_NUMBER_TABLE
561: , p4_a2 JTF_VARCHAR2_TABLE_100
562: , p4_a3 JTF_NUMBER_TABLE
563: , p4_a4 JTF_VARCHAR2_TABLE_100
556: , p3_a37 VARCHAR2
557: , p3_a38 NUMBER
558: , p3_a39 VARCHAR2
559: , p4_a0 JTF_NUMBER_TABLE
560: , p4_a1 JTF_NUMBER_TABLE
561: , p4_a2 JTF_VARCHAR2_TABLE_100
562: , p4_a3 JTF_NUMBER_TABLE
563: , p4_a4 JTF_VARCHAR2_TABLE_100
564: , p4_a5 JTF_NUMBER_TABLE
558: , p3_a39 VARCHAR2
559: , p4_a0 JTF_NUMBER_TABLE
560: , p4_a1 JTF_NUMBER_TABLE
561: , p4_a2 JTF_VARCHAR2_TABLE_100
562: , p4_a3 JTF_NUMBER_TABLE
563: , p4_a4 JTF_VARCHAR2_TABLE_100
564: , p4_a5 JTF_NUMBER_TABLE
565: , p4_a6 JTF_NUMBER_TABLE
566: , p4_a7 JTF_VARCHAR2_TABLE_300
560: , p4_a1 JTF_NUMBER_TABLE
561: , p4_a2 JTF_VARCHAR2_TABLE_100
562: , p4_a3 JTF_NUMBER_TABLE
563: , p4_a4 JTF_VARCHAR2_TABLE_100
564: , p4_a5 JTF_NUMBER_TABLE
565: , p4_a6 JTF_NUMBER_TABLE
566: , p4_a7 JTF_VARCHAR2_TABLE_300
567: , p4_a8 JTF_VARCHAR2_TABLE_2000
568: , p4_a9 JTF_VARCHAR2_TABLE_2000
561: , p4_a2 JTF_VARCHAR2_TABLE_100
562: , p4_a3 JTF_NUMBER_TABLE
563: , p4_a4 JTF_VARCHAR2_TABLE_100
564: , p4_a5 JTF_NUMBER_TABLE
565: , p4_a6 JTF_NUMBER_TABLE
566: , p4_a7 JTF_VARCHAR2_TABLE_300
567: , p4_a8 JTF_VARCHAR2_TABLE_2000
568: , p4_a9 JTF_VARCHAR2_TABLE_2000
569: , p4_a10 JTF_VARCHAR2_TABLE_100
566: , p4_a7 JTF_VARCHAR2_TABLE_300
567: , p4_a8 JTF_VARCHAR2_TABLE_2000
568: , p4_a9 JTF_VARCHAR2_TABLE_2000
569: , p4_a10 JTF_VARCHAR2_TABLE_100
570: , p4_a11 JTF_NUMBER_TABLE
571: , p5_a0 VARCHAR2
572: , p5_a1 NUMBER
573: , p5_a2 VARCHAR2
574: , p5_a3 VARCHAR2
581: , p5_a10 NUMBER
582: , p5_a11 NUMBER
583: , p5_a12 NUMBER
584: , p5_a13 NUMBER
585: , p6_a0 JTF_NUMBER_TABLE
586: , p6_a1 JTF_DATE_TABLE
587: , p6_a2 JTF_NUMBER_TABLE
588: , p6_a3 JTF_NUMBER_TABLE
589: , p6_a4 JTF_NUMBER_TABLE
583: , p5_a12 NUMBER
584: , p5_a13 NUMBER
585: , p6_a0 JTF_NUMBER_TABLE
586: , p6_a1 JTF_DATE_TABLE
587: , p6_a2 JTF_NUMBER_TABLE
588: , p6_a3 JTF_NUMBER_TABLE
589: , p6_a4 JTF_NUMBER_TABLE
590: , p6_a5 JTF_NUMBER_TABLE
591: , p6_a6 JTF_NUMBER_TABLE
584: , p5_a13 NUMBER
585: , p6_a0 JTF_NUMBER_TABLE
586: , p6_a1 JTF_DATE_TABLE
587: , p6_a2 JTF_NUMBER_TABLE
588: , p6_a3 JTF_NUMBER_TABLE
589: , p6_a4 JTF_NUMBER_TABLE
590: , p6_a5 JTF_NUMBER_TABLE
591: , p6_a6 JTF_NUMBER_TABLE
592: , p6_a7 JTF_NUMBER_TABLE
585: , p6_a0 JTF_NUMBER_TABLE
586: , p6_a1 JTF_DATE_TABLE
587: , p6_a2 JTF_NUMBER_TABLE
588: , p6_a3 JTF_NUMBER_TABLE
589: , p6_a4 JTF_NUMBER_TABLE
590: , p6_a5 JTF_NUMBER_TABLE
591: , p6_a6 JTF_NUMBER_TABLE
592: , p6_a7 JTF_NUMBER_TABLE
593: , p6_a8 JTF_VARCHAR2_TABLE_100
586: , p6_a1 JTF_DATE_TABLE
587: , p6_a2 JTF_NUMBER_TABLE
588: , p6_a3 JTF_NUMBER_TABLE
589: , p6_a4 JTF_NUMBER_TABLE
590: , p6_a5 JTF_NUMBER_TABLE
591: , p6_a6 JTF_NUMBER_TABLE
592: , p6_a7 JTF_NUMBER_TABLE
593: , p6_a8 JTF_VARCHAR2_TABLE_100
594: , p6_a9 JTF_VARCHAR2_TABLE_100
587: , p6_a2 JTF_NUMBER_TABLE
588: , p6_a3 JTF_NUMBER_TABLE
589: , p6_a4 JTF_NUMBER_TABLE
590: , p6_a5 JTF_NUMBER_TABLE
591: , p6_a6 JTF_NUMBER_TABLE
592: , p6_a7 JTF_NUMBER_TABLE
593: , p6_a8 JTF_VARCHAR2_TABLE_100
594: , p6_a9 JTF_VARCHAR2_TABLE_100
595: , p7_a0 VARCHAR2
588: , p6_a3 JTF_NUMBER_TABLE
589: , p6_a4 JTF_NUMBER_TABLE
590: , p6_a5 JTF_NUMBER_TABLE
591: , p6_a6 JTF_NUMBER_TABLE
592: , p6_a7 JTF_NUMBER_TABLE
593: , p6_a8 JTF_VARCHAR2_TABLE_100
594: , p6_a9 JTF_VARCHAR2_TABLE_100
595: , p7_a0 VARCHAR2
596: , p7_a1 NUMBER
605: , p7_a10 NUMBER
606: , p7_a11 NUMBER
607: , p7_a12 NUMBER
608: , p7_a13 NUMBER
609: , p8_a0 JTF_NUMBER_TABLE
610: , p8_a1 JTF_DATE_TABLE
611: , p8_a2 JTF_NUMBER_TABLE
612: , p8_a3 JTF_NUMBER_TABLE
613: , p8_a4 JTF_NUMBER_TABLE
607: , p7_a12 NUMBER
608: , p7_a13 NUMBER
609: , p8_a0 JTF_NUMBER_TABLE
610: , p8_a1 JTF_DATE_TABLE
611: , p8_a2 JTF_NUMBER_TABLE
612: , p8_a3 JTF_NUMBER_TABLE
613: , p8_a4 JTF_NUMBER_TABLE
614: , p8_a5 JTF_NUMBER_TABLE
615: , p8_a6 JTF_NUMBER_TABLE
608: , p7_a13 NUMBER
609: , p8_a0 JTF_NUMBER_TABLE
610: , p8_a1 JTF_DATE_TABLE
611: , p8_a2 JTF_NUMBER_TABLE
612: , p8_a3 JTF_NUMBER_TABLE
613: , p8_a4 JTF_NUMBER_TABLE
614: , p8_a5 JTF_NUMBER_TABLE
615: , p8_a6 JTF_NUMBER_TABLE
616: , p8_a7 JTF_NUMBER_TABLE
609: , p8_a0 JTF_NUMBER_TABLE
610: , p8_a1 JTF_DATE_TABLE
611: , p8_a2 JTF_NUMBER_TABLE
612: , p8_a3 JTF_NUMBER_TABLE
613: , p8_a4 JTF_NUMBER_TABLE
614: , p8_a5 JTF_NUMBER_TABLE
615: , p8_a6 JTF_NUMBER_TABLE
616: , p8_a7 JTF_NUMBER_TABLE
617: , p8_a8 JTF_VARCHAR2_TABLE_100
610: , p8_a1 JTF_DATE_TABLE
611: , p8_a2 JTF_NUMBER_TABLE
612: , p8_a3 JTF_NUMBER_TABLE
613: , p8_a4 JTF_NUMBER_TABLE
614: , p8_a5 JTF_NUMBER_TABLE
615: , p8_a6 JTF_NUMBER_TABLE
616: , p8_a7 JTF_NUMBER_TABLE
617: , p8_a8 JTF_VARCHAR2_TABLE_100
618: , p8_a9 JTF_VARCHAR2_TABLE_100
611: , p8_a2 JTF_NUMBER_TABLE
612: , p8_a3 JTF_NUMBER_TABLE
613: , p8_a4 JTF_NUMBER_TABLE
614: , p8_a5 JTF_NUMBER_TABLE
615: , p8_a6 JTF_NUMBER_TABLE
616: , p8_a7 JTF_NUMBER_TABLE
617: , p8_a8 JTF_VARCHAR2_TABLE_100
618: , p8_a9 JTF_VARCHAR2_TABLE_100
619: , x_return_status out nocopy VARCHAR2
612: , p8_a3 JTF_NUMBER_TABLE
613: , p8_a4 JTF_NUMBER_TABLE
614: , p8_a5 JTF_NUMBER_TABLE
615: , p8_a6 JTF_NUMBER_TABLE
616: , p8_a7 JTF_NUMBER_TABLE
617: , p8_a8 JTF_VARCHAR2_TABLE_100
618: , p8_a9 JTF_VARCHAR2_TABLE_100
619: , x_return_status out nocopy VARCHAR2
620: , x_msg_count out nocopy NUMBER
818: , p4_a36 VARCHAR2
819: , p4_a37 VARCHAR2
820: , p4_a38 NUMBER
821: , p4_a39 VARCHAR2
822: , p5_a0 JTF_NUMBER_TABLE
823: , p5_a1 JTF_NUMBER_TABLE
824: , p5_a2 JTF_VARCHAR2_TABLE_100
825: , p5_a3 JTF_NUMBER_TABLE
826: , p5_a4 JTF_VARCHAR2_TABLE_100
819: , p4_a37 VARCHAR2
820: , p4_a38 NUMBER
821: , p4_a39 VARCHAR2
822: , p5_a0 JTF_NUMBER_TABLE
823: , p5_a1 JTF_NUMBER_TABLE
824: , p5_a2 JTF_VARCHAR2_TABLE_100
825: , p5_a3 JTF_NUMBER_TABLE
826: , p5_a4 JTF_VARCHAR2_TABLE_100
827: , p5_a5 JTF_NUMBER_TABLE
821: , p4_a39 VARCHAR2
822: , p5_a0 JTF_NUMBER_TABLE
823: , p5_a1 JTF_NUMBER_TABLE
824: , p5_a2 JTF_VARCHAR2_TABLE_100
825: , p5_a3 JTF_NUMBER_TABLE
826: , p5_a4 JTF_VARCHAR2_TABLE_100
827: , p5_a5 JTF_NUMBER_TABLE
828: , p5_a6 JTF_NUMBER_TABLE
829: , p5_a7 JTF_VARCHAR2_TABLE_300
823: , p5_a1 JTF_NUMBER_TABLE
824: , p5_a2 JTF_VARCHAR2_TABLE_100
825: , p5_a3 JTF_NUMBER_TABLE
826: , p5_a4 JTF_VARCHAR2_TABLE_100
827: , p5_a5 JTF_NUMBER_TABLE
828: , p5_a6 JTF_NUMBER_TABLE
829: , p5_a7 JTF_VARCHAR2_TABLE_300
830: , p5_a8 JTF_VARCHAR2_TABLE_2000
831: , p5_a9 JTF_VARCHAR2_TABLE_2000
824: , p5_a2 JTF_VARCHAR2_TABLE_100
825: , p5_a3 JTF_NUMBER_TABLE
826: , p5_a4 JTF_VARCHAR2_TABLE_100
827: , p5_a5 JTF_NUMBER_TABLE
828: , p5_a6 JTF_NUMBER_TABLE
829: , p5_a7 JTF_VARCHAR2_TABLE_300
830: , p5_a8 JTF_VARCHAR2_TABLE_2000
831: , p5_a9 JTF_VARCHAR2_TABLE_2000
832: , p5_a10 JTF_VARCHAR2_TABLE_100
829: , p5_a7 JTF_VARCHAR2_TABLE_300
830: , p5_a8 JTF_VARCHAR2_TABLE_2000
831: , p5_a9 JTF_VARCHAR2_TABLE_2000
832: , p5_a10 JTF_VARCHAR2_TABLE_100
833: , p5_a11 JTF_NUMBER_TABLE
834: , p6_a0 VARCHAR2
835: , p6_a1 NUMBER
836: , p6_a2 VARCHAR2
837: , p6_a3 VARCHAR2
844: , p6_a10 NUMBER
845: , p6_a11 NUMBER
846: , p6_a12 NUMBER
847: , p6_a13 NUMBER
848: , p7_a0 JTF_NUMBER_TABLE
849: , p7_a1 JTF_DATE_TABLE
850: , p7_a2 JTF_NUMBER_TABLE
851: , p7_a3 JTF_NUMBER_TABLE
852: , p7_a4 JTF_NUMBER_TABLE
846: , p6_a12 NUMBER
847: , p6_a13 NUMBER
848: , p7_a0 JTF_NUMBER_TABLE
849: , p7_a1 JTF_DATE_TABLE
850: , p7_a2 JTF_NUMBER_TABLE
851: , p7_a3 JTF_NUMBER_TABLE
852: , p7_a4 JTF_NUMBER_TABLE
853: , p7_a5 JTF_NUMBER_TABLE
854: , p7_a6 JTF_NUMBER_TABLE
847: , p6_a13 NUMBER
848: , p7_a0 JTF_NUMBER_TABLE
849: , p7_a1 JTF_DATE_TABLE
850: , p7_a2 JTF_NUMBER_TABLE
851: , p7_a3 JTF_NUMBER_TABLE
852: , p7_a4 JTF_NUMBER_TABLE
853: , p7_a5 JTF_NUMBER_TABLE
854: , p7_a6 JTF_NUMBER_TABLE
855: , p7_a7 JTF_NUMBER_TABLE
848: , p7_a0 JTF_NUMBER_TABLE
849: , p7_a1 JTF_DATE_TABLE
850: , p7_a2 JTF_NUMBER_TABLE
851: , p7_a3 JTF_NUMBER_TABLE
852: , p7_a4 JTF_NUMBER_TABLE
853: , p7_a5 JTF_NUMBER_TABLE
854: , p7_a6 JTF_NUMBER_TABLE
855: , p7_a7 JTF_NUMBER_TABLE
856: , p7_a8 JTF_VARCHAR2_TABLE_100
849: , p7_a1 JTF_DATE_TABLE
850: , p7_a2 JTF_NUMBER_TABLE
851: , p7_a3 JTF_NUMBER_TABLE
852: , p7_a4 JTF_NUMBER_TABLE
853: , p7_a5 JTF_NUMBER_TABLE
854: , p7_a6 JTF_NUMBER_TABLE
855: , p7_a7 JTF_NUMBER_TABLE
856: , p7_a8 JTF_VARCHAR2_TABLE_100
857: , p7_a9 JTF_VARCHAR2_TABLE_100
850: , p7_a2 JTF_NUMBER_TABLE
851: , p7_a3 JTF_NUMBER_TABLE
852: , p7_a4 JTF_NUMBER_TABLE
853: , p7_a5 JTF_NUMBER_TABLE
854: , p7_a6 JTF_NUMBER_TABLE
855: , p7_a7 JTF_NUMBER_TABLE
856: , p7_a8 JTF_VARCHAR2_TABLE_100
857: , p7_a9 JTF_VARCHAR2_TABLE_100
858: , p8_a0 VARCHAR2
851: , p7_a3 JTF_NUMBER_TABLE
852: , p7_a4 JTF_NUMBER_TABLE
853: , p7_a5 JTF_NUMBER_TABLE
854: , p7_a6 JTF_NUMBER_TABLE
855: , p7_a7 JTF_NUMBER_TABLE
856: , p7_a8 JTF_VARCHAR2_TABLE_100
857: , p7_a9 JTF_VARCHAR2_TABLE_100
858: , p8_a0 VARCHAR2
859: , p8_a1 NUMBER
868: , p8_a10 NUMBER
869: , p8_a11 NUMBER
870: , p8_a12 NUMBER
871: , p8_a13 NUMBER
872: , p9_a0 JTF_NUMBER_TABLE
873: , p9_a1 JTF_DATE_TABLE
874: , p9_a2 JTF_NUMBER_TABLE
875: , p9_a3 JTF_NUMBER_TABLE
876: , p9_a4 JTF_NUMBER_TABLE
870: , p8_a12 NUMBER
871: , p8_a13 NUMBER
872: , p9_a0 JTF_NUMBER_TABLE
873: , p9_a1 JTF_DATE_TABLE
874: , p9_a2 JTF_NUMBER_TABLE
875: , p9_a3 JTF_NUMBER_TABLE
876: , p9_a4 JTF_NUMBER_TABLE
877: , p9_a5 JTF_NUMBER_TABLE
878: , p9_a6 JTF_NUMBER_TABLE
871: , p8_a13 NUMBER
872: , p9_a0 JTF_NUMBER_TABLE
873: , p9_a1 JTF_DATE_TABLE
874: , p9_a2 JTF_NUMBER_TABLE
875: , p9_a3 JTF_NUMBER_TABLE
876: , p9_a4 JTF_NUMBER_TABLE
877: , p9_a5 JTF_NUMBER_TABLE
878: , p9_a6 JTF_NUMBER_TABLE
879: , p9_a7 JTF_NUMBER_TABLE
872: , p9_a0 JTF_NUMBER_TABLE
873: , p9_a1 JTF_DATE_TABLE
874: , p9_a2 JTF_NUMBER_TABLE
875: , p9_a3 JTF_NUMBER_TABLE
876: , p9_a4 JTF_NUMBER_TABLE
877: , p9_a5 JTF_NUMBER_TABLE
878: , p9_a6 JTF_NUMBER_TABLE
879: , p9_a7 JTF_NUMBER_TABLE
880: , p9_a8 JTF_VARCHAR2_TABLE_100
873: , p9_a1 JTF_DATE_TABLE
874: , p9_a2 JTF_NUMBER_TABLE
875: , p9_a3 JTF_NUMBER_TABLE
876: , p9_a4 JTF_NUMBER_TABLE
877: , p9_a5 JTF_NUMBER_TABLE
878: , p9_a6 JTF_NUMBER_TABLE
879: , p9_a7 JTF_NUMBER_TABLE
880: , p9_a8 JTF_VARCHAR2_TABLE_100
881: , p9_a9 JTF_VARCHAR2_TABLE_100
874: , p9_a2 JTF_NUMBER_TABLE
875: , p9_a3 JTF_NUMBER_TABLE
876: , p9_a4 JTF_NUMBER_TABLE
877: , p9_a5 JTF_NUMBER_TABLE
878: , p9_a6 JTF_NUMBER_TABLE
879: , p9_a7 JTF_NUMBER_TABLE
880: , p9_a8 JTF_VARCHAR2_TABLE_100
881: , p9_a9 JTF_VARCHAR2_TABLE_100
882: , x_fee_id out nocopy NUMBER
875: , p9_a3 JTF_NUMBER_TABLE
876: , p9_a4 JTF_NUMBER_TABLE
877: , p9_a5 JTF_NUMBER_TABLE
878: , p9_a6 JTF_NUMBER_TABLE
879: , p9_a7 JTF_NUMBER_TABLE
880: , p9_a8 JTF_VARCHAR2_TABLE_100
881: , p9_a9 JTF_VARCHAR2_TABLE_100
882: , x_fee_id out nocopy NUMBER
883: , x_return_status out nocopy VARCHAR2