Search Results qp_number




Overview
Explore in AI Chat

Overview

QP_NUMBER is an Oracle E-Business Suite PL/SQL package owned by the APPS schema. Within the Oracle Advanced Pricing (QP) module, it provides the canonical numbering and internal number-conversion utilities used when constructing, storing, and interpreting pricing entities such as price lists, modifiers, qualifiers, and related identifiers. The package encapsulates the mapping between the human-facing canonical representation of a number or identifier and the internal format used by the pricing schema, insulating callers from the underlying encoding rules. Its status is VALID in both Oracle EBS 12.1.1 and 12.2.2, and its API classification in the ETRM documentation is recorded as OTHER, indicating that it is an internal utility package rather than a public, externally supported application programming interface.

Key Procedures and Functions

The ETRM metadata documents four procedures and functions in QP_NUMBER. Parameter lists are not published and are therefore not reproduced here.

  • CANONICAL_TO_NUMBER — Converts a canonical (external/display) number representation into the internal numeric form expected by pricing processing. It is the inbound half of the package's conversion pair.
  • NUMBER_TO_CANONICAL — Performs the inverse conversion, translating an internal numeric value back into its canonical representation suitable for display, comparison, or external reference.
  • TEST — A validation/diagnostic entry point used to exercise the conversion logic. Consistent with the ETRM classification of OTHER, this is a test harness routine rather than a business-facing procedure.
  • INITIALIZE — A setup routine that establishes the package state required before the conversion routines are invoked, typically called at the beginning of a session or processing run.

Tables Accessed

The documented ETRM metadata for QP_NUMBER does not list any database tables referenced directly by the package. Its dependency record shows references to the APPS schema, to the package itself, and to the SYS.STANDARD package only. This is consistent with a pure conversion utility: the package operates on values passed to it rather than persisting rows of its own. Where pricing tables appear to be involved, the persistence is performed by the calling pricing packages, which pass the resulting canonical or numeric values into tables through their own DML. The package is documented as not referenced by any database object, meaning no other stored object has a compile-time dependency on QP_NUMBER.

Usage Notes

QP_NUMBER is an internal utility and should not be treated as a supported public API. It is documented as being referenced by twenty-five other packages, which confirms that it is invoked indirectly by the higher-level pricing packages that perform the business transactions of Oracle Advanced Pricing, and only rarely, if ever, from Oracle Forms or concurrent programs directly. Custom code should avoid direct calls to CANONICAL_TO_NUMBER, NUMBER_TO_CANONICAL, TEST, or INITIALIZE, because the conversion rules are implementation details of the pricing schema and may change between releases without notice. When custom logic must interpret pricing identifiers, the recommended approach is to use the documented public pricing APIs, which invoke QP_NUMBER internally, rather than replicating or bypassing the conversion logic. In 12.1.1 and 12.2.2 the package is VALID in the APPS schema, so any invocation occurs under standard APPS schema resolution; there is no evidence of a separate synonym or wrapper for external consumers.