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_REGIONS_PKG dependencies on WSH_REGIONS_TL

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 334: INSERT INTO WSH_REGIONS_TL (

330: IF l_debug_on THEN
331: WSH_DEBUG_SV.logmsg(l_module_name, 'inserting region '||l_region_id);
332: END IF;
333:
334: INSERT INTO WSH_REGIONS_TL (
335: LANGUAGE,
336: REGION_ID,
337: CONTINENT,
338: 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 1869: update WSH_REGIONS_TL set

1865: -- deconsol_location_id = p_deconsol_location_id
1866: deconsol_location_id = decode(reg.region_id, l_region_id, p_deconsol_location_id, deconsol_location_id)
1867: where REGION_ID = reg.region_id;
1868:
1869: update WSH_REGIONS_TL set
1870: CONTINENT = nvl(p_continent, CONTINENT),
1871: COUNTRY = nvl(p_country, COUNTRY),
1872: COUNTRY_REGION = nvl(p_country_region, COUNTRY_REGION),
1873: STATE = nvl(p_state, STATE),

Line 1888: INSERT INTO WSH_REGIONS_TL (

1884: END LOOP;
1885:
1886: IF (SQL%NOTFOUND) THEN
1887: IF (p_insert_type = 'SYNC') THEN
1888: INSERT INTO WSH_REGIONS_TL (
1889: LANGUAGE,
1890: REGION_ID,
1891: CONTINENT,
1892: 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 2147: FROM wsh_regions_tl t

2143: FOR UPDATE OF w.region_id NOWAIT;
2144:
2145: CURSOR lock_row_tl IS
2146: SELECT t.region_id, t.country, t.state, t.city, t.postal_code_from, t.postal_code_to
2147: FROM wsh_regions_tl t
2148: WHERE t.language = p_lang_code
2149: AND t.region_id = p_region_id
2150: FOR UPDATE OF t.region_id NOWAIT;
2151:

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 2646: FROM wsh_regions_tl

2642: p_deconsol_location_id IN NUMBER DEFAULT NULL) IS
2643:
2644: CURSOR check_zone IS
2645: SELECT region_id
2646: FROM wsh_regions_tl
2647: WHERE zone = p_zone_name AND
2648: language = p_lang_code;
2649:
2650: l_zone_id NUMBER;

Line 2776: INSERT INTO WSH_REGIONS_TL (

2772: p_deconsol_location_id)
2773: RETURNING region_id
2774: INTO l_zone_id;
2775:
2776: INSERT INTO WSH_REGIONS_TL (
2777: LANGUAGE,
2778: REGION_ID,
2779: ZONE,
2780: CREATED_BY,

Line 2832: UPDATE wsh_regions_tl

2828: last_update_date = sysdate,
2829: deconsol_location_id = p_deconsol_location_id
2830: WHERE region_id = p_zone_id;
2831:
2832: UPDATE wsh_regions_tl
2833: SET zone = p_zone_name,
2834: --language = p_lang_code,--bug 8513956 moved language in where clause
2835: last_updated_by = p_user_id,
2836: last_update_date = sysdate

Line 2872: FROM wsh_regions w, wsh_regions_tl t

2868: x_status OUT NOCOPY NUMBER) IS
2869:
2870: CURSOR lock_row IS
2871: SELECT w.region_id, t.zone, w.zone_level
2872: FROM wsh_regions w, wsh_regions_tl t
2873: WHERE w.region_id = t.region_id
2874: AND t.language = p_lang_code
2875: FOR UPDATE OF w.region_id, t.region_id NOWAIT;
2876:

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 3744: l_prev_country WSH_REGIONS_TL.Country%TYPE;

3740: l_postal_code_from_rec tab_postal_code_from;
3741: l_postal_code_to_rec tab_postal_code_to;
3742: l_language_rec tab_language;
3743:
3744: l_prev_country WSH_REGIONS_TL.Country%TYPE;
3745: l_prev_state WSH_REGIONS_TL.State%TYPE;
3746: l_prev_city WSH_REGIONS_TL.City%TYPE;
3747: l_prev_country_code WSH_REGIONS.Country_Code%Type;
3748: l_prev_state_code WSH_REGIONS.State_Code%Type;

Line 3745: l_prev_state WSH_REGIONS_TL.State%TYPE;

3741: l_postal_code_to_rec tab_postal_code_to;
3742: l_language_rec tab_language;
3743:
3744: l_prev_country WSH_REGIONS_TL.Country%TYPE;
3745: l_prev_state WSH_REGIONS_TL.State%TYPE;
3746: l_prev_city WSH_REGIONS_TL.City%TYPE;
3747: l_prev_country_code WSH_REGIONS.Country_Code%Type;
3748: l_prev_state_code WSH_REGIONS.State_Code%Type;
3749: l_prev_city_code WSH_REGIONS.City_Code%Type;

Line 3746: l_prev_city WSH_REGIONS_TL.City%TYPE;

3742: l_language_rec tab_language;
3743:
3744: l_prev_country WSH_REGIONS_TL.Country%TYPE;
3745: l_prev_state WSH_REGIONS_TL.State%TYPE;
3746: l_prev_city WSH_REGIONS_TL.City%TYPE;
3747: l_prev_country_code WSH_REGIONS.Country_Code%Type;
3748: l_prev_state_code WSH_REGIONS.State_Code%Type;
3749: l_prev_city_code WSH_REGIONS.City_Code%Type;
3750:

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;

Line 4208: FROM WSH_REGIONS_TL T, WSH_ZONE_REGIONS P

4204: IS
4205: SELECT T.REGION_ID REGION_ID, T.COUNTRY COUNTRY, T.STATE STATE, T.CITY CITY,
4206: ltrim(P.POSTAL_CODE_FROM,'0') PCODE_FROM,
4207: ltrim(P.POSTAL_CODE_TO,'0') PCODE_TO
4208: FROM WSH_REGIONS_TL T, WSH_ZONE_REGIONS P
4209: WHERE T.LANGUAGE = p_lang
4210: AND T.REGION_ID = P.REGION_ID
4211: AND P.PARENT_REGION_ID = p_zoneId;
4212:

Line 4375: delete from WSH_REGIONS_TL T

4371: /*----------------------------------------------------------*/
4372: procedure ADD_LANGUAGE
4373: is
4374: begin
4375: delete from WSH_REGIONS_TL T
4376: where not exists
4377: (select NULL
4378: from WSH_REGIONS B
4379: where B.REGION_ID = T.REGION_ID

Line 4382: update WSH_REGIONS_TL T set (

4378: from WSH_REGIONS B
4379: where B.REGION_ID = T.REGION_ID
4380: );
4381:
4382: update WSH_REGIONS_TL T set (
4383: CONTINENT,
4384: COUNTRY,
4385: COUNTRY_REGION,
4386: STATE,

Line 4404: from WSH_REGIONS_TL B

4400: B.POSTAL_CODE_FROM,
4401: B.POSTAL_CODE_TO,
4402: B.ALTERNATE_NAME,
4403: B.COUNTY
4404: from WSH_REGIONS_TL B
4405: where B.REGION_ID = T.REGION_ID
4406: and B.LANGUAGE = T.SOURCE_LANG)
4407: where (
4408: T.REGION_ID,

Line 4413: from WSH_REGIONS_TL SUBB, WSH_REGIONS_TL SUBT

4409: T.LANGUAGE
4410: ) in (select
4411: SUBT.REGION_ID,
4412: SUBT.LANGUAGE
4413: from WSH_REGIONS_TL SUBB, WSH_REGIONS_TL SUBT
4414: where SUBB.REGION_ID = SUBT.REGION_ID
4415: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
4416: and (SUBB.CONTINENT <> SUBT.CONTINENT
4417: or (SUBB.CONTINENT is null and SUBT.CONTINENT is not null)

Line 4448: insert into WSH_REGIONS_TL (

4444: or (SUBB.COUNTY is null and SUBT.COUNTY is not null)
4445: or (SUBB.COUNTY is not null and SUBT.COUNTY is null)
4446: ));
4447:
4448: insert into WSH_REGIONS_TL (
4449: REGION_ID,
4450: CONTINENT,
4451: COUNTRY,
4452: COUNTRY_REGION,

Line 4486: from WSH_REGIONS_TL B, FND_LANGUAGES L

4482: B.CREATED_BY,
4483: B.LAST_UPDATE_LOGIN,
4484: L.LANGUAGE_CODE,
4485: B.SOURCE_LANG
4486: from WSH_REGIONS_TL B, FND_LANGUAGES L
4487: where L.INSTALLED_FLAG in ('I', 'B')
4488: and B.LANGUAGE = userenv('LANG')
4489: and not exists
4490: (select NULL

Line 4491: from WSH_REGIONS_TL T

4487: where L.INSTALLED_FLAG in ('I', 'B')
4488: and B.LANGUAGE = userenv('LANG')
4489: and not exists
4490: (select NULL
4491: from WSH_REGIONS_TL T
4492: where T.REGION_ID = B.REGION_ID
4493: and T.LANGUAGE = L.LANGUAGE_CODE);
4494: end ADD_LANGUAGE;
4495:

Line 4651: -- Wsh_Regions_Tl based on parameter p_populate_type.

4647: -- PROCEDURE : Init_Global_Table
4648: --
4649: -- PURPOSE : Populates the data in Global Temp tables(Wsh_Regions_Global
4650: -- and Wsh_Regions_Global_Data) fetched from Wsh_Regions and
4651: -- Wsh_Regions_Tl based on parameter p_populate_type.
4652: --
4653:
4654: PROCEDURE Init_Global_Table (
4655: p_country IN VARCHAR2,

Line 4669: FROM WSH_REGIONS_TL

4665: AS
4666:
4667: CURSOR city_cur IS
4668: SELECT DISTINCT UPPER(STATE)
4669: FROM WSH_REGIONS_TL
4670: WHERE UPPER(CITY) = UPPER(p_city)
4671: AND UPPER(COUNTRY) = UPPER(p_country);
4672: -- AND LANGUAGE = p_lang_code;
4673:

Line 4762: WSH_REGIONS_TL TL

4758: TL.POSTAL_CODE_FROM,
4759: TL.POSTAL_CODE_TO,
4760: TL.LANGUAGE
4761: FROM WSH_REGIONS R,
4762: WSH_REGIONS_TL TL
4763: WHERE R.REGION_ID = TL.REGION_ID
4764: AND R.REGION_TYPE = 0
4765: AND ( UPPER(R.COUNTRY_CODE) = UPPER(p_country_code)
4766: OR UPPER(TL.COUNTRY) = UPPER(p_country) );

Line 4885: WSH_REGIONS_TL TL

4881: TL.POSTAL_CODE_FROM,
4882: TL.POSTAL_CODE_TO,
4883: TL.LANGUAGE
4884: FROM WSH_REGIONS R,
4885: WSH_REGIONS_TL TL
4886: WHERE R.REGION_ID = TL.REGION_ID
4887: AND R.REGION_TYPE = 1
4888: AND (
4889: ( ( UPPER(R.STATE_CODE) = UPPER(p_state_code)

Line 4985: WSH_REGIONS_TL TL

4981: TL.POSTAL_CODE_FROM,
4982: TL.POSTAL_CODE_TO,
4983: TL.LANGUAGE
4984: FROM WSH_REGIONS R,
4985: WSH_REGIONS_TL TL
4986: WHERE R.REGION_ID = TL.REGION_ID
4987: /* AND (
4988: ( ( UPPER(R.CITY_CODE) = UPPER(p_city_code) OR p_city_code is NULL )
4989: AND ( decode(p_city_code, null, UPPER(R.STATE_CODE), NVL(UPPER(R.STATE_CODE), UPPER(p_state_code) )) = UPPER(p_state_code)

Line 5431: WSH_REGIONS_TL TL

5427: TL.POSTAL_CODE_FROM,
5428: TL.POSTAL_CODE_TO,
5429: TL.LANGUAGE
5430: FROM WSH_REGIONS R,
5431: WSH_REGIONS_TL TL
5432: WHERE TL.LANGUAGE = p_lang_code
5433: AND TL.REGION_ID = R.REGION_ID
5434: AND R.REGION_ID = i.region_id;
5435: