[Home] [Help]
50: -- Internal Row Handler Use Only.
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: PROCEDURE update_dml(p_rec IN OUT NOCOPY hr_loc_shd.g_rec_type) IS
55: --
56: l_proc VARCHAR2(72) := g_package||'update_dml';
57: --
58: BEGIN
62: -- Increment the object version
63: --
64: p_rec.object_version_number := p_rec.object_version_number + 1;
65: --
66: hr_loc_shd.g_api_dml := true; -- Set the api dml status
67: --
68: -- Update the hr_locations_all Row
69: --
70: UPDATE hr_locations_all
154: ece_tp_location_code = p_rec.ece_tp_location_code,
155: geometry = p_rec.geometry
156: WHERE location_id = p_rec.location_id;
157: --
158: hr_loc_shd.g_api_dml := false; -- Unset the api dml status
159: --
160: hr_utility.set_location(' Leaving:'||l_proc, 10);
161: --
162: EXCEPTION
161: --
162: EXCEPTION
163: WHEN hr_api.check_integrity_violated THEN
164: -- A check constraint has been violated
165: hr_loc_shd.g_api_dml := false; -- Unset the api dml status
166: hr_loc_shd.constraint_error
167: (p_constraint_name => hr_api.strip_constraint_name(sqlerrm));
168: WHEN hr_api.parent_integrity_violated THEN
169: -- Parent integrity has been violated
162: EXCEPTION
163: WHEN hr_api.check_integrity_violated THEN
164: -- A check constraint has been violated
165: hr_loc_shd.g_api_dml := false; -- Unset the api dml status
166: hr_loc_shd.constraint_error
167: (p_constraint_name => hr_api.strip_constraint_name(sqlerrm));
168: WHEN hr_api.parent_integrity_violated THEN
169: -- Parent integrity has been violated
170: hr_loc_shd.g_api_dml := false; -- Unset the api dml status
166: hr_loc_shd.constraint_error
167: (p_constraint_name => hr_api.strip_constraint_name(sqlerrm));
168: WHEN hr_api.parent_integrity_violated THEN
169: -- Parent integrity has been violated
170: hr_loc_shd.g_api_dml := false; -- Unset the api dml status
171: hr_loc_shd.constraint_error
172: (p_constraint_name => hr_api.strip_constraint_name(sqlerrm));
173: WHEN hr_api.unique_integrity_violated THEN
174: -- Unique integrity has been violated
167: (p_constraint_name => hr_api.strip_constraint_name(sqlerrm));
168: WHEN hr_api.parent_integrity_violated THEN
169: -- Parent integrity has been violated
170: hr_loc_shd.g_api_dml := false; -- Unset the api dml status
171: hr_loc_shd.constraint_error
172: (p_constraint_name => hr_api.strip_constraint_name(sqlerrm));
173: WHEN hr_api.unique_integrity_violated THEN
174: -- Unique integrity has been violated
175: hr_loc_shd.g_api_dml := false; -- Unset the api dml status
171: hr_loc_shd.constraint_error
172: (p_constraint_name => hr_api.strip_constraint_name(sqlerrm));
173: WHEN hr_api.unique_integrity_violated THEN
174: -- Unique integrity has been violated
175: hr_loc_shd.g_api_dml := false; -- Unset the api dml status
176: hr_loc_shd.constraint_error
177: (p_constraint_name => hr_api.strip_constraint_name(sqlerrm));
178: WHEN OTHERS THEN
179: hr_loc_shd.g_api_dml := false; -- Unset the api dml status
172: (p_constraint_name => hr_api.strip_constraint_name(sqlerrm));
173: WHEN hr_api.unique_integrity_violated THEN
174: -- Unique integrity has been violated
175: hr_loc_shd.g_api_dml := false; -- Unset the api dml status
176: hr_loc_shd.constraint_error
177: (p_constraint_name => hr_api.strip_constraint_name(sqlerrm));
178: WHEN OTHERS THEN
179: hr_loc_shd.g_api_dml := false; -- Unset the api dml status
180: RAISE;
175: hr_loc_shd.g_api_dml := false; -- Unset the api dml status
176: hr_loc_shd.constraint_error
177: (p_constraint_name => hr_api.strip_constraint_name(sqlerrm));
178: WHEN OTHERS THEN
179: hr_loc_shd.g_api_dml := false; -- Unset the api dml status
180: RAISE;
181: END update_dml;
182: --
183: -- ----------------------------------------------------------------------------
211: -- Internal Row Handler Use Only.
212: --
213: -- {End Of Comments}
214: -- ----------------------------------------------------------------------------
215: PROCEDURE pre_update(p_rec IN OUT NOCOPY hr_loc_shd.g_rec_type
216: ) IS
217: --
218: l_proc VARCHAR2(72) := g_package||'pre_update';
219: --
225:
226: --
227: hr_utility.set_location('Entering:'||l_proc, 5);
228: --
229: hr_loc_shd.derive_locale(p_rec);
230:
231:
232: if((nvl(p_rec.address_line_1,' ') = nvl(hr_loc_shd.g_old_rec.address_line_1,' '))
233: and (nvl(p_rec.address_line_2,' ') = nvl(hr_loc_shd.g_old_rec.address_line_2,' '))
228: --
229: hr_loc_shd.derive_locale(p_rec);
230:
231:
232: if((nvl(p_rec.address_line_1,' ') = nvl(hr_loc_shd.g_old_rec.address_line_1,' '))
233: and (nvl(p_rec.address_line_2,' ') = nvl(hr_loc_shd.g_old_rec.address_line_2,' '))
234: and (nvl(p_rec.address_line_3,' ') = nvl(hr_loc_shd.g_old_rec.address_line_3,' '))
235: and (nvl(p_rec.town_or_city,' ') = nvl(hr_loc_shd.g_old_rec.town_or_city,' '))
236: and (nvl(p_rec.region_1,' ') = nvl(hr_loc_shd.g_old_rec.region_1,' '))
229: hr_loc_shd.derive_locale(p_rec);
230:
231:
232: if((nvl(p_rec.address_line_1,' ') = nvl(hr_loc_shd.g_old_rec.address_line_1,' '))
233: and (nvl(p_rec.address_line_2,' ') = nvl(hr_loc_shd.g_old_rec.address_line_2,' '))
234: and (nvl(p_rec.address_line_3,' ') = nvl(hr_loc_shd.g_old_rec.address_line_3,' '))
235: and (nvl(p_rec.town_or_city,' ') = nvl(hr_loc_shd.g_old_rec.town_or_city,' '))
236: and (nvl(p_rec.region_1,' ') = nvl(hr_loc_shd.g_old_rec.region_1,' '))
237: and (nvl(p_rec.region_2,' ') = nvl(hr_loc_shd.g_old_rec.region_2,' '))
230:
231:
232: if((nvl(p_rec.address_line_1,' ') = nvl(hr_loc_shd.g_old_rec.address_line_1,' '))
233: and (nvl(p_rec.address_line_2,' ') = nvl(hr_loc_shd.g_old_rec.address_line_2,' '))
234: and (nvl(p_rec.address_line_3,' ') = nvl(hr_loc_shd.g_old_rec.address_line_3,' '))
235: and (nvl(p_rec.town_or_city,' ') = nvl(hr_loc_shd.g_old_rec.town_or_city,' '))
236: and (nvl(p_rec.region_1,' ') = nvl(hr_loc_shd.g_old_rec.region_1,' '))
237: and (nvl(p_rec.region_2,' ') = nvl(hr_loc_shd.g_old_rec.region_2,' '))
238: and (nvl(p_rec.region_3,' ') = nvl(hr_loc_shd.g_old_rec.region_3,' '))
231:
232: if((nvl(p_rec.address_line_1,' ') = nvl(hr_loc_shd.g_old_rec.address_line_1,' '))
233: and (nvl(p_rec.address_line_2,' ') = nvl(hr_loc_shd.g_old_rec.address_line_2,' '))
234: and (nvl(p_rec.address_line_3,' ') = nvl(hr_loc_shd.g_old_rec.address_line_3,' '))
235: and (nvl(p_rec.town_or_city,' ') = nvl(hr_loc_shd.g_old_rec.town_or_city,' '))
236: and (nvl(p_rec.region_1,' ') = nvl(hr_loc_shd.g_old_rec.region_1,' '))
237: and (nvl(p_rec.region_2,' ') = nvl(hr_loc_shd.g_old_rec.region_2,' '))
238: and (nvl(p_rec.region_3,' ') = nvl(hr_loc_shd.g_old_rec.region_3,' '))
239: and (nvl(p_rec.postal_code,' ') = nvl(hr_loc_shd.g_old_rec.postal_code,' '))
232: if((nvl(p_rec.address_line_1,' ') = nvl(hr_loc_shd.g_old_rec.address_line_1,' '))
233: and (nvl(p_rec.address_line_2,' ') = nvl(hr_loc_shd.g_old_rec.address_line_2,' '))
234: and (nvl(p_rec.address_line_3,' ') = nvl(hr_loc_shd.g_old_rec.address_line_3,' '))
235: and (nvl(p_rec.town_or_city,' ') = nvl(hr_loc_shd.g_old_rec.town_or_city,' '))
236: and (nvl(p_rec.region_1,' ') = nvl(hr_loc_shd.g_old_rec.region_1,' '))
237: and (nvl(p_rec.region_2,' ') = nvl(hr_loc_shd.g_old_rec.region_2,' '))
238: and (nvl(p_rec.region_3,' ') = nvl(hr_loc_shd.g_old_rec.region_3,' '))
239: and (nvl(p_rec.postal_code,' ') = nvl(hr_loc_shd.g_old_rec.postal_code,' '))
240: and (nvl(p_rec.country,' ') = nvl(hr_loc_shd.g_old_rec.country,' ')) ) then
233: and (nvl(p_rec.address_line_2,' ') = nvl(hr_loc_shd.g_old_rec.address_line_2,' '))
234: and (nvl(p_rec.address_line_3,' ') = nvl(hr_loc_shd.g_old_rec.address_line_3,' '))
235: and (nvl(p_rec.town_or_city,' ') = nvl(hr_loc_shd.g_old_rec.town_or_city,' '))
236: and (nvl(p_rec.region_1,' ') = nvl(hr_loc_shd.g_old_rec.region_1,' '))
237: and (nvl(p_rec.region_2,' ') = nvl(hr_loc_shd.g_old_rec.region_2,' '))
238: and (nvl(p_rec.region_3,' ') = nvl(hr_loc_shd.g_old_rec.region_3,' '))
239: and (nvl(p_rec.postal_code,' ') = nvl(hr_loc_shd.g_old_rec.postal_code,' '))
240: and (nvl(p_rec.country,' ') = nvl(hr_loc_shd.g_old_rec.country,' ')) ) then
241:
234: and (nvl(p_rec.address_line_3,' ') = nvl(hr_loc_shd.g_old_rec.address_line_3,' '))
235: and (nvl(p_rec.town_or_city,' ') = nvl(hr_loc_shd.g_old_rec.town_or_city,' '))
236: and (nvl(p_rec.region_1,' ') = nvl(hr_loc_shd.g_old_rec.region_1,' '))
237: and (nvl(p_rec.region_2,' ') = nvl(hr_loc_shd.g_old_rec.region_2,' '))
238: and (nvl(p_rec.region_3,' ') = nvl(hr_loc_shd.g_old_rec.region_3,' '))
239: and (nvl(p_rec.postal_code,' ') = nvl(hr_loc_shd.g_old_rec.postal_code,' '))
240: and (nvl(p_rec.country,' ') = nvl(hr_loc_shd.g_old_rec.country,' ')) ) then
241:
242: hr_utility.set_location('Not calling address2geometry:'||l_proc, 8);
235: and (nvl(p_rec.town_or_city,' ') = nvl(hr_loc_shd.g_old_rec.town_or_city,' '))
236: and (nvl(p_rec.region_1,' ') = nvl(hr_loc_shd.g_old_rec.region_1,' '))
237: and (nvl(p_rec.region_2,' ') = nvl(hr_loc_shd.g_old_rec.region_2,' '))
238: and (nvl(p_rec.region_3,' ') = nvl(hr_loc_shd.g_old_rec.region_3,' '))
239: and (nvl(p_rec.postal_code,' ') = nvl(hr_loc_shd.g_old_rec.postal_code,' '))
240: and (nvl(p_rec.country,' ') = nvl(hr_loc_shd.g_old_rec.country,' ')) ) then
241:
242: hr_utility.set_location('Not calling address2geometry:'||l_proc, 8);
243:
236: and (nvl(p_rec.region_1,' ') = nvl(hr_loc_shd.g_old_rec.region_1,' '))
237: and (nvl(p_rec.region_2,' ') = nvl(hr_loc_shd.g_old_rec.region_2,' '))
238: and (nvl(p_rec.region_3,' ') = nvl(hr_loc_shd.g_old_rec.region_3,' '))
239: and (nvl(p_rec.postal_code,' ') = nvl(hr_loc_shd.g_old_rec.postal_code,' '))
240: and (nvl(p_rec.country,' ') = nvl(hr_loc_shd.g_old_rec.country,' ')) ) then
241:
242: hr_utility.set_location('Not calling address2geometry:'||l_proc, 8);
243:
244: else
299: -- Internal Row Handler Use Only.
300: --
301: -- {End Of Comments}
302: -- ----------------------------------------------------------------------------
303: PROCEDURE post_update(p_rec IN hr_loc_shd.g_rec_type,
304: p_effective_date IN DATE) IS
305: --
306: l_proc VARCHAR2(72) := g_package||'post_update';
307: --
393: ,p_ece_tp_location_code => p_rec.ece_tp_location_code
394: ,p_object_version_number => p_rec.object_version_number
395: ,p_business_group_id => p_rec.business_group_id
396: --
397: ,p_location_code_o => hr_loc_shd.g_old_rec.location_code
398: ,p_address_line_1_o => hr_loc_shd.g_old_rec.address_line_1
399: ,p_address_line_2_o => hr_loc_shd.g_old_rec.address_line_2
400: ,p_address_line_3_o => hr_loc_shd.g_old_rec.address_line_3
401: ,p_bill_to_site_flag_o => hr_loc_shd.g_old_rec.bill_to_site_flag
394: ,p_object_version_number => p_rec.object_version_number
395: ,p_business_group_id => p_rec.business_group_id
396: --
397: ,p_location_code_o => hr_loc_shd.g_old_rec.location_code
398: ,p_address_line_1_o => hr_loc_shd.g_old_rec.address_line_1
399: ,p_address_line_2_o => hr_loc_shd.g_old_rec.address_line_2
400: ,p_address_line_3_o => hr_loc_shd.g_old_rec.address_line_3
401: ,p_bill_to_site_flag_o => hr_loc_shd.g_old_rec.bill_to_site_flag
402: ,p_country_o => hr_loc_shd.g_old_rec.country
395: ,p_business_group_id => p_rec.business_group_id
396: --
397: ,p_location_code_o => hr_loc_shd.g_old_rec.location_code
398: ,p_address_line_1_o => hr_loc_shd.g_old_rec.address_line_1
399: ,p_address_line_2_o => hr_loc_shd.g_old_rec.address_line_2
400: ,p_address_line_3_o => hr_loc_shd.g_old_rec.address_line_3
401: ,p_bill_to_site_flag_o => hr_loc_shd.g_old_rec.bill_to_site_flag
402: ,p_country_o => hr_loc_shd.g_old_rec.country
403: ,p_description_o => hr_loc_shd.g_old_rec.description
396: --
397: ,p_location_code_o => hr_loc_shd.g_old_rec.location_code
398: ,p_address_line_1_o => hr_loc_shd.g_old_rec.address_line_1
399: ,p_address_line_2_o => hr_loc_shd.g_old_rec.address_line_2
400: ,p_address_line_3_o => hr_loc_shd.g_old_rec.address_line_3
401: ,p_bill_to_site_flag_o => hr_loc_shd.g_old_rec.bill_to_site_flag
402: ,p_country_o => hr_loc_shd.g_old_rec.country
403: ,p_description_o => hr_loc_shd.g_old_rec.description
404: ,p_designated_receiver_id_o => hr_loc_shd.g_old_rec.designated_receiver_id
397: ,p_location_code_o => hr_loc_shd.g_old_rec.location_code
398: ,p_address_line_1_o => hr_loc_shd.g_old_rec.address_line_1
399: ,p_address_line_2_o => hr_loc_shd.g_old_rec.address_line_2
400: ,p_address_line_3_o => hr_loc_shd.g_old_rec.address_line_3
401: ,p_bill_to_site_flag_o => hr_loc_shd.g_old_rec.bill_to_site_flag
402: ,p_country_o => hr_loc_shd.g_old_rec.country
403: ,p_description_o => hr_loc_shd.g_old_rec.description
404: ,p_designated_receiver_id_o => hr_loc_shd.g_old_rec.designated_receiver_id
405: ,p_in_organization_flag_o => hr_loc_shd.g_old_rec.in_organization_flag
398: ,p_address_line_1_o => hr_loc_shd.g_old_rec.address_line_1
399: ,p_address_line_2_o => hr_loc_shd.g_old_rec.address_line_2
400: ,p_address_line_3_o => hr_loc_shd.g_old_rec.address_line_3
401: ,p_bill_to_site_flag_o => hr_loc_shd.g_old_rec.bill_to_site_flag
402: ,p_country_o => hr_loc_shd.g_old_rec.country
403: ,p_description_o => hr_loc_shd.g_old_rec.description
404: ,p_designated_receiver_id_o => hr_loc_shd.g_old_rec.designated_receiver_id
405: ,p_in_organization_flag_o => hr_loc_shd.g_old_rec.in_organization_flag
406: ,p_inactive_date_o => hr_loc_shd.g_old_rec.inactive_date
399: ,p_address_line_2_o => hr_loc_shd.g_old_rec.address_line_2
400: ,p_address_line_3_o => hr_loc_shd.g_old_rec.address_line_3
401: ,p_bill_to_site_flag_o => hr_loc_shd.g_old_rec.bill_to_site_flag
402: ,p_country_o => hr_loc_shd.g_old_rec.country
403: ,p_description_o => hr_loc_shd.g_old_rec.description
404: ,p_designated_receiver_id_o => hr_loc_shd.g_old_rec.designated_receiver_id
405: ,p_in_organization_flag_o => hr_loc_shd.g_old_rec.in_organization_flag
406: ,p_inactive_date_o => hr_loc_shd.g_old_rec.inactive_date
407: ,p_inventory_organization_id_o => hr_loc_shd.g_old_rec.inventory_organization_id
400: ,p_address_line_3_o => hr_loc_shd.g_old_rec.address_line_3
401: ,p_bill_to_site_flag_o => hr_loc_shd.g_old_rec.bill_to_site_flag
402: ,p_country_o => hr_loc_shd.g_old_rec.country
403: ,p_description_o => hr_loc_shd.g_old_rec.description
404: ,p_designated_receiver_id_o => hr_loc_shd.g_old_rec.designated_receiver_id
405: ,p_in_organization_flag_o => hr_loc_shd.g_old_rec.in_organization_flag
406: ,p_inactive_date_o => hr_loc_shd.g_old_rec.inactive_date
407: ,p_inventory_organization_id_o => hr_loc_shd.g_old_rec.inventory_organization_id
408: ,p_office_site_flag_o => hr_loc_shd.g_old_rec.office_site_flag
401: ,p_bill_to_site_flag_o => hr_loc_shd.g_old_rec.bill_to_site_flag
402: ,p_country_o => hr_loc_shd.g_old_rec.country
403: ,p_description_o => hr_loc_shd.g_old_rec.description
404: ,p_designated_receiver_id_o => hr_loc_shd.g_old_rec.designated_receiver_id
405: ,p_in_organization_flag_o => hr_loc_shd.g_old_rec.in_organization_flag
406: ,p_inactive_date_o => hr_loc_shd.g_old_rec.inactive_date
407: ,p_inventory_organization_id_o => hr_loc_shd.g_old_rec.inventory_organization_id
408: ,p_office_site_flag_o => hr_loc_shd.g_old_rec.office_site_flag
409: ,p_postal_code_o => hr_loc_shd.g_old_rec.postal_code
402: ,p_country_o => hr_loc_shd.g_old_rec.country
403: ,p_description_o => hr_loc_shd.g_old_rec.description
404: ,p_designated_receiver_id_o => hr_loc_shd.g_old_rec.designated_receiver_id
405: ,p_in_organization_flag_o => hr_loc_shd.g_old_rec.in_organization_flag
406: ,p_inactive_date_o => hr_loc_shd.g_old_rec.inactive_date
407: ,p_inventory_organization_id_o => hr_loc_shd.g_old_rec.inventory_organization_id
408: ,p_office_site_flag_o => hr_loc_shd.g_old_rec.office_site_flag
409: ,p_postal_code_o => hr_loc_shd.g_old_rec.postal_code
410: ,p_receiving_site_flag_o => hr_loc_shd.g_old_rec.receiving_site_flag
403: ,p_description_o => hr_loc_shd.g_old_rec.description
404: ,p_designated_receiver_id_o => hr_loc_shd.g_old_rec.designated_receiver_id
405: ,p_in_organization_flag_o => hr_loc_shd.g_old_rec.in_organization_flag
406: ,p_inactive_date_o => hr_loc_shd.g_old_rec.inactive_date
407: ,p_inventory_organization_id_o => hr_loc_shd.g_old_rec.inventory_organization_id
408: ,p_office_site_flag_o => hr_loc_shd.g_old_rec.office_site_flag
409: ,p_postal_code_o => hr_loc_shd.g_old_rec.postal_code
410: ,p_receiving_site_flag_o => hr_loc_shd.g_old_rec.receiving_site_flag
411: ,p_region_1_o => hr_loc_shd.g_old_rec.region_1
404: ,p_designated_receiver_id_o => hr_loc_shd.g_old_rec.designated_receiver_id
405: ,p_in_organization_flag_o => hr_loc_shd.g_old_rec.in_organization_flag
406: ,p_inactive_date_o => hr_loc_shd.g_old_rec.inactive_date
407: ,p_inventory_organization_id_o => hr_loc_shd.g_old_rec.inventory_organization_id
408: ,p_office_site_flag_o => hr_loc_shd.g_old_rec.office_site_flag
409: ,p_postal_code_o => hr_loc_shd.g_old_rec.postal_code
410: ,p_receiving_site_flag_o => hr_loc_shd.g_old_rec.receiving_site_flag
411: ,p_region_1_o => hr_loc_shd.g_old_rec.region_1
412: ,p_region_2_o => hr_loc_shd.g_old_rec.region_2
405: ,p_in_organization_flag_o => hr_loc_shd.g_old_rec.in_organization_flag
406: ,p_inactive_date_o => hr_loc_shd.g_old_rec.inactive_date
407: ,p_inventory_organization_id_o => hr_loc_shd.g_old_rec.inventory_organization_id
408: ,p_office_site_flag_o => hr_loc_shd.g_old_rec.office_site_flag
409: ,p_postal_code_o => hr_loc_shd.g_old_rec.postal_code
410: ,p_receiving_site_flag_o => hr_loc_shd.g_old_rec.receiving_site_flag
411: ,p_region_1_o => hr_loc_shd.g_old_rec.region_1
412: ,p_region_2_o => hr_loc_shd.g_old_rec.region_2
413: ,p_region_3_o => hr_loc_shd.g_old_rec.region_3
406: ,p_inactive_date_o => hr_loc_shd.g_old_rec.inactive_date
407: ,p_inventory_organization_id_o => hr_loc_shd.g_old_rec.inventory_organization_id
408: ,p_office_site_flag_o => hr_loc_shd.g_old_rec.office_site_flag
409: ,p_postal_code_o => hr_loc_shd.g_old_rec.postal_code
410: ,p_receiving_site_flag_o => hr_loc_shd.g_old_rec.receiving_site_flag
411: ,p_region_1_o => hr_loc_shd.g_old_rec.region_1
412: ,p_region_2_o => hr_loc_shd.g_old_rec.region_2
413: ,p_region_3_o => hr_loc_shd.g_old_rec.region_3
414: ,p_ship_to_location_id_o => hr_loc_shd.g_old_rec.ship_to_location_id
407: ,p_inventory_organization_id_o => hr_loc_shd.g_old_rec.inventory_organization_id
408: ,p_office_site_flag_o => hr_loc_shd.g_old_rec.office_site_flag
409: ,p_postal_code_o => hr_loc_shd.g_old_rec.postal_code
410: ,p_receiving_site_flag_o => hr_loc_shd.g_old_rec.receiving_site_flag
411: ,p_region_1_o => hr_loc_shd.g_old_rec.region_1
412: ,p_region_2_o => hr_loc_shd.g_old_rec.region_2
413: ,p_region_3_o => hr_loc_shd.g_old_rec.region_3
414: ,p_ship_to_location_id_o => hr_loc_shd.g_old_rec.ship_to_location_id
415: ,p_ship_to_site_flag_o => hr_loc_shd.g_old_rec.ship_to_site_flag
408: ,p_office_site_flag_o => hr_loc_shd.g_old_rec.office_site_flag
409: ,p_postal_code_o => hr_loc_shd.g_old_rec.postal_code
410: ,p_receiving_site_flag_o => hr_loc_shd.g_old_rec.receiving_site_flag
411: ,p_region_1_o => hr_loc_shd.g_old_rec.region_1
412: ,p_region_2_o => hr_loc_shd.g_old_rec.region_2
413: ,p_region_3_o => hr_loc_shd.g_old_rec.region_3
414: ,p_ship_to_location_id_o => hr_loc_shd.g_old_rec.ship_to_location_id
415: ,p_ship_to_site_flag_o => hr_loc_shd.g_old_rec.ship_to_site_flag
416: ,p_style_o => hr_loc_shd.g_old_rec.style
409: ,p_postal_code_o => hr_loc_shd.g_old_rec.postal_code
410: ,p_receiving_site_flag_o => hr_loc_shd.g_old_rec.receiving_site_flag
411: ,p_region_1_o => hr_loc_shd.g_old_rec.region_1
412: ,p_region_2_o => hr_loc_shd.g_old_rec.region_2
413: ,p_region_3_o => hr_loc_shd.g_old_rec.region_3
414: ,p_ship_to_location_id_o => hr_loc_shd.g_old_rec.ship_to_location_id
415: ,p_ship_to_site_flag_o => hr_loc_shd.g_old_rec.ship_to_site_flag
416: ,p_style_o => hr_loc_shd.g_old_rec.style
417: ,p_tax_name_o => hr_loc_shd.g_old_rec.tax_name
410: ,p_receiving_site_flag_o => hr_loc_shd.g_old_rec.receiving_site_flag
411: ,p_region_1_o => hr_loc_shd.g_old_rec.region_1
412: ,p_region_2_o => hr_loc_shd.g_old_rec.region_2
413: ,p_region_3_o => hr_loc_shd.g_old_rec.region_3
414: ,p_ship_to_location_id_o => hr_loc_shd.g_old_rec.ship_to_location_id
415: ,p_ship_to_site_flag_o => hr_loc_shd.g_old_rec.ship_to_site_flag
416: ,p_style_o => hr_loc_shd.g_old_rec.style
417: ,p_tax_name_o => hr_loc_shd.g_old_rec.tax_name
418: ,p_telephone_number_1_o => hr_loc_shd.g_old_rec.telephone_number_1
411: ,p_region_1_o => hr_loc_shd.g_old_rec.region_1
412: ,p_region_2_o => hr_loc_shd.g_old_rec.region_2
413: ,p_region_3_o => hr_loc_shd.g_old_rec.region_3
414: ,p_ship_to_location_id_o => hr_loc_shd.g_old_rec.ship_to_location_id
415: ,p_ship_to_site_flag_o => hr_loc_shd.g_old_rec.ship_to_site_flag
416: ,p_style_o => hr_loc_shd.g_old_rec.style
417: ,p_tax_name_o => hr_loc_shd.g_old_rec.tax_name
418: ,p_telephone_number_1_o => hr_loc_shd.g_old_rec.telephone_number_1
419: ,p_telephone_number_2_o => hr_loc_shd.g_old_rec.telephone_number_2
412: ,p_region_2_o => hr_loc_shd.g_old_rec.region_2
413: ,p_region_3_o => hr_loc_shd.g_old_rec.region_3
414: ,p_ship_to_location_id_o => hr_loc_shd.g_old_rec.ship_to_location_id
415: ,p_ship_to_site_flag_o => hr_loc_shd.g_old_rec.ship_to_site_flag
416: ,p_style_o => hr_loc_shd.g_old_rec.style
417: ,p_tax_name_o => hr_loc_shd.g_old_rec.tax_name
418: ,p_telephone_number_1_o => hr_loc_shd.g_old_rec.telephone_number_1
419: ,p_telephone_number_2_o => hr_loc_shd.g_old_rec.telephone_number_2
420: ,p_telephone_number_3_o => hr_loc_shd.g_old_rec.telephone_number_3
413: ,p_region_3_o => hr_loc_shd.g_old_rec.region_3
414: ,p_ship_to_location_id_o => hr_loc_shd.g_old_rec.ship_to_location_id
415: ,p_ship_to_site_flag_o => hr_loc_shd.g_old_rec.ship_to_site_flag
416: ,p_style_o => hr_loc_shd.g_old_rec.style
417: ,p_tax_name_o => hr_loc_shd.g_old_rec.tax_name
418: ,p_telephone_number_1_o => hr_loc_shd.g_old_rec.telephone_number_1
419: ,p_telephone_number_2_o => hr_loc_shd.g_old_rec.telephone_number_2
420: ,p_telephone_number_3_o => hr_loc_shd.g_old_rec.telephone_number_3
421: ,p_town_or_city_o => hr_loc_shd.g_old_rec.town_or_city
414: ,p_ship_to_location_id_o => hr_loc_shd.g_old_rec.ship_to_location_id
415: ,p_ship_to_site_flag_o => hr_loc_shd.g_old_rec.ship_to_site_flag
416: ,p_style_o => hr_loc_shd.g_old_rec.style
417: ,p_tax_name_o => hr_loc_shd.g_old_rec.tax_name
418: ,p_telephone_number_1_o => hr_loc_shd.g_old_rec.telephone_number_1
419: ,p_telephone_number_2_o => hr_loc_shd.g_old_rec.telephone_number_2
420: ,p_telephone_number_3_o => hr_loc_shd.g_old_rec.telephone_number_3
421: ,p_town_or_city_o => hr_loc_shd.g_old_rec.town_or_city
422: ,p_loc_information13_o => hr_loc_shd.g_old_rec.loc_information13
415: ,p_ship_to_site_flag_o => hr_loc_shd.g_old_rec.ship_to_site_flag
416: ,p_style_o => hr_loc_shd.g_old_rec.style
417: ,p_tax_name_o => hr_loc_shd.g_old_rec.tax_name
418: ,p_telephone_number_1_o => hr_loc_shd.g_old_rec.telephone_number_1
419: ,p_telephone_number_2_o => hr_loc_shd.g_old_rec.telephone_number_2
420: ,p_telephone_number_3_o => hr_loc_shd.g_old_rec.telephone_number_3
421: ,p_town_or_city_o => hr_loc_shd.g_old_rec.town_or_city
422: ,p_loc_information13_o => hr_loc_shd.g_old_rec.loc_information13
423: ,p_loc_information14_o => hr_loc_shd.g_old_rec.loc_information14
416: ,p_style_o => hr_loc_shd.g_old_rec.style
417: ,p_tax_name_o => hr_loc_shd.g_old_rec.tax_name
418: ,p_telephone_number_1_o => hr_loc_shd.g_old_rec.telephone_number_1
419: ,p_telephone_number_2_o => hr_loc_shd.g_old_rec.telephone_number_2
420: ,p_telephone_number_3_o => hr_loc_shd.g_old_rec.telephone_number_3
421: ,p_town_or_city_o => hr_loc_shd.g_old_rec.town_or_city
422: ,p_loc_information13_o => hr_loc_shd.g_old_rec.loc_information13
423: ,p_loc_information14_o => hr_loc_shd.g_old_rec.loc_information14
424: ,p_loc_information15_o => hr_loc_shd.g_old_rec.loc_information15
417: ,p_tax_name_o => hr_loc_shd.g_old_rec.tax_name
418: ,p_telephone_number_1_o => hr_loc_shd.g_old_rec.telephone_number_1
419: ,p_telephone_number_2_o => hr_loc_shd.g_old_rec.telephone_number_2
420: ,p_telephone_number_3_o => hr_loc_shd.g_old_rec.telephone_number_3
421: ,p_town_or_city_o => hr_loc_shd.g_old_rec.town_or_city
422: ,p_loc_information13_o => hr_loc_shd.g_old_rec.loc_information13
423: ,p_loc_information14_o => hr_loc_shd.g_old_rec.loc_information14
424: ,p_loc_information15_o => hr_loc_shd.g_old_rec.loc_information15
425: ,p_loc_information16_o => hr_loc_shd.g_old_rec.loc_information16
418: ,p_telephone_number_1_o => hr_loc_shd.g_old_rec.telephone_number_1
419: ,p_telephone_number_2_o => hr_loc_shd.g_old_rec.telephone_number_2
420: ,p_telephone_number_3_o => hr_loc_shd.g_old_rec.telephone_number_3
421: ,p_town_or_city_o => hr_loc_shd.g_old_rec.town_or_city
422: ,p_loc_information13_o => hr_loc_shd.g_old_rec.loc_information13
423: ,p_loc_information14_o => hr_loc_shd.g_old_rec.loc_information14
424: ,p_loc_information15_o => hr_loc_shd.g_old_rec.loc_information15
425: ,p_loc_information16_o => hr_loc_shd.g_old_rec.loc_information16
426: ,p_loc_information17_o => hr_loc_shd.g_old_rec.loc_information17
419: ,p_telephone_number_2_o => hr_loc_shd.g_old_rec.telephone_number_2
420: ,p_telephone_number_3_o => hr_loc_shd.g_old_rec.telephone_number_3
421: ,p_town_or_city_o => hr_loc_shd.g_old_rec.town_or_city
422: ,p_loc_information13_o => hr_loc_shd.g_old_rec.loc_information13
423: ,p_loc_information14_o => hr_loc_shd.g_old_rec.loc_information14
424: ,p_loc_information15_o => hr_loc_shd.g_old_rec.loc_information15
425: ,p_loc_information16_o => hr_loc_shd.g_old_rec.loc_information16
426: ,p_loc_information17_o => hr_loc_shd.g_old_rec.loc_information17
427: ,p_loc_information18_o => hr_loc_shd.g_old_rec.loc_information18
420: ,p_telephone_number_3_o => hr_loc_shd.g_old_rec.telephone_number_3
421: ,p_town_or_city_o => hr_loc_shd.g_old_rec.town_or_city
422: ,p_loc_information13_o => hr_loc_shd.g_old_rec.loc_information13
423: ,p_loc_information14_o => hr_loc_shd.g_old_rec.loc_information14
424: ,p_loc_information15_o => hr_loc_shd.g_old_rec.loc_information15
425: ,p_loc_information16_o => hr_loc_shd.g_old_rec.loc_information16
426: ,p_loc_information17_o => hr_loc_shd.g_old_rec.loc_information17
427: ,p_loc_information18_o => hr_loc_shd.g_old_rec.loc_information18
428: ,p_loc_information19_o => hr_loc_shd.g_old_rec.loc_information19
421: ,p_town_or_city_o => hr_loc_shd.g_old_rec.town_or_city
422: ,p_loc_information13_o => hr_loc_shd.g_old_rec.loc_information13
423: ,p_loc_information14_o => hr_loc_shd.g_old_rec.loc_information14
424: ,p_loc_information15_o => hr_loc_shd.g_old_rec.loc_information15
425: ,p_loc_information16_o => hr_loc_shd.g_old_rec.loc_information16
426: ,p_loc_information17_o => hr_loc_shd.g_old_rec.loc_information17
427: ,p_loc_information18_o => hr_loc_shd.g_old_rec.loc_information18
428: ,p_loc_information19_o => hr_loc_shd.g_old_rec.loc_information19
429: ,p_loc_information20_o => hr_loc_shd.g_old_rec.loc_information20
422: ,p_loc_information13_o => hr_loc_shd.g_old_rec.loc_information13
423: ,p_loc_information14_o => hr_loc_shd.g_old_rec.loc_information14
424: ,p_loc_information15_o => hr_loc_shd.g_old_rec.loc_information15
425: ,p_loc_information16_o => hr_loc_shd.g_old_rec.loc_information16
426: ,p_loc_information17_o => hr_loc_shd.g_old_rec.loc_information17
427: ,p_loc_information18_o => hr_loc_shd.g_old_rec.loc_information18
428: ,p_loc_information19_o => hr_loc_shd.g_old_rec.loc_information19
429: ,p_loc_information20_o => hr_loc_shd.g_old_rec.loc_information20
430: ,p_attribute_category_o => hr_loc_shd.g_old_rec.attribute_category
423: ,p_loc_information14_o => hr_loc_shd.g_old_rec.loc_information14
424: ,p_loc_information15_o => hr_loc_shd.g_old_rec.loc_information15
425: ,p_loc_information16_o => hr_loc_shd.g_old_rec.loc_information16
426: ,p_loc_information17_o => hr_loc_shd.g_old_rec.loc_information17
427: ,p_loc_information18_o => hr_loc_shd.g_old_rec.loc_information18
428: ,p_loc_information19_o => hr_loc_shd.g_old_rec.loc_information19
429: ,p_loc_information20_o => hr_loc_shd.g_old_rec.loc_information20
430: ,p_attribute_category_o => hr_loc_shd.g_old_rec.attribute_category
431: ,p_attribute1_o => hr_loc_shd.g_old_rec.attribute1
424: ,p_loc_information15_o => hr_loc_shd.g_old_rec.loc_information15
425: ,p_loc_information16_o => hr_loc_shd.g_old_rec.loc_information16
426: ,p_loc_information17_o => hr_loc_shd.g_old_rec.loc_information17
427: ,p_loc_information18_o => hr_loc_shd.g_old_rec.loc_information18
428: ,p_loc_information19_o => hr_loc_shd.g_old_rec.loc_information19
429: ,p_loc_information20_o => hr_loc_shd.g_old_rec.loc_information20
430: ,p_attribute_category_o => hr_loc_shd.g_old_rec.attribute_category
431: ,p_attribute1_o => hr_loc_shd.g_old_rec.attribute1
432: ,p_attribute2_o => hr_loc_shd.g_old_rec.attribute2
425: ,p_loc_information16_o => hr_loc_shd.g_old_rec.loc_information16
426: ,p_loc_information17_o => hr_loc_shd.g_old_rec.loc_information17
427: ,p_loc_information18_o => hr_loc_shd.g_old_rec.loc_information18
428: ,p_loc_information19_o => hr_loc_shd.g_old_rec.loc_information19
429: ,p_loc_information20_o => hr_loc_shd.g_old_rec.loc_information20
430: ,p_attribute_category_o => hr_loc_shd.g_old_rec.attribute_category
431: ,p_attribute1_o => hr_loc_shd.g_old_rec.attribute1
432: ,p_attribute2_o => hr_loc_shd.g_old_rec.attribute2
433: ,p_attribute3_o => hr_loc_shd.g_old_rec.attribute3
426: ,p_loc_information17_o => hr_loc_shd.g_old_rec.loc_information17
427: ,p_loc_information18_o => hr_loc_shd.g_old_rec.loc_information18
428: ,p_loc_information19_o => hr_loc_shd.g_old_rec.loc_information19
429: ,p_loc_information20_o => hr_loc_shd.g_old_rec.loc_information20
430: ,p_attribute_category_o => hr_loc_shd.g_old_rec.attribute_category
431: ,p_attribute1_o => hr_loc_shd.g_old_rec.attribute1
432: ,p_attribute2_o => hr_loc_shd.g_old_rec.attribute2
433: ,p_attribute3_o => hr_loc_shd.g_old_rec.attribute3
434: ,p_attribute4_o => hr_loc_shd.g_old_rec.attribute4
427: ,p_loc_information18_o => hr_loc_shd.g_old_rec.loc_information18
428: ,p_loc_information19_o => hr_loc_shd.g_old_rec.loc_information19
429: ,p_loc_information20_o => hr_loc_shd.g_old_rec.loc_information20
430: ,p_attribute_category_o => hr_loc_shd.g_old_rec.attribute_category
431: ,p_attribute1_o => hr_loc_shd.g_old_rec.attribute1
432: ,p_attribute2_o => hr_loc_shd.g_old_rec.attribute2
433: ,p_attribute3_o => hr_loc_shd.g_old_rec.attribute3
434: ,p_attribute4_o => hr_loc_shd.g_old_rec.attribute4
435: ,p_attribute5_o => hr_loc_shd.g_old_rec.attribute5
428: ,p_loc_information19_o => hr_loc_shd.g_old_rec.loc_information19
429: ,p_loc_information20_o => hr_loc_shd.g_old_rec.loc_information20
430: ,p_attribute_category_o => hr_loc_shd.g_old_rec.attribute_category
431: ,p_attribute1_o => hr_loc_shd.g_old_rec.attribute1
432: ,p_attribute2_o => hr_loc_shd.g_old_rec.attribute2
433: ,p_attribute3_o => hr_loc_shd.g_old_rec.attribute3
434: ,p_attribute4_o => hr_loc_shd.g_old_rec.attribute4
435: ,p_attribute5_o => hr_loc_shd.g_old_rec.attribute5
436: ,p_attribute6_o => hr_loc_shd.g_old_rec.attribute6
429: ,p_loc_information20_o => hr_loc_shd.g_old_rec.loc_information20
430: ,p_attribute_category_o => hr_loc_shd.g_old_rec.attribute_category
431: ,p_attribute1_o => hr_loc_shd.g_old_rec.attribute1
432: ,p_attribute2_o => hr_loc_shd.g_old_rec.attribute2
433: ,p_attribute3_o => hr_loc_shd.g_old_rec.attribute3
434: ,p_attribute4_o => hr_loc_shd.g_old_rec.attribute4
435: ,p_attribute5_o => hr_loc_shd.g_old_rec.attribute5
436: ,p_attribute6_o => hr_loc_shd.g_old_rec.attribute6
437: ,p_attribute7_o => hr_loc_shd.g_old_rec.attribute7
430: ,p_attribute_category_o => hr_loc_shd.g_old_rec.attribute_category
431: ,p_attribute1_o => hr_loc_shd.g_old_rec.attribute1
432: ,p_attribute2_o => hr_loc_shd.g_old_rec.attribute2
433: ,p_attribute3_o => hr_loc_shd.g_old_rec.attribute3
434: ,p_attribute4_o => hr_loc_shd.g_old_rec.attribute4
435: ,p_attribute5_o => hr_loc_shd.g_old_rec.attribute5
436: ,p_attribute6_o => hr_loc_shd.g_old_rec.attribute6
437: ,p_attribute7_o => hr_loc_shd.g_old_rec.attribute7
438: ,p_attribute8_o => hr_loc_shd.g_old_rec.attribute8
431: ,p_attribute1_o => hr_loc_shd.g_old_rec.attribute1
432: ,p_attribute2_o => hr_loc_shd.g_old_rec.attribute2
433: ,p_attribute3_o => hr_loc_shd.g_old_rec.attribute3
434: ,p_attribute4_o => hr_loc_shd.g_old_rec.attribute4
435: ,p_attribute5_o => hr_loc_shd.g_old_rec.attribute5
436: ,p_attribute6_o => hr_loc_shd.g_old_rec.attribute6
437: ,p_attribute7_o => hr_loc_shd.g_old_rec.attribute7
438: ,p_attribute8_o => hr_loc_shd.g_old_rec.attribute8
439: ,p_attribute9_o => hr_loc_shd.g_old_rec.attribute9
432: ,p_attribute2_o => hr_loc_shd.g_old_rec.attribute2
433: ,p_attribute3_o => hr_loc_shd.g_old_rec.attribute3
434: ,p_attribute4_o => hr_loc_shd.g_old_rec.attribute4
435: ,p_attribute5_o => hr_loc_shd.g_old_rec.attribute5
436: ,p_attribute6_o => hr_loc_shd.g_old_rec.attribute6
437: ,p_attribute7_o => hr_loc_shd.g_old_rec.attribute7
438: ,p_attribute8_o => hr_loc_shd.g_old_rec.attribute8
439: ,p_attribute9_o => hr_loc_shd.g_old_rec.attribute9
440: ,p_attribute10_o => hr_loc_shd.g_old_rec.attribute10
433: ,p_attribute3_o => hr_loc_shd.g_old_rec.attribute3
434: ,p_attribute4_o => hr_loc_shd.g_old_rec.attribute4
435: ,p_attribute5_o => hr_loc_shd.g_old_rec.attribute5
436: ,p_attribute6_o => hr_loc_shd.g_old_rec.attribute6
437: ,p_attribute7_o => hr_loc_shd.g_old_rec.attribute7
438: ,p_attribute8_o => hr_loc_shd.g_old_rec.attribute8
439: ,p_attribute9_o => hr_loc_shd.g_old_rec.attribute9
440: ,p_attribute10_o => hr_loc_shd.g_old_rec.attribute10
441: ,p_attribute11_o => hr_loc_shd.g_old_rec.attribute11
434: ,p_attribute4_o => hr_loc_shd.g_old_rec.attribute4
435: ,p_attribute5_o => hr_loc_shd.g_old_rec.attribute5
436: ,p_attribute6_o => hr_loc_shd.g_old_rec.attribute6
437: ,p_attribute7_o => hr_loc_shd.g_old_rec.attribute7
438: ,p_attribute8_o => hr_loc_shd.g_old_rec.attribute8
439: ,p_attribute9_o => hr_loc_shd.g_old_rec.attribute9
440: ,p_attribute10_o => hr_loc_shd.g_old_rec.attribute10
441: ,p_attribute11_o => hr_loc_shd.g_old_rec.attribute11
442: ,p_attribute12_o => hr_loc_shd.g_old_rec.attribute12
435: ,p_attribute5_o => hr_loc_shd.g_old_rec.attribute5
436: ,p_attribute6_o => hr_loc_shd.g_old_rec.attribute6
437: ,p_attribute7_o => hr_loc_shd.g_old_rec.attribute7
438: ,p_attribute8_o => hr_loc_shd.g_old_rec.attribute8
439: ,p_attribute9_o => hr_loc_shd.g_old_rec.attribute9
440: ,p_attribute10_o => hr_loc_shd.g_old_rec.attribute10
441: ,p_attribute11_o => hr_loc_shd.g_old_rec.attribute11
442: ,p_attribute12_o => hr_loc_shd.g_old_rec.attribute12
443: ,p_attribute13_o => hr_loc_shd.g_old_rec.attribute13
436: ,p_attribute6_o => hr_loc_shd.g_old_rec.attribute6
437: ,p_attribute7_o => hr_loc_shd.g_old_rec.attribute7
438: ,p_attribute8_o => hr_loc_shd.g_old_rec.attribute8
439: ,p_attribute9_o => hr_loc_shd.g_old_rec.attribute9
440: ,p_attribute10_o => hr_loc_shd.g_old_rec.attribute10
441: ,p_attribute11_o => hr_loc_shd.g_old_rec.attribute11
442: ,p_attribute12_o => hr_loc_shd.g_old_rec.attribute12
443: ,p_attribute13_o => hr_loc_shd.g_old_rec.attribute13
444: ,p_attribute14_o => hr_loc_shd.g_old_rec.attribute14
437: ,p_attribute7_o => hr_loc_shd.g_old_rec.attribute7
438: ,p_attribute8_o => hr_loc_shd.g_old_rec.attribute8
439: ,p_attribute9_o => hr_loc_shd.g_old_rec.attribute9
440: ,p_attribute10_o => hr_loc_shd.g_old_rec.attribute10
441: ,p_attribute11_o => hr_loc_shd.g_old_rec.attribute11
442: ,p_attribute12_o => hr_loc_shd.g_old_rec.attribute12
443: ,p_attribute13_o => hr_loc_shd.g_old_rec.attribute13
444: ,p_attribute14_o => hr_loc_shd.g_old_rec.attribute14
445: ,p_attribute15_o => hr_loc_shd.g_old_rec.attribute15
438: ,p_attribute8_o => hr_loc_shd.g_old_rec.attribute8
439: ,p_attribute9_o => hr_loc_shd.g_old_rec.attribute9
440: ,p_attribute10_o => hr_loc_shd.g_old_rec.attribute10
441: ,p_attribute11_o => hr_loc_shd.g_old_rec.attribute11
442: ,p_attribute12_o => hr_loc_shd.g_old_rec.attribute12
443: ,p_attribute13_o => hr_loc_shd.g_old_rec.attribute13
444: ,p_attribute14_o => hr_loc_shd.g_old_rec.attribute14
445: ,p_attribute15_o => hr_loc_shd.g_old_rec.attribute15
446: ,p_attribute16_o => hr_loc_shd.g_old_rec.attribute16
439: ,p_attribute9_o => hr_loc_shd.g_old_rec.attribute9
440: ,p_attribute10_o => hr_loc_shd.g_old_rec.attribute10
441: ,p_attribute11_o => hr_loc_shd.g_old_rec.attribute11
442: ,p_attribute12_o => hr_loc_shd.g_old_rec.attribute12
443: ,p_attribute13_o => hr_loc_shd.g_old_rec.attribute13
444: ,p_attribute14_o => hr_loc_shd.g_old_rec.attribute14
445: ,p_attribute15_o => hr_loc_shd.g_old_rec.attribute15
446: ,p_attribute16_o => hr_loc_shd.g_old_rec.attribute16
447: ,p_attribute17_o => hr_loc_shd.g_old_rec.attribute17
440: ,p_attribute10_o => hr_loc_shd.g_old_rec.attribute10
441: ,p_attribute11_o => hr_loc_shd.g_old_rec.attribute11
442: ,p_attribute12_o => hr_loc_shd.g_old_rec.attribute12
443: ,p_attribute13_o => hr_loc_shd.g_old_rec.attribute13
444: ,p_attribute14_o => hr_loc_shd.g_old_rec.attribute14
445: ,p_attribute15_o => hr_loc_shd.g_old_rec.attribute15
446: ,p_attribute16_o => hr_loc_shd.g_old_rec.attribute16
447: ,p_attribute17_o => hr_loc_shd.g_old_rec.attribute17
448: ,p_attribute18_o => hr_loc_shd.g_old_rec.attribute18
441: ,p_attribute11_o => hr_loc_shd.g_old_rec.attribute11
442: ,p_attribute12_o => hr_loc_shd.g_old_rec.attribute12
443: ,p_attribute13_o => hr_loc_shd.g_old_rec.attribute13
444: ,p_attribute14_o => hr_loc_shd.g_old_rec.attribute14
445: ,p_attribute15_o => hr_loc_shd.g_old_rec.attribute15
446: ,p_attribute16_o => hr_loc_shd.g_old_rec.attribute16
447: ,p_attribute17_o => hr_loc_shd.g_old_rec.attribute17
448: ,p_attribute18_o => hr_loc_shd.g_old_rec.attribute18
449: ,p_attribute19_o => hr_loc_shd.g_old_rec.attribute19
442: ,p_attribute12_o => hr_loc_shd.g_old_rec.attribute12
443: ,p_attribute13_o => hr_loc_shd.g_old_rec.attribute13
444: ,p_attribute14_o => hr_loc_shd.g_old_rec.attribute14
445: ,p_attribute15_o => hr_loc_shd.g_old_rec.attribute15
446: ,p_attribute16_o => hr_loc_shd.g_old_rec.attribute16
447: ,p_attribute17_o => hr_loc_shd.g_old_rec.attribute17
448: ,p_attribute18_o => hr_loc_shd.g_old_rec.attribute18
449: ,p_attribute19_o => hr_loc_shd.g_old_rec.attribute19
450: ,p_attribute20_o => hr_loc_shd.g_old_rec.attribute20
443: ,p_attribute13_o => hr_loc_shd.g_old_rec.attribute13
444: ,p_attribute14_o => hr_loc_shd.g_old_rec.attribute14
445: ,p_attribute15_o => hr_loc_shd.g_old_rec.attribute15
446: ,p_attribute16_o => hr_loc_shd.g_old_rec.attribute16
447: ,p_attribute17_o => hr_loc_shd.g_old_rec.attribute17
448: ,p_attribute18_o => hr_loc_shd.g_old_rec.attribute18
449: ,p_attribute19_o => hr_loc_shd.g_old_rec.attribute19
450: ,p_attribute20_o => hr_loc_shd.g_old_rec.attribute20
451: ,p_global_attribute_category_o => hr_loc_shd.g_old_rec.global_attribute_category
444: ,p_attribute14_o => hr_loc_shd.g_old_rec.attribute14
445: ,p_attribute15_o => hr_loc_shd.g_old_rec.attribute15
446: ,p_attribute16_o => hr_loc_shd.g_old_rec.attribute16
447: ,p_attribute17_o => hr_loc_shd.g_old_rec.attribute17
448: ,p_attribute18_o => hr_loc_shd.g_old_rec.attribute18
449: ,p_attribute19_o => hr_loc_shd.g_old_rec.attribute19
450: ,p_attribute20_o => hr_loc_shd.g_old_rec.attribute20
451: ,p_global_attribute_category_o => hr_loc_shd.g_old_rec.global_attribute_category
452: ,p_global_attribute1_o => hr_loc_shd.g_old_rec.global_attribute1
445: ,p_attribute15_o => hr_loc_shd.g_old_rec.attribute15
446: ,p_attribute16_o => hr_loc_shd.g_old_rec.attribute16
447: ,p_attribute17_o => hr_loc_shd.g_old_rec.attribute17
448: ,p_attribute18_o => hr_loc_shd.g_old_rec.attribute18
449: ,p_attribute19_o => hr_loc_shd.g_old_rec.attribute19
450: ,p_attribute20_o => hr_loc_shd.g_old_rec.attribute20
451: ,p_global_attribute_category_o => hr_loc_shd.g_old_rec.global_attribute_category
452: ,p_global_attribute1_o => hr_loc_shd.g_old_rec.global_attribute1
453: ,p_global_attribute2_o => hr_loc_shd.g_old_rec.global_attribute2
446: ,p_attribute16_o => hr_loc_shd.g_old_rec.attribute16
447: ,p_attribute17_o => hr_loc_shd.g_old_rec.attribute17
448: ,p_attribute18_o => hr_loc_shd.g_old_rec.attribute18
449: ,p_attribute19_o => hr_loc_shd.g_old_rec.attribute19
450: ,p_attribute20_o => hr_loc_shd.g_old_rec.attribute20
451: ,p_global_attribute_category_o => hr_loc_shd.g_old_rec.global_attribute_category
452: ,p_global_attribute1_o => hr_loc_shd.g_old_rec.global_attribute1
453: ,p_global_attribute2_o => hr_loc_shd.g_old_rec.global_attribute2
454: ,p_global_attribute3_o => hr_loc_shd.g_old_rec.global_attribute3
447: ,p_attribute17_o => hr_loc_shd.g_old_rec.attribute17
448: ,p_attribute18_o => hr_loc_shd.g_old_rec.attribute18
449: ,p_attribute19_o => hr_loc_shd.g_old_rec.attribute19
450: ,p_attribute20_o => hr_loc_shd.g_old_rec.attribute20
451: ,p_global_attribute_category_o => hr_loc_shd.g_old_rec.global_attribute_category
452: ,p_global_attribute1_o => hr_loc_shd.g_old_rec.global_attribute1
453: ,p_global_attribute2_o => hr_loc_shd.g_old_rec.global_attribute2
454: ,p_global_attribute3_o => hr_loc_shd.g_old_rec.global_attribute3
455: ,p_global_attribute4_o => hr_loc_shd.g_old_rec.global_attribute4
448: ,p_attribute18_o => hr_loc_shd.g_old_rec.attribute18
449: ,p_attribute19_o => hr_loc_shd.g_old_rec.attribute19
450: ,p_attribute20_o => hr_loc_shd.g_old_rec.attribute20
451: ,p_global_attribute_category_o => hr_loc_shd.g_old_rec.global_attribute_category
452: ,p_global_attribute1_o => hr_loc_shd.g_old_rec.global_attribute1
453: ,p_global_attribute2_o => hr_loc_shd.g_old_rec.global_attribute2
454: ,p_global_attribute3_o => hr_loc_shd.g_old_rec.global_attribute3
455: ,p_global_attribute4_o => hr_loc_shd.g_old_rec.global_attribute4
456: ,p_global_attribute5_o => hr_loc_shd.g_old_rec.global_attribute5
449: ,p_attribute19_o => hr_loc_shd.g_old_rec.attribute19
450: ,p_attribute20_o => hr_loc_shd.g_old_rec.attribute20
451: ,p_global_attribute_category_o => hr_loc_shd.g_old_rec.global_attribute_category
452: ,p_global_attribute1_o => hr_loc_shd.g_old_rec.global_attribute1
453: ,p_global_attribute2_o => hr_loc_shd.g_old_rec.global_attribute2
454: ,p_global_attribute3_o => hr_loc_shd.g_old_rec.global_attribute3
455: ,p_global_attribute4_o => hr_loc_shd.g_old_rec.global_attribute4
456: ,p_global_attribute5_o => hr_loc_shd.g_old_rec.global_attribute5
457: ,p_global_attribute6_o => hr_loc_shd.g_old_rec.global_attribute6
450: ,p_attribute20_o => hr_loc_shd.g_old_rec.attribute20
451: ,p_global_attribute_category_o => hr_loc_shd.g_old_rec.global_attribute_category
452: ,p_global_attribute1_o => hr_loc_shd.g_old_rec.global_attribute1
453: ,p_global_attribute2_o => hr_loc_shd.g_old_rec.global_attribute2
454: ,p_global_attribute3_o => hr_loc_shd.g_old_rec.global_attribute3
455: ,p_global_attribute4_o => hr_loc_shd.g_old_rec.global_attribute4
456: ,p_global_attribute5_o => hr_loc_shd.g_old_rec.global_attribute5
457: ,p_global_attribute6_o => hr_loc_shd.g_old_rec.global_attribute6
458: ,p_global_attribute7_o => hr_loc_shd.g_old_rec.global_attribute7
451: ,p_global_attribute_category_o => hr_loc_shd.g_old_rec.global_attribute_category
452: ,p_global_attribute1_o => hr_loc_shd.g_old_rec.global_attribute1
453: ,p_global_attribute2_o => hr_loc_shd.g_old_rec.global_attribute2
454: ,p_global_attribute3_o => hr_loc_shd.g_old_rec.global_attribute3
455: ,p_global_attribute4_o => hr_loc_shd.g_old_rec.global_attribute4
456: ,p_global_attribute5_o => hr_loc_shd.g_old_rec.global_attribute5
457: ,p_global_attribute6_o => hr_loc_shd.g_old_rec.global_attribute6
458: ,p_global_attribute7_o => hr_loc_shd.g_old_rec.global_attribute7
459: ,p_global_attribute8_o => hr_loc_shd.g_old_rec.global_attribute8
452: ,p_global_attribute1_o => hr_loc_shd.g_old_rec.global_attribute1
453: ,p_global_attribute2_o => hr_loc_shd.g_old_rec.global_attribute2
454: ,p_global_attribute3_o => hr_loc_shd.g_old_rec.global_attribute3
455: ,p_global_attribute4_o => hr_loc_shd.g_old_rec.global_attribute4
456: ,p_global_attribute5_o => hr_loc_shd.g_old_rec.global_attribute5
457: ,p_global_attribute6_o => hr_loc_shd.g_old_rec.global_attribute6
458: ,p_global_attribute7_o => hr_loc_shd.g_old_rec.global_attribute7
459: ,p_global_attribute8_o => hr_loc_shd.g_old_rec.global_attribute8
460: ,p_global_attribute9_o => hr_loc_shd.g_old_rec.global_attribute9
453: ,p_global_attribute2_o => hr_loc_shd.g_old_rec.global_attribute2
454: ,p_global_attribute3_o => hr_loc_shd.g_old_rec.global_attribute3
455: ,p_global_attribute4_o => hr_loc_shd.g_old_rec.global_attribute4
456: ,p_global_attribute5_o => hr_loc_shd.g_old_rec.global_attribute5
457: ,p_global_attribute6_o => hr_loc_shd.g_old_rec.global_attribute6
458: ,p_global_attribute7_o => hr_loc_shd.g_old_rec.global_attribute7
459: ,p_global_attribute8_o => hr_loc_shd.g_old_rec.global_attribute8
460: ,p_global_attribute9_o => hr_loc_shd.g_old_rec.global_attribute9
461: ,p_global_attribute10_o => hr_loc_shd.g_old_rec.global_attribute10
454: ,p_global_attribute3_o => hr_loc_shd.g_old_rec.global_attribute3
455: ,p_global_attribute4_o => hr_loc_shd.g_old_rec.global_attribute4
456: ,p_global_attribute5_o => hr_loc_shd.g_old_rec.global_attribute5
457: ,p_global_attribute6_o => hr_loc_shd.g_old_rec.global_attribute6
458: ,p_global_attribute7_o => hr_loc_shd.g_old_rec.global_attribute7
459: ,p_global_attribute8_o => hr_loc_shd.g_old_rec.global_attribute8
460: ,p_global_attribute9_o => hr_loc_shd.g_old_rec.global_attribute9
461: ,p_global_attribute10_o => hr_loc_shd.g_old_rec.global_attribute10
462: ,p_global_attribute11_o => hr_loc_shd.g_old_rec.global_attribute11
455: ,p_global_attribute4_o => hr_loc_shd.g_old_rec.global_attribute4
456: ,p_global_attribute5_o => hr_loc_shd.g_old_rec.global_attribute5
457: ,p_global_attribute6_o => hr_loc_shd.g_old_rec.global_attribute6
458: ,p_global_attribute7_o => hr_loc_shd.g_old_rec.global_attribute7
459: ,p_global_attribute8_o => hr_loc_shd.g_old_rec.global_attribute8
460: ,p_global_attribute9_o => hr_loc_shd.g_old_rec.global_attribute9
461: ,p_global_attribute10_o => hr_loc_shd.g_old_rec.global_attribute10
462: ,p_global_attribute11_o => hr_loc_shd.g_old_rec.global_attribute11
463: ,p_global_attribute12_o => hr_loc_shd.g_old_rec.global_attribute12
456: ,p_global_attribute5_o => hr_loc_shd.g_old_rec.global_attribute5
457: ,p_global_attribute6_o => hr_loc_shd.g_old_rec.global_attribute6
458: ,p_global_attribute7_o => hr_loc_shd.g_old_rec.global_attribute7
459: ,p_global_attribute8_o => hr_loc_shd.g_old_rec.global_attribute8
460: ,p_global_attribute9_o => hr_loc_shd.g_old_rec.global_attribute9
461: ,p_global_attribute10_o => hr_loc_shd.g_old_rec.global_attribute10
462: ,p_global_attribute11_o => hr_loc_shd.g_old_rec.global_attribute11
463: ,p_global_attribute12_o => hr_loc_shd.g_old_rec.global_attribute12
464: ,p_global_attribute13_o => hr_loc_shd.g_old_rec.global_attribute13
457: ,p_global_attribute6_o => hr_loc_shd.g_old_rec.global_attribute6
458: ,p_global_attribute7_o => hr_loc_shd.g_old_rec.global_attribute7
459: ,p_global_attribute8_o => hr_loc_shd.g_old_rec.global_attribute8
460: ,p_global_attribute9_o => hr_loc_shd.g_old_rec.global_attribute9
461: ,p_global_attribute10_o => hr_loc_shd.g_old_rec.global_attribute10
462: ,p_global_attribute11_o => hr_loc_shd.g_old_rec.global_attribute11
463: ,p_global_attribute12_o => hr_loc_shd.g_old_rec.global_attribute12
464: ,p_global_attribute13_o => hr_loc_shd.g_old_rec.global_attribute13
465: ,p_global_attribute14_o => hr_loc_shd.g_old_rec.global_attribute14
458: ,p_global_attribute7_o => hr_loc_shd.g_old_rec.global_attribute7
459: ,p_global_attribute8_o => hr_loc_shd.g_old_rec.global_attribute8
460: ,p_global_attribute9_o => hr_loc_shd.g_old_rec.global_attribute9
461: ,p_global_attribute10_o => hr_loc_shd.g_old_rec.global_attribute10
462: ,p_global_attribute11_o => hr_loc_shd.g_old_rec.global_attribute11
463: ,p_global_attribute12_o => hr_loc_shd.g_old_rec.global_attribute12
464: ,p_global_attribute13_o => hr_loc_shd.g_old_rec.global_attribute13
465: ,p_global_attribute14_o => hr_loc_shd.g_old_rec.global_attribute14
466: ,p_global_attribute15_o => hr_loc_shd.g_old_rec.global_attribute15
459: ,p_global_attribute8_o => hr_loc_shd.g_old_rec.global_attribute8
460: ,p_global_attribute9_o => hr_loc_shd.g_old_rec.global_attribute9
461: ,p_global_attribute10_o => hr_loc_shd.g_old_rec.global_attribute10
462: ,p_global_attribute11_o => hr_loc_shd.g_old_rec.global_attribute11
463: ,p_global_attribute12_o => hr_loc_shd.g_old_rec.global_attribute12
464: ,p_global_attribute13_o => hr_loc_shd.g_old_rec.global_attribute13
465: ,p_global_attribute14_o => hr_loc_shd.g_old_rec.global_attribute14
466: ,p_global_attribute15_o => hr_loc_shd.g_old_rec.global_attribute15
467: ,p_global_attribute16_o => hr_loc_shd.g_old_rec.global_attribute16
460: ,p_global_attribute9_o => hr_loc_shd.g_old_rec.global_attribute9
461: ,p_global_attribute10_o => hr_loc_shd.g_old_rec.global_attribute10
462: ,p_global_attribute11_o => hr_loc_shd.g_old_rec.global_attribute11
463: ,p_global_attribute12_o => hr_loc_shd.g_old_rec.global_attribute12
464: ,p_global_attribute13_o => hr_loc_shd.g_old_rec.global_attribute13
465: ,p_global_attribute14_o => hr_loc_shd.g_old_rec.global_attribute14
466: ,p_global_attribute15_o => hr_loc_shd.g_old_rec.global_attribute15
467: ,p_global_attribute16_o => hr_loc_shd.g_old_rec.global_attribute16
468: ,p_global_attribute17_o => hr_loc_shd.g_old_rec.global_attribute17
461: ,p_global_attribute10_o => hr_loc_shd.g_old_rec.global_attribute10
462: ,p_global_attribute11_o => hr_loc_shd.g_old_rec.global_attribute11
463: ,p_global_attribute12_o => hr_loc_shd.g_old_rec.global_attribute12
464: ,p_global_attribute13_o => hr_loc_shd.g_old_rec.global_attribute13
465: ,p_global_attribute14_o => hr_loc_shd.g_old_rec.global_attribute14
466: ,p_global_attribute15_o => hr_loc_shd.g_old_rec.global_attribute15
467: ,p_global_attribute16_o => hr_loc_shd.g_old_rec.global_attribute16
468: ,p_global_attribute17_o => hr_loc_shd.g_old_rec.global_attribute17
469: ,p_global_attribute18_o => hr_loc_shd.g_old_rec.global_attribute18
462: ,p_global_attribute11_o => hr_loc_shd.g_old_rec.global_attribute11
463: ,p_global_attribute12_o => hr_loc_shd.g_old_rec.global_attribute12
464: ,p_global_attribute13_o => hr_loc_shd.g_old_rec.global_attribute13
465: ,p_global_attribute14_o => hr_loc_shd.g_old_rec.global_attribute14
466: ,p_global_attribute15_o => hr_loc_shd.g_old_rec.global_attribute15
467: ,p_global_attribute16_o => hr_loc_shd.g_old_rec.global_attribute16
468: ,p_global_attribute17_o => hr_loc_shd.g_old_rec.global_attribute17
469: ,p_global_attribute18_o => hr_loc_shd.g_old_rec.global_attribute18
470: ,p_global_attribute19_o => hr_loc_shd.g_old_rec.global_attribute19
463: ,p_global_attribute12_o => hr_loc_shd.g_old_rec.global_attribute12
464: ,p_global_attribute13_o => hr_loc_shd.g_old_rec.global_attribute13
465: ,p_global_attribute14_o => hr_loc_shd.g_old_rec.global_attribute14
466: ,p_global_attribute15_o => hr_loc_shd.g_old_rec.global_attribute15
467: ,p_global_attribute16_o => hr_loc_shd.g_old_rec.global_attribute16
468: ,p_global_attribute17_o => hr_loc_shd.g_old_rec.global_attribute17
469: ,p_global_attribute18_o => hr_loc_shd.g_old_rec.global_attribute18
470: ,p_global_attribute19_o => hr_loc_shd.g_old_rec.global_attribute19
471: ,p_global_attribute20_o => hr_loc_shd.g_old_rec.global_attribute20
464: ,p_global_attribute13_o => hr_loc_shd.g_old_rec.global_attribute13
465: ,p_global_attribute14_o => hr_loc_shd.g_old_rec.global_attribute14
466: ,p_global_attribute15_o => hr_loc_shd.g_old_rec.global_attribute15
467: ,p_global_attribute16_o => hr_loc_shd.g_old_rec.global_attribute16
468: ,p_global_attribute17_o => hr_loc_shd.g_old_rec.global_attribute17
469: ,p_global_attribute18_o => hr_loc_shd.g_old_rec.global_attribute18
470: ,p_global_attribute19_o => hr_loc_shd.g_old_rec.global_attribute19
471: ,p_global_attribute20_o => hr_loc_shd.g_old_rec.global_attribute20
472: ,p_legal_address_flag_o => hr_loc_shd.g_old_rec.legal_address_flag
465: ,p_global_attribute14_o => hr_loc_shd.g_old_rec.global_attribute14
466: ,p_global_attribute15_o => hr_loc_shd.g_old_rec.global_attribute15
467: ,p_global_attribute16_o => hr_loc_shd.g_old_rec.global_attribute16
468: ,p_global_attribute17_o => hr_loc_shd.g_old_rec.global_attribute17
469: ,p_global_attribute18_o => hr_loc_shd.g_old_rec.global_attribute18
470: ,p_global_attribute19_o => hr_loc_shd.g_old_rec.global_attribute19
471: ,p_global_attribute20_o => hr_loc_shd.g_old_rec.global_attribute20
472: ,p_legal_address_flag_o => hr_loc_shd.g_old_rec.legal_address_flag
473: ,p_tp_header_id_o => hr_loc_shd.g_old_rec.tp_header_id
466: ,p_global_attribute15_o => hr_loc_shd.g_old_rec.global_attribute15
467: ,p_global_attribute16_o => hr_loc_shd.g_old_rec.global_attribute16
468: ,p_global_attribute17_o => hr_loc_shd.g_old_rec.global_attribute17
469: ,p_global_attribute18_o => hr_loc_shd.g_old_rec.global_attribute18
470: ,p_global_attribute19_o => hr_loc_shd.g_old_rec.global_attribute19
471: ,p_global_attribute20_o => hr_loc_shd.g_old_rec.global_attribute20
472: ,p_legal_address_flag_o => hr_loc_shd.g_old_rec.legal_address_flag
473: ,p_tp_header_id_o => hr_loc_shd.g_old_rec.tp_header_id
474: ,p_ece_tp_location_code_o => hr_loc_shd.g_old_rec.ece_tp_location_code
467: ,p_global_attribute16_o => hr_loc_shd.g_old_rec.global_attribute16
468: ,p_global_attribute17_o => hr_loc_shd.g_old_rec.global_attribute17
469: ,p_global_attribute18_o => hr_loc_shd.g_old_rec.global_attribute18
470: ,p_global_attribute19_o => hr_loc_shd.g_old_rec.global_attribute19
471: ,p_global_attribute20_o => hr_loc_shd.g_old_rec.global_attribute20
472: ,p_legal_address_flag_o => hr_loc_shd.g_old_rec.legal_address_flag
473: ,p_tp_header_id_o => hr_loc_shd.g_old_rec.tp_header_id
474: ,p_ece_tp_location_code_o => hr_loc_shd.g_old_rec.ece_tp_location_code
475: ,p_object_version_number_o => hr_loc_shd.g_old_rec.object_version_number
468: ,p_global_attribute17_o => hr_loc_shd.g_old_rec.global_attribute17
469: ,p_global_attribute18_o => hr_loc_shd.g_old_rec.global_attribute18
470: ,p_global_attribute19_o => hr_loc_shd.g_old_rec.global_attribute19
471: ,p_global_attribute20_o => hr_loc_shd.g_old_rec.global_attribute20
472: ,p_legal_address_flag_o => hr_loc_shd.g_old_rec.legal_address_flag
473: ,p_tp_header_id_o => hr_loc_shd.g_old_rec.tp_header_id
474: ,p_ece_tp_location_code_o => hr_loc_shd.g_old_rec.ece_tp_location_code
475: ,p_object_version_number_o => hr_loc_shd.g_old_rec.object_version_number
476: ,p_business_group_id_o => hr_loc_shd.g_old_rec.business_group_id
469: ,p_global_attribute18_o => hr_loc_shd.g_old_rec.global_attribute18
470: ,p_global_attribute19_o => hr_loc_shd.g_old_rec.global_attribute19
471: ,p_global_attribute20_o => hr_loc_shd.g_old_rec.global_attribute20
472: ,p_legal_address_flag_o => hr_loc_shd.g_old_rec.legal_address_flag
473: ,p_tp_header_id_o => hr_loc_shd.g_old_rec.tp_header_id
474: ,p_ece_tp_location_code_o => hr_loc_shd.g_old_rec.ece_tp_location_code
475: ,p_object_version_number_o => hr_loc_shd.g_old_rec.object_version_number
476: ,p_business_group_id_o => hr_loc_shd.g_old_rec.business_group_id
477: );
470: ,p_global_attribute19_o => hr_loc_shd.g_old_rec.global_attribute19
471: ,p_global_attribute20_o => hr_loc_shd.g_old_rec.global_attribute20
472: ,p_legal_address_flag_o => hr_loc_shd.g_old_rec.legal_address_flag
473: ,p_tp_header_id_o => hr_loc_shd.g_old_rec.tp_header_id
474: ,p_ece_tp_location_code_o => hr_loc_shd.g_old_rec.ece_tp_location_code
475: ,p_object_version_number_o => hr_loc_shd.g_old_rec.object_version_number
476: ,p_business_group_id_o => hr_loc_shd.g_old_rec.business_group_id
477: );
478: EXCEPTION
471: ,p_global_attribute20_o => hr_loc_shd.g_old_rec.global_attribute20
472: ,p_legal_address_flag_o => hr_loc_shd.g_old_rec.legal_address_flag
473: ,p_tp_header_id_o => hr_loc_shd.g_old_rec.tp_header_id
474: ,p_ece_tp_location_code_o => hr_loc_shd.g_old_rec.ece_tp_location_code
475: ,p_object_version_number_o => hr_loc_shd.g_old_rec.object_version_number
476: ,p_business_group_id_o => hr_loc_shd.g_old_rec.business_group_id
477: );
478: EXCEPTION
479: WHEN hr_api.cannot_find_prog_unit THEN
472: ,p_legal_address_flag_o => hr_loc_shd.g_old_rec.legal_address_flag
473: ,p_tp_header_id_o => hr_loc_shd.g_old_rec.tp_header_id
474: ,p_ece_tp_location_code_o => hr_loc_shd.g_old_rec.ece_tp_location_code
475: ,p_object_version_number_o => hr_loc_shd.g_old_rec.object_version_number
476: ,p_business_group_id_o => hr_loc_shd.g_old_rec.business_group_id
477: );
478: EXCEPTION
479: WHEN hr_api.cannot_find_prog_unit THEN
480: hr_api.cannot_find_prog_unit_error
530: -- Internal Row Handler Use Only.
531: --
532: -- {End Of Comments}
533: -- ----------------------------------------------------------------------------
534: PROCEDURE convert_defs(p_rec IN OUT NOCOPY hr_loc_shd.g_rec_type) IS
535: --
536: l_proc VARCHAR2(72) := g_package||'convert_defs';
537: --
538: BEGIN
545: -- is being used then we must set to the 'current' argument value.
546: --
547: IF (p_rec.entered_by = hr_api.g_number) THEN
548: p_rec.entered_by :=
549: hr_loc_shd.g_old_rec.entered_by;
550: END IF;
551: IF (p_rec.location_code = hr_api.g_varchar2) THEN
552: p_rec.location_code :=
553: hr_loc_shd.g_old_rec.location_code;
549: hr_loc_shd.g_old_rec.entered_by;
550: END IF;
551: IF (p_rec.location_code = hr_api.g_varchar2) THEN
552: p_rec.location_code :=
553: hr_loc_shd.g_old_rec.location_code;
554: END IF;
555: IF (p_rec.address_line_1 = hr_api.g_varchar2) THEN
556: p_rec.address_line_1 :=
557: hr_loc_shd.g_old_rec.address_line_1;
553: hr_loc_shd.g_old_rec.location_code;
554: END IF;
555: IF (p_rec.address_line_1 = hr_api.g_varchar2) THEN
556: p_rec.address_line_1 :=
557: hr_loc_shd.g_old_rec.address_line_1;
558: END IF;
559: IF (p_rec.address_line_2 = hr_api.g_varchar2) THEN
560: p_rec.address_line_2 :=
561: hr_loc_shd.g_old_rec.address_line_2;
557: hr_loc_shd.g_old_rec.address_line_1;
558: END IF;
559: IF (p_rec.address_line_2 = hr_api.g_varchar2) THEN
560: p_rec.address_line_2 :=
561: hr_loc_shd.g_old_rec.address_line_2;
562: END IF;
563: IF (p_rec.address_line_3 = hr_api.g_varchar2) THEN
564: p_rec.address_line_3 :=
565: hr_loc_shd.g_old_rec.address_line_3;
561: hr_loc_shd.g_old_rec.address_line_2;
562: END IF;
563: IF (p_rec.address_line_3 = hr_api.g_varchar2) THEN
564: p_rec.address_line_3 :=
565: hr_loc_shd.g_old_rec.address_line_3;
566: END IF;
567: IF (p_rec.bill_to_site_flag = hr_api.g_varchar2) THEN
568: p_rec.bill_to_site_flag :=
569: hr_loc_shd.g_old_rec.bill_to_site_flag;
565: hr_loc_shd.g_old_rec.address_line_3;
566: END IF;
567: IF (p_rec.bill_to_site_flag = hr_api.g_varchar2) THEN
568: p_rec.bill_to_site_flag :=
569: hr_loc_shd.g_old_rec.bill_to_site_flag;
570: END IF;
571: IF (p_rec.country = hr_api.g_varchar2) THEN
572: p_rec.country :=
573: hr_loc_shd.g_old_rec.country;
569: hr_loc_shd.g_old_rec.bill_to_site_flag;
570: END IF;
571: IF (p_rec.country = hr_api.g_varchar2) THEN
572: p_rec.country :=
573: hr_loc_shd.g_old_rec.country;
574: END IF;
575: IF (p_rec.description = hr_api.g_varchar2) THEN
576: p_rec.description :=
577: hr_loc_shd.g_old_rec.description;
573: hr_loc_shd.g_old_rec.country;
574: END IF;
575: IF (p_rec.description = hr_api.g_varchar2) THEN
576: p_rec.description :=
577: hr_loc_shd.g_old_rec.description;
578: END IF;
579: IF (p_rec.designated_receiver_id = hr_api.g_number) THEN
580: p_rec.designated_receiver_id :=
581: hr_loc_shd.g_old_rec.designated_receiver_id;
577: hr_loc_shd.g_old_rec.description;
578: END IF;
579: IF (p_rec.designated_receiver_id = hr_api.g_number) THEN
580: p_rec.designated_receiver_id :=
581: hr_loc_shd.g_old_rec.designated_receiver_id;
582: END IF;
583: IF (p_rec.in_organization_flag = hr_api.g_varchar2) THEN
584: p_rec.in_organization_flag :=
585: hr_loc_shd.g_old_rec.in_organization_flag;
581: hr_loc_shd.g_old_rec.designated_receiver_id;
582: END IF;
583: IF (p_rec.in_organization_flag = hr_api.g_varchar2) THEN
584: p_rec.in_organization_flag :=
585: hr_loc_shd.g_old_rec.in_organization_flag;
586: END IF;
587: IF (p_rec.inactive_date = hr_api.g_date) THEN
588: p_rec.inactive_date :=
589: hr_loc_shd.g_old_rec.inactive_date;
585: hr_loc_shd.g_old_rec.in_organization_flag;
586: END IF;
587: IF (p_rec.inactive_date = hr_api.g_date) THEN
588: p_rec.inactive_date :=
589: hr_loc_shd.g_old_rec.inactive_date;
590: END IF;
591: IF (p_rec.inventory_organization_id = hr_api.g_number) THEN
592: p_rec.inventory_organization_id :=
593: hr_loc_shd.g_old_rec.inventory_organization_id;
589: hr_loc_shd.g_old_rec.inactive_date;
590: END IF;
591: IF (p_rec.inventory_organization_id = hr_api.g_number) THEN
592: p_rec.inventory_organization_id :=
593: hr_loc_shd.g_old_rec.inventory_organization_id;
594: END IF;
595: IF (p_rec.office_site_flag = hr_api.g_varchar2) THEN
596: p_rec.office_site_flag :=
597: hr_loc_shd.g_old_rec.office_site_flag;
593: hr_loc_shd.g_old_rec.inventory_organization_id;
594: END IF;
595: IF (p_rec.office_site_flag = hr_api.g_varchar2) THEN
596: p_rec.office_site_flag :=
597: hr_loc_shd.g_old_rec.office_site_flag;
598: END IF;
599: IF (p_rec.postal_code = hr_api.g_varchar2) THEN
600: p_rec.postal_code :=
601: hr_loc_shd.g_old_rec.postal_code;
597: hr_loc_shd.g_old_rec.office_site_flag;
598: END IF;
599: IF (p_rec.postal_code = hr_api.g_varchar2) THEN
600: p_rec.postal_code :=
601: hr_loc_shd.g_old_rec.postal_code;
602: END IF;
603: IF (p_rec.receiving_site_flag = hr_api.g_varchar2) THEN
604: p_rec.receiving_site_flag :=
605: hr_loc_shd.g_old_rec.receiving_site_flag;
601: hr_loc_shd.g_old_rec.postal_code;
602: END IF;
603: IF (p_rec.receiving_site_flag = hr_api.g_varchar2) THEN
604: p_rec.receiving_site_flag :=
605: hr_loc_shd.g_old_rec.receiving_site_flag;
606: END IF;
607: IF (p_rec.region_1 = hr_api.g_varchar2) THEN
608: p_rec.region_1 :=
609: hr_loc_shd.g_old_rec.region_1;
605: hr_loc_shd.g_old_rec.receiving_site_flag;
606: END IF;
607: IF (p_rec.region_1 = hr_api.g_varchar2) THEN
608: p_rec.region_1 :=
609: hr_loc_shd.g_old_rec.region_1;
610: END IF;
611: IF (p_rec.region_2 = hr_api.g_varchar2) THEN
612: p_rec.region_2 :=
613: hr_loc_shd.g_old_rec.region_2;
609: hr_loc_shd.g_old_rec.region_1;
610: END IF;
611: IF (p_rec.region_2 = hr_api.g_varchar2) THEN
612: p_rec.region_2 :=
613: hr_loc_shd.g_old_rec.region_2;
614: END IF;
615: IF (p_rec.region_3 = hr_api.g_varchar2) THEN
616: p_rec.region_3 :=
617: hr_loc_shd.g_old_rec.region_3;
613: hr_loc_shd.g_old_rec.region_2;
614: END IF;
615: IF (p_rec.region_3 = hr_api.g_varchar2) THEN
616: p_rec.region_3 :=
617: hr_loc_shd.g_old_rec.region_3;
618: END IF;
619: IF (p_rec.ship_to_location_id = hr_api.g_number) THEN
620: p_rec.ship_to_location_id :=
621: hr_loc_shd.g_old_rec.ship_to_location_id;
617: hr_loc_shd.g_old_rec.region_3;
618: END IF;
619: IF (p_rec.ship_to_location_id = hr_api.g_number) THEN
620: p_rec.ship_to_location_id :=
621: hr_loc_shd.g_old_rec.ship_to_location_id;
622: END IF;
623: IF (p_rec.ship_to_site_flag = hr_api.g_varchar2) THEN
624: p_rec.ship_to_site_flag :=
625: hr_loc_shd.g_old_rec.ship_to_site_flag;
621: hr_loc_shd.g_old_rec.ship_to_location_id;
622: END IF;
623: IF (p_rec.ship_to_site_flag = hr_api.g_varchar2) THEN
624: p_rec.ship_to_site_flag :=
625: hr_loc_shd.g_old_rec.ship_to_site_flag;
626: END IF;
627: IF (p_rec.style = hr_api.g_varchar2) THEN
628: p_rec.style :=
629: hr_loc_shd.g_old_rec.style;
625: hr_loc_shd.g_old_rec.ship_to_site_flag;
626: END IF;
627: IF (p_rec.style = hr_api.g_varchar2) THEN
628: p_rec.style :=
629: hr_loc_shd.g_old_rec.style;
630: END IF;
631: IF (p_rec.tax_name = hr_api.g_varchar2) THEN
632: p_rec.tax_name :=
633: hr_loc_shd.g_old_rec.tax_name;
629: hr_loc_shd.g_old_rec.style;
630: END IF;
631: IF (p_rec.tax_name = hr_api.g_varchar2) THEN
632: p_rec.tax_name :=
633: hr_loc_shd.g_old_rec.tax_name;
634: END IF;
635: IF (p_rec.telephone_number_1 = hr_api.g_varchar2) THEN
636: p_rec.telephone_number_1 :=
637: hr_loc_shd.g_old_rec.telephone_number_1;
633: hr_loc_shd.g_old_rec.tax_name;
634: END IF;
635: IF (p_rec.telephone_number_1 = hr_api.g_varchar2) THEN
636: p_rec.telephone_number_1 :=
637: hr_loc_shd.g_old_rec.telephone_number_1;
638: END IF;
639: IF (p_rec.telephone_number_2 = hr_api.g_varchar2) THEN
640: p_rec.telephone_number_2 :=
641: hr_loc_shd.g_old_rec.telephone_number_2;
637: hr_loc_shd.g_old_rec.telephone_number_1;
638: END IF;
639: IF (p_rec.telephone_number_2 = hr_api.g_varchar2) THEN
640: p_rec.telephone_number_2 :=
641: hr_loc_shd.g_old_rec.telephone_number_2;
642: END IF;
643: IF (p_rec.telephone_number_3 = hr_api.g_varchar2) THEN
644: p_rec.telephone_number_3 :=
645: hr_loc_shd.g_old_rec.telephone_number_3;
641: hr_loc_shd.g_old_rec.telephone_number_2;
642: END IF;
643: IF (p_rec.telephone_number_3 = hr_api.g_varchar2) THEN
644: p_rec.telephone_number_3 :=
645: hr_loc_shd.g_old_rec.telephone_number_3;
646: END IF;
647: IF (p_rec.town_or_city = hr_api.g_varchar2) THEN
648: p_rec.town_or_city :=
649: hr_loc_shd.g_old_rec.town_or_city;
645: hr_loc_shd.g_old_rec.telephone_number_3;
646: END IF;
647: IF (p_rec.town_or_city = hr_api.g_varchar2) THEN
648: p_rec.town_or_city :=
649: hr_loc_shd.g_old_rec.town_or_city;
650: END IF;
651: IF (p_rec.loc_information13 = hr_api.g_varchar2) THEN
652: p_rec.loc_information13 :=
653: hr_loc_shd.g_old_rec.loc_information13;
649: hr_loc_shd.g_old_rec.town_or_city;
650: END IF;
651: IF (p_rec.loc_information13 = hr_api.g_varchar2) THEN
652: p_rec.loc_information13 :=
653: hr_loc_shd.g_old_rec.loc_information13;
654: END IF;
655: IF (p_rec.loc_information14 = hr_api.g_varchar2) THEN
656: p_rec.loc_information14 :=
657: hr_loc_shd.g_old_rec.loc_information14;
653: hr_loc_shd.g_old_rec.loc_information13;
654: END IF;
655: IF (p_rec.loc_information14 = hr_api.g_varchar2) THEN
656: p_rec.loc_information14 :=
657: hr_loc_shd.g_old_rec.loc_information14;
658: END IF;
659: IF (p_rec.loc_information15 = hr_api.g_varchar2) THEN
660: p_rec.loc_information15 :=
661: hr_loc_shd.g_old_rec.loc_information15;
657: hr_loc_shd.g_old_rec.loc_information14;
658: END IF;
659: IF (p_rec.loc_information15 = hr_api.g_varchar2) THEN
660: p_rec.loc_information15 :=
661: hr_loc_shd.g_old_rec.loc_information15;
662: END IF;
663: IF (p_rec.loc_information16 = hr_api.g_varchar2) THEN
664: p_rec.loc_information16 :=
665: hr_loc_shd.g_old_rec.loc_information16;
661: hr_loc_shd.g_old_rec.loc_information15;
662: END IF;
663: IF (p_rec.loc_information16 = hr_api.g_varchar2) THEN
664: p_rec.loc_information16 :=
665: hr_loc_shd.g_old_rec.loc_information16;
666: END IF;
667: IF (p_rec.loc_information17 = hr_api.g_varchar2) THEN
668: p_rec.loc_information17 :=
669: hr_loc_shd.g_old_rec.loc_information17;
665: hr_loc_shd.g_old_rec.loc_information16;
666: END IF;
667: IF (p_rec.loc_information17 = hr_api.g_varchar2) THEN
668: p_rec.loc_information17 :=
669: hr_loc_shd.g_old_rec.loc_information17;
670: END IF;
671: IF (p_rec.loc_information18 = hr_api.g_varchar2) THEN
672: p_rec.loc_information18 :=
673: hr_loc_shd.g_old_rec.loc_information18;
669: hr_loc_shd.g_old_rec.loc_information17;
670: END IF;
671: IF (p_rec.loc_information18 = hr_api.g_varchar2) THEN
672: p_rec.loc_information18 :=
673: hr_loc_shd.g_old_rec.loc_information18;
674: END IF;
675: IF (p_rec.loc_information19 = hr_api.g_varchar2) THEN
676: p_rec.loc_information19 :=
677: hr_loc_shd.g_old_rec.loc_information19;
673: hr_loc_shd.g_old_rec.loc_information18;
674: END IF;
675: IF (p_rec.loc_information19 = hr_api.g_varchar2) THEN
676: p_rec.loc_information19 :=
677: hr_loc_shd.g_old_rec.loc_information19;
678: END IF;
679: IF (p_rec.loc_information20 = hr_api.g_varchar2) THEN
680: p_rec.loc_information20 :=
681: hr_loc_shd.g_old_rec.loc_information20;
677: hr_loc_shd.g_old_rec.loc_information19;
678: END IF;
679: IF (p_rec.loc_information20 = hr_api.g_varchar2) THEN
680: p_rec.loc_information20 :=
681: hr_loc_shd.g_old_rec.loc_information20;
682: END IF;
683: IF (p_rec.attribute_category = hr_api.g_varchar2) THEN
684: p_rec.attribute_category :=
685: hr_loc_shd.g_old_rec.attribute_category;
681: hr_loc_shd.g_old_rec.loc_information20;
682: END IF;
683: IF (p_rec.attribute_category = hr_api.g_varchar2) THEN
684: p_rec.attribute_category :=
685: hr_loc_shd.g_old_rec.attribute_category;
686: END IF;
687: IF (p_rec.attribute1 = hr_api.g_varchar2) THEN
688: p_rec.attribute1 :=
689: hr_loc_shd.g_old_rec.attribute1;
685: hr_loc_shd.g_old_rec.attribute_category;
686: END IF;
687: IF (p_rec.attribute1 = hr_api.g_varchar2) THEN
688: p_rec.attribute1 :=
689: hr_loc_shd.g_old_rec.attribute1;
690: END IF;
691: IF (p_rec.attribute2 = hr_api.g_varchar2) THEN
692: p_rec.attribute2 :=
693: hr_loc_shd.g_old_rec.attribute2;
689: hr_loc_shd.g_old_rec.attribute1;
690: END IF;
691: IF (p_rec.attribute2 = hr_api.g_varchar2) THEN
692: p_rec.attribute2 :=
693: hr_loc_shd.g_old_rec.attribute2;
694: END IF;
695: IF (p_rec.attribute3 = hr_api.g_varchar2) THEN
696: p_rec.attribute3 :=
697: hr_loc_shd.g_old_rec.attribute3;
693: hr_loc_shd.g_old_rec.attribute2;
694: END IF;
695: IF (p_rec.attribute3 = hr_api.g_varchar2) THEN
696: p_rec.attribute3 :=
697: hr_loc_shd.g_old_rec.attribute3;
698: END IF;
699: IF (p_rec.attribute4 = hr_api.g_varchar2) THEN
700: p_rec.attribute4 :=
701: hr_loc_shd.g_old_rec.attribute4;
697: hr_loc_shd.g_old_rec.attribute3;
698: END IF;
699: IF (p_rec.attribute4 = hr_api.g_varchar2) THEN
700: p_rec.attribute4 :=
701: hr_loc_shd.g_old_rec.attribute4;
702: END IF;
703: IF (p_rec.attribute5 = hr_api.g_varchar2) THEN
704: p_rec.attribute5 :=
705: hr_loc_shd.g_old_rec.attribute5;
701: hr_loc_shd.g_old_rec.attribute4;
702: END IF;
703: IF (p_rec.attribute5 = hr_api.g_varchar2) THEN
704: p_rec.attribute5 :=
705: hr_loc_shd.g_old_rec.attribute5;
706: END IF;
707: IF (p_rec.attribute6 = hr_api.g_varchar2) THEN
708: p_rec.attribute6 :=
709: hr_loc_shd.g_old_rec.attribute6;
705: hr_loc_shd.g_old_rec.attribute5;
706: END IF;
707: IF (p_rec.attribute6 = hr_api.g_varchar2) THEN
708: p_rec.attribute6 :=
709: hr_loc_shd.g_old_rec.attribute6;
710: END IF;
711: IF (p_rec.attribute7 = hr_api.g_varchar2) THEN
712: p_rec.attribute7 :=
713: hr_loc_shd.g_old_rec.attribute7;
709: hr_loc_shd.g_old_rec.attribute6;
710: END IF;
711: IF (p_rec.attribute7 = hr_api.g_varchar2) THEN
712: p_rec.attribute7 :=
713: hr_loc_shd.g_old_rec.attribute7;
714: END IF;
715: IF (p_rec.attribute8 = hr_api.g_varchar2) THEN
716: p_rec.attribute8 :=
717: hr_loc_shd.g_old_rec.attribute8;
713: hr_loc_shd.g_old_rec.attribute7;
714: END IF;
715: IF (p_rec.attribute8 = hr_api.g_varchar2) THEN
716: p_rec.attribute8 :=
717: hr_loc_shd.g_old_rec.attribute8;
718: END IF;
719: IF (p_rec.attribute9 = hr_api.g_varchar2) THEN
720: p_rec.attribute9 :=
721: hr_loc_shd.g_old_rec.attribute9;
717: hr_loc_shd.g_old_rec.attribute8;
718: END IF;
719: IF (p_rec.attribute9 = hr_api.g_varchar2) THEN
720: p_rec.attribute9 :=
721: hr_loc_shd.g_old_rec.attribute9;
722: END IF;
723: IF (p_rec.attribute10 = hr_api.g_varchar2) THEN
724: p_rec.attribute10 :=
725: hr_loc_shd.g_old_rec.attribute10;
721: hr_loc_shd.g_old_rec.attribute9;
722: END IF;
723: IF (p_rec.attribute10 = hr_api.g_varchar2) THEN
724: p_rec.attribute10 :=
725: hr_loc_shd.g_old_rec.attribute10;
726: END IF;
727: IF (p_rec.attribute11 = hr_api.g_varchar2) THEN
728: p_rec.attribute11 :=
729: hr_loc_shd.g_old_rec.attribute11;
725: hr_loc_shd.g_old_rec.attribute10;
726: END IF;
727: IF (p_rec.attribute11 = hr_api.g_varchar2) THEN
728: p_rec.attribute11 :=
729: hr_loc_shd.g_old_rec.attribute11;
730: END IF;
731: IF (p_rec.attribute12 = hr_api.g_varchar2) THEN
732: p_rec.attribute12 :=
733: hr_loc_shd.g_old_rec.attribute12;
729: hr_loc_shd.g_old_rec.attribute11;
730: END IF;
731: IF (p_rec.attribute12 = hr_api.g_varchar2) THEN
732: p_rec.attribute12 :=
733: hr_loc_shd.g_old_rec.attribute12;
734: END IF;
735: IF (p_rec.attribute13 = hr_api.g_varchar2) THEN
736: p_rec.attribute13 :=
737: hr_loc_shd.g_old_rec.attribute13;
733: hr_loc_shd.g_old_rec.attribute12;
734: END IF;
735: IF (p_rec.attribute13 = hr_api.g_varchar2) THEN
736: p_rec.attribute13 :=
737: hr_loc_shd.g_old_rec.attribute13;
738: END IF;
739: IF (p_rec.attribute14 = hr_api.g_varchar2) THEN
740: p_rec.attribute14 :=
741: hr_loc_shd.g_old_rec.attribute14;
737: hr_loc_shd.g_old_rec.attribute13;
738: END IF;
739: IF (p_rec.attribute14 = hr_api.g_varchar2) THEN
740: p_rec.attribute14 :=
741: hr_loc_shd.g_old_rec.attribute14;
742: END IF;
743: IF (p_rec.attribute15 = hr_api.g_varchar2) THEN
744: p_rec.attribute15 :=
745: hr_loc_shd.g_old_rec.attribute15;
741: hr_loc_shd.g_old_rec.attribute14;
742: END IF;
743: IF (p_rec.attribute15 = hr_api.g_varchar2) THEN
744: p_rec.attribute15 :=
745: hr_loc_shd.g_old_rec.attribute15;
746: END IF;
747: IF (p_rec.attribute16 = hr_api.g_varchar2) THEN
748: p_rec.attribute16 :=
749: hr_loc_shd.g_old_rec.attribute16;
745: hr_loc_shd.g_old_rec.attribute15;
746: END IF;
747: IF (p_rec.attribute16 = hr_api.g_varchar2) THEN
748: p_rec.attribute16 :=
749: hr_loc_shd.g_old_rec.attribute16;
750: END IF;
751: IF (p_rec.attribute17 = hr_api.g_varchar2) THEN
752: p_rec.attribute17 :=
753: hr_loc_shd.g_old_rec.attribute17;
749: hr_loc_shd.g_old_rec.attribute16;
750: END IF;
751: IF (p_rec.attribute17 = hr_api.g_varchar2) THEN
752: p_rec.attribute17 :=
753: hr_loc_shd.g_old_rec.attribute17;
754: END IF;
755: IF (p_rec.attribute18 = hr_api.g_varchar2) THEN
756: p_rec.attribute18 :=
757: hr_loc_shd.g_old_rec.attribute18;
753: hr_loc_shd.g_old_rec.attribute17;
754: END IF;
755: IF (p_rec.attribute18 = hr_api.g_varchar2) THEN
756: p_rec.attribute18 :=
757: hr_loc_shd.g_old_rec.attribute18;
758: END IF;
759: IF (p_rec.attribute19 = hr_api.g_varchar2) THEN
760: p_rec.attribute19 :=
761: hr_loc_shd.g_old_rec.attribute19;
757: hr_loc_shd.g_old_rec.attribute18;
758: END IF;
759: IF (p_rec.attribute19 = hr_api.g_varchar2) THEN
760: p_rec.attribute19 :=
761: hr_loc_shd.g_old_rec.attribute19;
762: END IF;
763: IF (p_rec.attribute20 = hr_api.g_varchar2) THEN
764: p_rec.attribute20 :=
765: hr_loc_shd.g_old_rec.attribute20;
761: hr_loc_shd.g_old_rec.attribute19;
762: END IF;
763: IF (p_rec.attribute20 = hr_api.g_varchar2) THEN
764: p_rec.attribute20 :=
765: hr_loc_shd.g_old_rec.attribute20;
766: END IF;
767: IF (p_rec.global_attribute_category = hr_api.g_varchar2) THEN
768: p_rec.global_attribute_category :=
769: hr_loc_shd.g_old_rec.global_attribute_category;
765: hr_loc_shd.g_old_rec.attribute20;
766: END IF;
767: IF (p_rec.global_attribute_category = hr_api.g_varchar2) THEN
768: p_rec.global_attribute_category :=
769: hr_loc_shd.g_old_rec.global_attribute_category;
770: END IF;
771: IF (p_rec.global_attribute1 = hr_api.g_varchar2) THEN
772: p_rec.global_attribute1 :=
773: hr_loc_shd.g_old_rec.global_attribute1;
769: hr_loc_shd.g_old_rec.global_attribute_category;
770: END IF;
771: IF (p_rec.global_attribute1 = hr_api.g_varchar2) THEN
772: p_rec.global_attribute1 :=
773: hr_loc_shd.g_old_rec.global_attribute1;
774: END IF;
775: IF (p_rec.global_attribute2 = hr_api.g_varchar2) THEN
776: p_rec.global_attribute2 :=
777: hr_loc_shd.g_old_rec.global_attribute2;
773: hr_loc_shd.g_old_rec.global_attribute1;
774: END IF;
775: IF (p_rec.global_attribute2 = hr_api.g_varchar2) THEN
776: p_rec.global_attribute2 :=
777: hr_loc_shd.g_old_rec.global_attribute2;
778: END IF;
779: IF (p_rec.global_attribute3 = hr_api.g_varchar2) THEN
780: p_rec.global_attribute3 :=
781: hr_loc_shd.g_old_rec.global_attribute3;
777: hr_loc_shd.g_old_rec.global_attribute2;
778: END IF;
779: IF (p_rec.global_attribute3 = hr_api.g_varchar2) THEN
780: p_rec.global_attribute3 :=
781: hr_loc_shd.g_old_rec.global_attribute3;
782: END IF;
783: IF (p_rec.global_attribute4 = hr_api.g_varchar2) THEN
784: p_rec.global_attribute4 :=
785: hr_loc_shd.g_old_rec.global_attribute4;
781: hr_loc_shd.g_old_rec.global_attribute3;
782: END IF;
783: IF (p_rec.global_attribute4 = hr_api.g_varchar2) THEN
784: p_rec.global_attribute4 :=
785: hr_loc_shd.g_old_rec.global_attribute4;
786: END IF;
787: IF (p_rec.global_attribute5 = hr_api.g_varchar2) THEN
788: p_rec.global_attribute5 :=
789: hr_loc_shd.g_old_rec.global_attribute5;
785: hr_loc_shd.g_old_rec.global_attribute4;
786: END IF;
787: IF (p_rec.global_attribute5 = hr_api.g_varchar2) THEN
788: p_rec.global_attribute5 :=
789: hr_loc_shd.g_old_rec.global_attribute5;
790: END IF;
791: IF (p_rec.global_attribute6 = hr_api.g_varchar2) THEN
792: p_rec.global_attribute6 :=
793: hr_loc_shd.g_old_rec.global_attribute6;
789: hr_loc_shd.g_old_rec.global_attribute5;
790: END IF;
791: IF (p_rec.global_attribute6 = hr_api.g_varchar2) THEN
792: p_rec.global_attribute6 :=
793: hr_loc_shd.g_old_rec.global_attribute6;
794: END IF;
795: IF (p_rec.global_attribute7 = hr_api.g_varchar2) THEN
796: p_rec.global_attribute7 :=
797: hr_loc_shd.g_old_rec.global_attribute7;
793: hr_loc_shd.g_old_rec.global_attribute6;
794: END IF;
795: IF (p_rec.global_attribute7 = hr_api.g_varchar2) THEN
796: p_rec.global_attribute7 :=
797: hr_loc_shd.g_old_rec.global_attribute7;
798: END IF;
799: IF (p_rec.global_attribute8 = hr_api.g_varchar2) THEN
800: p_rec.global_attribute8 :=
801: hr_loc_shd.g_old_rec.global_attribute8;
797: hr_loc_shd.g_old_rec.global_attribute7;
798: END IF;
799: IF (p_rec.global_attribute8 = hr_api.g_varchar2) THEN
800: p_rec.global_attribute8 :=
801: hr_loc_shd.g_old_rec.global_attribute8;
802: END IF;
803: IF (p_rec.global_attribute9 = hr_api.g_varchar2) THEN
804: p_rec.global_attribute9 :=
805: hr_loc_shd.g_old_rec.global_attribute9;
801: hr_loc_shd.g_old_rec.global_attribute8;
802: END IF;
803: IF (p_rec.global_attribute9 = hr_api.g_varchar2) THEN
804: p_rec.global_attribute9 :=
805: hr_loc_shd.g_old_rec.global_attribute9;
806: END IF;
807: IF (p_rec.global_attribute10 = hr_api.g_varchar2) THEN
808: p_rec.global_attribute10 :=
809: hr_loc_shd.g_old_rec.global_attribute10;
805: hr_loc_shd.g_old_rec.global_attribute9;
806: END IF;
807: IF (p_rec.global_attribute10 = hr_api.g_varchar2) THEN
808: p_rec.global_attribute10 :=
809: hr_loc_shd.g_old_rec.global_attribute10;
810: END IF;
811: IF (p_rec.global_attribute11 = hr_api.g_varchar2) THEN
812: p_rec.global_attribute11 :=
813: hr_loc_shd.g_old_rec.global_attribute11;
809: hr_loc_shd.g_old_rec.global_attribute10;
810: END IF;
811: IF (p_rec.global_attribute11 = hr_api.g_varchar2) THEN
812: p_rec.global_attribute11 :=
813: hr_loc_shd.g_old_rec.global_attribute11;
814: END IF;
815: IF (p_rec.global_attribute12 = hr_api.g_varchar2) THEN
816: p_rec.global_attribute12 :=
817: hr_loc_shd.g_old_rec.global_attribute12;
813: hr_loc_shd.g_old_rec.global_attribute11;
814: END IF;
815: IF (p_rec.global_attribute12 = hr_api.g_varchar2) THEN
816: p_rec.global_attribute12 :=
817: hr_loc_shd.g_old_rec.global_attribute12;
818: END IF;
819: IF (p_rec.global_attribute13 = hr_api.g_varchar2) THEN
820: p_rec.global_attribute13 :=
821: hr_loc_shd.g_old_rec.global_attribute13;
817: hr_loc_shd.g_old_rec.global_attribute12;
818: END IF;
819: IF (p_rec.global_attribute13 = hr_api.g_varchar2) THEN
820: p_rec.global_attribute13 :=
821: hr_loc_shd.g_old_rec.global_attribute13;
822: END IF;
823: IF (p_rec.global_attribute14 = hr_api.g_varchar2) THEN
824: p_rec.global_attribute14 :=
825: hr_loc_shd.g_old_rec.global_attribute14;
821: hr_loc_shd.g_old_rec.global_attribute13;
822: END IF;
823: IF (p_rec.global_attribute14 = hr_api.g_varchar2) THEN
824: p_rec.global_attribute14 :=
825: hr_loc_shd.g_old_rec.global_attribute14;
826: END IF;
827: IF (p_rec.global_attribute15 = hr_api.g_varchar2) THEN
828: p_rec.global_attribute15 :=
829: hr_loc_shd.g_old_rec.global_attribute15;
825: hr_loc_shd.g_old_rec.global_attribute14;
826: END IF;
827: IF (p_rec.global_attribute15 = hr_api.g_varchar2) THEN
828: p_rec.global_attribute15 :=
829: hr_loc_shd.g_old_rec.global_attribute15;
830: END IF;
831: IF (p_rec.global_attribute16 = hr_api.g_varchar2) THEN
832: p_rec.global_attribute16 :=
833: hr_loc_shd.g_old_rec.global_attribute16;
829: hr_loc_shd.g_old_rec.global_attribute15;
830: END IF;
831: IF (p_rec.global_attribute16 = hr_api.g_varchar2) THEN
832: p_rec.global_attribute16 :=
833: hr_loc_shd.g_old_rec.global_attribute16;
834: END IF;
835: IF (p_rec.global_attribute17 = hr_api.g_varchar2) THEN
836: p_rec.global_attribute17 :=
837: hr_loc_shd.g_old_rec.global_attribute17;
833: hr_loc_shd.g_old_rec.global_attribute16;
834: END IF;
835: IF (p_rec.global_attribute17 = hr_api.g_varchar2) THEN
836: p_rec.global_attribute17 :=
837: hr_loc_shd.g_old_rec.global_attribute17;
838: END IF;
839: IF (p_rec.global_attribute18 = hr_api.g_varchar2) THEN
840: p_rec.global_attribute18 :=
841: hr_loc_shd.g_old_rec.global_attribute18;
837: hr_loc_shd.g_old_rec.global_attribute17;
838: END IF;
839: IF (p_rec.global_attribute18 = hr_api.g_varchar2) THEN
840: p_rec.global_attribute18 :=
841: hr_loc_shd.g_old_rec.global_attribute18;
842: END IF;
843: IF (p_rec.global_attribute19 = hr_api.g_varchar2) THEN
844: p_rec.global_attribute19 :=
845: hr_loc_shd.g_old_rec.global_attribute19;
841: hr_loc_shd.g_old_rec.global_attribute18;
842: END IF;
843: IF (p_rec.global_attribute19 = hr_api.g_varchar2) THEN
844: p_rec.global_attribute19 :=
845: hr_loc_shd.g_old_rec.global_attribute19;
846: END IF;
847: IF (p_rec.global_attribute20 = hr_api.g_varchar2) THEN
848: p_rec.global_attribute20 :=
849: hr_loc_shd.g_old_rec.global_attribute20;
845: hr_loc_shd.g_old_rec.global_attribute19;
846: END IF;
847: IF (p_rec.global_attribute20 = hr_api.g_varchar2) THEN
848: p_rec.global_attribute20 :=
849: hr_loc_shd.g_old_rec.global_attribute20;
850: END IF;
851: IF (p_rec.legal_address_flag = hr_api.g_varchar2) THEN
852: p_rec.legal_address_flag :=
853: hr_loc_shd.g_old_rec.legal_address_flag;
849: hr_loc_shd.g_old_rec.global_attribute20;
850: END IF;
851: IF (p_rec.legal_address_flag = hr_api.g_varchar2) THEN
852: p_rec.legal_address_flag :=
853: hr_loc_shd.g_old_rec.legal_address_flag;
854: END IF;
855: IF (p_rec.tp_header_id = hr_api.g_number) THEN
856: p_rec.tp_header_id :=
857: hr_loc_shd.g_old_rec.tp_header_id;
853: hr_loc_shd.g_old_rec.legal_address_flag;
854: END IF;
855: IF (p_rec.tp_header_id = hr_api.g_number) THEN
856: p_rec.tp_header_id :=
857: hr_loc_shd.g_old_rec.tp_header_id;
858: END IF;
859: IF (p_rec.ece_tp_location_code = hr_api.g_varchar2) THEN
860: p_rec.ece_tp_location_code :=
861: hr_loc_shd.g_old_rec.ece_tp_location_code;
857: hr_loc_shd.g_old_rec.tp_header_id;
858: END IF;
859: IF (p_rec.ece_tp_location_code = hr_api.g_varchar2) THEN
860: p_rec.ece_tp_location_code :=
861: hr_loc_shd.g_old_rec.ece_tp_location_code;
862: END IF;
863: IF (p_rec.business_group_id = hr_api.g_number) THEN
864: p_rec.business_group_id :=
865: hr_loc_shd.g_old_rec.business_group_id;
861: hr_loc_shd.g_old_rec.ece_tp_location_code;
862: END IF;
863: IF (p_rec.business_group_id = hr_api.g_number) THEN
864: p_rec.business_group_id :=
865: hr_loc_shd.g_old_rec.business_group_id;
866: END IF;
867: -- Fix 3286235
868: IF (p_rec.timezone_code = hr_api.g_varchar2) THEN
869: p_rec.timezone_code :=
866: END IF;
867: -- Fix 3286235
868: IF (p_rec.timezone_code = hr_api.g_varchar2) THEN
869: p_rec.timezone_code :=
870: hr_loc_shd.g_old_rec.timezone_code;
871: END IF;
872: -- End Fix 3286235
873: --
874: hr_utility.set_location(' Leaving:'||l_proc, 10);
879: -- |---------------------------------< upd >----------------------------------|
880: -- ----------------------------------------------------------------------------
881: PROCEDURE upd
882: (
883: p_rec IN OUT NOCOPY hr_loc_shd.g_rec_type
884: ,p_effective_date IN DATE
885: ,p_operating_unit_id IN NUMBER
886: ) IS
887: --
891: hr_utility.set_location('Entering:'||l_proc, 5);
892: --
893: -- We must lock the row which we need to update.
894: --
895: hr_loc_shd.lck
896: (
897: p_rec.location_id,
898: p_rec.object_version_number
899: );
1014: p_tp_header_id IN NUMBER DEFAULT hr_api.g_number,
1015: p_ece_tp_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
1016: ) IS
1017: --
1018: l_rec hr_loc_shd.g_rec_type;
1019: l_proc VARCHAR2(72) := g_package||'upd';
1020: --
1021: BEGIN
1022: hr_utility.set_location('Entering:'||l_proc, 5);
1024: -- Call conversion function to turn arguments into the
1025: -- l_rec structure.
1026: --
1027: l_rec :=
1028: hr_loc_shd.convert_args
1029: (
1030: p_location_id,
1031: p_location_code,
1032: p_timezone_code,