Search Results create_lp_enrollment




Overview
Explore in AI Chat

Overview

The APPS.OTA_LP_ENROLLMENT_API package body provides the supported programmatic interface for managing learner enrollment in Learning Paths within Oracle E-Business Suite 12.1.1 and 12.2.2. Learning Paths are structured curricula in Oracle Learning Management (part of Oracle iLearning / OTA modules) that group multiple courses into an ordered or mandatory sequence. This API encapsulates the business logic required to create, modify, and remove enrollment records by exposing a stable, validated set of procedures rather than permitting direct DML against the underlying Learning Management base tables. It is classified as an API in the ETRM metadata, meaning Oracle supports its invocation from custom code, provided the documented parameters and validation semantics are respected. The package also integrates with Oracle Workflow through the WF_ITEMS table, reflecting the fact that Learning Path enrollment frequently triggers notifications and workflow-driven status transitions.

Key Procedures and Functions

The ETRM metadata documents four procedures in this package body:

  • CREATE_LP_ENROLLMENT — Creates a new Learning Path enrollment record for a learner. The procedure accepts an effective date, a validation flag, the learning path identifier, and either a person or contact identifier to designate the learner. It also captures path status, enrollment source, mandatory and completed course counts, target and actual completion dates, creator, business group, and a full set of descriptive flexfield attributes. The line reference in the source excerpt confirms the header signature beginning at line 12.
  • UPDATE_LP_ENROLLMENT — Modifies an existing Learning Path enrollment, allowing changes to status, progress counts, completion dates, and descriptive attributes while preserving the enrollment's identity.
  • DELETE_LP_ENROLLMENT — Removes a Learning Path enrollment record. This is the procedure most commonly referenced in customizations that need to programmatically reverse or withdraw an enrollment, and it is the object associated with the search term delete_lp_enrollment.
  • SUBSCRIBE_TO_LEARNING_PATH — Enrolls a learner into a Learning Path using subscription semantics, typically used when the enrollment is driven by self-service or administrative subscription rather than direct record creation.

Tables Accessed

The package operates across four documented base tables accessed through APPS synonyms:

  • OTA_LEARNING_PATHS — The parent definition of the Learning Path being enrolled into; read to validate the path and its attributes.
  • OTA_LEARNING_PATH_MEMBERS — The constituent courses or sub-paths belonging to a Learning Path; used to derive mandatory course counts and progress expectations.
  • OTA_LP_ENROLLMENTS — The primary transactional table where enrollment records are inserted, updated, or deleted by this API.
  • WF_ITEMS — The Oracle Workflow runtime table, engaged to initiate or manage workflow processes associated with enrollment lifecycle events such as notifications and approvals.

Usage Notes

The API is typically invoked from Oracle Learning Management forms, self-service Learning pages, and subscription-related concurrent processes within the OTA module. It is also referenced by at least five other packages in the ETRM repository, indicating its role as a shared enrollment service layer. Custom implementations should call the procedures with the effective date and business group set appropriately, and pass p_validate = TRUE during testing to exercise validations without committing data. Because DELETE_LP_ENROLLMENT removes enrollment records and may cascade workflow items, it should be invoked only after confirming that dependent progress data and notifications are no longer required.