APPS.IEC_VALIDATE_PVT dependencies on IEC_TZ_OFFSET_MAP_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 2091: delete from IEC_TZ_OFFSET_MAP_CACHE;

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;
2094:
2095: COMMIT;

Line 2988: 'INSERT INTO IEC_TZ_OFFSET_MAP_CACHE (OFFSET, TIMEZONE_ID) VALUES (:timezone_offset, :timezone)'

2984: BEGIN
2985:
2986: EXECUTE IMMEDIATE
2987:
2988: 'INSERT INTO IEC_TZ_OFFSET_MAP_CACHE (OFFSET, TIMEZONE_ID) VALUES (:timezone_offset, :timezone)'
2989:
2990: USING l_data_value_col(l_count), l_data_value_col(l_count + 1);
2991:
2992: EXCEPTION

Line 7096: FROM IEC_TZ_OFFSET_MAP_CACHE

7092: EXECUTE IMMEDIATE
7093:
7094: 'SELECT TIMEZONE_ID
7095:
7096: FROM IEC_TZ_OFFSET_MAP_CACHE
7097:
7098: WHERE OFFSET = :timezone
7099:
7100: AND ROWNUM = 1'

Line 7158: FROM IEC_TZ_OFFSET_MAP_CACHE

7154: EXECUTE IMMEDIATE
7155:
7156: 'SELECT TIMEZONE_ID
7157:
7158: FROM IEC_TZ_OFFSET_MAP_CACHE
7159:
7160: WHERE UPPER(OFFSET) = :timezone
7161:
7162: AND ROWNUM = 1'