Search Results cs_parties_pkg




Overview
Explore in AI Chat

Overview

CS_PARTIES_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that provides utility access to party contact information within the Oracle Service (CS) module. Its principal business function is to resolve communication details — telephone numbers, e-mail addresses, and fax numbers — associated with a party or contact record. Rather than duplicate lookup logic in each calling component, the package centralizes these common retrieval operations so that service-related views and packages can obtain consistent contact data from the Trading Community Architecture (TCA) model. The package is classified as OTHER in the ETRM API registry, indicating that it is an internal supporting utility rather than a formally published public API with committed interface guarantees.

Key Procedures and Functions

  • GET_PARTY_PHONE — Returns the telephone number associated with a given party or contact. This is the primary accessor used by service forms and views when a phone number must be displayed for a customer, contact, or resource.
  • GET_PARTY_EMAIL — Returns the e-mail address associated with a given party or contact, supporting outbound notification and communication workflows within Oracle Service.
  • GET_PARTY_FAX — Returns the fax number associated with a given party or contact. Consistent with the other accessors, it isolates the fax lookup so that callers need not query TCA contact point data directly.

All three routines follow the same design pattern: accept a party identifier, locate the relevant contact point of the appropriate contact point type, and return the formatted communication value. Parameter lists are not documented in the ETRM metadata and should be confirmed against the package specification in the target environment before use in custom code.

Tables Accessed

The package reads from HZ_CONTACT_POINTS via its APPS synonym. HZ_CONTACT_POINTS is the TCA table that stores all contact point records (phone, e-mail, fax, URL, and similar) for parties, contacts, and locations, including the contact point type, the raw value, and status flags such as primary and active indicators. The three getter routines query this single table, filtering by party identifier and contact point type, to return the requested communication value. No write operations against TCA tables are documented, confirming that the package functions as a read-only accessor layer.

Usage Notes

CS_PARTIES_PKG is an internal dependency of several Service objects. It is referenced by the views CS_CONT_CONTACTS_RG_V, CS_IB_W_EMPLOYEES_V, and CS_JTF_RESOURCES_V, and it is referenced by three other packages in the APPS schema. Because these views and packages surface contact details to Service forms and self-service pages, any custom code that calls CS_PARTIES_PKG directly should be aware that it is not a formally published API. Typical invocation is from within Service-related view definitions, other CS packages, and custom extensions that need a lightweight contact-detail lookup without joining HZ_CONTACT_POINTS themselves. Oracle recommends using published TCA APIs such as the HZ_CONTACT_POINT_V2PUB or HZ_PARTY_V2PUB interfaces for transactional or interface development, and treating CS_PARTIES_PKG as a read-only convenience utility whose signature may change between releases. Developers should validate the package specification in their specific 12.1.1 or 12.2.2 instance and test any custom dependency against patched versions of the package.