Search Results initialize_hr_security

Overview

HR_SIGNON is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the HR Secure User functionality within Oracle Human Resources. Its principal business purpose is to initialize and expose HR security context information at the moment a user signs on to EBS or switches responsibility. The package is declared with AUTHID CURRENT_USER and carries the pragma restrict_references (hr_signon, WNPS, WNDS), meaning it does not write package state or database state directly, which is appropriate for an initialization and query utility.

The package header source (hrsignon.pkh 120.0.12010000.1) confirms that the initialization routine was previously hard-coded inside the FND_CLIENT_INFO package and was later externalized into HR_SIGNON. This design allows HR security profile data to be cached in a package-level global variable, g_hr_security_profile, declared as PER_SECURITY_PROFILES%ROWTYPE, so that downstream HR code can reference the signed-on user's security profile without repeated queries against the base tables.

The user search term "blusigns udaipur" is unrelated to this database object; HR_SIGNON pertains exclusively to Oracle HRMS sign-on security processing.

Key Procedures and Functions

• INITIALIZE_HR_SECURITY — A procedure that is invoked during the initialization of the APPS session whenever a user logs in or switches responsibility. Its documented role is to establish the HR security context for the session, populating the package-level global g_hr_security_profile with the relevant row from PER_SECURITY_PROFILES. The metadata does not document any parameters for this procedure.
• SECURITY_GROUPS_ENABLED — A function that checks whether or not security groups are enabled and returns a VARCHAR2 value. It is used by callers to determine whether HR security group logic should be applied for the current session. The metadata does not document any parameters for this function.

The package also declares a private package-level variable, session_context (NUMBER, initialized to 0), associated with fix 2876315, which mirrors the value held in fnd_global.session_context.

Tables Accessed

• PER_SECURITY_PROFILES — Stores the definition of HR security profiles. HR_SIGNON reads this table to populate g_hr_security_profile with the profile applicable to the signing-on user, enabling secure access to person and assignment data.
• PER_SEC_PROFILE_ASSIGNMENTS — Maps security profiles to users or responsibilities. HR_SIGNON references this table to determine which security profile assignment applies to the current session, thereby driving the security group and profile context.

These tables are referenced through APPS synonyms, consistent with standard EBS schema design. No write operations are documented, which aligns with the WNDS pragma.

Usage Notes

HR_SIGNON is an infrastructure package rather than a user-facing API. It is invoked automatically by the EBS session initialization flow at sign-on and at responsibility switch, replacing logic formerly embedded in FND_CLIENT_INFO. Because it is referenced by five other packages, customizations should avoid modifying it directly and should instead rely on its documented procedures and functions.

Developers writing custom HR code that depends on the active security profile or security group context may call SECURITY_GROUPS_ENABLED to branch logic, and may reference the initialized global variable populated by INITIALIZE_HR_SECURITY. Direct invocation of INITIALIZE_HR_SECURITY from custom code is generally unnecessary, as the standard sign-on sequence already performs it. As with all APPS-owned packages, extensions should be implemented through supported APIs rather than by altering HR_SIGNON itself.