The following lines contain the word 'select', 'insert', 'update' or 'delete':
select STA.NAME
from OKC_K_ARTICLES_B CAT,
OKC_STD_ARTICLES_V STA
where CAT.chr_id = p_catv_rec.chr_id
and CAT.sav_sae_id = p_catv_rec.sav_sae_id
and STA.ID = CAT.sav_sae_id
;
okc_cat_pvt.insert_row(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
x_return_status => x_return_status,
p_catv_rec => l_catv_rec,
x_catv_rec => x_catv_rec);
OKC_CVM_PVT.update_contract_version(
p_api_version => p_api_version,
p_init_msg_list => OKC_API.G_FALSE,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_cvmv_rec => l_cvmv_rec,
x_cvmv_rec => x_out_rec);
procedure update_k_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_catv_rec IN catv_rec_type,
x_catv_rec OUT NOCOPY catv_rec_type) is
l_catv_rec catv_rec_type := p_catv_rec;
select dnz_chr_id
from OKC_K_ARTICLES_B
where id = p_catv_rec.id;
okc_cat_pvt.update_row(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
x_return_status => x_return_status,
p_catv_rec => l_catv_rec,
x_catv_rec => x_catv_rec);
OKC_CVM_PVT.update_contract_version(
p_api_version => p_api_version,
p_init_msg_list => OKC_API.G_FALSE,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_cvmv_rec => l_cvmv_rec,
x_cvmv_rec => x_out_rec);
end update_k_article;
procedure delete_k_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_catv_rec IN catv_rec_type) is
l_dummy varchar2(1);
select '!'
from OKC_K_ARTICLES_B
where cat_id = p_catv_rec.id;
SELECT '!'
FROM Okc_Article_Trans_V
WHERE cat_id = p_catv_rec.id;
select dnz_chr_id
from OKC_K_ARTICLES_B
where id = p_catv_rec.id;
select id
from OKC_SECTION_CONTENTS
where cat_id = p_catv_rec.id;
okc_cat_pvt.delete_row(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
x_return_status => x_return_status,
p_catv_rec => p_catv_rec);
OKC_SECTIONS_PUB.delete_section_content(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
x_return_status => x_return_status,
p_sccv_rec => l_sccv_rec);
OKC_CVM_PVT.update_contract_version(
p_api_version => p_api_version,
p_init_msg_list => OKC_API.G_FALSE,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_cvmv_rec => l_cvmv_rec,
x_cvmv_rec => x_out_rec);
end delete_k_article;
okc_atn_pvt.insert_row(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
x_return_status => x_return_status,
p_atnv_rec => p_atnv_rec,
x_atnv_rec => x_atnv_rec);
OKC_CVM_PVT.update_contract_version(
p_api_version => p_api_version,
p_init_msg_list => OKC_API.G_FALSE,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_cvmv_rec => l_cvmv_rec,
x_cvmv_rec => x_out_rec);
procedure delete_article_translation(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_atnv_rec IN atnv_rec_type) is
--V
l_cvmv_rec OKC_CVM_PVT.cvmv_rec_type;
select dnz_chr_id
from OKC_ARTICLE_TRANS_V
where id = p_atnv_rec.id;
okc_atn_pvt.delete_row(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
x_return_status => x_return_status,
p_atnv_rec => p_atnv_rec);
OKC_CVM_PVT.update_contract_version(
p_api_version => p_api_version,
p_init_msg_list => OKC_API.G_FALSE,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_cvmv_rec => l_cvmv_rec,
x_cvmv_rec => x_out_rec);
end delete_article_translation;