1 PACKAGE BODY igi_expworkflow AS
2 -- $Header: igiwfacb.pls 115.19 2003/08/09 11:54:12 rgopalan ship $
3 --
4 -- PRIVATE ROUTINES
5 --
6 -- Procedure
7 -- Debug_Info
8 -- Description
9 -- Writes debug info from the package routines to a debug table.
10 --
11
12 PROCEDURE Debug_Info ( info varchar2 )
13 IS
14 BEGIN
15 NULL;
16 END debug_info ;
17
18 --
19 --
20 -- PUBLIC ROUTINES
21 --
22 --
23
24 PROCEDURE Selector( itemtype IN VARCHAR2,
25 itemkey IN VARCHAR2,
26 actid IN NUMBER,
27 funcmode IN VARCHAR2,
28 resultout OUT NOCOPY VARCHAR2)
29 IS
30 BEGIN
31 NULL;
32 END Selector ;
33
34
35 PROCEDURE Startup ( Wkf_Name VARCHAR2,
36 Trans_Unit_Id NUMBER,
37 Trans_Unit_Num VARCHAR2,
38 Wkf_Id NUMBER,
39 Flow_Id NUMBER,
40 User_Name VARCHAR2)
41 IS
42 BEGIN
43 NULL;
44 END Startup;
45
46
47 -- Procedure
48 -- LegalNumbering
49 -- Description
50 -- Obtains the legal numbers for a transmission unit and for
51 -- approved dialogue units in the transmission unit.
52 -- History
53 -- 14-JUN-1999 GWCeland procedure created
54 -- IN
55 -- itemtype - A valid item type from (WF_ITEM_TYPES table)
56 -- itemkey - A string generated from the application objects pk
57 -- actid - An instance of the function activity (instance id)
58 -- funcmode - Run/Cancel/Timeout
59 --
60 -- OUT NOCOPY
61 -- resultout - Procedure status
62 --
63 --
64
65 PROCEDURE LegalNumbering ( itemtype VARCHAR2,
66 itemkey VARCHAR2,
67 actid NUMBER,
68 funcmode VARCHAR2,
69 result OUT NOCOPY VARCHAR2)
70 IS
71 BEGIN
72 NULL;
73 END LegalNumbering;
74
75
76 PROCEDURE ContinueValidating( itemtype VARCHAR2,
77 itemkey VARCHAR2,
78 actid NUMBER,
79 funcmode VARCHAR2,
80 result OUT NOCOPY VARCHAR2)
81 IS
82 BEGIN
83 NULL;
84 END ContinueValidating ;
85
86 PROCEDURE SetRole ( itemtype VARCHAR2,
87 itemkey VARCHAR2,
88 actid NUMBER,
89 funcmode VARCHAR2,
90 result OUT NOCOPY VARCHAR2)
91
92 -- This procedure is called when a new authorizer in the hierarchy has been
93 -- selected to receive a notification. The attribute 'ROLE_NAME' is set to
94 -- equal the authorizer name. This attribute is used by the notification system
95 -- to determine where to send the notice.
96 IS
97 BEGIN
98 NULL;
99 END SetRole;
100
101
102 PROCEDURE GetParentPosition ( itemtype VARCHAR2,
103 itemkey VARCHAR2,
104 actid NUMBER,
105 funcmode VARCHAR2,
106 result OUT NOCOPY VARCHAR2)
107 -- This procedure controls access to the approval hierarchies and sets
108 -- the required context for each authorizer. It detects when approval
109 -- moves to the account office hierarchy and accordingly saves the
110 -- positions of the main authorizer and account officer so that the
111 -- approval notifications can be sent to these positions.
112 IS
113 BEGIN
114 NULL;
115 END GetParentPosition;
116
117 PROCEDURE SendDu ( itemtype VARCHAR2,
118 itemkey VARCHAR2,
119 actid NUMBER,
120 funcmode VARCHAR2,
121 p_message VARCHAR2)
122 IS
123 BEGIN
124 NULL;
125 END SendDu ;
126
127 PROCEDURE Terminate ( itemtype VARCHAR2,
128 itemkey VARCHAR2,
129 actid NUMBER,
130 funcmode VARCHAR2,
131 result OUT NOCOPY VARCHAR2)
132 -- Sets status to 'Terminated' indicating that the transmission unit
133 -- has exited the workflow.
134 IS
135 BEGIN
136 NULL;
137 END Terminate;
138
139 PROCEDURE ValidateGLDate( itemtype IN VARCHAR2,
140 itemkey IN VARCHAR2,
141 actid IN NUMBER,
142 funcmode IN VARCHAR2,
143 result OUT NOCOPY VARCHAR2)
144 -- Checks to see if the current date is valid. This date is used as
145 -- the gl date for all documents that are successfully approved or
146 -- completed in the transmission unit.
147 IS
148 BEGIN
149 NULL;
150 END ValidateGLDate ;
151
152 PROCEDURE BreakLink( itemtype VARCHAR2,
153 itemkey VARCHAR2,
154 actid NUMBER,
155 funcmode VARCHAR2,
156 result OUT NOCOPY VARCHAR2)
157 -- This procedure removes the link (dialog_unit_id) from AP/AR
158 -- documents that have been rejected by authorizer departments
159 -- so that the documents can be reused in other dialog units.
160 IS
161 BEGIN
162 NULL;
163 END BreakLink;
164
165
166 PROCEDURE CreateList ( itemtype VARCHAR2,
167 itemkey VARCHAR2,
168 actid NUMBER,
169 funcmode VARCHAR2,
170 result OUT NOCOPY VARCHAR2)
171
172 -- Creates a list of the people in the next position to receive the
173 -- transmission unit saving the list in a global workflow attribute.
174 IS
175 BEGIN
176 NULL;
177 END CreateList;
178
179
180 PROCEDURE CheckList ( itemtype VARCHAR2,
181 itemkey VARCHAR2,
182 actid NUMBER,
183 funcmode VARCHAR2,
184 result OUT NOCOPY VARCHAR2)
185 -- Checks that a user has selected a person from the list of people
186 -- in the next position. If not the notification is recent.
187 IS
188
189 BEGIN
190 NULL;
191 END CheckList;
192
193
194 PROCEDURE Cancel ( itemtype VARCHAR2,
195 itemkey VARCHAR2,
196 actid NUMBER,
197 funcmode VARCHAR2,
198 result OUT NOCOPY VARCHAR2)
199
200 -- If the accounts office do not want to take responsibility for certain
201 -- dialog units they can send the transmission unit back to the main authorizer.
202 -- If the main authorizer rejects any AP documents then they are cancelled.
203 IS
204 BEGIN
205 NULL;
206 END Cancel ;
207
208
209 PROCEDURE HoldApprove ( itemtype VARCHAR2,
210 itemkey VARCHAR2,
211 actid NUMBER,
212 funcmode VARCHAR2,
213 result OUT NOCOPY VARCHAR2)
214
215 -- Updates the gl date, removes the EXP hold and approves AP
216 -- documents contained in successfully validated dialog units.
217 IS
218 BEGIN
219 NULL;
220 END HoldApprove ;
221
222
223 PROCEDURE DocumentPayment ( itemtype IN VARCHAR2,
224 itemkey IN VARCHAR2,
225 actid IN NUMBER,
226 funcmode IN VARCHAR2,
227 result OUT NOCOPY VARCHAR2)
228 IS
229 BEGIN
230 NULL;
231 END DocumentPayment ;
232
233
234 PROCEDURE Complete_AR ( itemtype VARCHAR2,
235 itemkey VARCHAR2,
236 actid NUMBER,
237 funcmode VARCHAR2,
238 result OUT NOCOPY VARCHAR2)
239 -- Updates the gl date and changes the status of AR documents to
240 -- completed in successfully validated dialog units.
241 IS
242 BEGIN
243 NULL;
244 END Complete_AR ;
245
246
247
248 PROCEDURE MainAuthRequired ( itemtype IN VARCHAR2,
249 itemkey IN VARCHAR2,
250 actid IN NUMBER,
251 funcmode IN VARCHAR2,
252 result OUT NOCOPY VARCHAR2)
253 -- Determines if the main authorizer needs to validate any dialog units.
254 IS
255
256 BEGIN
257 NULL;
258 END MainAuthRequired;
259
260 PROCEDURE ResetDUStatus ( itemtype IN VARCHAR2,
261 itemkey IN VARCHAR2,
262 actid IN NUMBER,
263 funcmode IN VARCHAR2,
264 result OUT NOCOPY VARCHAR2)
265
266 -- when a user has validated a transmission unit the status of dialog
267 -- units that have passed validation are rest to transmitted for the
268 -- next user.
269 IS
270 BEGIN
271 NULL;
272 END ResetDUStatus ;
273
274 PROCEDURE AllDUsRejected ( itemtype IN VARCHAR2,
275 itemkey IN VARCHAR2,
276 actid IN NUMBER,
277 funcmode IN VARCHAR2,
278 result OUT NOCOPY VARCHAR2)
279
280 -- Determines if all the dialog units in the transmission unit have been rejected.
281
282 IS
283 BEGIN
284 NULL;
285 END AllDUsRejected ;
286
287
288 PROCEDURE Control_Buttons( itemtype IN VARCHAR2,
289 itemkey IN VARCHAR2,
290 actid IN NUMBER,
291 funcmode IN VARCHAR2,
292 resultout OUT NOCOPY VARCHAR2)
293 IS
294 BEGIN
295 NULL;
296 END control_buttons ;
297
298 PROCEDURE control_forwarding( itemtype IN VARCHAR2,
299 itemkey IN VARCHAR2,
300 actid IN NUMBER,
301 funcmode IN VARCHAR2,
302 resultout OUT NOCOPY VARCHAR2)
303 IS
304
305 BEGIN
306 NULL;
307 END control_forwarding;
308
309 END igi_expworkflow ;