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
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
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
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
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
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: );
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;
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: