Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Problem with APEX_APPLICATion validation for master detail page. HELP!

V RickertJun 25 2015 — edited Jun 29 2015

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!

This post has been answered by fac586 on Jun 26 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 27 2015
Added on Jun 25 2015
8 comments
681 views