Search Results get_edi_rec_type

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.

• Utility and sentinel functions: G_MISS_NUM, G_MISS_CHAR, and G_MISS_DATE return the standard "missing" placeholder values for numeric, character, and date data types, allowing callers to signal an attribute that should be left unchanged.
• G_VALID_LEVEL, G_VALID_LEVEL_NONE, G_VALID_LEVEL_FULL, and G_VALID_LEVEL_INT return numeric validation-level codes controlling the degree of validation applied when contact data is processed.
• G_BOOLEAN, G_TRUE, and G_FALSE provide character representations of boolean state, used where a Y/N style flag is required.
• GET_ERROR_CONSTANT resolves a message string into the package's error constant convention, and G_RET_STS_SUCCESS, G_RET_STS_ERROR, and G_RET_STS_UNEXP_ERROR return the standard success, expected-error, and unexpected-error status codes used by the TCA record-type pattern.
• HZ wrapper functions returning TCA record types: GET_PARTY_REC_TYPE, GET_PERSON_REC_TYPE, GET_CONTACT_POINTS_REC_TYPE, GET_PHONE_REC_TYPE, GET_EMAIL_REC_TYPE, GET_TELEX_REC_TYPE, GET_WEB_REC_TYPE, GET_PARTY_REL_REC_TYPE, GET_ORG_CONTACT_REC_TYPE, GET_PARTY_SITE_REC_TYPE, and GET_PARTY_SITE_USE_REC_TYPE.
• GET_EDI_REC_TYPE returns HZ_CONTACT_POINT_V2PUB.EDI_REC_TYPE, the record structure used to pass EDI contact point attributes to the HZ_CONTACT_POINT_V2PUB API. This is the function matched by the search term, and it is the counterpart of the phone, email, telex, and web record-type wrappers.

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.