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_LOC_BUS dependencies on HR_ALL_ORGANIZATION_UNITS

Line 880: -- hr_all_organization_units

876: -- per_all_assigments_f
877: -- pay_wc_funds
878: -- per_events
879: -- per_all_vacancies
880: -- hr_all_organization_units
881: -- hr_all_positions_f (date tracked position table)
882: -- pay_element_links_f
883: -- per_salary_survey_mappings
884: -- hr_location_extra_info

Line 935: cursor csr_hr_all_organization_units IS

931: SELECT NULL
932: FROM per_all_vacancies
933: WHERE location_id = p_location_id;
934: --
935: cursor csr_hr_all_organization_units IS
936: SELECT NULL
937: FROM hr_all_organization_units
938: WHERE location_id = p_location_id;
939: --

Line 937: FROM hr_all_organization_units

933: WHERE location_id = p_location_id;
934: --
935: cursor csr_hr_all_organization_units IS
936: SELECT NULL
937: FROM hr_all_organization_units
938: WHERE location_id = p_location_id;
939: --
940: cursor csr_hr_all_positions_f IS
941: SELECT NULL

Line 1022: OPEN csr_hr_all_organization_units;

1018: CLOSE csr_per_all_vacancies;
1019: --
1020: --
1021: hr_utility.set_location(l_proc, 30);
1022: OPEN csr_hr_all_organization_units;
1023: FETCH csr_hr_all_organization_units INTO l_exists;
1024: IF csr_hr_all_organization_units%found THEN
1025: CLOSE csr_hr_all_organization_units;
1026: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');

Line 1023: FETCH csr_hr_all_organization_units INTO l_exists;

1019: --
1020: --
1021: hr_utility.set_location(l_proc, 30);
1022: OPEN csr_hr_all_organization_units;
1023: FETCH csr_hr_all_organization_units INTO l_exists;
1024: IF csr_hr_all_organization_units%found THEN
1025: CLOSE csr_hr_all_organization_units;
1026: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');
1027: hr_utility.raise_error;

Line 1024: IF csr_hr_all_organization_units%found THEN

1020: --
1021: hr_utility.set_location(l_proc, 30);
1022: OPEN csr_hr_all_organization_units;
1023: FETCH csr_hr_all_organization_units INTO l_exists;
1024: IF csr_hr_all_organization_units%found THEN
1025: CLOSE csr_hr_all_organization_units;
1026: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');
1027: hr_utility.raise_error;
1028: END IF;

Line 1025: CLOSE csr_hr_all_organization_units;

1021: hr_utility.set_location(l_proc, 30);
1022: OPEN csr_hr_all_organization_units;
1023: FETCH csr_hr_all_organization_units INTO l_exists;
1024: IF csr_hr_all_organization_units%found THEN
1025: CLOSE csr_hr_all_organization_units;
1026: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');
1027: hr_utility.raise_error;
1028: END IF;
1029: CLOSE csr_hr_all_organization_units;

Line 1029: CLOSE csr_hr_all_organization_units;

1025: CLOSE csr_hr_all_organization_units;
1026: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');
1027: hr_utility.raise_error;
1028: END IF;
1029: CLOSE csr_hr_all_organization_units;
1030: --
1031: -- Added by SCNair on 30-SEP-99 (position date tracked table)
1032: --
1033: hr_utility.set_location(l_proc, 35);