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