APPS.CZ_MODEL_MIGRATION_PVT dependencies on CZ_CONFIG_ITEMS

Line 294: AND EXISTS (SELECT NULL FROM cz_config_items

290: AND creation_date <= NVL(p_end_date, SYSDATE)
291: AND persistent_component_id = (SELECT persistent_project_id
292: FROM cz_devl_projects
293: WHERE devl_project_id = p_model_id)
294: AND EXISTS (SELECT NULL FROM cz_config_items
295: WHERE config_hdr_id = hdr.config_hdr_id
296: AND config_rev_nbr = hdr.config_rev_nbr
297: AND (parent_config_item_id IS NULL OR parent_config_item_id = -1)
298: AND ps_node_name IS NULL);

Line 365: UPDATE cz_config_items item

361:
362: l_miss_item_tbl.DELETE;
363: IF l_model_type = MODEL_TYPE_NORMAL THEN
364: l_ndebug := 4;
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

Line 378: FROM cz_config_items

374: WHERE config_hdr_id = l_hdr_tbl(i) AND config_rev_nbr = l_rev_tbl(i);
375: l_cmt_rec_count := l_cmt_rec_count + SQL%ROWCOUNT;
376:
377: SELECT config_item_id BULK COLLECT INTO l_miss_item_tbl
378: FROM cz_config_items
379: WHERE config_hdr_id = l_hdr_tbl(i) AND config_rev_nbr = l_rev_tbl(i)
380: AND deleted_flag = '0' AND ps_node_name IS NULL;
381:
382: ELSIF l_model_type = MODEL_TYPE_ABNORMAL THEN

Line 390: FROM cz_config_items

386: l_item_tbl.DELETE;
387: l_name_tbl.DELETE;
388: l_item_prj_map.DELETE;
389: FOR j IN (SELECT config_item_id, ps_node_id, parent_config_item_id
390: FROM cz_config_items
391: WHERE deleted_flag = '0'
392: START WITH (parent_config_item_id IS NULL OR parent_config_item_id = -1)
393: AND config_hdr_id = l_hdr_tbl(i) AND config_rev_nbr = l_rev_tbl(i)
394: CONNECT BY PRIOR config_item_id = parent_config_item_id

Line 423: UPDATE cz_config_items

419:
420: -- print_maps(l_item_prj_map, l_item_tbl, l_name_tbl, l_miss_item_tbl);
421: l_ndebug := 6;
422: FORALL j IN l_item_tbl.FIRST .. l_item_tbl.LAST
423: UPDATE cz_config_items
424: SET ps_node_name = l_name_tbl(j)
425: WHERE config_hdr_id = l_hdr_tbl(i) AND config_rev_nbr = l_rev_tbl(i)
426: AND config_item_id = l_item_tbl(j);
427: