The following lines contain the word 'select', 'insert', 'update' or 'delete':
Procedure chk_non_updateable_args(p_rec in ghr_prh_shd.g_rec_type) is
--
l_proc varchar2(72) ;
l_proc := g_package || 'chk_non_updateable_args';
end chk_non_updateable_args;
select 1
from ghr_pa_requests par
where par.pa_request_id = p_pa_request_id;
select 1
from ghr_groupboxes gbx,
ghr_pa_requests par
where par.pa_request_id = p_pa_request_id
and gbx.routing_group_id = par.routing_group_id
and gbx.groupbox_id = p_groupbox_id;
select 1
from ghr_groupbox_users gbu
where gbu.groupbox_id = p_groupbox_id
and gbu.user_name = p_user_name;
select 1
from fnd_user
where upper(user_name) = upper(p_user_name);
select 1
from ghr_routing_lists prl
where prl.routing_list_id = p_routing_list_id;
select 1
from ghr_routing_list_members rlm
where rlm.routing_list_id = p_routing_list_id
and rlm.seq_number = p_routing_seq_number;
Procedure insert_validate
(p_rec in ghr_prh_shd.g_rec_type
)is
--
l_proc varchar2(72) := g_package||'insert_validate';
End insert_validate;
Procedure update_validate
(p_rec in ghr_prh_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 ghr_prh_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'delete_validate';
End delete_validate;