APPS.BIX_PMV_AI_SATR_PRTLT_PKG dependencies on BIX_PMV_DBI_UTL_PKG

Line 57: bix_pmv_dbi_utl_pkg.process_parameters(

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

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

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

Line 95: FROM '||bix_pmv_dbi_utl_pkg.trend_sql

91: l_sqltext := 'SELECT name VIEWBY,
92: SUM(p_anstime)/NULLIF(SUM(p_hand),0) BIX_PMV_AI_PREVSPANS,
93: SUM(curr_anstime)/NULLIF(SUM(curr_hand),0) BIX_PMV_AI_SPANS
94: FROM '||'(SELECT iset.*,cal.start_date st_date,cal.name
95: FROM '||bix_pmv_dbi_utl_pkg.trend_sql
96: (p_xtd => l_xtd,
97: p_comparison_type => l_comp_type,
98: p_fact_name => l_mv,
99: p_where_clause => l_where_clause,

Line 121: bix_pmv_dbi_utl_pkg.get_bind_vars (x_custom_output => p_custom_output

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