DBA Data[Home] [Help]

APPS.LNS_FINANCIALS_W dependencies on JTF_VARCHAR2_TABLE_2000

Line 137: , a28 JTF_VARCHAR2_TABLE_2000

133: , a24 JTF_NUMBER_TABLE
134: , a25 JTF_NUMBER_TABLE
135: , a26 JTF_NUMBER_TABLE
136: , a27 JTF_NUMBER_TABLE
137: , a28 JTF_VARCHAR2_TABLE_2000
138: , a29 JTF_VARCHAR2_TABLE_2000
139: , a30 JTF_VARCHAR2_TABLE_2000
140: , a31 JTF_VARCHAR2_TABLE_2000
141: , a32 JTF_NUMBER_TABLE

Line 138: , a29 JTF_VARCHAR2_TABLE_2000

134: , a25 JTF_NUMBER_TABLE
135: , a26 JTF_NUMBER_TABLE
136: , a27 JTF_NUMBER_TABLE
137: , a28 JTF_VARCHAR2_TABLE_2000
138: , a29 JTF_VARCHAR2_TABLE_2000
139: , a30 JTF_VARCHAR2_TABLE_2000
140: , a31 JTF_VARCHAR2_TABLE_2000
141: , a32 JTF_NUMBER_TABLE
142: , a33 JTF_VARCHAR2_TABLE_200

Line 139: , a30 JTF_VARCHAR2_TABLE_2000

135: , a26 JTF_NUMBER_TABLE
136: , a27 JTF_NUMBER_TABLE
137: , a28 JTF_VARCHAR2_TABLE_2000
138: , a29 JTF_VARCHAR2_TABLE_2000
139: , a30 JTF_VARCHAR2_TABLE_2000
140: , a31 JTF_VARCHAR2_TABLE_2000
141: , a32 JTF_NUMBER_TABLE
142: , a33 JTF_VARCHAR2_TABLE_200
143: , a34 JTF_NUMBER_TABLE

Line 140: , a31 JTF_VARCHAR2_TABLE_2000

136: , a27 JTF_NUMBER_TABLE
137: , a28 JTF_VARCHAR2_TABLE_2000
138: , a29 JTF_VARCHAR2_TABLE_2000
139: , a30 JTF_VARCHAR2_TABLE_2000
140: , a31 JTF_VARCHAR2_TABLE_2000
141: , a32 JTF_NUMBER_TABLE
142: , a33 JTF_VARCHAR2_TABLE_200
143: , a34 JTF_NUMBER_TABLE
144: , a35 JTF_NUMBER_TABLE

Line 145: , a36 JTF_VARCHAR2_TABLE_2000

141: , a32 JTF_NUMBER_TABLE
142: , a33 JTF_VARCHAR2_TABLE_200
143: , a34 JTF_NUMBER_TABLE
144: , a35 JTF_NUMBER_TABLE
145: , a36 JTF_VARCHAR2_TABLE_2000
146: , a37 JTF_NUMBER_TABLE
147: , a38 JTF_NUMBER_TABLE
148: , a39 JTF_NUMBER_TABLE
149: , a40 JTF_VARCHAR2_TABLE_2000

Line 149: , a40 JTF_VARCHAR2_TABLE_2000

145: , a36 JTF_VARCHAR2_TABLE_2000
146: , a37 JTF_NUMBER_TABLE
147: , a38 JTF_NUMBER_TABLE
148: , a39 JTF_NUMBER_TABLE
149: , a40 JTF_VARCHAR2_TABLE_2000
150: , a41 JTF_NUMBER_TABLE
151: , a42 JTF_VARCHAR2_TABLE_2000
152: ) as
153: ddindx binary_integer; indx binary_integer;

Line 151: , a42 JTF_VARCHAR2_TABLE_2000

147: , a38 JTF_NUMBER_TABLE
148: , a39 JTF_NUMBER_TABLE
149: , a40 JTF_VARCHAR2_TABLE_2000
150: , a41 JTF_NUMBER_TABLE
151: , a42 JTF_VARCHAR2_TABLE_2000
152: ) as
153: ddindx binary_integer; indx binary_integer;
154: begin
155: if a0 is not null and a0.count > 0 then

Line 240: , a28 out nocopy JTF_VARCHAR2_TABLE_2000

236: , a24 out nocopy JTF_NUMBER_TABLE
237: , a25 out nocopy JTF_NUMBER_TABLE
238: , a26 out nocopy JTF_NUMBER_TABLE
239: , a27 out nocopy JTF_NUMBER_TABLE
240: , a28 out nocopy JTF_VARCHAR2_TABLE_2000
241: , a29 out nocopy JTF_VARCHAR2_TABLE_2000
242: , a30 out nocopy JTF_VARCHAR2_TABLE_2000
243: , a31 out nocopy JTF_VARCHAR2_TABLE_2000
244: , a32 out nocopy JTF_NUMBER_TABLE

Line 241: , a29 out nocopy JTF_VARCHAR2_TABLE_2000

237: , a25 out nocopy JTF_NUMBER_TABLE
238: , a26 out nocopy JTF_NUMBER_TABLE
239: , a27 out nocopy JTF_NUMBER_TABLE
240: , a28 out nocopy JTF_VARCHAR2_TABLE_2000
241: , a29 out nocopy JTF_VARCHAR2_TABLE_2000
242: , a30 out nocopy JTF_VARCHAR2_TABLE_2000
243: , a31 out nocopy JTF_VARCHAR2_TABLE_2000
244: , a32 out nocopy JTF_NUMBER_TABLE
245: , a33 out nocopy JTF_VARCHAR2_TABLE_200

Line 242: , a30 out nocopy JTF_VARCHAR2_TABLE_2000

238: , a26 out nocopy JTF_NUMBER_TABLE
239: , a27 out nocopy JTF_NUMBER_TABLE
240: , a28 out nocopy JTF_VARCHAR2_TABLE_2000
241: , a29 out nocopy JTF_VARCHAR2_TABLE_2000
242: , a30 out nocopy JTF_VARCHAR2_TABLE_2000
243: , a31 out nocopy JTF_VARCHAR2_TABLE_2000
244: , a32 out nocopy JTF_NUMBER_TABLE
245: , a33 out nocopy JTF_VARCHAR2_TABLE_200
246: , a34 out nocopy JTF_NUMBER_TABLE

