1 PACKAGE LNS_BILLING_UTIL_PUB AUTHID CURRENT_USER AS
2 /* $Header: LNS_BILL_UTIL_S.pls 120.3 2006/02/07 13:15:12 scherkas noship $ */
3
4
5 /*========================================================================
6 | PUBLIC FUNCTION AMOUNT_PAID_YTD
7 |
8 | DESCRIPTION
9 | This procedure calculates next payment due.
10 |
11 | PSEUDO CODE/LOGIC
12 |
13 | PARAMETERS
14 | P_LOAN_ID IN Amount paid for Loan ID
15 | P_LINE_TYPE IN Amount paid for this line type
16 |
17 | KNOWN ISSUES
18 | None
19 |
20 | NOTES
21 |
22 | MODIFICATION HISTORY
23 | Date Author Description of Changes
24 | 30-12-2003 scherkas Created
25 |
26 *=======================================================================*/
27 FUNCTION AMOUNT_PAID_YTD(P_LOAN_ID IN NUMBER, P_LINE_TYPE VARCHAR2) RETURN NUMBER;
28
29
30
31 /*========================================================================
32 | PUBLIC FUNCTION NEXT_PAYMENT_DUE
33 |
34 | DESCRIPTION
35 | This procedure calculates amount paid YTD.
36 |
37 | PSEUDO CODE/LOGIC
38 |
39 | PARAMETERS
40 | P_LOAN_ID IN Last payment number for Loan ID
41 | P_LINE_TYPE Amount due for this line type
42 | P_PAYMENT_NUMBER Amount due for this payment number
43 |
44 | KNOWN ISSUES
45 | None
46 |
47 | NOTES
48 |
49 | MODIFICATION HISTORY
50 | Date Author Description of Changes
51 | 30-12-2003 scherkas Created
52 |
53 *=======================================================================*/
54 FUNCTION NEXT_PAYMENT_DUE(P_LOAN_ID IN NUMBER, P_LINE_TYPE IN VARCHAR2, P_PAYMENT_NUMBER IN NUMBER) RETURN NUMBER;
55
56
57
58 /*========================================================================
59 | PUBLIC FUNCTION AMOUNT_PAID_LAST_YEAR
60 |
61 | DESCRIPTION
62 | This procedure calculates principal paid last year.
63 |
64 | PSEUDO CODE/LOGIC
65 |
66 | PARAMETERS
67 | P_LOAN_ID IN Amount paid for Loan ID
68 | P_LINE_TYPE IN Amount paid for this line type
69 |
70 | KNOWN ISSUES
71 | None
72 |
73 | NOTES
74 |
75 | MODIFICATION HISTORY
76 | Date Author Description of Changes
77 | 30-12-2003 scherkas Created
78 |
79 *=======================================================================*/
80 FUNCTION AMOUNT_PAID_LAST_YEAR(P_LOAN_ID IN NUMBER, P_LINE_TYPE VARCHAR2) RETURN NUMBER;
81
82
83
84 /*========================================================================
85 | PUBLIC FUNCTION LAST_PAYMENT_NUMBER
86 |
87 | DESCRIPTION
88 | This procedure calculates last payment number.
89 |
90 | PSEUDO CODE/LOGIC
91 |
92 | PARAMETERS
93 | P_LOAN_ID IN Last payment number for Loan ID
94 |
95 | KNOWN ISSUES
96 | None
97 |
98 | NOTES
99 |
100 | MODIFICATION HISTORY
101 | Date Author Description of Changes
102 | 30-12-2003 scherkas Created
103 |
104 *=======================================================================*/
105 FUNCTION LAST_PAYMENT_NUMBER(P_LOAN_ID IN NUMBER) RETURN NUMBER;
106
107
108
109
110 /*========================================================================
111 | PUBLIC FUNCTION LAST_PAYMENT_NUMBER
112 |
113 | DESCRIPTION
114 | This procedure calculates last payment number.
115 |
116 | PSEUDO CODE/LOGIC
117 |
118 | PARAMETERS
119 | P_LOAN_ID IN Last payment number for Loan ID
120 | P_PHASE IN Phase
121 |
122 | KNOWN ISSUES
123 | None
124 |
125 | NOTES
126 | Any interesting aspect of the code in the package body which needs
127 | to be stated.
128 |
129 | MODIFICATION HISTORY
130 | Date Author Description of Changes
131 | 01-01-2004 scherkas Created
132 |
133 *=======================================================================*/
134 FUNCTION LAST_PAYMENT_NUMBER(P_LOAN_ID IN NUMBER, P_PHASE IN VARCHAR2) RETURN NUMBER;
135
136
137
138 /*========================================================================
139 | PUBLIC FUNCTION LAST_PAYMENT_NUMBER_EXT
140 |
141 | DESCRIPTION
142 | This procedure calculates last payment number taking in consideration 0-th installment
143 |
144 | PSEUDO CODE/LOGIC
145 |
146 | PARAMETERS
147 | P_LOAN_ID IN Last payment number for Loan ID
148 |
149 | KNOWN ISSUES
150 | None
151 |
152 | NOTES
153 |
154 | MODIFICATION HISTORY
155 | Date Author Description of Changes
156 | 30-12-2003 scherkas Created
157 |
158 *=======================================================================*/
159 FUNCTION LAST_PAYMENT_NUMBER_EXT(P_LOAN_ID IN NUMBER) RETURN NUMBER;
160
161
162
163
164 /*========================================================================
165 | PUBLIC FUNCTION LAST_AMORTIZATION_SCHED
166 |
167 | DESCRIPTION
168 | This procedure returns last amortization schedule id.
169 |
170 | PSEUDO CODE/LOGIC
171 |
172 | PARAMETERS
173 | P_LOAN_ID IN Last payment number for Loan ID
174 |
175 | KNOWN ISSUES
176 | None
177 |
178 | NOTES
179 |
180 | MODIFICATION HISTORY
181 | Date Author Description of Changes
182 | 30-12-2003 scherkas Created
183 |
184 *=======================================================================*/
185 FUNCTION LAST_AMORTIZATION_SCHED(P_LOAN_ID IN NUMBER) RETURN NUMBER;
186
187
188
189
190 /*========================================================================
191 | PUBLIC FUNCTION AMOUNT_OVERDUE
192 |
193 | DESCRIPTION
194 | This procedure calculates amount overdue.
195 |
196 | PSEUDO CODE/LOGIC
197 |
198 | PARAMETERS
199 | P_LOAN_ID IN Amount paid for Loan ID
200 | P_LINE_TYPE IN Amount paid for this line type
201 |
202 | KNOWN ISSUES
203 | None
204 |
205 | NOTES
206 |
207 | MODIFICATION HISTORY
208 | Date Author Description of Changes
209 | 30-12-2003 scherkas Created
210 |
211 *=======================================================================*/
212 FUNCTION AMOUNT_OVERDUE(P_LOAN_ID IN NUMBER, P_LINE_TYPE VARCHAR2) RETURN NUMBER;
213
214
215
216 /*========================================================================
217 | PUBLIC FUNCTION NUMBER_OVERDUE_BILLS
218 |
219 | DESCRIPTION
220 | This procedure calculates number of overdue bills.
221 |
222 | PSEUDO CODE/LOGIC
223 |
224 | PARAMETERS
225 | P_LOAN_ID IN Amount paid for Loan ID
226 |
227 | KNOWN ISSUES
228 | None
229 |
230 | NOTES
231 | Any interesting aspect of the code in the package body which needs
232 | to be stated.
233 |
234 | MODIFICATION HISTORY
235 | Date Author Description of Changes
236 | 01-01-2004 scherkas Created
237 |
238 *=======================================================================*/
239 FUNCTION NUMBER_OVERDUE_BILLS(P_LOAN_ID IN NUMBER) RETURN NUMBER;
240
241
242
243 /*========================================================================
244 | PUBLIC FUNCTION LAST_OVERDUE_DATE
245 |
246 | DESCRIPTION
247 | This procedure gets last overdue date.
248 |
249 | PSEUDO CODE/LOGIC
250 |
251 | PARAMETERS
252 | P_LOAN_ID IN Loan ID
253 |
254 | KNOWN ISSUES
255 | None
256 |
257 | NOTES
258 | Any interesting aspect of the code in the package body which needs
259 | to be stated.
260 |
261 | MODIFICATION HISTORY
262 | Date Author Description of Changes
263 | 01-01-2004 scherkas Created
264 |
265 *=======================================================================*/
266 FUNCTION LAST_OVERDUE_DATE(P_LOAN_ID IN NUMBER) RETURN DATE;
267
268
269
270 /*========================================================================
271 | PUBLIC FUNCTION OLDEST_OVERDUE_DATE
272 |
273 | DESCRIPTION
274 | This procedure gets oldest overdue date.
275 |
276 | PSEUDO CODE/LOGIC
277 |
278 | PARAMETERS
279 | P_LOAN_ID IN Loan ID
280 |
281 | KNOWN ISSUES
282 | None
283 |
284 | NOTES
285 | Any interesting aspect of the code in the package body which needs
286 | to be stated.
287 |
288 | MODIFICATION HISTORY
289 | Date Author Description of Changes
290 | 01-01-2004 scherkas Created
291 |
292 *=======================================================================*/
293 FUNCTION OLDEST_OVERDUE_DATE(P_LOAN_ID IN NUMBER) RETURN DATE;
294
295
296
297 /*========================================================================
298 | PUBLIC FUNCTION LAST_PAYMENT_AMOUNT
299 |
300 | DESCRIPTION
301 | This procedure gets last payment amount.
302 |
303 | PSEUDO CODE/LOGIC
304 |
305 | PARAMETERS
306 | P_LOAN_ID IN Amount for Loan ID
307 |
308 | KNOWN ISSUES
309 | None
310 |
311 | NOTES
312 | Any interesting aspect of the code in the package body which needs
313 | to be stated.
314 |
315 | MODIFICATION HISTORY
316 | Date Author Description of Changes
317 | 01-01-2004 scherkas Created
318 |
319 *=======================================================================*/
320 FUNCTION LAST_PAYMENT_AMOUNT(P_LOAN_ID IN NUMBER) RETURN NUMBER;
321
322
323
324 /*========================================================================
325 | PUBLIC FUNCTION LAST_PAYMENT_DATE
326 |
327 | DESCRIPTION
328 | This procedure gets last payment date.
329 |
330 | PSEUDO CODE/LOGIC
331 |
332 | PARAMETERS
333 | P_LOAN_ID IN Amount for Loan ID
334 |
335 | KNOWN ISSUES
336 | None
337 |
338 | NOTES
339 | Any interesting aspect of the code in the package body which needs
340 | to be stated.
341 |
342 | MODIFICATION HISTORY
343 | Date Author Description of Changes
344 | 01-01-2004 scherkas Created
345 |
346 *=======================================================================*/
347 FUNCTION LAST_PAYMENT_DATE(P_LOAN_ID IN NUMBER) RETURN DATE;
348
349
350
351 /*========================================================================
352 | PUBLIC FUNCTION BALANCE_BY_ACT_DATE
353 |
354 | DESCRIPTION
355 | This procedure returns loan balance by date.
356 |
357 | PSEUDO CODE/LOGIC
358 |
359 | PARAMETERS
360 | P_LOAN_ID IN Loan ID
361 | P_DATE IN Date
362 |
363 | KNOWN ISSUES
364 | None
365 |
366 | NOTES
367 | Any interesting aspect of the code in the package body which needs
368 | to be stated.
369 |
370 | MODIFICATION HISTORY
371 | Date Author Description of Changes
372 | 02-01-2006 scherkas Created
373 |
374 *=======================================================================*/
375 FUNCTION LOAN_BALANCE_BY_DATE(P_LOAN_ID IN NUMBER, P_DATE IN DATE) RETURN NUMBER;
376
377
378 END LNS_BILLING_UTIL_PUB; -- Package spec