APPS.AMV_UTILITY_PVT2 SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 42

select count(*)
from   amv_c_categories_b
where  channel_category_id = p_category_id;

Line: 81

select count(*)
from   jtf_rs_resource_extns
where  resource_id = p_user_id;

Line: 119

select count(*)
from   amv_u_my_channels
where  my_channel_id = p_mychannel_id;

Line: 154

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);

Line: 163

select can_delete_flag
from	  amv_u_access
where  access_to_table_code = AMV_UTILITY_PVT2.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;

Line: 185

END Get_DeleteChannelStatus;

Line: 207

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);

Line: 216

select can_update_flag
from	  amv_u_access
where  access_to_table_code = AMV_UTILITY_PVT2.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;

Line: 238

END Get_UpdateChannelStatus;

Line: 261

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);

Line: 270

select can_delete_flag
from	  amv_u_access
where  access_to_table_code = AMV_UTILITY_PVT2.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;

Line: 292

END Get_DeleteCategoryStatus;

Line: 314

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);

Line: 323

select can_update_flag
from	  amv_u_access
where  access_to_table_code = AMV_UTILITY_PVT2.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;

Line: 345

END Get_UpdateCategoryStatus;