1 PACKAGE hr_mx_employee_applicant_api AUTHID CURRENT_USER AS
2 /* $Header: pemxwrea.pkh 120.1 2005/10/02 02:42:56 aroussel $ */
3 /*#
4 * This package contains employee applicant APIs for Mexico.
5 * @rep:scope public
6 * @rep:product PER
7 * @rep:displayname Employee Applicant for Mexico
8 */
9 --
10 -- ----------------------------------------------------------------------------
11 -- |----------------------< mx_hire_to_employee_applicant >-------------------|
12 -- ----------------------------------------------------------------------------
13 --
14 -- {Start Of Comments}
15 /*#
16 * This API converts an applicant to an employee for Mexico but lets the
17 * employee retain any remaining applicant assignments.
18 *
19 *
20 * <p><b>Licensing</b><br>
21 * This API is licensed for use with Human Resources.
22 *
23 * <p><b>Prerequisites</b><br>
24 * Employee Applicant ( Internal Applicant ) must exist in the relevant
25 * business group and must have an applicant assignment with assignment status
26 * of 'Accepted'. If person_type_id is supplied, it must have a corresponding
27 * system person type of 'EMP', must be active and be in the same business
28 * group as that of the applicant being changed to employee.
29 *
30 * <p><b>Post Success</b><br>
31 * Applicant has been successfully hired as an employee.
32 *
33 * <p><b>Post Failure</b><br>
34 * The API does not update the person, application, assignments, or period of
35 * service and raises an error.
36 *
37 * @param p_validate If true, then validation alone will be performed and the
38 * database will remain unchanged. If false and all validation checks pass,
39 * then the database will be modified.
40 * @param p_hire_date Hire Date.
41 * @param p_person_id Identifies the person record to modify.
42 * @param p_per_object_version_number Pass in the current version number of the
43 * person to be updated. When the API completes if p_validate is false, will be
44 * set to the new version number of the updated person. If p_validate is true
45 * will be set to the same value which was passed in.
46 * @param p_person_type_id Type of employee being created.
47 * @param p_hire_all_accepted_asgs Flag indicating whether to convert all
48 * accepted applicant assignments to employee assignments.
49 * @param p_assignment_id Identifies the assignment record to be modified.
50 * @param p_curp_id Mexican National Identifier.
51 * @param p_employee_number The business group's employee number generation
52 * method determines when the API derives and passes out an employee number or
53 * when the calling program should pass in a value. When the API call completes
54 * if p_validate is false then will be set to the employee number. If
55 * p_validate is true then will be set to the passed value.
56 * @param p_per_effective_start_date If p_validate is false, then set to the
57 * effective start date on the updated person row which now exists as of the
58 * effective date. If p_validate is true, then set to null.
59 * @param p_per_effective_end_date If p_validate is false, then set to the
60 * effective end date on the updated person row which now exists as of the
61 * effective date. If p_validate is true, then set to null.
62 * @param p_assign_payroll_warning If set to true, then the date of birth is
63 * not entered. If set to false, then the date of birth has been entered.
64 * Indicates if it will be possible to set the payroll on any of this person's
65 * assignments.
66 * @param p_oversubscribed_vacancy_id Vacancy that was oversubscribed when the
67 * applicant was hired.
68 * @rep:displayname Hire To Employee Applicant for Mexico
69 * @rep:category BUSINESS_ENTITY PER_EMPLOYEE
70 * @rep:category BUSINESS_ENTITY PER_APPLICANT
71 * @rep:lifecycle active
72 * @rep:scope public
73 */
74 --
75 -- {End Of Comments}
76 --
77 PROCEDURE mx_hire_to_employee_applicant
78 (p_validate IN BOOLEAN DEFAULT FALSE
79 ,p_hire_date IN DATE
80 ,p_person_id IN per_all_people_f.person_id%TYPE
81 ,p_per_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
82 ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT NULL
83 ,p_hire_all_accepted_asgs IN VARCHAR2
84 ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL
85 ,p_CURP_id IN per_all_people_f.national_identifier%TYPE DEFAULT hr_api.g_varchar2
86 ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
87 ,p_per_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
88 ,p_per_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
89 ,p_assign_payroll_warning OUT NOCOPY BOOLEAN
90 ,p_oversubscribed_vacancy_id OUT NOCOPY NUMBER
91 );
92
93 END hr_mx_employee_applicant_api ;