Search Results chart_of_accounts_id_def




Overview
Explore in AI Chat

Overview

The APPS.WIP_WIPREDAT_XMLP_PKG package is a report logic package that supports the Oracle Work in Process "WIP Resource and Material Value Report" — internally identified by the short name WIPREDAT, reflected in the header comment "$Header: WIPREDATS.pls 120.1 2008/01/31 12:33:38 npannamp noship $". This report is an XML Publisher (XMLP) concurrent program used in discrete manufacturing environments to print detailed valuation information for assemblies, including material, resource, outside processing, and overhead costs and variances, for a given organization and date range.

The package is not a public API. It is a pure report-controller package: it declares the report's bind parameters, provides pre- and post-formatting logic, and supplies the limiter functions that conditionally suppress sections of the XML output so that blank or irrelevant blocks are not printed. It is classified under ETRM as "OTHER" and is owned by APPS. It is not referenced by any other packages, confirming its role as a leaf-level reporting component rather than a shared utility.

Key Procedures and Functions

The package declares eight documented procedures and functions. Their names, and the parameter context visible in the specification, indicate the following purposes:

  • BEFOREREPORT — Returns BOOLEAN. Executes before the report body is rendered, typically to initialize global variables, resolve the chart of accounts identifier, and prepare the data the report will consume.
  • AFTERREPORT — Returns BOOLEAN. Executes after the report body, used for cleanup and any final reconciliation of report-level state.
  • AFTERPFORM — Returns BOOLEAN. Executes after the Oracle Reports parameter form (PFORM) has been processed; it is the standard hook for validating and defaulting concurrent program parameters such as P_FROM_ASSEMBLY, P_TO_ASSEMBLY, and P_ORG_ID.
  • LINE_LIMITER — Returns CHARACTER. Controls whether the report's line-level (component/transaction) section is emitted.
  • ASSEMBLY_LIMITER — Returns CHARACTER. This is the function the user searched for. It controls whether the assembly-level section of the report is printed, a standard XML Publisher technique for conditionally hiding a repeating group when no data qualifies for the requested range.
  • FUS_DATE_LIMITER — Returns CHARACTER. Gates the "from/to start date" driven portion of the output, so the report can suppress date-based blocks when no date restriction is supplied.
  • C_STATUS_LIMITERFORMULA — Returns VARCHAR2. Non-XML report packages normally expose limiter functions as CHARACTER; this variant returns VARCHAR2 to serve as a status limiter formula, indicating the WIPREDAT report uses a status filter (see P_STATUS_LIMITER, VARCHAR2(240)).
  • GET_PRECISION — Returns VARCHAR2. Converts the numeric quantity precision parameter (P_QTY_PRECISION) into the format mask used for displaying quantities.

The package also declares numerous bind parameters, including P_CONC_REQUEST_ID, P_ORG_ID, P_COMPONENT_ITEM, P_FROM_ASSEMBLY, P_TO_ASSEMBLY, P_FROM_LINE, P_TO_LINE, P_FROM_START_DATE, P_TO_START_DATE, P_ITEM_GRP_BY, P_QTY_PRECISION, P_STATUS_LIMITER, and a set of account/valuation parameters (P_CMPL_LOCATOR, P_SUPPLY_LOCATOR, and the P_MTL_VAL_ACCT, P_RES_VAL_ACCT, P_OUT_PROC_VAL_ACCT, P_OH_VAL_ACCT, P_MTL_VARIANCE, P_STD_COST_VARIANCE, P_RES_VARIANCE, P_OUT_PROC_VARIANCE, P_OH_VARIANCE, P_MTL_OH_VAL_ACCT groups). CHART_OF_ACCOUNTS_ID_DEF holds the resolved chart of accounts identifier.

Tables Accessed

The provided ETRM extract contains no table list for this package; no base table or APPS-synonym references are documented. In EBS terms, a report package of this shape normally reads WIP and cost data — such as WIP_DISCRETE_JOBS, WIP_ENTITIES, WIP_TRANSACTIONS, and the MTL_ITEM/MTL_PARAMETERS family — through its underlying XML query rather than through direct references in the PL/SQL package body. Because the metadata does not enumerate tables, no specific table access can be asserted from the documentation provided.

Usage Notes

This package is invoked indirectly by the concurrent program for the WIP Resource and Material Value Report (short name WIPREDAT). It is not intended to be called from forms or custom PL/SQL. The limiter functions are referenced from the XML data template to conditionally render sections, and the two date, assembly, line, and status limiters act together to produce a report covering only the requested organizational, assembly, line, and date ranges. The P_DEBUG parameter suggests debug tracing can be enabled for troubleshooting. On both EBS 12.1.1 and 12.2.2, the file remains in the 120.1 version stream, indicating no functional change across those releases. Any customization should be avoided; instead, use the corresponding XML Publisher template and parameter configuration to alter report behavior.