Search Results ota_otarpreg_xmlp_pkg




Overview
Explore in AI Chat

Overview

APPS.OTA_OTARPREG_XMLP_PKG is the generated PL/SQL package body that supports the Oracle E-Business Suite OTA (Oracle Training Administration) concurrent report titled "Registration List," identified internally as OTARPREG. The package is bound to an XML Publisher (BI Publisher) report definition and is generated automatically by the Oracle Reports to XML Publisher migration utility. Its role is to supply the runtime parameters, formula columns, and group-level computations consumed by the report template during execution. The package does not expose a public API for external callers; it is an internal implementation unit invoked exclusively by the Oracle Reports/XML Publisher runtime engine when the Registration List concurrent program is submitted.

All identifiers are declared in a single package specification with no overloaded or private subprograms. The state variables declared at package level (for example the business group identifier, session date, report title, and the various CP_ columns) act as a shared context that the report layout references through the corresponding accessor functions.

Key Procedures and Functions

The package exposes sixteen documented program units, all of which are report-trigger callbacks or accessor functions:

  • BeforeReport — Fires prior to report data retrieval; initializes report-level context and typically resolves the report subtitle and business group name.
  • AfterPForm — Executes after the parameter form is processed; used to derive dependent parameter values from user input.
  • AfterReport — Executes after the report completes; releases context and finalizes report state.
  • CF_current_dateFormula — Returns the current date formatted for display in the report header or body.
  • CF_session_dateFormula — Formats the session date parameter for presentation.
  • CF_course_start_dateFormula and CF_course_end_dateFormula — Format the course start and end date parameters respectively.
  • cf_venueformula — Derives the venue description for a given event identifier.
  • CP_venue_p — Accessor returning the resolved venue string.
  • C_BUSINESS_GROUP_NAME_p — Accessor returning the business group name.
  • C_REPORT_SUBTITLE_p — Accessor returning the report subtitle.
  • C_EVENT_TITLE_p — Accessor returning the event title.
  • CP_current_date_p, CP_session_date_p, CP_course_start_date_p, CP_course_end_date_p — Accessors returning the formatted date strings stored in package state.

The accessor naming pattern (a trailing _p) is the standard convention generated for XML Publisher report packages, allowing the RTF template to reference these values as bind parameters.

Tables Accessed

The package references five objects through APPS synonyms:

  • HR_ALL_ORGANIZATION_UNITS — Resolves business group and training center organization names.
  • OTA_EVENTS_TL — Provides translated event titles for the report output.
  • OTA_RESOURCE_BOOKINGS — Supplies training resource booking details used to construct the registration listing.
  • OTA_SUPPLIABLE_RESOURCES_TL — Provides translated suppliable resource names, including venue descriptions.
  • DUAL — Used for scalar date and formatting computations in the formula columns.

Usage Notes

This package is invoked solely by the Oracle Training Administration "Registration List" concurrent program when the XML Publisher output format is selected. It should never be called directly from custom forms or concurrent code, as its state variables are populated exclusively by the Reports runtime during parameter processing. Because the source header dates to 2007 (version 120.1), the package is present in both EBS 12.1.1 and 12.2.2 with functionally equivalent behavior. The object is referenced by no other packages, confirming its role as a terminal report-support unit. Customizations should be applied to the underlying XML Publisher template rather than to this generated package, since regeneration overwrites modifications.