APPS.EDW_MRP_FORECAST_M_C dependencies on EDW_LOG

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

31: END IF;
32: EDW_MRP_FORECAST_M_C.g_push_date_range1 := nvl(l_from_date,
33: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
34: EDW_MRP_FORECAST_M_C.g_push_date_range2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
35: edw_log.put_line( 'The collection range is from '||
36: to_char(EDW_MRP_FORECAST_M_C.g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||
37: to_char(EDW_MRP_FORECAST_M_C.g_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));
38: edw_log.put_line(' ');
39: /* REM ---------------------------------------------------------------------

Line 38: edw_log.put_line(' ');

34: EDW_MRP_FORECAST_M_C.g_push_date_range2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
35: edw_log.put_line( 'The collection range is from '||
36: to_char(EDW_MRP_FORECAST_M_C.g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||
37: to_char(EDW_MRP_FORECAST_M_C.g_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));
38: edw_log.put_line(' ');
39: /* REM ---------------------------------------------------------------------
40: REM Start of Collection , Developer Customizable Section
41: REM --------------------------------------------------------------------- */
42: edw_log.put_line(' ');

Line 42: edw_log.put_line(' ');

38: edw_log.put_line(' ');
39: /* REM ---------------------------------------------------------------------
40: REM Start of Collection , Developer Customizable Section
41: REM --------------------------------------------------------------------- */
42: edw_log.put_line(' ');
43: edw_log.put_line('Pushing data');
44:
45: l_temp_date := sysdate;
46:

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

39: /* REM ---------------------------------------------------------------------
40: REM Start of Collection , Developer Customizable Section
41: REM --------------------------------------------------------------------- */
42: edw_log.put_line(' ');
43: edw_log.put_line('Pushing data');
44:
45: l_temp_date := sysdate;
46:
47:

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

50:
51:
52: l_duration := sysdate - l_temp_date;
53:
54: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
55: edw_log.put_line(' ');
56: /* ---------------------------------------------------------------------------
57: REM END OF Collection , Developer Customizable Section
58: REM ---------------------------------------------------------------------------

Line 55: edw_log.put_line(' ');

51:
52: l_duration := sysdate - l_temp_date;
53:
54: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
55: edw_log.put_line(' ');
56: /* ---------------------------------------------------------------------------
57: REM END OF Collection , Developer Customizable Section
58: REM ---------------------------------------------------------------------------
59: */

Line 81: edw_log.put_line('Starting Push_EDW_MRP_FCDM_FCS_LSTG');

77: l_date1 DATE;
78: l_date2 DATE;
79: l_rows_inserted NUMBER :=0;
80: BEGIN
81: edw_log.put_line('Starting Push_EDW_MRP_FCDM_FCS_LSTG');
82: l_date1 := p_from_date;
83: l_date2 := p_to_date;
84: Insert Into
85: EDW_MRP_FCDM_FCS_LSTG@EDW_APPS_TO_WH(

Line 122: edw_log.put_line('Commiting records for EDW_MRP_FCDM_FCS_LSTG');

118:
119:
120: l_rows_inserted := sql%rowcount;
121: EDW_MRP_FORECAST_M_C.g_row_count := l_rows_inserted ;
122: edw_log.put_line('Commiting records for EDW_MRP_FCDM_FCS_LSTG');
123: commit;
124:
125: edw_log.put_line('Completed Push_EDW_MRP_FCDM_FCS_LSTG');
126: Exception When others then

Line 125: edw_log.put_line('Completed Push_EDW_MRP_FCDM_FCS_LSTG');

121: EDW_MRP_FORECAST_M_C.g_row_count := l_rows_inserted ;
122: edw_log.put_line('Commiting records for EDW_MRP_FCDM_FCS_LSTG');
123: commit;
124:
125: edw_log.put_line('Completed Push_EDW_MRP_FCDM_FCS_LSTG');
126: Exception When others then
127: raise;
128: commit;
129: END;

Line 137: edw_log.put_line('Starting Push_EDW_MRP_FCDM_SET_LSTG');

133: l_date1 DATE;
134: l_date2 DATE;
135: l_rows_inserted NUMBER :=0;
136: BEGIN
137: edw_log.put_line('Starting Push_EDW_MRP_FCDM_SET_LSTG');
138: l_date1 := p_from_date;
139: l_date2 := p_to_date;
140: Insert Into
141: EDW_MRP_FCDM_SET_LSTG@EDW_APPS_TO_WH(

Line 178: edw_log.put_line('Commiting records for EDW_MRP_FCDM_SET_LSTG');

174:
175:
176: l_rows_inserted := sql%rowcount;
177:
178: edw_log.put_line('Commiting records for EDW_MRP_FCDM_SET_LSTG');
179: commit;
180:
181: edw_log.put_line('Completed Push_EDW_MRP_FCDM_SET_LSTG');
182: Exception When others then

Line 181: edw_log.put_line('Completed Push_EDW_MRP_FCDM_SET_LSTG');

177:
178: edw_log.put_line('Commiting records for EDW_MRP_FCDM_SET_LSTG');
179: commit;
180:
181: edw_log.put_line('Completed Push_EDW_MRP_FCDM_SET_LSTG');
182: Exception When others then
183: raise;
184: commit;
185: END;