Search Results c_org_indp1formula




Overview
Explore in AI Chat

Overview

INV_INVIRXRF_XMLP_PKG is the generated PL/SQL package body that supports the Oracle Inventory cross-reference report executed through Oracle XML Publisher (BI Publisher) in Oracle E-Business Suite 12.1.1 and 12.2.2. The report presents item-to-cross-reference relationships in two orientations: cross-references by item and items by cross-reference, controlled by the report parameter P_REPORT_TYPE. Like all XMLP report packages, it follows the Oracle Reports-compatible interface, exposing entry points such as BEFOREREPORT and AFTERPFORM that the report engine invokes at defined points in the execution cycle, together with formula columns referenced from the report data model. Within the ETRM repository the package is owned by APPS and classified as OTHER, with six documented program units and no dependencies on other packages.

Key Procedures and Functions

  • BEFOREREPORT — Invoked by the report engine prior to data retrieval. It branches on P_REPORT_TYPE to configure which query (Q_XREF_BY_ITEM or Q_ITEM_BY_XREF) is active, assigns the concurrent request identifier through FND_GLOBAL.CONC_REQUEST_ID, and contains the conventional SRW SRWINIT user-exit blocks, including their associated exception handling, retained for compatibility with the Oracle Reports runtime.
  • AFTERPFORM — Executed after the report parameter form is processed. In this package it is a stub that returns TRUE unconditionally.
  • AFTERREPORT — The standard post-report trigger, provided as part of the generated template for cleanup and SRW exit processing.
  • C_XREF_TYPE_MARG_FORMULAFORMUL — A formula column returning the display string concatenating the literal "Cross Reference Type: " with the value of the P_XREF_TYPE parameter.
  • C_ORG_INDPFORMULA — The formula the user searched for. It accepts the ORG_INDP value and returns 'Yes' when the indicator equals 'Y', and 'No' otherwise, providing a human-readable Boolean rendering of the organization-independent flag in the report output.
  • C_ORG_INDP1FORMULA — A companion formula applying the same Y-to-Yes / otherwise-No conversion to the second organization-independence indicator used by the report layout.

Tables Accessed

The documented ETRM metadata lists no tables referenced directly by this package body. Query logic for the cross-reference report resides in the underlying report definition and data model, while this package performs only parameter handling, global request context initialization, and column-level formatting. Any item, cross-reference, and organization data is therefore supplied to the formulas through bind and lexical parameters rather than direct SQL within the package.

Usage Notes

The package is invoked by the Oracle XML Publisher report engine when the Inventory cross-reference report is run, typically as a concurrent program submitted from the Inventory responsibility or from the standard report submission form. Because it is a generated report-support package, it is never called directly from application forms or custom PL/SQL; modifications should be made through the report definition and regenerated. The C_ORG_INDPFORMULA function is of interest to developers reviewing report output because it determines how the organization-independent indicator is displayed, mapping the stored Y value to "Yes." The inline comments referencing SRW calls indicate that the package originated from an Oracle Reports conversion to XML Publisher, a pattern common to Inventory reports in release 12.1.1 and 12.2.2. The package is referenced by no other packages, confirming its role as a leaf-level artifact serving a single report.