Search Results p_cat_struct_num

Overview

PO_POXCORIT_XMLP_PKG is the PL/SQL implementation package that supports the Oracle Purchasing concurrent program report "POXCORIT" (Country of Origin Item Detail, report file POXCORITS.pls). The package is owned by APPS and is declared with AUTHID CURRENT_USER. Published under a $Header of 120.1 2007/12/25 from source file POXCORITS.pls, the package is an XML Publisher report package whose primary business purpose is to drive the country-of-origin compliance report that lists approved supplier/item sourcing data by organization, category, and item. It exists to centralize the report's parameter passing, the SQL WHERE-clause assembly for flexible filters, and a server-side lookup of the vendor item number returned to the report layout.

In the context of EBS 12.1.1 and 12.2.2, this package is one of many legacy "XMLP_PKG" wrappers generated by Oracle Reports/XML Publisher and retained for backward compatibility. The global package variables mirror the concurrent program parameter dialog and are bound to the report layout at runtime.

Key Procedures and Functions

• BeforeReport — Standard report trigger fired before the report executes. It resolves the runtime values for the "P_" global variables, including p_cat_struct_num (the category structure number the user searched for) and p_item_struct_num, prior to the query being submitted.
• AfterReport — Standard report trigger invoked after report completion, used for cleanup and post-processing of report globals and session state.
• get_p_struct_num — Resolves the relevant item/category structure number used by the report by returning a boolean result. This is the routine that populates structure-number globals such as P_ITEM_STRUCT_NUM and P_CAT_STRUCT_NUM, which in turn drive the flexfield (key flexfield) filtering of category and item ranges.
• f_get_vendor_item_number — Server-side function that accepts organization, vendor, vendor site, and item identifiers and returns the vendor item number (varchar2) for the given sourcing relationship. It is the data-access function used to populate the vendor item number column of the report.
• cf_vendor_item_numberformula — The formula (levels) column counterpart to f_get_vendor_item_number, evaluating the vendor item number against the current report row using C_USING_ORG_ID, C_VENDOR_ID, C_VENDOR_SITE_ID, and C_ITEM_ID, and returning varchar2.

Tables Accessed

ETRM metadata documents a single referenced table: PO_APPROVED_SUPPLIER_LIST, accessed through an APPS synonym. This is the approved supplier list (ASL) table, which links approved vendors, vendor sites, organizations, and items. It is read by the vendor item number functions to resolve the sourcing relationship for each item and to return the vendor item number. No write operations are documented; the package is read-only against ASL.

Usage Notes

The package is typically invoked by the POXCORIT concurrent program or its XML Publisher report definition rather than by direct application code. The report's parameter dialog supplies the input values — including p_cat_struct_num, which the user searched for — that populate the package globals (P_CAT_STRUCT_NUM, P_FLEX_CAT, P_CAT_FROM, P_CAT_TO, P_DATE_FROM/TO, P_ORG_ID, and others). The BeforeReport trigger then executes, and the report query is filtered using the compiled WHERE-clause strings. Parameter values such as p_cat_struct_num should be supplied through the standard concurrent parameters form so that BeforeReport and get_p_struct_num can resolve them consistently. Because the package is not referenced by any other documented package, customizations should not depend on its internal state; instead, invoke it through the concurrent program or replicate its logic against PO_APPROVED_SUPPLIER_LIST when a standalone vendor item lookup is required.