Results for “p_event_id”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

HRI_OLTP_DISC_TRAINING is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and defined with AUTHID CURRENT_USER. It belongs to the Oracle HR Intelligence (HRI) product family and specifically supports the discovery and reporting layer for Oracle Training Administration (OTA), the training module embedded within Oracle Learning Management. Its core purpose is to return derived training cost, revenue, and duration values that are otherwise difficult to compute directly from transaction tables, exposing them as reusable PL/SQL functions for downstream analytical queries, discoverer worksheets, and reporting extracts.

The package has a compact public interface comprising eight documented functions. The header comment carries a version stamp of 115.0 dated 2002, indicating that the object has been stable across the EBS 11i, 12.1.1, and 12.2.2 releases. The classification of API as OTHER reflects that it is an internal helper package rather than a formally published public API.

Key Procedures and Functions

The eight documented functions fall into three logical groupings.

• GET_EVENT_BUDGET_COST — returns the budgeted cost associated with a given training event, identified by event ID.
• GET_EVENT_ACTUAL_COST — returns the actual cost incurred for a training event, enabling budget-versus-actual variance analysis.
• GET_EVENT_REVENUE — returns total revenue recorded against a training event.
• GET_ATT_INT_REV_BOOKING — returns the internal revenue attributable to a booking made by an attendee (internal delegate).
• GET_ATT_EXT_REV_BOOKING — returns the external revenue attributable to a booking made by an attendee (external delegate).
• GET_NON_ATT_INT_REV_BOOKING — returns internal revenue for a non-attendee booking, such as a cancellation or no-show.
• GET_NON_ATT_EXT_REV_BOOKING — returns external revenue for a non-attendee booking.
• CONVERT_TRAINING_DURATION — converts a training duration expressed in one unit of measure into another, using a conversion formula, activity version, event context, and session date to resolve the correct conversion factor.

Tables Accessed

The package reads from a defined set of training and finance tables through APPS synonyms. OTA_EVENTS, OTA_ACTIVITY_VERSIONS, and OTA_RESOURCE_BOOKINGS provide event, version, and resource context. OTA_DELEGATE_BOOKINGS and OTA_BOOKING_STATUS_TYPES supply delegate booking records and their statuses, underpinning the attendee versus non-attendee revenue calculations. OTA_FINANCE_LINES supplies the monetary amounts for cost and revenue functions. OTA_PROGRAM_MEMBERSHIPS and OTA_SUPPLIABLE_RESOURCES identify program and resource associations. FF_FORMULAS_F is consulted for duration conversion formulas, FND_CURRENCIES for currency handling, and PLITBLM serves as a PL/SQL index-by table utility.

Usage Notes

HRI_OLTP_DISC_TRAINING is generally invoked by Oracle Discoverer worksheets, HRI operational reporting views, and custom concurrent programs rather than by end-user forms. The package is referenced by one other delivered package, indicating it is a supporting utility in a layered reporting architecture. Because AUTHID CURRENT_USER is specified, execution is subject to the privileges of the calling schema; callers querying the HRI OLTP discoverer subject areas rely on APPS synonyms being visible. In the context of user searches such as "g4s training sheet", this package is the underlying logic that supplies the cost and revenue columns seen in training administration reports, including those extracted for third-party or vendor training sheets. Developers extending such reporting should call these functions rather than reimplementing the joins, as the logic accounts for booking status and delegate type distinctions that are not obvious from the base tables.