1 Package ota_mls_utility AUTHID CURRENT_USER as
2 /* $Header: otmlsutl.pkh 115.0 2003/04/11 14:25:06 jbharath noship $ */
3 --
4 -- Package Variables
5 --
6 -- ----------------------------------------------------------------------------
7 -- |---------------------------< set_session_language_code >------------------|
8 -- ----------------------------------------------------------------------------
9 --
10 -- {Start Of Comments}
11 --
12 -- Description:
13 -- Set the session language from the language code and clears the
14 -- key flex cache
15 --
16 -- Prerequisites:
17 --
18 -- In Parameters:
19 -- Name Reqd Type Description
20 -- ==== ==== ==== ===========
21 -- p_language_code Yes varchar2 the Two digit language code
22 --
23 -- Post Success:
24 -- userenv('LANG') is set to language code
25 --
26 -- Post Failure:
27 -- user session language is not changed
28 --
29 --
30 -- Access Status:
31 -- Public - For Internal Development Use Only
32 --
33 -- {End Of Comments}
34 --
35 procedure set_session_language_code
36 ( p_language_code in fnd_languages.language_code%TYPE
37 );
38 --
39 -- ----------------------------------------------------------------------------
40 -- |---------------------------< set_session_nls_language >-------------------|
41 -- ----------------------------------------------------------------------------
42 --
43 -- {Start Of Comments}
44 --
45 -- Description:
46 -- Set the session language from the nls language and clears the
47 -- key flex cache
48 --
49 -- Prerequisites:
50 --
51 -- In Parameters:
52 -- Name Reqd Type Description
53 -- ==== ==== ==== ===========
54 -- p_nls_language Yes varchar2 The nls language (NOT the 2 letter language code)
55 --
56 -- Post Success:
57 -- userev('LANG') is set to language code derived from nls language
58 --
59 -- Post Failure:
60 -- user session language is not changed
61 --
62 --
63 -- Access Status:
64 -- Public - For Internal Development Use Only
65 --
66 -- {End Of Comments}
67 --
68 procedure set_session_nls_language
69 ( p_nls_language in fnd_languages.nls_language%TYPE
70 );
71 end ota_mls_utility;