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 1319: | WSH_REGIONS_SEARCH_PKG.Get_Region_Info which inturn returns |

1315: | Map_Location_To_Region |
1316: | |
1317: | DESCRIPTION |
1318: | This API does the main mapping process. It calls the API |
1319: | WSH_REGIONS_SEARCH_PKG.Get_Region_Info which inturn returns |
1320: | the region id. For this particuar region, the parent regions |
1321: | are also obtained and all these are inserted into the |
1322: | intersection table. |
1323: | |

Line 1341: l_region_info WSH_REGIONS_SEARCH_PKG.region_rec;

1337: x_sqlcode OUT NOCOPY NUMBER,
1338: x_sqlerr OUT NOCOPY VARCHAR2) IS
1339:
1340:
1341: l_region_info WSH_REGIONS_SEARCH_PKG.region_rec;
1342: l_region_type NUMBER := 0;
1343: l_region_id NUMBER := 0;
1344: l_region_table WSH_REGIONS_SEARCH_PKG.region_table;
1345: l_country l_region_info.country%TYPE;

Line 1344: l_region_table WSH_REGIONS_SEARCH_PKG.region_table;

1340:
1341: l_region_info WSH_REGIONS_SEARCH_PKG.region_rec;
1342: l_region_type NUMBER := 0;
1343: l_region_id NUMBER := 0;
1344: l_region_table WSH_REGIONS_SEARCH_PKG.region_table;
1345: l_country l_region_info.country%TYPE;
1346: l_return_status VARCHAR2(10);
1347: Insert_Failed EXCEPTION;
1348: l_sqlcode NUMBER;

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

1460: -- START affected area
1461: -- change call to use get_all_region_matches
1462:
1463: IF l_debug_on THEN
1464: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_SEARCH_PKG.GET_ALL_REGION_MATCHES');
1465: END IF;
1466:
1467: WSH_REGIONS_SEARCH_PKG.Get_All_Region_Matches(
1468: p_country => l_country,

Line 1467: WSH_REGIONS_SEARCH_PKG.Get_All_Region_Matches(

1463: IF l_debug_on THEN
1464: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_SEARCH_PKG.GET_ALL_REGION_MATCHES');
1465: END IF;
1466:
1467: WSH_REGIONS_SEARCH_PKG.Get_All_Region_Matches(
1468: p_country => l_country,
1469: p_country_region => l_region_info.country_region,
1470: p_state => l_region_info.state,
1471: p_city => l_region_info.city,

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

2803:
2804: /* From Region, To Location */
2805:
2806:
2807: WSH_REGIONS_SEARCH_PKG.Get_All_RegionId_Matches(p_location_id =>p_ship_from_loc_id,
2808: x_region_tab => get_From_Region_tab,
2809: p_lang_code=>USERENV('LANG'),
2810: x_return_status =>l_return_status);
2811:

Line 2827: WSH_REGIONS_SEARCH_PKG.Get_All_Zone_Matches(

2823: RETURN;
2824: END IF;
2825:
2826:
2827: WSH_REGIONS_SEARCH_PKG.Get_All_Zone_Matches(
2828: p_region_id =>get_From_Region_tab(i),
2829: x_zone_tab =>Region_Loc_zone_tab,
2830: x_return_status =>l_return_status);
2831:

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

2849:
2850:
2851: /* From Location, To Region */
2852:
2853: WSH_REGIONS_SEARCH_PKG.Get_All_RegionId_Matches(p_location_id =>p_ship_to_site_id,
2854: p_lang_code=>USERENV('LANG'),
2855: x_region_tab => get_To_Region_tab,
2856: x_return_status =>l_return_status);
2857:

Line 2874: WSH_REGIONS_SEARCH_PKG.Get_All_Zone_Matches(

2870: RETURN;
2871: END IF;
2872:
2873:
2874: WSH_REGIONS_SEARCH_PKG.Get_All_Zone_Matches(
2875: p_region_id =>get_To_Region_tab(i),
2876: x_zone_tab =>Loc_Region_zone_tab,
2877: x_return_status =>l_return_status);
2878:

Line 2917: WSH_REGIONS_SEARCH_PKG.Get_All_Zone_Matches(

2913: x_transit_time :=l_transit_time;
2914: RETURN;
2915: END IF;
2916:
2917: WSH_REGIONS_SEARCH_PKG.Get_All_Zone_Matches(
2918: p_region_id =>get_From_Region_tab(j),
2919: x_zone_tab =>Region_Loc_zone_tab,
2920: x_return_status =>l_return_status);
2921: IF Region_Loc_zone_tab.count >0 THEN

Line 2937: WSH_REGIONS_SEARCH_PKG.Get_All_Zone_Matches(

2933: END LOOP;
2934: END IF;
2935:
2936:
2937: WSH_REGIONS_SEARCH_PKG.Get_All_Zone_Matches(
2938: p_region_id =>get_To_Region_tab(i),
2939: x_zone_tab =>Loc_Region_zone_tab,
2940: x_return_status =>l_return_status);
2941: IF Loc_Region_zone_tab.count >0 THEN

Line 2983: WSH_REGIONS_SEARCH_PKG.Get_All_Zone_Matches(

2979: x_transit_time :=l_transit_time;
2980: RETURN;
2981: END IF;
2982:
2983: WSH_REGIONS_SEARCH_PKG.Get_All_Zone_Matches(
2984: p_region_id =>get_To_Region_tab(j),
2985: x_zone_tab =>Loc_Region_zone_tab,
2986: x_return_status =>l_return_status);
2987: IF Loc_Region_zone_tab.count >0 THEN

Line 3003: WSH_REGIONS_SEARCH_PKG.Get_All_Zone_Matches(

2999: END LOOP;
3000: END IF;
3001:
3002:
3003: WSH_REGIONS_SEARCH_PKG.Get_All_Zone_Matches(
3004: p_region_id =>get_From_Region_tab(i),
3005: x_zone_tab =>Region_Loc_zone_tab,
3006: x_return_status =>l_return_status);
3007: IF Region_Loc_zone_tab.count >0 THEN