Search Results chk_booking_clash

Overview

The APPS.OTA_TRNG_ENROLL_SS package body is the self-service enrollment engine within the Oracle E-Business Suite Training Administration (OTA) module. Its header identifies it as the package used by the self-service application to create enrollment data when a user enrolls in a class. The single public entry point, ProcessSaveEnrollment, accepts event, cost center, assignment, business group, organization, person, and descriptive flexfield information, and returns a booking identifier together with an outcome message name. Post-success behavior is the creation of enrollment data; post-failure behavior is the return of a status to the caller, which raises the notification. The header carries the module's internal marker "Internal Development Use Only," and the source stamp (ottrnenr.pkb 120.2) confirms it is a seeded, shipped object rather than customer code.

Key Procedures and Functions

ETRM documents 17 procedures and functions in this package. ProcessSaveEnrollment is the principal API that orchestrates enrollment creation. ValidateEnrollment and Check_Enrollment_Creation perform eligibility checks before a booking is written. Chk_Booking_Clash — the object of the user's search — detects scheduling conflicts for the person being enrolled, preventing double-booking of a learner. Chk_Event_Cancelled_For_Person and Chk_For_Secure_Evt verify event status and security restrictions, while Chk_For_Restricted_Evt and Chk_Delegate_Ok_For_Event enforce restricted-event rules and delegated enrollment eligibility. Cancel_Finance reverses the financial lines associated with a cancelled booking. Get_Booking_Status_For_Web, Get_Person_To_Enroll_Details, Get_Current_Person_Id, and Get_Booking_Ovn are retrieval routines that surface booking status, learner details, the session person identity, and the booking object version number. Check_Cost_Center validates cost center input against allocation data, and Check_Wf_Status tests the Workflow status underlying an enrollment. Cross_Charges_Notifications and Approved drive the cross-charging notification and approval flow. None of these routines are documented with public parameter signatures in the excerpt, so direct invocation should be treated with caution.

Tables Accessed

The package reads and writes through APPS synonyms. Booking activity centers on OTA_DELEGATE_BOOKINGS, with status codes resolved from OTA_BOOKING_STATUS_TYPES and its translated table. Event definition and versioning draw on OTA_EVENTS, OTA_ACTIVITY_VERSIONS and OTA_ACTIVITY_VERSIONS_TL, plus OTA_EVENT_ASSOCIATIONS for related activities. Person and assignment context comes from PER_ALL_PEOPLE_F, PER_ALL_ASSIGNMENTS_F, and HR_ALL_ORGANIZATION_UNITS, with PER_BUSINESS_GROUPS supplied where needed. Financial reversal and cost allocation use OTA_FINANCE_HEADERS, OTA_FINANCE_LINES, PAY_COST_ALLOCATIONS_F, and PAY_COST_ALLOCATION_KEYFLEX. Self-service identity is resolved through FND_USER.

Usage Notes

This is an internal self-service package, not a supported public API, and the ETRM record shows it is referenced by only one other package. It is normally invoked indirectly from the learner self-service enrollment pages and related Workflow and notification processes rather than from custom forms or concurrent programs. Customizations that call ProcessSaveEnrollment directly should anticipate the out parameters for booking ID and message name, since the caller is responsible for raising the notification on a non-success status.