Results for “hr_loc_shd”

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

Overview

APPS.HR_LOC_SHD is a PL/SQL package in the Oracle E-Business Suite Applications schema that forms part of the seed data and shadow (SHD) infrastructure supporting the HR_LOCATIONS business object. Its principal role is to manage the shadow-table records that mirror the base HR_LOCATIONS_ALL table, providing the DML state and locale-conversion machinery used by the location API layer. In Oracle EBS 12.1.1 and 12.2.2, the SHD packages exist to detect and reconcile changes made to the underlying entity by comparing shadowed rows against live rows, and to expose that state to higher-level APIs. HR_LOC_SHD therefore acts as a supporting utility beneath the HR_LOCATIONS API stack rather than as a standalone business API.

Key Procedures and Functions

The ETRM metadata documents six procedures and functions within HR_LOC_SHD. Their names indicate the following responsibilities:

• RETURN_API_DML_STATUS — Returns the DML status indicator for the API invocation, allowing callers to determine whether insert, update, or delete activity was performed against the location records.
• CONSTRAINT_ERROR — Handles or raises constraint-related errors encountered while processing location shadow data, providing a controlled error path for integrity violations.
• API_UPDATING — Signals or tracks whether a location API update is in progress, used to gate behaviour that depends on an active update operation.
• LCK — Performs the locking routine required to serialise access to the location shadow records during DML, preventing concurrent conflicts.
• CONVERT_ARGS — Converts positional arguments passed into the location API into the internal representation expected by the shadow-processing logic.
• DERIVE_LOCALE — Derives the locale value associated with a location record, supporting the multilingual and territory-related attributes of HR_LOCATIONS_ALL.

Tables Accessed

The metadata identifies three referenced objects, accessed through APPS synonyms:

• HR_LOCATIONS_ALL — The base HR location entity; HR_LOC_SHD reads and reconciles this table to maintain shadow consistency.
• ALL_CONSTRAINTS — Consumed by the constraint-handling logic to identify and validate constraint definitions relevant to the location object.
• DBMS_DESCRIBE — Used, together with the SYS.STANDARD package and MDSYS.SDO_GEOMETRY type in the dependency list, to inspect and convert API argument metadata during call preparation.

Usage Notes

HR_LOC_SHD is not typically invoked directly by end users or forms. It is referenced by a well-defined set of callers in the HR location stack, including HR_LOCATIONS_ALL_OVN, HR_LOCATION_API, HR_LOC_BUS, HR_LOC_DEL, HR_LOC_INS, HR_LOC_UPD, and PER_PQH_SHR. These packages call into HR_LOC_SHD to obtain DML status, lock shadow records, convert API arguments, and derive locale values as part of standard location processing. Consequently, the package is exercised whenever a location is created, modified, or deleted through the HR_LOCATIONS API or its related business logic, including concurrent-program and setup-driven maintenance. Customisations should avoid calling HR_LOC_SHD procedures in isolation; the supported integration point remains the HR_LOCATIONS API layer, which invokes HR_LOC_SHD on the caller's behalf.