DBA Data[Home] [Help]

APPS.HR_EDW_WRK_ACTVTY_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('Pushing data');
57: --
58: COMMIT;
59: --

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

52: -- Start of Collection , Developer Customizable Section
53: -- -----------------------------------------------------------------------------
54:
55: edw_log.put_line(' ');
56: edw_log.put_line('Pushing data');
57: --
58: COMMIT;
59: --
60: l_temp_date := sysdate;

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

319: COMMIT;
320: l_duration := sysdate - l_temp_date;
321: --
322:
323: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
324: ' rows into the staging table');
325: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
326: edw_log.put_line(' ');
327:

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

321: --
322:
323: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
324: ' rows into the staging table');
325: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
326: edw_log.put_line(' ');
327:
328: -- ---------------------------------------------------------------------------
329: -- END OF Collection , Developer Customizable Section

Line 326: edw_log.put_line(' ');

322:
323: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
324: ' rows into the staging table');
325: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
326: edw_log.put_line(' ');
327:
328: -- ---------------------------------------------------------------------------
329: -- END OF Collection , Developer Customizable Section
330: -- ---------------------------------------------------------------------------