The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE hr_jp_predelete(p_organization_id INTEGER
,p_business_group_id INTEGER) is
/*
NAME
hr_jp_predelete
DESCRIPTION
Battery of tests to see if an organization has jobs and positions
and therefore may not be deleted.
PARAMETERS
p_organization_id : Organization Id of Organization to be deleted.
p_business_group_id : Business Group id of Organization to be deleted.
*/
--
-- Storage Variable.
--
l_test_func varchar2(60);
hr_utility.set_location('hr_job_pos.hr_jp_predelete',1);
select '1'
into l_test_func
from sys.dual
where exists ( select 1
from PER_JOBS_V x
where x.business_group_id = p_business_group_id);
hr_utility.set_location('hr_job_pos.hr_jp_predelete',2);
select '1'
into l_test_func
from sys.dual
where exists ( select 1
from HR_ALL_POSITIONS_F x
where x.organization_id = p_organization_id);
end hr_jp_predelete;
If so it may not be updated to a business group.
PARAMETERS
p_organization_id : Organization Id of Business group to be created.
*/
--
-- Local Storage variable.
l_test_func varchar2(60);
select '1'
into l_test_func
from sys.dual
where exists ( select 1
from HR_ALL_POSITIONS_F x
where x.ORGANIZATION_ID = p_organization_id);