DBA Data[Home] [Help]

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 2005/08/02 14:38 raverma noship $ */
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: ) as
77: ddindx binary_integer; indx binary_integer;

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: ) as
77: ddindx binary_integer; indx binary_integer;
78: begin

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

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

Line 121: , a5 out nocopy JTF_NUMBER_TABLE

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

Line 125: , a9 out nocopy JTF_NUMBER_TABLE

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

Line 128: , a12 out nocopy JTF_NUMBER_TABLE

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

Line 129: , a13 out nocopy JTF_NUMBER_TABLE

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

Line 133: , a17 out nocopy JTF_NUMBER_TABLE

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

Line 136: , a20 out nocopy JTF_NUMBER_TABLE

132: , a16 out nocopy JTF_VARCHAR2_TABLE_100
133: , a17 out nocopy JTF_NUMBER_TABLE
134: , a18 out nocopy JTF_VARCHAR2_TABLE_100
135: , a19 out nocopy JTF_VARCHAR2_TABLE_100
136: , a20 out nocopy JTF_NUMBER_TABLE
137: , a21 out nocopy JTF_NUMBER_TABLE
138: , a22 out nocopy JTF_DATE_TABLE
139: ) as
140: ddindx binary_integer; indx binary_integer;

Line 137: , a21 out nocopy JTF_NUMBER_TABLE

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

Line 143: a0 := JTF_NUMBER_TABLE();

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

Line 148: a5 := JTF_NUMBER_TABLE();

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

Line 152: a9 := JTF_NUMBER_TABLE();

148: a5 := JTF_NUMBER_TABLE();
149: a6 := JTF_VARCHAR2_TABLE_100();
150: a7 := JTF_DATE_TABLE();
151: a8 := JTF_DATE_TABLE();
152: a9 := JTF_NUMBER_TABLE();
153: a10 := JTF_VARCHAR2_TABLE_100();
154: a11 := JTF_VARCHAR2_TABLE_100();
155: a12 := JTF_NUMBER_TABLE();
156: a13 := JTF_NUMBER_TABLE();

Line 155: a12 := JTF_NUMBER_TABLE();

151: a8 := JTF_DATE_TABLE();
152: a9 := JTF_NUMBER_TABLE();
153: a10 := JTF_VARCHAR2_TABLE_100();
154: a11 := JTF_VARCHAR2_TABLE_100();
155: a12 := JTF_NUMBER_TABLE();
156: a13 := JTF_NUMBER_TABLE();
157: a14 := JTF_VARCHAR2_TABLE_100();
158: a15 := JTF_VARCHAR2_TABLE_100();
159: a16 := JTF_VARCHAR2_TABLE_100();

Line 156: a13 := JTF_NUMBER_TABLE();

152: a9 := JTF_NUMBER_TABLE();
153: a10 := JTF_VARCHAR2_TABLE_100();
154: a11 := JTF_VARCHAR2_TABLE_100();
155: a12 := JTF_NUMBER_TABLE();
156: a13 := JTF_NUMBER_TABLE();
157: a14 := JTF_VARCHAR2_TABLE_100();
158: a15 := JTF_VARCHAR2_TABLE_100();
159: a16 := JTF_VARCHAR2_TABLE_100();
160: a17 := JTF_NUMBER_TABLE();

Line 160: a17 := JTF_NUMBER_TABLE();

156: a13 := JTF_NUMBER_TABLE();
157: a14 := JTF_VARCHAR2_TABLE_100();
158: a15 := JTF_VARCHAR2_TABLE_100();
159: a16 := JTF_VARCHAR2_TABLE_100();
160: a17 := JTF_NUMBER_TABLE();
161: a18 := JTF_VARCHAR2_TABLE_100();
162: a19 := JTF_VARCHAR2_TABLE_100();
163: a20 := JTF_NUMBER_TABLE();
164: a21 := JTF_NUMBER_TABLE();

Line 163: a20 := JTF_NUMBER_TABLE();

159: a16 := JTF_VARCHAR2_TABLE_100();
160: a17 := JTF_NUMBER_TABLE();
161: a18 := JTF_VARCHAR2_TABLE_100();
162: a19 := JTF_VARCHAR2_TABLE_100();
163: a20 := JTF_NUMBER_TABLE();
164: a21 := JTF_NUMBER_TABLE();
165: a22 := JTF_DATE_TABLE();
166: else
167: a0 := JTF_NUMBER_TABLE();

Line 164: a21 := JTF_NUMBER_TABLE();

160: a17 := JTF_NUMBER_TABLE();
161: a18 := JTF_VARCHAR2_TABLE_100();
162: a19 := JTF_VARCHAR2_TABLE_100();
163: a20 := JTF_NUMBER_TABLE();
164: a21 := JTF_NUMBER_TABLE();
165: a22 := JTF_DATE_TABLE();
166: else
167: a0 := JTF_NUMBER_TABLE();
168: a1 := JTF_VARCHAR2_TABLE_100();

Line 167: a0 := JTF_NUMBER_TABLE();

163: a20 := JTF_NUMBER_TABLE();
164: a21 := JTF_NUMBER_TABLE();
165: a22 := JTF_DATE_TABLE();
166: else
167: a0 := JTF_NUMBER_TABLE();
168: a1 := JTF_VARCHAR2_TABLE_100();
169: a2 := JTF_VARCHAR2_TABLE_300();
170: a3 := JTF_VARCHAR2_TABLE_100();
171: a4 := JTF_VARCHAR2_TABLE_100();

Line 172: a5 := JTF_NUMBER_TABLE();

168: a1 := JTF_VARCHAR2_TABLE_100();
169: a2 := JTF_VARCHAR2_TABLE_300();
170: a3 := JTF_VARCHAR2_TABLE_100();
171: a4 := JTF_VARCHAR2_TABLE_100();
172: a5 := JTF_NUMBER_TABLE();
173: a6 := JTF_VARCHAR2_TABLE_100();
174: a7 := JTF_DATE_TABLE();
175: a8 := JTF_DATE_TABLE();
176: a9 := JTF_NUMBER_TABLE();

Line 176: a9 := JTF_NUMBER_TABLE();

172: a5 := JTF_NUMBER_TABLE();
173: a6 := JTF_VARCHAR2_TABLE_100();
174: a7 := JTF_DATE_TABLE();
175: a8 := JTF_DATE_TABLE();
176: a9 := JTF_NUMBER_TABLE();
177: a10 := JTF_VARCHAR2_TABLE_100();
178: a11 := JTF_VARCHAR2_TABLE_100();
179: a12 := JTF_NUMBER_TABLE();
180: a13 := JTF_NUMBER_TABLE();

Line 179: a12 := JTF_NUMBER_TABLE();

