1 PACKAGE LNS_REP_UTILS AUTHID CURRENT_USER as
2 /* $Header: LNS_REP_UTILS_S.pls 120.10 2011/01/25 14:10:10 scherkas 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 | 22-MAY-2009 GPARUCHU Bug#8428048 - New parameter P_REASON added to denote the reason for generating
119 | a new agreement report.
120 *=======================================================================*/
121 PROCEDURE PROCESS_AGREEMENT_REPORT(ERRBUF OUT NOCOPY VARCHAR2
122 ,RETCODE OUT NOCOPY VARCHAR2
123 ,LOAN_ID IN NUMBER
124 ,P_GENERATE_AGREEMENT IN VARCHAR2 DEFAULT 'N'
125 ,P_REASON IN VARCHAR2 DEFAULT NULL
126 );
127 PROCEDURE STORE_LOAN_AGREEMENT (P_LOAN_ID IN NUMBER
128 ,P_AGREEMENT_REASON IN VARCHAR2 DEFAULT NULL
129 );
130
131 PROCEDURE LNS_TRANSFER_LOANS_CONCUR(ERRBUF OUT NOCOPY VARCHAR2
132 ,RETCODE OUT NOCOPY VARCHAR2
133 ,P_FROM_LOAN_OFFICER IN NUMBER
134 ,P_TO_LOAN_OFFICER IN NUMBER
135 );
136
137 FUNCTION REPLACE_SPECIAL_CHARS (P_XML_DATA IN VARCHAR2)
138 RETURN VARCHAR2;
139
140 PROCEDURE STORE_LOAN_AGREEMENT_CP (P_LOAN_ID IN NUMBER
141 ,P_AGREEMENT_REASON IN VARCHAR2);
142
143 /*========================================================================
144 | PUBLIC PROCEDURE LNS_SET_ACCESS_LEVEL_CONCUR
145 |
146 | DESCRIPTION
147 | This procedure does mass access level assignment for borrowers, co-borrowers and guarantors.
148 |
149 | PSEUDO CODE/LOGIC
150 |
151 | PARAMETERS
152 | ERRBUF OUT Returns errors to CM
153 | RETCODE OUT Returns error code to CM
154 | ORG_ID IN Inputs org id
155 | BORROWER_ID IN Inputs borrower id
156 | PRODUCT_ID IN Inputs product id
157 | BORR_ACCESS_LEVEL IN Inputs primary borrower access level
158 | COBORR_ACCESS_LEVEL IN Inputs co-borrower access level
159 | GUAR_ACCESS_LEVEL IN Inputs guarantor access level
160 | FROM_LOAN_OFFICER IN Inputs from loan officer
161 | TO_LOAN_OFFICER IN Inputs to loan officer
162 |
163 | KNOWN ISSUES
164 | None
165 |
166 | NOTES
167 | Any interesting aspect of the code in the package body which needs
168 | to be stated.
169 |
170 | MODIFICATION HISTORY
171 | Date Author Description of Changes
172 | 28-07-2010 scherkas Created
173 |
174 *=======================================================================*/
175 PROCEDURE LNS_SET_ACCESS_LEVEL_CONCUR(
176 ERRBUF OUT NOCOPY VARCHAR2,
177 RETCODE OUT NOCOPY VARCHAR2,
178 ORG_ID IN NUMBER,
179 BORROWER_ID IN NUMBER,
180 PRODUCT_ID IN NUMBER,
181 BORR_ACCESS_LEVEL IN VARCHAR2,
182 COBORR_ACCESS_LEVEL IN VARCHAR2,
183 GUAR_ACCESS_LEVEL IN VARCHAR2);
184
185
186 PROCEDURE LNS_EXPORT_AM_SCHEDS_CONCUR(
187 ERRBUF OUT NOCOPY VARCHAR2,
188 RETCODE OUT NOCOPY VARCHAR2,
189 ORG_ID IN NUMBER, -- if null, will not filter by lorg
190 BORROWER_ID IN NUMBER, -- if null, will not filter by borrower
191 PRODUCT_ID IN NUMBER, -- if null, will not filter by product
192 LOAN_STATUS1 IN VARCHAR2, -- if null, will not filter by loan status
193 LOAN_STATUS2 IN VARCHAR2, -- if null, will not filter by loan status
194 LOAN_STATUS3 IN VARCHAR2, -- if null, will not filter by loan status
195 LOAN_ID IN NUMBER, -- if null, will not filter by loan
196 SCHEDULE_TYPE IN VARCHAR2, -- values: CURRENT/ORIGINAL/BOTH; if null, will export CURRENT schedule
197 TRUNCATE_HISTORY IN VARCHAR2); -- values: NO/PROCESSED_LOANS/ALL; if null, will use NO
198
199
200 END LNS_REP_UTILS;