APPS.BIX_PMV_AI_ATRTR_PRTLT_PKG dependencies on BIX_PMV_DBI_UTL_PKG

Line 61: bix_pmv_dbi_utl_pkg.process_parameters(

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

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

89: poa_dbi_util_pkg.add_column(p_cols,'0','hand','N',2,'XTD');
90: poa_dbi_util_pkg.add_column(p_cols,'call_cont_calls_offered_na','offrd','N',2,'XTD');
91:
92:
93: l_union_all_text := 'UNION ALL '||bix_pmv_dbi_utl_pkg.get_continued_measures
94: (p_bix_col_tab => p_cols,
95: p_where_clause => l_where_clause,
96: p_xtd => l_xtd,
97: p_comparison_type => l_comp_type,

Line 108: FROM '||bix_pmv_dbi_utl_pkg.trend_sql

104: SUM(curr_aban)*100/NULLIF(SUM(curr_offrd),0) BIX_PMV_AI_ABANRATE ,
105: -- SUM(p_tran)*100/NULLIF(SUM(p_hand) ,0) BIX_PMV_AI_PREVTRANRATE,
106: SUM(curr_tran)*100/NULLIF(SUM(curr_hand) ,0) BIX_PMV_AI_TRANRATE
107: FROM '||'(SELECT iset.*,cal.start_date st_date,cal.name
108: FROM '||bix_pmv_dbi_utl_pkg.trend_sql
109: (p_xtd => l_xtd,
110: p_comparison_type => l_comp_type,
111: p_fact_name => l_mv,
112: p_where_clause => l_where_clause,

Line 133: bix_pmv_dbi_utl_pkg.get_bind_vars (x_custom_output => p_custom_output

129: poa_dbi_util_pkg.get_custom_trend_binds (p_xtd => l_xtd
130: ,p_comparison_type => l_comp_type
131: ,x_custom_output => p_custom_output);
132:
133: bix_pmv_dbi_utl_pkg.get_bind_vars (x_custom_output => p_custom_output
134: ,p_func_area => NULL);
135:
136: EXCEPTION
137: WHEN OTHERS THEN