eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_VP_CAT_PVT SQL Statements

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

Line: 46


    DELETE FROM OKC_K_ARTICLES_TL T
     WHERE NOT EXISTS (
        SELECT NULL
          FROM OKC_K_ARTICLES_B B      --fixed bug 3321017 by kmotepal
         WHERE B.ID = T.ID
        );

Line: 53


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


    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,
        SECURITY_GROUP_ID,
        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.SECURITY_GROUP_ID,
            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: 152


    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,
            SECURITY_GROUP_ID
      FROM Okc_K_Articles_B
     WHERE okc_k_articles_b.id  = p_id;

Line: 205


              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,
              l_cat_rec.SECURITY_GROUP_ID;

Line: 247


    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,
            SECURITY_GROUP_ID,
            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: 286


              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.SECURITY_GROUP_ID,
              l_okc_k_articles_tl_rec.SAV_SAV_RELEASE;

Line: 311


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


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

Line: 516


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

Line: 519


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

Line: 522


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

Line: 622


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

Line: 669


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

Line: 710


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

Line: 751


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

Line: 914


      SELECT
              ID,
              OBJECT_VERSION_NUMBER,
              SFWT_FLAG,
              CHR_ID_RESPONSE,
              CHR_ID_AWARD,
              CHR_ID_RENEWED,
              INV_ORGANIZATION_ID,
              STS_CODE,
              QCL_ID,
              SCS_CODE,
              CONTRACT_NUMBER,
              CURRENCY_CODE,
              CONTRACT_NUMBER_MODIFIER,
              ARCHIVED_YN,
              DELETED_YN,
              CUST_PO_NUMBER_REQ_YN,
              PRE_PAY_REQ_YN,
              CUST_PO_NUMBER,
              SHORT_DESCRIPTION,
              COMMENTS,
              DESCRIPTION,
              DPAS_RATING,
              COGNOMEN,
              TEMPLATE_YN,
              TEMPLATE_USED,
              DATE_APPROVED,
              DATETIME_CANCELLED,
              AUTO_RENEW_DAYS,
              DATE_ISSUED,
              DATETIME_RESPONDED,
              NON_RESPONSE_REASON,
              NON_RESPONSE_EXPLAIN,
              RFP_TYPE,
              CHR_TYPE,
              KEEP_ON_MAIL_LIST,
              SET_ASIDE_REASON,
              SET_ASIDE_PERCENT,
              RESPONSE_COPIES_REQ,
              DATE_CLOSE_PROJECTED,
              DATETIME_PROPOSED,
              DATE_SIGNED,
              DATE_TERMINATED,
              DATE_RENEWED,
              TRN_CODE,
              START_DATE,
              END_DATE,
              AUTHORING_ORG_ID,
              BUY_OR_SELL,
              ISSUE_OR_RECEIVE,
              ESTIMATED_AMOUNT,
              CHR_ID_RENEWED_TO,
              ESTIMATED_AMOUNT_RENEWED,
              CURRENCY_CODE_RENEWED,
              USER_ACCESS_LEVEL,
              ATTRIBUTE_CATEGORY,
              ATTRIBUTE1,
              ATTRIBUTE2,
              ATTRIBUTE3,
              ATTRIBUTE4,
              ATTRIBUTE5,
              ATTRIBUTE6,
              ATTRIBUTE7,
              ATTRIBUTE8,
              ATTRIBUTE9,
              ATTRIBUTE10,
              ATTRIBUTE11,
              ATTRIBUTE12,
              ATTRIBUTE13,
              ATTRIBUTE14,
              ATTRIBUTE15,
              CREATED_BY,
              CREATION_DATE,
              LAST_UPDATED_BY,
              LAST_UPDATE_DATE,
              LAST_UPDATE_LOGIN
        FROM Okc_K_Headers_V
       WHERE okc_k_headers_v.id   = p_id;

