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.FTE_REGION_ZONE_LOADER dependencies on WSH_REGIONS

Line 25: TYPE REGION_ID_TAB IS TABLE OF WSH_REGIONS_INTERFACE.REGION_ID%TYPE INDEX BY BINARY_INTEGER;

21: G_USER_ID CONSTANT NUMBER := FND_GLOBAL.USER_ID;
22:
23: TYPE LANE_ID_TBL IS TABLE OF FTE_LANES.LANE_ID%TYPE INDEX BY BINARY_INTEGER;
24:
25: TYPE REGION_ID_TAB IS TABLE OF WSH_REGIONS_INTERFACE.REGION_ID%TYPE INDEX BY BINARY_INTEGER;
26: TYPE COUNTRY_CODE_TAB IS TABLE OF WSH_REGIONS_INTERFACE.COUNTRY_CODE%TYPE INDEX BY BINARY_INTEGER;
27: TYPE STATE_CODE_TAB IS TABLE OF WSH_REGIONS_INTERFACE.STATE_CODE%TYPE INDEX BY BINARY_INTEGER;
28: TYPE CITY_CODE_TAB IS TABLE OF WSH_REGIONS_INTERFACE.CITY_CODE%TYPE INDEX BY BINARY_INTEGER;
29:

Line 26: TYPE COUNTRY_CODE_TAB IS TABLE OF WSH_REGIONS_INTERFACE.COUNTRY_CODE%TYPE INDEX BY BINARY_INTEGER;

22:
23: TYPE LANE_ID_TBL IS TABLE OF FTE_LANES.LANE_ID%TYPE INDEX BY BINARY_INTEGER;
24:
25: TYPE REGION_ID_TAB IS TABLE OF WSH_REGIONS_INTERFACE.REGION_ID%TYPE INDEX BY BINARY_INTEGER;
26: TYPE COUNTRY_CODE_TAB IS TABLE OF WSH_REGIONS_INTERFACE.COUNTRY_CODE%TYPE INDEX BY BINARY_INTEGER;
27: TYPE STATE_CODE_TAB IS TABLE OF WSH_REGIONS_INTERFACE.STATE_CODE%TYPE INDEX BY BINARY_INTEGER;
28: TYPE CITY_CODE_TAB IS TABLE OF WSH_REGIONS_INTERFACE.CITY_CODE%TYPE INDEX BY BINARY_INTEGER;
29:
30: TYPE LANGUAGE_TAB IS TABLE OF WSH_REGIONS_TL_INTERFACE.LANGUAGE%TYPE INDEX BY BINARY_INTEGER;

Line 27: TYPE STATE_CODE_TAB IS TABLE OF WSH_REGIONS_INTERFACE.STATE_CODE%TYPE INDEX BY BINARY_INTEGER;

23: TYPE LANE_ID_TBL IS TABLE OF FTE_LANES.LANE_ID%TYPE INDEX BY BINARY_INTEGER;
24:
25: TYPE REGION_ID_TAB IS TABLE OF WSH_REGIONS_INTERFACE.REGION_ID%TYPE INDEX BY BINARY_INTEGER;
26: TYPE COUNTRY_CODE_TAB IS TABLE OF WSH_REGIONS_INTERFACE.COUNTRY_CODE%TYPE INDEX BY BINARY_INTEGER;
27: TYPE STATE_CODE_TAB IS TABLE OF WSH_REGIONS_INTERFACE.STATE_CODE%TYPE INDEX BY BINARY_INTEGER;
28: TYPE CITY_CODE_TAB IS TABLE OF WSH_REGIONS_INTERFACE.CITY_CODE%TYPE INDEX BY BINARY_INTEGER;
29:
30: TYPE LANGUAGE_TAB IS TABLE OF WSH_REGIONS_TL_INTERFACE.LANGUAGE%TYPE INDEX BY BINARY_INTEGER;
31: TYPE COUNTRY_TAB IS TABLE OF WSH_REGIONS_TL_INTERFACE.COUNTRY%TYPE INDEX BY BINARY_INTEGER;

