APPS.BIX_PMV_AI_ATWTR_PRTLT_PKG dependencies on BIX_PMV_DBI_UTL_PKG

Line 59: bix_pmv_dbi_utl_pkg.process_parameters(

55: --Initialize p_custom_output
56: --
57: p_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
58:
59: bix_pmv_dbi_utl_pkg.process_parameters(
60: p_param => p_page_parameter_tbl
61: ,p_trend => 'Y'
62: ,p_func_area => 'ITMAT'
63: ,p_version => '6.0'

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

78: poa_dbi_util_pkg.add_column(p_cols,'0' ,'talk','N',2,'XTD');
79: poa_dbi_util_pkg.add_column(p_cols,'0' ,'wrap','N',2,'XTD');
80: poa_dbi_util_pkg.add_column(p_cols,'call_cont_calls_handled_tot_na' ,'hand','N',2,'XTD');
81:
82: l_union_all_text := 'UNION ALL '||bix_pmv_dbi_utl_pkg.get_continued_measures
83: (p_bix_col_tab => p_cols,
84: p_where_clause => l_where_clause,
85: p_xtd => l_xtd,
86: p_comparison_type => l_comp_type,

Line 96: FROM '||bix_pmv_dbi_utl_pkg.trend_sql

92: SUM(curr_talk)/DECODE(SUM(curr_hand),0,null,SUM(curr_hand)) BIX_PMV_AI_AVGTALK ,
93: -- SUM(p_wrap)/DECODE(SUM(p_hand),0,null,SUM(p_hand)) BIX_PMV_AI_PREVAVGWRAP,
94: SUM(curr_wrap)/DECODE(SUM(curr_hand),0,null,SUM(curr_hand)) BIX_PMV_AI_AVGWRAP
95: FROM '||'(SELECT iset.*,cal.start_date st_date,cal.name
96: FROM '||bix_pmv_dbi_utl_pkg.trend_sql
97: (p_xtd => l_xtd,
98: p_comparison_type => l_comp_type,
99: p_fact_name => l_mv,
100: p_where_clause => l_where_clause,

Line 118: bix_pmv_dbi_utl_pkg.get_bind_vars (x_custom_output => p_custom_output

114: poa_dbi_util_pkg.get_custom_trend_binds (p_xtd => l_xtd,
115: p_comparison_type => l_comp_type,
116: x_custom_output => p_custom_output);
117:
118: bix_pmv_dbi_utl_pkg.get_bind_vars (x_custom_output => p_custom_output
119: ,p_func_area => NULL);
120:
121: EXCEPTION
122: WHEN OTHERS THEN