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 2003: WHERE TABLE_NAME = 'IEC_VAL_ENTRY_CACHE'

1999: SELECT 'TRUNCATE TABLE ' || OWNER || '.' || TABLE_NAME SQLSTMT
2000:
2001: FROM ALL_TABLES
2002:
2003: WHERE TABLE_NAME = 'IEC_VAL_ENTRY_CACHE'
2004:
2005: AND OWNER = table_owner;
2006:
2007:

Line 2042: delete from IEC_VAL_ENTRY_CACHE;

2038:
2039:
2040: COMMIT; */
2041:
2042: delete from IEC_VAL_ENTRY_CACHE;
2043:
2044: -- COMMIT;
2045: -- commented the above line as part of re-fix for the same bug7622572 FP - 8319163
2046:

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

2110: delete from IEC_TZ_MAPPING_CACHE;
2111:
2112: delete from IEC_TZ_OFFSET_MAP_CACHE;
2113:
2114: delete from IEC_VAL_ENTRY_CACHE;
2115:
2116: -- COMMIT;
2117: -- commented the above line as part of re-fix for the same bug7622572 FP - 8319163
2118:

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

4192: 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,
4193:
4194: 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
4195:
4196: FROM IEC_VAL_ENTRY_CACHE B WHERE A.LIST_ENTRY_ID = B.LIST_ENTRY_ID
4197:
4198: )
4199:
4200: WHERE LIST_HEADER_ID = :list_id AND LIST_ENTRY_ID IN (SELECT LIST_ENTRY_ID FROM IEC_VAL_ENTRY_CACHE);

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

4196: FROM IEC_VAL_ENTRY_CACHE B WHERE A.LIST_ENTRY_ID = B.LIST_ENTRY_ID
4197:
4198: )
4199:
4200: WHERE LIST_HEADER_ID = :list_id AND LIST_ENTRY_ID IN (SELECT LIST_ENTRY_ID FROM IEC_VAL_ENTRY_CACHE);
4201:
4202: END;'
4203:
4204: USING p_list_id;

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

4292: , DO_NOT_USE_REASON_S5
4293:
4294: , DO_NOT_USE_REASON_S6
4295:
4296: FROM IEC_VAL_ENTRY_CACHE B WHERE A.LIST_ENTRY_ID = B.LIST_ENTRY_ID
4297:
4298: )
4299:
4300: , LAST_UPDATED_BY = :login_id

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

4304: , LAST_UPDATE_LOGIN = :login_id
4305:
4306: WHERE A.LIST_HEADER_ID = :list_id
4307:
4308: AND A.LIST_ENTRY_ID IN (SELECT LIST_ENTRY_ID FROM IEC_VAL_ENTRY_CACHE)'
4309:
4310: USING l_login_id, l_login_id, p_list_id;
4311:
4312: EXCEPTION

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

4334: 'DELETE IEC_O_VALIDATION_REPORT_DETS
4335:
4336: WHERE LIST_HEADER_ID = :list_id
4337:
4338: AND LIST_ENTRY_ID IN (SELECT LIST_ENTRY_ID FROM IEC_VAL_ENTRY_CACHE)
4339:
4340: AND DO_NOT_USE_REASON_S1 IS NULL
4341:
4342: AND DO_NOT_USE_REASON_S2 IS NULL

Line 4430: FROM IEC_VAL_ENTRY_CACHE

