eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EDW_OPI_OPRN_M_C dependencies on EDW_LOG

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

35: EDW_OPI_OPRN_M_C.g_push_date_range2 := EDW_COLLECTION_UTIL.G_local_curr_push_start_date;
36: ELSE
37: EDW_OPI_OPRN_M_C.g_push_date_range2 := to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS');
38: END IF;
39: edw_log.put_line( 'The collection range is from '||
40: to_char(EDW_OPI_OPRN_M_C.g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||
41: to_char(EDW_OPI_OPRN_M_C.g_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));
42: edw_log.put_line(' ');
43: -- -----------------------------------------------------------------------------

Line 42: edw_log.put_line(' ');

38: END IF;
39: edw_log.put_line( 'The collection range is from '||
40: to_char(EDW_OPI_OPRN_M_C.g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||
41: to_char(EDW_OPI_OPRN_M_C.g_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));
42: edw_log.put_line(' ');
43: -- -----------------------------------------------------------------------------
44: -- Start of Collection , Developer Customizable Section
45: -- -----------------------------------------------------------------------------
46: edw_log.put_line(' ');

Line 46: edw_log.put_line(' ');

42: edw_log.put_line(' ');
43: -- -----------------------------------------------------------------------------
44: -- Start of Collection , Developer Customizable Section
45: -- -----------------------------------------------------------------------------
46: edw_log.put_line(' ');
47: edw_log.put_line('Pushing data');
48: l_temp_date := sysdate;
49: Push_EDW_OPI_OPRN_OPRN_LSTG(EDW_OPI_OPRN_M_C.g_push_date_range1, EDW_OPI_OPRN_M_C.g_push_date_range2);
50: Push_EDW_OPI_OPRN_OPRC_LSTG(EDW_OPI_OPRN_M_C.g_push_date_range1, EDW_OPI_OPRN_M_C.g_push_date_range2);

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

43: -- -----------------------------------------------------------------------------
44: -- Start of Collection , Developer Customizable Section
45: -- -----------------------------------------------------------------------------
46: edw_log.put_line(' ');
47: edw_log.put_line('Pushing data');
48: l_temp_date := sysdate;
49: Push_EDW_OPI_OPRN_OPRN_LSTG(EDW_OPI_OPRN_M_C.g_push_date_range1, EDW_OPI_OPRN_M_C.g_push_date_range2);
50: Push_EDW_OPI_OPRN_OPRC_LSTG(EDW_OPI_OPRN_M_C.g_push_date_range1, EDW_OPI_OPRN_M_C.g_push_date_range2);
51: l_duration := sysdate - l_temp_date;

Line 52: edw_log.put_line('Total rows inserted : '||g_row_count);

48: l_temp_date := sysdate;
49: Push_EDW_OPI_OPRN_OPRN_LSTG(EDW_OPI_OPRN_M_C.g_push_date_range1, EDW_OPI_OPRN_M_C.g_push_date_range2);
50: Push_EDW_OPI_OPRN_OPRC_LSTG(EDW_OPI_OPRN_M_C.g_push_date_range1, EDW_OPI_OPRN_M_C.g_push_date_range2);
51: l_duration := sysdate - l_temp_date;
52: edw_log.put_line('Total rows inserted : '||g_row_count);
53: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
54: edw_log.put_line(' ');
55: -- ---------------------------------------------------------------------------
56: -- END OF Collection , Developer Customizable Section

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

49: Push_EDW_OPI_OPRN_OPRN_LSTG(EDW_OPI_OPRN_M_C.g_push_date_range1, EDW_OPI_OPRN_M_C.g_push_date_range2);
50: Push_EDW_OPI_OPRN_OPRC_LSTG(EDW_OPI_OPRN_M_C.g_push_date_range1, EDW_OPI_OPRN_M_C.g_push_date_range2);
51: l_duration := sysdate - l_temp_date;
52: edw_log.put_line('Total rows inserted : '||g_row_count);
53: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
54: edw_log.put_line(' ');
55: -- ---------------------------------------------------------------------------
56: -- END OF Collection , Developer Customizable Section
57: -- ---------------------------------------------------------------------------

Line 54: edw_log.put_line(' ');

50: Push_EDW_OPI_OPRN_OPRC_LSTG(EDW_OPI_OPRN_M_C.g_push_date_range1, EDW_OPI_OPRN_M_C.g_push_date_range2);
51: l_duration := sysdate - l_temp_date;
52: edw_log.put_line('Total rows inserted : '||g_row_count);
53: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
54: edw_log.put_line(' ');
55: -- ---------------------------------------------------------------------------
56: -- END OF Collection , Developer Customizable Section
57: -- ---------------------------------------------------------------------------
58: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count,EDW_OPI_OPRN_M_C.g_exception_msg,

Line 79: edw_log.put_line('Starting Push_EDW_OPI_OPRN_OPRN_LSTG');

75: l_date1 DATE;
76: l_date2 DATE;
77: l_rows_inserted NUMBER :=0;
78: BEGIN
79: edw_log.put_line('Starting Push_EDW_OPI_OPRN_OPRN_LSTG');
80: l_date1 := p_from_date;
81: l_date2 := p_to_date;
82: Insert Into
83: EDW_OPI_OPRN_OPRN_LSTG@EDW_APPS_TO_WH(

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

121: from EDW_OPI_OPRN_OPRN_LCV@APPS_TO_APPS
122: where last_update_date between l_date1 and l_date2;
123: l_rows_inserted := sql%rowcount;
124: EDW_OPI_OPRN_M_C.g_row_count := EDW_OPI_OPRN_M_C.g_row_count + l_rows_inserted ;
125: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
126: ' rows into the staging table');
127: edw_log.put_line('Commiting records into EDW_OPI_OPRN_OPRN_LSTG');
128: commit;
129: edw_log.put_line('Completed Push_EDW_OPI_OPRN_OPRN_LSTG');

Line 127: edw_log.put_line('Commiting records into EDW_OPI_OPRN_OPRN_LSTG');

123: l_rows_inserted := sql%rowcount;
124: EDW_OPI_OPRN_M_C.g_row_count := EDW_OPI_OPRN_M_C.g_row_count + l_rows_inserted ;
125: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
126: ' rows into the staging table');
127: edw_log.put_line('Commiting records into EDW_OPI_OPRN_OPRN_LSTG');
128: commit;
129: edw_log.put_line('Completed Push_EDW_OPI_OPRN_OPRN_LSTG');
130: Exception When others then
131: raise;

Line 129: edw_log.put_line('Completed Push_EDW_OPI_OPRN_OPRN_LSTG');

125: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
126: ' rows into the staging table');
127: edw_log.put_line('Commiting records into EDW_OPI_OPRN_OPRN_LSTG');
128: commit;
129: edw_log.put_line('Completed Push_EDW_OPI_OPRN_OPRN_LSTG');
130: Exception When others then
131: raise;
132: commit;
133: END;

