Search Results get_jump_lo_id

Overview

APPS.OTA_LO_UTILITY is a VALID PL/SQL package in the Oracle E-Business Suite Applications (APPS) schema that supports the Oracle Learning Management (OTL) module, part of the Oracle iLearning and Training Administration footprint. In the context of Oracle EBS 12.1.1 and 12.2.2, this package delivers utility-level business logic for navigating, rendering, and enforcing access rules over learning objects, performances, events, and certification enrollments. It is classified as API type OTHER in the ETRM repository, indicating it is an internal helper package rather than a public web-service or loader API.

The package encapsulates the rules that determine whether a learner may attempt a learning object or event, how the "play" and "next/previous" controls behave within a learning path, and how statuses such as performance lesson status and enrollment status are derived. It is a foundation component used across the learner-facing UI rather than a standalone business process.

Key Procedures and Functions

The ETRM documentation records 54 procedures and functions. Representative members include:

• Status and timing: SET_PERFORMANCE_LESSON_STATUS and SET_PERFORMANCE_TIME persist lesson-level progress; GET_WAIT_DURATION_FOR_TEST and GET_WAIT_DURATION_FOR_LO return timing constraints applied to tests and learning objects.
• Navigation within a learning path: GET_PREVIOUS_EVENT_LO_ID, GET_NEXT_EVENT_LO_ID, GET_PREVIOUS_LO_ID, GET_NEXT_LO_ID, GET_FIRST_LO_ID, GET_MOST_RECENT_LO_ID, and GET_JUMP_LO_ID resolve relative position identifiers in the sequence of learning objects.
• Access control: USER_CAN_ATTEMPT_EVENT, USER_CAN_ATTEMPT_LO, and USER_CAN_ATTEMPT_CERT evaluate whether a given user is permitted to attempt an event, learning object, or certification.
• Presentation helpers: GET_PLAY_BUTTON and GET_PLAY_BUTTON_FOR_TEST determine the appropriate launch control for a learning object or test; GET_LO_TITLE_FOR_TREE returns display titles for the learning-object tree; GET_LO_TYPE returns the object's classification.
• Structural and enrollment helpers: ROOT_FOLDER_EXISTS validates the presence of the root folder in the catalog hierarchy; GET_ENROLL_LO_STATUS derives the enrollment status of a learning object.

Parameter lists are not documented in the ETRM extract and are intentionally omitted here.

Tables Accessed

The package reads and writes across the OTA learning tables via APPS synonyms:

• Enrollment and progress: OTA_ATTEMPTS, OTA_CERT_ENROLLMENTS, OTA_CERT_MBR_ENROLLMENTS, OTA_CERT_PRD_ENROLLMENTS, OTA_LP_MEMBER_ENROLLMENTS store learner attempt and enrollment state.
• Catalog and delivery: OTA_LEARNING_OBJECTS, OTA_EVENTS, OTA_PERFORMANCES, OTA_TESTS, OTA_CATEGORY_USAGES define the content and scheduling structure.
• Supporting: OTA_BOOKING_STATUS_TYPES, OTA_DELEGATE_BOOKINGS, OTA_EVALUATIONS, FND_USER, and FND_LANGUAGES (for multilingual display).

These accesses explain the package's dual role: enforcing access rules (user, enrollment, attempt history) and supplying presentation and navigation data.

Usage Notes

OTA_LO_UTILITY is reference-heavy: it calls HR_API and OTA_GENERAL, and is itself referenced by the OTA_TRAINING_RECORD package and the OTFV_ENROLLED_EVENTS view, confirming its role in training-record reporting and the enrolled-events query. It is typically invoked indirectly by the OTL learner UI and by internal APIs rather than through a dedicated concurrent program. Customizations should not modify this package; Oracle does not publish it as a supported public API, and its procedures are subject to change between 12.1.1 and 12.2.2. Direct calls from custom code should be avoided in favour of supported OTL APIs.