APPS.BSC_DESIGNER_PVT dependencies on FND_LANGUAGES

Line 689: FROM FND_LANGUAGES

685: l_current_user := 0;
686:
687: SELECT LANGUAGE_CODE INTO
688: l_base_lang
689: FROM FND_LANGUAGES
690: WHERE INSTALLED_FLAG IN ('B');
691: --h_msg := 'Testing Indicator:' || l_indicator || '/Type:' || l_ind_type || '/Config:' || l_ind_config || '/user:' || l_current_user || '/Lan:' || l_base_lang;
692: --DBMS_OUTPUT.PUT_LINE(h_msg);
693:

Line 869: ' FROM FND_LANGUAGES ' ||

865: -- Insert Defaults BSC_KPI_DEFAULTS_TL
866: h_sql :='INSERT INTO BSC_KPI_DEFAULTS_TL (TAB_ID,INDICATOR,LANGUAGE,SOURCE_LANG)' ||
867: ' SELECT '|| h_tab_id ||' TAB_ID,' || l_indicator || ' INDICATOR,' ||
868: ' LANGUAGE_CODE,' || '''' || l_base_lang || '''' ||
869: ' FROM FND_LANGUAGES ' ||
870: ' WHERE INSTALLED_FLAG IN (''B'',''I'')';
871: BSC_UPDATE_UTIL.Execute_Immediate(h_sql);
872: --DBMS_OUTPUT.PUT_LINE(h_sql);
873: EXCEPTION

Line 3160: ' FROM fnd_languages';

3156: END IF;
3157:
3158: -- Get supported languages in source system
3159: l_sql := 'SELECT DISTINCT language_code, installed_flag'||
3160: ' FROM fnd_languages';
3161: IF p_DbLink_Name IS NOT NULL THEN
3162: l_sql := l_sql || '@'||p_DbLink_Name;
3163: END IF;
3164: l_sql := l_sql ||' WHERE installed_flag IN (:1, :2)';

Line 3182: ' FROM fnd_languages'||

3178: CLOSE c_cursor;
3179:
3180: -- Get supported languages in target system
3181: l_sql := 'SELECT DISTINCT language_code'||
3182: ' FROM fnd_languages'||
3183: ' WHERE installed_flag IN (:1, :2)';
3184: OPEN c_cursor FOR l_sql USING 'B', 'I';
3185: l_num_trg_languages := 0;
3186: LOOP