Search Results hz_copy_rel_pvt




Overview
Explore in AI Chat

Overview

HZ_COPY_REL_PVT is a private PL/SQL package in the APPS schema that supports the Oracle EBS Trading Community Architecture (TCA) relationship model. Its central purpose is to enable bulk re-use of relationship definitions: it copies relationship type definitions, and where required the associated relationship instances, from a source relationship type to a target relationship type, so that large volumes of party relationships can be reclassified or duplicated without manual re-entry. In 12.1.1 and 12.2.2 this is important because relationship types drive reciprocity settings, directional semantics, and hierarchy behavior in HZ_RELATIONSHIPS and related structures. Because it is classified as a PVT package, it is not part of the public TCA API surface; it is intended for internal use by Oracle forms, concurrent programs, and other TCA packages that require mass maintenance of relationship classifications. The package is not referenced by any other documented package (referenced by 0 packages), which confirms it is a leaf-level utility invoked directly rather than a shared library.

Key Procedures and Functions

  • COPY_REL_TYPE_ONLY — Copies a relationship type definition without copying any existing relationship instances. This is used when only the type setup is required.
  • COPY_REL_TYPE_AND_ALL_RELS — Copies a relationship type together with all relationship instances that use it, producing a fully populated target type.
  • SUBMIT_COPY_REL_TYPE_RELS_CONC — Submits the copy of a relationship type and its relationships as a concurrent request, enabling large data volumes to be processed in background mode.
  • COPY_HIERARCHY — Copies a relationship hierarchy, that is, the hierarchical structure defined over relationship data, into a target context.
  • SUBMIT_COPY_HIERARCHY_CONC — Concurrent submission wrapper for the hierarchy copy operation.
  • CONVERT_REL_TYPE — Converts existing relationships from one relationship type to another, effectively reclassifying relationship instances.
  • SUBMIT_CONVERT_REL_TYPE_CONC — Concurrent submission wrapper for the relationship type conversion process.

Tables Accessed

  • HZ_RELATIONSHIP_TYPES — the primary source and target of copy/conversion operations.
  • HZ_RELATIONSHIPS — the relationship instances copied or converted.
  • HZ_HIERARCHY_NODES — hierarchy structure used by the hierarchy copy procedures.
  • HZ_PARTIES — referenced to validate and locate the parties participating in relationships.
  • FND_LOOKUP_VALUES — used for lookup validation and type classification values.
  • Utility access through DBMS_UTILITY and PLITBLM (PL/SQL table handling) supports bulk processing.

Usage Notes

HZ_COPY_REL_PVT is normally invoked indirectly. Oracle TCA administrative forms and set-up windows that offer "copy relationship type" or relationship conversion actions call the COPY_ and CONVERT_ entry points, while the SUBMIT_*_CONC procedures are the programmatic entry points used by concurrent programs registered in the APPS request group. Administrators running large conversions should prefer the concurrent wrappers, because in-line execution of the COPY_REL_TYPE_AND_ALL_RELS or COPY_HIERARCHY procedures against high-volume relationship data can be long running. Custom code should not call this PVT package as a substitute for supported public TCA APIs unless no public equivalent exists; because it is a private package, its signature is not guaranteed across patches. Always validate the target relationship type definition and reciprocal settings after execution, and ensure that concurrent requests complete before dependent relationships, hierarchies, or reporting are used.