APPS.AMV_CHANNEL_GRP SQL Statements

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

Line: 327

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  varchar2(30) := 'Delete_Channel';

Line: 344

	AMV_CHANNEL_PVT.Delete_Channel
	    (p_api_version       =>  p_api_version,
      	p_init_msg_list     =>  p_init_msg_list,
      	p_commit            =>  p_commit,
     	p_validation_level  =>  p_validation_level,
      	x_return_status     =>  x_return_status,
      	x_msg_count         =>  x_msg_count,
      	x_msg_data          =>  x_msg_data,
      	p_check_login_user 	=>  p_check_login_user,
      	p_channel_id        =>  p_channel_id,
		p_channel_name		=>  p_channel_name,
		p_category_id		=>  p_category_id
		);

Line: 371

END Delete_Channel;

Line: 399

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_PVT.AMV_CHANNEL_OBJ_TYPE
)
IS
l_api_name  varchar2(30) := 'Update_Channel';

Line: 414

	AMV_CHANNEL_PVT.Update_Channel
	    (p_api_version       =>  p_api_version,
      	p_init_msg_list     =>  p_init_msg_list,
      	p_commit            =>  p_commit,
     	p_validation_level  =>  p_validation_level,
      	x_return_status     =>  x_return_status,
      	x_msg_count         =>  x_msg_count,
      	x_msg_data          =>  x_msg_data,
      	p_check_login_user 	=>  p_check_login_user,
      	p_channel_record    =>  p_channel_record
		);

Line: 439

END Update_Channel;