eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.IEC_VALIDATE_PVT dependencies on IEC_TC_TZ_PAIRS_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 2108: delete from IEC_TC_TZ_PAIRS_CACHE;

2104:
2105:
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;

Line 4536: -- Update IEC_TC_TZ_PAIRS_CACHE for current contact point (increment record counts)

4532: BEGIN
4533:
4534:
4535:
4536: -- Update IEC_TC_TZ_PAIRS_CACHE for current contact point (increment record counts)
4537:
4538:
4539:
4540: FOR subset_rec IN (SELECT SUBSET_ID SUBSET_ID

Line 4576: 'UPDATE IEC_TC_TZ_PAIRS_CACHE

4572:
4573:
4574: EXECUTE IMMEDIATE
4575:
4576: 'UPDATE IEC_TC_TZ_PAIRS_CACHE
4577:
4578: SET RECORD_COUNT = NVL(RECORD_COUNT, 0) + :record_count_incr
4579:
4580: WHERE SUBSET_ID = :subset_id

Line 4608: 'UPDATE IEC_TC_TZ_PAIRS_CACHE

4604: ELSE
4605:
4606: EXECUTE IMMEDIATE
4607:
4608: 'UPDATE IEC_TC_TZ_PAIRS_CACHE
4609:
4610: SET RECORD_COUNT = NVL(RECORD_COUNT, 0) + :record_count_incr
4611:
4612: WHERE SUBSET_ID = :subset_id

Line 4658: 'INSERT INTO IEC_TC_TZ_PAIRS_CACHE

4654:
4655:
4656: EXECUTE IMMEDIATE
4657:
4658: 'INSERT INTO IEC_TC_TZ_PAIRS_CACHE
4659:
4660: ( SUBSET_ID
4661:
4662: , TERRITORY_CODE

Line 4710: -- Update IEC_TC_TZ_PAIRS_CACHE for contact points 1 through 6 (do not increment record counts)

4706: END LOOP;
4707:
4708:
4709:
4710: -- Update IEC_TC_TZ_PAIRS_CACHE for contact points 1 through 6 (do not increment record counts)
4711:
4712: l_cp_postfix.EXTEND(6);
4713:
4714: l_cp_postfix(1) := '_S1';

Line 4776: FROM IEC_TC_TZ_PAIRS_CACHE

4772: EXECUTE IMMEDIATE
4773:
4774: 'SELECT TC_TZ_PAIR_ID
4775:
4776: FROM IEC_TC_TZ_PAIRS_CACHE
4777:
4778: WHERE SUBSET_ID = :subset_id
4779:
4780: AND TERRITORY_CODE = :territory_code

Line 4804: FROM IEC_TC_TZ_PAIRS_CACHE

4800: EXECUTE IMMEDIATE
4801:
4802: 'SELECT TC_TZ_PAIR_ID
4803:
4804: FROM IEC_TC_TZ_PAIRS_CACHE
4805:
4806: WHERE SUBSET_ID = :subset_id
4807:
4808: AND TERRITORY_CODE = :territory_code

Line 4850: 'INSERT INTO IEC_TC_TZ_PAIRS_CACHE

4846:
4847:
4848: EXECUTE IMMEDIATE
4849:
4850: 'INSERT INTO IEC_TC_TZ_PAIRS_CACHE
4851:
4852: ( SUBSET_ID
4853:
4854: , TERRITORY_CODE

Line 4922: FROM IEC_TC_TZ_PAIRS_CACHE

4918: 'UPDATE IEC_VAL_ENTRY_CACHE A
4919:
4920: SET A.MKTG_ITEM_CC_TZS_ID_S1 = (SELECT TC_TZ_PAIR_ID
4921:
4922: FROM IEC_TC_TZ_PAIRS_CACHE
4923:
4924: WHERE SUBSET_ID = A.SUBSET_ID
4925:
4926: AND TERRITORY_CODE = A.TERRITORY_CODE_S1

Line 4938: FROM IEC_TC_TZ_PAIRS_CACHE

4934: AND CACHE_ONLY_FLAG <> ''O'')
4935:
4936: , A.MKTG_ITEM_CC_TZS_ID_S2 = (SELECT TC_TZ_PAIR_ID
4937:
4938: FROM IEC_TC_TZ_PAIRS_CACHE
4939:
4940: WHERE SUBSET_ID = A.SUBSET_ID
4941:
4942: AND TERRITORY_CODE = A.TERRITORY_CODE_S2

Line 4954: FROM IEC_TC_TZ_PAIRS_CACHE

4950: AND CACHE_ONLY_FLAG <> ''O'')
4951:
4952: , A.MKTG_ITEM_CC_TZS_ID_S3 = (SELECT TC_TZ_PAIR_ID
4953:
4954: FROM IEC_TC_TZ_PAIRS_CACHE
4955:
4956: WHERE SUBSET_ID = A.SUBSET_ID
4957:
4958: AND TERRITORY_CODE = A.TERRITORY_CODE_S3

Line 4970: FROM IEC_TC_TZ_PAIRS_CACHE

4966: AND CACHE_ONLY_FLAG <> ''O'')
4967:
4968: , A.MKTG_ITEM_CC_TZS_ID_S4 = (SELECT TC_TZ_PAIR_ID
4969:
4970: FROM IEC_TC_TZ_PAIRS_CACHE
4971:
4972: WHERE SUBSET_ID = A.SUBSET_ID
4973:
4974: AND TERRITORY_CODE = A.TERRITORY_CODE_S4

Line 4986: FROM IEC_TC_TZ_PAIRS_CACHE

4982: AND CACHE_ONLY_FLAG <> ''O'')
4983:
4984: , A.MKTG_ITEM_CC_TZS_ID_S5 = (SELECT TC_TZ_PAIR_ID
4985:
4986: FROM IEC_TC_TZ_PAIRS_CACHE
4987:
4988: WHERE SUBSET_ID = A.SUBSET_ID
4989:
4990: AND TERRITORY_CODE = A.TERRITORY_CODE_S5

Line 5002: FROM IEC_TC_TZ_PAIRS_CACHE

4998: AND CACHE_ONLY_FLAG <> ''O'')
4999:
5000: , A.MKTG_ITEM_CC_TZS_ID_S6 = (SELECT TC_TZ_PAIR_ID
5001:
5002: FROM IEC_TC_TZ_PAIRS_CACHE
5003:
5004: WHERE SUBSET_ID = A.SUBSET_ID
5005:
5006: AND TERRITORY_CODE = A.TERRITORY_CODE_S6

Line 5018: FROM IEC_TC_TZ_PAIRS_CACHE

5014: AND CACHE_ONLY_FLAG <> ''O'')
5015:
5016: , A.CURR_CP_MKTG_ITEM_CC_TZS_ID = (SELECT TC_TZ_PAIR_ID
5017:
5018: FROM IEC_TC_TZ_PAIRS_CACHE
5019:
5020: WHERE SUBSET_ID = A.SUBSET_ID
5021:
5022: AND TERRITORY_CODE = A.CURR_CP_TERRITORY_CODE

Line 5176: UPDATE IEC_TC_TZ_PAIRS_CACHE

5172: IF p_callable_zone_id_col.COUNT > 0 THEN
5173:
5174: FORALL i IN p_callable_zone_id_col.FIRST..p_callable_zone_id_col.LAST
5175:
5176: UPDATE IEC_TC_TZ_PAIRS_CACHE
5177:
5178: SET RECORD_COUNT = NVL(RECORD_COUNT, 0) + p_incr_amount_col(i)
5179:
5180: WHERE TC_TZ_PAIR_ID = p_callable_zone_id_col(i);

Line 5220: 'INSERT INTO IEC_TC_TZ_PAIRS_CACHE (SUBSET_ID, TERRITORY_CODE, REGION_ID, TIMEZONE_ID, TC_TZ_PAIR_ID, RECORD_COUNT, CACHE_ONLY_FLAG)

5216: -- LOAD IEC_G_MKTG_ITEM_CC_TZS RECORDS FOR CURRENT LIST INTO CACHE
5217:
5218: EXECUTE IMMEDIATE
5219:
5220: 'INSERT INTO IEC_TC_TZ_PAIRS_CACHE (SUBSET_ID, TERRITORY_CODE, REGION_ID, TIMEZONE_ID, TC_TZ_PAIR_ID, RECORD_COUNT, CACHE_ONLY_FLAG)
5221:
5222: SELECT SUBSET_ID, TERRITORY_CODE, REGION_ID, TIMEZONE_ID, ITM_CC_TZ_ID, 0, ''N''
5223:
5224: FROM IEC_G_MKTG_ITEM_CC_TZS

Line 5366: FROM IEC_TC_TZ_PAIRS_CACHE

5362: EXECUTE IMMEDIATE
5363:
5364: 'SELECT TERRITORY_CODE, REGION_ID, TIMEZONE_ID
5365:
5366: FROM IEC_TC_TZ_PAIRS_CACHE
5367:
5368: WHERE TC_TZ_PAIR_ID = :cc_tz_id'
5369:
5370: INTO l_territory_code, l_region_id, l_time_zone_id

Line 5486: FROM IEC_TC_TZ_PAIRS_CACHE

5482: SELECT SUBSET_ID, TERRITORY_CODE, REGION_ID, TIMEZONE_ID, TC_TZ_PAIR_ID, RECORD_COUNT
5483:
5484: BULK COLLECT INTO l_subset_id_col, l_territory_code_col, l_region_col, l_timezone_col, l_tc_tz_pair_id_col, l_record_count_col
5485:
5486: FROM IEC_TC_TZ_PAIRS_CACHE
5487:
5488: WHERE CACHE_ONLY_FLAG = 'Y';
5489:
5490:

Line 5556: FROM IEC_TC_TZ_PAIRS_CACHE

5552: SELECT TC_TZ_PAIR_ID, RECORD_COUNT
5553:
5554: BULK COLLECT INTO l_tc_tz_pair_id_col, l_record_count_col
5555:
5556: FROM IEC_TC_TZ_PAIRS_CACHE
5557:
5558: WHERE CACHE_ONLY_FLAG = 'N';
5559:
5560:

Line 5582: UPDATE IEC_TC_TZ_PAIRS_CACHE

5578:
5579:
5580: -- Update these records to reflect the fact that they now exist outside of the cache
5581:
5582: UPDATE IEC_TC_TZ_PAIRS_CACHE
5583:
5584: SET CACHE_ONLY_FLAG = 'N'
5585:
5586: WHERE CACHE_ONLY_FLAG = 'Y';

Line 5592: UPDATE IEC_TC_TZ_PAIRS_CACHE

5588:
5589:
5590: -- Clear record counts in cache to start fresh for next batch
5591:
5592: UPDATE IEC_TC_TZ_PAIRS_CACHE
5593:
5594: SET RECORD_COUNT = 0;
5595:
5596:

Line 16104: 'INSERT INTO IEC_TC_TZ_PAIRS_CACHE (SUBSET_ID, TERRITORY_CODE, REGION_ID, TIMEZONE_ID, TC_TZ_PAIR_ID, RECORD_COUNT, CACHE_ONLY_FLAG)

16100: -- used when assigning new callable zones (with subsets) to entries
16101:
16102: EXECUTE IMMEDIATE
16103:
16104: 'INSERT INTO IEC_TC_TZ_PAIRS_CACHE (SUBSET_ID, TERRITORY_CODE, REGION_ID, TIMEZONE_ID, TC_TZ_PAIR_ID, RECORD_COUNT, CACHE_ONLY_FLAG)
16105:
16106: SELECT SUBSET_ID, TERRITORY_CODE, REGION_ID, TIMEZONE_ID, ITM_CC_TZ_ID, RECORD_COUNT, ''O''
16107:
16108: FROM IEC_G_MKTG_ITEM_CC_TZS