APPS.OKL_VP_K_ARTICLE_PVT SQL Statements

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

Line: 24

      SELECT	ID,
		CHR_ID,
		CLE_ID,
		CAT_ID,
		SFWT_FLAG,
		SAV_SAE_ID,
		SAV_SAV_RELEASE,
		SBT_CODE,
		DNZ_CHR_ID,
		COMMENTS,
		FULLTEXT_YN,
		VARIATION_DESCRIPTION,
		NAME,
--		TEXT,
		ATTRIBUTE_CATEGORY,
		ATTRIBUTE1,
		ATTRIBUTE2,
		ATTRIBUTE3,
		ATTRIBUTE4,
		ATTRIBUTE5,
		ATTRIBUTE6,
		ATTRIBUTE7,
		ATTRIBUTE8,
		ATTRIBUTE9,
		ATTRIBUTE10,
		ATTRIBUTE11,
		ATTRIBUTE12,
		ATTRIBUTE13,
		ATTRIBUTE14,
		ATTRIBUTE15,
		CAT_TYPE
	FROM    OKC_K_ARTICLES_V
	WHERE 	ID = p_cat_id;

Line: 117

      SELECT null,
		null,
		null,
		null,
		OKC_API.G_TRUE,
		null,
		null,
		sae.SBT_CODE,
		null,
		null,
		'Y',
		null,
		sae.NAME,
--		saev.TEXT,
		null,
		null,
		null,
		null,
		null,
		null,
		null,
		null,
		null,
		null,
		null,
		null,
		null,
		null,
		null,
		null,
		'NSD'
	FROM    okc_std_art_versions_v  saev
      ,       okc_std_articles_v      sae
	WHERE   sae.ID = p_sae_id
      AND     saev.sav_release = p_sav_release
      AND     sae.ID = saev.sae_id;

Line: 272

    OKL_OKC_MIGRATION_A_PVT.insert_row(
         p_api_version     => l_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_catv_rec        => l_catv_rec,
         x_catv_rec        => x_catv_rec);

Line: 342

SELECT text
FROM okc_std_art_versions_v
WHERE sae_id = p_sae_id
AND sav_release = p_sae_release;

Line: 389

    OKL_OKC_MIGRATION_A_PVT.insert_row(
         p_api_version     => l_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_catv_rec        => l_catv_rec,
         x_catv_rec        => x_catv_rec);

Line: 605

procedure update_k_article(p_api_version	IN	NUMBER,
                              p_init_msg_list	IN	VARCHAR2 default OKC_API.G_FALSE,
                              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: 624

  okl_okc_migration_a_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: 645

end update_k_article;

Line: 656

procedure delete_k_article(p_api_version	IN	NUMBER,
                              p_init_msg_list	IN	VARCHAR2 default OKC_API.G_FALSE,
                              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_return_status     VARCHAR2(1)  := OKC_API.G_RET_STS_SUCCESS;

Line: 667

     SELECT dnz_chr_id
     FROM   okc_k_articles_v
     WHERE  id = p_catv_rec.id;

Line: 679

  okl_okc_migration_a_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: 701

END delete_k_article;