APPS.WSH_REGIONS_PKG dependencies on WSH_ZONE_REGIONS

Line 3085: FROM wsh_zone_regions z

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

Line 3102: FROM wsh_zone_regions

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

Line 3108: FROM wsh_zone_regions z

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

Line 3273: FROM wsh_zone_regions

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

Line 3290: DELETE FROM wsh_zone_regions

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

Line 3363: INSERT INTO WSH_ZONE_REGIONS (

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

Line 3377: wsh_zone_regions_s.nextval,

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

Line 3410: UPDATE wsh_zone_regions

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

Line 3447: FROM wsh_zone_regions

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

Line 4181: FROM WSH_REGIONS_TL T, WSH_ZONE_REGIONS P

4177: IS
4178: SELECT T.REGION_ID REGION_ID, T.COUNTRY COUNTRY, T.STATE STATE, T.CITY CITY,
4179: ltrim(P.POSTAL_CODE_FROM,'0') PCODE_FROM,
4180: ltrim(P.POSTAL_CODE_TO,'0') PCODE_TO
4181: FROM WSH_REGIONS_TL T, WSH_ZONE_REGIONS P
4182: WHERE T.LANGUAGE = p_lang
4183: AND T.REGION_ID = P.REGION_ID
4184: AND P.PARENT_REGION_ID = p_zoneId;
4185: