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 13789: ----------insert the fields of cz_publication_usages

13785: 'and cz_pb_client_apps.APPLICATION_SHORT_NAME=t.APPLICATION_SHORT_NAME';
13786: EXECUTE IMMEDIATE v_insert_string using p_old_publication_id;
13787:
13788: COMMIT;
13789: ----------insert the fields of cz_publication_usages
13790: cz_pb_mgr.v_insert_string :=
13791: 'INSERT INTO cz_publication_usages'
13792: || p_db_link
13793: || ' '

Line 13791: 'INSERT INTO cz_publication_usages'

13787:
13788: COMMIT;
13789: ----------insert the fields of cz_publication_usages
13790: cz_pb_mgr.v_insert_string :=
13791: 'INSERT INTO cz_publication_usages'
13792: || p_db_link
13793: || ' '
13794: || '(PUBLICATION_ID,USAGE_ID)'
13795: || ' '

Line 13800: || 'FROM cz_publication_usages'

13796: || 'SELECT '
13797: || p_new_publication_id
13798: || ',USAGE_ID'
13799: || ' '
13800: || 'FROM cz_publication_usages'
13801: || ' '
13802: || 'WHERE publication_id = :1';
13803:
13804: EXECUTE IMMEDIATE v_insert_string using p_old_publication_id;

Line 21093: DELETE FROM cz_publication_usages

21089:
21090: DELETE FROM cz_pb_client_apps
21091: WHERE publication_id = publicationid;
21092:
21093: DELETE FROM cz_publication_usages
21094: WHERE publication_id = publicationid;
21095:
21096: IF (l_reset_publication > 0)
21097: THEN

Line 21133: || 'DELETE FROM cz_publication_usages'

21129: || 'END;';
21130:
21131: EXECUTE IMMEDIATE 'BEGIN'
21132: || ' '
21133: || 'DELETE FROM cz_publication_usages'
21134: || v_cz_link_name
21135: || ''
21136: || ' '
21137: || 'WHERE publication_id = '

Line 21370: DELETE FROM cz_publication_usages

21366: -------->>>>>>>>>>>>>>>>>>
21367: PROCEDURE delete_src_pb_data(publicationid IN cz_model_publications.publication_id%TYPE)
21368: AS
21369: BEGIN
21370: DELETE FROM cz_publication_usages
21371: WHERE cz_publication_usages.publication_id = publicationid;
21372:
21373: DELETE FROM cz_pb_client_apps
21374: WHERE cz_pb_client_apps.publication_id = publicationid;

Line 21371: WHERE cz_publication_usages.publication_id = publicationid;

21367: PROCEDURE delete_src_pb_data(publicationid IN cz_model_publications.publication_id%TYPE)
21368: AS
21369: BEGIN
21370: DELETE FROM cz_publication_usages
21371: WHERE cz_publication_usages.publication_id = publicationid;
21372:
21373: DELETE FROM cz_pb_client_apps
21374: WHERE cz_pb_client_apps.publication_id = publicationid;
21375:

Line 21420: INSERT INTO cz_publication_usages

21416: END LOOP;
21417:
21418: FOR i IN p_usage_id_tbl.FIRST .. p_usage_id_tbl.LAST
21419: LOOP
21420: INSERT INTO cz_publication_usages
21421: (publication_id, usage_id
21422: )
21423: VALUES (publicationid, p_usage_id_tbl(i)
21424: );

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

21467:
21468: EXECUTE IMMEDIATE v_edit_str
21469: USING p_publication_mode, p_start_date, p_disable_date;
21470:
21471: v_edit_str :='DELETE FROM cz_publication_usages'||p_tgt_link||' ' ||
21472: 'WHERE cz_publication_usages.publication_id = :1';
21473:
21474: EXECUTE IMMEDIATE v_edit_str using p_remote_publication_id;
21475:

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

21468: EXECUTE IMMEDIATE v_edit_str
21469: USING p_publication_mode, p_start_date, p_disable_date;
21470:
21471: v_edit_str :='DELETE FROM cz_publication_usages'||p_tgt_link||' ' ||
21472: 'WHERE cz_publication_usages.publication_id = :1';
21473:
21474: EXECUTE IMMEDIATE v_edit_str using p_remote_publication_id;
21475:
21476:

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

21514:
21515: IF (p_usage_id_tbl.COUNT > 0) THEN
21516: FOR i IN p_usage_id_tbl.FIRST .. p_usage_id_tbl.LAST
21517: LOOP
21518: v_edit_str :='INSERT INTO cz_publication_usages'||p_tgt_link||' (publication_id,usage_id)' || ' ' ||
21519: 'VALUES(:1,:2)';
21520:
21521: EXECUTE IMMEDIATE v_edit_str using p_remote_publication_id,p_usage_id_tbl(i);
21522: END LOOP;

Line 22247: FROM cz_publication_usages

22243: WHERE publication_id = p_publication_id;
22244:
22245: SELECT usage_id
22246: BULK COLLECT INTO x_usageid_tbl
22247: FROM cz_publication_usages
22248: WHERE publication_id = p_publication_id;
22249:
22250: SELECT LANGUAGE
22251: BULK COLLECT INTO x_languageid_tbl

Line 23088: l_usg_id cz_publication_usages.usage_id%TYPE;

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

Line 23298: INSERT INTO cz_publication_usages

23294: IF (p_usg_id_tbl.COUNT > 0)
23295: THEN
23296: FOR i IN p_usg_id_tbl.FIRST .. p_usg_id_tbl.LAST
23297: LOOP
23298: INSERT INTO cz_publication_usages
23299: (publication_id, usage_id
23300: )
23301: VALUES (v_new_publication_id, p_usg_id_tbl(i)
23302: );

Line 23305: INSERT INTO cz_publication_usages

23301: VALUES (v_new_publication_id, p_usg_id_tbl(i)
23302: );
23303: END LOOP;
23304: ELSE
23305: INSERT INTO cz_publication_usages
23306: (publication_id, usage_id
23307: )
23308: VALUES (v_new_publication_id, l_usg_id
23309: );