DBA Data[Home] [Help]
Skip to content

PACKAGE: APPS.HR_MX_EMPLOYEE_APPLICANT_API

Source


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 ;