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

Line 147: edw_log.put_line('Dimension name is '||p_dim_name);

143: l_mode:=p_purge_option;
144: if l_mode is null then
145: l_mode:=0; -- 0 for delete, 1 for truncate
146: end if;
147: edw_log.put_line('Dimension name is '||p_dim_name);
148:
149: IF (l_mode=0) THEN
150: edw_log.put_line('Deleting loaded records in interface tables');
151: IF (p_dim_name IS NULL) THEN

Line 150: edw_log.put_line('Deleting loaded records in interface tables');

146: end if;
147: edw_log.put_line('Dimension name is '||p_dim_name);
148:
149: IF (l_mode=0) THEN
150: edw_log.put_line('Deleting loaded records in interface tables');
151: IF (p_dim_name IS NULL) THEN
152: Delete_All_Dimensions;
153: ELSE
154: Delete_One_Dimension(p_dim_name);

Line 157: edw_log.put_line('Truncating interface tables');

153: ELSE
154: Delete_One_Dimension(p_dim_name);
155: END IF;
156: ELSE
157: edw_log.put_line('Truncating interface tables');
158: IF (p_dim_name IS NULL) THEN
159: EDW_TRUNC_STG.Truncate_All_Dimensions;
160: ELSE
161: EDW_TRUNC_STG.Truncate_One_Dimension(p_dim_name);

Line 171: edw_log.put_line('Deleting staging tables for '||p_dim_name);

167:
168: BEGIN
169:
170: /* delete from the level staging tables */
171: edw_log.put_line('Deleting staging tables for '||p_dim_name);
172: FOR r1 IN dimm(p_dim_name) LOOP
173: Delete_Table(r1.table_name);
174: edw_log.put_line('Deleted staging table '||r1.table_name);
175: END LOOP;

Line 174: edw_log.put_line('Deleted staging table '||r1.table_name);

170: /* delete from the level staging tables */
171: edw_log.put_line('Deleting staging tables for '||p_dim_name);
172: FOR r1 IN dimm(p_dim_name) LOOP
173: Delete_Table(r1.table_name);
174: edw_log.put_line('Deleted staging table '||r1.table_name);
175: END LOOP;
176: END;
177:
178: Procedure Delete_All_Dimensions IS

Line 195: edw_log.put_line('Fact name is '||p_fact_name);

191: if l_mode is null then
192: l_mode:=0;
193: -- 0 for delete loaded recods, 1 for truncate all records
194: end if;
195: edw_log.put_line('Fact name is '||p_fact_name);
196:
197: IF (l_mode=0) THEN
198: edw_log.put_line('Deleting loaded records in interface tables');
199: IF (p_fact_name IS NULL) THEN

Line 198: edw_log.put_line('Deleting loaded records in interface tables');

194: end if;
195: edw_log.put_line('Fact name is '||p_fact_name);
196:
197: IF (l_mode=0) THEN
198: edw_log.put_line('Deleting loaded records in interface tables');
199: IF (p_fact_name IS NULL) THEN
200: Delete_All_Facts;
201: ELSE
202: Delete_One_fact(p_fact_name);

Line 205: edw_log.put_line('Truncating interface tables');

201: ELSE
202: Delete_One_fact(p_fact_name);
203: END IF;
204: ELSE
205: edw_log.put_line('Truncating interface tables');
206: IF (p_fact_name IS NULL) THEN
207: EDW_TRUNC_STG.Truncate_All_Facts;
208: ELSE
209: EDW_TRUNC_STG.Truncate_One_Fact(p_fact_name);

Line 219: edw_log.put_line('Deleting staging tables for '||p_fact_name);

215:
216: Procedure Delete_One_Fact(p_fact_name in varchar2) IS
217: l_staging_table varchar2(120) := null;
218: BEGIN
219: edw_log.put_line('Deleting staging tables for '||p_fact_name);
220: open factt(p_fact_name);
221: fetch factt into l_staging_table;
222: close factt;
223: Delete_Table(l_staging_table);

Line 224: edw_log.put_line('Deleted staging table '||l_staging_table);

220: open factt(p_fact_name);
221: fetch factt into l_staging_table;
222: close factt;
223: Delete_Table(l_staging_table);
224: edw_log.put_line('Deleted staging table '||l_staging_table);
225:
226: END;
227:
228: