eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMV_CHANNEL_PVT SQL Statements

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

Line: 90


select 	b.channel_id
from 	amv_c_channels_b b, amv_c_channels_tl tl
where 	tl.channel_name = p_channel_name
and   	tl.language = userenv('lang')
-- commented line below for bug no.2950840
--and	b.channel_category_id = p_category_id
and   	tl.channel_id = b.channel_id;

Line: 196


select 	match_on_author_flag
,	match_on_keyword_flag
,	match_on_perspective_flag
,	match_on_item_type_flag
,	match_on_content_type_flag
from	amv_c_channels_b
where	channel_id = p_channel_id;

Line: 298


select	b.channel_id,
	b.object_version_number,
	tl.channel_name,
	tl.description,
	b.channel_type,
	b.channel_category_id,
	b.status,
	b.owner_user_id,
	b.default_approver_user_id,
	b.effective_start_date,
	b.expiration_date,
	b.access_level_type,
	b.pub_need_approval_flag,
	b.sub_need_approval_flag,
	b.match_on_all_criteria_flag,
	b.match_on_keyword_flag,
	b.match_on_author_flag,
	b.match_on_perspective_flag,
	b.match_on_item_type_flag,
	b.match_on_content_type_flag,
	b.match_on_time_flag,
	b.application_id,
	b.external_access_flag,
	b.item_match_count,
	b.last_match_time,
	b.notification_interval_type,
	b.last_notification_time,
	b.attribute_category,
	b.attribute1,
	b.attribute2,
	b.attribute3,
	b.attribute4,
	b.attribute5,
	b.attribute6,
	b.attribute7,
	b.attribute8,
	b.attribute9,
	b.attribute10,
	b.attribute11,
	b.attribute12,
	b.attribute13,
	b.attribute14,
	b.attribute15
from	amv_c_channels_b b
,	amv_c_channels_tl tl
where	b.channel_id = p_channel_id
and   	tl.language = userenv('lang')
and	tl.channel_id = b.channel_id;

Line: 507


select amv_c_channels_b_s.nextval
from   dual;

Line: 674


    	 -- Select the channel sequence
	 OPEN ChannelId_Seq;

