:global.price_new := :price_new;

declare
	no_types number;
begin

	select type_num
	into no_types
	from types, prices
	where types.type_name = prices.type_name;

        if no_types is not null then
	   :types.price := :global.price_new * no_types;
        else
	   message('There is no price for that type. Please add a price for it in price page.');
	   message('There is no price for that type. Please add a price for it in price page.');
        end if;
end;