The following lines contain the word 'select', 'insert', 'update' or 'delete':
l_saev_rec.last_updated_by := p_saev_rec1.last_updated_by;
l_saev_rec.last_update_date := p_saev_rec1.last_update_date;
l_saev_rec.last_update_login := p_saev_rec1.last_update_login;
l_sacv_rec.last_updated_by := p_sacv_rec1.last_updated_by;
l_sacv_rec.last_update_date := p_sacv_rec1.last_update_date;
l_sacv_rec.last_update_login := p_sacv_rec1.last_update_login;
l_saiv_rec.last_updated_by := p_saiv_rec1.last_updated_by;
l_saiv_rec.last_update_date := p_saiv_rec1.last_update_date;
l_saiv_rec.last_update_login := p_saiv_rec1.last_update_login;
l_savv_rec.last_updated_by := p_savv_rec1.last_updated_by;
l_savv_rec.last_update_date := p_savv_rec1.last_update_date;
l_savv_rec.last_update_login := p_savv_rec1.last_update_login;
l_samv_rec.last_updated_by := p_samv_rec1.last_updated_by;
l_samv_rec.last_update_date := p_samv_rec1.last_update_date;
l_samv_rec.last_update_login := p_samv_rec1.last_update_login;
PROCEDURE Update_std_article(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_saev_rec IN saev_rec_type,
p_savv_tbl IN savv_tbl_type,
p_saiv_tbl IN saiv_tbl_type,
p_samv_tbl IN samv_tbl_type,
x_saev_rec OUT NOCOPY saev_rec_type,
x_savv_tbl OUT NOCOPY savv_tbl_type,
x_saiv_tbl OUT NOCOPY saiv_tbl_type,
x_samv_tbl OUT NOCOPY samv_tbl_type) IS
BEGIN
x_return_status := OKC_API.G_RET_STS_SUCCESS;
OKC_STD_ARTICLE_PVT.update_std_article(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_saev_rec => p_saev_rec,
p_savv_tbl => p_savv_tbl,
p_saiv_tbl => p_saiv_tbl,
p_samv_tbl => p_samv_tbl,
x_saev_rec => x_saev_rec,
x_savv_tbl => x_savv_tbl,
x_saiv_tbl => x_saiv_tbl,
x_samv_tbl => x_samv_tbl);
END Update_std_article;
PROCEDURE update_std_article(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_saev_rec IN saev_rec_type,
x_saev_rec OUT NOCOPY saev_rec_type) IS
l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_STD_ARTICLE';
OKC_STD_ARTICLE_PVT.update_std_article(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_saev_rec => l_saev_rec,
x_saev_rec => x_saev_rec);
END update_std_article;
PROCEDURE update_std_article(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_saev_tbl IN saev_tbl_type,
x_saev_tbl OUT NOCOPY saev_tbl_type) IS
i NUMBER := 0;
update_std_article(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_saev_rec => p_saev_tbl(i),
x_saev_rec => x_saev_tbl(i));
END update_std_article;
PROCEDURE delete_std_article(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_saev_rec IN saev_rec_type) IS
l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
l_api_name CONSTANT VARCHAR2(30) := 'DELETE_STD_ARTICLE';
OKC_STD_ARTICLE_PVT.delete_std_article(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_saev_rec => l_saev_rec);
END delete_std_article;
PROCEDURE delete_std_article(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_saev_tbl IN saev_tbl_type) IS
i NUMBER := 0;
delete_std_article(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_saev_rec => p_saev_tbl(i));
END delete_std_article;
PROCEDURE update_std_art_version(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_savv_rec IN savv_rec_type,
x_savv_rec OUT NOCOPY savv_rec_type) IS
l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_STD_ART_VERSION';
OKC_STD_ARTICLE_PVT.update_std_art_version(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_savv_rec => l_savv_rec,
x_savv_rec => x_savv_rec);
END update_std_art_version;
PROCEDURE update_std_art_version(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_savv_tbl IN savv_tbl_type,
x_savv_tbl OUT NOCOPY savv_tbl_type) IS
i NUMBER := 0;
update_std_art_version(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_savv_rec => p_savv_tbl(i),
x_savv_rec => x_savv_tbl(i));
END update_std_art_version;
PROCEDURE delete_std_art_version(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_savv_rec IN savv_rec_type) IS
l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
l_api_name CONSTANT VARCHAR2(30) := 'DELETE_STD_ART_VERSION';
OKC_STD_ARTICLE_PVT.delete_std_art_version(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_savv_rec => l_savv_rec);
END delete_std_art_version;
PROCEDURE delete_std_art_version(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_savv_tbl IN savv_tbl_type) IS
i NUMBER := 0;
delete_std_art_version(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_savv_rec => p_savv_tbl(i));
END delete_std_art_version;
PROCEDURE update_std_art_incmpt(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_saiv_rec IN saiv_rec_type,
x_saiv_rec OUT NOCOPY saiv_rec_type) IS
l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_STD_ART_INCMPT';
OKC_STD_ARTICLE_PVT.update_std_art_incmpt(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_saiv_rec => l_saiv_rec,
x_saiv_rec => x_saiv_rec);
END update_std_art_incmpt;
PROCEDURE update_std_art_incmpt(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_saiv_tbl IN saiv_tbl_type,
x_saiv_tbl OUT NOCOPY saiv_tbl_type) IS
i NUMBER := 0;
update_std_art_incmpt(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_saiv_rec => p_saiv_tbl(i),
x_saiv_rec => x_saiv_tbl(i));
END update_std_art_incmpt;
PROCEDURE delete_std_art_incmpt(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_saiv_rec IN saiv_rec_type) IS
l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
l_api_name CONSTANT VARCHAR2(30) := 'DELETE_STD_ART_INCMPT';
OKC_STD_ARTICLE_PVT.delete_std_art_incmpt(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_saiv_rec => l_saiv_rec);
END delete_std_art_incmpt;
PROCEDURE delete_std_art_incmpt(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_saiv_tbl IN saiv_tbl_type) IS
i NUMBER := 0;
delete_std_art_incmpt(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_saiv_rec => p_saiv_tbl(i));
END delete_std_art_incmpt;
PROCEDURE update_std_art_classing(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_sacv_rec IN sacv_rec_type,
x_sacv_rec OUT NOCOPY sacv_rec_type) IS
l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_STD_ART_CLASSING';
OKC_STD_ARTICLE_PVT.update_std_art_classing(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_sacv_rec => l_sacv_rec,
x_sacv_rec => x_sacv_rec);
END update_std_art_classing;
PROCEDURE update_std_art_classing(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_sacv_tbl IN sacv_tbl_type,
x_sacv_tbl OUT NOCOPY sacv_tbl_type) IS
i NUMBER := 0;
update_std_art_classing(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_sacv_rec => p_sacv_tbl(i),
x_sacv_rec => x_sacv_tbl(i));
END update_std_art_classing;
PROCEDURE delete_std_art_classing(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_sacv_rec IN sacv_rec_type) IS
l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
l_api_name CONSTANT VARCHAR2(30) := 'DELETE_STD_ART_CLASSING';
OKC_STD_ARTICLE_PVT.delete_std_art_classing(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_sacv_rec => l_sacv_rec);
END delete_std_art_classing;
PROCEDURE delete_std_art_classing(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_sacv_tbl IN sacv_tbl_type) IS
i NUMBER := 0;
delete_std_art_classing(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_sacv_rec => p_sacv_tbl(i));
END delete_std_art_classing;
PROCEDURE update_std_art_set_mem(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_samv_rec IN samv_rec_type,
x_samv_rec OUT NOCOPY samv_rec_type) IS
l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_STD_ART_SET_MEM';
OKC_STD_ARTICLE_PVT.update_std_art_set_mem(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_samv_rec => l_samv_rec,
x_samv_rec => x_samv_rec);
END update_std_art_set_mem;
PROCEDURE update_std_art_set_mem(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_samv_tbl IN samv_tbl_type,
x_samv_tbl OUT NOCOPY samv_tbl_type) IS
i NUMBER := 0;
update_std_art_set_mem(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_samv_rec => p_samv_tbl(i),
x_samv_rec => x_samv_tbl(i));
END update_std_art_set_mem;
PROCEDURE delete_std_art_set_mem(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_samv_rec IN samv_rec_type) IS
l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
l_api_name CONSTANT VARCHAR2(30) := 'DELETE_STD_ART_SET_MEM';
OKC_STD_ARTICLE_PVT.delete_std_art_set_mem(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_samv_rec => l_samv_rec);
END delete_std_art_set_mem;
PROCEDURE delete_std_art_set_mem(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_samv_tbl IN samv_tbl_type) IS
i NUMBER := 0;
delete_std_art_set_mem(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_samv_rec => p_samv_tbl(i));
END delete_std_art_set_mem;