4 g_itemtype varchar2(8);
1 package hr_approval_custom AUTHID CURRENT_USER as
2 /* $Header: hrapcuwf.pkh 120.1 2005/06/15 01:33:15 sturlapa noship $ */
3 --
5 g_itemkey varchar2(240);
6 --
7 -- ----------------------------------------------------------------------------
8 -- |------------------------------< get_routing_details1 >--------------------|
9 -- ----------------------------------------------------------------------------
10 --
11 -- This function returns the Id of a person. Used for routing of notifications
12 -- within the approval process
13 --
14 function get_routing_details1
15 (p_person_id in per_people_f.person_id%type)
16 return per_people_f.person_id%type;
17 --
18 -- ----------------------------------------------------------------------------
19 -- |------------------------------< get_routing_details2 >--------------------|
20 -- ----------------------------------------------------------------------------
21 --
22 -- This function returns the Id of a person. Used for routing of notifications
23 -- within the approval process
24 --
25 function get_routing_details2
26 (p_person_id in per_people_f.person_id%type)
27 return per_people_f.person_id%type;
28 --
29 -- ----------------------------------------------------------------------------
30 -- |------------------------------< get_routing_details3 >--------------------|
31 -- ----------------------------------------------------------------------------
32 --
33 -- This function returns the Id of a person. Used for routing of notifications
34 -- within the approval process
35 --
36 function get_routing_details3
37 (p_person_id in per_people_f.person_id%type)
38 return per_people_f.person_id%type;
39 -- ----------------------------------------------------------------------------
40 -- |------------------------------< get_routing_details4 >--------------------|
41 -- ----------------------------------------------------------------------------
42 --
43 -- This function returns the Id of a person. Used for routing of notifications
44 -- within the approval process
45 --
46 function get_routing_details4
47 (p_person_id in per_people_f.person_id%type)
48 return per_people_f.person_id%type;
49 --
50 -- ----------------------------------------------------------------------------
51 -- |------------------------------< get_routing_details5 >--------------------|
52 -- ----------------------------------------------------------------------------
53 --
54 -- This function returns the Id of a person. Used for routing of notifications
55 -- within the approval process
56 --
57 function get_routing_details5
58 (p_person_id in per_people_f.person_id%type)
59 return per_people_f.person_id%type;
60 --
61 -- ------------------------------------------------------------------------
62 -- |----------------------< Check_Final_Approver >-------------------------|
63 -- ------------------------------------------------------------------------
64 --
65 -- Description
66 --
67 -- Determine if this person is the final manager in the approval chain
68 --
69 --
73 return varchar2;
70 function Check_Final_Approver
71 (p_forward_to_person_id in per_people_f.person_id%type
72 ,p_person_id in per_people_f.person_id%type)
74 --
75 -- ------------------------------------------------------------------------
76 -- |----------------------< Check_Final_Payroll_Notifier >----------------|
77 -- ------------------------------------------------------------------------
78 --
79 -- Description
80 --
81 -- Determine if this person is the final payroll notifier in the payroll
82 -- notification chain
83 --
84 --
85 function Check_Final_Payroll_Notifier
86 (p_forward_to_person_id in per_people_f.person_id%type
87 ,p_person_id in per_people_f.person_id%type)
88 return varchar2;
89 -- ------------------------------------------------------------------------
90 -- |------------------------< Get_next_approver >-------------------------|
91 -- ------------------------------------------------------------------------
92 --
93 -- Description
94 --
95 -- Get the next approver in the chain
96 --
97 --
98 function Get_Next_Approver
99 (p_person_id in per_people_f.person_id%type)
100 return per_people_f.person_id%type;
101 -- ------------------------------------------------------------------------
102 -- |------------------------< Get_next_payroll_notifier >-----------------|
103 -- ------------------------------------------------------------------------
104 --
105 -- Description
106 --
107 -- Get the next payroll notifier in the payroll notification chain
108 --
109 --
110 function Get_Next_Payroll_Notifier
111 (p_person_id in per_people_f.person_id%type)
112 return per_people_f.person_id%type;
113 -- ------------------------------------------------------------------------
114 -- |------------------------------< get_URL1 >-----------------------------|
115 -- ------------------------------------------------------------------------
116 --
117 -- Description
118 --
119 -- This function will return a URL for the Employee Kiosk
120 -- This is the URL for the approver to review the changes of an employee
121 --
122 --
123 function get_URL1 return varchar2;
124 -- ------------------------------------------------------------------------
125 -- |------------------------------< get_URL2 >-----------------------------|
126 -- ------------------------------------------------------------------------
127 --
128 -- Description
129 --
130 -- This function will return a URL for the Employee Kiosk
131 -- This is the URL for the employee to complete a process once approved
132 --
133 --
134 function get_URL2 return varchar2;
135 -- ------------------------------------------------------------------------
136 -- |------------------------------< get_URL3 >-----------------------------|
137 -- ------------------------------------------------------------------------
138 --
139 -- Description
140 --
141 -- This function will return a URL for the Employee Kiosk
142 -- This is the URL for the employee to resubmit a rejected request
143 --
144 --
145 function get_URL3 return varchar2;
146 -- ------------------------------------------------------------------------
147 -- |------------------------------< get_URL4 >-----------------------------|
148 -- ------------------------------------------------------------------------
149 --
150 -- Description
151 --
152 -- This function will return a URL for the Employee Kiosk
153 -- This is the URL for the employee to cancel a rejected request
154 --
155 --
156 function get_URL4 return varchar2;
157 -- ------------------------------------------------------------------------
158 -- |------------------------------< get_URL5 >-----------------------------|
159 -- ------------------------------------------------------------------------
160 --
161 -- Description
162 --
163 -- This function will return a URL for the Employee Kiosk Apply for a Job
164 -- This is the URL for the approver to review the employee details
165 --
166 --
167 function get_URL5 return varchar2;
168 -- ------------------------------------------------------------------------
169 -- |------------------------------< get_URL6 >-----------------------------|
170 -- ------------------------------------------------------------------------
171 --
172 -- Description
173 --
174 -- This function will return a URL for the Employee Kiosk Apply for a Job
175 -- This is the URL for the approver to review the job details
176 --
177 --
178 function get_URL6 return varchar2;
179 -- ------------------------------------------------------------------------
180 -- |------------------------------< get_URL7 >-----------------------------|
181 -- ------------------------------------------------------------------------
182 --
183 -- Description
184 --
185 -- This function will return a URL for the Employee Kiosk Apply for a Job
186 -- This is the URL for the approver to review the employee's application
187 --
188 --
189 function get_URL7 return varchar2;
190 -- ------------------------------------------------------------------------
191 -- |------------------------------< get_URL8 >-----------------------------|
192 -- ------------------------------------------------------------------------
193 --
194 -- Description
195 --
196 -- This function will return a URL for the Employee Kiosk Apply for a Job
197 -- This is the URL for the approver to review the job details
198 --
199 --
200 function get_URL8 return varchar2;
201 -- ------------------------------------------------------------------------
202 -- |------------------------------< get_URL9 >-----------------------------|
203 -- ------------------------------------------------------------------------
204 --
205 -- Description
206 --
210 --
207 -- This function will return a URL for the Employee Kiosk Apply for a Job
208 -- This is the URL for the approver to review the job details
209 --
211 function get_URL9 return varchar2;
212 -- ------------------------------------------------------------------------
213 -- |------------------------------< get_URL10 >-----------------------------|
214 -- ------------------------------------------------------------------------
215 --
216 -- Description
217 --
218 -- This function will return a URL for the Employee Kiosk
219 -- This is the URL for the employee to cancel a rejected request
220 --
221 --
222 function get_URL10 return varchar2;
223 -- ------------------------------------------------------------------------
224 -- |------------------------------< get_URL11 >-----------------------------|
225 -- ------------------------------------------------------------------------
226 --
227 -- Description
228 --
229 -- This function will return a URL for the Employee Kiosk
230 -- This is the URL for the employee to cancel a rejected request
231 --
232 --
233 function get_URL11 return varchar2;
234 -- ------------------------------------------------------------------------
235 -- |------------------------------< get_URL12 >-----------------------------|
236 -- ------------------------------------------------------------------------
237 --
238 -- Description
239 --
240 -- This function will return a URL for the Employee Kiosk
241 -- This is the URL for the employee to cancel a rejected request
242 --
243 --
244 function get_URL12 return varchar2;
245 -- ------------------------------------------------------------------------
246 -- |------------------------------< get_URL13 >-----------------------------|
247 -- ------------------------------------------------------------------------
248 --
249 -- Description
250 --
251 -- This function will return a URL for the Employee Kiosk
252 -- This is the URL for the employee to cancel a rejected request
253 --
254 --
255 function get_URL13 return varchar2;
256 -- ------------------------------------------------------------------------
257 -- |------------------------------< get_URL14 >-----------------------------|
258 -- ------------------------------------------------------------------------
259 --
260 -- Description
261 --
262 -- This function will return a URL for the Employee Kiosk
263 -- This is the URL for the employee to cancel a rejected request
264 --
265 --
266 function get_URL14 return varchar2;
267 -- ------------------------------------------------------------------------
268 -- |------------------------------< get_URL15 >-----------------------------|
269 -- ------------------------------------------------------------------------
270 --
271 -- Description
272 --
273 -- This function will return a URL for the Employee Kiosk
274 -- This is the URL for the employee to cancel a rejected request
275 --
276 --
277 function get_URL15 return varchar2;
278 -- ------------------------------------------------------------------------
279 -- |------------------------------< get_URL16 >-----------------------------|
280 -- ------------------------------------------------------------------------
281 --
282 -- Description
283 --
284 -- This function will return a URL for the Employee Kiosk
285 -- This is the URL for the employee to cancel a rejected request
286 --
287 --
288 function get_URL16 return varchar2;
289 -- ------------------------------------------------------------------------
290 -- |------------------------------< get_URL17 >-----------------------------|
291 -- ------------------------------------------------------------------------
292 --
293 -- Description
294 --
295 -- This function will return a URL for the Employee Kiosk
296 -- This is the URL for the employee to cancel a rejected request
297 --
298 --
299 function get_URL17 return varchar2;
300 -- ------------------------------------------------------------------------
301 -- |------------------------------< get_URL18 >-----------------------------|
302 -- ------------------------------------------------------------------------
303 --
304 -- Description
305 --
306 -- This function will return a URL for the Employee Kiosk
307 -- This is the URL for the employee to cancel a rejected request
308 --
309 --
310 function get_URL18 return varchar2;
311 -- ------------------------------------------------------------------------
312 -- |------------------------------< get_URL19 >-----------------------------|
313 -- ------------------------------------------------------------------------
314 --
315 -- Description
316 --
317 -- This function will return a URL for the Employee Kiosk
318 -- This is the URL for the employee to cancel a rejected request
319 --
320 --
321 function get_URL19 return varchar2;
322 -- ------------------------------------------------------------------------
323 -- |------------------------------< get_URL20 >-----------------------------|
324 -- ------------------------------------------------------------------------
325 --
326 -- Description
327 --
328 -- This function will return a URL for the Employee Kiosk
329 -- This is the URL for the employee to cancel a rejected request
330 --
331 --
332 function get_URL20 return varchar2;
333 -- ----------------------------------------------------------------------------
334 -- |-----------------------< check_if_in_approval_chain >---------------------|
335 -- ----------------------------------------------------------------------------
336 --
337 -- Description
338 --
339 -- This function will return true if the forward to person is in
340 -- the approval chain of the current person
341 --
342 function check_if_in_approval_chain
343 (p_forward_to_person_id in per_people_f.person_id%type
344 ,p_person_id in per_people_f.person_id%type)
345 return boolean;
346 --
347 end hr_approval_custom;
[Home] [Help]