Line: 681


  	 AMV_C_CHANNELS_PKG.INSERT_ROW(
		X_ROWID => l_row_id,
  		X_CHANNEL_ID => l_channel_id,
		X_OBJECT_VERSION_NUMBER => l_object_version_number,
  		X_CHANNEL_TYPE =>  p_channel_record.channel_type,
  		X_CHANNEL_CATEGORY_ID => p_channel_record.channel_category_id,
  		X_STATUS => l_channel_obj.status,
  		X_OWNER_USER_ID => p_channel_record.owner_user_id,
  		X_DEFAULT_APPROVER_USER_ID =>
			p_channel_record.default_approver_user_id,
 		X_EFFECTIVE_START_DATE => l_channel_obj.effective_start_date,
  		X_EXPIRATION_DATE => l_expiration_date,
  		X_ACCESS_LEVEL_TYPE  => p_channel_record.access_level_type,
  		X_PUB_NEED_APPROVAL_FLAG =>
			l_channel_obj.pub_need_approval_flag,
  		X_SUB_NEED_APPROVAL_FLAG =>
			l_channel_obj.sub_need_approval_flag,
  		X_MATCH_ON_ALL_CRITERIA_FLAG =>
			l_channel_obj.match_on_all_criteria_flag,
  		X_MATCH_ON_KEYWORD_FLAG =>
			l_channel_obj.match_on_keyword_flag,
  		X_MATCH_ON_AUTHOR_FLAG => l_channel_obj.match_on_author_flag,
  		X_MATCH_ON_PERSPECTIVE_FLAG =>
			l_channel_obj.match_on_perspective_flag,
  		X_MATCH_ON_ITEM_TYPE_FLAG =>
			l_channel_obj.match_on_item_type_flag,
  		X_MATCH_ON_CONTENT_TYPE_FLAG =>
			l_channel_obj.match_on_content_type_flag,
  		X_MATCH_ON_TIME_FLAG => l_channel_obj.match_on_time_flag,
		X_APPLICATION_ID => l_channel_obj.application_id,
		X_EXTERNAL_ACCESS_FLAG => l_channel_obj.external_access_flag,
  		X_ITEM_MATCH_COUNT =>l_channel_obj.item_match_count,
  		X_LAST_MATCH_TIME => l_channel_obj.last_match_time,
  		X_NOTIFICATION_INTERVAL_TYPE =>
			l_channel_obj.notification_interval_type,
  		X_LAST_NOTIFICATION_TIME =>
			l_channel_obj.last_notification_time,
  		X_ATTRIBUTE_CATEGORY => l_channel_obj.attribute_category,
  		X_ATTRIBUTE1 => l_channel_obj.attribute1,
  		X_ATTRIBUTE2 => l_channel_obj.attribute2,
  		X_ATTRIBUTE3 => l_channel_obj.attribute3,
  		X_ATTRIBUTE4 => l_channel_obj.attribute4,
  		X_ATTRIBUTE5 => l_channel_obj.attribute5,
  		X_ATTRIBUTE6 => l_channel_obj.attribute6,
  		X_ATTRIBUTE7 => l_channel_obj.attribute7,
  		X_ATTRIBUTE8 => l_channel_obj.attribute8,
  		X_ATTRIBUTE9 => l_channel_obj.attribute9,
  		X_ATTRIBUTE10 => l_channel_obj.attribute10,
  		X_ATTRIBUTE11 => l_channel_obj.attribute11,
  		X_ATTRIBUTE12 => l_channel_obj.attribute12,
  		X_ATTRIBUTE13 => l_channel_obj.attribute13,
  		X_ATTRIBUTE14 => l_channel_obj.attribute14,
  		X_ATTRIBUTE15 => l_channel_obj.attribute15,
  		X_CHANNEL_NAME => l_channel_obj.channel_name,
		X_DESCRIPTION => l_channel_obj.description,
  		X_CREATION_DATE => sysdate,
  		X_CREATED_BY => l_user_id,
  		X_LAST_UPDATE_DATE => sysdate,
  		X_LAST_UPDATED_BY => l_user_id,
  		X_LAST_UPDATE_LOGIN =>  l_login_user_id
		);

Line: 1650


select channel_category_id
from   amv_c_categories_tl
where  channel_category_name = 'AMV_GROUP'
and    language = userenv('lang');

Line: 1656


select group_name
from  JTF_RS_GROUPS_VL
where group_id = p_group_id;

Line: 1898


PROCEDURE Delete_Channel
(     p_api_version       	IN  NUMBER,
      p_init_msg_list     	IN  VARCHAR2 := FND_API.G_FALSE,
      p_commit            	IN  VARCHAR2 := FND_API.G_FALSE,
      p_validation_level  	IN  NUMBER := FND_API.G_VALID_LEVEL_FULL,
      x_return_status     	OUT NOCOPY  VARCHAR2,
      x_msg_count         	OUT NOCOPY  NUMBER,
      x_msg_data          	OUT NOCOPY  VARCHAR2,
      p_check_login_user 	IN  VARCHAR2 := FND_API.G_TRUE,
      p_channel_id        	IN  NUMBER   := FND_API.G_MISS_NUM,
      p_channel_name      	IN  VARCHAR2 := FND_API.G_MISS_CHAR,
      p_category_id       	IN  NUMBER   := FND_API.G_MISS_NUM
)
IS
l_api_name          	CONSTANT VARCHAR2(30) := 'Delete_Channel';

Line: 1925


l_delete_channel_flag   	varchar2(1);

Line: 1930


    SAVEPOINT  Delete_Channel_PVT;

Line: 2016


		l_delete_channel_flag := FND_API.G_TRUE;

Line: 2018


		IF (AMV_UTILITY_PVT.Get_DeleteChannelStatus(	l_channel_id,
								l_resource_id,
								AMV_UTILITY_PVT.G_USER) )
		THEN
			l_delete_channel_flag := FND_API.G_TRUE;

Line: 2048


    IF l_delete_channel_flag = FND_API.G_TRUE THEN
	 -- Remove channel from mychannels
	 DELETE 	FROM amv_u_my_channels
	 WHERE	subscribing_to_id = l_channel_id
	 AND	subscribing_to_type = AMV_UTILITY_PVT.G_CHANNEL;

