Search Results get_multi_svc_profile

Overview

IBE_QUOTE_MISC_PVT is a private PL/SQL package in the APPS schema that provides shared utility logic for the Oracle iStore (IBE) quote-management subsystem. In Oracle EBS 12.1.1 and 12.2.2, the package acts as an internal helper layer supporting quote creation, retrieval, validation, and checkout processing. It is classified as a PVT (private) API, indicating that it is not intended as a public integration interface; it exists to be called by other packages within the iStore quoting stack.

The package bridges iStore's web-facing quote flows with the Oracle Advanced Supply Chain / Order Capture quoting data model (the ASO_* tables) and Oracle Trade Management quote entities. It centralizes reusable operations such as resolving the user's active quote, validating whether a quote may still be used, gathering header and line records, and assembling pricing and attribute collections consumed by presentation and checkout logic.

Key Procedures and Functions

The package exposes 44 documented procedures and functions. The principal ones include:

• GET_MULTI_SVC_PROFILE — retrieves multi-service profile information relevant to quote handling.
• IS_QUOTE_USABLE — validates whether a given quote is in a state that permits further operation or checkout.
• GET_ACTIVE_QUOTE_ID — resolves the currently active quote for a user or session context.
• GET_NUMBER_OF_LINES — returns the line count for a quote.
• GET_QUOTE_STATUS — obtains the status of a quote.
• GETLINEINDEXFROMLINEID — maps a line identifier to its index within a line collection.
• GETQUOTELASTUPDATEDATE — returns the last-updated timestamp of a quote.
• GETLINEPRCATTRTBL, GETLINEATTREXTTBL, GETLINEDETAILTBL, GETLINERELATIONSHIPTBL, GETLINEPRCADJTBL, GETHDRPRCADJTBL, GETALLLINESPRCADJTBL, GETLINEPRCADJRELTBL — build collection tables of line price attributes, attribute extensions, line details, line relationships, line-level and header-level price adjustments, and price-adjustment relationships.
• GETPRCADJINDEXFROMPRCADJID — maps a price-adjustment identifier to its index in a collection.
• GETLINETBL, GETLINEREC, GETHEADERREC, GETHEADERPAYMENTTBL — retrieve line collections, individual line records, header records, and header payment collections.

These routines rely on FND_API for standard API error handling and on typed collection structures such as JTF_NUMBER_TABLE and JTF_VARCHAR2_TABLE_100.

Tables Accessed

Documented dependencies include ASO_QUOTE_HEADERS, ASO_QUOTE_HEADERS_ALL, ASO_QUOTE_LINES, ASO_QUOTE_LINE_ATTRIBS_EXT, ASO_QUOTE_LINE_DETAILS, ASO_QUOTE_STATUSES_B, ASO_PRICE_ADJUSTMENTS, ASO_PRICE_ADJ_RELATIONSHIPS, ASO_PRICE_ATTRIBUTES, ASO_LINE_RELATIONSHIPS, ASO_PAYMENTS, IBE_ACTIVE_QUOTES, FND_USER, HZ_PARTIES, and HZ_RELATIONSHIPS. These reads support header/line retrieval, pricing, payment, party, and active-quote resolution. The package also calls ASO_QUOTE_PUB for public quote operations.

Usage Notes

IBE_QUOTE_MISC_PVT is referenced by seven sibling packages, including IBE_ONECLK_PVT, IBE_ORD_ONECLICK_PVT, IBE_QUOTE_CHECKOUT_PVT, IBE_QUOTE_SAVESHARE_PVT, IBE_QUOTE_SAVESHARE_V2_PVT, IBE_QUOTE_SAVE_PVT, and IBE_SHOP_LIST_PVT. It should therefore be treated as an internal implementation dependency rather than a supported public API; customizations should avoid direct calls and instead use the public packages that invoke it.