1 PACKAGE hr_in_location_api AS
2 /* $Header: pelocini.pkh 120.1 2005/10/02 02:42 aroussel $ */
3 /*#
4 * This package contains location APIs.
5 * @rep:scope public
6 * @rep:product PER
7 * @rep:displayname Location for India
8 */
9 --
10 -- ----------------------------------------------------------------------------
11 -- |----------------------------< create_in_location >------------------------|
12 -- ----------------------------------------------------------------------------
13 --
14 -- {Start Of Comments}
15 /*#
16 * This API creates a new location.
17 *
18 * The API is MLS enabled, and there are two translated columns: LOCATION_CODE
19 * and DESCRIPTION. The business_group_id of a location determines its scope.
20 * If the business_group_id is NULL, the location's scope is global. If the
21 * business_group_id is set, the location's scope is local.
22 *
23 * <p><b>Licensing</b><br>
24 * This API is licensed for use with Human Resources.
25 *
26 * <p><b>Prerequisites</b><br>
27 * Some fields require certain applications to be installed. See "In
28 * Parameters" for full details.
29 *
30 * <p><b>Post Success</b><br>
31 * A new location will be created.
32 *
33 * <p><b>Post Failure</b><br>
34 * The API does not create a location and raises an error.
35 *
36 * @param p_validate If true, then validation alone will be performed and the
37 * database will remain unchanged. If false and all validation checks pass,
38 * then the database will be modified.
39 * @param p_effective_date Determines when the DateTrack operation comes into
40 * force.
41 * @param p_language_code Specifies to which language the translation values
42 * apply. You can set to the base or any installed language. The default value
43 * of hr_api.userenv_lang is equivalent to the RDBMS userenv('LANG') function
44 * value.
45 * @param p_location_code Location name (Translated).
46 * @param p_description Location description (Translated).
47 * @param p_timezone_code Timezone of Location.
48 * @param p_tp_header_id Identifier for the Inventory Header.
49 * @param p_ece_tp_location_code Inventory Organization.
50 * @param p_flat_door_block Flat/Door/Block of the address.
51 * @param p_building_village Building/Village of the address.
52 * @param p_road_street Road/Street of the address.
53 * @param p_bill_to_site_flag Bill-to-Site Flag. Valid values are defined by
54 * 'YES/NO' lookup type. Default 'Y'.
55 * @param p_country Country of the address. If Address stye is India then the
56 * value will be India else wil get the valid values from FND_TERRITORIES
57 * @param p_designated_receiver_id Designated Receiver Person ID Must be a
58 * valid employee within the scope of the location
59 * @param p_in_organization_flag Internal Organization Flag. Valid values are
60 * defined by 'YES/NO' lookup type. Default 'Y'.
61 * @param p_inactive_date Date on which location becomes inactive. Must be
62 * greater than or equal to p_effective_date.
63 * @param p_operating_unit_id Needs to be provided if inventory_organization_id
64 * is provided. See special notes below. Not stored on database.
65 * @param p_inventory_organization_id Identifier for the Inventory Organization
66 * @param p_office_site_flag Office-Site Flag. Valid values are defined by
67 * 'YES/NO' lookup type. Default 'Y'.
68 * @param p_postal_code Postal code of the address. If Address stye is India
69 * then the first two digits must be valid for a state. Valid values are
70 * defined by 'IN_PIN_CODES' lookup type.
71 * @param p_receiving_site_flag Receiving-Site Flag. Valid values are defined
72 * by 'YES/NO' lookup type. Default 'Y'. If the current location is a 'Ship-to'
73 * site receiving_site_flag must also = 'Y'.
74 * @param p_ship_to_location_id Ship-to Location Id. Should never be NULL. IF
75 * it is passed through as NULL, then it will take the value of LOCATION_ID.
76 * The following must be true for validation to succeed: 1). INACTIVE_DATE (if
77 * set) >= SESSION_DATE. 2). BUSINESS_GROUP_ID is null or equal to the
78 * business group of the location. NOTE: if the business group of the location
79 * is null do not enforce this validation rule.
80 * @param p_ship_to_site_flag Ship-to-Site Flag. Valid values are defined by
81 * 'YES/NO' lookup type. If SHIP_TO_LOCATION_ID is equal to LOCATION_ID then
82 * the SHIP_TO_SITE_FLAG must be 'Y'. If the SHIP_TO_LOCATION_ID is passed as
83 * NULL, then it takes on the value of LOCATION_ID. If the SHIP_TO_LOCATION_ID
84 * is some other ID then the SHIP_TO_SITE_FLAG must be 'N'.
85 * @param p_style Address Flexfield.
86 * @param p_tax_name Tax Code.
87 * @param p_telephone_number Telephone Number of the address.
88 * @param p_fax_number Fax Number of the address.
89 * @param p_area Area/Locality of the address.
90 * @param p_town_city_district Town/City/District of the address.
91 * @param p_state_ut State/UT of the address. If Address stye is India then the
92 * valid values are defined by 'IN_STATES' lookup type.
93 * @param p_email Email.
94 * @param p_attribute_category This context value determines which flexfield
95 * structure to use with the descriptive flexfield segments.
96 * @param p_attribute1 Descriptive flexfield segment.
97 * @param p_attribute2 Descriptive flexfield segment.
98 * @param p_attribute3 Descriptive flexfield segment.
99 * @param p_attribute4 Descriptive flexfield segment.
100 * @param p_attribute5 Descriptive flexfield segment.
101 * @param p_attribute6 Descriptive flexfield segment.
102 * @param p_attribute7 Descriptive flexfield segment.
103 * @param p_attribute8 Descriptive flexfield segment.
104 * @param p_attribute9 Descriptive flexfield segment.
105 * @param p_attribute10 Descriptive flexfield segment.
106 * @param p_attribute11 Descriptive flexfield segment.
107 * @param p_attribute12 Descriptive flexfield segment.
108 * @param p_attribute13 Descriptive flexfield segment.
109 * @param p_attribute14 Descriptive flexfield segment.
110 * @param p_attribute15 Descriptive flexfield segment.
111 * @param p_attribute16 Descriptive flexfield segment.
112 * @param p_attribute17 Descriptive flexfield segment.
113 * @param p_attribute18 Descriptive flexfield segment.
114 * @param p_attribute19 Descriptive flexfield segment.
115 * @param p_attribute20 Descriptive flexfield segment.
116 * @param p_global_attribute_category The global context value which flexfield
117 * structure uses with the descriptive flexfield segments.
118 * @param p_global_attribute1 Descriptive flexfield segment.
119 * @param p_global_attribute2 Descriptive flexfield segment.
120 * @param p_global_attribute3 Descriptive flexfield segment.
121 * @param p_global_attribute4 Descriptive flexfield segment.
122 * @param p_global_attribute5 Descriptive flexfield segment.
123 * @param p_global_attribute6 Descriptive flexfield segment.
124 * @param p_global_attribute7 Descriptive flexfield segment.
125 * @param p_global_attribute8 Descriptive flexfield segment.
126 * @param p_global_attribute9 Descriptive flexfield segment.
127 * @param p_global_attribute10 Descriptive flexfield segment.
128 * @param p_global_attribute11 Descriptive flexfield segment.
129 * @param p_global_attribute12 Descriptive flexfield segment.
130 * @param p_global_attribute13 Descriptive flexfield segment.
131 * @param p_global_attribute14 Descriptive flexfield segment.
132 * @param p_global_attribute15 Descriptive flexfield segment.
133 * @param p_global_attribute16 Descriptive flexfield segment.
134 * @param p_global_attribute17 Descriptive flexfield segment.
135 * @param p_global_attribute18 Descriptive flexfield segment.
136 * @param p_global_attribute19 Descriptive flexfield segment.
137 * @param p_global_attribute20 Descriptive flexfield segment.
138 * @param p_business_group_id Business group ID. A NULL value indicates global
139 * scope. Any other value must index a valid business group and set the scope
140 * of the location to local.
141 * @param p_location_id If p_validate is false, this contains the ID assigned
142 * to the location (otherwise contains NULL).
143 * @param p_object_version_number If p_validate is false, then set to the
144 * version number of the created location. If p_validate is true, then the
145 * value will be null.
146 * @rep:displayname Create Location for India
147 * @rep:category BUSINESS_ENTITY HR_LOCATION
148 * @rep:lifecycle active
149 * @rep:category MISC_EXTENSIONS HR_DATAPUMP
150 * @rep:scope public
151 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
152 */
153 --
154 -- {End Of Comments}
155 --
156 PROCEDURE create_in_location
157 ( p_validate IN BOOLEAN DEFAULT false
158 ,p_effective_date IN DATE
159 ,p_language_code IN VARCHAR2 DEFAULT null
160 ,p_location_code IN VARCHAR2
161 ,p_description IN VARCHAR2 DEFAULT NULL
162 ,p_timezone_code IN VARCHAR2 DEFAULT NULL
163 ,p_tp_header_id IN NUMBER DEFAULT NULL
164 ,p_ece_tp_location_code IN VARCHAR2 DEFAULT NULL
165 ,p_flat_door_block IN VARCHAR2
166 ,p_building_village IN VARCHAR2 DEFAULT NULL
167 ,p_road_street IN VARCHAR2 DEFAULT NULL
168 ,p_bill_to_site_flag IN VARCHAR2 DEFAULT 'Y'
169 ,p_country IN VARCHAR2 DEFAULT NULL
170 ,p_designated_receiver_id IN NUMBER DEFAULT NULL
171 ,p_in_organization_flag IN VARCHAR2 DEFAULT 'Y'
172 ,p_inactive_date IN DATE DEFAULT NULL
173 ,p_operating_unit_id IN NUMBER DEFAULT NULL
174 ,p_inventory_organization_id IN NUMBER DEFAULT NULL
175 ,p_office_site_flag IN VARCHAR2 DEFAULT 'Y'
176 ,p_postal_code IN VARCHAR2 DEFAULT NULL
177 ,p_receiving_site_flag IN VARCHAR2 DEFAULT 'Y'
178 ,p_ship_to_location_id IN NUMBER DEFAULT NULL
179 ,p_ship_to_site_flag IN VARCHAR2 DEFAULT 'Y'
180 ,p_style IN VARCHAR2 DEFAULT NULL
181 ,p_tax_name IN VARCHAR2 DEFAULT NULL
182 ,p_telephone_number IN VARCHAR2 DEFAULT NULL
183 ,p_fax_number IN VARCHAR2 DEFAULT NULL
184 ,p_area IN VARCHAR2 DEFAULT NULL
185 ,p_town_city_district IN VARCHAR2
186 ,p_state_ut IN VARCHAR2 DEFAULT NULL
187 ,p_email IN VARCHAR2 DEFAULT NULL
188 ,p_attribute_category IN VARCHAR2 DEFAULT NULL
189 ,p_attribute1 IN VARCHAR2 DEFAULT NULL
190 ,p_attribute2 IN VARCHAR2 DEFAULT NULL
191 ,p_attribute3 IN VARCHAR2 DEFAULT NULL
192 ,p_attribute4 IN VARCHAR2 DEFAULT NULL
193 ,p_attribute5 IN VARCHAR2 DEFAULT NULL
194 ,p_attribute6 IN VARCHAR2 DEFAULT NULL
195 ,p_attribute7 IN VARCHAR2 DEFAULT NULL
196 ,p_attribute8 IN VARCHAR2 DEFAULT NULL
197 ,p_attribute9 IN VARCHAR2 DEFAULT NULL
198 ,p_attribute10 IN VARCHAR2 DEFAULT NULL
199 ,p_attribute11 IN VARCHAR2 DEFAULT NULL
200 ,p_attribute12 IN VARCHAR2 DEFAULT NULL
201 ,p_attribute13 IN VARCHAR2 DEFAULT NULL
202 ,p_attribute14 IN VARCHAR2 DEFAULT NULL
203 ,p_attribute15 IN VARCHAR2 DEFAULT NULL
204 ,p_attribute16 IN VARCHAR2 DEFAULT NULL
205 ,p_attribute17 IN VARCHAR2 DEFAULT NULL
206 ,p_attribute18 IN VARCHAR2 DEFAULT NULL
207 ,p_attribute19 IN VARCHAR2 DEFAULT NULL
208 ,p_attribute20 IN VARCHAR2 DEFAULT NULL
209 ,p_global_attribute_category IN VARCHAR2 DEFAULT NULL
210 ,p_global_attribute1 IN VARCHAR2 DEFAULT NULL
211 ,p_global_attribute2 IN VARCHAR2 DEFAULT NULL
212 ,p_global_attribute3 IN VARCHAR2 DEFAULT NULL
213 ,p_global_attribute4 IN VARCHAR2 DEFAULT NULL
214 ,p_global_attribute5 IN VARCHAR2 DEFAULT NULL
215 ,p_global_attribute6 IN VARCHAR2 DEFAULT NULL
216 ,p_global_attribute7 IN VARCHAR2 DEFAULT NULL
217 ,p_global_attribute8 IN VARCHAR2 DEFAULT NULL
218 ,p_global_attribute9 IN VARCHAR2 DEFAULT NULL
219 ,p_global_attribute10 IN VARCHAR2 DEFAULT NULL
220 ,p_global_attribute11 IN VARCHAR2 DEFAULT NULL
221 ,p_global_attribute12 IN VARCHAR2 DEFAULT NULL
222 ,p_global_attribute13 IN VARCHAR2 DEFAULT NULL
223 ,p_global_attribute14 IN VARCHAR2 DEFAULT NULL
224 ,p_global_attribute15 IN VARCHAR2 DEFAULT NULL
225 ,p_global_attribute16 IN VARCHAR2 DEFAULT NULL
226 ,p_global_attribute17 IN VARCHAR2 DEFAULT NULL
227 ,p_global_attribute18 IN VARCHAR2 DEFAULT NULL
228 ,p_global_attribute19 IN VARCHAR2 DEFAULT NULL
229 ,p_global_attribute20 IN VARCHAR2 DEFAULT NULL
230 ,p_business_group_id IN NUMBER DEFAULT NULL
231 ,p_location_id OUT NOCOPY NUMBER
232 ,p_object_version_number OUT NOCOPY NUMBER
233 ) ;
234 --
235 -- ----------------------------------------------------------------------------
236 -- |----------------------------< update_in_location >------------------------|
237 -- ----------------------------------------------------------------------------
238 --
239 -- {Start Of Comments}
240 /*#
241 * This API updates a location.
242 *
243 * The API is MLS enabled, and there are two translated columns: LOCATION_CODE
244 * and DESCRIPTION. The business_group_id of a location determines its scope.
245 * If the business_group_id is NULL, the location's scope is global. If the
246 * business_group_id is set, the location's scope is local.
247 *
248 * <p><b>Licensing</b><br>
249 * This API is licensed for use with Human Resources.
250 *
251 * <p><b>Prerequisites</b><br>
252 * Some fields require certain applications to have been installed.See "In
253 * Parameters" for full details.
254 *
255 * <p><b>Post Success</b><br>
256 * The location will be updated.
257 *
258 * <p><b>Post Failure</b><br>
259 * The API will not update the location and will raise an error.
260 *
261 * @param p_validate If true, then validation alone will be performed and the
262 * database will remain unchanged. If false and all validation checks pass,
263 * then the database will be modified.
264 * @param p_effective_date Determines when the DateTrack operation comes into
265 * force.
266 * @param p_language_code Specifies to which language the translation values
267 * apply. You can set to the base or any installed language. The default value
268 * of hr_api.userenv_lang is equivalent to the RDBMS userenv('LANG') function
269 * value.
270 * @param p_location_id Primary Key of the location to be updated.
271 * @param p_location_code Location name (Translated).
272 * @param p_description Location description (Translated).
273 * @param p_timezone_code Timezone of Location.
274 * @param p_tp_header_id Identifier for the Inventory Header.
275 * @param p_ece_tp_location_code Inventory Organization.
276 * @param p_flat_door_block Flat/Door/Block of the address.
277 * @param p_building_village Building/Village of the address.
278 * @param p_road_street Road/Street of the address.
279 * @param p_bill_to_site_flag Bill-to-Site Flag. Valid values are defined by
280 * 'YES/NO' lookup type. Default 'Y'.
281 * @param p_country Country of the address. If Address stye is India then the
282 * value will be India else wil get the valid values from FND_TERRITORIES
283 * @param p_designated_receiver_id Designated Receiver Person ID Must be a
284 * valid employee within the scope of the location.
285 * @param p_in_organization_flag Internal Organization Flag. Valid values are
286 * defined by 'YES/NO' lookup type. Default 'Y'.
287 * @param p_inactive_date Date on which location becomes inactive. Must be
288 * greater than or equal to p_effective_date.
289 * @param p_operating_unit_id Needs to be provided if inventory_organization_id
290 * is provided. See special notes below. Not stored on database.
291 * @param p_inventory_organization_id Identifier for the Inventory
292 * Organization.
293 * @param p_office_site_flag Office-Site Flag. Valid values are defined by
294 * 'YES/NO' lookup type. Default 'Y'.
295 * @param p_postal_code Postal code of the address. If Address stye is India
296 * then the first two digits must be valid for a state. Valid values are
300 * site receiving_site_flag must also = 'Y'.
297 * defined by 'IN_PIN_CODES' lookup type.
298 * @param p_receiving_site_flag Receiving-Site Flag. Valid values are defined
299 * by 'YES/NO' lookup type. Default 'Y'. If the current location is a 'Ship-to'
301 * @param p_ship_to_location_id Ship-to Location Id. Must be an active
302 * 'Ship-to' location within the scope of the current location.
303 * @param p_ship_to_site_flag Ship-to-Site Flag. Valid values are defined by
304 * 'YES/NO' lookup type. Default 'Y'. If ship_to_location_id is NULL, no
305 * further validation is performed. If ship_to_location_id is not NULL,
306 * ship_to_site_flag must be 'Y' if the 'Ship-to' location is the current
307 * location, otherwise it must be 'N'.
308 * @param p_style Address Flexfield.
309 * @param p_tax_name Tax Code.
310 * @param p_telephone_number Telephone Number of the address.
311 * @param p_fax_number Fax Number of the address.
312 * @param p_area Area/Locality of the address.
313 * @param p_town_city_district Town/City/District of the address.
314 * @param p_state_ut State/UT of the address. If Address stye is India then the
315 * valid values are defined by 'IN_STATES' lookup type.
316 * @param p_email Email.
317 * @param p_attribute_category This context value determines which flexfield
318 * structure to use with the descriptive flexfield segments.
319 * @param p_attribute1 Descriptive flexfield segment.
320 * @param p_attribute2 Descriptive flexfield segment.
321 * @param p_attribute3 Descriptive flexfield segment.
322 * @param p_attribute4 Descriptive flexfield segment.
323 * @param p_attribute5 Descriptive flexfield segment.
324 * @param p_attribute6 Descriptive flexfield segment.
325 * @param p_attribute7 Descriptive flexfield segment.
326 * @param p_attribute8 Descriptive flexfield segment.
327 * @param p_attribute9 Descriptive flexfield segment.
328 * @param p_attribute10 Descriptive flexfield segment.
329 * @param p_attribute11 Descriptive flexfield segment.
330 * @param p_attribute12 Descriptive flexfield segment.
331 * @param p_attribute13 Descriptive flexfield segment.
332 * @param p_attribute14 Descriptive flexfield segment.
333 * @param p_attribute15 Descriptive flexfield segment.
334 * @param p_attribute16 Descriptive flexfield segment.
335 * @param p_attribute17 Descriptive flexfield segment.
336 * @param p_attribute18 Descriptive flexfield segment.
337 * @param p_attribute19 Descriptive flexfield segment.
338 * @param p_attribute20 Descriptive flexfield segment.
339 * @param p_global_attribute_category The global context value which flexfield
340 * structure uses with the descriptive flexfield segments.
341 * @param p_global_attribute1 Descriptive flexfield segment.
342 * @param p_global_attribute2 Descriptive flexfield segment.
343 * @param p_global_attribute3 Descriptive flexfield segment.
344 * @param p_global_attribute4 Descriptive flexfield segment.
345 * @param p_global_attribute5 Descriptive flexfield segment.
346 * @param p_global_attribute6 Descriptive flexfield segment.
347 * @param p_global_attribute7 Descriptive flexfield segment.
348 * @param p_global_attribute8 Descriptive flexfield segment.
349 * @param p_global_attribute9 Descriptive flexfield segment.
350 * @param p_global_attribute10 Descriptive flexfield segment.
351 * @param p_global_attribute11 Descriptive flexfield segment.
352 * @param p_global_attribute12 Descriptive flexfield segment.
353 * @param p_global_attribute13 Descriptive flexfield segment.
354 * @param p_global_attribute14 Descriptive flexfield segment.
355 * @param p_global_attribute15 Descriptive flexfield segment.
356 * @param p_global_attribute16 Descriptive flexfield segment.
357 * @param p_global_attribute17 Descriptive flexfield segment.
358 * @param p_global_attribute18 Descriptive flexfield segment.
359 * @param p_global_attribute19 Descriptive flexfield segment.
360 * @param p_global_attribute20 Descriptive flexfield segment.
361 * @param p_object_version_number Pass in the current version number of the
362 * location to be updated. When the API completes if p_validate is false, will
363 * be set to the new version number of the updated location. If p_validate is
364 * true will be set to the same value which was passed in.
365 * @rep:displayname Update Location for India
366 * @rep:category BUSINESS_ENTITY HR_LOCATION
367 * @rep:lifecycle active
368 * @rep:category MISC_EXTENSIONS HR_DATAPUMP
369 * @rep:scope public
370 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
371 */
372 --
373 -- {End Of Comments}
374 --
375 PROCEDURE update_in_location
376 ( p_validate IN BOOLEAN DEFAULT false
377 ,p_effective_date IN DATE
378 ,p_language_code IN VARCHAR2 DEFAULT null
379 ,p_location_id IN NUMBER
380 ,p_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
381 ,p_description IN VARCHAR2 DEFAULT hr_api.g_varchar2
382 ,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
383 ,p_tp_header_id IN NUMBER DEFAULT hr_api.g_number
384 ,p_ece_tp_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
385 ,p_flat_door_block IN VARCHAR2 DEFAULT hr_api.g_varchar2
386 ,p_building_village IN VARCHAR2 DEFAULT hr_api.g_varchar2
387 ,p_road_street IN VARCHAR2 DEFAULT hr_api.g_varchar2
388 ,p_bill_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
389 ,p_country IN VARCHAR2 DEFAULT hr_api.g_varchar2
390 ,p_designated_receiver_id IN NUMBER DEFAULT hr_api.g_number
394 ,p_inventory_organization_id IN NUMBER DEFAULT hr_api.g_number
391 ,p_in_organization_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
392 ,p_inactive_date IN DATE DEFAULT hr_api.g_date
393 ,p_operating_unit_id IN NUMBER DEFAULT NULL
395 ,p_office_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
396 ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
397 ,p_receiving_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
398 ,p_ship_to_location_id IN NUMBER DEFAULT hr_api.g_number
399 ,p_ship_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
400 ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2
401 ,p_tax_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
402 ,p_telephone_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
403 ,p_fax_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
404 ,p_area IN VARCHAR2 DEFAULT hr_api.g_varchar2
405 ,p_town_city_district IN VARCHAR2 DEFAULT hr_api.g_varchar2
406 ,p_state_ut IN VARCHAR2 DEFAULT hr_api.g_varchar2
407 ,p_email IN VARCHAR2 DEFAULT hr_api.g_varchar2
408 ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
409 ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
410 ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
411 ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
412 ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
413 ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
414 ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
415 ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
416 ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
417 ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
418 ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
419 ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
420 ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
421 ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
422 ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
423 ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
424 ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
425 ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
426 ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
427 ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
428 ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
429 ,p_global_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
430 ,p_global_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
431 ,p_global_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
432 ,p_global_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
433 ,p_global_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
434 ,p_global_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
435 ,p_global_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
436 ,p_global_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
437 ,p_global_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
438 ,p_global_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
439 ,p_global_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
440 ,p_global_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
441 ,p_global_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
442 ,p_global_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
443 ,p_global_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
444 ,p_global_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
445 ,p_global_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
446 ,p_global_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
447 ,p_global_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
448 ,p_global_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
449 ,p_global_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
450 ,p_object_version_number IN OUT NOCOPY NUMBER
451 ) ;
452 END hr_in_location_api ;
[Home] [Help]