APPS.OKC_K_ARTICLE_PVT SQL Statements

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

Line: 46

  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
  ;

Line: 75

  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);

Line: 87

  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);

Line: 129

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;

Line: 141

  select dnz_chr_id
  from OKC_K_ARTICLES_B
  where id = p_catv_rec.id;

Line: 155

  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);

Line: 169

  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);

Line: 178

end update_k_article;

Line: 188

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);

Line: 201

  select '!'
  from OKC_K_ARTICLES_B
  where cat_id = p_catv_rec.id;

Line: 205

    SELECT '!'
	FROM Okc_Article_Trans_V
     	WHERE cat_id = p_catv_rec.id;

Line: 212

  select dnz_chr_id
  from OKC_K_ARTICLES_B
  where id = p_catv_rec.id;

Line: 218

  select id
  from OKC_SECTION_CONTENTS
  where cat_id = p_catv_rec.id;

Line: 262

  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);

Line: 278

           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);

Line: 287

  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);

Line: 296

end delete_k_article;

Line: 341

  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);

Line: 353

  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);

Line: 395

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;

Line: 405

  select dnz_chr_id
  from OKC_ARTICLE_TRANS_V
  where id = p_atnv_rec.id;

Line: 419

  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);

Line: 429

  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);

Line: 438

end delete_article_translation;