181:
182: -- List of Cursors used
183: CURSOR c_inv_comp_id(p_component_id NUMBER) IS
184: SELECT inventory_item_id
185: FROM csi_item_instances
186: WHERE instance_id = p_component_id;
187:
188: CURSOR c_inv_subcomp_id(p_subcomponent_id NUMBER) IS
189: SELECT inventory_item_id
186: WHERE instance_id = p_component_id;
187:
188: CURSOR c_inv_subcomp_id(p_subcomponent_id NUMBER) IS
189: SELECT inventory_item_id
190: FROM csi_item_instances
191: WHERE instance_id = p_subcomponent_id;
192:
193: BEGIN
194: