Search Results hr_api_transactions_s

Overview

APPS.HR_TRN_INS is a PL/SQL package body in the Oracle E-Business Suite APPS schema, classified under the OTHER API category. It belongs to the Oracle Human Resources (HR) module and forms part of the broader Transaction (TRN) framework that underpins the Oracle HRMS business object layer. Its role is to support the insertion, initialization, and transactional integrity of records managed within the HR Transaction architecture, working in close coordination with the HR_TRN_BUS (business logic), HR_TRN_SHD (shadow), and HR_API (public APIs) packages. The package is recorded as VALID in the ETRM metadata for releases 12.1.1 and 12.2.2, confirming it is an active, compiled component maintained across those environments. It is not referenced by any other database object, but it does reference several, making it a consumer-level package used internally during HR transaction processing rather than a shared public entry point.

Key Procedures and Functions

The package exposes four documented procedures/functions. The most notable are:

• SET_BASE_KEY_VALUE — Establishes the base key value used to identify and align the transaction record being processed. This procedure is responsible for initializing the key context so that HR transaction rows are correctly scoped before insertion logic executes.
• INS (Insert) — The primary insert routine within this package, responsible for creating new transaction records in the HR transaction tables. It coordinates with the underlying business logic and API layers to enforce HRMS transaction rules during the insertion process.

The remaining two procedures/functions (per the documented count of four) serve supplementary roles in the insert path, handling key-value setup and related preparatory transaction bookkeeping. The naming convention (HR_TRN_INS) indicates this is the insertion-side component of the HR Transaction (TRN) subsystem, complementing the business and shadow packages it depends on. Parameter lists are not enumerated in the ETRM metadata and should not be assumed; the documented contract is the procedure names and their functional purpose.

Tables Accessed

The package references the following APPS synonym-backed tables:

• HR_API_TRANSACTIONS — The primary transaction table holding header records of HR API transactions. HR_TRN_INS writes into and reads from this table when inserting new transaction rows.
• HR_API_TRANSACTIONS_S — The sequence/identifier-supporting table associated with HR_API_TRANSACTIONS. This is the object most likely associated with the user's search term hr_api_transactions_s. It provides surrogate key or sequence values used to uniquely identify each transaction.

Additionally, the package draws on FND_MESSAGE for message handling, HR_API for API infrastructure, HR_TRN_BUS for business rules, HR_TRN_SHD for shadow-record management, and HR_UTILITY for shared HR helper routines. DUAL and STANDARD are used for basic SQL and PL/SQL constructs.

Usage Notes

HR_TRN_INS is an internal HRMS transaction component and is not typically invoked directly by end users. It is executed indirectly through the HR transaction framework when forms, concurrent programs, or PL/SQL APIs perform insert operations on HR API transactions. The package's exclusive dependencies (it is not referenced by other database objects) suggest it is called dynamically or from within the HR_TRN runtime rather than through static dependency chains. Customizations should avoid calling HR_TRN_INS directly; developers are advised to use the supported public HR APIs in HR_API or the DML/API interfaces in HR_TRN_BUS instead, allowing HR_TRN_INS to remain an encapsulated implementation detail of the transaction insertion layer.