Line 28: TYPE CITY_CODE_TAB IS TABLE OF WSH_REGIONS_INTERFACE.CITY_CODE%TYPE INDEX BY BINARY_INTEGER;

24:
25: TYPE REGION_ID_TAB IS TABLE OF WSH_REGIONS_INTERFACE.REGION_ID%TYPE INDEX BY BINARY_INTEGER;
26: TYPE COUNTRY_CODE_TAB IS TABLE OF WSH_REGIONS_INTERFACE.COUNTRY_CODE%TYPE INDEX BY BINARY_INTEGER;
27: TYPE STATE_CODE_TAB IS TABLE OF WSH_REGIONS_INTERFACE.STATE_CODE%TYPE INDEX BY BINARY_INTEGER;
28: TYPE CITY_CODE_TAB IS TABLE OF WSH_REGIONS_INTERFACE.CITY_CODE%TYPE INDEX BY BINARY_INTEGER;
29:
30: TYPE LANGUAGE_TAB IS TABLE OF WSH_REGIONS_TL_INTERFACE.LANGUAGE%TYPE INDEX BY BINARY_INTEGER;
31: TYPE COUNTRY_TAB IS TABLE OF WSH_REGIONS_TL_INTERFACE.COUNTRY%TYPE INDEX BY BINARY_INTEGER;
32: TYPE STATE_TAB IS TABLE OF WSH_REGIONS_TL_INTERFACE.STATE%TYPE INDEX BY BINARY_INTEGER;

Line 30: TYPE LANGUAGE_TAB IS TABLE OF WSH_REGIONS_TL_INTERFACE.LANGUAGE%TYPE INDEX BY BINARY_INTEGER;

26: TYPE COUNTRY_CODE_TAB IS TABLE OF WSH_REGIONS_INTERFACE.COUNTRY_CODE%TYPE INDEX BY BINARY_INTEGER;
27: TYPE STATE_CODE_TAB IS TABLE OF WSH_REGIONS_INTERFACE.STATE_CODE%TYPE INDEX BY BINARY_INTEGER;
28: TYPE CITY_CODE_TAB IS TABLE OF WSH_REGIONS_INTERFACE.CITY_CODE%TYPE INDEX BY BINARY_INTEGER;
29:
30: TYPE LANGUAGE_TAB IS TABLE OF WSH_REGIONS_TL_INTERFACE.LANGUAGE%TYPE INDEX BY BINARY_INTEGER;
31: TYPE COUNTRY_TAB IS TABLE OF WSH_REGIONS_TL_INTERFACE.COUNTRY%TYPE INDEX BY BINARY_INTEGER;
32: TYPE STATE_TAB IS TABLE OF WSH_REGIONS_TL_INTERFACE.STATE%TYPE INDEX BY BINARY_INTEGER;
33: TYPE CITY_TAB IS TABLE OF WSH_REGIONS_TL_INTERFACE.CITY%TYPE INDEX BY BINARY_INTEGER;
34: TYPE POSTAL_CODE_FROM_TAB IS TABLE OF WSH_REGIONS_TL_INTERFACE.POSTAL_CODE_FROM%TYPE INDEX BY BINARY_INTEGER;

Line 31: TYPE COUNTRY_TAB IS TABLE OF WSH_REGIONS_TL_INTERFACE.COUNTRY%TYPE INDEX BY BINARY_INTEGER;

