Hi All,
I have an interactive grid and 2 columns are number fields that I want to set the minimum/maximum values dynamically. The values are dependant on what a user selects from a different column.
For example, when PART_NO is changed I'll see the value of length like so…
DECLARE
l_length VARCHAR2(4000);
BEGIN
SELECT CASE WHEN FLEXI_STATUS = 'Y' THEN LENGTH_MIN||'-'||LENGTH_MAX ELSE NULL END
INTO l_length
FROM S3_SALES_PART_V
WHERE PART_NO = :PART_NO
AND ROWNUM = 1; -- optional, in case multiple rows
RETURN l_length ;
EXCEPTION
WHEN NO_DATA_FOUND THEN
RETURN NULL;
END;
This shows the mimimum and maximum length allowed a user can select. These are different for each part then, like so…
PART_NO | Length
123 | 100-900
124 | 200-500
At the moment it will display the default error: 'length must be a valid number'
Is there a way I can set the tooltip to be custom and say ‘Length must be between range shown’
or
In length (which is a number field) set the Minimum to be a hidden page item value, i.e &P1_LENGTH_MIN. and maximum to be &P1_LENGTH_MAX?