Search Results request_price

Overview

QP_JAVA_ENGINE is a PL/SQL package in the APPS schema that belongs to the Oracle Advanced Pricing (QP) module of Oracle E-Business Suite. Its primary role is to support the Java-based pricing engine integration layer. Oracle Advanced Pricing evaluates pricing rules, modifiers, and qualifiers through a pricing engine; in EBS 12.1.1 and 12.2.2, a portion of that evaluation logic is exposed to and coordinated with Java-based components that perform high-volume pricing calculations. QP_JAVA_ENGINE serves as the database-side anchor for that coexistence, orchestrating calls and returning results that the Java pricing engine consumes. The package is classified as OTHER in the ETRM metadata, indicating it is not a formal public API but an internal engine-related utility. It carries a VALID status and is documented with a single exposed program unit, which suggests a narrow, focused interface rather than a broad functional surface. Both the package specification and package body exist, and the object is referenced by QP_JAVA_ENGINE itself, QP_PREQ_GRP, and QP_PREQ_PUB, indicating it is embedded within the pricing request processing chain rather than standing alone.

Key Procedures and Functions

The ETRM metadata documents one program unit within QP_JAVA_ENGINE:

• REQUEST_PRICE — The single documented entry point. Based on its name and the package context, REQUEST_PRICE is responsible for initiating a pricing request against the Java-backed pricing engine. It acts as the bridge that accepts a pricing context from the calling PL/SQL layer and routes it for evaluation, returning the negotiated or computed price outcome. No parameter list is documented, and none is asserted here; the procedure's purpose is the submission and retrieval of a price request within the Advanced Pricing evaluation flow.

No additional procedures or functions are recorded in the ETRM metadata for this package.

Tables Accessed

The documented table and object references for QP_JAVA_ENGINE include:

• FND_PROFILE_OPTIONS — Accessed via the FND_PROFILE dependency and documented as an APPS synonym reference. This is used to resolve profile option settings that govern pricing engine behavior and Java engine enablement, allowing the package to honour site-level configuration.
• QP_INT_PROFS_T — A pricing-related profile or interface structure referenced by the package, used in the context of pricing engine profile data.
• DBMS_UTILITY — The Oracle-supplied utility package, referenced for standard PL/SQL support operations such as error formatting or dependency resolution.
• PLITBLM — A PL/SQL internal table/collection construct referenced as part of the package's data handling.

The dependency listing further records references to FND_PROFILE and STANDARD, which are the profile access layer and the standard PL/SQL package respectively.

Usage Notes

QP_JAVA_ENGINE is an internal component and is not intended for direct invocation by end users or customizations. It is referenced by QP_PREQ_GRP, QP_PREQ_PUB, and by itself, confirming that it participates in the pricing request group and public pricing request processing paths. In practice, it is invoked indirectly when Advanced Pricing processes a pricing request that has been routed to the Java pricing engine. Typical triggers include pricing during order capture, quoting, and any concurrent or batch process that calls the pricing engine. Developers performing diagnostics on the "qp_preq_grp" search term should understand that QP_PREQ_GRP is a closely coupled sibling object that calls into QP_JAVA_ENGINE, and that troubleshooting pricing failures often requires inspecting both. Because the ETRM metadata exposes only REQUEST_PRICE and a limited dependency set, any customization should treat this package as an Oracle-owned internal object and avoid direct calls, relying instead on documented pricing public APIs such as QP_PREQ_PUB.