Search Results create_enrollments

Overview

APPS.OTA_MANDATORY_ENROLL_UTIL is a PL/SQL utility package within the Oracle E-Business Suite Learning Management module (OTA schema). It serves as the core processing engine for mandatory enrollment and automatic certification subscription workflows. The package evaluates learner eligibility against mandatory training requirements, generates enrollment requests, creates class and certification enrollments, and dispatches notifications to learners and class owners. It is classified as a UTIL package and resides in the APPS schema with VALID status in both 12.1.1 and 12.2.2. All 21 documented procedures and functions are public within the package specification, and the package is referenced by no other packages, indicating it is designed to be invoked directly by concurrent programs, forms, or workflow activities rather than consumed as a shared API layer.

Key Procedures and Functions

The documented procedures fall into several functional groups:

• Enrollment eligibility: LEARNER_CAN_ENROLL_IN_CLASS, LEARNER_CAN_ENROLL_IN_CERT, LEARNER_BELONGS_TO_CHILD_ORG, LEARNER_IS_NOTSELECTED_INCLASS, LRN_IS_NOTSELECTED_INCLASS_MUL, and LEARNER_IS_NOTSELECTED_INCERT validate whether a learner may be enrolled or is not already selected, including multi-learner variants.
• Mandatory event and request processing: PROCESS_MANDATORY_EVENT_ASSOC, PROCESS_MAND_EVENT_ASSOC_MULTI, PROCESS_MANDATORY_ENR_REQUESTS, and PROCESS_MAND_ENR_REQS_MULTI drive the creation and evaluation of mandatory enrollment requests from event associations.
• Enrollment creation: CREATE_ENROLLMENTS and CREATE_ENROLLMENTS_MULTI insert learner enrollments into classes and certification subscriptions.
• Notification: NOTIFY_MANDATORY_REQUEST, NOTIFY_CLASS_OWNERS, and NOTIFY_MULTI_CLASS_OWNERS issue workflow notifications to learners and class owners.
• Automatic certification: PROCESS_AUTOMATIC_CERT_SUBSCR, PROCESS_AUTO_CERT_SUBSCR_REQ, CREATE_CERT_REQ_MEMBER_RECORD, and CREATE_CERT_SUBSCRIPTIONS handle automatic certification subscription logic.
• Process control: CHECK_ALL_SLAVES_FINISHED verifies completion of dependent concurrent processes.

Tables Accessed

The package reads and writes several core Learning Management and HR tables through APPS synonyms:

• OTA_EVENTS, OTA_EVENTS_TL, OTA_EVENT_ASSOCIATIONS — source definitions of events and their mandatory associations.
• OTA_MANDATORY_ENR_REQUESTS, OTA_MANDATORY_ENR_REQ_MEMBERS, OTA_MAND_MULTI_ENR_REQUESTS, OTA_MAND_MULTI_ENR_REQ_MEMBERS — the destination tables where mandatory enrollment requests and their member records are created and tracked.
• OTA_CERTIFICATIONS_B, OTA_CERTIFICATIONS_TL, OTA_CERT_ENROLLMENTS — certification definitions and resulting certification enrollments.
• PER_ALL_ASSIGNMENTS_F, PER_ALL_PEOPLE_F — used to resolve learner identity, assignment, and organizational hierarchy.
• WF_ACTIVITIES, FND_CONCURRENT_PROGRAMS, FND_CONCURRENT_REQUESTS — support workflow notification dispatch and concurrent program submission.

Usage Notes

OTA_MANDATORY_ENROLL_UTIL is not invoked from a dedicated OTA form API in the documented metadata; rather, it is designed to be called by concurrent programs, Oracle Workflow activities, and custom extensions. Typical invocation patterns include: a scheduled concurrent program that processes new mandatory event associations and produces enrollment requests; workflow background processes that notify learners and class owners; and certification subscription jobs that generate automatic cert enrollments. Because the package references FND_CONCURRENT_REQUESTS and WF_ACTIVITIES, it is commonly executed in a distributed concurrent processing context where CHECK_ALL_SLAVES_FINISHED coordinates dependent child requests. Developers extending OTA should call these public procedures rather than modify the package body, and should be aware that the package is self-contained (referenced by 0 other packages), meaning changes to its internal logic will not cascade through a shared dependency chain but may still impact scheduled concurrent programs and workflow definitions that call it.