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.OKC_REVIEW_VAR_VALUES_PVT SQL Statements

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

Line: 10


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

Line: 12


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

Line: 62


     SELECT OKC_REVIEW_VAR_VALUES_S1.NEXTVAL FROM DUAL;

Line: 119


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

  ) RETURN VARCHAR2 IS
    CURSOR OKC_REVIEW_VAR_VALUES_pk_csr (cp_REVIEW_UPLD_TERMS_id IN NUMBER) IS
    SELECT
            REVIEW_VAR_VALUES_ID,
            VARIABLE_NAME,
            VARIABLE_CODE,
            VARIABLE_TYPE,
            VARIABLE_VALUE_ID,
            VARIABLE_VALUE,
            ATTRIBUTE_VALUE_SET_ID,
            OBJECT_VERSION_NUMBER,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_LOGIN,
            LAST_UPDATE_DATE,
            LANGUAGE
      FROM OKC_REVIEW_VAR_VALUES t
     WHERE t.REVIEW_UPLD_TERMS_ID = cp_REVIEW_UPLD_TERMS_id;

Line: 162


            x_last_updated_by,
            x_last_update_login,
            x_last_update_date,
            x_language;

Line: 225


    l_last_updated_by           OKC_REVIEW_VAR_VALUES.LAST_UPDATED_BY%TYPE;

Line: 226


    l_last_update_login         OKC_REVIEW_VAR_VALUES.LAST_UPDATE_LOGIN%TYPE;

Line: 227


    l_last_update_date          OKC_REVIEW_VAR_VALUES.LAST_UPDATE_DATE%TYPE;

Line: 248


        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_language                  => l_language
      );

Line: 364


     SELECT '!'
      FROM ??unknown_table??
      WHERE ??REVIEW_VAR_VALUES_ID?? = p_REVIEW_VAR_VALUES_id;

Line: 369


     SELECT '!'
      FROM ??unknown_table??
      WHERE ??REVIEW_UPLD_TERMS_ID?? = p_REVIEW_UPLD_TERMS_id;

Line: 374


     SELECT '!'
      FROM ??unknown_table??
      WHERE ??VARIABLE_VALUE_ID?? = p_variable_value_id;

Line: 379


     SELECT '!'
      FROM ??unknown_table??
      WHERE ??ATTRIBUTE_VALUE_SET_ID?? = p_attribute_value_set_id;

Line: 653


      l_last_updated_by           OKC_REVIEW_VAR_VALUES.LAST_UPDATED_BY%TYPE;

Line: 654


      l_last_update_login         OKC_REVIEW_VAR_VALUES.LAST_UPDATE_LOGIN%TYPE;

Line: 655


      l_last_update_date          OKC_REVIEW_VAR_VALUES.LAST_UPDATE_DATE%TYPE;

Line: 739


  FUNCTION Insert_Row(
    p_REVIEW_VAR_VALUES_id IN NUMBER,
    p_REVIEW_UPLD_TERMS_id  IN NUMBER,
    p_variable_name             IN VARCHAR2,
    p_variable_code             IN VARCHAR2,
    p_variable_type             IN VARCHAR2,
    p_variable_value_id         IN NUMBER,
    p_variable_value            IN VARCHAR2,
    p_attribute_value_set_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

  ) RETURN VARCHAR2 IS

  BEGIN

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

Line: 763


    INSERT INTO OKC_REVIEW_VAR_VALUES(
        REVIEW_VAR_VALUES_ID,
        REVIEW_UPLD_TERMS_ID,
        VARIABLE_NAME,
        VARIABLE_CODE,
        VARIABLE_TYPE,
        VARIABLE_VALUE_ID,
        VARIABLE_VALUE,
        ATTRIBUTE_VALUE_SET_ID,
        OBJECT_VERSION_NUMBER,
        CREATED_BY,
        CREATION_DATE,
        LAST_UPDATED_BY,
        LAST_UPDATE_LOGIN,
        LAST_UPDATE_DATE
        )
      VALUES (
        p_REVIEW_VAR_VALUES_id,
        p_REVIEW_UPLD_TERMS_id,
        p_variable_name,
        p_variable_code,
        p_variable_type,
        p_variable_value_id,
        p_variable_value,
        p_attribute_value_set_id,
        p_object_version_number,
        p_created_by,
        p_creation_date,
        p_last_updated_by,
        p_last_update_login,
        p_last_update_date);

