APPS.IEC_VALIDATE_PVT dependencies on IEC_TZ_MAPPING_CACHE

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

2071: SELECT 'TRUNCATE TABLE ' || OWNER || '.' || TABLE_NAME SQLSTMT
2072:
2073: FROM ALL_TABLES
2074:
2075: WHERE TABLE_NAME IN ('IEC_TC_TZ_PAIRS_CACHE', 'IEC_TZ_MAPPING_CACHE', 'IEC_TZ_OFFSET_MAP_CACHE', 'IEC_VAL_ENTRY_CACHE')
2076:
2077: AND OWNER = table_owner;
2078:
2079:

Line 2110: delete from IEC_TZ_MAPPING_CACHE;

2106: DBMS_SQL.CLOSE_CURSOR(l_ddl_csr); */
2107:
2108: delete from IEC_TC_TZ_PAIRS_CACHE;
2109:
2110: delete from IEC_TZ_MAPPING_CACHE;
2111:
2112: delete from IEC_TZ_OFFSET_MAP_CACHE;
2113:
2114: delete from IEC_VAL_ENTRY_CACHE;

Line 3042: INSERT INTO IEC_TZ_MAPPING_CACHE

3038:
3039:
3040: IF g_enable_zc_lookups THEN
3041:
3042: INSERT INTO IEC_TZ_MAPPING_CACHE
3043:
3044: (TERRITORY_CODE, AREA_CODE, POSTAL_CODE, TIMEZONE_ID)
3045:
3046: SELECT DISTINCT TERRITORY_CODE, PHONE_AREA_CODE, POSTAL_CODE, TIMEZONE_ID

Line 3052: INSERT INTO IEC_TZ_MAPPING_CACHE

3048: FROM IEC_G_TIMEZONE_MAPPINGS;
3049:
3050: ELSE
3051:
3052: INSERT INTO IEC_TZ_MAPPING_CACHE
3053:
3054: (TERRITORY_CODE, AREA_CODE, POSTAL_CODE, TIMEZONE_ID)
3055:
3056: SELECT DISTINCT TERRITORY_CODE, PHONE_AREA_CODE, NULL, TIMEZONE_ID

Line 6996: FROM IEC_TZ_MAPPING_CACHE

6992: EXECUTE IMMEDIATE
6993:
6994: 'SELECT DISTINCT TIMEZONE_ID
6995:
6996: FROM IEC_TZ_MAPPING_CACHE
6997:
6998: WHERE TERRITORY_CODE = :territory_code
6999:
7000: AND (AREA_CODE = :area_code OR AREA_CODE IS NULL)'

Line 7040: FROM IEC_TZ_MAPPING_CACHE

7036: EXECUTE IMMEDIATE
7037:
7038: 'SELECT DISTINCT TIMEZONE_ID
7039:
7040: FROM IEC_TZ_MAPPING_CACHE
7041:
7042: WHERE TERRITORY_CODE = :territory_code
7043:
7044: AND AREA_CODE = :area_code