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_SPRTN_F_C dependencies on EDW_LOG

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

42:
43:
44: l_date1 := g_push_date_range1;
45: l_date2 := g_push_date_range2;
46: edw_log.put_line( 'The collection range is from '||
47: to_char(l_date1,'MM/DD/YYYY HH24:MI:SS')||' to '||
48: to_char(l_date2,'MM/DD/YYYY HH24:MI:SS'));
49: edw_log.put_line(' ');
50:

Line 49: edw_log.put_line(' ');

45: l_date2 := g_push_date_range2;
46: edw_log.put_line( 'The collection range is from '||
47: to_char(l_date1,'MM/DD/YYYY HH24:MI:SS')||' to '||
48: to_char(l_date2,'MM/DD/YYYY HH24:MI:SS'));
49: edw_log.put_line(' ');
50:
51: -- -----------------------------------------------------------------------------
52: -- Start of Collection , Developer Customizable Section
53: -- -----------------------------------------------------------------------------

Line 55: edw_log.put_line(' ');

51: -- -----------------------------------------------------------------------------
52: -- Start of Collection , Developer Customizable Section
53: -- -----------------------------------------------------------------------------
54:
55: edw_log.put_line(' ');
56: edw_log.put_line('Populating separation reason types');
57: commit;
58: hri_edw_fct_wrkfc_sprtn.populate_sep_rsns;
59: commit;

Line 56: edw_log.put_line('Populating separation reason types');

52: -- Start of Collection , Developer Customizable Section
53: -- -----------------------------------------------------------------------------
54:
55: edw_log.put_line(' ');
56: edw_log.put_line('Populating separation reason types');
57: commit;
58: hri_edw_fct_wrkfc_sprtn.populate_sep_rsns;
59: commit;
60: edw_log.put_line('Finished populating separation reason types');

Line 60: edw_log.put_line('Finished populating separation reason types');

56: edw_log.put_line('Populating separation reason types');
57: commit;
58: hri_edw_fct_wrkfc_sprtn.populate_sep_rsns;
59: commit;
60: edw_log.put_line('Finished populating separation reason types');
61:
62: edw_log.put_line(' ');
63: edw_log.put_line('Populating separation performance table');
64: hri_edw_fct_wrkfc_sprtn.populate_hri_prd_of_srvce;

Line 62: edw_log.put_line(' ');

58: hri_edw_fct_wrkfc_sprtn.populate_sep_rsns;
59: commit;
60: edw_log.put_line('Finished populating separation reason types');
61:
62: edw_log.put_line(' ');
63: edw_log.put_line('Populating separation performance table');
64: hri_edw_fct_wrkfc_sprtn.populate_hri_prd_of_srvce;
65: edw_log.put_line('Finished populating separation performance table');
66:

Line 63: edw_log.put_line('Populating separation performance table');

59: commit;
60: edw_log.put_line('Finished populating separation reason types');
61:
62: edw_log.put_line(' ');
63: edw_log.put_line('Populating separation performance table');
64: hri_edw_fct_wrkfc_sprtn.populate_hri_prd_of_srvce;
65: edw_log.put_line('Finished populating separation performance table');
66:
67: edw_log.put_line(' ');

Line 65: edw_log.put_line('Finished populating separation performance table');

61:
62: edw_log.put_line(' ');
63: edw_log.put_line('Populating separation performance table');
64: hri_edw_fct_wrkfc_sprtn.populate_hri_prd_of_srvce;
65: edw_log.put_line('Finished populating separation performance table');
66:
67: edw_log.put_line(' ');
68: edw_log.put_line('Pushing data');
69: commit;

Line 67: edw_log.put_line(' ');

63: edw_log.put_line('Populating separation performance table');
64: hri_edw_fct_wrkfc_sprtn.populate_hri_prd_of_srvce;
65: edw_log.put_line('Finished populating separation performance table');
66:
67: edw_log.put_line(' ');
68: edw_log.put_line('Pushing data');
69: commit;
70:
71: l_temp_date := sysdate;

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

64: hri_edw_fct_wrkfc_sprtn.populate_hri_prd_of_srvce;
65: edw_log.put_line('Finished populating separation performance table');
66:
67: edw_log.put_line(' ');
68: edw_log.put_line('Pushing data');
69: commit;
70:
71: l_temp_date := sysdate;
72: commit;

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

287: commit;
288: --
289: l_duration := sysdate - l_temp_date;
290:
291: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
292: ' rows into the staging table');
293: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
294: edw_log.put_line(' ');
295:

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

289: l_duration := sysdate - l_temp_date;
290:
291: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
292: ' rows into the staging table');
293: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
294: edw_log.put_line(' ');
295:
296: -- ---------------------------------------------------------------------------
297: -- END OF Collection , Developer Customizable Section

Line 294: edw_log.put_line(' ');

290:
291: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
292: ' rows into the staging table');
293: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
294: edw_log.put_line(' ');
295:
296: -- ---------------------------------------------------------------------------
297: -- END OF Collection , Developer Customizable Section
298: -- ---------------------------------------------------------------------------