Search Results c_appl_toformula




Overview
Explore in AI Chat

Overview

ONT_OEXOEPCL_XMLP_PKG is an Oracle Application Object Library package owned by APPS that supports the Oracle Order Management concurrent program associated with seeded attribute and operation validation reporting. The suffix _XMLP_PKG identifies it as the PL/SQL package automatically generated to accompany an Oracle XML Publisher (BI Publisher) report definition. Its role is to declare the report's bind parameters, expose getter functions used by the report template, and provide the pre- and post-processing logic executed by the concurrent manager before and after the XML data is produced.

The package is classified as OTHER in the ETRM metadata, indicating that it is treated as an internal, generated artifact rather than a formal public API. It is not referenced by any other package, confirming its status as a leaf node invoked only through its owning concurrent program. The rp_functional_currency_p element that prompted the search is the getter that returns the functional currency of the operating unit's ledger to the report layout.

Key Procedures and Functions

  • BEFOREREPORT — Executed before the report query runs; initialises report-level context and prepares the data retrieval for the XML Publisher template.
  • AFTERREPORT — Executed after the report query completes; performs any cleanup or post-processing required once the dataset has been generated.
  • AFTERPFORM — The "after parameter form" hook. It runs once the concurrent program's parameter form has been submitted, allowing the package to derive or validate dependent values such as operating unit, ledger, and currency context.
  • C_APPL_TOFORMULA — A helper that translates an application context and constraint identifier into the value expected by the report's formula or layout logic, bridging responsibility and constraint settings to the XML template.
  • RP_REPORT_NAME_P — Getter returning the report name for display in the report header.
  • RP_SUB_TITLE_P — Getter returning the report subtitle, typically reflecting the selected validation entity, operation, or attribute.
  • RP_COMPANY_NAME_P — Getter returning the legal entity or company name printed on the report.
  • RP_FUNCTIONAL_CURRENCY_P — Getter returning the functional currency derived from the ledger associated with the concurrent request, populated during AFTERPFORM.

The package also declares the report's bind variables (P_SOB_ID, P_ATTRIBUTE, P_OPERATION, P_ENTITY, P_SEEDED, and related record-set and validation parameters) and the corresponding RP_ return variables. These are populated at runtime rather than by direct caller assignment.

Tables Accessed

  • FND_CONCURRENT_REQUESTS — Read to resolve the current concurrent request context, including the request identifier supplied through P_CONC_REQUEST_ID, so that the ledger and currency context can be determined.
  • FND_CURRENCIES — Read to translate the ledger's currency code into the descriptive functional currency returned by RP_FUNCTIONAL_CURRENCY_P.

Both objects are accessed through APPS synonyms, consistent with the package's AUTHID CURRENT_USER declaration.

Usage Notes

The package is invoked exclusively by the Oracle Order Management concurrent program that it supports; no other package or form calls it directly. It runs under the privileges of the APPS schema in the EBS 12.1.1 and 12.2.2 environments for which it is documented. Because it is a generated XML Publisher wrapper, it should not be modified or called from custom code; extensions should instead be applied to the underlying report definition or to a separate custom package. The header comment, dated 2007, indicates the package has remained essentially unchanged across releases, so the same behaviour should be expected in both 12.1.1 and 12.2.2.