eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_EMPLOYEE_APPLICANT_API dependencies on PER_ALL_ASSIGNMENTS_F

Line 25: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL

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
28: ,p_per_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
29: ,p_assign_payroll_warning OUT NOCOPY BOOLEAN

Line 47: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL

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
50: ,p_per_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
51: ,p_assign_payroll_warning OUT NOCOPY BOOLEAN

Line 72: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL

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

Line 163: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL

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

Line 317: p_asg_rec in out nocopy per_all_assignments_f%rowtype,

313: --
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',

Line 336: id per_all_assignments_f.assignment_id%TYPE,

332: -- #2264569: PL/SQL table to be used when hiring Applicants
333: -- Process Flag ==> (C)onvert, (R)etain, (E)nd Date (it can be null)
334: --
335: type rec_appl is record (
336: id per_all_assignments_f.assignment_id%TYPE,
337: process_flag varchar2(2)
338: );
339: type t_ApplTable is table of rec_appl index by binary_integer;
340:

Line 347: ,p_id per_all_assignments_f.assignment_id%TYPE)

343: --
344: -- routines to handle elements in table
345: --
346: function locate_element(p_table t_ApplTable
347: ,p_id per_all_assignments_f.assignment_id%TYPE)
348: return binary_integer;
349: --
350: --
351: function locate_value(p_table t_ApplTable

Line 357: ,p_id per_all_assignments_f.assignment_id%TYPE)

353: return binary_integer;
354: --
355: --
356: function end_date_exists(p_table t_ApplTable
357: ,p_id per_all_assignments_f.assignment_id%TYPE)
358: return integer;
359: --
360: --
361: function is_convert(p_table t_ApplTable

Line 362: ,p_id per_all_assignments_f.assignment_id%TYPE)

358: return integer;
359: --
360: --
361: function is_convert(p_table t_ApplTable
362: ,p_id per_all_assignments_f.assignment_id%TYPE)
363: return boolean;
364: --
365: --
366: function retain_exists(p_table t_ApplTable) return boolean;