APPS.IEC_VALIDATE_PVT dependencies on IEC_TZ_MAPPING_CACHE

Line 2055: WHERE TABLE_NAME IN ('IEC_TC_TZ_PAIRS_CACHE', 'IEC_TZ_MAPPING_CACHE', 'IEC_TZ_OFFSET_MAP_CACHE', 'IEC_VAL_ENTRY_CACHE')

2051: SELECT 'TRUNCATE TABLE ' || OWNER || '.' || TABLE_NAME SQLSTMT
2052:
2053: FROM ALL_TABLES
2054:
2055: WHERE TABLE_NAME IN ('IEC_TC_TZ_PAIRS_CACHE', 'IEC_TZ_MAPPING_CACHE', 'IEC_TZ_OFFSET_MAP_CACHE', 'IEC_VAL_ENTRY_CACHE')
2056:
2057: AND OWNER = table_owner;
2058:
2059:

Line 2089: delete from IEC_TZ_MAPPING_CACHE;

2085: DBMS_SQL.CLOSE_CURSOR(l_ddl_csr); */
2086:
2087: delete from IEC_TC_TZ_PAIRS_CACHE;
2088:
2089: delete from IEC_TZ_MAPPING_CACHE;
2090:
2091: delete from IEC_TZ_OFFSET_MAP_CACHE;
2092:
2093: delete from IEC_VAL_ENTRY_CACHE;

Line 3020: INSERT INTO IEC_TZ_MAPPING_CACHE

3016:
3017:
3018: IF g_enable_zc_lookups THEN
3019:
3020: INSERT INTO IEC_TZ_MAPPING_CACHE
3021:
3022: (TERRITORY_CODE, AREA_CODE, POSTAL_CODE, TIMEZONE_ID)
3023:
3024: SELECT DISTINCT TERRITORY_CODE, PHONE_AREA_CODE, POSTAL_CODE, TIMEZONE_ID

Line 3030: INSERT INTO IEC_TZ_MAPPING_CACHE

3026: FROM IEC_G_TIMEZONE_MAPPINGS;
3027:
3028: ELSE
3029:
3030: INSERT INTO IEC_TZ_MAPPING_CACHE
3031:
3032: (TERRITORY_CODE, AREA_CODE, POSTAL_CODE, TIMEZONE_ID)
3033:
3034: SELECT DISTINCT TERRITORY_CODE, PHONE_AREA_CODE, NULL, TIMEZONE_ID

Line 6974: FROM IEC_TZ_MAPPING_CACHE

6970: EXECUTE IMMEDIATE
6971:
6972: 'SELECT DISTINCT TIMEZONE_ID
6973:
6974: FROM IEC_TZ_MAPPING_CACHE
6975:
6976: WHERE TERRITORY_CODE = :territory_code
6977:
6978: AND (AREA_CODE = :area_code OR AREA_CODE IS NULL)'

Line 7018: FROM IEC_TZ_MAPPING_CACHE

7014: EXECUTE IMMEDIATE
7015:
7016: 'SELECT DISTINCT TIMEZONE_ID
7017:
7018: FROM IEC_TZ_MAPPING_CACHE
7019:
7020: WHERE TERRITORY_CODE = :territory_code
7021:
7022: AND AREA_CODE = :area_code