APPS.EDW_GEOGRAPHY_M_C dependencies on EDW_GEOG_CITY_LSTG

Line 74: Push_EDW_GEOG_CITY_LSTG (g_push_date_range1, g_push_date_range2);

70: END IF;
71:
72: Push_GEOG_POSTCODE_CITY_LSTG(g_push_date_range1, g_push_date_range2);
73: Push_EDW_GEOG_LOCATION_LSTG (g_push_date_range1, g_push_date_range2);
74: Push_EDW_GEOG_CITY_LSTG (g_push_date_range1, g_push_date_range2);
75: Push_EDW_GEOG_POSTCODE_LSTG (g_push_date_range1, g_push_date_range2);
76: Push_GEOG_STATE_REGION_LSTG (g_push_date_range1, g_push_date_range2);
77: Push_EDW_GEOG_STATE_LSTG (g_push_date_range1, g_push_date_range2);
78: Push_EDW_GEOG_REGION_LSTG (g_push_date_range1, g_push_date_range2);

Line 290: Procedure Push_EDW_GEOG_CITY_LSTG(p_from_date IN date, p_to_date IN DATE) IS

286:
287: END;
288:
289:
290: Procedure Push_EDW_GEOG_CITY_LSTG(p_from_date IN date, p_to_date IN DATE) IS
291: l_date1 DATE;
292: l_date2 DATE;
293: l_rows_inserted NUMBER :=0;
294: BEGIN

Line 295: edw_log.put_line('Starting Push_EDW_GEOG_CITY_LSTG');

291: l_date1 DATE;
292: l_date2 DATE;
293: l_rows_inserted NUMBER :=0;
294: BEGIN
295: edw_log.put_line('Starting Push_EDW_GEOG_CITY_LSTG');
296:
297: -------- To get PK info from the warehouse (bug #1757640) ------
298:
299: g_stmt := 'TRUNCATE TABLE ' || g_schema || '.POA_EDW_TEMP_GEOG';

Line 313: EDW_GEOG_CITY_LSTG(

309:
310: l_date1 := p_from_date;
311: l_date2 := p_to_date;
312: Insert Into
313: EDW_GEOG_CITY_LSTG(
314: CITY_PK,
315: STATE_REGION_FK,
316: CITY_DP,
317: NAME,

Line 372: edw_log.put_line('Completed Push_EDW_GEOG_CITY_LSTG');

368:
369: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
370: ' rows into the staging table');
371:
372: edw_log.put_line('Completed Push_EDW_GEOG_CITY_LSTG');
373:
374: Exception When others then
375: rollback;
376: raise;