Search Results get_relationship_obj

Overview

HZ_PARTY_BO_PVT is a private PL/SQL package owned by the APPS schema within the Oracle E-Business Suite Trading Community Architecture (TCA) module. The suffix _PVT denotes an internal implementation package; it encapsulates the business-object logic that supports the public party APIs exposed across the Customer Relationship Management and Order-to-Cash application stacks. In Oracle EBS 12.1.1 and 12.2.2, HZ_PARTY_BO_PVT serves as the centralized engine that orchestrates creation, update, and retrieval of the composite structures that comprise a "party" — the master record representing a person or organization. Rather than acting as a directly callable interface, it functions as a shared internal service used by the HZ_*_BO_PUB packages, persisting relationships, classifications, certifications, financial profiles, preferences, and party usage assignments while managing message propagation and business events through the standard TCA framework.

Key Procedures and Functions

The package exposes nineteen documented procedures and functions, grouped by business object:

• Relationship handling: CREATE_RELATIONSHIPS, CREATE_RELATIONSHIP_OBJ, UPDATE_RELATIONSHIP_OBJ, SAVE_RELATIONSHIP_OBJ, SAVE_RELATIONSHIPS, and GET_RELATIONSHIP_OBJ process party-to-party relationship records, building object structures and persisting changes.
• Classification and certification: CREATE_CLASSIFICATIONS, SAVE_CLASSIFICATIONS, CREATE_CERTIFICATIONS, and SAVE_CERTIFICATIONS manage party classifications and certification entries.
• Financial profiles and preferences: CREATE_FINANCIAL_PROFILES, SAVE_FINANCIAL_PROFILES, and SAVE_PARTY_PREFERENCES handle financial profile data and party-level preference settings.
• Party usage: CREATE_PARTY_USAGE_ASSGMNT and SAVE_PARTY_USAGE_ASSGMNT manage party usage assignment records that determine which application functions a party may serve.
• Framework utilities: CALL_BES, IS_RAISING_CREATE_EVENT, IS_RAISING_UPDATE_EVENT, and RETURN_ALL_MESSAGES invoke business events, test event-raising conditions, and return the accumulated message stack to callers.

Tables Accessed

DML is performed against several TCA tables via APPS synonyms:

• HZ_PARTIES — the master party entity.
• HZ_RELATIONSHIPS — stores relationship rows between parties.
• HZ_ORIG_SYS_REFERENCES — tracks originating system references for imported parties.
• HZ_BUS_OBJ_DEFINITIONS and HZ_BUS_OBJ_TRACKING — support the business-object framework, defining object types and tracking processing state.
• WF_PARAMETER_LIST_T and PLITBLM — Workflow parameter and PL/SQL index-by table utilities used in event propagation.

The package also references record/table types including HZ_RELATIONSHIP_OBJ_TBL, HZ_RELATIONSHIP_OBJ, HZ_CERTIFICATION_OBJ_TBL, HZ_CODE_ASSIGNMENT_OBJ_TBL, HZ_FINANCIAL_PROF_OBJ_TBL, HZ_MESSAGE_OBJ_TBL, HZ_PARTY_PREF_OBJ_TBL, and HZ_PARTY_USAGE_OBJ_TBL, and depends on FND_API.

Usage Notes

Because HZ_PARTY_BO_PVT is a private package, it is not intended for direct invocation by end users or custom code. It is invoked indirectly through the TCA public APIs — HZ_PERSON_BO_PUB, HZ_ORGANIZATION_BO_PUB, HZ_CONTACT_POINT_BO_PUB, HZ_CUST_ACCT_BO_PUB, HZ_LOCATION_BO_PUB, and related _BO_PUB packages, thirteen in total — that in turn drive it from Forms, concurrent programs, and the Trading Community Foundation import processes. Custom integrations should call the public _PUB interfaces rather than this package to preserve upgrade compatibility and validation logic. The presence of event- and message-related routines indicates it participates in TCA business events and error-stack handling, ensuring source-system references and messaging are propagated consistently across the 12.1.1 and 12.2.2 releases.