DBA Data[Home] [Help]

APPS.OTA_MLS_UTILITY dependencies on FND_LANGUAGES

Line 13: ( p_language_code in fnd_languages.language_code%TYPE

9: -- ----------------------------------------------------------------------------
10: -- |---------------------------< get_nls_language >---------------------------|
11: -- ----------------------------------------------------------------------------
12: function get_nls_language
13: ( p_language_code in fnd_languages.language_code%TYPE
14: ) return varchar2 IS
15: --
16: cursor c_nls_language IS
17: select l.nls_language

Line 18: from fnd_languages l

14: ) return varchar2 IS
15: --
16: cursor c_nls_language IS
17: select l.nls_language
18: from fnd_languages l
19: where l.language_code = p_language_code;
20: --
21: l_nls_language fnd_languages.nls_language%TYPE;
22: --

Line 21: l_nls_language fnd_languages.nls_language%TYPE;

17: select l.nls_language
18: from fnd_languages l
19: where l.language_code = p_language_code;
20: --
21: l_nls_language fnd_languages.nls_language%TYPE;
22: --
23: nls_language_not_found exception;
24: --
25: begin

Line 71: ( p_language_code in fnd_languages.language_code%TYPE

67: --
68: -- {End Of Comments}
69: --
70: procedure set_session_language_code
71: ( p_language_code in fnd_languages.language_code%TYPE
72: ) IS
73: l_proc varchar2(72) := g_package||' set_session_language_code';
74: begin
75: set_session_nls_language( get_nls_language( p_language_code ) );

Line 108: ( p_nls_language in fnd_languages.nls_language%TYPE

104: --
105: -- {End Of Comments}
106: --
107: procedure set_session_nls_language
108: ( p_nls_language in fnd_languages.nls_language%TYPE
109: ) IS
110: l_proc varchar2(72) := g_package||' set_session_nls_language';
111: begin
112: -- dbms_session will raise an error if nls_language is invalid