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_UWQ_TEMP_PKG dependencies on BIX_DM_REPORT

Line 267: --This procedure populates the BIX_DM_REPORT table for the UWQ logins report.

263: END POPULATE_BIN;
264:
265: PROCEDURE POPULATE_LOGINS_REPORT(p_context IN VARCHAR2 DEFAULT NULL)
266: --
267: --This procedure populates the BIX_DM_REPORT table for the UWQ logins report.
268: --
269: IS
270:
271: BEGIN

Line 279: delete from bix_dm_report

275:
276: --
277: --Delete the records from the previous run of the report.
278: --
279: delete from bix_dm_report
280: where report_code = 'BIX_UWQ_LOGINS_RPT'
281: and session_id = v_session_id;
282:
283: commit;

Line 294: INSERT INTO bix_dm_report (report_code, col2, col4,

290: --
291: --Display only that agent's information. There will be no further drill downs.
292: --
293:
294: INSERT INTO bix_dm_report (report_code, col2, col4,
295: col6, col8, col10, col12, col14, col16,
296: col18, col20, col22, col24, col26, session_id)
297: SELECT 'BIX_UWQ_LOGINS_RPT', res.source_name, '',
298: DAY6_LOGIN, DAY5_LOGIN, DAY4_LOGIN, DAY3_LOGIN, DAY2_LOGIN, DAY1_LOGIN,

Line 312: INSERT INTO bix_dm_report (report_code, col2, col4,

308:
309: --
310: --Total row
311: --
312: INSERT INTO bix_dm_report (report_code, col2, col4,
313: col6, col8, col10, col12, col14, col16,
314: col18, col20, col22, col24, col26, session_id)
315: SELECT 'BIX_UWQ_LOGINS_RPT', vl.group_name, '',
316: DAY6_LOGIN, DAY5_LOGIN, DAY4_LOGIN, DAY3_LOGIN, DAY2_LOGIN, DAY1_LOGIN,

Line 327: INSERT INTO bix_dm_report (report_code, col2, col3, col4,

323:
324: --
325: --Sub group details for immediate child groups of the default group.
326: --
327: INSERT INTO bix_dm_report (report_code, col2, col3, col4,
328: col6, col8, col10, col12, col14, col16,
329: col18, col20, col22, col24, col26, session_id)
330: SELECT 'BIX_UWQ_LOGINS_RPT', '', 'G'||to_char(v_date,'DD-MON-YYYY')||summ.group_id, vl.group_name,
331: DAY6_LOGIN, DAY5_LOGIN, DAY4_LOGIN, DAY3_LOGIN, DAY2_LOGIN, DAY1_LOGIN,

Line 347: INSERT INTO bix_dm_report (report_code, col2, col3, col4,

343:
344: --
345: --Agents directly associated with the group
346: --
347: INSERT INTO bix_dm_report (report_code, col2, col3, col4,
348: col6, col8, col10, col12, col14, col16,
349: col18, col20, col22, col24, col26, session_id)
350: SELECT 'BIX_UWQ_LOGINS_RPT', '', 'A'||to_char(v_date,'DD-MON-YYYY')||summ.resource_id, res.source_name,
351: DAY6_LOGIN, DAY5_LOGIN, DAY4_LOGIN, DAY3_LOGIN, DAY2_LOGIN, DAY1_LOGIN,

Line 376: INSERT INTO bix_dm_report (report_code, col2, col4,

372:
373: --
374: --Total row
375: --
376: INSERT INTO bix_dm_report (report_code, col2, col4,
377: col6, col8, col10, col12, col14, col16,
378: col18, col20, col22, col24, col26, session_id)
379: SELECT 'BIX_UWQ_LOGINS_RPT', vl.group_name, '',
380: DAY6_LOGIN, DAY5_LOGIN, DAY4_LOGIN, DAY3_LOGIN, DAY2_LOGIN, DAY1_LOGIN,

Line 391: INSERT INTO bix_dm_report (report_code, col2, col3, col4,

387:
388: --
389: --Sub group details for immediate child groups of the default group.
390: --
391: INSERT INTO bix_dm_report (report_code, col2, col3, col4,
392: col6, col8, col10, col12, col14, col16,
393: col18, col20, col22, col24, col26, session_id)
394: SELECT 'BIX_UWQ_LOGINS_RPT', '', 'G'||to_char(v_date,'DD-MON-YYYY')||summ.group_id, vl.group_name,
395: DAY6_LOGIN, DAY5_LOGIN, DAY4_LOGIN, DAY3_LOGIN, DAY2_LOGIN, DAY1_LOGIN,

Line 411: INSERT INTO bix_dm_report (report_code, col2, col3, col4,

407:
408: --
409: --Agents directly associated with the default group
410: --
411: INSERT INTO bix_dm_report (report_code, col2, col3, col4,
412: col6, col8, col10, col12, col14, col16,
413: col18, col20, col22, col24, col26, session_id)
414: SELECT 'BIX_UWQ_LOGINS_RPT', '', 'A'||to_char(v_date,'DD-MON-YYYY')||summ.resource_id, res.source_name,
415: DAY6_LOGIN, DAY5_LOGIN, DAY4_LOGIN, DAY3_LOGIN, DAY2_LOGIN, DAY1_LOGIN,

Line 445: --This procedure populates the BIX_DM_REPORT table for the UWQ durations report.

441: END populate_logins_report;
442:
443: PROCEDURE POPULATE_DURATIONS_REPORT(p_context IN VARCHAR2 DEFAULT NULL)
444: --
445: --This procedure populates the BIX_DM_REPORT table for the UWQ durations report.
446: --
447: IS
448:
449: BEGIN

Line 457: delete from bix_dm_report

453:
454: --
455: --Delete old rows from the previous run of the report.
456: --
457: delete from bix_dm_report
458: where report_code = 'BIX_UWQ_DURATIONS_RPT'
459: and session_id = v_session_id;
460:
461: commit;

Line 471: INSERT INTO bix_dm_report (report_code, col2, col4,

467:
468: --
469: --Display only that agent's information. There will be no further drill downs.
470: --
471: INSERT INTO bix_dm_report (report_code, col2, col4,
472: col6, col8, col10, col12, col14, col16,
473: col18, col20, col22, col24, col26, session_id)
474: SELECT 'BIX_UWQ_DURATIONS_RPT', res.source_name, '',
475: bix_util_pkg.get_hrmi_frmt( decode(DAY6_LOGIN,0,0,round(DAY6_DURATION/DAY6_LOGIN)) ),

Line 499: INSERT INTO bix_dm_report (report_code, col2, col4,

495:
496: --
497: --Total row
498: --
499: INSERT INTO bix_dm_report (report_code, col2, col4,
500: col6, col8, col10, col12, col14, col16,
501: col18, col20, col22, col24, col26, session_id)
502: SELECT 'BIX_UWQ_DURATIONS_RPT', vl.group_name, '',
503: bix_util_pkg.get_hrmi_frmt( decode(DAY6_LOGIN,0,0,round(DAY6_DURATION/DAY6_LOGIN)) ),

Line 523: INSERT INTO bix_dm_report (report_code, col2, col3, col4,

519:
520: --
521: --Sub groups
522: --
523: INSERT INTO bix_dm_report (report_code, col2, col3, col4,
524: col6, col8, col10, col12, col14, col16,
525: col18, col20, col22, col24, col26, session_id)
526: SELECT 'BIX_UWQ_DURATIONS_RPT', '', 'G'||to_char(v_date,'DD-MON-YYYY')||summ.group_id, vl.group_name,
527: bix_util_pkg.get_hrmi_frmt( decode(DAY6_LOGIN,0,0,round(DAY6_DURATION/DAY6_LOGIN)) ),

Line 552: INSERT INTO bix_dm_report (report_code, col2, col3, col4,

548:
549: --
550: --Agents directly associated with the group
551: --
552: INSERT INTO bix_dm_report (report_code, col2, col3, col4,
553: col6, col8, col10, col12, col14, col16,
554: col18, col20, col22, col24, col26, session_id)
555: SELECT 'BIX_UWQ_DURATIONS_RPT', '', 'A'||to_char(v_date,'DD-MON-YYYY')||summ.resource_id, res.source_name,
556: bix_util_pkg.get_hrmi_frmt( decode(DAY6_LOGIN,0,0,round(DAY6_DURATION/DAY6_LOGIN)) ),

Line 590: INSERT INTO bix_dm_report (report_code, col2, col4,

586:
587: --
588: --Total row
589: --
590: INSERT INTO bix_dm_report (report_code, col2, col4,
591: col6, col8, col10, col12, col14, col16,
592: col18, col20, col22, col24, col26, session_id)
593: SELECT 'BIX_UWQ_DURATIONS_RPT', vl.group_name, '',
594: bix_util_pkg.get_hrmi_frmt( decode(DAY6_LOGIN,0,0,round(DAY6_DURATION/DAY6_LOGIN)) ),

Line 614: INSERT INTO bix_dm_report (report_code, col2, col3, col4,

610:
611: --
612: --Sub groups
613: --
614: INSERT INTO bix_dm_report (report_code, col2, col3, col4,
615: col6, col8, col10, col12, col14, col16,
616: col18, col20, col22, col24, col26, session_id)
617: SELECT 'BIX_UWQ_DURATIONS_RPT', '', 'G'||to_char(v_date,'DD-MON-YYYY')||summ.group_id, vl.group_name,
618: bix_util_pkg.get_hrmi_frmt( decode(DAY6_LOGIN,0,0,round(DAY6_DURATION/DAY6_LOGIN)) ),

Line 643: INSERT INTO bix_dm_report (report_code, col2, col3, col4,

639:
640: --
641: --Agents directly associated with default group.
642: --
643: INSERT INTO bix_dm_report (report_code, col2, col3, col4,
644: col6, col8, col10, col12, col14, col16,
645: col18, col20, col22, col24, col26, session_id)
646: SELECT 'BIX_UWQ_DURATIONS_RPT', '', 'A'||to_char(v_date,'DD-MON-YYYY')||summ.resource_id, res.source_name,
647: bix_util_pkg.get_hrmi_frmt( decode(DAY6_LOGIN,0,0,round(DAY6_DURATION/DAY6_LOGIN)) ),