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_CAMP_PERF_REPORT dependencies on BIX_UTIL_PKG

Line 107: bix_util_pkg.get_conversion_rate(v_global_currency, v_user_currency, sysdate, v_conversion_type, l_denom_rate, l_num_rate, l_status );

103: v_conversion_type := fnd_profile.value( 'BIX_DM_CONVERSION_TYPE' );
104: v_user_def_curr := fnd_profile.value('JTF_PROFILE_DEFAULT_CURRENCY');
105: v_format_mask := fnd_currency.get_format_mask(v_user_currency, 30 );
106: --to_char( amt, l_format_mask)
107: bix_util_pkg.get_conversion_rate(v_global_currency, v_user_currency, sysdate, v_conversion_type, l_denom_rate, l_num_rate, l_status );
108: if (l_denom_rate = 0 or l_denom_rate is null) then
109: l_factor := 1;
110: else
111: l_factor := l_num_rate/l_denom_rate;

Line 144: , bix_util_pkg.get_hrmiss_frmt(SUM(login_time))

140: , l_index
141: , v_campaign_name
142: , null
143: , null
144: , bix_util_pkg.get_hrmiss_frmt(SUM(login_time))
145: , SUM(IN_CALLS_HANDLED + out_calls_handled)
146: , bix_util_pkg.get_hrmiss_frmt(SUM(in_talk_time + out_talk_time)
147: / DECODE(SUM(in_calls_handled + out_calls_handled),0,1,SUM(in_calls_handled + out_calls_handled)))
148: , bix_util_pkg.get_hrmiss_frmt(SUM(in_wrap_time + out_wrap_time)

Line 146: , bix_util_pkg.get_hrmiss_frmt(SUM(in_talk_time + out_talk_time)

142: , null
143: , null
144: , bix_util_pkg.get_hrmiss_frmt(SUM(login_time))
145: , SUM(IN_CALLS_HANDLED + out_calls_handled)
146: , bix_util_pkg.get_hrmiss_frmt(SUM(in_talk_time + out_talk_time)
147: / DECODE(SUM(in_calls_handled + out_calls_handled),0,1,SUM(in_calls_handled + out_calls_handled)))
148: , bix_util_pkg.get_hrmiss_frmt(SUM(in_wrap_time + out_wrap_time)
149: /decode(SUM(in_calls_handled + out_calls_handled),0,1,SUM(in_calls_handled + out_calls_handled)))
150: , bix_util_pkg.get_hrmiss_frmt(sum(available_time + in_talk_time + out_talk_time + in_wrap_time + out_wrap_time))

Line 148: , bix_util_pkg.get_hrmiss_frmt(SUM(in_wrap_time + out_wrap_time)

144: , bix_util_pkg.get_hrmiss_frmt(SUM(login_time))
145: , SUM(IN_CALLS_HANDLED + out_calls_handled)
146: , bix_util_pkg.get_hrmiss_frmt(SUM(in_talk_time + out_talk_time)
147: / DECODE(SUM(in_calls_handled + out_calls_handled),0,1,SUM(in_calls_handled + out_calls_handled)))
148: , bix_util_pkg.get_hrmiss_frmt(SUM(in_wrap_time + out_wrap_time)
149: /decode(SUM(in_calls_handled + out_calls_handled),0,1,SUM(in_calls_handled + out_calls_handled)))
150: , bix_util_pkg.get_hrmiss_frmt(sum(available_time + in_talk_time + out_talk_time + in_wrap_time + out_wrap_time))
151: , trunc(sum(available_time + in_talk_time + out_talk_time + in_wrap_time + out_wrap_time)/sum(login_time) * 100, 2)
152: ,sum(leads_created)

Line 150: , bix_util_pkg.get_hrmiss_frmt(sum(available_time + in_talk_time + out_talk_time + in_wrap_time + out_wrap_time))

146: , bix_util_pkg.get_hrmiss_frmt(SUM(in_talk_time + out_talk_time)
147: / DECODE(SUM(in_calls_handled + out_calls_handled),0,1,SUM(in_calls_handled + out_calls_handled)))
148: , bix_util_pkg.get_hrmiss_frmt(SUM(in_wrap_time + out_wrap_time)
149: /decode(SUM(in_calls_handled + out_calls_handled),0,1,SUM(in_calls_handled + out_calls_handled)))
150: , bix_util_pkg.get_hrmiss_frmt(sum(available_time + in_talk_time + out_talk_time + in_wrap_time + out_wrap_time))
151: , trunc(sum(available_time + in_talk_time + out_talk_time + in_wrap_time + out_wrap_time)/sum(login_time) * 100, 2)
152: ,sum(leads_created)
153: ,to_char(sum(leads_amount) * l_factor, v_format_mask)
154: ,sum(opportunities_won)

Line 185: , bix_util_pkg.get_hrmiss_frmt(SUM(login_time))

181: , l_index
182: , NULL
183: , v_group_name
184: , null
185: , bix_util_pkg.get_hrmiss_frmt(SUM(login_time))
186: , SUM(IN_CALLS_HANDLED + out_calls_handled)
187: , bix_util_pkg.get_hrmiss_frmt(SUM(in_talk_time + out_talk_time)
188: / DECODE(SUM(in_calls_handled + out_calls_handled),0,1,SUM(in_calls_handled + out_calls_handled)))
189: , bix_util_pkg.get_hrmiss_frmt(SUM(in_wrap_time + out_wrap_time)

Line 187: , bix_util_pkg.get_hrmiss_frmt(SUM(in_talk_time + out_talk_time)

183: , v_group_name
184: , null
185: , bix_util_pkg.get_hrmiss_frmt(SUM(login_time))
186: , SUM(IN_CALLS_HANDLED + out_calls_handled)
187: , bix_util_pkg.get_hrmiss_frmt(SUM(in_talk_time + out_talk_time)
188: / DECODE(SUM(in_calls_handled + out_calls_handled),0,1,SUM(in_calls_handled + out_calls_handled)))
189: , bix_util_pkg.get_hrmiss_frmt(SUM(in_wrap_time + out_wrap_time)
190: /decode(SUM(in_calls_handled + out_calls_handled),0,1,SUM(in_calls_handled + out_calls_handled)))
191: , bix_util_pkg.get_hrmiss_frmt(sum(available_time + in_talk_time + out_talk_time + in_wrap_time + out_wrap_time))

Line 189: , bix_util_pkg.get_hrmiss_frmt(SUM(in_wrap_time + out_wrap_time)

185: , bix_util_pkg.get_hrmiss_frmt(SUM(login_time))
186: , SUM(IN_CALLS_HANDLED + out_calls_handled)
187: , bix_util_pkg.get_hrmiss_frmt(SUM(in_talk_time + out_talk_time)
188: / DECODE(SUM(in_calls_handled + out_calls_handled),0,1,SUM(in_calls_handled + out_calls_handled)))
189: , bix_util_pkg.get_hrmiss_frmt(SUM(in_wrap_time + out_wrap_time)
190: /decode(SUM(in_calls_handled + out_calls_handled),0,1,SUM(in_calls_handled + out_calls_handled)))
191: , bix_util_pkg.get_hrmiss_frmt(sum(available_time + in_talk_time + out_talk_time + in_wrap_time + out_wrap_time))
192: , trunc(sum(available_time + in_talk_time + out_talk_time + in_wrap_time + out_wrap_time)/sum(login_time) * 100, 2)
193: ,sum(leads_created)

Line 191: , bix_util_pkg.get_hrmiss_frmt(sum(available_time + in_talk_time + out_talk_time + in_wrap_time + out_wrap_time))

187: , bix_util_pkg.get_hrmiss_frmt(SUM(in_talk_time + out_talk_time)
188: / DECODE(SUM(in_calls_handled + out_calls_handled),0,1,SUM(in_calls_handled + out_calls_handled)))
189: , bix_util_pkg.get_hrmiss_frmt(SUM(in_wrap_time + out_wrap_time)
190: /decode(SUM(in_calls_handled + out_calls_handled),0,1,SUM(in_calls_handled + out_calls_handled)))
191: , bix_util_pkg.get_hrmiss_frmt(sum(available_time + in_talk_time + out_talk_time + in_wrap_time + out_wrap_time))
192: , trunc(sum(available_time + in_talk_time + out_talk_time + in_wrap_time + out_wrap_time)/sum(login_time) * 100, 2)
193: ,sum(leads_created)
194: ,to_char(sum(leads_amount)* l_factor, v_format_mask)
195: ,sum(opportunities_won)

Line 227: , bix_util_pkg.get_hrmiss_frmt(SUM(login_time))

223: ,l_index
224: , null
225: , v_resource_name
226: , null
227: , bix_util_pkg.get_hrmiss_frmt(SUM(login_time))
228: , (SUM(IN_CALLS_HANDLED + out_calls_handled))
229: , bix_util_pkg.get_hrmiss_frmt(SUM(in_talk_time + out_talk_time)
230: / DECODE(SUM(in_calls_handled + out_calls_handled),0,1,SUM(in_calls_handled + out_calls_handled)))
231: , bix_util_pkg.get_hrmiss_frmt(SUM(in_wrap_time + out_wrap_time)/decode(SUM(in_calls_handled + out_calls_handled),0,1,SUM(in_calls_handled + out_calls_handled)))

Line 229: , bix_util_pkg.get_hrmiss_frmt(SUM(in_talk_time + out_talk_time)

225: , v_resource_name
226: , null
227: , bix_util_pkg.get_hrmiss_frmt(SUM(login_time))
228: , (SUM(IN_CALLS_HANDLED + out_calls_handled))
229: , bix_util_pkg.get_hrmiss_frmt(SUM(in_talk_time + out_talk_time)
230: / DECODE(SUM(in_calls_handled + out_calls_handled),0,1,SUM(in_calls_handled + out_calls_handled)))
231: , bix_util_pkg.get_hrmiss_frmt(SUM(in_wrap_time + out_wrap_time)/decode(SUM(in_calls_handled + out_calls_handled),0,1,SUM(in_calls_handled + out_calls_handled)))
232: , bix_util_pkg.get_hrmiss_frmt(sum(available_time + in_talk_time + out_talk_time + in_wrap_time + out_wrap_time))
233: , trunc(sum((available_time + in_talk_time + out_talk_time + in_wrap_time + out_wrap_time))/sum(login_time) * 100, 2),

Line 231: , bix_util_pkg.get_hrmiss_frmt(SUM(in_wrap_time + out_wrap_time)/decode(SUM(in_calls_handled + out_calls_handled),0,1,SUM(in_calls_handled + out_calls_handled)))

227: , bix_util_pkg.get_hrmiss_frmt(SUM(login_time))
228: , (SUM(IN_CALLS_HANDLED + out_calls_handled))
229: , bix_util_pkg.get_hrmiss_frmt(SUM(in_talk_time + out_talk_time)
230: / DECODE(SUM(in_calls_handled + out_calls_handled),0,1,SUM(in_calls_handled + out_calls_handled)))
231: , bix_util_pkg.get_hrmiss_frmt(SUM(in_wrap_time + out_wrap_time)/decode(SUM(in_calls_handled + out_calls_handled),0,1,SUM(in_calls_handled + out_calls_handled)))
232: , bix_util_pkg.get_hrmiss_frmt(sum(available_time + in_talk_time + out_talk_time + in_wrap_time + out_wrap_time))
233: , trunc(sum((available_time + in_talk_time + out_talk_time + in_wrap_time + out_wrap_time))/sum(login_time) * 100, 2),
234: sum(leads_created),
235: to_char(sum(leads_amount) * l_factor, v_format_mask),

Line 232: , bix_util_pkg.get_hrmiss_frmt(sum(available_time + in_talk_time + out_talk_time + in_wrap_time + out_wrap_time))

228: , (SUM(IN_CALLS_HANDLED + out_calls_handled))
229: , bix_util_pkg.get_hrmiss_frmt(SUM(in_talk_time + out_talk_time)
230: / DECODE(SUM(in_calls_handled + out_calls_handled),0,1,SUM(in_calls_handled + out_calls_handled)))
231: , bix_util_pkg.get_hrmiss_frmt(SUM(in_wrap_time + out_wrap_time)/decode(SUM(in_calls_handled + out_calls_handled),0,1,SUM(in_calls_handled + out_calls_handled)))
232: , bix_util_pkg.get_hrmiss_frmt(sum(available_time + in_talk_time + out_talk_time + in_wrap_time + out_wrap_time))
233: , trunc(sum((available_time + in_talk_time + out_talk_time + in_wrap_time + out_wrap_time))/sum(login_time) * 100, 2),
234: sum(leads_created),
235: to_char(sum(leads_amount) * l_factor, v_format_mask),
236: sum(opportunities_won),

Line 269: , bix_util_pkg.get_hrmiss_frmt(SUM(login_time))

265: , decode(g_time_range,1,period_start_time,
266: 2,substr(period_start_time,1,2),
267: 3,to_char(floor(substr(period_start_time,1,2) / 2) * 2),
268: 4,to_char(floor(substr(period_start_time,1,2) / 4) * 4),period_start_date)
269: , bix_util_pkg.get_hrmiss_frmt(SUM(login_time))
270: , (SUM(in_calls_handled + out_calls_handled))
271: , bix_util_pkg.get_hrmiss_frmt(SUM(in_talk_time + out_talk_time)/ DECODE(SUM(in_calls_handled + out_calls_handled),0,1,SUM(in_calls_handled + out_calls_handled)))
272: , bix_util_pkg.get_hrmiss_frmt(SUM(in_wrap_time + out_wrap_time)/decode(SUM(in_calls_handled + out_calls_handled),0,1,SUM(in_calls_handled + out_calls_handled)))
273: , bix_util_pkg.get_hrmiss_frmt(sum(available_time + in_talk_time + out_talk_time + in_wrap_time + out_wrap_time))

Line 271: , bix_util_pkg.get_hrmiss_frmt(SUM(in_talk_time + out_talk_time)/ DECODE(SUM(in_calls_handled + out_calls_handled),0,1,SUM(in_calls_handled + out_calls_handled)))

267: 3,to_char(floor(substr(period_start_time,1,2) / 2) * 2),
268: 4,to_char(floor(substr(period_start_time,1,2) / 4) * 4),period_start_date)
269: , bix_util_pkg.get_hrmiss_frmt(SUM(login_time))
270: , (SUM(in_calls_handled + out_calls_handled))
271: , bix_util_pkg.get_hrmiss_frmt(SUM(in_talk_time + out_talk_time)/ DECODE(SUM(in_calls_handled + out_calls_handled),0,1,SUM(in_calls_handled + out_calls_handled)))
272: , bix_util_pkg.get_hrmiss_frmt(SUM(in_wrap_time + out_wrap_time)/decode(SUM(in_calls_handled + out_calls_handled),0,1,SUM(in_calls_handled + out_calls_handled)))
273: , bix_util_pkg.get_hrmiss_frmt(sum(available_time + in_talk_time + out_talk_time + in_wrap_time + out_wrap_time))
274: , trunc(sum((available_time + in_talk_time + out_talk_time + in_wrap_time + out_wrap_time))/sum(login_time) * 100, 2),
275: sum(leads_created),

Line 272: , bix_util_pkg.get_hrmiss_frmt(SUM(in_wrap_time + out_wrap_time)/decode(SUM(in_calls_handled + out_calls_handled),0,1,SUM(in_calls_handled + out_calls_handled)))

268: 4,to_char(floor(substr(period_start_time,1,2) / 4) * 4),period_start_date)
269: , bix_util_pkg.get_hrmiss_frmt(SUM(login_time))
270: , (SUM(in_calls_handled + out_calls_handled))
271: , bix_util_pkg.get_hrmiss_frmt(SUM(in_talk_time + out_talk_time)/ DECODE(SUM(in_calls_handled + out_calls_handled),0,1,SUM(in_calls_handled + out_calls_handled)))
272: , bix_util_pkg.get_hrmiss_frmt(SUM(in_wrap_time + out_wrap_time)/decode(SUM(in_calls_handled + out_calls_handled),0,1,SUM(in_calls_handled + out_calls_handled)))
273: , bix_util_pkg.get_hrmiss_frmt(sum(available_time + in_talk_time + out_talk_time + in_wrap_time + out_wrap_time))
274: , trunc(sum((available_time + in_talk_time + out_talk_time + in_wrap_time + out_wrap_time))/sum(login_time) * 100, 2),
275: sum(leads_created),
276: to_char(sum(leads_amount) * l_factor, v_format_mask),

Line 273: , bix_util_pkg.get_hrmiss_frmt(sum(available_time + in_talk_time + out_talk_time + in_wrap_time + out_wrap_time))

269: , bix_util_pkg.get_hrmiss_frmt(SUM(login_time))
270: , (SUM(in_calls_handled + out_calls_handled))
271: , bix_util_pkg.get_hrmiss_frmt(SUM(in_talk_time + out_talk_time)/ DECODE(SUM(in_calls_handled + out_calls_handled),0,1,SUM(in_calls_handled + out_calls_handled)))
272: , bix_util_pkg.get_hrmiss_frmt(SUM(in_wrap_time + out_wrap_time)/decode(SUM(in_calls_handled + out_calls_handled),0,1,SUM(in_calls_handled + out_calls_handled)))
273: , bix_util_pkg.get_hrmiss_frmt(sum(available_time + in_talk_time + out_talk_time + in_wrap_time + out_wrap_time))
274: , trunc(sum((available_time + in_talk_time + out_talk_time + in_wrap_time + out_wrap_time))/sum(login_time) * 100, 2),
275: sum(leads_created),
276: to_char(sum(leads_amount) * l_factor, v_format_mask),
277: sum(opportunities_won),

Line 333: bix_util_pkg.get_time_range(v_time , v_start_period, v_end_period);

329: elsif (v_time = 8) then
330: v_start_period := sysdate - 1;
331: v_end_period := sysdate;
332: else
333: bix_util_pkg.get_time_range(v_time , v_start_period, v_end_period);
334: end if;
335: else
336: v_start_period := to_date(jtfb_dcf.get_parameter_value(p_context,'P_START_PERIOD'));
337: v_end_period := to_date(jtfb_dcf.get_parameter_value(p_context,'P_END_PERIOD'));