Line 243: , a31 out nocopy JTF_VARCHAR2_TABLE_2000

239: , a27 out nocopy JTF_NUMBER_TABLE
240: , a28 out nocopy JTF_VARCHAR2_TABLE_2000
241: , a29 out nocopy JTF_VARCHAR2_TABLE_2000
242: , a30 out nocopy JTF_VARCHAR2_TABLE_2000
243: , a31 out nocopy JTF_VARCHAR2_TABLE_2000
244: , a32 out nocopy JTF_NUMBER_TABLE
245: , a33 out nocopy JTF_VARCHAR2_TABLE_200
246: , a34 out nocopy JTF_NUMBER_TABLE
247: , a35 out nocopy JTF_NUMBER_TABLE

Line 248: , a36 out nocopy JTF_VARCHAR2_TABLE_2000

244: , a32 out nocopy JTF_NUMBER_TABLE
245: , a33 out nocopy JTF_VARCHAR2_TABLE_200
246: , a34 out nocopy JTF_NUMBER_TABLE
247: , a35 out nocopy JTF_NUMBER_TABLE
248: , a36 out nocopy JTF_VARCHAR2_TABLE_2000
249: , a37 out nocopy JTF_NUMBER_TABLE
250: , a38 out nocopy JTF_NUMBER_TABLE
251: , a39 out nocopy JTF_NUMBER_TABLE
252: , a40 out nocopy JTF_VARCHAR2_TABLE_2000

Line 252: , a40 out nocopy JTF_VARCHAR2_TABLE_2000

248: , a36 out nocopy JTF_VARCHAR2_TABLE_2000
249: , a37 out nocopy JTF_NUMBER_TABLE
250: , a38 out nocopy JTF_NUMBER_TABLE
251: , a39 out nocopy JTF_NUMBER_TABLE
252: , a40 out nocopy JTF_VARCHAR2_TABLE_2000
253: , a41 out nocopy JTF_NUMBER_TABLE
254: , a42 out nocopy JTF_VARCHAR2_TABLE_2000
255: ) as
256: ddindx binary_integer; indx binary_integer;

Line 254: , a42 out nocopy JTF_VARCHAR2_TABLE_2000

250: , a38 out nocopy JTF_NUMBER_TABLE
251: , a39 out nocopy JTF_NUMBER_TABLE
252: , a40 out nocopy JTF_VARCHAR2_TABLE_2000
253: , a41 out nocopy JTF_NUMBER_TABLE
254: , a42 out nocopy JTF_VARCHAR2_TABLE_2000
255: ) as
256: ddindx binary_integer; indx binary_integer;
257: begin
258: if t is null or t.count = 0 then

Line 287: a28 := JTF_VARCHAR2_TABLE_2000();

283: a24 := JTF_NUMBER_TABLE();
284: a25 := JTF_NUMBER_TABLE();
285: a26 := JTF_NUMBER_TABLE();
286: a27 := JTF_NUMBER_TABLE();
287: a28 := JTF_VARCHAR2_TABLE_2000();
288: a29 := JTF_VARCHAR2_TABLE_2000();
289: a30 := JTF_VARCHAR2_TABLE_2000();
290: a31 := JTF_VARCHAR2_TABLE_2000();
291: a32 := JTF_NUMBER_TABLE();

Line 288: a29 := JTF_VARCHAR2_TABLE_2000();

284: a25 := JTF_NUMBER_TABLE();
285: a26 := JTF_NUMBER_TABLE();
286: a27 := JTF_NUMBER_TABLE();
287: a28 := JTF_VARCHAR2_TABLE_2000();
288: a29 := JTF_VARCHAR2_TABLE_2000();
289: a30 := JTF_VARCHAR2_TABLE_2000();
290: a31 := JTF_VARCHAR2_TABLE_2000();
291: a32 := JTF_NUMBER_TABLE();
292: a33 := JTF_VARCHAR2_TABLE_200();

Line 289: a30 := JTF_VARCHAR2_TABLE_2000();

285: a26 := JTF_NUMBER_TABLE();
286: a27 := JTF_NUMBER_TABLE();
287: a28 := JTF_VARCHAR2_TABLE_2000();
288: a29 := JTF_VARCHAR2_TABLE_2000();
289: a30 := JTF_VARCHAR2_TABLE_2000();
290: a31 := JTF_VARCHAR2_TABLE_2000();
291: a32 := JTF_NUMBER_TABLE();
292: a33 := JTF_VARCHAR2_TABLE_200();
293: a34 := JTF_NUMBER_TABLE();

Line 290: a31 := JTF_VARCHAR2_TABLE_2000();

286: a27 := JTF_NUMBER_TABLE();
287: a28 := JTF_VARCHAR2_TABLE_2000();
288: a29 := JTF_VARCHAR2_TABLE_2000();
289: a30 := JTF_VARCHAR2_TABLE_2000();
290: a31 := JTF_VARCHAR2_TABLE_2000();
291: a32 := JTF_NUMBER_TABLE();
292: a33 := JTF_VARCHAR2_TABLE_200();
293: a34 := JTF_NUMBER_TABLE();
294: a35 := JTF_NUMBER_TABLE();

Line 295: a36 := JTF_VARCHAR2_TABLE_2000();

291: a32 := JTF_NUMBER_TABLE();
292: a33 := JTF_VARCHAR2_TABLE_200();
293: a34 := JTF_NUMBER_TABLE();
294: a35 := JTF_NUMBER_TABLE();
295: a36 := JTF_VARCHAR2_TABLE_2000();
296: a37 := JTF_NUMBER_TABLE();
297: a38 := JTF_NUMBER_TABLE();
298: a39 := JTF_NUMBER_TABLE();
299: a40 := JTF_VARCHAR2_TABLE_2000();

Line 299: a40 := JTF_VARCHAR2_TABLE_2000();

295: a36 := JTF_VARCHAR2_TABLE_2000();
296: a37 := JTF_NUMBER_TABLE();
297: a38 := JTF_NUMBER_TABLE();
298: a39 := JTF_NUMBER_TABLE();
299: a40 := JTF_VARCHAR2_TABLE_2000();
300: a41 := JTF_NUMBER_TABLE();
301: a42 := JTF_VARCHAR2_TABLE_2000();
302: else
303: a0 := JTF_NUMBER_TABLE();

