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.HR_EDW_WRK_CMPSTN_F_C dependencies on EDW_LOG

Line 327: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||

323: -- where last_update_date between l_date1 and l_date2;
324: l_rows_inserted := sql%rowcount;
325: l_duration := sysdate - l_temp_date;
326: --
327: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
328: ' rows into the HR_EDW_WRK_CMPSTN_FSTG staging table');
329: edw_log.put_line('Date of Snapshot: ' || p_on_date);
330: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
331: edw_log.put_line(' ');

Line 329: edw_log.put_line('Date of Snapshot: ' || p_on_date);

325: l_duration := sysdate - l_temp_date;
326: --
327: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
328: ' rows into the HR_EDW_WRK_CMPSTN_FSTG staging table');
329: edw_log.put_line('Date of Snapshot: ' || p_on_date);
330: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
331: edw_log.put_line(' ');
332: --
333: commit;

Line 330: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));

326: --
327: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
328: ' rows into the HR_EDW_WRK_CMPSTN_FSTG staging table');
329: edw_log.put_line('Date of Snapshot: ' || p_on_date);
330: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
331: edw_log.put_line(' ');
332: --
333: commit;
334: --

Line 331: edw_log.put_line(' ');

327: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
328: ' rows into the HR_EDW_WRK_CMPSTN_FSTG staging table');
329: edw_log.put_line('Date of Snapshot: ' || p_on_date);
330: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
331: edw_log.put_line(' ');
332: --
333: commit;
334: --
335: END;

Line 480: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||

476: --
477: l_rows_inserted := sql%rowcount;
478: l_duration := sysdate - l_temp_date;
479: --
480: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
481: ' rows into the HR_EDW_WRK_CMPSTN_FSTG staging table');
482: edw_log.put_line('Date of Snapshot: ' || p_on_date);
483: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
484: edw_log.put_line(' ');

Line 482: edw_log.put_line('Date of Snapshot: ' || p_on_date);

478: l_duration := sysdate - l_temp_date;
479: --
480: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
481: ' rows into the HR_EDW_WRK_CMPSTN_FSTG staging table');
482: edw_log.put_line('Date of Snapshot: ' || p_on_date);
483: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
484: edw_log.put_line(' ');
485: --
486: commit;

Line 483: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));

479: --
480: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
481: ' rows into the HR_EDW_WRK_CMPSTN_FSTG staging table');
482: edw_log.put_line('Date of Snapshot: ' || p_on_date);
483: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
484: edw_log.put_line(' ');
485: --
486: commit;
487: --

Line 484: edw_log.put_line(' ');

480: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
481: ' rows into the HR_EDW_WRK_CMPSTN_FSTG staging table');
482: edw_log.put_line('Date of Snapshot: ' || p_on_date);
483: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
484: edw_log.put_line(' ');
485: --
486: commit;
487: --
488: END;

Line 609: edw_log.put_line('');

605:
606: /* If there are any issues, print report to log */
607: IF (l_no_missing_rates > 0) THEN
608:
609: edw_log.put_line('');
610: edw_log.put_line('Missing Rate Report');
611: edw_log.put_line('===================');
612: edw_log.put_line('');
613:

Line 610: edw_log.put_line('Missing Rate Report');

606: /* If there are any issues, print report to log */
607: IF (l_no_missing_rates > 0) THEN
608:
609: edw_log.put_line('');
610: edw_log.put_line('Missing Rate Report');
611: edw_log.put_line('===================');
612: edw_log.put_line('');
613:
614: edw_log.put_line('Issue Date Currency Name Number of rows');

Line 611: edw_log.put_line('===================');

607: IF (l_no_missing_rates > 0) THEN
608:
609: edw_log.put_line('');
610: edw_log.put_line('Missing Rate Report');
611: edw_log.put_line('===================');
612: edw_log.put_line('');
613:
614: edw_log.put_line('Issue Date Currency Name Number of rows');
615: edw_log.put_line('------------------ ----------- -------------------- --------------');

