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 129: ,p_person_id IN per_all_people_f.person_id%TYPE

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

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

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

Line 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

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

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

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

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

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

Line 154: p_person_id in per_all_people_f.person_id%TYPE,

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,

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

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,

Line 231: p_person_id in per_all_people_f.person_id%TYPE,

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,

Line 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