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,
2835: last_updated_by = p_user_id,
2836: last_update_date = sysdate

Line 2871: FROM wsh_regions w, wsh_regions_tl t

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

Line 3695: WSH_REGIONS_TL_INTERFACE TL

3691: TL.POSTAL_CODE_FROM,
3692: TL.POSTAL_CODE_TO,
3693: TL.LANGUAGE
3694: FROM WSH_REGIONS_INTERFACE R,
3695: WSH_REGIONS_TL_INTERFACE TL
3696: WHERE R.REGION_ID = TL.REGION_ID
3697: AND TL.ZONE IS NULL -- We are not processing zones here .
3698: AND PROCESSED_FLAG is null
3699: ORDER BY TL.COUNTRY, R.COUNTRY_CODE,

Line 3735: l_prev_country WSH_REGIONS_TL.Country%TYPE;

3731: l_postal_code_from_rec tab_postal_code_from;
3732: l_postal_code_to_rec tab_postal_code_to;
3733: l_language_rec tab_language;
3734:
3735: l_prev_country WSH_REGIONS_TL.Country%TYPE;
3736: l_prev_state WSH_REGIONS_TL.State%TYPE;
3737: l_prev_city WSH_REGIONS_TL.City%TYPE;
3738: l_prev_country_code WSH_REGIONS.Country_Code%Type;
3739: l_prev_state_code WSH_REGIONS.State_Code%Type;

Line 3736: l_prev_state WSH_REGIONS_TL.State%TYPE;

3732: l_postal_code_to_rec tab_postal_code_to;
3733: l_language_rec tab_language;
3734:
3735: l_prev_country WSH_REGIONS_TL.Country%TYPE;
3736: l_prev_state WSH_REGIONS_TL.State%TYPE;
3737: l_prev_city WSH_REGIONS_TL.City%TYPE;
3738: l_prev_country_code WSH_REGIONS.Country_Code%Type;
3739: l_prev_state_code WSH_REGIONS.State_Code%Type;
3740: l_prev_city_code WSH_REGIONS.City_Code%Type;

Line 3737: l_prev_city WSH_REGIONS_TL.City%TYPE;

3733: l_language_rec tab_language;
3734:
3735: l_prev_country WSH_REGIONS_TL.Country%TYPE;
3736: l_prev_state WSH_REGIONS_TL.State%TYPE;
3737: l_prev_city WSH_REGIONS_TL.City%TYPE;
3738: l_prev_country_code WSH_REGIONS.Country_Code%Type;
3739: l_prev_state_code WSH_REGIONS.State_Code%Type;
3740: l_prev_city_code WSH_REGIONS.City_Code%Type;
3741:

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

4006: FORALL i in l_del_region_id.first..l_del_region_id.last
4007: DELETE FROM WSH_REGIONS_INTERFACE WHERE REGION_ID = l_del_region_id(i);
4008:
4009: FORALL i in l_del_region_id.first..l_del_region_id.last
4010: DELETE FROM WSH_REGIONS_TL_INTERFACE WHERE REGION_ID = l_del_region_id(i);
4011:
4012: -- Deleting region ids from array
4013: l_del_region_id.DELETE;
4014: END IF;

Line 4181: FROM WSH_REGIONS_TL T, WSH_ZONE_REGIONS P

4177: IS
4178: SELECT T.REGION_ID REGION_ID, T.COUNTRY COUNTRY, T.STATE STATE, T.CITY CITY,
4179: ltrim(P.POSTAL_CODE_FROM,'0') PCODE_FROM,
4180: ltrim(P.POSTAL_CODE_TO,'0') PCODE_TO
4181: FROM WSH_REGIONS_TL T, WSH_ZONE_REGIONS P
4182: WHERE T.LANGUAGE = p_lang
4183: AND T.REGION_ID = P.REGION_ID
4184: AND P.PARENT_REGION_ID = p_zoneId;
4185:

Line 4348: delete from WSH_REGIONS_TL T