175: a8 := JTF_DATE_TABLE();
176: a9 := JTF_NUMBER_TABLE();
177: a10 := JTF_VARCHAR2_TABLE_100();
178: a11 := JTF_VARCHAR2_TABLE_100();
179: a12 := JTF_NUMBER_TABLE();
180: a13 := JTF_NUMBER_TABLE();
181: a14 := JTF_VARCHAR2_TABLE_100();
182: a15 := JTF_VARCHAR2_TABLE_100();
183: a16 := JTF_VARCHAR2_TABLE_100();

Line 180: a13 := JTF_NUMBER_TABLE();

176: a9 := JTF_NUMBER_TABLE();
177: a10 := JTF_VARCHAR2_TABLE_100();
178: a11 := JTF_VARCHAR2_TABLE_100();
179: a12 := JTF_NUMBER_TABLE();
180: a13 := JTF_NUMBER_TABLE();
181: a14 := JTF_VARCHAR2_TABLE_100();
182: a15 := JTF_VARCHAR2_TABLE_100();
183: a16 := JTF_VARCHAR2_TABLE_100();
184: a17 := JTF_NUMBER_TABLE();

Line 184: a17 := JTF_NUMBER_TABLE();

180: a13 := JTF_NUMBER_TABLE();
181: a14 := JTF_VARCHAR2_TABLE_100();
182: a15 := JTF_VARCHAR2_TABLE_100();
183: a16 := JTF_VARCHAR2_TABLE_100();
184: a17 := JTF_NUMBER_TABLE();
185: a18 := JTF_VARCHAR2_TABLE_100();
186: a19 := JTF_VARCHAR2_TABLE_100();
187: a20 := JTF_NUMBER_TABLE();
188: a21 := JTF_NUMBER_TABLE();

Line 187: a20 := JTF_NUMBER_TABLE();

183: a16 := JTF_VARCHAR2_TABLE_100();
184: a17 := JTF_NUMBER_TABLE();
185: a18 := JTF_VARCHAR2_TABLE_100();
186: a19 := JTF_VARCHAR2_TABLE_100();
187: a20 := JTF_NUMBER_TABLE();
188: a21 := JTF_NUMBER_TABLE();
189: a22 := JTF_DATE_TABLE();
190: if t.count > 0 then
191: a0.extend(t.count);

Line 188: a21 := JTF_NUMBER_TABLE();

184: a17 := JTF_NUMBER_TABLE();
185: a18 := JTF_VARCHAR2_TABLE_100();
186: a19 := JTF_VARCHAR2_TABLE_100();
187: a20 := JTF_NUMBER_TABLE();
188: a21 := JTF_NUMBER_TABLE();
189: a22 := JTF_DATE_TABLE();
190: if t.count > 0 then
191: a0.extend(t.count);
192: a1.extend(t.count);

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

246: end if;
247: end if;
248: end rosetta_table_copy_out_p3;
249:
250: procedure rosetta_table_copy_in_p5(t out nocopy lns_fee_engine.fee_calc_tbl, a0 JTF_NUMBER_TABLE
251: , a1 JTF_VARCHAR2_TABLE_100
252: , a2 JTF_VARCHAR2_TABLE_100
253: , a3 JTF_VARCHAR2_TABLE_100
254: , a4 JTF_NUMBER_TABLE

Line 254: , a4 JTF_NUMBER_TABLE

250: procedure rosetta_table_copy_in_p5(t out nocopy lns_fee_engine.fee_calc_tbl, a0 JTF_NUMBER_TABLE
251: , a1 JTF_VARCHAR2_TABLE_100
252: , a2 JTF_VARCHAR2_TABLE_100
253: , a3 JTF_VARCHAR2_TABLE_100
254: , a4 JTF_NUMBER_TABLE
255: , a5 JTF_NUMBER_TABLE
256: , a6 JTF_VARCHAR2_TABLE_300
257: , a7 JTF_NUMBER_TABLE
258: , a8 JTF_VARCHAR2_TABLE_100

Line 255: , a5 JTF_NUMBER_TABLE

251: , a1 JTF_VARCHAR2_TABLE_100
252: , a2 JTF_VARCHAR2_TABLE_100
253: , a3 JTF_VARCHAR2_TABLE_100
254: , a4 JTF_NUMBER_TABLE
255: , a5 JTF_NUMBER_TABLE
256: , a6 JTF_VARCHAR2_TABLE_300
257: , a7 JTF_NUMBER_TABLE
258: , a8 JTF_VARCHAR2_TABLE_100
259: , a9 JTF_VARCHAR2_TABLE_100

Line 257: , a7 JTF_NUMBER_TABLE

253: , a3 JTF_VARCHAR2_TABLE_100
254: , a4 JTF_NUMBER_TABLE
255: , a5 JTF_NUMBER_TABLE
256: , a6 JTF_VARCHAR2_TABLE_300
257: , a7 JTF_NUMBER_TABLE
258: , a8 JTF_VARCHAR2_TABLE_100
259: , a9 JTF_VARCHAR2_TABLE_100
260: , a10 JTF_VARCHAR2_TABLE_100
261: , a11 JTF_NUMBER_TABLE

Line 261: , a11 JTF_NUMBER_TABLE

257: , a7 JTF_NUMBER_TABLE
258: , a8 JTF_VARCHAR2_TABLE_100
259: , a9 JTF_VARCHAR2_TABLE_100
260: , a10 JTF_VARCHAR2_TABLE_100
261: , a11 JTF_NUMBER_TABLE
262: , a12 JTF_VARCHAR2_TABLE_100
263: , a13 JTF_VARCHAR2_TABLE_100
264: , a14 JTF_NUMBER_TABLE
265: ) as

Line 264: , a14 JTF_NUMBER_TABLE

260: , a10 JTF_VARCHAR2_TABLE_100
261: , a11 JTF_NUMBER_TABLE
262: , a12 JTF_VARCHAR2_TABLE_100
263: , a13 JTF_VARCHAR2_TABLE_100
264: , a14 JTF_NUMBER_TABLE
265: ) as
266: ddindx binary_integer; indx binary_integer;
267: begin
268: if a0 is not null and a0.count > 0 then

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

