Search Results hr_lei_upd




Overview
Explore in AI Chat

Overview

HR_LEI_SHD is a shared utility package in the APPS schema that supports the HR_LEI family of packages, which manage Legal Entity information within Oracle E-Business Suite. The package is registered as VALID in both Oracle EBS 12.1.1 and 12.2.2 and is classified under ETRM as an "OTHER" API rather than a public business API. Its role is to provide common internal services — argument conversion, locking, constraint validation, and update auditing — that the other HR_LEI packages call rather than duplicating. The "_SHD" suffix conventionally denotes a shared or helper module. Because HR_LEI_SHD is referenced by HR_LEI_BUS, HR_LEI_DEL, HR_LEI_FLEX, HR_LEI_FLEX_DDF, HR_LEI_INS, HR_LEI_UPD, and PER_PQH_SHR, it functions as a cross-cutting support layer for legal entity create, update, delete, and flexfield operations.

Key Procedures and Functions

ETRM documents four procedures or functions within HR_LEI_SHD:

  • CONSTRAINT_ERROR — Raises or handles constraint violation errors encountered during legal entity processing, allowing calling packages to fail with a consistent error message.
  • API_UPDATING — Indicates or manages the API-update context so that downstream logic can distinguish changes made through the API versus direct table manipulation, supporting audit and validation behavior.
  • LCK — Provides locking logic, typically to serialize concurrent operations on legal entity records and prevent conflicting updates.
  • CONVERT_ARGS — Converts or normalizes arguments passed between the HR_LEI packages, mapping caller-supplied values into the internal representations expected by the shared processing routines.

Parameter lists are not documented in the ETRM extract and are therefore not reproduced here.

Tables Accessed

ETRM records two table dependencies via APPS synonyms:

  • ALL_CONSTRAINTS — The data dictionary view used to inspect constraint definitions, consistent with the CONSTRAINT_ERROR routine's need to identify which constraint was violated.
  • HR_LOCATION_EXTRA_INFO — The HR location extra information table, which stores additional attributes for locations associated with legal entities.

The package also depends on the SYS STANDARD package, the PUBLIC synonym layer, and ALL_CONSTRAINTS at the PUBLIC level. These accesses are read-oriented and support validation and metadata lookups rather than primary data maintenance, which is handled by HR_LEI_INS, HR_LEI_UPD, and HR_LEI_DEL.

Usage Notes

HR_LEI_SHD is not intended to be invoked directly by end users, forms, or concurrent programs. It is an internal helper invoked by the seven dependent HR_LEI packages: HR_LEI_BUS (business logic), HR_LEI_DEL (delete), HR_LEI_FLEX and HR_LEI_FLEX_DDF (flexfield handling), HR_LEI_INS (insert), HR_LEI_UPD (update), and PER_PQH_SHR. The user's search term "hr_lei_del" reflects this relationship: HR_LEI_DEL depends on HR_LEI_SHD for constraint checking, locking, and argument conversion during legal entity deletion.

Because this is a private shared package, customizations should not call it directly; instead, use the public HR_LEI business APIs. Any modification to HR_LEI_SHD risks invalidating all seven dependent packages and should be performed only with a full dependency impact assessment and regression testing across legal entity and location flows.