Search Results update_lp_enrollment

Overview

The APPS.OTA_LP_ENROLLMENT_SWI package is a self-service wrapper (SWI) within the Oracle E-Business Suite Learning Management (OTA) module. Its purpose is to expose enrollment operations against a Learning Path to web-based and self-service callers, shielding them from the underlying business API. As reflected in the header comment, each procedure delegates to the corresponding API in ota_lp_enrollment_api — for example, create_lp_enrollment is documented as the self-service wrapper to ota_lp_enrollment_api.create_lp_enrollment.

In the ETRM taxonomy the package carries an API classification of OTHER and is owned by APPS. It is a thin orchestration layer: it accepts already-derived IN parameters, invokes the core API, and returns a status indicator rather than performing its own validation logic. The header explicitly notes that all IN parameters must be appropriately derived by the caller. The package header file identifier (otlpeswi.pkh, version 120.3 dated 2005) indicates this code has been stable across the 11i and R12 releases, and it remains present in 12.1.1 and 12.2.2.

Key Procedures and Functions

The package exposes four documented procedures:

• CREATE_LP_ENROLLMENT — Creates a new enrollment record against a learning path, delegating to ota_lp_enrollment_api.create_lp_enrollment. The documented parameters cover the effective date and validate flag, the learning path and person/contact identifiers, path status and enrollment source codes, mandatory and completed course counts, completion target and actual completion dates, creator, business group, and a set of descriptive flexfield attributes.
• UPDATE_LP_ENROLLMENT — The procedure targeted by the search term update_lp_enrollment. It modifies an existing learning path enrollment through the self-service interface, delegating to the corresponding update routine in ota_lp_enrollment_api. It is the entry point used when a learner's enrollment status, completion figures, or target dates change.
• DELETE_LP_ENROLLMENT — Removes an existing learning path enrollment record, again via the underlying API, and reports outcome through the return status parameter.
• SUBSCRIBE_TO_LEARNING_PATH — Provides the self-service subscription path, enrolling a learner onto a learning path and typically used when the subscription is initiated by the learner rather than by an administrator.

Consistent with the header comments, every procedure returns success or failure through p_return_status after completing.

Tables Accessed

The ETRM metadata records no tables directly referenced via APPS synonyms for this package, which is expected: as a self-service wrapper it owns no SQL of its own. All DML against the learning path enrollment entities is performed by the delegated API (ota_lp_enrollment_api), which writes to the underlying OTA learning path enrollment tables. The wrapper's only interaction with persistent data is transactional, routed through that API.

Usage Notes

The package is documented as Internal Development use only. It is not intended for direct invocation by end users or for ad hoc SQL callers. The metadata records that it is referenced by one other package, confirming it functions as a component within a larger call chain rather than as a standalone entry point.

Typical callers are self-service Learning Management flows — the learner-facing enrollment, update, deletion, and subscription actions rendered through the OTA self-service UI — and it may additionally be invoked by concurrent programs or custom code that requires the self-service wrapper semantics. Developers extending enrollment behavior should prefer calling the core API directly unless the self-service wrapper contract is specifically required, given the restricted access status and the reliance on the caller having derived all IN parameters correctly.