1 Package hr_ex_employee_api AUTHID CURRENT_USER as
2 /* $Header: peexeapi.pkh 120.5.12020000.2 2013/01/18 07:19:00 srannama ship $ */
3 /*#
4 * This package contains Ex-Employee APIs.
5 * @rep:scope public
6 * @rep:product per
7 * @rep:displayname Ex-Employee
8 */
9 -- ER FPT
10 g_fpt_termination varchar2(1) := 'N';
11 --
12 -- 120.4 (START)
13 --
14 -- Added overloaded procedure for new ALU Warning parameter
15 --
16 -- ----------------------------------------------------------------------------
17 -- |--------------------------< actual_termination_emp >----------------------|
18 -- ----------------------------------------------------------------------------
19 --
20 -- This version of the API is now out-of-date however it has been provided to
21 -- you for backward compatibility support and will be removed in the future.
22 -- Oracle recommends you to modify existing calling programs in advance of the
23 -- support being withdrawn thus avoiding any potential disruption.
24 --
25 procedure actual_termination_emp
26 (p_validate in boolean default false
27 ,p_effective_date in date
28 ,p_period_of_service_id in number
29 ,p_object_version_number in out nocopy number
30 ,p_actual_termination_date in date
31 ,p_last_standard_process_date in date default hr_api.g_date
32 ,p_person_type_id in number default hr_api.g_number
33 ,p_assignment_status_type_id in number default hr_api.g_number
34 ,p_leaving_reason in varchar2 default hr_api.g_varchar2
38 ,p_attribute1 in varchar2 default hr_api.g_varchar2
35 ,p_atd_new in number default hr_api.g_true_num
36 ,p_lspd_new in number default hr_api.g_true_num
37 ,p_attribute_category in varchar2 default hr_api.g_varchar2
39 ,p_attribute2 in varchar2 default hr_api.g_varchar2
40 ,p_attribute3 in varchar2 default hr_api.g_varchar2
41 ,p_attribute4 in varchar2 default hr_api.g_varchar2
42 ,p_attribute5 in varchar2 default hr_api.g_varchar2
43 ,p_attribute6 in varchar2 default hr_api.g_varchar2
44 ,p_attribute7 in varchar2 default hr_api.g_varchar2
45 ,p_attribute8 in varchar2 default hr_api.g_varchar2
46 ,p_attribute9 in varchar2 default hr_api.g_varchar2
47 ,p_attribute10 in varchar2 default hr_api.g_varchar2
48 ,p_attribute11 in varchar2 default hr_api.g_varchar2
49 ,p_attribute12 in varchar2 default hr_api.g_varchar2
50 ,p_attribute13 in varchar2 default hr_api.g_varchar2
51 ,p_attribute14 in varchar2 default hr_api.g_varchar2
52 ,p_attribute15 in varchar2 default hr_api.g_varchar2
53 ,p_attribute16 in varchar2 default hr_api.g_varchar2
54 ,p_attribute17 in varchar2 default hr_api.g_varchar2
55 ,p_attribute18 in varchar2 default hr_api.g_varchar2
56 ,p_attribute19 in varchar2 default hr_api.g_varchar2
57 ,p_attribute20 in varchar2 default hr_api.g_varchar2
58 ,p_pds_information_category in varchar2 default hr_api.g_varchar2
59 ,p_pds_information1 in varchar2 default hr_api.g_varchar2
60 ,p_pds_information2 in varchar2 default hr_api.g_varchar2
61 ,p_pds_information3 in varchar2 default hr_api.g_varchar2
62 ,p_pds_information4 in varchar2 default hr_api.g_varchar2
63 ,p_pds_information5 in varchar2 default hr_api.g_varchar2
64 ,p_pds_information6 in varchar2 default hr_api.g_varchar2
65 ,p_pds_information7 in varchar2 default hr_api.g_varchar2
66 ,p_pds_information8 in varchar2 default hr_api.g_varchar2
67 ,p_pds_information9 in varchar2 default hr_api.g_varchar2
68 ,p_pds_information10 in varchar2 default hr_api.g_varchar2
69 ,p_pds_information11 in varchar2 default hr_api.g_varchar2
70 ,p_pds_information12 in varchar2 default hr_api.g_varchar2
71 ,p_pds_information13 in varchar2 default hr_api.g_varchar2
72 ,p_pds_information14 in varchar2 default hr_api.g_varchar2
73 ,p_pds_information15 in varchar2 default hr_api.g_varchar2
74 ,p_pds_information16 in varchar2 default hr_api.g_varchar2
75 ,p_pds_information17 in varchar2 default hr_api.g_varchar2
76 ,p_pds_information18 in varchar2 default hr_api.g_varchar2
77 ,p_pds_information19 in varchar2 default hr_api.g_varchar2
78 ,p_pds_information20 in varchar2 default hr_api.g_varchar2
79 ,p_pds_information21 in varchar2 default hr_api.g_varchar2
80 ,p_pds_information22 in varchar2 default hr_api.g_varchar2
81 ,p_pds_information23 in varchar2 default hr_api.g_varchar2
82 ,p_pds_information24 in varchar2 default hr_api.g_varchar2
83 ,p_pds_information25 in varchar2 default hr_api.g_varchar2
84 ,p_pds_information26 in varchar2 default hr_api.g_varchar2
85 ,p_pds_information27 in varchar2 default hr_api.g_varchar2
86 ,p_pds_information28 in varchar2 default hr_api.g_varchar2
87 ,p_pds_information29 in varchar2 default hr_api.g_varchar2
88 ,p_pds_information30 in varchar2 default hr_api.g_varchar2
89 ,p_last_std_process_date_out out nocopy date
90 ,p_supervisor_warning out nocopy boolean
91 ,p_event_warning out nocopy boolean
92 ,p_interview_warning out nocopy boolean
93 ,p_review_warning out nocopy boolean
94 ,p_recruiter_warning out nocopy boolean
95 ,p_asg_future_changes_warning out nocopy boolean
96 ,p_entries_changed_warning out nocopy varchar2
97 ,p_pay_proposal_warning out nocopy boolean
98 ,p_dod_warning out nocopy boolean
99 ,p_alu_change_warning out nocopy varchar2
100 );
101 --
102 -- 120.4 (END)
103 --
104 -- ----------------------------------------------------------------------------
105 -- |--------------------------< actual_termination_emp >----------------------|
106 -- ----------------------------------------------------------------------------
107 --
108 -- This version of the API is now out-of-date however it has been provided to
109 -- you for backward compatibility support and will be removed in the future.
110 -- Oracle recommends you to modify existing calling programs in advance of the
111 -- support being withdrawn thus avoiding any potential disruption.
112 --
113 procedure actual_termination_emp
114 (p_validate in boolean default false
115 ,p_effective_date in date
116 ,p_period_of_service_id in number
117 ,p_object_version_number in out nocopy number
118 ,p_actual_termination_date in date
119 ,p_last_standard_process_date in date default hr_api.g_date
120 ,p_person_type_id in number default hr_api.g_number
121 ,p_assignment_status_type_id in number default hr_api.g_number
125 ,p_attribute2 in varchar2 default hr_api.g_varchar2
122 ,p_leaving_reason in varchar2 default hr_api.g_varchar2
123 ,p_attribute_category in varchar2 default hr_api.g_varchar2
124 ,p_attribute1 in varchar2 default hr_api.g_varchar2
126 ,p_attribute3 in varchar2 default hr_api.g_varchar2
127 ,p_attribute4 in varchar2 default hr_api.g_varchar2
128 ,p_attribute5 in varchar2 default hr_api.g_varchar2
129 ,p_attribute6 in varchar2 default hr_api.g_varchar2
130 ,p_attribute7 in varchar2 default hr_api.g_varchar2
131 ,p_attribute8 in varchar2 default hr_api.g_varchar2
132 ,p_attribute9 in varchar2 default hr_api.g_varchar2
133 ,p_attribute10 in varchar2 default hr_api.g_varchar2
134 ,p_attribute11 in varchar2 default hr_api.g_varchar2
135 ,p_attribute12 in varchar2 default hr_api.g_varchar2
136 ,p_attribute13 in varchar2 default hr_api.g_varchar2
137 ,p_attribute14 in varchar2 default hr_api.g_varchar2
138 ,p_attribute15 in varchar2 default hr_api.g_varchar2
139 ,p_attribute16 in varchar2 default hr_api.g_varchar2
140 ,p_attribute17 in varchar2 default hr_api.g_varchar2
141 ,p_attribute18 in varchar2 default hr_api.g_varchar2
142 ,p_attribute19 in varchar2 default hr_api.g_varchar2
143 ,p_attribute20 in varchar2 default hr_api.g_varchar2
144 ,p_pds_information_category in varchar2 default hr_api.g_varchar2
145 ,p_pds_information1 in varchar2 default hr_api.g_varchar2
146 ,p_pds_information2 in varchar2 default hr_api.g_varchar2
147 ,p_pds_information3 in varchar2 default hr_api.g_varchar2
148 ,p_pds_information4 in varchar2 default hr_api.g_varchar2
149 ,p_pds_information5 in varchar2 default hr_api.g_varchar2
150 ,p_pds_information6 in varchar2 default hr_api.g_varchar2
151 ,p_pds_information7 in varchar2 default hr_api.g_varchar2
152 ,p_pds_information8 in varchar2 default hr_api.g_varchar2
153 ,p_pds_information9 in varchar2 default hr_api.g_varchar2
154 ,p_pds_information10 in varchar2 default hr_api.g_varchar2
155 ,p_pds_information11 in varchar2 default hr_api.g_varchar2
156 ,p_pds_information12 in varchar2 default hr_api.g_varchar2
157 ,p_pds_information13 in varchar2 default hr_api.g_varchar2
158 ,p_pds_information14 in varchar2 default hr_api.g_varchar2
159 ,p_pds_information15 in varchar2 default hr_api.g_varchar2
160 ,p_pds_information16 in varchar2 default hr_api.g_varchar2
161 ,p_pds_information17 in varchar2 default hr_api.g_varchar2
162 ,p_pds_information18 in varchar2 default hr_api.g_varchar2
163 ,p_pds_information19 in varchar2 default hr_api.g_varchar2
164 ,p_pds_information20 in varchar2 default hr_api.g_varchar2
165 ,p_pds_information21 in varchar2 default hr_api.g_varchar2
166 ,p_pds_information22 in varchar2 default hr_api.g_varchar2
167 ,p_pds_information23 in varchar2 default hr_api.g_varchar2
168 ,p_pds_information24 in varchar2 default hr_api.g_varchar2
169 ,p_pds_information25 in varchar2 default hr_api.g_varchar2
170 ,p_pds_information26 in varchar2 default hr_api.g_varchar2
171 ,p_pds_information27 in varchar2 default hr_api.g_varchar2
172 ,p_pds_information28 in varchar2 default hr_api.g_varchar2
173 ,p_pds_information29 in varchar2 default hr_api.g_varchar2
174 ,p_pds_information30 in varchar2 default hr_api.g_varchar2
175 ,p_last_std_process_date_out out nocopy date
176 ,p_supervisor_warning out nocopy boolean
177 ,p_event_warning out nocopy boolean
178 ,p_interview_warning out nocopy boolean
179 ,p_review_warning out nocopy boolean
180 ,p_recruiter_warning out nocopy boolean
181 ,p_asg_future_changes_warning out nocopy boolean
182 ,p_entries_changed_warning out nocopy varchar2
183 ,p_pay_proposal_warning out nocopy boolean
184 ,p_dod_warning out nocopy boolean
185 );
186 --
187 -- 120.4 (START)
188 --
189 -- ----------------------------------------------------------------------------
190 -- |--------------------------< actual_termination_emp >----------------------|
191 -- ----------------------------------------------------------------------------
192 --
193 -- This version of the API is now out-of-date however it has been provided to
194 -- you for backward compatibility support and will be removed in the future.
195 -- Oracle recommends you to modify existing calling programs in advance of the
196 -- support being withdrawn thus avoiding any potential disruption.
197 --
198 procedure actual_termination_emp
199 (p_validate in boolean default false
200 ,p_effective_date in date
201 ,p_period_of_service_id in number
202 ,p_object_version_number in out nocopy number
203 ,p_actual_termination_date in date
204 ,p_last_standard_process_date in out nocopy date
205 ,p_person_type_id in number default hr_api.g_number
206 ,p_assignment_status_type_id in number default hr_api.g_number
207 ,p_leaving_reason in varchar2 default hr_api.g_varchar2
208 ,p_supervisor_warning out nocopy boolean
209 ,p_event_warning out nocopy boolean
210 ,p_interview_warning out nocopy boolean
211 ,p_review_warning out nocopy boolean
215 ,p_pay_proposal_warning out nocopy boolean
212 ,p_recruiter_warning out nocopy boolean
213 ,p_asg_future_changes_warning out nocopy boolean
214 ,p_entries_changed_warning out nocopy varchar2
216 ,p_dod_warning out nocopy boolean
217 );
218 --
219 -- 120.4 (END)
220 --
221 -- ----------------------------------------------------------------------------
222 -- |--------------------------< actual_termination_emp >----------------------|
223 -- ----------------------------------------------------------------------------
224 --
225 -- {Start Of Comments}
226 /*#
227 * This API terminates an employee.
228 *
229 * This API converts a person of type Employee >to a person of type
230 * Ex-Employee. The person's period of service and any employee assignments are
231 * ended.
232 *
233 * <p><b>Licensing</b><br>
234 * This API is licensed for use with Human Resources.
235 *
236 * <p><b>Prerequisites</b><br>
237 * The employee must exist in the relevant business group.
238 *
239 * <p><b>Post Success</b><br>
240 * The employee is terminated successfully.
241 *
242 * <p><b>Post Failure</b><br>
243 * The employee is not terminated and an error is raised.
244 * @param p_validate If true, then validation alone will be performed and the
245 * database will remain unchanged. If false and all validation checks pass,
246 * then the database will be modified.
247 * @param p_effective_date Determines when the DateTrack operation comes into
248 * force.
249 * @param p_period_of_service_id Period of service that is being terminated.
250 * @param p_object_version_number Pass in the current version number of the
251 * period of service to be updated. When the API completes if p_validate is
252 * false, will be set to the new version number of the updated period of
253 * service. If p_validate is true will be set to the same value which was
254 * passed in.
255 * @param p_actual_termination_date Actual termination date.
256 * @param p_last_standard_process_date Last standard process date
257 * @param p_person_type_id Type of employee being terminated.
258 * @param p_assignment_status_type_id Status of an employee in a specific
259 * assignment.
260 * @param p_leaving_reason Termination Reason. Valid values are defined by the
261 * LEAV_REAS lookup type.
262 * @param p_atd_new New Actual Termination Date entered flag. Set to 1 when
263 * a new date is entered else set to 0.
264 * @param p_lspd_new New Last Standard Process Date entered flag. Set to 1 when
265 * a new date is entered else set to 0.
266 * @param p_supervisor_warning If set to true, then this person is a supervisor
267 * for another, current or future assignment.
268 * @param p_event_warning If set to true, then this person is booked on at
269 * least one event in the past, present, or future.
270 * @param p_interview_warning If set to true, then this person is scheduled to
271 * be an interviewer or has interviews booked in the past, present, or future.
272 * @param p_review_warning If set to true, then this person has a review
273 * scheduled.
274 * @param p_recruiter_warning If set to true, then this person is a recruiter
275 * for a vacancy in the past, present, or future.
276 * @param p_asg_future_changes_warning If set to true, then at least one
277 * assignment change, after the actual termination date, has been overwritten
278 * with the new assignment status.
279 * @param p_entries_changed_warning Set to Y when at least one element entry is
280 * affected by the assignment change. Set to S if at least one salary element
281 * entry is affected. Otherwise, set to N.
282 * @param p_pay_proposal_warning If set to true, then there is at least one pay
283 * proposal existing after the actual termination date of this assignment.
284 * @param p_dod_warning If set to true, then the date of death has been set on
285 * terminating the person.
286 * @param p_alu_change_warning Set to Y when at least one assignment link
287 * usage is affected by the termination. Otherwise, set to N.
288 * @rep:displayname Actual Employee Termination
289 * @rep:category BUSINESS_ENTITY PER_EMPLOYEE
290 * @rep:category MISC_EXTENSIONS HR_DATAPUMP
291 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
292 * @rep:scope public
293 * @rep:lifecycle active
294 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
295 */
296 --
297 -- {End Of Comments}
298 --
299 procedure actual_termination_emp
300 (p_validate in boolean default false
301 ,p_effective_date in date
302 ,p_period_of_service_id in number
303 ,p_object_version_number in out nocopy number
304 ,p_actual_termination_date in date
305 ,p_last_standard_process_date in out nocopy date
306 ,p_person_type_id in number default hr_api.g_number
307 ,p_assignment_status_type_id in number default hr_api.g_number
308 ,p_leaving_reason in varchar2 default hr_api.g_varchar2
309 --
310 -- 120.4 (START)
311 --
312 ,p_atd_new in number default hr_api.g_true_num
313 ,p_lspd_new in number default hr_api.g_true_num
314 --
315 -- 120.4 (END)
316 --
317 ,p_supervisor_warning out nocopy boolean
318 ,p_event_warning out nocopy boolean
319 ,p_interview_warning out nocopy boolean
320 ,p_review_warning out nocopy boolean
321 ,p_recruiter_warning out nocopy boolean
322 ,p_asg_future_changes_warning out nocopy boolean
323 ,p_entries_changed_warning out nocopy varchar2
324 ,p_pay_proposal_warning out nocopy boolean
325 ,p_dod_warning out nocopy boolean
326 --
327 -- 120.4 (START)
328 --
329 ,p_alu_change_warning out nocopy varchar2
330 --
331 -- 120.4 (END)
332 --
333 );
334 --
338 --
335 -- ----------------------------------------------------------------------------
336 -- |----------------------------< final_process_emp >-------------------------|
337 -- ----------------------------------------------------------------------------
339 -- {Start Of Comments}
340 /*#
341 * This API set the final process date for a terminated employee.
342 *
343 * This API covers the second step in terminating a period of service and all
344 * current assignments for an employee. It updates the period of service
345 * details and date-effectively deletes all employee assignments as of the
346 * final process date. If a final process date is not specified for the U.S.
347 * legislation, this API uses the actual termination date. For other
348 * legislations, it uses the last standard process date. <P> If you want to
349 * change the final process date after it has been entered, you must cancel the
350 * termination and reapply the termination from the new date. <P>Element
351 * entries for any assignment that have an element termination rule of Final
352 * Close are date-effectively deleted from the final process date. Cost
353 * allocations, grade step/point placements, COBRA coverage benefits, and
354 * personal payment methods for all assignments are date-effectively deleted
355 * from the final process date.
356 *
357 * <p><b>Licensing</b><br>
358 * This API is licensed for use with Human Resources.
359 *
360 * <p><b>Prerequisites</b><br>
361 * The ex-employee must exist in the relevant business group.
362 *
363 * <p><b>Post Success</b><br>
364 * The ex-employee is updated with the relevant final process date. The
365 * ex-employee's assignments and other related records are deleted as of the
366 * effective date.
367 *
368 * <p><b>Post Failure</b><br>
369 * The API does not update the period of service, assignments, or element
370 * entries and raises an error.
371 * @param p_validate If true, then validation alone will be performed and the
372 * database will remain unchanged. If false and all validation checks pass,
373 * then the database will be modified.
374 * @param p_period_of_service_id Period of service that is being terminated.
375 * @param p_object_version_number Pass in the current version number of the
376 * period of service to be updated. When the API completes if p_validate is
377 * false, will be set to the new version number of the updated period of
378 * service. If p_validate is true will be set to the same value which was
379 * passed in.
380 * @param p_final_process_date Final Process Date. If p_validate is false, then
381 * set to the final process date on the updated period of service row. If
382 * p_validate is true, then set to the value passed in.
383 * @param p_org_now_no_manager_warning If set to true, from the final process
384 * date of this assignment there are no other managers in the assignment's
385 * organization.
386 * @param p_asg_future_changes_warning If set to true, then at least one
387 * assignment change, after the actual termination date, has been overwritten
388 * with the new assignment status.
389 * @param p_entries_changed_warning Set to Y when at least one element entry is
390 * affected by the assignment change. Set to S if at least one salary element
391 * entry is affected. (This is a more specific case than Y.) Otherwise, set to
392 * N when no element entries are affected.
393 * @rep:displayname Final Process Employee
394 * @rep:category BUSINESS_ENTITY PER_EMPLOYEE
395 * @rep:category MISC_EXTENSIONS HR_DATAPUMP
396 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
397 * @rep:scope public
398 * @rep:lifecycle active
399 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
400 */
401 --
402 -- {End Of Comments}
403 --
404 procedure final_process_emp
405 (p_validate in boolean default false
406 ,p_period_of_service_id in number
407 ,p_object_version_number in out nocopy number
408 ,p_final_process_date in out nocopy date
409 ,p_org_now_no_manager_warning out nocopy boolean
410 ,p_asg_future_changes_warning out nocopy boolean
411 ,p_entries_changed_warning out nocopy varchar2
412 );
413 --
414 -- ----------------------------------------------------------------------------
415 -- |-------------------------< update_term_details_emp >----------------------|
416 -- ----------------------------------------------------------------------------
417 --
418 -- {Start Of Comments}
419 /*#
420 * This API updates employee termination information.
421 *
422 *
423 * <p><b>Licensing</b><br>
424 * This API is licensed for use with Human Resources.
425 *
426 * <p><b>Prerequisites</b><br>
427 * The ex-employee must exist in the relevant business group.
428 *
429 * <p><b>Post Success</b><br>
430 * The ex-employee record is updated successfully.
431 *
432 * <p><b>Post Failure</b><br>
433 * The API does not update the period of service record and raises an error.
434 * @param p_validate If true, then validation alone will be performed and the
435 * database will remain unchanged. If false and all validation checks pass,
436 * then the database will be modified.
437 * @param p_effective_date Determines when the DateTrack operation comes into
438 * force.
439 * @param p_period_of_service_id Period of service that is being terminated.
440 * @param p_object_version_number Pass in the current version number of the
441 * period of service to be updated. When the API completes if p_validate is
442 * false, will be set to the new version number of the updated period of
443 * service. If p_validate is true will be set to the same value which was
444 * passed in.
445 * @param p_termination_accepted_person Person who accepted this termination.
446 * @param p_accepted_termination_date Date when the termination of employment
447 * was accepted
448 * @param p_comments Comment text.
449 * @param p_leaving_reason Termination Reason. Valid values are defined by the
450 * LEAV_REAS lookup type.
454 * @rep:displayname Update Employee Termination Details
451 * @param p_notified_termination_date Date on which the termination was
452 * notified.
453 * @param p_projected_termination_date Projected termination date.
455 * @rep:category BUSINESS_ENTITY PER_EX-EMPLOYEE
456 * @rep:category MISC_EXTENSIONS HR_DATAPUMP
457 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
458 * @rep:scope public
459 * @rep:lifecycle active
460 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
461 */
462 --
463 -- {End Of Comments}
464 --
465 procedure update_term_details_emp
466 (p_validate in boolean default false
467 ,p_effective_date in date
468 ,p_period_of_service_id in number
469 ,p_object_version_number in out nocopy number
470 ,p_termination_accepted_person in number default hr_api.g_number
471 ,p_accepted_termination_date in date default hr_api.g_date
472 ,p_comments in varchar2 default hr_api.g_varchar2
473 ,p_leaving_reason in varchar2 default hr_api.g_varchar2
474 ,p_notified_termination_date in date default hr_api.g_date
475 ,p_projected_termination_date in date default hr_api.g_date
476 );
477 --
478 -- ----------------------------------------------------------------------------
479 -- |-----------------------< check_for_compl_actions >-------------------------|
480 -- ----------------------------------------------------------------------------
481 --
482 -- {Start Of Comments}
483 --
484 -- Description:
485 -- This is a private function for checking payroll actions as part
486 -- of validation of the termination
487 --
488 -- Prerequisites:
489 -- The employee must exist in the database.
490 --
491 -- In Parameters:
492 -- Name Reqd Type Description
493 -- p_person_id Yes Number person_id
494 -- p_act_date Yes date actual termination date
495 -- p_lsp_date Yes date last standard process date
496 -- p_fpr_date Yes date final process date
497 --
498 -- Post Success:
499 -- The function will return a VARCHAR2 to indicate level of success.
500 --
501 -- Access Status:
502 -- Internal development use only
503 --
504 -- {End Of Comments}
505 FUNCTION check_for_compl_actions(p_person_id NUMBER
506 ,p_act_date DATE
507 ,p_lsp_date DATE
508 ,p_fpr_date DATE) RETURN VARCHAR2;
509 --
510 --
511 -- ----------------------------------------------------------------------------
512 -- |-----------------------< reverse_terminate_employee >-------------------------|
513 -- ----------------------------------------------------------------------------
514 --
515 -- {Start Of Comments}
516 --
517 -- Description:
518 -- This API is not published, hence not meant for public calls.
519 --
520 -- Prerequisites:
521 -- The employee must exist in the database.
522 --
523 -- In Parameters:
524 -- Name Reqd Type Description
525 -- p_validate No boolean If true, then validation alone will
526 -- be performed and the database will
527 -- remain unchanged. If false and all
528 -- validation checks pass, then the
529 -- database will be modified.
530 -- p_person_id Yes Number person_id
531 -- p_actual_termination_date Yes date Actual termination date
532 -- p_clear_details Yes varchar2
533 --
534 -- Post Success:
535 -- The procedure will raise a Business Event when an employee's termination
536 -- is cancelled.
537 --
538 -- Access Status:
539 -- Internal development use only
540 --
541 -- {End Of Comments}
542
543 procedure reverse_terminate_employee
544 (p_validate in boolean default false
545 ,p_person_id in number
546 ,p_actual_termination_date in date
547 ,p_clear_details in varchar2
548 );
549
550 end hr_ex_employee_api;