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_DEVELOPER_UTILS_PVT dependencies on CZ_PUBLICATION_USAGES

Line 7314: FROM cz_publication_usages

7310:
7311: BEGIN
7312: SELECT 1
7313: INTO l_usage_count
7314: FROM cz_publication_usages
7315: WHERE cz_publication_usages.usage_id = p_usage_id
7316: AND cz_publication_usages.publication_id IN (SELECT publication_id
7317: FROM cz_model_publications
7318: WHERE cz_model_publications.deleted_flag = '0')

Line 7315: WHERE cz_publication_usages.usage_id = p_usage_id

7311: BEGIN
7312: SELECT 1
7313: INTO l_usage_count
7314: FROM cz_publication_usages
7315: WHERE cz_publication_usages.usage_id = p_usage_id
7316: AND cz_publication_usages.publication_id IN (SELECT publication_id
7317: FROM cz_model_publications
7318: WHERE cz_model_publications.deleted_flag = '0')
7319: AND rownum < 2;

Line 7316: AND cz_publication_usages.publication_id IN (SELECT publication_id

7312: SELECT 1
7313: INTO l_usage_count
7314: FROM cz_publication_usages
7315: WHERE cz_publication_usages.usage_id = p_usage_id
7316: AND cz_publication_usages.publication_id IN (SELECT publication_id
7317: FROM cz_model_publications
7318: WHERE cz_model_publications.deleted_flag = '0')
7319: AND rownum < 2;
7320: EXCEPTION

Line 7468: DELETE FROM cz_publication_usages

7464: SET in_use = 'X',
7465: name = append_name(usageId, 'USG', name)
7466: WHERE model_usage_id = usageId;
7467:
7468: DELETE FROM cz_publication_usages
7469: WHERE usage_id = usageId;
7470:
7471: DELETE FROM cz_rp_entries
7472: WHERE object_type ='USG' and object_id = usageId;

Line 8294: FROM cz_publication_usages

8290:
8291: BEGIN
8292: SELECT 1
8293: INTO l_usage_count
8294: FROM cz_publication_usages
8295: WHERE cz_publication_usages.usage_id = l_usg_ref(modelId)
8296: AND cz_publication_usages.publication_id IN (SELECT publication_id
8297: FROM cz_model_publications
8298: WHERE cz_model_publications.deleted_flag = '0')

Line 8295: WHERE cz_publication_usages.usage_id = l_usg_ref(modelId)

8291: BEGIN
8292: SELECT 1
8293: INTO l_usage_count
8294: FROM cz_publication_usages
8295: WHERE cz_publication_usages.usage_id = l_usg_ref(modelId)
8296: AND cz_publication_usages.publication_id IN (SELECT publication_id
8297: FROM cz_model_publications
8298: WHERE cz_model_publications.deleted_flag = '0')
8299: AND rownum < 2;

Line 8296: AND cz_publication_usages.publication_id IN (SELECT publication_id

8292: SELECT 1
8293: INTO l_usage_count
8294: FROM cz_publication_usages
8295: WHERE cz_publication_usages.usage_id = l_usg_ref(modelId)
8296: AND cz_publication_usages.publication_id IN (SELECT publication_id
8297: FROM cz_model_publications
8298: WHERE cz_model_publications.deleted_flag = '0')
8299: AND rownum < 2;
8300: EXCEPTION