Search Results hr_util_misc_web




Overview
Explore in AI Chat

Overview

HR_UTIL_MISC_WEB is a shared Oracle Application Object Library utility package body in the APPS schema that provides the miscellaneous server-side plumbing used by Oracle E-Business Suite's self-service HRMS web pages. It is classified by ETRM as an "OTHER" API rather than a formal business API, reflecting its role as an internal toolkit rather than a callable interface. In Oracle EBS 12.1.1 and 12.2.2 the package remains VALID and is referenced by thirty-one other packages, indicating wide internal reuse across the HR self-service layer, Oracle iRecruitment-style flows, and personalization pages. Its responsibilities fall into four broad areas: derivation of localization and display attributes (NLS parameters, group separators, currency masks, date formats, language codes), resolution of web-application file locations (image, HTML, and calendar directories), construction and validation of session state for stateless web requests, and formatting helpers that build dynamic SQL or HTML fragments and decode message text. Because these concerns recur in nearly every HRMS self-service page, centralizing them in one package avoids duplication and keeps locale and session behavior consistent across modules.

Key Procedures and Functions

The documented interface exposes thirty-nine procedures and functions. NLS and display helpers include GET_NLS_PARAMETER, GET_GROUP_SEPARATOR, GET_CURRENCY_MASK, GET_LANGUAGE_CODE, and GET_USER_DATE_FORMAT, which surface locale-specific values derived from V$NLS_PARAMETERS, FND_PROFILE, and related sources. Validation routines IS_VALID_NUMBER, IS_VALID_CURRENCY, and VALIDATE_DATE_LOOKUP_CODE confirm that user-entered data conforms to the current locale conventions. Directory resolvers GET_IMAGE_DIRECTORY, GET_HTML_DIRECTORY, and GET_CALENDAR_FILE return the correct web path for static assets. Person and message helpers include GET_PERSON_REC and RETURN_MSG_TEXT. Date handling is supported by BUILD_DATE2CHAR_EXPRESSION, which constructs a SQL expression converting a date column to a locale-formatted character string. Session management is covered by INSERT_SESSION_ROW, AUTONOMOUS_COMMIT_FND_SESS_ROW, REMOVE_SESSION_ROW, VALIDATE_SESSION, and the supporting PREPARE_PARAMETER and GET_COMPLETE_URL routines, which together persist and verify FND_SESSIONS/ICX_SESSIONS state across page transitions.

Tables Accessed

The package reads and writes through APPS synonyms. Session state is maintained in FND_SESSIONS and ICX_SESSIONS, with FND_PRODUCT_INSTALLATIONS and FND_WEB_CONFIG consulted for installation and configuration context. Person lookups use PER_ALL_PEOPLE_F and PER_BUSINESS_GROUPS. Locale and lookup values come from FND_FORM_FUNCTIONS, HR_LOOKUPS, and V$NLS_PARAMETERS. Document-related routines touch FND_ATTACHED_DOCUMENTS, FND_ATTACHED_DOCUMENTS_S, FND_DOCUMENTS, FND_DOCUMENTS_TL, FND_DOCUMENTS_LONG_TEXT, FND_DOCUMENT_CATEGORIES, FND_DOCUMENT_CATEGORIES_TL, and FND_DOCUMENT_DATATYPES. DUAL supplies scalar expression evaluation, and HTP is used for HTML generation.

Usage Notes

HR_UTIL_MISC_WEB is not intended for direct customer invocation. It is called by HRMS self-service pages and by the other thirty-one dependent packages, typically during page rendering, form validation, and session initialization. Customizations that require locale-aware number or currency validation, session verification, or dynamic date formatting within HRMS web extensions may call these routines, but Oracle support treats the interface as internal; signatures should be verified against the deployed database before reliance.