Question on Oracle Public DB link inside Procedures
This depends on how the link was set up. A public link means it is accessible to anyone to access the link but the credentials used to access the remote DB can either be those of the current user or a specific user.

Take a look at CREATE DATABASE LINK for the full syntax and explanations.