Line 301: a42 := JTF_VARCHAR2_TABLE_2000();

297: a38 := JTF_NUMBER_TABLE();
298: a39 := JTF_NUMBER_TABLE();
299: a40 := JTF_VARCHAR2_TABLE_2000();
300: a41 := JTF_NUMBER_TABLE();
301: a42 := JTF_VARCHAR2_TABLE_2000();
302: else
303: a0 := JTF_NUMBER_TABLE();
304: a1 := JTF_DATE_TABLE();
305: a2 := JTF_DATE_TABLE();

Line 331: a28 := JTF_VARCHAR2_TABLE_2000();

327: a24 := JTF_NUMBER_TABLE();
328: a25 := JTF_NUMBER_TABLE();
329: a26 := JTF_NUMBER_TABLE();
330: a27 := JTF_NUMBER_TABLE();
331: a28 := JTF_VARCHAR2_TABLE_2000();
332: a29 := JTF_VARCHAR2_TABLE_2000();
333: a30 := JTF_VARCHAR2_TABLE_2000();
334: a31 := JTF_VARCHAR2_TABLE_2000();
335: a32 := JTF_NUMBER_TABLE();

Line 332: a29 := JTF_VARCHAR2_TABLE_2000();

328: a25 := JTF_NUMBER_TABLE();
329: a26 := JTF_NUMBER_TABLE();
330: a27 := JTF_NUMBER_TABLE();
331: a28 := JTF_VARCHAR2_TABLE_2000();
332: a29 := JTF_VARCHAR2_TABLE_2000();
333: a30 := JTF_VARCHAR2_TABLE_2000();
334: a31 := JTF_VARCHAR2_TABLE_2000();
335: a32 := JTF_NUMBER_TABLE();
336: a33 := JTF_VARCHAR2_TABLE_200();

Line 333: a30 := JTF_VARCHAR2_TABLE_2000();

329: a26 := JTF_NUMBER_TABLE();
330: a27 := JTF_NUMBER_TABLE();
331: a28 := JTF_VARCHAR2_TABLE_2000();
332: a29 := JTF_VARCHAR2_TABLE_2000();
333: a30 := JTF_VARCHAR2_TABLE_2000();
334: a31 := JTF_VARCHAR2_TABLE_2000();
335: a32 := JTF_NUMBER_TABLE();
336: a33 := JTF_VARCHAR2_TABLE_200();
337: a34 := JTF_NUMBER_TABLE();

Line 334: a31 := JTF_VARCHAR2_TABLE_2000();

330: a27 := JTF_NUMBER_TABLE();
331: a28 := JTF_VARCHAR2_TABLE_2000();
332: a29 := JTF_VARCHAR2_TABLE_2000();
333: a30 := JTF_VARCHAR2_TABLE_2000();
334: a31 := JTF_VARCHAR2_TABLE_2000();
335: a32 := JTF_NUMBER_TABLE();
336: a33 := JTF_VARCHAR2_TABLE_200();
337: a34 := JTF_NUMBER_TABLE();
338: a35 := JTF_NUMBER_TABLE();

Line 339: a36 := JTF_VARCHAR2_TABLE_2000();

335: a32 := JTF_NUMBER_TABLE();
336: a33 := JTF_VARCHAR2_TABLE_200();
337: a34 := JTF_NUMBER_TABLE();
338: a35 := JTF_NUMBER_TABLE();
339: a36 := JTF_VARCHAR2_TABLE_2000();
340: a37 := JTF_NUMBER_TABLE();
341: a38 := JTF_NUMBER_TABLE();
342: a39 := JTF_NUMBER_TABLE();
343: a40 := JTF_VARCHAR2_TABLE_2000();

Line 343: a40 := JTF_VARCHAR2_TABLE_2000();

339: a36 := JTF_VARCHAR2_TABLE_2000();
340: a37 := JTF_NUMBER_TABLE();
341: a38 := JTF_NUMBER_TABLE();
342: a39 := JTF_NUMBER_TABLE();
343: a40 := JTF_VARCHAR2_TABLE_2000();
344: a41 := JTF_NUMBER_TABLE();
345: a42 := JTF_VARCHAR2_TABLE_2000();
346: if t.count > 0 then
347: a0.extend(t.count);

Line 345: a42 := JTF_VARCHAR2_TABLE_2000();

341: a38 := JTF_NUMBER_TABLE();
342: a39 := JTF_NUMBER_TABLE();
343: a40 := JTF_VARCHAR2_TABLE_2000();
344: a41 := JTF_NUMBER_TABLE();
345: a42 := JTF_VARCHAR2_TABLE_2000();
346: if t.count > 0 then
347: a0.extend(t.count);
348: a1.extend(t.count);
349: a2.extend(t.count);

Line 1878: , p4_a28 out nocopy JTF_VARCHAR2_TABLE_2000

1874: , p4_a24 out nocopy JTF_NUMBER_TABLE
1875: , p4_a25 out nocopy JTF_NUMBER_TABLE
1876: , p4_a26 out nocopy JTF_NUMBER_TABLE
1877: , p4_a27 out nocopy JTF_NUMBER_TABLE
1878: , p4_a28 out nocopy JTF_VARCHAR2_TABLE_2000
1879: , p4_a29 out nocopy JTF_VARCHAR2_TABLE_2000
1880: , p4_a30 out nocopy JTF_VARCHAR2_TABLE_2000
1881: , p4_a31 out nocopy JTF_VARCHAR2_TABLE_2000
1882: , p4_a32 out nocopy JTF_NUMBER_TABLE

Line 1879: , p4_a29 out nocopy JTF_VARCHAR2_TABLE_2000

1875: , p4_a25 out nocopy JTF_NUMBER_TABLE
1876: , p4_a26 out nocopy JTF_NUMBER_TABLE
1877: , p4_a27 out nocopy JTF_NUMBER_TABLE
1878: , p4_a28 out nocopy JTF_VARCHAR2_TABLE_2000
1879: , p4_a29 out nocopy JTF_VARCHAR2_TABLE_2000
1880: , p4_a30 out nocopy JTF_VARCHAR2_TABLE_2000
1881: , p4_a31 out nocopy JTF_VARCHAR2_TABLE_2000
1882: , p4_a32 out nocopy JTF_NUMBER_TABLE
1883: , p4_a33 out nocopy JTF_VARCHAR2_TABLE_200

