APPS.CZ_MODEL_MIGRATION_PVT dependencies on CZ_MODEL_REF_EXPLS

Line 194: (SELECT component_id FROM cz_model_ref_expls

190: -- each node has name ?
191: BEGIN
192: SELECT MODEL_TYPE_NAME_ERR INTO l_model_type FROM cz_ps_nodes
193: WHERE deleted_flag = '0' AND devl_project_id IN
194: (SELECT component_id FROM cz_model_ref_expls
195: WHERE deleted_flag = '0' AND model_id = p_model_id
196: AND (ps_node_type = PS_NODE_TYPE_REFERENCE OR parent_expl_node_id IS NULL))
197: AND name IS NULL AND rownum < 2;
198: EXCEPTION

Line 208: (SELECT component_id FROM cz_model_ref_expls

204: IF l_model_type = MODEL_TYPE_NORMAL THEN
205: FOR i IN (SELECT persistent_node_id, COUNT(distinct name)
206: FROM cz_ps_nodes
207: WHERE deleted_flag = '0' AND devl_project_id IN
208: (SELECT component_id FROM cz_model_ref_expls
209: WHERE deleted_flag = '0' AND model_id = p_model_id
210: AND (ps_node_type = PS_NODE_TYPE_REFERENCE OR
211: parent_expl_node_id IS NULL))
212: GROUP BY persistent_node_id

Line 270: (SELECT component_id FROM cz_model_ref_expls

266: BEGIN
267: FOR i IN (SELECT devl_project_id, persistent_node_id, name, ps_node_type, reference_id
268: FROM cz_ps_nodes
269: WHERE deleted_flag = '0' AND devl_project_id in
270: (SELECT component_id FROM cz_model_ref_expls
271: WHERE deleted_flag = '0' AND model_id = p_model_id
272: AND (ps_node_type = PS_NODE_TYPE_REFERENCE OR parent_expl_node_id IS NULL)))
273: LOOP
274: l_prj_pid_name_map(i.devl_project_id)(i.persistent_node_id) := i.name;

Line 328: FROM cz_model_ref_expls re

324: FROM cz_devl_projects
325: WHERE devl_project_id = l_mdl_tbl(i) AND deleted_flag = '0';
326:
327: SELECT p_model_id INTO l_model_id
328: FROM cz_model_ref_expls re
329: WHERE deleted_flag = '0' AND model_id = l_mdl_tbl(i)
330: AND ps_node_type = PS_NODE_TYPE_REFERENCE
331: AND NOT EXISTS (SELECT 1 FROM cz_devl_projects
332: WHERE deleted_flag = '0' AND devl_project_id = re.component_id)

Line 369: AND EXISTS (SELECT 1 FROM cz_model_ref_expls

365: UPDATE cz_config_items item
366: SET ps_node_name =
367: (SELECT name FROM cz_ps_nodes psn
368: WHERE deleted_flag = '0' AND persistent_node_id = item.ps_node_id
369: AND EXISTS (SELECT 1 FROM cz_model_ref_expls
370: WHERE deleted_flag = '0' AND model_id = l_model_id
371: AND (ps_node_type = PS_NODE_TYPE_REFERENCE OR parent_expl_node_id IS NULL)
372: AND component_id = psn.devl_project_id)
373: AND rownum < 2)