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

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 566: and ( ( region_id in (select wrt.region_id from wsh_regions_tl wrt,

562:
563: FORALL i IN l_del_loc_id_tab.first .. l_del_loc_id_tab.last
564:
565: DELETE from wsh_region_locations where location_id = l_del_loc_id_tab(i)
566: and ( ( region_id in (select wrt.region_id from wsh_regions_tl wrt,
567: wsh_regions wr
568: where wrt.region_id = wr.region_id
569: and wrt.language = USERENV('LANG'))
570: ) OR region_id IS NULL);

Line 567: wsh_regions wr

563: FORALL i IN l_del_loc_id_tab.first .. l_del_loc_id_tab.last
564:
565: DELETE from wsh_region_locations where location_id = l_del_loc_id_tab(i)
566: and ( ( region_id in (select wrt.region_id from wsh_regions_tl wrt,
567: wsh_regions wr
568: where wrt.region_id = wr.region_id
569: and wrt.language = USERENV('LANG'))
570: ) OR region_id IS NULL);
571:

Line 630: and region_id in (select wrt.region_id from wsh_regions_tl wrt,

626:
627: UPDATE wsh_region_locations
628: SET exception_type = 'Y'
629: WHERE location_id = l_upd_loc_id_tab(cnt)
630: and region_id in (select wrt.region_id from wsh_regions_tl wrt,
631: wsh_regions wr
632: where wrt.region_id = wr.region_id
633: and wrt.language = USERENV('LANG'));
634:

Line 631: wsh_regions wr

627: UPDATE wsh_region_locations
628: SET exception_type = 'Y'
629: WHERE location_id = l_upd_loc_id_tab(cnt)
630: and region_id in (select wrt.region_id from wsh_regions_tl wrt,
631: wsh_regions wr
632: where wrt.region_id = wr.region_id
633: and wrt.language = USERENV('LANG'));
634:
635: IF l_debug_on THEN

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 1376: FROM wsh_regions_tl wrt, wsh_regions wr

1372: WHERE location_id = p_location_id
1373: AND ( ( region_id IN
1374: (
1375: SELECT wrt.region_id
1376: FROM wsh_regions_tl wrt, wsh_regions wr
1377: WHERE wrt.region_id = wr.region_id
1378: AND wrt.language = USERENV('LANG'))
1379: )
1380: OR region_id IS NULL);

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 1495: from wsh_regions_tl wrt,

1491: from wsh_region_locations
1492: where location_id = p_location_id
1493: and ( ( region_id in
1494: ( select wrt.region_id
1495: from wsh_regions_tl wrt,
1496: wsh_regions wr
1497: where wrt.region_id = wr.region_id
1498: and wrt.language = USERENV('LANG') )
1499: ) OR region_id IS NULL )

Line 1496: wsh_regions wr

1492: where location_id = p_location_id
1493: and ( ( region_id in
1494: ( select wrt.region_id
1495: from wsh_regions_tl wrt,
1496: wsh_regions wr
1497: where wrt.region_id = wr.region_id
1498: and wrt.language = USERENV('LANG') )
1499: ) OR region_id IS NULL )
1500: order by region_type desc;

Line 1577: and ( ( region_id in (select wrt.region_id from wsh_regions_tl wrt,

1573:
1574: IF p_insert_flag THEN
1575: IF ( l_region_detail_tab.COUNT > 1 ) THEN
1576: DELETE from wsh_region_locations where location_id = p_location_id
1577: and ( ( region_id in (select wrt.region_id from wsh_regions_tl wrt,
1578: wsh_regions wr
1579: where wrt.region_id = wr.region_id
1580: and wrt.language = USERENV('LANG'))
1581: ) OR region_id IS NULL);

Line 1578: wsh_regions wr

1574: IF p_insert_flag THEN
1575: IF ( l_region_detail_tab.COUNT > 1 ) THEN
1576: DELETE from wsh_region_locations where location_id = p_location_id
1577: and ( ( region_id in (select wrt.region_id from wsh_regions_tl wrt,
1578: wsh_regions wr
1579: where wrt.region_id = wr.region_id
1580: and wrt.language = USERENV('LANG'))
1581: ) OR region_id IS NULL);
1582: END IF;

Line 1639: and ( ( region_id in (select wrt.region_id from wsh_regions_tl wrt,

1635: l_region_detail_tab(1).region_id is null AND
1636: l_region_detail_tab(1).region_type is null )
1637: THEN
1638: DELETE from wsh_region_locations where location_id = p_location_id
1639: and ( ( region_id in (select wrt.region_id from wsh_regions_tl wrt,
1640: wsh_regions wr
1641: where wrt.region_id = wr.region_id
1642: and wrt.language = USERENV('LANG'))
1643: ) OR region_id IS NULL);

Line 1640: wsh_regions wr

1636: l_region_detail_tab(1).region_type is null )
1637: THEN
1638: DELETE from wsh_region_locations where location_id = p_location_id
1639: and ( ( region_id in (select wrt.region_id from wsh_regions_tl wrt,
1640: wsh_regions wr
1641: where wrt.region_id = wr.region_id
1642: and wrt.language = USERENV('LANG'))
1643: ) OR region_id IS NULL);
1644: --

Line 1717: from wsh_regions_tl wrt,

1713: WHERE location_id = p_location_id
1714: AND region_type = l_region_detail_tab(l_region_counter).region_type
1715: AND region_id in
1716: ( select wrt.region_id
1717: from wsh_regions_tl wrt,
1718: wsh_regions wr
1719: where wr.region_id = wrt.region_id
1720: and wrt.language = USERENV('LANG') );
1721:

Line 1718: wsh_regions wr

1714: AND region_type = l_region_detail_tab(l_region_counter).region_type
1715: AND region_id in
1716: ( select wrt.region_id
1717: from wsh_regions_tl wrt,
1718: wsh_regions wr
1719: where wr.region_id = wrt.region_id
1720: and wrt.language = USERENV('LANG') );
1721:
1722: IF l_debug_on THEN

Line 1819: and region_id in (select wrt.region_id from wsh_regions_tl wrt,

1815: last_update_date = sysdate,
1816: last_updated_by = FND_GLOBAL.user_id,
1817: last_update_login = FND_GLOBAL.login_id
1818: WHERE location_id = p_location_id
1819: and region_id in (select wrt.region_id from wsh_regions_tl wrt,
1820: wsh_regions wr
1821: where wrt.region_id = wr.region_id
1822: and wrt.language = USERENV('LANG'));
1823:

Line 1820: wsh_regions wr

1816: last_updated_by = FND_GLOBAL.user_id,
1817: last_update_login = FND_GLOBAL.login_id
1818: WHERE location_id = p_location_id
1819: and region_id in (select wrt.region_id from wsh_regions_tl wrt,
1820: wsh_regions wr
1821: where wrt.region_id = wr.region_id
1822: and wrt.language = USERENV('LANG'));
1823:
1824: -- Vijay 08/25: added call to put exception WSH_LOCATION_REGIONS_2_ERR

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