eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CZ_PB_MGR dependencies on CZ_PB_LANGUAGES

Line 13808: ---------------- insert the fields of cz_pb_languages

13804: EXECUTE IMMEDIATE v_insert_string using p_old_publication_id;
13805:
13806:
13807: COMMIT;
13808: ---------------- insert the fields of cz_pb_languages
13809: cz_pb_mgr.v_insert_string :=
13810: 'INSERT INTO cz_pb_languages'
13811: || p_db_link
13812: || ' '

Line 13810: 'INSERT INTO cz_pb_languages'

13806:
13807: COMMIT;
13808: ---------------- insert the fields of cz_pb_languages
13809: cz_pb_mgr.v_insert_string :=
13810: 'INSERT INTO cz_pb_languages'
13811: || p_db_link
13812: || ' '
13813: || '(PUBLICATION_ID,LANGUAGE)'
13814: || ' '

Line 13819: || 'FROM cz_pb_languages'

13815: || 'SELECT '
13816: || p_new_publication_id
13817: || ',LANGUAGE'
13818: || ' '
13819: || 'FROM cz_pb_languages'
13820: || ' '
13821: || 'WHERE cz_pb_languages.publication_id = :1';
13822:
13823: EXECUTE IMMEDIATE v_insert_string using p_old_publication_id;

Line 13821: || 'WHERE cz_pb_languages.publication_id = :1';

13817: || ',LANGUAGE'
13818: || ' '
13819: || 'FROM cz_pb_languages'
13820: || ' '
13821: || 'WHERE cz_pb_languages.publication_id = :1';
13822:
13823: EXECUTE IMMEDIATE v_insert_string using p_old_publication_id;
13824:
13825: COMMIT;

Line 21376: DELETE FROM cz_pb_languages

21372:
21373: DELETE FROM cz_pb_client_apps
21374: WHERE cz_pb_client_apps.publication_id = publicationid;
21375:
21376: DELETE FROM cz_pb_languages
21377: WHERE cz_pb_languages.publication_id = publicationid;
21378: EXCEPTION
21379: WHEN OTHERS
21380: THEN

Line 21377: WHERE cz_pb_languages.publication_id = publicationid;

21373: DELETE FROM cz_pb_client_apps
21374: WHERE cz_pb_client_apps.publication_id = publicationid;
21375:
21376: DELETE FROM cz_pb_languages
21377: WHERE cz_pb_languages.publication_id = publicationid;
21378: EXCEPTION
21379: WHEN OTHERS
21380: THEN
21381: RAISE;

Line 21411: INSERT INTO cz_pb_languages

21407: END LOOP;
21408:
21409: FOR i IN p_language_id_tbl.FIRST .. p_language_id_tbl.LAST
21410: LOOP
21411: INSERT INTO cz_pb_languages
21412: (publication_id, LANGUAGE
21413: )
21414: VALUES (publicationid, p_language_id_tbl(i)
21415: );

Line 21482: v_edit_str := 'DELETE FROM cz_pb_languages'||p_tgt_link||' ' ||

21478: 'WHERE cz_pb_client_apps.publication_id = :1';
21479:
21480: EXECUTE IMMEDIATE v_edit_str using p_remote_publication_id;
21481:
21482: v_edit_str := 'DELETE FROM cz_pb_languages'||p_tgt_link||' ' ||
21483: 'WHERE cz_pb_languages.publication_id = :1';
21484:
21485: EXECUTE IMMEDIATE v_edit_str using p_remote_publication_id;
21486:

Line 21483: 'WHERE cz_pb_languages.publication_id = :1';

21479:
21480: EXECUTE IMMEDIATE v_edit_str using p_remote_publication_id;
21481:
21482: v_edit_str := 'DELETE FROM cz_pb_languages'||p_tgt_link||' ' ||
21483: 'WHERE cz_pb_languages.publication_id = :1';
21484:
21485: EXECUTE IMMEDIATE v_edit_str using p_remote_publication_id;
21486:
21487: IF (p_application_id_tbl.COUNT > 0) THEN

Line 21508: v_edit_str :='INSERT INTO cz_pb_languages'||p_tgt_link||' (publication_id,language)' || ' ' ||

21504:
21505: IF (p_language_id_tbl.COUNT > 0) THEN
21506: FOR i IN p_language_id_tbl.FIRST .. p_language_id_tbl.LAST
21507: LOOP
21508: v_edit_str :='INSERT INTO cz_pb_languages'||p_tgt_link||' (publication_id,language)' || ' ' ||
21509: 'values(:1,:2)';
21510: EXECUTE IMMEDIATE v_edit_str using p_remote_publication_id,p_language_id_tbl(i);
21511:
21512: END LOOP;

Line 22252: FROM cz_pb_languages

22248: WHERE publication_id = p_publication_id;
22249:
22250: SELECT LANGUAGE
22251: BULK COLLECT INTO x_languageid_tbl
22252: FROM cz_pb_languages
22253: WHERE publication_id = p_publication_id;
22254:
22255: IF ((x_applicationid_tbl.COUNT = 0) OR(x_usageid_tbl.COUNT = 0) OR(x_languageid_tbl.COUNT = 0))
22256: THEN

Line 23089: l_lang_code cz_pb_languages.LANGUAGE%TYPE;

23085: IS
23086: l_model_id cz_rp_entries.object_id%TYPE;
23087: l_publication_mode cz_model_publications.publication_mode%TYPE;
23088: l_usg_id cz_publication_usages.usage_id%TYPE;
23089: l_lang_code cz_pb_languages.LANGUAGE%TYPE;
23090: l_start_date DATE;
23091: l_end_date DATE;
23092: l_last_struct_update DATE;
23093: l_last_logic_update DATE;

Line 23316: INSERT INTO cz_pb_languages

23312: IF (p_lang_tbl.COUNT > 0)
23313: THEN
23314: FOR i IN p_lang_tbl.FIRST .. p_lang_tbl.LAST
23315: LOOP
23316: INSERT INTO cz_pb_languages
23317: (publication_id, LANGUAGE
23318: )
23319: VALUES (v_new_publication_id, p_lang_tbl(i)
23320: );

Line 23323: INSERT INTO cz_pb_languages

23319: VALUES (v_new_publication_id, p_lang_tbl(i)
23320: );
23321: END LOOP;
23322: ELSE
23323: INSERT INTO cz_pb_languages
23324: (publication_id, LANGUAGE
23325: )
23326: VALUES (v_new_publication_id, l_lang_code
23327: );