APPS.WF_DIRECTORY dependencies on WF_LANGUAGES

Line 637: -- installed_flag - Y when a language is installed in WF_LANGUAGES,

633: -- language
634: -- territory
635: -- orig_system
636: -- orig_system_id
637: -- installed_flag - Y when a language is installed in WF_LANGUAGES,
638: -- N otherwise.
639: --
640: procedure GetRoleInfoMail(
641: role in varchar2,

Line 667: from WF_LANGUAGES

663:
664: begin
665: select nvl(INSTALLED_FLAG, 'N')
666: into GetRoleInfoMail.installed_flag
667: from WF_LANGUAGES
668: where NLS_LANGUAGE = GetRoleInfoMail.language;
669: exception
670: when NO_DATA_FOUND then
671: installed_flag := 'N';

Line 724: from WF_LANGUAGES

720:
721: begin
722: select nvl(INSTALLED_FLAG, 'N')
723: into GetRoleInfoMail2.p_installed_flag
724: from WF_LANGUAGES
725: where NLS_LANGUAGE = GetRoleInfoMail2.p_nlsLanguage;
726: exception
727: when NO_DATA_FOUND then
728: p_installed_flag := 'N';

Line 1345: from WF_LANGUAGES

1341: --
1342: if (language is null or territory is null) then
1343: begin
1344: select nls_territory, nls_language into nterr, nlang
1345: from WF_LANGUAGES
1346: where code = userenv('LANG');
1347: exception
1348: when NO_DATA_FOUND then
1349: wf_core.raise('WF_NO_LANG_TERR');

Line 1766: from WF_LANGUAGES

1762: --
1763: if (language is null or territory is null) then
1764: begin
1765: select nls_territory, nls_language into nterr, nlang
1766: from WF_LANGUAGES
1767: where code = userenv('LANG');
1768:
1769: exception
1770: when NO_DATA_FOUND then