Search Results hr_abm_bus

Overview

HR_ABM_BUS is a PL/SQL business (BUS) layer package owned by the APPS schema in Oracle E-Business Suite releases 12.1.1 and 12.2.2. Its name derives from the "ABM" functional area, which in Oracle HRMS relates to absence management processing. The package occupies the middle tier of the standard Oracle EBS three-layer architecture, sitting above the table-handler (TH) layer that performs direct DML and below the user interface, concurrent program, and public API layers.

The package is documented with an API classification of OTHER, indicating that it is not exposed as a formal public API and is intended for internal use within the HRMS absence management code path. In the ETRM repository it is recorded with a VALID status and one documented program unit, INSERT_VALIDATE. The dependency metadata confirms that HR_ABM_BUS references the shadow package HR_ABM_SHD and is itself referenced by HR_ABM_INS, establishing a clear relationship chain: HR_ABM_INS invokes HR_ABM_BUS for business validation, and HR_ABM_BUS in turn calls HR_ABM_SHD for the underlying data operations.

Key Procedures and Functions

The ETRM documentation records a single program unit within this package: INSERT_VALIDATE. The name indicates a validation routine executed as part of an insert operation, and its placement in a BUS-layer package is consistent with that role. In the standard HRMS layering convention, insert processing proceeds from the interface layer through the business layer, where business rules are enforced, before the table handler performs the physical insert. INSERT_VALIDATE therefore represents the point at which business rule checks are applied to the record being created.

The documented metadata does not include the parameter list for INSERT_VALIDATE; the signature should be verified against the actual package specification in the target environment before the routine is called from custom code. No other procedures or functions are recorded in the ETRM extract, though the package body may contain additional private helper units that are not separately documented.

Tables Accessed

The ETRM metadata for HR_ABM_BUS does not enumerate specific base tables accessed through APPS synonyms. Instead, all data access is routed through the shadow package HR_ABM_SHD, which is the documented dependency of HR_ABM_BUS. This is a common Oracle HRMS design pattern: the shadow package encapsulates the DML and query logic, allowing the business package to focus on validation and rule enforcement while remaining decoupled from the physical table structures.

Because table-level detail is not exposed in the metadata, the precise set of absence management tables read or written by INSERT_VALIDATE cannot be stated from documentation alone. The HR_ABM_SHD dependency should be inspected to identify the underlying objects.

Usage Notes

HR_ABM_BUS is an internal package and is not intended for direct invocation by external or customer-written code. It is referenced by exactly one other package in the documented dependency set: HR_ABM_INS, which is the insertion-handling package for the same functional area. The typical invocation path is therefore through HR_ABM_INS rather than by calling HR_ABM_BUS directly.

• Business-layer packages such as this one are normally invoked from Oracle Forms-based HRMS windows, from concurrent programs that process absence or assignment records, or from other HRMS packages operating within the same call stack.
• Because the package is classified as OTHER rather than as a public API, Oracle does not guarantee the stability of its signature or behavior across patches or upgrades. Customizations should avoid direct dependencies on HR_ABM_BUS.
• Validation failures raised by INSERT_VALIDATE are typically surfaced to the calling layer as application errors, which the interface layer converts into user-visible messages.
• Any analysis of this package should begin with HR_ABM_SHD, since that dependency holds the table-level logic on which HR_ABM_BUS depends.