APPS.JTF_RS_GROUP_ORGS_PUB SQL Statements

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

Line: 7

   create, update and delete from other modules.
   Its main procedures are as following:
   Create Resource Group to HR Org mapping
   Update Resource Group to HR Org mapping
   Delete Resource Group to HR Org mapping
   Calls to these procedures will invoke procedures from jtf_rs_group_orgs_pvt
   to do business validations and to do actual inserts, updates and deletes into
   tables.
   ******************************************************************************************/

  /* Package variables. */

  G_PKG_NAME        CONSTANT VARCHAR2(30) := 'JTF_RS_GROUP_ORGS_PUB';

Line: 125

  /* Procedure to update the Resource Group to HR Org mapping Attributes
	based on input values passed by calling routines. */

  PROCEDURE  update_group_org
  (P_API_VERSION           IN  NUMBER,
   P_INIT_MSG_LIST         IN  VARCHAR2,
   P_COMMIT                IN  VARCHAR2,
   P_GROUP_ID              IN  JTF_RS_GROUP_ORGANIZATIONS.GROUP_ID%TYPE,
   P_ORGANIZATION_ID       IN  JTF_RS_GROUP_ORGANIZATIONS.ORGANIZATION_ID%TYPE,
   P_ATTRIBUTE1            IN  JTF_RS_GROUP_ORGANIZATIONS.ATTRIBUTE1%TYPE,
   P_ATTRIBUTE2            IN  JTF_RS_GROUP_ORGANIZATIONS.ATTRIBUTE2%TYPE,
   P_ATTRIBUTE3            IN  JTF_RS_GROUP_ORGANIZATIONS.ATTRIBUTE3%TYPE,
   P_ATTRIBUTE4            IN  JTF_RS_GROUP_ORGANIZATIONS.ATTRIBUTE4%TYPE,
   P_ATTRIBUTE5            IN  JTF_RS_GROUP_ORGANIZATIONS.ATTRIBUTE5%TYPE,
   P_ATTRIBUTE6            IN  JTF_RS_GROUP_ORGANIZATIONS.ATTRIBUTE6%TYPE,
   P_ATTRIBUTE7            IN  JTF_RS_GROUP_ORGANIZATIONS.ATTRIBUTE7%TYPE,
   P_ATTRIBUTE8            IN  JTF_RS_GROUP_ORGANIZATIONS.ATTRIBUTE8%TYPE,
   P_ATTRIBUTE9            IN  JTF_RS_GROUP_ORGANIZATIONS.ATTRIBUTE9%TYPE,
   P_ATTRIBUTE10           IN  JTF_RS_GROUP_ORGANIZATIONS.ATTRIBUTE10%TYPE,
   P_ATTRIBUTE11           IN  JTF_RS_GROUP_ORGANIZATIONS.ATTRIBUTE11%TYPE,
   P_ATTRIBUTE12           IN  JTF_RS_GROUP_ORGANIZATIONS.ATTRIBUTE12%TYPE,
   P_ATTRIBUTE13           IN  JTF_RS_GROUP_ORGANIZATIONS.ATTRIBUTE13%TYPE,
   P_ATTRIBUTE14           IN  JTF_RS_GROUP_ORGANIZATIONS.ATTRIBUTE14%TYPE,
   P_ATTRIBUTE15           IN  JTF_RS_GROUP_ORGANIZATIONS.ATTRIBUTE15%TYPE,
   P_ATTRIBUTE_CATEGORY    IN  JTF_RS_GROUP_ORGANIZATIONS.ATTRIBUTE_CATEGORY%TYPE,
   P_OBJECT_VERSION_NUMBER IN OUT NOCOPY JTF_RS_GROUP_ORGANIZATIONS.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: 157

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

Line: 161

    SAVEPOINT sp_update_group_org;

Line: 174

    JTF_RS_GROUP_ORGS_PVT.update_group_org
         (P_API_VERSION           => P_API_VERSION,
          P_INIT_MSG_LIST         => P_INIT_MSG_LIST,
	      P_COMMIT                => P_COMMIT,
          P_GROUP_ID              => P_GROUP_ID,
          P_ORGANIZATION_ID       => P_ORGANIZATION_ID,
          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,
          P_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER,
          X_RETURN_STATUS         => X_RETURN_STATUS,
          X_MSG_COUNT             => X_MSG_COUNT,
          X_MSG_DATA              => X_MSG_DATA
		  );

Line: 215

      ROLLBACK TO sp_update_group_org;

Line: 220

      ROLLBACK TO sp_update_group_org;

Line: 229

  END update_group_org;

Line: 231

  /* Procedure to delete resource group - HR Org mapping  */

  PROCEDURE  delete_group_org
  (P_API_VERSION            IN  NUMBER,
   P_INIT_MSG_LIST          IN  VARCHAR2,
   P_COMMIT                 IN  VARCHAR2,
   P_GROUP_ID               IN  JTF_RS_GROUP_ORGANIZATIONS.GROUP_ID%TYPE,
   P_ORGANIZATION_ID        IN  JTF_RS_GROUP_ORGANIZATIONS.ORGANIZATION_ID%TYPE,
   P_OBJECT_VERSION_NUMBER  IN  JTF_RS_GROUP_ORGANIZATIONS.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: 246

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

Line: 250

    SAVEPOINT sp_delete_group_org;

Line: 263

    JTF_RS_GROUP_ORGS_PVT.delete_group_org
         (P_API_VERSION           => P_API_VERSION,
          P_INIT_MSG_LIST         => P_INIT_MSG_LIST,
	      P_COMMIT                => P_COMMIT,
          P_GROUP_ID              => P_GROUP_ID,
          P_ORGANIZATION_ID       => P_ORGANIZATION_ID,
          P_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER,
          X_RETURN_STATUS         => X_RETURN_STATUS,
          X_MSG_COUNT             => X_MSG_COUNT,
          X_MSG_DATA              => X_MSG_DATA
		  );

Line: 288

      ROLLBACK TO sp_delete_group_org;

Line: 293

      ROLLBACK TO sp_delete_group_org;

Line: 302

  END delete_group_org;