I am having an issue with the Apex_Application.g_fxx data structure. I am trying to validate rows within my Master Detail page and need to use apex_application.g_f10 as this is the name of the variable located within the HTML data source stream. The name of the element I need is "f10" as it corresponds to the database column "status" on my page. I am trying to validate that all elements of the detail have the same status or an error is flagged. I use the following PL/SQL block that returns a boolean:
<code>
declare
l_first_value varchar2(4000);
begin
--f10 = PO_STATUS column of PO_DETAILS table on tabular portion of page.
l_first_value := apex_application.g_f10(1);
for i in 2 .. apex_application.g_f10.COUNT
loop
if l_first_value != apex_application.g_f10(i)
then
return false;
end if;
end loop;
return true;
end;
</code>
The HTML data that I am targeting for "f10" is the following:
<code>
<td headers="Status" class="t20data">
<label for="f10_0000" class="hideMeButHearMe">Status</label>
<select name="f10" id="f10_0000">
<option value="" selected="selected">Make a Selection</option>
<option value="APPROVED" >APPROVED</option>
<option value="CLOSED" >CLOSED</option>
</select>
<input type="hidden" name="f02" value="" id="f02_0000" />
<input type="hidden" name="f03" value="30427" id="f03_0000" />
<input type="hidden" id="fcs_0000" name="fcs" value="2158A9B101842608F4CA966C0BC1433D">
<input type="hidden" id="frowid_0000" name="frowid" value="" />
<input type="hidden" id="fcud_0000" name="fcud" value="D" />
</td>
</code>
So not sure why there might be an issue when this validation used to work before. The PL/SQL block takes the first line of F10 data and compares it to successive lines. If the data is not equal, then an error occurs and the user is asked to adjust the data.
It no longer works, though I have checked and the Status still points to F10.
I stumped. I did not use an official master detail page previously. I used two separate pages before: one for the header and another to display master detail. I have upgraded the page for smoother user processing. I would think the data structure though would be identical but maybe I am wrong.
Any ideas?
Thanks!