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!

How to show and hide page items based on a change on another page item and a database function?

AllenS.Jun 20 2019 — edited Jun 20 2019

Hi,

I have a requirement to show and hide items based on other item values and a database function.

So basically I have the following function:

create function is_rendered ( p_country in varchar2, p_currency_code in varchar2, p_item in varchar2 ) return boolean

is

begin

if ( use country, currency and item in some condition ) then

return true;

else

return false;

end if;

end;

In my page I have the following items:

P8_COUNTRY

P8_CURRENCY_CODE

P8_SWIFT_BIC_BEI

P8_FED_WIRE

Depending on the currency chosen, I would then either show or hide P8_SWIFT_BIC_BEI and P8_FED_WIRE.

What I've tried is to use a Dynamic Action (Change) on both P8_COUNTRY and P8_CURRENCY_CODE.

pastedImage_3.png

Then I added a Server-side condition.

pastedImage_5.png

However, I can't seem to add a False action to this. I'm getting the error below.

pastedImage_6.pngpastedImage_7.png

Appreciate any help.

Regards,

Allen

Comments
Post Details
Added on Jun 20 2019
1 comment
2,960 views