29 APEX_EXTENSION

The APEX_EXTENSION package contains utility functions used for invoking extension applications.

This API can be used in the following contexts:

• in an Oracle APEX session context of a workspace that has the Component Availability attribute Allow Hosting Extensions enabled (is an extension workspace)
• this extension workspace has created links in its Extension Menu with attribute public set to Yes
• another workspace is subscribed to the extension workspace's published extension menu and granted read acces to the extension workspace

The API can be called in Automations or in database sessions using APEX_SESSION.CREATE_SESSION to establish an APEX session context. Invoking the procedure from the extension workspace, with the subscribed workspace name or ID, from an automation of an application in that extension workspace or session in a database schema associated to it, changes the behavior of application-related public APEX views such that querying them returns the application metadata of that subscribed workspace, but not the metadata of the "own" workspace anymore.

• ADD_MENU_ENTRY Procedure
  
• GET_GRANTOR_WORKSPACE Function
  
• REMOVE_MENU_ENTRY Procedure
  
• SET_WORKSPACE Procedure Signature 1
  
• SET_WORKSPACE Procedure Signature 2