APPS.BIX_PMV_AI_AURTR_PRTLT_PKG dependencies on BIX_PMV_DBI_UTL_PKG

Line 63: bix_pmv_dbi_utl_pkg.process_parameters(

59: --
60: p_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
61:
62: --call the process parameters whith p_mv_set = 'SES' ,ie. for agent session
63: bix_pmv_dbi_utl_pkg.process_parameters(
64: p_param => p_page_parameter_tbl
65: ,p_trend => 'Y'
66: ,p_func_area => 'ITMAT'
67: ,p_version => '6.0'

Line 94: l_union_all_text := 'UNION ALL '||bix_pmv_dbi_utl_pkg.get_continued_measures

90: poa_dbi_util_pkg.add_column(p_cols,'available_time','avail','N',2,'XTD');
91: poa_dbi_util_pkg.add_column(p_cols,'idle_time' ,'idle ','N',2,'XTD');
92:
93:
94: l_union_all_text := 'UNION ALL '||bix_pmv_dbi_utl_pkg.get_continued_measures
95: (p_bix_col_tab => p_cols,
96: p_where_clause => l_where_clause,
97: p_xtd => l_xtd,
98: p_comparison_type => l_comp_type,

Line 101: bix_pmv_dbi_utl_pkg.process_parameters(

97: p_xtd => l_xtd,
98: p_comparison_type => l_comp_type,
99: p_mv_set => 'SES');
100:
101: bix_pmv_dbi_utl_pkg.process_parameters(
102: p_param => p_page_parameter_tbl
103: ,p_trend => 'Y'
104: ,p_func_area => 'ITMAT'
105: ,p_version => '6.0'

Line 123: FROM '||bix_pmv_dbi_utl_pkg.trend_sql

119: /* sum(nvl(p_login,0)-nvl(p_idle,0))*100/decode(sum(p_login),0,null,sum(p_login)) bix_pmv_ai_prevavailrate,*/
120: sum(nvl(curr_login,0)-nvl(curr_idle,0)-nvl(curr_avail,0))*100/decode(sum(curr_login),0,null,sum(curr_login)) bix_pmv_ai_utilrate/*,
121: sum(nvl(p_login,0)-nvl(p_idle,0)-nvl(p_avail,0))*100/decode(sum(p_login),0,null,sum(p_login)) bix_pmv_ai_prevutilrate*/
122: FROM '||'(SELECT iset.*,cal.start_date st_date,cal.name
123: FROM '||bix_pmv_dbi_utl_pkg.trend_sql
124: (p_xtd => l_xtd,
125: p_comparison_type => l_comp_type,
126: p_fact_name => l_mv,
127: p_where_clause => l_where_clause,

Line 148: bix_pmv_dbi_utl_pkg.get_bind_vars (x_custom_output => p_custom_output

144: poa_dbi_util_pkg.get_custom_trend_binds (p_xtd => l_xtd
145: ,p_comparison_type => l_comp_type
146: ,x_custom_output => p_custom_output);
147:
148: bix_pmv_dbi_utl_pkg.get_bind_vars (x_custom_output => p_custom_output
149: ,p_func_area => NULL);
150:
151:
152: EXCEPTION