APPS.EDW_GEOGRAPHY_M_C dependencies on EDW_GEOG_LOCATION_LSTG

Line 73: Push_EDW_GEOG_LOCATION_LSTG (g_push_date_range1, g_push_date_range2);

69: RAISE_APPLICATION_ERROR (-20001, '***There is not POA schema set up***');
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);

Line 107: Procedure Push_EDW_GEOG_LOCATION_LSTG(p_from_date IN date, p_to_date IN DATE) IS

103: g_push_date_range1, g_push_date_range2);
104: End;
105:
106:
107: Procedure Push_EDW_GEOG_LOCATION_LSTG(p_from_date IN date, p_to_date IN DATE) IS
108: l_date1 DATE;
109: l_date2 DATE;
110: l_rows_inserted NUMBER :=0;
111: BEGIN

Line 112: edw_log.put_line('Starting Push_EDW_GEOG_LOCATION_LSTG');

108: l_date1 DATE;
109: l_date2 DATE;
110: l_rows_inserted NUMBER :=0;
111: BEGIN
112: edw_log.put_line('Starting Push_EDW_GEOG_LOCATION_LSTG');
113: l_date1 := p_from_date;
114: l_date2 := p_to_date;
115: Insert Into
116: EDW_GEOG_LOCATION_LSTG(

Line 116: EDW_GEOG_LOCATION_LSTG(

112: edw_log.put_line('Starting Push_EDW_GEOG_LOCATION_LSTG');
113: l_date1 := p_from_date;
114: l_date2 := p_to_date;
115: Insert Into
116: EDW_GEOG_LOCATION_LSTG(
117: ADDRESS_LINE_1,
118: ADDRESS_LINE_2,
119: ADDRESS_LINE_3,
120: ADDRESS_LINE_4,

Line 183: edw_log.put_line('Completed Push_EDW_GEOG_LOCATION_LSTG');

179:
180: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
181: ' rows into the staging table');
182:
183: edw_log.put_line('Completed Push_EDW_GEOG_LOCATION_LSTG');
184:
185: EDW_GEOGRAPHY_M_C.g_row_count_m := l_rows_inserted;
186:
187: Exception When others then