APPS.CZ_MODEL_MIGRATION_PVT dependencies on CZ_CONFIG_ITEMS

Line 318: AND EXISTS (SELECT NULL FROM cz_config_items

314: AND creation_date <= NVL(p_end_date, SYSDATE)
315: AND persistent_component_id = (SELECT persistent_project_id
316: FROM cz_devl_projects
317: WHERE devl_project_id = p_model_id)
318: AND EXISTS (SELECT NULL FROM cz_config_items
319: WHERE config_hdr_id = hdr.config_hdr_id
320: AND config_rev_nbr = hdr.config_rev_nbr
321: AND (parent_config_item_id IS NULL OR parent_config_item_id = -1)
322: AND ps_node_name IS NULL);

Line 389: UPDATE cz_config_items item

385:
386: l_miss_item_tbl.DELETE;
387: IF l_model_type = MODEL_TYPE_NORMAL THEN
388: l_ndebug := 4;
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

Line 402: FROM cz_config_items

398: WHERE config_hdr_id = l_hdr_tbl(i) AND config_rev_nbr = l_rev_tbl(i);
399: l_cmt_rec_count := l_cmt_rec_count + SQL%ROWCOUNT;
400:
401: SELECT config_item_id BULK COLLECT INTO l_miss_item_tbl
402: FROM cz_config_items
403: WHERE config_hdr_id = l_hdr_tbl(i) AND config_rev_nbr = l_rev_tbl(i)
404: AND deleted_flag = '0' AND ps_node_name IS NULL;
405:
406: ELSIF l_model_type = MODEL_TYPE_ABNORMAL THEN

Line 414: FROM cz_config_items

410: l_item_tbl.DELETE;
411: l_name_tbl.DELETE;
412: l_item_prj_map.DELETE;
413: FOR j IN (SELECT config_item_id, ps_node_id, parent_config_item_id
414: FROM cz_config_items
415: WHERE deleted_flag = '0'
416: START WITH (parent_config_item_id IS NULL OR parent_config_item_id = -1)
417: AND config_hdr_id = l_hdr_tbl(i) AND config_rev_nbr = l_rev_tbl(i)
418: CONNECT BY PRIOR config_item_id = parent_config_item_id

Line 447: UPDATE cz_config_items

443:
444: -- print_maps(l_item_prj_map, l_item_tbl, l_name_tbl, l_miss_item_tbl);
445: l_ndebug := 6;
446: FORALL j IN l_item_tbl.FIRST .. l_item_tbl.LAST
447: UPDATE cz_config_items
448: SET ps_node_name = l_name_tbl(j)
449: WHERE config_hdr_id = l_hdr_tbl(i) AND config_rev_nbr = l_rev_tbl(i)
450: AND config_item_id = l_item_tbl(j);
451: