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.12010000.4 2010/02/24 01:45:44 mbolli ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy lns_fee_engine.fee_basis_tbl, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_NUMBER_TABLE
5: ) as
6: ddindx binary_integer; indx binary_integer;
7: begin

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: , a23 JTF_VARCHAR2_TABLE_100

Line 76: , a23 JTF_VARCHAR2_TABLE_100

72: , a19 JTF_VARCHAR2_TABLE_100
73: , a20 JTF_NUMBER_TABLE
74: , a21 JTF_NUMBER_TABLE
75: , a22 JTF_DATE_TABLE
76: , a23 JTF_VARCHAR2_TABLE_100
77: ) as
78: ddindx binary_integer; indx binary_integer;
79: begin
80: if a0 is not null and a0.count > 0 then

Line 119: , a1 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 121: , a3 out nocopy JTF_VARCHAR2_TABLE_100

117: end rosetta_table_copy_in_p3;
118: procedure rosetta_table_copy_out_p3(t lns_fee_engine.fee_structure_tbl, a0 out nocopy JTF_NUMBER_TABLE
119: , a1 out nocopy JTF_VARCHAR2_TABLE_100
120: , a2 out nocopy JTF_VARCHAR2_TABLE_300
121: , a3 out nocopy JTF_VARCHAR2_TABLE_100
122: , a4 out nocopy JTF_VARCHAR2_TABLE_100
123: , a5 out nocopy JTF_NUMBER_TABLE
124: , a6 out nocopy JTF_VARCHAR2_TABLE_100
125: , a7 out nocopy JTF_DATE_TABLE

Line 122: , a4 out nocopy JTF_VARCHAR2_TABLE_100

118: procedure rosetta_table_copy_out_p3(t lns_fee_engine.fee_structure_tbl, a0 out nocopy JTF_NUMBER_TABLE
119: , a1 out nocopy JTF_VARCHAR2_TABLE_100
120: , a2 out nocopy JTF_VARCHAR2_TABLE_300
121: , a3 out nocopy JTF_VARCHAR2_TABLE_100
122: , a4 out nocopy JTF_VARCHAR2_TABLE_100
123: , a5 out nocopy JTF_NUMBER_TABLE
124: , a6 out nocopy JTF_VARCHAR2_TABLE_100
125: , a7 out nocopy JTF_DATE_TABLE
126: , a8 out nocopy JTF_DATE_TABLE

Line 124: , a6 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 128: , a10 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 129: , a11 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 132: , a14 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 133: , a15 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 134: , a16 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 136: , a18 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 137: , a19 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 141: , a23 out nocopy JTF_VARCHAR2_TABLE_100

137: , a19 out nocopy JTF_VARCHAR2_TABLE_100
138: , a20 out nocopy JTF_NUMBER_TABLE
139: , a21 out nocopy JTF_NUMBER_TABLE
140: , a22 out nocopy JTF_DATE_TABLE
141: , a23 out nocopy JTF_VARCHAR2_TABLE_100
142: ) as
143: ddindx binary_integer; indx binary_integer;
144: begin
145: if t is null or t.count = 0 then

Line 147: a1 := JTF_VARCHAR2_TABLE_100();

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

Line 149: a3 := JTF_VARCHAR2_TABLE_100();

145: if t is null or t.count = 0 then
146: a0 := JTF_NUMBER_TABLE();
147: a1 := JTF_VARCHAR2_TABLE_100();
148: a2 := JTF_VARCHAR2_TABLE_300();
149: a3 := JTF_VARCHAR2_TABLE_100();
150: a4 := JTF_VARCHAR2_TABLE_100();
151: a5 := JTF_NUMBER_TABLE();
152: a6 := JTF_VARCHAR2_TABLE_100();
153: a7 := JTF_DATE_TABLE();

Line 150: a4 := JTF_VARCHAR2_TABLE_100();

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

Line 152: a6 := JTF_VARCHAR2_TABLE_100();

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

Line 156: a10 := JTF_VARCHAR2_TABLE_100();

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

Line 157: a11 := JTF_VARCHAR2_TABLE_100();

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

Line 160: a14 := JTF_VARCHAR2_TABLE_100();

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

Line 161: a15 := JTF_VARCHAR2_TABLE_100();

157: a11 := JTF_VARCHAR2_TABLE_100();
158: a12 := JTF_NUMBER_TABLE();
159: a13 := JTF_NUMBER_TABLE();
160: a14 := JTF_VARCHAR2_TABLE_100();
161: a15 := JTF_VARCHAR2_TABLE_100();
162: a16 := JTF_VARCHAR2_TABLE_100();
163: a17 := JTF_NUMBER_TABLE();
164: a18 := JTF_VARCHAR2_TABLE_100();
165: a19 := JTF_VARCHAR2_TABLE_100();

Line 162: a16 := JTF_VARCHAR2_TABLE_100();

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

Line 164: a18 := JTF_VARCHAR2_TABLE_100();

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

Line 165: a19 := JTF_VARCHAR2_TABLE_100();

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

Line 169: a23 := JTF_VARCHAR2_TABLE_100();

165: a19 := JTF_VARCHAR2_TABLE_100();
166: a20 := JTF_NUMBER_TABLE();
167: a21 := JTF_NUMBER_TABLE();
168: a22 := JTF_DATE_TABLE();
169: a23 := JTF_VARCHAR2_TABLE_100();
170: else
171: a0 := JTF_NUMBER_TABLE();
172: a1 := JTF_VARCHAR2_TABLE_100();
173: a2 := JTF_VARCHAR2_TABLE_300();

Line 172: a1 := JTF_VARCHAR2_TABLE_100();

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

Line 174: a3 := JTF_VARCHAR2_TABLE_100();

170: else
171: a0 := JTF_NUMBER_TABLE();
172: a1 := JTF_VARCHAR2_TABLE_100();
173: a2 := JTF_VARCHAR2_TABLE_300();
174: a3 := JTF_VARCHAR2_TABLE_100();
175: a4 := JTF_VARCHAR2_TABLE_100();
176: a5 := JTF_NUMBER_TABLE();
177: a6 := JTF_VARCHAR2_TABLE_100();
178: a7 := JTF_DATE_TABLE();

Line 175: a4 := JTF_VARCHAR2_TABLE_100();

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

Line 177: a6 := JTF_VARCHAR2_TABLE_100();

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

Line 181: a10 := JTF_VARCHAR2_TABLE_100();

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

Line 182: a11 := JTF_VARCHAR2_TABLE_100();

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

Line 185: a14 := JTF_VARCHAR2_TABLE_100();

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

Line 186: a15 := JTF_VARCHAR2_TABLE_100();

182: a11 := JTF_VARCHAR2_TABLE_100();
183: a12 := JTF_NUMBER_TABLE();
184: a13 := JTF_NUMBER_TABLE();
185: a14 := JTF_VARCHAR2_TABLE_100();
186: a15 := JTF_VARCHAR2_TABLE_100();
187: a16 := JTF_VARCHAR2_TABLE_100();
188: a17 := JTF_NUMBER_TABLE();
189: a18 := JTF_VARCHAR2_TABLE_100();
190: a19 := JTF_VARCHAR2_TABLE_100();

Line 187: a16 := JTF_VARCHAR2_TABLE_100();

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

Line 189: a18 := JTF_VARCHAR2_TABLE_100();

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

Line 190: a19 := JTF_VARCHAR2_TABLE_100();

186: a15 := JTF_VARCHAR2_TABLE_100();
187: a16 := JTF_VARCHAR2_TABLE_100();
188: a17 := JTF_NUMBER_TABLE();
189: a18 := JTF_VARCHAR2_TABLE_100();
190: a19 := JTF_VARCHAR2_TABLE_100();
191: a20 := JTF_NUMBER_TABLE();
192: a21 := JTF_NUMBER_TABLE();
193: a22 := JTF_DATE_TABLE();
194: a23 := JTF_VARCHAR2_TABLE_100();

Line 194: a23 := JTF_VARCHAR2_TABLE_100();

190: a19 := JTF_VARCHAR2_TABLE_100();
191: a20 := JTF_NUMBER_TABLE();
192: a21 := JTF_NUMBER_TABLE();
193: a22 := JTF_DATE_TABLE();
194: a23 := JTF_VARCHAR2_TABLE_100();
195: if t.count > 0 then
196: a0.extend(t.count);
197: a1.extend(t.count);
198: a2.extend(t.count);

Line 258: , a1 JTF_VARCHAR2_TABLE_100

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

Line 259: , a2 JTF_VARCHAR2_TABLE_100

255: end rosetta_table_copy_out_p3;
256:
257: procedure rosetta_table_copy_in_p5(t out nocopy lns_fee_engine.fee_calc_tbl, a0 JTF_NUMBER_TABLE
258: , a1 JTF_VARCHAR2_TABLE_100
259: , a2 JTF_VARCHAR2_TABLE_100
260: , a3 JTF_VARCHAR2_TABLE_100
261: , a4 JTF_NUMBER_TABLE
262: , a5 JTF_NUMBER_TABLE
263: , a6 JTF_VARCHAR2_TABLE_300

Line 260: , a3 JTF_VARCHAR2_TABLE_100

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

Line 265: , a8 JTF_VARCHAR2_TABLE_100

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

Line 266: , a9 JTF_VARCHAR2_TABLE_100

262: , a5 JTF_NUMBER_TABLE
263: , a6 JTF_VARCHAR2_TABLE_300
264: , a7 JTF_NUMBER_TABLE
265: , a8 JTF_VARCHAR2_TABLE_100
266: , a9 JTF_VARCHAR2_TABLE_100
267: , a10 JTF_VARCHAR2_TABLE_100
268: , a11 JTF_NUMBER_TABLE
269: , a12 JTF_VARCHAR2_TABLE_100
270: , a13 JTF_VARCHAR2_TABLE_100

Line 267: , a10 JTF_VARCHAR2_TABLE_100

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

Line 269: , a12 JTF_VARCHAR2_TABLE_100

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

Line 270: , a13 JTF_VARCHAR2_TABLE_100

266: , a9 JTF_VARCHAR2_TABLE_100
267: , a10 JTF_VARCHAR2_TABLE_100
268: , a11 JTF_NUMBER_TABLE
269: , a12 JTF_VARCHAR2_TABLE_100
270: , a13 JTF_VARCHAR2_TABLE_100
271: , a14 JTF_NUMBER_TABLE
272: , a15 JTF_VARCHAR2_TABLE_100
273: , a16 JTF_VARCHAR2_TABLE_100
274: ) as

Line 272: , a15 JTF_VARCHAR2_TABLE_100

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

Line 273: , a16 JTF_VARCHAR2_TABLE_100

269: , a12 JTF_VARCHAR2_TABLE_100
270: , a13 JTF_VARCHAR2_TABLE_100
271: , a14 JTF_NUMBER_TABLE
272: , a15 JTF_VARCHAR2_TABLE_100
273: , a16 JTF_VARCHAR2_TABLE_100
274: ) as
275: ddindx binary_integer; indx binary_integer;
276: begin
277: if a0 is not null and a0.count > 0 then

