APPS.OKL_ARTICLE_PUB SQL Statements

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

Line: 19

      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: 116

      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: 440

PROCEDURE delete_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_cat_id			     IN  NUMBER
  ) AS

    l_api_name	VARCHAR2(30) := 'delete_article';

Line: 481

    OKC_K_ARTICLE_PUB.delete_k_article(
         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);