Search Results p_ship_to

Overview

APPS.PO_POXCORSL_XMLP_PKG is a PL/SQL package that supports the Oracle Purchasing country-of-origin reporting concurrent program in Oracle E-Business Suite 12.1.1 and 12.2.2. The package name follows the standard Oracle Reports integration convention: the "XMLP" suffix identifies it as the server-side package that accompanies the XML Publisher (BI Publisher) report definition, and the "POXCORSL" segment identifies the source report template (POXCORSLS.pls). The package is declared with AUTHID CURRENT_USER, meaning its procedures execute under the privileges of the invoking session rather than the APPS schema owner, which is standard for report-supporting packages in the Oracle EBS technology stack.

The package carries a set of global variables that correspond directly to the report's concurrent program parameters and runtime report state. These include P_CONC_REQUEST_ID, which captures the concurrent request identifier for logging and traceability; P_SHIP_TO and P_SHIP_TO_ORG_NAME, which hold the ship-to organization selection and its resolved organization name; P_VENDOR_FROM, P_VENDOR_TO, and P_VENDOR_SITE, which define the supplier and supplier site range; and P_ITEM_STRUCT_NUM, P_TITLE, P_FLEX_ITEM, P_COUNTRY_OF_ORIGIN_CODE, and P_QUERY_WHERE_COUNTRY_CODE, which drive item structure, reporting title, item flexfield, and country-of-origin filtering. The user search term "p_ship_to" maps to the P_SHIP_TO parameter variable described above.

Key Procedures and Functions

• BEFOREREPORT — Executed before the report body is rendered. Its role is to initialize the package globals, resolve report parameter values such as the ship-to organization name, and prepare any dynamic SQL fragments (for example the country-code WHERE clause) required by the report query.
• AFTERREPORT — Executed after the report completes. It performs cleanup and post-processing actions, returning a boolean status to the report engine.

Only this BeforeReport/AfterReport pair is documented in the ETRM metadata. No additional procedures or functions are recorded, and therefore no parameter lists beyond the implied boolean return should be assumed.

Tables Accessed

The documented metadata lists no base tables referenced through APPS synonyms. In practice, this package primarily manipulates package-level variables and delegates most data retrieval to the report's underlying SQL query definitions rather than issuing direct DML. Any data access for the country-of-origin report — supplier, supplier site, item, ship-to organization, and country-of-origin records — is driven by the report query itself, not by procedures within this package.

Usage Notes

This package is invoked indirectly by the Oracle Reports/XML Publisher runtime when the associated country-of-origin purchasing report is submitted as a concurrent program. It is not intended to be called directly from forms or custom code. Customizations should not modify the package signature, because the report definition binds to the P_* globals by name; changes to variable names, ordering, or the BeforeReport/AfterReport entry points can break report execution. When troubleshooting the "p_ship_to" parameter, verify the concurrent program parameter values and confirm the resolved organization is populated in P_SHIP_TO_ORG_NAME during BeforeReport.