62: ,x_return_status OUT NOCOPY VARCHAR2) IS
63:
64: CURSOR Cur_subinventory(subinventory varchar2 ) IS
65: SELECT Locator_type
66: FROM mtl_secondary_inventories
67: WHERE secondary_inventory_name = subinventory
68: AND organization_id = p_organization_id;
69:
70: CURSOR Cur_item (item_id number ) IS