DBA Data[Home] [Help]

APPS.OKC_K_ARTICLES_PVT SQL Statements

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

Line: 11

  G_RECORD_DELETED             CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_DELETED;
Line: 13

  G_RECORD_LOGICALLY_DELETED   CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
Line: 19

  G_LOCK_RECORD_DELETED        CONSTANT VARCHAR2(200) := OKC_API.G_LOCK_RECORD_DELETED;
Line: 50

  G_AMEND_CODE_DELETED         CONSTANT   VARCHAR2(30) := 'DELETED';
Line: 52

  G_AMEND_CODE_UPDATED         CONSTANT   VARCHAR2(30) := 'UPDATED';
Line: 64

     SELECT OKC_K_ARTICLES_B_S.NEXTVAL FROM DUAL;
Line: 150

    x_last_updated_by            OUT NOCOPY NUMBER,
    x_last_update_login          OUT NOCOPY NUMBER,
    x_last_update_date           OUT NOCOPY DATE,
    x_last_amended_by            OUT NOCOPY NUMBER,
    x_last_amendment_date        OUT NOCOPY DATE

  ) RETURN VARCHAR2 IS
    CURSOR OKC_K_ARTICLES_B_pk_csr (cp_id IN NUMBER) IS
    SELECT
            SAV_SAE_ID,
            DOCUMENT_TYPE,
            DOCUMENT_ID,
            CLE_ID,
            SOURCE_FLAG,
            MANDATORY_YN,
            SCN_ID,
            LABEL,
            AMENDMENT_DESCRIPTION,
            AMENDMENT_OPERATION_CODE,
            ARTICLE_VERSION_ID,
            CHANGE_NONSTD_YN,
            ORIG_SYSTEM_REFERENCE_CODE,
            ORIG_SYSTEM_REFERENCE_ID1,
            ORIG_SYSTEM_REFERENCE_ID2,
            DISPLAY_SEQUENCE,
            ATTRIBUTE_CATEGORY,
            ATTRIBUTE1,
            ATTRIBUTE2,
            ATTRIBUTE3,
            ATTRIBUTE4,
            ATTRIBUTE5,
            ATTRIBUTE6,
            ATTRIBUTE7,
            ATTRIBUTE8,
            ATTRIBUTE9,
            ATTRIBUTE10,
            ATTRIBUTE11,
            ATTRIBUTE12,
            ATTRIBUTE13,
            ATTRIBUTE14,
            ATTRIBUTE15,
            PRINT_TEXT_YN,
            SUMMARY_AMEND_OPERATION_CODE,
            REF_ARTICLE_ID,
            REF_ARTICLE_VERSION_ID,
            OBJECT_VERSION_NUMBER,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_LOGIN,
            LAST_UPDATE_DATE,
            LAST_AMENDED_BY,
            LAST_AMENDMENT_DATE
      FROM OKC_K_ARTICLES_B t
     WHERE t.ID = cp_id;
Line: 206

    SELECT
            SAV_SAE_ID,
            DOCUMENT_TYPE,
            DOCUMENT_ID,
            CLE_ID,
            SOURCE_FLAG,
            MANDATORY_YN,
            SCN_ID,
            LABEL,
            AMENDMENT_DESCRIPTION,
            AMENDMENT_OPERATION_CODE,
            ARTICLE_VERSION_ID,
            CHANGE_NONSTD_YN,
            ORIG_SYSTEM_REFERENCE_CODE,
            ORIG_SYSTEM_REFERENCE_ID1,
            ORIG_SYSTEM_REFERENCE_ID2,
            DISPLAY_SEQUENCE,
            ATTRIBUTE_CATEGORY,
            ATTRIBUTE1,
            ATTRIBUTE2,
            ATTRIBUTE3,
            ATTRIBUTE4,
            ATTRIBUTE5,
            ATTRIBUTE6,
            ATTRIBUTE7,
            ATTRIBUTE8,
            ATTRIBUTE9,
            ATTRIBUTE10,
            ATTRIBUTE11,
            ATTRIBUTE12,
            ATTRIBUTE13,
            ATTRIBUTE14,
            ATTRIBUTE15,
            PRINT_TEXT_YN,
            SUMMARY_AMEND_OPERATION_CODE,
            REF_ARTICLE_ID,
            REF_ARTICLE_VERSION_ID,
            OBJECT_VERSION_NUMBER,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_LOGIN,
            LAST_UPDATE_DATE,
            LAST_AMENDED_BY,
            LAST_AMENDMENT_DATE
      FROM OKC_K_ARTICLES_BH t
     WHERE t.ID = cp_id and major_version=cp_major_version;
Line: 306

            x_last_updated_by,
            x_last_update_login,
            x_last_update_date,
            x_last_amended_by,
            x_last_amendment_date;
Line: 312

        Okc_Api.Set_Message(G_APP_NAME,G_LOCK_RECORD_DELETED,
                   'ENTITYNAME','OKC_K_ARTICLES_B',
                   'PKEY',p_id,
                   'OVN',p_major_version
        );
Line: 367

            x_last_updated_by,
            x_last_update_login,
            x_last_update_date,
            x_last_amended_by,
            x_last_amendment_date;
Line: 373

        Okc_Api.Set_Message(G_APP_NAME,G_LOCK_RECORD_DELETED,
                   'ENTITYNAME','OKC_K_ARTICLES_BH',
                   'PKEY',p_id,
                   'OVN',p_major_version
        );
Line: 522

    l_last_updated_by            OKC_K_ARTICLES_B.LAST_UPDATED_BY%TYPE;
Line: 523

    l_last_update_login          OKC_K_ARTICLES_B.LAST_UPDATE_LOGIN%TYPE;
Line: 524

    l_last_update_date           OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE;
