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_VARCHAR2_TABLE_100

Line 3: procedure rosetta_table_copy_in_p1(t out nocopy lns_fee_engine.fee_basis_tbl, a0 JTF_VARCHAR2_TABLE_100

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

Line 24: procedure rosetta_table_copy_out_p1(t lns_fee_engine.fee_basis_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100

20: end loop;
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

Line 30: a0 := JTF_VARCHAR2_TABLE_100();

26: ) as
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();

Line 33: a0 := JTF_VARCHAR2_TABLE_100();

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
36: a0.extend(t.count);
37: a1.extend(t.count);

Line 54: , a1 JTF_VARCHAR2_TABLE_100

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
58: , a5 JTF_NUMBER_TABLE

Line 56: , a3 JTF_VARCHAR2_TABLE_100

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
58: , a5 JTF_NUMBER_TABLE
59: , a6 JTF_VARCHAR2_TABLE_100
60: , a7 JTF_DATE_TABLE

Line 57: , a4 JTF_VARCHAR2_TABLE_100

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
58: , a5 JTF_NUMBER_TABLE
59: , a6 JTF_VARCHAR2_TABLE_100
60: , a7 JTF_DATE_TABLE
61: , a8 JTF_DATE_TABLE

Line 59: , a6 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
63: , a10 JTF_VARCHAR2_TABLE_100

Line 63: , a10 JTF_VARCHAR2_TABLE_100

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
67: , a14 JTF_VARCHAR2_TABLE_100

Line 64: , a11 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
67: , a14 JTF_VARCHAR2_TABLE_100
68: , a15 JTF_VARCHAR2_TABLE_100

Line 67: , a14 JTF_VARCHAR2_TABLE_100

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
71: , a18 JTF_VARCHAR2_TABLE_100

Line 68: , a15 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
71: , a18 JTF_VARCHAR2_TABLE_100
72: , a19 JTF_VARCHAR2_TABLE_100

Line 69: , a16 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
71: , a18 JTF_VARCHAR2_TABLE_100
72: , a19 JTF_VARCHAR2_TABLE_100
73: , a20 JTF_NUMBER_TABLE

Line 71: , a18 JTF_VARCHAR2_TABLE_100

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
75: , a22 JTF_DATE_TABLE

Line 72: , a19 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
75: , a22 JTF_DATE_TABLE
76: ) as

Line 117: , a1 out nocopy JTF_VARCHAR2_TABLE_100

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
121: , a5 out nocopy JTF_NUMBER_TABLE

Line 119: , a3 out nocopy JTF_VARCHAR2_TABLE_100

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
121: , a5 out nocopy JTF_NUMBER_TABLE
122: , a6 out nocopy JTF_VARCHAR2_TABLE_100
123: , a7 out nocopy JTF_DATE_TABLE

Line 120: , a4 out nocopy JTF_VARCHAR2_TABLE_100

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
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

Line 122: , a6 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
126: , a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 126: , a10 out nocopy JTF_VARCHAR2_TABLE_100

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
130: , a14 out nocopy JTF_VARCHAR2_TABLE_100

Line 127: , a11 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
130: , a14 out nocopy JTF_VARCHAR2_TABLE_100
131: , a15 out nocopy JTF_VARCHAR2_TABLE_100

Line 130: , a14 out nocopy JTF_VARCHAR2_TABLE_100

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
134: , a18 out nocopy JTF_VARCHAR2_TABLE_100

Line 131: , a15 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
134: , a18 out nocopy JTF_VARCHAR2_TABLE_100
135: , a19 out nocopy JTF_VARCHAR2_TABLE_100

Line 132: , a16 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
134: , a18 out nocopy JTF_VARCHAR2_TABLE_100
135: , a19 out nocopy JTF_VARCHAR2_TABLE_100
136: , a20 out nocopy JTF_NUMBER_TABLE

Line 134: , a18 out nocopy JTF_VARCHAR2_TABLE_100

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
138: , a22 out nocopy JTF_DATE_TABLE

Line 135: , a19 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
138: , a22 out nocopy JTF_DATE_TABLE
139: ) as

Line 144: a1 := JTF_VARCHAR2_TABLE_100();

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();
148: a5 := JTF_NUMBER_TABLE();

Line 146: a3 := JTF_VARCHAR2_TABLE_100();

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();
148: a5 := JTF_NUMBER_TABLE();
149: a6 := JTF_VARCHAR2_TABLE_100();
150: a7 := JTF_DATE_TABLE();

