APPS.HR_EDW_WRK_RCTMNT_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 Recruitment Table');
57: hri_edw_fct_recruitment.populate_recruitment_table;
58: edw_log.put_line('Finished populating table');
59:

Line 56: edw_log.put_line('Populating Recruitment Table');

52: -- Start of Collection , Developer Customizable Section
53: -- -----------------------------------------------------------------------------
54:
55: edw_log.put_line(' ');
56: edw_log.put_line('Populating Recruitment Table');
57: hri_edw_fct_recruitment.populate_recruitment_table;
58: edw_log.put_line('Finished populating table');
59:
60: edw_log.put_line(' ');

Line 58: edw_log.put_line('Finished populating table');

54:
55: edw_log.put_line(' ');
56: edw_log.put_line('Populating Recruitment Table');
57: hri_edw_fct_recruitment.populate_recruitment_table;
58: edw_log.put_line('Finished populating table');
59:
60: edw_log.put_line(' ');
61: edw_log.put_line('Pushing data');
62:

Line 60: edw_log.put_line(' ');

56: edw_log.put_line('Populating Recruitment Table');
57: hri_edw_fct_recruitment.populate_recruitment_table;
58: edw_log.put_line('Finished populating table');
59:
60: edw_log.put_line(' ');
61: edw_log.put_line('Pushing data');
62:
63: l_temp_date := sysdate;
64: --

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

57: hri_edw_fct_recruitment.populate_recruitment_table;
58: edw_log.put_line('Finished populating table');
59:
60: edw_log.put_line(' ');
61: edw_log.put_line('Pushing data');
62:
63: l_temp_date := sysdate;
64: --
65: COMMIT;

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

297: WHERE last_update_date BETWEEN l_date1 AND l_date2
298: AND effective_start_date between l_date1 AND l_date2;
299: */
300:
301: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
302: ' rows into the staging table');
303: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
304: edw_log.put_line(' ');
305:

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

299: */
300:
301: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
302: ' rows into the staging table');
303: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
304: edw_log.put_line(' ');
305:
306: -- ---------------------------------------------------------------------------
307: -- END OF Collection , Developer Customizable Section

Line 304: edw_log.put_line(' ');

300:
301: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
302: ' rows into the staging table');
303: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
304: edw_log.put_line(' ');
305:
306: -- ---------------------------------------------------------------------------
307: -- END OF Collection , Developer Customizable Section
308: -- ---------------------------------------------------------------------------