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

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

Line: 7


   create, update and delete rows
   Its main procedures are as following:
   Create res_availability
   Update res_availability
   Delete res_availability
   Calls to these procedures will call procedures of jtf_rs_res_availability_pvt
   to do inserts, updates and deletes into tables.
   ******************************************************************************************/

 /* Package variables. */

  G_PKG_NAME         VARCHAR2(30) := 'JTF_RS_RES_AVAILABILITY_PUB';

Line: 67


    SELECT 1
    FROM jtf_rs_resource_extns
    WHERE resource_id = l_resource_id;

Line: 175


  /* Procedure to update resource availability
	based on input values passed by calling routines. */

  PROCEDURE  update_res_availability
  (P_API_VERSION          IN   NUMBER,
   P_INIT_MSG_LIST        IN   VARCHAR2   DEFAULT  FND_API.G_FALSE,
   P_COMMIT               IN   VARCHAR2   DEFAULT  FND_API.G_FALSE,
   P_AVAILABILITY_ID      IN   JTF_RS_RES_AVAILABILITY.AVAILABILITY_ID%TYPE,
   P_RESOURCE_ID          IN   JTF_RS_RES_AVAILABILITY.RESOURCE_ID%TYPE   DEFAULT  FND_API.G_MISS_NUM,
   P_AVAILABLE_FLAG       IN   JTF_RS_RES_AVAILABILITY.AVAILABLE_FLAG%TYPE  DEFAULT  FND_API.G_MISS_CHAR,
   P_REASON_CODE          IN   JTF_RS_RES_AVAILABILITY.REASON_CODE%TYPE  DEFAULT  FND_API.G_MISS_CHAR,
   P_START_DATE           IN   JTF_RS_RES_AVAILABILITY.START_DATE%TYPE   DEFAULT  FND_API.G_MISS_DATE,
   P_END_DATE             IN   JTF_RS_RES_AVAILABILITY.END_DATE%TYPE     DEFAULT  FND_API.G_MISS_DATE,
   P_MODE_OF_AVAILABILITY IN   JTF_RS_RES_AVAILABILITY.MODE_OF_AVAILABILITY%TYPE  DEFAULT  FND_API.G_MISS_CHAR,
   P_OBJECT_VERSION_NUM   IN OUT NOCOPY JTF_RS_RES_AVAILABILITY.OBJECT_VERSION_NUMBER%TYPE,
   P_ATTRIBUTE1		  IN   JTF_RS_RES_AVAILABILITY.ATTRIBUTE1%TYPE  DEFAULT  FND_API.G_MISS_CHAR,
   P_ATTRIBUTE2		  IN   JTF_RS_RES_AVAILABILITY.ATTRIBUTE2%TYPE  DEFAULT  FND_API.G_MISS_CHAR,
   P_ATTRIBUTE3		  IN   JTF_RS_RES_AVAILABILITY.ATTRIBUTE3%TYPE  DEFAULT  FND_API.G_MISS_CHAR,
   P_ATTRIBUTE4		  IN   JTF_RS_RES_AVAILABILITY.ATTRIBUTE4%TYPE  DEFAULT  FND_API.G_MISS_CHAR,
   P_ATTRIBUTE5		  IN   JTF_RS_RES_AVAILABILITY.ATTRIBUTE5%TYPE  DEFAULT  FND_API.G_MISS_CHAR,
   P_ATTRIBUTE6		  IN   JTF_RS_RES_AVAILABILITY.ATTRIBUTE6%TYPE  DEFAULT  FND_API.G_MISS_CHAR,
   P_ATTRIBUTE7		  IN   JTF_RS_RES_AVAILABILITY.ATTRIBUTE7%TYPE  DEFAULT  FND_API.G_MISS_CHAR,
   P_ATTRIBUTE8		  IN   JTF_RS_RES_AVAILABILITY.ATTRIBUTE8%TYPE  DEFAULT  FND_API.G_MISS_CHAR,
   P_ATTRIBUTE9		  IN   JTF_RS_RES_AVAILABILITY.ATTRIBUTE9%TYPE  DEFAULT  FND_API.G_MISS_CHAR,
   P_ATTRIBUTE10	  IN   JTF_RS_RES_AVAILABILITY.ATTRIBUTE10%TYPE DEFAULT  FND_API.G_MISS_CHAR,
   P_ATTRIBUTE11	  IN   JTF_RS_RES_AVAILABILITY.ATTRIBUTE11%TYPE DEFAULT  FND_API.G_MISS_CHAR,
   P_ATTRIBUTE12	  IN   JTF_RS_RES_AVAILABILITY.ATTRIBUTE12%TYPE DEFAULT  FND_API.G_MISS_CHAR,
   P_ATTRIBUTE13	  IN   JTF_RS_RES_AVAILABILITY.ATTRIBUTE13%TYPE DEFAULT  FND_API.G_MISS_CHAR,
   P_ATTRIBUTE14	  IN   JTF_RS_RES_AVAILABILITY.ATTRIBUTE14%TYPE DEFAULT  FND_API.G_MISS_CHAR,
   P_ATTRIBUTE15	  IN   JTF_RS_RES_AVAILABILITY.ATTRIBUTE15%TYPE DEFAULT  FND_API.G_MISS_CHAR,
   P_ATTRIBUTE_CATEGORY	  IN   JTF_RS_RES_AVAILABILITY.ATTRIBUTE_CATEGORY%TYPE DEFAULT  FND_API.G_MISS_CHAR,
   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)                              := 'UPDATE_RES_AVAILABILITY';