Line 147: a4 := JTF_VARCHAR2_TABLE_100();

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();
148: a5 := JTF_NUMBER_TABLE();
149: a6 := JTF_VARCHAR2_TABLE_100();
150: a7 := JTF_DATE_TABLE();
151: a8 := JTF_DATE_TABLE();

Line 149: a6 := 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();
153: a10 := JTF_VARCHAR2_TABLE_100();

Line 153: a10 := JTF_VARCHAR2_TABLE_100();

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();
157: a14 := JTF_VARCHAR2_TABLE_100();

Line 154: a11 := 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();
157: a14 := JTF_VARCHAR2_TABLE_100();
158: a15 := JTF_VARCHAR2_TABLE_100();

Line 157: a14 := JTF_VARCHAR2_TABLE_100();

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();
161: a18 := JTF_VARCHAR2_TABLE_100();

Line 158: a15 := 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();
161: a18 := JTF_VARCHAR2_TABLE_100();
162: a19 := JTF_VARCHAR2_TABLE_100();

Line 159: a16 := 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();
161: a18 := JTF_VARCHAR2_TABLE_100();
162: a19 := JTF_VARCHAR2_TABLE_100();
163: a20 := JTF_NUMBER_TABLE();

Line 161: a18 := JTF_VARCHAR2_TABLE_100();

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();
165: a22 := JTF_DATE_TABLE();

Line 162: a19 := 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();
165: a22 := JTF_DATE_TABLE();
166: else

Line 168: a1 := JTF_VARCHAR2_TABLE_100();

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();
172: a5 := JTF_NUMBER_TABLE();

Line 170: a3 := JTF_VARCHAR2_TABLE_100();

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();
172: a5 := JTF_NUMBER_TABLE();
173: a6 := JTF_VARCHAR2_TABLE_100();
174: a7 := JTF_DATE_TABLE();

Line 171: a4 := JTF_VARCHAR2_TABLE_100();

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();
172: a5 := JTF_NUMBER_TABLE();
173: a6 := JTF_VARCHAR2_TABLE_100();
174: a7 := JTF_DATE_TABLE();
175: a8 := JTF_DATE_TABLE();

Line 173: a6 := 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();
177: a10 := JTF_VARCHAR2_TABLE_100();

Line 177: a10 := JTF_VARCHAR2_TABLE_100();

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();
181: a14 := JTF_VARCHAR2_TABLE_100();

Line 178: a11 := 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();
181: a14 := JTF_VARCHAR2_TABLE_100();
182: a15 := JTF_VARCHAR2_TABLE_100();

Line 181: a14 := JTF_VARCHAR2_TABLE_100();

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();
185: a18 := JTF_VARCHAR2_TABLE_100();

Line 182: a15 := 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();
185: a18 := JTF_VARCHAR2_TABLE_100();
186: a19 := JTF_VARCHAR2_TABLE_100();

Line 183: a16 := 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();
185: a18 := JTF_VARCHAR2_TABLE_100();
186: a19 := JTF_VARCHAR2_TABLE_100();
187: a20 := JTF_NUMBER_TABLE();

Line 185: a18 := JTF_VARCHAR2_TABLE_100();

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();
189: a22 := JTF_DATE_TABLE();

Line 186: a19 := 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();
189: a22 := JTF_DATE_TABLE();
190: if t.count > 0 then

Line 251: , a1 JTF_VARCHAR2_TABLE_100

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
255: , a5 JTF_NUMBER_TABLE

Line 252: , a2 JTF_VARCHAR2_TABLE_100

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
255: , a5 JTF_NUMBER_TABLE
256: , a6 JTF_VARCHAR2_TABLE_300

Line 253: , a3 JTF_VARCHAR2_TABLE_100

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
255: , a5 JTF_NUMBER_TABLE
256: , a6 JTF_VARCHAR2_TABLE_300
257: , a7 JTF_NUMBER_TABLE

Line 258: , a8 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
262: , a12 JTF_VARCHAR2_TABLE_100

Line 259: , a9 JTF_VARCHAR2_TABLE_100

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
262: , a12 JTF_VARCHAR2_TABLE_100
263: , a13 JTF_VARCHAR2_TABLE_100

Line 260: , a10 JTF_VARCHAR2_TABLE_100

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
262: , a12 JTF_VARCHAR2_TABLE_100
263: , a13 JTF_VARCHAR2_TABLE_100
264: , a14 JTF_NUMBER_TABLE

