Search Results ap_aid_table_handler_pkg




Overview
Explore in AI Chat

Overview

AP_AID_TABLE_HANDLER_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema. Its object name embeds the abbreviation "AID," which within the Payables module corresponds to AP Invoice Distributions. The package therefore serves as a low-level table handler whose purpose is to encapsulate the standard Data Manipulation Language operations required to maintain rows in the invoice distributions tables. Rather than exposing table access directly to forms, concurrent programs, or custom extensions, the E-Business Suite development framework routes inserts, updates, and deletions of invoice distribution records through this package. This design isolates the physical table structure from application logic and centralises the routine maintenance operations performed against the distributions entity.

Key Procedures and Functions

The ETRM metadata documents three procedures within AP_AID_TABLE_HANDLER_PKG. Each represents a discrete DML operation against the handler's underlying tables.

  • INSERT_ROW — Creates a new row in the invoice distributions table. This procedure is the entry point used when a new distribution line must be created for an invoice, supplying the column values required to establish the record.
  • UPDATE_ROW — Modifies an existing invoice distribution row. It is invoked when distribution attributes require amendment after the row has been created, such as adjustments to amounts or account assignments.
  • DELETE_ROW — Removes an existing invoice distribution row, typically during invoice revalidation, correction, or reversal processing when a distribution is no longer required.

The presence of these three procedures indicates a conventional table handler pattern, where each documented operation maps directly to one of the three core DML verbs. No parameter lists are exposed in the available documentation, and the metadata lists only these three procedures.

Tables Accessed

The documented table references, resolved through APPS synonyms, are AP_INVOICE_DISTRIBUTIONS and AP_INVOICE_DISTRIBUTIONS_S. AP_INVOICE_DISTRIBUTIONS is the principal transactional table storing invoice distribution lines within Payables. AP_INVOICE_DISTRIBUTIONS_S is the corresponding sequence-backed or shadow table commonly used in the EBS table handler pattern to support row identifier generation and concurrency handling. The handler reads, inserts, updates, and deletes against these objects as part of its three documented procedures. This narrow table footprint confirms the package's role as a dedicated maintenance utility for the invoice distributions entity rather than a broader business-logic unit.

Usage Notes

AP_AID_TABLE_HANDLER_PKG is an internal E-Business Suite component rather than a published API; the ETRM classification records it as OTHER. The dependency information shows it is referenced by AP_INVOICE_DISTRIBUTIONS_PKG, meaning the higher-level distributions package consumes this handler to perform its own record maintenance. This layered relationship is typical of the EBS architecture, in which a business package delegates physical DML to a handler package. Because the handler is invoked indirectly, customizations and extensions should interact with AP_INVOICE_DISTRIBUTIONS_PKG or the supported invoice APIs rather than calling AP_AID_TABLE_HANDLER_PKG directly. Direct invocation carries risk because the package operates below the business validation layer and does not enforce the rules applied by the consuming distributions package. The object is documented as VALID in both Oracle EBS 12.1.1 and 12.2.2, and its dependency on SYS.STANDARD reflects the standard PL/SQL environment common to both releases.