APPS.OKC_CAT_PVT SQL Statements

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

Line: 62

    DELETE FROM OKC_K_ARTICLES_TL T
     WHERE NOT EXISTS (
        SELECT NULL
          FROM OKC_K_ARTICLES_B B
         WHERE B.ID = T.ID
        );

Line: 69

    UPDATE OKC_K_ARTICLES_TL T SET (
        COMMENTS,
        VARIATION_DESCRIPTION,
        NAME,
        TEXT,
        SAV_SAV_RELEASE) = (SELECT
                                  B.COMMENTS,
                                  B.VARIATION_DESCRIPTION,
                                  B.NAME,
                                  B.TEXT,
                                  B.SAV_SAV_RELEASE
                                FROM OKC_K_ARTICLES_TL B
                               WHERE B.ID = T.ID
                                 AND B.LANGUAGE = T.SOURCE_LANG)
      WHERE (
              T.ID,
              T.LANGUAGE)
          IN (SELECT
                  SUBT.ID,
                  SUBT.LANGUAGE
                FROM OKC_K_ARTICLES_TL SUBB, OKC_K_ARTICLES_TL SUBT
               WHERE SUBB.ID = SUBT.ID
                 AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
                 AND (SUBB.COMMENTS <> SUBT.COMMENTS
                      OR SUBB.VARIATION_DESCRIPTION <> SUBT.VARIATION_DESCRIPTION
                      OR SUBB.NAME <> SUBT.NAME
-- Commented in favor of handcode
---                     OR SUBB.TEXT <> SUBT.TEXT
--+Hand code start
                      OR ( (SUBB.TEXT IS NOT NULL AND SUBT.TEXT IS NOT NULL)
				   AND (DBMS_LOB.COMPARE(SUBB.TEXT,SUBT.TEXT) <> 0))
--+Hand code end
                      OR SUBB.SAV_SAV_RELEASE <> SUBT.SAV_SAV_RELEASE
                      OR (SUBB.COMMENTS IS NULL AND SUBT.COMMENTS IS NOT NULL)
                      OR (SUBB.COMMENTS IS NOT NULL AND SUBT.COMMENTS IS NULL)
                      OR (SUBB.VARIATION_DESCRIPTION IS NULL AND SUBT.VARIATION_DESCRIPTION IS NOT NULL)
                      OR (SUBB.VARIATION_DESCRIPTION IS NOT NULL AND SUBT.VARIATION_DESCRIPTION IS NULL)
                      OR (SUBB.NAME IS NULL AND SUBT.NAME IS NOT NULL)
                      OR (SUBB.NAME IS NOT NULL AND SUBT.NAME IS NULL)
                      OR (SUBB.TEXT IS NULL AND SUBT.TEXT IS NOT NULL)
                      OR (SUBB.TEXT IS NOT NULL AND SUBT.TEXT IS NULL)
                      OR (SUBB.SAV_SAV_RELEASE IS NULL AND SUBT.SAV_SAV_RELEASE IS NOT NULL)
                      OR (SUBB.SAV_SAV_RELEASE IS NOT NULL AND SUBT.SAV_SAV_RELEASE IS NULL)
              ));

Line: 114

    INSERT INTO OKC_K_ARTICLES_TL (
        ID,
        LANGUAGE,
        SOURCE_LANG,
        SFWT_FLAG,
        OBJECT_VERSION_NUMBER,
        COMMENTS,
        VARIATION_DESCRIPTION,
        NAME,
        TEXT,
        CREATED_BY,
        CREATION_DATE,
        LAST_UPDATED_BY,
        LAST_UPDATE_DATE,
        LAST_UPDATE_LOGIN,
        SAV_SAV_RELEASE)
      SELECT
            B.ID,
            L.LANGUAGE_CODE,
            B.SOURCE_LANG,
            B.SFWT_FLAG,
            B.OBJECT_VERSION_NUMBER,
            B.COMMENTS,
            B.VARIATION_DESCRIPTION,
            B.NAME,
            B.TEXT,
            B.CREATED_BY,
            B.CREATION_DATE,
            B.LAST_UPDATED_BY,
            B.LAST_UPDATE_DATE,
            B.LAST_UPDATE_LOGIN,
            B.SAV_SAV_RELEASE
        FROM OKC_K_ARTICLES_TL B, FND_LANGUAGES L
       WHERE L.INSTALLED_FLAG IN ('I', 'B')
         AND B.LANGUAGE = USERENV('LANG')
         AND NOT EXISTS(
                    SELECT NULL
                      FROM OKC_K_ARTICLES_TL T
                     WHERE T.ID = B.ID
                       AND T.LANGUAGE = L.LANGUAGE_CODE
                    );

Line: 155

DELETE FROM OKC_K_ARTICLES_TLH T
     WHERE NOT EXISTS (
        SELECT NULL
          FROM OKC_K_ARTICLES_BH B
         WHERE B.ID = T.ID
         AND B.MAJOR_VERSION = T.MAJOR_VERSION
        );