Line: 569

        x_last_updated_by            => l_last_updated_by,
        x_last_update_login          => l_last_update_login,
        x_last_update_date           => l_last_update_date,
        x_last_amended_by            => x_last_amended_by,
        x_last_amendment_date        => x_last_amendment_date
      );
Line: 874

     SELECT '!'
      FROM okc_articles_all
      WHERE article_id = p_sav_sae_id;
Line: 879

     SELECT '!'
      FROM okc_sections_b
      WHERE ID = p_scn_id;
Line: 884

     SELECT '!'
      FROM okc_article_versions
      WHERE ARTICLE_VERSION_ID = p_article_version_id;
Line: 889

     SELECT '!'
      FROM OKC_BUS_DOC_TYPES_V
      WHERE document_type = p_document_type;
Line: 894

    SELECT '!' FROM OKC_SECTIONS_B
    WHERE ID = p_scn_id
    AND   AMENDMENT_OPERATION_CODE = G_AMEND_CODE_DELETED;
Line: 1049

       IF p_amendment_operation_code IN (G_AMEND_CODE_UPDATED,G_AMEND_CODE_ADDED) THEN

           l_dummy_var := '?';
Line: 1236

    SELECT '!' FROM OKC_ARTICLE_VERSIONS
    WHERE ARTICLE_VERSION_ID = p_article_version_id
    AND   ARTICLE_ID        = p_sav_sae_id;
Line: 1435

      l_last_updated_by            OKC_K_ARTICLES_B.LAST_UPDATED_BY%TYPE;
Line: 1436

      l_last_update_login          OKC_K_ARTICLES_B.LAST_UPDATE_LOGIN%TYPE;
Line: 1437

      l_last_update_date           OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE;
Line: 1618

  FUNCTION Insert_Row(
    p_id                         IN NUMBER,
    p_sav_sae_id                 IN NUMBER,
    p_cat_type                   IN VARCHAR2, -- Bug 3341342
    p_document_type              IN VARCHAR2,
    p_document_id                IN NUMBER,
    p_cle_id                     IN NUMBER,
    p_source_flag                IN VARCHAR2,
    p_mandatory_yn               IN VARCHAR2,
    p_scn_id                     IN NUMBER,
    p_label                      IN VARCHAR2,
    p_amendment_description      IN VARCHAR2,
    p_amendment_operation_code   IN VARCHAR2,
    p_article_version_id         IN NUMBER,
    p_change_nonstd_yn           IN VARCHAR2,
    p_orig_system_reference_code IN VARCHAR2,
    p_orig_system_reference_id1  IN NUMBER,
    p_orig_system_reference_id2  IN NUMBER,
    p_display_sequence           IN NUMBER,
    p_attribute_category         IN VARCHAR2,
    p_attribute1                 IN VARCHAR2,
    p_attribute2                 IN VARCHAR2,
    p_attribute3                 IN VARCHAR2,
    p_attribute4                 IN VARCHAR2,
    p_attribute5                 IN VARCHAR2,
    p_attribute6                 IN VARCHAR2,
    p_attribute7                 IN VARCHAR2,
    p_attribute8                 IN VARCHAR2,
    p_attribute9                 IN VARCHAR2,
    p_attribute10                IN VARCHAR2,
    p_attribute11                IN VARCHAR2,
    p_attribute12                IN VARCHAR2,
    p_attribute13                IN VARCHAR2,
    p_attribute14                IN VARCHAR2,
    p_attribute15                IN VARCHAR2,
    p_print_text_yn                IN VARCHAR2,
    p_summary_amend_operation_code IN VARCHAR2,
    p_ref_article_id               IN NUMBER,
    p_ref_article_version_id       IN NUMBER,
    p_object_version_number      IN NUMBER,
    p_created_by                 IN NUMBER,
    p_creation_date              IN DATE,
    p_last_updated_by            IN NUMBER,
    p_last_update_login          IN NUMBER,
    p_last_update_date           IN DATE,
    p_last_amended_by            IN NUMBER,
    p_last_amendment_date        IN DATE

  ) RETURN VARCHAR2 IS
   l_chr_id   NUMBER;
Line: 1672

       Okc_Debug.Log('3100: Entered Insert_Row function', 2);
