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 POA_DBI_UTIL_PKG

Line 261: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;

257: l_sqltext VARCHAR2(32000) ;
258: l_sqltext_cont VARCHAR2(32000) ;
259: l_where_clause VARCHAR2(1000) ;
260: l_mv VARCHAR2 (240);
261: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
262: l_col_tbl_cont poa_dbi_util_pkg.poa_dbi_col_tbl;
263: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
264: l_filter_where VARCHAR2 (2000);
265: l_func_area varchar2(5) := 'ICSTR';

Line 262: l_col_tbl_cont poa_dbi_util_pkg.poa_dbi_col_tbl;

258: l_sqltext_cont VARCHAR2(32000) ;
259: l_where_clause VARCHAR2(1000) ;
260: l_mv VARCHAR2 (240);
261: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
262: l_col_tbl_cont poa_dbi_util_pkg.poa_dbi_col_tbl;
263: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
264: l_filter_where VARCHAR2 (2000);
265: l_func_area varchar2(5) := 'ICSTR';
266: l_mv_set varchar2(3) := 'ITM';

Line 263: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

259: l_where_clause VARCHAR2(1000) ;
260: l_mv VARCHAR2 (240);
261: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
262: l_col_tbl_cont poa_dbi_util_pkg.poa_dbi_col_tbl;
263: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
264: l_filter_where VARCHAR2 (2000);
265: l_func_area varchar2(5) := 'ICSTR';
266: l_mv_set varchar2(3) := 'ITM';
267: l_version varchar2(3) := NULL;

Line 281: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();

277: p_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
278:
279: /* Trial for Util Package..*/
280:
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

Line 282: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl ();

278:
279: /* Trial for Util Package..*/
280:
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

Line 283: l_col_tbl_cont := poa_dbi_util_pkg.poa_dbi_col_tbl ();

279: /* Trial for Util Package..*/
280:
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'

Line 300: poa_dbi_util_pkg.add_column(p_col_tbl => l_col_tbl_cont

296: , p_view_by_select => l_view_by_select
297: , p_view_by => l_view_by
298: );
299: -- Populate col table with columns for continued measures
300: poa_dbi_util_pkg.add_column(p_col_tbl => l_col_tbl_cont
301: , p_col_name => 'NULL'
302: , p_grand_total => 'N'
303: , p_alias_name => 'a'
304: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

Line 304: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

300: poa_dbi_util_pkg.add_column(p_col_tbl => l_col_tbl_cont
301: , p_col_name => 'NULL'
302: , p_grand_total => 'N'
303: , p_alias_name => 'a'
304: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
305: , p_to_date_type => l_timetype
306: );
307: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont
308: , p_col_name => 'NULL'

Line 307: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont

303: , p_alias_name => 'a'
304: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
305: , p_to_date_type => l_timetype
306: );
307: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont
308: , p_col_name => 'NULL'
309: , p_grand_total => 'N'
310: , p_alias_name => 'b'
311: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

Line 311: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

307: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont
308: , p_col_name => 'NULL'
309: , p_grand_total => 'N'
310: , p_alias_name => 'b'
311: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
312: , p_to_date_type => l_timetype
313: );
314: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont
315: , p_col_name => '(CASE WHEN media_item_type in (''TELE_INB'',''TELE_DIRECT'') THEN call_cont_calls_offered_na END)'

Line 314: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont

310: , p_alias_name => 'b'
311: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
312: , p_to_date_type => l_timetype
313: );
314: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont
315: , p_col_name => '(CASE WHEN media_item_type in (''TELE_INB'',''TELE_DIRECT'') THEN call_cont_calls_offered_na END)'
316: , p_grand_total => 'N'
317: , p_alias_name => 'c'
318: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

Line 318: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

314: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont
315: , p_col_name => '(CASE WHEN media_item_type in (''TELE_INB'',''TELE_DIRECT'') THEN call_cont_calls_offered_na END)'
316: , p_grand_total => 'N'
317: , p_alias_name => 'c'
318: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
319: , p_to_date_type => l_timetype
320: );
321: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont
322: , p_col_name => 'NULL'