Line 262: , a12 JTF_VARCHAR2_TABLE_100

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
266: ddindx binary_integer; indx binary_integer;

Line 263: , a13 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
266: ddindx binary_integer; indx binary_integer;
267: begin

Line 298: , a1 out nocopy JTF_VARCHAR2_TABLE_100

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
302: , a5 out nocopy JTF_NUMBER_TABLE

Line 299: , a2 out nocopy JTF_VARCHAR2_TABLE_100

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
302: , a5 out nocopy JTF_NUMBER_TABLE
303: , a6 out nocopy JTF_VARCHAR2_TABLE_300

Line 300: , a3 out nocopy JTF_VARCHAR2_TABLE_100

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
302: , a5 out nocopy JTF_NUMBER_TABLE
303: , a6 out nocopy JTF_VARCHAR2_TABLE_300
304: , a7 out nocopy JTF_NUMBER_TABLE

Line 305: , a8 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
309: , a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 306: , a9 out nocopy JTF_VARCHAR2_TABLE_100

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
309: , a12 out nocopy JTF_VARCHAR2_TABLE_100
310: , a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 307: , a10 out nocopy JTF_VARCHAR2_TABLE_100

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
309: , a12 out nocopy JTF_VARCHAR2_TABLE_100
310: , a13 out nocopy JTF_VARCHAR2_TABLE_100
311: , a14 out nocopy JTF_NUMBER_TABLE

Line 309: , a12 out nocopy JTF_VARCHAR2_TABLE_100

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
313: ddindx binary_integer; indx binary_integer;

Line 310: , a13 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
313: ddindx binary_integer; indx binary_integer;
314: begin

Line 317: a1 := JTF_VARCHAR2_TABLE_100();

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();
321: a5 := JTF_NUMBER_TABLE();

Line 318: a2 := JTF_VARCHAR2_TABLE_100();

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();
321: a5 := JTF_NUMBER_TABLE();
322: a6 := JTF_VARCHAR2_TABLE_300();

Line 319: a3 := JTF_VARCHAR2_TABLE_100();

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();
321: a5 := JTF_NUMBER_TABLE();
322: a6 := JTF_VARCHAR2_TABLE_300();
323: a7 := JTF_NUMBER_TABLE();

Line 324: a8 := 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();
328: a12 := JTF_VARCHAR2_TABLE_100();

Line 325: a9 := JTF_VARCHAR2_TABLE_100();

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();
328: a12 := JTF_VARCHAR2_TABLE_100();
329: a13 := JTF_VARCHAR2_TABLE_100();

Line 326: a10 := JTF_VARCHAR2_TABLE_100();

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();
328: a12 := JTF_VARCHAR2_TABLE_100();
329: a13 := JTF_VARCHAR2_TABLE_100();
330: a14 := JTF_NUMBER_TABLE();

Line 328: a12 := JTF_VARCHAR2_TABLE_100();

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
332: a0 := JTF_NUMBER_TABLE();

Line 329: a13 := 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
332: a0 := JTF_NUMBER_TABLE();
333: a1 := JTF_VARCHAR2_TABLE_100();

Line 333: a1 := 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();
337: a5 := JTF_NUMBER_TABLE();

Line 334: a2 := 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();
337: a5 := JTF_NUMBER_TABLE();
338: a6 := JTF_VARCHAR2_TABLE_300();

Line 335: a3 := JTF_VARCHAR2_TABLE_100();

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();
337: a5 := JTF_NUMBER_TABLE();
338: a6 := JTF_VARCHAR2_TABLE_300();
339: a7 := JTF_NUMBER_TABLE();

Line 340: a8 := 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();
344: a12 := JTF_VARCHAR2_TABLE_100();

Line 341: a9 := JTF_VARCHAR2_TABLE_100();

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();
344: a12 := JTF_VARCHAR2_TABLE_100();
345: a13 := JTF_VARCHAR2_TABLE_100();

Line 342: a10 := JTF_VARCHAR2_TABLE_100();

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();
344: a12 := JTF_VARCHAR2_TABLE_100();
345: a13 := JTF_VARCHAR2_TABLE_100();
346: a14 := JTF_NUMBER_TABLE();

Line 344: a12 := JTF_VARCHAR2_TABLE_100();

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
348: a0.extend(t.count);

Line 345: a13 := 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
348: a0.extend(t.count);
349: a1.extend(t.count);

Line 392: , p1_a0 JTF_VARCHAR2_TABLE_100

388: end if;
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

