eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.LNS_FEE_ENGINE_W dependencies on JTF_NUMBER_TABLE

Line 4: , a1 JTF_NUMBER_TABLE

1: package body lns_fee_engine_w as
2: /* $Header: LNS_FEE_ENGINJ_B.pls 120.3.12010000.4 2010/02/24 01:45:44 mbolli ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy lns_fee_engine.fee_basis_tbl, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_NUMBER_TABLE
5: ) as
6: ddindx binary_integer; indx binary_integer;
7: begin
8: if a0 is not null and a0.count > 0 then

Line 25: , a1 out nocopy JTF_NUMBER_TABLE

21: end if;
22: end if;
23: end rosetta_table_copy_in_p1;
24: procedure rosetta_table_copy_out_p1(t lns_fee_engine.fee_basis_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100
25: , a1 out nocopy JTF_NUMBER_TABLE
26: ) as
27: ddindx binary_integer; indx binary_integer;
28: begin
29: if t is null or t.count = 0 then

Line 31: a1 := JTF_NUMBER_TABLE();

27: ddindx binary_integer; indx binary_integer;
28: begin
29: if t is null or t.count = 0 then
30: a0 := JTF_VARCHAR2_TABLE_100();
31: a1 := JTF_NUMBER_TABLE();
32: else
33: a0 := JTF_VARCHAR2_TABLE_100();
34: a1 := JTF_NUMBER_TABLE();
35: if t.count > 0 then

Line 34: a1 := JTF_NUMBER_TABLE();

30: a0 := JTF_VARCHAR2_TABLE_100();
31: a1 := JTF_NUMBER_TABLE();
32: else
33: a0 := JTF_VARCHAR2_TABLE_100();
34: a1 := JTF_NUMBER_TABLE();
35: if t.count > 0 then
36: a0.extend(t.count);
37: a1.extend(t.count);
38: ddindx := t.first;

Line 53: procedure rosetta_table_copy_in_p3(t out nocopy lns_fee_engine.fee_structure_tbl, a0 JTF_NUMBER_TABLE

49: end if;
50: end if;
51: end rosetta_table_copy_out_p1;
52:
53: procedure rosetta_table_copy_in_p3(t out nocopy lns_fee_engine.fee_structure_tbl, a0 JTF_NUMBER_TABLE
54: , a1 JTF_VARCHAR2_TABLE_100
55: , a2 JTF_VARCHAR2_TABLE_300
56: , a3 JTF_VARCHAR2_TABLE_100
57: , a4 JTF_VARCHAR2_TABLE_100

Line 58: , a5 JTF_NUMBER_TABLE

54: , a1 JTF_VARCHAR2_TABLE_100
55: , a2 JTF_VARCHAR2_TABLE_300
56: , a3 JTF_VARCHAR2_TABLE_100
57: , a4 JTF_VARCHAR2_TABLE_100
58: , a5 JTF_NUMBER_TABLE
59: , a6 JTF_VARCHAR2_TABLE_100
60: , a7 JTF_DATE_TABLE
61: , a8 JTF_DATE_TABLE
62: , a9 JTF_NUMBER_TABLE

Line 62: , a9 JTF_NUMBER_TABLE

58: , a5 JTF_NUMBER_TABLE
59: , a6 JTF_VARCHAR2_TABLE_100
60: , a7 JTF_DATE_TABLE
61: , a8 JTF_DATE_TABLE
62: , a9 JTF_NUMBER_TABLE
63: , a10 JTF_VARCHAR2_TABLE_100
64: , a11 JTF_VARCHAR2_TABLE_100
65: , a12 JTF_NUMBER_TABLE
66: , a13 JTF_NUMBER_TABLE

Line 65: , a12 JTF_NUMBER_TABLE

61: , a8 JTF_DATE_TABLE
62: , a9 JTF_NUMBER_TABLE
63: , a10 JTF_VARCHAR2_TABLE_100
64: , a11 JTF_VARCHAR2_TABLE_100
65: , a12 JTF_NUMBER_TABLE
66: , a13 JTF_NUMBER_TABLE
67: , a14 JTF_VARCHAR2_TABLE_100
68: , a15 JTF_VARCHAR2_TABLE_100
69: , a16 JTF_VARCHAR2_TABLE_100

Line 66: , a13 JTF_NUMBER_TABLE

62: , a9 JTF_NUMBER_TABLE
63: , a10 JTF_VARCHAR2_TABLE_100
64: , a11 JTF_VARCHAR2_TABLE_100
65: , a12 JTF_NUMBER_TABLE
66: , a13 JTF_NUMBER_TABLE
67: , a14 JTF_VARCHAR2_TABLE_100
68: , a15 JTF_VARCHAR2_TABLE_100
69: , a16 JTF_VARCHAR2_TABLE_100
70: , a17 JTF_NUMBER_TABLE

Line 70: , a17 JTF_NUMBER_TABLE

66: , a13 JTF_NUMBER_TABLE
67: , a14 JTF_VARCHAR2_TABLE_100
68: , a15 JTF_VARCHAR2_TABLE_100
69: , a16 JTF_VARCHAR2_TABLE_100
70: , a17 JTF_NUMBER_TABLE
71: , a18 JTF_VARCHAR2_TABLE_100
72: , a19 JTF_VARCHAR2_TABLE_100
73: , a20 JTF_NUMBER_TABLE
74: , a21 JTF_NUMBER_TABLE

Line 73: , a20 JTF_NUMBER_TABLE

69: , a16 JTF_VARCHAR2_TABLE_100
70: , a17 JTF_NUMBER_TABLE
71: , a18 JTF_VARCHAR2_TABLE_100
72: , a19 JTF_VARCHAR2_TABLE_100
73: , a20 JTF_NUMBER_TABLE
74: , a21 JTF_NUMBER_TABLE
75: , a22 JTF_DATE_TABLE
76: , a23 JTF_VARCHAR2_TABLE_100
77: ) as

Line 74: , a21 JTF_NUMBER_TABLE

70: , a17 JTF_NUMBER_TABLE
71: , a18 JTF_VARCHAR2_TABLE_100
72: , a19 JTF_VARCHAR2_TABLE_100
73: , a20 JTF_NUMBER_TABLE
74: , a21 JTF_NUMBER_TABLE
75: , a22 JTF_DATE_TABLE
76: , a23 JTF_VARCHAR2_TABLE_100
77: ) as
78: ddindx binary_integer; indx binary_integer;

Line 118: procedure rosetta_table_copy_out_p3(t lns_fee_engine.fee_structure_tbl, a0 out nocopy JTF_NUMBER_TABLE

114: end loop;
115: end if;
116: end if;
117: end rosetta_table_copy_in_p3;
118: procedure rosetta_table_copy_out_p3(t lns_fee_engine.fee_structure_tbl, a0 out nocopy JTF_NUMBER_TABLE
119: , a1 out nocopy JTF_VARCHAR2_TABLE_100
120: , a2 out nocopy JTF_VARCHAR2_TABLE_300
121: , a3 out nocopy JTF_VARCHAR2_TABLE_100
122: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 123: , a5 out nocopy JTF_NUMBER_TABLE

119: , a1 out nocopy JTF_VARCHAR2_TABLE_100
120: , a2 out nocopy JTF_VARCHAR2_TABLE_300
121: , a3 out nocopy JTF_VARCHAR2_TABLE_100
122: , a4 out nocopy JTF_VARCHAR2_TABLE_100
123: , a5 out nocopy JTF_NUMBER_TABLE
124: , a6 out nocopy JTF_VARCHAR2_TABLE_100
125: , a7 out nocopy JTF_DATE_TABLE
126: , a8 out nocopy JTF_DATE_TABLE
127: , a9 out nocopy JTF_NUMBER_TABLE

Line 127: , a9 out nocopy JTF_NUMBER_TABLE

123: , a5 out nocopy JTF_NUMBER_TABLE
124: , a6 out nocopy JTF_VARCHAR2_TABLE_100
125: , a7 out nocopy JTF_DATE_TABLE
126: , a8 out nocopy JTF_DATE_TABLE
127: , a9 out nocopy JTF_NUMBER_TABLE
128: , a10 out nocopy JTF_VARCHAR2_TABLE_100
129: , a11 out nocopy JTF_VARCHAR2_TABLE_100
130: , a12 out nocopy JTF_NUMBER_TABLE
131: , a13 out nocopy JTF_NUMBER_TABLE

Line 130: , a12 out nocopy JTF_NUMBER_TABLE

126: , a8 out nocopy JTF_DATE_TABLE
127: , a9 out nocopy JTF_NUMBER_TABLE
128: , a10 out nocopy JTF_VARCHAR2_TABLE_100
129: , a11 out nocopy JTF_VARCHAR2_TABLE_100
130: , a12 out nocopy JTF_NUMBER_TABLE
131: , a13 out nocopy JTF_NUMBER_TABLE
132: , a14 out nocopy JTF_VARCHAR2_TABLE_100
133: , a15 out nocopy JTF_VARCHAR2_TABLE_100
134: , a16 out nocopy JTF_VARCHAR2_TABLE_100

Line 131: , a13 out nocopy JTF_NUMBER_TABLE

127: , a9 out nocopy JTF_NUMBER_TABLE
128: , a10 out nocopy JTF_VARCHAR2_TABLE_100
129: , a11 out nocopy JTF_VARCHAR2_TABLE_100
130: , a12 out nocopy JTF_NUMBER_TABLE
131: , a13 out nocopy JTF_NUMBER_TABLE
132: , a14 out nocopy JTF_VARCHAR2_TABLE_100
133: , a15 out nocopy JTF_VARCHAR2_TABLE_100
134: , a16 out nocopy JTF_VARCHAR2_TABLE_100
135: , a17 out nocopy JTF_NUMBER_TABLE

Line 135: , a17 out nocopy JTF_NUMBER_TABLE

131: , a13 out nocopy JTF_NUMBER_TABLE
132: , a14 out nocopy JTF_VARCHAR2_TABLE_100
133: , a15 out nocopy JTF_VARCHAR2_TABLE_100
134: , a16 out nocopy JTF_VARCHAR2_TABLE_100
135: , a17 out nocopy JTF_NUMBER_TABLE
136: , a18 out nocopy JTF_VARCHAR2_TABLE_100
137: , a19 out nocopy JTF_VARCHAR2_TABLE_100
138: , a20 out nocopy JTF_NUMBER_TABLE
139: , a21 out nocopy JTF_NUMBER_TABLE

Line 138: , a20 out nocopy JTF_NUMBER_TABLE

134: , a16 out nocopy JTF_VARCHAR2_TABLE_100
135: , a17 out nocopy JTF_NUMBER_TABLE
136: , a18 out nocopy JTF_VARCHAR2_TABLE_100
137: , a19 out nocopy JTF_VARCHAR2_TABLE_100
138: , a20 out nocopy JTF_NUMBER_TABLE
139: , a21 out nocopy JTF_NUMBER_TABLE
140: , a22 out nocopy JTF_DATE_TABLE
141: , a23 out nocopy JTF_VARCHAR2_TABLE_100
142: ) as

Line 139: , a21 out nocopy JTF_NUMBER_TABLE

135: , a17 out nocopy JTF_NUMBER_TABLE
136: , a18 out nocopy JTF_VARCHAR2_TABLE_100
137: , a19 out nocopy JTF_VARCHAR2_TABLE_100
138: , a20 out nocopy JTF_NUMBER_TABLE
139: , a21 out nocopy JTF_NUMBER_TABLE
140: , a22 out nocopy JTF_DATE_TABLE
141: , a23 out nocopy JTF_VARCHAR2_TABLE_100
142: ) as
143: ddindx binary_integer; indx binary_integer;

Line 146: a0 := JTF_NUMBER_TABLE();

142: ) as
143: ddindx binary_integer; indx binary_integer;
144: begin
145: if t is null or t.count = 0 then
146: a0 := JTF_NUMBER_TABLE();
147: a1 := JTF_VARCHAR2_TABLE_100();
148: a2 := JTF_VARCHAR2_TABLE_300();
149: a3 := JTF_VARCHAR2_TABLE_100();
150: a4 := JTF_VARCHAR2_TABLE_100();

Line 151: a5 := JTF_NUMBER_TABLE();

147: a1 := JTF_VARCHAR2_TABLE_100();
148: a2 := JTF_VARCHAR2_TABLE_300();
149: a3 := JTF_VARCHAR2_TABLE_100();
150: a4 := JTF_VARCHAR2_TABLE_100();
151: a5 := JTF_NUMBER_TABLE();
152: a6 := JTF_VARCHAR2_TABLE_100();
153: a7 := JTF_DATE_TABLE();
154: a8 := JTF_DATE_TABLE();
155: a9 := JTF_NUMBER_TABLE();

Line 155: a9 := JTF_NUMBER_TABLE();

151: a5 := JTF_NUMBER_TABLE();
152: a6 := JTF_VARCHAR2_TABLE_100();
153: a7 := JTF_DATE_TABLE();
154: a8 := JTF_DATE_TABLE();
155: a9 := JTF_NUMBER_TABLE();
156: a10 := JTF_VARCHAR2_TABLE_100();
157: a11 := JTF_VARCHAR2_TABLE_100();
158: a12 := JTF_NUMBER_TABLE();
159: a13 := JTF_NUMBER_TABLE();

Line 158: a12 := JTF_NUMBER_TABLE();

154: a8 := JTF_DATE_TABLE();
155: a9 := JTF_NUMBER_TABLE();
156: a10 := JTF_VARCHAR2_TABLE_100();
157: a11 := JTF_VARCHAR2_TABLE_100();
158: a12 := JTF_NUMBER_TABLE();
159: a13 := JTF_NUMBER_TABLE();
160: a14 := JTF_VARCHAR2_TABLE_100();
161: a15 := JTF_VARCHAR2_TABLE_100();
162: a16 := JTF_VARCHAR2_TABLE_100();

Line 159: a13 := JTF_NUMBER_TABLE();

155: a9 := JTF_NUMBER_TABLE();
156: a10 := JTF_VARCHAR2_TABLE_100();
157: a11 := JTF_VARCHAR2_TABLE_100();
158: a12 := JTF_NUMBER_TABLE();
159: a13 := JTF_NUMBER_TABLE();
160: a14 := JTF_VARCHAR2_TABLE_100();
161: a15 := JTF_VARCHAR2_TABLE_100();
162: a16 := JTF_VARCHAR2_TABLE_100();
163: a17 := JTF_NUMBER_TABLE();

Line 163: a17 := JTF_NUMBER_TABLE();

159: a13 := JTF_NUMBER_TABLE();
160: a14 := JTF_VARCHAR2_TABLE_100();
161: a15 := JTF_VARCHAR2_TABLE_100();
162: a16 := JTF_VARCHAR2_TABLE_100();
163: a17 := JTF_NUMBER_TABLE();
164: a18 := JTF_VARCHAR2_TABLE_100();
165: a19 := JTF_VARCHAR2_TABLE_100();
166: a20 := JTF_NUMBER_TABLE();
167: a21 := JTF_NUMBER_TABLE();

Line 166: a20 := JTF_NUMBER_TABLE();

162: a16 := JTF_VARCHAR2_TABLE_100();
163: a17 := JTF_NUMBER_TABLE();
164: a18 := JTF_VARCHAR2_TABLE_100();
165: a19 := JTF_VARCHAR2_TABLE_100();
166: a20 := JTF_NUMBER_TABLE();
167: a21 := JTF_NUMBER_TABLE();
168: a22 := JTF_DATE_TABLE();
169: a23 := JTF_VARCHAR2_TABLE_100();
170: else

Line 167: a21 := JTF_NUMBER_TABLE();

163: a17 := JTF_NUMBER_TABLE();
164: a18 := JTF_VARCHAR2_TABLE_100();
165: a19 := JTF_VARCHAR2_TABLE_100();
166: a20 := JTF_NUMBER_TABLE();
167: a21 := JTF_NUMBER_TABLE();
168: a22 := JTF_DATE_TABLE();
169: a23 := JTF_VARCHAR2_TABLE_100();
170: else
171: a0 := JTF_NUMBER_TABLE();

Line 171: a0 := JTF_NUMBER_TABLE();

167: a21 := JTF_NUMBER_TABLE();
168: a22 := JTF_DATE_TABLE();
169: a23 := JTF_VARCHAR2_TABLE_100();
170: else
171: a0 := JTF_NUMBER_TABLE();
172: a1 := JTF_VARCHAR2_TABLE_100();
173: a2 := JTF_VARCHAR2_TABLE_300();
174: a3 := JTF_VARCHAR2_TABLE_100();
175: a4 := JTF_VARCHAR2_TABLE_100();

Line 176: a5 := JTF_NUMBER_TABLE();

172: a1 := JTF_VARCHAR2_TABLE_100();
173: a2 := JTF_VARCHAR2_TABLE_300();
174: a3 := JTF_VARCHAR2_TABLE_100();
175: a4 := JTF_VARCHAR2_TABLE_100();
176: a5 := JTF_NUMBER_TABLE();
177: a6 := JTF_VARCHAR2_TABLE_100();
178: a7 := JTF_DATE_TABLE();
179: a8 := JTF_DATE_TABLE();
180: a9 := JTF_NUMBER_TABLE();

Line 180: a9 := JTF_NUMBER_TABLE();

176: a5 := JTF_NUMBER_TABLE();
177: a6 := JTF_VARCHAR2_TABLE_100();
178: a7 := JTF_DATE_TABLE();
179: a8 := JTF_DATE_TABLE();
180: a9 := JTF_NUMBER_TABLE();
181: a10 := JTF_VARCHAR2_TABLE_100();
182: a11 := JTF_VARCHAR2_TABLE_100();
183: a12 := JTF_NUMBER_TABLE();
184: a13 := JTF_NUMBER_TABLE();

Line 183: a12 := JTF_NUMBER_TABLE();

179: a8 := JTF_DATE_TABLE();
180: a9 := JTF_NUMBER_TABLE();
181: a10 := JTF_VARCHAR2_TABLE_100();
182: a11 := JTF_VARCHAR2_TABLE_100();
183: a12 := JTF_NUMBER_TABLE();
184: a13 := JTF_NUMBER_TABLE();
185: a14 := JTF_VARCHAR2_TABLE_100();
186: a15 := JTF_VARCHAR2_TABLE_100();
187: a16 := JTF_VARCHAR2_TABLE_100();

Line 184: a13 := JTF_NUMBER_TABLE();

180: a9 := JTF_NUMBER_TABLE();
181: a10 := JTF_VARCHAR2_TABLE_100();
182: a11 := JTF_VARCHAR2_TABLE_100();
183: a12 := JTF_NUMBER_TABLE();
184: a13 := JTF_NUMBER_TABLE();
185: a14 := JTF_VARCHAR2_TABLE_100();
186: a15 := JTF_VARCHAR2_TABLE_100();
187: a16 := JTF_VARCHAR2_TABLE_100();
188: a17 := JTF_NUMBER_TABLE();

Line 188: a17 := JTF_NUMBER_TABLE();

184: a13 := JTF_NUMBER_TABLE();
185: a14 := JTF_VARCHAR2_TABLE_100();
186: a15 := JTF_VARCHAR2_TABLE_100();
187: a16 := JTF_VARCHAR2_TABLE_100();
188: a17 := JTF_NUMBER_TABLE();
189: a18 := JTF_VARCHAR2_TABLE_100();
190: a19 := JTF_VARCHAR2_TABLE_100();
191: a20 := JTF_NUMBER_TABLE();
192: a21 := JTF_NUMBER_TABLE();

Line 191: a20 := JTF_NUMBER_TABLE();

187: a16 := JTF_VARCHAR2_TABLE_100();
188: a17 := JTF_NUMBER_TABLE();
189: a18 := JTF_VARCHAR2_TABLE_100();
190: a19 := JTF_VARCHAR2_TABLE_100();
191: a20 := JTF_NUMBER_TABLE();
192: a21 := JTF_NUMBER_TABLE();
193: a22 := JTF_DATE_TABLE();
194: a23 := JTF_VARCHAR2_TABLE_100();
195: if t.count > 0 then

Line 192: a21 := JTF_NUMBER_TABLE();

188: a17 := JTF_NUMBER_TABLE();
189: a18 := JTF_VARCHAR2_TABLE_100();
190: a19 := JTF_VARCHAR2_TABLE_100();
191: a20 := JTF_NUMBER_TABLE();
192: a21 := JTF_NUMBER_TABLE();
193: a22 := JTF_DATE_TABLE();
194: a23 := JTF_VARCHAR2_TABLE_100();
195: if t.count > 0 then
196: a0.extend(t.count);

Line 257: procedure rosetta_table_copy_in_p5(t out nocopy lns_fee_engine.fee_calc_tbl, a0 JTF_NUMBER_TABLE

253: end if;
254: end if;
255: end rosetta_table_copy_out_p3;
256:
257: procedure rosetta_table_copy_in_p5(t out nocopy lns_fee_engine.fee_calc_tbl, a0 JTF_NUMBER_TABLE
258: , a1 JTF_VARCHAR2_TABLE_100
259: , a2 JTF_VARCHAR2_TABLE_100
260: , a3 JTF_VARCHAR2_TABLE_100
261: , a4 JTF_NUMBER_TABLE

Line 261: , a4 JTF_NUMBER_TABLE

257: procedure rosetta_table_copy_in_p5(t out nocopy lns_fee_engine.fee_calc_tbl, a0 JTF_NUMBER_TABLE
258: , a1 JTF_VARCHAR2_TABLE_100
259: , a2 JTF_VARCHAR2_TABLE_100
260: , a3 JTF_VARCHAR2_TABLE_100
261: , a4 JTF_NUMBER_TABLE
262: , a5 JTF_NUMBER_TABLE
263: , a6 JTF_VARCHAR2_TABLE_300
264: , a7 JTF_NUMBER_TABLE
265: , a8 JTF_VARCHAR2_TABLE_100

Line 262: , a5 JTF_NUMBER_TABLE

258: , a1 JTF_VARCHAR2_TABLE_100
259: , a2 JTF_VARCHAR2_TABLE_100
260: , a3 JTF_VARCHAR2_TABLE_100
261: , a4 JTF_NUMBER_TABLE
262: , a5 JTF_NUMBER_TABLE
263: , a6 JTF_VARCHAR2_TABLE_300
264: , a7 JTF_NUMBER_TABLE
265: , a8 JTF_VARCHAR2_TABLE_100
266: , a9 JTF_VARCHAR2_TABLE_100

Line 264: , a7 JTF_NUMBER_TABLE

260: , a3 JTF_VARCHAR2_TABLE_100
261: , a4 JTF_NUMBER_TABLE
262: , a5 JTF_NUMBER_TABLE
263: , a6 JTF_VARCHAR2_TABLE_300
264: , a7 JTF_NUMBER_TABLE
265: , a8 JTF_VARCHAR2_TABLE_100
266: , a9 JTF_VARCHAR2_TABLE_100
267: , a10 JTF_VARCHAR2_TABLE_100
268: , a11 JTF_NUMBER_TABLE

Line 268: , a11 JTF_NUMBER_TABLE

264: , a7 JTF_NUMBER_TABLE
265: , a8 JTF_VARCHAR2_TABLE_100
266: , a9 JTF_VARCHAR2_TABLE_100
267: , a10 JTF_VARCHAR2_TABLE_100
268: , a11 JTF_NUMBER_TABLE
269: , a12 JTF_VARCHAR2_TABLE_100
270: , a13 JTF_VARCHAR2_TABLE_100
271: , a14 JTF_NUMBER_TABLE
272: , a15 JTF_VARCHAR2_TABLE_100

Line 271: , a14 JTF_NUMBER_TABLE

267: , a10 JTF_VARCHAR2_TABLE_100
268: , a11 JTF_NUMBER_TABLE
269: , a12 JTF_VARCHAR2_TABLE_100
270: , a13 JTF_VARCHAR2_TABLE_100
271: , a14 JTF_NUMBER_TABLE
272: , a15 JTF_VARCHAR2_TABLE_100
273: , a16 JTF_VARCHAR2_TABLE_100
274: ) as
275: ddindx binary_integer; indx binary_integer;

Line 308: procedure rosetta_table_copy_out_p5(t lns_fee_engine.fee_calc_tbl, a0 out nocopy JTF_NUMBER_TABLE

304: end loop;
305: end if;
306: end if;
307: end rosetta_table_copy_in_p5;
308: procedure rosetta_table_copy_out_p5(t lns_fee_engine.fee_calc_tbl, a0 out nocopy JTF_NUMBER_TABLE
309: , a1 out nocopy JTF_VARCHAR2_TABLE_100
310: , a2 out nocopy JTF_VARCHAR2_TABLE_100
311: , a3 out nocopy JTF_VARCHAR2_TABLE_100
312: , a4 out nocopy JTF_NUMBER_TABLE

Line 312: , a4 out nocopy JTF_NUMBER_TABLE

308: procedure rosetta_table_copy_out_p5(t lns_fee_engine.fee_calc_tbl, a0 out nocopy JTF_NUMBER_TABLE
309: , a1 out nocopy JTF_VARCHAR2_TABLE_100
310: , a2 out nocopy JTF_VARCHAR2_TABLE_100
311: , a3 out nocopy JTF_VARCHAR2_TABLE_100
312: , a4 out nocopy JTF_NUMBER_TABLE
313: , a5 out nocopy JTF_NUMBER_TABLE
314: , a6 out nocopy JTF_VARCHAR2_TABLE_300
315: , a7 out nocopy JTF_NUMBER_TABLE
316: , a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 313: , a5 out nocopy JTF_NUMBER_TABLE

309: , a1 out nocopy JTF_VARCHAR2_TABLE_100
310: , a2 out nocopy JTF_VARCHAR2_TABLE_100
311: , a3 out nocopy JTF_VARCHAR2_TABLE_100
312: , a4 out nocopy JTF_NUMBER_TABLE
313: , a5 out nocopy JTF_NUMBER_TABLE
314: , a6 out nocopy JTF_VARCHAR2_TABLE_300
315: , a7 out nocopy JTF_NUMBER_TABLE
316: , a8 out nocopy JTF_VARCHAR2_TABLE_100
317: , a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 315: , a7 out nocopy JTF_NUMBER_TABLE

311: , a3 out nocopy JTF_VARCHAR2_TABLE_100
312: , a4 out nocopy JTF_NUMBER_TABLE
313: , a5 out nocopy JTF_NUMBER_TABLE
314: , a6 out nocopy JTF_VARCHAR2_TABLE_300
315: , a7 out nocopy JTF_NUMBER_TABLE
316: , a8 out nocopy JTF_VARCHAR2_TABLE_100
317: , a9 out nocopy JTF_VARCHAR2_TABLE_100
318: , a10 out nocopy JTF_VARCHAR2_TABLE_100
319: , a11 out nocopy JTF_NUMBER_TABLE

Line 319: , a11 out nocopy JTF_NUMBER_TABLE

315: , a7 out nocopy JTF_NUMBER_TABLE
316: , a8 out nocopy JTF_VARCHAR2_TABLE_100
317: , a9 out nocopy JTF_VARCHAR2_TABLE_100
318: , a10 out nocopy JTF_VARCHAR2_TABLE_100
319: , a11 out nocopy JTF_NUMBER_TABLE
320: , a12 out nocopy JTF_VARCHAR2_TABLE_100
321: , a13 out nocopy JTF_VARCHAR2_TABLE_100
322: , a14 out nocopy JTF_NUMBER_TABLE
323: , a15 out nocopy JTF_VARCHAR2_TABLE_100

Line 322: , a14 out nocopy JTF_NUMBER_TABLE

318: , a10 out nocopy JTF_VARCHAR2_TABLE_100
319: , a11 out nocopy JTF_NUMBER_TABLE
320: , a12 out nocopy JTF_VARCHAR2_TABLE_100
321: , a13 out nocopy JTF_VARCHAR2_TABLE_100
322: , a14 out nocopy JTF_NUMBER_TABLE
323: , a15 out nocopy JTF_VARCHAR2_TABLE_100
324: , a16 out nocopy JTF_VARCHAR2_TABLE_100
325: ) as
326: ddindx binary_integer; indx binary_integer;

Line 329: a0 := JTF_NUMBER_TABLE();

325: ) as
326: ddindx binary_integer; indx binary_integer;
327: begin
328: if t is null or t.count = 0 then
329: a0 := JTF_NUMBER_TABLE();
330: a1 := JTF_VARCHAR2_TABLE_100();
331: a2 := JTF_VARCHAR2_TABLE_100();
332: a3 := JTF_VARCHAR2_TABLE_100();
333: a4 := JTF_NUMBER_TABLE();

Line 333: a4 := JTF_NUMBER_TABLE();

329: a0 := JTF_NUMBER_TABLE();
330: a1 := JTF_VARCHAR2_TABLE_100();
331: a2 := JTF_VARCHAR2_TABLE_100();
332: a3 := JTF_VARCHAR2_TABLE_100();
333: a4 := JTF_NUMBER_TABLE();
334: a5 := JTF_NUMBER_TABLE();
335: a6 := JTF_VARCHAR2_TABLE_300();
336: a7 := JTF_NUMBER_TABLE();
337: a8 := JTF_VARCHAR2_TABLE_100();

Line 334: a5 := JTF_NUMBER_TABLE();

330: a1 := JTF_VARCHAR2_TABLE_100();
331: a2 := JTF_VARCHAR2_TABLE_100();
332: a3 := JTF_VARCHAR2_TABLE_100();
333: a4 := JTF_NUMBER_TABLE();
334: a5 := JTF_NUMBER_TABLE();
335: a6 := JTF_VARCHAR2_TABLE_300();
336: a7 := JTF_NUMBER_TABLE();
337: a8 := JTF_VARCHAR2_TABLE_100();
338: a9 := JTF_VARCHAR2_TABLE_100();

Line 336: a7 := JTF_NUMBER_TABLE();

332: a3 := JTF_VARCHAR2_TABLE_100();
333: a4 := JTF_NUMBER_TABLE();
334: a5 := JTF_NUMBER_TABLE();
335: a6 := JTF_VARCHAR2_TABLE_300();
336: a7 := JTF_NUMBER_TABLE();
337: a8 := JTF_VARCHAR2_TABLE_100();
338: a9 := JTF_VARCHAR2_TABLE_100();
339: a10 := JTF_VARCHAR2_TABLE_100();
340: a11 := JTF_NUMBER_TABLE();

Line 340: a11 := JTF_NUMBER_TABLE();

336: a7 := JTF_NUMBER_TABLE();
337: a8 := JTF_VARCHAR2_TABLE_100();
338: a9 := JTF_VARCHAR2_TABLE_100();
339: a10 := JTF_VARCHAR2_TABLE_100();
340: a11 := JTF_NUMBER_TABLE();
341: a12 := JTF_VARCHAR2_TABLE_100();
342: a13 := JTF_VARCHAR2_TABLE_100();
343: a14 := JTF_NUMBER_TABLE();
344: a15 := JTF_VARCHAR2_TABLE_100();

Line 343: a14 := JTF_NUMBER_TABLE();

339: a10 := JTF_VARCHAR2_TABLE_100();
340: a11 := JTF_NUMBER_TABLE();
341: a12 := JTF_VARCHAR2_TABLE_100();
342: a13 := JTF_VARCHAR2_TABLE_100();
343: a14 := JTF_NUMBER_TABLE();
344: a15 := JTF_VARCHAR2_TABLE_100();
345: a16 := JTF_VARCHAR2_TABLE_100();
346: else
347: a0 := JTF_NUMBER_TABLE();

Line 347: a0 := JTF_NUMBER_TABLE();

343: a14 := JTF_NUMBER_TABLE();
344: a15 := JTF_VARCHAR2_TABLE_100();
345: a16 := JTF_VARCHAR2_TABLE_100();
346: else
347: a0 := JTF_NUMBER_TABLE();
348: a1 := JTF_VARCHAR2_TABLE_100();
349: a2 := JTF_VARCHAR2_TABLE_100();
350: a3 := JTF_VARCHAR2_TABLE_100();
351: a4 := JTF_NUMBER_TABLE();

Line 351: a4 := JTF_NUMBER_TABLE();

347: a0 := JTF_NUMBER_TABLE();
348: a1 := JTF_VARCHAR2_TABLE_100();
349: a2 := JTF_VARCHAR2_TABLE_100();
350: a3 := JTF_VARCHAR2_TABLE_100();
351: a4 := JTF_NUMBER_TABLE();
352: a5 := JTF_NUMBER_TABLE();
353: a6 := JTF_VARCHAR2_TABLE_300();
354: a7 := JTF_NUMBER_TABLE();
355: a8 := JTF_VARCHAR2_TABLE_100();

Line 352: a5 := JTF_NUMBER_TABLE();

348: a1 := JTF_VARCHAR2_TABLE_100();
349: a2 := JTF_VARCHAR2_TABLE_100();
350: a3 := JTF_VARCHAR2_TABLE_100();
351: a4 := JTF_NUMBER_TABLE();
352: a5 := JTF_NUMBER_TABLE();
353: a6 := JTF_VARCHAR2_TABLE_300();
354: a7 := JTF_NUMBER_TABLE();
355: a8 := JTF_VARCHAR2_TABLE_100();
356: a9 := JTF_VARCHAR2_TABLE_100();

Line 354: a7 := JTF_NUMBER_TABLE();

350: a3 := JTF_VARCHAR2_TABLE_100();
351: a4 := JTF_NUMBER_TABLE();
352: a5 := JTF_NUMBER_TABLE();
353: a6 := JTF_VARCHAR2_TABLE_300();
354: a7 := JTF_NUMBER_TABLE();
355: a8 := JTF_VARCHAR2_TABLE_100();
356: a9 := JTF_VARCHAR2_TABLE_100();
357: a10 := JTF_VARCHAR2_TABLE_100();
358: a11 := JTF_NUMBER_TABLE();

Line 358: a11 := JTF_NUMBER_TABLE();

354: a7 := JTF_NUMBER_TABLE();
355: a8 := JTF_VARCHAR2_TABLE_100();
356: a9 := JTF_VARCHAR2_TABLE_100();
357: a10 := JTF_VARCHAR2_TABLE_100();
358: a11 := JTF_NUMBER_TABLE();
359: a12 := JTF_VARCHAR2_TABLE_100();
360: a13 := JTF_VARCHAR2_TABLE_100();
361: a14 := JTF_NUMBER_TABLE();
362: a15 := JTF_VARCHAR2_TABLE_100();

Line 361: a14 := JTF_NUMBER_TABLE();

357: a10 := JTF_VARCHAR2_TABLE_100();
358: a11 := JTF_NUMBER_TABLE();
359: a12 := JTF_VARCHAR2_TABLE_100();
360: a13 := JTF_VARCHAR2_TABLE_100();
361: a14 := JTF_NUMBER_TABLE();
362: a15 := JTF_VARCHAR2_TABLE_100();
363: a16 := JTF_VARCHAR2_TABLE_100();
364: if t.count > 0 then
365: a0.extend(t.count);

Line 414: , p1_a1 JTF_NUMBER_TABLE

410: end rosetta_table_copy_out_p5;
411:
412: procedure calculatefees(p_loan_id NUMBER
413: , p1_a0 JTF_VARCHAR2_TABLE_100
414: , p1_a1 JTF_NUMBER_TABLE
415: , p_installment NUMBER
416: , p3_a0 JTF_NUMBER_TABLE
417: , p3_a1 JTF_VARCHAR2_TABLE_100
418: , p3_a2 JTF_VARCHAR2_TABLE_300

Line 416: , p3_a0 JTF_NUMBER_TABLE

412: procedure calculatefees(p_loan_id NUMBER
413: , p1_a0 JTF_VARCHAR2_TABLE_100
414: , p1_a1 JTF_NUMBER_TABLE
415: , p_installment NUMBER
416: , p3_a0 JTF_NUMBER_TABLE
417: , p3_a1 JTF_VARCHAR2_TABLE_100
418: , p3_a2 JTF_VARCHAR2_TABLE_300
419: , p3_a3 JTF_VARCHAR2_TABLE_100
420: , p3_a4 JTF_VARCHAR2_TABLE_100

Line 421: , p3_a5 JTF_NUMBER_TABLE

417: , p3_a1 JTF_VARCHAR2_TABLE_100
418: , p3_a2 JTF_VARCHAR2_TABLE_300
419: , p3_a3 JTF_VARCHAR2_TABLE_100
420: , p3_a4 JTF_VARCHAR2_TABLE_100
421: , p3_a5 JTF_NUMBER_TABLE
422: , p3_a6 JTF_VARCHAR2_TABLE_100
423: , p3_a7 JTF_DATE_TABLE
424: , p3_a8 JTF_DATE_TABLE
425: , p3_a9 JTF_NUMBER_TABLE

Line 425: , p3_a9 JTF_NUMBER_TABLE

421: , p3_a5 JTF_NUMBER_TABLE
422: , p3_a6 JTF_VARCHAR2_TABLE_100
423: , p3_a7 JTF_DATE_TABLE
424: , p3_a8 JTF_DATE_TABLE
425: , p3_a9 JTF_NUMBER_TABLE
426: , p3_a10 JTF_VARCHAR2_TABLE_100
427: , p3_a11 JTF_VARCHAR2_TABLE_100
428: , p3_a12 JTF_NUMBER_TABLE
429: , p3_a13 JTF_NUMBER_TABLE

Line 428: , p3_a12 JTF_NUMBER_TABLE

424: , p3_a8 JTF_DATE_TABLE
425: , p3_a9 JTF_NUMBER_TABLE
426: , p3_a10 JTF_VARCHAR2_TABLE_100
427: , p3_a11 JTF_VARCHAR2_TABLE_100
428: , p3_a12 JTF_NUMBER_TABLE
429: , p3_a13 JTF_NUMBER_TABLE
430: , p3_a14 JTF_VARCHAR2_TABLE_100
431: , p3_a15 JTF_VARCHAR2_TABLE_100
432: , p3_a16 JTF_VARCHAR2_TABLE_100

Line 429: , p3_a13 JTF_NUMBER_TABLE

425: , p3_a9 JTF_NUMBER_TABLE
426: , p3_a10 JTF_VARCHAR2_TABLE_100
427: , p3_a11 JTF_VARCHAR2_TABLE_100
428: , p3_a12 JTF_NUMBER_TABLE
429: , p3_a13 JTF_NUMBER_TABLE
430: , p3_a14 JTF_VARCHAR2_TABLE_100
431: , p3_a15 JTF_VARCHAR2_TABLE_100
432: , p3_a16 JTF_VARCHAR2_TABLE_100
433: , p3_a17 JTF_NUMBER_TABLE

Line 433: , p3_a17 JTF_NUMBER_TABLE

429: , p3_a13 JTF_NUMBER_TABLE
430: , p3_a14 JTF_VARCHAR2_TABLE_100
431: , p3_a15 JTF_VARCHAR2_TABLE_100
432: , p3_a16 JTF_VARCHAR2_TABLE_100
433: , p3_a17 JTF_NUMBER_TABLE
434: , p3_a18 JTF_VARCHAR2_TABLE_100
435: , p3_a19 JTF_VARCHAR2_TABLE_100
436: , p3_a20 JTF_NUMBER_TABLE
437: , p3_a21 JTF_NUMBER_TABLE

Line 436: , p3_a20 JTF_NUMBER_TABLE

432: , p3_a16 JTF_VARCHAR2_TABLE_100
433: , p3_a17 JTF_NUMBER_TABLE
434: , p3_a18 JTF_VARCHAR2_TABLE_100
435: , p3_a19 JTF_VARCHAR2_TABLE_100
436: , p3_a20 JTF_NUMBER_TABLE
437: , p3_a21 JTF_NUMBER_TABLE
438: , p3_a22 JTF_DATE_TABLE
439: , p3_a23 JTF_VARCHAR2_TABLE_100
440: , p4_a0 out nocopy JTF_NUMBER_TABLE

Line 437: , p3_a21 JTF_NUMBER_TABLE

433: , p3_a17 JTF_NUMBER_TABLE
434: , p3_a18 JTF_VARCHAR2_TABLE_100
435: , p3_a19 JTF_VARCHAR2_TABLE_100
436: , p3_a20 JTF_NUMBER_TABLE
437: , p3_a21 JTF_NUMBER_TABLE
438: , p3_a22 JTF_DATE_TABLE
439: , p3_a23 JTF_VARCHAR2_TABLE_100
440: , p4_a0 out nocopy JTF_NUMBER_TABLE
441: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 440: , p4_a0 out nocopy JTF_NUMBER_TABLE

436: , p3_a20 JTF_NUMBER_TABLE
437: , p3_a21 JTF_NUMBER_TABLE
438: , p3_a22 JTF_DATE_TABLE
439: , p3_a23 JTF_VARCHAR2_TABLE_100
440: , p4_a0 out nocopy JTF_NUMBER_TABLE
441: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
442: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
443: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
444: , p4_a4 out nocopy JTF_NUMBER_TABLE

Line 444: , p4_a4 out nocopy JTF_NUMBER_TABLE

440: , p4_a0 out nocopy JTF_NUMBER_TABLE
441: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
442: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
443: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
444: , p4_a4 out nocopy JTF_NUMBER_TABLE
445: , p4_a5 out nocopy JTF_NUMBER_TABLE
446: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_300
447: , p4_a7 out nocopy JTF_NUMBER_TABLE
448: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 445: , p4_a5 out nocopy JTF_NUMBER_TABLE

441: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
442: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
443: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
444: , p4_a4 out nocopy JTF_NUMBER_TABLE
445: , p4_a5 out nocopy JTF_NUMBER_TABLE
446: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_300
447: , p4_a7 out nocopy JTF_NUMBER_TABLE
448: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
449: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 447: , p4_a7 out nocopy JTF_NUMBER_TABLE

443: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
444: , p4_a4 out nocopy JTF_NUMBER_TABLE
445: , p4_a5 out nocopy JTF_NUMBER_TABLE
446: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_300
447: , p4_a7 out nocopy JTF_NUMBER_TABLE
448: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
449: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
450: , p4_a10 out nocopy JTF_VARCHAR2_TABLE_100
451: , p4_a11 out nocopy JTF_NUMBER_TABLE

Line 451: , p4_a11 out nocopy JTF_NUMBER_TABLE

447: , p4_a7 out nocopy JTF_NUMBER_TABLE
448: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
449: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
450: , p4_a10 out nocopy JTF_VARCHAR2_TABLE_100
451: , p4_a11 out nocopy JTF_NUMBER_TABLE
452: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
453: , p4_a13 out nocopy JTF_VARCHAR2_TABLE_100
454: , p4_a14 out nocopy JTF_NUMBER_TABLE
455: , p4_a15 out nocopy JTF_VARCHAR2_TABLE_100

Line 454: , p4_a14 out nocopy JTF_NUMBER_TABLE

450: , p4_a10 out nocopy JTF_VARCHAR2_TABLE_100
451: , p4_a11 out nocopy JTF_NUMBER_TABLE
452: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
453: , p4_a13 out nocopy JTF_VARCHAR2_TABLE_100
454: , p4_a14 out nocopy JTF_NUMBER_TABLE
455: , p4_a15 out nocopy JTF_VARCHAR2_TABLE_100
456: , p4_a16 out nocopy JTF_VARCHAR2_TABLE_100
457: , x_return_status out nocopy VARCHAR2
458: , x_msg_count out nocopy NUMBER

Line 547: , p3_a0 in out nocopy JTF_NUMBER_TABLE

543:
544: procedure writefeeschedule(p_init_msg_list VARCHAR2
545: , p_commit VARCHAR2
546: , p_loan_id NUMBER
547: , p3_a0 in out nocopy JTF_NUMBER_TABLE
548: , p3_a1 in out nocopy JTF_VARCHAR2_TABLE_100
549: , p3_a2 in out nocopy JTF_VARCHAR2_TABLE_100
550: , p3_a3 in out nocopy JTF_VARCHAR2_TABLE_100
551: , p3_a4 in out nocopy JTF_NUMBER_TABLE

Line 551: , p3_a4 in out nocopy JTF_NUMBER_TABLE

547: , p3_a0 in out nocopy JTF_NUMBER_TABLE
548: , p3_a1 in out nocopy JTF_VARCHAR2_TABLE_100
549: , p3_a2 in out nocopy JTF_VARCHAR2_TABLE_100
550: , p3_a3 in out nocopy JTF_VARCHAR2_TABLE_100
551: , p3_a4 in out nocopy JTF_NUMBER_TABLE
552: , p3_a5 in out nocopy JTF_NUMBER_TABLE
553: , p3_a6 in out nocopy JTF_VARCHAR2_TABLE_300
554: , p3_a7 in out nocopy JTF_NUMBER_TABLE
555: , p3_a8 in out nocopy JTF_VARCHAR2_TABLE_100

Line 552: , p3_a5 in out nocopy JTF_NUMBER_TABLE

548: , p3_a1 in out nocopy JTF_VARCHAR2_TABLE_100
549: , p3_a2 in out nocopy JTF_VARCHAR2_TABLE_100
550: , p3_a3 in out nocopy JTF_VARCHAR2_TABLE_100
551: , p3_a4 in out nocopy JTF_NUMBER_TABLE
552: , p3_a5 in out nocopy JTF_NUMBER_TABLE
553: , p3_a6 in out nocopy JTF_VARCHAR2_TABLE_300
554: , p3_a7 in out nocopy JTF_NUMBER_TABLE
555: , p3_a8 in out nocopy JTF_VARCHAR2_TABLE_100
556: , p3_a9 in out nocopy JTF_VARCHAR2_TABLE_100

Line 554: , p3_a7 in out nocopy JTF_NUMBER_TABLE

550: , p3_a3 in out nocopy JTF_VARCHAR2_TABLE_100
551: , p3_a4 in out nocopy JTF_NUMBER_TABLE
552: , p3_a5 in out nocopy JTF_NUMBER_TABLE
553: , p3_a6 in out nocopy JTF_VARCHAR2_TABLE_300
554: , p3_a7 in out nocopy JTF_NUMBER_TABLE
555: , p3_a8 in out nocopy JTF_VARCHAR2_TABLE_100
556: , p3_a9 in out nocopy JTF_VARCHAR2_TABLE_100
557: , p3_a10 in out nocopy JTF_VARCHAR2_TABLE_100
558: , p3_a11 in out nocopy JTF_NUMBER_TABLE

Line 558: , p3_a11 in out nocopy JTF_NUMBER_TABLE

554: , p3_a7 in out nocopy JTF_NUMBER_TABLE
555: , p3_a8 in out nocopy JTF_VARCHAR2_TABLE_100
556: , p3_a9 in out nocopy JTF_VARCHAR2_TABLE_100
557: , p3_a10 in out nocopy JTF_VARCHAR2_TABLE_100
558: , p3_a11 in out nocopy JTF_NUMBER_TABLE
559: , p3_a12 in out nocopy JTF_VARCHAR2_TABLE_100
560: , p3_a13 in out nocopy JTF_VARCHAR2_TABLE_100
561: , p3_a14 in out nocopy JTF_NUMBER_TABLE
562: , p3_a15 in out nocopy JTF_VARCHAR2_TABLE_100

Line 561: , p3_a14 in out nocopy JTF_NUMBER_TABLE

557: , p3_a10 in out nocopy JTF_VARCHAR2_TABLE_100
558: , p3_a11 in out nocopy JTF_NUMBER_TABLE
559: , p3_a12 in out nocopy JTF_VARCHAR2_TABLE_100
560: , p3_a13 in out nocopy JTF_VARCHAR2_TABLE_100
561: , p3_a14 in out nocopy JTF_NUMBER_TABLE
562: , p3_a15 in out nocopy JTF_VARCHAR2_TABLE_100
563: , p3_a16 in out nocopy JTF_VARCHAR2_TABLE_100
564: , x_return_status out nocopy VARCHAR2
565: , x_msg_count out nocopy NUMBER

Line 639: , p3_a0 JTF_NUMBER_TABLE

635:
636: procedure updatefeeschedule(p_init_msg_list VARCHAR2
637: , p_commit VARCHAR2
638: , p_loan_id NUMBER
639: , p3_a0 JTF_NUMBER_TABLE
640: , p3_a1 JTF_VARCHAR2_TABLE_100
641: , p3_a2 JTF_VARCHAR2_TABLE_100
642: , p3_a3 JTF_VARCHAR2_TABLE_100
643: , p3_a4 JTF_NUMBER_TABLE

Line 643: , p3_a4 JTF_NUMBER_TABLE

639: , p3_a0 JTF_NUMBER_TABLE
640: , p3_a1 JTF_VARCHAR2_TABLE_100
641: , p3_a2 JTF_VARCHAR2_TABLE_100
642: , p3_a3 JTF_VARCHAR2_TABLE_100
643: , p3_a4 JTF_NUMBER_TABLE
644: , p3_a5 JTF_NUMBER_TABLE
645: , p3_a6 JTF_VARCHAR2_TABLE_300
646: , p3_a7 JTF_NUMBER_TABLE
647: , p3_a8 JTF_VARCHAR2_TABLE_100

Line 644: , p3_a5 JTF_NUMBER_TABLE

640: , p3_a1 JTF_VARCHAR2_TABLE_100
641: , p3_a2 JTF_VARCHAR2_TABLE_100
642: , p3_a3 JTF_VARCHAR2_TABLE_100
643: , p3_a4 JTF_NUMBER_TABLE
644: , p3_a5 JTF_NUMBER_TABLE
645: , p3_a6 JTF_VARCHAR2_TABLE_300
646: , p3_a7 JTF_NUMBER_TABLE
647: , p3_a8 JTF_VARCHAR2_TABLE_100
648: , p3_a9 JTF_VARCHAR2_TABLE_100

Line 646: , p3_a7 JTF_NUMBER_TABLE

642: , p3_a3 JTF_VARCHAR2_TABLE_100
643: , p3_a4 JTF_NUMBER_TABLE
644: , p3_a5 JTF_NUMBER_TABLE
645: , p3_a6 JTF_VARCHAR2_TABLE_300
646: , p3_a7 JTF_NUMBER_TABLE
647: , p3_a8 JTF_VARCHAR2_TABLE_100
648: , p3_a9 JTF_VARCHAR2_TABLE_100
649: , p3_a10 JTF_VARCHAR2_TABLE_100
650: , p3_a11 JTF_NUMBER_TABLE

Line 650: , p3_a11 JTF_NUMBER_TABLE

646: , p3_a7 JTF_NUMBER_TABLE
647: , p3_a8 JTF_VARCHAR2_TABLE_100
648: , p3_a9 JTF_VARCHAR2_TABLE_100
649: , p3_a10 JTF_VARCHAR2_TABLE_100
650: , p3_a11 JTF_NUMBER_TABLE
651: , p3_a12 JTF_VARCHAR2_TABLE_100
652: , p3_a13 JTF_VARCHAR2_TABLE_100
653: , p3_a14 JTF_NUMBER_TABLE
654: , p3_a15 JTF_VARCHAR2_TABLE_100

Line 653: , p3_a14 JTF_NUMBER_TABLE

649: , p3_a10 JTF_VARCHAR2_TABLE_100
650: , p3_a11 JTF_NUMBER_TABLE
651: , p3_a12 JTF_VARCHAR2_TABLE_100
652: , p3_a13 JTF_VARCHAR2_TABLE_100
653: , p3_a14 JTF_NUMBER_TABLE
654: , p3_a15 JTF_VARCHAR2_TABLE_100
655: , p3_a16 JTF_VARCHAR2_TABLE_100
656: , x_return_status out nocopy VARCHAR2
657: , x_msg_count out nocopy NUMBER

Line 715: , p5_a0 out nocopy JTF_NUMBER_TABLE

711: , p_loan_id NUMBER
712: , p_installment_number NUMBER
713: , p_disb_header_id NUMBER
714: , p_phase VARCHAR2
715: , p5_a0 out nocopy JTF_NUMBER_TABLE
716: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_100
717: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
718: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
719: , p5_a4 out nocopy JTF_NUMBER_TABLE

Line 719: , p5_a4 out nocopy JTF_NUMBER_TABLE

715: , p5_a0 out nocopy JTF_NUMBER_TABLE
716: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_100
717: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
718: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
719: , p5_a4 out nocopy JTF_NUMBER_TABLE
720: , p5_a5 out nocopy JTF_NUMBER_TABLE
721: , p5_a6 out nocopy JTF_VARCHAR2_TABLE_300
722: , p5_a7 out nocopy JTF_NUMBER_TABLE
723: , p5_a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 720: , p5_a5 out nocopy JTF_NUMBER_TABLE

716: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_100
717: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
718: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
719: , p5_a4 out nocopy JTF_NUMBER_TABLE
720: , p5_a5 out nocopy JTF_NUMBER_TABLE
721: , p5_a6 out nocopy JTF_VARCHAR2_TABLE_300
722: , p5_a7 out nocopy JTF_NUMBER_TABLE
723: , p5_a8 out nocopy JTF_VARCHAR2_TABLE_100
724: , p5_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 722: , p5_a7 out nocopy JTF_NUMBER_TABLE

718: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
719: , p5_a4 out nocopy JTF_NUMBER_TABLE
720: , p5_a5 out nocopy JTF_NUMBER_TABLE
721: , p5_a6 out nocopy JTF_VARCHAR2_TABLE_300
722: , p5_a7 out nocopy JTF_NUMBER_TABLE
723: , p5_a8 out nocopy JTF_VARCHAR2_TABLE_100
724: , p5_a9 out nocopy JTF_VARCHAR2_TABLE_100
725: , p5_a10 out nocopy JTF_VARCHAR2_TABLE_100
726: , p5_a11 out nocopy JTF_NUMBER_TABLE

Line 726: , p5_a11 out nocopy JTF_NUMBER_TABLE

722: , p5_a7 out nocopy JTF_NUMBER_TABLE
723: , p5_a8 out nocopy JTF_VARCHAR2_TABLE_100
724: , p5_a9 out nocopy JTF_VARCHAR2_TABLE_100
725: , p5_a10 out nocopy JTF_VARCHAR2_TABLE_100
726: , p5_a11 out nocopy JTF_NUMBER_TABLE
727: , p5_a12 out nocopy JTF_VARCHAR2_TABLE_100
728: , p5_a13 out nocopy JTF_VARCHAR2_TABLE_100
729: , p5_a14 out nocopy JTF_NUMBER_TABLE
730: , p5_a15 out nocopy JTF_VARCHAR2_TABLE_100

Line 729: , p5_a14 out nocopy JTF_NUMBER_TABLE

725: , p5_a10 out nocopy JTF_VARCHAR2_TABLE_100
726: , p5_a11 out nocopy JTF_NUMBER_TABLE
727: , p5_a12 out nocopy JTF_VARCHAR2_TABLE_100
728: , p5_a13 out nocopy JTF_VARCHAR2_TABLE_100
729: , p5_a14 out nocopy JTF_NUMBER_TABLE
730: , p5_a15 out nocopy JTF_VARCHAR2_TABLE_100
731: , p5_a16 out nocopy JTF_VARCHAR2_TABLE_100
732: , x_return_status out nocopy VARCHAR2
733: , x_msg_count out nocopy NUMBER

Line 796: , p3_a1 JTF_NUMBER_TABLE

792: procedure getfeedetails(p_init_msg_list VARCHAR2
793: , p_loan_id NUMBER
794: , p_installment NUMBER
795: , p3_a0 JTF_VARCHAR2_TABLE_100
796: , p3_a1 JTF_NUMBER_TABLE
797: , p_based_on_terms VARCHAR2
798: , p_phase VARCHAR2
799: , p6_a0 out nocopy JTF_NUMBER_TABLE
800: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 799: , p6_a0 out nocopy JTF_NUMBER_TABLE

795: , p3_a0 JTF_VARCHAR2_TABLE_100
796: , p3_a1 JTF_NUMBER_TABLE
797: , p_based_on_terms VARCHAR2
798: , p_phase VARCHAR2
799: , p6_a0 out nocopy JTF_NUMBER_TABLE
800: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
801: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
802: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
803: , p6_a4 out nocopy JTF_NUMBER_TABLE

Line 803: , p6_a4 out nocopy JTF_NUMBER_TABLE

799: , p6_a0 out nocopy JTF_NUMBER_TABLE
800: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
801: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
802: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
803: , p6_a4 out nocopy JTF_NUMBER_TABLE
804: , p6_a5 out nocopy JTF_NUMBER_TABLE
805: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
806: , p6_a7 out nocopy JTF_NUMBER_TABLE
807: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 804: , p6_a5 out nocopy JTF_NUMBER_TABLE

800: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
801: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
802: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
803: , p6_a4 out nocopy JTF_NUMBER_TABLE
804: , p6_a5 out nocopy JTF_NUMBER_TABLE
805: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
806: , p6_a7 out nocopy JTF_NUMBER_TABLE
807: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
808: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 806: , p6_a7 out nocopy JTF_NUMBER_TABLE

802: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
803: , p6_a4 out nocopy JTF_NUMBER_TABLE
804: , p6_a5 out nocopy JTF_NUMBER_TABLE
805: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
806: , p6_a7 out nocopy JTF_NUMBER_TABLE
807: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
808: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
809: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
810: , p6_a11 out nocopy JTF_NUMBER_TABLE

Line 810: , p6_a11 out nocopy JTF_NUMBER_TABLE

806: , p6_a7 out nocopy JTF_NUMBER_TABLE
807: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
808: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
809: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
810: , p6_a11 out nocopy JTF_NUMBER_TABLE
811: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
812: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
813: , p6_a14 out nocopy JTF_NUMBER_TABLE
814: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100

Line 813: , p6_a14 out nocopy JTF_NUMBER_TABLE

809: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
810: , p6_a11 out nocopy JTF_NUMBER_TABLE
811: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
812: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
813: , p6_a14 out nocopy JTF_NUMBER_TABLE
814: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
815: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
816: , x_return_status out nocopy VARCHAR2
817: , x_msg_count out nocopy NUMBER

Line 888: , p4_a1 JTF_NUMBER_TABLE

884: , p_commit VARCHAR2
885: , p_loan_id NUMBER
886: , p_installment_number NUMBER
887: , p4_a0 JTF_VARCHAR2_TABLE_100
888: , p4_a1 JTF_NUMBER_TABLE
889: , p5_a0 JTF_NUMBER_TABLE
890: , p5_a1 JTF_VARCHAR2_TABLE_100
891: , p5_a2 JTF_VARCHAR2_TABLE_300
892: , p5_a3 JTF_VARCHAR2_TABLE_100

Line 889: , p5_a0 JTF_NUMBER_TABLE

885: , p_loan_id NUMBER
886: , p_installment_number NUMBER
887: , p4_a0 JTF_VARCHAR2_TABLE_100
888: , p4_a1 JTF_NUMBER_TABLE
889: , p5_a0 JTF_NUMBER_TABLE
890: , p5_a1 JTF_VARCHAR2_TABLE_100
891: , p5_a2 JTF_VARCHAR2_TABLE_300
892: , p5_a3 JTF_VARCHAR2_TABLE_100
893: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 894: , p5_a5 JTF_NUMBER_TABLE

890: , p5_a1 JTF_VARCHAR2_TABLE_100
891: , p5_a2 JTF_VARCHAR2_TABLE_300
892: , p5_a3 JTF_VARCHAR2_TABLE_100
893: , p5_a4 JTF_VARCHAR2_TABLE_100
894: , p5_a5 JTF_NUMBER_TABLE
895: , p5_a6 JTF_VARCHAR2_TABLE_100
896: , p5_a7 JTF_DATE_TABLE
897: , p5_a8 JTF_DATE_TABLE
898: , p5_a9 JTF_NUMBER_TABLE

Line 898: , p5_a9 JTF_NUMBER_TABLE

894: , p5_a5 JTF_NUMBER_TABLE
895: , p5_a6 JTF_VARCHAR2_TABLE_100
896: , p5_a7 JTF_DATE_TABLE
897: , p5_a8 JTF_DATE_TABLE
898: , p5_a9 JTF_NUMBER_TABLE
899: , p5_a10 JTF_VARCHAR2_TABLE_100
900: , p5_a11 JTF_VARCHAR2_TABLE_100
901: , p5_a12 JTF_NUMBER_TABLE
902: , p5_a13 JTF_NUMBER_TABLE

Line 901: , p5_a12 JTF_NUMBER_TABLE

897: , p5_a8 JTF_DATE_TABLE
898: , p5_a9 JTF_NUMBER_TABLE
899: , p5_a10 JTF_VARCHAR2_TABLE_100
900: , p5_a11 JTF_VARCHAR2_TABLE_100
901: , p5_a12 JTF_NUMBER_TABLE
902: , p5_a13 JTF_NUMBER_TABLE
903: , p5_a14 JTF_VARCHAR2_TABLE_100
904: , p5_a15 JTF_VARCHAR2_TABLE_100
905: , p5_a16 JTF_VARCHAR2_TABLE_100

Line 902: , p5_a13 JTF_NUMBER_TABLE

898: , p5_a9 JTF_NUMBER_TABLE
899: , p5_a10 JTF_VARCHAR2_TABLE_100
900: , p5_a11 JTF_VARCHAR2_TABLE_100
901: , p5_a12 JTF_NUMBER_TABLE
902: , p5_a13 JTF_NUMBER_TABLE
903: , p5_a14 JTF_VARCHAR2_TABLE_100
904: , p5_a15 JTF_VARCHAR2_TABLE_100
905: , p5_a16 JTF_VARCHAR2_TABLE_100
906: , p5_a17 JTF_NUMBER_TABLE

Line 906: , p5_a17 JTF_NUMBER_TABLE

902: , p5_a13 JTF_NUMBER_TABLE
903: , p5_a14 JTF_VARCHAR2_TABLE_100
904: , p5_a15 JTF_VARCHAR2_TABLE_100
905: , p5_a16 JTF_VARCHAR2_TABLE_100
906: , p5_a17 JTF_NUMBER_TABLE
907: , p5_a18 JTF_VARCHAR2_TABLE_100
908: , p5_a19 JTF_VARCHAR2_TABLE_100
909: , p5_a20 JTF_NUMBER_TABLE
910: , p5_a21 JTF_NUMBER_TABLE

Line 909: , p5_a20 JTF_NUMBER_TABLE

905: , p5_a16 JTF_VARCHAR2_TABLE_100
906: , p5_a17 JTF_NUMBER_TABLE
907: , p5_a18 JTF_VARCHAR2_TABLE_100
908: , p5_a19 JTF_VARCHAR2_TABLE_100
909: , p5_a20 JTF_NUMBER_TABLE
910: , p5_a21 JTF_NUMBER_TABLE
911: , p5_a22 JTF_DATE_TABLE
912: , p5_a23 JTF_VARCHAR2_TABLE_100
913: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 910: , p5_a21 JTF_NUMBER_TABLE

906: , p5_a17 JTF_NUMBER_TABLE
907: , p5_a18 JTF_VARCHAR2_TABLE_100
908: , p5_a19 JTF_VARCHAR2_TABLE_100
909: , p5_a20 JTF_NUMBER_TABLE
910: , p5_a21 JTF_NUMBER_TABLE
911: , p5_a22 JTF_DATE_TABLE
912: , p5_a23 JTF_VARCHAR2_TABLE_100
913: , p6_a0 out nocopy JTF_NUMBER_TABLE
914: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 913: , p6_a0 out nocopy JTF_NUMBER_TABLE

909: , p5_a20 JTF_NUMBER_TABLE
910: , p5_a21 JTF_NUMBER_TABLE
911: , p5_a22 JTF_DATE_TABLE
912: , p5_a23 JTF_VARCHAR2_TABLE_100
913: , p6_a0 out nocopy JTF_NUMBER_TABLE
914: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
915: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
916: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
917: , p6_a4 out nocopy JTF_NUMBER_TABLE

Line 917: , p6_a4 out nocopy JTF_NUMBER_TABLE

913: , p6_a0 out nocopy JTF_NUMBER_TABLE
914: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
915: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
916: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
917: , p6_a4 out nocopy JTF_NUMBER_TABLE
918: , p6_a5 out nocopy JTF_NUMBER_TABLE
919: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
920: , p6_a7 out nocopy JTF_NUMBER_TABLE
921: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 918: , p6_a5 out nocopy JTF_NUMBER_TABLE

914: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
915: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
916: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
917: , p6_a4 out nocopy JTF_NUMBER_TABLE
918: , p6_a5 out nocopy JTF_NUMBER_TABLE
919: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
920: , p6_a7 out nocopy JTF_NUMBER_TABLE
921: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
922: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 920: , p6_a7 out nocopy JTF_NUMBER_TABLE

916: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
917: , p6_a4 out nocopy JTF_NUMBER_TABLE
918: , p6_a5 out nocopy JTF_NUMBER_TABLE
919: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
920: , p6_a7 out nocopy JTF_NUMBER_TABLE
921: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
922: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
923: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
924: , p6_a11 out nocopy JTF_NUMBER_TABLE

Line 924: , p6_a11 out nocopy JTF_NUMBER_TABLE

920: , p6_a7 out nocopy JTF_NUMBER_TABLE
921: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
922: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
923: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
924: , p6_a11 out nocopy JTF_NUMBER_TABLE
925: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
926: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
927: , p6_a14 out nocopy JTF_NUMBER_TABLE
928: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100

Line 927: , p6_a14 out nocopy JTF_NUMBER_TABLE

923: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
924: , p6_a11 out nocopy JTF_NUMBER_TABLE
925: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
926: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
927: , p6_a14 out nocopy JTF_NUMBER_TABLE
928: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
929: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
930: , x_return_status out nocopy VARCHAR2
931: , x_msg_count out nocopy NUMBER

Line 1026: , p3_a0 out nocopy JTF_NUMBER_TABLE

1022:
1023: procedure getsubmitforapprfeeschedule(p_init_msg_list VARCHAR2
1024: , p_loan_id NUMBER
1025: , p_billed_flag VARCHAR2
1026: , p3_a0 out nocopy JTF_NUMBER_TABLE
1027: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
1028: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_100
1029: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100
1030: , p3_a4 out nocopy JTF_NUMBER_TABLE

Line 1030: , p3_a4 out nocopy JTF_NUMBER_TABLE

1026: , p3_a0 out nocopy JTF_NUMBER_TABLE
1027: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
1028: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_100
1029: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100
1030: , p3_a4 out nocopy JTF_NUMBER_TABLE
1031: , p3_a5 out nocopy JTF_NUMBER_TABLE
1032: , p3_a6 out nocopy JTF_VARCHAR2_TABLE_300
1033: , p3_a7 out nocopy JTF_NUMBER_TABLE
1034: , p3_a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 1031: , p3_a5 out nocopy JTF_NUMBER_TABLE

1027: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
1028: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_100
1029: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100
1030: , p3_a4 out nocopy JTF_NUMBER_TABLE
1031: , p3_a5 out nocopy JTF_NUMBER_TABLE
1032: , p3_a6 out nocopy JTF_VARCHAR2_TABLE_300
1033: , p3_a7 out nocopy JTF_NUMBER_TABLE
1034: , p3_a8 out nocopy JTF_VARCHAR2_TABLE_100
1035: , p3_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 1033: , p3_a7 out nocopy JTF_NUMBER_TABLE

1029: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100
1030: , p3_a4 out nocopy JTF_NUMBER_TABLE
1031: , p3_a5 out nocopy JTF_NUMBER_TABLE
1032: , p3_a6 out nocopy JTF_VARCHAR2_TABLE_300
1033: , p3_a7 out nocopy JTF_NUMBER_TABLE
1034: , p3_a8 out nocopy JTF_VARCHAR2_TABLE_100
1035: , p3_a9 out nocopy JTF_VARCHAR2_TABLE_100
1036: , p3_a10 out nocopy JTF_VARCHAR2_TABLE_100
1037: , p3_a11 out nocopy JTF_NUMBER_TABLE

Line 1037: , p3_a11 out nocopy JTF_NUMBER_TABLE

1033: , p3_a7 out nocopy JTF_NUMBER_TABLE
1034: , p3_a8 out nocopy JTF_VARCHAR2_TABLE_100
1035: , p3_a9 out nocopy JTF_VARCHAR2_TABLE_100
1036: , p3_a10 out nocopy JTF_VARCHAR2_TABLE_100
1037: , p3_a11 out nocopy JTF_NUMBER_TABLE
1038: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100
1039: , p3_a13 out nocopy JTF_VARCHAR2_TABLE_100
1040: , p3_a14 out nocopy JTF_NUMBER_TABLE
1041: , p3_a15 out nocopy JTF_VARCHAR2_TABLE_100

Line 1040: , p3_a14 out nocopy JTF_NUMBER_TABLE

1036: , p3_a10 out nocopy JTF_VARCHAR2_TABLE_100
1037: , p3_a11 out nocopy JTF_NUMBER_TABLE
1038: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100
1039: , p3_a13 out nocopy JTF_VARCHAR2_TABLE_100
1040: , p3_a14 out nocopy JTF_NUMBER_TABLE
1041: , p3_a15 out nocopy JTF_VARCHAR2_TABLE_100
1042: , p3_a16 out nocopy JTF_VARCHAR2_TABLE_100
1043: , x_return_status out nocopy VARCHAR2
1044: , x_msg_count out nocopy NUMBER