Search Results ams_dm_models_b_pkg




Overview
Explore in AI Chat

Overview

APPS.AMS_DM_MODELS_B_PKG is a PL/SQL package in the Oracle E-Business Suite (EBS) Applications schema (APPS) that provides the low-level data manipulation layer for the Oracle Marketing (AMS) Direct Marketing Models entity. The package is classified as a base-table (B) package, meaning it encapsulates the insert, update, delete, lock, and translation operations for the underlying AMS_DM_MODELS_ALL_B and AMS_DM_MODELS_ALL_TL tables. Its status is documented as VALID in ETRM for EBS 12.1.1 and 12.2.2.

Functionally, this package is the persistence backbone for Direct Marketing Model definitions — the objects that describe the target segments, scoring, and selection criteria used to drive outbound campaign execution within Oracle Marketing. Higher-level logical layers such as AMS_DM_MODEL_PVT depend on this package to persist, retrieve, and manage the model records, enforcing the separation between business logic (the PVT layer) and raw table access (the B layer).

Key Procedures and Functions

The ETRM metadata documents seven procedures in this package:

  • INSERT_ROW — Inserts a new Direct Marketing Model row into the base table, establishing the primary key and initial attributes.
  • UPDATE_ROW — Modifies an existing model record with updated attribute values.
  • LOCK_ROW — Acquires a row-level lock on a model record to support concurrency control during multi-step updates.
  • DELETE_ROW — Removes a Direct Marketing Model record from the base table.
  • ADD_LANGUAGE — Creates translation rows for a model in a specified language, supporting multilingual deployment.
  • TRANSLATE_ROW — Updates or inserts the translated (TL) attribute values for a model record.
  • LOAD_ROW — Loads a model record from a seed or staging source, typically used for data migration or patching.

These procedures are not documented with parameter lists in ETRM, and callers should reference the package specification in the database for exact signatures. Consistent with standard EBS B-package patterns, the parameters typically include WHO columns (creation/update audit) and the primary key identifiers.

Tables Accessed

The package operates against the following documented tables via APPS synonyms:

  • AMS_DM_MODELS_ALL_B — The base (non-translatable) table holding Direct Marketing Model definition records; the primary target of INSERT_ROW, UPDATE_ROW, DELETE_ROW, LOCK_ROW, and LOAD_ROW.
  • AMS_DM_MODELS_ALL_B_S — The sequence used to generate primary key values for new records.
  • AMS_DM_MODELS_ALL_TL — The translation table storing language-specific model names and descriptions; accessed by ADD_LANGUAGE and TRANSLATE_ROW.
  • FND_LANGUAGES — Oracle Applications' language repository, used to validate and enumerate installed languages for translation operations.
  • DUAL — A utility reference used for single-row queries (e.g., sequence value retrieval).

Usage Notes

This package is not intended for direct invocation by end users. It is typically called by:

  • AMS_DM_MODEL_PVT, the API layer that implements Direct Marketing Model business rules and delegates persistence to this package. AMS_DM_MODEL_PVT is the recommended entry point for programmatic work with models.
  • Oracle Marketing forms and the model administration UI, which route DML through the PVT layer down to this B package.
  • Concurrent programs and data migration scripts that use LOAD_ROW, ADD_LANGUAGE, and TRANSLATE_ROW for setup or seed-data loading.
  • Custom code should invoke AMS_DM_MODEL_PVT rather than this package directly to preserve validation and business-rule enforcement.

As with all APPS schema packages, changes to the underlying tables or sequence necessitate corresponding updates to this package, and any recompilation should follow standard EBS patching and dependency-validation procedures.