Line 1880: , p4_a30 out nocopy JTF_VARCHAR2_TABLE_2000

1876: , p4_a26 out nocopy JTF_NUMBER_TABLE
1877: , p4_a27 out nocopy JTF_NUMBER_TABLE
1878: , p4_a28 out nocopy JTF_VARCHAR2_TABLE_2000
1879: , p4_a29 out nocopy JTF_VARCHAR2_TABLE_2000
1880: , p4_a30 out nocopy JTF_VARCHAR2_TABLE_2000
1881: , p4_a31 out nocopy JTF_VARCHAR2_TABLE_2000
1882: , p4_a32 out nocopy JTF_NUMBER_TABLE
1883: , p4_a33 out nocopy JTF_VARCHAR2_TABLE_200
1884: , p4_a34 out nocopy JTF_NUMBER_TABLE

Line 1881: , p4_a31 out nocopy JTF_VARCHAR2_TABLE_2000

1877: , p4_a27 out nocopy JTF_NUMBER_TABLE
1878: , p4_a28 out nocopy JTF_VARCHAR2_TABLE_2000
1879: , p4_a29 out nocopy JTF_VARCHAR2_TABLE_2000
1880: , p4_a30 out nocopy JTF_VARCHAR2_TABLE_2000
1881: , p4_a31 out nocopy JTF_VARCHAR2_TABLE_2000
1882: , p4_a32 out nocopy JTF_NUMBER_TABLE
1883: , p4_a33 out nocopy JTF_VARCHAR2_TABLE_200
1884: , p4_a34 out nocopy JTF_NUMBER_TABLE
1885: , p4_a35 out nocopy JTF_NUMBER_TABLE

Line 1886: , p4_a36 out nocopy JTF_VARCHAR2_TABLE_2000

1882: , p4_a32 out nocopy JTF_NUMBER_TABLE
1883: , p4_a33 out nocopy JTF_VARCHAR2_TABLE_200
1884: , p4_a34 out nocopy JTF_NUMBER_TABLE
1885: , p4_a35 out nocopy JTF_NUMBER_TABLE
1886: , p4_a36 out nocopy JTF_VARCHAR2_TABLE_2000
1887: , p4_a37 out nocopy JTF_NUMBER_TABLE
1888: , p4_a38 out nocopy JTF_NUMBER_TABLE
1889: , p4_a39 out nocopy JTF_NUMBER_TABLE
1890: , p4_a40 out nocopy JTF_VARCHAR2_TABLE_2000

Line 1890: , p4_a40 out nocopy JTF_VARCHAR2_TABLE_2000

1886: , p4_a36 out nocopy JTF_VARCHAR2_TABLE_2000
1887: , p4_a37 out nocopy JTF_NUMBER_TABLE
1888: , p4_a38 out nocopy JTF_NUMBER_TABLE
1889: , p4_a39 out nocopy JTF_NUMBER_TABLE
1890: , p4_a40 out nocopy JTF_VARCHAR2_TABLE_2000
1891: , p4_a41 out nocopy JTF_NUMBER_TABLE
1892: , p4_a42 out nocopy JTF_VARCHAR2_TABLE_2000
1893: )
1894:

Line 1892: , p4_a42 out nocopy JTF_VARCHAR2_TABLE_2000

1888: , p4_a38 out nocopy JTF_NUMBER_TABLE
1889: , p4_a39 out nocopy JTF_NUMBER_TABLE
1890: , p4_a40 out nocopy JTF_VARCHAR2_TABLE_2000
1891: , p4_a41 out nocopy JTF_NUMBER_TABLE
1892: , p4_a42 out nocopy JTF_VARCHAR2_TABLE_2000
1893: )
1894:
1895: as
1896: ddp_loan_details lns_financials.loan_details_rec;

Line 2219: , p4_a28 out nocopy JTF_VARCHAR2_TABLE_2000

2215: , p4_a24 out nocopy JTF_NUMBER_TABLE
2216: , p4_a25 out nocopy JTF_NUMBER_TABLE
2217: , p4_a26 out nocopy JTF_NUMBER_TABLE
2218: , p4_a27 out nocopy JTF_NUMBER_TABLE
2219: , p4_a28 out nocopy JTF_VARCHAR2_TABLE_2000
2220: , p4_a29 out nocopy JTF_VARCHAR2_TABLE_2000
2221: , p4_a30 out nocopy JTF_VARCHAR2_TABLE_2000
2222: , p4_a31 out nocopy JTF_VARCHAR2_TABLE_2000
2223: , p4_a32 out nocopy JTF_NUMBER_TABLE

Line 2220: , p4_a29 out nocopy JTF_VARCHAR2_TABLE_2000

2216: , p4_a25 out nocopy JTF_NUMBER_TABLE
2217: , p4_a26 out nocopy JTF_NUMBER_TABLE
2218: , p4_a27 out nocopy JTF_NUMBER_TABLE
2219: , p4_a28 out nocopy JTF_VARCHAR2_TABLE_2000
2220: , p4_a29 out nocopy JTF_VARCHAR2_TABLE_2000
2221: , p4_a30 out nocopy JTF_VARCHAR2_TABLE_2000
2222: , p4_a31 out nocopy JTF_VARCHAR2_TABLE_2000
2223: , p4_a32 out nocopy JTF_NUMBER_TABLE
2224: , p4_a33 out nocopy JTF_VARCHAR2_TABLE_200

Line 2221: , p4_a30 out nocopy JTF_VARCHAR2_TABLE_2000

2217: , p4_a26 out nocopy JTF_NUMBER_TABLE
2218: , p4_a27 out nocopy JTF_NUMBER_TABLE
2219: , p4_a28 out nocopy JTF_VARCHAR2_TABLE_2000
2220: , p4_a29 out nocopy JTF_VARCHAR2_TABLE_2000
2221: , p4_a30 out nocopy JTF_VARCHAR2_TABLE_2000
2222: , p4_a31 out nocopy JTF_VARCHAR2_TABLE_2000
2223: , p4_a32 out nocopy JTF_NUMBER_TABLE
2224: , p4_a33 out nocopy JTF_VARCHAR2_TABLE_200
2225: , p4_a34 out nocopy JTF_NUMBER_TABLE

