APPS.IEC_VALIDATE_PVT dependencies on IEC_G_TIMEZONE_MAPPINGS

Line 3026: FROM IEC_G_TIMEZONE_MAPPINGS;

3022: (TERRITORY_CODE, AREA_CODE, POSTAL_CODE, TIMEZONE_ID)
3023:
3024: SELECT DISTINCT TERRITORY_CODE, PHONE_AREA_CODE, POSTAL_CODE, TIMEZONE_ID
3025:
3026: FROM IEC_G_TIMEZONE_MAPPINGS;
3027:
3028: ELSE
3029:
3030: INSERT INTO IEC_TZ_MAPPING_CACHE

Line 3036: FROM IEC_G_TIMEZONE_MAPPINGS;

3032: (TERRITORY_CODE, AREA_CODE, POSTAL_CODE, TIMEZONE_ID)
3033:
3034: SELECT DISTINCT TERRITORY_CODE, PHONE_AREA_CODE, NULL, TIMEZONE_ID
3035:
3036: FROM IEC_G_TIMEZONE_MAPPINGS;
3037:
3038: END IF;
3039:
3040:

Line 16710: SELECT DISTINCT PHONE_AREA_CODE FROM IEC_G_TIMEZONE_MAPPINGS;

16706:
16707:
16708: CURSOR AREA_CODE_LIST IS
16709:
16710: SELECT DISTINCT PHONE_AREA_CODE FROM IEC_G_TIMEZONE_MAPPINGS;
16711:
16712:
16713:
16714: BEGIN

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

16720:
16721:
16722: SELECT COUNT(*) INTO L_COUNT FROM
16723:
16724: (SELECT DISTINCT TIMEZONE_ID FROM IEC_G_TIMEZONE_MAPPINGS WHERE PHONE_AREA_CODE = REC.PHONE_AREA_CODE);
16725:
16726:
16727:
16728: IF L_COUNT = 1 THEN

Line 16734: FROM IEC_G_TIMEZONE_MAPPINGS

16730:
16731:
16732: SELECT DISTINCT TERRITORY_CODE INTO L_TERRITORY_CODE
16733:
16734: FROM IEC_G_TIMEZONE_MAPPINGS
16735:
16736: WHERE PHONE_AREA_CODE = REC.PHONE_AREA_CODE;
16737:
16738:

Line 16742: FROM IEC_G_TIMEZONE_MAPPINGS

16738:
16739:
16740: SELECT DISTINCT TIMEZONE_ID INTO L_TIMEZONE_ID
16741:
16742: FROM IEC_G_TIMEZONE_MAPPINGS
16743:
16744: WHERE PHONE_AREA_CODE = REC.PHONE_AREA_CODE;
16745:
16746:

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

16744: WHERE PHONE_AREA_CODE = REC.PHONE_AREA_CODE;
16745:
16746:
16747:
16748: DELETE IEC_G_TIMEZONE_MAPPINGS WHERE PHONE_AREA_CODE = REC.PHONE_AREA_CODE;
16749:
16750:
16751:
16752: INSERT INTO IEC_G_TIMEZONE_MAPPINGS

Line 16752: INSERT INTO IEC_G_TIMEZONE_MAPPINGS

16748: DELETE IEC_G_TIMEZONE_MAPPINGS WHERE PHONE_AREA_CODE = REC.PHONE_AREA_CODE;
16749:
16750:
16751:
16752: INSERT INTO IEC_G_TIMEZONE_MAPPINGS
16753:
16754: (TIMEZONE_MAPPING_ID, TERRITORY_CODE, PHONE_AREA_CODE, POSTAL_CODE, TIMEZONE_ID, CREATED_BY,
16755:
16756: CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER)

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

16756: CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER)
16757:
16758: VALUES
16759:
16760: (IEC_G_TIMEZONE_MAPPINGS_S.NEXTVAL, L_TERRITORY_CODE, REC.PHONE_AREA_CODE, NULL, L_TIMEZONE_ID, 0,
16761:
16762: SYSDATE, 0, SYSDATE, 0, 1);
16763:
16764: END IF;