Results for “hr_amd_shd”

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

Overview

APPS.HR_AMD_SHD is a shadow (upgrade-support) PL/SQL package body within the Oracle E-Business Suite Human Resources (HR) product family. The "_SHD" suffix denotes a shadow package used during patch application and product upgrade, providing the implementation logic that the corresponding specification, HR_AMD_SHD, exposes to callers. The package name prefix "HR_AMD" indicates it belongs to the Application Module Definition (AMD) area of Oracle HRMS, which manages the metadata describing HR API modules registered in the HR_API_MODULES table. As a shadow package, its primary business function is to support controlled, repeatable modification of HR API module metadata during upgrade or patching cycles, while enforcing the integrity constraints defined on the underlying tables. Because it is an internal, upgrade-oriented object rather than a supported runtime API, it is not intended for direct customer invocation.

Key Procedures and Functions

The documented package exposes four procedures or functions:

• CONSTRAINT_ERROR — Translates Oracle constraint violations raised by the database into user-facing, message-dictionary-based errors. It accepts the name of the violated constraint and maps known constraints on HR_API_MODULES (including HR_API_MODULES_CK1, CK2, CK3, HR_API_MODULES_PK, and HR_API_MODULES_UK1) to specific HRMS messages such as PER_52121_AMD_MOD_TYPE_INV, PER_52122_AMD_DATA_WBG_INV, and PER_52119_AMD_MOD_NAME_NOT_UNQ. It uses HR_UTILITY.SET_MESSAGE, SET_MESSAGE_TOKEN, and RAISE_ERROR to produce consistent error handling.
• API_UPDATING — Supports the update path for API module metadata, encapsulating the logic required to modify records in HR_API_MODULES safely and consistently during upgrade operations.
• LCK — Provides locking behavior for the package, ensuring that concurrent upgrade or patch sessions do not corrupt API module definitions through overlapping modifications.
• CONVERT_ARGS — Handles argument conversion, allowing callers to pass values in one representation while the package standardizes them for storage or comparison against HR_API_MODULES columns.

Tables Accessed

The package references two documented tables via APPS synonyms:

• ALL_CONSTRAINTS — Read to identify constraint definitions, most notably so that CONSTRAINT_ERROR can recognize constraint names and determine the correct message mapping when a violation occurs.
• HR_API_MODULES — The central data store for HR API module definitions. The package reads, updates, and validates rows in this table as part of the upgrade and metadata maintenance cycle, and its constraints drive the error-handling logic in CONSTRAINT_ERROR.

Usage Notes

HR_AMD_SHD is an internal shadow package, typically invoked indirectly by Oracle HRMS upgrade drivers, patch routines, and other HR packages rather than through Oracle Forms or standard concurrent programs. ETRM metadata shows it is referenced by four other packages, confirming its role as a shared internal utility during module-definition maintenance. Custom code should not call this package directly; doing so bypasses documented API boundaries and can conflict with upgrade sequencing. Administrators investigating errors such as PER_52119, PER_52121, or PER_52122 during an HRMS patch or upgrade should treat HR_AMD_SHD as the origin of the standardized error translation rather than a defect site.