Search Results validate_session

Overview

HR_SESSION_UTILITIES is a server-side PL/SQL package in the Oracle E-Business Suite Applications (APPS) schema that provides shared session and environment utility routines for Oracle HRMS and the self-service (SSHR) framework. Its principal business purpose is to abstract the retrieval of information about the currently logged-in user and the current web session, together with frequently required directory paths, language and date-format settings, and date helper functions. The package body carries the header identifier hrsessuw.pkb 120.1 (2005/09/23), and is shipped noship, i.e. it is not a seed data object but core application code.

The package is of particular interest to developers investigating session validation, because the internal comment at line 31 to 35 documents a deliberate design change: validate session is only used to retrieve data here, not actually used to validate the session. A later modification eliminated the call to validate_session entirely, and the package now calls ICX_SEC directly (icx_sec.getID(n_param => 9)) to resolve the person identifier. Session validation itself is performed outside this function by the calling framework.

Key Procedures and Functions

The ETRM metadata documents fourteen procedures and functions:

• GET_LOGGEDIN_USER — returns the PER_PEOPLE_F%ROWTYPE record of the currently logged-in user. As noted above, it resolves the person via ICX_SEC rather than through a session-validation call, then delegates to HR_GENERAL_UTILITIES.GET_PERSON_RECORD.
• INSERT_SESSION_ROW — inserts a row into the FND_SESSIONS table, establishing a session record.
• REMOVE_SESSION_ROW — removes the corresponding FND_SESSIONS row, typically at session termination.
• GET_LANGUAGE_CODE — returns the current language code for the session.
• GET_IMAGE_DIRECTORY, GET_HTML_DIRECTORY, GET_STATIC_HTML_DIRECTORY, GET_JAVA_DIRECTORY — return the configured filesystem or URL directory locations for images, HTML, static HTML, and Java resources respectively.
• GET_USER_DATE_FORMAT — returns the date format mask applicable to the logged-in user.
• GET_BASE_HREF — returns the base HREF value used for constructing web links.
• GET_TODAY — returns the current date, cached in the package global g_today.
• GET_TODAY_AS_TEXT — returns the current date as a formatted character string (g_today_txt).
• GET_PRINT_ACTION — returns the applicable print action for the session context.

Tables Accessed

The package references the following objects through APPS synonyms: FND_SESSIONS (session rows created and deleted by INSERT_SESSION_ROW and REMOVE_SESSION_ROW), FND_PRODUCT_INSTALLATIONS (installation and directory configuration used by the directory and format getters), WF_ITEMS (Workflow items), and the OWA_COOKIE and OWA_UTIL PL/SQL toolkit packages, which supply cookie and HTTP utility handling for the web session. PER_PEOPLE_F is referenced for the person record returned by GET_LOGGEDIN_USER.

Usage Notes

HR_SESSION_UTILITIES is invoked from Oracle Forms, self-service web pages, and other PL/SQL packages rather than by end users directly; the ETRM metadata records it as referenced by three other packages. It is the standard entry point within HRMS for obtaining the logged-in person and session-scoped configuration such as language, date format, and directory paths. Custom code should call GET_LOGGEDIN_USER for the current person, and must not rely on this package to validate a session, since that responsibility lies with the calling application layer.