Search Results learner_unenrollment




Overview
Explore in AI Chat

Overview

OTA_LRNR_ENROLL_UNENROLL_WF is an Oracle EBS Applications (APPS) PL/SQL package that provides a workflow-oriented integration layer for Oracle Learning Management (OTM) certification and learner enrollment events. Declared AUTHID CURRENT_USER, the package executes under the privileges of the invoking schema and exists specifically to drive Oracle Workflow process activities when enrollment and unenrollment transactions occur. It does not itself own the learner enrollment business logic; rather, it is a thin orchestration wrapper invoked by the enrollment APIs and utilities, translating a domain event into the appropriate workflow process invocation.

The package's header comment (version 120.1.12000000.1) explicitly records that it is "called from ota_Cert_enrollments_api and ota_cpe_util." This establishes the package's role as a subordinate component in the OTM enrollment architecture: the primary APIs own validation and persistence, while this package routes the resulting state change into Oracle Workflow for notification and process execution.

Key Procedures and Functions

The ETRM metadata documents three public procedures, each corresponding to a distinct enrollment lifecycle event:

  • CERT_ENROLLMENT — Handles the workflow-side processing of a certification enrollment. It accepts a workflow process name, an item type, a person identifier, and a certification identifier, and is invoked when a learner is enrolled onto a certification defined in OTA_CERTIFICATIONS_B.
  • LEARNER_ENROLLMENT — Processes a learner enrollment against a learning event. It receives a workflow process name, item type, person identifier, event identifier, and booking identifier. The booking reference ties the workflow activity to the specific enrollment/booking record created for the learner.
  • LEARNER_UNENROLLMENT — The counterpart to LEARNER_ENROLLMENT, invoked when a learner is removed from a learning event. It accepts the workflow process name, item type, person identifier, and event identifier, and initiates the unenrollment workflow so that downstream notifications and status updates are dispatched. This is the procedure most directly associated with the "learner_unenrollment" search term.

No parameter lists are reproduced here beyond those documented; callers must reference the package specification for exact signature and datatype details.

Tables Accessed

The documented table references reflect three categories of access. Enrollment domain tables — OTA_CERTIFICATIONS_B, OTA_CERTIFICATIONS_TL, OTA_EVENTS, OTA_EVENTS_TL, OTA_OFFERINGS, and OTA_ACTIVITY_VERSIONS / OTA_ACTIVITY_VERSIONS_TL — supply the certification, event, offering, and activity-version context used to resolve the workflow process and item data. Workflow infrastructure tables — WF_ITEMS, WF_PROCESS_ACTIVITIES, WF_ACTIVITIES, and HR_WORKFLOW_ITEM_KEY_S — are consulted to instantiate and route workflow items. Descriptive and reference tables — OTA_BOOKING_STATUS_TYPES_TL, OTA_CATEGORY_USAGES_TL, FND_TIMEZONES_TL, and HR_LOCATIONS_ALL — provide translated status types, category usage definitions, timezone information, and location details needed for notification content. All are referenced through APPS synonyms, consistent with the AUTHID CURRENT_USER declaration.

Usage Notes

Because this package is documented as invoked from ota_Cert_enrollments_api and ota_cpe_util, standard practice is to rely on those APIs rather than calling the procedures directly. Customizations that require workflow notification on enrollment or unenrollment should likewise be implemented by extending or subscribing to the workflow processes triggered through these procedures, not by bypassing the APIs. The package is not exposed as a concurrent program; it executes within the transaction initiated by the calling API, and its success is therefore coupled to that transaction's outcome. When diagnosing missing unenrollment notifications, the LEARNER_UNENROLLMENT procedure and its workflow item creation are the correct starting point for investigation.