1 PACKAGE hr_location_api AUTHID CURRENT_USER AS
2 /* $Header: hrlocapi.pkh 120.4 2009/10/26 12:26:51 skura noship $ */
3 /*#
4 * This package contains APIs for maintaining location information.
5 * @rep:scope public
6 * @rep:product per
7 * @rep:displayname Location
8 */
9 --
10 -- ----------------------------------------------------------------------------
11 -- |---------------------------< create_location >----------------------------|
12 -- ----------------------------------------------------------------------------
13 -- {Start Of Comments}
14 /*#
15 * This API is used to create locations.
16 *
17 *
18 * <p><b>Licensing</b><br>
19 * This API is licensed for use with Human Resources and HR Foundation.
20 *
21 * <p><b>Prerequisites</b><br>
22 * If a business group is specified it must exist on the effective date.
23 *
24 * <p><b>Post Success</b><br>
25 * The location is created.
26 *
27 * <p><b>Post Failure</b><br>
28 * The location is not created and an error is raised.
29 * @param p_validate If true, then validation alone will be performed and the
30 * database will remain unchanged. If false and all validation checks pass,
31 * then the database will be modified.
32 * @param p_effective_date Reference date for validating lookup values are
33 * applicable during the start to end active date range. This date does not
34 * determine when the changes take effect.
35 * @param p_language_code Specifies to which language the translation values
36 * apply. You can set to the base or any installed language. The default value
37 * of hr_api.userenv_lang is equivalent to the RDBMS userenv('LANG') function
38 * value.
39 * @param p_location_code Unique name of the location
40 * @param p_description Description of the location
41 * @param p_timezone_code Time zone of the location.
42 * @param p_tp_header_id Identifies the inventory header. Used by Oracle EDI
43 * Gateway.
44 * @param p_ece_tp_location_code Identifies the inventory organization. Used by
45 * Oracle EDI Gateway.
46 * @param p_address_line_1 Location Address Developer Descriptive Flexfield
47 * Segment.
48 * @param p_address_line_2 Location Address Developer Descriptive Flexfield
49 * Segment.
50 * @param p_address_line_3 Location Address Developer Descriptive Flexfield
51 * Segment.
52 * @param p_bill_to_site_flag Indicates if this is a billing location
53 * @param p_country Location Address Developer Descriptive Flexfield Segment.
54 * @param p_designated_receiver_id Designated Receiver Person ID. Must be a
55 * valid employee within the scope of the location.
56 * @param p_in_organization_flag Indicates if the organization is an Internal
57 * Organization. Valid values defined in the YES/NO lookup type.
58 * @param p_inactive_date Date on which the location becomes inactive. Must be
59 * greater than or equal to p_effective_date.
60 * @param p_operating_unit_id Identifies the Operating Unit. Used to validate
61 * the parameter p_inventory_organization_id.
62 * @param p_inventory_organization_id Identifies the Inventory Organization for
63 * this location
64 * @param p_office_site_flag Indicates whether this location can be used as an
65 * office site. Valid values are defined in the YES_NO lookup type.
66 * @param p_postal_code Location Address Developer Descriptive Flexfield
67 * Segment.
68 * @param p_receiving_site_flag Indicates whether this location can be used as
69 * a receiving site. Valid values are defined in the YES_NO lookup type.
70 * @param p_region_1 Location Address Developer Descriptive Flexfield Segment.
71 * @param p_region_2 Location Address Developer Descriptive Flexfield Segment.
72 * @param p_region_3 Location Address Developer Descriptive Flexfield Segment.
73 * @param p_ship_to_location_id Identifies the Ship To Location. If it is
74 * passed as null, it will assume the value of the current location identifier.
75 * @param p_ship_to_site_flag Indicates whether items can be shipped to this
76 * location. Valid values are defined in the YES_NO lookup type.
77 * @param p_style This context value determines which Flexfield Structure to
78 * use with the Location Address Developer Descriptive flexfield segments.
79 * @param p_tax_name This parameter is disabled.
80 * @param p_telephone_number_1 Location Address Developer Descriptive Flexfield
81 * Segment.
82 * @param p_telephone_number_2 Location Address Developer Descriptive Flexfield
83 * Segment.
84 * @param p_telephone_number_3 Location Address Developer Descriptive Flexfield
85 * Segment.
86 * @param p_town_or_city Location Address Developer Descriptive Flexfield
87 * Segment.
88 * @param p_loc_information13 Location Address Developer Descriptive Flexfield
89 * Segment.
90 * @param p_loc_information14 Location Address Developer Descriptive Flexfield
91 * Segment.
92 * @param p_loc_information15 Location Address Developer Descriptive Flexfield
93 * Segment.
94 * @param p_loc_information16 Location Address Developer Descriptive Flexfield
95 * Segment.
96 * @param p_loc_information17 Location Address Developer Descriptive Flexfield
97 * Segment.
98 * @param p_loc_information18 Location Address Developer Descriptive Flexfield
99 * Segment.
100 * @param p_loc_information19 Location Address Developer Descriptive Flexfield
101 * Segment.
102 * @param p_loc_information20 Location Address Developer Descriptive Flexfield
103 * Segment.
104 * @param p_attribute_category This context value determines which flexfield
105 * structure to use with the descriptive flexfield segments.
106 * @param p_attribute1 Descriptive flexfield segment.
107 * @param p_attribute2 Descriptive flexfield segment.
108 * @param p_attribute3 Descriptive flexfield segment.
109 * @param p_attribute4 Descriptive flexfield segment.
110 * @param p_attribute5 Descriptive flexfield segment.
111 * @param p_attribute6 Descriptive flexfield segment.
112 * @param p_attribute7 Descriptive flexfield segment.
113 * @param p_attribute8 Descriptive flexfield segment.
114 * @param p_attribute9 Descriptive flexfield segment.
115 * @param p_attribute10 Descriptive flexfield segment.
116 * @param p_attribute11 Descriptive flexfield segment.
117 * @param p_attribute12 Descriptive flexfield segment.
118 * @param p_attribute13 Descriptive flexfield segment.
119 * @param p_attribute14 Descriptive flexfield segment.
120 * @param p_attribute15 Descriptive flexfield segment.
121 * @param p_attribute16 Descriptive flexfield segment.
122 * @param p_attribute17 Descriptive flexfield segment.
123 * @param p_attribute18 Descriptive flexfield segment.
124 * @param p_attribute19 Descriptive flexfield segment.
125 * @param p_attribute20 Descriptive flexfield segment.
126 * @param p_global_attribute_category This context value determines which
127 * Flexfield Structure to use with the JG_HR_LOCATIONS Descriptive flexfield
128 * segments. Used by Oracle Regional Localizations
129 * @param p_global_attribute1 JG_HR_LOCATIONS Descriptive Flexfield Segment.
130 * Used by Oracle Regional Localizations
131 * @param p_global_attribute2 JG_HR_LOCATIONS Descriptive Flexfield Segment.
132 * Used by Oracle Regional Localizations
133 * @param p_global_attribute3 JG_HR_LOCATIONS Descriptive Flexfield Segment.
134 * Used by Oracle Regional Localizations
135 * @param p_global_attribute4 JG_HR_LOCATIONS Descriptive Flexfield Segment.
136 * Used by Oracle Regional Localizations
137 * @param p_global_attribute5 JG_HR_LOCATIONS Descriptive Flexfield Segment.
138 * Used by Oracle Regional Localizations
139 * @param p_global_attribute6 JG_HR_LOCATIONS Descriptive Flexfield Segment.
140 * Used by Oracle Regional Localizations
141 * @param p_global_attribute7 JG_HR_LOCATIONS Descriptive Flexfield Segment.
142 * Used by Oracle Regional Localizations
143 * @param p_global_attribute8 JG_HR_LOCATIONS Descriptive Flexfield Segment.
144 * Used by Oracle Regional Localizations
145 * @param p_global_attribute9 JG_HR_LOCATIONS Descriptive Flexfield Segment.
146 * Used by Oracle Regional Localizations
147 * @param p_global_attribute10 JG_HR_LOCATIONS Descriptive Flexfield Segment.
148 * Used by Oracle Regional Localizations
149 * @param p_global_attribute11 JG_HR_LOCATIONS Descriptive Flexfield Segment.
150 * Used by Oracle Regional Localizations
151 * @param p_global_attribute12 JG_HR_LOCATIONS Descriptive Flexfield Segment.
152 * Used by Oracle Regional Localizations
153 * @param p_global_attribute13 JG_HR_LOCATIONS Descriptive Flexfield Segment.
154 * Used by Oracle Regional Localizations
155 * @param p_global_attribute14 JG_HR_LOCATIONS Descriptive Flexfield Segment.
156 * Used by Oracle Regional Localizations
157 * @param p_global_attribute15 JG_HR_LOCATIONS Descriptive Flexfield Segment.
158 * Used by Oracle Regional Localizations
159 * @param p_global_attribute16 JG_HR_LOCATIONS Descriptive Flexfield Segment.
160 * Used by Oracle Regional Localizations
161 * @param p_global_attribute17 JG_HR_LOCATIONS Descriptive Flexfield Segment.
162 * Used by Oracle Regional Localizations
163 * @param p_global_attribute18 JG_HR_LOCATIONS Descriptive Flexfield Segment.
164 * Used by Oracle Regional Localizations
165 * @param p_global_attribute19 JG_HR_LOCATIONS Descriptive Flexfield Segment.
166 * Used by Oracle Regional Localizations
167 * @param p_global_attribute20 JG_HR_LOCATIONS Descriptive Flexfield Segment.
168 * Used by Oracle Regional Localizations
169 * @param p_business_group_id Business group identifier. No value indicates the
170 * location can be used in any business group. Any other value must indicate a
171 * business group that exists, and restricts the scope of the location to that
172 * business group.
173 * @param p_location_id If p_validate is false, uniquely identifies the
174 * location created. If p_validate is true set to null.
175 * @param p_object_version_number If p_validate is false, then set to the
176 * version number of the created location. If p_validate is true, then the
177 * value will be null.
178 * @rep:displayname Create Location
179 * @rep:category BUSINESS_ENTITY HR_LOCATION
180 * @rep:category MISC_EXTENSIONS HR_DATAPUMP
181 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
182 * @rep:scope public
183 * @rep:lifecycle active
184 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
185 */
186 --
187 -- {End Of Comments}
188 --
189 PROCEDURE create_location
190 ( p_validate IN BOOLEAN DEFAULT false
191 ,p_effective_date IN DATE
192 ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
193 ,p_location_code IN VARCHAR2
194 ,p_description IN VARCHAR2 DEFAULT NULL
195 ,p_timezone_code IN VARCHAR2 DEFAULT NULL
196 ,p_tp_header_id IN NUMBER DEFAULT NULL
197 ,p_ece_tp_location_code IN VARCHAR2 DEFAULT NULL
198 ,p_address_line_1 IN VARCHAR2 DEFAULT NULL
199 ,p_address_line_2 IN VARCHAR2 DEFAULT NULL
200 ,p_address_line_3 IN VARCHAR2 DEFAULT NULL
201 ,p_bill_to_site_flag IN VARCHAR2 DEFAULT 'Y'
202 ,p_country IN VARCHAR2 DEFAULT NULL
203 ,p_designated_receiver_id IN NUMBER DEFAULT NULL
204 ,p_in_organization_flag IN VARCHAR2 DEFAULT 'Y'
205 ,p_inactive_date IN DATE DEFAULT NULL
206 ,p_operating_unit_id IN NUMBER DEFAULT NULL
207 ,p_inventory_organization_id IN NUMBER DEFAULT NULL
208 ,p_office_site_flag IN VARCHAR2 DEFAULT 'Y'
209 ,p_postal_code IN VARCHAR2 DEFAULT NULL
210 ,p_receiving_site_flag IN VARCHAR2 DEFAULT 'Y'
211 ,p_region_1 IN VARCHAR2 DEFAULT NULL
212 ,p_region_2 IN VARCHAR2 DEFAULT NULL
213 ,p_region_3 IN VARCHAR2 DEFAULT NULL
214 ,p_ship_to_location_id IN NUMBER DEFAULT NULL
215 ,p_ship_to_site_flag IN VARCHAR2 DEFAULT 'Y'
216 ,p_style IN VARCHAR2 DEFAULT NULL
217 ,p_tax_name IN VARCHAR2 DEFAULT NULL
218 ,p_telephone_number_1 IN VARCHAR2 DEFAULT NULL
219 ,p_telephone_number_2 IN VARCHAR2 DEFAULT NULL
220 ,p_telephone_number_3 IN VARCHAR2 DEFAULT NULL
221 ,p_town_or_city IN VARCHAR2 DEFAULT NULL
222 ,p_loc_information13 IN VARCHAR2 DEFAULT NULL
223 ,p_loc_information14 IN VARCHAR2 DEFAULT NULL
224 ,p_loc_information15 IN VARCHAR2 DEFAULT NULL
225 ,p_loc_information16 IN VARCHAR2 DEFAULT NULL
226 ,p_loc_information17 IN VARCHAR2 DEFAULT NULL
227 ,p_loc_information18 IN VARCHAR2 DEFAULT NULL
228 ,p_loc_information19 IN VARCHAR2 DEFAULT NULL
229 ,p_loc_information20 IN VARCHAR2 DEFAULT NULL
230 ,p_attribute_category IN VARCHAR2 DEFAULT NULL
231 ,p_attribute1 IN VARCHAR2 DEFAULT NULL
232 ,p_attribute2 IN VARCHAR2 DEFAULT NULL
233 ,p_attribute3 IN VARCHAR2 DEFAULT NULL
234 ,p_attribute4 IN VARCHAR2 DEFAULT NULL
235 ,p_attribute5 IN VARCHAR2 DEFAULT NULL
236 ,p_attribute6 IN VARCHAR2 DEFAULT NULL
237 ,p_attribute7 IN VARCHAR2 DEFAULT NULL
238 ,p_attribute8 IN VARCHAR2 DEFAULT NULL
239 ,p_attribute9 IN VARCHAR2 DEFAULT NULL
240 ,p_attribute10 IN VARCHAR2 DEFAULT NULL
241 ,p_attribute11 IN VARCHAR2 DEFAULT NULL
242 ,p_attribute12 IN VARCHAR2 DEFAULT NULL
243 ,p_attribute13 IN VARCHAR2 DEFAULT NULL
244 ,p_attribute14 IN VARCHAR2 DEFAULT NULL
245 ,p_attribute15 IN VARCHAR2 DEFAULT NULL
246 ,p_attribute16 IN VARCHAR2 DEFAULT NULL
247 ,p_attribute17 IN VARCHAR2 DEFAULT NULL
248 ,p_attribute18 IN VARCHAR2 DEFAULT NULL
249 ,p_attribute19 IN VARCHAR2 DEFAULT NULL
250 ,p_attribute20 IN VARCHAR2 DEFAULT NULL
251 ,p_global_attribute_category IN VARCHAR2 DEFAULT NULL
252 ,p_global_attribute1 IN VARCHAR2 DEFAULT NULL
253 ,p_global_attribute2 IN VARCHAR2 DEFAULT NULL
254 ,p_global_attribute3 IN VARCHAR2 DEFAULT NULL
255 ,p_global_attribute4 IN VARCHAR2 DEFAULT NULL
256 ,p_global_attribute5 IN VARCHAR2 DEFAULT NULL
257 ,p_global_attribute6 IN VARCHAR2 DEFAULT NULL
258 ,p_global_attribute7 IN VARCHAR2 DEFAULT NULL
259 ,p_global_attribute8 IN VARCHAR2 DEFAULT NULL
260 ,p_global_attribute9 IN VARCHAR2 DEFAULT NULL
261 ,p_global_attribute10 IN VARCHAR2 DEFAULT NULL
262 ,p_global_attribute11 IN VARCHAR2 DEFAULT NULL
263 ,p_global_attribute12 IN VARCHAR2 DEFAULT NULL
264 ,p_global_attribute13 IN VARCHAR2 DEFAULT NULL
265 ,p_global_attribute14 IN VARCHAR2 DEFAULT NULL
266 ,p_global_attribute15 IN VARCHAR2 DEFAULT NULL
267 ,p_global_attribute16 IN VARCHAR2 DEFAULT NULL
268 ,p_global_attribute17 IN VARCHAR2 DEFAULT NULL
269 ,p_global_attribute18 IN VARCHAR2 DEFAULT NULL
270 ,p_global_attribute19 IN VARCHAR2 DEFAULT NULL
271 ,p_global_attribute20 IN VARCHAR2 DEFAULT NULL
272 ,p_business_group_id IN NUMBER DEFAULT NULL
273 ,p_location_id OUT NOCOPY NUMBER
274 ,p_object_version_number OUT NOCOPY NUMBER
275 );
276 -- ----------------------------------------------------------------------------
277 -- |-------------------------------< update_location >------------------------|
278 -- ----------------------------------------------------------------------------
279 -- {Start Of Comments}
280 /*#
281 * This API updates the details of a location.
282 *
283 *
284 * <p><b>Licensing</b><br>
285 * This API is licensed for use with Human Resources and HR Foundation.
286 *
287 * <p><b>Prerequisites</b><br>
288 * The location must exist.
289 *
290 * <p><b>Post Success</b><br>
291 * The location information is updated with the details supplied.
292 *
293 * <p><b>Post Failure</b><br>
294 * The API does not update the location, and raises an error
295 * @param p_validate If true, then validation alone will be performed and the
296 * database will remain unchanged. If false and all validation checks pass,
297 * then the database will be modified.
298 * @param p_effective_date Reference date for validating lookup values are
299 * applicable during the start to end active date range. This date does not
300 * determine when the changes take effect.
301 * @param p_language_code Specifies to which language the translation values
302 * apply. You can set to the base or any installed language. The default value
303 * of hr_api.userenv_lang is equivalent to the RDBMS userenv('LANG') function
304 * value.
305 * @param p_location_id Uniquely identifies the location to be updated.
306 * @param p_location_code Unique name of the location
307 * @param p_description Description of the location
308 * @param p_timezone_code Time zone of the location.
309 * @param p_tp_header_id Identifies the inventory header. Used by Oracle EDI
310 * Gateway.
311 * @param p_ece_tp_location_code Identifies the inventory organization. Used by
312 * Oracle EDI Gateway.
313 * @param p_address_line_1 Location Address Developer Descriptive Flexfield
314 * Segment.
315 * @param p_address_line_2 Location Address Developer Descriptive Flexfield
316 * Segment.
317 * @param p_address_line_3 Location Address Developer Descriptive Flexfield
318 * Segment.
319 * @param p_bill_to_site_flag Indicates if this is a billing location
320 * @param p_country Location Address Developer Descriptive Flexfield Segment.
321 * @param p_designated_receiver_id Designated Receiver Person ID. Must be a
322 * valid employee within the scope of the location.
323 * @param p_in_organization_flag Indicates if the organization is an Internal
324 * Organization. Valid values defined in the YES/NO lookup type.
325 * @param p_inactive_date Date on which location becomes inactive. Must be
326 * greater than or equal to p_effective_date.
327 * @param p_operating_unit_id Identifies Operating Unit, used to validate the
328 * parameter p_inventory_organization_id.
329 * @param p_inventory_organization_id Identifies the Inventory Organization for
330 * this location
331 * @param p_office_site_flag Indicates whether this location can be used as an
332 * office site. Valid values are defined in the YES_NO lookup type.
333 * @param p_postal_code Location Address Developer Descriptive Flexfield
334 * Segment.
335 * @param p_receiving_site_flag Indicates whether this location can be used as
336 * a receiving site. Valid values are defined in the YES_NO lookup type.
337 * @param p_region_1 Location Address Developer Descriptive Flexfield Segment.
338 * @param p_region_2 Location Address Developer Descriptive Flexfield Segment.
339 * @param p_region_3 Location Address Developer Descriptive Flexfield Segment.
340 * @param p_ship_to_location_id Identifies the Ship To Location. If it is
341 * passed as null, it will assume the value of the current location identifier.
342 * @param p_ship_to_site_flag Indicates whether items can be shipped to this
343 * location. Valid values are defined in the YES_NO lookup type.
344 * @param p_style This context value determines which Flexfield Structure to
345 * use with the Location Address Developer Descriptive flexfield segments.
346 * @param p_tax_name This parameter is disabled.
347 * @param p_telephone_number_1 Location Address Developer Descriptive Flexfield
348 * Segment.
349 * @param p_telephone_number_2 Location Address Developer Descriptive Flexfield
350 * Segment.
351 * @param p_telephone_number_3 Location Address Developer Descriptive Flexfield
352 * Segment.
353 * @param p_town_or_city Location Address Developer Descriptive Flexfield
354 * Segment.
355 * @param p_loc_information13 Location Address Developer Descriptive Flexfield
356 * Segment.
357 * @param p_loc_information14 Location Address Developer Descriptive Flexfield
358 * Segment.
359 * @param p_loc_information15 Location Address Developer Descriptive Flexfield
360 * Segment.
361 * @param p_loc_information16 Location Address Developer Descriptive Flexfield
362 * Segment.
363 * @param p_loc_information17 Location Address Developer Descriptive Flexfield
364 * Segment.
365 * @param p_loc_information18 Location Address Developer Descriptive Flexfield
366 * Segment.
367 * @param p_loc_information19 Location Address Developer Descriptive Flexfield
368 * Segment.
369 * @param p_loc_information20 Location Address Developer Descriptive Flexfield
370 * Segment.
371 * @param p_attribute_category This context value determines which flexfield
372 * structure to use with the descriptive flexfield segments.
373 * @param p_attribute1 Descriptive flexfield segment.
374 * @param p_attribute2 Descriptive flexfield segment.
375 * @param p_attribute3 Descriptive flexfield segment.
376 * @param p_attribute4 Descriptive flexfield segment.
377 * @param p_attribute5 Descriptive flexfield segment.
378 * @param p_attribute6 Descriptive flexfield segment.
379 * @param p_attribute7 Descriptive flexfield segment.
380 * @param p_attribute8 Descriptive flexfield segment.
381 * @param p_attribute9 Descriptive flexfield segment.
382 * @param p_attribute10 Descriptive flexfield segment.
383 * @param p_attribute11 Descriptive flexfield segment.
384 * @param p_attribute12 Descriptive flexfield segment.
385 * @param p_attribute13 Descriptive flexfield segment.
386 * @param p_attribute14 Descriptive flexfield segment.
387 * @param p_attribute15 Descriptive flexfield segment.
388 * @param p_attribute16 Descriptive flexfield segment.
389 * @param p_attribute17 Descriptive flexfield segment.
390 * @param p_attribute18 Descriptive flexfield segment.
391 * @param p_attribute19 Descriptive flexfield segment.
392 * @param p_attribute20 Descriptive flexfield segment.
393 * @param p_global_attribute_category This context value determines which
394 * Flexfield Structure to use with the JG_HR_LOCATIONS Descriptive flexfield
395 * segments. Used by Oracle Regional Localizations
396 * @param p_global_attribute1 JG_HR_LOCATIONS Descriptive Flexfield Segment.
397 * Used by Oracle Regional Localizations
398 * @param p_global_attribute2 JG_HR_LOCATIONS Descriptive Flexfield Segment.
399 * Used by Oracle Regional Localizations
400 * @param p_global_attribute3 JG_HR_LOCATIONS Descriptive Flexfield Segment.
401 * Used by Oracle Regional Localizations
402 * @param p_global_attribute4 JG_HR_LOCATIONS Descriptive Flexfield Segment.
403 * Used by Oracle Regional Localizations
404 * @param p_global_attribute5 JG_HR_LOCATIONS Descriptive Flexfield Segment.
405 * Used by Oracle Regional Localizations
406 * @param p_global_attribute6 JG_HR_LOCATIONS Descriptive Flexfield Segment.
407 * Used by Oracle Regional Localizations
408 * @param p_global_attribute7 JG_HR_LOCATIONS Descriptive Flexfield Segment.
409 * Used by Oracle Regional Localizations
410 * @param p_global_attribute8 JG_HR_LOCATIONS Descriptive Flexfield Segment.
411 * Used by Oracle Regional Localizations
412 * @param p_global_attribute9 JG_HR_LOCATIONS Descriptive Flexfield Segment.
413 * Used by Oracle Regional Localizations
414 * @param p_global_attribute10 JG_HR_LOCATIONS Descriptive Flexfield Segment.
415 * Used by Oracle Regional Localizations
416 * @param p_global_attribute11 JG_HR_LOCATIONS Descriptive Flexfield Segment.
417 * Used by Oracle Regional Localizations
418 * @param p_global_attribute12 JG_HR_LOCATIONS Descriptive Flexfield Segment.
419 * Used by Oracle Regional Localizations
420 * @param p_global_attribute13 JG_HR_LOCATIONS Descriptive Flexfield Segment.
421 * Used by Oracle Regional Localizations
422 * @param p_global_attribute14 JG_HR_LOCATIONS Descriptive Flexfield Segment.
423 * Used by Oracle Regional Localizations
424 * @param p_global_attribute15 JG_HR_LOCATIONS Descriptive Flexfield Segment.
425 * Used by Oracle Regional Localizations
426 * @param p_global_attribute16 JG_HR_LOCATIONS Descriptive Flexfield Segment.
427 * Used by Oracle Regional Localizations
428 * @param p_global_attribute17 JG_HR_LOCATIONS Descriptive Flexfield Segment.
429 * Used by Oracle Regional Localizations
430 * @param p_global_attribute18 JG_HR_LOCATIONS Descriptive Flexfield Segment.
431 * Used by Oracle Regional Localizations
432 * @param p_global_attribute19 JG_HR_LOCATIONS Descriptive Flexfield Segment.
433 * Used by Oracle Regional Localizations
434 * @param p_global_attribute20 JG_HR_LOCATIONS Descriptive Flexfield Segment.
435 * Used by Oracle Regional Localizations
436 * @param p_object_version_number Pass in the current version number of the
437 * location record to be updated. When the API completes if p_validate is
438 * false, will be set to the new version number of the updated location record.
439 * If p_validate is true will be set to the same value which was passed in.
440 * @rep:displayname Update Location
441 * @rep:category BUSINESS_ENTITY HR_LOCATION
442 * @rep:category MISC_EXTENSIONS HR_DATAPUMP
443 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
444 * @rep:scope public
445 * @rep:lifecycle active
446 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
447 */
448 --
449 -- {End Of Comments}
450 --
451 PROCEDURE update_location
452 ( p_validate IN BOOLEAN DEFAULT false
453 ,p_effective_date IN DATE
454 ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
455 ,p_location_id IN NUMBER
456 ,p_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
457 ,p_description IN VARCHAR2 DEFAULT hr_api.g_varchar2
458 ,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
459 ,p_tp_header_id IN NUMBER DEFAULT hr_api.g_number
460 ,p_ece_tp_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
461 ,p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
462 ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
463 ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
464 ,p_bill_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
465 ,p_country IN VARCHAR2 DEFAULT hr_api.g_varchar2
466 ,p_designated_receiver_id IN NUMBER DEFAULT hr_api.g_number
467 ,p_in_organization_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
468 ,p_inactive_date IN DATE DEFAULT hr_api.g_date
469 ,p_operating_unit_id IN NUMBER DEFAULT NULL
470 ,p_inventory_organization_id IN NUMBER DEFAULT hr_api.g_number
471 ,p_office_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
472 ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
473 ,p_receiving_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
474 ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
475 ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
476 ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
477 ,p_ship_to_location_id IN NUMBER DEFAULT hr_api.g_number
478 ,p_ship_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
479 ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2
480 ,p_tax_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
481 ,p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
482 ,p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
483 ,p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
484 ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2
485 ,p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
486 ,p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
487 ,p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
488 ,p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
489 ,p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
490 ,p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
491 ,p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
492 ,p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
493 ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
494 ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
495 ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
496 ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
497 ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
498 ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
499 ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
500 ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
501 ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
502 ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
503 ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
504 ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
505 ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
506 ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
507 ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
508 ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
509 ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
510 ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
511 ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
512 ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
513 ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
514 ,p_global_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
515 ,p_global_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
516 ,p_global_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
517 ,p_global_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
518 ,p_global_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
519 ,p_global_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
520 ,p_global_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
521 ,p_global_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
522 ,p_global_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
523 ,p_global_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
524 ,p_global_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
525 ,p_global_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
526 ,p_global_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
527 ,p_global_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
528 ,p_global_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
529 ,p_global_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
530 ,p_global_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
531 ,p_global_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
532 ,p_global_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
533 ,p_global_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
534 ,p_global_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
535 ,p_object_version_number IN OUT NOCOPY NUMBER
536 );
537 --
538 -- ----------------------------------------------------------------------------
539 -- |--------------------------< delete_location >-----------------------------|
540 -- ----------------------------------------------------------------------------
541 -- {Start Of Comments}
542 /*#
543 * This API deletes a location.
544 *
545 *
546 * <p><b>Licensing</b><br>
547 * This API is licensed for use with Human Resources and HR Foundation.
548 *
549 * <p><b>Prerequisites</b><br>
550 * The location must exist
551 *
552 * <p><b>Post Success</b><br>
553 * The API deletes the location.
554 *
555 * <p><b>Post Failure</b><br>
556 * The API does not delete the location, and raises an error
557 * @param p_validate If true, then validation alone will be performed and the
558 * database will remain unchanged. If false and all validation checks pass,
559 * then the database will be modified.
560 * @param p_location_id Uniquely identifies the location to be deleted.
561 * @param p_object_version_number Current version number of the location to be
562 * deleted.
563 * @rep:displayname Delete Location
564 * @rep:category BUSINESS_ENTITY HR_LOCATION
565 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
566 * @rep:scope public
567 * @rep:lifecycle active
568 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
569 */
570 --
571 -- {End Of Comments}
572 --
573 PROCEDURE delete_location
574 ( p_validate IN BOOLEAN DEFAULT false
575 ,p_location_id IN hr_locations.location_id%TYPE
576 ,p_object_version_number IN hr_locations.object_version_number%TYPE
577 );
578 --
579 -- ----------------------------------------------------------------------------
580 -- |-----------------------< create_location_legal_adr >-----------------------|
581 -- ----------------------------------------------------------------------------
582 -- {Start Of Comments}
583 --
584 -- Description:
585 -- This API creates a new location as a legal address.
586 -- The legal address flag will be 'Y' for the location created.
587 --
588 -- A location that has been flagged as a legal address can be used as the legal
589 -- address for a legal entity. This functionality is used by the new financials
590 -- legal entity model which will be available in a future release of the
591 -- eBusiness Suite.
592 --
593 -- The API is MLS enabled, and there are two translated
594 -- columns: LOCATION_CODE and DESCRIPTION.
595 --
596 --
597 -- Locations are stored on the HR_LOCATIONS_ALL table. The translated
598 -- columns are stored on the HR_LOCATIONS_ALL_TL table.
599 --
600 -- The business_group_id of a location determines its scope:
601 --
602 -- If the business_group_id is NULL, the location's scope is global.
603 -- This means the location is visible to/can reference any entity
604 -- (within the scope of the current security group).
605 --
606 -- If the business_group_id is set, the location's scope is local.
607 -- This means the location is visible to/can reference any entity
608 -- within the same business_group or whose scope is global (within
609 -- the scope of the current security group).
610 --
611 --
612 -- Prerequisites:
613 --
614 -- None.
615 --
616 -- In Parameters:
617 -- Name Reqd Type Description
618 --
619 -- p_validate No Boolean If true, the database
620 -- remains unchanged. If false
621 -- then the location will be
622 -- created on the database.
623 -- p_effective_date Yes Date Used for date_track
624 -- validation.
625 -- p_language_code No Varchar2 The language used for the
626 -- initial translation values
627 -- p_location_code Yes Varchar2 Location name (Translated)
628 -- p_description No Varchar2 Location description (Translated)
629 -- p_timezone_code No Varchar2 Timezone of Location
630 -- p_address_line_1 No Varchar2 Address Flexfield
631 -- p_address_line_2 No Varchar2 Address Flexfield
632 -- p_address_line_3 No Varchar2 Address Flexfield
633 -- p_country No Varchar2 Address Flexfield
634 -- p_inactive_date No Date Date on which location becomes
635 -- p_postal_code No Varchar2 Address Flexfield
636 -- p_region_1 No Varchar2 Address Flexfield
637 -- p_region_2 No Varchar2 Address Flexfield
638 -- p_region_3 No Varchar2 Address Flexfield
639 --
640 -- p_style No Varchar2 Address Flexfield
641 -- p_town_or_city No Varchar2 Address Flexfield
642 -- p_telephone_number_1 No Varchar2 Address Flexfield
643 -- p_telephone_number_2 No Varchar2 Address Flexfield
644 -- p_telephone_number_3 No Varchar2 Address Flexfield
645 -- p_loc_information13 No Varchar2 Address Flexfield
646 -- p_loc_information14 No Varchar2 Address Flexfield
647 -- p_loc_information15 No Varchar2 Address Flexfield
648 -- p_loc_information16 No Varchar2 Address Flexfield
649 -- p_loc_information17 No Varchar2 Address Flexfield
650 -- p_loc_information18 No Varchar2 Address Flexfield
651 -- p_loc_information19 No Varchar2 Address Flexfield
652 -- p_loc_information20 No Varchar2 Address Flexfield
653 -- p_attribute_category No Varchar2 Flexfield Category
654 -- p_attribute1 No Varchar2 Flexfield
655 -- ..
656 -- p_attribute20 No Varchar2 Flexfield
657 -- p_business_group_id No Number Business group ID. A
658 -- NULL value indicates global
659 -- scope. Any other value must
660 -- index a valid business group
661 -- and sets the scope of the
662 -- location to local.
663 --
664 -- Post Success:
665 -- When the location has been successfully inserted, the following OUT
666 -- parameters are set:
667 --
668 -- Name Type Description
669 --
670 -- p_location_id Number If p_validate is false, this
671 -- contains the ID assigned to
672 -- the location (otherwise
673 -- contains NULL)
674 -- p_object_version_number Number If p_validate is false, this
675 -- contains the Object Version
676 -- Number of the newly created
677 -- row (otherwise contains NULL)
678 --
679 -- Post Failure:
680 -- The API does not create the location, and raises an error
681 --
682 -- Access Status:
683 -- Internal Development Use Only.
684 --
685 -- Special Notes:
686 -- N/A
687 -- {End Of Comments}
688 --
689 PROCEDURE create_location_legal_adr
690 ( p_validate IN BOOLEAN DEFAULT false
691 ,p_effective_date IN DATE
692 ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
693 ,p_location_code IN VARCHAR2
694 ,p_description IN VARCHAR2 DEFAULT NULL
695 ,p_timezone_code IN VARCHAR2 DEFAULT NULL
696 ,p_address_line_1 IN VARCHAR2 DEFAULT NULL
697 ,p_address_line_2 IN VARCHAR2 DEFAULT NULL
698 ,p_address_line_3 IN VARCHAR2 DEFAULT NULL
699 ,p_country IN VARCHAR2 DEFAULT NULL
700 ,p_inactive_date IN DATE DEFAULT NULL
701 ,p_postal_code IN VARCHAR2 DEFAULT NULL
702 ,p_region_1 IN VARCHAR2 DEFAULT NULL
703 ,p_region_2 IN VARCHAR2 DEFAULT NULL
704 ,p_region_3 IN VARCHAR2 DEFAULT NULL
705 ,p_style IN VARCHAR2 DEFAULT NULL
706 ,p_town_or_city IN VARCHAR2 DEFAULT NULL
707 /*Added for bug8703747 */
708 ,p_telephone_number_1 IN VARCHAR2 DEFAULT NULL
709 ,p_telephone_number_2 IN VARCHAR2 DEFAULT NULL
710 ,p_telephone_number_3 IN VARCHAR2 DEFAULT NULL
711 ,p_loc_information13 IN VARCHAR2 DEFAULT NULL
712 ,p_loc_information14 IN VARCHAR2 DEFAULT NULL
713 ,p_loc_information15 IN VARCHAR2 DEFAULT NULL
714 ,p_loc_information16 IN VARCHAR2 DEFAULT NULL
715 ,p_loc_information17 IN VARCHAR2 DEFAULT NULL
716 ,p_loc_information18 IN VARCHAR2 DEFAULT NULL
717 ,p_loc_information19 IN VARCHAR2 DEFAULT NULL
718 ,p_loc_information20 IN VARCHAR2 DEFAULT NULL
719 /*Changes end for bug8703747 */
720 ,p_attribute_category IN VARCHAR2 DEFAULT NULL
721 ,p_attribute1 IN VARCHAR2 DEFAULT NULL
722 ,p_attribute2 IN VARCHAR2 DEFAULT NULL
723 ,p_attribute3 IN VARCHAR2 DEFAULT NULL
724 ,p_attribute4 IN VARCHAR2 DEFAULT NULL
725 ,p_attribute5 IN VARCHAR2 DEFAULT NULL
726 ,p_attribute6 IN VARCHAR2 DEFAULT NULL
727 ,p_attribute7 IN VARCHAR2 DEFAULT NULL
728 ,p_attribute8 IN VARCHAR2 DEFAULT NULL
729 ,p_attribute9 IN VARCHAR2 DEFAULT NULL
730 ,p_attribute10 IN VARCHAR2 DEFAULT NULL
731 ,p_attribute11 IN VARCHAR2 DEFAULT NULL
732 ,p_attribute12 IN VARCHAR2 DEFAULT NULL
733 ,p_attribute13 IN VARCHAR2 DEFAULT NULL
734 ,p_attribute14 IN VARCHAR2 DEFAULT NULL
735 ,p_attribute15 IN VARCHAR2 DEFAULT NULL
736 ,p_attribute16 IN VARCHAR2 DEFAULT NULL
737 ,p_attribute17 IN VARCHAR2 DEFAULT NULL
738 ,p_attribute18 IN VARCHAR2 DEFAULT NULL
739 ,p_attribute19 IN VARCHAR2 DEFAULT NULL
740 ,p_attribute20 IN VARCHAR2 DEFAULT NULL
741 ,p_business_group_id IN NUMBER DEFAULT NULL
742 ,p_location_id OUT NOCOPY NUMBER
743 ,p_object_version_number OUT NOCOPY NUMBER
744 );
745 -- ----------------------------------------------------------------------------
746 -- |-----------------------< update_location_legal_adr >-----------------------|
747 -- ----------------------------------------------------------------------------
748 -- {Start Of Comments}
749 --
750 -- Description:
751 -- This API updates an existing location which has been created as a
752 -- legal adress.
753 --
754 -- A location that has been flagged as a legal address can be used as the legal
755 -- address for a legal entity. This functionality is used by the new financials
756 -- legal entity model which will be available in a future release of the
757 -- eBusiness Suite.
758 --
759 -- The API is MLS enabled, and there are two translated
760 -- columns: LOCATION_CODE and DESCRIPTION.
761 --
762 -- Locations are stored on the HR_LOCATIONS_ALL table. The translated
763 -- columns are stored on the HR_LOCATIONS_ALL_TL table. This API will call
764 -- hr_location_internal API, which is an internal API, which can not be
765 -- accessed by users.
766 --
767 -- The business_group_id of a location determines its scope:
768 --
769 -- If the business_group_id is NULL, the location's scope is global.
770 -- This means the location is visible to/can reference any entity
771 -- (within the scope of the current security group).
772 --
773 -- If the business_group_id is set, the location's scope is local.
774 -- This means the location is visible to/can reference any entity
775 -- within the same business_group or whose scope is global (within
776 -- the scope of the current security group).
777 --
778 --
779 -- Prerequisites:
780 --
781 -- None.
782 --
783 -- In Parameters:
784 -- Name Reqd Type Description
785 --
786 -- p_validate No Boolean If true, the database
787 -- remains unchanged. If false
788 -- then the location will be
789 -- created on the database.
790 -- p_effective_date Yes Date Used for date_track
791 -- validation.
792 -- p_language_code No Varchar2 Determines which translation(s)
793 -- are updated.
794 -- p_location_id Yes Number Primary Key
795 -- p_location_code No Varchar2 Location name (Translated)
796 -- p_description No Varchar2 Location description (Translated)
797 -- p_timezone_code No Varchar2 Timezone of Location
798 -- p_address_line_1 No Varchar2 Address Flexfield
799 -- p_address_line_2 No Varchar2 Address Flexfield
800 -- p_address_line_3 No Varchar2 Address Flexfield
801 -- p_country No Varchar2 Address Flexfield
802 -- p_inactive_date No Date Date on which location becomes
803 -- p_postal_code No Varchar2 Address Flexfield
804 -- p_region_1 No Varchar2 Address Flexfield
805 -- p_region_2 No Varchar2 Address Flexfield
806 -- p_region_3 No Varchar2 Address Flexfield
807 -- p_style No Varchar2 Address Flexfield
808 -- p_town_or_city No Varchar2 Address Flexfield
809 -- p_telephone_number_1 No Varchar2 Address Flexfield
810 -- p_telephone_number_2 No Varchar2 Address Flexfield
811 -- p_telephone_number_3 No Varchar2 Address Flexfield
812 -- p_loc_information13 No Varchar2 Address Flexfield
813 -- p_loc_information14 No Varchar2 Address Flexfield
814 -- p_loc_information15 No Varchar2 Address Flexfield
815 -- p_loc_information16 No Varchar2 Address Flexfield
816 -- p_loc_information17 No Varchar2 Address Flexfield
817 -- p_loc_information18 No Varchar2 Address Flexfield
818 -- p_loc_information19 No Varchar2 Address Flexfield
819 -- p_loc_information20 No Varchar2 Address Flexfield
820 -- p_attribute_category No Varchar2 Flexfield Category
821 -- p_attribute1 No Varchar2 Flexfield
822 -- ..
823 -- p_attribute20 No Varchar2 Flexfield
824 -- p_object_version_number Yes Number Object Version Number
825 --
826 -- Post Success:
827 -- When the location has been successfully updated, the following OUT
828 -- parameters are set:
829 --
830 -- Name Type Description
831 --
832 -- p_object_version_number Number If p_validate is false, this
833 -- contains the new Object
834 -- Version Number assigned to
835 -- the row (otherwise it is
836 -- left unchanged).
837 -- Post Failure:
838 -- The API does not update the location, and raises an error
839 --
840 -- Access Status:
841 -- Internal Development Use Only.
842 --
843 --
844 -- Special Notes:
845 -- N/A
846 --
847 -- {End Of Comments}
848 --
849 PROCEDURE update_location_legal_adr
850 ( p_validate IN BOOLEAN DEFAULT false
851 ,p_effective_date IN DATE
852 ,p_location_id IN NUMBER
853 ,p_description IN VARCHAR2 DEFAULT hr_api.g_varchar2
854 ,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
855 ,p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
856 ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
857 ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
858 ,p_inactive_date IN DATE DEFAULT hr_api.g_date
859 ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
860 ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
861 ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
862 ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
863 ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2
864 ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2
865 /* Added for bug8703747*/
866 ,p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
867 ,p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
868 ,p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
869 ,p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
870 ,p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
871 ,p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
872 ,p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
873 ,p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
874 ,p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
875 ,p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
876 ,p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
877 /*Changes end for bug8703747 */
878 ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
879 ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
880 ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
881 ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
882 ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
883 ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
884 ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
885 ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
886 ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
887 ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
888 ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
889 ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
890 ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
891 ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
892 ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
893 ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
894 ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
895 ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
896 ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
897 ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
898 ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
899 ,p_object_version_number IN OUT NOCOPY NUMBER
900 );
901 --
902 --------------------------------------------------------------------------------
903 PROCEDURE set_translation_globals(p_business_group_id IN NUMBER,
904 p_legislation_code IN VARCHAR2);
905 --------------------------------------------------------------------------------
906 -- ----------------------------------------------------------------------------
907 -- |-----------------------< enable_location_legal_adr >-----------------------|
908 -- ----------------------------------------------------------------------------
909 -- {Start Of Comments}
910 --
911 -- Description:
912 -- This API enables the location identified by p_location_id as a legal
913 -- address.The legal address flag will be updated to 'Y' for this location.
914 --
915 -- A location that has been flagged as a legal address can be used as the legal
916 -- address for a legal entity. This functionality is used by the new financials
917 -- legal entity model which will be available in a future release of the
918 -- eBusiness Suite.
919 --
920 -- Prerequisites:
921 --
922 -- None.
923 --
924 -- In Parameters:
925 -- Name Reqd Type Description
926 --
927 -- p_validate No Boolean If true, the database
928 -- remains unchanged. If false
929 -- then the location will be
930 -- created on the database.
931 -- p_effective_date Yes Date Used for date_track
932 -- validation.
933 -- p_location_id Yes Number Primary Key
934 -- p_object_version_number Yes Number Object Version Number
935 --
936 -- Post Success:
937 -- When the location has been successfully enabled as a legal address loaction,
938 -- the following OUT parameters are set:
939 --
940 -- Name Type Description
941 --
942 -- p_object_version_number Number If p_validate is false, this
943 -- contains the new Object
944 -- Version Number assigned to
945 -- the row (otherwise it is
946 -- left unchanged).
947 -- Post Failure:
948 -- The API does not enable the location as legal address location, and
949 -- raises an error
950 --
951 -- Access Status:
952 -- Internal Development Use Only.
953 --
954 --
955 -- Special Notes:
956 -- N/A
957 --
958 -- {End Of Comments}
959 --
960 PROCEDURE enable_location_legal_adr
961 ( p_validate IN BOOLEAN DEFAULT false
962 ,p_effective_date IN DATE
963 ,p_location_id IN NUMBER
964 ,p_object_version_number IN OUT NOCOPY NUMBER
965 );
966 --
967
968 --------------------------------------------------------------------------------
969 -- ----------------------------------------------------------------------------
970 -- |-----------------------< disable_location_legal_adr >-----------------------|
971 -- ----------------------------------------------------------------------------
972 -- {Start Of Comments}
973 --
974 -- Description:
975 -- This API disables the location identified by p_location_id as a legal
976 -- address.The legal address flag will be updated to NULL for this location.
977 --
978 -- A location that has been flagged as a legal address can be used as the legal
979 -- address for a legal entity. This functionality is used by the new financials
980 -- legal entity model which will be available in a future release of the
981 -- eBusiness Suite.
982 --
983 -- Prerequisites:
984 --
985 -- None.
986 --
987 -- In Parameters:
988 -- Name Reqd Type Description
989 --
990 -- p_validate No Boolean If true, the database
991 -- remains unchanged. If false
992 -- then the location will be
993 -- created on the database.
994 -- p_effective_date Yes Date Used for date_track
995 -- validation.
996 -- p_location_id Yes Number Primary Key
997 -- p_object_version_number Yes Number Object Version Number
998 --
999 -- Post Success:
1000 -- When the location has been successfully enabled as a legal address loaction,
1001 -- the following OUT parameters are set:
1002 --
1003 -- Name Type Description
1004 --
1005 -- p_object_version_number Number If p_validate is false, this
1006 -- contains the new Object
1007 -- Version Number assigned to
1008 -- the row (otherwise it is
1009 -- left unchanged).
1010 -- Post Failure:
1011 -- The API does not disable the legal address location, and raises an error
1012 --
1013 -- Access Status:
1014 -- Internal Development Use Only.
1015 --
1016 --
1017 -- Special Notes:
1018 -- N/A
1019 --
1020 -- {End Of Comments}
1021 --
1022 PROCEDURE disable_location_legal_adr
1023 ( p_validate IN BOOLEAN DEFAULT false
1024 ,p_effective_date IN DATE
1025 ,p_location_id IN NUMBER
1026 ,p_object_version_number IN OUT NOCOPY NUMBER
1027 );
1028 --
1029
1030 END hr_location_api;
1031 --
[Home] [Help]