When you declare your cursor there is a LOCAL option you can include which makes the cursor local to that stored procedure. For recursive procedures when there is no way...
Not sure exactly what you're looking for but General Code Publishers has vast experience setting up systems for local governments exactly like you described. They have a large customer base...