4344: /*----------------------------------------------------------*/
4345: procedure ADD_LANGUAGE
4346: is
4347: begin
4348: delete from WSH_REGIONS_TL T
4349: where not exists
4350: (select NULL
4351: from WSH_REGIONS B
4352: where B.REGION_ID = T.REGION_ID

Line 4355: update WSH_REGIONS_TL T set (

4351: from WSH_REGIONS B
4352: where B.REGION_ID = T.REGION_ID
4353: );
4354:
4355: update WSH_REGIONS_TL T set (
4356: CONTINENT,
4357: COUNTRY,
4358: COUNTRY_REGION,
4359: STATE,

Line 4377: from WSH_REGIONS_TL B

4373: B.POSTAL_CODE_FROM,
4374: B.POSTAL_CODE_TO,
4375: B.ALTERNATE_NAME,
4376: B.COUNTY
4377: from WSH_REGIONS_TL B
4378: where B.REGION_ID = T.REGION_ID
4379: and B.LANGUAGE = T.SOURCE_LANG)
4380: where (
4381: T.REGION_ID,

Line 4386: from WSH_REGIONS_TL SUBB, WSH_REGIONS_TL SUBT

4382: T.LANGUAGE
4383: ) in (select
4384: SUBT.REGION_ID,
4385: SUBT.LANGUAGE
4386: from WSH_REGIONS_TL SUBB, WSH_REGIONS_TL SUBT
4387: where SUBB.REGION_ID = SUBT.REGION_ID
4388: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
4389: and (SUBB.CONTINENT <> SUBT.CONTINENT
4390: or (SUBB.CONTINENT is null and SUBT.CONTINENT is not null)

Line 4421: insert into WSH_REGIONS_TL (

4417: or (SUBB.COUNTY is null and SUBT.COUNTY is not null)
4418: or (SUBB.COUNTY is not null and SUBT.COUNTY is null)
4419: ));
4420:
4421: insert into WSH_REGIONS_TL (
4422: REGION_ID,
4423: CONTINENT,
4424: COUNTRY,
4425: COUNTRY_REGION,

Line 4459: from WSH_REGIONS_TL B, FND_LANGUAGES L

4455: B.CREATED_BY,
4456: B.LAST_UPDATE_LOGIN,
4457: L.LANGUAGE_CODE,
4458: B.SOURCE_LANG
4459: from WSH_REGIONS_TL B, FND_LANGUAGES L
4460: where L.INSTALLED_FLAG in ('I', 'B')
4461: and B.LANGUAGE = userenv('LANG')
4462: and not exists
4463: (select NULL

Line 4464: from WSH_REGIONS_TL T

4460: where L.INSTALLED_FLAG in ('I', 'B')
4461: and B.LANGUAGE = userenv('LANG')
4462: and not exists
4463: (select NULL
4464: from WSH_REGIONS_TL T
4465: where T.REGION_ID = B.REGION_ID
4466: and T.LANGUAGE = L.LANGUAGE_CODE);
4467: end ADD_LANGUAGE;
4468:

Line 4624: -- Wsh_Regions_Tl based on parameter p_populate_type.

4620: -- PROCEDURE : Init_Global_Table
4621: --
4622: -- PURPOSE : Populates the data in Global Temp tables(Wsh_Regions_Global
4623: -- and Wsh_Regions_Global_Data) fetched from Wsh_Regions and
4624: -- Wsh_Regions_Tl based on parameter p_populate_type.
4625: --
4626:
4627: PROCEDURE Init_Global_Table (
4628: p_country IN VARCHAR2,

Line 4642: FROM WSH_REGIONS_TL

4638: AS
4639:
4640: CURSOR city_cur IS
4641: SELECT DISTINCT UPPER(STATE)
4642: FROM WSH_REGIONS_TL
4643: WHERE UPPER(CITY) = UPPER(p_city)
4644: AND UPPER(COUNTRY) = UPPER(p_country);
4645: -- AND LANGUAGE = p_lang_code;
4646:

Line 4735: WSH_REGIONS_TL TL

4731: TL.POSTAL_CODE_FROM,
4732: TL.POSTAL_CODE_TO,
4733: TL.LANGUAGE
4734: FROM WSH_REGIONS R,
4735: WSH_REGIONS_TL TL
4736: WHERE R.REGION_ID = TL.REGION_ID
4737: AND R.REGION_TYPE = 0
4738: AND ( UPPER(R.COUNTRY_CODE) = UPPER(p_country_code)
4739: OR UPPER(TL.COUNTRY) = UPPER(p_country) );

Line 4858: WSH_REGIONS_TL TL

4854: TL.POSTAL_CODE_FROM,
4855: TL.POSTAL_CODE_TO,
4856: TL.LANGUAGE
4857: FROM WSH_REGIONS R,
4858: WSH_REGIONS_TL TL
4859: WHERE R.REGION_ID = TL.REGION_ID
4860: AND R.REGION_TYPE = 1
4861: AND (
4862: ( ( UPPER(R.STATE_CODE) = UPPER(p_state_code)

Line 4958: WSH_REGIONS_TL TL

4954: TL.POSTAL_CODE_FROM,
4955: TL.POSTAL_CODE_TO,
4956: TL.LANGUAGE
4957: FROM WSH_REGIONS R,
4958: WSH_REGIONS_TL TL
4959: WHERE R.REGION_ID = TL.REGION_ID
4960: AND (
4961: ( ( UPPER(R.CITY_CODE) = UPPER(p_city_code) OR p_city_code is NULL )
4962: AND ( decode(p_city_code, null, UPPER(R.STATE_CODE), NVL(UPPER(R.STATE_CODE), UPPER(p_state_code) )) = UPPER(p_state_code)

Line 5368: WSH_REGIONS_TL TL

5364: TL.POSTAL_CODE_FROM,
5365: TL.POSTAL_CODE_TO,
5366: TL.LANGUAGE
5367: FROM WSH_REGIONS R,
5368: WSH_REGIONS_TL TL
5369: WHERE TL.LANGUAGE = p_lang_code
5370: AND TL.REGION_ID = R.REGION_ID
5371: AND R.REGION_ID = i.region_id;
5372: