Search Results hr_trn_bus




Overview
Explore in AI Chat

Overview

APPS.HR_TRN_BUS is the business-layer ("BUS") package body of the Oracle Human Resources training module API infrastructure. In the Oracle EBS 12.1.1 and 12.2.2 releases it forms part of the standard HR training (HR_TRN) schema, which governs the definition and maintenance of training events, offerings, enrolled delegates, and related training activity. The package follows the Oracle Application Object Library (AOL) table handler pattern, in which the _BUS package supplies the business-rule validation layer that the corresponding _SHD shared-record type and the underlying DML operations rely upon. It is classified in the ETRM 12.2.2 repository under owner APPS with an API classification of "OTHER," indicating that it is an internal supporting component rather than a fully documented public API. The package header and body were created to centralise and standardise the validation performed whenever a training entity record is inserted, updated, or deleted through the application. Its declared global identifier, g_package, is set to ' hr_trn_bus.' and is prefixed to each procedure name so that runtime tracing records the fully qualified entry point. The $Header line (hrtrnrhi.pkb 120.2, dated 21-SEP-2005) confirms that the code lineage predates 12.1.1 and remains unchanged in the 12.2.x code lines.

Key Procedures and Functions

The ETRM metadata documents three procedures, all of which accept the shared record type hr_trn_shd.g_rec_type as their input parameter. The parameter lists are consistent across the package; no additional arguments are documented.

  • INSERT_VALIDATE — invoked before a new training record is committed. It provides the hook for business-rule verification that must succeed before the insert proceeds. In the delivered 120.2 body the procedure body is effectively empty aside from HR_UTILITY.SET_LOCATION tracing; the validation placeholder is resolved by the customer or by a later patch if instance-specific rules are required.
  • UPDATE_VALIDATE — invoked before an existing training record is modified, applying the same business-rule contract to changed data.
  • DELETE_VALIDATE — invoked before a training record is removed, permitting referential or status checks prior to deletion. As with the other two, the delivered implementation is skeletal and relies on the surrounding handler framework for enforcement.

Each procedure brackets its logic with the standard HR_UTILITY.SET_LOCATION calls at sequence points 5 (entering) and 10 (leaving), consistent with Oracle HRMS tracing conventions.

Tables Accessed

The ETRM metadata records no tables referenced through APPS synonyms for this package. The single data structure consumed by all three procedures is the shared PL/SQL record type hr_trn_shd.g_rec_type, a package-level type defined in the companion HR_TRN_SHD specification. This record mirrors the columns of the underlying training base table and is passed by the table handler without the business package issuing direct SQL. Any physical table access is therefore performed by the table handler layer rather than by HR_TRN_BUS itself.

Usage Notes

HR_TRN_BUS is not intended for direct invocation by end users or by custom code. It is called automatically by the HR training table handler infrastructure, which is invoked in turn from the OTA (Oracle Training Administration) forms and associated concurrent programs. The ETRM repository records that the package is referenced by three other packages, reflecting this layered dependency. Developers extending HR training behaviour should place custom validation logic inside the relevant *_VALIDATE procedure rather than pre- or post-processing around the handler, because the empty delivered bodies exist precisely to support such extensions. Because the package is built on the hr_trn_shd record type, any modification to that type requires recompilation of HR_TRN_BUS. Tracing output from the package is controlled through the standard HR_UTILITY diagnostic facility, and the package name is reported in the form ' hr_trn_bus.' plus the procedure identifier.