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

1388: WHERE location_id = p_location_id
1389: AND ( ( region_id IN
1390: (
1391: SELECT wrt.region_id
1392: FROM wsh_regions_tl wrt, wsh_regions wr
1393: WHERE wrt.region_id = wr.region_id
1394: AND wrt.language = USERENV('LANG'))
1395: )
1396: OR region_id IS NULL);

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

1507: from wsh_region_locations
1508: where location_id = p_location_id
1509: and ( ( region_id in
1510: ( select wrt.region_id
1511: from wsh_regions_tl wrt,
1512: wsh_regions wr
1513: where wrt.region_id = wr.region_id
1514: and wrt.language = USERENV('LANG') )
1515: ) OR region_id IS NULL )

Line 1512: wsh_regions wr

1508: where location_id = p_location_id
1509: and ( ( region_id in
1510: ( select wrt.region_id
1511: from wsh_regions_tl wrt,
1512: wsh_regions wr
1513: where wrt.region_id = wr.region_id
1514: and wrt.language = USERENV('LANG') )
1515: ) OR region_id IS NULL )
1516: order by region_type desc;

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

1589:
1590: IF p_insert_flag THEN
1591: IF ( l_region_detail_tab.COUNT > 1 ) THEN
1592: DELETE from wsh_region_locations where location_id = p_location_id
1593: and ( ( region_id in (select wrt.region_id from wsh_regions_tl wrt,
1594: wsh_regions wr
1595: where wrt.region_id = wr.region_id
1596: and wrt.language = USERENV('LANG'))
1597: ) OR region_id IS NULL);

Line 1594: wsh_regions wr

1590: IF p_insert_flag THEN
1591: IF ( l_region_detail_tab.COUNT > 1 ) THEN
1592: DELETE from wsh_region_locations where location_id = p_location_id
1593: and ( ( region_id in (select wrt.region_id from wsh_regions_tl wrt,
1594: wsh_regions wr
1595: where wrt.region_id = wr.region_id
1596: and wrt.language = USERENV('LANG'))
1597: ) OR region_id IS NULL);
1598: END IF;

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

1651: l_region_detail_tab(1).region_id is null AND
1652: l_region_detail_tab(1).region_type is null )
1653: THEN
1654: DELETE from wsh_region_locations where location_id = p_location_id
1655: and ( ( region_id in (select wrt.region_id from wsh_regions_tl wrt,
1656: wsh_regions wr
1657: where wrt.region_id = wr.region_id
1658: and wrt.language = USERENV('LANG'))
1659: ) OR region_id IS NULL);

Line 1656: wsh_regions wr

1652: l_region_detail_tab(1).region_type is null )
1653: THEN
1654: DELETE from wsh_region_locations where location_id = p_location_id
1655: and ( ( region_id in (select wrt.region_id from wsh_regions_tl wrt,
1656: wsh_regions wr
1657: where wrt.region_id = wr.region_id
1658: and wrt.language = USERENV('LANG'))
1659: ) OR region_id IS NULL);
1660: --

Line 1733: from wsh_regions_tl wrt,

1729: WHERE location_id = p_location_id
1730: AND region_type = l_region_detail_tab(l_region_counter).region_type
1731: AND region_id in
1732: ( select wrt.region_id
1733: from wsh_regions_tl wrt,
1734: wsh_regions wr
1735: where wr.region_id = wrt.region_id
1736: and wrt.language = USERENV('LANG') );
1737:

Line 1734: wsh_regions wr

1730: AND region_type = l_region_detail_tab(l_region_counter).region_type
1731: AND region_id in
1732: ( select wrt.region_id
1733: from wsh_regions_tl wrt,
1734: wsh_regions wr
1735: where wr.region_id = wrt.region_id
1736: and wrt.language = USERENV('LANG') );
1737:
1738: IF l_debug_on THEN

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

1831: last_update_date = sysdate,
1832: last_updated_by = FND_GLOBAL.user_id,
1833: last_update_login = FND_GLOBAL.login_id
1834: WHERE location_id = p_location_id
1835: and region_id in (select wrt.region_id from wsh_regions_tl wrt,
1836: wsh_regions wr
1837: where wrt.region_id = wr.region_id
1838: and wrt.language = USERENV('LANG'));
1839:

Line 1836: wsh_regions wr

1832: last_updated_by = FND_GLOBAL.user_id,
1833: last_update_login = FND_GLOBAL.login_id
1834: WHERE location_id = p_location_id
1835: and region_id in (select wrt.region_id from wsh_regions_tl wrt,
1836: wsh_regions wr
1837: where wrt.region_id = wr.region_id
1838: and wrt.language = USERENV('LANG'));
1839:
1840: -- Vijay 08/25: added call to put exception WSH_LOCATION_REGIONS_2_ERR

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