APPS.AMV_CATEGORY_GRP SQL Statements

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

Line: 139

PROCEDURE Delete_Category
(     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_application_id		IN  NUMBER,
      p_category_id          	IN  NUMBER := FND_API.G_MISS_NUM,
      p_category_name        	IN  VARCHAR2 := FND_API.G_MISS_CHAR,
      p_parent_category_id   	IN  NUMBER := FND_API.G_MISS_NUM
)
IS
l_api_name varchar2(30) := 'Delete_Category';

Line: 157

	AMV_CATEGORY_PVT.Delete_Category
	(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_application_id => p_application_id,
      p_category_id => p_category_id,
      p_category_name => p_category_name,
      p_parent_category_id => p_parent_category_id
	);

Line: 184

END Delete_Category;

Line: 375

PROCEDURE Update_Category
(     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_object_version_number   IN  NUMBER,
	 p_application_id		IN  NUMBER,
      p_category_id          	IN  NUMBER := FND_API.G_MISS_NUM,
      p_category_name 	     	IN  VARCHAR2 := FND_API.G_MISS_CHAR,
      p_parent_category_id   	IN  NUMBER := FND_API.G_MISS_NUM,
      p_category_order		IN  NUMBER := FND_API.G_MISS_NUM,
      p_category_new_name    	IN  VARCHAR2 := FND_API.G_MISS_CHAR,
      p_description 	     	IN  VARCHAR2 := FND_API.G_MISS_CHAR
)
IS
l_api_name varchar2(30) := 'Update_Category';

Line: 396

	AMV_CATEGORY_PVT.Update_Category
	(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_object_version_number => p_object_version_number,
      p_application_id => p_application_id,
      p_category_id => p_category_id,
      p_category_name => p_category_name,
      p_parent_category_id => p_parent_category_id,
      p_category_order => p_category_order,
      p_category_new_name => p_category_new_name,
      p_description => p_description
	);

Line: 428

END Update_Category;