Search Results validate_fund_facts

Overview

APPS.AMS_ACTMETRICFACT_PVT is a private (PVT-classified) PL/SQL package body within the Oracle E-Business Suite Marketing (AMS) module. Its role is to encapsulate the business logic used to create, maintain, validate, and manipulate records in the Activity Metric Facts entity, which stores the quantitative factual values captured against activity metrics in Oracle Marketing and Trade Management (formerly Enterprise Trading and Relationship Management, ETRM). The package provides exception-safe, message-enabled private APIs that operate on the AMS_ACT_METRIC_FACTS_ALL table and its associated formula and metric definition tables.

The package was originally created in June 1999 and includes a history of revisions, including the July 2000 modification to allow the same hierarchy node to appear combined with a unique formula_id, and the April 3, 2001 addition of the VALIDATE_FUND_FACTS procedure. It follows the standard Oracle EBS private API conventions by initializing the FND message stack and returning the standard x_return_status, x_msg_count, and x_msg_data out parameters through its documented routines.

Key Procedures and Functions

The package exposes ten documented procedures and functions:

• INIT_ACTMETRICFACT_REC — Initializes the activity metric fact record structure with default values before it is passed to other package routines.
• CREATE_ACTMETRICFACT — Inserts a new activity metric fact record into the underlying tables after validating the supplied record.
• UPDATE_ACTMETRICFACT — Updates an existing activity metric fact record, applying validation rules before committing changes.
• DELETE_ACTMETRICFACT — Removes an activity metric fact record from the entity, ensuring referential and business rules are respected.
• LOCK_ACTMETRICFACT — Acquires a row-level lock on the specified activity metric fact to serialize concurrent modifications.
• VALIDATE_ACTMETFACT — Performs record-level validation of an activity metric fact, checking required attributes and business constraints.
• VALIDATE_ACTMETFACT_ITEMS — Validates the item (line) details belonging to an activity metric fact record.
• VALIDATE_ACTMETFACT_REC — Validates the complete activity metric fact record structure, including header and items, prior to persistence.
• COMPLETE_ACTMETFACT_REC — Completes or defaults missing attributes of an activity metric fact record, producing a fully populated record for subsequent processing.
• VALIDATE_FUND_FACTS — Validates the fund-related facts associated with an activity metric fact. This routine was added in April 2001 specifically to enforce the business rules governing funds captured as metric facts, and is the object most directly associated with the search term "validate_fund_facts."

Tables Accessed

The package references the following tables through APPS synonyms:

• AMS_ACT_METRICS_ALL — Holds the activity metric definitions against which facts are captured. Used during validation to confirm the metric is valid and active.
• AMS_ACT_METRIC_FACTS_ALL — The primary table storing activity metric facts. Read and written by CREATE, UPDATE, DELETE, LOCK, and COMPLETE routines.
• AMS_ACT_METRIC_FACTS_ALL_S — The sequence used to generate primary keys for new activity metric fact records.
• AMS_ACT_METRIC_FORMULAS — Stores formula definitions referenced when deriving or validating computed fact values; the July 2000 revision tied hierarchy nodes to unique formula_id values in this table.
• DUAL — Used for scalar lookups, sequence access, and simple validations.

Usage Notes

Because AMS_ACTMETRICFACT_PVT is a private package, it is not intended for direct invocation by external interfaces. Instead, it is called by the public marketing APIs and by Oracle Forms used to maintain activity metric facts. The package is referenced by one other PL/SQL package, which acts as the public entry point that enforces security and standard validation before delegating to these private routines. It is typically invoked during interactive form transactions (create, update, delete of activity metric facts), during concurrent program processing of metric facts, and by custom extensions that must replicate the same validation semantics. The VALIDATE_FUND_FACTS procedure is of particular interest when funds are modeled as activity metric facts, ensuring that fund amounts and related attributes conform to the fund fact model before storage. Developers extending the ETRM fund tracking feature should invoke the public wrapper rather than this private package directly.