[Home] [Help]
403:
404: IF (l_model_instantiation_type = NETWORK AND l_instance_hdr_id_tbl.COUNT > 0) THEN
405: FOR i IN l_instance_hdr_id_tbl.FIRST .. l_instance_hdr_id_tbl.LAST LOOP
406: IF l_instance_type_tbl(i) = NETWORK_INSTANCE_ROOT THEN
407: DELETE FROM CZ_CONFIG_EXT_ATTRIBUTES
408: WHERE CONFIG_HDR_ID = l_instance_hdr_id_tbl(i)
409: AND CONFIG_REV_NBR = l_instance_rev_nbr_tbl(i);
410: END IF;
411: END LOOP;
1227: RETURN;
1228: END IF;
1229:
1230: IF p_delete_ext_attr THEN
1231: DELETE FROM CZ_CONFIG_EXT_ATTRIBUTES
1232: WHERE config_hdr_id = p_pseudo_hdr_id AND config_rev_nbr = 1;
1233: END IF;
1234: DELETE FROM CZ_CONFIG_ITEMS
1235: WHERE config_hdr_id = p_pseudo_hdr_id AND config_rev_nbr = 1;
1830: END LOOP;
1831:
1832: l_nDebug := 8;
1833: FORALL i IN l_config_item_tbl.first .. l_config_item_tbl.lAST
1834: INSERT INTO cz_config_ext_attributes(config_hdr_id
1835: ,config_rev_nbr
1836: ,config_item_id
1837: ,attribute_name
1838: ,attribute_group
1853: IF l_rec1_seq IS NULL THEN
1854: l_config_item_tbl.DELETE;
1855: l_seq_nbr_tbl.DELETE;
1856: SELECT attr.config_item_id BULK COLLECT INTO l_config_item_tbl
1857: FROM cz_config_ext_attributes attr, cz_config_items item
1858: WHERE attr.config_hdr_id = l_pseudo_hdr_id AND attr.config_rev_nbr = 1
1859: AND attr.config_hdr_id = item.config_hdr_id AND attr.config_rev_nbr = item.config_rev_nbr
1860: AND attr.config_item_id = item.config_item_id
1861: ORDER BY nvl(length(translate(item.node_identifier,'-0123456789','A')),0), attr.sequence_nbr;
1864: l_seq_nbr_tbl(i) := i + l_idx;
1865: END LOOP;
1866:
1867: FORALL i IN l_config_item_tbl.FIRST .. l_config_item_tbl.LAST
1868: UPDATE cz_config_ext_attributes
1869: SET sequence_nbr = l_seq_nbr_tbl(i)
1870: WHERE config_hdr_id = l_pseudo_hdr_id AND config_rev_nbr = 1
1871: AND config_item_id = l_config_item_tbl(i);
1872: