APPS.BIX_PMV_AI_SLTR_PRTLT_PKG dependencies on POA_DBI_UTIL_PKG

Line 10: p_cols poa_dbi_util_pkg.poa_dbi_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();

6: p_custom_output OUT NOCOPY bis_query_attributes_TBL
7: )
8: AS
9:
10: p_cols poa_dbi_util_pkg.poa_dbi_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
11: bix_col_tab poa_dbi_util_pkg.poa_dbi_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl() ;
12: poa_in_join_tab poa_dbi_util_pkg.poa_dbi_in_join_tbl := poa_dbi_util_pkg.poa_dbi_IN_join_tbl();
13:
14: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

Line 11: bix_col_tab poa_dbi_util_pkg.poa_dbi_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl() ;

7: )
8: AS
9:
10: p_cols poa_dbi_util_pkg.poa_dbi_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
11: bix_col_tab poa_dbi_util_pkg.poa_dbi_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl() ;
12: poa_in_join_tab poa_dbi_util_pkg.poa_dbi_in_join_tbl := poa_dbi_util_pkg.poa_dbi_IN_join_tbl();
13:
14: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
15:

Line 12: poa_in_join_tab poa_dbi_util_pkg.poa_dbi_in_join_tbl := poa_dbi_util_pkg.poa_dbi_IN_join_tbl();

8: AS
9:
10: p_cols poa_dbi_util_pkg.poa_dbi_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
11: bix_col_tab poa_dbi_util_pkg.poa_dbi_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl() ;
12: poa_in_join_tab poa_dbi_util_pkg.poa_dbi_in_join_tbl := poa_dbi_util_pkg.poa_dbi_IN_join_tbl();
13:
14: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
15:
16: l_where_clause VARCHAR2(32000);

Line 14: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

10: p_cols poa_dbi_util_pkg.poa_dbi_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
11: bix_col_tab poa_dbi_util_pkg.poa_dbi_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl() ;
12: poa_in_join_tab poa_dbi_util_pkg.poa_dbi_in_join_tbl := poa_dbi_util_pkg.poa_dbi_IN_join_tbl();
13:
14: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
15:
16: l_where_clause VARCHAR2(32000);
17: l_mv VARCHAR2(32000);
18: l_dummy VARCHAR2(32000);

Line 28: l_dim_map poa_dbi_util_pkg.poa_dbi_dim_map;

24: l_period_type VARCHAR2(2000);
25: l_record_type_id NUMBER;
26: l_comp_type VARCHAR2(50);
27: l_sql_errm VARCHAR2(32000);
28: l_dim_map poa_dbi_util_pkg.poa_dbi_dim_map;
29: l_previous_report_start_date DATE;
30: l_current_report_start_date DATE;
31: l_previous_as_of_date DATE;
32: l_period_type_id NUMBER;

Line 75: poa_dbi_util_pkg.add_column(bix_col_tab,'call_calls_offered_total','offrd' ,'N',2,'XTD');

71: ,p_view_by => l_dummy);
72:
73:
74:
75: poa_dbi_util_pkg.add_column(bix_col_tab,'call_calls_offered_total','offrd' ,'N',2,'XTD');
76: poa_dbi_util_pkg.add_column(bix_col_tab,'agent_calls_answered_by_goal','ansgoal' ,'N',2,'XTD');
77:
78:
79: --Columns, for which sum is not to be taken, pass them as 0.

Line 76: poa_dbi_util_pkg.add_column(bix_col_tab,'agent_calls_answered_by_goal','ansgoal' ,'N',2,'XTD');

72:
73:
74:
75: poa_dbi_util_pkg.add_column(bix_col_tab,'call_calls_offered_total','offrd' ,'N',2,'XTD');
76: poa_dbi_util_pkg.add_column(bix_col_tab,'agent_calls_answered_by_goal','ansgoal' ,'N',2,'XTD');
77:
78:
79: --Columns, for which sum is not to be taken, pass them as 0.
80:

Line 81: poa_dbi_util_pkg.add_column(p_cols,'call_cont_calls_offered_na' ,'offrd','N',2,'XTD');

77:
78:
79: --Columns, for which sum is not to be taken, pass them as 0.
80:
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

Line 82: poa_dbi_util_pkg.add_column(p_cols,'0' ,'ansgoal','N',2,'XTD');

78:
79: --Columns, for which sum is not to be taken, pass them as 0.
80:
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,

Line 129: poa_dbi_util_pkg.get_custom_trend_binds (p_xtd => l_xtd

125:
126: p_custom_sql := l_sqltext;
127:
128:
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