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
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
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;
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;
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
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:
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:
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)
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';
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
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
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
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
4449: SELECT distinct component_id
4450: BULK
4451: COLLECT
4452: INTO x_locked_models
4453: FROM cz_model_ref_expls
4454: WHERE model_id = p_model_id
4455: AND deleted_flag = '0'
4456: AND ps_node_type IN (263,264);
4457: