Search Results default_func_currency

Overview

APPS.AMS_ACTMETRIC_PVT is a private PL/SQL package within the Oracle E-Business Suite Marketing (AMS) module, responsible for the core business logic supporting Activity Metrics. Activity metrics represent quantifiable performance measurements — cost, revenue, response counts, or similar units — collected against marketing activities, campaigns, deliverables, and events in the Oracle Marketing and Oracle Trade Management schemas. The package defines the constants, record types, and procedures that together form the internal implementation layer behind the public activity metric API.

The package is classified as PVT (private), meaning it is not intended for direct invocation by external or customer-written code; the public wrapper packages are the supported entry points. As the implementation layer, AMS_ACTMETRIC_PVT encapsulates create, update, delete, lock, and validation operations against the activity metrics tables, plus currency conversion, rollup synchronization, forecasted cost checking, and cost posting. Its documented history begins in release 11.5.6 and it remains present in EBS 12.1.1 and 12.2.2.

Key Procedures and Functions

• CREATE_ACTMETRIC — Establishes a new activity metric record, applying defaulting and validation before insert into the base table.
• UPDATE_ACTMETRIC — Modifies an existing activity metric, including dependent-metric and rollup implications.
• DELETE_ACTMETRIC — Removes an activity metric record.
• LOCK_ACTMETRIC — Obtains a locking handle on a metric row to guard concurrent modification.
• VALIDATE_ACTMETRIC, VALIDATE_ACTMETRIC_ITEMS, VALIDATE_ACTMETRIC_RECORD — Perform attribute-level, line-level, and full-record validation respectively, enforcing required values and referential integrity prior to persistence.
• INIT_ACTMETRIC_REC — Initializes the working record structure, typically used in update flows to seed pre-existing values.
• COMPLETE_ACTMETRIC_REC — Fills in derived or defaulted fields on the record that were not explicitly supplied.
• DEFAULT_FUNC_CURRENCY — Resolves the functional currency for the operating context; this is the procedure surfaced by the search term "default_func_currency". It underpins the currency setting used by CONVERT_CURRENCY and CONVERT_CURRENCY2.
• CONVERT_CURRENCY, CONVERT_CURRENCY2 — Convert metric amounts between currencies using FND_CURRENCIES rates; the second variant supports an alternate conversion path.
• SYNC_ROLLUP_CURRENCY — Aligns rolled-up metric amounts with the appropriate rollup currency.
• CHECK_FORECASTED_COST — Tests whether a metric's cost exceeds its forecasted cost budget.
• SETCOMMITTEDVAL — Sets committed value amounts on the metric.
• POST_COSTS — Posts activity metric costs to the appropriate accounting/budget context.
• MAKE_ACTMETRIC_DIRTY, INVALIDATE_ROLLUP — Mark metric and rollup records as requiring recomputation.
• GET_OBJECT_INFO — Retrieves metadata about the owning object of a metric.
• HAVE_PUBLISHED — Reports whether the metric or its owning object has been published.

Tables Accessed

• AMS_ACT_METRICS_ALL, AMS_ACT_METRICS_ALL_S — Primary storage for activity metrics and their related security/summary views.
• AMS_ACT_METRIC_HST, AMS_ACT_METRIC_HST_S — Historical versions of metric records.
• AMS_METRICS_ALL_B, AMS_METRIC_FORMULAS — Metric definitions and the formulas used to compute derived values.
• AMS_ACT_LISTS — Activity lists associated with metrics.
• AMS_CAMPAIGNS_ALL_B, AMS_CAMPAIGN_SCHEDULES_B — Campaign headers and schedules that own or reference metrics.
• AMS_DELIVERABLES_ALL_B, AMS_EVENT_HEADERS_ALL_B, AMS_EVENT_OFFERS_ALL_B — Deliverable, event, and event-offer objects against which metrics are recorded.
• FND_CURRENCIES — Currency definitions and conversion rates used by DEFAULT_FUNC_CURRENCY and CONVERT_CURRENCY.
• MTL_UNITS_OF_MEASURE — Units of measure validating metric quantities.
• OZF_ACT_BUDGETS — Trade Management activity budgets used by CHECK_FORECASTED_COST and POST_COSTS.

Usage Notes

AMS_ACTMETRIC_PVT is invoked indirectly through public AMS wrapper packages rather than called directly by forms or concurrent programs. It is referenced by nine other packages, reflecting its role as a shared internal service layer for metric persistence and currency conversion. Customizations should target the public activity metric API and never depend on this package's signatures, as it is a private implementation subject to change across patch levels. Because it is not covered by the standard ASO "noship" build path at header revision 120.1, no formal external interface is exposed; its documented behavior is stable but unsupported for direct calls.