Line 396: , p3_a1 JTF_VARCHAR2_TABLE_100

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
400: , p3_a5 JTF_NUMBER_TABLE

Line 398: , p3_a3 JTF_VARCHAR2_TABLE_100

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
400: , p3_a5 JTF_NUMBER_TABLE
401: , p3_a6 JTF_VARCHAR2_TABLE_100
402: , p3_a7 JTF_DATE_TABLE

Line 399: , p3_a4 JTF_VARCHAR2_TABLE_100

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
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

Line 401: , p3_a6 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
405: , p3_a10 JTF_VARCHAR2_TABLE_100

Line 405: , p3_a10 JTF_VARCHAR2_TABLE_100

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
409: , p3_a14 JTF_VARCHAR2_TABLE_100

Line 406: , p3_a11 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
409: , p3_a14 JTF_VARCHAR2_TABLE_100
410: , p3_a15 JTF_VARCHAR2_TABLE_100

Line 409: , p3_a14 JTF_VARCHAR2_TABLE_100

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
413: , p3_a18 JTF_VARCHAR2_TABLE_100

Line 410: , p3_a15 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
413: , p3_a18 JTF_VARCHAR2_TABLE_100
414: , p3_a19 JTF_VARCHAR2_TABLE_100

Line 411: , p3_a16 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
413: , p3_a18 JTF_VARCHAR2_TABLE_100
414: , p3_a19 JTF_VARCHAR2_TABLE_100
415: , p3_a20 JTF_NUMBER_TABLE

Line 413: , p3_a18 JTF_VARCHAR2_TABLE_100

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
417: , p3_a22 JTF_DATE_TABLE

Line 414: , p3_a19 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
417: , p3_a22 JTF_DATE_TABLE
418: , p4_a0 out nocopy JTF_NUMBER_TABLE

Line 419: , p4_a1 out nocopy 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
423: , p4_a5 out nocopy JTF_NUMBER_TABLE

Line 420: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100

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
423: , p4_a5 out nocopy JTF_NUMBER_TABLE
424: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_300

Line 421: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100

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
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

Line 426: , p4_a8 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
430: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 427: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100

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
430: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
431: , p4_a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 428: , p4_a10 out nocopy JTF_VARCHAR2_TABLE_100

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
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

Line 430: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100

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
434: , x_msg_count out nocopy NUMBER

Line 431: , p4_a13 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
434: , x_msg_count out nocopy NUMBER
435: , x_msg_data out nocopy VARCHAR2

Line 521: , p3_a1 in out nocopy JTF_VARCHAR2_TABLE_100

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
525: , p3_a5 in out nocopy JTF_NUMBER_TABLE

Line 522: , p3_a2 in out nocopy JTF_VARCHAR2_TABLE_100

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
525: , p3_a5 in out nocopy JTF_NUMBER_TABLE
526: , p3_a6 in out nocopy JTF_VARCHAR2_TABLE_300

Line 523: , p3_a3 in out nocopy JTF_VARCHAR2_TABLE_100

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
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

Line 528: , p3_a8 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
532: , p3_a12 in out nocopy JTF_VARCHAR2_TABLE_100

Line 529: , p3_a9 in out nocopy JTF_VARCHAR2_TABLE_100

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
532: , p3_a12 in out nocopy JTF_VARCHAR2_TABLE_100
533: , p3_a13 in out nocopy JTF_VARCHAR2_TABLE_100

Line 530: , p3_a10 in out nocopy JTF_VARCHAR2_TABLE_100

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
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

Line 532: , p3_a12 in out nocopy JTF_VARCHAR2_TABLE_100

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
536: , x_msg_count out nocopy NUMBER

Line 533: , p3_a13 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
536: , x_msg_count out nocopy NUMBER
537: , x_msg_data out nocopy VARCHAR2

Line 607: , p3_a1 JTF_VARCHAR2_TABLE_100

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
611: , p3_a5 JTF_NUMBER_TABLE

Line 608: , p3_a2 JTF_VARCHAR2_TABLE_100

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
611: , p3_a5 JTF_NUMBER_TABLE
612: , p3_a6 JTF_VARCHAR2_TABLE_300

Line 609: , p3_a3 JTF_VARCHAR2_TABLE_100

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
611: , p3_a5 JTF_NUMBER_TABLE
612: , p3_a6 JTF_VARCHAR2_TABLE_300
613: , p3_a7 JTF_NUMBER_TABLE

Line 614: , p3_a8 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
618: , p3_a12 JTF_VARCHAR2_TABLE_100

