APPS.CZ_PB_MGR dependencies on FND_LANGUAGES

Line 817: || ' SELECT language_code into base_lang FROM fnd_languages WHERE installed_flag = ''B'';'

813: || 'base_lang VARCHAR2(10);'
814: || ' '
815: || 'BEGIN'
816: || ' '
817: || ' SELECT language_code into base_lang FROM fnd_languages WHERE installed_flag = ''B'';'
818: || ' '
819: || 'FOR I IN cz_pb_mgr.v_cz_intl_text_new_ref.FIRST..cz_pb_mgr.v_cz_intl_text_new_ref.LAST'
820: || ' '
821: || 'LOOP'

Line 1419: select count(1) into lang_count from fnd_languages where installed_flag in('I','B');

1415: l_sql_str varchar2(4000);
1416: lang_count number;
1417: BEGIN
1418:
1419: select count(1) into lang_count from fnd_languages where installed_flag in('I','B');
1420:
1421: IF ((cz_pb_mgr.v_status_code <> PUBLICATION_ERROR) AND(cz_pb_mgr.mm_v_tbl_prop_vals_trans_new.COUNT > 0))
1422: THEN
1423:

Line 11288: FROM fnd_languages

11284:
11285: BEGIN
11286: SELECT UPPER(language_code)
11287: BULK COLLECT INTO cz_pb_mgr.v_src_lang_code_tbl
11288: FROM fnd_languages
11289: WHERE fnd_languages.installed_flag IN('B', 'I')
11290: ORDER BY UPPER(language_code);
11291: EXCEPTION
11292: WHEN OTHERS

Line 11289: WHERE fnd_languages.installed_flag IN('B', 'I')

11285: BEGIN
11286: SELECT UPPER(language_code)
11287: BULK COLLECT INTO cz_pb_mgr.v_src_lang_code_tbl
11288: FROM fnd_languages
11289: WHERE fnd_languages.installed_flag IN('B', 'I')
11290: ORDER BY UPPER(language_code);
11291: EXCEPTION
11292: WHEN OTHERS
11293: THEN

Line 11305: || 'FROM fnd_languages'

11301:
11302: BEGIN
11303: OPEN lang_cv FOR 'SELECT UPPER(language_code)'
11304: || ' '
11305: || 'FROM fnd_languages'
11306: || cz_pb_mgr.v_db_link
11307: || ' '
11308: || 'WHERE fnd_languages.installed_flag IN (''B'', ''I'')'
11309: || ' '

Line 11308: || 'WHERE fnd_languages.installed_flag IN (''B'', ''I'')'

11304: || ' '
11305: || 'FROM fnd_languages'
11306: || cz_pb_mgr.v_db_link
11307: || ' '
11308: || 'WHERE fnd_languages.installed_flag IN (''B'', ''I'')'
11309: || ' '
11310: || 'ORDER BY UPPER(language_code)';
11311:
11312: lang_index := 1;