Search Results cs_sr_cust_cont_maint_pvt




Overview
Explore in AI Chat

Overview

CS_SR_CUST_CONT_MAINT_PVT is a private (PVT) PL/SQL package owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented header identifies it as a maintenance utility layer for customer contact data managed within the Service (CS) module and the Trading Community Architecture (TCA / HZ) schema. The package serves two distinct purposes. First, it provides a set of generic PL/SQL utility routines — missing-value sentinels, validation level constants, boolean conversion, error constant lookup, and standard return status codes — that are reused by contact maintenance logic. Second, it exposes a collection of wrapper functions that return TCA public API record types, allowing the Service customer contact maintenance flow to construct and populate the complex PL/SQL record structures required by the HZ_PARTY_V2PUB, HZ_CONTACT_POINT_V2PUB, HZ_RELATIONSHIP_V2PUB, HZ_PARTY_CONTACT_V2PUB, and HZ_PARTY_SITE_V2PUB APIs. Because the API classification is PVT, the package is not a supported public interface; it is an internal implementation detail invoked by the Service contact maintenance program units.

Key Procedures and Functions

The documented interface contains 30 functions, falling into two groups.

Tables Accessed

The supplied ETRM metadata records no directly referenced tables via APPS synonyms. The package operates indirectly: its record-type wrappers return PL/SQL records that are subsequently passed to the HZ TCA public APIs (HZ_PARTY_V2PUB, HZ_CONTACT_POINT_V2PUB, HZ_RELATIONSHIP_V2PUB, HZ_PARTY_CONTACT_V2PUB, HZ_PARTY_SITE_V2PUB), which in turn read and write the underlying TCA tables such as HZ_PARTIES, HZ_CONTACT_POINTS, HZ_RELATIONSHIPS, HZ_PARTY_SITES, and HZ_PARTY_SITE_USES. All persistence is therefore performed by those APIs rather than by direct DML inside this private package.

Usage Notes

Because CS_SR_CUST_CONT_MAINT_PVT is classified PVT and is referenced by zero other packages in the documented metadata, it is an internal helper with no public dependency surface. It is invoked from the Service customer contact maintenance program units — typically the customer contact forms and their supporting libraries within the Service module — to build TCA record structures and to apply consistent defaults, missing values, and return status codes before calling the HZ contact point and party APIs. Custom code in 12.1.1 or 12.2.2 should not call this package directly, as private APIs are not covered by Oracle's compatibility guarantee and may change between releases or patches; the supported route for equivalent functionality is the public TCA APIs (for example HZ_CONTACT_POINT_V2PUB) whose record types are exposed here.