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:
64: --
65: PROCEDURE hire_to_employee_applicant
66: (p_validate IN BOOLEAN DEFAULT FALSE
67: ,p_hire_date IN DATE
68: ,p_person_id IN per_all_people_f.person_id%TYPE
69: ,p_per_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
70: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT NULL
71: ,p_hire_all_accepted_asgs IN VARCHAR2
72: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL
65: PROCEDURE hire_to_employee_applicant
66: (p_validate IN BOOLEAN DEFAULT FALSE
67: ,p_hire_date IN DATE
68: ,p_person_id IN per_all_people_f.person_id%TYPE
69: ,p_per_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
70: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT NULL
71: ,p_hire_all_accepted_asgs IN VARCHAR2
72: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL
73: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE DEFAULT hr_api.g_varchar2
69: ,p_per_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
70: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT NULL
71: ,p_hire_all_accepted_asgs IN VARCHAR2
72: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL
73: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE DEFAULT hr_api.g_varchar2
74: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
75: ,p_per_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
76: ,p_per_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
77: ,p_assign_payroll_warning OUT NOCOPY BOOLEAN
70: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT NULL
71: ,p_hire_all_accepted_asgs IN VARCHAR2
72: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL
73: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE DEFAULT hr_api.g_varchar2
74: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
75: ,p_per_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
76: ,p_per_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
77: ,p_assign_payroll_warning OUT NOCOPY BOOLEAN
78: ,p_oversubscribed_vacancy_id out nocopy number
71: ,p_hire_all_accepted_asgs IN VARCHAR2
72: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL
73: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE DEFAULT hr_api.g_varchar2
74: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
75: ,p_per_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
76: ,p_per_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
77: ,p_assign_payroll_warning OUT NOCOPY BOOLEAN
78: ,p_oversubscribed_vacancy_id out nocopy number
79: );
72: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL
73: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE DEFAULT hr_api.g_varchar2
74: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
75: ,p_per_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
76: ,p_per_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
77: ,p_assign_payroll_warning OUT NOCOPY BOOLEAN
78: ,p_oversubscribed_vacancy_id out nocopy number
79: );
80: -- End changes for bug 9879782
155: --
156: PROCEDURE hire_to_employee_applicant
157: (p_validate IN BOOLEAN DEFAULT FALSE
158: ,p_hire_date IN DATE
159: ,p_person_id IN per_all_people_f.person_id%TYPE
160: ,p_per_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
161: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT NULL
162: ,p_hire_all_accepted_asgs IN VARCHAR2
163: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL
156: PROCEDURE hire_to_employee_applicant
157: (p_validate IN BOOLEAN DEFAULT FALSE
158: ,p_hire_date IN DATE
159: ,p_person_id IN per_all_people_f.person_id%TYPE
160: ,p_per_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
161: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT NULL
162: ,p_hire_all_accepted_asgs IN VARCHAR2
163: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL
164: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE DEFAULT hr_api.g_varchar2
160: ,p_per_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
161: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT NULL
162: ,p_hire_all_accepted_asgs IN VARCHAR2
163: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL
164: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE DEFAULT hr_api.g_varchar2
165: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
166: ,p_per_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
167: ,p_per_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
168: ,p_assign_payroll_warning OUT NOCOPY BOOLEAN
161: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT NULL
162: ,p_hire_all_accepted_asgs IN VARCHAR2
163: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL
164: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE DEFAULT hr_api.g_varchar2
165: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
166: ,p_per_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
167: ,p_per_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
168: ,p_assign_payroll_warning OUT NOCOPY BOOLEAN
169: ,p_oversubscribed_vacancy_id out nocopy number
162: ,p_hire_all_accepted_asgs IN VARCHAR2
163: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL
164: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE DEFAULT hr_api.g_varchar2
165: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
166: ,p_per_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
167: ,p_per_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
168: ,p_assign_payroll_warning OUT NOCOPY BOOLEAN
169: ,p_oversubscribed_vacancy_id out nocopy number
170: ,p_upload_irec_docs IN VARCHAR2 -- Added for bug 9879782
163: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL
164: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE DEFAULT hr_api.g_varchar2
165: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
166: ,p_per_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
167: ,p_per_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
168: ,p_assign_payroll_warning OUT NOCOPY BOOLEAN
169: ,p_oversubscribed_vacancy_id out nocopy number
170: ,p_upload_irec_docs IN VARCHAR2 -- Added for bug 9879782
171: );
181: --
182: procedure hire_employee_applicant
183: (p_validate in boolean default false,
184: p_hire_date in date,
185: p_person_id in per_all_people_f.person_id%TYPE,
186: p_per_object_version_number in out nocopy per_all_people_f.object_version_number%TYPE,
187: p_person_type_id in number default null,
188: p_assignment_id in number default null,
189: p_per_effective_start_date out nocopy date,
182: procedure hire_employee_applicant
183: (p_validate in boolean default false,
184: p_hire_date in date,
185: p_person_id in per_all_people_f.person_id%TYPE,
186: p_per_object_version_number in out nocopy per_all_people_f.object_version_number%TYPE,
187: p_person_type_id in number default null,
188: p_assignment_id in number default null,
189: p_per_effective_start_date out nocopy date,
190: p_per_effective_end_date out nocopy date,
204: --
205: procedure hire_employee_applicant
206: (p_validate in boolean default false,
207: p_hire_date in date,
208: p_person_id in per_all_people_f.person_id%TYPE,
209: p_primary_assignment_id in number default null,
210: p_person_type_id in number default null,
211: p_overwrite_primary in varchar2 default 'N',
212: p_per_object_version_number in out nocopy per_all_people_f.object_version_number%TYPE,
208: p_person_id in per_all_people_f.person_id%TYPE,
209: p_primary_assignment_id in number default null,
210: p_person_type_id in number default null,
211: p_overwrite_primary in varchar2 default 'N',
212: p_per_object_version_number in out nocopy per_all_people_f.object_version_number%TYPE,
213: p_per_effective_start_date out nocopy date,
214: p_per_effective_end_date out nocopy date,
215: p_unaccepted_asg_del_warning out nocopy boolean,
216: p_assign_payroll_warning out nocopy boolean
286: --
287: procedure hire_employee_applicant
288: (p_validate in boolean default false,
289: p_hire_date in date,
290: p_person_id in per_all_people_f.person_id%TYPE,
291: p_primary_assignment_id in number default null,
292: p_person_type_id in number default null,
293: p_overwrite_primary in varchar2 default 'N',
294: p_per_object_version_number in out nocopy per_all_people_f.object_version_number%TYPE,
290: p_person_id in per_all_people_f.person_id%TYPE,
291: p_primary_assignment_id in number default null,
292: p_person_type_id in number default null,
293: p_overwrite_primary in varchar2 default 'N',
294: p_per_object_version_number in out nocopy per_all_people_f.object_version_number%TYPE,
295: p_per_effective_start_date out nocopy date,
296: p_per_effective_end_date out nocopy date,
297: p_unaccepted_asg_del_warning out nocopy boolean,
298: p_assign_payroll_warning out nocopy boolean,
314: procedure hire_employee_applicant
315: (p_validate in boolean default false,
316: p_hire_date in date,
317: p_asg_rec in out nocopy per_all_assignments_f%rowtype,
318: p_person_id in per_all_people_f.person_id%TYPE,
319: p_primary_assignment_id in number default null,
320: p_person_type_id in number default null,
321: p_overwrite_primary in varchar2 default 'N',
322: p_per_object_version_number in out nocopy per_all_people_f.object_version_number%TYPE,
318: p_person_id in per_all_people_f.person_id%TYPE,
319: p_primary_assignment_id in number default null,
320: p_person_type_id in number default null,
321: p_overwrite_primary in varchar2 default 'N',
322: p_per_object_version_number in out nocopy per_all_people_f.object_version_number%TYPE,
323: p_per_effective_start_date out nocopy date,
324: p_per_effective_end_date out nocopy date,
325: p_unaccepted_asg_del_warning out nocopy boolean,
326: p_assign_payroll_warning out nocopy boolean