APPS.JTF_RS_GROUP_USAGES_PUB SQL Statements

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

Line: 9

   Delete Resource Group Usage
   Calls to these procedures will invoke procedures from jtf_rs_group_usages_pvt
   to do business validations and to do actual inserts and updates into tables.
   ******************************************************************************************/


  /* Package variables. */

  G_PKG_NAME         VARCHAR2(30) := 'JTF_RS_GROUP_USAGES_PUB';

Line: 183

  /* Procedure to delete the resource group usage
	based on input values passed by calling routines. */

  PROCEDURE  delete_group_usage
  (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_GROUP_ID             IN   JTF_RS_GROUP_USAGES.GROUP_ID%TYPE,
   P_GROUP_NUMBER         IN   JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE,
   P_USAGE                IN   JTF_RS_GROUP_USAGES.USAGE%TYPE,
   P_OBJECT_VERSION_NUM   IN   JTF_RS_GROUP_USAGES.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: 200

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

Line: 212

    SAVEPOINT delete_group_usage_pub;

Line: 278

    /* Call the private procedure for delete */

    jtf_rs_group_usages_pvt.delete_group_usage
    (P_API_VERSION => 1,
     P_INIT_MSG_LIST => fnd_api.g_false,
     P_COMMIT => fnd_api.g_false,
     P_GROUP_ID => l_group_id,
     P_USAGE => l_usage,
     P_OBJECT_VERSION_NUM => p_object_version_num,
     X_RETURN_STATUS => x_return_status,
     X_MSG_COUNT => x_msg_count,
     X_MSG_DATA => x_msg_data
    );

Line: 320

      ROLLBACK TO delete_group_usage_pub;

Line: 335

      ROLLBACK TO delete_group_usage_pub;

Line: 348

  END delete_group_usage;