APPS.BIV_DBI_TMPL_UTIL dependencies on BIS_PMV_PAGE_PARAMETER_TBL

Line 27: ( p_param in bis_pmv_page_parameter_tbl )

23: -- when poa_dbi_util_pkg.get_parameter_values is updated to handle
24: -- rolling periods this function will not be needed.
25: --
26: function get_period_type
27: ( p_param in bis_pmv_page_parameter_tbl )
28: return varchar2;
29:
30: -- this is biv specific and should remain in this package.
31: procedure process_parameters

Line 32: ( p_param in bis_pmv_page_parameter_tbl

28: return varchar2;
29:
30: -- this is biv specific and should remain in this package.
31: procedure process_parameters
32: ( p_param in bis_pmv_page_parameter_tbl
33: , p_report_type in varchar2 -- 'ACTIVITY','CLOSED','BACKLOG','BACKLOG_AGE'
34: , p_trend in varchar2
35: , x_view_by out nocopy varchar2
36: , x_view_by_col_name out nocopy varchar2

Line 68: ( p_param in bis_pmv_page_parameter_tbl )

64: -- the join/where logic from biv_dbi_template_pkg.status_sql
65: -- anyway.
66: -- this is biv specific and should remain in this package
67: function get_backlog_type
68: ( p_param in bis_pmv_page_parameter_tbl )
69: return varchar2;
70:
71: -- get_bucket_outer_query function returns the columns for the
72: -- outer select statement for the buckets based on the

Line 123: ( p_param in bis_pmv_page_parameter_tbl )

119: -- contents of the parameters provided by PMV
120: -- note: it should only be called in debugging situations.
121: -- this is biv specific and should remain in this package.
122: function dump_parameters
123: ( p_param in bis_pmv_page_parameter_tbl )
124: return varchar2;
125:
126: -- dump_binds function returns as a comment block the
127: -- contents of the bind variables provided by PMV and product team

Line 141: , p_param in bis_pmv_page_parameter_tbl

137: -- aging and order by aging.
138: -- this is biv specific and should remain in this package.
139: procedure override_order_by
140: ( p_view_by in varchar2
141: , p_param in bis_pmv_page_parameter_tbl
142: , p_stmt in out nocopy varchar2
143: );
144:
145: -- get_balance_fact function returns the MV name to check the

Line 195: ( p_param in bis_pmv_page_parameter_tbl

191:
192: -- bind_low_high procedure returns the low and high values for bucket
193: -- as bind variable values
194: procedure bind_low_high
195: ( p_param in bis_pmv_page_parameter_tbl
196: , p_short_name in varchar2
197: , p_low in varchar2
198: , p_high in varchar2
199: , p_custom_output in out nocopy bis_query_attributes_tbl

Line 205: ( p_param in bis_pmv_page_parameter_tbl

201:
202: -- process_parameters procedure is a wrapper to the other
203: -- process_parameters specifically for detail report queries
204: procedure process_parameters
205: ( p_param in bis_pmv_page_parameter_tbl
206: , p_report_type in varchar2 -- 'BACKLOG_DETAIL', 'CLOSED_DETAIL'
207: , x_where_clause out nocopy varchar2
208: , x_xtd out nocopy varchar2
209: , x_mv out nocopy varchar2

Line 218: ( p_param in bis_pmv_page_parameter_tbl )

214: );
215:
216: -- get_order_by function returns the order by parameter
217: function get_order_by
218: ( p_param in bis_pmv_page_parameter_tbl )
219: return varchar2;
220:
221: -- bind_age_dates procedure returns the current and prior date
222: -- values as bind variables for backlog aging

Line 224: ( p_param in bis_pmv_page_parameter_tbl

220:
221: -- bind_age_dates procedure returns the current and prior date
222: -- values as bind variables for backlog aging
223: procedure bind_age_dates
224: ( p_param in bis_pmv_page_parameter_tbl
225: , p_current_name in varchar2
226: , p_prior_name in varchar2
227: , p_custom_output in out nocopy bis_query_attributes_tbl
228: );