Search Results cancel_finance

Overview

OTA_ENROLL_IN_TRAINING_SS is an Oracle EBS Applications (APPS) PL/SQL package body belonging to the Oracle Training Administration (OTA) module of Oracle Human Resources / Enterprise Learning Management. Its documented header (otssetrn.pkb, version 120.3) confirms that it supports the self-service enrollment flow, creating enrollment data when a user enrolls in a class through self-service. The package encapsulates the business logic behind the "Enroll in Training" self-service function, including validation of the learner, the event, cost centers, booking conflicts, and secure or restricted event checks, as well as the Workflow process creation that drives approvals and notifications.

The classification of this package in the ETRM metadata is "OTHER" rather than a public, supported API. It is described in the source comments as being for internal development use and for use by the self-service application only. It is referenced by two other packages, indicating it is a subordinate component called from a higher-level self-service controller or workflow-enabled wrapper rather than being invoked directly by customer code.

Key Procedures and Functions

The package exposes eighteen documented procedures and functions. The central routine is PROCESSSAVEENROLLMENT, which creates the enrollment (booking) record when a learner enrolls in a class and returns the booking identifier and a message name to the caller. Supporting routines include:

• CANCEL_FINANCE — handles the financial reversal associated with canceling an enrollment, working against the finance header data for the booking. This is the routine most relevant to users searching for "cancel_finance."
• VALIDATE_ENROLLMENT — performs the pre-enrollment validation of the learner and the event.
• CHECK_ENROLLMENT_CREATION — determines whether an enrollment may be created for the given person and event.
• CHECK_COST_CENTER — validates cost center information supplied during enrollment.
• CHK_BOOKING_CLASH — checks for scheduling conflicts between the requested class and existing bookings.
• CHK_FOR_SECURE_EVT and CHK_FOR_RESTRICTED_EVT — enforce security and restriction rules on the event.
• CHK_DELEGATE_OK_FOR_EVENT — validates whether a delegate may be enrolled for the event.
• CHK_EVENT_CANCELLED_FOR_PERSON — detects a prior cancellation by the same person.
• CREATE_ENROLL_WF_PROCESS — initiates the Oracle Workflow process associated with the enrollment.
• CHECK_WF_STATUS — reports the status of the enrollment workflow.
• GET_BOOKING_STATUS_FOR_WEB, GET_BOOKING_OVN, GET_PERSON_TO_ENROLL_DETAILS, and GET_CURRENT_PERSON_ID — retrieve booking status, object version number, learner details, and the current person identifier for the self-service session.
• CROSS_CHARGES_NOTIFICATIONS and APPROVED — support cross-charging notification and approval processing.

Tables Accessed

The package reads and writes through APPS synonyms. Enrollment and booking data reside in OTA_DELEGATE_BOOKINGS, with status decoded via OTA_BOOKING_STATUS_TYPES and OTA_BOOKING_STATUS_TYPES_TL. Event and activity definitions come from OTA_EVENTS, OTA_ACTIVITY_VERSIONS, OTA_ACTIVITY_VERSIONS_TL, and OTA_EVENT_ASSOCIATIONS. Financial reversal for cancellations is recorded in OTA_FINANCE_HEADERS. Person and assignment context is drawn from PER_ALL_PEOPLE_F, PER_ALL_ASSIGNMENTS_F, PER_BUSINESS_GROUPS (referenced in parameters), HR_ALL_ORGANIZATION_UNITS, and FND_USER. Workflow integration uses WF_ITEMS, WF_PROCESS_ACTIVITIES, and HR_WORKFLOW_ITEM_KEY_S.

Usage Notes

OTA_ENROLL_IN_TRAINING_SS is invoked from the learner self-service enrollment pages and from the workflow-enabled enrollment process, not from a standard concurrent program. Because the header states "Internal Development Use Only," customizations should call the supported OTA enrollment APIs rather than invoking this package directly. The CANCEL_FINANCE routine is reached during cancellation processing when a learner or administrator cancels an existing booking and the associated finance records must be reversed; the finance header table OTA_FINANCE_HEADERS is updated in that path. The package is version-sensitive: the header reflects version 120.3 (2008), and behavior should be verified against the specific 12.1.1 or 12.2.2 patch level in use.