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

Line 760: fii_util.start_timer;

756: -- 2. Identify Changed AP Holds record and AP Invoices record
757: -- --------------------------------------------------------
758: edw_log.put_line(' ');
759: edw_log.put_line('Identifying changed AP Holds record and AP Invoices record');
760: fii_util.start_timer;
761: IDENTIFY_CHANGE(l_row_count);
762: fii_util.stop_timer;
763: fii_util.print_timer('Identified '||l_row_count||' changed records');
764:

Line 762: fii_util.stop_timer;

758: edw_log.put_line(' ');
759: edw_log.put_line('Identifying changed AP Holds record and AP Invoices record');
760: fii_util.start_timer;
761: IDENTIFY_CHANGE(l_row_count);
762: fii_util.stop_timer;
763: fii_util.print_timer('Identified '||l_row_count||' changed records');
764:
765: -- --------------------------------------------------------
766: -- 3. Pushing data to local staging table

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

759: edw_log.put_line('Identifying changed AP Holds record and AP Invoices record');
760: fii_util.start_timer;
761: IDENTIFY_CHANGE(l_row_count);
762: fii_util.stop_timer;
763: fii_util.print_timer('Identified '||l_row_count||' changed records');
764:
765: -- --------------------------------------------------------
766: -- 3. Pushing data to local staging table
767: -- --------------------------------------------------------

Line 771: fii_util.start_timer;

767: -- --------------------------------------------------------
768:
769: edw_log.put_line(' ');
770: edw_log.put_line('Pushing data');
771: fii_util.start_timer;
772: g_row_count := PUSH_TO_LOCAL;
773: fii_util.stop_timer;
774: fii_util.print_timer('Process Time');
775:

Line 773: fii_util.stop_timer;

769: edw_log.put_line(' ');
770: edw_log.put_line('Pushing data');
771: fii_util.start_timer;
772: g_row_count := PUSH_TO_LOCAL;
773: fii_util.stop_timer;
774: fii_util.print_timer('Process Time');
775:
776: IF (g_row_count = -1) THEN
777: RAISE L_push_local_failure;

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

770: edw_log.put_line('Pushing data');
771: fii_util.start_timer;
772: g_row_count := PUSH_TO_LOCAL;
773: fii_util.stop_timer;
774: fii_util.print_timer('Process Time');
775:
776: IF (g_row_count = -1) THEN
777: RAISE L_push_local_failure;
778: END IF;

Line 902: fii_util.start_timer;

898: -- -----------------------------------------------
899:
900: edw_log.put_line(' ');
901: edw_log.put_line('Moving data from local staging table to remote staging table');
902: fii_util.start_timer;
903: g_row_count := PUSH_REMOTE;
904: fii_util.stop_timer;
905: fii_util.print_timer('Duration');
906:

Line 904: fii_util.stop_timer;

900: edw_log.put_line(' ');
901: edw_log.put_line('Moving data from local staging table to remote staging table');
902: fii_util.start_timer;
903: g_row_count := PUSH_REMOTE;
904: fii_util.stop_timer;
905: fii_util.print_timer('Duration');
906:
907: IF (g_row_count = -1) THEN RAISE l_push_remote_failure; END IF;
908:

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

901: edw_log.put_line('Moving data from local staging table to remote staging table');
902: fii_util.start_timer;
903: g_row_count := PUSH_REMOTE;
904: fii_util.stop_timer;
905: fii_util.print_timer('Duration');
906:
907: IF (g_row_count = -1) THEN RAISE l_push_remote_failure; END IF;
908:
909: edw_log.put_line(' ');

Line 912: fii_util.start_timer;

908:
909: edw_log.put_line(' ');
910: edw_log.put_line('Cleaning local staging table');
911:
912: fii_util.start_timer;
913: TRUNCATE_TABLE('FII_AP_HOLD_DATA_FSTG');
914: fii_util.stop_timer;
915: fii_util.print_timer('Duration');
916:

Line 914: fii_util.stop_timer;

910: edw_log.put_line('Cleaning local staging table');
911:
912: fii_util.start_timer;
913: TRUNCATE_TABLE('FII_AP_HOLD_DATA_FSTG');
914: fii_util.stop_timer;
915: fii_util.print_timer('Duration');
916:
917: ELSE
918: -- -----------------------------------------------

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

911:
912: fii_util.start_timer;
913: TRUNCATE_TABLE('FII_AP_HOLD_DATA_FSTG');
914: fii_util.stop_timer;
915: fii_util.print_timer('Duration');
916:
917: ELSE
918: -- -----------------------------------------------
919: -- The target warehouse is the same database

Line 927: fii_util.start_timer;

923:
924: edw_log.put_line(' ');
925: edw_log.put_line('Marking records in staging table with READY status');
926:
927: fii_util.start_timer;
928: g_row_count := SET_STATUS_READY;
929: fii_util.stop_timer;
930: fii_util.print_timer('Duration');
931: commit;

Line 929: fii_util.stop_timer;

925: edw_log.put_line('Marking records in staging table with READY status');
926:
927: fii_util.start_timer;
928: g_row_count := SET_STATUS_READY;
929: fii_util.stop_timer;
930: fii_util.print_timer('Duration');
931: commit;
932: DELETE_STG;
933: IF (g_row_count = -1) THEN RAISE l_set_status_failure; END IF;

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

926:
927: fii_util.start_timer;
928: g_row_count := SET_STATUS_READY;
929: fii_util.stop_timer;
930: fii_util.print_timer('Duration');
931: commit;
932: DELETE_STG;
933: IF (g_row_count = -1) THEN RAISE l_set_status_failure; END IF;
934: END IF;