APPS.BIV_DBI_CLO_PKG dependencies on BIS_QUERY_ATTRIBUTES_TBL

Line 13: , x_custom_output out nocopy bis_query_attributes_tbl

9:
10: procedure get_tbl_sql
11: ( p_param in bis_pmv_page_parameter_tbl
12: , x_custom_sql out nocopy varchar2
13: , x_custom_output out nocopy bis_query_attributes_tbl
14: , p_distribution in varchar2 := 'N'
15: )
16: is
17:

Line 31: l_custom_output bis_query_attributes_tbl;

27:
28: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
29: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
30:
31: l_custom_output bis_query_attributes_tbl;
32:
33: l_to_date_type VARCHAR2 (3) ;
34: l_as_of_date date;
35:

Line 215: , x_custom_output out nocopy bis_query_attributes_tbl

211:
212: procedure get_dbn_tbl_sql
213: ( p_param in bis_pmv_page_parameter_tbl
214: , x_custom_sql out nocopy varchar2
215: , x_custom_output out nocopy bis_query_attributes_tbl
216: )
217: is
218: begin
219: get_tbl_sql

Line 231: , x_custom_output out nocopy bis_query_attributes_tbl

227:
228: procedure get_trd_sql
229: ( p_param in bis_pmv_page_parameter_tbl
230: , x_custom_sql out nocopy varchar2
231: , x_custom_output out nocopy bis_query_attributes_tbl
232: , p_distribution in varchar2 := 'N'
233: )
234: is
235:

Line 249: l_custom_output bis_query_attributes_tbl;

245:
246: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
247: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
248:
249: l_custom_output bis_query_attributes_tbl;
250:
251: l_to_date_type VARCHAR2 (3) ;
252: l_as_of_date date;
253:

Line 396: , x_custom_output out nocopy bis_query_attributes_tbl

392:
393: procedure get_dbn_trd_sql
394: ( p_param in bis_pmv_page_parameter_tbl
395: , x_custom_sql out nocopy varchar2
396: , x_custom_output out nocopy bis_query_attributes_tbl
397: )
398: is
399: begin
400: get_trd_sql

Line 411: , x_custom_output out nocopy bis_query_attributes_tbl

407:
408: procedure get_detail_sql
409: ( p_param in bis_pmv_page_parameter_tbl
410: , x_custom_sql out nocopy varchar2
411: , x_custom_output out nocopy bis_query_attributes_tbl
412: )as
413:
414: l_where_clause varchar2(10000);
415: l_mv varchar2(10000);

Line 423: l_custom_output bis_query_attributes_tbl;

419: l_drill_url varchar2(500);
420: l_sr_id varchar2(100);
421:
422: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
423: l_custom_output bis_query_attributes_tbl;
424: l_as_of_date date;
425:
426: l_xtd varchar2(200);
427: begin

Line 518: l_custom_output := bis_query_attributes_tbl();

514: --|| biv_dbi_tmpl_util.dump_parameters(p_param)
515: ;
516:
517: if l_custom_output is null then
518: l_custom_output := bis_query_attributes_tbl();
519: end if;
520:
521: x_custom_output := l_custom_output;
522: