Search Results add_succ_to_temp

Overview

AR_GTA_SPLIT_TRX_PROC is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified as OTHER in the ETRM repository. It supports the Global Tax Application (GTA) module of Oracle Receivables by splitting transactions according to predefined transfer rules. The package exists to ensure that transactional data routed from Receivables into the GTA tax engine does not exceed configured thresholds governing tax rate, maximum amount, or maximum line count. When a transfer rule is applied, the package evaluates each transaction against these limits and produces one or more successor transactions as required. It is defined with AUTHID CURRENT_USER and has been part of the EBS codebase since May 2005, with subsequent fix history addressing registration handling, transaction type retrieval, module prefix casing, and the treatment of credit memos whose line numbers exceed the maximum line limitation when sales lists are enabled (Bug 7758496).

Key Procedures and Functions

The package exposes eleven documented procedures and functions. The central public entry point is SPLIT_TRANSACTIONS, which receives a transfer rule identifier, an organization identifier, and an input nested table of transaction data, and returns the split output as a nested table. Supporting this main routine are several internal procedures. PROCESS_BEFORE_SPLIT performs preparatory evaluation of transaction attributes prior to any split action. COPY_HEADER duplicates header-level information onto each generated successor transaction. SPLIT_NESTED_TABLE manages the mechanical redistribution of rows within the PL/SQL collection types used to carry transaction data, while ADD_SUCC_TO_TEMP inserts successor transactions into the GTA temporary staging structures. Splitting logic is further decomposed by criterion: SPLIT_TRX_BY_TAXREG_NUMBER divides transactions on tax registration number boundaries, and SPLIT_TRX_BY_RATE divides them by tax rate. GET_TRX_TYPE resolves the Receivables transaction type associated with a given record. GET_MAX_AMOUNT_LINE retrieves the configured maximum amount and maximum line thresholds — the settings most relevant to the user's "max_lines" search term, since the split behaviour is driven by these limits. JUDGE_CM_LIMIT and FILTER_CREDIT_MEMO together determine how credit memos are treated when their line counts exceed the configured maximum, reflecting the credit memo fix noted in the history block.

Tables Accessed

The package references several GTA-specific tables, including AR_GTA_RULE_HEADERS_ALL for rule definitions, AR_GTA_SYSTEM_PARAMETERS and AR_GTA_SYSTEM_PARAMETERS_ALL for global configuration, and AR_GTA_TAX_LIMITS_ALL for per-rate tax limits. Transaction staging and output are handled through AR_GTA_TRANSFER_TEMP and its sequence AR_GTA_TRANSFER_TEMP_S, together with AR_GTA_TRX_HEADERS(_ALL), AR_GTA_TRX_HEADERS_ALL_S, AR_GTA_TRX_LINES_ALL, and AR_GTA_TRX_LINES_ALL_S. Receivables sources are read from RA_CUSTOMER_TRX_ALL and RA_CUST_TRX_TYPES_ALL. DUAL and PLITBLM are used for scalar evaluation and collection operations respectively.

Usage Notes

AR_GTA_SPLIT_TRX_PROC is an internal processing package rather than an end-user-facing API. It is not exposed through a standard Receivables form and is normally invoked during the GTA transaction transfer flow, typically from a concurrent program or from another package in the GTA transfer chain — ETRM records that it is referenced by one other package. Customizations that need to influence split behaviour should adjust the rule headers and tax limits rather than modifying this package, as it carries the standard Oracle noship header designation and is subject to patching.