Search Results p_from_job

Overview

CST_PAC_WIP_VALUE_REPORT_PVT is a private PL/SQL package owned by the APPS schema within the Oracle E-Business Suite Cost Management (CST) module. Its primary purpose is to support the "Periodic WIP Value Report," a concurrent program that presents work-in-process balances for a given PAC period, legal entity, and cost group. The package produces XML output consumed by the report rendering layer. As a PVT package, it is an internal implementation artifact rather than a public API; it is invoked indirectly through the concurrent program and is not intended for direct call from customer code.

The package addresses the periodic costing requirement to value open and closed discrete jobs within a PAC (Periodic Actual Cost) period. It supports two report modes defined by the report type parameter: period-to-date and cumulative. The user search term p_from_job corresponds to one of the report's filter parameters, allowing the caller to restrict report output to a range of job numbers, bounded by p_from_job and p_to_job.

Key Procedures and Functions

The package exposes four documented procedures and functions:

• GENERATE_XMLDATA — The main entry point, invoked by the concurrent request "Periodic WIP Value Report." It accepts a comprehensive set of IN parameters including report type, legal entity, cost group, cost type, PAC period, set of books, class type, the job range (p_from_job, p_to_job), the assembly range, currency information, and exchange rate details, and returns the standard concurrent program OUT parameters errbuf and retcode.
• PERIODIC_WIP_VALUE_RPT_DETAILS — Populates the detailed report data set, aggregating WIP balances and job-level values for the selected period and filters.
• GET_XMLDATA — Retrieves or constructs the XML payload from the populated data, formatting it for consumption by the report output engine.
• DISPLAY_PARAMETERS — Renders the parameters used for the report run, typically for inclusion in the report header.

Tables Accessed

The package reads from a broad set of Cost Management, WIP, and reference tables, accessed through APPS synonyms:

• WIP_DISCRETE_JOBS, WIP_ENTITIES, WIP_LINES — source job, entity, and operation line data.
• WIP_PAC_PERIOD_BALANCES, CST_WIP_PAC_PERIOD_BAL_TMP — periodic WIP balance figures and temporary staging of computed values.
• CST_PAC_PERIODS, CST_PAC_PROCESS_PHASES — PAC period definition and processing phases.
• CST_COST_GROUPS, CST_COST_TYPES, CST_LE_COST_TYPES, CST_COST_ELEMENTS — cost group, cost type, legal-entity cost type, and cost element metadata.
• MTL_SYSTEM_ITEMS_KFV, WIP_ACCOUNTING_CLASSES, MTL_PARAMETERS — item descriptions, accounting class validation, and organization parameters.
• FND_CURRENCIES — currency code validation for displayed amounts.

Usage Notes

CST_PAC_WIP_VALUE_REPORT_PVT is invoked exclusively through the "Periodic WIP Value Report" concurrent program. The p_from_job parameter is optional and defaults to NULL; when supplied, it constrains the report to jobs whose identifiers are greater than or equal to the specified value, working in conjunction with p_to_job. The metadata records that the package is referenced by zero other packages, confirming its role as a terminal, report-serving private unit rather than a shared library. Customizations should avoid direct invocation; supported extension points are the concurrent program's parameter form and its output template.