Line 612: edw_log.put_line('');

608:
609: edw_log.put_line('');
610: edw_log.put_line('Missing Rate Report');
611: edw_log.put_line('===================');
612: edw_log.put_line('');
613:
614: edw_log.put_line('Issue Date Currency Name Number of rows');
615: edw_log.put_line('------------------ ----------- -------------------- --------------');
616:

Line 614: edw_log.put_line('Issue Date Currency Name Number of rows');

610: edw_log.put_line('Missing Rate Report');
611: edw_log.put_line('===================');
612: edw_log.put_line('');
613:
614: edw_log.put_line('Issue Date Currency Name Number of rows');
615: edw_log.put_line('------------------ ----------- -------------------- --------------');
616:
617: FOR missing_rate IN rate_issues_csr LOOP
618:

Line 615: edw_log.put_line('------------------ ----------- -------------------- --------------');

611: edw_log.put_line('===================');
612: edw_log.put_line('');
613:
614: edw_log.put_line('Issue Date Currency Name Number of rows');
615: edw_log.put_line('------------------ ----------- -------------------- --------------');
616:
617: FOR missing_rate IN rate_issues_csr LOOP
618:
619: edw_log.put_line(missing_rate.collection_status ||

Line 619: edw_log.put_line(missing_rate.collection_status ||

615: edw_log.put_line('------------------ ----------- -------------------- --------------');
616:
617: FOR missing_rate IN rate_issues_csr LOOP
618:
619: edw_log.put_line(missing_rate.collection_status ||
620: missing_rate.snapshot_date ||
621: missing_rate.currency_name || ' ' ||
622: missing_rate.total);
623:

Line 626: edw_log.put_line('');

622: missing_rate.total);
623:
624: END LOOP;
625:
626: edw_log.put_line('');
627: edw_log.put_line('');
628:
629: END IF;
630:

Line 627: edw_log.put_line('');

623:
624: END LOOP;
625:
626: edw_log.put_line('');
627: edw_log.put_line('');
628:
629: END IF;
630:
631: END report_missing_rates;

Line 672: edw_log.put_line( 'The collection range is from '||

668: END IF;
669: --
670: l_date1 := g_push_date_range1;
671: l_date2 := g_push_date_range2;
672: edw_log.put_line( 'The collection range is from '||
673: to_char(l_date1,'MM/DD/YYYY HH24:MI:SS')||' to '||
674: to_char(l_date2,'MM/DD/YYYY HH24:MI:SS'));
675: edw_log.put_line(' ');
676: -- -----------------------------------------------------------------------------

Line 675: edw_log.put_line(' ');

671: l_date2 := g_push_date_range2;
672: edw_log.put_line( 'The collection range is from '||
673: to_char(l_date1,'MM/DD/YYYY HH24:MI:SS')||' to '||
674: to_char(l_date2,'MM/DD/YYYY HH24:MI:SS'));
675: edw_log.put_line(' ');
676: -- -----------------------------------------------------------------------------
677: -- Start of Collection , Developer Customizable Section
678: -- -----------------------------------------------------------------------------
679: edw_log.put_line(' ');

Line 679: edw_log.put_line(' ');

675: edw_log.put_line(' ');
676: -- -----------------------------------------------------------------------------
677: -- Start of Collection , Developer Customizable Section
678: -- -----------------------------------------------------------------------------
679: edw_log.put_line(' ');
680: edw_log.put_line('Pushing data');
681: --
682: /**************************************************************************/
683: /* Section to populate snapshot dates table */

Line 680: edw_log.put_line('Pushing data');

676: -- -----------------------------------------------------------------------------
677: -- Start of Collection , Developer Customizable Section
678: -- -----------------------------------------------------------------------------
679: edw_log.put_line(' ');
680: edw_log.put_line('Pushing data');
681: --
682: /**************************************************************************/
683: /* Section to populate snapshot dates table */
684: /**************************************************************************/