APPS.CZ_REFS dependencies on CZ_DEVL_PROJECTS

Line 839: AND EXISTS (SELECT NULL FROM cz_devl_projects

835: t_subtree_tbl.DELETE;
836:
837: FOR i IN(SELECT ps_node_id, devl_project_id FROM CZ_PS_NODES a
838: WHERE reference_id=p_model_id AND deleted_flag='0'
839: AND EXISTS (SELECT NULL FROM cz_devl_projects
840: WHERE devl_project_id = a.devl_project_id
841: AND deleted_flag='0'))
842: LOOP
843: FOR h IN (SELECT model_ref_expl_id FROM CZ_MODEL_REF_EXPLS

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

2948:
2949: IF v_ps_node_type IN(REFERENCE_TYPE,CONNECTOR_TYPE) AND v_node_Exist=FALSE THEN
2950: --
2951: -- find "Models Chain" that contains
2952: -- the given model ( CZ_DEVL_PROJECTS.devl_project_id=p_model_id )
2953: -- t_chain array will store Model Ids of this chain
2954: --
2955: t_chain.DELETE;t_projectCache.DELETE;
2956: populate_chain(p_model_id);

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

3157: ERROR_CODE:=915;
3158:
3159: --
3160: -- find "Models Chain" that contains
3161: -- the given model ( CZ_DEVL_PROJECTS.devl_project_id=v_ref_model_id )
3162: -- t_chain array will store Model Ids of this chain
3163: --
3164: t_chain.DELETE;t_projectCache.DELETE;
3165: populate_chain(p_model_id);