DBA Data[Home] [Help]

APPS.WSH_UTIL_CORE dependencies on WSH_LOCATIONS

Line 20: ,location_source_code wsh_locations.location_source_code%TYPE

16:
17: TYPE Loc_Info_rec IS REcord (
18: wsh_location_id NUMBER
19: ,source_location_id NUMBER
20: ,location_source_code wsh_locations.location_source_code%TYPE
21: ,location_code wsh_locations.location_code%TYPE
22: ,address1 wsh_locations.address1%TYPE
23: ,city wsh_locations.city%TYPE
24: ,state wsh_locations.state%TYPE

Line 21: ,location_code wsh_locations.location_code%TYPE

17: TYPE Loc_Info_rec IS REcord (
18: wsh_location_id NUMBER
19: ,source_location_id NUMBER
20: ,location_source_code wsh_locations.location_source_code%TYPE
21: ,location_code wsh_locations.location_code%TYPE
22: ,address1 wsh_locations.address1%TYPE
23: ,city wsh_locations.city%TYPE
24: ,state wsh_locations.state%TYPE
25: ,country wsh_locations.country%TYPE

Line 22: ,address1 wsh_locations.address1%TYPE

18: wsh_location_id NUMBER
19: ,source_location_id NUMBER
20: ,location_source_code wsh_locations.location_source_code%TYPE
21: ,location_code wsh_locations.location_code%TYPE
22: ,address1 wsh_locations.address1%TYPE
23: ,city wsh_locations.city%TYPE
24: ,state wsh_locations.state%TYPE
25: ,country wsh_locations.country%TYPE
26: ,postal_code wsh_locations.postal_code%TYPE

Line 23: ,city wsh_locations.city%TYPE

19: ,source_location_id NUMBER
20: ,location_source_code wsh_locations.location_source_code%TYPE
21: ,location_code wsh_locations.location_code%TYPE
22: ,address1 wsh_locations.address1%TYPE
23: ,city wsh_locations.city%TYPE
24: ,state wsh_locations.state%TYPE
25: ,country wsh_locations.country%TYPE
26: ,postal_code wsh_locations.postal_code%TYPE
27: ,ui_location_code wsh_locations.ui_location_code%TYPE

Line 24: ,state wsh_locations.state%TYPE

20: ,location_source_code wsh_locations.location_source_code%TYPE
21: ,location_code wsh_locations.location_code%TYPE
22: ,address1 wsh_locations.address1%TYPE
23: ,city wsh_locations.city%TYPE
24: ,state wsh_locations.state%TYPE
25: ,country wsh_locations.country%TYPE
26: ,postal_code wsh_locations.postal_code%TYPE
27: ,ui_location_code wsh_locations.ui_location_code%TYPE
28: ,hr_location_code hr_locations_all.location_code%TYPE

Line 25: ,country wsh_locations.country%TYPE

21: ,location_code wsh_locations.location_code%TYPE
22: ,address1 wsh_locations.address1%TYPE
23: ,city wsh_locations.city%TYPE
24: ,state wsh_locations.state%TYPE
25: ,country wsh_locations.country%TYPE
26: ,postal_code wsh_locations.postal_code%TYPE
27: ,ui_location_code wsh_locations.ui_location_code%TYPE
28: ,hr_location_code hr_locations_all.location_code%TYPE
29: );

Line 26: ,postal_code wsh_locations.postal_code%TYPE

22: ,address1 wsh_locations.address1%TYPE
23: ,city wsh_locations.city%TYPE
24: ,state wsh_locations.state%TYPE
25: ,country wsh_locations.country%TYPE
26: ,postal_code wsh_locations.postal_code%TYPE
27: ,ui_location_code wsh_locations.ui_location_code%TYPE
28: ,hr_location_code hr_locations_all.location_code%TYPE
29: );
30: TYPE Loc_Info_Tab IS TABLE OF Loc_Info_rec INDEX BY BINARY_INTEGER;

Line 27: ,ui_location_code wsh_locations.ui_location_code%TYPE

23: ,city wsh_locations.city%TYPE
24: ,state wsh_locations.state%TYPE
25: ,country wsh_locations.country%TYPE
26: ,postal_code wsh_locations.postal_code%TYPE
27: ,ui_location_code wsh_locations.ui_location_code%TYPE
28: ,hr_location_code hr_locations_all.location_code%TYPE
29: );
30: TYPE Loc_Info_Tab IS TABLE OF Loc_Info_rec INDEX BY BINARY_INTEGER;
31: