1: package lns_financials_w as
2: /* $Header: LNS_FINANCIALJ_S.pls 120.7.12010000.3 2009/01/07 13:35:57 gparuchu ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy lns_financials.rate_schedule_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_DATE_TABLE
5: , a2 JTF_DATE_TABLE
1: package lns_financials_w as
2: /* $Header: LNS_FINANCIALJ_S.pls 120.7.12010000.3 2009/01/07 13:35:57 gparuchu ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy lns_financials.rate_schedule_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_DATE_TABLE
5: , a2 JTF_DATE_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 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
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
28: , a2 JTF_DATE_TABLE
29: , a3 JTF_DATE_TABLE
30: , a4 JTF_NUMBER_TABLE
50: , a24 JTF_NUMBER_TABLE
51: , a25 JTF_NUMBER_TABLE
52: , a26 JTF_NUMBER_TABLE
53: );
54: procedure rosetta_table_copy_out_p3(t lns_financials.amortization_tbl, a0 out nocopy JTF_NUMBER_TABLE
55: , a1 out nocopy JTF_DATE_TABLE
56: , a2 out nocopy JTF_DATE_TABLE
57: , a3 out nocopy JTF_DATE_TABLE
58: , a4 out nocopy JTF_NUMBER_TABLE
79: , a25 out nocopy JTF_NUMBER_TABLE
80: , a26 out nocopy JTF_NUMBER_TABLE
81: );
82:
83: procedure rosetta_table_copy_in_p6(t out nocopy lns_financials.payoff_tbl, a0 JTF_NUMBER_TABLE
84: , a1 JTF_NUMBER_TABLE
85: , a2 JTF_NUMBER_TABLE
86: , a3 JTF_NUMBER_TABLE
87: , a4 JTF_NUMBER_TABLE
90: , a7 JTF_NUMBER_TABLE
91: , a8 JTF_NUMBER_TABLE
92: , a9 JTF_DATE_TABLE
93: );
94: procedure rosetta_table_copy_out_p6(t lns_financials.payoff_tbl, a0 out nocopy JTF_NUMBER_TABLE
95: , a1 out nocopy JTF_NUMBER_TABLE
96: , a2 out nocopy JTF_NUMBER_TABLE
97: , a3 out nocopy JTF_NUMBER_TABLE
98: , a4 out nocopy JTF_NUMBER_TABLE
102: , a8 out nocopy JTF_NUMBER_TABLE
103: , a9 out nocopy JTF_DATE_TABLE
104: );
105:
106: procedure rosetta_table_copy_in_p8(t out nocopy lns_financials.payoff_tbl2, a0 JTF_VARCHAR2_TABLE_100
107: , a1 JTF_NUMBER_TABLE
108: , a2 JTF_NUMBER_TABLE
109: , a3 JTF_NUMBER_TABLE
110: );
107: , a1 JTF_NUMBER_TABLE
108: , a2 JTF_NUMBER_TABLE
109: , a3 JTF_NUMBER_TABLE
110: );
111: procedure rosetta_table_copy_out_p8(t lns_financials.payoff_tbl2, a0 out nocopy JTF_VARCHAR2_TABLE_100
112: , a1 out nocopy JTF_NUMBER_TABLE
113: , a2 out nocopy JTF_NUMBER_TABLE
114: , a3 out nocopy JTF_NUMBER_TABLE
115: );
113: , a2 out nocopy JTF_NUMBER_TABLE
114: , a3 out nocopy JTF_NUMBER_TABLE
115: );
116:
117: procedure rosetta_table_copy_in_p10(t out nocopy lns_financials.loan_activity_tbl, a0 JTF_DATE_TABLE
118: , a1 JTF_NUMBER_TABLE
119: , a2 JTF_NUMBER_TABLE
120: , a3 JTF_NUMBER_TABLE
121: );
118: , a1 JTF_NUMBER_TABLE
119: , a2 JTF_NUMBER_TABLE
120: , a3 JTF_NUMBER_TABLE
121: );
122: procedure rosetta_table_copy_out_p10(t lns_financials.loan_activity_tbl, a0 out nocopy JTF_DATE_TABLE
123: , a1 out nocopy JTF_NUMBER_TABLE
124: , a2 out nocopy JTF_NUMBER_TABLE
125: , a3 out nocopy JTF_NUMBER_TABLE
126: );
124: , a2 out nocopy JTF_NUMBER_TABLE
125: , a3 out nocopy JTF_NUMBER_TABLE
126: );
127:
128: procedure rosetta_table_copy_in_p12(t out nocopy lns_financials.payment_schedule_tbl, a0 JTF_DATE_TABLE
129: , a1 JTF_DATE_TABLE
130: );
131: procedure rosetta_table_copy_out_p12(t lns_financials.payment_schedule_tbl, a0 out nocopy JTF_DATE_TABLE
132: , a1 out nocopy JTF_DATE_TABLE
127:
128: procedure rosetta_table_copy_in_p12(t out nocopy lns_financials.payment_schedule_tbl, a0 JTF_DATE_TABLE
129: , a1 JTF_DATE_TABLE
130: );
131: procedure rosetta_table_copy_out_p12(t lns_financials.payment_schedule_tbl, a0 out nocopy JTF_DATE_TABLE
132: , a1 out nocopy JTF_DATE_TABLE
133: );
134:
135: procedure rosetta_table_copy_in_p13(t out nocopy lns_financials.date_tbl, a0 JTF_DATE_TABLE);
131: procedure rosetta_table_copy_out_p12(t lns_financials.payment_schedule_tbl, a0 out nocopy JTF_DATE_TABLE
132: , a1 out nocopy JTF_DATE_TABLE
133: );
134:
135: procedure rosetta_table_copy_in_p13(t out nocopy lns_financials.date_tbl, a0 JTF_DATE_TABLE);
136: procedure rosetta_table_copy_out_p13(t lns_financials.date_tbl, a0 out nocopy JTF_DATE_TABLE);
137:
138: procedure rosetta_table_copy_in_p14(t out nocopy lns_financials.amount_tbl, a0 JTF_NUMBER_TABLE);
139: procedure rosetta_table_copy_out_p14(t lns_financials.amount_tbl, a0 out nocopy JTF_NUMBER_TABLE);
132: , a1 out nocopy JTF_DATE_TABLE
133: );
134:
135: procedure rosetta_table_copy_in_p13(t out nocopy lns_financials.date_tbl, a0 JTF_DATE_TABLE);
136: procedure rosetta_table_copy_out_p13(t lns_financials.date_tbl, a0 out nocopy JTF_DATE_TABLE);
137:
138: procedure rosetta_table_copy_in_p14(t out nocopy lns_financials.amount_tbl, a0 JTF_NUMBER_TABLE);
139: procedure rosetta_table_copy_out_p14(t lns_financials.amount_tbl, a0 out nocopy JTF_NUMBER_TABLE);
140:
134:
135: procedure rosetta_table_copy_in_p13(t out nocopy lns_financials.date_tbl, a0 JTF_DATE_TABLE);
136: procedure rosetta_table_copy_out_p13(t lns_financials.date_tbl, a0 out nocopy JTF_DATE_TABLE);
137:
138: procedure rosetta_table_copy_in_p14(t out nocopy lns_financials.amount_tbl, a0 JTF_NUMBER_TABLE);
139: procedure rosetta_table_copy_out_p14(t lns_financials.amount_tbl, a0 out nocopy JTF_NUMBER_TABLE);
140:
141: procedure rosetta_table_copy_in_p15(t out nocopy lns_financials.vchar_tbl, a0 JTF_VARCHAR2_TABLE_100);
142: procedure rosetta_table_copy_out_p15(t lns_financials.vchar_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100);
135: procedure rosetta_table_copy_in_p13(t out nocopy lns_financials.date_tbl, a0 JTF_DATE_TABLE);
136: procedure rosetta_table_copy_out_p13(t lns_financials.date_tbl, a0 out nocopy JTF_DATE_TABLE);
137:
138: procedure rosetta_table_copy_in_p14(t out nocopy lns_financials.amount_tbl, a0 JTF_NUMBER_TABLE);
139: procedure rosetta_table_copy_out_p14(t lns_financials.amount_tbl, a0 out nocopy JTF_NUMBER_TABLE);
140:
141: procedure rosetta_table_copy_in_p15(t out nocopy lns_financials.vchar_tbl, a0 JTF_VARCHAR2_TABLE_100);
142: procedure rosetta_table_copy_out_p15(t lns_financials.vchar_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100);
143:
137:
138: procedure rosetta_table_copy_in_p14(t out nocopy lns_financials.amount_tbl, a0 JTF_NUMBER_TABLE);
139: procedure rosetta_table_copy_out_p14(t lns_financials.amount_tbl, a0 out nocopy JTF_NUMBER_TABLE);
140:
141: procedure rosetta_table_copy_in_p15(t out nocopy lns_financials.vchar_tbl, a0 JTF_VARCHAR2_TABLE_100);
142: procedure rosetta_table_copy_out_p15(t lns_financials.vchar_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100);
143:
144: procedure rosetta_table_copy_in_p17(t out nocopy lns_financials.fees_tbl, a0 JTF_NUMBER_TABLE
145: , a1 JTF_VARCHAR2_TABLE_100
138: procedure rosetta_table_copy_in_p14(t out nocopy lns_financials.amount_tbl, a0 JTF_NUMBER_TABLE);
139: procedure rosetta_table_copy_out_p14(t lns_financials.amount_tbl, a0 out nocopy JTF_NUMBER_TABLE);
140:
141: procedure rosetta_table_copy_in_p15(t out nocopy lns_financials.vchar_tbl, a0 JTF_VARCHAR2_TABLE_100);
142: procedure rosetta_table_copy_out_p15(t lns_financials.vchar_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100);
143:
144: procedure rosetta_table_copy_in_p17(t out nocopy lns_financials.fees_tbl, a0 JTF_NUMBER_TABLE
145: , a1 JTF_VARCHAR2_TABLE_100
146: , a2 JTF_NUMBER_TABLE
140:
141: procedure rosetta_table_copy_in_p15(t out nocopy lns_financials.vchar_tbl, a0 JTF_VARCHAR2_TABLE_100);
142: procedure rosetta_table_copy_out_p15(t lns_financials.vchar_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100);
143:
144: procedure rosetta_table_copy_in_p17(t out nocopy lns_financials.fees_tbl, a0 JTF_NUMBER_TABLE
145: , a1 JTF_VARCHAR2_TABLE_100
146: , a2 JTF_NUMBER_TABLE
147: , a3 JTF_NUMBER_TABLE
148: , a4 JTF_VARCHAR2_TABLE_300
151: , a7 JTF_NUMBER_TABLE
152: , a8 JTF_VARCHAR2_TABLE_100
153: , a9 JTF_VARCHAR2_TABLE_100
154: );
155: procedure rosetta_table_copy_out_p17(t lns_financials.fees_tbl, a0 out nocopy JTF_NUMBER_TABLE
156: , a1 out nocopy JTF_VARCHAR2_TABLE_100
157: , a2 out nocopy JTF_NUMBER_TABLE
158: , a3 out nocopy JTF_NUMBER_TABLE
159: , a4 out nocopy JTF_VARCHAR2_TABLE_300
1126: , p_num_intervals NUMBER
1127: , p_ending_balance NUMBER
1128: , p_pay_in_arrears number
1129: ) return number;
1130: end lns_financials_w;