47: -- Internal Table Handler Use Only.
48: --
49: -- {End Of Comments}
50: -- ----------------------------------------------------------------------------
51: PROCEDURE delete_dml(p_rec IN hr_loc_shd.g_rec_type) IS
52: --
53: l_proc VARCHAR2(72) := g_package||'delete_dml';
54: --
55: BEGIN
54: --
55: BEGIN
56: hr_utility.set_location('Entering:'||l_proc, 5);
57: --
58: hr_loc_shd.g_api_dml := true; -- Set the api dml status
59: --
60: -- Delete the location row.
61: --
62: DELETE FROM hr_locations_all
61: --
62: DELETE FROM hr_locations_all
63: WHERE location_id = p_rec.location_id;
64: --
65: hr_loc_shd.g_api_dml := false; -- Unset the api dml status
66: --
67: hr_utility.set_location(' Leaving:'||l_proc, 10);
68: --
69: EXCEPTION
68: --
69: EXCEPTION
70: WHEN hr_api.child_integrity_violated THEN
71: -- Child integrity has been violated
72: hr_loc_shd.g_api_dml := false; -- Unset the api dml status
73: hr_loc_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(sqlerrm));
75: WHEN OTHERS THEN
76: hr_loc_shd.g_api_dml := false; -- Unset the api dml status
69: EXCEPTION
70: WHEN hr_api.child_integrity_violated THEN
71: -- Child integrity has been violated
72: hr_loc_shd.g_api_dml := false; -- Unset the api dml status
73: hr_loc_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(sqlerrm));
75: WHEN OTHERS THEN
76: hr_loc_shd.g_api_dml := false; -- Unset the api dml status
77: RAISE;
72: hr_loc_shd.g_api_dml := false; -- Unset the api dml status
73: hr_loc_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(sqlerrm));
75: WHEN OTHERS THEN
76: hr_loc_shd.g_api_dml := false; -- Unset the api dml status
77: RAISE;
78: END delete_dml;
79: --
80: -- ----------------------------------------------------------------------------
108: -- Internal Table Handler Use Only.
109: --
110: -- {End Of Comments}
111: -- ----------------------------------------------------------------------------
112: PROCEDURE pre_delete(p_rec IN hr_loc_shd.g_rec_type) IS
113: --
114: l_proc VARCHAR2(72) := g_package||'pre_delete';
115: --
116: BEGIN
150: -- Internal table Handler Use Only.
151: --
152: -- {End Of Comments}
153: -- ----------------------------------------------------------------------------
154: PROCEDURE post_delete(p_rec IN hr_loc_shd.g_rec_type) IS
155: --
156: l_proc VARCHAR2(72) := g_package||'post_delete';
157: --
158: BEGIN
163: --
164: hr_loc_rkd.after_delete
165: ( p_location_id => p_rec.location_id
166: --
167: ,p_location_code_o => hr_loc_shd.g_old_rec.location_code
168: ,p_address_line_1_o => hr_loc_shd.g_old_rec.address_line_1
169: ,p_address_line_2_o => hr_loc_shd.g_old_rec.address_line_2
170: ,p_address_line_3_o => hr_loc_shd.g_old_rec.address_line_3
171: ,p_bill_to_site_flag_o => hr_loc_shd.g_old_rec.bill_to_site_flag
164: hr_loc_rkd.after_delete
165: ( p_location_id => p_rec.location_id
166: --
167: ,p_location_code_o => hr_loc_shd.g_old_rec.location_code
168: ,p_address_line_1_o => hr_loc_shd.g_old_rec.address_line_1
169: ,p_address_line_2_o => hr_loc_shd.g_old_rec.address_line_2
170: ,p_address_line_3_o => hr_loc_shd.g_old_rec.address_line_3
171: ,p_bill_to_site_flag_o => hr_loc_shd.g_old_rec.bill_to_site_flag
172: ,p_country_o => hr_loc_shd.g_old_rec.country
165: ( p_location_id => p_rec.location_id
166: --
167: ,p_location_code_o => hr_loc_shd.g_old_rec.location_code
168: ,p_address_line_1_o => hr_loc_shd.g_old_rec.address_line_1
169: ,p_address_line_2_o => hr_loc_shd.g_old_rec.address_line_2
170: ,p_address_line_3_o => hr_loc_shd.g_old_rec.address_line_3
171: ,p_bill_to_site_flag_o => hr_loc_shd.g_old_rec.bill_to_site_flag
172: ,p_country_o => hr_loc_shd.g_old_rec.country
173: ,p_description_o => hr_loc_shd.g_old_rec.description
166: --
167: ,p_location_code_o => hr_loc_shd.g_old_rec.location_code
168: ,p_address_line_1_o => hr_loc_shd.g_old_rec.address_line_1
169: ,p_address_line_2_o => hr_loc_shd.g_old_rec.address_line_2
170: ,p_address_line_3_o => hr_loc_shd.g_old_rec.address_line_3
171: ,p_bill_to_site_flag_o => hr_loc_shd.g_old_rec.bill_to_site_flag
172: ,p_country_o => hr_loc_shd.g_old_rec.country
173: ,p_description_o => hr_loc_shd.g_old_rec.description
174: ,p_designated_receiver_id_o => hr_loc_shd.g_old_rec.designated_receiver_id
167: ,p_location_code_o => hr_loc_shd.g_old_rec.location_code
168: ,p_address_line_1_o => hr_loc_shd.g_old_rec.address_line_1
169: ,p_address_line_2_o => hr_loc_shd.g_old_rec.address_line_2
170: ,p_address_line_3_o => hr_loc_shd.g_old_rec.address_line_3
171: ,p_bill_to_site_flag_o => hr_loc_shd.g_old_rec.bill_to_site_flag
172: ,p_country_o => hr_loc_shd.g_old_rec.country
173: ,p_description_o => hr_loc_shd.g_old_rec.description
174: ,p_designated_receiver_id_o => hr_loc_shd.g_old_rec.designated_receiver_id
175: ,p_in_organization_flag_o => hr_loc_shd.g_old_rec.in_organization_flag
168: ,p_address_line_1_o => hr_loc_shd.g_old_rec.address_line_1
169: ,p_address_line_2_o => hr_loc_shd.g_old_rec.address_line_2
170: ,p_address_line_3_o => hr_loc_shd.g_old_rec.address_line_3
171: ,p_bill_to_site_flag_o => hr_loc_shd.g_old_rec.bill_to_site_flag
172: ,p_country_o => hr_loc_shd.g_old_rec.country
173: ,p_description_o => hr_loc_shd.g_old_rec.description
174: ,p_designated_receiver_id_o => hr_loc_shd.g_old_rec.designated_receiver_id
175: ,p_in_organization_flag_o => hr_loc_shd.g_old_rec.in_organization_flag
176: ,p_inactive_date_o => hr_loc_shd.g_old_rec.inactive_date
169: ,p_address_line_2_o => hr_loc_shd.g_old_rec.address_line_2
170: ,p_address_line_3_o => hr_loc_shd.g_old_rec.address_line_3
171: ,p_bill_to_site_flag_o => hr_loc_shd.g_old_rec.bill_to_site_flag
172: ,p_country_o => hr_loc_shd.g_old_rec.country
173: ,p_description_o => hr_loc_shd.g_old_rec.description
174: ,p_designated_receiver_id_o => hr_loc_shd.g_old_rec.designated_receiver_id
175: ,p_in_organization_flag_o => hr_loc_shd.g_old_rec.in_organization_flag
176: ,p_inactive_date_o => hr_loc_shd.g_old_rec.inactive_date
177: ,p_inventory_organization_id_o => hr_loc_shd.g_old_rec.inventory_organization_id
170: ,p_address_line_3_o => hr_loc_shd.g_old_rec.address_line_3
171: ,p_bill_to_site_flag_o => hr_loc_shd.g_old_rec.bill_to_site_flag
172: ,p_country_o => hr_loc_shd.g_old_rec.country
173: ,p_description_o => hr_loc_shd.g_old_rec.description
174: ,p_designated_receiver_id_o => hr_loc_shd.g_old_rec.designated_receiver_id
175: ,p_in_organization_flag_o => hr_loc_shd.g_old_rec.in_organization_flag
176: ,p_inactive_date_o => hr_loc_shd.g_old_rec.inactive_date
177: ,p_inventory_organization_id_o => hr_loc_shd.g_old_rec.inventory_organization_id
178: ,p_office_site_flag_o => hr_loc_shd.g_old_rec.office_site_flag
171: ,p_bill_to_site_flag_o => hr_loc_shd.g_old_rec.bill_to_site_flag
172: ,p_country_o => hr_loc_shd.g_old_rec.country
173: ,p_description_o => hr_loc_shd.g_old_rec.description
174: ,p_designated_receiver_id_o => hr_loc_shd.g_old_rec.designated_receiver_id
175: ,p_in_organization_flag_o => hr_loc_shd.g_old_rec.in_organization_flag
176: ,p_inactive_date_o => hr_loc_shd.g_old_rec.inactive_date
177: ,p_inventory_organization_id_o => hr_loc_shd.g_old_rec.inventory_organization_id
178: ,p_office_site_flag_o => hr_loc_shd.g_old_rec.office_site_flag
179: ,p_postal_code_o => hr_loc_shd.g_old_rec.postal_code
172: ,p_country_o => hr_loc_shd.g_old_rec.country
173: ,p_description_o => hr_loc_shd.g_old_rec.description
174: ,p_designated_receiver_id_o => hr_loc_shd.g_old_rec.designated_receiver_id
175: ,p_in_organization_flag_o => hr_loc_shd.g_old_rec.in_organization_flag
176: ,p_inactive_date_o => hr_loc_shd.g_old_rec.inactive_date
177: ,p_inventory_organization_id_o => hr_loc_shd.g_old_rec.inventory_organization_id
178: ,p_office_site_flag_o => hr_loc_shd.g_old_rec.office_site_flag
179: ,p_postal_code_o => hr_loc_shd.g_old_rec.postal_code
180: ,p_receiving_site_flag_o => hr_loc_shd.g_old_rec.receiving_site_flag
173: ,p_description_o => hr_loc_shd.g_old_rec.description
174: ,p_designated_receiver_id_o => hr_loc_shd.g_old_rec.designated_receiver_id
175: ,p_in_organization_flag_o => hr_loc_shd.g_old_rec.in_organization_flag
176: ,p_inactive_date_o => hr_loc_shd.g_old_rec.inactive_date
177: ,p_inventory_organization_id_o => hr_loc_shd.g_old_rec.inventory_organization_id
178: ,p_office_site_flag_o => hr_loc_shd.g_old_rec.office_site_flag
179: ,p_postal_code_o => hr_loc_shd.g_old_rec.postal_code
180: ,p_receiving_site_flag_o => hr_loc_shd.g_old_rec.receiving_site_flag
181: ,p_region_1_o => hr_loc_shd.g_old_rec.region_1
174: ,p_designated_receiver_id_o => hr_loc_shd.g_old_rec.designated_receiver_id
175: ,p_in_organization_flag_o => hr_loc_shd.g_old_rec.in_organization_flag
176: ,p_inactive_date_o => hr_loc_shd.g_old_rec.inactive_date
177: ,p_inventory_organization_id_o => hr_loc_shd.g_old_rec.inventory_organization_id
178: ,p_office_site_flag_o => hr_loc_shd.g_old_rec.office_site_flag
179: ,p_postal_code_o => hr_loc_shd.g_old_rec.postal_code
180: ,p_receiving_site_flag_o => hr_loc_shd.g_old_rec.receiving_site_flag
181: ,p_region_1_o => hr_loc_shd.g_old_rec.region_1
182: ,p_region_2_o => hr_loc_shd.g_old_rec.region_2
175: ,p_in_organization_flag_o => hr_loc_shd.g_old_rec.in_organization_flag
176: ,p_inactive_date_o => hr_loc_shd.g_old_rec.inactive_date
177: ,p_inventory_organization_id_o => hr_loc_shd.g_old_rec.inventory_organization_id
178: ,p_office_site_flag_o => hr_loc_shd.g_old_rec.office_site_flag
179: ,p_postal_code_o => hr_loc_shd.g_old_rec.postal_code
180: ,p_receiving_site_flag_o => hr_loc_shd.g_old_rec.receiving_site_flag
181: ,p_region_1_o => hr_loc_shd.g_old_rec.region_1
182: ,p_region_2_o => hr_loc_shd.g_old_rec.region_2
183: ,p_region_3_o => hr_loc_shd.g_old_rec.region_3
176: ,p_inactive_date_o => hr_loc_shd.g_old_rec.inactive_date
177: ,p_inventory_organization_id_o => hr_loc_shd.g_old_rec.inventory_organization_id
178: ,p_office_site_flag_o => hr_loc_shd.g_old_rec.office_site_flag
179: ,p_postal_code_o => hr_loc_shd.g_old_rec.postal_code
180: ,p_receiving_site_flag_o => hr_loc_shd.g_old_rec.receiving_site_flag
181: ,p_region_1_o => hr_loc_shd.g_old_rec.region_1
182: ,p_region_2_o => hr_loc_shd.g_old_rec.region_2
183: ,p_region_3_o => hr_loc_shd.g_old_rec.region_3
184: ,p_ship_to_location_id_o => hr_loc_shd.g_old_rec.ship_to_location_id
177: ,p_inventory_organization_id_o => hr_loc_shd.g_old_rec.inventory_organization_id
178: ,p_office_site_flag_o => hr_loc_shd.g_old_rec.office_site_flag
179: ,p_postal_code_o => hr_loc_shd.g_old_rec.postal_code
180: ,p_receiving_site_flag_o => hr_loc_shd.g_old_rec.receiving_site_flag
181: ,p_region_1_o => hr_loc_shd.g_old_rec.region_1
182: ,p_region_2_o => hr_loc_shd.g_old_rec.region_2
183: ,p_region_3_o => hr_loc_shd.g_old_rec.region_3
184: ,p_ship_to_location_id_o => hr_loc_shd.g_old_rec.ship_to_location_id
185: ,p_ship_to_site_flag_o => hr_loc_shd.g_old_rec.ship_to_site_flag
178: ,p_office_site_flag_o => hr_loc_shd.g_old_rec.office_site_flag
179: ,p_postal_code_o => hr_loc_shd.g_old_rec.postal_code
180: ,p_receiving_site_flag_o => hr_loc_shd.g_old_rec.receiving_site_flag
181: ,p_region_1_o => hr_loc_shd.g_old_rec.region_1
182: ,p_region_2_o => hr_loc_shd.g_old_rec.region_2
183: ,p_region_3_o => hr_loc_shd.g_old_rec.region_3
184: ,p_ship_to_location_id_o => hr_loc_shd.g_old_rec.ship_to_location_id
185: ,p_ship_to_site_flag_o => hr_loc_shd.g_old_rec.ship_to_site_flag
186: ,p_style_o => hr_loc_shd.g_old_rec.style
179: ,p_postal_code_o => hr_loc_shd.g_old_rec.postal_code
180: ,p_receiving_site_flag_o => hr_loc_shd.g_old_rec.receiving_site_flag
181: ,p_region_1_o => hr_loc_shd.g_old_rec.region_1
182: ,p_region_2_o => hr_loc_shd.g_old_rec.region_2
183: ,p_region_3_o => hr_loc_shd.g_old_rec.region_3
184: ,p_ship_to_location_id_o => hr_loc_shd.g_old_rec.ship_to_location_id
185: ,p_ship_to_site_flag_o => hr_loc_shd.g_old_rec.ship_to_site_flag
186: ,p_style_o => hr_loc_shd.g_old_rec.style
187: ,p_tax_name_o => hr_loc_shd.g_old_rec.tax_name
180: ,p_receiving_site_flag_o => hr_loc_shd.g_old_rec.receiving_site_flag
181: ,p_region_1_o => hr_loc_shd.g_old_rec.region_1
182: ,p_region_2_o => hr_loc_shd.g_old_rec.region_2
183: ,p_region_3_o => hr_loc_shd.g_old_rec.region_3
184: ,p_ship_to_location_id_o => hr_loc_shd.g_old_rec.ship_to_location_id
185: ,p_ship_to_site_flag_o => hr_loc_shd.g_old_rec.ship_to_site_flag
186: ,p_style_o => hr_loc_shd.g_old_rec.style
187: ,p_tax_name_o => hr_loc_shd.g_old_rec.tax_name
188: ,p_telephone_number_1_o => hr_loc_shd.g_old_rec.telephone_number_1
181: ,p_region_1_o => hr_loc_shd.g_old_rec.region_1
182: ,p_region_2_o => hr_loc_shd.g_old_rec.region_2
183: ,p_region_3_o => hr_loc_shd.g_old_rec.region_3
184: ,p_ship_to_location_id_o => hr_loc_shd.g_old_rec.ship_to_location_id
185: ,p_ship_to_site_flag_o => hr_loc_shd.g_old_rec.ship_to_site_flag
186: ,p_style_o => hr_loc_shd.g_old_rec.style
187: ,p_tax_name_o => hr_loc_shd.g_old_rec.tax_name
188: ,p_telephone_number_1_o => hr_loc_shd.g_old_rec.telephone_number_1
189: ,p_telephone_number_2_o => hr_loc_shd.g_old_rec.telephone_number_2
182: ,p_region_2_o => hr_loc_shd.g_old_rec.region_2
183: ,p_region_3_o => hr_loc_shd.g_old_rec.region_3
184: ,p_ship_to_location_id_o => hr_loc_shd.g_old_rec.ship_to_location_id
185: ,p_ship_to_site_flag_o => hr_loc_shd.g_old_rec.ship_to_site_flag
186: ,p_style_o => hr_loc_shd.g_old_rec.style
187: ,p_tax_name_o => hr_loc_shd.g_old_rec.tax_name
188: ,p_telephone_number_1_o => hr_loc_shd.g_old_rec.telephone_number_1
189: ,p_telephone_number_2_o => hr_loc_shd.g_old_rec.telephone_number_2
190: ,p_telephone_number_3_o => hr_loc_shd.g_old_rec.telephone_number_3
183: ,p_region_3_o => hr_loc_shd.g_old_rec.region_3
184: ,p_ship_to_location_id_o => hr_loc_shd.g_old_rec.ship_to_location_id
185: ,p_ship_to_site_flag_o => hr_loc_shd.g_old_rec.ship_to_site_flag
186: ,p_style_o => hr_loc_shd.g_old_rec.style
187: ,p_tax_name_o => hr_loc_shd.g_old_rec.tax_name
188: ,p_telephone_number_1_o => hr_loc_shd.g_old_rec.telephone_number_1
189: ,p_telephone_number_2_o => hr_loc_shd.g_old_rec.telephone_number_2
190: ,p_telephone_number_3_o => hr_loc_shd.g_old_rec.telephone_number_3
191: ,p_town_or_city_o => hr_loc_shd.g_old_rec.town_or_city
184: ,p_ship_to_location_id_o => hr_loc_shd.g_old_rec.ship_to_location_id
185: ,p_ship_to_site_flag_o => hr_loc_shd.g_old_rec.ship_to_site_flag
186: ,p_style_o => hr_loc_shd.g_old_rec.style
187: ,p_tax_name_o => hr_loc_shd.g_old_rec.tax_name
188: ,p_telephone_number_1_o => hr_loc_shd.g_old_rec.telephone_number_1
189: ,p_telephone_number_2_o => hr_loc_shd.g_old_rec.telephone_number_2
190: ,p_telephone_number_3_o => hr_loc_shd.g_old_rec.telephone_number_3
191: ,p_town_or_city_o => hr_loc_shd.g_old_rec.town_or_city
192: ,p_loc_information13_o => hr_loc_shd.g_old_rec.loc_information13
185: ,p_ship_to_site_flag_o => hr_loc_shd.g_old_rec.ship_to_site_flag
186: ,p_style_o => hr_loc_shd.g_old_rec.style
187: ,p_tax_name_o => hr_loc_shd.g_old_rec.tax_name
188: ,p_telephone_number_1_o => hr_loc_shd.g_old_rec.telephone_number_1
189: ,p_telephone_number_2_o => hr_loc_shd.g_old_rec.telephone_number_2
190: ,p_telephone_number_3_o => hr_loc_shd.g_old_rec.telephone_number_3
191: ,p_town_or_city_o => hr_loc_shd.g_old_rec.town_or_city
192: ,p_loc_information13_o => hr_loc_shd.g_old_rec.loc_information13
193: ,p_loc_information14_o => hr_loc_shd.g_old_rec.loc_information14
186: ,p_style_o => hr_loc_shd.g_old_rec.style
187: ,p_tax_name_o => hr_loc_shd.g_old_rec.tax_name
188: ,p_telephone_number_1_o => hr_loc_shd.g_old_rec.telephone_number_1
189: ,p_telephone_number_2_o => hr_loc_shd.g_old_rec.telephone_number_2
190: ,p_telephone_number_3_o => hr_loc_shd.g_old_rec.telephone_number_3
191: ,p_town_or_city_o => hr_loc_shd.g_old_rec.town_or_city
192: ,p_loc_information13_o => hr_loc_shd.g_old_rec.loc_information13
193: ,p_loc_information14_o => hr_loc_shd.g_old_rec.loc_information14
194: ,p_loc_information15_o => hr_loc_shd.g_old_rec.loc_information15
187: ,p_tax_name_o => hr_loc_shd.g_old_rec.tax_name
188: ,p_telephone_number_1_o => hr_loc_shd.g_old_rec.telephone_number_1
189: ,p_telephone_number_2_o => hr_loc_shd.g_old_rec.telephone_number_2
190: ,p_telephone_number_3_o => hr_loc_shd.g_old_rec.telephone_number_3
191: ,p_town_or_city_o => hr_loc_shd.g_old_rec.town_or_city
192: ,p_loc_information13_o => hr_loc_shd.g_old_rec.loc_information13
193: ,p_loc_information14_o => hr_loc_shd.g_old_rec.loc_information14
194: ,p_loc_information15_o => hr_loc_shd.g_old_rec.loc_information15
195: ,p_loc_information16_o => hr_loc_shd.g_old_rec.loc_information16
188: ,p_telephone_number_1_o => hr_loc_shd.g_old_rec.telephone_number_1
189: ,p_telephone_number_2_o => hr_loc_shd.g_old_rec.telephone_number_2
190: ,p_telephone_number_3_o => hr_loc_shd.g_old_rec.telephone_number_3
191: ,p_town_or_city_o => hr_loc_shd.g_old_rec.town_or_city
192: ,p_loc_information13_o => hr_loc_shd.g_old_rec.loc_information13
193: ,p_loc_information14_o => hr_loc_shd.g_old_rec.loc_information14
194: ,p_loc_information15_o => hr_loc_shd.g_old_rec.loc_information15
195: ,p_loc_information16_o => hr_loc_shd.g_old_rec.loc_information16
196: ,p_loc_information17_o => hr_loc_shd.g_old_rec.loc_information17
189: ,p_telephone_number_2_o => hr_loc_shd.g_old_rec.telephone_number_2
190: ,p_telephone_number_3_o => hr_loc_shd.g_old_rec.telephone_number_3
191: ,p_town_or_city_o => hr_loc_shd.g_old_rec.town_or_city
192: ,p_loc_information13_o => hr_loc_shd.g_old_rec.loc_information13
193: ,p_loc_information14_o => hr_loc_shd.g_old_rec.loc_information14
194: ,p_loc_information15_o => hr_loc_shd.g_old_rec.loc_information15
195: ,p_loc_information16_o => hr_loc_shd.g_old_rec.loc_information16
196: ,p_loc_information17_o => hr_loc_shd.g_old_rec.loc_information17
197: ,p_loc_information18_o => hr_loc_shd.g_old_rec.loc_information18
190: ,p_telephone_number_3_o => hr_loc_shd.g_old_rec.telephone_number_3
191: ,p_town_or_city_o => hr_loc_shd.g_old_rec.town_or_city
192: ,p_loc_information13_o => hr_loc_shd.g_old_rec.loc_information13
193: ,p_loc_information14_o => hr_loc_shd.g_old_rec.loc_information14
194: ,p_loc_information15_o => hr_loc_shd.g_old_rec.loc_information15
195: ,p_loc_information16_o => hr_loc_shd.g_old_rec.loc_information16
196: ,p_loc_information17_o => hr_loc_shd.g_old_rec.loc_information17
197: ,p_loc_information18_o => hr_loc_shd.g_old_rec.loc_information18
198: ,p_loc_information19_o => hr_loc_shd.g_old_rec.loc_information19
191: ,p_town_or_city_o => hr_loc_shd.g_old_rec.town_or_city
192: ,p_loc_information13_o => hr_loc_shd.g_old_rec.loc_information13
193: ,p_loc_information14_o => hr_loc_shd.g_old_rec.loc_information14
194: ,p_loc_information15_o => hr_loc_shd.g_old_rec.loc_information15
195: ,p_loc_information16_o => hr_loc_shd.g_old_rec.loc_information16
196: ,p_loc_information17_o => hr_loc_shd.g_old_rec.loc_information17
197: ,p_loc_information18_o => hr_loc_shd.g_old_rec.loc_information18
198: ,p_loc_information19_o => hr_loc_shd.g_old_rec.loc_information19
199: ,p_loc_information20_o => hr_loc_shd.g_old_rec.loc_information20
192: ,p_loc_information13_o => hr_loc_shd.g_old_rec.loc_information13
193: ,p_loc_information14_o => hr_loc_shd.g_old_rec.loc_information14
194: ,p_loc_information15_o => hr_loc_shd.g_old_rec.loc_information15
195: ,p_loc_information16_o => hr_loc_shd.g_old_rec.loc_information16
196: ,p_loc_information17_o => hr_loc_shd.g_old_rec.loc_information17
197: ,p_loc_information18_o => hr_loc_shd.g_old_rec.loc_information18
198: ,p_loc_information19_o => hr_loc_shd.g_old_rec.loc_information19
199: ,p_loc_information20_o => hr_loc_shd.g_old_rec.loc_information20
200: ,p_attribute_category_o => hr_loc_shd.g_old_rec.attribute_category
193: ,p_loc_information14_o => hr_loc_shd.g_old_rec.loc_information14
194: ,p_loc_information15_o => hr_loc_shd.g_old_rec.loc_information15
195: ,p_loc_information16_o => hr_loc_shd.g_old_rec.loc_information16
196: ,p_loc_information17_o => hr_loc_shd.g_old_rec.loc_information17
197: ,p_loc_information18_o => hr_loc_shd.g_old_rec.loc_information18
198: ,p_loc_information19_o => hr_loc_shd.g_old_rec.loc_information19
199: ,p_loc_information20_o => hr_loc_shd.g_old_rec.loc_information20
200: ,p_attribute_category_o => hr_loc_shd.g_old_rec.attribute_category
201: ,p_attribute1_o => hr_loc_shd.g_old_rec.attribute1
194: ,p_loc_information15_o => hr_loc_shd.g_old_rec.loc_information15
195: ,p_loc_information16_o => hr_loc_shd.g_old_rec.loc_information16
196: ,p_loc_information17_o => hr_loc_shd.g_old_rec.loc_information17
197: ,p_loc_information18_o => hr_loc_shd.g_old_rec.loc_information18
198: ,p_loc_information19_o => hr_loc_shd.g_old_rec.loc_information19
199: ,p_loc_information20_o => hr_loc_shd.g_old_rec.loc_information20
200: ,p_attribute_category_o => hr_loc_shd.g_old_rec.attribute_category
201: ,p_attribute1_o => hr_loc_shd.g_old_rec.attribute1
202: ,p_attribute2_o => hr_loc_shd.g_old_rec.attribute2
195: ,p_loc_information16_o => hr_loc_shd.g_old_rec.loc_information16
196: ,p_loc_information17_o => hr_loc_shd.g_old_rec.loc_information17
197: ,p_loc_information18_o => hr_loc_shd.g_old_rec.loc_information18
198: ,p_loc_information19_o => hr_loc_shd.g_old_rec.loc_information19
199: ,p_loc_information20_o => hr_loc_shd.g_old_rec.loc_information20
200: ,p_attribute_category_o => hr_loc_shd.g_old_rec.attribute_category
201: ,p_attribute1_o => hr_loc_shd.g_old_rec.attribute1
202: ,p_attribute2_o => hr_loc_shd.g_old_rec.attribute2
203: ,p_attribute3_o => hr_loc_shd.g_old_rec.attribute3
196: ,p_loc_information17_o => hr_loc_shd.g_old_rec.loc_information17
197: ,p_loc_information18_o => hr_loc_shd.g_old_rec.loc_information18
198: ,p_loc_information19_o => hr_loc_shd.g_old_rec.loc_information19
199: ,p_loc_information20_o => hr_loc_shd.g_old_rec.loc_information20
200: ,p_attribute_category_o => hr_loc_shd.g_old_rec.attribute_category
201: ,p_attribute1_o => hr_loc_shd.g_old_rec.attribute1
202: ,p_attribute2_o => hr_loc_shd.g_old_rec.attribute2
203: ,p_attribute3_o => hr_loc_shd.g_old_rec.attribute3
204: ,p_attribute4_o => hr_loc_shd.g_old_rec.attribute4
197: ,p_loc_information18_o => hr_loc_shd.g_old_rec.loc_information18
198: ,p_loc_information19_o => hr_loc_shd.g_old_rec.loc_information19
199: ,p_loc_information20_o => hr_loc_shd.g_old_rec.loc_information20
200: ,p_attribute_category_o => hr_loc_shd.g_old_rec.attribute_category
201: ,p_attribute1_o => hr_loc_shd.g_old_rec.attribute1
202: ,p_attribute2_o => hr_loc_shd.g_old_rec.attribute2
203: ,p_attribute3_o => hr_loc_shd.g_old_rec.attribute3
204: ,p_attribute4_o => hr_loc_shd.g_old_rec.attribute4
205: ,p_attribute5_o => hr_loc_shd.g_old_rec.attribute5
198: ,p_loc_information19_o => hr_loc_shd.g_old_rec.loc_information19
199: ,p_loc_information20_o => hr_loc_shd.g_old_rec.loc_information20
200: ,p_attribute_category_o => hr_loc_shd.g_old_rec.attribute_category
201: ,p_attribute1_o => hr_loc_shd.g_old_rec.attribute1
202: ,p_attribute2_o => hr_loc_shd.g_old_rec.attribute2
203: ,p_attribute3_o => hr_loc_shd.g_old_rec.attribute3
204: ,p_attribute4_o => hr_loc_shd.g_old_rec.attribute4
205: ,p_attribute5_o => hr_loc_shd.g_old_rec.attribute5
206: ,p_attribute6_o => hr_loc_shd.g_old_rec.attribute6
199: ,p_loc_information20_o => hr_loc_shd.g_old_rec.loc_information20
200: ,p_attribute_category_o => hr_loc_shd.g_old_rec.attribute_category
201: ,p_attribute1_o => hr_loc_shd.g_old_rec.attribute1
202: ,p_attribute2_o => hr_loc_shd.g_old_rec.attribute2
203: ,p_attribute3_o => hr_loc_shd.g_old_rec.attribute3
204: ,p_attribute4_o => hr_loc_shd.g_old_rec.attribute4
205: ,p_attribute5_o => hr_loc_shd.g_old_rec.attribute5
206: ,p_attribute6_o => hr_loc_shd.g_old_rec.attribute6
207: ,p_attribute7_o => hr_loc_shd.g_old_rec.attribute7
200: ,p_attribute_category_o => hr_loc_shd.g_old_rec.attribute_category
201: ,p_attribute1_o => hr_loc_shd.g_old_rec.attribute1
202: ,p_attribute2_o => hr_loc_shd.g_old_rec.attribute2
203: ,p_attribute3_o => hr_loc_shd.g_old_rec.attribute3
204: ,p_attribute4_o => hr_loc_shd.g_old_rec.attribute4
205: ,p_attribute5_o => hr_loc_shd.g_old_rec.attribute5
206: ,p_attribute6_o => hr_loc_shd.g_old_rec.attribute6
207: ,p_attribute7_o => hr_loc_shd.g_old_rec.attribute7
208: ,p_attribute8_o => hr_loc_shd.g_old_rec.attribute8
201: ,p_attribute1_o => hr_loc_shd.g_old_rec.attribute1
202: ,p_attribute2_o => hr_loc_shd.g_old_rec.attribute2
203: ,p_attribute3_o => hr_loc_shd.g_old_rec.attribute3
204: ,p_attribute4_o => hr_loc_shd.g_old_rec.attribute4
205: ,p_attribute5_o => hr_loc_shd.g_old_rec.attribute5
206: ,p_attribute6_o => hr_loc_shd.g_old_rec.attribute6
207: ,p_attribute7_o => hr_loc_shd.g_old_rec.attribute7
208: ,p_attribute8_o => hr_loc_shd.g_old_rec.attribute8
209: ,p_attribute9_o => hr_loc_shd.g_old_rec.attribute9
202: ,p_attribute2_o => hr_loc_shd.g_old_rec.attribute2
203: ,p_attribute3_o => hr_loc_shd.g_old_rec.attribute3
204: ,p_attribute4_o => hr_loc_shd.g_old_rec.attribute4
205: ,p_attribute5_o => hr_loc_shd.g_old_rec.attribute5
206: ,p_attribute6_o => hr_loc_shd.g_old_rec.attribute6
207: ,p_attribute7_o => hr_loc_shd.g_old_rec.attribute7
208: ,p_attribute8_o => hr_loc_shd.g_old_rec.attribute8
209: ,p_attribute9_o => hr_loc_shd.g_old_rec.attribute9
210: ,p_attribute10_o => hr_loc_shd.g_old_rec.attribute10
203: ,p_attribute3_o => hr_loc_shd.g_old_rec.attribute3
204: ,p_attribute4_o => hr_loc_shd.g_old_rec.attribute4
205: ,p_attribute5_o => hr_loc_shd.g_old_rec.attribute5
206: ,p_attribute6_o => hr_loc_shd.g_old_rec.attribute6
207: ,p_attribute7_o => hr_loc_shd.g_old_rec.attribute7
208: ,p_attribute8_o => hr_loc_shd.g_old_rec.attribute8
209: ,p_attribute9_o => hr_loc_shd.g_old_rec.attribute9
210: ,p_attribute10_o => hr_loc_shd.g_old_rec.attribute10
211: ,p_attribute11_o => hr_loc_shd.g_old_rec.attribute11
204: ,p_attribute4_o => hr_loc_shd.g_old_rec.attribute4
205: ,p_attribute5_o => hr_loc_shd.g_old_rec.attribute5
206: ,p_attribute6_o => hr_loc_shd.g_old_rec.attribute6
207: ,p_attribute7_o => hr_loc_shd.g_old_rec.attribute7
208: ,p_attribute8_o => hr_loc_shd.g_old_rec.attribute8
209: ,p_attribute9_o => hr_loc_shd.g_old_rec.attribute9
210: ,p_attribute10_o => hr_loc_shd.g_old_rec.attribute10
211: ,p_attribute11_o => hr_loc_shd.g_old_rec.attribute11
212: ,p_attribute12_o => hr_loc_shd.g_old_rec.attribute12
205: ,p_attribute5_o => hr_loc_shd.g_old_rec.attribute5
206: ,p_attribute6_o => hr_loc_shd.g_old_rec.attribute6
207: ,p_attribute7_o => hr_loc_shd.g_old_rec.attribute7
208: ,p_attribute8_o => hr_loc_shd.g_old_rec.attribute8
209: ,p_attribute9_o => hr_loc_shd.g_old_rec.attribute9
210: ,p_attribute10_o => hr_loc_shd.g_old_rec.attribute10
211: ,p_attribute11_o => hr_loc_shd.g_old_rec.attribute11
212: ,p_attribute12_o => hr_loc_shd.g_old_rec.attribute12
213: ,p_attribute13_o => hr_loc_shd.g_old_rec.attribute13
206: ,p_attribute6_o => hr_loc_shd.g_old_rec.attribute6
207: ,p_attribute7_o => hr_loc_shd.g_old_rec.attribute7
208: ,p_attribute8_o => hr_loc_shd.g_old_rec.attribute8
209: ,p_attribute9_o => hr_loc_shd.g_old_rec.attribute9
210: ,p_attribute10_o => hr_loc_shd.g_old_rec.attribute10
211: ,p_attribute11_o => hr_loc_shd.g_old_rec.attribute11
212: ,p_attribute12_o => hr_loc_shd.g_old_rec.attribute12
213: ,p_attribute13_o => hr_loc_shd.g_old_rec.attribute13
214: ,p_attribute14_o => hr_loc_shd.g_old_rec.attribute14
207: ,p_attribute7_o => hr_loc_shd.g_old_rec.attribute7
208: ,p_attribute8_o => hr_loc_shd.g_old_rec.attribute8
209: ,p_attribute9_o => hr_loc_shd.g_old_rec.attribute9
210: ,p_attribute10_o => hr_loc_shd.g_old_rec.attribute10
211: ,p_attribute11_o => hr_loc_shd.g_old_rec.attribute11
212: ,p_attribute12_o => hr_loc_shd.g_old_rec.attribute12
213: ,p_attribute13_o => hr_loc_shd.g_old_rec.attribute13
214: ,p_attribute14_o => hr_loc_shd.g_old_rec.attribute14
215: ,p_attribute15_o => hr_loc_shd.g_old_rec.attribute15
208: ,p_attribute8_o => hr_loc_shd.g_old_rec.attribute8
209: ,p_attribute9_o => hr_loc_shd.g_old_rec.attribute9
210: ,p_attribute10_o => hr_loc_shd.g_old_rec.attribute10
211: ,p_attribute11_o => hr_loc_shd.g_old_rec.attribute11
212: ,p_attribute12_o => hr_loc_shd.g_old_rec.attribute12
213: ,p_attribute13_o => hr_loc_shd.g_old_rec.attribute13
214: ,p_attribute14_o => hr_loc_shd.g_old_rec.attribute14
215: ,p_attribute15_o => hr_loc_shd.g_old_rec.attribute15
216: ,p_attribute16_o => hr_loc_shd.g_old_rec.attribute16
209: ,p_attribute9_o => hr_loc_shd.g_old_rec.attribute9
210: ,p_attribute10_o => hr_loc_shd.g_old_rec.attribute10
211: ,p_attribute11_o => hr_loc_shd.g_old_rec.attribute11
212: ,p_attribute12_o => hr_loc_shd.g_old_rec.attribute12
213: ,p_attribute13_o => hr_loc_shd.g_old_rec.attribute13
214: ,p_attribute14_o => hr_loc_shd.g_old_rec.attribute14
215: ,p_attribute15_o => hr_loc_shd.g_old_rec.attribute15
216: ,p_attribute16_o => hr_loc_shd.g_old_rec.attribute16
217: ,p_attribute17_o => hr_loc_shd.g_old_rec.attribute17
210: ,p_attribute10_o => hr_loc_shd.g_old_rec.attribute10
211: ,p_attribute11_o => hr_loc_shd.g_old_rec.attribute11
212: ,p_attribute12_o => hr_loc_shd.g_old_rec.attribute12
213: ,p_attribute13_o => hr_loc_shd.g_old_rec.attribute13
214: ,p_attribute14_o => hr_loc_shd.g_old_rec.attribute14
215: ,p_attribute15_o => hr_loc_shd.g_old_rec.attribute15
216: ,p_attribute16_o => hr_loc_shd.g_old_rec.attribute16
217: ,p_attribute17_o => hr_loc_shd.g_old_rec.attribute17
218: ,p_attribute18_o => hr_loc_shd.g_old_rec.attribute18
211: ,p_attribute11_o => hr_loc_shd.g_old_rec.attribute11
212: ,p_attribute12_o => hr_loc_shd.g_old_rec.attribute12
213: ,p_attribute13_o => hr_loc_shd.g_old_rec.attribute13
214: ,p_attribute14_o => hr_loc_shd.g_old_rec.attribute14
215: ,p_attribute15_o => hr_loc_shd.g_old_rec.attribute15
216: ,p_attribute16_o => hr_loc_shd.g_old_rec.attribute16
217: ,p_attribute17_o => hr_loc_shd.g_old_rec.attribute17
218: ,p_attribute18_o => hr_loc_shd.g_old_rec.attribute18
219: ,p_attribute19_o => hr_loc_shd.g_old_rec.attribute19
212: ,p_attribute12_o => hr_loc_shd.g_old_rec.attribute12
213: ,p_attribute13_o => hr_loc_shd.g_old_rec.attribute13
214: ,p_attribute14_o => hr_loc_shd.g_old_rec.attribute14
215: ,p_attribute15_o => hr_loc_shd.g_old_rec.attribute15
216: ,p_attribute16_o => hr_loc_shd.g_old_rec.attribute16
217: ,p_attribute17_o => hr_loc_shd.g_old_rec.attribute17
218: ,p_attribute18_o => hr_loc_shd.g_old_rec.attribute18
219: ,p_attribute19_o => hr_loc_shd.g_old_rec.attribute19
220: ,p_attribute20_o => hr_loc_shd.g_old_rec.attribute20
213: ,p_attribute13_o => hr_loc_shd.g_old_rec.attribute13
214: ,p_attribute14_o => hr_loc_shd.g_old_rec.attribute14
215: ,p_attribute15_o => hr_loc_shd.g_old_rec.attribute15
216: ,p_attribute16_o => hr_loc_shd.g_old_rec.attribute16
217: ,p_attribute17_o => hr_loc_shd.g_old_rec.attribute17
218: ,p_attribute18_o => hr_loc_shd.g_old_rec.attribute18
219: ,p_attribute19_o => hr_loc_shd.g_old_rec.attribute19
220: ,p_attribute20_o => hr_loc_shd.g_old_rec.attribute20
221: ,p_global_attribute_category_o => hr_loc_shd.g_old_rec.global_attribute_category
214: ,p_attribute14_o => hr_loc_shd.g_old_rec.attribute14
215: ,p_attribute15_o => hr_loc_shd.g_old_rec.attribute15
216: ,p_attribute16_o => hr_loc_shd.g_old_rec.attribute16
217: ,p_attribute17_o => hr_loc_shd.g_old_rec.attribute17
218: ,p_attribute18_o => hr_loc_shd.g_old_rec.attribute18
219: ,p_attribute19_o => hr_loc_shd.g_old_rec.attribute19
220: ,p_attribute20_o => hr_loc_shd.g_old_rec.attribute20
221: ,p_global_attribute_category_o => hr_loc_shd.g_old_rec.global_attribute_category
222: ,p_global_attribute1_o => hr_loc_shd.g_old_rec.global_attribute1
215: ,p_attribute15_o => hr_loc_shd.g_old_rec.attribute15
216: ,p_attribute16_o => hr_loc_shd.g_old_rec.attribute16
217: ,p_attribute17_o => hr_loc_shd.g_old_rec.attribute17
218: ,p_attribute18_o => hr_loc_shd.g_old_rec.attribute18
219: ,p_attribute19_o => hr_loc_shd.g_old_rec.attribute19
220: ,p_attribute20_o => hr_loc_shd.g_old_rec.attribute20
221: ,p_global_attribute_category_o => hr_loc_shd.g_old_rec.global_attribute_category
222: ,p_global_attribute1_o => hr_loc_shd.g_old_rec.global_attribute1
223: ,p_global_attribute2_o => hr_loc_shd.g_old_rec.global_attribute2
216: ,p_attribute16_o => hr_loc_shd.g_old_rec.attribute16
217: ,p_attribute17_o => hr_loc_shd.g_old_rec.attribute17
218: ,p_attribute18_o => hr_loc_shd.g_old_rec.attribute18
219: ,p_attribute19_o => hr_loc_shd.g_old_rec.attribute19
220: ,p_attribute20_o => hr_loc_shd.g_old_rec.attribute20
221: ,p_global_attribute_category_o => hr_loc_shd.g_old_rec.global_attribute_category
222: ,p_global_attribute1_o => hr_loc_shd.g_old_rec.global_attribute1
223: ,p_global_attribute2_o => hr_loc_shd.g_old_rec.global_attribute2
224: ,p_global_attribute3_o => hr_loc_shd.g_old_rec.global_attribute3
217: ,p_attribute17_o => hr_loc_shd.g_old_rec.attribute17
218: ,p_attribute18_o => hr_loc_shd.g_old_rec.attribute18
219: ,p_attribute19_o => hr_loc_shd.g_old_rec.attribute19
220: ,p_attribute20_o => hr_loc_shd.g_old_rec.attribute20
221: ,p_global_attribute_category_o => hr_loc_shd.g_old_rec.global_attribute_category
222: ,p_global_attribute1_o => hr_loc_shd.g_old_rec.global_attribute1
223: ,p_global_attribute2_o => hr_loc_shd.g_old_rec.global_attribute2
224: ,p_global_attribute3_o => hr_loc_shd.g_old_rec.global_attribute3
225: ,p_global_attribute4_o => hr_loc_shd.g_old_rec.global_attribute4
218: ,p_attribute18_o => hr_loc_shd.g_old_rec.attribute18
219: ,p_attribute19_o => hr_loc_shd.g_old_rec.attribute19
220: ,p_attribute20_o => hr_loc_shd.g_old_rec.attribute20
221: ,p_global_attribute_category_o => hr_loc_shd.g_old_rec.global_attribute_category
222: ,p_global_attribute1_o => hr_loc_shd.g_old_rec.global_attribute1
223: ,p_global_attribute2_o => hr_loc_shd.g_old_rec.global_attribute2
224: ,p_global_attribute3_o => hr_loc_shd.g_old_rec.global_attribute3
225: ,p_global_attribute4_o => hr_loc_shd.g_old_rec.global_attribute4
226: ,p_global_attribute5_o => hr_loc_shd.g_old_rec.global_attribute5
219: ,p_attribute19_o => hr_loc_shd.g_old_rec.attribute19
220: ,p_attribute20_o => hr_loc_shd.g_old_rec.attribute20
221: ,p_global_attribute_category_o => hr_loc_shd.g_old_rec.global_attribute_category
222: ,p_global_attribute1_o => hr_loc_shd.g_old_rec.global_attribute1
223: ,p_global_attribute2_o => hr_loc_shd.g_old_rec.global_attribute2
224: ,p_global_attribute3_o => hr_loc_shd.g_old_rec.global_attribute3
225: ,p_global_attribute4_o => hr_loc_shd.g_old_rec.global_attribute4
226: ,p_global_attribute5_o => hr_loc_shd.g_old_rec.global_attribute5
227: ,p_global_attribute6_o => hr_loc_shd.g_old_rec.global_attribute6
220: ,p_attribute20_o => hr_loc_shd.g_old_rec.attribute20
221: ,p_global_attribute_category_o => hr_loc_shd.g_old_rec.global_attribute_category
222: ,p_global_attribute1_o => hr_loc_shd.g_old_rec.global_attribute1
223: ,p_global_attribute2_o => hr_loc_shd.g_old_rec.global_attribute2
224: ,p_global_attribute3_o => hr_loc_shd.g_old_rec.global_attribute3
225: ,p_global_attribute4_o => hr_loc_shd.g_old_rec.global_attribute4
226: ,p_global_attribute5_o => hr_loc_shd.g_old_rec.global_attribute5
227: ,p_global_attribute6_o => hr_loc_shd.g_old_rec.global_attribute6
228: ,p_global_attribute7_o => hr_loc_shd.g_old_rec.global_attribute7
221: ,p_global_attribute_category_o => hr_loc_shd.g_old_rec.global_attribute_category
222: ,p_global_attribute1_o => hr_loc_shd.g_old_rec.global_attribute1
223: ,p_global_attribute2_o => hr_loc_shd.g_old_rec.global_attribute2
224: ,p_global_attribute3_o => hr_loc_shd.g_old_rec.global_attribute3
225: ,p_global_attribute4_o => hr_loc_shd.g_old_rec.global_attribute4
226: ,p_global_attribute5_o => hr_loc_shd.g_old_rec.global_attribute5
227: ,p_global_attribute6_o => hr_loc_shd.g_old_rec.global_attribute6
228: ,p_global_attribute7_o => hr_loc_shd.g_old_rec.global_attribute7
229: ,p_global_attribute8_o => hr_loc_shd.g_old_rec.global_attribute8
222: ,p_global_attribute1_o => hr_loc_shd.g_old_rec.global_attribute1
223: ,p_global_attribute2_o => hr_loc_shd.g_old_rec.global_attribute2
224: ,p_global_attribute3_o => hr_loc_shd.g_old_rec.global_attribute3
225: ,p_global_attribute4_o => hr_loc_shd.g_old_rec.global_attribute4
226: ,p_global_attribute5_o => hr_loc_shd.g_old_rec.global_attribute5
227: ,p_global_attribute6_o => hr_loc_shd.g_old_rec.global_attribute6
228: ,p_global_attribute7_o => hr_loc_shd.g_old_rec.global_attribute7
229: ,p_global_attribute8_o => hr_loc_shd.g_old_rec.global_attribute8
230: ,p_global_attribute9_o => hr_loc_shd.g_old_rec.global_attribute9
223: ,p_global_attribute2_o => hr_loc_shd.g_old_rec.global_attribute2
224: ,p_global_attribute3_o => hr_loc_shd.g_old_rec.global_attribute3
225: ,p_global_attribute4_o => hr_loc_shd.g_old_rec.global_attribute4
226: ,p_global_attribute5_o => hr_loc_shd.g_old_rec.global_attribute5
227: ,p_global_attribute6_o => hr_loc_shd.g_old_rec.global_attribute6
228: ,p_global_attribute7_o => hr_loc_shd.g_old_rec.global_attribute7
229: ,p_global_attribute8_o => hr_loc_shd.g_old_rec.global_attribute8
230: ,p_global_attribute9_o => hr_loc_shd.g_old_rec.global_attribute9
231: ,p_global_attribute10_o => hr_loc_shd.g_old_rec.global_attribute10
224: ,p_global_attribute3_o => hr_loc_shd.g_old_rec.global_attribute3
225: ,p_global_attribute4_o => hr_loc_shd.g_old_rec.global_attribute4
226: ,p_global_attribute5_o => hr_loc_shd.g_old_rec.global_attribute5
227: ,p_global_attribute6_o => hr_loc_shd.g_old_rec.global_attribute6
228: ,p_global_attribute7_o => hr_loc_shd.g_old_rec.global_attribute7
229: ,p_global_attribute8_o => hr_loc_shd.g_old_rec.global_attribute8
230: ,p_global_attribute9_o => hr_loc_shd.g_old_rec.global_attribute9
231: ,p_global_attribute10_o => hr_loc_shd.g_old_rec.global_attribute10
232: ,p_global_attribute11_o => hr_loc_shd.g_old_rec.global_attribute11
225: ,p_global_attribute4_o => hr_loc_shd.g_old_rec.global_attribute4
226: ,p_global_attribute5_o => hr_loc_shd.g_old_rec.global_attribute5
227: ,p_global_attribute6_o => hr_loc_shd.g_old_rec.global_attribute6
228: ,p_global_attribute7_o => hr_loc_shd.g_old_rec.global_attribute7
229: ,p_global_attribute8_o => hr_loc_shd.g_old_rec.global_attribute8
230: ,p_global_attribute9_o => hr_loc_shd.g_old_rec.global_attribute9
231: ,p_global_attribute10_o => hr_loc_shd.g_old_rec.global_attribute10
232: ,p_global_attribute11_o => hr_loc_shd.g_old_rec.global_attribute11
233: ,p_global_attribute12_o => hr_loc_shd.g_old_rec.global_attribute12
226: ,p_global_attribute5_o => hr_loc_shd.g_old_rec.global_attribute5
227: ,p_global_attribute6_o => hr_loc_shd.g_old_rec.global_attribute6
228: ,p_global_attribute7_o => hr_loc_shd.g_old_rec.global_attribute7
229: ,p_global_attribute8_o => hr_loc_shd.g_old_rec.global_attribute8
230: ,p_global_attribute9_o => hr_loc_shd.g_old_rec.global_attribute9
231: ,p_global_attribute10_o => hr_loc_shd.g_old_rec.global_attribute10
232: ,p_global_attribute11_o => hr_loc_shd.g_old_rec.global_attribute11
233: ,p_global_attribute12_o => hr_loc_shd.g_old_rec.global_attribute12
234: ,p_global_attribute13_o => hr_loc_shd.g_old_rec.global_attribute13
227: ,p_global_attribute6_o => hr_loc_shd.g_old_rec.global_attribute6
228: ,p_global_attribute7_o => hr_loc_shd.g_old_rec.global_attribute7
229: ,p_global_attribute8_o => hr_loc_shd.g_old_rec.global_attribute8
230: ,p_global_attribute9_o => hr_loc_shd.g_old_rec.global_attribute9
231: ,p_global_attribute10_o => hr_loc_shd.g_old_rec.global_attribute10
232: ,p_global_attribute11_o => hr_loc_shd.g_old_rec.global_attribute11
233: ,p_global_attribute12_o => hr_loc_shd.g_old_rec.global_attribute12
234: ,p_global_attribute13_o => hr_loc_shd.g_old_rec.global_attribute13
235: ,p_global_attribute14_o => hr_loc_shd.g_old_rec.global_attribute14
228: ,p_global_attribute7_o => hr_loc_shd.g_old_rec.global_attribute7
229: ,p_global_attribute8_o => hr_loc_shd.g_old_rec.global_attribute8
230: ,p_global_attribute9_o => hr_loc_shd.g_old_rec.global_attribute9
231: ,p_global_attribute10_o => hr_loc_shd.g_old_rec.global_attribute10
232: ,p_global_attribute11_o => hr_loc_shd.g_old_rec.global_attribute11
233: ,p_global_attribute12_o => hr_loc_shd.g_old_rec.global_attribute12
234: ,p_global_attribute13_o => hr_loc_shd.g_old_rec.global_attribute13
235: ,p_global_attribute14_o => hr_loc_shd.g_old_rec.global_attribute14
236: ,p_global_attribute15_o => hr_loc_shd.g_old_rec.global_attribute15
229: ,p_global_attribute8_o => hr_loc_shd.g_old_rec.global_attribute8
230: ,p_global_attribute9_o => hr_loc_shd.g_old_rec.global_attribute9
231: ,p_global_attribute10_o => hr_loc_shd.g_old_rec.global_attribute10
232: ,p_global_attribute11_o => hr_loc_shd.g_old_rec.global_attribute11
233: ,p_global_attribute12_o => hr_loc_shd.g_old_rec.global_attribute12
234: ,p_global_attribute13_o => hr_loc_shd.g_old_rec.global_attribute13
235: ,p_global_attribute14_o => hr_loc_shd.g_old_rec.global_attribute14
236: ,p_global_attribute15_o => hr_loc_shd.g_old_rec.global_attribute15
237: ,p_global_attribute16_o => hr_loc_shd.g_old_rec.global_attribute16
230: ,p_global_attribute9_o => hr_loc_shd.g_old_rec.global_attribute9
231: ,p_global_attribute10_o => hr_loc_shd.g_old_rec.global_attribute10
232: ,p_global_attribute11_o => hr_loc_shd.g_old_rec.global_attribute11
233: ,p_global_attribute12_o => hr_loc_shd.g_old_rec.global_attribute12
234: ,p_global_attribute13_o => hr_loc_shd.g_old_rec.global_attribute13
235: ,p_global_attribute14_o => hr_loc_shd.g_old_rec.global_attribute14
236: ,p_global_attribute15_o => hr_loc_shd.g_old_rec.global_attribute15
237: ,p_global_attribute16_o => hr_loc_shd.g_old_rec.global_attribute16
238: ,p_global_attribute17_o => hr_loc_shd.g_old_rec.global_attribute17
231: ,p_global_attribute10_o => hr_loc_shd.g_old_rec.global_attribute10
232: ,p_global_attribute11_o => hr_loc_shd.g_old_rec.global_attribute11
233: ,p_global_attribute12_o => hr_loc_shd.g_old_rec.global_attribute12
234: ,p_global_attribute13_o => hr_loc_shd.g_old_rec.global_attribute13
235: ,p_global_attribute14_o => hr_loc_shd.g_old_rec.global_attribute14
236: ,p_global_attribute15_o => hr_loc_shd.g_old_rec.global_attribute15
237: ,p_global_attribute16_o => hr_loc_shd.g_old_rec.global_attribute16
238: ,p_global_attribute17_o => hr_loc_shd.g_old_rec.global_attribute17
239: ,p_global_attribute18_o => hr_loc_shd.g_old_rec.global_attribute18
232: ,p_global_attribute11_o => hr_loc_shd.g_old_rec.global_attribute11
233: ,p_global_attribute12_o => hr_loc_shd.g_old_rec.global_attribute12
234: ,p_global_attribute13_o => hr_loc_shd.g_old_rec.global_attribute13
235: ,p_global_attribute14_o => hr_loc_shd.g_old_rec.global_attribute14
236: ,p_global_attribute15_o => hr_loc_shd.g_old_rec.global_attribute15
237: ,p_global_attribute16_o => hr_loc_shd.g_old_rec.global_attribute16
238: ,p_global_attribute17_o => hr_loc_shd.g_old_rec.global_attribute17
239: ,p_global_attribute18_o => hr_loc_shd.g_old_rec.global_attribute18
240: ,p_global_attribute19_o => hr_loc_shd.g_old_rec.global_attribute19
233: ,p_global_attribute12_o => hr_loc_shd.g_old_rec.global_attribute12
234: ,p_global_attribute13_o => hr_loc_shd.g_old_rec.global_attribute13
235: ,p_global_attribute14_o => hr_loc_shd.g_old_rec.global_attribute14
236: ,p_global_attribute15_o => hr_loc_shd.g_old_rec.global_attribute15
237: ,p_global_attribute16_o => hr_loc_shd.g_old_rec.global_attribute16
238: ,p_global_attribute17_o => hr_loc_shd.g_old_rec.global_attribute17
239: ,p_global_attribute18_o => hr_loc_shd.g_old_rec.global_attribute18
240: ,p_global_attribute19_o => hr_loc_shd.g_old_rec.global_attribute19
241: ,p_global_attribute20_o => hr_loc_shd.g_old_rec.global_attribute20
234: ,p_global_attribute13_o => hr_loc_shd.g_old_rec.global_attribute13
235: ,p_global_attribute14_o => hr_loc_shd.g_old_rec.global_attribute14
236: ,p_global_attribute15_o => hr_loc_shd.g_old_rec.global_attribute15
237: ,p_global_attribute16_o => hr_loc_shd.g_old_rec.global_attribute16
238: ,p_global_attribute17_o => hr_loc_shd.g_old_rec.global_attribute17
239: ,p_global_attribute18_o => hr_loc_shd.g_old_rec.global_attribute18
240: ,p_global_attribute19_o => hr_loc_shd.g_old_rec.global_attribute19
241: ,p_global_attribute20_o => hr_loc_shd.g_old_rec.global_attribute20
242: ,p_legal_address_flag_o => hr_loc_shd.g_old_rec.legal_address_flag
235: ,p_global_attribute14_o => hr_loc_shd.g_old_rec.global_attribute14
236: ,p_global_attribute15_o => hr_loc_shd.g_old_rec.global_attribute15
237: ,p_global_attribute16_o => hr_loc_shd.g_old_rec.global_attribute16
238: ,p_global_attribute17_o => hr_loc_shd.g_old_rec.global_attribute17
239: ,p_global_attribute18_o => hr_loc_shd.g_old_rec.global_attribute18
240: ,p_global_attribute19_o => hr_loc_shd.g_old_rec.global_attribute19
241: ,p_global_attribute20_o => hr_loc_shd.g_old_rec.global_attribute20
242: ,p_legal_address_flag_o => hr_loc_shd.g_old_rec.legal_address_flag
243: ,p_tp_header_id_o => hr_loc_shd.g_old_rec.tp_header_id
236: ,p_global_attribute15_o => hr_loc_shd.g_old_rec.global_attribute15
237: ,p_global_attribute16_o => hr_loc_shd.g_old_rec.global_attribute16
238: ,p_global_attribute17_o => hr_loc_shd.g_old_rec.global_attribute17
239: ,p_global_attribute18_o => hr_loc_shd.g_old_rec.global_attribute18
240: ,p_global_attribute19_o => hr_loc_shd.g_old_rec.global_attribute19
241: ,p_global_attribute20_o => hr_loc_shd.g_old_rec.global_attribute20
242: ,p_legal_address_flag_o => hr_loc_shd.g_old_rec.legal_address_flag
243: ,p_tp_header_id_o => hr_loc_shd.g_old_rec.tp_header_id
244: ,p_ece_tp_location_code_o => hr_loc_shd.g_old_rec.ece_tp_location_code
237: ,p_global_attribute16_o => hr_loc_shd.g_old_rec.global_attribute16
238: ,p_global_attribute17_o => hr_loc_shd.g_old_rec.global_attribute17
239: ,p_global_attribute18_o => hr_loc_shd.g_old_rec.global_attribute18
240: ,p_global_attribute19_o => hr_loc_shd.g_old_rec.global_attribute19
241: ,p_global_attribute20_o => hr_loc_shd.g_old_rec.global_attribute20
242: ,p_legal_address_flag_o => hr_loc_shd.g_old_rec.legal_address_flag
243: ,p_tp_header_id_o => hr_loc_shd.g_old_rec.tp_header_id
244: ,p_ece_tp_location_code_o => hr_loc_shd.g_old_rec.ece_tp_location_code
245: ,p_object_version_number_o => hr_loc_shd.g_old_rec.object_version_number
238: ,p_global_attribute17_o => hr_loc_shd.g_old_rec.global_attribute17
239: ,p_global_attribute18_o => hr_loc_shd.g_old_rec.global_attribute18
240: ,p_global_attribute19_o => hr_loc_shd.g_old_rec.global_attribute19
241: ,p_global_attribute20_o => hr_loc_shd.g_old_rec.global_attribute20
242: ,p_legal_address_flag_o => hr_loc_shd.g_old_rec.legal_address_flag
243: ,p_tp_header_id_o => hr_loc_shd.g_old_rec.tp_header_id
244: ,p_ece_tp_location_code_o => hr_loc_shd.g_old_rec.ece_tp_location_code
245: ,p_object_version_number_o => hr_loc_shd.g_old_rec.object_version_number
246: ,p_business_group_id_o => hr_loc_shd.g_old_rec.business_group_id
239: ,p_global_attribute18_o => hr_loc_shd.g_old_rec.global_attribute18
240: ,p_global_attribute19_o => hr_loc_shd.g_old_rec.global_attribute19
241: ,p_global_attribute20_o => hr_loc_shd.g_old_rec.global_attribute20
242: ,p_legal_address_flag_o => hr_loc_shd.g_old_rec.legal_address_flag
243: ,p_tp_header_id_o => hr_loc_shd.g_old_rec.tp_header_id
244: ,p_ece_tp_location_code_o => hr_loc_shd.g_old_rec.ece_tp_location_code
245: ,p_object_version_number_o => hr_loc_shd.g_old_rec.object_version_number
246: ,p_business_group_id_o => hr_loc_shd.g_old_rec.business_group_id
247: );
240: ,p_global_attribute19_o => hr_loc_shd.g_old_rec.global_attribute19
241: ,p_global_attribute20_o => hr_loc_shd.g_old_rec.global_attribute20
242: ,p_legal_address_flag_o => hr_loc_shd.g_old_rec.legal_address_flag
243: ,p_tp_header_id_o => hr_loc_shd.g_old_rec.tp_header_id
244: ,p_ece_tp_location_code_o => hr_loc_shd.g_old_rec.ece_tp_location_code
245: ,p_object_version_number_o => hr_loc_shd.g_old_rec.object_version_number
246: ,p_business_group_id_o => hr_loc_shd.g_old_rec.business_group_id
247: );
248: EXCEPTION
241: ,p_global_attribute20_o => hr_loc_shd.g_old_rec.global_attribute20
242: ,p_legal_address_flag_o => hr_loc_shd.g_old_rec.legal_address_flag
243: ,p_tp_header_id_o => hr_loc_shd.g_old_rec.tp_header_id
244: ,p_ece_tp_location_code_o => hr_loc_shd.g_old_rec.ece_tp_location_code
245: ,p_object_version_number_o => hr_loc_shd.g_old_rec.object_version_number
246: ,p_business_group_id_o => hr_loc_shd.g_old_rec.business_group_id
247: );
248: EXCEPTION
249: WHEN hr_api.cannot_find_prog_unit THEN
242: ,p_legal_address_flag_o => hr_loc_shd.g_old_rec.legal_address_flag
243: ,p_tp_header_id_o => hr_loc_shd.g_old_rec.tp_header_id
244: ,p_ece_tp_location_code_o => hr_loc_shd.g_old_rec.ece_tp_location_code
245: ,p_object_version_number_o => hr_loc_shd.g_old_rec.object_version_number
246: ,p_business_group_id_o => hr_loc_shd.g_old_rec.business_group_id
247: );
248: EXCEPTION
249: WHEN hr_api.cannot_find_prog_unit THEN
250: hr_api.cannot_find_prog_unit_error
303: -- ----------------------------------------------------------------------------
304: --
305: PROCEDURE del
306: (
307: p_rec IN hr_loc_shd.g_rec_type
308: ) IS
309: --
310: l_proc VARCHAR2(72) := g_package||'del';
311: --
313: hr_utility.set_location('Entering:'||l_proc, 5);
314: --
315: -- We must lock the row which we need to delete.
316: --
317: hr_loc_shd.lck ( p_rec.location_id,
318: p_rec.object_version_number );
319: hr_utility.set_location(l_proc, 10);
320: --
321: -- Call the supporting delete validate operation
384: p_location_id IN NUMBER,
385: p_object_version_number IN NUMBER
386: ) IS
387: --
388: l_rec hr_loc_shd.g_rec_type;
389: l_proc VARCHAR2(72) := g_package||'del';
390: --
391: BEGIN
392: hr_utility.set_location('Entering:'||l_proc, 5);