Search Results zx_api_code_combinations_s

Overview

ZX_R11I_TAX_PARTNER_PKG is a tax partner integration package in the Oracle E-Business Tax (EBTax / ETRM) module. Its name reflects its role as a bridge between the Release 11i tax partner framework and the ZX (E-Business Tax) schema introduced in Release 12. The package body is owned by APPS and holds a VALID status in the ETRM 12.1.1 and 12.2.2 environments, with an API classification of OTHER, indicating it is an internal utility rather than a formally published public API. It operates as a wrapper and orchestration layer that participates in the third-party tax service provider (tax partner) integration flow, handling geopolitical validation, party tax profile extension, transaction line preprocessing for partner vendors, and service registration management invoked from the user interface.

Key Procedures and Functions

The package exposes twelve documented procedures and functions. Their purposes are as follows.

• IS_CITY_LIMIT_VALID — Validates whether the city component of an address reflects a valid city limit, supporting accurate jurisdiction determination for tax calculation.
• IS_GEOCODE_VALID — Confirms the validity of a geocode associated with a party or tax profile, supporting geopolitical resolution.
• TAX_VENDOR_EXTENSION — Provides the extension hook that allows partner-specific or vendor-specific processing to be attached to the standard tax partner flow.
• COPY_PTNR_TAX_LINE_BEF_UPD — Copies partner tax-related line information before an update, preserving prior values for audit, history, or comparison.
• COPY_TRX_LINE_FOR_PTNR_BEF_UPD — Copies transaction line data for partner processing before an update, ensuring partner tax logic reads consistent source data.
• CREATE_SRVC_REGISTN_FROM_UI — Creates a service registration record on behalf of the user interface, encapsulating validation and persistence of registration details.
• CREATE_EXTN_REGISTN_FROM_UI — Creates an external (third-party) registration record invoked from the UI.
• EXECUTE_EXTN_PLUGIN_FROM_UI — Executes a registered external plugin from the UI, providing the invocation point for extension logic.
• FLUSH_TABLE_INFORMATION — Flushes cached or staged table information, ensuring subsequent reads or writes operate on current data.

The remaining documented procedures participate in the same registration, validation, and preprocessing lifecycle. No parameter signatures are published in the metadata, so the interfaces should be treated as internally defined.

Tables Accessed

The package reads and writes tax and party data through APPS synonyms. Core tax tables include ZX_LINES, ZX_LINES_DET_FACTORS, ZX_API_CODE_COMBINATIONS, ZX_API_CODE_COMBINATIONS_S (the object referenced in the search), ZX_API_OWNER_STATUSES, ZX_API_REGISTRATIONS, ZX_API_REGISTRATIONS_S, ZX_EVNT_CLS_MAPPINGS, and ZX_PARTY_TAX_PROFILE. Party and customer data is sourced from HZ_PARTIES, HZ_PARTY_SITES, HZ_CUST_ACCOUNTS, HZ_CUST_ACCT_SITES_ALL, and HZ_CUST_SITE_USES_ALL, while HR_ALL_ORGANIZATION_UNITS supplies organizational context. These tables support registration creation, code combination resolution, owner status tracking, party tax profile extension, and transaction line preprocessing prior to update.

Usage Notes

ZX_R11I_TAX_PARTNER_PKG is invoked indirectly by the broader E-Business Tax partner infrastructure rather than as a standalone entry point. It is referenced by seven other packages and depends on FND_API, FND_GLOBAL, FND_LOG, FND_MESSAGE, FND_REQUEST, ZX_API_PUB, ZX_API_PRVDR_PUB, ZX_GLOBAL_STRUCTURES_PKG, ZX_TAX_PARTNER_PKG, ZX_TAXWARE_USER_PKG, ZX_TAX_VERTEX_PKG, ZX_TPI_SERVICES_PKG, ZX_SECURITY, and related utilities. The FROM_UI procedures and EXECUTE_EXTN_PLUGIN_FROM_UI confirm that portions of the package are triggered by user actions in E-Business Tax setup and configuration forms. Custom code should not call these internal routines directly; instead, customization should be routed through the supported public APIs (ZX_API_PUB, ZX_API_PRVDR_PUB) and vendor extension plugins, which this package ultimately invokes.