The following lines contain the word 'select', 'insert', 'update' or 'delete':
Select resource_id
From jtf_rs_resource_extns
Where user_id = p_user_id
--And u.employee_id = r.source_id
--And r.category = 'EMPLOYEE'
;
Select
user_name
From fnd_user
Where user_id = p_id;
Select
user_id, user_name
From fnd_user
Where user_id = p_id;
Select item_id
From jtf_amv_items_vl
where item_id = p_item_id;
Select channel_id
From amv_c_channels_b
where channel_id = p_channel_id;
Select channel_category_id
From amv_c_categories_b
where channel_category_id = p_category_id;
Select application_id
From fnd_application
where application_id = p_application_id;
Select perspective_id
From amv_i_perspectives_b
where perspective_id = p_perspective_id;
Select content_type_id
From amv_i_content_types_b
where content_type_id = p_content_type_id;
Select role_id
From jtf_rs_roles_vl
Where role_id = p_role_id
; --And role_type_id = AMV_USER_PVT.G_MES_ROLE_TYPE_ID;
Select resource_id
From jtf_rs_resource_extns
Where resource_id = p_resource_id
--And category = AMV_USER_PVT.G_RESOURCE_CATEGORY
;
Select group_id
From jtf_rs_groups_vl
where group_id = p_group_id
--And usage = AMV_USER_PVT.G_MES_GROUP_USAGE
;
select count(*)
from jtf_rs_resource_extns
where resource_id = p_user_id;
select count(*)
from amv_u_my_channels
where my_channel_id = p_mychannel_id;
FUNCTION Get_DeleteChannelStatus
( p_channel_id IN NUMBER,
p_user_or_group_id IN NUMBER,
p_user_or_group_type IN VARCHAR2) return boolean
IS
--
l_flag varchar2(1);
select can_delete_flag
from amv_u_access
where access_to_table_code = AMV_UTILITY_PVT.G_CHANNEL
and access_to_table_record_id = p_channel_id
and user_or_group_id = p_user_or_group_id
and user_or_group_type = p_user_or_group_type;
END Get_DeleteChannelStatus;
FUNCTION Get_UpdateChannelStatus
( p_channel_id IN NUMBER,
p_user_or_group_id IN NUMBER,
p_user_or_group_type IN VARCHAR2) return boolean
IS
--
l_flag varchar2(1);
select can_update_flag
from amv_u_access
where access_to_table_code = AMV_UTILITY_PVT.G_CHANNEL
and access_to_table_record_id = p_channel_id
and user_or_group_id = p_user_or_group_id
and user_or_group_type = p_user_or_group_type;
END Get_UpdateChannelStatus;
FUNCTION Get_DeleteCategoryStatus
( p_category_id IN NUMBER,
p_user_or_group_id IN NUMBER,
p_user_or_group_type IN VARCHAR2) return boolean
IS
--
l_flag varchar2(1);
select can_delete_flag
from amv_u_access
where access_to_table_code = AMV_UTILITY_PVT.G_CATEGORY
and access_to_table_record_id = p_category_id
and user_or_group_id = p_user_or_group_id
and user_or_group_type = p_user_or_group_type;
END Get_DeleteCategoryStatus;
FUNCTION Get_UpdateCategoryStatus
( p_category_id IN NUMBER,
p_user_or_group_id IN NUMBER,
p_user_or_group_type IN VARCHAR2) return boolean
IS
--
l_flag varchar2(1);
select can_update_flag
from amv_u_access
where access_to_table_code = AMV_UTILITY_PVT.G_CATEGORY
and access_to_table_record_id = p_category_id
and user_or_group_id = p_user_or_group_id
and user_or_group_type = p_user_or_group_type;
END Get_UpdateCategoryStatus;