Line 2222: , p4_a31 out nocopy JTF_VARCHAR2_TABLE_2000

2218: , p4_a27 out nocopy JTF_NUMBER_TABLE
2219: , p4_a28 out nocopy JTF_VARCHAR2_TABLE_2000
2220: , p4_a29 out nocopy JTF_VARCHAR2_TABLE_2000
2221: , p4_a30 out nocopy JTF_VARCHAR2_TABLE_2000
2222: , p4_a31 out nocopy JTF_VARCHAR2_TABLE_2000
2223: , p4_a32 out nocopy JTF_NUMBER_TABLE
2224: , p4_a33 out nocopy JTF_VARCHAR2_TABLE_200
2225: , p4_a34 out nocopy JTF_NUMBER_TABLE
2226: , p4_a35 out nocopy JTF_NUMBER_TABLE

Line 2227: , p4_a36 out nocopy JTF_VARCHAR2_TABLE_2000

2223: , p4_a32 out nocopy JTF_NUMBER_TABLE
2224: , p4_a33 out nocopy JTF_VARCHAR2_TABLE_200
2225: , p4_a34 out nocopy JTF_NUMBER_TABLE
2226: , p4_a35 out nocopy JTF_NUMBER_TABLE
2227: , p4_a36 out nocopy JTF_VARCHAR2_TABLE_2000
2228: , p4_a37 out nocopy JTF_NUMBER_TABLE
2229: , p4_a38 out nocopy JTF_NUMBER_TABLE
2230: , p4_a39 out nocopy JTF_NUMBER_TABLE
2231: , p4_a40 out nocopy JTF_VARCHAR2_TABLE_2000

Line 2231: , p4_a40 out nocopy JTF_VARCHAR2_TABLE_2000

2227: , p4_a36 out nocopy JTF_VARCHAR2_TABLE_2000
2228: , p4_a37 out nocopy JTF_NUMBER_TABLE
2229: , p4_a38 out nocopy JTF_NUMBER_TABLE
2230: , p4_a39 out nocopy JTF_NUMBER_TABLE
2231: , p4_a40 out nocopy JTF_VARCHAR2_TABLE_2000
2232: , p4_a41 out nocopy JTF_NUMBER_TABLE
2233: , p4_a42 out nocopy JTF_VARCHAR2_TABLE_2000
2234: )
2235:

Line 2233: , p4_a42 out nocopy JTF_VARCHAR2_TABLE_2000

2229: , p4_a38 out nocopy JTF_NUMBER_TABLE
2230: , p4_a39 out nocopy JTF_NUMBER_TABLE
2231: , p4_a40 out nocopy JTF_VARCHAR2_TABLE_2000
2232: , p4_a41 out nocopy JTF_NUMBER_TABLE
2233: , p4_a42 out nocopy JTF_VARCHAR2_TABLE_2000
2234: )
2235:
2236: as
2237: ddp_loan_details lns_financials.loan_details_rec;

Line 2455: , p3_a28 out nocopy JTF_VARCHAR2_TABLE_2000

2451: , p3_a24 out nocopy JTF_NUMBER_TABLE
2452: , p3_a25 out nocopy JTF_NUMBER_TABLE
2453: , p3_a26 out nocopy JTF_NUMBER_TABLE
2454: , p3_a27 out nocopy JTF_NUMBER_TABLE
2455: , p3_a28 out nocopy JTF_VARCHAR2_TABLE_2000
2456: , p3_a29 out nocopy JTF_VARCHAR2_TABLE_2000
2457: , p3_a30 out nocopy JTF_VARCHAR2_TABLE_2000
2458: , p3_a31 out nocopy JTF_VARCHAR2_TABLE_2000
2459: , p3_a32 out nocopy JTF_NUMBER_TABLE

Line 2456: , p3_a29 out nocopy JTF_VARCHAR2_TABLE_2000

2452: , p3_a25 out nocopy JTF_NUMBER_TABLE
2453: , p3_a26 out nocopy JTF_NUMBER_TABLE
2454: , p3_a27 out nocopy JTF_NUMBER_TABLE
2455: , p3_a28 out nocopy JTF_VARCHAR2_TABLE_2000
2456: , p3_a29 out nocopy JTF_VARCHAR2_TABLE_2000
2457: , p3_a30 out nocopy JTF_VARCHAR2_TABLE_2000
2458: , p3_a31 out nocopy JTF_VARCHAR2_TABLE_2000
2459: , p3_a32 out nocopy JTF_NUMBER_TABLE
2460: , p3_a33 out nocopy JTF_VARCHAR2_TABLE_200

Line 2457: , p3_a30 out nocopy JTF_VARCHAR2_TABLE_2000

2453: , p3_a26 out nocopy JTF_NUMBER_TABLE
2454: , p3_a27 out nocopy JTF_NUMBER_TABLE
2455: , p3_a28 out nocopy JTF_VARCHAR2_TABLE_2000
2456: , p3_a29 out nocopy JTF_VARCHAR2_TABLE_2000
2457: , p3_a30 out nocopy JTF_VARCHAR2_TABLE_2000
2458: , p3_a31 out nocopy JTF_VARCHAR2_TABLE_2000
2459: , p3_a32 out nocopy JTF_NUMBER_TABLE
2460: , p3_a33 out nocopy JTF_VARCHAR2_TABLE_200
2461: , p3_a34 out nocopy JTF_NUMBER_TABLE

Line 2458: , p3_a31 out nocopy JTF_VARCHAR2_TABLE_2000

2454: , p3_a27 out nocopy JTF_NUMBER_TABLE
2455: , p3_a28 out nocopy JTF_VARCHAR2_TABLE_2000
2456: , p3_a29 out nocopy JTF_VARCHAR2_TABLE_2000
2457: , p3_a30 out nocopy JTF_VARCHAR2_TABLE_2000
2458: , p3_a31 out nocopy JTF_VARCHAR2_TABLE_2000
2459: , p3_a32 out nocopy JTF_NUMBER_TABLE
2460: , p3_a33 out nocopy JTF_VARCHAR2_TABLE_200
2461: , p3_a34 out nocopy JTF_NUMBER_TABLE
2462: , p3_a35 out nocopy JTF_NUMBER_TABLE

