338: IF p_uom_code IS NOT NULL THEN
339: BEGIN
340: SELECT Primary_Uom_Code
341: INTO l_primary_uom_code
342: FROM MTL_SYSTEM_ITEMS
343: WHERE Organization_Id = p_organization_id
344: AND Inventory_Item_Id = p_inventory_item_id;
345: EXCEPTION
346: WHEN no_data_found THEN
640: l_lot_control NUMBER;
641: CURSOR get_item_details( org_id IN NUMBER
642: , item_id IN NUMBER) IS
643: SELECT NVL(lot_control_code, 1)
644: FROM mtl_system_items
645: WHERE inventory_item_id = item_id
646: AND organization_id = org_id;
647:
648: l_demand_header_type NUMBER;
900: IF p_uom_code IS NOT NULL THEN
901: BEGIN
902: SELECT Primary_Uom_Code
903: INTO l_primary_uom_code
904: FROM MTL_SYSTEM_ITEMS
905: WHERE Organization_Id = p_organization_id
906: AND Inventory_Item_Id = p_inventory_item_id;
907: EXCEPTION
908: WHEN no_data_found THEN
1316: l_lot_control NUMBER;
1317: CURSOR get_item_details( org_id IN NUMBER
1318: , item_id IN NUMBER) IS
1319: SELECT NVL(lot_control_code, 1)
1320: FROM mtl_system_items
1321: WHERE inventory_item_id = item_id
1322: AND organization_id = org_id;
1323:
1324: l_demand_header_type NUMBER;
1440: IF p_uom_code IS NOT NULL THEN
1441: BEGIN
1442: SELECT Primary_Uom_Code
1443: INTO l_primary_uom_code
1444: FROM MTL_SYSTEM_ITEMS
1445: WHERE Organization_Id = p_organization_id
1446: AND Inventory_Item_Id = p_inventory_item_id;
1447: EXCEPTION
1448: WHEN no_data_found THEN