Line: 1679

    INSERT INTO OKC_K_ARTICLES_B(
        ID,
        SAV_SAE_ID,
        SAV_SAV_RELEASE,
        SBT_CODE,
        CAT_TYPE,
        CHR_ID,
        CAT_ID,
        DNZ_CHR_ID,
        FULLTEXT_YN,
        DOCUMENT_TYPE,
        DOCUMENT_ID,
        CLE_ID,
        SOURCE_FLAG,
        MANDATORY_YN,
        SCN_ID,
        LABEL,
        AMENDMENT_DESCRIPTION,
        AMENDMENT_OPERATION_CODE,
        ARTICLE_VERSION_ID,
        CHANGE_NONSTD_YN,
        ORIG_SYSTEM_REFERENCE_CODE,
        ORIG_SYSTEM_REFERENCE_ID1,
        ORIG_SYSTEM_REFERENCE_ID2,
        DISPLAY_SEQUENCE,
        ATTRIBUTE_CATEGORY,
        ATTRIBUTE1,
        ATTRIBUTE2,
        ATTRIBUTE3,
        ATTRIBUTE4,
        ATTRIBUTE5,
        ATTRIBUTE6,
        ATTRIBUTE7,
        ATTRIBUTE8,
        ATTRIBUTE9,
        ATTRIBUTE10,
        ATTRIBUTE11,
        ATTRIBUTE12,
        ATTRIBUTE13,
        ATTRIBUTE14,
        ATTRIBUTE15,
        PRINT_TEXT_YN,
        SUMMARY_AMEND_OPERATION_CODE,
        REF_ARTICLE_ID,
        REF_ARTICLE_VERSION_ID,
        OBJECT_VERSION_NUMBER,
        CREATED_BY,
        CREATION_DATE,
        LAST_UPDATED_BY,
        LAST_UPDATE_LOGIN,
        LAST_UPDATE_DATE,
        ORIG_ARTICLE_ID,
        LAST_AMENDED_BY,
        LAST_AMENDMENT_DATE)
      VALUES (
        p_id,
        p_sav_sae_id,
        Null,
        Null,
        p_cat_type,--Bug 3341342
        decode(p_cle_id,NULL,l_chr_id,NULL),
        Null,
        l_chr_id,
        Null,
        p_document_type,
        p_document_id,
        p_cle_id,
        p_source_flag,
        p_mandatory_yn,
        p_scn_id,
        p_label,
        p_amendment_description,
        p_amendment_operation_code,
        decode(p_document_type, OKC_TERMS_UTIL_GRP.G_TMPL_DOC_TYPE,NULL,p_article_version_id),
        p_change_nonstd_yn,
        p_orig_system_reference_code,
        p_orig_system_reference_id1,
        p_orig_system_reference_id2,
        p_display_sequence,
        p_attribute_category,
        p_attribute1,
        p_attribute2,
        p_attribute3,
        p_attribute4,
        p_attribute5,
        p_attribute6,
        p_attribute7,
        p_attribute8,
        p_attribute9,
        p_attribute10,
        p_attribute11,
        p_attribute12,
        p_attribute13,
        p_attribute14,
        p_attribute15,
        p_print_text_yn,
        p_summary_amend_operation_code,
        p_ref_article_id,
        p_ref_article_version_id,
        p_object_version_number,
        p_created_by,
        p_creation_date,
        p_last_updated_by,
        p_last_update_login,
        p_last_update_date,
        p_sav_sae_id,
        p_last_amended_by,
        p_last_amendment_date);
Line: 1789

       Okc_Debug.Log('3200: Leaving Insert_Row', 2);
Line: 1798

         Okc_Debug.Log('3300: Leaving Insert_Row:OTHERS Exception', 2);
Line: 1810

  END Insert_Row;
Line: 1815

  PROCEDURE Insert_Row(
    p_validation_level	         IN NUMBER,
    x_return_status              OUT NOCOPY VARCHAR2,
    p_id                         IN NUMBER,
    p_sav_sae_id                 IN NUMBER,
    p_cat_type                   IN VARCHAR2,--Bug 3341342
    p_document_type              IN VARCHAR2,
    p_document_id                IN NUMBER,
    p_cle_id                     IN NUMBER,
    p_source_flag                IN VARCHAR2,
    p_mandatory_yn               IN VARCHAR2,
    p_scn_id                     IN NUMBER,
    p_label                      IN VARCHAR2,
    p_amendment_description      IN VARCHAR2,
    p_amendment_operation_code   IN VARCHAR2,
    p_article_version_id         IN NUMBER,
    p_change_nonstd_yn           IN VARCHAR2,
    p_orig_system_reference_code IN VARCHAR2,
    p_orig_system_reference_id1  IN NUMBER,
    p_orig_system_reference_id2  IN NUMBER,
    p_display_sequence           IN NUMBER,
    p_attribute_category         IN VARCHAR2,
    p_attribute1                 IN VARCHAR2,
    p_attribute2                 IN VARCHAR2,
    p_attribute3                 IN VARCHAR2,
    p_attribute4                 IN VARCHAR2,
    p_attribute5                 IN VARCHAR2,
    p_attribute6                 IN VARCHAR2,
    p_attribute7                 IN VARCHAR2,
    p_attribute8                 IN VARCHAR2,
    p_attribute9                 IN VARCHAR2,
    p_attribute10                IN VARCHAR2,
    p_attribute11                IN VARCHAR2,
    p_attribute12                IN VARCHAR2,
    p_attribute13                IN VARCHAR2,
    p_attribute14                IN VARCHAR2,
    p_attribute15                IN VARCHAR2,
    p_print_text_yn              IN VARCHAR2,
    p_summary_amend_operation_code IN VARCHAR2,
    p_ref_article_id              IN NUMBER,
    p_ref_article_version_id      IN NUMBER,
    x_id                         OUT NOCOPY NUMBER

  ) IS

    l_object_version_number      OKC_K_ARTICLES_B.OBJECT_VERSION_NUMBER%TYPE;
Line: 1863

    l_last_updated_by            OKC_K_ARTICLES_B.LAST_UPDATED_BY%TYPE;
Line: 1864

    l_last_update_login          OKC_K_ARTICLES_B.LAST_UPDATE_LOGIN%TYPE;
Line: 1865

    l_last_update_date           OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE;
Line: 1873

       Okc_Debug.Log('3400: Entered Insert_Row', 2);
Line: 1896

    l_last_update_date := l_creation_date;
Line: 1897

    l_last_updated_by := l_created_by;
Line: 1898

    l_last_update_login := Fnd_Global.Login_Id;
