APPS.CZ_PB_MGR dependencies on FND_LANGUAGES

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

1155: l_sql_str varchar2(4000);
1156: lang_count number;
1157: BEGIN
1158:
1159: select count(1) into lang_count from fnd_languages where installed_flag in('I','B');
1160:
1161: IF ((cz_pb_mgr.v_status_code <> PUBLICATION_ERROR) AND(cz_pb_mgr.mm_v_tbl_prop_vals_trans_new.COUNT > 0))
1162: THEN
1163:

Line 10532: FROM fnd_languages

10528:
10529: BEGIN
10530: SELECT UPPER(language_code)
10531: BULK COLLECT INTO cz_pb_mgr.v_src_lang_code_tbl
10532: FROM fnd_languages
10533: WHERE fnd_languages.installed_flag IN('B', 'I')
10534: ORDER BY UPPER(language_code);
10535: EXCEPTION
10536: WHEN OTHERS

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

10529: BEGIN
10530: SELECT UPPER(language_code)
10531: BULK COLLECT INTO cz_pb_mgr.v_src_lang_code_tbl
10532: FROM fnd_languages
10533: WHERE fnd_languages.installed_flag IN('B', 'I')
10534: ORDER BY UPPER(language_code);
10535: EXCEPTION
10536: WHEN OTHERS
10537: THEN

Line 10549: || 'FROM fnd_languages'

10545:
10546: BEGIN
10547: OPEN lang_cv FOR 'SELECT UPPER(language_code)'
10548: || ' '
10549: || 'FROM fnd_languages'
10550: || cz_pb_mgr.v_db_link
10551: || ' '
10552: || 'WHERE fnd_languages.installed_flag IN (''B'', ''I'')'
10553: || ' '

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

10548: || ' '
10549: || 'FROM fnd_languages'
10550: || cz_pb_mgr.v_db_link
10551: || ' '
10552: || 'WHERE fnd_languages.installed_flag IN (''B'', ''I'')'
10553: || ' '
10554: || 'ORDER BY UPPER(language_code)';
10555:
10556: lang_index := 1;