APPS.EDW_GEOGRAPHY_M_C dependencies on EDW_GEOG_POSTCODE_LSTG

Line 75: Push_EDW_GEOG_POSTCODE_LSTG (g_push_date_range1, g_push_date_range2);

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);
79: Push_EDW_GEOG_COUNTRY_LSTG (g_push_date_range1, g_push_date_range2);

Line 381: Procedure Push_EDW_GEOG_POSTCODE_LSTG(p_from_date IN date, p_to_date IN DATE) IS

377:
378: END;
379:
380:
381: Procedure Push_EDW_GEOG_POSTCODE_LSTG(p_from_date IN date, p_to_date IN DATE) IS
382: l_date1 DATE;
383: l_date2 DATE;
384: l_rows_inserted NUMBER :=0;
385: BEGIN

Line 386: edw_log.put_line('Starting Push_EDW_GEOG_POSTCODE_LSTG');

382: l_date1 DATE;
383: l_date2 DATE;
384: l_rows_inserted NUMBER :=0;
385: BEGIN
386: edw_log.put_line('Starting Push_EDW_GEOG_POSTCODE_LSTG');
387:
388: -------- To get PK info from the warehouse (bug #1757640) ------
389:
390: g_stmt := 'TRUNCATE TABLE ' || g_schema || '.POA_EDW_TEMP_GEOG';

Line 404: EDW_GEOG_POSTCODE_LSTG(

400:
401: l_date1 := p_from_date;
402: l_date2 := p_to_date;
403: Insert Into
404: EDW_GEOG_POSTCODE_LSTG(
405: STATE_REGION_FK,
406: NAME,
407: INSTANCE,
408: USER_ATTRIBUTE1,

Line 463: edw_log.put_line('Completed Push_EDW_GEOG_POSTCODE_LSTG');

459:
460: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
461: ' rows into the staging table');
462:
463: edw_log.put_line('Completed Push_EDW_GEOG_POSTCODE_LSTG');
464:
465: Exception When others then
466: rollback;
467: raise;