Search Results get_lp_completion_date

Overview

OTA_LRNG_PATH_MEMBER_UTIL is a PL/SQL utility package body in the Oracle E-Business Suite (EBS) Learning Management (formerly OTA / Oracle Training Administration) module. Its header ($Header: otlpmwrs.pkb 120.5.12020000.4 2013/03/21) confirms it is a shipped, patched component maintained through the 12.1.1 and 12.2.2 release streams. As its API classification (UTIL) implies, the package encapsulates reusable business logic rather than exposing an end-user transaction API. Its central responsibility is to derive and maintain the status of learning path members and their enrollments — determining whether a learner has enrolled, whether an enrollment is valid, and when a learning path, its members, or individual classes are considered complete. These routines form the computational backbone used by the Learning Path setup and enrollment forms, concurrent processes, and by the five other packages that reference this utility.

Key Procedures and Functions

The 15 documented program units fall into three functional groups.

• Enrollment status and validation: GET_ENROLLMENT_STATUS derives the current booking/enrollment status for a learning path member by joining member, enrollment, event, delegate booking, and booking status records. CHK_ENROLLMENT_EXIST and CHK_ENROLLMENT_EXIST-style checks verify whether an enrollment record already exists before a new one is created. GET_LME_STATUS and CALCULATE_LME_STATUS compute and persist the status of a learning path member enrollment. GET_VALID_ENROLL validates that an enrollment is eligible and current.
• Maintenance and propagation: UPDATE_LPE_LME_CHANGE and UPDATE_LME_ENROLL_STATUS_CHG propagate status changes between learning path enrollments, member enrollments, and delegate bookings, keeping the hierarchy synchronized when a learner's booking changes.
• Completion and Talent Management integration: GET_CLASS_COMPLETION_DATE, GET_LPM_COMPLETION_DATE, and GET_LP_COMPLETION_DATE return completion dates at the class, member, and learning path levels respectively — the last being the routine users reach when searching for get_lp_completion_date. CHK_NO_OF_MANDATORY_COURSES evaluates mandatory-course counts. CREATE_TALENT_MGMT_LPM and UPDATE_TALENT_MGMT_LP synchronize learning path data with Oracle Talent Management.

Tables Accessed

The package reads and updates the core Learning Management tables through APPS synonyms. The learning path definition and membership hierarchy is represented by OTA_LEARNING_PATHS, OTA_LEARNING_PATH_MEMBERS, OTA_LP_ENROLLMENTS, OTA_LP_MEMBER_ENROLLMENTS, and OTA_LP_SECTIONS / OTA_LP_SECTIONS_TL. Activity and delivery data come from OTA_ACTIVITY_VERSIONS, OTA_OFFERINGS, OTA_PERFORMANCES, and OTA_EVENTS. Learner-level status is sourced from OTA_DELEGATE_BOOKINGS, OTA_BOOKING_STATUS_TYPES, and OTA_ATTEMPTS. OTA_CATEGORY_USAGES supports categorization lookups, and DUAL is used for single-row computations. Because the package queries and updates enrollment and member status columns, it participates directly in enrollment lifecycle persistence rather than being read-only.

Usage Notes

OTA_LRNG_PATH_MEMBER_UTIL is invoked indirectly rather than by end users. Learning Path setup and enrollment forms in the OTA/OLM responsibility call these routines to validate enrollments, recalculate member status after a booking change, and display completion dates. Concurrent programs that refresh learning path status or perform Talent Management synchronization also depend on the completion-date and status-calculation functions. Five other packages reference this utility, so customizations should call the documented functions instead of duplicating their logic, and should treat the package as a dependent internal component whose behavior may change across patches within 12.1.1 and 12.2.2.