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_SECURITY_PVT dependencies on CZ_MODEL_REF_EXPLS

Line 749: FROM cz_model_ref_expls

745: SELECT distinct component_id
746: BULK
747: COLLECT
748: INTO x_locked_entities
749: FROM cz_model_ref_expls
750: WHERE cz_model_ref_expls.model_id = p_entity_id
751: AND cz_model_ref_expls.deleted_flag = '0'
752: AND cz_model_ref_expls.ps_node_type = 263;
753: EXCEPTION

Line 750: WHERE cz_model_ref_expls.model_id = p_entity_id

746: BULK
747: COLLECT
748: INTO x_locked_entities
749: FROM cz_model_ref_expls
750: WHERE cz_model_ref_expls.model_id = p_entity_id
751: AND cz_model_ref_expls.deleted_flag = '0'
752: AND cz_model_ref_expls.ps_node_type = 263;
753: EXCEPTION
754: WHEN NO_DATA_FOUND THEN

Line 751: AND cz_model_ref_expls.deleted_flag = '0'

747: COLLECT
748: INTO x_locked_entities
749: FROM cz_model_ref_expls
750: WHERE cz_model_ref_expls.model_id = p_entity_id
751: AND cz_model_ref_expls.deleted_flag = '0'
752: AND cz_model_ref_expls.ps_node_type = 263;
753: EXCEPTION
754: WHEN NO_DATA_FOUND THEN
755: NULL;

Line 752: AND cz_model_ref_expls.ps_node_type = 263;

748: INTO x_locked_entities
749: FROM cz_model_ref_expls
750: WHERE cz_model_ref_expls.model_id = p_entity_id
751: AND cz_model_ref_expls.deleted_flag = '0'
752: AND cz_model_ref_expls.ps_node_type = 263;
753: EXCEPTION
754: WHEN NO_DATA_FOUND THEN
755: NULL;
756: END;

Line 857: FROM cz_model_ref_expls

853: SELECT component_id
854: BULK
855: COLLECT
856: INTO l_locked_entities
857: FROM cz_model_ref_expls
858: WHERE model_id = p_entity_id
859: AND deleted_flag = '0'
860: AND component_id IN (SELECT devl_project_id
861: FROM cz_devl_projects

Line 1427: FROM cz_model_ref_expls

1423: SELECT component_id
1424: BULK
1425: COLLECT
1426: INTO l_models
1427: FROM cz_model_ref_expls
1428: WHERE model_id = p_model_id
1429: AND ps_node_type = 263
1430: AND deleted_flag = '0';
1431:

Line 1481: FROM cz_model_ref_expls

1477: COLLECT
1478: INTO l_checkout_user_tbl
1479: FROM cz_devl_projects
1480: WHERE cz_devl_projects.devl_project_id IN ( SELECT component_id
1481: FROM cz_model_ref_expls
1482: WHERE model_id = p_model_id
1483: AND ps_node_type = 263
1484: AND deleted_flag = '0')
1485:

Line 3030: FROM cz_model_ref_expls

3026: COLLECT
3027: INTO x_model_name_tbl, x_checkout_user_tbl
3028: FROM cz_devl_projects
3029: WHERE cz_devl_projects.devl_project_id IN (SELECT component_id
3030: FROM cz_model_ref_expls
3031: WHERE cz_model_ref_expls.deleted_flag = '0'
3032: AND cz_model_ref_expls.model_id = p_model_id)
3033: AND (cz_devl_projects.checkout_user IS NOT NULL
3034: AND cz_devl_projects.checkout_user <> FND_GLOBAL.user_name)

Line 3031: WHERE cz_model_ref_expls.deleted_flag = '0'

3027: INTO x_model_name_tbl, x_checkout_user_tbl
3028: FROM cz_devl_projects
3029: WHERE cz_devl_projects.devl_project_id IN (SELECT component_id
3030: FROM cz_model_ref_expls
3031: WHERE cz_model_ref_expls.deleted_flag = '0'
3032: AND cz_model_ref_expls.model_id = p_model_id)
3033: AND (cz_devl_projects.checkout_user IS NOT NULL
3034: AND cz_devl_projects.checkout_user <> FND_GLOBAL.user_name)
3035: AND cz_devl_projects.deleted_flag = '0';

Line 3032: AND cz_model_ref_expls.model_id = p_model_id)

3028: FROM cz_devl_projects
3029: WHERE cz_devl_projects.devl_project_id IN (SELECT component_id
3030: FROM cz_model_ref_expls
3031: WHERE cz_model_ref_expls.deleted_flag = '0'
3032: AND cz_model_ref_expls.model_id = p_model_id)
3033: AND (cz_devl_projects.checkout_user IS NOT NULL
3034: AND cz_devl_projects.checkout_user <> FND_GLOBAL.user_name)
3035: AND cz_devl_projects.deleted_flag = '0';
3036: EXCEPTION

Line 3076: FROM cz_model_ref_expls a

3072: SELECT distinct a.component_id
3073: BULK
3074: COLLECT
3075: INTO x_models_to_lock
3076: FROM cz_model_ref_expls a
3077: WHERE a.model_id = p_model_id
3078: AND a.deleted_flag = '0'
3079: AND a.component_id IN ( SELECT devl_project_id
3080: FROM cz_devl_projects

Line 3177: FROM cz_model_ref_expls

3173: SELECT distinct component_id
3174: BULK
3175: COLLECT
3176: INTO l_model_tbl
3177: FROM cz_model_ref_expls
3178: WHERE model_id = p_model_id
3179: AND deleted_flag = '0'
3180: AND ps_node_type IN (263,264);
3181: EXCEPTION

Line 3826: FROM cz_model_ref_expls

3822: SELECT distinct component_id
3823: BULK
3824: COLLECT
3825: INTO l_model_tbl
3826: FROM cz_model_ref_expls
3827: WHERE model_id = p_model_id
3828: AND deleted_flag = '0'
3829: AND ps_node_type IN (263,264);
3830: EXCEPTION