eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_REGIONS_SEARCH_PKG dependencies on WSH_REGIONS

Line 1: PACKAGE BODY WSH_REGIONS_SEARCH_PKG AS

1: PACKAGE BODY WSH_REGIONS_SEARCH_PKG AS
2: /* $Header: WSHRESEB.pls 120.12.12010000.2 2008/08/29 13:21:51 selsubra ship $ */
3:
4: --
5: -- Package

Line 6: -- WSH_REGIONS_SEARCH_PKG

2: /* $Header: WSHRESEB.pls 120.12.12010000.2 2008/08/29 13:21:51 selsubra ship $ */
3:
4: --
5: -- Package
6: -- WSH_REGIONS_SEARCH_PKG
7: --
8: -- Purpose
9: --
10:

Line 56: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_REGIONS_SEARCH_PKG';

52: -- Purpose: call another Get_Region_Info with p_search_flag ='N'
53: --
54: --
55: --
56: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_REGIONS_SEARCH_PKG';
57: --
58:
59: --
60: -- PROCEDURE : get_key

Line 136: WSH_UTIL_CORE.default_handler('WSH_REGIONS_SEARCH_PKG.get_key');

132: END IF;
133: x_return_status := l_return_status;
134: EXCEPTION
135: WHEN others THEN
136: WSH_UTIL_CORE.default_handler('WSH_REGIONS_SEARCH_PKG.get_key');
137: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
138: --
139: IF l_debug_on THEN
140: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 364: ' from WSH_REGIONS_INTERFACE R, WSH_REGIONS_TL_INTERFACE TL';

360: ''N'' ';
361:
362: IF (p_interface_flag = 'Y') THEN
363: sql_string := sql_string ||
364: ' from WSH_REGIONS_INTERFACE R, WSH_REGIONS_TL_INTERFACE TL';
365: ELSE
366: sql_string := sql_string ||
367: ' from WSH_REGIONS R, WSH_REGIONS_TL TL';
368: END IF;

Line 367: ' from WSH_REGIONS R, WSH_REGIONS_TL TL';

363: sql_string := sql_string ||
364: ' from WSH_REGIONS_INTERFACE R, WSH_REGIONS_TL_INTERFACE TL';
365: ELSE
366: sql_string := sql_string ||
367: ' from WSH_REGIONS R, WSH_REGIONS_TL TL';
368: END IF;
369:
370: -- sql_string := sql_string ||
371: -- ' where R.REGION_ID = TL.REGION_ID and ROWNUM < 2 ';

Line 879: ' from WSH_REGIONS_INTERFACE R ';

875: sql_string := 'select R.REGION_ID';
876:
877: IF (p_interface_flag = 'Y') THEN
878: sql_string := sql_string ||
879: ' from WSH_REGIONS_INTERFACE R ';
880: ELSE
881: sql_string := sql_string ||
882: ' from WSH_REGIONS R ';
883: END IF;

Line 882: ' from WSH_REGIONS R ';

878: sql_string := sql_string ||
879: ' from WSH_REGIONS_INTERFACE R ';
880: ELSE
881: sql_string := sql_string ||
882: ' from WSH_REGIONS R ';
883: END IF;
884:
885:
886: IF (p_postal_code_from IS NOT NULL OR p_language_code IS NOT NULL) THEN

Line 891: ', WSH_REGIONS_TL_INTERFACE TL ';

887:
888: IF (p_interface_flag = 'Y') THEN
889:
890: sql_string := sql_string ||
891: ', WSH_REGIONS_TL_INTERFACE TL ';
892:
893: ELSE
894:
895: sql_string := sql_string ||

Line 896: ', WSH_REGIONS_TL TL ';

892:
893: ELSE
894:
895: sql_string := sql_string ||
896: ', WSH_REGIONS_TL TL ';
897:
898: END IF;
899:
900: END IF;

Line 1340: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_PKG.ADD_REGION',WSH_DEBUG_SV.C_PROC_LEVEL);

