APPS.BIX_PMV_AI_SLTR_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 85: l_union_all_text := 'UNION ALL '||bix_pmv_dbi_utl_pkg.get_continued_measures

81: poa_dbi_util_pkg.add_column(p_cols,'call_cont_calls_offered_na' ,'offrd','N',2,'XTD');
82: poa_dbi_util_pkg.add_column(p_cols,'0' ,'ansgoal','N',2,'XTD');
83:
84:
85: l_union_all_text := 'UNION ALL '||bix_pmv_dbi_utl_pkg.get_continued_measures
86: (p_bix_col_tab => p_cols,
87: p_where_clause => l_where_clause,
88: p_xtd => l_xtd,
89: p_comparison_type => l_comp_type,

Line 108: bix_pmv_dbi_utl_pkg.trend_sql

104: SUM(curr_ansgoal)*100/DECODE(SUM(curr_offrd),0,null,SUM(curr_offrd)) BIX_PMV_AI_SL,
105: ' || l_goal ||' BIX_PMV_AI_SLGOAL
106: FROM '||'(SELECT iset.*,cal.start_date st_date,cal.name
107: FROM '||
108: 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