199:
200: BEGIN
201:
202: -- Update Subinventory for the Hierarchy node
203: Update csp_sec_inventories
204: set hierarchy_node_id = NULL
205: where hierarchy_node_id = p_HIERARCHY_NODE_ID;
206:
207: -- Update Subinventory for all the SubHierarchy nodes
204: set hierarchy_node_id = NULL
205: where hierarchy_node_id = p_HIERARCHY_NODE_ID;
206:
207: -- Update Subinventory for all the SubHierarchy nodes
208: Update csp_sec_inventories
209: set hierarchy_node_id = NULL
210: where hierarchy_node_id in (select rh.hierarchy_node_id
211: from csp_rep_hierarchies rh
212: where parent_node_id = p_HIERARCHY_NODE_ID);