DBA Data[Home] [Help]

APPS.BSC_MIGRATION dependencies on FND_LANGUAGES

Line 346: ' FROM fnd_languages@'||g_db_link||

342:
343: BEGIN
344: -- Get supported languages in source system
345: h_sql := 'SELECT DISTINCT language_code, installed_flag'||
346: ' FROM fnd_languages@'||g_db_link||
347: ' WHERE installed_flag IN (:1, :2)';
348: OPEN h_cursor FOR h_sql USING 'B', 'I';
349: h_num_src_languages := 0;
350: LOOP

Line 365: ' FROM fnd_languages'||

361: CLOSE h_cursor;
362:
363: -- Get supported languages in target system
364: h_sql := 'SELECT DISTINCT language_code'||
365: ' FROM fnd_languages'||
366: ' WHERE installed_flag IN (:1, :2)';
367: OPEN h_cursor FOR h_sql USING 'B', 'I';
368: h_num_trg_languages := 0;
369: LOOP

Line 6475: FROM fnd_languages

6471: -- with the description of the base language of the target system.
6472:
6473: -- Get the base language of the target system
6474: SELECT language_code INTO h_base_language
6475: FROM fnd_languages
6476: WHERE installed_flag = 'B';
6477:
6478: -- Get supported languages in target that are not supported in source
6479: h_sql := 'SELECT DISTINCT language_code'||

Line 6480: ' FROM fnd_languages'||

6476: WHERE installed_flag = 'B';
6477:
6478: -- Get supported languages in target that are not supported in source
6479: h_sql := 'SELECT DISTINCT language_code'||
6480: ' FROM fnd_languages'||
6481: ' WHERE installed_flag IN (:1, :2) AND'||
6482: ' language_code NOT IN ('||
6483: ' SELECT language_code'||
6484: ' FROM fnd_languages@'||g_db_link||

Line 6484: ' FROM fnd_languages@'||g_db_link||

6480: ' FROM fnd_languages'||
6481: ' WHERE installed_flag IN (:1, :2) AND'||
6482: ' language_code NOT IN ('||
6483: ' SELECT language_code'||
6484: ' FROM fnd_languages@'||g_db_link||
6485: ' WHERE installed_flag IN (:3, :4)'||
6486: ' )';
6487: OPEN h_cursor FOR h_sql USING 'B', 'I', 'B', 'I';
6488: LOOP