Search Results check_unique_line

Overview

ARP_TRX_TAX_UTIL is a utility package in the Oracle Receivables (AR) module of Oracle E-Business Suite, owned by the APPS schema. It is classified as a UTIL (utility) package rather than a public API, meaning it is intended to support internal processing logic for transaction lines and their associated tax calculations. The package consolidates a set of helper routines used primarily by the Receivables transaction entry and maintenance flows, addressing line-numbering, item flexfield defaults, summary recomputation, uniqueness validation, deletion guards, and tax-code balance checks. Because it operates directly against the core Receivables transaction tables, its procedures are tightly coupled to the structure of RA_CUSTOMER_TRX and RA_CUSTOMER_TRX_LINES.

Key Procedures and Functions

• GET_DEFAULT_LINE_NUM — Derives a default line number for a customer transaction line, based on the controlling transaction and existing line context.
• GET_ITEM_FLEX_DEFAULTS — Returns default attribute values for an inventory item, including description, primary unit of measure, and accounting rule details.
• SELECT_SUMMARY — Computes and returns summary totals for a transaction line, supporting line and tax summary modes.
• CHECK_LAST_LINE_ON_DELETE — Determines whether a line being deleted is the last remaining line, or the only tax line, on the transaction.
• CHECK_UNIQUE_LINE — Validates that a proposed customer transaction line number is unique within the transaction. This is the procedure the user searched for.
• TAX_BALANCE — Evaluates the balance or outstanding tax implication associated with a prior transaction line.
• CHECK_TAX_CODE — Validates tax code applicability, typically against the AR_VAT_TAX validation table.

Tables Accessed

The package references the following tables via APPS synonyms. RA_CUSTOMER_TRX and RA_CUSTOMER_TRX_LINES are the primary transaction and line stores, supplying the transaction date, invoicing rule, extended amount, and line-number context. RA_RULES and RA_RULE_SCHEDULES provide accounting rule name, duration, and type for revenue scheduling defaults. AR_VAT_TAX supports tax code validation. MTL_SYSTEM_ITEMS supplies item descriptions, accounting rules, and inventory item identifiers, while MTL_UNITS_OF_MEASURE supplies the unit-of-measure code and name. DUAL is used for single-row expressions. These references are read-oriented except where summary or line maintenance logic may feed back into the Receivables transaction flow.

Usage Notes

As a UTIL-classified package, ARP_TRX_TAX_UTIL is not documented as a public inbound interface and is referenced by no other APPS packages per the ETRM metadata. It is therefore invoked from within the Receivables forms and supporting internal logic during transaction entry, update, and deletion, rather than from standalone concurrent programs. Custom code should not call this package directly; the supported integration surface for Receivables transaction lines is the public AR API layer. In particular, CHECK_UNIQUE_LINE and CHECK_LAST_LINE_ON_DELETE should be treated as internal validation helpers whose behavior and signatures are subject to change across releases such as 12.1.1 and 12.2.2. Developers performing diagnostics on duplicate or non-unique line numbers should confirm results through the supported API or form behavior rather than relying on direct invocation of this utility.