Search Results ar_gta_transfer_temp_s

Overview

AR_GTA_SPLIT_TRX_PROC is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite. It supports Global Tax Adjudication (GTA) processing within Oracle Receivables by splitting transaction records so that tax can be calculated and adjudicated at a more granular level. GTA requires transactional data — headers, lines, and associated tax details — to be partitioned according to rules such as tax registration number, tax rate, and credit memo limits. This package performs that partitioning, copying transaction headers and distributing lines into temporary and staging structures used by downstream GTA processing. The object is documented as VALID in ETRM 12.2.2 and is classified as an "OTHER" API rather than a public, supported interface, indicating it is an internal component of the GTA engine.

Key Procedures and Functions

• SPLIT_TRANSACTIONS — The primary entry point. It drives the overall split logic across the set of transactions being processed.
• COPY_HEADER — Copies transaction header information when a transaction is divided into multiple derived records.
• PROCESS_BEFORE_SPLIT — Performs preparatory validation or setup work before splitting begins.
• SPLIT_NESTED_TABLE — Handles splitting of nested (PL/SQL collection) structures that carry line or detail data.
• ADD_SUCC_TO_TEMP — Adds successfully split records to the temporary staging table.
• SPLIT_TRX_BY_TAXREG_NUMBER — Splits transactions according to tax registration number, the core GTA partitioning rule.
• SPLIT_TRX_BY_RATE — Splits transactions by tax rate where a single transaction spans multiple rates.
• GET_TRX_TYPE — Retrieves the transaction type associated with a transaction, used to determine split behavior.
• JUDGE_CM_LIMIT — Evaluates credit memo amounts against defined limits to decide whether splitting is required.
• GET_MAX_AMOUNT_LINE — Determines the maximum amount line, supporting limit comparisons during credit memo processing.
• FILTER_CREDIT_MEMO — Filters credit memos so that only eligible transactions enter the split flow.

Tables Accessed

The package reads and writes GTA-specific staging and rule tables. AR_GTA_RULE_HEADERS_ALL supplies the splitting rules that govern how transactions are divided. AR_GTA_SYSTEM_PARAMETERS and AR_GTA_SYSTEM_PARAMETERS_ALL provide system-level configuration. AR_GTA_TAX_LIMITS_ALL holds the tax threshold values used by the credit memo limit checks. Intermediate and output data are written to AR_GTA_TRANSFER_TEMP and AR_GTA_TRANSFER_TEMP_S, while AR_GTA_TRX_HEADERS, AR_GTA_TRX_HEADERS_ALL, and AR_GTA_TRX_HEADERS_ALL_S store the split transaction header records. Line-level results are held in AR_GTA_TRX_LINES_ALL and AR_GTA_TRX_LINES_ALL_S. Transaction type context is obtained from RA_CUST_TRX_TYPES_ALL, and RA_CUSTOMER_TRX_ALL supplies the source Receivables transactions. DUAL and PLITBLM (the standard PL/SQL integer table type) are also referenced. Utility logic is shared through AR_GTA_TRX_UTIL.

Usage Notes

AR_GTA_SPLIT_TRX_PROC is not referenced by any other database object; instead it is invoked by one other package within the GTA processing chain, typically as part of the tax adjudication flow for Receivables transactions. It is not intended as a public API and should not be called directly from custom code. Standard diagnostic facilities — FND_FILE, FND_LOG, and FND_MESSAGE — are referenced, indicating the package writes log output and messages, consistent with execution from a concurrent program. In both 12.1.1 and 12.2.2 the object exists under the APPS schema with status VALID. Because GTA behavior is configuration-driven, split results depend on rule header and system parameter setup rather than on hard-coded logic. When troubleshooting the related table AR_GTA_TRX_HEADERS_ALL_S, this package is the principal producer of its rows.