Line 321: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont

317: , p_alias_name => 'c'
318: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
319: , p_to_date_type => l_timetype
320: );
321: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont
322: , p_col_name => 'NULL'
323: , p_grand_total => 'N'
324: , p_alias_name => 'd'
325: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

Line 325: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

321: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont
322: , p_col_name => 'NULL'
323: , p_grand_total => 'N'
324: , p_alias_name => 'd'
325: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
326: , p_to_date_type => l_timetype
327: );
328: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont
329: , p_col_name => '(CASE WHEN media_item_type in (''TELE_INB'',''TELE_DIRECT'') THEN call_cont_calls_handled_tot_na END)'

Line 328: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont

324: , p_alias_name => 'd'
325: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
326: , p_to_date_type => l_timetype
327: );
328: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont
329: , p_col_name => '(CASE WHEN media_item_type in (''TELE_INB'',''TELE_DIRECT'') THEN call_cont_calls_handled_tot_na END)'
330: , p_grand_total => 'N'
331: , p_alias_name => 'e'
332: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

Line 332: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

328: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont
329: , p_col_name => '(CASE WHEN media_item_type in (''TELE_INB'',''TELE_DIRECT'') THEN call_cont_calls_handled_tot_na END)'
330: , p_grand_total => 'N'
331: , p_alias_name => 'e'
332: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
333: , p_to_date_type => l_timetype
334: );
335: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont
336: , p_col_name => 'call_cont_calls_handled_tot_na'

Line 335: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont

331: , p_alias_name => 'e'
332: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
333: , p_to_date_type => l_timetype
334: );
335: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont
336: , p_col_name => 'call_cont_calls_handled_tot_na'
337: , p_grand_total => 'N'
338: , p_alias_name => 'f'
339: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

Line 339: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

335: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont
336: , p_col_name => 'call_cont_calls_handled_tot_na'
337: , p_grand_total => 'N'
338: , p_alias_name => 'f'
339: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
340: , p_to_date_type => l_timetype
341: );
342: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont
343: , p_col_name => 'NULL'

Line 342: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont

338: , p_alias_name => 'f'
339: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
340: , p_to_date_type => l_timetype
341: );
342: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont
343: , p_col_name => 'NULL'
344: , p_grand_total => 'N'
345: , p_alias_name => 'g'
346: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

Line 346: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

342: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont
343: , p_col_name => 'NULL'
344: , p_grand_total => 'N'
345: , p_alias_name => 'g'
346: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
347: , p_to_date_type => l_timetype
348: );
349: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont
350: , p_col_name => 'NULL'

Line 349: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont

345: , p_alias_name => 'g'
346: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
347: , p_to_date_type => l_timetype
348: );
349: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont
350: , p_col_name => 'NULL'
351: , p_grand_total => 'N'
352: , p_alias_name => 'h'
353: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

Line 353: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

349: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont
350: , p_col_name => 'NULL'
351: , p_grand_total => 'N'
352: , p_alias_name => 'h'
353: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
354: , p_to_date_type => l_timetype
355: );
356: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont
357: , p_col_name => 'NULL'

Line 356: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont

352: , p_alias_name => 'h'
353: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
354: , p_to_date_type => l_timetype
355: );
356: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont
357: , p_col_name => 'NULL'
358: , p_grand_total => 'N'
359: , p_alias_name => 'i'
360: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

Line 360: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

356: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont
357: , p_col_name => 'NULL'
358: , p_grand_total => 'N'
359: , p_alias_name => 'i'
360: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
361: , p_to_date_type => l_timetype
362: );
363: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont
364: , p_col_name => 'NULL'

Line 363: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont

359: , p_alias_name => 'i'
360: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
361: , p_to_date_type => l_timetype
362: );
363: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont
364: , p_col_name => 'NULL'
365: , p_grand_total => 'N'
366: , p_alias_name => 'j'
367: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

Line 367: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

363: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont
364: , p_col_name => 'NULL'
365: , p_grand_total => 'N'
366: , p_alias_name => 'j'
367: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
368: , p_to_date_type => l_timetype
369: );
370: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont
371: , p_col_name => 'NULL'

