Search Results create_org_contact_role

Overview

HZ_PARTY_CONTACT_V2PUB is a public PL/SQL API package in the Oracle E-Business Suite Trading Community Architecture (TCA) / Receivables (AR) product family. It provides the canonical programmatic interface for creating, updating, and retrieving organizational contacts and their associated roles within the HZ (Trading Community) data model. In Oracle EBS 12.1.1 and 12.2.2, this package is the successor "V2" version of the contact public API, offering a stable, business-logic-encapsulated entry point that shields callers from the underlying table structures.

The package separates its coarse-grained public API from a set of private procedures such as do_create_org_contact, do_update_org_contact, do_create_org_contact_role, do_update_org_contact_role, and check_obsolete_columns. These private procedures perform the actual DML, while the public procedures expose only the supported interface. The header comment ($Header: ARH2PCSB.pls ... 2007/09/28) confirms it is a maintained AR-family package delivered under the APPS schema.

Key Procedures and Functions

The documented public API comprises six procedures and functions:

• CREATE_ORG_CONTACT — Creates an organization contact record, instantiating the party/relationship and contact rows required to associate a person with an organization.
• UPDATE_ORG_CONTACT — Modifies an existing organization contact, honoring object version numbers for optimistic concurrency control.
• CREATE_ORG_CONTACT_ROLE — Assigns a role to an existing organization contact (for example, a contact purpose or responsibility).
• UPDATE_ORG_CONTACT_ROLE — Modifies an existing organization contact role record.
• GET_ORG_CONTACT_REC — Retrieves the full attribute set of an organization contact into the API's record type for inspection or downstream processing.
• GET_ORG_CONTACT_ROLE_REC — Retrieves the attribute set of an organization contact role.

All create and update operations return a standard x_return_status out parameter, allowing callers to distinguish success, expected error, and unexpected error conditions consistent with the TCA API error-handling convention. Parameter lists are defined by the package's record types (ORG_CONTACT_REC_TYPE, ORG_CONTACT_ROLE_REC_TYPE) and object version number in/out parameters; these must be referenced from the package specification rather than reconstructed.

Tables Accessed

The package performs DML and queries against the following tables (via APPS synonyms):

• HZ_ORG_CONTACTS — Stores the organization contact records themselves; the primary write target.
• HZ_ORG_CONTACT_ROLES — Stores roles assigned to contacts.
• HZ_CONTACT_NUMBERS_S — Stores contact phone, fax, and e-mail numbers; a sequence-backed table keyed for contact points.
• HZ_PARTIES — The master party registry; contact creation and update touches party attributes and object version numbers.
• HZ_PERSON_PROFILES — Person-specific attributes for contact parties.
• HZ_RELATIONSHIPS — The party-to-party relationship linking a contact to the organization.
• HZ_RELATIONSHIP_TYPES — Lookup of valid relationship types used when establishing the contact relationship.
• DUAL — Used for utility selections such as sequence and version retrieval.

Usage Notes

HZ_PARTY_CONTACT_V2PUB is referenced by 40 other packages, reflecting its role as a shared TCA service. It is typically invoked from:

• Oracle Forms UI actions that maintain organization contacts and contact roles.
• Concurrent programs and batch loaders that import or synchronize contact data.
• Custom PL/SQL code that must create or update contacts while preserving TCA business rules, denormalized party information, and object version integrity.

Callers should always check x_return_status after invocation, populate required record type fields, and supply object version numbers on updates to avoid concurrent-update conflicts. Direct DML against the underlying HZ tables is not supported and bypasses the validation embedded in this package. Note that ETRM metadata is authoritative for this object; consult the package specification for exact parameter signatures.