Actually I do not think there is any difference in the two. The cursor will remain the same. As package is a group of functions/procedures, You can declare cursors in the package specifications {global access} or the package body {local access}. In procedures, cursors are limited to that procedure itself and cannot be accessed outside the procedure.

Hope this helps...!

Regards