Line: 2055


	 DELETE 	FROM amv_u_access
	 WHERE	access_to_table_code = AMV_UTILITY_PVT.G_CHANNEL
	 AND		access_to_table_record_id = l_channel_id;

Line: 2060


	 DELETE 	FROM amv_c_authors
	 WHERE	channel_id = l_channel_id;

Line: 2063


	 DELETE 	FROM amv_c_keywords
	 WHERE	channel_id = l_channel_id;

Line: 2066


	 DELETE 	FROM amv_c_content_types
	 WHERE	channel_id = l_channel_id;

Line: 2069


	 DELETE 	FROM amv_c_chl_perspectives
	 WHERE	channel_id = l_channel_id;

Line: 2072


	 DELETE 	FROM amv_c_item_types
	 WHERE	channel_id = l_channel_id;

Line: 2075


	 DELETE 	FROM amv_c_chl_item_match
	 WHERE	channel_id = l_channel_id;

Line: 2079


	 AMV_C_CHANNELS_PKG.DELETE_ROW (l_channel_id);

Line: 2109


       ROLLBACK TO  Delete_Channel_PVT;

Line: 2118


       ROLLBACK TO  Delete_Channel_PVT;

Line: 2127


       ROLLBACK TO  Delete_Channel_PVT;

Line: 2140


END Delete_Channel;

Line: 2168


PROCEDURE Update_Channel
(     p_api_version       	IN  NUMBER,
      p_init_msg_list     	IN  VARCHAR2 := FND_API.G_FALSE,
      p_commit            	IN  VARCHAR2 := FND_API.G_FALSE,
      p_validation_level  	IN  NUMBER := FND_API.G_VALID_LEVEL_FULL,
      x_return_status     	OUT NOCOPY  VARCHAR2,
      x_msg_count         	OUT NOCOPY  NUMBER,
      x_msg_data          	OUT NOCOPY  VARCHAR2,
      p_check_login_user 	IN  VARCHAR2 := FND_API.G_TRUE,
      p_channel_record    	IN  AMV_CHANNEL_OBJ_TYPE
)
IS
l_api_name         	CONSTANT VARCHAR2(30) := 'Update_Channel';

Line: 2195


l_update_channel_flag   	varchar2(1);

Line: 2200


select object_version_number
from   amv_c_channels_b
where  channel_id = l_channel_id;

Line: 2206


    SAVEPOINT  Update_Channel_PVT;

Line: 2293


		l_update_channel_flag := FND_API.G_TRUE;

Line: 2295


		IF (AMV_UTILITY_PVT.Get_UpdateChannelStatus(
								l_channel_id,
								l_resource_id,
								AMV_UTILITY_PVT.G_USER) )
		THEN
			l_update_channel_flag := FND_API.G_TRUE;

Line: 2326


    IF l_update_channel_flag = FND_API.G_TRUE THEN
	-- Get the current channel record
	Get_ChannelRecord(l_channel_id, l_channel_obj);

Line: 2491


    	   -- Update channel name if different
      	   IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
     	    	IF l_channel_exist_flag = FND_API.G_FALSE THEN
	     	  -- set channel name to new value only if it does not exist
	     	  l_channel_obj.channel_name := p_channel_record.channel_name;

