Search Results g_module

Overview

OKS_QP_PKG is a service contract pricing integration package in Oracle E-Business Suite that bridges the Service (OKS) and Advanced Pricing (QP) modules. Its primary responsibility is to support the pricing engine calls that determine charges, price adjustments, discounts, and modifiers applied to service contracts, subscription lines, and related covered items. The package acts as the OKS-side adapter to Oracle Advanced Pricing, populating pricing request records, invoking the QP pricing engine, and interpreting the returned pricing results for the service contract workflow. The package header declares the g_module global constant, constructed as 'oks.plsql.pricing.' || g_pkg_name || '.', which is used as the debug log prefix throughout the body, indicating the package operates in the pricing sub-domain of the OKS schema. The body shown originates from OKSRAQPB.pls version 120.17.12020000.3, dated 2013, consistent with the 12.1.1 and 12.2.2 code lines.

Key Procedures and Functions

ETRM documents four entry points for this package, all relating to pricing computation on service contracts:

• CALC_PRICE — The principal pricing routine. It assembles the pricing request for a contract or line, calls the Advanced Pricing engine (QP), and writes back the resulting prices and adjustments. It is the function most commonly invoked by concurrent pricing processes and contract forms.
• CALC_PRICE_PRE — A pre-processing hook executed before the main pricing call, used to set up qualifiers, pricing attributes, and context values required by the pricing engine.
• CALC_PRICE_POST — A post-processing hook executed after the main pricing call, used to persist or reconcile the pricing results back to the service contract structures, including price adjustments and price breaks.
• DELETE_LOCKED_PRICEBREAKS — Removes price break records that are locked and therefore no longer editable by the pricing engine, preventing stale price breaks from being re-applied during recalculation.

The source excerpt additionally shows helper logic such as check_hdr_discount (determines whether any price adjustments exist for a contract header) and modifier_4_usg (handles modifier processing for usage), both of which support the pricing flow but are not part of the documented four APIs.

Tables Accessed

The package reads and writes across Service, Order Capture, Pricing, Installed Base, and Trading Community tables, reflecting the breadth of the pricing calculation:

• Service contracts: OKC_K_HEADERS_ALL_B, OKC_K_LINES_B, OKC_K_ITEMS, OKC_K_PARTY_ROLES_B, OKS_K_LINES_B, OKC_GOVERNANCES — the contract header, line, item, party role, and governance records being priced.
• Pricing: OKC_PRICE_ADJUSTMENTS, QP_LIST_LINES, OKS_QUALIFIERS — price adjustment records, price lists, and qualifiers consulted or written during pricing.
• Installed Base: CSI_ITEM_INSTANCES, CSI_I_PRICING_ATTRIBS — installed instance and its pricing attribute values used as pricing context.
• Customer: HZ_CUST_ACCOUNTS_ALL, HZ_CUST_ACCT_SITES_ALL, HZ_CUST_SITE_USES_ALL — customer, site, and site-use context for pricing qualifiers.
• Inventory: MTL_SYSTEM_ITEMS — item master attributes for the items being priced.

Usage Notes

OKS_QP_PKG is invoked from the Service Contracts forms and from concurrent pricing programs whenever a contract, subscription, or service line requires (re)pricing. ETRM records that it is referenced by 16 other packages, confirming it as a central pricing utility rather than a leaf module. Common invocation paths include the Service Contracts authoring UI, the pricing concurrent request, and custom extensions that call CALC_PRICE after modifying contract qualifiers. Because the package depends on fnd_log and fnd_msg_pub, debug logging can be enabled via the standard FND profile options (FND_DEBUG / runtime level) to trace pricing execution through the g_module prefixed log strings. The presence of both PRE and POST hooks means the pricing cycle must be treated as a three-phase operation when calling the package from custom code.