APEX

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 Post-Authentication Procedure Name 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;