Search Results hri_bpl_security




Overview
Explore in AI Chat

Overview

The APPS.HRI_BPL_SECURITY package body is a security-oriented PL/SQL utility within the Oracle E-Business Suite Human Resources Intelligence (HRI) module. Its designation as a Business Process Library (BPL) security package places it within the family of HRI utilities responsible for enforcing access control and resolving the identity of the current user, responsibilities, and organizations during HR reporting and self-service operations. The package encapsulates the logic required to return the correct sign-in person, resolve the manager identity associated with the current user, and determine the operating organization context, all of which are prerequisites for secure HR data retrieval. Because it is a VALID object owned by the APPS schema, it is a supported, production-grade component of the 12.1.1 and 12.2.2 environments.

Key Procedures and Functions

The ETRM metadata documents six procedures and functions. The four named entries are described below; the remaining two are internal helper routines.

  • GET_NAMED_USER_PROFILE_VALUE — Retrieves a profile option value for the named user, providing the profile-based configuration needed for security decisions.
  • GET_APPS_SIGNIN_PERSON_ID — Returns the PERSON_ID of the user currently signed in to the application, establishing the primary identity for downstream security checks.
  • GET_MGR_ID — Returns the manager identifier associated with the current user, supporting manager-hierarchy security access to HR data.
  • GET_ORG_ID — Returns the organization identifier in effect for the current session, allowing the package to scope queries to the correct business group or organization.

Tables Accessed

The only documented table referenced through an APPS synonym is FND_RESPONSIBILITY. This package reads responsibility definitions to establish the responsibility context under which the session is operating, which is essential for determining the profile values and security scope returned by the functions above. No write operations against this table are documented; the access is read-only and used to derive the security context.

Usage Notes

This package is not referenced by any other database object, indicating that it is invoked indirectly — typically by HRI forms, concurrent programs, or reporting components that require a consistent, centralized way to resolve user identity and organization context. Its dependency on FND_GLOBAL and FND_PROFILE confirms that it relies on the standard EBS session globals and profile framework to obtain the current user, responsibility, and organization. Custom code extending HR or OTL reporting should invoke these functions rather than querying FND_RESPONSIBILITY or reading profile options directly, ensuring the same security semantics are applied. Because the underlying logic is subject to EBS support, developers should treat the package as a black box and avoid modifying it; any customizations should wrap or extend the documented interfaces instead.