[Home] [Help]
176: -- x_uom_suffix: returns "km" or "mi" based on the distance UOM parameter,
177: -- needed for travel reports to determine distance UOM
178: -- column to use.
179: procedure process_parameters
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
194:
195: -- this is an overload of process_parameters that does not return
196: -- x_uom_suffix.
197: procedure process_parameters
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
213: -- occurance of a named parameter.
214: -- this is used internally and may also be used externally for
215: -- returning the value of any named parameter (e.g. 'ORDERBY')
216: function get_parameter_value
217: ( p_param in bis_pmv_page_parameter_tbl
218: , p_parameter_name in varchar2
219: )
220: return varchar2;
221:
225: -- returning the value of any named parameter (e.g. G_COST_ELEMENT)
226: -- by default "All" will be replaced with null unless
227: -- p_no_replace_all = Y
228: function get_parameter_id
229: ( p_param in bis_pmv_page_parameter_tbl
230: , p_parameter_name in varchar2
231: , p_no_replace_all in varchar2 default null
232: )
233: return varchar2;
380: -- note: the function should not be included in any code
381: -- released as it will cause a unique sql statement to be
382: -- generated each time, it is for development testing only.
383: function dump_parameters
384: ( p_param in bis_pmv_page_parameter_tbl )
385: return varchar2;
386:
387: -- this function allows you to create a second (or Nth) view by
388: -- in a report, for example asset downtime view by asset plus
399: return varchar2;
400:
401: -- this procedure is a noop
402: procedure check_district_filter
403: ( p_param in bis_pmv_page_parameter_tbl
404: , p_dim_map in out nocopy poa_dbi_util_pkg.poa_dbi_dim_map
405: );
406:
407: -- this function returns the portion of the inner query select stmt
488: -- value, defaults to &ISC_FS_LOW
489: -- p_high_token: optionally provide the bind variable name to use for low
490: -- value, defaults to &ISC_FS_HIGH
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
604: -- It returns Y if the district is a leaf node district or a resource,
605: -- otherwise returns N.
606: -- p_param: the parameter table passed into your report from PMV.
607: function is_district_leaf_node
608: ( p_param in bis_pmv_page_parameter_tbl
609: )
610: return varchar2;
611:
612: end isc_fs_rpt_util_pkg;