DBA Data[Home] [Help]

APPS.OKC_DOC_QA_LIST_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: 62

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

  ) RETURN VARCHAR2 IS
    CURSOR OKC_DOC_QA_LISTS_pk_csr (cp_qa_code IN VARCHAR2,cp_document_type IN VARCHAR2) IS
    SELECT
            SEVERITY_FLAG,
            ENABLE_QA_YN,
            OBJECT_VERSION_NUMBER,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_LOGIN,
            LAST_UPDATE_DATE
      FROM OKC_DOC_QA_LISTS t
     WHERE t.QA_CODE = cp_qa_code and
           t.DOCUMENT_TYPE = cp_document_type;
Line: 94

            x_last_updated_by,
            x_last_update_login,
            x_last_update_date;
Line: 148

    l_last_updated_by       OKC_DOC_QA_LISTS.LAST_UPDATED_BY%TYPE;
Line: 149

    l_last_update_login     OKC_DOC_QA_LISTS.LAST_UPDATE_LOGIN%TYPE;
Line: 150

    l_last_update_date      OKC_DOC_QA_LISTS.LAST_UPDATE_DATE%TYPE;
Line: 166

        x_last_updated_by       => l_last_updated_by,
        x_last_update_login     => l_last_update_login,
        x_last_update_date      => l_last_update_date
      );
Line: 240

     SELECT '!'
      FROM OKC_BUS_DOC_TYPES_V
      WHERE DOCUMENT_TYPE = p_document_type;
Line: 489

      l_last_updated_by       OKC_DOC_QA_LISTS.LAST_UPDATED_BY%TYPE;
Line: 490

      l_last_update_login     OKC_DOC_QA_LISTS.LAST_UPDATE_LOGIN%TYPE;
Line: 491

      l_last_update_date      OKC_DOC_QA_LISTS.LAST_UPDATE_DATE%TYPE;
Line: 561

  FUNCTION Insert_Row(
    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,
    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

  ) RETURN VARCHAR2 IS

  BEGIN

    IF (l_debug = 'Y') THEN
       Okc_Debug.Log('3600: Entered Insert_Row function', 2);
Line: 581

    INSERT INTO OKC_DOC_QA_LISTS(
        QA_CODE,
        DOCUMENT_TYPE,
        SEVERITY_FLAG,
        ENABLE_QA_YN,
        OBJECT_VERSION_NUMBER,
        CREATED_BY,
        CREATION_DATE,
        LAST_UPDATED_BY,
        LAST_UPDATE_LOGIN,
        LAST_UPDATE_DATE)
      VALUES (
        p_qa_code,
        p_document_type,
        p_severity_flag,
        p_enable_qa_yn,
        p_object_version_number,
        p_created_by,
        p_creation_date,
        p_last_updated_by,
        p_last_update_login,
        p_last_update_date);
Line: 605

       Okc_Debug.Log('3700: Leaving Insert_Row', 2);
Line: 614

         Okc_Debug.Log('3800: Leaving Insert_Row:OTHERS Exception', 2);
Line: 626

  END Insert_Row;