293: end loop;
294: end if;
295: end if;
296: end rosetta_table_copy_in_p5;
297: procedure rosetta_table_copy_out_p5(t lns_fee_engine.fee_calc_tbl, a0 out nocopy JTF_NUMBER_TABLE
298: , a1 out nocopy JTF_VARCHAR2_TABLE_100
299: , a2 out nocopy JTF_VARCHAR2_TABLE_100
300: , a3 out nocopy JTF_VARCHAR2_TABLE_100
301: , a4 out nocopy JTF_NUMBER_TABLE

Line 301: , a4 out nocopy JTF_NUMBER_TABLE

297: procedure rosetta_table_copy_out_p5(t lns_fee_engine.fee_calc_tbl, a0 out nocopy JTF_NUMBER_TABLE
298: , a1 out nocopy JTF_VARCHAR2_TABLE_100
299: , a2 out nocopy JTF_VARCHAR2_TABLE_100
300: , a3 out nocopy JTF_VARCHAR2_TABLE_100
301: , a4 out nocopy JTF_NUMBER_TABLE
302: , a5 out nocopy JTF_NUMBER_TABLE
303: , a6 out nocopy JTF_VARCHAR2_TABLE_300
304: , a7 out nocopy JTF_NUMBER_TABLE
305: , a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 302: , a5 out nocopy JTF_NUMBER_TABLE

298: , a1 out nocopy JTF_VARCHAR2_TABLE_100
299: , a2 out nocopy JTF_VARCHAR2_TABLE_100
300: , a3 out nocopy JTF_VARCHAR2_TABLE_100
301: , a4 out nocopy JTF_NUMBER_TABLE
302: , a5 out nocopy JTF_NUMBER_TABLE
303: , a6 out nocopy JTF_VARCHAR2_TABLE_300
304: , a7 out nocopy JTF_NUMBER_TABLE
305: , a8 out nocopy JTF_VARCHAR2_TABLE_100
306: , a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 304: , a7 out nocopy JTF_NUMBER_TABLE

300: , a3 out nocopy JTF_VARCHAR2_TABLE_100
301: , a4 out nocopy JTF_NUMBER_TABLE
302: , a5 out nocopy JTF_NUMBER_TABLE
303: , a6 out nocopy JTF_VARCHAR2_TABLE_300
304: , a7 out nocopy JTF_NUMBER_TABLE
305: , a8 out nocopy JTF_VARCHAR2_TABLE_100
306: , a9 out nocopy JTF_VARCHAR2_TABLE_100
307: , a10 out nocopy JTF_VARCHAR2_TABLE_100
308: , a11 out nocopy JTF_NUMBER_TABLE

Line 308: , a11 out nocopy JTF_NUMBER_TABLE

304: , a7 out nocopy JTF_NUMBER_TABLE
305: , a8 out nocopy JTF_VARCHAR2_TABLE_100
306: , a9 out nocopy JTF_VARCHAR2_TABLE_100
307: , a10 out nocopy JTF_VARCHAR2_TABLE_100
308: , a11 out nocopy JTF_NUMBER_TABLE
309: , a12 out nocopy JTF_VARCHAR2_TABLE_100
310: , a13 out nocopy JTF_VARCHAR2_TABLE_100
311: , a14 out nocopy JTF_NUMBER_TABLE
312: ) as

Line 311: , a14 out nocopy JTF_NUMBER_TABLE

307: , a10 out nocopy JTF_VARCHAR2_TABLE_100
308: , a11 out nocopy JTF_NUMBER_TABLE
309: , a12 out nocopy JTF_VARCHAR2_TABLE_100
310: , a13 out nocopy JTF_VARCHAR2_TABLE_100
311: , a14 out nocopy JTF_NUMBER_TABLE
312: ) as
313: ddindx binary_integer; indx binary_integer;
314: begin
315: if t is null or t.count = 0 then

Line 316: a0 := JTF_NUMBER_TABLE();

312: ) as
313: ddindx binary_integer; indx binary_integer;
314: begin
315: if t is null or t.count = 0 then
316: a0 := JTF_NUMBER_TABLE();
317: a1 := JTF_VARCHAR2_TABLE_100();
318: a2 := JTF_VARCHAR2_TABLE_100();
319: a3 := JTF_VARCHAR2_TABLE_100();
320: a4 := JTF_NUMBER_TABLE();

Line 320: a4 := JTF_NUMBER_TABLE();

316: a0 := JTF_NUMBER_TABLE();
317: a1 := JTF_VARCHAR2_TABLE_100();
318: a2 := JTF_VARCHAR2_TABLE_100();
319: a3 := JTF_VARCHAR2_TABLE_100();
320: a4 := JTF_NUMBER_TABLE();
321: a5 := JTF_NUMBER_TABLE();
322: a6 := JTF_VARCHAR2_TABLE_300();
323: a7 := JTF_NUMBER_TABLE();
324: a8 := JTF_VARCHAR2_TABLE_100();

Line 321: a5 := JTF_NUMBER_TABLE();

317: a1 := JTF_VARCHAR2_TABLE_100();
318: a2 := JTF_VARCHAR2_TABLE_100();
319: a3 := JTF_VARCHAR2_TABLE_100();
320: a4 := JTF_NUMBER_TABLE();
321: a5 := JTF_NUMBER_TABLE();
322: a6 := JTF_VARCHAR2_TABLE_300();
323: a7 := JTF_NUMBER_TABLE();
324: a8 := JTF_VARCHAR2_TABLE_100();
325: a9 := JTF_VARCHAR2_TABLE_100();

Line 323: a7 := JTF_NUMBER_TABLE();

319: a3 := JTF_VARCHAR2_TABLE_100();
320: a4 := JTF_NUMBER_TABLE();
321: a5 := JTF_NUMBER_TABLE();
322: a6 := JTF_VARCHAR2_TABLE_300();
323: a7 := JTF_NUMBER_TABLE();
324: a8 := JTF_VARCHAR2_TABLE_100();
325: a9 := JTF_VARCHAR2_TABLE_100();
326: a10 := JTF_VARCHAR2_TABLE_100();
327: a11 := JTF_NUMBER_TABLE();

Line 327: a11 := JTF_NUMBER_TABLE();

323: a7 := JTF_NUMBER_TABLE();
324: a8 := JTF_VARCHAR2_TABLE_100();
325: a9 := JTF_VARCHAR2_TABLE_100();
326: a10 := JTF_VARCHAR2_TABLE_100();
327: a11 := JTF_NUMBER_TABLE();
328: a12 := JTF_VARCHAR2_TABLE_100();
329: a13 := JTF_VARCHAR2_TABLE_100();
330: a14 := JTF_NUMBER_TABLE();
331: else

Line 330: a14 := JTF_NUMBER_TABLE();

326: a10 := JTF_VARCHAR2_TABLE_100();
327: a11 := JTF_NUMBER_TABLE();
328: a12 := JTF_VARCHAR2_TABLE_100();
329: a13 := JTF_VARCHAR2_TABLE_100();
330: a14 := JTF_NUMBER_TABLE();
331: else
332: a0 := JTF_NUMBER_TABLE();
333: a1 := JTF_VARCHAR2_TABLE_100();
334: a2 := JTF_VARCHAR2_TABLE_100();

Line 332: a0 := JTF_NUMBER_TABLE();