Line 370: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont

366: , p_alias_name => 'j'
367: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
368: , p_to_date_type => l_timetype
369: );
370: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont
371: , p_col_name => 'NULL'
372: , p_grand_total => 'N'
373: , p_alias_name => 'n'
374: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

Line 374: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

370: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont
371: , p_col_name => 'NULL'
372: , p_grand_total => 'N'
373: , p_alias_name => 'n'
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 (

Line 388: poa_dbi_util_pkg.add_column(p_col_tbl => l_col_tbl

384: , p_union => 'ALL');
385:
386: -- Populate col table with regular columns
387:
388: poa_dbi_util_pkg.add_column(p_col_tbl => l_col_tbl
389: , p_col_name => '(CASE WHEN media_item_type in (''TELE_INB'',''TELE_DIRECT'') THEN agent_calls_answered_by_goal END)'
390: , p_grand_total => 'N'
391: , p_alias_name => 'a'
392: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

Line 392: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

388: poa_dbi_util_pkg.add_column(p_col_tbl => l_col_tbl
389: , p_col_name => '(CASE WHEN media_item_type in (''TELE_INB'',''TELE_DIRECT'') THEN agent_calls_answered_by_goal END)'
390: , p_grand_total => 'N'
391: , p_alias_name => 'a'
392: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
393: , p_to_date_type => l_timetype
394: );
395: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
396: , p_col_name => '(CASE WHEN media_item_type in (''TELE_INB'',''TELE_DIRECT'') THEN call_tot_queue_to_answer END)'

Line 395: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl

391: , p_alias_name => 'a'
392: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
393: , p_to_date_type => l_timetype
394: );
395: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
396: , p_col_name => '(CASE WHEN media_item_type in (''TELE_INB'',''TELE_DIRECT'') THEN call_tot_queue_to_answer END)'
397: , p_grand_total => 'N'
398: , p_alias_name => 'b'
399: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

Line 399: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

395: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
396: , p_col_name => '(CASE WHEN media_item_type in (''TELE_INB'',''TELE_DIRECT'') THEN call_tot_queue_to_answer END)'
397: , p_grand_total => 'N'
398: , p_alias_name => 'b'
399: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
400: , p_to_date_type => l_timetype
401: );
402: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
403: , p_col_name => '(CASE WHEN media_item_type in (''TELE_INB'',''TELE_DIRECT'') THEN call_calls_offered_total END)'

Line 402: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl

398: , p_alias_name => 'b'
399: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
400: , p_to_date_type => l_timetype
401: );
402: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
403: , p_col_name => '(CASE WHEN media_item_type in (''TELE_INB'',''TELE_DIRECT'') THEN call_calls_offered_total END)'
404: , p_grand_total => 'N'
405: , p_alias_name => 'c'
406: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

Line 406: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

402: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
403: , p_col_name => '(CASE WHEN media_item_type in (''TELE_INB'',''TELE_DIRECT'') THEN call_calls_offered_total END)'
404: , p_grand_total => 'N'
405: , p_alias_name => 'c'
406: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
407: , p_to_date_type => l_timetype
408: );
409: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
410: , p_col_name => '(CASE WHEN media_item_type in (''TELE_INB'',''TELE_DIRECT'') THEN call_calls_transferred END)'

Line 409: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl

405: , p_alias_name => 'c'
406: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
407: , p_to_date_type => l_timetype
408: );
409: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
410: , p_col_name => '(CASE WHEN media_item_type in (''TELE_INB'',''TELE_DIRECT'') THEN call_calls_transferred END)'
411: , p_grand_total => 'N'
412: , p_alias_name => 'd'
413: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

Line 413: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

409: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
410: , p_col_name => '(CASE WHEN media_item_type in (''TELE_INB'',''TELE_DIRECT'') THEN call_calls_transferred END)'
411: , p_grand_total => 'N'
412: , p_alias_name => 'd'
413: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
414: , p_to_date_type => l_timetype
415: );
416: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
417: , p_col_name => '(CASE WHEN media_item_type in (''TELE_INB'',''TELE_DIRECT'') THEN call_calls_handled_total END)'

