packages sess.get_apex_globals

sess.get_apex_globals

Repository spec: sess.get_apex_globals, body: sess.get_apex_globals

Signature

FUNCTION get_apex_globals
RETURN sessions.apex_globals%TYPE;

Show code (17 lines)

FUNCTION get_apex_globals
RETURN sessions.apex_globals%TYPE
AS
    out_items       sessions.apex_globals%TYPE;
BEGIN
    $IF $$APEX_INSTALLED $THEN
        SELECT
            LISTAGG(t.item_name || sess.splitter_values || APEX_UTIL.GET_SESSION_STATE(t.item_name), sess.splitter_rows)
                WITHIN GROUP (ORDER BY t.item_name)
        INTO out_items
        FROM apex_application_items t
        WHERE t.application_id = sess.get_app_id()
            AND APEX_UTIL.GET_SESSION_STATE(t.item_name) IS NOT NULL;
    $END    
    --
    RETURN out_items;
END;