50: , a24 JTF_NUMBER_TABLE
51: , a25 JTF_NUMBER_TABLE
52: , a26 JTF_NUMBER_TABLE
53: , a27 JTF_NUMBER_TABLE
54: , a28 JTF_VARCHAR2_TABLE_2000
55: , a29 JTF_VARCHAR2_TABLE_2000
56: , a30 JTF_VARCHAR2_TABLE_2000
57: , a31 JTF_VARCHAR2_TABLE_2000
58: , a32 JTF_NUMBER_TABLE
51: , a25 JTF_NUMBER_TABLE
52: , a26 JTF_NUMBER_TABLE
53: , a27 JTF_NUMBER_TABLE
54: , a28 JTF_VARCHAR2_TABLE_2000
55: , a29 JTF_VARCHAR2_TABLE_2000
56: , a30 JTF_VARCHAR2_TABLE_2000
57: , a31 JTF_VARCHAR2_TABLE_2000
58: , a32 JTF_NUMBER_TABLE
59: , a33 JTF_VARCHAR2_TABLE_200
52: , a26 JTF_NUMBER_TABLE
53: , a27 JTF_NUMBER_TABLE
54: , a28 JTF_VARCHAR2_TABLE_2000
55: , a29 JTF_VARCHAR2_TABLE_2000
56: , a30 JTF_VARCHAR2_TABLE_2000
57: , a31 JTF_VARCHAR2_TABLE_2000
58: , a32 JTF_NUMBER_TABLE
59: , a33 JTF_VARCHAR2_TABLE_200
60: , a34 JTF_NUMBER_TABLE
53: , a27 JTF_NUMBER_TABLE
54: , a28 JTF_VARCHAR2_TABLE_2000
55: , a29 JTF_VARCHAR2_TABLE_2000
56: , a30 JTF_VARCHAR2_TABLE_2000
57: , a31 JTF_VARCHAR2_TABLE_2000
58: , a32 JTF_NUMBER_TABLE
59: , a33 JTF_VARCHAR2_TABLE_200
60: , a34 JTF_NUMBER_TABLE
61: , a35 JTF_NUMBER_TABLE
58: , a32 JTF_NUMBER_TABLE
59: , a33 JTF_VARCHAR2_TABLE_200
60: , a34 JTF_NUMBER_TABLE
61: , a35 JTF_NUMBER_TABLE
62: , a36 JTF_VARCHAR2_TABLE_2000
63: , a37 JTF_NUMBER_TABLE
64: , a38 JTF_NUMBER_TABLE
65: , a39 JTF_NUMBER_TABLE
66: , a40 JTF_VARCHAR2_TABLE_2000
62: , a36 JTF_VARCHAR2_TABLE_2000
63: , a37 JTF_NUMBER_TABLE
64: , a38 JTF_NUMBER_TABLE
65: , a39 JTF_NUMBER_TABLE
66: , a40 JTF_VARCHAR2_TABLE_2000
67: , a41 JTF_NUMBER_TABLE
68: , a42 JTF_VARCHAR2_TABLE_2000
69: );
70: procedure rosetta_table_copy_out_p3(t lns_financials.amortization_tbl, a0 out nocopy JTF_NUMBER_TABLE
64: , a38 JTF_NUMBER_TABLE
65: , a39 JTF_NUMBER_TABLE
66: , a40 JTF_VARCHAR2_TABLE_2000
67: , a41 JTF_NUMBER_TABLE
68: , a42 JTF_VARCHAR2_TABLE_2000
69: );
70: procedure rosetta_table_copy_out_p3(t lns_financials.amortization_tbl, a0 out nocopy JTF_NUMBER_TABLE
71: , a1 out nocopy JTF_DATE_TABLE
72: , a2 out nocopy JTF_DATE_TABLE
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
98: , a28 out nocopy JTF_VARCHAR2_TABLE_2000
99: , a29 out nocopy JTF_VARCHAR2_TABLE_2000
100: , a30 out nocopy JTF_VARCHAR2_TABLE_2000
101: , a31 out nocopy JTF_VARCHAR2_TABLE_2000
102: , a32 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
98: , a28 out nocopy JTF_VARCHAR2_TABLE_2000
99: , a29 out nocopy JTF_VARCHAR2_TABLE_2000
100: , a30 out nocopy JTF_VARCHAR2_TABLE_2000
101: , a31 out nocopy JTF_VARCHAR2_TABLE_2000
102: , a32 out nocopy JTF_NUMBER_TABLE
103: , a33 out nocopy JTF_VARCHAR2_TABLE_200
96: , a26 out nocopy JTF_NUMBER_TABLE
97: , a27 out nocopy JTF_NUMBER_TABLE
98: , a28 out nocopy JTF_VARCHAR2_TABLE_2000
99: , a29 out nocopy JTF_VARCHAR2_TABLE_2000
100: , a30 out nocopy JTF_VARCHAR2_TABLE_2000
101: , a31 out nocopy JTF_VARCHAR2_TABLE_2000
102: , a32 out nocopy JTF_NUMBER_TABLE
103: , a33 out nocopy JTF_VARCHAR2_TABLE_200
104: , a34 out nocopy JTF_NUMBER_TABLE
97: , a27 out nocopy JTF_NUMBER_TABLE
98: , a28 out nocopy JTF_VARCHAR2_TABLE_2000
99: , a29 out nocopy JTF_VARCHAR2_TABLE_2000
100: , a30 out nocopy JTF_VARCHAR2_TABLE_2000
101: , a31 out nocopy JTF_VARCHAR2_TABLE_2000
102: , a32 out nocopy JTF_NUMBER_TABLE
103: , a33 out nocopy JTF_VARCHAR2_TABLE_200
104: , a34 out nocopy JTF_NUMBER_TABLE
105: , a35 out nocopy JTF_NUMBER_TABLE
102: , a32 out nocopy JTF_NUMBER_TABLE
103: , a33 out nocopy JTF_VARCHAR2_TABLE_200
104: , a34 out nocopy JTF_NUMBER_TABLE
105: , a35 out nocopy JTF_NUMBER_TABLE
106: , a36 out nocopy JTF_VARCHAR2_TABLE_2000
107: , a37 out nocopy JTF_NUMBER_TABLE
108: , a38 out nocopy JTF_NUMBER_TABLE
109: , a39 out nocopy JTF_NUMBER_TABLE
110: , a40 out nocopy JTF_VARCHAR2_TABLE_2000
106: , a36 out nocopy JTF_VARCHAR2_TABLE_2000
107: , a37 out nocopy JTF_NUMBER_TABLE
108: , a38 out nocopy JTF_NUMBER_TABLE
109: , a39 out nocopy JTF_NUMBER_TABLE
110: , a40 out nocopy JTF_VARCHAR2_TABLE_2000
111: , a41 out nocopy JTF_NUMBER_TABLE
112: , a42 out nocopy JTF_VARCHAR2_TABLE_2000
113: );
114:
108: , a38 out nocopy JTF_NUMBER_TABLE
109: , a39 out nocopy JTF_NUMBER_TABLE
110: , a40 out nocopy JTF_VARCHAR2_TABLE_2000
111: , a41 out nocopy JTF_NUMBER_TABLE
112: , a42 out nocopy JTF_VARCHAR2_TABLE_2000
113: );
114:
115: procedure rosetta_table_copy_in_p6(t out nocopy lns_financials.payoff_tbl, a0 JTF_NUMBER_TABLE
116: , a1 JTF_NUMBER_TABLE
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
661: , p4_a28 out nocopy JTF_VARCHAR2_TABLE_2000
662: , p4_a29 out nocopy JTF_VARCHAR2_TABLE_2000
663: , p4_a30 out nocopy JTF_VARCHAR2_TABLE_2000
664: , p4_a31 out nocopy JTF_VARCHAR2_TABLE_2000
665: , p4_a32 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
661: , p4_a28 out nocopy JTF_VARCHAR2_TABLE_2000
662: , p4_a29 out nocopy JTF_VARCHAR2_TABLE_2000
663: , p4_a30 out nocopy JTF_VARCHAR2_TABLE_2000
664: , p4_a31 out nocopy JTF_VARCHAR2_TABLE_2000
665: , p4_a32 out nocopy JTF_NUMBER_TABLE
666: , p4_a33 out nocopy JTF_VARCHAR2_TABLE_200
659: , p4_a26 out nocopy JTF_NUMBER_TABLE
660: , p4_a27 out nocopy JTF_NUMBER_TABLE
661: , p4_a28 out nocopy JTF_VARCHAR2_TABLE_2000
662: , p4_a29 out nocopy JTF_VARCHAR2_TABLE_2000
663: , p4_a30 out nocopy JTF_VARCHAR2_TABLE_2000
664: , p4_a31 out nocopy JTF_VARCHAR2_TABLE_2000
665: , p4_a32 out nocopy JTF_NUMBER_TABLE
666: , p4_a33 out nocopy JTF_VARCHAR2_TABLE_200
667: , p4_a34 out nocopy JTF_NUMBER_TABLE
660: , p4_a27 out nocopy JTF_NUMBER_TABLE
661: , p4_a28 out nocopy JTF_VARCHAR2_TABLE_2000
662: , p4_a29 out nocopy JTF_VARCHAR2_TABLE_2000
663: , p4_a30 out nocopy JTF_VARCHAR2_TABLE_2000
664: , p4_a31 out nocopy JTF_VARCHAR2_TABLE_2000
665: , p4_a32 out nocopy JTF_NUMBER_TABLE
666: , p4_a33 out nocopy JTF_VARCHAR2_TABLE_200
667: , p4_a34 out nocopy JTF_NUMBER_TABLE
668: , p4_a35 out nocopy JTF_NUMBER_TABLE
665: , p4_a32 out nocopy JTF_NUMBER_TABLE
666: , p4_a33 out nocopy JTF_VARCHAR2_TABLE_200
667: , p4_a34 out nocopy JTF_NUMBER_TABLE
668: , p4_a35 out nocopy JTF_NUMBER_TABLE
669: , p4_a36 out nocopy JTF_VARCHAR2_TABLE_2000
670: , p4_a37 out nocopy JTF_NUMBER_TABLE
671: , p4_a38 out nocopy JTF_NUMBER_TABLE
672: , p4_a39 out nocopy JTF_NUMBER_TABLE
673: , p4_a40 out nocopy JTF_VARCHAR2_TABLE_2000
669: , p4_a36 out nocopy JTF_VARCHAR2_TABLE_2000
670: , p4_a37 out nocopy JTF_NUMBER_TABLE
671: , p4_a38 out nocopy JTF_NUMBER_TABLE
672: , p4_a39 out nocopy JTF_NUMBER_TABLE
673: , p4_a40 out nocopy JTF_VARCHAR2_TABLE_2000
674: , p4_a41 out nocopy JTF_NUMBER_TABLE
675: , p4_a42 out nocopy JTF_VARCHAR2_TABLE_2000
676: );
677: procedure amortizeloan(p0_a0 NUMBER
671: , p4_a38 out nocopy JTF_NUMBER_TABLE
672: , p4_a39 out nocopy JTF_NUMBER_TABLE
673: , p4_a40 out nocopy JTF_VARCHAR2_TABLE_2000
674: , p4_a41 out nocopy JTF_NUMBER_TABLE
675: , p4_a42 out nocopy JTF_VARCHAR2_TABLE_2000
676: );
677: procedure amortizeloan(p0_a0 NUMBER
678: , p0_a1 NUMBER
679: , p0_a2 VARCHAR2
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
813: , p4_a28 out nocopy JTF_VARCHAR2_TABLE_2000
814: , p4_a29 out nocopy JTF_VARCHAR2_TABLE_2000
815: , p4_a30 out nocopy JTF_VARCHAR2_TABLE_2000
816: , p4_a31 out nocopy JTF_VARCHAR2_TABLE_2000
817: , p4_a32 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
813: , p4_a28 out nocopy JTF_VARCHAR2_TABLE_2000
814: , p4_a29 out nocopy JTF_VARCHAR2_TABLE_2000
815: , p4_a30 out nocopy JTF_VARCHAR2_TABLE_2000
816: , p4_a31 out nocopy JTF_VARCHAR2_TABLE_2000
817: , p4_a32 out nocopy JTF_NUMBER_TABLE
818: , p4_a33 out nocopy JTF_VARCHAR2_TABLE_200
811: , p4_a26 out nocopy JTF_NUMBER_TABLE
812: , p4_a27 out nocopy JTF_NUMBER_TABLE
813: , p4_a28 out nocopy JTF_VARCHAR2_TABLE_2000
814: , p4_a29 out nocopy JTF_VARCHAR2_TABLE_2000
815: , p4_a30 out nocopy JTF_VARCHAR2_TABLE_2000
816: , p4_a31 out nocopy JTF_VARCHAR2_TABLE_2000
817: , p4_a32 out nocopy JTF_NUMBER_TABLE
818: , p4_a33 out nocopy JTF_VARCHAR2_TABLE_200
819: , p4_a34 out nocopy JTF_NUMBER_TABLE
812: , p4_a27 out nocopy JTF_NUMBER_TABLE
813: , p4_a28 out nocopy JTF_VARCHAR2_TABLE_2000
814: , p4_a29 out nocopy JTF_VARCHAR2_TABLE_2000
815: , p4_a30 out nocopy JTF_VARCHAR2_TABLE_2000
816: , p4_a31 out nocopy JTF_VARCHAR2_TABLE_2000
817: , p4_a32 out nocopy JTF_NUMBER_TABLE
818: , p4_a33 out nocopy JTF_VARCHAR2_TABLE_200
819: , p4_a34 out nocopy JTF_NUMBER_TABLE
820: , p4_a35 out nocopy JTF_NUMBER_TABLE
817: , p4_a32 out nocopy JTF_NUMBER_TABLE
818: , p4_a33 out nocopy JTF_VARCHAR2_TABLE_200
819: , p4_a34 out nocopy JTF_NUMBER_TABLE
820: , p4_a35 out nocopy JTF_NUMBER_TABLE
821: , p4_a36 out nocopy JTF_VARCHAR2_TABLE_2000
822: , p4_a37 out nocopy JTF_NUMBER_TABLE
823: , p4_a38 out nocopy JTF_NUMBER_TABLE
824: , p4_a39 out nocopy JTF_NUMBER_TABLE
825: , p4_a40 out nocopy JTF_VARCHAR2_TABLE_2000
821: , p4_a36 out nocopy JTF_VARCHAR2_TABLE_2000
822: , p4_a37 out nocopy JTF_NUMBER_TABLE
823: , p4_a38 out nocopy JTF_NUMBER_TABLE
824: , p4_a39 out nocopy JTF_NUMBER_TABLE
825: , p4_a40 out nocopy JTF_VARCHAR2_TABLE_2000
826: , p4_a41 out nocopy JTF_NUMBER_TABLE
827: , p4_a42 out nocopy JTF_VARCHAR2_TABLE_2000
828: );
829: procedure amortizeloan(p_loan_id NUMBER
823: , p4_a38 out nocopy JTF_NUMBER_TABLE
824: , p4_a39 out nocopy JTF_NUMBER_TABLE
825: , p4_a40 out nocopy JTF_VARCHAR2_TABLE_2000
826: , p4_a41 out nocopy JTF_NUMBER_TABLE
827: , p4_a42 out nocopy JTF_VARCHAR2_TABLE_2000
828: );
829: procedure amortizeloan(p_loan_id NUMBER
830: , p_based_on_terms VARCHAR2
831: , p_installment_number NUMBER
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
860: , p3_a28 out nocopy JTF_VARCHAR2_TABLE_2000
861: , p3_a29 out nocopy JTF_VARCHAR2_TABLE_2000
862: , p3_a30 out nocopy JTF_VARCHAR2_TABLE_2000
863: , p3_a31 out nocopy JTF_VARCHAR2_TABLE_2000
864: , p3_a32 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
860: , p3_a28 out nocopy JTF_VARCHAR2_TABLE_2000
861: , p3_a29 out nocopy JTF_VARCHAR2_TABLE_2000
862: , p3_a30 out nocopy JTF_VARCHAR2_TABLE_2000
863: , p3_a31 out nocopy JTF_VARCHAR2_TABLE_2000
864: , p3_a32 out nocopy JTF_NUMBER_TABLE
865: , p3_a33 out nocopy JTF_VARCHAR2_TABLE_200
858: , p3_a26 out nocopy JTF_NUMBER_TABLE
859: , p3_a27 out nocopy JTF_NUMBER_TABLE
860: , p3_a28 out nocopy JTF_VARCHAR2_TABLE_2000
861: , p3_a29 out nocopy JTF_VARCHAR2_TABLE_2000
862: , p3_a30 out nocopy JTF_VARCHAR2_TABLE_2000
863: , p3_a31 out nocopy JTF_VARCHAR2_TABLE_2000
864: , p3_a32 out nocopy JTF_NUMBER_TABLE
865: , p3_a33 out nocopy JTF_VARCHAR2_TABLE_200
866: , p3_a34 out nocopy JTF_NUMBER_TABLE
859: , p3_a27 out nocopy JTF_NUMBER_TABLE
860: , p3_a28 out nocopy JTF_VARCHAR2_TABLE_2000
861: , p3_a29 out nocopy JTF_VARCHAR2_TABLE_2000
862: , p3_a30 out nocopy JTF_VARCHAR2_TABLE_2000
863: , p3_a31 out nocopy JTF_VARCHAR2_TABLE_2000
864: , p3_a32 out nocopy JTF_NUMBER_TABLE
865: , p3_a33 out nocopy JTF_VARCHAR2_TABLE_200
866: , p3_a34 out nocopy JTF_NUMBER_TABLE
867: , p3_a35 out nocopy JTF_NUMBER_TABLE
864: , p3_a32 out nocopy JTF_NUMBER_TABLE
865: , p3_a33 out nocopy JTF_VARCHAR2_TABLE_200
866: , p3_a34 out nocopy JTF_NUMBER_TABLE
867: , p3_a35 out nocopy JTF_NUMBER_TABLE
868: , p3_a36 out nocopy JTF_VARCHAR2_TABLE_2000
869: , p3_a37 out nocopy JTF_NUMBER_TABLE
870: , p3_a38 out nocopy JTF_NUMBER_TABLE
871: , p3_a39 out nocopy JTF_NUMBER_TABLE
872: , p3_a40 out nocopy JTF_VARCHAR2_TABLE_2000
868: , p3_a36 out nocopy JTF_VARCHAR2_TABLE_2000
869: , p3_a37 out nocopy JTF_NUMBER_TABLE
870: , p3_a38 out nocopy JTF_NUMBER_TABLE
871: , p3_a39 out nocopy JTF_NUMBER_TABLE
872: , p3_a40 out nocopy JTF_VARCHAR2_TABLE_2000
873: , p3_a41 out nocopy JTF_NUMBER_TABLE
874: , p3_a42 out nocopy JTF_VARCHAR2_TABLE_2000
875: );
876: procedure loanprojection(p0_a0 NUMBER
870: , p3_a38 out nocopy JTF_NUMBER_TABLE
871: , p3_a39 out nocopy JTF_NUMBER_TABLE
872: , p3_a40 out nocopy JTF_VARCHAR2_TABLE_2000
873: , p3_a41 out nocopy JTF_NUMBER_TABLE
874: , p3_a42 out nocopy JTF_VARCHAR2_TABLE_2000
875: );
876: procedure loanprojection(p0_a0 NUMBER
877: , p0_a1 NUMBER
878: , p0_a2 VARCHAR2
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
1011: , p3_a28 out nocopy JTF_VARCHAR2_TABLE_2000
1012: , p3_a29 out nocopy JTF_VARCHAR2_TABLE_2000
1013: , p3_a30 out nocopy JTF_VARCHAR2_TABLE_2000
1014: , p3_a31 out nocopy JTF_VARCHAR2_TABLE_2000
1015: , p3_a32 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
1011: , p3_a28 out nocopy JTF_VARCHAR2_TABLE_2000
1012: , p3_a29 out nocopy JTF_VARCHAR2_TABLE_2000
1013: , p3_a30 out nocopy JTF_VARCHAR2_TABLE_2000
1014: , p3_a31 out nocopy JTF_VARCHAR2_TABLE_2000
1015: , p3_a32 out nocopy JTF_NUMBER_TABLE
1016: , p3_a33 out nocopy JTF_VARCHAR2_TABLE_200
1009: , p3_a26 out nocopy JTF_NUMBER_TABLE
1010: , p3_a27 out nocopy JTF_NUMBER_TABLE
1011: , p3_a28 out nocopy JTF_VARCHAR2_TABLE_2000
1012: , p3_a29 out nocopy JTF_VARCHAR2_TABLE_2000
1013: , p3_a30 out nocopy JTF_VARCHAR2_TABLE_2000
1014: , p3_a31 out nocopy JTF_VARCHAR2_TABLE_2000
1015: , p3_a32 out nocopy JTF_NUMBER_TABLE
1016: , p3_a33 out nocopy JTF_VARCHAR2_TABLE_200
1017: , p3_a34 out nocopy JTF_NUMBER_TABLE
1010: , p3_a27 out nocopy JTF_NUMBER_TABLE
1011: , p3_a28 out nocopy JTF_VARCHAR2_TABLE_2000
1012: , p3_a29 out nocopy JTF_VARCHAR2_TABLE_2000
1013: , p3_a30 out nocopy JTF_VARCHAR2_TABLE_2000
1014: , p3_a31 out nocopy JTF_VARCHAR2_TABLE_2000
1015: , p3_a32 out nocopy JTF_NUMBER_TABLE
1016: , p3_a33 out nocopy JTF_VARCHAR2_TABLE_200
1017: , p3_a34 out nocopy JTF_NUMBER_TABLE
1018: , p3_a35 out nocopy JTF_NUMBER_TABLE
1015: , p3_a32 out nocopy JTF_NUMBER_TABLE
1016: , p3_a33 out nocopy JTF_VARCHAR2_TABLE_200
1017: , p3_a34 out nocopy JTF_NUMBER_TABLE
1018: , p3_a35 out nocopy JTF_NUMBER_TABLE
1019: , p3_a36 out nocopy JTF_VARCHAR2_TABLE_2000
1020: , p3_a37 out nocopy JTF_NUMBER_TABLE
1021: , p3_a38 out nocopy JTF_NUMBER_TABLE
1022: , p3_a39 out nocopy JTF_NUMBER_TABLE
1023: , p3_a40 out nocopy JTF_VARCHAR2_TABLE_2000
1019: , p3_a36 out nocopy JTF_VARCHAR2_TABLE_2000
1020: , p3_a37 out nocopy JTF_NUMBER_TABLE
1021: , p3_a38 out nocopy JTF_NUMBER_TABLE
1022: , p3_a39 out nocopy JTF_NUMBER_TABLE
1023: , p3_a40 out nocopy JTF_VARCHAR2_TABLE_2000
1024: , p3_a41 out nocopy JTF_NUMBER_TABLE
1025: , p3_a42 out nocopy JTF_VARCHAR2_TABLE_2000
1026: );
1027: procedure runopenprojection(p_init_msg_list VARCHAR2
1021: , p3_a38 out nocopy JTF_NUMBER_TABLE
1022: , p3_a39 out nocopy JTF_NUMBER_TABLE
1023: , p3_a40 out nocopy JTF_VARCHAR2_TABLE_2000
1024: , p3_a41 out nocopy JTF_NUMBER_TABLE
1025: , p3_a42 out nocopy JTF_VARCHAR2_TABLE_2000
1026: );
1027: procedure runopenprojection(p_init_msg_list VARCHAR2
1028: , p_loan_id NUMBER
1029: , p_based_on_terms VARCHAR2
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
1058: , p3_a28 out nocopy JTF_VARCHAR2_TABLE_2000
1059: , p3_a29 out nocopy JTF_VARCHAR2_TABLE_2000
1060: , p3_a30 out nocopy JTF_VARCHAR2_TABLE_2000
1061: , p3_a31 out nocopy JTF_VARCHAR2_TABLE_2000
1062: , p3_a32 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
1058: , p3_a28 out nocopy JTF_VARCHAR2_TABLE_2000
1059: , p3_a29 out nocopy JTF_VARCHAR2_TABLE_2000
1060: , p3_a30 out nocopy JTF_VARCHAR2_TABLE_2000
1061: , p3_a31 out nocopy JTF_VARCHAR2_TABLE_2000
1062: , p3_a32 out nocopy JTF_NUMBER_TABLE
1063: , p3_a33 out nocopy JTF_VARCHAR2_TABLE_200
1056: , p3_a26 out nocopy JTF_NUMBER_TABLE
1057: , p3_a27 out nocopy JTF_NUMBER_TABLE
1058: , p3_a28 out nocopy JTF_VARCHAR2_TABLE_2000
1059: , p3_a29 out nocopy JTF_VARCHAR2_TABLE_2000
1060: , p3_a30 out nocopy JTF_VARCHAR2_TABLE_2000
1061: , p3_a31 out nocopy JTF_VARCHAR2_TABLE_2000
1062: , p3_a32 out nocopy JTF_NUMBER_TABLE
1063: , p3_a33 out nocopy JTF_VARCHAR2_TABLE_200
1064: , p3_a34 out nocopy JTF_NUMBER_TABLE
1057: , p3_a27 out nocopy JTF_NUMBER_TABLE
1058: , p3_a28 out nocopy JTF_VARCHAR2_TABLE_2000
1059: , p3_a29 out nocopy JTF_VARCHAR2_TABLE_2000
1060: , p3_a30 out nocopy JTF_VARCHAR2_TABLE_2000
1061: , p3_a31 out nocopy JTF_VARCHAR2_TABLE_2000
1062: , p3_a32 out nocopy JTF_NUMBER_TABLE
1063: , p3_a33 out nocopy JTF_VARCHAR2_TABLE_200
1064: , p3_a34 out nocopy JTF_NUMBER_TABLE
1065: , p3_a35 out nocopy JTF_NUMBER_TABLE
1062: , p3_a32 out nocopy JTF_NUMBER_TABLE
1063: , p3_a33 out nocopy JTF_VARCHAR2_TABLE_200
1064: , p3_a34 out nocopy JTF_NUMBER_TABLE
1065: , p3_a35 out nocopy JTF_NUMBER_TABLE
1066: , p3_a36 out nocopy JTF_VARCHAR2_TABLE_2000
1067: , p3_a37 out nocopy JTF_NUMBER_TABLE
1068: , p3_a38 out nocopy JTF_NUMBER_TABLE
1069: , p3_a39 out nocopy JTF_NUMBER_TABLE
1070: , p3_a40 out nocopy JTF_VARCHAR2_TABLE_2000
1066: , p3_a36 out nocopy JTF_VARCHAR2_TABLE_2000
1067: , p3_a37 out nocopy JTF_NUMBER_TABLE
1068: , p3_a38 out nocopy JTF_NUMBER_TABLE
1069: , p3_a39 out nocopy JTF_NUMBER_TABLE
1070: , p3_a40 out nocopy JTF_VARCHAR2_TABLE_2000
1071: , p3_a41 out nocopy JTF_NUMBER_TABLE
1072: , p3_a42 out nocopy JTF_VARCHAR2_TABLE_2000
1073: , x_return_status out nocopy VARCHAR2
1074: , x_msg_count out nocopy NUMBER
1068: , p3_a38 out nocopy JTF_NUMBER_TABLE
1069: , p3_a39 out nocopy JTF_NUMBER_TABLE
1070: , p3_a40 out nocopy JTF_VARCHAR2_TABLE_2000
1071: , p3_a41 out nocopy JTF_NUMBER_TABLE
1072: , p3_a42 out nocopy JTF_VARCHAR2_TABLE_2000
1073: , x_return_status out nocopy VARCHAR2
1074: , x_msg_count out nocopy NUMBER
1075: , x_msg_data out nocopy VARCHAR2
1076: );
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
1110: , p5_a28 out nocopy JTF_VARCHAR2_TABLE_2000
1111: , p5_a29 out nocopy JTF_VARCHAR2_TABLE_2000
1112: , p5_a30 out nocopy JTF_VARCHAR2_TABLE_2000
1113: , p5_a31 out nocopy JTF_VARCHAR2_TABLE_2000
1114: , p5_a32 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
1110: , p5_a28 out nocopy JTF_VARCHAR2_TABLE_2000
1111: , p5_a29 out nocopy JTF_VARCHAR2_TABLE_2000
1112: , p5_a30 out nocopy JTF_VARCHAR2_TABLE_2000
1113: , p5_a31 out nocopy JTF_VARCHAR2_TABLE_2000
1114: , p5_a32 out nocopy JTF_NUMBER_TABLE
1115: , p5_a33 out nocopy JTF_VARCHAR2_TABLE_200
1108: , p5_a26 out nocopy JTF_NUMBER_TABLE
1109: , p5_a27 out nocopy JTF_NUMBER_TABLE
1110: , p5_a28 out nocopy JTF_VARCHAR2_TABLE_2000
1111: , p5_a29 out nocopy JTF_VARCHAR2_TABLE_2000
1112: , p5_a30 out nocopy JTF_VARCHAR2_TABLE_2000
1113: , p5_a31 out nocopy JTF_VARCHAR2_TABLE_2000
1114: , p5_a32 out nocopy JTF_NUMBER_TABLE
1115: , p5_a33 out nocopy JTF_VARCHAR2_TABLE_200
1116: , p5_a34 out nocopy JTF_NUMBER_TABLE
1109: , p5_a27 out nocopy JTF_NUMBER_TABLE
1110: , p5_a28 out nocopy JTF_VARCHAR2_TABLE_2000
1111: , p5_a29 out nocopy JTF_VARCHAR2_TABLE_2000
1112: , p5_a30 out nocopy JTF_VARCHAR2_TABLE_2000
1113: , p5_a31 out nocopy JTF_VARCHAR2_TABLE_2000
1114: , p5_a32 out nocopy JTF_NUMBER_TABLE
1115: , p5_a33 out nocopy JTF_VARCHAR2_TABLE_200
1116: , p5_a34 out nocopy JTF_NUMBER_TABLE
1117: , p5_a35 out nocopy JTF_NUMBER_TABLE
1114: , p5_a32 out nocopy JTF_NUMBER_TABLE
1115: , p5_a33 out nocopy JTF_VARCHAR2_TABLE_200
1116: , p5_a34 out nocopy JTF_NUMBER_TABLE
1117: , p5_a35 out nocopy JTF_NUMBER_TABLE
1118: , p5_a36 out nocopy JTF_VARCHAR2_TABLE_2000
1119: , p5_a37 out nocopy JTF_NUMBER_TABLE
1120: , p5_a38 out nocopy JTF_NUMBER_TABLE
1121: , p5_a39 out nocopy JTF_NUMBER_TABLE
1122: , p5_a40 out nocopy JTF_VARCHAR2_TABLE_2000
1118: , p5_a36 out nocopy JTF_VARCHAR2_TABLE_2000
1119: , p5_a37 out nocopy JTF_NUMBER_TABLE
1120: , p5_a38 out nocopy JTF_NUMBER_TABLE
1121: , p5_a39 out nocopy JTF_NUMBER_TABLE
1122: , p5_a40 out nocopy JTF_VARCHAR2_TABLE_2000
1123: , p5_a41 out nocopy JTF_NUMBER_TABLE
1124: , p5_a42 out nocopy JTF_VARCHAR2_TABLE_2000
1125: , x_return_status out nocopy VARCHAR2
1126: , x_msg_count out nocopy NUMBER
1120: , p5_a38 out nocopy JTF_NUMBER_TABLE
1121: , p5_a39 out nocopy JTF_NUMBER_TABLE
1122: , p5_a40 out nocopy JTF_VARCHAR2_TABLE_2000
1123: , p5_a41 out nocopy JTF_NUMBER_TABLE
1124: , p5_a42 out nocopy JTF_VARCHAR2_TABLE_2000
1125: , x_return_status out nocopy VARCHAR2
1126: , x_msg_count out nocopy NUMBER
1127: , x_msg_data out nocopy VARCHAR2
1128: );