Search Results rp_org_name_p




Overview
Explore in AI Chat

Overview

The APPS.ONT_OEXORDTP_XMLP_PKG package is a generated Oracle reports package that supports the Order Tracking / Order Information Portal XML Publisher report in Oracle E-Business Suite. The package name combines the ONT (Order Management) module prefix with OEXORDTP_XMLP, indicating it is the PL/SQL package automatically produced for the Order Tracking Print (XML Publisher) concurrent program. Its principal role is to provide the report-specific global variables, and the before/after report and after-form trigger functions, that the Oracle Reports runtime calls when executing the OEXORDTP report definition.

The package is principally a container for the report's runtime state. It holds bind/public parameters such as the transaction type (low and high ranges plus code), order category, set of books identifier, concurrent request identifier, and the COGS flexfield structure data, together with derived report values such as the report name, operating unit (organization) name, and a "data found" flag. These globals are populated by the report triggers and consumed by the XML Publisher data template.

Key Procedures and Functions

The documented interface comprises six callables:

  • BEFOREREPORT — Executed before the report query is run. It is the initialization trigger that populates the report's global variables (transaction type ranges, order category, SOB identifier) and prepares the reporting context prior to data retrieval.
  • AFTERPFORM — Executed after the parameter form values are accepted. It performs post-parameter-form processing, typically validating or transforming the user-entered parameters and setting the additional globals (COGS flexfield data and structure number) required by the query.
  • AFTERREPORT — Executed after the report body has been produced. It finalizes report state and handles any cleanup or post-processing logic associated with report completion.
  • RP_REPORT_NAME_P — Returns the report name value (RP_REPORT_NAME) to the XML Publisher template.
  • RP_ORG_NAME_P — Returns the organization name (RP_ORG_NAME). This is the getter function that corresponds to the "rp_org_name_p" token that was searched; it exposes the operating unit / organization display name to the report output.
  • RP_DATA_FOUND_P — Returns the data-found flag (RP_DATA_FOUND), allowing the template layout to conditionally render content depending on whether the query returned records.

Tables Accessed

The only documented table reference is FND_CONCURRENT_REQUESTS (accessed through the APPS synonym). This is the standard Oracle Application Object Library table that stores concurrent program request records. The report package reads it, typically in the before-report logic, to correlate the running request identifier (P_CONC_REQUEST_ID) with request-level information needed for the run and for XML output metadata. No other tables are documented in the package metadata; the report's substantive order data is retrieved by the associated report query rather than by this package directly.

Usage Notes

This package is not intended for direct invocation from forms or custom code. It is generated and maintained by Oracle Reports/XML Publisher and is called automatically by the Reports runtime engine when the OEXORDTP XML Publisher concurrent program executes. The *_P functions are referenced from within the report's XML data template and layout to inject values such as the organization name and report name into the generated output. The metadata records zero packages referencing this package, confirming it sits at the leaf of the dependency tree. Because it is a generated artifact, modifications should be made by updating and republishing the underlying report definition rather than editing the package directly. As with all APPS-owned report packages, it should be treated as read-only reference material.