Search Results hr_trn_ins




Overview
Explore in AI Chat

Overview

APPS.HR_TRN_INS is a server-side PL/SQL package that forms part of the Oracle E-Business Suite Human Resources (HR) infrastructure, specifically the Oracle Human Resources (formerly Oracle Training Administration / OTA) subsystem that manages training and other HR-related transactional data. Within the EBS 12.1.1 and 12.2.2 data model, HR_TRN_INS occupies a low-level, internal role in the HR transactions framework. It is not an end-user facing component, but rather a helper package that supports the insertion of HR transaction records into the core transactions staging and API tables.

The package is registered in the ETRM with the classification OTHER, denoting that it is a supporting utility rather than a formal public API. Its status as VALID indicates the object is compiled and available in the APPS schema. HR_TRN_INS is tightly coupled with the HR_TRANSACTION_API and HR_TRANSACTION_SWI packages, which reference it, suggesting HR_TRN_INS performs the physical insert operations on behalf of those higher-level transaction interfaces.

Key Procedures and Functions

The ETRM documentation identifies four documented procedures/functions, of which the named entries are:

  • INS — The primary insertion routine. It is responsible for writing HR transaction rows into the underlying transaction tables. As the name implies, INS encapsulates the insert logic used by callers such as HR_TRANSACTION_API and HR_TRANSACTION_SWI.
  • SET_BASE_KEY_VALUE — A utility routine that establishes or derives the base key value used to identify the transaction record. This supports the assignment of key identifiers required before insertion into the transaction tables.

The ETRM metadata lists four procedures/functions in total; the additional routines are not individually named in the excerpt provided. None of the parameter lists are documented, and no parameter signatures are asserted here.

Tables Accessed

HR_TRN_INS references the following objects through APPS synonyms:

  • HR_API_TRANSACTIONS — The main HR API transactions table that stores transaction records processed through the HR API framework. HR_TRN_INS inserts rows here, populating the data required for downstream processing.
  • HR_API_TRANSACTIONS_S — The corresponding sequence or secondary/support table associated with HR_API_TRANSACTIONS, typically used to generate unique transaction identifiers that HR_TRN_INS applies before the base record is committed.

At the dependency level, HR_TRN_INS references HR_TRN_SHD (the shadow table associated with its own base table) and the SYS.STANDARD package for standard PL/SQL functionality.

Usage Notes

HR_TRN_INS is an internal package and is not normally invoked directly by end users or by customer-written code. It is called indirectly by the HR transactions framework. The documented dependency list shows that it is referenced by APPS.HR_TRANSACTION_API and APPS.HR_TRANSACTION_SWI, and it also references itself (HR_TRN_INS), indicating recursive or internal re-use within the package.

Typical invocation occurs when an HR transaction is submitted through the HR API layer — for example, when training or HR data changes are posted via forms, concurrent programs, or external integrations that route through HR_TRANSACTION_API. The framework calls HR_TRN_INS to perform the physical insert and key assignment steps. Because it manipulates core HR transaction tables directly, it must be treated as a system-owned, non-supported extension point; customizations should target the documented HR_TRANSACTION_API and HR_TRANSACTION_SWI interfaces instead of HR_TRN_INS. In EBS 12.2.2 the package resides in the APPS schema alongside the standard online patching (EBR) objects, so any reference must resolve through the APPS synonyms.