328: a12 := JTF_VARCHAR2_TABLE_100();
329: a13 := JTF_VARCHAR2_TABLE_100();
330: a14 := JTF_NUMBER_TABLE();
331: else
332: a0 := JTF_NUMBER_TABLE();
333: a1 := JTF_VARCHAR2_TABLE_100();
334: a2 := JTF_VARCHAR2_TABLE_100();
335: a3 := JTF_VARCHAR2_TABLE_100();
336: a4 := JTF_NUMBER_TABLE();

Line 336: a4 := JTF_NUMBER_TABLE();

332: a0 := JTF_NUMBER_TABLE();
333: a1 := JTF_VARCHAR2_TABLE_100();
334: a2 := JTF_VARCHAR2_TABLE_100();
335: a3 := JTF_VARCHAR2_TABLE_100();
336: a4 := JTF_NUMBER_TABLE();
337: a5 := JTF_NUMBER_TABLE();
338: a6 := JTF_VARCHAR2_TABLE_300();
339: a7 := JTF_NUMBER_TABLE();
340: a8 := JTF_VARCHAR2_TABLE_100();

Line 337: a5 := JTF_NUMBER_TABLE();

333: a1 := JTF_VARCHAR2_TABLE_100();
334: a2 := JTF_VARCHAR2_TABLE_100();
335: a3 := JTF_VARCHAR2_TABLE_100();
336: a4 := JTF_NUMBER_TABLE();
337: a5 := JTF_NUMBER_TABLE();
338: a6 := JTF_VARCHAR2_TABLE_300();
339: a7 := JTF_NUMBER_TABLE();
340: a8 := JTF_VARCHAR2_TABLE_100();
341: a9 := JTF_VARCHAR2_TABLE_100();

Line 339: a7 := JTF_NUMBER_TABLE();

335: a3 := JTF_VARCHAR2_TABLE_100();
336: a4 := JTF_NUMBER_TABLE();
337: a5 := JTF_NUMBER_TABLE();
338: a6 := JTF_VARCHAR2_TABLE_300();
339: a7 := JTF_NUMBER_TABLE();
340: a8 := JTF_VARCHAR2_TABLE_100();
341: a9 := JTF_VARCHAR2_TABLE_100();
342: a10 := JTF_VARCHAR2_TABLE_100();
343: a11 := JTF_NUMBER_TABLE();

Line 343: a11 := JTF_NUMBER_TABLE();

339: a7 := JTF_NUMBER_TABLE();
340: a8 := JTF_VARCHAR2_TABLE_100();
341: a9 := JTF_VARCHAR2_TABLE_100();
342: a10 := JTF_VARCHAR2_TABLE_100();
343: a11 := JTF_NUMBER_TABLE();
344: a12 := JTF_VARCHAR2_TABLE_100();
345: a13 := JTF_VARCHAR2_TABLE_100();
346: a14 := JTF_NUMBER_TABLE();
347: if t.count > 0 then

Line 346: a14 := JTF_NUMBER_TABLE();

342: a10 := JTF_VARCHAR2_TABLE_100();
343: a11 := JTF_NUMBER_TABLE();
344: a12 := JTF_VARCHAR2_TABLE_100();
345: a13 := JTF_VARCHAR2_TABLE_100();
346: a14 := JTF_NUMBER_TABLE();
347: if t.count > 0 then
348: a0.extend(t.count);
349: a1.extend(t.count);
350: a2.extend(t.count);

Line 393: , p1_a1 JTF_NUMBER_TABLE

