APPS.EDW_GEOGRAPHY_M_C dependencies on EDW_GEOG_AREA1_LSTG

Line 81: Push_EDW_GEOG_AREA1_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:
84: l_duration := sysdate - l_temp_date;
85:

Line 936: Procedure Push_EDW_GEOG_AREA1_LSTG(p_from_date IN date, p_to_date IN DATE) IS

932:
933: END;
934:
935:
936: Procedure Push_EDW_GEOG_AREA1_LSTG(p_from_date IN date, p_to_date IN DATE) IS
937: l_date1 DATE;
938: l_date2 DATE;
939: l_rows_inserted NUMBER :=0;
940: l_tmp_str1 VARCHAR2 (120);

Line 943: edw_log.put_line('Starting Push_EDW_GEOG_AREA1_LSTG');

939: l_rows_inserted NUMBER :=0;
940: l_tmp_str1 VARCHAR2 (120);
941: l_tmp_str2 VARCHAR2 (120);
942: BEGIN
943: edw_log.put_line('Starting Push_EDW_GEOG_AREA1_LSTG');
944:
945: -------- To get PK info from the warehouse (bug #1757640) ------
946:
947: g_stmt := 'TRUNCATE TABLE ' || g_schema || '.POA_EDW_TEMP_GEOG';

Line 969: EDW_GEOG_AREA1_LSTG(

965: edw_log.put_line('***Warning*** : No Look Code Found From GET_LOOKUP_VALUE in Pushing AREA1');
966: end if;
967:
968: Insert Into
969: EDW_GEOG_AREA1_LSTG(
970: AREA1_PK,
971: ALL_FK,
972: AREA1_DP,
973: NAME,

Line 1009: edw_log.put_line('Completed Push_EDW_GEOG_AREA1_LSTG');

1005:
1006: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
1007: ' rows into the staging table');
1008:
1009: edw_log.put_line('Completed Push_EDW_GEOG_AREA1_LSTG');
1010:
1011: Exception When others then
1012: rollback;
1013: raise;