Search Results get_lse_source_value

Overview

OKC_PRICE_PVT is a private PL/SQL package in the Oracle E-Business Suite Contracts (OKC) module, owned by APPS and classified as a PVT (private) API. It provides the internal pricing engine that bridges Oracle Contracts and Oracle Advanced Pricing (QP). Its principal responsibility is to build the pricing context for contract lines and price elements, invoke the QP pricing engine to derive list and negotiated prices, and then persist the resulting price adjustments back into the OKC pricing tables.

The package defines several PL/SQL record types that carry pricing data through this flow. GLOBAL_LSE_REC_TYPE and GLOBAL_RPRLE_REC_TYPE map line style and rule values to QP qualifiers and pricing attributes, storing a current source object, a source value, and a lookup code. CLE_PRICE_REC_TYPE holds the calculated price for a priced line, including line identifier, quantity, unit of measure, currency, list price, unit price, negotiated amount, price list identifier, and pricing date. These structures confirm that the package operates on contract line level pricing rather than on the contract header as a whole.

Key Procedures and Functions

• GET_LSE_SOURCE_VALUE — resolves the source value for a line style element, used when mapping line style data to QP qualifiers and pricing attributes.
• GET_RUL_SOURCE_VALUE — resolves the source value for a rule, supporting the mapping of rule definitions to QP context.
• GET_PRLE_SOURCE_VALUE — resolves the source value for a price element or party role element within the pricing context.
• BUILD_CHR_CONTEXT — constructs the character (characteristic) context passed to the pricing engine for a contract line.
• BUILD_CLE_CONTEXT — constructs the line element context, assembling the qualifier and attribute values that Oracle Pricing requires to evaluate a price.
• GET_LINE_IDS — returns the identifiers of the lines to be processed during a pricing run.
• CALCULATE_PRICE — the core pricing routine; it submits the assembled context to the QP engine and retrieves list price and negotiated amounts for the line.
• UPDATE_CONTRACT_PRICE — writes calculated pricing results back at the contract level.
• UPDATE_LINE_PRICE — writes calculated pricing results back to the individual contract line.
• GET_MANUAL_ADJUSTMENTS — retrieves manual price adjustments defined or applied against a contract line, allowing manually entered discounts, surcharges, or overrides to be incorporated into the final negotiated price alongside adjustments returned by Oracle Pricing.

Tables Accessed

The package reads and writes contract structures including OKC_K_HEADERS_B, OKC_K_ITEMS, OKC_K_LINES_B, and OKC_K_PARTY_ROLES_B, which supply the header, line, item, and party role data that form the pricing context. OKC_GOVERNANCES, OKC_RULES_B, and OKC_RULE_GROUPS_B provide the governance and rule definitions that map to QP qualifiers. OKC_PRICE_ADJUSTMENTS, OKC_PRICE_ADJ_ASSOCS, and OKC_PRICE_ADJ_ATTRIBS store the price adjustments, their associations, and their attributes; these are the tables read by GET_MANUAL_ADJUSTMENTS and written during line and contract price updates. JTF_OBJECT_USAGES and the PLITBLM table support the pricing engine invocation and context resolution.

Usage Notes

Because OKC_PRICE_PVT is a private package, it is not a supported integration point and should not be called directly from custom code. It is invoked internally when contract pricing is calculated — typically from the Contracts authoring forms, from pricing-related concurrent programs, or from other OKC packages that require contract line prices. The metadata indicates it is referenced by three other packages, all of which rely on it for the shared pricing workflow. Customizations that need to observe or adjust manual adjustments should prefer supported public APIs or the OKC pricing adjustment tables, since the internal signatures and behavior of OKC_PRICE_PVT may change between releases without notice.