APPS.HR_LOC_BUS dependencies on HR_LOCATION_EXTRA_INFO

Line 884: -- hr_location_extra_info

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
885: -- per_us_inval_locations
886: --
887: --
888: -- Pre-conditions:

Line 955: cursor csr_hr_location_extra_info IS

951: SELECT NULL
952: FROM per_salary_survey_mappings
953: WHERE location_id = p_location_id;
954:
955: cursor csr_hr_location_extra_info IS
956: SELECT NULL
957: FROM hr_location_extra_info
958: WHERE location_id = p_location_id;
959: --

Line 957: FROM hr_location_extra_info

953: WHERE location_id = p_location_id;
954:
955: cursor csr_hr_location_extra_info IS
956: SELECT NULL
957: FROM hr_location_extra_info
958: WHERE location_id = p_location_id;
959: --
960: cursor csr_per_us_inval_locations IS
961: SELECT NULL

Line 1067: OPEN csr_hr_location_extra_info;

1063: CLOSE csr_per_salary_survey_mappings;
1064: --
1065: --
1066: hr_utility.set_location(l_proc, 50);
1067: OPEN csr_hr_location_extra_info;
1068: FETCH csr_hr_location_extra_info INTO l_exists;
1069: IF csr_hr_location_extra_info%found THEN
1070: CLOSE csr_hr_location_extra_info;
1071: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');

Line 1068: FETCH csr_hr_location_extra_info INTO l_exists;

1064: --
1065: --
1066: hr_utility.set_location(l_proc, 50);
1067: OPEN csr_hr_location_extra_info;
1068: FETCH csr_hr_location_extra_info INTO l_exists;
1069: IF csr_hr_location_extra_info%found THEN
1070: CLOSE csr_hr_location_extra_info;
1071: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');
1072: hr_utility.raise_error;

Line 1069: IF csr_hr_location_extra_info%found THEN

1065: --
1066: hr_utility.set_location(l_proc, 50);
1067: OPEN csr_hr_location_extra_info;
1068: FETCH csr_hr_location_extra_info INTO l_exists;
1069: IF csr_hr_location_extra_info%found THEN
1070: CLOSE csr_hr_location_extra_info;
1071: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');
1072: hr_utility.raise_error;
1073: END IF;

Line 1070: CLOSE csr_hr_location_extra_info;

1066: hr_utility.set_location(l_proc, 50);
1067: OPEN csr_hr_location_extra_info;
1068: FETCH csr_hr_location_extra_info INTO l_exists;
1069: IF csr_hr_location_extra_info%found THEN
1070: CLOSE csr_hr_location_extra_info;
1071: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');
1072: hr_utility.raise_error;
1073: END IF;
1074: CLOSE csr_hr_location_extra_info;

Line 1074: CLOSE csr_hr_location_extra_info;

1070: CLOSE csr_hr_location_extra_info;
1071: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');
1072: hr_utility.raise_error;
1073: END IF;
1074: CLOSE csr_hr_location_extra_info;
1075: --
1076: --
1077: hr_utility.set_location(l_proc, 55);
1078: OPEN csr_per_us_inval_locations;