APPS.OKC_TERMS_VERSION_PVT SQL Statements

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

Line: 10

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

Line: 46

     SELECT id, object_version_number,amendment_operation_code,summary_amend_operation_code
       FROM okc_sections_b
      WHERE document_type = p_doc_type AND document_id = p_doc_id
       AND (amendment_operation_code IS NOT NULL OR amendment_description IS NOT NULL OR summary_amend_operation_code IS NOT NULL);

Line: 52

     SELECT kart.id, kart.object_version_number,kart.amendment_operation_code,kart.summary_amend_operation_code,
            DECODE(art.standard_yn,'N','Y',NULL) change_nonstd_yn
       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 (kart.amendment_operation_code IS NOT NULL OR kart.amendment_description IS NOT NULL
            OR kart.summary_amend_operation_code IS NOT NULL OR art.standard_yn='N');

Line: 61

     SELECT id, object_version_number, amendment_operation_code
       FROM okc_sections_b
      WHERE document_type = p_doc_type AND document_id = p_doc_id
       AND (amendment_operation_code IS NOT NULL OR amendment_description IS NOT NULL);

Line: 67

     SELECT id, object_version_number
       FROM okc_sections_b
      WHERE document_type = p_doc_type AND document_id = p_doc_id
       AND amendment_operation_code = G_AMEND_CODE_DELETED
       AND SUMMARY_AMEND_OPERATION_CODE  IS NULL;

Line: 74

     SELECT id, kart.object_version_number, amendment_operation_code,standard_yn
       FROM okc_k_articles_b kart,okc_articles_all
      WHERE document_type = p_doc_type AND document_id = p_doc_id
       AND  sav_sae_id = article_id
       AND (amendment_operation_code IS NOT NULL
         OR standard_yn='N');

Line: 82

     SELECT id, object_version_number
       FROM okc_k_articles_b
      WHERE document_type = p_doc_type AND document_id = p_doc_id
       AND amendment_operation_code = G_AMEND_CODE_DELETED
       AND SUMMARY_AMEND_OPERATION_CODE  IS NULL;

Line: 91

      SELECT contract_source_code
	  FROM okc_template_usages
	  WHERE document_type = p_doc_type AND document_id = p_doc_id;

Line: 118

    IF cr.amendment_operation_code=G_AMEND_CODE_DELETED OR
       cr.summary_amend_operation_code=G_AMEND_CODE_DELETED THEN
        --------------------------------------------
        -- Delete section
        --------------------------------------------
        Okc_Terms_Sections_Pvt.delete_row(
          x_return_status         => x_return_status,
          p_id                    => cr.id,
          p_object_version_number => cr.object_version_number
        );

Line: 139

        Okc_K_Articles_Pvt.Delete_Set(
          x_return_status         => x_return_status,
          p_scn_id                => cr.id
        );

Line: 154

        Okc_K_Art_Variables_Pvt.Delete_Set(
          x_return_status         => x_return_status,
          p_scn_id                => cr.id
        );

Line: 168

        Okc_Terms_Sections_Pvt.Update_Row(
          x_return_status            => x_return_status,
          p_id                       => cr.id,
          p_amendment_operation_code => G_MISS_CHAR,
          p_summary_amend_operation_code => G_MISS_CHAR,
          p_amendment_description    => G_MISS_CHAR,
          p_last_amendment_date      => G_MISS_DATE,
          p_last_amended_by          => G_MISS_NUM,
          p_object_version_number    => cr.object_version_number
        );

Line: 190

    IF cr.amendment_operation_code=G_AMEND_CODE_DELETED OR
       cr.summary_amend_operation_code=G_AMEND_CODE_DELETED THEN

        --------------------------------------------
        -- Delete article
        --------------------------------------------
        Okc_k_articles_pvt.delete_row(
          x_return_status         => x_return_status,
          p_id                    => cr.id,
          p_object_version_number => cr.object_version_number
        );

Line: 212

        Okc_K_Art_Variables_Pvt.Delete_Set(
          x_return_status         => x_return_status,
          p_cat_id                => cr.id
        );

