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

Line 71: edw_log.put_line( 'Push for User Defined dimension : '||p_dimension);

67: ELSE
68: g_push_date_range2 := to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS');
69: END IF;
70:
71: edw_log.put_line( 'Push for User Defined dimension : '||p_dimension);
72: edw_log.put_line( 'The push range is from '||
73: to_char(EDW_FLEX_PUSH_C.g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||
74: to_char(EDW_FLEX_PUSH_C.g_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));
75: edw_log.put_line(' ');

Line 72: edw_log.put_line( 'The push range is from '||

68: g_push_date_range2 := to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS');
69: END IF;
70:
71: edw_log.put_line( 'Push for User Defined dimension : '||p_dimension);
72: edw_log.put_line( 'The push range is from '||
73: to_char(EDW_FLEX_PUSH_C.g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||
74: to_char(EDW_FLEX_PUSH_C.g_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));
75: edw_log.put_line(' ');
76:

Line 75: edw_log.put_line(' ');

71: edw_log.put_line( 'Push for User Defined dimension : '||p_dimension);
72: edw_log.put_line( 'The push range is from '||
73: to_char(EDW_FLEX_PUSH_C.g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||
74: to_char(EDW_FLEX_PUSH_C.g_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));
75: edw_log.put_line(' ');
76:
77: -- -----------------------------------------------------------------------------
78: -- Start of Collection , Developer Customizable Section
79: -- -----------------------------------------------------------------------------

Line 81: edw_log.put_line(' ');

77: -- -----------------------------------------------------------------------------
78: -- Start of Collection , Developer Customizable Section
79: -- -----------------------------------------------------------------------------
80:
81: edw_log.put_line(' ');
82: l_temp_date := sysdate;
83:
84: -- -----------------------------------------------------------------------------
85: -- Call Push_Levels to push the two levels.

Line 94: edw_log.put_line('Total rows inserted for '||g_dimension||' : '||g_row_count);

90: l_duration := sysdate - l_temp_date;
91:
92: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count, null, g_push_date_range1, g_push_date_range2);
93:
94: edw_log.put_line('Total rows inserted for '||g_dimension||' : '||g_row_count);
95: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
96: edw_log.put_line(' ');
97:
98: commit;

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

91:
92: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count, null, g_push_date_range1, g_push_date_range2);
93:
94: edw_log.put_line('Total rows inserted for '||g_dimension||' : '||g_row_count);
95: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
96: edw_log.put_line(' ');
97:
98: commit;
99:

Line 96: edw_log.put_line(' ');

92: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count, null, g_push_date_range1, g_push_date_range2);
93:
94: edw_log.put_line('Total rows inserted for '||g_dimension||' : '||g_row_count);
95: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
96: edw_log.put_line(' ');
97:
98: commit;
99:
100: Exception When others then

Line 131: edw_log.put_line('Starting Push For EDW_FLEX_DIM'||g_index||'_L'||p_level||'_LSTG');

127: l_target_link VARCHAR2(128);
128:
129: BEGIN
130:
131: edw_log.put_line('Starting Push For EDW_FLEX_DIM'||g_index||'_L'||p_level||'_LSTG');
132:
133: -- get databaselink
134: EDW_COLLECTION_UTIL.get_dblink_names(l_source_link, l_target_link);
135:

Line 151: edw_log.put_line('Insert statement is : '|| stmt);

147: /* if null then set to from_date + 0.1 seconds */
148: stmt := stmt ||' where NVL(last_update_date, to_date('''||
149: to_char(p_from_date,'MM/DD/YYYY HH24:MI:SS')||''','''|| 'MM/DD/YYYY HH24:MI:SS'||''''||')+1/864000) between :p_from_date and :p_to_date';
150:
151: edw_log.put_line('Insert statement is : '|| stmt);
152:
153: cid := DBMS_SQL.open_cursor;
154: DBMS_SQL.PARSE(cid, stmt, dbms_sql.native);
155: edw_log.put_line('Parsed stmt');

Line 155: edw_log.put_line('Parsed stmt');

151: edw_log.put_line('Insert statement is : '|| stmt);
152:
153: cid := DBMS_SQL.open_cursor;
154: DBMS_SQL.PARSE(cid, stmt, dbms_sql.native);
155: edw_log.put_line('Parsed stmt');
156:
157:
158: DBMS_SQL.BIND_VARIABLE(cid, ':p_from_date', p_from_date);
159: DBMS_SQL.BIND_VARIABLE(cid, ':p_to_date', p_to_date);

Line 164: edw_log.put_line('Inserted '||l_dummy|| ' rows into the staging table');

160: l_dummy := DBMS_SQL.EXECUTE(cid);
161: DBMS_SQL.close_cursor(cid);
162: commit;
163: g_row_count := g_row_count + l_dummy;
164: edw_log.put_line('Inserted '||l_dummy|| ' rows into the staging table');
165: edw_log.put_line('Commiting records for EDW_FLEX_DIM'||g_index||'_L'||p_level||'_LSTG');
166:
167: commit;
168:

Line 165: edw_log.put_line('Commiting records for EDW_FLEX_DIM'||g_index||'_L'||p_level||'_LSTG');

161: DBMS_SQL.close_cursor(cid);
162: commit;
163: g_row_count := g_row_count + l_dummy;
164: edw_log.put_line('Inserted '||l_dummy|| ' rows into the staging table');
165: edw_log.put_line('Commiting records for EDW_FLEX_DIM'||g_index||'_L'||p_level||'_LSTG');
166:
167: commit;
168:
169: edw_log.put_line('Completed Push_EDW_FLEX_DIM'||g_index||'_L'||p_level||'_LSTG'||newline||newline);

Line 169: edw_log.put_line('Completed Push_EDW_FLEX_DIM'||g_index||'_L'||p_level||'_LSTG'||newline||newline);

165: edw_log.put_line('Commiting records for EDW_FLEX_DIM'||g_index||'_L'||p_level||'_LSTG');
166:
167: commit;
168:
169: edw_log.put_line('Completed Push_EDW_FLEX_DIM'||g_index||'_L'||p_level||'_LSTG'||newline||newline);
170:
171: Exception When others then
172: raise;
173: commit;