packages sess

sess package

Source code: packages/sess.spec.sql, packages/sess.sql

Introduction

Best way to start is with sessions table.

Initialization

Module name	Type	IN	Lines	Description
init_session 1	P		12	Initialize session
init_session 2	P	1	18	Initialize session and keep resp. set user_id
create_session 1	P	2	36	Set user_id and contexts from previous session
create_session 2	P	3	25	Set user_id and apply contexts from session table
create_session 3	P	4	75	Set user_id and mimic requested APEX page with items
load_session	P	6	51	Load/get contexts from sessions table and set them as current
update_session	P	2	44	Store current contexts and items to sessions and update logs table

Getters for tree package

Module name	Type	IN	Lines	Description
get_user_id	F		11	Returns current user id (APEX, SYS_CONTEXT, DB...)
get_role_id_status	F	3	19	Returns TRUE if user has passed role
get_app_id	F		9	Returns APEX application id
get_page_id	F		9	Returns APEX page id
get_session_db	F		17	Returns database session id
get_session_apex	F		5	Returns APEX session id
get_session_id	F		5	Returns recent session_id from sessions table
get_client_id	F	1	9	Returns client_id for DBMS_SESSION

Context functionality

Module name	Type	IN	Lines	Description
get_context	F	3	23	Returns desired app context as string
get_context_number	F	2	15	Returns desired app context as NUMBER
get_context_date	F	2	15	Returns desired app context as DATE
set_context 1	P	2	33	Set application context value
set_context 2	P	2	20	Set application context value (date)

Storing and retrieving contexts and items

Module name	Type	IN	Lines	Description
get_contexts	F		17	Prepare/get contexts payload from current values
get_apex_globals	F		17	Prepare/get APEX global items
get_apex_locals	F		20	Prepare/get current APEX page items
apply_contexts	P	2	40	Set contexts from payload (available thru SYS_CONTEXT)
apply_items	P	1	23	Parse/set APEX items