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

Line 41: ||bix_pmv_dbi_utl_pkg.get_simple_measure(

37: END IF;
38:
39: l_measure_txt :=
40: ' SELECT nvl(party_name,:l_unknown) BIX_PMV_AI_CUSTOMER,'||l_goal||' BIX_PMV_AI_SLGOAL,'
41: ||bix_pmv_dbi_utl_pkg.get_simple_measure(
42: p_curr=>'to_number(NVL(c_e,0))'
43: ,p_prev=>'NVL(p_e,0)'
44: ,p_measurecol=>'BIX_PMV_AI_INCALLHAND_CP'
45: ,p_totalcol=>'BIX_PMV_TOTAL7'

Line 51: ||bix_pmv_dbi_utl_pkg.get_simple_measure(

47: ,p_changetotalcol=>'BIX_PMV_TOTAL8'
48: )
49: ||','
50: /* For KPI- Inbound calls Handled Current */
51: ||bix_pmv_dbi_utl_pkg.get_simple_measure(
52: p_curr=>'NVL(c_e,0)'
53: ,p_measurecol=>'BIX_CALC_ITEM17'
54: ,p_totalcol=>'BIX_CALC_ITEM18'
55: )

Line 57: ||bix_pmv_dbi_utl_pkg.get_simple_measure(

53: ,p_measurecol=>'BIX_CALC_ITEM17'
54: ,p_totalcol=>'BIX_CALC_ITEM18'
55: )
56: ||',' /* For KPI- Inbound calls Handled Previous */
57: ||bix_pmv_dbi_utl_pkg.get_simple_measure(
58: p_curr=>'NVL(p_e,0)'
59: ,p_measurecol=>'BIX_CALC_ITEM19'
60: ,p_totalcol=>'BIX_CALC_ITEM20'
61: )

Line 63: ||bix_pmv_dbi_utl_pkg.get_simple_measure(

59: ,p_measurecol=>'BIX_CALC_ITEM19'
60: ,p_totalcol=>'BIX_CALC_ITEM20'
61: )
62: ||','
63: ||bix_pmv_dbi_utl_pkg.get_simple_measure(
64: p_curr=>'NVL(c_i,0)'
65: ,p_prev=>'NVL(p_i,0)'
66: ,p_measurecol=>'BIX_PMV_AI_SRCR_CP'
67: ,p_totalcol=>'BIX_PMV_TOTAL13'

Line 73: bix_pmv_dbi_utl_pkg.get_simple_measure(

69: ,p_changetotalcol=>'BIX_PMV_TOTAL14'
70: )
71: ||','
72: ||/* For KPI- SR created -Current period */
73: bix_pmv_dbi_utl_pkg.get_simple_measure(
74: p_curr=>'NVL(c_i,0)'
75: ,p_measurecol=>'BIX_CALC_ITEM29'
76: ,p_totalcol=>'BIX_CALC_ITEM30'
77: )

Line 80: bix_pmv_dbi_utl_pkg.get_simple_measure(

76: ,p_totalcol=>'BIX_CALC_ITEM30'
77: )
78: ||','
79: ||/* For KPI- SR created -Prior period */
80: bix_pmv_dbi_utl_pkg.get_simple_measure(
81: p_curr=>'NVL(p_i,0)'
82: ,p_measurecol=>'BIX_CALC_ITEM31'
83: ,p_totalcol=>'BIX_CALC_ITEM32'
84: )

Line 86: ||bix_pmv_dbi_utl_pkg.get_simple_measure(

82: ,p_measurecol=>'BIX_CALC_ITEM31'
83: ,p_totalcol=>'BIX_CALC_ITEM32'
84: )
85: ||','
86: ||bix_pmv_dbi_utl_pkg.get_simple_measure(
87: p_curr=>'NVL(c_j,0)'
88: ,p_prev=>'NVL(p_j,0)'
89: ,p_measurecol=>'BIX_PMV_AI_LECR_CP'
90: ,p_totalcol=>'BIX_PMV_TOTAL15'

Line 96: bix_pmv_dbi_utl_pkg.get_simple_measure(

92: ,p_changetotalcol=>'BIX_PMV_TOTAL16'
93: )
94: ||','
95: ||/* For KPI- Leads created -Current period */
96: bix_pmv_dbi_utl_pkg.get_simple_measure(
97: p_curr=>'NVL(c_j,0)'
98: ,p_measurecol=>'BIX_CALC_ITEM33'
99: ,p_totalcol=>'BIX_CALC_ITEM34'
100: )

Line 103: bix_pmv_dbi_utl_pkg.get_simple_measure(

99: ,p_totalcol=>'BIX_CALC_ITEM34'
100: )
101: ||','
102: ||/* For KPI- Leads created -Priorperiod */
103: bix_pmv_dbi_utl_pkg.get_simple_measure(
104: p_curr=>'NVL(p_j,0)'
105: ,p_measurecol=>'BIX_CALC_ITEM35'
106: ,p_totalcol=>'BIX_CALC_ITEM36'
107: )

Line 109: ||bix_pmv_dbi_utl_pkg.get_simple_measure(

105: ,p_measurecol=>'BIX_CALC_ITEM35'
106: ,p_totalcol=>'BIX_CALC_ITEM36'
107: )
108: ||','
109: ||bix_pmv_dbi_utl_pkg.get_simple_measure(
110: p_curr=>'NVL(c_n,0)'
111: ,p_prev=>'NVL(p_n,0)'
112: ,p_measurecol=>'BIX_PMV_AI_OPCR_CP'
113: ,p_totalcol=>'BIX_PMV_TOTAL19'

Line 119: bix_pmv_dbi_utl_pkg.get_simple_measure(

115: ,p_changetotalcol=>'BIX_PMV_TOTAL20'
116: )
117: ||','
118: ||/* For KPI- Opportunities created -Current period */
119: bix_pmv_dbi_utl_pkg.get_simple_measure(
120: p_curr=>'NVL(c_n,0)'
121: ,p_measurecol=>'BIX_CALC_ITEM37'
122: ,p_totalcol=>'BIX_CALC_ITEM38'
123: )

Line 126: bix_pmv_dbi_utl_pkg.get_simple_measure(

122: ,p_totalcol=>'BIX_CALC_ITEM38'
123: )
124: ||','
125: ||/* For KPI- Opportunities created -Prior period */
126: bix_pmv_dbi_utl_pkg.get_simple_measure(
127: p_curr=>'NVL(p_n,0)'
128: ,p_measurecol=>'BIX_CALC_ITEM39'
129: ,p_totalcol=>'BIX_CALC_ITEM40'
130: )

Line 132: ||bix_pmv_dbi_utl_pkg.get_divided_measure(

128: ,p_measurecol=>'BIX_CALC_ITEM39'
129: ,p_totalcol=>'BIX_CALC_ITEM40'
130: )
131: ||','
132: ||bix_pmv_dbi_utl_pkg.get_divided_measure(
133: p_percentage=>'Y'
134: ,p_num=>'NVL(c_a, 0)'
135: ,p_denom=>'NVL(c_c,0)'
136: ,p_pnum=>'NVL(p_a, 0)'

Line 144: ||bix_pmv_dbi_utl_pkg.get_divided_measure(

140: ,p_changecol=>'BIX_PMV_AI_SL_CG'
141: ,p_changetotalcol=>'BIX_PMV_TOTAL2'
142: )
143: ||','
144: ||bix_pmv_dbi_utl_pkg.get_divided_measure(
145: p_percentage=>'N'
146: ,p_num=>'NVL(c_b, 0)'
147: ,p_denom=>'NVL(c_e,0)'
148: ,p_pnum=>'NVL(p_b, 0)'

Line 156: ||bix_pmv_dbi_utl_pkg.get_divided_measure(

152: ,p_changecol=>'BIX_PMV_AI_SPANS_CG'
153: ,p_changetotalcol=>'BIX_PMV_TOTAL4'
154: )
155: ||',' /* KPI - Average Speed to Answer */
156: ||bix_pmv_dbi_utl_pkg.get_divided_measure(
157: p_percentage=>'N'
158: ,p_num=>'NVL(c_b, 0)'
159: ,p_denom=>'NVL(c_e,0)'
160: ,p_measurecol=>'BIX_CALC_ITEM21'

Line 164: ||bix_pmv_dbi_utl_pkg.get_divided_measure(

160: ,p_measurecol=>'BIX_CALC_ITEM21'
161: ,p_totalcol=>'BIX_CALC_ITEM22'
162: )
163: ||','
164: ||bix_pmv_dbi_utl_pkg.get_divided_measure(
165: p_percentage=>'N'
166: ,p_num=>'NVL(p_b, 0)'
167: ,p_denom=>'NVL(p_e,0)'
168: ,p_measurecol=>'BIX_CALC_ITEM23'

Line 173: ||bix_pmv_dbi_utl_pkg.get_divided_measure(

169: ,p_totalcol=>'BIX_CALC_ITEM24'
170: )
171: ||','
172:
173: ||bix_pmv_dbi_utl_pkg.get_divided_measure(
174: p_percentage=>'Y'
175: ,p_num=>'NVL(c_d, 0)'
176: ,p_denom=>'NVL(c_e,0)'
177: ,p_pnum=>'NVL(p_d, 0)'

Line 185: ||bix_pmv_dbi_utl_pkg.get_divided_measure(

181: ,p_changecol=>'BIX_PMV_AI_TRANRATE_CG'
182: ,p_changetotalcol=>'BIX_PMV_TOTAL6'
183: )
184: ||',' /* KPI - Transfer Rate */
185: ||bix_pmv_dbi_utl_pkg.get_divided_measure(
186: p_percentage=>'Y'
187: ,p_num=>'NVL(c_d, 0)'
188: ,p_denom=>'NVL(c_e,0)'
189: ,p_measurecol=>'BIX_CALC_ITEM25'

Line 193: ||bix_pmv_dbi_utl_pkg.get_divided_measure(

189: ,p_measurecol=>'BIX_CALC_ITEM25'
190: ,p_totalcol=>'BIX_CALC_ITEM26'
191: )
192: ||','
193: ||bix_pmv_dbi_utl_pkg.get_divided_measure(
194: p_percentage=>'Y'
195: ,p_num=>'NVL(p_d, 0)'
196: ,p_denom=>'NVL(p_e,0)'
197: ,p_measurecol=>'BIX_CALC_ITEM27'

Line 202: ||bix_pmv_dbi_utl_pkg.get_divided_measure(

198: ,p_totalcol=>'BIX_CALC_ITEM28'
199: )
200: ||','
201: /* Average Talk KPI */
202: ||bix_pmv_dbi_utl_pkg.get_divided_measure(
203: p_percentage=>'N'
204: ,p_num=>'NVL(c_h, 0)'
205: ,p_denom=>'NVL(c_f,0)'
206: ,p_measurecol=>'BIX_CALC_ITEM1'

Line 210: ||bix_pmv_dbi_utl_pkg.get_divided_measure(

206: ,p_measurecol=>'BIX_CALC_ITEM1'
207: ,p_totalcol=>'BIX_CALC_ITEM2'
208: )
209: ||','
210: ||bix_pmv_dbi_utl_pkg.get_divided_measure(
211: p_percentage=>'N'
212: ,p_num=>'NVL(p_h, 0)'
213: ,p_denom=>'NVL(p_f,0)'
214: ,p_measurecol=>'BIX_CALC_ITEM3'

Line 218: ||bix_pmv_dbi_utl_pkg.get_divided_measure(

214: ,p_measurecol=>'BIX_CALC_ITEM3'
215: ,p_totalcol=>'BIX_CALC_ITEM4'
216: )
217: ||','
218: ||bix_pmv_dbi_utl_pkg.get_divided_measure(
219: p_percentage=>'N'
220: ,p_num=>'NVL(c_h, 0)'
221: ,p_denom=>'NVL(c_f,0)'
222: ,p_pnum=>'NVL(p_h, 0)'

Line 230: ||bix_pmv_dbi_utl_pkg.get_divided_measure(

226: ,p_changecol=>'BIX_PMV_AI_AVGTALK_CG'
227: ,p_changetotalcol=>'BIX_PMV_TOTAL10'
228: )
229: ||','
230: ||bix_pmv_dbi_utl_pkg.get_divided_measure(
231: p_percentage=>'N'
232: ,p_num=>'NVL(c_g, 0)'
233: ,p_denom=>'NVL(c_f,0)'
234: ,p_pnum=>'NVL(p_g, 0)'

Line 285: bix_pmv_dbi_utl_pkg.process_parameters

281: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
282: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl ();
283: l_col_tbl_cont := poa_dbi_util_pkg.poa_dbi_col_tbl ();
284:
285: bix_pmv_dbi_utl_pkg.process_parameters
286: ( p_param => p_page_parameter_tbl
287: , p_trend => 'N'
288: , p_func_area => l_func_area
289: , p_version => l_version

Line 378: bix_pmv_dbi_utl_pkg.status_sql_daylevel (

374: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
375: , p_to_date_type => l_timetype
376: );
377: l_sqltext_cont :=
378: bix_pmv_dbi_utl_pkg.status_sql_daylevel (
379: p_fact_name => l_mv
380: , p_row_type_where_clause => l_where_clause --this shud come from util package
381: , p_col_name => l_col_tbl_cont
382: , p_join_tables => l_join_tbl

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

478: || get_zeronull_clause;
479:
480:
481: p_sql_text:=l_sqltext;
482: bix_pmv_dbi_utl_pkg.get_bind_vars (p_custom_output,p_func_area => l_func_area);
483:
484:
485: /* End of Trial for Util Package */
486: