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

2736: --
2737: -- Cursor to get legislation code
2738: --
2739: CURSOR csr_per_legislation
2740: (p_person_id IN per_all_people_f.person_id%TYPE
2741: ,p_effective_date IN DATE
2742: ) IS
2743: SELECT bus.legislation_code
2744: FROM per_people_f per

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

3775: l_effective_date DATE;
3776: --
3777: l_object_version_number CONSTANT per_all_assignments_f.object_version_number%TYPE := p_object_version_number;
3778: l_datetrack_update_mode VARCHAR2(30) := p_datetrack_update_mode;
3779: l_employee_number CONSTANT per_all_people_f.applicant_number%TYPE := p_employee_number;
3780: l_emp_num per_all_people_f.applicant_number%TYPE := p_employee_number;
3781: l_ovn per_all_people_f.object_version_number%TYPE := p_object_version_number;
3782: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;
3783: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;

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

3776: --
3777: l_object_version_number CONSTANT per_all_assignments_f.object_version_number%TYPE := p_object_version_number;
3778: l_datetrack_update_mode VARCHAR2(30) := p_datetrack_update_mode;
3779: l_employee_number CONSTANT per_all_people_f.applicant_number%TYPE := p_employee_number;
3780: l_emp_num per_all_people_f.applicant_number%TYPE := p_employee_number;
3781: l_ovn per_all_people_f.object_version_number%TYPE := p_object_version_number;
3782: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;
3783: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;
3784: l_assign_payroll_warning BOOLEAN;

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

3777: l_object_version_number CONSTANT per_all_assignments_f.object_version_number%TYPE := p_object_version_number;
3778: l_datetrack_update_mode VARCHAR2(30) := p_datetrack_update_mode;
3779: l_employee_number CONSTANT per_all_people_f.applicant_number%TYPE := p_employee_number;
3780: l_emp_num per_all_people_f.applicant_number%TYPE := p_employee_number;
3781: l_ovn per_all_people_f.object_version_number%TYPE := p_object_version_number;
3782: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;
3783: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;
3784: l_assign_payroll_warning BOOLEAN;
3785: l_orig_hire_warning BOOLEAN;

Line 3782: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;

3778: l_datetrack_update_mode VARCHAR2(30) := p_datetrack_update_mode;
3779: l_employee_number CONSTANT per_all_people_f.applicant_number%TYPE := p_employee_number;
3780: l_emp_num per_all_people_f.applicant_number%TYPE := p_employee_number;
3781: l_ovn per_all_people_f.object_version_number%TYPE := p_object_version_number;
3782: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;
3783: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;
3784: l_assign_payroll_warning BOOLEAN;
3785: l_orig_hire_warning BOOLEAN;
3786: --

Line 3783: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;

3779: l_employee_number CONSTANT per_all_people_f.applicant_number%TYPE := p_employee_number;
3780: l_emp_num per_all_people_f.applicant_number%TYPE := p_employee_number;
3781: l_ovn per_all_people_f.object_version_number%TYPE := p_object_version_number;
3782: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;
3783: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;
3784: l_assign_payroll_warning BOOLEAN;
3785: l_orig_hire_warning BOOLEAN;
3786: --
3787: l_person_type_id per_person_types.person_type_id%TYPE := p_person_type_id;

Line 3795: l_current_applicant_flag per_all_people_f.current_applicant_flag%TYPE;

3791: l_system_person_type per_person_types.system_person_type%TYPE;
3792: l_effective_start_date DATE;
3793: l_effective_end_date DATE;
3794: l_comment_id hr_comments.comment_id%TYPE;
3795: l_current_applicant_flag per_all_people_f.current_applicant_flag%TYPE;
3796: l_current_emp_or_apl_flag per_all_people_f.current_emp_or_apl_flag%TYPE;
3797: l_current_employee_flag per_all_people_f.current_employee_flag%TYPE;
3798: l_full_name per_all_people_f.full_name%TYPE;
3799: l_name_combination_warning BOOLEAN;

Line 3796: l_current_emp_or_apl_flag per_all_people_f.current_emp_or_apl_flag%TYPE;

3792: l_effective_start_date DATE;
3793: l_effective_end_date DATE;
3794: l_comment_id hr_comments.comment_id%TYPE;
3795: l_current_applicant_flag per_all_people_f.current_applicant_flag%TYPE;
3796: l_current_emp_or_apl_flag per_all_people_f.current_emp_or_apl_flag%TYPE;
3797: l_current_employee_flag per_all_people_f.current_employee_flag%TYPE;
3798: l_full_name per_all_people_f.full_name%TYPE;
3799: l_name_combination_warning BOOLEAN;
3800: l_period_of_service_id per_periods_of_service.period_of_service_id%TYPE;

Line 3797: l_current_employee_flag per_all_people_f.current_employee_flag%TYPE;

3793: l_effective_end_date DATE;
3794: l_comment_id hr_comments.comment_id%TYPE;
3795: l_current_applicant_flag per_all_people_f.current_applicant_flag%TYPE;
3796: l_current_emp_or_apl_flag per_all_people_f.current_emp_or_apl_flag%TYPE;
3797: l_current_employee_flag per_all_people_f.current_employee_flag%TYPE;
3798: l_full_name per_all_people_f.full_name%TYPE;
3799: l_name_combination_warning BOOLEAN;
3800: l_period_of_service_id per_periods_of_service.period_of_service_id%TYPE;
3801: l_pds_object_version_number per_periods_of_service.object_version_number%TYPE;

Line 3798: l_full_name per_all_people_f.full_name%TYPE;

3794: l_comment_id hr_comments.comment_id%TYPE;
3795: l_current_applicant_flag per_all_people_f.current_applicant_flag%TYPE;
3796: l_current_emp_or_apl_flag per_all_people_f.current_emp_or_apl_flag%TYPE;
3797: l_current_employee_flag per_all_people_f.current_employee_flag%TYPE;
3798: l_full_name per_all_people_f.full_name%TYPE;
3799: l_name_combination_warning BOOLEAN;
3800: l_period_of_service_id per_periods_of_service.period_of_service_id%TYPE;
3801: l_pds_object_version_number per_periods_of_service.object_version_number%TYPE;
3802: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

Line 3842: (p_person_id IN per_all_people_f.person_id%TYPE

3838: --
3839: -- End of fix for bug 3143299
3840: --
3841: CURSOR csr_per_details
3842: (p_person_id IN per_all_people_f.person_id%TYPE
3843: ,p_effective_date IN DATE
3844: )
3845: IS
3846: SELECT pet.person_type_id

Line 4428: (p_person_id IN per_all_people_f.person_id%TYPE

4424: --
4425: -- Cursor to get primary assignment on specified date
4426: --
4427: CURSOR c_prim_asg
4428: (p_person_id IN per_all_people_f.person_id%TYPE
4429: ,p_effective_date IN DATE
4430: ) IS
4431: SELECT assignment_id
4432: ,effective_start_date