Line 309: , a1 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 310: , a2 out nocopy JTF_VARCHAR2_TABLE_100

306: end if;
307: end rosetta_table_copy_in_p5;
308: procedure rosetta_table_copy_out_p5(t lns_fee_engine.fee_calc_tbl, a0 out nocopy JTF_NUMBER_TABLE
309: , a1 out nocopy JTF_VARCHAR2_TABLE_100
310: , a2 out nocopy JTF_VARCHAR2_TABLE_100
311: , a3 out nocopy JTF_VARCHAR2_TABLE_100
312: , a4 out nocopy JTF_NUMBER_TABLE
313: , a5 out nocopy JTF_NUMBER_TABLE
314: , a6 out nocopy JTF_VARCHAR2_TABLE_300

Line 311: , a3 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 316: , a8 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 317: , a9 out nocopy JTF_VARCHAR2_TABLE_100

313: , a5 out nocopy JTF_NUMBER_TABLE
314: , a6 out nocopy JTF_VARCHAR2_TABLE_300
315: , a7 out nocopy JTF_NUMBER_TABLE
316: , a8 out nocopy JTF_VARCHAR2_TABLE_100
317: , a9 out nocopy JTF_VARCHAR2_TABLE_100
318: , a10 out nocopy JTF_VARCHAR2_TABLE_100
319: , a11 out nocopy JTF_NUMBER_TABLE
320: , a12 out nocopy JTF_VARCHAR2_TABLE_100
321: , a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 318: , a10 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 320: , a12 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 321: , a13 out nocopy JTF_VARCHAR2_TABLE_100

317: , a9 out nocopy JTF_VARCHAR2_TABLE_100
318: , a10 out nocopy JTF_VARCHAR2_TABLE_100
319: , a11 out nocopy JTF_NUMBER_TABLE
320: , a12 out nocopy JTF_VARCHAR2_TABLE_100
321: , a13 out nocopy JTF_VARCHAR2_TABLE_100
322: , a14 out nocopy JTF_NUMBER_TABLE
323: , a15 out nocopy JTF_VARCHAR2_TABLE_100
324: , a16 out nocopy JTF_VARCHAR2_TABLE_100
325: ) as

