Databases Reference
In-Depth Information
l message := l message ||
'<li>The Quantity value in row #'|| i ||
' must be a whole number.';
--
-- flip valid numbers flag to avoid processing
-- error below
--
l valid numbers := false;
end;
end if;
--
-- order line items cannot be less than $10, so check
-- the line item subtotals if both values were numeric
--
if l valid numbers then
if apex application.g f02(i) * apex application.g f03(i)
< 10 then
l message := l message ||
'<li>The Product subtotal in '||
'row #'|| i ||
' may not be less than 10 dollars.';
end if;
end if;
end loop;
--
-- update collection to store SUBMITTED values.
-- we might need these to rerender the form but it
-- will be easier to process the data in a collection versus
-- the pl/sql apex application.g f0n arrays.
--
for i in 1..apex application.g f01.count loop
--
-- update collection member based on g f01 being the
-- product id (c001) for given member
--
for c2 in (select c.seq id
from apex collections c
where c.collection name = 'ORDER ADJUSTMENTS'
and c.c001 = apex application.g f01(i))
loop
apex collection.update member(
p collection name => 'ORDER ADJUSTMENTS',
p seq => c2.seq id,
p c001 => apex application.g f01(i),
p c002 => apex application.g f02(i),
p c003 => apex application.g f03(i)
);
end loop;
end loop;
--
-- return validation messages if any
--
