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_TELDTL_RPT_PKG dependencies on BIX_PMV_DBI_UTL_PKG

Line 47: ||bix_pmv_dbi_utl_pkg.get_simple_measure(

43:
44: l_measure_txt:=
45: l_view_by_select
46: ||','||l_goal||' BIX_PMV_AI_SLGOAL,'
47: ||bix_pmv_dbi_utl_pkg.get_simple_measure(
48: p_curr=>'to_number(NVL(c_g,0))'
49: ,p_prev=>'NVL(p_g,0)'
50: ,p_measurecol=>'BIX_PMV_AI_INCALLHAND_CP'
51: ,p_totalcol=>'BIX_PMV_TOTAL9'

Line 56: ||',' || bix_pmv_dbi_utl_pkg.get_simple_measure(

52: ,p_changecol=>'BIX_PMV_AI_INCALLHAND_CG'
53: ,p_changetotalcol=>'BIX_PMV_TOTAL10'
54: )
55: /* Abandoned Calls */
56: ||',' || bix_pmv_dbi_utl_pkg.get_simple_measure(
57: p_curr=>'NVL(c_e,0)'
58: ,p_prev=>'NVL(p_e,0)'
59: ,p_measurecol=>'BIX_ATTRIBUTE_7'
60: ,p_totalcol=>'BIX_PMV_TOTAL21'

Line 65: ||bix_pmv_dbi_utl_pkg.get_simple_measure(

61: ,p_changecol=>'BIX_ATTRIBUTE_9'
62: ,p_changetotalcol=>'BIX_PMV_TOTAL22'
63: )
64: ||','
65: ||bix_pmv_dbi_utl_pkg.get_simple_measure(
66: p_curr=>'NVL(c_l,0)'
67: ,p_prev=>'NVL(p_l,0)'
68: ,p_measurecol=>'BIX_PMV_AI_SRCR_CP'
69: ,p_totalcol=>'BIX_PMV_TOTAL17'

Line 74: ||bix_pmv_dbi_utl_pkg.get_simple_measure(

70: ,p_changecol=>'BIX_PMV_AI_SRCR_CG'
71: ,p_changetotalcol=>'BIX_PMV_TOTAL18'
72: )
73: ||','
74: ||bix_pmv_dbi_utl_pkg.get_simple_measure(
75: p_curr=>'NVL(c_m,0)'
76: ,p_prev=>'NVL(p_m,0)'
77: ,p_measurecol=>'BIX_PMV_AI_LECR_CP'
78: ,p_totalcol=>'BIX_PMV_TOTAL19'

Line 83: ||bix_pmv_dbi_utl_pkg.get_simple_measure(

79: ,p_changecol=>'BIX_PMV_AI_LECR_CG'
80: ,p_changetotalcol=>'BIX_PMV_TOTAL20'
81: )
82: ||','
83: ||bix_pmv_dbi_utl_pkg.get_simple_measure(
84: p_curr=>'NVL(c_n,0)'
85: ,p_prev=>'NVL(p_n,0)'
86: ,p_measurecol=>'BIX_PMV_AI_OPCR_CP'
87: ,p_totalcol=>'BIX_PMV_TOTAL23'

Line 92: ||bix_pmv_dbi_utl_pkg.get_simple_measure(

88: ,p_changecol=>'BIX_PMV_AI_OPCR_CG'
89: ,p_changetotalcol=>'BIX_PMV_TOTAL24'
90: )
91: ||','
92: ||bix_pmv_dbi_utl_pkg.get_simple_measure(
93: p_curr=>'NVL(c_h,0)'
94: ,p_prev=>'NVL(p_h,0)'
95: ,p_measurecol=>'BIX_PMV_AI_WEBCALL_CP'
96: ,p_totalcol=>'BIX_PMV_TOTAL11'

Line 101: ||bix_pmv_dbi_utl_pkg.get_divided_measure(

97: ,p_changecol=>'BIX_PMV_AI_WEBCALL_CG'
98: ,p_changetotalcol=>'BIX_PMV_TOTAL12'
99: )
100: ||','
101: ||bix_pmv_dbi_utl_pkg.get_divided_measure(
102: p_percentage=>'Y'
103: ,p_num=>'NVL(c_a, 0)'
104: ,p_denom=>'NVL(c_d,0)'
105: ,p_pnum=>'NVL(p_a, 0)'

Line 115: ||bix_pmv_dbi_utl_pkg.get_divided_measure(

111: )
112: ||','
113: /* For KPI -Inbound Service Level -Current Value - got from BIX_PMV_AI_SL_CP*/
114: /* For KPI -Inbound Service Level -Prior Value*/
115: ||bix_pmv_dbi_utl_pkg.get_divided_measure(
116: p_percentage=>'Y'
117: ,p_num=>'NVL(p_a, 0)'
118: ,p_denom=>'NVL(p_d,0)'
119: ,p_measurecol=>'BIX_CALC_ITEM3'

Line 123: ||bix_pmv_dbi_utl_pkg.get_divided_measure(

119: ,p_measurecol=>'BIX_CALC_ITEM3'
120: ,p_totalcol=>'BIX_CALC_ITEM4'
121: )
122: ||','
123: ||bix_pmv_dbi_utl_pkg.get_divided_measure(
124: p_percentage=>'N'
125: ,p_num=>'NVL(c_c, 0)'
126: ,p_denom=>'NVL(c_g,0)'
127: ,p_pnum=>'NVL(p_c, 0)'

Line 135: ||bix_pmv_dbi_utl_pkg.get_divided_measure(

131: ,p_changecol=>'BIX_PMV_AI_SPANS_CG'
132: ,p_changetotalcol=>'BIX_PMV_TOTAL4'
133: )
134: ||','
135: ||bix_pmv_dbi_utl_pkg.get_divided_measure(
136: p_percentage=>'Y'
137: ,p_num=>'NVL(c_e, 0)'
138: ,p_denom=>'NVL(c_d,0)'
139: ,p_pnum=>'NVL(p_e, 0)'

Line 149: ||bix_pmv_dbi_utl_pkg.get_divided_measure(

145: )
146: ||','
147: /* For KPI-Abandon rate Current period - got from BIX_PMV_AI_ABANRATE_CP*/
148: /* For KPI-Abandon rate Prior period */
149: ||bix_pmv_dbi_utl_pkg.get_divided_measure(
150: p_percentage=>'Y'
151: ,p_num=>'NVL(p_e, 0)'
152: ,p_denom=>'NVL(p_d,0)'
153: ,p_measurecol=>'BIX_CALC_ITEM11'

Line 157: ||bix_pmv_dbi_utl_pkg.get_divided_measure(

153: ,p_measurecol=>'BIX_CALC_ITEM11'
154: ,p_totalcol=>'BIX_CALC_ITEM12'
155: )
156: ||','
157: ||bix_pmv_dbi_utl_pkg.get_divided_measure(
158: p_percentage=>'Y'
159: ,p_num=>'NVL(c_f, 0)'
160: ,p_denom=>'NVL(c_g,0)'
161: ,p_pnum=>'NVL(p_f, 0)'

Line 169: ||bix_pmv_dbi_utl_pkg.get_divided_measure(

165: ,p_changecol=>'BIX_PMV_AI_TRANRATE_CG'
166: ,p_changetotalcol=>'BIX_PMV_TOTAL8'
167: )
168: ||','
169: ||bix_pmv_dbi_utl_pkg.get_divided_measure(
170: p_percentage=>'N'
171: ,p_num=>'NVL(c_k, 0)'
172: ,p_denom=>'NVL(c_i,0)'
173: ,p_pnum=>'NVL(p_k, 0)'

Line 184: /*||bix_pmv_dbi_utl_pkg.get_divided_measure(

180: ||','
181:
182: /* For KPI- Average Talk Current got from BIX_PMV_AI_AVGTALK_CP*/
183: /* For KPI- Average Talk Prior*/
184: /*||bix_pmv_dbi_utl_pkg.get_divided_measure(
185: p_percentage=>'N'
186: ,p_num=>'NVL(p_k, 0)'
187: ,p_denom=>'NVL(p_i,0)'
188: ,p_measurecol=>'BIX_CALC_ITEM23'

Line 193: ||bix_pmv_dbi_utl_pkg.get_divided_measure(

189: ,p_totalcol=>'BIX_CALC_ITEM24'
190: )
191: ||','
192: */
193: ||bix_pmv_dbi_utl_pkg.get_divided_measure(
194: p_percentage=>'N'
195: ,p_num=>'NVL(c_j, 0)'
196: ,p_denom=>'NVL(c_i,0)'
197: ,p_pnum=>'NVL(p_j, 0)'

Line 207: ||bix_pmv_dbi_utl_pkg.get_divided_measure(

203: )
204: ||','
205: /* For KPI- Average Wrap Current - got from BIX_PMV_AI_AVGWRAP_CP */
206: /* For KPI- Average Wrap Prior */
207: ||bix_pmv_dbi_utl_pkg.get_divided_measure(
208: p_percentage=>'N'
209: ,p_num=>'NVL(p_j, 0)'
210: ,p_denom=>'NVL(p_i,0)'
211: ,p_measurecol=>'BIX_CALC_ITEM27'

Line 215: ||bix_pmv_dbi_utl_pkg.get_divided_measure(

211: ,p_measurecol=>'BIX_CALC_ITEM27'
212: ,p_totalcol=>'BIX_CALC_ITEM28'
213: )
214: ||','
215: ||bix_pmv_dbi_utl_pkg.get_divided_measure(
216: p_percentage=>'Y'
217: ,p_num=>'NVL(p_a, 0)'
218: ,p_denom=>'NVL(p_d,0)'
219: ,p_measurecol=>'BIX_PMV_AI_SL_PP'

Line 222: ||bix_pmv_dbi_utl_pkg.get_divided_measure(

218: ,p_denom=>'NVL(p_d,0)'
219: ,p_measurecol=>'BIX_PMV_AI_SL_PP'
220: )
221: ||','
222: ||bix_pmv_dbi_utl_pkg.get_divided_measure(
223: p_percentage=>'N'
224: ,p_num=>'NVL(p_c, 0)'
225: ,p_denom=>'NVL(p_g,0)'
226: ,p_measurecol=>'BIX_PMV_AI_SPANS_PP'

Line 229: ||bix_pmv_dbi_utl_pkg.get_divided_measure(

225: ,p_denom=>'NVL(p_g,0)'
226: ,p_measurecol=>'BIX_PMV_AI_SPANS_PP'
227: )
228: ||','
229: ||bix_pmv_dbi_utl_pkg.get_divided_measure(
230: p_percentage=>'Y'
231: ,p_num=>'NVL(p_e, 0)'
232: ,p_denom=>'NVL(p_d,0)'
233: ,p_measurecol=>'BIX_PMV_AI_ABANRATE_PP'

Line 236: ||bix_pmv_dbi_utl_pkg.get_divided_measure(

232: ,p_denom=>'NVL(p_d,0)'
233: ,p_measurecol=>'BIX_PMV_AI_ABANRATE_PP'
234: )
235: ||','
236: ||bix_pmv_dbi_utl_pkg.get_divided_measure(
237: p_percentage=>'N'
238: ,p_num=>'NVL(p_k, 0)'
239: ,p_denom=>'NVL(p_i,0)'
240: ,p_measurecol=>'BIX_PMV_AI_AVGTALK_PP'

Line 243: ||bix_pmv_dbi_utl_pkg.get_simple_measure(

239: ,p_denom=>'NVL(p_i,0)'
240: ,p_measurecol=>'BIX_PMV_AI_AVGTALK_PP'
241: )
242: ||','
243: ||bix_pmv_dbi_utl_pkg.get_simple_measure(
244: p_curr=>'NVL(p_g, 0)'
245: ,p_measurecol=>'BIX_PMV_AI_INCALLHAND_PP'
246: )
247: ||' FROM((';

Line 310: bix_pmv_dbi_utl_pkg.process_parameters

306: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl ();
307: l_col_tbl_cont := poa_dbi_util_pkg.poa_dbi_col_tbl ();
308:
309:
310: bix_pmv_dbi_utl_pkg.process_parameters
311: ( p_param => p_page_parameter_tbl
312: , p_trend => 'N'
313: , p_func_area => l_func_area
314: , p_version => l_version

Line 325: IF l_view_by = bix_pmv_dbi_utl_pkg.g_ai_ccntr_dim THEN

321: , p_view_by_select => l_view_by_select
322: , p_view_by => l_view_by
323: );
324:
325: IF l_view_by = bix_pmv_dbi_utl_pkg.g_ai_ccntr_dim THEN
326: l_generate_viewby :='Y';
327: ELSIF l_view_by = bix_pmv_dbi_utl_pkg.g_ai_class_dim THEN
328: l_group_by_clause :='group by classification_value &ORDER_BY_CLAUSE nulls last';
329: ELSIF l_view_by = bix_pmv_dbi_utl_pkg.g_ai_dnis_dim THEN

Line 327: ELSIF l_view_by = bix_pmv_dbi_utl_pkg.g_ai_class_dim THEN

323: );
324:
325: IF l_view_by = bix_pmv_dbi_utl_pkg.g_ai_ccntr_dim THEN
326: l_generate_viewby :='Y';
327: ELSIF l_view_by = bix_pmv_dbi_utl_pkg.g_ai_class_dim THEN
328: l_group_by_clause :='group by classification_value &ORDER_BY_CLAUSE nulls last';
329: ELSIF l_view_by = bix_pmv_dbi_utl_pkg.g_ai_dnis_dim THEN
330: l_group_by_clause :='group by dnis_name &ORDER_BY_CLAUSE nulls last';
331: END IF;

Line 329: ELSIF l_view_by = bix_pmv_dbi_utl_pkg.g_ai_dnis_dim THEN

325: IF l_view_by = bix_pmv_dbi_utl_pkg.g_ai_ccntr_dim THEN
326: l_generate_viewby :='Y';
327: ELSIF l_view_by = bix_pmv_dbi_utl_pkg.g_ai_class_dim THEN
328: l_group_by_clause :='group by classification_value &ORDER_BY_CLAUSE nulls last';
329: ELSIF l_view_by = bix_pmv_dbi_utl_pkg.g_ai_dnis_dim THEN
330: l_group_by_clause :='group by dnis_name &ORDER_BY_CLAUSE nulls last';
331: END IF;
332:
333:

Line 448: bix_pmv_dbi_utl_pkg.status_sql_daylevel (

444: );
445:
446:
447: l_sqltext_cont :=
448: bix_pmv_dbi_utl_pkg.status_sql_daylevel (
449: p_fact_name => l_mv
450: , p_row_type_where_clause => l_where_clause --this shud come from util package
451: , p_col_name => l_col_tbl_cont
452: , p_join_tables => l_join_tbl

Line 580: bix_pmv_dbi_utl_pkg.get_bind_vars (p_custom_output,p_func_area => l_func_area);

576:
577:
578:
579: p_sql_text := l_sqltext;
580: bix_pmv_dbi_utl_pkg.get_bind_vars (p_custom_output,p_func_area => l_func_area);
581:
582:
583: -- l_sqltext:=NULL;
584: -- l_where_clause:=NULL;

Line 599: BIX_PMV_DBI_UTL_PKG.get_ai_page_params( p_page_parameter_tbl,

595: l_column_name := NULL;
596:
597: -- Get the parameters
598:
599: BIX_PMV_DBI_UTL_PKG.get_ai_page_params( p_page_parameter_tbl,
600: l_as_of_date,
601: l_period_type,
602: l_record_type_id,
603: l_comp_type,