Line 2463: , p3_a36 out nocopy JTF_VARCHAR2_TABLE_2000

2459: , p3_a32 out nocopy JTF_NUMBER_TABLE
2460: , p3_a33 out nocopy JTF_VARCHAR2_TABLE_200
2461: , p3_a34 out nocopy JTF_NUMBER_TABLE
2462: , p3_a35 out nocopy JTF_NUMBER_TABLE
2463: , p3_a36 out nocopy JTF_VARCHAR2_TABLE_2000
2464: , p3_a37 out nocopy JTF_NUMBER_TABLE
2465: , p3_a38 out nocopy JTF_NUMBER_TABLE
2466: , p3_a39 out nocopy JTF_NUMBER_TABLE
2467: , p3_a40 out nocopy JTF_VARCHAR2_TABLE_2000

Line 2467: , p3_a40 out nocopy JTF_VARCHAR2_TABLE_2000

2463: , p3_a36 out nocopy JTF_VARCHAR2_TABLE_2000
2464: , p3_a37 out nocopy JTF_NUMBER_TABLE
2465: , p3_a38 out nocopy JTF_NUMBER_TABLE
2466: , p3_a39 out nocopy JTF_NUMBER_TABLE
2467: , p3_a40 out nocopy JTF_VARCHAR2_TABLE_2000
2468: , p3_a41 out nocopy JTF_NUMBER_TABLE
2469: , p3_a42 out nocopy JTF_VARCHAR2_TABLE_2000
2470: )
2471:

Line 2469: , p3_a42 out nocopy JTF_VARCHAR2_TABLE_2000

2465: , p3_a38 out nocopy JTF_NUMBER_TABLE
2466: , p3_a39 out nocopy JTF_NUMBER_TABLE
2467: , p3_a40 out nocopy JTF_VARCHAR2_TABLE_2000
2468: , p3_a41 out nocopy JTF_NUMBER_TABLE
2469: , p3_a42 out nocopy JTF_VARCHAR2_TABLE_2000
2470: )
2471:
2472: as
2473: ddx_loan_amort_tbl lns_financials.amortization_tbl;

Line 2673: , p3_a28 out nocopy JTF_VARCHAR2_TABLE_2000

2669: , p3_a24 out nocopy JTF_NUMBER_TABLE
2670: , p3_a25 out nocopy JTF_NUMBER_TABLE
2671: , p3_a26 out nocopy JTF_NUMBER_TABLE
2672: , p3_a27 out nocopy JTF_NUMBER_TABLE
2673: , p3_a28 out nocopy JTF_VARCHAR2_TABLE_2000
2674: , p3_a29 out nocopy JTF_VARCHAR2_TABLE_2000
2675: , p3_a30 out nocopy JTF_VARCHAR2_TABLE_2000
2676: , p3_a31 out nocopy JTF_VARCHAR2_TABLE_2000
2677: , p3_a32 out nocopy JTF_NUMBER_TABLE

Line 2674: , p3_a29 out nocopy JTF_VARCHAR2_TABLE_2000

2670: , p3_a25 out nocopy JTF_NUMBER_TABLE
2671: , p3_a26 out nocopy JTF_NUMBER_TABLE
2672: , p3_a27 out nocopy JTF_NUMBER_TABLE
2673: , p3_a28 out nocopy JTF_VARCHAR2_TABLE_2000
2674: , p3_a29 out nocopy JTF_VARCHAR2_TABLE_2000
2675: , p3_a30 out nocopy JTF_VARCHAR2_TABLE_2000
2676: , p3_a31 out nocopy JTF_VARCHAR2_TABLE_2000
2677: , p3_a32 out nocopy JTF_NUMBER_TABLE
2678: , p3_a33 out nocopy JTF_VARCHAR2_TABLE_200

Line 2675: , p3_a30 out nocopy JTF_VARCHAR2_TABLE_2000

2671: , p3_a26 out nocopy JTF_NUMBER_TABLE
2672: , p3_a27 out nocopy JTF_NUMBER_TABLE
2673: , p3_a28 out nocopy JTF_VARCHAR2_TABLE_2000
2674: , p3_a29 out nocopy JTF_VARCHAR2_TABLE_2000
2675: , p3_a30 out nocopy JTF_VARCHAR2_TABLE_2000
2676: , p3_a31 out nocopy JTF_VARCHAR2_TABLE_2000
2677: , p3_a32 out nocopy JTF_NUMBER_TABLE
2678: , p3_a33 out nocopy JTF_VARCHAR2_TABLE_200
2679: , p3_a34 out nocopy JTF_NUMBER_TABLE

Line 2676: , p3_a31 out nocopy JTF_VARCHAR2_TABLE_2000

2672: , p3_a27 out nocopy JTF_NUMBER_TABLE
2673: , p3_a28 out nocopy JTF_VARCHAR2_TABLE_2000
2674: , p3_a29 out nocopy JTF_VARCHAR2_TABLE_2000
2675: , p3_a30 out nocopy JTF_VARCHAR2_TABLE_2000
2676: , p3_a31 out nocopy JTF_VARCHAR2_TABLE_2000
2677: , p3_a32 out nocopy JTF_NUMBER_TABLE
2678: , p3_a33 out nocopy JTF_VARCHAR2_TABLE_200
2679: , p3_a34 out nocopy JTF_NUMBER_TABLE
2680: , p3_a35 out nocopy JTF_NUMBER_TABLE

Line 2681: , p3_a36 out nocopy JTF_VARCHAR2_TABLE_2000

2677: , p3_a32 out nocopy JTF_NUMBER_TABLE
2678: , p3_a33 out nocopy JTF_VARCHAR2_TABLE_200
2679: , p3_a34 out nocopy JTF_NUMBER_TABLE
2680: , p3_a35 out nocopy JTF_NUMBER_TABLE
2681: , p3_a36 out nocopy JTF_VARCHAR2_TABLE_2000
2682: , p3_a37 out nocopy JTF_NUMBER_TABLE
2683: , p3_a38 out nocopy JTF_NUMBER_TABLE
2684: , p3_a39 out nocopy JTF_NUMBER_TABLE
2685: , p3_a40 out nocopy JTF_VARCHAR2_TABLE_2000

