Search Results get_rates_table_sql




Overview
Explore in AI Chat

Overview

The OKI_DBI_SRM_BKRNWL_PVT package is a private PL/SQL package owned by the APPS schema in Oracle E-Business Suite. Its name and structure tie it to the Oracle Daily Business Intelligence (DBI) reporting framework and the Supplier Relationship Management (SRM) subject area, with a specific focus on booking and renewal (BKRNWL) analytics. In EBS 12.1.1 and 12.2.2, DBI pages are rendered by a metadata-driven engine that assembles a query at runtime from page parameters. Packages such as this one act as the interface between that engine and the underlying transactional tables.

The package exposes a small, purpose-built API classified as PVT (private), meaning it is not intended as a public integration point. It is invoked internally by the DBI presentation layer rather than being called directly by customer code. The three procedures it exposes supply the SQL text and column-attribute metadata needed to populate a booking-and-renewal report region.

Key Procedures and Functions

The package documents three procedures, each following the same DBI interrogation signature pattern.

  • GET_TABLE_SQL — The procedure most closely associated with the user's search term. It returns the custom SQL statement (x_custom_sql) that drives the tabular booking-and-renewal report, together with the output attribute definitions (x_custom_output) that describe columns, data types, and display properties.
  • GET_RATES_TABLE_SQL — Provides the SQL and attribute metadata for the rates-oriented tabular region of the same report. It follows the identical two-output convention as GET_TABLE_SQL.
  • GET_TREND_SQL — Supplies the SQL and attribute metadata for the trend analysis region, which presents booking and renewal activity over time.

All three procedures accept a single IN parameter of type BIS_PMV_PAGE_PARAMETER_TBL, the standard DBI page-parameter collection, and return VARCHAR2 SQL text alongside a BIS_QUERY_ATTRIBUTES_TBL attribute table. No parameter lists beyond these documented signatures should be assumed.

Tables Accessed

The ETRM metadata records a single referenced table via an APPS synonym: PLITBLM. In the EBS data model, PLITBLM is a PL/SQL internal table type used within the Oracle Applications technology stack. Its presence here indicates the package constructs or stages tabular data in memory before handing the result set to the DBI rendering engine. No base business tables are documented as directly referenced by this private package; the transactional booking-and-renewal data is presumed to be resolved through the SQL text that the procedures return rather than through static DML in the package body.

Usage Notes

Because OKI_DBI_SRM_BKRNWL_PVT is a PVT-classified package, it is not a supported public API and should not be called from custom concurrent programs or forms. It is invoked indirectly whenever users or administrators run the Oracle DBI booking-and-renewal page in the SRM dashboard. The procedures are called by the DBI page engine, which passes the active page parameters and receives back the SQL and column metadata required to build the report.

The package header carries a header revision of 120.1 dated 2006, indicating a long-stable interface carried forward into later EBS releases. Customizations that need to alter booking-and-renewal reporting should target the DBI page metadata or the underlying SQL logic rather than modifying this package, since changes risk breaking the private contract with the DBI engine. The metadata records no other packages referencing this one, confirming its role as a leaf-level component in the reporting stack.