Line: 2522


	 -- Update channel record
	 BEGIN
	  AMV_C_CHANNELS_PKG.UPDATE_ROW(
	   x_channel_id => l_channel_id,
	   x_object_version_number => l_object_version_number + 1,
	   x_channel_type => l_channel_obj.channel_type,
	   x_channel_category_id => l_channel_obj.channel_category_id,
	   x_status => l_channel_obj.status,
	   x_owner_user_id => l_channel_obj.owner_user_id,
	   x_default_approver_user_id =>l_channel_obj.default_approver_user_id,
	   x_effective_start_date => l_channel_obj.effective_start_date,
	   x_expiration_date => l_channel_obj.expiration_date,
	   x_access_level_type => l_channel_obj.access_level_type,
	   x_pub_need_approval_flag => l_channel_obj.pub_need_approval_flag,
	   x_sub_need_approval_flag => l_channel_obj.sub_need_approval_flag,
	   x_match_on_all_criteria_flag=>l_channel_obj.match_on_all_criteria_flag,
	   x_match_on_keyword_flag => l_channel_obj.match_on_keyword_flag,
	   x_match_on_author_flag => l_channel_obj.match_on_author_flag,
	   x_match_on_perspective_flag => l_channel_obj.match_on_perspective_flag,
	   x_match_on_item_type_flag => l_channel_obj.match_on_item_type_flag,
	   x_match_on_content_type_flag=>l_channel_obj.match_on_content_type_flag,
	   x_match_on_time_flag => l_channel_obj.match_on_time_flag,
	   x_application_id => l_channel_obj.application_id,
	   x_external_access_flag => l_channel_obj.external_access_flag,
	   x_item_match_count => l_channel_obj.item_match_count,
	   x_last_match_time => l_channel_obj.last_match_time,
	   x_notification_interval_type=>l_channel_obj.notification_interval_type,
	   x_last_notification_time => l_channel_obj.last_notification_time,
	   x_attribute_category => l_channel_obj.attribute_category,
	   x_attribute1 => l_channel_obj.attribute1,
	   x_attribute2 => l_channel_obj.attribute2,
	   x_attribute3 => l_channel_obj.attribute3,
	   x_attribute4 => l_channel_obj.attribute4,
	   x_attribute5 => l_channel_obj.attribute5,
	   x_attribute6 => l_channel_obj.attribute6,
	   x_attribute7 => l_channel_obj.attribute7,
	   x_attribute8 => l_channel_obj.attribute8,
	   x_attribute9 => l_channel_obj.attribute9,
	   x_attribute10 => l_channel_obj.attribute10,
	   x_attribute11 => l_channel_obj.attribute11,
	   x_attribute12 => l_channel_obj.attribute12,
	   x_attribute13 => l_channel_obj.attribute13,
	   x_attribute14 => l_channel_obj.attribute14,
	   x_attribute15 => l_channel_obj.attribute15,
 	   x_last_update_date => sysdate,
	   x_last_updated_by => l_user_id,
	   x_last_update_login => l_login_user_id,
	   x_channel_name => l_channel_obj.channel_name,
	   x_description => l_channel_obj.description
	  );

Line: 2633


       ROLLBACK TO  Update_Channel_PVT;

Line: 2642


       ROLLBACK TO  Update_Channel_PVT;

Line: 2651


       ROLLBACK TO  Update_Channel_PVT;

Line: 2664


END Update_Channel;

Line: 2909


l_update_channel_flag 	Varchar2(1);

Line: 2913


select amv_c_content_types_s.nextval
from dual;

Line: 3002


		l_update_channel_flag := FND_API.G_TRUE;

Line: 3004


		IF (AMV_UTILITY_PVT.Get_UpdateChannelStatus(
								l_channel_id,
								l_resource_id,
								AMV_UTILITY_PVT.G_USER) )
		THEN
			l_update_channel_flag := FND_API.G_TRUE;

Line: 3035


    IF l_update_channel_flag = FND_API.G_TRUE THEN

	-- remove old categories for the channel
	DELETE FROM amv_c_content_types
	WHERE channel_id = l_channel_id;

Line: 3043


		UPDATE 	amv_c_channels_b
		set	match_on_content_type_flag = FND_API.G_TRUE
		where 	channel_id = l_channel_id;

Line: 3047


		UPDATE 	amv_c_channels_b
		set	match_on_content_type_flag = FND_API.G_FALSE
		where 	channel_id = l_channel_id;

Line: 3054


		UPDATE 	amv_c_channels_b
		set	match_on_all_criteria_flag = FND_API.G_TRUE
		where 	channel_id = l_channel_id;

Line: 3058


		UPDATE 	amv_c_channels_b
		set	match_on_all_criteria_flag = FND_API.G_FALSE
		where 	channel_id = l_channel_id;

Line: 3063


	-- insert the new category id's for the channel
	FOR i in 1..p_content_type_id_array.count LOOP

	OPEN C_ChanContentType_Seq;

Line: 3070


	INSERT INTO amv_c_content_types
	(
		channel_content_type_id,
		object_version_number,
		last_update_date,
		last_updated_by,
		creation_date,
		created_by,
		last_update_login,
		channel_id,
		content_type_id
	)
	VALUES (
		l_chl_content_type_id,
		l_object_version_number,
		sysdate,
		l_user_id,
		sysdate,
		l_user_id,
		l_login_user_id,
		l_channel_id,
		p_content_type_id_array(i)
	);

