Results for “hr_lei_flex”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.HR_LEI_FLEX is a PL/SQL package body in the Oracle E-Business Suite Applications schema (APPS) that supports the Legal Entity Identifier (LEI) flexfield infrastructure within Oracle Human Resources. Its role is to manage the Key Flexfield (KFF) definition and validation logic associated with legal entity identification, allowing the HR module to store, structure, and validate the segment combinations that identify legal entities across the enterprise. The package is classified as OTHER in the ETRM metadata, indicating it is not a public, supported API but rather an internal utility consumed by dependent HR components.

In Oracle EBS 12.1.1 and 12.2.2, flexfields remain central to how descriptive and key data are modeled. HR_LEI_FLEX provides the programmatic bridge between the LEI flexfield definition and the underlying HR shadow tables, ensuring that segment values and combinations are resolved consistently whenever legal entity information is entered or queried through HR forms and concurrent processes.

Key Procedures and Functions

The ETRM documentation lists two procedures/functions for this package body:

• DF — a documented entry point within HR_LEI_FLEX. In the context of flexfield utility packages, a routine such as DF typically handles definition or defaulting logic tied to the LEI flexfield structure, resolving segment behavior during flexfield processing.
• DDF — a second documented routine, presumed to support dependent definition or defaulting functionality, complementing DF in the flexfield resolution cycle.

Because the metadata does not expose parameter signatures, parameter lists are intentionally omitted here; consumers should inspect the package specification directly before invoking these routines from custom code. As a package body classified as OTHER rather than a supported public API, both routines are best treated as internal implementation units.

Tables Accessed

Per the dependency listing, HR_LEI_FLEX does not reference standalone business tables directly through APPS synonyms in the documented metadata. Instead, its dependencies are other PL/SQL units: APPS.HR_LEI_FLEX (the specification), APPS.HR_LEI_SHD, APPS.HR_UTILITY, and APPS.PER_ASG_SHD, along with the SYS.STANDARD package. The presence of HR_LEI_SHD and PER_ASG_SHD — shadow tables for flexfield-related definitions and assignment data — indicates that the package reads from and possibly writes to these shadow structures to validate and resolve LEI flexfield segment combinations. HR_UTILITY supplies shared HR helper logic used during that processing. The package is not referenced by any other database object, confirming it sits at the edge of the dependency graph as an internally consumed utility.

Usage Notes

HR_LEI_FLEX is typically invoked indirectly rather than by name. In standard EBS operation, HR forms that capture legal entity data trigger the flexfield engine, which in turn calls utility packages such as this one to validate segments and resolve combinations. Concurrent programs performing HR data validation or migration may also reach this package through the flexfield application programming interface chain.

For custom development, direct invocation of DF or DDF is not recommended unless the calling logic already participates in the flexfield processing lifecycle, because the routines assume the correct flexfield context has been established. Developers extending legal entity functionality should prefer supported flexfield APIs and standard HR interfaces, treating HR_LEI_FLEX as a dependency to be aware of rather than a surface to code against. Because the package is marked VALID and draws only on other APPS utilities and shadow tables, it should be preserved during patching and upgrades in both 12.1.1 and 12.2.2 environments.