16: l_location_rec hr_locations_all%rowtype;
17: Begin
18: hr_utility.set_location('Entering Default Rec' , 25);
19:
20: l_location_rec.LOCATION_CODE := hr_api.g_varchar2;
21: l_location_rec.ADDRESS_LINE_1 := hr_api.g_varchar2;
22: l_location_rec.ADDRESS_LINE_2 := hr_api.g_varchar2;
23: l_location_rec.ADDRESS_LINE_3 := hr_api.g_varchar2;
24: l_location_rec.BILL_TO_SITE_FLAG := hr_api.g_varchar2;
17: Begin
18: hr_utility.set_location('Entering Default Rec' , 25);
19:
20: l_location_rec.LOCATION_CODE := hr_api.g_varchar2;
21: l_location_rec.ADDRESS_LINE_1 := hr_api.g_varchar2;
22: l_location_rec.ADDRESS_LINE_2 := hr_api.g_varchar2;
23: l_location_rec.ADDRESS_LINE_3 := hr_api.g_varchar2;
24: l_location_rec.BILL_TO_SITE_FLAG := hr_api.g_varchar2;
25: l_location_rec.COUNTRY := hr_api.g_varchar2;
18: hr_utility.set_location('Entering Default Rec' , 25);
19:
20: l_location_rec.LOCATION_CODE := hr_api.g_varchar2;
21: l_location_rec.ADDRESS_LINE_1 := hr_api.g_varchar2;
22: l_location_rec.ADDRESS_LINE_2 := hr_api.g_varchar2;
23: l_location_rec.ADDRESS_LINE_3 := hr_api.g_varchar2;
24: l_location_rec.BILL_TO_SITE_FLAG := hr_api.g_varchar2;
25: l_location_rec.COUNTRY := hr_api.g_varchar2;
26: l_location_rec.DESCRIPTION := hr_api.g_varchar2;
19:
20: l_location_rec.LOCATION_CODE := hr_api.g_varchar2;
21: l_location_rec.ADDRESS_LINE_1 := hr_api.g_varchar2;
22: l_location_rec.ADDRESS_LINE_2 := hr_api.g_varchar2;
23: l_location_rec.ADDRESS_LINE_3 := hr_api.g_varchar2;
24: l_location_rec.BILL_TO_SITE_FLAG := hr_api.g_varchar2;
25: l_location_rec.COUNTRY := hr_api.g_varchar2;
26: l_location_rec.DESCRIPTION := hr_api.g_varchar2;
27: l_location_rec.DESIGNATED_RECEIVER_ID := hr_api.g_number;
20: l_location_rec.LOCATION_CODE := hr_api.g_varchar2;
21: l_location_rec.ADDRESS_LINE_1 := hr_api.g_varchar2;
22: l_location_rec.ADDRESS_LINE_2 := hr_api.g_varchar2;
23: l_location_rec.ADDRESS_LINE_3 := hr_api.g_varchar2;
24: l_location_rec.BILL_TO_SITE_FLAG := hr_api.g_varchar2;
25: l_location_rec.COUNTRY := hr_api.g_varchar2;
26: l_location_rec.DESCRIPTION := hr_api.g_varchar2;
27: l_location_rec.DESIGNATED_RECEIVER_ID := hr_api.g_number;
28: l_location_rec.IN_ORGANIZATION_FLAG := hr_api.g_varchar2;
21: l_location_rec.ADDRESS_LINE_1 := hr_api.g_varchar2;
22: l_location_rec.ADDRESS_LINE_2 := hr_api.g_varchar2;
23: l_location_rec.ADDRESS_LINE_3 := hr_api.g_varchar2;
24: l_location_rec.BILL_TO_SITE_FLAG := hr_api.g_varchar2;
25: l_location_rec.COUNTRY := hr_api.g_varchar2;
26: l_location_rec.DESCRIPTION := hr_api.g_varchar2;
27: l_location_rec.DESIGNATED_RECEIVER_ID := hr_api.g_number;
28: l_location_rec.IN_ORGANIZATION_FLAG := hr_api.g_varchar2;
29: l_location_rec.INACTIVE_DATE := hr_api.g_date;
22: l_location_rec.ADDRESS_LINE_2 := hr_api.g_varchar2;
23: l_location_rec.ADDRESS_LINE_3 := hr_api.g_varchar2;
24: l_location_rec.BILL_TO_SITE_FLAG := hr_api.g_varchar2;
25: l_location_rec.COUNTRY := hr_api.g_varchar2;
26: l_location_rec.DESCRIPTION := hr_api.g_varchar2;
27: l_location_rec.DESIGNATED_RECEIVER_ID := hr_api.g_number;
28: l_location_rec.IN_ORGANIZATION_FLAG := hr_api.g_varchar2;
29: l_location_rec.INACTIVE_DATE := hr_api.g_date;
30: l_location_rec.INVENTORY_ORGANIZATION_ID := hr_api.g_number;
23: l_location_rec.ADDRESS_LINE_3 := hr_api.g_varchar2;
24: l_location_rec.BILL_TO_SITE_FLAG := hr_api.g_varchar2;
25: l_location_rec.COUNTRY := hr_api.g_varchar2;
26: l_location_rec.DESCRIPTION := hr_api.g_varchar2;
27: l_location_rec.DESIGNATED_RECEIVER_ID := hr_api.g_number;
28: l_location_rec.IN_ORGANIZATION_FLAG := hr_api.g_varchar2;
29: l_location_rec.INACTIVE_DATE := hr_api.g_date;
30: l_location_rec.INVENTORY_ORGANIZATION_ID := hr_api.g_number;
31: l_location_rec.OFFICE_SITE_FLAG := hr_api.g_varchar2;
24: l_location_rec.BILL_TO_SITE_FLAG := hr_api.g_varchar2;
25: l_location_rec.COUNTRY := hr_api.g_varchar2;
26: l_location_rec.DESCRIPTION := hr_api.g_varchar2;
27: l_location_rec.DESIGNATED_RECEIVER_ID := hr_api.g_number;
28: l_location_rec.IN_ORGANIZATION_FLAG := hr_api.g_varchar2;
29: l_location_rec.INACTIVE_DATE := hr_api.g_date;
30: l_location_rec.INVENTORY_ORGANIZATION_ID := hr_api.g_number;
31: l_location_rec.OFFICE_SITE_FLAG := hr_api.g_varchar2;
32: l_location_rec.POSTAL_CODE := hr_api.g_varchar2;
25: l_location_rec.COUNTRY := hr_api.g_varchar2;
26: l_location_rec.DESCRIPTION := hr_api.g_varchar2;
27: l_location_rec.DESIGNATED_RECEIVER_ID := hr_api.g_number;
28: l_location_rec.IN_ORGANIZATION_FLAG := hr_api.g_varchar2;
29: l_location_rec.INACTIVE_DATE := hr_api.g_date;
30: l_location_rec.INVENTORY_ORGANIZATION_ID := hr_api.g_number;
31: l_location_rec.OFFICE_SITE_FLAG := hr_api.g_varchar2;
32: l_location_rec.POSTAL_CODE := hr_api.g_varchar2;
33: l_location_rec.RECEIVING_SITE_FLAG := hr_api.g_varchar2;
26: l_location_rec.DESCRIPTION := hr_api.g_varchar2;
27: l_location_rec.DESIGNATED_RECEIVER_ID := hr_api.g_number;
28: l_location_rec.IN_ORGANIZATION_FLAG := hr_api.g_varchar2;
29: l_location_rec.INACTIVE_DATE := hr_api.g_date;
30: l_location_rec.INVENTORY_ORGANIZATION_ID := hr_api.g_number;
31: l_location_rec.OFFICE_SITE_FLAG := hr_api.g_varchar2;
32: l_location_rec.POSTAL_CODE := hr_api.g_varchar2;
33: l_location_rec.RECEIVING_SITE_FLAG := hr_api.g_varchar2;
34: l_location_rec.REGION_1 := hr_api.g_varchar2;
27: l_location_rec.DESIGNATED_RECEIVER_ID := hr_api.g_number;
28: l_location_rec.IN_ORGANIZATION_FLAG := hr_api.g_varchar2;
29: l_location_rec.INACTIVE_DATE := hr_api.g_date;
30: l_location_rec.INVENTORY_ORGANIZATION_ID := hr_api.g_number;
31: l_location_rec.OFFICE_SITE_FLAG := hr_api.g_varchar2;
32: l_location_rec.POSTAL_CODE := hr_api.g_varchar2;
33: l_location_rec.RECEIVING_SITE_FLAG := hr_api.g_varchar2;
34: l_location_rec.REGION_1 := hr_api.g_varchar2;
35: l_location_rec.REGION_2 := hr_api.g_varchar2;
28: l_location_rec.IN_ORGANIZATION_FLAG := hr_api.g_varchar2;
29: l_location_rec.INACTIVE_DATE := hr_api.g_date;
30: l_location_rec.INVENTORY_ORGANIZATION_ID := hr_api.g_number;
31: l_location_rec.OFFICE_SITE_FLAG := hr_api.g_varchar2;
32: l_location_rec.POSTAL_CODE := hr_api.g_varchar2;
33: l_location_rec.RECEIVING_SITE_FLAG := hr_api.g_varchar2;
34: l_location_rec.REGION_1 := hr_api.g_varchar2;
35: l_location_rec.REGION_2 := hr_api.g_varchar2;
36: l_location_rec.REGION_3 := hr_api.g_varchar2;
29: l_location_rec.INACTIVE_DATE := hr_api.g_date;
30: l_location_rec.INVENTORY_ORGANIZATION_ID := hr_api.g_number;
31: l_location_rec.OFFICE_SITE_FLAG := hr_api.g_varchar2;
32: l_location_rec.POSTAL_CODE := hr_api.g_varchar2;
33: l_location_rec.RECEIVING_SITE_FLAG := hr_api.g_varchar2;
34: l_location_rec.REGION_1 := hr_api.g_varchar2;
35: l_location_rec.REGION_2 := hr_api.g_varchar2;
36: l_location_rec.REGION_3 := hr_api.g_varchar2;
37: l_location_rec.SHIP_TO_LOCATION_ID := hr_api.g_number;
30: l_location_rec.INVENTORY_ORGANIZATION_ID := hr_api.g_number;
31: l_location_rec.OFFICE_SITE_FLAG := hr_api.g_varchar2;
32: l_location_rec.POSTAL_CODE := hr_api.g_varchar2;
33: l_location_rec.RECEIVING_SITE_FLAG := hr_api.g_varchar2;
34: l_location_rec.REGION_1 := hr_api.g_varchar2;
35: l_location_rec.REGION_2 := hr_api.g_varchar2;
36: l_location_rec.REGION_3 := hr_api.g_varchar2;
37: l_location_rec.SHIP_TO_LOCATION_ID := hr_api.g_number;
38: l_location_rec.SHIP_TO_SITE_FLAG := hr_api.g_varchar2;
31: l_location_rec.OFFICE_SITE_FLAG := hr_api.g_varchar2;
32: l_location_rec.POSTAL_CODE := hr_api.g_varchar2;
33: l_location_rec.RECEIVING_SITE_FLAG := hr_api.g_varchar2;
34: l_location_rec.REGION_1 := hr_api.g_varchar2;
35: l_location_rec.REGION_2 := hr_api.g_varchar2;
36: l_location_rec.REGION_3 := hr_api.g_varchar2;
37: l_location_rec.SHIP_TO_LOCATION_ID := hr_api.g_number;
38: l_location_rec.SHIP_TO_SITE_FLAG := hr_api.g_varchar2;
39: l_location_rec.STYLE := g_style;
32: l_location_rec.POSTAL_CODE := hr_api.g_varchar2;
33: l_location_rec.RECEIVING_SITE_FLAG := hr_api.g_varchar2;
34: l_location_rec.REGION_1 := hr_api.g_varchar2;
35: l_location_rec.REGION_2 := hr_api.g_varchar2;
36: l_location_rec.REGION_3 := hr_api.g_varchar2;
37: l_location_rec.SHIP_TO_LOCATION_ID := hr_api.g_number;
38: l_location_rec.SHIP_TO_SITE_FLAG := hr_api.g_varchar2;
39: l_location_rec.STYLE := g_style;
40: l_location_rec.TAX_NAME := hr_api.g_varchar2;
33: l_location_rec.RECEIVING_SITE_FLAG := hr_api.g_varchar2;
34: l_location_rec.REGION_1 := hr_api.g_varchar2;
35: l_location_rec.REGION_2 := hr_api.g_varchar2;
36: l_location_rec.REGION_3 := hr_api.g_varchar2;
37: l_location_rec.SHIP_TO_LOCATION_ID := hr_api.g_number;
38: l_location_rec.SHIP_TO_SITE_FLAG := hr_api.g_varchar2;
39: l_location_rec.STYLE := g_style;
40: l_location_rec.TAX_NAME := hr_api.g_varchar2;
41: l_location_rec.TELEPHONE_NUMBER_1 := hr_api.g_varchar2;
34: l_location_rec.REGION_1 := hr_api.g_varchar2;
35: l_location_rec.REGION_2 := hr_api.g_varchar2;
36: l_location_rec.REGION_3 := hr_api.g_varchar2;
37: l_location_rec.SHIP_TO_LOCATION_ID := hr_api.g_number;
38: l_location_rec.SHIP_TO_SITE_FLAG := hr_api.g_varchar2;
39: l_location_rec.STYLE := g_style;
40: l_location_rec.TAX_NAME := hr_api.g_varchar2;
41: l_location_rec.TELEPHONE_NUMBER_1 := hr_api.g_varchar2;
42: l_location_rec.TELEPHONE_NUMBER_2 := hr_api.g_varchar2;
36: l_location_rec.REGION_3 := hr_api.g_varchar2;
37: l_location_rec.SHIP_TO_LOCATION_ID := hr_api.g_number;
38: l_location_rec.SHIP_TO_SITE_FLAG := hr_api.g_varchar2;
39: l_location_rec.STYLE := g_style;
40: l_location_rec.TAX_NAME := hr_api.g_varchar2;
41: l_location_rec.TELEPHONE_NUMBER_1 := hr_api.g_varchar2;
42: l_location_rec.TELEPHONE_NUMBER_2 := hr_api.g_varchar2;
43: l_location_rec.TELEPHONE_NUMBER_3 := hr_api.g_varchar2;
44: l_location_rec.TOWN_OR_CITY := hr_api.g_varchar2;
37: l_location_rec.SHIP_TO_LOCATION_ID := hr_api.g_number;
38: l_location_rec.SHIP_TO_SITE_FLAG := hr_api.g_varchar2;
39: l_location_rec.STYLE := g_style;
40: l_location_rec.TAX_NAME := hr_api.g_varchar2;
41: l_location_rec.TELEPHONE_NUMBER_1 := hr_api.g_varchar2;
42: l_location_rec.TELEPHONE_NUMBER_2 := hr_api.g_varchar2;
43: l_location_rec.TELEPHONE_NUMBER_3 := hr_api.g_varchar2;
44: l_location_rec.TOWN_OR_CITY := hr_api.g_varchar2;
45: l_location_rec.ATTRIBUTE_CATEGORY := hr_api.g_varchar2;
38: l_location_rec.SHIP_TO_SITE_FLAG := hr_api.g_varchar2;
39: l_location_rec.STYLE := g_style;
40: l_location_rec.TAX_NAME := hr_api.g_varchar2;
41: l_location_rec.TELEPHONE_NUMBER_1 := hr_api.g_varchar2;
42: l_location_rec.TELEPHONE_NUMBER_2 := hr_api.g_varchar2;
43: l_location_rec.TELEPHONE_NUMBER_3 := hr_api.g_varchar2;
44: l_location_rec.TOWN_OR_CITY := hr_api.g_varchar2;
45: l_location_rec.ATTRIBUTE_CATEGORY := hr_api.g_varchar2;
46: l_location_rec.ATTRIBUTE1 := hr_api.g_varchar2;
39: l_location_rec.STYLE := g_style;
40: l_location_rec.TAX_NAME := hr_api.g_varchar2;
41: l_location_rec.TELEPHONE_NUMBER_1 := hr_api.g_varchar2;
42: l_location_rec.TELEPHONE_NUMBER_2 := hr_api.g_varchar2;
43: l_location_rec.TELEPHONE_NUMBER_3 := hr_api.g_varchar2;
44: l_location_rec.TOWN_OR_CITY := hr_api.g_varchar2;
45: l_location_rec.ATTRIBUTE_CATEGORY := hr_api.g_varchar2;
46: l_location_rec.ATTRIBUTE1 := hr_api.g_varchar2;
47: l_location_rec.ATTRIBUTE2 := hr_api.g_varchar2;
40: l_location_rec.TAX_NAME := hr_api.g_varchar2;
41: l_location_rec.TELEPHONE_NUMBER_1 := hr_api.g_varchar2;
42: l_location_rec.TELEPHONE_NUMBER_2 := hr_api.g_varchar2;
43: l_location_rec.TELEPHONE_NUMBER_3 := hr_api.g_varchar2;
44: l_location_rec.TOWN_OR_CITY := hr_api.g_varchar2;
45: l_location_rec.ATTRIBUTE_CATEGORY := hr_api.g_varchar2;
46: l_location_rec.ATTRIBUTE1 := hr_api.g_varchar2;
47: l_location_rec.ATTRIBUTE2 := hr_api.g_varchar2;
48: l_location_rec.ATTRIBUTE3 := hr_api.g_varchar2;
41: l_location_rec.TELEPHONE_NUMBER_1 := hr_api.g_varchar2;
42: l_location_rec.TELEPHONE_NUMBER_2 := hr_api.g_varchar2;
43: l_location_rec.TELEPHONE_NUMBER_3 := hr_api.g_varchar2;
44: l_location_rec.TOWN_OR_CITY := hr_api.g_varchar2;
45: l_location_rec.ATTRIBUTE_CATEGORY := hr_api.g_varchar2;
46: l_location_rec.ATTRIBUTE1 := hr_api.g_varchar2;
47: l_location_rec.ATTRIBUTE2 := hr_api.g_varchar2;
48: l_location_rec.ATTRIBUTE3 := hr_api.g_varchar2;
49: l_location_rec.ATTRIBUTE4 := hr_api.g_varchar2;
42: l_location_rec.TELEPHONE_NUMBER_2 := hr_api.g_varchar2;
43: l_location_rec.TELEPHONE_NUMBER_3 := hr_api.g_varchar2;
44: l_location_rec.TOWN_OR_CITY := hr_api.g_varchar2;
45: l_location_rec.ATTRIBUTE_CATEGORY := hr_api.g_varchar2;
46: l_location_rec.ATTRIBUTE1 := hr_api.g_varchar2;
47: l_location_rec.ATTRIBUTE2 := hr_api.g_varchar2;
48: l_location_rec.ATTRIBUTE3 := hr_api.g_varchar2;
49: l_location_rec.ATTRIBUTE4 := hr_api.g_varchar2;
50: l_location_rec.ATTRIBUTE5 := hr_api.g_varchar2;
43: l_location_rec.TELEPHONE_NUMBER_3 := hr_api.g_varchar2;
44: l_location_rec.TOWN_OR_CITY := hr_api.g_varchar2;
45: l_location_rec.ATTRIBUTE_CATEGORY := hr_api.g_varchar2;
46: l_location_rec.ATTRIBUTE1 := hr_api.g_varchar2;
47: l_location_rec.ATTRIBUTE2 := hr_api.g_varchar2;
48: l_location_rec.ATTRIBUTE3 := hr_api.g_varchar2;
49: l_location_rec.ATTRIBUTE4 := hr_api.g_varchar2;
50: l_location_rec.ATTRIBUTE5 := hr_api.g_varchar2;
51: l_location_rec.ATTRIBUTE6 := hr_api.g_varchar2;
44: l_location_rec.TOWN_OR_CITY := hr_api.g_varchar2;
45: l_location_rec.ATTRIBUTE_CATEGORY := hr_api.g_varchar2;
46: l_location_rec.ATTRIBUTE1 := hr_api.g_varchar2;
47: l_location_rec.ATTRIBUTE2 := hr_api.g_varchar2;
48: l_location_rec.ATTRIBUTE3 := hr_api.g_varchar2;
49: l_location_rec.ATTRIBUTE4 := hr_api.g_varchar2;
50: l_location_rec.ATTRIBUTE5 := hr_api.g_varchar2;
51: l_location_rec.ATTRIBUTE6 := hr_api.g_varchar2;
52: l_location_rec.ATTRIBUTE7 := hr_api.g_varchar2;
45: l_location_rec.ATTRIBUTE_CATEGORY := hr_api.g_varchar2;
46: l_location_rec.ATTRIBUTE1 := hr_api.g_varchar2;
47: l_location_rec.ATTRIBUTE2 := hr_api.g_varchar2;
48: l_location_rec.ATTRIBUTE3 := hr_api.g_varchar2;
49: l_location_rec.ATTRIBUTE4 := hr_api.g_varchar2;
50: l_location_rec.ATTRIBUTE5 := hr_api.g_varchar2;
51: l_location_rec.ATTRIBUTE6 := hr_api.g_varchar2;
52: l_location_rec.ATTRIBUTE7 := hr_api.g_varchar2;
53: l_location_rec.ATTRIBUTE8 := hr_api.g_varchar2;
46: l_location_rec.ATTRIBUTE1 := hr_api.g_varchar2;
47: l_location_rec.ATTRIBUTE2 := hr_api.g_varchar2;
48: l_location_rec.ATTRIBUTE3 := hr_api.g_varchar2;
49: l_location_rec.ATTRIBUTE4 := hr_api.g_varchar2;
50: l_location_rec.ATTRIBUTE5 := hr_api.g_varchar2;
51: l_location_rec.ATTRIBUTE6 := hr_api.g_varchar2;
52: l_location_rec.ATTRIBUTE7 := hr_api.g_varchar2;
53: l_location_rec.ATTRIBUTE8 := hr_api.g_varchar2;
54: l_location_rec.ATTRIBUTE9 := hr_api.g_varchar2;
47: l_location_rec.ATTRIBUTE2 := hr_api.g_varchar2;
48: l_location_rec.ATTRIBUTE3 := hr_api.g_varchar2;
49: l_location_rec.ATTRIBUTE4 := hr_api.g_varchar2;
50: l_location_rec.ATTRIBUTE5 := hr_api.g_varchar2;
51: l_location_rec.ATTRIBUTE6 := hr_api.g_varchar2;
52: l_location_rec.ATTRIBUTE7 := hr_api.g_varchar2;
53: l_location_rec.ATTRIBUTE8 := hr_api.g_varchar2;
54: l_location_rec.ATTRIBUTE9 := hr_api.g_varchar2;
55: l_location_rec.ATTRIBUTE10 := hr_api.g_varchar2;
48: l_location_rec.ATTRIBUTE3 := hr_api.g_varchar2;
49: l_location_rec.ATTRIBUTE4 := hr_api.g_varchar2;
50: l_location_rec.ATTRIBUTE5 := hr_api.g_varchar2;
51: l_location_rec.ATTRIBUTE6 := hr_api.g_varchar2;
52: l_location_rec.ATTRIBUTE7 := hr_api.g_varchar2;
53: l_location_rec.ATTRIBUTE8 := hr_api.g_varchar2;
54: l_location_rec.ATTRIBUTE9 := hr_api.g_varchar2;
55: l_location_rec.ATTRIBUTE10 := hr_api.g_varchar2;
56: l_location_rec.ATTRIBUTE11 := hr_api.g_varchar2;
49: l_location_rec.ATTRIBUTE4 := hr_api.g_varchar2;
50: l_location_rec.ATTRIBUTE5 := hr_api.g_varchar2;
51: l_location_rec.ATTRIBUTE6 := hr_api.g_varchar2;
52: l_location_rec.ATTRIBUTE7 := hr_api.g_varchar2;
53: l_location_rec.ATTRIBUTE8 := hr_api.g_varchar2;
54: l_location_rec.ATTRIBUTE9 := hr_api.g_varchar2;
55: l_location_rec.ATTRIBUTE10 := hr_api.g_varchar2;
56: l_location_rec.ATTRIBUTE11 := hr_api.g_varchar2;
57: l_location_rec.ATTRIBUTE12 := hr_api.g_varchar2;
50: l_location_rec.ATTRIBUTE5 := hr_api.g_varchar2;
51: l_location_rec.ATTRIBUTE6 := hr_api.g_varchar2;
52: l_location_rec.ATTRIBUTE7 := hr_api.g_varchar2;
53: l_location_rec.ATTRIBUTE8 := hr_api.g_varchar2;
54: l_location_rec.ATTRIBUTE9 := hr_api.g_varchar2;
55: l_location_rec.ATTRIBUTE10 := hr_api.g_varchar2;
56: l_location_rec.ATTRIBUTE11 := hr_api.g_varchar2;
57: l_location_rec.ATTRIBUTE12 := hr_api.g_varchar2;
58: l_location_rec.ATTRIBUTE13 := hr_api.g_varchar2;
51: l_location_rec.ATTRIBUTE6 := hr_api.g_varchar2;
52: l_location_rec.ATTRIBUTE7 := hr_api.g_varchar2;
53: l_location_rec.ATTRIBUTE8 := hr_api.g_varchar2;
54: l_location_rec.ATTRIBUTE9 := hr_api.g_varchar2;
55: l_location_rec.ATTRIBUTE10 := hr_api.g_varchar2;
56: l_location_rec.ATTRIBUTE11 := hr_api.g_varchar2;
57: l_location_rec.ATTRIBUTE12 := hr_api.g_varchar2;
58: l_location_rec.ATTRIBUTE13 := hr_api.g_varchar2;
59: l_location_rec.ATTRIBUTE14 := hr_api.g_varchar2;
52: l_location_rec.ATTRIBUTE7 := hr_api.g_varchar2;
53: l_location_rec.ATTRIBUTE8 := hr_api.g_varchar2;
54: l_location_rec.ATTRIBUTE9 := hr_api.g_varchar2;
55: l_location_rec.ATTRIBUTE10 := hr_api.g_varchar2;
56: l_location_rec.ATTRIBUTE11 := hr_api.g_varchar2;
57: l_location_rec.ATTRIBUTE12 := hr_api.g_varchar2;
58: l_location_rec.ATTRIBUTE13 := hr_api.g_varchar2;
59: l_location_rec.ATTRIBUTE14 := hr_api.g_varchar2;
60: l_location_rec.ATTRIBUTE15 := hr_api.g_varchar2;
53: l_location_rec.ATTRIBUTE8 := hr_api.g_varchar2;
54: l_location_rec.ATTRIBUTE9 := hr_api.g_varchar2;
55: l_location_rec.ATTRIBUTE10 := hr_api.g_varchar2;
56: l_location_rec.ATTRIBUTE11 := hr_api.g_varchar2;
57: l_location_rec.ATTRIBUTE12 := hr_api.g_varchar2;
58: l_location_rec.ATTRIBUTE13 := hr_api.g_varchar2;
59: l_location_rec.ATTRIBUTE14 := hr_api.g_varchar2;
60: l_location_rec.ATTRIBUTE15 := hr_api.g_varchar2;
61: l_location_rec.ATTRIBUTE16 := hr_api.g_varchar2;
54: l_location_rec.ATTRIBUTE9 := hr_api.g_varchar2;
55: l_location_rec.ATTRIBUTE10 := hr_api.g_varchar2;
56: l_location_rec.ATTRIBUTE11 := hr_api.g_varchar2;
57: l_location_rec.ATTRIBUTE12 := hr_api.g_varchar2;
58: l_location_rec.ATTRIBUTE13 := hr_api.g_varchar2;
59: l_location_rec.ATTRIBUTE14 := hr_api.g_varchar2;
60: l_location_rec.ATTRIBUTE15 := hr_api.g_varchar2;
61: l_location_rec.ATTRIBUTE16 := hr_api.g_varchar2;
62: l_location_rec.ATTRIBUTE17 := hr_api.g_varchar2;
55: l_location_rec.ATTRIBUTE10 := hr_api.g_varchar2;
56: l_location_rec.ATTRIBUTE11 := hr_api.g_varchar2;
57: l_location_rec.ATTRIBUTE12 := hr_api.g_varchar2;
58: l_location_rec.ATTRIBUTE13 := hr_api.g_varchar2;
59: l_location_rec.ATTRIBUTE14 := hr_api.g_varchar2;
60: l_location_rec.ATTRIBUTE15 := hr_api.g_varchar2;
61: l_location_rec.ATTRIBUTE16 := hr_api.g_varchar2;
62: l_location_rec.ATTRIBUTE17 := hr_api.g_varchar2;
63: l_location_rec.ATTRIBUTE18 := hr_api.g_varchar2;
56: l_location_rec.ATTRIBUTE11 := hr_api.g_varchar2;
57: l_location_rec.ATTRIBUTE12 := hr_api.g_varchar2;
58: l_location_rec.ATTRIBUTE13 := hr_api.g_varchar2;
59: l_location_rec.ATTRIBUTE14 := hr_api.g_varchar2;
60: l_location_rec.ATTRIBUTE15 := hr_api.g_varchar2;
61: l_location_rec.ATTRIBUTE16 := hr_api.g_varchar2;
62: l_location_rec.ATTRIBUTE17 := hr_api.g_varchar2;
63: l_location_rec.ATTRIBUTE18 := hr_api.g_varchar2;
64: l_location_rec.ATTRIBUTE19 := hr_api.g_varchar2;
57: l_location_rec.ATTRIBUTE12 := hr_api.g_varchar2;
58: l_location_rec.ATTRIBUTE13 := hr_api.g_varchar2;
59: l_location_rec.ATTRIBUTE14 := hr_api.g_varchar2;
60: l_location_rec.ATTRIBUTE15 := hr_api.g_varchar2;
61: l_location_rec.ATTRIBUTE16 := hr_api.g_varchar2;
62: l_location_rec.ATTRIBUTE17 := hr_api.g_varchar2;
63: l_location_rec.ATTRIBUTE18 := hr_api.g_varchar2;
64: l_location_rec.ATTRIBUTE19 := hr_api.g_varchar2;
65: l_location_rec.ATTRIBUTE20 := hr_api.g_varchar2;
58: l_location_rec.ATTRIBUTE13 := hr_api.g_varchar2;
59: l_location_rec.ATTRIBUTE14 := hr_api.g_varchar2;
60: l_location_rec.ATTRIBUTE15 := hr_api.g_varchar2;
61: l_location_rec.ATTRIBUTE16 := hr_api.g_varchar2;
62: l_location_rec.ATTRIBUTE17 := hr_api.g_varchar2;
63: l_location_rec.ATTRIBUTE18 := hr_api.g_varchar2;
64: l_location_rec.ATTRIBUTE19 := hr_api.g_varchar2;
65: l_location_rec.ATTRIBUTE20 := hr_api.g_varchar2;
66: l_location_rec.LAST_UPDATE_DATE := hr_api.g_date;
59: l_location_rec.ATTRIBUTE14 := hr_api.g_varchar2;
60: l_location_rec.ATTRIBUTE15 := hr_api.g_varchar2;
61: l_location_rec.ATTRIBUTE16 := hr_api.g_varchar2;
62: l_location_rec.ATTRIBUTE17 := hr_api.g_varchar2;
63: l_location_rec.ATTRIBUTE18 := hr_api.g_varchar2;
64: l_location_rec.ATTRIBUTE19 := hr_api.g_varchar2;
65: l_location_rec.ATTRIBUTE20 := hr_api.g_varchar2;
66: l_location_rec.LAST_UPDATE_DATE := hr_api.g_date;
67: l_location_rec.LAST_UPDATED_BY := hr_api.g_number;
60: l_location_rec.ATTRIBUTE15 := hr_api.g_varchar2;
61: l_location_rec.ATTRIBUTE16 := hr_api.g_varchar2;
62: l_location_rec.ATTRIBUTE17 := hr_api.g_varchar2;
63: l_location_rec.ATTRIBUTE18 := hr_api.g_varchar2;
64: l_location_rec.ATTRIBUTE19 := hr_api.g_varchar2;
65: l_location_rec.ATTRIBUTE20 := hr_api.g_varchar2;
66: l_location_rec.LAST_UPDATE_DATE := hr_api.g_date;
67: l_location_rec.LAST_UPDATED_BY := hr_api.g_number;
68: l_location_rec.LAST_UPDATE_LOGIN := hr_api.g_number;
61: l_location_rec.ATTRIBUTE16 := hr_api.g_varchar2;
62: l_location_rec.ATTRIBUTE17 := hr_api.g_varchar2;
63: l_location_rec.ATTRIBUTE18 := hr_api.g_varchar2;
64: l_location_rec.ATTRIBUTE19 := hr_api.g_varchar2;
65: l_location_rec.ATTRIBUTE20 := hr_api.g_varchar2;
66: l_location_rec.LAST_UPDATE_DATE := hr_api.g_date;
67: l_location_rec.LAST_UPDATED_BY := hr_api.g_number;
68: l_location_rec.LAST_UPDATE_LOGIN := hr_api.g_number;
69: l_location_rec.CREATED_BY := hr_api.g_number;
62: l_location_rec.ATTRIBUTE17 := hr_api.g_varchar2;
63: l_location_rec.ATTRIBUTE18 := hr_api.g_varchar2;
64: l_location_rec.ATTRIBUTE19 := hr_api.g_varchar2;
65: l_location_rec.ATTRIBUTE20 := hr_api.g_varchar2;
66: l_location_rec.LAST_UPDATE_DATE := hr_api.g_date;
67: l_location_rec.LAST_UPDATED_BY := hr_api.g_number;
68: l_location_rec.LAST_UPDATE_LOGIN := hr_api.g_number;
69: l_location_rec.CREATED_BY := hr_api.g_number;
70: l_location_rec.CREATION_DATE := hr_api.g_date;
63: l_location_rec.ATTRIBUTE18 := hr_api.g_varchar2;
64: l_location_rec.ATTRIBUTE19 := hr_api.g_varchar2;
65: l_location_rec.ATTRIBUTE20 := hr_api.g_varchar2;
66: l_location_rec.LAST_UPDATE_DATE := hr_api.g_date;
67: l_location_rec.LAST_UPDATED_BY := hr_api.g_number;
68: l_location_rec.LAST_UPDATE_LOGIN := hr_api.g_number;
69: l_location_rec.CREATED_BY := hr_api.g_number;
70: l_location_rec.CREATION_DATE := hr_api.g_date;
71: l_location_rec.OBJECT_VERSION_NUMBER := hr_api.g_number;
64: l_location_rec.ATTRIBUTE19 := hr_api.g_varchar2;
65: l_location_rec.ATTRIBUTE20 := hr_api.g_varchar2;
66: l_location_rec.LAST_UPDATE_DATE := hr_api.g_date;
67: l_location_rec.LAST_UPDATED_BY := hr_api.g_number;
68: l_location_rec.LAST_UPDATE_LOGIN := hr_api.g_number;
69: l_location_rec.CREATED_BY := hr_api.g_number;
70: l_location_rec.CREATION_DATE := hr_api.g_date;
71: l_location_rec.OBJECT_VERSION_NUMBER := hr_api.g_number;
72: l_location_rec.TP_HEADER_ID := hr_api.g_number;
65: l_location_rec.ATTRIBUTE20 := hr_api.g_varchar2;
66: l_location_rec.LAST_UPDATE_DATE := hr_api.g_date;
67: l_location_rec.LAST_UPDATED_BY := hr_api.g_number;
68: l_location_rec.LAST_UPDATE_LOGIN := hr_api.g_number;
69: l_location_rec.CREATED_BY := hr_api.g_number;
70: l_location_rec.CREATION_DATE := hr_api.g_date;
71: l_location_rec.OBJECT_VERSION_NUMBER := hr_api.g_number;
72: l_location_rec.TP_HEADER_ID := hr_api.g_number;
73: l_location_rec.ECE_TP_LOCATION_CODE := hr_api.g_varchar2;
66: l_location_rec.LAST_UPDATE_DATE := hr_api.g_date;
67: l_location_rec.LAST_UPDATED_BY := hr_api.g_number;
68: l_location_rec.LAST_UPDATE_LOGIN := hr_api.g_number;
69: l_location_rec.CREATED_BY := hr_api.g_number;
70: l_location_rec.CREATION_DATE := hr_api.g_date;
71: l_location_rec.OBJECT_VERSION_NUMBER := hr_api.g_number;
72: l_location_rec.TP_HEADER_ID := hr_api.g_number;
73: l_location_rec.ECE_TP_LOCATION_CODE := hr_api.g_varchar2;
74: l_location_rec.GLOBAL_ATTRIBUTE_CATEGORY := hr_api.g_varchar2;
67: l_location_rec.LAST_UPDATED_BY := hr_api.g_number;
68: l_location_rec.LAST_UPDATE_LOGIN := hr_api.g_number;
69: l_location_rec.CREATED_BY := hr_api.g_number;
70: l_location_rec.CREATION_DATE := hr_api.g_date;
71: l_location_rec.OBJECT_VERSION_NUMBER := hr_api.g_number;
72: l_location_rec.TP_HEADER_ID := hr_api.g_number;
73: l_location_rec.ECE_TP_LOCATION_CODE := hr_api.g_varchar2;
74: l_location_rec.GLOBAL_ATTRIBUTE_CATEGORY := hr_api.g_varchar2;
75: l_location_rec.GLOBAL_ATTRIBUTE1 := hr_api.g_varchar2;
68: l_location_rec.LAST_UPDATE_LOGIN := hr_api.g_number;
69: l_location_rec.CREATED_BY := hr_api.g_number;
70: l_location_rec.CREATION_DATE := hr_api.g_date;
71: l_location_rec.OBJECT_VERSION_NUMBER := hr_api.g_number;
72: l_location_rec.TP_HEADER_ID := hr_api.g_number;
73: l_location_rec.ECE_TP_LOCATION_CODE := hr_api.g_varchar2;
74: l_location_rec.GLOBAL_ATTRIBUTE_CATEGORY := hr_api.g_varchar2;
75: l_location_rec.GLOBAL_ATTRIBUTE1 := hr_api.g_varchar2;
76: l_location_rec.GLOBAL_ATTRIBUTE2 := hr_api.g_varchar2;
69: l_location_rec.CREATED_BY := hr_api.g_number;
70: l_location_rec.CREATION_DATE := hr_api.g_date;
71: l_location_rec.OBJECT_VERSION_NUMBER := hr_api.g_number;
72: l_location_rec.TP_HEADER_ID := hr_api.g_number;
73: l_location_rec.ECE_TP_LOCATION_CODE := hr_api.g_varchar2;
74: l_location_rec.GLOBAL_ATTRIBUTE_CATEGORY := hr_api.g_varchar2;
75: l_location_rec.GLOBAL_ATTRIBUTE1 := hr_api.g_varchar2;
76: l_location_rec.GLOBAL_ATTRIBUTE2 := hr_api.g_varchar2;
77: l_location_rec.GLOBAL_ATTRIBUTE3 := hr_api.g_varchar2;
70: l_location_rec.CREATION_DATE := hr_api.g_date;
71: l_location_rec.OBJECT_VERSION_NUMBER := hr_api.g_number;
72: l_location_rec.TP_HEADER_ID := hr_api.g_number;
73: l_location_rec.ECE_TP_LOCATION_CODE := hr_api.g_varchar2;
74: l_location_rec.GLOBAL_ATTRIBUTE_CATEGORY := hr_api.g_varchar2;
75: l_location_rec.GLOBAL_ATTRIBUTE1 := hr_api.g_varchar2;
76: l_location_rec.GLOBAL_ATTRIBUTE2 := hr_api.g_varchar2;
77: l_location_rec.GLOBAL_ATTRIBUTE3 := hr_api.g_varchar2;
78: l_location_rec.GLOBAL_ATTRIBUTE4 := hr_api.g_varchar2;
71: l_location_rec.OBJECT_VERSION_NUMBER := hr_api.g_number;
72: l_location_rec.TP_HEADER_ID := hr_api.g_number;
73: l_location_rec.ECE_TP_LOCATION_CODE := hr_api.g_varchar2;
74: l_location_rec.GLOBAL_ATTRIBUTE_CATEGORY := hr_api.g_varchar2;
75: l_location_rec.GLOBAL_ATTRIBUTE1 := hr_api.g_varchar2;
76: l_location_rec.GLOBAL_ATTRIBUTE2 := hr_api.g_varchar2;
77: l_location_rec.GLOBAL_ATTRIBUTE3 := hr_api.g_varchar2;
78: l_location_rec.GLOBAL_ATTRIBUTE4 := hr_api.g_varchar2;
79: l_location_rec.GLOBAL_ATTRIBUTE5 := hr_api.g_varchar2;
72: l_location_rec.TP_HEADER_ID := hr_api.g_number;
73: l_location_rec.ECE_TP_LOCATION_CODE := hr_api.g_varchar2;
74: l_location_rec.GLOBAL_ATTRIBUTE_CATEGORY := hr_api.g_varchar2;
75: l_location_rec.GLOBAL_ATTRIBUTE1 := hr_api.g_varchar2;
76: l_location_rec.GLOBAL_ATTRIBUTE2 := hr_api.g_varchar2;
77: l_location_rec.GLOBAL_ATTRIBUTE3 := hr_api.g_varchar2;
78: l_location_rec.GLOBAL_ATTRIBUTE4 := hr_api.g_varchar2;
79: l_location_rec.GLOBAL_ATTRIBUTE5 := hr_api.g_varchar2;
80: l_location_rec.GLOBAL_ATTRIBUTE6 := hr_api.g_varchar2;
73: l_location_rec.ECE_TP_LOCATION_CODE := hr_api.g_varchar2;
74: l_location_rec.GLOBAL_ATTRIBUTE_CATEGORY := hr_api.g_varchar2;
75: l_location_rec.GLOBAL_ATTRIBUTE1 := hr_api.g_varchar2;
76: l_location_rec.GLOBAL_ATTRIBUTE2 := hr_api.g_varchar2;
77: l_location_rec.GLOBAL_ATTRIBUTE3 := hr_api.g_varchar2;
78: l_location_rec.GLOBAL_ATTRIBUTE4 := hr_api.g_varchar2;
79: l_location_rec.GLOBAL_ATTRIBUTE5 := hr_api.g_varchar2;
80: l_location_rec.GLOBAL_ATTRIBUTE6 := hr_api.g_varchar2;
81: l_location_rec.GLOBAL_ATTRIBUTE7 := hr_api.g_varchar2;
74: l_location_rec.GLOBAL_ATTRIBUTE_CATEGORY := hr_api.g_varchar2;
75: l_location_rec.GLOBAL_ATTRIBUTE1 := hr_api.g_varchar2;
76: l_location_rec.GLOBAL_ATTRIBUTE2 := hr_api.g_varchar2;
77: l_location_rec.GLOBAL_ATTRIBUTE3 := hr_api.g_varchar2;
78: l_location_rec.GLOBAL_ATTRIBUTE4 := hr_api.g_varchar2;
79: l_location_rec.GLOBAL_ATTRIBUTE5 := hr_api.g_varchar2;
80: l_location_rec.GLOBAL_ATTRIBUTE6 := hr_api.g_varchar2;
81: l_location_rec.GLOBAL_ATTRIBUTE7 := hr_api.g_varchar2;
82: l_location_rec.GLOBAL_ATTRIBUTE8 := hr_api.g_varchar2;
75: l_location_rec.GLOBAL_ATTRIBUTE1 := hr_api.g_varchar2;
76: l_location_rec.GLOBAL_ATTRIBUTE2 := hr_api.g_varchar2;
77: l_location_rec.GLOBAL_ATTRIBUTE3 := hr_api.g_varchar2;
78: l_location_rec.GLOBAL_ATTRIBUTE4 := hr_api.g_varchar2;
79: l_location_rec.GLOBAL_ATTRIBUTE5 := hr_api.g_varchar2;
80: l_location_rec.GLOBAL_ATTRIBUTE6 := hr_api.g_varchar2;
81: l_location_rec.GLOBAL_ATTRIBUTE7 := hr_api.g_varchar2;
82: l_location_rec.GLOBAL_ATTRIBUTE8 := hr_api.g_varchar2;
83: l_location_rec.GLOBAL_ATTRIBUTE9 := hr_api.g_varchar2;
76: l_location_rec.GLOBAL_ATTRIBUTE2 := hr_api.g_varchar2;
77: l_location_rec.GLOBAL_ATTRIBUTE3 := hr_api.g_varchar2;
78: l_location_rec.GLOBAL_ATTRIBUTE4 := hr_api.g_varchar2;
79: l_location_rec.GLOBAL_ATTRIBUTE5 := hr_api.g_varchar2;
80: l_location_rec.GLOBAL_ATTRIBUTE6 := hr_api.g_varchar2;
81: l_location_rec.GLOBAL_ATTRIBUTE7 := hr_api.g_varchar2;
82: l_location_rec.GLOBAL_ATTRIBUTE8 := hr_api.g_varchar2;
83: l_location_rec.GLOBAL_ATTRIBUTE9 := hr_api.g_varchar2;
84: l_location_rec.GLOBAL_ATTRIBUTE10 := hr_api.g_varchar2;
77: l_location_rec.GLOBAL_ATTRIBUTE3 := hr_api.g_varchar2;
78: l_location_rec.GLOBAL_ATTRIBUTE4 := hr_api.g_varchar2;
79: l_location_rec.GLOBAL_ATTRIBUTE5 := hr_api.g_varchar2;
80: l_location_rec.GLOBAL_ATTRIBUTE6 := hr_api.g_varchar2;
81: l_location_rec.GLOBAL_ATTRIBUTE7 := hr_api.g_varchar2;
82: l_location_rec.GLOBAL_ATTRIBUTE8 := hr_api.g_varchar2;
83: l_location_rec.GLOBAL_ATTRIBUTE9 := hr_api.g_varchar2;
84: l_location_rec.GLOBAL_ATTRIBUTE10 := hr_api.g_varchar2;
85: l_location_rec.GLOBAL_ATTRIBUTE11 := hr_api.g_varchar2;
78: l_location_rec.GLOBAL_ATTRIBUTE4 := hr_api.g_varchar2;
79: l_location_rec.GLOBAL_ATTRIBUTE5 := hr_api.g_varchar2;
80: l_location_rec.GLOBAL_ATTRIBUTE6 := hr_api.g_varchar2;
81: l_location_rec.GLOBAL_ATTRIBUTE7 := hr_api.g_varchar2;
82: l_location_rec.GLOBAL_ATTRIBUTE8 := hr_api.g_varchar2;
83: l_location_rec.GLOBAL_ATTRIBUTE9 := hr_api.g_varchar2;
84: l_location_rec.GLOBAL_ATTRIBUTE10 := hr_api.g_varchar2;
85: l_location_rec.GLOBAL_ATTRIBUTE11 := hr_api.g_varchar2;
86: l_location_rec.GLOBAL_ATTRIBUTE12 := hr_api.g_varchar2;
79: l_location_rec.GLOBAL_ATTRIBUTE5 := hr_api.g_varchar2;
80: l_location_rec.GLOBAL_ATTRIBUTE6 := hr_api.g_varchar2;
81: l_location_rec.GLOBAL_ATTRIBUTE7 := hr_api.g_varchar2;
82: l_location_rec.GLOBAL_ATTRIBUTE8 := hr_api.g_varchar2;
83: l_location_rec.GLOBAL_ATTRIBUTE9 := hr_api.g_varchar2;
84: l_location_rec.GLOBAL_ATTRIBUTE10 := hr_api.g_varchar2;
85: l_location_rec.GLOBAL_ATTRIBUTE11 := hr_api.g_varchar2;
86: l_location_rec.GLOBAL_ATTRIBUTE12 := hr_api.g_varchar2;
87: l_location_rec.GLOBAL_ATTRIBUTE13 := hr_api.g_varchar2;
80: l_location_rec.GLOBAL_ATTRIBUTE6 := hr_api.g_varchar2;
81: l_location_rec.GLOBAL_ATTRIBUTE7 := hr_api.g_varchar2;
82: l_location_rec.GLOBAL_ATTRIBUTE8 := hr_api.g_varchar2;
83: l_location_rec.GLOBAL_ATTRIBUTE9 := hr_api.g_varchar2;
84: l_location_rec.GLOBAL_ATTRIBUTE10 := hr_api.g_varchar2;
85: l_location_rec.GLOBAL_ATTRIBUTE11 := hr_api.g_varchar2;
86: l_location_rec.GLOBAL_ATTRIBUTE12 := hr_api.g_varchar2;
87: l_location_rec.GLOBAL_ATTRIBUTE13 := hr_api.g_varchar2;
88: l_location_rec.GLOBAL_ATTRIBUTE14 := hr_api.g_varchar2;
81: l_location_rec.GLOBAL_ATTRIBUTE7 := hr_api.g_varchar2;
82: l_location_rec.GLOBAL_ATTRIBUTE8 := hr_api.g_varchar2;
83: l_location_rec.GLOBAL_ATTRIBUTE9 := hr_api.g_varchar2;
84: l_location_rec.GLOBAL_ATTRIBUTE10 := hr_api.g_varchar2;
85: l_location_rec.GLOBAL_ATTRIBUTE11 := hr_api.g_varchar2;
86: l_location_rec.GLOBAL_ATTRIBUTE12 := hr_api.g_varchar2;
87: l_location_rec.GLOBAL_ATTRIBUTE13 := hr_api.g_varchar2;
88: l_location_rec.GLOBAL_ATTRIBUTE14 := hr_api.g_varchar2;
89: l_location_rec.GLOBAL_ATTRIBUTE15 := hr_api.g_varchar2;
82: l_location_rec.GLOBAL_ATTRIBUTE8 := hr_api.g_varchar2;
83: l_location_rec.GLOBAL_ATTRIBUTE9 := hr_api.g_varchar2;
84: l_location_rec.GLOBAL_ATTRIBUTE10 := hr_api.g_varchar2;
85: l_location_rec.GLOBAL_ATTRIBUTE11 := hr_api.g_varchar2;
86: l_location_rec.GLOBAL_ATTRIBUTE12 := hr_api.g_varchar2;
87: l_location_rec.GLOBAL_ATTRIBUTE13 := hr_api.g_varchar2;
88: l_location_rec.GLOBAL_ATTRIBUTE14 := hr_api.g_varchar2;
89: l_location_rec.GLOBAL_ATTRIBUTE15 := hr_api.g_varchar2;
90: l_location_rec.GLOBAL_ATTRIBUTE16 := hr_api.g_varchar2;
83: l_location_rec.GLOBAL_ATTRIBUTE9 := hr_api.g_varchar2;
84: l_location_rec.GLOBAL_ATTRIBUTE10 := hr_api.g_varchar2;
85: l_location_rec.GLOBAL_ATTRIBUTE11 := hr_api.g_varchar2;
86: l_location_rec.GLOBAL_ATTRIBUTE12 := hr_api.g_varchar2;
87: l_location_rec.GLOBAL_ATTRIBUTE13 := hr_api.g_varchar2;
88: l_location_rec.GLOBAL_ATTRIBUTE14 := hr_api.g_varchar2;
89: l_location_rec.GLOBAL_ATTRIBUTE15 := hr_api.g_varchar2;
90: l_location_rec.GLOBAL_ATTRIBUTE16 := hr_api.g_varchar2;
91: l_location_rec.GLOBAL_ATTRIBUTE17 := hr_api.g_varchar2;
84: l_location_rec.GLOBAL_ATTRIBUTE10 := hr_api.g_varchar2;
85: l_location_rec.GLOBAL_ATTRIBUTE11 := hr_api.g_varchar2;
86: l_location_rec.GLOBAL_ATTRIBUTE12 := hr_api.g_varchar2;
87: l_location_rec.GLOBAL_ATTRIBUTE13 := hr_api.g_varchar2;
88: l_location_rec.GLOBAL_ATTRIBUTE14 := hr_api.g_varchar2;
89: l_location_rec.GLOBAL_ATTRIBUTE15 := hr_api.g_varchar2;
90: l_location_rec.GLOBAL_ATTRIBUTE16 := hr_api.g_varchar2;
91: l_location_rec.GLOBAL_ATTRIBUTE17 := hr_api.g_varchar2;
92: l_location_rec.GLOBAL_ATTRIBUTE18 := hr_api.g_varchar2;
85: l_location_rec.GLOBAL_ATTRIBUTE11 := hr_api.g_varchar2;
86: l_location_rec.GLOBAL_ATTRIBUTE12 := hr_api.g_varchar2;
87: l_location_rec.GLOBAL_ATTRIBUTE13 := hr_api.g_varchar2;
88: l_location_rec.GLOBAL_ATTRIBUTE14 := hr_api.g_varchar2;
89: l_location_rec.GLOBAL_ATTRIBUTE15 := hr_api.g_varchar2;
90: l_location_rec.GLOBAL_ATTRIBUTE16 := hr_api.g_varchar2;
91: l_location_rec.GLOBAL_ATTRIBUTE17 := hr_api.g_varchar2;
92: l_location_rec.GLOBAL_ATTRIBUTE18 := hr_api.g_varchar2;
93: l_location_rec.GLOBAL_ATTRIBUTE19 := hr_api.g_varchar2;
86: l_location_rec.GLOBAL_ATTRIBUTE12 := hr_api.g_varchar2;
87: l_location_rec.GLOBAL_ATTRIBUTE13 := hr_api.g_varchar2;
88: l_location_rec.GLOBAL_ATTRIBUTE14 := hr_api.g_varchar2;
89: l_location_rec.GLOBAL_ATTRIBUTE15 := hr_api.g_varchar2;
90: l_location_rec.GLOBAL_ATTRIBUTE16 := hr_api.g_varchar2;
91: l_location_rec.GLOBAL_ATTRIBUTE17 := hr_api.g_varchar2;
92: l_location_rec.GLOBAL_ATTRIBUTE18 := hr_api.g_varchar2;
93: l_location_rec.GLOBAL_ATTRIBUTE19 := hr_api.g_varchar2;
94: l_location_rec.GLOBAL_ATTRIBUTE20 := hr_api.g_varchar2;
87: l_location_rec.GLOBAL_ATTRIBUTE13 := hr_api.g_varchar2;
88: l_location_rec.GLOBAL_ATTRIBUTE14 := hr_api.g_varchar2;
89: l_location_rec.GLOBAL_ATTRIBUTE15 := hr_api.g_varchar2;
90: l_location_rec.GLOBAL_ATTRIBUTE16 := hr_api.g_varchar2;
91: l_location_rec.GLOBAL_ATTRIBUTE17 := hr_api.g_varchar2;
92: l_location_rec.GLOBAL_ATTRIBUTE18 := hr_api.g_varchar2;
93: l_location_rec.GLOBAL_ATTRIBUTE19 := hr_api.g_varchar2;
94: l_location_rec.GLOBAL_ATTRIBUTE20 := hr_api.g_varchar2;
95: l_location_rec.BUSINESS_GROUP_ID := hr_api.g_number;
88: l_location_rec.GLOBAL_ATTRIBUTE14 := hr_api.g_varchar2;
89: l_location_rec.GLOBAL_ATTRIBUTE15 := hr_api.g_varchar2;
90: l_location_rec.GLOBAL_ATTRIBUTE16 := hr_api.g_varchar2;
91: l_location_rec.GLOBAL_ATTRIBUTE17 := hr_api.g_varchar2;
92: l_location_rec.GLOBAL_ATTRIBUTE18 := hr_api.g_varchar2;
93: l_location_rec.GLOBAL_ATTRIBUTE19 := hr_api.g_varchar2;
94: l_location_rec.GLOBAL_ATTRIBUTE20 := hr_api.g_varchar2;
95: l_location_rec.BUSINESS_GROUP_ID := hr_api.g_number;
96: l_location_rec.LOC_INFORMATION13 := hr_api.g_varchar2;
89: l_location_rec.GLOBAL_ATTRIBUTE15 := hr_api.g_varchar2;
90: l_location_rec.GLOBAL_ATTRIBUTE16 := hr_api.g_varchar2;
91: l_location_rec.GLOBAL_ATTRIBUTE17 := hr_api.g_varchar2;
92: l_location_rec.GLOBAL_ATTRIBUTE18 := hr_api.g_varchar2;
93: l_location_rec.GLOBAL_ATTRIBUTE19 := hr_api.g_varchar2;
94: l_location_rec.GLOBAL_ATTRIBUTE20 := hr_api.g_varchar2;
95: l_location_rec.BUSINESS_GROUP_ID := hr_api.g_number;
96: l_location_rec.LOC_INFORMATION13 := hr_api.g_varchar2;
97: l_location_rec.LOC_INFORMATION14 := hr_api.g_varchar2;
90: l_location_rec.GLOBAL_ATTRIBUTE16 := hr_api.g_varchar2;
91: l_location_rec.GLOBAL_ATTRIBUTE17 := hr_api.g_varchar2;
92: l_location_rec.GLOBAL_ATTRIBUTE18 := hr_api.g_varchar2;
93: l_location_rec.GLOBAL_ATTRIBUTE19 := hr_api.g_varchar2;
94: l_location_rec.GLOBAL_ATTRIBUTE20 := hr_api.g_varchar2;
95: l_location_rec.BUSINESS_GROUP_ID := hr_api.g_number;
96: l_location_rec.LOC_INFORMATION13 := hr_api.g_varchar2;
97: l_location_rec.LOC_INFORMATION14 := hr_api.g_varchar2;
98: l_location_rec.LOC_INFORMATION15 := hr_api.g_varchar2;
91: l_location_rec.GLOBAL_ATTRIBUTE17 := hr_api.g_varchar2;
92: l_location_rec.GLOBAL_ATTRIBUTE18 := hr_api.g_varchar2;
93: l_location_rec.GLOBAL_ATTRIBUTE19 := hr_api.g_varchar2;
94: l_location_rec.GLOBAL_ATTRIBUTE20 := hr_api.g_varchar2;
95: l_location_rec.BUSINESS_GROUP_ID := hr_api.g_number;
96: l_location_rec.LOC_INFORMATION13 := hr_api.g_varchar2;
97: l_location_rec.LOC_INFORMATION14 := hr_api.g_varchar2;
98: l_location_rec.LOC_INFORMATION15 := hr_api.g_varchar2;
99: l_location_rec.LOC_INFORMATION16 := hr_api.g_varchar2;
92: l_location_rec.GLOBAL_ATTRIBUTE18 := hr_api.g_varchar2;
93: l_location_rec.GLOBAL_ATTRIBUTE19 := hr_api.g_varchar2;
94: l_location_rec.GLOBAL_ATTRIBUTE20 := hr_api.g_varchar2;
95: l_location_rec.BUSINESS_GROUP_ID := hr_api.g_number;
96: l_location_rec.LOC_INFORMATION13 := hr_api.g_varchar2;
97: l_location_rec.LOC_INFORMATION14 := hr_api.g_varchar2;
98: l_location_rec.LOC_INFORMATION15 := hr_api.g_varchar2;
99: l_location_rec.LOC_INFORMATION16 := hr_api.g_varchar2;
100: l_location_rec.LOC_INFORMATION17 := hr_api.g_varchar2;
93: l_location_rec.GLOBAL_ATTRIBUTE19 := hr_api.g_varchar2;
94: l_location_rec.GLOBAL_ATTRIBUTE20 := hr_api.g_varchar2;
95: l_location_rec.BUSINESS_GROUP_ID := hr_api.g_number;
96: l_location_rec.LOC_INFORMATION13 := hr_api.g_varchar2;
97: l_location_rec.LOC_INFORMATION14 := hr_api.g_varchar2;
98: l_location_rec.LOC_INFORMATION15 := hr_api.g_varchar2;
99: l_location_rec.LOC_INFORMATION16 := hr_api.g_varchar2;
100: l_location_rec.LOC_INFORMATION17 := hr_api.g_varchar2;
101: l_location_rec.LOC_INFORMATION18 := hr_api.g_varchar2;
94: l_location_rec.GLOBAL_ATTRIBUTE20 := hr_api.g_varchar2;
95: l_location_rec.BUSINESS_GROUP_ID := hr_api.g_number;
96: l_location_rec.LOC_INFORMATION13 := hr_api.g_varchar2;
97: l_location_rec.LOC_INFORMATION14 := hr_api.g_varchar2;
98: l_location_rec.LOC_INFORMATION15 := hr_api.g_varchar2;
99: l_location_rec.LOC_INFORMATION16 := hr_api.g_varchar2;
100: l_location_rec.LOC_INFORMATION17 := hr_api.g_varchar2;
101: l_location_rec.LOC_INFORMATION18 := hr_api.g_varchar2;
102: l_location_rec.LOC_INFORMATION19 := hr_api.g_varchar2;
95: l_location_rec.BUSINESS_GROUP_ID := hr_api.g_number;
96: l_location_rec.LOC_INFORMATION13 := hr_api.g_varchar2;
97: l_location_rec.LOC_INFORMATION14 := hr_api.g_varchar2;
98: l_location_rec.LOC_INFORMATION15 := hr_api.g_varchar2;
99: l_location_rec.LOC_INFORMATION16 := hr_api.g_varchar2;
100: l_location_rec.LOC_INFORMATION17 := hr_api.g_varchar2;
101: l_location_rec.LOC_INFORMATION18 := hr_api.g_varchar2;
102: l_location_rec.LOC_INFORMATION19 := hr_api.g_varchar2;
103: l_location_rec.LOC_INFORMATION20 := hr_api.g_varchar2;
96: l_location_rec.LOC_INFORMATION13 := hr_api.g_varchar2;
97: l_location_rec.LOC_INFORMATION14 := hr_api.g_varchar2;
98: l_location_rec.LOC_INFORMATION15 := hr_api.g_varchar2;
99: l_location_rec.LOC_INFORMATION16 := hr_api.g_varchar2;
100: l_location_rec.LOC_INFORMATION17 := hr_api.g_varchar2;
101: l_location_rec.LOC_INFORMATION18 := hr_api.g_varchar2;
102: l_location_rec.LOC_INFORMATION19 := hr_api.g_varchar2;
103: l_location_rec.LOC_INFORMATION20 := hr_api.g_varchar2;
104: l_location_rec.DERIVED_LOCALE := hr_api.g_varchar2;
97: l_location_rec.LOC_INFORMATION14 := hr_api.g_varchar2;
98: l_location_rec.LOC_INFORMATION15 := hr_api.g_varchar2;
99: l_location_rec.LOC_INFORMATION16 := hr_api.g_varchar2;
100: l_location_rec.LOC_INFORMATION17 := hr_api.g_varchar2;
101: l_location_rec.LOC_INFORMATION18 := hr_api.g_varchar2;
102: l_location_rec.LOC_INFORMATION19 := hr_api.g_varchar2;
103: l_location_rec.LOC_INFORMATION20 := hr_api.g_varchar2;
104: l_location_rec.DERIVED_LOCALE := hr_api.g_varchar2;
105: l_location_rec.LEGAL_ADDRESS_FLAG := hr_api.g_varchar2;
98: l_location_rec.LOC_INFORMATION15 := hr_api.g_varchar2;
99: l_location_rec.LOC_INFORMATION16 := hr_api.g_varchar2;
100: l_location_rec.LOC_INFORMATION17 := hr_api.g_varchar2;
101: l_location_rec.LOC_INFORMATION18 := hr_api.g_varchar2;
102: l_location_rec.LOC_INFORMATION19 := hr_api.g_varchar2;
103: l_location_rec.LOC_INFORMATION20 := hr_api.g_varchar2;
104: l_location_rec.DERIVED_LOCALE := hr_api.g_varchar2;
105: l_location_rec.LEGAL_ADDRESS_FLAG := hr_api.g_varchar2;
106: l_location_rec.TIMEZONE_CODE := hr_api.g_varchar2;
99: l_location_rec.LOC_INFORMATION16 := hr_api.g_varchar2;
100: l_location_rec.LOC_INFORMATION17 := hr_api.g_varchar2;
101: l_location_rec.LOC_INFORMATION18 := hr_api.g_varchar2;
102: l_location_rec.LOC_INFORMATION19 := hr_api.g_varchar2;
103: l_location_rec.LOC_INFORMATION20 := hr_api.g_varchar2;
104: l_location_rec.DERIVED_LOCALE := hr_api.g_varchar2;
105: l_location_rec.LEGAL_ADDRESS_FLAG := hr_api.g_varchar2;
106: l_location_rec.TIMEZONE_CODE := hr_api.g_varchar2;
107:
100: l_location_rec.LOC_INFORMATION17 := hr_api.g_varchar2;
101: l_location_rec.LOC_INFORMATION18 := hr_api.g_varchar2;
102: l_location_rec.LOC_INFORMATION19 := hr_api.g_varchar2;
103: l_location_rec.LOC_INFORMATION20 := hr_api.g_varchar2;
104: l_location_rec.DERIVED_LOCALE := hr_api.g_varchar2;
105: l_location_rec.LEGAL_ADDRESS_FLAG := hr_api.g_varchar2;
106: l_location_rec.TIMEZONE_CODE := hr_api.g_varchar2;
107:
108: return l_location_rec;
101: l_location_rec.LOC_INFORMATION18 := hr_api.g_varchar2;
102: l_location_rec.LOC_INFORMATION19 := hr_api.g_varchar2;
103: l_location_rec.LOC_INFORMATION20 := hr_api.g_varchar2;
104: l_location_rec.DERIVED_LOCALE := hr_api.g_varchar2;
105: l_location_rec.LEGAL_ADDRESS_FLAG := hr_api.g_varchar2;
106: l_location_rec.TIMEZONE_CODE := hr_api.g_varchar2;
107:
108: return l_location_rec;
109:
102: l_location_rec.LOC_INFORMATION19 := hr_api.g_varchar2;
103: l_location_rec.LOC_INFORMATION20 := hr_api.g_varchar2;
104: l_location_rec.DERIVED_LOCALE := hr_api.g_varchar2;
105: l_location_rec.LEGAL_ADDRESS_FLAG := hr_api.g_varchar2;
106: l_location_rec.TIMEZONE_CODE := hr_api.g_varchar2;
107:
108: return l_location_rec;
109:
110: exception
335:
336:
337: PROCEDURE INSUPD_LOCATION
338: (p_effective_date IN DATE
339: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
340: ,p_location_code IN VARCHAR2
341: ,p_description IN VARCHAR2 DEFAULT NULL
342: ,p_timezone_code IN VARCHAR2 DEFAULT NULL
343: ,p_tp_header_id IN NUMBER DEFAULT NULL