Line 416: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl

412: , p_alias_name => 'd'
413: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
414: , p_to_date_type => l_timetype
415: );
416: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
417: , p_col_name => '(CASE WHEN media_item_type in (''TELE_INB'',''TELE_DIRECT'') THEN call_calls_handled_total END)'
418: , p_grand_total => 'N'
419: , p_alias_name => 'e'
420: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

Line 420: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

416: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
417: , p_col_name => '(CASE WHEN media_item_type in (''TELE_INB'',''TELE_DIRECT'') THEN call_calls_handled_total END)'
418: , p_grand_total => 'N'
419: , p_alias_name => 'e'
420: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
421: , p_to_date_type => l_timetype
422: );
423: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
424: , p_col_name => 'call_calls_handled_total'

Line 423: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl

419: , p_alias_name => 'e'
420: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
421: , p_to_date_type => l_timetype
422: );
423: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
424: , p_col_name => 'call_calls_handled_total'
425: , p_grand_total => 'N'
426: , p_alias_name => 'f'
427: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

Line 427: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

423: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
424: , p_col_name => 'call_calls_handled_total'
425: , p_grand_total => 'N'
426: , p_alias_name => 'f'
427: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
428: , p_to_date_type => l_timetype
429: );
430: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
431: , p_col_name => 'agent_wrap_time_nac'

Line 430: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl

426: , p_alias_name => 'f'
427: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
428: , p_to_date_type => l_timetype
429: );
430: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
431: , p_col_name => 'agent_wrap_time_nac'
432: , p_grand_total => 'N'
433: , p_alias_name => 'g'
434: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

Line 434: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

430: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
431: , p_col_name => 'agent_wrap_time_nac'
432: , p_grand_total => 'N'
433: , p_alias_name => 'g'
434: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
435: , p_to_date_type => l_timetype
436: );
437: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
438: , p_col_name => 'call_talk_time'

Line 437: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl

433: , p_alias_name => 'g'
434: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
435: , p_to_date_type => l_timetype
436: );
437: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
438: , p_col_name => 'call_talk_time'
439: , p_grand_total => 'N'
440: , p_alias_name => 'h'
441: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

Line 441: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

437: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
438: , p_col_name => 'call_talk_time'
439: , p_grand_total => 'N'
440: , p_alias_name => 'h'
441: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
442: , p_to_date_type => l_timetype
443: );
444: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
445: , p_col_name => 'agent_sr_created'

Line 444: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl

440: , p_alias_name => 'h'
441: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
442: , p_to_date_type => l_timetype
443: );
444: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
445: , p_col_name => 'agent_sr_created'
446: , p_grand_total => 'N'
447: , p_alias_name => 'i'
448: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

Line 448: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

444: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
445: , p_col_name => 'agent_sr_created'
446: , p_grand_total => 'N'
447: , p_alias_name => 'i'
448: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
449: , p_to_date_type => l_timetype
450: );
451: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
452: , p_col_name => 'agent_leads_created'

Line 451: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl

447: , p_alias_name => 'i'
448: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
449: , p_to_date_type => l_timetype
450: );
451: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
452: , p_col_name => 'agent_leads_created'
453: , p_grand_total => 'N'
454: , p_alias_name => 'j'
455: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

Line 455: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

451: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
452: , p_col_name => 'agent_leads_created'
453: , p_grand_total => 'N'
454: , p_alias_name => 'j'
455: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
456: , p_to_date_type => l_timetype
457: );
458: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
459: , p_col_name => 'agent_opportunities_created'

Line 458: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl

454: , p_alias_name => 'j'
455: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
456: , p_to_date_type => l_timetype
457: );
458: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
459: , p_col_name => 'agent_opportunities_created'
460: , p_grand_total => 'N'
461: , p_alias_name => 'n'
462: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

Line 462: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

458: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
459: , p_col_name => 'agent_opportunities_created'
460: , p_grand_total => 'N'
461: , p_alias_name => 'n'
462: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
463: , p_to_date_type => l_timetype
464: );
465:
466: l_sqltext :='select * from ('||