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_MODEL_PUBLICATIONS

Line 3962: FOR k IN(SELECT publication_id FROM CZ_MODEL_PUBLICATIONS

3958: -- check - if this UI published or no
3959: --------------------------------------
3960: l_ui_is_published := FALSE;
3961: x_msg_count := 0;
3962: FOR k IN(SELECT publication_id FROM CZ_MODEL_PUBLICATIONS
3963: WHERE ui_def_id=p_ui_def_id AND deleted_flag='0')
3964: LOOP
3965: l_ui_is_published := TRUE;
3966: add_Error_Message(p_message_name => 'CZ_DEL_UI_IS_PUBLISHED',

Line 4677: FROM cz_model_publications

4673: -- finally, check for published models
4674: ---------------------------------------
4675: BEGIN
4676: SELECT publication_id BULK COLLECT INTO l_publication_tbl
4677: FROM cz_model_publications
4678: WHERE object_id = p_model_id
4679: AND object_type = 'PRJ'
4680: AND deleted_flag = '0';
4681:

Line 7264: FROM cz_model_publications

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
7268: WHEN NO_DATA_FOUND THEN

Line 7265: WHERE cz_model_publications.deleted_flag = '0')

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
7268: WHEN NO_DATA_FOUND THEN
7269: NULL;

Line 7847: FROM cz_model_publications

7843: SELECT publication_id
7844: BULK
7845: COLLECT
7846: INTO l_publication_tbl
7847: FROM cz_model_publications
7848: WHERE object_id = l_ref_model_ids_tbl(i)
7849: AND object_type = 'PRJ'
7850: AND deleted_flag = '0';
7851:

Line 8188: FROM cz_model_publications

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
8192: WHEN NO_DATA_FOUND THEN

Line 8189: WHERE cz_model_publications.deleted_flag = '0')

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
8192: WHEN NO_DATA_FOUND THEN
8193: l_usage_count := 0;