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

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

Line: 116


      PV_SELECTED_ATTR_VALUES_PKG.Insert_Row(
          px_ATTR_VALUE_ID  => x_ATTR_VALUE_ID
         ,p_LAST_UPDATE_DATE  => SYSDATE
         ,p_LAST_UPDATED_BY  => FND_GLOBAL.USER_ID
         ,p_CREATION_DATE  => SYSDATE
         ,p_CREATED_BY  => FND_GLOBAL.USER_ID
         ,p_LAST_UPDATE_LOGIN  => FND_GLOBAL.CONC_LOGIN_ID
         ,p_OBJECT_VERSION_NUMBER  => p_SELATTVAL_rec.OBJECT_VERSION_NUMBER
         ,p_REQUEST_ID  => p_SELATTVAL_rec.REQUEST_ID
         ,p_PROGRAM_APPLICATION_ID  => p_SELATTVAL_rec.PROGRAM_APPLICATION_ID
         ,p_PROGRAM_ID  => p_SELATTVAL_rec.PROGRAM_ID
         ,p_PROGRAM_UPDATE_DATE  => p_SELATTVAL_rec.PROGRAM_UPDATE_DATE
         ,p_SELECTION_CRITERIA_ID  => p_SELATTVAL_rec.SELECTION_CRITERIA_ID
         ,p_ATTRIBUTE_VALUE  => p_SELATTVAL_rec.ATTRIBUTE_VALUE
         ,p_ATTRIBUTE_TO_VALUE  => p_SELATTVAL_rec.ATTRIBUTE_TO_VALUE
         ,p_ATTRIBUTE_CATEGORY  => p_SELATTVAL_rec.ATTRIBUTE_CATEGORY
         ,p_ATTRIBUTE1  => p_SELATTVAL_rec.ATTRIBUTE1
         ,p_ATTRIBUTE2  => p_SELATTVAL_rec.ATTRIBUTE2
         ,p_ATTRIBUTE3  => p_SELATTVAL_rec.ATTRIBUTE3
         ,p_ATTRIBUTE4  => p_SELATTVAL_rec.ATTRIBUTE4
         ,p_ATTRIBUTE5  => p_SELATTVAL_rec.ATTRIBUTE5
         ,p_ATTRIBUTE6  => p_SELATTVAL_rec.ATTRIBUTE6
         ,p_ATTRIBUTE7  => p_SELATTVAL_rec.ATTRIBUTE7
         ,p_ATTRIBUTE8  => p_SELATTVAL_rec.ATTRIBUTE8
         ,p_ATTRIBUTE9  => p_SELATTVAL_rec.ATTRIBUTE9
         ,p_ATTRIBUTE10  => p_SELATTVAL_rec.ATTRIBUTE10
         ,p_ATTRIBUTE11  => p_SELATTVAL_rec.ATTRIBUTE11
         ,p_ATTRIBUTE12  => p_SELATTVAL_rec.ATTRIBUTE12
         ,p_ATTRIBUTE13  => p_SELATTVAL_rec.ATTRIBUTE13
         ,p_ATTRIBUTE14  => p_SELATTVAL_rec.ATTRIBUTE14
         ,p_ATTRIBUTE15  => p_SELATTVAL_rec.ATTRIBUTE15
         ,p_SCORE        => p_SELATTVAL_rec.SCORE);

Line: 215


PROCEDURE Update_selattval(
    P_Api_Version_Number         IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2     := FND_API.G_FALSE,
    P_Commit                     IN   VARCHAR2     := FND_API.G_FALSE,
    p_validation_level           IN   NUMBER       := FND_API.G_VALID_LEVEL_FULL,
    P_Identity_Resource_Id       IN   NUMBER,
    P_SELATTVAL_Rec              IN    PV_RULE_RECTYPE_PUB.SELATTVAL_Rec_Type,
    X_Return_Status              OUT NOCOPY  VARCHAR2,
    X_Msg_Count                  OUT NOCOPY  NUMBER,
    X_Msg_Data                   OUT NOCOPY  VARCHAR2
    )

 IS

Cursor C_Get_selattval(pc_ATTR_VALUE_ID Number) IS
    Select object_version_number
    From  PV_SELECTED_ATTR_VALUES
    where attr_value_id = pc_attr_value_id
    For Update NOWAIT;

Line: 235


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

Line: 243


      SAVEPOINT UPDATE_SELATTVAL_PVT;

