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

Line 49: ||bix_pmv_dbi_utl_pkg.get_simple_measure(

45: END IF;
46:
47: l_measure_txt :=
48: ' SELECT v.resource_name BIX_PMV_AI_AGENT, '
49: ||bix_pmv_dbi_utl_pkg.get_simple_measure(
50: p_curr=>'to_number(NVL(c_lg,0))'
51: ,p_measurecol=>'BIX_PMV_AI_LOGIN_CP'
52: ,p_totalcol=>'BIX_PMV_TOTAL1'
53: ,p_convertunit=>'/3600'

Line 56: ||bix_pmv_dbi_utl_pkg.get_pertotal_measure(

52: ,p_totalcol=>'BIX_PMV_TOTAL1'
53: ,p_convertunit=>'/3600'
54: )
55: ||','
56: ||bix_pmv_dbi_utl_pkg.get_pertotal_measure(
57: p_num =>'to_number(NVL(c_lg,0))'
58: ,p_measurecol=>'BIX_PMV_AI_LOGIN_PT'
59: )
60: ||','

Line 61: ||bix_pmv_dbi_utl_pkg.get_divided_measure(

57: p_num =>'to_number(NVL(c_lg,0))'
58: ,p_measurecol=>'BIX_PMV_AI_LOGIN_PT'
59: )
60: ||','
61: ||bix_pmv_dbi_utl_pkg.get_divided_measure(
62: p_percentage=>'Y'
63: ,p_num=>'NVL(c_lg, 0)-NVL(c_id,0)'
64: ,p_denom=>'NVL(c_lg,0)'
65: ,p_measurecol=>'BIX_PMV_AI_AVAILRATE_CP'

Line 69: ||bix_pmv_dbi_utl_pkg.get_devavg_measure(

65: ,p_measurecol=>'BIX_PMV_AI_AVAILRATE_CP'
66: ,p_totalcol=>'BIX_PMV_TOTAL2'
67: )
68: ||','
69: ||bix_pmv_dbi_utl_pkg.get_devavg_measure(
70: p_percentage=>'Y'
71: ,p_num=>'NVL(c_lg, 0)-NVL(c_id,0)'
72: ,p_denom=>'NVL(c_lg,0)'
73: ,p_col=>'BIX_PMV_AI_AVAILRATE_DEV'

Line 76: ||bix_pmv_dbi_utl_pkg.get_divided_measure(

72: ,p_denom=>'NVL(c_lg,0)'
73: ,p_col=>'BIX_PMV_AI_AVAILRATE_DEV'
74: )
75: ||','
76: ||bix_pmv_dbi_utl_pkg.get_divided_measure(
77: p_percentage=>'Y'
78: ,p_num=>'NVL(c_lg, 0)-NVL(c_id,0)-NVL(c_av,0)'
79: ,p_denom=>'NVL(c_lg,0)'
80: ,p_measurecol=>'BIX_PMV_AI_UTILRATE_CP'

Line 84: ||bix_pmv_dbi_utl_pkg.get_devavg_measure(

80: ,p_measurecol=>'BIX_PMV_AI_UTILRATE_CP'
81: ,p_totalcol=>'BIX_PMV_TOTAL3'
82: )
83: ||','
84: ||bix_pmv_dbi_utl_pkg.get_devavg_measure(
85: p_percentage=>'Y'
86: ,p_num=>'NVL(c_lg, 0)-NVL(c_id,0)-NVL(c_av,0)'
87: ,p_denom=>'NVL(c_lg,0)'
88: ,p_col=>'BIX_PMV_AI_UTILRATE_DEV'

Line 91: ||bix_pmv_dbi_utl_pkg.get_simple_measure(

87: ,p_denom=>'NVL(c_lg,0)'
88: ,p_col=>'BIX_PMV_AI_UTILRATE_DEV'
89: )
90: ||','
91: ||bix_pmv_dbi_utl_pkg.get_simple_measure(
92: p_curr=>'NVL(c_ic,0)'
93: ,p_measurecol=>'BIX_PMV_AI_INCALLHAND_CP'
94: ,p_totalcol=>'BIX_PMV_TOTAL4'
95: )

Line 97: ||bix_pmv_dbi_utl_pkg.get_pertotal_measure(

93: ,p_measurecol=>'BIX_PMV_AI_INCALLHAND_CP'
94: ,p_totalcol=>'BIX_PMV_TOTAL4'
95: )
96: ||','
97: ||bix_pmv_dbi_utl_pkg.get_pertotal_measure(
98: p_num =>'to_number(NVL(c_ic,0))'
99: ,p_measurecol=>'BIX_PMV_AI_INCALLHAND_PT'
100: )
101: ||','

Line 102: ||bix_pmv_dbi_utl_pkg.get_divided_measure(

98: p_num =>'to_number(NVL(c_ic,0))'
99: ,p_measurecol=>'BIX_PMV_AI_INCALLHAND_PT'
100: )
101: ||','
102: ||bix_pmv_dbi_utl_pkg.get_divided_measure(
103: p_percentage=>'N'
104: ,p_num=>'NVL(c_ic,0)'
105: ,p_denom=>'NVL(c_lg,0)'
106: ,p_measurecol=>'BIX_PMV_AI_INCALLHAND_PAH'

Line 111: ||bix_pmv_dbi_utl_pkg.get_devavg_measure(

107: ,p_totalcol=>'BIX_PMV_TOTAL5'
108: ,p_convunitfordenom=>'/3600'
109: )
110: ||','
111: ||bix_pmv_dbi_utl_pkg.get_devavg_measure(
112: p_percentage=>'N'
113: ,p_num=>'NVL(c_ic,0)'
114: ,p_denom=>'NVL(c_lg,0)'
115: ,p_col=>'BIX_PMV_AI_INCALLHAND_PAH_DEV'

Line 119: ||bix_pmv_dbi_utl_pkg.get_simple_measure(

115: ,p_col=>'BIX_PMV_AI_INCALLHAND_PAH_DEV'
116: ,p_convunitfordenom=>'/3600'
117: )
118: ||','
119: ||bix_pmv_dbi_utl_pkg.get_simple_measure(
120: p_curr=>'NVL(c_mc,0)'
121: ,p_measurecol=>'BIX_PMV_AI_DIALED_CP'
122: ,p_totalcol=>'BIX_PMV_TOTAL8'
123: )

Line 125: ||bix_pmv_dbi_utl_pkg.get_pertotal_measure(

121: ,p_measurecol=>'BIX_PMV_AI_DIALED_CP'
122: ,p_totalcol=>'BIX_PMV_TOTAL8'
123: )
124: ||','
125: ||bix_pmv_dbi_utl_pkg.get_pertotal_measure(
126: p_num =>'to_number(NVL(c_mc,0))'
127: ,p_measurecol=>'BIX_PMV_AI_DIALED_PT'
128: )
129: ||','

Line 130: ||bix_pmv_dbi_utl_pkg.get_divided_measure(

126: p_num =>'to_number(NVL(c_mc,0))'
127: ,p_measurecol=>'BIX_PMV_AI_DIALED_PT'
128: )
129: ||','
130: ||bix_pmv_dbi_utl_pkg.get_divided_measure(
131: p_percentage=>'N'
132: ,p_num=>'NVL(c_mc,0)'
133: ,p_denom=>'NVL(c_lg,0)'
134: ,p_measurecol=>'BIX_PMV_AI_DIALED_PAH'

Line 139: ||bix_pmv_dbi_utl_pkg.get_devavg_measure(

135: ,p_totalcol=>'BIX_PMV_TOTAL9'
136: ,p_convunitfordenom=>'/3600'
137: )
138: ||','
139: ||bix_pmv_dbi_utl_pkg.get_devavg_measure(
140: p_percentage=>'N'
141: ,p_num=>'NVL(c_mc,0)'
142: ,p_denom=>'NVL(c_lg,0)'
143: ,p_col=>'BIX_PMV_AI_DIALED_PAH_DEV'

Line 147: ||bix_pmv_dbi_utl_pkg.get_divided_measure(

143: ,p_col=>'BIX_PMV_AI_DIALED_PAH_DEV'
144: ,p_convunitfordenom=>'/3600'
145: )
146: ||','
147: ||bix_pmv_dbi_utl_pkg.get_divided_measure(
148: p_percentage=>'N'
149: ,p_num=>'NVL(c_t, 0)'
150: ,p_denom=>'NVL(c_tc,0)+NVL(c_cch,0)+
151: NVL(c_ctc,0)+NVL(c_cct,0)'

Line 156: ||bix_pmv_dbi_utl_pkg.get_devavg_measure(

152: ,p_measurecol=>'BIX_PMV_AI_AVGTALK_CP'
153: ,p_totalcol=>'BIX_PMV_TOTAL10'
154: )
155: ||','
156: ||bix_pmv_dbi_utl_pkg.get_devavg_measure(
157: p_percentage=>'N'
158: ,p_num=>'NVL(c_t, 0)'
159: ,p_denom=>'NVL(c_tc,0)+NVL(c_cch,0)+
160: NVL(c_ctc,0)+NVL(c_cct,0)'

Line 164: ||bix_pmv_dbi_utl_pkg.get_divided_measure(

160: NVL(c_ctc,0)+NVL(c_cct,0)'
161: ,p_col=>'BIX_PMV_AI_AVGTALK_DEV'
162: )
163: ||','
164: ||bix_pmv_dbi_utl_pkg.get_divided_measure(
165: p_percentage=>'N'
166: ,p_num=>'NVL(c_w, 0)'
167: ,p_denom=>'NVL(c_tc,0)+NVL(c_cch,0)+
168: NVL(c_ctc,0)+NVL(c_cct,0)'

Line 173: ||bix_pmv_dbi_utl_pkg.get_devavg_measure(

169: ,p_measurecol=>'BIX_PMV_AI_AVGWRAP_CP'
170: ,p_totalcol=>'BIX_PMV_TOTAL11'
171: )
172: ||','
173: ||bix_pmv_dbi_utl_pkg.get_devavg_measure(
174: p_percentage=>'N'
175: ,p_num=>'NVL(c_w, 0)'
176: ,p_denom=>'NVL(c_tc,0)+NVL(c_cch,0)+
177: NVL(c_ctc,0)+NVL(c_cct,0)'

Line 181: ||bix_pmv_dbi_utl_pkg.get_simple_measure(

177: NVL(c_ctc,0)+NVL(c_cct,0)'
178: ,p_col=>'BIX_PMV_AI_AVGWRAP_DEV'
179: )
180: ||','
181: ||bix_pmv_dbi_utl_pkg.get_simple_measure(
182: p_curr=>'NVL(c_wc,0)'
183: ,p_measurecol=>'BIX_PMV_AI_WEBCALL_CP'
184: ,p_totalcol=>'BIX_PMV_TOTAL6'
185: )

Line 187: ||bix_pmv_dbi_utl_pkg.get_pertotal_measure(

183: ,p_measurecol=>'BIX_PMV_AI_WEBCALL_CP'
184: ,p_totalcol=>'BIX_PMV_TOTAL6'
185: )
186: ||','
187: ||bix_pmv_dbi_utl_pkg.get_pertotal_measure(
188: p_num =>'to_number(NVL(c_wc,0))'
189: ,p_measurecol=>'BIX_PMV_AI_WEBCALL_PT'
190: )
191: ||','

Line 192: ||bix_pmv_dbi_utl_pkg.get_divided_measure(

188: p_num =>'to_number(NVL(c_wc,0))'
189: ,p_measurecol=>'BIX_PMV_AI_WEBCALL_PT'
190: )
191: ||','
192: ||bix_pmv_dbi_utl_pkg.get_divided_measure(
193: p_percentage=>'N'
194: ,p_num=>'NVL(c_wc,0)'
195: ,p_denom=>'NVL(c_lg,0)'
196: ,p_measurecol=>'BIX_PMV_AI_WEBCALL_PAH'

Line 201: ||bix_pmv_dbi_utl_pkg.get_devavg_measure(

197: ,p_totalcol=>'BIX_PMV_TOTAL7'
198: ,p_convunitfordenom=>'/3600'
199: )
200: ||','
201: ||bix_pmv_dbi_utl_pkg.get_devavg_measure(
202: p_percentage=>'N'
203: ,p_num=>'NVL(c_wc,0)'
204: ,p_denom=>'NVL(c_lg,0)'
205: ,p_col=>'BIX_PMV_AI_WEBCALL_PAH_DEV'

Line 209: ||bix_pmv_dbi_utl_pkg.get_simple_measure(

205: ,p_col=>'BIX_PMV_AI_WEBCALL_PAH_DEV'
206: ,p_convunitfordenom=>'/3600'
207: )
208: ||','
209: ||bix_pmv_dbi_utl_pkg.get_simple_measure(
210: p_curr=>'NVL(c_s,0)'
211: ,p_measurecol=>'BIX_PMV_AI_SRCR_CP'
212: ,p_totalcol=>'BIX_PMV_TOTAL13'
213: )

Line 215: ||bix_pmv_dbi_utl_pkg.get_pertotal_measure(

211: ,p_measurecol=>'BIX_PMV_AI_SRCR_CP'
212: ,p_totalcol=>'BIX_PMV_TOTAL13'
213: )
214: ||','
215: ||bix_pmv_dbi_utl_pkg.get_pertotal_measure(
216: p_num =>'to_number(NVL(c_s,0))'
217: ,p_measurecol=>'BIX_PMV_AI_SRCR_PT'
218: )
219: ||','

Line 220: ||bix_pmv_dbi_utl_pkg.get_simple_measure(

216: p_num =>'to_number(NVL(c_s,0))'
217: ,p_measurecol=>'BIX_PMV_AI_SRCR_PT'
218: )
219: ||','
220: ||bix_pmv_dbi_utl_pkg.get_simple_measure(
221: p_curr=>'NVL(c_l,0)'
222: ,p_measurecol=>'BIX_PMV_AI_LECR_CP'
223: ,p_totalcol=>'BIX_PMV_TOTAL14'
224: )

Line 226: ||bix_pmv_dbi_utl_pkg.get_pertotal_measure(

222: ,p_measurecol=>'BIX_PMV_AI_LECR_CP'
223: ,p_totalcol=>'BIX_PMV_TOTAL14'
224: )
225: ||','
226: ||bix_pmv_dbi_utl_pkg.get_pertotal_measure(
227: p_num =>'to_number(NVL(c_l,0))'
228: ,p_measurecol=>'BIX_PMV_AI_LECR_PT'
229: )
230: ||','

Line 231: ||bix_pmv_dbi_utl_pkg.get_simple_measure(

227: p_num =>'to_number(NVL(c_l,0))'
228: ,p_measurecol=>'BIX_PMV_AI_LECR_PT'
229: )
230: ||','
231: ||bix_pmv_dbi_utl_pkg.get_simple_measure(
232: p_curr=>'NVL(c_o,0)'
233: ,p_measurecol=>'BIX_PMV_AI_OPCR_CP'
234: ,p_totalcol=>'BIX_PMV_TOTAL15'
235: )

Line 237: ||bix_pmv_dbi_utl_pkg.get_pertotal_measure(

233: ,p_measurecol=>'BIX_PMV_AI_OPCR_CP'
234: ,p_totalcol=>'BIX_PMV_TOTAL15'
235: )
236: ||','
237: ||bix_pmv_dbi_utl_pkg.get_pertotal_measure(
238: p_num =>'to_number(NVL(c_o,0))'
239: ,p_measurecol=>'BIX_PMV_AI_OPCR_PT'
240: )
241: ||','

Line 243: ||bix_pmv_dbi_utl_pkg.get_simple_measure(

239: ,p_measurecol=>'BIX_PMV_AI_OPCR_PT'
240: )
241: ||','
242:
243: ||bix_pmv_dbi_utl_pkg.get_simple_measure(
244: p_curr=>'NVL(c_mc,0)'
245: ,p_measurecol=>'BIX_CALC_ITEM1'
246: ,p_totalcol=>'BIX_CALC_ITEM2'
247: )

Line 249: ||bix_pmv_dbi_utl_pkg.get_simple_measure(

245: ,p_measurecol=>'BIX_CALC_ITEM1'
246: ,p_totalcol=>'BIX_CALC_ITEM2'
247: )
248: ||','
249: ||bix_pmv_dbi_utl_pkg.get_simple_measure(
250: p_curr=>'NVL(p_mc,0)'
251: ,p_measurecol=>'BIX_CALC_ITEM3'
252: ,p_totalcol=>'BIX_CALC_ITEM4'
253: )

Line 255: ||bix_pmv_dbi_utl_pkg.get_simple_measure(

251: ,p_measurecol=>'BIX_CALC_ITEM3'
252: ,p_totalcol=>'BIX_CALC_ITEM4'
253: )
254: ||','
255: ||bix_pmv_dbi_utl_pkg.get_simple_measure(
256: p_curr=>'NVL(c_wc,0)'
257: ,p_measurecol=>'BIX_CALC_ITEM5'
258: ,p_totalcol=>'BIX_CALC_ITEM6'
259: )

Line 261: ||bix_pmv_dbi_utl_pkg.get_simple_measure(

257: ,p_measurecol=>'BIX_CALC_ITEM5'
258: ,p_totalcol=>'BIX_CALC_ITEM6'
259: )
260: ||','
261: ||bix_pmv_dbi_utl_pkg.get_simple_measure(
262: p_curr=>'NVL(p_wc,0)'
263: ,p_measurecol=>'BIX_CALC_ITEM7'
264: ,p_totalcol=>'BIX_CALC_ITEM8'
265: )

Line 267: ||bix_pmv_dbi_utl_pkg.get_divided_measure(

263: ,p_measurecol=>'BIX_CALC_ITEM7'
264: ,p_totalcol=>'BIX_CALC_ITEM8'
265: )
266: ||','
267: ||bix_pmv_dbi_utl_pkg.get_divided_measure(
268: p_percentage=>'Y'
269: ,p_num=>'NVL(c_lg, 0)-NVL(c_id,0)'
270: ,p_denom=>'NVL(c_lg,0)'
271: ,p_measurecol=>'BIX_CALC_ITEM9'

Line 275: ||bix_pmv_dbi_utl_pkg.get_divided_measure(

271: ,p_measurecol=>'BIX_CALC_ITEM9'
272: ,p_totalcol=>'BIX_CALC_ITEM10'
273: )
274: ||','
275: ||bix_pmv_dbi_utl_pkg.get_divided_measure(
276: p_percentage=>'Y'
277: ,p_num=>'NVL(p_lg, 0)-NVL(p_id,0)'
278: ,p_denom=>'NVL(p_lg,0)'
279: ,p_measurecol=>'BIX_CALC_ITEM11'

Line 283: ||bix_pmv_dbi_utl_pkg.get_divided_measure(

279: ,p_measurecol=>'BIX_CALC_ITEM11'
280: ,p_totalcol=>'BIX_CALC_ITEM12'
281: )
282: ||','
283: ||bix_pmv_dbi_utl_pkg.get_divided_measure(
284: p_percentage=>'Y'
285: ,p_num=>'NVL(c_lg, 0)-NVL(c_id,0)-NVL(c_av,0)'
286: ,p_denom=>'NVL(c_lg,0)'
287: ,p_measurecol=>'BIX_CALC_ITEM13'

Line 291: ||bix_pmv_dbi_utl_pkg.get_divided_measure(

287: ,p_measurecol=>'BIX_CALC_ITEM13'
288: ,p_totalcol=>'BIX_CALC_ITEM14'
289: )
290: ||','
291: ||bix_pmv_dbi_utl_pkg.get_divided_measure(
292: p_percentage=>'Y'
293: ,p_num=>'NVL(p_lg, 0)-NVL(p_id,0)-NVL(p_av,0)'
294: ,p_denom=>'NVL(p_lg,0)'
295: ,p_measurecol=>'BIX_CALC_ITEM15'

Line 299: ||bix_pmv_dbi_utl_pkg.get_divided_measure(

295: ,p_measurecol=>'BIX_CALC_ITEM15'
296: ,p_totalcol=>'BIX_CALC_ITEM16'
297: )
298: ||','
299: ||bix_pmv_dbi_utl_pkg.get_divided_measure(
300: p_percentage=>'N'
301: ,p_num=>'NVL(c_ic,0)'
302: ,p_denom=>'NVL(c_lg,0)'
303: ,p_measurecol=>'BIX_CALC_ITEM17'

Line 308: ||bix_pmv_dbi_utl_pkg.get_divided_measure(

304: ,p_totalcol=>'BIX_CALC_ITEM18'
305: ,p_convunitfordenom=>'/3600'
306: )
307: ||','
308: ||bix_pmv_dbi_utl_pkg.get_divided_measure(
309: p_percentage=>'N'
310: ,p_num=>'NVL(p_ic,0)'
311: ,p_denom=>'NVL(p_lg,0)'
312: ,p_measurecol=>'BIX_CALC_ITEM19'

Line 398: bix_pmv_dbi_utl_pkg.process_parameters

394: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl ();
395: l_col_tbl_cont := poa_dbi_util_pkg.poa_dbi_col_tbl ();
396: l_col_tbl_sess := poa_dbi_util_pkg.poa_dbi_col_tbl ();
397:
398: bix_pmv_dbi_utl_pkg.process_parameters
399: ( p_param => p_page_parameter_tbl
400: , p_trend => 'N'
401: , p_func_area => l_func_area
402: , p_version => l_version

Line 521: BIX_PMV_DBI_utl_pkg.status_sql_daylevel (

517: , p_to_date_type => l_timetype
518: );
519:
520: l_sqltext_cont :=
521: BIX_PMV_DBI_utl_pkg.status_sql_daylevel (
522: p_fact_name => l_mv
523: , p_row_type_where_clause => l_where_clause --this shud come from util package
524: , p_col_name => l_col_tbl_cont
525: , p_join_tables => l_join_tbl

Line 532: bix_pmv_dbi_utl_pkg.process_parameters

528: --insert into bix_Debug values ('Ended status_sql_daylevel for continued');
529: --
530: --Session SQL
531: --
532: bix_pmv_dbi_utl_pkg.process_parameters
533: ( p_param => p_page_parameter_tbl
534: , p_trend => 'N'
535: , p_func_area => l_func_area
536: , p_version => l_version

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

749: --insert into bix_debug values (x);
750:
751:
752: p_sql_text:=l_sqltext;
753: bix_pmv_dbi_utl_pkg.get_bind_vars (p_custom_output,p_func_area => l_func_area);
754:
755: /* End of Trial for Util Package */
756:
757: /*****************************