APEX JavaScript PL/SQL
And that’s how the cookie crumbles
owa_cookie.send does not write the cookie to the browser because the “Reload on Submit” setting is not set at page level.
APEX Automation PL/SQL
On APEX LOV’s and how to define their queries
The goal in defining LOV queries is to have them stored in a compiled way, having the benefit of database dependencies and making use of the SQL optimizer.