Search Results qty_precision

Overview

WIP_COMMON_XMLP_PKG is a shared PL/SQL utility package body owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. Although its name follows the convention used by Oracle XML Publisher (XMLP) report-specific packages, this package functions as a common formatting helper for Work in Process (WIP) and related manufacturing reports and programs. Its single documented function, GET_PRECISION, translates a stored quantity precision value into an Oracle number format mask. This is a routine requirement in WIP output: shop floor travelers, job and schedule reports, transaction registers, and material issue documents must display quantities with the same number of decimal places configured in the inventory or unit of measure setup. Centralizing that mapping in one package avoids duplicating the DECODE or IF/ELSIF logic across dozens of reports, ensuring consistent rendering of quantities across the manufacturing and inventory modules.

Key Procedures and Functions

The package exposes one documented function:

• GET_PRECISION — Accepts a numeric quantity precision and returns a VARCHAR2 format mask suitable for use with TO_CHAR or an Oracle Reports/BI Publisher format field. Based on the documented source, the mapping is: precision 0 returns '999G999G999G990'; precision 1 returns '999G999G999G990D0'; precision 3 returns '999G999G999G990D000'; precision 4 returns '999G999G999G990D0000'; precision 5 returns '999G999G999G990D00000'; precision 6 returns '999G999G999G990D000000'; and any other value (including 2) returns the default '999G999G999G990D00'. The 'G' character represents the group separator and 'D' the decimal separator, both resolved at runtime from the session's NLS_NUMERIC_CHARACTERS setting, which keeps formatting locale-correct.

No other procedures or functions are documented in ETRM for this package, and it contains no private helper routines visible in the metadata.

Tables Accessed

WIP_COMMON_XMLP_PKG does not reference any tables, views, or APPS synonyms. It is a pure formatting package: the quantity precision value is supplied by the caller, normally from a source such as MTL_UNITS_OF_MEASURE or an inventory item attribute that the calling report has already queried. This stateless, table-free design makes the package cheap to invoke and safe to call repeatedly from report data model triggers or formula columns.

Usage Notes

WIP_COMMON_XMLP_PKG is referenced by eight other packages in the APPS schema, confirming its role as a shared dependency rather than a standalone entry point. Typical invocation patterns include:

• Inside the data model or formula columns of WIP concurrent XML Publisher reports, where the returned mask is passed to TO_CHAR for quantity fields.
• From other APPS packages and report-specific XMLP packages that need to honor the organization's quantity precision without re-implementing the mapping.
• From custom extensions or report copies that follow Oracle's XML Publisher conventions and call WIP_COMMON_XMLP_PKG.GET_PRECISION directly.

Because the function is deterministic with respect to its input and returns a constant string for each precision value, it is well suited to being called per row. Developers should note that the default branch covers precision 2 as well as any unexpected value, so an out-of-range precision passed by custom code will silently fall back to two decimals rather than raising an error. The package carries a 2008 header ($Header: WIPCOMMONB.pls 120.1) and the 'noship' designation, indicating it is a compiled database object shipped with the product and not intended to be modified. In 12.1.1 and 12.2.2 the behavior is identical; no Online Patching editioning differences apply to this read-only utility.