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_PUBLICATION_USAGES

Line 12791: ----------insert the fields of cz_publication_usages

12787: 'and cz_pb_client_apps.APPLICATION_SHORT_NAME=t.APPLICATION_SHORT_NAME';
12788: EXECUTE IMMEDIATE v_insert_string using p_old_publication_id;
12789:
12790: COMMIT;
12791: ----------insert the fields of cz_publication_usages
12792: cz_pb_mgr.v_insert_string :=
12793: 'INSERT INTO cz_publication_usages'
12794: || p_db_link
12795: || ' '

Line 12793: 'INSERT INTO cz_publication_usages'

12789:
12790: COMMIT;
12791: ----------insert the fields of cz_publication_usages
12792: cz_pb_mgr.v_insert_string :=
12793: 'INSERT INTO cz_publication_usages'
12794: || p_db_link
12795: || ' '
12796: || '(PUBLICATION_ID,USAGE_ID)'
12797: || ' '

Line 12802: || 'FROM cz_publication_usages'

12798: || 'SELECT '
12799: || p_new_publication_id
12800: || ',USAGE_ID'
12801: || ' '
12802: || 'FROM cz_publication_usages'
12803: || ' '
12804: || 'WHERE publication_id = :1';
12805:
12806: EXECUTE IMMEDIATE v_insert_string using p_old_publication_id;

Line 19884: DELETE FROM cz_publication_usages

19880:
19881: DELETE FROM cz_pb_client_apps
19882: WHERE publication_id = publicationid;
19883:
19884: DELETE FROM cz_publication_usages
19885: WHERE publication_id = publicationid;
19886:
19887: IF (l_reset_publication > 0)
19888: THEN

Line 19924: || 'DELETE FROM cz_publication_usages'

19920: || 'END;';
19921:
19922: EXECUTE IMMEDIATE 'BEGIN'
19923: || ' '
19924: || 'DELETE FROM cz_publication_usages'
19925: || v_cz_link_name
19926: || ''
19927: || ' '
19928: || 'WHERE publication_id = '

Line 20161: DELETE FROM cz_publication_usages

20157: -------->>>>>>>>>>>>>>>>>>
20158: PROCEDURE delete_src_pb_data(publicationid IN cz_model_publications.publication_id%TYPE)
20159: AS
20160: BEGIN
20161: DELETE FROM cz_publication_usages
20162: WHERE cz_publication_usages.publication_id = publicationid;
20163:
20164: DELETE FROM cz_pb_client_apps
20165: WHERE cz_pb_client_apps.publication_id = publicationid;

Line 20162: WHERE cz_publication_usages.publication_id = publicationid;

20158: PROCEDURE delete_src_pb_data(publicationid IN cz_model_publications.publication_id%TYPE)
20159: AS
20160: BEGIN
20161: DELETE FROM cz_publication_usages
20162: WHERE cz_publication_usages.publication_id = publicationid;
20163:
20164: DELETE FROM cz_pb_client_apps
20165: WHERE cz_pb_client_apps.publication_id = publicationid;
20166:

Line 20211: INSERT INTO cz_publication_usages

20207: END LOOP;
20208:
20209: FOR i IN p_usage_id_tbl.FIRST .. p_usage_id_tbl.LAST
20210: LOOP
20211: INSERT INTO cz_publication_usages
20212: (publication_id, usage_id
20213: )
20214: VALUES (publicationid, p_usage_id_tbl(i)
20215: );

Line 20262: v_edit_str :='DELETE FROM cz_publication_usages'||p_tgt_link||' ' ||

20258:
20259: EXECUTE IMMEDIATE v_edit_str
20260: USING p_publication_mode, p_start_date, p_disable_date;
20261:
20262: v_edit_str :='DELETE FROM cz_publication_usages'||p_tgt_link||' ' ||
20263: 'WHERE cz_publication_usages.publication_id = :1';
20264:
20265: EXECUTE IMMEDIATE v_edit_str using p_remote_publication_id;
20266:

Line 20263: 'WHERE cz_publication_usages.publication_id = :1';

20259: EXECUTE IMMEDIATE v_edit_str
20260: USING p_publication_mode, p_start_date, p_disable_date;
20261:
20262: v_edit_str :='DELETE FROM cz_publication_usages'||p_tgt_link||' ' ||
20263: 'WHERE cz_publication_usages.publication_id = :1';
20264:
20265: EXECUTE IMMEDIATE v_edit_str using p_remote_publication_id;
20266:
20267:

Line 20309: v_edit_str :='INSERT INTO cz_publication_usages'||p_tgt_link||' (publication_id,usage_id)' || ' ' ||

20305:
20306: IF (p_usage_id_tbl.COUNT > 0) THEN
20307: FOR i IN p_usage_id_tbl.FIRST .. p_usage_id_tbl.LAST
20308: LOOP
20309: v_edit_str :='INSERT INTO cz_publication_usages'||p_tgt_link||' (publication_id,usage_id)' || ' ' ||
20310: 'VALUES(:1,:2)';
20311:
20312: EXECUTE IMMEDIATE v_edit_str using p_remote_publication_id,p_usage_id_tbl(i);
20313: END LOOP;

Line 21038: FROM cz_publication_usages

21034: WHERE publication_id = p_publication_id;
21035:
21036: SELECT usage_id
21037: BULK COLLECT INTO x_usageid_tbl
21038: FROM cz_publication_usages
21039: WHERE publication_id = p_publication_id;
21040:
21041: SELECT LANGUAGE
21042: BULK COLLECT INTO x_languageid_tbl

Line 21879: l_usg_id cz_publication_usages.usage_id%TYPE;

21875: )
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;

Line 22089: INSERT INTO cz_publication_usages

22085: IF (p_usg_id_tbl.COUNT > 0)
22086: THEN
22087: FOR i IN p_usg_id_tbl.FIRST .. p_usg_id_tbl.LAST
22088: LOOP
22089: INSERT INTO cz_publication_usages
22090: (publication_id, usage_id
22091: )
22092: VALUES (v_new_publication_id, p_usg_id_tbl(i)
22093: );

Line 22096: INSERT INTO cz_publication_usages

22092: VALUES (v_new_publication_id, p_usg_id_tbl(i)
22093: );
22094: END LOOP;
22095: ELSE
22096: INSERT INTO cz_publication_usages
22097: (publication_id, usage_id
22098: )
22099: VALUES (v_new_publication_id, l_usg_id
22100: );