Search Results create_payment_row

Overview

The ASO_PAYMENT_INT package is a public PL/SQL API within the Oracle E-Business Suite Order Capture / Quoting module (ASO schema). It provides the integration layer between Oracle Quoting (ASO) and the Oracle Payments (IBY) infrastructure, allowing payment instruments and payment terms associated with a quote header or quote line to be created, maintained, and reconciled programmatically. The package declared with AUTHID CURRENT_USER acts as a bridge that resolves the payment term identifier for a given quote context and that persists payment-related rows into the underlying ASO and IBY tables.

In Oracle EBS 12.1.1 and 12.2.2, the package supports the credit-card and payment-instrument workflow that governs how a quote captures funding details. A record type, CC_Trxn_Rec_Type, models the inbound credit-card transaction payload (merchant identifier, card number, expiration date, holder name, invoice-to address elements, tangible amount, currency, payment mode, settlement date, authorization type, and CVV2). A companion type, CC_Trxn_Out_Rec_Type, models the outbound response with status, error code, error message, transaction identifier and date, authorization code, and error location. These types define the contract used when payment-processing calls are made from Quoting.

Key Procedures and Functions

• GET_PAYMENT_TERM_ID — A function that returns a payment term identifier. It accepts a quote header identifier and a quote line identifier, resolving the applicable payment term for that context. This is the routine most frequently referenced when consumers need to determine which payment term governs a quote or line.
• CREATE_IBY_PAYMENT — A procedure that accepts a payment record and creates the corresponding payment entity through the Oracle Payments (IBY) integration path.
• CREATE_PAYMENT_ROW — Inserts a new payment row into the ASO payments tables.
• UPDATE_PAYMENT_ROW — Modifies an existing payment row previously persisted by the package.
• DELETE_PAYMENT_ROW — Removes a payment row from the ASO payment tables.
• PURGE_ASO_PAYMENTS_DATA — Cleanses orphaned or obsolete payment data associated with quotes.

Tables Accessed

The package reads and writes the following tables through APPS synonyms:

• ASO_PAYMENTS and ASO_PAYMENTS_S — Primary storage for quote-level payment records; the base table and its translation/child table are maintained by the create, update, delete, and purge routines.
• IBY_CREDITCARD — Holds credit-card instrument details referenced during IBY payment creation.
• IBY_EXTERNAL_PAYERS_ALL and IBY_PMT_INSTR_USES_ALL — Oracle Payments payer and payment-instrument-usage tables used when establishing the payment relationship.
• HZ_PARTIES — Provides party information for the payer associated with the payment.
• PLITBLM — A PL/SQL index-by or temporary structure used internally for bulk processing.

Usage Notes

ASO_PAYMENT_INT is typically invoked from Oracle Quoting forms and from the quote capture flows that interact with Oracle Payments. Because it is referenced by four other packages, it functions as a shared utility rather than a standalone entry point; custom code extending the quoting payment workflow should call the documented routines rather than manipulate ASO_PAYMENTS or IBY tables directly, to preserve data integrity across the ASO and IBY schemas. When customizing or integrating in 12.1.1 or 12.2.2, developers should note that GET_PAYMENT_TERM_ID is the documented accessor for payment-term resolution and should be preferred over direct table queries. As with any public API, the package signature must not be altered; extensions should be layered through supported hooks and concurrent-program wrappers.