18: --
19: PROCEDURE hire_to_employee_applicant
20: (p_validate IN BOOLEAN DEFAULT FALSE
21: ,p_hire_date IN DATE
22: ,p_person_id IN per_all_people_f.person_id%TYPE
23: ,p_per_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
24: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT NULL
25: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL
26: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
19: PROCEDURE hire_to_employee_applicant
20: (p_validate IN BOOLEAN DEFAULT FALSE
21: ,p_hire_date IN DATE
22: ,p_person_id IN per_all_people_f.person_id%TYPE
23: ,p_per_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
24: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT NULL
25: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL
26: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
27: ,p_per_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
22: ,p_person_id IN per_all_people_f.person_id%TYPE
23: ,p_per_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
24: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT NULL
25: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL
26: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
27: ,p_per_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
28: ,p_per_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
29: ,p_assign_payroll_warning OUT NOCOPY BOOLEAN
30: );
23: ,p_per_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
24: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT NULL
25: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL
26: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
27: ,p_per_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
28: ,p_per_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
29: ,p_assign_payroll_warning OUT NOCOPY BOOLEAN
30: );
31: --
24: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT NULL
25: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL
26: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
27: ,p_per_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
28: ,p_per_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
29: ,p_assign_payroll_warning OUT NOCOPY BOOLEAN
30: );
31: --
32: -- ----------------------------------------------------------------------------
40: --
41: PROCEDURE hire_to_employee_applicant
42: (p_validate IN BOOLEAN DEFAULT FALSE
43: ,p_hire_date IN DATE
44: ,p_person_id IN per_all_people_f.person_id%TYPE
45: ,p_per_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
46: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT NULL
47: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL
48: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
41: PROCEDURE hire_to_employee_applicant
42: (p_validate IN BOOLEAN DEFAULT FALSE
43: ,p_hire_date IN DATE
44: ,p_person_id IN per_all_people_f.person_id%TYPE
45: ,p_per_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
46: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT NULL
47: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL
48: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
49: ,p_per_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
44: ,p_person_id IN per_all_people_f.person_id%TYPE
45: ,p_per_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
46: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT NULL
47: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL
48: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
49: ,p_per_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
50: ,p_per_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
51: ,p_assign_payroll_warning OUT NOCOPY BOOLEAN
52: ,p_oversubscribed_vacancy_id out nocopy number
45: ,p_per_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
46: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT NULL
47: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL
48: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
49: ,p_per_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
50: ,p_per_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
51: ,p_assign_payroll_warning OUT NOCOPY BOOLEAN
52: ,p_oversubscribed_vacancy_id out nocopy number
53: );
46: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT NULL
47: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL
48: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
49: ,p_per_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
50: ,p_per_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
51: ,p_assign_payroll_warning OUT NOCOPY BOOLEAN
52: ,p_oversubscribed_vacancy_id out nocopy number
53: );
54: --
125: --
126: PROCEDURE hire_to_employee_applicant
127: (p_validate IN BOOLEAN DEFAULT FALSE
128: ,p_hire_date IN DATE
129: ,p_person_id IN per_all_people_f.person_id%TYPE
130: ,p_per_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
131: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT NULL
132: ,p_hire_all_accepted_asgs IN VARCHAR2
133: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL
126: PROCEDURE hire_to_employee_applicant
127: (p_validate IN BOOLEAN DEFAULT FALSE
128: ,p_hire_date IN DATE
129: ,p_person_id IN per_all_people_f.person_id%TYPE
130: ,p_per_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
131: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT NULL
132: ,p_hire_all_accepted_asgs IN VARCHAR2
133: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL
134: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE DEFAULT hr_api.g_varchar2
130: ,p_per_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
131: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT NULL
132: ,p_hire_all_accepted_asgs IN VARCHAR2
133: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL
134: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE DEFAULT hr_api.g_varchar2
135: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
136: ,p_per_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
137: ,p_per_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
138: ,p_assign_payroll_warning OUT NOCOPY BOOLEAN
131: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT NULL
132: ,p_hire_all_accepted_asgs IN VARCHAR2
133: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL
134: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE DEFAULT hr_api.g_varchar2
135: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
136: ,p_per_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
137: ,p_per_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
138: ,p_assign_payroll_warning OUT NOCOPY BOOLEAN
139: ,p_oversubscribed_vacancy_id out nocopy number
132: ,p_hire_all_accepted_asgs IN VARCHAR2
133: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL
134: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE DEFAULT hr_api.g_varchar2
135: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
136: ,p_per_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
137: ,p_per_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
138: ,p_assign_payroll_warning OUT NOCOPY BOOLEAN
139: ,p_oversubscribed_vacancy_id out nocopy number
140: );
133: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL
134: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE DEFAULT hr_api.g_varchar2
135: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
136: ,p_per_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
137: ,p_per_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
138: ,p_assign_payroll_warning OUT NOCOPY BOOLEAN
139: ,p_oversubscribed_vacancy_id out nocopy number
140: );
141: --
150: --
151: procedure hire_employee_applicant
152: (p_validate in boolean default false,
153: p_hire_date in date,
154: p_person_id in per_all_people_f.person_id%TYPE,
155: p_per_object_version_number in out nocopy per_all_people_f.object_version_number%TYPE,
156: p_person_type_id in number default null,
157: p_assignment_id in number default null,
158: p_per_effective_start_date out nocopy date,
151: procedure hire_employee_applicant
152: (p_validate in boolean default false,
153: p_hire_date in date,
154: p_person_id in per_all_people_f.person_id%TYPE,
155: p_per_object_version_number in out nocopy per_all_people_f.object_version_number%TYPE,
156: p_person_type_id in number default null,
157: p_assignment_id in number default null,
158: p_per_effective_start_date out nocopy date,
159: p_per_effective_end_date out nocopy date,
227: --
228: procedure hire_employee_applicant
229: (p_validate in boolean default false,
230: p_hire_date in date,
231: p_person_id in per_all_people_f.person_id%TYPE,
232: p_primary_assignment_id in number default null,
233: p_person_type_id in number default null,
234: p_overwrite_primary in varchar2 default 'N',
235: p_per_object_version_number in out nocopy per_all_people_f.object_version_number%TYPE,
231: p_person_id in per_all_people_f.person_id%TYPE,
232: p_primary_assignment_id in number default null,
233: p_person_type_id in number default null,
234: p_overwrite_primary in varchar2 default 'N',
235: p_per_object_version_number in out nocopy per_all_people_f.object_version_number%TYPE,
236: p_per_effective_start_date out nocopy date,
237: p_per_effective_end_date out nocopy date,
238: p_unaccepted_asg_del_warning out nocopy boolean,
239: p_assign_payroll_warning out nocopy boolean