Results for “ibe_ord_oneclick_pvt”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IBE_ORD_ONECLICK_PVT is a private PL/SQL package in the Oracle E-Business Suite iStore (IBE) module that implements the One-Click purchasing feature for registered customers. In the 12.1.1 and 12.2.2 releases the package is owned by APPS and classified as PVT, indicating it is an internal implementation unit rather than a public API intended for direct external calls. Its role is to persist, retrieve, and apply the stored preferences — freight terms, payment method, bill-to and ship-to addresses, and contact e-mail — that allow a returning customer to place an express order without re-entering order information on each visit.

The package also supports the express-buy checkout path, where quote data captured through the ASO Quote public structures is converted into a submitted sales order. The header comment reflects a fairly stable code line (version 120.2, dated 2005), which is consistent with the package functioning as foundational One-Click infrastructure that has been carried forward largely unchanged from 11i into the 12.x family.

Key Procedures and Functions

• GET_SETTINGS — Retrieves the stored One-Click configuration for a given party and account, returning the enabled flag, freight code, payment identifier, bill-to and ship-to party site identifiers, last update date, and notification e-mail address, along with the object version number used for optimistic locking.
• SAVE_SETTINGS — Creates or updates the One-Click configuration for a party/account combination using the standard PL/SQL API conventions (API version, initialization of message list, commit control, and validation level) and returns the standard return status, message count, and message data outputs.
• UPDATE_SETTINGS — Performs the modification path for existing One-Click records; a package constant, UPDATE_EXPRESSORDER (value 7), is declared alongside the specification and is associated with the express-order update operation.
• GET_EXPRESS_ITEMS_SETTINGS — Populates express checkout settings onto the quote header, payment, shipment, and tax detail PL/SQL table types defined in ASO_QUOTE_PUB, with a calling flag defaulting to the ITEMS mode.
• EXPRESS_BUY_ORDER — Executes the One-Click order placement, taking the stored preferences and cart/quote content and driving the order through the express checkout flow.
• GET_CREDIT_CARD_TYPE — Derives the credit card type from a supplied card number, used to validate and label stored payment instruments during express checkout.

Tables Accessed

The package reads and writes IBE_ORD_ONECLICK and its companion objects IBE_ORD_ONECLICK_ALL and IBE_ORD_ONECLICK_S1, which hold the persisted One-Click preferences and their multilingual and secondary index structures. Payment information is drawn from ASO_PAYMENTS, AP_BANK_ACCOUNTS, and PLITBLM (payment instrument reference data), while address and contact data come from HZ_PARTIES, HZ_CUST_ACCOUNTS, HZ_CONTACT_POINTS, and HZ_RELATIONSHIPS. Order content is carried through ASO_QUOTE_HEADERS, ASO_SHIPMENTS, and ASO_TAX_DETAILS, which the package populates so that the quote can be converted into an order.

Usage Notes

Because the package is marked PVT, it is not a supported integration entry point. It is invoked internally by the iStore One-Click user interface and the express checkout flow, and ETRM records it as referenced by two other packages, which are the typical callers. Customizations should target the public ASO_QUOTE_PUB and iStore order APIs instead of calling IBE_ORD_ONECLICK_PVT directly, since private package signatures can change between patch levels and are not covered by Oracle's public API compatibility guarantees. Functionality is effectively the same across 12.1.1 and 12.2.2, with any differences limited to underlying table or synonym changes introduced by the 12.2 Online Patching architecture.