Line: 994


      SELECT
              ID,
              OBJECT_VERSION_NUMBER,
              SFWT_FLAG,
              CHR_ID,
              CLE_ID,
              CLE_ID_RENEWED,
              CLE_ID_RENEWED_TO,
              LSE_ID,
              LINE_NUMBER,
              STS_CODE,
              DISPLAY_SEQUENCE,
              TRN_CODE,
              DNZ_CHR_ID,
              COMMENTS,
              ITEM_DESCRIPTION,
              HIDDEN_IND,
              PRICE_UNIT,
              PRICE_UNIT_PERCENT,
              PRICE_NEGOTIATED,
              PRICE_NEGOTIATED_RENEWED,
              PRICE_LEVEL_IND,
              INVOICE_LINE_LEVEL_IND,
              DPAS_RATING,
              BLOCK23TEXT,
              EXCEPTION_YN,
              TEMPLATE_USED,
              DATE_TERMINATED,
              NAME,
              START_DATE,
              END_DATE,
              ATTRIBUTE_CATEGORY,
              ATTRIBUTE1,
              ATTRIBUTE2,
              ATTRIBUTE3,
              ATTRIBUTE4,
              ATTRIBUTE5,
              ATTRIBUTE6,
              ATTRIBUTE7,
              ATTRIBUTE8,
              ATTRIBUTE9,
              ATTRIBUTE10,
              ATTRIBUTE11,
              ATTRIBUTE12,
              ATTRIBUTE13,
              ATTRIBUTE14,
              ATTRIBUTE15,
              CREATED_BY,
              CREATION_DATE,
              LAST_UPDATED_BY,
              LAST_UPDATE_DATE,
              LAST_UPDATE_LOGIN,
              PRICE_TYPE,
              CURRENCY_CODE,
              CURRENCY_CODE_RENEWED
        FROM Okc_K_Lines_V
       WHERE okc_k_lines_v.id     = p_id;

Line: 1053


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


      SELECT
              SAE_ID,
              SAV_RELEASE,
              OBJECT_VERSION_NUMBER,
              SFWT_FLAG,
              DATE_ACTIVE,
              TEXT,
              SHORT_DESCRIPTION,
              ATTRIBUTE_CATEGORY,
              ATTRIBUTE1,
              ATTRIBUTE2,
              ATTRIBUTE3,
              ATTRIBUTE4,
              ATTRIBUTE5,
              ATTRIBUTE6,
              ATTRIBUTE7,
              ATTRIBUTE8,
              ATTRIBUTE9,
              ATTRIBUTE10,
              ATTRIBUTE11,
              ATTRIBUTE12,
              ATTRIBUTE13,
              ATTRIBUTE14,
              ATTRIBUTE15,
              CREATED_BY,
              CREATION_DATE,
              LAST_UPDATED_BY,
              LAST_UPDATE_DATE,
              LAST_UPDATE_LOGIN
        FROM Okc_Std_Art_Versions_V
       WHERE okc_std_art_versions_v.sae_id = p_sae_id
         AND okc_std_art_versions_v.sav_release = p_sav_release;

Line: 1130


      SELECT
              APPLICATION_ID,
              LOOKUP_TYPE,
              LOOKUP_CODE,
              MEANING,
              DESCRIPTION,
              ENABLED_FLAG,
              START_DATE_ACTIVE,
              END_DATE_ACTIVE,
              CREATED_BY,
              CREATION_DATE,
              LAST_UPDATE_DATE,
              LAST_UPDATED_BY,
              LAST_UPDATE_LOGIN
        FROM Fnd_Common_Lookups
       WHERE fnd_common_lookups.lookup_code = p_lookup_code;

Line: 1221


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

Line: 1321


    p_to.last_updated_by := p_from.last_updated_by;

Line: 1322


    p_to.last_update_date := p_from.last_update_date;

Line: 1324


    p_to.last_update_login := p_from.last_update_login;

Line: 1358


    p_to.last_updated_by := p_from.last_updated_by;

Line: 1359


    p_to.last_update_date := p_from.last_update_date;

Line: 1361


    p_to.last_update_login := p_from.last_update_login;

