APPS.WSH_REGIONS_SEARCH_PKG dependencies on WSH_REGIONS_GLOBAL

Line 3219: -- PURPOSE : Checks whether region exists in Wsh_Regions_Global_Data

3215:
3216: --
3217: -- PROCEDURE : Check_Region_Info
3218: --
3219: -- PURPOSE : Checks whether region exists in Wsh_Regions_Global_Data
3220: -- table based on parameters passed to it.
3221: PROCEDURE Check_Region_Info (
3222: p_country IN VARCHAR2,
3223: p_state IN VARCHAR2,

Line 3236: FROM WSH_REGIONS_GLOBAL_DATA

3232: IS
3233:
3234: CURSOR C1 IS
3235: SELECT REGION_ID
3236: FROM WSH_REGIONS_GLOBAL_DATA
3237: WHERE ( city = UPPER(p_city) or p_city is null )
3238: AND ( state = UPPER(p_state) or p_state is null )
3239: AND country = UPPER(p_country)
3240: AND ( p_postal_code_from is null

Line 3248: FROM WSH_REGIONS_GLOBAL_DATA

3244: AND language = p_lang_code;
3245:
3246: CURSOR C2 IS
3247: SELECT REGION_ID
3248: FROM WSH_REGIONS_GLOBAL_DATA
3249: WHERE ( city = UPPER(p_city) )
3250: AND ( nvl(state, UPPER(p_state)) = UPPER(p_state) )
3251: AND country = UPPER(p_country)
3252: AND ( p_postal_code_from is null

Line 3345: -- PURPOSE : Checks whether region exists in Wsh_Regions_Global_Data

3341:
3342: --
3343: -- PROCEDURE : Check_Region_Info_Code
3344: --
3345: -- PURPOSE : Checks whether region exists in Wsh_Regions_Global_Data
3346: -- table based on parameters passed to it.
3347: PROCEDURE Check_Region_Info_Code (
3348: p_country IN VARCHAR2,
3349: p_state IN VARCHAR2,

Line 3363: FROM WSH_REGIONS_GLOBAL_DATA

3359: IS
3360:
3361: CURSOR C1 IS
3362: SELECT REGION_ID
3363: FROM WSH_REGIONS_GLOBAL_DATA
3364: WHERE ( city = UPPER(p_city) or p_city is null )
3365: AND ( decode(p_city, null, state, nvl(state, UPPER(p_state))) = UPPER(p_state)
3366: OR ( p_state is null ) )
3367: AND country = UPPER(p_country)

Line 3456: -- PURPOSE : Checks whether region exists in Wsh_Regions_Global_Data/

3452:
3453: --
3454: -- PROCEDURE : Check_Region_Id_Codes_Only
3455: --
3456: -- PURPOSE : Checks whether region exists in Wsh_Regions_Global_Data/
3457: -- Wsh_Regions_Global table based on parameters passed to it.
3458:
3459: PROCEDURE Check_Region_Id_Codes_Only (
3460: p_country_code IN VARCHAR2,

Line 3457: -- Wsh_Regions_Global table based on parameters passed to it.

3453: --
3454: -- PROCEDURE : Check_Region_Id_Codes_Only
3455: --
3456: -- PURPOSE : Checks whether region exists in Wsh_Regions_Global_Data/
3457: -- Wsh_Regions_Global table based on parameters passed to it.
3458:
3459: PROCEDURE Check_Region_Id_Codes_Only (
3460: p_country_code IN VARCHAR2,
3461: p_state_code IN VARCHAR2,

Line 3472: FROM WSH_REGIONS_GLOBAL_DATA

3468: x_region_id OUT NOCOPY NUMBER )
3469: IS
3470: CURSOR C1 IS
3471: SELECT REGION_ID
3472: FROM WSH_REGIONS_GLOBAL_DATA
3473: WHERE ( city_code = UPPER(p_city_code) or p_city_code is null )
3474: AND ( decode(p_city_code, null, state_code, nvl(state_code, UPPER(p_state_code))) = UPPER(p_state_code)
3475: OR ( p_state_code is null ) )
3476: AND country_code = UPPER(p_country_code)

Line 3485: FROM WSH_REGIONS_GLOBAL

3481: AND language = nvl(p_language_code, language);
3482:
3483: CURSOR C2 IS
3484: SELECT REGION_ID
3485: FROM WSH_REGIONS_GLOBAL
3486: WHERE ( city_code = UPPER(p_city_code) or p_city_code is null )
3487: AND ( decode(p_city_code, null, state_code, nvl(state_code, UPPER(p_state_code))) = UPPER(p_state_code)
3488: OR ( p_state_code is null ) )
3489: AND country_code = UPPER(p_country_code)