Search Results hz_common_pub




Overview
Explore in AI Chat

Overview

HZ_COMMON_PUB is a public PL/SQL package body owned by the APPS schema within the Oracle E-Business Suite Trading Community Architecture (TCA) module. It functions as a shared utility and validation layer that other TCA packages and Oracle Receivables components invoke to perform common, reusable operations against the party, customer, and site data model. The package is classified as a PUBLIC API, meaning it is intended to be callable from external code, forms, concurrent programs, and custom extensions. Its documented status is VALID in both EBS 12.1.1 and 12.2.2.

The package does not itself embody a single business transaction. Rather, it centralizes transactional control (commit and rollback), installation detection for TCA, lookup validation, sequencing helpers for account and party-site numbers, address and name resolution, and reusable time-window and mandatory-column validation routines. Dependencies include FND_API, FND_MSG_PUB, FND_MESSAGE, FND_LOOKUP_VALUES, FND_TERRITORIES_VL, FND_ACCESS_CONTROL_UTIL, AR_LOOKUPS, ARP_UTIL, and core HZ tables, confirming its role as a cross-cutting utility in the TCA and Receivables stack.

Key Procedures and Functions

The documented API surface comprises 29 procedures and functions. The principal groups are:

Tables Accessed

The package reads and, in limited cases, writes the following tables through APPS synonyms:

  • HZ_PARTIES, HZ_CUST_ACCOUNTS, HZ_CUST_ACCOUNT_ROLES — party and account name, contact, and role resolution.
  • HZ_CUST_ACCT_SITES_ALL, HZ_PARTY_SITES, HZ_PARTY_SITE_NUMBER_S — address and site number resolution and sequencing.
  • HZ_LOCATIONS — address attribute lookups.
  • HZ_RELATIONSHIPS — party relationship traversal for contact and role queries.
  • HZ_ACCOUNT_NUM_S, HZ_PARTY_SITE_NUMBER_S — sequence access for account and site numbers.
  • FND_LOOKUP_VALUES — lookup validation.
  • DBMS_SESSION, DUAL — session context management and singleton queries.

Usage Notes

HZ_COMMON_PUB is invoked indirectly by 30 other database objects and is referenced by numerous TCA and Receivables APIs. Typical invocation channels include Oracle Forms for customer and party maintenance, concurrent programs performing bulk TCA operations, and custom PL/SQL extending standard TCA flows. Because it is a public API with documented commit/rollback helpers, callers should treat COMMIT_TRANSACTION and ROLLBACK_TRANSACTION as the standard mechanism for transactional closure. The security-context procedures should be invoked around operations requiring content-source restriction. Developers should not rely on undocumented signatures; only the 29 documented procedures and functions are supported. No database object depends on HZ_COMMON_PUB itself, confirming its pure utility role.