Search Results p_vendor_from

Overview

PO_POXRVODS_XMLP_PKG is the generated PL/SQL package body that backs the Oracle E-Business Suite concurrent report program POXRVODS, the Purchasing "Overdue Receiving and Delivery" (overdue shipments / purchase order delivery) XML Publisher report. The package supplies the report-independent and report-triggered PL/SQL logic that Oracle Reports/BI Publisher templates invoke through the standard BeforeReport, AfterReport, and AfterPForm entry points. Its principal responsibilities are parameter pre-processing and GL-style quantity format-mask derivation. Parameter values supplied at submission time from the concurrent program, including vendor-related bind parameters such as p_vendor_to, are consumed by the report template to constrain and display the overdue PO shipment data set. The package is classified in ETRM as API classification OTHER, meaning it is a report-support package rather than a callable business API. It is owned by APPS and defined in the file POXRVODSB.pls.

Key Procedures and Functions

• BEFOREREPORT — Executes immediately prior to report execution. It resolves the organization identifier parameter (P_org_id) into a display name by selecting from ORG_ORGANIZATION_DEFINITIONS, populating the P_org_displayed user parameter; when no organization is supplied, it sets the display value to an empty string. It also derives the quantity report-level FORMAT_MASK via PO_COMMON_xmlp_pkg.GET_PRECISION using P_QTY_PRECISION, and contains the traditional FND SRWINIT / SRWEXIT references that are now commented out in the XML Publisher implementation. Returns TRUE on completion.
• AFTERREPORT — The post-execution trigger. In this package body it contains the commented-out SRW.USER_EXIT('FND SRWEXIT') call and simply returns TRUE.
• GET_PRECISION — Internal helper that maps the P_QTY_PRECISION user parameter to a numeric display format mask. It branches on precision values 0, 1, 3, 4, 5, and 6 and assigns the corresponding format mask (defaulting to a two-decimal mask otherwise). The SRW attribute assignments are commented out in the XML Publisher variant.
• GET_P_STRUCT_NUM — Report utility function used by the runtime to verify the report parameter structure initialization; the BeforeReport trigger evaluates its return value against TRUE.
• AFTERPFORM — Parameter-form trigger fired after the report parameter form has been processed, used to finalize parameter values (for example, derived vendor ranges) before the query executes.
• C_ITEM_FLEXFORMULA — Formula/formatting function associated with the report data model, used to produce a display string for an item-related flexfield or column in the output.

Tables Accessed

The package body explicitly reads ORG_ORGANIZATION_DEFINITIONS, using the supplied organization identifier to return the organization name for header display. All other data retrieval for the report (purchase order shipments and delivery/overdue details selected by the entered vendor range, including p_vendor_to) is performed by the report's SQL query and referencing packages rather than by this package body. No insert, update, or delete statements are present in the package; it is read-only with respect to schema data.

Usage Notes

This package is not intended for direct invocation from forms or custom code. It is instantiated implicitly when the POXRVODS concurrent program is run from the Submit Requests window (Purchasing responsibility, Overdue Receiving and Delivery report). Oracle Reports/BI Publisher calls BEFOREREPORT and AFTERREPORT automatically and evaluates GET_P_STRUCT_NUM within the BeforeReport trigger. Support and diagnostic activity should therefore focus on parameter values submitted to the concurrent program — the vendor range (p_vendor_to), overdue date, organization, and quantity precision — since only these inputs, together with ORG_ORGANIZATION_DEFINITIONS, influence package behavior. The package references no other packages and is not referenced by any other package, confirming its role as a leaf-level report support unit in Oracle EBS 12.1.1 and 12.2.2.