Search Results get_oe_header_id

Overview

ARP_TRX_LINE_UTIL is a utility package owned by APPS in the Oracle E-Business Suite Receivables (AR) module. It provides reusable PL/SQL helper routines that support transaction line processing for customer transactions in Oracle Receivables. The package is classified as a UTIL object under the Enterprise Transaction Resource Model (ETRM), indicating that it exposes low-level building blocks rather than a public business API. Its procedures and functions address common line-level operations: determining default and maximum line numbers, deriving credit-related dates and periods, retrieving item flexfield defaults from inventory, resolving tax classification and tax amounts, and resolving the originating order header from an order line. In EBS 12.1.1 and 12.2.2, the package is deployed as part of the standard AR code set and is referenced by other application packages, confirming its role as shared infrastructure rather than an end-user-facing component. Because it is a UTIL package, its contents are typically called by other PL/SQL units rather than directly from the Applications forms layer, although forms-based customizations may invoke the same routines.

Key Procedures and Functions

The documented package contains nine procedures and functions. They include two overloads of GET_TAX_AMOUNT, reflecting a search term frequently encountered by developers investigating tax calculation behavior.

• DERIVE_LAST_DATE_TO_CR — a function that derives the last date to credit for a given customer transaction line.
• DERIVE_LAST_PD_TO_CR — a function that derives the corresponding last period to credit.
• GET_DEFAULT_LINE_NUM — a procedure returning the default line number for a customer transaction.
• GET_ITEM_FLEX_DEFAULTS — a procedure returning item flexfield defaults, including description, unit of measure, and accounting rule attributes.
• GET_MAX_LINE_NUMBER — a procedure returning the maximum line number for a customer transaction.
• GET_OE_HEADER_ID — a function returning the order header identifier associated with an order line.
• GET_TAX_CLASSIFICATION_CODE — a function returning the tax classification code for a VAT tax identifier.
• GET_TAX_AMOUNT — an overloaded function returning the tax amount, either for a customer transaction or for a specific customer transaction line, filtered by tax type.

Tables Accessed

The package reads from several AR and shared tables through APPS synonyms. RA_CUSTOMER_TRX_LINES supplies transaction line data used in line numbering, date derivation, and tax amount retrieval. RA_RULES and RA_RULE_SCHEDULES provide revenue recognition rule and schedule information used by GET_ITEM_FLEX_DEFAULTS. MTL_SYSTEM_ITEMS supplies item attributes required for flexfield defaults and unit of measure resolution. OE_ORDER_LINES supports the mapping from order line to order header in GET_OE_HEADER_ID. ZX_LINES and ZX_ID_TCC_MAPPING are consulted for tax line and tax classification code lookup, supporting GET_TAX_AMOUNT and GET_TAX_CLASSIFICATION_CODE. AR_SYSTEM_PARAMETERS provides Receivables system-level configuration used to determine defaults and date limitations.

Usage Notes

Because ARP_TRX_LINE_UTIL is a utility package referenced by eight other packages, it is typically invoked indirectly during Receivables transaction creation, line population, and tax processing flows rather than being called directly by users. Concurrent programs and forms that create or import transaction lines rely on the underlying routines through higher-level AR APIs. Developers writing custom PL/SQL extensions for Oracle Receivables may call these routines directly when implementing line-level logic, provided they respect the standard transaction integrity rules. The GET_TAX_AMOUNT overloads are commonly queried during tax reconciliation and reporting work, where retrieving the tax amount either at the transaction level or at the line level with a tax type filter is required. When used in 12.2.2, the package remains internal and any direct invocation should be treated as a custom extension of standard AR behavior.