The following lines contain the word 'select', 'insert', 'update' or 'delete':
Procedure chk_non_updateable_args
(
p_rec in hr_opt_shd.g_rec_type
) IS
--
l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
End chk_non_updateable_args;
select option_type_id
from hr_ki_option_types
where option_type_id = p_option_type_id;
select responsibility_id
from fnd_responsibility
where responsibility_id =l_r_id
and application_id=l_a_id;
select application_id
from fnd_application
where application_id =p_option_level_id ;
select user_id
from fnd_user
where user_id=p_option_level_id ;
select INTEGRATION_ID
from hr_ki_integrations
where integration_id = p_integration_id;
select null
from hr_ki_options
where (option_type_id = p_option_type_id
and integration_id = p_integration_id
and option_level=p_option_level)
and (option_level_id=p_option_level_id
or option_level_id is null);
Procedure insert_validate
(p_effective_date in date
,p_rec in hr_opt_shd.g_rec_type
) is
--
l_proc varchar2(72) := g_package||'insert_validate';
End insert_validate;
Procedure update_validate
(
p_rec in hr_opt_shd.g_rec_type
) is
--
l_proc varchar2(72) := g_package||'update_validate';
chk_non_updateable_args
(
p_rec => p_rec
);
End update_validate;
Procedure delete_validate
(p_rec in hr_opt_shd.g_rec_type
) is
--
l_proc varchar2(72) := g_package||'delete_validate';
End delete_validate;