Search Results hz_addr_ispeed_pkg

Overview

HZ_ADDR_ISPEED_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite. The name follows the TCA (Trading Community Architecture) naming convention associated with the HZ schema objects, which govern customer, party, location, and address data. The ISPEED component indicates that the package was originally created to support an address-related integration, most commonly associated with bulk address validation, cleansing, or batch data-load operations tied to external address services. Within the ETRM registry, the object is classified under the generic API classification "OTHER," meaning Oracle does not publish it as a supported public interface or as part of a formal documented API set.

The package is documented with only two procedures, INSERT_ROW and UPDATE_ROW, indicating that it is a low-level data manipulation wrapper rather than a business-rule-enforcing API. Its business function is therefore internal: it provides insert and update access to rows on behalf of a parent address process rather than exposing a full public interface with validations, date-tracking, or concurrent conflict resolution normally found in TCA public APIs.

Key Procedures and Functions

• INSERT_ROW — Inserts a new row into the underlying address data structure managed by the package. It serves the initial population of address records during the integration or batch process that the package supports.
• UPDATE_ROW — Modifies an existing row previously inserted or maintained through the package. It supports the ongoing maintenance and correction of address data produced by the same process.

No parameter lists, return types, or exception handling are documented in the ETRM metadata. The procedures should be treated as internal implementation routines rather than supported API entry points. Because the package is not documented as a public API, Oracle support does not guarantee backward compatibility of procedure signatures between releases.

Tables Accessed

The ETRM metadata does not enumerate specific tables referenced by HZ_ADDR_ISPEED_PKG. Its dependency listing is limited to SYS.STANDARD, the standard PL/SQL package supplying built-in types and functions. Given the package name and the presence of INSERT_ROW and UPDATE_ROW procedures, the package logically operates against address-related TCA tables, most plausibly HZ_LOCATIONS or a closely associated address staging or detail table. Because no table list is documented, any table-level dependency should be confirmed directly against the deployed package body in the target instance using ALL_DEPENDENCIES or by reviewing the source in the APPS schema.

Usage Notes

HZ_ADDR_ISPEED_PKG is referenced by no other documented packages and references no published API parent. This is consistent with an integration-specific utility package invoked directly by a dedicated batch loader, a concurrent program, or a custom form handler rather than by standard EBS application flows. Typical invocation scenarios include a one-time or scheduled data migration of address records, or a synchronization routine against an external address validation service.

Because the package is classified as OTHER and is not a supported public API, customizations should not depend on it for long-term development. Where equivalent supported functionality is required, TCA public APIs under the HZ_ADDRESS or HZ_LOCATION API families should be used instead. Any modification requires careful regression testing, as the package operates directly on address data and errors can affect customer and location records across the instance. Verification of current validity should be performed against the specific release, since the object is documented as VALID in the ETRM 12.2.2 registry and may differ in 12.1.1.