Results for “hr_lei_ins”

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

Overview

HR_LEI_INS is an internal PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM metadata as an API of type OTHER. It belongs to the Human Resources family of legal entity and location-related extension objects, as indicated by its naming convention (HR_LEI for the HR Legal Entity / Location Extra Info area) and its documented relationship to the HR_LOCATION_EXTRA_INFO table family. The package serves as an insert-oriented worker module that supports the storage and maintenance of supplementary location information that is not captured in the core HR_LOCATION record. In Oracle EBS 12.1.1 and 12.2.2, the HR_LOCATION_EXTRA_INFO and HR_LOCATION_EXTRA_INFO_S (shadow) tables are used to hold DFF-style or customer-specific attributes attached to a location, and HR_LEI_INS provides the packaged logic that performs the insert operations against these tables. It is not a public, customer-callable API in the sense of HR_LOCATION_API or HR_LOCATION_EXTRA_INFO_API; rather, it is a supporting internal package invoked on behalf of higher-level APIs and forms.

Key Procedures and Functions

The documented procedures and functions available in this package are limited, with only one procedure and no additional functions evident from the extracted metadata.

• INS — A single procedure named INS is the operational entry point of the package. Its name and classification indicate that it is responsible for performing insert processing into the location extra information tables. As the metadata does not expose a parameter list, no parameter details are documented here; the procedure should be treated as an internal insert handler. It is invoked indirectly through the HR_LOCATION_EXTRA_INFO_API package rather than by direct customer calls.

Because only the INS procedure is documented, developers should not assume any update, delete, or validation routine within this package. All stated procedure behavior is grounded strictly in the ETRM metadata.

Tables Accessed

The package operates against two documented tables, reached through APPS synonyms:

• HR_LOCATION_EXTRA_INFO — The primary table holding user-defined and extensible location attributes. HR_LEI_INS performs insert operations into this table.
• HR_LOCATION_EXTRA_INFO_S — The shadow table associated with HR_LOCATION_EXTRA_INFO. Shadow tables typically preserve the original values of changed columns for audit and date-tracking purposes; an insert through HR_LEI_INS would populate this shadow table in tandem with the base table.

These tables store supplementary location data keyed to a location, and the insert logic is the mechanism by which new extra-info rows become available to querying forms and reports.

Usage Notes

HR_LEI_INS is referenced by the HR_LEI_INS package itself (self-referential, corresponding to the package body) and by HR_LOCATION_EXTRA_INFO_API, which is the primary public caller. This dependency chain confirms its role as a subordinate insert utility rather than a top-level interface. Custom code should invoke HR_LOCATION_EXTRA_INFO_API instead of calling HR_LEI_INS directly, since direct calling bypasses any validation or sequencing performed by the parent API. The package is also listed as depending on HR_LEI_SHD, an internal shared component, and on the STANDARD package for standard PL/SQL constructs. When troubleshooting missing or incorrect location extra information in Oracle EBS 12.1.1 or 12.2.2, HR_LEI_INS is a relevant investigation point for insert failures, particularly where shadow-table inconsistencies arise. Its status is VALID in both 12.1.1 and 12.2.2 environments, though the ETRM extract reflects the 12.2.2 EBS schema.