The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE update_location(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
p_loc_rec IN blk_rec_type,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2)
AS
l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
OKL_BLK_AST_UPD_PVT.update_location( p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
p_loc_rec => p_loc_rec,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data);
FND_MSG_PUB.ADD_EXC_MSG('OKL_BLK_AST_UPD_PUB','Update_Location');
END update_location;
PROCEDURE update_location(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
p_loc_tbl IN blk_tbl_type,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2)
AS
l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
OKL_BLK_AST_UPD_PVT.update_location( p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
p_loc_tbl => p_loc_tbl,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data);
FND_MSG_PUB.ADD_EXC_MSG('OKL_BLK_AST_UPD_PUB','Update_Location');
END update_location;