Add a stored procedure to handle entity deletions

Add a stored procedure to handle entity deletions #2974