Search Results initialize_om_rec_types

Overview

ASO_ORDER_INT is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM as an OTHER API rather than a fully public interface. It provides the internal integration layer between Oracle Order Management and Oracle Advanced Pricing / Quoting (ASO) records, allowing order headers and lines to be created, updated, booked, cancelled, and interrogated programmatically. The package operates against the Order Management open interface model, exposing strongly typed record structures such as Order_Header_Rec_Type and Order_Line_Rec_Type that mirror the order header and line columns. Each attribute in these records defaults to FND_API.G_MISS_NUM or FND_API.G_MISS_CHAR, the standard EBS convention signalling "attribute not supplied," so callers may pass partial records without overwriting existing values. Because ASO_ORDER_INT is referenced by thirty-three other packages and is not classified as a public API, it is best understood as a shared internal service consumed by quoting and order-management modules rather than a customer-facing entry point.

Key Procedures and Functions

The documented interface comprises seventeen procedures and functions. The transactional core is CREATE_ORDER, UPDATE_ORDER, and DELETE_ORDER, which manage the lifecycle of an order record, followed by BOOK_ORDER and CANCEL_ORDER for status transitions. Status inspection is handled by GET_HEADER_STATUS and GET_LINE_STATUS, which return the current state of an order header or line. Pricing calculations are provided by TOTAL_ORDER_PRICE, TOTAL_LIST_PRICE, and GET_ORDER_TOTAL, which derive monetary totals from the order and pricing data. Customer-related lookups are served by GET_ACCT_SITE_USES and GET_CUST_ACCT_ROLES, which retrieve account site usage and customer account role information. SALESREP_ID and SERVICE_INDEX resolve sales-representative and service reference values. The procedure named in the search term, INITIALIZE_OM_REC_TYPES, initialises the Order Management record type structures used by the package, seeding the strongly typed records to their G_MISS default state so that callers can populate only the attributes of interest before invoking the transactional procedures.

Tables Accessed

Through APPS synonyms the package reads and writes ASO_QUOTE_HEADERS_ALL, the quote header table central to the ASO quoting model. Customer master data is resolved through HZ_CUST_ACCOUNTS, HZ_CUST_ACCOUNT_ROLES, HZ_CUST_ACCT_SITES_ALL, HZ_CUST_SITE_USES_ALL, HZ_ORG_CONTACTS, HZ_PARTIES, HZ_PARTY_SITES, HZ_RELATIONSHIPS, and HZ_ROLE_RESPONSIBILITY, reflecting the package's need to obtain account sites, contacts, party relationships, and role responsibilities when building or validating an order. AMS_DELIVERABLES_ALL_B supplies deliverable definitions, and PLITBLM is referenced as part of the standard EBS concurrency and record-handling infrastructure. Together these tables support the order header and line lifecycle, customer party validation, and price and total derivation.

Usage Notes

ASO_ORDER_INT is typically invoked indirectly, by Oracle Quoting and Order Management forms, concurrent programs, and other internal packages that must create, update, book, or cancel ASO orders programmatically. Custom code that calls the package directly must first invoke INITIALIZE_OM_REC_TYPES to obtain valid record structures initialised to FND_API.G_MISS defaults, then populate only the required attributes for the intended operation. Because the package is registered as OTHER rather than a public API, its signatures are not guaranteed by Oracle support policy, and any direct use should be treated as a supported-exception risk requiring regression testing across 12.1.1 and 12.2.2 upgrades.