APPS.ISG_BPEL_CTX_PKG dependencies on FND_LANGUAGES

Line 3: pAppsBaseLang fnd_languages.nls_language%type;

1: PACKAGE body ISG_BPEL_CTX_PKG AS
2: /* $Header: ISGBPELCTXB.pls 120.0.12020000.5 2013/05/21 09:55:27 smunnalu noship $ */
3: pAppsBaseLang fnd_languages.nls_language%type;
4:
5:
6: function getAppsBaseLang
7: return varchar2

Line 14: FROM fnd_languages

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

Line 26: pTemp fnd_languages.nls_language%type;

22:
23: procedure getUserLang( userId Number,
24: lang_code OUT NOCOPY varchar2)
25: is
26: pTemp fnd_languages.nls_language%type;
27: begin
28: pTemp:=fnd_profile.value_specific('ICX_LANGUAGE',user_id=>userId);
29: SELECT language_code
30: INTO lang_code

Line 31: FROM fnd_languages

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

Line 85: FROM fnd_languages

81: ISG_BPEL_CTX_PKG.getUserLang( pUserID, pLangCode);
82: ELSE
83: SELECT language_code
84: INTO pLangCode
85: FROM fnd_languages
86: WHERE nls_language = upper(pLang)
87: and Installed_flag in ('B','I');
88: END IF;
89: SELECT message_text