Line: 227

        Okc_k_articles_pvt.Update_Row(
          x_return_status            => x_return_status,
          p_id                       => cr.id,
          p_amendment_operation_code => G_MISS_CHAR,
          p_change_nonstd_yn         => cr.change_nonstd_yn,
          p_summary_amend_operation_code => G_MISS_CHAR,
          p_amendment_description    => G_MISS_CHAR,
          p_last_amendment_date      => G_MISS_DATE,
          p_last_amended_by          => G_MISS_NUM,
          p_print_text_yn            => 'N',
          p_object_version_number    => cr.object_version_number
        );

Line: 264

        Okc_Terms_Sections_Pvt.delete_row(
          x_return_status         => x_return_status,
          p_id                    => cr.id,
          p_object_version_number => cr.object_version_number
        );

Line: 280

        Okc_K_Articles_Pvt.Delete_Set(
          x_return_status         => x_return_status,
          p_scn_id                => cr.id
        );

Line: 295

        Okc_K_Art_Variables_Pvt.Delete_Set(
          x_return_status         => x_return_status,
          p_scn_id                => cr.id
        );

Line: 312

        Okc_K_Articles_Pvt.Delete_Row(
          x_return_status         => x_return_status,
          p_id                    => cr.id,
          p_object_version_number => cr.object_version_number
        );

Line: 328

        Okc_K_Art_Variables_Pvt.Delete_Set(
          x_return_status         => x_return_status,
          p_cat_id                => cr.id
        );

Line: 345

        Okc_Terms_Sections_Pvt.Update_Row(
          x_return_status            => x_return_status,
          p_id                       => cr.id,
          p_amendment_operation_code => G_MISS_CHAR,
          p_last_amendment_date      => G_MISS_DATE,
          p_last_amended_by          => G_MISS_NUM,
          p_object_version_number    => cr.object_version_number
        );

Line: 363

         select decode(cr.standard_yn,'N','Y',NULL)
                into l_change_nonstd from dual;

Line: 368

            Okc_K_Articles_Pvt.Update_Row(
              x_return_status            => x_return_status,
              p_id                       => cr.id,
              p_amendment_operation_code => G_MISS_CHAR,
              p_change_nonstd_yn         => l_change_nonstd,
              p_last_amendment_date      => G_MISS_DATE,
              p_last_amended_by          => G_MISS_NUM,
              p_object_version_number    => cr.object_version_number
            );

Line: 396

       OKC_TEMPLATE_USAGES_PVT.update_row(
	      p_validation_level => FND_API.G_VALID_LEVEL_FULL,
		 x_return_status => x_return_status,
	      p_document_type => p_doc_type,
		 p_document_id => p_doc_id,
		 p_source_change_allowed_flag => 'N');

Line: 481

     SELECT id, object_version_number, amendment_operation_code
       FROM okc_sections_b
      WHERE document_type = p_doc_type AND document_id = p_doc_id
       AND (amendment_operation_code IS NOT NULL OR amendment_description IS NOT NULL);

Line: 487

     SELECT id, object_version_number
       FROM okc_sections_b
      WHERE document_type = p_doc_type AND document_id = p_doc_id
       AND amendment_operation_code = G_AMEND_CODE_DELETED
       AND SUMMARY_AMEND_OPERATION_CODE  IS NULL;

Line: 494

     SELECT id, kart.object_version_number, amendment_operation_code,standard_yn
       FROM okc_k_articles_b kart,okc_articles_all
      WHERE document_type = p_doc_type AND document_id = p_doc_id
       AND  sav_sae_id = article_id
       AND (amendment_operation_code IS NOT NULL
         OR standard_yn='N');

Line: 502

     SELECT id, object_version_number
       FROM okc_k_articles_b
      WHERE document_type = p_doc_type AND document_id = p_doc_id
       AND amendment_operation_code = G_AMEND_CODE_DELETED
       AND SUMMARY_AMEND_OPERATION_CODE  IS NULL;

Line: 620

        Okc_Terms_Sections_Pvt.delete_row(
          x_return_status         => x_return_status,
          p_id                    => cr.id,
          p_object_version_number => cr.object_version_number
        );

Line: 636

        Okc_K_Articles_Pvt.Delete_Set(
          x_return_status         => x_return_status,
          p_scn_id                => cr.id
        );

