2: /* $Header: bivsrvrclos.pls 115.1 2004/01/16 02:55:59 kreardon noship $ */
3: AUTHID CURRENT_USER as
4:
5: procedure get_tbl_sql
6: ( p_param in bis_pmv_page_parameter_tbl
7: , x_custom_sql out nocopy varchar2
8: , x_custom_output out nocopy bis_query_attributes_tbl
9: , p_distribution in varchar2 := 'N'
10: );
9: , p_distribution in varchar2 := 'N'
10: );
11:
12: procedure get_dbn_tbl_sql
13: ( p_param in bis_pmv_page_parameter_tbl
14: , x_custom_sql out nocopy varchar2
15: , x_custom_output out nocopy bis_query_attributes_tbl
16: );
17:
15: , x_custom_output out nocopy bis_query_attributes_tbl
16: );
17:
18: procedure get_trd_sql
19: ( p_param in bis_pmv_page_parameter_tbl
20: , x_custom_sql out nocopy varchar2
21: , x_custom_output out nocopy bis_query_attributes_tbl
22: , p_distribution in varchar2 := 'N'
23: );
22: , p_distribution in varchar2 := 'N'
23: );
24:
25: procedure get_dbn_trd_sql
26: ( p_param in bis_pmv_page_parameter_tbl
27: , x_custom_sql out nocopy varchar2
28: , x_custom_output out nocopy bis_query_attributes_tbl
29: );
30:
28: , x_custom_output out nocopy bis_query_attributes_tbl
29: );
30:
31: procedure get_detail_sql
32: ( p_param in bis_pmv_page_parameter_tbl
33: , x_custom_sql out nocopy varchar2
34: , x_custom_output out nocopy bis_query_attributes_tbl
35: );
36: