4377: BEGIN
4378: IF p_inventory_item_id IS NULL THEN
4379: IF p_item_number IS NOT NULL THEN
4380: SELECT INVENTORY_ITEM_ID INTO l_inventory_item_id
4381: FROM MTL_SYSTEM_ITEMS_B_KFV
4382: WHERE ORGANIZATION_ID = l_organization_id
4383: AND CONCATENATED_SEGMENTS = p_item_number;
4384: ELSE
4385: RAISE INVALID_ITEM;
4385: RAISE INVALID_ITEM;
4386: END IF;
4387: ELSE
4388: SELECT INVENTORY_ITEM_ID INTO l_inventory_item_id
4389: FROM MTL_SYSTEM_ITEMS_B_KFV
4390: WHERE ORGANIZATION_ID = l_organization_id
4391: AND INVENTORY_ITEM_ID = p_inventory_item_id;
4392: END IF;
4393: