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.HR_LOCATION_RECORD dependencies on HR_LOCATIONS

Line 12: location_id hr_locations.location_id%TYPE,

8: */
9:
10: TYPE location_rectype IS RECORD
11: (
12: location_id hr_locations.location_id%TYPE,
13: location_code hr_locations.location_code%TYPE,
14: location_use hr_locations.location_use%TYPE,
15: business_group_id hr_locations.business_group_id%TYPE,
16: description hr_locations.description%TYPE,

Line 13: location_code hr_locations.location_code%TYPE,

9:
10: TYPE location_rectype IS RECORD
11: (
12: location_id hr_locations.location_id%TYPE,
13: location_code hr_locations.location_code%TYPE,
14: location_use hr_locations.location_use%TYPE,
15: business_group_id hr_locations.business_group_id%TYPE,
16: description hr_locations.description%TYPE,
17: ship_to_location_id hr_locations.ship_to_location_id%TYPE,

Line 14: location_use hr_locations.location_use%TYPE,

10: TYPE location_rectype IS RECORD
11: (
12: location_id hr_locations.location_id%TYPE,
13: location_code hr_locations.location_code%TYPE,
14: location_use hr_locations.location_use%TYPE,
15: business_group_id hr_locations.business_group_id%TYPE,
16: description hr_locations.description%TYPE,
17: ship_to_location_id hr_locations.ship_to_location_id%TYPE,
18: ship_to_site_flag hr_locations.ship_to_site_flag%TYPE,

Line 15: business_group_id hr_locations.business_group_id%TYPE,

11: (
12: location_id hr_locations.location_id%TYPE,
13: location_code hr_locations.location_code%TYPE,
14: location_use hr_locations.location_use%TYPE,
15: business_group_id hr_locations.business_group_id%TYPE,
16: description hr_locations.description%TYPE,
17: ship_to_location_id hr_locations.ship_to_location_id%TYPE,
18: ship_to_site_flag hr_locations.ship_to_site_flag%TYPE,
19: receiving_site_flag hr_locations.receiving_site_flag%TYPE,

Line 16: description hr_locations.description%TYPE,

12: location_id hr_locations.location_id%TYPE,
13: location_code hr_locations.location_code%TYPE,
14: location_use hr_locations.location_use%TYPE,
15: business_group_id hr_locations.business_group_id%TYPE,
16: description hr_locations.description%TYPE,
17: ship_to_location_id hr_locations.ship_to_location_id%TYPE,
18: ship_to_site_flag hr_locations.ship_to_site_flag%TYPE,
19: receiving_site_flag hr_locations.receiving_site_flag%TYPE,
20: bill_to_site_flag hr_locations.bill_to_site_flag%TYPE,

Line 17: ship_to_location_id hr_locations.ship_to_location_id%TYPE,

13: location_code hr_locations.location_code%TYPE,
14: location_use hr_locations.location_use%TYPE,
15: business_group_id hr_locations.business_group_id%TYPE,
16: description hr_locations.description%TYPE,
17: ship_to_location_id hr_locations.ship_to_location_id%TYPE,
18: ship_to_site_flag hr_locations.ship_to_site_flag%TYPE,
19: receiving_site_flag hr_locations.receiving_site_flag%TYPE,
20: bill_to_site_flag hr_locations.bill_to_site_flag%TYPE,
21: in_organization_flag hr_locations.in_organization_flag%TYPE,

Line 18: ship_to_site_flag hr_locations.ship_to_site_flag%TYPE,

14: location_use hr_locations.location_use%TYPE,
15: business_group_id hr_locations.business_group_id%TYPE,
16: description hr_locations.description%TYPE,
17: ship_to_location_id hr_locations.ship_to_location_id%TYPE,
18: ship_to_site_flag hr_locations.ship_to_site_flag%TYPE,
19: receiving_site_flag hr_locations.receiving_site_flag%TYPE,
20: bill_to_site_flag hr_locations.bill_to_site_flag%TYPE,
21: in_organization_flag hr_locations.in_organization_flag%TYPE,
22: office_site_flag hr_locations.office_site_flag%TYPE,

Line 19: receiving_site_flag hr_locations.receiving_site_flag%TYPE,

15: business_group_id hr_locations.business_group_id%TYPE,
16: description hr_locations.description%TYPE,
17: ship_to_location_id hr_locations.ship_to_location_id%TYPE,
18: ship_to_site_flag hr_locations.ship_to_site_flag%TYPE,
19: receiving_site_flag hr_locations.receiving_site_flag%TYPE,
20: bill_to_site_flag hr_locations.bill_to_site_flag%TYPE,
21: in_organization_flag hr_locations.in_organization_flag%TYPE,
22: office_site_flag hr_locations.office_site_flag%TYPE,
23: designated_receiver_id hr_locations.designated_receiver_id%TYPE,

Line 20: bill_to_site_flag hr_locations.bill_to_site_flag%TYPE,

16: description hr_locations.description%TYPE,
17: ship_to_location_id hr_locations.ship_to_location_id%TYPE,
18: ship_to_site_flag hr_locations.ship_to_site_flag%TYPE,
19: receiving_site_flag hr_locations.receiving_site_flag%TYPE,
20: bill_to_site_flag hr_locations.bill_to_site_flag%TYPE,
21: in_organization_flag hr_locations.in_organization_flag%TYPE,
22: office_site_flag hr_locations.office_site_flag%TYPE,
23: designated_receiver_id hr_locations.designated_receiver_id%TYPE,
24: inventory_organization_id hr_locations.inventory_organization_id%TYPE,

Line 21: in_organization_flag hr_locations.in_organization_flag%TYPE,

17: ship_to_location_id hr_locations.ship_to_location_id%TYPE,
18: ship_to_site_flag hr_locations.ship_to_site_flag%TYPE,
19: receiving_site_flag hr_locations.receiving_site_flag%TYPE,
20: bill_to_site_flag hr_locations.bill_to_site_flag%TYPE,
21: in_organization_flag hr_locations.in_organization_flag%TYPE,
22: office_site_flag hr_locations.office_site_flag%TYPE,
23: designated_receiver_id hr_locations.designated_receiver_id%TYPE,
24: inventory_organization_id hr_locations.inventory_organization_id%TYPE,
25: tax_name hr_locations.tax_name%TYPE,

Line 22: office_site_flag hr_locations.office_site_flag%TYPE,

18: ship_to_site_flag hr_locations.ship_to_site_flag%TYPE,
19: receiving_site_flag hr_locations.receiving_site_flag%TYPE,
20: bill_to_site_flag hr_locations.bill_to_site_flag%TYPE,
21: in_organization_flag hr_locations.in_organization_flag%TYPE,
22: office_site_flag hr_locations.office_site_flag%TYPE,
23: designated_receiver_id hr_locations.designated_receiver_id%TYPE,
24: inventory_organization_id hr_locations.inventory_organization_id%TYPE,
25: tax_name hr_locations.tax_name%TYPE,
26: inactive_date hr_locations.inactive_date%TYPE,

Line 23: designated_receiver_id hr_locations.designated_receiver_id%TYPE,

19: receiving_site_flag hr_locations.receiving_site_flag%TYPE,
20: bill_to_site_flag hr_locations.bill_to_site_flag%TYPE,
21: in_organization_flag hr_locations.in_organization_flag%TYPE,
22: office_site_flag hr_locations.office_site_flag%TYPE,
23: designated_receiver_id hr_locations.designated_receiver_id%TYPE,
24: inventory_organization_id hr_locations.inventory_organization_id%TYPE,
25: tax_name hr_locations.tax_name%TYPE,
26: inactive_date hr_locations.inactive_date%TYPE,
27: style hr_locations.style%TYPE,

Line 24: inventory_organization_id hr_locations.inventory_organization_id%TYPE,

20: bill_to_site_flag hr_locations.bill_to_site_flag%TYPE,
21: in_organization_flag hr_locations.in_organization_flag%TYPE,
22: office_site_flag hr_locations.office_site_flag%TYPE,
23: designated_receiver_id hr_locations.designated_receiver_id%TYPE,
24: inventory_organization_id hr_locations.inventory_organization_id%TYPE,
25: tax_name hr_locations.tax_name%TYPE,
26: inactive_date hr_locations.inactive_date%TYPE,
27: style hr_locations.style%TYPE,
28: address_line_1 hr_locations.address_line_1%TYPE,

Line 25: tax_name hr_locations.tax_name%TYPE,

21: in_organization_flag hr_locations.in_organization_flag%TYPE,
22: office_site_flag hr_locations.office_site_flag%TYPE,
23: designated_receiver_id hr_locations.designated_receiver_id%TYPE,
24: inventory_organization_id hr_locations.inventory_organization_id%TYPE,
25: tax_name hr_locations.tax_name%TYPE,
26: inactive_date hr_locations.inactive_date%TYPE,
27: style hr_locations.style%TYPE,
28: address_line_1 hr_locations.address_line_1%TYPE,
29: address_line_2 hr_locations.address_line_2%TYPE,

Line 26: inactive_date hr_locations.inactive_date%TYPE,

22: office_site_flag hr_locations.office_site_flag%TYPE,
23: designated_receiver_id hr_locations.designated_receiver_id%TYPE,
24: inventory_organization_id hr_locations.inventory_organization_id%TYPE,
25: tax_name hr_locations.tax_name%TYPE,
26: inactive_date hr_locations.inactive_date%TYPE,
27: style hr_locations.style%TYPE,
28: address_line_1 hr_locations.address_line_1%TYPE,
29: address_line_2 hr_locations.address_line_2%TYPE,
30: address_line_3 hr_locations.address_line_3%TYPE,

Line 27: style hr_locations.style%TYPE,

23: designated_receiver_id hr_locations.designated_receiver_id%TYPE,
24: inventory_organization_id hr_locations.inventory_organization_id%TYPE,
25: tax_name hr_locations.tax_name%TYPE,
26: inactive_date hr_locations.inactive_date%TYPE,
27: style hr_locations.style%TYPE,
28: address_line_1 hr_locations.address_line_1%TYPE,
29: address_line_2 hr_locations.address_line_2%TYPE,
30: address_line_3 hr_locations.address_line_3%TYPE,
31: town_or_city hr_locations.town_or_city%TYPE,

Line 28: address_line_1 hr_locations.address_line_1%TYPE,

24: inventory_organization_id hr_locations.inventory_organization_id%TYPE,
25: tax_name hr_locations.tax_name%TYPE,
26: inactive_date hr_locations.inactive_date%TYPE,
27: style hr_locations.style%TYPE,
28: address_line_1 hr_locations.address_line_1%TYPE,
29: address_line_2 hr_locations.address_line_2%TYPE,
30: address_line_3 hr_locations.address_line_3%TYPE,
31: town_or_city hr_locations.town_or_city%TYPE,
32: country hr_locations.country%TYPE,

Line 29: address_line_2 hr_locations.address_line_2%TYPE,

25: tax_name hr_locations.tax_name%TYPE,
26: inactive_date hr_locations.inactive_date%TYPE,
27: style hr_locations.style%TYPE,
28: address_line_1 hr_locations.address_line_1%TYPE,
29: address_line_2 hr_locations.address_line_2%TYPE,
30: address_line_3 hr_locations.address_line_3%TYPE,
31: town_or_city hr_locations.town_or_city%TYPE,
32: country hr_locations.country%TYPE,
33: postal_code hr_locations.postal_code%TYPE,

Line 30: address_line_3 hr_locations.address_line_3%TYPE,

26: inactive_date hr_locations.inactive_date%TYPE,
27: style hr_locations.style%TYPE,
28: address_line_1 hr_locations.address_line_1%TYPE,
29: address_line_2 hr_locations.address_line_2%TYPE,
30: address_line_3 hr_locations.address_line_3%TYPE,
31: town_or_city hr_locations.town_or_city%TYPE,
32: country hr_locations.country%TYPE,
33: postal_code hr_locations.postal_code%TYPE,
34: region_1 hr_locations.region_1%TYPE,

Line 31: town_or_city hr_locations.town_or_city%TYPE,

27: style hr_locations.style%TYPE,
28: address_line_1 hr_locations.address_line_1%TYPE,
29: address_line_2 hr_locations.address_line_2%TYPE,
30: address_line_3 hr_locations.address_line_3%TYPE,
31: town_or_city hr_locations.town_or_city%TYPE,
32: country hr_locations.country%TYPE,
33: postal_code hr_locations.postal_code%TYPE,
34: region_1 hr_locations.region_1%TYPE,
35: region_2 hr_locations.region_2%TYPE,

Line 32: country hr_locations.country%TYPE,

28: address_line_1 hr_locations.address_line_1%TYPE,
29: address_line_2 hr_locations.address_line_2%TYPE,
30: address_line_3 hr_locations.address_line_3%TYPE,
31: town_or_city hr_locations.town_or_city%TYPE,
32: country hr_locations.country%TYPE,
33: postal_code hr_locations.postal_code%TYPE,
34: region_1 hr_locations.region_1%TYPE,
35: region_2 hr_locations.region_2%TYPE,
36: region_3 hr_locations.region_3%TYPE,

Line 33: postal_code hr_locations.postal_code%TYPE,

29: address_line_2 hr_locations.address_line_2%TYPE,
30: address_line_3 hr_locations.address_line_3%TYPE,
31: town_or_city hr_locations.town_or_city%TYPE,
32: country hr_locations.country%TYPE,
33: postal_code hr_locations.postal_code%TYPE,
34: region_1 hr_locations.region_1%TYPE,
35: region_2 hr_locations.region_2%TYPE,
36: region_3 hr_locations.region_3%TYPE,
37: telephone_number_1 hr_locations.telephone_number_1%TYPE,

Line 34: region_1 hr_locations.region_1%TYPE,

30: address_line_3 hr_locations.address_line_3%TYPE,
31: town_or_city hr_locations.town_or_city%TYPE,
32: country hr_locations.country%TYPE,
33: postal_code hr_locations.postal_code%TYPE,
34: region_1 hr_locations.region_1%TYPE,
35: region_2 hr_locations.region_2%TYPE,
36: region_3 hr_locations.region_3%TYPE,
37: telephone_number_1 hr_locations.telephone_number_1%TYPE,
38: telephone_number_2 hr_locations.telephone_number_2%TYPE,

Line 35: region_2 hr_locations.region_2%TYPE,

31: town_or_city hr_locations.town_or_city%TYPE,
32: country hr_locations.country%TYPE,
33: postal_code hr_locations.postal_code%TYPE,
34: region_1 hr_locations.region_1%TYPE,
35: region_2 hr_locations.region_2%TYPE,
36: region_3 hr_locations.region_3%TYPE,
37: telephone_number_1 hr_locations.telephone_number_1%TYPE,
38: telephone_number_2 hr_locations.telephone_number_2%TYPE,
39: telephone_number_3 hr_locations.telephone_number_3%TYPE,

Line 36: region_3 hr_locations.region_3%TYPE,

32: country hr_locations.country%TYPE,
33: postal_code hr_locations.postal_code%TYPE,
34: region_1 hr_locations.region_1%TYPE,
35: region_2 hr_locations.region_2%TYPE,
36: region_3 hr_locations.region_3%TYPE,
37: telephone_number_1 hr_locations.telephone_number_1%TYPE,
38: telephone_number_2 hr_locations.telephone_number_2%TYPE,
39: telephone_number_3 hr_locations.telephone_number_3%TYPE,
40: loc_information13 hr_locations.loc_information13%TYPE,

Line 37: telephone_number_1 hr_locations.telephone_number_1%TYPE,

33: postal_code hr_locations.postal_code%TYPE,
34: region_1 hr_locations.region_1%TYPE,
35: region_2 hr_locations.region_2%TYPE,
36: region_3 hr_locations.region_3%TYPE,
37: telephone_number_1 hr_locations.telephone_number_1%TYPE,
38: telephone_number_2 hr_locations.telephone_number_2%TYPE,
39: telephone_number_3 hr_locations.telephone_number_3%TYPE,
40: loc_information13 hr_locations.loc_information13%TYPE,
41: loc_information14 hr_locations.loc_information14%TYPE,

Line 38: telephone_number_2 hr_locations.telephone_number_2%TYPE,

34: region_1 hr_locations.region_1%TYPE,
35: region_2 hr_locations.region_2%TYPE,
36: region_3 hr_locations.region_3%TYPE,
37: telephone_number_1 hr_locations.telephone_number_1%TYPE,
38: telephone_number_2 hr_locations.telephone_number_2%TYPE,
39: telephone_number_3 hr_locations.telephone_number_3%TYPE,
40: loc_information13 hr_locations.loc_information13%TYPE,
41: loc_information14 hr_locations.loc_information14%TYPE,
42: loc_information15 hr_locations.loc_information15%TYPE,

Line 39: telephone_number_3 hr_locations.telephone_number_3%TYPE,

35: region_2 hr_locations.region_2%TYPE,
36: region_3 hr_locations.region_3%TYPE,
37: telephone_number_1 hr_locations.telephone_number_1%TYPE,
38: telephone_number_2 hr_locations.telephone_number_2%TYPE,
39: telephone_number_3 hr_locations.telephone_number_3%TYPE,
40: loc_information13 hr_locations.loc_information13%TYPE,
41: loc_information14 hr_locations.loc_information14%TYPE,
42: loc_information15 hr_locations.loc_information15%TYPE,
43: loc_information16 hr_locations.loc_information16%TYPE,

Line 40: loc_information13 hr_locations.loc_information13%TYPE,

36: region_3 hr_locations.region_3%TYPE,
37: telephone_number_1 hr_locations.telephone_number_1%TYPE,
38: telephone_number_2 hr_locations.telephone_number_2%TYPE,
39: telephone_number_3 hr_locations.telephone_number_3%TYPE,
40: loc_information13 hr_locations.loc_information13%TYPE,
41: loc_information14 hr_locations.loc_information14%TYPE,
42: loc_information15 hr_locations.loc_information15%TYPE,
43: loc_information16 hr_locations.loc_information16%TYPE,
44: loc_information17 hr_locations.loc_information17%TYPE,

Line 41: loc_information14 hr_locations.loc_information14%TYPE,

37: telephone_number_1 hr_locations.telephone_number_1%TYPE,
38: telephone_number_2 hr_locations.telephone_number_2%TYPE,
39: telephone_number_3 hr_locations.telephone_number_3%TYPE,
40: loc_information13 hr_locations.loc_information13%TYPE,
41: loc_information14 hr_locations.loc_information14%TYPE,
42: loc_information15 hr_locations.loc_information15%TYPE,
43: loc_information16 hr_locations.loc_information16%TYPE,
44: loc_information17 hr_locations.loc_information17%TYPE,
45: loc_information18 hr_locations.loc_information18%TYPE,

Line 42: loc_information15 hr_locations.loc_information15%TYPE,

38: telephone_number_2 hr_locations.telephone_number_2%TYPE,
39: telephone_number_3 hr_locations.telephone_number_3%TYPE,
40: loc_information13 hr_locations.loc_information13%TYPE,
41: loc_information14 hr_locations.loc_information14%TYPE,
42: loc_information15 hr_locations.loc_information15%TYPE,
43: loc_information16 hr_locations.loc_information16%TYPE,
44: loc_information17 hr_locations.loc_information17%TYPE,
45: loc_information18 hr_locations.loc_information18%TYPE,
46: loc_information19 hr_locations.loc_information19%TYPE,

Line 43: loc_information16 hr_locations.loc_information16%TYPE,

39: telephone_number_3 hr_locations.telephone_number_3%TYPE,
40: loc_information13 hr_locations.loc_information13%TYPE,
41: loc_information14 hr_locations.loc_information14%TYPE,
42: loc_information15 hr_locations.loc_information15%TYPE,
43: loc_information16 hr_locations.loc_information16%TYPE,
44: loc_information17 hr_locations.loc_information17%TYPE,
45: loc_information18 hr_locations.loc_information18%TYPE,
46: loc_information19 hr_locations.loc_information19%TYPE,
47: loc_information20 hr_locations.loc_information20%TYPE,

Line 44: loc_information17 hr_locations.loc_information17%TYPE,

40: loc_information13 hr_locations.loc_information13%TYPE,
41: loc_information14 hr_locations.loc_information14%TYPE,
42: loc_information15 hr_locations.loc_information15%TYPE,
43: loc_information16 hr_locations.loc_information16%TYPE,
44: loc_information17 hr_locations.loc_information17%TYPE,
45: loc_information18 hr_locations.loc_information18%TYPE,
46: loc_information19 hr_locations.loc_information19%TYPE,
47: loc_information20 hr_locations.loc_information20%TYPE,
48: attribute_category hr_locations.attribute_category%TYPE,

Line 45: loc_information18 hr_locations.loc_information18%TYPE,

41: loc_information14 hr_locations.loc_information14%TYPE,
42: loc_information15 hr_locations.loc_information15%TYPE,
43: loc_information16 hr_locations.loc_information16%TYPE,
44: loc_information17 hr_locations.loc_information17%TYPE,
45: loc_information18 hr_locations.loc_information18%TYPE,
46: loc_information19 hr_locations.loc_information19%TYPE,
47: loc_information20 hr_locations.loc_information20%TYPE,
48: attribute_category hr_locations.attribute_category%TYPE,
49: attribute1 hr_locations.attribute1%TYPE,

Line 46: loc_information19 hr_locations.loc_information19%TYPE,

42: loc_information15 hr_locations.loc_information15%TYPE,
43: loc_information16 hr_locations.loc_information16%TYPE,
44: loc_information17 hr_locations.loc_information17%TYPE,
45: loc_information18 hr_locations.loc_information18%TYPE,
46: loc_information19 hr_locations.loc_information19%TYPE,
47: loc_information20 hr_locations.loc_information20%TYPE,
48: attribute_category hr_locations.attribute_category%TYPE,
49: attribute1 hr_locations.attribute1%TYPE,
50: attribute2 hr_locations.attribute2%TYPE,

Line 47: loc_information20 hr_locations.loc_information20%TYPE,

43: loc_information16 hr_locations.loc_information16%TYPE,
44: loc_information17 hr_locations.loc_information17%TYPE,
45: loc_information18 hr_locations.loc_information18%TYPE,
46: loc_information19 hr_locations.loc_information19%TYPE,
47: loc_information20 hr_locations.loc_information20%TYPE,
48: attribute_category hr_locations.attribute_category%TYPE,
49: attribute1 hr_locations.attribute1%TYPE,
50: attribute2 hr_locations.attribute2%TYPE,
51: attribute3 hr_locations.attribute3%TYPE,

Line 48: attribute_category hr_locations.attribute_category%TYPE,

44: loc_information17 hr_locations.loc_information17%TYPE,
45: loc_information18 hr_locations.loc_information18%TYPE,
46: loc_information19 hr_locations.loc_information19%TYPE,
47: loc_information20 hr_locations.loc_information20%TYPE,
48: attribute_category hr_locations.attribute_category%TYPE,
49: attribute1 hr_locations.attribute1%TYPE,
50: attribute2 hr_locations.attribute2%TYPE,
51: attribute3 hr_locations.attribute3%TYPE,
52: attribute4 hr_locations.attribute4%TYPE,

Line 49: attribute1 hr_locations.attribute1%TYPE,

45: loc_information18 hr_locations.loc_information18%TYPE,
46: loc_information19 hr_locations.loc_information19%TYPE,
47: loc_information20 hr_locations.loc_information20%TYPE,
48: attribute_category hr_locations.attribute_category%TYPE,
49: attribute1 hr_locations.attribute1%TYPE,
50: attribute2 hr_locations.attribute2%TYPE,
51: attribute3 hr_locations.attribute3%TYPE,
52: attribute4 hr_locations.attribute4%TYPE,
53: attribute5 hr_locations.attribute5%TYPE,

Line 50: attribute2 hr_locations.attribute2%TYPE,

46: loc_information19 hr_locations.loc_information19%TYPE,
47: loc_information20 hr_locations.loc_information20%TYPE,
48: attribute_category hr_locations.attribute_category%TYPE,
49: attribute1 hr_locations.attribute1%TYPE,
50: attribute2 hr_locations.attribute2%TYPE,
51: attribute3 hr_locations.attribute3%TYPE,
52: attribute4 hr_locations.attribute4%TYPE,
53: attribute5 hr_locations.attribute5%TYPE,
54: attribute6 hr_locations.attribute6%TYPE,

Line 51: attribute3 hr_locations.attribute3%TYPE,

47: loc_information20 hr_locations.loc_information20%TYPE,
48: attribute_category hr_locations.attribute_category%TYPE,
49: attribute1 hr_locations.attribute1%TYPE,
50: attribute2 hr_locations.attribute2%TYPE,
51: attribute3 hr_locations.attribute3%TYPE,
52: attribute4 hr_locations.attribute4%TYPE,
53: attribute5 hr_locations.attribute5%TYPE,
54: attribute6 hr_locations.attribute6%TYPE,
55: attribute7 hr_locations.attribute7%TYPE,

Line 52: attribute4 hr_locations.attribute4%TYPE,

48: attribute_category hr_locations.attribute_category%TYPE,
49: attribute1 hr_locations.attribute1%TYPE,
50: attribute2 hr_locations.attribute2%TYPE,
51: attribute3 hr_locations.attribute3%TYPE,
52: attribute4 hr_locations.attribute4%TYPE,
53: attribute5 hr_locations.attribute5%TYPE,
54: attribute6 hr_locations.attribute6%TYPE,
55: attribute7 hr_locations.attribute7%TYPE,
56: attribute8 hr_locations.attribute8%TYPE,

Line 53: attribute5 hr_locations.attribute5%TYPE,

49: attribute1 hr_locations.attribute1%TYPE,
50: attribute2 hr_locations.attribute2%TYPE,
51: attribute3 hr_locations.attribute3%TYPE,
52: attribute4 hr_locations.attribute4%TYPE,
53: attribute5 hr_locations.attribute5%TYPE,
54: attribute6 hr_locations.attribute6%TYPE,
55: attribute7 hr_locations.attribute7%TYPE,
56: attribute8 hr_locations.attribute8%TYPE,
57: attribute9 hr_locations.attribute9%TYPE,

Line 54: attribute6 hr_locations.attribute6%TYPE,

50: attribute2 hr_locations.attribute2%TYPE,
51: attribute3 hr_locations.attribute3%TYPE,
52: attribute4 hr_locations.attribute4%TYPE,
53: attribute5 hr_locations.attribute5%TYPE,
54: attribute6 hr_locations.attribute6%TYPE,
55: attribute7 hr_locations.attribute7%TYPE,
56: attribute8 hr_locations.attribute8%TYPE,
57: attribute9 hr_locations.attribute9%TYPE,
58: attribute10 hr_locations.attribute10%TYPE,

Line 55: attribute7 hr_locations.attribute7%TYPE,

51: attribute3 hr_locations.attribute3%TYPE,
52: attribute4 hr_locations.attribute4%TYPE,
53: attribute5 hr_locations.attribute5%TYPE,
54: attribute6 hr_locations.attribute6%TYPE,
55: attribute7 hr_locations.attribute7%TYPE,
56: attribute8 hr_locations.attribute8%TYPE,
57: attribute9 hr_locations.attribute9%TYPE,
58: attribute10 hr_locations.attribute10%TYPE,
59: attribute11 hr_locations.attribute11%TYPE,

Line 56: attribute8 hr_locations.attribute8%TYPE,

52: attribute4 hr_locations.attribute4%TYPE,
53: attribute5 hr_locations.attribute5%TYPE,
54: attribute6 hr_locations.attribute6%TYPE,
55: attribute7 hr_locations.attribute7%TYPE,
56: attribute8 hr_locations.attribute8%TYPE,
57: attribute9 hr_locations.attribute9%TYPE,
58: attribute10 hr_locations.attribute10%TYPE,
59: attribute11 hr_locations.attribute11%TYPE,
60: attribute12 hr_locations.attribute12%TYPE,

Line 57: attribute9 hr_locations.attribute9%TYPE,

53: attribute5 hr_locations.attribute5%TYPE,
54: attribute6 hr_locations.attribute6%TYPE,
55: attribute7 hr_locations.attribute7%TYPE,
56: attribute8 hr_locations.attribute8%TYPE,
57: attribute9 hr_locations.attribute9%TYPE,
58: attribute10 hr_locations.attribute10%TYPE,
59: attribute11 hr_locations.attribute11%TYPE,
60: attribute12 hr_locations.attribute12%TYPE,
61: attribute13 hr_locations.attribute13%TYPE,

Line 58: attribute10 hr_locations.attribute10%TYPE,

54: attribute6 hr_locations.attribute6%TYPE,
55: attribute7 hr_locations.attribute7%TYPE,
56: attribute8 hr_locations.attribute8%TYPE,
57: attribute9 hr_locations.attribute9%TYPE,
58: attribute10 hr_locations.attribute10%TYPE,
59: attribute11 hr_locations.attribute11%TYPE,
60: attribute12 hr_locations.attribute12%TYPE,
61: attribute13 hr_locations.attribute13%TYPE,
62: attribute14 hr_locations.attribute14%TYPE,

Line 59: attribute11 hr_locations.attribute11%TYPE,

55: attribute7 hr_locations.attribute7%TYPE,
56: attribute8 hr_locations.attribute8%TYPE,
57: attribute9 hr_locations.attribute9%TYPE,
58: attribute10 hr_locations.attribute10%TYPE,
59: attribute11 hr_locations.attribute11%TYPE,
60: attribute12 hr_locations.attribute12%TYPE,
61: attribute13 hr_locations.attribute13%TYPE,
62: attribute14 hr_locations.attribute14%TYPE,
63: attribute15 hr_locations.attribute15%TYPE,

Line 60: attribute12 hr_locations.attribute12%TYPE,

56: attribute8 hr_locations.attribute8%TYPE,
57: attribute9 hr_locations.attribute9%TYPE,
58: attribute10 hr_locations.attribute10%TYPE,
59: attribute11 hr_locations.attribute11%TYPE,
60: attribute12 hr_locations.attribute12%TYPE,
61: attribute13 hr_locations.attribute13%TYPE,
62: attribute14 hr_locations.attribute14%TYPE,
63: attribute15 hr_locations.attribute15%TYPE,
64: attribute16 hr_locations.attribute16%TYPE,

Line 61: attribute13 hr_locations.attribute13%TYPE,

57: attribute9 hr_locations.attribute9%TYPE,
58: attribute10 hr_locations.attribute10%TYPE,
59: attribute11 hr_locations.attribute11%TYPE,
60: attribute12 hr_locations.attribute12%TYPE,
61: attribute13 hr_locations.attribute13%TYPE,
62: attribute14 hr_locations.attribute14%TYPE,
63: attribute15 hr_locations.attribute15%TYPE,
64: attribute16 hr_locations.attribute16%TYPE,
65: attribute17 hr_locations.attribute17%TYPE,

Line 62: attribute14 hr_locations.attribute14%TYPE,

58: attribute10 hr_locations.attribute10%TYPE,
59: attribute11 hr_locations.attribute11%TYPE,
60: attribute12 hr_locations.attribute12%TYPE,
61: attribute13 hr_locations.attribute13%TYPE,
62: attribute14 hr_locations.attribute14%TYPE,
63: attribute15 hr_locations.attribute15%TYPE,
64: attribute16 hr_locations.attribute16%TYPE,
65: attribute17 hr_locations.attribute17%TYPE,
66: attribute18 hr_locations.attribute18%TYPE,

Line 63: attribute15 hr_locations.attribute15%TYPE,

59: attribute11 hr_locations.attribute11%TYPE,
60: attribute12 hr_locations.attribute12%TYPE,
61: attribute13 hr_locations.attribute13%TYPE,
62: attribute14 hr_locations.attribute14%TYPE,
63: attribute15 hr_locations.attribute15%TYPE,
64: attribute16 hr_locations.attribute16%TYPE,
65: attribute17 hr_locations.attribute17%TYPE,
66: attribute18 hr_locations.attribute18%TYPE,
67: attribute19 hr_locations.attribute19%TYPE,

Line 64: attribute16 hr_locations.attribute16%TYPE,

60: attribute12 hr_locations.attribute12%TYPE,
61: attribute13 hr_locations.attribute13%TYPE,
62: attribute14 hr_locations.attribute14%TYPE,
63: attribute15 hr_locations.attribute15%TYPE,
64: attribute16 hr_locations.attribute16%TYPE,
65: attribute17 hr_locations.attribute17%TYPE,
66: attribute18 hr_locations.attribute18%TYPE,
67: attribute19 hr_locations.attribute19%TYPE,
68: attribute20 hr_locations.attribute20%TYPE,

Line 65: attribute17 hr_locations.attribute17%TYPE,

61: attribute13 hr_locations.attribute13%TYPE,
62: attribute14 hr_locations.attribute14%TYPE,
63: attribute15 hr_locations.attribute15%TYPE,
64: attribute16 hr_locations.attribute16%TYPE,
65: attribute17 hr_locations.attribute17%TYPE,
66: attribute18 hr_locations.attribute18%TYPE,
67: attribute19 hr_locations.attribute19%TYPE,
68: attribute20 hr_locations.attribute20%TYPE,
69: global_attribute_category hr_locations.global_attribute_category%TYPE,

Line 66: attribute18 hr_locations.attribute18%TYPE,

62: attribute14 hr_locations.attribute14%TYPE,
63: attribute15 hr_locations.attribute15%TYPE,
64: attribute16 hr_locations.attribute16%TYPE,
65: attribute17 hr_locations.attribute17%TYPE,
66: attribute18 hr_locations.attribute18%TYPE,
67: attribute19 hr_locations.attribute19%TYPE,
68: attribute20 hr_locations.attribute20%TYPE,
69: global_attribute_category hr_locations.global_attribute_category%TYPE,
70: global_attribute1 hr_locations.global_attribute1%TYPE,

Line 67: attribute19 hr_locations.attribute19%TYPE,

63: attribute15 hr_locations.attribute15%TYPE,
64: attribute16 hr_locations.attribute16%TYPE,
65: attribute17 hr_locations.attribute17%TYPE,
66: attribute18 hr_locations.attribute18%TYPE,
67: attribute19 hr_locations.attribute19%TYPE,
68: attribute20 hr_locations.attribute20%TYPE,
69: global_attribute_category hr_locations.global_attribute_category%TYPE,
70: global_attribute1 hr_locations.global_attribute1%TYPE,
71: global_attribute2 hr_locations.global_attribute2%TYPE,

Line 68: attribute20 hr_locations.attribute20%TYPE,

64: attribute16 hr_locations.attribute16%TYPE,
65: attribute17 hr_locations.attribute17%TYPE,
66: attribute18 hr_locations.attribute18%TYPE,
67: attribute19 hr_locations.attribute19%TYPE,
68: attribute20 hr_locations.attribute20%TYPE,
69: global_attribute_category hr_locations.global_attribute_category%TYPE,
70: global_attribute1 hr_locations.global_attribute1%TYPE,
71: global_attribute2 hr_locations.global_attribute2%TYPE,
72: global_attribute3 hr_locations.global_attribute3%TYPE,

Line 69: global_attribute_category hr_locations.global_attribute_category%TYPE,

65: attribute17 hr_locations.attribute17%TYPE,
66: attribute18 hr_locations.attribute18%TYPE,
67: attribute19 hr_locations.attribute19%TYPE,
68: attribute20 hr_locations.attribute20%TYPE,
69: global_attribute_category hr_locations.global_attribute_category%TYPE,
70: global_attribute1 hr_locations.global_attribute1%TYPE,
71: global_attribute2 hr_locations.global_attribute2%TYPE,
72: global_attribute3 hr_locations.global_attribute3%TYPE,
73: global_attribute4 hr_locations.global_attribute4%TYPE,

Line 70: global_attribute1 hr_locations.global_attribute1%TYPE,

66: attribute18 hr_locations.attribute18%TYPE,
67: attribute19 hr_locations.attribute19%TYPE,
68: attribute20 hr_locations.attribute20%TYPE,
69: global_attribute_category hr_locations.global_attribute_category%TYPE,
70: global_attribute1 hr_locations.global_attribute1%TYPE,
71: global_attribute2 hr_locations.global_attribute2%TYPE,
72: global_attribute3 hr_locations.global_attribute3%TYPE,
73: global_attribute4 hr_locations.global_attribute4%TYPE,
74: global_attribute5 hr_locations.global_attribute5%TYPE,

Line 71: global_attribute2 hr_locations.global_attribute2%TYPE,

67: attribute19 hr_locations.attribute19%TYPE,
68: attribute20 hr_locations.attribute20%TYPE,
69: global_attribute_category hr_locations.global_attribute_category%TYPE,
70: global_attribute1 hr_locations.global_attribute1%TYPE,
71: global_attribute2 hr_locations.global_attribute2%TYPE,
72: global_attribute3 hr_locations.global_attribute3%TYPE,
73: global_attribute4 hr_locations.global_attribute4%TYPE,
74: global_attribute5 hr_locations.global_attribute5%TYPE,
75: global_attribute6 hr_locations.global_attribute6%TYPE,

Line 72: global_attribute3 hr_locations.global_attribute3%TYPE,

68: attribute20 hr_locations.attribute20%TYPE,
69: global_attribute_category hr_locations.global_attribute_category%TYPE,
70: global_attribute1 hr_locations.global_attribute1%TYPE,
71: global_attribute2 hr_locations.global_attribute2%TYPE,
72: global_attribute3 hr_locations.global_attribute3%TYPE,
73: global_attribute4 hr_locations.global_attribute4%TYPE,
74: global_attribute5 hr_locations.global_attribute5%TYPE,
75: global_attribute6 hr_locations.global_attribute6%TYPE,
76: global_attribute7 hr_locations.global_attribute7%TYPE,

Line 73: global_attribute4 hr_locations.global_attribute4%TYPE,

69: global_attribute_category hr_locations.global_attribute_category%TYPE,
70: global_attribute1 hr_locations.global_attribute1%TYPE,
71: global_attribute2 hr_locations.global_attribute2%TYPE,
72: global_attribute3 hr_locations.global_attribute3%TYPE,
73: global_attribute4 hr_locations.global_attribute4%TYPE,
74: global_attribute5 hr_locations.global_attribute5%TYPE,
75: global_attribute6 hr_locations.global_attribute6%TYPE,
76: global_attribute7 hr_locations.global_attribute7%TYPE,
77: global_attribute8 hr_locations.global_attribute8%TYPE,

Line 74: global_attribute5 hr_locations.global_attribute5%TYPE,

70: global_attribute1 hr_locations.global_attribute1%TYPE,
71: global_attribute2 hr_locations.global_attribute2%TYPE,
72: global_attribute3 hr_locations.global_attribute3%TYPE,
73: global_attribute4 hr_locations.global_attribute4%TYPE,
74: global_attribute5 hr_locations.global_attribute5%TYPE,
75: global_attribute6 hr_locations.global_attribute6%TYPE,
76: global_attribute7 hr_locations.global_attribute7%TYPE,
77: global_attribute8 hr_locations.global_attribute8%TYPE,
78: global_attribute9 hr_locations.global_attribute9%TYPE,

Line 75: global_attribute6 hr_locations.global_attribute6%TYPE,

71: global_attribute2 hr_locations.global_attribute2%TYPE,
72: global_attribute3 hr_locations.global_attribute3%TYPE,
73: global_attribute4 hr_locations.global_attribute4%TYPE,
74: global_attribute5 hr_locations.global_attribute5%TYPE,
75: global_attribute6 hr_locations.global_attribute6%TYPE,
76: global_attribute7 hr_locations.global_attribute7%TYPE,
77: global_attribute8 hr_locations.global_attribute8%TYPE,
78: global_attribute9 hr_locations.global_attribute9%TYPE,
79: global_attribute10 hr_locations.global_attribute10%TYPE,

Line 76: global_attribute7 hr_locations.global_attribute7%TYPE,

72: global_attribute3 hr_locations.global_attribute3%TYPE,
73: global_attribute4 hr_locations.global_attribute4%TYPE,
74: global_attribute5 hr_locations.global_attribute5%TYPE,
75: global_attribute6 hr_locations.global_attribute6%TYPE,
76: global_attribute7 hr_locations.global_attribute7%TYPE,
77: global_attribute8 hr_locations.global_attribute8%TYPE,
78: global_attribute9 hr_locations.global_attribute9%TYPE,
79: global_attribute10 hr_locations.global_attribute10%TYPE,
80: global_attribute11 hr_locations.global_attribute11%TYPE,

Line 77: global_attribute8 hr_locations.global_attribute8%TYPE,

73: global_attribute4 hr_locations.global_attribute4%TYPE,
74: global_attribute5 hr_locations.global_attribute5%TYPE,
75: global_attribute6 hr_locations.global_attribute6%TYPE,
76: global_attribute7 hr_locations.global_attribute7%TYPE,
77: global_attribute8 hr_locations.global_attribute8%TYPE,
78: global_attribute9 hr_locations.global_attribute9%TYPE,
79: global_attribute10 hr_locations.global_attribute10%TYPE,
80: global_attribute11 hr_locations.global_attribute11%TYPE,
81: global_attribute12 hr_locations.global_attribute12%TYPE,

Line 78: global_attribute9 hr_locations.global_attribute9%TYPE,

74: global_attribute5 hr_locations.global_attribute5%TYPE,
75: global_attribute6 hr_locations.global_attribute6%TYPE,
76: global_attribute7 hr_locations.global_attribute7%TYPE,
77: global_attribute8 hr_locations.global_attribute8%TYPE,
78: global_attribute9 hr_locations.global_attribute9%TYPE,
79: global_attribute10 hr_locations.global_attribute10%TYPE,
80: global_attribute11 hr_locations.global_attribute11%TYPE,
81: global_attribute12 hr_locations.global_attribute12%TYPE,
82: global_attribute13 hr_locations.global_attribute13%TYPE,

Line 79: global_attribute10 hr_locations.global_attribute10%TYPE,

75: global_attribute6 hr_locations.global_attribute6%TYPE,
76: global_attribute7 hr_locations.global_attribute7%TYPE,
77: global_attribute8 hr_locations.global_attribute8%TYPE,
78: global_attribute9 hr_locations.global_attribute9%TYPE,
79: global_attribute10 hr_locations.global_attribute10%TYPE,
80: global_attribute11 hr_locations.global_attribute11%TYPE,
81: global_attribute12 hr_locations.global_attribute12%TYPE,
82: global_attribute13 hr_locations.global_attribute13%TYPE,
83: global_attribute14 hr_locations.global_attribute14%TYPE,

Line 80: global_attribute11 hr_locations.global_attribute11%TYPE,

76: global_attribute7 hr_locations.global_attribute7%TYPE,
77: global_attribute8 hr_locations.global_attribute8%TYPE,
78: global_attribute9 hr_locations.global_attribute9%TYPE,
79: global_attribute10 hr_locations.global_attribute10%TYPE,
80: global_attribute11 hr_locations.global_attribute11%TYPE,
81: global_attribute12 hr_locations.global_attribute12%TYPE,
82: global_attribute13 hr_locations.global_attribute13%TYPE,
83: global_attribute14 hr_locations.global_attribute14%TYPE,
84: global_attribute15 hr_locations.global_attribute15%TYPE,

Line 81: global_attribute12 hr_locations.global_attribute12%TYPE,

77: global_attribute8 hr_locations.global_attribute8%TYPE,
78: global_attribute9 hr_locations.global_attribute9%TYPE,
79: global_attribute10 hr_locations.global_attribute10%TYPE,
80: global_attribute11 hr_locations.global_attribute11%TYPE,
81: global_attribute12 hr_locations.global_attribute12%TYPE,
82: global_attribute13 hr_locations.global_attribute13%TYPE,
83: global_attribute14 hr_locations.global_attribute14%TYPE,
84: global_attribute15 hr_locations.global_attribute15%TYPE,
85: global_attribute16 hr_locations.global_attribute16%TYPE,

Line 82: global_attribute13 hr_locations.global_attribute13%TYPE,

78: global_attribute9 hr_locations.global_attribute9%TYPE,
79: global_attribute10 hr_locations.global_attribute10%TYPE,
80: global_attribute11 hr_locations.global_attribute11%TYPE,
81: global_attribute12 hr_locations.global_attribute12%TYPE,
82: global_attribute13 hr_locations.global_attribute13%TYPE,
83: global_attribute14 hr_locations.global_attribute14%TYPE,
84: global_attribute15 hr_locations.global_attribute15%TYPE,
85: global_attribute16 hr_locations.global_attribute16%TYPE,
86: global_attribute17 hr_locations.global_attribute17%TYPE,

Line 83: global_attribute14 hr_locations.global_attribute14%TYPE,

79: global_attribute10 hr_locations.global_attribute10%TYPE,
80: global_attribute11 hr_locations.global_attribute11%TYPE,
81: global_attribute12 hr_locations.global_attribute12%TYPE,
82: global_attribute13 hr_locations.global_attribute13%TYPE,
83: global_attribute14 hr_locations.global_attribute14%TYPE,
84: global_attribute15 hr_locations.global_attribute15%TYPE,
85: global_attribute16 hr_locations.global_attribute16%TYPE,
86: global_attribute17 hr_locations.global_attribute17%TYPE,
87: global_attribute18 hr_locations.global_attribute18%TYPE,

Line 84: global_attribute15 hr_locations.global_attribute15%TYPE,

80: global_attribute11 hr_locations.global_attribute11%TYPE,
81: global_attribute12 hr_locations.global_attribute12%TYPE,
82: global_attribute13 hr_locations.global_attribute13%TYPE,
83: global_attribute14 hr_locations.global_attribute14%TYPE,
84: global_attribute15 hr_locations.global_attribute15%TYPE,
85: global_attribute16 hr_locations.global_attribute16%TYPE,
86: global_attribute17 hr_locations.global_attribute17%TYPE,
87: global_attribute18 hr_locations.global_attribute18%TYPE,
88: global_attribute19 hr_locations.global_attribute19%TYPE,

Line 85: global_attribute16 hr_locations.global_attribute16%TYPE,

81: global_attribute12 hr_locations.global_attribute12%TYPE,
82: global_attribute13 hr_locations.global_attribute13%TYPE,
83: global_attribute14 hr_locations.global_attribute14%TYPE,
84: global_attribute15 hr_locations.global_attribute15%TYPE,
85: global_attribute16 hr_locations.global_attribute16%TYPE,
86: global_attribute17 hr_locations.global_attribute17%TYPE,
87: global_attribute18 hr_locations.global_attribute18%TYPE,
88: global_attribute19 hr_locations.global_attribute19%TYPE,
89: global_attribute20 hr_locations.global_attribute20%TYPE,

Line 86: global_attribute17 hr_locations.global_attribute17%TYPE,

82: global_attribute13 hr_locations.global_attribute13%TYPE,
83: global_attribute14 hr_locations.global_attribute14%TYPE,
84: global_attribute15 hr_locations.global_attribute15%TYPE,
85: global_attribute16 hr_locations.global_attribute16%TYPE,
86: global_attribute17 hr_locations.global_attribute17%TYPE,
87: global_attribute18 hr_locations.global_attribute18%TYPE,
88: global_attribute19 hr_locations.global_attribute19%TYPE,
89: global_attribute20 hr_locations.global_attribute20%TYPE,
90: last_update_date hr_locations.last_update_date%TYPE,

Line 87: global_attribute18 hr_locations.global_attribute18%TYPE,

83: global_attribute14 hr_locations.global_attribute14%TYPE,
84: global_attribute15 hr_locations.global_attribute15%TYPE,
85: global_attribute16 hr_locations.global_attribute16%TYPE,
86: global_attribute17 hr_locations.global_attribute17%TYPE,
87: global_attribute18 hr_locations.global_attribute18%TYPE,
88: global_attribute19 hr_locations.global_attribute19%TYPE,
89: global_attribute20 hr_locations.global_attribute20%TYPE,
90: last_update_date hr_locations.last_update_date%TYPE,
91: last_updated_by hr_locations.last_updated_by%TYPE,

Line 88: global_attribute19 hr_locations.global_attribute19%TYPE,

84: global_attribute15 hr_locations.global_attribute15%TYPE,
85: global_attribute16 hr_locations.global_attribute16%TYPE,
86: global_attribute17 hr_locations.global_attribute17%TYPE,
87: global_attribute18 hr_locations.global_attribute18%TYPE,
88: global_attribute19 hr_locations.global_attribute19%TYPE,
89: global_attribute20 hr_locations.global_attribute20%TYPE,
90: last_update_date hr_locations.last_update_date%TYPE,
91: last_updated_by hr_locations.last_updated_by%TYPE,
92: last_update_login hr_locations.last_update_login%TYPE,

Line 89: global_attribute20 hr_locations.global_attribute20%TYPE,

85: global_attribute16 hr_locations.global_attribute16%TYPE,
86: global_attribute17 hr_locations.global_attribute17%TYPE,
87: global_attribute18 hr_locations.global_attribute18%TYPE,
88: global_attribute19 hr_locations.global_attribute19%TYPE,
89: global_attribute20 hr_locations.global_attribute20%TYPE,
90: last_update_date hr_locations.last_update_date%TYPE,
91: last_updated_by hr_locations.last_updated_by%TYPE,
92: last_update_login hr_locations.last_update_login%TYPE,
93: created_by hr_locations.created_by%TYPE,

Line 90: last_update_date hr_locations.last_update_date%TYPE,

86: global_attribute17 hr_locations.global_attribute17%TYPE,
87: global_attribute18 hr_locations.global_attribute18%TYPE,
88: global_attribute19 hr_locations.global_attribute19%TYPE,
89: global_attribute20 hr_locations.global_attribute20%TYPE,
90: last_update_date hr_locations.last_update_date%TYPE,
91: last_updated_by hr_locations.last_updated_by%TYPE,
92: last_update_login hr_locations.last_update_login%TYPE,
93: created_by hr_locations.created_by%TYPE,
94: creation_date hr_locations.creation_date%TYPE,

Line 91: last_updated_by hr_locations.last_updated_by%TYPE,

87: global_attribute18 hr_locations.global_attribute18%TYPE,
88: global_attribute19 hr_locations.global_attribute19%TYPE,
89: global_attribute20 hr_locations.global_attribute20%TYPE,
90: last_update_date hr_locations.last_update_date%TYPE,
91: last_updated_by hr_locations.last_updated_by%TYPE,
92: last_update_login hr_locations.last_update_login%TYPE,
93: created_by hr_locations.created_by%TYPE,
94: creation_date hr_locations.creation_date%TYPE,
95: entered_by hr_locations.entered_by%TYPE,

Line 92: last_update_login hr_locations.last_update_login%TYPE,

88: global_attribute19 hr_locations.global_attribute19%TYPE,
89: global_attribute20 hr_locations.global_attribute20%TYPE,
90: last_update_date hr_locations.last_update_date%TYPE,
91: last_updated_by hr_locations.last_updated_by%TYPE,
92: last_update_login hr_locations.last_update_login%TYPE,
93: created_by hr_locations.created_by%TYPE,
94: creation_date hr_locations.creation_date%TYPE,
95: entered_by hr_locations.entered_by%TYPE,
96: tp_header_id hr_locations.tp_header_id%TYPE,

Line 93: created_by hr_locations.created_by%TYPE,

89: global_attribute20 hr_locations.global_attribute20%TYPE,
90: last_update_date hr_locations.last_update_date%TYPE,
91: last_updated_by hr_locations.last_updated_by%TYPE,
92: last_update_login hr_locations.last_update_login%TYPE,
93: created_by hr_locations.created_by%TYPE,
94: creation_date hr_locations.creation_date%TYPE,
95: entered_by hr_locations.entered_by%TYPE,
96: tp_header_id hr_locations.tp_header_id%TYPE,
97: ece_tp_location_code hr_locations.ece_tp_location_code%TYPE,

Line 94: creation_date hr_locations.creation_date%TYPE,

90: last_update_date hr_locations.last_update_date%TYPE,
91: last_updated_by hr_locations.last_updated_by%TYPE,
92: last_update_login hr_locations.last_update_login%TYPE,
93: created_by hr_locations.created_by%TYPE,
94: creation_date hr_locations.creation_date%TYPE,
95: entered_by hr_locations.entered_by%TYPE,
96: tp_header_id hr_locations.tp_header_id%TYPE,
97: ece_tp_location_code hr_locations.ece_tp_location_code%TYPE,
98: object_version_number hr_locations.object_version_number%TYPE,

Line 95: entered_by hr_locations.entered_by%TYPE,

91: last_updated_by hr_locations.last_updated_by%TYPE,
92: last_update_login hr_locations.last_update_login%TYPE,
93: created_by hr_locations.created_by%TYPE,
94: creation_date hr_locations.creation_date%TYPE,
95: entered_by hr_locations.entered_by%TYPE,
96: tp_header_id hr_locations.tp_header_id%TYPE,
97: ece_tp_location_code hr_locations.ece_tp_location_code%TYPE,
98: object_version_number hr_locations.object_version_number%TYPE,
99: legal_address_flag hr_locations.legal_address_flag%TYPE,

Line 96: tp_header_id hr_locations.tp_header_id%TYPE,

92: last_update_login hr_locations.last_update_login%TYPE,
93: created_by hr_locations.created_by%TYPE,
94: creation_date hr_locations.creation_date%TYPE,
95: entered_by hr_locations.entered_by%TYPE,
96: tp_header_id hr_locations.tp_header_id%TYPE,
97: ece_tp_location_code hr_locations.ece_tp_location_code%TYPE,
98: object_version_number hr_locations.object_version_number%TYPE,
99: legal_address_flag hr_locations.legal_address_flag%TYPE,
100: timezone_code hr_locations.timezone_code%TYPE

Line 97: ece_tp_location_code hr_locations.ece_tp_location_code%TYPE,

93: created_by hr_locations.created_by%TYPE,
94: creation_date hr_locations.creation_date%TYPE,
95: entered_by hr_locations.entered_by%TYPE,
96: tp_header_id hr_locations.tp_header_id%TYPE,
97: ece_tp_location_code hr_locations.ece_tp_location_code%TYPE,
98: object_version_number hr_locations.object_version_number%TYPE,
99: legal_address_flag hr_locations.legal_address_flag%TYPE,
100: timezone_code hr_locations.timezone_code%TYPE
101: );

Line 98: object_version_number hr_locations.object_version_number%TYPE,

94: creation_date hr_locations.creation_date%TYPE,
95: entered_by hr_locations.entered_by%TYPE,
96: tp_header_id hr_locations.tp_header_id%TYPE,
97: ece_tp_location_code hr_locations.ece_tp_location_code%TYPE,
98: object_version_number hr_locations.object_version_number%TYPE,
99: legal_address_flag hr_locations.legal_address_flag%TYPE,
100: timezone_code hr_locations.timezone_code%TYPE
101: );
102:

Line 99: legal_address_flag hr_locations.legal_address_flag%TYPE,

95: entered_by hr_locations.entered_by%TYPE,
96: tp_header_id hr_locations.tp_header_id%TYPE,
97: ece_tp_location_code hr_locations.ece_tp_location_code%TYPE,
98: object_version_number hr_locations.object_version_number%TYPE,
99: legal_address_flag hr_locations.legal_address_flag%TYPE,
100: timezone_code hr_locations.timezone_code%TYPE
101: );
102:
103: TYPE location_tabletype IS TABLE OF location_rectype NOT NULL;

Line 100: timezone_code hr_locations.timezone_code%TYPE

96: tp_header_id hr_locations.tp_header_id%TYPE,
97: ece_tp_location_code hr_locations.ece_tp_location_code%TYPE,
98: object_version_number hr_locations.object_version_number%TYPE,
99: legal_address_flag hr_locations.legal_address_flag%TYPE,
100: timezone_code hr_locations.timezone_code%TYPE
101: );
102:
103: TYPE location_tabletype IS TABLE OF location_rectype NOT NULL;
104:

