Search Results ams_dm_source_pkg




Overview
Explore in AI Chat

Overview

APPS.AMS_DM_SOURCE_PKG is a PL/SQL package in the Oracle E-Business Suite Applications schema (APPS) associated with Oracle Marketing (AMS). Its name follows the AMS_DM_* convention used for "Direct Marketing" source-related objects, and its documented procedures align with the standard ETRM generated-maintenance interface pattern: INSERT_ROW, UPDATE_ROW, LOCK_ROW, and DELETE_ROW. These single-row maintenance routines provide the procedural layer through which the AMS_DM_SOURCE entity is created, amended, locked for update, and removed. Its documented classification is OTHER, indicating that it is a supporting maintenance package rather than a workflow business API, and its documented status is VALID in the ETRM 12.2.2 repository.

Key Procedures and Functions

Four procedures are documented for this package. No parameter lists are recorded in the source metadata, so only their purpose is described here.

  • INSERT_ROW — Creates a new record in the AMS_DM_SOURCE table. This is the entry point for establishing a new direct-marketing source definition.
  • UPDATE_ROW — Modifies an existing AMS_DM_SOURCE record, applying changes to the maintained columns of the entity.
  • LOCK_ROW — Obtains a row-level lock on the target AMS_DM_SOURCE record, providing pessimistic concurrency control so that concurrent updates do not overwrite one another.
  • DELETE_ROW — Removes an AMS_DM_SOURCE record, providing the deletion path for the entity.

The symmetry of these four operations is characteristic of Oracle's generated table-handler packages, which centralize DML and locking behavior for a single table and are consumed by higher-level business logic rather than called directly by end users.

Tables Accessed

The package references a single documented table through APPS synonyms: AMS_DM_SOURCE. This table stores the direct-marketing source records that the four procedures act upon. INSERT_ROW and UPDATE_ROW write to it, DELETE_ROW removes rows from it, and LOCK_ROW positions and locks a row within it. The dependency listing also shows a reference to SYS.STANDARD, which is simply the PL/SQL base package required by virtually all compiled PL/SQL units and carries no application significance. No other application tables are documented as referenced by this package.

Usage Notes

According to the documented dependency information, AMS_DM_SOURCE_PKG is referenced by the package APPS.AMS_DMSOURCE_PVT, and the package also appears in its own dependent-code listing, reflecting the standard package/package-body relationship. This means AMS_DM_SOURCE_PKG functions as the low-level data-access layer beneath AMS_DMSOURCE_PVT, which exposes the higher-level business logic for direct-marketing sources. Typical invocation therefore flows from the private API layer, not directly from forms, concurrent programs, or ad hoc SQL. Because the ETRM metadata records this package as an OTHER-classified, generated maintenance handler, customization or direct invocation by customer code is not advisable; the supported integration point is the higher-level public API (AMS_DMSOURCE_PVT) that calls these procedures internally. Developers investigating the package should treat it as internal infrastructure, relying on the documented procedure names and the AMS_DM_SOURCE table reference to understand its behavior rather than expecting published parameter contracts. In both Oracle EBS 12.1.1 and 12.2.2, this object is expected to remain stable, and the 12.2.2 ETRM documentation confirms its VALID status and its single inbound package dependency.