Search Results get_def_time_comp




Overview
Explore in AI Chat

Overview

APPS.BIV_DBI_PARAM_PKG is a database package body that belongs to the Oracle EBS Business Intelligence (BIV) subsystem, specifically the Daily Business Intelligence (DBI) reporting layer. Its principal business function is to assemble and return a formatted parameter string that is consumed by DBI region pages and dashboards. The parameter string follows the Oracle EBS "&NAME=value" URL/parameter convention and supplies runtime context such as the as-of date, the default time period, the time comparison basis, and view-by dimensions that determine how a DBI region renders its data.

The package is classified in ETRM as an OTHER API, meaning it is treated as an internal supporting utility rather than a published integration interface. The header comment identifies the source file as bivsrvrparb.pls and the header revision as 120.0, dated 2005/05/24, indicating that the object has been stable since the early 12.x releases. It is present in both Oracle EBS 12.1.1 and 12.2.2, where it remains an internal DBI parameter helper. Users encounter the object most often when tracing the origin of a DBI region parameter, which explains the recurring search interest in get_def_time_per.

Key Procedures and Functions

  • GET_PARAMS — The primary documented function. It accepts an optional region code and returns a VARCHAR2 parameter string. It builds the base string using the system date for the as-of date, calls the other two functions to embed the default time period and the default time comparison, appends fixed request-type and item-category parameters, and conditionally appends a status filter for unresolved service-request regions. A final CASE expression appends a VIEW_BY value that varies with the region code.
  • GET_DEF_TIME_PER — Returns the default time period used by DBI pages. Consistent with the excerpt, it returns a rolling-month style token (TIME+FII_ROLLING_MONTH), which is then matched by GET_PARAMS against patterns such as FII_ROLLING_WEEK, FII_ROLLING_MONTH, FII_ROLLING_QTR, and FII_ROLLING_YEAR to select the correct parameter name.
  • GET_DEF_TIME_COMP — Returns the default time comparison used by DBI pages. GET_PARAMS inspects its value: when it contains YEARLY, a YEARLY parameter is emitted; otherwise a SEQUENTIAL parameter is emitted.

Tables Accessed

Per the ETRM metadata, no tables are referenced through APPS synonyms. The package is a pure computational utility with no direct SQL against application tables. All dynamic values are derived at runtime from SYSDATE and from API calls into the FND date utility, FND_DATE.DATE_TO_CHARDATE, which converts the truncated system date into a character representation suitable for the parameter string. Because the package holds no persistent state and performs no DML, it carries no transactional impact.

Usage Notes

The package is invoked internally by DBI region rendering infrastructure rather than by end users directly. GET_PARAMS is called with a region code when a DBI page is built; the returned string is used to construct the region's parameter context. The comments in the excerpt note two behavioural details: the literal "All" must remain in mixed case for correct matching, and certain unresolved-service-request regions require the BIV_RES_STATUS=N filter to display only open requests. Region codes containing TRD receive a VIEW_BY based on the default time period; TBL regions receive a severity-based view; KPI regions receive a request-type view; and PARAM regions receive the base string only. Custom code that calls this package should treat the returned string as opaque and should not depend on its internal ordering, since the CASE logic may evolve. No other APPS packages are documented as referencing it, confirming its role as a terminal helper within the DBI parameter flow.