Search Results ams_dm_score_pvt_w




Overview
Explore in AI Chat

Overview

APPS.AMS_DM_SCORE_PVT_W is a private PL/SQL package belonging to the Oracle Marketing (AMS) module of Oracle E-Business Suite, specifically within the Oracle Advanced Marketing / Marketing Intelligence score-carding subsystem (AMS_DM denotes the Data Mining / scoring component). The package serves as the procedural workhorse for creating, maintaining, and validating marketing scores — the numeric or categorical ratings that marketing applications assign to customers, leads, contacts, or opportunities during segmentation, list generation, and campaign targeting.

The "_W" suffix follows the Oracle EBS convention for a wrapper package that exposes or brokers the functionality of the underlying private API, AMS_DM_SCORE_PVT. In this case AMS_DM_SCORE_PVT_W is documented as referencing AMS_DM_SCORE_PVT and the FND_API utility package, and it depends on several JTF collection types (JTF_NUMBER_TABLE, JTF_DATE_TABLE, and the JTF_VARCHAR2_TABLE_100/200/300/1000/4000 variants), which indicates it is designed to receive and return set-based (multi-row) data rather than singletons. The package is classified as OTHER in the API registry, confirming it is an internal, non-public interface intended for use by other AMS components rather than by external integrations.

Key Procedures and Functions

  • CREATE_SCORE — Establishes a new score record within the marketing scoring model, persisting the score definition and its associated attributes.
  • UPDATE_SCORE — Modifies an existing score record, supporting maintenance of score values, weights, or descriptive attributes.
  • VALIDATE_SCORE — Performs validation logic on a score entity prior to persistence, enforcing business rules and referential integrity.
  • VALIDATE_SCORE_REC — A record-level validation routine, applying the same validation rules to an individual in-memory score record.
  • CHECK_SCORE_ITEMS — Verifies the component items that make up a score, ensuring the constituent elements referenced by a scoring model are present and consistent.
  • COPY_SCORE — Duplicates an existing score definition, typically used when cloning a scoring model or template.
  • ROSETTA_TABLE_COPY_IN_P3 and ROSETTA_TABLE_COPY_OUT_P3 — A pair of bulk data-transfer utilities following the "Rosetta" naming convention used in AMS for mapping external/tabular data into and out of PL/SQL collection structures. The _IN variant marshals inbound table data; the _OUT variant extracts result sets. The "_P3" suffix denotes a specific overload or phase of the routine.

Tables Accessed

The package's documented table reference resolves through APPS synonyms to PLITBLM. This is a standard Oracle Applications flex-field / descriptive-flexfield interim table used as a PL/SQL-indexed table staging area. Its presence indicates that AMS_DM_SCORE_PVT_W stages score-attribute data (particularly descriptive flexfield segments) in a temporary structure before committing to the underlying score tables maintained by AMS_DM_SCORE_PVT.

Usage Notes

AMS_DM_SCORE_PVT_W is not intended for direct customer invocation. It is called internally by Oracle Marketing forms and concurrent programs during score definition maintenance and by the AMS_DM_SCORE_PVT base package. The metadata records zero packages referencing it externally, and no direct public API exposure, confirming its role as a private helper layer. Developers extending marketing scoring functionality should call the supported public AMS scoring APIs rather than this wrapper.