Search Results gt_trx_class_mng

Overview

The ZX_AP_ACTG_POPULATE_PKG package body is a Payables tax accounting extraction component within the Oracle E-Business Tax (EBTax) module, owned by the APPS schema. Its principal responsibility is to populate the global PL/SQL collection variables that are used during the extraction of tax data from Payables (Accounts Payable) transactions into the E-Business Tax repository. The global table variables declared at the top of the package — such as GT_TRX_CLASS_MNG, GT_TAX_RATE_CODE_REG_TYPE_MNG, GT_TAXABLE_DISC_AMT, and the extensive family of GT_BILLING_TP_* and GT_SHIPPING_TP_* collections — mirror the structures defined in ZX_EXTRACT_PKG and hold transaction class, tax rate, taxable discount, and party location data prior to insertion into the ZX reporting tables. In EBS 12.1.1 and 12.2.2, this package supports the data movement required by the tax reporting and reconciliation architecture, ensuring that the accounting distributions from AP invoices are coupled with the correct tax attributes and reporting party details.

Key Procedures and Functions

The ETRM metadata documents two procedures/functions within this package body:

• UPDATE_ADDITIONAL_INFO — Updates supplemental tax information associated with the extracted records. It is used to enrich the staged tax data with attributes that are not captured by the primary extraction logic, aligning the records with the reporting requirements of ZX_REP_ACTG_EXT_T and the associated accounting extract structures.
• LOOKUP_DESC_MEANING — Resolves a description or meaning value from a lookup, enabling the extraction process to translate coded lookup values into human-readable meanings for reporting and reconciliation output.

The global collection variables declared in the package header (trx class, tax rate registration type, quantity UOM, taxable and tax discount amounts in both entered and functional currency, VAT transaction type descriptions, and billing/shipping party address elements) are populated by these routines and consumed by the parent extraction program. The metadata does not expose the individual parameter lists for these procedures, so only their functional purpose is described here.

Tables Accessed

The package references the following objects through APPS synonyms:

• AP_INVOICES_ALL, AP_INVOICE_DISTRIBUTIONS_ALL, AP_INVOICE_PAYMENTS_ALL, AP_PAYMENT_HISTORY_ALL, AP_PAYMENT_HIST_DISTS — source Payables invoice, distribution, and payment data that drives the tax accounting extract.
• AP_SUPPLIERS, AP_SUPPLIER_SITES_ALL, AP_SYSTEM_PARAMETERS_ALL — supplier and system-level defaults used for party and location determination.
• XLA_AE_HEADERS, XLA_AE_LINES, XLA_DISTRIBUTION_LINKS — Subledger Accounting entries that link Payables distributions to their accounting representations, essential for reconciliation between tax and GL accounting.
• ZX_PARTY_TAX_PROFILE, ZX_REC_NREC_DIST, ZX_REP_TRX_DETAIL_T, ZX_REP_ACTG_EXT_T — E-Business Tax reporting and party tax profile tables, forming the target and supporting structures for the extract.

Usage Notes

ZX_AP_ACTG_POPULATE_PKG is not a public API; its API classification is OTHER and it is not referenced by other packages per the ETRM metadata. It is invoked internally by the Payables tax extraction and reconciliation flow, typically as part of the concurrent processing that generates the ZX reporting extracts (such as the tax repository and reconciliation reports). Customers and implementers should not call the procedures directly; instead they should rely on the standard E-Business Tax concurrent programs. The populate_tax_data search term associated with this object reflects its role in loading tax data into the global extraction collections. Because the package writes to global package variables, it operates within a single session and must complete before downstream extraction steps consume the populated tables.