6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: );
14: procedure rosetta_table_copy_out_p1(t lns_financials.rate_schedule_tbl, a0 out nocopy JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: );
14: procedure rosetta_table_copy_out_p1(t lns_financials.rate_schedule_tbl, a0 out nocopy JTF_NUMBER_TABLE
15: , a1 out nocopy JTF_DATE_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: );
14: procedure rosetta_table_copy_out_p1(t lns_financials.rate_schedule_tbl, a0 out nocopy JTF_NUMBER_TABLE
15: , a1 out nocopy JTF_DATE_TABLE
16: , a2 out nocopy JTF_DATE_TABLE
17: , a3 out nocopy JTF_NUMBER_TABLE
18: , a4 out nocopy JTF_NUMBER_TABLE
19: , a5 out nocopy JTF_NUMBER_TABLE
20: , a6 out nocopy JTF_NUMBER_TABLE
21: , a7 out nocopy JTF_VARCHAR2_TABLE_100
22: , a8 out nocopy JTF_VARCHAR2_TABLE_100
23: , a9 out nocopy JTF_VARCHAR2_TABLE_100
24: );
25:
18: , a4 out nocopy JTF_NUMBER_TABLE
19: , a5 out nocopy JTF_NUMBER_TABLE
20: , a6 out nocopy JTF_NUMBER_TABLE
21: , a7 out nocopy JTF_VARCHAR2_TABLE_100
22: , a8 out nocopy JTF_VARCHAR2_TABLE_100
23: , a9 out nocopy JTF_VARCHAR2_TABLE_100
24: );
25:
26: procedure rosetta_table_copy_in_p3(t out nocopy lns_financials.amortization_tbl, a0 JTF_NUMBER_TABLE
19: , a5 out nocopy JTF_NUMBER_TABLE
20: , a6 out nocopy JTF_NUMBER_TABLE
21: , a7 out nocopy JTF_VARCHAR2_TABLE_100
22: , a8 out nocopy JTF_VARCHAR2_TABLE_100
23: , a9 out nocopy JTF_VARCHAR2_TABLE_100
24: );
25:
26: procedure rosetta_table_copy_in_p3(t out nocopy lns_financials.amortization_tbl, a0 JTF_NUMBER_TABLE
27: , a1 JTF_DATE_TABLE
43: , a17 JTF_NUMBER_TABLE
44: , a18 JTF_NUMBER_TABLE
45: , a19 JTF_NUMBER_TABLE
46: , a20 JTF_NUMBER_TABLE
47: , a21 JTF_VARCHAR2_TABLE_100
48: , a22 JTF_VARCHAR2_TABLE_100
49: , a23 JTF_VARCHAR2_TABLE_100
50: , a24 JTF_NUMBER_TABLE
51: , a25 JTF_NUMBER_TABLE
44: , a18 JTF_NUMBER_TABLE
45: , a19 JTF_NUMBER_TABLE
46: , a20 JTF_NUMBER_TABLE
47: , a21 JTF_VARCHAR2_TABLE_100
48: , a22 JTF_VARCHAR2_TABLE_100
49: , a23 JTF_VARCHAR2_TABLE_100
50: , a24 JTF_NUMBER_TABLE
51: , a25 JTF_NUMBER_TABLE
52: , a26 JTF_NUMBER_TABLE
45: , a19 JTF_NUMBER_TABLE
46: , a20 JTF_NUMBER_TABLE
47: , a21 JTF_VARCHAR2_TABLE_100
48: , a22 JTF_VARCHAR2_TABLE_100
49: , a23 JTF_VARCHAR2_TABLE_100
50: , a24 JTF_NUMBER_TABLE
51: , a25 JTF_NUMBER_TABLE
52: , a26 JTF_NUMBER_TABLE
53: , a27 JTF_NUMBER_TABLE
87: , a17 out nocopy JTF_NUMBER_TABLE
88: , a18 out nocopy JTF_NUMBER_TABLE
89: , a19 out nocopy JTF_NUMBER_TABLE
90: , a20 out nocopy JTF_NUMBER_TABLE
91: , a21 out nocopy JTF_VARCHAR2_TABLE_100
92: , a22 out nocopy JTF_VARCHAR2_TABLE_100
93: , a23 out nocopy JTF_VARCHAR2_TABLE_100
94: , a24 out nocopy JTF_NUMBER_TABLE
95: , a25 out nocopy JTF_NUMBER_TABLE
88: , a18 out nocopy JTF_NUMBER_TABLE
89: , a19 out nocopy JTF_NUMBER_TABLE
90: , a20 out nocopy JTF_NUMBER_TABLE
91: , a21 out nocopy JTF_VARCHAR2_TABLE_100
92: , a22 out nocopy JTF_VARCHAR2_TABLE_100
93: , a23 out nocopy JTF_VARCHAR2_TABLE_100
94: , a24 out nocopy JTF_NUMBER_TABLE
95: , a25 out nocopy JTF_NUMBER_TABLE
96: , a26 out nocopy JTF_NUMBER_TABLE
89: , a19 out nocopy JTF_NUMBER_TABLE
90: , a20 out nocopy JTF_NUMBER_TABLE
91: , a21 out nocopy JTF_VARCHAR2_TABLE_100
92: , a22 out nocopy JTF_VARCHAR2_TABLE_100
93: , a23 out nocopy JTF_VARCHAR2_TABLE_100
94: , a24 out nocopy JTF_NUMBER_TABLE
95: , a25 out nocopy JTF_NUMBER_TABLE
96: , a26 out nocopy JTF_NUMBER_TABLE
97: , a27 out nocopy JTF_NUMBER_TABLE
134: , a8 out nocopy JTF_NUMBER_TABLE
135: , a9 out nocopy JTF_DATE_TABLE
136: );
137:
138: procedure rosetta_table_copy_in_p8(t out nocopy lns_financials.payoff_tbl2, a0 JTF_VARCHAR2_TABLE_100
139: , a1 JTF_NUMBER_TABLE
140: , a2 JTF_NUMBER_TABLE
141: , a3 JTF_NUMBER_TABLE
142: );
139: , a1 JTF_NUMBER_TABLE
140: , a2 JTF_NUMBER_TABLE
141: , a3 JTF_NUMBER_TABLE
142: );
143: procedure rosetta_table_copy_out_p8(t lns_financials.payoff_tbl2, a0 out nocopy JTF_VARCHAR2_TABLE_100
144: , a1 out nocopy JTF_NUMBER_TABLE
145: , a2 out nocopy JTF_NUMBER_TABLE
146: , a3 out nocopy JTF_NUMBER_TABLE
147: );
169:
170: procedure rosetta_table_copy_in_p14(t out nocopy lns_financials.amount_tbl, a0 JTF_NUMBER_TABLE);
171: procedure rosetta_table_copy_out_p14(t lns_financials.amount_tbl, a0 out nocopy JTF_NUMBER_TABLE);
172:
173: procedure rosetta_table_copy_in_p15(t out nocopy lns_financials.vchar_tbl, a0 JTF_VARCHAR2_TABLE_100);
174: procedure rosetta_table_copy_out_p15(t lns_financials.vchar_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100);
175:
176: procedure rosetta_table_copy_in_p17(t out nocopy lns_financials.fees_tbl, a0 JTF_NUMBER_TABLE
177: , a1 JTF_VARCHAR2_TABLE_100
170: procedure rosetta_table_copy_in_p14(t out nocopy lns_financials.amount_tbl, a0 JTF_NUMBER_TABLE);
171: procedure rosetta_table_copy_out_p14(t lns_financials.amount_tbl, a0 out nocopy JTF_NUMBER_TABLE);
172:
173: procedure rosetta_table_copy_in_p15(t out nocopy lns_financials.vchar_tbl, a0 JTF_VARCHAR2_TABLE_100);
174: procedure rosetta_table_copy_out_p15(t lns_financials.vchar_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100);
175:
176: procedure rosetta_table_copy_in_p17(t out nocopy lns_financials.fees_tbl, a0 JTF_NUMBER_TABLE
177: , a1 JTF_VARCHAR2_TABLE_100
178: , a2 JTF_NUMBER_TABLE
173: procedure rosetta_table_copy_in_p15(t out nocopy lns_financials.vchar_tbl, a0 JTF_VARCHAR2_TABLE_100);
174: procedure rosetta_table_copy_out_p15(t lns_financials.vchar_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100);
175:
176: procedure rosetta_table_copy_in_p17(t out nocopy lns_financials.fees_tbl, a0 JTF_NUMBER_TABLE
177: , a1 JTF_VARCHAR2_TABLE_100
178: , a2 JTF_NUMBER_TABLE
179: , a3 JTF_NUMBER_TABLE
180: , a4 JTF_VARCHAR2_TABLE_300
181: , a5 JTF_NUMBER_TABLE
178: , a2 JTF_NUMBER_TABLE
179: , a3 JTF_NUMBER_TABLE
180: , a4 JTF_VARCHAR2_TABLE_300
181: , a5 JTF_NUMBER_TABLE
182: , a6 JTF_VARCHAR2_TABLE_100
183: , a7 JTF_NUMBER_TABLE
184: , a8 JTF_VARCHAR2_TABLE_100
185: , a9 JTF_VARCHAR2_TABLE_100
186: );
180: , a4 JTF_VARCHAR2_TABLE_300
181: , a5 JTF_NUMBER_TABLE
182: , a6 JTF_VARCHAR2_TABLE_100
183: , a7 JTF_NUMBER_TABLE
184: , a8 JTF_VARCHAR2_TABLE_100
185: , a9 JTF_VARCHAR2_TABLE_100
186: );
187: procedure rosetta_table_copy_out_p17(t lns_financials.fees_tbl, a0 out nocopy JTF_NUMBER_TABLE
188: , a1 out nocopy JTF_VARCHAR2_TABLE_100
181: , a5 JTF_NUMBER_TABLE
182: , a6 JTF_VARCHAR2_TABLE_100
183: , a7 JTF_NUMBER_TABLE
184: , a8 JTF_VARCHAR2_TABLE_100
185: , a9 JTF_VARCHAR2_TABLE_100
186: );
187: procedure rosetta_table_copy_out_p17(t lns_financials.fees_tbl, a0 out nocopy JTF_NUMBER_TABLE
188: , a1 out nocopy JTF_VARCHAR2_TABLE_100
189: , a2 out nocopy JTF_NUMBER_TABLE
184: , a8 JTF_VARCHAR2_TABLE_100
185: , a9 JTF_VARCHAR2_TABLE_100
186: );
187: procedure rosetta_table_copy_out_p17(t lns_financials.fees_tbl, a0 out nocopy JTF_NUMBER_TABLE
188: , a1 out nocopy JTF_VARCHAR2_TABLE_100
189: , a2 out nocopy JTF_NUMBER_TABLE
190: , a3 out nocopy JTF_NUMBER_TABLE
191: , a4 out nocopy JTF_VARCHAR2_TABLE_300
192: , a5 out nocopy JTF_NUMBER_TABLE
189: , a2 out nocopy JTF_NUMBER_TABLE
190: , a3 out nocopy JTF_NUMBER_TABLE
191: , a4 out nocopy JTF_VARCHAR2_TABLE_300
192: , a5 out nocopy JTF_NUMBER_TABLE
193: , a6 out nocopy JTF_VARCHAR2_TABLE_100
194: , a7 out nocopy JTF_NUMBER_TABLE
195: , a8 out nocopy JTF_VARCHAR2_TABLE_100
196: , a9 out nocopy JTF_VARCHAR2_TABLE_100
197: );
191: , a4 out nocopy JTF_VARCHAR2_TABLE_300
192: , a5 out nocopy JTF_NUMBER_TABLE
193: , a6 out nocopy JTF_VARCHAR2_TABLE_100
194: , a7 out nocopy JTF_NUMBER_TABLE
195: , a8 out nocopy JTF_VARCHAR2_TABLE_100
196: , a9 out nocopy JTF_VARCHAR2_TABLE_100
197: );
198:
199: procedure shiftloandates(p_loan_id NUMBER
192: , a5 out nocopy JTF_NUMBER_TABLE
193: , a6 out nocopy JTF_VARCHAR2_TABLE_100
194: , a7 out nocopy JTF_NUMBER_TABLE
195: , a8 out nocopy JTF_VARCHAR2_TABLE_100
196: , a9 out nocopy JTF_VARCHAR2_TABLE_100
197: );
198:
199: procedure shiftloandates(p_loan_id NUMBER
200: , p_new_start_date DATE
404: procedure calculatepayoff(p_api_version NUMBER
405: , p_init_msg_list VARCHAR2
406: , p_loan_id NUMBER
407: , p_payoff_date DATE
408: , p4_a0 out nocopy JTF_VARCHAR2_TABLE_100
409: , p4_a1 out nocopy JTF_NUMBER_TABLE
410: , p4_a2 out nocopy JTF_NUMBER_TABLE
411: , p4_a3 out nocopy JTF_NUMBER_TABLE
412: , x_return_status out nocopy VARCHAR2
517: , p3_a3 JTF_NUMBER_TABLE
518: , p3_a4 JTF_NUMBER_TABLE
519: , p3_a5 JTF_NUMBER_TABLE
520: , p3_a6 JTF_NUMBER_TABLE
521: , p3_a7 JTF_VARCHAR2_TABLE_100
522: , p3_a8 JTF_VARCHAR2_TABLE_100
523: , p3_a9 JTF_VARCHAR2_TABLE_100
524: ) return number;
525: procedure amortizeeploan(p0_a0 NUMBER
518: , p3_a4 JTF_NUMBER_TABLE
519: , p3_a5 JTF_NUMBER_TABLE
520: , p3_a6 JTF_NUMBER_TABLE
521: , p3_a7 JTF_VARCHAR2_TABLE_100
522: , p3_a8 JTF_VARCHAR2_TABLE_100
523: , p3_a9 JTF_VARCHAR2_TABLE_100
524: ) return number;
525: procedure amortizeeploan(p0_a0 NUMBER
526: , p0_a1 NUMBER
519: , p3_a5 JTF_NUMBER_TABLE
520: , p3_a6 JTF_NUMBER_TABLE
521: , p3_a7 JTF_VARCHAR2_TABLE_100
522: , p3_a8 JTF_VARCHAR2_TABLE_100
523: , p3_a9 JTF_VARCHAR2_TABLE_100
524: ) return number;
525: procedure amortizeeploan(p0_a0 NUMBER
526: , p0_a1 NUMBER
527: , p0_a2 VARCHAR2
624: , p1_a3 JTF_NUMBER_TABLE
625: , p1_a4 JTF_NUMBER_TABLE
626: , p1_a5 JTF_NUMBER_TABLE
627: , p1_a6 JTF_NUMBER_TABLE
628: , p1_a7 JTF_VARCHAR2_TABLE_100
629: , p1_a8 JTF_VARCHAR2_TABLE_100
630: , p1_a9 JTF_VARCHAR2_TABLE_100
631: , p_based_on_terms VARCHAR2
632: , p_installment_number NUMBER
625: , p1_a4 JTF_NUMBER_TABLE
626: , p1_a5 JTF_NUMBER_TABLE
627: , p1_a6 JTF_NUMBER_TABLE
628: , p1_a7 JTF_VARCHAR2_TABLE_100
629: , p1_a8 JTF_VARCHAR2_TABLE_100
630: , p1_a9 JTF_VARCHAR2_TABLE_100
631: , p_based_on_terms VARCHAR2
632: , p_installment_number NUMBER
633: , p4_a0 out nocopy JTF_NUMBER_TABLE
626: , p1_a5 JTF_NUMBER_TABLE
627: , p1_a6 JTF_NUMBER_TABLE
628: , p1_a7 JTF_VARCHAR2_TABLE_100
629: , p1_a8 JTF_VARCHAR2_TABLE_100
630: , p1_a9 JTF_VARCHAR2_TABLE_100
631: , p_based_on_terms VARCHAR2
632: , p_installment_number NUMBER
633: , p4_a0 out nocopy JTF_NUMBER_TABLE
634: , p4_a1 out nocopy JTF_DATE_TABLE
650: , p4_a17 out nocopy JTF_NUMBER_TABLE
651: , p4_a18 out nocopy JTF_NUMBER_TABLE
652: , p4_a19 out nocopy JTF_NUMBER_TABLE
653: , p4_a20 out nocopy JTF_NUMBER_TABLE
654: , p4_a21 out nocopy JTF_VARCHAR2_TABLE_100
655: , p4_a22 out nocopy JTF_VARCHAR2_TABLE_100
656: , p4_a23 out nocopy JTF_VARCHAR2_TABLE_100
657: , p4_a24 out nocopy JTF_NUMBER_TABLE
658: , p4_a25 out nocopy JTF_NUMBER_TABLE
651: , p4_a18 out nocopy JTF_NUMBER_TABLE
652: , p4_a19 out nocopy JTF_NUMBER_TABLE
653: , p4_a20 out nocopy JTF_NUMBER_TABLE
654: , p4_a21 out nocopy JTF_VARCHAR2_TABLE_100
655: , p4_a22 out nocopy JTF_VARCHAR2_TABLE_100
656: , p4_a23 out nocopy JTF_VARCHAR2_TABLE_100
657: , p4_a24 out nocopy JTF_NUMBER_TABLE
658: , p4_a25 out nocopy JTF_NUMBER_TABLE
659: , p4_a26 out nocopy JTF_NUMBER_TABLE
652: , p4_a19 out nocopy JTF_NUMBER_TABLE
653: , p4_a20 out nocopy JTF_NUMBER_TABLE
654: , p4_a21 out nocopy JTF_VARCHAR2_TABLE_100
655: , p4_a22 out nocopy JTF_VARCHAR2_TABLE_100
656: , p4_a23 out nocopy JTF_VARCHAR2_TABLE_100
657: , p4_a24 out nocopy JTF_NUMBER_TABLE
658: , p4_a25 out nocopy JTF_NUMBER_TABLE
659: , p4_a26 out nocopy JTF_NUMBER_TABLE
660: , p4_a27 out nocopy JTF_NUMBER_TABLE
776: , p1_a3 JTF_NUMBER_TABLE
777: , p1_a4 JTF_NUMBER_TABLE
778: , p1_a5 JTF_NUMBER_TABLE
779: , p1_a6 JTF_NUMBER_TABLE
780: , p1_a7 JTF_VARCHAR2_TABLE_100
781: , p1_a8 JTF_VARCHAR2_TABLE_100
782: , p1_a9 JTF_VARCHAR2_TABLE_100
783: , p_based_on_terms VARCHAR2
784: , p_installment_number NUMBER
777: , p1_a4 JTF_NUMBER_TABLE
778: , p1_a5 JTF_NUMBER_TABLE
779: , p1_a6 JTF_NUMBER_TABLE
780: , p1_a7 JTF_VARCHAR2_TABLE_100
781: , p1_a8 JTF_VARCHAR2_TABLE_100
782: , p1_a9 JTF_VARCHAR2_TABLE_100
783: , p_based_on_terms VARCHAR2
784: , p_installment_number NUMBER
785: , p4_a0 out nocopy JTF_NUMBER_TABLE
778: , p1_a5 JTF_NUMBER_TABLE
779: , p1_a6 JTF_NUMBER_TABLE
780: , p1_a7 JTF_VARCHAR2_TABLE_100
781: , p1_a8 JTF_VARCHAR2_TABLE_100
782: , p1_a9 JTF_VARCHAR2_TABLE_100
783: , p_based_on_terms VARCHAR2
784: , p_installment_number NUMBER
785: , p4_a0 out nocopy JTF_NUMBER_TABLE
786: , p4_a1 out nocopy JTF_DATE_TABLE
802: , p4_a17 out nocopy JTF_NUMBER_TABLE
803: , p4_a18 out nocopy JTF_NUMBER_TABLE
804: , p4_a19 out nocopy JTF_NUMBER_TABLE
805: , p4_a20 out nocopy JTF_NUMBER_TABLE
806: , p4_a21 out nocopy JTF_VARCHAR2_TABLE_100
807: , p4_a22 out nocopy JTF_VARCHAR2_TABLE_100
808: , p4_a23 out nocopy JTF_VARCHAR2_TABLE_100
809: , p4_a24 out nocopy JTF_NUMBER_TABLE
810: , p4_a25 out nocopy JTF_NUMBER_TABLE
803: , p4_a18 out nocopy JTF_NUMBER_TABLE
804: , p4_a19 out nocopy JTF_NUMBER_TABLE
805: , p4_a20 out nocopy JTF_NUMBER_TABLE
806: , p4_a21 out nocopy JTF_VARCHAR2_TABLE_100
807: , p4_a22 out nocopy JTF_VARCHAR2_TABLE_100
808: , p4_a23 out nocopy JTF_VARCHAR2_TABLE_100
809: , p4_a24 out nocopy JTF_NUMBER_TABLE
810: , p4_a25 out nocopy JTF_NUMBER_TABLE
811: , p4_a26 out nocopy JTF_NUMBER_TABLE
804: , p4_a19 out nocopy JTF_NUMBER_TABLE
805: , p4_a20 out nocopy JTF_NUMBER_TABLE
806: , p4_a21 out nocopy JTF_VARCHAR2_TABLE_100
807: , p4_a22 out nocopy JTF_VARCHAR2_TABLE_100
808: , p4_a23 out nocopy JTF_VARCHAR2_TABLE_100
809: , p4_a24 out nocopy JTF_NUMBER_TABLE
810: , p4_a25 out nocopy JTF_NUMBER_TABLE
811: , p4_a26 out nocopy JTF_NUMBER_TABLE
812: , p4_a27 out nocopy JTF_NUMBER_TABLE
849: , p3_a17 out nocopy JTF_NUMBER_TABLE
850: , p3_a18 out nocopy JTF_NUMBER_TABLE
851: , p3_a19 out nocopy JTF_NUMBER_TABLE
852: , p3_a20 out nocopy JTF_NUMBER_TABLE
853: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
854: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
855: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
856: , p3_a24 out nocopy JTF_NUMBER_TABLE
857: , p3_a25 out nocopy JTF_NUMBER_TABLE
850: , p3_a18 out nocopy JTF_NUMBER_TABLE
851: , p3_a19 out nocopy JTF_NUMBER_TABLE
852: , p3_a20 out nocopy JTF_NUMBER_TABLE
853: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
854: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
855: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
856: , p3_a24 out nocopy JTF_NUMBER_TABLE
857: , p3_a25 out nocopy JTF_NUMBER_TABLE
858: , p3_a26 out nocopy JTF_NUMBER_TABLE
851: , p3_a19 out nocopy JTF_NUMBER_TABLE
852: , p3_a20 out nocopy JTF_NUMBER_TABLE
853: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
854: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
855: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
856: , p3_a24 out nocopy JTF_NUMBER_TABLE
857: , p3_a25 out nocopy JTF_NUMBER_TABLE
858: , p3_a26 out nocopy JTF_NUMBER_TABLE
859: , p3_a27 out nocopy JTF_NUMBER_TABLE
976: , p2_a3 JTF_NUMBER_TABLE
977: , p2_a4 JTF_NUMBER_TABLE
978: , p2_a5 JTF_NUMBER_TABLE
979: , p2_a6 JTF_NUMBER_TABLE
980: , p2_a7 JTF_VARCHAR2_TABLE_100
981: , p2_a8 JTF_VARCHAR2_TABLE_100
982: , p2_a9 JTF_VARCHAR2_TABLE_100
983: , p3_a0 out nocopy JTF_NUMBER_TABLE
984: , p3_a1 out nocopy JTF_DATE_TABLE
977: , p2_a4 JTF_NUMBER_TABLE
978: , p2_a5 JTF_NUMBER_TABLE
979: , p2_a6 JTF_NUMBER_TABLE
980: , p2_a7 JTF_VARCHAR2_TABLE_100
981: , p2_a8 JTF_VARCHAR2_TABLE_100
982: , p2_a9 JTF_VARCHAR2_TABLE_100
983: , p3_a0 out nocopy JTF_NUMBER_TABLE
984: , p3_a1 out nocopy JTF_DATE_TABLE
985: , p3_a2 out nocopy JTF_DATE_TABLE
978: , p2_a5 JTF_NUMBER_TABLE
979: , p2_a6 JTF_NUMBER_TABLE
980: , p2_a7 JTF_VARCHAR2_TABLE_100
981: , p2_a8 JTF_VARCHAR2_TABLE_100
982: , p2_a9 JTF_VARCHAR2_TABLE_100
983: , p3_a0 out nocopy JTF_NUMBER_TABLE
984: , p3_a1 out nocopy JTF_DATE_TABLE
985: , p3_a2 out nocopy JTF_DATE_TABLE
986: , p3_a3 out nocopy JTF_DATE_TABLE
1000: , p3_a17 out nocopy JTF_NUMBER_TABLE
1001: , p3_a18 out nocopy JTF_NUMBER_TABLE
1002: , p3_a19 out nocopy JTF_NUMBER_TABLE
1003: , p3_a20 out nocopy JTF_NUMBER_TABLE
1004: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
1005: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
1006: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
1007: , p3_a24 out nocopy JTF_NUMBER_TABLE
1008: , p3_a25 out nocopy JTF_NUMBER_TABLE
1001: , p3_a18 out nocopy JTF_NUMBER_TABLE
1002: , p3_a19 out nocopy JTF_NUMBER_TABLE
1003: , p3_a20 out nocopy JTF_NUMBER_TABLE
1004: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
1005: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
1006: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
1007: , p3_a24 out nocopy JTF_NUMBER_TABLE
1008: , p3_a25 out nocopy JTF_NUMBER_TABLE
1009: , p3_a26 out nocopy JTF_NUMBER_TABLE
1002: , p3_a19 out nocopy JTF_NUMBER_TABLE
1003: , p3_a20 out nocopy JTF_NUMBER_TABLE
1004: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
1005: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
1006: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
1007: , p3_a24 out nocopy JTF_NUMBER_TABLE
1008: , p3_a25 out nocopy JTF_NUMBER_TABLE
1009: , p3_a26 out nocopy JTF_NUMBER_TABLE
1010: , p3_a27 out nocopy JTF_NUMBER_TABLE
1047: , p3_a17 out nocopy JTF_NUMBER_TABLE
1048: , p3_a18 out nocopy JTF_NUMBER_TABLE
1049: , p3_a19 out nocopy JTF_NUMBER_TABLE
1050: , p3_a20 out nocopy JTF_NUMBER_TABLE
1051: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
1052: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
1053: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
1054: , p3_a24 out nocopy JTF_NUMBER_TABLE
1055: , p3_a25 out nocopy JTF_NUMBER_TABLE
1048: , p3_a18 out nocopy JTF_NUMBER_TABLE
1049: , p3_a19 out nocopy JTF_NUMBER_TABLE
1050: , p3_a20 out nocopy JTF_NUMBER_TABLE
1051: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
1052: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
1053: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
1054: , p3_a24 out nocopy JTF_NUMBER_TABLE
1055: , p3_a25 out nocopy JTF_NUMBER_TABLE
1056: , p3_a26 out nocopy JTF_NUMBER_TABLE
1049: , p3_a19 out nocopy JTF_NUMBER_TABLE
1050: , p3_a20 out nocopy JTF_NUMBER_TABLE
1051: , p3_a21 out nocopy JTF_VARCHAR2_TABLE_100
1052: , p3_a22 out nocopy JTF_VARCHAR2_TABLE_100
1053: , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
1054: , p3_a24 out nocopy JTF_NUMBER_TABLE
1055: , p3_a25 out nocopy JTF_NUMBER_TABLE
1056: , p3_a26 out nocopy JTF_NUMBER_TABLE
1057: , p3_a27 out nocopy JTF_NUMBER_TABLE
1099: , p5_a17 out nocopy JTF_NUMBER_TABLE
1100: , p5_a18 out nocopy JTF_NUMBER_TABLE
1101: , p5_a19 out nocopy JTF_NUMBER_TABLE
1102: , p5_a20 out nocopy JTF_NUMBER_TABLE
1103: , p5_a21 out nocopy JTF_VARCHAR2_TABLE_100
1104: , p5_a22 out nocopy JTF_VARCHAR2_TABLE_100
1105: , p5_a23 out nocopy JTF_VARCHAR2_TABLE_100
1106: , p5_a24 out nocopy JTF_NUMBER_TABLE
1107: , p5_a25 out nocopy JTF_NUMBER_TABLE
1100: , p5_a18 out nocopy JTF_NUMBER_TABLE
1101: , p5_a19 out nocopy JTF_NUMBER_TABLE
1102: , p5_a20 out nocopy JTF_NUMBER_TABLE
1103: , p5_a21 out nocopy JTF_VARCHAR2_TABLE_100
1104: , p5_a22 out nocopy JTF_VARCHAR2_TABLE_100
1105: , p5_a23 out nocopy JTF_VARCHAR2_TABLE_100
1106: , p5_a24 out nocopy JTF_NUMBER_TABLE
1107: , p5_a25 out nocopy JTF_NUMBER_TABLE
1108: , p5_a26 out nocopy JTF_NUMBER_TABLE
1101: , p5_a19 out nocopy JTF_NUMBER_TABLE
1102: , p5_a20 out nocopy JTF_NUMBER_TABLE
1103: , p5_a21 out nocopy JTF_VARCHAR2_TABLE_100
1104: , p5_a22 out nocopy JTF_VARCHAR2_TABLE_100
1105: , p5_a23 out nocopy JTF_VARCHAR2_TABLE_100
1106: , p5_a24 out nocopy JTF_NUMBER_TABLE
1107: , p5_a25 out nocopy JTF_NUMBER_TABLE
1108: , p5_a26 out nocopy JTF_NUMBER_TABLE
1109: , p5_a27 out nocopy JTF_NUMBER_TABLE
1174: , p5_a40 out nocopy VARCHAR2
1175: , p5_a41 out nocopy NUMBER
1176: , p5_a42 out nocopy VARCHAR2
1177: , p6_a0 out nocopy JTF_NUMBER_TABLE
1178: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
1179: , p6_a2 out nocopy JTF_NUMBER_TABLE
1180: , p6_a3 out nocopy JTF_NUMBER_TABLE
1181: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300
1182: , p6_a5 out nocopy JTF_NUMBER_TABLE
1179: , p6_a2 out nocopy JTF_NUMBER_TABLE
1180: , p6_a3 out nocopy JTF_NUMBER_TABLE
1181: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300
1182: , p6_a5 out nocopy JTF_NUMBER_TABLE
1183: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1184: , p6_a7 out nocopy JTF_NUMBER_TABLE
1185: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
1186: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1187: , x_return_status out nocopy VARCHAR2
1181: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300
1182: , p6_a5 out nocopy JTF_NUMBER_TABLE
1183: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1184: , p6_a7 out nocopy JTF_NUMBER_TABLE
1185: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
1186: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1187: , x_return_status out nocopy VARCHAR2
1188: , x_msg_count out nocopy NUMBER
1189: , x_msg_data out nocopy VARCHAR2
1182: , p6_a5 out nocopy JTF_NUMBER_TABLE
1183: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1184: , p6_a7 out nocopy JTF_NUMBER_TABLE
1185: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
1186: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1187: , x_return_status out nocopy VARCHAR2
1188: , x_msg_count out nocopy NUMBER
1189: , x_msg_data out nocopy VARCHAR2
1190: );
1234: , p3_a40 out nocopy VARCHAR2
1235: , p3_a41 out nocopy NUMBER
1236: , p3_a42 out nocopy VARCHAR2
1237: , p4_a0 out nocopy JTF_NUMBER_TABLE
1238: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
1239: , p4_a2 out nocopy JTF_NUMBER_TABLE
1240: , p4_a3 out nocopy JTF_NUMBER_TABLE
1241: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_300
1242: , p4_a5 out nocopy JTF_NUMBER_TABLE
1239: , p4_a2 out nocopy JTF_NUMBER_TABLE
1240: , p4_a3 out nocopy JTF_NUMBER_TABLE
1241: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_300
1242: , p4_a5 out nocopy JTF_NUMBER_TABLE
1243: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
1244: , p4_a7 out nocopy JTF_NUMBER_TABLE
1245: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
1246: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
1247: , x_return_status out nocopy VARCHAR2
1241: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_300
1242: , p4_a5 out nocopy JTF_NUMBER_TABLE
1243: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
1244: , p4_a7 out nocopy JTF_NUMBER_TABLE
1245: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
1246: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
1247: , x_return_status out nocopy VARCHAR2
1248: , x_msg_count out nocopy NUMBER
1249: , x_msg_data out nocopy VARCHAR2
1242: , p4_a5 out nocopy JTF_NUMBER_TABLE
1243: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
1244: , p4_a7 out nocopy JTF_NUMBER_TABLE
1245: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
1246: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
1247: , x_return_status out nocopy VARCHAR2
1248: , x_msg_count out nocopy NUMBER
1249: , x_msg_data out nocopy VARCHAR2
1250: );
1366: , p_init_msg_list VARCHAR2
1367: , p_loan_id NUMBER
1368: , p_date DATE
1369: , p_reason VARCHAR2
1370: , p5_a0 out nocopy JTF_VARCHAR2_TABLE_100
1371: , p5_a1 out nocopy JTF_NUMBER_TABLE
1372: , p5_a2 out nocopy JTF_NUMBER_TABLE
1373: , p5_a3 out nocopy JTF_NUMBER_TABLE
1374: , x_return_status out nocopy VARCHAR2