Line: 3216


select content_type_id
from   amv_c_content_types
where  channel_id = l_channel_id;

Line: 3413


l_update_channel_flag 	Varchar2(1);

Line: 3417


select amv_c_chl_perspectives_s.nextval
from dual;

Line: 3506


		l_update_channel_flag := FND_API.G_TRUE;

Line: 3508


		IF (AMV_UTILITY_PVT.Get_UpdateChannelStatus(
								l_channel_id,
								l_resource_id,
								AMV_UTILITY_PVT.G_USER) )
		THEN
			l_update_channel_flag := FND_API.G_TRUE;

Line: 3539


    IF l_update_channel_flag = FND_API.G_TRUE THEN
	-- remove old perspectives for the channel
	DELETE FROM amv_c_chl_perspectives
	WHERE channel_id = l_channel_id;

Line: 3546


		UPDATE 	amv_c_channels_b
		set	match_on_perspective_flag = FND_API.G_TRUE
		where 	channel_id = l_channel_id;

Line: 3550


		UPDATE 	amv_c_channels_b
		set	match_on_perspective_flag = FND_API.G_FALSE
		where 	channel_id = l_channel_id;

Line: 3557


		UPDATE 	amv_c_channels_b
		set	match_on_all_criteria_flag = FND_API.G_TRUE
		where 	channel_id = l_channel_id;

Line: 3561


		UPDATE 	amv_c_channels_b
		set	match_on_all_criteria_flag = FND_API.G_FALSE
		where 	channel_id = l_channel_id;

Line: 3566


	-- insert the new perspectives id's for the channel
	FOR i in 1..p_perspective_id_array.count LOOP

	OPEN C_ChanPerspective_Seq;

Line: 3573


	INSERT INTO amv_c_chl_perspectives
	(
		channel_perspective_id,
		object_version_number,
		last_update_date,
		last_updated_by,
		creation_date,
		created_by,
		last_update_login,
		channel_id,
		perspective_id
	)
	VALUES (
		l_chl_perspective_id,
		l_object_version_number,
		sysdate,
		l_user_id,
		sysdate,
		l_user_id,
		l_login_user_id,
		l_channel_id,
		p_perspective_id_array(i)
	);

Line: 3719


select perspective_id
from   amv_c_chl_perspectives
where  channel_id = l_channel_id;

Line: 3916


l_update_channel_flag 	Varchar2(1);

Line: 3920


select amv_c_item_types_s.nextval
from dual;

Line: 4009


		l_update_channel_flag := FND_API.G_TRUE;

Line: 4011


		IF (AMV_UTILITY_PVT.Get_UpdateChannelStatus(
								l_channel_id,
								l_resource_id,
								AMV_UTILITY_PVT.G_USER) )
		THEN
			l_update_channel_flag := FND_API.G_TRUE;

Line: 4042


    IF l_update_channel_flag = FND_API.G_TRUE THEN
	-- remove old groups for the channel
	DELETE FROM amv_c_item_types
	WHERE channel_id = l_channel_id;

Line: 4049


		UPDATE 	amv_c_channels_b
		set	match_on_item_type_flag = FND_API.G_TRUE
		where 	channel_id = l_channel_id;

Line: 4053


		UPDATE 	amv_c_channels_b
		set	match_on_item_type_flag = FND_API.G_FALSE
		where 	channel_id = l_channel_id;

Line: 4060


		UPDATE 	amv_c_channels_b
		set	match_on_all_criteria_flag = FND_API.G_TRUE
		where 	channel_id = l_channel_id;

Line: 4064


		UPDATE 	amv_c_channels_b
		set	match_on_all_criteria_flag = FND_API.G_FALSE
		where 	channel_id = l_channel_id;

Line: 4069


	-- insert the new groups id's for the channel
	FOR i in 1..p_item_type_array.count LOOP
	OPEN C_ChanItemType_Seq;

