Search Results delivery_mode_notifications




Overview
Explore in AI Chat

Overview

OTA_LEARNER_ENROLL_REVIEW_SS is an Oracle E-Business Suite PL/SQL package owned by APPS and declared with AUTHID CURRENT_USER, meaning its unqualified database object references resolve against the privileges of the invoking session rather than the package owner. In the Oracle Learning Management (OTRM) module, the package supports the learner-facing enrollment review and submission flow. It mediates the interaction between the self-service learning pages and the underlying enrollment APIs, validating learner selections, persisting activity booking detail, orchestrating approval routing, and generating the notifications that accompany enrollment, cancellation, cross-charge, and delivery-mode events. The package is classified as OTHER within the ETRM metadata rather than as a formal public API, which indicates it is intended primarily for internal use by OTRM application forms and concurrent processes rather than as a supported integration surface.

Key Procedures and Functions

The documented procedures and functions cover the complete lifecycle of a learner enrollment review transaction:

  • SAVE_ADD_ENROLL_DETAIL — Persists the enrollment detail captured on the review page, including descriptive flexfield (DDF) context and attribute values, delegate information, and booking justification, and returns an error message when validation fails.
  • GET_ADD_ENR_DTL_DATA_FROM_TT and GET_REVIEW_DATA_FROM_TT — Retrieve enrollment detail and review data from the OTRM transaction tables (TT) that back the self-service pages.
  • PROCESS_API and PROCESS_API2 — Drive the enrollment processing calls into the underlying learning APIs, handling the invocation sequence and result interpretation.
  • CREATE_ENROLLMENT, CANCEL_ENROLLMENT, and VALIDATE_ENROLLMENT — Create a new booking, cancel an existing booking, and perform pre-submission validation of an enrollment.
  • CREATE_SEGMENT — Creates the booking segment records associated with a multi-segment or multi-day learning offering.
  • CROSS_CHARGES_NOTIFICATIONS — Generates the notifications associated with cross-charging of enrollment costs between internal organizations or cost centers. This procedure is the object most directly associated with the search term "cross_charges_notifications" and reflects the requirement to inform finance or receiving organizations when training costs are recharged.
  • DELIVERY_MODE_NOTIFICATIONS — Generates notifications driven by the learner's selected delivery mode.
  • APPROVED, IS_CLASS_PENDING_FOR_APPROVAL, and GET_APPROVAL_REQ — Determine whether a class or enrollment requires approval, retrieve the applicable approval requirement, and process the approved outcome.
  • NTF_DETAILS_TO_LRNR — Delivers notification detail back to the learner.

Tables Accessed

The package reads and writes a defined set of OTRM, HR, and workflow tables through APPS synonyms. OTA_BKNG_JUSTIFICATIONS_B and OTA_BKNG_JUSTIFICATIONS_TL hold booking justification definitions and their translated text, read by the csr_get_booking_justification cursor using USERENV('LANG'). OTA_ACTIVITY_VERSIONS and OTA_ACTIVITY_VERSIONS_TL provide the activity version and offering information needed for enrollment and approval checks. OTA_BOOKING_STATUS_TYPES supplies valid booking statuses, while OTA_CATEGORY_USAGES and OTA_CATEGORY_USAGES_TL map learner categories to activities for eligibility and pricing. OTA_DELEGATE_BOOKINGS stores delegate booking records created or updated for enrollment submissions. HR tables — HR_ALL_ORGANIZATION_UNITS, HR_LOCATIONS_ALL, HR_API_TRANSACTION_STEPS, and HR_API_TRANSACTION_VALUES — support organization, location, and HR API transaction context. FND_USER and FND_TIMEZONES_TL provide user identity and time zone lookup, and WF_ITEMS underpins the workflow notification and approval integration.

Usage Notes

OTA_LEARNER_ENROLL_REVIEW_SS is invoked from the Oracle Learning Management self-service learner pages when a learner reviews, validates, and submits an enrollment, and it can also be called from OTRM concurrent programs or custom code that performs equivalent enrollment and notification processing. Because the package is declared AUTHID CURRENT_USER and classified as OTHER, it is not a supported public API; any custom invocation carries regression risk and should be limited to environments where the underlying OTRM schema and API behavior have been fully validated. The notification procedures, including CROSS_CHARGES_NOTIFICATIONS, depend on correct workflow setup and organization configuration, so administrators should verify workflow mailer configuration and organization hierarchies before relying on these notifications in production.