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.

[Home] [Help]

APPS.BIX_PMV_AI_AURTR_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: 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: 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: 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: 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: 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: 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: 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 77: poa_dbi_util_pkg.add_column(bix_col_tab,'agent_talk_time_nac','talk' ,'N',2,'XTD');

73: ,p_xtd => l_xtd
74: ,p_view_by_select => l_view_by_select
75: ,p_view_by => l_dummy);
76:
77: poa_dbi_util_pkg.add_column(bix_col_tab,'agent_talk_time_nac','talk' ,'N',2,'XTD');
78: poa_dbi_util_pkg.add_column(bix_col_tab,'agent_wrap_time_nac','wrap' ,'N',2,'XTD');
79: poa_dbi_util_pkg.add_column(bix_col_tab,'0' ,'login','N',2,'XTD');
80: poa_dbi_util_pkg.add_column(bix_col_tab,'0' ,'work' ,'N',2,'XTD');
81: poa_dbi_util_pkg.add_column(bix_col_tab,'0' ,'avail','N',2,'XTD');

Line 78: poa_dbi_util_pkg.add_column(bix_col_tab,'agent_wrap_time_nac','wrap' ,'N',2,'XTD');

74: ,p_view_by_select => l_view_by_select
75: ,p_view_by => l_dummy);
76:
77: poa_dbi_util_pkg.add_column(bix_col_tab,'agent_talk_time_nac','talk' ,'N',2,'XTD');
78: poa_dbi_util_pkg.add_column(bix_col_tab,'agent_wrap_time_nac','wrap' ,'N',2,'XTD');
79: poa_dbi_util_pkg.add_column(bix_col_tab,'0' ,'login','N',2,'XTD');
80: poa_dbi_util_pkg.add_column(bix_col_tab,'0' ,'work' ,'N',2,'XTD');
81: poa_dbi_util_pkg.add_column(bix_col_tab,'0' ,'avail','N',2,'XTD');
82: poa_dbi_util_pkg.add_column(bix_col_tab,'0' ,'idle' ,'N',2,'XTD');

Line 79: poa_dbi_util_pkg.add_column(bix_col_tab,'0' ,'login','N',2,'XTD');

75: ,p_view_by => l_dummy);
76:
77: poa_dbi_util_pkg.add_column(bix_col_tab,'agent_talk_time_nac','talk' ,'N',2,'XTD');
78: poa_dbi_util_pkg.add_column(bix_col_tab,'agent_wrap_time_nac','wrap' ,'N',2,'XTD');
79: poa_dbi_util_pkg.add_column(bix_col_tab,'0' ,'login','N',2,'XTD');
80: poa_dbi_util_pkg.add_column(bix_col_tab,'0' ,'work' ,'N',2,'XTD');
81: poa_dbi_util_pkg.add_column(bix_col_tab,'0' ,'avail','N',2,'XTD');
82: poa_dbi_util_pkg.add_column(bix_col_tab,'0' ,'idle' ,'N',2,'XTD');
83:

Line 80: poa_dbi_util_pkg.add_column(bix_col_tab,'0' ,'work' ,'N',2,'XTD');

76:
77: poa_dbi_util_pkg.add_column(bix_col_tab,'agent_talk_time_nac','talk' ,'N',2,'XTD');
78: poa_dbi_util_pkg.add_column(bix_col_tab,'agent_wrap_time_nac','wrap' ,'N',2,'XTD');
79: poa_dbi_util_pkg.add_column(bix_col_tab,'0' ,'login','N',2,'XTD');
80: poa_dbi_util_pkg.add_column(bix_col_tab,'0' ,'work' ,'N',2,'XTD');
81: poa_dbi_util_pkg.add_column(bix_col_tab,'0' ,'avail','N',2,'XTD');
82: poa_dbi_util_pkg.add_column(bix_col_tab,'0' ,'idle' ,'N',2,'XTD');
83:
84:

Line 81: poa_dbi_util_pkg.add_column(bix_col_tab,'0' ,'avail','N',2,'XTD');

77: poa_dbi_util_pkg.add_column(bix_col_tab,'agent_talk_time_nac','talk' ,'N',2,'XTD');
78: poa_dbi_util_pkg.add_column(bix_col_tab,'agent_wrap_time_nac','wrap' ,'N',2,'XTD');
79: poa_dbi_util_pkg.add_column(bix_col_tab,'0' ,'login','N',2,'XTD');
80: poa_dbi_util_pkg.add_column(bix_col_tab,'0' ,'work' ,'N',2,'XTD');
81: poa_dbi_util_pkg.add_column(bix_col_tab,'0' ,'avail','N',2,'XTD');
82: poa_dbi_util_pkg.add_column(bix_col_tab,'0' ,'idle' ,'N',2,'XTD');
83:
84:
85:

Line 82: poa_dbi_util_pkg.add_column(bix_col_tab,'0' ,'idle' ,'N',2,'XTD');

78: poa_dbi_util_pkg.add_column(bix_col_tab,'agent_wrap_time_nac','wrap' ,'N',2,'XTD');
79: poa_dbi_util_pkg.add_column(bix_col_tab,'0' ,'login','N',2,'XTD');
80: poa_dbi_util_pkg.add_column(bix_col_tab,'0' ,'work' ,'N',2,'XTD');
81: poa_dbi_util_pkg.add_column(bix_col_tab,'0' ,'avail','N',2,'XTD');
82: poa_dbi_util_pkg.add_column(bix_col_tab,'0' ,'idle' ,'N',2,'XTD');
83:
84:
85:
86: poa_dbi_util_pkg.add_column(p_cols,'0' ,'talk' ,'N',2,'XTD');

