1 PACKAGE hr_termination_ss AUTHID CURRENT_USER AS
2 /* $Header: hrtrmwrs.pkh 120.1.12020000.3 2013/03/08 10:21:33 sudedas ship $ */
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_TERMINATION_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 || FUNCTION: update_object_version
45 || DESCRIPTION: Update the object version number in the transaction step
46 || to pass the invalid object api error for Save for Later.
47 ||=======================================================================
48 */
49 PROCEDURE update_object_version
50 (p_transaction_step_id in number
51 ,p_login_person_id in number);
52
53 --
54 --
55 /*
56 ||===========================================================================
57 || FUNCTION: branch_on_subordinate_presence
58 || DESCRIPTION:
59 || This procedure will read the CURRENT_PERSON_ID item level
60 || attribute value and then find out nocopy if the employee to be terminated
61 || has any subordinates or not. If he has, this procedure will set
62 || the wf result code to "Y". So, workflow will transition to the
63 || Supevisor page accordingly.
64 || This procedure will set the wf transition code as follows:
65 || (Y/N)
66 || For 'Y' => branch to Supervisor page
67 || 'N' => do not branch to Supervisor page
68 ||=======================================================================
69 */
70 PROCEDURE branch_on_subordinate_presence
71 (itemtype in varchar2
72 ,itemkey in varchar2
73 ,actid in number
74 ,funcmode in varchar2
75 ,resultout out nocopy varchar2);
76 --
77 --
78 /*
79 ||===========================================================================
80 || PROCEDURE: actual_termination_emp
81 ||---------------------------------------------------------------------------
82 ||
83 || Description:
84 || This procedure will call the actual API -
85 || hr_ex_employee_api.actual_termination_emp
86 ||
87 || Pre Conditions:
88 ||
89 || In Arguments:
90 || Contains entire list of parameters that are defined in the actual
91 || API. For details see peexeapi.pkb file.
92 ||
93 || out nocopy Arguments:
94 ||
95 || In out nocopy Arguments:
96 ||
97 || Post Success:
98 || Executes the API call.
99 ||
100 || Post Failure:
101 || Raises an exception
102 ||
103 || Access Status:
104 || Public.
105 ||
106 ||===========================================================================
107 */
108 procedure actual_termination_emp
109 (p_validate in number default 0
110 ,p_effective_date in date
111 ,p_period_of_service_id in number
112 ,p_object_version_number in out nocopy number
113 ,p_actual_termination_date in date
114 ,p_last_standard_process_date in out nocopy date
115 ,p_person_type_id in number default hr_api.g_number
116 ,p_assignment_status_type_id in number default hr_api.g_number
117 ,p_leaving_reason in varchar2 default hr_api.g_varchar2
118 ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
119 ,p_rehire_reason in varchar2 default hr_api.g_varchar2
120 ,p_termination_accepted_person in number default hr_api.g_number
121 ,p_accepted_termination_date in date default hr_api.g_date
122 ,p_comments in varchar2 default hr_api.g_varchar2
123 ,p_notified_termination_date in date default hr_api.g_date
124 ,p_projected_termination_date in date default hr_api.g_date
125 ,p_final_process_date in out nocopy date
126 ,p_attribute_category in varchar2 default hr_api.g_varchar2
127 ,p_attribute1 in varchar2 default hr_api.g_varchar2
128 ,p_attribute2 in varchar2 default hr_api.g_varchar2
129 ,p_attribute3 in varchar2 default hr_api.g_varchar2
130 ,p_attribute4 in varchar2 default hr_api.g_varchar2
131 ,p_attribute5 in varchar2 default hr_api.g_varchar2
132 ,p_attribute6 in varchar2 default hr_api.g_varchar2
133 ,p_attribute7 in varchar2 default hr_api.g_varchar2
134 ,p_attribute8 in varchar2 default hr_api.g_varchar2
135 ,p_attribute9 in varchar2 default hr_api.g_varchar2
136 ,p_attribute10 in varchar2 default hr_api.g_varchar2
137 ,p_attribute11 in varchar2 default hr_api.g_varchar2
138 ,p_attribute12 in varchar2 default hr_api.g_varchar2
139 ,p_attribute13 in varchar2 default hr_api.g_varchar2
140 ,p_attribute14 in varchar2 default hr_api.g_varchar2
141 ,p_attribute15 in varchar2 default hr_api.g_varchar2
142 ,p_attribute16 in varchar2 default hr_api.g_varchar2
143 ,p_attribute17 in varchar2 default hr_api.g_varchar2
144 ,p_attribute18 in varchar2 default hr_api.g_varchar2
145 ,p_attribute19 in varchar2 default hr_api.g_varchar2
146 ,p_attribute20 in varchar2 default hr_api.g_varchar2
147 ,p_pds_information_category in varchar2 default hr_api.g_varchar2
148 ,p_pds_information1 in varchar2 default hr_api.g_varchar2
149 ,p_pds_information2 in varchar2 default hr_api.g_varchar2
150 ,p_pds_information3 in varchar2 default hr_api.g_varchar2
151 ,p_pds_information4 in varchar2 default hr_api.g_varchar2
152 ,p_pds_information5 in varchar2 default hr_api.g_varchar2
153 ,p_pds_information6 in varchar2 default hr_api.g_varchar2
154 ,p_pds_information7 in varchar2 default hr_api.g_varchar2
155 ,p_pds_information8 in varchar2 default hr_api.g_varchar2
156 ,p_pds_information9 in varchar2 default hr_api.g_varchar2
157 ,p_pds_information10 in varchar2 default hr_api.g_varchar2
158 ,p_pds_information11 in varchar2 default hr_api.g_varchar2
159 ,p_pds_information12 in varchar2 default hr_api.g_varchar2
160 ,p_pds_information13 in varchar2 default hr_api.g_varchar2
161 ,p_pds_information14 in varchar2 default hr_api.g_varchar2
162 ,p_pds_information15 in varchar2 default hr_api.g_varchar2
163 ,p_pds_information16 in varchar2 default hr_api.g_varchar2
164 ,p_pds_information17 in varchar2 default hr_api.g_varchar2
165 ,p_pds_information18 in varchar2 default hr_api.g_varchar2
166 ,p_pds_information19 in varchar2 default hr_api.g_varchar2
167 ,p_pds_information20 in varchar2 default hr_api.g_varchar2
168 ,p_pds_information21 in varchar2 default hr_api.g_varchar2
169 ,p_pds_information22 in varchar2 default hr_api.g_varchar2
170 ,p_pds_information23 in varchar2 default hr_api.g_varchar2
171 ,p_pds_information24 in varchar2 default hr_api.g_varchar2
172 ,p_pds_information25 in varchar2 default hr_api.g_varchar2
173 ,p_pds_information26 in varchar2 default hr_api.g_varchar2
174 ,p_pds_information27 in varchar2 default hr_api.g_varchar2
175 ,p_pds_information28 in varchar2 default hr_api.g_varchar2
176 ,p_pds_information29 in varchar2 default hr_api.g_varchar2
177 ,p_pds_information30 in varchar2 default hr_api.g_varchar2
178 ,p_supervisor_warning out nocopy number
179 ,p_event_warning out nocopy number
180 ,p_interview_warning out nocopy number
181 ,p_review_warning out nocopy number
182 ,p_recruiter_warning out nocopy number
183 ,p_asg_future_changes_warning out nocopy number
184 ,p_entries_changed_warning out nocopy varchar2
185 ,p_pay_proposal_warning out nocopy number
186 ,p_dod_warning out nocopy number
187 ,p_error_message out nocopy long
188 );
189
190
191 /*
192 ||===========================================================================
193 || PROCEDURE: update_pds_details
194 ||---------------------------------------------------------------------------
195 ||
196 || Description:
197 || This procedure will call the actual API -
198 || hr_periods_of_service_api.update_pds_details
199 ||
200 || Pre Conditions:
201 ||
202 || In Arguments:
203 || Contains entire list of parameters that are defined in the actual
204 || API. For details see pepdsapi.pkb file.
205 ||
206 || out nocopy Arguments:
207 ||
208 || In out nocopy Arguments:
209 ||
210 || Post Success:
211 || Executes the API call.
212 ||
213 || Post Failure:
214 || Raises an exception
215 ||
216 || Access Status:
217 || Public.
218 ||
219 ||===========================================================================
220 */
221 procedure update_pds_details
222 (p_validate in number default 0
223 ,p_effective_date in date
224 ,p_period_of_service_id in number
225 ,p_termination_accepted_person in number default hr_api.g_number
226 ,p_accepted_termination_date in date default hr_api.g_date
227 ,p_object_version_number in out nocopy number
228 ,p_comments in varchar2 default hr_api.g_varchar2
229 ,p_leaving_reason in varchar2 default hr_api.g_varchar2
230 ,p_notified_termination_date in date default hr_api.g_date
231 ,p_projected_termination_date in date default hr_api.g_date
232 ,p_attribute_category in varchar2 default hr_api.g_varchar2
233 ,p_attribute1 in varchar2 default hr_api.g_varchar2
234 ,p_attribute2 in varchar2 default hr_api.g_varchar2
235 ,p_attribute3 in varchar2 default hr_api.g_varchar2
236 ,p_attribute4 in varchar2 default hr_api.g_varchar2
237 ,p_attribute5 in varchar2 default hr_api.g_varchar2
238 ,p_attribute6 in varchar2 default hr_api.g_varchar2
239 ,p_attribute7 in varchar2 default hr_api.g_varchar2
240 ,p_attribute8 in varchar2 default hr_api.g_varchar2
241 ,p_attribute9 in varchar2 default hr_api.g_varchar2
242 ,p_attribute10 in varchar2 default hr_api.g_varchar2
243 ,p_attribute11 in varchar2 default hr_api.g_varchar2
244 ,p_attribute12 in varchar2 default hr_api.g_varchar2
245 ,p_attribute13 in varchar2 default hr_api.g_varchar2
246 ,p_attribute14 in varchar2 default hr_api.g_varchar2
247 ,p_attribute15 in varchar2 default hr_api.g_varchar2
248 ,p_attribute16 in varchar2 default hr_api.g_varchar2
249 ,p_attribute17 in varchar2 default hr_api.g_varchar2
250 ,p_attribute18 in varchar2 default hr_api.g_varchar2
251 ,p_attribute19 in varchar2 default hr_api.g_varchar2
252 ,p_attribute20 in varchar2 default hr_api.g_varchar2
253 ,p_pds_information_category in varchar2 default hr_api.g_varchar2
254 ,p_pds_information1 in varchar2 default hr_api.g_varchar2
255 ,p_pds_information2 in varchar2 default hr_api.g_varchar2
256 ,p_pds_information3 in varchar2 default hr_api.g_varchar2
257 ,p_pds_information4 in varchar2 default hr_api.g_varchar2
258 ,p_pds_information5 in varchar2 default hr_api.g_varchar2
259 ,p_pds_information6 in varchar2 default hr_api.g_varchar2
260 ,p_pds_information7 in varchar2 default hr_api.g_varchar2
261 ,p_pds_information8 in varchar2 default hr_api.g_varchar2
262 ,p_pds_information9 in varchar2 default hr_api.g_varchar2
263 ,p_pds_information10 in varchar2 default hr_api.g_varchar2
264 ,p_pds_information11 in varchar2 default hr_api.g_varchar2
265 ,p_pds_information12 in varchar2 default hr_api.g_varchar2
266 ,p_pds_information13 in varchar2 default hr_api.g_varchar2
267 ,p_pds_information14 in varchar2 default hr_api.g_varchar2
268 ,p_pds_information15 in varchar2 default hr_api.g_varchar2
269 ,p_pds_information16 in varchar2 default hr_api.g_varchar2
270 ,p_pds_information17 in varchar2 default hr_api.g_varchar2
271 ,p_pds_information18 in varchar2 default hr_api.g_varchar2
272 ,p_pds_information19 in varchar2 default hr_api.g_varchar2
273 ,p_pds_information20 in varchar2 default hr_api.g_varchar2
274 ,p_pds_information21 in varchar2 default hr_api.g_varchar2
275 ,p_pds_information22 in varchar2 default hr_api.g_varchar2
276 ,p_pds_information23 in varchar2 default hr_api.g_varchar2
277 ,p_pds_information24 in varchar2 default hr_api.g_varchar2
278 ,p_pds_information25 in varchar2 default hr_api.g_varchar2
279 ,p_pds_information26 in varchar2 default hr_api.g_varchar2
280 ,p_pds_information27 in varchar2 default hr_api.g_varchar2
281 ,p_pds_information28 in varchar2 default hr_api.g_varchar2
282 ,p_pds_information29 in varchar2 default hr_api.g_varchar2
283 ,p_pds_information30 in varchar2 default hr_api.g_varchar2
284 );
285
286 /*
287 ||===========================================================================
288 || PROCEDURE: process_save
289 ||---------------------------------------------------------------------------
290 ||
291 || Description:
292 || Save Termination Transaction to transaction table
293 ||
294 || Pre Conditions:
295 ||
296 || In Arguments:
297 || Transaction details that need to be saved to transaction table
298 ||
299 || out nocopy Arguments:
300 || None.
301 ||
302 || In out nocopy Arguments:
303 ||
304 || Post Success:
305 || Writes to transaction table
306 ||
307 || Post Failure:
308 || Raises an exception
309 ||
310 || Access Status:
311 || Public
312 ||
313 ||===========================================================================
314 */
315 procedure process_save
316 (p_item_type in wf_items.item_type%TYPE
317 ,p_item_key in wf_items.item_key%TYPE
318 ,p_actid in varchar2
319 ,p_effective_date in varchar2 default hr_api.g_varchar2
320 ,p_period_of_service_id in varchar2 default hr_api.g_varchar2
321 ,p_object_version_number in varchar2 default hr_api.g_varchar2
322 ,p_actual_termination_date in varchar2 default hr_api.g_varchar2
323 ,p_notified_termination_date in varchar2 default hr_api.g_varchar2
324 ,p_leaving_reason in varchar2 default hr_api.g_varchar2
325 ,p_comments in varchar2 default hr_api.g_varchar2
326 ,p_login_person_id in number
327 ,p_person_id in number
328 ,p_attribute_category in varchar2 default hr_api.g_varchar2
329 ,p_attribute1 in varchar2 default hr_api.g_varchar2
330 ,p_attribute2 in varchar2 default hr_api.g_varchar2
331 ,p_attribute3 in varchar2 default hr_api.g_varchar2
332 ,p_attribute4 in varchar2 default hr_api.g_varchar2
333 ,p_attribute5 in varchar2 default hr_api.g_varchar2
334 ,p_attribute6 in varchar2 default hr_api.g_varchar2
335 ,p_attribute7 in varchar2 default hr_api.g_varchar2
336 ,p_attribute8 in varchar2 default hr_api.g_varchar2
337 ,p_attribute9 in varchar2 default hr_api.g_varchar2
338 ,p_attribute10 in varchar2 default hr_api.g_varchar2
339 ,p_attribute11 in varchar2 default hr_api.g_varchar2
340 ,p_attribute12 in varchar2 default hr_api.g_varchar2
341 ,p_attribute13 in varchar2 default hr_api.g_varchar2
342 ,p_attribute14 in varchar2 default hr_api.g_varchar2
343 ,p_attribute15 in varchar2 default hr_api.g_varchar2
344 ,p_attribute16 in varchar2 default hr_api.g_varchar2
345 ,p_attribute17 in varchar2 default hr_api.g_varchar2
346 ,p_attribute18 in varchar2 default hr_api.g_varchar2
347 ,p_attribute19 in varchar2 default hr_api.g_varchar2
348 ,p_attribute20 in varchar2 default hr_api.g_varchar2
349 ,p_review_proc_call in varchar2 default hr_api.g_varchar2
350 ,p_pds_information_category in varchar2 default hr_api.g_varchar2
351 ,p_pds_information1 in varchar2 default hr_api.g_varchar2
352 ,p_pds_information2 in varchar2 default hr_api.g_varchar2
353 ,p_pds_information3 in varchar2 default hr_api.g_varchar2
354 ,p_pds_information4 in varchar2 default hr_api.g_varchar2
355 ,p_pds_information5 in varchar2 default hr_api.g_varchar2
356 ,p_pds_information6 in varchar2 default hr_api.g_varchar2
357 ,p_pds_information7 in varchar2 default hr_api.g_varchar2
358 ,p_pds_information8 in varchar2 default hr_api.g_varchar2
359 ,p_pds_information9 in varchar2 default hr_api.g_varchar2
360 ,p_pds_information10 in varchar2 default hr_api.g_varchar2
361 ,p_pds_information11 in varchar2 default hr_api.g_varchar2
362 ,p_pds_information12 in varchar2 default hr_api.g_varchar2
363 ,p_pds_information13 in varchar2 default hr_api.g_varchar2
364 ,p_pds_information14 in varchar2 default hr_api.g_varchar2
365 ,p_pds_information15 in varchar2 default hr_api.g_varchar2
366 ,p_pds_information16 in varchar2 default hr_api.g_varchar2
367 ,p_pds_information17 in varchar2 default hr_api.g_varchar2
368 ,p_pds_information18 in varchar2 default hr_api.g_varchar2
369 ,p_pds_information19 in varchar2 default hr_api.g_varchar2
370 ,p_pds_information20 in varchar2 default hr_api.g_varchar2
371 ,p_pds_information21 in varchar2 default hr_api.g_varchar2
372 ,p_pds_information22 in varchar2 default hr_api.g_varchar2
373 ,p_pds_information23 in varchar2 default hr_api.g_varchar2
374 ,p_pds_information24 in varchar2 default hr_api.g_varchar2
375 ,p_pds_information25 in varchar2 default hr_api.g_varchar2
376 ,p_pds_information26 in varchar2 default hr_api.g_varchar2
377 ,p_pds_information27 in varchar2 default hr_api.g_varchar2
378 ,p_pds_information28 in varchar2 default hr_api.g_varchar2
379 ,p_pds_information29 in varchar2 default hr_api.g_varchar2
380 ,p_pds_information30 in varchar2 default hr_api.g_varchar2
381 ,p_person_type_id in number default hr_api.g_number
382 ,p_assignment_status_type_id in number default hr_api.g_number
383 ,p_effective_date_option in varchar2 default hr_api.g_varchar2
384 ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
385 ,p_rehire_reason in varchar2 default hr_api.g_varchar2
386 ,p_last_standard_process_date in varchar2 default hr_api.g_varchar2
387 ,p_projected_termination_date in varchar2 default hr_api.g_varchar2
388 ,p_final_process_date in varchar2 default hr_api.g_varchar2
389 );
390
391 /*
392 ||==========================================================================
393 || PROCEDURE: process_api
394 ||--------------------------------------------------------------------------
395 ||
396 || Description:
397 || This procedure is invoked whenever approvers have approved the
398 || termination proposal. It is called from workflow.
399 || It will call the termination APIs to update hr tables.
400 ||
401 || Pre-Requisities:
402 || The transaction step must exist.
403 ||
404 || In Parameters:
405 || p_validate Determines if the API should be called in
406 || validate mode.
407 || p_transaction_step_id Specifies which transaction step is to be
408 || processed.
409 ||
410 || Post Success:
411 || Termination APIs will be processed.
412 ||
413 || Post Failure:
414 || None
415 ||
416 || Access Status:
417 || Public.
418 ||
419 ||==========================================================================
420 */
421 PROCEDURE process_api (
422 p_validate IN BOOLEAN DEFAULT FALSE,
423 p_transaction_step_id IN NUMBER DEFAULT NULL,
424 p_effective_date IN VARCHAR2 DEFAULT NULL
425 );
426
427 /*
428 ||===========================================================================
429 || PROCEDURE: get_term_transaction
430 ||---------------------------------------------------------------------------
431 ||
432 || Description:
433 || Reads Termination Transaction from transaction table
434 ||
435 || Pre Conditions:
436 ||
437 || In Arguments:
438 || Transaction id keys
439 ||
440 || out nocopy Arguments:
441 || None.
442 ||
443 || In out nocopy Arguments:
444 ||
445 || Post Success:
446 || Reads from transaction table
447 ||
448 || Post Failure:
449 || Raises an exception
450 ||
451 || Access Status:
452 || Public
453 ||
454 ||===========================================================================
455 */
456 procedure get_term_transaction
457 (p_transaction_step_id in varchar2
458 ,p_period_of_service_id out nocopy varchar2
459 ,p_object_version_number out nocopy varchar2
460 ,p_actual_termination_date out nocopy varchar2
461 ,p_notified_termination_date out nocopy varchar2
462 ,p_leaving_reason out nocopy varchar2
463 ,p_person_type_id out nocopy varchar2
464 ,p_assignment_status_type_id out nocopy varchar2
465 ,p_rehire_recommendation out nocopy varchar2
466 ,p_rehire_reason out nocopy varchar2
467 ,p_comments out nocopy varchar2
468 ,p_last_standard_process_date out nocopy varchar2
469 ,p_projected_termination_date out nocopy varchar2
470 ,p_final_process_date out nocopy varchar2
471 ,p_attribute_category out nocopy varchar2
472 ,p_attribute1 out nocopy varchar2
473 ,p_attribute2 out nocopy varchar2
474 ,p_attribute3 out nocopy varchar2
475 ,p_attribute4 out nocopy varchar2
476 ,p_attribute5 out nocopy varchar2
477 ,p_attribute6 out nocopy varchar2
478 ,p_attribute7 out nocopy varchar2
479 ,p_attribute8 out nocopy varchar2
480 ,p_attribute9 out nocopy varchar2
481 ,p_attribute10 out nocopy varchar2
482 ,p_attribute11 out nocopy varchar2
483 ,p_attribute12 out nocopy varchar2
484 ,p_attribute13 out nocopy varchar2
485 ,p_attribute14 out nocopy varchar2
486 ,p_attribute15 out nocopy varchar2
487 ,p_attribute16 out nocopy varchar2
488 ,p_attribute17 out nocopy varchar2
489 ,p_attribute18 out nocopy varchar2
490 ,p_attribute19 out nocopy varchar2
491 ,p_attribute20 out nocopy varchar2
492 ,p_review_actid out nocopy varchar2
493 ,p_review_proc_call out nocopy varchar2
494 ,p_pds_information_category out nocopy varchar2
495 ,p_pds_information1 out nocopy varchar2
496 ,p_pds_information2 out nocopy varchar2
497 ,p_pds_information3 out nocopy varchar2
498 ,p_pds_information4 out nocopy varchar2
499 ,p_pds_information5 out nocopy varchar2
500 ,p_pds_information6 out nocopy varchar2
501 ,p_pds_information7 out nocopy varchar2
502 ,p_pds_information8 out nocopy varchar2
503 ,p_pds_information9 out nocopy varchar2
504 ,p_pds_information10 out nocopy varchar2
505 ,p_pds_information11 out nocopy varchar2
506 ,p_pds_information12 out nocopy varchar2
507 ,p_pds_information13 out nocopy varchar2
508 ,p_pds_information14 out nocopy varchar2
509 ,p_pds_information15 out nocopy varchar2
510 ,p_pds_information16 out nocopy varchar2
511 ,p_pds_information17 out nocopy varchar2
512 ,p_pds_information18 out nocopy varchar2
513 ,p_pds_information19 out nocopy varchar2
514 ,p_pds_information20 out nocopy varchar2
515 ,p_pds_information21 out nocopy varchar2
516 ,p_pds_information22 out nocopy varchar2
517 ,p_pds_information23 out nocopy varchar2
518 ,p_pds_information24 out nocopy varchar2
519 ,p_pds_information25 out nocopy varchar2
520 ,p_pds_information26 out nocopy varchar2
521 ,p_pds_information27 out nocopy varchar2
522 ,p_pds_information28 out nocopy varchar2
523 ,p_pds_information29 out nocopy varchar2
524 ,p_pds_information30 out nocopy varchar2
525 );
526
527 -- Introduced for Quick Termination functionality
528 --
529 Procedure moveAllDirectReports(
530 p_validate in varchar2 default 'Y',
531 p_old_sup_person_id in number,
532 p_old_sup_bg_id in number,
533 p_old_sup_asg_id in number,
534 p_term_date in varchar2,
535 p_flow_identifier in varchar2,
536 p_new_sup_person_id in number,
537 p_new_sup_asg_id in number,
538 p_login_person_id in number,
539 p_item_type in varchar2,
540 p_item_key in varchar2
541 ) ;
542
543 END hr_termination_ss;
[Home] [Help]