APPS.HR_LOC_BUS dependencies on PER_ALL_VACANCIES

Line 868: -- per_all_vacancies

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

Line 919: cursor csr_per_all_vacancies IS

915: SELECT NULL
916: FROM per_events
917: WHERE location_id = p_location_id;
918: --
919: cursor csr_per_all_vacancies IS
920: SELECT NULL
921: FROM per_all_vacancies
922: WHERE location_id = p_location_id;
923: --

Line 921: FROM per_all_vacancies

917: WHERE location_id = p_location_id;
918: --
919: cursor csr_per_all_vacancies IS
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

Line 991: OPEN csr_per_all_vacancies;

987: CLOSE csr_per_events;
988: --
989: --
990: hr_utility.set_location(l_proc, 25);
991: OPEN csr_per_all_vacancies;
992: FETCH csr_per_all_vacancies INTO l_exists;
993: IF csr_per_all_vacancies%found THEN
994: CLOSE csr_per_all_vacancies;
995: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');

Line 992: FETCH csr_per_all_vacancies INTO l_exists;

988: --
989: --
990: hr_utility.set_location(l_proc, 25);
991: OPEN csr_per_all_vacancies;
992: FETCH csr_per_all_vacancies INTO l_exists;
993: IF csr_per_all_vacancies%found THEN
994: CLOSE csr_per_all_vacancies;
995: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');
996: hr_utility.raise_error;

Line 993: IF csr_per_all_vacancies%found THEN

989: --
990: hr_utility.set_location(l_proc, 25);
991: OPEN csr_per_all_vacancies;
992: FETCH csr_per_all_vacancies INTO l_exists;
993: IF csr_per_all_vacancies%found THEN
994: CLOSE csr_per_all_vacancies;
995: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');
996: hr_utility.raise_error;
997: END IF;

Line 994: CLOSE csr_per_all_vacancies;

990: hr_utility.set_location(l_proc, 25);
991: OPEN csr_per_all_vacancies;
992: FETCH csr_per_all_vacancies INTO l_exists;
993: IF csr_per_all_vacancies%found THEN
994: CLOSE csr_per_all_vacancies;
995: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');
996: hr_utility.raise_error;
997: END IF;
998: CLOSE csr_per_all_vacancies;

Line 998: CLOSE csr_per_all_vacancies;

994: CLOSE csr_per_all_vacancies;
995: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');
996: hr_utility.raise_error;
997: END IF;
998: CLOSE csr_per_all_vacancies;
999: --
1000: --
1001: hr_utility.set_location(l_proc, 30);
1002: OPEN csr_hr_all_organization_units;