APPS.BIV_DBI_TMPL_UTIL dependencies on POA_DBI_UTIL_PKG

Line 20: -- for period_type as poa_dbi_util_pkg.get_parameter_values

16: g_BACKLOG_TYPE varchar2(50) := 'BACKLOG_TYPE+BACKLOG_TYPE';
17: g_RES_STATUS varchar2(50) := 'BIV_RES_STATUS+RES_STATUS';
18:
19: -- get_period_type function returns the value of the parameter value
20: -- for period_type as poa_dbi_util_pkg.get_parameter_values
21: -- does not understand rolling periods yet.
22: --
23: -- when poa_dbi_util_pkg.get_parameter_values is updated to handle
24: -- rolling periods this function will not be needed.

Line 23: -- when poa_dbi_util_pkg.get_parameter_values is updated to handle

19: -- get_period_type function returns the value of the parameter value
20: -- for period_type as poa_dbi_util_pkg.get_parameter_values
21: -- does not understand rolling periods yet.
22: --
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 )

Line 41: , x_join_tbl out nocopy poa_DBI_UTIL_PKG.poa_dbi_join_tbl

37: , x_comparison_type out nocopy varchar2
38: , x_xtd out nocopy varchar2
39: , x_where_clause out nocopy varchar2
40: , x_mv out nocopy varchar2
41: , x_join_tbl out nocopy poa_DBI_UTIL_PKG.poa_dbi_join_tbl
42: , x_as_of_date out nocopy date
43: );
44:
45: -- this is biv specific and should remain in this package.

Line 62: -- for backlog type as poa_dbi_util_pkg.get_parameter_values

58: , p_column_alias in varchar2 default 'BIV_ATTRIBUTE4' )
59: return varchar2;
60:
61: -- get_backlog_type function returns the value of the parameter value
62: -- for backlog type as poa_dbi_util_pkg.get_parameter_values
63: -- only returns whether or not it is set and we don't want
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

Line 91: , p_col_tbl in out nocopy poa_DBI_UTIL_PKG.poa_dbi_col_tbl

87: -- the inner query for the buckets based on the bucket short name.
88: -- this is biv specific and should remain in this package.
89: procedure add_bucket_inner_query
90: ( p_short_name in varchar2
91: , p_col_tbl in out nocopy poa_DBI_UTIL_PKG.poa_dbi_col_tbl
92: , p_col_name in varchar2
93: , p_alias_name in varchar2
94: , p_grand_total in varchar2
95: , p_prior_code in varchar2

Line 100: -- this is a wrapper to poa_dbi_util_pkg.change_clause.

96: , p_to_date_type in varchar2
97: , x_bucket_rec out nocopy bis_bucket_pub.bis_bucket_rec_type
98: );
99:
100: -- this is a wrapper to poa_dbi_util_pkg.change_clause.
101: -- this is biv specific and should remain in this package.
102: function change_column
103: ( p_current_column in varchar2
104: , p_prior_column in varchar2

Line 109: -- this is a wrapper to poa_dbi_util_pkg.rate_clause.

105: , p_column_alias in varchar2
106: , p_percent in varchar2 default 'Y'
107: ) return varchar2;
108:
109: -- this is a wrapper to poa_dbi_util_pkg.rate_clause.
110: -- this is biv specific and should remain in this package.
111: function rate_column
112: ( p_numerator in varchar2
113: , p_denominator in varchar2

Line 212: , x_join_tbl out nocopy poa_DBI_UTIL_PKG.poa_dbi_join_tbl

208: , x_xtd out nocopy varchar2
209: , x_mv out nocopy varchar2
210: , x_join_from out nocopy varchar2
211: , x_join_where out nocopy varchar2
212: , x_join_tbl out nocopy poa_DBI_UTIL_PKG.poa_dbi_join_tbl
213: , x_as_of_date out nocopy date
214: );
215:
216: -- get_order_by function returns the order by parameter