Line: 1955

    x_return_status := Insert_Row(
      p_id                         => x_id,
      p_sav_sae_id                 => p_sav_sae_id,
      p_cat_type                   => p_cat_type, --Bug 3341342
      p_document_type              => p_document_type,
      p_document_id                => p_document_id,
      p_cle_id                     => p_cle_id,
      p_source_flag                => p_source_flag,
      p_mandatory_yn               => p_mandatory_yn,
      p_scn_id                     => p_scn_id,
      p_label                      => p_label,
      p_amendment_description      => p_amendment_description,
      p_amendment_operation_code   => p_amendment_operation_code,
      p_article_version_id         => p_article_version_id,
      p_change_nonstd_yn           => p_change_nonstd_yn,
      p_orig_system_reference_code => p_orig_system_reference_code,
      p_orig_system_reference_id1  => p_orig_system_reference_id1,
      p_orig_system_reference_id2  => p_orig_system_reference_id2,
      p_display_sequence           => p_display_sequence,
      p_attribute_category         => p_attribute_category,
      p_attribute1                 => p_attribute1,
      p_attribute2                 => p_attribute2,
      p_attribute3                 => p_attribute3,
      p_attribute4                 => p_attribute4,
      p_attribute5                 => p_attribute5,
      p_attribute6                 => p_attribute6,
      p_attribute7                 => p_attribute7,
      p_attribute8                 => p_attribute8,
      p_attribute9                 => p_attribute9,
      p_attribute10                => p_attribute10,
      p_attribute11                => p_attribute11,
      p_attribute12                => p_attribute12,
      p_attribute13                => p_attribute13,
      p_attribute14                => p_attribute14,
      p_attribute15                => p_attribute15,
      p_print_text_yn              => p_print_text_yn,
      p_summary_amend_operation_code=> p_summary_amend_operation_code,
      p_ref_article_id              => p_ref_article_id,
      p_ref_article_version_id      => p_ref_article_version_id,
      p_object_version_number      => l_object_version_number,
      p_created_by                 => l_created_by,
      p_creation_date              => l_creation_date,
      p_last_updated_by            => l_last_updated_by,
      p_last_update_login          => l_last_update_login,
      p_last_update_date           => l_last_update_date,
      p_last_amended_by            => l_last_amended_by,
      p_last_amendment_date        => l_last_amendment_date
    );
Line: 2010

       Okc_Debug.Log('3500: Leaving Insert_Row', 2);