Line: 163

    UPDATE OKC_K_ARTICLES_TLH T SET (
        COMMENTS,
        VARIATION_DESCRIPTION,
        NAME,
        TEXT,
        SAV_SAV_RELEASE) = (SELECT
                                  B.COMMENTS,
                                  B.VARIATION_DESCRIPTION,
                                  B.NAME,
                                  B.TEXT,
                                  B.SAV_SAV_RELEASE
                                FROM OKC_K_ARTICLES_TLH B
                               WHERE B.ID = T.ID
                               AND B.MAJOR_VERSION = T.MAJOR_VERSION
                                 AND B.LANGUAGE = T.SOURCE_LANG)
      WHERE (
              T.ID,
              T.MAJOR_VERSION,
              T.LANGUAGE)
          IN (SELECT
                  SUBT.ID,
                  SUBT.MAJOR_VERSION,
                  SUBT.LANGUAGE
                FROM OKC_K_ARTICLES_TLH SUBB, OKC_K_ARTICLES_TLH SUBT
               WHERE SUBB.ID = SUBT.ID
                 AND SUBB.MAJOR_VERSION = SUBT.MAJOR_VERSION
                 AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
                 AND (SUBB.COMMENTS <> SUBT.COMMENTS
                      OR SUBB.VARIATION_DESCRIPTION <> SUBT.VARIATION_DESCRIPTION
                      OR SUBB.NAME <> SUBT.NAME
   OR ( (SUBB.TEXT IS NOT NULL AND SUBT.TEXT IS NOT NULL)
                                   AND (DBMS_LOB.COMPARE(SUBB.TEXT,SUBT.TEXT) <> 0))
                      OR SUBB.SAV_SAV_RELEASE <> SUBT.SAV_SAV_RELEASE
                      OR (SUBB.COMMENTS IS NULL AND SUBT.COMMENTS IS NOT NULL)
                      OR (SUBB.COMMENTS IS NOT NULL AND SUBT.COMMENTS IS NULL)
                      OR (SUBB.VARIATION_DESCRIPTION IS NULL AND SUBT.VARIATION_DESCRIPTION IS NOT NULL)
                      OR (SUBB.VARIATION_DESCRIPTION IS NOT NULL AND SUBT.VARIATION_DESCRIPTION IS NULL)
                      OR (SUBB.NAME IS NULL AND SUBT.NAME IS NOT NULL)
                      OR (SUBB.NAME IS NOT NULL AND SUBT.NAME IS NULL)
                      OR (SUBB.TEXT IS NULL AND SUBT.TEXT IS NOT NULL)
                      OR (SUBB.TEXT IS NOT NULL AND SUBT.TEXT IS NULL)
                      OR (SUBB.SAV_SAV_RELEASE IS NULL AND SUBT.SAV_SAV_RELEASE IS NOT NULL)
                      OR (SUBB.SAV_SAV_RELEASE IS NOT NULL AND SUBT.SAV_SAV_RELEASE IS NULL)
              ));

Line: 208

    INSERT INTO OKC_K_ARTICLES_TLH (
        ID,
        LANGUAGE,
        MAJOR_VERSION,
        SOURCE_LANG,
        SFWT_FLAG,
        OBJECT_VERSION_NUMBER,
        COMMENTS,
        VARIATION_DESCRIPTION,
        NAME,
        TEXT,
        CREATED_BY,
        CREATION_DATE,
        LAST_UPDATED_BY,
        LAST_UPDATE_DATE,
        LAST_UPDATE_LOGIN,
        SAV_SAV_RELEASE)
 SELECT
            B.ID,
            L.LANGUAGE_CODE,
            B.MAJOR_VERSION,
            B.SOURCE_LANG,
            B.SFWT_FLAG,
            B.OBJECT_VERSION_NUMBER,
            B.COMMENTS,
            B.VARIATION_DESCRIPTION,
            B.NAME,
            B.TEXT,
            B.CREATED_BY,
            B.CREATION_DATE,
            B.LAST_UPDATED_BY,
            B.LAST_UPDATE_DATE,
            B.LAST_UPDATE_LOGIN,
            B.SAV_SAV_RELEASE
        FROM OKC_K_ARTICLES_TLH B, FND_LANGUAGES L
       WHERE L.INSTALLED_FLAG IN ('I', 'B')
         AND B.LANGUAGE = USERENV('LANG')
         AND NOT EXISTS(
                    SELECT NULL
                      FROM OKC_K_ARTICLES_TLH T
                     WHERE T.ID = B.ID
                     AND T.MAJOR_VERSION = B.MAJOR_VERSION
                       AND T.LANGUAGE = L.LANGUAGE_CODE
                    );

