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.

APPS.IEC_VALIDATE_PVT dependencies on HZ_PHONE_COUNTRY_CODES

Line 489: , 'HZ_PHONE_COUNTRY_CODES'

485: IEC_OCS_LOG_PVT.Init_TerritoryNotFoundMsg
486:
487: ( p_territory_code
488:
489: , 'HZ_PHONE_COUNTRY_CODES'
490:
491: , g_message
492:
493: , g_encoded_message

Line 527: , 'HZ_PHONE_COUNTRY_CODES'

523: IEC_OCS_LOG_PVT.Init_TerritoryNotUniqueMsg
524:
525: ( p_territory_code
526:
527: , 'HZ_PHONE_COUNTRY_CODES'
528:
529: , g_message
530:
531: , g_encoded_message

Line 2255: FROM HZ_PHONE_COUNTRY_CODES B

2251:
2252:
2253: FOR cc_rec IN (SELECT DISTINCT B.PHONE_COUNTRY_CODE, B.AREA_CODE_LENGTH
2254:
2255: FROM HZ_PHONE_COUNTRY_CODES B
2256:
2257: WHERE B.AREA_CODE_LENGTH IS NOT NULL
2258:
2259: AND (1, B.PHONE_COUNTRY_CODE) = (SELECT COUNT(*) COUNT, PHONE_COUNTRY_CODE

Line 2263: FROM HZ_PHONE_COUNTRY_CODES

2259: AND (1, B.PHONE_COUNTRY_CODE) = (SELECT COUNT(*) COUNT, PHONE_COUNTRY_CODE
2260:
2261: FROM (SELECT DISTINCT PHONE_COUNTRY_CODE, AREA_CODE_LENGTH
2262:
2263: FROM HZ_PHONE_COUNTRY_CODES
2264:
2265: WHERE AREA_CODE_LENGTH IS NOT NULL)
2266:
2267: WHERE PHONE_COUNTRY_CODE = B.PHONE_COUNTRY_CODE GROUP BY PHONE_COUNTRY_CODE))

Line 2279: FROM HZ_PHONE_COUNTRY_CODES B

2275:
2276:
2277: FOR cc_rec IN (SELECT DISTINCT B.PHONE_COUNTRY_CODE, (B.PHONE_LENGTH - B.AREA_CODE_LENGTH) PN_LENGTH
2278:
2279: FROM HZ_PHONE_COUNTRY_CODES B
2280:
2281: WHERE B.PHONE_LENGTH IS NOT NULL
2282:
2283: AND (1, B.PHONE_COUNTRY_CODE) = (SELECT COUNT(*) COUNT, PHONE_COUNTRY_CODE

Line 2287: FROM HZ_PHONE_COUNTRY_CODES

2283: AND (1, B.PHONE_COUNTRY_CODE) = (SELECT COUNT(*) COUNT, PHONE_COUNTRY_CODE
2284:
2285: FROM (SELECT DISTINCT PHONE_COUNTRY_CODE, PHONE_LENGTH
2286:
2287: FROM HZ_PHONE_COUNTRY_CODES
2288:
2289: WHERE PHONE_LENGTH IS NOT NULL)
2290:
2291: WHERE PHONE_COUNTRY_CODE = B.PHONE_COUNTRY_CODE GROUP BY PHONE_COUNTRY_CODE))

Line 2303: FROM HZ_PHONE_COUNTRY_CODES A WHERE 1 = (SELECT COUNT(*)

2299:
2300:
2301: FOR cc_rec IN (SELECT DISTINCT PHONE_COUNTRY_CODE, TERRITORY_CODE
2302:
2303: FROM HZ_PHONE_COUNTRY_CODES A WHERE 1 = (SELECT COUNT(*)
2304:
2305: FROM HZ_PHONE_COUNTRY_CODES
2306:
2307: WHERE PHONE_COUNTRY_CODE = A.PHONE_COUNTRY_CODE))

Line 2305: FROM HZ_PHONE_COUNTRY_CODES

2301: FOR cc_rec IN (SELECT DISTINCT PHONE_COUNTRY_CODE, TERRITORY_CODE
2302:
2303: FROM HZ_PHONE_COUNTRY_CODES A WHERE 1 = (SELECT COUNT(*)
2304:
2305: FROM HZ_PHONE_COUNTRY_CODES
2306:
2307: WHERE PHONE_COUNTRY_CODE = A.PHONE_COUNTRY_CODE))
2308:
2309: LOOP

Line 2319: FROM HZ_PHONE_COUNTRY_CODES)

2315:
2316:
2317: FOR cc_rec IN (SELECT DISTINCT PHONE_COUNTRY_CODE
2318:
2319: FROM HZ_PHONE_COUNTRY_CODES)
2320:
2321: LOOP
2322:
2323: g_cc_cc_lookup_tbl(cc_rec.PHONE_COUNTRY_CODE) := cc_rec.PHONE_COUNTRY_CODE;

Line 2766: FROM HZ_PHONE_COUNTRY_CODES

2762: EXECUTE IMMEDIATE
2763:
2764: 'SELECT PHONE_COUNTRY_CODE
2765:
2766: FROM HZ_PHONE_COUNTRY_CODES
2767:
2768: WHERE TERRITORY_CODE = :territory_code'
2769:
2770: INTO g_phone_country_code

Line 6590: FROM HZ_PHONE_FORMATS A, HZ_PHONE_COUNTRY_CODES B

6586: EXECUTE IMMEDIATE
6587:
6588: 'SELECT DISTINCT A.AREA_CODE_SIZE
6589:
6590: FROM HZ_PHONE_FORMATS A, HZ_PHONE_COUNTRY_CODES B
6591:
6592: WHERE A.TERRITORY_CODE = B.TERRITORY_CODE AND B.PHONE_COUNTRY_CODE = :country_code
6593:
6594: AND LENGTH(TRIM(TRANSLATE( UPPER(PHONE_FORMAT_STYLE)

Line 16048: CURR_CP_COUNTRY_CODE = (SELECT PHONE_COUNTRY_CODE FROM HZ_PHONE_COUNTRY_CODES B WHERE B.TERRITORY_CODE = A.CURR_CP_COUNTRY_CODE)

16044: UPDATE ' || p_source_type_v || ' A' || '
16045:
16046: SET
16047:
16048: CURR_CP_COUNTRY_CODE = (SELECT PHONE_COUNTRY_CODE FROM HZ_PHONE_COUNTRY_CODES B WHERE B.TERRITORY_CODE = A.CURR_CP_COUNTRY_CODE)
16049:
16050: , PHONE_COUNTRY_CODE_S1 = (SELECT PHONE_COUNTRY_CODE FROM HZ_PHONE_COUNTRY_CODES B WHERE B.TERRITORY_CODE = A.PHONE_COUNTRY_CODE_S1)
16051:
16052: , PHONE_COUNTRY_CODE_S2 = (SELECT PHONE_COUNTRY_CODE FROM HZ_PHONE_COUNTRY_CODES B WHERE B.TERRITORY_CODE = A.PHONE_COUNTRY_CODE_S2)

Line 16050: , PHONE_COUNTRY_CODE_S1 = (SELECT PHONE_COUNTRY_CODE FROM HZ_PHONE_COUNTRY_CODES B WHERE B.TERRITORY_CODE = A.PHONE_COUNTRY_CODE_S1)

16046: SET
16047:
16048: CURR_CP_COUNTRY_CODE = (SELECT PHONE_COUNTRY_CODE FROM HZ_PHONE_COUNTRY_CODES B WHERE B.TERRITORY_CODE = A.CURR_CP_COUNTRY_CODE)
16049:
16050: , PHONE_COUNTRY_CODE_S1 = (SELECT PHONE_COUNTRY_CODE FROM HZ_PHONE_COUNTRY_CODES B WHERE B.TERRITORY_CODE = A.PHONE_COUNTRY_CODE_S1)
16051:
16052: , PHONE_COUNTRY_CODE_S2 = (SELECT PHONE_COUNTRY_CODE FROM HZ_PHONE_COUNTRY_CODES B WHERE B.TERRITORY_CODE = A.PHONE_COUNTRY_CODE_S2)
16053:
16054: , PHONE_COUNTRY_CODE_S3 = (SELECT PHONE_COUNTRY_CODE FROM HZ_PHONE_COUNTRY_CODES B WHERE B.TERRITORY_CODE = A.PHONE_COUNTRY_CODE_S3)

Line 16052: , PHONE_COUNTRY_CODE_S2 = (SELECT PHONE_COUNTRY_CODE FROM HZ_PHONE_COUNTRY_CODES B WHERE B.TERRITORY_CODE = A.PHONE_COUNTRY_CODE_S2)

16048: CURR_CP_COUNTRY_CODE = (SELECT PHONE_COUNTRY_CODE FROM HZ_PHONE_COUNTRY_CODES B WHERE B.TERRITORY_CODE = A.CURR_CP_COUNTRY_CODE)
16049:
16050: , PHONE_COUNTRY_CODE_S1 = (SELECT PHONE_COUNTRY_CODE FROM HZ_PHONE_COUNTRY_CODES B WHERE B.TERRITORY_CODE = A.PHONE_COUNTRY_CODE_S1)
16051:
16052: , PHONE_COUNTRY_CODE_S2 = (SELECT PHONE_COUNTRY_CODE FROM HZ_PHONE_COUNTRY_CODES B WHERE B.TERRITORY_CODE = A.PHONE_COUNTRY_CODE_S2)
16053:
16054: , PHONE_COUNTRY_CODE_S3 = (SELECT PHONE_COUNTRY_CODE FROM HZ_PHONE_COUNTRY_CODES B WHERE B.TERRITORY_CODE = A.PHONE_COUNTRY_CODE_S3)
16055:
16056: , PHONE_COUNTRY_CODE_S4 = (SELECT PHONE_COUNTRY_CODE FROM HZ_PHONE_COUNTRY_CODES B WHERE B.TERRITORY_CODE = A.PHONE_COUNTRY_CODE_S4)

Line 16054: , PHONE_COUNTRY_CODE_S3 = (SELECT PHONE_COUNTRY_CODE FROM HZ_PHONE_COUNTRY_CODES B WHERE B.TERRITORY_CODE = A.PHONE_COUNTRY_CODE_S3)

16050: , PHONE_COUNTRY_CODE_S1 = (SELECT PHONE_COUNTRY_CODE FROM HZ_PHONE_COUNTRY_CODES B WHERE B.TERRITORY_CODE = A.PHONE_COUNTRY_CODE_S1)
16051:
16052: , PHONE_COUNTRY_CODE_S2 = (SELECT PHONE_COUNTRY_CODE FROM HZ_PHONE_COUNTRY_CODES B WHERE B.TERRITORY_CODE = A.PHONE_COUNTRY_CODE_S2)
16053:
16054: , PHONE_COUNTRY_CODE_S3 = (SELECT PHONE_COUNTRY_CODE FROM HZ_PHONE_COUNTRY_CODES B WHERE B.TERRITORY_CODE = A.PHONE_COUNTRY_CODE_S3)
16055:
16056: , PHONE_COUNTRY_CODE_S4 = (SELECT PHONE_COUNTRY_CODE FROM HZ_PHONE_COUNTRY_CODES B WHERE B.TERRITORY_CODE = A.PHONE_COUNTRY_CODE_S4)
16057:
16058: , PHONE_COUNTRY_CODE_S5 = (SELECT PHONE_COUNTRY_CODE FROM HZ_PHONE_COUNTRY_CODES B WHERE B.TERRITORY_CODE = A.PHONE_COUNTRY_CODE_S5)

Line 16056: , PHONE_COUNTRY_CODE_S4 = (SELECT PHONE_COUNTRY_CODE FROM HZ_PHONE_COUNTRY_CODES B WHERE B.TERRITORY_CODE = A.PHONE_COUNTRY_CODE_S4)

16052: , PHONE_COUNTRY_CODE_S2 = (SELECT PHONE_COUNTRY_CODE FROM HZ_PHONE_COUNTRY_CODES B WHERE B.TERRITORY_CODE = A.PHONE_COUNTRY_CODE_S2)
16053:
16054: , PHONE_COUNTRY_CODE_S3 = (SELECT PHONE_COUNTRY_CODE FROM HZ_PHONE_COUNTRY_CODES B WHERE B.TERRITORY_CODE = A.PHONE_COUNTRY_CODE_S3)
16055:
16056: , PHONE_COUNTRY_CODE_S4 = (SELECT PHONE_COUNTRY_CODE FROM HZ_PHONE_COUNTRY_CODES B WHERE B.TERRITORY_CODE = A.PHONE_COUNTRY_CODE_S4)
16057:
16058: , PHONE_COUNTRY_CODE_S5 = (SELECT PHONE_COUNTRY_CODE FROM HZ_PHONE_COUNTRY_CODES B WHERE B.TERRITORY_CODE = A.PHONE_COUNTRY_CODE_S5)
16059:
16060: , PHONE_COUNTRY_CODE_S6 = (SELECT PHONE_COUNTRY_CODE FROM HZ_PHONE_COUNTRY_CODES B WHERE B.TERRITORY_CODE = A.PHONE_COUNTRY_CODE_S6)

Line 16058: , PHONE_COUNTRY_CODE_S5 = (SELECT PHONE_COUNTRY_CODE FROM HZ_PHONE_COUNTRY_CODES B WHERE B.TERRITORY_CODE = A.PHONE_COUNTRY_CODE_S5)

16054: , PHONE_COUNTRY_CODE_S3 = (SELECT PHONE_COUNTRY_CODE FROM HZ_PHONE_COUNTRY_CODES B WHERE B.TERRITORY_CODE = A.PHONE_COUNTRY_CODE_S3)
16055:
16056: , PHONE_COUNTRY_CODE_S4 = (SELECT PHONE_COUNTRY_CODE FROM HZ_PHONE_COUNTRY_CODES B WHERE B.TERRITORY_CODE = A.PHONE_COUNTRY_CODE_S4)
16057:
16058: , PHONE_COUNTRY_CODE_S5 = (SELECT PHONE_COUNTRY_CODE FROM HZ_PHONE_COUNTRY_CODES B WHERE B.TERRITORY_CODE = A.PHONE_COUNTRY_CODE_S5)
16059:
16060: , PHONE_COUNTRY_CODE_S6 = (SELECT PHONE_COUNTRY_CODE FROM HZ_PHONE_COUNTRY_CODES B WHERE B.TERRITORY_CODE = A.PHONE_COUNTRY_CODE_S6)
16061:
16062: WHERE LIST_HEADER_ID = :list_header_id

Line 16060: , PHONE_COUNTRY_CODE_S6 = (SELECT PHONE_COUNTRY_CODE FROM HZ_PHONE_COUNTRY_CODES B WHERE B.TERRITORY_CODE = A.PHONE_COUNTRY_CODE_S6)

16056: , PHONE_COUNTRY_CODE_S4 = (SELECT PHONE_COUNTRY_CODE FROM HZ_PHONE_COUNTRY_CODES B WHERE B.TERRITORY_CODE = A.PHONE_COUNTRY_CODE_S4)
16057:
16058: , PHONE_COUNTRY_CODE_S5 = (SELECT PHONE_COUNTRY_CODE FROM HZ_PHONE_COUNTRY_CODES B WHERE B.TERRITORY_CODE = A.PHONE_COUNTRY_CODE_S5)
16059:
16060: , PHONE_COUNTRY_CODE_S6 = (SELECT PHONE_COUNTRY_CODE FROM HZ_PHONE_COUNTRY_CODES B WHERE B.TERRITORY_CODE = A.PHONE_COUNTRY_CODE_S6)
16061:
16062: WHERE LIST_HEADER_ID = :list_header_id
16063:
16064: AND TRANSLATE(UPPER(CURR_CP_COUNTRY_CODE), ''0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ'', ''0123456789'') IS NULL