Search Results hz_party_acquire




Overview
Explore in AI Chat

Overview

HZ_PARTY_ACQUIRE is a PL/SQL package body owned by the APPS schema within the Oracle E-Business Suite Trading Community Architecture (TCA) model. Its principal business function is the acquisition, or retrieval, of party-centric information — registrations, addresses, contact points, known-as names, and account details — from the TCA registry. In contrast to the HZ_CUST_ACCOUNT_V2PUB and HZ_PARTY_V2PUB packages that perform data creation and maintenance, HZ_PARTY_ACQUIRE concentrates on read and retrieval semantics, exposing a set of GET_* procedures that acquisition flows (such as self-service registration and party import) use to reconcile inbound data against existing TCA records. The package is classified as OTHER in ETRM and holds VALID status in both EBS 12.1.1 and 12.2.2.

The package is a mature, dependency-rich component. It is not referenced by any other database object directly, yet it is reported as referenced by 32 other packages, indicating it is consumed principally at the application layer rather than through stored database dependencies.

Key Procedures and Functions

Ten documented procedures and functions constitute the public surface of HZ_PARTY_ACQUIRE:

  • GET_PARTY_REC — Retrieves the primary party record for a given entity, forming the entry point for downstream retrieval logic.
  • GET_PARTY_SITE_REC — Obtains party site information associated with a party, returning the site data required by acquisition flows.
  • GET_CONTACT_REC — Retrieves the contact record, including relationship and role detail, for a party or organization contact.
  • GET_CONTACT_POINT_REC — Returns contact point data (for example phone, email, or URL references) for the party.
  • GET_ACCOUNT_INFO — Acquires customer account information linked to the party.
  • GET_KNOWN_AS — Retrieves known-as names (alternate or former names) held against the party.
  • GET_ADDRESS — Returns formatted address information for the party or party site.
  • GET_PHONE_NUMBER — Retrieves telephone number data from the party's contact points.
  • GET_CONTACT_NAME — Returns the name of a contact associated with the party.
  • GET_SSM_MAPPINGS — Acquires source-system mapping information, used to reconcile a party with its originating system reference.

Exact parameter lists are not exposed in the ETRM metadata and are therefore not enumerated here.

Tables Accessed

HZ_PARTY_ACQUIRE reads and writes against the core TCA tables aliased under APPS synonyms:

API utilities FND_API, FND_MESSAGE, FND_MSG_PUB, and FND_FILE provide error handling, message stack, and file output support.

Usage Notes

The package is invoked from Oracle Forms, self-service acquisition flows, concurrent import programs, and custom PL/SQL. Typical callers use HZ_PARTY_ACQUIRE to read an existing party, then pass the retrieved records to HZ_PARTY_V2PUB or HZ_CUST_ACCOUNT_V2PUB for creation or update. It is most commonly used in party import and registration scenarios where inbound data must be matched against existing TCA records. Because it is referenced by 32 packages, developers extending TCA acquisition logic should treat it as a stable read interface and avoid direct DML on the underlying HZ_* tables.