PUBLISH_APPLICATION Procedure

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.

Note:

This procedure is available in Oracle APEX release 4.2.3 and later.

Syntax

APEX_LANG.PUBLISH_APPLICATION (
    p_application_id           IN NUMBER,
    p_language                 IN VARCHAR2,
    p_new_trans_application_id IN NUMBER DEFAULT NULL );

Parameters

Parameter	Description
`p_application_id`	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.
`p_language`	The IANA language code for the existing translation mapping. Examples include `en-us`, `fr-ca`, `ja`, `he`.
`p_new_trans_application_id`	(Optional) Specifies a new application ID for the language being published. When provided, it updates the existing language-mapping with the new application ID.

Example

The following example demonstrates the publish process for an APEX application and language.

begin
    --
    -- If running from SQLcl, we need to set the environment
    -- for the Oracle APEX 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 APEX 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;
/