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 PER_US_INVAL_LOCATIONS

Line 874: -- per_us_inval_locations

870: -- hr_all_positions_f (date tracked position table)
871: -- pay_element_links_f
872: -- per_salary_survey_mappings
873: -- hr_location_extra_info
874: -- per_us_inval_locations
875: --
876: --
877: -- Pre-conditions:
878: -- None

Line 949: cursor csr_per_us_inval_locations IS

945: SELECT NULL
946: FROM hr_location_extra_info
947: WHERE location_id = p_location_id;
948: --
949: cursor csr_per_us_inval_locations IS
950: SELECT NULL
951: FROM per_us_inval_locations
952: WHERE location_id = p_location_id;
953: --

Line 951: FROM per_us_inval_locations

947: WHERE location_id = p_location_id;
948: --
949: cursor csr_per_us_inval_locations IS
950: SELECT NULL
951: FROM per_us_inval_locations
952: WHERE location_id = p_location_id;
953: --
954: BEGIN
955: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 1058: OPEN csr_per_us_inval_locations;

1054: CLOSE csr_hr_location_extra_info;
1055: --
1056: --
1057: hr_utility.set_location(l_proc, 55);
1058: OPEN csr_per_us_inval_locations;
1059: FETCH csr_per_us_inval_locations INTO l_exists;
1060: IF csr_per_us_inval_locations%found THEN
1061: CLOSE csr_per_us_inval_locations;
1062: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');

Line 1059: FETCH csr_per_us_inval_locations INTO l_exists;

1055: --
1056: --
1057: hr_utility.set_location(l_proc, 55);
1058: OPEN csr_per_us_inval_locations;
1059: FETCH csr_per_us_inval_locations INTO l_exists;
1060: IF csr_per_us_inval_locations%found THEN
1061: CLOSE csr_per_us_inval_locations;
1062: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');
1063: hr_utility.raise_error;

Line 1060: IF csr_per_us_inval_locations%found THEN

1056: --
1057: hr_utility.set_location(l_proc, 55);
1058: OPEN csr_per_us_inval_locations;
1059: FETCH csr_per_us_inval_locations INTO l_exists;
1060: IF csr_per_us_inval_locations%found THEN
1061: CLOSE csr_per_us_inval_locations;
1062: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');
1063: hr_utility.raise_error;
1064: END IF;

Line 1061: CLOSE csr_per_us_inval_locations;

1057: hr_utility.set_location(l_proc, 55);
1058: OPEN csr_per_us_inval_locations;
1059: FETCH csr_per_us_inval_locations INTO l_exists;
1060: IF csr_per_us_inval_locations%found THEN
1061: CLOSE csr_per_us_inval_locations;
1062: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');
1063: hr_utility.raise_error;
1064: END IF;
1065: CLOSE csr_per_us_inval_locations;

Line 1065: CLOSE csr_per_us_inval_locations;

1061: CLOSE csr_per_us_inval_locations;
1062: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');
1063: hr_utility.raise_error;
1064: END IF;
1065: CLOSE csr_per_us_inval_locations;
1066: --
1067: -- Call pre-delete validation provided by other Apps
1068: --
1069: inv_location.inv_predel_validation ( p_location_id => p_location_id);