Line: 632

  PROCEDURE Insert_Row(
    p_validation_level	      IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
    x_return_status           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_object_version_number OKC_DOC_QA_LISTS.OBJECT_VERSION_NUMBER%TYPE;
Line: 651

    l_last_updated_by       OKC_DOC_QA_LISTS.LAST_UPDATED_BY%TYPE;
Line: 652

    l_last_update_login     OKC_DOC_QA_LISTS.LAST_UPDATE_LOGIN%TYPE;
Line: 653

    l_last_update_date      OKC_DOC_QA_LISTS.LAST_UPDATE_DATE%TYPE;
Line: 659

       Okc_Debug.Log('4200: Entered Insert_Row', 2);
Line: 670

    l_last_update_date := l_creation_date;
Line: 671

    l_last_updated_by := l_created_by;
Line: 672

    l_last_update_login := Fnd_Global.Login_Id;
Line: 694

       Okc_Debug.Log('4300: Call the internal Insert_Row for Base Table', 2);
Line: 697

    x_return_status := Insert_Row(
      p_qa_code               => x_qa_code,
      p_document_type         => x_document_type,
      p_severity_flag         => p_severity_flag,
      p_enable_qa_yn          => p_enable_qa_yn,
      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
    );
Line: 718

       Okc_Debug.Log('4500: Leaving Insert_Row', 2);
Line: 724

         Okc_Debug.Log('4600: Leaving Insert_Row:FND_API.G_EXC_ERROR Exception', 2);
Line: 730

         Okc_Debug.Log('4700: Leaving Insert_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
Line: 736

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

  END Insert_Row;
Line: 763

    SELECT object_version_number
      FROM OKC_DOC_QA_LISTS
     WHERE QA_CODE = cp_qa_code AND DOCUMENT_TYPE = cp_document_type
       AND (object_version_number = cp_object_version_number OR cp_object_version_number IS NULL)
    FOR UPDATE OF object_version_number NOWAIT;
Line: 770

    SELECT object_version_number
      FROM OKC_DOC_QA_LISTS
     WHERE QA_CODE = cp_qa_code AND DOCUMENT_TYPE = cp_document_type;
Line: 816

        Okc_Api.Set_Message(G_FND_APP,G_RECORD_DELETED);
Line: 820

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

  FUNCTION Update_Row(
    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,
    p_last_updated_by       IN NUMBER,
    p_last_update_login     IN NUMBER,
    p_last_update_date      IN DATE
   ) RETURN VARCHAR2 IS

  BEGIN

    IF (l_debug = 'Y') THEN
       Okc_Debug.Log('6400: Entered Update_Row', 2);
Line: 944

    UPDATE OKC_DOC_QA_LISTS
     SET SEVERITY_FLAG         = p_severity_flag,
         ENABLE_QA_YN          = p_enable_qa_yn,
         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
    WHERE QA_CODE               = p_qa_code AND DOCUMENT_TYPE         = p_document_type;
Line: 954

       Okc_Debug.Log('6500: Leaving Update_Row', 2);
Line: 963

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

  END Update_Row;
Line: 980

  PROCEDURE Update_Row(
    p_validation_level	           IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

    x_return_status                OUT NOCOPY VARCHAR2,

    p_qa_code               IN VARCHAR2,
    p_document_type         IN VARCHAR2,
    p_severity_flag         IN VARCHAR2 := NULL,
    p_enable_qa_yn          IN VARCHAR2 := NULL,

    p_object_version_number IN NUMBER

   ) IS

    l_severity_flag         OKC_DOC_QA_LISTS.SEVERITY_FLAG%TYPE;
Line: 997

    l_last_updated_by       OKC_DOC_QA_LISTS.LAST_UPDATED_BY%TYPE;
Line: 998

    l_last_update_login     OKC_DOC_QA_LISTS.LAST_UPDATE_LOGIN%TYPE;
Line: 999

    l_last_update_date      OKC_DOC_QA_LISTS.LAST_UPDATE_DATE%TYPE;
Line: 1004

       Okc_Debug.Log('7000: Entered Update_Row', 2);
Line: 1064

    l_last_update_date := SYSDATE;
Line: 1065

    l_last_updated_by := FND_GLOBAL.USER_ID;
Line: 1066

    l_last_update_login := FND_GLOBAL.LOGIN_ID;
Line: 1080

    x_return_status := Update_Row(
      p_qa_code               => p_qa_code,
      p_document_type         => p_document_type,
      p_severity_flag         => l_severity_flag,
      p_enable_qa_yn          => l_enable_qa_yn,
      p_object_version_number => l_object_version_number,
      p_last_updated_by       => l_last_updated_by,
      p_last_update_login     => l_last_update_login,
      p_last_update_date      => l_last_update_date
    );
Line: 1098

      Okc_Debug.Log('7800: Leaving Update_Row', 2);
Line: 1104

        Okc_Debug.Log('7900: Leaving Update_Row:FND_API.G_EXC_ERROR Exception', 2);
Line: 1110

        Okc_Debug.Log('8000: Leaving Update_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
Line: 1116

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

  END Update_Row;
Line: 1134

  FUNCTION Delete_Row(
    p_qa_code               IN VARCHAR2,
    p_document_type         IN VARCHAR2
  ) RETURN VARCHAR2 IS

  BEGIN

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

    DELETE FROM OKC_DOC_QA_LISTS
      WHERE QA_CODE = p_QA_CODE AND DOCUMENT_TYPE = p_DOCUMENT_TYPE;
Line: 1149

       Okc_Debug.Log('8300: Leaving Delete_Row', 2);
Line: 1158

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

  END Delete_Row;
Line: 1175

  PROCEDURE Delete_Row(
    x_return_status                OUT NOCOPY VARCHAR2,
    p_qa_code               IN VARCHAR2,
    p_document_type         IN VARCHAR2,
    p_object_version_number IN NUMBER
  ) IS
    l_api_name                     CONSTANT VARCHAR2(30) := 'B_Delete_Row';
Line: 1185

       Okc_Debug.Log('8800: Entered Delete_Row', 2);
Line: 1204

    x_return_status := Delete_Row( p_qa_code => p_qa_code,p_document_type => p_document_type );
Line: 1213

       Okc_Debug.Log('9300: Leaving Delete_Row', 2);
Line: 1219

         Okc_Debug.Log('9400: Leaving Delete_Row:FND_API.G_EXC_ERROR Exception', 2);
Line: 1225

         Okc_Debug.Log('9500: Leaving Delete_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
Line: 1231

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

  END Delete_Row;