APPS.WSH_REGIONS_PKG dependencies on WSH_REGIONS_TL_INTERFACE

Line 210: INSERT INTO WSH_REGIONS_TL_INTERFACE (

206: fnd_global.login_id);
207:
208: END IF;
209:
210: INSERT INTO WSH_REGIONS_TL_INTERFACE (
211: LANGUAGE,
212: REGION_ID,
213: CONTINENT,
214: COUNTRY,

Line 1742: UPDATE WSH_REGIONS_TL_INTERFACE

1738: LAST_UPDATE_DATE = sysdate,
1739: LAST_UPDATED_BY = p_user_id
1740: WHERE REGION_ID = l_region_id;
1741:
1742: UPDATE WSH_REGIONS_TL_INTERFACE
1743: SET CONTINENT = p_continent,
1744: COUNTRY = p_country,
1745: COUNTRY_REGION = p_country_region,
1746: STATE = p_state,

Line 1758: INSERT INTO WSH_REGIONS_TL_INTERFACE (

1754: WHERE REGION_ID = l_region_id
1755: AND LANGUAGE = p_lang_code;
1756:
1757: IF (SQL%NOTFOUND) THEN
1758: INSERT INTO WSH_REGIONS_TL_INTERFACE (
1759: LANGUAGE,
1760: REGION_ID,
1761: CONTINENT,
1762: COUNTRY,

Line 2051: FROM wsh_regions_interface r, wsh_regions_tl_interface t

2047: x_error_msg OUT NOCOPY VARCHAR2) IS
2048:
2049: CURSOR lock_rows IS
2050: SELECT r.region_id
2051: FROM wsh_regions_interface r, wsh_regions_tl_interface t
2052: WHERE r.region_id = t.region_id AND
2053: r.region_id = p_region_id AND
2054: t.language = nvl(p_lang_code, t.language)
2055: FOR UPDATE OF r.region_id NOWAIT;

Line 2091: DELETE FROM wsh_regions_tl_interface WHERE region_id = l_region_id AND language= nvl(p_lang_code, language);

2087: OPEN lock_rows;
2088: FETCH lock_rows INTO l_region_id;
2089: CLOSE lock_rows;
2090:
2091: DELETE FROM wsh_regions_tl_interface WHERE region_id = l_region_id AND language= nvl(p_lang_code, language);
2092: DELETE FROM wsh_regions_interface WHERE region_id = l_region_id;
2093:
2094: ELSE
2095: x_status := 2;

Line 2389: FROM wsh_regions_tl_interface t

2385: FOR UPDATE OF w.region_id NOWAIT;
2386:
2387: CURSOR lock_row_tl IS
2388: SELECT t.region_id, t.country, t.state, t.city, t.postal_code_from, t.postal_code_to
2389: FROM wsh_regions_tl_interface t
2390: WHERE t.language = p_lang_code
2391: AND t.region_id = p_region_id
2392: FOR UPDATE OF t.region_id NOWAIT;
2393:

Line 3700: WSH_REGIONS_TL_INTERFACE TL

3696: TL.POSTAL_CODE_FROM,
3697: TL.POSTAL_CODE_TO,
3698: TL.LANGUAGE
3699: FROM WSH_REGIONS_INTERFACE R,
3700: WSH_REGIONS_TL_INTERFACE TL
3701: WHERE R.REGION_ID = TL.REGION_ID
3702: AND TL.ZONE IS NULL -- We are not processing zones here .
3703: AND PROCESSED_FLAG is null
3704: AND nvl(TL.STATE,'NULL') = decode(x_state,NULL,nvl(TL.STATE,'NULL'),x_state)

Line 4019: DELETE FROM WSH_REGIONS_TL_INTERFACE WHERE REGION_ID = l_del_region_id(i);

4015: FORALL i in l_del_region_id.first..l_del_region_id.last
4016: DELETE FROM WSH_REGIONS_INTERFACE WHERE REGION_ID = l_del_region_id(i);
4017:
4018: FORALL i in l_del_region_id.first..l_del_region_id.last
4019: DELETE FROM WSH_REGIONS_TL_INTERFACE WHERE REGION_ID = l_del_region_id(i);
4020:
4021: -- Deleting region ids from array
4022: l_del_region_id.DELETE;
4023: END IF;