Line: 279


      AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: - Open Cursor to Select');

Line: 289


               FND_MESSAGE.Set_Name('PV', 'API_MISSING_UPDATE_TARGET');

Line: 335


          p_validation_mode  => AS_UTILITY_PVT.G_UPDATE,
          P_SELATTVAL_Rec  =>  P_SELATTVAL_Rec,
          x_return_status    => x_return_status,
          x_msg_count        => x_msg_count,
          x_msg_data         => x_msg_data);

Line: 350


      AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');

Line: 354


      PV_SELECTED_ATTR_VALUES_PKG.Update_Row(
          p_ATTR_VALUE_ID  => p_SELATTVAL_rec.ATTR_VALUE_ID
         ,p_LAST_UPDATE_DATE  => SYSDATE
         ,p_LAST_UPDATED_BY  => FND_GLOBAL.USER_ID
         ,p_CREATION_DATE  => FND_API.G_MISS_DATE
         ,p_CREATED_BY     => FND_API.G_MISS_NUM
         ,p_LAST_UPDATE_LOGIN  => FND_GLOBAL.CONC_LOGIN_ID
         ,p_OBJECT_VERSION_NUMBER  => p_SELATTVAL_rec.OBJECT_VERSION_NUMBER
         ,p_REQUEST_ID  => p_SELATTVAL_rec.REQUEST_ID
         ,p_PROGRAM_APPLICATION_ID  => p_SELATTVAL_rec.PROGRAM_APPLICATION_ID
         ,p_PROGRAM_ID  => p_SELATTVAL_rec.PROGRAM_ID
         ,p_PROGRAM_UPDATE_DATE  => p_SELATTVAL_rec.PROGRAM_UPDATE_DATE
         ,p_SELECTION_CRITERIA_ID  => p_SELATTVAL_rec.SELECTION_CRITERIA_ID
         ,p_ATTRIBUTE_VALUE  => p_SELATTVAL_rec.ATTRIBUTE_VALUE
         ,p_ATTRIBUTE_TO_VALUE  => p_SELATTVAL_rec.ATTRIBUTE_TO_VALUE
         ,p_ATTRIBUTE_CATEGORY  => p_SELATTVAL_rec.ATTRIBUTE_CATEGORY
         ,p_ATTRIBUTE1  => p_SELATTVAL_rec.ATTRIBUTE1
         ,p_ATTRIBUTE2  => p_SELATTVAL_rec.ATTRIBUTE2
         ,p_ATTRIBUTE3  => p_SELATTVAL_rec.ATTRIBUTE3
         ,p_ATTRIBUTE4  => p_SELATTVAL_rec.ATTRIBUTE4
         ,p_ATTRIBUTE5  => p_SELATTVAL_rec.ATTRIBUTE5
         ,p_ATTRIBUTE6  => p_SELATTVAL_rec.ATTRIBUTE6
         ,p_ATTRIBUTE7  => p_SELATTVAL_rec.ATTRIBUTE7
         ,p_ATTRIBUTE8  => p_SELATTVAL_rec.ATTRIBUTE8
         ,p_ATTRIBUTE9  => p_SELATTVAL_rec.ATTRIBUTE9
         ,p_ATTRIBUTE10  => p_SELATTVAL_rec.ATTRIBUTE10
         ,p_ATTRIBUTE11  => p_SELATTVAL_rec.ATTRIBUTE11
         ,p_ATTRIBUTE12  => p_SELATTVAL_rec.ATTRIBUTE12
         ,p_ATTRIBUTE13  => p_SELATTVAL_rec.ATTRIBUTE13
         ,p_ATTRIBUTE14  => p_SELATTVAL_rec.ATTRIBUTE14
         ,p_ATTRIBUTE15  => p_SELATTVAL_rec.ATTRIBUTE15
	 ,p_SCORE        => p_SELATTVAL_rec.SCORE);

Line: 442


End Update_selattval;

Line: 447


PROCEDURE Delete_selattval(
    P_Api_Version_Number         IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2     := FND_API.G_FALSE,
    P_Commit                     IN   VARCHAR2     := FND_API.G_FALSE,
    p_validation_level           IN   NUMBER       := FND_API.G_VALID_LEVEL_FULL,
    P_Identity_Resource_Id     IN   NUMBER,
    P_SELATTVAL_Rec            IN PV_RULE_RECTYPE_PUB.SELATTVAL_Rec_Type,
    X_Return_Status              OUT NOCOPY  VARCHAR2,
    X_Msg_Count                  OUT NOCOPY  NUMBER,
    X_Msg_Data                   OUT NOCOPY  VARCHAR2
    )

 IS
