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