Line 615: , p3_a9 JTF_VARCHAR2_TABLE_100

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
618: , p3_a12 JTF_VARCHAR2_TABLE_100
619: , p3_a13 JTF_VARCHAR2_TABLE_100

Line 616: , p3_a10 JTF_VARCHAR2_TABLE_100

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
618: , p3_a12 JTF_VARCHAR2_TABLE_100
619: , p3_a13 JTF_VARCHAR2_TABLE_100
620: , p3_a14 JTF_NUMBER_TABLE

Line 618: , p3_a12 JTF_VARCHAR2_TABLE_100

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
622: , x_msg_count out nocopy NUMBER

Line 619: , p3_a13 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
622: , x_msg_count out nocopy NUMBER
623: , x_msg_data out nocopy VARCHAR2

Line 678: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100

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
682: , p4_a5 out nocopy JTF_NUMBER_TABLE

Line 679: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100

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
682: , p4_a5 out nocopy JTF_NUMBER_TABLE
683: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_300

Line 680: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100

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
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

Line 685: , p4_a8 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
689: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 686: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100

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
689: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
690: , p4_a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 687: , p4_a10 out nocopy JTF_VARCHAR2_TABLE_100

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
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

Line 689: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100

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
693: , x_msg_count out nocopy NUMBER

Line 690: , p4_a13 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
693: , x_msg_count out nocopy NUMBER
694: , x_msg_data out nocopy VARCHAR2

Line 750: , p3_a0 JTF_VARCHAR2_TABLE_100

746:
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

Line 755: , p6_a1 out nocopy 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
759: , p6_a5 out nocopy JTF_NUMBER_TABLE

Line 756: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

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
759: , p6_a5 out nocopy JTF_NUMBER_TABLE
760: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300

Line 757: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

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
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

Line 762: , p6_a8 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
766: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 763: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100

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
766: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
767: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 764: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100

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
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

Line 766: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100

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
770: , x_msg_count out nocopy NUMBER

Line 767: , p6_a13 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
770: , x_msg_count out nocopy NUMBER
771: , x_msg_data out nocopy VARCHAR2

Line 838: , p4_a0 JTF_VARCHAR2_TABLE_100

834: procedure processfees(p_init_msg_list VARCHAR2
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

Line 841: , p5_a1 JTF_VARCHAR2_TABLE_100

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
845: , p5_a5 JTF_NUMBER_TABLE

Line 843: , p5_a3 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
845: , p5_a5 JTF_NUMBER_TABLE
846: , p5_a6 JTF_VARCHAR2_TABLE_100
847: , p5_a7 JTF_DATE_TABLE

Line 844: , p5_a4 JTF_VARCHAR2_TABLE_100

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
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

Line 846: , p5_a6 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
850: , p5_a10 JTF_VARCHAR2_TABLE_100

Line 850: , p5_a10 JTF_VARCHAR2_TABLE_100

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
854: , p5_a14 JTF_VARCHAR2_TABLE_100

Line 851: , p5_a11 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
854: , p5_a14 JTF_VARCHAR2_TABLE_100
855: , p5_a15 JTF_VARCHAR2_TABLE_100

Line 854: , p5_a14 JTF_VARCHAR2_TABLE_100

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
858: , p5_a18 JTF_VARCHAR2_TABLE_100

Line 855: , p5_a15 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
858: , p5_a18 JTF_VARCHAR2_TABLE_100
859: , p5_a19 JTF_VARCHAR2_TABLE_100

Line 856: , p5_a16 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
858: , p5_a18 JTF_VARCHAR2_TABLE_100
859: , p5_a19 JTF_VARCHAR2_TABLE_100
860: , p5_a20 JTF_NUMBER_TABLE

Line 858: , p5_a18 JTF_VARCHAR2_TABLE_100

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
862: , p5_a22 JTF_DATE_TABLE

Line 859: , p5_a19 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
862: , p5_a22 JTF_DATE_TABLE
863: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 864: , p6_a1 out nocopy 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
868: , p6_a5 out nocopy JTF_NUMBER_TABLE

Line 865: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

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
868: , p6_a5 out nocopy JTF_NUMBER_TABLE
869: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300

Line 866: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

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
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

Line 871: , p6_a8 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
875: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 872: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100

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
875: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
876: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 873: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100

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
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

Line 875: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100

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
879: , x_msg_count out nocopy NUMBER

Line 876: , p6_a13 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
879: , x_msg_count out nocopy NUMBER
880: , x_msg_data out nocopy VARCHAR2