APPS.EDW_GEOGRAPHY_M_C dependencies on EDW_GEOG_POSTCODE_CITY_LSTG

Line 174: from EDW_GEOG_POSTCODE_CITY_LSTG

170: USER_ATTRIBUTE4,
171: USER_ATTRIBUTE5,
172: NULL,
173: 'READY'
174: from EDW_GEOG_POSTCODE_CITY_LSTG
175: where collection_status='READY');
176:
177: l_rows_inserted := sql%rowcount;
178: EDW_GEOGRAPHY_M_C.g_row_count := EDW_GEOGRAPHY_M_C.g_row_count + l_rows_inserted ;

Line 199: edw_log.put_line('Starting Push_EDW_GEOG_POSTCODE_CITY_LSTG');

195: l_date1 DATE;
196: l_date2 DATE;
197: l_rows_inserted NUMBER :=0;
198: BEGIN
199: edw_log.put_line('Starting Push_EDW_GEOG_POSTCODE_CITY_LSTG');
200:
201:
202: -------- To get PK info from the warehouse (bug #1757640) ------
203:

Line 219: EDW_GEOG_POSTCODE_CITY_LSTG(

215: l_date1 := p_from_date;
216: l_date2 := p_to_date;
217:
218: Insert Into
219: EDW_GEOG_POSTCODE_CITY_LSTG(
220: INSTANCE,
221: USER_ATTRIBUTE1,
222: USER_ATTRIBUTE2,
223: USER_ATTRIBUTE3,

Line 281: edw_log.put_line('Completed Push_EDW_GEOG_POSTCODE_CITY_LSTG');

277:
278: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
279: ' rows into the staging table');
280:
281: edw_log.put_line('Completed Push_EDW_GEOG_POSTCODE_CITY_LSTG');
282:
283: Exception When others then
284: rollback;
285: raise;