Search Results tot_calls




Overview
Explore in AI Chat

Overview

BIX_PMV_AO_AGTDTL_RPT_PKG is an Oracle E-Business Suite reporting package that belongs to the BIX (Business Intelligence) application module and resides in the APPS schema. Its header comment identifies the source file as bixoagdr.plb, last revised in 2004 for the 11.5.x code line, and it remains present in the 12.1.1 and 12.2.2 environments. The package supports the "Agent Detail" page of the Oracle Marketing / TeleSales Performance Management Viewer (PMV) framework, which presents ad hoc, drillable analytical output through self-service HTML pages rather than through fixed concurrent reports.

The package name resolves as BIX (Business Intelligence Extension) + PMV (Performance Management Viewer) + AO (Agent/Activity Organizer) + AGTDTL (Agent Detail). It therefore renders the agent-level detail query used by marketing and call-center users to analyze agent activity across campaigns, call centers, schedules, and source codes for a selected as-of date and comparison period.

Key Procedures and Functions

  • GET_SQL — The single documented procedure and the functional core of the package. It accepts the PMV page parameter table (BIS_PMV_PAGE_PARAMETER_TBL) and returns dynamically constructed SQL text together with a PMV custom output attribute table (BIS_QUERY_ATTRIBUTES_TBL). Internally it declares local variables for the as-of date, period type, comparison type, call center, campaign, schedule, source code, agent group, and view-by selection, then calls BIX_PMV_DBI_UTL_PKG.get_ao_page_params to populate them. Based on which parameters are non-null, the procedure concatenates conditional WHERE fragments — for example, restricting fact.server_group_id when a call center is chosen, fact.campaign_id when a campaign is chosen, and fact.schedule_id when a schedule is chosen. The completed statement is returned to the PMV engine for execution.

Notably, the source excerpt contains no occurrence of the search term tot_calls. Agent call totals are computed by the generated SQL rather than by a named PL/SQL variable in this unit.

Tables Accessed

ETRM metadata lists a single referenced object, PLITBLM. This is the PL/SQL-independent "PL/SQL Interface Table" used by the BIS/BIX PMV framework to pass page parameter rows and query attributes between the viewer runtime and the reporting packages. Because the package builds SQL text instead of executing it, the base fact and dimension tables (agent, campaign, call center, and schedule) are referenced through the generated query and resolved at runtime by the PMV engine; they are not listed as static dependencies of the package body itself.

Usage Notes

The package is invoked indirectly by the Oracle Marketing Performance Management Viewer framework whenever a user opens or refreshes the Agent Detail page. The PMV runtime resolves the page definition, calls GET_SQL to obtain the parameter-driven SQL and custom column metadata, then executes the returned statement against the reporting schema. It is not intended for direct invocation from forms, concurrent programs, or custom code, although developers extending PMV pages commonly model custom reporting packages on this structure — accepting the page parameter table, delegating to BIX_PMV_DBI_UTL_PKG for parameter parsing, and returning both SQL text and query attributes.

Because GET_SQL returns SQL as a string, the actual number of rows and columns displayed depends entirely on the parameters the user selects and the structure of the underlying Business Intelligence fact views. The package carries no business rules of its own beyond optional WHERE-clause assembly and localization of the "Unknown" label via FND_MESSAGE.GET_STRING, which is retrieved from the BIX message dictionary and falls back to the literal 'Unknown' if the message is unavailable. The documented dependency count of zero other packages confirms that this unit is a terminal reporting component in the PMV call chain rather than a shared utility.