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