Search Results ota_tfh_api_bus




Overview
Explore in AI Chat

Overview

OTA_TFH_API_SHD is an Oracle E-Business Suite shadow (suffix _SHD) PL/SQL package owned by the APPS schema. It belongs to the Oracle Training Administration (OTA/ETRM) product family and operates within the OTA_TFH (Training Finance Headers) API layer, which manages the records of the OTA_FINANCE_HEADERS table. The "_SHD" suffix denotes the shadow copy that Oracle Workflow and the runtime API infrastructure maintain alongside the primary package. The shadow package carries the same public interface as its base counterpart but is used internally by Workflow to detect changes to the package specification so that out-of-date cached instantiations can be invalidated and recompiled.

Functionally, OTA_TFH_API_SHD provides the low-level DML and row-locking plumbing that the higher-level business rules packages (OTA_TFH_API_BUSINESS_RULES, OTA_TFH_API_BUSINESS_RULES2) and the standard CRUD packages (INS, UPD, DEL) rely upon when manipulating training finance header records. The metadata classifies this package as API classification OTHER and confirms it is a VALID object in the ETRM 12.2.2 environment while also present in 12.1.1.

Key Procedures and Functions

The ETRM metadata documents five procedures and functions within this package:

  • RETURN_API_DML_STATUS — Returns the DML status indicator for the most recent API operation, allowing the calling packages to determine whether an insert, update, or delete was internally successful.
  • CONSTRAINT_ERROR — Handles or raises constraint-related exceptions that occur when the underlying DML against the finance headers violates database constraints.
  • API_UPDATING — Represents the flag/state indicator used to signal that an API update is in progress, supporting re-entrancy and preventing recursive modification of the same record.
  • LCK — Performs the row-level lock on the target finance header record, ensuring that only one session can modify the row before the corresponding DML proceeds.
  • CONVERT_ARGS — Converts or normalizes incoming arguments into the canonical format expected by the finance header DML routines.

These routines form the shared runtime support layer rather than end-user business logic; the true business validation resides in OTA_TFH_API_BUSINESS_RULES and OTA_TFH_API_BUSINESS_RULES2, both of which reference this package.

Tables Accessed

The only documented table referenced through APPS synonyms is OTA_FINANCE_HEADERS. This table stores the training finance header records that track financial and costing information for training events and offerings. The shadow package reads and writes this table indirectly through the DML performed by its sibling API packages; the locking (LCK) and argument-conversion (CONVERT_ARGS) routines, together with the constraint handling routine, all act in support of operations targeting this single table.

Usage Notes

OTA_TFH_API_SHD is not intended for direct invocation by end users, forms, or concurrent programs. It is referenced by eight other packages, including OTA_COST_TRANSFER_TO_GL_PKG, OTA_ILEARNING2, OTA_TFH_API_BUS, the two business rules packages, DEL, INS, and UPD. Custom code should call the mainstream API (for example the INS, UPD, and DEL packages) rather than the shadow package directly. The presence of OTA_TFH_API_SHD in the dependency chain is expected and reflects the Workflow-protected layering maintained by the Oracle EBS runtime.