DBA Data[Home] [Help]

APPS.POA_DBI_APL_PKG dependencies on BIS_QUERY_ATTRIBUTES

Line 18: x_custom_output out nocopy bis_query_attributes_tbl)

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);
21: l_view_by varchar2(120);
22: l_view_by_col varchar2(120);

Line 200: x_custom_output out nocopy bis_query_attributes_tbl)

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);
203: l_view_by varchar2(120);
204: l_view_by_col varchar2(120);

Line 382: x_custom_output out nocopy bis_query_attributes_tbl)

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);
385: l_view_by varchar2(120);
386: l_view_by_col varchar2(120);

Line 401: l_custom_rec BIS_QUERY_ATTRIBUTES;

397: l_mv varchar2(30);
398: l_join_rec poa_dbi_util_pkg.POA_DBI_JOIN_REC;
399: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
400: l_in_join_tbl poa_dbi_util_pkg.POA_DBI_IN_JOIN_TBL;
401: l_custom_rec BIS_QUERY_ATTRIBUTES;
402: l_view_by_value varchar2(100);
403: begin
404: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
405: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();