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_BILLING_BATCH_PUB_W dependencies on JTF_VARCHAR2_TABLE_100

Line 5: , a2 JTF_VARCHAR2_TABLE_100

1: package body lns_billing_batch_pub_w as
2: /* $Header: LNS_BILL_PUBJ_B.pls 120.5.12020000.2 2012/07/19 20:52:53 scherkas ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy lns_billing_batch_pub.loans_to_bill_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_300
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_DATE_TABLE

Line 11: , a8 JTF_VARCHAR2_TABLE_100

7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_VARCHAR2_TABLE_100

Line 12: , a9 JTF_VARCHAR2_TABLE_100

8: , a5 JTF_DATE_TABLE
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_NUMBER_TABLE

Line 15: , a12 JTF_VARCHAR2_TABLE_100

11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_NUMBER_TABLE

Line 17: , a14 JTF_VARCHAR2_TABLE_100

13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_NUMBER_TABLE

Line 18: , a15 JTF_VARCHAR2_TABLE_100

14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_NUMBER_TABLE

Line 27: , a24 JTF_VARCHAR2_TABLE_100

23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_VARCHAR2_TABLE_100
28: , a25 JTF_DATE_TABLE
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_NUMBER_TABLE

Line 32: , a29 JTF_VARCHAR2_TABLE_100

28: , a25 JTF_DATE_TABLE
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_VARCHAR2_TABLE_100
33: , a30 JTF_VARCHAR2_TABLE_100
34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_VARCHAR2_TABLE_100
36: , a33 JTF_NUMBER_TABLE

Line 33: , a30 JTF_VARCHAR2_TABLE_100

29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_VARCHAR2_TABLE_100
33: , a30 JTF_VARCHAR2_TABLE_100
34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_VARCHAR2_TABLE_100
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_NUMBER_TABLE

Line 35: , a32 JTF_VARCHAR2_TABLE_100

31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_VARCHAR2_TABLE_100
33: , a30 JTF_VARCHAR2_TABLE_100
34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_VARCHAR2_TABLE_100
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_NUMBER_TABLE
39: , a36 JTF_NUMBER_TABLE

Line 96: , a2 out nocopy JTF_VARCHAR2_TABLE_100

92: end if;
93: end rosetta_table_copy_in_p1;
94: procedure rosetta_table_copy_out_p1(t lns_billing_batch_pub.loans_to_bill_tbl, a0 out nocopy JTF_NUMBER_TABLE
95: , a1 out nocopy JTF_NUMBER_TABLE
96: , a2 out nocopy JTF_VARCHAR2_TABLE_100
97: , a3 out nocopy JTF_VARCHAR2_TABLE_300
98: , a4 out nocopy JTF_NUMBER_TABLE
99: , a5 out nocopy JTF_DATE_TABLE
100: , a6 out nocopy JTF_DATE_TABLE

Line 102: , a8 out nocopy JTF_VARCHAR2_TABLE_100

98: , a4 out nocopy JTF_NUMBER_TABLE
99: , a5 out nocopy JTF_DATE_TABLE
100: , a6 out nocopy JTF_DATE_TABLE
101: , a7 out nocopy JTF_DATE_TABLE
102: , a8 out nocopy JTF_VARCHAR2_TABLE_100
103: , a9 out nocopy JTF_VARCHAR2_TABLE_100
104: , a10 out nocopy JTF_NUMBER_TABLE
105: , a11 out nocopy JTF_NUMBER_TABLE
106: , a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 103: , a9 out nocopy JTF_VARCHAR2_TABLE_100

99: , a5 out nocopy JTF_DATE_TABLE
100: , a6 out nocopy JTF_DATE_TABLE
101: , a7 out nocopy JTF_DATE_TABLE
102: , a8 out nocopy JTF_VARCHAR2_TABLE_100
103: , a9 out nocopy JTF_VARCHAR2_TABLE_100
104: , a10 out nocopy JTF_NUMBER_TABLE
105: , a11 out nocopy JTF_NUMBER_TABLE
106: , a12 out nocopy JTF_VARCHAR2_TABLE_100
107: , a13 out nocopy JTF_NUMBER_TABLE

Line 106: , a12 out nocopy JTF_VARCHAR2_TABLE_100

102: , a8 out nocopy JTF_VARCHAR2_TABLE_100
103: , a9 out nocopy JTF_VARCHAR2_TABLE_100
104: , a10 out nocopy JTF_NUMBER_TABLE
105: , a11 out nocopy JTF_NUMBER_TABLE
106: , a12 out nocopy JTF_VARCHAR2_TABLE_100
107: , a13 out nocopy JTF_NUMBER_TABLE
108: , a14 out nocopy JTF_VARCHAR2_TABLE_100
109: , a15 out nocopy JTF_VARCHAR2_TABLE_100
110: , a16 out nocopy JTF_NUMBER_TABLE

Line 108: , a14 out nocopy JTF_VARCHAR2_TABLE_100

104: , a10 out nocopy JTF_NUMBER_TABLE
105: , a11 out nocopy JTF_NUMBER_TABLE
106: , a12 out nocopy JTF_VARCHAR2_TABLE_100
107: , a13 out nocopy JTF_NUMBER_TABLE
108: , a14 out nocopy JTF_VARCHAR2_TABLE_100
109: , a15 out nocopy JTF_VARCHAR2_TABLE_100
110: , a16 out nocopy JTF_NUMBER_TABLE
111: , a17 out nocopy JTF_NUMBER_TABLE
112: , a18 out nocopy JTF_NUMBER_TABLE

Line 109: , a15 out nocopy JTF_VARCHAR2_TABLE_100

105: , a11 out nocopy JTF_NUMBER_TABLE
106: , a12 out nocopy JTF_VARCHAR2_TABLE_100
107: , a13 out nocopy JTF_NUMBER_TABLE
108: , a14 out nocopy JTF_VARCHAR2_TABLE_100
109: , a15 out nocopy JTF_VARCHAR2_TABLE_100
110: , a16 out nocopy JTF_NUMBER_TABLE
111: , a17 out nocopy JTF_NUMBER_TABLE
112: , a18 out nocopy JTF_NUMBER_TABLE
113: , a19 out nocopy JTF_NUMBER_TABLE

Line 118: , a24 out nocopy JTF_VARCHAR2_TABLE_100

114: , a20 out nocopy JTF_NUMBER_TABLE
115: , a21 out nocopy JTF_NUMBER_TABLE
116: , a22 out nocopy JTF_NUMBER_TABLE
117: , a23 out nocopy JTF_NUMBER_TABLE
118: , a24 out nocopy JTF_VARCHAR2_TABLE_100
119: , a25 out nocopy JTF_DATE_TABLE
120: , a26 out nocopy JTF_NUMBER_TABLE
121: , a27 out nocopy JTF_NUMBER_TABLE
122: , a28 out nocopy JTF_NUMBER_TABLE

Line 123: , a29 out nocopy JTF_VARCHAR2_TABLE_100

119: , a25 out nocopy JTF_DATE_TABLE
120: , a26 out nocopy JTF_NUMBER_TABLE
121: , a27 out nocopy JTF_NUMBER_TABLE
122: , a28 out nocopy JTF_NUMBER_TABLE
123: , a29 out nocopy JTF_VARCHAR2_TABLE_100
124: , a30 out nocopy JTF_VARCHAR2_TABLE_100
125: , a31 out nocopy JTF_NUMBER_TABLE
126: , a32 out nocopy JTF_VARCHAR2_TABLE_100
127: , a33 out nocopy JTF_NUMBER_TABLE

Line 124: , a30 out nocopy JTF_VARCHAR2_TABLE_100

120: , a26 out nocopy JTF_NUMBER_TABLE
121: , a27 out nocopy JTF_NUMBER_TABLE
122: , a28 out nocopy JTF_NUMBER_TABLE
123: , a29 out nocopy JTF_VARCHAR2_TABLE_100
124: , a30 out nocopy JTF_VARCHAR2_TABLE_100
125: , a31 out nocopy JTF_NUMBER_TABLE
126: , a32 out nocopy JTF_VARCHAR2_TABLE_100
127: , a33 out nocopy JTF_NUMBER_TABLE
128: , a34 out nocopy JTF_NUMBER_TABLE

Line 126: , a32 out nocopy JTF_VARCHAR2_TABLE_100

122: , a28 out nocopy JTF_NUMBER_TABLE
123: , a29 out nocopy JTF_VARCHAR2_TABLE_100
124: , a30 out nocopy JTF_VARCHAR2_TABLE_100
125: , a31 out nocopy JTF_NUMBER_TABLE
126: , a32 out nocopy JTF_VARCHAR2_TABLE_100
127: , a33 out nocopy JTF_NUMBER_TABLE
128: , a34 out nocopy JTF_NUMBER_TABLE
129: , a35 out nocopy JTF_NUMBER_TABLE
130: , a36 out nocopy JTF_NUMBER_TABLE

Line 137: a2 := JTF_VARCHAR2_TABLE_100();

133: begin
134: if t is null or t.count = 0 then
135: a0 := JTF_NUMBER_TABLE();
136: a1 := JTF_NUMBER_TABLE();
137: a2 := JTF_VARCHAR2_TABLE_100();
138: a3 := JTF_VARCHAR2_TABLE_300();
139: a4 := JTF_NUMBER_TABLE();
140: a5 := JTF_DATE_TABLE();
141: a6 := JTF_DATE_TABLE();

Line 143: a8 := JTF_VARCHAR2_TABLE_100();

139: a4 := JTF_NUMBER_TABLE();
140: a5 := JTF_DATE_TABLE();
141: a6 := JTF_DATE_TABLE();
142: a7 := JTF_DATE_TABLE();
143: a8 := JTF_VARCHAR2_TABLE_100();
144: a9 := JTF_VARCHAR2_TABLE_100();
145: a10 := JTF_NUMBER_TABLE();
146: a11 := JTF_NUMBER_TABLE();
147: a12 := JTF_VARCHAR2_TABLE_100();

Line 144: a9 := JTF_VARCHAR2_TABLE_100();

140: a5 := JTF_DATE_TABLE();
141: a6 := JTF_DATE_TABLE();
142: a7 := JTF_DATE_TABLE();
143: a8 := JTF_VARCHAR2_TABLE_100();
144: a9 := JTF_VARCHAR2_TABLE_100();
145: a10 := JTF_NUMBER_TABLE();
146: a11 := JTF_NUMBER_TABLE();
147: a12 := JTF_VARCHAR2_TABLE_100();
148: a13 := JTF_NUMBER_TABLE();

Line 147: a12 := JTF_VARCHAR2_TABLE_100();

143: a8 := JTF_VARCHAR2_TABLE_100();
144: a9 := JTF_VARCHAR2_TABLE_100();
145: a10 := JTF_NUMBER_TABLE();
146: a11 := JTF_NUMBER_TABLE();
147: a12 := JTF_VARCHAR2_TABLE_100();
148: a13 := JTF_NUMBER_TABLE();
149: a14 := JTF_VARCHAR2_TABLE_100();
150: a15 := JTF_VARCHAR2_TABLE_100();
151: a16 := JTF_NUMBER_TABLE();

Line 149: a14 := JTF_VARCHAR2_TABLE_100();

145: a10 := JTF_NUMBER_TABLE();
146: a11 := JTF_NUMBER_TABLE();
147: a12 := JTF_VARCHAR2_TABLE_100();
148: a13 := JTF_NUMBER_TABLE();
149: a14 := JTF_VARCHAR2_TABLE_100();
150: a15 := JTF_VARCHAR2_TABLE_100();
151: a16 := JTF_NUMBER_TABLE();
152: a17 := JTF_NUMBER_TABLE();
153: a18 := JTF_NUMBER_TABLE();

Line 150: a15 := JTF_VARCHAR2_TABLE_100();

146: a11 := JTF_NUMBER_TABLE();
147: a12 := JTF_VARCHAR2_TABLE_100();
148: a13 := JTF_NUMBER_TABLE();
149: a14 := JTF_VARCHAR2_TABLE_100();
150: a15 := JTF_VARCHAR2_TABLE_100();
151: a16 := JTF_NUMBER_TABLE();
152: a17 := JTF_NUMBER_TABLE();
153: a18 := JTF_NUMBER_TABLE();
154: a19 := JTF_NUMBER_TABLE();

Line 159: a24 := JTF_VARCHAR2_TABLE_100();

155: a20 := JTF_NUMBER_TABLE();
156: a21 := JTF_NUMBER_TABLE();
157: a22 := JTF_NUMBER_TABLE();
158: a23 := JTF_NUMBER_TABLE();
159: a24 := JTF_VARCHAR2_TABLE_100();
160: a25 := JTF_DATE_TABLE();
161: a26 := JTF_NUMBER_TABLE();
162: a27 := JTF_NUMBER_TABLE();
163: a28 := JTF_NUMBER_TABLE();

Line 164: a29 := JTF_VARCHAR2_TABLE_100();

160: a25 := JTF_DATE_TABLE();
161: a26 := JTF_NUMBER_TABLE();
162: a27 := JTF_NUMBER_TABLE();
163: a28 := JTF_NUMBER_TABLE();
164: a29 := JTF_VARCHAR2_TABLE_100();
165: a30 := JTF_VARCHAR2_TABLE_100();
166: a31 := JTF_NUMBER_TABLE();
167: a32 := JTF_VARCHAR2_TABLE_100();
168: a33 := JTF_NUMBER_TABLE();

Line 165: a30 := JTF_VARCHAR2_TABLE_100();

161: a26 := JTF_NUMBER_TABLE();
162: a27 := JTF_NUMBER_TABLE();
163: a28 := JTF_NUMBER_TABLE();
164: a29 := JTF_VARCHAR2_TABLE_100();
165: a30 := JTF_VARCHAR2_TABLE_100();
166: a31 := JTF_NUMBER_TABLE();
167: a32 := JTF_VARCHAR2_TABLE_100();
168: a33 := JTF_NUMBER_TABLE();
169: a34 := JTF_NUMBER_TABLE();

Line 167: a32 := JTF_VARCHAR2_TABLE_100();

163: a28 := JTF_NUMBER_TABLE();
164: a29 := JTF_VARCHAR2_TABLE_100();
165: a30 := JTF_VARCHAR2_TABLE_100();
166: a31 := JTF_NUMBER_TABLE();
167: a32 := JTF_VARCHAR2_TABLE_100();
168: a33 := JTF_NUMBER_TABLE();
169: a34 := JTF_NUMBER_TABLE();
170: a35 := JTF_NUMBER_TABLE();
171: a36 := JTF_NUMBER_TABLE();

Line 175: a2 := JTF_VARCHAR2_TABLE_100();

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

Line 181: a8 := JTF_VARCHAR2_TABLE_100();

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

Line 182: a9 := JTF_VARCHAR2_TABLE_100();

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

Line 185: a12 := JTF_VARCHAR2_TABLE_100();

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

Line 187: a14 := JTF_VARCHAR2_TABLE_100();

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

Line 188: a15 := JTF_VARCHAR2_TABLE_100();

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

Line 197: a24 := JTF_VARCHAR2_TABLE_100();

193: a20 := JTF_NUMBER_TABLE();
194: a21 := JTF_NUMBER_TABLE();
195: a22 := JTF_NUMBER_TABLE();
196: a23 := JTF_NUMBER_TABLE();
197: a24 := JTF_VARCHAR2_TABLE_100();
198: a25 := JTF_DATE_TABLE();
199: a26 := JTF_NUMBER_TABLE();
200: a27 := JTF_NUMBER_TABLE();
201: a28 := JTF_NUMBER_TABLE();

Line 202: a29 := JTF_VARCHAR2_TABLE_100();

198: a25 := JTF_DATE_TABLE();
199: a26 := JTF_NUMBER_TABLE();
200: a27 := JTF_NUMBER_TABLE();
201: a28 := JTF_NUMBER_TABLE();
202: a29 := JTF_VARCHAR2_TABLE_100();
203: a30 := JTF_VARCHAR2_TABLE_100();
204: a31 := JTF_NUMBER_TABLE();
205: a32 := JTF_VARCHAR2_TABLE_100();
206: a33 := JTF_NUMBER_TABLE();

Line 203: a30 := JTF_VARCHAR2_TABLE_100();

199: a26 := JTF_NUMBER_TABLE();
200: a27 := JTF_NUMBER_TABLE();
201: a28 := JTF_NUMBER_TABLE();
202: a29 := JTF_VARCHAR2_TABLE_100();
203: a30 := JTF_VARCHAR2_TABLE_100();
204: a31 := JTF_NUMBER_TABLE();
205: a32 := JTF_VARCHAR2_TABLE_100();
206: a33 := JTF_NUMBER_TABLE();
207: a34 := JTF_NUMBER_TABLE();

Line 205: a32 := JTF_VARCHAR2_TABLE_100();

201: a28 := JTF_NUMBER_TABLE();
202: a29 := JTF_VARCHAR2_TABLE_100();
203: a30 := JTF_VARCHAR2_TABLE_100();
204: a31 := JTF_NUMBER_TABLE();
205: a32 := JTF_VARCHAR2_TABLE_100();
206: a33 := JTF_NUMBER_TABLE();
207: a34 := JTF_NUMBER_TABLE();
208: a35 := JTF_NUMBER_TABLE();
209: a36 := JTF_NUMBER_TABLE();

Line 298: procedure rosetta_table_copy_in_p4(t out nocopy lns_billing_batch_pub.reverse_tbl, a0 JTF_VARCHAR2_TABLE_100

294: end if;
295: end if;
296: end rosetta_table_copy_out_p1;
297:
298: procedure rosetta_table_copy_in_p4(t out nocopy lns_billing_batch_pub.reverse_tbl, a0 JTF_VARCHAR2_TABLE_100
299: , a1 JTF_NUMBER_TABLE
300: , a2 JTF_NUMBER_TABLE
301: , a3 JTF_NUMBER_TABLE
302: , a4 JTF_VARCHAR2_TABLE_100

Line 302: , a4 JTF_VARCHAR2_TABLE_100

298: procedure rosetta_table_copy_in_p4(t out nocopy lns_billing_batch_pub.reverse_tbl, a0 JTF_VARCHAR2_TABLE_100
299: , a1 JTF_NUMBER_TABLE
300: , a2 JTF_NUMBER_TABLE
301: , a3 JTF_NUMBER_TABLE
302: , a4 JTF_VARCHAR2_TABLE_100
303: , a5 JTF_NUMBER_TABLE
304: , a6 JTF_NUMBER_TABLE
305: , a7 JTF_NUMBER_TABLE
306: ) as

Line 331: procedure rosetta_table_copy_out_p4(t lns_billing_batch_pub.reverse_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100

327: end loop;
328: end if;
329: end if;
330: end rosetta_table_copy_in_p4;
331: procedure rosetta_table_copy_out_p4(t lns_billing_batch_pub.reverse_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100
332: , a1 out nocopy JTF_NUMBER_TABLE
333: , a2 out nocopy JTF_NUMBER_TABLE
334: , a3 out nocopy JTF_NUMBER_TABLE
335: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 335: , a4 out nocopy JTF_VARCHAR2_TABLE_100

331: procedure rosetta_table_copy_out_p4(t lns_billing_batch_pub.reverse_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100
332: , a1 out nocopy JTF_NUMBER_TABLE
333: , a2 out nocopy JTF_NUMBER_TABLE
334: , a3 out nocopy JTF_NUMBER_TABLE
335: , a4 out nocopy JTF_VARCHAR2_TABLE_100
336: , a5 out nocopy JTF_NUMBER_TABLE
337: , a6 out nocopy JTF_NUMBER_TABLE
338: , a7 out nocopy JTF_NUMBER_TABLE
339: ) as

Line 343: a0 := JTF_VARCHAR2_TABLE_100();

339: ) as
340: ddindx binary_integer; indx binary_integer;
341: begin
342: if t is null or t.count = 0 then
343: a0 := JTF_VARCHAR2_TABLE_100();
344: a1 := JTF_NUMBER_TABLE();
345: a2 := JTF_NUMBER_TABLE();
346: a3 := JTF_NUMBER_TABLE();
347: a4 := JTF_VARCHAR2_TABLE_100();

Line 347: a4 := JTF_VARCHAR2_TABLE_100();

343: a0 := JTF_VARCHAR2_TABLE_100();
344: a1 := JTF_NUMBER_TABLE();
345: a2 := JTF_NUMBER_TABLE();
346: a3 := JTF_NUMBER_TABLE();
347: a4 := JTF_VARCHAR2_TABLE_100();
348: a5 := JTF_NUMBER_TABLE();
349: a6 := JTF_NUMBER_TABLE();
350: a7 := JTF_NUMBER_TABLE();
351: else

Line 352: a0 := JTF_VARCHAR2_TABLE_100();

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

Line 356: a4 := JTF_VARCHAR2_TABLE_100();

352: a0 := JTF_VARCHAR2_TABLE_100();
353: a1 := JTF_NUMBER_TABLE();
354: a2 := JTF_NUMBER_TABLE();
355: a3 := JTF_NUMBER_TABLE();
356: a4 := JTF_VARCHAR2_TABLE_100();
357: a5 := JTF_NUMBER_TABLE();
358: a6 := JTF_NUMBER_TABLE();
359: a7 := JTF_NUMBER_TABLE();
360: if t.count > 0 then

Line 475: , a7 JTF_VARCHAR2_TABLE_100

471: , a3 JTF_NUMBER_TABLE
472: , a4 JTF_NUMBER_TABLE
473: , a5 JTF_NUMBER_TABLE
474: , a6 JTF_NUMBER_TABLE
475: , a7 JTF_VARCHAR2_TABLE_100
476: , a8 JTF_VARCHAR2_TABLE_300
477: , a9 JTF_NUMBER_TABLE
478: , a10 JTF_NUMBER_TABLE
479: , a11 JTF_NUMBER_TABLE

Line 520: , a7 out nocopy JTF_VARCHAR2_TABLE_100

516: , a3 out nocopy JTF_NUMBER_TABLE
517: , a4 out nocopy JTF_NUMBER_TABLE
518: , a5 out nocopy JTF_NUMBER_TABLE
519: , a6 out nocopy JTF_NUMBER_TABLE
520: , a7 out nocopy JTF_VARCHAR2_TABLE_100
521: , a8 out nocopy JTF_VARCHAR2_TABLE_300
522: , a9 out nocopy JTF_NUMBER_TABLE
523: , a10 out nocopy JTF_NUMBER_TABLE
524: , a11 out nocopy JTF_NUMBER_TABLE

Line 538: a7 := JTF_VARCHAR2_TABLE_100();

534: a3 := JTF_NUMBER_TABLE();
535: a4 := JTF_NUMBER_TABLE();
536: a5 := JTF_NUMBER_TABLE();
537: a6 := JTF_NUMBER_TABLE();
538: a7 := JTF_VARCHAR2_TABLE_100();
539: a8 := JTF_VARCHAR2_TABLE_300();
540: a9 := JTF_NUMBER_TABLE();
541: a10 := JTF_NUMBER_TABLE();
542: a11 := JTF_NUMBER_TABLE();

Line 553: a7 := JTF_VARCHAR2_TABLE_100();

549: a3 := JTF_NUMBER_TABLE();
550: a4 := JTF_NUMBER_TABLE();
551: a5 := JTF_NUMBER_TABLE();
552: a6 := JTF_NUMBER_TABLE();
553: a7 := JTF_VARCHAR2_TABLE_100();
554: a8 := JTF_VARCHAR2_TABLE_300();
555: a9 := JTF_NUMBER_TABLE();
556: a10 := JTF_NUMBER_TABLE();
557: a11 := JTF_NUMBER_TABLE();

Line 604: , a2 JTF_VARCHAR2_TABLE_100

600: end rosetta_table_copy_out_p8;
601:
602: procedure rosetta_table_copy_in_p10(t out nocopy lns_billing_batch_pub.invoice_details_tbl, a0 JTF_NUMBER_TABLE
603: , a1 JTF_NUMBER_TABLE
604: , a2 JTF_VARCHAR2_TABLE_100
605: , a3 JTF_NUMBER_TABLE
606: , a4 JTF_VARCHAR2_TABLE_100
607: , a5 JTF_NUMBER_TABLE
608: , a6 JTF_NUMBER_TABLE

Line 606: , a4 JTF_VARCHAR2_TABLE_100

602: procedure rosetta_table_copy_in_p10(t out nocopy lns_billing_batch_pub.invoice_details_tbl, a0 JTF_NUMBER_TABLE
603: , a1 JTF_NUMBER_TABLE
604: , a2 JTF_VARCHAR2_TABLE_100
605: , a3 JTF_NUMBER_TABLE
606: , a4 JTF_VARCHAR2_TABLE_100
607: , a5 JTF_NUMBER_TABLE
608: , a6 JTF_NUMBER_TABLE
609: , a7 JTF_NUMBER_TABLE
610: , a8 JTF_DATE_TABLE

Line 613: , a11 JTF_VARCHAR2_TABLE_100

609: , a7 JTF_NUMBER_TABLE
610: , a8 JTF_DATE_TABLE
611: , a9 JTF_DATE_TABLE
612: , a10 JTF_DATE_TABLE
613: , a11 JTF_VARCHAR2_TABLE_100
614: , a12 JTF_VARCHAR2_TABLE_100
615: , a13 JTF_VARCHAR2_TABLE_100
616: , a14 JTF_NUMBER_TABLE
617: ) as

Line 614: , a12 JTF_VARCHAR2_TABLE_100

610: , a8 JTF_DATE_TABLE
611: , a9 JTF_DATE_TABLE
612: , a10 JTF_DATE_TABLE
613: , a11 JTF_VARCHAR2_TABLE_100
614: , a12 JTF_VARCHAR2_TABLE_100
615: , a13 JTF_VARCHAR2_TABLE_100
616: , a14 JTF_NUMBER_TABLE
617: ) as
618: ddindx binary_integer; indx binary_integer;

Line 615: , a13 JTF_VARCHAR2_TABLE_100

611: , a9 JTF_DATE_TABLE
612: , a10 JTF_DATE_TABLE
613: , a11 JTF_VARCHAR2_TABLE_100
614: , a12 JTF_VARCHAR2_TABLE_100
615: , a13 JTF_VARCHAR2_TABLE_100
616: , a14 JTF_NUMBER_TABLE
617: ) as
618: ddindx binary_integer; indx binary_integer;
619: begin

Line 651: , a2 out nocopy JTF_VARCHAR2_TABLE_100

647: end if;
648: end rosetta_table_copy_in_p10;
649: procedure rosetta_table_copy_out_p10(t lns_billing_batch_pub.invoice_details_tbl, a0 out nocopy JTF_NUMBER_TABLE
650: , a1 out nocopy JTF_NUMBER_TABLE
651: , a2 out nocopy JTF_VARCHAR2_TABLE_100
652: , a3 out nocopy JTF_NUMBER_TABLE
653: , a4 out nocopy JTF_VARCHAR2_TABLE_100
654: , a5 out nocopy JTF_NUMBER_TABLE
655: , a6 out nocopy JTF_NUMBER_TABLE

Line 653: , a4 out nocopy JTF_VARCHAR2_TABLE_100

649: procedure rosetta_table_copy_out_p10(t lns_billing_batch_pub.invoice_details_tbl, a0 out nocopy JTF_NUMBER_TABLE
650: , a1 out nocopy JTF_NUMBER_TABLE
651: , a2 out nocopy JTF_VARCHAR2_TABLE_100
652: , a3 out nocopy JTF_NUMBER_TABLE
653: , a4 out nocopy JTF_VARCHAR2_TABLE_100
654: , a5 out nocopy JTF_NUMBER_TABLE
655: , a6 out nocopy JTF_NUMBER_TABLE
656: , a7 out nocopy JTF_NUMBER_TABLE
657: , a8 out nocopy JTF_DATE_TABLE

Line 660: , a11 out nocopy JTF_VARCHAR2_TABLE_100

656: , a7 out nocopy JTF_NUMBER_TABLE
657: , a8 out nocopy JTF_DATE_TABLE
658: , a9 out nocopy JTF_DATE_TABLE
659: , a10 out nocopy JTF_DATE_TABLE
660: , a11 out nocopy JTF_VARCHAR2_TABLE_100
661: , a12 out nocopy JTF_VARCHAR2_TABLE_100
662: , a13 out nocopy JTF_VARCHAR2_TABLE_100
663: , a14 out nocopy JTF_NUMBER_TABLE
664: ) as

Line 661: , a12 out nocopy JTF_VARCHAR2_TABLE_100

657: , a8 out nocopy JTF_DATE_TABLE
658: , a9 out nocopy JTF_DATE_TABLE
659: , a10 out nocopy JTF_DATE_TABLE
660: , a11 out nocopy JTF_VARCHAR2_TABLE_100
661: , a12 out nocopy JTF_VARCHAR2_TABLE_100
662: , a13 out nocopy JTF_VARCHAR2_TABLE_100
663: , a14 out nocopy JTF_NUMBER_TABLE
664: ) as
665: ddindx binary_integer; indx binary_integer;

Line 662: , a13 out nocopy JTF_VARCHAR2_TABLE_100

658: , a9 out nocopy JTF_DATE_TABLE
659: , a10 out nocopy JTF_DATE_TABLE
660: , a11 out nocopy JTF_VARCHAR2_TABLE_100
661: , a12 out nocopy JTF_VARCHAR2_TABLE_100
662: , a13 out nocopy JTF_VARCHAR2_TABLE_100
663: , a14 out nocopy JTF_NUMBER_TABLE
664: ) as
665: ddindx binary_integer; indx binary_integer;
666: begin

Line 670: a2 := JTF_VARCHAR2_TABLE_100();

666: begin
667: if t is null or t.count = 0 then
668: a0 := JTF_NUMBER_TABLE();
669: a1 := JTF_NUMBER_TABLE();
670: a2 := JTF_VARCHAR2_TABLE_100();
671: a3 := JTF_NUMBER_TABLE();
672: a4 := JTF_VARCHAR2_TABLE_100();
673: a5 := JTF_NUMBER_TABLE();
674: a6 := JTF_NUMBER_TABLE();

Line 672: a4 := JTF_VARCHAR2_TABLE_100();

668: a0 := JTF_NUMBER_TABLE();
669: a1 := JTF_NUMBER_TABLE();
670: a2 := JTF_VARCHAR2_TABLE_100();
671: a3 := JTF_NUMBER_TABLE();
672: a4 := JTF_VARCHAR2_TABLE_100();
673: a5 := JTF_NUMBER_TABLE();
674: a6 := JTF_NUMBER_TABLE();
675: a7 := JTF_NUMBER_TABLE();
676: a8 := JTF_DATE_TABLE();

Line 679: a11 := JTF_VARCHAR2_TABLE_100();

675: a7 := JTF_NUMBER_TABLE();
676: a8 := JTF_DATE_TABLE();
677: a9 := JTF_DATE_TABLE();
678: a10 := JTF_DATE_TABLE();
679: a11 := JTF_VARCHAR2_TABLE_100();
680: a12 := JTF_VARCHAR2_TABLE_100();
681: a13 := JTF_VARCHAR2_TABLE_100();
682: a14 := JTF_NUMBER_TABLE();
683: else

Line 680: a12 := JTF_VARCHAR2_TABLE_100();

676: a8 := JTF_DATE_TABLE();
677: a9 := JTF_DATE_TABLE();
678: a10 := JTF_DATE_TABLE();
679: a11 := JTF_VARCHAR2_TABLE_100();
680: a12 := JTF_VARCHAR2_TABLE_100();
681: a13 := JTF_VARCHAR2_TABLE_100();
682: a14 := JTF_NUMBER_TABLE();
683: else
684: a0 := JTF_NUMBER_TABLE();

Line 681: a13 := JTF_VARCHAR2_TABLE_100();

677: a9 := JTF_DATE_TABLE();
678: a10 := JTF_DATE_TABLE();
679: a11 := JTF_VARCHAR2_TABLE_100();
680: a12 := JTF_VARCHAR2_TABLE_100();
681: a13 := JTF_VARCHAR2_TABLE_100();
682: a14 := JTF_NUMBER_TABLE();
683: else
684: a0 := JTF_NUMBER_TABLE();
685: a1 := JTF_NUMBER_TABLE();

Line 686: a2 := JTF_VARCHAR2_TABLE_100();

682: a14 := JTF_NUMBER_TABLE();
683: else
684: a0 := JTF_NUMBER_TABLE();
685: a1 := JTF_NUMBER_TABLE();
686: a2 := JTF_VARCHAR2_TABLE_100();
687: a3 := JTF_NUMBER_TABLE();
688: a4 := JTF_VARCHAR2_TABLE_100();
689: a5 := JTF_NUMBER_TABLE();
690: a6 := JTF_NUMBER_TABLE();

Line 688: a4 := JTF_VARCHAR2_TABLE_100();

684: a0 := JTF_NUMBER_TABLE();
685: a1 := JTF_NUMBER_TABLE();
686: a2 := JTF_VARCHAR2_TABLE_100();
687: a3 := JTF_NUMBER_TABLE();
688: a4 := JTF_VARCHAR2_TABLE_100();
689: a5 := JTF_NUMBER_TABLE();
690: a6 := JTF_NUMBER_TABLE();
691: a7 := JTF_NUMBER_TABLE();
692: a8 := JTF_DATE_TABLE();

Line 695: a11 := JTF_VARCHAR2_TABLE_100();

691: a7 := JTF_NUMBER_TABLE();
692: a8 := JTF_DATE_TABLE();
693: a9 := JTF_DATE_TABLE();
694: a10 := JTF_DATE_TABLE();
695: a11 := JTF_VARCHAR2_TABLE_100();
696: a12 := JTF_VARCHAR2_TABLE_100();
697: a13 := JTF_VARCHAR2_TABLE_100();
698: a14 := JTF_NUMBER_TABLE();
699: if t.count > 0 then

Line 696: a12 := JTF_VARCHAR2_TABLE_100();

692: a8 := JTF_DATE_TABLE();
693: a9 := JTF_DATE_TABLE();
694: a10 := JTF_DATE_TABLE();
695: a11 := JTF_VARCHAR2_TABLE_100();
696: a12 := JTF_VARCHAR2_TABLE_100();
697: a13 := JTF_VARCHAR2_TABLE_100();
698: a14 := JTF_NUMBER_TABLE();
699: if t.count > 0 then
700: a0.extend(t.count);

Line 697: a13 := JTF_VARCHAR2_TABLE_100();

693: a9 := JTF_DATE_TABLE();
694: a10 := JTF_DATE_TABLE();
695: a11 := JTF_VARCHAR2_TABLE_100();
696: a12 := JTF_VARCHAR2_TABLE_100();
697: a13 := JTF_VARCHAR2_TABLE_100();
698: a14 := JTF_NUMBER_TABLE();
699: if t.count > 0 then
700: a0.extend(t.count);
701: a1.extend(t.count);

Line 745: , a2 JTF_VARCHAR2_TABLE_100

741: end rosetta_table_copy_out_p10;
742:
743: procedure rosetta_table_copy_in_p12(t out nocopy lns_billing_batch_pub.cash_receipt_tbl, a0 JTF_NUMBER_TABLE
744: , a1 JTF_NUMBER_TABLE
745: , a2 JTF_VARCHAR2_TABLE_100
746: , a3 JTF_NUMBER_TABLE
747: , a4 JTF_DATE_TABLE
748: , a5 JTF_VARCHAR2_TABLE_100
749: , a6 JTF_VARCHAR2_TABLE_100

Line 748: , a5 JTF_VARCHAR2_TABLE_100

744: , a1 JTF_NUMBER_TABLE
745: , a2 JTF_VARCHAR2_TABLE_100
746: , a3 JTF_NUMBER_TABLE
747: , a4 JTF_DATE_TABLE
748: , a5 JTF_VARCHAR2_TABLE_100
749: , a6 JTF_VARCHAR2_TABLE_100
750: , a7 JTF_VARCHAR2_TABLE_100
751: , a8 JTF_DATE_TABLE
752: , a9 JTF_DATE_TABLE

Line 749: , a6 JTF_VARCHAR2_TABLE_100

745: , a2 JTF_VARCHAR2_TABLE_100
746: , a3 JTF_NUMBER_TABLE
747: , a4 JTF_DATE_TABLE
748: , a5 JTF_VARCHAR2_TABLE_100
749: , a6 JTF_VARCHAR2_TABLE_100
750: , a7 JTF_VARCHAR2_TABLE_100
751: , a8 JTF_DATE_TABLE
752: , a9 JTF_DATE_TABLE
753: ) as

Line 750: , a7 JTF_VARCHAR2_TABLE_100

746: , a3 JTF_NUMBER_TABLE
747: , a4 JTF_DATE_TABLE
748: , a5 JTF_VARCHAR2_TABLE_100
749: , a6 JTF_VARCHAR2_TABLE_100
750: , a7 JTF_VARCHAR2_TABLE_100
751: , a8 JTF_DATE_TABLE
752: , a9 JTF_DATE_TABLE
753: ) as
754: ddindx binary_integer; indx binary_integer;

Line 782: , a2 out nocopy JTF_VARCHAR2_TABLE_100

778: end if;
779: end rosetta_table_copy_in_p12;
780: procedure rosetta_table_copy_out_p12(t lns_billing_batch_pub.cash_receipt_tbl, a0 out nocopy JTF_NUMBER_TABLE
781: , a1 out nocopy JTF_NUMBER_TABLE
782: , a2 out nocopy JTF_VARCHAR2_TABLE_100
783: , a3 out nocopy JTF_NUMBER_TABLE
784: , a4 out nocopy JTF_DATE_TABLE
785: , a5 out nocopy JTF_VARCHAR2_TABLE_100
786: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 785: , a5 out nocopy JTF_VARCHAR2_TABLE_100

781: , a1 out nocopy JTF_NUMBER_TABLE
782: , a2 out nocopy JTF_VARCHAR2_TABLE_100
783: , a3 out nocopy JTF_NUMBER_TABLE
784: , a4 out nocopy JTF_DATE_TABLE
785: , a5 out nocopy JTF_VARCHAR2_TABLE_100
786: , a6 out nocopy JTF_VARCHAR2_TABLE_100
787: , a7 out nocopy JTF_VARCHAR2_TABLE_100
788: , a8 out nocopy JTF_DATE_TABLE
789: , a9 out nocopy JTF_DATE_TABLE

Line 786: , a6 out nocopy JTF_VARCHAR2_TABLE_100

782: , a2 out nocopy JTF_VARCHAR2_TABLE_100
783: , a3 out nocopy JTF_NUMBER_TABLE
784: , a4 out nocopy JTF_DATE_TABLE
785: , a5 out nocopy JTF_VARCHAR2_TABLE_100
786: , a6 out nocopy JTF_VARCHAR2_TABLE_100
787: , a7 out nocopy JTF_VARCHAR2_TABLE_100
788: , a8 out nocopy JTF_DATE_TABLE
789: , a9 out nocopy JTF_DATE_TABLE
790: ) as

Line 787: , a7 out nocopy JTF_VARCHAR2_TABLE_100

783: , a3 out nocopy JTF_NUMBER_TABLE
784: , a4 out nocopy JTF_DATE_TABLE
785: , a5 out nocopy JTF_VARCHAR2_TABLE_100
786: , a6 out nocopy JTF_VARCHAR2_TABLE_100
787: , a7 out nocopy JTF_VARCHAR2_TABLE_100
788: , a8 out nocopy JTF_DATE_TABLE
789: , a9 out nocopy JTF_DATE_TABLE
790: ) as
791: ddindx binary_integer; indx binary_integer;

Line 796: a2 := JTF_VARCHAR2_TABLE_100();

792: begin
793: if t is null or t.count = 0 then
794: a0 := JTF_NUMBER_TABLE();
795: a1 := JTF_NUMBER_TABLE();
796: a2 := JTF_VARCHAR2_TABLE_100();
797: a3 := JTF_NUMBER_TABLE();
798: a4 := JTF_DATE_TABLE();
799: a5 := JTF_VARCHAR2_TABLE_100();
800: a6 := JTF_VARCHAR2_TABLE_100();

Line 799: a5 := JTF_VARCHAR2_TABLE_100();

795: a1 := JTF_NUMBER_TABLE();
796: a2 := JTF_VARCHAR2_TABLE_100();
797: a3 := JTF_NUMBER_TABLE();
798: a4 := JTF_DATE_TABLE();
799: a5 := JTF_VARCHAR2_TABLE_100();
800: a6 := JTF_VARCHAR2_TABLE_100();
801: a7 := JTF_VARCHAR2_TABLE_100();
802: a8 := JTF_DATE_TABLE();
803: a9 := JTF_DATE_TABLE();

Line 800: a6 := JTF_VARCHAR2_TABLE_100();

796: a2 := JTF_VARCHAR2_TABLE_100();
797: a3 := JTF_NUMBER_TABLE();
798: a4 := JTF_DATE_TABLE();
799: a5 := JTF_VARCHAR2_TABLE_100();
800: a6 := JTF_VARCHAR2_TABLE_100();
801: a7 := JTF_VARCHAR2_TABLE_100();
802: a8 := JTF_DATE_TABLE();
803: a9 := JTF_DATE_TABLE();
804: else

Line 801: a7 := JTF_VARCHAR2_TABLE_100();

797: a3 := JTF_NUMBER_TABLE();
798: a4 := JTF_DATE_TABLE();
799: a5 := JTF_VARCHAR2_TABLE_100();
800: a6 := JTF_VARCHAR2_TABLE_100();
801: a7 := JTF_VARCHAR2_TABLE_100();
802: a8 := JTF_DATE_TABLE();
803: a9 := JTF_DATE_TABLE();
804: else
805: a0 := JTF_NUMBER_TABLE();

Line 807: a2 := JTF_VARCHAR2_TABLE_100();

803: a9 := JTF_DATE_TABLE();
804: else
805: a0 := JTF_NUMBER_TABLE();
806: a1 := JTF_NUMBER_TABLE();
807: a2 := JTF_VARCHAR2_TABLE_100();
808: a3 := JTF_NUMBER_TABLE();
809: a4 := JTF_DATE_TABLE();
810: a5 := JTF_VARCHAR2_TABLE_100();
811: a6 := JTF_VARCHAR2_TABLE_100();

Line 810: a5 := JTF_VARCHAR2_TABLE_100();

806: a1 := JTF_NUMBER_TABLE();
807: a2 := JTF_VARCHAR2_TABLE_100();
808: a3 := JTF_NUMBER_TABLE();
809: a4 := JTF_DATE_TABLE();
810: a5 := JTF_VARCHAR2_TABLE_100();
811: a6 := JTF_VARCHAR2_TABLE_100();
812: a7 := JTF_VARCHAR2_TABLE_100();
813: a8 := JTF_DATE_TABLE();
814: a9 := JTF_DATE_TABLE();

Line 811: a6 := JTF_VARCHAR2_TABLE_100();

807: a2 := JTF_VARCHAR2_TABLE_100();
808: a3 := JTF_NUMBER_TABLE();
809: a4 := JTF_DATE_TABLE();
810: a5 := JTF_VARCHAR2_TABLE_100();
811: a6 := JTF_VARCHAR2_TABLE_100();
812: a7 := JTF_VARCHAR2_TABLE_100();
813: a8 := JTF_DATE_TABLE();
814: a9 := JTF_DATE_TABLE();
815: if t.count > 0 then

Line 812: a7 := JTF_VARCHAR2_TABLE_100();

808: a3 := JTF_NUMBER_TABLE();
809: a4 := JTF_DATE_TABLE();
810: a5 := JTF_VARCHAR2_TABLE_100();
811: a6 := JTF_VARCHAR2_TABLE_100();
812: a7 := JTF_VARCHAR2_TABLE_100();
813: a8 := JTF_DATE_TABLE();
814: a9 := JTF_DATE_TABLE();
815: if t.count > 0 then
816: a0.extend(t.count);

Line 907: , p5_a7 JTF_VARCHAR2_TABLE_100

903: , p5_a3 JTF_NUMBER_TABLE
904: , p5_a4 JTF_NUMBER_TABLE
905: , p5_a5 JTF_NUMBER_TABLE
906: , p5_a6 JTF_NUMBER_TABLE
907: , p5_a7 JTF_VARCHAR2_TABLE_100
908: , p5_a8 JTF_VARCHAR2_TABLE_300
909: , p5_a9 JTF_NUMBER_TABLE
910: , p5_a10 JTF_NUMBER_TABLE
911: , p5_a11 JTF_NUMBER_TABLE

Line 995: , p5_a7 JTF_VARCHAR2_TABLE_100

991: , p5_a3 JTF_NUMBER_TABLE
992: , p5_a4 JTF_NUMBER_TABLE
993: , p5_a5 JTF_NUMBER_TABLE
994: , p5_a6 JTF_NUMBER_TABLE
995: , p5_a7 JTF_VARCHAR2_TABLE_100
996: , p5_a8 JTF_VARCHAR2_TABLE_300
997: , p5_a9 JTF_NUMBER_TABLE
998: , p5_a10 JTF_NUMBER_TABLE
999: , p5_a11 JTF_NUMBER_TABLE

Line 1074: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100

1070: , p_validation_level NUMBER
1071: , p_loan_id NUMBER
1072: , p5_a0 out nocopy JTF_NUMBER_TABLE
1073: , p5_a1 out nocopy JTF_NUMBER_TABLE
1074: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
1075: , p5_a3 out nocopy JTF_NUMBER_TABLE
1076: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
1077: , p5_a5 out nocopy JTF_NUMBER_TABLE
1078: , p5_a6 out nocopy JTF_NUMBER_TABLE

Line 1076: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100

1072: , p5_a0 out nocopy JTF_NUMBER_TABLE
1073: , p5_a1 out nocopy JTF_NUMBER_TABLE
1074: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
1075: , p5_a3 out nocopy JTF_NUMBER_TABLE
1076: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
1077: , p5_a5 out nocopy JTF_NUMBER_TABLE
1078: , p5_a6 out nocopy JTF_NUMBER_TABLE
1079: , p5_a7 out nocopy JTF_NUMBER_TABLE
1080: , p5_a8 out nocopy JTF_DATE_TABLE

Line 1083: , p5_a11 out nocopy JTF_VARCHAR2_TABLE_100

1079: , p5_a7 out nocopy JTF_NUMBER_TABLE
1080: , p5_a8 out nocopy JTF_DATE_TABLE
1081: , p5_a9 out nocopy JTF_DATE_TABLE
1082: , p5_a10 out nocopy JTF_DATE_TABLE
1083: , p5_a11 out nocopy JTF_VARCHAR2_TABLE_100
1084: , p5_a12 out nocopy JTF_VARCHAR2_TABLE_100
1085: , p5_a13 out nocopy JTF_VARCHAR2_TABLE_100
1086: , p5_a14 out nocopy JTF_NUMBER_TABLE
1087: , x_return_status out nocopy VARCHAR2

Line 1084: , p5_a12 out nocopy JTF_VARCHAR2_TABLE_100

1080: , p5_a8 out nocopy JTF_DATE_TABLE
1081: , p5_a9 out nocopy JTF_DATE_TABLE
1082: , p5_a10 out nocopy JTF_DATE_TABLE
1083: , p5_a11 out nocopy JTF_VARCHAR2_TABLE_100
1084: , p5_a12 out nocopy JTF_VARCHAR2_TABLE_100
1085: , p5_a13 out nocopy JTF_VARCHAR2_TABLE_100
1086: , p5_a14 out nocopy JTF_NUMBER_TABLE
1087: , x_return_status out nocopy VARCHAR2
1088: , x_msg_count out nocopy NUMBER

Line 1085: , p5_a13 out nocopy JTF_VARCHAR2_TABLE_100

1081: , p5_a9 out nocopy JTF_DATE_TABLE
1082: , p5_a10 out nocopy JTF_DATE_TABLE
1083: , p5_a11 out nocopy JTF_VARCHAR2_TABLE_100
1084: , p5_a12 out nocopy JTF_VARCHAR2_TABLE_100
1085: , p5_a13 out nocopy JTF_VARCHAR2_TABLE_100
1086: , p5_a14 out nocopy JTF_NUMBER_TABLE
1087: , x_return_status out nocopy VARCHAR2
1088: , x_msg_count out nocopy NUMBER
1089: , x_msg_data out nocopy VARCHAR2

Line 1152: , p5_a2 JTF_VARCHAR2_TABLE_100

1148: , p_validation_level NUMBER
1149: , p_loan_id NUMBER
1150: , p5_a0 JTF_NUMBER_TABLE
1151: , p5_a1 JTF_NUMBER_TABLE
1152: , p5_a2 JTF_VARCHAR2_TABLE_100
1153: , p5_a3 JTF_NUMBER_TABLE
1154: , p5_a4 JTF_DATE_TABLE
1155: , p5_a5 JTF_VARCHAR2_TABLE_100
1156: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 1155: , p5_a5 JTF_VARCHAR2_TABLE_100

1151: , p5_a1 JTF_NUMBER_TABLE
1152: , p5_a2 JTF_VARCHAR2_TABLE_100
1153: , p5_a3 JTF_NUMBER_TABLE
1154: , p5_a4 JTF_DATE_TABLE
1155: , p5_a5 JTF_VARCHAR2_TABLE_100
1156: , p5_a6 JTF_VARCHAR2_TABLE_100
1157: , p5_a7 JTF_VARCHAR2_TABLE_100
1158: , p5_a8 JTF_DATE_TABLE
1159: , p5_a9 JTF_DATE_TABLE

Line 1156: , p5_a6 JTF_VARCHAR2_TABLE_100

1152: , p5_a2 JTF_VARCHAR2_TABLE_100
1153: , p5_a3 JTF_NUMBER_TABLE
1154: , p5_a4 JTF_DATE_TABLE
1155: , p5_a5 JTF_VARCHAR2_TABLE_100
1156: , p5_a6 JTF_VARCHAR2_TABLE_100
1157: , p5_a7 JTF_VARCHAR2_TABLE_100
1158: , p5_a8 JTF_DATE_TABLE
1159: , p5_a9 JTF_DATE_TABLE
1160: , x_return_status out nocopy VARCHAR2

Line 1157: , p5_a7 JTF_VARCHAR2_TABLE_100

1153: , p5_a3 JTF_NUMBER_TABLE
1154: , p5_a4 JTF_DATE_TABLE
1155: , p5_a5 JTF_VARCHAR2_TABLE_100
1156: , p5_a6 JTF_VARCHAR2_TABLE_100
1157: , p5_a7 JTF_VARCHAR2_TABLE_100
1158: , p5_a8 JTF_DATE_TABLE
1159: , p5_a9 JTF_DATE_TABLE
1160: , x_return_status out nocopy VARCHAR2
1161: , x_msg_count out nocopy NUMBER

Line 1221: , p6_a2 JTF_VARCHAR2_TABLE_100

1217: , p_loan_id NUMBER
1218: , p_am_sched_tbl JTF_NUMBER_TABLE
1219: , p6_a0 JTF_NUMBER_TABLE
1220: , p6_a1 JTF_NUMBER_TABLE
1221: , p6_a2 JTF_VARCHAR2_TABLE_100
1222: , p6_a3 JTF_NUMBER_TABLE
1223: , p6_a4 JTF_DATE_TABLE
1224: , p6_a5 JTF_VARCHAR2_TABLE_100
1225: , p6_a6 JTF_VARCHAR2_TABLE_100

Line 1224: , p6_a5 JTF_VARCHAR2_TABLE_100

1220: , p6_a1 JTF_NUMBER_TABLE
1221: , p6_a2 JTF_VARCHAR2_TABLE_100
1222: , p6_a3 JTF_NUMBER_TABLE
1223: , p6_a4 JTF_DATE_TABLE
1224: , p6_a5 JTF_VARCHAR2_TABLE_100
1225: , p6_a6 JTF_VARCHAR2_TABLE_100
1226: , p6_a7 JTF_VARCHAR2_TABLE_100
1227: , p6_a8 JTF_DATE_TABLE
1228: , p6_a9 JTF_DATE_TABLE

Line 1225: , p6_a6 JTF_VARCHAR2_TABLE_100

1221: , p6_a2 JTF_VARCHAR2_TABLE_100
1222: , p6_a3 JTF_NUMBER_TABLE
1223: , p6_a4 JTF_DATE_TABLE
1224: , p6_a5 JTF_VARCHAR2_TABLE_100
1225: , p6_a6 JTF_VARCHAR2_TABLE_100
1226: , p6_a7 JTF_VARCHAR2_TABLE_100
1227: , p6_a8 JTF_DATE_TABLE
1228: , p6_a9 JTF_DATE_TABLE
1229: , x_return_status out nocopy VARCHAR2

Line 1226: , p6_a7 JTF_VARCHAR2_TABLE_100

1222: , p6_a3 JTF_NUMBER_TABLE
1223: , p6_a4 JTF_DATE_TABLE
1224: , p6_a5 JTF_VARCHAR2_TABLE_100
1225: , p6_a6 JTF_VARCHAR2_TABLE_100
1226: , p6_a7 JTF_VARCHAR2_TABLE_100
1227: , p6_a8 JTF_DATE_TABLE
1228: , p6_a9 JTF_DATE_TABLE
1229: , x_return_status out nocopy VARCHAR2
1230: , x_msg_count out nocopy NUMBER

Line 1318: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

1314: , p_loan_id NUMBER
1315: , p_am_sched_id NUMBER
1316: , p6_a0 out nocopy JTF_NUMBER_TABLE
1317: , p6_a1 out nocopy JTF_NUMBER_TABLE
1318: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1319: , p6_a3 out nocopy JTF_NUMBER_TABLE
1320: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1321: , p6_a5 out nocopy JTF_NUMBER_TABLE
1322: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 1320: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

1316: , p6_a0 out nocopy JTF_NUMBER_TABLE
1317: , p6_a1 out nocopy JTF_NUMBER_TABLE
1318: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1319: , p6_a3 out nocopy JTF_NUMBER_TABLE
1320: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1321: , p6_a5 out nocopy JTF_NUMBER_TABLE
1322: , p6_a6 out nocopy JTF_NUMBER_TABLE
1323: , p6_a7 out nocopy JTF_NUMBER_TABLE
1324: , p6_a8 out nocopy JTF_DATE_TABLE

Line 1327: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100

1323: , p6_a7 out nocopy JTF_NUMBER_TABLE
1324: , p6_a8 out nocopy JTF_DATE_TABLE
1325: , p6_a9 out nocopy JTF_DATE_TABLE
1326: , p6_a10 out nocopy JTF_DATE_TABLE
1327: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
1328: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
1329: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
1330: , p6_a14 out nocopy JTF_NUMBER_TABLE
1331: , x_return_status out nocopy VARCHAR2

Line 1328: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100

1324: , p6_a8 out nocopy JTF_DATE_TABLE
1325: , p6_a9 out nocopy JTF_DATE_TABLE
1326: , p6_a10 out nocopy JTF_DATE_TABLE
1327: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
1328: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
1329: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
1330: , p6_a14 out nocopy JTF_NUMBER_TABLE
1331: , x_return_status out nocopy VARCHAR2
1332: , x_msg_count out nocopy NUMBER

Line 1329: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100

1325: , p6_a9 out nocopy JTF_DATE_TABLE
1326: , p6_a10 out nocopy JTF_DATE_TABLE
1327: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
1328: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
1329: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
1330: , p6_a14 out nocopy JTF_NUMBER_TABLE
1331: , x_return_status out nocopy VARCHAR2
1332: , x_msg_count out nocopy NUMBER
1333: , x_msg_data out nocopy VARCHAR2

Line 1410: , p6_a7 JTF_VARCHAR2_TABLE_100

1406: , p6_a3 JTF_NUMBER_TABLE
1407: , p6_a4 JTF_NUMBER_TABLE
1408: , p6_a5 JTF_NUMBER_TABLE
1409: , p6_a6 JTF_NUMBER_TABLE
1410: , p6_a7 JTF_VARCHAR2_TABLE_100
1411: , p6_a8 JTF_VARCHAR2_TABLE_300
1412: , p6_a9 JTF_NUMBER_TABLE
1413: , p6_a10 JTF_NUMBER_TABLE
1414: , p6_a11 JTF_NUMBER_TABLE

Line 1419: , p7_a2 JTF_VARCHAR2_TABLE_100

1415: , p6_a12 JTF_NUMBER_TABLE
1416: , p6_a13 JTF_VARCHAR2_TABLE_2000
1417: , p7_a0 JTF_NUMBER_TABLE
1418: , p7_a1 JTF_NUMBER_TABLE
1419: , p7_a2 JTF_VARCHAR2_TABLE_100
1420: , p7_a3 JTF_NUMBER_TABLE
1421: , p7_a4 JTF_DATE_TABLE
1422: , p7_a5 JTF_VARCHAR2_TABLE_100
1423: , p7_a6 JTF_VARCHAR2_TABLE_100

Line 1422: , p7_a5 JTF_VARCHAR2_TABLE_100

1418: , p7_a1 JTF_NUMBER_TABLE
1419: , p7_a2 JTF_VARCHAR2_TABLE_100
1420: , p7_a3 JTF_NUMBER_TABLE
1421: , p7_a4 JTF_DATE_TABLE
1422: , p7_a5 JTF_VARCHAR2_TABLE_100
1423: , p7_a6 JTF_VARCHAR2_TABLE_100
1424: , p7_a7 JTF_VARCHAR2_TABLE_100
1425: , p7_a8 JTF_DATE_TABLE
1426: , p7_a9 JTF_DATE_TABLE

Line 1423: , p7_a6 JTF_VARCHAR2_TABLE_100

1419: , p7_a2 JTF_VARCHAR2_TABLE_100
1420: , p7_a3 JTF_NUMBER_TABLE
1421: , p7_a4 JTF_DATE_TABLE
1422: , p7_a5 JTF_VARCHAR2_TABLE_100
1423: , p7_a6 JTF_VARCHAR2_TABLE_100
1424: , p7_a7 JTF_VARCHAR2_TABLE_100
1425: , p7_a8 JTF_DATE_TABLE
1426: , p7_a9 JTF_DATE_TABLE
1427: , x_return_status out nocopy VARCHAR2

Line 1424: , p7_a7 JTF_VARCHAR2_TABLE_100

1420: , p7_a3 JTF_NUMBER_TABLE
1421: , p7_a4 JTF_DATE_TABLE
1422: , p7_a5 JTF_VARCHAR2_TABLE_100
1423: , p7_a6 JTF_VARCHAR2_TABLE_100
1424: , p7_a7 JTF_VARCHAR2_TABLE_100
1425: , p7_a8 JTF_DATE_TABLE
1426: , p7_a9 JTF_DATE_TABLE
1427: , x_return_status out nocopy VARCHAR2
1428: , x_msg_count out nocopy NUMBER