Search Results make_incomplete

Overview

ARP_PROCESS_LINE is a stored PL/SQL package owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It belongs to the Oracle Receivables (AR) module and provides the core line-level processing logic used by the AutoInvoice and receipt application infrastructure. Its primary business function is to perform DML operations against customer transaction lines, memo lines, and their associated accounting distributions during transaction creation, adjustment, and reversal. The package is classified as a low-level internal API (API classification: OTHER) and is not intended for direct external invocation, but rather serves as a shared subroutine layer for higher-level Receivables processing packages.

Key Procedures and Functions

The ETRM documentation records four callable units within this package:

• INSERT_LINE — Creates a new transaction line record, establishing the line-level data and any dependent distribution or memo records required for a newly generated Receivables transaction.
• UPDATE_LINE — Modifies an existing transaction line, applying changes to line attributes and synchronizing dependent distribution and memo rows.
• DELETE_LINE — Removes a transaction line and its dependent records, supporting transaction maintenance and cleanup operations.
• MAKE_INCOMPLETE — Marks a line as incomplete, flagging it for subsequent correction or review. This is typically used when mandatory validation fails, allowing the transaction to be saved in a recoverable state.

These four units constitute the complete documented public interface. No parameter lists are published in the ETRM metadata; consumers of this package should reference the live package specification for exact signatures, as the package is an internal dependency rather than a supported public API.

Tables Accessed

The package reads and writes the following documented tables via APPS synonyms:

• RA_CUSTOMER_TRX and RA_CUSTOMER_TRX_LINES — the transaction header and line tables, which hold the core receivable transaction data this package manipulates.
• RA_CUST_TRX_LINE_GL_DIST — the line-level accounting distributions generated and maintained alongside each line.
• RA_CUST_TRX_TYPES — the transaction type definition, used to determine applicable processing rules.
• AR_MEMO_LINES — memo line records associated with credit and debit memos.
• FND_CURRENCIES — currency definitions used for validation and conversion.
• GL_CODE_COMBINATIONS — the accounting flexfield combinations validated against distributions.
• AR_DEFERRED_LINES and AR_LINE_CONTS — deferred accounting line records and line-level contingency data, supporting revenue recognition and contingent revenue handling.

Usage Notes

ARP_PROCESS_LINE is referenced by four dependent packages: ARP_DELETE_LINE_COVER, ARP_INSERT_LINE_COVER, ARP_REVERSE_RECEIPT, and ARP_UPDATE_LINE_COVER. These cover routines act as wrappers that invoke the corresponding INSERT, UPDATE, and DELETE operations while applying Receivables business validation and event logic. The presence of ARP_REVERSE_RECEIPT as a dependent indicates that the package participates in receipt reversal processing, where reversing entries must generate compensating transaction lines. In practice, ARP_PROCESS_LINE is invoked indirectly through AutoInvoice import, the Receivables transactions form, and standard adjustment or reversal workflows; it is not intended to be called directly from custom code. Developers extending Receivables functionality should use the supported public APIs (such as AR_INVOICE_API_PUB) rather than this internal package, since its signature and behavior are not guaranteed across patches or releases.