APPS.EDW_GEOGRAPHY_M_C dependencies on EDW_GEOG_COUNTRY_LSTG

Line 79: Push_EDW_GEOG_COUNTRY_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);
80: Push_EDW_GEOG_AREA2_LSTG (g_push_date_range1, g_push_date_range2);
81: Push_EDW_GEOG_AREA1_LSTG (g_push_date_range1, g_push_date_range2);
82:
83:

Line 762: Procedure Push_EDW_GEOG_COUNTRY_LSTG(p_from_date IN date, p_to_date IN DATE) IS

758:
759: END;
760:
761:
762: Procedure Push_EDW_GEOG_COUNTRY_LSTG(p_from_date IN date, p_to_date IN DATE) IS
763: l_date1 DATE;
764: l_date2 DATE;
765: l_rows_inserted NUMBER :=0;
766: BEGIN

Line 767: edw_log.put_line('Starting Push_EDW_GEOG_COUNTRY_LSTG');

763: l_date1 DATE;
764: l_date2 DATE;
765: l_rows_inserted NUMBER :=0;
766: BEGIN
767: edw_log.put_line('Starting Push_EDW_GEOG_COUNTRY_LSTG');
768:
769: -------- To get PK info from the warehouse (bug #1757640) ------
770:
771: g_stmt := 'TRUNCATE TABLE ' || g_schema || '.POA_EDW_TEMP_GEOG';

Line 785: EDW_GEOG_COUNTRY_LSTG(

781:
782: l_date1 := p_from_date;
783: l_date2 := p_to_date;
784: Insert Into
785: EDW_GEOG_COUNTRY_LSTG(
786: COUNTRY_PK,
787: AREA2_FK,
788: COUNTRY_DP,
789: NAME,

Line 844: edw_log.put_line('Completed Push_EDW_GEOG_COUNTRY_LSTG');

840:
841: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
842: ' rows into the staging table');
843:
844: edw_log.put_line('Completed Push_EDW_GEOG_COUNTRY_LSTG');
845:
846: Exception When others then
847: rollback;
848: raise;