1 PACKAGE LNS_REP_UTILS AUTHID CURRENT_USER as
2 /* $Header: LNS_REP_UTILS_S.pls 120.2.12000000.2 2007/07/15 12:54:13 mbolli ship $ */
3 /*=======================================================================+
4 | Package Global Constants
5 +=======================================================================*/
6
7 g_loan_start_date_from DATE;
8 g_loan_start_date_to DATE;
9 g_bill_due_date_from DATE;
10 g_bill_due_date_to DATE;
11
12 /*=======================================================================+
13 | Declare PUBLIC Data Types and Variables
14 +=======================================================================*/
15 /*========================================================================+
16 Function which returns the global variable g_loan_start_date_from
17 ========================================================================*/
18
19 FUNCTION get_loan_start_date_from return DATE;
20
21 /*========================================================================+
22 Function which returns the global variable g_loan_start_date_to
23 ========================================================================*/
24
25 FUNCTION get_loan_start_date_to return DATE;
26 /*========================================================================+
27 Function which returns the global variable g_bill_due_date_from
28 ========================================================================*/
29
30 FUNCTION get_bill_due_date_from return DATE;
31
32 /*========================================================================+
33 Function which returns the global variable g_bill_due_date_to
34 ========================================================================*/
35
36 FUNCTION get_bill_due_date_to return DATE;
37 /*========================================================================
38 | PUBLIC PROCEDURE PRINT_CLOB
39 |
40 | DESCRIPTION
41 | This process selects the process to run.
42 |
43 | PSEUDO CODE/LOGIC
44 |
45 | PARAMETERS
46 | P_PARAM1 IN Standard in parameter
47 | X_PARAM2 OUT NOCOPY Standard out parameter
48 |
49 | KNOWN ISSUES
50 | None
51 |
52 | NOTES
53 |
54 | MODIFICATION HISTORY
55 | Date Author Description of Changes
56 | 17-Jan-2005 GBELLARY Created
57 | 07-Mar-2005 GBELLARY Added procedures and functions for
58 | Loan Reconciliation Report.
59 | 08-Mar-2005 GBELLARY Changed order of parameters
60 | in PROCESS_RECON_REPORT.
61 | 23-Aug-2005 GBELLARY Changed/ added parameters
62 | in PROCESS_RECON_REPORT
63 | and PROCESS_PORTFOLIO_REPORT
64 |
65 *=======================================================================*/
66 PROCEDURE PRINT_CLOB ( lob_loc in clob);
67 PROCEDURE PROCESS_PORTFOLIO_REPORT(ERRBUF OUT NOCOPY VARCHAR2
68 ,RETCODE OUT NOCOPY VARCHAR2
69 ,LOAN_CLASS IN VARCHAR2
70 ,LOAN_TYPE_ID IN NUMBER
71 ,CURRENCY_CODE IN VARCHAR2
72 ,LOAN_NUMBER IN VARCHAR2
73 ,BORROWER_ID IN NUMBER
74 ,CUST_ACCOUNT_ID IN NUMBER
75 ,LOAN_START_DATE_FROM IN VARCHAR2
76 ,LOAN_START_DATE_TO IN VARCHAR2
77 ,LEGAL_ENTITY_ID IN NUMBER
78 ,PRODUCT_ID IN NUMBER
79 ,LOAN_ASSIGNED_TO IN NUMBER
80 ,LOAN_STATUS1 IN VARCHAR2
81 ,LOAN_STATUS2 IN VARCHAR2
82 ,INCLUDE_CHARTS IN VARCHAR2
83 );
84 PROCEDURE PROCESS_RECON_REPORT(ERRBUF OUT NOCOPY VARCHAR2
85 ,RETCODE OUT NOCOPY VARCHAR2
86 ,LOAN_CLASS IN VARCHAR2
87 ,LOAN_TYPE_ID IN NUMBER
88 ,CURRENCY_CODE IN VARCHAR2
89 ,BILL_DUE_DATE_FROM IN VARCHAR2
90 ,BILL_DUE_DATE_TO IN VARCHAR2
91 ,LEGAL_ENTITY_ID IN NUMBER
92 ,LOAN_NUMBER IN VARCHAR2
93 ,BORROWER_ID IN NUMBER
94 ,CUST_ACCOUNT_ID IN NUMBER
95 ,LOAN_ASSIGNED_TO IN NUMBER
96 );
97 /*========================================================================
98 | PUBLIC PROCEDURE PRINT_CLOB
99 |
100 | DESCRIPTION
101 | This process selects the process to run.
102 |
103 | PSEUDO CODE/LOGIC
104 |
105 | PARAMETERS
106 | P_PARAM1 IN Standard in parameter
107 | X_PARAM2 OUT NOCOPY Standard out parameter
108 |
109 | KNOWN ISSUES
110 | None
111 |
112 | NOTES
113 |
114 | MODIFICATION HISTORY
115 | Date Author Description of Changes
116 | 13-JUL-2007 MBOLLI Bug#6169438 - New Parameter 'P_GENERATE_AGREEMENT', which
117 | implies the loan agreement must be regenereated if the value is 'Y'.
118 *=======================================================================*/
119 PROCEDURE PROCESS_AGREEMENT_REPORT(ERRBUF OUT NOCOPY VARCHAR2
120 ,RETCODE OUT NOCOPY VARCHAR2
121 ,LOAN_ID IN NUMBER
122 ,P_GENERATE_AGREEMENT IN VARCHAR2 DEFAULT 'N'
123 );
124 PROCEDURE STORE_LOAN_AGREEMENT (P_LOAN_ID IN NUMBER);
125 END LNS_REP_UTILS;