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_MAP_LOCATION_REGION_PKG dependencies on WSH_REGIONS_SEARCH_PKG

Line 263: WSH_REGIONS_SEARCH_PKG.Process_All_Locations(

259: END IF;
260:
261: IF p_map_regions = 'Y' THEN
262:
263: WSH_REGIONS_SEARCH_PKG.Process_All_Locations(
264: p_dummy1 => NULL,
265: p_dummy2 => NULL,
266: p_mode => l_mode,
267: p_insert_flag => l_insert_flag,

Line 279: WSH_REGIONS_SEARCH_PKG.Process_All_Locations(

275: END IF;
276:
277: ELSIF l_req_data = '1' and p_map_regions = 'Y' THEN
278:
279: WSH_REGIONS_SEARCH_PKG.Process_All_Locations(
280: p_dummy1 => NULL,
281: p_dummy2 => NULL,
282: p_mode => l_mode,
283: p_insert_flag => l_insert_flag,

Line 290: WSH_REGIONS_SEARCH_PKG.get_child_requests_status(x_completion_status => l_completion_status);

286: p_end_date => p_end_date,
287: p_num_of_instances => p_num_of_instances
288: );
289: ELSE
290: WSH_REGIONS_SEARCH_PKG.get_child_requests_status(x_completion_status => l_completion_status);
291:
292: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS(l_completion_status,'');
293: END IF;
294:

Line 1303: | WSH_REGIONS_SEARCH_PKG.Get_Region_Info which inturn returns |

1299: | Map_Location_To_Region |
1300: | |
1301: | DESCRIPTION |
1302: | This API does the main mapping process. It calls the API |
1303: | WSH_REGIONS_SEARCH_PKG.Get_Region_Info which inturn returns |
1304: | the region id. For this particuar region, the parent regions |
1305: | are also obtained and all these are inserted into the |
1306: | intersection table. |
1307: | |

Line 1325: l_region_info WSH_REGIONS_SEARCH_PKG.region_rec;

1321: x_sqlcode OUT NOCOPY NUMBER,
1322: x_sqlerr OUT NOCOPY VARCHAR2) IS
1323:
1324:
1325: l_region_info WSH_REGIONS_SEARCH_PKG.region_rec;
1326: l_region_type NUMBER := 0;
1327: l_region_id NUMBER := 0;
1328: l_region_table WSH_REGIONS_SEARCH_PKG.region_table;
1329: l_country l_region_info.country%TYPE;

Line 1328: l_region_table WSH_REGIONS_SEARCH_PKG.region_table;

1324:
1325: l_region_info WSH_REGIONS_SEARCH_PKG.region_rec;
1326: l_region_type NUMBER := 0;
1327: l_region_id NUMBER := 0;
1328: l_region_table WSH_REGIONS_SEARCH_PKG.region_table;
1329: l_country l_region_info.country%TYPE;
1330: l_return_status VARCHAR2(10);
1331: Insert_Failed EXCEPTION;
1332: l_sqlcode NUMBER;

Line 1448: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_SEARCH_PKG.GET_ALL_REGION_MATCHES');

1444: -- START affected area
1445: -- change call to use get_all_region_matches
1446:
1447: IF l_debug_on THEN
1448: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_SEARCH_PKG.GET_ALL_REGION_MATCHES');
1449: END IF;
1450:
1451: WSH_REGIONS_SEARCH_PKG.Get_All_Region_Matches(
1452: p_country => l_country,

Line 1451: WSH_REGIONS_SEARCH_PKG.Get_All_Region_Matches(

1447: IF l_debug_on THEN
1448: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_SEARCH_PKG.GET_ALL_REGION_MATCHES');
1449: END IF;
1450:
1451: WSH_REGIONS_SEARCH_PKG.Get_All_Region_Matches(
1452: p_country => l_country,
1453: p_country_region => l_region_info.country_region,
1454: p_state => l_region_info.state,
1455: p_city => l_region_info.city,

Line 2791: WSH_REGIONS_SEARCH_PKG.Get_All_RegionId_Matches(p_location_id =>p_ship_from_loc_id,

2787:
2788: /* From Region, To Location */
2789:
2790:
2791: WSH_REGIONS_SEARCH_PKG.Get_All_RegionId_Matches(p_location_id =>p_ship_from_loc_id,
2792: x_region_tab => get_From_Region_tab,
2793: p_lang_code=>USERENV('LANG'),
2794: x_return_status =>l_return_status);
2795:

Line 2811: WSH_REGIONS_SEARCH_PKG.Get_All_Zone_Matches(

2807: RETURN;
2808: END IF;
2809:
2810:
2811: WSH_REGIONS_SEARCH_PKG.Get_All_Zone_Matches(
2812: p_region_id =>get_From_Region_tab(i),
2813: x_zone_tab =>Region_Loc_zone_tab,
2814: x_return_status =>l_return_status);
2815:

Line 2837: WSH_REGIONS_SEARCH_PKG.Get_All_RegionId_Matches(p_location_id =>p_ship_to_site_id,

2833:
2834:
2835: /* From Location, To Region */
2836:
2837: WSH_REGIONS_SEARCH_PKG.Get_All_RegionId_Matches(p_location_id =>p_ship_to_site_id,
2838: p_lang_code=>USERENV('LANG'),
2839: x_region_tab => get_To_Region_tab,
2840: x_return_status =>l_return_status);
2841:

Line 2858: WSH_REGIONS_SEARCH_PKG.Get_All_Zone_Matches(

2854: RETURN;
2855: END IF;
2856:
2857:
2858: WSH_REGIONS_SEARCH_PKG.Get_All_Zone_Matches(
2859: p_region_id =>get_To_Region_tab(i),
2860: x_zone_tab =>Loc_Region_zone_tab,
2861: x_return_status =>l_return_status);
2862:

Line 2901: WSH_REGIONS_SEARCH_PKG.Get_All_Zone_Matches(

2897: x_transit_time :=l_transit_time;
2898: RETURN;
2899: END IF;
2900:
2901: WSH_REGIONS_SEARCH_PKG.Get_All_Zone_Matches(
2902: p_region_id =>get_From_Region_tab(j),
2903: x_zone_tab =>Region_Loc_zone_tab,
2904: x_return_status =>l_return_status);
2905: IF Region_Loc_zone_tab.count >0 THEN

Line 2921: WSH_REGIONS_SEARCH_PKG.Get_All_Zone_Matches(

2917: END LOOP;
2918: END IF;
2919:
2920:
2921: WSH_REGIONS_SEARCH_PKG.Get_All_Zone_Matches(
2922: p_region_id =>get_To_Region_tab(i),
2923: x_zone_tab =>Loc_Region_zone_tab,
2924: x_return_status =>l_return_status);
2925: IF Loc_Region_zone_tab.count >0 THEN

Line 2967: WSH_REGIONS_SEARCH_PKG.Get_All_Zone_Matches(

2963: x_transit_time :=l_transit_time;
2964: RETURN;
2965: END IF;
2966:
2967: WSH_REGIONS_SEARCH_PKG.Get_All_Zone_Matches(
2968: p_region_id =>get_To_Region_tab(j),
2969: x_zone_tab =>Loc_Region_zone_tab,
2970: x_return_status =>l_return_status);
2971: IF Loc_Region_zone_tab.count >0 THEN

Line 2987: WSH_REGIONS_SEARCH_PKG.Get_All_Zone_Matches(

2983: END LOOP;
2984: END IF;
2985:
2986:
2987: WSH_REGIONS_SEARCH_PKG.Get_All_Zone_Matches(
2988: p_region_id =>get_From_Region_tab(i),
2989: x_zone_tab =>Region_Loc_zone_tab,
2990: x_return_status =>l_return_status);
2991: IF Region_Loc_zone_tab.count >0 THEN