The following lines contain the word 'select', 'insert', 'update' or 'delete':
Procedure chk_non_updateable_args
(p_effective_date in date
,p_rec in irc_isc_shd.g_rec_type
) IS
--
l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
End chk_non_updateable_args;
select null
from per_all_people_f ppf
where ppf.person_id = p_person_id
and trunc(p_effective_date) between ppf.effective_start_date
and ppf.effective_end_date;
select 1
from irc_search_criteria isc
where isc.object_id = p_object_id
and isc.object_type = 'WPREF';
select null from irc_search_criteria isc
where isc.search_name = p_search_name
and isc.object_id = p_person_id ;
select 1 from hr_locations_all
where location_id=p_location_id;
select null from per_all_vacancies pav
where pav.vacancy_id = p_vacancy_id;
select null from per_qualification_types pqt
where pqt.qualification_type_id = p_min_qual_level;
select rank from per_qualification_types where qualification_type_id = c_qual_type_id;
select null from fnd_currencies fc
where p_salary_currency = fc.currency_code
and p_effective_date between
nvl(fc.start_date_active, p_effective_date)
and nvl(fc.end_date_active, p_effective_date);
Procedure insert_validate
(p_effective_date in date
,p_rec in irc_isc_shd.g_rec_type
) is
--
l_proc varchar2(72) := g_package||'insert_validate';
End insert_validate;
Procedure update_validate
(p_effective_date in date
,p_rec in irc_isc_shd.g_rec_type
) 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 irc_isc_shd.g_rec_type
) is
--
l_proc varchar2(72) := g_package||'delete_validate';
End delete_validate;