Use this procedure to publish the translated version of an application. This procedure creates an underlying, hidden replica of the primary application and merges the strings from the translation repository in this new application. Perform a seed and publish process each time you want to update the translated version of your application and synchronize it with the primary application.
This application is not visible in the App Builder. It can be published and exported, but not directly edited.
This procedure is available in Application Express release 4.2.3 and later.
APEX_LANG.PUBLISH_APPLICATION ( p_application_id IN NUMBER, p_language IN VARCHAR2 )
Table 16-5 PUBLISH_APPLICATION Parameters
The ID of the application for which you want to publish and create the translated version. This is the ID of the primary language application.
The IANA language code for the existing translation mapping. Examples include en-us, fr-ca, ja, he.
The following example demonstrates the publish process for an Application Express application and language.
begin -- -- If running from SQL*Plus, we need to set the environment -- for the Application Express workspace associated with this schema. The -- call to apex_util.set_security_group_id is not necessary if -- you're running within the context of the App Builder -- or an Application Express application. -- for c1 in (select workspace_id from apex_workspaces) loop apex_util.set_security_group_id( c1.workspace_id ); exit; end loop; -- Now, publish the translated version of the application apex_lang.publish_application( p_application_id => 63969, p_language => 'ja' ); commit; end; /