Search Results ams_formula_pvt

Overview

APPS.AMS_FORMULA_PVT is a private PL/SQL package body in the Oracle E-Business Suite Applications schema, classified under the ETRM API taxonomy as a "PVT" (private) package. Its business purpose is to manage the definition, maintenance, validation, and execution of activity metric formulas used by Oracle Marketing (AMS) and related Oracle Advanced Planning or activity-based costing functionality. Formulas stored in the AMS_ACT_METRIC_FORMULAS tables allow an administrator to express a calculated performance metric as a combination of operands and entries, which the package then evaluates at runtime through its EXECUTE_FORMULA routine.

The object is documented as VALID in both Oracle EBS 12.1.1 and 12.2.2 environments and is not referenced by any other database object, confirming its status as an internal implementation library consumed only through its public wrapper, AMS_FORMULA_PVT is the public specification that exposes these routines to forms, concurrent programs, and other PL/SQL callers.

Key Procedures and Functions

The package body exposes seventeen documented procedures and functions covering the complete lifecycle of a formula header and its associated formula entries:

EXECUTE_FORMULA — Evaluates a stored formula against its runtime operand values and returns the calculated metric result.
CREATE_FORMULA — Inserts a new formula header record with its defining attributes.
UPDATE_FORMULA — Modifies the attributes of an existing formula header.
DELETE_FORMULA — Removes a formula header record.
LOCK_FORMULA — Obtains a row-level lock on a formula header to serialize concurrent maintenance.
VALIDATE_FORMULA — Performs validation logic on a formula header record.
VALIDATE_FORMULA_ITEMS — Validates the individual item set belonging to a formula.
VALIDATE_FORMULA_REC — Validates a full formula record structure.
COMPLETE_FORMULA_REC — Finalises or completes the setup of a formula record after validation.
CREATE_FORMULA_ENTRY — Inserts a new formula entry (operand or component) linked to a formula.
UPDATE_FORMULA_ENTRY — Modifies an existing formula entry.
DELETE_FORMULA_ENTRY — Removes a formula entry.
LOCK_FORMULA_ENTRY — Locks a formula entry row for controlled concurrent update.
VALIDATE_FORMULA_ENTRY — Validates an individual formula entry record.
VALIDATE_FORM_ENT_ITEMS — Validates the item set associated with a formula entry.
VALIDATE_FORM_ENT_REC — Validates a complete formula entry record structure.
COMPLETE_FORM_ENT_REC — Completes the setup of a formula entry record after validation.

Tables Accessed

The package reads and writes the following tables, all accessed via APPS synonyms:

AMS_ACT_METRIC_FORMULAS — the master table holding formula header definitions.
AMS_ACT_METRIC_FORMULAS_S — the shadow (TL) table supporting the formula header.
AMS_ACT_METRIC_FORM_ENT — the base table storing individual formula entries (operands/components).
AMS_ACT_METRIC_FORMULA_ENT_S — the shadow table for formula entries.
DUAL — used for PL/SQL level scalar evaluations and simple lookups.
PLITBLM — the PL/SQL index-by table of VARCHAR2 used for passing collections of arguments into EXECUTE_FORMULA.

Usage Notes

AMS_FORMULA_PVT is invoked indirectly through its public counterpart AMS_FORMULA_PVT and is typically called from the Oracle Marketing administrative forms when users define or maintain activity metric formulas, and from concurrent programs or custom PL/SQL that must evaluate a formula at runtime. The package relies on FND_API, FND_GLOBAL, FND_MESSAGE, FND_MSG_PUB, JTF_PLSQL_API, AMS_UTILITY_PVT, and STANDARD for error handling, API infrastructure, and message resolution. Because it is a PVT package, direct calls from custom code should be avoided; integrators should use the supported public API instead.

