865: -- per_all_assigments_f
866: -- pay_wc_funds
867: -- per_events
868: -- per_all_vacancies
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
920: SELECT NULL
921: FROM per_all_vacancies
922: WHERE location_id = p_location_id;
923: --
924: cursor csr_hr_all_organization_units IS
925: SELECT NULL
926: FROM hr_all_organization_units
927: WHERE location_id = p_location_id;
928: --
922: WHERE location_id = p_location_id;
923: --
924: cursor csr_hr_all_organization_units IS
925: SELECT NULL
926: FROM hr_all_organization_units
927: WHERE location_id = p_location_id;
928: --
929: cursor csr_hr_all_positions_f IS
930: SELECT NULL
998: CLOSE csr_per_all_vacancies;
999: --
1000: --
1001: hr_utility.set_location(l_proc, 30);
1002: OPEN csr_hr_all_organization_units;
1003: FETCH csr_hr_all_organization_units INTO l_exists;
1004: IF csr_hr_all_organization_units%found THEN
1005: CLOSE csr_hr_all_organization_units;
1006: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');
999: --
1000: --
1001: hr_utility.set_location(l_proc, 30);
1002: OPEN csr_hr_all_organization_units;
1003: FETCH csr_hr_all_organization_units INTO l_exists;
1004: IF csr_hr_all_organization_units%found THEN
1005: CLOSE csr_hr_all_organization_units;
1006: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');
1007: hr_utility.raise_error;
1000: --
1001: hr_utility.set_location(l_proc, 30);
1002: OPEN csr_hr_all_organization_units;
1003: FETCH csr_hr_all_organization_units INTO l_exists;
1004: IF csr_hr_all_organization_units%found THEN
1005: CLOSE csr_hr_all_organization_units;
1006: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');
1007: hr_utility.raise_error;
1008: END IF;
1001: hr_utility.set_location(l_proc, 30);
1002: OPEN csr_hr_all_organization_units;
1003: FETCH csr_hr_all_organization_units INTO l_exists;
1004: IF csr_hr_all_organization_units%found THEN
1005: CLOSE csr_hr_all_organization_units;
1006: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');
1007: hr_utility.raise_error;
1008: END IF;
1009: CLOSE csr_hr_all_organization_units;
1005: CLOSE csr_hr_all_organization_units;
1006: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');
1007: hr_utility.raise_error;
1008: END IF;
1009: CLOSE csr_hr_all_organization_units;
1010: --
1011: -- Added by SCNair on 30-SEP-99 (position date tracked table)
1012: --
1013: hr_utility.set_location(l_proc, 35);