DBA Data[Home] [Help]

APPS.OTA_MLS_MIGRATION dependencies on FND_LANGUAGES

Line 17: from fnd_languages

13:
14: cursor csr_installed_languages is
15: select language_code,
16: nls_Language
17: from fnd_languages
18: where installed_flag in ('I', 'B');
19:
20: l_userenv_language_code FND_LANGUAGES.LANGUAGE_CODE%TYPE := userenv('LANG');
21: l_current_nls_language VARCHAR2(30);

Line 20: l_userenv_language_code FND_LANGUAGES.LANGUAGE_CODE%TYPE := userenv('LANG');

16: nls_Language
17: from fnd_languages
18: where installed_flag in ('I', 'B');
19:
20: l_userenv_language_code FND_LANGUAGES.LANGUAGE_CODE%TYPE := userenv('LANG');
21: l_current_nls_language VARCHAR2(30);
22: l_current_language FND_LANGUAGES.LANGUAGE_CODE%TYPE ;
23: l_rows_processed number := 0;
24:

Line 22: l_current_language FND_LANGUAGES.LANGUAGE_CODE%TYPE ;

18: where installed_flag in ('I', 'B');
19:
20: l_userenv_language_code FND_LANGUAGES.LANGUAGE_CODE%TYPE := userenv('LANG');
21: l_current_nls_language VARCHAR2(30);
22: l_current_language FND_LANGUAGES.LANGUAGE_CODE%TYPE ;
23: l_rows_processed number := 0;
24:
25: begin
26:

Line 115: from fnd_languages

111:
112: cursor csr_installed_languages is
113: select language_code,
114: nls_Language
115: from fnd_languages
116: where installed_flag in ('I', 'B');
117:
118: l_userenv_language_code FND_LANGUAGES.LANGUAGE_CODE%TYPE := userenv('LANG');
119: l_current_nls_language VARCHAR2(30);

Line 118: l_userenv_language_code FND_LANGUAGES.LANGUAGE_CODE%TYPE := userenv('LANG');

114: nls_Language
115: from fnd_languages
116: where installed_flag in ('I', 'B');
117:
118: l_userenv_language_code FND_LANGUAGES.LANGUAGE_CODE%TYPE := userenv('LANG');
119: l_current_nls_language VARCHAR2(30);
120: l_current_language FND_LANGUAGES.LANGUAGE_CODE%TYPE;
121: l_rows_processed number := 0;
122: l_end_of_time date := hr_general.end_of_time;

Line 120: l_current_language FND_LANGUAGES.LANGUAGE_CODE%TYPE;

116: where installed_flag in ('I', 'B');
117:
118: l_userenv_language_code FND_LANGUAGES.LANGUAGE_CODE%TYPE := userenv('LANG');
119: l_current_nls_language VARCHAR2(30);
120: l_current_language FND_LANGUAGES.LANGUAGE_CODE%TYPE;
121: l_rows_processed number := 0;
122: l_end_of_time date := hr_general.end_of_time;
123:
124: begin

Line 216: from fnd_languages

212:
213: cursor csr_installed_languages is
214: select language_code,
215: nls_Language
216: from fnd_languages
217: where installed_flag in ('I', 'B');
218:
219: l_userenv_language_code FND_LANGUAGES.LANGUAGE_CODE%TYPE := userenv('LANG');
220: l_current_nls_language VARCHAR2(30);

Line 219: l_userenv_language_code FND_LANGUAGES.LANGUAGE_CODE%TYPE := userenv('LANG');

215: nls_Language
216: from fnd_languages
217: where installed_flag in ('I', 'B');
218:
219: l_userenv_language_code FND_LANGUAGES.LANGUAGE_CODE%TYPE := userenv('LANG');
220: l_current_nls_language VARCHAR2(30);
221: l_current_language FND_LANGUAGES.LANGUAGE_CODE%TYPE;
222: l_rows_processed number := 0;
223: l_end_of_time date := hr_general.end_of_time;

Line 221: l_current_language FND_LANGUAGES.LANGUAGE_CODE%TYPE;

217: where installed_flag in ('I', 'B');
218:
219: l_userenv_language_code FND_LANGUAGES.LANGUAGE_CODE%TYPE := userenv('LANG');
220: l_current_nls_language VARCHAR2(30);
221: l_current_language FND_LANGUAGES.LANGUAGE_CODE%TYPE;
222: l_rows_processed number := 0;
223: l_end_of_time date := hr_general.end_of_time;
224:
225: begin

Line 313: from fnd_languages

309:
310: cursor csr_installed_languages is
311: select language_code,
312: nls_Language
313: from fnd_languages
314: where installed_flag in ('I', 'B');
315:
316: l_userenv_language_code FND_LANGUAGES.LANGUAGE_CODE%TYPE := userenv('LANG');
317: l_current_nls_language VARCHAR2(30);

Line 316: l_userenv_language_code FND_LANGUAGES.LANGUAGE_CODE%TYPE := userenv('LANG');

312: nls_Language
313: from fnd_languages
314: where installed_flag in ('I', 'B');
315:
316: l_userenv_language_code FND_LANGUAGES.LANGUAGE_CODE%TYPE := userenv('LANG');
317: l_current_nls_language VARCHAR2(30);
318: l_current_language FND_LANGUAGES.LANGUAGE_CODE%TYPE;
319: l_rows_processed number := 0;
320: l_end_of_time date := hr_general.end_of_time;

Line 318: l_current_language FND_LANGUAGES.LANGUAGE_CODE%TYPE;

314: where installed_flag in ('I', 'B');
315:
316: l_userenv_language_code FND_LANGUAGES.LANGUAGE_CODE%TYPE := userenv('LANG');
317: l_current_nls_language VARCHAR2(30);
318: l_current_language FND_LANGUAGES.LANGUAGE_CODE%TYPE;
319: l_rows_processed number := 0;
320: l_end_of_time date := hr_general.end_of_time;
321:
322: begin

Line 411: from fnd_languages

407:
408: cursor csr_installed_languages is
409: select language_code,
410: nls_Language
411: from fnd_languages
412: where installed_flag in ('I', 'B');
413:
414: l_userenv_language_code FND_LANGUAGES.LANGUAGE_CODE%TYPE := userenv('LANG');
415: l_current_nls_language VARCHAR2(30);

Line 414: l_userenv_language_code FND_LANGUAGES.LANGUAGE_CODE%TYPE := userenv('LANG');

410: nls_Language
411: from fnd_languages
412: where installed_flag in ('I', 'B');
413:
414: l_userenv_language_code FND_LANGUAGES.LANGUAGE_CODE%TYPE := userenv('LANG');
415: l_current_nls_language VARCHAR2(30);
416: l_current_language FND_LANGUAGES.LANGUAGE_CODE%TYPE;
417: l_rows_processed number := 0;
418: l_end_of_time date := hr_general.end_of_time;

Line 416: l_current_language FND_LANGUAGES.LANGUAGE_CODE%TYPE;

412: where installed_flag in ('I', 'B');
413:
414: l_userenv_language_code FND_LANGUAGES.LANGUAGE_CODE%TYPE := userenv('LANG');
415: l_current_nls_language VARCHAR2(30);
416: l_current_language FND_LANGUAGES.LANGUAGE_CODE%TYPE;
417: l_rows_processed number := 0;
418: l_end_of_time date := hr_general.end_of_time;
419:
420: begin