APPS.WSH_MAP_LOCATION_REGION_PKG dependencies on WSH_REGIONS_TL

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 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 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 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 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 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 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 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: