APPS.HR_LOC_BUS dependencies on HR_LOCATION_EXTRA_INFO

Line 873: -- hr_location_extra_info

869: -- hr_all_organization_units
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:

Line 944: cursor csr_hr_location_extra_info IS

940: SELECT NULL
941: FROM per_salary_survey_mappings
942: WHERE location_id = p_location_id;
943:
944: cursor csr_hr_location_extra_info IS
945: SELECT NULL
946: FROM hr_location_extra_info
947: WHERE location_id = p_location_id;
948: --

Line 946: FROM hr_location_extra_info

942: WHERE location_id = p_location_id;
943:
944: cursor csr_hr_location_extra_info 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

Line 1047: OPEN csr_hr_location_extra_info;

1043: CLOSE csr_per_salary_survey_mappings;
1044: --
1045: --
1046: hr_utility.set_location(l_proc, 50);
1047: OPEN csr_hr_location_extra_info;
1048: FETCH csr_hr_location_extra_info INTO l_exists;
1049: IF csr_hr_location_extra_info%found THEN
1050: CLOSE csr_hr_location_extra_info;
1051: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');

Line 1048: FETCH csr_hr_location_extra_info INTO l_exists;

1044: --
1045: --
1046: hr_utility.set_location(l_proc, 50);
1047: OPEN csr_hr_location_extra_info;
1048: FETCH csr_hr_location_extra_info INTO l_exists;
1049: IF csr_hr_location_extra_info%found THEN
1050: CLOSE csr_hr_location_extra_info;
1051: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');
1052: hr_utility.raise_error;

Line 1049: IF csr_hr_location_extra_info%found THEN

1045: --
1046: hr_utility.set_location(l_proc, 50);
1047: OPEN csr_hr_location_extra_info;
1048: FETCH csr_hr_location_extra_info INTO l_exists;
1049: IF csr_hr_location_extra_info%found THEN
1050: CLOSE csr_hr_location_extra_info;
1051: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');
1052: hr_utility.raise_error;
1053: END IF;

Line 1050: CLOSE csr_hr_location_extra_info;

1046: hr_utility.set_location(l_proc, 50);
1047: OPEN csr_hr_location_extra_info;
1048: FETCH csr_hr_location_extra_info INTO l_exists;
1049: IF csr_hr_location_extra_info%found THEN
1050: CLOSE csr_hr_location_extra_info;
1051: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');
1052: hr_utility.raise_error;
1053: END IF;
1054: CLOSE csr_hr_location_extra_info;

Line 1054: CLOSE csr_hr_location_extra_info;

1050: CLOSE csr_hr_location_extra_info;
1051: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');
1052: hr_utility.raise_error;
1053: END IF;
1054: CLOSE csr_hr_location_extra_info;
1055: --
1056: --
1057: hr_utility.set_location(l_proc, 55);
1058: OPEN csr_per_us_inval_locations;