Search Results ams_io_other

Overview

AMS_DCF_LEADS_TITLE is a PL/SQL package body owned by APPS in the Oracle E-Business Suite, classified under the channel/CRM reporting layer that supports the DCF (Data Collection Framework) used by Oracle Marketing and related analytics modules. Its business function is to dynamically resolve and return display titles for Business Intelligence (BI) KPI bins and reports. Rather than storing static labels, the package derives titles at runtime from parameters supplied by the calling reporting engine and from lookup tables, so that the same report definition renders correctly across periods, organizational contexts, and languages. The package header file reference (amsvldsb.pls, version 115.3, dated 2002) indicates an early-generation component that has remained stable through the 12.1.1 and 12.2.2 releases.

Key Procedures and Functions

The package exposes nine documented procedures and functions, all centered on title generation for KPI and regional report bin displays:

• PRINT_KPI_BIN_TITLE — Returns a formatted title for a KPI bin, typically resolving the reporting period into a human-readable date range.
• PRINT_KPI_REPORT_TITLE — Returns the top-level title for a KPI report, deriving the report name from DCF component configuration and lookup values.
• PRINT_REG_REPORT_TITLE — Produces the report-level title for regional variants of the reporting output.
• PRINT_REG_BIN_TITLE — Generates the standard bin title for regional reports.
• PRINT_REG_BIN_TITLE_LS — A specialized bin title variant, distinguished by the LS suffix (a region- or dimension-specific rendering).
• PRINT_REG_BIN_TITLE_LQ — The LQ variant of the regional bin title function.
• PRINT_REG_BIN_TITLE_WS — The WS variant of the regional bin title function.
• PRINT_REG_BIN_TITLE_IS — The IS variant of the regional bin title function.
• PRINT_REG_BIN_TITLE_WR — The WR variant of the regional bin title function.

The variants exist to accommodate different geographic or organizational roll-up definitions while sharing the same underlying formatting and lookup logic.

Tables Accessed

The package reads from the following objects through APPS synonyms:

• BIM_R_PERIODS — Supplies the start and end dates used to format the period portion of each title, filtered by period type and fixed calculation type.
• FND_LOOKUP_VALUES — Provides the translated report or component name and related lookup meanings, resolved against the session language for multilingual support.
• BIM_R_LEAD_QU_BIN_MV — A materialized view supplying lead quantity bin data referenced by the regional title functions.

All accesses are read-only; the package does not persist data.

Usage Notes

AMS_DCF_LEADS_TITLE is invoked at report-render time by the DCF reporting engine and by concurrent programs that produce KPI and regional lead reports. It is not referenced by any other PL/SQL package, so its consumers are external: BI Publisher templates, Oracle Reports layouts, and OAF or Forms-based analytics pages that need dynamically resolved headings. The package also depends on AMS_DCF_GET_PARAMETER_VALUE logic and the utility function AMS_UTILITY_PVT.GET_LOOKUP_MEANING (the source of the AMS_IO_OTHER lookup set associated with the user's search term, ams_io_scale_by). Customizations should treat the package as a display-layer utility, extending lookup values rather than altering the package body, to preserve upgrade safety across 12.1.1 and 12.2.2.