Rem
Rem
Rem load_trans.sql
Rem
Rem Copyright (c) 2006, Oracle Corporation.  All rights reserved.  
Rem
Rem    NAME
Rem      load_trans.sql - APEX Translations Install
Rem
Rem    DESCRIPTION
Rem      Based on passed-in language name, run the appropriate
Rem      language-specific install script. Should be run as SYS.
Rem
Rem
Rem    MODIFIED   (MM/DD/YYYY)
Rem     jstraub    09/14/2004 - Created
Rem     jstraub    09/27/2004 - Added alter session set current_schema
Rem     jkallman   01/04/2005 - Adjusted schema to FLOWS_020000
Rem     jkallman   09/14/2005 - Adjusted schema to FLOWS_020100
Rem     jkallman   01/23/2006 - Adjusted schema to FLOWS_020200
Rem     jkallman   09/29/2006 - Adjusted schema to FLOWS_030000
Rem     jkallman   08/02/2007 - Change FLOWS_030000 references to FLOWS_030100
Rem     jkallman   09/09/2008 - Change FLOWS_030100 references to APEX_030200


alter session set current_schema = APEX_030200;

DEFINE nls_language = "&1"
COLUMN lang_abbr NEW_VALUE lang_abbr

SELECT DECODE('&nls_language',
'BRAZILIAN PORTUGUESE', 'pt-br',
'FRENCH', 'fr',
'GERMAN', 'de',
'ITALIAN', 'it',
'JAPANESE', 'ja',
'KOREAN', 'ko',
'SIMPLIFIED CHINESE', 'zh-cn',
'SPANISH', 'es',
'TRADITIONAL CHINESE', 'zh-tw',
'de') 
lang_abbr FROM dual;

@@builder/&lang_abbr/load_&lang_abbr..sql