eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BIX_PMV_AI_ATRTR_PRTLT_PKG dependencies on POA_DBI_UTIL_PKG

Line 10: bix_col_tab 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: bix_col_tab poa_dbi_util_pkg.poa_dbi_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl() ;
11: p_cols poa_dbi_util_pkg.poa_dbi_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
12: bix_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: p_cols poa_dbi_util_pkg.poa_dbi_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();

7: )
8: AS
9:
10: bix_col_tab poa_dbi_util_pkg.poa_dbi_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl() ;
11: p_cols poa_dbi_util_pkg.poa_dbi_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
12: bix_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: bix_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: bix_col_tab poa_dbi_util_pkg.poa_dbi_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl() ;
11: p_cols poa_dbi_util_pkg.poa_dbi_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
12: bix_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: bix_col_tab poa_dbi_util_pkg.poa_dbi_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl() ;
11: p_cols poa_dbi_util_pkg.poa_dbi_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
12: bix_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 79: poa_dbi_util_pkg.add_column(bix_col_tab,'call_calls_abandoned', 'aban' ,'N',2, 'XTD');

75:
76: l_where_clause := l_where_clause ||' AND fact.media_item_type IN (''TELE_INB'', ''TELE_DIRECT'') ';
77:
78:
79: poa_dbi_util_pkg.add_column(bix_col_tab,'call_calls_abandoned', 'aban' ,'N',2, 'XTD');
80: poa_dbi_util_pkg.add_column(bix_col_tab,'call_calls_transferred', 'tran' ,'N',2, 'XTD');
81: poa_dbi_util_pkg.add_column(bix_col_tab,'call_calls_handled_total','hand' ,'N',2, 'XTD');
82: poa_dbi_util_pkg.add_column(bix_col_tab,'call_calls_offered_total','offrd' ,'N',2,'XTD');
83:

Line 80: poa_dbi_util_pkg.add_column(bix_col_tab,'call_calls_transferred', 'tran' ,'N',2, 'XTD');

76: l_where_clause := l_where_clause ||' AND fact.media_item_type IN (''TELE_INB'', ''TELE_DIRECT'') ';
77:
78:
79: poa_dbi_util_pkg.add_column(bix_col_tab,'call_calls_abandoned', 'aban' ,'N',2, 'XTD');
80: poa_dbi_util_pkg.add_column(bix_col_tab,'call_calls_transferred', 'tran' ,'N',2, 'XTD');
81: poa_dbi_util_pkg.add_column(bix_col_tab,'call_calls_handled_total','hand' ,'N',2, 'XTD');
82: poa_dbi_util_pkg.add_column(bix_col_tab,'call_calls_offered_total','offrd' ,'N',2,'XTD');
83:
84:

Line 81: poa_dbi_util_pkg.add_column(bix_col_tab,'call_calls_handled_total','hand' ,'N',2, 'XTD');

77:
78:
79: poa_dbi_util_pkg.add_column(bix_col_tab,'call_calls_abandoned', 'aban' ,'N',2, 'XTD');
80: poa_dbi_util_pkg.add_column(bix_col_tab,'call_calls_transferred', 'tran' ,'N',2, 'XTD');
81: poa_dbi_util_pkg.add_column(bix_col_tab,'call_calls_handled_total','hand' ,'N',2, 'XTD');
82: poa_dbi_util_pkg.add_column(bix_col_tab,'call_calls_offered_total','offrd' ,'N',2,'XTD');
83:
84:
85: --Columns, for which sum is not to be taken, pass them as 0.

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

78:
79: poa_dbi_util_pkg.add_column(bix_col_tab,'call_calls_abandoned', 'aban' ,'N',2, 'XTD');
80: poa_dbi_util_pkg.add_column(bix_col_tab,'call_calls_transferred', 'tran' ,'N',2, 'XTD');
81: poa_dbi_util_pkg.add_column(bix_col_tab,'call_calls_handled_total','hand' ,'N',2, 'XTD');
82: poa_dbi_util_pkg.add_column(bix_col_tab,'call_calls_offered_total','offrd' ,'N',2,'XTD');
83:
84:
85: --Columns, for which sum is not to be taken, pass them as 0.
86:

Line 87: poa_dbi_util_pkg.add_column(p_cols,'0','aban','N',2,'XTD');

83:
84:
85: --Columns, for which sum is not to be taken, pass them as 0.
86:
87: poa_dbi_util_pkg.add_column(p_cols,'0','aban','N',2,'XTD');
88: poa_dbi_util_pkg.add_column(p_cols,'0','tran','N',2,'XTD');
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:

Line 88: poa_dbi_util_pkg.add_column(p_cols,'0','tran','N',2,'XTD');

84:
85: --Columns, for which sum is not to be taken, pass them as 0.
86:
87: poa_dbi_util_pkg.add_column(p_cols,'0','aban','N',2,'XTD');
88: poa_dbi_util_pkg.add_column(p_cols,'0','tran','N',2,'XTD');
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:

Line 89: poa_dbi_util_pkg.add_column(p_cols,'0','hand','N',2,'XTD');

85: --Columns, for which sum is not to be taken, pass them as 0.
86:
87: poa_dbi_util_pkg.add_column(p_cols,'0','aban','N',2,'XTD');
88: poa_dbi_util_pkg.add_column(p_cols,'0','tran','N',2,'XTD');
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

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

86:
87: poa_dbi_util_pkg.add_column(p_cols,'0','aban','N',2,'XTD');
88: poa_dbi_util_pkg.add_column(p_cols,'0','tran','N',2,'XTD');
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,

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