Search Results po_poxrqexp_xmlp_pkg

Overview

APPS.PO_POXRQEXP_XMLP_PKG is the PL/SQL package body that supports the Oracle Purchasing purchase requisition export report, an XML Publisher (BI Publisher) concurrent program. The package implements the server-side PL/SQL logic that the report definition invokes at runtime, most notably the initialization and teardown hooks required by the Oracle Reports-to-XML Publisher migration framework. Its primary business purpose is to resolve the correct purchasing structure identifier (the default purchasing organization's inventory structure) and expose it to the report as a bind parameter, so that requisition data extracted by the report is filtered and formatted against the proper operating unit's structure. The package header source carries the revision marker $Header: POXRQEXPB.pls 120.1 2008/01/06, confirming its long-standing presence in the Purchasing module and its classification as a non-shipped (noship) support object.

Key Procedures and Functions

• BEFOREREPORT — The pre-report trigger function. It executes the initialization sequence for the report, historically the FND SRWINIT user exit (now commented out in the migrated XML Publisher version). It then calls get_p_struct_num and validates the returned Boolean, and returns TRUE to signal that report execution may proceed.
• GET_P_STRUCT_NUM — The function that satisfies the user's search for "get_p_struct_num". It queries the default sets view to retrieve the structure identifier for the functional area associated with purchasing (functional_area_id = 2), assigns that value to the report parameter P_STRUCT_NUM, and returns TRUE on success or FALSE when an exception is raised. It is the central data-lookup routine in the package and is the only documented procedure that reads application data.
• AFTERREPORT — The post-report trigger function. It performs teardown, historically via the FND SRWEXIT user exit (also commented out in the migrated form), and returns TRUE unconditionally.

Tables Accessed

The package reads a single documented object: MTL_DEFAULT_SETS_VIEW, accessed through its APPS synonym. The query selects structure_id from this view, filtered by functional_area_id = 2. This view resolves the default item/master organization structure assignment for the Materials Management functional area, which in the Purchasing context maps to the default purchasing structure. The retrieved structure ID is stored in the report parameter P_STRUCT_NUM, which downstream report queries use to constrain requisition lines to the correct organization structure. No inserts, updates, or deletes are performed; the package is strictly read-only with respect to application tables.

Usage Notes

This package is invoked exclusively by the XML Publisher report definition for the Purchase Requisition Export program. It is not referenced by any other package (documented as referenced by 0 packages), so it should be treated as a report-private support package rather than a reusable API. It executes automatically when the concurrent program runs: BEFOREREPORT fires first to establish P_STRUCT_NUM, and AFTERREPORT fires on completion. Because the FND SRWINIT and FND SRWEXIT calls are commented out in the shipped source, the package relies on the XML Publisher runtime for session initialization and cleanup. Customizations should avoid altering the parameter name P_STRUCT_NUM, since the report layout references it as an Oracle Reports placeholder. The exception handler in GET_P_STRUCT_NUM returns FALSE rather than raising, so a missing structure assignment results in a silent report initialization failure rather than a hard error — a behavior worth noting when diagnosing reports that produce no rows.