Search Results rosetta_g_miss_num_map

Overview

AMS_ACTMETRICFACT_PVT_W is a private PL/SQL package body in the Oracle E-Business Suite Applications (APPS) schema that supports the ActMetricFact business object within the Oracle Marketing (AMS) product family. The ActMetricFact entity stores marketing activity metric fact records — quantifiable measurements associated with marketing activities, campaigns, and their outcomes — which feed analytical reporting and campaign performance evaluation. The package follows the standard EBS "Private API" (_PVT_W) architecture, in which a generated wrapper module exposes standardized CRUD, validation, and record-initialization entry points while delegating attribute-level logic to the underlying entity handler. It is documented as an OTHER classification API, meaning it is not part of Oracle's formally published public interface but is internal infrastructure invoked by the generated PL/SQL layer and by dependent AMS packages.

Key Procedures and Functions

The package exposes seven documented program units, consistent with the EBS private API pattern:

• INIT_ACTMETRICFACT_REC — Initializes the ActMetricFact record structure. It accepts a long positional OUT NOCOPY parameter list (p0_a0 through at least p0_a39 in the shipped source) covering numeric, date, and VARCHAR2 attributes, and resets every attribute to its default or "miss" sentinel value prior to population.
• CREATE_ACTMETRICFACT — Inserts a new ActMetricFact row after validating the supplied attribute set.
• UPDATE_ACTMETRICFACT — Modifies an existing ActMetricFact row, applying changed attributes to the persisted record.
• VALIDATE_ACTMETFACT — Performs entity-level validation on the ActMetricFact record, enforcing required attributes and business rules.
• VALIDATE_ACTMETFACT_ITEMS — Validates the individual attribute items of the record, typically checking each column value independently.
• VALIDATE_ACTMETFACT_REC — Validates the complete ActMetricFact record as a whole, orchestrating item-level checks prior to a create or update.
• COMPLETE_ACTMETFACT_REC — Completes the record by deriving or defaulting attributes that were not explicitly supplied, preparing it for persistence.

Tables Accessed

The documented metadata does not enumerate the specific base tables the package reads or writes through APPS synonyms. Based on the entity name and the AMS schema conventions, the package operates against the AMS_ACTMETRICFACTS table and its associated translation and reference tables (for example AMS_ACTMETRICFACTS_TL for multilingual attribute values, and lookup/validation tables referenced by the AMS_ACTMETRICFACT attributes). These accesses occur through the APPS synonym layer so that the package resolves objects in the caller's runtime schema. Writes are confined to the create and update flows; validation and completion routines perform read-only checks or in-memory manipulation of the parameter list.

Usage Notes

AMS_ACTMETRICFACT_PVT_W is not intended for direct invocation by external developers. It is called by the generated AMS_ACTMETRICFACT_PUB package and by internal AMS processing logic, including concurrent programs and forms that maintain marketing activity metrics. The parameters use FND_API.g_miss_num, FND_API.g_miss_date, and related sentinels to represent unset attributes, and the package contains explicit workaround helpers — rosetta_g_miss_num_map and rosetta_g_miss_date_in_map — that translate JDBC "GMiss" values into the FND_API equivalents. This is significant for integrations: any custom code binding to this API must supply fnd_api.g_miss_* values for columns it does not intend to change, not NULL, and must expect the Rosetta mapping on inbound values from non-native clients. Because the package is classified as a private API and is referenced by zero other packages in the ETRM metadata, Oracle does not guarantee interface stability across releases; in 12.1.1 and 12.2.2 the surface is functionally identical, but customizations should target the public _PUB wrapper wherever one exists.