Line 323: , a15 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 324: , a16 out nocopy JTF_VARCHAR2_TABLE_100

320: , a12 out nocopy JTF_VARCHAR2_TABLE_100
321: , a13 out nocopy JTF_VARCHAR2_TABLE_100
322: , a14 out nocopy JTF_NUMBER_TABLE
323: , a15 out nocopy JTF_VARCHAR2_TABLE_100
324: , a16 out nocopy JTF_VARCHAR2_TABLE_100
325: ) as
326: ddindx binary_integer; indx binary_integer;
327: begin
328: if t is null or t.count = 0 then

Line 330: a1 := JTF_VARCHAR2_TABLE_100();

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

Line 331: a2 := JTF_VARCHAR2_TABLE_100();

327: begin
328: if t is null or t.count = 0 then
329: a0 := JTF_NUMBER_TABLE();
330: a1 := JTF_VARCHAR2_TABLE_100();
331: a2 := JTF_VARCHAR2_TABLE_100();
332: a3 := JTF_VARCHAR2_TABLE_100();
333: a4 := JTF_NUMBER_TABLE();
334: a5 := JTF_NUMBER_TABLE();
335: a6 := JTF_VARCHAR2_TABLE_300();

Line 332: a3 := JTF_VARCHAR2_TABLE_100();

