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_VAL_ENTRY_CACHE

Line 1985: WHERE TABLE_NAME = 'IEC_VAL_ENTRY_CACHE'

1981: SELECT 'TRUNCATE TABLE ' || OWNER || '.' || TABLE_NAME SQLSTMT
1982:
1983: FROM ALL_TABLES
1984:
1985: WHERE TABLE_NAME = 'IEC_VAL_ENTRY_CACHE'
1986:
1987: AND OWNER = table_owner;
1988:
1989:

Line 2023: delete from IEC_VAL_ENTRY_CACHE;

2019:
2020:
2021: COMMIT; */
2022:
2023: delete from IEC_VAL_ENTRY_CACHE;
2024:
2025: COMMIT;
2026:
2027: /* End of fix for bug7622572 */

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 2093: delete from IEC_VAL_ENTRY_CACHE;

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;
2096:
2097: EXCEPTION

Line 4174: FROM IEC_VAL_ENTRY_CACHE B WHERE A.LIST_ENTRY_ID = B.LIST_ENTRY_ID

4170: CONTACT_POINT_ID_S5, TIME_ZONE_S5, PHONE_COUNTRY_CODE_S5, PHONE_AREA_CODE_S5, PHONE_NUMBER_S5, RAW_PHONE_NUMBER_S5, MKTG_ITEM_CC_TZS_ID_S5,
4171:
4172: CONTACT_POINT_ID_S6, TIME_ZONE_S6, PHONE_COUNTRY_CODE_S6, PHONE_AREA_CODE_S6, PHONE_NUMBER_S6, RAW_PHONE_NUMBER_S6, MKTG_ITEM_CC_TZS_ID_S6
4173:
4174: FROM IEC_VAL_ENTRY_CACHE B WHERE A.LIST_ENTRY_ID = B.LIST_ENTRY_ID
4175:
4176: )
4177:
4178: WHERE LIST_HEADER_ID = :list_id AND LIST_ENTRY_ID IN (SELECT LIST_ENTRY_ID FROM IEC_VAL_ENTRY_CACHE);

Line 4178: WHERE LIST_HEADER_ID = :list_id AND LIST_ENTRY_ID IN (SELECT LIST_ENTRY_ID FROM IEC_VAL_ENTRY_CACHE);

4174: FROM IEC_VAL_ENTRY_CACHE B WHERE A.LIST_ENTRY_ID = B.LIST_ENTRY_ID
4175:
4176: )
4177:
4178: WHERE LIST_HEADER_ID = :list_id AND LIST_ENTRY_ID IN (SELECT LIST_ENTRY_ID FROM IEC_VAL_ENTRY_CACHE);
4179:
4180: END;'
4181:
4182: USING p_list_id;

Line 4274: FROM IEC_VAL_ENTRY_CACHE B WHERE A.LIST_ENTRY_ID = B.LIST_ENTRY_ID

4270: , DO_NOT_USE_REASON_S5
4271:
4272: , DO_NOT_USE_REASON_S6
4273:
4274: FROM IEC_VAL_ENTRY_CACHE B WHERE A.LIST_ENTRY_ID = B.LIST_ENTRY_ID
4275:
4276: )
4277:
4278: , LAST_UPDATED_BY = :login_id

Line 4286: AND A.LIST_ENTRY_ID IN (SELECT LIST_ENTRY_ID FROM IEC_VAL_ENTRY_CACHE)'

4282: , LAST_UPDATE_LOGIN = :login_id
4283:
4284: WHERE A.LIST_HEADER_ID = :list_id
4285:
4286: AND A.LIST_ENTRY_ID IN (SELECT LIST_ENTRY_ID FROM IEC_VAL_ENTRY_CACHE)'
4287:
4288: USING l_login_id, l_login_id, p_list_id;
4289:
4290: EXCEPTION

Line 4316: AND LIST_ENTRY_ID IN (SELECT LIST_ENTRY_ID FROM IEC_VAL_ENTRY_CACHE)

4312: 'DELETE IEC_O_VALIDATION_REPORT_DETS
4313:
4314: WHERE LIST_HEADER_ID = :list_id
4315:
4316: AND LIST_ENTRY_ID IN (SELECT LIST_ENTRY_ID FROM IEC_VAL_ENTRY_CACHE)
4317:
4318: AND DO_NOT_USE_REASON_S1 IS NULL
4319:
4320: AND DO_NOT_USE_REASON_S2 IS NULL

Line 4408: FROM IEC_VAL_ENTRY_CACHE

