Search Results get_default_line_num

Overview

ARP_TRX_TAX_UTIL is a public utility package in the Oracle Receivables (AR) module, owned by the APPS schema. It provides shared tax-related helper logic used during the creation, maintenance, and validation of tax lines on customer transactions. The package encapsulates routines that calculate line numbering, resolve item flexfield defaulting for tax lines, validate tax codes and line uniqueness, and enforce balancing rules against the transaction's tax accounting. Its classification as a UTIL package indicates that it is not a business-facing API in its own right, but a supporting library consumed by other Receivables tax-processing programs and internal transaction logic. The header revision ($Header: ARTCTTXB.pls 115.4) confirms it is a long-standing component of the tax-line infrastructure, present across the EBS 12.1.1 and 12.2.2 releases.

Key Procedures and Functions

The package exposes seven documented procedures and functions:

• GET_DEFAULT_LINE_NUM — Returns the default line number for a new tax line. It derives the next available number by taking the maximum existing line number for tax lines linked to the same parent transaction line and adding one. This ensures tax lines are numbered consistently within the document's line hierarchy.
• GET_ITEM_FLEX_DEFAULTS — Resolves default values from the item key flexfield (the MTL_SYSTEM_ITEMS-based inventory item structure) so that tax lines referencing an inventory item inherit appropriate descriptive and accounting attributes. This is the routine most commonly searched for in the context of item flexfield defaulting.
• SELECT_SUMMARY — Retrieves summarized tax information for a transaction, providing aggregate figures used in tax reporting and display logic rather than persisting new data.
• CHECK_LAST_LINE_ON_DELETE — Validates whether a tax line may be deleted, typically guarding against the removal of the last remaining line that would leave the transaction or its tax structure inconsistent.
• CHECK_UNIQUE_LINE — Verifies that a proposed tax line does not duplicate an existing line for the same transaction, enforcing uniqueness constraints at the application level.
• TAX_BALANCE — Performs the tax balancing check, comparing transaction tax amounts against expected values to ensure the document remains in balance for accounting and posting purposes.
• CHECK_TAX_CODE — Validates a tax code against the AR_VAT_TAX setup, confirming that the code is defined, effective, and usable for the transaction being processed.

Tables Accessed

The package reads and writes against the following objects, all accessed through APPS synonyms:

• AR_VAT_TAX — the tax code definition table, used by CHECK_TAX_CODE to validate tax codes.
• MTL_SYSTEM_ITEMS — the inventory item master, consulted by GET_ITEM_FLEX_DEFAULTS for item flexfield defaulting.
• MTL_UNITS_OF_MEASURE — unit of measure validation for item-based tax lines.
• RA_CUSTOMER_TRX — the transaction header, used for context and balancing checks.
• RA_CUSTOMER_TRX_LINES — the transaction line detail, where tax lines are inserted, numbered, and validated.
• RA_RULES and RA_RULE_SCHEDULES — revenue recognition rules and schedules, used when validating line activity against transaction rules.
• DUAL — used for simple scalar evaluations and default derivations.

Usage Notes

ARP_TRX_TAX_UTIL is an internal utility and is referenced by zero other documented packages, meaning its callers are embedded within the Receivables application code base rather than published as dependent APIs. It is typically invoked from the Receivables transactions form, from tax calculation and line generation logic, and from concurrent programs that process or validate tax lines. Custom code should treat these routines as internal helpers rather than a supported integration surface; any direct invocation should pin the exact release, since signatures and behavior may differ between 12.1.1 and 12.2.2. Debug output is gated by the AFLOG_ENABLED profile option, enabling tracing of individual routines when diagnosing tax line creation or balancing failures.