APPS.BIV_DBI_RES_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 214: , x_custom_output out nocopy bis_query_attributes_tbl

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

Line 230: , x_custom_output out nocopy bis_query_attributes_tbl

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

Line 248: l_custom_output bis_query_attributes_tbl;

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

Line 397: , x_custom_output out nocopy bis_query_attributes_tbl

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

Line 412: , x_custom_output out nocopy bis_query_attributes_tbl

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

Line 424: l_custom_output bis_query_attributes_tbl;

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

Line 519: l_custom_output := bis_query_attributes_tbl();

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