Line: 651

        Okc_K_Art_Variables_Pvt.Delete_Set(
          x_return_status         => x_return_status,
          p_scn_id                => cr.id
        );

Line: 668

        Okc_K_Articles_Pvt.Delete_Row(
          x_return_status         => x_return_status,
          p_id                    => cr.id,
          p_object_version_number => cr.object_version_number
        );

Line: 684

        Okc_K_Art_Variables_Pvt.Delete_Set(
          x_return_status         => x_return_status,
          p_cat_id                => cr.id
        );

Line: 701

        Okc_Terms_Sections_Pvt.Update_Row(
          x_return_status            => x_return_status,
          p_id                       => cr.id,
          p_amendment_operation_code => G_MISS_CHAR,
          p_object_version_number    => cr.object_version_number
        );

Line: 717

         select decode(cr.standard_yn,'N','Y',NULL)
                into l_change_nonstd from dual;

Line: 722

            Okc_K_Articles_Pvt.Update_Row(
              x_return_status            => x_return_status,
              p_id                       => cr.id,
              p_amendment_operation_code => G_MISS_CHAR,
              p_change_nonstd_yn         => l_change_nonstd,
              p_object_version_number    => cr.object_version_number
            );

Line: 954

  Procedure Delete_Doc_Version (
    x_return_status    OUT NOCOPY VARCHAR2,

    p_doc_type         IN  VARCHAR2,
    p_doc_id           IN  NUMBER,
    p_version_number   IN  NUMBER
   ) IS
    l_api_name          CONSTANT VARCHAR2(30) := 'Delete_Doc_Version';

Line: 965

       Okc_Debug.Log('100: Entered Delete_Doc_Version', 2);

Line: 966

       Okc_Debug.Log('100: Call Delete_Version for sections', 2);

Line: 971

             G_PKG_NAME, '100: Entered Delete_Doc_Version');

Line: 973

             G_PKG_NAME, '100: Call Delete_Version for sections');

Line: 980

    x_return_status := OKC_TERMS_SECTIONS_PVT.Delete_Version(
      p_doc_type         => p_doc_type,
      p_doc_id           => p_doc_id,
      p_major_version    => p_version_number
    );

Line: 1002

             G_PKG_NAME, '100: Call Delete_Version for article variables');

Line: 1004

    x_return_status := OKC_K_ART_VARIABLES_PVT.Delete_Version(
      p_doc_type         => p_doc_type,
      p_doc_id           => p_doc_id,
      p_major_version    => p_version_number
    );

Line: 1023

             G_PKG_NAME, '100: Call Delete_Version for articles');

Line: 1025

    x_return_status := OKC_K_ARTICLES_PVT.Delete_Version(
      p_doc_type         => p_doc_type,
      p_doc_id           => p_doc_id,
      p_major_version    => p_version_number
    );

Line: 1042

       Okc_Debug.Log('100: Call Delete_Version for template usages', 2);

Line: 1047

           G_PKG_NAME, '100: Call Delete_Version for template usages' );

Line: 1049

    x_return_status := OKC_TEMPLATE_USAGES_PVT.Delete_Version(
      p_doc_type         => p_doc_type,
      p_doc_id           => p_doc_id,
      p_major_version    => p_version_number
    );

Line: 1064

     Okc_Debug.Log('300: Leaving Delete_Doc_Version', 2);

Line: 1069

           G_PKG_NAME, '300: Leaving Delete_Doc_Version' );

Line: 1075

         okc_debug.log('400: Leaving Delete_Doc_Version : OKC_API.G_EXCEPTION_ERROR Exception', 2);

Line: 1080

             G_PKG_NAME, '400: Leaving Delete_Doc_Version : OKC_API.G_EXCEPTION_ERROR Exception' );

Line: 1086

         okc_debug.log('500: Leaving Delete_Doc_Version : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

Line: 1091

             G_PKG_NAME, '500: Leaving Delete_Doc_Version : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );

Line: 1097

        okc_debug.log('600: Leaving Delete_Doc_Version because of EXCEPTION: '||sqlerrm, 2);

Line: 1102

             G_PKG_NAME, '600: Leaving Delete_Doc_Version because of EXCEPTION: '||sqlerrm );

Line: 1109

  END Delete_Doc_Version ;