APPS.WSH_RU_ROLES_PVT SQL Statements

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

Line: 7

  PROCEDURE Insert_Row(
	p_role_record	IN  Role_Type,
	x_rowid		OUT NOCOPY  VARCHAR2,
	x_role_id	OUT NOCOPY  NUMBER,
	x_return_status OUT NOCOPY  VARCHAR2) IS

    wsh_duplicate_name		EXCEPTION;

Line: 16

        SELECT role_id  FROM WSH_ROLES WHERE name = p_role_record.name;

Line: 19

       SELECT wsh_roles_s.nextval FROM DUAL;

Line: 22

       SELECT rowid FROM WSH_ROLES WHERE role_id = x_role_id;

Line: 31

l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'INSERT_ROW';

Line: 71

    INSERT INTO WSH_ROLES (
	ROLE_ID,
	NAME,
	DESCRIPTION,
	CREATED_BY,
	CREATION_DATE,
	LAST_UPDATED_BY,
	LAST_UPDATE_DATE,
	LAST_UPDATE_LOGIN
	) VALUES (
	l_role_id,
	p_role_record.NAME,
	p_role_record.DESCRIPTION,
	p_role_record.CREATED_BY,
	p_role_record.CREATION_DATE,
	p_role_record.LAST_UPDATED_BY,
	p_role_record.LAST_UPDATE_DATE,
	p_role_record.LAST_UPDATE_LOGIN
	);

Line: 125

	wsh_util_core.default_handler('WSH_RU_ROLES_PVT.INSERT_ROW');

Line: 135

  END Insert_Row;

Line: 143

	SELECT * FROM WSH_ROLES
	WHERE rowid = p_rowid
	FOR UPDATE OF ROLE_ID NOWAIT;

Line: 177

      FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');

Line: 188

       AND (l_db_rec.LAST_UPDATED_BY = p_role_record.LAST_UPDATED_BY)
       AND (l_db_rec.LAST_UPDATE_DATE = p_role_record.LAST_UPDATE_DATE)
       AND ((l_db_rec.LAST_UPDATE_LOGIN = p_role_record.LAST_UPDATE_LOGIN)
            OR (    l_db_rec.LAST_UPDATE_LOGIN IS NULL
                AND p_role_record.LAST_UPDATE_LOGIN IS NULL))
    THEN
      --
      -- Debug Statements
      --
      IF l_debug_on THEN
          WSH_DEBUG_SV.pop(l_module_name);

Line: 263

  PROCEDURE Update_Row(
	p_rowid		IN  VARCHAR2,
	p_role_record	IN  Role_Type,
	x_return_status OUT NOCOPY  VARCHAR2) IS
	--

        CURSOR c_dup_role_name IS
        SELECT role_id  FROM WSH_ROLES
        WHERE name = p_role_record.name
        AND ROLE_ID <> p_role_record.ROLE_ID;

Line: 280

	l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'UPDATE_ROW';

Line: 311

    UPDATE WSH_ROLES
    SET
	ROLE_ID		  =  p_role_record.ROLE_ID,
	NAME		  =  p_role_record.NAME,
	DESCRIPTION	  =  p_role_record.DESCRIPTION,
	CREATED_BY	  =  p_role_record.CREATED_BY,
	CREATION_DATE	  =  p_role_record.CREATION_DATE,
	LAST_UPDATED_BY	  =  p_role_record.LAST_UPDATED_BY,
	LAST_UPDATE_DATE  =  p_role_record.LAST_UPDATE_DATE,
	LAST_UPDATE_LOGIN =  p_role_record.LAST_UPDATE_LOGIN
    WHERE ROLE_ID = p_role_record.ROLE_ID;

Line: 355

	wsh_util_core.default_handler('WSH_RU_ROLES_PVT.UPDATE_ROW');

Line: 365

  END Update_Row;

Line: 368

  PROCEDURE Delete_Row(
	p_rowid		IN  VARCHAR2,
	x_return_status OUT NOCOPY  VARCHAR2) IS
	--
l_debug_on BOOLEAN;

Line: 374

	l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'DELETE_ROW';

Line: 395

    DELETE FROM WSH_ROLES
    WHERE rowid = p_rowid;

Line: 412

	wsh_util_core.default_handler('WSH_RU_ROLES_PVT.DELETE_ROW');

Line: 422

  END Delete_Row;