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