DBA Data[Home] [Help]

APPS.ISC_EDW_BACKLOG_SUM1_F_C dependencies on FII_UTIL

Line 437: FII_UTIL.Put_Timestamp;

433: END IF;
434: EDW_LOG.Put_Names('ISC_EDW_BACKLOG_SUM1_F.log','ISC_EDW_BACKLOG_SUM1_F.out',l_dir);
435:
436:
437: FII_UTIL.Put_Timestamp;
438: EDW_LOG.Put_Line('');
439: EDW_LOG.Put_Line('Initialization');
440:
441: FII_UTIL.Start_Timer;

Line 441: FII_UTIL.Start_Timer;

437: FII_UTIL.Put_Timestamp;
438: EDW_LOG.Put_Line('');
439: EDW_LOG.Put_Line('Initialization');
440:
441: FII_UTIL.Start_Timer;
442:
443: Init;
444:
445: FII_UTIL.Stop_Timer;

Line 445: FII_UTIL.Stop_Timer;

441: FII_UTIL.Start_Timer;
442:
443: Init;
444:
445: FII_UTIL.Stop_Timer;
446: FII_UTIL.Print_Timer('Duration');
447:
448: EDW_LOG.Put_Line('');
449: EDW_LOG.Put_Line('Dropping the Intermediary Summary Table');

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

442:
443: Init;
444:
445: FII_UTIL.Stop_Timer;
446: FII_UTIL.Print_Timer('Duration');
447:
448: EDW_LOG.Put_Line('');
449: EDW_LOG.Put_Line('Dropping the Intermediary Summary Table');
450: FII_UTIL.Start_Timer;

Line 450: FII_UTIL.Start_Timer;

446: FII_UTIL.Print_Timer('Duration');
447:
448: EDW_LOG.Put_Line('');
449: EDW_LOG.Put_Line('Dropping the Intermediary Summary Table');
450: FII_UTIL.Start_Timer;
451:
452: Drop_Table('ISC_EDW_BACK_SUM1_SUMM');
453:
454: FII_UTIL.Stop_Timer;

Line 454: FII_UTIL.Stop_Timer;

450: FII_UTIL.Start_Timer;
451:
452: Drop_Table('ISC_EDW_BACK_SUM1_SUMM');
453:
454: FII_UTIL.Stop_Timer;
455: FII_UTIL.Print_Timer('Duration');
456:
457: EDW_LOG.Put_Line('');
458: EDW_LOG.Put_Line('Truncating the Summary Table');

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

451:
452: Drop_Table('ISC_EDW_BACK_SUM1_SUMM');
453:
454: FII_UTIL.Stop_Timer;
455: FII_UTIL.Print_Timer('Duration');
456:
457: EDW_LOG.Put_Line('');
458: EDW_LOG.Put_Line('Truncating the Summary Table');
459: FII_UTIL.Start_Timer;

Line 459: FII_UTIL.Start_Timer;

455: FII_UTIL.Print_Timer('Duration');
456:
457: EDW_LOG.Put_Line('');
458: EDW_LOG.Put_Line('Truncating the Summary Table');
459: FII_UTIL.Start_Timer;
460:
461: Truncate_Table('ISC_EDW_BACKLOG_SUM1_F');
462:
463: FII_UTIL.Stop_Timer;

Line 463: FII_UTIL.Stop_Timer;

459: FII_UTIL.Start_Timer;
460:
461: Truncate_Table('ISC_EDW_BACKLOG_SUM1_F');
462:
463: FII_UTIL.Stop_Timer;
464: FII_UTIL.Print_Timer('Duration');
465:
466:
467: EDW_LOG.Put_Line('');

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

460:
461: Truncate_Table('ISC_EDW_BACKLOG_SUM1_F');
462:
463: FII_UTIL.Stop_Timer;
464: FII_UTIL.Print_Timer('Duration');
465:
466:
467: EDW_LOG.Put_Line('');
468: EDW_LOG.Put_Line('Extracting Backlog information from all the source instances ');

Line 469: FII_UTIL.Start_Timer;

465:
466:
467: EDW_LOG.Put_Line('');
468: EDW_LOG.Put_Line('Extracting Backlog information from all the source instances ');
469: FII_UTIL.Start_Timer;
470:
471: Collect_Backlog;
472:
473: FII_UTIL.Stop_Timer;

Line 473: FII_UTIL.Stop_Timer;

469: FII_UTIL.Start_Timer;
470:
471: Collect_Backlog;
472:
473: FII_UTIL.Stop_Timer;
474: FII_UTIL.Print_Timer('Duration');
475:
476: EDW_LOG.Put_Line('');
477: EDW_LOG.Put_Line('Populate the Backlog Summary Table ');

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

470:
471: Collect_Backlog;
472:
473: FII_UTIL.Stop_Timer;
474: FII_UTIL.Print_Timer('Duration');
475:
476: EDW_LOG.Put_Line('');
477: EDW_LOG.Put_Line('Populate the Backlog Summary Table ');
478: FII_UTIL.Start_Timer;

Line 478: FII_UTIL.Start_Timer;

474: FII_UTIL.Print_Timer('Duration');
475:
476: EDW_LOG.Put_Line('');
477: EDW_LOG.Put_Line('Populate the Backlog Summary Table ');
478: FII_UTIL.Start_Timer;
479:
480: Populate_Backlog_Summary;
481:
482: FII_UTIL.Stop_Timer;

Line 482: FII_UTIL.Stop_Timer;

478: FII_UTIL.Start_Timer;
479:
480: Populate_Backlog_Summary;
481:
482: FII_UTIL.Stop_Timer;
483: FII_UTIL.Print_Timer('Duration');
484:
485:
486: EXCEPTION

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

479:
480: Populate_Backlog_Summary;
481:
482: FII_UTIL.Stop_Timer;
483: FII_UTIL.Print_Timer('Duration');
484:
485:
486: EXCEPTION
487: