APPS.EDW_POA_SPLRITEM_M_C dependencies on EDW_LOG

Line 44: edw_log.put_line( 'The collection range is from '||

40: g_push_date_range2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
41:
42: l_date1 := g_push_date_range1;
43: l_date2 := g_push_date_range2;
44: edw_log.put_line( 'The collection range is from '||
45: to_char(l_date1,'MM/DD/YYYY HH24:MI:SS')||' to '||
46: to_char(l_date2,'MM/DD/YYYY HH24:MI:SS'));
47: edw_log.put_line(' ');
48:

Line 47: edw_log.put_line(' ');

43: l_date2 := g_push_date_range2;
44: edw_log.put_line( 'The collection range is from '||
45: to_char(l_date1,'MM/DD/YYYY HH24:MI:SS')||' to '||
46: to_char(l_date2,'MM/DD/YYYY HH24:MI:SS'));
47: edw_log.put_line(' ');
48:
49: -- -----------------------------------------------------------------------------
50: -- Start of Collection , Developer Customizable Section
51: -- -----------------------------------------------------------------------------

Line 53: edw_log.put_line(' ');

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:

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

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:

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

60:
61:
62: l_duration := sysdate - l_temp_date;
63:
64: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
65: edw_log.put_line(' ');
66: -- ---------------------------------------------------------------------------
67: -- END OF Collection , Developer Customizable Section
68: -- ---------------------------------------------------------------------------

Line 65: edw_log.put_line(' ');

61:
62: l_duration := sysdate - l_temp_date;
63:
64: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
65: edw_log.put_line(' ');
66: -- ---------------------------------------------------------------------------
67: -- END OF Collection , Developer Customizable Section
68: -- ---------------------------------------------------------------------------
69: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count, P_PERIOD_START => l_date1,

Line 91: edw_log.put_line('Starting Push_EDW_POA_SPIM_SPLRITEM_LSTG');

87: l_date1 DATE;
88: l_date2 DATE;
89: l_rows_inserted NUMBER :=0;
90: BEGIN
91: edw_log.put_line('Starting Push_EDW_POA_SPIM_SPLRITEM_LSTG');
92: l_date1 := p_from_date;
93: l_date2 := p_to_date;
94: Insert Into
95: EDW_POA_SPIM_SPLRITEM_LSTG@EDW_APPS_TO_WH(

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

133:
134: l_rows_inserted := sql%rowcount;
135: EDW_POA_SPLRITEM_M_C.g_row_count := EDW_POA_SPLRITEM_M_C.g_row_count + l_rows_inserted ;
136:
137: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
138: ' rows into the staging table');
139:
140: edw_log.put_line('Completed Push_EDW_POA_SPIM_SPLRITEM_LSTG');
141:

Line 140: edw_log.put_line('Completed Push_EDW_POA_SPIM_SPLRITEM_LSTG');

136:
137: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
138: ' rows into the staging table');
139:
140: edw_log.put_line('Completed Push_EDW_POA_SPIM_SPLRITEM_LSTG');
141:
142: Exception When others then
143: rollback;
144: raise;