Search Results ota_tdb_api_ins2




Overview
Explore in AI Chat

Overview

OTA_TDB_API_INS2 is a public PL/SQL package body owned by the APPS schema in Oracle E-Business Suite. It forms part of the Oracle Learning Management (OTM) module within Oracle iLearning and the wider Oracle Human Resources (HRMS) family. The package name follows the OTA_TDB naming convention, where "TDB" refers to the Training and Development Booking schema objects that underpin learner enrollment, class booking, and event registration processing. OTA_TDB_API_INS2 provides the application programming interface layer responsible for inserting and instantiating enrollment records against Oracle Learning Management booking structures. It abstracts the underlying persistency and validation logic from the forms and concurrent programs that consume it, ensuring that enrollment data is created consistently and in accordance with OTM business rules. The object is documented as VALID in the ETRM repository for both Oracle EBS 12.1.1 and 12.2.2, and its API classification is OTHER, indicating it is a supporting rather than fully public interface.

Key Procedures and Functions

The ETRM metadata documents a single exposed program unit:

  • CREATE_ENROLLMENT — The principal entry point of the package. It is responsible for the creation of an enrollment record for a learner against a given offering, class, or event. In practice it validates the incoming learner and training event context, applies enrollment defaults derived from the booking setup, and delegates the actual insert into the booking tables to the underlying business logic. Because the package is an "INS" variant (insert-oriented rather than update-oriented), the procedure is invoked whenever a new enrollment must be persisted rather than an existing one amended. The ETRM records do not expose a parameter list, and the exact signature should be obtained by describing the package in the target database rather than inferred from documentation.

Tables Accessed

The documented dependency list shows that OTA_TDB_API_INS2 does not directly reference base tables through hard-coded DML; instead it operates through sibling package APIs and the APPS synonym layer. Its declared dependencies include OTA_TDB_BUS, OTA_DELEGATE_BOOKING_API, and OTA_EVT_BUS2. OTA_TDB_BUS is the business-service package that encapsulates the insert, update, and delete operations on the OTM booking and enrollment tables, so CREATE_ENROLLMENT effectively drives writes into those structures through it. OTA_DELEGATE_BOOKING_API handles delegated or proxy booking scenarios, which are relevant when one person books training on behalf of another. OTA_EVT_BUS2 is the event business service used to resolve and validate the training event against which the enrollment is being created. FND_MESSAGE is referenced for message retrieval and error propagation, while HR_UTILITY supplies shared HRMS utility routines. The package therefore reads and writes enrollment data indirectly, preserving the layered architecture of OTM.

Usage Notes

OTA_TDB_API_INS2 is not referenced by any database object, which identifies it as a top-level consumer rather than a shared internal routine. It is typically invoked from Oracle Learning Management forms during self-service or administrator enrollment, from concurrent programs that bulk-load or import learner bookings, and from custom PL/SQL extensions that need to create enrollments programmatically. Because the package is owned by APPS and is not referenced by other database objects, it can be modified with relatively low risk to dependent code; however, any change to CREATE_ENROLLMENT must preserve the enrollment validation and messaging behavior expected by the calling forms. When implementing customizations, developers should call the documented procedure rather than inserting directly into the underlying OTM booking tables, so that event capacity checks, waitlist logic, and audit columns continue to be enforced.