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