1 PACKAGE LNS_EXT_LOAN_PUB AUTHID CURRENT_USER as
2 /* $Header: LNS_EXT_LOAN_S.pls 120.0.12010000.1 2008/11/25 14:14:59 scherkas noship $ */
3
4 /*=======================================================================+
5 | Declare PUBLIC Data Types and Variables
6 +=======================================================================*/
7
8 TYPE LOAN_EXT_REC IS RECORD(
9 LOAN_EXT_ID NUMBER,
10 LOAN_ID NUMBER,
11 DESCRIPTION VARCHAR2(30),
12 EXT_TERM NUMBER,
13 EXT_TERM_PERIOD VARCHAR2(30),
14 EXT_BALLOON_TYPE VARCHAR2(30),
15 EXT_BALLOON_AMOUNT NUMBER,
16 EXT_AMORT_TERM NUMBER,
17 EXT_RATE NUMBER,
18 EXT_SPREAD NUMBER,
19 EXT_IO_FLAG VARCHAR2(1),
20 EXT_FLOATING_FLAG VARCHAR2(1),
21 EXT_INDEX_DATE DATE
22 );
23
24
25 -- this record type is for calculating new loan terms
26 TYPE NEW_TERM_REC IS RECORD(
27 LOAN_ID NUMBER, -- in/out; required
28 EXT_TERM NUMBER, -- in/out; required
29 EXT_TERM_PERIOD VARCHAR2(30), -- in/out; required
30 EXT_BALLOON_TYPE VARCHAR2(30), -- in/out; required
31 EXT_BALLOON_AMOUNT NUMBER, -- in/out; required
32 EXT_AMORT_TERM NUMBER, -- in/out; required
33 OLD_TERM NUMBER, -- out
34 OLD_TERM_PERIOD VARCHAR2(30), -- out
35 OLD_BALLOON_TYPE VARCHAR2(30), -- out
36 OLD_BALLOON_AMOUNT NUMBER, -- out
37 OLD_AMORT_TERM NUMBER, -- out
38 OLD_MATURITY_DATE DATE, -- out
39 OLD_INSTALLMENTS NUMBER, -- out
40 NEW_TERM NUMBER, -- out
41 NEW_TERM_PERIOD VARCHAR2(30), -- out
42 NEW_BALLOON_TYPE VARCHAR2(30), -- out
43 NEW_BALLOON_AMOUNT NUMBER, -- out
44 NEW_AMORT_TERM NUMBER, -- out
45 NEW_MATURITY_DATE DATE, -- out
46 -- BEGIN_EXT_INSTAL_NUMBER NUMBER, -- out
47 -- END_EXT_INSTAL_NUMBER NUMBER, -- out
48 NEW_INSTALLMENTS NUMBER -- out
49 );
50
51
52
53 /*========================================================================
54 | PUBLIC PROCEDURE SAVE_LOAN_EXTENSION
55 |
56 | DESCRIPTION
57 | This procedure inserts/updates loan extension in lns_loan_extensions table
58 |
59 | PSEUDO CODE/LOGIC
60 |
61 | PARAMETERS
62 | P_API_VERSION IN Standard in parameter
63 | P_INIT_MSG_LIST IN Standard in parameter
64 | P_COMMIT IN Standard in parameter
65 | P_VALIDATION_LEVEL IN Standard in parameter
66 | P_LOAN_EXT_REC IN OUT NOCOPY LNS_EXT_LOAN_PUB.LOAN_EXT_REC record
67 | X_RETURN_STATUS OUT NOCOPY Standard out parameter
68 | X_MSG_COUNT OUT NOCOPY Standard out parameter
69 | X_MSG_DATA OUT NOCOPY Standard out parameter
70 |
71 | KNOWN ISSUES
72 | None
73 |
74 | NOTES
75 |
76 | MODIFICATION HISTORY
77 | Date Author Description of Changes
78 | 09-25-2007 scherkas Created
79 |
80 *=======================================================================*/
81 PROCEDURE SAVE_LOAN_EXTENSION(
82 P_API_VERSION IN NUMBER,
83 P_INIT_MSG_LIST IN VARCHAR2,
84 P_COMMIT IN VARCHAR2,
85 P_VALIDATION_LEVEL IN NUMBER,
86 P_LOAN_EXT_REC IN OUT NOCOPY LNS_EXT_LOAN_PUB.LOAN_EXT_REC,
87 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
88 X_MSG_COUNT OUT NOCOPY NUMBER,
89 X_MSG_DATA OUT NOCOPY VARCHAR2);
90
91
92
93 /*========================================================================
94 | PUBLIC PROCEDURE APPROVE_LOAN_EXTENSION
95 |
96 | DESCRIPTION
97 | This procedure approves loan extension and updates loan term data in
98 | lns_loan_headers_all from lns_loan_extensions table
99 |
100 | PSEUDO CODE/LOGIC
101 |
102 | PARAMETERS
103 | P_API_VERSION IN Standard in parameter
104 | P_INIT_MSG_LIST IN Standard in parameter
105 | P_COMMIT IN Standard in parameter
106 | P_VALIDATION_LEVEL IN Standard in parameter
107 | P_LOAN_EXT_ID IN Loan extension ID
108 | X_RETURN_STATUS OUT NOCOPY Standard out parameter
109 | X_MSG_COUNT OUT NOCOPY Standard out parameter
110 | X_MSG_DATA OUT NOCOPY Standard out parameter
111 |
112 | KNOWN ISSUES
113 | None
114 |
115 | NOTES
116 |
117 | MODIFICATION HISTORY
118 | Date Author Description of Changes
119 | 09-25-2007 scherkas Created
120 |
121 *=======================================================================*/
122 PROCEDURE APPROVE_LOAN_EXTENSION(
123 P_API_VERSION IN NUMBER,
124 P_INIT_MSG_LIST IN VARCHAR2,
125 P_COMMIT IN VARCHAR2,
126 P_VALIDATION_LEVEL IN NUMBER,
127 P_LOAN_EXT_ID IN NUMBER,
128 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
129 X_MSG_COUNT OUT NOCOPY NUMBER,
130 X_MSG_DATA OUT NOCOPY VARCHAR2);
131
132
133
134 /*========================================================================
135 | PUBLIC PROCEDURE REJECT_LOAN_EXTENSION
136 |
137 | DESCRIPTION
138 | This procedure rejects loan extension. No changes is made in lns_loan_headers_all table
139 |
140 | PSEUDO CODE/LOGIC
141 |
142 | PARAMETERS
143 | P_API_VERSION IN Standard in parameter
144 | P_INIT_MSG_LIST IN Standard in parameter
145 | P_COMMIT IN Standard in parameter
146 | P_VALIDATION_LEVEL IN Standard in parameter
147 | P_LOAN_EXT_ID IN Loan extension ID
148 | X_RETURN_STATUS OUT NOCOPY Standard out parameter
149 | X_MSG_COUNT OUT NOCOPY Standard out parameter
150 | X_MSG_DATA OUT NOCOPY Standard out parameter
151 |
152 | KNOWN ISSUES
153 | None
154 |
155 | NOTES
156 |
157 | MODIFICATION HISTORY
158 | Date Author Description of Changes
159 | 09-25-2007 scherkas Created
160 |
161 *=======================================================================*/
162 PROCEDURE REJECT_LOAN_EXTENSION(
163 P_API_VERSION IN NUMBER,
164 P_INIT_MSG_LIST IN VARCHAR2,
165 P_COMMIT IN VARCHAR2,
166 P_VALIDATION_LEVEL IN NUMBER,
167 P_LOAN_EXT_ID IN NUMBER,
168 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
169 X_MSG_COUNT OUT NOCOPY NUMBER,
170 X_MSG_DATA OUT NOCOPY VARCHAR2);
171
172
173
174 /*========================================================================
175 | PUBLIC PROCEDURE CALC_NEW_TERMS
176 |
177 | DESCRIPTION
178 | This procedure calculates and returns new loan terms based on input extension loan term data.
179 |
180 | PSEUDO CODE/LOGIC
181 |
182 | PARAMETERS
183 | P_API_VERSION IN Standard in parameter
184 | P_INIT_MSG_LIST IN Standard in parameter
185 | P_COMMIT IN Standard in parameter
186 | P_VALIDATION_LEVEL IN Standard in parameter
187 | P_EXT_LOAN_REC IN OUT NOCOPY LNS_EXT_LOAN_PUB.NEW_TERM_REC record
188 | X_RETURN_STATUS OUT NOCOPY Standard out parameter
189 | X_MSG_COUNT OUT NOCOPY Standard out parameter
190 | X_MSG_DATA OUT NOCOPY Standard out parameter
191 |
192 | KNOWN ISSUES
193 | None
194 |
195 | NOTES
196 |
197 | MODIFICATION HISTORY
198 | Date Author Description of Changes
199 | 09-25-2007 scherkas Created
200 |
201 *=======================================================================*/
202 PROCEDURE CALC_NEW_TERMS(
203 P_API_VERSION IN NUMBER,
204 P_INIT_MSG_LIST IN VARCHAR2,
205 P_COMMIT IN VARCHAR2,
206 P_VALIDATION_LEVEL IN NUMBER,
207 P_NEW_TERM_REC IN OUT NOCOPY LNS_EXT_LOAN_PUB.NEW_TERM_REC,
208 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
209 X_MSG_COUNT OUT NOCOPY NUMBER,
210 X_MSG_DATA OUT NOCOPY VARCHAR2);
211
212
213
214 END LNS_EXT_LOAN_PUB;