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

Line 1: PACKAGE WSH_LOCATIONS_PKG as

1: PACKAGE WSH_LOCATIONS_PKG as
2: /* $Header: WSHLOCMS.pls 120.1.12000000.1 2007/01/16 05:47:58 appldev ship $ */
3:
4: TYPE location_rec_type IS RECORD (
5: WSH_LOCATION_ID WSH_LOCATIONS.WSH_LOCATION_ID%TYPE,

Line 5: WSH_LOCATION_ID WSH_LOCATIONS.WSH_LOCATION_ID%TYPE,

1: PACKAGE WSH_LOCATIONS_PKG as
2: /* $Header: WSHLOCMS.pls 120.1.12000000.1 2007/01/16 05:47:58 appldev ship $ */
3:
4: TYPE location_rec_type IS RECORD (
5: WSH_LOCATION_ID WSH_LOCATIONS.WSH_LOCATION_ID%TYPE,
6: SOURCE_LOCATION_ID WSH_LOCATIONS.SOURCE_LOCATION_ID%TYPE,
7: LOCATION_SOURCE_CODE WSH_LOCATIONS.LOCATION_SOURCE_CODE%TYPE,
8: LOCATION_CODE WSH_LOCATIONS.LOCATION_CODE%TYPE,
9: UI_LOCATION_CODE WSH_LOCATIONS.UI_LOCATION_CODE%TYPE,

Line 6: SOURCE_LOCATION_ID WSH_LOCATIONS.SOURCE_LOCATION_ID%TYPE,

2: /* $Header: WSHLOCMS.pls 120.1.12000000.1 2007/01/16 05:47:58 appldev ship $ */
3:
4: TYPE location_rec_type IS RECORD (
5: WSH_LOCATION_ID WSH_LOCATIONS.WSH_LOCATION_ID%TYPE,
6: SOURCE_LOCATION_ID WSH_LOCATIONS.SOURCE_LOCATION_ID%TYPE,
7: LOCATION_SOURCE_CODE WSH_LOCATIONS.LOCATION_SOURCE_CODE%TYPE,
8: LOCATION_CODE WSH_LOCATIONS.LOCATION_CODE%TYPE,
9: UI_LOCATION_CODE WSH_LOCATIONS.UI_LOCATION_CODE%TYPE,
10: ADDRESS1 WSH_LOCATIONS.ADDRESS1%TYPE,

Line 7: LOCATION_SOURCE_CODE WSH_LOCATIONS.LOCATION_SOURCE_CODE%TYPE,

3:
4: TYPE location_rec_type IS RECORD (
5: WSH_LOCATION_ID WSH_LOCATIONS.WSH_LOCATION_ID%TYPE,
6: SOURCE_LOCATION_ID WSH_LOCATIONS.SOURCE_LOCATION_ID%TYPE,
7: LOCATION_SOURCE_CODE WSH_LOCATIONS.LOCATION_SOURCE_CODE%TYPE,
8: LOCATION_CODE WSH_LOCATIONS.LOCATION_CODE%TYPE,
9: UI_LOCATION_CODE WSH_LOCATIONS.UI_LOCATION_CODE%TYPE,
10: ADDRESS1 WSH_LOCATIONS.ADDRESS1%TYPE,
11: ADDRESS2 WSH_LOCATIONS.ADDRESS2%TYPE,

Line 8: LOCATION_CODE WSH_LOCATIONS.LOCATION_CODE%TYPE,

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

Line 9: UI_LOCATION_CODE WSH_LOCATIONS.UI_LOCATION_CODE%TYPE,

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

Line 10: ADDRESS1 WSH_LOCATIONS.ADDRESS1%TYPE,

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

Line 11: ADDRESS2 WSH_LOCATIONS.ADDRESS2%TYPE,

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

Line 12: ADDRESS3 WSH_LOCATIONS.ADDRESS3%TYPE,

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

Line 13: ADDRESS4 WSH_LOCATIONS.ADDRESS4%TYPE,

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

Line 14: COUNTRY WSH_LOCATIONS.COUNTRY%TYPE,

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

Line 15: STATE WSH_LOCATIONS.STATE%TYPE,

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

Line 16: PROVINCE WSH_LOCATIONS.PROVINCE%TYPE,

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

Line 17: COUNTY WSH_LOCATIONS.COUNTY%TYPE,

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

Line 18: CITY WSH_LOCATIONS.CITY%TYPE,

14: COUNTRY WSH_LOCATIONS.COUNTRY%TYPE,
15: STATE WSH_LOCATIONS.STATE%TYPE,
16: PROVINCE WSH_LOCATIONS.PROVINCE%TYPE,
17: COUNTY WSH_LOCATIONS.COUNTY%TYPE,
18: CITY WSH_LOCATIONS.CITY%TYPE,
19: POSTAL_CODE WSH_LOCATIONS.POSTAL_CODE%TYPE,
20: INACTIVE_DATE WSH_LOCATIONS.INACTIVE_DATE%TYPE,
21: LONGITUDE WSH_LOCATIONS.LONGITUDE%TYPE,
22: LATITUDE WSH_LOCATIONS.LATITUDE%TYPE,

Line 19: POSTAL_CODE WSH_LOCATIONS.POSTAL_CODE%TYPE,

15: STATE WSH_LOCATIONS.STATE%TYPE,
16: PROVINCE WSH_LOCATIONS.PROVINCE%TYPE,
17: COUNTY WSH_LOCATIONS.COUNTY%TYPE,
18: CITY WSH_LOCATIONS.CITY%TYPE,
19: POSTAL_CODE WSH_LOCATIONS.POSTAL_CODE%TYPE,
20: INACTIVE_DATE WSH_LOCATIONS.INACTIVE_DATE%TYPE,
21: LONGITUDE WSH_LOCATIONS.LONGITUDE%TYPE,
22: LATITUDE WSH_LOCATIONS.LATITUDE%TYPE,
23: GEOMETRY WSH_LOCATIONS.GEOMETRY%TYPE,

Line 20: INACTIVE_DATE WSH_LOCATIONS.INACTIVE_DATE%TYPE,

16: PROVINCE WSH_LOCATIONS.PROVINCE%TYPE,
17: COUNTY WSH_LOCATIONS.COUNTY%TYPE,
18: CITY WSH_LOCATIONS.CITY%TYPE,
19: POSTAL_CODE WSH_LOCATIONS.POSTAL_CODE%TYPE,
20: INACTIVE_DATE WSH_LOCATIONS.INACTIVE_DATE%TYPE,
21: LONGITUDE WSH_LOCATIONS.LONGITUDE%TYPE,
22: LATITUDE WSH_LOCATIONS.LATITUDE%TYPE,
23: GEOMETRY WSH_LOCATIONS.GEOMETRY%TYPE,
24: TIMEZONE_CODE WSH_LOCATIONS.TIMEZONE_CODE%TYPE

Line 21: LONGITUDE WSH_LOCATIONS.LONGITUDE%TYPE,

17: COUNTY WSH_LOCATIONS.COUNTY%TYPE,
18: CITY WSH_LOCATIONS.CITY%TYPE,
19: POSTAL_CODE WSH_LOCATIONS.POSTAL_CODE%TYPE,
20: INACTIVE_DATE WSH_LOCATIONS.INACTIVE_DATE%TYPE,
21: LONGITUDE WSH_LOCATIONS.LONGITUDE%TYPE,
22: LATITUDE WSH_LOCATIONS.LATITUDE%TYPE,
23: GEOMETRY WSH_LOCATIONS.GEOMETRY%TYPE,
24: TIMEZONE_CODE WSH_LOCATIONS.TIMEZONE_CODE%TYPE
25: );

Line 22: LATITUDE WSH_LOCATIONS.LATITUDE%TYPE,

18: CITY WSH_LOCATIONS.CITY%TYPE,
19: POSTAL_CODE WSH_LOCATIONS.POSTAL_CODE%TYPE,
20: INACTIVE_DATE WSH_LOCATIONS.INACTIVE_DATE%TYPE,
21: LONGITUDE WSH_LOCATIONS.LONGITUDE%TYPE,
22: LATITUDE WSH_LOCATIONS.LATITUDE%TYPE,
23: GEOMETRY WSH_LOCATIONS.GEOMETRY%TYPE,
24: TIMEZONE_CODE WSH_LOCATIONS.TIMEZONE_CODE%TYPE
25: );
26:

Line 23: GEOMETRY WSH_LOCATIONS.GEOMETRY%TYPE,

19: POSTAL_CODE WSH_LOCATIONS.POSTAL_CODE%TYPE,
20: INACTIVE_DATE WSH_LOCATIONS.INACTIVE_DATE%TYPE,
21: LONGITUDE WSH_LOCATIONS.LONGITUDE%TYPE,
22: LATITUDE WSH_LOCATIONS.LATITUDE%TYPE,
23: GEOMETRY WSH_LOCATIONS.GEOMETRY%TYPE,
24: TIMEZONE_CODE WSH_LOCATIONS.TIMEZONE_CODE%TYPE
25: );
26:
27: --

Line 24: TIMEZONE_CODE WSH_LOCATIONS.TIMEZONE_CODE%TYPE

20: INACTIVE_DATE WSH_LOCATIONS.INACTIVE_DATE%TYPE,
21: LONGITUDE WSH_LOCATIONS.LONGITUDE%TYPE,
22: LATITUDE WSH_LOCATIONS.LATITUDE%TYPE,
23: GEOMETRY WSH_LOCATIONS.GEOMETRY%TYPE,
24: TIMEZONE_CODE WSH_LOCATIONS.TIMEZONE_CODE%TYPE
25: );
26:
27: --
28: -- Package: WSH_LOCATIONS_PKG

