APPS.JTF_RS_JOB_ROLES_PVT SQL Statements

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

Line: 6

   like create and delete resource job roles.
   Its main procedures are as following:
   Create Resource Job Roles
   Delete Resource Job Roles
   These procedures does the business validations and then Calls the corresponding
   table handlers to do actual inserts and deletes into tables.
   ******************************************************************************************/

  /* Package variables. */

  G_PKG_NAME         VARCHAR2(30) := 'JTF_RS_JOB_ROLES_PVT';

Line: 61

	 SELECT 'Y'
	 FROM jtf_rs_job_roles
	 WHERE ROWID = l_rowid;

Line: 92

    SELECT count(*)
    INTO l_check_count
    FROM jtf_rs_job_roles
    WHERE job_id = l_job_id
	 AND role_id = l_role_id;

Line: 112

    SELECT jtf_rs_job_roles_s.nextval
    INTO l_job_role_id
    FROM dual;

Line: 117

    /* Insert the row into the table by calling the table handler. */

    jtf_rs_job_roles_pkg.insert_row(
      x_rowid => l_rowid,
      x_job_role_id => l_job_role_id,
      x_job_id => l_job_id,
      x_role_id => l_role_id,
      x_attribute1 => p_attribute1,
      x_attribute2 => p_attribute2,
      x_attribute3 => p_attribute3,
      x_attribute4 => p_attribute4,
      x_attribute5 => p_attribute5,
      x_attribute6 => p_attribute6,
      x_attribute7 => p_attribute7,
      x_attribute8 => p_attribute8,
      x_attribute9 => p_attribute9,
      x_attribute10 => p_attribute10,
      x_attribute11 => p_attribute11,
      x_attribute12 => p_attribute12,
      x_attribute13 => p_attribute13,
      x_attribute14 => p_attribute14,
      x_attribute15 => p_attribute15,
      x_attribute_category => p_attribute_category,
      x_creation_date => SYSDATE,
      x_created_by => jtf_resource_utl.created_by,
      x_last_update_date => SYSDATE,
      x_last_updated_by => jtf_resource_utl.updated_by,
      x_last_update_login => jtf_resource_utl.login_id
    );

Line: 218

  /* Procedure to delete the resource job roles. */

  PROCEDURE  delete_resource_job_roles
  (P_API_VERSION          IN   NUMBER,
   P_INIT_MSG_LIST        IN   VARCHAR2,
   P_COMMIT               IN   VARCHAR2,
   P_JOB_ROLE_ID          IN   JTF_RS_JOB_ROLES.JOB_ROLE_ID%TYPE,
   P_OBJECT_VERSION_NUM   IN   JTF_RS_JOB_ROLES.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: 234

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

Line: 242

    SAVEPOINT delete_resource_job_role_pvt;

Line: 286

    /* Call the private procedure for logical delete */

    BEGIN

      /* Delete the row into the table by calling the table handler. */

      jtf_rs_job_roles_pkg.delete_row(
        x_job_role_id => l_job_role_id
      );

Line: 324

      ROLLBACK TO delete_resource_job_role_pvt;

Line: 333

      ROLLBACK TO delete_resource_job_role_pvt;

Line: 340

  END delete_resource_job_roles;