APPS.IEC_VALIDATE_PVT dependencies on IEC_G_TIMEZONE_MAPPINGS

Line 3048: FROM IEC_G_TIMEZONE_MAPPINGS;

3044: (TERRITORY_CODE, AREA_CODE, POSTAL_CODE, TIMEZONE_ID)
3045:
3046: SELECT DISTINCT TERRITORY_CODE, PHONE_AREA_CODE, POSTAL_CODE, TIMEZONE_ID
3047:
3048: FROM IEC_G_TIMEZONE_MAPPINGS;
3049:
3050: ELSE
3051:
3052: INSERT INTO IEC_TZ_MAPPING_CACHE

Line 3058: FROM IEC_G_TIMEZONE_MAPPINGS;

3054: (TERRITORY_CODE, AREA_CODE, POSTAL_CODE, TIMEZONE_ID)
3055:
3056: SELECT DISTINCT TERRITORY_CODE, PHONE_AREA_CODE, NULL, TIMEZONE_ID
3057:
3058: FROM IEC_G_TIMEZONE_MAPPINGS;
3059:
3060: END IF;
3061:
3062:

Line 16732: SELECT DISTINCT PHONE_AREA_CODE FROM IEC_G_TIMEZONE_MAPPINGS;

16728:
16729:
16730: CURSOR AREA_CODE_LIST IS
16731:
16732: SELECT DISTINCT PHONE_AREA_CODE FROM IEC_G_TIMEZONE_MAPPINGS;
16733:
16734:
16735:
16736: BEGIN

Line 16746: (SELECT DISTINCT TIMEZONE_ID FROM IEC_G_TIMEZONE_MAPPINGS WHERE PHONE_AREA_CODE = REC.PHONE_AREA_CODE);

16742:
16743:
16744: SELECT COUNT(*) INTO L_COUNT FROM
16745:
16746: (SELECT DISTINCT TIMEZONE_ID FROM IEC_G_TIMEZONE_MAPPINGS WHERE PHONE_AREA_CODE = REC.PHONE_AREA_CODE);
16747:
16748:
16749:
16750: IF L_COUNT = 1 THEN

Line 16756: FROM IEC_G_TIMEZONE_MAPPINGS

16752:
16753:
16754: SELECT DISTINCT TERRITORY_CODE INTO L_TERRITORY_CODE
16755:
16756: FROM IEC_G_TIMEZONE_MAPPINGS
16757:
16758: WHERE PHONE_AREA_CODE = REC.PHONE_AREA_CODE;
16759:
16760:

Line 16764: FROM IEC_G_TIMEZONE_MAPPINGS

16760:
16761:
16762: SELECT DISTINCT TIMEZONE_ID INTO L_TIMEZONE_ID
16763:
16764: FROM IEC_G_TIMEZONE_MAPPINGS
16765:
16766: WHERE PHONE_AREA_CODE = REC.PHONE_AREA_CODE;
16767:
16768:

Line 16770: DELETE IEC_G_TIMEZONE_MAPPINGS WHERE PHONE_AREA_CODE = REC.PHONE_AREA_CODE;

16766: WHERE PHONE_AREA_CODE = REC.PHONE_AREA_CODE;
16767:
16768:
16769:
16770: DELETE IEC_G_TIMEZONE_MAPPINGS WHERE PHONE_AREA_CODE = REC.PHONE_AREA_CODE;
16771:
16772:
16773:
16774: INSERT INTO IEC_G_TIMEZONE_MAPPINGS

Line 16774: INSERT INTO IEC_G_TIMEZONE_MAPPINGS

16770: DELETE IEC_G_TIMEZONE_MAPPINGS WHERE PHONE_AREA_CODE = REC.PHONE_AREA_CODE;
16771:
16772:
16773:
16774: INSERT INTO IEC_G_TIMEZONE_MAPPINGS
16775:
16776: (TIMEZONE_MAPPING_ID, TERRITORY_CODE, PHONE_AREA_CODE, POSTAL_CODE, TIMEZONE_ID, CREATED_BY,
16777:
16778: CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER)

Line 16782: (IEC_G_TIMEZONE_MAPPINGS_S.NEXTVAL, L_TERRITORY_CODE, REC.PHONE_AREA_CODE, NULL, L_TIMEZONE_ID, 0,

16778: CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER)
16779:
16780: VALUES
16781:
16782: (IEC_G_TIMEZONE_MAPPINGS_S.NEXTVAL, L_TERRITORY_CODE, REC.PHONE_AREA_CODE, NULL, L_TIMEZONE_ID, 0,
16783:
16784: SYSDATE, 0, SYSDATE, 0, 1);
16785:
16786: END IF;