DBA Data[Home] [Help]

APPS.HR_EMPLOYEE_APPLICANT_API dependencies on PER_ALL_PEOPLE_F

Line 22: ,p_person_id IN per_all_people_f.person_id%TYPE

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

Line 23: ,p_per_object_version_number IN OUT NOCOPY per_all_people_f.object_version_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

Line 26: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%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: );

Line 27: ,p_per_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%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: );
31: --

Line 28: ,p_per_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%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: --
32: -- ----------------------------------------------------------------------------

Line 44: ,p_person_id IN per_all_people_f.person_id%TYPE

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

Line 45: ,p_per_object_version_number IN OUT NOCOPY per_all_people_f.object_version_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

Line 48: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%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

Line 49: ,p_per_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%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
53: );

Line 50: ,p_per_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%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: );
54:

Line 68: ,p_person_id IN per_all_people_f.person_id%TYPE

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

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

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

Line 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

Line 74: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_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
78: ,p_oversubscribed_vacancy_id out nocopy number

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

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: );

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

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

Line 159: ,p_person_id IN per_all_people_f.person_id%TYPE

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

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

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

Line 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

Line 165: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_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
169: ,p_oversubscribed_vacancy_id out nocopy number

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

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

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

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: );

Line 185: p_person_id in per_all_people_f.person_id%TYPE,

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,

Line 186: p_per_object_version_number in out nocopy per_all_people_f.object_version_number%TYPE,

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,

Line 208: p_person_id in per_all_people_f.person_id%TYPE,

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,

Line 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

Line 290: p_person_id in per_all_people_f.person_id%TYPE,

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,

Line 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,

Line 318: p_person_id in per_all_people_f.person_id%TYPE,

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,

Line 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