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 3990: FOR k IN(SELECT publication_id FROM CZ_MODEL_PUBLICATIONS

3986: -- check - if this UI published or no
3987: --------------------------------------
3988: l_ui_is_published := FALSE;
3989: x_msg_count := 0;
3990: FOR k IN(SELECT publication_id FROM CZ_MODEL_PUBLICATIONS
3991: WHERE ui_def_id=p_ui_def_id AND deleted_flag='0')
3992: LOOP
3993: l_ui_is_published := TRUE;
3994: add_Error_Message(p_message_name => 'CZ_DEL_UI_IS_PUBLISHED',

Line 4705: FROM cz_model_publications

4701: -- finally, check for published models
4702: ---------------------------------------
4703: BEGIN
4704: SELECT publication_id BULK COLLECT INTO l_publication_tbl
4705: FROM cz_model_publications
4706: WHERE object_id = p_model_id
4707: AND object_type = 'PRJ'
4708: AND deleted_flag = '0';
4709:

Line 7317: FROM cz_model_publications

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

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

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
7321: WHEN NO_DATA_FOUND THEN
7322: NULL;

Line 7905: FROM cz_model_publications

7901: SELECT publication_id
7902: BULK
7903: COLLECT
7904: INTO l_publication_tbl
7905: FROM cz_model_publications
7906: WHERE object_id = l_ref_model_ids_tbl(i)
7907: AND object_type = 'PRJ'
7908: AND deleted_flag = '0';
7909:

Line 8297: FROM cz_model_publications

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

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

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