1 PACKAGE LNS_WORK_FLOW AUTHID CURRENT_USER as
2 /* $Header: LNS_WORK_FLOW_S.pls 120.8 2011/03/07 11:20:44 gparuchu ship $ */
3
4 /*=======================================================================+
5 | Declare PUBLIC Data Types and Variables
6 +=======================================================================*/
7
8
9 /*========================================================================
10 | PUBLIC PROCEDURE PROCESS_LOAN_STATUS_CHANGE
11 |
12 | DESCRIPTION
13 | This procedure processes Loan status changes
14 |
15 | PSEUDO CODE/LOGIC
16 |
17 | PARAMETERS
18 | P_LOAN_ID IN Standard in parameter
19 | P_FROM_STATUS IN Standard in parameter
20 | P_TO_STATUS IN Standard in parameter
21 |
22 | KNOWN ISSUES
23 | None
24 |
25 | NOTES
26 |
27 | MODIFICATION HISTORY
28 | Date Author Description of Changes
29 | 06-Feb-2005 GBELLARY Created
30 |
31 *=======================================================================*/
32 PROCEDURE PROCESS_LOAN_STATUS_CHANGE( p_loan_id IN NUMBER
33 ,p_from_status IN VARCHAR2
34 ,p_to_status IN VARCHAR2);
35 /*========================================================================
36 | PUBLIC PROCEDURE PROCESS_STATUS_CHANGE
37 |
38 | DESCRIPTION
39 | This procedure processes Loan status changes both loan_status and sec status
40 |
41 | PSEUDO CODE/LOGIC
42 |
43 | PARAMETERS
44 | P_LOAN_ID IN Standard in parameter
45 | P_COLUMN_NAME IN Standard in parameter
46 | P_FROM_STATUS IN Standard in parameter
47 | P_TO_STATUS IN Standard in parameter
48 |
49 | KNOWN ISSUES
50 | None
51 |
52 | NOTES
53 |
54 | MODIFICATION HISTORY
55 | Date Author Description of Changes
56 | 03-Oct-2005 GBELLARY Created
57 |
58 *=======================================================================*/
59 PROCEDURE PROCESS_STATUS_CHANGE( p_loan_id IN NUMBER
60 ,p_column_name IN VARCHAR2
61 ,p_from_status IN VARCHAR2
62 ,p_to_status IN VARCHAR2);
63 PROCEDURE PROCESS_SEC_STATUS_CHANGE( p_loan_id IN NUMBER
64 ,p_from_status IN VARCHAR2
65 ,p_to_status IN VARCHAR2);
66 PROCEDURE RAISE_EVENT ( p_loan_id IN NUMBER
67 ,p_event_name IN VARCHAR2
68 ,p_from_status IN VARCHAR2 DEFAULT NULL );
69 FUNCTION CREATE_NOTIFICATION_DETAILS ( itemtype in varchar2,
70 itemkey in varchar2,
71 p_event_name in varchar2,
72 p_loan_id in NUMBER,
73 p_loan_class_code in varchar2,
74 p_loan_type in varchar2,
75 p_loan_type_id in number,
76 p_current_user_id in number)
77 RETURN VARCHAR2;
78 /*========================================================================
79 | PUBLIC PROCEDURE PROCESS_EVENT
80 |
81 | DESCRIPTION
82 | This procedure processes the event and is called from workflow.
83 |
84 | PSEUDO CODE/LOGIC
85 |
86 | PARAMETERS
87 | ITEMKEY IN Standard in parameter
88 | ACTID IN Standard in parameter
89 | FUNCMODE IN Standard in parameter
90 | RESULTOUT OUT Standard out parameter
91 |
92 | KNOWN ISSUES
93 | None
94 |
95 | NOTES
96 |
97 | MODIFICATION HISTORY
98 | Date Author Description of Changes
99 | 06-Feb-2005 GBELLARY Created
100 |
101 *=======================================================================*/
102 PROCEDURE PROCESS_EVENT(itemtype in varchar2,
103 itemkey in varchar2,
104 actid in number,
105 funcmode in varchar2,
106 resultout out NOCOPY varchar2 );
107
108 /*========================================================================
109 | PUBLIC PROCEDURE PROCESS_LOAN_APPROVAL
110 |
111 | DESCRIPTION
112 | This procedure insters/updates the loan Approval Status in LNS_APPROVAL_ACTIONS table.
113 |
114 | PSEUDO CODE/LOGIC
115 |
116 | PARAMETERS
117 | ITEMKEY IN Standard in parameter
118 | ACTID IN Standard in parameter
119 | FUNCMODE IN Standard in parameter
120 | RESULTOUT OUT Standard out parameter
121 |
122 | KNOWN ISSUES
123 | None
124 |
125 | NOTES
126 |
127 | MODIFICATION HISTORY
128 | Date Author Description of Changes
129 | 23-Aug-2009 avepati Created
130 | 23-Aug-2009 avepati bug 8764310 - Loan Notification Missing Approve and Reject Buttons
131 |
132 *=======================================================================*/
133 PROCEDURE PROCESS_LOAN_APPROVAL(itemtype in varchar2,
134 itemkey in varchar2,
135 actid in number,
136 funcmode in varchar2,
137 resultout out NOCOPY varchar2 );
138
139 /*========================================================================
140 | PUBLIC PROCEDURE PROCESS_LOAN_REJECTION
141 |
142 | DESCRIPTION
143 | This procedure insters/updates the Loan Rejection Status in LNS_APPROVAL_ACTIONS table.
144 |
145 | PSEUDO CODE/LOGIC
146 |
147 | PARAMETERS
148 | ITEMKEY IN Standard in parameter
149 | ACTID IN Standard in parameter
150 | FUNCMODE IN Standard in parameter
151 | RESULTOUT OUT Standard out parameter
152 |
153 | KNOWN ISSUES
154 | None
155 |
156 | NOTES
157 |
158 | MODIFICATION HISTORY
159 | Date Author Description of Changes
160 | 23-Aug-2009 avepati Created
161 | 23-Aug-2009 avepati bug 8764310 - Loan Notification Missing Approve and Reject Buttons
162 |
163 *=======================================================================*/
164 PROCEDURE PROCESS_LOAN_REJECTION(itemtype in varchar2,
165 itemkey in varchar2,
166 actid in number,
167 funcmode in varchar2,
168 resultout out NOCOPY varchar2 );
169
170 /*========================================================================
171 | PUBLIC PROCEDURE REQUEST_LOAN_INFORMATION
172 |
173 | DESCRIPTION
174 | This procedure updates the the Loan Status back to Incomplete in LNS_APPROVAL_ACTIONS table.
175 |
176 | PSEUDO CODE/LOGIC
177 |
178 | PARAMETERS
179 | ITEMKEY IN Standard in parameter
180 | ACTID IN Standard in parameter
181 | FUNCMODE IN Standard in parameter
182 | RESULTOUT OUT Standard out parameter
183 |
184 | KNOWN ISSUES
185 | None
186 |
187 | NOTES
188 |
189 | MODIFICATION HISTORY
190 | Date Author Description of Changes
191 | 11-Dec-2009 avepati Created
192 | 11-Dec-2009 avepati bug 8764310 - Loan Notification Missing Approve and Reject Buttons
193 |
194 *=======================================================================*/
195 PROCEDURE REQUEST_LOAN_INFORMATION(itemtype in varchar2,
196 itemkey in varchar2,
197 actid in number,
198 funcmode in varchar2,
199 resultout out NOCOPY varchar2 );
200
201 /*========================================================================
202 | PUBLIC PROCEDURE APPROVE_LOAN_FROM_NTF
203 |
204 | DESCRIPTION
205 | This procedure hides/displays the loan Approve/Reject button in Loan Approval Notification.
206 | Based on the profile LNS: Loan Approval From Notificaiton
207 | PSEUDO CODE/LOGIC
208 |
209 | PARAMETERS
210 | ITEMKEY IN Standard in parameter
211 | ACTID IN Standard in parameter
212 | FUNCMODE IN Standard in parameter
213 | RESULTOUT OUT Standard out parameter
214 |
215 | KNOWN ISSUES
216 | None
217 |
218 | NOTES
219 |
220 | MODIFICATION HISTORY
221 | Date Author Description of Changes
222 | 23-Aug-2009 avepati Created
223 | 23-Aug-2009 avepati bug 9092928 - Loan Approval/Rejection Notes is not saved
224 |
225 *=======================================================================*/
226 PROCEDURE APPROVE_LOAN_FROM_NTF(itemtype in varchar2,
227 itemkey in varchar2,
228 actid in number,
229 funcmode in varchar2,
230 resultout out NOCOPY varchar2 );
231
232 /*========================================================================
233 | PUBLIC PROCEDURE LOG_EVENT_HISTORY
234 |
235 | DESCRIPTION
236 | This procedure logs the event history in LNS_EVT_ACTION_HISTORY_H table.
237 |
238 | PSEUDO CODE/LOGIC
239 |
240 | PARAMETERS
241 | ITEMKEY IN Standard in parameter
242 | ACTID IN Standard in parameter
243 | FUNCMODE IN Standard in parameter
244 | RESULTOUT OUT Standard out parameter
245 |
246 | KNOWN ISSUES
247 | None
248 |
249 | NOTES
250 |
251 | MODIFICATION HISTORY
252 | Date Author Description of Changes
253 | 06-Feb-2005 GBELLARY Created
254 |
255 *=======================================================================*/
256 PROCEDURE LOG_EVENT_HISTORY(itemtype in varchar2,
257 itemkey in varchar2,
258 actid in number,
259 funcmode in varchar2,
260 resultout out NOCOPY varchar2 );
261 /*========================================================================
262 | PUBLIC PROCEDURE SYNCH_EVENT_ACTIONS
263 |
264 | DESCRIPTION
265 | This procedure adds event actions for newly created user extensible
266 | Loan Types.
267 | PSEUDO CODE/LOGIC
268 |
269 | PARAMETERS
270 | NONE.
271 |
272 | KNOWN ISSUES
273 | None
274 |
275 | NOTES
276 |
277 | MODIFICATION HISTORY
278 | Date Author Description of Changes
279 | 23-Feb-2005 GBELLARY Created
280 |
281 *=======================================================================*/
282 PROCEDURE SYNCH_EVENT_ACTIONS;
283
284 /*========================================================================
285 | PUBLIC PROCEDURE DELETE_LNS_EVENT_ACTIONS
286 |
287 | DESCRIPTION
288 | This procedure deletes the event action records from the table
289 | lns_event_actions table for the provided loanType.
290 |
291 | PSEUDO CODE/LOGIC
292 |
293 | PARAMETERS
294 | p_loan_type_id IN Standard in parameter
295 |
296 | KNOWN ISSUES
297 | None
298 |
299 | NOTES
300 |
301 | MODIFICATION HISTORY
302 | Date Author Description of Changes
303 | 16-Mar-2009 MBOLLI Created
304 |
305 *=======================================================================*/
306 PROCEDURE DELETE_LNS_EVENT_ACTIONS ( p_loan_type_id IN NUMBER);
307
308 PROCEDURE AME_FIND_PRIMARY_APPROVER(
309 p_item_type IN VARCHAR2,
310 p_item_key IN VARCHAR2,
311 p_actid IN NUMBER,
312 p_funcmode IN VARCHAR2,
313 p_result OUT NOCOPY VARCHAR2);
314
315
316 PROCEDURE UPDATE_APPROVAL_STATUS_TO_AME(
317 p_item_type IN VARCHAR2,
318 p_item_key IN VARCHAR2,
319 p_actid IN NUMBER,
320 p_funcmode IN VARCHAR2,
321 p_result OUT NOCOPY VARCHAR2);
322
323 PROCEDURE UPDATE_REJECTED_STATUS_TO_AME(
324 p_item_type IN VARCHAR2,
325 p_item_key IN VARCHAR2,
326 p_actid IN NUMBER,
327 p_funcmode IN VARCHAR2,
328 p_result OUT NOCOPY VARCHAR2);
329
330 PROCEDURE APPROVE_LOAN_USING_AME(itemtype in varchar2,
331 itemkey in varchar2,
332 actid in number,
333 funcmode in varchar2,
334 resultout out NOCOPY varchar2 );
335 PROCEDURE AME_VERIFY_LOANS_MGR_ROLE(itemtype in varchar2,
336 itemkey in varchar2,
337 actid in number,
338 funcmode in varchar2,
339 resultout out NOCOPY varchar2 );
340 PROCEDURE AMEEnabled(
341 p_item_type IN VARCHAR2,
342 p_item_key IN VARCHAR2,
343 p_actid IN NUMBER,
344 p_funmode IN VARCHAR2,
345 p_result OUT NOCOPY VARCHAR2);
346
347 /*========================================================================
348 | PUBLIC PROCEDURE PROCESS_AME_APPROVAL_ACTION
349 |
350 | DESCRIPTION
351 | This procedure inserts the loan Approval Actions in LNS_APPROVAL_ACTIONS table
352 | whenever an approver takes any action from notification.
353 |
354 | PSEUDO CODE/LOGIC
355 |
356 | PARAMETERS
357 | ITEMKEY IN Standard in parameter
358 | ACTID IN Standard in parameter
359 | FUNCMODE IN Standard in parameter
360 | RESULTOUT OUT Standard out parameter
361 |
362 | KNOWN ISSUES
363 | None
364 |
365 | NOTES
366 |
367 | MODIFICATION HISTORY
368 | Date Author Description of Changes
369 | 12-Nov-2010 gparuchu Created
370 |
371 *=======================================================================*/
372 PROCEDURE PROCESS_AME_APPROVAL_ACTION(itemtype in varchar2,
373 itemkey in varchar2,
374 actid in number,
375 funcmode in varchar2,
378 END LNS_WORK_FLOW;
376 resultout out NOCOPY varchar2 );
377