Search Results ota_off_ins




Overview
Explore in AI Chat

Overview

OTA_OFF_INS is an internal Oracle E-Business Suite PL/SQL package owned by the APPS schema that participates in the Oracle Training Administration (OTA) module's offering-insertion logic. Its role is narrow and technical: it encapsulates the low-level work of setting up the base key context and performing the physical insert of a new row into the offerings tables. It is not an end-user-facing API in the same sense as OTA_OFFERING_API; rather, it functions as a supporting worker that other OTA packages call after the higher-level offering API and the shadow (SHD) record have already accepted the incoming data.

The package is reported as VALID in ETRM for both 12.1.1 and 12.2.2, is classified as API type OTHER, and depends directly on APPS.OTA_OFF_SHD and the SYS.STANDARD package. Its tight dependency set confirms that its responsibility is confined to insertion mechanics rather than validation, workflow, or business-rule processing.

Key Procedures and Functions

ETRM documents three procedures/functions for this package:

  • SET_BASE_KEY_VALUE — establishes the base key value used as the primary identifying key (WHO column / primary key context) for the offering record being inserted. It is invoked before the insert so that the new row receives a consistent, correctly derived key rather than relying on the caller to supply one.
  • INS — performs the actual insertion of the offering record into the underlying offerings tables. It is the operational heart of the package and is responsible for writing the row once the key context has been established.
  • A third documented routine exists, but ETRM does not expose its individual name beyond the listing; treat it as an internal helper within the same insertion path.

No parameter lists are documented, and none should be assumed; callers interact with these routines through the OTA offering creation/upgrade flow rather than documented public signatures.

Tables Accessed

The package operates against two documented tables, reached through APPS synonyms:

  • OTA_OFFERINGS — the base offerings table; the target of the INS procedure.
  • OTA_OFFERINGS_S — the shadow (S) table retained by Oracle for upgrade support and audit/versioning. Rows are mirrored here during insert so the upgrade path can reconcile historical data.

The dependency on OTA_OFF_SHD reflects the same shadow-table architecture: the package must respect the SHD convention when inserting into OTA_OFFERINGS_S.

Usage Notes

OTA_OFF_INS is referenced by three other packages: OTA_CLASSIC_UPGRADE, OTA_OFFERING_API, and OTA_OFFERING_SWI. This confirms it is a subordinate utility. It is invoked indirectly:

  • During the classic upgrade path (OTA_CLASSIC_UPGRADE) when legacy offerings must be inserted into the current tables.
  • From OTA_OFFERING_API when a new offering is created programmatically and the API delegates the physical insert.
  • From OTA_OFFERING_SWI, the server-side workflow/interface layer.

Because it is not exposed through a form or a standard concurrent program, custom code should not call OTA_OFF_INS directly. Developers should use OTA_OFFERING_API instead and allow it to invoke OTA_OFF_INS internally; calling the insert package directly risks bypassing validation and shadow-table consistency.