27: TYPE STATE_CODE_TAB IS TABLE OF WSH_REGIONS_INTERFACE.STATE_CODE%TYPE INDEX BY BINARY_INTEGER;
28: TYPE CITY_CODE_TAB IS TABLE OF WSH_REGIONS_INTERFACE.CITY_CODE%TYPE INDEX BY BINARY_INTEGER;
29:
30: TYPE LANGUAGE_TAB IS TABLE OF WSH_REGIONS_TL_INTERFACE.LANGUAGE%TYPE INDEX BY BINARY_INTEGER;
31: TYPE COUNTRY_TAB IS TABLE OF WSH_REGIONS_TL_INTERFACE.COUNTRY%TYPE INDEX BY BINARY_INTEGER;
32: TYPE STATE_TAB IS TABLE OF WSH_REGIONS_TL_INTERFACE.STATE%TYPE INDEX BY BINARY_INTEGER;
33: TYPE CITY_TAB IS TABLE OF WSH_REGIONS_TL_INTERFACE.CITY%TYPE INDEX BY BINARY_INTEGER;
34: TYPE POSTAL_CODE_FROM_TAB IS TABLE OF WSH_REGIONS_TL_INTERFACE.POSTAL_CODE_FROM%TYPE INDEX BY BINARY_INTEGER;
35: TYPE POSTAL_CODE_TO_TAB IS TABLE OF WSH_REGIONS_TL_INTERFACE.POSTAL_CODE_TO%TYPE INDEX BY BINARY_INTEGER;

Line 32: TYPE STATE_TAB IS TABLE OF WSH_REGIONS_TL_INTERFACE.STATE%TYPE INDEX BY BINARY_INTEGER;

28: TYPE CITY_CODE_TAB IS TABLE OF WSH_REGIONS_INTERFACE.CITY_CODE%TYPE INDEX BY BINARY_INTEGER;
29:
30: TYPE LANGUAGE_TAB IS TABLE OF WSH_REGIONS_TL_INTERFACE.LANGUAGE%TYPE INDEX BY BINARY_INTEGER;
31: TYPE COUNTRY_TAB IS TABLE OF WSH_REGIONS_TL_INTERFACE.COUNTRY%TYPE INDEX BY BINARY_INTEGER;
32: TYPE STATE_TAB IS TABLE OF WSH_REGIONS_TL_INTERFACE.STATE%TYPE INDEX BY BINARY_INTEGER;
33: TYPE CITY_TAB IS TABLE OF WSH_REGIONS_TL_INTERFACE.CITY%TYPE INDEX BY BINARY_INTEGER;
34: TYPE POSTAL_CODE_FROM_TAB IS TABLE OF WSH_REGIONS_TL_INTERFACE.POSTAL_CODE_FROM%TYPE INDEX BY BINARY_INTEGER;
35: TYPE POSTAL_CODE_TO_TAB IS TABLE OF WSH_REGIONS_TL_INTERFACE.POSTAL_CODE_TO%TYPE INDEX BY BINARY_INTEGER;
36:

Line 33: TYPE CITY_TAB IS TABLE OF WSH_REGIONS_TL_INTERFACE.CITY%TYPE INDEX BY BINARY_INTEGER;

29:
30: TYPE LANGUAGE_TAB IS TABLE OF WSH_REGIONS_TL_INTERFACE.LANGUAGE%TYPE INDEX BY BINARY_INTEGER;
31: TYPE COUNTRY_TAB IS TABLE OF WSH_REGIONS_TL_INTERFACE.COUNTRY%TYPE INDEX BY BINARY_INTEGER;
32: TYPE STATE_TAB IS TABLE OF WSH_REGIONS_TL_INTERFACE.STATE%TYPE INDEX BY BINARY_INTEGER;
33: TYPE CITY_TAB IS TABLE OF WSH_REGIONS_TL_INTERFACE.CITY%TYPE INDEX BY BINARY_INTEGER;
34: TYPE POSTAL_CODE_FROM_TAB IS TABLE OF WSH_REGIONS_TL_INTERFACE.POSTAL_CODE_FROM%TYPE INDEX BY BINARY_INTEGER;
35: TYPE POSTAL_CODE_TO_TAB IS TABLE OF WSH_REGIONS_TL_INTERFACE.POSTAL_CODE_TO%TYPE INDEX BY BINARY_INTEGER;
36:
37:

Line 34: TYPE POSTAL_CODE_FROM_TAB IS TABLE OF WSH_REGIONS_TL_INTERFACE.POSTAL_CODE_FROM%TYPE INDEX BY BINARY_INTEGER;

