1: package body okl_fee_pvt_w as
2: /* $Header: OKLIFEEB.pls 120.2 2006/03/16 10:09:43 asawanka noship $ */
3: procedure rosetta_table_copy_in_p23(t out nocopy okl_fee_pvt.feev_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_500
7: , a4 JTF_VARCHAR2_TABLE_500
1: package body okl_fee_pvt_w as
2: /* $Header: OKLIFEEB.pls 120.2 2006/03/16 10:09:43 asawanka noship $ */
3: procedure rosetta_table_copy_in_p23(t out nocopy okl_fee_pvt.feev_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_500
7: , a4 JTF_VARCHAR2_TABLE_500
8: , a5 JTF_VARCHAR2_TABLE_500
18: , a15 JTF_VARCHAR2_TABLE_500
19: , a16 JTF_VARCHAR2_TABLE_500
20: , a17 JTF_VARCHAR2_TABLE_500
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_NUMBER_TABLE
23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_VARCHAR2_TABLE_100
26: , a23 JTF_NUMBER_TABLE
19: , a16 JTF_VARCHAR2_TABLE_500
20: , a17 JTF_VARCHAR2_TABLE_500
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_NUMBER_TABLE
23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_VARCHAR2_TABLE_100
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_NUMBER_TABLE
22: , a19 JTF_NUMBER_TABLE
23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_VARCHAR2_TABLE_100
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_VARCHAR2_TABLE_100
30: , a27 JTF_DATE_TABLE
23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_VARCHAR2_TABLE_100
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_VARCHAR2_TABLE_100
30: , a27 JTF_DATE_TABLE
31: , a28 JTF_DATE_TABLE
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_VARCHAR2_TABLE_100
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_VARCHAR2_TABLE_100
30: , a27 JTF_DATE_TABLE
31: , a28 JTF_DATE_TABLE
32: , a29 JTF_NUMBER_TABLE
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_VARCHAR2_TABLE_100
30: , a27 JTF_DATE_TABLE
31: , a28 JTF_DATE_TABLE
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_NUMBER_TABLE
34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_NUMBER_TABLE
36: , a33 JTF_NUMBER_TABLE
29: , a26 JTF_VARCHAR2_TABLE_100
30: , a27 JTF_DATE_TABLE
31: , a28 JTF_DATE_TABLE
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_NUMBER_TABLE
34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_NUMBER_TABLE
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_VARCHAR2_TABLE_100
30: , a27 JTF_DATE_TABLE
31: , a28 JTF_DATE_TABLE
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_NUMBER_TABLE
34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_NUMBER_TABLE
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_VARCHAR2_TABLE_100
38: , a35 JTF_VARCHAR2_TABLE_300
31: , a28 JTF_DATE_TABLE
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_NUMBER_TABLE
34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_NUMBER_TABLE
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_VARCHAR2_TABLE_100
38: , a35 JTF_VARCHAR2_TABLE_300
39: , a36 JTF_VARCHAR2_TABLE_2000
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_NUMBER_TABLE
34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_NUMBER_TABLE
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_VARCHAR2_TABLE_100
38: , a35 JTF_VARCHAR2_TABLE_300
39: , a36 JTF_VARCHAR2_TABLE_2000
40: , a37 JTF_VARCHAR2_TABLE_2000
37: , a34 JTF_VARCHAR2_TABLE_100
38: , a35 JTF_VARCHAR2_TABLE_300
39: , a36 JTF_VARCHAR2_TABLE_2000
40: , a37 JTF_VARCHAR2_TABLE_2000
41: , a38 JTF_NUMBER_TABLE
42: ) as
43: ddindx binary_integer; indx binary_integer;
44: begin
45: if a0 is not null and a0.count > 0 then
94: end loop;
95: end if;
96: end if;
97: end rosetta_table_copy_in_p23;
98: procedure rosetta_table_copy_out_p23(t okl_fee_pvt.feev_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
99: , a1 out nocopy JTF_NUMBER_TABLE
100: , a2 out nocopy JTF_VARCHAR2_TABLE_100
101: , a3 out nocopy JTF_VARCHAR2_TABLE_500
102: , a4 out nocopy JTF_VARCHAR2_TABLE_500
95: end if;
96: end if;
97: end rosetta_table_copy_in_p23;
98: procedure rosetta_table_copy_out_p23(t okl_fee_pvt.feev_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
99: , a1 out nocopy JTF_NUMBER_TABLE
100: , a2 out nocopy JTF_VARCHAR2_TABLE_100
101: , a3 out nocopy JTF_VARCHAR2_TABLE_500
102: , a4 out nocopy JTF_VARCHAR2_TABLE_500
103: , a5 out nocopy JTF_VARCHAR2_TABLE_500
113: , a15 out nocopy JTF_VARCHAR2_TABLE_500
114: , a16 out nocopy JTF_VARCHAR2_TABLE_500
115: , a17 out nocopy JTF_VARCHAR2_TABLE_500
116: , a18 out nocopy JTF_VARCHAR2_TABLE_100
117: , a19 out nocopy JTF_NUMBER_TABLE
118: , a20 out nocopy JTF_NUMBER_TABLE
119: , a21 out nocopy JTF_VARCHAR2_TABLE_100
120: , a22 out nocopy JTF_VARCHAR2_TABLE_100
121: , a23 out nocopy JTF_NUMBER_TABLE
114: , a16 out nocopy JTF_VARCHAR2_TABLE_500
115: , a17 out nocopy JTF_VARCHAR2_TABLE_500
116: , a18 out nocopy JTF_VARCHAR2_TABLE_100
117: , a19 out nocopy JTF_NUMBER_TABLE
118: , a20 out nocopy JTF_NUMBER_TABLE
119: , a21 out nocopy JTF_VARCHAR2_TABLE_100
120: , a22 out nocopy JTF_VARCHAR2_TABLE_100
121: , a23 out nocopy JTF_NUMBER_TABLE
122: , a24 out nocopy JTF_NUMBER_TABLE
117: , a19 out nocopy JTF_NUMBER_TABLE
118: , a20 out nocopy JTF_NUMBER_TABLE
119: , a21 out nocopy JTF_VARCHAR2_TABLE_100
120: , a22 out nocopy JTF_VARCHAR2_TABLE_100
121: , a23 out nocopy JTF_NUMBER_TABLE
122: , a24 out nocopy JTF_NUMBER_TABLE
123: , a25 out nocopy JTF_NUMBER_TABLE
124: , a26 out nocopy JTF_VARCHAR2_TABLE_100
125: , a27 out nocopy JTF_DATE_TABLE
118: , a20 out nocopy JTF_NUMBER_TABLE
119: , a21 out nocopy JTF_VARCHAR2_TABLE_100
120: , a22 out nocopy JTF_VARCHAR2_TABLE_100
121: , a23 out nocopy JTF_NUMBER_TABLE
122: , a24 out nocopy JTF_NUMBER_TABLE
123: , a25 out nocopy JTF_NUMBER_TABLE
124: , a26 out nocopy JTF_VARCHAR2_TABLE_100
125: , a27 out nocopy JTF_DATE_TABLE
126: , a28 out nocopy JTF_DATE_TABLE
119: , a21 out nocopy JTF_VARCHAR2_TABLE_100
120: , a22 out nocopy JTF_VARCHAR2_TABLE_100
121: , a23 out nocopy JTF_NUMBER_TABLE
122: , a24 out nocopy JTF_NUMBER_TABLE
123: , a25 out nocopy JTF_NUMBER_TABLE
124: , a26 out nocopy JTF_VARCHAR2_TABLE_100
125: , a27 out nocopy JTF_DATE_TABLE
126: , a28 out nocopy JTF_DATE_TABLE
127: , a29 out nocopy JTF_NUMBER_TABLE
123: , a25 out nocopy JTF_NUMBER_TABLE
124: , a26 out nocopy JTF_VARCHAR2_TABLE_100
125: , a27 out nocopy JTF_DATE_TABLE
126: , a28 out nocopy JTF_DATE_TABLE
127: , a29 out nocopy JTF_NUMBER_TABLE
128: , a30 out nocopy JTF_NUMBER_TABLE
129: , a31 out nocopy JTF_NUMBER_TABLE
130: , a32 out nocopy JTF_NUMBER_TABLE
131: , a33 out nocopy JTF_NUMBER_TABLE
124: , a26 out nocopy JTF_VARCHAR2_TABLE_100
125: , a27 out nocopy JTF_DATE_TABLE
126: , a28 out nocopy JTF_DATE_TABLE
127: , a29 out nocopy JTF_NUMBER_TABLE
128: , a30 out nocopy JTF_NUMBER_TABLE
129: , a31 out nocopy JTF_NUMBER_TABLE
130: , a32 out nocopy JTF_NUMBER_TABLE
131: , a33 out nocopy JTF_NUMBER_TABLE
132: , a34 out nocopy JTF_VARCHAR2_TABLE_100
125: , a27 out nocopy JTF_DATE_TABLE
126: , a28 out nocopy JTF_DATE_TABLE
127: , a29 out nocopy JTF_NUMBER_TABLE
128: , a30 out nocopy JTF_NUMBER_TABLE
129: , a31 out nocopy JTF_NUMBER_TABLE
130: , a32 out nocopy JTF_NUMBER_TABLE
131: , a33 out nocopy JTF_NUMBER_TABLE
132: , a34 out nocopy JTF_VARCHAR2_TABLE_100
133: , a35 out nocopy JTF_VARCHAR2_TABLE_300
126: , a28 out nocopy JTF_DATE_TABLE
127: , a29 out nocopy JTF_NUMBER_TABLE
128: , a30 out nocopy JTF_NUMBER_TABLE
129: , a31 out nocopy JTF_NUMBER_TABLE
130: , a32 out nocopy JTF_NUMBER_TABLE
131: , a33 out nocopy JTF_NUMBER_TABLE
132: , a34 out nocopy JTF_VARCHAR2_TABLE_100
133: , a35 out nocopy JTF_VARCHAR2_TABLE_300
134: , a36 out nocopy JTF_VARCHAR2_TABLE_2000
127: , a29 out nocopy JTF_NUMBER_TABLE
128: , a30 out nocopy JTF_NUMBER_TABLE
129: , a31 out nocopy JTF_NUMBER_TABLE
130: , a32 out nocopy JTF_NUMBER_TABLE
131: , a33 out nocopy JTF_NUMBER_TABLE
132: , a34 out nocopy JTF_VARCHAR2_TABLE_100
133: , a35 out nocopy JTF_VARCHAR2_TABLE_300
134: , a36 out nocopy JTF_VARCHAR2_TABLE_2000
135: , a37 out nocopy JTF_VARCHAR2_TABLE_2000
132: , a34 out nocopy JTF_VARCHAR2_TABLE_100
133: , a35 out nocopy JTF_VARCHAR2_TABLE_300
134: , a36 out nocopy JTF_VARCHAR2_TABLE_2000
135: , a37 out nocopy JTF_VARCHAR2_TABLE_2000
136: , a38 out nocopy JTF_NUMBER_TABLE
137: ) as
138: ddindx binary_integer; indx binary_integer;
139: begin
140: if t is null or t.count = 0 then
137: ) as
138: ddindx binary_integer; indx binary_integer;
139: begin
140: if t is null or t.count = 0 then
141: a0 := JTF_NUMBER_TABLE();
142: a1 := JTF_NUMBER_TABLE();
143: a2 := JTF_VARCHAR2_TABLE_100();
144: a3 := JTF_VARCHAR2_TABLE_500();
145: a4 := JTF_VARCHAR2_TABLE_500();
138: ddindx binary_integer; indx binary_integer;
139: begin
140: if t is null or t.count = 0 then
141: a0 := JTF_NUMBER_TABLE();
142: a1 := JTF_NUMBER_TABLE();
143: a2 := JTF_VARCHAR2_TABLE_100();
144: a3 := JTF_VARCHAR2_TABLE_500();
145: a4 := JTF_VARCHAR2_TABLE_500();
146: a5 := JTF_VARCHAR2_TABLE_500();
156: a15 := JTF_VARCHAR2_TABLE_500();
157: a16 := JTF_VARCHAR2_TABLE_500();
158: a17 := JTF_VARCHAR2_TABLE_500();
159: a18 := JTF_VARCHAR2_TABLE_100();
160: a19 := JTF_NUMBER_TABLE();
161: a20 := JTF_NUMBER_TABLE();
162: a21 := JTF_VARCHAR2_TABLE_100();
163: a22 := JTF_VARCHAR2_TABLE_100();
164: a23 := JTF_NUMBER_TABLE();
157: a16 := JTF_VARCHAR2_TABLE_500();
158: a17 := JTF_VARCHAR2_TABLE_500();
159: a18 := JTF_VARCHAR2_TABLE_100();
160: a19 := JTF_NUMBER_TABLE();
161: a20 := JTF_NUMBER_TABLE();
162: a21 := JTF_VARCHAR2_TABLE_100();
163: a22 := JTF_VARCHAR2_TABLE_100();
164: a23 := JTF_NUMBER_TABLE();
165: a24 := JTF_NUMBER_TABLE();
160: a19 := JTF_NUMBER_TABLE();
161: a20 := JTF_NUMBER_TABLE();
162: a21 := JTF_VARCHAR2_TABLE_100();
163: a22 := JTF_VARCHAR2_TABLE_100();
164: a23 := JTF_NUMBER_TABLE();
165: a24 := JTF_NUMBER_TABLE();
166: a25 := JTF_NUMBER_TABLE();
167: a26 := JTF_VARCHAR2_TABLE_100();
168: a27 := JTF_DATE_TABLE();
161: a20 := JTF_NUMBER_TABLE();
162: a21 := JTF_VARCHAR2_TABLE_100();
163: a22 := JTF_VARCHAR2_TABLE_100();
164: a23 := JTF_NUMBER_TABLE();
165: a24 := JTF_NUMBER_TABLE();
166: a25 := JTF_NUMBER_TABLE();
167: a26 := JTF_VARCHAR2_TABLE_100();
168: a27 := JTF_DATE_TABLE();
169: a28 := JTF_DATE_TABLE();
162: a21 := JTF_VARCHAR2_TABLE_100();
163: a22 := JTF_VARCHAR2_TABLE_100();
164: a23 := JTF_NUMBER_TABLE();
165: a24 := JTF_NUMBER_TABLE();
166: a25 := JTF_NUMBER_TABLE();
167: a26 := JTF_VARCHAR2_TABLE_100();
168: a27 := JTF_DATE_TABLE();
169: a28 := JTF_DATE_TABLE();
170: a29 := JTF_NUMBER_TABLE();
166: a25 := JTF_NUMBER_TABLE();
167: a26 := JTF_VARCHAR2_TABLE_100();
168: a27 := JTF_DATE_TABLE();
169: a28 := JTF_DATE_TABLE();
170: a29 := JTF_NUMBER_TABLE();
171: a30 := JTF_NUMBER_TABLE();
172: a31 := JTF_NUMBER_TABLE();
173: a32 := JTF_NUMBER_TABLE();
174: a33 := JTF_NUMBER_TABLE();
167: a26 := JTF_VARCHAR2_TABLE_100();
168: a27 := JTF_DATE_TABLE();
169: a28 := JTF_DATE_TABLE();
170: a29 := JTF_NUMBER_TABLE();
171: a30 := JTF_NUMBER_TABLE();
172: a31 := JTF_NUMBER_TABLE();
173: a32 := JTF_NUMBER_TABLE();
174: a33 := JTF_NUMBER_TABLE();
175: a34 := JTF_VARCHAR2_TABLE_100();
168: a27 := JTF_DATE_TABLE();
169: a28 := JTF_DATE_TABLE();
170: a29 := JTF_NUMBER_TABLE();
171: a30 := JTF_NUMBER_TABLE();
172: a31 := JTF_NUMBER_TABLE();
173: a32 := JTF_NUMBER_TABLE();
174: a33 := JTF_NUMBER_TABLE();
175: a34 := JTF_VARCHAR2_TABLE_100();
176: a35 := JTF_VARCHAR2_TABLE_300();
169: a28 := JTF_DATE_TABLE();
170: a29 := JTF_NUMBER_TABLE();
171: a30 := JTF_NUMBER_TABLE();
172: a31 := JTF_NUMBER_TABLE();
173: a32 := JTF_NUMBER_TABLE();
174: a33 := JTF_NUMBER_TABLE();
175: a34 := JTF_VARCHAR2_TABLE_100();
176: a35 := JTF_VARCHAR2_TABLE_300();
177: a36 := JTF_VARCHAR2_TABLE_2000();
170: a29 := JTF_NUMBER_TABLE();
171: a30 := JTF_NUMBER_TABLE();
172: a31 := JTF_NUMBER_TABLE();
173: a32 := JTF_NUMBER_TABLE();
174: a33 := JTF_NUMBER_TABLE();
175: a34 := JTF_VARCHAR2_TABLE_100();
176: a35 := JTF_VARCHAR2_TABLE_300();
177: a36 := JTF_VARCHAR2_TABLE_2000();
178: a37 := JTF_VARCHAR2_TABLE_2000();
175: a34 := JTF_VARCHAR2_TABLE_100();
176: a35 := JTF_VARCHAR2_TABLE_300();
177: a36 := JTF_VARCHAR2_TABLE_2000();
178: a37 := JTF_VARCHAR2_TABLE_2000();
179: a38 := JTF_NUMBER_TABLE();
180: else
181: a0 := JTF_NUMBER_TABLE();
182: a1 := JTF_NUMBER_TABLE();
183: a2 := JTF_VARCHAR2_TABLE_100();
177: a36 := JTF_VARCHAR2_TABLE_2000();
178: a37 := JTF_VARCHAR2_TABLE_2000();
179: a38 := JTF_NUMBER_TABLE();
180: else
181: a0 := JTF_NUMBER_TABLE();
182: a1 := JTF_NUMBER_TABLE();
183: a2 := JTF_VARCHAR2_TABLE_100();
184: a3 := JTF_VARCHAR2_TABLE_500();
185: a4 := JTF_VARCHAR2_TABLE_500();
178: a37 := JTF_VARCHAR2_TABLE_2000();
179: a38 := JTF_NUMBER_TABLE();
180: else
181: a0 := JTF_NUMBER_TABLE();
182: a1 := JTF_NUMBER_TABLE();
183: a2 := JTF_VARCHAR2_TABLE_100();
184: a3 := JTF_VARCHAR2_TABLE_500();
185: a4 := JTF_VARCHAR2_TABLE_500();
186: a5 := JTF_VARCHAR2_TABLE_500();
196: a15 := JTF_VARCHAR2_TABLE_500();
197: a16 := JTF_VARCHAR2_TABLE_500();
198: a17 := JTF_VARCHAR2_TABLE_500();
199: a18 := JTF_VARCHAR2_TABLE_100();
200: a19 := JTF_NUMBER_TABLE();
201: a20 := JTF_NUMBER_TABLE();
202: a21 := JTF_VARCHAR2_TABLE_100();
203: a22 := JTF_VARCHAR2_TABLE_100();
204: a23 := JTF_NUMBER_TABLE();
197: a16 := JTF_VARCHAR2_TABLE_500();
198: a17 := JTF_VARCHAR2_TABLE_500();
199: a18 := JTF_VARCHAR2_TABLE_100();
200: a19 := JTF_NUMBER_TABLE();
201: a20 := JTF_NUMBER_TABLE();
202: a21 := JTF_VARCHAR2_TABLE_100();
203: a22 := JTF_VARCHAR2_TABLE_100();
204: a23 := JTF_NUMBER_TABLE();
205: a24 := JTF_NUMBER_TABLE();
200: a19 := JTF_NUMBER_TABLE();
201: a20 := JTF_NUMBER_TABLE();
202: a21 := JTF_VARCHAR2_TABLE_100();
203: a22 := JTF_VARCHAR2_TABLE_100();
204: a23 := JTF_NUMBER_TABLE();
205: a24 := JTF_NUMBER_TABLE();
206: a25 := JTF_NUMBER_TABLE();
207: a26 := JTF_VARCHAR2_TABLE_100();
208: a27 := JTF_DATE_TABLE();
201: a20 := JTF_NUMBER_TABLE();
202: a21 := JTF_VARCHAR2_TABLE_100();
203: a22 := JTF_VARCHAR2_TABLE_100();
204: a23 := JTF_NUMBER_TABLE();
205: a24 := JTF_NUMBER_TABLE();
206: a25 := JTF_NUMBER_TABLE();
207: a26 := JTF_VARCHAR2_TABLE_100();
208: a27 := JTF_DATE_TABLE();
209: a28 := JTF_DATE_TABLE();
202: a21 := JTF_VARCHAR2_TABLE_100();
203: a22 := JTF_VARCHAR2_TABLE_100();
204: a23 := JTF_NUMBER_TABLE();
205: a24 := JTF_NUMBER_TABLE();
206: a25 := JTF_NUMBER_TABLE();
207: a26 := JTF_VARCHAR2_TABLE_100();
208: a27 := JTF_DATE_TABLE();
209: a28 := JTF_DATE_TABLE();
210: a29 := JTF_NUMBER_TABLE();
206: a25 := JTF_NUMBER_TABLE();
207: a26 := JTF_VARCHAR2_TABLE_100();
208: a27 := JTF_DATE_TABLE();
209: a28 := JTF_DATE_TABLE();
210: a29 := JTF_NUMBER_TABLE();
211: a30 := JTF_NUMBER_TABLE();
212: a31 := JTF_NUMBER_TABLE();
213: a32 := JTF_NUMBER_TABLE();
214: a33 := JTF_NUMBER_TABLE();
207: a26 := JTF_VARCHAR2_TABLE_100();
208: a27 := JTF_DATE_TABLE();
209: a28 := JTF_DATE_TABLE();
210: a29 := JTF_NUMBER_TABLE();
211: a30 := JTF_NUMBER_TABLE();
212: a31 := JTF_NUMBER_TABLE();
213: a32 := JTF_NUMBER_TABLE();
214: a33 := JTF_NUMBER_TABLE();
215: a34 := JTF_VARCHAR2_TABLE_100();
208: a27 := JTF_DATE_TABLE();
209: a28 := JTF_DATE_TABLE();
210: a29 := JTF_NUMBER_TABLE();
211: a30 := JTF_NUMBER_TABLE();
212: a31 := JTF_NUMBER_TABLE();
213: a32 := JTF_NUMBER_TABLE();
214: a33 := JTF_NUMBER_TABLE();
215: a34 := JTF_VARCHAR2_TABLE_100();
216: a35 := JTF_VARCHAR2_TABLE_300();
209: a28 := JTF_DATE_TABLE();
210: a29 := JTF_NUMBER_TABLE();
211: a30 := JTF_NUMBER_TABLE();
212: a31 := JTF_NUMBER_TABLE();
213: a32 := JTF_NUMBER_TABLE();
214: a33 := JTF_NUMBER_TABLE();
215: a34 := JTF_VARCHAR2_TABLE_100();
216: a35 := JTF_VARCHAR2_TABLE_300();
217: a36 := JTF_VARCHAR2_TABLE_2000();
210: a29 := JTF_NUMBER_TABLE();
211: a30 := JTF_NUMBER_TABLE();
212: a31 := JTF_NUMBER_TABLE();
213: a32 := JTF_NUMBER_TABLE();
214: a33 := JTF_NUMBER_TABLE();
215: a34 := JTF_VARCHAR2_TABLE_100();
216: a35 := JTF_VARCHAR2_TABLE_300();
217: a36 := JTF_VARCHAR2_TABLE_2000();
218: a37 := JTF_VARCHAR2_TABLE_2000();
215: a34 := JTF_VARCHAR2_TABLE_100();
216: a35 := JTF_VARCHAR2_TABLE_300();
217: a36 := JTF_VARCHAR2_TABLE_2000();
218: a37 := JTF_VARCHAR2_TABLE_2000();
219: a38 := JTF_NUMBER_TABLE();
220: if t.count > 0 then
221: a0.extend(t.count);
222: a1.extend(t.count);
223: a2.extend(t.count);
313: , p_init_msg_list VARCHAR2
314: , x_return_status out nocopy VARCHAR2
315: , x_msg_count out nocopy NUMBER
316: , x_msg_data out nocopy VARCHAR2
317: , p5_a0 JTF_NUMBER_TABLE
318: , p5_a1 JTF_NUMBER_TABLE
319: , p5_a2 JTF_VARCHAR2_TABLE_100
320: , p5_a3 JTF_VARCHAR2_TABLE_500
321: , p5_a4 JTF_VARCHAR2_TABLE_500
314: , x_return_status out nocopy VARCHAR2
315: , x_msg_count out nocopy NUMBER
316: , x_msg_data out nocopy VARCHAR2
317: , p5_a0 JTF_NUMBER_TABLE
318: , p5_a1 JTF_NUMBER_TABLE
319: , p5_a2 JTF_VARCHAR2_TABLE_100
320: , p5_a3 JTF_VARCHAR2_TABLE_500
321: , p5_a4 JTF_VARCHAR2_TABLE_500
322: , p5_a5 JTF_VARCHAR2_TABLE_500
332: , p5_a15 JTF_VARCHAR2_TABLE_500
333: , p5_a16 JTF_VARCHAR2_TABLE_500
334: , p5_a17 JTF_VARCHAR2_TABLE_500
335: , p5_a18 JTF_VARCHAR2_TABLE_100
336: , p5_a19 JTF_NUMBER_TABLE
337: , p5_a20 JTF_NUMBER_TABLE
338: , p5_a21 JTF_VARCHAR2_TABLE_100
339: , p5_a22 JTF_VARCHAR2_TABLE_100
340: , p5_a23 JTF_NUMBER_TABLE
333: , p5_a16 JTF_VARCHAR2_TABLE_500
334: , p5_a17 JTF_VARCHAR2_TABLE_500
335: , p5_a18 JTF_VARCHAR2_TABLE_100
336: , p5_a19 JTF_NUMBER_TABLE
337: , p5_a20 JTF_NUMBER_TABLE
338: , p5_a21 JTF_VARCHAR2_TABLE_100
339: , p5_a22 JTF_VARCHAR2_TABLE_100
340: , p5_a23 JTF_NUMBER_TABLE
341: , p5_a24 JTF_NUMBER_TABLE
336: , p5_a19 JTF_NUMBER_TABLE
337: , p5_a20 JTF_NUMBER_TABLE
338: , p5_a21 JTF_VARCHAR2_TABLE_100
339: , p5_a22 JTF_VARCHAR2_TABLE_100
340: , p5_a23 JTF_NUMBER_TABLE
341: , p5_a24 JTF_NUMBER_TABLE
342: , p5_a25 JTF_NUMBER_TABLE
343: , p5_a26 JTF_VARCHAR2_TABLE_100
344: , p5_a27 JTF_DATE_TABLE
337: , p5_a20 JTF_NUMBER_TABLE
338: , p5_a21 JTF_VARCHAR2_TABLE_100
339: , p5_a22 JTF_VARCHAR2_TABLE_100
340: , p5_a23 JTF_NUMBER_TABLE
341: , p5_a24 JTF_NUMBER_TABLE
342: , p5_a25 JTF_NUMBER_TABLE
343: , p5_a26 JTF_VARCHAR2_TABLE_100
344: , p5_a27 JTF_DATE_TABLE
345: , p5_a28 JTF_DATE_TABLE
338: , p5_a21 JTF_VARCHAR2_TABLE_100
339: , p5_a22 JTF_VARCHAR2_TABLE_100
340: , p5_a23 JTF_NUMBER_TABLE
341: , p5_a24 JTF_NUMBER_TABLE
342: , p5_a25 JTF_NUMBER_TABLE
343: , p5_a26 JTF_VARCHAR2_TABLE_100
344: , p5_a27 JTF_DATE_TABLE
345: , p5_a28 JTF_DATE_TABLE
346: , p5_a29 JTF_NUMBER_TABLE
342: , p5_a25 JTF_NUMBER_TABLE
343: , p5_a26 JTF_VARCHAR2_TABLE_100
344: , p5_a27 JTF_DATE_TABLE
345: , p5_a28 JTF_DATE_TABLE
346: , p5_a29 JTF_NUMBER_TABLE
347: , p5_a30 JTF_NUMBER_TABLE
348: , p5_a31 JTF_NUMBER_TABLE
349: , p5_a32 JTF_NUMBER_TABLE
350: , p5_a33 JTF_NUMBER_TABLE
343: , p5_a26 JTF_VARCHAR2_TABLE_100
344: , p5_a27 JTF_DATE_TABLE
345: , p5_a28 JTF_DATE_TABLE
346: , p5_a29 JTF_NUMBER_TABLE
347: , p5_a30 JTF_NUMBER_TABLE
348: , p5_a31 JTF_NUMBER_TABLE
349: , p5_a32 JTF_NUMBER_TABLE
350: , p5_a33 JTF_NUMBER_TABLE
351: , p5_a34 JTF_VARCHAR2_TABLE_100
344: , p5_a27 JTF_DATE_TABLE
345: , p5_a28 JTF_DATE_TABLE
346: , p5_a29 JTF_NUMBER_TABLE
347: , p5_a30 JTF_NUMBER_TABLE
348: , p5_a31 JTF_NUMBER_TABLE
349: , p5_a32 JTF_NUMBER_TABLE
350: , p5_a33 JTF_NUMBER_TABLE
351: , p5_a34 JTF_VARCHAR2_TABLE_100
352: , p5_a35 JTF_VARCHAR2_TABLE_300
345: , p5_a28 JTF_DATE_TABLE
346: , p5_a29 JTF_NUMBER_TABLE
347: , p5_a30 JTF_NUMBER_TABLE
348: , p5_a31 JTF_NUMBER_TABLE
349: , p5_a32 JTF_NUMBER_TABLE
350: , p5_a33 JTF_NUMBER_TABLE
351: , p5_a34 JTF_VARCHAR2_TABLE_100
352: , p5_a35 JTF_VARCHAR2_TABLE_300
353: , p5_a36 JTF_VARCHAR2_TABLE_2000
346: , p5_a29 JTF_NUMBER_TABLE
347: , p5_a30 JTF_NUMBER_TABLE
348: , p5_a31 JTF_NUMBER_TABLE
349: , p5_a32 JTF_NUMBER_TABLE
350: , p5_a33 JTF_NUMBER_TABLE
351: , p5_a34 JTF_VARCHAR2_TABLE_100
352: , p5_a35 JTF_VARCHAR2_TABLE_300
353: , p5_a36 JTF_VARCHAR2_TABLE_2000
354: , p5_a37 JTF_VARCHAR2_TABLE_2000
351: , p5_a34 JTF_VARCHAR2_TABLE_100
352: , p5_a35 JTF_VARCHAR2_TABLE_300
353: , p5_a36 JTF_VARCHAR2_TABLE_2000
354: , p5_a37 JTF_VARCHAR2_TABLE_2000
355: , p5_a38 JTF_NUMBER_TABLE
356: , p6_a0 out nocopy JTF_NUMBER_TABLE
357: , p6_a1 out nocopy JTF_NUMBER_TABLE
358: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
359: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_500
352: , p5_a35 JTF_VARCHAR2_TABLE_300
353: , p5_a36 JTF_VARCHAR2_TABLE_2000
354: , p5_a37 JTF_VARCHAR2_TABLE_2000
355: , p5_a38 JTF_NUMBER_TABLE
356: , p6_a0 out nocopy JTF_NUMBER_TABLE
357: , p6_a1 out nocopy JTF_NUMBER_TABLE
358: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
359: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_500
360: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_500
353: , p5_a36 JTF_VARCHAR2_TABLE_2000
354: , p5_a37 JTF_VARCHAR2_TABLE_2000
355: , p5_a38 JTF_NUMBER_TABLE
356: , p6_a0 out nocopy JTF_NUMBER_TABLE
357: , p6_a1 out nocopy JTF_NUMBER_TABLE
358: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
359: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_500
360: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_500
361: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500
371: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
372: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
373: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
374: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
375: , p6_a19 out nocopy JTF_NUMBER_TABLE
376: , p6_a20 out nocopy JTF_NUMBER_TABLE
377: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
378: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
379: , p6_a23 out nocopy JTF_NUMBER_TABLE
372: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
373: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
374: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
375: , p6_a19 out nocopy JTF_NUMBER_TABLE
376: , p6_a20 out nocopy JTF_NUMBER_TABLE
377: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
378: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
379: , p6_a23 out nocopy JTF_NUMBER_TABLE
380: , p6_a24 out nocopy JTF_NUMBER_TABLE
375: , p6_a19 out nocopy JTF_NUMBER_TABLE
376: , p6_a20 out nocopy JTF_NUMBER_TABLE
377: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
378: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
379: , p6_a23 out nocopy JTF_NUMBER_TABLE
380: , p6_a24 out nocopy JTF_NUMBER_TABLE
381: , p6_a25 out nocopy JTF_NUMBER_TABLE
382: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_100
383: , p6_a27 out nocopy JTF_DATE_TABLE
376: , p6_a20 out nocopy JTF_NUMBER_TABLE
377: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
378: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
379: , p6_a23 out nocopy JTF_NUMBER_TABLE
380: , p6_a24 out nocopy JTF_NUMBER_TABLE
381: , p6_a25 out nocopy JTF_NUMBER_TABLE
382: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_100
383: , p6_a27 out nocopy JTF_DATE_TABLE
384: , p6_a28 out nocopy JTF_DATE_TABLE
377: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
378: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
379: , p6_a23 out nocopy JTF_NUMBER_TABLE
380: , p6_a24 out nocopy JTF_NUMBER_TABLE
381: , p6_a25 out nocopy JTF_NUMBER_TABLE
382: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_100
383: , p6_a27 out nocopy JTF_DATE_TABLE
384: , p6_a28 out nocopy JTF_DATE_TABLE
385: , p6_a29 out nocopy JTF_NUMBER_TABLE
381: , p6_a25 out nocopy JTF_NUMBER_TABLE
382: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_100
383: , p6_a27 out nocopy JTF_DATE_TABLE
384: , p6_a28 out nocopy JTF_DATE_TABLE
385: , p6_a29 out nocopy JTF_NUMBER_TABLE
386: , p6_a30 out nocopy JTF_NUMBER_TABLE
387: , p6_a31 out nocopy JTF_NUMBER_TABLE
388: , p6_a32 out nocopy JTF_NUMBER_TABLE
389: , p6_a33 out nocopy JTF_NUMBER_TABLE
382: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_100
383: , p6_a27 out nocopy JTF_DATE_TABLE
384: , p6_a28 out nocopy JTF_DATE_TABLE
385: , p6_a29 out nocopy JTF_NUMBER_TABLE
386: , p6_a30 out nocopy JTF_NUMBER_TABLE
387: , p6_a31 out nocopy JTF_NUMBER_TABLE
388: , p6_a32 out nocopy JTF_NUMBER_TABLE
389: , p6_a33 out nocopy JTF_NUMBER_TABLE
390: , p6_a34 out nocopy JTF_VARCHAR2_TABLE_100
383: , p6_a27 out nocopy JTF_DATE_TABLE
384: , p6_a28 out nocopy JTF_DATE_TABLE
385: , p6_a29 out nocopy JTF_NUMBER_TABLE
386: , p6_a30 out nocopy JTF_NUMBER_TABLE
387: , p6_a31 out nocopy JTF_NUMBER_TABLE
388: , p6_a32 out nocopy JTF_NUMBER_TABLE
389: , p6_a33 out nocopy JTF_NUMBER_TABLE
390: , p6_a34 out nocopy JTF_VARCHAR2_TABLE_100
391: , p6_a35 out nocopy JTF_VARCHAR2_TABLE_300
384: , p6_a28 out nocopy JTF_DATE_TABLE
385: , p6_a29 out nocopy JTF_NUMBER_TABLE
386: , p6_a30 out nocopy JTF_NUMBER_TABLE
387: , p6_a31 out nocopy JTF_NUMBER_TABLE
388: , p6_a32 out nocopy JTF_NUMBER_TABLE
389: , p6_a33 out nocopy JTF_NUMBER_TABLE
390: , p6_a34 out nocopy JTF_VARCHAR2_TABLE_100
391: , p6_a35 out nocopy JTF_VARCHAR2_TABLE_300
392: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_2000
385: , p6_a29 out nocopy JTF_NUMBER_TABLE
386: , p6_a30 out nocopy JTF_NUMBER_TABLE
387: , p6_a31 out nocopy JTF_NUMBER_TABLE
388: , p6_a32 out nocopy JTF_NUMBER_TABLE
389: , p6_a33 out nocopy JTF_NUMBER_TABLE
390: , p6_a34 out nocopy JTF_VARCHAR2_TABLE_100
391: , p6_a35 out nocopy JTF_VARCHAR2_TABLE_300
392: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_2000
393: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_2000
390: , p6_a34 out nocopy JTF_VARCHAR2_TABLE_100
391: , p6_a35 out nocopy JTF_VARCHAR2_TABLE_300
392: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_2000
393: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_2000
394: , p6_a38 out nocopy JTF_NUMBER_TABLE
395: )
396:
397: as
398: ddp_feev_tbl okl_fee_pvt.feev_tbl_type;
510: , p_init_msg_list VARCHAR2
511: , x_return_status out nocopy VARCHAR2
512: , x_msg_count out nocopy NUMBER
513: , x_msg_data out nocopy VARCHAR2
514: , p5_a0 JTF_NUMBER_TABLE
515: , p5_a1 JTF_NUMBER_TABLE
516: , p5_a2 JTF_VARCHAR2_TABLE_100
517: , p5_a3 JTF_VARCHAR2_TABLE_500
518: , p5_a4 JTF_VARCHAR2_TABLE_500
511: , x_return_status out nocopy VARCHAR2
512: , x_msg_count out nocopy NUMBER
513: , x_msg_data out nocopy VARCHAR2
514: , p5_a0 JTF_NUMBER_TABLE
515: , p5_a1 JTF_NUMBER_TABLE
516: , p5_a2 JTF_VARCHAR2_TABLE_100
517: , p5_a3 JTF_VARCHAR2_TABLE_500
518: , p5_a4 JTF_VARCHAR2_TABLE_500
519: , p5_a5 JTF_VARCHAR2_TABLE_500
529: , p5_a15 JTF_VARCHAR2_TABLE_500
530: , p5_a16 JTF_VARCHAR2_TABLE_500
531: , p5_a17 JTF_VARCHAR2_TABLE_500
532: , p5_a18 JTF_VARCHAR2_TABLE_100
533: , p5_a19 JTF_NUMBER_TABLE
534: , p5_a20 JTF_NUMBER_TABLE
535: , p5_a21 JTF_VARCHAR2_TABLE_100
536: , p5_a22 JTF_VARCHAR2_TABLE_100
537: , p5_a23 JTF_NUMBER_TABLE
530: , p5_a16 JTF_VARCHAR2_TABLE_500
531: , p5_a17 JTF_VARCHAR2_TABLE_500
532: , p5_a18 JTF_VARCHAR2_TABLE_100
533: , p5_a19 JTF_NUMBER_TABLE
534: , p5_a20 JTF_NUMBER_TABLE
535: , p5_a21 JTF_VARCHAR2_TABLE_100
536: , p5_a22 JTF_VARCHAR2_TABLE_100
537: , p5_a23 JTF_NUMBER_TABLE
538: , p5_a24 JTF_NUMBER_TABLE
533: , p5_a19 JTF_NUMBER_TABLE
534: , p5_a20 JTF_NUMBER_TABLE
535: , p5_a21 JTF_VARCHAR2_TABLE_100
536: , p5_a22 JTF_VARCHAR2_TABLE_100
537: , p5_a23 JTF_NUMBER_TABLE
538: , p5_a24 JTF_NUMBER_TABLE
539: , p5_a25 JTF_NUMBER_TABLE
540: , p5_a26 JTF_VARCHAR2_TABLE_100
541: , p5_a27 JTF_DATE_TABLE
534: , p5_a20 JTF_NUMBER_TABLE
535: , p5_a21 JTF_VARCHAR2_TABLE_100
536: , p5_a22 JTF_VARCHAR2_TABLE_100
537: , p5_a23 JTF_NUMBER_TABLE
538: , p5_a24 JTF_NUMBER_TABLE
539: , p5_a25 JTF_NUMBER_TABLE
540: , p5_a26 JTF_VARCHAR2_TABLE_100
541: , p5_a27 JTF_DATE_TABLE
542: , p5_a28 JTF_DATE_TABLE
535: , p5_a21 JTF_VARCHAR2_TABLE_100
536: , p5_a22 JTF_VARCHAR2_TABLE_100
537: , p5_a23 JTF_NUMBER_TABLE
538: , p5_a24 JTF_NUMBER_TABLE
539: , p5_a25 JTF_NUMBER_TABLE
540: , p5_a26 JTF_VARCHAR2_TABLE_100
541: , p5_a27 JTF_DATE_TABLE
542: , p5_a28 JTF_DATE_TABLE
543: , p5_a29 JTF_NUMBER_TABLE
539: , p5_a25 JTF_NUMBER_TABLE
540: , p5_a26 JTF_VARCHAR2_TABLE_100
541: , p5_a27 JTF_DATE_TABLE
542: , p5_a28 JTF_DATE_TABLE
543: , p5_a29 JTF_NUMBER_TABLE
544: , p5_a30 JTF_NUMBER_TABLE
545: , p5_a31 JTF_NUMBER_TABLE
546: , p5_a32 JTF_NUMBER_TABLE
547: , p5_a33 JTF_NUMBER_TABLE
540: , p5_a26 JTF_VARCHAR2_TABLE_100
541: , p5_a27 JTF_DATE_TABLE
542: , p5_a28 JTF_DATE_TABLE
543: , p5_a29 JTF_NUMBER_TABLE
544: , p5_a30 JTF_NUMBER_TABLE
545: , p5_a31 JTF_NUMBER_TABLE
546: , p5_a32 JTF_NUMBER_TABLE
547: , p5_a33 JTF_NUMBER_TABLE
548: , p5_a34 JTF_VARCHAR2_TABLE_100
541: , p5_a27 JTF_DATE_TABLE
542: , p5_a28 JTF_DATE_TABLE
543: , p5_a29 JTF_NUMBER_TABLE
544: , p5_a30 JTF_NUMBER_TABLE
545: , p5_a31 JTF_NUMBER_TABLE
546: , p5_a32 JTF_NUMBER_TABLE
547: , p5_a33 JTF_NUMBER_TABLE
548: , p5_a34 JTF_VARCHAR2_TABLE_100
549: , p5_a35 JTF_VARCHAR2_TABLE_300
542: , p5_a28 JTF_DATE_TABLE
543: , p5_a29 JTF_NUMBER_TABLE
544: , p5_a30 JTF_NUMBER_TABLE
545: , p5_a31 JTF_NUMBER_TABLE
546: , p5_a32 JTF_NUMBER_TABLE
547: , p5_a33 JTF_NUMBER_TABLE
548: , p5_a34 JTF_VARCHAR2_TABLE_100
549: , p5_a35 JTF_VARCHAR2_TABLE_300
550: , p5_a36 JTF_VARCHAR2_TABLE_2000
543: , p5_a29 JTF_NUMBER_TABLE
544: , p5_a30 JTF_NUMBER_TABLE
545: , p5_a31 JTF_NUMBER_TABLE
546: , p5_a32 JTF_NUMBER_TABLE
547: , p5_a33 JTF_NUMBER_TABLE
548: , p5_a34 JTF_VARCHAR2_TABLE_100
549: , p5_a35 JTF_VARCHAR2_TABLE_300
550: , p5_a36 JTF_VARCHAR2_TABLE_2000
551: , p5_a37 JTF_VARCHAR2_TABLE_2000
548: , p5_a34 JTF_VARCHAR2_TABLE_100
549: , p5_a35 JTF_VARCHAR2_TABLE_300
550: , p5_a36 JTF_VARCHAR2_TABLE_2000
551: , p5_a37 JTF_VARCHAR2_TABLE_2000
552: , p5_a38 JTF_NUMBER_TABLE
553: , p6_a0 out nocopy JTF_NUMBER_TABLE
554: , p6_a1 out nocopy JTF_NUMBER_TABLE
555: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
556: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_500
549: , p5_a35 JTF_VARCHAR2_TABLE_300
550: , p5_a36 JTF_VARCHAR2_TABLE_2000
551: , p5_a37 JTF_VARCHAR2_TABLE_2000
552: , p5_a38 JTF_NUMBER_TABLE
553: , p6_a0 out nocopy JTF_NUMBER_TABLE
554: , p6_a1 out nocopy JTF_NUMBER_TABLE
555: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
556: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_500
557: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_500
550: , p5_a36 JTF_VARCHAR2_TABLE_2000
551: , p5_a37 JTF_VARCHAR2_TABLE_2000
552: , p5_a38 JTF_NUMBER_TABLE
553: , p6_a0 out nocopy JTF_NUMBER_TABLE
554: , p6_a1 out nocopy JTF_NUMBER_TABLE
555: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
556: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_500
557: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_500
558: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500
568: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
569: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
570: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
571: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
572: , p6_a19 out nocopy JTF_NUMBER_TABLE
573: , p6_a20 out nocopy JTF_NUMBER_TABLE
574: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
575: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
576: , p6_a23 out nocopy JTF_NUMBER_TABLE
569: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
570: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
571: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
572: , p6_a19 out nocopy JTF_NUMBER_TABLE
573: , p6_a20 out nocopy JTF_NUMBER_TABLE
574: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
575: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
576: , p6_a23 out nocopy JTF_NUMBER_TABLE
577: , p6_a24 out nocopy JTF_NUMBER_TABLE
572: , p6_a19 out nocopy JTF_NUMBER_TABLE
573: , p6_a20 out nocopy JTF_NUMBER_TABLE
574: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
575: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
576: , p6_a23 out nocopy JTF_NUMBER_TABLE
577: , p6_a24 out nocopy JTF_NUMBER_TABLE
578: , p6_a25 out nocopy JTF_NUMBER_TABLE
579: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_100
580: , p6_a27 out nocopy JTF_DATE_TABLE
573: , p6_a20 out nocopy JTF_NUMBER_TABLE
574: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
575: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
576: , p6_a23 out nocopy JTF_NUMBER_TABLE
577: , p6_a24 out nocopy JTF_NUMBER_TABLE
578: , p6_a25 out nocopy JTF_NUMBER_TABLE
579: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_100
580: , p6_a27 out nocopy JTF_DATE_TABLE
581: , p6_a28 out nocopy JTF_DATE_TABLE
574: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
575: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
576: , p6_a23 out nocopy JTF_NUMBER_TABLE
577: , p6_a24 out nocopy JTF_NUMBER_TABLE
578: , p6_a25 out nocopy JTF_NUMBER_TABLE
579: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_100
580: , p6_a27 out nocopy JTF_DATE_TABLE
581: , p6_a28 out nocopy JTF_DATE_TABLE
582: , p6_a29 out nocopy JTF_NUMBER_TABLE
578: , p6_a25 out nocopy JTF_NUMBER_TABLE
579: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_100
580: , p6_a27 out nocopy JTF_DATE_TABLE
581: , p6_a28 out nocopy JTF_DATE_TABLE
582: , p6_a29 out nocopy JTF_NUMBER_TABLE
583: , p6_a30 out nocopy JTF_NUMBER_TABLE
584: , p6_a31 out nocopy JTF_NUMBER_TABLE
585: , p6_a32 out nocopy JTF_NUMBER_TABLE
586: , p6_a33 out nocopy JTF_NUMBER_TABLE
579: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_100
580: , p6_a27 out nocopy JTF_DATE_TABLE
581: , p6_a28 out nocopy JTF_DATE_TABLE
582: , p6_a29 out nocopy JTF_NUMBER_TABLE
583: , p6_a30 out nocopy JTF_NUMBER_TABLE
584: , p6_a31 out nocopy JTF_NUMBER_TABLE
585: , p6_a32 out nocopy JTF_NUMBER_TABLE
586: , p6_a33 out nocopy JTF_NUMBER_TABLE
587: , p6_a34 out nocopy JTF_VARCHAR2_TABLE_100
580: , p6_a27 out nocopy JTF_DATE_TABLE
581: , p6_a28 out nocopy JTF_DATE_TABLE
582: , p6_a29 out nocopy JTF_NUMBER_TABLE
583: , p6_a30 out nocopy JTF_NUMBER_TABLE
584: , p6_a31 out nocopy JTF_NUMBER_TABLE
585: , p6_a32 out nocopy JTF_NUMBER_TABLE
586: , p6_a33 out nocopy JTF_NUMBER_TABLE
587: , p6_a34 out nocopy JTF_VARCHAR2_TABLE_100
588: , p6_a35 out nocopy JTF_VARCHAR2_TABLE_300
581: , p6_a28 out nocopy JTF_DATE_TABLE
582: , p6_a29 out nocopy JTF_NUMBER_TABLE
583: , p6_a30 out nocopy JTF_NUMBER_TABLE
584: , p6_a31 out nocopy JTF_NUMBER_TABLE
585: , p6_a32 out nocopy JTF_NUMBER_TABLE
586: , p6_a33 out nocopy JTF_NUMBER_TABLE
587: , p6_a34 out nocopy JTF_VARCHAR2_TABLE_100
588: , p6_a35 out nocopy JTF_VARCHAR2_TABLE_300
589: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_2000
582: , p6_a29 out nocopy JTF_NUMBER_TABLE
583: , p6_a30 out nocopy JTF_NUMBER_TABLE
584: , p6_a31 out nocopy JTF_NUMBER_TABLE
585: , p6_a32 out nocopy JTF_NUMBER_TABLE
586: , p6_a33 out nocopy JTF_NUMBER_TABLE
587: , p6_a34 out nocopy JTF_VARCHAR2_TABLE_100
588: , p6_a35 out nocopy JTF_VARCHAR2_TABLE_300
589: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_2000
590: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_2000
587: , p6_a34 out nocopy JTF_VARCHAR2_TABLE_100
588: , p6_a35 out nocopy JTF_VARCHAR2_TABLE_300
589: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_2000
590: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_2000
591: , p6_a38 out nocopy JTF_NUMBER_TABLE
592: )
593:
594: as
595: ddp_feev_tbl okl_fee_pvt.feev_tbl_type;
707: , p_init_msg_list VARCHAR2
708: , x_return_status out nocopy VARCHAR2
709: , x_msg_count out nocopy NUMBER
710: , x_msg_data out nocopy VARCHAR2
711: , p5_a0 JTF_NUMBER_TABLE
712: , p5_a1 JTF_NUMBER_TABLE
713: , p5_a2 JTF_VARCHAR2_TABLE_100
714: , p5_a3 JTF_VARCHAR2_TABLE_500
715: , p5_a4 JTF_VARCHAR2_TABLE_500
708: , x_return_status out nocopy VARCHAR2
709: , x_msg_count out nocopy NUMBER
710: , x_msg_data out nocopy VARCHAR2
711: , p5_a0 JTF_NUMBER_TABLE
712: , p5_a1 JTF_NUMBER_TABLE
713: , p5_a2 JTF_VARCHAR2_TABLE_100
714: , p5_a3 JTF_VARCHAR2_TABLE_500
715: , p5_a4 JTF_VARCHAR2_TABLE_500
716: , p5_a5 JTF_VARCHAR2_TABLE_500
726: , p5_a15 JTF_VARCHAR2_TABLE_500
727: , p5_a16 JTF_VARCHAR2_TABLE_500
728: , p5_a17 JTF_VARCHAR2_TABLE_500
729: , p5_a18 JTF_VARCHAR2_TABLE_100
730: , p5_a19 JTF_NUMBER_TABLE
731: , p5_a20 JTF_NUMBER_TABLE
732: , p5_a21 JTF_VARCHAR2_TABLE_100
733: , p5_a22 JTF_VARCHAR2_TABLE_100
734: , p5_a23 JTF_NUMBER_TABLE
727: , p5_a16 JTF_VARCHAR2_TABLE_500
728: , p5_a17 JTF_VARCHAR2_TABLE_500
729: , p5_a18 JTF_VARCHAR2_TABLE_100
730: , p5_a19 JTF_NUMBER_TABLE
731: , p5_a20 JTF_NUMBER_TABLE
732: , p5_a21 JTF_VARCHAR2_TABLE_100
733: , p5_a22 JTF_VARCHAR2_TABLE_100
734: , p5_a23 JTF_NUMBER_TABLE
735: , p5_a24 JTF_NUMBER_TABLE
730: , p5_a19 JTF_NUMBER_TABLE
731: , p5_a20 JTF_NUMBER_TABLE
732: , p5_a21 JTF_VARCHAR2_TABLE_100
733: , p5_a22 JTF_VARCHAR2_TABLE_100
734: , p5_a23 JTF_NUMBER_TABLE
735: , p5_a24 JTF_NUMBER_TABLE
736: , p5_a25 JTF_NUMBER_TABLE
737: , p5_a26 JTF_VARCHAR2_TABLE_100
738: , p5_a27 JTF_DATE_TABLE
731: , p5_a20 JTF_NUMBER_TABLE
732: , p5_a21 JTF_VARCHAR2_TABLE_100
733: , p5_a22 JTF_VARCHAR2_TABLE_100
734: , p5_a23 JTF_NUMBER_TABLE
735: , p5_a24 JTF_NUMBER_TABLE
736: , p5_a25 JTF_NUMBER_TABLE
737: , p5_a26 JTF_VARCHAR2_TABLE_100
738: , p5_a27 JTF_DATE_TABLE
739: , p5_a28 JTF_DATE_TABLE
732: , p5_a21 JTF_VARCHAR2_TABLE_100
733: , p5_a22 JTF_VARCHAR2_TABLE_100
734: , p5_a23 JTF_NUMBER_TABLE
735: , p5_a24 JTF_NUMBER_TABLE
736: , p5_a25 JTF_NUMBER_TABLE
737: , p5_a26 JTF_VARCHAR2_TABLE_100
738: , p5_a27 JTF_DATE_TABLE
739: , p5_a28 JTF_DATE_TABLE
740: , p5_a29 JTF_NUMBER_TABLE
736: , p5_a25 JTF_NUMBER_TABLE
737: , p5_a26 JTF_VARCHAR2_TABLE_100
738: , p5_a27 JTF_DATE_TABLE
739: , p5_a28 JTF_DATE_TABLE
740: , p5_a29 JTF_NUMBER_TABLE
741: , p5_a30 JTF_NUMBER_TABLE
742: , p5_a31 JTF_NUMBER_TABLE
743: , p5_a32 JTF_NUMBER_TABLE
744: , p5_a33 JTF_NUMBER_TABLE
737: , p5_a26 JTF_VARCHAR2_TABLE_100
738: , p5_a27 JTF_DATE_TABLE
739: , p5_a28 JTF_DATE_TABLE
740: , p5_a29 JTF_NUMBER_TABLE
741: , p5_a30 JTF_NUMBER_TABLE
742: , p5_a31 JTF_NUMBER_TABLE
743: , p5_a32 JTF_NUMBER_TABLE
744: , p5_a33 JTF_NUMBER_TABLE
745: , p5_a34 JTF_VARCHAR2_TABLE_100
738: , p5_a27 JTF_DATE_TABLE
739: , p5_a28 JTF_DATE_TABLE
740: , p5_a29 JTF_NUMBER_TABLE
741: , p5_a30 JTF_NUMBER_TABLE
742: , p5_a31 JTF_NUMBER_TABLE
743: , p5_a32 JTF_NUMBER_TABLE
744: , p5_a33 JTF_NUMBER_TABLE
745: , p5_a34 JTF_VARCHAR2_TABLE_100
746: , p5_a35 JTF_VARCHAR2_TABLE_300
739: , p5_a28 JTF_DATE_TABLE
740: , p5_a29 JTF_NUMBER_TABLE
741: , p5_a30 JTF_NUMBER_TABLE
742: , p5_a31 JTF_NUMBER_TABLE
743: , p5_a32 JTF_NUMBER_TABLE
744: , p5_a33 JTF_NUMBER_TABLE
745: , p5_a34 JTF_VARCHAR2_TABLE_100
746: , p5_a35 JTF_VARCHAR2_TABLE_300
747: , p5_a36 JTF_VARCHAR2_TABLE_2000
740: , p5_a29 JTF_NUMBER_TABLE
741: , p5_a30 JTF_NUMBER_TABLE
742: , p5_a31 JTF_NUMBER_TABLE
743: , p5_a32 JTF_NUMBER_TABLE
744: , p5_a33 JTF_NUMBER_TABLE
745: , p5_a34 JTF_VARCHAR2_TABLE_100
746: , p5_a35 JTF_VARCHAR2_TABLE_300
747: , p5_a36 JTF_VARCHAR2_TABLE_2000
748: , p5_a37 JTF_VARCHAR2_TABLE_2000
745: , p5_a34 JTF_VARCHAR2_TABLE_100
746: , p5_a35 JTF_VARCHAR2_TABLE_300
747: , p5_a36 JTF_VARCHAR2_TABLE_2000
748: , p5_a37 JTF_VARCHAR2_TABLE_2000
749: , p5_a38 JTF_NUMBER_TABLE
750: )
751:
752: as
753: ddp_feev_tbl okl_fee_pvt.feev_tbl_type;