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