The following lines contain the word 'select', 'insert', 'update' or 'delete':
select business_group_id
into p_business_group_id
from per_position_structures
where p_position_structure_id = position_structure_id;
select pbg.security_group_id
from per_business_groups pbg
, per_pos_structure_versions psv
where psv.pos_structure_version_id = p_pos_structure_version_id
and pbg.business_group_id = psv.business_group_id;
select pbg.legislation_code
from per_business_groups pbg
, per_pos_structure_versions psv
where psv.pos_structure_version_id = p_pos_structure_version_id
and pbg.business_group_id = psv.business_group_id;
cursor struct_element is select *
from per_pos_structure_elements ose
where ose.pos_structure_version_id = p_src_psv_id;
select count(*)
into l_count
from per_pos_structure_versions
where pos_structure_version_id in (p_src_psv_id,
p_dest_psv_id);
INSERT INTO PER_POS_STRUCTURE_ELEMENTS(
pos_structure_element_id,
business_group_id,
parent_position_id,
pos_structure_version_id
) VALUES (
PER_POS_STRUCTURE_ELEMENTS_S.NEXTVAL,
ele_record.Business_Group_Id,
ele_record.parent_position_Id,
p_pos_structure_version_id
);
select max(osv.date_to)
into l_max_end_date
from per_pos_structure_versions osv
where osv.date_from < p_Date_From
and osv.position_structure_id = p_position_structure_id
and osv.pos_structure_Version_id = nvl(p_pos_structure_version_id,-1);
select min(osv.date_from)
into l_min_start_date
from per_pos_structure_versions osv
where osv.position_structure_id = p_position_structure_id
and osv.date_from > p_Date_To
and osv.pos_structure_Version_id = nvl(p_pos_structure_version_id,-1);
select null
into l_dummy
from dual
where exists
(select 1
from per_pos_structure_versions osv
where osv.date_from <= nvl(p_Date_To, hr_api.g_eot)
and nvl(osv.date_to,hr_api.g_eot) >= p_Date_From
and osv.position_structure_id = p_position_structure_id
and osv.pos_structure_version_id
<> nvl(p_pos_structure_version_id,-1));
select pos_structure_version_id,business_group_id
from per_pos_structure_versions
where version_number = p_version_number
and nvl(p_pos_structure_version_id,-1) <> pos_structure_version_id
and p_position_structure_id = position_structure_id;
select 'N' from dual
where not exists (select 'Y' from per_position_structures where position_structure_id = p_position_structure_id);
Procedure chk_non_updateable_args
(p_effective_date in date
,p_rec in per_psv_shd.g_rec_type
) IS
--
l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
End chk_non_updateable_args;
Procedure insert_validate
(p_effective_date in date
,p_rec in per_psv_shd.g_rec_type
,p_gap_warning out nocopy boolean
) is
--
l_proc varchar2(72) := g_package||'insert_validate';
End insert_validate;
Procedure update_validate
(p_effective_date in date
,p_rec in per_psv_shd.g_rec_type
,p_gap_warning out nocopy boolean ) is
--
l_proc varchar2(72) := g_package||'update_validate';
chk_non_updateable_args
(p_effective_date => p_effective_date
,p_rec => p_rec
);
End update_validate;
Procedure delete_validate
(p_rec in per_psv_shd.g_rec_type
) is
--
l_proc varchar2(72) := g_package||'delete_validate';
End delete_validate;