Results for “zx_tds_import_document_pkg”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

ZX_TDS_IMPORT_DOCUMENT_PKG is an Oracle E-Business Tax (EBS Tax / ETRM) PL/SQL package owned by the APPS schema. It supports the import of externally supplied tax document data into the E-Business Tax repository and the subsequent calculation of tax on those imported transactions. The package serves as a bridge between staged, externally generated transaction and tax line records (held in global temporary tables) and the persistent E-Business Tax data model, enabling downstream processes such as tax calculation, tax line proration, and reporting to operate on imported documents. The package is classified as an "OTHER" API in ETRM 12.2.2 and exposes two documented program units, PRORATE_IMPORTED_SUM_TAX_LINES and CALCULATE_TAX_FOR_IMPORT. It is referenced by ZX_TDS_CALC_SERVICES_PUB_PKG, which indicates it participates in the tax determination and calculation service flow, and it depends on ZX_API_PUB for core tax API interactions.

Key Procedures and Functions

• PRORATE_IMPORTED_SUM_TAX_LINES — Allocates or distributes summarized tax amounts on imported tax lines across the underlying transaction lines. In the E-Business Tax model, tax amounts may be captured at a summary level during import, and this unit prorates those amounts so that each transaction line carries its appropriate share of tax, preserving the integrity of tax reporting and accounting.
• CALCULATE_TAX_FOR_IMPORT — Drives tax calculation for imported documents. It applies the relevant tax regimes, taxes, rates, and reporting codes to the imported transaction lines, producing calculated tax records that can be persisted back into the E-Business Tax tables. This unit leverages the core tax API (ZX_API_PUB) to perform the actual determination and calculation.

Both procedures operate in the context of E-Business Tax's multilayered data structure (regime, tax, tax status, rate, jurisdiction, and reporting type). Their exact parameter signatures are not documented in the available metadata and should be confirmed against the database before use.

Tables Accessed

The package interacts with a set of global temporary tables (GT) that stage import data, and with the persistent E-Business Tax base and transaction tables:

• ZX_TRX_HEADERS_GT, ZX_TRANSACTION_LINES_GT, ZX_LINES — staging and storage of transaction headers and lines for which tax is to be calculated or prorated.
• ZX_IMPORT_TAX_LINES_GT, ZX_DETAIL_TAX_LINES_GT, ZX_TRX_TAX_LINK_GT — staging of imported tax lines, detailed tax line breakdowns, and linkage between transactions and their tax lines.
• ZX_RATES_B, ZX_REGIMES_B, ZX_TAXES_B, ZX_REPORTING_CODES_B — configuration tables supplying regime, tax, rate, and reporting code definitions applied during calculation.
• ZX_LINES_DET_FACTORS — detail-level tax determination factors used during tax calculation.
• PLITBLM — the Oracle standard PL/SQL table used by the database for bulk operations.

Usage Notes

ZX_TDS_IMPORT_DOCUMENT_PKG is typically invoked from import or integration flows that load external tax and transaction data into E-Business Tax, such as third-party tax engine integrations or data migration utilities. It is called by ZX_TDS_CALC_SERVICES_PUB_PKG, meaning it forms part of the tax calculation service layer and is exercised when tax determination is requested for imported documents. It may also be invoked from custom PL/SQL or concurrent programs that stage data in the ZX *_GT tables and then request calculation or proration. Because it relies on ZX_API_PUB, callers should ensure the E-Business Tax configuration (regimes, taxes, rates, and reporting codes) is complete and effective before invoking the package. As with all ETRM APIs, callers should handle exceptions, observe transaction boundaries, and validate the contents of the staging tables prior to execution.