PACKAGE BODY: APPS.AMS_FORMULA_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:AMS_FORMULA_PVT, status:VALID,
PACKAGE BODY: APPS.AMS_FORMULA_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:AMS_FORMULA_PVT, status:VALID,
PACKAGE: APPS.AMS_FORMULA_PVT 12.1.1
owner:APPS, object_type:PACKAGE, object_name:AMS_FORMULA_PVT, status:VALID,
PACKAGE: APPS.AMS_FORMULA_PVT 12.2.2
owner:APPS, object_type:PACKAGE, object_name:AMS_FORMULA_PVT, status:VALID,
SYNONYM: APPS.AMS_ACT_METRIC_FORMULA_ENT_S 12.2.2
owner:APPS, object_type:SYNONYM, object_name:AMS_ACT_METRIC_FORMULA_ENT_S, status:VALID,
SYNONYM: APPS.AMS_ACT_METRIC_FORM_ENT 12.1.1
owner:APPS, object_type:SYNONYM, object_name:AMS_ACT_METRIC_FORM_ENT, status:VALID,
SYNONYM: APPS.AMS_ACT_METRIC_FORMULAS_S 12.2.2
owner:APPS, object_type:SYNONYM, object_name:AMS_ACT_METRIC_FORMULAS_S, status:VALID,
SYNONYM: APPS.AMS_ACT_METRIC_FORM_ENT 12.2.2
owner:APPS, object_type:SYNONYM, object_name:AMS_ACT_METRIC_FORM_ENT, status:VALID,
PACKAGE BODY: APPS.AMS_FORMULA_PVT_W 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:AMS_FORMULA_PVT_W, status:VALID,
SYNONYM: APPS.AMS_ACT_METRIC_FORMULAS_S 12.1.1
owner:APPS, object_type:SYNONYM, object_name:AMS_ACT_METRIC_FORMULAS_S, status:VALID,
SYNONYM: APPS.AMS_ACT_METRIC_FORMULA_ENT_S 12.1.1
owner:APPS, object_type:SYNONYM, object_name:AMS_ACT_METRIC_FORMULA_ENT_S, status:VALID,
SYNONYM: APPS.AMS_ACT_METRIC_FORMULAS 12.1.1
owner:APPS, object_type:SYNONYM, object_name:AMS_ACT_METRIC_FORMULAS, status:VALID,
SYNONYM: APPS.AMS_ACT_METRIC_FORMULAS 12.2.2
owner:APPS, object_type:SYNONYM, object_name:AMS_ACT_METRIC_FORMULAS, status:VALID,
PACKAGE BODY: APPS.AMS_FORMULA_PVT_W 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:AMS_FORMULA_PVT_W, status:VALID,
PACKAGE: APPS.AMS_FORMULA_PVT 12.1.1
PACKAGE: APPS.JTF_PLSQL_API 12.2.2
owner:APPS, object_type:PACKAGE, object_name:JTF_PLSQL_API, status:VALID,
PACKAGE: APPS.AMS_FORMULA_PVT 12.2.2
12.1.1 DBA Data 12.1.1
PACKAGE: APPS.JTF_PLSQL_API 12.1.1
owner:APPS, object_type:PACKAGE, object_name:JTF_PLSQL_API, status:VALID,
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1
12.2.2 DBA Data 12.2.2
APPS.AMS_FORMULA_PVT_W dependencies on AMS_FORMULA_PVT 12.1.1
APPS.AMS_FORMULA_PVT dependencies on AMS_FORMULA_PVT 12.1.1
PACKAGE: APPS.AMS_UTILITY_PVT 12.2.2
owner:APPS, object_type:PACKAGE, object_name:AMS_UTILITY_PVT, status:VALID,
APPS.AMS_FORMULA_PVT_W dependencies on AMS_FORMULA_PVT 12.2.2
APPS.AMS_FORMULA_PVT dependencies on AMS_FORMULA_PVT 12.2.2
PACKAGE: APPS.AMS_UTILITY_PVT 12.1.1
owner:APPS, object_type:PACKAGE, object_name:AMS_UTILITY_PVT, status:VALID,
PACKAGE BODY: APPS.AMS_FORMULA_PVT 12.1.1
PACKAGE BODY: APPS.AMS_FORMULA_PVT 12.2.2
PACKAGE: APPS.FND_MSG_PUB 12.2.2
owner:APPS, object_type:PACKAGE, object_name:FND_MSG_PUB, status:VALID,
PACKAGE: APPS.FND_MSG_PUB 12.1.1
owner:APPS, object_type:PACKAGE, object_name:FND_MSG_PUB, status:VALID,
SYNONYM: PUBLIC.DUAL 12.2.2
owner:PUBLIC, object_type:SYNONYM, object_name:DUAL, status:VALID,
SYNONYM: PUBLIC.DUAL 12.1.1
owner:PUBLIC, object_type:SYNONYM, object_name:DUAL, status:VALID,
PACKAGE: APPS.FND_API 12.2.2
owner:APPS, object_type:PACKAGE, object_name:FND_API, status:VALID,
PACKAGE: APPS.FND_API 12.1.1
owner:APPS, object_type:PACKAGE, object_name:FND_API, status:VALID,
SYNONYM: PUBLIC.PLITBLM 12.1.1
owner:PUBLIC, object_type:SYNONYM, object_name:PLITBLM, status:VALID,
PACKAGE: APPS.FND_GLOBAL 12.2.2
owner:APPS, object_type:PACKAGE, object_name:FND_GLOBAL, status:VALID,
SYNONYM: PUBLIC.PLITBLM 12.2.2
owner:PUBLIC, object_type:SYNONYM, object_name:PLITBLM, status:VALID,
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1
12.1.1 DBA Data 12.1.1
PACKAGE: APPS.FND_GLOBAL 12.1.1
owner:APPS, object_type:PACKAGE, object_name:FND_GLOBAL, status:VALID,
PACKAGE: APPS.FND_MESSAGE 12.2.2
owner:APPS, object_type:PACKAGE, object_name:FND_MESSAGE, status:VALID,
PACKAGE: APPS.FND_MESSAGE 12.1.1
owner:APPS, object_type:PACKAGE, object_name:FND_MESSAGE, status:VALID,
PACKAGE: SYS.STANDARD 12.1.1
owner:SYS, object_type:PACKAGE, object_name:STANDARD, status:VALID,