328: if t is null or t.count = 0 then
329: a0 := JTF_NUMBER_TABLE();
330: a1 := JTF_VARCHAR2_TABLE_100();
331: a2 := JTF_VARCHAR2_TABLE_100();
332: a3 := JTF_VARCHAR2_TABLE_100();
333: a4 := JTF_NUMBER_TABLE();
334: a5 := JTF_NUMBER_TABLE();
335: a6 := JTF_VARCHAR2_TABLE_300();
336: a7 := JTF_NUMBER_TABLE();

Line 337: a8 := JTF_VARCHAR2_TABLE_100();

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

Line 338: a9 := JTF_VARCHAR2_TABLE_100();

334: a5 := JTF_NUMBER_TABLE();
335: a6 := JTF_VARCHAR2_TABLE_300();
336: a7 := JTF_NUMBER_TABLE();
337: a8 := JTF_VARCHAR2_TABLE_100();
338: a9 := JTF_VARCHAR2_TABLE_100();
339: a10 := JTF_VARCHAR2_TABLE_100();
340: a11 := JTF_NUMBER_TABLE();
341: a12 := JTF_VARCHAR2_TABLE_100();
342: a13 := JTF_VARCHAR2_TABLE_100();

Line 339: a10 := JTF_VARCHAR2_TABLE_100();

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

Line 341: a12 := JTF_VARCHAR2_TABLE_100();

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

Line 342: a13 := JTF_VARCHAR2_TABLE_100();

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

Line 344: a15 := JTF_VARCHAR2_TABLE_100();

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

Line 345: a16 := JTF_VARCHAR2_TABLE_100();

341: a12 := JTF_VARCHAR2_TABLE_100();
342: a13 := JTF_VARCHAR2_TABLE_100();
343: a14 := JTF_NUMBER_TABLE();
344: a15 := JTF_VARCHAR2_TABLE_100();
345: a16 := JTF_VARCHAR2_TABLE_100();
346: else
347: a0 := JTF_NUMBER_TABLE();
348: a1 := JTF_VARCHAR2_TABLE_100();
349: a2 := JTF_VARCHAR2_TABLE_100();

Line 348: a1 := JTF_VARCHAR2_TABLE_100();

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

Line 349: a2 := JTF_VARCHAR2_TABLE_100();

345: a16 := JTF_VARCHAR2_TABLE_100();
346: else
347: a0 := JTF_NUMBER_TABLE();
348: a1 := JTF_VARCHAR2_TABLE_100();
349: a2 := JTF_VARCHAR2_TABLE_100();
350: a3 := JTF_VARCHAR2_TABLE_100();
351: a4 := JTF_NUMBER_TABLE();
352: a5 := JTF_NUMBER_TABLE();
353: a6 := JTF_VARCHAR2_TABLE_300();

Line 350: a3 := JTF_VARCHAR2_TABLE_100();

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

Line 355: a8 := JTF_VARCHAR2_TABLE_100();

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

Line 356: a9 := JTF_VARCHAR2_TABLE_100();

352: a5 := JTF_NUMBER_TABLE();
353: a6 := JTF_VARCHAR2_TABLE_300();
354: a7 := JTF_NUMBER_TABLE();
355: a8 := JTF_VARCHAR2_TABLE_100();
356: a9 := JTF_VARCHAR2_TABLE_100();
357: a10 := JTF_VARCHAR2_TABLE_100();
358: a11 := JTF_NUMBER_TABLE();
359: a12 := JTF_VARCHAR2_TABLE_100();
360: a13 := JTF_VARCHAR2_TABLE_100();

Line 357: a10 := JTF_VARCHAR2_TABLE_100();

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

Line 359: a12 := JTF_VARCHAR2_TABLE_100();

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

Line 360: a13 := JTF_VARCHAR2_TABLE_100();

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

Line 362: a15 := JTF_VARCHAR2_TABLE_100();

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

Line 363: a16 := JTF_VARCHAR2_TABLE_100();

359: a12 := JTF_VARCHAR2_TABLE_100();
360: a13 := JTF_VARCHAR2_TABLE_100();
361: a14 := JTF_NUMBER_TABLE();
362: a15 := JTF_VARCHAR2_TABLE_100();
363: a16 := JTF_VARCHAR2_TABLE_100();
364: if t.count > 0 then
365: a0.extend(t.count);
366: a1.extend(t.count);
367: a2.extend(t.count);

Line 413: , p1_a0 JTF_VARCHAR2_TABLE_100

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

Line 417: , p3_a1 JTF_VARCHAR2_TABLE_100

