DBA Data[Home] [Help]

APPS.LNS_PAYOFF_PUB_W dependencies on JTF_VARCHAR2_TABLE_100

Line 5: , a2 JTF_VARCHAR2_TABLE_100

1: package body lns_payoff_pub_w as
2: /* $Header: LNS_PAYOFFJ_B.pls 120.1.12020000.2 2012/07/19 20:58:34 scherkas ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy lns_payoff_pub.invoice_details_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_DATE_TABLE

Line 7: , a4 JTF_VARCHAR2_TABLE_100

3: procedure rosetta_table_copy_in_p1(t out nocopy lns_payoff_pub.invoice_details_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_DATE_TABLE

Line 12: , a9 JTF_VARCHAR2_TABLE_100

8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: ) as
15: ddindx binary_integer; indx binary_integer;
16: begin

Line 13: , a10 JTF_VARCHAR2_TABLE_100

9: , a6 JTF_DATE_TABLE
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: ) as
15: ddindx binary_integer; indx binary_integer;
16: begin
17: if a0 is not null and a0.count > 0 then

Line 44: , a2 out nocopy JTF_VARCHAR2_TABLE_100

40: end if;
41: end rosetta_table_copy_in_p1;
42: procedure rosetta_table_copy_out_p1(t lns_payoff_pub.invoice_details_tbl, a0 out nocopy JTF_NUMBER_TABLE
43: , a1 out nocopy JTF_NUMBER_TABLE
44: , a2 out nocopy JTF_VARCHAR2_TABLE_100
45: , a3 out nocopy JTF_NUMBER_TABLE
46: , a4 out nocopy JTF_VARCHAR2_TABLE_100
47: , a5 out nocopy JTF_NUMBER_TABLE
48: , a6 out nocopy JTF_DATE_TABLE

Line 46: , a4 out nocopy JTF_VARCHAR2_TABLE_100

42: procedure rosetta_table_copy_out_p1(t lns_payoff_pub.invoice_details_tbl, a0 out nocopy JTF_NUMBER_TABLE
43: , a1 out nocopy JTF_NUMBER_TABLE
44: , a2 out nocopy JTF_VARCHAR2_TABLE_100
45: , a3 out nocopy JTF_NUMBER_TABLE
46: , a4 out nocopy JTF_VARCHAR2_TABLE_100
47: , a5 out nocopy JTF_NUMBER_TABLE
48: , a6 out nocopy JTF_DATE_TABLE
49: , a7 out nocopy JTF_DATE_TABLE
50: , a8 out nocopy JTF_DATE_TABLE

Line 51: , a9 out nocopy JTF_VARCHAR2_TABLE_100

47: , a5 out nocopy JTF_NUMBER_TABLE
48: , a6 out nocopy JTF_DATE_TABLE
49: , a7 out nocopy JTF_DATE_TABLE
50: , a8 out nocopy JTF_DATE_TABLE
51: , a9 out nocopy JTF_VARCHAR2_TABLE_100
52: , a10 out nocopy JTF_VARCHAR2_TABLE_100
53: ) as
54: ddindx binary_integer; indx binary_integer;
55: begin

Line 52: , a10 out nocopy JTF_VARCHAR2_TABLE_100

48: , a6 out nocopy JTF_DATE_TABLE
49: , a7 out nocopy JTF_DATE_TABLE
50: , a8 out nocopy JTF_DATE_TABLE
51: , a9 out nocopy JTF_VARCHAR2_TABLE_100
52: , a10 out nocopy JTF_VARCHAR2_TABLE_100
53: ) as
54: ddindx binary_integer; indx binary_integer;
55: begin
56: if t is null or t.count = 0 then

Line 59: a2 := JTF_VARCHAR2_TABLE_100();

55: begin
56: if t is null or t.count = 0 then
57: a0 := JTF_NUMBER_TABLE();
58: a1 := JTF_NUMBER_TABLE();
59: a2 := JTF_VARCHAR2_TABLE_100();
60: a3 := JTF_NUMBER_TABLE();
61: a4 := JTF_VARCHAR2_TABLE_100();
62: a5 := JTF_NUMBER_TABLE();
63: a6 := JTF_DATE_TABLE();

Line 61: a4 := JTF_VARCHAR2_TABLE_100();

57: a0 := JTF_NUMBER_TABLE();
58: a1 := JTF_NUMBER_TABLE();
59: a2 := JTF_VARCHAR2_TABLE_100();
60: a3 := JTF_NUMBER_TABLE();
61: a4 := JTF_VARCHAR2_TABLE_100();
62: a5 := JTF_NUMBER_TABLE();
63: a6 := JTF_DATE_TABLE();
64: a7 := JTF_DATE_TABLE();
65: a8 := JTF_DATE_TABLE();

Line 66: a9 := JTF_VARCHAR2_TABLE_100();

62: a5 := JTF_NUMBER_TABLE();
63: a6 := JTF_DATE_TABLE();
64: a7 := JTF_DATE_TABLE();
65: a8 := JTF_DATE_TABLE();
66: a9 := JTF_VARCHAR2_TABLE_100();
67: a10 := JTF_VARCHAR2_TABLE_100();
68: else
69: a0 := JTF_NUMBER_TABLE();
70: a1 := JTF_NUMBER_TABLE();

Line 67: a10 := JTF_VARCHAR2_TABLE_100();

63: a6 := JTF_DATE_TABLE();
64: a7 := JTF_DATE_TABLE();
65: a8 := JTF_DATE_TABLE();
66: a9 := JTF_VARCHAR2_TABLE_100();
67: a10 := JTF_VARCHAR2_TABLE_100();
68: else
69: a0 := JTF_NUMBER_TABLE();
70: a1 := JTF_NUMBER_TABLE();
71: a2 := JTF_VARCHAR2_TABLE_100();

Line 71: a2 := JTF_VARCHAR2_TABLE_100();

67: a10 := JTF_VARCHAR2_TABLE_100();
68: else
69: a0 := JTF_NUMBER_TABLE();
70: a1 := JTF_NUMBER_TABLE();
71: a2 := JTF_VARCHAR2_TABLE_100();
72: a3 := JTF_NUMBER_TABLE();
73: a4 := JTF_VARCHAR2_TABLE_100();
74: a5 := JTF_NUMBER_TABLE();
75: a6 := JTF_DATE_TABLE();

Line 73: a4 := JTF_VARCHAR2_TABLE_100();

69: a0 := JTF_NUMBER_TABLE();
70: a1 := JTF_NUMBER_TABLE();
71: a2 := JTF_VARCHAR2_TABLE_100();
72: a3 := JTF_NUMBER_TABLE();
73: a4 := JTF_VARCHAR2_TABLE_100();
74: a5 := JTF_NUMBER_TABLE();
75: a6 := JTF_DATE_TABLE();
76: a7 := JTF_DATE_TABLE();
77: a8 := JTF_DATE_TABLE();

Line 78: a9 := JTF_VARCHAR2_TABLE_100();

74: a5 := JTF_NUMBER_TABLE();
75: a6 := JTF_DATE_TABLE();
76: a7 := JTF_DATE_TABLE();
77: a8 := JTF_DATE_TABLE();
78: a9 := JTF_VARCHAR2_TABLE_100();
79: a10 := JTF_VARCHAR2_TABLE_100();
80: if t.count > 0 then
81: a0.extend(t.count);
82: a1.extend(t.count);

Line 79: a10 := JTF_VARCHAR2_TABLE_100();

75: a6 := JTF_DATE_TABLE();
76: a7 := JTF_DATE_TABLE();
77: a8 := JTF_DATE_TABLE();
78: a9 := JTF_VARCHAR2_TABLE_100();
79: a10 := JTF_VARCHAR2_TABLE_100();
80: if t.count > 0 then
81: a0.extend(t.count);
82: a1.extend(t.count);
83: a2.extend(t.count);

Line 118: , a2 JTF_VARCHAR2_TABLE_100

114: end rosetta_table_copy_out_p1;
115:
116: procedure rosetta_table_copy_in_p3(t out nocopy lns_payoff_pub.cash_receipt_tbl, a0 JTF_NUMBER_TABLE
117: , a1 JTF_NUMBER_TABLE
118: , a2 JTF_VARCHAR2_TABLE_100
119: , a3 JTF_NUMBER_TABLE
120: , a4 JTF_DATE_TABLE
121: , a5 JTF_VARCHAR2_TABLE_100
122: , a6 JTF_VARCHAR2_TABLE_100

Line 121: , a5 JTF_VARCHAR2_TABLE_100

117: , a1 JTF_NUMBER_TABLE
118: , a2 JTF_VARCHAR2_TABLE_100
119: , a3 JTF_NUMBER_TABLE
120: , a4 JTF_DATE_TABLE
121: , a5 JTF_VARCHAR2_TABLE_100
122: , a6 JTF_VARCHAR2_TABLE_100
123: , a7 JTF_VARCHAR2_TABLE_100
124: ) as
125: ddindx binary_integer; indx binary_integer;

Line 122: , a6 JTF_VARCHAR2_TABLE_100

118: , a2 JTF_VARCHAR2_TABLE_100
119: , a3 JTF_NUMBER_TABLE
120: , a4 JTF_DATE_TABLE
121: , a5 JTF_VARCHAR2_TABLE_100
122: , a6 JTF_VARCHAR2_TABLE_100
123: , a7 JTF_VARCHAR2_TABLE_100
124: ) as
125: ddindx binary_integer; indx binary_integer;
126: begin

Line 123: , a7 JTF_VARCHAR2_TABLE_100

119: , a3 JTF_NUMBER_TABLE
120: , a4 JTF_DATE_TABLE
121: , a5 JTF_VARCHAR2_TABLE_100
122: , a6 JTF_VARCHAR2_TABLE_100
123: , a7 JTF_VARCHAR2_TABLE_100
124: ) as
125: ddindx binary_integer; indx binary_integer;
126: begin
127: if a0 is not null and a0.count > 0 then

Line 151: , a2 out nocopy JTF_VARCHAR2_TABLE_100

147: end if;
148: end rosetta_table_copy_in_p3;
149: procedure rosetta_table_copy_out_p3(t lns_payoff_pub.cash_receipt_tbl, a0 out nocopy JTF_NUMBER_TABLE
150: , a1 out nocopy JTF_NUMBER_TABLE
151: , a2 out nocopy JTF_VARCHAR2_TABLE_100
152: , a3 out nocopy JTF_NUMBER_TABLE
153: , a4 out nocopy JTF_DATE_TABLE
154: , a5 out nocopy JTF_VARCHAR2_TABLE_100
155: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 154: , a5 out nocopy JTF_VARCHAR2_TABLE_100

150: , a1 out nocopy JTF_NUMBER_TABLE
151: , a2 out nocopy JTF_VARCHAR2_TABLE_100
152: , a3 out nocopy JTF_NUMBER_TABLE
153: , a4 out nocopy JTF_DATE_TABLE
154: , a5 out nocopy JTF_VARCHAR2_TABLE_100
155: , a6 out nocopy JTF_VARCHAR2_TABLE_100
156: , a7 out nocopy JTF_VARCHAR2_TABLE_100
157: ) as
158: ddindx binary_integer; indx binary_integer;

Line 155: , a6 out nocopy JTF_VARCHAR2_TABLE_100

151: , a2 out nocopy JTF_VARCHAR2_TABLE_100
152: , a3 out nocopy JTF_NUMBER_TABLE
153: , a4 out nocopy JTF_DATE_TABLE
154: , a5 out nocopy JTF_VARCHAR2_TABLE_100
155: , a6 out nocopy JTF_VARCHAR2_TABLE_100
156: , a7 out nocopy JTF_VARCHAR2_TABLE_100
157: ) as
158: ddindx binary_integer; indx binary_integer;
159: begin

Line 156: , a7 out nocopy JTF_VARCHAR2_TABLE_100

152: , a3 out nocopy JTF_NUMBER_TABLE
153: , a4 out nocopy JTF_DATE_TABLE
154: , a5 out nocopy JTF_VARCHAR2_TABLE_100
155: , a6 out nocopy JTF_VARCHAR2_TABLE_100
156: , a7 out nocopy JTF_VARCHAR2_TABLE_100
157: ) as
158: ddindx binary_integer; indx binary_integer;
159: begin
160: if t is null or t.count = 0 then

Line 163: a2 := JTF_VARCHAR2_TABLE_100();

159: begin
160: if t is null or t.count = 0 then
161: a0 := JTF_NUMBER_TABLE();
162: a1 := JTF_NUMBER_TABLE();
163: a2 := JTF_VARCHAR2_TABLE_100();
164: a3 := JTF_NUMBER_TABLE();
165: a4 := JTF_DATE_TABLE();
166: a5 := JTF_VARCHAR2_TABLE_100();
167: a6 := JTF_VARCHAR2_TABLE_100();

Line 166: a5 := JTF_VARCHAR2_TABLE_100();

162: a1 := JTF_NUMBER_TABLE();
163: a2 := JTF_VARCHAR2_TABLE_100();
164: a3 := JTF_NUMBER_TABLE();
165: a4 := JTF_DATE_TABLE();
166: a5 := JTF_VARCHAR2_TABLE_100();
167: a6 := JTF_VARCHAR2_TABLE_100();
168: a7 := JTF_VARCHAR2_TABLE_100();
169: else
170: a0 := JTF_NUMBER_TABLE();

Line 167: a6 := JTF_VARCHAR2_TABLE_100();

163: a2 := JTF_VARCHAR2_TABLE_100();
164: a3 := JTF_NUMBER_TABLE();
165: a4 := JTF_DATE_TABLE();
166: a5 := JTF_VARCHAR2_TABLE_100();
167: a6 := JTF_VARCHAR2_TABLE_100();
168: a7 := JTF_VARCHAR2_TABLE_100();
169: else
170: a0 := JTF_NUMBER_TABLE();
171: a1 := JTF_NUMBER_TABLE();

Line 168: a7 := JTF_VARCHAR2_TABLE_100();

164: a3 := JTF_NUMBER_TABLE();
165: a4 := JTF_DATE_TABLE();
166: a5 := JTF_VARCHAR2_TABLE_100();
167: a6 := JTF_VARCHAR2_TABLE_100();
168: a7 := JTF_VARCHAR2_TABLE_100();
169: else
170: a0 := JTF_NUMBER_TABLE();
171: a1 := JTF_NUMBER_TABLE();
172: a2 := JTF_VARCHAR2_TABLE_100();

Line 172: a2 := JTF_VARCHAR2_TABLE_100();

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

Line 175: a5 := JTF_VARCHAR2_TABLE_100();

171: a1 := JTF_NUMBER_TABLE();
172: a2 := JTF_VARCHAR2_TABLE_100();
173: a3 := JTF_NUMBER_TABLE();
174: a4 := JTF_DATE_TABLE();
175: a5 := JTF_VARCHAR2_TABLE_100();
176: a6 := JTF_VARCHAR2_TABLE_100();
177: a7 := JTF_VARCHAR2_TABLE_100();
178: if t.count > 0 then
179: a0.extend(t.count);

Line 176: a6 := JTF_VARCHAR2_TABLE_100();

172: a2 := JTF_VARCHAR2_TABLE_100();
173: a3 := JTF_NUMBER_TABLE();
174: a4 := JTF_DATE_TABLE();
175: a5 := JTF_VARCHAR2_TABLE_100();
176: a6 := JTF_VARCHAR2_TABLE_100();
177: a7 := JTF_VARCHAR2_TABLE_100();
178: if t.count > 0 then
179: a0.extend(t.count);
180: a1.extend(t.count);

Line 177: a7 := JTF_VARCHAR2_TABLE_100();

173: a3 := JTF_NUMBER_TABLE();
174: a4 := JTF_DATE_TABLE();
175: a5 := JTF_VARCHAR2_TABLE_100();
176: a6 := JTF_VARCHAR2_TABLE_100();
177: a7 := JTF_VARCHAR2_TABLE_100();
178: if t.count > 0 then
179: a0.extend(t.count);
180: a1.extend(t.count);
181: a2.extend(t.count);

Line 213: , a5 JTF_VARCHAR2_TABLE_100

209: , a1 JTF_NUMBER_TABLE
210: , a2 JTF_DATE_TABLE
211: , a3 JTF_DATE_TABLE
212: , a4 JTF_DATE_TABLE
213: , a5 JTF_VARCHAR2_TABLE_100
214: , a6 JTF_VARCHAR2_TABLE_100
215: , a7 JTF_VARCHAR2_TABLE_100
216: , a8 JTF_NUMBER_TABLE
217: , a9 JTF_NUMBER_TABLE

Line 214: , a6 JTF_VARCHAR2_TABLE_100

210: , a2 JTF_DATE_TABLE
211: , a3 JTF_DATE_TABLE
212: , a4 JTF_DATE_TABLE
213: , a5 JTF_VARCHAR2_TABLE_100
214: , a6 JTF_VARCHAR2_TABLE_100
215: , a7 JTF_VARCHAR2_TABLE_100
216: , a8 JTF_NUMBER_TABLE
217: , a9 JTF_NUMBER_TABLE
218: , a10 JTF_VARCHAR2_TABLE_100

Line 215: , a7 JTF_VARCHAR2_TABLE_100

211: , a3 JTF_DATE_TABLE
212: , a4 JTF_DATE_TABLE
213: , a5 JTF_VARCHAR2_TABLE_100
214: , a6 JTF_VARCHAR2_TABLE_100
215: , a7 JTF_VARCHAR2_TABLE_100
216: , a8 JTF_NUMBER_TABLE
217: , a9 JTF_NUMBER_TABLE
218: , a10 JTF_VARCHAR2_TABLE_100
219: , a11 JTF_NUMBER_TABLE

Line 218: , a10 JTF_VARCHAR2_TABLE_100

214: , a6 JTF_VARCHAR2_TABLE_100
215: , a7 JTF_VARCHAR2_TABLE_100
216: , a8 JTF_NUMBER_TABLE
217: , a9 JTF_NUMBER_TABLE
218: , a10 JTF_VARCHAR2_TABLE_100
219: , a11 JTF_NUMBER_TABLE
220: , a12 JTF_VARCHAR2_TABLE_100
221: , a13 JTF_VARCHAR2_TABLE_100
222: , a14 JTF_NUMBER_TABLE

Line 220: , a12 JTF_VARCHAR2_TABLE_100

216: , a8 JTF_NUMBER_TABLE
217: , a9 JTF_NUMBER_TABLE
218: , a10 JTF_VARCHAR2_TABLE_100
219: , a11 JTF_NUMBER_TABLE
220: , a12 JTF_VARCHAR2_TABLE_100
221: , a13 JTF_VARCHAR2_TABLE_100
222: , a14 JTF_NUMBER_TABLE
223: , a15 JTF_NUMBER_TABLE
224: , a16 JTF_NUMBER_TABLE

Line 221: , a13 JTF_VARCHAR2_TABLE_100

217: , a9 JTF_NUMBER_TABLE
218: , a10 JTF_VARCHAR2_TABLE_100
219: , a11 JTF_NUMBER_TABLE
220: , a12 JTF_VARCHAR2_TABLE_100
221: , a13 JTF_VARCHAR2_TABLE_100
222: , a14 JTF_NUMBER_TABLE
223: , a15 JTF_NUMBER_TABLE
224: , a16 JTF_NUMBER_TABLE
225: ) as

Line 264: , a5 out nocopy JTF_VARCHAR2_TABLE_100

260: , a1 out nocopy JTF_NUMBER_TABLE
261: , a2 out nocopy JTF_DATE_TABLE
262: , a3 out nocopy JTF_DATE_TABLE
263: , a4 out nocopy JTF_DATE_TABLE
264: , a5 out nocopy JTF_VARCHAR2_TABLE_100
265: , a6 out nocopy JTF_VARCHAR2_TABLE_100
266: , a7 out nocopy JTF_VARCHAR2_TABLE_100
267: , a8 out nocopy JTF_NUMBER_TABLE
268: , a9 out nocopy JTF_NUMBER_TABLE

Line 265: , a6 out nocopy JTF_VARCHAR2_TABLE_100

261: , a2 out nocopy JTF_DATE_TABLE
262: , a3 out nocopy JTF_DATE_TABLE
263: , a4 out nocopy JTF_DATE_TABLE
264: , a5 out nocopy JTF_VARCHAR2_TABLE_100
265: , a6 out nocopy JTF_VARCHAR2_TABLE_100
266: , a7 out nocopy JTF_VARCHAR2_TABLE_100
267: , a8 out nocopy JTF_NUMBER_TABLE
268: , a9 out nocopy JTF_NUMBER_TABLE
269: , a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 266: , a7 out nocopy JTF_VARCHAR2_TABLE_100

262: , a3 out nocopy JTF_DATE_TABLE
263: , a4 out nocopy JTF_DATE_TABLE
264: , a5 out nocopy JTF_VARCHAR2_TABLE_100
265: , a6 out nocopy JTF_VARCHAR2_TABLE_100
266: , a7 out nocopy JTF_VARCHAR2_TABLE_100
267: , a8 out nocopy JTF_NUMBER_TABLE
268: , a9 out nocopy JTF_NUMBER_TABLE
269: , a10 out nocopy JTF_VARCHAR2_TABLE_100
270: , a11 out nocopy JTF_NUMBER_TABLE

Line 269: , a10 out nocopy JTF_VARCHAR2_TABLE_100

265: , a6 out nocopy JTF_VARCHAR2_TABLE_100
266: , a7 out nocopy JTF_VARCHAR2_TABLE_100
267: , a8 out nocopy JTF_NUMBER_TABLE
268: , a9 out nocopy JTF_NUMBER_TABLE
269: , a10 out nocopy JTF_VARCHAR2_TABLE_100
270: , a11 out nocopy JTF_NUMBER_TABLE
271: , a12 out nocopy JTF_VARCHAR2_TABLE_100
272: , a13 out nocopy JTF_VARCHAR2_TABLE_100
273: , a14 out nocopy JTF_NUMBER_TABLE

Line 271: , a12 out nocopy JTF_VARCHAR2_TABLE_100

267: , a8 out nocopy JTF_NUMBER_TABLE
268: , a9 out nocopy JTF_NUMBER_TABLE
269: , a10 out nocopy JTF_VARCHAR2_TABLE_100
270: , a11 out nocopy JTF_NUMBER_TABLE
271: , a12 out nocopy JTF_VARCHAR2_TABLE_100
272: , a13 out nocopy JTF_VARCHAR2_TABLE_100
273: , a14 out nocopy JTF_NUMBER_TABLE
274: , a15 out nocopy JTF_NUMBER_TABLE
275: , a16 out nocopy JTF_NUMBER_TABLE

Line 272: , a13 out nocopy JTF_VARCHAR2_TABLE_100

268: , a9 out nocopy JTF_NUMBER_TABLE
269: , a10 out nocopy JTF_VARCHAR2_TABLE_100
270: , a11 out nocopy JTF_NUMBER_TABLE
271: , a12 out nocopy JTF_VARCHAR2_TABLE_100
272: , a13 out nocopy JTF_VARCHAR2_TABLE_100
273: , a14 out nocopy JTF_NUMBER_TABLE
274: , a15 out nocopy JTF_NUMBER_TABLE
275: , a16 out nocopy JTF_NUMBER_TABLE
276: ) as

Line 285: a5 := JTF_VARCHAR2_TABLE_100();

281: a1 := JTF_NUMBER_TABLE();
282: a2 := JTF_DATE_TABLE();
283: a3 := JTF_DATE_TABLE();
284: a4 := JTF_DATE_TABLE();
285: a5 := JTF_VARCHAR2_TABLE_100();
286: a6 := JTF_VARCHAR2_TABLE_100();
287: a7 := JTF_VARCHAR2_TABLE_100();
288: a8 := JTF_NUMBER_TABLE();
289: a9 := JTF_NUMBER_TABLE();

Line 286: a6 := JTF_VARCHAR2_TABLE_100();

282: a2 := JTF_DATE_TABLE();
283: a3 := JTF_DATE_TABLE();
284: a4 := JTF_DATE_TABLE();
285: a5 := JTF_VARCHAR2_TABLE_100();
286: a6 := JTF_VARCHAR2_TABLE_100();
287: a7 := JTF_VARCHAR2_TABLE_100();
288: a8 := JTF_NUMBER_TABLE();
289: a9 := JTF_NUMBER_TABLE();
290: a10 := JTF_VARCHAR2_TABLE_100();

Line 287: a7 := JTF_VARCHAR2_TABLE_100();

283: a3 := JTF_DATE_TABLE();
284: a4 := JTF_DATE_TABLE();
285: a5 := JTF_VARCHAR2_TABLE_100();
286: a6 := JTF_VARCHAR2_TABLE_100();
287: a7 := JTF_VARCHAR2_TABLE_100();
288: a8 := JTF_NUMBER_TABLE();
289: a9 := JTF_NUMBER_TABLE();
290: a10 := JTF_VARCHAR2_TABLE_100();
291: a11 := JTF_NUMBER_TABLE();

Line 290: a10 := JTF_VARCHAR2_TABLE_100();

286: a6 := JTF_VARCHAR2_TABLE_100();
287: a7 := JTF_VARCHAR2_TABLE_100();
288: a8 := JTF_NUMBER_TABLE();
289: a9 := JTF_NUMBER_TABLE();
290: a10 := JTF_VARCHAR2_TABLE_100();
291: a11 := JTF_NUMBER_TABLE();
292: a12 := JTF_VARCHAR2_TABLE_100();
293: a13 := JTF_VARCHAR2_TABLE_100();
294: a14 := JTF_NUMBER_TABLE();

Line 292: a12 := JTF_VARCHAR2_TABLE_100();

288: a8 := JTF_NUMBER_TABLE();
289: a9 := JTF_NUMBER_TABLE();
290: a10 := JTF_VARCHAR2_TABLE_100();
291: a11 := JTF_NUMBER_TABLE();
292: a12 := JTF_VARCHAR2_TABLE_100();
293: a13 := JTF_VARCHAR2_TABLE_100();
294: a14 := JTF_NUMBER_TABLE();
295: a15 := JTF_NUMBER_TABLE();
296: a16 := JTF_NUMBER_TABLE();

Line 293: a13 := JTF_VARCHAR2_TABLE_100();

289: a9 := JTF_NUMBER_TABLE();
290: a10 := JTF_VARCHAR2_TABLE_100();
291: a11 := JTF_NUMBER_TABLE();
292: a12 := JTF_VARCHAR2_TABLE_100();
293: a13 := JTF_VARCHAR2_TABLE_100();
294: a14 := JTF_NUMBER_TABLE();
295: a15 := JTF_NUMBER_TABLE();
296: a16 := JTF_NUMBER_TABLE();
297: else

Line 303: a5 := JTF_VARCHAR2_TABLE_100();

299: a1 := JTF_NUMBER_TABLE();
300: a2 := JTF_DATE_TABLE();
301: a3 := JTF_DATE_TABLE();
302: a4 := JTF_DATE_TABLE();
303: a5 := JTF_VARCHAR2_TABLE_100();
304: a6 := JTF_VARCHAR2_TABLE_100();
305: a7 := JTF_VARCHAR2_TABLE_100();
306: a8 := JTF_NUMBER_TABLE();
307: a9 := JTF_NUMBER_TABLE();

Line 304: a6 := JTF_VARCHAR2_TABLE_100();

300: a2 := JTF_DATE_TABLE();
301: a3 := JTF_DATE_TABLE();
302: a4 := JTF_DATE_TABLE();
303: a5 := JTF_VARCHAR2_TABLE_100();
304: a6 := JTF_VARCHAR2_TABLE_100();
305: a7 := JTF_VARCHAR2_TABLE_100();
306: a8 := JTF_NUMBER_TABLE();
307: a9 := JTF_NUMBER_TABLE();
308: a10 := JTF_VARCHAR2_TABLE_100();

Line 305: a7 := JTF_VARCHAR2_TABLE_100();

301: a3 := JTF_DATE_TABLE();
302: a4 := JTF_DATE_TABLE();
303: a5 := JTF_VARCHAR2_TABLE_100();
304: a6 := JTF_VARCHAR2_TABLE_100();
305: a7 := JTF_VARCHAR2_TABLE_100();
306: a8 := JTF_NUMBER_TABLE();
307: a9 := JTF_NUMBER_TABLE();
308: a10 := JTF_VARCHAR2_TABLE_100();
309: a11 := JTF_NUMBER_TABLE();

Line 308: a10 := JTF_VARCHAR2_TABLE_100();

304: a6 := JTF_VARCHAR2_TABLE_100();
305: a7 := JTF_VARCHAR2_TABLE_100();
306: a8 := JTF_NUMBER_TABLE();
307: a9 := JTF_NUMBER_TABLE();
308: a10 := JTF_VARCHAR2_TABLE_100();
309: a11 := JTF_NUMBER_TABLE();
310: a12 := JTF_VARCHAR2_TABLE_100();
311: a13 := JTF_VARCHAR2_TABLE_100();
312: a14 := JTF_NUMBER_TABLE();

Line 310: a12 := JTF_VARCHAR2_TABLE_100();

306: a8 := JTF_NUMBER_TABLE();
307: a9 := JTF_NUMBER_TABLE();
308: a10 := JTF_VARCHAR2_TABLE_100();
309: a11 := JTF_NUMBER_TABLE();
310: a12 := JTF_VARCHAR2_TABLE_100();
311: a13 := JTF_VARCHAR2_TABLE_100();
312: a14 := JTF_NUMBER_TABLE();
313: a15 := JTF_NUMBER_TABLE();
314: a16 := JTF_NUMBER_TABLE();

Line 311: a13 := JTF_VARCHAR2_TABLE_100();

307: a9 := JTF_NUMBER_TABLE();
308: a10 := JTF_VARCHAR2_TABLE_100();
309: a11 := JTF_NUMBER_TABLE();
310: a12 := JTF_VARCHAR2_TABLE_100();
311: a13 := JTF_VARCHAR2_TABLE_100();
312: a14 := JTF_NUMBER_TABLE();
313: a15 := JTF_NUMBER_TABLE();
314: a16 := JTF_NUMBER_TABLE();
315: if t.count > 0 then

Line 369: , p4_a2 JTF_VARCHAR2_TABLE_100

365: , p_loan_id NUMBER
366: , p_payoff_date DATE
367: , p4_a0 JTF_NUMBER_TABLE
368: , p4_a1 JTF_NUMBER_TABLE
369: , p4_a2 JTF_VARCHAR2_TABLE_100
370: , p4_a3 JTF_NUMBER_TABLE
371: , p4_a4 JTF_DATE_TABLE
372: , p4_a5 JTF_VARCHAR2_TABLE_100
373: , p4_a6 JTF_VARCHAR2_TABLE_100

Line 372: , p4_a5 JTF_VARCHAR2_TABLE_100

368: , p4_a1 JTF_NUMBER_TABLE
369: , p4_a2 JTF_VARCHAR2_TABLE_100
370: , p4_a3 JTF_NUMBER_TABLE
371: , p4_a4 JTF_DATE_TABLE
372: , p4_a5 JTF_VARCHAR2_TABLE_100
373: , p4_a6 JTF_VARCHAR2_TABLE_100
374: , p4_a7 JTF_VARCHAR2_TABLE_100
375: , x_return_status out nocopy VARCHAR2
376: , x_msg_count out nocopy NUMBER

Line 373: , p4_a6 JTF_VARCHAR2_TABLE_100

369: , p4_a2 JTF_VARCHAR2_TABLE_100
370: , p4_a3 JTF_NUMBER_TABLE
371: , p4_a4 JTF_DATE_TABLE
372: , p4_a5 JTF_VARCHAR2_TABLE_100
373: , p4_a6 JTF_VARCHAR2_TABLE_100
374: , p4_a7 JTF_VARCHAR2_TABLE_100
375: , x_return_status out nocopy VARCHAR2
376: , x_msg_count out nocopy NUMBER
377: , x_msg_data out nocopy VARCHAR2

Line 374: , p4_a7 JTF_VARCHAR2_TABLE_100

370: , p4_a3 JTF_NUMBER_TABLE
371: , p4_a4 JTF_DATE_TABLE
372: , p4_a5 JTF_VARCHAR2_TABLE_100
373: , p4_a6 JTF_VARCHAR2_TABLE_100
374: , p4_a7 JTF_VARCHAR2_TABLE_100
375: , x_return_status out nocopy VARCHAR2
376: , x_msg_count out nocopy NUMBER
377: , x_msg_data out nocopy VARCHAR2
378: )

Line 429: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100

425: , p_loan_id NUMBER
426: , p_payoff_date DATE
427: , p4_a0 out nocopy JTF_NUMBER_TABLE
428: , p4_a1 out nocopy JTF_NUMBER_TABLE
429: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
430: , p4_a3 out nocopy JTF_NUMBER_TABLE
431: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
432: , p4_a5 out nocopy JTF_NUMBER_TABLE
433: , p4_a6 out nocopy JTF_DATE_TABLE

Line 431: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100

427: , p4_a0 out nocopy JTF_NUMBER_TABLE
428: , p4_a1 out nocopy JTF_NUMBER_TABLE
429: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
430: , p4_a3 out nocopy JTF_NUMBER_TABLE
431: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
432: , p4_a5 out nocopy JTF_NUMBER_TABLE
433: , p4_a6 out nocopy JTF_DATE_TABLE
434: , p4_a7 out nocopy JTF_DATE_TABLE
435: , p4_a8 out nocopy JTF_DATE_TABLE

Line 436: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100

432: , p4_a5 out nocopy JTF_NUMBER_TABLE
433: , p4_a6 out nocopy JTF_DATE_TABLE
434: , p4_a7 out nocopy JTF_DATE_TABLE
435: , p4_a8 out nocopy JTF_DATE_TABLE
436: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
437: , p4_a10 out nocopy JTF_VARCHAR2_TABLE_100
438: , x_return_status out nocopy VARCHAR2
439: , x_msg_count out nocopy NUMBER
440: , x_msg_data out nocopy VARCHAR2

Line 437: , p4_a10 out nocopy JTF_VARCHAR2_TABLE_100

433: , p4_a6 out nocopy JTF_DATE_TABLE
434: , p4_a7 out nocopy JTF_DATE_TABLE
435: , p4_a8 out nocopy JTF_DATE_TABLE
436: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
437: , p4_a10 out nocopy JTF_VARCHAR2_TABLE_100
438: , x_return_status out nocopy VARCHAR2
439: , x_msg_count out nocopy NUMBER
440: , x_msg_data out nocopy VARCHAR2
441: )

Line 498: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100

494: , p4_a1 out nocopy JTF_NUMBER_TABLE
495: , p4_a2 out nocopy JTF_DATE_TABLE
496: , p4_a3 out nocopy JTF_DATE_TABLE
497: , p4_a4 out nocopy JTF_DATE_TABLE
498: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100
499: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
500: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_100
501: , p4_a8 out nocopy JTF_NUMBER_TABLE
502: , p4_a9 out nocopy JTF_NUMBER_TABLE

Line 499: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100

495: , p4_a2 out nocopy JTF_DATE_TABLE
496: , p4_a3 out nocopy JTF_DATE_TABLE
497: , p4_a4 out nocopy JTF_DATE_TABLE
498: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100
499: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
500: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_100
501: , p4_a8 out nocopy JTF_NUMBER_TABLE
502: , p4_a9 out nocopy JTF_NUMBER_TABLE
503: , p4_a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 500: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_100

496: , p4_a3 out nocopy JTF_DATE_TABLE
497: , p4_a4 out nocopy JTF_DATE_TABLE
498: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100
499: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
500: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_100
501: , p4_a8 out nocopy JTF_NUMBER_TABLE
502: , p4_a9 out nocopy JTF_NUMBER_TABLE
503: , p4_a10 out nocopy JTF_VARCHAR2_TABLE_100
504: , p4_a11 out nocopy JTF_NUMBER_TABLE

Line 503: , p4_a10 out nocopy JTF_VARCHAR2_TABLE_100

499: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
500: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_100
501: , p4_a8 out nocopy JTF_NUMBER_TABLE
502: , p4_a9 out nocopy JTF_NUMBER_TABLE
503: , p4_a10 out nocopy JTF_VARCHAR2_TABLE_100
504: , p4_a11 out nocopy JTF_NUMBER_TABLE
505: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
506: , p4_a13 out nocopy JTF_VARCHAR2_TABLE_100
507: , p4_a14 out nocopy JTF_NUMBER_TABLE

Line 505: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100

501: , p4_a8 out nocopy JTF_NUMBER_TABLE
502: , p4_a9 out nocopy JTF_NUMBER_TABLE
503: , p4_a10 out nocopy JTF_VARCHAR2_TABLE_100
504: , p4_a11 out nocopy JTF_NUMBER_TABLE
505: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
506: , p4_a13 out nocopy JTF_VARCHAR2_TABLE_100
507: , p4_a14 out nocopy JTF_NUMBER_TABLE
508: , p4_a15 out nocopy JTF_NUMBER_TABLE
509: , p4_a16 out nocopy JTF_NUMBER_TABLE

Line 506: , p4_a13 out nocopy JTF_VARCHAR2_TABLE_100

502: , p4_a9 out nocopy JTF_NUMBER_TABLE
503: , p4_a10 out nocopy JTF_VARCHAR2_TABLE_100
504: , p4_a11 out nocopy JTF_NUMBER_TABLE
505: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
506: , p4_a13 out nocopy JTF_VARCHAR2_TABLE_100
507: , p4_a14 out nocopy JTF_NUMBER_TABLE
508: , p4_a15 out nocopy JTF_NUMBER_TABLE
509: , p4_a16 out nocopy JTF_NUMBER_TABLE
510: , x_return_status out nocopy VARCHAR2

Line 582: , p10_a5 in out nocopy JTF_VARCHAR2_TABLE_100

578: , p10_a1 in out nocopy JTF_NUMBER_TABLE
579: , p10_a2 in out nocopy JTF_DATE_TABLE
580: , p10_a3 in out nocopy JTF_DATE_TABLE
581: , p10_a4 in out nocopy JTF_DATE_TABLE
582: , p10_a5 in out nocopy JTF_VARCHAR2_TABLE_100
583: , p10_a6 in out nocopy JTF_VARCHAR2_TABLE_100
584: , p10_a7 in out nocopy JTF_VARCHAR2_TABLE_100
585: , p10_a8 in out nocopy JTF_NUMBER_TABLE
586: , p10_a9 in out nocopy JTF_NUMBER_TABLE

Line 583: , p10_a6 in out nocopy JTF_VARCHAR2_TABLE_100

579: , p10_a2 in out nocopy JTF_DATE_TABLE
580: , p10_a3 in out nocopy JTF_DATE_TABLE
581: , p10_a4 in out nocopy JTF_DATE_TABLE
582: , p10_a5 in out nocopy JTF_VARCHAR2_TABLE_100
583: , p10_a6 in out nocopy JTF_VARCHAR2_TABLE_100
584: , p10_a7 in out nocopy JTF_VARCHAR2_TABLE_100
585: , p10_a8 in out nocopy JTF_NUMBER_TABLE
586: , p10_a9 in out nocopy JTF_NUMBER_TABLE
587: , p10_a10 in out nocopy JTF_VARCHAR2_TABLE_100

Line 584: , p10_a7 in out nocopy JTF_VARCHAR2_TABLE_100

580: , p10_a3 in out nocopy JTF_DATE_TABLE
581: , p10_a4 in out nocopy JTF_DATE_TABLE
582: , p10_a5 in out nocopy JTF_VARCHAR2_TABLE_100
583: , p10_a6 in out nocopy JTF_VARCHAR2_TABLE_100
584: , p10_a7 in out nocopy JTF_VARCHAR2_TABLE_100
585: , p10_a8 in out nocopy JTF_NUMBER_TABLE
586: , p10_a9 in out nocopy JTF_NUMBER_TABLE
587: , p10_a10 in out nocopy JTF_VARCHAR2_TABLE_100
588: , p10_a11 in out nocopy JTF_NUMBER_TABLE

Line 587: , p10_a10 in out nocopy JTF_VARCHAR2_TABLE_100

583: , p10_a6 in out nocopy JTF_VARCHAR2_TABLE_100
584: , p10_a7 in out nocopy JTF_VARCHAR2_TABLE_100
585: , p10_a8 in out nocopy JTF_NUMBER_TABLE
586: , p10_a9 in out nocopy JTF_NUMBER_TABLE
587: , p10_a10 in out nocopy JTF_VARCHAR2_TABLE_100
588: , p10_a11 in out nocopy JTF_NUMBER_TABLE
589: , p10_a12 in out nocopy JTF_VARCHAR2_TABLE_100
590: , p10_a13 in out nocopy JTF_VARCHAR2_TABLE_100
591: , p10_a14 in out nocopy JTF_NUMBER_TABLE

Line 589: , p10_a12 in out nocopy JTF_VARCHAR2_TABLE_100

585: , p10_a8 in out nocopy JTF_NUMBER_TABLE
586: , p10_a9 in out nocopy JTF_NUMBER_TABLE
587: , p10_a10 in out nocopy JTF_VARCHAR2_TABLE_100
588: , p10_a11 in out nocopy JTF_NUMBER_TABLE
589: , p10_a12 in out nocopy JTF_VARCHAR2_TABLE_100
590: , p10_a13 in out nocopy JTF_VARCHAR2_TABLE_100
591: , p10_a14 in out nocopy JTF_NUMBER_TABLE
592: , p10_a15 in out nocopy JTF_NUMBER_TABLE
593: , p10_a16 in out nocopy JTF_NUMBER_TABLE

Line 590: , p10_a13 in out nocopy JTF_VARCHAR2_TABLE_100

586: , p10_a9 in out nocopy JTF_NUMBER_TABLE
587: , p10_a10 in out nocopy JTF_VARCHAR2_TABLE_100
588: , p10_a11 in out nocopy JTF_NUMBER_TABLE
589: , p10_a12 in out nocopy JTF_VARCHAR2_TABLE_100
590: , p10_a13 in out nocopy JTF_VARCHAR2_TABLE_100
591: , p10_a14 in out nocopy JTF_NUMBER_TABLE
592: , p10_a15 in out nocopy JTF_NUMBER_TABLE
593: , p10_a16 in out nocopy JTF_NUMBER_TABLE
594: , x_return_status out nocopy VARCHAR2