The APEX_PKG_APP_INSTALL package provides utilities you can use to manage Packaged Applications. You can use APEX_PKG_APP_INSTALL package to install, upgrade, and deinstall packaged application from the command line. Before using the package, the security_group_id must be set by calling either APEX_UTIL.SET_WORKSPACE or APEX_UTIL.SET_SECURITY_GROUP_ID. The related APEX views to get more information on packaged applications are APEX_PKG_APP_AUTHENTICATIONS, APEX_PKG_APP_AVAILABLE, APEX_PKG_APP_INSTALLED, and APEX_PKG_APP_ACTIVITY.
Note:
APEX_PKG_APP_INSTALL supports managing database packaged applications and does not support websheet packaged applications.