413: , p1_a0 JTF_VARCHAR2_TABLE_100
414: , p1_a1 JTF_NUMBER_TABLE
415: , p_installment NUMBER
416: , p3_a0 JTF_NUMBER_TABLE
417: , p3_a1 JTF_VARCHAR2_TABLE_100
418: , p3_a2 JTF_VARCHAR2_TABLE_300
419: , p3_a3 JTF_VARCHAR2_TABLE_100
420: , p3_a4 JTF_VARCHAR2_TABLE_100
421: , p3_a5 JTF_NUMBER_TABLE

Line 419: , p3_a3 JTF_VARCHAR2_TABLE_100

415: , p_installment NUMBER
416: , p3_a0 JTF_NUMBER_TABLE
417: , p3_a1 JTF_VARCHAR2_TABLE_100
418: , p3_a2 JTF_VARCHAR2_TABLE_300
419: , p3_a3 JTF_VARCHAR2_TABLE_100
420: , p3_a4 JTF_VARCHAR2_TABLE_100
421: , p3_a5 JTF_NUMBER_TABLE
422: , p3_a6 JTF_VARCHAR2_TABLE_100
423: , p3_a7 JTF_DATE_TABLE

Line 420: , p3_a4 JTF_VARCHAR2_TABLE_100

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

Line 422: , p3_a6 JTF_VARCHAR2_TABLE_100

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

Line 426: , p3_a10 JTF_VARCHAR2_TABLE_100

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

Line 427: , p3_a11 JTF_VARCHAR2_TABLE_100

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

Line 430: , p3_a14 JTF_VARCHAR2_TABLE_100

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

Line 431: , p3_a15 JTF_VARCHAR2_TABLE_100

427: , p3_a11 JTF_VARCHAR2_TABLE_100
428: , p3_a12 JTF_NUMBER_TABLE
429: , p3_a13 JTF_NUMBER_TABLE
430: , p3_a14 JTF_VARCHAR2_TABLE_100
431: , p3_a15 JTF_VARCHAR2_TABLE_100
432: , p3_a16 JTF_VARCHAR2_TABLE_100
433: , p3_a17 JTF_NUMBER_TABLE
434: , p3_a18 JTF_VARCHAR2_TABLE_100
435: , p3_a19 JTF_VARCHAR2_TABLE_100

Line 432: , p3_a16 JTF_VARCHAR2_TABLE_100

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

Line 434: , p3_a18 JTF_VARCHAR2_TABLE_100

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

Line 435: , p3_a19 JTF_VARCHAR2_TABLE_100

431: , p3_a15 JTF_VARCHAR2_TABLE_100
432: , p3_a16 JTF_VARCHAR2_TABLE_100
433: , p3_a17 JTF_NUMBER_TABLE
434: , p3_a18 JTF_VARCHAR2_TABLE_100
435: , p3_a19 JTF_VARCHAR2_TABLE_100
436: , p3_a20 JTF_NUMBER_TABLE
437: , p3_a21 JTF_NUMBER_TABLE
438: , p3_a22 JTF_DATE_TABLE
439: , p3_a23 JTF_VARCHAR2_TABLE_100

Line 439: , p3_a23 JTF_VARCHAR2_TABLE_100

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

Line 441: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 442: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100

438: , p3_a22 JTF_DATE_TABLE
439: , p3_a23 JTF_VARCHAR2_TABLE_100
440: , p4_a0 out nocopy JTF_NUMBER_TABLE
441: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
442: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
443: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
444: , p4_a4 out nocopy JTF_NUMBER_TABLE
445: , p4_a5 out nocopy JTF_NUMBER_TABLE
446: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_300

Line 443: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 448: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 449: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100

445: , p4_a5 out nocopy JTF_NUMBER_TABLE
446: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_300
447: , p4_a7 out nocopy JTF_NUMBER_TABLE
448: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
449: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
450: , p4_a10 out nocopy JTF_VARCHAR2_TABLE_100
451: , p4_a11 out nocopy JTF_NUMBER_TABLE
452: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
453: , p4_a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 450: , p4_a10 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 452: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 453: , p4_a13 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 455: , p4_a15 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 456: , p4_a16 out nocopy JTF_VARCHAR2_TABLE_100

452: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
453: , p4_a13 out nocopy JTF_VARCHAR2_TABLE_100
454: , p4_a14 out nocopy JTF_NUMBER_TABLE
455: , p4_a15 out nocopy JTF_VARCHAR2_TABLE_100
456: , p4_a16 out nocopy JTF_VARCHAR2_TABLE_100
457: , x_return_status out nocopy VARCHAR2
458: , x_msg_count out nocopy NUMBER
459: , x_msg_data out nocopy VARCHAR2
460: )

Line 548: , p3_a1 in out nocopy JTF_VARCHAR2_TABLE_100

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

Line 549: , p3_a2 in out nocopy JTF_VARCHAR2_TABLE_100

