The following lines contain the word 'select', 'insert', 'update' or 'delete':
Procedure chk_non_updateable_args(p_rec in ghr_pdh_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
end chk_non_updateable_args;
select 1
from ghr_position_descriptions gpd
where gpd.position_description_id = p_position_description_id;
select 1
from ghr_groupboxes gbx,
ghr_position_descriptions gpd
where gpd.position_description_id = p_position_description_id
and gbx.routing_group_id = gpd.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 fnd_user
WHERE user_name = upper(p_user_name);
SELECT 1
FROM fnd_user
WHERE UPPER(user_name) = UPPER(p_user_name)
AND user_name LIKE 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_pdh_shd.g_rec_type
)is
--
l_proc varchar2(72) := g_package||'insert_validate';
End insert_validate;
Procedure update_validate
(p_rec in ghr_pdh_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_pdh_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'delete_validate';
End delete_validate;