Search Results c_component_sortformula




Overview
Explore in AI Chat

Overview

The APPS.WIP_WIPDJORQ_XMLP_PKG package is a packaged PL/SQL construct that supports the Oracle Work in Process discrete job reporting infrastructure, specifically the XML Publisher (BI Publisher) report associated with the "Discrete Job Open Requirements" style reporting in Oracle E-Business Suite 12.1.1 and 12.2.2. It is classified under the ETRM as an "OTHER" API, meaning it is not a public, supported application programming interface but rather an internal report support package generated to back a specific concurrent program and its XML Publisher template.

The package encapsulates the bind parameters, formatting logic, and break-group calculations needed to render the report output. Its header declares a large set of packaged variables that map to the concurrent program's report parameters — organization, job ranges, date ranges, department limits, buyer and planner ranges, component ranges, supply and detail locations, quantity precision, and assorted report-control flags such as P_NETTABLE, P_INCLUDE_BULK, P_INCLUDE_VENDOR, and P_DEBUG. These parameters drive filtering, sorting, and display formatting within the report's data model and layout template.

Key Procedures and Functions

The package exposes thirty documented program units. The lifecycle functions BEFOREREPORT and AFTERREPORT initialize and finalize report state. Several "limiter" functions — LIMIT_JOBS, LIMIT_DATES, LIMIT_PLANNERS, LIMIT_BUYER, and DEPARTMENT_LIMITER — constrain the result set so that only jobs, dates, planners, buyers, or departments within the selected parameters appear in the output.

The "C_*FORMULA" functions provide computed and formatted values for the report layout. These include C_NETTABLE_CONSTRAINTFORMULA, C_TOTAL_QTY_FORMULAFORMULA, C_QTY_SHORT_QOHFORMULA, C_BREAK_JOBFORMULA, C_BREAK_DATE_REQUIREDFORMULA, C_BREAK_DEPARTMENTFORMULA, C_LIMIT_COMPONENTSFORMULA, C_BREAK_COMP_DISPFORMULA, NET_QTY_DETAILFORMULA, AVAIL_QTYFORMULA, C_COMPONENT_SORTFORMULA, ZEROFORMULA, and C_BREAK_ASSY_DISPFORMULA. The widely searched C_BREAK_DATE_REQUIREDFORMULA (declared on line 86) takes a DATE_REQUIRED input and returns a DATE; its purpose is to produce the break-group value for the requirement date used in hierarchical or grouped report sections, so that the XML layout can correctly segment output by required date.

Tables Accessed

The ETRM metadata for this package does not enumerate specific base tables accessed through APPS synonyms. In practice, a discrete job open-requirements report of this class draws on Work in Process and Materials Planning views such as WIP_DISCRETE_JOBS, WIP_REQUIREMENT_OPERATIONS, WIP_ENTITIES, MTL_SYSTEM_ITEMS, and related supply/demand views. Because no table list is documented, the exact access set should be confirmed against the packaged body source in the target environment.

Usage Notes

This package is invoked indirectly by the Oracle Reports/XML Publisher concurrent program it supports; it is not intended to be called from custom code, and no other package references it (referenced by 0 other packages per ETRM). Changes should be treated as patch-level modifications only. The $Header line (WIPDJORQS.pls 120.1) indicates a 2008 baseline that persists across 12.1.1 and 12.2.2, so behavior is consistent between those releases.