545: , p_commit VARCHAR2
546: , p_loan_id NUMBER
547: , p3_a0 in out nocopy JTF_NUMBER_TABLE
548: , p3_a1 in out nocopy JTF_VARCHAR2_TABLE_100
549: , p3_a2 in out nocopy JTF_VARCHAR2_TABLE_100
550: , p3_a3 in out nocopy JTF_VARCHAR2_TABLE_100
551: , p3_a4 in out nocopy JTF_NUMBER_TABLE
552: , p3_a5 in out nocopy JTF_NUMBER_TABLE
553: , p3_a6 in out nocopy JTF_VARCHAR2_TABLE_300

Line 550: , p3_a3 in out nocopy JTF_VARCHAR2_TABLE_100

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

Line 555: , p3_a8 in out nocopy JTF_VARCHAR2_TABLE_100

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

Line 556: , p3_a9 in out nocopy JTF_VARCHAR2_TABLE_100

552: , p3_a5 in out nocopy JTF_NUMBER_TABLE
553: , p3_a6 in out nocopy JTF_VARCHAR2_TABLE_300
554: , p3_a7 in out nocopy JTF_NUMBER_TABLE
555: , p3_a8 in out nocopy JTF_VARCHAR2_TABLE_100
556: , p3_a9 in out nocopy JTF_VARCHAR2_TABLE_100
557: , p3_a10 in out nocopy JTF_VARCHAR2_TABLE_100
558: , p3_a11 in out nocopy JTF_NUMBER_TABLE
559: , p3_a12 in out nocopy JTF_VARCHAR2_TABLE_100
560: , p3_a13 in out nocopy JTF_VARCHAR2_TABLE_100

Line 557: , p3_a10 in out nocopy JTF_VARCHAR2_TABLE_100

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

Line 559: , p3_a12 in out nocopy JTF_VARCHAR2_TABLE_100

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

Line 560: , p3_a13 in out nocopy JTF_VARCHAR2_TABLE_100

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

Line 562: , p3_a15 in out nocopy JTF_VARCHAR2_TABLE_100

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

Line 563: , p3_a16 in out nocopy JTF_VARCHAR2_TABLE_100

559: , p3_a12 in out nocopy JTF_VARCHAR2_TABLE_100
560: , p3_a13 in out nocopy JTF_VARCHAR2_TABLE_100
561: , p3_a14 in out nocopy JTF_NUMBER_TABLE
562: , p3_a15 in out nocopy JTF_VARCHAR2_TABLE_100
563: , p3_a16 in out nocopy JTF_VARCHAR2_TABLE_100
564: , x_return_status out nocopy VARCHAR2
565: , x_msg_count out nocopy NUMBER
566: , x_msg_data out nocopy VARCHAR2
567: )

Line 640: , p3_a1 JTF_VARCHAR2_TABLE_100

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

Line 641: , p3_a2 JTF_VARCHAR2_TABLE_100

637: , p_commit VARCHAR2
638: , p_loan_id NUMBER
639: , p3_a0 JTF_NUMBER_TABLE
640: , p3_a1 JTF_VARCHAR2_TABLE_100
641: , p3_a2 JTF_VARCHAR2_TABLE_100
642: , p3_a3 JTF_VARCHAR2_TABLE_100
643: , p3_a4 JTF_NUMBER_TABLE
644: , p3_a5 JTF_NUMBER_TABLE
645: , p3_a6 JTF_VARCHAR2_TABLE_300

Line 642: , p3_a3 JTF_VARCHAR2_TABLE_100

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

Line 647: , p3_a8 JTF_VARCHAR2_TABLE_100

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

Line 648: , p3_a9 JTF_VARCHAR2_TABLE_100

644: , p3_a5 JTF_NUMBER_TABLE
645: , p3_a6 JTF_VARCHAR2_TABLE_300
646: , p3_a7 JTF_NUMBER_TABLE
647: , p3_a8 JTF_VARCHAR2_TABLE_100
648: , p3_a9 JTF_VARCHAR2_TABLE_100
649: , p3_a10 JTF_VARCHAR2_TABLE_100
650: , p3_a11 JTF_NUMBER_TABLE
651: , p3_a12 JTF_VARCHAR2_TABLE_100
652: , p3_a13 JTF_VARCHAR2_TABLE_100

Line 649: , p3_a10 JTF_VARCHAR2_TABLE_100

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

Line 651: , p3_a12 JTF_VARCHAR2_TABLE_100

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

Line 652: , p3_a13 JTF_VARCHAR2_TABLE_100

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

Line 654: , p3_a15 JTF_VARCHAR2_TABLE_100

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

Line 655: , p3_a16 JTF_VARCHAR2_TABLE_100

