1 PACKAGE hr_organization_api AUTHID CURRENT_USER AS
2 /* $Header: hrorgapi.pkh 120.16 2009/04/14 09:46:42 sathkris ship $ */
3 /*#
4 * This package contains APIs that create and manage HR Organizations.
5 * @rep:scope public
6 * @rep:product per
7 * @rep:displayname Organization
8 */
9 --
10 -- ----------------------------------------------------------------------------
11 -- |--------------------------< create_hr_organization >----------------------|
12 -- ----------------------------------------------------------------------------
13 --
14 -- {Start Of Comments}
15 /*#
16 * This API creates an organization with the classification HR Organization.
17 *
18 *
19 * <p><b>Licensing</b><br>
20 * This API is licensed for use with Human Resources.
21 *
22 * <p><b>Prerequisites</b><br>
23 * None
24 *
25 * <p><b>Post Success</b><br>
26 * Organization with the classification of hr organization is created.
27 *
28 * <p><b>Post Failure</b><br>
29 * Organization is not created and error is raised.
30 *
31 * @param p_validate If true, then validation alone will be performed and the
32 * database will remain unchanged. If false and all validation checks pass,
33 * then the database will be modified.
34 * @param p_effective_date Reference date for validating lookup values are
35 * applicable during the start to end active date range. This date does not
36 * determine when the changes take effect.
37 * @param p_business_group_id Uniquely identifies the business group associated
38 * with the organization the process creates.
39 * @param p_name The name of the organization the process creates.
40 * @param p_date_from Date the organization takes effect.
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_id Uniquely identifies the location of the organization.
46 * @param p_date_to Date the organization is no longer in effect.
47 * @param p_internal_external_flag Flag specifying if the organization is an
48 * internal or external organization.
49 * @param p_internal_address_line Internal Address Line.
50 * @param p_type The organization type associated with the organization the
51 * process creates. Valid values are determined by the ORG_TYPE lookup type.
52 * @param p_enabled_flag Flag specifying if the organization information is
53 * enabled. The default value is 'N'.
54 * @param p_segment1 Cost allocation key flexfield segment
55 * @param p_segment2 Cost allocation key flexfield segment
56 * @param p_segment3 Cost allocation key flexfield segment
57 * @param p_segment4 Cost allocation key flexfield segment
58 * @param p_segment5 Cost allocation key flexfield segment
59 * @param p_segment6 Cost allocation key flexfield segment
60 * @param p_segment7 Cost allocation key flexfield segment
61 * @param p_segment8 Cost allocation key flexfield segment
62 * @param p_segment9 Cost allocation key flexfield segment
63 * @param p_segment10 Cost allocation key flexfield segment
64 * @param p_segment11 Cost allocation key flexfield segment
65 * @param p_segment12 Cost allocation key flexfield segment
66 * @param p_segment13 Cost allocation key flexfield segment
67 * @param p_segment14 Cost allocation key flexfield segment
68 * @param p_segment15 Cost allocation key flexfield segment
69 * @param p_segment16 Cost allocation key flexfield segment
70 * @param p_segment17 Cost allocation key flexfield segment
71 * @param p_segment18 Cost allocation key flexfield segment
72 * @param p_segment19 Cost allocation key flexfield segment
73 * @param p_segment20 Cost allocation key flexfield segment
74 * @param p_segment21 Cost allocation key flexfield segment
75 * @param p_segment22 Cost allocation key flexfield segment
76 * @param p_segment23 Cost allocation key flexfield segment
77 * @param p_segment24 Cost allocation key flexfield segment
78 * @param p_segment25 Cost allocation key flexfield segment
79 * @param p_segment26 Cost allocation key flexfield segment
80 * @param p_segment27 Cost allocation key flexfield segment
81 * @param p_segment28 Cost allocation key flexfield segment
82 * @param p_segment29 Cost allocation key flexfield segment
83 * @param p_segment30 Cost allocation key flexfield segment
84 * @param p_concat_segments Cost Allocation Flexfield concatenated segments.
85 * @param p_object_version_number_inf If p_validate is false, then set to the
89 * version number of the created organization row. If p_validate is true, then
86 * version number of the created organization information row. If p_validate is
87 * true, then the value will be null.
88 * @param p_object_version_number_org If p_validate is false, then set to the
90 * the value will be null.
91 * @param p_organization_id If p_validate is false, then this uniquely
92 * identifies the organization created. If p_validate is true, then set to
93 * null..
94 * @param p_org_information_id If p_validate is false, this uniquely identifies
95 * the organization information created. If p_validate is true, then set to
96 * null.
97 * @param p_duplicate_org_warning The value is 'true' if an organization
98 * already exists with the same name in a different business group. (If the
99 * duplicate is in the same business group, the process raises an error.)
100 * @rep:displayname Create HR Organization
101 * @rep:category BUSINESS_ENTITY HR_ORGANIZATION
102 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
103 * @rep:scope public
104 * @rep:lifecycle active
105 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
106 */
107 --
108 -- {End Of Comments}
109 --
110 procedure create_hr_organization
111 (p_validate in boolean default false
112 ,p_effective_date in date
113 ,p_business_group_id in number
114 ,p_name in varchar2
115 ,p_date_from in date
116 ,p_language_code in varchar2 default hr_api.userenv_lang
117 ,p_location_id in number default null
118 ,p_date_to in date default null
119 ,p_internal_external_flag in varchar2 default null
120 ,p_internal_address_line in varchar2 default null
121 ,p_type in varchar2 default null
122 ,p_enabled_flag in varchar2 default 'N'
123 ,p_segment1 in varchar2 default null
124 ,p_segment2 in varchar2 default null
125 ,p_segment3 in varchar2 default null
126 ,p_segment4 in varchar2 default null
127 ,p_segment5 in varchar2 default null
128 ,p_segment6 in varchar2 default null
129 ,p_segment7 in varchar2 default null
130 ,p_segment8 in varchar2 default null
131 ,p_segment9 in varchar2 default null
132 ,p_segment10 in varchar2 default null
133 ,p_segment11 in varchar2 default null
134 ,p_segment12 in varchar2 default null
135 ,p_segment13 in varchar2 default null
136 ,p_segment14 in varchar2 default null
137 ,p_segment15 in varchar2 default null
138 ,p_segment16 in varchar2 default null
139 ,p_segment17 in varchar2 default null
140 ,p_segment18 in varchar2 default null
141 ,p_segment19 in varchar2 default null
142 ,p_segment20 in varchar2 default null
143 ,p_segment21 in varchar2 default null
144 ,p_segment22 in varchar2 default null
145 ,p_segment23 in varchar2 default null
146 ,p_segment24 in varchar2 default null
147 ,p_segment25 in varchar2 default null
148 ,p_segment26 in varchar2 default null
149 ,p_segment27 in varchar2 default null
150 ,p_segment28 in varchar2 default null
151 ,p_segment29 in varchar2 default null
152 ,p_segment30 in varchar2 default null
153 ,p_concat_segments in varchar2 default null
154 ,p_object_version_number_inf out nocopy number
155 ,p_object_version_number_org out nocopy number
156 ,p_organization_id out nocopy number
157 ,p_org_information_id out nocopy number
158 ,p_duplicate_org_warning out nocopy boolean
159 );
160 --
161 -- ----------------------------------------------------------------------------
162 -- |---------------------------< create_organization >------------------------|
163 -- ----------------------------------------------------------------------------
164 --
165 -- This version of the API is now out-of-date however it has been provided to
166 -- you for backward compatibility support and will be removed in the future.
167 -- Oracle recommends you to modify existing calling programs in advance of the
168 -- support being withdrawn thus avoiding any potential disruption.
169 --
170 PROCEDURE create_organization
171 ( p_validate IN BOOLEAN DEFAULT false
172 ,p_effective_date IN DATE
173 ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
174 ,p_business_group_id IN NUMBER
175 ,p_date_from IN DATE
176 ,p_name IN VARCHAR2
177 ,p_location_id in number default null
178 ,p_date_to in date default null
179 ,p_internal_external_flag in varchar2 default null
180 ,p_internal_address_line in varchar2 default null
181 ,p_type in varchar2 default null
182 ,p_comments in varchar2 default null
183 ,p_attribute_category in varchar2 default null
184 ,p_attribute1 in varchar2 default null
185 ,p_attribute2 in varchar2 default null
186 ,p_attribute3 in varchar2 default null
187 ,p_attribute4 in varchar2 default null
188 ,p_attribute5 in varchar2 default null
192 ,p_attribute9 in varchar2 default null
189 ,p_attribute6 in varchar2 default null
190 ,p_attribute7 in varchar2 default null
191 ,p_attribute8 in varchar2 default null
193 ,p_attribute10 in varchar2 default null
194 ,p_attribute11 in varchar2 default null
195 ,p_attribute12 in varchar2 default null
196 ,p_attribute13 in varchar2 default null
197 ,p_attribute14 in varchar2 default null
198 ,p_attribute15 in varchar2 default null
199 ,p_attribute16 in varchar2 default null
200 ,p_attribute17 in varchar2 default null
201 ,p_attribute18 in varchar2 default null
202 ,p_attribute19 in varchar2 default null
203 ,p_attribute20 in varchar2 default null
204 --Enhancement 4040086
205 --Begin of Add 10 additional segments
206 ,p_attribute21 in varchar2 default null
207 ,p_attribute22 in varchar2 default null
208 ,p_attribute23 in varchar2 default null
209 ,p_attribute24 in varchar2 default null
210 ,p_attribute25 in varchar2 default null
211 ,p_attribute26 in varchar2 default null
212 ,p_attribute27 in varchar2 default null
213 ,p_attribute28 in varchar2 default null
214 ,p_attribute29 in varchar2 default null
215 ,p_attribute30 in varchar2 default null
216 --End of Add 10 additional segments
217 ,p_organization_id OUT NOCOPY NUMBER
218 ,p_object_version_number OUT NOCOPY NUMBER
219 );
220 --
221 -- ----------------------------------------------------------------------------
222 -- |---------------------------< create_organization >------------------------|
223 -- ----------------------------------------------------------------------------
224 --
225 -- {Start Of Comments}
226 /*#
227 * This API creates a new organization within the scope of an existing business
228 * group.
229 *
230 * The API is MLS enabled, and there is one translated column (NAME).
231 *
232 * <p><b>Licensing</b><br>
233 * This API is licensed for use with Human Resources and HR Foundation.
234 *
235 * <p><b>Prerequisites</b><br>
236 * None
237 *
238 * <p><b>Post Success</b><br>
239 * Organization is created.
240 *
241 * <p><b>Post Failure</b><br>
242 * Organization not created and error returned.
243 * @param p_validate If true, then validation alone will be performed and the
244 * database will remain unchanged. If false and all validation checks pass,
245 * then the database will be modified.
246 * @param p_effective_date Reference date for validating lookup values are
247 * applicable during the start to end active date range. This date does not
248 * determine when the changes take effect.
249 * @param p_language_code Specifies to which language the translation values
250 * apply. You can set to the base or any installed language. The default value
251 * of hr_api.userenv_lang is equivalent to the RDBMS userenv('LANG') function
252 * value.
253 * @param p_business_group_id Uniquely identifies the business group associated
254 * with the organization the process creates.
255 * @param p_date_from Date the organization takes effect.
256 * @param p_name The name of the organization the process creates (translated).
257 * @param p_location_id Uniquely identifies the location of the organization.
258 * @param p_date_to Date when the organization is no longer in effect.
259 * @param p_internal_external_flag Internal or external organization flag.
260 * @param p_internal_address_line Internal address Line.
261 * @param p_type The organization type associated with the organization the
262 * process creates. Valid values are determined by the ORG_TYPE lookup type.
263 * @param p_comments Comment text
264 * @param p_attribute_category This context value determines which flexfield
265 * structure to use with the descriptive flexfield segments.
266 * @param p_attribute1 Descriptive flexfield segment.
267 * @param p_attribute2 Descriptive flexfield segment.
268 * @param p_attribute3 Descriptive flexfield segment.
269 * @param p_attribute4 Descriptive flexfield segment.
270 * @param p_attribute5 Descriptive flexfield segment.
271 * @param p_attribute6 Descriptive flexfield segment.
272 * @param p_attribute7 Descriptive flexfield segment.
273 * @param p_attribute8 Descriptive flexfield segment.
274 * @param p_attribute9 Descriptive flexfield segment.
275 * @param p_attribute10 Descriptive flexfield segment.
276 * @param p_attribute11 Descriptive flexfield segment.
277 * @param p_attribute12 Descriptive flexfield segment.
278 * @param p_attribute13 Descriptive flexfield segment.
279 * @param p_attribute14 Descriptive flexfield segment.
280 * @param p_attribute15 Descriptive flexfield segment.
281 * @param p_attribute16 Descriptive flexfield segment.
282 * @param p_attribute17 Descriptive flexfield segment.
283 * @param p_attribute18 Descriptive flexfield segment.
284 * @param p_attribute19 Descriptive flexfield segment.
285 * @param p_attribute20 Descriptive flexfield segment.
286 * @param p_attribute21 Descriptive flexfield segment.
287 * @param p_attribute22 Descriptive flexfield segment.
288 * @param p_attribute23 Descriptive flexfield segment.
289 * @param p_attribute24 Descriptive flexfield segment.
290 * @param p_attribute25 Descriptive flexfield segment.
291 * @param p_attribute26 Descriptive flexfield segment.
292 * @param p_attribute27 Descriptive flexfield segment.
293 * @param p_attribute28 Descriptive flexfield segment.
294 * @param p_attribute29 Descriptive flexfield segment.
298 * null.
295 * @param p_attribute30 Descriptive flexfield segment.
296 * @param p_organization_id If p_validate is false, then this uniquely
297 * identifies the Organization created. If p_validate is true, then set to
299 * @param p_object_version_number If p_validate is false, then set to the
300 * version number of the organization created. If p_validate is true, then set
301 * to null..
302 * @param p_duplicate_org_warning The value is 'true' if an organization
303 * already exists with the same name in a different business group. (If the
304 * duplicate is in the same business group, the process raises an error.)
305 * @rep:displayname Create Organization
306 * @rep:category BUSINESS_ENTITY HR_ORGANIZATION
307 * @rep:category MISC_EXTENSIONS HR_DATAPUMP
308 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
309 * @rep:scope public
310 * @rep:lifecycle active
311 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
312 */
313 --
314 -- {End Of Comments}
315 --
316
317 PROCEDURE create_organization
318 ( p_validate IN BOOLEAN DEFAULT false
319 ,p_effective_date IN DATE
320 ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
321 ,p_business_group_id IN NUMBER
322 ,p_date_from IN DATE
323 ,p_name IN VARCHAR2
324 ,p_location_id in number default null
325 ,p_date_to in date default null
326 ,p_internal_external_flag in varchar2 default null
327 ,p_internal_address_line in varchar2 default null
328 ,p_type in varchar2 default null
329 ,p_comments in varchar2 default null
330 ,p_attribute_category in varchar2 default null
331 ,p_attribute1 in varchar2 default null
332 ,p_attribute2 in varchar2 default null
333 ,p_attribute3 in varchar2 default null
334 ,p_attribute4 in varchar2 default null
335 ,p_attribute5 in varchar2 default null
336 ,p_attribute6 in varchar2 default null
337 ,p_attribute7 in varchar2 default null
338 ,p_attribute8 in varchar2 default null
339 ,p_attribute9 in varchar2 default null
340 ,p_attribute10 in varchar2 default null
341 ,p_attribute11 in varchar2 default null
342 ,p_attribute12 in varchar2 default null
343 ,p_attribute13 in varchar2 default null
344 ,p_attribute14 in varchar2 default null
345 ,p_attribute15 in varchar2 default null
346 ,p_attribute16 in varchar2 default null
347 ,p_attribute17 in varchar2 default null
348 ,p_attribute18 in varchar2 default null
349 ,p_attribute19 in varchar2 default null
350 ,p_attribute20 in varchar2 default null
351 --Enhancement 4040086
352 --Begin of Add 10 additional segments
353 ,p_attribute21 in varchar2 default null
354 ,p_attribute22 in varchar2 default null
355 ,p_attribute23 in varchar2 default null
356 ,p_attribute24 in varchar2 default null
357 ,p_attribute25 in varchar2 default null
358 ,p_attribute26 in varchar2 default null
359 ,p_attribute27 in varchar2 default null
360 ,p_attribute28 in varchar2 default null
361 ,p_attribute29 in varchar2 default null
362 ,p_attribute30 in varchar2 default null
363 --End of Add 10 additional segments
364 ,p_organization_id OUT NOCOPY NUMBER
365 ,p_object_version_number OUT NOCOPY NUMBER
366 ,p_duplicate_org_warning OUT NOCOPY BOOLEAN
367 );
368
369 --
370 -- ----------------------------------------------------------------------------
371 -- |---------------------------< update_organization >------------------------|
372 -- ----------------------------------------------------------------------------
373 --
374 -- {Start Of Comments}
375 /*#
376 * This API Updates an existing Organization.
377 *
378 * You cannot update the name or business_group_id attributes. The process
379 * stores organizations in the table HR_ALL_ORGANIZATION_UNITS.
380 *
381 * <p><b>Licensing</b><br>
382 * This API is licensed for use with Human Resources and HR Foundation.
383 *
384 * <p><b>Prerequisites</b><br>
385 * Organization must exist.
386 *
387 * <p><b>Post Success</b><br>
388 * When the location has been successfully inserted, the following OUT
389 * parameters are set:
390 *
391 * <p><b>Post Failure</b><br>
392 * The API does not update the organization, and raises an error
393 * @param p_validate If true, then validation alone will be performed and the
394 * database will remain unchanged. If false and all validation checks pass,
395 * then the database will be modified.
396 * @param p_effective_date Reference date for validating lookup values are
397 * applicable during the start to end active date range. This date does not
398 * determine when the changes take effect.
399 * @param p_language_code Specifies to which language the translation values
400 * apply. You can set to the base or any installed language. The default value
401 * of hr_api.userenv_lang is equivalent to the RDBMS userenv('LANG') function
402 * value.
403 * @param p_name Name of the organization (translated).
404 * @param p_organization_id Uniquely identifies the organization record to
405 * modify.
409 * @param p_date_to Date till when the organization is in effect.
406 * @param p_cost_allocation_keyflex_id Cost Allocation Key Flex ID
407 * @param p_location_id Uniquely identifies the location of the organization.
408 * @param p_date_from Date the organization takes effect.
410 * @param p_internal_external_flag Internal External Flag
411 * @param p_internal_address_line Internal Address Line.
412 * @param p_type The organization type associated with the organization the
413 * process creates. Valid values are determined by the ORG_TYPE lookup type.
414 * @param p_comments Comment Text
415 * @param p_attribute_category This context value determines which flexfield
416 * structure to use with the descriptive flexfield segments.
417 * @param p_attribute1 Descriptive flexfield segment.
418 * @param p_attribute2 Descriptive flexfield segment.
419 * @param p_attribute3 Descriptive flexfield segment.
420 * @param p_attribute4 Descriptive flexfield segment.
421 * @param p_attribute5 Descriptive flexfield segment.
422 * @param p_attribute6 Descriptive flexfield segment.
423 * @param p_attribute7 Descriptive flexfield segment.
424 * @param p_attribute8 Descriptive flexfield segment.
425 * @param p_attribute9 Descriptive flexfield segment.
426 * @param p_attribute10 Descriptive flexfield segment.
427 * @param p_attribute11 Descriptive flexfield segment.
428 * @param p_attribute12 Descriptive flexfield segment.
429 * @param p_attribute13 Descriptive flexfield segment.
430 * @param p_attribute14 Descriptive flexfield segment.
431 * @param p_attribute15 Descriptive flexfield segment.
432 * @param p_attribute16 Descriptive flexfield segment.
433 * @param p_attribute17 Descriptive flexfield segment.
434 * @param p_attribute18 Descriptive flexfield segment.
435 * @param p_attribute19 Descriptive flexfield segment.
436 * @param p_attribute20 Descriptive flexfield segment.
437 * @param p_attribute21 Descriptive flexfield segment.
438 * @param p_attribute22 Descriptive flexfield segment.
439 * @param p_attribute23 Descriptive flexfield segment.
440 * @param p_attribute24 Descriptive flexfield segment.
441 * @param p_attribute25 Descriptive flexfield segment.
442 * @param p_attribute26 Descriptive flexfield segment.
443 * @param p_attribute27 Descriptive flexfield segment.
444 * @param p_attribute28 Descriptive flexfield segment.
445 * @param p_attribute29 Descriptive flexfield segment.
446 * @param p_attribute30 Descriptive flexfield segment.
447 * @param p_segment1 Cost allocation key flexfield segment
448 * @param p_segment2 Cost allocation key flexfield segment
449 * @param p_segment3 Cost allocation key flexfield segment
450 * @param p_segment4 Cost allocation key flexfield segment
451 * @param p_segment5 Cost allocation key flexfield segment
452 * @param p_segment6 Cost allocation key flexfield segment
453 * @param p_segment7 Cost allocation key flexfield segment
454 * @param p_segment8 Cost allocation key flexfield segment
455 * @param p_segment9 Cost allocation key flexfield segment
456 * @param p_segment10 Cost allocation key flexfield segment
457 * @param p_segment11 Cost allocation key flexfield segment
458 * @param p_segment12 Cost allocation key flexfield segment
459 * @param p_segment13 Cost allocation key flexfield segment
460 * @param p_segment14 Cost allocation key flexfield segment
461 * @param p_segment15 Cost allocation key flexfield segment
462 * @param p_segment16 Cost allocation key flexfield segment
463 * @param p_segment17 Cost allocation key flexfield segment
464 * @param p_segment18 Cost allocation key flexfield segment
465 * @param p_segment19 Cost allocation key flexfield segment
466 * @param p_segment20 Cost allocation key flexfield segment
467 * @param p_segment21 Cost allocation key flexfield segment
468 * @param p_segment22 Cost allocation key flexfield segment
469 * @param p_segment23 Cost allocation key flexfield segment
470 * @param p_segment24 Cost allocation key flexfield segment
471 * @param p_segment25 Cost allocation key flexfield segment
472 * @param p_segment26 Cost allocation key flexfield segment
473 * @param p_segment27 Cost allocation key flexfield segment
474 * @param p_segment28 Cost allocation key flexfield segment
475 * @param p_segment29 Cost allocation key flexfield segment
476 * @param p_segment30 Cost allocation key flexfield segment
477 * @param p_concat_segments Cost allocation key flexfield segment
478 * @param p_object_version_number Pass in the current version number of the
479 * Organization to be updated. When the API completes if p_validate is false,
480 * will be set to the new version number of the updated Organization. If
481 * p_validate is true will be set to the same value which was passed in.
482 * @param p_duplicate_org_warning The value is 'true' if an organization
483 * already exists with the same name in a different business group. (If the
484 * duplicate is in the same business group, the process raises an error).
485 * @rep:displayname Update Organization
486 * @rep:category BUSINESS_ENTITY HR_ORGANIZATION
487 * @rep:category MISC_EXTENSIONS HR_DATAPUMP
488 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
489 * @rep:scope public
490 * @rep:lifecycle active
491 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
492 */
493 --
494 -- {End Of Comments}
495 --
496 PROCEDURE update_organization
497 ( p_validate IN BOOLEAN DEFAULT false
498 ,p_effective_date IN DATE
499 ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
500 --
501 ,p_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
502 ,p_organization_id IN NUMBER
503 ,p_cost_allocation_keyflex_id IN NUMBER DEFAULT hr_api.g_number
504 ,p_location_id IN NUMBER DEFAULT hr_api.g_number
505 -- Bug 3040119
506 --,p_soft_coding_keyflex_id IN NUMBER DEFAULT hr_api.g_number
507 ,p_date_from IN DATE DEFAULT hr_api.g_date
511 ,p_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
508 ,p_date_to IN DATE DEFAULT hr_api.g_date
509 ,p_internal_external_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
510 ,p_internal_address_line IN VARCHAR2 DEFAULT hr_api.g_varchar2
512 ,p_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2
513 ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
514 ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
515 ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
516 ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
517 ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
518 ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
519 ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
520 ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
521 ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
522 ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
523 ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
524 ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
525 ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
526 ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
527 ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
528 ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
529 ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
530 ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
531 ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
532 ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
533 ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
534 --Enhancement 4040086
535 --Begin of Add 10 additional segments
536 ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
537 ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
538 ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
539 ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
540 ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
541 ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
542 ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
543 ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
544 ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
545 ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
546 --End of Add 10 additional segments
547 -- Bug 3039046
548 ,p_segment1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
549 ,p_segment2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
550 ,p_segment3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
551 ,p_segment4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
552 ,p_segment5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
553 ,p_segment6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
554 ,p_segment7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
555 ,p_segment8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
556 ,p_segment9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
557 ,p_segment10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
558 ,p_segment11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
559 ,p_segment12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
560 ,p_segment13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
561 ,p_segment14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
562 ,p_segment15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
563 ,p_segment16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
564 ,p_segment17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
565 ,p_segment18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
566 ,p_segment19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
567 ,p_segment20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
568 ,p_segment21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
569 ,p_segment22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
570 ,p_segment23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
571 ,p_segment24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
572 ,p_segment25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
573 ,p_segment26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
574 ,p_segment27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
575 ,p_segment28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
576 ,p_segment29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
577 ,p_segment30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
578 ,p_concat_segments IN VARCHAR2 DEFAULT hr_api.g_varchar2
579 --
580 ,p_object_version_number IN OUT NOCOPY NUMBER
581 ,p_duplicate_org_warning OUT NOCOPY BOOLEAN
582 );
583 --
584 -- ----------------------------------------------------------------------------
585 -- |---------------------------< update_organization >------------------------|
586 -- ----------------------------------------------------------------------------
587 --
588 -- This version of the API is now out-of-date however it has been provided to
589 -- you for backward compatibility support and will be removed in the future.
590 -- Oracle recommends you to modify existing calling programs in advance of the
594 PROCEDURE update_organization
591 -- support being withdrawn thus avoiding any potential disruption.
592 --
593
598 --
595 ( p_validate IN BOOLEAN DEFAULT false
596 ,p_effective_date IN DATE
597 ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
599 ,p_organization_id IN NUMBER
600 ,p_cost_allocation_keyflex_id IN NUMBER DEFAULT hr_api.g_number
601 ,p_location_id IN NUMBER DEFAULT hr_api.g_number
602 -- Bug 3040119
603 --,p_soft_coding_keyflex_id IN NUMBER DEFAULT hr_api.g_number
604 ,p_date_from IN DATE DEFAULT hr_api.g_date
605 ,p_date_to IN DATE DEFAULT hr_api.g_date
606 ,p_internal_external_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
607 ,p_internal_address_line IN VARCHAR2 DEFAULT hr_api.g_varchar2
608 ,p_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
609 ,p_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2
610 ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
611 ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
612 ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
613 ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
614 ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
615 ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
616 ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
617 ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
618 ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
619 ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
620 ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
621 ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
622 ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
623 ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
624 ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
625 ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
626 ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
627 ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
628 ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
629 ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
630 ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
631 --Enhancement 4040086
632 --Begin of Add 10 additional segments
633 ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
634 ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
635 ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
636 ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
637 ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
638 ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
639 ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
640 ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
641 ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
642 ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
643 -- Bug 3039046
644 ,p_segment1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
645 ,p_segment2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
646 ,p_segment3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
647 ,p_segment4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
648 ,p_segment5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
649 ,p_segment6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
650 ,p_segment7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
651 ,p_segment8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
652 ,p_segment9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
653 ,p_segment10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
654 ,p_segment11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
655 ,p_segment12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
656 ,p_segment13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
657 ,p_segment14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
658 ,p_segment15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
659 ,p_segment16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
660 ,p_segment17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
664 ,p_segment21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
661 ,p_segment18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
662 ,p_segment19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
663 ,p_segment20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
665 ,p_segment22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
666 ,p_segment23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
667 ,p_segment24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
668 ,p_segment25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
669 ,p_segment26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
670 ,p_segment27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
671 ,p_segment28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
672 ,p_segment29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
673 ,p_segment30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
674 ,p_concat_segments IN VARCHAR2 DEFAULT hr_api.g_varchar2
675 --
676 ,p_object_version_number IN OUT NOCOPY NUMBER
677 );
678 --
679 -- ----------------------------------------------------------------------------
680 -- |---------------------------< delete_organization >------------------------|
681 -- ----------------------------------------------------------------------------
682 --
683 -- {Start Of Comments}
684 /*#
685 * This API deletes an organization.
686 *
687 * This API deletes an organization from the HR_ALL_ORGANIZATION_UNITS table,
688 * and its associated translated rows from the HR_ALL_ORGANIZATION_UNITS_TL
689 * table.
690 *
691 * <p><b>Licensing</b><br>
692 * This API is licensed for use with Human Resources and HR Foundation.
693 *
694 * <p><b>Prerequisites</b><br>
695 * Organization should exist.
696 *
697 * <p><b>Post Success</b><br>
698 * Organization is deleted.
699 *
700 * <p><b>Post Failure</b><br>
701 * Organization is not deleted and error is returned.
702 * @param p_validate If true, then validation alone will be performed and the
703 * database will remain unchanged. If false and all validation checks pass,
704 * then the database will be modified.
705 * @param p_organization_id Identifies the organization record to deleted.
706 * @param p_object_version_number Current version number of the Organization to
707 * be deleted.
708 * @rep:displayname Delete Organization
709 * @rep:category BUSINESS_ENTITY HR_ORGANIZATION
710 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
711 * @rep:scope public
712 * @rep:lifecycle active
713 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
714 */
715 --
716 -- {End Of Comments}
717 --
718 PROCEDURE delete_organization
719 ( p_validate IN BOOLEAN DEFAULT false
720 ,p_organization_id IN hr_all_organization_units.organization_id%TYPE
721 ,p_object_version_number IN hr_all_organization_units.object_version_number%TYPE
722 );
723 --
724 -- ----------------------------------------------------------------------------
725 -- |------------------------< create_org_classification >---------------------|
726 -- ----------------------------------------------------------------------------
727 --
728 -- {Start Of Comments}
729 /*#
730 * This API creates organization classification for an existing organization.
731 *
732 * Classifications are stored in the table HR_ORGANIZATION_INFORMATION.
733 *
734 * <p><b>Licensing</b><br>
735 * This API is licensed for use with Human Resources and HR Foundation.
736 *
737 * <p><b>Prerequisites</b><br>
738 * Organization should exist.
739 *
740 * <p><b>Post Success</b><br>
741 * Classification will be added to the organization.
742 *
743 * <p><b>Post Failure</b><br>
744 * Classification is not added to the organization and error is returned.
745 * @param p_validate If true, then validation alone will be performed and the
746 * database will remain unchanged. If false and all validation checks pass,
747 * then the database will be modified.
748 * @param p_effective_date Reference date for validating lookup values are
749 * applicable during the start to end active date range. This date does not
750 * determine when the changes take effect.
751 * @param p_organization_id Uniquely identifies the organization for which the
752 * process adds a new classification.
753 * @param p_org_classif_code The organization classification code
754 * @param p_org_information_id If p_validate is false, then this uniquely
758 * version number of the organization classification created. If p_validate is
755 * identifies the classification created. If p_validate is true, then set to
756 * null.
757 * @param p_object_version_number If p_validate is false, then set to the
759 * true, then set to null..
760 * @rep:displayname Create Organization Classification
761 * @rep:category BUSINESS_ENTITY HR_ORGANIZATION
762 * @rep:category MISC_EXTENSIONS HR_DATAPUMP
763 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
764 * @rep:scope public
765 * @rep:lifecycle active
766 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
767 */
768 --
769 -- {End Of Comments}
770 --
771 PROCEDURE create_org_classification
772 ( p_validate IN BOOLEAN DEFAULT false
773 ,p_effective_date IN DATE
774 --
775 ,p_organization_id IN NUMBER
776 ,p_org_classif_code IN VARCHAR2
777 ,p_org_information_id OUT NOCOPY NUMBER
778 ,p_object_version_number OUT NOCOPY NUMBER
779 );
780 --
781 -- ----------------------------------------------------------------------------
782 -- |------------------------< enable_org_classification >---------------------|
783 -- ----------------------------------------------------------------------------
784 --
785 -- {Start Of Comments}
786 /*#
787 * This API enables a classification of an organization.
788 *
789 * Classifications are stored in the table HR_ORGANIZATION_INFORMATION.
790 *
791 * <p><b>Licensing</b><br>
792 * This API is licensed for use with Human Resources and HR Foundation.
793 *
794 * <p><b>Prerequisites</b><br>
795 * Classification of the organization should already exist.
796 *
797 * <p><b>Post Success</b><br>
798 * Classification of the organization will be enabled.
799 *
800 * <p><b>Post Failure</b><br>
801 * Classifcation is not enabled and error is returned.
802 * @param p_validate If true, then validation alone will be performed and the
803 * database will remain unchanged. If false and all validation checks pass,
804 * then the database will be modified.
805 * @param p_effective_date Reference date for validating lookup values are
806 * applicable during the start to end active date range. This date does not
807 * determine when the changes take effect.
808 * @param p_org_information_id Identifies the organization classification
809 * record to be enabled.
810 * @param p_org_info_type_code Organization information type code.
811 * @param p_object_version_number Pass in the current version number of the
812 * organization classification to be enabled. When the API completes if
813 * p_validate is false, will be set to the new version number of the enabled
814 * organization classification. If p_validate is true will be set to the same
815 * value which was passed in.
816 * @rep:displayname Enable Organization Classification
817 * @rep:category BUSINESS_ENTITY HR_ORGANIZATION
818 * @rep:scope public
819 * @rep:lifecycle active
820 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
821 */
822 --
823 -- {End Of Comments}
824 --
825 PROCEDURE enable_org_classification
826 ( p_validate IN BOOLEAN DEFAULT false
827 ,p_effective_date IN DATE
828 --
829 ,p_org_information_id IN NUMBER
830 ,p_org_info_type_code IN VARCHAR2
831 ,p_object_version_number IN OUT NOCOPY NUMBER
832 );
833 --
834 -- ----------------------------------------------------------------------------
835 -- |------------------------< disable_org_classification >--------------------|
836 -- ----------------------------------------------------------------------------
837 --
838 -- {Start Of Comments}
839 /*#
840 * This API disables the classifcation of an organization.
841 *
842 * Classifications are stored on the table HR_ORGANIZATION_INFORMATION.
843 *
844 * <p><b>Licensing</b><br>
845 * This API is licensed for use with Human Resources and HR Foundation.
846 *
847 * <p><b>Prerequisites</b><br>
848 * Classification of the organization should already exist.
849 *
850 * <p><b>Post Success</b><br>
851 * Classification of the organization will be disabled.
852 *
853 * <p><b>Post Failure</b><br>
854 * The classification of the organization will not be disbaled and error is
855 * returned.
856 * @param p_validate If true, then validation alone will be performed and the
857 * database will remain unchanged. If false and all validation checks pass,
858 * then the database will be modified.
859 * @param p_effective_date Reference date for validating lookup values are
860 * applicable during the start to end active date range. This date does not
861 * determine when the changes take effect.
862 * @param p_org_information_id Identifies the organization classification
863 * record to be disabled.
864 * @param p_org_info_type_code Organization information type code.
865 * @param p_object_version_number Pass in the current version number of the
866 * oragnization classification to be updated. When the API completes if
867 * p_validate is false, will be set to the new version number of the updated
868 * organization classification If p_validate is true will be set to the same
869 * value which was passed in.
870 * @rep:displayname Disable Organization Classification
871 * @rep:category BUSINESS_ENTITY HR_ORGANIZATION
872 * @rep:scope public
873 * @rep:lifecycle active
874 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
875 */
876 --
877 -- {End Of Comments}
878 --
879
880 PROCEDURE disable_org_classification
881 ( p_validate IN BOOLEAN DEFAULT false
882 ,p_effective_date IN DATE
883 --
887 );
884 ,p_org_information_id IN NUMBER
885 ,p_org_info_type_code IN VARCHAR2
886 ,p_object_version_number IN OUT NOCOPY NUMBER
888 --
889 -- ----------------------------------------------------------------------------
890 -- |--------------------------< create_org_information >----------------------|
891 -- ----------------------------------------------------------------------------
892 --
893 -- {Start Of Comments}
894 /*#
895 * This API creates organization information.
896 *
897 * Information types are stored in the table HR_ORGANIZATION_INFORMATION.
898 *
899 * <p><b>Licensing</b><br>
900 * This API is licensed for use with Human Resources and HR Foundation.
901 *
902 * <p><b>Prerequisites</b><br>
903 * A valid organization must exist.
904 *
905 * <p><b>Post Success</b><br>
906 * When the information type has been successfully inserted, the process
907 * creates an organization information record.
908 *
909 * <p><b>Post Failure</b><br>
910 * The API does not create the information type, and raises an error
911 * @param p_validate If true, then validation alone will be performed and the
912 * database will remain unchanged. If false and all validation checks pass,
913 * then the database will be modified.
914 * @param p_effective_date Reference date for validating lookup values are
915 * applicable during the start to end active date range. This date does not
916 * determine when the changes take effect.
917 * @param p_organization_id Uniquely identifies the organization for which the
918 * process creates organization information.
919 * @param p_org_info_type_code The Information Type Code.
920 * @param p_org_information1 Segment1 for p_org_info_type_code.
921 * @param p_org_information2 Segment2 for p_org_info_type_code.
922 * @param p_org_information3 Segment3 for p_org_info_type_code.
923 * @param p_org_information4 Segment4 for p_org_info_type_code.
924 * @param p_org_information5 Segment5 for p_org_info_type_code.
925 * @param p_org_information6 Segment6 for p_org_info_type_code.
926 * @param p_org_information7 Segment7 for p_org_info_type_code.
927 * @param p_org_information8 Segment8 for p_org_info_type_code.
928 * @param p_org_information9 Segment9 for p_org_info_type_code.
929 * @param p_org_information10 Segment10 for p_org_info_type_code.
930 * @param p_org_information11 Segment11 for p_org_info_type_code.
931 * @param p_org_information12 Segment12 for p_org_info_type_code.
932 * @param p_org_information13 Segment13 for p_org_info_type_code.
933 * @param p_org_information14 Segment14 for p_org_info_type_code.
934 * @param p_org_information15 Segment15 for p_org_info_type_code.
935 * @param p_org_information16 Segment16 for p_org_info_type_code.
936 * @param p_org_information17 Segment17 for p_org_info_type_code.
937 * @param p_org_information18 Segment18 for p_org_info_type_code.
938 * @param p_org_information19 Segment19 for p_org_info_type_code.
939 * @param p_org_information20 Segment20 for p_org_info_type_code.
940 * @param p_attribute_category This context value determines which flexfield
941 * structure to use with the descriptive flexfield segments.
942 * @param p_attribute1 Descriptive flexfield segment.
943 * @param p_attribute2 Descriptive flexfield segment.
944 * @param p_attribute3 Descriptive flexfield segment.
945 * @param p_attribute4 Descriptive flexfield segment.
946 * @param p_attribute5 Descriptive flexfield segment.
947 * @param p_attribute6 Descriptive flexfield segment.
948 * @param p_attribute7 Descriptive flexfield segment.
949 * @param p_attribute8 Descriptive flexfield segment.
950 * @param p_attribute9 Descriptive flexfield segment.
951 * @param p_attribute10 Descriptive flexfield segment.
952 * @param p_attribute11 Descriptive flexfield segment.
953 * @param p_attribute12 Descriptive flexfield segment.
954 * @param p_attribute13 Descriptive flexfield segment.
955 * @param p_attribute14 Descriptive flexfield segment.
956 * @param p_attribute15 Descriptive flexfield segment.
957 * @param p_attribute16 Descriptive flexfield segment.
958 * @param p_attribute17 Descriptive flexfield segment.
959 * @param p_attribute18 Descriptive flexfield segment.
960 * @param p_attribute19 Descriptive flexfield segment.
961 * @param p_attribute20 Descriptive flexfield segment.
962 * @param p_org_information_id If p_validate is false, then this uniquely
963 * identifies the information type created. If p_validate is true, then set to
964 * null.
965 * @param p_object_version_number If p_validate is false, then set to the
966 * version number of the created organization information. If p_validate is
967 * true, then the value will be null.
968 * @rep:displayname Create Organization Information
969 * @rep:category BUSINESS_ENTITY HR_ORGANIZATION
970 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
971 * @rep:scope public
972 * @rep:lifecycle active
973 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
974 */
975 --
976 -- {End Of Comments}
977 --
978 PROCEDURE create_org_information
979 ( p_validate IN BOOLEAN DEFAULT false
980 ,p_effective_date IN DATE
981 --
982 ,p_organization_id IN NUMBER
983 ,p_org_info_type_code IN VARCHAR2
984 ,p_org_information1 IN VARCHAR2 DEFAULT null
985 ,p_org_information2 IN VARCHAR2 DEFAULT null
986 ,p_org_information3 IN VARCHAR2 DEFAULT null
987 ,p_org_information4 IN VARCHAR2 DEFAULT null
988 ,p_org_information5 IN VARCHAR2 DEFAULT null
989 ,p_org_information6 IN VARCHAR2 DEFAULT null
990 ,p_org_information7 IN VARCHAR2 DEFAULT null
991 ,p_org_information8 IN VARCHAR2 DEFAULT null
992 ,p_org_information9 IN VARCHAR2 DEFAULT null
993 ,p_org_information10 IN VARCHAR2 DEFAULT null
997 ,p_org_information14 IN VARCHAR2 DEFAULT null
994 ,p_org_information11 IN VARCHAR2 DEFAULT null
995 ,p_org_information12 IN VARCHAR2 DEFAULT null
996 ,p_org_information13 IN VARCHAR2 DEFAULT null
998 ,p_org_information15 IN VARCHAR2 DEFAULT null
999 ,p_org_information16 IN VARCHAR2 DEFAULT null
1000 ,p_org_information17 IN VARCHAR2 DEFAULT null
1001 ,p_org_information18 IN VARCHAR2 DEFAULT null
1002 ,p_org_information19 IN VARCHAR2 DEFAULT null
1003 ,p_org_information20 IN VARCHAR2 DEFAULT null
1004 ,p_attribute_category IN VARCHAR2 DEFAULT null
1005 ,p_attribute1 IN VARCHAR2 DEFAULT null
1006 ,p_attribute2 IN VARCHAR2 DEFAULT null
1007 ,p_attribute3 IN VARCHAR2 DEFAULT null
1008 ,p_attribute4 IN VARCHAR2 DEFAULT null
1009 ,p_attribute5 IN VARCHAR2 DEFAULT null
1010 ,p_attribute6 IN VARCHAR2 DEFAULT null
1011 ,p_attribute7 IN VARCHAR2 DEFAULT null
1012 ,p_attribute8 IN VARCHAR2 DEFAULT null
1013 ,p_attribute9 IN VARCHAR2 DEFAULT null
1014 ,p_attribute10 IN VARCHAR2 DEFAULT null
1015 ,p_attribute11 IN VARCHAR2 DEFAULT null
1016 ,p_attribute12 IN VARCHAR2 DEFAULT null
1017 ,p_attribute13 IN VARCHAR2 DEFAULT null
1018 ,p_attribute14 IN VARCHAR2 DEFAULT null
1019 ,p_attribute15 IN VARCHAR2 DEFAULT null
1020 ,p_attribute16 IN VARCHAR2 DEFAULT null
1021 ,p_attribute17 IN VARCHAR2 DEFAULT null
1022 ,p_attribute18 IN VARCHAR2 DEFAULT null
1023 ,p_attribute19 IN VARCHAR2 DEFAULT null
1024 ,p_attribute20 IN VARCHAR2 DEFAULT null
1025 ,p_org_information_id OUT NOCOPY NUMBER
1026 ,p_object_version_number OUT NOCOPY NUMBER
1027 );
1028 --
1029 -- ----------------------------------------------------------------------------
1030 -- |----------------------------< create_org_manager >------------------------|
1031 -- ----------------------------------------------------------------------------
1032 --
1033 -- {Start Of Comments}
1034 /*#
1035 * This API creates cost center manager information.
1036 *
1037 * This API creates a new cost center manager information type for an existing
1038 * organization. Information types are stored in the table
1039 * HR_ORGANIZATION_INFORMATION.
1040 *
1041 * <p><b>Licensing</b><br>
1042 * This API is licensed for use with Human Resources and HR Foundation.
1043 *
1044 * <p><b>Prerequisites</b><br>
1045 * Organization should exist.
1046 *
1047 * <p><b>Post Success</b><br>
1048 * Organization manager relationship gets created.
1049 *
1050 * <p><b>Post Failure</b><br>
1051 * The API does not create the organization manager relationship, and raises an
1052 * error
1053 * @param p_validate If true, then validation alone will be performed and the
1054 * database will remain unchanged. If false and all validation checks pass,
1055 * then the database will be modified.
1056 * @param p_effective_date Reference date for validating lookup values are
1057 * applicable during the start to end active date range. This date does not
1058 * determine when the changes take effect.
1059 * @param p_organization_id Uniquely identifies the organization associated
1060 * with the organization manager relationship the process creates.
1061 * @param p_org_info_type_code The organization information type code -
1062 * 'Organization Name Alias'
1063 * @param p_org_information1 Segment1 for p_org_info_type_code.
1064 * @param p_org_information2 Uniquely identifies the person associated with the
1065 * cost center manager information.
1066 * @param p_org_information3 The date the organization manager relationship
1067 * takes effect.
1068 * @param p_org_information4 The date the organization manager relationship is
1069 * no longer in effect.
1070 * @param p_org_information5 Segment5 for p_org_info_type_code.
1071 * @param p_org_information6 Segment6 for p_org_info_type_code.
1072 * @param p_org_information7 Segment7 for p_org_info_type_code.
1073 * @param p_org_information8 Segment8 for p_org_info_type_code.
1074 * @param p_org_information9 Segment9 for p_org_info_type_code.
1075 * @param p_org_information10 Segment10 for p_org_info_type_code.
1076 * @param p_org_information11 Segment11 for p_org_info_type_code.
1077 * @param p_org_information12 Segment12 for p_org_info_type_code.
1078 * @param p_org_information13 Segment13 for p_org_info_type_code.
1079 * @param p_org_information14 Segment14 for p_org_info_type_code.
1080 * @param p_org_information15 Segment15 for p_org_info_type_code.
1081 * @param p_org_information16 Segment16 for p_org_info_type_code.
1082 * @param p_org_information17 Segment17 for p_org_info_type_code.
1083 * @param p_org_information18 Segment18 for p_org_info_type_code.
1084 * @param p_org_information19 Segment19 for p_org_info_type_code.
1085 * @param p_org_information20 Segment20 for p_org_info_type_code.
1086 * @param p_attribute_category This context value determines which flexfield
1087 * structure to use with the descriptive flexfield segments.
1088 * @param p_attribute1 Descriptive flexfield segment.
1089 * @param p_attribute2 Descriptive flexfield segment.
1090 * @param p_attribute3 Descriptive flexfield segment.
1091 * @param p_attribute4 Descriptive flexfield segment.
1092 * @param p_attribute5 Descriptive flexfield segment.
1093 * @param p_attribute6 Descriptive flexfield segment.
1094 * @param p_attribute7 Descriptive flexfield segment.
1095 * @param p_attribute8 Descriptive flexfield segment.
1096 * @param p_attribute9 Descriptive flexfield segment.
1100 * @param p_attribute13 Descriptive flexfield segment.
1097 * @param p_attribute10 Descriptive flexfield segment.
1098 * @param p_attribute11 Descriptive flexfield segment.
1099 * @param p_attribute12 Descriptive flexfield segment.
1101 * @param p_attribute14 Descriptive flexfield segment.
1102 * @param p_attribute15 Descriptive flexfield segment.
1103 * @param p_attribute16 Descriptive flexfield segment.
1104 * @param p_attribute17 Descriptive flexfield segment.
1105 * @param p_attribute18 Descriptive flexfield segment.
1106 * @param p_attribute19 Descriptive flexfield segment.
1107 * @param p_attribute20 Descriptive flexfield segment.
1108 * @param p_org_information_id If p_validate is false, then this uniquely
1109 * identifies the information type created. If p_validate is true, then set to
1110 * null.
1111 * @param p_object_version_number If p_validate is false, then it is set to
1112 * the version number of the created organization manager relationship. If
1113 * p_validate is true, then the value will be null.
1114 * @param p_warning Set if there is a overlap in the organization manager
1115 * relationship..
1116 * @rep:displayname Create Cost Center Manager
1117 * @rep:category BUSINESS_ENTITY HR_COST_CENTER
1118 * @rep:scope public
1119 * @rep:lifecycle active
1120 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
1121 */
1122 --
1123 -- {End Of Comments}
1124 --
1125 PROCEDURE create_org_manager
1126 ( p_validate IN BOOLEAN DEFAULT false
1127 ,p_effective_date IN DATE
1128 ,p_organization_id IN NUMBER
1129 ,p_org_info_type_code IN VARCHAR2
1130 ,p_org_information1 IN VARCHAR2 DEFAULT null
1131 ,p_org_information2 IN VARCHAR2 DEFAULT null
1132 ,p_org_information3 IN VARCHAR2 DEFAULT null
1133 ,p_org_information4 IN VARCHAR2 DEFAULT null
1134 ,p_org_information5 IN VARCHAR2 DEFAULT null
1135 ,p_org_information6 IN VARCHAR2 DEFAULT null
1136 ,p_org_information7 IN VARCHAR2 DEFAULT null
1137 ,p_org_information8 IN VARCHAR2 DEFAULT null
1138 ,p_org_information9 IN VARCHAR2 DEFAULT null
1139 ,p_org_information10 IN VARCHAR2 DEFAULT null
1140 ,p_org_information11 IN VARCHAR2 DEFAULT null
1141 ,p_org_information12 IN VARCHAR2 DEFAULT null
1142 ,p_org_information13 IN VARCHAR2 DEFAULT null
1143 ,p_org_information14 IN VARCHAR2 DEFAULT null
1144 ,p_org_information15 IN VARCHAR2 DEFAULT null
1145 ,p_org_information16 IN VARCHAR2 DEFAULT null
1146 ,p_org_information17 IN VARCHAR2 DEFAULT null
1147 ,p_org_information18 IN VARCHAR2 DEFAULT null
1148 ,p_org_information19 IN VARCHAR2 DEFAULT null
1149 ,p_org_information20 IN VARCHAR2 DEFAULT null
1150 ,p_attribute_category IN VARCHAR2 DEFAULT null
1151 ,p_attribute1 IN VARCHAR2 DEFAULT null
1152 ,p_attribute2 IN VARCHAR2 DEFAULT null
1153 ,p_attribute3 IN VARCHAR2 DEFAULT null
1154 ,p_attribute4 IN VARCHAR2 DEFAULT null
1155 ,p_attribute5 IN VARCHAR2 DEFAULT null
1156 ,p_attribute6 IN VARCHAR2 DEFAULT null
1157 ,p_attribute7 IN VARCHAR2 DEFAULT null
1158 ,p_attribute8 IN VARCHAR2 DEFAULT null
1159 ,p_attribute9 IN VARCHAR2 DEFAULT null
1160 ,p_attribute10 IN VARCHAR2 DEFAULT null
1161 ,p_attribute11 IN VARCHAR2 DEFAULT null
1162 ,p_attribute12 IN VARCHAR2 DEFAULT null
1163 ,p_attribute13 IN VARCHAR2 DEFAULT null
1164 ,p_attribute14 IN VARCHAR2 DEFAULT null
1165 ,p_attribute15 IN VARCHAR2 DEFAULT null
1166 ,p_attribute16 IN VARCHAR2 DEFAULT null
1167 ,p_attribute17 IN VARCHAR2 DEFAULT null
1168 ,p_attribute18 IN VARCHAR2 DEFAULT null
1169 ,p_attribute19 IN VARCHAR2 DEFAULT null
1170 ,p_attribute20 IN VARCHAR2 DEFAULT null
1171 ,p_org_information_id OUT NOCOPY NUMBER
1172 ,p_object_version_number OUT NOCOPY NUMBER
1173 ,p_warning OUT NOCOPY BOOLEAN);
1174 --
1175 -- ----------------------------------------------------------------------------
1176 -- |--------------------------< update_org_information >----------------------|
1177 -- ----------------------------------------------------------------------------
1178 --
1179 -- {Start Of Comments}
1180 /*#
1181 * This API updates an information type of an Organization.
1182 *
1183 * Information types are stored in the table HR_ORGANIZATION_INFORMATION.
1184 *
1185 * <p><b>Licensing</b><br>
1186 * This API is licensed for use with Human Resources and HR Foundation.
1187 *
1188 * <p><b>Prerequisites</b><br>
1189 * Organization should exist.
1190 *
1191 * <p><b>Post Success</b><br>
1192 * Organization information gets created.
1193 *
1194 * <p><b>Post Failure</b><br>
1195 * The API does not create the information type, and raises an error
1196 * @param p_validate If true, then validation alone will be performed and the
1197 * database will remain unchanged. If false and all validation checks pass,
1198 * then the database will be modified.
1199 * @param p_effective_date Reference date for validating lookup values are
1200 * applicable during the start to end active date range. This date does not
1201 * determine when the changes take effect.
1202 * @param p_org_information_id Uniquely identifies the organization information
1203 * record to modify.
1207 * @param p_org_information3 Segment3 for p_org_info_type_code.
1204 * @param p_org_info_type_code The organization information type code.
1205 * @param p_org_information1 Segment1 for p_org_info_type_code.
1206 * @param p_org_information2 Segment2 for p_org_info_type_code.
1208 * @param p_org_information4 Segment4 for p_org_info_type_code.
1209 * @param p_org_information5 Segment5 for p_org_info_type_code.
1210 * @param p_org_information6 Segment6 for p_org_info_type_code.
1211 * @param p_org_information7 Segment7 for p_org_info_type_code.
1212 * @param p_org_information8 Segment8 for p_org_info_type_code.
1213 * @param p_org_information9 Segment9 for p_org_info_type_code.
1214 * @param p_org_information10 Segment10 for p_org_info_type_code.
1215 * @param p_org_information11 Segment11 for p_org_info_type_code.
1216 * @param p_org_information12 Segment12 for p_org_info_type_code.
1217 * @param p_org_information13 Segment13 for p_org_info_type_code.
1218 * @param p_org_information14 Segment14 for p_org_info_type_code.
1219 * @param p_org_information15 Segment15 for p_org_info_type_code.
1220 * @param p_org_information16 Segment16 for p_org_info_type_code.
1221 * @param p_org_information17 Segment17 for p_org_info_type_code.
1222 * @param p_org_information18 Segment18 for p_org_info_type_code.
1223 * @param p_org_information19 Segment19 for p_org_info_type_code.
1224 * @param p_org_information20 Segment20 for p_org_info_type_code.
1225 * @param p_attribute_category This context value determines which flexfield
1226 * structure to use with the descriptive flexfield segments.
1227 * @param p_attribute1 Descriptive flexfield segment.
1228 * @param p_attribute2 Descriptive flexfield segment.
1229 * @param p_attribute3 Descriptive flexfield segment.
1230 * @param p_attribute4 Descriptive flexfield segment.
1231 * @param p_attribute5 Descriptive flexfield segment.
1232 * @param p_attribute6 Descriptive flexfield segment.
1233 * @param p_attribute7 Descriptive flexfield segment.
1234 * @param p_attribute8 Descriptive flexfield segment.
1235 * @param p_attribute9 Descriptive flexfield segment.
1236 * @param p_attribute10 Descriptive flexfield segment.
1237 * @param p_attribute11 Descriptive flexfield segment.
1238 * @param p_attribute12 Descriptive flexfield segment.
1239 * @param p_attribute13 Descriptive flexfield segment.
1240 * @param p_attribute14 Descriptive flexfield segment.
1241 * @param p_attribute15 Descriptive flexfield segment.
1242 * @param p_attribute16 Descriptive flexfield segment.
1243 * @param p_attribute17 Descriptive flexfield segment.
1244 * @param p_attribute18 Descriptive flexfield segment.
1245 * @param p_attribute19 Descriptive flexfield segment.
1246 * @param p_attribute20 Descriptive flexfield segment.
1247 * @param p_object_version_number Pass in the current version number of the
1248 * organization information record to be updated. When the API completes if
1249 * p_validate is false, will be set to the new version number of the updated
1250 * organization information record. If p_validate is true will be set to the
1251 * same value which was passed in.
1252 * @rep:displayname Update Organization Information
1253 * @rep:category BUSINESS_ENTITY HR_ORGANIZATION
1254 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
1255 * @rep:scope public
1256 * @rep:lifecycle active
1257 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
1258 */
1259 --
1260 -- {End Of Comments}
1261 --
1262 PROCEDURE update_org_information
1263 (p_validate IN BOOLEAN DEFAULT false
1264 ,p_effective_date IN DATE
1265 ,p_org_information_id IN NUMBER
1266 ,p_org_info_type_code IN VARCHAR2
1267 ,p_org_information1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1268 ,p_org_information2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1269 ,p_org_information3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1270 ,p_org_information4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1271 ,p_org_information5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1272 ,p_org_information6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1273 ,p_org_information7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1274 ,p_org_information8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1275 ,p_org_information9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1276 ,p_org_information10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1277 ,p_org_information11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1278 ,p_org_information12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1279 ,p_org_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1280 ,p_org_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1281 ,p_org_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1282 ,p_org_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1283 ,p_org_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1284 ,p_org_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1285 ,p_org_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1286 ,p_org_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1287 ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
1288 ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1289 ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1290 ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1291 ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1292 ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1293 ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1294 ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1295 ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1296 ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1297 ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1298 ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1302 ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1299 ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1300 ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1301 ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1303 ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1304 ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1305 ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1306 ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1307 ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1308 ,p_object_version_number IN OUT NOCOPY NUMBER
1309 );
1310 --
1311 -- ----------------------------------------------------------------------------
1312 -- |----------------------------< update_org_manager >------------------------|
1313 -- ----------------------------------------------------------------------------
1314 --
1315 -- {Start Of Comments}
1316 /*#
1317 * This API updates an organization manager relationship.
1318 *
1319 * This API updates an information type for a Cost Center Manager Relationship
1320 * of an existing organization. Information types are stored in the table
1321 * HR_ORGANIZATION_INFORMATION.
1322 *
1323 * <p><b>Licensing</b><br>
1324 * This API is licensed for use with Human Resources and HR Foundation.
1325 *
1326 * <p><b>Prerequisites</b><br>
1327 * Organization should exist.
1328 *
1329 * <p><b>Post Success</b><br>
1330 * Organization manager relationship gets updated.
1331 *
1332 * <p><b>Post Failure</b><br>
1333 * The API does not update the organization manager relationship, and raises an
1334 * error
1335 * @param p_validate If true, then validation alone will be performed and the
1336 * database will remain unchanged. If false and all validation checks pass,
1337 * then the database will be modified.
1338 * @param p_effective_date Reference date for validating lookup values are
1339 * applicable during the start to end active date range. This date does not
1340 * determine when the changes take effect.
1341 * @param p_organization_id Uniquely identifies the organization associated
1342 * with the organization manager relationship the process updates.
1343 * @param p_org_information_id Uniquely identifies the organization
1344 * information.
1345 * @param p_org_info_type_code The organization information type code -
1346 * 'Organization Name Alias
1347 * @param p_org_information1 Segment1 for p_org_info_type_code.
1348 * @param p_org_information2 Uniquely identifies the person (manager) for whom
1349 * the process updates cost center manager information.
1350 * @param p_org_information3 The date the organization manager relationship
1351 * takes effect.
1352 * @param p_org_information4 The date the organization manager relationship is
1353 * no longer in effect.
1354 * @param p_org_information5 Segment5 for p_org_info_type_code.
1355 * @param p_org_information6 Segment6 for p_org_info_type_code.
1356 * @param p_org_information7 Segment7 for p_org_info_type_code.
1357 * @param p_org_information8 Segment8 for p_org_info_type_code.
1358 * @param p_org_information9 Segment9 for p_org_info_type_code.
1359 * @param p_org_information10 Segment10 for p_org_info_type_code.
1360 * @param p_org_information11 Segment11 for p_org_info_type_code.
1361 * @param p_org_information12 Segment12 for p_org_info_type_code.
1362 * @param p_org_information13 Segment13 for p_org_info_type_code.
1363 * @param p_org_information14 Segment14 for p_org_info_type_code.
1364 * @param p_org_information15 Segment15 for p_org_info_type_code.
1365 * @param p_org_information16 Segment16 for p_org_info_type_code.
1366 * @param p_org_information17 Segment17 for p_org_info_type_code.
1367 * @param p_org_information18 Segment18 for p_org_info_type_code.
1368 * @param p_org_information19 Segment19 for p_org_info_type_code.
1369 * @param p_org_information20 Segment20 for p_org_info_type_code.
1370 * @param p_attribute_category This context value determines which flexfield
1371 * structure to use with the descriptive flexfield segments.
1372 * @param p_attribute1 Descriptive flexfield segment.
1373 * @param p_attribute2 Descriptive flexfield segment.
1374 * @param p_attribute3 Descriptive flexfield segment.
1375 * @param p_attribute4 Descriptive flexfield segment.
1376 * @param p_attribute5 Descriptive flexfield segment.
1377 * @param p_attribute6 Descriptive flexfield segment.
1378 * @param p_attribute7 Descriptive flexfield segment.
1379 * @param p_attribute8 Descriptive flexfield segment.
1380 * @param p_attribute9 Descriptive flexfield segment.
1381 * @param p_attribute10 Descriptive flexfield segment.
1382 * @param p_attribute11 Descriptive flexfield segment.
1383 * @param p_attribute12 Descriptive flexfield segment.
1384 * @param p_attribute13 Descriptive flexfield segment.
1385 * @param p_attribute14 Descriptive flexfield segment.
1386 * @param p_attribute15 Descriptive flexfield segment.
1387 * @param p_attribute16 Descriptive flexfield segment.
1388 * @param p_attribute17 Descriptive flexfield segment.
1389 * @param p_attribute18 Descriptive flexfield segment.
1390 * @param p_attribute19 Descriptive flexfield segment.
1391 * @param p_attribute20 Descriptive flexfield segment.
1392 * @param p_object_version_number Pass in the current version number of the
1393 * organization manager relationship record to be updated. When the API
1394 * completes if p_validate is false, will be set to the new version number of
1395 * the updated organization manager relationship. If p_validate is true will be
1396 * set to the same value which was passed in.
1397 * @param p_warning Set to true if a gap exists in the continuity of effective
1398 * dates for associated Cost Center Manager Relationships.
1399 * @rep:displayname Update Cost Center Manager
1400 * @rep:category BUSINESS_ENTITY HR_COST_CENTER
1401 * @rep:scope public
1402 * @rep:lifecycle active
1403 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
1404 */
1408 PROCEDURE update_org_manager
1405 --
1406 -- {End Of Comments}
1407 --
1409 ( p_validate IN BOOLEAN DEFAULT false
1410 ,p_effective_date IN DATE
1411 ,p_organization_id IN NUMBER
1412 ,p_org_information_id IN NUMBER
1413 ,p_org_info_type_code IN VARCHAR2
1414 ,p_org_information1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1415 ,p_org_information2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1416 ,p_org_information3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1417 ,p_org_information4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1418 ,p_org_information5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1419 ,p_org_information6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1420 ,p_org_information7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1421 ,p_org_information8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1422 ,p_org_information9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1423 ,p_org_information10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1424 ,p_org_information11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1425 ,p_org_information12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1426 ,p_org_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1427 ,p_org_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1428 ,p_org_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1429 ,p_org_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1430 ,p_org_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1431 ,p_org_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1432 ,p_org_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1433 ,p_org_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1434 ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
1435 ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1436 ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1437 ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1438 ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1439 ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1440 ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1441 ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1442 ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1443 ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1444 ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1445 ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1446 ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1447 ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1448 ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1449 ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1450 ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1451 ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1452 ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1453 ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1454 ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1455 ,p_object_version_number IN OUT NOCOPY NUMBER
1456 ,p_warning OUT NOCOPY BOOLEAN);
1457 --
1458 -- ----------------------------------------------------------------------------
1459 -- |----------------------------< delete_org_manager >------------------------|
1460 -- ----------------------------------------------------------------------------
1461 --
1462 -- {Start Of Comments}
1463 /*#
1464 * This API deletes an organization manager relationship.
1465 *
1466 * This API deletes an information type for a Cost Center Manager Relationship
1467 * of an existing organization. Information types are stored in the table
1468 * HR_ORGANIZATION_INFORMATION.
1469 *
1470 * <p><b>Licensing</b><br>
1471 * This API is licensed for use with Human Resources and HR Foundation.
1472 *
1473 * <p><b>Prerequisites</b><br>
1474 * Organization manager relationship should exist.
1475 *
1476 * <p><b>Post Success</b><br>
1477 * Organization manager relationship is successfully deleted.
1478 *
1479 * <p><b>Post Failure</b><br>
1480 * The API does not delete the organization manager relationship, and raises an
1481 * error
1482 * @param p_validate If true, then validation alone will be performed and the
1483 * database will remain unchanged. If false and all validation checks pass,
1484 * then the database will be modified.
1485 * @param p_org_information_id Identifies the organization manager relationship
1486 * record to delete.
1487 * @param p_object_version_number Current version number of the organization
1488 * manager relationship to be deleted.
1489 * @rep:displayname Delete Cost Center Manager
1490 * @rep:category BUSINESS_ENTITY HR_COST_CENTER
1491 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
1492 * @rep:scope public
1493 * @rep:lifecycle active
1494 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
1495 */
1496 --
1497 -- {End Of Comments}
1498 --
1499 PROCEDURE delete_org_manager
1500 ( p_validate IN BOOLEAN DEFAULT false
1501 ,p_org_information_id IN NUMBER
1502 ,p_object_version_number IN OUT NOCOPY NUMBER);
1503 --
1504 -- ----------------------------------------------------------------------------
1505 -- |--------------------------< create_business_group >-----------------------|
1509 /*#
1506 -- ----------------------------------------------------------------------------
1507 --
1508 -- {Start Of Comments}
1510 * This API creates a business group.
1511 *
1512 * This API creates a new business group. This API is MLS enabled, and there is
1513 * one translated column (NAME). Organizations are stored in the table
1514 * HR_ALL_ORGANIZATION_UNITS. The translated columns are stored in the table
1515 * HR_ALL_ORGANIZATION_UNITS_TL.
1516 *
1517 * <p><b>Licensing</b><br>
1518 * This API is licensed for use with Human Resources and HR Foundation.
1519 *
1520 * <p><b>Prerequisites</b><br>
1521 * None
1522 *
1523 * <p><b>Post Success</b><br>
1524 * Organization with the classification of Business Group is created.
1525 *
1526 * <p><b>Post Failure</b><br>
1527 * The API does not create the organization, and raises an error
1528 * @param p_validate If true, then validation alone will be performed and the
1529 * database will remain unchanged. If false and all validation checks pass,
1530 * then the database will be modified.
1531 * @param p_effective_date Reference date for validating lookup values are
1532 * applicable during the start to end active date range. This date does not
1533 * determine when the changes take effect.
1534 * @param p_language_code Specifies to which language the translation values
1535 * apply. You can set to the base or any installed language. The default value
1536 * of hr_api.userenv_lang is equivalent to the RDBMS userenv('LANG') function
1537 * value.
1538 * @param p_date_from Date the organization takes effect.
1539 * @param p_name The business group name (translated).
1540 * @param p_type The organization type associated with the organization the
1541 * process creates. Valid values are determined by the ORG_TYPE lookup type.
1542 * @param p_internal_external_flag Flag specifying if the organization is an
1543 * internal or external organization.
1544 * @param p_location_id Uniquely identifies the location of the organization.
1545 * @param p_short_name The business group short name
1546 * @param p_emp_gen_method Employee number generation method. Valid values are
1547 * 'A' (Automatic) and 'M' (Manual).
1548 * @param p_app_gen_method Applicant number generation method. Valid values are
1549 * 'A' (Automatic) and 'M' (Manual).
1550 * @param p_cwk_gen_method Contingent Worker number generation method. Valid
1551 * values are 'A' (Automatic), 'M' (Manual), and 'E' (same as employee number).
1552 * @param p_grade_flex_id Uniquely identifies the Grade key flexfield.
1553 * @param p_group_flex_id Uniquely identifies the People Group key flexfield.
1554 * @param p_job_flex_id Uniquely identifies the Job key flexfield.
1555 * @param p_cost_flex_id Uniquely identifies the Cost Allocation key flexfield.
1556 * @param p_position_flex_id Uniquely identifies the Position key flexfield.
1557 * @param p_legislation_code The Legislation Code
1558 * @param p_currency_code The Currency Code
1559 * @param p_fiscal_year_start Start of Fiscal year
1560 * @param p_min_work_age Minimum Work Age
1561 * @param p_max_work_age Maximum Working Age
1562 * @param p_sec_group_id Security group ID
1563 * @param p_competence_flex_id Uniquely identifies the Competence key
1564 * flexfield.
1565 * @param p_organization_id If p_validate is false, then this uniquely
1566 * identifies the business group created. If p_validate is true, then set to
1567 * null..
1568 * @param p_object_version_number If p_validate is false, then set to the
1569 * version number of the created business group. If p_validate is true, then
1570 * the value will be null.
1571 * @rep:displayname Create Business Group
1572 * @rep:category BUSINESS_ENTITY HR_BUSINESS_GROUP
1573 * @rep:category MISC_EXTENSIONS HR_DATAPUMP
1574 * @rep:scope public
1575 * @rep:lifecycle active
1576 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
1577 */
1578 --
1579 -- {End Of Comments}
1580 --
1581 PROCEDURE create_business_group
1582 ( p_validate IN BOOLEAN DEFAULT false
1583 ,p_effective_date IN DATE
1584 ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
1585 --
1586 ,p_date_from IN DATE
1587 ,p_name IN VARCHAR2
1588 ,p_type IN VARCHAR2
1589 ,p_internal_external_flag IN VARCHAR2
1590 ,p_location_id IN NUMBER
1591 ,p_short_name IN VARCHAR2
1592 ,p_emp_gen_method IN VARCHAR2
1593 ,p_app_gen_method IN VARCHAR2
1594 ,p_cwk_gen_method IN VARCHAR2
1595 ,p_grade_flex_id IN VARCHAR2
1596 ,p_group_flex_id IN VARCHAR2
1597 ,p_job_flex_id IN VARCHAR2
1598 ,p_cost_flex_id IN VARCHAR2
1599 ,p_position_flex_id IN VARCHAR2
1600 ,p_legislation_code IN VARCHAR2
1601 ,p_currency_code IN VARCHAR2
1602 ,p_fiscal_year_start IN VARCHAR2
1603 ,p_min_work_age IN VARCHAR2
1604 ,p_max_work_age IN VARCHAR2
1605 ,p_sec_group_id IN VARCHAR2
1606 ,p_competence_flex_id IN VARCHAR2
1607 ,p_organization_id OUT NOCOPY NUMBER
1608 ,p_object_version_number OUT NOCOPY NUMBER
1609 );
1610 --
1611 -- ----------------------------------------------------------------------------
1612 -- |--------------------------< create_operating_unit >-----------------------|
1613 -- ----------------------------------------------------------------------------
1614 --
1615 -- {Start Of Comments}
1616 /*#
1617 * This API creates a new Operating Unit within an existing Business group.
1618 *
1619 * The API is MLS enabled, and there is one translated column (NAME).
1623 * <p><b>Licensing</b><br>
1620 * Organizations are stored in the table HR_ALL_ORGANIZATION_UNITS. The
1621 * translated columns are stored in the table HR_ALL_ORGANIZATION_UNITS_TL.
1622 *
1624 * This API is licensed for use with Human Resources and HR Foundation.
1625 *
1626 * <p><b>Prerequisites</b><br>
1627 * Business group should exist.
1628 *
1629 * <p><b>Post Success</b><br>
1630 * Operating unit gets successfully created.
1631 *
1632 * <p><b>Post Failure</b><br>
1633 * Operating unit is not created and returns an error.
1634 * @param p_validate If true, then validation alone will be performed and the
1635 * database will remain unchanged. If false and all validation checks pass,
1636 * then the database will be modified.
1637 * @param p_effective_date Reference date for validating lookup values are
1638 * applicable during the start to end active date range. This date does not
1639 * determine when the changes take effect.
1640 * @param p_language_code Specifies to which language the translation values
1641 * apply. You can set to the base or any installed language. The default value
1642 * of hr_api.userenv_lang is equivalent to the RDBMS userenv('LANG') function
1643 * value.
1644 * @param p_business_group_id Uniquely identifies the business group associated
1645 * with the operating unit the process creates.
1646 * @param p_date_from Date the operating unit takes effect.
1647 * @param p_name The name of the operating unit.
1648 * @param p_type The organization type associated with the operating unit the
1649 * process creates. Valid values are determined by the ORG_TYPE lookup type.
1650 * @param p_internal_external_flag Flag specifying if the organization is an
1651 * internal or external organization.
1652 * @param p_location_id Uniquely identifies the location of the operating unit
1653 * the process creates.
1654 * @param p_set_of_books_id Uniquely identifies the ledger associated
1655 * with the operating unit the process creates.
1656 * @param p_organization_id If p_validate is false, then this uniquely
1657 * identifies the operating unit created. If p_validate is true, then set to
1658 * null..
1659 * @param p_object_version_number If p_validate is false, then set to the
1660 * version number of the operating unit created. If p_validate is true, then
1661 * set to null..
1662 * @param p_legal_entity_id Uniquely identifies the legal entity associated
1663 * with the operating unit.
1664 * @param p_short_code Operating unit short code.
1665 * @rep:displayname Create Operating Unit
1666 * @rep:category BUSINESS_ENTITY HR_OPERATING_UNIT
1667 * @rep:scope public
1668 * @rep:lifecycle active
1669 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
1670 */
1671 --
1672 -- {End Of Comments}
1673 --
1674
1675 PROCEDURE create_operating_unit
1676 ( p_validate IN BOOLEAN DEFAULT false
1677 ,p_effective_date IN DATE
1678 ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
1679 --
1680 ,p_business_group_id IN NUMBER
1681 ,p_date_from IN DATE
1682 ,p_name IN VARCHAR2
1683 ,p_type IN VARCHAR2
1684 ,p_internal_external_flag IN VARCHAR2
1685 ,p_location_id IN NUMBER
1686 ,p_set_of_books_id IN VARCHAR2
1687 -- Added p_legal_entity_id for bug 41281871
1688 ,p_legal_entity_id IN VARCHAR2 DEFAULT null
1689 -- Added p_short_code for bug 4526439
1690 ,p_short_code IN VARCHAR2 DEFAULT null
1691 ,p_organization_id OUT NOCOPY NUMBER
1692 ,p_object_version_number OUT NOCOPY NUMBER
1693 );
1694 --
1695 --
1696 -- ----------------------------------------------------------------------------
1697 -- |---------------------------< get_operating_unit >----------------------|
1698 -- ----------------------------------------------------------------------------
1699 -- {Start Of Comments}
1700 --
1701 -- Description:
1702 -- This function returns operating unit for a given person when provided
1703 -- with only one of the following parameters of person_id,assignment_id
1704 -- or organization_id.
1705 --
1706 --
1707 function get_operating_unit
1708 (
1709 p_effective_date IN DATE
1710 ,p_person_id IN NUMBER DEFAULT NULL
1711 ,p_assignment_id IN NUMBER DEFAULT NULL
1712 ,p_organization_id IN NUMBER DEFAULT NULL
1713 ) return number;
1714 --
1715 --
1716 -- ----------------------------------------------------------------------------
1717 -- |--------------------------< update_operating_unit >-----------------------|
1718 -- ----------------------------------------------------------------------------
1719 --
1720 -- {Start Of Comments}
1721 /*#
1722 * This API updates a new operating unit starting with existing
1723 * business group. The API is MLS enabled, and there is
1724 * one translated column: NAME.
1725 *
1726 * Organizations are updated on the HR_ALL_ORGANIZATION_UNITS table.
1727 * The translated columns are stored on the
1728 * HR_ALL_ORGANIZATION_UNITS_TL table.
1729 *
1730 * <p><b>Licensing</b><br>
1731 * This API is licensed for use with Human Resources and HR Foundation.
1732 *
1733 * <p><b>Prerequisites</b><br>
1734 * Operating should exists for the Business group
1735 *
1736 * <p><b>Post Success</b><br>
1737 * Operating unit gets successfully Updated.
1738 *
1739 * <p><b>Post Failure</b><br>
1740 * Operating unit is not updated and returns an error.
1741 *
1742 * @param p_validate If true, then validation alone will be performed and
1743 * the database will remain unchanged. If false and all validation checks pass,
1744 * then the database will be modified.
1748 * date_track validation.
1745 * @param p_organization_id Uniquely identifies the operating unit.
1746 * @param p_effective_date Reference date for validating lookup values are
1747 * applicable during the start to end active date range and used for
1749 * @param p_language_code Specifies to which language the translation
1750 * values apply. You can set to the base or any installed language. The default
1751 * value of hr_api.userenv_lang is equivalent to the RDBMS userenv('LANG')
1752 * function value.
1753 * @param p_date_from Date the operating unit takes effect.
1754 * @param p_name The name of the operating unit.
1755 * @param p_type The organization type associated with the operating unit the
1756 * process creates. Valid values are determined by the ORG_TYPE lookup type.
1757 * @param p_internal_external_flag Flag specifying if the organization is an
1758 * internal or external organization.
1759 * @param p_location_id Uniquely identifies the location of the operating unit.
1760 * @param p_set_of_books_id Uniquely identifies the ledger associated
1761 * with the operating unit.
1762 * @param p_usable_flag Marks the operating unit usable when null is passed.
1763 * @param p_short_code Operating unit short code.
1764 * @param p_legal_entity_id Uniquely identifies the legal entity associated
1765 * with the operating unit.
1766 * @param p_object_version_number If p_validate is false, then set to the
1767 * version number of the operating unit updated. If p_validate is true, then
1768 * set to the same value which was passed in.
1769 * @param p_update_prim_ledger_warning Used to raise warning.
1770 * @param p_duplicate_org_warning The value is 'true' if an organization
1771 * already exists with the same name in a different business group. (If the
1772 * duplicate is in the same business group, the process raises an error.)
1773 * @rep:displayname Update Operating Unit
1774 * @rep:category BUSINESS_ENTITY HR_OPERATING_UNIT
1775 * @rep:scope public
1776 * @rep:lifecycle active
1777 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
1778 */
1779 --
1780 -- {End Of Comments}
1781 --
1782 PROCEDURE update_operating_unit
1783 (
1784 p_validate IN BOOLEAN DEFAULT false
1785 ,p_organization_id IN NUMBER
1786 ,p_effective_date IN DATE
1787 ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
1788 ,p_date_from IN DATE DEFAULT hr_api.g_date
1789 ,p_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
1790 ,p_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
1791 ,p_internal_external_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
1792 ,p_location_id IN NUMBER DEFAULT hr_api.g_number
1793 ,p_set_of_books_id IN VARCHAR2 DEFAULT hr_api.g_varchar2
1794 ,p_usable_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
1795 -- Added p_short_code for bug 4526439
1796 ,p_short_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
1797 ,p_legal_entity_id IN VARCHAR2 DEFAULT hr_api.g_varchar2
1798 ,p_object_version_number IN OUT NOCOPY NUMBER
1799 ,p_update_prim_ledger_warning OUT NOCOPY BOOLEAN
1800 ,p_duplicate_org_warning OUT NOCOPY BOOLEAN
1801 );
1802
1803 --
1804 --
1805 --
1806 -- ----------------------------------------------------------------------------
1807 -- |---------------------------< create_legal_entity >------------------------|
1808 -- ----------------------------------------------------------------------------
1809 --
1810 -- {Start Of Comments}
1811 /*#
1812 * This API creates an organization with a classification of legal entity.
1813 *
1814 * The API is MLS enabled, and there is one translated column (NAME).
1815 * Organizations are stored in the table HR_ALL_ORGANIZATION_UNITS. The
1816 * translated columns are stored in the table HR_ALL_ORGANIZATION_UNITS_TL.
1817 *
1818 * <p><b>Licensing</b><br>
1819 * This API is licensed for use with Human Resources and HR Foundation.
1820 *
1821 * <p><b>Prerequisites</b><br>
1822 * Business group should exist.
1823 *
1824 * <p><b>Post Success</b><br>
1825 * An organization with a classification of legal entity is created.
1826 *
1827 * <p><b>Post Failure</b><br>
1828 * The API does not create the organization, and raises an error.
1829 *
1830 * @param p_validate If true, then validation alone will be performed and the
1831 * database will remain unchanged. If false and all validation checks pass,
1832 * then the database will be modified.
1833 * @param p_effective_date Reference date for validating lookup values are
1834 * applicable during the start to end active date range. This date does not
1835 * determine when the changes take effect.
1836 * @param p_language_code Specifies to which language the translation values
1837 * apply. You can set to the base or any installed language. The default value
1838 * of hr_api.userenv_lang is equivalent to the RDBMS userenv('LANG') function
1839 * value.
1840 * @param p_business_group_id Uniquely identifies the business group associated
1841 * with the legal entity the process creates.
1842 * @param p_date_from Date the legal entity takes effect.
1843 * @param p_name Name of the legal entity
1844 * @param p_type The organization type associated with the legal entity the
1845 * process creates. Valid values are determined by the ORG_TYPE lookup type.
1846 * @param p_internal_external_flag Flag specifying if the organization is an
1847 * internal or external organization.
1848 * @param p_location_id Uniquely identifies the location of the legal entity
1849 * the process creates.
1850 * @param p_set_of_books_id ledger id.
1851 * @param p_organization_id If p_validate is false, then this uniquely
1855 * version number of the legal entity created. If p_validate is true, then set
1852 * identifies the legal entity created. If p_validate is true, then set to
1853 * null.
1854 * @param p_object_version_number If p_validate is false, then set to the
1856 * to null..
1857 * @rep:displayname Create Legal Entity
1858 * @rep:category BUSINESS_ENTITY HR_LEGAL_ENTITY
1859 * @rep:scope public
1860 * @rep:lifecycle active
1861 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
1862 */
1863 --
1864 -- {End Of Comments}
1865 --
1866
1867 PROCEDURE create_legal_entity
1868 ( p_validate IN BOOLEAN DEFAULT false
1869 ,p_effective_date IN DATE
1870 ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
1871 --
1872 ,p_business_group_id IN NUMBER
1873 ,p_date_from IN DATE
1874 ,p_name IN VARCHAR2
1875 ,p_type IN VARCHAR2
1876 ,p_internal_external_flag IN VARCHAR2
1877 ,p_location_id IN NUMBER
1878 ,p_set_of_books_id IN VARCHAR2
1879 ,p_organization_id OUT NOCOPY NUMBER
1880 ,p_object_version_number OUT NOCOPY NUMBER
1881 );
1882 --
1883 -- ----------------------------------------------------------------------------
1884 -- |----------------------------< create_bgr_classif >------------------------|
1885 -- ----------------------------------------------------------------------------
1886 --
1887 -- {Start Of Comments}
1888 /*#
1889 * This API creates a new classification for an existing business group, namely
1890 * operating unit and legal entity accounting.
1891 *
1892 *
1893 * <p><b>Licensing</b><br>
1894 * This API is licensed for use with Human Resources and HR Foundation.
1895 *
1896 * <p><b>Prerequisites</b><br>
1897 * Business group exists.
1898 *
1899 * <p><b>Post Success</b><br>
1900 * operating unit and legal entity accounting classification added to an
1901 * existing business group.
1902 *
1903 * <p><b>Post Failure</b><br>
1904 * operating unit and legal entity accounting classification not added to an
1905 * existing business group, and raises an error.
1906 *
1907 * @param p_validate If true, then validation alone will be performed and the
1908 * database will remain unchanged. If false and all validation checks pass,
1909 * then the database will be modified.
1910 * @param p_effective_date Reference date for validating lookup values are
1911 * applicable during the start to end active date range. This date does not
1912 * determine when the changes take effect.
1913 * @param p_business_group_id Uniquely identifies the business group associated
1914 * with the business group classification the process creates.
1915 * @param p_set_of_books_id Uniquely identifies the ledger associated
1916 * with the business group classification the process creates.
1917 * @rep:displayname Create Business Group Classification
1918 * @rep:category BUSINESS_ENTITY HR_ORGANIZATION
1919 * @rep:scope public
1920 * @rep:lifecycle active
1921 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
1922 */
1923 --
1924 -- {End Of Comments}
1925 --
1926 PROCEDURE create_bgr_classif
1927 ( p_validate IN BOOLEAN DEFAULT false
1928 ,p_effective_date IN DATE
1929 --
1930 ,p_business_group_id IN NUMBER
1931 ,p_set_of_books_id IN VARCHAR2
1932 );
1933 --
1934 -- ----------------------------------------------------------------------------
1935 -- |-----------------------< create_legal_entity_classif >--------------------|
1936 -- ----------------------------------------------------------------------------
1937 --
1938 -- {Start Of Comments}
1939 /*#
1940 * This API creates a Legal Entity Classification for an existing Organization
1941 * and populates information type data.
1942 *
1943 * Organizations are stored in the table HR_ALL_ORGANIZATION_UNITS.
1944 *
1945 * <p><b>Licensing</b><br>
1946 * This API is licensed for use with Human Resources and HR Foundation.
1947 *
1948 * <p><b>Prerequisites</b><br>
1949 * Organization ID should exist.
1950 *
1951 * <p><b>Post Success</b><br>
1952 * The process successfully inserts the legal entity classification.
1953 *
1954 * <p><b>Post Failure</b><br>
1955 * The API does not create the legal entity classification and raises an error.
1956 *
1957 * @param p_validate If true, then validation alone will be performed and the
1958 * database will remain unchanged. If false and all validation checks pass,
1959 * then the database will be modified.
1960 * @param p_effective_date Reference date for validating lookup values are
1961 * applicable during the start to end active date range. This date does not
1962 * determine when the changes take effect.
1963 * @param p_organization_id Uniquely identifies the organization associated
1964 * with the legal entity classification the process creates.
1965 * @param p_set_of_books_id Uniquely identifies the ledger associated
1966 * with the legal entity classification the process creates.
1967 * @rep:displayname Create Legal Entity Classification
1968 * @rep:category BUSINESS_ENTITY HR_ORGANIZATION
1969 * @rep:scope public
1970 * @rep:lifecycle active
1971 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
1972 */
1973 --
1974 -- {End Of Comments}
1975 --
1976
1977 PROCEDURE create_legal_entity_classif
1978 ( p_validate IN BOOLEAN DEFAULT false
1979 ,p_effective_date IN DATE
1980 --
1981 ,p_organization_id IN NUMBER
1982 ,p_set_of_books_id IN VARCHAR2
1983 );
1984 --
1985 -- ----------------------------------------------------------------------------
1989 -- {Start Of Comments}
1986 -- |-------------------------< create_oper_unit_classif >---------------------|
1987 -- ----------------------------------------------------------------------------
1988 --
1990 /*#
1991 * This API creates an Operating Unit classification for an existing
1992 * organization.
1993 *
1994 * This API creates new classification for existing organization and populates
1995 * information type data. Organizations are stored in the table
1996 * HR_ALL_ORGANIZATION_UNITS.
1997 *
1998 * <p><b>Licensing</b><br>
1999 * This API is licensed for use with Human Resources and HR Foundation.
2000 *
2001 * <p><b>Prerequisites</b><br>
2002 * Organization should exist.
2003 *
2004 * <p><b>Post Success</b><br>
2005 * When the process has successfully inserted the operating unit
2006 * classification, the process sets the OUT parameters.
2007 *
2008 * <p><b>Post Failure</b><br>
2009 * The API does not create the operating unit classification and raises error.
2010 *
2011 * @param p_validate If true, then validation alone will be performed and the
2012 * database will remain unchanged. If false and all validation checks pass,
2013 * then the database will be modified.
2014 * @param p_effective_date Reference date for validating lookup values are
2015 * applicable during the start to end active date range. This date does not
2016 * determine when the changes take effect.
2017 * @param p_organization_id Uniquely identifies the organization associated
2018 * with the operating unit classification the process creates.
2019 * @param p_legal_entity_id Uniquely identifies the legal entity associated
2020 * with the operating unit classification the process creates.
2021 * @param p_set_of_books_id Uniquely identifies the ledger associated
2022 * with the operating unit classification the process creates.
2023 * @param p_oper_unit_short_code Operating Unit Short Code.
2024 * @rep:displayname Create Operating Unit Classification
2025 * @rep:category BUSINESS_ENTITY HR_ORGANIZATION
2026 * @rep:scope public
2027 * @rep:lifecycle active
2028 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
2029 */
2030 --
2031 -- {End Of Comments}
2032 --
2033 PROCEDURE create_oper_unit_classif
2034 ( p_validate IN BOOLEAN DEFAULT false
2035 ,p_effective_date IN DATE
2036 --
2037 ,p_organization_id IN NUMBER
2038 ,p_legal_entity_id IN VARCHAR2
2039 ,p_set_of_books_id IN VARCHAR2
2040 ,p_oper_unit_short_code IN VARCHAR2 DEFAULT null --- Fix For Bug # 7439707
2041 );
2042 --
2043 -- ----------------------------------------------------------------------------
2044 -- |------------------------------< trans_org_name >--------------------------|
2045 -- ----------------------------------------------------------------------------
2046 --
2047 -- {Start Of Comments}
2048 /*#
2049 * This API translates an organization name.
2050 *
2051 * This API translates an organization name into a specified language. The API
2052 * is MLS enabled, and there is one translated column (NAME). The translated
2053 * column is stored in the table HR_ALL_ORGANIZATION_UNITS_TL.
2054 *
2055 * <p><b>Licensing</b><br>
2056 * This API is licensed for use with HR Foundation.
2057 *
2058 * <p><b>Prerequisites</b><br>
2059 * Oragnization should exist.
2060 *
2061 * <p><b>Post Success</b><br>
2062 * When the organization name has been successfully translated, the following
2063 * OUT parameters are set:
2064 *
2065 * <p><b>Post Failure</b><br>
2066 * The API does not translate the organization name, and raises an error
2067 * @param p_validate If true, then validation alone will be performed and the
2068 * database will remain unchanged. If false and all validation checks pass,
2069 * then the database will be modified.
2070 * @param p_effective_date Reference date for validating lookup values are
2071 * applicable during the start to end active date range. This date does not
2072 * determine when the changes take effect.
2073 * @param p_language_code Specifies to which language the translation values
2074 * apply. You can set to the base or any installed language. The default value
2075 * of hr_api.userenv_lang is equivalent to the RDBMS userenv('LANG') function
2076 * value.
2077 * @param p_organization_id Uniquely identifies the organization whose name the
2078 * process translates.
2079 * @param p_name The organization name (translated)
2080 * @rep:displayname Translate Organization Name
2081 * @rep:category BUSINESS_ENTITY HR_ORGANIZATION
2082 * @rep:scope public
2083 * @rep:lifecycle active
2084 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
2085 */
2086 --
2087 -- {End Of Comments}
2088 --
2089 PROCEDURE trans_org_name
2090 ( p_validate IN BOOLEAN DEFAULT false
2091 ,p_effective_date IN DATE
2092 ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
2093 --
2094 ,p_organization_id IN NUMBER
2095 ,p_name IN VARCHAR2
2096 );
2097 --
2098 -- ----------------------------------------------------------------------------
2099 -- |------------------------< create_company_cost_center >--------------------|
2100 -- ----------------------------------------------------------------------------
2101 --
2102 -- {Start Of Comments}
2103 /*#
2104 * This API adds an organization classification of Company Cost Center.
2105 *
2106 * This API creates new Company Cost Center classification for an existing
2107 * organization and populates information type data. Organizations are stored
2108 * in the table HR_ALL_ORGANIZATION_UNITS.
2109 *
2110 * <p><b>Licensing</b><br>
2111 * This API is licensed for use with Human Resources.
2112 *
2113 * <p><b>Prerequisites</b><br>
2114 * Organization should exist.
2115 *
2116 * <p><b>Post Success</b><br>
2117 * Company cost center is successfully created.
2118 *
2119 * <p><b>Post Failure</b><br>
2120 * The API does not create the organization classification and org information
2121 * and raises an error
2122 * @param p_validate If true, then validation alone will be performed and the
2123 * database will remain unchanged. If false and all validation checks pass,
2124 * then the database will be modified.
2125 * @param p_effective_date Reference date for validating lookup values are
2126 * applicable during the start to end active date range. This date does not
2127 * determine when the changes take effect.
2128 * @param p_organization_id Uniquely identifies the organization associated
2129 * with the classification and information the process creates.
2130 * @param p_company_valueset_id maps onto org_information2
2131 * @param p_company maps onto org_information3
2132 * @param p_costcenter_valueset_id maps onto org_information4
2133 * @param p_costcenter maps onto org_information5
2134 * @param p_ori_org_information_id Uniquely identifies the org classification
2135 * of 'CC'.
2136 * @param p_ori_object_version_number If p_validate is false, then set to the
2137 * version number of the organization classification ('CC') record created. If
2138 * p_validate is true, then the value will be null.
2139 * @param p_org_information_id Uniquely identifies the 'Company Cost Center'
2140 * organization information the process creates.
2141 * @param p_object_version_number If p_validate is false, then set to the
2142 * version number of the Organization Classification created. If p_validate is
2143 * true, then set to null.
2144 * @rep:displayname Create Company Cost Center
2145 * @rep:category BUSINESS_ENTITY HR_COST_CENTER
2146 * @rep:category MISC_EXTENSIONS HR_DATAPUMP
2147 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
2148 * @rep:scope public
2149 * @rep:lifecycle active
2150 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
2151 */
2152 --
2153 -- {End Of Comments}
2154 --
2155
2156 PROCEDURE create_company_cost_center
2157 ( p_validate IN BOOLEAN DEFAULT false
2158 ,p_effective_date IN DATE
2159 ,p_organization_id IN NUMBER
2160 ,p_company_valueset_id IN NUMBER DEFAULT null
2161 ,p_company IN VARCHAR2 DEFAULT null
2162 ,p_costcenter_valueset_id IN NUMBER DEFAULT null
2163 ,p_costcenter IN VARCHAR2 DEFAULT null
2164 ,p_ori_org_information_id OUT NOCOPY NUMBER
2165 ,p_ori_object_version_number OUT NOCOPY NUMBER
2166 ,p_org_information_id OUT NOCOPY NUMBER
2167 ,p_object_version_number OUT NOCOPY NUMBER
2168 );
2169 --
2170 --
2171 --------------------------------------------------------------------------------
2172 PROCEDURE set_translation_globals(p_business_group_id IN NUMBER,
2173 p_legislation_code IN VARCHAR2);
2174 --------------------------------------------------------------------------------
2175 --
2176 --
2177 PROCEDURE create_org_class_internal
2178 ( p_validate IN BOOLEAN DEFAULT false
2179 ,p_effective_date IN DATE
2180 ,p_organization_id IN NUMBER
2181 ,p_org_classif_code IN VARCHAR2
2182 ,p_classification_enabled IN VARCHAR2 DEFAULT 'Y' -- Bug 3456540
2183 ,p_org_information_id OUT nocopy NUMBER
2184 ,p_object_version_number OUT nocopy NUMBER
2185 );
2186 --
2187 -- ----------------------------------------------------------------------------
2188 -- |----------------------< create_not_usable_ou_internal >-------------------|
2189 -- ----------------------------------------------------------------------------
2190 -- This API creates a default or not usable Operating Unit.
2191 PROCEDURE create_not_usable_ou_internal
2192 (p_validate IN BOOLEAN DEFAULT FALSE
2193 ,p_effective_date IN DATE
2194 ,p_language_code IN VARCHAR2 DEFAULT HR_API.userenv_lang
2195 ,p_business_group_id IN NUMBER
2196 ,p_date_from IN DATE
2197 ,p_name IN VARCHAR2
2198 ,p_type IN VARCHAR2
2199 ,p_internal_external_flag IN VARCHAR2
2200 ,p_location_id IN NUMBER
2201 ,p_ledger_id IN VARCHAR2 DEFAULT NULL
2202 ,p_default_legal_context IN VARCHAR2 DEFAULT NULL
2203 ,p_short_code IN VARCHAR2 DEFAULT NULL
2204 ,p_organization_id OUT NOCOPY NUMBER
2205 ,p_object_version_number OUT NOCOPY NUMBER );
2206 --
2207 END hr_organization_api;
2208 --
2209 --
[Home] [Help]