l_api_name                CONSTANT VARCHAR2(30) := 'Delete_selattval';

Line: 465


      SAVEPOINT DELETE_SELATTVAL_PVT;

Line: 501


      AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling delete table handler');

Line: 505


      PV_SELECTED_ATTR_VALUES_PKG.Delete_Row(
          p_ATTR_VALUE_ID  => p_SELATTVAL_rec.ATTR_VALUE_ID);

Line: 563


End Delete_selattval;

Line: 577


      SELECT 'X'
      FROM  pv_selected_attr_values
      WHERE attr_value_id = pc_attr_value_id;

Line: 608


      ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
      THEN
          -- validate NOT NULL column
          IF (p_attr_value_id IS NULL) OR
             (p_attr_value_id = FND_API.G_MISS_NUM)
          THEN
              AS_UTILITY_PVT.Set_Message(
                  p_msg_level     => FND_MSG_PUB.G_MSG_LVL_ERROR,
                  p_msg_name      => 'API_MISSING_LEAD_ID');

Line: 648


PROCEDURE Validate_SELECTION_CRITERIA_ID (
    P_Init_Msg_List              IN   VARCHAR2     := FND_API.G_FALSE,
    P_Validation_mode            IN   VARCHAR2,
    P_SELECTION_CRITERIA_ID      IN   NUMBER,
    X_Return_Status              OUT NOCOPY  VARCHAR2,
    X_Msg_Count                  OUT NOCOPY  NUMBER,
    X_Msg_Data                   OUT NOCOPY  VARCHAR2
    )
IS
  CURSOR C_select_criteria_id_Exists (c_select_criteria_id NUMBER) IS
      SELECT 'X'
      FROM  pv_enty_select_criteria
      WHERE selection_criteria_id = c_select_criteria_id;

Line: 677


      IF(p_selection_criteria_id is NULL)
      THEN
          IF (AS_DEBUG_HIGH_ON) THEN
              AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'Private API: -Violate NOT NULL constraint(selection_criteria_id)');

Line: 686


      OPEN  C_select_criteria_id_Exists (p_selection_criteria_id);

Line: 687


      FETCH C_select_criteria_id_Exists into l_val;

Line: 689


      IF C_select_criteria_id_Exists%NOTFOUND
      THEN
          AS_UTILITY_PVT.Set_Message(
              p_msg_level     => FND_MSG_PUB.G_MSG_LVL_ERROR,
              p_msg_name      => 'API_INVALID_ID',
              p_token1        => 'COLUMN',
              p_token1_value  => 'selection_criteria_id',
              p_token2        => 'VALUE',
              p_token2_value  => p_selection_criteria_id );

Line: 701


     CLOSE C_select_criteria_id_Exists;

Line: 709


END Validate_SELECTION_CRITERIA_ID;

Line: 723


   cursor lc_criterion_dup_values_check (pc_rule_id number,pc_attribute_id number,pc_attribute_value varchar2,pc_selection_type_code varchar2) is
   select attribute_value
   from
      pv_selected_attr_values sav, pv_enty_select_criteria esc
   where
      sav.selection_criteria_id = esc.selection_criteria_id and
      esc.process_rule_id = pc_rule_id and
      esc.attribute_id = pc_attribute_id and
      esc.selection_type_code = pc_selection_type_code and
      sav.attribute_value = pc_attribute_value;

Line: 738


l_selection_type_code varchar2(30);

Line: 777


          Validate_SELECTION_CRITERIA_ID(
              p_init_msg_list          => FND_API.G_FALSE,
              p_validation_mode        => p_validation_mode,
              p_SELECTION_CRITERIA_ID  => P_SELATTVAL_Rec.SELECTION_CRITERIA_ID,
              x_return_status          => x_return_status,
              x_msg_count              => x_msg_count,
              x_msg_data               => x_msg_data);

Line: 795


           select process_rule_id,attribute_id,selection_type_code into l_rule_id,l_attribute_id,l_selection_type_code from pv_enty_select_criteria
	   where selection_criteria_id = P_SELATTVAL_Rec.selection_criteria_id;

Line: 801


					      pc_selection_type_code => l_selection_type_code);