30: TYPE LANGUAGE_TAB IS TABLE OF WSH_REGIONS_TL_INTERFACE.LANGUAGE%TYPE INDEX BY BINARY_INTEGER;
31: TYPE COUNTRY_TAB IS TABLE OF WSH_REGIONS_TL_INTERFACE.COUNTRY%TYPE INDEX BY BINARY_INTEGER;
32: TYPE STATE_TAB IS TABLE OF WSH_REGIONS_TL_INTERFACE.STATE%TYPE INDEX BY BINARY_INTEGER;
33: TYPE CITY_TAB IS TABLE OF WSH_REGIONS_TL_INTERFACE.CITY%TYPE INDEX BY BINARY_INTEGER;
34: TYPE POSTAL_CODE_FROM_TAB IS TABLE OF WSH_REGIONS_TL_INTERFACE.POSTAL_CODE_FROM%TYPE INDEX BY BINARY_INTEGER;
35: TYPE POSTAL_CODE_TO_TAB IS TABLE OF WSH_REGIONS_TL_INTERFACE.POSTAL_CODE_TO%TYPE INDEX BY BINARY_INTEGER;
36:
37:
38: --_______________________________________________________________________________________--

Line 35: TYPE POSTAL_CODE_TO_TAB IS TABLE OF WSH_REGIONS_TL_INTERFACE.POSTAL_CODE_TO%TYPE INDEX BY BINARY_INTEGER;

31: TYPE COUNTRY_TAB IS TABLE OF WSH_REGIONS_TL_INTERFACE.COUNTRY%TYPE INDEX BY BINARY_INTEGER;
32: TYPE STATE_TAB IS TABLE OF WSH_REGIONS_TL_INTERFACE.STATE%TYPE INDEX BY BINARY_INTEGER;
33: TYPE CITY_TAB IS TABLE OF WSH_REGIONS_TL_INTERFACE.CITY%TYPE INDEX BY BINARY_INTEGER;
34: TYPE POSTAL_CODE_FROM_TAB IS TABLE OF WSH_REGIONS_TL_INTERFACE.POSTAL_CODE_FROM%TYPE INDEX BY BINARY_INTEGER;
35: TYPE POSTAL_CODE_TO_TAB IS TABLE OF WSH_REGIONS_TL_INTERFACE.POSTAL_CODE_TO%TYPE INDEX BY BINARY_INTEGER;
36:
37:
38: --_______________________________________________________________________________________--
39: --

Line 50: SELECT WSH_REGIONS_S.NEXTVAL FROM DUAL;

46:
47: FUNCTION GET_NEXT_REGION_ID RETURN NUMBER IS
48:
49: CURSOR GET_REGION_ID IS
50: SELECT WSH_REGIONS_S.NEXTVAL FROM DUAL;
51: l_region_id NUMBER := -1;
52:
53: BEGIN
54:

Line 75: -- Get the region_id of a zone from the wsh_regions_tl table.

71: --
72: -- FUNCTION GET_ZONE_ID
73: --
74: -- Purpose
75: -- Get the region_id of a zone from the wsh_regions_tl table.
76: --
77: -- IN Parameters
78: -- 1. p_zone_name: The name of the zone.
79: -- 2. p_exact_match: A boolean which specifies whether the match on zone_name

Line 91: FROM wsh_regions_tl

87: FUNCTION GET_ZONE_ID(p_zone_name IN VARCHAR2 ) RETURN NUMBER IS
88:
89: CURSOR GET_ZONE_ID(p_zone_name VARCHAR2) IS
90: SELECT region_id
91: FROM wsh_regions_tl
92: WHERE zone = p_zone_name
93: --BUG 6067174 : Zone ID returned should be specific to the instance language.
94: and language = userenv('lang');
95:

Line 127: -- Purpose: Add a zone to wsh_regions table