Line 107: location_id hr_locations.location_id%TYPE DEFAULT NULL,

103: TYPE location_tabletype IS TABLE OF location_rectype NOT NULL;
104:
105: TYPE location_input_rectype IS RECORD
106: (
107: location_id hr_locations.location_id%TYPE DEFAULT NULL,
108: start_location_id hr_locations.location_id%TYPE DEFAULT NULL,
109: end_location_id hr_locations.location_id%TYPE DEFAULT NULL,
110: business_group_id hr_locations.business_group_id%TYPE DEFAULT NULL
111: );

Line 108: start_location_id hr_locations.location_id%TYPE DEFAULT NULL,

104:
105: TYPE location_input_rectype IS RECORD
106: (
107: location_id hr_locations.location_id%TYPE DEFAULT NULL,
108: start_location_id hr_locations.location_id%TYPE DEFAULT NULL,
109: end_location_id hr_locations.location_id%TYPE DEFAULT NULL,
110: business_group_id hr_locations.business_group_id%TYPE DEFAULT NULL
111: );
112:

Line 109: end_location_id hr_locations.location_id%TYPE DEFAULT NULL,

105: TYPE location_input_rectype IS RECORD
106: (
107: location_id hr_locations.location_id%TYPE DEFAULT NULL,
108: start_location_id hr_locations.location_id%TYPE DEFAULT NULL,
109: end_location_id hr_locations.location_id%TYPE DEFAULT NULL,
110: business_group_id hr_locations.business_group_id%TYPE DEFAULT NULL
111: );
112:
113: /*#

Line 110: business_group_id hr_locations.business_group_id%TYPE DEFAULT NULL

106: (
107: location_id hr_locations.location_id%TYPE DEFAULT NULL,
108: start_location_id hr_locations.location_id%TYPE DEFAULT NULL,
109: end_location_id hr_locations.location_id%TYPE DEFAULT NULL,
110: business_group_id hr_locations.business_group_id%TYPE DEFAULT NULL
111: );
112:
113: /*#
114: * This is procedure for querying location details.