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

Line 723: fii_util.start_timer;

719: -- 2. Identify Changed AP Invoice Holds record
720: -- --------------------------------------------------------
721: edw_log.put_line(' ');
722: edw_log.put_line('Identifying changed AP Invoice Holds record');
723: fii_util.start_timer;
724: IDENTIFY_CHANGE(l_row_count);
725: fii_util.stop_timer;
726: fii_util.print_timer('Identified '||l_row_count||' changed records');
727:

Line 725: fii_util.stop_timer;

721: edw_log.put_line(' ');
722: edw_log.put_line('Identifying changed AP Invoice Holds record');
723: fii_util.start_timer;
724: IDENTIFY_CHANGE(l_row_count);
725: fii_util.stop_timer;
726: fii_util.print_timer('Identified '||l_row_count||' changed records');
727:
728:
729: -- --------------------------------------------------------

Line 726: fii_util.print_timer('Identified '||l_row_count||' changed records');

722: edw_log.put_line('Identifying changed AP Invoice Holds record');
723: fii_util.start_timer;
724: IDENTIFY_CHANGE(l_row_count);
725: fii_util.stop_timer;
726: fii_util.print_timer('Identified '||l_row_count||' changed records');
727:
728:
729: -- --------------------------------------------------------
730: -- 3. Pushing data to local staging table

Line 735: fii_util.start_timer;

731: -- --------------------------------------------------------
732:
733: edw_log.put_line(' ');
734: edw_log.put_line('Pushing data');
735: fii_util.start_timer;
736: g_row_count := PUSH_TO_LOCAL;
737: fii_util.stop_timer;
738: fii_util.print_timer('Process Time');
739:

Line 737: fii_util.stop_timer;

733: edw_log.put_line(' ');
734: edw_log.put_line('Pushing data');
735: fii_util.start_timer;
736: g_row_count := PUSH_TO_LOCAL;
737: fii_util.stop_timer;
738: fii_util.print_timer('Process Time');
739:
740: IF (g_row_count = -1) THEN
741: RAISE L_push_local_failure;

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

734: edw_log.put_line('Pushing data');
735: fii_util.start_timer;
736: g_row_count := PUSH_TO_LOCAL;
737: fii_util.stop_timer;
738: fii_util.print_timer('Process Time');
739:
740: IF (g_row_count = -1) THEN
741: RAISE L_push_local_failure;
742: END IF;

Line 865: fii_util.start_timer;

861: -- -----------------------------------------------
862:
863: edw_log.put_line(' ');
864: edw_log.put_line('Moving data from local staging table to remote staging table');
865: fii_util.start_timer;
866: g_row_count := PUSH_REMOTE;
867: fii_util.stop_timer;
868: fii_util.print_timer('Duration');
869:

Line 867: fii_util.stop_timer;

863: edw_log.put_line(' ');
864: edw_log.put_line('Moving data from local staging table to remote staging table');
865: fii_util.start_timer;
866: g_row_count := PUSH_REMOTE;
867: fii_util.stop_timer;
868: fii_util.print_timer('Duration');
869:
870: IF (g_row_count = -1) THEN RAISE l_push_remote_failure; END IF;
871:

Line 868: fii_util.print_timer('Duration');

864: edw_log.put_line('Moving data from local staging table to remote staging table');
865: fii_util.start_timer;
866: g_row_count := PUSH_REMOTE;
867: fii_util.stop_timer;
868: fii_util.print_timer('Duration');
869:
870: IF (g_row_count = -1) THEN RAISE l_push_remote_failure; END IF;
871:
872: edw_log.put_line(' ');

Line 875: fii_util.start_timer;

871:
872: edw_log.put_line(' ');
873: edw_log.put_line('Cleaning local staging table');
874:
875: fii_util.start_timer;
876: TRUNCATE_TABLE('FII_AP_INV_ON_HOLD_FSTG');
877: fii_util.stop_timer;
878: fii_util.print_timer('Duration');
879:

Line 877: fii_util.stop_timer;

873: edw_log.put_line('Cleaning local staging table');
874:
875: fii_util.start_timer;
876: TRUNCATE_TABLE('FII_AP_INV_ON_HOLD_FSTG');
877: fii_util.stop_timer;
878: fii_util.print_timer('Duration');
879:
880: ELSE
881: -- -----------------------------------------------

Line 878: fii_util.print_timer('Duration');

874:
875: fii_util.start_timer;
876: TRUNCATE_TABLE('FII_AP_INV_ON_HOLD_FSTG');
877: fii_util.stop_timer;
878: fii_util.print_timer('Duration');
879:
880: ELSE
881: -- -----------------------------------------------
882: -- The target warehouse is the same database

Line 890: fii_util.start_timer;

886:
887: edw_log.put_line(' ');
888: edw_log.put_line('Marking records in staging table with READY status');
889:
890: fii_util.start_timer;
891: g_row_count := SET_STATUS_READY;
892: fii_util.stop_timer;
893: fii_util.print_timer('Duration');
894: commit;

Line 892: fii_util.stop_timer;

888: edw_log.put_line('Marking records in staging table with READY status');
889:
890: fii_util.start_timer;
891: g_row_count := SET_STATUS_READY;
892: fii_util.stop_timer;
893: fii_util.print_timer('Duration');
894: commit;
895: DELETE_STG;
896: IF (g_row_count = -1) THEN RAISE l_set_status_failure; END IF;

Line 893: fii_util.print_timer('Duration');

889:
890: fii_util.start_timer;
891: g_row_count := SET_STATUS_READY;
892: fii_util.stop_timer;
893: fii_util.print_timer('Duration');
894: commit;
895: DELETE_STG;
896: IF (g_row_count = -1) THEN RAISE l_set_status_failure; END IF;
897: END IF;