APPS.WF_SOA_CTX_PKG dependencies on FND_LANGUAGES

Line 5: pAppsBaseLang fnd_languages.nls_language%type;

1: PACKAGE body WF_SOA_CTX_PKG AS
2: /* $Header: WFSOACTXB.pls 120.0.12010000.9 2009/07/26 07:09:15 snellepa noship $ */
3:
4:
5: pAppsBaseLang fnd_languages.nls_language%type;
6:
7: /* private function to get apps base Language Code */
8: function getAppsBaseLang
9: return varchar2

Line 16: FROM fnd_languages

12:
13: IF WF_SOA_CTX_PKG.pAppsBaseLang IS NULL THEN
14: SELECT language_code
15: INTO WF_SOA_CTX_PKG.pAppsBaseLang
16: FROM fnd_languages
17: WHERE Installed_flag = 'B';
18: END IF;
19:
20: return WF_SOA_CTX_PKG.pAppsBaseLang;

Line 27: pTemp fnd_languages.nls_language%type;

23: /* private procedure to get User specific Language Details*/
24:
25: procedure getUserLang( userId Number, lang_code OUT NOCOPY varchar2)
26: is
27: pTemp fnd_languages.nls_language%type;
28: begin
29: pTemp:=fnd_profile.value_specific('ICX_LANGUAGE',user_id=>userId);
30: SELECT language_code
31: INTO lang_code

Line 32: FROM fnd_languages

28: begin
29: pTemp:=fnd_profile.value_specific('ICX_LANGUAGE',user_id=>userId);
30: SELECT language_code
31: INTO lang_code
32: FROM fnd_languages
33: WHERE nls_language = pTemp
34: and Installed_flag in ('B','I');
35: exception
36: WHEN No_Data_found THEN

Line 147: FROM fnd_languages

143: ELSE -- language is specifed
144: IF pIsLangCode=1 THEN -- and it has been specified as Code
145: SELECT language_code
146: INTO pLangCode
147: FROM fnd_languages
148: WHERE language_code = upper(pLang)
149: and Installed_flag in ('B','I');
150:
151: ELSE -- it has been specied as Name ( in English !!)

Line 154: FROM fnd_languages

150:
151: ELSE -- it has been specied as Name ( in English !!)
152: SELECT language_code
153: INTO pLangCode
154: FROM fnd_languages
155: WHERE nls_language = upper(pLang)
156: and Installed_flag in ('B','I');
157:
158:

Line 319: pLangCode fnd_languages.language_code%TYPE;

315: pnlslanguage VARCHAR2,
316: pIsLangCode NUMBER default 0,
317: pOrgId NUMBER)
318: IS
319: pLangCode fnd_languages.language_code%TYPE;
320: pUserId fnd_user.user_id%TYPE;
321: pAppId fnd_application.application_id%TYPE;
322: pRespId fnd_responsibility.responsibility_id%TYPE;
323: pSecGrpId fnd_security_groups.security_group_id%TYPE;