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 9: WSH_LOCATION_ID WSH_LOCATIONS.WSH_LOCATION_ID%TYPE,

5: --R12.1.1 Standalone Project
6: g_mode VARCHAR2(10) := 'NORMAL';
7:
8: TYPE loc_rec_type IS RECORD(
9: WSH_LOCATION_ID WSH_LOCATIONS.WSH_LOCATION_ID%TYPE,
10: SOURCE_LOCATION_ID WSH_LOCATIONS.SOURCE_LOCATION_ID%TYPE,
11: LOCATION_SOURCE_CODE WSH_LOCATIONS.LOCATION_SOURCE_CODE%TYPE,
12: LOCATION_CODE WSH_LOCATIONS.LOCATION_CODE%TYPE,
13: UI_LOCATION_CODE WSH_LOCATIONS.UI_LOCATION_CODE%TYPE,

Line 10: SOURCE_LOCATION_ID WSH_LOCATIONS.SOURCE_LOCATION_ID%TYPE,

6: g_mode VARCHAR2(10) := 'NORMAL';
7:
8: TYPE loc_rec_type IS RECORD(
9: WSH_LOCATION_ID WSH_LOCATIONS.WSH_LOCATION_ID%TYPE,
10: SOURCE_LOCATION_ID WSH_LOCATIONS.SOURCE_LOCATION_ID%TYPE,
11: LOCATION_SOURCE_CODE WSH_LOCATIONS.LOCATION_SOURCE_CODE%TYPE,
12: LOCATION_CODE WSH_LOCATIONS.LOCATION_CODE%TYPE,
13: UI_LOCATION_CODE WSH_LOCATIONS.UI_LOCATION_CODE%TYPE,
14: ADDRESS1 WSH_LOCATIONS.ADDRESS1%TYPE,

Line 11: LOCATION_SOURCE_CODE WSH_LOCATIONS.LOCATION_SOURCE_CODE%TYPE,

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

Line 12: LOCATION_CODE WSH_LOCATIONS.LOCATION_CODE%TYPE,

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

Line 13: UI_LOCATION_CODE WSH_LOCATIONS.UI_LOCATION_CODE%TYPE,

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

Line 14: ADDRESS1 WSH_LOCATIONS.ADDRESS1%TYPE,

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

Line 15: ADDRESS2 WSH_LOCATIONS.ADDRESS2%TYPE,

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

Line 16: ADDRESS3 WSH_LOCATIONS.ADDRESS3%TYPE,

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

Line 17: ADDRESS4 WSH_LOCATIONS.ADDRESS4%TYPE,

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

Line 18: COUNTRY WSH_LOCATIONS.COUNTRY%TYPE,

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

Line 19: STATE WSH_LOCATIONS.STATE%TYPE,

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

Line 20: PROVINCE WSH_LOCATIONS.PROVINCE%TYPE,

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

Line 21: COUNTY WSH_LOCATIONS.COUNTY%TYPE,

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

Line 22: CITY WSH_LOCATIONS.CITY%TYPE,

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

Line 23: POSTAL_CODE WSH_LOCATIONS.POSTAL_CODE%TYPE,

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

Line 24: INACTIVE_DATE WSH_LOCATIONS.INACTIVE_DATE%TYPE);

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