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_API dependencies on PER_ALL_PEOPLE_F

Line 12: (p_person_id IN per_all_people_f.person_id%TYPE

8: --
9: -- Package cursors
10: --
11: CURSOR csr_future_asgs
12: (p_person_id IN per_all_people_f.person_id%TYPE
13: ,p_effective_date IN DATE
14: )
15: IS
16: SELECT asg.assignment_id

Line 60: (p_person_id IN per_all_people_f.person_id%TYPE

56: --
57: -- {End Of Comments}
58: --
59: FUNCTION future_asgs_count
60: (p_person_id IN per_all_people_f.person_id%TYPE
61: ,p_effective_date IN DATE
62: )
63: RETURN INTEGER
64: IS

Line 766: ,p_parent_table => 'PER_ALL_PEOPLE_F'

762: ,p_date_to => null
763: ,p_phone_type => 'W1'
764: ,p_phone_number => p_work_telephone
765: ,p_parent_id => l_person_id
766: ,p_parent_table => 'PER_ALL_PEOPLE_F'
767: ,p_validate => FALSE
768: ,p_effective_date => l_hire_date
769: ,p_object_version_number => l_phn_object_version_number --out
770: ,p_phone_id => l_phone_id --out

Line 779: FROM per_all_people_f

775: -- Start of fix for bug 3684087
776: --
777: SELECT object_version_number
778: INTO l_per_object_Version_number
779: FROM per_all_people_f
780: WHERE person_id = l_person_id
781: And effective_start_Date = l_per_effective_start_date
782: and effective_end_Date = l_per_effective_end_date;
783: --

Line 3051: (p_person_id IN per_all_people_f.person_id%TYPE

3047: --
3048: -- Cursor to get legislation code
3049: --
3050: CURSOR csr_per_legislation
3051: (p_person_id IN per_all_people_f.person_id%TYPE
3052: ,p_effective_date IN DATE
3053: ) IS
3054: SELECT bus.legislation_code
3055: FROM per_people_f per

Line 4091: l_employee_number CONSTANT per_all_people_f.applicant_number%TYPE := p_employee_number;

4087: l_effective_date DATE;
4088: --
4089: l_object_version_number CONSTANT per_all_assignments_f.object_version_number%TYPE := p_object_version_number;
4090: l_datetrack_update_mode VARCHAR2(30) := p_datetrack_update_mode;
4091: l_employee_number CONSTANT per_all_people_f.applicant_number%TYPE := p_employee_number;
4092: l_emp_num per_all_people_f.applicant_number%TYPE := p_employee_number;
4093: l_ovn per_all_people_f.object_version_number%TYPE := p_object_version_number;
4094: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;
4095: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;

Line 4092: l_emp_num per_all_people_f.applicant_number%TYPE := p_employee_number;

4088: --
4089: l_object_version_number CONSTANT per_all_assignments_f.object_version_number%TYPE := p_object_version_number;
4090: l_datetrack_update_mode VARCHAR2(30) := p_datetrack_update_mode;
4091: l_employee_number CONSTANT per_all_people_f.applicant_number%TYPE := p_employee_number;
4092: l_emp_num per_all_people_f.applicant_number%TYPE := p_employee_number;
4093: l_ovn per_all_people_f.object_version_number%TYPE := p_object_version_number;
4094: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;
4095: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;
4096: l_assign_payroll_warning BOOLEAN;

Line 4093: l_ovn per_all_people_f.object_version_number%TYPE := p_object_version_number;

4089: l_object_version_number CONSTANT per_all_assignments_f.object_version_number%TYPE := p_object_version_number;
4090: l_datetrack_update_mode VARCHAR2(30) := p_datetrack_update_mode;
4091: l_employee_number CONSTANT per_all_people_f.applicant_number%TYPE := p_employee_number;
4092: l_emp_num per_all_people_f.applicant_number%TYPE := p_employee_number;
4093: l_ovn per_all_people_f.object_version_number%TYPE := p_object_version_number;
4094: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;
4095: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;
4096: l_assign_payroll_warning BOOLEAN;
4097: l_orig_hire_warning BOOLEAN;

Line 4094: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;

4090: l_datetrack_update_mode VARCHAR2(30) := p_datetrack_update_mode;
4091: l_employee_number CONSTANT per_all_people_f.applicant_number%TYPE := p_employee_number;
4092: l_emp_num per_all_people_f.applicant_number%TYPE := p_employee_number;
4093: l_ovn per_all_people_f.object_version_number%TYPE := p_object_version_number;
4094: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;
4095: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;
4096: l_assign_payroll_warning BOOLEAN;
4097: l_orig_hire_warning BOOLEAN;
4098: --

Line 4095: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;

4091: l_employee_number CONSTANT per_all_people_f.applicant_number%TYPE := p_employee_number;
4092: l_emp_num per_all_people_f.applicant_number%TYPE := p_employee_number;
4093: l_ovn per_all_people_f.object_version_number%TYPE := p_object_version_number;
4094: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;
4095: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;
4096: l_assign_payroll_warning BOOLEAN;
4097: l_orig_hire_warning BOOLEAN;
4098: --
4099: l_person_type_id per_person_types.person_type_id%TYPE := p_person_type_id;

Line 4107: l_current_applicant_flag per_all_people_f.current_applicant_flag%TYPE;

4103: l_system_person_type per_person_types.system_person_type%TYPE;
4104: l_effective_start_date DATE;
4105: l_effective_end_date DATE;
4106: l_comment_id hr_comments.comment_id%TYPE;
4107: l_current_applicant_flag per_all_people_f.current_applicant_flag%TYPE;
4108: l_current_emp_or_apl_flag per_all_people_f.current_emp_or_apl_flag%TYPE;
4109: l_current_employee_flag per_all_people_f.current_employee_flag%TYPE;
4110: l_full_name per_all_people_f.full_name%TYPE;
4111: l_name_combination_warning BOOLEAN;

Line 4108: l_current_emp_or_apl_flag per_all_people_f.current_emp_or_apl_flag%TYPE;

4104: l_effective_start_date DATE;
4105: l_effective_end_date DATE;
4106: l_comment_id hr_comments.comment_id%TYPE;
4107: l_current_applicant_flag per_all_people_f.current_applicant_flag%TYPE;
4108: l_current_emp_or_apl_flag per_all_people_f.current_emp_or_apl_flag%TYPE;
4109: l_current_employee_flag per_all_people_f.current_employee_flag%TYPE;
4110: l_full_name per_all_people_f.full_name%TYPE;
4111: l_name_combination_warning BOOLEAN;
4112: l_period_of_service_id per_periods_of_service.period_of_service_id%TYPE;

Line 4109: l_current_employee_flag per_all_people_f.current_employee_flag%TYPE;

4105: l_effective_end_date DATE;
4106: l_comment_id hr_comments.comment_id%TYPE;
4107: l_current_applicant_flag per_all_people_f.current_applicant_flag%TYPE;
4108: l_current_emp_or_apl_flag per_all_people_f.current_emp_or_apl_flag%TYPE;
4109: l_current_employee_flag per_all_people_f.current_employee_flag%TYPE;
4110: l_full_name per_all_people_f.full_name%TYPE;
4111: l_name_combination_warning BOOLEAN;
4112: l_period_of_service_id per_periods_of_service.period_of_service_id%TYPE;
4113: l_pds_object_version_number per_periods_of_service.object_version_number%TYPE;

Line 4110: l_full_name per_all_people_f.full_name%TYPE;

4106: l_comment_id hr_comments.comment_id%TYPE;
4107: l_current_applicant_flag per_all_people_f.current_applicant_flag%TYPE;
4108: l_current_emp_or_apl_flag per_all_people_f.current_emp_or_apl_flag%TYPE;
4109: l_current_employee_flag per_all_people_f.current_employee_flag%TYPE;
4110: l_full_name per_all_people_f.full_name%TYPE;
4111: l_name_combination_warning BOOLEAN;
4112: l_period_of_service_id per_periods_of_service.period_of_service_id%TYPE;
4113: l_pds_object_version_number per_periods_of_service.object_version_number%TYPE;
4114: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

Line 4154: (p_person_id IN per_all_people_f.person_id%TYPE

4150: --
4151: -- End of fix for bug 3143299
4152: --
4153: CURSOR csr_per_details
4154: (p_person_id IN per_all_people_f.person_id%TYPE
4155: ,p_effective_date IN DATE
4156: )
4157: IS
4158: SELECT pet.person_type_id

Line 4774: (p_person_id IN per_all_people_f.person_id%TYPE

4770: --
4771: -- Cursor to get primary assignment on specified date
4772: --
4773: CURSOR c_prim_asg
4774: (p_person_id IN per_all_people_f.person_id%TYPE
4775: ,p_effective_date IN DATE
4776: ) IS
4777: SELECT assignment_id
4778: ,effective_start_date