APPS.JTF_RS_TEAM_MEMBERS_PUB SQL Statements

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

Line: 6

   create, update and delete resource team members.
   Its main procedures are as following:
   Create Resource Team Members
   Update Resource Team Members
   Delete Resource Team Members
   This package validates the input parameters to these procedures and then
   Calls corresponding  procedures from jtf_rs_team_members_pvt
   to do business validations and to do actual inserts, updates and deletes into tables.
   ******************************************************************************************/

  /* Package variables. */

  G_PKG_NAME         VARCHAR2(30) := 'JTF_RS_TEAM_MEMBERS_PUB';

Line: 233

  /* Procedure to delete the resource team members. */

  PROCEDURE  delete_resource_team_members
  (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_MEMBERS.TEAM_ID%TYPE,
   P_TEAM_NUMBER          IN   JTF_RS_TEAMS_VL.TEAM_NUMBER%TYPE,
   P_TEAM_RESOURCE_ID     IN   JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,
   P_TEAM_RESOURCE_NUMBER IN   NUMBER,
   P_RESOURCE_TYPE        IN   JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
   P_OBJECT_VERSION_NUM   IN   JTF_RS_TEAM_MEMBERS.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: 251

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

Line: 266

    SAVEPOINT delete_resource_member_pub;

Line: 377

    /* Call the private procedure for delete */

    jtf_rs_team_members_pvt.delete_resource_team_members
    (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_TEAM_RESOURCE_ID => l_team_resource_id,
     P_RESOURCE_TYPE => l_resource_type,
     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: 420

      ROLLBACK TO delete_resource_member_pub;

Line: 435

      ROLLBACK TO delete_resource_member_pub;

Line: 442

  END delete_resource_team_members;