[Home] [Help]
180: ( p_param in bis_pmv_page_parameter_tbl
181: , p_dimension_tbl in out nocopy t_dimension_tbl
182: , p_dim_filter_map in out nocopy poa_dbi_util_pkg.poa_dbi_dim_map
183: , p_trend in varchar2
184: , p_custom_output in out nocopy bis_query_attributes_tbl
185: , x_cur_suffix out nocopy varchar2
186: , x_where_clause out nocopy varchar2
187: , x_viewby_select out nocopy varchar2
188: , x_join_tbl out nocopy poa_dbi_util_pkg.poa_dbi_join_tbl
198: ( p_param in bis_pmv_page_parameter_tbl
199: , p_dimension_tbl in out nocopy t_dimension_tbl
200: , p_dim_filter_map in out nocopy poa_dbi_util_pkg.poa_dbi_dim_map
201: , p_trend in varchar2
202: , p_custom_output in out nocopy bis_query_attributes_tbl
203: , x_cur_suffix out nocopy varchar2
204: , x_where_clause out nocopy varchar2
205: , x_viewby_select out nocopy varchar2
206: , x_join_tbl out nocopy poa_dbi_util_pkg.poa_dbi_join_tbl
346: -- is important and must match the grouping_id clause in the
347: -- corresponding MV defintion.
348: procedure bind_group_id
349: ( p_dim_bmap in number
350: , p_custom_output in out nocopy bis_query_attributes_tbl
351: , p_column1 in varchar2 default null
352: , p_column2 in varchar2 default null
353: , p_column3 in varchar2 default null
354: , p_column4 in varchar2 default null
469: -- p_parameter_value: this is the value to be used for the bind value, it needs
470: -- to be compatible with p_parameter_data_type, for DATE_BIND
471: -- pass date as DD/MM/YYYY
472: procedure add_custom_bind_parameter
473: ( p_custom_output in out nocopy bis_query_attributes_tbl
474: , p_parameter_name in varchar2
475: , p_parameter_data_type in varchar2
476: , p_parameter_value in varchar2
477: );
491: procedure bind_low_high
492: ( p_param in bis_pmv_page_parameter_tbl
493: , p_param_name in varchar2
494: , p_short_name in varchar2
495: , p_custom_output in out nocopy bis_query_attributes_tbl
496: , p_low_token in varchar2 default null
497: , p_high_token in varchar2 default null
498: );
499: