1 package hr_approval_wf AUTHID CURRENT_USER as
2 /* $Header: hrapprwf.pkh 115.7 2002/12/06 07:37:34 snachuri ship $ */
3 -- --------------------------------------------------------------------
4 -- |--------------------< create_item_attrib_if_notexist >---------|
5 -- --------------------------------------------------------------------
6 --
7 -- Description
8 --
9 -- This procedure checks to see if an item attribute exists. If it does
10 -- not the one is created
11 procedure create_item_attrib_if_notexist
12 (p_item_type in varchar2
13 ,p_item_key in varchar2
14 ,p_name in varchar2) ;
15 --
16 -- ---------------------------------------------------------------------------
17 -- |-------------------------< intialize_item_attributes >--------------------|
18 -- ---------------------------------------------------------------------------
19 --
20 -- Description
21 --
22 -- This procedure creates all the activity item attributes required by
23 -- the approval process and initialises some of them.
24 --
25 procedure initialize_item_attributes
26 (itemtype in varchar2
27 ,itemkey in varchar2
28 ,actid in number
29 ,funmode in varchar2
30 ,result out nocopy varchar2);
31 -- --------------------------------------------------------------------
32 -- |------------------------< set_routing_details1 >------------------|
33 -- --------------------------------------------------------------------
34 --
35 -- Description
36 --
37 -- This procedure sets the item attributes
38 -- APPROVAL_ROUTING_PERSON_ID1, APPROVAL_ROUTING_USERNAME1,
39 -- APPROVAL_ROUTING_DISPLAY_NAME1.
40 -- It calls hr_approval_custom.get_routing_details1 which is
41 -- where the person ID is defined
42 -- These can be used to define the performer of a notification activities.
43 --
44 procedure set_routing_details1(itemtype in varchar2,
45 itemkey in varchar2,
46 actid in number,
47 funmode in varchar2,
48 result out nocopy varchar2 );
49 --
50 -- --------------------------------------------------------------------
51 -- |------------------------< set_routing_details2 >------------------|
52 -- --------------------------------------------------------------------
53 --
54 -- Description
55 --
56 -- This procedure sets the item attributes
57 -- APPROVAL_ROUTING_PERSON_ID2, APPROVAL_ROUTING_USERNAME2,
58 -- APPROVAL_ROUTING_DISPLAY_NAME2.
59 -- It calls hr_approval_custom.get_routing_details2 which is
60 -- where the person ID is defined
61 -- These can be used to define the performer of a notification activities.
62 --
63 procedure set_routing_details2(itemtype in varchar2,
64 itemkey in varchar2,
65 actid in number,
66 funmode in varchar2,
67 result out nocopy varchar2 );
68 --
69 -- --------------------------------------------------------------------
70 -- |------------------------< set_routing_details3 >------------------|
71 -- --------------------------------------------------------------------
72 --
73 -- Description
74 --
75 -- This procedure sets the item attributes
76 -- APPROVAL_ROUTING_PERSON_ID3, APPROVAL_ROUTING_USERNAME3,
77 -- APPROVAL_ROUTING_DISPLAY_NAME3.
78 -- It calls hr_approval_custom.get_routing_details3 which is
79 -- where the person ID is defined
80 -- These can be used to define the performer of a notification activities.
81 --
82 procedure set_routing_details3(itemtype in varchar2,
83 itemkey in varchar2,
84 actid in number,
85 funmode in varchar2,
86 result out nocopy varchar2 );
87 --
88 -- --------------------------------------------------------------------
89 -- |------------------------< set_routing_details4 >------------------|
90 -- --------------------------------------------------------------------
91 --
92 -- Description
93 --
94 -- This procedure sets the item attributes
95 -- APPROVAL_ROUTING_PERSON_ID4, APPROVAL_ROUTING_USERNAME4,
96 -- APPROVAL_ROUTING_DISPLAY_NAME4.
97 -- It calls hr_approval_custom.get_routing_details4 which is
98 -- where the person ID is defined
99 -- These can be used to define the performer of a notification activities.
100 --
101 procedure set_routing_details4(itemtype in varchar2,
102 itemkey in varchar2,
103 actid in number,
104 funmode in varchar2,
105 result out nocopy varchar2 );
106 --
107 -- --------------------------------------------------------------------
108 -- |------------------------< set_routing_details5 >------------------|
109 -- --------------------------------------------------------------------
110 --
111 -- Description
112 --
113 -- This procedure sets the item attributes
114 -- APPROVAL_ROUTING_PERSON_ID5, APPROVAL_ROUTING_USERNAME5,
115 -- APPROVAL_ROUTING_DISPLAY_NAME5.
116 -- It calls hr_approval_custom.get_routing_details5 which is
117 -- where the person ID is defined
118 -- These can be used to define the performer of a notification activities.
119 --
120 procedure set_routing_details5(itemtype in varchar2,
121 itemkey in varchar2,
122 actid in number,
123 funmode in varchar2,
124 result out nocopy varchar2 );
125 -- --------------------------------------------------------------------
126 -- |----------------------------< set_URL1 >---------------------------|
127 -- --------------------------------------------------------------------
128 --
129 -- Description
130 --
131 -- This function sets the attribute APPROVAL_URL1 to define
132 -- a URL for Employee Kiosk. The URL value is obtained from
133 -- the function hr_approval_custom.get_URL1
134 --
135 procedure set_URL1(itemtype in varchar2,
136 itemkey in varchar2,
137 actid in number,
138 funmode in varchar2,
139 result out nocopy varchar2);
140 -- --------------------------------------------------------------------
141 -- |----------------------------< set_URL2 >---------------------------|
142 -- --------------------------------------------------------------------
143 --
144 -- Description
145 --
146 -- This function sets the attribute APPROVAL_URL2 to define
147 -- a URL for Employee Kiosk. The URL value is obtained from
148 -- the function hr_approval_custom.get_URL2
149 --
150 procedure set_URL2(itemtype in varchar2,
151 itemkey in varchar2,
152 actid in number,
153 funmode in varchar2,
154 result out nocopy varchar2);
155 -- --------------------------------------------------------------------
156 -- |----------------------------< set_URL3 >---------------------------|
157 -- --------------------------------------------------------------------
158 --
159 -- Description
160 --
161 -- This function sets the attribute APPROVAL_URL3 to define
162 -- a URL for Employee Kiosk. The URL value is obtained from
163 -- the function hr_approval_custom.get_URL3
164 --
165 procedure set_URL3(itemtype in varchar2,
166 itemkey in varchar2,
167 actid in number,
168 funmode in varchar2,
169 result out nocopy varchar2);
170 -- --------------------------------------------------------------------
171 -- |----------------------------< set_URL4 >---------------------------|
172 -- --------------------------------------------------------------------
173 --
174 -- Description
175 --
176 -- This function sets the attribute APPROVAL_URL4 to define
177 -- a URL for Employee Kiosk. The URL value is obtained from
178 -- the function hr_approval_custom.get_URL4
179 --
180 procedure set_URL4(itemtype in varchar2,
181 itemkey in varchar2,
182 actid in number,
183 funmode in varchar2,
184 result out nocopy varchar2);
185 -- --------------------------------------------------------------------
186 -- |----------------------------< set_URL5 >---------------------------|
187 -- --------------------------------------------------------------------
188 --
189 -- Description
190 --
191 -- This function sets the attribute APPROVAL_URL5 to define
192 -- a URL for Employee Kiosk. The URL value is obtained from
193 -- the function hr_approval_custom.get_URL5
194 --
195 procedure set_URL5(itemtype in varchar2,
196 itemkey in varchar2,
197 actid in number,
198 funmode in varchar2,
199 result out nocopy varchar2);
200 -- --------------------------------------------------------------------
201 -- |----------------------------< set_URL6 >---------------------------|
202 -- --------------------------------------------------------------------
203 --
204 -- Description
205 --
206 -- This function sets the attribute APPROVAL_URL6 to define
207 -- a URL for Employee Kiosk. The URL value is obtained from
208 -- the function hr_approval_custom.get_URL6
209 --
210 procedure set_URL6(itemtype in varchar2,
211 itemkey in varchar2,
212 actid in number,
213 funmode in varchar2,
214 result out nocopy varchar2);
215 -- --------------------------------------------------------------------
216 -- |----------------------------< set_URL7 >---------------------------|
217 -- --------------------------------------------------------------------
218 --
219 -- Description
220 --
221 -- This function sets the attribute APPROVAL_URL7 to define
222 -- a URL for Employee Kiosk. The URL value is obtained from
223 -- the function hr_approval_custom.get_URL7
224 --
225 procedure set_URL7(itemtype in varchar2,
226 itemkey in varchar2,
227 actid in number,
228 funmode in varchar2,
229 result out nocopy varchar2);
230 -- --------------------------------------------------------------------
231 -- |----------------------------< set_URL8 >---------------------------|
232 -- --------------------------------------------------------------------
233 --
234 -- Description
235 --
236 -- This function sets the attribute APPROVAL_URL8 to define
237 -- a URL for Employee Kiosk. The URL value is obtained from
238 -- the function hr_approval_custom.get_URL8
239 --
240 procedure set_URL8(itemtype in varchar2,
241 itemkey in varchar2,
242 actid in number,
243 funmode in varchar2,
244 result out nocopy varchar2);
245 -- --------------------------------------------------------------------
246 -- |----------------------------< set_URL9 >---------------------------|
247 -- --------------------------------------------------------------------
248 --
249 -- Description
250 --
251 -- This function sets the attribute APPROVAL_URL9 to define
252 -- a URL for Employee Kiosk. The URL value is obtained from
253 -- the function hr_approval_custom.get_URL9
254 --
255 procedure set_URL9(itemtype in varchar2,
256 itemkey in varchar2,
257 actid in number,
258 funmode in varchar2,
259 result out nocopy varchar2);
260 -- --------------------------------------------------------------------
261 -- |----------------------------< set_URL10 >---------------------------|
262 -- --------------------------------------------------------------------
263 --
264 -- Description
265 --
266 -- This function sets the attribute APPROVAL_URL10 to define
267 -- a URL for Employee Kiosk. The URL value is obtained from
268 -- the function hr_approval_custom.get_URL10
269 --
270 procedure set_URL10(itemtype in varchar2,
271 itemkey in varchar2,
272 actid in number,
273 funmode in varchar2,
274 result out nocopy varchar2);
275 -- --------------------------------------------------------------------
276 -- |----------------------------< set_URL11 >---------------------------|
277 -- --------------------------------------------------------------------
278 --
279 -- Description
280 --
281 -- This function sets the attribute APPROVAL_URL11 to define
282 -- a URL for Employee Kiosk. The URL value is obtained from
283 -- the function hr_approval_custom.get_URL11
284 --
285 procedure set_URL11(itemtype in varchar2,
286 itemkey in varchar2,
287 actid in number,
288 funmode in varchar2,
289 result out nocopy varchar2);
290 -- --------------------------------------------------------------------
291 -- |----------------------------< set_URL12 >---------------------------|
292 -- --------------------------------------------------------------------
293 --
294 -- Description
295 --
296 -- This function sets the attribute APPROVAL_URL12 to define
297 -- a URL for Employee Kiosk. The URL value is obtained from
298 -- the function hr_approval_custom.get_URL12
299 --
300 procedure set_URL12(itemtype in varchar2,
301 itemkey in varchar2,
302 actid in number,
303 funmode in varchar2,
304 result out nocopy varchar2);
305 -- --------------------------------------------------------------------
306 -- |----------------------------< set_URL13 >---------------------------|
307 -- --------------------------------------------------------------------
308 --
309 -- Description
310 --
311 -- This function sets the attribute APPROVAL_URL13 to define
312 -- a URL for Employee Kiosk. The URL value is obtained from
313 -- the function hr_approval_custom.get_URL13
314 --
315 procedure set_URL13(itemtype in varchar2,
316 itemkey in varchar2,
317 actid in number,
318 funmode in varchar2,
319 result out nocopy varchar2);
320 -- --------------------------------------------------------------------
321 -- |----------------------------< set_URL14 >---------------------------|
322 -- --------------------------------------------------------------------
323 --
324 -- Description
325 --
326 -- This function sets the attribute APPROVAL_URL14 to define
327 -- a URL for Employee Kiosk. The URL value is obtained from
328 -- the function hr_approval_custom.get_URL14
329 --
330 procedure set_URL14(itemtype in varchar2,
331 itemkey in varchar2,
332 actid in number,
333 funmode in varchar2,
334 result out nocopy varchar2);
335
336 -- ------------------------------------------------------------------------
337 -- |----------------------< Check_Final_Approver >-------------------------|
338 -- ------------------------------------------------------------------------
339 --
340 -- Description
341 --
342 -- Determine if this person is the final manager in the approval chain
343 --
344 --
345 procedure Check_Final_Approver( itemtype in varchar2,
346 itemkey in varchar2,
347 actid in number,
348 funmode in varchar2,
349 result out nocopy varchar2 );
350 --
351 -- ------------------------------------------------------------------------
352 -- |------------------------< Get_next_approver >-------------------------|
353 -- ------------------------------------------------------------------------
354 --
355 -- Description
356 --
357 -- Get the next approver in the chain
358 --
359 --
360 procedure Get_Next_Approver ( itemtype in varchar2,
361 itemkey in varchar2,
362 actid in number,
363 funmode in varchar2,
364 result out nocopy varchar2 );
365 --
366 -- ------------------------------------------------------------------------
367 -- |------------------------< Get_next_approver >-------------------------|
368 -- ------------------------------------------------------------------------
369 --
370 -- Description
371 --
372 -- Get the next approver in the chain
373 -- Overloaded method returns the person id of the next approver in the chain
374 -- or null if no approver exists.
375 --
376 --
377 procedure Get_Next_Approver ( itemtype in varchar2,
378 itemkey in varchar2,
379 currentapproverid in per_people_f.person_id%type,
380 personid out nocopy per_people_f.person_id%type);
381 -- ------------------------------------------------------------------------
382 -- |--------------------------< copy_approval_comment >---------------------|
383 -- ------------------------------------------------------------------------
384 --
385 -- Description
386 --
387 -- Copies the item attribute APPROVAL_COMMENT into item attribute
388 -- APPROVAL_COMMENT_COPY so that it cna be displayed in the notification
389 --
390 --
391 procedure copy_approval_comment( itemtype in varchar2,
392 itemkey in varchar2,
393 actid in number,
394 funmode in varchar2,
395 result out nocopy varchar2 );
396 --
397 -- ---------------------------------------------------------------------------
398 -- |-------------------------< set_current_person_to_creator >----------------|
399 -- ---------------------------------------------------------------------------
400 --
401 -- Description
402 --
403 -- Sets the value of the attribute CURRENT_PERSON_ID to the value
404 -- of the attribute CREATOR_PERSON_ID
405 --
406 --
407 procedure set_current_person_to_creator
408 (itemtype in varchar2
409 ,itemkey in varchar2
410 ,actid in number
411 ,funmode in varchar2
412 ,result out nocopy varchar2);
413 -- ---------------------------------------------------------------------------
414 -- |-------------------------< set_training_admin_person >-------------------|
415 -- ---------------------------------------------------------------------------
416 --
417 -- Description
418 --
419 -- gets the value of the training administrator
420 --
421 --
422 procedure set_training_admin_person
423 (itemtype in varchar2
424 ,itemkey in varchar2
425 ,actid in number
426 ,funmode in varchar2
427 ,result out nocopy varchar2);
428
429 --
430 -- ---------------------------------------------------------------------------
431 -- |-------------------------< set_supervisor_id >----------------------------|
432 -- ---------------------------------------------------------------------------
433 --
434 -- Description
435 --
436 -- gets the value of the supervisor id
437 --
438 --
439 procedure set_supervisor_id
440 (itemtype in varchar2
441 ,itemkey in varchar2
442 ,actid in number
443 ,funmode in varchar2
444 ,result out nocopy varchar2);
445
446 --
447 procedure set_forward_to
448 (itemtype in varchar2
449 ,itemkey in varchar2
450 ,actid in number
451 ,funmode in varchar2
452 ,result out nocopy varchar2);
453 --
454 end hr_approval_wf;
455
456
457