Search Results ont_oexiodis_xmlp_pkg




Overview
Explore in AI Chat

Overview

The package body APPS.ONT_OEXIODIS_XMLP_PKG implements the server-side PL/SQL logic that supports the Oracle Order Management "Open Orders and Item Details" XML Publisher (BI Publisher) report, historically known as the Order Information Detail (OEXIODIS) concurrent program. It is a report-support package generated in the standard XML Publisher report package pattern, in which a combination of package-level variables, a before-report function, an after-form trigger function, and multiple value-returning "R_" and "CF_" formula functions are consumed by the report template to render parameter labels, column captions, and conditional SQL fragments. The package is owned by APPS and is classified as API classification OTHER, meaning it is not intended for external calling as a public API; it is an internal report companion object.

The package was last shipped with a header revision dated 2008/05/05 and remains present in EBS 12.1.1 and 12.2.2, largely unchanged, because it drives a long-standing order-line detail reporting requirement rather than a core transactional API.

Key Procedures and Functions

The documented package exposes 24 procedures and functions. The principal groups are:

No parameter lists are documented in the metadata; purposes are inferred from function naming and the OEXIODIS report context.

Tables Accessed

The package references the following tables through APPS synonyms:

Usage Notes

This package is invoked only by the XML Publisher engine when the OEXIODIS report is submitted as a concurrent program. It is not referenced by any other package (referenced-by count of 0), so it should be treated as a private report implementation object. It is not a supported extension point. Customizations should be limited to copying and cloning the report definition rather than modifying the shipped package. Because it executes under the APPS schema and constructs SQL fragments from user-entered parameters, runtime errors in parameter text are absorbed by local WHEN OTHERS THEN NULL handlers, which can silently suppress messages; this behavior is consistent with legacy XML Publisher report packages and is a consideration when debugging unexpected report output.