APPS.WSH_REGIONS_PKG dependencies on WSH_ZONE_REGIONS

Line 3086: FROM wsh_zone_regions z

3082: x_error_msg OUT NOCOPY VARCHAR2) IS
3083:
3084: CURSOR check_regions_in_zone(l_region_id NUMBER, l_codeFrom VARCHAR2, l_codeTo VARCHAR2) IS
3085: SELECT region_id
3086: FROM wsh_zone_regions z
3087: WHERE z.region_id in (
3088: SELECT region_id
3089: FROM wsh_regions
3090: START WITH region_id = l_region_id

Line 3103: FROM wsh_zone_regions

3099: FROM wsh_regions r
3100: WHERE region_id = l_region_id
3101: START WITH r.region_id in (
3102: SELECT region_id
3103: FROM wsh_zone_regions
3104: WHERE parent_region_id = p_zone_id)
3105: CONNECT BY PRIOR parent_region_id = region_id;
3106:
3107: CURSOR check_same_region_in_zone(l_region_id NUMBER, l_codeFrom VARCHAR2, l_codeTo VARCHAR2) IS

Line 3109: FROM wsh_zone_regions z

3105: CONNECT BY PRIOR parent_region_id = region_id;
3106:
3107: CURSOR check_same_region_in_zone(l_region_id NUMBER, l_codeFrom VARCHAR2, l_codeTo VARCHAR2) IS
3108: SELECT region_id
3109: FROM wsh_zone_regions z
3110: WHERE z.region_id in (
3111: SELECT region_id
3112: FROM wsh_regions
3113: START WITH region_id = l_region_id

Line 3274: FROM wsh_zone_regions

3270: IF (p_zone_region_id > 0 AND p_insert_type = 'DELETE') THEN
3271:
3272: SELECT count(*)
3273: INTO l_region_count
3274: FROM wsh_zone_regions
3275: WHERE parent_region_id = p_zone_id;
3276:
3277: IF (l_region_count = 1) THEN
3278:

Line 3291: DELETE FROM wsh_zone_regions

3287: --
3288: RETURN;
3289: END IF;
3290:
3291: DELETE FROM wsh_zone_regions
3292: WHERE zone_region_id = p_zone_region_id;
3293:
3294: --
3295: -- Debug Statements

Line 3364: INSERT INTO WSH_ZONE_REGIONS (

3360: RETURN;
3361: END IF;
3362:
3363: IF (p_insert_type IN ('ADD','INSERT')) THEN
3364: INSERT INTO WSH_ZONE_REGIONS (
3365: ZONE_REGION_ID,
3366: REGION_ID,
3367: PARENT_REGION_ID,
3368: POSTAL_CODE_FROM,

Line 3378: wsh_zone_regions_s.nextval,

3374: LAST_UPDATE_LOGIN,
3375: ZONE_FLAG,
3376: PARTY_ID)
3377: VALUES (
3378: wsh_zone_regions_s.nextval,
3379: l_region_id,
3380: p_zone_id,
3381: p_postal_code_from,
3382: p_postal_code_to,

Line 3411: UPDATE wsh_zone_regions

3407: END IF;
3408:
3409: ELSIF (p_zone_region_id > 0 AND p_insert_type IN ('UPDATE','SYNC')) THEN
3410:
3411: UPDATE wsh_zone_regions
3412: SET region_id = l_region_id,
3413: postal_code_from = p_postal_code_from,
3414: postal_code_to = p_postal_code_to,
3415: last_updated_by = p_user_id,

Line 3448: FROM wsh_zone_regions

3444: x_status OUT NOCOPY NUMBER) IS
3445:
3446: CURSOR lock_row IS
3447: SELECT zone_region_id, parent_region_id , region_id
3448: FROM wsh_zone_regions
3449: WHERE zone_region_id = p_zone_region_id
3450: FOR UPDATE OF zone_region_id NOWAIT;
3451:
3452: Recinfo lock_row%ROWTYPE;

Line 4208: FROM WSH_REGIONS_TL T, WSH_ZONE_REGIONS P

4204: IS
4205: SELECT T.REGION_ID REGION_ID, T.COUNTRY COUNTRY, T.STATE STATE, T.CITY CITY,
4206: ltrim(P.POSTAL_CODE_FROM,'0') PCODE_FROM,
4207: ltrim(P.POSTAL_CODE_TO,'0') PCODE_TO
4208: FROM WSH_REGIONS_TL T, WSH_ZONE_REGIONS P
4209: WHERE T.LANGUAGE = p_lang
4210: AND T.REGION_ID = P.REGION_ID
4211: AND P.PARENT_REGION_ID = p_zoneId;
4212: