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_MAP_LOCATION_REGION_PKG dependencies on WSH_LOCATIONS

Line 7: WSH_LOCATION_ID WSH_LOCATIONS.WSH_LOCATION_ID%TYPE,

3:
4: g_loc_commit VARCHAR2(1) := 'Y';
5:
6: TYPE loc_rec_type IS RECORD(
7: WSH_LOCATION_ID WSH_LOCATIONS.WSH_LOCATION_ID%TYPE,
8: SOURCE_LOCATION_ID WSH_LOCATIONS.SOURCE_LOCATION_ID%TYPE,
9: LOCATION_SOURCE_CODE WSH_LOCATIONS.LOCATION_SOURCE_CODE%TYPE,
10: LOCATION_CODE WSH_LOCATIONS.LOCATION_CODE%TYPE,
11: UI_LOCATION_CODE WSH_LOCATIONS.UI_LOCATION_CODE%TYPE,

Line 8: SOURCE_LOCATION_ID WSH_LOCATIONS.SOURCE_LOCATION_ID%TYPE,

4: g_loc_commit VARCHAR2(1) := 'Y';
5:
6: TYPE loc_rec_type IS RECORD(
7: WSH_LOCATION_ID WSH_LOCATIONS.WSH_LOCATION_ID%TYPE,
8: SOURCE_LOCATION_ID WSH_LOCATIONS.SOURCE_LOCATION_ID%TYPE,
9: LOCATION_SOURCE_CODE WSH_LOCATIONS.LOCATION_SOURCE_CODE%TYPE,
10: LOCATION_CODE WSH_LOCATIONS.LOCATION_CODE%TYPE,
11: UI_LOCATION_CODE WSH_LOCATIONS.UI_LOCATION_CODE%TYPE,
12: ADDRESS1 WSH_LOCATIONS.ADDRESS1%TYPE,

Line 9: LOCATION_SOURCE_CODE WSH_LOCATIONS.LOCATION_SOURCE_CODE%TYPE,

5:
6: TYPE loc_rec_type IS RECORD(
7: WSH_LOCATION_ID WSH_LOCATIONS.WSH_LOCATION_ID%TYPE,
8: SOURCE_LOCATION_ID WSH_LOCATIONS.SOURCE_LOCATION_ID%TYPE,
9: LOCATION_SOURCE_CODE WSH_LOCATIONS.LOCATION_SOURCE_CODE%TYPE,
10: LOCATION_CODE WSH_LOCATIONS.LOCATION_CODE%TYPE,
11: UI_LOCATION_CODE WSH_LOCATIONS.UI_LOCATION_CODE%TYPE,
12: ADDRESS1 WSH_LOCATIONS.ADDRESS1%TYPE,
13: ADDRESS2 WSH_LOCATIONS.ADDRESS2%TYPE,

Line 10: LOCATION_CODE WSH_LOCATIONS.LOCATION_CODE%TYPE,

6: TYPE loc_rec_type IS RECORD(
7: WSH_LOCATION_ID WSH_LOCATIONS.WSH_LOCATION_ID%TYPE,
8: SOURCE_LOCATION_ID WSH_LOCATIONS.SOURCE_LOCATION_ID%TYPE,
9: LOCATION_SOURCE_CODE WSH_LOCATIONS.LOCATION_SOURCE_CODE%TYPE,
10: LOCATION_CODE WSH_LOCATIONS.LOCATION_CODE%TYPE,
11: UI_LOCATION_CODE WSH_LOCATIONS.UI_LOCATION_CODE%TYPE,
12: ADDRESS1 WSH_LOCATIONS.ADDRESS1%TYPE,
13: ADDRESS2 WSH_LOCATIONS.ADDRESS2%TYPE,
14: ADDRESS3 WSH_LOCATIONS.ADDRESS3%TYPE,

Line 11: UI_LOCATION_CODE WSH_LOCATIONS.UI_LOCATION_CODE%TYPE,

7: WSH_LOCATION_ID WSH_LOCATIONS.WSH_LOCATION_ID%TYPE,
8: SOURCE_LOCATION_ID WSH_LOCATIONS.SOURCE_LOCATION_ID%TYPE,
9: LOCATION_SOURCE_CODE WSH_LOCATIONS.LOCATION_SOURCE_CODE%TYPE,
10: LOCATION_CODE WSH_LOCATIONS.LOCATION_CODE%TYPE,
11: UI_LOCATION_CODE WSH_LOCATIONS.UI_LOCATION_CODE%TYPE,
12: ADDRESS1 WSH_LOCATIONS.ADDRESS1%TYPE,
13: ADDRESS2 WSH_LOCATIONS.ADDRESS2%TYPE,
14: ADDRESS3 WSH_LOCATIONS.ADDRESS3%TYPE,
15: ADDRESS4 WSH_LOCATIONS.ADDRESS4%TYPE,

Line 12: ADDRESS1 WSH_LOCATIONS.ADDRESS1%TYPE,

8: SOURCE_LOCATION_ID WSH_LOCATIONS.SOURCE_LOCATION_ID%TYPE,
9: LOCATION_SOURCE_CODE WSH_LOCATIONS.LOCATION_SOURCE_CODE%TYPE,
10: LOCATION_CODE WSH_LOCATIONS.LOCATION_CODE%TYPE,
11: UI_LOCATION_CODE WSH_LOCATIONS.UI_LOCATION_CODE%TYPE,
12: ADDRESS1 WSH_LOCATIONS.ADDRESS1%TYPE,
13: ADDRESS2 WSH_LOCATIONS.ADDRESS2%TYPE,
14: ADDRESS3 WSH_LOCATIONS.ADDRESS3%TYPE,
15: ADDRESS4 WSH_LOCATIONS.ADDRESS4%TYPE,
16: COUNTRY WSH_LOCATIONS.COUNTRY%TYPE,

Line 13: ADDRESS2 WSH_LOCATIONS.ADDRESS2%TYPE,

9: LOCATION_SOURCE_CODE WSH_LOCATIONS.LOCATION_SOURCE_CODE%TYPE,
10: LOCATION_CODE WSH_LOCATIONS.LOCATION_CODE%TYPE,
11: UI_LOCATION_CODE WSH_LOCATIONS.UI_LOCATION_CODE%TYPE,
12: ADDRESS1 WSH_LOCATIONS.ADDRESS1%TYPE,
13: ADDRESS2 WSH_LOCATIONS.ADDRESS2%TYPE,
14: ADDRESS3 WSH_LOCATIONS.ADDRESS3%TYPE,
15: ADDRESS4 WSH_LOCATIONS.ADDRESS4%TYPE,
16: COUNTRY WSH_LOCATIONS.COUNTRY%TYPE,
17: STATE WSH_LOCATIONS.STATE%TYPE,

Line 14: ADDRESS3 WSH_LOCATIONS.ADDRESS3%TYPE,

10: LOCATION_CODE WSH_LOCATIONS.LOCATION_CODE%TYPE,
11: UI_LOCATION_CODE WSH_LOCATIONS.UI_LOCATION_CODE%TYPE,
12: ADDRESS1 WSH_LOCATIONS.ADDRESS1%TYPE,
13: ADDRESS2 WSH_LOCATIONS.ADDRESS2%TYPE,
14: ADDRESS3 WSH_LOCATIONS.ADDRESS3%TYPE,
15: ADDRESS4 WSH_LOCATIONS.ADDRESS4%TYPE,
16: COUNTRY WSH_LOCATIONS.COUNTRY%TYPE,
17: STATE WSH_LOCATIONS.STATE%TYPE,
18: PROVINCE WSH_LOCATIONS.PROVINCE%TYPE,

Line 15: ADDRESS4 WSH_LOCATIONS.ADDRESS4%TYPE,

11: UI_LOCATION_CODE WSH_LOCATIONS.UI_LOCATION_CODE%TYPE,
12: ADDRESS1 WSH_LOCATIONS.ADDRESS1%TYPE,
13: ADDRESS2 WSH_LOCATIONS.ADDRESS2%TYPE,
14: ADDRESS3 WSH_LOCATIONS.ADDRESS3%TYPE,
15: ADDRESS4 WSH_LOCATIONS.ADDRESS4%TYPE,
16: COUNTRY WSH_LOCATIONS.COUNTRY%TYPE,
17: STATE WSH_LOCATIONS.STATE%TYPE,
18: PROVINCE WSH_LOCATIONS.PROVINCE%TYPE,
19: COUNTY WSH_LOCATIONS.COUNTY%TYPE,

Line 16: COUNTRY WSH_LOCATIONS.COUNTRY%TYPE,

12: ADDRESS1 WSH_LOCATIONS.ADDRESS1%TYPE,
13: ADDRESS2 WSH_LOCATIONS.ADDRESS2%TYPE,
14: ADDRESS3 WSH_LOCATIONS.ADDRESS3%TYPE,
15: ADDRESS4 WSH_LOCATIONS.ADDRESS4%TYPE,
16: COUNTRY WSH_LOCATIONS.COUNTRY%TYPE,
17: STATE WSH_LOCATIONS.STATE%TYPE,
18: PROVINCE WSH_LOCATIONS.PROVINCE%TYPE,
19: COUNTY WSH_LOCATIONS.COUNTY%TYPE,
20: CITY WSH_LOCATIONS.CITY%TYPE,

Line 17: STATE WSH_LOCATIONS.STATE%TYPE,

13: ADDRESS2 WSH_LOCATIONS.ADDRESS2%TYPE,
14: ADDRESS3 WSH_LOCATIONS.ADDRESS3%TYPE,
15: ADDRESS4 WSH_LOCATIONS.ADDRESS4%TYPE,
16: COUNTRY WSH_LOCATIONS.COUNTRY%TYPE,
17: STATE WSH_LOCATIONS.STATE%TYPE,
18: PROVINCE WSH_LOCATIONS.PROVINCE%TYPE,
19: COUNTY WSH_LOCATIONS.COUNTY%TYPE,
20: CITY WSH_LOCATIONS.CITY%TYPE,
21: POSTAL_CODE WSH_LOCATIONS.POSTAL_CODE%TYPE,

Line 18: PROVINCE WSH_LOCATIONS.PROVINCE%TYPE,

14: ADDRESS3 WSH_LOCATIONS.ADDRESS3%TYPE,
15: ADDRESS4 WSH_LOCATIONS.ADDRESS4%TYPE,
16: COUNTRY WSH_LOCATIONS.COUNTRY%TYPE,
17: STATE WSH_LOCATIONS.STATE%TYPE,
18: PROVINCE WSH_LOCATIONS.PROVINCE%TYPE,
19: COUNTY WSH_LOCATIONS.COUNTY%TYPE,
20: CITY WSH_LOCATIONS.CITY%TYPE,
21: POSTAL_CODE WSH_LOCATIONS.POSTAL_CODE%TYPE,
22: INACTIVE_DATE WSH_LOCATIONS.INACTIVE_DATE%TYPE);

Line 19: COUNTY WSH_LOCATIONS.COUNTY%TYPE,

15: ADDRESS4 WSH_LOCATIONS.ADDRESS4%TYPE,
16: COUNTRY WSH_LOCATIONS.COUNTRY%TYPE,
17: STATE WSH_LOCATIONS.STATE%TYPE,
18: PROVINCE WSH_LOCATIONS.PROVINCE%TYPE,
19: COUNTY WSH_LOCATIONS.COUNTY%TYPE,
20: CITY WSH_LOCATIONS.CITY%TYPE,
21: POSTAL_CODE WSH_LOCATIONS.POSTAL_CODE%TYPE,
22: INACTIVE_DATE WSH_LOCATIONS.INACTIVE_DATE%TYPE);
23:

Line 20: CITY WSH_LOCATIONS.CITY%TYPE,

16: COUNTRY WSH_LOCATIONS.COUNTRY%TYPE,
17: STATE WSH_LOCATIONS.STATE%TYPE,
18: PROVINCE WSH_LOCATIONS.PROVINCE%TYPE,
19: COUNTY WSH_LOCATIONS.COUNTY%TYPE,
20: CITY WSH_LOCATIONS.CITY%TYPE,
21: POSTAL_CODE WSH_LOCATIONS.POSTAL_CODE%TYPE,
22: INACTIVE_DATE WSH_LOCATIONS.INACTIVE_DATE%TYPE);
23:
24: TYPE TableNumbers is TABLE of NUMBER INDEX BY BINARY_INTEGER; -- table number type

Line 21: POSTAL_CODE WSH_LOCATIONS.POSTAL_CODE%TYPE,

17: STATE WSH_LOCATIONS.STATE%TYPE,
18: PROVINCE WSH_LOCATIONS.PROVINCE%TYPE,
19: COUNTY WSH_LOCATIONS.COUNTY%TYPE,
20: CITY WSH_LOCATIONS.CITY%TYPE,
21: POSTAL_CODE WSH_LOCATIONS.POSTAL_CODE%TYPE,
22: INACTIVE_DATE WSH_LOCATIONS.INACTIVE_DATE%TYPE);
23:
24: TYPE TableNumbers is TABLE of NUMBER INDEX BY BINARY_INTEGER; -- table number type
25: TYPE TableVarchar is TABLE of VARCHAR2(120) INDEX BY BINARY_INTEGER; -- table varchar(120) type

Line 22: INACTIVE_DATE WSH_LOCATIONS.INACTIVE_DATE%TYPE);

18: PROVINCE WSH_LOCATIONS.PROVINCE%TYPE,
19: COUNTY WSH_LOCATIONS.COUNTY%TYPE,
20: CITY WSH_LOCATIONS.CITY%TYPE,
21: POSTAL_CODE WSH_LOCATIONS.POSTAL_CODE%TYPE,
22: INACTIVE_DATE WSH_LOCATIONS.INACTIVE_DATE%TYPE);
23:
24: TYPE TableNumbers is TABLE of NUMBER INDEX BY BINARY_INTEGER; -- table number type
25: TYPE TableVarchar is TABLE of VARCHAR2(120) INDEX BY BINARY_INTEGER; -- table varchar(120) type
26: TYPE TableDate is TABLE of DATE INDEX BY BINARY_INTEGER; -- table date type