APPS.AMV_UTILITY_PVT SQL Statements

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

Line: 82

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

Line: 168

Select
    user_name
From   fnd_user
Where  user_id = p_id;

Line: 250

Select
    user_id, user_name
From   fnd_user
Where  user_id = p_id;

Line: 315

Select item_id
From   jtf_amv_items_vl
where  item_id = p_item_id;

Line: 354

Select channel_id
From   amv_c_channels_b
where  channel_id = p_channel_id;

Line: 393

Select channel_category_id
From   amv_c_categories_b
where  channel_category_id = p_category_id;

Line: 431

Select application_id
From   fnd_application
where  application_id = p_application_id;

Line: 470

Select perspective_id
From   amv_i_perspectives_b
where  perspective_id = p_perspective_id;

Line: 511

Select content_type_id
From   amv_i_content_types_b
where  content_type_id = p_content_type_id;

Line: 549

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;

Line: 588

Select resource_id
From   jtf_rs_resource_extns
Where  resource_id = p_resource_id
--And    category = AMV_USER_PVT.G_RESOURCE_CATEGORY
;

Line: 653

Select group_id
From   jtf_rs_groups_vl
where  group_id = p_group_id
--And    usage = AMV_USER_PVT.G_MES_GROUP_USAGE
;

Line: 698

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

Line: 736

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

Line: 771

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: 780

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;

Line: 802

END Get_DeleteChannelStatus;

Line: 824

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: 833

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;

Line: 855

END Get_UpdateChannelStatus;

Line: 878

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: 887

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;

Line: 909

END Get_DeleteCategoryStatus;

Line: 931

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: 940

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;

Line: 962

END Get_UpdateCategoryStatus;