APPS.JTF_RS_TEAM_USAGES_PUB SQL Statements

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

Line: 9

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


  /* Package variables. */

  G_PKG_NAME         VARCHAR2(30) := 'JTF_RS_TEAM_USAGES_PUB';

Line: 176

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

  PROCEDURE  delete_team_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_TEAM_ID              IN   JTF_RS_TEAM_USAGES.TEAM_ID%TYPE,
   P_TEAM_NUMBER          IN   JTF_RS_TEAMS_VL.TEAM_NUMBER%TYPE,
   P_USAGE                IN   JTF_RS_TEAM_USAGES.USAGE%TYPE,
   P_OBJECT_VERSION_NUM   IN   JTF_RS_TEAM_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: 193

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

Line: 204

    SAVEPOINT delete_team_usage_pub;

Line: 268

    /* Call the private procedure for delete */

    jtf_rs_team_usages_pvt.delete_team_usage
    (P_API_VERSION => 1,
     P_INIT_MSG_LIST => fnd_api.g_false,
     P_COMMIT => fnd_api.g_false,
     P_TEAM_ID => l_team_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: 310

      ROLLBACK TO delete_team_usage_pub;

Line: 325

      ROLLBACK TO delete_team_usage_pub;

Line: 332

  END delete_team_usage;