eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_LOC_DEL dependencies on HR_LOC_SHD

Line 51: PROCEDURE delete_dml(p_rec IN hr_loc_shd.g_rec_type) IS

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

Line 58: hr_loc_shd.g_api_dml := true; -- Set the api dml status

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

Line 65: hr_loc_shd.g_api_dml := false; -- Unset the api dml status

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

Line 72: hr_loc_shd.g_api_dml := false; -- Unset the api dml status

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

Line 73: hr_loc_shd.constraint_error

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;

Line 76: hr_loc_shd.g_api_dml := false; -- Unset the api dml status

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

Line 112: PROCEDURE pre_delete(p_rec IN hr_loc_shd.g_rec_type) IS

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

Line 154: PROCEDURE post_delete(p_rec IN hr_loc_shd.g_rec_type) IS

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

Line 167: ,p_location_code_o => hr_loc_shd.g_old_rec.location_code

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

Line 168: ,p_address_line_1_o => hr_loc_shd.g_old_rec.address_line_1

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

Line 169: ,p_address_line_2_o => hr_loc_shd.g_old_rec.address_line_2

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

Line 170: ,p_address_line_3_o => hr_loc_shd.g_old_rec.address_line_3

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

Line 171: ,p_bill_to_site_flag_o => hr_loc_shd.g_old_rec.bill_to_site_flag

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

Line 172: ,p_country_o => hr_loc_shd.g_old_rec.country

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

Line 173: ,p_description_o => hr_loc_shd.g_old_rec.description

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

Line 174: ,p_designated_receiver_id_o => hr_loc_shd.g_old_rec.designated_receiver_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

Line 175: ,p_in_organization_flag_o => hr_loc_shd.g_old_rec.in_organization_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

Line 176: ,p_inactive_date_o => hr_loc_shd.g_old_rec.inactive_date

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

Line 177: ,p_inventory_organization_id_o => hr_loc_shd.g_old_rec.inventory_organization_id

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

Line 178: ,p_office_site_flag_o => hr_loc_shd.g_old_rec.office_site_flag

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

Line 179: ,p_postal_code_o => hr_loc_shd.g_old_rec.postal_code

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

Line 180: ,p_receiving_site_flag_o => hr_loc_shd.g_old_rec.receiving_site_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
184: ,p_ship_to_location_id_o => hr_loc_shd.g_old_rec.ship_to_location_id

Line 181: ,p_region_1_o => hr_loc_shd.g_old_rec.region_1

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

Line 182: ,p_region_2_o => hr_loc_shd.g_old_rec.region_2

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

Line 183: ,p_region_3_o => hr_loc_shd.g_old_rec.region_3

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

Line 184: ,p_ship_to_location_id_o => hr_loc_shd.g_old_rec.ship_to_location_id

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

Line 185: ,p_ship_to_site_flag_o => hr_loc_shd.g_old_rec.ship_to_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
189: ,p_telephone_number_2_o => hr_loc_shd.g_old_rec.telephone_number_2

Line 186: ,p_style_o => hr_loc_shd.g_old_rec.style

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

Line 187: ,p_tax_name_o => hr_loc_shd.g_old_rec.tax_name

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

Line 188: ,p_telephone_number_1_o => hr_loc_shd.g_old_rec.telephone_number_1

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

Line 189: ,p_telephone_number_2_o => hr_loc_shd.g_old_rec.telephone_number_2

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

Line 190: ,p_telephone_number_3_o => hr_loc_shd.g_old_rec.telephone_number_3

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

Line 191: ,p_town_or_city_o => hr_loc_shd.g_old_rec.town_or_city

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

Line 192: ,p_loc_information13_o => hr_loc_shd.g_old_rec.loc_information13

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

Line 193: ,p_loc_information14_o => hr_loc_shd.g_old_rec.loc_information14

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

Line 194: ,p_loc_information15_o => hr_loc_shd.g_old_rec.loc_information15

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

Line 195: ,p_loc_information16_o => hr_loc_shd.g_old_rec.loc_information16

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

Line 196: ,p_loc_information17_o => hr_loc_shd.g_old_rec.loc_information17

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

Line 197: ,p_loc_information18_o => hr_loc_shd.g_old_rec.loc_information18

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

Line 198: ,p_loc_information19_o => hr_loc_shd.g_old_rec.loc_information19

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

Line 199: ,p_loc_information20_o => hr_loc_shd.g_old_rec.loc_information20

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

Line 200: ,p_attribute_category_o => hr_loc_shd.g_old_rec.attribute_category

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

Line 201: ,p_attribute1_o => hr_loc_shd.g_old_rec.attribute1

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

Line 202: ,p_attribute2_o => hr_loc_shd.g_old_rec.attribute2

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

