APPS.WF_MAIL dependencies on WF_LANGUAGES

Line 7417: from WF_LANGUAGES

7413: raise NO_DATA_FOUND;
7414: end if;
7415: select NLS_CODESET
7416: into charset
7417: from WF_LANGUAGES
7418: where NLS_LANGUAGE = lang
7419: and NLS_TERRITORY = terr;
7420: exception
7421: when NO_DATA_FOUND then

Line 7425: from WF_LANGUAGES

7421: when NO_DATA_FOUND then
7422: -- try to find the character set base on language alone
7423: select NLS_CODESET
7424: into charset
7425: from WF_LANGUAGES
7426: where NLS_LANGUAGE = lang
7427: and rownum < 2;
7428: end;
7429: exception

Line 7488: from wf_languages

7484: -- NLSMapper to get IANA EQ or NOT.
7485: begin
7486: select override_email_charset
7487: into db_override_cs
7488: from wf_languages
7489: where code ='WFCS'
7490: and rownum < 2 ; -- This language code is being used to store
7491: -- overridden DB default char-set, if any.
7492: exception

Line 7702: from wf_languages

7698: select nvl(OVERRIDE_EMAIL_CHARSET,nls_codeset),
7699: installed_flag,
7700: decode(OVERRIDE_EMAIL_CHARSET, null, 'N', 'Y')
7701: into l_codeset, l_install , l_is_iana_cs
7702: from wf_languages
7703: where nls_language = l_lang
7704: AND installed_flag = 'Y';
7705:
7706: p_language := l_lang;

Line 7722: from wf_languages

7718: select nvl(OVERRIDE_EMAIL_CHARSET,nls_codeset),
7719: installed_flag,
7720: decode(OVERRIDE_EMAIL_CHARSET, null, 'N', 'Y')
7721: into l_codeset, l_install , l_is_iana_cs
7722: from wf_languages
7723: where nls_language = p_language
7724: and installed_flag = 'Y';
7725:
7726: p_codeset := l_codeset;

Line 8345: FROM WF_LANGUAGES

8341:
8342: begin
8343: SELECT NLS_CODESET, INSTALLED_FLAG
8344: INTO l_codeset,l_installed
8345: FROM WF_LANGUAGES
8346: WHERE NLS_LANGUAGE = l_language
8347: AND INSTALLED_FLAG = 'Y';
8348: exception
8349: when no_data_found then