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
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 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
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: ) as
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
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: ) as
15: ddindx binary_integer; indx binary_integer;
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
51: , a9 out nocopy JTF_VARCHAR2_TABLE_100
52: , a10 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
51: , a9 out nocopy JTF_VARCHAR2_TABLE_100
52: , a10 out nocopy JTF_VARCHAR2_TABLE_100
53: ) as
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
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;
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();
66: a9 := JTF_VARCHAR2_TABLE_100();
67: a10 := 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();
66: a9 := JTF_VARCHAR2_TABLE_100();
67: a10 := JTF_VARCHAR2_TABLE_100();
68: else
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();
66: a9 := JTF_VARCHAR2_TABLE_100();
67: a10 := JTF_VARCHAR2_TABLE_100();
68: else
69: a0 := 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();
78: a9 := JTF_VARCHAR2_TABLE_100();
79: a10 := 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();
78: a9 := JTF_VARCHAR2_TABLE_100();
79: a10 := JTF_VARCHAR2_TABLE_100();
80: if t.count > 0 then
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();
78: a9 := JTF_VARCHAR2_TABLE_100();
79: a10 := JTF_VARCHAR2_TABLE_100();
80: if t.count > 0 then
81: a0.extend(t.count);
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
123: , a7 JTF_VARCHAR2_TABLE_100
124: ) as
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
156: , a7 out nocopy JTF_VARCHAR2_TABLE_100
157: ) as
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();
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();
177: a7 := JTF_VARCHAR2_TABLE_100();
178: if t.count > 0 then
206: end rosetta_table_copy_out_p3;
207:
208: procedure rosetta_table_copy_in_p5(t out nocopy lns_payoff_pub.loan_cancel_details_tbl, a0 JTF_NUMBER_TABLE
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
207:
208: procedure rosetta_table_copy_in_p5(t out nocopy lns_payoff_pub.loan_cancel_details_tbl, a0 JTF_NUMBER_TABLE
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
208: procedure rosetta_table_copy_in_p5(t out nocopy lns_payoff_pub.loan_cancel_details_tbl, a0 JTF_NUMBER_TABLE
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
257: end if;
258: end rosetta_table_copy_in_p5;
259: procedure rosetta_table_copy_out_p5(t lns_payoff_pub.loan_cancel_details_tbl, a0 out nocopy JTF_NUMBER_TABLE
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
258: end rosetta_table_copy_in_p5;
259: procedure rosetta_table_copy_out_p5(t lns_payoff_pub.loan_cancel_details_tbl, a0 out nocopy JTF_NUMBER_TABLE
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
259: procedure rosetta_table_copy_out_p5(t lns_payoff_pub.loan_cancel_details_tbl, a0 out nocopy JTF_NUMBER_TABLE
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
278: begin
279: if t is null or t.count = 0 then
280: a0 := JTF_NUMBER_TABLE();
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();
279: if t is null or t.count = 0 then
280: a0 := JTF_NUMBER_TABLE();
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();
280: a0 := JTF_NUMBER_TABLE();
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();
296: a16 := JTF_NUMBER_TABLE();
297: else
298: a0 := JTF_NUMBER_TABLE();
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();
297: else
298: a0 := JTF_NUMBER_TABLE();
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();
298: a0 := JTF_NUMBER_TABLE();
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();
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
374: , p4_a7 JTF_VARCHAR2_TABLE_100
375: , x_return_status out nocopy VARCHAR2
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
436: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
437: , p4_a10 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
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
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
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
491: , p_loan_id NUMBER
492: , p_cancellation_date DATE
493: , p4_a0 out nocopy JTF_NUMBER_TABLE
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
492: , p_cancellation_date DATE
493: , p4_a0 out nocopy JTF_NUMBER_TABLE
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
493: , p4_a0 out nocopy JTF_NUMBER_TABLE
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
575: , p_action VARCHAR2
576: , p_loan_cancellation_id in out nocopy NUMBER
577: , p10_a0 in out nocopy JTF_NUMBER_TABLE
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
576: , p_loan_cancellation_id in out nocopy NUMBER
577: , p10_a0 in out nocopy JTF_NUMBER_TABLE
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
577: , p10_a0 in out nocopy JTF_NUMBER_TABLE
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