Search Results map_line_price_adj_rltn

Overview

ASO_MAP_QUOTE_ORDER_INT is an Oracle Application Object Library (APPS) PL/SQL package body within the Order Capture (ASO) module of Oracle E-Business Suite, valid across 12.1.1 and 12.2.2. Its principal business function is to map quotation data held in Oracle Quoting (ASO) into the structure required by Order Management (OE), enabling the conversion of a quote into a sales order. The package bridges the quoting and order fulfillment domains by resolving customer, contact, pricing, adjustment, sales credit, tax, lot/serial, and payment attributes from quote-side entities and translating them into the OE_ORDER_PUB API structures used to create and validate orders. In ETRM 12.2.2 it is classified as an API of type OTHER and is referenced by six other database objects. It is not referenced by any database object at the schema level, indicating it is an upper-layer integration utility rather than a low-level library.

Key Procedures and Functions

The documented package exposes seventeen procedures and functions that collectively perform the quote-to-order transformation. These are grouped as follows:

• MAP_QUOTE_TO_ORDER — the top-level driver that orchestrates mapping of an entire quote into order structures.
• Customer and contact resolution: GET_CUST_ACCNT_ID, GET_ACCT_SITE_USES, GET_CUST_ACCT_ROLES, GET_ORG_CONTACT, and GET_ORG_CONTACT_ROLE retrieve the customer account, site use, account role, and organization contact details required on the order header.
• Header price mapping: MAP_HEADER_PRICE_ATTR, MAP_HEADER_PRICE_ADJ, MAP_HEADER_PRICE_ADJ_ATTR, and MAP_HEADER_PRICE_ADJ_RLTN translate header-level price attributes, price adjustments, adjustment attributes, and adjustment relationships.
• Header sales credits: MAP_HEADER_SALES_CREDITS maps salesperson credit assignments to the order header.
• Line-level mapping: MAP_LINE_PRICE_ATT, MAP_LINE_PRICE_ADJ, and MAP_LINE_PRICE_ADJ_RLTN handle line price attributes, adjustments, and adjustment relationships.
• Line-level credits and details: MAP_LINE_SALES_CREDIT, MAP_LOT_SERIAL, and MAP_LINE_PAYMENTS map line sales credits, lot and serial number information, and payment details.

The package builds upon OE_ORDER_PUB, ASO_QUOTE_PUB, ASO_ORDER_INT, ASO_PARTY_INT, ASO_CHECK_TCA_PVT, ASO_UTILITY_PVT, and ASO_DEBUG_PUB, together with FND_API, FND_MSG_PUB, FND_MESSAGE, FND_GLOBAL, and FND_PROFILE for messaging, error handling, and environment context.

Tables Accessed

The package reads and writes quote and Trading Community Architecture (TCA) data through APPS synonyms. ASO_QUOTE_HEADERS_ALL provides the source quote header; ASO_TAX_DETAILS supplies tax information. Customer and party data are resolved from HZ_CUST_ACCOUNTS, HZ_CUST_ACCOUNT_ROLES, HZ_CUST_ACCT_SITES, HZ_CUST_SITE_USES, HZ_PARTIES, HZ_PARTY_SITES, HZ_RELATIONSHIPS, and HZ_ORG_CONTACTS. JTF_RS_SALESREPS_MO_V provides sales representative information for credit mapping. Order-side configuration is drawn from OE_ORDER_SOURCES and OE_TRANSACTION_TYPES_ALL. PLITBLM is used as a PL/SQL index-by table type utility. Additional dependencies include OE_ORDER_HEADERS_V, GL_SETS_OF_BOOKS, CSI_SYSTEMS_VL, OE_GLOBALS, and OE_ORDER_SCH_UTIL.

Usage Notes

ASO_MAP_QUOTE_ORDER_INT is typically invoked during quote-to-order conversion, when a user submits a quote for order creation from Oracle Quoting or through the Order Management integration flow. It is designed to be called programmatically from concurrent programs, workflow activities, or custom PL/SQL that requires quote-to-order mapping beyond standard seeded flows. Because it manipulates OE_ORDER_PUB structures, callers should invoke it within a properly initialized FND_GLOBAL session and should handle the FND_MSG_PUB message stack for errors. Its dependencies on ASO_CHECK_TCA_PVT and ASO_PARTY_INT confirm that TCA validation must pass before mapping succeeds. As it is referenced by six other packages, it functions as a reusable mapping layer rather than a standalone entry point.