8: -- ----------------------------------------------------------------------------
9: -- |----------------------------< create_location >---------------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE create_location
12: (p_validate in number default hr_api.g_false_num
13: ,p_configuration_code in varchar2
14: ,p_configuration_context in varchar2
15: ,p_location_code in varchar2
16: ,p_description in varchar2 default null
65: --
66: -- Convert constant values to their corresponding boolean value
67: --
68: l_validate :=
69: hr_api.constant_to_boolean
70: (p_constant_value => p_validate);
71: --
72: -- Register Surrogate ID or user key values
73: --
160: -- ----------------------------------------------------------------------------
161: -- |----------------------------< update_location >---------------------------|
162: -- ----------------------------------------------------------------------------
163: PROCEDURE update_location
164: (p_validate in number default hr_api.g_false_num
165: ,p_location_id in number
166: ,p_configuration_code in varchar2
167: ,p_configuration_context in varchar2
168: ,p_location_code in varchar2
165: ,p_location_id in number
166: ,p_configuration_code in varchar2
167: ,p_configuration_context in varchar2
168: ,p_location_code in varchar2
169: ,p_description in varchar2 default hr_api.g_varchar2
170: ,p_style in varchar2 default hr_api.g_varchar2
171: ,p_address_line_1 in varchar2 default hr_api.g_varchar2
172: ,p_address_line_2 in varchar2 default hr_api.g_varchar2
173: ,p_address_line_3 in varchar2 default hr_api.g_varchar2
166: ,p_configuration_code in varchar2
167: ,p_configuration_context in varchar2
168: ,p_location_code in varchar2
169: ,p_description in varchar2 default hr_api.g_varchar2
170: ,p_style in varchar2 default hr_api.g_varchar2
171: ,p_address_line_1 in varchar2 default hr_api.g_varchar2
172: ,p_address_line_2 in varchar2 default hr_api.g_varchar2
173: ,p_address_line_3 in varchar2 default hr_api.g_varchar2
174: ,p_town_or_city in varchar2 default hr_api.g_varchar2
167: ,p_configuration_context in varchar2
168: ,p_location_code in varchar2
169: ,p_description in varchar2 default hr_api.g_varchar2
170: ,p_style in varchar2 default hr_api.g_varchar2
171: ,p_address_line_1 in varchar2 default hr_api.g_varchar2
172: ,p_address_line_2 in varchar2 default hr_api.g_varchar2
173: ,p_address_line_3 in varchar2 default hr_api.g_varchar2
174: ,p_town_or_city in varchar2 default hr_api.g_varchar2
175: ,p_country in varchar2 default hr_api.g_varchar2
168: ,p_location_code in varchar2
169: ,p_description in varchar2 default hr_api.g_varchar2
170: ,p_style in varchar2 default hr_api.g_varchar2
171: ,p_address_line_1 in varchar2 default hr_api.g_varchar2
172: ,p_address_line_2 in varchar2 default hr_api.g_varchar2
173: ,p_address_line_3 in varchar2 default hr_api.g_varchar2
174: ,p_town_or_city in varchar2 default hr_api.g_varchar2
175: ,p_country in varchar2 default hr_api.g_varchar2
176: ,p_postal_code in varchar2 default hr_api.g_varchar2
169: ,p_description in varchar2 default hr_api.g_varchar2
170: ,p_style in varchar2 default hr_api.g_varchar2
171: ,p_address_line_1 in varchar2 default hr_api.g_varchar2
172: ,p_address_line_2 in varchar2 default hr_api.g_varchar2
173: ,p_address_line_3 in varchar2 default hr_api.g_varchar2
174: ,p_town_or_city in varchar2 default hr_api.g_varchar2
175: ,p_country in varchar2 default hr_api.g_varchar2
176: ,p_postal_code in varchar2 default hr_api.g_varchar2
177: ,p_region_1 in varchar2 default hr_api.g_varchar2
170: ,p_style in varchar2 default hr_api.g_varchar2
171: ,p_address_line_1 in varchar2 default hr_api.g_varchar2
172: ,p_address_line_2 in varchar2 default hr_api.g_varchar2
173: ,p_address_line_3 in varchar2 default hr_api.g_varchar2
174: ,p_town_or_city in varchar2 default hr_api.g_varchar2
175: ,p_country in varchar2 default hr_api.g_varchar2
176: ,p_postal_code in varchar2 default hr_api.g_varchar2
177: ,p_region_1 in varchar2 default hr_api.g_varchar2
178: ,p_region_2 in varchar2 default hr_api.g_varchar2
171: ,p_address_line_1 in varchar2 default hr_api.g_varchar2
172: ,p_address_line_2 in varchar2 default hr_api.g_varchar2
173: ,p_address_line_3 in varchar2 default hr_api.g_varchar2
174: ,p_town_or_city in varchar2 default hr_api.g_varchar2
175: ,p_country in varchar2 default hr_api.g_varchar2
176: ,p_postal_code in varchar2 default hr_api.g_varchar2
177: ,p_region_1 in varchar2 default hr_api.g_varchar2
178: ,p_region_2 in varchar2 default hr_api.g_varchar2
179: ,p_region_3 in varchar2 default hr_api.g_varchar2
172: ,p_address_line_2 in varchar2 default hr_api.g_varchar2
173: ,p_address_line_3 in varchar2 default hr_api.g_varchar2
174: ,p_town_or_city in varchar2 default hr_api.g_varchar2
175: ,p_country in varchar2 default hr_api.g_varchar2
176: ,p_postal_code in varchar2 default hr_api.g_varchar2
177: ,p_region_1 in varchar2 default hr_api.g_varchar2
178: ,p_region_2 in varchar2 default hr_api.g_varchar2
179: ,p_region_3 in varchar2 default hr_api.g_varchar2
180: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
173: ,p_address_line_3 in varchar2 default hr_api.g_varchar2
174: ,p_town_or_city in varchar2 default hr_api.g_varchar2
175: ,p_country in varchar2 default hr_api.g_varchar2
176: ,p_postal_code in varchar2 default hr_api.g_varchar2
177: ,p_region_1 in varchar2 default hr_api.g_varchar2
178: ,p_region_2 in varchar2 default hr_api.g_varchar2
179: ,p_region_3 in varchar2 default hr_api.g_varchar2
180: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
181: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
174: ,p_town_or_city in varchar2 default hr_api.g_varchar2
175: ,p_country in varchar2 default hr_api.g_varchar2
176: ,p_postal_code in varchar2 default hr_api.g_varchar2
177: ,p_region_1 in varchar2 default hr_api.g_varchar2
178: ,p_region_2 in varchar2 default hr_api.g_varchar2
179: ,p_region_3 in varchar2 default hr_api.g_varchar2
180: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
181: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
182: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
175: ,p_country in varchar2 default hr_api.g_varchar2
176: ,p_postal_code in varchar2 default hr_api.g_varchar2
177: ,p_region_1 in varchar2 default hr_api.g_varchar2
178: ,p_region_2 in varchar2 default hr_api.g_varchar2
179: ,p_region_3 in varchar2 default hr_api.g_varchar2
180: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
181: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
182: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
183: ,p_loc_information13 in varchar2 default hr_api.g_varchar2
176: ,p_postal_code in varchar2 default hr_api.g_varchar2
177: ,p_region_1 in varchar2 default hr_api.g_varchar2
178: ,p_region_2 in varchar2 default hr_api.g_varchar2
179: ,p_region_3 in varchar2 default hr_api.g_varchar2
180: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
181: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
182: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
183: ,p_loc_information13 in varchar2 default hr_api.g_varchar2
184: ,p_loc_information14 in varchar2 default hr_api.g_varchar2
177: ,p_region_1 in varchar2 default hr_api.g_varchar2
178: ,p_region_2 in varchar2 default hr_api.g_varchar2
179: ,p_region_3 in varchar2 default hr_api.g_varchar2
180: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
181: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
182: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
183: ,p_loc_information13 in varchar2 default hr_api.g_varchar2
184: ,p_loc_information14 in varchar2 default hr_api.g_varchar2
185: ,p_loc_information15 in varchar2 default hr_api.g_varchar2
178: ,p_region_2 in varchar2 default hr_api.g_varchar2
179: ,p_region_3 in varchar2 default hr_api.g_varchar2
180: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
181: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
182: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
183: ,p_loc_information13 in varchar2 default hr_api.g_varchar2
184: ,p_loc_information14 in varchar2 default hr_api.g_varchar2
185: ,p_loc_information15 in varchar2 default hr_api.g_varchar2
186: ,p_loc_information16 in varchar2 default hr_api.g_varchar2
179: ,p_region_3 in varchar2 default hr_api.g_varchar2
180: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
181: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
182: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
183: ,p_loc_information13 in varchar2 default hr_api.g_varchar2
184: ,p_loc_information14 in varchar2 default hr_api.g_varchar2
185: ,p_loc_information15 in varchar2 default hr_api.g_varchar2
186: ,p_loc_information16 in varchar2 default hr_api.g_varchar2
187: ,p_loc_information17 in varchar2 default hr_api.g_varchar2
180: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
181: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
182: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
183: ,p_loc_information13 in varchar2 default hr_api.g_varchar2
184: ,p_loc_information14 in varchar2 default hr_api.g_varchar2
185: ,p_loc_information15 in varchar2 default hr_api.g_varchar2
186: ,p_loc_information16 in varchar2 default hr_api.g_varchar2
187: ,p_loc_information17 in varchar2 default hr_api.g_varchar2
188: ,p_loc_information18 in varchar2 default hr_api.g_varchar2
181: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
182: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
183: ,p_loc_information13 in varchar2 default hr_api.g_varchar2
184: ,p_loc_information14 in varchar2 default hr_api.g_varchar2
185: ,p_loc_information15 in varchar2 default hr_api.g_varchar2
186: ,p_loc_information16 in varchar2 default hr_api.g_varchar2
187: ,p_loc_information17 in varchar2 default hr_api.g_varchar2
188: ,p_loc_information18 in varchar2 default hr_api.g_varchar2
189: ,p_loc_information19 in varchar2 default hr_api.g_varchar2
182: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
183: ,p_loc_information13 in varchar2 default hr_api.g_varchar2
184: ,p_loc_information14 in varchar2 default hr_api.g_varchar2
185: ,p_loc_information15 in varchar2 default hr_api.g_varchar2
186: ,p_loc_information16 in varchar2 default hr_api.g_varchar2
187: ,p_loc_information17 in varchar2 default hr_api.g_varchar2
188: ,p_loc_information18 in varchar2 default hr_api.g_varchar2
189: ,p_loc_information19 in varchar2 default hr_api.g_varchar2
190: ,p_loc_information20 in varchar2 default hr_api.g_varchar2
183: ,p_loc_information13 in varchar2 default hr_api.g_varchar2
184: ,p_loc_information14 in varchar2 default hr_api.g_varchar2
185: ,p_loc_information15 in varchar2 default hr_api.g_varchar2
186: ,p_loc_information16 in varchar2 default hr_api.g_varchar2
187: ,p_loc_information17 in varchar2 default hr_api.g_varchar2
188: ,p_loc_information18 in varchar2 default hr_api.g_varchar2
189: ,p_loc_information19 in varchar2 default hr_api.g_varchar2
190: ,p_loc_information20 in varchar2 default hr_api.g_varchar2
191: ,p_language_code in varchar2 default hr_api.g_varchar2
184: ,p_loc_information14 in varchar2 default hr_api.g_varchar2
185: ,p_loc_information15 in varchar2 default hr_api.g_varchar2
186: ,p_loc_information16 in varchar2 default hr_api.g_varchar2
187: ,p_loc_information17 in varchar2 default hr_api.g_varchar2
188: ,p_loc_information18 in varchar2 default hr_api.g_varchar2
189: ,p_loc_information19 in varchar2 default hr_api.g_varchar2
190: ,p_loc_information20 in varchar2 default hr_api.g_varchar2
191: ,p_language_code in varchar2 default hr_api.g_varchar2
192: ,p_effective_date in date
185: ,p_loc_information15 in varchar2 default hr_api.g_varchar2
186: ,p_loc_information16 in varchar2 default hr_api.g_varchar2
187: ,p_loc_information17 in varchar2 default hr_api.g_varchar2
188: ,p_loc_information18 in varchar2 default hr_api.g_varchar2
189: ,p_loc_information19 in varchar2 default hr_api.g_varchar2
190: ,p_loc_information20 in varchar2 default hr_api.g_varchar2
191: ,p_language_code in varchar2 default hr_api.g_varchar2
192: ,p_effective_date in date
193: ,p_object_version_number in out nocopy number
186: ,p_loc_information16 in varchar2 default hr_api.g_varchar2
187: ,p_loc_information17 in varchar2 default hr_api.g_varchar2
188: ,p_loc_information18 in varchar2 default hr_api.g_varchar2
189: ,p_loc_information19 in varchar2 default hr_api.g_varchar2
190: ,p_loc_information20 in varchar2 default hr_api.g_varchar2
191: ,p_language_code in varchar2 default hr_api.g_varchar2
192: ,p_effective_date in date
193: ,p_object_version_number in out nocopy number
194: ,p_return_status out nocopy varchar2
187: ,p_loc_information17 in varchar2 default hr_api.g_varchar2
188: ,p_loc_information18 in varchar2 default hr_api.g_varchar2
189: ,p_loc_information19 in varchar2 default hr_api.g_varchar2
190: ,p_loc_information20 in varchar2 default hr_api.g_varchar2
191: ,p_language_code in varchar2 default hr_api.g_varchar2
192: ,p_effective_date in date
193: ,p_object_version_number in out nocopy number
194: ,p_return_status out nocopy varchar2
195: ) is
219: --
220: -- Convert constant values to their corresponding boolean value
221: --
222: l_validate :=
223: hr_api.constant_to_boolean
224: (p_constant_value => p_validate);
225: --
226: -- Register Surrogate ID or user key values
227: --
312: -- ----------------------------------------------------------------------------
313: -- |----------------------------< delete_location >---------------------------|
314: -- ----------------------------------------------------------------------------
315: PROCEDURE delete_location
316: (p_validate in number default hr_api.g_false_num
317: ,p_location_id in number
318: ,p_object_version_number in number
319: ,p_return_status out nocopy varchar2
320: ) is
342: --
343: -- Convert constant values to their corresponding boolean value
344: --
345: l_validate :=
346: hr_api.constant_to_boolean
347: (p_constant_value => p_validate);
348: --
349: -- Register Surrogate ID or user key values
350: --