Oracle APEX - Popup LOV Events Plugin

Sharing a small plugin, providing ‘Open’ and ‘Close’ events for Popup LOV’s as can be used in Dynamic Actions. The events can be used for both 'Modal Dialog' and 'Inline Popup'.

The ‘Open’ event typically can be used for things like:

• setting P0 item(s) which are used in a Shared Component LOV query

• setting specific dialog options, eg setting the dialog height to 85% of the browser inner height

The ‘Close’ event will enable to check if the dialog was cancelled.

To expand a bit on the P0 item(s): suppose you have a Shared Component LOV as used on multiple pages/places. The LOV is used as cascading from a page item value. As the LOV is used in multiple places, the LOV query uses a generic bind variable:

When using more than once on a page, the most robust and save is to set the P0_STATE just before the Popup LOV is getting populated.

And so, you can define the DA for the purpose:

By next configuration, the P0 item is part of the items to submit:

In other situations where there is no Cascading, the item can be submitted by using next Initialization JS Function on the LOV item:

function(options) {
   options.itemsToSubmit=['P0_ITEM'];
   return options;
}

The P0 item can have ‘Per Request’ Session State Storage:

Find the demo page here.

And that makes up plugin number 12 under the lib4x umbrella. Have a nice day!