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_ASSIGNMENTS_F

Line 794: FROM per_all_assignments_f

790: l_hire_date);
791:
792: SELECT object_version_number
793: INTO l_asg_object_Version_number
794: FROM per_all_assignments_f
795: WHERE business_group_id = p_business_group_id
796: and person_id = l_person_id
797: and assignment_id = l_assignment_id
798: and effective_start_Date = l_hire_date;

Line 4029: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

4025: --
4026: -- Local variables
4027: --
4028: l_proc VARCHAR2(72) := g_package||'hire_into_job';
4029: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
4030: --
4031: BEGIN
4032: --
4033: if g_debug then

Line 4089: l_object_version_number CONSTANT per_all_assignments_f.object_version_number%TYPE := p_object_version_number;

4085: l_proc VARCHAR2(72) := g_package||'hire_into_job';
4086: --
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;

Line 4114: l_assignment_id per_all_assignments_f.assignment_id%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;
4115: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
4116: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
4117: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
4118: l_person_type_usage_id per_person_type_usages.person_type_usage_id%TYPE;

Line 4115: l_asg_object_version_number per_all_assignments_f.object_version_number%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;
4115: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
4116: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
4117: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
4118: l_person_type_usage_id per_person_type_usages.person_type_usage_id%TYPE;
4119: l_ptu_object_version_number per_person_type_usages.object_version_number%TYPE;

Line 4116: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;

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;
4115: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
4116: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
4117: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
4118: l_person_type_usage_id per_person_type_usages.person_type_usage_id%TYPE;
4119: l_ptu_object_version_number per_person_type_usages.object_version_number%TYPE;
4120: --

Line 4117: l_assignment_number per_all_assignments_f.assignment_number%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;
4115: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
4116: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
4117: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
4118: l_person_type_usage_id per_person_type_usages.person_type_usage_id%TYPE;
4119: l_ptu_object_version_number per_person_type_usages.object_version_number%TYPE;
4120: --
4121: -- Start of fix for bug 3143299

Line 4987: INSERT INTO per_all_assignments_f

4983: --
4984: -- Insert new record with primary flag 'N' and ESD
4985: -- same as EED same as rehire date
4986: --
4987: INSERT INTO per_all_assignments_f
4988: (assignment_id
4989: ,effective_start_date
4990: ,effective_end_date
4991: ,business_group_id

Line 5238: INSERT INTO per_all_assignments_f

5234: --
5235: -- Insert new record primary flag 'N' and ESD
5236: -- same as rehire date
5237: --
5238: INSERT INTO per_all_assignments_f
5239: (assignment_id
5240: ,effective_start_date
5241: ,effective_end_date
5242: ,business_group_id