4315: x_error_message OUT NOCOPY VARCHAR2)
4316: IS
4317: CURSOR x_sub_lov IS
4318: SELECT NVL(locator_type, 1)
4319: FROM mtl_secondary_inventories
4320: WHERE organization_id = p_organization_id
4321: AND NVL(disable_date, SYSDATE + 1) > SYSDATE
4322: AND secondary_inventory_name = p_subinventory_code
4323: AND quantity_tracked = 1;
4323: AND quantity_tracked = 1;
4324:
4325: CURSOR x_sub_lov1 IS
4326: SELECT NVL(s.locator_type, 1)
4327: FROM mtl_secondary_inventories s,
4328: mtl_item_sub_inventories i
4329: WHERE s.secondary_inventory_name = i.secondary_inventory
4330: AND s.organization_id = i.organization_id
4331: AND s.organization_id = p_organization_id