30:
31: l_push_date_range1 := nvl(l_from_date,
32: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
33: l_push_date_range2 := nvl(l_to_date, EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
34: edw_log.put_line( 'The collection range is from '||
35: to_char(l_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||
36: to_char(l_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));
37: edw_log.put_line(' ');
38:
33: l_push_date_range2 := nvl(l_to_date, EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
34: edw_log.put_line( 'The collection range is from '||
35: to_char(l_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||
36: to_char(l_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));
37: edw_log.put_line(' ');
38:
39: Edw_POA_LN_TYPE_M_C.Push_LN_TYPE(Errbuf, Retcode, L_push_date_range1,l_push_date_range2);
40:
41:
80:
81: -- -----------------------------------------------------------------------------
82: -- Start of Collection , Developer Customizable Section
83: -- -----------------------------------------------------------------------------
84: edw_log.put_line(' ');
85: edw_log.put_line('Pushing data');
86:
87: l_temp_date := sysdate;
88:
81: -- -----------------------------------------------------------------------------
82: -- Start of Collection , Developer Customizable Section
83: -- -----------------------------------------------------------------------------
84: edw_log.put_line(' ');
85: edw_log.put_line('Pushing data');
86:
87: l_temp_date := sysdate;
88:
89: Insert Into EDW_POA_LNTP_LN_TYPE_LSTG@EDW_APPS_TO_WH(
136:
137: l_rows_inserted := sql%rowcount;
138: l_duration := sysdate - l_temp_date;
139:
140: edw_log.put_line('Inserted '||to_char(nvl(l_rows_inserted,0))||
141: ' rows into the staging table');
142: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
143: edw_log.put_line(' ');
144:
138: l_duration := sysdate - l_temp_date;
139:
140: edw_log.put_line('Inserted '||to_char(nvl(l_rows_inserted,0))||
141: ' rows into the staging table');
142: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
143: edw_log.put_line(' ');
144:
145: -- ---------------------------------------------------------------------------
146: -- END OF Collection , Developer Customizable Section
139:
140: edw_log.put_line('Inserted '||to_char(nvl(l_rows_inserted,0))||
141: ' rows into the staging table');
142: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
143: edw_log.put_line(' ');
144:
145: -- ---------------------------------------------------------------------------
146: -- END OF Collection , Developer Customizable Section
147: -- ---------------------------------------------------------------------------