4404: , sysdate
4405:
4406: , :login_id
4407:
4408: FROM IEC_VAL_ENTRY_CACHE
4409:
4410: WHERE LIST_ENTRY_ID NOT IN (SELECT LIST_ENTRY_ID FROM IEC_O_VALIDATION_REPORT_DETS WHERE LIST_HEADER_ID = :list_id)
4411:
4412: AND ( DO_NOT_USE_REASON_S1 IS NOT NULL

Line 4528: FROM IEC_VAL_ENTRY_CACHE

4524: , CURR_CP_TIME_ZONE TIME_ZONE
4525:
4526: , COUNT(*) RECORD_COUNT
4527:
4528: FROM IEC_VAL_ENTRY_CACHE
4529:
4530: WHERE DO_NOT_USE_FLAG = 'N'
4531:
4532: GROUP BY SUBSET_ID

Line 4720: FROM IEC_VAL_ENTRY_CACHE

4716: , REGION_ID' || l_cp_postfix(i) || ' REGION_ID
4717:
4718: , TIME_ZONE' || l_cp_postfix(i) || ' TIME_ZONE
4719:
4720: FROM IEC_VAL_ENTRY_CACHE
4721:
4722: WHERE DO_NOT_USE_FLAG = ''N''
4723:
4724: AND VALID_FLAG' || l_cp_postfix(i) || ' = ''Y''';

Line 4892: -- Update IEC_VAL_ENTRY_CACHE with the MKTG_ITEM_CC_TZ_ID

4888: END LOOP;
4889:
4890:
4891:
4892: -- Update IEC_VAL_ENTRY_CACHE with the MKTG_ITEM_CC_TZ_ID
4893:
4894: EXECUTE IMMEDIATE
4895:
4896: 'UPDATE IEC_VAL_ENTRY_CACHE A

Line 4896: 'UPDATE IEC_VAL_ENTRY_CACHE A

4892: -- Update IEC_VAL_ENTRY_CACHE with the MKTG_ITEM_CC_TZ_ID
4893:
4894: EXECUTE IMMEDIATE
4895:
4896: 'UPDATE IEC_VAL_ENTRY_CACHE A
4897:
4898: SET A.MKTG_ITEM_CC_TZS_ID_S1 = (SELECT TC_TZ_PAIR_ID
4899:
4900: FROM IEC_TC_TZ_PAIRS_CACHE

Line 5680: FROM IEC_VAL_ENTRY_CACHE B

5676: , B.CURR_CP_PHONE_LINE_TYPE
5677:
5678: , B.CURR_CP_CONTACT_POINT_PURPOSE
5679:
5680: FROM IEC_VAL_ENTRY_CACHE B
5681:
5682: WHERE A.LIST_ENTRY_ID = B.LIST_ENTRY_ID)
5683:
5684: , LAST_UPDATED_BY = :login_id

Line 5692: AND A.LIST_ENTRY_ID IN (SELECT LIST_ENTRY_ID FROM IEC_VAL_ENTRY_CACHE)'

5688: , LAST_UPDATE_LOGIN = :login_id
5689:
5690: WHERE A.LIST_HEADER_ID = :list_id
5691:
5692: AND A.LIST_ENTRY_ID IN (SELECT LIST_ENTRY_ID FROM IEC_VAL_ENTRY_CACHE)'
5693:
5694: USING l_login_id, l_login_id, p_list_id;
5695:
5696:

Line 5728: FROM IEC_VAL_ENTRY_CACHE

5724: AND A.LIST_ENTRY_ID IN
5725:
5726: ( SELECT LIST_ENTRY_ID
5727:
5728: FROM IEC_VAL_ENTRY_CACHE
5729:
5730: WHERE DO_NOT_USE_FLAG = ''Y''
5731:
5732: AND DO_NOT_USE_REASON = ''4'')'

Line 5886: FROM IEC_VAL_ENTRY_CACHE

5882: , sysdate
5883:
5884: , :login_id
5885:
5886: FROM IEC_VAL_ENTRY_CACHE
5887:
5888: WHERE DO_NOT_USE_FLAG = ''N''
5889:
5890: AND LIST_ENTRY_ID NOT IN (SELECT LIST_ENTRY_ID FROM IEC_G_RETURN_ENTRIES WHERE LIST_HEADER_ID = :list_id)'

Line 6206: 'UPDATE IEC_VAL_ENTRY_CACHE

6202: IF p_subset_view_col(i) IS NOT NULL THEN
6203:
6204: EXECUTE IMMEDIATE
6205:
6206: 'UPDATE IEC_VAL_ENTRY_CACHE
6207:
6208: SET SUBSET_ID = :subset_id
6209:
6210: WHERE SUBSET_ID IS NULL

Line 6244: 'UPDATE IEC_VAL_ENTRY_CACHE

6240: -- Assign all remaining entries to default subset
6241:
6242: EXECUTE IMMEDIATE
6243:
6244: 'UPDATE IEC_VAL_ENTRY_CACHE
6245:
6246: SET SUBSET_ID = :subset_id
6247:
6248: WHERE SUBSET_ID IS NULL

Line 6270: 'UPDATE IEC_VAL_ENTRY_CACHE

6266: -- No user-defined subsets exist, assign all entries to default subset
6267:
6268: EXECUTE IMMEDIATE
6269:
6270: 'UPDATE IEC_VAL_ENTRY_CACHE
6271:
6272: SET SUBSET_ID = :subset_id
6273:
6274: WHERE SUBSET_ID IS NULL

Line 9216: INSERT INTO IEC_VAL_ENTRY_CACHE

9212: END;
9213:
9214:
9215:
9216: INSERT INTO IEC_VAL_ENTRY_CACHE
9217:
9218: ( LIST_ENTRY_ID
9219:
9220: , POSTAL_CODE

Line 9620: FROM IEC_VAL_ENTRY_CACHE'

9616: EXECUTE IMMEDIATE
9617:
9618: 'SELECT COUNT(*)
9619:
9620: FROM IEC_VAL_ENTRY_CACHE'
9621:
9622: INTO l_entry_count;
9623:
9624:

Line 11792: FROM IEC_VAL_ENTRY_CACHE

11788: , RAW_PHONE_NUMBER' || l_cp_postfix_col(i) || '
11789:
11790: , TIME_ZONE' || l_cp_postfix_col(i) || '
11791:
11792: FROM IEC_VAL_ENTRY_CACHE
11793:
11794: WHERE LIST_ENTRY_ID = :list_entry_id)
11795:
11796: WHERE LIST_HEADER_ID = :to_list_id AND LIST_ENTRY_ID = :list_entry_id

Line 16106: -- Load entries into IEC_VAL_ENTRY_CACHE

16102: USING p_list_id;
16103:
16104:
16105:
16106: -- Load entries into IEC_VAL_ENTRY_CACHE
16107:
16108: BEGIN
16109:
16110: OPEN l_list_entry_csr FOR

Line 16262: INSERT INTO IEC_VAL_ENTRY_CACHE

16258: Get_CallableZoneDetail_Cache(l_cc_tz_id_s6, l_tc_s6, l_rc_s6, l_tz_s6, l_valid_flag_s6);
16259:
16260:
16261:
16262: INSERT INTO IEC_VAL_ENTRY_CACHE
16263:
16264: ( LIST_ENTRY_ID
16265:
16266: , CALLBACK_FLAG

Line 16372: FROM IEC_VAL_ENTRY_CACHE'

16368: EXECUTE IMMEDIATE
16369:
16370: 'SELECT COUNT(*)
16371:
16372: FROM IEC_VAL_ENTRY_CACHE'
16373:
16374: INTO l_entry_count;
16375:
16376:

Line 16438: FROM IEC_VAL_ENTRY_CACHE B WHERE A.LIST_ENTRY_ID = B.LIST_ENTRY_ID )

16434: , MKTG_ITEM_CC_TZS_ID_S5
16435:
16436: , MKTG_ITEM_CC_TZS_ID_S6
16437:
16438: FROM IEC_VAL_ENTRY_CACHE B WHERE A.LIST_ENTRY_ID = B.LIST_ENTRY_ID )
16439:
16440: WHERE LIST_HEADER_ID = :list_id AND LIST_ENTRY_ID IN (SELECT LIST_ENTRY_ID FROM IEC_VAL_ENTRY_CACHE);
16441:
16442: END;'

Line 16440: WHERE LIST_HEADER_ID = :list_id AND LIST_ENTRY_ID IN (SELECT LIST_ENTRY_ID FROM IEC_VAL_ENTRY_CACHE);

16436: , MKTG_ITEM_CC_TZS_ID_S6
16437:
16438: FROM IEC_VAL_ENTRY_CACHE B WHERE A.LIST_ENTRY_ID = B.LIST_ENTRY_ID )
16439:
16440: WHERE LIST_HEADER_ID = :list_id AND LIST_ENTRY_ID IN (SELECT LIST_ENTRY_ID FROM IEC_VAL_ENTRY_CACHE);
16441:
16442: END;'
16443:
16444: USING p_list_id;

Line 16516: FROM IEC_VAL_ENTRY_CACHE B

16512: , CURR_CP_RAW_PHONE_NUMBER
16513:
16514: , CURR_CP_TIME_ZONE
16515:
16516: FROM IEC_VAL_ENTRY_CACHE B
16517:
16518: WHERE A.LIST_ENTRY_ID = B.LIST_ENTRY_ID )
16519:
16520: WHERE LIST_HEADER_ID = :list_id AND LIST_ENTRY_ID IN (SELECT LIST_ENTRY_ID FROM IEC_VAL_ENTRY_CACHE);

Line 16520: WHERE LIST_HEADER_ID = :list_id AND LIST_ENTRY_ID IN (SELECT LIST_ENTRY_ID FROM IEC_VAL_ENTRY_CACHE);

16516: FROM IEC_VAL_ENTRY_CACHE B
16517:
16518: WHERE A.LIST_ENTRY_ID = B.LIST_ENTRY_ID )
16519:
16520: WHERE LIST_HEADER_ID = :list_id AND LIST_ENTRY_ID IN (SELECT LIST_ENTRY_ID FROM IEC_VAL_ENTRY_CACHE);
16521:
16522: END;'
16523:
16524: USING p_list_id;