40: EDW_HR_AGE_BAND_M_C.g_push_date_range2 := to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS');
41: END IF;
42:
43:
44: edw_log.put_line( 'The collection range is from '||
45: to_char(EDW_HR_AGE_BAND_M_C.g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||
46: to_char(EDW_HR_AGE_BAND_M_C.g_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));
47: edw_log.put_line(' ');
48:
43:
44: edw_log.put_line( 'The collection range is from '||
45: to_char(EDW_HR_AGE_BAND_M_C.g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||
46: to_char(EDW_HR_AGE_BAND_M_C.g_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));
47: edw_log.put_line(' ');
48:
49: -- -----------------------------------------------------------------------------
50: -- Start of Collection , Developer Customizable Section
51: -- -----------------------------------------------------------------------------
49: -- -----------------------------------------------------------------------------
50: -- Start of Collection , Developer Customizable Section
51: -- -----------------------------------------------------------------------------
52:
53: edw_log.put_line(' ');
54: edw_log.put_line('Pushing data');
55:
56: l_temp_date := sysdate;
57:
50: -- Start of Collection , Developer Customizable Section
51: -- -----------------------------------------------------------------------------
52:
53: edw_log.put_line(' ');
54: edw_log.put_line('Pushing data');
55:
56: l_temp_date := sysdate;
57:
58:
60:
61:
62: l_duration := sysdate - l_temp_date;
63:
64: edw_log.put_line('Total rows inserted : '||g_row_count);
65: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
66: edw_log.put_line(' ');
67: -- ---------------------------------------------------------------------------
68: -- END OF Collection , Developer Customizable Section
61:
62: l_duration := sysdate - l_temp_date;
63:
64: edw_log.put_line('Total rows inserted : '||g_row_count);
65: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
66: edw_log.put_line(' ');
67: -- ---------------------------------------------------------------------------
68: -- END OF Collection , Developer Customizable Section
69: -- ---------------------------------------------------------------------------
62: l_duration := sysdate - l_temp_date;
63:
64: edw_log.put_line('Total rows inserted : '||g_row_count);
65: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
66: edw_log.put_line(' ');
67: -- ---------------------------------------------------------------------------
68: -- END OF Collection , Developer Customizable Section
69: -- ---------------------------------------------------------------------------
70: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count, null, g_push_date_range1, g_push_date_range2 );
86: l_date1 DATE;
87: l_date2 DATE;
88: l_rows_inserted NUMBER :=0;
89: BEGIN
90: edw_log.put_line('Starting Push_EDW_HR_AGE_AGE_BAND_LSTG');
91: l_date1 := p_from_date;
92: l_date2 := p_to_date;
93: Insert Into
94: EDW_HR_AGE_AGE_BAND_LSTG@EDW_APPS_TO_WH(
137:
138:
139: l_rows_inserted := sql%rowcount;
140: EDW_HR_AGE_BAND_M_C.g_row_count := EDW_HR_AGE_BAND_M_C.g_row_count + l_rows_inserted ;
141: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
142: ' rows into the EDW_HR_AGE_AGE_BAND_LSTG staging table');
143: edw_log.put_line('Commiting records for EDW_HR_AGE_AGE_BAND_LSTG');
144: commit;
145:
139: l_rows_inserted := sql%rowcount;
140: EDW_HR_AGE_BAND_M_C.g_row_count := EDW_HR_AGE_BAND_M_C.g_row_count + l_rows_inserted ;
141: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
142: ' rows into the EDW_HR_AGE_AGE_BAND_LSTG staging table');
143: edw_log.put_line('Commiting records for EDW_HR_AGE_AGE_BAND_LSTG');
144: commit;
145:
146: edw_log.put_line('Completed Push_EDW_HR_AGE_AGE_BAND_LSTG');
147: Exception When others then
142: ' rows into the EDW_HR_AGE_AGE_BAND_LSTG staging table');
143: edw_log.put_line('Commiting records for EDW_HR_AGE_AGE_BAND_LSTG');
144: commit;
145:
146: edw_log.put_line('Completed Push_EDW_HR_AGE_AGE_BAND_LSTG');
147: Exception When others then
148: raise;
149: commit;
150: END;