1 PACKAGE LNS_AMORTIZATION_SCHEDS_PKG AUTHID CURRENT_USER AS
2 /* $Header: LNS_AMSCH_TBLH_S.pls 120.4 2011/10/25 18:12:45 scherkas ship $ */
3
4 /* Insert_Row procedure */
5 PROCEDURE Insert_Row(
6 X_AMORTIZATION_SCHEDULE_ID IN OUT NOCOPY NUMBER
7 ,P_LOAN_ID IN NUMBER
8 ,P_PAYMENT_NUMBER IN NUMBER DEFAULT NULL
9 ,P_DUE_DATE IN DATE DEFAULT NULL
10 ,P_LATE_DATE IN DATE DEFAULT NULL
11 ,P_PRINCIPAL_AMOUNT IN NUMBER DEFAULT NULL
12 ,P_INTEREST_AMOUNT IN NUMBER DEFAULT NULL
13 ,P_OTHER_AMOUNT IN NUMBER DEFAULT NULL
14 ,P_REVERSED_FLAG IN VARCHAR2 DEFAULT NULL
15 ,P_REVERSED_DATE IN DATE DEFAULT NULL
16 ,P_RATE_ID IN NUMBER DEFAULT NULL
17 ,P_CREATED_BY IN NUMBER DEFAULT NULL
18 ,P_CREATION_DATE IN DATE DEFAULT NULL
19 ,P_LAST_UPDATED_BY IN NUMBER DEFAULT NULL
20 ,P_LAST_UPDATE_DATE IN DATE DEFAULT NULL
21 ,P_LAST_UPDATE_LOGIN IN NUMBER DEFAULT NULL
22 ,P_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT NULL
23 ,P_ATTRIBUTE1 IN VARCHAR2 DEFAULT NULL
24 ,P_ATTRIBUTE2 IN VARCHAR2 DEFAULT NULL
25 ,P_ATTRIBUTE3 IN VARCHAR2 DEFAULT NULL
26 ,P_ATTRIBUTE4 IN VARCHAR2 DEFAULT NULL
27 ,P_ATTRIBUTE5 IN VARCHAR2 DEFAULT NULL
28 ,P_ATTRIBUTE6 IN VARCHAR2 DEFAULT NULL
29 ,P_ATTRIBUTE7 IN VARCHAR2 DEFAULT NULL
30 ,P_ATTRIBUTE8 IN VARCHAR2 DEFAULT NULL
31 ,P_ATTRIBUTE9 IN VARCHAR2 DEFAULT NULL
32 ,P_ATTRIBUTE10 IN VARCHAR2 DEFAULT NULL
33 ,P_ATTRIBUTE11 IN VARCHAR2 DEFAULT NULL
34 ,P_ATTRIBUTE12 IN VARCHAR2 DEFAULT NULL
35 ,P_ATTRIBUTE13 IN VARCHAR2 DEFAULT NULL
36 ,P_ATTRIBUTE14 IN VARCHAR2 DEFAULT NULL
37 ,P_ATTRIBUTE15 IN VARCHAR2 DEFAULT NULL
38 ,P_ATTRIBUTE16 IN VARCHAR2 DEFAULT NULL
39 ,P_ATTRIBUTE17 IN VARCHAR2 DEFAULT NULL
40 ,P_ATTRIBUTE18 IN VARCHAR2 DEFAULT NULL
41 ,P_ATTRIBUTE19 IN VARCHAR2 DEFAULT NULL
42 ,P_ATTRIBUTE20 IN VARCHAR2 DEFAULT NULL
43 ,P_OBJECT_VERSION_NUMBER IN NUMBER
44 ,P_PARENT_AMORTIZATION_ID IN NUMBER DEFAULT NULL
45 ,P_REAMORTIZATION_AMOUNT IN NUMBER DEFAULT NULL
46 ,P_REAMORTIZE_FROM_INSTALLMENT IN NUMBER DEFAULT NULL
47 ,P_REAMORTIZE_TO_INSTALLMENT IN NUMBER DEFAULT NULL
48 ,P_FEE_AMOUNT IN NUMBER DEFAULT NULL
49 ,P_PRINCIPAL_TRX_ID IN NUMBER DEFAULT NULL
50 ,P_INTEREST_TRX_ID IN NUMBER DEFAULT NULL
51 ,P_FEE_TRX_ID IN NUMBER DEFAULT NULL
52 ,P_STATEMENT_XML IN CLOB DEFAULT NULL
53 ,P_PRINCIPAL_BALANCE IN NUMBER DEFAULT NULL
54 ,P_PHASE IN VARCHAR2 DEFAULT NULL
55 ,P_FUNDED_AMOUNT IN NUMBER DEFAULT NULL
56 ,P_DEFERRED_INT_AMOUNT IN NUMBER DEFAULT NULL
57 ,P_CAP_INT_AMOUNT IN NUMBER DEFAULT NULL
58 ,P_CURR_CAP_INT_AMOUNT IN NUMBER DEFAULT NULL
59 );
60
61 /* Update_Row procedure */
62 PROCEDURE Update_Row(
63 P_AMORTIZATION_SCHEDULE_ID IN NUMBER
64 ,P_LOAN_ID IN NUMBER DEFAULT NULL
65 ,P_PAYMENT_NUMBER IN NUMBER DEFAULT NULL
66 ,P_DUE_DATE IN DATE DEFAULT NULL
67 ,P_LATE_DATE IN DATE DEFAULT NULL
68 ,P_PRINCIPAL_AMOUNT IN NUMBER DEFAULT NULL
69 ,P_INTEREST_AMOUNT IN NUMBER DEFAULT NULL
70 ,P_OTHER_AMOUNT IN NUMBER DEFAULT NULL
71 ,P_REVERSED_FLAG IN VARCHAR2 DEFAULT NULL
72 ,P_REVERSED_DATE IN DATE DEFAULT NULL
73 ,P_RATE_ID IN NUMBER DEFAULT NULL
74 ,P_LAST_UPDATED_BY IN NUMBER DEFAULT NULL
75 ,P_LAST_UPDATE_DATE IN DATE DEFAULT NULL
76 ,P_LAST_UPDATE_LOGIN IN NUMBER DEFAULT NULL
77 ,P_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT NULL
78 ,P_ATTRIBUTE1 IN VARCHAR2 DEFAULT NULL
79 ,P_ATTRIBUTE2 IN VARCHAR2 DEFAULT NULL
80 ,P_ATTRIBUTE3 IN VARCHAR2 DEFAULT NULL
81 ,P_ATTRIBUTE4 IN VARCHAR2 DEFAULT NULL
82 ,P_ATTRIBUTE5 IN VARCHAR2 DEFAULT NULL
83 ,P_ATTRIBUTE6 IN VARCHAR2 DEFAULT NULL
84 ,P_ATTRIBUTE7 IN VARCHAR2 DEFAULT NULL
85 ,P_ATTRIBUTE8 IN VARCHAR2 DEFAULT NULL
86 ,P_ATTRIBUTE9 IN VARCHAR2 DEFAULT NULL
87 ,P_ATTRIBUTE10 IN VARCHAR2 DEFAULT NULL
88 ,P_ATTRIBUTE11 IN VARCHAR2 DEFAULT NULL
89 ,P_ATTRIBUTE12 IN VARCHAR2 DEFAULT NULL
90 ,P_ATTRIBUTE13 IN VARCHAR2 DEFAULT NULL
91 ,P_ATTRIBUTE14 IN VARCHAR2 DEFAULT NULL
92 ,P_ATTRIBUTE15 IN VARCHAR2 DEFAULT NULL
93 ,P_ATTRIBUTE16 IN VARCHAR2 DEFAULT NULL
94 ,P_ATTRIBUTE17 IN VARCHAR2 DEFAULT NULL
95 ,P_ATTRIBUTE18 IN VARCHAR2 DEFAULT NULL
96 ,P_ATTRIBUTE19 IN VARCHAR2 DEFAULT NULL
97 ,P_ATTRIBUTE20 IN VARCHAR2 DEFAULT NULL
98 ,P_OBJECT_VERSION_NUMBER IN NUMBER DEFAULT NULL
99 ,P_PARENT_AMORTIZATION_ID IN NUMBER DEFAULT NULL
100 ,P_REAMORTIZATION_AMOUNT IN NUMBER DEFAULT NULL
101 ,P_REAMORTIZE_FROM_INSTALLMENT IN NUMBER DEFAULT NULL
102 ,P_REAMORTIZE_TO_INSTALLMENT IN NUMBER DEFAULT NULL
103 ,P_FEE_AMOUNT IN NUMBER DEFAULT NULL
104 ,P_PRINCIPAL_TRX_ID IN NUMBER DEFAULT NULL
105 ,P_INTEREST_TRX_ID IN NUMBER DEFAULT NULL
106 ,P_FEE_TRX_ID IN NUMBER DEFAULT NULL
107 ,P_PRINCIPAL_BALANCE IN NUMBER DEFAULT NULL
108 ,P_PHASE IN VARCHAR2 DEFAULT NULL
109 ,P_FUNDED_AMOUNT IN NUMBER DEFAULT NULL
110 ,P_DEFERRED_INT_AMOUNT IN NUMBER DEFAULT NULL
111 ,P_CAP_INT_AMOUNT IN NUMBER DEFAULT NULL
112 ,P_CURR_CAP_INT_AMOUNT IN NUMBER DEFAULT NULL
113 );
114
115 /* Update_Statement procedure */
116 PROCEDURE Update_Statement(
117 P_AMORTIZATION_SCHEDULE_ID IN NUMBER
118 ,P_STATEMENT_XML IN CLOB
119 );
120
121 /* Delete_Row procedure */
122 PROCEDURE Delete_Row(P_AMORTIZATION_SCHEDULE_ID IN NUMBER);
123
124 /* Lock_Row procedure */
125 PROCEDURE Lock_Row(
126 P_AMORTIZATION_SCHEDULE_ID IN NUMBER
127 ,P_LOAN_ID IN NUMBER DEFAULT NULL
128 ,P_PAYMENT_NUMBER IN NUMBER DEFAULT NULL
129 ,P_DUE_DATE IN DATE DEFAULT NULL
130 ,P_LATE_DATE IN DATE DEFAULT NULL
131 ,P_PRINCIPAL_AMOUNT IN NUMBER DEFAULT NULL
132 ,P_INTEREST_AMOUNT IN NUMBER DEFAULT NULL
133 ,P_OTHER_AMOUNT IN NUMBER DEFAULT NULL
134 ,P_REVERSED_FLAG IN VARCHAR2 DEFAULT NULL
135 ,P_REVERSED_DATE IN DATE DEFAULT NULL
136 ,P_RATE_ID IN NUMBER DEFAULT NULL
137 ,P_CREATED_BY IN NUMBER DEFAULT NULL
138 ,P_CREATION_DATE IN DATE DEFAULT NULL
139 ,P_LAST_UPDATED_BY IN NUMBER DEFAULT NULL
140 ,P_LAST_UPDATE_DATE IN DATE DEFAULT NULL
141 ,P_LAST_UPDATE_LOGIN IN NUMBER DEFAULT NULL
142 ,P_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT NULL
143 ,P_ATTRIBUTE1 IN VARCHAR2 DEFAULT NULL
144 ,P_ATTRIBUTE2 IN VARCHAR2 DEFAULT NULL
145 ,P_ATTRIBUTE3 IN VARCHAR2 DEFAULT NULL
146 ,P_ATTRIBUTE4 IN VARCHAR2 DEFAULT NULL
147 ,P_ATTRIBUTE5 IN VARCHAR2 DEFAULT NULL
148 ,P_ATTRIBUTE6 IN VARCHAR2 DEFAULT NULL
149 ,P_ATTRIBUTE7 IN VARCHAR2 DEFAULT NULL
150 ,P_ATTRIBUTE8 IN VARCHAR2 DEFAULT NULL
151 ,P_ATTRIBUTE9 IN VARCHAR2 DEFAULT NULL
152 ,P_ATTRIBUTE10 IN VARCHAR2 DEFAULT NULL
153 ,P_ATTRIBUTE11 IN VARCHAR2 DEFAULT NULL
154 ,P_ATTRIBUTE12 IN VARCHAR2 DEFAULT NULL
155 ,P_ATTRIBUTE13 IN VARCHAR2 DEFAULT NULL
156 ,P_ATTRIBUTE14 IN VARCHAR2 DEFAULT NULL
157 ,P_ATTRIBUTE15 IN VARCHAR2 DEFAULT NULL
158 ,P_ATTRIBUTE16 IN VARCHAR2 DEFAULT NULL
159 ,P_ATTRIBUTE17 IN VARCHAR2 DEFAULT NULL
160 ,P_ATTRIBUTE18 IN VARCHAR2 DEFAULT NULL
161 ,P_ATTRIBUTE19 IN VARCHAR2 DEFAULT NULL
162 ,P_ATTRIBUTE20 IN VARCHAR2 DEFAULT NULL
163 ,P_OBJECT_VERSION_NUMBER IN NUMBER DEFAULT NULL
164 ,P_PARENT_AMORTIZATION_ID IN NUMBER DEFAULT NULL
165 ,P_REAMORTIZATION_AMOUNT IN NUMBER DEFAULT NULL
166 ,P_REAMORTIZE_FROM_INSTALLMENT IN NUMBER DEFAULT NULL
167 ,P_REAMORTIZE_TO_INSTALLMENT IN NUMBER DEFAULT NULL
168 ,P_FEE_AMOUNT IN NUMBER DEFAULT NULL
169 ,P_PRINCIPAL_TRX_ID IN NUMBER DEFAULT NULL
170 ,P_INTEREST_TRX_ID IN NUMBER DEFAULT NULL
171 ,P_FEE_TRX_ID IN NUMBER DEFAULT NULL
172 ,P_STATEMENT_XML IN CLOB DEFAULT NULL
173 ,P_PRINCIPAL_BALANCE IN NUMBER DEFAULT NULL
174 ,P_PHASE IN VARCHAR2 DEFAULT NULL
175 ,P_FUNDED_AMOUNT IN NUMBER DEFAULT NULL
176 ,P_DEFERRED_INT_AMOUNT IN NUMBER DEFAULT NULL
177 ,P_CAP_INT_AMOUNT IN NUMBER DEFAULT NULL
178 ,P_CURR_CAP_INT_AMOUNT IN NUMBER DEFAULT NULL
179 );
180 END;
181
[Home] [Help]