Line 86: poa_dbi_util_pkg.add_column(p_cols,'0' ,'talk' ,'N',2,'XTD');

82: poa_dbi_util_pkg.add_column(bix_col_tab,'0' ,'idle' ,'N',2,'XTD');
83:
84:
85:
86: poa_dbi_util_pkg.add_column(p_cols,'0' ,'talk' ,'N',2,'XTD');
87: poa_dbi_util_pkg.add_column(p_cols,'0' ,'wrap' ,'N',2,'XTD');
88: poa_dbi_util_pkg.add_column(p_cols,'login_time' ,'login','N',2,'XTD');
89: poa_dbi_util_pkg.add_column(p_cols,'work_time' ,'work ','N',2,'XTD');
90: poa_dbi_util_pkg.add_column(p_cols,'available_time','avail','N',2,'XTD');

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

83:
84:
85:
86: poa_dbi_util_pkg.add_column(p_cols,'0' ,'talk' ,'N',2,'XTD');
87: poa_dbi_util_pkg.add_column(p_cols,'0' ,'wrap' ,'N',2,'XTD');
88: poa_dbi_util_pkg.add_column(p_cols,'login_time' ,'login','N',2,'XTD');
89: poa_dbi_util_pkg.add_column(p_cols,'work_time' ,'work ','N',2,'XTD');
90: poa_dbi_util_pkg.add_column(p_cols,'available_time','avail','N',2,'XTD');
91: poa_dbi_util_pkg.add_column(p_cols,'idle_time' ,'idle ','N',2,'XTD');

Line 88: poa_dbi_util_pkg.add_column(p_cols,'login_time' ,'login','N',2,'XTD');

84:
85:
86: poa_dbi_util_pkg.add_column(p_cols,'0' ,'talk' ,'N',2,'XTD');
87: poa_dbi_util_pkg.add_column(p_cols,'0' ,'wrap' ,'N',2,'XTD');
88: poa_dbi_util_pkg.add_column(p_cols,'login_time' ,'login','N',2,'XTD');
89: poa_dbi_util_pkg.add_column(p_cols,'work_time' ,'work ','N',2,'XTD');
90: poa_dbi_util_pkg.add_column(p_cols,'available_time','avail','N',2,'XTD');
91: poa_dbi_util_pkg.add_column(p_cols,'idle_time' ,'idle ','N',2,'XTD');
92:

Line 89: poa_dbi_util_pkg.add_column(p_cols,'work_time' ,'work ','N',2,'XTD');

85:
86: poa_dbi_util_pkg.add_column(p_cols,'0' ,'talk' ,'N',2,'XTD');
87: poa_dbi_util_pkg.add_column(p_cols,'0' ,'wrap' ,'N',2,'XTD');
88: poa_dbi_util_pkg.add_column(p_cols,'login_time' ,'login','N',2,'XTD');
89: poa_dbi_util_pkg.add_column(p_cols,'work_time' ,'work ','N',2,'XTD');
90: poa_dbi_util_pkg.add_column(p_cols,'available_time','avail','N',2,'XTD');
91: poa_dbi_util_pkg.add_column(p_cols,'idle_time' ,'idle ','N',2,'XTD');
92:
93:

Line 90: poa_dbi_util_pkg.add_column(p_cols,'available_time','avail','N',2,'XTD');

86: poa_dbi_util_pkg.add_column(p_cols,'0' ,'talk' ,'N',2,'XTD');
87: poa_dbi_util_pkg.add_column(p_cols,'0' ,'wrap' ,'N',2,'XTD');
88: poa_dbi_util_pkg.add_column(p_cols,'login_time' ,'login','N',2,'XTD');
89: poa_dbi_util_pkg.add_column(p_cols,'work_time' ,'work ','N',2,'XTD');
90: poa_dbi_util_pkg.add_column(p_cols,'available_time','avail','N',2,'XTD');
91: poa_dbi_util_pkg.add_column(p_cols,'idle_time' ,'idle ','N',2,'XTD');
92:
93:
94: l_union_all_text := 'UNION ALL '||bix_pmv_dbi_utl_pkg.get_continued_measures

Line 91: poa_dbi_util_pkg.add_column(p_cols,'idle_time' ,'idle ','N',2,'XTD');

87: poa_dbi_util_pkg.add_column(p_cols,'0' ,'wrap' ,'N',2,'XTD');
88: poa_dbi_util_pkg.add_column(p_cols,'login_time' ,'login','N',2,'XTD');
89: poa_dbi_util_pkg.add_column(p_cols,'work_time' ,'work ','N',2,'XTD');
90: poa_dbi_util_pkg.add_column(p_cols,'available_time','avail','N',2,'XTD');
91: poa_dbi_util_pkg.add_column(p_cols,'idle_time' ,'idle ','N',2,'XTD');
92:
93:
94: l_union_all_text := 'UNION ALL '||bix_pmv_dbi_utl_pkg.get_continued_measures
95: (p_bix_col_tab => p_cols,

Line 144: poa_dbi_util_pkg.get_custom_trend_binds (p_xtd => l_xtd

140:
141: p_custom_sql := l_sqltext;
142:
143:
144: poa_dbi_util_pkg.get_custom_trend_binds (p_xtd => l_xtd
145: ,p_comparison_type => l_comp_type
146: ,x_custom_output => p_custom_output);
147:
148: bix_pmv_dbi_utl_pkg.get_bind_vars (x_custom_output => p_custom_output