Hi Everyone,
Oracle 11 g
APEX 4.2.2
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.
PROCEDURE set_home_page
AS
v_user_home_page VARCHAR2(3);
BEGIN
v_user_home_page :=
CASE
WHEN APEX_UTIL.PUBLIC_CHECK_AUTHORIZATION ('Head Office')
THEN '1'
WHEN APEX_UTIL.PUBLIC_CHECK_AUTHORIZATION ('Australia')
THEN '2'
WHEN APEX_UTIL.PUBLIC_CHECK_AUTHORIZATION ('New Zealand')
THEN '3'
ELSE '1'
END;
-- Not sure about this bit ??? --
APEX_APPLICATION.G_HOME_LINK := v_user_home_page;
END;