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.OKI_REFRESH_PVT dependencies on FND_DATE

Line 1578: fnd_date.date_to_displayDT(sysdate));

1574: l_job_end_date := LEAST(nvl(p_job_start_date, sysdate ),l_sysdate);
1575:
1576: fnd_file.put_line( which => fnd_file.log
1577: , buff => 'Service Contracts Intelligence - incremental load Started on ' ||
1578: fnd_date.date_to_displayDT(sysdate));
1579: fnd_file.put_line( which => fnd_file.log
1580: , buff => 'Parameter : start date '|| fnd_date.date_to_displayDT(l_job_start_date));
1581: fnd_file.put_line( which => fnd_file.log
1582: , buff => 'Parameter : end date '|| fnd_date.date_to_displayDT(l_job_end_date));

Line 1580: , buff => 'Parameter : start date '|| fnd_date.date_to_displayDT(l_job_start_date));

1576: fnd_file.put_line( which => fnd_file.log
1577: , buff => 'Service Contracts Intelligence - incremental load Started on ' ||
1578: fnd_date.date_to_displayDT(sysdate));
1579: fnd_file.put_line( which => fnd_file.log
1580: , buff => 'Parameter : start date '|| fnd_date.date_to_displayDT(l_job_start_date));
1581: fnd_file.put_line( which => fnd_file.log
1582: , buff => 'Parameter : end date '|| fnd_date.date_to_displayDT(l_job_end_date));
1583:
1584: IF l_job_end_date < l_job_start_date THEN

Line 1582: , buff => 'Parameter : end date '|| fnd_date.date_to_displayDT(l_job_end_date));

1578: fnd_date.date_to_displayDT(sysdate));
1579: fnd_file.put_line( which => fnd_file.log
1580: , buff => 'Parameter : start date '|| fnd_date.date_to_displayDT(l_job_start_date));
1581: fnd_file.put_line( which => fnd_file.log
1582: , buff => 'Parameter : end date '|| fnd_date.date_to_displayDT(l_job_end_date));
1583:
1584: IF l_job_end_date < l_job_start_date THEN
1585: -- Job start date is greater than job end date
1586: fnd_file.put_line( which => fnd_file.log

Line 1742: fnd_date.date_to_displayDT(sysdate));

1738: l_table_owner := 'OKI';
1739:
1740: fnd_file.put_line( which => fnd_file.log
1741: , buff => 'Service Contracts Intelligence - Initial load Started on: ' ||
1742: fnd_date.date_to_displayDT(sysdate));
1743: fnd_file.put_line( which => fnd_file.log
1744: , buff => 'Parameter : start date '|| fnd_date.date_to_displayDT(l_job_start_date));
1745: fnd_file.put_line( which => fnd_file.log
1746: , buff => 'Parameter : end date '|| fnd_date.date_to_displayDT(l_sysdate));

Line 1744: , buff => 'Parameter : start date '|| fnd_date.date_to_displayDT(l_job_start_date));

1740: fnd_file.put_line( which => fnd_file.log
1741: , buff => 'Service Contracts Intelligence - Initial load Started on: ' ||
1742: fnd_date.date_to_displayDT(sysdate));
1743: fnd_file.put_line( which => fnd_file.log
1744: , buff => 'Parameter : start date '|| fnd_date.date_to_displayDT(l_job_start_date));
1745: fnd_file.put_line( which => fnd_file.log
1746: , buff => 'Parameter : end date '|| fnd_date.date_to_displayDT(l_sysdate));
1747:
1748: l_table_name := 'OKI_JOB_RUNS' ;

Line 1746: , buff => 'Parameter : end date '|| fnd_date.date_to_displayDT(l_sysdate));

1742: fnd_date.date_to_displayDT(sysdate));
1743: fnd_file.put_line( which => fnd_file.log
1744: , buff => 'Parameter : start date '|| fnd_date.date_to_displayDT(l_job_start_date));
1745: fnd_file.put_line( which => fnd_file.log
1746: , buff => 'Parameter : end date '|| fnd_date.date_to_displayDT(l_sysdate));
1747:
1748: l_table_name := 'OKI_JOB_RUNS' ;
1749: l_loc := 'Calling truncate_table with ' || l_table_owner || '.' || l_table_name ;
1750: truncate_table( p_table_owner => l_table_owner