389: end rosetta_table_copy_out_p5;
390:
391: procedure calculatefees(p_loan_id NUMBER
392: , p1_a0 JTF_VARCHAR2_TABLE_100
393: , p1_a1 JTF_NUMBER_TABLE
394: , p_installment NUMBER
395: , p3_a0 JTF_NUMBER_TABLE
396: , p3_a1 JTF_VARCHAR2_TABLE_100
397: , p3_a2 JTF_VARCHAR2_TABLE_300

Line 395: , p3_a0 JTF_NUMBER_TABLE

391: procedure calculatefees(p_loan_id NUMBER
392: , p1_a0 JTF_VARCHAR2_TABLE_100
393: , p1_a1 JTF_NUMBER_TABLE
394: , p_installment NUMBER
395: , p3_a0 JTF_NUMBER_TABLE
396: , p3_a1 JTF_VARCHAR2_TABLE_100
397: , p3_a2 JTF_VARCHAR2_TABLE_300
398: , p3_a3 JTF_VARCHAR2_TABLE_100
399: , p3_a4 JTF_VARCHAR2_TABLE_100

Line 400: , p3_a5 JTF_NUMBER_TABLE

396: , p3_a1 JTF_VARCHAR2_TABLE_100
397: , p3_a2 JTF_VARCHAR2_TABLE_300
398: , p3_a3 JTF_VARCHAR2_TABLE_100
399: , p3_a4 JTF_VARCHAR2_TABLE_100
400: , p3_a5 JTF_NUMBER_TABLE
401: , p3_a6 JTF_VARCHAR2_TABLE_100
402: , p3_a7 JTF_DATE_TABLE
403: , p3_a8 JTF_DATE_TABLE
404: , p3_a9 JTF_NUMBER_TABLE

Line 404: , p3_a9 JTF_NUMBER_TABLE

400: , p3_a5 JTF_NUMBER_TABLE
401: , p3_a6 JTF_VARCHAR2_TABLE_100
402: , p3_a7 JTF_DATE_TABLE
403: , p3_a8 JTF_DATE_TABLE
404: , p3_a9 JTF_NUMBER_TABLE
405: , p3_a10 JTF_VARCHAR2_TABLE_100
406: , p3_a11 JTF_VARCHAR2_TABLE_100
407: , p3_a12 JTF_NUMBER_TABLE
408: , p3_a13 JTF_NUMBER_TABLE

Line 407: , p3_a12 JTF_NUMBER_TABLE

403: , p3_a8 JTF_DATE_TABLE
404: , p3_a9 JTF_NUMBER_TABLE
405: , p3_a10 JTF_VARCHAR2_TABLE_100
406: , p3_a11 JTF_VARCHAR2_TABLE_100
407: , p3_a12 JTF_NUMBER_TABLE
408: , p3_a13 JTF_NUMBER_TABLE
409: , p3_a14 JTF_VARCHAR2_TABLE_100
410: , p3_a15 JTF_VARCHAR2_TABLE_100
411: , p3_a16 JTF_VARCHAR2_TABLE_100

Line 408: , p3_a13 JTF_NUMBER_TABLE

404: , p3_a9 JTF_NUMBER_TABLE
405: , p3_a10 JTF_VARCHAR2_TABLE_100
406: , p3_a11 JTF_VARCHAR2_TABLE_100
407: , p3_a12 JTF_NUMBER_TABLE
408: , p3_a13 JTF_NUMBER_TABLE
409: , p3_a14 JTF_VARCHAR2_TABLE_100
410: , p3_a15 JTF_VARCHAR2_TABLE_100
411: , p3_a16 JTF_VARCHAR2_TABLE_100
412: , p3_a17 JTF_NUMBER_TABLE

Line 412: , p3_a17 JTF_NUMBER_TABLE

408: , p3_a13 JTF_NUMBER_TABLE
409: , p3_a14 JTF_VARCHAR2_TABLE_100
410: , p3_a15 JTF_VARCHAR2_TABLE_100
411: , p3_a16 JTF_VARCHAR2_TABLE_100
412: , p3_a17 JTF_NUMBER_TABLE
413: , p3_a18 JTF_VARCHAR2_TABLE_100
414: , p3_a19 JTF_VARCHAR2_TABLE_100
415: , p3_a20 JTF_NUMBER_TABLE
416: , p3_a21 JTF_NUMBER_TABLE

Line 415: , p3_a20 JTF_NUMBER_TABLE

411: , p3_a16 JTF_VARCHAR2_TABLE_100
412: , p3_a17 JTF_NUMBER_TABLE
413: , p3_a18 JTF_VARCHAR2_TABLE_100
414: , p3_a19 JTF_VARCHAR2_TABLE_100
415: , p3_a20 JTF_NUMBER_TABLE
416: , p3_a21 JTF_NUMBER_TABLE
417: , p3_a22 JTF_DATE_TABLE
418: , p4_a0 out nocopy JTF_NUMBER_TABLE
419: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 416: , p3_a21 JTF_NUMBER_TABLE

412: , p3_a17 JTF_NUMBER_TABLE
413: , p3_a18 JTF_VARCHAR2_TABLE_100
414: , p3_a19 JTF_VARCHAR2_TABLE_100
415: , p3_a20 JTF_NUMBER_TABLE
416: , p3_a21 JTF_NUMBER_TABLE
417: , p3_a22 JTF_DATE_TABLE
418: , p4_a0 out nocopy JTF_NUMBER_TABLE
419: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
420: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 418: , p4_a0 out nocopy JTF_NUMBER_TABLE

414: , p3_a19 JTF_VARCHAR2_TABLE_100
415: , p3_a20 JTF_NUMBER_TABLE
416: , p3_a21 JTF_NUMBER_TABLE
417: , p3_a22 JTF_DATE_TABLE
418: , p4_a0 out nocopy JTF_NUMBER_TABLE
419: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
420: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
421: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
422: , p4_a4 out nocopy JTF_NUMBER_TABLE

Line 422: , p4_a4 out nocopy JTF_NUMBER_TABLE

418: , p4_a0 out nocopy JTF_NUMBER_TABLE
419: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
420: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
421: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
422: , p4_a4 out nocopy JTF_NUMBER_TABLE
423: , p4_a5 out nocopy JTF_NUMBER_TABLE
424: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_300
425: , p4_a7 out nocopy JTF_NUMBER_TABLE
426: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 423: , p4_a5 out nocopy JTF_NUMBER_TABLE

419: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
420: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
421: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
422: , p4_a4 out nocopy JTF_NUMBER_TABLE
423: , p4_a5 out nocopy JTF_NUMBER_TABLE
424: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_300
425: , p4_a7 out nocopy JTF_NUMBER_TABLE
426: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
427: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 425: , p4_a7 out nocopy JTF_NUMBER_TABLE

421: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
422: , p4_a4 out nocopy JTF_NUMBER_TABLE
423: , p4_a5 out nocopy JTF_NUMBER_TABLE
424: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_300
425: , p4_a7 out nocopy JTF_NUMBER_TABLE
426: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
427: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
428: , p4_a10 out nocopy JTF_VARCHAR2_TABLE_100
429: , p4_a11 out nocopy JTF_NUMBER_TABLE

Line 429: , p4_a11 out nocopy JTF_NUMBER_TABLE

425: , p4_a7 out nocopy JTF_NUMBER_TABLE
426: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
427: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
428: , p4_a10 out nocopy JTF_VARCHAR2_TABLE_100
429: , p4_a11 out nocopy JTF_NUMBER_TABLE
430: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
431: , p4_a13 out nocopy JTF_VARCHAR2_TABLE_100
432: , p4_a14 out nocopy JTF_NUMBER_TABLE
433: , x_return_status out nocopy VARCHAR2

Line 432: , p4_a14 out nocopy JTF_NUMBER_TABLE

428: , p4_a10 out nocopy JTF_VARCHAR2_TABLE_100
429: , p4_a11 out nocopy JTF_NUMBER_TABLE
430: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
431: , p4_a13 out nocopy JTF_VARCHAR2_TABLE_100
432: , p4_a14 out nocopy JTF_NUMBER_TABLE
433: , x_return_status out nocopy VARCHAR2
434: , x_msg_count out nocopy NUMBER
435: , x_msg_data out nocopy VARCHAR2
436: )

Line 520: , p3_a0 in out nocopy JTF_NUMBER_TABLE

516:
517: procedure writefeeschedule(p_init_msg_list VARCHAR2
518: , p_commit VARCHAR2
519: , p_loan_id NUMBER
520: , p3_a0 in out nocopy JTF_NUMBER_TABLE
521: , p3_a1 in out nocopy JTF_VARCHAR2_TABLE_100
522: , p3_a2 in out nocopy JTF_VARCHAR2_TABLE_100
523: , p3_a3 in out nocopy JTF_VARCHAR2_TABLE_100
524: , p3_a4 in out nocopy JTF_NUMBER_TABLE

Line 524: , p3_a4 in out nocopy JTF_NUMBER_TABLE

520: , p3_a0 in out nocopy JTF_NUMBER_TABLE
521: , p3_a1 in out nocopy JTF_VARCHAR2_TABLE_100
522: , p3_a2 in out nocopy JTF_VARCHAR2_TABLE_100
523: , p3_a3 in out nocopy JTF_VARCHAR2_TABLE_100
524: , p3_a4 in out nocopy JTF_NUMBER_TABLE
525: , p3_a5 in out nocopy JTF_NUMBER_TABLE
526: , p3_a6 in out nocopy JTF_VARCHAR2_TABLE_300
527: , p3_a7 in out nocopy JTF_NUMBER_TABLE
528: , p3_a8 in out nocopy JTF_VARCHAR2_TABLE_100

Line 525: , p3_a5 in out nocopy JTF_NUMBER_TABLE

521: , p3_a1 in out nocopy JTF_VARCHAR2_TABLE_100
522: , p3_a2 in out nocopy JTF_VARCHAR2_TABLE_100
523: , p3_a3 in out nocopy JTF_VARCHAR2_TABLE_100
524: , p3_a4 in out nocopy JTF_NUMBER_TABLE
525: , p3_a5 in out nocopy JTF_NUMBER_TABLE
526: , p3_a6 in out nocopy JTF_VARCHAR2_TABLE_300
527: , p3_a7 in out nocopy JTF_NUMBER_TABLE
528: , p3_a8 in out nocopy JTF_VARCHAR2_TABLE_100
529: , p3_a9 in out nocopy JTF_VARCHAR2_TABLE_100

Line 527: , p3_a7 in out nocopy JTF_NUMBER_TABLE

523: , p3_a3 in out nocopy JTF_VARCHAR2_TABLE_100
524: , p3_a4 in out nocopy JTF_NUMBER_TABLE
525: , p3_a5 in out nocopy JTF_NUMBER_TABLE
526: , p3_a6 in out nocopy JTF_VARCHAR2_TABLE_300
527: , p3_a7 in out nocopy JTF_NUMBER_TABLE
528: , p3_a8 in out nocopy JTF_VARCHAR2_TABLE_100
529: , p3_a9 in out nocopy JTF_VARCHAR2_TABLE_100
530: , p3_a10 in out nocopy JTF_VARCHAR2_TABLE_100
531: , p3_a11 in out nocopy JTF_NUMBER_TABLE

Line 531: , p3_a11 in out nocopy JTF_NUMBER_TABLE

527: , p3_a7 in out nocopy JTF_NUMBER_TABLE
528: , p3_a8 in out nocopy JTF_VARCHAR2_TABLE_100
529: , p3_a9 in out nocopy JTF_VARCHAR2_TABLE_100
530: , p3_a10 in out nocopy JTF_VARCHAR2_TABLE_100
531: , p3_a11 in out nocopy JTF_NUMBER_TABLE
532: , p3_a12 in out nocopy JTF_VARCHAR2_TABLE_100
533: , p3_a13 in out nocopy JTF_VARCHAR2_TABLE_100
534: , p3_a14 in out nocopy JTF_NUMBER_TABLE
535: , x_return_status out nocopy VARCHAR2

Line 534: , p3_a14 in out nocopy JTF_NUMBER_TABLE

530: , p3_a10 in out nocopy JTF_VARCHAR2_TABLE_100
531: , p3_a11 in out nocopy JTF_NUMBER_TABLE
532: , p3_a12 in out nocopy JTF_VARCHAR2_TABLE_100
533: , p3_a13 in out nocopy JTF_VARCHAR2_TABLE_100
534: , p3_a14 in out nocopy JTF_NUMBER_TABLE
535: , x_return_status out nocopy VARCHAR2
536: , x_msg_count out nocopy NUMBER
537: , x_msg_data out nocopy VARCHAR2
538: )

Line 606: , p3_a0 JTF_NUMBER_TABLE

602:
603: procedure updatefeeschedule(p_init_msg_list VARCHAR2
604: , p_commit VARCHAR2
605: , p_loan_id NUMBER
606: , p3_a0 JTF_NUMBER_TABLE
607: , p3_a1 JTF_VARCHAR2_TABLE_100
608: , p3_a2 JTF_VARCHAR2_TABLE_100
609: , p3_a3 JTF_VARCHAR2_TABLE_100
610: , p3_a4 JTF_NUMBER_TABLE

Line 610: , p3_a4 JTF_NUMBER_TABLE

606: , p3_a0 JTF_NUMBER_TABLE
607: , p3_a1 JTF_VARCHAR2_TABLE_100
608: , p3_a2 JTF_VARCHAR2_TABLE_100
609: , p3_a3 JTF_VARCHAR2_TABLE_100
610: , p3_a4 JTF_NUMBER_TABLE
611: , p3_a5 JTF_NUMBER_TABLE
612: , p3_a6 JTF_VARCHAR2_TABLE_300
613: , p3_a7 JTF_NUMBER_TABLE
614: , p3_a8 JTF_VARCHAR2_TABLE_100

Line 611: , p3_a5 JTF_NUMBER_TABLE

607: , p3_a1 JTF_VARCHAR2_TABLE_100
608: , p3_a2 JTF_VARCHAR2_TABLE_100
609: , p3_a3 JTF_VARCHAR2_TABLE_100
610: , p3_a4 JTF_NUMBER_TABLE
611: , p3_a5 JTF_NUMBER_TABLE
612: , p3_a6 JTF_VARCHAR2_TABLE_300
613: , p3_a7 JTF_NUMBER_TABLE
614: , p3_a8 JTF_VARCHAR2_TABLE_100
615: , p3_a9 JTF_VARCHAR2_TABLE_100

Line 613: , p3_a7 JTF_NUMBER_TABLE

609: , p3_a3 JTF_VARCHAR2_TABLE_100
610: , p3_a4 JTF_NUMBER_TABLE
611: , p3_a5 JTF_NUMBER_TABLE
612: , p3_a6 JTF_VARCHAR2_TABLE_300
613: , p3_a7 JTF_NUMBER_TABLE
614: , p3_a8 JTF_VARCHAR2_TABLE_100
615: , p3_a9 JTF_VARCHAR2_TABLE_100
616: , p3_a10 JTF_VARCHAR2_TABLE_100
617: , p3_a11 JTF_NUMBER_TABLE

Line 617: , p3_a11 JTF_NUMBER_TABLE

613: , p3_a7 JTF_NUMBER_TABLE
614: , p3_a8 JTF_VARCHAR2_TABLE_100
615: , p3_a9 JTF_VARCHAR2_TABLE_100
616: , p3_a10 JTF_VARCHAR2_TABLE_100
617: , p3_a11 JTF_NUMBER_TABLE
618: , p3_a12 JTF_VARCHAR2_TABLE_100
619: , p3_a13 JTF_VARCHAR2_TABLE_100
620: , p3_a14 JTF_NUMBER_TABLE
621: , x_return_status out nocopy VARCHAR2

Line 620: , p3_a14 JTF_NUMBER_TABLE

616: , p3_a10 JTF_VARCHAR2_TABLE_100
617: , p3_a11 JTF_NUMBER_TABLE
618: , p3_a12 JTF_VARCHAR2_TABLE_100
619: , p3_a13 JTF_VARCHAR2_TABLE_100
620: , p3_a14 JTF_NUMBER_TABLE
621: , x_return_status out nocopy VARCHAR2
622: , x_msg_count out nocopy NUMBER
623: , x_msg_data out nocopy VARCHAR2
624: )

Line 677: , p4_a0 out nocopy JTF_NUMBER_TABLE

673: procedure getfeeschedule(p_init_msg_list VARCHAR2
674: , p_loan_id NUMBER
675: , p_installment_number NUMBER
676: , p_disb_header_id NUMBER
677: , p4_a0 out nocopy JTF_NUMBER_TABLE
678: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
679: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
680: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
681: , p4_a4 out nocopy JTF_NUMBER_TABLE

Line 681: , p4_a4 out nocopy JTF_NUMBER_TABLE

677: , p4_a0 out nocopy JTF_NUMBER_TABLE
678: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
679: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
680: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
681: , p4_a4 out nocopy JTF_NUMBER_TABLE
682: , p4_a5 out nocopy JTF_NUMBER_TABLE
683: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_300
684: , p4_a7 out nocopy JTF_NUMBER_TABLE
685: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 682: , p4_a5 out nocopy JTF_NUMBER_TABLE

678: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
679: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
680: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
681: , p4_a4 out nocopy JTF_NUMBER_TABLE
682: , p4_a5 out nocopy JTF_NUMBER_TABLE
683: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_300
684: , p4_a7 out nocopy JTF_NUMBER_TABLE
685: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
686: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 684: , p4_a7 out nocopy JTF_NUMBER_TABLE

680: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
681: , p4_a4 out nocopy JTF_NUMBER_TABLE
682: , p4_a5 out nocopy JTF_NUMBER_TABLE
683: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_300
684: , p4_a7 out nocopy JTF_NUMBER_TABLE
685: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
686: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
687: , p4_a10 out nocopy JTF_VARCHAR2_TABLE_100
688: , p4_a11 out nocopy JTF_NUMBER_TABLE

Line 688: , p4_a11 out nocopy JTF_NUMBER_TABLE

684: , p4_a7 out nocopy JTF_NUMBER_TABLE
685: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
686: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
687: , p4_a10 out nocopy JTF_VARCHAR2_TABLE_100
688: , p4_a11 out nocopy JTF_NUMBER_TABLE
689: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
690: , p4_a13 out nocopy JTF_VARCHAR2_TABLE_100
691: , p4_a14 out nocopy JTF_NUMBER_TABLE
692: , x_return_status out nocopy VARCHAR2

Line 691: , p4_a14 out nocopy JTF_NUMBER_TABLE

687: , p4_a10 out nocopy JTF_VARCHAR2_TABLE_100
688: , p4_a11 out nocopy JTF_NUMBER_TABLE
689: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
690: , p4_a13 out nocopy JTF_VARCHAR2_TABLE_100
691: , p4_a14 out nocopy JTF_NUMBER_TABLE
692: , x_return_status out nocopy VARCHAR2
693: , x_msg_count out nocopy NUMBER
694: , x_msg_data out nocopy VARCHAR2
695: )

Line 751: , p3_a1 JTF_NUMBER_TABLE

747: procedure getfeedetails(p_init_msg_list VARCHAR2
748: , p_loan_id NUMBER
749: , p_installment NUMBER
750: , p3_a0 JTF_VARCHAR2_TABLE_100
751: , p3_a1 JTF_NUMBER_TABLE
752: , p_based_on_terms VARCHAR2
753: , p_phase VARCHAR2
754: , p6_a0 out nocopy JTF_NUMBER_TABLE
755: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 754: , p6_a0 out nocopy JTF_NUMBER_TABLE

750: , p3_a0 JTF_VARCHAR2_TABLE_100
751: , p3_a1 JTF_NUMBER_TABLE
752: , p_based_on_terms VARCHAR2
753: , p_phase VARCHAR2
754: , p6_a0 out nocopy JTF_NUMBER_TABLE
755: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
756: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
757: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
758: , p6_a4 out nocopy JTF_NUMBER_TABLE

Line 758: , p6_a4 out nocopy JTF_NUMBER_TABLE

754: , p6_a0 out nocopy JTF_NUMBER_TABLE
755: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
756: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
757: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
758: , p6_a4 out nocopy JTF_NUMBER_TABLE
759: , p6_a5 out nocopy JTF_NUMBER_TABLE
760: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
761: , p6_a7 out nocopy JTF_NUMBER_TABLE
762: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 759: , p6_a5 out nocopy JTF_NUMBER_TABLE

755: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
756: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
757: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
758: , p6_a4 out nocopy JTF_NUMBER_TABLE
759: , p6_a5 out nocopy JTF_NUMBER_TABLE
760: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
761: , p6_a7 out nocopy JTF_NUMBER_TABLE
762: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
763: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 761: , p6_a7 out nocopy JTF_NUMBER_TABLE

757: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
758: , p6_a4 out nocopy JTF_NUMBER_TABLE
759: , p6_a5 out nocopy JTF_NUMBER_TABLE
760: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
761: , p6_a7 out nocopy JTF_NUMBER_TABLE
762: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
763: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
764: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
765: , p6_a11 out nocopy JTF_NUMBER_TABLE

Line 765: , p6_a11 out nocopy JTF_NUMBER_TABLE

761: , p6_a7 out nocopy JTF_NUMBER_TABLE
762: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
763: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
764: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
765: , p6_a11 out nocopy JTF_NUMBER_TABLE
766: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
767: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
768: , p6_a14 out nocopy JTF_NUMBER_TABLE
769: , x_return_status out nocopy VARCHAR2

Line 768: , p6_a14 out nocopy JTF_NUMBER_TABLE

764: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
765: , p6_a11 out nocopy JTF_NUMBER_TABLE
766: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
767: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
768: , p6_a14 out nocopy JTF_NUMBER_TABLE
769: , x_return_status out nocopy VARCHAR2
770: , x_msg_count out nocopy NUMBER
771: , x_msg_data out nocopy VARCHAR2
772: )

Line 839: , p4_a1 JTF_NUMBER_TABLE

835: , p_commit VARCHAR2
836: , p_loan_id NUMBER
837: , p_installment_number NUMBER
838: , p4_a0 JTF_VARCHAR2_TABLE_100
839: , p4_a1 JTF_NUMBER_TABLE
840: , p5_a0 JTF_NUMBER_TABLE
841: , p5_a1 JTF_VARCHAR2_TABLE_100
842: , p5_a2 JTF_VARCHAR2_TABLE_300
843: , p5_a3 JTF_VARCHAR2_TABLE_100

Line 840: , p5_a0 JTF_NUMBER_TABLE

836: , p_loan_id NUMBER
837: , p_installment_number NUMBER
838: , p4_a0 JTF_VARCHAR2_TABLE_100
839: , p4_a1 JTF_NUMBER_TABLE
840: , p5_a0 JTF_NUMBER_TABLE
841: , p5_a1 JTF_VARCHAR2_TABLE_100
842: , p5_a2 JTF_VARCHAR2_TABLE_300
843: , p5_a3 JTF_VARCHAR2_TABLE_100
844: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 845: , p5_a5 JTF_NUMBER_TABLE

841: , p5_a1 JTF_VARCHAR2_TABLE_100
842: , p5_a2 JTF_VARCHAR2_TABLE_300
843: , p5_a3 JTF_VARCHAR2_TABLE_100
844: , p5_a4 JTF_VARCHAR2_TABLE_100
845: , p5_a5 JTF_NUMBER_TABLE
846: , p5_a6 JTF_VARCHAR2_TABLE_100
847: , p5_a7 JTF_DATE_TABLE
848: , p5_a8 JTF_DATE_TABLE
849: , p5_a9 JTF_NUMBER_TABLE

Line 849: , p5_a9 JTF_NUMBER_TABLE

845: , p5_a5 JTF_NUMBER_TABLE
846: , p5_a6 JTF_VARCHAR2_TABLE_100
847: , p5_a7 JTF_DATE_TABLE
848: , p5_a8 JTF_DATE_TABLE
849: , p5_a9 JTF_NUMBER_TABLE
850: , p5_a10 JTF_VARCHAR2_TABLE_100
851: , p5_a11 JTF_VARCHAR2_TABLE_100
852: , p5_a12 JTF_NUMBER_TABLE
853: , p5_a13 JTF_NUMBER_TABLE

Line 852: , p5_a12 JTF_NUMBER_TABLE

848: , p5_a8 JTF_DATE_TABLE
849: , p5_a9 JTF_NUMBER_TABLE
850: , p5_a10 JTF_VARCHAR2_TABLE_100
851: , p5_a11 JTF_VARCHAR2_TABLE_100
852: , p5_a12 JTF_NUMBER_TABLE
853: , p5_a13 JTF_NUMBER_TABLE
854: , p5_a14 JTF_VARCHAR2_TABLE_100
855: , p5_a15 JTF_VARCHAR2_TABLE_100
856: , p5_a16 JTF_VARCHAR2_TABLE_100

Line 853: , p5_a13 JTF_NUMBER_TABLE

849: , p5_a9 JTF_NUMBER_TABLE
850: , p5_a10 JTF_VARCHAR2_TABLE_100
851: , p5_a11 JTF_VARCHAR2_TABLE_100
852: , p5_a12 JTF_NUMBER_TABLE
853: , p5_a13 JTF_NUMBER_TABLE
854: , p5_a14 JTF_VARCHAR2_TABLE_100
855: , p5_a15 JTF_VARCHAR2_TABLE_100
856: , p5_a16 JTF_VARCHAR2_TABLE_100
857: , p5_a17 JTF_NUMBER_TABLE

Line 857: , p5_a17 JTF_NUMBER_TABLE

853: , p5_a13 JTF_NUMBER_TABLE
854: , p5_a14 JTF_VARCHAR2_TABLE_100
855: , p5_a15 JTF_VARCHAR2_TABLE_100
856: , p5_a16 JTF_VARCHAR2_TABLE_100
857: , p5_a17 JTF_NUMBER_TABLE
858: , p5_a18 JTF_VARCHAR2_TABLE_100
859: , p5_a19 JTF_VARCHAR2_TABLE_100
860: , p5_a20 JTF_NUMBER_TABLE
861: , p5_a21 JTF_NUMBER_TABLE

Line 860: , p5_a20 JTF_NUMBER_TABLE

856: , p5_a16 JTF_VARCHAR2_TABLE_100
857: , p5_a17 JTF_NUMBER_TABLE
858: , p5_a18 JTF_VARCHAR2_TABLE_100
859: , p5_a19 JTF_VARCHAR2_TABLE_100
860: , p5_a20 JTF_NUMBER_TABLE
861: , p5_a21 JTF_NUMBER_TABLE
862: , p5_a22 JTF_DATE_TABLE
863: , p6_a0 out nocopy JTF_NUMBER_TABLE
864: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 861: , p5_a21 JTF_NUMBER_TABLE

857: , p5_a17 JTF_NUMBER_TABLE
858: , p5_a18 JTF_VARCHAR2_TABLE_100
859: , p5_a19 JTF_VARCHAR2_TABLE_100
860: , p5_a20 JTF_NUMBER_TABLE
861: , p5_a21 JTF_NUMBER_TABLE
862: , p5_a22 JTF_DATE_TABLE
863: , p6_a0 out nocopy JTF_NUMBER_TABLE
864: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
865: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 863: , p6_a0 out nocopy JTF_NUMBER_TABLE

859: , p5_a19 JTF_VARCHAR2_TABLE_100
860: , p5_a20 JTF_NUMBER_TABLE
861: , p5_a21 JTF_NUMBER_TABLE
862: , p5_a22 JTF_DATE_TABLE
863: , p6_a0 out nocopy JTF_NUMBER_TABLE
864: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
865: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
866: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
867: , p6_a4 out nocopy JTF_NUMBER_TABLE

Line 867: , p6_a4 out nocopy JTF_NUMBER_TABLE

863: , p6_a0 out nocopy JTF_NUMBER_TABLE
864: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
865: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
866: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
867: , p6_a4 out nocopy JTF_NUMBER_TABLE
868: , p6_a5 out nocopy JTF_NUMBER_TABLE
869: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
870: , p6_a7 out nocopy JTF_NUMBER_TABLE
871: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 868: , p6_a5 out nocopy JTF_NUMBER_TABLE

864: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
865: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
866: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
867: , p6_a4 out nocopy JTF_NUMBER_TABLE
868: , p6_a5 out nocopy JTF_NUMBER_TABLE
869: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
870: , p6_a7 out nocopy JTF_NUMBER_TABLE
871: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
872: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 870: , p6_a7 out nocopy JTF_NUMBER_TABLE

866: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
867: , p6_a4 out nocopy JTF_NUMBER_TABLE
868: , p6_a5 out nocopy JTF_NUMBER_TABLE
869: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
870: , p6_a7 out nocopy JTF_NUMBER_TABLE
871: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
872: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
873: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
874: , p6_a11 out nocopy JTF_NUMBER_TABLE

Line 874: , p6_a11 out nocopy JTF_NUMBER_TABLE

870: , p6_a7 out nocopy JTF_NUMBER_TABLE
871: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
872: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
873: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
874: , p6_a11 out nocopy JTF_NUMBER_TABLE
875: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
876: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
877: , p6_a14 out nocopy JTF_NUMBER_TABLE
878: , x_return_status out nocopy VARCHAR2

Line 877: , p6_a14 out nocopy JTF_NUMBER_TABLE

873: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
874: , p6_a11 out nocopy JTF_NUMBER_TABLE
875: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
876: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
877: , p6_a14 out nocopy JTF_NUMBER_TABLE
878: , x_return_status out nocopy VARCHAR2
879: , x_msg_count out nocopy NUMBER
880: , x_msg_data out nocopy VARCHAR2
881: )