DBA Data[Home] [Help]

APPS.WSH_FTE_CONSTRAINT_FRAMEWORK dependencies on WSH_REGIONS_SEARCH_PKG

Line 2742: WSH_REGIONS_SEARCH_PKG.Get_All_RegionId_Matches(

2738:
2739: l_comp_class_id := g_comp_class_tab(l_hash_value).compatibility_class_id;
2740:
2741:
2742: WSH_REGIONS_SEARCH_PKG.Get_All_RegionId_Matches(
2743: p_location_id => p_location_id,
2744: p_use_cache => TRUE,
2745: p_lang_code => USERENV('LANG'),
2746: x_region_tab => l_region_tab,

Line 2814: WSH_REGIONS_SEARCH_PKG.Get_All_Zone_Matches(

2810: END IF;
2811: END IF;
2812:
2813: -- l_object1_id currently holds the region id
2814: WSH_REGIONS_SEARCH_PKG.Get_All_Zone_Matches(
2815: p_region_id => l_region_id,
2816: x_zone_tab => l_zone_tab,
2817: x_return_status => l_return_status);
2818:

Line 3156: WSH_REGIONS_SEARCH_PKG.Get_All_RegionId_Matches(

3152: END IF;
3153:
3154: l_reg_comp_class_id := g_comp_class_tab(l_hash_value).COMPATIBILITY_CLASS_ID;
3155:
3156: WSH_REGIONS_SEARCH_PKG.Get_All_RegionId_Matches(
3157: p_location_id => p_location_id,
3158: p_use_cache => TRUE,
3159: p_lang_code => USERENV('LANG'),
3160: x_region_tab => l_region_tab,

Line 3295: WSH_DEBUG_SV.logmsg(l_module_name,' Calling WSH_REGIONS_SEARCH_PKG.Get_All_Zone_Matches ');

3291:
3292: IF NOT(l_constraint_found) THEN
3293:
3294: IF l_debug_on THEN
3295: WSH_DEBUG_SV.logmsg(l_module_name,' Calling WSH_REGIONS_SEARCH_PKG.Get_All_Zone_Matches ');
3296: END IF;
3297: WSH_REGIONS_SEARCH_PKG.Get_All_Zone_Matches(
3298: p_region_id => l_region_id,
3299: x_zone_tab => l_zone_tab,

Line 3297: WSH_REGIONS_SEARCH_PKG.Get_All_Zone_Matches(

3293:
3294: IF l_debug_on THEN
3295: WSH_DEBUG_SV.logmsg(l_module_name,' Calling WSH_REGIONS_SEARCH_PKG.Get_All_Zone_Matches ');
3296: END IF;
3297: WSH_REGIONS_SEARCH_PKG.Get_All_Zone_Matches(
3298: p_region_id => l_region_id,
3299: x_zone_tab => l_zone_tab,
3300: x_return_status => l_return_status);
3301:

Line 17882: WSH_REGIONS_SEARCH_PKG.Get_All_RegionId_Matches(

17878: IF l_debug_on THEN
17879: WSH_DEBUG_SV.logmsg(l_module_name,'g_region_mustuse_location.COUNT : '|| g_region_mustuse_location.COUNT);
17880: END IF;
17881:
17882: WSH_REGIONS_SEARCH_PKG.Get_All_RegionId_Matches(
17883: p_location_id => l_ship_to_location_id,
17884: p_use_cache => TRUE,
17885: p_lang_code => USERENV('LANG'),
17886: x_region_tab => l_region_tab,

Line 17915: WSH_REGIONS_SEARCH_PKG.Get_All_Zone_Matches(

17911:
17912: IF (l_ship_to_location_id < g_cache_max_size AND l_deconsol_location IS NOT NULL) THEN
17913: g_location_mustuse_location(l_ship_to_location_id) := l_deconsol_location;
17914: ELSIF l_deconsol_location IS NULL THEN
17915: WSH_REGIONS_SEARCH_PKG.Get_All_Zone_Matches(
17916: p_region_id => l_region_id,
17917: x_zone_tab => l_zone_tab,
17918: x_return_status => l_return_status);
17919:

Line 18078: WSH_REGIONS_SEARCH_PKG.Get_All_RegionId_Matches(

18074: IF l_debug_on THEN
18075: WSH_DEBUG_SV.logmsg(l_module_name,'g_region_mustuse_location.COUNT : '|| g_region_mustuse_location.COUNT);
18076: END IF;
18077:
18078: WSH_REGIONS_SEARCH_PKG.Get_All_RegionId_Matches(
18079: p_location_id => l_ship_from_location_id,
18080: p_use_cache => TRUE,
18081: p_lang_code => USERENV('LANG'),
18082: x_region_tab => l_region_tab,

Line 18111: WSH_REGIONS_SEARCH_PKG.Get_All_Zone_Matches(

18107:
18108: IF (l_ship_to_location_id < g_cache_max_size AND l_deconsol_location IS NOT NULL) THEN
18109: g_location_mustuse_location(l_ship_from_location_id) := l_deconsol_location;
18110: ELSIF l_deconsol_location IS NULL THEN
18111: WSH_REGIONS_SEARCH_PKG.Get_All_Zone_Matches(
18112: p_region_id => l_region_id,
18113: x_zone_tab => l_zone_tab,
18114: x_return_status => l_return_status);
18115:

Line 18267: l_region_tab WSH_REGIONS_SEARCH_PKG.region_deconsol_Tab_Type;

18263: l_rule_deconsol_location NUMBER;
18264: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
18265: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'VALIDATE_CONSTRAINT_DECONSOL';
18266: rec_cnt NUMBER;
18267: l_region_tab WSH_REGIONS_SEARCH_PKG.region_deconsol_Tab_Type;
18268: l_success VARCHAR2(1) := 'S';
18269: l_failure VARCHAR2(1) := 'F';
18270: l_zone_index NUMBER := 0;
18271: l_msg_count NUMBER := 0;

Line 18584: WSH_REGIONS_SEARCH_PKG.get_all_region_deconsols

18580: IF l_debug_on THEN
18581: WSH_DEBUG_SV.logmsg(l_module_name,'p_delivery_info(rec_cnt).ULTIMATE_DROPOFF_LOCATION_ID: '||p_delivery_info(rec_cnt).ULTIMATE_DROPOFF_LOCATION_ID);
18582: END IF;
18583:
18584: WSH_REGIONS_SEARCH_PKG.get_all_region_deconsols
18585: ( p_location_id => p_delivery_info(rec_cnt).ULTIMATE_DROPOFF_LOCATION_ID,
18586: p_use_cache => TRUE,
18587: p_lang_code => USERENV('LANG'),
18588: p_zone_flag => TRUE,

Line 18674: WSH_REGIONS_SEARCH_PKG.get_all_region_deconsols

18670: -- }
18671: ELSE -- if
18672: --{
18673:
18674: WSH_REGIONS_SEARCH_PKG.get_all_region_deconsols
18675: ( p_location_id => p_delivery_info(rec_cnt).ULTIMATE_DROPOFF_LOCATION_ID,
18676: p_use_cache => TRUE,
18677: p_lang_code => USERENV('LANG'),
18678: p_zone_flag => TRUE,