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

Line 246: fii_util.start_timer;

242: /* Pushing Day */
243: begin
244: edw_log.put_line(' ');
245: edw_log.put_line('Pushing Day and Calendar Day');
246: fii_util.start_timer;
247: loop
248: insert into edw_time_day_lstg
249: (day_pk,
250: half_month_fk,

Line 356: fii_util.stop_timer;

352: exit;
353: end if;
354: end loop;
355: commit;
356: fii_util.stop_timer;
357: fii_util.print_timer('Process Time');
358: edw_log.put_line(' ');
359: end;
360:

Line 357: fii_util.print_timer('Process Time');

353: end if;
354: end loop;
355: commit;
356: fii_util.stop_timer;
357: fii_util.print_timer('Process Time');
358: edw_log.put_line(' ');
359: end;
360:
361: /* Pushing Month */

Line 364: fii_util.start_timer;

360:
361: /* Pushing Month */
362: begin
363: edw_log.put_line('Pushing Month and Month level push down');
364: fii_util.start_timer;
365: loop
366: l_mon_quarter_date:=trunc(l_mon_month_start_date,'Q');
367:
368: insert into edw_time_month_lstg

Line 505: fii_util.stop_timer;

501: exit;
502: end if;
503: end loop;
504: commit;
505: fii_util.stop_timer;
506: fii_util.print_timer('Process Time');
507: edw_log.put_line(' ');
508: end;
509:

Line 506: fii_util.print_timer('Process Time');

502: end if;
503: end loop;
504: commit;
505: fii_util.stop_timer;
506: fii_util.print_timer('Process Time');
507: edw_log.put_line(' ');
508: end;
509:
510: /* Pushing Quarter */

Line 513: fii_util.start_timer;

509:
510: /* Pushing Quarter */
511: begin
512: edw_log.put_line('Pushing Quarter');
513: fii_util.start_timer;
514: l_quarter:=fnd_message.get_string('FII', 'FII_AR_QUARTER');
515: loop
516: insert into edw_time_qtr_lstg
517: (qtr_pk,

Line 552: fii_util.stop_timer;

548: exit;
549: end if;
550: end loop;
551: commit;
552: fii_util.stop_timer;
553: fii_util.print_timer('Process Time');
554: edw_log.put_line(' ');
555: end;
556:

Line 553: fii_util.print_timer('Process Time');

549: end if;
550: end loop;
551: commit;
552: fii_util.stop_timer;
553: fii_util.print_timer('Process Time');
554: edw_log.put_line(' ');
555: end;
556:
557: /* Pushing Half Year */

Line 560: fii_util.start_timer;

556:
557: /* Pushing Half Year */
558: begin
559: edw_log.put_line('Pushing Half Year');
560: fii_util.start_timer;
561: l_first_half:=fnd_message.get_string('FII', 'FII_AR_FIRST_HALF');
562: l_second_half:=fnd_message.get_string('FII', 'FII_AR_SECOND_HALF');
563: loop
564: insert into edw_time_half_year_lstg

Line 607: fii_util.stop_timer;

603: l_half_year_counter := 0;
604: end if;
605: end loop;
606: commit;
607: fii_util.stop_timer;
608: fii_util.print_timer('Process Time');
609: edw_log.put_line(' ');
610: end;
611:

Line 608: fii_util.print_timer('Process Time');

604: end if;
605: end loop;
606: commit;
607: fii_util.stop_timer;
608: fii_util.print_timer('Process Time');
609: edw_log.put_line(' ');
610: end;
611:
612: /* Pushing Year */

Line 615: fii_util.start_timer;

611:
612: /* Pushing Year */
613: begin
614: edw_log.put_line('Pushing Year');
615: fii_util.start_timer;
616: loop
617: insert into edw_time_year_lstg
618: (year_pk,
619: all_fk,

Line 654: fii_util.stop_timer;

650: exit;
651: end if;
652: end loop;
653: commit;
654: fii_util.stop_timer;
655: fii_util.print_timer('Process Time');
656: edw_log.put_line(' ');
657: end;
658:

Line 655: fii_util.print_timer('Process Time');

651: end if;
652: end loop;
653: commit;
654: fii_util.stop_timer;
655: fii_util.print_timer('Process Time');
656: edw_log.put_line(' ');
657: end;
658:
659: /* Pushing Week */

Line 662: fii_util.start_timer;

658:
659: /* Pushing Week */
660: begin
661: edw_log.put_line('Pushing Week');
662: fii_util.start_timer;
663: l_week:=fnd_message.get_string('FII', 'FII_AR_WEEK');
664: loop
665: insert into edw_time_week_lstg
666: (week_pk,

Line 710: fii_util.stop_timer;

706: exit;
707: end if;
708: end loop;
709: commit;
710: fii_util.stop_timer;
711: fii_util.print_timer('Process Time');
712: edw_log.put_line(' ');
713: end;
714:

Line 711: fii_util.print_timer('Process Time');

707: end if;
708: end loop;
709: commit;
710: fii_util.stop_timer;
711: fii_util.print_timer('Process Time');
712: edw_log.put_line(' ');
713: end;
714:
715: /* Pushing 445 Period */

Line 718: fii_util.start_timer;

714:
715: /* Pushing 445 Period */
716: begin
717: edw_log.put_line('Pushing 445 Period');
718: fii_util.start_timer;
719: l_period:=fnd_message.get_string('FII', 'FII_AR_PERIOD');
720: loop
721: INSERT INTO edw_time_period_445_lstg
722: (period_445_pk,

Line 768: fii_util.stop_timer;

764: exit;
765: end if;
766: end loop;
767: commit;
768: fii_util.stop_timer;
769: fii_util.print_timer('Process Time');
770: edw_log.put_line(' ');
771: end;
772:

Line 769: fii_util.print_timer('Process Time');

765: end if;
766: end loop;
767: commit;
768: fii_util.stop_timer;
769: fii_util.print_timer('Process Time');
770: edw_log.put_line(' ');
771: end;
772:
773: /* Pushing Half Month */

Line 776: fii_util.start_timer;

772:
773: /* Pushing Half Month */
774: begin
775: edw_log.put_line('Pushing Half Month');
776: fii_util.start_timer;
777: l_first_half:=fnd_message.get_string('FII', 'FII_AR_FIRST_HALF');
778: l_second_half:=fnd_message.get_string('FII', 'FII_AR_SECOND_HALF');
779: loop
780: insert into edw_time_half_month_lstg

Line 860: fii_util.stop_timer;

856: l_hm_counter:=0;
857: end if;
858: end loop;
859: commit;
860: fii_util.stop_timer;
861: fii_util.print_timer('Process Time');
862: edw_log.put_line(' ');
863: end;
864:

Line 861: fii_util.print_timer('Process Time');

857: end if;
858: end loop;
859: commit;
860: fii_util.stop_timer;
861: fii_util.print_timer('Process Time');
862: edw_log.put_line(' ');
863: end;
864:
865: /* for Status Viewer to verify the pushed record number */