1 PACKAGE hr_location_internal AUTHID CURRENT_USER AS
2 /* $Header: hrlocbsi.pkh 120.0 2005/05/31 01:20:52 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |-----------------------< create_generic_location >------------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 -- This API creates a new location, which is called from,
11 -- hr_location_api.create_location or hr_location_api.create_location_legal_adr
12 --
13 -- Locations are stored on the HR_LOCATIONS_ALL table. The translated
14 -- columns are stored on the HR_LOCATIONS_ALL_TL table.
15 --
16 -- The business_group_id of a location determines its scope:
17 --
18 -- If the business_group_id is NULL, the location's scope is global.
19 -- This means the location is visible to/can reference any entity
20 -- (within the scope of the current security group).
21 --
22 -- If the business_group_id is set, the location's scope is local.
23 -- This means the location is visible to/can reference any entity
24 -- within the same business_group or whose scope is global (within
25 -- the scope of the current security group).
26 --
27 -- Longitude and Latitude columns can hold the co-ordinates of a
28 -- location, using the decimal format. For example, 10 degrees North
29 -- and 20 degrees West is stored as:
30 -- Latitude = +10.0
31 -- Longitude = -20.0
32 --
33 --
34 -- Prerequisites:
35 --
36 -- Some fields require certain applications to have been installed. See "In
37 -- Parameters" for full details.
38 --
39 -- In Parameters:
40 -- Name Reqd Type Description
41 --
42 -- p_validate No Boolean If true, the database
43 -- remains unchanged. If false
44 -- then the location will be
45 -- created on the database.
46 -- p_effective_date Yes Date Used for date_track
47 -- validation.
48 -- p_language_code No Varchar2 The language used for the
49 -- initial translation values
50 -- p_location_code Yes Varchar2 Location name (Translated)
51 -- p_description No Varchar2 Location description (Translated)
52 -- p_timezone_code No Varchar2 Timezone for Location
53 -- p_tp_header_id No Varchar2 Inventory Header Id
54 -- p_ece_tp_location_code No Varchar2 Inventory Organization
55 -- p_address_line_1 No Varchar2 Address Flexfield
56 -- p_address_line_2 No Varchar2 Address Flexfield
57 -- p_address_line_3 No Varchar2 Address Flexfield
58 -- p_bill_to_site_flag No Varchar2 Bill-to-Site Flag
59 -- (YES/NO lookup value default 'Y')
60 -- p_country No Varchar2 Address Flexfield
61 -- p_designated_receiver_id No Varchar2 Designated Receiver Person ID
62 -- Must be a valid employee within
63 -- the scope of the location.
64 -- p_in_organization_flag No Varchar2 Internal Organization Flag
65 -- (YES/NO lookup value default 'Y')
66 -- p_inactive_date No Date Date on which location becomes
67 -- inactive. Must be greater than
68 -- or equal to p_effective_date.
69 -- p_operating_unit_id No Date Needs to be provided if
70 -- inventory_organization_id is provided.
71 -- See special notes below. Not stored
72 -- on database.
73 -- p_inventory_organization_id No Date Inventory Organization Id
74 -- p_office_site_flag No Varchar2 Office-Site Flag
75 -- (YES/NO lookup value default 'Y')
76 -- p_postal_code No Varchar2 Address Flexfield
77 -- p_receiving_site_flag No Varchar2 Receiving-Site Flag
78 -- (YES/NO lookup value default 'Y')
79 -- If the current location is a "Ship-to"
80 -- site, receiving_site_flag must also
81 -- = 'Y'
82 -- p_region_1 No Varchar2 Address Flexfield
83 -- p_region_2 No Varchar2 Address Flexfield
84 -- p_region_3 No Varchar2 Address Flexfield
85 -- p_ship_to_location_id No Number Ship-to Location Id.
86 -- Should never be NULL. IF it is
87 -- passed through as NULL, then it
88 -- will take the value of LOCATION_ID.
89 --
90 -- The following must be true for
91 -- validation to succeed:
92 -- 1). INACTIVE_DATE (if set) >=
93 -- SESSION_DATE.
94 -- 2). BUSINESS_GROUP_ID is null or
95 -- equal to the business group of the
96 -- location.
97 -- NOTE: if the business group of the
98 -- location is null do not enforce
99 -- this validation rule.
100 --
101 -- p_ship_to_site_flag No Varchar2 Ship-to-Site Flag.
102 -- Is a YES_NO column, whose value
103 -- must exist in FND_COMMON_LOOKUPS
104 -- as type YES_NO.
105 -- (i.e. must be 'Y' or 'N')
106 --
107 -- If SHIP_TO_LOCATION_ID is equal to
108 -- LOCATION_ID then the
109 -- SHIP_TO_SITE_FLAG must be 'Y'.
110 -- If the SHIP_TO_LOCATION_ID is
111 -- passed as NULL, then it takes on
112 -- the value of LOCATION_ID. If the
113 -- SHIP_TO_LOCATION_ID is some other
114 -- ID then the SHIP_TO_SITE_FLAG must
115 -- be 'N'.
116 --
117 -- p_style No Varchar2 Address Flexfield
118 -- p_tax_name No Varchar2 Tax Code
119 -- p_telephone_number_1 No Varchar2 Address Flexfield
120 -- p_telephone_number_2 No Varchar2 Address Flexfield
121 -- p_telephone_number_3 No Varchar2 Address Flexfield
122 -- p_town_or_city No Varchar2 Address Flexfield
123 -- p_loc_information13 No Varchar2 Address Flexfield
124 -- p_loc_information14 No Varchar2 Address Flexfield
125 -- p_loc_information15 No Varchar2 Address Flexfield
126 -- p_loc_information16 No Varchar2 Address Flexfield
127 -- p_loc_information17 No Varchar2 Address Flexfield
128 -- p_attribute_category No Varchar2 Flexfield Category
129 -- p_attribute1 No Varchar2 Flexfield
130 -- ..
131 -- p_attribute20 No Varchar2 Flexfield
132 -- p_global_attribute_category No Varchar2 Flexfield Category
133 -- p_global_attribute1 No Varchar2 Flexfield
134 -- ..
135 -- p_global_attribute20 No Varchar2 Flexfield
136 -- p_legal_address_flag No Varchar2 default is set to 'N'. This
137 -- will state whether or not the
138 -- location is a legal entity
139 -- p_business_group_id No Number Business group ID. A
140 -- NULL value indicates global
141 -- scope. Any other value must
142 -- index a valid business group
143 -- and sets the scope of the
144 -- location to local.
145 --
146 -- Post Success:
147 -- When the location has been successfully inserted, the following OUT
148 -- parameters are set:
149 --
150 -- Name Type Description
151 --
152 -- p_location_id Number If p_validate is false, this
153 -- contains the ID assigned to
154 -- the location (otherwise
155 -- contains NULL)
156 -- p_object_version_number Number If p_validate is false, this
157 -- contains the Object Version
158 -- Number of the newly created
159 -- row (otherwise contains NULL)
160 --
161 -- Post Failure:
162 -- The API does not create the location, and raises an error
163 --
164 -- Access Status:
165 -- Public.
166 --
167 -- Special Notes:
168 --
169 -- p_operating_unit_id is not stored on any table, merely used to
170 -- validate p_inventory_organization_id. It is not mandatory because
171 -- HR users should not have to supply the parameter.
172 --
173 -- {End Of Comments}
174 --
175 PROCEDURE create_generic_location
176 ( p_validate IN BOOLEAN DEFAULT false
177 ,p_effective_date IN DATE
178 ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
179 ,p_location_code IN VARCHAR2
180 ,p_description IN VARCHAR2 DEFAULT NULL
181 ,p_timezone_code IN VARCHAR2 DEFAULT NULL
182 ,p_tp_header_id IN NUMBER DEFAULT NULL
183 ,p_ece_tp_location_code IN VARCHAR2 DEFAULT NULL
184 ,p_address_line_1 IN VARCHAR2 DEFAULT NULL
185 ,p_address_line_2 IN VARCHAR2 DEFAULT NULL
186 ,p_address_line_3 IN VARCHAR2 DEFAULT NULL
187 ,p_bill_to_site_flag IN VARCHAR2 DEFAULT 'Y'
188 ,p_country IN VARCHAR2 DEFAULT NULL
189 ,p_designated_receiver_id IN NUMBER DEFAULT NULL
190 ,p_in_organization_flag IN VARCHAR2 DEFAULT 'Y'
191 ,p_inactive_date IN DATE DEFAULT NULL
192 ,p_operating_unit_id IN NUMBER DEFAULT NULL
193 ,p_inventory_organization_id IN NUMBER DEFAULT NULL
194 ,p_office_site_flag IN VARCHAR2 DEFAULT 'Y'
195 ,p_postal_code IN VARCHAR2 DEFAULT NULL
196 ,p_receiving_site_flag IN VARCHAR2 DEFAULT 'Y'
197 ,p_region_1 IN VARCHAR2 DEFAULT NULL
198 ,p_region_2 IN VARCHAR2 DEFAULT NULL
199 ,p_region_3 IN VARCHAR2 DEFAULT NULL
200 ,p_ship_to_location_id IN NUMBER DEFAULT NULL
201 ,p_ship_to_site_flag IN VARCHAR2 DEFAULT 'Y'
202 ,p_style IN VARCHAR2 DEFAULT NULL
203 ,p_tax_name IN VARCHAR2 DEFAULT NULL
204 ,p_telephone_number_1 IN VARCHAR2 DEFAULT NULL
205 ,p_telephone_number_2 IN VARCHAR2 DEFAULT NULL
206 ,p_telephone_number_3 IN VARCHAR2 DEFAULT NULL
207 ,p_town_or_city IN VARCHAR2 DEFAULT NULL
208 ,p_loc_information13 IN VARCHAR2 DEFAULT NULL
209 ,p_loc_information14 IN VARCHAR2 DEFAULT NULL
210 ,p_loc_information15 IN VARCHAR2 DEFAULT NULL
211 ,p_loc_information16 IN VARCHAR2 DEFAULT NULL
212 ,p_loc_information17 IN VARCHAR2 DEFAULT NULL
213 ,p_loc_information18 IN VARCHAR2 DEFAULT NULL
214 ,p_loc_information19 IN VARCHAR2 DEFAULT NULL
215 ,p_loc_information20 IN VARCHAR2 DEFAULT NULL
216 ,p_attribute_category IN VARCHAR2 DEFAULT NULL
217 ,p_attribute1 IN VARCHAR2 DEFAULT NULL
218 ,p_attribute2 IN VARCHAR2 DEFAULT NULL
219 ,p_attribute3 IN VARCHAR2 DEFAULT NULL
220 ,p_attribute4 IN VARCHAR2 DEFAULT NULL
221 ,p_attribute5 IN VARCHAR2 DEFAULT NULL
222 ,p_attribute6 IN VARCHAR2 DEFAULT NULL
223 ,p_attribute7 IN VARCHAR2 DEFAULT NULL
224 ,p_attribute8 IN VARCHAR2 DEFAULT NULL
225 ,p_attribute9 IN VARCHAR2 DEFAULT NULL
226 ,p_attribute10 IN VARCHAR2 DEFAULT NULL
227 ,p_attribute11 IN VARCHAR2 DEFAULT NULL
228 ,p_attribute12 IN VARCHAR2 DEFAULT NULL
229 ,p_attribute13 IN VARCHAR2 DEFAULT NULL
230 ,p_attribute14 IN VARCHAR2 DEFAULT NULL
231 ,p_attribute15 IN VARCHAR2 DEFAULT NULL
232 ,p_attribute16 IN VARCHAR2 DEFAULT NULL
233 ,p_attribute17 IN VARCHAR2 DEFAULT NULL
234 ,p_attribute18 IN VARCHAR2 DEFAULT NULL
235 ,p_attribute19 IN VARCHAR2 DEFAULT NULL
236 ,p_attribute20 IN VARCHAR2 DEFAULT NULL
237 ,p_global_attribute_category IN VARCHAR2 DEFAULT NULL
238 ,p_global_attribute1 IN VARCHAR2 DEFAULT NULL
239 ,p_global_attribute2 IN VARCHAR2 DEFAULT NULL
240 ,p_global_attribute3 IN VARCHAR2 DEFAULT NULL
241 ,p_global_attribute4 IN VARCHAR2 DEFAULT NULL
242 ,p_global_attribute5 IN VARCHAR2 DEFAULT NULL
243 ,p_global_attribute6 IN VARCHAR2 DEFAULT NULL
244 ,p_global_attribute7 IN VARCHAR2 DEFAULT NULL
245 ,p_global_attribute8 IN VARCHAR2 DEFAULT NULL
246 ,p_global_attribute9 IN VARCHAR2 DEFAULT NULL
247 ,p_global_attribute10 IN VARCHAR2 DEFAULT NULL
248 ,p_global_attribute11 IN VARCHAR2 DEFAULT NULL
249 ,p_global_attribute12 IN VARCHAR2 DEFAULT NULL
250 ,p_global_attribute13 IN VARCHAR2 DEFAULT NULL
251 ,p_global_attribute14 IN VARCHAR2 DEFAULT NULL
252 ,p_global_attribute15 IN VARCHAR2 DEFAULT NULL
253 ,p_global_attribute16 IN VARCHAR2 DEFAULT NULL
254 ,p_global_attribute17 IN VARCHAR2 DEFAULT NULL
255 ,p_global_attribute18 IN VARCHAR2 DEFAULT NULL
256 ,p_global_attribute19 IN VARCHAR2 DEFAULT NULL
257 ,p_global_attribute20 IN VARCHAR2 DEFAULT NULL
258 ,p_business_group_id IN NUMBER DEFAULT NULL
259 ,p_legal_address_flag IN VARCHAR2 DEFAULT NULL
260 ,p_location_id OUT NOCOPY NUMBER
261 ,p_object_version_number OUT NOCOPY NUMBER
262 );
263 -- ----------------------------------------------------------------------------
264 -- |-------------------------< update_generic_location >---------------------|
265 -- ----------------------------------------------------------------------------
266 -- {Start Of Comments}
267 --
268 -- Description:
269 -- This API creates a new location, which is called from,
270 -- hr_location_api.create_location or hr_location_api.create_location_legal_adr
271 --
272 -- Locations are stored on the HR_LOCATIONS_ALL table. The translated
273 -- columns are stored on the HR_LOCATIONS_ALL_TL table.
274 --
275 -- The business_group_id of a location determines its scope:
276 --
277 -- If the business_group_id is NULL, the location's scope is global.
278 -- This means the location is visible to/can reference any entity
279 -- (within the scope of the current security group).
280 --
281 -- If the business_group_id is set, the location's scope is local.
282 -- This means the location is visible to/can reference any entity
283 -- within the same business_group or whose scope is global (within
284 -- the scope of the current security group).
285 --
286 -- Longitude and Latitude columns can hold the co-ordinates of a
287 -- location, using the decimal format. For example, 10 degrees North
288 -- and 20 degrees West is stored as:
289 -- Latitude = +10.0
290 -- Longitude = -20.0
291 --
292 -- Prerequisites:
293 --
294 -- Some fields require certain applications to have been installed. See "In
295 -- Parameters" for full details.
296 --
297 -- In Parameters:
298 -- Name Reqd Type Description
299 --
300 -- p_validate No Boolean If true, the database
301 -- remains unchanged. If false
302 -- then the location will be
303 -- created on the database.
304 -- p_effective_date Yes Date Used for date_track
305 -- validation.
306 -- p_language_code No Varchar2 Determines which translation(s)
307 -- are updated.
308 -- p_location_id Yes Varchar2 Primary Key
309 -- p_location_code No Varchar2 Location name (Translated)
310 -- p_description No Varchar2 Location description (Translated)
311 -- p_timezone_code No Varchar2 Timezone for Location
312 -- p_tp_header_id No Varchar2 Inventory Header Id
313 -- p_ece_tp_location_code No Varchar2 Inventory Organization
314 -- p_address_line_1 No Varchar2 Address Flexfield
315 -- p_address_line_2 No Varchar2 Address Flexfield
316 -- p_address_line_3 No Varchar2 Address Flexfield
317 -- p_bill_to_site_flag No Varchar2 Bill-to-Site Flag
318 -- (YES/NO lookup value default 'Y')
319 -- p_country No Varchar2 Address Flexfield
320 -- p_designated_receiver_id No Varchar2 Designated Receiver Person ID
321 -- Must be a valid employee within
322 -- the scope of the location.
323 -- p_in_organization_flag No Varchar2 Internal Organization Flag
324 -- (YES/NO lookup value default 'Y')
325 -- p_inactive_date No Date Date on which location becomes
326 -- inactive. Must be greater than
327 -- or equal to p_effective_date.
328 -- p_operating_unit_id No Date Needs to be provided if
329 -- inventory_organization_id is provided.
330 -- See special notes below. Not stored
331 -- on database.
332 -- p_inventory_organization_id No Date Inventory Organization Id
333 -- p_office_site_flag No Varchar2 Office-Site Flag
334 -- (YES/NO lookup value default 'Y')
335 -- p_postal_code No Varchar2 Address Flexfield
336 -- p_receiving_site_flag No Varchar2 Receiving-Site Flag
337 -- (YES/NO lookup value default 'Y')
338 -- If the current location is a "Ship-to"
339 -- site, receiving_site_flag must also
340 -- = 'Y'
341 -- p_region_1 No Varchar2 Address Flexfield
342 -- p_region_2 No Varchar2 Address Flexfield
343 -- p_region_3 No Varchar2 Address Flexfield
344 -- p_ship_to_location_id No Number Ship-to Location Id.
345 -- Must be an active "Ship-to"
346 -- location within the scope
347 -- of the current location.
348 -- p_ship_to_site_flag No Varchar2 Ship-to-Site Flag
349 -- (YES/NO lookup value default 'Y')
350 -- If ship_to_location_id is NULL,
351 -- no further validation is performed.
352 -- If ship_to_location_id is not NULL,
353 -- ship_to_site_flag must be 'Y' if
354 -- the "Ship-to" location is the
355 -- current location, otherwise it
356 -- must be 'N'
357 -- p_style No Varchar2 Address Flexfield
358 -- p_tax_name No Varchar2 Tax Code
359 -- p_telephone_number_1 No Varchar2 Address Flexfield
360 -- p_telephone_number_2 No Varchar2 Address Flexfield
361 -- p_telephone_number_3 No Varchar2 Address Flexfield
362 -- p_town_or_city No Varchar2 Address Flexfield
363 -- p_loc_information13 No Varchar2 Address Flexfield
364 -- p_loc_information14 No Varchar2 Address Flexfield
365 -- p_loc_information15 No Varchar2 Address Flexfield
366 -- p_loc_information16 No Varchar2 Address Flexfield
367 -- p_loc_information17 No Varchar2 Address Flexfield
368 -- p_attribute_category No Varchar2 Flexfield Category
369 -- p_attribute1 No Varchar2 Flexfield
370 -- ..
371 -- p_attribute20 No Varchar2 Flexfield
372 -- p_global_attribute_category No Varchar2 Flexfield Category
373 -- p_global_attribute1 No Varchar2 Flexfield
374 -- ..
375 -- p_global_attribute20 No Varchar2 Flexfield
376 -- p_legal_address_flag No Varchar2 default is set to NULL. This
377 -- will state whether or not the
378 -- location is a legal entity
379 -- p_object_version_number Yes Number Object Version Number
380 --
381 -- Post Success:
382 -- When the location has been successfully inserted, the following OUT
383 -- parameters are set:
384 --
385 -- Name Type Description
386 --
387 -- p_object_version_number Number If p_validate is false, this
388 -- contains the new Object
389 -- Version Number assigned to
390 -- the row (otherwise it is
391 -- left unchanged).
392 -- Post Failure:
393 -- The API does not update the location, and raises an error
394 --
395 -- Access Status:
396 -- Public.
397 --
398 --
399 -- Special Notes:
400 --
401 -- p_operating_unit_id defaults to NULL because it is not stored on any table,
402 -- merely used to validate p_inventory_organization_id. It is not mandatory
403 -- because HR users should not have to supply the parameter.
404 --
405 -- {End Of Comments}
406 --
407 PROCEDURE update_generic_location
408 ( p_validate IN BOOLEAN DEFAULT false
409 ,p_effective_date IN DATE
410 ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
411 ,p_location_id IN NUMBER
412 ,p_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
413 ,p_description IN VARCHAR2 DEFAULT hr_api.g_varchar2
414 ,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
415 ,p_tp_header_id IN NUMBER DEFAULT hr_api.g_number
416 ,p_ece_tp_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
417 ,p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
418 ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
419 ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
420 ,p_bill_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
421 ,p_country IN VARCHAR2 DEFAULT hr_api.g_varchar2
422 ,p_designated_receiver_id IN NUMBER DEFAULT hr_api.g_number
423 ,p_in_organization_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
424 ,p_inactive_date IN DATE DEFAULT hr_api.g_date
425 ,p_operating_unit_id IN NUMBER DEFAULT NULL
426 ,p_inventory_organization_id IN NUMBER DEFAULT hr_api.g_number
427 ,p_office_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
428 ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
429 ,p_receiving_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
430 ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
431 ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
432 ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
433 ,p_ship_to_location_id IN NUMBER DEFAULT hr_api.g_number
434 ,p_ship_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
435 ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2
436 ,p_tax_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
437 ,p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
438 ,p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
439 ,p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
440 ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2
441 ,p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
442 ,p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
443 ,p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
444 ,p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
445 ,p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
446 ,p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
447 ,p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
448 ,p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
449 ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
450 ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
451 ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
452 ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
453 ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
454 ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
455 ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
456 ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
457 ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
458 ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
459 ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
460 ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
461 ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
462 ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
463 ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
464 ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
465 ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
466 ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
467 ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
468 ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
469 ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
470 ,p_global_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
471 ,p_global_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
472 ,p_global_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
473 ,p_global_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
474 ,p_global_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
475 ,p_global_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
476 ,p_global_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
477 ,p_global_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
478 ,p_global_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
479 ,p_global_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
480 ,p_global_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
481 ,p_global_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
482 ,p_global_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
483 ,p_global_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
484 ,p_global_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
485 ,p_global_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
486 ,p_global_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
487 ,p_global_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
488 ,p_global_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
489 ,p_global_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
490 ,p_global_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
491 ,p_legal_address_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
492 ,p_object_version_number IN OUT NOCOPY NUMBER
493 );
494 --
495 --------------------------------------------------------------------------------
496 END hr_location_internal;
497 --
[Home] [Help]