Line: 1393


    p_to.last_updated_by := p_from.last_updated_by;

Line: 1394


    p_to.last_update_date := p_from.last_update_date;

Line: 1395


    p_to.last_update_login := p_from.last_update_login;

Line: 1412


    p_to.last_updated_by := p_from.last_updated_by;

Line: 1413


    p_to.last_update_date := p_from.last_update_date;

Line: 1414


    p_to.last_update_login := p_from.last_update_login;

Line: 1569


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

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1578


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

Line: 1614


    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,
        security_group_id)
      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,
        l_cat_rec.security_group_id);

Line: 1714


  END insert_row;

Line: 1718


  PROCEDURE insert_row(
    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_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: 1727


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

Line: 1732


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

Line: 1771


      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,
          security_group_id,
          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.security_group_id,
          l_okc_k_articles_tl_rec.sav_sav_release);

Line: 1840


  END insert_row;

Line: 1844


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

Line: 1854


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

Line: 1872


      l_catv_rec.LAST_UPDATE_DATE := l_catv_rec.CREATION_DATE;

Line: 1873


      l_catv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1874


      l_catv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1940


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

Line: 1954


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


  END insert_row;

Line: 2006


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

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2016


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

Line: 2025


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


  END insert_row;

Line: 2086


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


    SELECT OBJECT_VERSION_NUMBER
      FROM OKC_K_ARTICLES_B
    WHERE ID = p_cat_rec.id;

Line: 2134


      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 2143


      OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 2192


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

Line: 2228


      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 2429


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

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2438


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

Line: 2504


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


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


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


    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,
        SECURITY_GROUP_ID = l_def_cat_rec.security_group_id
    WHERE ID = l_def_cat_rec.id;

Line: 2695


  END update_row;

Line: 2699


  PROCEDURE update_row(
    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_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: 2708


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

Line: 2778


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


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


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


    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,
        SECURITY_GROUP_ID = l_def_okc_k_articles_tl_rec.security_group_id,
        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: 2862


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


  END update_row;

Line: 2904


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

Line: 2914


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

Line: 2930


      l_catv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 2931


      l_catv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 2932


      l_catv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 3092


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


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


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


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


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

Line: 3233


  END update_row;

Line: 3237


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

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3247


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

Line: 3256


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


  END update_row;

Line: 3307


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

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3315


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

Line: 3329


    DELETE FROM OKC_K_ARTICLES_B
     WHERE ID = l_cat_rec.id;

Line: 3364


  END delete_row;

Line: 3368


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

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3376


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

Line: 3413


    DELETE FROM OKC_K_ARTICLES_TL
     WHERE ID = l_okc_k_articles_tl_rec.id;

Line: 3448


  END delete_row;

Line: 3452


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

Line: 3461


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

Line: 3487


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

Line: 3499


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

Line: 3543


  END delete_row;

Line: 3547


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

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3556


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

Line: 3565


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


  END delete_row;

Line: 3612


PROCEDURE INSERT_ROW_UPG(p_catv_tbl catv_tbl_type) IS
  l_tabsize NUMBER := p_catv_tbl.COUNT;

Line: 3650


  in_last_updated_by               OKC_DATATYPES.NumberTabTyp;

Line: 3651


  in_last_update_date              OKC_DATATYPES.DateTabTyp;

Line: 3652


  in_last_update_login             OKC_DATATYPES.NumberTabTyp;

Line: 3694


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

Line: 3695


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

Line: 3696


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

Line: 3701


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


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


END INSERT_ROW_UPG;

Line: 3828


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,
      security_group_id
)
  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,
      security_group_id
  FROM okc_k_articles_b
WHERE dnz_chr_id = p_chr_id;

Line: 3905


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,
      security_group_id,
      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,
      security_group_id,
      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: 3976


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,
      security_group_id,
      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,
      security_group_id,
      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: 4022


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,
      security_group_id
)
  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,
      security_group_id
  FROM okc_k_articles_bh
WHERE dnz_chr_id = p_chr_id
  AND major_version = p_major_version;