APPS.HR_LOC_BUS dependencies on PER_ALL_VACANCIES

Line 879: -- per_all_vacancies

875: --
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

Line 930: cursor csr_per_all_vacancies IS

926: SELECT NULL
927: FROM per_events
928: WHERE location_id = p_location_id;
929: --
930: cursor csr_per_all_vacancies IS
931: SELECT NULL
932: FROM per_all_vacancies
933: WHERE location_id = p_location_id;
934: --

Line 932: FROM per_all_vacancies

928: WHERE location_id = p_location_id;
929: --
930: cursor csr_per_all_vacancies 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

Line 1011: OPEN csr_per_all_vacancies;

1007: CLOSE csr_per_events;
1008: --
1009: --
1010: hr_utility.set_location(l_proc, 25);
1011: OPEN csr_per_all_vacancies;
1012: FETCH csr_per_all_vacancies INTO l_exists;
1013: IF csr_per_all_vacancies%found THEN
1014: CLOSE csr_per_all_vacancies;
1015: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');

Line 1012: FETCH csr_per_all_vacancies INTO l_exists;

1008: --
1009: --
1010: hr_utility.set_location(l_proc, 25);
1011: OPEN csr_per_all_vacancies;
1012: FETCH csr_per_all_vacancies INTO l_exists;
1013: IF csr_per_all_vacancies%found THEN
1014: CLOSE csr_per_all_vacancies;
1015: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');
1016: hr_utility.raise_error;

Line 1013: IF csr_per_all_vacancies%found THEN

1009: --
1010: hr_utility.set_location(l_proc, 25);
1011: OPEN csr_per_all_vacancies;
1012: FETCH csr_per_all_vacancies INTO l_exists;
1013: IF csr_per_all_vacancies%found THEN
1014: CLOSE csr_per_all_vacancies;
1015: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');
1016: hr_utility.raise_error;
1017: END IF;

Line 1014: CLOSE csr_per_all_vacancies;

1010: hr_utility.set_location(l_proc, 25);
1011: OPEN csr_per_all_vacancies;
1012: FETCH csr_per_all_vacancies INTO l_exists;
1013: IF csr_per_all_vacancies%found THEN
1014: CLOSE csr_per_all_vacancies;
1015: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');
1016: hr_utility.raise_error;
1017: END IF;
1018: CLOSE csr_per_all_vacancies;

Line 1018: CLOSE csr_per_all_vacancies;

1014: CLOSE csr_per_all_vacancies;
1015: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');
1016: hr_utility.raise_error;
1017: END IF;
1018: CLOSE csr_per_all_vacancies;
1019: --
1020: --
1021: hr_utility.set_location(l_proc, 30);
1022: OPEN csr_hr_all_organization_units;