1 PACKAGE LNS_BILLING_BATCH_PUB AUTHID CURRENT_USER as
2 /* $Header: LNS_BILLING_S.pls 120.4.12010000.2 2008/11/20 14:18:13 scherkas ship $ */
3
4 /*=======================================================================+
5 | Declare PUBLIC Data Types and Variables
6 +=======================================================================*/
7
8 TYPE LOAN_TO_BILL_REC IS RECORD(
9 LOAN_ID NUMBER,
10 OBJECT_VERSION_NUMBER NUMBER,
11 LOAN_NUMBER VARCHAR2(60),
12 LOAN_DESCRIPTION VARCHAR2(250),
13 FUNDED_AMOUNT NUMBER,
14 FIRST_PAYMENT_DATE DATE,
15 NEXT_PAYMENT_DUE_DATE DATE,
16 NEXT_PAYMENT_LATE_DATE DATE,
17 BILLED_FLAG VARCHAR2(1),
18 LOAN_CURRENCY VARCHAR2(15),
19 CUST_ACCOUNT_ID NUMBER,
20 BILL_TO_ADDRESS_ID NUMBER,
21 LOAN_PAYMENT_FREQUENCY VARCHAR2(30),
22 NUMBER_GRACE_DAYS NUMBER,
23 PAYMENT_APPLICATION_ORDER VARCHAR2(30),
24 CUSTOM_PAYMENTS_FLAG VARCHAR2(1),
25 LAST_PAYMENT_NUMBER NUMBER,
26 NEXT_PAYMENT_NUMBER NUMBER,
27 NEXT_PRINCIPAL_AMOUNT NUMBER,
28 NEXT_INTEREST_AMOUNT NUMBER,
29 NEXT_FEE_AMOUNT NUMBER,
30 NEXT_AMORTIZATION_ID NUMBER,
31 RATE_ID NUMBER,
32 PARENT_AMORTIZATION_ID NUMBER,
33 EXCHANGE_RATE_TYPE VARCHAR2(30),
34 EXCHANGE_DATE DATE,
35 EXCHANGE_RATE NUMBER,
36 ORG_ID NUMBER,
37 LEGAL_ENTITY_ID NUMBER,
38 CURRENT_PHASE VARCHAR2(30),
39 FORGIVENESS_FLAG VARCHAR2(1),
40 FORGIVENESS_PERCENT NUMBER
41 );
42 TYPE LOANS_TO_BILL_TBL IS TABLE OF LOAN_TO_BILL_REC INDEX BY BINARY_INTEGER;
43
44 TYPE LOAN_NEXT_DD_REC IS RECORD(
45 LOAN_ID NUMBER,
46 LOAN_NUMBER VARCHAR2(60),
47 OBJECT_VERSION_NUMBER NUMBER,
48 NEXT_PAYMENT_NUMBER NUMBER,
49 CUSTOM_PAYMENTS_FLAG VARCHAR2(1)
50 );
51
52 TYPE REVERSE_REC IS RECORD(
53 TRX_NUMBER VARCHAR2(20),
54 CUSTOMER_TRX_ID NUMBER,
55 PAYMENT_SCHEDULE_ID NUMBER,
56 CUSTOMER_TRX_LINE_ID NUMBER,
57 LINE_TYPE VARCHAR2(30),
58 TRX_AMOUNT NUMBER,
59 APPLIED_AMOUNT NUMBER,
60 ORG_ID NUMBER
61 );
62 TYPE REVERSE_TBL IS TABLE OF REVERSE_REC INDEX BY BINARY_INTEGER;
63
64 TYPE BILL_HEADER_REC IS RECORD(
65 HEADER_ID NUMBER,
66 LOAN_ID NUMBER,
67 ASSOC_PAYMENT_NUM NUMBER,
68 DUE_DATE DATE
69 );
70 TYPE BILL_HEADERS_TBL IS TABLE OF BILL_HEADER_REC INDEX BY BINARY_INTEGER;
71
72 TYPE BILL_LINE_REC IS RECORD(
73 HEADER_ID NUMBER,
74 LINE_ID NUMBER,
75 CUSTOMER_TRX_ID NUMBER,
76 PAYMENT_SCHEDULE_ID NUMBER,
77 CUSTOMER_TRX_LINE_ID NUMBER,
78 LINE_REF_ID NUMBER,
79 LINE_AMOUNT NUMBER,
80 LINE_TYPE VARCHAR2(30),
81 LINE_DESC VARCHAR2(240),
82 CASH_RECEIPT_ID NUMBER,
83 APPLY_AMOUNT NUMBER,
84 PAYMENT_ORDER NUMBER,
85 FEE_SCHEDULE_ID NUMBER
86 );
87 TYPE BILL_LINES_TBL IS TABLE OF BILL_LINE_REC INDEX BY BINARY_INTEGER;
88
89
90 /*========================================================================
91 | PUBLIC PROCEDURE LNS_BILLING_CONCUR
92 |
93 | DESCRIPTION
94 | This procedure gets called from CM to start billing engine.
95 |
96 | PSEUDO CODE/LOGIC
97 |
98 | PARAMETERS
99 | ERRBUF OUT Returns errors to CM
100 | RETCODE OUT Returns error code to CM
101 | BORROWER_ID IN Inputs borrower id
102 | LOAN_ID IN Inputs loan
103 | FROM_DAYS_TO_DD IN Inputs from days
104 | TO_DAYS_TO_DD IN Inputs to days
105 |
106 | KNOWN ISSUES
107 | None
108 |
109 | NOTES
110 |
111 | MODIFICATION HISTORY
112 | Date Author Description of Changes
113 | 30-12-2003 scherkas Created
114 |
115 *=======================================================================*/
116 PROCEDURE LNS_BILLING_CONCUR(
117 ERRBUF OUT NOCOPY VARCHAR2,
118 RETCODE OUT NOCOPY VARCHAR2,
119 BORROWER_ID IN NUMBER,
120 LOAN_ID IN NUMBER,
121 FROM_DAYS_TO_DD IN NUMBER,
122 TO_DAYS_TO_DD IN NUMBER);
123
124
125 /*========================================================================
126 | PUBLIC PROCEDURE LNS_RVRS_PMT_CONCUR
127 |
128 | DESCRIPTION
129 | This procedure gets called from CM to start reversal engine.
130 |
131 | PSEUDO CODE/LOGIC
132 |
133 | PARAMETERS
134 | ERRBUF OUT Returns errors to CM
135 | RETCODE OUT Returns error code to CM
136 | LOAN_ID IN Inputs loan
137 | REBILL_FLAG IN Inputs rebill flag
138 |
139 | KNOWN ISSUES
140 | None
141 |
142 | NOTES
143 |
144 | MODIFICATION HISTORY
145 | Date Author Description of Changes
146 | 30-12-2003 scherkas Created
147 |
148 *=======================================================================*/
149 PROCEDURE LNS_RVRS_PMT_CONCUR(
150 ERRBUF OUT NOCOPY VARCHAR2,
151 RETCODE OUT NOCOPY VARCHAR2,
152 LOAN_ID IN NUMBER,
153 REBILL_FLAG IN VARCHAR2);
154
155
156
157 /*========================================================================
158 | PUBLIC PROCEDURE LNS_ADJUST_RECEIV_CONCUR
159 |
160 | DESCRIPTION
161 | This procedure got called from concurent manager to adjust original receivables for a loan
162 |
163 | PSEUDO CODE/LOGIC
164 |
165 | PARAMETERS
166 | ERRBUF OUT Returns errors to CM
167 | RETCODE OUT Returns error code to CM
168 | LOAN_ID IN Inputs loan
169 |
170 | KNOWN ISSUES
171 | None
172 |
173 | NOTES
174 | Any interesting aspect of the code in the package body which needs
175 | to be stated.
176 |
177 | MODIFICATION HISTORY
178 | Date Author Description of Changes
179 | 01-01-2004 scherkas Created
180 |
181 *=======================================================================*/
182 PROCEDURE LNS_ADJUST_RECEIV_CONCUR(
183 ERRBUF OUT NOCOPY VARCHAR2,
184 RETCODE OUT NOCOPY VARCHAR2,
185 LOAN_ID IN NUMBER);
186
187
188
189 /*========================================================================
190 | PUBLIC PROCEDURE BILL_LOANS
191 |
192 | DESCRIPTION
193 | This procedure searches for loans to bill and process them one by one.
194 |
195 | PSEUDO CODE/LOGIC
196 |
197 | PARAMETERS
198 | P_API_VERSION IN Standard in parameter
199 | P_INIT_MSG_LIST IN Standard in parameter
200 | P_COMMIT IN Standard in parameter
201 | P_VALIDATION_LEVEL IN Standard in parameter
202 | P_BORROWER_ID IN Inputs borrower id
203 | P_LOAN_ID IN Inputs loan id
204 | P_FROM_DAYS_TO_DD IN Inputs from days
205 | P_TO_DAYS_TO_DD IN Inputs to days
206 | X_RETURN_STATUS OUT NOCOPY Standard out parameter
207 | X_MSG_COUNT OUT NOCOPY Standard out parameter
208 | X_MSG_DATA OUT NOCOPY Standard out parameter
209 |
210 | KNOWN ISSUES
211 | None
212 |
213 | NOTES
214 |
215 | MODIFICATION HISTORY
216 | Date Author Description of Changes
217 | 30-12-2003 scherkas Created
218 |
219 *=======================================================================*/
220 PROCEDURE BILL_LOANS(
221 P_API_VERSION IN NUMBER,
222 P_INIT_MSG_LIST IN VARCHAR2,
223 P_COMMIT IN VARCHAR2,
224 P_VALIDATION_LEVEL IN NUMBER,
225 P_BORROWER_ID IN NUMBER,
226 P_LOAN_ID IN NUMBER,
227 P_FROM_DAYS_TO_DD IN NUMBER,
228 P_TO_DAYS_TO_DD IN NUMBER,
229 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
230 X_MSG_COUNT OUT NOCOPY NUMBER,
231 X_MSG_DATA OUT NOCOPY VARCHAR2);
232
233
234
235 /*========================================================================
236 | PUBLIC PROCEDURE CALC_PAST_DUE_LOANS_NEXT_DD
237 |
238 | DESCRIPTION
239 | This procedure searches for overdue loans and recalc new due days.
240 |
241 | PSEUDO CODE/LOGIC
242 |
243 | PARAMETERS
244 | P_API_VERSION IN Standard in parameter
245 | P_INIT_MSG_LIST IN Standard in parameter
246 | P_COMMIT IN Standard in parameter
247 | P_VALIDATION_LEVEL IN Standard in parameter
248 | X_RETURN_STATUS OUT NOCOPY Standard out parameter
249 | X_MSG_COUNT OUT NOCOPY Standard out parameter
250 | X_MSG_DATA OUT NOCOPY Standard out parameter
251 |
252 | KNOWN ISSUES
253 | None
254 |
255 | NOTES
256 |
257 | MODIFICATION HISTORY
258 | Date Author Description of Changes
259 | 30-12-2003 scherkas Created
260 |
261 *=======================================================================*/
262 PROCEDURE CALC_PAST_DUE_LOANS_NEXT_DD(
263 P_API_VERSION IN NUMBER,
264 P_INIT_MSG_LIST IN VARCHAR2,
265 P_COMMIT IN VARCHAR2,
266 P_VALIDATION_LEVEL IN NUMBER,
267 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
268 X_MSG_COUNT OUT NOCOPY NUMBER,
269 X_MSG_DATA OUT NOCOPY VARCHAR2);
270
271
272
273 /*========================================================================
274 | PUBLIC PROCEDURE REVERSE_LAST_AMORTIZATION
275 |
276 | DESCRIPTION
277 | This procedure searches and reverses last loans amortization.
278 |
279 | PSEUDO CODE/LOGIC
280 |
281 | PARAMETERS
282 | P_API_VERSION IN Standard in parameter
283 | P_INIT_MSG_LIST IN Standard in parameter
284 | P_COMMIT IN Standard in parameter
285 | P_VALIDATION_LEVEL IN Standard in parameter
286 | P_LOAN_ID IN Inputs loan id
287 | P_REBILL_FLAG IN Inputs rebill flag
288 | X_RETURN_STATUS OUT NOCOPY Standard out parameter
289 | X_MSG_COUNT OUT NOCOPY Standard out parameter
290 | X_MSG_DATA OUT NOCOPY Standard out parameter
291 |
292 | KNOWN ISSUES
293 | None
294 |
295 | NOTES
296 |
297 | MODIFICATION HISTORY
298 | Date Author Description of Changes
299 | 30-12-2003 scherkas Created
300 |
301 *=======================================================================*/
302 PROCEDURE REVERSE_LAST_AMORTIZATION(
303 P_API_VERSION IN NUMBER,
304 P_INIT_MSG_LIST IN VARCHAR2,
305 P_COMMIT IN VARCHAR2,
306 P_VALIDATION_LEVEL IN NUMBER,
307 P_LOAN_ID IN NUMBER,
308 P_REBILL_FLAG IN VARCHAR2,
309 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
310 X_MSG_COUNT OUT NOCOPY NUMBER,
311 X_MSG_DATA OUT NOCOPY VARCHAR2);
312
313 /*========================================================================
314 | PUBLIC PROCEDURE CREDIT_AMORTIZATION_PARTIAL
315 |
316 | DESCRIPTION
317 | This procedure will credit a portion of the last amortization.
318 | The portion can be principal interest or fees
319 |
320 | PSEUDO CODE/LOGIC
321 |
322 | PARAMETERS
323 | P_API_VERSION IN Standard in parameter
324 | P_INIT_MSG_LIST IN Standard in parameter
325 | P_COMMIT IN Standard in parameter
326 | P_VALIDATION_LEVEL IN Standard in parameter
327 | P_LOAN_ID IN Inputs loan id
328 | P_LINE_TYPE IN PRIN or INT or FEE
329 | X_RETURN_STATUS OUT NOCOPY Standard out parameter
330 | X_MSG_COUNT OUT NOCOPY Standard out parameter
331 | X_MSG_DATA OUT NOCOPY Standard out parameter
332 |
333 | KNOWN ISSUES
334 | None
335 |
336 | NOTES
337 |
338 | MODIFICATION HISTORY
339 | Date Author Description of Changes
340 | 10-12-2004 raverma Created
341 |
342 *=======================================================================*/
343 PROCEDURE CREDIT_AMORTIZATION_PARTIAL(P_API_VERSION IN NUMBER
344 ,P_INIT_MSG_LIST IN VARCHAR2
345 ,P_COMMIT IN VARCHAR2
346 ,P_VALIDATION_LEVEL IN NUMBER
347 ,P_LOAN_ID IN NUMBER
348 ,P_LINE_TYPE IN VARCHAR2
349 ,X_RETURN_STATUS OUT NOCOPY VARCHAR
350 ,X_MSG_COUNT OUT NOCOPY NUMBER
351 ,X_MSG_DATA OUT NOCOPY VARCHAR2);
352
353
354 /*========================================================================
355 | PUBLIC PROCEDURE CREATE_SINGLE_OFFCYCLE_BILL
356 |
357 | DESCRIPTION
358 | This procedure creates single manual bill.
359 |
360 | PSEUDO CODE/LOGIC
361 |
362 | PARAMETERS
363 | P_API_VERSION IN Standard in parameter
364 | P_INIT_MSG_LIST IN Standard in parameter
365 | P_COMMIT IN Standard in parameter
366 | P_VALIDATION_LEVEL IN Standard in parameter
367 | P_BILL_HEADER_REC IN Manual bill header record
368 | P_BILL_LINES_TBL IN Manual bill lines
369 | X_RETURN_STATUS OUT NOCOPY Standard out parameter
370 | X_MSG_COUNT OUT NOCOPY Standard out parameter
371 | X_MSG_DATA OUT NOCOPY Standard out parameter
372 |
373 | KNOWN ISSUES
374 | None
375 |
376 | NOTES
380 | 30-12-2003 scherkas Created
377 |
378 | MODIFICATION HISTORY
379 | Date Author Description of Changes
381 |
382 *=======================================================================*/
383 PROCEDURE CREATE_SINGLE_OFFCYCLE_BILL(
384 P_API_VERSION IN NUMBER,
385 P_INIT_MSG_LIST IN VARCHAR2,
386 P_COMMIT IN VARCHAR2,
387 P_VALIDATION_LEVEL IN NUMBER,
388 P_BILL_HEADER_REC IN LNS_BILLING_BATCH_PUB.BILL_HEADER_REC,
389 P_BILL_LINES_TBL IN LNS_BILLING_BATCH_PUB.BILL_LINES_TBL,
390 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
391 X_MSG_COUNT OUT NOCOPY NUMBER,
392 X_MSG_DATA OUT NOCOPY VARCHAR2);
393
394
395
396 /*========================================================================
397 | PUBLIC PROCEDURE CREATE_OFFCYCLE_BILLS
398 |
399 | DESCRIPTION
400 | This procedure creates multiple manual bills.
401 |
402 | PSEUDO CODE/LOGIC
403 |
404 | PARAMETERS
405 | P_API_VERSION IN Standard in parameter
406 | P_INIT_MSG_LIST IN Standard in parameter
407 | P_COMMIT IN Standard in parameter
408 | P_VALIDATION_LEVEL IN Standard in parameter
409 | P_BILL_HEADERS_TBL IN Manual bill headers
410 | P_BILL_LINES_TBL IN Manual bill lines
411 | X_RETURN_STATUS OUT NOCOPY Standard out parameter
412 | X_MSG_COUNT OUT NOCOPY Standard out parameter
413 | X_MSG_DATA OUT NOCOPY Standard out parameter
414 |
415 | KNOWN ISSUES
416 | None
417 |
418 | NOTES
419 |
420 | MODIFICATION HISTORY
421 | Date Author Description of Changes
422 | 30-12-2003 scherkas Created
423 |
424 *=======================================================================*/
425 PROCEDURE CREATE_OFFCYCLE_BILLS(
426 P_API_VERSION IN NUMBER,
427 P_INIT_MSG_LIST IN VARCHAR2,
428 P_COMMIT IN VARCHAR2,
429 P_VALIDATION_LEVEL IN NUMBER,
430 P_BILL_HEADERS_TBL IN LNS_BILLING_BATCH_PUB.BILL_HEADERS_TBL,
431 P_BILL_LINES_TBL IN LNS_BILLING_BATCH_PUB.BILL_LINES_TBL,
432 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
433 X_MSG_COUNT OUT NOCOPY NUMBER,
434 X_MSG_DATA OUT NOCOPY VARCHAR2);
435
436
437
438 /*========================================================================
439 | PUBLIC PROCEDURE REVERSE_OFFCYCLE_BILL
440 |
441 | DESCRIPTION
442 | This procedure reverses a single manual bill.
443 |
444 | PSEUDO CODE/LOGIC
445 |
446 | PARAMETERS
447 | P_API_VERSION IN Standard in parameter
448 | P_INIT_MSG_LIST IN Standard in parameter
449 | P_COMMIT IN Standard in parameter
450 | P_VALIDATION_LEVEL IN Standard in parameter
451 | P_AMORTIZATION_ID IN Input amortization id to reverse
452 | X_RETURN_STATUS OUT NOCOPY Standard out parameter
453 | X_MSG_COUNT OUT NOCOPY Standard out parameter
454 | X_MSG_DATA OUT NOCOPY Standard out parameter
455 |
456 | KNOWN ISSUES
457 | None
458 |
459 | NOTES
460 |
461 | MODIFICATION HISTORY
462 | Date Author Description of Changes
463 | 30-12-2003 scherkas Created
464 |
465 *=======================================================================*/
466 PROCEDURE REVERSE_OFFCYCLE_BILL(
467 P_API_VERSION IN NUMBER,
468 P_INIT_MSG_LIST IN VARCHAR2,
469 P_COMMIT IN VARCHAR2,
470 P_VALIDATION_LEVEL IN NUMBER,
471 P_AMORTIZATION_ID IN NUMBER,
472 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
473 X_MSG_COUNT OUT NOCOPY NUMBER,
474 X_MSG_DATA OUT NOCOPY VARCHAR2);
475
476
477
478
479 /*========================================================================
480 | PUBLIC PROCEDURE ADJUST_ORIGINAL_RECEIVABLE
481 |
482 | DESCRIPTION
483 | This procedure adjusts loans original receivable in AR
484 |
485 | PSEUDO CODE/LOGIC
486 |
487 | PARAMETERS
488 | P_API_VERSION IN Standard in parameter
489 | P_INIT_MSG_LIST IN Standard in parameter
490 | P_COMMIT IN Standard in parameter
491 | P_VALIDATION_LEVEL IN Standard in parameter
492 | P_LOAN_ID IN Loan ID
493 | X_RETURN_STATUS OUT NOCOPY Standard out parameter
494 | X_MSG_COUNT OUT NOCOPY Standard out parameter
495 | X_MSG_DATA OUT NOCOPY Standard out parameter
496 |
497 | KNOWN ISSUES
498 | None
499 |
500 | NOTES
501 |
502 | MODIFICATION HISTORY
503 | Date Author Description of Changes
504 | 01-01-2004 scherkas Created
505 |
506 *=======================================================================*/
507 PROCEDURE ADJUST_ORIGINAL_RECEIVABLE(
508 P_API_VERSION IN NUMBER,
509 P_INIT_MSG_LIST IN VARCHAR2,
510 P_COMMIT IN VARCHAR2,
511 P_VALIDATION_LEVEL IN NUMBER,
512 P_LOAN_ID IN NUMBER,
513 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
514 X_MSG_COUNT OUT NOCOPY NUMBER,
515 X_MSG_DATA OUT NOCOPY VARCHAR2);
516
517
518 /*========================================================================
519 | PUBLIC PROCEDURE PREBILL_SINGLE_LOAN
520 |
521 | DESCRIPTION
522 | This procedure prebill (do initial billing) for single loan
523 |
524 | PSEUDO CODE/LOGIC
525 |
526 | PARAMETERS
527 | P_API_VERSION IN Standard in parameter
528 | P_INIT_MSG_LIST IN Standard in parameter
529 | P_COMMIT IN Standard in parameter
530 | P_VALIDATION_LEVEL IN Standard in parameter
531 | P_LOAN_ID IN Loan ID
532 | X_RETURN_STATUS OUT NOCOPY Standard out parameter
533 | X_MSG_COUNT OUT NOCOPY Standard out parameter
534 | X_MSG_DATA OUT NOCOPY Standard out parameter
535 |
536 | KNOWN ISSUES
537 | None
538 |
539 | NOTES
540 | Any interesting aspect of the code in the package body which needs
541 | to be stated.
542 |
543 | MODIFICATION HISTORY
544 | Date Author Description of Changes
545 | 12-23-2004 scherkas Created
546 |
547 *=======================================================================*/
548 PROCEDURE PREBILL_SINGLE_LOAN(
549 P_API_VERSION IN NUMBER,
550 P_INIT_MSG_LIST IN VARCHAR2,
551 P_COMMIT IN VARCHAR2,
552 P_VALIDATION_LEVEL IN NUMBER,
553 P_LOAN_ID IN NUMBER,
554 X_BILLED_YN OUT NOCOPY VARCHAR2,
555 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
556 X_MSG_COUNT OUT NOCOPY NUMBER,
557 X_MSG_DATA OUT NOCOPY VARCHAR2);
558
559
560
561 /*========================================================================
562 | PUBLIC PROCEDURE GENERATE_BILLING_STATEMENT_XML
563 |
564 | DESCRIPTION
565 | This procedure creates the billing statement xml for single loan
566 |
567 | PSEUDO CODE/LOGIC
568 |
569 | PARAMETERS
570 | P_LOAN_ID IN NUMBER
571 | P_AMORTIZATION_SCHEDULE_ID IN NUMBER
572 | KNOWN ISSUES
573 | None
574 |
575 | NOTES
576 | Any interesting aspect of the code in the package body which needs
577 | to be stated.
578 |
579 | MODIFICATION HISTORY
580 | Date Author Description of Changes
581 | 04-24-2004 karamach Created
582 | 05-04-2004 scherkas Modified
583 | 06-19-2004 karamach Changed to use DBMS_XMLQUERY (8i pkg) instead of DBMS_XMLGEN (9i pkg)
584 | to be compatible with the supported Oracle database version 8.1.7.4
585 | and avoid 9i dependency
586 |
587 *=======================================================================*/
588 PROCEDURE GENERATE_BILLING_STATEMENT_XML(p_loan_id IN NUMBER,
589 p_amortization_schedule_id IN NUMBER);
590
591
592 /*========================================================================
593 | PUBLIC PROCEDURE PROCESS_PAID_LOANS
594 |
595 | DESCRIPTION
596 | This procedure sets still active paid off loans to status PAIDOFF
597 |
598 | PSEUDO CODE/LOGIC
599 |
600 | PARAMETERS
601 | P_API_VERSION IN Standard in parameter
602 | P_INIT_MSG_LIST IN Standard in parameter
603 | P_COMMIT IN Standard in parameter
604 | P_VALIDATION_LEVEL IN Standard in parameter
605 | P_LOAN_ID IN Loan
606 | P_PAYOFF_DATE IN Pay off date
607 | X_RETURN_STATUS OUT NOCOPY Standard out parameter
608 | X_MSG_COUNT OUT NOCOPY Standard out parameter
609 | X_MSG_DATA OUT NOCOPY Standard out parameter
610
611 | KNOWN ISSUES
612 | None
613 |
614 | NOTES
615 | Any interesting aspect of the code in the package body which needs
616 | to be stated.
617 |
618 | MODIFICATION HISTORY
619 | Date Author Description of Changes
620 | 01-01-2004 scherkas Created
621 |
622 *=======================================================================*/
623 PROCEDURE PROCESS_PAID_LOANS(
624 P_API_VERSION IN NUMBER,
625 P_INIT_MSG_LIST IN VARCHAR2,
626 P_COMMIT IN VARCHAR2,
627 P_VALIDATION_LEVEL IN NUMBER,
628 P_LOAN_ID IN NUMBER,
629 P_PAYOFF_DATE IN DATE,
630 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
631 X_MSG_COUNT OUT NOCOPY NUMBER,
632 X_MSG_DATA OUT NOCOPY VARCHAR2);
633
634
635
636 END LNS_BILLING_BATCH_PUB;