Line: 796


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

Line: 805


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

Line: 817


  END Insert_Row;

Line: 823


  PROCEDURE Insert_Row(
    p_validation_level	      IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
    x_return_status           OUT NOCOPY VARCHAR2,

    p_REVIEW_VAR_VALUES_id IN NUMBER,
    p_REVIEW_UPLD_TERMS_id  IN NUMBER,
    p_variable_name             IN VARCHAR2,
    p_variable_code             IN VARCHAR2,
    p_variable_type             IN VARCHAR2,
    p_variable_value_id         IN NUMBER,
    p_variable_value            IN VARCHAR2,

    p_attribute_value_set_id    IN NUMBER := NULL,

    x_REVIEW_UPLD_TERMS_id  OUT NOCOPY NUMBER

  ) IS

    l_object_version_number     OKC_REVIEW_VAR_VALUES.OBJECT_VERSION_NUMBER%TYPE;

Line: 844


    l_last_updated_by           OKC_REVIEW_VAR_VALUES.LAST_UPDATED_BY%TYPE;

Line: 845


    l_last_update_login         OKC_REVIEW_VAR_VALUES.LAST_UPDATE_LOGIN%TYPE;

Line: 846


    l_last_update_date          OKC_REVIEW_VAR_VALUES.LAST_UPDATE_DATE%TYPE;

Line: 852


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

Line: 875


    l_last_update_date := l_creation_date;

Line: 876


    l_last_updated_by := l_created_by;

Line: 877


    l_last_update_login := Fnd_Global.Login_Id;

Line: 903


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

Line: 906


    x_return_status := Insert_Row(
      p_REVIEW_UPLD_TERMS_id  => x_REVIEW_UPLD_TERMS_id,
      p_REVIEW_VAR_VALUES_id => p_REVIEW_VAR_VALUES_id,
      p_variable_name             => p_variable_name,
      p_variable_code             => p_variable_code,
      p_variable_type             => p_variable_type,
      p_variable_value_id         => p_variable_value_id,
      p_variable_value            => p_variable_value,
      p_attribute_value_set_id    => p_attribute_value_set_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
    );

Line: 934


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

Line: 940


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

Line: 946


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

Line: 952


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

Line: 962


  END Insert_Row;

Line: 979


    SELECT object_version_number
      FROM OKC_REVIEW_VAR_VALUES
     WHERE REVIEW_UPLD_TERMS_ID = cp_REVIEW_UPLD_TERMS_id
       AND (object_version_number = cp_object_version_number OR cp_object_version_number IS NULL)
    FOR UPDATE OF object_version_number NOWAIT;

Line: 986


    SELECT object_version_number
      FROM OKC_REVIEW_VAR_VALUES
     WHERE REVIEW_UPLD_TERMS_ID = cp_REVIEW_UPLD_TERMS_id;

Line: 1026


        Okc_Api.Set_Message(G_APP_NAME,G_RECORD_DELETED);