Line: 223


    SELECT 1
    FROM jtf_rs_resource_extns
    WHERE resource_id = l_resource_id;

Line: 229


    SELECT 1
    FROM jtf_rs_res_availability
    WHERE availability_id = l_availability_id;

Line: 235


     SAVEPOINT UPDATE_RES_AVAILABILITY_SP;

Line: 282


		 JTF_RS_RES_AVAILABILITY_PVT.UPDATE_RES_AVAILABILITY(
                               P_API_VERSION            => l_api_version,
                               P_INIT_MSG_LIST          => p_init_msg_list,
                               P_COMMIT                 => p_commit,
                               P_AVAILABILITY_ID        => p_availability_id,
                               P_RESOURCE_ID            => p_resource_id,
                               P_AVAILABLE_FLAG         => p_available_flag,
                               P_REASON_CODE            => p_reason_code,
                               P_START_DATE             => p_start_date,
                               P_END_DATE               => p_end_date,
                               P_MODE_OF_AVAILABILITY   => p_mode_of_availability,
                               P_OBJECT_VERSION_NUM     => l_object_version_number,
                               P_ATTRIBUTE1		=> p_attribute1,
                               P_ATTRIBUTE2		=> P_attribute2,
                               P_ATTRIBUTE3		=> p_attribute3,
                               P_ATTRIBUTE4		=> p_attribute4,
                               P_ATTRIBUTE5		=> p_attribute5,
                               P_ATTRIBUTE6		=> p_attribute6,
                               P_ATTRIBUTE7		=> p_attribute7,
                               P_ATTRIBUTE8		=> p_attribute8,
                               P_ATTRIBUTE9		=> p_attribute9,
                               P_ATTRIBUTE10	        => p_attribute10,
                               P_ATTRIBUTE11	        => p_attribute11,
                               P_ATTRIBUTE12	        => p_attribute12,
                               P_ATTRIBUTE13	        => p_attribute13,
                               P_ATTRIBUTE14	        => p_attribute14,
                               P_ATTRIBUTE15	        => p_attribute15,
                               P_ATTRIBUTE_CATEGORY     => p_attribute_category,
                               X_RETURN_STATUS          => l_return_status,
                               X_MSG_COUNT              => l_msg_count,
                               X_MSG_DATA               => l_msg_data
                              );

Line: 331


      ROLLBACK TO UPDATE_RES_AVAILABILITY_SP;

Line: 336


      ROLLBACK TO UPDATE_RES_AVAILABILITY_SP;

Line: 341


      ROLLBACK TO UPDATE_RES_AVAILABILITY_SP;

Line: 349


   END  update_res_availability;

Line: 352


  /* Procedure to delete the resource availability */

  PROCEDURE  delete_res_availability
  (P_API_VERSION          IN     NUMBER,
   P_INIT_MSG_LIST        IN     VARCHAR2   DEFAULT  FND_API.G_FALSE,
   P_COMMIT               IN     VARCHAR2   DEFAULT  FND_API.G_FALSE,
   P_AVAILABILITY_ID      IN     JTF_RS_RES_AVAILABILITY.AVAILABILITY_ID%TYPE,
   P_OBJECT_VERSION_NUM   IN     JTF_RS_RES_AVAILABILITY.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_name           CONSTANT VARCHAR2(30) := 'DELETE_RES_AVAILABILITY';

Line: 375


    SELECT 1
    FROM jtf_rs_res_availability
    WHERE availability_id = l_availability_id;

Line: 381


     SAVEPOINT DELETE_RES_AVAILABILITY_SP;

Line: 413


    JTF_RS_RES_AVAILABILITY_PVT.DELETE_RES_AVAILABILITY
  (P_API_VERSION         => l_api_version,
   P_INIT_MSG_LIST       => p_init_msg_list,
   P_COMMIT              => p_commit,
   P_AVAILABILITY_ID     => p_availability_id,
   P_OBJECT_VERSION_NUM  => p_object_version_num,
   X_RETURN_STATUS       => l_return_status,
   X_MSG_COUNT           => l_msg_count,
   X_MSG_DATA            => l_msg_data
  );

Line: 438


      ROLLBACK TO DELETE_RES_AVAILABILITY_SP;

Line: 443


      ROLLBACK TO DELETE_RES_AVAILABILITY_SP;

Line: 448


      ROLLBACK TO DELETE_RES_AVAILABILITY_SP;

Line: 457


 END delete_res_availability;