Line: 4075


	INSERT INTO amv_c_item_types
	(
		channel_item_type_id,
		object_version_number,
		last_update_date,
		last_updated_by,
		creation_date,
		created_by,
		last_update_login,
		channel_id,
		item_type
	)
	VALUES (
		l_item_type_id,
		l_object_version_number,
		sysdate,
		l_user_id,
		sysdate,
		l_user_id,
		l_login_user_id,
		l_channel_id,
		p_item_type_array(i)
	);

Line: 4221


select item_type
from   amv_c_item_types
where  channel_id = l_channel_id;

Line: 4418


l_update_channel_flag 	Varchar2(1);

Line: 4422


select amv_c_keywords_s.nextval
from dual;

Line: 4512


		l_update_channel_flag := FND_API.G_TRUE;

Line: 4514


		IF (AMV_UTILITY_PVT.Get_UpdateChannelStatus(
								l_channel_id,
								l_resource_id,
								AMV_UTILITY_PVT.G_USER) )
		THEN
			l_update_channel_flag := FND_API.G_TRUE;

Line: 4545


    IF l_update_channel_flag = FND_API.G_TRUE THEN
	-- remove old keywords for the channel
	DELETE FROM amv_c_keywords
	WHERE channel_id = l_channel_id;

Line: 4552


		UPDATE 	amv_c_channels_b
		set	match_on_keyword_flag = FND_API.G_TRUE
		where 	channel_id = l_channel_id;

Line: 4556


		UPDATE 	amv_c_channels_b
		set	match_on_keyword_flag = FND_API.G_FALSE
		where 	channel_id = l_channel_id;

Line: 4563


		UPDATE 	amv_c_channels_b
		set	match_on_all_criteria_flag = FND_API.G_TRUE
		where 	channel_id = l_channel_id;

Line: 4567


		UPDATE 	amv_c_channels_b
		set	match_on_all_criteria_flag = FND_API.G_FALSE
		where 	channel_id = l_channel_id;

Line: 4572


	-- insert new keywords for the channel
	FOR i in 1..p_keywords_array.count LOOP
	OPEN C_ChanKeywordId_Seq;

Line: 4577


	INSERT INTO amv_c_keywords
	(
		channel_keyword_id,
		object_version_number,
		last_update_date,
		last_updated_by,
		creation_date,
		created_by,
		last_update_login,
		channel_id,
		keyword
	)
	VALUES (
		l_keyword_id,
		l_object_version_number,
		sysdate,
		l_user_id,
		sysdate,
		l_user_id,
		l_login_user_id,
		l_channel_id,
		initcap(p_keywords_array(i))
	);

Line: 4724


select keyword
from   amv_c_keywords
where  channel_id = l_channel_id;

Line: 4920


l_update_channel_flag 	Varchar2(1);

Line: 4925


select amv_c_authors_s.nextval
from dual;

Line: 5015


		l_update_channel_flag := FND_API.G_TRUE;

Line: 5017


		IF (AMV_UTILITY_PVT.Get_UpdateChannelStatus(
								l_channel_id,
								l_resource_id,
								AMV_UTILITY_PVT.G_USER) )
		THEN
			l_update_channel_flag := FND_API.G_TRUE;

Line: 5048


    IF l_update_channel_flag = FND_API.G_TRUE THEN
	-- remove old authors for the channel
	DELETE FROM amv_c_authors
	WHERE channel_id = l_channel_id;

Line: 5055


		UPDATE 	amv_c_channels_b
		set	match_on_author_flag = FND_API.G_TRUE
		where 	channel_id = l_channel_id;

Line: 5059


		UPDATE 	amv_c_channels_b
		set	match_on_author_flag = FND_API.G_FALSE
		where 	channel_id = l_channel_id;

Line: 5066


		UPDATE 	amv_c_channels_b
		set	match_on_all_criteria_flag = FND_API.G_TRUE
		where 	channel_id = l_channel_id;

Line: 5070


		UPDATE 	amv_c_channels_b
		set	match_on_all_criteria_flag = FND_API.G_FALSE
		where 	channel_id = l_channel_id;

Line: 5075


	-- insert the new authors for the channel
	FOR i in 1..p_authors_array.count LOOP
	OPEN C_ChanAuthorId_Seq;