4426: , sysdate
4427:
4428: , :login_id
4429:
4430: FROM IEC_VAL_ENTRY_CACHE
4431:
4432: WHERE LIST_ENTRY_ID NOT IN (SELECT LIST_ENTRY_ID FROM IEC_O_VALIDATION_REPORT_DETS WHERE LIST_HEADER_ID = :list_id)
4433:
4434: AND ( DO_NOT_USE_REASON_S1 IS NOT NULL

Line 4550: FROM IEC_VAL_ENTRY_CACHE

4546: , CURR_CP_TIME_ZONE TIME_ZONE
4547:
4548: , COUNT(*) RECORD_COUNT
4549:
4550: FROM IEC_VAL_ENTRY_CACHE
4551:
4552: WHERE DO_NOT_USE_FLAG = 'N'
4553:
4554: GROUP BY SUBSET_ID

Line 4742: FROM IEC_VAL_ENTRY_CACHE

4738: , REGION_ID' || l_cp_postfix(i) || ' REGION_ID
4739:
4740: , TIME_ZONE' || l_cp_postfix(i) || ' TIME_ZONE
4741:
4742: FROM IEC_VAL_ENTRY_CACHE
4743:
4744: WHERE DO_NOT_USE_FLAG = ''N''
4745:
4746: AND VALID_FLAG' || l_cp_postfix(i) || ' = ''Y''';

Line 4914: -- Update IEC_VAL_ENTRY_CACHE with the MKTG_ITEM_CC_TZ_ID

4910: END LOOP;
4911:
4912:
4913:
4914: -- Update IEC_VAL_ENTRY_CACHE with the MKTG_ITEM_CC_TZ_ID
4915:
4916: EXECUTE IMMEDIATE
4917:
4918: 'UPDATE IEC_VAL_ENTRY_CACHE A

Line 4918: 'UPDATE IEC_VAL_ENTRY_CACHE A

4914: -- Update IEC_VAL_ENTRY_CACHE with the MKTG_ITEM_CC_TZ_ID
4915:
4916: EXECUTE IMMEDIATE
4917:
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

Line 5702: FROM IEC_VAL_ENTRY_CACHE B

5698: , B.CURR_CP_PHONE_LINE_TYPE
5699:
5700: , B.CURR_CP_CONTACT_POINT_PURPOSE
5701:
5702: FROM IEC_VAL_ENTRY_CACHE B
5703:
5704: WHERE A.LIST_ENTRY_ID = B.LIST_ENTRY_ID)
5705:
5706: , LAST_UPDATED_BY = :login_id

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

5710: , LAST_UPDATE_LOGIN = :login_id
5711:
5712: WHERE A.LIST_HEADER_ID = :list_id
5713:
5714: AND A.LIST_ENTRY_ID IN (SELECT LIST_ENTRY_ID FROM IEC_VAL_ENTRY_CACHE)'
5715:
5716: USING l_login_id, l_login_id, p_list_id;
5717:
5718:

Line 5750: FROM IEC_VAL_ENTRY_CACHE

5746: AND A.LIST_ENTRY_ID IN
5747:
5748: ( SELECT LIST_ENTRY_ID
5749:
5750: FROM IEC_VAL_ENTRY_CACHE
5751:
5752: WHERE DO_NOT_USE_FLAG = ''Y''
5753:
5754: AND DO_NOT_USE_REASON = ''4'')'

Line 5908: FROM IEC_VAL_ENTRY_CACHE

5904: , sysdate
5905:
5906: , :login_id
5907:
5908: FROM IEC_VAL_ENTRY_CACHE
5909:
5910: WHERE DO_NOT_USE_FLAG = ''N''
5911:
5912: AND LIST_ENTRY_ID NOT IN (SELECT LIST_ENTRY_ID FROM IEC_G_RETURN_ENTRIES WHERE LIST_HEADER_ID = :list_id)'

Line 6228: 'UPDATE IEC_VAL_ENTRY_CACHE

6224: IF p_subset_view_col(i) IS NOT NULL THEN
6225:
6226: EXECUTE IMMEDIATE
6227:
6228: 'UPDATE IEC_VAL_ENTRY_CACHE
6229:
6230: SET SUBSET_ID = :subset_id
6231:
6232: WHERE SUBSET_ID IS NULL

Line 6266: 'UPDATE IEC_VAL_ENTRY_CACHE

6262: -- Assign all remaining entries to default subset
6263:
6264: EXECUTE IMMEDIATE
6265:
6266: 'UPDATE IEC_VAL_ENTRY_CACHE
6267:
6268: SET SUBSET_ID = :subset_id
6269:
6270: WHERE SUBSET_ID IS NULL

Line 6292: 'UPDATE IEC_VAL_ENTRY_CACHE

6288: -- No user-defined subsets exist, assign all entries to default subset
6289:
6290: EXECUTE IMMEDIATE
6291:
6292: 'UPDATE IEC_VAL_ENTRY_CACHE
6293:
6294: SET SUBSET_ID = :subset_id
6295:
6296: WHERE SUBSET_ID IS NULL

Line 9238: INSERT INTO IEC_VAL_ENTRY_CACHE

9234: END;
9235:
9236:
9237:
9238: INSERT INTO IEC_VAL_ENTRY_CACHE
9239:
9240: ( LIST_ENTRY_ID
9241:
9242: , POSTAL_CODE

Line 9642: FROM IEC_VAL_ENTRY_CACHE'

9638: EXECUTE IMMEDIATE
9639:
9640: 'SELECT COUNT(*)
9641:
9642: FROM IEC_VAL_ENTRY_CACHE'
9643:
9644: INTO l_entry_count;
9645:
9646:

Line 11814: FROM IEC_VAL_ENTRY_CACHE

11810: , RAW_PHONE_NUMBER' || l_cp_postfix_col(i) || '
11811:
11812: , TIME_ZONE' || l_cp_postfix_col(i) || '
11813:
11814: FROM IEC_VAL_ENTRY_CACHE
11815:
11816: WHERE LIST_ENTRY_ID = :list_entry_id)
11817:
11818: WHERE LIST_HEADER_ID = :to_list_id AND LIST_ENTRY_ID = :list_entry_id

Line 16128: -- Load entries into IEC_VAL_ENTRY_CACHE

16124: USING p_list_id;
16125:
16126:
16127:
16128: -- Load entries into IEC_VAL_ENTRY_CACHE
16129:
16130: BEGIN
16131:
16132: OPEN l_list_entry_csr FOR

Line 16284: INSERT INTO IEC_VAL_ENTRY_CACHE

16280: Get_CallableZoneDetail_Cache(l_cc_tz_id_s6, l_tc_s6, l_rc_s6, l_tz_s6, l_valid_flag_s6);
16281:
16282:
16283:
16284: INSERT INTO IEC_VAL_ENTRY_CACHE
16285:
16286: ( LIST_ENTRY_ID
16287:
16288: , CALLBACK_FLAG

Line 16394: FROM IEC_VAL_ENTRY_CACHE'

16390: EXECUTE IMMEDIATE
16391:
16392: 'SELECT COUNT(*)
16393:
16394: FROM IEC_VAL_ENTRY_CACHE'
16395:
16396: INTO l_entry_count;
16397:
16398:

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

16456: , MKTG_ITEM_CC_TZS_ID_S5
16457:
16458: , MKTG_ITEM_CC_TZS_ID_S6
16459:
16460: FROM IEC_VAL_ENTRY_CACHE B WHERE A.LIST_ENTRY_ID = B.LIST_ENTRY_ID )
16461:
16462: WHERE LIST_HEADER_ID = :list_id AND LIST_ENTRY_ID IN (SELECT LIST_ENTRY_ID FROM IEC_VAL_ENTRY_CACHE);
16463:
16464: END;'

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

16458: , MKTG_ITEM_CC_TZS_ID_S6
16459:
16460: FROM IEC_VAL_ENTRY_CACHE B WHERE A.LIST_ENTRY_ID = B.LIST_ENTRY_ID )
16461:
16462: WHERE LIST_HEADER_ID = :list_id AND LIST_ENTRY_ID IN (SELECT LIST_ENTRY_ID FROM IEC_VAL_ENTRY_CACHE);
16463:
16464: END;'
16465:
16466: USING p_list_id;

Line 16538: FROM IEC_VAL_ENTRY_CACHE B

16534: , CURR_CP_RAW_PHONE_NUMBER
16535:
16536: , CURR_CP_TIME_ZONE
16537:
16538: FROM IEC_VAL_ENTRY_CACHE B
16539:
16540: WHERE A.LIST_ENTRY_ID = B.LIST_ENTRY_ID )
16541:
16542: WHERE LIST_HEADER_ID = :list_id AND LIST_ENTRY_ID IN (SELECT LIST_ENTRY_ID FROM IEC_VAL_ENTRY_CACHE);

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

16538: FROM IEC_VAL_ENTRY_CACHE B
16539:
16540: WHERE A.LIST_ENTRY_ID = B.LIST_ENTRY_ID )
16541:
16542: WHERE LIST_HEADER_ID = :list_id AND LIST_ENTRY_ID IN (SELECT LIST_ENTRY_ID FROM IEC_VAL_ENTRY_CACHE);
16543:
16544: END;'
16545:
16546: USING p_list_id;