636:
637: if (p_item_name is not null ) and ( l_supplier_item_flag=false ) and ( l_customer_item_flag=false ) then
638: BEGIN
639: select cm.inventory_item_id into l_item_id 640: from msc_items cm 641: where
642: item_name=p_item_name;
643:
644: -- --dbms_output.put_line('item name exists' ||l_item_id);