Search Results zx_srvc_typ_pkg




Overview
Explore in AI Chat

Overview

ZX_SRVC_TYP_PKG is a public PL/SQL package owned by APPS in the Oracle E-Business Suite E-Business Tax (E-Business Tax / ETRM, formerly ZX) module. Its classification in ETRM is OTHER, indicating that it is a supporting package rather than a published external API in the strictest sense, though several of its procedures are documented as being called from published services such as calculate_tax and import_document_with_tax.

The package serves as a service-type-oriented service layer within the tax engine. It encapsulates the procedural logic required to calculate tax on a document, import documents with tax already attached, override tax and recovery lines, reverse documents and distributions, determine recovery, validate documents for tax processing, and synchronize tax lines against a source transaction. In Oracle EBS 12.1.1 and 12.2.2, the package header declares an extensive set of collection types (for example, VARCHAR2, NUMBER, and record/table types keyed by BINARY_INTEGER), which are used to pass sets of document lines, tax attributes, and detail factors between the tax engine and calling applications in a bulk-managed fashion.

Key Procedures and Functions

The documented public procedures and functions fall into several functional groups. The calculation and import group includes CALCULATE_TAX, which is called from the published service calculate_tax and drives tax determination and calculation for a document; and IMPORT, called from the published service import_document_with_tax, which brings externally calculated tax lines into E-Business Tax.

Line maintenance and override procedures include OVERRIDE_TAX_LINES and OVERRIDE_RECOVERY for user-specified overrides, MARK_TAX_LINES_DELETED for logical deletion of tax lines, and DISCARD_TAX_ONLY_LINES, which removes tax-only lines that are not accompanied by corresponding document lines.

Document lifecycle procedures include DOCUMENT_LEVEL_CHANGES, REVERSE_DOCUMENT, and REVERSE_DISTRIBUTIONS, handling header-level changes to a tax document and reversal of documents and their associated accounting distributions. Recovery-related logic is covered by DETERMINE_RECOVERY and FREEZE_DISTRIBUTION_LINES. Validation is handled by VALIDATE_DOCUMENT_FOR_TAX.

Attribute and defaulting procedures include INSUPD_LINE_DET_FACTORS, GET_TAX_PROFILE_IDS, DEFAULT_TAX_ATTRS_WRAPPER, GET_DEFAULT_TAX_DET_ATTRS, DECIDE_CALL_REDEFAULT_APIS, CALL_REDEFAULTING_APIS, and SYNCHRONIZE_TAX. The ZX_LINES_TABLE_HANDLER procedure provides a centralized handler for the tax lines table.

Tables Accessed

The package references a broad set of APPS synonyms spanning trading partners, items, and transaction sources. Party and site data come from HZ_PARTIES, HZ_CUST_ACCOUNTS, and HZ_LOCATIONS; supplier and organization data come from AP_SUPPLIERS, HR_ALL_ORGANIZATION_UNITS, and HR_LOCATIONS_ALL. Transaction sources include RA_CUSTOMER_TRX_ALL and RA_CUST_TRX_TYPES_ALL for receivables, OE_ORDER_LINES_ALL for order management, and ASO_QUOTE_HEADERS_ALL for quoting. Inventory items are resolved from MTL_SYSTEM_ITEMS and MTL_SYSTEM_ITEMS_B. Sales representative data comes from RA_SALESREPS_ALL, assignment data from PER_ALL_ASSIGNMENTS_F, and the legal entity tax profile from XLE_ETB_PROFILES.

Usage Notes

ZX_SRVC_TYP_PKG is invoked indirectly through the published E-Business Tax services (calculate_tax and import_document_with_tax) rather than being called directly by end users. It is referenced by two other packages, so it operates as a shared internal service layer. In practice it is triggered from transaction entry forms and from concurrent programs that calculate tax for receivables, order management, and similar transaction flows. Custom code should call the published ZX_API_PUB entry points rather than this package, because the documented entry points are the supported integration surface.