382: l_return_val_wrap number := -1;
383:
384: cursor get_item_primary_uom is
385: select primary_uom_code
386: from mtl_system_items msi
387: where msi.inventory_item_id = p_inventory_item_id
388: and msi.organization_id = p_organization_id;
389:
390: begin
565:
566: -- @@@ Get the primary uom for the Item in question.
567: cursor c_get_prim_uom_code is
568: select primary_uom_code
569: from mtl_system_items mtl
570: where mtl.inventory_item_id = p_inventory_item_id
571: and mtl.organization_id = p_organization_id;
572:
573: -- @@@ Get the records in WLC in the prim uom of the item.
690:
691: -- @@@ Get the primary uom for the Item in question.
692: cursor c_get_prim_uom_code is
693: select primary_uom_code
694: from mtl_system_items mtl
695: where mtl.inventory_item_id = p_inventory_item_id
696: and mtl.organization_id = p_organization_id;
697:
698: -- @@@ Check to see if the record in WLC is in the prim uom of the item.