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_PA_COST_F_C dependencies on FII_UTIL

Line 615: fii_util.start_timer;

611: -- --------------------------------------------------------
612: if g_debug_flag = 'Y' then
613: edw_log.put_line(' ');
614: edw_log.put_line('Cleaning up unprocessed records left in local staging table');
615: fii_util.start_timer;
616: end if;
617:
618: -- note that TRUNCATE statement does implicit commit;
619:

Line 629: fii_util.stop_timer;

625: select count(*) into rows1 from FII_PA_COST_FSTG;
626:
627: if g_debug_flag = 'Y' then
628: edw_log.put_line('Number of rows in stg after truncating or deleting'||rows1 );
629: fii_util.stop_timer;
630: fii_util.print_timer('Process Time');
631: end if;
632:
633: -- --------------------------------------------------------

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

626:
627: if g_debug_flag = 'Y' then
628: edw_log.put_line('Number of rows in stg after truncating or deleting'||rows1 );
629: fii_util.stop_timer;
630: fii_util.print_timer('Process Time');
631: end if;
632:
633: -- --------------------------------------------------------
634: -- 2. Identify Changed records in the

Line 641: fii_util.start_timer;

637:
638: -- note that IDENTIFY_CHANGE analyzes table and does implicit commit;
639:
640: if g_debug_flag = 'Y' then
641: fii_util.start_timer;
642: end if;
643:
644: if NOT IDENTIFY_CHANGE THEN
645: RAISE l_iden_change_failure;

Line 651: fii_util.stop_timer;

647: select count(*) into rows1 from FII_PA_COST_pk;
648:
649: if g_debug_flag = 'Y' then
650: edw_log.put_line('Number of rows in pk after identify change'||rows1 );
651: fii_util.stop_timer;
652: fii_util.print_timer('Process Time');
653: end if;
654:
655: -- --------------------------------------------------------

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

648:
649: if g_debug_flag = 'Y' then
650: edw_log.put_line('Number of rows in pk after identify change'||rows1 );
651: fii_util.stop_timer;
652: fii_util.print_timer('Process Time');
653: end if;
654:
655: -- --------------------------------------------------------
656: -- 3. Pushing data to local staging table

Line 662: fii_util.start_timer;

658:
659: if g_debug_flag = 'Y' then
660: edw_log.put_line(' ');
661: edw_log.put_line('Pushing data to local staging table');
662: fii_util.start_timer;
663: end if;
664:
665: g_row_count := PUSH_TO_LOCAL;
666:

Line 668: fii_util.stop_timer;

664:
665: g_row_count := PUSH_TO_LOCAL;
666:
667: if g_debug_flag = 'Y' then
668: fii_util.stop_timer;
669: fii_util.print_timer('Process Time');
670: end if;
671:
672: IF (g_row_count = -1) THEN

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

665: g_row_count := PUSH_TO_LOCAL;
666:
667: if g_debug_flag = 'Y' then
668: fii_util.stop_timer;
669: fii_util.print_timer('Process Time');
670: end if;
671:
672: IF (g_row_count = -1) THEN
673: RAISE L_push_local_failure;

Line 746: fii_util.start_timer;

742: if g_debug_flag = 'Y' then
743: edw_log.put_line(' ');
744: edw_log.put_line('g_row_count in LOCAL_SAME_AS_REMOTE'|| g_row_count);
745: edw_log.put_line('Moving data from local staging table to remote staging table');
746: fii_util.start_timer;
747: end if;
748:
749: g_row_count := PUSH_REMOTE;
750:

Line 752: fii_util.stop_timer;

748:
749: g_row_count := PUSH_REMOTE;
750:
751: if g_debug_flag = 'Y' then
752: fii_util.stop_timer;
753: fii_util.print_timer('Process time');
754: end if;
755:
756: IF (g_row_count = -1) THEN RAISE l_push_remote_failure; END IF;

Line 753: fii_util.print_timer('Process time');

749: g_row_count := PUSH_REMOTE;
750:
751: if g_debug_flag = 'Y' then
752: fii_util.stop_timer;
753: fii_util.print_timer('Process time');
754: end if;
755:
756: IF (g_row_count = -1) THEN RAISE l_push_remote_failure; END IF;
757:

Line 761: fii_util.start_timer;

757:
758: if g_debug_flag = 'Y' then
759: edw_log.put_line(' ');
760: edw_log.put_line('Cleaning local staging table');
761: fii_util.start_timer;
762: end if;
763:
764: TRUNCATE_STG;
765:

Line 767: fii_util.stop_timer;

763:
764: TRUNCATE_STG;
765:
766: if g_debug_flag = 'Y' then
767: fii_util.stop_timer;
768: fii_util.print_timer('Process time');
769: end if;
770:
771: ELSE

Line 768: fii_util.print_timer('Process time');

764: TRUNCATE_STG;
765:
766: if g_debug_flag = 'Y' then
767: fii_util.stop_timer;
768: fii_util.print_timer('Process time');
769: end if;
770:
771: ELSE
772: -- -----------------------------------------------

Line 781: fii_util.start_timer;

777:
778: if g_debug_flag = 'Y' then
779: edw_log.put_line(' ');
780: edw_log.put_line('Marking records in staging table with READY status');
781: fii_util.start_timer;
782: end if;
783:
784: g_row_count := SET_STATUS_READY;
785:

Line 787: fii_util.stop_timer;

783:
784: g_row_count := SET_STATUS_READY;
785:
786: if g_debug_flag = 'Y' then
787: fii_util.stop_timer;
788: fii_util.print_timer('Process time');
789: edw_log.put_line('g_row_count from SET_STATUS_READY'|| g_row_count);
790: end if;
791:

Line 788: fii_util.print_timer('Process time');

784: g_row_count := SET_STATUS_READY;
785:
786: if g_debug_flag = 'Y' then
787: fii_util.stop_timer;
788: fii_util.print_timer('Process time');
789: edw_log.put_line('g_row_count from SET_STATUS_READY'|| g_row_count);
790: end if;
791:
792: DELETE_STG;