Results for “zx_api_registrations_s”

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

Overview

ZX_API_PRVDR_PUB is a public PL/SQL package body in the APPS schema that governs the interaction between Oracle E-Business Tax (EBTax) and external or third-party tax service providers registered within the ETRM (E-Business Tax Regime Manager) framework. Its role is to broker the lifecycle of service registrations — the records that associate a party, regime, and service type with an external tax content or calculation provider. In Oracle EBS 12.1.1 and 12.2.2, this package functions as the API-facing layer that custom integrations, partner applications, and internal concurrent processes call to create, remove, and execute provider-backed tax services. The package body is documented as VALID, depends heavily on the FND_API, FND_FLEX_KEY_API, and FND_LOG framework utilities, and is treated as API-classified (PUB) publishing code, meaning its signatures are intended for supported external invocation.

Key Procedures and Functions

• CREATE_SRVC_REGISTRATION — Creates a service registration record, establishing the link between a party, a tax regime, and a service type used by an external provider. This is the entry point for onboarding a provider to a given tax context.
• DELETE_SRVC_REGISTRATION — Removes or deactivates an existing service registration, allowing providers to be decommissioned from a tax regime and service type combination without leaving orphaned records.
• EXECUTE_SRVC_PLUGIN — Invokes the registered provider plugin associated with a service registration, serving as the runtime dispatch mechanism that external tax content or calculation services plug into EBTax processing.

These three routines form a complete register–deregister–invoke cycle, supporting the provider integration model used by EBTax.

Tables Accessed

• ZX_API_REGISTRATIONS and ZX_API_REGISTRATIONS_S — The primary registration and translation tables for API-managed service registrations. ZX_API_REGISTRATIONS_S holds the translated descriptive columns exposed by the ZX_API_REGISTRATIONS base table.
• ZX_API_OWNER_STATUSES — Tracks ownership and status of API registrations.
• ZX_API_CODE_COMBINATIONS — Stores flexfield-derived combinations associated with registration processing.
• ZX_SERVICE_TYPES, ZX_REGIMES_B, and ZX_PARTY_TAX_PROFILE — Provide the service type, tax regime, and party tax profile context for each registration.
• HZ_PARTIES — Supplies the trading partner or legal entity identity tied to the registration; accessed through the FND_FLEX_KEY_API and FND_FLEX_EXT utilities for party validation.
• PLITBLM — PL/SQL table of numbers, used for internal key or line handling.

Reads and writes are mediated through APPS synonyms, and the package relies on FND_API for standard return status and FND_LOG for diagnostic messaging.

Usage Notes

ZX_API_PRVDR_PUB is invoked by EBTax setup and configuration flows — typically from the provider registration UI or concurrent programs that register external tax service providers, and at runtime when EBTax dispatches tax calculation or content requests to a registered plugin. The package is not referenced by any other database object, so it sits at the top of the dependency chain rather than being consumed internally by other PL/SQL units; its callers are external, including forms, concurrent programs, and customer-written integrations. Because the package is API-classified, it should be called only through its documented public procedures and never modified or wrapped by unsupported mechanisms. Oracle EBS patch updates to the APPS schema may redefine this body, so any custom dependency on its behavior should be treated as subject to change across 12.1.1 and 12.2.2 releases.