The following lines contain the word 'select', 'insert', 'update' or 'delete':
select hou1.org_information_id,hou1.org_information_context,hou1.object_version_number
,ho1.object_version_number
from
hr_all_organization_units ho1,
hr_organization_information hou1
where ho1.organization_id=l_organization_id
and hou1.organization_id=ho1.organization_id
and hou1.org_information_context='Exp Organization Defaults';
select 'Y'
from hr_all_organization_units
where organization_id=l_organization_id
and nvl(internal_external_flag,'X')=nvl(l_internal_external_flag,'X');
select object_version_number
from hr_all_organization_units
where organization_id=l_organization_id
and
(name <> l_organization_name
or date_from <> l_date_from
or nvl(date_to,to_date('31/12/4712','dd/mm/rrrr')) <>
nvl(l_date_to,to_date('31/12/4712','dd/mm/rrrr')));
select 'Y' from HR_OPERATING_UNITS
where trunc(sysdate) between trunc(date_from) and nvl(trunc(date_to), trunc(sysdate))
and organization_id = p_operating_unit;
select 'Y' from hr_all_organization_units
where business_group_id = l_business_group_id
and name = l_organization_name ;
if ( is_valid_name %found ) THEN -- Organization exists, update needed
select organization_id into l_organization_id
from hr_all_organization_units
where business_group_id = l_business_group_id
and name = l_organization_name ;
hr_organization_api.update_org_information(
p_effective_date =>sysdate
,p_org_information_id =>l_org_information_id
,p_org_info_type_code =>l_org_info_type_code
,p_org_information1 =>l_operating_unit_id
,p_object_version_number=>l_object_version_number_inf
);
hr_organization_api.update_organization(
p_effective_date =>sysdate
,p_name =>l_organization_name
,p_organization_id =>l_organization_id
,p_internal_external_flag =>l_internal_external_flag
,p_date_from =>l_date_from
,p_date_to =>l_date_to
,p_object_version_number =>l_object_version_number_org
,p_duplicate_org_warning =>l_duplicate_org_warning
);