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);
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:
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:
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);
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;
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
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);
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;
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
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);
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;
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
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);
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;
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