Search Results get_party_site_rec

Overview

HZ_PARTY_ACQUIRE is a public PL/SQL package owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It belongs to the Oracle Trading Community Architecture (TCA) foundation and is classified under the API classification OTHER rather than as a formal public API. The package provides the retrieval side of the party data model: whereas the HZ_PARTY_SEARCH package defines the record type structures used to carry party, party site, contact, and contact point data, HZ_PARTY_ACQUIRE supplies the functions that hydrate those structures from the underlying TCA tables based on a primary key identifier. The package is declared AUTHID CURRENT_USER, meaning that all unqualified object references resolve against the privileges of the calling user, which is significant because many of the constituent tables (HZ_PARTIES, HZ_CUST_ACCOUNTS, HZ_PERSON_PROFILES, and similar) carry sensitive personally identifiable information subject to data security policies.

The second family of functions in the package performs attribute-level lookups, returning a single VARCHAR2 value for a named entity, attribute, and optional context combination. These convenience accessors shield callers from the multi-table joins and descriptive flexfield handling that would otherwise be required to resolve a single display value.

Key Procedures and Functions

• get_party_rec — Returns a HZ_PARTY_SEARCH.party_search_rec_type record populated from the party identifier and party type supplied by the caller.
• get_party_site_rec — Returns a HZ_PARTY_SEARCH.party_site_search_rec_type record for a given party site identifier. This is the function most commonly sought by developers searching for party site retrieval logic.
• get_contact_rec — Returns a HZ_PARTY_SEARCH.contact_search_rec_type record for a given organization contact identifier.
• get_contact_point_rec — Returns a HZ_PARTY_SEARCH.contact_point_search_rec_type record for a given contact point identifier.
• get_account_info — Returns a VARCHAR2 value representing account information for a party, qualified by entity, attribute, and optional context.
• get_known_as — Returns the "known as" name value for a party, qualified by entity, attribute, and optional context.
• get_address — Returns a formatted or attribute-specific address value for a party site identifier.
• get_phone_number — Returns a telephone number value for a contact point identifier.
• get_contact_name — Returns a contact name value for an organization contact identifier.
• get_ssm_mappings — Returns a mapping value from the single source of truth (SSM) configuration for a given record identifier and entity/attribute context.

Tables Accessed

The package reads from HZ_PARTIES, HZ_PARTY_SITES, and HZ_LOCATIONS to assemble party and address records; from HZ_ORG_CONTACTS and HZ_CONTACT_POINTS to assemble contact and contact point records; from HZ_CUST_ACCOUNTS to supply account information; from HZ_ORGANIZATION_PROFILES and HZ_PERSON_PROFILES to enrich party records with profile-specific attributes; and from HZ_RELATIONSHIPS and HZ_ORIG_SYS_REFERENCES to resolve party relationships and source-system cross references. The information is accessed through APPS synonyms over the TCA base tables. Dynamic SQL is used, as indicated by the reference to DBMS_SQL and PLITBLM, which allows attribute resolution to be driven at runtime from the entity/attribute/context arguments rather than from static SQL.

Usage Notes

HZ_PARTY_ACQUIRE is referenced by 32 other packages in the E-Business Suite, indicating that it functions primarily as an internal service layer consumed by higher-level TCA APIs and by Oracle applications such as Receivables, Order Management, and CRM modules. Because the package is classified as OTHER rather than as a supported public API, custom code should treat it as subject to change between releases and should not depend on it where a documented public API exists. Typical invocation is from PL/SQL inside other packages or from forms-based lookups, rather than from concurrent programs directly. Developers retrieving party site data should note that get_party_site_rec returns a record typed against HZ_PARTY_SEARCH, so the calling code must declare a variable of that type and must handle the possibility that no row exists for the supplied identifier.