OK, amazing response, it worked like a charm and is exactly what I was looking for:
FETCH get_all_locations BULK COLLECT INTO v_all_locations;
I need to iterate over this collection at various points (in multiple procedures) in order to move some data around. This collection represents the root nodes (by specifying the type to the cursor) and now I need to get all the children but this will be the topic of an additional post.
I have a representation in the DB like a folder structure and need to create another collection that consists of all children depth first and not sure how to do this. I appreciate this response, I learned a lot.