Results for “fnd_attachments”

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

Overview

AP_AI_TABLE_HANDLER_PKG is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. The prefix "AP_AI" associates it with the Payables Application Accounting Intelligence (AI) layer, which supports diagnostic and table-level access for invoice entry and invoice-related DML within the Payables module. The package provides a controlled Data Manipulation Language (DML) interface for core invoice tables, allowing an internal component or API layer to insert, update, and delete rows against the underlying Payables base tables without directly issuing DML from every caller. In the ETRM documentation the API is classified as "OTHER", indicating that it is an internal, non-public utility rather than a formally published open interface or public API. Despite this classification, AP_AI_TABLE_HANDLER_PKG is a VALID compiled object and forms part of the standard APPS dependency chain.

Key Procedures and Functions

The documented package exposes three procedures, each mapping to a standard DML operation:

• INSERT_ROW — Creates a new row in the target invoice-related table, populating the columns supplied by the caller and applying any required default or WHO-column handling.
• UPDATE_ROW — Modifies an existing row in the target table, updating the identified columns and preserving the remaining column values.
• DELETE_ROW — Removes an existing row from the target table, typically invoked after referential or business-rule validation has been satisfied.

No parameter lists are published in the available metadata; only the procedure names and their DML intent are documented. The procedures are intended to centralize row-level operations on the underlying invoice tables so that a single package governs how those tables are written to.

Tables Accessed

Because the user query referenced AP_INVOICES_S, that table is the most prominent of the objects handled by this package. AP_INVOICES_S is the sequenced/invoice keyed table that participates in the AP invoice schema alongside AP_INVOICES and AP_INVOICES_ALL. The documented dependency list shows the package reading and writing, in whole or in part, the following objects through APPS synonyms:

• AP_INVOICES, AP_INVOICES_ALL, and AP_INVOICES_S — core invoice header rows and their keyed representation.
• AP_HISTORY_INVOICES_ALL — historical invoice records retained for audit and inquiry.
• AP_INVOICE_DISTRIBUTIONS_ALL, AP_INVOICE_LINES_ALL, and AP_PAYMENT_SCHEDULES_ALL — invoice distribution, line, and payment schedule detail.
• AP_HOLDS_ALL — invoice holds applied to prevent or allow payment.
• AP_SELF_ASSESSED_TAX_DIST_ALL — self-assessed tax distribution records.
• AP_SUPPLIER_SITES_ALL — supplier site reference data used when inserting or updating invoice rows.

These tables constitute the full invoice data model, confirming that the package operates at the heart of Payables invoice maintenance rather than on peripheral entities. Dependencies also include FND_API, FND_MESSAGE, FND_ATTACHED_DOCUMENTS2_PKG, APP_EXCEPTION, AP_DBI_PKG, AP_ETAX_UTILITY_PKG, GL_CA_UTILITY_PKG, and ZX_API_PUB.

Usage Notes

AP_AI_TABLE_HANDLER_PKG is an internal utility. It is invoked by packaged code within the AI diagnostic framework rather than directly by end users. Typical invocation paths include AI-driven diagnostics or forms-based maintenance that need to persist row-level changes against the AP invoice tables while reusing a single, validated DML path. The package is referenced by one other package, and the ETRM metadata states that it is not referenced by any database object itself, although it calls into the AP, FND, GL, and ZX packages listed above. Because it performs direct DML and is not part of the supported public API surface (it is not AP_INVOICES_PKG or a related public interface), customizations should not target AP_AI_TABLE_HANDLER_PKG directly. Use the supported public invoice APIs for integration work, and treat this package as an internal implementation detail supporting the invoice table handler functionality in Release 12.