APPS.JTF_RS_RESOURCE_VALUES_PUB SQL Statements

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

Line: 7

   create, update and delete resource salesrep territories from other modules.
   Its main procedures are as following:
   Create Resource Values
   Update Resource Values
   Delete Resource Values
   Delete All Resource Values
   Get Resource Values
   Get Resource Param List
   Calls to these procedures will invoke procedures from jtf_rs_resource_values_pvt
   to do business validations and to do actual inserts, updates and deletes into tables.
   ******************************************************************************************/

   --Package variables
      G_PKG_NAME         VARCHAR2(30) := 'JTF_RESOURCE_PARAMS_PUB';

Line: 135

   PROCEDURE UPDATE_RS_RESOURCE_VALUES(
      P_Api_Version	         	IN   	NUMBER,
      P_Init_Msg_List              	IN   	VARCHAR2     := FND_API.G_FALSE,
      P_Commit                     	IN   	VARCHAR2     := FND_API.G_FALSE,
      p_resource_param_value_id		IN   	NUMBER,
      p_resource_id			IN   	NUMBER,
      p_resource_param_id       	IN   	NUMBER,
      p_value      			IN   	VARCHAR2	DEFAULT FND_API.G_MISS_CHAR,
      p_value_type          		IN   	VARCHAR2	DEFAULT FND_API.G_MISS_CHAR,
      p_object_version_number		IN OUT NOCOPY JTF_RS_RESOURCE_VALUES.OBJECT_VERSION_NUMBER%TYPE,
      X_Return_Status              	OUT NOCOPY 	VARCHAR2,
      X_Msg_Count                  	OUT NOCOPY 	NUMBER,
      X_Msg_Data                   	OUT NOCOPY 	VARCHAR2
  )IS

        l_api_version            	CONSTANT NUMBER 	:= 1.0;

Line: 151

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

Line: 162

    SAVEPOINT update_rs_resource_values_pub;

Line: 220

      SELECT resource_param_value_id
      INTO l_resource_param_value_id
      FROM jtf_rs_resource_values
      WHERE resource_id = l_resource_id
         AND resource_param_id = l_resource_param_id
         AND value_type = l_value_type;

Line: 228

      jtf_rs_resource_values_pvt.update_rs_resource_values(
         P_API_VERSION              => 1,
         P_INIT_MSG_LIST            => fnd_api.g_false,
         P_COMMIT                   => fnd_api.g_false,
     	 p_resource_param_value_id  => l_resource_param_value_id,
     	 p_value                    => l_value,
     	 p_object_version_number    => l_object_version_number,
     	 X_RETURN_STATUS            => x_return_status,
     	 X_MSG_COUNT                => x_msg_count,
     	 X_MSG_DATA                 => x_msg_data
      );

Line: 253

      ROLLBACK TO update_rs_resource_values_pub;

Line: 260

      ROLLBACK TO update_rs_resource_values_pub;

Line: 264

  END update_rs_resource_values;

Line: 266

  /* Procedure to Delete Resource Values based on the
     input values provided by the calling routines */

  PROCEDURE DELETE_RS_RESOURCE_VALUES(
      P_Api_Version			IN   NUMBER,
      P_Init_Msg_List              	IN   VARCHAR2     := FND_API.G_FALSE,
      P_Commit                     	IN   VARCHAR2     := FND_API.G_FALSE,
      p_resource_param_value_id		IN   NUMBER,
      p_object_version_number   	IN   JTF_RS_RESOURCE_VALUES.OBJECT_VERSION_NUMBER%TYPE,
      X_Return_Status              	OUT NOCOPY VARCHAR2,
      X_Msg_Count                  	OUT NOCOPY NUMBER,
      X_Msg_Data                   	OUT NOCOPY VARCHAR2
  )IS

        l_api_version            	CONSTANT NUMBER := 1.0;

Line: 281

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

Line: 286

    SAVEPOINT delete_rs_resource_values_pub;

Line: 302

   jtf_rs_resource_values_pvt.delete_rs_resource_values(
     P_API_VERSION              => 1,
     P_INIT_MSG_LIST            => fnd_api.g_false,
     P_COMMIT                   => fnd_api.g_false,
     P_RESOURCE_PARAM_VALUE_ID  => l_resource_param_value_id,
     P_OBJECT_VERSION_NUMBER	=> l_object_version_number,
     X_RETURN_STATUS            => x_return_status,
     X_MSG_COUNT                => x_msg_count,
     X_MSG_DATA                 => x_msg_data
   );

Line: 326

      ROLLBACK TO delete_rs_resource_values_pub;

Line: 333

      ROLLBACK TO delete_rs_resource_values_pub;

Line: 337

  END delete_rs_resource_values;

Line: 339

  /* Procedure to Delete all Resource Values based on the
     Resource Id provided by the calling routines */

  PROCEDURE DELETE_ALL_RS_RESOURCE_VALUES(
      P_Api_Version	  		IN   NUMBER,
      P_Init_Msg_List              	IN   VARCHAR2     	:= FND_API.G_FALSE,
      P_Commit                     	IN   VARCHAR2     	:= FND_API.G_FALSE,
      p_resource_id                	IN   NUMBER,
      X_Return_Status              	OUT NOCOPY VARCHAR2,
      X_Msg_Count                  	OUT NOCOPY NUMBER,
      X_Msg_Data                   	OUT NOCOPY VARCHAR2
  )IS

        l_api_version            	CONSTANT NUMBER 	:= 1.0;

Line: 353

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

Line: 359

    SAVEPOINT delete_all_rs_values_pub;

Line: 375

   jtf_rs_resource_values_pvt.delete_all_rs_resource_values(
     P_API_VERSION              => 1,
     P_INIT_MSG_LIST            => fnd_api.g_false,
     P_COMMIT                   => fnd_api.g_false,
     P_RESOURCE_ID  		=> l_resource_id,
     X_RETURN_STATUS            => x_return_status,
     X_MSG_COUNT                => x_msg_count,
     X_MSG_DATA                 => x_msg_data
   );

Line: 398

      ROLLBACK TO delete_all_rs_values_pub;

Line: 405

      ROLLBACK TO delete_all_rs_values_pub;

Line: 409

  END delete_all_rs_resource_values;