7:
8: g_closed_detail_rep_func varchar2(50) := 'BIV_DBI_RES_DTL_REP';
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: )
208:
209: end get_tbl_sql;
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
224: end get_dbn_tbl_sql;
225:
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: )
391:
392: end get_trd_sql;
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
406: );
407: end get_dbn_trd_sql;
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: