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 133: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL

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

Line 248: id per_all_assignments_f.assignment_id%TYPE,

244: -- #2264569: PL/SQL table to be used when hiring Applicants
245: -- Process Flag ==> (C)onvert, (R)etain, (E)nd Date (it can be null)
246: --
247: type rec_appl is record (
248: id per_all_assignments_f.assignment_id%TYPE,
249: process_flag varchar2(2)
250: );
251: type t_ApplTable is table of rec_appl index by binary_integer;
252:

Line 259: ,p_id per_all_assignments_f.assignment_id%TYPE)

255: --
256: -- routines to handle elements in table
257: --
258: function locate_element(p_table t_ApplTable
259: ,p_id per_all_assignments_f.assignment_id%TYPE)
260: return binary_integer;
261: --
262: --
263: function locate_value(p_table t_ApplTable

Line 269: ,p_id per_all_assignments_f.assignment_id%TYPE)

265: return binary_integer;
266: --
267: --
268: function end_date_exists(p_table t_ApplTable
269: ,p_id per_all_assignments_f.assignment_id%TYPE)
270: return integer;
271: --
272: --
273: function is_convert(p_table t_ApplTable

Line 274: ,p_id per_all_assignments_f.assignment_id%TYPE)

270: return integer;
271: --
272: --
273: function is_convert(p_table t_ApplTable
274: ,p_id per_all_assignments_f.assignment_id%TYPE)
275: return boolean;
276: --
277: --
278: function retain_exists(p_table t_ApplTable) return boolean;