Search Results get_booking_status




Overview
Explore in AI Chat

Overview

APPS.OTA_TRAINING_RECORD is a PL/SQL package body belonging to the Oracle E-Business Suite OTA (Oracle Training Administration) schema, the module responsible for the training and certification lifecycle within Oracle Learning Management. The package exposes query-oriented APIs that return training event and certification information in a structured, pre-formatted manner suitable for downstream consumers. Rather than maintaining transactional data itself, the package serves as a read-side convenience layer that consolidates data scattered across the OTA and PER table families into reusable result sets.

Its API classification is documented as OTHER, indicating it is not one of the formally published public APIs such as OTA_DELEGATE_BOOKINGS or OTA_EVENT_API, but is instead an internal helper package consumed by other OTA components and report/query logic. It is natively shipped with Oracle EBS 12.1.1 and 12.2.2 and is not registered as referenced by other documented packages, which is consistent with its role as a leaf-level data retrieval utility.

Key Procedures and Functions

The ETRM metadata documents two public program units within the package:

  • GET_CERTIFICATION_DETAILS — Retrieves certification definition and member information. Given a certification identifier, it returns the descriptive details of the certification together with associated competency, member, and enrollment attributes. This is the entry point that satisfies the common search term "get_certification_details" encountered by developers browsing the OTA data dictionary.
  • GET_TRAINING_DETAILS — Returns training activity and offering information, joining activity-version data to catalog descriptions, competencies, and organizational context. It complements GET_CERTIFICATION_DETAILS for training records that are not certification-based.

The package body source also contains private helpers, notably GET_EVENTS returning a NOCOPY event_tabletype collection via an explicit cursor over OTA_EVENTS, and IS_REQUIRED performing membership testing against a query_options associative array. These routines support the two documented entry points and are not exported for general use. Parameter lists are not reproduced here, consistent with documented metadata.

Tables Accessed

The package queries a broad set of OTA, PER, and HR tables through APPS synonyms. Certification-related reads touch OTA_CERTIFICATIONS_B and OTA_CERTIFICATIONS_TL (base and translated certification attributes), OTA_CERTIFICATION_MEMBERS, OTA_CERT_ENROLLMENTS, OTA_CERT_MBR_ENROLLMENTS, and OTA_CERT_PRD_ENROLLMENTS, which link certifications to members, delegates, and awarded periods. Training and event detail is sourced from OTA_EVENTS, OTA_ACTIVITY_VERSIONS and OTA_ACTIVITY_VERSIONS_TL, plus OTA_BOOKING_STATUS_TYPES_TL for status meaning and OTA_DELEGATE_BOOKINGS for booking context.

Competency and organizational data are resolved via PER_COMPETENCES_TL, PER_COMPETENCE_ELEMENTS, HR_ALL_ORGANIZATION_UNITS, and HR_ALL_ORGANIZATION_UNITS_TL. All access is read-only in the documented excerpts; no INSERT, UPDATE, or DELETE statements appear in the metadata.

Usage Notes

OTA_TRAINING_RECORD is typically invoked from OTA forms, Oracle Learning Management self-service pages, and custom PL/SQL that requires a denormalized view of training or certification records without reimplementing the underlying joins. Because it is classified as OTHER and is not referenced by any documented public API, extensions should call it only after validating the exact signature against the shipped package specification in the target release, as behavior can differ between 12.1.1 and 12.2.2. Custom concurrent programs and reports that need certification attributes for a given person or certification ID may use GET_CERTIFICATION_DETAILS directly, while GET_TRAINING_DETAILS serves equivalent reporting needs for non-certification training. Standard support practice is to avoid modifying the package and to wrap calls in custom code with appropriate exception handling.