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.

[Home] [Help]

APPS.CZ_DEVELOPER_UTILS_PVT dependencies on CZ_PUBLICATION_USAGES

Line 7261: FROM cz_publication_usages

7257:
7258: BEGIN
7259: SELECT 1
7260: INTO l_usage_count
7261: FROM cz_publication_usages
7262: WHERE cz_publication_usages.usage_id = p_usage_id
7263: AND cz_publication_usages.publication_id IN (SELECT publication_id
7264: FROM cz_model_publications
7265: WHERE cz_model_publications.deleted_flag = '0')

Line 7262: WHERE cz_publication_usages.usage_id = p_usage_id

7258: BEGIN
7259: SELECT 1
7260: INTO l_usage_count
7261: FROM cz_publication_usages
7262: WHERE cz_publication_usages.usage_id = p_usage_id
7263: AND cz_publication_usages.publication_id IN (SELECT publication_id
7264: FROM cz_model_publications
7265: WHERE cz_model_publications.deleted_flag = '0')
7266: AND rownum < 2;

Line 7263: AND cz_publication_usages.publication_id IN (SELECT publication_id

7259: SELECT 1
7260: INTO l_usage_count
7261: FROM cz_publication_usages
7262: WHERE cz_publication_usages.usage_id = p_usage_id
7263: AND cz_publication_usages.publication_id IN (SELECT publication_id
7264: FROM cz_model_publications
7265: WHERE cz_model_publications.deleted_flag = '0')
7266: AND rownum < 2;
7267: EXCEPTION

Line 7415: DELETE FROM cz_publication_usages

7411: SET in_use = 'X',
7412: name = append_name(usageId, 'USG', name)
7413: WHERE model_usage_id = usageId;
7414:
7415: DELETE FROM cz_publication_usages
7416: WHERE usage_id = usageId;
7417:
7418: DELETE FROM cz_rp_entries
7419: WHERE object_type ='USG' and object_id = usageId;

Line 8185: FROM cz_publication_usages

8181:
8182: BEGIN
8183: SELECT 1
8184: INTO l_usage_count
8185: FROM cz_publication_usages
8186: WHERE cz_publication_usages.usage_id = l_usg_ref(modelId)
8187: AND cz_publication_usages.publication_id IN (SELECT publication_id
8188: FROM cz_model_publications
8189: WHERE cz_model_publications.deleted_flag = '0')

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

8182: BEGIN
8183: SELECT 1
8184: INTO l_usage_count
8185: FROM cz_publication_usages
8186: WHERE cz_publication_usages.usage_id = l_usg_ref(modelId)
8187: AND cz_publication_usages.publication_id IN (SELECT publication_id
8188: FROM cz_model_publications
8189: WHERE cz_model_publications.deleted_flag = '0')
8190: AND rownum < 2;

Line 8187: AND cz_publication_usages.publication_id IN (SELECT publication_id

8183: SELECT 1
8184: INTO l_usage_count
8185: FROM cz_publication_usages
8186: WHERE cz_publication_usages.usage_id = l_usg_ref(modelId)
8187: AND cz_publication_usages.publication_id IN (SELECT publication_id
8188: FROM cz_model_publications
8189: WHERE cz_model_publications.deleted_flag = '0')
8190: AND rownum < 2;
8191: EXCEPTION