[Home] [Help]
138: -- x_xtd: returns a short coded representation of the selected
139: -- period type, needed so can be passed into
140: -- poa_dbi_template_pkg.trend_sql
141: procedure process_parameters
142: ( p_param in bis_pmv_page_parameter_tbl
143: , p_dimension_tbl in out nocopy t_dimension_tbl
144: , p_dim_filter_map in out nocopy poa_dbi_util_pkg.poa_dbi_dim_map
145: , p_trend in varchar2
146: , p_custom_output in out nocopy bis_query_attributes_tbl
157: -- occurance of a named parameter.
158: -- this is used internally and may also be used externally for
159: -- returning the value of any named parameter (e.g. 'ORDERBY')
160: function get_parameter_value
161: ( p_param in bis_pmv_page_parameter_tbl
162: , p_parameter_name in varchar2
163: )
164: return varchar2;
165:
169: -- returning the value of any named parameter (e.g. G_COST_ELEMENT)
170: -- by default "All" will be replaced with null unless
171: -- p_no_replace_all = Y
172: function get_parameter_id
173: ( p_param in bis_pmv_page_parameter_tbl
174: , p_parameter_name in varchar2
175: , p_no_replace_all in varchar2 default null
176: )
177: return varchar2;
324: -- note: the function should not be included in any code
325: -- released as it will cause a unique sql statement to be
326: -- generated each time, it is for development testing only.
327: function dump_parameters
328: ( p_param in bis_pmv_page_parameter_tbl )
329: return varchar2;
330:
331: -- this function allows you to create a second (or Nth) view by
332: -- in a report, for example asset downtime view by asset plus