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