Line: 269

    SELECT
            ID,
            SAV_SAE_ID,
            SBT_CODE,
            CAT_TYPE,
            CHR_ID,
            CLE_ID,
            CAT_ID,
            DNZ_CHR_ID,
            OBJECT_VERSION_NUMBER,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            FULLTEXT_YN,
            LAST_UPDATE_LOGIN,
            ATTRIBUTE_CATEGORY,
            ATTRIBUTE1,
            ATTRIBUTE2,
            ATTRIBUTE3,
            ATTRIBUTE4,
            ATTRIBUTE5,
            ATTRIBUTE6,
            ATTRIBUTE7,
            ATTRIBUTE8,
            ATTRIBUTE9,
            ATTRIBUTE10,
            ATTRIBUTE11,
            ATTRIBUTE12,
            ATTRIBUTE13,
            ATTRIBUTE14,
            ATTRIBUTE15
      FROM Okc_K_Articles_B
     WHERE okc_k_articles_b.id  = p_id;

Line: 327

              l_cat_rec.LAST_UPDATED_BY,
              l_cat_rec.LAST_UPDATE_DATE,
              l_cat_rec.FULLTEXT_YN,
              l_cat_rec.LAST_UPDATE_LOGIN,
              l_cat_rec.ATTRIBUTE_CATEGORY,
              l_cat_rec.ATTRIBUTE1,
              l_cat_rec.ATTRIBUTE2,
              l_cat_rec.ATTRIBUTE3,
              l_cat_rec.ATTRIBUTE4,
              l_cat_rec.ATTRIBUTE5,
              l_cat_rec.ATTRIBUTE6,
              l_cat_rec.ATTRIBUTE7,
              l_cat_rec.ATTRIBUTE8,
              l_cat_rec.ATTRIBUTE9,
              l_cat_rec.ATTRIBUTE10,
              l_cat_rec.ATTRIBUTE11,
              l_cat_rec.ATTRIBUTE12,
              l_cat_rec.ATTRIBUTE13,
              l_cat_rec.ATTRIBUTE14,
              l_cat_rec.ATTRIBUTE15;

Line: 377

    SELECT
            ID,
            LANGUAGE,
            SOURCE_LANG,
            SFWT_FLAG,
            OBJECT_VERSION_NUMBER,
            COMMENTS,
            VARIATION_DESCRIPTION,
            NAME,
            TEXT,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN,
            SAV_SAV_RELEASE
      FROM Okc_K_Articles_Tl
     WHERE okc_k_articles_tl.id = p_id
       AND okc_k_articles_tl.language = p_language;

Line: 421

              l_okc_k_articles_tl_rec.LAST_UPDATED_BY,
              l_okc_k_articles_tl_rec.LAST_UPDATE_DATE,
              l_okc_k_articles_tl_rec.LAST_UPDATE_LOGIN,
              l_okc_k_articles_tl_rec.SAV_SAV_RELEASE;

Line: 453

    SELECT
            ID,
            CHR_ID,
            CLE_ID,
            CAT_ID,
            OBJECT_VERSION_NUMBER,
            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,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okc_K_Articles_V
     WHERE okc_k_articles_v.id  = p_id;

Line: 540

              l_catv_rec.LAST_UPDATED_BY,
              l_catv_rec.LAST_UPDATE_DATE,
              l_catv_rec.LAST_UPDATE_LOGIN;

