1 PACKAGE LNS_WORK_FLOW AUTHID CURRENT_USER as
2 /* $Header: LNS_WORK_FLOW_S.pls 120.3 2005/11/15 11:49:48 gbellary noship $ */
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 | PUBLIC PROCEDURE LOG_EVENT_HISTORY
109 |
110 | DESCRIPTION
111 | This procedure logs the event history in LNS_EVT_ACTION_HISTORY_H table.
112 |
113 | PSEUDO CODE/LOGIC
114 |
115 | PARAMETERS
116 | ITEMKEY IN Standard in parameter
117 | ACTID IN Standard in parameter
118 | FUNCMODE IN Standard in parameter
119 | RESULTOUT OUT Standard out parameter
120 |
121 | KNOWN ISSUES
122 | None
123 |
124 | NOTES
125 |
126 | MODIFICATION HISTORY
127 | Date Author Description of Changes
128 | 06-Feb-2005 GBELLARY Created
129 |
130 *=======================================================================*/
131 PROCEDURE LOG_EVENT_HISTORY(itemtype in varchar2,
132 itemkey in varchar2,
133 actid in number,
134 funcmode in varchar2,
135 resultout out NOCOPY varchar2 );
136 /*========================================================================
137 | PUBLIC PROCEDURE SYNCH_EVENT_ACTIONS
138 |
139 | DESCRIPTION
140 | This procedure adds event actions for newly created user extensible
141 | Loan Types.
142 | PSEUDO CODE/LOGIC
143 |
144 | PARAMETERS
145 | NONE.
146 |
147 | KNOWN ISSUES
148 | None
149 |
150 | NOTES
151 |
152 | MODIFICATION HISTORY
153 | Date Author Description of Changes
154 | 23-Feb-2005 GBELLARY Created
155 |
156 *=======================================================================*/
157 PROCEDURE SYNCH_EVENT_ACTIONS;
158 END LNS_WORK_FLOW;