DBA Data[Home] [Help]

APPS.HR_MX_EMPLOYEE_APPLICANT_API dependencies on PER_ALL_PEOPLE_F

Line 13: ,p_person_id IN per_all_people_f.person_id%TYPE

9: --
10: PROCEDURE mx_hire_to_employee_applicant
11: (p_validate IN BOOLEAN DEFAULT FALSE
12: ,p_hire_date IN DATE
13: ,p_person_id IN per_all_people_f.person_id%TYPE
14: ,p_per_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
15: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT NULL
16: ,p_hire_all_accepted_asgs IN VARCHAR2
17: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL

Line 14: ,p_per_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE

10: PROCEDURE mx_hire_to_employee_applicant
11: (p_validate IN BOOLEAN DEFAULT FALSE
12: ,p_hire_date IN DATE
13: ,p_person_id IN per_all_people_f.person_id%TYPE
14: ,p_per_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
15: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT NULL
16: ,p_hire_all_accepted_asgs IN VARCHAR2
17: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL
18: ,p_CURP_id IN per_all_people_f.national_identifier%TYPE DEFAULT hr_api.g_varchar2

Line 18: ,p_CURP_id IN per_all_people_f.national_identifier%TYPE DEFAULT hr_api.g_varchar2

14: ,p_per_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
15: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT NULL
16: ,p_hire_all_accepted_asgs IN VARCHAR2
17: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL
18: ,p_CURP_id IN per_all_people_f.national_identifier%TYPE DEFAULT hr_api.g_varchar2
19: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
20: ,p_per_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
21: ,p_per_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
22: ,p_assign_payroll_warning OUT NOCOPY BOOLEAN

Line 19: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE

15: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT NULL
16: ,p_hire_all_accepted_asgs IN VARCHAR2
17: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL
18: ,p_CURP_id IN per_all_people_f.national_identifier%TYPE DEFAULT hr_api.g_varchar2
19: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
20: ,p_per_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
21: ,p_per_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
22: ,p_assign_payroll_warning OUT NOCOPY BOOLEAN
23: ,p_oversubscribed_vacancy_id OUT NOCOPY NUMBER

Line 20: ,p_per_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE

16: ,p_hire_all_accepted_asgs IN VARCHAR2
17: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL
18: ,p_CURP_id IN per_all_people_f.national_identifier%TYPE DEFAULT hr_api.g_varchar2
19: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
20: ,p_per_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
21: ,p_per_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
22: ,p_assign_payroll_warning OUT NOCOPY BOOLEAN
23: ,p_oversubscribed_vacancy_id OUT NOCOPY NUMBER
24: )

Line 21: ,p_per_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE

17: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL
18: ,p_CURP_id IN per_all_people_f.national_identifier%TYPE DEFAULT hr_api.g_varchar2
19: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
20: ,p_per_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
21: ,p_per_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
22: ,p_assign_payroll_warning OUT NOCOPY BOOLEAN
23: ,p_oversubscribed_vacancy_id OUT NOCOPY NUMBER
24: )
25: is

Line 28: l_business_group_id per_all_people_f.business_group_id%TYPE;

24: )
25: is
26: -- Declare cursors and local variables
27: l_proc VARCHAR2(72);
28: l_business_group_id per_all_people_f.business_group_id%TYPE;
29:
30: --
31: BEGIN
32: