APPS.CZ_REFS dependencies on CZ_DEVL_PROJECTS

Line 905: AND EXISTS (SELECT NULL FROM cz_devl_projects

901: t_subtree_tbl.DELETE;
902:
903: FOR i IN(SELECT ps_node_id, devl_project_id FROM CZ_PS_NODES a
904: WHERE reference_id=p_model_id AND deleted_flag='0'
905: AND EXISTS (SELECT NULL FROM cz_devl_projects
906: WHERE devl_project_id = a.devl_project_id
907: AND deleted_flag='0'))
908: LOOP
909: FOR h IN (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS

Line 3019: -- the given model ( CZ_DEVL_PROJECTS.devl_project_id=p_model_id )

3015:
3016: IF v_ps_node_type IN(REFERENCE_TYPE,CONNECTOR_TYPE) AND v_node_Exist=FALSE THEN
3017: --
3018: -- find "Models Chain" that contains
3019: -- the given model ( CZ_DEVL_PROJECTS.devl_project_id=p_model_id )
3020: -- t_chain array will store Model Ids of this chain
3021: --
3022: t_chain.DELETE;t_projectCache.DELETE;
3023: populate_chain(p_model_id);

Line 3228: -- the given model ( CZ_DEVL_PROJECTS.devl_project_id=v_ref_model_id )

3224: ERROR_CODE:=915;
3225:
3226: --
3227: -- find "Models Chain" that contains
3228: -- the given model ( CZ_DEVL_PROJECTS.devl_project_id=v_ref_model_id )
3229: -- t_chain array will store Model Ids of this chain
3230: --
3231: t_chain.DELETE;t_projectCache.DELETE;
3232: populate_chain(p_model_id);