Search Results oe_order_import_specific_pvt




Overview
Explore in AI Chat

Overview

OE_INLINE_CUSTOMER_PUB is a public PL/SQL package in the Oracle E-Business Suite Order Management (OE) module, owned by the APPS schema. Its stated purpose, per the embedded source comments, is Order Import customer creation. The package provides an application programming interface that allows Order Import processing to create and delete customer information inline — that is, during the same processing cycle in which order headers, lines, and related interface records are being validated and moved into the transactional tables. The header identifies the package as version 1.0, with a source file header dating to 2008 and carrying a 120.1.12010000.1 revision stamp, which places the code lineage within the EBS 12.1.x family and carried forward into 12.2.2. The package is classified as PUB, meaning it is intended for supported external invocation rather than as a private helper.

Key Procedures and Functions

The ETRM metadata documents two procedures, and no public functions.

  • CREATE_CUSTOMER_INFO — Creates customer information for use during Order Import. The source excerpt shows that it accepts an inbound customer-information reference and type code, a usage indicator, and optional values for original system document reference, original system line reference, order source, and organization. It returns the newly created customer information identifier, the corresponding customer information number, and a return status output indicating success or failure. This is the primary entry point for inline customer creation.
  • DELETE_CUSTOMER_INFO — Removes customer information that was previously staged or created. It operates on a header-level customer record and a collection of line-level customer records, both typed using structures defined in OE_ORDER_IMPORT_SPECIFIC_PVT (Customer_Rec_Type and Customer_Tbl_Type). This supports cleanup or rollback semantics within the Order Import flow.

Tables Accessed

The package references the following tables through APPS synonyms, reflecting its dual responsibilities of reading trading-partner and system setup data and writing Order Import interface records.

Usage Notes

OE_INLINE_CUSTOMER_PUB is invoked as part of the Order Import workflow, which is driven by the Order Import concurrent program and the underlying OE_ORDER_IMPORT_SPECIFIC_PVT logic. It is not typically called directly from an Oracle Forms UI; instead it is referenced by other PL/SQL packages that orchestrate order import and by the import processing framework itself. The metadata indicates the package is referenced by two other packages, consistent with its role as a reusable customer-creation service. Custom integrations that build or stage records in the OE interface tables should treat CREATE_CUSTOMER_INFO and DELETE_CUSTOMER_INFO as the supported API surface, respecting the p_customer_info_type_code and p_usage inputs to control whether a new customer is created or matched. Because the package writes into interface tables, subsequent execution of the Order Import concurrent program is required to transfer staged customer and order data into their final transactional destinations. The x_return_status output should always be checked before continuing, as the procedure reports failures through that parameter rather than by raising exceptions.