1 PACKAGE LNS_SAMPLE_CUSTOM_CONDS AUTHID CURRENT_USER as
2 /* $Header: LNS_SMPL_CUSTOM_CONDS_S.pls 120.0.12010000.1 2010/03/22 15:29:56 scherkas noship $ */
3
4 /*=======================================================================+
5 | Declare PUBLIC Data Types and Variables
6 +=======================================================================*/
7
8
9 /*========================================================================
10 | PUBLIC PROCEDURE VALIDATE_INCREASE_LOAN_AMOUNT1
11 |
12 | DESCRIPTION
13 | This procedure implements sample validation of increase loan amount - increase of loan amount must not be greater
14 | than 10% of original loan amount.
15 |
16 | PSEUDO CODE/LOGIC
17 | 100%*(increase_amount/original_loan_amount) <= 10%
18 |
19 | PARAMETERS
20 | P_COND_ASSIGNMENT_ID IN Condition Assignment ID
21 | X_CONDITION_MET OUT NOCOPY Returned value that indicates if condition is met or not. Valid values Y, N
22 | X_ERROR OUT NOCOPY If condition is not met this returned error message explains why.
23 |
24 | KNOWN ISSUES
25 | None
26 |
27 | NOTES
28 | Any interesting aspect of the code in the package body which needs
29 | to be stated.
30 |
31 | MODIFICATION HISTORY
32 | Date Author Description of Changes
33 | 12-07-2009 scherkas Created
34 |
35 *=======================================================================*/
36 PROCEDURE VALIDATE_INCREASE_LOAN_AMOUNT1(
37 P_COND_ASSIGNMENT_ID IN NUMBER,
38 X_CONDITION_MET OUT NOCOPY VARCHAR2,
39 X_ERROR OUT NOCOPY VARCHAR2);
40
41
42 /*========================================================================
43 | PUBLIC PROCEDURE VALIDATE_LOAN_APPR_COND1
44 |
45 | DESCRIPTION
46 | This procedure implements sample validation for loan approval.
47 | This procedure always returns success.
48 |
49 | PSEUDO CODE/LOGIC
50 | 100%*(increase_amount/original_loan_amount) <= 10%
51 |
52 | PARAMETERS
53 | P_COND_ASSIGNMENT_ID IN Condition Assignment ID
54 | X_CONDITION_MET OUT NOCOPY Returned value that indicates if condition is met or not. Valid values Y, N
55 | X_ERROR OUT NOCOPY If condition is not met this returned error message explains why.
56 |
57 | KNOWN ISSUES
58 | None
59 |
60 | NOTES
61 | Any interesting aspect of the code in the package body which needs
62 | to be stated.
63 |
64 | MODIFICATION HISTORY
65 | Date Author Description of Changes
66 | 12-07-2009 scherkas Created
67 |
68 *=======================================================================*/
69 PROCEDURE VALIDATE_LOAN_APPR_COND1(
70 P_COND_ASSIGNMENT_ID IN NUMBER,
71 X_CONDITION_MET OUT NOCOPY VARCHAR2,
72 X_ERROR OUT NOCOPY VARCHAR2);
73
74
75 /*========================================================================
76 | PUBLIC PROCEDURE VALIDATE_LOAN_APPR_COND2
77 |
78 | DESCRIPTION
79 | This procedure implements sample validation for loan approval.
80 | This procedure always returns failure.
81 |
82 | PSEUDO CODE/LOGIC
83 | 100%*(increase_amount/original_loan_amount) <= 10%
84 |
85 | PARAMETERS
86 | P_COND_ASSIGNMENT_ID IN Condition Assignment ID
87 | X_CONDITION_MET OUT NOCOPY Returned value that indicates if condition is met or not. Valid values Y, N
88 | X_ERROR OUT NOCOPY If condition is not met this returned error message explains why.
89 |
90 | KNOWN ISSUES
91 | None
92 |
93 | NOTES
94 | Any interesting aspect of the code in the package body which needs
95 | to be stated.
96 |
97 | MODIFICATION HISTORY
98 | Date Author Description of Changes
99 | 12-07-2009 scherkas Created
100 |
101 *=======================================================================*/
102 PROCEDURE VALIDATE_LOAN_APPR_COND2(
103 P_COND_ASSIGNMENT_ID IN NUMBER,
104 X_CONDITION_MET OUT NOCOPY VARCHAR2,
105 X_ERROR OUT NOCOPY VARCHAR2);
106
107
108 /*========================================================================
109 | PUBLIC PROCEDURE VALIDATE_DISB_AMOUNT
110 |
111 | DESCRIPTION
112 | This procedure implements sample validation of disbursement amount - disbursement amount must be greater then
113 | or equal to 20% of current loan amount.
114 |
115 | PSEUDO CODE/LOGIC
116 | 100%*(disbursement_amount/loan_amount) >= 20%
117 |
118 | PARAMETERS
119 | P_COND_ASSIGNMENT_ID IN Condition Assignment ID
120 | X_CONDITION_MET OUT NOCOPY Returned value that indicates if condition is met or not. Valid values Y, N
121 | X_ERROR OUT NOCOPY If condition is not met this returned error message explains why.
122 |
123 | KNOWN ISSUES
124 | None
125 |
126 | NOTES
127 | Any interesting aspect of the code in the package body which needs
128 | to be stated.
129 |
130 | MODIFICATION HISTORY
131 | Date Author Description of Changes
132 | 12-07-2009 scherkas Created
133 |
134 *=======================================================================*/
135 PROCEDURE VALIDATE_DISB_AMOUNT(
136 P_COND_ASSIGNMENT_ID IN NUMBER,
137 X_CONDITION_MET OUT NOCOPY VARCHAR2,
138 X_ERROR OUT NOCOPY VARCHAR2);
139
140
141 /*========================================================================
142 | PUBLIC PROCEDURE VALIDATE_DISB1_AMOUNT
143 |
144 | DESCRIPTION
145 | This procedure implements sample validation of disbursement amount - disbursement amount must be
146 | or equal to 50% of current loan amount.
147 |
148 | PSEUDO CODE/LOGIC
149 | 100%*(disbursement_amount/loan_amount) = 50%
150 |
151 | PARAMETERS
152 | P_COND_ASSIGNMENT_ID IN Condition Assignment ID
153 | X_CONDITION_MET OUT NOCOPY Returned value that indicates if condition is met or not. Valid values Y, N
154 | X_ERROR OUT NOCOPY If condition is not met this returned error message explains why.
155 |
156 | KNOWN ISSUES
157 | None
158 |
159 | NOTES
160 | Any interesting aspect of the code in the package body which needs
161 | to be stated.
162 |
163 | MODIFICATION HISTORY
164 | Date Author Description of Changes
165 | 12-07-2009 scherkas Created
166 |
167 *=======================================================================*/
168 PROCEDURE VALIDATE_DISB1_AMOUNT(
169 P_COND_ASSIGNMENT_ID IN NUMBER,
170 X_CONDITION_MET OUT NOCOPY VARCHAR2,
171 X_ERROR OUT NOCOPY VARCHAR2);
172
173
174 /*========================================================================
175 | PUBLIC PROCEDURE VALIDATE_NUM_DISB_IN_MONTH
176 |
177 | DESCRIPTION
178 | This procedure implements sample validation of disbursement -
179 | number of disbursements in any given month cannot be greater than 1
180 |
181 | PSEUDO CODE/LOGIC
182 |
183 | PARAMETERS
184 | P_COND_ASSIGNMENT_ID IN Condition Assignment ID
185 | X_CONDITION_MET OUT NOCOPY Returned value that indicates if condition is met or not. Valid values Y, N
186 | X_ERROR OUT NOCOPY If condition is not met this returned error message explains why.
187 |
188 | KNOWN ISSUES
189 | None
190 |
191 | NOTES
192 | Any interesting aspect of the code in the package body which needs
193 | to be stated.
194 |
195 | MODIFICATION HISTORY
196 | Date Author Description of Changes
197 | 12-07-2009 scherkas Created
198 |
199 *=======================================================================*/
200 PROCEDURE VALIDATE_NUM_DISB_IN_MONTH(
201 P_COND_ASSIGNMENT_ID IN NUMBER,
202 X_CONDITION_MET OUT NOCOPY VARCHAR2,
203 X_ERROR OUT NOCOPY VARCHAR2);
204
205
206 /*========================================================================
207 | PUBLIC PROCEDURE VALIDATE_NUM_DISB_IN_YEAR
208 |
209 | DESCRIPTION
210 | This procedure implements sample validation of disbursement -
211 | number of disbursements in calendar year cannot be greater than 4
212 |
213 | PSEUDO CODE/LOGIC
214 |
215 | PARAMETERS
216 | P_COND_ASSIGNMENT_ID IN Condition Assignment ID
217 | X_CONDITION_MET OUT NOCOPY Returned value that indicates if condition is met or not. Valid values Y, N
218 | X_ERROR OUT NOCOPY If condition is not met this returned error message explains why.
219 |
220 | KNOWN ISSUES
221 | None
222 |
223 | NOTES
224 | Any interesting aspect of the code in the package body which needs
225 | to be stated.
226 |
227 | MODIFICATION HISTORY
228 | Date Author Description of Changes
229 | 12-07-2009 scherkas Created
230 |
231 *=======================================================================*/
232 PROCEDURE VALIDATE_NUM_DISB_IN_YEAR(
233 P_COND_ASSIGNMENT_ID IN NUMBER,
234 X_CONDITION_MET OUT NOCOPY VARCHAR2,
235 X_ERROR OUT NOCOPY VARCHAR2);
236
237 END ;