Search Results pop_hz_relationships

Overview

HZ_POPULATE_BOT_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. Its name reflects its central purpose: populating the Business Object Tracking (BOT) infrastructure within the Oracle Trading Community Architecture (TCA) data model. The package header carries the file identifier ARHPBOTS.pls, indicating that it originated in the Receivables (AR) product family, where TCA registries and party model components are shared across Receivables, Order Management, and other modules.

The package exposes a uniform set of procedures that each service a specific TCA entity. Every procedure follows a conventional signature pattern in which an operation parameter indicates the DML action (typically insert, update, or delete) and an entity identifier parameter identifies the specific record being processed. This design allows callers to register, maintain, or remove business object tracking records against the corresponding entity tables in a controlled, repeatable manner.

Key Procedures and Functions

The documented interface comprises 34 procedures, of which the following are representative of the entity coverage:

• POP_HZ_WORK_CLASS — processes HZ_WORK_CLASS records.
• POP_HZ_ROLE_RESPONSIBILITY — processes HZ_ROLE_RESPONSIBILITY records.
• POP_HZ_RELATIONSHIPS — processes HZ_RELATIONSHIPS records.
• POP_HZ_PERSON_PROFILES — processes HZ_PERSON_PROFILES records.
• POP_HZ_PERSON_LANGUAGE — processes HZ_PERSON_LANGUAGE records.
• POP_HZ_PERSON_INTEREST — processes HZ_PERSON_INTEREST records.
• POP_HZ_PARTY_SITE_USES — processes HZ_PARTY_SITE_USES records.
• POP_HZ_PARTY_SITES — processes HZ_PARTY_SITES records.
• POP_HZ_PARTY_PREFERENCES — processes HZ_PARTY_PREFERENCES records.
• POP_HZ_ORG_CONTACT_ROLES — processes HZ_ORG_CONTACT_ROLES records.
• POP_HZ_ORG_CONTACTS — processes HZ_ORG_CONTACTS records.
• POP_HZ_ORGANIZATION_PROFILES — processes HZ_ORGANIZATION_PROFILES records; this is the procedure most directly associated with the search term pop_hz_organization_profiles.
• POP_HZ_LOCATIONS — processes HZ_LOCATIONS records.
• POP_HZ_FINANCIAL_REPORTS, POP_HZ_FINANCIAL_PROFILE, POP_HZ_FINANCIAL_NUMBERS — process the financial reporting and profile entities.
• POP_HZ_EMPLOYMENT_HISTORY, POP_HZ_EDUCATION — process person-centric history and qualification entities.
• POP_HZ_CUST_SITE_USES_ALL, POP_HZ_CUST_PROFILE_AMTS — process customer-facing site use and profile amount entities.

Each procedure accepts an operation indicator and the primary key of the target row, and applies the operation to the business object tracking model for that entity.

Tables Accessed

The package references TCA tables through APPS synonyms. Documented tables include HZ_BUS_OBJ_TRACKING, which is the central tracking repository this package maintains; HZ_CERTIFICATIONS, HZ_CITIZENSHIP, HZ_CODE_ASSIGNMENTS, HZ_CONTACT_POINTS, HZ_CONTACT_PREFERENCES, HZ_CREDIT_RATINGS, HZ_CUSTOMER_PROFILES, HZ_CUST_ACCOUNTS, HZ_CUST_ACCOUNT_ROLES, HZ_CUST_ACCT_RELATE_ALL, HZ_CUST_ACCT_SITES_ALL, HZ_CUST_PROFILE_AMTS, HZ_CUST_SITE_USES_ALL, and HZ_EDUCATION. Together these tables represent the party, customer, contact, site, profile, and qualification entities whose lifecycle events are reflected in the business object tracking structure.

Usage Notes

HZ_POPULATE_BOT_PKG is referenced by 22 other packages within the EBS codebase, which indicates that it is an internal utility rather than a public, standalone API. It is typically invoked indirectly when TCA entity records are created, changed, or removed through supported TCA APIs, forms, or concurrent programs, so that the business object tracking records remain synchronized with the underlying entity data. Direct invocation in custom code should be approached with caution, given the absence of a documented public API classification and the package's dependency on internal entity identifiers. The 12.2.2 metadata lists the API classification as OTHER, reinforcing that it is intended for internal maintenance of business object tracking rather than as an exposed integration point.