APPS.WSH_REGIONS_SEARCH_PKG dependencies on WSH_REGIONS_GLOBAL

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

3486:
3487: --
3488: -- PROCEDURE : Check_Region_Info
3489: --
3490: -- PURPOSE : Checks whether region exists in Wsh_Regions_Global_Data
3491: -- table based on parameters passed to it.
3492: PROCEDURE Check_Region_Info (
3493: p_country IN VARCHAR2,
3494: p_state IN VARCHAR2,

Line 3507: FROM WSH_REGIONS_GLOBAL_DATA

3503: IS
3504:
3505: CURSOR C1 IS
3506: SELECT REGION_ID
3507: FROM WSH_REGIONS_GLOBAL_DATA
3508: WHERE ( city = UPPER(p_city) or p_city is null )
3509: AND ( state = UPPER(p_state) or p_state is null )
3510: AND country = UPPER(p_country)
3511: AND ( p_postal_code_from is null

Line 3519: FROM WSH_REGIONS_GLOBAL_DATA

3515: AND language = p_lang_code;
3516:
3517: CURSOR C2 IS
3518: SELECT REGION_ID
3519: FROM WSH_REGIONS_GLOBAL_DATA
3520: WHERE ( city = UPPER(p_city) )
3521: AND ( nvl(state, UPPER(p_state)) = UPPER(p_state) )
3522: AND country = UPPER(p_country)
3523: AND ( p_postal_code_from is null

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

3612:
3613: --
3614: -- PROCEDURE : Check_Region_Info_Code
3615: --
3616: -- PURPOSE : Checks whether region exists in Wsh_Regions_Global_Data
3617: -- table based on parameters passed to it.
3618: PROCEDURE Check_Region_Info_Code (
3619: p_country IN VARCHAR2,
3620: p_state IN VARCHAR2,

Line 3634: FROM WSH_REGIONS_GLOBAL_DATA

3630: IS
3631:
3632: CURSOR C1 IS
3633: SELECT REGION_ID
3634: FROM WSH_REGIONS_GLOBAL_DATA
3635: WHERE ( city = UPPER(p_city) or p_city is null )
3636: AND ( decode(p_city, null, state, nvl(state, UPPER(p_state))) = UPPER(p_state)
3637: OR ( p_state is null ) )
3638: AND country = UPPER(p_country)

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

3723:
3724: --
3725: -- PROCEDURE : Check_Region_Id_Codes_Only
3726: --
3727: -- PURPOSE : Checks whether region exists in Wsh_Regions_Global_Data/
3728: -- Wsh_Regions_Global table based on parameters passed to it.
3729:
3730: PROCEDURE Check_Region_Id_Codes_Only (
3731: p_country_code IN VARCHAR2,

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

3724: --
3725: -- PROCEDURE : Check_Region_Id_Codes_Only
3726: --
3727: -- PURPOSE : Checks whether region exists in Wsh_Regions_Global_Data/
3728: -- Wsh_Regions_Global table based on parameters passed to it.
3729:
3730: PROCEDURE Check_Region_Id_Codes_Only (
3731: p_country_code IN VARCHAR2,
3732: p_state_code IN VARCHAR2,

Line 3743: FROM WSH_REGIONS_GLOBAL_DATA

3739: x_region_id OUT NOCOPY NUMBER )
3740: IS
3741: CURSOR C1 IS
3742: SELECT REGION_ID
3743: FROM WSH_REGIONS_GLOBAL_DATA
3744: WHERE ( city_code = UPPER(p_city_code) or p_city_code is null )
3745: AND ( decode(p_city_code, null, state_code, nvl(state_code, UPPER(p_state_code))) = UPPER(p_state_code)
3746: OR ( p_state_code is null ) )
3747: AND country_code = UPPER(p_country_code)

Line 3756: FROM WSH_REGIONS_GLOBAL

3752: AND language = nvl(p_language_code, language);
3753:
3754: CURSOR C2 IS
3755: SELECT REGION_ID
3756: FROM WSH_REGIONS_GLOBAL
3757: WHERE ( city_code = UPPER(p_city_code) or p_city_code is null )
3758: AND ( decode(p_city_code, null, state_code, nvl(state_code, UPPER(p_state_code))) = UPPER(p_state_code)
3759: OR ( p_state_code is null ) )
3760: AND country_code = UPPER(p_country_code)