Search Results is_count_processed




Overview
Explore in AI Chat

Overview

INV_INVRCWSR_XMLP_PKG is the generated PL/SQL package that backs the Oracle E-Business Suite concurrent program Inventory Replenishment Count Worksheet Report (short name INVRCWSR). It belongs to the Oracle Inventory (INV) product and is classified as a report XML Publisher (XMLP) support package, a category of APPS-owned packages that Oracle generates for reports driven by the XML Publisher engine. The package declares the report's global parameters, exposes the standard report trigger functions, and contains the column-level formulas (the CF_*FORMULA functions) that transform raw stored code values into user-readable text before the report data is rendered.

Functionally, the package supports the warehouse replenishment counting workflow: a count is created against a subinventory or a source organization, quantities are tracked, and the worksheet report presents each counted item together with its locator, PAR level, process status, source type, count type, and error conditions. The package itself performs no business transactions; it is a presentation and formatting layer that prepared data, derived queries, and computes display strings for a specific concurrent request.

Key Procedures and Functions

  • BEFOREREPORT — Report pre-processing trigger; performs setup and parameter normalization before the data model executes.
  • AFTERPFORM — Post-parameter-form trigger; executes after the user submits or closes the parameter form, typically to derive dependent parameters such as flexfield SQL strings.
  • AFTERREPORT — Report post-processing trigger; returns control after the report output is produced.
  • CF_LOCATORFORMULA — Resolves a locator ID and organization ID into the display description of the stock locator.
  • CF_PAR_LEVELFORMULA — Derives the PAR (periodic automatic replenishment) level for a given locator and item.
  • CF_ERRORFORMULA — Evaluates error code, process status, planning level, quantity-tracked flag, count type, and locator to produce the report's error indicator text.
  • CF_PROCESS_STATUSFORMULA — Converts a numeric process status code into its descriptive status label.
  • CF_SOURCE_TYPEFORMULA — Converts a numeric source type code into the corresponding source type description (for example inventory, supplier, or subinventory). This is the formula associated with the search term cf_source_typeformula.
  • CF_COUNT_TYPEFORMULA — Converts a numeric count type code into its descriptive label.
  • CF_SOURCE_ORG_CODEFORMULA — Resolves a source organization ID into the organization code displayed on the report.
  • IS_COUNT_PROCESSED — Determines whether a physical or replenishment count has already been processed, controlling report behavior or output.
  • SETUP_ERROR — Initializes or captures error state used by the report's error-handling logic.

The package also declares a substantial set of global variables prefixed with P_ that hold organization, header, subinventory, date, name, flexfield SQL, printer, and status literal values, including the status constants (hold, pending, processing, error, completed) and source type constants. These globals are populated from the concurrent program parameters and consumed by the formula functions.

Tables Accessed

  • FND_CONCURRENT_REQUESTS — The standard concurrent manager table, read to retrieve request-level information such as the concurrent request ID and request date used to populate the report header and global parameters.
  • MTL_SECONDARY_LOCATORS — The inventory table holding secondary locator definitions, referenced by the locator-oriented formula functions (notably CF_LOCATORFORMULA and CF_PAR_LEVELFORMULA) to resolve locator IDs into descriptive values.

Usage Notes

Oracle does not document this package as a public API, and it is not referenced by any other documented package. It is invoked exclusively in the context of its concurrent program: when the report is submitted from the Inventory responsibility, the concurrent manager calls the package's trigger functions and, for each report row, calls the appropriate CF_*FORMULA function to format column values. Custom code should not call these formulas directly, because their signatures and behavior are tied to the report definition and may change between releases or patches. The noship attribute in the source header confirms that this is a private, non-shippable support object; customizations that need replenishment count worksheet data should query the underlying Inventory tables (such as the count headers, count details, and item/locator tables) rather than depending on this package. Within a supported Oracle EBS 12.1.1 or 12.2.2 instance, the object is delivered as part of the INV product's APPS schema and should be treated as read-only reference material when troubleshooting report output.