Search Results ams_collab_assoc_pvt




Overview
Explore in AI Chat

Overview

AMS_COLLAB_ASSOC_PVT is a private PL/SQL package in the APPS schema that belongs to the Oracle Marketing (AMS) module, within the broader Oracle E-Business Suite 12.1.1 and 12.2.2 application stack. Its purpose, as stated in the package header comments, is to provide an API for the association of collaboration content items and scripts originating from Web ADI (Web Applications Desktop Integrator). In practical terms, the package manages the linkage between marketing collaboration objects — such as proposals and scripts — and the underlying content records that reference them. The package is classified as a Private (PVT) API, meaning it is intended for internal use by other application objects rather than as a public integration interface. As a private package, it is not designed for direct invocation by external or customer-developed code, and its signature may change without notice between releases.

Key Procedures and Functions

The documented ETRM metadata records a single public procedure within this package:

  • CREATE_COLLAB_ASSOC — Creates an association record linking a collaboration content item or script to its corresponding target object. It operates on the record structure collab_assoc_rec_type, which encapsulates the columns of the underlying association table. This record includes identifying attributes such as collab_item_id (the primary key of the association table), collab_type (validated against the AMS_COLLABORATION_TYPE lookup), collab_assoc_value (for example, a script name or proposal name), and collab_assoc_id (content ID, proposal ID, or script ID). Standard WHO audit columns — last_update_date, last_updated_by, creation_date, created_by, and last_update_login — are also captured, along with object_version_number for optimistic locking and obj_type/obj_id to identify the associated business object.

Tables Accessed

The package reads from and writes to the following tables through APPS synonyms:

  • IBC_ASSOCIATIONS — The collaboration associations repository. This is the primary target of the CREATE_COLLAB_ASSOC operation, where new association rows are inserted. Its columns map to the collab_assoc_rec_type record definition.
  • IES_DEPLOYED_SCRIPTS — Stores deployed script definitions used in interactive selling and marketing script deployment. The package references this table to resolve script identifiers when associating collaboration content with scripts.

Usage Notes

As a private API, AMS_COLLAB_ASSOC_PVT is invoked indirectly by other application code rather than through direct user action. The ETRM metadata indicates it is referenced by one other package, which is the typical calling pattern for a PVT-layer object: a public API or a Web ADI integration component calls CREATE_COLLAB_ASSOC to persist association data after a collaboration content item or script is registered or deployed. The reference to Web ADI in the header confirms that the primary invocation path is through desktop-integrated marketing workflows, where content and script data are uploaded and then linked to their associated marketing objects. The G_DEFAULT_NUM_REC_FETCH constant of 30 suggests internal cursor processing that batches records during these operations. Custom code should not call this package directly; developers requiring equivalent functionality should use the corresponding public AMS APIs. Because the package is a PVT object, it is unsupported for customer extensions and is subject to change across EBS patches and upgrades, including the 12.1.1 to 12.2.2 transition.