Search Results ams_dm_models_all_b_s

Overview

The APPS.AMS_DM_MODELS_B_PKG package body is the core transactional processing layer for Oracle Marketing (AMS) Direct Marketing model definitions in Oracle E-Business Suite 12.1.1 and 12.2.2. It exposes the DML and multilanguage (MLS) primitives that maintain the base table AMS_DM_MODELS_ALL_B, its MLS shadow table AMS_DM_MODELS_ALL_TL, and the related sequence object AMS_DM_MODELS_ALL_B_S. In the Oracle Applications architecture, the _B_PKG naming convention denotes a base-table handler package that is deliberately thin: it performs row-level inserts, updates, locking, deletes, language installation, translation maintenance, and single-record loads, while richer business validation and derivation logic is layered above it in a separate _PKG unit. The package is registered under the APPS schema and reports a VALID status, indicating it is an active, compiled component of the ETRM data model rather than a deprecated artifact.

Key Procedures and Functions

The documented package metadata enumerates seven entry points. Parameter lists are not reproduced here; the purpose of each is described below.

• INSERT_ROW — Creates a new Direct Marketing model record. It obtains the primary key from AMS_DM_MODELS_ALL_B_S and writes the base-row attributes into AMS_DM_MODELS_ALL_B.
• UPDATE_ROW — Applies changes to an existing model base row, typically invoked after the caller has validated the modified attributes.
• LOCK_ROW — Acquires a row-level lock on the target model record to serialize concurrent modification, normally called before an update sequence.
• DELETE_ROW — Removes the base row for a model, together with its dependent MLS translation rows.
• ADD_LANGUAGE — Installs translation rows in AMS_DM_MODELS_ALL_TL for a newly enabled language, copying source-language content where appropriate and using FND_LANGUAGES to determine installed languages.
• TRANSLATE_ROW — Writes or updates the translatable (MLS) columns of a model for a specific language, preserving the base row.
• LOAD_ROW — Performs a consolidated load of a model definition, supporting seed data, upgrade, and migration scenarios where a record must be created or refreshed programmatically.

Tables Accessed

• AMS_DM_MODELS_ALL_B — the base table holding language-independent model attributes; target of insert, update, lock, and delete operations.
• AMS_DM_MODELS_ALL_B_S — the sequence supplying unique model identifiers for new rows.
• AMS_DM_MODELS_ALL_TL — the MLS translation table holding language-specific column values; maintained by ADD_LANGUAGE, TRANSLATE_ROW, and the delete path.
• FND_LANGUAGES — the Oracle Applications language registry, read to validate and resolve language codes during translation operations.
• DUAL — used for scalar evaluations and sequence-style queries within PL/SQL.

Usage Notes

The package depends on the Oracle Applications foundation APIs FND_API, FND_MESSAGE, FND_MSG_PUB, FND_GLOBAL, and APP_EXCEPTION, which supply the standard error-stack, message-token, and session-context conventions. Calls are therefore expected to honour the FND_API.G_MISS_CHAR/G_MISS_NUM/G_MISS_DATE sentinel conventions, and the internal routines set the usual x_return_status, x_msg_count, and x_msg_data outputs. Invocation is typically indirect: Oracle Marketing setup forms and Direct Marketing concurrent programs call the higher-level model API, which in turn delegates persistence to AMS_DM_MODELS_B_PKG. Custom integrations, data-migration scripts, and Oracle Diagnostics/ETRM inspection routines may also call this package directly when a controlled DML or multi-language load of model metadata is required. Because the package body is not referenced by any other documented database object, it functions as a leaf-level DML service within the AMS data model; callers should perform their own business validation before invoking these routines.