1 PACKAGE LNS_FUNDING_PUB AUTHID CURRENT_USER as
2 /* $Header: LNS_FUNDING_S.pls 120.16 2005/12/12 10:12:19 scherkas noship $ */
3
4 /*=======================================================================+
5 | Declare PUBLIC Data Types and Variables
6 +=======================================================================*/
7
8 TYPE LNS_DISB_HEADERS_REC IS RECORD(
9 DISB_HEADER_ID NUMBER,
10 LOAN_ID NUMBER,
11 ACTIVITY_CODE VARCHAR2(30),
12 DISBURSEMENT_NUMBER NUMBER,
13 HEADER_AMOUNT NUMBER,
14 HEADER_PERCENT NUMBER,
15 STATUS VARCHAR2(30),
16 TARGET_DATE DATE,
17 PAYMENT_REQUEST_DATE DATE,
18 OBJECT_VERSION_NUMBER NUMBER,
19 AUTOFUNDING_FLAG VARCHAR2(1)
20 );
21
22 TYPE LNS_DISB_LINES_REC IS RECORD(
23 DISB_LINE_ID NUMBER,
24 DISB_HEADER_ID NUMBER,
25 DISB_LINE_NUMBER NUMBER,
26 LINE_AMOUNT NUMBER,
27 LINE_PERCENT NUMBER,
28 PAYEE_PARTY_ID NUMBER,
29 BANK_ACCOUNT_ID NUMBER,
30 PAYMENT_METHOD_CODE VARCHAR2(30),
31 STATUS VARCHAR2(30),
32 REQUEST_DATE DATE,
33 DISBURSEMENT_DATE DATE,
34 OBJECT_VERSION_NUMBER NUMBER,
35 INVOICE_INTERFACE_ID NUMBER,
36 INVOICE_ID NUMBER
37 );
38
39 Type Trxn_Attributes_Rec_Type IS Record(
40 Application_Id NUMBER,
41 Payer_Legal_Entity_Id NUMBER,
42 Payer_Org_Id NUMBER,
43 Payer_Org_Type VARCHAR2(30),
44 Payee_Party_Id NUMBER,
45 Payee_Party_Site_Id NUMBER,
46 Supplier_Site_Id NUMBER,
47 Pay_Proc_Trxn_Type_Code VARCHAR2(30),
48 Payment_Currency VARCHAR2(10),
49 Payment_Amount NUMBER,
50 Payment_Function VARCHAR2(30)
51 );
52
53 Type Default_Pmt_Attrs_Rec_Type is Record(
54 Payment_Method_Name VARCHAR2(100),
55 Payment_Method_Code VARCHAR2(30),
56 Payee_BankAccount_Id NUMBER,
57 Payee_BankAccount_Number VARCHAR2(100),
58 Payee_BankAccount_Name VARCHAR2(80)
59 );
60
61 /*========================================================================
62 | PUBLIC FUNCTION IS_SUBMIT_DISB_ENABLED
63 |
64 | DESCRIPTION
65 | This function returns is submition of a disbursement header enabled or not.
66 |
67 | PSEUDO CODE/LOGIC
68 |
69 | PARAMETERS
70 | P_DISB_HEADER_D IN Disbursement header
71 |
72 | KNOWN ISSUES
73 | None
74 |
75 | NOTES
76 |
77 | MODIFICATION HISTORY
78 | Date Author Description of Changes
79 | 18-07-2005 scherkas Created
80 |
81 *=======================================================================*/
82 FUNCTION IS_SUBMIT_DISB_ENABLED(P_DISB_HEADER_ID IN NUMBER) RETURN VARCHAR2;
83
84
85
86 /*========================================================================
87 | PUBLIC FUNCTION IS_CANCEL_DISB_ENABLED
88 |
89 | DESCRIPTION
90 | This function returns is cancel of a disbursements enabled or not.
91 |
92 | PSEUDO CODE/LOGIC
93 |
94 | PARAMETERS
95 | P_LOAN_D IN Loan
96 |
97 | KNOWN ISSUES
98 | None
99 |
100 | NOTES
101 |
102 | MODIFICATION HISTORY
103 | Date Author Description of Changes
104 | 18-07-2005 scherkas Created
105 |
106 *=======================================================================*/
107 FUNCTION IS_CANCEL_DISB_ENABLED(P_LOAN_ID IN NUMBER) RETURN VARCHAR2;
108
109
110
111 /*========================================================================
112 | PUBLIC FUNCTION IS_DISB_HDR_READ_ONLY
113 |
114 | DESCRIPTION
115 | This function returns is disb header read only or not.
116 |
117 | PSEUDO CODE/LOGIC
118 |
119 | PARAMETERS
120 | P_DISB_HEADER_ID IN Disbursement header
121 |
122 | KNOWN ISSUES
123 | None
124 |
125 | NOTES
126 |
127 | MODIFICATION HISTORY
128 | Date Author Description of Changes
129 | 13-09-2005 scherkas Created
130 |
131 *=======================================================================*/
132 FUNCTION IS_DISB_HDR_READ_ONLY(P_DISB_HEADER_ID IN NUMBER) RETURN VARCHAR2;
133
134
135
136 /*========================================================================
137 | PUBLIC FUNCTION IS_DISB_LINE_READ_ONLY
138 |
139 | DESCRIPTION
140 | This function returns is disb line read only or not.
141 |
142 | PSEUDO CODE/LOGIC
143 |
144 | PARAMETERS
145 | P_DISB_LINE_ID IN Disbursement line
146 |
147 | KNOWN ISSUES
148 | None
149 |
150 | NOTES
151 |
152 | MODIFICATION HISTORY
153 | Date Author Description of Changes
154 | 13-09-2005 scherkas Created
155 |
156 *=======================================================================*/
157 FUNCTION IS_DISB_LINE_READ_ONLY(P_DISB_LINE_ID IN NUMBER) RETURN VARCHAR2;
158
159
160
161 /*========================================================================
162 | PUBLIC FUNCTION IS_LAST_DISB_BEFORE_CONV
163 |
164 | DESCRIPTION
165 | This function returns is it last disb header before loan conversion.
166 |
167 | PSEUDO CODE/LOGIC
168 |
169 | PARAMETERS
170 | P_DISB_HEADER_ID IN Disbursement header
171 |
172 | KNOWN ISSUES
173 | None
174 |
175 | NOTES
176 |
177 | MODIFICATION HISTORY
178 | Date Author Description of Changes
179 | 13-09-2005 scherkas Created
180 |
181 *=======================================================================*/
182 FUNCTION IS_LAST_DISB_BEFORE_CONV(P_DISB_HEADER_ID IN NUMBER) RETURN VARCHAR2;
183
184
185
186 /*========================================================================
187 | PUBLIC PROCEDURE Get_Default_Payment_Attributes
188 |
189 | DESCRIPTION
190 | This procedure returns default payment attributes from Oracle Payments
191 |
192 | PSEUDO CODE/LOGIC
193 |
194 | PARAMETERS
195 | P_API_VERSION IN Standard in parameter
196 | P_INIT_MSG_LIST IN Standard in parameter
197 | P_COMMIT IN Standard in parameter
198 | P_VALIDATION_LEVEL IN Standard in parameter
199 | P_Trxn_Attributes_Rec IN LNS_FUNDING_PUB.Trxn_Attributes_Rec_Type,
200 | X_default_pmt_attrs_rec OUT NOCOPY LNS_FUNDING_PUB.Default_Pmt_Attrs_Rec_Type,
201 | X_RETURN_STATUS OUT NOCOPY Standard out parameter
202 | X_MSG_COUNT OUT NOCOPY Standard out parameter
203 | X_MSG_DATA OUT NOCOPY Standard out parameter
204 |
205 | KNOWN ISSUES
206 | None
207 |
208 | NOTES
209 |
210 | MODIFICATION HISTORY
211 | Date Author Description of Changes
212 | 06-07-2005 scherkas Created
213 |
214 *=======================================================================*/
215 PROCEDURE Get_Default_Payment_Attributes(
216 P_API_VERSION IN NUMBER,
217 P_INIT_MSG_LIST IN VARCHAR2,
218 P_COMMIT IN VARCHAR2,
219 P_VALIDATION_LEVEL IN NUMBER,
220 P_Trxn_Attributes_Rec IN LNS_FUNDING_PUB.Trxn_Attributes_Rec_Type,
221 X_default_pmt_attrs_rec OUT NOCOPY LNS_FUNDING_PUB.Default_Pmt_Attrs_Rec_Type,
222 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
223 X_MSG_COUNT OUT NOCOPY NUMBER,
224 X_MSG_DATA OUT NOCOPY VARCHAR2);
225
226
227
228 /*========================================================================
229 | PUBLIC PROCEDURE INSERT_DISB_HEADER
230 |
231 | DESCRIPTION
232 | This procedure inserts new disbursement header
233 |
234 | PSEUDO CODE/LOGIC
235 |
236 | PARAMETERS
237 | P_API_VERSION IN Standard in parameter
238 | P_INIT_MSG_LIST IN Standard in parameter
239 | P_COMMIT IN Standard in parameter
240 | P_VALIDATION_LEVEL IN Standard in parameter
241 | P_DISB_HEADER_REC IN LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC,
242 | X_RETURN_STATUS OUT NOCOPY Standard out parameter
243 | X_MSG_COUNT OUT NOCOPY Standard out parameter
244 | X_MSG_DATA OUT NOCOPY Standard out parameter
245 |
246 | KNOWN ISSUES
247 | None
248 |
249 | NOTES
250 |
251 | MODIFICATION HISTORY
252 | Date Author Description of Changes
253 | 06-07-2005 scherkas Created
254 |
255 *=======================================================================*/
256 PROCEDURE INSERT_DISB_HEADER(
257 P_API_VERSION IN NUMBER,
258 P_INIT_MSG_LIST IN VARCHAR2,
259 P_COMMIT IN VARCHAR2,
260 P_VALIDATION_LEVEL IN NUMBER,
261 P_DISB_HEADER_REC IN LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC,
262 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
263 X_MSG_COUNT OUT NOCOPY NUMBER,
264 X_MSG_DATA OUT NOCOPY VARCHAR2);
265
266
267
268 /*========================================================================
269 | PUBLIC PROCEDURE UPDATE_DISB_HEADER
270 |
271 | DESCRIPTION
272 | This procedure updates disbursement header
273 |
274 | PSEUDO CODE/LOGIC
275 |
276 | PARAMETERS
277 | P_API_VERSION IN Standard in parameter
278 | P_INIT_MSG_LIST IN Standard in parameter
279 | P_COMMIT IN Standard in parameter
280 | P_VALIDATION_LEVEL IN Standard in parameter
281 | P_DISB_HEADER_REC IN LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC,
282 | X_RETURN_STATUS OUT NOCOPY Standard out parameter
283 | X_MSG_COUNT OUT NOCOPY Standard out parameter
284 | X_MSG_DATA OUT NOCOPY Standard out parameter
285 |
286 | KNOWN ISSUES
287 | None
288 |
289 | NOTES
290 |
291 | MODIFICATION HISTORY
292 | Date Author Description of Changes
293 | 06-07-2005 scherkas Created
294 |
295 *=======================================================================*/
296 PROCEDURE UPDATE_DISB_HEADER(
297 P_API_VERSION IN NUMBER,
298 P_INIT_MSG_LIST IN VARCHAR2,
299 P_COMMIT IN VARCHAR2,
300 P_VALIDATION_LEVEL IN NUMBER,
301 P_DISB_HEADER_REC IN LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC,
302 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
303 X_MSG_COUNT OUT NOCOPY NUMBER,
304 X_MSG_DATA OUT NOCOPY VARCHAR2);
305
306
307
308 /*========================================================================
309 | PUBLIC PROCEDURE DELETE_DISB_HEADER
310 |
311 | DESCRIPTION
312 | This procedure deletes disbursement header
313 |
314 | PSEUDO CODE/LOGIC
315 |
316 | PARAMETERS
317 | P_API_VERSION IN Standard in parameter
318 | P_INIT_MSG_LIST IN Standard in parameter
319 | P_COMMIT IN Standard in parameter
320 | P_VALIDATION_LEVEL IN Standard in parameter
321 | P_DISB_HEADER_ID IN Disbursement Header ID
322 | X_RETURN_STATUS OUT NOCOPY Standard out parameter
323 | X_MSG_COUNT OUT NOCOPY Standard out parameter
324 | X_MSG_DATA OUT NOCOPY Standard out parameter
325 |
326 | KNOWN ISSUES
327 | None
328 |
329 | NOTES
330 |
331 | MODIFICATION HISTORY
332 | Date Author Description of Changes
333 | 06-07-2005 scherkas Created
334 |
335 *=======================================================================*/
336 PROCEDURE DELETE_DISB_HEADER(
337 P_API_VERSION IN NUMBER,
338 P_INIT_MSG_LIST IN VARCHAR2,
339 P_COMMIT IN VARCHAR2,
340 P_VALIDATION_LEVEL IN NUMBER,
341 P_DISB_HEADER_ID IN NUMBER,
342 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
343 X_MSG_COUNT OUT NOCOPY NUMBER,
344 X_MSG_DATA OUT NOCOPY VARCHAR2);
345
346
347
348 /*========================================================================
349 | PUBLIC PROCEDURE INSERT_DISB_LINE
350 |
351 | DESCRIPTION
352 | This procedure inserts new disbursement line
353 |
354 | PSEUDO CODE/LOGIC
355 |
356 | PARAMETERS
357 | P_API_VERSION IN Standard in parameter
358 | P_INIT_MSG_LIST IN Standard in parameter
359 | P_COMMIT IN Standard in parameter
360 | P_VALIDATION_LEVEL IN Standard in parameter
361 | P_DISB_LINE_REC IN OUT NOCOPY LNS_FUNDING_PUB.LNS_DISB_LINES_REC
362 | X_RETURN_STATUS OUT NOCOPY Standard out parameter
363 | X_MSG_COUNT OUT NOCOPY Standard out parameter
364 | X_MSG_DATA OUT NOCOPY Standard out parameter
365 |
366 | KNOWN ISSUES
367 | None
368 |
369 | NOTES
370 |
371 | MODIFICATION HISTORY
372 | Date Author Description of Changes
373 | 06-07-2005 scherkas Created
374 |
375 *=======================================================================*/
376 PROCEDURE INSERT_DISB_LINE(
377 P_API_VERSION IN NUMBER,
378 P_INIT_MSG_LIST IN VARCHAR2,
379 P_COMMIT IN VARCHAR2,
380 P_VALIDATION_LEVEL IN NUMBER,
381 P_DISB_LINE_REC IN LNS_FUNDING_PUB.LNS_DISB_LINES_REC,
382 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
383 X_MSG_COUNT OUT NOCOPY NUMBER,
384 X_MSG_DATA OUT NOCOPY VARCHAR2);
385
386
387
388 /*========================================================================
389 | PUBLIC PROCEDURE UPDATE_DISB_LINE
390 |
391 | DESCRIPTION
392 | This procedure updates disbursement line
393 |
394 | PSEUDO CODE/LOGIC
395 |
396 | PARAMETERS
397 | P_API_VERSION IN Standard in parameter
398 | P_INIT_MSG_LIST IN Standard in parameter
399 | P_COMMIT IN Standard in parameter
400 | P_VALIDATION_LEVEL IN Standard in parameter
401 | P_DISB_LINE_REC IN LNS_FUNDING_PUB.LNS_DISB_LINES_REC
402 | X_RETURN_STATUS OUT NOCOPY Standard out parameter
403 | X_MSG_COUNT OUT NOCOPY Standard out parameter
404 | X_MSG_DATA OUT NOCOPY Standard out parameter
405 |
406 | KNOWN ISSUES
407 | None
408 |
409 | NOTES
410 |
411 | MODIFICATION HISTORY
412 | Date Author Description of Changes
413 | 06-07-2005 scherkas Created
414 |
415 *=======================================================================*/
416 PROCEDURE UPDATE_DISB_LINE(
417 P_API_VERSION IN NUMBER,
418 P_INIT_MSG_LIST IN VARCHAR2,
419 P_COMMIT IN VARCHAR2,
420 P_VALIDATION_LEVEL IN NUMBER,
421 P_DISB_LINE_REC IN LNS_FUNDING_PUB.LNS_DISB_LINES_REC,
422 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
423 X_MSG_COUNT OUT NOCOPY NUMBER,
424 X_MSG_DATA OUT NOCOPY VARCHAR2);
425
426
427
428 /*========================================================================
429 | PUBLIC PROCEDURE DELETE_DISB_LINE
430 |
431 | DESCRIPTION
432 | This procedure deletes disbursement line
433 |
434 | PSEUDO CODE/LOGIC
435 |
436 | PARAMETERS
437 | P_API_VERSION IN Standard in parameter
438 | P_INIT_MSG_LIST IN Standard in parameter
439 | P_COMMIT IN Standard in parameter
440 | P_VALIDATION_LEVEL IN Standard in parameter
441 | P_DISB_LINE_ID IN Disbursement Line ID
442 | X_RETURN_STATUS OUT NOCOPY Standard out parameter
443 | X_MSG_COUNT OUT NOCOPY Standard out parameter
444 | X_MSG_DATA OUT NOCOPY Standard out parameter
445 |
446 | KNOWN ISSUES
447 | None
448 |
449 | NOTES
450 |
451 | MODIFICATION HISTORY
452 | Date Author Description of Changes
453 | 06-07-2005 scherkas Created
454 |
455 *=======================================================================*/
456 PROCEDURE DELETE_DISB_LINE(
457 P_API_VERSION IN NUMBER,
458 P_INIT_MSG_LIST IN VARCHAR2,
459 P_COMMIT IN VARCHAR2,
460 P_VALIDATION_LEVEL IN NUMBER,
461 P_DISB_LINE_ID IN NUMBER,
462 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
463 X_MSG_COUNT OUT NOCOPY NUMBER,
464 X_MSG_DATA OUT NOCOPY VARCHAR2);
465
466
467
468 /*========================================================================
469 | PUBLIC PROCEDURE SUBMIT_DISBURSEMENT
470 |
471 | DESCRIPTION
472 | This procedure submits disbursement to AP.
473 |
474 | PSEUDO CODE/LOGIC
475 |
476 | PARAMETERS
477 | P_API_VERSION IN Standard in parameter
478 | P_INIT_MSG_LIST IN Standard in parameter
479 | P_COMMIT IN Standard in parameter
480 | P_VALIDATION_LEVEL IN Standard in parameter
481 | P_DISB_HEADER_ID IN Disbursement Header ID
482 | X_RETURN_STATUS OUT NOCOPY Standard out parameter
483 | X_MSG_COUNT OUT NOCOPY Standard out parameter
484 | X_MSG_DATA OUT NOCOPY Standard out parameter
485 |
486 | KNOWN ISSUES
487 | None
488 |
489 | NOTES
490 | Any interesting aspect of the code in the package body which needs
491 | to be stated.
492 |
493 | MODIFICATION HISTORY
494 | Date Author Description of Changes
495 | 06-23-2005 scherkas Created
496 |
497 *=======================================================================*/
498 PROCEDURE SUBMIT_DISBURSEMENT(
499 P_API_VERSION IN NUMBER,
500 P_INIT_MSG_LIST IN VARCHAR2,
501 P_COMMIT IN VARCHAR2,
502 P_VALIDATION_LEVEL IN NUMBER,
503 P_DISB_HEADER_ID IN NUMBER,
504 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
505 X_MSG_COUNT OUT NOCOPY NUMBER,
506 X_MSG_DATA OUT NOCOPY VARCHAR2);
507
508
509
510 /*========================================================================
511 | PUBLIC PROCEDURE VALIDATE_DISB_LINES
512 |
513 | DESCRIPTION
514 | This procedure validates all disbursement lines for a specific disbursement header.
515 |
516 | PSEUDO CODE/LOGIC
517 |
518 | PARAMETERS
519 | P_API_VERSION IN Standard in parameter
520 | P_INIT_MSG_LIST IN Standard in parameter
521 | P_COMMIT IN Standard in parameter
522 | P_VALIDATION_LEVEL IN Standard in parameter
523 | P_DISB_HEADER_ID IN Disbursement Header ID
524 | X_RETURN_STATUS OUT NOCOPY Standard out parameter
525 | X_MSG_COUNT OUT NOCOPY Standard out parameter
526 | X_MSG_DATA OUT NOCOPY Standard out parameter
527 |
528 | KNOWN ISSUES
529 | None
530 |
531 | NOTES
532 | Any interesting aspect of the code in the package body which needs
533 | to be stated.
534 |
535 | MODIFICATION HISTORY
536 | Date Author Description of Changes
537 | 11-08-2004 scherkas Created
538 |
539 *=======================================================================*/
540 PROCEDURE VALIDATE_DISB_LINES(
541 P_API_VERSION IN NUMBER,
542 P_INIT_MSG_LIST IN VARCHAR2,
543 P_COMMIT IN VARCHAR2,
544 P_VALIDATION_LEVEL IN NUMBER,
545 P_DISB_HEADER_ID IN NUMBER,
546 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
547 X_MSG_COUNT OUT NOCOPY NUMBER,
548 X_MSG_DATA OUT NOCOPY VARCHAR2);
549
550
551
552 /*========================================================================
553 | PUBLIC PROCEDURE VALIDATE_DISB_HEADERS
554 |
555 | DESCRIPTION
556 | This procedure validates all disbursement headers.
557 |
558 | PSEUDO CODE/LOGIC
559 |
560 | PARAMETERS
561 | P_API_VERSION IN Standard in parameter
562 | P_INIT_MSG_LIST IN Standard in parameter
563 | P_COMMIT IN Standard in parameter
564 | P_VALIDATION_LEVEL IN Standard in parameter
565 | P_LOAN_ID IN Loan ID
566 | X_RETURN_STATUS OUT NOCOPY Standard out parameter
567 | X_MSG_COUNT OUT NOCOPY Standard out parameter
568 | X_MSG_DATA OUT NOCOPY Standard out parameter
569 |
570 | KNOWN ISSUES
571 | None
572 |
573 | NOTES
574 | Any interesting aspect of the code in the package body which needs
575 | to be stated.
576 |
577 | MODIFICATION HISTORY
578 | Date Author Description of Changes
579 | 11-08-2004 scherkas Created
580 |
581 *=======================================================================*/
582 PROCEDURE VALIDATE_DISB_HEADERS(
583 P_API_VERSION IN NUMBER,
584 P_INIT_MSG_LIST IN VARCHAR2,
585 P_COMMIT IN VARCHAR2,
586 P_VALIDATION_LEVEL IN NUMBER,
587 P_LOAN_ID IN NUMBER,
588 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
589 X_MSG_COUNT OUT NOCOPY NUMBER,
590 X_MSG_DATA OUT NOCOPY VARCHAR2);
591
592
593
594 /*========================================================================
595 | PUBLIC PROCEDURE DEFAULT_PROD_DISBURSEMENTS
596 |
597 | DESCRIPTION
598 | This procedure Defaults Disbursements for a loan based on product setup.
599 |
600 | PSEUDO CODE/LOGIC
601 |
602 | PARAMETERS
603 | P_LOAN_ID IN Loan ID
604 |
605 | KNOWN ISSUES
606 | None
607 |
608 | NOTES
609 | Any interesting aspect of the code in the package body which needs
610 | to be stated.
611 |
612 | MODIFICATION HISTORY
613 | Date Author Description of Changes
614 | 12-07-2005 gbellary Created
615 |
616 *=======================================================================*/
617 PROCEDURE DEFAULT_PROD_DISBURSEMENTS(
618 P_LOAN_ID IN NUMBER);
619 TYPE LOAN_PAYEE_REC IS RECORD(
620 PAYEE_NAME VARCHAR2(240),
621 TAXPAYER_ID VARCHAR2(30),
622 TAX_REGISTRATION_ID VARCHAR2(20),
623 SUPPLIER_TYPE VARCHAR2(30),
624 PAYEE_NUMBER VARCHAR2(30)
625 );
626
627 /*========================================================================
628 | PUBLIC PROCEDURE SubscribeTo_Payment_Event
629 |
630 | DESCRIPTION
631 | This procedure called by AP to confirm payment on invoice
632 |
633 | PSEUDO CODE/LOGIC
634 |
635 | PARAMETERS
636 | P_Event_Type IN Event type
637 | P_Check_ID IN Check ID
638 | X_RETURN_STATUS OUT NOCOPY Standard out parameter
639 | X_MSG_COUNT OUT NOCOPY Standard out parameter
640 | X_MSG_DATA OUT NOCOPY Standard out parameter
641 |
642 | KNOWN ISSUES
643 | None
644 |
645 | NOTES
646 | Any interesting aspect of the code in the package body which needs
647 | to be stated.
648 |
649 | MODIFICATION HISTORY
650 | Date Author Description of Changes
651 | 07-25-2005 scherkas Created
652 |
653 *=======================================================================*/
654 PROCEDURE SubscribeTo_Payment_Event
655 (P_Event_Type IN VARCHAR2,
656 P_Check_ID IN NUMBER,
657 P_Return_Status OUT NOCOPY VARCHAR2,
658 P_Msg_Count OUT NOCOPY NUMBER,
659 P_Msg_Data OUT NOCOPY VARCHAR2);
660
661
662
663 /*========================================================================
664 | PUBLIC PROCEDURE COMPLETE_ALL_DISB
665 |
666 | DESCRIPTION
667 | This procedure is for testing purpose only.
668 | It completes all available disbursements for a loan and sets all to status fully paid.
669 |
670 | PSEUDO CODE/LOGIC
671 |
672 | PARAMETERS
673 | P_API_VERSION IN Standard in parameter
674 | P_INIT_MSG_LIST IN Standard in parameter
675 | P_COMMIT IN Standard in parameter
676 | P_VALIDATION_LEVEL IN Standard in parameter
677 | P_LOAN_ID IN Loan
678 | X_RETURN_STATUS OUT NOCOPY Standard out parameter
679 | X_MSG_COUNT OUT NOCOPY Standard out parameter
680 | X_MSG_DATA OUT NOCOPY Standard out parameter
681 |
682 | KNOWN ISSUES
683 | None
684 |
685 | NOTES
686 | Any interesting aspect of the code in the package body which needs
687 | to be stated.
688 |
689 | MODIFICATION HISTORY
690 | Date Author Description of Changes
691 | 07-26-2005 scherkas Created
692 |
693 *=======================================================================*/
694 PROCEDURE COMPLETE_ALL_DISB(
695 P_API_VERSION IN NUMBER,
696 P_INIT_MSG_LIST IN VARCHAR2,
697 P_COMMIT IN VARCHAR2,
698 P_VALIDATION_LEVEL IN NUMBER,
699 P_LOAN_ID IN NUMBER,
700 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
701 X_MSG_COUNT OUT NOCOPY NUMBER,
702 X_MSG_DATA OUT NOCOPY VARCHAR2);
703
704
705
706 /*========================================================================
707 | PUBLIC PROCEDURE SUBMIT_AUTODISBURSEMENT
708 |
709 | DESCRIPTION
710 | This procedure submits 1-st disbursement of a loan
711 |
712 | PSEUDO CODE/LOGIC
713 |
714 | PARAMETERS
715 | P_API_VERSION IN Standard in parameter
716 | P_INIT_MSG_LIST IN Standard in parameter
717 | P_COMMIT IN Standard in parameter
718 | P_VALIDATION_LEVEL IN Standard in parameter
719 | P_LOAN_ID IN Loan ID
720 | X_RETURN_STATUS OUT NOCOPY Standard out parameter
721 | X_MSG_COUNT OUT NOCOPY Standard out parameter
722 | X_MSG_DATA OUT NOCOPY Standard out parameter
723 |
724 | KNOWN ISSUES
725 | None
726 |
727 | NOTES
728 | Any interesting aspect of the code in the package body which needs
729 | to be stated.
730 |
731 | MODIFICATION HISTORY
732 | Date Author Description of Changes
733 | 07-26-2005 scherkas Created
734 |
735 *=======================================================================*/
736 PROCEDURE SUBMIT_AUTODISBURSEMENT(
737 P_API_VERSION IN NUMBER,
738 P_INIT_MSG_LIST IN VARCHAR2,
739 P_COMMIT IN VARCHAR2,
740 P_VALIDATION_LEVEL IN NUMBER,
741 P_LOAN_ID IN NUMBER,
742 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
743 X_MSG_COUNT OUT NOCOPY NUMBER,
744 X_MSG_DATA OUT NOCOPY VARCHAR2);
745
746
747
748 /*========================================================================
749 | PUBLIC PROCEDURE APPROVE_CANCEL_REM_DISB
750 |
751 | DESCRIPTION
752 | This procedure to be called after approval of cancelation of disbursement schedule and
753 | cancels all remaining disbursements of a loan
754 |
755 | PSEUDO CODE/LOGIC
756 |
757 | PARAMETERS
758 | P_API_VERSION IN Standard in parameter
759 | P_INIT_MSG_LIST IN Standard in parameter
760 | P_COMMIT IN Standard in parameter
761 | P_VALIDATION_LEVEL IN Standard in parameter
762 | P_LOAN_ID IN Loan
763 | X_RETURN_STATUS OUT NOCOPY Standard out parameter
764 | X_MSG_COUNT OUT NOCOPY Standard out parameter
765 | X_MSG_DATA OUT NOCOPY Standard out parameter
766 |
767 | KNOWN ISSUES
768 | None
769 |
770 | NOTES
771 | Any interesting aspect of the code in the package body which needs
772 | to be stated.
773 |
774 | MODIFICATION HISTORY
775 | Date Author Description of Changes
776 | 07-26-2005 scherkas Created
777 |
778 *=======================================================================*/
779 PROCEDURE APPROVE_CANCEL_REM_DISB(
780 P_API_VERSION IN NUMBER,
781 P_INIT_MSG_LIST IN VARCHAR2,
782 P_COMMIT IN VARCHAR2,
783 P_VALIDATION_LEVEL IN NUMBER,
784 P_LOAN_ID IN NUMBER,
785 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
786 X_MSG_COUNT OUT NOCOPY NUMBER,
787 X_MSG_DATA OUT NOCOPY VARCHAR2);
788
789
790
791 /*========================================================================
792 | PUBLIC PROCEDURE SET_AUTOFUNDING
793 |
794 | DESCRIPTION
795 | This procedure sets autofunding flag for a loan.
796 |
797 | PSEUDO CODE/LOGIC
798 |
799 | PARAMETERS
800 | P_API_VERSION IN Standard in parameter
801 | P_INIT_MSG_LIST IN Standard in parameter
802 | P_COMMIT IN Standard in parameter
803 | P_VALIDATION_LEVEL IN Standard in parameter
804 | P_LOAN_ID IN Loan ID
805 | P_AUTOFUNDING_FLAG IN Autofunding flag
806 | X_RETURN_STATUS OUT NOCOPY Standard out parameter
807 | X_MSG_COUNT OUT NOCOPY Standard out parameter
808 | X_MSG_DATA OUT NOCOPY Standard out parameter
809 |
810 | KNOWN ISSUES
811 | None
812 |
813 | NOTES
814 | Any interesting aspect of the code in the package body which needs
815 | to be stated.
816 |
817 | MODIFICATION HISTORY
818 | Date Author Description of Changes
819 | 11-15-2004 scherkas Created
820 |
821 *=======================================================================*/
822 PROCEDURE SET_AUTOFUNDING(
823 P_API_VERSION IN NUMBER,
824 P_INIT_MSG_LIST IN VARCHAR2,
825 P_COMMIT IN VARCHAR2,
826 P_VALIDATION_LEVEL IN NUMBER,
827 P_LOAN_ID IN NUMBER,
828 P_AUTOFUNDING_FLAG IN VARCHAR2,
829 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
830 X_MSG_COUNT OUT NOCOPY NUMBER,
831 X_MSG_DATA OUT NOCOPY VARCHAR2);
832
833
834
835 /*========================================================================
836 | PUBLIC PROCEDURE REJECT_CANCEL_DISB
837 |
838 | DESCRIPTION
839 | This procedure to be called after rejection of cancelation of disbursement schedule and
840 | reactivate disbursement schedule of a loan
841 |
842 | PSEUDO CODE/LOGIC
843 |
844 | PARAMETERS
845 | P_API_VERSION IN Standard in parameter
846 | P_INIT_MSG_LIST IN Standard in parameter
847 | P_COMMIT IN Standard in parameter
848 | P_VALIDATION_LEVEL IN Standard in parameter
849 | P_LOAN_ID IN Loan
850 | X_RETURN_STATUS OUT NOCOPY Standard out parameter
851 | X_MSG_COUNT OUT NOCOPY Standard out parameter
852 | X_MSG_DATA OUT NOCOPY Standard out parameter
853 |
854 | KNOWN ISSUES
855 | None
856 |
857 | NOTES
858 | Any interesting aspect of the code in the package body which needs
859 | to be stated.
860 |
861 | MODIFICATION HISTORY
862 | Date Author Description of Changes
863 | 07-26-2005 scherkas Created
864 |
865 *=======================================================================*/
866 PROCEDURE REJECT_CANCEL_DISB(
867 P_API_VERSION IN NUMBER,
868 P_INIT_MSG_LIST IN VARCHAR2,
869 P_COMMIT IN VARCHAR2,
870 P_VALIDATION_LEVEL IN NUMBER,
871 P_LOAN_ID IN NUMBER,
872 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
873 X_MSG_COUNT OUT NOCOPY NUMBER,
874 X_MSG_DATA OUT NOCOPY VARCHAR2);
875
876
877
878 /*========================================================================
879 | PUBLIC PROCEDURE CANCEL_DISB_SCHEDULE
880 |
881 | DESCRIPTION
882 | This procedure only sets loan status to PENDING_CANCELLATION
883 |
884 | PSEUDO CODE/LOGIC
885 |
886 | PARAMETERS
887 | P_API_VERSION IN Standard in parameter
888 | P_INIT_MSG_LIST IN Standard in parameter
889 | P_COMMIT IN Standard in parameter
890 | P_VALIDATION_LEVEL IN Standard in parameter
891 | P_LOAN_ID IN Loan
892 | X_RETURN_STATUS OUT NOCOPY Standard out parameter
893 | X_MSG_COUNT OUT NOCOPY Standard out parameter
894 | X_MSG_DATA OUT NOCOPY Standard out parameter
895 |
896 | KNOWN ISSUES
897 | None
898 |
899 | NOTES
900 | Any interesting aspect of the code in the package body which needs
901 | to be stated.
902 |
903 | MODIFICATION HISTORY
904 | Date Author Description of Changes
905 | 07-26-2005 scherkas Created
906 |
907 *=======================================================================*/
908 PROCEDURE CANCEL_DISB_SCHEDULE(
909 P_API_VERSION IN NUMBER,
910 P_INIT_MSG_LIST IN VARCHAR2,
911 P_COMMIT IN VARCHAR2,
912 P_VALIDATION_LEVEL IN NUMBER,
913 P_LOAN_ID IN NUMBER,
914 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
915 X_MSG_COUNT OUT NOCOPY NUMBER,
916 X_MSG_DATA OUT NOCOPY VARCHAR2);
917
918
919
920 /*========================================================================
921 | PUBLIC PROCEDURE VALIDATE_DISB_FOR_APPR
922 |
923 | DESCRIPTION
924 | This procedure validates disbursement schedule for approval process.
925 |
926 | PSEUDO CODE/LOGIC
927 |
928 | PARAMETERS
929 | P_API_VERSION IN Standard in parameter
930 | P_INIT_MSG_LIST IN Standard in parameter
931 | P_COMMIT IN Standard in parameter
932 | P_VALIDATION_LEVEL IN Standard in parameter
933 | P_LOAN_ID IN Loan ID
934 | X_RETURN_STATUS OUT NOCOPY Standard out parameter
935 | X_MSG_COUNT OUT NOCOPY Standard out parameter
936 | X_MSG_DATA OUT NOCOPY Standard out parameter
937 |
938 | KNOWN ISSUES
939 | None
940 |
941 | NOTES
942 | Any interesting aspect of the code in the package body which needs
943 | to be stated.
944 |
945 | MODIFICATION HISTORY
946 | Date Author Description of Changes
947 | 11-08-2004 scherkas Created
948 |
949 *=======================================================================*/
950 PROCEDURE VALIDATE_DISB_FOR_APPR(
951 P_API_VERSION IN NUMBER,
952 P_INIT_MSG_LIST IN VARCHAR2,
953 P_COMMIT IN VARCHAR2,
954 P_VALIDATION_LEVEL IN NUMBER,
955 P_LOAN_ID IN NUMBER,
956 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
957 X_MSG_COUNT OUT NOCOPY NUMBER,
958 X_MSG_DATA OUT NOCOPY VARCHAR2);
959
960 /*************************** Old Stuff ******************************************/
961
962 TYPE LOAN_PAYEE_SITE_REC IS RECORD(
963 PAYEE_SITE_CODE VARCHAR2(15),
964 PAYEE_ID NUMBER,
965 ADDRESS_LINE1 VARCHAR2(240),
966 ADDRESS_LINE2 VARCHAR2(240),
967 ADDRESS_LINE3 VARCHAR2(240),
968 CITY VARCHAR2(25),
969 STATE VARCHAR2(150),
970 ZIP VARCHAR2(20),
971 PROVINCE VARCHAR2(150),
972 COUNTY VARCHAR2(150),
973 COUNTRY VARCHAR2(25)
974 );
975
976 TYPE SITE_CONTACT_REC IS RECORD(
977 PAYEE_SITE_ID NUMBER,
978 FIRST_NAME VARCHAR2(15),
979 LAST_NAME VARCHAR2(20),
980 TITLE VARCHAR2(30),
981 PHONE VARCHAR2(15),
982 FAX VARCHAR2(15),
983 EMAIL VARCHAR2(2000)
984 );
985
986 TYPE BANK_ACCOUNT_USE_REC IS RECORD(
987 PAYEE_ID NUMBER,
988 PAYEE_SITE_ID NUMBER,
989 BANK_ACCOUNT_ID NUMBER,
990 PRIMARY_FLAG VARCHAR2(1)
991 );
992
993 TYPE FUNDING_ADVICE_REC IS RECORD(
994 FUNDING_ADVICE_ID NUMBER, /* optional: if null - will insert new advice; otherwise - update advice */
995 LOAN_ID NUMBER, /* required */
996 LOAN_START_DATE DATE, /* required */
997 FIRST_PAYMENT_DATE DATE, /* required */
998 APPROVED_DATE DATE, /* for internal use - do not pass */
999 DUE_DATE DATE, /* required */
1000 AMOUNT NUMBER, /* required */
1001 CURRENCY VARCHAR2(15), /* required */
1002 DESCRIPTION VARCHAR2(255), /* optional, if not passed - standard value will be assigned */
1003 PAYMENT_METHOD VARCHAR2(30), /* required */
1004 PAYEE_ID NUMBER, /* required */
1005 PAYEE_SITE_ID NUMBER, /* required */
1006 SITE_CONTACT_ID NUMBER, /* optional */
1007 BANK_BRANCH_ID NUMBER, /* required */
1008 BANK_ACCOUNT_ID NUMBER, /* required */
1009 INVOICE_ID NUMBER, /* for internal use - do not pass */
1010 REQUEST_ID NUMBER, /* for internal use - do not pass */
1011 ADVICE_NUMBER VARCHAR2(60), /* optional, if not passed - standard value will be assigned */
1012 INVOICE_NUMBER VARCHAR2(50), /* optional, if not passed - standard value will be assigned */
1013 LOAN_STATUS VARCHAR2(30) /* for internal use - do not pass */
1014 );
1015
1016 TYPE INIT_FUNDING_ADVICE_REC IS RECORD(
1017 LOAN_ID NUMBER, /* required */
1018 PAYMENT_METHOD VARCHAR2(30), /* required */
1019 PAYEE_ID NUMBER, /* required */
1020 PAYEE_SITE_ID NUMBER, /* required */
1021 SITE_CONTACT_ID NUMBER, /* optional */
1022 BANK_BRANCH_ID NUMBER, /* required */
1023 BANK_ACCOUNT_ID NUMBER /* required */
1024 );
1025
1026
1027 /*========================================================================
1028 | PUBLIC PROCEDURE CREATE_PAYEE
1029 |
1030 | DESCRIPTION
1031 | This procedure creates loan payee in AP
1032 |
1033 | PSEUDO CODE/LOGIC
1034 |
1035 | PARAMETERS
1036 | P_API_VERSION IN Standard in parameter
1037 | P_INIT_MSG_LIST IN Standard in parameter
1038 | P_COMMIT IN Standard in parameter
1039 | P_VALIDATION_LEVEL IN Standard in parameter
1040 | P_PAYEE_REC IN Payee record
1041 | X_PAYEE_ID OUT NOCOPY Return payee id
1042 | X_RETURN_STATUS OUT NOCOPY Standard out parameter
1043 | X_MSG_COUNT OUT NOCOPY Standard out parameter
1044 | X_MSG_DATA OUT NOCOPY Standard out parameter
1045 |
1046 | KNOWN ISSUES
1047 | None
1048 |
1049 | NOTES
1050 |
1051 | MODIFICATION HISTORY
1052 | Date Author Description of Changes
1053 | 09-22-2004 scherkas Created
1054 |
1055 *=======================================================================*/
1056 PROCEDURE CREATE_PAYEE(
1057 P_API_VERSION IN NUMBER,
1058 P_INIT_MSG_LIST IN VARCHAR2,
1059 P_COMMIT IN VARCHAR2,
1060 P_VALIDATION_LEVEL IN NUMBER,
1061 P_PAYEE_REC IN LNS_FUNDING_PUB.LOAN_PAYEE_REC,
1062 X_PAYEE_ID OUT NOCOPY NUMBER,
1063 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1064 X_MSG_COUNT OUT NOCOPY NUMBER,
1065 X_MSG_DATA OUT NOCOPY VARCHAR2);
1066
1067
1068
1069 /*========================================================================
1070 | PUBLIC PROCEDURE CREATE_PAYEE_SITE
1071 |
1072 | DESCRIPTION
1073 | This procedure creates loan payee site in AP
1074 |
1075 | PSEUDO CODE/LOGIC
1076 |
1077 | PARAMETERS
1078 | P_API_VERSION IN Standard in parameter
1079 | P_INIT_MSG_LIST IN Standard in parameter
1080 | P_COMMIT IN Standard in parameter
1081 | P_VALIDATION_LEVEL IN Standard in parameter
1082 | P_PAYEE_SITE_REC IN Payee record
1083 | X_PAYEE_SITE_ID OUT NOCOPY Returns payee site id
1084 | X_RETURN_STATUS OUT NOCOPY Standard out parameter
1085 | X_MSG_COUNT OUT NOCOPY Standard out parameter
1086 | X_MSG_DATA OUT NOCOPY Standard out parameter
1087 |
1088 | KNOWN ISSUES
1089 | None
1090 |
1091 | NOTES
1092 |
1093 | MODIFICATION HISTORY
1094 | Date Author Description of Changes
1095 | 09-22-2004 scherkas Created
1096 |
1097 *=======================================================================*/
1098 PROCEDURE CREATE_PAYEE_SITE(
1099 P_API_VERSION IN NUMBER,
1100 P_INIT_MSG_LIST IN VARCHAR2,
1101 P_COMMIT IN VARCHAR2,
1102 P_VALIDATION_LEVEL IN NUMBER,
1103 P_PAYEE_SITE_REC IN LNS_FUNDING_PUB.LOAN_PAYEE_SITE_REC,
1104 X_PAYEE_SITE_ID OUT NOCOPY NUMBER,
1105 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1106 X_MSG_COUNT OUT NOCOPY NUMBER,
1107 X_MSG_DATA OUT NOCOPY VARCHAR2);
1108
1109
1110
1111 /*========================================================================
1112 | PUBLIC PROCEDURE CREATE_SITE_CONTACT
1113 |
1114 | DESCRIPTION
1115 | This procedure creates site contact in AP
1116 |
1117 | PSEUDO CODE/LOGIC
1118 |
1119 | PARAMETERS
1120 | P_API_VERSION IN Standard in parameter
1121 | P_INIT_MSG_LIST IN Standard in parameter
1122 | P_COMMIT IN Standard in parameter
1123 | P_VALIDATION_LEVEL IN Standard in parameter
1124 | P_SITE_CONTACT_REC IN Site contact record
1125 | X_SITE_CONTACT_ID OUT NOCOPY Returns site contact id
1126 | X_RETURN_STATUS OUT NOCOPY Standard out parameter
1127 | X_MSG_COUNT OUT NOCOPY Standard out parameter
1128 | X_MSG_DATA OUT NOCOPY Standard out parameter
1129 |
1130 | KNOWN ISSUES
1131 | None
1132 |
1133 | NOTES
1134 | Any interesting aspect of the code in the package body which needs
1135 | to be stated.
1136 |
1137 | MODIFICATION HISTORY
1138 | Date Author Description of Changes
1139 | 09-22-2004 scherkas Created
1140 |
1141 *=======================================================================*/
1142 PROCEDURE CREATE_SITE_CONTACT(
1143 P_API_VERSION IN NUMBER,
1144 P_INIT_MSG_LIST IN VARCHAR2,
1145 P_COMMIT IN VARCHAR2,
1146 P_VALIDATION_LEVEL IN NUMBER,
1147 P_SITE_CONTACT_REC IN LNS_FUNDING_PUB.SITE_CONTACT_REC,
1148 X_SITE_CONTACT_ID OUT NOCOPY NUMBER,
1149 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1150 X_MSG_COUNT OUT NOCOPY NUMBER,
1151 X_MSG_DATA OUT NOCOPY VARCHAR2);
1152
1153
1154
1155 /*========================================================================
1156 | PUBLIC PROCEDURE CREATE_BANK_ACC_USE
1157 |
1158 | DESCRIPTION
1159 | This procedure creates bank account use.
1160 |
1161 | PSEUDO CODE/LOGIC
1162 |
1163 | PARAMETERS
1164 | P_API_VERSION IN Standard in parameter
1165 | P_INIT_MSG_LIST IN Standard in parameter
1166 | P_COMMIT IN Standard in parameter
1167 | P_VALIDATION_LEVEL IN Standard in parameter
1168 | P_BANK_ACC_USE_REC IN Bank account use record
1169 | X_BANK_ACC_USE_ID OUT NOCOPY Returns bank account use id
1170 | X_RETURN_STATUS OUT NOCOPY Standard out parameter
1171 | X_MSG_COUNT OUT NOCOPY Standard out parameter
1172 | X_MSG_DATA OUT NOCOPY Standard out parameter
1173 |
1174 | KNOWN ISSUES
1175 | None
1176 |
1177 | NOTES
1178 | Any interesting aspect of the code in the package body which needs
1179 | to be stated.
1180 |
1181 | MODIFICATION HISTORY
1182 | Date Author Description of Changes
1183 | 11-12-2004 scherkas Created
1184 |
1185 *=======================================================================*/
1186 PROCEDURE CREATE_BANK_ACC_USE(
1187 P_API_VERSION IN NUMBER,
1188 P_INIT_MSG_LIST IN VARCHAR2,
1189 P_COMMIT IN VARCHAR2,
1190 P_VALIDATION_LEVEL IN NUMBER,
1191 P_BANK_ACC_USE_REC IN LNS_FUNDING_PUB.BANK_ACCOUNT_USE_REC,
1192 X_BANK_ACC_USE_ID OUT NOCOPY NUMBER,
1193 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1194 X_MSG_COUNT OUT NOCOPY NUMBER,
1195 X_MSG_DATA OUT NOCOPY VARCHAR2);
1196
1197
1198
1199 /*========================================================================
1200 | PUBLIC PROCEDURE INIT_FUNDING_ADVICE
1201 |
1202 | DESCRIPTION
1203 | This procedure inits funding advice.
1204 |
1205 | PSEUDO CODE/LOGIC
1206 |
1207 | PARAMETERS
1208 | P_API_VERSION IN Standard in parameter
1209 | P_INIT_MSG_LIST IN Standard in parameter
1210 | P_COMMIT IN Standard in parameter
1211 | P_VALIDATION_LEVEL IN Standard in parameter
1212 | P_INIT_FUNDING_REC IN Init funding advice record
1213 | X_FUNDING_ADVICE_ID OUT NOCOPY Returns funding advice id
1214 | X_RETURN_STATUS OUT NOCOPY Standard out parameter
1215 | X_MSG_COUNT OUT NOCOPY Standard out parameter
1216 | X_MSG_DATA OUT NOCOPY Standard out parameter
1217 |
1218 | KNOWN ISSUES
1219 | None
1220 |
1221 | NOTES
1222 |
1223 | MODIFICATION HISTORY
1224 | Date Author Description of Changes
1225 | 11-03-2004 scherkas Created
1226 |
1227 *=======================================================================*/
1228 PROCEDURE INIT_FUNDING_ADVICE(
1229 P_API_VERSION IN NUMBER,
1230 P_INIT_MSG_LIST IN VARCHAR2,
1231 P_COMMIT IN VARCHAR2,
1232 P_VALIDATION_LEVEL IN NUMBER,
1233 P_INIT_FUNDING_REC IN LNS_FUNDING_PUB.INIT_FUNDING_ADVICE_REC,
1234 X_FUNDING_ADVICE_ID OUT NOCOPY NUMBER,
1235 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1236 X_MSG_COUNT OUT NOCOPY NUMBER,
1237 X_MSG_DATA OUT NOCOPY VARCHAR2);
1238
1239
1240
1241
1242 /*========================================================================
1243 | PUBLIC PROCEDURE VALIDATE_FUNDING_ADVICE
1244 |
1245 | DESCRIPTION
1246 | This procedure validates funding advice.
1247 |
1248 | PSEUDO CODE/LOGIC
1249 |
1250 | PARAMETERS
1251 | P_API_VERSION IN Standard in parameter
1252 | P_INIT_MSG_LIST IN Standard in parameter
1253 | P_COMMIT IN Standard in parameter
1254 | P_VALIDATION_LEVEL IN Standard in parameter
1255 | P_LOAN_ID IN Loan ID
1256 | X_RETURN_STATUS OUT NOCOPY Standard out parameter
1257 | X_MSG_COUNT OUT NOCOPY Standard out parameter
1258 | X_MSG_DATA OUT NOCOPY Standard out parameter
1259 |
1260 | KNOWN ISSUES
1261 | None
1262 |
1263 | NOTES
1264 | Any interesting aspect of the code in the package body which needs
1265 | to be stated.
1266 |
1267 | MODIFICATION HISTORY
1268 | Date Author Description of Changes
1269 | 11-08-2004 scherkas Created
1270 |
1271 *=======================================================================*/
1272 PROCEDURE VALIDATE_FUNDING_ADVICE(
1273 P_API_VERSION IN NUMBER,
1274 P_INIT_MSG_LIST IN VARCHAR2,
1275 P_COMMIT IN VARCHAR2,
1276 P_VALIDATION_LEVEL IN NUMBER,
1277 P_LOAN_ID IN NUMBER,
1278 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1279 X_MSG_COUNT OUT NOCOPY NUMBER,
1280 X_MSG_DATA OUT NOCOPY VARCHAR2);
1281
1282
1283
1284 /*========================================================================
1285 | PUBLIC PROCEDURE CREATE_FUNDING_ADVICE
1286 |
1287 | DESCRIPTION
1288 | This procedure is for automatic funding advice creation.
1289 |
1290 | PSEUDO CODE/LOGIC
1291 |
1292 | PARAMETERS
1293 | P_API_VERSION IN Standard in parameter
1294 | P_INIT_MSG_LIST IN Standard in parameter
1295 | P_COMMIT IN Standard in parameter
1296 | P_VALIDATION_LEVEL IN Standard in parameter
1297 | P_LOAN_ID IN Loan ID
1298 | X_FUNDING_ADVICE_ID OUT NOCOPY Returns funding advice id
1299 | X_RETURN_STATUS OUT NOCOPY Standard out parameter
1300 | X_MSG_COUNT OUT NOCOPY Standard out parameter
1301 | X_MSG_DATA OUT NOCOPY Standard out parameter
1302 |
1303 | KNOWN ISSUES
1304 | None
1305 |
1306 | NOTES
1307 |
1308 | MODIFICATION HISTORY
1309 | Date Author Description of Changes
1310 | 11-03-2004 scherkas Created
1311 |
1312 *=======================================================================*/
1313 PROCEDURE CREATE_FUNDING_ADVICE(
1314 P_API_VERSION IN NUMBER,
1315 P_INIT_MSG_LIST IN VARCHAR2,
1316 P_COMMIT IN VARCHAR2,
1317 P_VALIDATION_LEVEL IN NUMBER,
1318 P_LOAN_ID IN NUMBER,
1319 X_FUNDING_ADVICE_ID OUT NOCOPY NUMBER,
1320 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1321 X_MSG_COUNT OUT NOCOPY NUMBER,
1322 X_MSG_DATA OUT NOCOPY VARCHAR2);
1323
1324
1325
1326
1327 /*========================================================================
1328 | PUBLIC PROCEDURE CREATE_FUNDING_ADVICE
1329 |
1330 | DESCRIPTION
1331 | This procedure creates funding advice.
1332 |
1333 | PSEUDO CODE/LOGIC
1334 |
1335 | PARAMETERS
1336 | P_API_VERSION IN Standard in parameter
1337 | P_INIT_MSG_LIST IN Standard in parameter
1338 | P_COMMIT IN Standard in parameter
1339 | P_VALIDATION_LEVEL IN Standard in parameter
1340 | P_FUNDING_ADVICE_REC IN Funding advice record
1341 | X_FUNDING_ADVICE_ID OUT NOCOPY Returns funding advice id
1342 | X_RETURN_STATUS OUT NOCOPY Standard out parameter
1343 | X_MSG_COUNT OUT NOCOPY Standard out parameter
1344 | X_MSG_DATA OUT NOCOPY Standard out parameter
1345 |
1346 | KNOWN ISSUES
1347 | None
1348 |
1349 | NOTES
1350 |
1351 | MODIFICATION HISTORY
1352 | Date Author Description of Changes
1353 | 11-03-2004 scherkas Created
1354 |
1355 *=======================================================================*/
1356 PROCEDURE CREATE_FUNDING_ADVICE(
1357 P_API_VERSION IN NUMBER,
1358 P_INIT_MSG_LIST IN VARCHAR2,
1359 P_COMMIT IN VARCHAR2,
1360 P_VALIDATION_LEVEL IN NUMBER,
1361 P_FUNDING_ADVICE_REC IN LNS_FUNDING_PUB.FUNDING_ADVICE_REC,
1362 X_FUNDING_ADVICE_ID OUT NOCOPY NUMBER,
1363 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1364 X_MSG_COUNT OUT NOCOPY NUMBER,
1365 X_MSG_DATA OUT NOCOPY VARCHAR2);
1366
1367
1368
1369 /*========================================================================
1370 | PUBLIC FUNCTION GET_FUNDING_ADVICE_NUMBER
1371 |
1372 | DESCRIPTION
1373 | This procedure generates new funding advice number.
1374 |
1375 | PSEUDO CODE/LOGIC
1376 |
1377 | PARAMETERS
1378 | P_LOAN_ID IN Loan ID
1379 |
1380 | KNOWN ISSUES
1381 | None
1382 |
1383 | NOTES
1384 |
1385 | MODIFICATION HISTORY
1386 | Date Author Description of Changes
1387 | 11-03-2004 scherkas Created
1388 |
1389 *=======================================================================*/
1390 FUNCTION GET_FUNDING_ADVICE_NUMBER(P_LOAN_ID IN NUMBER) RETURN VARCHAR2;
1391
1392
1393
1394 /*========================================================================
1395 | PUBLIC FUNCTION GET_FUNDING_ADVICE_DESC
1396 |
1397 | DESCRIPTION
1398 | This procedure generates new funding advice description.
1399 |
1400 | PSEUDO CODE/LOGIC
1401 |
1402 | PARAMETERS
1403 | P_LOAN_ID IN Loan ID
1404 |
1405 | KNOWN ISSUES
1406 | None
1407 |
1408 | NOTES
1409 | Any interesting aspect of the code in the package body which needs
1410 | to be stated.
1411 |
1412 | MODIFICATION HISTORY
1413 | Date Author Description of Changes
1414 | 11-03-2004 scherkas Created
1415 |
1416 *=======================================================================*/
1417 FUNCTION GET_FUNDING_ADVICE_DESC(P_LOAN_ID IN NUMBER) RETURN VARCHAR2;
1418
1419
1420 /*========================================================================
1421 | PUBLIC PROCEDURE CHECK_FUNDING_STATUS
1422 |
1423 | DESCRIPTION
1424 | This procedure checks for funding status of:
1425 | - all funding advices or
1426 | - all funding advices for particular loan or
1427 | - one particular funding advice
1428 |
1429 | PSEUDO CODE/LOGIC
1430 |
1431 | PARAMETERS
1432 | P_API_VERSION IN Standard in parameter
1433 | P_INIT_MSG_LIST IN Standard in parameter
1434 | P_COMMIT IN Standard in parameter
1435 | P_VALIDATION_LEVEL IN Standard in parameter
1436 | P_LOAN_ID IN Loan ID
1437 | P_FUNDING_ADVICE_ID IN Funding advice ID
1438 | X_RETURN_STATUS OUT NOCOPY Standard out parameter
1439 | X_MSG_COUNT OUT NOCOPY Standard out parameter
1440 | X_MSG_DATA OUT NOCOPY Standard out parameter
1441 |
1442 | KNOWN ISSUES
1443 | None
1444 |
1445 | NOTES
1446 | Any interesting aspect of the code in the package body which needs
1447 | to be stated.
1448 |
1449 | MODIFICATION HISTORY
1450 | Date Author Description of Changes
1451 | 11-30-2004 scherkas Created
1452 |
1453 *=======================================================================*/
1454 PROCEDURE CHECK_FUNDING_STATUS(
1455 P_API_VERSION IN NUMBER,
1456 P_INIT_MSG_LIST IN VARCHAR2,
1457 P_COMMIT IN VARCHAR2,
1458 P_VALIDATION_LEVEL IN NUMBER,
1459 P_LOAN_ID IN NUMBER,
1460 P_FUNDING_ADVICE_ID IN NUMBER,
1461 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1462 X_MSG_COUNT OUT NOCOPY NUMBER,
1463 X_MSG_DATA OUT NOCOPY VARCHAR2);
1464
1465
1466
1467
1468 /*========================================================================
1469 | PUBLIC PROCEDURE LNS_CHK_FUND_STAT_CONCUR
1470 |
1471 | DESCRIPTION
1472 | This procedure got called from concurent manager to check funding status
1473 |
1474 | PSEUDO CODE/LOGIC
1475 |
1476 | PARAMETERS
1477 | ERRBUF OUT Returns errors to CM
1478 | RETCODE OUT Returns error code to CM
1479 | LOAN_ID IN Inputs loan
1480 | FUNDING_ADVICE_ID IN Input funding advice
1481 |
1482 | KNOWN ISSUES
1483 | None
1484 |
1485 | NOTES
1486 | Any interesting aspect of the code in the package body which needs
1487 | to be stated.
1488 |
1489 | MODIFICATION HISTORY
1490 | Date Author Description of Changes
1491 | 12-02-2004 scherkas Created
1492 |
1493 *=======================================================================*/
1494 PROCEDURE LNS_CHK_FUND_STAT_CONCUR(
1495 ERRBUF OUT NOCOPY VARCHAR2,
1496 RETCODE OUT NOCOPY VARCHAR2,
1497 LOAN_ID IN NUMBER,
1498 FUNDING_ADVICE_ID IN NUMBER);
1499
1500
1501
1502 /*========================================================================
1503 | PUBLIC PROCEDURE VALIDATE_DISB_FOR_PAYOFF
1504 |
1505 | DESCRIPTION
1506 | This procedure validates disbursements for payoff process
1507 |
1508 | PSEUDO CODE/LOGIC
1509 |
1510 | PARAMETERS
1511 | P_API_VERSION IN Standard in parameter
1512 | P_INIT_MSG_LIST IN Standard in parameter
1513 | P_COMMIT IN Standard in parameter
1514 | P_VALIDATION_LEVEL IN Standard in parameter
1515 | P_LOAN_ID IN Loan ID
1516 | X_RETURN_STATUS OUT NOCOPY Standard out parameter
1517 | X_MSG_COUNT OUT NOCOPY Standard out parameter
1518 | X_MSG_DATA OUT NOCOPY Standard out parameter
1519 |
1520 | KNOWN ISSUES
1521 | None
1522 |
1523 | NOTES
1524 | Any interesting aspect of the code in the package body which needs
1525 | to be stated.
1526 |
1527 | MODIFICATION HISTORY
1528 | Date Author Description of Changes
1529 | 12-08-2005 scherkas Created
1530 |
1531 *=======================================================================*/
1532 PROCEDURE VALIDATE_DISB_FOR_PAYOFF(
1533 P_API_VERSION IN NUMBER,
1534 P_INIT_MSG_LIST IN VARCHAR2,
1535 P_COMMIT IN VARCHAR2,
1536 P_VALIDATION_LEVEL IN NUMBER,
1537 P_LOAN_ID IN NUMBER,
1538 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1539 X_MSG_COUNT OUT NOCOPY NUMBER,
1540 X_MSG_DATA OUT NOCOPY VARCHAR2);
1541
1542
1543
1544
1545 END LNS_FUNDING_PUB;