1 PACKAGE hr_mx_ex_employee_api AS
2 /* $Header: pemxwrxe.pkh 120.1 2005/10/02 02:43:23 aroussel $ */
3 /*#
4 * This package contains Ex-Employee APIs for Mexico.
5 * @rep:scope public
6 * @rep:product PER
7 * @rep:displayname Ex-Employee for Mexico
8 */
9 --
10 -- ----------------------------------------------------------------------------
11 -- |---------------------------< mx_final_process_emp >-----------------------|
12 -- ----------------------------------------------------------------------------
13 --
14 -- {Start Of Comments}
15 /*#
16 * This API sets the final process date for a terminated employee.
17 *
18 * This API covers the second step in terminating a period of service and all
19 * current assignments for an employee. It updates the period of service
20 * details and date-effectively deletes all employee assignments as of the
21 * final process date. If a final process date is not specified for the U.S.
22 * legislation, this API uses the actual termination date. For other
23 * legislations, it uses the last standard process date. If you want to change
24 * the final process date after it has been entered, you must cancel the
25 * termination and reapply the termination from the new date. Element entries
26 * for any assignment that have an element termination rule of Final Close are
27 * date-effectively deleted from the final process date. Cost allocations,
28 * grade step/point placements, COBRA coverage benefits, and personal payment
29 * methods for all assignments are date-effectively deleted from the final
30 * process date.
31 *
32 * <p><b>Licensing</b><br>
33 * This API is licensed for use with Human Resources.
34 *
35 * <p><b>Prerequisites</b><br>
36 * The ex-employee must exist in the relevant business group.
37 *
38 * <p><b>Post Success</b><br>
39 * The ex-employee is updated with the relevant final process date. The
40 * ex-employee's assignments and other related records are deleted as of the
41 * effective date.
42 *
43 * <p><b>Post Failure</b><br>
44 * The API does not update the period of service, assignments, or element
45 * entries and raises an error.
46 *
47 * @param p_validate If true, then validation alone will be performed and the
48 * database will remain unchanged. If false and all validation checks pass,
49 * then the database will be modified.
50 * @param p_period_of_service_id Period of service that is being terminated.
51 * @param p_ss_leaving_reason Social Security Leaving Reason for the employee's
52 * termination.
53 * @param p_object_version_number Pass in the current version number of the
54 * period of service to be updated. When the API completes if p_validate is
55 * false, will be set to the new version number of the updated period of
56 * service. If p_validate is true will be set to the same value which was
57 * passed in.
58 * @param p_final_process_date Final Process Date. If p_validate is false, then
59 * set to the final process date on the updated period of service row. If
60 * p_validate is true, then set to the value passed in.
61 * @param p_org_now_no_manager_warning If set to true, from the final process
62 * date of this assignment there are no other managers in the assignment's
63 * organization.
64 * @param p_asg_future_changes_warning If set to true, then at least one
65 * assignment change, after the actual termination date, has been overwritten
66 * with the new assignment status.
67 * @param p_entries_changed_warning Set to Y when at least one element entry is
68 * affected by the assignment change. Set to S if at least one salary element
69 * entry is affected. (This is a more specific case than Y.) Otherwise, set to
70 * N when no element entries are affected.
71 * @rep:displayname Final Process Employee for Mexico
72 * @rep:category BUSINESS_ENTITY PER_EX-EMPLOYEE
73 * @rep:lifecycle active
74 * @rep:category MISC_EXTENSIONS HR_DATAPUMP
75 * @rep:scope public
76 */
77 --
78 -- {End Of Comments}
79 --
80 PROCEDURE mx_final_process_emp
81 (p_validate IN BOOLEAN DEFAULT FALSE
82 ,p_period_of_service_id IN NUMBER
83 ,p_ss_leaving_reason IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
84 ,p_object_version_number IN OUT NOCOPY NUMBER
85 ,p_final_process_date IN OUT NOCOPY DATE
86 ,p_org_now_no_manager_warning OUT NOCOPY BOOLEAN
87 ,p_asg_future_changes_warning OUT NOCOPY BOOLEAN
88 ,p_entries_changed_warning OUT NOCOPY VARCHAR2
89 );
90 --
91 END hr_mx_ex_employee_api ;