Search Results c_backorderedformula

Overview

PO_POXRQOBO_XMLP_PKG is the Oracle E-Business Suite PL/SQL wrapper package that accompanies the "Backordered Requisitions Report" (short name POXRQOBO), an Oracle Reports-based concurrent program in the Purchasing module. The package is declared with AUTHID CURRENT_USER and carries the header identifier POXRQOBOS.pls, version 120.3. Its principal role is to provide the server-side PL/SQL logic and shared session state required by the corresponding XML Publisher report definition. The report surfaces requisition and purchase order lines that are in a backordered status, enabling buyers and supply chain staff to identify demand that has not been fulfilled.

The package exposes a set of global variables that hold report-level parameter values throughout the concurrent request lifecycle. These include P_TITLE, P_CONC_REQUEST_ID, the descriptive flexfield selectors P_FLEX_ITEM and P_FLEX_CAT, date range parameters P_CREATION_DATE_FROM and P_CREATION_DATE_TO, P_REQUESTOR, subinventory boundaries P_SUBINVENTORY_FROM and P_SUBINVENTORY_TO, quantity precision settings P_QTY_PRECISION and QTY_PRECISION, P_STRUCT_NUM, plus the flags P_OE_STATUS and P_CR_INSTALLED. Collectively these variables drive the filtering, formatting, and conditional display logic of the report output.

Key Procedures and Functions

The package documents eight callable units. BeforeReport and AfterReport are report-level trigger functions returning BOOLEAN; they execute initialization and cleanup logic before and after the report data model runs. GET_P_STRUCT_NUM returns BOOLEAN and resolves the bill of material structure number used in report processing.

Four formula functions return VARCHAR2 values consumed by the report data model. C_BACKORDEREDFORMULA supplies the computed backordered quantity expression. C_WHEREFORMULA builds a dynamic WHERE clause fragment. C_FROMFORMULA constructs the FROM clause fragment used to assemble the report query, which is the object most frequently referenced in searches such as "c_fromformula". C_SHIP_QUANTITYFORMULA returns the computed ship quantity. Finally, G_REQUISITIONGROUPFILTER accepts a numeric backordered argument and returns BOOLEAN, applying requisition grouping filter logic conditional on the backordered value.

Tables Accessed

The ETRM metadata for this package does not enumerate specific tables; no base tables are documented as directly referenced through APPS synonyms. Consistent with its assigned responsibilities, the package derives its data indirectly through the report query assembled by C_FROMFORMULA and C_WHEREFORMULA, and by the requisition filter routine G_REQUISITIONGROUPFILTER. Any table access therefore occurs through the Oracle Reports SQL layer rather than through explicit DML statements within the package body.

Usage Notes

PO_POXRQOBO_XMLP_PKG is invoked automatically by the Oracle Reports runtime when the Backordered Requisitions Report concurrent program executes. It is not designed to be called directly from custom forms or standalone PL/SQL; the report template calls the BeforeReport and AfterReport triggers and the formula functions at designated points in the data model. Custom reporting can reuse the same query-building formulas as a reference pattern, but direct invocation is unsupported. The package is referenced by zero other packages according to the metadata, confirming its role as a leaf-level, report-specific component that depends on no downstream consumers within the EBS codebase.