APPS.OKC_DOC_QA_LIST_GRP SQL Statements

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

Line: 137

  PROCEDURE Insert_Doc_Qa_List(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    p_validation_level	           IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
    p_commit                       IN VARCHAR2 := FND_API.G_FALSE,

    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,

    p_qa_code               IN VARCHAR2,
    p_document_type         IN VARCHAR2,
    p_severity_flag         IN VARCHAR2,
    p_enable_qa_yn          IN VARCHAR2,



    x_qa_code               OUT NOCOPY VARCHAR2,
    x_document_type         OUT NOCOPY VARCHAR2

  ) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 164

    l_last_updated_by       OKC_DOC_QA_LISTS.LAST_UPDATED_BY%TYPE;

Line: 165

    l_last_update_login     OKC_DOC_QA_LISTS.LAST_UPDATE_LOGIN%TYPE;

Line: 166

    l_last_update_date      OKC_DOC_QA_LISTS.LAST_UPDATE_DATE%TYPE;

Line: 170

       okc_debug.log('600: Entered Insert_Doc_Qa_List', 2);

Line: 174

    SAVEPOINT g_Insert_Doc_Qa_List_GRP;

Line: 189

    OKC_DOC_QA_LIST_PVT.Insert_Row(
      p_validation_level           =>   p_validation_level,
      x_return_status              =>   x_return_status,
      p_qa_code               => p_qa_code,
      p_document_type         => p_document_type,
      p_severity_flag         => p_severity_flag,
      p_enable_qa_yn          => p_enable_qa_yn,
      x_qa_code               => x_qa_code,
      x_document_type         => x_document_type
    );

Line: 215

       okc_debug.log('700: Leaving Insert_Doc_Qa_List', 2);

Line: 221

         okc_debug.log('800: Leaving Insert_Doc_Qa_List: OKC_API.G_EXCEPTION_ERROR Exception', 2);

Line: 223

      ROLLBACK TO g_Insert_Doc_Qa_List_GRP;

Line: 229

         okc_debug.log('900: Leaving Insert_Doc_Qa_List: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

Line: 231

      ROLLBACK TO g_Insert_Doc_Qa_List_GRP;

Line: 237

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

Line: 240

      ROLLBACK TO g_Insert_Doc_Qa_List_GRP;

Line: 247

  END Insert_Doc_Qa_List;

Line: 341

  PROCEDURE Update_Doc_Qa_List(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    p_validation_level	           IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
    p_commit                       IN VARCHAR2 := FND_API.G_FALSE,

    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,

    p_qa_code               IN VARCHAR2,
    p_document_type         IN VARCHAR2,
    p_severity_flag         IN VARCHAR2,
    p_enable_qa_yn          IN VARCHAR2,



    p_object_version_number IN NUMBER

   ) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 363

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

Line: 368

       okc_debug.log('1600: Entered Update_Doc_Qa_List', 2);

Line: 373

    SAVEPOINT g_Update_Doc_Qa_List_GRP;

Line: 388

    OKC_DOC_QA_LIST_PVT.Update_Row(
      p_validation_level           => p_validation_level,
      x_return_status              => x_return_status,
      p_qa_code               => p_qa_code,
      p_document_type         => p_document_type,
      p_severity_flag         => p_severity_flag,
      p_enable_qa_yn          => p_enable_qa_yn,
      p_object_version_number => p_object_version_number
    );

Line: 413

      okc_debug.log('1800: Leaving Update_Doc_Qa_List', 2);

Line: 419

         okc_debug.log('1900: Leaving Update_Doc_Qa_List: OKC_API.G_EXCEPTION_ERROR Exception', 2);

Line: 421

      ROLLBACK TO g_Update_Doc_Qa_List_GRP;

Line: 427

         okc_debug.log('2000: Leaving Update_Doc_Qa_List: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

Line: 429

      ROLLBACK TO g_Update_Doc_Qa_List_GRP;

Line: 435

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

Line: 438

      ROLLBACK TO g_Update_Doc_Qa_List_GRP;

Line: 445

  END Update_Doc_Qa_List;

Line: 450

  PROCEDURE Delete_Doc_Qa_List(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    p_commit                       IN VARCHAR2 := FND_API.G_FALSE,

    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,

    p_qa_code               IN VARCHAR2,
    p_document_type         IN VARCHAR2,
    p_object_version_number IN NUMBER
  ) IS
    l_api_version                  CONSTANT NUMBER := 1;

Line: 464

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

Line: 468

       okc_debug.log('2200: Entered Delete_Doc_Qa_List', 2);

Line: 472

    SAVEPOINT g_Delete_Doc_Qa_List_GRP;

Line: 487

    OKC_DOC_QA_LIST_PVT.Delete_Row(
      x_return_status              =>   x_return_status,
      p_qa_code               => p_qa_code,
      p_document_type         => p_document_type,
      p_object_version_number => p_object_version_number
    );

Line: 509

       okc_debug.log('2300: Leaving Delete_Doc_Qa_List', 2);

Line: 515

         okc_debug.log('2400: Leaving Delete_Doc_Qa_List: OKC_API.G_EXCEPTION_ERROR Exception', 2);

Line: 517

      ROLLBACK TO g_Delete_Doc_Qa_List_GRP;

Line: 523

         okc_debug.log('2500: Leaving Delete_Doc_Qa_List: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

Line: 525

      ROLLBACK TO g_Delete_Doc_Qa_List_GRP;

Line: 531

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

Line: 534

      ROLLBACK TO g_Delete_Doc_Qa_List_GRP;

Line: 541

  END Delete_Doc_Qa_List;