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

Line 636: -- fii_util.stop_timer;

632: l_duration := sysdate - l_temp_date;
633: edw_log.put_line ('Process Time for Update: ' || edw_log.duration(l_duration));
634: edw_log.put_line ('# of Updated Records: ' || l_count);
635:
636: -- fii_util.stop_timer;
637: -- fii_util.print_timer('Duration');
638:
639: EXCEPTION
640: WHEN OTHERS THEN

Line 637: -- fii_util.print_timer('Duration');

633: edw_log.put_line ('Process Time for Update: ' || edw_log.duration(l_duration));
634: edw_log.put_line ('# of Updated Records: ' || l_count);
635:
636: -- fii_util.stop_timer;
637: -- fii_util.print_timer('Duration');
638:
639: EXCEPTION
640: WHEN OTHERS THEN
641: g_errbuf:=sqlerrm;

Line 1335: fii_util.start_timer;

1331: -- 2. Identify Changed AP Invoice Lines record
1332: -- --------------------------------------------------------
1333: edw_log.put_line(' ');
1334: edw_log.put_line('Identifying changed AP Invoice Lines record');
1335: fii_util.start_timer;
1336: IDENTIFY_CHANGE(l_row_count);
1337: fii_util.stop_timer;
1338: fii_util.print_timer('Identified '||l_row_count||' changed records');
1339:

Line 1337: fii_util.stop_timer;

1333: edw_log.put_line(' ');
1334: edw_log.put_line('Identifying changed AP Invoice Lines record');
1335: fii_util.start_timer;
1336: IDENTIFY_CHANGE(l_row_count);
1337: fii_util.stop_timer;
1338: fii_util.print_timer('Identified '||l_row_count||' changed records');
1339:
1340: -- --------------------------------------------------------
1341: -- 3. Pushing data to local staging table

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

1334: edw_log.put_line('Identifying changed AP Invoice Lines record');
1335: fii_util.start_timer;
1336: IDENTIFY_CHANGE(l_row_count);
1337: fii_util.stop_timer;
1338: fii_util.print_timer('Identified '||l_row_count||' changed records');
1339:
1340: -- --------------------------------------------------------
1341: -- 3. Pushing data to local staging table
1342: -- --------------------------------------------------------

Line 1346: fii_util.start_timer;

1342: -- --------------------------------------------------------
1343:
1344: edw_log.put_line(' ');
1345: edw_log.put_line('Pushing data');
1346: fii_util.start_timer;
1347: g_row_count := PUSH_TO_LOCAL;
1348: fii_util.stop_timer;
1349: fii_util.print_timer('Process Time');
1350:

Line 1348: fii_util.stop_timer;

1344: edw_log.put_line(' ');
1345: edw_log.put_line('Pushing data');
1346: fii_util.start_timer;
1347: g_row_count := PUSH_TO_LOCAL;
1348: fii_util.stop_timer;
1349: fii_util.print_timer('Process Time');
1350:
1351: IF (g_row_count = -1) THEN
1352: RAISE L_push_local_failure;

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

1345: edw_log.put_line('Pushing data');
1346: fii_util.start_timer;
1347: g_row_count := PUSH_TO_LOCAL;
1348: fii_util.stop_timer;
1349: fii_util.print_timer('Process Time');
1350:
1351: IF (g_row_count = -1) THEN
1352: RAISE L_push_local_failure;
1353: END IF;

Line 1367: fii_util.start_timer;

1363: -- --------------------------------------------------------
1364:
1365: edw_log.put_line(' ');
1366: edw_log.put_line('Populate discount_amt columns');
1367: fii_util.start_timer;
1368:
1369: UPDATE_DIST_CCID; -- added for SLA-AP Uptake
1370:
1371: UPDATE_DISCOUNT_AMT;

Line 1372: fii_util.stop_timer;

1368:
1369: UPDATE_DIST_CCID; -- added for SLA-AP Uptake
1370:
1371: UPDATE_DISCOUNT_AMT;
1372: fii_util.stop_timer;
1373:
1374:
1375: -- --------------------------------------------------------
1376: -- 4. Delete all temp table records

Line 1488: fii_util.start_timer;

1484: -- -----------------------------------------------
1485:
1486: edw_log.put_line(' ');
1487: edw_log.put_line('Moving data from local staging table to remote staging table');
1488: fii_util.start_timer;
1489: g_row_count := PUSH_REMOTE;
1490: fii_util.stop_timer;
1491: fii_util.print_timer('Duration');
1492:

Line 1490: fii_util.stop_timer;

1486: edw_log.put_line(' ');
1487: edw_log.put_line('Moving data from local staging table to remote staging table');
1488: fii_util.start_timer;
1489: g_row_count := PUSH_REMOTE;
1490: fii_util.stop_timer;
1491: fii_util.print_timer('Duration');
1492:
1493: IF (g_row_count = -1) THEN RAISE l_push_remote_failure; END IF;
1494:

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

1487: edw_log.put_line('Moving data from local staging table to remote staging table');
1488: fii_util.start_timer;
1489: g_row_count := PUSH_REMOTE;
1490: fii_util.stop_timer;
1491: fii_util.print_timer('Duration');
1492:
1493: IF (g_row_count = -1) THEN RAISE l_push_remote_failure; END IF;
1494:
1495: edw_log.put_line(' ');

Line 1498: fii_util.start_timer;

1494:
1495: edw_log.put_line(' ');
1496: edw_log.put_line('Cleaning local staging table');
1497:
1498: fii_util.start_timer;
1499: TRUNCATE_table('FII_AP_INV_LINES_FSTG');
1500: fii_util.stop_timer;
1501: fii_util.print_timer('Duration');
1502:

Line 1500: fii_util.stop_timer;

1496: edw_log.put_line('Cleaning local staging table');
1497:
1498: fii_util.start_timer;
1499: TRUNCATE_table('FII_AP_INV_LINES_FSTG');
1500: fii_util.stop_timer;
1501: fii_util.print_timer('Duration');
1502:
1503: ELSE
1504: -- -----------------------------------------------

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

1497:
1498: fii_util.start_timer;
1499: TRUNCATE_table('FII_AP_INV_LINES_FSTG');
1500: fii_util.stop_timer;
1501: fii_util.print_timer('Duration');
1502:
1503: ELSE
1504: -- -----------------------------------------------
1505: -- The target warehouse is the same database

Line 1513: fii_util.start_timer;

1509:
1510: edw_log.put_line(' ');
1511: edw_log.put_line('Marking records in staging table with READY status');
1512:
1513: fii_util.start_timer;
1514: g_row_count := SET_STATUS_READY;
1515: fii_util.stop_timer;
1516: fii_util.print_timer('Duration');
1517: COMMIT;

Line 1515: fii_util.stop_timer;

1511: edw_log.put_line('Marking records in staging table with READY status');
1512:
1513: fii_util.start_timer;
1514: g_row_count := SET_STATUS_READY;
1515: fii_util.stop_timer;
1516: fii_util.print_timer('Duration');
1517: COMMIT;
1518: DELETE_STG;
1519: IF (g_row_count = -1) THEN RAISE l_set_status_failure; END IF;

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

1512:
1513: fii_util.start_timer;
1514: g_row_count := SET_STATUS_READY;
1515: fii_util.stop_timer;
1516: fii_util.print_timer('Duration');
1517: COMMIT;
1518: DELETE_STG;
1519: IF (g_row_count = -1) THEN RAISE l_set_status_failure; END IF;
1520: END IF;