Line 203: ,p_attribute3_o => hr_loc_shd.g_old_rec.attribute3

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

Line 204: ,p_attribute4_o => hr_loc_shd.g_old_rec.attribute4

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

Line 205: ,p_attribute5_o => hr_loc_shd.g_old_rec.attribute5

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

Line 206: ,p_attribute6_o => hr_loc_shd.g_old_rec.attribute6

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

Line 207: ,p_attribute7_o => hr_loc_shd.g_old_rec.attribute7

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

Line 208: ,p_attribute8_o => hr_loc_shd.g_old_rec.attribute8

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

Line 209: ,p_attribute9_o => hr_loc_shd.g_old_rec.attribute9

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

Line 210: ,p_attribute10_o => hr_loc_shd.g_old_rec.attribute10

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

Line 211: ,p_attribute11_o => hr_loc_shd.g_old_rec.attribute11

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

Line 212: ,p_attribute12_o => hr_loc_shd.g_old_rec.attribute12

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

Line 213: ,p_attribute13_o => hr_loc_shd.g_old_rec.attribute13

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

Line 214: ,p_attribute14_o => hr_loc_shd.g_old_rec.attribute14

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

Line 215: ,p_attribute15_o => hr_loc_shd.g_old_rec.attribute15

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

Line 216: ,p_attribute16_o => hr_loc_shd.g_old_rec.attribute16

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

Line 217: ,p_attribute17_o => hr_loc_shd.g_old_rec.attribute17

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

Line 218: ,p_attribute18_o => hr_loc_shd.g_old_rec.attribute18

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

Line 219: ,p_attribute19_o => hr_loc_shd.g_old_rec.attribute19

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

Line 220: ,p_attribute20_o => hr_loc_shd.g_old_rec.attribute20

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

Line 221: ,p_global_attribute_category_o => hr_loc_shd.g_old_rec.global_attribute_category

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

Line 222: ,p_global_attribute1_o => hr_loc_shd.g_old_rec.global_attribute1

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

Line 223: ,p_global_attribute2_o => hr_loc_shd.g_old_rec.global_attribute2

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

Line 224: ,p_global_attribute3_o => hr_loc_shd.g_old_rec.global_attribute3

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

Line 225: ,p_global_attribute4_o => hr_loc_shd.g_old_rec.global_attribute4

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

Line 226: ,p_global_attribute5_o => hr_loc_shd.g_old_rec.global_attribute5

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

Line 227: ,p_global_attribute6_o => hr_loc_shd.g_old_rec.global_attribute6

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

Line 228: ,p_global_attribute7_o => hr_loc_shd.g_old_rec.global_attribute7

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

Line 229: ,p_global_attribute8_o => hr_loc_shd.g_old_rec.global_attribute8

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

Line 230: ,p_global_attribute9_o => hr_loc_shd.g_old_rec.global_attribute9

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

Line 231: ,p_global_attribute10_o => hr_loc_shd.g_old_rec.global_attribute10

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

Line 232: ,p_global_attribute11_o => hr_loc_shd.g_old_rec.global_attribute11

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

Line 233: ,p_global_attribute12_o => hr_loc_shd.g_old_rec.global_attribute12

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

Line 234: ,p_global_attribute13_o => hr_loc_shd.g_old_rec.global_attribute13

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

Line 235: ,p_global_attribute14_o => hr_loc_shd.g_old_rec.global_attribute14

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

Line 236: ,p_global_attribute15_o => hr_loc_shd.g_old_rec.global_attribute15

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

Line 237: ,p_global_attribute16_o => hr_loc_shd.g_old_rec.global_attribute16

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

Line 238: ,p_global_attribute17_o => hr_loc_shd.g_old_rec.global_attribute17

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

Line 239: ,p_global_attribute18_o => hr_loc_shd.g_old_rec.global_attribute18

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

Line 240: ,p_global_attribute19_o => hr_loc_shd.g_old_rec.global_attribute19

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

Line 241: ,p_global_attribute20_o => hr_loc_shd.g_old_rec.global_attribute20

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

Line 242: ,p_legal_address_flag_o => hr_loc_shd.g_old_rec.legal_address_flag

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

Line 243: ,p_tp_header_id_o => hr_loc_shd.g_old_rec.tp_header_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: );

Line 244: ,p_ece_tp_location_code_o => hr_loc_shd.g_old_rec.ece_tp_location_code

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

Line 245: ,p_object_version_number_o => hr_loc_shd.g_old_rec.object_version_number

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

Line 246: ,p_business_group_id_o => hr_loc_shd.g_old_rec.business_group_id

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

Line 307: p_rec IN hr_loc_shd.g_rec_type

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

Line 317: hr_loc_shd.lck ( p_rec.location_id,

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

Line 388: l_rec hr_loc_shd.g_rec_type;

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