DBA Data[Home] [Help]

APPS.POA_DBI_INV_PKG dependencies on BIS_QUERY_ATTRIBUTES

Line 26: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

22: -- |----------------------------< status_sql >---------------------------|
23: -- -----------------------------------------------------------------------
24: PROCEDURE status_sql(p_param IN BIS_PMV_PAGE_PARAMETER_TBL
25: ,x_custom_sql OUT NOCOPY VARCHAR2
26: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
27: IS
28: l_query VARCHAR2(32000);
29: l_view_by VARCHAR2(120);
30: l_view_by_col VARCHAR2(120);

Line 48: l_custom_rec BIS_QUERY_ATTRIBUTES;

44: l_where_clause VARCHAR2(2000);
45: l_where_clause2 VARCHAR2(2000);
46: l_mv VARCHAR2(30);
47: l_mv2 VARCHAR2(30);
48: l_custom_rec BIS_QUERY_ATTRIBUTES;
49: ERR_MSG VARCHAR2(100);
50: l_sec_context varchar2(10);
51: l_use_only_agg_mv varchar2(1);
52: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;

Line 362: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

358: -- |-----------------------------< trend_sql >---------------------------|
359: -- -----------------------------------------------------------------------
360: PROCEDURE trend_sql(p_param IN BIS_PMV_PAGE_PARAMETER_TBL
361: ,x_custom_sql OUT NOCOPY VARCHAR2
362: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
363: IS
364: l_query VARCHAR2(10000);
365: l_view_by VARCHAR2(120);
366: l_view_by_col_name VARCHAR2(120);