Line 2685: , p3_a40 out nocopy JTF_VARCHAR2_TABLE_2000

2681: , p3_a36 out nocopy JTF_VARCHAR2_TABLE_2000
2682: , p3_a37 out nocopy JTF_NUMBER_TABLE
2683: , p3_a38 out nocopy JTF_NUMBER_TABLE
2684: , p3_a39 out nocopy JTF_NUMBER_TABLE
2685: , p3_a40 out nocopy JTF_VARCHAR2_TABLE_2000
2686: , p3_a41 out nocopy JTF_NUMBER_TABLE
2687: , p3_a42 out nocopy JTF_VARCHAR2_TABLE_2000
2688: )
2689:

Line 2687: , p3_a42 out nocopy JTF_VARCHAR2_TABLE_2000

2683: , p3_a38 out nocopy JTF_NUMBER_TABLE
2684: , p3_a39 out nocopy JTF_NUMBER_TABLE
2685: , p3_a40 out nocopy JTF_VARCHAR2_TABLE_2000
2686: , p3_a41 out nocopy JTF_NUMBER_TABLE
2687: , p3_a42 out nocopy JTF_VARCHAR2_TABLE_2000
2688: )
2689:
2690: as
2691: ddp_loan_details lns_financials.loan_details_rec;

Line 2906: , p3_a28 out nocopy JTF_VARCHAR2_TABLE_2000

2902: , p3_a24 out nocopy JTF_NUMBER_TABLE
2903: , p3_a25 out nocopy JTF_NUMBER_TABLE
2904: , p3_a26 out nocopy JTF_NUMBER_TABLE
2905: , p3_a27 out nocopy JTF_NUMBER_TABLE
2906: , p3_a28 out nocopy JTF_VARCHAR2_TABLE_2000
2907: , p3_a29 out nocopy JTF_VARCHAR2_TABLE_2000
2908: , p3_a30 out nocopy JTF_VARCHAR2_TABLE_2000
2909: , p3_a31 out nocopy JTF_VARCHAR2_TABLE_2000
2910: , p3_a32 out nocopy JTF_NUMBER_TABLE

Line 2907: , p3_a29 out nocopy JTF_VARCHAR2_TABLE_2000

2903: , p3_a25 out nocopy JTF_NUMBER_TABLE
2904: , p3_a26 out nocopy JTF_NUMBER_TABLE
2905: , p3_a27 out nocopy JTF_NUMBER_TABLE
2906: , p3_a28 out nocopy JTF_VARCHAR2_TABLE_2000
2907: , p3_a29 out nocopy JTF_VARCHAR2_TABLE_2000
2908: , p3_a30 out nocopy JTF_VARCHAR2_TABLE_2000
2909: , p3_a31 out nocopy JTF_VARCHAR2_TABLE_2000
2910: , p3_a32 out nocopy JTF_NUMBER_TABLE
2911: , p3_a33 out nocopy JTF_VARCHAR2_TABLE_200

Line 2908: , p3_a30 out nocopy JTF_VARCHAR2_TABLE_2000

2904: , p3_a26 out nocopy JTF_NUMBER_TABLE
2905: , p3_a27 out nocopy JTF_NUMBER_TABLE
2906: , p3_a28 out nocopy JTF_VARCHAR2_TABLE_2000
2907: , p3_a29 out nocopy JTF_VARCHAR2_TABLE_2000
2908: , p3_a30 out nocopy JTF_VARCHAR2_TABLE_2000
2909: , p3_a31 out nocopy JTF_VARCHAR2_TABLE_2000
2910: , p3_a32 out nocopy JTF_NUMBER_TABLE
2911: , p3_a33 out nocopy JTF_VARCHAR2_TABLE_200
2912: , p3_a34 out nocopy JTF_NUMBER_TABLE

Line 2909: , p3_a31 out nocopy JTF_VARCHAR2_TABLE_2000

2905: , p3_a27 out nocopy JTF_NUMBER_TABLE
2906: , p3_a28 out nocopy JTF_VARCHAR2_TABLE_2000
2907: , p3_a29 out nocopy JTF_VARCHAR2_TABLE_2000
2908: , p3_a30 out nocopy JTF_VARCHAR2_TABLE_2000
2909: , p3_a31 out nocopy JTF_VARCHAR2_TABLE_2000
2910: , p3_a32 out nocopy JTF_NUMBER_TABLE
2911: , p3_a33 out nocopy JTF_VARCHAR2_TABLE_200
2912: , p3_a34 out nocopy JTF_NUMBER_TABLE
2913: , p3_a35 out nocopy JTF_NUMBER_TABLE

Line 2914: , p3_a36 out nocopy JTF_VARCHAR2_TABLE_2000

2910: , p3_a32 out nocopy JTF_NUMBER_TABLE
2911: , p3_a33 out nocopy JTF_VARCHAR2_TABLE_200
2912: , p3_a34 out nocopy JTF_NUMBER_TABLE
2913: , p3_a35 out nocopy JTF_NUMBER_TABLE
2914: , p3_a36 out nocopy JTF_VARCHAR2_TABLE_2000
2915: , p3_a37 out nocopy JTF_NUMBER_TABLE
2916: , p3_a38 out nocopy JTF_NUMBER_TABLE
2917: , p3_a39 out nocopy JTF_NUMBER_TABLE
2918: , p3_a40 out nocopy JTF_VARCHAR2_TABLE_2000

Line 2918: , p3_a40 out nocopy JTF_VARCHAR2_TABLE_2000

2914: , p3_a36 out nocopy JTF_VARCHAR2_TABLE_2000
2915: , p3_a37 out nocopy JTF_NUMBER_TABLE
2916: , p3_a38 out nocopy JTF_NUMBER_TABLE
2917: , p3_a39 out nocopy JTF_NUMBER_TABLE
2918: , p3_a40 out nocopy JTF_VARCHAR2_TABLE_2000
2919: , p3_a41 out nocopy JTF_NUMBER_TABLE
2920: , p3_a42 out nocopy JTF_VARCHAR2_TABLE_2000
2921: , x_return_status out nocopy VARCHAR2
2922: , x_msg_count out nocopy NUMBER

