Search Results g_level_event

Overview

The APPS.ZX_TDS_IMPORT_DOCUMENT_PKG package body is a component of the Oracle E-Business Tax (EBTax) infrastructure responsible for importing and processing tax documents — typically third-party or external tax data — into the EBS Tax repository. Its role centers on the population and validation of the EBTax interface tables (the ZX global temporary interface structures denoted by the _GT suffix), bridging externally-furnished tax line detail with the internal calculation and proration logic required to derive final tax results.

The package header comment identifies it as a "TDS import document" routine, a naming convention associated with Tax Document Submission / tax data import flows. It declares internal PL/SQL record types (such as tax_line_rec_type) that mirror the columns of the ZX interface tables, together with constants for FND_LOG severity levels used for runtime diagnostics. This structure confirms that the package operates as a backend engine that consumes staged interface records, applies tax rules and rate lookups, and produces finalized tax lines.

Key Procedures and Functions

Two documented program units are exposed by the package:

• PRORATE_IMPORTED_SUM_TAX_LINES — Distributes summary-level tax amounts imported from an external source across the underlying detail tax lines. When a source system supplies only an aggregate tax figure for a group of transaction lines, this procedure apportions the summarized amount to each contributing line according to the applicable proration basis, ensuring the sum of the detail amounts reconciles to the imported summary total.
• CALCULATE_TAX_FOR_IMPORT — Drives the tax calculation for records staged in the import interface tables. It determines the applicable tax regime, tax, tax status, rate code, and rate for each imported line, computes or validates the tax amount, and prepares the calculated results for downstream validation and transfer into the live ZX tables. It handles both included-tax and exception/exemption scenarios represented in the interface record structure.

Both procedures operate against the package's internal record definitions, which include tax regime codes, tax rate codes, jurisdiction codes, exemption and exception identifiers, and linkage identifiers such as trx_line_id. No parameter lists are documented for these units.

Tables Accessed

The package reads and writes the following documented tables via APPS synonyms:

• ZX_TRANSACTION_LINES_GT, ZX_TRX_HEADERS_GT, ZX_TRX_TAX_LINK_GT — staging tables holding transaction header, line, and line-to-tax linkage data used as the import source; the record type draws trx_date, precision, minimum_accountable_unit, trx_level_type, and line-level attributes from these structures.
• ZX_IMPORT_TAX_LINES_GT and ZX_DETAIL_TAX_LINES_GT — summary and detail tax line interface tables populated or consumed during proration and calculation.
• ZX_LINES and ZX_LINES_DET_FACTORS — the persisted tax line repository and its determination factors, used to validate or resolve tax outcomes.
• ZX_RATES_B, ZX_TAXES_B, ZX_REGIMES_B, ZX_REPORTING_CODES_B — tax setup and configuration tables supplying regime, tax, rate, and reporting code definitions referenced during calculation.
• PLITBLM — the PL/SQL table/array utility, used for in-memory collection handling.

Usage Notes

The package is invoked from EBTax import and calculation flows rather than exposed directly to end users. It is typically reached through the EBTax transaction import and tax calculation concurrent programs or via the higher-level EBTax public APIs that orchestrate staging, calculation, and transfer of externally-sourced tax documents. One other package references it, confirming it functions as an internal dependency rather than a top-level entry point.

Custom code should not call these procedures directly, as the interface table contents and processing sequence are normally managed by the EBTax import framework. The $Header line records a version of 120.61.12010000.2, indicating the file is shipped with the 12.1.x and 12.2.x code lines. Given the user query term zx_transaction_lines_gt_u1, note that this is the unique index on the ZX_TRANSACTION_LINES_GT interface table, which supports the lookups this package performs against staged transaction line rows during import processing.