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_HR_RQN_VCNCY_M_C dependencies on EDW_LOG

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

40: EDW_HR_RQN_VCNCY_M_C.g_push_date_range2 := to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS');
41: END IF;
42:
43:
44: edw_log.put_line( 'The collection range is from '||
45: to_char(EDW_HR_RQN_VCNCY_M_C.g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||
46: to_char(EDW_HR_RQN_VCNCY_M_C.g_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));
47: edw_log.put_line(' ');
48:

Line 47: edw_log.put_line(' ');

43:
44: edw_log.put_line( 'The collection range is from '||
45: to_char(EDW_HR_RQN_VCNCY_M_C.g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||
46: to_char(EDW_HR_RQN_VCNCY_M_C.g_push_date_range2,'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 65: edw_log.put_line('Total rows inserted : '||g_row_count);

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

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

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: -- ---------------------------------------------------------------------------

Line 67: edw_log.put_line(' ');

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, null, g_push_date_range1, g_push_date_range2 );

Line 91: edw_log.put_line('Starting Push_EDW_HR_RQVC_VACANCY_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_HR_RQVC_VACANCY_LSTG');
92: l_date1 := p_from_date;
93: l_date2 := p_to_date;
94: Insert Into
95: EDW_HR_RQVC_VACANCY_LSTG@EDW_APPS_TO_WH(

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

148:
149:
150: l_rows_inserted := sql%rowcount;
151: EDW_HR_RQN_VCNCY_M_C.g_row_count := EDW_HR_RQN_VCNCY_M_C.g_row_count + l_rows_inserted ;
152: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
153: ' rows into the EDW_HR_RQVC_VACANCY_LSTG staging table');
154: edw_log.put_line('Commiting records for EDW_HR_RQVC_VACANCY_LSTG');
155: commit;
156:

Line 154: edw_log.put_line('Commiting records for EDW_HR_RQVC_VACANCY_LSTG');

150: l_rows_inserted := sql%rowcount;
151: EDW_HR_RQN_VCNCY_M_C.g_row_count := EDW_HR_RQN_VCNCY_M_C.g_row_count + l_rows_inserted ;
152: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
153: ' rows into the EDW_HR_RQVC_VACANCY_LSTG staging table');
154: edw_log.put_line('Commiting records for EDW_HR_RQVC_VACANCY_LSTG');
155: commit;
156:
157: edw_log.put_line('Completed Push_EDW_HR_RQVC_VACANCY_LSTG');
158: Exception When others then

Line 157: edw_log.put_line('Completed Push_EDW_HR_RQVC_VACANCY_LSTG');

153: ' rows into the EDW_HR_RQVC_VACANCY_LSTG staging table');
154: edw_log.put_line('Commiting records for EDW_HR_RQVC_VACANCY_LSTG');
155: commit;
156:
157: edw_log.put_line('Completed Push_EDW_HR_RQVC_VACANCY_LSTG');
158: Exception When others then
159: raise;
160: commit;
161: END;

Line 169: edw_log.put_line('Starting Push_EDW_HR_RQVC_REQUISTN_LSTG');

165: l_date1 DATE;
166: l_date2 DATE;
167: l_rows_inserted NUMBER :=0;
168: BEGIN
169: edw_log.put_line('Starting Push_EDW_HR_RQVC_REQUISTN_LSTG');
170: l_date1 := p_from_date;
171: l_date2 := p_to_date;
172: Insert Into
173: EDW_HR_RQVC_REQUISTN_LSTG@EDW_APPS_TO_WH(

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

211: where last_update_date between l_date1 and l_date2;
212:
213:
214: l_rows_inserted := sql%rowcount;
215: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
216: ' rows into the EDW_HR_RQVC_REQUISTN_LSTG staging table');
217: edw_log.put_line('Commiting records for EDW_HR_RQVC_REQUISTN_LSTG');
218: commit;
219:

Line 217: edw_log.put_line('Commiting records for EDW_HR_RQVC_REQUISTN_LSTG');

213:
214: l_rows_inserted := sql%rowcount;
215: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
216: ' rows into the EDW_HR_RQVC_REQUISTN_LSTG staging table');
217: edw_log.put_line('Commiting records for EDW_HR_RQVC_REQUISTN_LSTG');
218: commit;
219:
220: edw_log.put_line('Completed Push_EDW_HR_RQVC_REQUISTN_LSTG');
221: Exception When others then

Line 220: edw_log.put_line('Completed Push_EDW_HR_RQVC_REQUISTN_LSTG');

216: ' rows into the EDW_HR_RQVC_REQUISTN_LSTG staging table');
217: edw_log.put_line('Commiting records for EDW_HR_RQVC_REQUISTN_LSTG');
218: commit;
219:
220: edw_log.put_line('Completed Push_EDW_HR_RQVC_REQUISTN_LSTG');
221: Exception When others then
222: raise;
223: commit;
224: END;