123: --_______________________________________________________________________________________--
124: --
125: -- FUNCTION ADD_ZONE
126: --
127: -- Purpose: Add a zone to wsh_regions table
128: --
129: -- IN parameters:
130: -- 1. p_zone_name: name of the zone to be added
131: -- 2. p_validate_flag: validate flag

Line 171: INSERT INTO WSH_REGIONS(

167: IF (l_zone_id = -1) THEN
168: RETURN l_zone_id;
169: END IF;
170:
171: INSERT INTO WSH_REGIONS(
172: REGION_ID,
173: PARENT_REGION_ID,
174: REGION_TYPE,
175: LAST_UPDATE_DATE,

Line 188: INSERT INTO WSH_REGIONS_TL(

184: G_USER_ID,
185: SYSDATE,
186: G_USER_ID);
187:
188: INSERT INTO WSH_REGIONS_TL(
189: REGION_ID,
190: LANGUAGE,
191: ZONE,
192: LAST_UPDATE_DATE,

Line 221: -- Purpose: call wsh_regions_search_pkg and get region information

217: --_______________________________________________________________________________________--
218: --
219: -- FUNCTION GET_REGION_ID
220: --
221: -- Purpose: call wsh_regions_search_pkg and get region information
222: --
223: -- IN parameters:
224: -- 1. p_region_info: region information record
225: --

Line 231: FUNCTION GET_REGION_ID(p_region_info IN WSH_REGIONS_SEARCH_PKG.REGION_REC)

227: -- 1. x_status: status, -1 if no error
228: -- 2. x_error_msg: error message if error
229: --_______________________________________________________________________________________--
230:
231: FUNCTION GET_REGION_ID(p_region_info IN WSH_REGIONS_SEARCH_PKG.REGION_REC)
232:
233: RETURN NUMBER IS
234:
235: x_region_info WSH_REGIONS_SEARCH_PKG.REGION_REC;

Line 235: x_region_info WSH_REGIONS_SEARCH_PKG.REGION_REC;

231: FUNCTION GET_REGION_ID(p_region_info IN WSH_REGIONS_SEARCH_PKG.REGION_REC)
232:
233: RETURN NUMBER IS
234:
235: x_region_info WSH_REGIONS_SEARCH_PKG.REGION_REC;
236:
237: l_country_code VARCHAR2(3) := '';
238: l_country VARCHAR2(50);
239: l_state P_REGION_INFO.STATE%TYPE;

Line 255: -- WSH_REGIONS_SEARCH_PKG.Get_Region_Info expects a country

251: l_city := p_region_info.CITY;
252: l_state := p_region_info.STATE;
253:
254: --+
255: -- WSH_REGIONS_SEARCH_PKG.Get_Region_Info expects a country
256: -- name as its first argument, and not a country code
257: -- i.e. 'United States' instead of 'US'. If we THINK that the
258: -- 'country' argument supplied is a country code, we pass it as
259: -- the 'country code' argument.

Line 278: WSH_REGIONS_SEARCH_PKG.Get_Region_Info(

274: l_city_code := l_city;
275: l_city := NULL;
276: END IF;
277:
278: WSH_REGIONS_SEARCH_PKG.Get_Region_Info(
279: p_country => l_country,
280: p_country_region => '',
281: p_state => l_state,
282: p_city => l_city,

Line 310: -- Purpose: call wsh_regions_search_pkg and get region information

306: --_______________________________________________________________________________________--
307: --
308: -- FUNCTION GET_REGION_ID
309: --
310: -- Purpose: call wsh_regions_search_pkg and get region information
311: --
312: -- IN parameters:
313: -- 1. p_region_info: region information record
314: -- 2. p_recursively_flag: recursive search flag

Line 320: FUNCTION GET_REGION_ID(p_region_info IN WSH_REGIONS_SEARCH_PKG.REGION_REC,

316: -- RETURN
317: -- 1. region id
318: --_______________________________________________________________________________________--
319:
320: FUNCTION GET_REGION_ID(p_region_info IN WSH_REGIONS_SEARCH_PKG.REGION_REC,
321: p_recursively_flag IN VARCHAR2)
322:
323: RETURN NUMBER IS
324:

Line 345: -- WSH_REGIONS_SEARCH_PKG.Get_Region_Info expects a country

341: l_city := p_region_info.CITY;
342: l_state := p_region_info.STATE;
343:
344: --+
345: -- WSH_REGIONS_SEARCH_PKG.Get_Region_Info expects a country
346: -- name as its first argument, and not a country code
347: -- i.e. 'United States' instead of 'US'. If we THINK that the
348: -- 'country' argument supplied is a country code, we pass it as
349: -- the 'country code' argument.

Line 365: WSH_REGIONS_SEARCH_PKG.Get_Region_Info(

361: l_city_code := l_city;
362: l_city := NULL;
363: END IF;
364:
365: WSH_REGIONS_SEARCH_PKG.Get_Region_Info(
366: p_country => l_country,
367: p_country_region => '',
368: p_state => l_state,
369: p_city => l_city,

Line 552: l_region_rec WSH_REGIONS_SEARCH_PKG.region_rec;

548: l_zone_name VARCHAR2(200);
549: l_country VARCHAR2(100);
550: l_zone_id NUMBER;
551: l_region_id NUMBER;
552: l_region_rec WSH_REGIONS_SEARCH_PKG.region_rec;
553: l_temp_id NUMBER;
554:
555: l_values FTE_BULKLOAD_PKG.data_values_tbl;
556:

Line 612: WSH_REGIONS_PKG.UPDATE_ZONE_REGION(p_insert_type => 'INSERT',

608: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Unable to create new Zone');
609: RETURN;
610: END IF;
611:
612: WSH_REGIONS_PKG.UPDATE_ZONE_REGION(p_insert_type => 'INSERT',
613: p_zone_region_id => l_region_id,
614: p_zone_id => l_zone_id,
615: p_region_id => l_region_id,
616: p_country => l_region_rec.country,

Line 633: FTE_UTIL_PKG.Write_LogFile(l_module_name,'WSH_REGIONS_PKG.UPDATE_ZONE_REGION returned with error',x_error_msg);

629: x_status => x_status,
630: x_error_msg => x_error_msg);
631:
632: IF (x_status = 2) THEN
633: FTE_UTIL_PKG.Write_LogFile(l_module_name,'WSH_REGIONS_PKG.UPDATE_ZONE_REGION returned with error',x_error_msg);
634: FTE_UTIL_PKG.Exit_Debug(l_module_name);
635: RETURN;
636: END IF;
637:

Line 712: SELECT WSH_REGIONS_INTERFACE_S.NEXTVAL

708: L_POSTAL_CODE_FROM POSTAL_CODE_FROM_TAB;
709: L_POSTAL_CODE_TO POSTAL_CODE_TO_TAB;
710:
711: CURSOR GET_INTERFACE_REGION_ID IS
712: SELECT WSH_REGIONS_INTERFACE_S.NEXTVAL
713: FROM DUAL;
714:
715: l_module_name CONSTANT VARCHAR2(100) := 'FTE.PLSQL.' || G_PKG_NAME || '.PROCESS_REGION';
716:

Line 770: INSERT INTO WSH_REGIONS_INTERFACE(

766: END LOOP;
767:
768: FORALL i in L_REGION_ID.FIRST..L_REGION_ID.LAST
769:
770: INSERT INTO WSH_REGIONS_INTERFACE(
771: REGION_ID,
772: PARENT_REGION_ID,
773: COUNTRY_CODE,
774: STATE_CODE,

Line 797: INSERT INTO WSH_REGIONS_TL_INTERFACE(

793: NULL);
794:
795: FORALL i in L_REGION_ID.FIRST..L_REGION_ID.LAST
796:
797: INSERT INTO WSH_REGIONS_TL_INTERFACE(
798: LANGUAGE,
799: REGION_ID,
800: COUNTRY,
801: STATE,