Line: 5080


	INSERT INTO amv_c_authors
	(
		channel_author_id,
		object_version_number,
		last_update_date,
		last_updated_by,
		creation_date,
		created_by,
		last_update_login,
		channel_id,
		author
	)
	VALUES (
		l_author_id,
		l_object_version_number,
		sysdate,
		l_user_id,
		sysdate,
		l_user_id,
		l_login_user_id,
		l_channel_id,
		initcap(p_authors_array(i))
	);

Line: 5226


select author
from   amv_c_authors
where  channel_id = l_channel_id;

Line: 5434


select count(cim.item_id)
from   amv_c_chl_item_match cim
,      jtf_amv_items_vl ib
where  cim.channel_id = p_channel_id
and    cim.approval_status_type = p_item_status
and    cim.table_name_code = AMV_UTILITY_PVT.G_TABLE_NAME_CODE
and    cim.available_for_channel_date <= sysdate
and    cim.item_id = ib.item_id;

Line: 5444


select ib.item_id
from   amv_c_chl_item_match cim
,      jtf_amv_items_vl ib
where  cim.channel_id = p_channel_id
and    cim.approval_status_type = p_item_status
and    cim.table_name_code = AMV_UTILITY_PVT.G_TABLE_NAME_CODE
and    cim.item_id = ib.item_id
order by ib.effective_start_date;

Line: 5454


select count(cim.item_id)
from   amv_c_chl_item_match cim
,      jtf_amv_items_vl ib
where  cim.channel_id = p_channel_id
and    cim.approval_status_type = p_item_status
and    cim.table_name_code = AMV_UTILITY_PVT.G_TABLE_NAME_CODE
and    cim.available_for_channel_date <= sysdate
and    cim.item_id = ib.item_id
and    nvl(ib.effective_start_date, sysdate) <= sysdate + 1
and    nvl(ib.expiration_date, sysdate) >= sysdate;

Line: 5466


select ib.item_id
from   amv_c_chl_item_match cim
,      jtf_amv_items_vl ib
where  cim.channel_id = p_channel_id
and    cim.approval_status_type = p_item_status
and    cim.table_name_code = AMV_UTILITY_PVT.G_TABLE_NAME_CODE
and    cim.available_for_channel_date <= sysdate
and    cim.item_id = ib.item_id
and    nvl(ib.effective_start_date, sysdate) <= sysdate + 1
and    nvl(ib.expiration_date, sysdate) >= sysdate
order by ib.effective_start_date desc;

Line: 5808


	UPDATE 	amv_c_chl_item_match
	SET	approval_status_type = p_approval_status
	,	approval_date = sysdate
	,	last_update_date = sysdate
	,	last_updated_by = l_user_id
	,	last_update_login = l_login_user_id
	WHERE	channel_id = l_channel_id
	AND	item_id = p_item_id;

Line: 6025


    l_sql_statement := 	'SELECT b.channel_id, ' ||
			'	b.object_version_number, ' ||
			'	tl.channel_name, ' ||
			'	tl.description, ' ||
			'	b.channel_type, ' ||
			'	b.channel_category_id, ' ||
			'	b.status, ' ||
			'	b.owner_user_id, ' ||
			'	b.default_approver_user_id, ' ||
			'	b.effective_start_date, ' ||
			'	b.expiration_date, ' ||
			'	b.access_level_type, ' ||
			'	b.pub_need_approval_flag, ' ||
			'	b.sub_need_approval_flag, ' ||
			'	b.match_on_all_criteria_flag, ' ||
			'	b.match_on_keyword_flag, ' ||
			'	b.match_on_author_flag, ' ||
			'	b.match_on_perspective_flag, ' ||
			'	b.match_on_item_type_flag, ' ||
			'	b.match_on_content_type_flag, ' ||
			'	b.match_on_time_flag, ' ||
			'	b.application_id, ' ||
			'	b.external_access_flag, ' ||
			'	b.item_match_count, ' ||
			'	b.last_match_time, ' ||
			'	b.notification_interval_type, ' ||
			'	b.last_notification_time ' ||
			'FROM 	amv_c_channels_b b  ' ||
			',    	amv_c_channels_tl tl ';

Line: 6055


    l_sql_statement2 := 'Select count(*) ' ||
			'FROM 	amv_c_channels_b b  ' ||
			',    	amv_c_channels_tl tl ';