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

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

40: EDW_HR_PRSN_TYP_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_PRSN_TYP_M_C.g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||
46: to_char(EDW_HR_PRSN_TYP_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_PRSN_TYP_M_C.g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||
46: to_char(EDW_HR_PRSN_TYP_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('Populating HRI Person Type table');
55: HRI_EDW_DIM_PERSON_TYPE.populate_person_types;
56: edw_log.put_line('Finished populating table');
57:

Line 54: edw_log.put_line('Populating HRI Person Type table');

50: -- Start of Collection , Developer Customizable Section
51: -- -----------------------------------------------------------------------------
52:
53: edw_log.put_line(' ');
54: edw_log.put_line('Populating HRI Person Type table');
55: HRI_EDW_DIM_PERSON_TYPE.populate_person_types;
56: edw_log.put_line('Finished populating table');
57:
58: edw_log.put_line(' ');

Line 56: edw_log.put_line('Finished populating table');

52:
53: edw_log.put_line(' ');
54: edw_log.put_line('Populating HRI Person Type table');
55: HRI_EDW_DIM_PERSON_TYPE.populate_person_types;
56: edw_log.put_line('Finished populating table');
57:
58: edw_log.put_line(' ');
59: edw_log.put_line('Pushing data');
60:

Line 58: edw_log.put_line(' ');

54: edw_log.put_line('Populating HRI Person Type table');
55: HRI_EDW_DIM_PERSON_TYPE.populate_person_types;
56: edw_log.put_line('Finished populating table');
57:
58: edw_log.put_line(' ');
59: edw_log.put_line('Pushing data');
60:
61: l_temp_date := sysdate;
62:

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

55: HRI_EDW_DIM_PERSON_TYPE.populate_person_types;
56: edw_log.put_line('Finished populating table');
57:
58: edw_log.put_line(' ');
59: edw_log.put_line('Pushing data');
60:
61: l_temp_date := sysdate;
62:
63:

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

65:
66:
67: l_duration := sysdate - l_temp_date;
68:
69: edw_log.put_line('Total rows inserted : '||g_row_count);
70: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
71: edw_log.put_line(' ');
72: -- ---------------------------------------------------------------------------
73: -- END OF Collection , Developer Customizable Section

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

66:
67: l_duration := sysdate - l_temp_date;
68:
69: edw_log.put_line('Total rows inserted : '||g_row_count);
70: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
71: edw_log.put_line(' ');
72: -- ---------------------------------------------------------------------------
73: -- END OF Collection , Developer Customizable Section
74: -- ---------------------------------------------------------------------------

Line 71: edw_log.put_line(' ');

67: l_duration := sysdate - l_temp_date;
68:
69: edw_log.put_line('Total rows inserted : '||g_row_count);
70: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
71: edw_log.put_line(' ');
72: -- ---------------------------------------------------------------------------
73: -- END OF Collection , Developer Customizable Section
74: -- ---------------------------------------------------------------------------
75: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count, null, g_push_date_range1, g_push_date_range2 );

Line 95: edw_log.put_line('Starting Push_EDW_HR_PTYP_PRSN_TYP_LSTG');

91: l_date1 DATE;
92: l_date2 DATE;
93: l_rows_inserted NUMBER :=0;
94: BEGIN
95: edw_log.put_line('Starting Push_EDW_HR_PTYP_PRSN_TYP_LSTG');
96: l_date1 := p_from_date;
97: l_date2 := p_to_date;
98:
99: -- Set collect to date to sysdate below so that changes to the collected

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

227:
228:
229: l_rows_inserted := sql%rowcount;
230: EDW_HR_PRSN_TYP_M_C.g_row_count := EDW_HR_PRSN_TYP_M_C.g_row_count + l_rows_inserted ;
231: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
232: ' rows into the EDW_HR_PTYP_PRSN_TYP_LSTG staging table');
233: edw_log.put_line('Commiting records for EDW_HR_PTYP_PRSN_TYP_LSTG');
234: commit;
235:

Line 233: edw_log.put_line('Commiting records for EDW_HR_PTYP_PRSN_TYP_LSTG');

229: l_rows_inserted := sql%rowcount;
230: EDW_HR_PRSN_TYP_M_C.g_row_count := EDW_HR_PRSN_TYP_M_C.g_row_count + l_rows_inserted ;
231: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
232: ' rows into the EDW_HR_PTYP_PRSN_TYP_LSTG staging table');
233: edw_log.put_line('Commiting records for EDW_HR_PTYP_PRSN_TYP_LSTG');
234: commit;
235:
236: edw_log.put_line('Completed Push_EDW_HR_PTYP_PRSN_TYP_LSTG');
237: Exception When others then

Line 236: edw_log.put_line('Completed Push_EDW_HR_PTYP_PRSN_TYP_LSTG');

232: ' rows into the EDW_HR_PTYP_PRSN_TYP_LSTG staging table');
233: edw_log.put_line('Commiting records for EDW_HR_PTYP_PRSN_TYP_LSTG');
234: commit;
235:
236: edw_log.put_line('Completed Push_EDW_HR_PTYP_PRSN_TYP_LSTG');
237: Exception When others then
238: raise;
239: commit;
240: END;