Search Results update_contact_point

Overview

AMS_CONTACT_POINT_PVT is a private (PVT) PL/SQL package in the APPS schema that encapsulates the core business logic for creating and maintaining contact points within Oracle Marketing (AMS). A "contact point" represents an addressable channel or medium through which a party, customer, or resource can be reached or contacted — for example a phone number, e-mail address, fax number, or web URL. Contact points are stored in the AMS_CONTACT_POINTS table and are associated with an owning entity through the OWNER_TABLE_NAME and OWNER_TABLE_ID columns, allowing the same structure to serve many different parent objects across the E-Business Suite.

The package is classified as PVT, indicating that it is an internal implementation package rather than a public, certified API. It is not intended for direct invocation by external developers. The header declares AUTHID CURRENT_USER, so the package executes with the privileges of the calling user rather than the definer. The package also exposes a package-level constant, G_DEFAULT_NUM_REC_FETCH, set to 30, which governs the default number of records fetched per call in any bulk retrieval logic, and a constant G_MISS_CONTENT_SOURCE_TYPE defaulting to 'USER_ENTERED'.

Key Procedures and Functions

The documented public surface of this package consists of two procedures. No parameter lists are reproduced here, consistent with ETRM's restricted documentation of private package signatures.

• CREATE_CONTACT_POINT — Establishes a new contact point record. It accepts the attributes that describe the contact point (type, status, owning entity, primary flag, content source, and the descriptive flexfield attribute columns) and persists them to the AMS_CONTACT_POINTS table, assigning the contact point identifier. It is the entry point invoked whenever a new reachable channel must be recorded against an owning party or object.
• UPDATE_CONTACT_POINT — Modifies an existing contact point. It alters the stored attributes for a given contact point identifier, including the status, primary flag, content source, and descriptive flexfield segments, without creating a new row.

Tables Accessed

The primary table manipulated by this package is AMS_CONTACT_POINTS, which holds the persisted contact point rows. The package record type, contact_point_rec_type, mirrors the table's columns — CONTACT_POINT_ID, CONTACT_POINT_TYPE, STATUS, OWNER_TABLE_NAME, OWNER_TABLE_ID, PRIMARY_FLAG, ORIG_SYSTEM_REFERENCE, CONTENT_SOURCE_TYPE, ATTRIBUTE_CATEGORY, and the twenty flexible attribute columns (ATTRIBUTE1 through ATTRIBUTE20 in the AMS schema) — confirming that CREATE_CONTACT_POINT inserts into this table and UPDATE_CONTACT_POINT updates it. The OWNER_TABLE_NAME and OWNER_TABLE_ID columns implement the generic foreign key pattern used throughout AMS, letting contact points attach polymorphically to any owning entity. The record type is documented as automatically generated from the table definition, which reinforces the direct, column-level coupling between this package and AMS_CONTACT_POINTS.

Usage Notes

As a PVT package, AMS_CONTACT_POINT_PVT is normally invoked indirectly. Oracle Marketing forms and other AMS modules call it to persist contact point changes made through the user interface, and it is referenced by one other package within the application, which delegates contact point creation and update operations to it. The explicit AUTHID CURRENT_USER clause means callers must possess the necessary privileges on the underlying objects.

Custom code should not call this private package directly. Developers requiring contact point maintenance should use the corresponding public API surface exposed by Oracle Marketing, which in turn delegates to AMS_CONTACT_POINT_PVT. Direct use risks dependency on an unsupported, version-specific internal interface and may break across patching or upgrades from 12.1.1 to 12.2.2.