Line 140: edw_log.put_line('Starting Push_EDW_OPI_OPRN_OPRC_LSTG');

136: l_date1 DATE;
137: l_date2 DATE;
138: l_rows_inserted NUMBER :=0;
139: BEGIN
140: edw_log.put_line('Starting Push_EDW_OPI_OPRN_OPRC_LSTG');
141: l_date1 := p_from_date;
142: l_date2 := p_to_date;
143: Insert Into
144: EDW_OPI_OPRN_OPRC_LSTG@EDW_APPS_TO_WH(

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

174: from EDW_OPI_OPRN_OPRC_LCV@APPS_TO_APPS
175: where last_update_date between l_date1 and l_date2;
176: l_rows_inserted := sql%rowcount;
177: EDW_OPI_OPRN_M_C.g_row_count := EDW_OPI_OPRN_M_C.g_row_count + l_rows_inserted ;
178: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
179: ' rows into the staging table');
180: edw_log.put_line('Commiting records into EDW_OPI_OPRN_OPRC_LSTG');
181: commit;
182: edw_log.put_line('Completed Push_EDW_OPI_OPRN_OPRC_LSTG');

Line 180: edw_log.put_line('Commiting records into EDW_OPI_OPRN_OPRC_LSTG');

176: l_rows_inserted := sql%rowcount;
177: EDW_OPI_OPRN_M_C.g_row_count := EDW_OPI_OPRN_M_C.g_row_count + l_rows_inserted ;
178: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
179: ' rows into the staging table');
180: edw_log.put_line('Commiting records into EDW_OPI_OPRN_OPRC_LSTG');
181: commit;
182: edw_log.put_line('Completed Push_EDW_OPI_OPRN_OPRC_LSTG');
183: Exception When others then
184: raise;

Line 182: edw_log.put_line('Completed Push_EDW_OPI_OPRN_OPRC_LSTG');

178: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
179: ' rows into the staging table');
180: edw_log.put_line('Commiting records into EDW_OPI_OPRN_OPRC_LSTG');
181: commit;
182: edw_log.put_line('Completed Push_EDW_OPI_OPRN_OPRC_LSTG');
183: Exception When others then
184: raise;
185: commit;
186: END;