[Home] [Help]
433:
434: IF (l_model_instantiation_type = NETWORK AND l_instance_hdr_id_tbl.COUNT > 0) THEN
435: FOR i IN l_instance_hdr_id_tbl.FIRST .. l_instance_hdr_id_tbl.LAST LOOP
436: IF l_instance_type_tbl(i) = NETWORK_INSTANCE_ROOT THEN
437: DELETE FROM CZ_CONFIG_EXT_ATTRIBUTES
438: WHERE CONFIG_HDR_ID = l_instance_hdr_id_tbl(i)
439: AND CONFIG_REV_NBR = l_instance_rev_nbr_tbl(i);
440: END IF;
441: END LOOP;
1320: RETURN;
1321: END IF;
1322:
1323: IF p_delete_ext_attr THEN
1324: DELETE FROM CZ_CONFIG_EXT_ATTRIBUTES
1325: WHERE config_hdr_id = p_pseudo_hdr_id AND config_rev_nbr = 1;
1326: END IF;
1327: DELETE FROM CZ_CONFIG_ITEMS
1328: WHERE config_hdr_id = p_pseudo_hdr_id AND config_rev_nbr = 1;
2183: END LOOP;
2184:
2185: l_nDebug := 8;
2186: FORALL i IN l_config_item_tbl.first .. l_config_item_tbl.lAST
2187: INSERT INTO cz_config_ext_attributes(config_hdr_id
2188: ,config_rev_nbr
2189: ,config_item_id
2190: ,attribute_name
2191: ,attribute_group
2206: IF l_rec1_seq IS NULL THEN
2207: l_config_item_tbl.DELETE;
2208: l_seq_nbr_tbl.DELETE;
2209: SELECT attr.config_item_id BULK COLLECT INTO l_config_item_tbl
2210: FROM cz_config_ext_attributes attr, cz_config_items item
2211: WHERE attr.config_hdr_id = l_pseudo_hdr_id AND attr.config_rev_nbr = 1
2212: AND attr.config_hdr_id = item.config_hdr_id AND attr.config_rev_nbr = item.config_rev_nbr
2213: AND attr.config_item_id = item.config_item_id
2214: ORDER BY nvl(length(translate(item.node_identifier,'-0123456789','A')),0), attr.sequence_nbr;
2217: l_seq_nbr_tbl(i) := i + l_idx;
2218: END LOOP;
2219:
2220: FORALL i IN l_config_item_tbl.FIRST .. l_config_item_tbl.LAST
2221: UPDATE cz_config_ext_attributes
2222: SET sequence_nbr = l_seq_nbr_tbl(i)
2223: WHERE config_hdr_id = l_pseudo_hdr_id AND config_rev_nbr = 1
2224: AND config_item_id = l_config_item_tbl(i);
2225: