Search Results hr_api_modules_s

Overview

The APPS.HR_AMD_INS package body is a private implementation unit within the Oracle Human Resources (HR) module of Oracle E-Business Suite, valid in releases 12.1.1 and 12.2.2. Its name identifies it as part of the Application Module Definition (AMD) family, a set of server-side constructs that manage the registration and configuration of HR API modules. The package provides the insertion-side logic used when a new API module record must be created in the HR API metadata repository, typically as part of a data-seeding, patching, or setup activity rather than routine transactional processing.

The package is classified under the ETRM "OTHER" API classification, indicating that it is not a published public API intended for general customer extension, but an internal support unit invoked by Oracle configuration and installation logic. It is not referenced by any other database object, confirming its role as a terminal, self-contained implementation detail within the AMD layer.

Key Procedures and Functions

The ETRM metadata documents one callable program unit and one subprogram name:

• INS — The insertion routine. It performs the core work of the package: creating a new row representing an HR API module definition. This is the package's principal entry point.
• HR_AMD_INS — The package body itself, listed among the dependent objects and referenced internally as the containing unit for the INS program. In practice this reflects the package-level name resolving to its own body for internal calls.

Because the ETRM documentation does not expose formal parameter lists for these units, no signature detail is asserted here. The single documented procedure, INS, is understood to encapsulate the insertion logic required to register an API module.

Tables Accessed

Two base tables are referenced via APPS synonyms:

• HR_API_MODULES — The primary HR API module registry table. This is the principal target of the insertion logic, holding the module definitions that govern API behavior.
• HR_API_MODULES_S — The companion sequence or shadow table associated with HR_API_MODULES, used to generate or maintain key values for new module records. The user query "hr_api_modules_s" corresponds directly to this object.

Additional dependencies include the supporting HR packages HR_AMD_BUS, HR_AMD_SHD, HR_API, and HR_UTILITY, plus the SYS objects DUAL and the STANDARD package. These supply shared business logic, shadow-table maintenance, API utility routines, and standard PL/SQL functionality used during insertion.

Usage Notes

HR_AMD_INS is internal infrastructure. It is typically invoked during installation, upgrade, or patch application when HR API module metadata must be registered, and by related AMD packages such as HR_AMD_BUS and HR_AMD_SHD that orchestrate module definition activity. Customer-facing forms and concurrent programs generally do not call it directly; custom code should prefer supported public HR APIs rather than this OTHER-classified unit. Its dependence on HR_API_MODULES_S means callers must ensure naming-sequence integrity is preserved, and direct invocation outside the intended setup context risks inconsistent API module registration.