APPS.EDW_GEOGRAPHY_M_C dependencies on EDW_GEOG_REGION_LSTG

Line 78: Push_EDW_GEOG_REGION_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);
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:

Line 663: Procedure Push_EDW_GEOG_REGION_LSTG(p_from_date IN date, p_to_date IN DATE) IS

659:
660: END;
661:
662:
663: Procedure Push_EDW_GEOG_REGION_LSTG(p_from_date IN date, p_to_date IN DATE) IS
664: l_date1 DATE;
665: l_date2 DATE;
666: l_rows_inserted NUMBER :=0;
667: l_tmp_str VARCHAR2 (120);

Line 669: edw_log.put_line('Starting Push_EDW_GEOG_REGION_LSTG');

665: l_date2 DATE;
666: l_rows_inserted NUMBER :=0;
667: l_tmp_str VARCHAR2 (120);
668: BEGIN
669: edw_log.put_line('Starting Push_EDW_GEOG_REGION_LSTG');
670:
671: -------- To get PK info from the warehouse (bug #1757640) ------
672:
673: g_stmt := 'TRUNCATE TABLE ' || g_schema || '.POA_EDW_TEMP_GEOG';

Line 694: EDW_GEOG_REGION_LSTG(

690: edw_log.put_line('***Warning*** : No Look Code Found From GET_LOOKUP_VALUE in Pushing REGION');
691: end if;
692:
693: Insert Into
694: EDW_GEOG_REGION_LSTG(
695: REGION_PK,
696: COUNTRY_FK,
697: REGION_DP,
698: NAME,

Line 753: edw_log.put_line('Completed Push_EDW_GEOG_REGION_LSTG');

749:
750: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
751: ' rows into the staging table');
752:
753: edw_log.put_line('Completed Push_EDW_GEOG_REGION_LSTG');
754:
755: Exception When others then
756: rollback;
757: raise;