Use this procedure to seed the translation repository for the specified application and language. This procedure populates the translation repository with all of the new, updated and removed translatable strings from your 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.
APEX_LANG.SEED_TRANSLATIONS ( p_application_id IN NUMBER, p_language IN VARCHAR2 )
Table 22-6 SEED_TRANSLATIONS Parameters
The ID of the application for which you want to update the translation repository. 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 seeding process of the translation repository 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, seed the translation repository apex_lang.seed_translations( p_application_id => 63969, p_language => 'ja' ); commit; -- Print out the total number of potentially translatable strings -- for c1 in (select count(*) thecount from apex_application_trans_repos where application_id = 63969) loop dbms_output.put_line( 'Potentially translatable strings found: ' || c1.thecount ); end loop; end; /