Search Results hr_amd_bus




Overview
Explore in AI Chat

Overview

APPS.HR_AMD_BUS is an internal row handler package in the Oracle E-Business Suite HRMS module, generated from the HR_AMD business rules repository definition. The suffix "_BUS" identifies it as the business-rules layer of the standard Oracle row-handler triad (_SHD shadow, _BUS business rules, _RHI row handler interface). The package encapsulates all validation logic that must execute before insert, update, or delete operations are permitted against the underlying database table. It is declared with AUTHID CURRENT_USER and carries an access status of "Internal Row Handler Use Only," meaning it is not intended for direct invocation by external consumers. The header comment (dated 2002) confirms the package has remained stable across releases and is shipped unchanged in both 12.1.1 and 12.2.2.

Key Procedures and Functions

The package exposes three documented procedures, each serving as the validation orchestrator for one DML operation:

  • INSERT_VALIDATE — Controls execution of all insert business rules validation. It is a private procedure invoked from the ins procedure of the row handler. Its stated purpose is to run insert-time business rule checks; error handling is only performed if explicitly coded. Developer notes direct that insert rules should call straight procedures or functions and avoid conditional branching.
  • UPDATE_VALIDATE — Controls execution of all update business rules validation. It is called from the upd procedure and mirrors the insert counterpart, accepting a PL/SQL record structure and the effective date context.
  • DELETE_VALIDATE — Controls execution of all delete business rules validation, invoked from the delete path of the row handler prior to allowing removal of a record.

All three accept a PL/SQL record structure and an effective date parameter; the effective date is essential because HRMS operates a date-tracked (datetrack) model requiring validation against the temporal context of the operation.

Tables Accessed

The documented table references, reached through APPS synonyms, are:

  • HR_API_MODULES — Registers the API/row handler module so that hooks and validations are applied consistently within the HR API framework.
  • HR_API_HOOKS — Drives invocation of customer-defined "before" and "after" process hooks attached to the row handler, allowing extensions to be layered onto the delivered validation flow.
  • FND_TERRITORIES — Supplies territory validation data, reflecting the territorial or address-related nature of the HR_AMD entity managed by this row handler.

Usage Notes

HR_AMD_BUS is not called directly from forms, concurrent programs, or custom code. It is invoked exclusively through the row handler interface layer as part of the standard insert, update, and delete transactions. The correct extension point for customers is the HR_API_HOOKS mechanism rather than modification of this package, since it is an Oracle-owned, attribute-generated object and any direct edits will be overwritten during patching. Custom code should call the public row handler API instead, which in turn drives these validation procedures. The package is referenced by three other packages, consistent with its position as a dependent layer in the HRMS row handler stack.