Search Results ota_lrng_path_member_util




Overview
Explore in AI Chat

Overview

The APPS.OTA_LRNG_PATH_MEMBER_UTIL package is a PL/SQL utility package within the Oracle E-Business Suite (EBS) Oracle Learning Management (OLM) module. Its primary business function is to centralize the logic governing the relationship between learning paths and their constituent members — the courses, offerings, and other learning activities that are assembled into a structured curriculum. The package manages the lifecycle of a learner's enrollment in a learning path member, computes completion and status values, and synchronizes member-level state with its parent learning path enrollment.

The package is classified as a UTIL (utility) API, meaning it exposes reusable procedural building blocks rather than a formal public API contract. It is consumed internally by higher-level APIs such as OTA_LP_MEMBER_ENROLLMENT_API, OTA_DELEGATE_BOOKING_API, and OTA_TDB_DEL, and it operates in the APPS schema at status VALID across both EBS 12.1.1 and 12.2.2.

Key Procedures and Functions

The package exposes fifteen documented procedures and functions, which fall into three functional groups:

Tables Accessed

The package reads and writes the core OLM tables via APPS synonyms. OTA_LEARNING_PATHS, OTA_LEARNING_PATH_MEMBERS, and OTA_LP_ENROLLMENTS store the path definition, its members, and the learner's path-level enrollment. OTA_LP_MEMBER_ENROLLMENTS holds the per-member enrollment rows that this package maintains. OTA_ACTIVITY_VERSIONS, OTA_OFFERINGS, OTA_PERFORMANCES, and OTA_EVENTS provide the schedulable delivery details used in completion calculations. OTA_ATTEMPTS and OTA_BOOKING_STATUS_TYPES supply attempt history and status lookups, while OTA_DELEGATE_BOOKINGS supports delegated learner scenarios. Structural metadata for path sections is drawn from OTA_LP_SECTIONS and OTA_LP_SECTIONS_TL, and category information from OTA_CATEGORY_USAGES. DUAL is used for single-row evaluations. The package also calls HR_API for person-related operations.

Usage Notes

The package is not invoked directly from OLM forms or concurrent programs. It is called internally by the enrollment and delegate booking APIs whenever a learning path member enrollment is created, modified, or completed, and by the Talent Management deletion and update routines. Customizations that must synchronize path-member status, completion dates, or mandatory-course counts should call these procedures rather than update the underlying tables directly, ensuring that status propagation between OTA_LP_ENROLLMENTS and OTA_LP_MEMBER_ENROLLMENTS remains consistent. Because it is a utility package, its signatures are not guaranteed to be stable across patches, and custom code referencing it should be regression-tested during EBS upgrades.