APPS.FND_CP_RT_PKG dependencies on NLS_SESSION_PARAMETERS

Line 88: l_nls_lang nls_session_parameters.value%TYPE;

84: p_num IN varchar2,
85: p_date IN varchar2,
86: p_varchar IN varchar2) is
87:
88: l_nls_lang nls_session_parameters.value%TYPE;
89: l_nls_terr nls_session_parameters.value%TYPE;
90: l_nls_num_char nls_session_parameters.value%TYPE;
91: l_nls_date_fmt nls_session_parameters.value%TYPE;
92: l_nls_date_lang nls_session_parameters.value%TYPE;

Line 89: l_nls_terr nls_session_parameters.value%TYPE;

85: p_date IN varchar2,
86: p_varchar IN varchar2) is
87:
88: l_nls_lang nls_session_parameters.value%TYPE;
89: l_nls_terr nls_session_parameters.value%TYPE;
90: l_nls_num_char nls_session_parameters.value%TYPE;
91: l_nls_date_fmt nls_session_parameters.value%TYPE;
92: l_nls_date_lang nls_session_parameters.value%TYPE;
93: l_db_inst v$instance.instance_name%TYPE;

Line 90: l_nls_num_char nls_session_parameters.value%TYPE;

86: p_varchar IN varchar2) is
87:
88: l_nls_lang nls_session_parameters.value%TYPE;
89: l_nls_terr nls_session_parameters.value%TYPE;
90: l_nls_num_char nls_session_parameters.value%TYPE;
91: l_nls_date_fmt nls_session_parameters.value%TYPE;
92: l_nls_date_lang nls_session_parameters.value%TYPE;
93: l_db_inst v$instance.instance_name%TYPE;
94:

Line 91: l_nls_date_fmt nls_session_parameters.value%TYPE;

87:
88: l_nls_lang nls_session_parameters.value%TYPE;
89: l_nls_terr nls_session_parameters.value%TYPE;
90: l_nls_num_char nls_session_parameters.value%TYPE;
91: l_nls_date_fmt nls_session_parameters.value%TYPE;
92: l_nls_date_lang nls_session_parameters.value%TYPE;
93: l_db_inst v$instance.instance_name%TYPE;
94:
95: begin

Line 92: l_nls_date_lang nls_session_parameters.value%TYPE;

88: l_nls_lang nls_session_parameters.value%TYPE;
89: l_nls_terr nls_session_parameters.value%TYPE;
90: l_nls_num_char nls_session_parameters.value%TYPE;
91: l_nls_date_fmt nls_session_parameters.value%TYPE;
92: l_nls_date_lang nls_session_parameters.value%TYPE;
93: l_db_inst v$instance.instance_name%TYPE;
94:
95: begin
96: -- ----------------------------------------------

Line 153: From Nls_Session_Parameters

149: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Verify NLS session parameter values...');
150: SECTION_TITLE(FND_FILE.OUTPUT, 'Verify NLS session parameter values...');
151:
152: Select Value Into l_nls_lang
153: From Nls_Session_Parameters
154: Where Upper(Parameter) = 'NLS_LANGUAGE';
155: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'NLS_LANGUAGE = ' || l_nls_lang);
156:
157: Select Value Into l_nls_terr

Line 158: From Nls_Session_Parameters

154: Where Upper(Parameter) = 'NLS_LANGUAGE';
155: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'NLS_LANGUAGE = ' || l_nls_lang);
156:
157: Select Value Into l_nls_terr
158: From Nls_Session_Parameters
159: Where Upper(Parameter) = 'NLS_TERRITORY';
160: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'NLS_TERRITORY = ' || l_nls_terr);
161:
162: Select Value Into l_nls_num_char

Line 163: From Nls_Session_Parameters

159: Where Upper(Parameter) = 'NLS_TERRITORY';
160: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'NLS_TERRITORY = ' || l_nls_terr);
161:
162: Select Value Into l_nls_num_char
163: From Nls_Session_Parameters
164: Where Upper(Parameter) = 'NLS_NUMERIC_CHARACTERS';
165: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'NLS_NUMERIC_CHARACTERS = ' || l_nls_num_char);
166:
167: Select Value Into l_nls_date_fmt

Line 168: From Nls_Session_Parameters

164: Where Upper(Parameter) = 'NLS_NUMERIC_CHARACTERS';
165: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'NLS_NUMERIC_CHARACTERS = ' || l_nls_num_char);
166:
167: Select Value Into l_nls_date_fmt
168: From Nls_Session_Parameters
169: Where Upper(Parameter) = 'NLS_DATE_FORMAT';
170: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'NLS_DATE_FORMAT = ' || l_nls_date_fmt);
171:
172: Select Value Into l_nls_date_lang

Line 173: From Nls_Session_Parameters

169: Where Upper(Parameter) = 'NLS_DATE_FORMAT';
170: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'NLS_DATE_FORMAT = ' || l_nls_date_fmt);
171:
172: Select Value Into l_nls_date_lang
173: From Nls_Session_Parameters
174: Where Upper(Parameter) = 'NLS_DATE_LANGUAGE';
175: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'NLS_DATE_LANGUAGE = ' || l_nls_date_lang);
176:
177: --