91: AND cz_model_publications.product_key like '%:%';
92:
93: CURSOR ui_def_cur(v_models cz_devl_projects.devl_project_id%TYPE) IS
94: SELECT ui_def_id, ui_style
95: FROM cz_ui_defs
96: WHERE cz_ui_defs.devl_project_id = v_models
97: AND deleted_flag = '0'
98: order by LAST_UPDATE_DATE desc;
99:
92:
93: CURSOR ui_def_cur(v_models cz_devl_projects.devl_project_id%TYPE) IS
94: SELECT ui_def_id, ui_style
95: FROM cz_ui_defs
96: WHERE cz_ui_defs.devl_project_id = v_models
97: AND deleted_flag = '0'
98: order by LAST_UPDATE_DATE desc;
99:
100: CURSOR appl_cur(v_preferred_ui_style VARCHAR2) IS
3217: SELECT ui_def_id
3218: BULK
3219: COLLECT
3220: INTO t_uis_ref
3221: FROM cz_ui_defs
3222: WHERE cz_ui_defs.devl_project_id IN (SELECT COMPONENT_ID
3223: FROM CZ_MODEL_REF_EXPLS
3224: WHERE model_id = t_model_ids_tbl(i)
3225: AND deleted_flag = '0')
3218: BULK
3219: COLLECT
3220: INTO t_uis_ref
3221: FROM cz_ui_defs
3222: WHERE cz_ui_defs.devl_project_id IN (SELECT COMPONENT_ID
3223: FROM CZ_MODEL_REF_EXPLS
3224: WHERE model_id = t_model_ids_tbl(i)
3225: AND deleted_flag = '0')
3226: AND cz_ui_defs.deleted_flag = '0'
3222: WHERE cz_ui_defs.devl_project_id IN (SELECT COMPONENT_ID
3223: FROM CZ_MODEL_REF_EXPLS
3224: WHERE model_id = t_model_ids_tbl(i)
3225: AND deleted_flag = '0')
3226: AND cz_ui_defs.deleted_flag = '0'
3227: AND cz_ui_defs.ui_style = '0';
3228: EXCEPTION
3229: WHEN NO_DATA_FOUND THEN
3230: NULL;
3223: FROM CZ_MODEL_REF_EXPLS
3224: WHERE model_id = t_model_ids_tbl(i)
3225: AND deleted_flag = '0')
3226: AND cz_ui_defs.deleted_flag = '0'
3227: AND cz_ui_defs.ui_style = '0';
3228: EXCEPTION
3229: WHEN NO_DATA_FOUND THEN
3230: NULL;
3231: END;