Line: 679

    IF (l_catv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
      l_catv_rec.last_updated_by := NULL;

Line: 682

    IF (l_catv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
      l_catv_rec.last_update_date := NULL;

Line: 685

    IF (l_catv_rec.last_update_login = OKC_API.G_MISS_NUM) THEN
      l_catv_rec.last_update_login := NULL;

Line: 834

    select '!'
    from okc_k_headers_b
    where id = p_catv_rec.dnz_chr_id;

Line: 900

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

Line: 960

  select '!'
  from OKC_K_LINES_B
  where id = p_catv_rec.cle_id;

Line: 1020

  select '!'
  from OKC_K_HEADERS_B
  where id = p_catv_rec.chr_id;

Line: 1216

    select '!' from OKC_STD_ART_VERSIONS_B
    where SAE_ID=p_sae_id and SAV_RELEASE=p_sav_release;

Line: 1336

    p_to.last_updated_by := p_from.last_updated_by;

Line: 1337

    p_to.last_update_date := p_from.last_update_date;

Line: 1339

    p_to.last_update_login := p_from.last_update_login;

Line: 1377

    p_to.last_updated_by := p_from.last_updated_by;

Line: 1378

    p_to.last_update_date := p_from.last_update_date;

Line: 1380

    p_to.last_update_login := p_from.last_update_login;

Line: 1416

    p_to.last_updated_by := p_from.last_updated_by;

Line: 1417

    p_to.last_update_date := p_from.last_update_date;

Line: 1418

    p_to.last_update_login := p_from.last_update_login;

Line: 1439

    p_to.last_updated_by := p_from.last_updated_by;

Line: 1440

    p_to.last_update_date := p_from.last_update_date;

Line: 1441

    p_to.last_update_login := p_from.last_update_login;

Line: 1659

  PROCEDURE insert_row(
    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_cat_rec                      IN cat_rec_type,
    x_cat_rec                      OUT NOCOPY cat_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1668

    l_api_name                     CONSTANT VARCHAR2(30) := 'B_insert_row';

Line: 1690

       okc_debug.log('4800: Entered insert_row', 2);

Line: 1712

    INSERT INTO OKC_K_ARTICLES_B(
        id,
        sav_sae_id,
        sbt_code,
        cat_type,
        chr_id,
        cle_id,
        cat_id,
        dnz_chr_id,
        object_version_number,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        fulltext_yn,
        last_update_login,
        attribute_category,
        attribute1,
        attribute2,
        attribute3,
        attribute4,
        attribute5,
        attribute6,
        attribute7,
        attribute8,
        attribute9,
        attribute10,
        attribute11,
        attribute12,
        attribute13,
        attribute14,
        attribute15)
      VALUES (
        l_cat_rec.id,
        l_cat_rec.sav_sae_id,
        l_cat_rec.sbt_code,
        l_cat_rec.cat_type,
        l_cat_rec.chr_id,
        l_cat_rec.cle_id,
        l_cat_rec.cat_id,
        l_cat_rec.dnz_chr_id,
        l_cat_rec.object_version_number,
        l_cat_rec.created_by,
        l_cat_rec.creation_date,
        l_cat_rec.last_updated_by,
        l_cat_rec.last_update_date,
        l_cat_rec.fulltext_yn,
        l_cat_rec.last_update_login,
        l_cat_rec.attribute_category,
        l_cat_rec.attribute1,
        l_cat_rec.attribute2,
        l_cat_rec.attribute3,
        l_cat_rec.attribute4,
        l_cat_rec.attribute5,
        l_cat_rec.attribute6,
        l_cat_rec.attribute7,
        l_cat_rec.attribute8,
        l_cat_rec.attribute9,
        l_cat_rec.attribute10,
        l_cat_rec.attribute11,
        l_cat_rec.attribute12,
        l_cat_rec.attribute13,
        l_cat_rec.attribute14,
        l_cat_rec.attribute15);

Line: 1781

   okc_debug.log('4900: Leaving insert_row', 2);

Line: 1789

       okc_debug.log('5000: Leaving insert_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);

Line: 1805

       okc_debug.log('5100: Leaving insert_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

Line: 1821

       okc_debug.log('5200: Leaving insert_row:OTHERS Exception', 2);

Line: 1835

  END insert_row;

Line: 1839

  PROCEDURE insert_row(
    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_okc_k_articles_tl_rec        IN okc_k_articles_tl_rec_type,
    x_okc_k_articles_tl_rec        OUT NOCOPY okc_k_articles_tl_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1848

    l_api_name                     CONSTANT VARCHAR2(30) := 'TL_insert_row';

Line: 1853

      SELECT *
        FROM FND_LANGUAGES
       WHERE INSTALLED_FLAG IN ('I', 'B');

Line: 1876

       okc_debug.log('5300: Entered insert_row', 2);

Line: 1900

      INSERT INTO OKC_K_ARTICLES_TL(
          id,
          language,
          source_lang,
          sfwt_flag,
          object_version_number,
          comments,
          variation_description,
          name,
          text,
          created_by,
          creation_date,
          last_updated_by,
          last_update_date,
          last_update_login,
          sav_sav_release)
        VALUES (
          l_okc_k_articles_tl_rec.id,
          l_okc_k_articles_tl_rec.language,
          l_okc_k_articles_tl_rec.source_lang,
          l_okc_k_articles_tl_rec.sfwt_flag,
          l_okc_k_articles_tl_rec.object_version_number,
          l_okc_k_articles_tl_rec.comments,
          l_okc_k_articles_tl_rec.variation_description,
          l_okc_k_articles_tl_rec.name,
          l_okc_k_articles_tl_rec.text,
          l_okc_k_articles_tl_rec.created_by,
          l_okc_k_articles_tl_rec.creation_date,
          l_okc_k_articles_tl_rec.last_updated_by,
          l_okc_k_articles_tl_rec.last_update_date,
          l_okc_k_articles_tl_rec.last_update_login,
          l_okc_k_articles_tl_rec.sav_sav_release);

Line: 1938

   okc_debug.log('5400: Leaving insert_row', 2);

Line: 1946

       okc_debug.log('5500: Leaving insert_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);

Line: 1962

       okc_debug.log('5600: Leaving insert_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

Line: 1978

       okc_debug.log('5700: Leaving insert_row:OTHERS Exception', 2);

Line: 1992

  END insert_row;

Line: 1996

  PROCEDURE insert_row(
    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_api_version                 CONSTANT NUMBER := 1;

Line: 2006

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_insert_row';

Line: 2030

      l_catv_rec.LAST_UPDATE_DATE := l_catv_rec.CREATION_DATE;

Line: 2031

      l_catv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 2032

      l_catv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 2067

       okc_debug.log('6000: Entered insert_row', 2);

Line: 2118

    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_cat_rec,
      lx_cat_rec
    );

Line: 2132

    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_okc_k_articles_tl_rec,
      lx_okc_k_articles_tl_rec
    );

Line: 2151

   okc_debug.log('6050: Leaving insert_row', 2);

Line: 2159

       okc_debug.log('6100: Leaving insert_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);

Line: 2175

       okc_debug.log('6200: Leaving insert_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

Line: 2191

       okc_debug.log('6300: Leaving insert_row:OTHERS Exception', 2);

Line: 2205

  END insert_row;

Line: 2209

  PROCEDURE insert_row(
    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_tbl                     IN catv_tbl_type,
    x_catv_tbl                     OUT NOCOPY catv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2219

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';

Line: 2226

       okc_debug.log('6500: Entered insert_row', 2);

Line: 2234

        insert_row (
          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_catv_rec                     => p_catv_tbl(i),
          x_catv_rec                     => x_catv_tbl(i));

Line: 2248

       okc_debug.log('6550: Leaving insert_row', 2);

Line: 2256

       okc_debug.log('6600: Leaving insert_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);

Line: 2272

       okc_debug.log('6700: Leaving insert_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

Line: 2288

       okc_debug.log('6800: Leaving insert_row:OTHERS Exception', 2);

Line: 2302

  END insert_row;

Line: 2320

    SELECT OBJECT_VERSION_NUMBER
      FROM OKC_K_ARTICLES_B
     WHERE ID = p_cat_rec.id
       AND OBJECT_VERSION_NUMBER = p_cat_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 2327

    SELECT OBJECT_VERSION_NUMBER
      FROM OKC_K_ARTICLES_B
    WHERE ID = p_cat_rec.id;

Line: 2382

      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 2391

      OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 2465

    SELECT *
      FROM OKC_K_ARTICLES_TL
     WHERE ID = p_okc_k_articles_tl_rec.id
    FOR UPDATE NOWAIT;

Line: 2520

      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 2808

  PROCEDURE update_row(
    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_cat_rec                      IN cat_rec_type,
    x_cat_rec                      OUT NOCOPY cat_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2817

    l_api_name                     CONSTANT VARCHAR2(30) := 'B_update_row';

Line: 2889

      IF (x_cat_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_cat_rec.last_updated_by := l_cat_rec.last_updated_by;

Line: 2893

      IF (x_cat_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_cat_rec.last_update_date := l_cat_rec.last_update_date;

Line: 2901

      IF (x_cat_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_cat_rec.last_update_login := l_cat_rec.last_update_login;

Line: 2996

       okc_debug.log('10100: Entered update_row', 2);

Line: 3024

    UPDATE  OKC_K_ARTICLES_B
    SET SAV_SAE_ID = l_def_cat_rec.sav_sae_id,
        SBT_CODE = l_def_cat_rec.sbt_code,
        CAT_TYPE = l_def_cat_rec.cat_type,
        CHR_ID = l_def_cat_rec.chr_id,
        CLE_ID = l_def_cat_rec.cle_id,
        CAT_ID = l_def_cat_rec.cat_id,
        DNZ_CHR_ID = l_def_cat_rec.dnz_chr_id,
        OBJECT_VERSION_NUMBER = l_def_cat_rec.object_version_number,
        CREATED_BY = l_def_cat_rec.created_by,
        CREATION_DATE = l_def_cat_rec.creation_date,
        LAST_UPDATED_BY = l_def_cat_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_cat_rec.last_update_date,
        FULLTEXT_YN = l_def_cat_rec.fulltext_yn,
        LAST_UPDATE_LOGIN = l_def_cat_rec.last_update_login,
        ATTRIBUTE_CATEGORY = l_def_cat_rec.attribute_category,
        ATTRIBUTE1 = l_def_cat_rec.attribute1,
        ATTRIBUTE2 = l_def_cat_rec.attribute2,
        ATTRIBUTE3 = l_def_cat_rec.attribute3,
        ATTRIBUTE4 = l_def_cat_rec.attribute4,
        ATTRIBUTE5 = l_def_cat_rec.attribute5,
        ATTRIBUTE6 = l_def_cat_rec.attribute6,
        ATTRIBUTE7 = l_def_cat_rec.attribute7,
        ATTRIBUTE8 = l_def_cat_rec.attribute8,
        ATTRIBUTE9 = l_def_cat_rec.attribute9,
        ATTRIBUTE10 = l_def_cat_rec.attribute10,
        ATTRIBUTE11 = l_def_cat_rec.attribute11,
        ATTRIBUTE12 = l_def_cat_rec.attribute12,
        ATTRIBUTE13 = l_def_cat_rec.attribute13,
        ATTRIBUTE14 = l_def_cat_rec.attribute14,
        ATTRIBUTE15 = l_def_cat_rec.attribute15
    WHERE ID = l_def_cat_rec.id;

Line: 3061

   okc_debug.log('10200: Leaving update_row', 2);

Line: 3069

       okc_debug.log('10300: Leaving update_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);

Line: 3085

       okc_debug.log('10400: Leaving update_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

Line: 3101

       okc_debug.log('10500: Leaving update_row:OTHERS Exception', 2);

Line: 3115

  END update_row;

Line: 3119

  PROCEDURE update_row(
    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_okc_k_articles_tl_rec        IN okc_k_articles_tl_rec_type,
    x_okc_k_articles_tl_rec        OUT NOCOPY okc_k_articles_tl_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3128

    l_api_name                     CONSTANT VARCHAR2(30) := 'TL_update_row';

Line: 3204

      IF (x_okc_k_articles_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_okc_k_articles_tl_rec.last_updated_by := l_okc_k_articles_tl_rec.last_updated_by;

Line: 3208

      IF (x_okc_k_articles_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_okc_k_articles_tl_rec.last_update_date := l_okc_k_articles_tl_rec.last_update_date;

Line: 3212

      IF (x_okc_k_articles_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_okc_k_articles_tl_rec.last_update_login := l_okc_k_articles_tl_rec.last_update_login;

Line: 3222

   okc_debug.log('10650: Leaving update_row', 2);

Line: 3249

       okc_debug.log('10700: Entered update_row', 2);

Line: 3277

    UPDATE  OKC_K_ARTICLES_TL
    SET OBJECT_VERSION_NUMBER = l_def_okc_k_articles_tl_rec.object_version_number,
        COMMENTS = l_def_okc_k_articles_tl_rec.comments,
        VARIATION_DESCRIPTION = l_def_okc_k_articles_tl_rec.variation_description,
        NAME = l_def_okc_k_articles_tl_rec.name,
        TEXT = l_def_okc_k_articles_tl_rec.text,
        CREATED_BY = l_def_okc_k_articles_tl_rec.created_by,
        CREATION_DATE = l_def_okc_k_articles_tl_rec.creation_date,
        LAST_UPDATED_BY = l_def_okc_k_articles_tl_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_okc_k_articles_tl_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_okc_k_articles_tl_rec.last_update_login,
        SAV_SAV_RELEASE = l_def_okc_k_articles_tl_rec.sav_sav_release
--+
	,SOURCE_LANG = l_def_okc_k_articles_tl_rec.SOURCE_LANG
--+
    WHERE ID = l_def_okc_k_articles_tl_rec.id
---      AND SOURCE_LANG = USERENV('LANG');

Line: 3298

    UPDATE  OKC_K_ARTICLES_TL
    SET SFWT_FLAG = 'Y'
    WHERE ID = l_def_okc_k_articles_tl_rec.id
      AND SOURCE_LANG <> USERENV('LANG');

Line: 3307

   okc_debug.log('10750: Leaving update_row', 2);

Line: 3315

       okc_debug.log('10800: Leaving update_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);

Line: 3331

       okc_debug.log('10900: Leaving update_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

Line: 3347

       okc_debug.log('11000: Leaving update_row:OTHERS Exception', 2);

Line: 3361

  END update_row;

Line: 3365

  PROCEDURE update_row(
    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_api_version                 CONSTANT NUMBER := 1;

Line: 3375

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_update_row';

Line: 3392

      l_catv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 3393

      l_catv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 3394

      l_catv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 3561

      IF (x_catv_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_catv_rec.last_updated_by := l_catv_rec.last_updated_by;

Line: 3565

      IF (x_catv_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_catv_rec.last_update_date := l_catv_rec.last_update_date;

Line: 3569

      IF (x_catv_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_catv_rec.last_update_login := l_catv_rec.last_update_login;

Line: 3601

   okc_debug.log('11500: Entered update_row', 2);

Line: 3656

    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_okc_k_articles_tl_rec,
      lx_okc_k_articles_tl_rec
    );

Line: 3670

    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_cat_rec,
      lx_cat_rec
    );

Line: 3688

    okc_debug.log('11600: Leaving update_row', 2);

Line: 3696

       okc_debug.log('11700: Leaving update_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);

Line: 3712

       okc_debug.log('11800: Leaving update_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

Line: 3728

       okc_debug.log('11900: Leaving update_row:OTHERS Exception', 2);

Line: 3742

  END update_row;

Line: 3746

  PROCEDURE update_row(
    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_tbl                     IN catv_tbl_type,
    x_catv_tbl                     OUT NOCOPY catv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3756

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_tbl_update_row';

Line: 3763

       okc_debug.log('12000: Entered update_row', 2);

Line: 3771

        update_row (
          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_catv_rec                     => p_catv_tbl(i),
          x_catv_rec                     => x_catv_tbl(i));

Line: 3785

   okc_debug.log('12100: Leaving update_row', 2);

Line: 3793

       okc_debug.log('12200: Leaving update_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);

Line: 3809

       okc_debug.log('12300: Leaving update_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

Line: 3825

       okc_debug.log('12400: Leaving update_row:OTHERS Exception', 2);

Line: 3839

  END update_row;

Line: 3847

  PROCEDURE delete_row(
    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_cat_rec                      IN cat_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3855

    l_api_name                     CONSTANT VARCHAR2(30) := 'B_delete_row';

Line: 3863

       okc_debug.log('12500: Entered delete_row', 2);

Line: 3875

    DELETE FROM OKC_K_ARTICLES_B
     WHERE ID = l_cat_rec.id;

Line: 3881

       okc_debug.log('12600: Leaving delete_row', 2);

Line: 3889

       okc_debug.log('12700: Leaving delete_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);

Line: 3905

       okc_debug.log('12800: Leaving delete_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

Line: 3921

       okc_debug.log('12900: Leaving delete_row:OTHERS Exception', 2);

Line: 3935

  END delete_row;

Line: 3939

  PROCEDURE delete_row(
    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_okc_k_articles_tl_rec        IN okc_k_articles_tl_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3947

    l_api_name                     CONSTANT VARCHAR2(30) := 'TL_delete_row';

Line: 3970

       okc_debug.log('13100: Entered delete_row', 2);

Line: 3992

    DELETE FROM OKC_K_ARTICLES_TL
     WHERE ID = l_okc_k_articles_tl_rec.id;

Line: 3998

       okc_debug.log('13200: Leaving delete_row', 2);

Line: 4006

       okc_debug.log('13300: Leaving delete_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);

Line: 4022

       okc_debug.log('13400: Leaving delete_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

Line: 4038

       okc_debug.log('13500: Leaving delete_row:OTHERS Exception', 2);

Line: 4052

  END delete_row;

Line: 4056

  PROCEDURE delete_row(
    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_api_version                 CONSTANT NUMBER := 1;

Line: 4065

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_delete_row';

Line: 4074

       okc_debug.log('13600: Entered delete_row', 2);

Line: 4097

    delete_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_okc_k_articles_tl_rec
    );

Line: 4109

    delete_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_cat_rec
    );

Line: 4124

       okc_debug.log('13700: Leaving delete_row', 2);

Line: 4132

       okc_debug.log('13800: Leaving delete_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);

Line: 4148

       okc_debug.log('13900: Leaving delete_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

Line: 4164

       okc_debug.log('14000: Leaving delete_row:OTHERS Exception', 2);

Line: 4178

  END delete_row;

Line: 4182

  PROCEDURE delete_row(
    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_tbl                     IN catv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 4191

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';

Line: 4198

       okc_debug.log('14100: Entered delete_row', 2);

Line: 4206

        delete_row (
          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_catv_rec                     => p_catv_tbl(i));

Line: 4219

    okc_debug.log('14200: Leaving delete_row', 2);

Line: 4227

       okc_debug.log('14300: Leaving delete_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);

Line: 4243

       okc_debug.log('14400: Leaving delete_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

Line: 4259

       okc_debug.log('14500: Leaving delete_row:OTHERS Exception', 2);

Line: 4273

  END delete_row;

Line: 4278

PROCEDURE INSERT_ROW_UPG(x_return_status OUT NOCOPY VARCHAR2,p_catv_tbl catv_tbl_type) IS
  l_tabsize NUMBER := p_catv_tbl.COUNT;

Line: 4316

  in_last_updated_by               OKC_DATATYPES.NumberTabTyp;

Line: 4317

  in_last_update_date              OKC_DATATYPES.DateTabTyp;

Line: 4318

  in_last_update_login             OKC_DATATYPES.NumberTabTyp;

Line: 4326

       okc_debug.log('14600: Entered INSERT_ROW_UPG', 2);

Line: 4367

    in_last_updated_by          (j) := p_catv_tbl(i).last_updated_by;

Line: 4368

    in_last_update_date         (j) := p_catv_tbl(i).last_update_date;

Line: 4369

    in_last_update_login        (j) := p_catv_tbl(i).last_update_login;

Line: 4374

    INSERT
      INTO OKC_K_ARTICLES_B
      (
        id,
        sav_sae_id,
        sbt_code,
        cat_type,
        chr_id,
        cle_id,
        cat_id,
        dnz_chr_id,
        object_version_number,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        fulltext_yn,
        last_update_login,
        attribute_category,
        attribute1,
        attribute2,
        attribute3,
        attribute4,
        attribute5,
        attribute6,
        attribute7,
        attribute8,
        attribute9,
        attribute10,
        attribute11,
        attribute12,
        attribute13,
        attribute14,
        attribute15
-- REMOVE comma from the previous line
     )
     VALUES (
        in_id(i),
        in_sav_sae_id(i),
        in_sbt_code(i),
        in_cat_type(i),
        in_chr_id(i),
        in_cle_id(i),
        in_cat_id(i),
        in_dnz_chr_id(i),
        in_object_version_number(i),
        in_created_by(i),
        in_creation_date(i),
        in_last_updated_by(i),
        in_last_update_date(i),
        in_fulltext_yn(i),
        in_last_update_login(i),
        in_attribute_category(i),
        in_attribute1(i),
        in_attribute2(i),
        in_attribute3(i),
        in_attribute4(i),
        in_attribute5(i),
        in_attribute6(i),
        in_attribute7(i),
        in_attribute8(i),
        in_attribute9(i),
        in_attribute10(i),
        in_attribute11(i),
        in_attribute12(i),
        in_attribute13(i),
        in_attribute14(i),
        in_attribute15(i)
-- REMOVE comma from the previous line
     );

Line: 4447

      INSERT INTO OKC_K_ARTICLES_TL(
        id,
        language,
        source_lang,
        sfwt_flag,
        object_version_number,
        comments,
        variation_description,
        name,
      --  text,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        last_update_login,
        sav_sav_release
-- REMOVE comma from the previous line
     )
     VALUES (
        in_id(i),
        OKC_UTIL.g_language_code(lang_i),
        l_source_lang,
        in_sfwt_flag(i),
        in_object_version_number(i),
        in_comments(i),
        in_variation_description(i),
        in_name(i),
      --  in_text(i),
        in_created_by(i),
        in_creation_date(i),
        in_last_updated_by(i),
        in_last_update_date(i),
        in_last_update_login(i),
        in_sav_sav_release(i)
-- REMOVE comma from the previous line
      );

Line: 4486

       okc_debug.log('14700: Leaving INSERT_ROW_UPG', 2);

Line: 4504

       okc_debug.log('14800: Leaving INSERT_ROW_UPG:OTHERS Exception', 2);

Line: 4510

END INSERT_ROW_UPG;

Line: 4530

INSERT INTO okc_k_articles_bh
  (
      major_version,
      id,
      sav_sae_id,
      sbt_code,
      cat_type,
      chr_id,
      cle_id,
      cat_id,
      dnz_chr_id,
      object_version_number,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      fulltext_yn,
      last_update_login,
      attribute_category,
      attribute1,
      attribute2,
      attribute3,
      attribute4,
      attribute5,
      attribute6,
      attribute7,
      attribute8,
      attribute9,
      attribute10,
      attribute11,
      attribute12,
      attribute13,
      attribute14,
      attribute15
)
  SELECT
      p_major_version,
      id,
      sav_sae_id,
      sbt_code,
      cat_type,
      chr_id,
      cle_id,
      cat_id,
      dnz_chr_id,
      object_version_number,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      fulltext_yn,
      last_update_login,
      attribute_category,
      attribute1,
      attribute2,
      attribute3,
      attribute4,
      attribute5,
      attribute6,
      attribute7,
      attribute8,
      attribute9,
      attribute10,
      attribute11,
      attribute12,
      attribute13,
      attribute14,
      attribute15
  FROM okc_k_articles_b
WHERE dnz_chr_id = p_chr_id;

Line: 4605

INSERT INTO okc_k_articles_tlh
  (
      major_version,
      id,
      language,
      source_lang,
      sfwt_flag,
      object_version_number,
      comments,
      variation_description,
      name,
      text,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login,
      sav_sav_release
)
  SELECT
      p_major_version,
      id,
      language,
      source_lang,
      sfwt_flag,
      object_version_number,
      comments,
      variation_description,
      name,
      text,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login,
      sav_sav_release
  FROM okc_k_articles_tl
 WHERE id in (select id from okc_k_articles_b
			where dnz_chr_id = p_chr_id);

Line: 4693

INSERT INTO okc_k_articles_tl
  (
      id,
      language,
      source_lang,
      sfwt_flag,
      object_version_number,
      comments,
      variation_description,
      name,
      text,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login,
      sav_sav_release
)
  SELECT
      id,
      language,
      source_lang,
      sfwt_flag,
      object_version_number,
      comments,
      variation_description,
      name,
      text,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login,
      sav_sav_release
  FROM okc_k_articles_tlh
WHERE id in (SELECT id
			FROM okc_k_articles_bh
		    WHERE dnz_chr_id = p_chr_id)
  AND major_version = p_major_version;

Line: 4737

INSERT INTO okc_k_articles_b
  (
      id,
      sav_sae_id,
      sbt_code,
      cat_type,
      chr_id,
      cle_id,
      cat_id,
      dnz_chr_id,
      object_version_number,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      fulltext_yn,
      last_update_login,
      attribute_category,
      attribute1,
      attribute2,
      attribute3,
      attribute4,
      attribute5,
      attribute6,
      attribute7,
      attribute8,
      attribute9,
      attribute10,
      attribute11,
      attribute12,
      attribute13,
      attribute14,
      attribute15
)
  SELECT
      id,
      sav_sae_id,
      sbt_code,
      cat_type,
      chr_id,
      cle_id,
      cat_id,
      dnz_chr_id,
      object_version_number,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      fulltext_yn,
      last_update_login,
      attribute_category,
      attribute1,
      attribute2,
      attribute3,
      attribute4,
      attribute5,
      attribute6,
      attribute7,
      attribute8,
      attribute9,
      attribute10,
      attribute11,
      attribute12,
      attribute13,
      attribute14,
      attribute15
  FROM okc_k_articles_bh
WHERE dnz_chr_id = p_chr_id
  AND major_version = p_major_version;