It works like an installer: you place it on a USB drive or internal HDD, then install it via the PS3’s “Install Package Files” menu (available only on custom firmware or developer units).
Example: Downloading a free homebrew PKG from a trusted developer. Ps3 Pkg File Download