Search Results validate_scoreresult

Overview

AMS_SCORERESULT_PVT is a private PL/SQL package body in the APPS schema that implements the core persistence and processing logic for Oracle Advanced Marketing (AMS) scoring results. Within the Oracle E-Business Suite 12.1.1 and 12.2.2 environment, this package belongs to the Advanced Marketing Scoring and List Generation architecture, which evaluates customers, prospects, and contacts against data mining model scores and produces ranked, targetable lists. The package encapsulates the DML operations, validation rules, locking conventions, and result-summarization logic that the public AMS_DMSELECTION_PVT and related APIs rely upon. Because it is classified as a PVT (private) package, it is not intended for direct invocation by external applications; instead it is consumed internally by the AMS scoring and list generation layer.

The package is documented as VALID and references a broad set of AMS data model objects, reflecting its role as the write-side engine for score results and percentile computations.

Key Procedures and Functions

The ETRM metadata documents eleven procedures and functions in this package body:

• CREATE_SCORERESULT — Insert a new score result record for a data mining model scoring run.
• UPDATE_SCORERESULT — Modify an existing score result row.
• DELETE_SCORERESULT — Remove a score result and its dependent detail rows.
• LOCK_SCORERESULT — Acquire a row-level lock to prevent concurrent modification during processing.
• VALIDATE_SCORERESULT — Perform completeness and consistency checks before or after persistence.
• CHECK_SCORERESULT_ITEMS — Verify individual score result attributes or child items against expected values.
• VALIDATE_SCORERESULT_REC — Record-level validation of a fully populated score result structure.
• SUMMARIZE_RESULTS — Aggregate score outcomes across a set of results, typically for reporting or list qualification.
• GENERATE_LIST — Drive the generation of a target list from qualified score results, coordinating with list generation packages.
• INSERT_PERCENTILE_RESULTS — Persist percentile-based score outcomes derived from distribution computation.

The procedures are purpose-built for the create, read, validate, and summarize lifecycle that scoring engines require.

Tables Accessed

Via APPS synonyms, the package reads and writes the following documented objects:

• AMS_DM_SCORE_RESULTS / _S — The primary score result entity and its sequence; the main target of CREATE, UPDATE, and DELETE operations.
• AMS_DM_SCORE_LISTS_S — Supplies key values for generated score lists; this is the object the user searched (ams_dm_score_lists_s), indicating its role in list identification.
• AMS_DM_SCORE_PCT_RESULTS / _S — Stores percentile results written by INSERT_PERCENTILE_RESULTS.
• AMS_DM_SCORES_ALL_B — The score definition table providing the scoring criteria being evaluated.
• AMS_DM_MODELS_ALL_B / _VL — Data mining model definitions and translated views referenced for model context.
• AMS_DM_TARGETS_B — Target population definitions associated with scoring runs.
• AMS_DM_SOURCE — Source data definitions feeding the scoring process.
• AMS_LIST_SRC_TYPES — List source type reference data used during list generation.
• DBMS_SQL, DUAL, PLITBLM — Utility objects used for dynamic SQL and procedural table handling.

Usage Notes

AMS_SCORERESULT_PVT is invoked indirectly by higher-level AMS components. The documented dependency list shows it is called by AMS_DMSELECTION_PVT, AMS_DM_SCORE_RESULTS_PKG, AMS_LISTGENERATION_PKG, and AMS_UTILITY_PVT, and it references standard FND utilities (FND_API, FND_GLOBAL, FND_MESSAGE, FND_MSG_PUB, FND_PROFILE) and JTF_PLSQL_API. In practice, users trigger its logic through the Advanced Marketing score results and list generation concurrent programs and related OAF/Forms-based UI flows rather than by direct SQL. The FND_API and FND_MSG_PUB dependencies indicate the package follows the standard EBS API error-handling and message-stack conventions. Because it is a PVT package, customizations should avoid direct calls and instead extend the public selection and list generation APIs.