Line 28: -- Package: WSH_LOCATIONS_PKG

24: TIMEZONE_CODE WSH_LOCATIONS.TIMEZONE_CODE%TYPE
25: );
26:
27: --
28: -- Package: WSH_LOCATIONS_PKG
29: --
30: -- Purpose: To populate data in WSH_LOCATIONS with the data in
31: -- HZ_LOCATIONS, HR_LOCATIONS
32: --

Line 30: -- Purpose: To populate data in WSH_LOCATIONS with the data in

26:
27: --
28: -- Package: WSH_LOCATIONS_PKG
29: --
30: -- Purpose: To populate data in WSH_LOCATIONS with the data in
31: -- HZ_LOCATIONS, HR_LOCATIONS
32: --
33: --
34: /*===========================================================================+

Line 40: | This procedure will populate the WSH_LOCATIONS table |

36: | Process_Locations |
37: | |
38: | DESCRIPTION |
39: | |
40: | This procedure will populate the WSH_LOCATIONS table |
41: | with the locations in HZ_LOCATIONS (whose usage is deliver_to |
42: | or ship_to) and HR_LOCATIONS |
43: | |
44: +===========================================================================*/

Line 153: END WSH_LOCATIONS_PKG;

149: pTimezoneTbl LocationCode_Tbl_Type;
150: --pGeometryTbl Geometry_Tbl_Type;
151: pLastUpdateDateTbl Date_Tbl_Type;
152:
153: END WSH_LOCATIONS_PKG;