Search Results create_enroll_wf_process

Overview

OTA_CANCEL_TRAINING_SS is a public PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM API registry as OTHER. It belongs to the Oracle Training Administration (OTA) product family, which underpins the Learning Management functionality within Oracle HRMS and Oracle iLearning. The package encapsulates server-side logic that supports the cancellation of training enrollments and the initiation of related workflow processes. Its name reflects a "SS" (server-side) implementation pattern common in OTA, where thin client forms layers delegate business logic to packages rather than embedding it directly in form triggers.

The package is defined with AUTHID CURRENT_USER, meaning that its SQL statements execute with the privileges of the calling user rather than the package owner. This design choice places responsibility on the invoking application or user to hold appropriate permissions on the underlying tables and to observe the correct operating context. The header comments date the source to 2002, indicating the package has been carried forward through successive EBS releases, including 12.1.1 and 12.2.2.

Key Procedures and Functions

The package exposes three documented procedures:

• CREATE_ENROLL_WF_PROCESS — Sets the item attributes used by Oracle Workflow when a training enrollment workflow process is created. It accepts the workflow item key and item type together with person, event, and course date context, and returns a status and message data to the caller.
• CANCEL_ENROLLMENT — The central procedure associated with the search term "cancel_enrollment." It is invoked from the View Enrollment Details screen when the user presses Submit, and it processes the cancellation of the enrollment identifier passed to it. This is the primary entry point for programmatic cancellation of a learner's booking.
• GET_BOOKING_STATUS_COMMENTS — Retrieves descriptive comments associated with booking statuses, supporting the display and audit of enrollment status changes.

No parameter lists are reproduced here beyond those confirmed in the documented source; callers should consult the package specification for exact signatures.

Tables Accessed

The package references the following tables through APPS synonyms:

• OTA_EVENTS, OTA_ACTIVITY_VERSIONS, OTA_ACTIVITY_VERSIONS_TL — Event and version definitions supplying course titles, start and end dates, and translated version names.
• OTA_BOOKING_STATUS_HISTORIES — Records status transitions resulting from cancellations.
• OTA_DELEGATE_BOOKINGS — Delegate-level booking records affected when an enrollment is cancelled.
• OTA_FINANCE_HEADERS and OTA_FINANCE_LINES — Financial entries tied to training bookings, relevant where cancellation triggers refund or charge adjustment logic.
• WF_ITEMS — Workflow item context for the enrollment workflow process.
• FND_USER — The application user context used for auditing.
• PER_ALL_PEOPLE_F and PER_ALL_ASSIGNMENTS_F — Person and assignment details used to resolve the learner's identity and organizational placement.

Usage Notes

OTA_CANCEL_TRAINING_SS is typically invoked from the Oracle Training Administration forms layer, specifically the View Enrollment Details screen, when a user submits a cancellation. The workflow-oriented procedure may also be called during enrollment workflow setup, where item attributes must be populated before the workflow engine can proceed.

The package is not referenced by any other documented packages, so its callers are expected to be forms, concurrent programs, or custom extensions rather than other PL/SQL APIs. Because it is declared AUTHID CURRENT_USER, custom code calling CANCEL_ENROLLMENT or CREATE_ENROLL_WF_PROCESS must ensure the executing schema has the necessary direct privileges on the referenced OTA, WF, FND, and PER tables. In 12.1.1 and 12.2.2 environments, the package remains a viable integration point for automating enrollment cancellation, but developers should verify that the caller supplies valid workflow item context and that downstream finance and history records are reconciled after invocation.