Line 927: SELECT SUBSTR(userenv('LANG'),1,4) INTO ls_lang FROM dual;
923: OR LOB_TYPE = 'MLS_TEMPLATE')
924: AND LANGUAGE = p_lang
925: AND XDO_FILE_TYPE = 'XSL-FO';
926: BEGIN 927: SELECT SUBSTR(userenv('LANG'),1,4) INTO ls_lang FROM dual; 928: IF ls_lang = 'US' THEN
929: p_lang := 'en' ;
930: ELSE
931: p_lang := lower(ls_lang);