Search Results zx_valid_init_params_pkg




Overview
Explore in AI Chat

Overview

ZX_VALID_INIT_PARAMS_PKG is an Oracle E-Business Tax (EBS Tax / ETRM) PL/SQL package owned by the APPS schema. Its name reflects its principal role: validating initialization parameters and providing the entry point and control logic through which tax-relevant documents are processed, recorded, calculated, and reversed within the E-Business Tax engine. The package acts as a gatekeeper for document-level tax processing, determining which transactions are eligible to enter the tax repository and orchestrating the operations that follow — tax calculation, recovery determination, distribution handling, and document reversal.

The package operates on the E-Business Tax data model, which centers on the ZX schema (tax lines, event classes, tax types, and recovery). Its scope spans the full document lifecycle, from a preliminary eligibility check (IS_DOC_TO_BE_RECORDED) through tax determination and calculation, and on to corrective operations such as overrides, deletions, and reversals. The package header declares a record type, Source_rec_Type, that captures a comprehensive set of party and party-site roles — SHIP_TO, SHIP_FROM, POA, POO, PAYING, OWN_HQ, TRAD_HQ, POI, POD, BILL_TO, BILL_FROM, TTL_TRNS, and MERCHANT — together with corresponding party-site columns. This structure supplies the taxation context for a document, indicating that the package is designed to validate and resolve the parties and sites that participate in tax determination.

The documented header includes the standard EBS header comment dated 2006, confirming this is a long-standing component of the tax infrastructure carried forward into Oracle EBS 12.1.1 and 12.2.2.

Key Procedures and Functions

The ETRM metadata lists 21 documented procedures and functions. Their purposes are as follows:

Tables Accessed

The package references the following tables through APPS synonyms, all in the ZX tax schema:

Usage Notes

ZX_VALID_INIT_PARAMS_PKG is an internal engine component rather than an end-user API. It is invoked indirectly by E-Business Tax processing, including the tax calculation and document import flows driven by user actions in forms and by concurrent programs that process tax for transactions such as invoices, purchase orders, and sales orders. The metadata records that the package is referenced by nine other packages, confirming its role as a shared service within the tax code base. Customizations should not call this package directly unless the calling code replicates the full event context — entity code, event class code, and the associated party and site identifiers — expected by the Source_rec structure. Because of its dependency on global temporary tables and the tax repository's referential integrity, direct calls should be limited to diagnostics or custom extensions that follow Oracle's own invocation patterns.