40: ,p_loc_information17 In Varchar2 Default Null
41: ,p_loc_information18 In Varchar2 Default Null
42: ,p_loc_information19 In Varchar2 Default Null
43: ,p_loc_information20 In Varchar2 Default Null
44: ,p_language_code In Varchar2 Default hr_api.userenv_lang
45: ,p_effective_date In Date
46: ,p_object_version_number Out Nocopy Number
47: ,p_location_id Out Nocopy Number
48: )
75: -- instead of p_language_code from now on, to allow an IN OUT parameter to
76: -- be passed through.
77: --
78: l_language_code := p_language_code;
79: hr_api.validate_language_code(p_language_code => l_language_code);
80: --
81: hr_utility.set_location(l_proc, 20);
82:
83: -- Process Logic
120: --
121: -- When in validation only mode raise the Validate_Enabled exception
122: --
123: If p_validate Then
124: Raise hr_api.validate_enabled;
125: End If;
126: --
127: -- Set all output arguments
128: --
131: hr_utility.set_location(' Leaving:'||l_proc, 70);
132: --
133: Exception
134: --
135: When hr_api.validate_enabled Then
136: --
137: -- As the Validate_Enabled exception has been raised
138: -- we must rollback to the savepoint
139: --
164: ,p_location_id In Number
165: ,p_configuration_code In Varchar2
166: ,p_configuration_context In Varchar2
167: ,p_location_code In Varchar2
168: ,p_description In Varchar2 Default hr_api.g_varchar2
169: ,p_style In Varchar2 Default hr_api.g_varchar2
170: ,p_address_line_1 In Varchar2 Default hr_api.g_varchar2
171: ,p_address_line_2 In Varchar2 Default hr_api.g_varchar2
172: ,p_address_line_3 In Varchar2 Default hr_api.g_varchar2
165: ,p_configuration_code In Varchar2
166: ,p_configuration_context In Varchar2
167: ,p_location_code In Varchar2
168: ,p_description In Varchar2 Default hr_api.g_varchar2
169: ,p_style In Varchar2 Default hr_api.g_varchar2
170: ,p_address_line_1 In Varchar2 Default hr_api.g_varchar2
171: ,p_address_line_2 In Varchar2 Default hr_api.g_varchar2
172: ,p_address_line_3 In Varchar2 Default hr_api.g_varchar2
173: ,p_town_or_city In Varchar2 Default hr_api.g_varchar2
166: ,p_configuration_context In Varchar2
167: ,p_location_code In Varchar2
168: ,p_description In Varchar2 Default hr_api.g_varchar2
169: ,p_style In Varchar2 Default hr_api.g_varchar2
170: ,p_address_line_1 In Varchar2 Default hr_api.g_varchar2
171: ,p_address_line_2 In Varchar2 Default hr_api.g_varchar2
172: ,p_address_line_3 In Varchar2 Default hr_api.g_varchar2
173: ,p_town_or_city In Varchar2 Default hr_api.g_varchar2
174: ,p_country In Varchar2 Default hr_api.g_varchar2
167: ,p_location_code In Varchar2
168: ,p_description In Varchar2 Default hr_api.g_varchar2
169: ,p_style In Varchar2 Default hr_api.g_varchar2
170: ,p_address_line_1 In Varchar2 Default hr_api.g_varchar2
171: ,p_address_line_2 In Varchar2 Default hr_api.g_varchar2
172: ,p_address_line_3 In Varchar2 Default hr_api.g_varchar2
173: ,p_town_or_city In Varchar2 Default hr_api.g_varchar2
174: ,p_country In Varchar2 Default hr_api.g_varchar2
175: ,p_postal_code In Varchar2 Default hr_api.g_varchar2
168: ,p_description In Varchar2 Default hr_api.g_varchar2
169: ,p_style In Varchar2 Default hr_api.g_varchar2
170: ,p_address_line_1 In Varchar2 Default hr_api.g_varchar2
171: ,p_address_line_2 In Varchar2 Default hr_api.g_varchar2
172: ,p_address_line_3 In Varchar2 Default hr_api.g_varchar2
173: ,p_town_or_city In Varchar2 Default hr_api.g_varchar2
174: ,p_country In Varchar2 Default hr_api.g_varchar2
175: ,p_postal_code In Varchar2 Default hr_api.g_varchar2
176: ,p_region_1 In Varchar2 Default hr_api.g_varchar2
169: ,p_style In Varchar2 Default hr_api.g_varchar2
170: ,p_address_line_1 In Varchar2 Default hr_api.g_varchar2
171: ,p_address_line_2 In Varchar2 Default hr_api.g_varchar2
172: ,p_address_line_3 In Varchar2 Default hr_api.g_varchar2
173: ,p_town_or_city In Varchar2 Default hr_api.g_varchar2
174: ,p_country In Varchar2 Default hr_api.g_varchar2
175: ,p_postal_code In Varchar2 Default hr_api.g_varchar2
176: ,p_region_1 In Varchar2 Default hr_api.g_varchar2
177: ,p_region_2 In Varchar2 Default hr_api.g_varchar2
170: ,p_address_line_1 In Varchar2 Default hr_api.g_varchar2
171: ,p_address_line_2 In Varchar2 Default hr_api.g_varchar2
172: ,p_address_line_3 In Varchar2 Default hr_api.g_varchar2
173: ,p_town_or_city In Varchar2 Default hr_api.g_varchar2
174: ,p_country In Varchar2 Default hr_api.g_varchar2
175: ,p_postal_code In Varchar2 Default hr_api.g_varchar2
176: ,p_region_1 In Varchar2 Default hr_api.g_varchar2
177: ,p_region_2 In Varchar2 Default hr_api.g_varchar2
178: ,p_region_3 In Varchar2 Default hr_api.g_varchar2
171: ,p_address_line_2 In Varchar2 Default hr_api.g_varchar2
172: ,p_address_line_3 In Varchar2 Default hr_api.g_varchar2
173: ,p_town_or_city In Varchar2 Default hr_api.g_varchar2
174: ,p_country In Varchar2 Default hr_api.g_varchar2
175: ,p_postal_code In Varchar2 Default hr_api.g_varchar2
176: ,p_region_1 In Varchar2 Default hr_api.g_varchar2
177: ,p_region_2 In Varchar2 Default hr_api.g_varchar2
178: ,p_region_3 In Varchar2 Default hr_api.g_varchar2
179: ,p_telephone_number_1 In Varchar2 Default hr_api.g_varchar2
172: ,p_address_line_3 In Varchar2 Default hr_api.g_varchar2
173: ,p_town_or_city In Varchar2 Default hr_api.g_varchar2
174: ,p_country In Varchar2 Default hr_api.g_varchar2
175: ,p_postal_code In Varchar2 Default hr_api.g_varchar2
176: ,p_region_1 In Varchar2 Default hr_api.g_varchar2
177: ,p_region_2 In Varchar2 Default hr_api.g_varchar2
178: ,p_region_3 In Varchar2 Default hr_api.g_varchar2
179: ,p_telephone_number_1 In Varchar2 Default hr_api.g_varchar2
180: ,p_telephone_number_2 In Varchar2 Default hr_api.g_varchar2
173: ,p_town_or_city In Varchar2 Default hr_api.g_varchar2
174: ,p_country In Varchar2 Default hr_api.g_varchar2
175: ,p_postal_code In Varchar2 Default hr_api.g_varchar2
176: ,p_region_1 In Varchar2 Default hr_api.g_varchar2
177: ,p_region_2 In Varchar2 Default hr_api.g_varchar2
178: ,p_region_3 In Varchar2 Default hr_api.g_varchar2
179: ,p_telephone_number_1 In Varchar2 Default hr_api.g_varchar2
180: ,p_telephone_number_2 In Varchar2 Default hr_api.g_varchar2
181: ,p_telephone_number_3 In Varchar2 Default hr_api.g_varchar2
174: ,p_country In Varchar2 Default hr_api.g_varchar2
175: ,p_postal_code In Varchar2 Default hr_api.g_varchar2
176: ,p_region_1 In Varchar2 Default hr_api.g_varchar2
177: ,p_region_2 In Varchar2 Default hr_api.g_varchar2
178: ,p_region_3 In Varchar2 Default hr_api.g_varchar2
179: ,p_telephone_number_1 In Varchar2 Default hr_api.g_varchar2
180: ,p_telephone_number_2 In Varchar2 Default hr_api.g_varchar2
181: ,p_telephone_number_3 In Varchar2 Default hr_api.g_varchar2
182: ,p_loc_information13 In Varchar2 Default hr_api.g_varchar2
175: ,p_postal_code In Varchar2 Default hr_api.g_varchar2
176: ,p_region_1 In Varchar2 Default hr_api.g_varchar2
177: ,p_region_2 In Varchar2 Default hr_api.g_varchar2
178: ,p_region_3 In Varchar2 Default hr_api.g_varchar2
179: ,p_telephone_number_1 In Varchar2 Default hr_api.g_varchar2
180: ,p_telephone_number_2 In Varchar2 Default hr_api.g_varchar2
181: ,p_telephone_number_3 In Varchar2 Default hr_api.g_varchar2
182: ,p_loc_information13 In Varchar2 Default hr_api.g_varchar2
183: ,p_loc_information14 In Varchar2 Default hr_api.g_varchar2
176: ,p_region_1 In Varchar2 Default hr_api.g_varchar2
177: ,p_region_2 In Varchar2 Default hr_api.g_varchar2
178: ,p_region_3 In Varchar2 Default hr_api.g_varchar2
179: ,p_telephone_number_1 In Varchar2 Default hr_api.g_varchar2
180: ,p_telephone_number_2 In Varchar2 Default hr_api.g_varchar2
181: ,p_telephone_number_3 In Varchar2 Default hr_api.g_varchar2
182: ,p_loc_information13 In Varchar2 Default hr_api.g_varchar2
183: ,p_loc_information14 In Varchar2 Default hr_api.g_varchar2
184: ,p_loc_information15 In Varchar2 Default hr_api.g_varchar2
177: ,p_region_2 In Varchar2 Default hr_api.g_varchar2
178: ,p_region_3 In Varchar2 Default hr_api.g_varchar2
179: ,p_telephone_number_1 In Varchar2 Default hr_api.g_varchar2
180: ,p_telephone_number_2 In Varchar2 Default hr_api.g_varchar2
181: ,p_telephone_number_3 In Varchar2 Default hr_api.g_varchar2
182: ,p_loc_information13 In Varchar2 Default hr_api.g_varchar2
183: ,p_loc_information14 In Varchar2 Default hr_api.g_varchar2
184: ,p_loc_information15 In Varchar2 Default hr_api.g_varchar2
185: ,p_loc_information16 In Varchar2 Default hr_api.g_varchar2
178: ,p_region_3 In Varchar2 Default hr_api.g_varchar2
179: ,p_telephone_number_1 In Varchar2 Default hr_api.g_varchar2
180: ,p_telephone_number_2 In Varchar2 Default hr_api.g_varchar2
181: ,p_telephone_number_3 In Varchar2 Default hr_api.g_varchar2
182: ,p_loc_information13 In Varchar2 Default hr_api.g_varchar2
183: ,p_loc_information14 In Varchar2 Default hr_api.g_varchar2
184: ,p_loc_information15 In Varchar2 Default hr_api.g_varchar2
185: ,p_loc_information16 In Varchar2 Default hr_api.g_varchar2
186: ,p_loc_information17 In Varchar2 Default hr_api.g_varchar2
179: ,p_telephone_number_1 In Varchar2 Default hr_api.g_varchar2
180: ,p_telephone_number_2 In Varchar2 Default hr_api.g_varchar2
181: ,p_telephone_number_3 In Varchar2 Default hr_api.g_varchar2
182: ,p_loc_information13 In Varchar2 Default hr_api.g_varchar2
183: ,p_loc_information14 In Varchar2 Default hr_api.g_varchar2
184: ,p_loc_information15 In Varchar2 Default hr_api.g_varchar2
185: ,p_loc_information16 In Varchar2 Default hr_api.g_varchar2
186: ,p_loc_information17 In Varchar2 Default hr_api.g_varchar2
187: ,p_loc_information18 In Varchar2 Default hr_api.g_varchar2
180: ,p_telephone_number_2 In Varchar2 Default hr_api.g_varchar2
181: ,p_telephone_number_3 In Varchar2 Default hr_api.g_varchar2
182: ,p_loc_information13 In Varchar2 Default hr_api.g_varchar2
183: ,p_loc_information14 In Varchar2 Default hr_api.g_varchar2
184: ,p_loc_information15 In Varchar2 Default hr_api.g_varchar2
185: ,p_loc_information16 In Varchar2 Default hr_api.g_varchar2
186: ,p_loc_information17 In Varchar2 Default hr_api.g_varchar2
187: ,p_loc_information18 In Varchar2 Default hr_api.g_varchar2
188: ,p_loc_information19 In Varchar2 Default hr_api.g_varchar2
181: ,p_telephone_number_3 In Varchar2 Default hr_api.g_varchar2
182: ,p_loc_information13 In Varchar2 Default hr_api.g_varchar2
183: ,p_loc_information14 In Varchar2 Default hr_api.g_varchar2
184: ,p_loc_information15 In Varchar2 Default hr_api.g_varchar2
185: ,p_loc_information16 In Varchar2 Default hr_api.g_varchar2
186: ,p_loc_information17 In Varchar2 Default hr_api.g_varchar2
187: ,p_loc_information18 In Varchar2 Default hr_api.g_varchar2
188: ,p_loc_information19 In Varchar2 Default hr_api.g_varchar2
189: ,p_loc_information20 In Varchar2 Default hr_api.g_varchar2
182: ,p_loc_information13 In Varchar2 Default hr_api.g_varchar2
183: ,p_loc_information14 In Varchar2 Default hr_api.g_varchar2
184: ,p_loc_information15 In Varchar2 Default hr_api.g_varchar2
185: ,p_loc_information16 In Varchar2 Default hr_api.g_varchar2
186: ,p_loc_information17 In Varchar2 Default hr_api.g_varchar2
187: ,p_loc_information18 In Varchar2 Default hr_api.g_varchar2
188: ,p_loc_information19 In Varchar2 Default hr_api.g_varchar2
189: ,p_loc_information20 In Varchar2 Default hr_api.g_varchar2
190: ,p_language_code In Varchar2 Default hr_api.userenv_lang
183: ,p_loc_information14 In Varchar2 Default hr_api.g_varchar2
184: ,p_loc_information15 In Varchar2 Default hr_api.g_varchar2
185: ,p_loc_information16 In Varchar2 Default hr_api.g_varchar2
186: ,p_loc_information17 In Varchar2 Default hr_api.g_varchar2
187: ,p_loc_information18 In Varchar2 Default hr_api.g_varchar2
188: ,p_loc_information19 In Varchar2 Default hr_api.g_varchar2
189: ,p_loc_information20 In Varchar2 Default hr_api.g_varchar2
190: ,p_language_code In Varchar2 Default hr_api.userenv_lang
191: ,p_effective_date In Date
184: ,p_loc_information15 In Varchar2 Default hr_api.g_varchar2
185: ,p_loc_information16 In Varchar2 Default hr_api.g_varchar2
186: ,p_loc_information17 In Varchar2 Default hr_api.g_varchar2
187: ,p_loc_information18 In Varchar2 Default hr_api.g_varchar2
188: ,p_loc_information19 In Varchar2 Default hr_api.g_varchar2
189: ,p_loc_information20 In Varchar2 Default hr_api.g_varchar2
190: ,p_language_code In Varchar2 Default hr_api.userenv_lang
191: ,p_effective_date In Date
192: ,p_object_version_number In Out Nocopy Number
185: ,p_loc_information16 In Varchar2 Default hr_api.g_varchar2
186: ,p_loc_information17 In Varchar2 Default hr_api.g_varchar2
187: ,p_loc_information18 In Varchar2 Default hr_api.g_varchar2
188: ,p_loc_information19 In Varchar2 Default hr_api.g_varchar2
189: ,p_loc_information20 In Varchar2 Default hr_api.g_varchar2
190: ,p_language_code In Varchar2 Default hr_api.userenv_lang
191: ,p_effective_date In Date
192: ,p_object_version_number In Out Nocopy Number
193: ) Is
186: ,p_loc_information17 In Varchar2 Default hr_api.g_varchar2
187: ,p_loc_information18 In Varchar2 Default hr_api.g_varchar2
188: ,p_loc_information19 In Varchar2 Default hr_api.g_varchar2
189: ,p_loc_information20 In Varchar2 Default hr_api.g_varchar2
190: ,p_language_code In Varchar2 Default hr_api.userenv_lang
191: ,p_effective_date In Date
192: ,p_object_version_number In Out Nocopy Number
193: ) Is
194: --
220: -- instead of p_language_code from now on, to allow an IN OUT parameter to be
221: -- passed through.
222: --
223: l_language_code := p_language_code;
224: hr_api.validate_language_code(p_language_code => l_language_code);
225: hr_utility.set_location(l_proc, 20);
226: --
227: --
228: -- Process Logic
268: --
269: -- When in validation only mode raise the Validate_Enabled exception
270: --
271: If p_validate Then
272: Raise hr_api.validate_enabled;
273: End If;
274: --
275: -- Set all output arguments. If p_validate was TRUE, this bit is
276: -- never reached, so p_object_version_number is passed back unchanged.
280: hr_utility.set_location(' Leaving:'||l_proc, 70);
281: --
282: Exception
283: --
284: When hr_api.validate_enabled Then
285: --
286: -- As the Validate_Enabled exception has been raised
287: -- we must rollback to the savepoint
288: --
343: --
344: -- When in validation only mode raise the Validate_Enabled exception
345: --
346: If p_validate Then
347: Raise hr_api.validate_enabled;
348: End If;
349: --
350: --
351: Exception
349: --
350: --
351: Exception
352: --
353: When hr_api.validate_enabled Then
354: --
355: -- As the Validate_Enabled exception has been raised
356: -- we must rollback to the savepoint
357: --