APPS.WF_MAIL dependencies on WF_LANGUAGES

Line 7163: from WF_LANGUAGES

7159: raise NO_DATA_FOUND;
7160: end if;
7161: select NLS_CODESET
7162: into charset
7163: from WF_LANGUAGES
7164: where NLS_LANGUAGE = lang
7165: and NLS_TERRITORY = terr;
7166: exception
7167: when NO_DATA_FOUND then

Line 7171: from WF_LANGUAGES

7167: when NO_DATA_FOUND then
7168: -- try to find the character set base on language alone
7169: select NLS_CODESET
7170: into charset
7171: from WF_LANGUAGES
7172: where NLS_LANGUAGE = lang
7173: and rownum < 2;
7174: end;
7175: exception

Line 7401: from wf_languages

7397: -- Check for validity of notification's language
7398: begin
7399: select nls_codeset, installed_flag
7400: into l_codeset, l_install
7401: from wf_languages
7402: where nls_language = l_lang;
7403: exception
7404: when others then
7405: l_install := 'N';

Line 7420: from wf_languages

7416: -- Notification level language is not installed, use user's preference
7417: begin
7418: select nls_codeset, installed_flag
7419: into p_codeset, l_install
7420: from wf_languages
7421: where nls_language = p_language;
7422: exception
7423: when others then
7424: l_install := 'N';

Line 7453: from wf_languages

7449: if (l_terr is not null) then
7450: begin
7451: select 'Y'
7452: into l_install
7453: from wf_languages
7454: where nls_territory = l_terr;
7455: -- Notification level territory is valid
7456: p_territory := l_terr;
7457: exception

Line 7468: from wf_languages

7464: if (l_install = 'N') then
7465: begin
7466: select 'Y'
7467: into l_install
7468: from wf_languages
7469: where nls_territory = p_territory;
7470: exception
7471: when others then
7472: -- Neither notification level nor user's territory preference is

Line 8026: FROM WF_LANGUAGES

8022:
8023: begin
8024: SELECT NLS_CODESET, INSTALLED_FLAG
8025: INTO l_codeset,l_installed
8026: FROM WF_LANGUAGES
8027: WHERE NLS_LANGUAGE = l_language
8028: AND INSTALLED_FLAG = 'Y';
8029: exception
8030: when no_data_found then