651: , p3_a12 JTF_VARCHAR2_TABLE_100
652: , p3_a13 JTF_VARCHAR2_TABLE_100
653: , p3_a14 JTF_NUMBER_TABLE
654: , p3_a15 JTF_VARCHAR2_TABLE_100
655: , p3_a16 JTF_VARCHAR2_TABLE_100
656: , x_return_status out nocopy VARCHAR2
657: , x_msg_count out nocopy NUMBER
658: , x_msg_data out nocopy VARCHAR2
659: )

Line 716: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 717: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100

713: , p_disb_header_id NUMBER
714: , p_phase VARCHAR2
715: , p5_a0 out nocopy JTF_NUMBER_TABLE
716: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_100
717: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
718: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
719: , p5_a4 out nocopy JTF_NUMBER_TABLE
720: , p5_a5 out nocopy JTF_NUMBER_TABLE
721: , p5_a6 out nocopy JTF_VARCHAR2_TABLE_300

Line 718: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 723: , p5_a8 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 724: , p5_a9 out nocopy JTF_VARCHAR2_TABLE_100

720: , p5_a5 out nocopy JTF_NUMBER_TABLE
721: , p5_a6 out nocopy JTF_VARCHAR2_TABLE_300
722: , p5_a7 out nocopy JTF_NUMBER_TABLE
723: , p5_a8 out nocopy JTF_VARCHAR2_TABLE_100
724: , p5_a9 out nocopy JTF_VARCHAR2_TABLE_100
725: , p5_a10 out nocopy JTF_VARCHAR2_TABLE_100
726: , p5_a11 out nocopy JTF_NUMBER_TABLE
727: , p5_a12 out nocopy JTF_VARCHAR2_TABLE_100
728: , p5_a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 725: , p5_a10 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 727: , p5_a12 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 728: , p5_a13 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 730: , p5_a15 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 731: , p5_a16 out nocopy JTF_VARCHAR2_TABLE_100

727: , p5_a12 out nocopy JTF_VARCHAR2_TABLE_100
728: , p5_a13 out nocopy JTF_VARCHAR2_TABLE_100
729: , p5_a14 out nocopy JTF_NUMBER_TABLE
730: , p5_a15 out nocopy JTF_VARCHAR2_TABLE_100
731: , p5_a16 out nocopy JTF_VARCHAR2_TABLE_100
732: , x_return_status out nocopy VARCHAR2
733: , x_msg_count out nocopy NUMBER
734: , x_msg_data out nocopy VARCHAR2
735: )

Line 795: , p3_a0 JTF_VARCHAR2_TABLE_100

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

Line 800: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 801: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

797: , p_based_on_terms VARCHAR2
798: , p_phase VARCHAR2
799: , p6_a0 out nocopy JTF_NUMBER_TABLE
800: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
801: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
802: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
803: , p6_a4 out nocopy JTF_NUMBER_TABLE
804: , p6_a5 out nocopy JTF_NUMBER_TABLE
805: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300

Line 802: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 807: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 808: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100

804: , p6_a5 out nocopy JTF_NUMBER_TABLE
805: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
806: , p6_a7 out nocopy JTF_NUMBER_TABLE
807: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
808: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
809: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
810: , p6_a11 out nocopy JTF_NUMBER_TABLE
811: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
812: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 809: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 811: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 812: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 814: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 815: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100

811: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
812: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
813: , p6_a14 out nocopy JTF_NUMBER_TABLE
814: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
815: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
816: , x_return_status out nocopy VARCHAR2
817: , x_msg_count out nocopy NUMBER
818: , x_msg_data out nocopy VARCHAR2
819: )

Line 887: , p4_a0 JTF_VARCHAR2_TABLE_100

