Oracle 11 g
The application is designed for users of different departments / locations of the company, e.g. Australia, New Zealand and Head Office. I'm trying to dynamically set up a home page based on where the user belongs to. The authentication type is SSO, so I've defined the following code in PL/SQL section (see below) and calling the procedure in section. This solution is not working unfortunately... Please, let me know what I'm doing wrong.
WHEN APEX_UTIL.PUBLIC_CHECK_AUTHORIZATION ('Head Office')
WHEN APEX_UTIL.PUBLIC_CHECK_AUTHORIZATION ('Australia')
WHEN APEX_UTIL.PUBLIC_CHECK_AUTHORIZATION ('New Zealand')
-- Not sure about this bit ??? --
APEX_APPLICATION.G_HOME_LINK := v_user_home_page;