Search Results validate_scoreresult_rec

Overview

APPS.AMS_SCORERESULT_PVT is a private PL/SQL package in the Oracle E-Business Suite Advanced Marketing (AMS) module, which forms part of the Oracle Trade Management and Marketing foundation. The package implements the internal application logic that supports score result processing within the AMS data-mining and scoring framework. Its name follows the Oracle EBS private API naming convention, where the _PVT suffix denotes a package intended for internal use only, as opposed to the _PUB public wrapper packages exposed to external callers.

The package handles the lifecycle of score results generated by marketing data-mining models: creating, updating, deleting, locking, validating, and summarizing scoring outcomes, and generating percentile-based result sets. The object is documented as VALID in the APPS schema and is classified as a PVT API in ETRM metadata for EBS 12.1.1 and 12.2.2. It depends on FND_API and STANDARD (from SYS), which indicates that it follows Oracle's standard API error-handling and message conventions, including the use of the FND_API G_MISS_* constants and the standard p_return_status out parameter pattern, although the exact signatures are not documented here.

Key Procedures and Functions

The ETRM metadata documents eleven procedures and functions. Their purposes are:

• CREATE_SCORERESULT — inserts a new score result record into the score result tables.
• UPDATE_SCORERESULT — modifies an existing score result row, preserving the audit columns managed by the AMS framework.
• DELETE_SCORERESULT — logically or physically removes a score result entry.
• LOCK_SCORERESULT — obtains a row-level lock on a score result to serialize concurrent updates.
• VALIDATE_SCORERESULT — performs attribute-level validation on score result data prior to persistence.
• CHECK_SCORERESULT_ITEMS — verifies related score items for completeness and consistency.
• VALIDATE_SCORERESULT_REC — record-level validation routine that validates an entire score result record structure.
• SUMMARIZE_RESULTS — aggregates score outcomes, producing summary statistics for reporting or downstream processing.
• GENERATE_LIST — builds a marketing list from score results, linking scored targets to list-generation logic.
• INSERT_PERCENTILE_RESULTS — computes and stores percentile rankings into the percentile result tables.

Tables Accessed

The package reads and writes a set of AMS data-mining tables via APPS synonyms:

• AMS_DM_SCORE_RESULTS and its _S translation/attribute counterpart — the primary score result store.
• AMS_DM_SCORE_PCT_RESULTS and _S — percentile ranking results produced by INSERT_PERCENTILE_RESULTS.
• AMS_DM_SCORE_LISTS_S — score list definitions used during list generation.
• AMS_DM_SCORES_ALL_B — the base score definitions the results reference.
• AMS_DM_MODELS_ALL_B — the data-mining model that produced the scores.
• AMS_DM_SOURCE and AMS_DM_TARGETS_B — source and target definitions used to resolve scored entities.
• AMS_LIST_SRC_TYPES — list source type lookup used by GENERATE_LIST.
• DBMS_SQL, DUAL, PLITBLM — dynamic SQL, dual-table selection, and PL/SQL index-by table support, indicating dynamic scoring queries.

Usage Notes

As a private package, AMS_SCORERESULT_PVT is not intended for direct customer invocation. It is referenced by two packages documented in the ETRM metadata: AMS_SCORERESULT_PUB, the public wrapper that external callers should use, and AMS_WFMOD_PVT, which suggests that workflow or model-related processing also consumes its scoring routines. Typical invocation paths are the AMS score result maintenance forms and concurrent programs that generate scores, compute percentiles, and build target lists. Customizations should target AMS_SCORERESULT_PUB and its documented parameters rather than the private package, since the _PVT interface may change across patch levels and is not part of the supported public API surface. The dependency on FND_API further implies that callers should expect standard p_return_status handling semantics on any wrapper-level call.