883: procedure processfees(p_init_msg_list VARCHAR2
884: , p_commit VARCHAR2
885: , p_loan_id NUMBER
886: , p_installment_number NUMBER
887: , p4_a0 JTF_VARCHAR2_TABLE_100
888: , p4_a1 JTF_NUMBER_TABLE
889: , p5_a0 JTF_NUMBER_TABLE
890: , p5_a1 JTF_VARCHAR2_TABLE_100
891: , p5_a2 JTF_VARCHAR2_TABLE_300

Line 890: , p5_a1 JTF_VARCHAR2_TABLE_100

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

Line 892: , p5_a3 JTF_VARCHAR2_TABLE_100

888: , p4_a1 JTF_NUMBER_TABLE
889: , p5_a0 JTF_NUMBER_TABLE
890: , p5_a1 JTF_VARCHAR2_TABLE_100
891: , p5_a2 JTF_VARCHAR2_TABLE_300
892: , p5_a3 JTF_VARCHAR2_TABLE_100
893: , p5_a4 JTF_VARCHAR2_TABLE_100
894: , p5_a5 JTF_NUMBER_TABLE
895: , p5_a6 JTF_VARCHAR2_TABLE_100
896: , p5_a7 JTF_DATE_TABLE

Line 893: , p5_a4 JTF_VARCHAR2_TABLE_100

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

Line 895: , p5_a6 JTF_VARCHAR2_TABLE_100

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

Line 899: , p5_a10 JTF_VARCHAR2_TABLE_100

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

Line 900: , p5_a11 JTF_VARCHAR2_TABLE_100

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

Line 903: , p5_a14 JTF_VARCHAR2_TABLE_100

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

Line 904: , p5_a15 JTF_VARCHAR2_TABLE_100

900: , p5_a11 JTF_VARCHAR2_TABLE_100
901: , p5_a12 JTF_NUMBER_TABLE
902: , p5_a13 JTF_NUMBER_TABLE
903: , p5_a14 JTF_VARCHAR2_TABLE_100
904: , p5_a15 JTF_VARCHAR2_TABLE_100
905: , p5_a16 JTF_VARCHAR2_TABLE_100
906: , p5_a17 JTF_NUMBER_TABLE
907: , p5_a18 JTF_VARCHAR2_TABLE_100
908: , p5_a19 JTF_VARCHAR2_TABLE_100

Line 905: , p5_a16 JTF_VARCHAR2_TABLE_100

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

Line 907: , p5_a18 JTF_VARCHAR2_TABLE_100

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

Line 908: , p5_a19 JTF_VARCHAR2_TABLE_100

904: , p5_a15 JTF_VARCHAR2_TABLE_100
905: , p5_a16 JTF_VARCHAR2_TABLE_100
906: , p5_a17 JTF_NUMBER_TABLE
907: , p5_a18 JTF_VARCHAR2_TABLE_100
908: , p5_a19 JTF_VARCHAR2_TABLE_100
909: , p5_a20 JTF_NUMBER_TABLE
910: , p5_a21 JTF_NUMBER_TABLE
911: , p5_a22 JTF_DATE_TABLE
912: , p5_a23 JTF_VARCHAR2_TABLE_100

Line 912: , p5_a23 JTF_VARCHAR2_TABLE_100

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

Line 914: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 915: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

911: , p5_a22 JTF_DATE_TABLE
912: , p5_a23 JTF_VARCHAR2_TABLE_100
913: , p6_a0 out nocopy JTF_NUMBER_TABLE
914: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
915: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
916: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
917: , p6_a4 out nocopy JTF_NUMBER_TABLE
918: , p6_a5 out nocopy JTF_NUMBER_TABLE
919: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300

Line 916: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 921: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 922: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100

918: , p6_a5 out nocopy JTF_NUMBER_TABLE
919: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
920: , p6_a7 out nocopy JTF_NUMBER_TABLE
921: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
922: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
923: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
924: , p6_a11 out nocopy JTF_NUMBER_TABLE
925: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
926: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 923: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 925: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 926: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 928: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 929: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100

925: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
926: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
927: , p6_a14 out nocopy JTF_NUMBER_TABLE
928: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
929: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
930: , x_return_status out nocopy VARCHAR2
931: , x_msg_count out nocopy NUMBER
932: , x_msg_data out nocopy VARCHAR2
933: )

Line 1027: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 1028: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_100

1024: , p_loan_id NUMBER
1025: , p_billed_flag VARCHAR2
1026: , p3_a0 out nocopy JTF_NUMBER_TABLE
1027: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
1028: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_100
1029: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100
1030: , p3_a4 out nocopy JTF_NUMBER_TABLE
1031: , p3_a5 out nocopy JTF_NUMBER_TABLE
1032: , p3_a6 out nocopy JTF_VARCHAR2_TABLE_300

Line 1029: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 1034: , p3_a8 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 1035: , p3_a9 out nocopy JTF_VARCHAR2_TABLE_100

1031: , p3_a5 out nocopy JTF_NUMBER_TABLE
1032: , p3_a6 out nocopy JTF_VARCHAR2_TABLE_300
1033: , p3_a7 out nocopy JTF_NUMBER_TABLE
1034: , p3_a8 out nocopy JTF_VARCHAR2_TABLE_100
1035: , p3_a9 out nocopy JTF_VARCHAR2_TABLE_100
1036: , p3_a10 out nocopy JTF_VARCHAR2_TABLE_100
1037: , p3_a11 out nocopy JTF_NUMBER_TABLE
1038: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100
1039: , p3_a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 1036: , p3_a10 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 1038: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 1039: , p3_a13 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 1041: , p3_a15 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 1042: , p3_a16 out nocopy JTF_VARCHAR2_TABLE_100

1038: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100
1039: , p3_a13 out nocopy JTF_VARCHAR2_TABLE_100
1040: , p3_a14 out nocopy JTF_NUMBER_TABLE
1041: , p3_a15 out nocopy JTF_VARCHAR2_TABLE_100
1042: , p3_a16 out nocopy JTF_VARCHAR2_TABLE_100
1043: , x_return_status out nocopy VARCHAR2
1044: , x_msg_count out nocopy NUMBER
1045: , x_msg_data out nocopy VARCHAR2
1046: )