Line: 1030


        Okc_Api.Set_Message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 1135


  FUNCTION Update_Row(
    p_REVIEW_UPLD_TERMS_id  IN NUMBER,
    p_REVIEW_VAR_VALUES_id IN NUMBER,
    p_variable_name             IN VARCHAR2,
    p_variable_code             IN VARCHAR2,
    p_variable_type             IN VARCHAR2,
    p_variable_value_id         IN NUMBER,
    p_variable_value            IN VARCHAR2,
    p_attribute_value_set_id    IN NUMBER,
    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: 1156


    UPDATE OKC_REVIEW_VAR_VALUES
     SET REVIEW_VAR_VALUES_ID = p_REVIEW_VAR_VALUES_id,
         VARIABLE_NAME             = p_variable_name,
         VARIABLE_CODE             = p_variable_code,
         VARIABLE_TYPE             = p_variable_type,
         VARIABLE_VALUE_ID         = p_variable_value_id,
         VARIABLE_VALUE            = p_variable_value,
         ATTRIBUTE_VALUE_SET_ID    = p_attribute_value_set_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
    WHERE REVIEW_UPLD_TERMS_ID  = p_REVIEW_UPLD_TERMS_id;

Line: 1171


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

Line: 1180


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

Line: 1192


  END Update_Row;

Line: 1197


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

    x_return_status                OUT NOCOPY VARCHAR2,

    p_REVIEW_UPLD_TERMS_id  IN NUMBER,

    p_REVIEW_VAR_VALUES_id IN NUMBER := NULL,
    p_variable_name             IN VARCHAR2 := NULL,
    p_variable_code             IN VARCHAR2 := NULL,
    p_variable_type             IN VARCHAR2 := NULL,
    p_variable_value_id         IN NUMBER := NULL,
    p_variable_value            IN VARCHAR2 := NULL,
    p_attribute_value_set_id    IN NUMBER := NULL,

    p_object_version_number     IN NUMBER

   ) IS

    l_REVIEW_VAR_VALUES_id OKC_REVIEW_VAR_VALUES.REVIEW_VAR_VALUES_ID%TYPE;

Line: 1224


    l_last_updated_by           OKC_REVIEW_VAR_VALUES.LAST_UPDATED_BY%TYPE;

Line: 1225


    l_last_update_login         OKC_REVIEW_VAR_VALUES.LAST_UPDATE_LOGIN%TYPE;

Line: 1226


    l_last_update_date          OKC_REVIEW_VAR_VALUES.LAST_UPDATE_DATE%TYPE;

Line: 1231


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

Line: 1303


    l_last_update_date := SYSDATE;

Line: 1304


    l_last_updated_by := FND_GLOBAL.USER_ID;

Line: 1305


    l_last_update_login := FND_GLOBAL.LOGIN_ID;

Line: 1320


    x_return_status := Update_Row(
      p_REVIEW_UPLD_TERMS_id  => p_REVIEW_UPLD_TERMS_id,
      p_REVIEW_VAR_VALUES_id => l_REVIEW_VAR_VALUES_id,
      p_variable_name             => l_variable_name,
      p_variable_code             => l_variable_code,
      p_variable_type             => l_variable_type,
      p_variable_value_id         => l_variable_value_id,
      p_variable_value            => l_variable_value,
      p_attribute_value_set_id    => l_attribute_value_set_id,
      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: 1342


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

Line: 1348


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

Line: 1354


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

Line: 1360


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

Line: 1370


  END Update_Row;

Line: 1378


  FUNCTION Delete_Row(
    p_REVIEW_UPLD_TERMS_id  IN NUMBER
  ) RETURN VARCHAR2 IS

  BEGIN

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

Line: 1388


    DELETE FROM OKC_REVIEW_VAR_VALUES
      WHERE REVIEW_UPLD_TERMS_ID = p_REVIEW_UPLD_TERMS_ID;

Line: 1393


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

Line: 1402


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

Line: 1414


  END Delete_Row;

Line: 1419


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

Line: 1428


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

Line: 1446


    x_return_status := Delete_Row( p_REVIEW_UPLD_TERMS_id => p_REVIEW_UPLD_TERMS_id );

Line: 1455


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

Line: 1461


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

Line: 1467


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

Line: 1473


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

Line: 1483


  END Delete_Row;