1 Package hr_item_properties_bsi AUTHID CURRENT_USER as
2 /* $Header: hritpbsi.pkh 115.2 2003/09/24 02:00:25 bsubrama noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |--------------------------< create_item_property >------------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description: This business support process inserts a new item property
10 -- in the HR Schema.
11 --
12 --
13 -- Prerequisites:
14 --
15 --
16 -- In Parameters:
17 -- Name Reqd Type Description
18 -- p_language_code N varchar2
19 -- p_form_item_id N number
20 -- p_template_item_id N number
21 -- p_template_item_context_id N number
22 -- p_alignment N number
23 -- p_bevel N number
24 -- p_case_restriction N number
25 -- p_default_value N varchar2
26 -- p_enabled N number
27 -- p_format_mask N varchar2
28 -- p_height N number
29 -- p_information_formula_id N number
30 -- p_information_param_item_id1 N number
31 -- p_information_param_item_id2 N number
32 -- p_information_param_item_id3 N number
33 -- p_information_param_item_id4 N number
34 -- p_information_param_item_id5 N number
35 -- p_information_prompt N varchar2
36 -- p_insert_allowed N number
37 -- p_label N varchar2
38 -- p_prompt_text N varchar2
39 -- p_prompt_alignment_offset N number
40 -- p_prompt_display_style N number
41 -- p_prompt_edge N number
42 -- p_prompt_edge_alignment N number
43 -- p_prompt_edge_offset N number
44 -- p_prompt_text_alignment N number
45 -- p_query_allowed N number
46 -- p_required N number
47 -- p_tooltip_text N varchar2
48 -- p_update_allowed N number
49 -- p_validation_formula_id N number
50 -- p_validation_param_item_id2 N number
51 -- p_validation_param_item_id3 N number
52 -- p_validation_param_item_id4 N number
53 -- p_validation_param_item_id5 N number
54 -- p_validation_param_item_id6 N number
55 -- p_visible N number
56 -- p_width N number
57 -- p_x_position N number
58 -- p_y_position N number
59 -- p_information_category N varchar2
60 -- p_information1 N varchar2
61 -- p_information2 N varchar2
62 -- p_information3 N varchar2
63 -- p_information4 N varchar2
64 -- p_information5 N varchar2
65 -- p_information6 N varchar2
66 -- p_information7 N varchar2
67 -- p_information8 N varchar2
68 -- p_information9 N varchar2
69 -- p_information10 N varchar2
70 -- p_information11 N varchar2
71 -- p_information12 N varchar2
72 -- p_information13 N varchar2
73 -- p_information14 N varchar2
74 -- p_information15 N varchar2
75 -- p_information16 N varchar2
76 -- p_information17 N varchar2
77 -- p_information18 N varchar2
78 -- p_information19 N varchar2
79 -- p_information20 N varchar2
80 -- p_information21 N varchar2
81 -- p_information22 N varchar2
82 -- p_information23 N varchar2
83 -- p_information24 N varchar2
84 -- p_information25 N varchar2
85 -- p_information26 N varchar2
86 -- p_information27 N varchar2
87 -- p_information28 N varchar2
88 -- p_information29 N varchar2
89 -- p_information30 N varchar2
90 --
91 -- Post Success:
92 --
93 --
94 -- Name Type Description
95 -- p_item_property_id Number
96 ---- p_override_value_warning Number
97 --
98 -- Post Failure:
99 --
100 --
101 -- Access Status:
102 -- Public.
103 --
104 -- {End Of Comments}
105 --
106 procedure create_item_property
107 (p_validate in boolean default false
108 ,p_effective_date in date
109 ,p_language_code in varchar2 default hr_api.userenv_lang
110 ,p_form_item_id in number default null
111 ,p_template_item_id in number default null
112 ,p_template_item_context_id in number default null
113 ,p_alignment in number default null
114 ,p_bevel in number default null
115 ,p_case_restriction in number default null
116 ,p_default_value in varchar2 default null
117 ,p_enabled in number default null
118 ,p_format_mask in varchar2 default null
119 ,p_height in number default null
120 ,p_information_formula_id in number default null
121 ,p_information_param_item_id1 in number default null
122 ,p_information_param_item_id2 in number default null
123 ,p_information_param_item_id3 in number default null
124 ,p_information_param_item_id4 in number default null
125 ,p_information_param_item_id5 in number default null
126 ,p_information_prompt in varchar2 default null
127 ,p_insert_allowed in number default null
128 ,p_label in varchar2 default null
129 ,p_prompt_text in varchar2 default null
130 ,p_prompt_alignment_offset in number default null
131 ,p_prompt_display_style in number default null
132 ,p_prompt_edge in number default null
133 ,p_prompt_edge_alignment in number default null
134 ,p_prompt_edge_offset in number default null
135 ,p_prompt_text_alignment in number default null
136 ,p_query_allowed in number default null
137 ,p_required in number default null
138 ,p_tooltip_text in varchar2 default null
139 ,p_update_allowed in number default null
140 ,p_validation_formula_id in number default null
141 ,p_validation_param_item_id1 in number default null
142 ,p_validation_param_item_id2 in number default null
143 ,p_validation_param_item_id3 in number default null
144 ,p_validation_param_item_id4 in number default null
145 ,p_validation_param_item_id5 in number default null
146 ,p_visible in number default null
147 ,p_width in number default null
148 ,p_x_position in number default null
149 ,p_y_position in number default null
150 ,p_information_category in varchar2 default null
151 ,p_information1 in varchar2 default null
152 ,p_information2 in varchar2 default null
153 ,p_information3 in varchar2 default null
154 ,p_information4 in varchar2 default null
155 ,p_information5 in varchar2 default null
156 ,p_information6 in varchar2 default null
157 ,p_information7 in varchar2 default null
158 ,p_information8 in varchar2 default null
159 ,p_information9 in varchar2 default null
160 ,p_information10 in varchar2 default null
161 ,p_information11 in varchar2 default null
162 ,p_information12 in varchar2 default null
163 ,p_information13 in varchar2 default null
164 ,p_information14 in varchar2 default null
165 ,p_information15 in varchar2 default null
166 ,p_information16 in varchar2 default null
167 ,p_information17 in varchar2 default null
168 ,p_information18 in varchar2 default null
169 ,p_information19 in varchar2 default null
170 ,p_information20 in varchar2 default null
171 ,p_information21 in varchar2 default null
172 ,p_information22 in varchar2 default null
173 ,p_information23 in varchar2 default null
174 ,p_information24 in varchar2 default null
175 ,p_information25 in varchar2 default null
176 ,p_information26 in varchar2 default null
177 ,p_information27 in varchar2 default null
178 ,p_information28 in varchar2 default null
179 ,p_information29 in varchar2 default null
180 ,p_information30 in varchar2 default null
181 ,p_next_navigation_item_id in number default null
182 ,p_previous_navigation_item_id in number default null
183 ,p_item_property_id out nocopy number
184 ,p_object_version_number out nocopy number
185 --,p_override_value_warning out boolean
186 );
187 --
188 --
189 -- ----------------------------------------------------------------------------
190 -- |--------------------------< update_item_property >-------------------------|
191 -- ----------------------------------------------------------------------------
192 -- {Start Of Comments}
193 --
194 -- Description:
195 --
196 --
197 -- Prerequisites:
198 --
199 --
200 -- In Parameters:
201 -- Name Reqd Type Description
202 -- p_language_code N varchar2
203 -- p_item_property_id N number
204 -- p_form_item_id N number
205 -- p_template_item_id N number
206 -- p_template_item_context_id N number
207 -- p_alignment N number
208 -- p_bevel N number
209 -- p_case_restriction N number
210 -- p_default_value N varchar2
211 -- p_enabled N number
212 -- p_format_mask N varchar2
213 -- p_height N number
214 -- p_information_formula_id N number
215 -- p_information_param_item_id1 N number
216 -- p_information_param_item_id2 N number
217 -- p_information_param_item_id3 N number
218 -- p_information_param_item_id4 N number
219 -- p_information_param_item_id5 N number
220 -- p_information_prompt N varchar2
221 -- p_insert_allowed N number
222 -- p_label N varchar2
223 -- p_prompt_text N varchar2
224 -- p_prompt_alignment_offset N number
225 -- p_prompt_display_style N number
226 -- p_prompt_edge N number
227 -- p_prompt_edge_alignment N number
228 -- p_prompt_edge_offset N number
229 -- p_prompt_text_alignment N number
230 -- p_query_allowed N number
231 -- p_required N number
232 -- p_tooltip_text N varchar2
233 -- p_update_allowed N number
234 -- p_validation_formula_id N number
235 -- p_validation_param_item_id1 N number
236 -- p_validation_param_item_id2 N number
237 -- p_validation_param_item_id3 N number
238 -- p_validation_param_item_id4 N number
239 -- p_validation_param_item_id5 N number
240 -- p_visible N number
241 -- p_width N number
242 -- p_x_position N number
243 -- p_y_position N number
244 -- p_information_category N varchar2
245 -- p_information1 N varchar2
246 -- p_information2 N varchar2
247 -- p_information3 N varchar2
248 -- p_information4 N varchar2
249 -- p_information5 N varchar2
250 -- p_information6 N varchar2
251 -- p_information7 N varchar2
252 -- p_information8 N varchar2
253 -- p_information9 N varchar2
254 -- p_information10 N varchar2
255 -- p_information11 N varchar2
256 -- p_information12 N varchar2
257 -- p_information13 N varchar2
258 -- p_information14 N varchar2
259 -- p_information15 N varchar2
260 -- p_information16 N varchar2
261 -- p_information17 N varchar2
262 -- p_information18 N varchar2
263 -- p_information19 N varchar2
264 -- p_information20 N varchar2
265 -- p_information21 N varchar2
266 -- p_information22 N varchar2
267 -- p_information23 N varchar2
268 -- p_information24 N varchar2
269 -- p_information25 N varchar2
270 -- p_information26 N varchar2
271 -- p_information27 N varchar2
272 -- p_information28 N varchar2
273 -- p_information29 N varchar2
274 -- p_information30 N varchar2
275 --
276 --
277 -- Post Success:
278 --
279 --
280 -- Name Type Description
281 -- p_override_value_warning Number
282 --
283 -- Post Failure:
284 --
285 --
286 -- Access Status:
287 -- Public.
288 --
289 -- {End Of Comments}
290 --
291 procedure update_item_property
292 (p_validate in boolean default false
293 ,p_effective_date in date
294 ,p_language_code in varchar2 default hr_api.userenv_lang
295 ,p_item_property_id in number default null
296 ,p_object_version_number in out nocopy number
297 ,p_form_item_id in number default null
298 ,p_template_item_id in number default null
299 ,p_template_item_context_id in number default null
300 ,p_alignment in number default hr_api.g_number
301 ,p_bevel in number default hr_api.g_number
302 ,p_case_restriction in number default hr_api.g_number
303 ,p_default_value in varchar2 default hr_api.g_varchar2
304 ,p_enabled in number default hr_api.g_number
305 ,p_format_mask in varchar2 default hr_api.g_varchar2
306 ,p_height in number default hr_api.g_number
307 ,p_information_formula_id in number default hr_api.g_number
308 ,p_information_param_item_id1 in number default hr_api.g_number
309 ,p_information_param_item_id2 in number default hr_api.g_number
310 ,p_information_param_item_id3 in number default hr_api.g_number
311 ,p_information_param_item_id4 in number default hr_api.g_number
312 ,p_information_param_item_id5 in number default hr_api.g_number
313 ,p_information_prompt in varchar2 default hr_api.g_varchar2
314 ,p_insert_allowed in number default hr_api.g_number
315 ,p_label in varchar2 default hr_api.g_varchar2
316 ,p_prompt_text in varchar2 default hr_api.g_varchar2
317 ,p_prompt_alignment_offset in number default hr_api.g_number
318 ,p_prompt_display_style in number default hr_api.g_number
319 ,p_prompt_edge in number default hr_api.g_number
320 ,p_prompt_edge_alignment in number default hr_api.g_number
321 ,p_prompt_edge_offset in number default hr_api.g_number
322 ,p_prompt_text_alignment in number default hr_api.g_number
323 ,p_query_allowed in number default hr_api.g_number
324 ,p_required in number default hr_api.g_number
325 ,p_tooltip_text in varchar2 default hr_api.g_varchar2
326 ,p_update_allowed in number default hr_api.g_number
327 ,p_validation_formula_id in number default hr_api.g_number
328 ,p_validation_param_item_id1 in number default hr_api.g_number
329 ,p_validation_param_item_id2 in number default hr_api.g_number
330 ,p_validation_param_item_id3 in number default hr_api.g_number
331 ,p_validation_param_item_id4 in number default hr_api.g_number
332 ,p_validation_param_item_id5 in number default hr_api.g_number
333 ,p_visible in number default hr_api.g_number
334 ,p_width in number default hr_api.g_number
335 ,p_x_position in number default hr_api.g_number
336 ,p_y_position in number default hr_api.g_number
337 ,p_information_category in varchar2 default hr_api.g_varchar2
338 ,p_information1 in varchar2 default hr_api.g_varchar2
339 ,p_information2 in varchar2 default hr_api.g_varchar2
340 ,p_information3 in varchar2 default hr_api.g_varchar2
341 ,p_information4 in varchar2 default hr_api.g_varchar2
342 ,p_information5 in varchar2 default hr_api.g_varchar2
343 ,p_information6 in varchar2 default hr_api.g_varchar2
344 ,p_information7 in varchar2 default hr_api.g_varchar2
345 ,p_information8 in varchar2 default hr_api.g_varchar2
346 ,p_information9 in varchar2 default hr_api.g_varchar2
347 ,p_information10 in varchar2 default hr_api.g_varchar2
348 ,p_information11 in varchar2 default hr_api.g_varchar2
349 ,p_information12 in varchar2 default hr_api.g_varchar2
350 ,p_information13 in varchar2 default hr_api.g_varchar2
351 ,p_information14 in varchar2 default hr_api.g_varchar2
352 ,p_information15 in varchar2 default hr_api.g_varchar2
353 ,p_information16 in varchar2 default hr_api.g_varchar2
354 ,p_information17 in varchar2 default hr_api.g_varchar2
355 ,p_information18 in varchar2 default hr_api.g_varchar2
356 ,p_information19 in varchar2 default hr_api.g_varchar2
357 ,p_information20 in varchar2 default hr_api.g_varchar2
358 ,p_information21 in varchar2 default hr_api.g_varchar2
359 ,p_information22 in varchar2 default hr_api.g_varchar2
360 ,p_information23 in varchar2 default hr_api.g_varchar2
361 ,p_information24 in varchar2 default hr_api.g_varchar2
362 ,p_information25 in varchar2 default hr_api.g_varchar2
363 ,p_information26 in varchar2 default hr_api.g_varchar2
364 ,p_information27 in varchar2 default hr_api.g_varchar2
365 ,p_information28 in varchar2 default hr_api.g_varchar2
366 ,p_information29 in varchar2 default hr_api.g_varchar2
367 ,p_information30 in varchar2 default hr_api.g_varchar2
368 ,p_next_navigation_item_id in number default hr_api.g_number
369 ,p_previous_navigation_item_id in number default hr_api.g_number
370 --,p_override_value_warning out boolean
371 );
372 --
373 --
374 -- ----------------------------------------------------------------------------
375 -- |--------------------------< delete_item_property >------------------------|
376 -- ----------------------------------------------------------------------------
377 -- {Start Of Comments}
378 --
379 -- Description: This business support process deletes an item property from
380 -- the HR Schema.
381 --
382 --
383 -- Prerequisites:
384 --
385 --
386 -- In Parameters:
387 -- Name Reqd Type Description
388 -- p_item_property_id N number
389 -- p_form_item_id N number
390 -- p_template_item_id N number
391 -- p_template_item_context_id N number
392 --
393 --
394 -- Post Success:
395 --
396 --
397 -- Name Type Description
398 --
399 -- Post Failure:
400 --
401 --
402 -- Access Status:
403 -- Public.
404 --
405 -- {End Of Comments}
406 --
407 procedure delete_item_property
408 (p_validate in boolean default false
409 ,p_item_property_id in number default null
410 ,p_form_item_id in number default null
411 ,p_template_item_id in number default null
412 ,p_template_item_context_id in number default null
413 ,p_object_version_number in number
414 );
415 --
416 --
417 -- ----------------------------------------------------------------------------
418 -- |--------------------------< copy_item_property >--------------------------|
419 -- ----------------------------------------------------------------------------
420 -- {Start Of Comments}
421 --
422 -- Description: This business support process copies properties from a form
423 -- item to a template item. Any property may not be copied by
424 -- specifying the value required in the parameter list.
425 --
426 -- Prerequisites:
427 --
428 --
429 -- In Parameters:
430 -- Name Reqd Type Description
431 -- p_language_code N varchar2
432 -- p_form_item_id Y number
433 -- p_template_item_id Y number
434 -- p_alignment N number
435 -- p_bevel N number
436 -- p_case_restriction N number
437 -- p_default_value N varchar2
438 -- p_enabled N number
439 -- p_format_mask N varchar2
440 -- p_height N number
441 -- p_information_formula_id N number
442 -- p_information_param_item_id1 N number
443 -- p_information_param_item_id2 N number
444 -- p_information_param_item_id3 N number
445 -- p_information_param_item_id4 N number
446 -- p_information_param_item_id5 N number
447 -- p_information_prompt N varchar2
448 -- p_insert_allowed N number
449 -- p_label N varchar2
450 -- p_prompt_text N varchar2
451 -- p_prompt_alignment_offset N number
452 -- p_prompt_display_style N number
453 -- p_prompt_edge N number
454 -- p_prompt_edge_alignment N number
455 -- p_prompt_edge_offset N number
456 -- p_prompt_text_alignment N number
457 -- p_query_allowed N number
458 -- p_required N number
459 -- p_tooltip_text N varchar2
460 -- p_update_allowed N number
461 -- p_validation_formula_id N number
462 -- p_validation_param_item_id1 N number
463 -- p_validation_param_item_id2 N number
464 -- p_validation_param_item_id3 N number
465 -- p_validation_param_item_id4 N number
466 -- p_validation_param_item_id5 N number
467 -- p_visible N number
468 -- p_width N number
469 -- p_x_position N number
470 -- p_y_position N number
471 -- p_information_category N varchar2
472 -- p_information1 N varchar2
473 -- p_information2 N varchar2
474 -- p_information3 N varchar2
475 -- p_information4 N varchar2
476 -- p_information5 N varchar2
477 -- p_information6 N varchar2
478 -- p_information7 N varchar2
479 -- p_information8 N varchar2
480 -- p_information9 N varchar2
481 -- p_information10 N varchar2
482 -- p_information11 N varchar2
483 -- p_information12 N varchar2
484 -- p_information13 N varchar2
485 -- p_information14 N varchar2
486 -- p_information15 N varchar2
487 -- p_information16 N varchar2
488 -- p_information17 N varchar2
489 -- p_information18 N varchar2
490 -- p_information19 N varchar2
491 -- p_information20 N varchar2
492 -- p_information21 N varchar2
493 -- p_information22 N varchar2
494 -- p_information23 N varchar2
495 -- p_information24 N varchar2
496 -- p_information25 N varchar2
497 -- p_information26 N varchar2
498 -- p_information27 N varchar2
499 -- p_information28 N varchar2
500 -- p_information29 N varchar2
501 -- p_information30 N varchar2
502 --
503 --
504 -- Post Success:
505 --
506 --
507 -- Name Type Description
508 -- p_item_property_id Number
509 -- p_override_value_warning Number
510 --
511 -- Post Failure:
512 --
513 --
514 -- Access Status:
515 -- Public.
516 --
517 -- {End Of Comments}
518 --
519 procedure copy_item_property
520 (p_validate in boolean default false
521 ,p_effective_date in date
522 ,p_language_code in varchar2 default hr_api.userenv_lang
523 ,p_form_item_id in number
524 ,p_template_item_id in number
525 ,p_alignment in number default hr_api.g_number
526 ,p_bevel in number default hr_api.g_number
527 ,p_case_restriction in number default hr_api.g_number
528 ,p_default_value in varchar2 default hr_api.g_varchar2
529 ,p_enabled in number default hr_api.g_number
530 ,p_format_mask in varchar2 default hr_api.g_varchar2
531 ,p_height in number default hr_api.g_number
532 ,p_information_formula_id in number default hr_api.g_number
533 ,p_information_param_item_id1 in number default hr_api.g_number
534 ,p_information_param_item_id2 in number default hr_api.g_number
535 ,p_information_param_item_id3 in number default hr_api.g_number
536 ,p_information_param_item_id4 in number default hr_api.g_number
537 ,p_information_param_item_id5 in number default hr_api.g_number
538 ,p_information_prompt in varchar2 default hr_api.g_varchar2
539 ,p_insert_allowed in number default hr_api.g_number
540 ,p_label in varchar2 default hr_api.g_varchar2
541 ,p_prompt_text in varchar2 default hr_api.g_varchar2
542 ,p_prompt_alignment_offset in number default hr_api.g_number
543 ,p_prompt_display_style in number default hr_api.g_number
544 ,p_prompt_edge in number default hr_api.g_number
545 ,p_prompt_edge_alignment in number default hr_api.g_number
546 ,p_prompt_edge_offset in number default hr_api.g_number
547 ,p_prompt_text_alignment in number default hr_api.g_number
548 ,p_query_allowed in number default hr_api.g_number
549 ,p_required in number default hr_api.g_number
550 ,p_tooltip_text in varchar2 default hr_api.g_varchar2
551 ,p_update_allowed in number default hr_api.g_number
552 ,p_validation_formula_id in number default hr_api.g_number
553 ,p_validation_param_item_id1 in number default hr_api.g_number
554 ,p_validation_param_item_id2 in number default hr_api.g_number
555 ,p_validation_param_item_id3 in number default hr_api.g_number
556 ,p_validation_param_item_id4 in number default hr_api.g_number
557 ,p_validation_param_item_id5 in number default hr_api.g_number
558 ,p_visible in number default hr_api.g_number
559 ,p_width in number default hr_api.g_number
560 ,p_x_position in number default hr_api.g_number
561 ,p_y_position in number default hr_api.g_number
562 ,p_information_category in varchar2 default hr_api.g_varchar2
563 ,p_information1 in varchar2 default hr_api.g_varchar2
564 ,p_information2 in varchar2 default hr_api.g_varchar2
565 ,p_information3 in varchar2 default hr_api.g_varchar2
566 ,p_information4 in varchar2 default hr_api.g_varchar2
567 ,p_information5 in varchar2 default hr_api.g_varchar2
568 ,p_information6 in varchar2 default hr_api.g_varchar2
569 ,p_information7 in varchar2 default hr_api.g_varchar2
570 ,p_information8 in varchar2 default hr_api.g_varchar2
571 ,p_information9 in varchar2 default hr_api.g_varchar2
572 ,p_information10 in varchar2 default hr_api.g_varchar2
573 ,p_information11 in varchar2 default hr_api.g_varchar2
574 ,p_information12 in varchar2 default hr_api.g_varchar2
575 ,p_information13 in varchar2 default hr_api.g_varchar2
576 ,p_information14 in varchar2 default hr_api.g_varchar2
577 ,p_information15 in varchar2 default hr_api.g_varchar2
578 ,p_information16 in varchar2 default hr_api.g_varchar2
579 ,p_information17 in varchar2 default hr_api.g_varchar2
580 ,p_information18 in varchar2 default hr_api.g_varchar2
581 ,p_information19 in varchar2 default hr_api.g_varchar2
582 ,p_information20 in varchar2 default hr_api.g_varchar2
583 ,p_information21 in varchar2 default hr_api.g_varchar2
584 ,p_information22 in varchar2 default hr_api.g_varchar2
585 ,p_information23 in varchar2 default hr_api.g_varchar2
586 ,p_information24 in varchar2 default hr_api.g_varchar2
587 ,p_information25 in varchar2 default hr_api.g_varchar2
588 ,p_information26 in varchar2 default hr_api.g_varchar2
589 ,p_information27 in varchar2 default hr_api.g_varchar2
590 ,p_information28 in varchar2 default hr_api.g_varchar2
591 ,p_information29 in varchar2 default hr_api.g_varchar2
592 ,p_information30 in varchar2 default hr_api.g_varchar2
593 ,p_next_navigation_item_id in number default hr_api.g_number
594 ,p_previous_navigation_item_id in number default hr_api.g_number
595 ,p_item_property_id out nocopy number
596 ,p_object_version_number out nocopy number
597 --,p_override_value_warning out boolean
598 );
599 --
600 --
601 -- ----------------------------------------------------------------------------
602 -- |----------------------< copy_item_property - overload 1>-------------------|
603 -- ----------------------------------------------------------------------------
604 -- {Start Of Comments}
605 --
606 -- Description: This business support process copies properties from a
607 -- template item to a template item context. Any property may
608 -- not be copied by specifying the value required in the
609 -- parameter list
610 --
611 -- Prerequisites:
612 --
613 --
614 -- In Parameters:
615 -- Name Reqd Type Description
616 -- p_language_code N varchar2
617 -- p_template_item_id Y number
618 -- p_template_item_context_id Y number
619 -- p_alignment N number
620 -- p_bevel N number
621 -- p_case_restriction N number
622 -- p_default_value N varchar2
623 -- p_enabled N number
624 -- p_format_mask N varchar2
625 -- p_height N number
626 -- p_information_formula_id N number
627 -- p_information_param_item_id1 N number
628 -- p_information_param_item_id2 N number
629 -- p_information_param_item_id3 N number
630 -- p_information_param_item_id4 N number
631 -- p_information_param_item_id5 N number
632 -- p_information_prompt N varchar2
633 -- p_insert_allowed N number
634 -- p_label N varchar2
635 -- p_prompt_text N varchar2
636 -- p_prompt_alignment_offset N number
637 -- p_prompt_display_style N number
638 -- p_prompt_edge N number
639 -- p_prompt_edge_alignment N number
640 -- p_prompt_edge_offset N number
641 -- p_prompt_text_alignment N number
642 -- p_query_allowed N number
643 -- p_required N number
644 -- p_tooltip_text N varchar2
645 -- p_update_allowed N number
646 -- p_validation_formula_id N number
647 -- p_validation_param_item_id1 N number
648 -- p_validation_param_item_id2 N number
649 -- p_validation_param_item_id3 N number
650 -- p_validation_param_item_id4 N number
651 -- p_validation_param_item_id5 N number
652 -- p_visible N number
653 -- p_width N number
654 -- p_x_position N number
655 -- p_y_position N number
656 -- p_information_category N varchar2
657 -- p_information1 N varchar2
658 -- p_information2 N varchar2
659 -- p_information3 N varchar2
660 -- p_information4 N varchar2
661 -- p_information5 N varchar2
662 -- p_information6 N varchar2
663 -- p_information7 N varchar2
664 -- p_information8 N varchar2
665 -- p_information9 N varchar2
666 -- p_information10 N varchar2
667 -- p_information11 N varchar2
668 -- p_information12 N varchar2
669 -- p_information13 N varchar2
670 -- p_information14 N varchar2
671 -- p_information15 N varchar2
672 -- p_information16 N varchar2
673 -- p_information17 N varchar2
674 -- p_information18 N varchar2
675 -- p_information19 N varchar2
676 -- p_information20 N varchar2
677 -- p_information21 N varchar2
678 -- p_information22 N varchar2
679 -- p_information23 N varchar2
680 -- p_information24 N varchar2
681 -- p_information25 N varchar2
682 -- p_information26 N varchar2
683 -- p_information27 N varchar2
684 -- p_information28 N varchar2
685 -- p_information29 N varchar2
686 -- p_information30 N varchar2
687 --
688 --
689 -- Post Success:
690 --
691 --
692 -- Name Type Description
693 -- p_item_property_id Number
694 -- p_override_value_warning Number
695 --
696 -- Post Failure:
697 --
698 --
699 -- Access Status:
700 -- Public.
701 --
702 -- {End Of Comments}
703 --
704 procedure copy_item_property
705 (p_validate in boolean default false
706 ,p_effective_date in date
707 ,p_language_code in varchar2 default hr_api.userenv_lang
708 ,p_template_item_id in number
709 ,p_template_item_context_id in number
710 ,p_alignment in number default hr_api.g_number
711 ,p_bevel in number default hr_api.g_number
712 ,p_case_restriction in number default hr_api.g_number
713 ,p_default_value in varchar2 default hr_api.g_varchar2
714 ,p_enabled in number default hr_api.g_number
715 ,p_format_mask in varchar2 default hr_api.g_varchar2
716 ,p_height in number default hr_api.g_number
717 ,p_information_formula_id in number default hr_api.g_number
718 ,p_information_param_item_id1 in number default hr_api.g_number
719 ,p_information_param_item_id2 in number default hr_api.g_number
720 ,p_information_param_item_id3 in number default hr_api.g_number
721 ,p_information_param_item_id4 in number default hr_api.g_number
722 ,p_information_param_item_id5 in number default hr_api.g_number
723 ,p_information_prompt in varchar2 default hr_api.g_varchar2
724 ,p_insert_allowed in number default hr_api.g_number
725 ,p_label in varchar2 default hr_api.g_varchar2
726 ,p_prompt_text in varchar2 default hr_api.g_varchar2
727 ,p_prompt_alignment_offset in number default hr_api.g_number
728 ,p_prompt_display_style in number default hr_api.g_number
729 ,p_prompt_edge in number default hr_api.g_number
730 ,p_prompt_edge_alignment in number default hr_api.g_number
731 ,p_prompt_edge_offset in number default hr_api.g_number
732 ,p_prompt_text_alignment in number default hr_api.g_number
733 ,p_query_allowed in number default hr_api.g_number
734 ,p_required in number default hr_api.g_number
735 ,p_tooltip_text in varchar2 default hr_api.g_varchar2
736 ,p_update_allowed in number default hr_api.g_number
737 ,p_validation_formula_id in number default hr_api.g_number
738 ,p_validation_param_item_id1 in number default hr_api.g_number
739 ,p_validation_param_item_id2 in number default hr_api.g_number
740 ,p_validation_param_item_id3 in number default hr_api.g_number
741 ,p_validation_param_item_id4 in number default hr_api.g_number
742 ,p_validation_param_item_id5 in number default hr_api.g_number
743 ,p_visible in number default hr_api.g_number
744 ,p_width in number default hr_api.g_number
745 ,p_x_position in number default hr_api.g_number
746 ,p_y_position in number default hr_api.g_number
747 ,p_information_category in varchar2 default hr_api.g_varchar2
748 ,p_information1 in varchar2 default hr_api.g_varchar2
749 ,p_information2 in varchar2 default hr_api.g_varchar2
750 ,p_information3 in varchar2 default hr_api.g_varchar2
751 ,p_information4 in varchar2 default hr_api.g_varchar2
752 ,p_information5 in varchar2 default hr_api.g_varchar2
753 ,p_information6 in varchar2 default hr_api.g_varchar2
754 ,p_information7 in varchar2 default hr_api.g_varchar2
755 ,p_information8 in varchar2 default hr_api.g_varchar2
756 ,p_information9 in varchar2 default hr_api.g_varchar2
757 ,p_information10 in varchar2 default hr_api.g_varchar2
758 ,p_information11 in varchar2 default hr_api.g_varchar2
759 ,p_information12 in varchar2 default hr_api.g_varchar2
760 ,p_information13 in varchar2 default hr_api.g_varchar2
761 ,p_information14 in varchar2 default hr_api.g_varchar2
762 ,p_information15 in varchar2 default hr_api.g_varchar2
763 ,p_information16 in varchar2 default hr_api.g_varchar2
764 ,p_information17 in varchar2 default hr_api.g_varchar2
765 ,p_information18 in varchar2 default hr_api.g_varchar2
766 ,p_information19 in varchar2 default hr_api.g_varchar2
767 ,p_information20 in varchar2 default hr_api.g_varchar2
768 ,p_information21 in varchar2 default hr_api.g_varchar2
769 ,p_information22 in varchar2 default hr_api.g_varchar2
770 ,p_information23 in varchar2 default hr_api.g_varchar2
771 ,p_information24 in varchar2 default hr_api.g_varchar2
772 ,p_information25 in varchar2 default hr_api.g_varchar2
773 ,p_information26 in varchar2 default hr_api.g_varchar2
774 ,p_information27 in varchar2 default hr_api.g_varchar2
775 ,p_information28 in varchar2 default hr_api.g_varchar2
776 ,p_information29 in varchar2 default hr_api.g_varchar2
777 ,p_information30 in varchar2 default hr_api.g_varchar2
778 ,p_next_navigation_item_id in number default hr_api.g_number
779 ,p_previous_navigation_item_id in number default hr_api.g_number
780 ,p_item_property_id out nocopy number
781 ,p_object_version_number out nocopy number
782 --,p_override_value_warning out boolean
783 );
784 --
785 --
786 -- ----------------------------------------------------------------------------
787 -- |------------------< copy_item_property overload -2 >----------------------|
788 -- ----------------------------------------------------------------------------
789 -- {Start Of Comments}
790 --
791 -- Description: This business support process copies properties from a
792 -- template item to another template item. Any property may not
793 -- be copied by specifying the value required in the parameter
794 -- list.
795 --
796 -- Prerequisites:
797 --
798 --
799 -- In Parameters:
800 -- Name Reqd Type Description
801 -- p_language_code N varchar2
802 -- p_template_item_id_from Y number
803 -- p_template_item_id_to Y number
804 -- p_alignment N number
805 -- p_bevel N number
806 -- p_case_restriction N number
807 -- p_default_value N varchar2
808 -- p_enabled N number
809 -- p_format_mask N varchar2
810 -- p_height N number
811 -- p_information_formula_id N number
812 -- p_information_param_item_id1 N number
813 -- p_information_param_item_id2 N number
814 -- p_information_param_item_id3 N number
815 -- p_information_param_item_id4 N number
816 -- p_information_param_item_id5 N number
817 -- p_information_prompt N varchar2
818 -- p_insert_allowed N number
819 -- p_label N varchar2
820 -- p_prompt_text N varchar2
821 -- p_prompt_alignment_offset N number
822 -- p_prompt_display_style N number
823 -- p_prompt_edge N number
824 -- p_prompt_edge_alignment N number
825 -- p_prompt_edge_offset N number
826 -- p_prompt_text_alignment N number
827 -- p_query_allowed N number
828 -- p_required N number
829 -- p_tooltip_text N varchar2
830 -- p_update_allowed N number
831 -- p_validation_formula_id N number
832 -- p_validation_param_item_id1 N number
833 -- p_validation_param_item_id2 N number
834 -- p_validation_param_item_id3 N number
835 -- p_validation_param_item_id4 N number
836 -- p_validation_param_item_id5 N number
837 -- p_visible N number
838 -- p_width N number
839 -- p_x_position N number
840 -- p_y_position N number
841 -- p_information_category N varchar2
842 -- p_information1 N varchar2
843 -- p_information2 N varchar2
844 -- p_information3 N varchar2
845 -- p_information4 N varchar2
846 -- p_information5 N varchar2
847 -- p_information6 N varchar2
848 -- p_information7 N varchar2
849 -- p_information8 N varchar2
850 -- p_information9 N varchar2
851 -- p_information10 N varchar2
852 -- p_information11 N varchar2
853 -- p_information12 N varchar2
854 -- p_information13 N varchar2
855 -- p_information14 N varchar2
856 -- p_information15 N varchar2
857 -- p_information16 N varchar2
858 -- p_information17 N varchar2
859 -- p_information18 N varchar2
860 -- p_information19 N varchar2
861 -- p_information20 N varchar2
862 -- p_information21 N varchar2
863 -- p_information22 N varchar2
864 -- p_information23 N varchar2
865 -- p_information24 N varchar2
866 -- p_information25 N varchar2
867 -- p_information26 N varchar2
868 -- p_information27 N varchar2
869 -- p_information28 N varchar2
870 -- p_information29 N varchar2
871 -- p_information30 N varchar2
872 --
873 --
874 -- Post Success:
875 --
876 --
877 -- Name Type Description
878 -- p_item_property_id Number
879 -- p_override_value_warning Number
880 --
881 -- Post Failure:
882 --
883 --
884 -- Access Status:
885 -- Public.
886 --
887 -- {End Of Comments}
888 --
889 procedure copy_item_property
890 (p_validate in boolean default false
891 ,p_effective_date in date
892 ,p_language_code in varchar2 default hr_api.userenv_lang
893 ,p_template_item_id_from in number
894 ,p_template_item_id_to in number
895 ,p_alignment in number default hr_api.g_number
896 ,p_bevel in number default hr_api.g_number
897 ,p_case_restriction in number default hr_api.g_number
898 ,p_default_value in varchar2 default hr_api.g_varchar2
899 ,p_enabled in number default hr_api.g_number
900 ,p_format_mask in varchar2 default hr_api.g_varchar2
901 ,p_height in number default hr_api.g_number
902 ,p_information_formula_id in number default hr_api.g_number
903 ,p_information_param_item_id1 in number default hr_api.g_number
904 ,p_information_param_item_id2 in number default hr_api.g_number
905 ,p_information_param_item_id3 in number default hr_api.g_number
906 ,p_information_param_item_id4 in number default hr_api.g_number
907 ,p_information_param_item_id5 in number default hr_api.g_number
908 ,p_information_prompt in varchar2 default hr_api.g_varchar2
909 ,p_insert_allowed in number default hr_api.g_number
910 ,p_label in varchar2 default hr_api.g_varchar2
911 ,p_prompt_text in varchar2 default hr_api.g_varchar2
912 ,p_prompt_alignment_offset in number default hr_api.g_number
913 ,p_prompt_display_style in number default hr_api.g_number
914 ,p_prompt_edge in number default hr_api.g_number
915 ,p_prompt_edge_alignment in number default hr_api.g_number
916 ,p_prompt_edge_offset in number default hr_api.g_number
917 ,p_prompt_text_alignment in number default hr_api.g_number
918 ,p_query_allowed in number default hr_api.g_number
919 ,p_required in number default hr_api.g_number
920 ,p_tooltip_text in varchar2 default hr_api.g_varchar2
921 ,p_update_allowed in number default hr_api.g_number
922 ,p_validation_formula_id in number default hr_api.g_number
923 ,p_validation_param_item_id1 in number default hr_api.g_number
924 ,p_validation_param_item_id2 in number default hr_api.g_number
925 ,p_validation_param_item_id3 in number default hr_api.g_number
926 ,p_validation_param_item_id4 in number default hr_api.g_number
927 ,p_validation_param_item_id5 in number default hr_api.g_number
928 ,p_visible in number default hr_api.g_number
929 ,p_width in number default hr_api.g_number
930 ,p_x_position in number default hr_api.g_number
931 ,p_y_position in number default hr_api.g_number
932 ,p_information_category in varchar2 default hr_api.g_varchar2
933 ,p_information1 in varchar2 default hr_api.g_varchar2
934 ,p_information2 in varchar2 default hr_api.g_varchar2
935 ,p_information3 in varchar2 default hr_api.g_varchar2
936 ,p_information4 in varchar2 default hr_api.g_varchar2
937 ,p_information5 in varchar2 default hr_api.g_varchar2
938 ,p_information6 in varchar2 default hr_api.g_varchar2
939 ,p_information7 in varchar2 default hr_api.g_varchar2
940 ,p_information8 in varchar2 default hr_api.g_varchar2
941 ,p_information9 in varchar2 default hr_api.g_varchar2
942 ,p_information10 in varchar2 default hr_api.g_varchar2
943 ,p_information11 in varchar2 default hr_api.g_varchar2
944 ,p_information12 in varchar2 default hr_api.g_varchar2
945 ,p_information13 in varchar2 default hr_api.g_varchar2
946 ,p_information14 in varchar2 default hr_api.g_varchar2
947 ,p_information15 in varchar2 default hr_api.g_varchar2
948 ,p_information16 in varchar2 default hr_api.g_varchar2
949 ,p_information17 in varchar2 default hr_api.g_varchar2
950 ,p_information18 in varchar2 default hr_api.g_varchar2
951 ,p_information19 in varchar2 default hr_api.g_varchar2
952 ,p_information20 in varchar2 default hr_api.g_varchar2
953 ,p_information21 in varchar2 default hr_api.g_varchar2
954 ,p_information22 in varchar2 default hr_api.g_varchar2
955 ,p_information23 in varchar2 default hr_api.g_varchar2
956 ,p_information24 in varchar2 default hr_api.g_varchar2
957 ,p_information25 in varchar2 default hr_api.g_varchar2
958 ,p_information26 in varchar2 default hr_api.g_varchar2
959 ,p_information27 in varchar2 default hr_api.g_varchar2
960 ,p_information28 in varchar2 default hr_api.g_varchar2
961 ,p_information29 in varchar2 default hr_api.g_varchar2
962 ,p_information30 in varchar2 default hr_api.g_varchar2
963 ,p_next_navigation_item_id in number default hr_api.g_number
964 ,p_previous_navigation_item_id in number default hr_api.g_number
965 ,p_item_property_id out nocopy number
966 ,p_object_version_number out nocopy number
967 --,p_override_value_warning out boolean
968 );
969 --
970 --
971 -- ----------------------------------------------------------------------------
972 -- |--------------------< copy_item_property overload 3 >---------------------|
973 -- ----------------------------------------------------------------------------
974 -- {Start Of Comments}
975 --
976 -- Description: This business support process copies properties from a
977 -- template item context to another template item context.
978 -- Any property may not be copied by specifying the value
979 -- required in the parameter list.
980 --
981 -- Prerequisites:
982 --
983 --
984 -- In Parameters:
985 -- Name Reqd Type Description
986 -- p_language_code N varchar2
987 -- p_template_item_context_id_from Y number
988 -- p_template_item_context_id_to Y number
989 -- p_alignment N number
990 -- p_bevel N number
991 -- p_case_restriction N number
992 -- p_default_value N varchar2
993 -- p_enabled N number
994 -- p_format_mask N varchar2
995 -- p_height N number
996 -- p_information_formula_id N number
997 -- p_information_param_item_id1 N number
998 -- p_information_param_item_id2 N number
999 -- p_information_param_item_id3 N number
1000 -- p_information_param_item_id4 N number
1001 -- p_information_param_item_id5 N number
1002 -- p_information_prompt N varchar2
1003 -- p_insert_allowed N number
1004 -- p_label N varchar2
1005 -- p_prompt_text N varchar2
1006 -- p_prompt_alignment_offset N number
1007 -- p_prompt_display_style N number
1008 -- p_prompt_edge N number
1009 -- p_prompt_edge_alignment N number
1010 -- p_prompt_edge_offset N number
1011 -- p_prompt_text_alignment N number
1012 -- p_query_allowed N number
1013 -- p_required N number
1014 -- p_tooltip_text N varchar2
1015 -- p_update_allowed N number
1016 -- p_validation_formula_id N number
1017 -- p_validation_param_item_id2 N number
1018 -- p_validation_param_item_id3 N number
1019 -- p_validation_param_item_id4 N number
1020 -- p_validation_param_item_id5 N number
1021 -- p_validation_param_item_id6 N number
1022 -- p_visible N number
1023 -- p_width N number
1024 -- p_x_position N number
1025 -- p_y_position N number
1026 -- p_information_category N varchar2
1027 -- p_information1 N varchar2
1028 -- p_information2 N varchar2
1029 -- p_information3 N varchar2
1030 -- p_information4 N varchar2
1031 -- p_information5 N varchar2
1032 -- p_information6 N varchar2
1033 -- p_information7 N varchar2
1034 -- p_information8 N varchar2
1035 -- p_information9 N varchar2
1036 -- p_information10 N varchar2
1037 -- p_information11 N varchar2
1038 -- p_information12 N varchar2
1039 -- p_information13 N varchar2
1040 -- p_information14 N varchar2
1041 -- p_information15 N varchar2
1042 -- p_information16 N varchar2
1043 -- p_information17 N varchar2
1044 -- p_information18 N varchar2
1045 -- p_information19 N varchar2
1046 -- p_information20 N varchar2
1047 -- p_information21 N varchar2
1048 -- p_information22 N varchar2
1049 -- p_information23 N varchar2
1050 -- p_information24 N varchar2
1051 -- p_information25 N varchar2
1052 -- p_information26 N varchar2
1053 -- p_information27 N varchar2
1054 -- p_information28 N varchar2
1055 -- p_information29 N varchar2
1056 -- p_information30 N varchar2
1057 --
1058 -- Post Success:
1059 --
1060 -- Name Type Description
1061 -- p_item_property_id Number
1062 -- p_override_value_warning Number
1063 --
1064 -- Post Failure:
1065 --
1066 --
1067 -- Access Status:
1068 -- Public.
1069 --
1070 -- {End Of Comments}
1071 --
1072 procedure copy_item_property
1073 (p_validate in boolean default false
1074 ,p_effective_date in date
1075 ,p_language_code in varchar2 default hr_api.userenv_lang
1076 ,p_template_item_context_id_frm in number
1077 ,p_template_item_context_id_to in number
1078 ,p_alignment in number default hr_api.g_number
1079 ,p_bevel in number default hr_api.g_number
1080 ,p_case_restriction in number default hr_api.g_number
1081 ,p_default_value in varchar2 default hr_api.g_varchar2
1082 ,p_enabled in number default hr_api.g_number
1083 ,p_format_mask in varchar2 default hr_api.g_varchar2
1084 ,p_height in number default hr_api.g_number
1085 ,p_information_formula_id in number default hr_api.g_number
1086 ,p_information_param_item_id1 in number default hr_api.g_number
1087 ,p_information_param_item_id2 in number default hr_api.g_number
1088 ,p_information_param_item_id3 in number default hr_api.g_number
1089 ,p_information_param_item_id4 in number default hr_api.g_number
1090 ,p_information_param_item_id5 in number default hr_api.g_number
1091 ,p_information_prompt in varchar2 default hr_api.g_varchar2
1092 ,p_insert_allowed in number default hr_api.g_number
1093 ,p_label in varchar2 default hr_api.g_varchar2
1094 ,p_prompt_text in varchar2 default hr_api.g_varchar2
1095 ,p_prompt_alignment_offset in number default hr_api.g_number
1096 ,p_prompt_display_style in number default hr_api.g_number
1097 ,p_prompt_edge in number default hr_api.g_number
1098 ,p_prompt_edge_alignment in number default hr_api.g_number
1099 ,p_prompt_edge_offset in number default hr_api.g_number
1100 ,p_prompt_text_alignment in number default hr_api.g_number
1101 ,p_query_allowed in number default hr_api.g_number
1102 ,p_required in number default hr_api.g_number
1103 ,p_tooltip_text in varchar2 default hr_api.g_varchar2
1104 ,p_update_allowed in number default hr_api.g_number
1105 ,p_validation_formula_id in number default hr_api.g_number
1106 ,p_validation_param_item_id1 in number default hr_api.g_number
1107 ,p_validation_param_item_id2 in number default hr_api.g_number
1108 ,p_validation_param_item_id3 in number default hr_api.g_number
1109 ,p_validation_param_item_id4 in number default hr_api.g_number
1110 ,p_validation_param_item_id5 in number default hr_api.g_number
1111 ,p_visible in number default hr_api.g_number
1112 ,p_width in number default hr_api.g_number
1113 ,p_x_position in number default hr_api.g_number
1114 ,p_y_position in number default hr_api.g_number
1115 ,p_information_category in varchar2 default hr_api.g_varchar2
1116 ,p_information1 in varchar2 default hr_api.g_varchar2
1117 ,p_information2 in varchar2 default hr_api.g_varchar2
1118 ,p_information3 in varchar2 default hr_api.g_varchar2
1119 ,p_information4 in varchar2 default hr_api.g_varchar2
1120 ,p_information5 in varchar2 default hr_api.g_varchar2
1121 ,p_information6 in varchar2 default hr_api.g_varchar2
1122 ,p_information7 in varchar2 default hr_api.g_varchar2
1123 ,p_information8 in varchar2 default hr_api.g_varchar2
1124 ,p_information9 in varchar2 default hr_api.g_varchar2
1125 ,p_information10 in varchar2 default hr_api.g_varchar2
1126 ,p_information11 in varchar2 default hr_api.g_varchar2
1127 ,p_information12 in varchar2 default hr_api.g_varchar2
1128 ,p_information13 in varchar2 default hr_api.g_varchar2
1129 ,p_information14 in varchar2 default hr_api.g_varchar2
1130 ,p_information15 in varchar2 default hr_api.g_varchar2
1131 ,p_information16 in varchar2 default hr_api.g_varchar2
1132 ,p_information17 in varchar2 default hr_api.g_varchar2
1133 ,p_information18 in varchar2 default hr_api.g_varchar2
1134 ,p_information19 in varchar2 default hr_api.g_varchar2
1135 ,p_information20 in varchar2 default hr_api.g_varchar2
1136 ,p_information21 in varchar2 default hr_api.g_varchar2
1137 ,p_information22 in varchar2 default hr_api.g_varchar2
1138 ,p_information23 in varchar2 default hr_api.g_varchar2
1139 ,p_information24 in varchar2 default hr_api.g_varchar2
1140 ,p_information25 in varchar2 default hr_api.g_varchar2
1141 ,p_information26 in varchar2 default hr_api.g_varchar2
1142 ,p_information27 in varchar2 default hr_api.g_varchar2
1143 ,p_information28 in varchar2 default hr_api.g_varchar2
1144 ,p_information29 in varchar2 default hr_api.g_varchar2
1145 ,p_information30 in varchar2 default hr_api.g_varchar2
1146 ,p_next_navigation_item_id in number default hr_api.g_number
1147 ,p_previous_navigation_item_id in number default hr_api.g_number
1148 ,p_item_property_id out nocopy number
1149 ,p_object_version_number out nocopy number
1150 --,p_override_value_warning out boolean
1151 );
1152 --
1153 end hr_item_properties_bsi;