41: EDW_OPI_LOT_M_C.g_push_date_range2 := to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS');
42: END IF;
43:
44:
45: edw_log.put_line( 'The collection range is from '||
46: to_char(EDW_OPI_LOT_M_C.g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||
47: to_char(EDW_OPI_LOT_M_C.g_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));
48: edw_log.put_line(' ');
49:
44:
45: edw_log.put_line( 'The collection range is from '||
46: to_char(EDW_OPI_LOT_M_C.g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||
47: to_char(EDW_OPI_LOT_M_C.g_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));
48: edw_log.put_line(' ');
49:
50: -- -----------------------------------------------------------------------------
51: -- Start of Collection , Developer Customizable Section
52: -- -----------------------------------------------------------------------------
50: -- -----------------------------------------------------------------------------
51: -- Start of Collection , Developer Customizable Section
52: -- -----------------------------------------------------------------------------
53:
54: edw_log.put_line(' ');
55: edw_log.put_line('Pushing data');
56:
57: l_temp_date := sysdate;
58:
51: -- Start of Collection , Developer Customizable Section
52: -- -----------------------------------------------------------------------------
53:
54: edw_log.put_line(' ');
55: edw_log.put_line('Pushing data');
56:
57: l_temp_date := sysdate;
58:
59:
61:
62:
63: l_duration := sysdate - l_temp_date;
64:
65: edw_log.put_line('Total rows inserted : '||g_row_count);
66: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
67: edw_log.put_line(' ');
68: -- ---------------------------------------------------------------------------
69: -- END OF Collection , Developer Customizable Section
62:
63: l_duration := sysdate - l_temp_date;
64:
65: edw_log.put_line('Total rows inserted : '||g_row_count);
66: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
67: edw_log.put_line(' ');
68: -- ---------------------------------------------------------------------------
69: -- END OF Collection , Developer Customizable Section
70: -- ---------------------------------------------------------------------------
63: l_duration := sysdate - l_temp_date;
64:
65: edw_log.put_line('Total rows inserted : '||g_row_count);
66: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
67: edw_log.put_line(' ');
68: -- ---------------------------------------------------------------------------
69: -- END OF Collection , Developer Customizable Section
70: -- ---------------------------------------------------------------------------
71: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count,EDW_OPI_LOT_M_C.g_exception_msg,
90: l_date1 DATE;
91: l_date2 DATE;
92: l_rows_inserted NUMBER :=0;
93: BEGIN
94: edw_log.put_line('Starting Push_EDW_OPI_LOTD_LOT_LSTG');
95: l_date1 := p_from_date;
96: l_date2 := p_to_date;
97: Insert Into
98: EDW_OPI_LOTD_LOT_LSTG@EDW_APPS_TO_WH(
145:
146:
147: l_rows_inserted := sql%rowcount;
148: EDW_OPI_LOT_M_C.g_row_count := EDW_OPI_LOT_M_C.g_row_count + l_rows_inserted ;
149: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
150: ' rows into the staging table');
151: edw_log.put_line('Commiting records for EDW_OPI_LOTD_LOT_LSTG');
152: commit;
153:
147: l_rows_inserted := sql%rowcount;
148: EDW_OPI_LOT_M_C.g_row_count := EDW_OPI_LOT_M_C.g_row_count + l_rows_inserted ;
149: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
150: ' rows into the staging table');
151: edw_log.put_line('Commiting records for EDW_OPI_LOTD_LOT_LSTG');
152: commit;
153:
154: edw_log.put_line('Completed Push_EDW_OPI_LOTD_LOT_LSTG');
155: Exception When others then
150: ' rows into the staging table');
151: edw_log.put_line('Commiting records for EDW_OPI_LOTD_LOT_LSTG');
152: commit;
153:
154: edw_log.put_line('Completed Push_EDW_OPI_LOTD_LOT_LSTG');
155: Exception When others then
156: raise;
157: commit;
158: END;