Line 2920: , p3_a42 out nocopy JTF_VARCHAR2_TABLE_2000

2916: , p3_a38 out nocopy JTF_NUMBER_TABLE
2917: , p3_a39 out nocopy JTF_NUMBER_TABLE
2918: , p3_a40 out nocopy JTF_VARCHAR2_TABLE_2000
2919: , p3_a41 out nocopy JTF_NUMBER_TABLE
2920: , p3_a42 out nocopy JTF_VARCHAR2_TABLE_2000
2921: , x_return_status out nocopy VARCHAR2
2922: , x_msg_count out nocopy NUMBER
2923: , x_msg_data out nocopy VARCHAR2
2924: )

Line 3034: , p5_a28 out nocopy JTF_VARCHAR2_TABLE_2000

3030: , p5_a24 out nocopy JTF_NUMBER_TABLE
3031: , p5_a25 out nocopy JTF_NUMBER_TABLE
3032: , p5_a26 out nocopy JTF_NUMBER_TABLE
3033: , p5_a27 out nocopy JTF_NUMBER_TABLE
3034: , p5_a28 out nocopy JTF_VARCHAR2_TABLE_2000
3035: , p5_a29 out nocopy JTF_VARCHAR2_TABLE_2000
3036: , p5_a30 out nocopy JTF_VARCHAR2_TABLE_2000
3037: , p5_a31 out nocopy JTF_VARCHAR2_TABLE_2000
3038: , p5_a32 out nocopy JTF_NUMBER_TABLE

Line 3035: , p5_a29 out nocopy JTF_VARCHAR2_TABLE_2000

3031: , p5_a25 out nocopy JTF_NUMBER_TABLE
3032: , p5_a26 out nocopy JTF_NUMBER_TABLE
3033: , p5_a27 out nocopy JTF_NUMBER_TABLE
3034: , p5_a28 out nocopy JTF_VARCHAR2_TABLE_2000
3035: , p5_a29 out nocopy JTF_VARCHAR2_TABLE_2000
3036: , p5_a30 out nocopy JTF_VARCHAR2_TABLE_2000
3037: , p5_a31 out nocopy JTF_VARCHAR2_TABLE_2000
3038: , p5_a32 out nocopy JTF_NUMBER_TABLE
3039: , p5_a33 out nocopy JTF_VARCHAR2_TABLE_200

Line 3036: , p5_a30 out nocopy JTF_VARCHAR2_TABLE_2000

3032: , p5_a26 out nocopy JTF_NUMBER_TABLE
3033: , p5_a27 out nocopy JTF_NUMBER_TABLE
3034: , p5_a28 out nocopy JTF_VARCHAR2_TABLE_2000
3035: , p5_a29 out nocopy JTF_VARCHAR2_TABLE_2000
3036: , p5_a30 out nocopy JTF_VARCHAR2_TABLE_2000
3037: , p5_a31 out nocopy JTF_VARCHAR2_TABLE_2000
3038: , p5_a32 out nocopy JTF_NUMBER_TABLE
3039: , p5_a33 out nocopy JTF_VARCHAR2_TABLE_200
3040: , p5_a34 out nocopy JTF_NUMBER_TABLE

Line 3037: , p5_a31 out nocopy JTF_VARCHAR2_TABLE_2000

3033: , p5_a27 out nocopy JTF_NUMBER_TABLE
3034: , p5_a28 out nocopy JTF_VARCHAR2_TABLE_2000
3035: , p5_a29 out nocopy JTF_VARCHAR2_TABLE_2000
3036: , p5_a30 out nocopy JTF_VARCHAR2_TABLE_2000
3037: , p5_a31 out nocopy JTF_VARCHAR2_TABLE_2000
3038: , p5_a32 out nocopy JTF_NUMBER_TABLE
3039: , p5_a33 out nocopy JTF_VARCHAR2_TABLE_200
3040: , p5_a34 out nocopy JTF_NUMBER_TABLE
3041: , p5_a35 out nocopy JTF_NUMBER_TABLE

Line 3042: , p5_a36 out nocopy JTF_VARCHAR2_TABLE_2000

3038: , p5_a32 out nocopy JTF_NUMBER_TABLE
3039: , p5_a33 out nocopy JTF_VARCHAR2_TABLE_200
3040: , p5_a34 out nocopy JTF_NUMBER_TABLE
3041: , p5_a35 out nocopy JTF_NUMBER_TABLE
3042: , p5_a36 out nocopy JTF_VARCHAR2_TABLE_2000
3043: , p5_a37 out nocopy JTF_NUMBER_TABLE
3044: , p5_a38 out nocopy JTF_NUMBER_TABLE
3045: , p5_a39 out nocopy JTF_NUMBER_TABLE
3046: , p5_a40 out nocopy JTF_VARCHAR2_TABLE_2000

Line 3046: , p5_a40 out nocopy JTF_VARCHAR2_TABLE_2000

3042: , p5_a36 out nocopy JTF_VARCHAR2_TABLE_2000
3043: , p5_a37 out nocopy JTF_NUMBER_TABLE
3044: , p5_a38 out nocopy JTF_NUMBER_TABLE
3045: , p5_a39 out nocopy JTF_NUMBER_TABLE
3046: , p5_a40 out nocopy JTF_VARCHAR2_TABLE_2000
3047: , p5_a41 out nocopy JTF_NUMBER_TABLE
3048: , p5_a42 out nocopy JTF_VARCHAR2_TABLE_2000
3049: , x_return_status out nocopy VARCHAR2
3050: , x_msg_count out nocopy NUMBER

Line 3048: , p5_a42 out nocopy JTF_VARCHAR2_TABLE_2000

3044: , p5_a38 out nocopy JTF_NUMBER_TABLE
3045: , p5_a39 out nocopy JTF_NUMBER_TABLE
3046: , p5_a40 out nocopy JTF_VARCHAR2_TABLE_2000
3047: , p5_a41 out nocopy JTF_NUMBER_TABLE
3048: , p5_a42 out nocopy JTF_VARCHAR2_TABLE_2000
3049: , x_return_status out nocopy VARCHAR2
3050: , x_msg_count out nocopy NUMBER
3051: , x_msg_data out nocopy VARCHAR2
3052: )