Search Results get_sp_id

Overview

HR_SIGNON is a private internal package body in the APPS schema that governs the establishment of Human Resources security context at the moment a user signs on to Oracle E-Business Suite. Its central responsibility is to determine which business group (the highest-level HR organization partition) should be applied to the current session, and to initialize the HR security profile that constrains the data the user can access. Because the same responsibility may be shared by users operating under either a single security group model or a multi security group model, HR_SIGNON abstracts that decision behind the ENABLE_SECURITY_GROUPS profile option.

The package carries a header of hrsignon.pkb 120.1.12010000.2, placing it in the 12.1.1 release family and confirming its continued presence in 12.2.2. It is classified in the ETRM repository as OTHER rather than as a public API, reflecting its role as signon-time infrastructure rather than a callable business interface.

Key Procedures and Functions

• INITIALIZE_HR_SECURITY — the principal entry point. It establishes the HR security context for the session, resolving the appropriate business group and security profile so that subsequent HR queries are filtered correctly. When ENABLE_SECURITY_GROUPS is set to 'Y', multiple security groups may be used against a single responsibility and the business group is derived by querying PER_BUSINESS_GROUPS with the security group the user selected at signon. When the profile is 'N', the single security group model applies and the business group is located through the business group profile value.
• SECURITY_GROUPS_ENABLED — a helper that reports whether the multi security group model is active, allowing calling code to branch between the two derivation strategies described above.

Both routines are declared inside the package body and are not exposed as described public parameters in the metadata; the private helper Get_BG_ID performs the underlying lookup logic, and Generic_Error raises FND-style messages via FND_MESSAGE with the SQL_PLSQL_ERROR token set.

Tables Accessed

• PER_SECURITY_PROFILES — the definition table for HR security profiles, read to identify the security profile assigned to the signing-on user or responsibility.
• PER_SEC_PROFILE_ASSIGNMENTS — the assignment table linking security profiles to responsibilities or users; queried to resolve the effective profile at signon.

In addition, the package references PER_BUSINESS_GROUPS when deriving the business group under the multi security group model. This linkage is directly relevant to the user search term per_business_group, since the business group is the value ultimately returned and cached for the session.

Usage Notes

HR_SIGNON is invoked automatically during the signon transaction, typically through the Oracle Forms FND_SIGNON flow and the HR responsibility initialization logic, rather than being called directly by end users. Five other packages in the ETRM repository are documented as referencing it, indicating that HR product code depends on its output when establishing session context.

Custom code should not call INITIALIZE_HR_SECURITY directly to change security context; the supported approach is to set the ENABLE_SECURITY_GROUPS profile option and assign security profiles through the standard HR security configuration screens. Because the package relies on profile values evaluated at signon time, changes to security group configuration or profile settings take effect only after the user signs out and reconnects.