DBA Data[Home] [Help]

APPS.POA_DBI_APL_PKG dependencies on BIS_PMV_PAGE_PARAMETER_TBL

Line 16: procedure status_sql(p_param in bis_pmv_page_parameter_tbl,

12: FUNCTION get_trend_sel_clause(p_type in varchar2 := 'trend') return VARCHAR2;
13: FUNCTION get_status_filter_where return VARCHAR2;
14: FUNCTION get_kpi_filter_where return VARCHAR2;
15:
16: procedure status_sql(p_param in bis_pmv_page_parameter_tbl,
17: x_custom_sql out nocopy varchar2,
18: x_custom_output out nocopy bis_query_attributes_tbl)
19: is
20: l_query varchar2(10000);

Line 198: procedure trend_sql(p_param in bis_pmv_page_parameter_tbl,

194: end if; /* l_sec_context = 'OU' or l_sec_context = 'OU/COM' */
195: x_custom_sql := l_query;
196: end;
197:
198: procedure trend_sql(p_param in bis_pmv_page_parameter_tbl,
199: x_custom_sql out nocopy varchar2,
200: x_custom_output out nocopy bis_query_attributes_tbl)
201: is
202: l_query varchar2(10000);

Line 380: procedure kpi_sql(p_param in bis_pmv_page_parameter_tbl,

376: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);
377:
378: END;
379:
380: procedure kpi_sql(p_param in bis_pmv_page_parameter_tbl,
381: x_custom_sql out nocopy varchar2,
382: x_custom_output out nocopy bis_query_attributes_tbl)
383: is
384: l_query varchar2(4000);