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 12810: ---------------- insert the fields of cz_pb_languages

12806: EXECUTE IMMEDIATE v_insert_string using p_old_publication_id;
12807:
12808:
12809: COMMIT;
12810: ---------------- insert the fields of cz_pb_languages
12811: cz_pb_mgr.v_insert_string :=
12812: 'INSERT INTO cz_pb_languages'
12813: || p_db_link
12814: || ' '

Line 12812: 'INSERT INTO cz_pb_languages'

12808:
12809: COMMIT;
12810: ---------------- insert the fields of cz_pb_languages
12811: cz_pb_mgr.v_insert_string :=
12812: 'INSERT INTO cz_pb_languages'
12813: || p_db_link
12814: || ' '
12815: || '(PUBLICATION_ID,LANGUAGE)'
12816: || ' '

Line 12821: || 'FROM cz_pb_languages'

12817: || 'SELECT '
12818: || p_new_publication_id
12819: || ',LANGUAGE'
12820: || ' '
12821: || 'FROM cz_pb_languages'
12822: || ' '
12823: || 'WHERE cz_pb_languages.publication_id = :1';
12824:
12825: EXECUTE IMMEDIATE v_insert_string using p_old_publication_id;

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

12819: || ',LANGUAGE'
12820: || ' '
12821: || 'FROM cz_pb_languages'
12822: || ' '
12823: || 'WHERE cz_pb_languages.publication_id = :1';
12824:
12825: EXECUTE IMMEDIATE v_insert_string using p_old_publication_id;
12826:
12827: COMMIT;

Line 20167: DELETE FROM cz_pb_languages

20163:
20164: DELETE FROM cz_pb_client_apps
20165: WHERE cz_pb_client_apps.publication_id = publicationid;
20166:
20167: DELETE FROM cz_pb_languages
20168: WHERE cz_pb_languages.publication_id = publicationid;
20169: EXCEPTION
20170: WHEN OTHERS
20171: THEN

Line 20168: WHERE cz_pb_languages.publication_id = publicationid;

20164: DELETE FROM cz_pb_client_apps
20165: WHERE cz_pb_client_apps.publication_id = publicationid;
20166:
20167: DELETE FROM cz_pb_languages
20168: WHERE cz_pb_languages.publication_id = publicationid;
20169: EXCEPTION
20170: WHEN OTHERS
20171: THEN
20172: RAISE;

Line 20202: INSERT INTO cz_pb_languages

20198: END LOOP;
20199:
20200: FOR i IN p_language_id_tbl.FIRST .. p_language_id_tbl.LAST
20201: LOOP
20202: INSERT INTO cz_pb_languages
20203: (publication_id, LANGUAGE
20204: )
20205: VALUES (publicationid, p_language_id_tbl(i)
20206: );

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

20269: 'WHERE cz_pb_client_apps.publication_id = :1';
20270:
20271: EXECUTE IMMEDIATE v_edit_str using p_remote_publication_id;
20272:
20273: v_edit_str := 'DELETE FROM cz_pb_languages'||p_tgt_link||' ' ||
20274: 'WHERE cz_pb_languages.publication_id = :1';
20275:
20276: EXECUTE IMMEDIATE v_edit_str using p_remote_publication_id;
20277:

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

20270:
20271: EXECUTE IMMEDIATE v_edit_str using p_remote_publication_id;
20272:
20273: v_edit_str := 'DELETE FROM cz_pb_languages'||p_tgt_link||' ' ||
20274: 'WHERE cz_pb_languages.publication_id = :1';
20275:
20276: EXECUTE IMMEDIATE v_edit_str using p_remote_publication_id;
20277:
20278: IF (p_application_id_tbl.COUNT > 0) THEN

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

20295:
20296: IF (p_language_id_tbl.COUNT > 0) THEN
20297: FOR i IN p_language_id_tbl.FIRST .. p_language_id_tbl.LAST
20298: LOOP
20299: v_edit_str :='INSERT INTO cz_pb_languages'||p_tgt_link||' (publication_id,language)' || ' ' ||
20300: 'values(:1,:2)';
20301: EXECUTE IMMEDIATE v_edit_str using p_remote_publication_id,p_language_id_tbl(i);
20302:
20303: END LOOP;

Line 21043: FROM cz_pb_languages

21039: WHERE publication_id = p_publication_id;
21040:
21041: SELECT LANGUAGE
21042: BULK COLLECT INTO x_languageid_tbl
21043: FROM cz_pb_languages
21044: WHERE publication_id = p_publication_id;
21045:
21046: IF ((x_applicationid_tbl.COUNT = 0) OR(x_usageid_tbl.COUNT = 0) OR(x_languageid_tbl.COUNT = 0))
21047: THEN

Line 21880: l_lang_code cz_pb_languages.LANGUAGE%TYPE;

21876: IS
21877: l_model_id cz_rp_entries.object_id%TYPE;
21878: l_publication_mode cz_model_publications.publication_mode%TYPE;
21879: l_usg_id cz_publication_usages.usage_id%TYPE;
21880: l_lang_code cz_pb_languages.LANGUAGE%TYPE;
21881: l_start_date DATE;
21882: l_end_date DATE;
21883: l_last_struct_update DATE;
21884: l_last_logic_update DATE;

Line 22107: INSERT INTO cz_pb_languages

22103: IF (p_lang_tbl.COUNT > 0)
22104: THEN
22105: FOR i IN p_lang_tbl.FIRST .. p_lang_tbl.LAST
22106: LOOP
22107: INSERT INTO cz_pb_languages
22108: (publication_id, LANGUAGE
22109: )
22110: VALUES (v_new_publication_id, p_lang_tbl(i)
22111: );

Line 22114: INSERT INTO cz_pb_languages

22110: VALUES (v_new_publication_id, p_lang_tbl(i)
22111: );
22112: END LOOP;
22113: ELSE
22114: INSERT INTO cz_pb_languages
22115: (publication_id, LANGUAGE
22116: )
22117: VALUES (v_new_publication_id, l_lang_code
22118: );