Search Results get_blanket_line_id

Overview

OE_BLANKET_PRICING_UTIL is a utility PL/SQL package owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It is classified in the ETRM repository as a UTIL object, indicating that it provides shared helper logic rather than a public, standalone business API. Its functional remit is the pricing infrastructure that underpins blanket sales agreements: it validates whether a customer-facing price list is associated with blanket pricing, creates and maintains pricing modifiers, deactivates pricing entities, resolves internal identifiers for blanket headers and lines, and derives released amounts and quantities against blanket lines.

The package therefore sits between the Order Management (OE) schema objects that store blanket sales agreements and the Advanced Pricing (QP) schema objects that store price lists, list lines and pricing attributes. It is not a transaction-entry API; it is the glue that keeps blanket agreement pricing consistent with the pricing model when agreements are created, revised, cancelled or referenced by downstream ordering flows.

Key Procedures and Functions

• IS_BLANKET_PRICE_LIST — Determines whether a given price list qualifies as a blanket price list, allowing callers to branch their processing based on how the list is used.
• CREATE_MODIFIERS — Creates the pricing modifiers (adjustments) required by a blanket agreement, writing the corresponding pricing list and list line structures.
• DEACTIVATE_PRICING — Deactivates the pricing constructs associated with a blanket agreement, typically invoked when the agreement is cancelled, closed, or otherwise no longer eligible for pricing.
• GET_BLANKET_HEADER_ID — Returns the identifier for a blanket agreement header, used to resolve the OE-side key from the calling context.
• GET_BLANKET_LINE_ID — Returns the identifier for a blanket agreement line, used for line-level processing and cross-referencing.
• GET_LIST_LINE_ID — Returns the QP list line identifier associated with a blanket line, bridging the OE and QP data models.
• GET_BLANKET_REL_AMT — Derives the released amount at the blanket agreement level, supporting commitment and utilisation reporting.
• GET_BL_LINE_REL_AMT — Derives the released amount for a specific blanket line.
• GET_BL_LINE_REL_QTY — Derives the released quantity for a specific blanket line.

Tables Accessed

The package operates exclusively through APPS synonyms. On the Order Management side it reads and writes OE_BLANKET_HEADERS, OE_BLANKET_HEADERS_ALL and OE_BLANKET_HEADERS_EXT, together with OE_BLANKET_LINES and OE_BLANKET_LINES_EXT, to resolve header and line identifiers and to accumulate released amounts and quantities. On the Advanced Pricing side it works with QP_LIST_HEADERS and QP_LIST_LINES, where the price list and list line records are created and deactivated, and with QP_PRC_CONTEXTS_B and QP_PTE_SEGMENTS, which supply the pricing context and attribute segmentation needed to build correct modifiers. The PLITBLM table supplies the translated list-line descriptive information used when constructing pricing records.

Usage Notes

Because the package is classified as a utility and is referenced by OE_BLANKET_UTIL and OE_DELAYED_REQUESTS_PVT, it is normally invoked indirectly. The principal entry points are Order Management forms and concurrent programs that capture or revise blanket sales agreements, plus the delayed-request processor that handles pricing work asynchronously. Customisations should call the packaged functions rather than manipulating OE_BLANKET_* or QP_LIST_* tables directly, since the package encapsulates the required join between agreement lines and pricing list lines. No parameter lists are documented in the ETRM repository for this object; implementers should inspect the package specification in the target instance before calling it from bespoke code.