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

Line 910: fii_util.start_timer;

906: -- 2. Identify Changed AP Invoice Payments record
907: -- --------------------------------------------------------
908: edw_log.put_line(' ');
909: edw_log.put_line('Identifying changed AP Invoice Payments record');
910: fii_util.start_timer;
911: IDENTIFY_CHANGE(l_row_count);
912: fii_util.stop_timer;
913: fii_util.print_timer('Identified '||l_row_count||' changed records');
914:

Line 912: fii_util.stop_timer;

908: edw_log.put_line(' ');
909: edw_log.put_line('Identifying changed AP Invoice Payments record');
910: fii_util.start_timer;
911: IDENTIFY_CHANGE(l_row_count);
912: fii_util.stop_timer;
913: fii_util.print_timer('Identified '||l_row_count||' changed records');
914:
915: -- --------------------------------------------------------
916: -- 3. Pushing data to local staging table

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

909: edw_log.put_line('Identifying changed AP Invoice Payments record');
910: fii_util.start_timer;
911: IDENTIFY_CHANGE(l_row_count);
912: fii_util.stop_timer;
913: fii_util.print_timer('Identified '||l_row_count||' changed records');
914:
915: -- --------------------------------------------------------
916: -- 3. Pushing data to local staging table
917: -- --------------------------------------------------------

Line 921: fii_util.start_timer;

917: -- --------------------------------------------------------
918:
919: edw_log.put_line(' ');
920: edw_log.put_line('Pushing data');
921: fii_util.start_timer;
922: g_row_count := PUSH_TO_LOCAL;
923: fii_util.stop_timer;
924: fii_util.print_timer('Process Time');
925:

Line 923: fii_util.stop_timer;

919: edw_log.put_line(' ');
920: edw_log.put_line('Pushing data');
921: fii_util.start_timer;
922: g_row_count := PUSH_TO_LOCAL;
923: fii_util.stop_timer;
924: fii_util.print_timer('Process Time');
925:
926: IF (g_row_count = -1) THEN
927: RAISE L_push_local_failure;

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

920: edw_log.put_line('Pushing data');
921: fii_util.start_timer;
922: g_row_count := PUSH_TO_LOCAL;
923: fii_util.stop_timer;
924: fii_util.print_timer('Process Time');
925:
926: IF (g_row_count = -1) THEN
927: RAISE L_push_local_failure;
928: END IF;

Line 1048: fii_util.start_timer;

1044: -- and clean up local staging
1045: -- -----------------------------------------------
1046: edw_log.put_line(' ');
1047: edw_log.put_line('Moving data from local staging table to remote staging table');
1048: fii_util.start_timer;
1049: g_row_count := PUSH_REMOTE;
1050: fii_util.stop_timer;
1051: fii_util.print_timer('Duration');
1052:

Line 1050: fii_util.stop_timer;

1046: edw_log.put_line(' ');
1047: edw_log.put_line('Moving data from local staging table to remote staging table');
1048: fii_util.start_timer;
1049: g_row_count := PUSH_REMOTE;
1050: fii_util.stop_timer;
1051: fii_util.print_timer('Duration');
1052:
1053: IF (g_row_count = -1) THEN RAISE l_push_remote_failure; END IF;
1054:

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

1047: edw_log.put_line('Moving data from local staging table to remote staging table');
1048: fii_util.start_timer;
1049: g_row_count := PUSH_REMOTE;
1050: fii_util.stop_timer;
1051: fii_util.print_timer('Duration');
1052:
1053: IF (g_row_count = -1) THEN RAISE l_push_remote_failure; END IF;
1054:
1055: edw_log.put_line(' ');

Line 1058: fii_util.start_timer;

1054:
1055: edw_log.put_line(' ');
1056: edw_log.put_line('Cleaning local staging table');
1057:
1058: fii_util.start_timer;
1059: TRUNCATE_TABLE('FII_AP_INV_PAYMTS_FSTG');
1060: fii_util.stop_timer;
1061: fii_util.print_timer('Duration');
1062:

Line 1060: fii_util.stop_timer;

1056: edw_log.put_line('Cleaning local staging table');
1057:
1058: fii_util.start_timer;
1059: TRUNCATE_TABLE('FII_AP_INV_PAYMTS_FSTG');
1060: fii_util.stop_timer;
1061: fii_util.print_timer('Duration');
1062:
1063: ELSE
1064: -- -----------------------------------------------

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

1057:
1058: fii_util.start_timer;
1059: TRUNCATE_TABLE('FII_AP_INV_PAYMTS_FSTG');
1060: fii_util.stop_timer;
1061: fii_util.print_timer('Duration');
1062:
1063: ELSE
1064: -- -----------------------------------------------
1065: -- The target warehouse is the same database

Line 1073: fii_util.start_timer;

1069:
1070: edw_log.put_line(' ');
1071: edw_log.put_line('Marking records in staging table with READY status');
1072:
1073: fii_util.start_timer;
1074: g_row_count := SET_STATUS_READY;
1075: fii_util.stop_timer;
1076: fii_util.print_timer('Duration');
1077: commit;

Line 1075: fii_util.stop_timer;

1071: edw_log.put_line('Marking records in staging table with READY status');
1072:
1073: fii_util.start_timer;
1074: g_row_count := SET_STATUS_READY;
1075: fii_util.stop_timer;
1076: fii_util.print_timer('Duration');
1077: commit;
1078: DELETE_STG;
1079: IF (g_row_count = -1) THEN RAISE l_set_status_failure; END IF;

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

1072:
1073: fii_util.start_timer;
1074: g_row_count := SET_STATUS_READY;
1075: fii_util.stop_timer;
1076: fii_util.print_timer('Duration');
1077: commit;
1078: DELETE_STG;
1079: IF (g_row_count = -1) THEN RAISE l_set_status_failure; END IF;
1080: END IF;