Search Results get_review_data_from_tt

Overview

The APPS.OTA_ENROLL_REVIEW_SS package is a server-side PL/SQL API within the Oracle E-Business Suite OTA (Oracle Training Administration / Learning Management) module. It is declared with AUTHID CURRENT_USER and belongs to the OTHER API classification, indicating it is not a formal public interface but rather an internal helper package. Its principal business purpose is to support the enrollment review and enrollment-processing workflow: capturing data entered by a learner or administrator in the enrollment review pages, materializing that data from a PL/SQL table-type cache, validating and creating enrollments, and invoking the underlying learning APIs that persist bookings and delegate records. In 12.1.1 and 12.2.2 the package continues to expose this behavior unchanged from the historical header revision (otrevwrs.pkh), which suggests a stable, low-churn component of the OTA enrollment stack.

Key Procedures and Functions

The package exposes eleven documented procedures and functions:

• SAVE_ADD_ENROLL_DETAIL — Persists the enrollment detail supplied by the calling UI, including activity, event, version, key flexfield, business group, assignment, organization, and up to twenty descriptive flexfield segments (p_tdb_information1..20). It returns an error message through an OUT NOCOPY parameter.
• GET_ADD_ENR_DTL_DATA_FROM_TT — Retrieves add-enrollment detail rows from a PL/SQL table type (TT) cache, used to stage data between the form and the API layer.
• GET_REVIEW_DATA_FROM_TT — Retrieves review-screen data from the same TT cache for display and confirmation.
• PROCESS_API — Drives the primary processing path, coordinating validation and creation of the enrollment from staged data.
• PROCESS_API2 — The secondary processing entry point, typically invoked for a subsequent pass or an alternate enrollment scenario (for example, when additional cross-charge, delegate, or finance context must be processed after the first pass). It is the procedure referenced by the search term process_api2.
• CREATE_ENROLLMENT — Creates the enrollment record itself.
• CANCEL_ENROLLMENT — Reverses or cancels an existing enrollment.
• VALIDATE_ENROLLMENT — Applies business validation rules before creation or cancellation proceeds.
• CREATE_SEGMENT — Creates the accounting/flexfield segment mappings required for the enrollment.

Tables Accessed

The package reads and writes a focused set of OTA and HR tables through APPS synonyms. Enrollment and event context come from OTA_EVENTS, OTA_ACTIVITY_VERSIONS, OTA_ACTIVITY_VERSIONS_TL, OTA_BOOKING_STATUS_TYPES, and OTA_DELEGATE_BOOKINGS. Financial impact is handled via OTA_FINANCE_HEADERS, OTA_FINANCE_LINES, and OTA_CROSS_CHARGES. Cost allocation and flexfield mapping use OTA_HR_GL_FLEX_MAPS and PAY_COST_ALLOCATION_KEYFLEX. Person and organization context is drawn from PER_ALL_ASSIGNMENTS_F, HR_ALL_ORGANIZATION_UNITS, and FND_USER. Transaction bookkeeping uses HR_API_TRANSACTION_STEPS and HR_API_TRANSACTION_VALUES.

Usage Notes

OTA_ENROLL_REVIEW_SS is invoked primarily by the OTA enrollment review forms in the Self-Service and administrative Learning Management responsibility, and by concurrent programs or custom code that need to create, validate, or cancel enrollments programmatically. It is not referenced by other packages (0 inbound references), so callers invoke it directly rather than through a wrapper. Because it is an OTHER-classified, non-public API, Oracle does not guarantee signature stability across releases; customizations should pin behavior to the specific 12.1.1 or 12.2.2 instance and avoid reliance on undocumented parameter defaults.