APPS.CZ_MODEL_MIGRATION_PVT dependencies on CZ_MODEL_REF_EXPLS

Line 218: (SELECT component_id FROM cz_model_ref_expls

214: -- each node has name ?
215: BEGIN
216: SELECT MODEL_TYPE_NAME_ERR INTO l_model_type FROM cz_ps_nodes
217: WHERE deleted_flag = '0' AND devl_project_id IN
218: (SELECT component_id FROM cz_model_ref_expls
219: WHERE deleted_flag = '0' AND model_id = p_model_id
220: AND (ps_node_type = PS_NODE_TYPE_REFERENCE OR parent_expl_node_id IS NULL))
221: AND name IS NULL AND rownum < 2;
222: EXCEPTION

Line 232: (SELECT component_id FROM cz_model_ref_expls

228: IF l_model_type = MODEL_TYPE_NORMAL THEN
229: FOR i IN (SELECT persistent_node_id, COUNT(distinct name)
230: FROM cz_ps_nodes
231: WHERE deleted_flag = '0' AND devl_project_id IN
232: (SELECT component_id FROM cz_model_ref_expls
233: WHERE deleted_flag = '0' AND model_id = p_model_id
234: AND (ps_node_type = PS_NODE_TYPE_REFERENCE OR
235: parent_expl_node_id IS NULL))
236: GROUP BY persistent_node_id

Line 294: (SELECT component_id FROM cz_model_ref_expls

290: BEGIN
291: FOR i IN (SELECT devl_project_id, persistent_node_id, name, ps_node_type, reference_id
292: FROM cz_ps_nodes
293: WHERE deleted_flag = '0' AND devl_project_id in
294: (SELECT component_id FROM cz_model_ref_expls
295: WHERE deleted_flag = '0' AND model_id = p_model_id
296: AND (ps_node_type = PS_NODE_TYPE_REFERENCE OR parent_expl_node_id IS NULL)))
297: LOOP
298: l_prj_pid_name_map(i.devl_project_id)(i.persistent_node_id) := i.name;

Line 352: FROM cz_model_ref_expls re

348: FROM cz_devl_projects
349: WHERE devl_project_id = l_mdl_tbl(i) AND deleted_flag = '0';
350:
351: SELECT p_model_id INTO l_model_id
352: FROM cz_model_ref_expls re
353: WHERE deleted_flag = '0' AND model_id = l_mdl_tbl(i)
354: AND ps_node_type = PS_NODE_TYPE_REFERENCE
355: AND NOT EXISTS (SELECT 1 FROM cz_devl_projects
356: WHERE deleted_flag = '0' AND devl_project_id = re.component_id)

Line 393: AND EXISTS (SELECT 1 FROM cz_model_ref_expls

389: UPDATE cz_config_items item
390: SET ps_node_name =
391: (SELECT name FROM cz_ps_nodes psn
392: WHERE deleted_flag = '0' AND persistent_node_id = item.ps_node_id
393: AND EXISTS (SELECT 1 FROM cz_model_ref_expls
394: WHERE deleted_flag = '0' AND model_id = l_model_id
395: AND (ps_node_type = PS_NODE_TYPE_REFERENCE OR parent_expl_node_id IS NULL)
396: AND component_id = psn.devl_project_id)
397: AND rownum < 2)