Results for “overhead_var”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.CST_PAC_WIP_VALUE_REPORT_PVT is a private (PVT-classified) PL/SQL package body in the Oracle E-Business Suite Cost Management (CST) module. Its primary business function is to generate the XML dataset that backs the Periodic Actual Costing (PAC) Work in Process (WIP) Value Report. The WIP Value Report provides cost accountants and manufacturing finance users with a period-end view of the value accumulated in discrete work in process jobs, broken down by cost element, accounting class, cost group, and PAC period. The package sits beneath a concurrent program that produces the report output, exposing the internal procedures that assemble report parameters, gather detail rows, and render the final XML document consumed by the report template engine. Because the package is classified as PVT, it is not an officially supported public API; it is an internal implementation artifact supporting a seeded Oracle report. In releases 12.1.1 and 12.2.2 the same package body (with header revision $Header: CSTPWVRB.pls 120.11 2010/08/31) is shipped, with the private procedures used by the concurrent manager to produce the structured XML output. A user searching for the term "material_var" typically reaches this object because the report surfaces material cost group variation values (for example, material usage variance and material rate variance components) against WIP jobs, and the XML element names emitted by the package reflect those material variance classifications.

Key Procedures and Functions

• GENERATE_XMLDATA — The main driver procedure. It accepts runtime logging flags and a large set of report parameters, then orchestrates the seeded helper routines to build the CLOB-based XML output for the report. It initializes the package name and logging constants, opens the XML document, and delegates to the subordinate procedures that produce the data sections.
• DISPLAY_PARAMETERS — A procedure dedicated to emitting the report input parameters into the XML output, so that the rendered report displays the run-time selection criteria (legal entity, cost type, PAC period, cost group, set of books, class type, job range, assembly range, currency, and exchange rate attributes).
• PERIODIC_WIP_VALUE_RPT_DETAILS — The procedure that extracts and formats the periodic WIP value detail rows. It is the core data-gathering routine that reads PAC period balances and WIP balancing data and converts them into XML fragment rows representing accumulated cost by element, including material variance amounts.
• GET_XMLDATA — A retrieval procedure that returns the assembled XML document (typically a CLOB) to the caller, allowing the concurrent program or report wrapper to consume the generated content.

Tables Accessed

The package reads and writes across the Cost Management, Work in Process, and FND reference schemas through APPS synonyms. The key documented tables include:

• CST_PAC_PERIODS, CST_PAC_PROCESS_PHASES, CST_WIP_PAC_PERIOD_BAL_TMP — the PAC period definition, phase tracking, and the temporary WIP period balance staging table where periodic actual cost balances are accumulated.
• WIP_PAC_PERIOD_BALANCES — the persistent periodic WIP balance table that supplies reported value amounts.
• WIP_DISCRETE_JOBS, WIP_ENTITIES, WIP_LINES — job, entity, and job line (operation/resource) data that supply job identification and detail.
• WIP_ACCOUNTING_CLASSES — the accounting class categorization applied to WIP balances.
• CST_COST_ELEMENTS, CST_COST_GROUPS, CST_COST_TYPES, CST_LE_COST_TYPES — cost element, cost group, cost type, and legal-entity cost type definitions that drive the cost element view, including the material cost element and its associated cost group variation.
• MTL_PARAMETERS, MTL_SYSTEM_ITEMS_KFV — inventory organization parameters and the item concatenated description view for item identification.
• FND_CURRENCIES — currency definitions used for reporting amounts in the requested currency.

Usage Notes

This package is invoked indirectly, not directly by end users. It is called by the concurrent program that runs the PAC WIP Value Report, which passes the parameter set received from the report submission form (legal entity, cost type, PAC period, cost group, set of books, class type, job range, assembly range, currency, inventory rate display flag, exchange rate type, and exchange rate). Because it is a PVT package with no documented public API classification, custom code should not call it directly; any programmatic reuse should be routed through supported Cost Management public APIs or through the seeded concurrent program. The package is not referenced by any other package per the ETRM metadata. Note that in R12.2.2 the Online Patching (editioning) architecture allows seeded PL/SQL objects to be editioned while the run-edition remains in use; Oracle's standard edtioning rules therefore apply to any custom extension layered around this package.