1336: -- Debug Statements
1337: --
1338: IF l_debug_on THEN
1339: WSH_DEBUG_SV.logmsg(l_module_name,nvl(l_region_info.country,l_region_info.country_code)||' '||nvl(l_region_info.state,l_region_info.state_code)||' '||nvl(l_region_info.city,l_region_info.city_code)||' '||l_region_info.postal_code_from);
1340: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_PKG.ADD_REGION',WSH_DEBUG_SV.C_PROC_LEVEL);
1341: END IF;
1342: --
1343: Wsh_Regions_Pkg.Add_Region(
1344: p_country_code => l_region_info.country_code,

Line 1343: Wsh_Regions_Pkg.Add_Region(

1339: WSH_DEBUG_SV.logmsg(l_module_name,nvl(l_region_info.country,l_region_info.country_code)||' '||nvl(l_region_info.state,l_region_info.state_code)||' '||nvl(l_region_info.city,l_region_info.city_code)||' '||l_region_info.postal_code_from);
1340: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_PKG.ADD_REGION',WSH_DEBUG_SV.C_PROC_LEVEL);
1341: END IF;
1342: --
1343: Wsh_Regions_Pkg.Add_Region(
1344: p_country_code => l_region_info.country_code,
1345: p_country_region_code => l_region_info.country_region_code,
1346: p_state_code => l_region_info.state_code,
1347: p_city_code => l_region_info.city_code,

Line 1429: FROM wsh_regions_interface r, wsh_regions_tl_interface t

1425: SELECT nvl(country, country_code) country,
1426: nvl(state,state_code) state,
1427: nvl(city,city_code) city,
1428: postal_code_from
1429: FROM wsh_regions_interface r, wsh_regions_tl_interface t
1430: WHERE r.region_id = t.region_id and r.creation_date >= l_processing_date
1431: ORDER BY country, state, city, postal_code_from;
1432:
1433: CURSOR get_loc_info (l_start_date DATE, l_end_date DATE) IS

Line 1527: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_SEARCH_PKG.MATCH_LOCATION_REGION',WSH_DEBUG_SV.C_PROC_LEVEL);

1523: --
1524: -- Debug Statements
1525: --
1526: IF l_debug_on THEN
1527: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_SEARCH_PKG.MATCH_LOCATION_REGION',WSH_DEBUG_SV.C_PROC_LEVEL);
1528: END IF;
1529: --
1530: l_region_id := Wsh_Regions_Search_Pkg.Match_Location_Region (
1531: p_country => loc.territory_short_name,

Line 1530: l_region_id := Wsh_Regions_Search_Pkg.Match_Location_Region (

1526: IF l_debug_on THEN
1527: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_SEARCH_PKG.MATCH_LOCATION_REGION',WSH_DEBUG_SV.C_PROC_LEVEL);
1528: END IF;
1529: --
1530: l_region_id := Wsh_Regions_Search_Pkg.Match_Location_Region (
1531: p_country => loc.territory_short_name,
1532: p_country_code => loc.territory_code,
1533: p_state => loc.state,
1534: p_city => loc.city,

Line 1709: WSH_UTIL_CORE.default_handler('WSH_REGIONS_SEARCH_PKG.Get_Child_Requests_Status');

1705: WSH_DEBUG_SV.pop(l_module_name);
1706: END IF;
1707: EXCEPTION
1708: WHEN others THEN
1709: WSH_UTIL_CORE.default_handler('WSH_REGIONS_SEARCH_PKG.Get_Child_Requests_Status');
1710: --
1711: IF l_debug_on THEN
1712: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1713: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

Line 1769: WSH_REGIONS_SEARCH_PKG.Process_All_Locations(

1765: IF l_debug_on THEN
1766: WSH_DEBUG_SV.logmsg(l_module_name, 'CALLING PROCESS_ALL_LOCATIONS API with location_type=BOTH' ,WSH_DEBUG_SV.C_PROC_LEVEL);
1767: END IF;
1768:
1769: WSH_REGIONS_SEARCH_PKG.Process_All_Locations(
1770: p_dummy1 => NULL,
1771: p_dummy2 => NULL,
1772: p_mode => p_mode,
1773: p_insert_flag => p_insert_flag,

Line 1786: WSH_UTIL_CORE.default_handler('WSH_REGIONS_SEARCH_PKG.Process_All_Locations');

1782: END IF;
1783:
1784: EXCEPTION
1785: WHEN others THEN
1786: WSH_UTIL_CORE.default_handler('WSH_REGIONS_SEARCH_PKG.Process_All_Locations');
1787: --
1788: IF l_debug_on THEN
1789: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1790: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

Line 2092: WSH_UTIL_CORE.default_handler('WSH_REGIONS_SEARCH_PKG.Process_All_Locations');

2088: END IF;
2089:
2090: EXCEPTION
2091: WHEN others THEN
2092: WSH_UTIL_CORE.default_handler('WSH_REGIONS_SEARCH_PKG.Process_All_Locations');
2093: --
2094: IF l_debug_on THEN
2095: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2096: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

Line 2151: WSH_UTIL_CORE.default_handler('WSH_REGIONS_SEARCH_PKG.refresh_cache');

2147: --
2148:
2149: EXCEPTION
2150: WHEN others THEN
2151: WSH_UTIL_CORE.default_handler('WSH_REGIONS_SEARCH_PKG.refresh_cache');
2152: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2153: --
2154: IF l_debug_on THEN
2155: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 2205: FROM wsh_regions wr,

2201: wr.country_region_code,
2202: wr.state_code,
2203: wr.city_code,
2204: decode(loc.parent_region_flag,'Y','N','N','Y')
2205: FROM wsh_regions wr,
2206: wsh_regions_tl wrt,
2207: wsh_region_locations loc
2208: WHERE wr.region_id = l_region_id AND
2209: loc.location_id = l_location_id AND

Line 2206: wsh_regions_tl wrt,

2202: wr.state_code,
2203: wr.city_code,
2204: decode(loc.parent_region_flag,'Y','N','N','Y')
2205: FROM wsh_regions wr,
2206: wsh_regions_tl wrt,
2207: wsh_region_locations loc
2208: WHERE wr.region_id = l_region_id AND
2209: loc.location_id = l_location_id AND
2210: wr.region_id = loc.region_id AND

Line 2230: FROM wsh_regions r,

2226: null,
2227: null,
2228: null,
2229: 'N'
2230: FROM wsh_regions r,
2231: wsh_regions_tl rt,
2232: wsh_zone_regions z
2233: WHERE r.region_id = z.parent_region_id AND
2234: z.region_id = l_region_id AND

Line 2231: wsh_regions_tl rt,

2227: null,
2228: null,
2229: 'N'
2230: FROM wsh_regions r,
2231: wsh_regions_tl rt,
2232: wsh_zone_regions z
2233: WHERE r.region_id = z.parent_region_id AND
2234: z.region_id = l_region_id AND
2235: r.region_type = 10 AND

Line 2241: FROM wsh_region_locations wrl, wsh_regions_tl wrt,

2237: rt.language = nvl(l_lang_code,rt.language);
2238:
2239: CURSOR Check_Location_Exists(c_location_id IN NUMBER,c_lang_code IN VARCHAR2) IS
2240: SELECT 'exists'
2241: FROM wsh_region_locations wrl, wsh_regions_tl wrt,
2242: wsh_regions wr
2243: WHERE wrl.region_id is not null
2244: AND wrl.location_id = c_location_id
2245: AND wrl.region_id = wrt.region_id

Line 2242: wsh_regions wr

2238:
2239: CURSOR Check_Location_Exists(c_location_id IN NUMBER,c_lang_code IN VARCHAR2) IS
2240: SELECT 'exists'
2241: FROM wsh_region_locations wrl, wsh_regions_tl wrt,
2242: wsh_regions wr
2243: WHERE wrl.region_id is not null
2244: AND wrl.location_id = c_location_id
2245: AND wrl.region_id = wrt.region_id
2246: AND wrt.language = nvl(c_lang_code,wrt.language)

Line 2347: FROM wsh_region_locations wrl,wsh_regions_tl wrt,wsh_regions wr

2343: IF l_exists IS NOT NULL THEN
2344: /*
2345: SELECT wrl.region_id
2346: BULK COLLECT INTO l_rgid_tab
2347: FROM wsh_region_locations wrl,wsh_regions_tl wrt,wsh_regions wr
2348: WHERE wrl.location_id = p_location_id
2349: AND wrl.region_id is not null
2350: AND wrl.region_id = wrt.region_id
2351: AND wrt.language = nvl(p_lang_code,wrt.language)

Line 2699: WSH_UTIL_CORE.default_handler('WSH_REGIONS_SEARCH_PKG.Get_All_Region_Matches');

2695: --
2696: --Bug 4775798
2697: EXCEPTION
2698: WHEN OTHERS THEN
2699: WSH_UTIL_CORE.default_handler('WSH_REGIONS_SEARCH_PKG.Get_All_Region_Matches');
2700: IF l_debug_on THEN
2701: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2702: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2703: ELSE

Line 2704: WSH_UTIL_CORE.printmsg('Unexpected error has occured in WSH_REGIONS_SEARCH_PKG.Get_All_Region_Matches');

2700: IF l_debug_on THEN
2701: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2702: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2703: ELSE
2704: WSH_UTIL_CORE.printmsg('Unexpected error has occured in WSH_REGIONS_SEARCH_PKG.Get_All_Region_Matches');
2705: WSH_UTIL_CORE.printmsg(SQLERRM);
2706: END IF;
2707: END Get_All_Region_Matches;
2708:

Line 2728: FROM wsh_region_locations wrl,wsh_regions_tl wrt,wsh_regions wr

2724:
2725:
2726: CURSOR c_get_all_region_id(l_location_id IN NUMBER, l_lang_code IN VARCHAR2) IS
2727: SELECT wrl.region_id
2728: FROM wsh_region_locations wrl,wsh_regions_tl wrt,wsh_regions wr
2729: WHERE wrl.location_id = l_location_id
2730: AND wrl.region_id is not null
2731: AND wrl.region_id = wrt.region_id
2732: AND wrt.language = nvl(l_lang_code,wrt.language)

Line 2817: WSH_UTIL_CORE.default_handler('WSH_REGIONS_SEARCH_PKG.Get_All_RegionId_Matches');

2813: WHEN others THEN
2814: IF c_get_all_region_id%ISOPEN THEN
2815: CLOSE c_get_all_region_id;
2816: END IF;
2817: WSH_UTIL_CORE.default_handler('WSH_REGIONS_SEARCH_PKG.Get_All_RegionId_Matches');
2818: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2819: --
2820: IF l_debug_on THEN
2821: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 2846: FROM wsh_zone_regions wzr,wsh_regions wr

2842: x_return_status OUT NOCOPY VARCHAR2) IS
2843:
2844: CURSOR c_get_zone_for_region(c_region_id IN NUMBER) IS
2845: SELECT wr.region_id
2846: FROM wsh_zone_regions wzr,wsh_regions wr
2847: WHERE wzr.region_id = c_region_id
2848: AND zone_flag = 'Y'
2849: AND wzr.parent_region_id = wr.region_id
2850: AND wr.region_type=10;

Line 2931: WSH_UTIL_CORE.default_handler('WSH_REGIONS_SEARCH_PKG.Get_All_Zone_Matches');

2927: WHEN others THEN
2928: IF c_get_zone_for_region%ISOPEN THEN
2929: CLOSE c_get_zone_for_region;
2930: END IF;
2931: WSH_UTIL_CORE.default_handler('WSH_REGIONS_SEARCH_PKG.Get_All_Zone_Matches');
2932: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2933: --
2934: IF l_debug_on THEN
2935: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 2990: FROM wsh_region_locations wrl,wsh_regions_tl wrt,wsh_regions wr

2986: CURSOR c_get_all_regions_loc(c_location_id IN NUMBER, c_lang_code IN VARCHAR2) IS
2987: SELECT wrl.region_id,
2988: wr.region_type,
2989: wr.deconsol_location_id
2990: FROM wsh_region_locations wrl,wsh_regions_tl wrt,wsh_regions wr
2991: WHERE wrl.location_id = c_location_id
2992: AND wrl.region_id IS NOT NULL
2993: AND wrl.region_id = wrt.region_id
2994: AND wrt.language = nvl('US',wrt.language)

Line 3004: FROM wsh_zone_regions wzr,wsh_regions wr

3000: SELECT wr.region_id,
3001: --null,
3002: wr.region_type,
3003: wr.deconsol_location_id
3004: FROM wsh_zone_regions wzr,wsh_regions wr
3005: WHERE wzr.region_id = c_region_id
3006: AND zone_flag = 'Y'
3007: AND wzr.parent_region_id = wr.region_id
3008: AND wr.region_type=10

Line 3204: WSH_UTIL_CORE.default_handler('WSH_REGIONS_SEARCH_PKG.get_all_region_deconsols');

3200: END IF;
3201: IF c_get_zone_for_region%ISOPEN THEN
3202: CLOSE c_get_zone_for_region;
3203: END IF;
3204: WSH_UTIL_CORE.default_handler('WSH_REGIONS_SEARCH_PKG.get_all_region_deconsols');
3205: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3206: --
3207: IF l_debug_on THEN
3208: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

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 3231: x_region_info OUT NOCOPY WSH_REGIONS_SEARCH_PKG.region_rec)

3227: p_region_type IN NUMBER,
3228: p_search_flag IN VARCHAR2,
3229: p_lang_code IN VARCHAR2,
3230: x_return_status OUT NOCOPY VARCHAR2,
3231: x_region_info OUT NOCOPY WSH_REGIONS_SEARCH_PKG.region_rec)
3232: IS
3233:
3234: CURSOR C1 IS
3235: SELECT REGION_ID

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 3358: x_region_info OUT NOCOPY WSH_REGIONS_SEARCH_PKG.region_rec)

3354: p_region_type IN NUMBER,
3355: p_search_flag IN VARCHAR2,
3356: p_lang_code IN VARCHAR2,
3357: x_return_status OUT NOCOPY VARCHAR2,
3358: x_region_info OUT NOCOPY WSH_REGIONS_SEARCH_PKG.region_rec)
3359: IS
3360:
3361: CURSOR C1 IS
3362: SELECT REGION_ID

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)

Line 3601: END WSH_REGIONS_SEARCH_PKG;

3597:
3598: END;
3599:
3600:
3601: END WSH_REGIONS_SEARCH_PKG;