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 1487: from WF_LANGUAGES

1483: --
1484: if (language is null or territory is null) then
1485: begin
1486: select nls_territory, nls_language into nterr, nlang
1487: from WF_LANGUAGES
1488: where code = userenv('LANG');
1489: exception
1490: when NO_DATA_FOUND then
1491: wf_core.raise('WF_NO_LANG_TERR');

Line 1908: from WF_LANGUAGES

1904: --
1905: if (language is null or territory is null) then
1906: begin
1907: select nls_territory, nls_language into nterr, nlang
1908: from WF_LANGUAGES
1909: where code = userenv('LANG');
1910:
1911: exception
1912: when NO_DATA_FOUND then