[Home] [Help]
PACKAGE: APPS.HR_REVTERMINATION_SS
Source
1 PACKAGE hr_revtermination_ss AUTHID CURRENT_USER AS
2 /* $Header: hrrevtrmwrs.pkh 120.2 2011/04/18 09:48:19 asatulur noship $ */
3
4 gtt_transaction_steps hr_transaction_ss.transaction_table;
5 gv_TERMINATION_ACTIVITY_NAME CONSTANT
6 wf_item_activity_statuses_v.activity_name%TYPE := 'HR_REVTERMINATION_SS';
7
8
9 --store termination related information
10 TYPE rt_termination IS RECORD (
11 actual_termination_date
12 per_periods_of_service.actual_termination_date%TYPE,
13 notified_termination_date
14 per_periods_of_service.notified_termination_date%TYPE,
15 leaving_reason
16 per_periods_of_service.leaving_reason%TYPE,
17 comments
18 per_periods_of_service.comments%TYPE,
19 period_of_service_id
20 per_periods_of_service.period_of_service_id%TYPE,
21 object_version_number
22 per_periods_of_service.object_version_number%TYPE,
23 person_type_id
24 per_person_types.person_type_id%TYPE,
25 assignment_status_type_id
26 per_assignment_status_types.assignment_status_type_id%TYPE,
27 rehire_recommendation
28 per_all_people_f.rehire_recommendation%TYPE,
29 rehire_reason
30 per_all_people_f.rehire_reason%TYPE,
31 last_standard_process_date
32 per_periods_of_service.last_standard_process_date%type,
33 projected_termination_date
34 per_periods_of_service.projected_termination_date%type,
35 final_process_date
36 per_periods_of_service.final_process_date%type
37 );
38
39 -- for DFF
40 TYPE t_flex_table IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;
41
42
43 /*
44 ||===========================================================================
45 || PROCEDURE: ex_emp_process_save
46 ||---------------------------------------------------------------------------
47 ||
48 || Description:
49 || Save Termination Transaction to transaction table
50 ||
51 || Pre Conditions:
52 ||
53 || In Arguments:
54 || Transaction details that need to be saved to transaction table
55 ||
56 || out nocopy Arguments:
57 || None.
58 ||
59 || In out nocopy Arguments:
60 ||
61 || Post Success:
62 || Writes to transaction table
63 ||
64 || Post Failure:
65 || Raises an exception
66 ||
67 || Access Status:
68 || Public
69 ||
70 ||===========================================================================
71 */
72 PROCEDURE ex_emp_process_save (
73 p_validate in number default 0
74 ,p_effective_date in varchar2
75 ,p_item_type in wf_items.item_type%TYPE
76 ,p_item_key in wf_items.item_key%TYPE
77 ,p_actid in varchar2
78 ,p_transaction_mode in varchar2 DEFAULT '#'
79 ,p_period_of_service_id in number default hr_api.g_number
80 ,p_object_version_number in number
81 ,p_person_id in number
82 ,p_login_person_id in number
83 ,p_actual_termination_date in varchar2
84 ,p_last_standard_process_date in varchar2
85 ,p_leaving_reason in varchar2
86 ,p_comments in varchar2 default hr_api.g_varchar2
87 ,p_notified_termination_date in varchar2
88 ,p_review_proc_call in varchar2
89 ,p_attribute_category in varchar2 default hr_api.g_varchar2
90 ,p_attribute1 in varchar2 default hr_api.g_varchar2
91 ,p_attribute2 in varchar2 default hr_api.g_varchar2
92 ,p_attribute3 in varchar2 default hr_api.g_varchar2
93 ,p_attribute4 in varchar2 default hr_api.g_varchar2
94 ,p_attribute5 in varchar2 default hr_api.g_varchar2
95 ,p_attribute6 in varchar2 default hr_api.g_varchar2
96 ,p_attribute7 in varchar2 default hr_api.g_varchar2
97 ,p_attribute8 in varchar2 default hr_api.g_varchar2
98 ,p_attribute9 in varchar2 default hr_api.g_varchar2
99 ,p_attribute10 in varchar2 default hr_api.g_varchar2
100 ,p_attribute11 in varchar2 default hr_api.g_varchar2
101 ,p_attribute12 in varchar2 default hr_api.g_varchar2
102 ,p_attribute13 in varchar2 default hr_api.g_varchar2
103 ,p_attribute14 in varchar2 default hr_api.g_varchar2
104 ,p_attribute15 in varchar2 default hr_api.g_varchar2
105 ,p_attribute16 in varchar2 default hr_api.g_varchar2
106 ,p_attribute17 in varchar2 default hr_api.g_varchar2
107 ,p_attribute18 in varchar2 default hr_api.g_varchar2
108 ,p_attribute19 in varchar2 default hr_api.g_varchar2
109 ,p_attribute20 in varchar2 default hr_api.g_varchar2
110 ,p_pds_information_category in varchar2 default hr_api.g_varchar2
111 ,p_pds_information1 in varchar2 default hr_api.g_varchar2
112 ,p_pds_information2 in varchar2 default hr_api.g_varchar2
113 ,p_pds_information3 in varchar2 default hr_api.g_varchar2
114 ,p_pds_information4 in varchar2 default hr_api.g_varchar2
115 ,p_pds_information5 in varchar2 default hr_api.g_varchar2
116 ,p_pds_information6 in varchar2 default hr_api.g_varchar2
117 ,p_pds_information7 in varchar2 default hr_api.g_varchar2
118 ,p_pds_information8 in varchar2 default hr_api.g_varchar2
119 ,p_pds_information9 in varchar2 default hr_api.g_varchar2
120 ,p_pds_information10 in varchar2 default hr_api.g_varchar2
121 ,p_pds_information11 in varchar2 default hr_api.g_varchar2
122 ,p_pds_information12 in varchar2 default hr_api.g_varchar2
123 ,p_pds_information13 in varchar2 default hr_api.g_varchar2
124 ,p_pds_information14 in varchar2 default hr_api.g_varchar2
125 ,p_pds_information15 in varchar2 default hr_api.g_varchar2
126 ,p_pds_information16 in varchar2 default hr_api.g_varchar2
127 ,p_pds_information17 in varchar2 default hr_api.g_varchar2
128 ,p_pds_information18 in varchar2 default hr_api.g_varchar2
129 ,p_pds_information19 in varchar2 default hr_api.g_varchar2
130 ,p_pds_information20 in varchar2 default hr_api.g_varchar2
131 ,p_pds_information21 in varchar2 default hr_api.g_varchar2
132 ,p_pds_information22 in varchar2 default hr_api.g_varchar2
133 ,p_pds_information23 in varchar2 default hr_api.g_varchar2
134 ,p_pds_information24 in varchar2 default hr_api.g_varchar2
135 ,p_pds_information25 in varchar2 default hr_api.g_varchar2
136 ,p_pds_information26 in varchar2 default hr_api.g_varchar2
137 ,p_pds_information27 in varchar2 default hr_api.g_varchar2
138 ,p_pds_information28 in varchar2 default hr_api.g_varchar2
139 ,p_pds_information29 in varchar2 default hr_api.g_varchar2
140 ,p_pds_information30 in varchar2 default hr_api.g_varchar2
141 ,p_person_type_id in number
142 ,p_assignment_status_type_id in number
143 ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
144 ,p_rehire_reason in varchar2 default hr_api.g_varchar2
145 ,p_projected_termination_date in varchar2 default hr_api.g_varchar2
146 ,p_final_process_date in varchar2 default hr_api.g_varchar2
147 ,p_clear_details in varchar2 default 'Y'
148 ,p_error_message out nocopy long
149
150 );
151
152 /*
153 ||===========================================================================
154 || PROCEDURE: ex_cwk_process_save
155 ||---------------------------------------------------------------------------
156 ||
157 || Description:
158 || Save Termination Transaction to transaction table
159 ||
160 || Pre Conditions:
161 ||
162 || In Arguments:
163 || Transaction details that need to be saved to transaction table
164 ||
165 || out nocopy Arguments:
166 || None.
167 ||
168 || In out nocopy Arguments:
169 ||
170 || Post Success:
171 || Writes to transaction table
172 ||
173 || Post Failure:
174 || Raises an exception
175 ||
176 || Access Status:
177 || Public
178 ||
179 ||===========================================================================
180 */
181 PROCEDURE ex_cwk_process_save
182 ( p_validate in number default 0
183 ,p_item_type in wf_items.item_type%TYPE
184 ,p_item_key in wf_items.item_key%TYPE
185 ,p_actid in varchar2
186 ,p_transaction_mode in varchar2 DEFAULT '#'
187 ,p_effective_date in varchar2
188 ,p_person_id in number
189 ,p_date_start in varchar2
190 ,p_object_version_number in number
191 ,p_person_type_id in number default hr_api.g_number
192 ,p_actual_termination_date in varchar2 default to_char(hr_api.g_date)
193 ,p_final_process_date in varchar2
194 ,p_last_standard_process_date in varchar2
195 ,p_termination_reason in varchar2 default hr_api.g_varchar2
196 ,p_projected_termination_date in varchar2 default to_char(hr_api.g_date)
197 ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
198 ,p_rehire_reason in varchar2 default hr_api.g_varchar2
199 ,p_attribute_category in varchar2 default hr_api.g_varchar2
200 ,p_attribute1 in varchar2 default hr_api.g_varchar2
201 ,p_attribute2 in varchar2 default hr_api.g_varchar2
202 ,p_attribute3 in varchar2 default hr_api.g_varchar2
203 ,p_attribute4 in varchar2 default hr_api.g_varchar2
204 ,p_attribute5 in varchar2 default hr_api.g_varchar2
205 ,p_attribute6 in varchar2 default hr_api.g_varchar2
206 ,p_attribute7 in varchar2 default hr_api.g_varchar2
207 ,p_attribute8 in varchar2 default hr_api.g_varchar2
208 ,p_attribute9 in varchar2 default hr_api.g_varchar2
209 ,p_attribute10 in varchar2 default hr_api.g_varchar2
210 ,p_attribute11 in varchar2 default hr_api.g_varchar2
211 ,p_attribute12 in varchar2 default hr_api.g_varchar2
212 ,p_attribute13 in varchar2 default hr_api.g_varchar2
213 ,p_attribute14 in varchar2 default hr_api.g_varchar2
214 ,p_attribute15 in varchar2 default hr_api.g_varchar2
215 ,p_attribute16 in varchar2 default hr_api.g_varchar2
216 ,p_attribute17 in varchar2 default hr_api.g_varchar2
217 ,p_attribute18 in varchar2 default hr_api.g_varchar2
218 ,p_attribute19 in varchar2 default hr_api.g_varchar2
219 ,p_attribute20 in varchar2 default hr_api.g_varchar2
220 ,p_attribute21 in varchar2 default hr_api.g_varchar2
221 ,p_attribute22 in varchar2 default hr_api.g_varchar2
222 ,p_attribute23 in varchar2 default hr_api.g_varchar2
223 ,p_attribute24 in varchar2 default hr_api.g_varchar2
224 ,p_attribute25 in varchar2 default hr_api.g_varchar2
225 ,p_attribute26 in varchar2 default hr_api.g_varchar2
226 ,p_attribute27 in varchar2 default hr_api.g_varchar2
227 ,p_attribute28 in varchar2 default hr_api.g_varchar2
228 ,p_attribute29 in varchar2 default hr_api.g_varchar2
229 ,p_attribute30 in varchar2 default hr_api.g_varchar2
230 ,p_information_category in varchar2 default hr_api.g_varchar2
231 ,p_information1 in varchar2 default hr_api.g_varchar2
232 ,p_information2 in varchar2 default hr_api.g_varchar2
233 ,p_information3 in varchar2 default hr_api.g_varchar2
234 ,p_information4 in varchar2 default hr_api.g_varchar2
235 ,p_information5 in varchar2 default hr_api.g_varchar2
236 ,p_information6 in varchar2 default hr_api.g_varchar2
237 ,p_information7 in varchar2 default hr_api.g_varchar2
238 ,p_information8 in varchar2 default hr_api.g_varchar2
239 ,p_information9 in varchar2 default hr_api.g_varchar2
240 ,p_information10 in varchar2 default hr_api.g_varchar2
241 ,p_information11 in varchar2 default hr_api.g_varchar2
242 ,p_information12 in varchar2 default hr_api.g_varchar2
243 ,p_information13 in varchar2 default hr_api.g_varchar2
244 ,p_information14 in varchar2 default hr_api.g_varchar2
245 ,p_information15 in varchar2 default hr_api.g_varchar2
246 ,p_information16 in varchar2 default hr_api.g_varchar2
247 ,p_information17 in varchar2 default hr_api.g_varchar2
248 ,p_information18 in varchar2 default hr_api.g_varchar2
249 ,p_information19 in varchar2 default hr_api.g_varchar2
250 ,p_information20 in varchar2 default hr_api.g_varchar2
251 ,p_information21 in varchar2 default hr_api.g_varchar2
252 ,p_information22 in varchar2 default hr_api.g_varchar2
253 ,p_information23 in varchar2 default hr_api.g_varchar2
254 ,p_information24 in varchar2 default hr_api.g_varchar2
255 ,p_information25 in varchar2 default hr_api.g_varchar2
256 ,p_information26 in varchar2 default hr_api.g_varchar2
257 ,p_information27 in varchar2 default hr_api.g_varchar2
258 ,p_information28 in varchar2 default hr_api.g_varchar2
259 ,p_information29 in varchar2 default hr_api.g_varchar2
260 ,p_information30 in varchar2 default hr_api.g_varchar2
261 ,p_review_proc_call in varchar2 default hr_api.g_varchar2
262 ,p_effective_date_option in varchar2 default hr_api.g_varchar2
263 ,p_login_person_id in number
264 ,p_clear_details in varchar2 default 'Y'
265 ,p_fut_actns_exist_warning out nocopy number
266 ,p_error_message out nocopy long
267
268 );
269
270 /*
271 ||==========================================================================
272 || PROCEDURE: process_api
273 ||--------------------------------------------------------------------------
274 ||
275 || Description:
276 || This procedure is invoked whenever approvers have approved the
277 || termination proposal. It is called from workflow.
278 || It will call the termination APIs to update hr tables.
279 ||
280 || Pre-Requisities:
281 || The transaction step must exist.
282 ||
283 || In Parameters:
284 || p_validate Determines if the API should be called in
285 || validate mode.
286 || p_transaction_step_id Specifies which transaction step is to be
287 || processed.
288 ||
289 || Post Success:
290 || Termination APIs will be processed.
291 ||
292 || Post Failure:
293 || None
294 ||
295 || Access Status:
296 || Public.
297 ||
298 ||==========================================================================
299 */
300 PROCEDURE process_api (
301 p_validate IN BOOLEAN DEFAULT FALSE,
302 p_transaction_step_id IN NUMBER DEFAULT NULL,
303 p_effective_date IN VARCHAR2 DEFAULT NULL
304 );
305
306
307 procedure checkPersonType( p_item_type in varchar2,
308 p_item_key in varchar2,
309 p_act_id in number,
310 funmode in varchar2,
311 result out nocopy varchar2 );
312
313 PROCEDURE getCwkTransactionDetails
314 ( p_transaction_step_id in varchar2
315 ,p_person_id out nocopy number
316 ,p_date_start out nocopy Date
317 ,p_object_version_number out nocopy number
318 ,p_person_type_id out nocopy number
319 ,p_actual_termination_date out nocopy Date
320 ,p_final_process_date out nocopy Date
321 ,p_last_standard_process_date out nocopy Date
322 ,p_termination_reason out nocopy varchar2
323 ,p_rehire_recommendation out nocopy varchar2
324 ,p_rehire_reason out nocopy varchar2
325 ,p_projected_termination_date out nocopy Date
326 ,p_attribute_category out nocopy varchar2
327 ,p_attribute1 out nocopy varchar2
328 ,p_attribute2 out nocopy varchar2
329 ,p_attribute3 out nocopy varchar2
330 ,p_attribute4 out nocopy varchar2
331 ,p_attribute5 out nocopy varchar2
332 ,p_attribute6 out nocopy varchar2
333 ,p_attribute7 out nocopy varchar2
334 ,p_attribute8 out nocopy varchar2
335 ,p_attribute9 out nocopy varchar2
336 ,p_attribute10 out nocopy varchar2
337 ,p_attribute11 out nocopy varchar2
338 ,p_attribute12 out nocopy varchar2
339 ,p_attribute13 out nocopy varchar2
340 ,p_attribute14 out nocopy varchar2
341 ,p_attribute15 out nocopy varchar2
342 ,p_attribute16 out nocopy varchar2
343 ,p_attribute17 out nocopy varchar2
344 ,p_attribute18 out nocopy varchar2
345 ,p_attribute19 out nocopy varchar2
346 ,p_attribute20 out nocopy varchar2
347 ,p_attribute21 out nocopy varchar2
348 ,p_attribute22 out nocopy varchar2
349 ,p_attribute23 out nocopy varchar2
350 ,p_attribute24 out nocopy varchar2
351 ,p_attribute25 out nocopy varchar2
352 ,p_attribute26 out nocopy varchar2
353 ,p_attribute27 out nocopy varchar2
354 ,p_attribute28 out nocopy varchar2
355 ,p_attribute29 out nocopy varchar2
356 ,p_attribute30 out nocopy varchar2
357 ,p_information_category out NOCOPY varchar2
358 ,p_information1 out nocopy varchar2
359 ,p_information2 out nocopy varchar2
360 ,p_information3 out nocopy varchar2
361 ,p_information4 out nocopy varchar2
362 ,p_information5 out nocopy varchar2
363 ,p_information6 out nocopy varchar2
364 ,p_information7 out nocopy varchar2
365 ,p_information8 out nocopy varchar2
366 ,p_information9 out nocopy varchar2
367 ,p_information10 out nocopy varchar2
368 ,p_information11 out nocopy varchar2
369 ,p_information12 out nocopy varchar2
370 ,p_information13 out nocopy varchar2
371 ,p_information14 out nocopy varchar2
372 ,p_information15 out nocopy varchar2
373 ,p_information16 out nocopy varchar2
374 ,p_information17 out nocopy varchar2
375 ,p_information18 out nocopy varchar2
376 ,p_information19 out nocopy varchar2
377 ,p_information20 out nocopy varchar2
378 ,p_information21 out nocopy varchar2
379 ,p_information22 out nocopy varchar2
380 ,p_information23 out nocopy varchar2
381 ,p_information24 out nocopy varchar2
382 ,p_information25 out nocopy varchar2
383 ,p_information26 out nocopy varchar2
384 ,p_information27 out nocopy varchar2
385 ,p_information28 out nocopy varchar2
386 ,p_information29 out nocopy varchar2
387 ,p_information30 out nocopy varchar2
388 ,p_clear_details out nocopy varchar2
389 );
390
391 PROCEDURE getEmpTransactionDetails
392 ( p_transaction_step_id in varchar2
393 ,p_person_id out nocopy number
394 ,period_of_service_id out nocopy number
395 ,p_object_version_number out nocopy number
396 ,p_actual_termination_date out nocopy Date
397 ,p_leaving_reason out nocopy varchar2
398 ,p_notified_termination_date out nocopy Date
399 ,p_comments out nocopy varchar2
400 ,p_last_standard_process_date out nocopy Date
401 ,p_projected_termination_date out nocopy Date
402 ,p_final_process_date out nocopy Date
403 ,p_rehire_recommendation out nocopy varchar2
404 ,p_attribute_category out nocopy varchar2
405 ,p_attribute1 out nocopy varchar2
406 ,p_attribute2 out nocopy varchar2
407 ,p_attribute3 out nocopy varchar2
408 ,p_attribute4 out nocopy varchar2
409 ,p_attribute5 out nocopy varchar2
410 ,p_attribute6 out nocopy varchar2
411 ,p_attribute7 out nocopy varchar2
412 ,p_attribute8 out nocopy varchar2
413 ,p_attribute9 out nocopy varchar2
414 ,p_attribute10 out nocopy varchar2
415 ,p_attribute11 out nocopy varchar2
416 ,p_attribute12 out nocopy varchar2
417 ,p_attribute13 out nocopy varchar2
418 ,p_attribute14 out nocopy varchar2
419 ,p_attribute15 out nocopy varchar2
420 ,p_attribute16 out nocopy varchar2
421 ,p_attribute17 out nocopy varchar2
422 ,p_attribute18 out nocopy varchar2
423 ,p_attribute19 out nocopy varchar2
424 ,p_attribute20 out nocopy varchar2
425 ,p_pds_information_category out NOCOPY varchar2
426 ,p_pds_information1 out nocopy varchar2
427 ,p_pds_information2 out nocopy varchar2
428 ,p_pds_information3 out nocopy varchar2
429 ,p_pds_information4 out nocopy varchar2
430 ,p_pds_information5 out nocopy varchar2
431 ,p_pds_information6 out nocopy varchar2
432 ,p_pds_information7 out nocopy varchar2
433 ,p_pds_information8 out nocopy varchar2
434 ,p_pds_information9 out nocopy varchar2
435 ,p_pds_information10 out nocopy varchar2
436 ,p_pds_information11 out nocopy varchar2
437 ,p_pds_information12 out nocopy varchar2
438 ,p_pds_information13 out nocopy varchar2
439 ,p_pds_information14 out nocopy varchar2
440 ,p_pds_information15 out nocopy varchar2
441 ,p_pds_information16 out nocopy varchar2
442 ,p_pds_information17 out nocopy varchar2
443 ,p_pds_information18 out nocopy varchar2
444 ,p_pds_information19 out nocopy varchar2
445 ,p_pds_information20 out nocopy varchar2
446 ,p_pds_information21 out nocopy varchar2
447 ,p_pds_information22 out nocopy varchar2
448 ,p_pds_information23 out nocopy varchar2
449 ,p_pds_information24 out nocopy varchar2
450 ,p_pds_information25 out nocopy varchar2
451 ,p_pds_information26 out nocopy varchar2
452 ,p_pds_information27 out nocopy varchar2
453 ,p_pds_information28 out nocopy varchar2
454 ,p_pds_information29 out nocopy varchar2
455 ,p_pds_information30 out nocopy varchar2
456 ,p_clear_details out nocopy varchar2
457 ,p_rehire_reason out nocopy varchar2
458 );
459
460 END hr_revtermination_ss;