Search Results hr_session_utilities




Overview
Explore in AI Chat

Overview

HR_SESSION_UTILITIES is an Oracle E-Business Suite PL/SQL package owned by the APPS schema. It provides low-level session and environment utility routines that support Oracle HRMS self-service and related web-based functionality. The package abstracts common operations such as identifying the currently logged-in user, writing and removing session rows, resolving directory paths for images, HTML, and Java resources, and formatting date and text values for display. In EBS 12.1.1 and 12.2.2, it functions as a shared infrastructure dependency rather than a business-facing API, and its ETRM classification is OTHER.

The package is closely coupled with the Oracle HRMS schema. It references PER_PEOPLE_F and WF_ITEMS directly, and it is referenced by HR_GENERAL_UTILITIES — the object most commonly associated with the search term "hr_general_utilities" — as well as by HXT_BATCH_VAL and PAY_IN_TAX_DECLARATION. This dependency chain confirms its role as a foundational utility layer beneath higher-level HRMS packages.

Key Procedures and Functions

The ETRM metadata documents fourteen procedures and functions, thirteen of which are itemized below:

  • GET_LOGGEDIN_USER — Returns the identity of the user currently associated with the session, supporting personalization and security checks.
  • INSERT_SESSION_ROW — Creates a session record, typically in FND_SESSIONS, to establish or refresh session state.
  • REMOVE_SESSION_ROW — Deletes the corresponding session record, used during logout or session cleanup.
  • GET_LANGUAGE_CODE — Retrieves the active language code for the session, driving localization behavior.
  • GET_IMAGE_DIRECTORY — Returns the directory path used to locate image resources.
  • GET_HTML_DIRECTORY — Returns the directory path used to locate HTML resources.
  • GET_STATIC_HTML_DIRECTORY — Returns the directory path for static HTML content.
  • GET_JAVA_DIRECTORY — Returns the directory path for Java resources.
  • GET_USER_DATE_FORMAT — Returns the date format mask applicable to the current user, enabling consistent display formatting.
  • GET_BASE_HREF — Returns the base URL reference used to construct relative links in generated HTML.
  • GET_TODAY — Returns the current date value.
  • GET_TODAY_AS_TEXT — Returns the current date rendered as text, typically for display purposes.
  • GET_PRINT_ACTION — Returns the print action setting associated with the session or page context.

Tables Accessed

Via APPS synonyms, the package interacts with several underlying database objects:

  • FND_SESSIONS — Stores session records created and removed by INSERT_SESSION_ROW and REMOVE_SESSION_ROW.
  • FND_PRODUCT_INSTALLATIONS — Consulted to determine product installation status and related configuration.
  • WF_ITEMS — Referenced for workflow item context, aligning session activity with workflow events.
  • PER_PEOPLE_F — Referenced to resolve person-level information tied to the logged-in user.
  • OWA_COOKIE and OWA_UTIL — Oracle Web Agent packages used for cookie handling and web utility operations.

Usage Notes

HR_SESSION_UTILITIES is invoked indirectly rather than directly by end users. Its principal consumer is HR_GENERAL_UTILITIES, with additional references from HXT_BATCH_VAL, PAY_IN_TAX_DECLARATION, and HR_SESSION_UTILITIES itself. As a result, it executes during HRMS self-service page rendering, workflow-driven batch validation, and payroll tax declaration processing. Custom code should call higher-level packages such as HR_GENERAL_UTILITIES rather than HR_SESSION_UTILITIES directly, since the utility layer is internal and may change between releases. No direct concurrent program or form entry point is documented for this package; it operates strictly as a supporting dependency in EBS 12.1.1 and 12.2.2.