Line: 2017

         Okc_Debug.Log('3600: Leaving Insert_Row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
Line: 2025

         Okc_Debug.Log('3700: Leaving Insert_Row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
Line: 2032

         Okc_Debug.Log('3800: Leaving Insert_Row because of EXCEPTION: '||sqlerrm, 2);
Line: 2043

  END Insert_Row;
Line: 2057

    SELECT object_version_number
      FROM OKC_K_ARTICLES_B
     WHERE ID = cp_id
       AND (object_version_number = cp_object_version_number OR cp_object_version_number IS NULL)
    FOR UPDATE OF object_version_number NOWAIT;
Line: 2064

    SELECT object_version_number
      FROM OKC_K_ARTICLES_B
     WHERE ID = cp_id;
Line: 2110

        Okc_Api.Set_Message(G_APP_NAME,G_LOCK_RECORD_DELETED,
                   'ENTITYNAME','OKC_K_ARTICLES_B',
                   'PKEY',p_id,
                   'OVN',p_object_version_number
                    );
Line: 2118

        Okc_Api.Set_Message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
Line: 2223

  FUNCTION Update_Row(
    p_id                         IN NUMBER,
    p_sav_sae_id                 IN NUMBER,
    p_document_type              IN VARCHAR2,
    p_document_id                IN NUMBER,
    p_cle_id                     IN NUMBER,
    p_source_flag                IN VARCHAR2,
    p_mandatory_yn               IN VARCHAR2,
    p_scn_id                     IN NUMBER,
    p_label                      IN VARCHAR2,
    p_amendment_description      IN VARCHAR2,
    p_amendment_operation_code   IN VARCHAR2,
    p_article_version_id         IN NUMBER,
    p_change_nonstd_yn           IN VARCHAR2,
    p_orig_system_reference_code IN VARCHAR2,
    p_orig_system_reference_id1  IN NUMBER,
    p_orig_system_reference_id2  IN NUMBER,
    p_display_sequence           IN NUMBER,
    p_attribute_category         IN VARCHAR2,
    p_attribute1                 IN VARCHAR2,
    p_attribute2                 IN VARCHAR2,
    p_attribute3                 IN VARCHAR2,
    p_attribute4                 IN VARCHAR2,
    p_attribute5                 IN VARCHAR2,
    p_attribute6                 IN VARCHAR2,
    p_attribute7                 IN VARCHAR2,
    p_attribute8                 IN VARCHAR2,
    p_attribute9                 IN VARCHAR2,
    p_attribute10                IN VARCHAR2,
    p_attribute11                IN VARCHAR2,
    p_attribute12                IN VARCHAR2,
    p_attribute13                IN VARCHAR2,
    p_attribute14                IN VARCHAR2,
    p_attribute15                IN VARCHAR2,
    p_print_text_yn              IN VARCHAR2,
    p_summary_amend_operation_code IN VARCHAR2,
    p_ref_article_id              IN NUMBER,
    p_ref_article_version_id      IN NUMBER,
    p_object_version_number      IN NUMBER,
    p_created_by                 IN NUMBER,
    p_creation_date              IN DATE,
    p_last_updated_by            IN NUMBER,
    p_last_update_login          IN NUMBER,
    p_last_update_date           IN DATE,
    p_last_amended_by            IN NUMBER,
    p_last_amendment_date        IN DATE
   ) RETURN VARCHAR2 IS

   l_chr_id   NUMBER;
Line: 2276

       Okc_Debug.Log('4800: Entered Update_Row', 2);
Line: 2282

    UPDATE OKC_K_ARTICLES_B
     SET SAV_SAE_ID                 = p_sav_sae_id,
         DOCUMENT_TYPE              = p_document_type,
         DOCUMENT_ID                = p_document_id,
         CLE_ID                     = p_cle_id,
         SOURCE_FLAG                = p_source_flag,
         MANDATORY_YN               = p_mandatory_yn,
         SCN_ID                     = p_scn_id,
         CHR_ID                     = decode(p_cle_id,NULL,l_chr_id,NULL),
         DNZ_CHR_ID                 = l_chr_id,
         LABEL                      = p_label,
         AMENDMENT_DESCRIPTION      = p_amendment_description,
         AMENDMENT_OPERATION_CODE   = p_amendment_operation_code,
         ARTICLE_VERSION_ID         = decode(p_document_type,OKC_TERMS_UTIL_GRP.G_TMPL_DOC_TYPE,NULL,p_article_version_id),
         CHANGE_NONSTD_YN           = p_change_nonstd_yn,
         ORIG_SYSTEM_REFERENCE_CODE = p_orig_system_reference_code,
         ORIG_SYSTEM_REFERENCE_ID1  = p_orig_system_reference_id1,
         ORIG_SYSTEM_REFERENCE_ID2  = p_orig_system_reference_id2,
         DISPLAY_SEQUENCE           = p_display_sequence,
         ATTRIBUTE_CATEGORY         = p_attribute_category,
         ATTRIBUTE1                 = p_attribute1,
         ATTRIBUTE2                 = p_attribute2,
         ATTRIBUTE3                 = p_attribute3,
         ATTRIBUTE4                 = p_attribute4,
         ATTRIBUTE5                 = p_attribute5,
         ATTRIBUTE6                 = p_attribute6,
         ATTRIBUTE7                 = p_attribute7,
         ATTRIBUTE8                 = p_attribute8,
         ATTRIBUTE9                 = p_attribute9,
         ATTRIBUTE10                = p_attribute10,
         ATTRIBUTE11                = p_attribute11,
         ATTRIBUTE12                = p_attribute12,
         ATTRIBUTE13                = p_attribute13,
         ATTRIBUTE14                = p_attribute14,
         ATTRIBUTE15                = p_attribute15,
         PRINT_TEXT_YN              = p_print_text_yn,
         SUMMARY_AMEND_OPERATION_CODE= p_summary_amend_operation_code,
         REF_ARTICLE_ID             = p_ref_article_id,
         REF_ARTICLE_VERSION_ID     = p_ref_article_version_id,
         OBJECT_VERSION_NUMBER      = p_object_version_number,
         LAST_UPDATED_BY            = p_last_updated_by,
         LAST_UPDATE_LOGIN          = p_last_update_login,
         LAST_UPDATE_DATE           = p_last_update_date,
         LAST_AMENDED_BY            = p_last_amended_by,
         LAST_AMENDMENT_DATE        = p_last_amendment_date
    WHERE ID                        = p_id;
Line: 2330

       Okc_Debug.Log('4900: Leaving Update_Row', 2);
Line: 2339

         Okc_Debug.Log('5000: Leaving Update_Row because of EXCEPTION: '||sqlerrm, 2);
Line: 2351

  END Update_Row;
Line: 2355

  PROCEDURE Update_Row(
    p_validation_level	         IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
    x_return_status              OUT NOCOPY VARCHAR2,
    p_id                         IN NUMBER,
    p_sav_sae_id                 IN NUMBER,
    p_document_type              IN VARCHAR2,
    p_document_id                IN NUMBER,
    p_cle_id                     IN NUMBER,
    p_source_flag                IN VARCHAR2,
    p_mandatory_yn               IN VARCHAR2,
    p_scn_id                     IN NUMBER,
    p_label                      IN VARCHAR2,
    p_amendment_description      IN VARCHAR2,
    p_amendment_operation_code   IN VARCHAR2,
    p_article_version_id         IN NUMBER,
    p_change_nonstd_yn           IN VARCHAR2,
    p_orig_system_reference_code IN VARCHAR2,
    p_orig_system_reference_id1  IN NUMBER,
    p_orig_system_reference_id2  IN NUMBER,
    p_display_sequence           IN NUMBER,
    p_attribute_category         IN VARCHAR2,
    p_attribute1                 IN VARCHAR2,
    p_attribute2                 IN VARCHAR2,
    p_attribute3                 IN VARCHAR2,
    p_attribute4                 IN VARCHAR2,
    p_attribute5                 IN VARCHAR2,
    p_attribute6                 IN VARCHAR2,
    p_attribute7                 IN VARCHAR2,
    p_attribute8                 IN VARCHAR2,
    p_attribute9                 IN VARCHAR2,
    p_attribute10                IN VARCHAR2,
    p_attribute11                IN VARCHAR2,
    p_attribute12                IN VARCHAR2,
    p_attribute13                IN VARCHAR2,
    p_attribute14                IN VARCHAR2,
    p_attribute15                IN VARCHAR2,
    p_print_text_yn              IN VARCHAR2,
    p_summary_amend_operation_code IN VARCHAR2,
    p_ref_article_id              IN NUMBER,
    p_ref_article_version_id      IN NUMBER,
    p_object_version_number      IN NUMBER,
    p_last_amended_by            IN NUMBER,
    p_last_amendment_date        IN DATE

   ) IS

    l_sav_sae_id                 OKC_K_ARTICLES_B.SAV_SAE_ID%TYPE;
Line: 2440

    l_last_updated_by            OKC_K_ARTICLES_B.LAST_UPDATED_BY%TYPE;
Line: 2441

    l_last_update_login          OKC_K_ARTICLES_B.LAST_UPDATE_LOGIN%TYPE;
Line: 2442

    l_last_update_date           OKC_K_ARTICLES_B.LAST_UPDATE_DATE%TYPE;
Line: 2449

       Okc_Debug.Log('5100: Entered Update_Row', 2);
Line: 2612

    l_last_update_date := SYSDATE;
Line: 2613

    l_last_updated_by := FND_GLOBAL.USER_ID;
Line: 2614

    l_last_update_login := FND_GLOBAL.LOGIN_ID;
Line: 2628

    x_return_status := Update_Row(
      p_id                         => p_id,
      p_sav_sae_id                 => l_sav_sae_id,
      p_document_type              => l_document_type,
      p_document_id                => l_document_id,
      p_cle_id                     => l_cle_id,
      p_source_flag                => l_source_flag,
      p_mandatory_yn               => l_mandatory_yn,
      p_scn_id                     => l_scn_id,
      p_label                      => l_label,
      p_amendment_description      => l_amendment_description,
      p_amendment_operation_code   => l_amendment_operation_code,
      p_article_version_id         => l_article_version_id,
      p_change_nonstd_yn           => l_change_nonstd_yn,
      p_orig_system_reference_code => l_orig_system_reference_code,
      p_orig_system_reference_id1  => l_orig_system_reference_id1,
      p_orig_system_reference_id2  => l_orig_system_reference_id2,
      p_display_sequence           => l_display_sequence,
      p_attribute_category         => l_attribute_category,
      p_attribute1                 => l_attribute1,
      p_attribute2                 => l_attribute2,
      p_attribute3                 => l_attribute3,
      p_attribute4                 => l_attribute4,
      p_attribute5                 => l_attribute5,
      p_attribute6                 => l_attribute6,
      p_attribute7                 => l_attribute7,
      p_attribute8                 => l_attribute8,
      p_attribute9                 => l_attribute9,
      p_attribute10                => l_attribute10,
      p_attribute11                => l_attribute11,
      p_attribute12                => l_attribute12,
      p_attribute13                => l_attribute13,
      p_attribute14                => l_attribute14,
      p_attribute15                => l_attribute15,
      p_print_text_yn              => l_print_text_yn,
      p_summary_amend_operation_code => l_summary_amend_operation_code,
      p_ref_article_id              => l_ref_article_id,
      p_ref_article_version_id      => l_ref_article_version_id,
      p_object_version_number      => l_object_version_number,
      p_created_by                 => l_created_by,
      p_creation_date              => l_creation_date,
      p_last_updated_by            => l_last_updated_by,
      p_last_update_login          => l_last_update_login,
      p_last_update_date           => l_last_update_date,
      p_last_amended_by            => l_last_amended_by,
      p_last_amendment_date        => l_last_amendment_date
    );
Line: 2682

      Okc_Debug.Log('5700: Leaving Update_Row', 2);
Line: 2689

        Okc_Debug.Log('5800: Leaving Update_Row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
Line: 2696

        Okc_Debug.Log('5900: Leaving Update_Row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
Line: 2703

        Okc_Debug.Log('6000: Leaving Update_Row because of EXCEPTION: '||sqlerrm, 2);
Line: 2715

  END Update_Row;
Line: 2723

  FUNCTION Delete_Row(
    p_id                         IN NUMBER
  ) RETURN VARCHAR2 IS

  BEGIN

    IF (l_debug = 'Y') THEN
       Okc_Debug.Log('6100: Entered Delete_Row', 2);
Line: 2733

    DELETE FROM OKC_K_ARTICLES_B WHERE ID = p_ID;
Line: 2736

       Okc_Debug.Log('6200: Leaving Delete_Row', 2);
Line: 2745

         Okc_Debug.Log('6300: Leaving Delete_Row because of EXCEPTION: '||sqlerrm, 2);
Line: 2757

  END Delete_Row;
Line: 2761

  PROCEDURE Delete_Row(
    x_return_status                OUT NOCOPY VARCHAR2,
    p_id                         IN NUMBER,
    p_object_version_number      IN NUMBER
  ) IS

  l_standard_yn VARCHAR2(1) := 'Y';
Line: 2776

    SELECT art.standard_yn,
           kart.sav_sae_id,
           kart.article_version_id
    FROM okc_k_articles_b kart,
         okc_articles_all art
    WHERE kart.id = cp_id
    AND art.article_id = kart.sav_sae_id;
Line: 2785

    SELECT 'Y'
    FROM okc_k_articles_b
    WHERE article_version_id = cp_article_version_id
    UNION ALL
    SELECT 'Y'
    FROM OKC_K_ARTICLES_BH
    WHERE article_version_id = cp_article_version_id;
Line: 2796

       Okc_Debug.Log('6400: Entered Delete_Row', 2);
Line: 2813

    x_return_status := Delete_Row( p_id => p_id );
Line: 2824

        OKC_ARTICLES_GRP.delete_article(
                         p_api_version          => 1,
                         p_init_msg_list        => FND_API.G_FALSE,

                         x_return_status        => l_return_status,
                         x_msg_count            => l_msg_count,
                         x_msg_data             => l_msg_data,

                         p_article_id           => l_article_id,
                         p_article_version_id   => l_article_version_id);
Line: 2848

       Okc_Debug.Log('6500: Leaving Delete_Row', 2);
Line: 2855

         Okc_Debug.Log('6600: Leaving Delete_Row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
Line: 2863

         Okc_Debug.Log('6700: Leaving Delete_Row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
Line: 2871

         Okc_Debug.Log('6800: Leaving Delete_Row because of EXCEPTION: '||sqlerrm, 2);
Line: 2883

  END Delete_Row;
Line: 2885

PROCEDURE delete_set(
    x_return_status          OUT NOCOPY VARCHAR2,
    p_scn_id                 IN NUMBER
) IS
  CURSOR lock_csr IS
    SELECT rowid
    FROM OKC_K_ARTICLES_B
    WHERE SCN_ID=P_SCN_ID
    FOR UPDATE NOWAIT;
Line: 2896

       Okc_Debug.Log('9700: Entered Delete_Set', 2);
Line: 2903

    DELETE FROM OKC_K_ARTICLES_B
    WHERE SCN_ID=P_SCN_ID;
Line: 2907

       Okc_Debug.Log('11000: Leaving Delete_set', 2);
Line: 2913

         Okc_Debug.Log('000: Leaving Delete_set:E_Resource_Busy Exception', 2);
Line: 2924

         Okc_Debug.Log('11100: Leaving Delete_Set:FND_API.G_EXC_ERROR Exception', 2);
Line: 2934

         Okc_Debug.Log('11200: Leaving Delete_Set:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
Line: 2944

         Okc_Debug.Log('11300: Leaving Delete_Set because of EXCEPTION: '||sqlerrm, 2);
Line: 2958

END delete_set;
Line: 2960

PROCEDURE delete_set(
    x_return_status          OUT NOCOPY VARCHAR2,
    p_doc_type               IN VARCHAR2,
    p_doc_id                 IN NUMBER
) IS
    CURSOR lock_csr IS
    SELECT rowid
    FROM OKC_K_ARTICLES_B
    WHERE DOCUMENT_TYPE=p_doc_type
    AND DOCUMENT_ID = p_doc_id
    FOR UPDATE NOWAIT;
Line: 2974

       Okc_Debug.Log('9700: Entered Delete_Set', 2);
Line: 2983

    DELETE FROM OKC_K_ARTICLES_B
    WHERE DOCUMENT_TYPE=p_doc_type
    AND DOCUMENT_ID = p_doc_id;
Line: 2988

       Okc_Debug.Log('11000: Leaving Delete_set', 2);
Line: 2994

         Okc_Debug.Log('000: Leaving Delete_set:E_Resource_Busy Exception', 2);
Line: 3005

         Okc_Debug.Log('11100: Leaving Delete_Set:FND_API.G_EXC_ERROR Exception', 2);
Line: 3015

         Okc_Debug.Log('11200: Leaving Delete_Set:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
Line: 3025

         Okc_Debug.Log('11300: Leaving Delete_Set because of EXCEPTION: '||sqlerrm, 2);
Line: 3039

END delete_set;
Line: 3057

    SELECT KART.ID,
        KART.SAV_SAE_ID,
        KART.ARTICLE_VERSION_ID
      FROM OKC_K_ARTICLES_B KART,
           OKC_ARTICLES_ALL ART
      WHERE KART.document_type = p_doc_type
      AND   KART.document_id = p_doc_id
      AND   KART.SAV_SAE_ID = ART.ARTICLE_ID
      AND   ART.STANDARD_YN = 'N';
Line: 3076

    INSERT INTO OKC_K_ARTICLES_BH (
        major_version,
        ID,
        SAV_SAE_ID,
        SAV_SAV_RELEASE,
        SBT_CODE,
        CAT_TYPE,
        CHR_ID,
        CAT_ID,
        DNZ_CHR_ID,
        FULLTEXT_YN,
        DOCUMENT_TYPE,
        DOCUMENT_ID,
        CLE_ID,
        SOURCE_FLAG,
        MANDATORY_YN,
        SCN_ID,
        LABEL,
        AMENDMENT_DESCRIPTION,
        AMENDMENT_OPERATION_CODE,
        ARTICLE_VERSION_ID,
        CHANGE_NONSTD_YN,
        ORIG_SYSTEM_REFERENCE_CODE,
        ORIG_SYSTEM_REFERENCE_ID1,
        ORIG_SYSTEM_REFERENCE_ID2,
        DISPLAY_SEQUENCE,
        ATTRIBUTE_CATEGORY,
        ATTRIBUTE1,
        ATTRIBUTE2,
        ATTRIBUTE3,
        ATTRIBUTE4,
        ATTRIBUTE5,
        ATTRIBUTE6,
        ATTRIBUTE7,
        ATTRIBUTE8,
        ATTRIBUTE9,
        ATTRIBUTE10,
        ATTRIBUTE11,
        ATTRIBUTE12,
        ATTRIBUTE13,
        ATTRIBUTE14,
        ATTRIBUTE15,
        PRINT_TEXT_YN,
        SUMMARY_AMEND_OPERATION_CODE,
        REF_ARTICLE_ID,
        REF_ARTICLE_VERSION_ID,
        OBJECT_VERSION_NUMBER,
        CREATED_BY,
        CREATION_DATE,
        LAST_UPDATED_BY,
        LAST_UPDATE_LOGIN,
        LAST_UPDATE_DATE,
        ORIG_ARTICLE_ID,
        LAST_AMENDED_BY,
        LAST_AMENDMENT_DATE)
     SELECT
        p_major_version,
        ID,
        SAV_SAE_ID,
        SAV_SAV_RELEASE,
        SBT_CODE,
        CAT_TYPE,
        CHR_ID,
        CAT_ID,
        DNZ_CHR_ID,
        FULLTEXT_YN,
        DOCUMENT_TYPE,
        DOCUMENT_ID,
        CLE_ID,
        SOURCE_FLAG,
        MANDATORY_YN,
        SCN_ID,
        LABEL,
        AMENDMENT_DESCRIPTION,
        AMENDMENT_OPERATION_CODE,
        ARTICLE_VERSION_ID,
        CHANGE_NONSTD_YN,
        ORIG_SYSTEM_REFERENCE_CODE,
        ORIG_SYSTEM_REFERENCE_ID1,
        ORIG_SYSTEM_REFERENCE_ID2,
        DISPLAY_SEQUENCE,
        ATTRIBUTE_CATEGORY,
        ATTRIBUTE1,
        ATTRIBUTE2,
        ATTRIBUTE3,
        ATTRIBUTE4,
        ATTRIBUTE5,
        ATTRIBUTE6,
        ATTRIBUTE7,
        ATTRIBUTE8,
        ATTRIBUTE9,
        ATTRIBUTE10,
        ATTRIBUTE11,
        ATTRIBUTE12,
        ATTRIBUTE13,
        ATTRIBUTE14,
        ATTRIBUTE15,
        PRINT_TEXT_YN,
        SUMMARY_AMEND_OPERATION_CODE,
        REF_ARTICLE_ID,
        REF_ARTICLE_VERSION_ID,
        OBJECT_VERSION_NUMBER,
        CREATED_BY,
        CREATION_DATE,
        LAST_UPDATED_BY,
        LAST_UPDATE_LOGIN,
        LAST_UPDATE_DATE,
        ORIG_ARTICLE_ID,
        LAST_AMENDED_BY,
        LAST_AMENDMENT_DATE
      FROM OKC_K_ARTICLES_B
      WHERE document_type = p_doc_type
      AND   document_id = p_doc_id;
Line: 3227

      UPDATE OKC_K_ARTICLES_B
      SET  SAV_SAE_ID = l_article_id,
        ARTICLE_VERSION_ID = l_article_version_id
      WHERE ID = rec.id;
Line: 3305

    INSERT INTO OKC_K_ARTICLES_B (
        ID,
        SAV_SAE_ID,
        SAV_SAV_RELEASE,
        SBT_CODE,
        CAT_TYPE,
        CHR_ID,
        CLE_ID,
        CAT_ID,
        DNZ_CHR_ID,
        FULLTEXT_YN,
        DOCUMENT_TYPE,
        DOCUMENT_ID,
        SOURCE_FLAG,
        MANDATORY_YN,
        SCN_ID,
        LABEL,
        AMENDMENT_DESCRIPTION,
        AMENDMENT_OPERATION_CODE,
        ARTICLE_VERSION_ID,
        CHANGE_NONSTD_YN,
        ORIG_SYSTEM_REFERENCE_CODE,
        ORIG_SYSTEM_REFERENCE_ID1,
        ORIG_SYSTEM_REFERENCE_ID2,
        DISPLAY_SEQUENCE,
        ATTRIBUTE_CATEGORY,
        ATTRIBUTE1,
        ATTRIBUTE2,
        ATTRIBUTE3,
        ATTRIBUTE4,
        ATTRIBUTE5,
        ATTRIBUTE6,
        ATTRIBUTE7,
        ATTRIBUTE8,
        ATTRIBUTE9,
        ATTRIBUTE10,
        ATTRIBUTE11,
        ATTRIBUTE12,
        ATTRIBUTE13,
        ATTRIBUTE14,
        ATTRIBUTE15,
        PRINT_TEXT_YN,
        SUMMARY_AMEND_OPERATION_CODE,
        REF_ARTICLE_ID,
        REF_ARTICLE_VERSION_ID,
        OBJECT_VERSION_NUMBER,
        CREATED_BY,
        CREATION_DATE,
        LAST_UPDATED_BY,
        LAST_UPDATE_LOGIN,
        LAST_UPDATE_DATE,
        ORIG_ARTICLE_ID,
        LAST_AMENDED_BY,
        LAST_AMENDMENT_DATE)
     SELECT
        ID,
        SAV_SAE_ID,
        SAV_SAV_RELEASE,
        SBT_CODE,
        CAT_TYPE,
        CHR_ID,
        CLE_ID,
        CAT_ID,
        DNZ_CHR_ID,
        FULLTEXT_YN,
        DOCUMENT_TYPE,
        DOCUMENT_ID,
        SOURCE_FLAG,
        MANDATORY_YN,
        SCN_ID,
        LABEL,
        AMENDMENT_DESCRIPTION,
        AMENDMENT_OPERATION_CODE,
        ARTICLE_VERSION_ID,
        CHANGE_NONSTD_YN,
        ORIG_SYSTEM_REFERENCE_CODE,
        ORIG_SYSTEM_REFERENCE_ID1,
        ORIG_SYSTEM_REFERENCE_ID2,
        DISPLAY_SEQUENCE,
        ATTRIBUTE_CATEGORY,
        ATTRIBUTE1,
        ATTRIBUTE2,
        ATTRIBUTE3,
        ATTRIBUTE4,
        ATTRIBUTE5,
        ATTRIBUTE6,
        ATTRIBUTE7,
        ATTRIBUTE8,
        ATTRIBUTE9,
        ATTRIBUTE10,
        ATTRIBUTE11,
        ATTRIBUTE12,
        ATTRIBUTE13,
        ATTRIBUTE14,
        ATTRIBUTE15,
        PRINT_TEXT_YN,
        SUMMARY_AMEND_OPERATION_CODE,
        REF_ARTICLE_ID,
        REF_ARTICLE_VERSION_ID,
        OBJECT_VERSION_NUMBER,
        CREATED_BY,
        CREATION_DATE,
        LAST_UPDATED_BY,
        LAST_UPDATE_LOGIN,
        LAST_UPDATE_DATE,
        ORIG_ARTICLE_ID,
        LAST_AMENDED_BY,
        LAST_AMENDMENT_DATE
      FROM OKC_K_ARTICLES_BH
      WHERE document_type = p_doc_type
      AND document_id = p_doc_id
      AND major_version = p_major_version;
Line: 3445

  FUNCTION Delete_Version(
    p_doc_type                     IN VARCHAR2,
    p_doc_id                       IN NUMBER,
    p_major_version                IN NUMBER
  ) RETURN VARCHAR2 IS

  BEGIN

    IF (l_debug = 'Y') THEN
       Okc_Debug.Log('7200: Entered Delete_Version', 2);
Line: 3460

    DELETE
      FROM OKC_K_ARTICLES_BH
      WHERE document_type = p_doc_type
      AND document_id = p_doc_id
      AND major_version = p_major_version;
Line: 3467

       Okc_Debug.Log('7300: Leaving Delete_Version', 2);
Line: 3476

       Okc_Debug.Log('7400: Leaving Delete_Version because of EXCEPTION: '||sqlerrm, 2);
Line: 3488

  END Delete_Version;