Search Results ams_default_curr_code

Overview

AMS_DCF_TITLE is a PL/SQL package body owned by APPS within the Oracle E-Business Suite Marketing (AMS) module. Its documented purpose is the construction and delivery of titles and header strings used by Oracle Marketing analytics dashboards and dependent reporting components. The package encapsulates the title-generation logic that surrounds KPI bins, regional report headers, incremental and non-cumulative report captions, and currency annotations displayed on dashboard pages. It is classified as an OTHER API, indicating that it is an internal implementation utility rather than a public, supported programmatic interface. The header comment identifies the source revision as amsvdtlb.pls 120.1 2011/11/18, consistent with the 12.1.1 and 12.2.2 code lines. Because the package drives presentation-layer text rather than transaction processing, its functions are read-only with respect to business data and are typically invoked while rendering a dashboard region.

Key Procedures and Functions

The ETRM metadata documents fourteen procedures and functions. GET_CURRENCY returns a formatted currency annotation assembled from the profile option AMS_DEFAULT_CURR_CODE, lookups in AMS_IO_OTHER (IN/FOR), and the scale-by lookup AMS_IO_SCALE_BY, resolved through JTBF_DCF.GET_PARAMETER_VALUE. PRINT_CURRENCY provides the corresponding printable currency title. PRINT_KPI_BIN_TITLE builds the caption for a KPI bin, using the P_PERIOD_TYPE parameter to derive a date range from BIM_R_PERIODS.

The regional bin title functions — PRINT_REG_BIN_TITLE_KPI, PRINT_REG_BIN_TITLE_MB, PRINT_REG_BIN_TITLE_CE, and PRINT_REG_BIN_TITLE_EE — produce bin captions for the KPI, Marketing Budget, Campaign Effectiveness, and Event Effectiveness dashboard variants. PRINT_REG_REPORT_TITLE, PRINT_REG_REPORT_NC_TITLE, and PRINT_REG_INCREMENTAL_TITLE generate report-level, non-cumulative, and incremental report headings for the regional dashboard family. PRINT_HOM_REPORT_TITLE and PRINT_HOM_REPORT_NC_TITLE perform the equivalent role for the home (summary) dashboard. PRINT_MKTG_ACTIVITIES_TITLE supplies the heading for the marketing activities region. Parameter lists are not asserted beyond the documented p_parameters convention; each function resolves its inputs through dashboard framework parameters.

Tables Accessed

The package reads from a small, well-defined set of objects. BIM_R_PERIODS supplies period start and end dates used to render fixed period ranges in bin and report titles. The materialized views BIM_R_CAMP_ACT_BIN_MV, BIM_R_CAMP_DIM_SUM_MV, BIM_R_EVEN_DIM_SUM_MV, and BIM_R_FD_DIM_SUM_MV back the activity, campaign dimension, event dimension, and financial dimension dashboard summaries whose titles this package generates. FND_LOOKUP_VALUES is consulted for lookup meanings, including the scale-by meaning and the IN/FOR connectors accessed via AMS_UTILITY_PVT. DUAL is used for single-row expression evaluation. All access is read-only; no inserts, updates, or deletes are documented.

Usage Notes

AMS_DCF_TITLE is invoked indirectly through the Oracle Marketing dashboard framework, which passes runtime parameters and retrieves the resulting title strings during page rendering. Because the documented procedures include no public parameter signatures beyond p_parameters, custom code should not call these functions directly. The functions consistently return a blank space or empty string through their exception handlers, ensuring that a title-generation failure never prevents dashboard rendering. The AMS_DEFAULT_CURR_CODE profile option governs the currency text returned by GET_CURRENCY and PRINT_CURRENCY, so implementations that localize currency display must maintain that profile setting. The package is referenced by zero other packages, confirming its position as a terminal presentation utility. No supported extension points are documented.