Search Results c_using_org_id




Overview
Explore in AI Chat

Overview

PO_POXCORIT_XMLP_PKG is the generated PL/SQL package body that backs the Oracle E-Business Suite XML Publisher (BI Publisher) concurrent report commonly identified as "POXCO RIT" — a Purchasing report centered on country-of-origin information for sourced items and approved supplier list entries. As with all XMLP report packages in Oracle EBS 12.1.1 and 12.2.2, this package serves as the data-model layer for the report definition. It supplies the PL/SQL functions that the XML Publisher data template calls to populate report parameters, retrieve structural defaults, and compute derived display values before the report output is rendered.

The package is owned by APPS and classified as OTHER, meaning it exposes no public application programming interface intended for external consumption by other Oracle modules. Its scope is confined to the execution lifecycle of the single report it supports.

Key Procedures and Functions

  • BEFOREREPORT — Executes before the report query runs. It resolves the organization name for the selected organization identifier into the P_organization_name parameter, and constructs the dynamic WHERE fragment stored in P_QUERY_WHERE_COUNTRY_CODE. When a country-of-origin code is supplied by the user, the function builds a predicate restricting poll.country_of_origin_code to that value; when no code is supplied, it defaults the fragment to 1=1 so the report returns unrestricted results. This is the logic referenced by the search term p_query_where_country_code.
  • AFTERREPORT — Executes after the report data is generated. In this implementation it performs the standard SRW exit handling and returns TRUE.
  • GET_P_STRUCT_NUM — Retrieves the item category structure identifier from MTL_DEFAULT_SETS_VIEW for functional area 2 and assigns it to P_CAT_STRUCT_NUM, ensuring the report uses the correct category structure when presenting item classifications.
  • F_GET_VENDOR_ITEM_NUMBER — Returns the primary vendor item number by querying PO_APPROVED_SUPPLIER_LIST for the given organization, vendor, vendor site, and item combination.
  • CF_VENDOR_ITEM_NUMBERFORMULA — The XML Publisher formula column wrapper that invokes the vendor item number lookup so the value can be embedded directly in the report layout.

Tables Accessed

The documented data access targets the APPS synonym PO_APPROVED_SUPPLIER_LIST, read via F_GET_VENDOR_ITEM_NUMBER to resolve the primary vendor item number for each sourcing record. The package additionally reads ORG_ORGANIZATION_DEFINITIONS to translate the organization identifier into its display name, and MTL_DEFAULT_SETS_VIEW to obtain the default category structure identifier. All access is read-only; the package writes no application data.

Usage Notes

This package is invoked exclusively through the XML Publisher concurrent program infrastructure. At runtime the report engine calls BEFOREREPORT, executes the data template query using the constructed P_QUERY_WHERE_COUNTRY_CODE predicate, applies the formula column for vendor item numbers, and then calls AFTERREPORT during cleanup. It is not referenced by any other package, form, or custom code, and Oracle does not publish it as a callable API. Because the package body was last versioned at 120.1, it reflects long-stable behavior and should be treated as report-internal logic; customizations should be made through the report definition or a copied package rather than by modifying the shipped object directly.