APPS.WSH_RU_ROLE_PRIVILEGES_PVT SQL Statements

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

Line: 7

  PROCEDURE Insert_Row(
	p_role_privilege_record	IN  Role_Privilege_Type,
	x_rowid		        OUT NOCOPY  VARCHAR2,
	x_role_privilege_id	OUT NOCOPY  NUMBER,
	x_return_status         OUT NOCOPY  VARCHAR2) IS

    CURSOR c_new_role_privilege_id IS
       SELECT wsh_role_privileges_s.nextval FROM DUAL;

Line: 17

       SELECT rowid FROM WSH_ROLE_PRIVILEGES WHERE role_privilege_id = x_role_privilege_id;

Line: 25

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

Line: 57

    INSERT INTO WSH_ROLE_PRIVILEGES (
	ROLE_PRIVILEGE_ID,
	ROLE_ID,
	PRIVILEGE_CODE,
	CREATED_BY,
	CREATION_DATE,
	LAST_UPDATED_BY,
	LAST_UPDATE_DATE,
	LAST_UPDATE_LOGIN
	) VALUES (
	l_role_privilege_id,
	p_role_privilege_record.ROLE_ID,
	p_role_privilege_record.PRIVILEGE_CODE,
	p_role_privilege_record.CREATED_BY,
	p_role_privilege_record.CREATION_DATE,
	p_role_privilege_record.LAST_UPDATED_BY,
	p_role_privilege_record.LAST_UPDATE_DATE,
	p_role_privilege_record.LAST_UPDATE_LOGIN
	);

Line: 95

	wsh_util_core.default_handler('WSH_RU_ROLE_PRIVILEGES_PVT.INSERT_ROW',l_module_name);

Line: 102

  END Insert_Row;

Line: 110

	SELECT * FROM WSH_ROLE_PRIVILEGES
	WHERE rowid = p_rowid
	FOR UPDATE OF ROLE_PRIVILEGE_ID NOWAIT;

Line: 141

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

Line: 143

         WSH_DEBUG_SV.log(l_module_name,'FORM_RECORD_DELETED');

Line: 153

       AND (l_db_rec.LAST_UPDATED_BY = p_role_privilege_record.LAST_UPDATED_BY)
       AND (l_db_rec.LAST_UPDATE_DATE = p_role_privilege_record.LAST_UPDATE_DATE)
       AND ((l_db_rec.LAST_UPDATE_LOGIN = p_role_privilege_record.LAST_UPDATE_LOGIN)
            OR (    l_db_rec.LAST_UPDATE_LOGIN IS NULL
                AND p_role_privilege_record.LAST_UPDATE_LOGIN IS NULL))
    THEN
      --
      IF l_debug_on THEN
          WSH_DEBUG_SV.pop(l_module_name,'Noting Changed');

Line: 212

  PROCEDURE Update_Row(
	p_rowid		IN  VARCHAR2,
	p_role_privilege_record	IN  Role_Privilege_Type,
	x_return_status OUT NOCOPY  VARCHAR2) IS
	--
l_debug_on BOOLEAN;

Line: 219

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

Line: 237

    UPDATE WSH_ROLE_PRIVILEGES
    SET
	ROLE_ID		  =  p_role_privilege_record.ROLE_ID,
	PRIVILEGE_CODE	  =  p_role_privilege_record.PRIVILEGE_CODE,
	CREATED_BY	  =  p_role_privilege_record.CREATED_BY,
	CREATION_DATE	  =  p_role_privilege_record.CREATION_DATE,
	LAST_UPDATED_BY	  =  p_role_privilege_record.LAST_UPDATED_BY,
	LAST_UPDATE_DATE  =  p_role_privilege_record.LAST_UPDATE_DATE,
	LAST_UPDATE_LOGIN =  p_role_privilege_record.LAST_UPDATE_LOGIN
    WHERE rowid = p_rowid;

Line: 249

       WSH_DEBUG_SV.log(l_module_name,'Rows Updated',SQL%ROWCOUNT);

Line: 264

	wsh_util_core.default_handler('WSH_RU_ROLE_PRIVILEGES_PVT.UPDATE_ROW',l_module_name);

Line: 271

  END Update_Row;

Line: 274

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

Line: 280

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

Line: 298

    DELETE FROM WSH_ROLE_PRIVILEGES
    WHERE rowid = p_rowid;

Line: 306

        WSH_DEBUG_SV.log(l_module_name,'Rows Deleted',SQL%ROWCOUNT);

Line: 313

	wsh_util_core.default_handler('WSH_RU_ROLE_PRIVILEGES_PVT.DELETE_ROW',l_module_name);

Line: 320

  END Delete_Row;

Line: 329

  PROCEDURE Delete_Role_Privileges(p_role_id in NUMBER,
                        x_return_status OUT NOCOPY VARCHAR2)


  IS

  l_debug_on BOOLEAN;

Line: 337

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

Line: 356

    DELETE FROM WSH_ROLE_PRIVILEGES
    WHERE role_id = p_role_id
    AND    privilege_code
	         IN('TRIP_VIEW','TRIP_EDIT',
	            'STOP_VIEW','STOP_EDIT',
	            'DLVY_VIEW','DLVY_EDIT',
	            'DLVB_VIEW','DLVB_EDIT',
	            'GENR_VIEW','GENR_EDIT'); -- Added AND condition for R12

Line: 370

        WSH_DEBUG_SV.log(l_module_name,'Rows Deleted',SQL%ROWCOUNT);

Line: 377

        wsh_util_core.default_handler('WSH_RU_ROLE_PRIVILEGES_PVT.DELETE_ROLR',l_module_name);

Line: 384

  END Delete_Role_Privileges;