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.ISC_EDW_BOOK_SUM1_F_C dependencies on FII_UTIL

Line 543: FII_UTIL.Start_Timer;

539: -- --------------------------------------------
540:
541: EDW_LOG.Put_Line('Identifying changed Booked orders lines');
542:
543: FII_UTIL.Start_Timer;
544:
545: l_seq_id_line := IDENTIFY_CHANGE(l_row_count);
546:
547: FII_UTIL.Stop_Timer;

Line 547: FII_UTIL.Stop_Timer;

543: FII_UTIL.Start_Timer;
544:
545: l_seq_id_line := IDENTIFY_CHANGE(l_row_count);
546:
547: FII_UTIL.Stop_Timer;
548: FII_UTIL.Print_Timer('Identified '||l_row_count||' changed records in');
549:
550: IF (l_seq_id_line = -1)
551: THEN

Line 548: FII_UTIL.Print_Timer('Identified '||l_row_count||' changed records in');

544:
545: l_seq_id_line := IDENTIFY_CHANGE(l_row_count);
546:
547: FII_UTIL.Stop_Timer;
548: FII_UTIL.Print_Timer('Identified '||l_row_count||' changed records in');
549:
550: IF (l_seq_id_line = -1)
551: THEN
552: RAISE l_iden_change_failure;

Line 563: FII_UTIL.Start_Timer;

559:
560: EDW_LOG.Put_Line(' ');
561: EDW_LOG.Put_Line('Pushing data to local staging');
562:
563: FII_UTIL.Start_Timer;
564:
565: g_row_count := PUSH_TO_LOCAL(l_seq_id_line);
566:
567: FII_UTIL.Stop_Timer;

Line 567: FII_UTIL.Stop_Timer;

563: FII_UTIL.Start_Timer;
564:
565: g_row_count := PUSH_TO_LOCAL(l_seq_id_line);
566:
567: FII_UTIL.Stop_Timer;
568: FII_UTIL.Print_Timer('Process Time');
569:
570: IF (g_row_count = -1)
571: THEN RAISE L_push_local_failure;

Line 568: FII_UTIL.Print_Timer('Process Time');

564:
565: g_row_count := PUSH_TO_LOCAL(l_seq_id_line);
566:
567: FII_UTIL.Stop_Timer;
568: FII_UTIL.Print_Timer('Process Time');
569:
570: IF (g_row_count = -1)
571: THEN RAISE L_push_local_failure;
572: END IF;

Line 599: FII_UTIL.Start_Timer;

595:
596: EDW_LOG.Put_Line(' ');
597: EDW_LOG.Put_Line('Moving data from local staging table to remote staging table');
598:
599: FII_UTIL.Start_Timer;
600:
601: g_row_count := PUSH_REMOTE;
602:
603: FII_UTIL.Stop_Timer;

Line 603: FII_UTIL.Stop_Timer;

599: FII_UTIL.Start_Timer;
600:
601: g_row_count := PUSH_REMOTE;
602:
603: FII_UTIL.Stop_Timer;
604: FII_UTIL.Print_Timer('Duration');
605:
606: IF (g_row_count = -1) THEN RAISE l_push_remote_failure; END IF;
607:

Line 604: FII_UTIL.Print_Timer('Duration');

600:
601: g_row_count := PUSH_REMOTE;
602:
603: FII_UTIL.Stop_Timer;
604: FII_UTIL.Print_Timer('Duration');
605:
606: IF (g_row_count = -1) THEN RAISE l_push_remote_failure; END IF;
607:
608: EDW_LOG.Put_Line(' ');

Line 611: FII_UTIL.Start_Timer;

607:
608: EDW_LOG.Put_Line(' ');
609: EDW_LOG.Put_Line('Cleaning local staging table');
610:
611: FII_UTIL.Start_Timer;
612:
613: TRUNCATE_STG;
614:
615: FII_UTIL.Stop_Timer;

Line 615: FII_UTIL.Stop_Timer;

611: FII_UTIL.Start_Timer;
612:
613: TRUNCATE_STG;
614:
615: FII_UTIL.Stop_Timer;
616: FII_UTIL.Print_Timer('Duration');
617:
618: ELSE
619: -- -----------------------------------------------

Line 616: FII_UTIL.Print_Timer('Duration');

612:
613: TRUNCATE_STG;
614:
615: FII_UTIL.Stop_Timer;
616: FII_UTIL.Print_Timer('Duration');
617:
618: ELSE
619: -- -----------------------------------------------
620: -- The target warehouse is the same database

Line 628: FII_UTIL.Start_Timer;

624:
625: EDW_LOG.Put_Line(' ');
626: EDW_LOG.Put_Line('Marking records in staging table with READY status');
627:
628: FII_UTIL.Start_Timer;
629:
630: g_row_count := SET_STATUS_READY;
631:
632: FII_UTIL.Stop_Timer;

Line 632: FII_UTIL.Stop_Timer;

628: FII_UTIL.Start_Timer;
629:
630: g_row_count := SET_STATUS_READY;
631:
632: FII_UTIL.Stop_Timer;
633: FII_UTIL.Print_Timer('Duration');
634:
635: IF (g_row_count = -1)
636: THEN RAISE l_set_status_failure;

Line 633: FII_UTIL.Print_Timer('Duration');

629:
630: g_row_count := SET_STATUS_READY;
631:
632: FII_UTIL.Stop_Timer;
633: FII_UTIL.Print_Timer('Duration');
634:
635: IF (g_row_count = -1)
636: THEN RAISE l_set_status_failure;
637: END IF;