[Home] [Help]
PACKAGE BODY: APPS.HR_ITEM_PROPERTIES_BSI
Source
1 Package Body hr_item_properties_bsi as
2 /* $Header: hritpbsi.pkb 120.0 2005/05/31 00:59:30 appldev noship $ */
3 --
4 -- Package Variables
5 --
6 g_package varchar2(33) := ' hr_item_properties_bsi.';
7 --
8 -- ----------------------------------------------------------------------------
9 PROCEDURE update_radio_button_property
10 (p_effective_date IN DATE
11 ,p_language_code IN VARCHAR2
12 ,p_form_item_id IN NUMBER
13 ,p_template_item_id IN NUMBER
14 ,p_template_item_context_id IN NUMBER
15 ,p_default_value IN VARCHAR2
16 ,p_information_formula_id IN NUMBER
17 ,p_information_param_item_id1 IN NUMBER
18 ,p_information_param_item_id2 IN NUMBER
19 ,p_information_param_item_id3 IN NUMBER
20 ,p_information_param_item_id4 IN NUMBER
21 ,p_information_param_item_id5 IN NUMBER
22 ,p_information_prompt IN VARCHAR2
23 ,p_insert_allowed IN NUMBER
24 ,p_next_navigation_item_id IN NUMBER
25 ,p_previous_navigation_item_id IN NUMBER
26 ,p_query_allowed IN NUMBER
27 ,p_tooltip_text IN VARCHAR2
28 ,p_update_allowed IN NUMBER
29 ,p_validation_formula_id IN NUMBER
30 ,p_validation_param_item_id1 IN NUMBER
31 ,p_validation_param_item_id2 IN NUMBER
32 ,p_validation_param_item_id3 IN NUMBER
33 ,p_validation_param_item_id4 IN NUMBER
34 ,p_validation_param_item_id5 IN NUMBER
35 ,p_object_version_number in out nocopy number
36 )
37 IS
38 CURSOR csr_form_items
39 (p_form_item_id IN NUMBER
40 )
41 IS
42 SELECT itp.item_property_id
43 FROM hr_item_properties_b itp
44 ,hr_form_items_b fi2
45 ,hr_form_items_b fi1
46 WHERE itp.form_item_id = fi2.form_item_id
47 AND fi2.application_id = fi1.application_id
48 AND fi2.form_id = fi1.form_id
49 AND fi2.full_item_name = fi1.full_item_name
50 AND fi2.form_item_id <> fi1.form_item_id
51 AND fi1.item_type = 'RADIO_BUTTON'
52 AND fi1.form_item_id = p_form_item_id;
53 CURSOR csr_template_items
54 (p_template_item_id IN NUMBER
55 )
56 IS
57 SELECT itp.item_property_id
58 FROM hr_item_properties_b itp
59 ,hr_template_items_b ti2
60 ,hr_form_items_b fi2
61 ,hr_form_items_b fi1
62 ,hr_template_items_b ti1
63 WHERE itp.template_item_id = ti2.template_item_id
64 AND ti2.form_template_id = ti1.form_template_id
65 AND ti2.form_item_id = fi2.form_item_id
66 AND fi2.application_id = fi1.application_id
67 AND fi2.form_id = fi1.form_id
68 AND fi2.full_item_name = fi1.full_item_name
69 AND fi2.form_item_id <> fi1.form_item_id
70 AND fi1.item_type = 'RADIO_BUTTON'
71 AND fi1.form_item_id = ti1.form_item_id
72 AND ti1.template_item_id = p_template_item_id;
73 CURSOR csr_template_item_contexts
74 (p_template_item_context_id IN NUMBER
75 )
76 IS
77 SELECT itp.item_property_id
78 FROM hr_item_properties_b itp
79 ,hr_template_item_contexts_b tc2
80 ,hr_template_items_b ti2
81 ,hr_form_items_b fi2
82 ,hr_form_items_b fi1
83 ,hr_template_items_b ti1
84 ,hr_template_item_contexts_b tc1
85 WHERE itp.template_item_context_id = tc2.template_item_context_id
86 AND tc2.item_context_id = tc1.item_context_id
87 AND tc2.template_item_id = ti2.template_item_id
88 AND ti2.form_template_id = ti1.form_template_id
89 AND ti2.form_item_id = fi2.form_item_id
90 AND fi2.application_id = fi1.application_id
91 AND fi2.form_id = fi1.form_id
92 AND fi2.full_item_name = fi1.full_item_name
93 AND fi2.form_item_id <> fi1.form_item_id
94 AND fi1.item_type = 'RADIO_BUTTON'
95 AND fi1.form_item_id = ti1.form_item_id
96 AND ti1.template_item_id = tc1.template_item_id
97 AND tc1.template_item_context_id = p_template_item_context_id;
98 PROCEDURE update_radio_button_property_i
99 (p_item_property_id IN NUMBER
100 )
101 IS
102 BEGIN
103 hr_itp_upd.upd
104 (p_effective_date => p_effective_date
105 ,p_item_property_id => p_item_property_id
106 ,p_object_version_number => p_object_version_number
107 ,p_information_formula_id => p_information_formula_id
108 ,p_information_param_item_id1 => p_information_param_item_id1
109 ,p_information_param_item_id2 => p_information_param_item_id2
110 ,p_information_param_item_id3 => p_information_param_item_id3
111 ,p_information_param_item_id4 => p_information_param_item_id4
112 ,p_information_param_item_id5 => p_information_param_item_id5
113 ,p_insert_allowed => p_insert_allowed
114 ,p_next_navigation_item_id => p_next_navigation_item_id
115 ,p_previous_navigation_item_id => p_previous_navigation_item_id
116 ,p_query_allowed => p_query_allowed
117 ,p_update_allowed => p_update_allowed
118 ,p_validation_formula_id => p_validation_formula_id
119 ,p_validation_param_item_id1 => p_validation_param_item_id1
120 ,p_validation_param_item_id2 => p_validation_param_item_id2
121 ,p_validation_param_item_id3 => p_validation_param_item_id3
122 ,p_validation_param_item_id4 => p_validation_param_item_id4
123 ,p_validation_param_item_id5 => p_validation_param_item_id5
124 );
125 hr_ipt_upd.upd_tl
126 (p_language_code => p_language_code
127 ,p_default_value => p_default_value
128 ,p_item_property_id => p_item_property_id
129 ,p_information_prompt => p_information_prompt
130 ,p_tooltip_text => p_tooltip_text
131 );
132 END update_radio_button_property_i;
133 BEGIN
134 IF (p_form_item_id IS NOT NULL)
135 THEN
136 FOR l_item_property IN csr_form_items(p_form_item_id)
137 LOOP
138 update_radio_button_property_i(l_item_property.item_property_id);
139 END LOOP;
140 ELSIF (p_template_item_id IS NOT NULL)
141 THEN
142 FOR l_item_property IN csr_template_items(p_template_item_id)
143 LOOP
144 update_radio_button_property_i(l_item_property.item_property_id);
145 END LOOP;
146 ELSIF (p_template_item_context_id IS NOT NULL)
147 THEN
148 FOR l_item_property IN csr_template_item_contexts(p_template_item_context_id)
149 LOOP
150 update_radio_button_property_i(l_item_property.item_property_id);
151 END LOOP;
152 END IF;
153 END update_radio_button_property;
154 --
155 -- ----------------------------------------------------------------------------
156 -- |--------------------------< create_item_property >------------------------|
157 -- ----------------------------------------------------------------------------
158 --
159 procedure create_item_property
160 (p_validate in boolean default false
161 ,p_effective_date in date
162 ,p_language_code in varchar2 default hr_api.userenv_lang
163 ,p_form_item_id in number default null
164 ,p_template_item_id in number default null
165 ,p_template_item_context_id in number default null
166 ,p_alignment in number default null
167 ,p_bevel in number default null
168 ,p_case_restriction in number default null
169 ,p_default_value in varchar2 default null
170 ,p_enabled in number default null
171 ,p_format_mask in varchar2 default null
172 ,p_height in number default null
173 ,p_information_formula_id in number default null
174 ,p_information_param_item_id1 in number default null
175 ,p_information_param_item_id2 in number default null
176 ,p_information_param_item_id3 in number default null
177 ,p_information_param_item_id4 in number default null
178 ,p_information_param_item_id5 in number default null
179 ,p_information_prompt in varchar2 default null
180 ,p_insert_allowed in number default null
181 ,p_label in varchar2 default null
182 ,p_prompt_text in varchar2 default null
183 ,p_prompt_alignment_offset in number default null
184 ,p_prompt_display_style in number default null
185 ,p_prompt_edge in number default null
186 ,p_prompt_edge_alignment in number default null
187 ,p_prompt_edge_offset in number default null
188 ,p_prompt_text_alignment in number default null
189 ,p_query_allowed in number default null
190 ,p_required in number default null
191 ,p_tooltip_text in varchar2 default null
192 ,p_update_allowed in number default null
193 ,p_validation_formula_id in number default null
194 ,p_validation_param_item_id1 in number default null
195 ,p_validation_param_item_id2 in number default null
196 ,p_validation_param_item_id3 in number default null
197 ,p_validation_param_item_id4 in number default null
198 ,p_validation_param_item_id5 in number default null
199 ,p_visible in number default null
200 ,p_width in number default null
201 ,p_x_position in number default null
202 ,p_y_position in number default null
203 ,p_information_category in varchar2 default null
204 ,p_information1 in varchar2 default null
205 ,p_information2 in varchar2 default null
206 ,p_information3 in varchar2 default null
207 ,p_information4 in varchar2 default null
208 ,p_information5 in varchar2 default null
209 ,p_information6 in varchar2 default null
210 ,p_information7 in varchar2 default null
211 ,p_information8 in varchar2 default null
212 ,p_information9 in varchar2 default null
213 ,p_information10 in varchar2 default null
214 ,p_information11 in varchar2 default null
215 ,p_information12 in varchar2 default null
216 ,p_information13 in varchar2 default null
217 ,p_information14 in varchar2 default null
218 ,p_information15 in varchar2 default null
219 ,p_information16 in varchar2 default null
220 ,p_information17 in varchar2 default null
221 ,p_information18 in varchar2 default null
222 ,p_information19 in varchar2 default null
223 ,p_information20 in varchar2 default null
224 ,p_information21 in varchar2 default null
225 ,p_information22 in varchar2 default null
226 ,p_information23 in varchar2 default null
227 ,p_information24 in varchar2 default null
228 ,p_information25 in varchar2 default null
229 ,p_information26 in varchar2 default null
230 ,p_information27 in varchar2 default null
231 ,p_information28 in varchar2 default null
232 ,p_information29 in varchar2 default null
233 ,p_information30 in varchar2 default null
234 ,p_next_navigation_item_id in number default null
235 ,p_previous_navigation_item_id in number default null
236 ,p_item_property_id out nocopy number
237 ,p_object_version_number out nocopy number
238 --,p_override_value_warning out boolean
239 ) is
240 --
241 -- Declare cursors and local variables
242 --
243
244 l_language_code fnd_languages.language_code%TYPE;
245
246 l_item_property_id number;
247 l_object_version_number number;
248 l_override_value_warning boolean;
249 l_proc varchar2(72) := g_package||'create_item_property';
250 begin
251 hr_utility.set_location('Entering:'|| l_proc, 10);
252 --
253 -- Issue a savepoint
254 --
255 savepoint create_item_property;
256 --
257 -- Truncate the time portion from all IN date parameters
258 --
259 -- p_effective_date := TRUNC(p_effective_date);
260 --
261 -- Validate the language parameter. l_language_code should be passed
262 -- instead of p_language_code from now on, to allow an IN OUT parameter to
263 -- be passed through.
264 --
265 l_language_code := p_language_code;
266 hr_api.validate_language_code(p_language_code => l_language_code);
267 --
268 hr_utility.set_location(l_proc, 20);
269 --
270 --
271 -- Process Logic
272 --
273 hr_itp_ins.ins(p_effective_date => TRUNC(p_effective_date)
274 ,p_form_item_id => p_form_item_id
275 ,p_template_item_id => p_template_item_id
276 ,p_template_item_context_id => p_template_item_context_id
277 ,p_alignment => p_alignment
278 ,p_bevel => p_bevel
279 ,p_case_restriction => p_case_restriction
280 ,p_enabled => p_enabled
281 ,p_format_mask => p_format_mask
282 ,p_height => p_height
283 ,p_information_formula_id => p_information_formula_id
284 ,p_information_param_item_id1 => p_information_param_item_id1
285 ,p_information_param_item_id2 => p_information_param_item_id2
286 ,p_information_param_item_id3 => p_information_param_item_id3
287 ,p_information_param_item_id4 => p_information_param_item_id4
288 ,p_information_param_item_id5 => p_information_param_item_id5
289 ,p_insert_allowed => p_insert_allowed
290 ,p_prompt_alignment_offset => p_prompt_alignment_offset
291 ,p_prompt_display_style => p_prompt_display_style
292 ,p_prompt_edge => p_prompt_edge
293 ,p_prompt_edge_alignment => p_prompt_edge_alignment
294 ,p_prompt_edge_offset => p_prompt_edge_offset
295 ,p_prompt_text_alignment => p_prompt_text_alignment
296 ,p_query_allowed => p_query_allowed
297 ,p_required => p_required
298 ,p_update_allowed => p_update_allowed
299 ,p_validation_formula_id => p_validation_formula_id
300 ,p_validation_param_item_id1 => p_validation_param_item_id1
301 ,p_validation_param_item_id2 => p_validation_param_item_id2
302 ,p_validation_param_item_id3 => p_validation_param_item_id3
303 ,p_validation_param_item_id4 => p_validation_param_item_id4
304 ,p_validation_param_item_id5 => p_validation_param_item_id5
305 ,p_visible => p_visible
306 ,p_width => p_width
307 ,p_x_position => p_x_position
308 ,p_y_position => p_y_position
309 ,p_information_category => p_information_category
310 ,p_information1 => p_information1
311 ,p_information2 => p_information2
312 ,p_information3 => p_information3
313 ,p_information4 => p_information4
314 ,p_information5 => p_information5
315 ,p_information6 => p_information6
316 ,p_information7 => p_information7
317 ,p_information8 => p_information8
318 ,p_information9 => p_information9
319 ,p_information10 => p_information10
320 ,p_information11 => p_information11
321 ,p_information12 => p_information12
322 ,p_information13 => p_information13
323 ,p_information14 => p_information14
324 ,p_information15 => p_information15
325 ,p_information16 => p_information16
326 ,p_information17 => p_information17
327 ,p_information18 => p_information18
328 ,p_information19 => p_information19
329 ,p_information20 => p_information20
330 ,p_information21 => p_information21
331 ,p_information22 => p_information22
332 ,p_information23 => p_information23
333 ,p_information24 => p_information24
334 ,p_information25 => p_information25
335 ,p_information26 => p_information26
336 ,p_information27 => p_information27
337 ,p_information28 => p_information28
338 ,p_information29 => p_information29
339 ,p_information30 => p_information30
340 ,p_next_navigation_item_id => p_next_navigation_item_id
341 ,p_previous_navigation_item_id => p_previous_navigation_item_id
342 ,p_item_property_id => l_item_property_id
343 ,p_object_version_number => l_object_version_number);
344 -- ,p_override_value_warning => l_override_value_warning);
345
346 hr_ipt_ins.ins_tl(p_language_code => l_language_code
347 ,p_item_property_id => l_item_property_id
348 ,p_default_value => p_default_value
349 ,p_information_prompt => p_information_prompt
350 ,p_label => p_label
351 ,p_prompt_text => p_prompt_text
352 ,p_tooltip_text => p_tooltip_text);
353 --
354 -- Update properties common across all buttons of a radio group
355 --
356 update_radio_button_property
357 (p_effective_date => TRUNC(p_effective_date)
358 ,p_language_code => l_language_code
359 ,p_form_item_id => p_form_item_id
360 ,p_template_item_id => p_template_item_id
361 ,p_template_item_context_id => p_template_item_context_id
362 ,p_default_value => p_default_value
363 ,p_information_formula_id => p_information_formula_id
364 ,p_information_param_item_id1 => p_information_param_item_id1
365 ,p_information_param_item_id2 => p_information_param_item_id2
366 ,p_information_param_item_id3 => p_information_param_item_id3
367 ,p_information_param_item_id4 => p_information_param_item_id4
368 ,p_information_param_item_id5 => p_information_param_item_id5
369 ,p_information_prompt => p_information_prompt
370 ,p_insert_allowed => p_insert_allowed
371 ,p_next_navigation_item_id => p_next_navigation_item_id
372 ,p_previous_navigation_item_id => p_previous_navigation_item_id
373 ,p_query_allowed => p_query_allowed
374 ,p_tooltip_text => p_tooltip_text
375 ,p_update_allowed => p_update_allowed
376 ,p_validation_formula_id => p_validation_formula_id
377 ,p_validation_param_item_id1 => p_validation_param_item_id1
378 ,p_validation_param_item_id2 => p_validation_param_item_id2
379 ,p_validation_param_item_id3 => p_validation_param_item_id3
380 ,p_validation_param_item_id4 => p_validation_param_item_id4
381 ,p_validation_param_item_id5 => p_validation_param_item_id5
382 ,p_object_version_number => l_object_version_number
383 );
384 --
385 -- When in validation only mode raise the Validate_Enabled exception
386 --
387 if p_validate then
388 raise hr_api.validate_enabled;
389 end if;
390 --
391 -- Set all output arguments
392 --
393 p_item_property_id := l_item_property_id;
394 p_object_version_number := l_object_version_number;
395 --p_override_value_warning := l_override_value_warning;
396 --
397 hr_utility.set_location(' Leaving:'||l_proc, 70);
398 exception
399 when hr_api.validate_enabled then
400 --
401 -- As the Validate_Enabled exception has been raised
402 -- we must rollback to the savepoint
403 --
404 rollback to create_item_property;
405 --
406 -- Only set output warning arguments
407 -- (Any key or derived arguments must be set to null
408 -- when validation only mode is being used.)
409 --
410 p_item_property_id := null;
411 --p_override_value_warning := null;
412 hr_utility.set_location(' Leaving:'||l_proc, 80);
413 when others then
414 --
415 -- A validation or unexpected error has occured
416 --
417 rollback to create_item_property;
418 hr_utility.set_location(' Leaving:'||l_proc, 90);
419 raise;
420 end create_item_property;
421 --
422 --
423 -- ----------------------------------------------------------------------------
424 -- |--------------------------< update_item_property >------------------------|
425 -- ----------------------------------------------------------------------------
426 --
427 procedure update_item_property
428 (p_validate in boolean default false
429 ,p_effective_date in date
430 ,p_language_code in varchar2 default hr_api.userenv_lang
431 ,p_item_property_id in number default null
432 ,p_object_version_number in out nocopy number
433 ,p_form_item_id in number default null
434 ,p_template_item_id in number default null
435 ,p_template_item_context_id in number default null
436 ,p_alignment in number default hr_api.g_number
437 ,p_bevel in number default hr_api.g_number
438 ,p_case_restriction in number default hr_api.g_number
439 ,p_default_value in varchar2 default hr_api.g_varchar2
440 ,p_enabled in number default hr_api.g_number
441 ,p_format_mask in varchar2 default hr_api.g_varchar2
442 ,p_height in number default hr_api.g_number
443 ,p_information_formula_id in number default hr_api.g_number
444 ,p_information_param_item_id1 in number default hr_api.g_number
445 ,p_information_param_item_id2 in number default hr_api.g_number
446 ,p_information_param_item_id3 in number default hr_api.g_number
447 ,p_information_param_item_id4 in number default hr_api.g_number
448 ,p_information_param_item_id5 in number default hr_api.g_number
449 ,p_information_prompt in varchar2 default hr_api.g_varchar2
450 ,p_insert_allowed in number default hr_api.g_number
451 ,p_label in varchar2 default hr_api.g_varchar2
452 ,p_prompt_text in varchar2 default hr_api.g_varchar2
453 ,p_prompt_alignment_offset in number default hr_api.g_number
454 ,p_prompt_display_style in number default hr_api.g_number
455 ,p_prompt_edge in number default hr_api.g_number
456 ,p_prompt_edge_alignment in number default hr_api.g_number
457 ,p_prompt_edge_offset in number default hr_api.g_number
458 ,p_prompt_text_alignment in number default hr_api.g_number
459 ,p_query_allowed in number default hr_api.g_number
460 ,p_required in number default hr_api.g_number
461 ,p_tooltip_text in varchar2 default hr_api.g_varchar2
462 ,p_update_allowed in number default hr_api.g_number
463 ,p_validation_formula_id in number default hr_api.g_number
464 ,p_validation_param_item_id1 in number default hr_api.g_number
465 ,p_validation_param_item_id2 in number default hr_api.g_number
466 ,p_validation_param_item_id3 in number default hr_api.g_number
467 ,p_validation_param_item_id4 in number default hr_api.g_number
468 ,p_validation_param_item_id5 in number default hr_api.g_number
469 ,p_visible in number default hr_api.g_number
470 ,p_width in number default hr_api.g_number
471 ,p_x_position in number default hr_api.g_number
472 ,p_y_position in number default hr_api.g_number
473 ,p_information_category in varchar2 default hr_api.g_varchar2
474 ,p_information1 in varchar2 default hr_api.g_varchar2
475 ,p_information2 in varchar2 default hr_api.g_varchar2
476 ,p_information3 in varchar2 default hr_api.g_varchar2
477 ,p_information4 in varchar2 default hr_api.g_varchar2
478 ,p_information5 in varchar2 default hr_api.g_varchar2
479 ,p_information6 in varchar2 default hr_api.g_varchar2
480 ,p_information7 in varchar2 default hr_api.g_varchar2
481 ,p_information8 in varchar2 default hr_api.g_varchar2
482 ,p_information9 in varchar2 default hr_api.g_varchar2
483 ,p_information10 in varchar2 default hr_api.g_varchar2
484 ,p_information11 in varchar2 default hr_api.g_varchar2
485 ,p_information12 in varchar2 default hr_api.g_varchar2
486 ,p_information13 in varchar2 default hr_api.g_varchar2
487 ,p_information14 in varchar2 default hr_api.g_varchar2
488 ,p_information15 in varchar2 default hr_api.g_varchar2
489 ,p_information16 in varchar2 default hr_api.g_varchar2
490 ,p_information17 in varchar2 default hr_api.g_varchar2
491 ,p_information18 in varchar2 default hr_api.g_varchar2
492 ,p_information19 in varchar2 default hr_api.g_varchar2
493 ,p_information20 in varchar2 default hr_api.g_varchar2
494 ,p_information21 in varchar2 default hr_api.g_varchar2
495 ,p_information22 in varchar2 default hr_api.g_varchar2
496 ,p_information23 in varchar2 default hr_api.g_varchar2
497 ,p_information24 in varchar2 default hr_api.g_varchar2
498 ,p_information25 in varchar2 default hr_api.g_varchar2
499 ,p_information26 in varchar2 default hr_api.g_varchar2
500 ,p_information27 in varchar2 default hr_api.g_varchar2
501 ,p_information28 in varchar2 default hr_api.g_varchar2
502 ,p_information29 in varchar2 default hr_api.g_varchar2
503 ,p_information30 in varchar2 default hr_api.g_varchar2
504 ,p_next_navigation_item_id in number default hr_api.g_number
505 ,p_previous_navigation_item_id in number default hr_api.g_number
506 --,p_override_value_warning out boolean
507 ) is
508 --
509 -- Declare cursors and local variables
510 --
511
512 l_language_code fnd_languages.language_code%TYPE;
513
514 CURSOR cur_item_prop_1
515 IS
516 SELECT item_property_id
517 FROM hr_item_properties_b
518 WHERE form_item_id = p_form_item_id;
519
520 CURSOR cur_item_prop_2
521 IS
522 SELECT item_property_id
523 FROM hr_item_properties_b
524 WHERE template_item_id = p_template_item_id;
525
526 CURSOR cur_item_prop_3
527 IS
528 SELECT item_property_id
529 FROM hr_item_properties_b
530 WHERE template_item_context_id = p_template_item_context_id;
531
532 l_item_property_id number;
533 l_proc varchar2(72) := g_package||'update_item_property';
534 l_override_value_warning boolean;
535 begin
536 hr_utility.set_location('Entering:'|| l_proc, 10);
537 --
538 -- Issue a savepoint
539 --
540 savepoint update_item_property;
541 --
542 -- Truncate the time portion from all IN date parameters
543 --
544 -- p_effective_date := TRUNC(p_effective_date);
545 --
546 -- Validate the language parameter. l_language_code should be passed
547 -- instead of p_language_code from now on, to allow an IN OUT parameter to
548 -- be passed through.
549 --
550 l_language_code := p_language_code;
551 hr_api.validate_language_code(p_language_code => l_language_code);
552 --
553 hr_utility.set_location(l_proc, 20);
554 --
555 --
556 -- Validation in addition to Row Handlers
557 --
558 hr_utility.set_location('At:'|| l_proc, 15);
559
560 IF ( p_item_property_id is not null ) AND
561 (p_template_item_context_id is not null OR p_form_item_id is not null OR
562 p_template_item_id is not null) THEN
563 -- error message
564 fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
565 fnd_message.set_token('PROCEDURE', l_proc);
566 fnd_message.set_token('STEP','10');
567 fnd_message.raise_error;
568 ELSIF (p_template_item_context_id is not null ) AND
569 ( p_form_item_id is not null OR p_item_property_id is not null
570 OR p_template_item_id is not null) THEN
571 -- error message
572 fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
573 fnd_message.set_token('PROCEDURE', l_proc);
574 fnd_message.set_token('STEP','10');
575 fnd_message.raise_error;
576 ELSIF( p_template_item_id is not null) AND
577 ( p_item_property_id is not null
578 OR p_template_item_context_id is not null
579 OR p_form_item_id is not null) THEN
580 -- error message
581 fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
582 fnd_message.set_token('PROCEDURE', l_proc);
583 fnd_message.set_token('STEP','10');
584 fnd_message.raise_error;
585 ELSIF( p_form_item_id is not null) AND
586 ( p_item_property_id is not null
587 OR p_template_item_context_id is not null
588 OR p_template_item_id is not null) THEN
589 -- error message
590 fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
591 fnd_message.set_token('PROCEDURE', l_proc);
592 fnd_message.set_token('STEP','10');
593 fnd_message.raise_error;
594 END IF;
595
596 --
597 -- Process Logic
598 --
599 hr_utility.set_location('At:'|| l_proc, 20);
600
601 l_item_property_id := p_item_property_id;
602
603 IF p_form_item_id is not null THEN
604 OPEN cur_item_prop_1;
605 FETCH cur_item_prop_1 INTO l_item_property_id;
606 CLOSE cur_item_prop_1;
607 END IF;
608 IF p_template_item_id is not null THEN
609 OPEN cur_item_prop_2;
610 FETCH cur_item_prop_2 INTO l_item_property_id;
611 CLOSE cur_item_prop_2;
612 END IF;
613 IF p_template_item_context_id is not null THEN
614 OPEN cur_item_prop_3;
615 FETCH cur_item_prop_3 INTO l_item_property_id;
616 CLOSE cur_item_prop_3;
617 END IF;
618
619 hr_utility.set_location('At:'|| l_proc, 25);
620
621 hr_itp_upd.upd(p_effective_date => TRUNC(p_effective_date)
622 ,p_item_property_id => l_item_property_id
623 ,p_object_version_number => p_object_version_number
624 ,p_alignment => p_alignment
625 ,p_bevel => p_bevel
626 ,p_case_restriction => p_case_restriction
627 ,p_enabled => p_enabled
628 ,p_format_mask => p_format_mask
629 ,p_height => p_height
630 ,p_information_formula_id => p_information_formula_id
631 ,p_information_param_item_id1 => p_information_param_item_id1
632 ,p_information_param_item_id2 => p_information_param_item_id2
633 ,p_information_param_item_id3 => p_information_param_item_id3
634 ,p_information_param_item_id4 => p_information_param_item_id4
635 ,p_information_param_item_id5 => p_information_param_item_id5
636 ,p_insert_allowed => p_insert_allowed
637 ,p_prompt_alignment_offset => p_prompt_alignment_offset
638 ,p_prompt_display_style => p_prompt_display_style
639 ,p_prompt_edge => p_prompt_edge
640 ,p_prompt_edge_alignment => p_prompt_edge_alignment
641 ,p_prompt_edge_offset => p_prompt_edge_offset
642 ,p_prompt_text_alignment => p_prompt_text_alignment
643 ,p_query_allowed => p_query_allowed
644 ,p_required => p_required
645 ,p_update_allowed => p_update_allowed
646 ,p_validation_formula_id => p_validation_formula_id
647 ,p_validation_param_item_id1 => p_validation_param_item_id1
648 ,p_validation_param_item_id2 => p_validation_param_item_id2
649 ,p_validation_param_item_id3 => p_validation_param_item_id3
650 ,p_validation_param_item_id4 => p_validation_param_item_id4
651 ,p_validation_param_item_id5 => p_validation_param_item_id5
652 ,p_visible => p_visible
653 ,p_width => p_width
654 ,p_x_position => p_x_position
655 ,p_y_position => p_y_position
656 ,p_information_category => p_information_category
657 ,p_information1 => p_information1
658 ,p_information2 => p_information2
659 ,p_information3 => p_information3
660 ,p_information4 => p_information4
661 ,p_information5 => p_information5
662 ,p_information6 => p_information6
663 ,p_information7 => p_information7
664 ,p_information8 => p_information8
665 ,p_information9 => p_information9
666 ,p_information10 => p_information10
667 ,p_information11 => p_information11
668 ,p_information12 => p_information12
669 ,p_information13 => p_information13
670 ,p_information14 => p_information14
671 ,p_information15 => p_information15
672 ,p_information16 => p_information16
673 ,p_information17 => p_information17
674 ,p_information18 => p_information18
675 ,p_information19 => p_information19
676 ,p_information20 => p_information20
677 ,p_information21 => p_information21
678 ,p_information22 => p_information22
679 ,p_information23 => p_information23
680 ,p_information24 => p_information24
681 ,p_information25 => p_information25
682 ,p_information26 => p_information26
683 ,p_information27 => p_information27
684 ,p_information28 => p_information28
685 ,p_information29 => p_information29
686 ,p_information30 => p_information30
687 ,p_next_navigation_item_id => p_next_navigation_item_id
688 ,p_previous_navigation_item_id => p_previous_navigation_item_id);
689 -- ,p_override_value_warning => l_override_value_warning);
690
691 hr_utility.set_location('At:'|| l_proc, 30);
692
693 hr_ipt_upd.upd_tl(p_language_code => l_language_code
694 ,p_item_property_id => l_item_property_id
695 ,p_default_value => p_default_value
696 ,p_information_prompt => p_information_prompt
697 ,p_label => p_label
698 ,p_prompt_text => p_prompt_text
699 ,p_tooltip_text => p_tooltip_text);
700
701 --
702 -- Update properties common across all buttons of a radio group
703 --
704 update_radio_button_property
705 (p_effective_date => TRUNC(p_effective_date)
706 ,p_language_code => l_language_code
707 ,p_form_item_id => p_form_item_id
708 ,p_template_item_id => p_template_item_id
709 ,p_template_item_context_id => p_template_item_context_id
710 ,p_default_value => p_default_value
711 ,p_information_formula_id => p_information_formula_id
712 ,p_information_param_item_id1 => p_information_param_item_id1
713 ,p_information_param_item_id2 => p_information_param_item_id2
714 ,p_information_param_item_id3 => p_information_param_item_id3
715 ,p_information_param_item_id4 => p_information_param_item_id4
716 ,p_information_param_item_id5 => p_information_param_item_id5
717 ,p_information_prompt => p_information_prompt
718 ,p_insert_allowed => p_insert_allowed
719 ,p_next_navigation_item_id => p_next_navigation_item_id
720 ,p_previous_navigation_item_id => p_previous_navigation_item_id
721 ,p_query_allowed => p_query_allowed
722 ,p_tooltip_text => p_tooltip_text
723 ,p_update_allowed => p_update_allowed
724 ,p_validation_formula_id => p_validation_formula_id
725 ,p_validation_param_item_id1 => p_validation_param_item_id1
726 ,p_validation_param_item_id2 => p_validation_param_item_id2
727 ,p_validation_param_item_id3 => p_validation_param_item_id3
728 ,p_validation_param_item_id4 => p_validation_param_item_id4
729 ,p_validation_param_item_id5 => p_validation_param_item_id5
730 ,p_object_version_number => p_object_version_number
731 );
732 --
733 -- When in validation only mode raise the Validate_Enabled exception
734 --
735 hr_utility.set_location('At:'|| l_proc, 35);
736
737 if p_validate then
738 raise hr_api.validate_enabled;
739 end if;
740 --
741 -- Set all output arguments
742 --
743 --p_override_value_warning := l_override_value_warning;
744 --
745 hr_utility.set_location(' Leaving:'||l_proc, 70);
746 exception
747 when hr_api.validate_enabled then
748 --
749 -- As the Validate_Enabled exception has been raised
750 -- we must rollback to the savepoint
751 --
752 rollback to update_item_property;
753 --
754 -- Only set output warning arguments
755 -- (Any key or derived arguments must be set to null
756 -- when validation only mode is being used.)
757 --
758 --p_override_value_warning := null;
759 hr_utility.set_location(' Leaving:'||l_proc, 80);
760 when others then
761 --
762 -- A validation or unexpected error has occured
763 --
764 rollback to update_item_property;
765 hr_utility.set_location(' Leaving:'||l_proc, 90);
766 raise;
767 end update_item_property;
768 --
769 --
770 -- ----------------------------------------------------------------------------
771 -- |------------------------< delete_item_property >--------------------------|
772 -- ----------------------------------------------------------------------------
773 --
774 procedure delete_item_property
775 (p_validate in boolean default false
776 ,p_item_property_id in number default null
777 ,p_form_item_id in number default null
778 ,p_template_item_id in number default null
779 ,p_template_item_context_id in number default null
780 ,p_object_version_number in number
781 ) is
782 --
783 -- Declare cursors and local variables
784 --
785
786 CURSOR cur_item_prop_1
787 IS
788 SELECT item_property_id
789 FROM hr_item_properties_b
790 WHERE form_item_id = p_form_item_id;
791
792 CURSOR cur_item_prop_2
793 IS
794 SELECT item_property_id
795 FROM hr_item_properties_b
796 WHERE template_item_id = p_template_item_id;
797
798 CURSOR cur_item_prop_3
799 IS
800 SELECT item_property_id
801 FROM hr_item_properties_b
802 WHERE template_item_context_id = p_template_item_context_id;
803
804 l_item_property_id number;
805 l_proc varchar2(72) := g_package||'delete_item_property';
806 begin
807 hr_utility.set_location('Entering:'|| l_proc, 10);
808 --
809 -- Issue a savepoint
810 --
811 savepoint delete_item_property;
812 --
813 -- Validation in addition to Row Handlers
814 --
815
816 hr_utility.set_location('At:'|| l_proc, 15);
817
818 IF ( p_item_property_id is not null ) AND
819 (p_template_item_context_id is not null OR p_form_item_id is not null OR
820 p_template_item_id is not null) THEN
821 -- error message
822 fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
823 fnd_message.set_token('PROCEDURE', l_proc);
824 fnd_message.set_token('STEP','10');
825 fnd_message.raise_error;
826 ELSIF (p_template_item_context_id is not null ) AND
827 ( p_form_item_id is not null OR p_item_property_id is not null
828 OR p_template_item_id is not null) THEN
829 -- error message
830 fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
831 fnd_message.set_token('PROCEDURE', l_proc);
832 fnd_message.set_token('STEP','10');
833 fnd_message.raise_error;
834 ELSIF( p_template_item_id is not null) AND
835 ( p_item_property_id is not null
836 OR p_template_item_context_id is not null
837 OR p_form_item_id is not null) THEN
838 -- error message
839 fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
840 fnd_message.set_token('PROCEDURE', l_proc);
841 fnd_message.set_token('STEP','10');
842 fnd_message.raise_error;
843 ELSIF( p_form_item_id is not null) AND
844 ( p_item_property_id is not null
845 OR p_template_item_context_id is not null
846 OR p_template_item_id is not null) THEN
847 -- error message
848 fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
849 fnd_message.set_token('PROCEDURE', l_proc);
850 fnd_message.set_token('STEP','10');
851 fnd_message.raise_error;
852 END IF;
853
854 --
855 -- Process Logic
856 --
857 hr_utility.set_location('At:'|| l_proc, 20);
858
859 l_item_property_id := p_item_property_id;
860
861 IF p_form_item_id is not null THEN
862 OPEN cur_item_prop_1;
863 FETCH cur_item_prop_1 INTO l_item_property_id;
864 CLOSE cur_item_prop_1;
865 END IF;
866
867 hr_utility.set_location('At:'|| l_proc, 25);
868
869 IF p_template_item_id is not null THEN
870 OPEN cur_item_prop_2;
871 FETCH cur_item_prop_2 INTO l_item_property_id;
872 CLOSE cur_item_prop_2;
873 END IF;
874
875 hr_utility.set_location('At:'|| l_proc, 30);
876
877 IF p_template_item_context_id is not null THEN
878 OPEN cur_item_prop_3;
879 FETCH cur_item_prop_3 INTO l_item_property_id;
880 CLOSE cur_item_prop_3;
881 END IF;
882
883 hr_utility.set_location('At:'|| l_proc, 35);
884 -- Bug 4018745 Starts Here
885 -- Desc: Added if condition to avoid the below calls if item_property_id is null.
886 if l_item_property_id is not null then
887 hr_itp_shd.lck( p_item_property_id => l_item_property_id
888 , p_object_version_number => p_object_version_number);
889
890 hr_utility.set_location('At:'|| l_proc, 40);
891
892 hr_ipt_del.del_tl( p_item_property_id => l_item_property_id);
893
894 hr_utility.set_location('At:'|| l_proc, 45);
895
896 hr_itp_del.del( p_item_property_id => l_item_property_id
897 , p_object_version_number => p_object_version_number);
898
899 --
900 -- When in validation only mode raise the Validate_Enabled exception
901 --
902 hr_utility.set_location('At:'|| l_proc, 50);
903 end if;
904 -- Bug 4018745 Ends Here
905 if p_validate then
906 raise hr_api.validate_enabled;
907 end if;
908 --
909 hr_utility.set_location(' Leaving:'||l_proc, 70);
910 exception
911 when hr_api.validate_enabled then
912 --
913 -- As the Validate_Enabled exception has been raised
914 -- we must rollback to the savepoint
915 --
916 rollback to delete_item_property;
917 --
918 -- Only set output warning arguments
919 -- (Any key or derived arguments must be set to null
920 -- when validation only mode is being used.)
921 --
922 hr_utility.set_location(' Leaving:'||l_proc, 80);
923 when others then
924 --
925 -- A validation or unexpected error has occured
926 --
927 rollback to delete_item_property;
928 hr_utility.set_location(' Leaving:'||l_proc, 90);
929 raise;
930 end delete_item_property;
931 --
932 -- ----------------------------------------------------------------------------
933 -- |--------------------------< copy_item_property >--------------------------|
934 -- ----------------------------------------------------------------------------
935 --
936 procedure copy_item_property
937 (p_validate in boolean default false
938 ,p_effective_date in date
939 ,p_language_code in varchar2 default hr_api.userenv_lang
940 ,p_form_item_id in number
941 ,p_template_item_id in number
942 ,p_alignment in number default hr_api.g_number
943 ,p_bevel in number default hr_api.g_number
944 ,p_case_restriction in number default hr_api.g_number
945 ,p_default_value in varchar2 default hr_api.g_varchar2
946 ,p_enabled in number default hr_api.g_number
947 ,p_format_mask in varchar2 default hr_api.g_varchar2
948 ,p_height in number default hr_api.g_number
949 ,p_information_formula_id in number default hr_api.g_number
950 ,p_information_param_item_id1 in number default hr_api.g_number
951 ,p_information_param_item_id2 in number default hr_api.g_number
952 ,p_information_param_item_id3 in number default hr_api.g_number
953 ,p_information_param_item_id4 in number default hr_api.g_number
954 ,p_information_param_item_id5 in number default hr_api.g_number
955 ,p_information_prompt in varchar2 default hr_api.g_varchar2
956 ,p_insert_allowed in number default hr_api.g_number
957 ,p_label in varchar2 default hr_api.g_varchar2
958 ,p_prompt_text in varchar2 default hr_api.g_varchar2
959 ,p_prompt_alignment_offset in number default hr_api.g_number
960 ,p_prompt_display_style in number default hr_api.g_number
961 ,p_prompt_edge in number default hr_api.g_number
962 ,p_prompt_edge_alignment in number default hr_api.g_number
963 ,p_prompt_edge_offset in number default hr_api.g_number
964 ,p_prompt_text_alignment in number default hr_api.g_number
965 ,p_query_allowed in number default hr_api.g_number
966 ,p_required in number default hr_api.g_number
967 ,p_tooltip_text in varchar2 default hr_api.g_varchar2
968 ,p_update_allowed in number default hr_api.g_number
969 ,p_validation_formula_id in number default hr_api.g_number
970 ,p_validation_param_item_id1 in number default hr_api.g_number
971 ,p_validation_param_item_id2 in number default hr_api.g_number
972 ,p_validation_param_item_id3 in number default hr_api.g_number
973 ,p_validation_param_item_id4 in number default hr_api.g_number
974 ,p_validation_param_item_id5 in number default hr_api.g_number
975 ,p_visible in number default hr_api.g_number
976 ,p_width in number default hr_api.g_number
977 ,p_x_position in number default hr_api.g_number
978 ,p_y_position in number default hr_api.g_number
979 ,p_information_category in varchar2 default hr_api.g_varchar2
980 ,p_information1 in varchar2 default hr_api.g_varchar2
981 ,p_information2 in varchar2 default hr_api.g_varchar2
982 ,p_information3 in varchar2 default hr_api.g_varchar2
983 ,p_information4 in varchar2 default hr_api.g_varchar2
984 ,p_information5 in varchar2 default hr_api.g_varchar2
985 ,p_information6 in varchar2 default hr_api.g_varchar2
986 ,p_information7 in varchar2 default hr_api.g_varchar2
987 ,p_information8 in varchar2 default hr_api.g_varchar2
988 ,p_information9 in varchar2 default hr_api.g_varchar2
989 ,p_information10 in varchar2 default hr_api.g_varchar2
990 ,p_information11 in varchar2 default hr_api.g_varchar2
991 ,p_information12 in varchar2 default hr_api.g_varchar2
992 ,p_information13 in varchar2 default hr_api.g_varchar2
993 ,p_information14 in varchar2 default hr_api.g_varchar2
994 ,p_information15 in varchar2 default hr_api.g_varchar2
995 ,p_information16 in varchar2 default hr_api.g_varchar2
996 ,p_information17 in varchar2 default hr_api.g_varchar2
997 ,p_information18 in varchar2 default hr_api.g_varchar2
998 ,p_information19 in varchar2 default hr_api.g_varchar2
999 ,p_information20 in varchar2 default hr_api.g_varchar2
1000 ,p_information21 in varchar2 default hr_api.g_varchar2
1001 ,p_information22 in varchar2 default hr_api.g_varchar2
1002 ,p_information23 in varchar2 default hr_api.g_varchar2
1003 ,p_information24 in varchar2 default hr_api.g_varchar2
1004 ,p_information25 in varchar2 default hr_api.g_varchar2
1005 ,p_information26 in varchar2 default hr_api.g_varchar2
1006 ,p_information27 in varchar2 default hr_api.g_varchar2
1007 ,p_information28 in varchar2 default hr_api.g_varchar2
1008 ,p_information29 in varchar2 default hr_api.g_varchar2
1009 ,p_information30 in varchar2 default hr_api.g_varchar2
1010 ,p_next_navigation_item_id in number default hr_api.g_number
1011 ,p_previous_navigation_item_id in number default hr_api.g_number
1012 ,p_item_property_id out nocopy number
1013 ,p_object_version_number out nocopy number
1014 --,p_override_value_warning out boolean
1015 ) is
1016 --
1017 -- Declare cursors and local variables
1018 --
1019
1020 Type l_rec_type Is Record
1021 (alignment hr_item_properties_b.alignment%TYPE
1022 ,bevel hr_item_properties_b.bevel%TYPE
1023 ,case_restriction hr_item_properties_b.case_restriction%TYPE
1024 ,enabled hr_item_properties_b.enabled%TYPE
1025 ,format_mask hr_item_properties_b.format_mask%TYPE
1026 ,height hr_item_properties_b.height%TYPE
1027 ,information_formula_id hr_item_properties_b.information_formula_id%TYPE
1028 ,information_param_item_id1 hr_item_properties_b.information_parameter_item_id1%TYPE
1029 ,information_param_item_id2 hr_item_properties_b.information_parameter_item_id2%TYPE
1030 ,information_param_item_id3 hr_item_properties_b.information_parameter_item_id3%TYPE
1031 ,information_param_item_id4 hr_item_properties_b.information_parameter_item_id4%TYPE
1032 ,information_param_item_id5 hr_item_properties_b.information_parameter_item_id5%TYPE
1033 ,insert_allowed hr_item_properties_b.insert_allowed%TYPE
1034 ,prompt_alignment_offset hr_item_properties_b.prompt_alignment_offset%TYPE
1035 ,prompt_display_style hr_item_properties_b.prompt_display_style%TYPE
1036 ,prompt_edge hr_item_properties_b.prompt_edge%TYPE
1037 ,prompt_edge_alignment hr_item_properties_b.prompt_edge_alignment%TYPE
1038 ,prompt_edge_offset hr_item_properties_b.prompt_edge_offset%TYPE
1039 ,prompt_text_alignment hr_item_properties_b.prompt_text_alignment%TYPE
1040 ,query_allowed hr_item_properties_b.query_allowed%TYPE
1041 ,required hr_item_properties_b.required%TYPE
1042 ,update_allowed hr_item_properties_b.update_allowed%TYPE
1043 ,validation_formula_id hr_item_properties_b.validation_formula_id%TYPE
1044 ,validation_param_item_id1 hr_item_properties_b.validation_parameter_item_id1%TYPE
1045 ,validation_param_item_id2 hr_item_properties_b.validation_parameter_item_id2%TYPE
1046 ,validation_param_item_id3 hr_item_properties_b.validation_parameter_item_id3%TYPE
1047 ,validation_param_item_id4 hr_item_properties_b.validation_parameter_item_id4%TYPE
1048 ,validation_param_item_id5 hr_item_properties_b.validation_parameter_item_id5%TYPE
1049 ,visible hr_item_properties_b.visible%TYPE
1050 ,width hr_item_properties_b.width%TYPE
1051 ,x_position hr_item_properties_b.x_position%TYPE
1052 ,y_position hr_item_properties_b.y_position%TYPE
1053 ,information_category hr_item_properties_b.information_category%TYPE
1054 ,information1 hr_item_properties_b.information1%TYPE
1055 ,information2 hr_item_properties_b.information2%TYPE
1056 ,information3 hr_item_properties_b.information3%TYPE
1057 ,information4 hr_item_properties_b.information4%TYPE
1058 ,information5 hr_item_properties_b.information5%TYPE
1059 ,information6 hr_item_properties_b.information6%TYPE
1060 ,information7 hr_item_properties_b.information7%TYPE
1061 ,information8 hr_item_properties_b.information8%TYPE
1062 ,information9 hr_item_properties_b.information9%TYPE
1063 ,information10 hr_item_properties_b.information10%TYPE
1064 ,information11 hr_item_properties_b.information11%TYPE
1065 ,information12 hr_item_properties_b.information12%TYPE
1066 ,information13 hr_item_properties_b.information13%TYPE
1067 ,information14 hr_item_properties_b.information14%TYPE
1068 ,information15 hr_item_properties_b.information15%TYPE
1069 ,information16 hr_item_properties_b.information16%TYPE
1070 ,information17 hr_item_properties_b.information17%TYPE
1071 ,information18 hr_item_properties_b.information18%TYPE
1072 ,information19 hr_item_properties_b.information19%TYPE
1073 ,information20 hr_item_properties_b.information20%TYPE
1074 ,information21 hr_item_properties_b.information21%TYPE
1075 ,information22 hr_item_properties_b.information22%TYPE
1076 ,information23 hr_item_properties_b.information23%TYPE
1077 ,information24 hr_item_properties_b.information24%TYPE
1078 ,information25 hr_item_properties_b.information25%TYPE
1079 ,information26 hr_item_properties_b.information26%TYPE
1080 ,information27 hr_item_properties_b.information27%TYPE
1081 ,information28 hr_item_properties_b.information28%TYPE
1082 ,information29 hr_item_properties_b.information29%TYPE
1083 ,information30 hr_item_properties_b.information30%TYPE
1084 ,next_navigation_item_id hr_item_properties_b.next_navigation_item_id%TYPE
1085 ,previous_navigation_item_id hr_item_properties_b.previous_navigation_item_id%TYPE
1086 );
1087
1088 l_rec l_rec_type;
1089
1090 CURSOR cur_check
1091 IS
1092 SELECT 1
1093 FROM hr_template_items tit
1094 WHERE tit.template_item_id = p_template_item_id
1095 AND tit.form_item_id = p_form_item_id;
1096
1097 -- added a outer join so that the correct values are returned
1098 -- if there are no entries in the properties table
1099 CURSOR cur_item_prop
1100 IS
1101 SELECT DECODE(p_alignment,hr_api.g_number,itp.alignment,p_alignment)
1102 ,DECODE(p_bevel,hr_api.g_number,itp.bevel,p_bevel)
1103 ,DECODE(p_case_restriction,hr_api.g_number,itp.case_restriction,p_case_restriction)
1104 ,DECODE(p_enabled,hr_api.g_number,itp.enabled,p_enabled)
1105 ,DECODE(p_format_mask,hr_api.g_varchar2,itp.format_mask,p_format_mask)
1106 ,DECODE(p_height,hr_api.g_number,itp.height,p_height)
1107 ,DECODE(p_information_formula_id,hr_api.g_number,itp.information_formula_id,p_information_formula_id)
1108 ,DECODE(p_information_param_item_id1,hr_api.g_number,itp.information_parameter_item_id1,p_information_param_item_id1)
1109 ,DECODE(p_information_param_item_id2,hr_api.g_number,itp.information_parameter_item_id2,p_information_param_item_id2)
1110 ,DECODE(p_information_param_item_id3,hr_api.g_number,itp.information_parameter_item_id3,p_information_param_item_id3)
1111 ,DECODE(p_information_param_item_id4,hr_api.g_number,itp.information_parameter_item_id4,p_information_param_item_id4)
1112 ,DECODE(p_information_param_item_id5,hr_api.g_number,itp.information_parameter_item_id5,p_information_param_item_id5)
1113 ,DECODE(p_insert_allowed,hr_api.g_number,itp.insert_allowed,p_insert_allowed)
1114 ,DECODE(p_prompt_alignment_offset,hr_api.g_number,itp.prompt_alignment_offset,p_prompt_alignment_offset)
1115 ,DECODE(p_prompt_display_style,hr_api.g_number,itp.prompt_display_style,p_prompt_display_style)
1116 ,DECODE(p_prompt_edge,hr_api.g_number,itp.prompt_edge,p_prompt_edge)
1117 ,DECODE(p_prompt_edge_alignment,hr_api.g_number,itp.prompt_edge_alignment,p_prompt_edge_alignment)
1118 ,DECODE(p_prompt_edge_offset,hr_api.g_number,itp.prompt_edge_offset,p_prompt_edge_offset)
1119 ,DECODE(p_prompt_text_alignment,hr_api.g_number,itp.prompt_text_alignment,p_prompt_text_alignment)
1120 ,DECODE(p_query_allowed,hr_api.g_number,itp.query_allowed,p_query_allowed)
1121 ,DECODE(p_required,hr_api.g_number,itp.required,p_required)
1122 ,DECODE(p_update_allowed,hr_api.g_number,itp.update_allowed,p_update_allowed)
1123 ,DECODE(p_validation_formula_id,hr_api.g_number,itp.validation_formula_id,p_validation_formula_id)
1124 ,DECODE(p_validation_param_item_id1,hr_api.g_number,itp.validation_parameter_item_id1,p_validation_param_item_id1)
1125 ,DECODE(p_validation_param_item_id2,hr_api.g_number,itp.validation_parameter_item_id2,p_validation_param_item_id2)
1126 ,DECODE(p_validation_param_item_id3,hr_api.g_number,itp.validation_parameter_item_id3,p_validation_param_item_id3)
1127 ,DECODE(p_validation_param_item_id4,hr_api.g_number,itp.validation_parameter_item_id4,p_validation_param_item_id4)
1128 ,DECODE(p_validation_param_item_id5,hr_api.g_number,itp.validation_parameter_item_id5,p_validation_param_item_id5)
1129 ,DECODE(p_visible,hr_api.g_number,itp.visible,p_visible)
1130 ,DECODE(p_width,hr_api.g_number,itp.width,p_width)
1131 ,DECODE(p_x_position,hr_api.g_number,itp.x_position,p_x_position)
1132 ,DECODE(p_y_position,hr_api.g_number,itp.y_position,p_y_position)
1133 ,DECODE(p_information_category,hr_api.g_varchar2,itp.information_category,p_information_category)
1134 ,DECODE(p_information1,hr_api.g_varchar2,itp.information1,p_information1)
1135 ,DECODE(p_information2,hr_api.g_varchar2,itp.information2,p_information2)
1136 ,DECODE(p_information3,hr_api.g_varchar2,itp.information3,p_information3)
1137 ,DECODE(p_information4,hr_api.g_varchar2,itp.information4,p_information4)
1138 ,DECODE(p_information5,hr_api.g_varchar2,itp.information5,p_information5)
1139 ,DECODE(p_information6,hr_api.g_varchar2,itp.information6,p_information6)
1140 ,DECODE(p_information7,hr_api.g_varchar2,itp.information7,p_information7)
1141 ,DECODE(p_information8,hr_api.g_varchar2,itp.information8,p_information8)
1142 ,DECODE(p_information9,hr_api.g_varchar2,itp.information9,p_information9)
1143 ,DECODE(p_information10,hr_api.g_varchar2,itp.information10,p_information10)
1144 ,DECODE(p_information11,hr_api.g_varchar2,itp.information11,p_information11)
1145 ,DECODE(p_information12,hr_api.g_varchar2,itp.information12,p_information12)
1146 ,DECODE(p_information13,hr_api.g_varchar2,itp.information13,p_information13)
1147 ,DECODE(p_information14,hr_api.g_varchar2,itp.information14,p_information14)
1148 ,DECODE(p_information15,hr_api.g_varchar2,itp.information15,p_information15)
1149 ,DECODE(p_information16,hr_api.g_varchar2,itp.information16,p_information16)
1150 ,DECODE(p_information17,hr_api.g_varchar2,itp.information17,p_information17)
1151 ,DECODE(p_information18,hr_api.g_varchar2,itp.information18,p_information18)
1152 ,DECODE(p_information19,hr_api.g_varchar2,itp.information19,p_information19)
1153 ,DECODE(p_information20,hr_api.g_varchar2,itp.information20,p_information20)
1154 ,DECODE(p_information21,hr_api.g_varchar2,itp.information21,p_information21)
1155 ,DECODE(p_information22,hr_api.g_varchar2,itp.information22,p_information22)
1156 ,DECODE(p_information23,hr_api.g_varchar2,itp.information23,p_information23)
1157 ,DECODE(p_information24,hr_api.g_varchar2,itp.information24,p_information24)
1158 ,DECODE(p_information25,hr_api.g_varchar2,itp.information25,p_information25)
1159 ,DECODE(p_information26,hr_api.g_varchar2,itp.information26,p_information26)
1160 ,DECODE(p_information27,hr_api.g_varchar2,itp.information27,p_information27)
1161 ,DECODE(p_information28,hr_api.g_varchar2,itp.information28,p_information28)
1162 ,DECODE(p_information29,hr_api.g_varchar2,itp.information29,p_information29)
1163 ,DECODE(p_information30,hr_api.g_varchar2,itp.information30,p_information30)
1164 ,DECODE(p_next_navigation_item_id,hr_api.g_number,itp.next_navigation_item_id,p_next_navigation_item_id)
1165 ,DECODE(p_previous_navigation_item_id,hr_api.g_number,itp.previous_navigation_item_id,p_previous_navigation_item_id)
1166 FROM hr_item_properties_b itp
1167 , hr_form_items_b hfi
1168 WHERE itp.form_item_id (+) = hfi.form_item_id
1169 AND hfi.form_item_id = p_form_item_id;
1170
1171 CURSOR cur_item_tl
1172 IS
1173 SELECT COUNT(0) t_count
1174 ,itptl.source_lang
1175 ,DECODE(p_default_value,hr_api.g_varchar2,itptl.default_value,p_default_value) default_value
1176 ,DECODE(p_information_prompt,hr_api.g_varchar2,itptl.information_prompt,p_information_prompt) information_prompt
1177 ,DECODE(p_label,hr_api.g_varchar2,itptl.label,p_label) label
1178 ,DECODE(p_prompt_text,hr_api.g_varchar2,itptl.prompt_text,p_prompt_text) prompt_text
1179 ,DECODE(p_tooltip_text,hr_api.g_varchar2,itptl.tooltip_text,p_tooltip_text) tooltip_text
1180 FROM hr_item_properties_tl itptl
1181 ,hr_item_properties_b itp
1182 WHERE itptl.item_property_id = itp.item_property_id
1183 AND itp.form_item_id = p_form_item_id
1184 GROUP BY itptl.source_lang
1185 ,DECODE(p_default_value,hr_api.g_varchar2,itptl.default_value,p_default_value)
1186 ,DECODE(p_information_prompt,hr_api.g_varchar2,itptl.information_prompt,p_information_prompt)
1187 ,DECODE(p_label,hr_api.g_varchar2,itptl.label,p_label)
1188 ,DECODE(p_prompt_text,hr_api.g_varchar2,itptl.prompt_text,p_prompt_text)
1189 ,DECODE(p_tooltip_text,hr_api.g_varchar2,itptl.tooltip_text,p_tooltip_text)
1190 ORDER BY 1;
1191
1192 l_language_code fnd_languages.language_code%TYPE;
1193
1194 l_check number;
1195 l_item_property_id number ;
1196 l_object_version_number number;
1197 l_override_value_warning boolean;
1198 l_proc varchar2(72) := g_package||'copy_item_property';
1199 begin
1200 hr_utility.set_location('Entering:'|| l_proc, 10);
1201 --
1202 -- Issue a savepoint
1203 --
1204 savepoint copy_item_property;
1205 --
1206 -- Truncate the time portion from all IN date parameters
1207 --
1208 -- p_effective_date := TRUNC(p_effective_date);
1209 --
1210 -- Validate the language parameter. l_language_code should be passed
1211 -- instead of p_language_code from now on, to allow an IN OUT parameter to
1212 -- be passed through.
1213 --
1214 l_language_code := p_language_code;
1215 hr_api.validate_language_code(p_language_code => l_language_code);
1216 --
1217 hr_utility.set_location(l_proc, 20);
1218 --
1219 --
1220 -- Validation in addition to Row Handlers
1221 --
1222 hr_utility.set_location('At:'|| l_proc, 15);
1223
1224 OPEN cur_check;
1225 FETCH cur_check INTO l_check;
1226 IF cur_check%NOTFOUND THEN
1227 CLOSE cur_check;
1228 -- error message
1229 fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1230 fnd_message.set_token('PROCEDURE', l_proc);
1231 fnd_message.set_token('STEP','10');
1232 fnd_message.raise_error;
1233 END IF;
1234 CLOSE cur_check;
1235 --
1236 -- Process Logic
1237 --
1238 hr_utility.set_location('At:'|| l_proc, 20);
1239
1240 OPEN cur_item_prop;
1241 FETCH cur_item_prop INTO l_rec;
1242 CLOSE cur_item_prop;
1243
1244 hr_utility.set_location('At:'|| l_proc, 25);
1245
1246 hr_itp_ins.ins(p_effective_date => TRUNC(p_effective_date)
1247 ,p_template_item_id => p_template_item_id
1248 ,p_alignment => l_rec.alignment
1249 ,p_bevel => l_rec.bevel
1250 ,p_case_restriction => l_rec.case_restriction
1251 ,p_enabled => l_rec.enabled
1252 ,p_format_mask => l_rec.format_mask
1253 ,p_height => l_rec.height
1254 ,p_information_formula_id => l_rec.information_formula_id
1255 ,p_information_param_item_id1 => l_rec.information_param_item_id1
1256 ,p_information_param_item_id2 => l_rec.information_param_item_id2
1257 ,p_information_param_item_id3 => l_rec.information_param_item_id3
1258 ,p_information_param_item_id4 => l_rec.information_param_item_id4
1259 ,p_information_param_item_id5 => l_rec.information_param_item_id5
1260 ,p_insert_allowed => l_rec.insert_allowed
1261 ,p_prompt_alignment_offset => l_rec.prompt_alignment_offset
1262 ,p_prompt_display_style => l_rec.prompt_display_style
1263 ,p_prompt_edge => l_rec.prompt_edge
1264 ,p_prompt_edge_alignment => l_rec.prompt_edge_alignment
1265 ,p_prompt_edge_offset => l_rec.prompt_edge_offset
1266 ,p_prompt_text_alignment => l_rec.prompt_text_alignment
1267 ,p_query_allowed => l_rec.query_allowed
1268 ,p_required => l_rec.required
1269 ,p_update_allowed => l_rec.update_allowed
1270 ,p_validation_formula_id => l_rec.validation_formula_id
1271 ,p_validation_param_item_id1 => l_rec.validation_param_item_id1
1272 ,p_validation_param_item_id2 => l_rec.validation_param_item_id2
1273 ,p_validation_param_item_id3 => l_rec.validation_param_item_id3
1274 ,p_validation_param_item_id4 => l_rec.validation_param_item_id4
1275 ,p_validation_param_item_id5 => l_rec.validation_param_item_id5
1276 ,p_visible => l_rec.visible
1277 ,p_width => l_rec.width
1278 ,p_x_position => l_rec.x_position
1279 ,p_y_position => l_rec.y_position
1280 ,p_information_category => l_rec.information_category
1281 ,p_information1 => l_rec.information1
1282 ,p_information2 => l_rec.information2
1283 ,p_information3 => l_rec.information3
1284 ,p_information4 => l_rec.information4
1285 ,p_information5 => l_rec.information5
1286 ,p_information6 => l_rec.information6
1287 ,p_information7 => l_rec.information7
1288 ,p_information8 => l_rec.information8
1289 ,p_information9 => l_rec.information9
1290 ,p_information10 => l_rec.information10
1291 ,p_information11 => l_rec.information11
1292 ,p_information12 => l_rec.information12
1293 ,p_information13 => l_rec.information13
1294 ,p_information14 => l_rec.information14
1295 ,p_information15 => l_rec.information15
1296 ,p_information16 => l_rec.information16
1297 ,p_information17 => l_rec.information17
1298 ,p_information18 => l_rec.information18
1299 ,p_information19 => l_rec.information19
1300 ,p_information20 => l_rec.information20
1301 ,p_information21 => l_rec.information21
1302 ,p_information22 => l_rec.information22
1303 ,p_information23 => l_rec.information23
1304 ,p_information24 => l_rec.information24
1305 ,p_information25 => l_rec.information25
1306 ,p_information26 => l_rec.information26
1307 ,p_information27 => l_rec.information27
1308 ,p_information28 => l_rec.information28
1309 ,p_information29 => l_rec.information29
1310 ,p_information30 => l_rec.information30
1311 ,p_next_navigation_item_id => l_rec.next_navigation_item_id
1312 ,p_previous_navigation_item_id => l_rec.previous_navigation_item_id
1313 ,p_item_property_id => l_item_property_id
1314 ,p_object_version_number => l_object_version_number);
1315 --,p_override_value_warning => l_override_value_warning);
1316
1317 hr_utility.set_location('At:'|| l_proc, 30);
1318
1319 IF ( p_default_value <> hr_api.g_varchar2)
1320 AND ( p_information_prompt <> hr_api.g_varchar2)
1321 AND ( p_label <> hr_api.g_varchar2 )
1322 AND ( p_prompt_text <> hr_api.g_varchar2 )
1323 AND ( p_tooltip_text <> hr_api.g_varchar2 ) THEN
1324
1325 hr_utility.set_location('At:'|| l_proc, 35);
1326
1327 hr_ipt_ins.ins_tl(p_language_code => l_language_code
1328 ,p_item_property_id => l_item_property_id
1329 ,p_default_value => p_default_value
1330 ,p_information_prompt => p_information_prompt
1331 ,p_label => p_label
1332 ,p_prompt_text => p_prompt_text
1333 ,p_tooltip_text => p_tooltip_text);
1334
1335 ELSE
1336 hr_utility.set_location('At:'|| l_proc, 40);
1337
1338 FOR cur_rec in cur_item_tl LOOP
1339 IF cur_item_tl%ROWCOUNT = 1 THEN
1340 hr_utility.set_location('At:'|| l_proc, 45);
1341
1342 hr_ipt_ins.ins_tl(p_language_code => cur_rec.source_lang
1343 ,p_item_property_id => l_item_property_id
1344 ,p_default_value => cur_rec.default_value
1345 ,p_information_prompt => cur_rec.information_prompt
1346 ,p_label => cur_rec.label
1347 ,p_prompt_text => cur_rec.prompt_text
1348 ,p_tooltip_text => cur_rec.tooltip_text);
1349 ELSE
1350 hr_utility.set_location('At:'|| l_proc, 50);
1351
1352 hr_ipt_upd.upd_tl(p_language_code => cur_rec.source_lang
1353 ,p_item_property_id => l_item_property_id
1354 ,p_default_value => cur_rec.default_value
1355 ,p_information_prompt => cur_rec.information_prompt
1356 ,p_label => cur_rec.label
1357 ,p_prompt_text => cur_rec.prompt_text
1358 ,p_tooltip_text => cur_rec.tooltip_text);
1359 END IF;
1360 END LOOP;
1361 END IF;
1362 --
1363 -- Update properties common across all buttons of a radio group
1364 --
1365 update_radio_button_property
1366 (p_effective_date => TRUNC(p_effective_date)
1367 ,p_language_code => l_language_code
1368 ,p_form_item_id => NULL
1369 ,p_template_item_id => p_template_item_id
1370 ,p_template_item_context_id => NULL
1371 ,p_default_value => p_default_value
1372 ,p_information_formula_id => l_rec.information_formula_id
1373 ,p_information_param_item_id1 => l_rec.information_param_item_id1
1374 ,p_information_param_item_id2 => l_rec.information_param_item_id2
1375 ,p_information_param_item_id3 => l_rec.information_param_item_id3
1376 ,p_information_param_item_id4 => l_rec.information_param_item_id4
1377 ,p_information_param_item_id5 => l_rec.information_param_item_id5
1378 ,p_information_prompt => p_information_prompt
1379 ,p_insert_allowed => l_rec.insert_allowed
1380 ,p_next_navigation_item_id => l_rec.next_navigation_item_id
1381 ,p_previous_navigation_item_id => l_rec.previous_navigation_item_id
1382 ,p_query_allowed => l_rec.query_allowed
1383 ,p_tooltip_text => p_tooltip_text
1384 ,p_update_allowed => l_rec.update_allowed
1385 ,p_validation_formula_id => l_rec.validation_formula_id
1386 ,p_validation_param_item_id1 => l_rec.validation_param_item_id1
1387 ,p_validation_param_item_id2 => l_rec.validation_param_item_id2
1388 ,p_validation_param_item_id3 => l_rec.validation_param_item_id3
1389 ,p_validation_param_item_id4 => l_rec.validation_param_item_id4
1390 ,p_validation_param_item_id5 => l_rec.validation_param_item_id5
1391 ,p_object_version_number => l_object_version_number
1392 );
1393 --
1394 -- When in validation only mode raise the Validate_Enabled exception
1395 --
1396 hr_utility.set_location('At:'|| l_proc, 60);
1397
1398 if p_validate then
1399 raise hr_api.validate_enabled;
1400 end if;
1401 --
1402 -- Set all output arguments
1403 --
1404 p_item_property_id := l_item_property_id;
1405 p_object_version_number := l_object_version_number;
1406 --p_override_value_warning := l_override_value_warning;
1407 --
1408 hr_utility.set_location(' Leaving:'||l_proc, 70);
1409 exception
1410 when hr_api.validate_enabled then
1411 --
1412 -- As the Validate_Enabled exception has been raised
1413 -- we must rollback to the savepoint
1414 --
1415 rollback to copy_item_property;
1416 --
1417 -- Only set output warning arguments
1418 -- (Any key or derived arguments must be set to null
1419 -- when validation only mode is being used.)
1420 --
1421 p_item_property_id := null;
1422 --p_override_value_warning := null;
1423 hr_utility.set_location(' Leaving:'||l_proc, 80);
1424 when others then
1425 --
1426 -- A validation or unexpected error has occured
1427 --
1428 rollback to copy_item_property;
1429 hr_utility.set_location(' Leaving:'||l_proc, 90);
1430 raise;
1431 end copy_item_property;
1432 --
1433 --
1434 -- ----------------------------------------------------------------------------
1435 -- |--------------------< copy_item_property - overload 1>--------------------|
1436 -- ----------------------------------------------------------------------------
1437 --
1438 procedure copy_item_property
1439 (p_validate in boolean default false
1440 ,p_effective_date in date
1441 ,p_language_code in varchar2 default hr_api.userenv_lang
1442 ,p_template_item_id in number
1443 ,p_template_item_context_id in number
1444 ,p_alignment in number default hr_api.g_number
1445 ,p_bevel in number default hr_api.g_number
1446 ,p_case_restriction in number default hr_api.g_number
1447 ,p_default_value in varchar2 default hr_api.g_varchar2
1448 ,p_enabled in number default hr_api.g_number
1449 ,p_format_mask in varchar2 default hr_api.g_varchar2
1450 ,p_height in number default hr_api.g_number
1451 ,p_information_formula_id in number default hr_api.g_number
1452 ,p_information_param_item_id1 in number default hr_api.g_number
1453 ,p_information_param_item_id2 in number default hr_api.g_number
1454 ,p_information_param_item_id3 in number default hr_api.g_number
1455 ,p_information_param_item_id4 in number default hr_api.g_number
1456 ,p_information_param_item_id5 in number default hr_api.g_number
1457 ,p_information_prompt in varchar2 default hr_api.g_varchar2
1458 ,p_insert_allowed in number default hr_api.g_number
1459 ,p_label in varchar2 default hr_api.g_varchar2
1460 ,p_prompt_text in varchar2 default hr_api.g_varchar2
1461 ,p_prompt_alignment_offset in number default hr_api.g_number
1462 ,p_prompt_display_style in number default hr_api.g_number
1463 ,p_prompt_edge in number default hr_api.g_number
1464 ,p_prompt_edge_alignment in number default hr_api.g_number
1465 ,p_prompt_edge_offset in number default hr_api.g_number
1466 ,p_prompt_text_alignment in number default hr_api.g_number
1467 ,p_query_allowed in number default hr_api.g_number
1468 ,p_required in number default hr_api.g_number
1469 ,p_tooltip_text in varchar2 default hr_api.g_varchar2
1470 ,p_update_allowed in number default hr_api.g_number
1471 ,p_validation_formula_id in number default hr_api.g_number
1472 ,p_validation_param_item_id1 in number default hr_api.g_number
1473 ,p_validation_param_item_id2 in number default hr_api.g_number
1474 ,p_validation_param_item_id3 in number default hr_api.g_number
1475 ,p_validation_param_item_id4 in number default hr_api.g_number
1476 ,p_validation_param_item_id5 in number default hr_api.g_number
1477 ,p_visible in number default hr_api.g_number
1478 ,p_width in number default hr_api.g_number
1479 ,p_x_position in number default hr_api.g_number
1480 ,p_y_position in number default hr_api.g_number
1481 ,p_information_category in varchar2 default hr_api.g_varchar2
1482 ,p_information1 in varchar2 default hr_api.g_varchar2
1483 ,p_information2 in varchar2 default hr_api.g_varchar2
1484 ,p_information3 in varchar2 default hr_api.g_varchar2
1485 ,p_information4 in varchar2 default hr_api.g_varchar2
1486 ,p_information5 in varchar2 default hr_api.g_varchar2
1487 ,p_information6 in varchar2 default hr_api.g_varchar2
1488 ,p_information7 in varchar2 default hr_api.g_varchar2
1489 ,p_information8 in varchar2 default hr_api.g_varchar2
1490 ,p_information9 in varchar2 default hr_api.g_varchar2
1491 ,p_information10 in varchar2 default hr_api.g_varchar2
1492 ,p_information11 in varchar2 default hr_api.g_varchar2
1493 ,p_information12 in varchar2 default hr_api.g_varchar2
1494 ,p_information13 in varchar2 default hr_api.g_varchar2
1495 ,p_information14 in varchar2 default hr_api.g_varchar2
1496 ,p_information15 in varchar2 default hr_api.g_varchar2
1497 ,p_information16 in varchar2 default hr_api.g_varchar2
1498 ,p_information17 in varchar2 default hr_api.g_varchar2
1499 ,p_information18 in varchar2 default hr_api.g_varchar2
1500 ,p_information19 in varchar2 default hr_api.g_varchar2
1501 ,p_information20 in varchar2 default hr_api.g_varchar2
1502 ,p_information21 in varchar2 default hr_api.g_varchar2
1503 ,p_information22 in varchar2 default hr_api.g_varchar2
1504 ,p_information23 in varchar2 default hr_api.g_varchar2
1505 ,p_information24 in varchar2 default hr_api.g_varchar2
1506 ,p_information25 in varchar2 default hr_api.g_varchar2
1507 ,p_information26 in varchar2 default hr_api.g_varchar2
1508 ,p_information27 in varchar2 default hr_api.g_varchar2
1509 ,p_information28 in varchar2 default hr_api.g_varchar2
1510 ,p_information29 in varchar2 default hr_api.g_varchar2
1511 ,p_information30 in varchar2 default hr_api.g_varchar2
1512 ,p_next_navigation_item_id in number default hr_api.g_number
1513 ,p_previous_navigation_item_id in number default hr_api.g_number
1514 ,p_item_property_id out nocopy number
1515 ,p_object_version_number out nocopy number
1516 --,p_override_value_warning out boolean
1517 ) is
1518 --
1519 -- Declare cursors and local variables
1520 --
1521
1522 Type l_rec_type Is Record
1523 (alignment hr_item_properties_b.alignment%TYPE
1524 ,bevel hr_item_properties_b.bevel%TYPE
1525 ,case_restriction hr_item_properties_b.case_restriction%TYPE
1526 ,enabled hr_item_properties_b.enabled%TYPE
1527 ,format_mask hr_item_properties_b.format_mask%TYPE
1528 ,height hr_item_properties_b.height%TYPE
1529 ,information_formula_id hr_item_properties_b.information_formula_id%TYPE
1530 ,information_param_item_id1 hr_item_properties_b.information_parameter_item_id1%TYPE
1531 ,information_param_item_id2 hr_item_properties_b.information_parameter_item_id2%TYPE
1532 ,information_param_item_id3 hr_item_properties_b.information_parameter_item_id3%TYPE
1533 ,information_param_item_id4 hr_item_properties_b.information_parameter_item_id4%TYPE
1534 ,information_param_item_id5 hr_item_properties_b.information_parameter_item_id5%TYPE
1535 ,insert_allowed hr_item_properties_b.insert_allowed%TYPE
1536 ,prompt_alignment_offset hr_item_properties_b.prompt_alignment_offset%TYPE
1537 ,prompt_display_style hr_item_properties_b.prompt_display_style%TYPE
1538 ,prompt_edge hr_item_properties_b.prompt_edge%TYPE
1539 ,prompt_edge_alignment hr_item_properties_b.prompt_edge_alignment%TYPE
1540 ,prompt_edge_offset hr_item_properties_b.prompt_edge_offset%TYPE
1541 ,prompt_text_alignment hr_item_properties_b.prompt_text_alignment%TYPE
1542 ,query_allowed hr_item_properties_b.query_allowed%TYPE
1543 ,required hr_item_properties_b.required%TYPE
1544 ,update_allowed hr_item_properties_b.update_allowed%TYPE
1545 ,validation_formula_id hr_item_properties_b.validation_formula_id%TYPE
1546 ,validation_param_item_id1 hr_item_properties_b.validation_parameter_item_id1%TYPE
1547 ,validation_param_item_id2 hr_item_properties_b.validation_parameter_item_id2%TYPE
1548 ,validation_param_item_id3 hr_item_properties_b.validation_parameter_item_id3%TYPE
1549 ,validation_param_item_id4 hr_item_properties_b.validation_parameter_item_id4%TYPE
1550 ,validation_param_item_id5 hr_item_properties_b.validation_parameter_item_id5%TYPE
1551 ,visible hr_item_properties_b.visible%TYPE
1552 ,width hr_item_properties_b.width%TYPE
1553 ,x_position hr_item_properties_b.x_position%TYPE
1554 ,y_position hr_item_properties_b.y_position%TYPE
1555 ,information_category hr_item_properties_b.information_category%TYPE
1556 ,information1 hr_item_properties_b.information1%TYPE
1557 ,information2 hr_item_properties_b.information2%TYPE
1558 ,information3 hr_item_properties_b.information3%TYPE
1559 ,information4 hr_item_properties_b.information4%TYPE
1560 ,information5 hr_item_properties_b.information5%TYPE
1561 ,information6 hr_item_properties_b.information6%TYPE
1562 ,information7 hr_item_properties_b.information7%TYPE
1563 ,information8 hr_item_properties_b.information8%TYPE
1564 ,information9 hr_item_properties_b.information9%TYPE
1565 ,information10 hr_item_properties_b.information10%TYPE
1566 ,information11 hr_item_properties_b.information11%TYPE
1567 ,information12 hr_item_properties_b.information12%TYPE
1568 ,information13 hr_item_properties_b.information13%TYPE
1569 ,information14 hr_item_properties_b.information14%TYPE
1570 ,information15 hr_item_properties_b.information15%TYPE
1571 ,information16 hr_item_properties_b.information16%TYPE
1572 ,information17 hr_item_properties_b.information17%TYPE
1573 ,information18 hr_item_properties_b.information18%TYPE
1574 ,information19 hr_item_properties_b.information19%TYPE
1575 ,information20 hr_item_properties_b.information20%TYPE
1576 ,information21 hr_item_properties_b.information21%TYPE
1577 ,information22 hr_item_properties_b.information22%TYPE
1578 ,information23 hr_item_properties_b.information23%TYPE
1579 ,information24 hr_item_properties_b.information24%TYPE
1580 ,information25 hr_item_properties_b.information25%TYPE
1581 ,information26 hr_item_properties_b.information26%TYPE
1582 ,information27 hr_item_properties_b.information27%TYPE
1583 ,information28 hr_item_properties_b.information28%TYPE
1584 ,information29 hr_item_properties_b.information29%TYPE
1585 ,information30 hr_item_properties_b.information30%TYPE
1586 ,next_navigation_item_id hr_item_properties_b.next_navigation_item_id%TYPE
1587 ,previous_navigation_item_id hr_item_properties_b.previous_navigation_item_id%TYPE
1588 );
1589
1590 l_rec l_rec_type;
1591
1592 CURSOR cur_check
1593 IS
1594 SELECT 1
1595 FROM hr_template_item_contexts tic
1596 WHERE tic.template_item_context_id = p_template_item_context_id
1597 AND tic.template_item_id = p_template_item_id;
1598
1599 -- added a outer join so that the correct values are returned
1600 -- if there are no entries in the properties table
1601 CURSOR cur_item_prop
1602 IS
1603 SELECT DECODE(p_alignment,hr_api.g_number,itp.alignment,p_alignment)
1604 ,DECODE(p_bevel,hr_api.g_number,itp.bevel,p_bevel)
1605 ,DECODE(p_case_restriction,hr_api.g_number,itp.case_restriction,p_case_restriction)
1606 ,DECODE(p_enabled,hr_api.g_number,itp.enabled,p_enabled)
1607 ,DECODE(p_format_mask,hr_api.g_varchar2,itp.format_mask,p_format_mask)
1608 ,DECODE(p_height,hr_api.g_number,itp.height,p_height)
1609 ,DECODE(p_information_formula_id,hr_api.g_number,itp.information_formula_id,p_information_formula_id)
1610 ,DECODE(p_information_param_item_id1,hr_api.g_number,itp.information_parameter_item_id1,p_information_param_item_id1)
1611 ,DECODE(p_information_param_item_id2,hr_api.g_number,itp.information_parameter_item_id2,p_information_param_item_id2)
1612 ,DECODE(p_information_param_item_id3,hr_api.g_number,itp.information_parameter_item_id3,p_information_param_item_id3)
1613 ,DECODE(p_information_param_item_id4,hr_api.g_number,itp.information_parameter_item_id4,p_information_param_item_id4)
1614 ,DECODE(p_information_param_item_id5,hr_api.g_number,itp.information_parameter_item_id5,p_information_param_item_id5)
1615 ,DECODE(p_insert_allowed,hr_api.g_number,itp.insert_allowed,p_insert_allowed)
1616 ,DECODE(p_prompt_alignment_offset,hr_api.g_number,itp.prompt_alignment_offset,p_prompt_alignment_offset)
1617 ,DECODE(p_prompt_display_style,hr_api.g_number,itp.prompt_display_style,p_prompt_display_style)
1618 ,DECODE(p_prompt_edge,hr_api.g_number,itp.prompt_edge,p_prompt_edge)
1619 ,DECODE(p_prompt_edge_alignment,hr_api.g_number,itp.prompt_edge_alignment,p_prompt_edge_alignment)
1620 ,DECODE(p_prompt_edge_offset,hr_api.g_number,itp.prompt_edge_offset,p_prompt_edge_offset)
1621 ,DECODE(p_prompt_text_alignment,hr_api.g_number,itp.prompt_text_alignment,p_prompt_text_alignment)
1622 ,DECODE(p_query_allowed,hr_api.g_number,itp.query_allowed,p_query_allowed)
1623 ,DECODE(p_required,hr_api.g_number,itp.required,p_required)
1624 ,DECODE(p_update_allowed,hr_api.g_number,itp.update_allowed,p_update_allowed)
1625 ,DECODE(p_validation_formula_id,hr_api.g_number,itp.validation_formula_id,p_validation_formula_id)
1626 ,DECODE(p_validation_param_item_id1,hr_api.g_number,itp.validation_parameter_item_id1,p_validation_param_item_id1)
1627 ,DECODE(p_validation_param_item_id2,hr_api.g_number,itp.validation_parameter_item_id2,p_validation_param_item_id2)
1628 ,DECODE(p_validation_param_item_id3,hr_api.g_number,itp.validation_parameter_item_id3,p_validation_param_item_id3)
1629 ,DECODE(p_validation_param_item_id4,hr_api.g_number,itp.validation_parameter_item_id4,p_validation_param_item_id4)
1630 ,DECODE(p_validation_param_item_id5,hr_api.g_number,itp.validation_parameter_item_id5,p_validation_param_item_id5)
1631 ,DECODE(p_visible,hr_api.g_number,itp.visible,p_visible)
1632 ,DECODE(p_width,hr_api.g_number,itp.width,p_width)
1633 ,DECODE(p_x_position,hr_api.g_number,itp.x_position,p_x_position)
1634 ,DECODE(p_y_position,hr_api.g_number,itp.y_position,p_y_position)
1635 ,DECODE(p_information_category,hr_api.g_varchar2,itp.information_category,p_information_category)
1636 ,DECODE(p_information1,hr_api.g_varchar2,itp.information1,p_information1)
1637 ,DECODE(p_information2,hr_api.g_varchar2,itp.information2,p_information2)
1638 ,DECODE(p_information3,hr_api.g_varchar2,itp.information3,p_information3)
1639 ,DECODE(p_information4,hr_api.g_varchar2,itp.information4,p_information4)
1640 ,DECODE(p_information5,hr_api.g_varchar2,itp.information5,p_information5)
1641 ,DECODE(p_information6,hr_api.g_varchar2,itp.information6,p_information6)
1642 ,DECODE(p_information7,hr_api.g_varchar2,itp.information7,p_information7)
1643 ,DECODE(p_information8,hr_api.g_varchar2,itp.information8,p_information8)
1644 ,DECODE(p_information9,hr_api.g_varchar2,itp.information9,p_information9)
1645 ,DECODE(p_information10,hr_api.g_varchar2,itp.information10,p_information10)
1646 ,DECODE(p_information11,hr_api.g_varchar2,itp.information11,p_information11)
1647 ,DECODE(p_information12,hr_api.g_varchar2,itp.information12,p_information12)
1648 ,DECODE(p_information13,hr_api.g_varchar2,itp.information13,p_information13)
1649 ,DECODE(p_information14,hr_api.g_varchar2,itp.information14,p_information14)
1650 ,DECODE(p_information15,hr_api.g_varchar2,itp.information15,p_information15)
1651 ,DECODE(p_information16,hr_api.g_varchar2,itp.information16,p_information16)
1652 ,DECODE(p_information17,hr_api.g_varchar2,itp.information17,p_information17)
1653 ,DECODE(p_information18,hr_api.g_varchar2,itp.information18,p_information18)
1654 ,DECODE(p_information19,hr_api.g_varchar2,itp.information19,p_information19)
1655 ,DECODE(p_information20,hr_api.g_varchar2,itp.information20,p_information20)
1656 ,DECODE(p_information21,hr_api.g_varchar2,itp.information21,p_information21)
1657 ,DECODE(p_information22,hr_api.g_varchar2,itp.information22,p_information22)
1658 ,DECODE(p_information23,hr_api.g_varchar2,itp.information23,p_information23)
1659 ,DECODE(p_information24,hr_api.g_varchar2,itp.information24,p_information24)
1660 ,DECODE(p_information25,hr_api.g_varchar2,itp.information25,p_information25)
1661 ,DECODE(p_information26,hr_api.g_varchar2,itp.information26,p_information26)
1662 ,DECODE(p_information27,hr_api.g_varchar2,itp.information27,p_information27)
1663 ,DECODE(p_information28,hr_api.g_varchar2,itp.information28,p_information28)
1664 ,DECODE(p_information29,hr_api.g_varchar2,itp.information29,p_information29)
1665 ,DECODE(p_information30,hr_api.g_varchar2,itp.information30,p_information30)
1666 ,DECODE(p_next_navigation_item_id,hr_api.g_number,itp.next_navigation_item_id,p_next_navigation_item_id)
1667 ,DECODE(p_previous_navigation_item_id,hr_api.g_number,itp.previous_navigation_item_id,p_previous_navigation_item_id)
1668 FROM hr_item_properties_b itp
1669 , hr_template_items_b hti
1670 WHERE itp.template_item_id (+) = hti.template_item_id
1671 AND hti.template_item_id = p_template_item_id;
1672
1673 CURSOR cur_item_tl
1674 IS
1675 SELECT COUNT(0) t_count
1676 ,itptl.source_lang
1677 ,DECODE(p_default_value,hr_api.g_varchar2,itptl.default_value,p_default_value) default_value
1678 ,DECODE(p_information_prompt,hr_api.g_varchar2,itptl.information_prompt,p_information_prompt) information_prompt
1679 ,DECODE(p_label,hr_api.g_varchar2,itptl.label,p_label) label
1680 ,DECODE(p_prompt_text,hr_api.g_varchar2,itptl.prompt_text,p_prompt_text) prompt_text
1681 ,DECODE(p_tooltip_text,hr_api.g_varchar2,itptl.tooltip_text,p_tooltip_text) tooltip_text
1682 FROM hr_item_properties_tl itptl
1683 ,hr_item_properties_b itp
1684 WHERE itptl.item_property_id = itp.item_property_id
1685 AND itp.template_item_id = p_template_item_id
1686 GROUP BY itptl.source_lang
1687 ,DECODE(p_default_value,hr_api.g_varchar2,itptl.default_value,p_default_value)
1688 ,DECODE(p_information_prompt,hr_api.g_varchar2,itptl.information_prompt,p_information_prompt)
1689 ,DECODE(p_label,hr_api.g_varchar2,itptl.label,p_label)
1690 ,DECODE(p_prompt_text,hr_api.g_varchar2,itptl.prompt_text,p_prompt_text)
1691 ,DECODE(p_tooltip_text,hr_api.g_varchar2,itptl.tooltip_text,p_tooltip_text)
1692 ORDER BY 1;
1693
1694 l_language_code fnd_languages.language_code%TYPE;
1695
1696 l_check number;
1697 l_item_property_id number ;
1698 l_object_version_number number;
1699 l_override_value_warning boolean;
1700 l_proc varchar2(72) := g_package||'copy_item_property';
1701 begin
1702 hr_utility.set_location('Entering:'|| l_proc, 10);
1703 --
1704 -- Issue a savepoint
1705 --
1706 savepoint copy_item_property;
1707 --
1708 -- Truncate the time portion from all IN date parameters
1709 --
1710
1711 --
1712 -- Validate the language parameter. l_language_code should be passed
1713 -- instead of p_language_code from now on, to allow an IN OUT parameter to
1714 -- be passed through.
1715 --
1716 l_language_code := p_language_code;
1717 hr_api.validate_language_code(p_language_code => l_language_code);
1718 --
1719 hr_utility.set_location(l_proc, 20);
1720 --
1721 --
1722 -- Validation in addition to Row Handlers
1723 --
1724 hr_utility.set_location('At:'|| l_proc, 15);
1725
1726 OPEN cur_check;
1727 FETCH cur_check INTO l_check;
1728 IF cur_check%NOTFOUND THEN
1729 CLOSE cur_check;
1730 -- error message
1731 fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1732 fnd_message.set_token('PROCEDURE', l_proc);
1733 fnd_message.set_token('STEP','10');
1734 fnd_message.raise_error;
1735 END IF;
1736 CLOSE cur_check;
1737 --
1738 -- Process Logic
1739 --
1740 hr_utility.set_location('At:'|| l_proc, 20);
1741
1742 OPEN cur_item_prop;
1743 FETCH cur_item_prop INTO l_rec;
1744 CLOSE cur_item_prop;
1745
1746 hr_utility.set_location('At:'|| l_proc, 25);
1747
1748 hr_itp_ins.ins(p_effective_date => TRUNC(p_effective_date)
1749 ,p_template_item_context_id => p_template_item_context_id
1750 ,p_alignment => l_rec.alignment
1751 ,p_bevel => l_rec.bevel
1752 ,p_case_restriction => l_rec.case_restriction
1753 ,p_enabled => l_rec.enabled
1754 ,p_format_mask => l_rec.format_mask
1755 ,p_height => l_rec.height
1756 ,p_information_formula_id => l_rec.information_formula_id
1757 ,p_information_param_item_id1 => l_rec.information_param_item_id1
1758 ,p_information_param_item_id2 => l_rec.information_param_item_id2
1759 ,p_information_param_item_id3 => l_rec.information_param_item_id3
1760 ,p_information_param_item_id4 => l_rec.information_param_item_id4
1761 ,p_information_param_item_id5 => l_rec.information_param_item_id5
1762 ,p_insert_allowed => l_rec.insert_allowed
1763 ,p_prompt_alignment_offset => l_rec.prompt_alignment_offset
1764 ,p_prompt_display_style => l_rec.prompt_display_style
1765 ,p_prompt_edge => l_rec.prompt_edge
1766 ,p_prompt_edge_alignment => l_rec.prompt_edge_alignment
1767 ,p_prompt_edge_offset => l_rec.prompt_edge_offset
1768 ,p_prompt_text_alignment => l_rec.prompt_text_alignment
1769 ,p_query_allowed => l_rec.query_allowed
1770 ,p_required => l_rec.required
1771 ,p_update_allowed => l_rec.update_allowed
1772 ,p_validation_formula_id => l_rec.validation_formula_id
1773 ,p_validation_param_item_id1 => l_rec.validation_param_item_id1
1774 ,p_validation_param_item_id2 => l_rec.validation_param_item_id2
1775 ,p_validation_param_item_id3 => l_rec.validation_param_item_id3
1776 ,p_validation_param_item_id4 => l_rec.validation_param_item_id4
1777 ,p_validation_param_item_id5 => l_rec.validation_param_item_id5
1778 ,p_visible => l_rec.visible
1779 ,p_width => l_rec.width
1780 ,p_x_position => l_rec.x_position
1781 ,p_y_position => l_rec.y_position
1782 ,p_information_category => l_rec.information_category
1783 ,p_information1 => l_rec.information1
1784 ,p_information2 => l_rec.information2
1785 ,p_information3 => l_rec.information3
1786 ,p_information4 => l_rec.information4
1787 ,p_information5 => l_rec.information5
1788 ,p_information6 => l_rec.information6
1789 ,p_information7 => l_rec.information7
1790 ,p_information8 => l_rec.information8
1791 ,p_information9 => l_rec.information9
1792 ,p_information10 => l_rec.information10
1793 ,p_information11 => l_rec.information11
1794 ,p_information12 => l_rec.information12
1795 ,p_information13 => l_rec.information13
1796 ,p_information14 => l_rec.information14
1797 ,p_information15 => l_rec.information15
1798 ,p_information16 => l_rec.information16
1799 ,p_information17 => l_rec.information17
1800 ,p_information18 => l_rec.information18
1801 ,p_information19 => l_rec.information19
1802 ,p_information20 => l_rec.information20
1803 ,p_information21 => l_rec.information21
1804 ,p_information22 => l_rec.information22
1805 ,p_information23 => l_rec.information23
1806 ,p_information24 => l_rec.information24
1807 ,p_information25 => l_rec.information25
1808 ,p_information26 => l_rec.information26
1809 ,p_information27 => l_rec.information27
1810 ,p_information28 => l_rec.information28
1811 ,p_information29 => l_rec.information29
1812 ,p_information30 => l_rec.information30
1813 ,p_next_navigation_item_id => l_rec.next_navigation_item_id
1814 ,p_previous_navigation_item_id => l_rec.previous_navigation_item_id
1815 ,p_item_property_id => l_item_property_id
1816 ,p_object_version_number => l_object_version_number);
1817 --,p_override_value_warning => l_override_value_warning);
1818
1819 hr_utility.set_location('At:'|| l_proc, 30);
1820
1821 IF (p_default_value <> hr_api.g_varchar2)
1822 AND ( p_information_prompt <> hr_api.g_varchar2)
1823 AND ( p_label <> hr_api.g_varchar2 )
1824 AND ( p_prompt_text <> hr_api.g_varchar2 )
1825 AND ( p_tooltip_text <> hr_api.g_varchar2 ) THEN
1826
1827 hr_utility.set_location('At:'|| l_proc, 35);
1828
1829 hr_ipt_ins.ins_tl(p_language_code => l_language_code
1830 ,p_item_property_id => l_item_property_id
1831 ,p_default_value => p_default_value
1832 ,p_information_prompt => p_information_prompt
1833 ,p_label => p_label
1834 ,p_prompt_text => p_prompt_text
1835 ,p_tooltip_text => p_tooltip_text);
1836
1837 ELSE
1838 hr_utility.set_location('At:'|| l_proc, 40);
1839
1840 FOR cur_rec in cur_item_tl LOOP
1841 IF cur_item_tl%ROWCOUNT = 1 THEN
1842 hr_utility.set_location('At:'|| l_proc, 45);
1843
1844 hr_ipt_ins.ins_tl(p_language_code => cur_rec.source_lang
1845 ,p_item_property_id => l_item_property_id
1846 ,p_default_value => cur_rec.default_value
1847 ,p_information_prompt => cur_rec.information_prompt
1848 ,p_label => cur_rec.label
1849 ,p_prompt_text => cur_rec.prompt_text
1850 ,p_tooltip_text => cur_rec.tooltip_text);
1851 ELSE
1852 hr_utility.set_location('At:'|| l_proc, 50);
1853
1854 hr_ipt_upd.upd_tl(p_language_code => cur_rec.source_lang
1855 ,p_item_property_id => l_item_property_id
1856 ,p_default_value => cur_rec.default_value
1857 ,p_information_prompt => cur_rec.information_prompt
1858 ,p_label => cur_rec.label
1859 ,p_prompt_text => cur_rec.prompt_text
1860 ,p_tooltip_text => cur_rec.tooltip_text);
1861 END IF;
1862 END LOOP;
1863 END IF;
1864 --
1865 -- Update properties common across all buttons of a radio group
1866 --
1867 update_radio_button_property
1868 (p_effective_date => TRUNC(p_effective_date)
1869 ,p_language_code => l_language_code
1870 ,p_form_item_id => NULL
1871 ,p_template_item_id => NULL
1872 ,p_template_item_context_id => p_template_item_context_id
1873 ,p_default_value => p_default_value
1874 ,p_information_formula_id => l_rec.information_formula_id
1875 ,p_information_param_item_id1 => l_rec.information_param_item_id1
1876 ,p_information_param_item_id2 => l_rec.information_param_item_id2
1877 ,p_information_param_item_id3 => l_rec.information_param_item_id3
1878 ,p_information_param_item_id4 => l_rec.information_param_item_id4
1879 ,p_information_param_item_id5 => l_rec.information_param_item_id5
1880 ,p_information_prompt => p_information_prompt
1881 ,p_insert_allowed => l_rec.insert_allowed
1882 ,p_next_navigation_item_id => l_rec.next_navigation_item_id
1883 ,p_previous_navigation_item_id => l_rec.previous_navigation_item_id
1884 ,p_query_allowed => l_rec.query_allowed
1885 ,p_tooltip_text => p_tooltip_text
1886 ,p_update_allowed => l_rec.update_allowed
1887 ,p_validation_formula_id => l_rec.validation_formula_id
1888 ,p_validation_param_item_id1 => l_rec.validation_param_item_id1
1889 ,p_validation_param_item_id2 => l_rec.validation_param_item_id2
1890 ,p_validation_param_item_id3 => l_rec.validation_param_item_id3
1891 ,p_validation_param_item_id4 => l_rec.validation_param_item_id4
1892 ,p_validation_param_item_id5 => l_rec.validation_param_item_id5
1893 ,p_object_version_number => l_object_version_number
1894 );
1895 --
1896 -- When in validation only mode raise the Validate_Enabled exception
1897 --
1898 hr_utility.set_location('At:'|| l_proc, 55);
1899
1900 if p_validate then
1901 raise hr_api.validate_enabled;
1902 end if;
1903 --
1904 -- Set all output arguments
1905 --
1906 p_item_property_id := l_item_property_id;
1907 p_object_version_number := l_object_version_number;
1908 --p_override_value_warning := l_override_value_warning;
1909 --
1910 hr_utility.set_location(' Leaving:'||l_proc, 70);
1911 exception
1912 when hr_api.validate_enabled then
1913 --
1914 -- As the Validate_Enabled exception has been raised
1915 -- we must rollback to the savepoint
1916 --
1917 rollback to copy_item_property;
1918 --
1919 -- Only set output warning arguments
1920 -- (Any key or derived arguments must be set to null
1921 -- when validation only mode is being used.)
1922 --
1923 p_item_property_id := null;
1924 --p_override_value_warning := null;
1925 hr_utility.set_location(' Leaving:'||l_proc, 80);
1926 when others then
1927 --
1928 -- A validation or unexpected error has occured
1929 --
1930 rollback to copy_item_property;
1931 hr_utility.set_location(' Leaving:'||l_proc, 90);
1932 raise;
1933 end copy_item_property;
1934 --
1935 --
1936 -- ----------------------------------------------------------------------------
1937 -- |--------------------< copy_item_property - overload 2>--------------------|
1938 -- ----------------------------------------------------------------------------
1939 --
1940 procedure copy_item_property
1941 (p_validate in boolean default false
1942 ,p_effective_date in date
1943 ,p_language_code in varchar2 default hr_api.userenv_lang
1944 ,p_template_item_id_from in number
1945 ,p_template_item_id_to in number
1946 ,p_alignment in number default hr_api.g_number
1947 ,p_bevel in number default hr_api.g_number
1948 ,p_case_restriction in number default hr_api.g_number
1949 ,p_default_value in varchar2 default hr_api.g_varchar2
1950 ,p_enabled in number default hr_api.g_number
1951 ,p_format_mask in varchar2 default hr_api.g_varchar2
1952 ,p_height in number default hr_api.g_number
1953 ,p_information_formula_id in number default hr_api.g_number
1954 ,p_information_param_item_id1 in number default hr_api.g_number
1955 ,p_information_param_item_id2 in number default hr_api.g_number
1956 ,p_information_param_item_id3 in number default hr_api.g_number
1957 ,p_information_param_item_id4 in number default hr_api.g_number
1958 ,p_information_param_item_id5 in number default hr_api.g_number
1959 ,p_information_prompt in varchar2 default hr_api.g_varchar2
1960 ,p_insert_allowed in number default hr_api.g_number
1961 ,p_label in varchar2 default hr_api.g_varchar2
1962 ,p_prompt_text in varchar2 default hr_api.g_varchar2
1963 ,p_prompt_alignment_offset in number default hr_api.g_number
1964 ,p_prompt_display_style in number default hr_api.g_number
1965 ,p_prompt_edge in number default hr_api.g_number
1966 ,p_prompt_edge_alignment in number default hr_api.g_number
1967 ,p_prompt_edge_offset in number default hr_api.g_number
1968 ,p_prompt_text_alignment in number default hr_api.g_number
1969 ,p_query_allowed in number default hr_api.g_number
1970 ,p_required in number default hr_api.g_number
1971 ,p_tooltip_text in varchar2 default hr_api.g_varchar2
1972 ,p_update_allowed in number default hr_api.g_number
1973 ,p_validation_formula_id in number default hr_api.g_number
1974 ,p_validation_param_item_id1 in number default hr_api.g_number
1975 ,p_validation_param_item_id2 in number default hr_api.g_number
1976 ,p_validation_param_item_id3 in number default hr_api.g_number
1977 ,p_validation_param_item_id4 in number default hr_api.g_number
1978 ,p_validation_param_item_id5 in number default hr_api.g_number
1979 ,p_visible in number default hr_api.g_number
1980 ,p_width in number default hr_api.g_number
1981 ,p_x_position in number default hr_api.g_number
1982 ,p_y_position in number default hr_api.g_number
1983 ,p_information_category in varchar2 default hr_api.g_varchar2
1984 ,p_information1 in varchar2 default hr_api.g_varchar2
1985 ,p_information2 in varchar2 default hr_api.g_varchar2
1986 ,p_information3 in varchar2 default hr_api.g_varchar2
1987 ,p_information4 in varchar2 default hr_api.g_varchar2
1988 ,p_information5 in varchar2 default hr_api.g_varchar2
1989 ,p_information6 in varchar2 default hr_api.g_varchar2
1990 ,p_information7 in varchar2 default hr_api.g_varchar2
1991 ,p_information8 in varchar2 default hr_api.g_varchar2
1992 ,p_information9 in varchar2 default hr_api.g_varchar2
1993 ,p_information10 in varchar2 default hr_api.g_varchar2
1994 ,p_information11 in varchar2 default hr_api.g_varchar2
1995 ,p_information12 in varchar2 default hr_api.g_varchar2
1996 ,p_information13 in varchar2 default hr_api.g_varchar2
1997 ,p_information14 in varchar2 default hr_api.g_varchar2
1998 ,p_information15 in varchar2 default hr_api.g_varchar2
1999 ,p_information16 in varchar2 default hr_api.g_varchar2
2000 ,p_information17 in varchar2 default hr_api.g_varchar2
2001 ,p_information18 in varchar2 default hr_api.g_varchar2
2002 ,p_information19 in varchar2 default hr_api.g_varchar2
2003 ,p_information20 in varchar2 default hr_api.g_varchar2
2004 ,p_information21 in varchar2 default hr_api.g_varchar2
2005 ,p_information22 in varchar2 default hr_api.g_varchar2
2006 ,p_information23 in varchar2 default hr_api.g_varchar2
2007 ,p_information24 in varchar2 default hr_api.g_varchar2
2008 ,p_information25 in varchar2 default hr_api.g_varchar2
2009 ,p_information26 in varchar2 default hr_api.g_varchar2
2010 ,p_information27 in varchar2 default hr_api.g_varchar2
2011 ,p_information28 in varchar2 default hr_api.g_varchar2
2012 ,p_information29 in varchar2 default hr_api.g_varchar2
2013 ,p_information30 in varchar2 default hr_api.g_varchar2
2014 ,p_next_navigation_item_id in number default hr_api.g_number
2015 ,p_previous_navigation_item_id in number default hr_api.g_number
2016 ,p_item_property_id out nocopy number
2017 ,p_object_version_number out nocopy number
2018 --,p_override_value_warning out boolean
2019 ) is
2020 --
2021 -- Declare cursors and local variables
2022 --
2023
2024 Type l_rec_type Is Record
2025 (alignment hr_item_properties_b.alignment%TYPE
2026 ,bevel hr_item_properties_b.bevel%TYPE
2027 ,case_restriction hr_item_properties_b.case_restriction%TYPE
2028 ,enabled hr_item_properties_b.enabled%TYPE
2029 ,format_mask hr_item_properties_b.format_mask%TYPE
2030 ,height hr_item_properties_b.height%TYPE
2031 ,information_formula_id hr_item_properties_b.information_formula_id%TYPE
2032 ,information_param_item_id1 hr_item_properties_b.information_parameter_item_id1%TYPE
2033 ,information_param_item_id2 hr_item_properties_b.information_parameter_item_id2%TYPE
2034 ,information_param_item_id3 hr_item_properties_b.information_parameter_item_id3%TYPE
2035 ,information_param_item_id4 hr_item_properties_b.information_parameter_item_id4%TYPE
2036 ,information_param_item_id5 hr_item_properties_b.information_parameter_item_id5%TYPE
2037 ,insert_allowed hr_item_properties_b.insert_allowed%TYPE
2038 ,prompt_alignment_offset hr_item_properties_b.prompt_alignment_offset%TYPE
2039 ,prompt_display_style hr_item_properties_b.prompt_display_style%TYPE
2040 ,prompt_edge hr_item_properties_b.prompt_edge%TYPE
2041 ,prompt_edge_alignment hr_item_properties_b.prompt_edge_alignment%TYPE
2042 ,prompt_edge_offset hr_item_properties_b.prompt_edge_offset%TYPE
2043 ,prompt_text_alignment hr_item_properties_b.prompt_text_alignment%TYPE
2044 ,query_allowed hr_item_properties_b.query_allowed%TYPE
2045 ,required hr_item_properties_b.required%TYPE
2046 ,update_allowed hr_item_properties_b.update_allowed%TYPE
2047 ,validation_formula_id hr_item_properties_b.validation_formula_id%TYPE
2048 ,validation_param_item_id1 hr_item_properties_b.validation_parameter_item_id1%TYPE
2049 ,validation_param_item_id2 hr_item_properties_b.validation_parameter_item_id2%TYPE
2050 ,validation_param_item_id3 hr_item_properties_b.validation_parameter_item_id3%TYPE
2051 ,validation_param_item_id4 hr_item_properties_b.validation_parameter_item_id4%TYPE
2052 ,validation_param_item_id5 hr_item_properties_b.validation_parameter_item_id5%TYPE
2053 ,visible hr_item_properties_b.visible%TYPE
2054 ,width hr_item_properties_b.width%TYPE
2055 ,x_position hr_item_properties_b.x_position%TYPE
2056 ,y_position hr_item_properties_b.y_position%TYPE
2057 ,information_category hr_item_properties_b.information_category%TYPE
2058 ,information1 hr_item_properties_b.information1%TYPE
2059 ,information2 hr_item_properties_b.information2%TYPE
2060 ,information3 hr_item_properties_b.information3%TYPE
2061 ,information4 hr_item_properties_b.information4%TYPE
2062 ,information5 hr_item_properties_b.information5%TYPE
2063 ,information6 hr_item_properties_b.information6%TYPE
2064 ,information7 hr_item_properties_b.information7%TYPE
2065 ,information8 hr_item_properties_b.information8%TYPE
2066 ,information9 hr_item_properties_b.information9%TYPE
2067 ,information10 hr_item_properties_b.information10%TYPE
2068 ,information11 hr_item_properties_b.information11%TYPE
2069 ,information12 hr_item_properties_b.information12%TYPE
2070 ,information13 hr_item_properties_b.information13%TYPE
2071 ,information14 hr_item_properties_b.information14%TYPE
2072 ,information15 hr_item_properties_b.information15%TYPE
2073 ,information16 hr_item_properties_b.information16%TYPE
2074 ,information17 hr_item_properties_b.information17%TYPE
2075 ,information18 hr_item_properties_b.information18%TYPE
2076 ,information19 hr_item_properties_b.information19%TYPE
2077 ,information20 hr_item_properties_b.information20%TYPE
2078 ,information21 hr_item_properties_b.information21%TYPE
2079 ,information22 hr_item_properties_b.information22%TYPE
2080 ,information23 hr_item_properties_b.information23%TYPE
2081 ,information24 hr_item_properties_b.information24%TYPE
2082 ,information25 hr_item_properties_b.information25%TYPE
2083 ,information26 hr_item_properties_b.information26%TYPE
2084 ,information27 hr_item_properties_b.information27%TYPE
2085 ,information28 hr_item_properties_b.information28%TYPE
2086 ,information29 hr_item_properties_b.information29%TYPE
2087 ,information30 hr_item_properties_b.information30%TYPE
2088 ,next_navigation_item_id hr_item_properties_b.next_navigation_item_id%TYPE
2089 ,previous_navigation_item_id hr_item_properties_b.previous_navigation_item_id%TYPE
2090 );
2091
2092 l_rec l_rec_type;
2093
2094 CURSOR cur_check
2095 IS
2096 SELECT tit.form_item_id
2097 FROM hr_template_items tit
2098 WHERE tit.template_item_id = p_template_item_id_from
2099 INTERSECT
2100 SELECT tit.form_item_id
2101 FROM hr_template_items tit
2102 WHERE tit.template_item_id = p_template_item_id_to;
2103
2104 CURSOR cur_item_prop
2105 IS
2106 SELECT DECODE(p_alignment,hr_api.g_number,itp.alignment,p_alignment)
2107 ,DECODE(p_bevel,hr_api.g_number,itp.bevel,p_bevel)
2108 ,DECODE(p_case_restriction,hr_api.g_number,itp.case_restriction,p_case_restriction)
2109 ,DECODE(p_enabled,hr_api.g_number,itp.enabled,p_enabled)
2110 ,DECODE(p_format_mask,hr_api.g_varchar2,itp.format_mask,p_format_mask)
2111 ,DECODE(p_height,hr_api.g_number,itp.height,p_height)
2112 ,DECODE(p_information_formula_id,hr_api.g_number,itp.information_formula_id,p_information_formula_id)
2113 ,DECODE(p_information_param_item_id1,hr_api.g_number,itp.information_parameter_item_id1,p_information_param_item_id1)
2114 ,DECODE(p_information_param_item_id2,hr_api.g_number,itp.information_parameter_item_id2,p_information_param_item_id2)
2115 ,DECODE(p_information_param_item_id3,hr_api.g_number,itp.information_parameter_item_id3,p_information_param_item_id3)
2116 ,DECODE(p_information_param_item_id4,hr_api.g_number,itp.information_parameter_item_id4,p_information_param_item_id4)
2117 ,DECODE(p_information_param_item_id5,hr_api.g_number,itp.information_parameter_item_id5,p_information_param_item_id5)
2118 ,DECODE(p_insert_allowed,hr_api.g_number,itp.insert_allowed,p_insert_allowed)
2119 ,DECODE(p_prompt_alignment_offset,hr_api.g_number,itp.prompt_alignment_offset,p_prompt_alignment_offset)
2120 ,DECODE(p_prompt_display_style,hr_api.g_number,itp.prompt_display_style,p_prompt_display_style)
2121 ,DECODE(p_prompt_edge,hr_api.g_number,itp.prompt_edge,p_prompt_edge)
2122 ,DECODE(p_prompt_edge_alignment,hr_api.g_number,itp.prompt_edge_alignment,p_prompt_edge_alignment)
2123 ,DECODE(p_prompt_edge_offset,hr_api.g_number,itp.prompt_edge_offset,p_prompt_edge_offset)
2124 ,DECODE(p_prompt_text_alignment,hr_api.g_number,itp.prompt_text_alignment,p_prompt_text_alignment)
2125 ,DECODE(p_query_allowed,hr_api.g_number,itp.query_allowed,p_query_allowed)
2126 ,DECODE(p_required,hr_api.g_number,itp.required,p_required)
2127 ,DECODE(p_update_allowed,hr_api.g_number,itp.update_allowed,p_update_allowed)
2128 ,DECODE(p_validation_formula_id,hr_api.g_number,itp.validation_formula_id,p_validation_formula_id)
2129 ,DECODE(p_validation_param_item_id1,hr_api.g_number,itp.validation_parameter_item_id1,p_validation_param_item_id1)
2130 ,DECODE(p_validation_param_item_id2,hr_api.g_number,itp.validation_parameter_item_id2,p_validation_param_item_id2)
2131 ,DECODE(p_validation_param_item_id3,hr_api.g_number,itp.validation_parameter_item_id3,p_validation_param_item_id3)
2132 ,DECODE(p_validation_param_item_id4,hr_api.g_number,itp.validation_parameter_item_id4,p_validation_param_item_id4)
2133 ,DECODE(p_validation_param_item_id5,hr_api.g_number,itp.validation_parameter_item_id5,p_validation_param_item_id5)
2134 ,DECODE(p_visible,hr_api.g_number,itp.visible,p_visible)
2135 ,DECODE(p_width,hr_api.g_number,itp.width,p_width)
2136 ,DECODE(p_x_position,hr_api.g_number,itp.x_position,p_x_position)
2137 ,DECODE(p_y_position,hr_api.g_number,itp.y_position,p_y_position)
2138 ,DECODE(p_information_category,hr_api.g_varchar2,itp.information_category,p_information_category)
2139 ,DECODE(p_information1,hr_api.g_varchar2,itp.information1,p_information1)
2140 ,DECODE(p_information2,hr_api.g_varchar2,itp.information2,p_information2)
2141 ,DECODE(p_information3,hr_api.g_varchar2,itp.information3,p_information3)
2142 ,DECODE(p_information4,hr_api.g_varchar2,itp.information4,p_information4)
2143 ,DECODE(p_information5,hr_api.g_varchar2,itp.information5,p_information5)
2144 ,DECODE(p_information6,hr_api.g_varchar2,itp.information6,p_information6)
2145 ,DECODE(p_information7,hr_api.g_varchar2,itp.information7,p_information7)
2146 ,DECODE(p_information8,hr_api.g_varchar2,itp.information8,p_information8)
2147 ,DECODE(p_information9,hr_api.g_varchar2,itp.information9,p_information9)
2148 ,DECODE(p_information10,hr_api.g_varchar2,itp.information10,p_information10)
2149 ,DECODE(p_information11,hr_api.g_varchar2,itp.information11,p_information11)
2150 ,DECODE(p_information12,hr_api.g_varchar2,itp.information12,p_information12)
2151 ,DECODE(p_information13,hr_api.g_varchar2,itp.information13,p_information13)
2152 ,DECODE(p_information14,hr_api.g_varchar2,itp.information14,p_information14)
2153 ,DECODE(p_information15,hr_api.g_varchar2,itp.information15,p_information15)
2154 ,DECODE(p_information16,hr_api.g_varchar2,itp.information16,p_information16)
2155 ,DECODE(p_information17,hr_api.g_varchar2,itp.information17,p_information17)
2156 ,DECODE(p_information18,hr_api.g_varchar2,itp.information18,p_information18)
2157 ,DECODE(p_information19,hr_api.g_varchar2,itp.information19,p_information19)
2158 ,DECODE(p_information20,hr_api.g_varchar2,itp.information20,p_information20)
2159 ,DECODE(p_information21,hr_api.g_varchar2,itp.information21,p_information21)
2160 ,DECODE(p_information22,hr_api.g_varchar2,itp.information22,p_information22)
2161 ,DECODE(p_information23,hr_api.g_varchar2,itp.information23,p_information23)
2162 ,DECODE(p_information24,hr_api.g_varchar2,itp.information24,p_information24)
2163 ,DECODE(p_information25,hr_api.g_varchar2,itp.information25,p_information25)
2164 ,DECODE(p_information26,hr_api.g_varchar2,itp.information26,p_information26)
2165 ,DECODE(p_information27,hr_api.g_varchar2,itp.information27,p_information27)
2166 ,DECODE(p_information28,hr_api.g_varchar2,itp.information28,p_information28)
2167 ,DECODE(p_information29,hr_api.g_varchar2,itp.information29,p_information29)
2168 ,DECODE(p_information30,hr_api.g_varchar2,itp.information30,p_information30)
2169 ,DECODE(p_next_navigation_item_id,hr_api.g_number,itp.next_navigation_item_id,p_next_navigation_item_id)
2170 ,DECODE(p_previous_navigation_item_id,hr_api.g_number,itp.previous_navigation_item_id,p_previous_navigation_item_id)
2171 FROM hr_item_properties_b itp
2172 ,hr_template_items_b hti
2173 WHERE itp.template_item_id (+) = hti.template_item_id
2174 AND hti.template_item_id = p_template_item_id_from;
2175
2176 CURSOR cur_item_tl
2177 IS
2178 SELECT COUNT(0) t_count
2179 ,itptl.source_lang
2180 ,DECODE(p_default_value,hr_api.g_varchar2,itptl.default_value,p_default_value) default_value
2181 ,DECODE(p_information_prompt,hr_api.g_varchar2,itptl.information_prompt,p_information_prompt) information_prompt
2182 ,DECODE(p_label,hr_api.g_varchar2,itptl.label,p_label) label
2183 ,DECODE(p_prompt_text,hr_api.g_varchar2,itptl.prompt_text,p_prompt_text) prompt_text
2184 ,DECODE(p_tooltip_text,hr_api.g_varchar2,itptl.tooltip_text,p_tooltip_text) tooltip_text
2185 FROM hr_item_properties_tl itptl
2186 ,hr_item_properties_b itp
2187 WHERE itptl.item_property_id = itp.item_property_id
2188 AND itp.template_item_id = p_template_item_id_from
2189 GROUP BY itptl.source_lang
2190 ,DECODE(p_default_value,hr_api.g_varchar2,itptl.default_value,p_default_value)
2191 ,DECODE(p_information_prompt,hr_api.g_varchar2,itptl.information_prompt,p_information_prompt)
2192 ,DECODE(p_label,hr_api.g_varchar2,itptl.label,p_label)
2193 ,DECODE(p_prompt_text,hr_api.g_varchar2,itptl.prompt_text,p_prompt_text)
2194 ,DECODE(p_tooltip_text,hr_api.g_varchar2,itptl.tooltip_text,p_tooltip_text)
2195 ORDER BY 1;
2196
2197 l_check number;
2198 l_item_property_id number ;
2199 l_object_version_number number;
2200 l_override_value_warning boolean;
2201 l_proc varchar2(72) := g_package||'copy_item_property';
2202 l_language_code fnd_languages.language_code%TYPE;
2203
2204 begin
2205 hr_utility.set_location('Entering:'|| l_proc, 10);
2206 --
2207 -- Issue a savepoint
2208 --
2209 savepoint copy_item_property;
2210 --
2211 -- Truncate the time portion from all IN date parameters
2212 --
2213
2214 --
2215 -- Validate the language parameter. l_language_code should be passed
2216 -- instead of p_language_code from now on, to allow an IN OUT parameter to
2217 -- be passed through.
2218 --
2219 l_language_code := p_language_code;
2220 hr_api.validate_language_code(p_language_code => l_language_code);
2221 --
2222 hr_utility.set_location(l_proc, 20);
2223 --
2224 --
2225 -- Validation in addition to Row Handlers
2226 --
2227 hr_utility.set_location('At:'|| l_proc, 15);
2228
2229 OPEN cur_check;
2230 FETCH cur_check INTO l_check;
2231 IF cur_check%NOTFOUND THEN
2232 CLOSE cur_check;
2233 -- error message
2234 fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2235 fnd_message.set_token('PROCEDURE', l_proc);
2236 fnd_message.set_token('STEP','10');
2237 fnd_message.raise_error;
2238 END IF;
2239 CLOSE cur_check;
2240 --
2241 -- Process Logic
2242 --
2243 hr_utility.set_location('At:'|| l_proc, 20);
2244
2245 OPEN cur_item_prop;
2246 FETCH cur_item_prop INTO l_rec;
2247 CLOSE cur_item_prop;
2248
2249 hr_utility.set_location('At:'|| l_proc, 25);
2250
2251 hr_itp_ins.ins(p_effective_date => TRUNC(p_effective_date)
2252 ,p_template_item_id => p_template_item_id_to
2253 ,p_alignment => l_rec.alignment
2254 ,p_bevel => l_rec.bevel
2255 ,p_case_restriction => l_rec.case_restriction
2256 ,p_enabled => l_rec.enabled
2257 ,p_format_mask => l_rec.format_mask
2258 ,p_height => l_rec.height
2259 ,p_information_formula_id => l_rec.information_formula_id
2260 ,p_information_param_item_id1 => l_rec.information_param_item_id1
2261 ,p_information_param_item_id2 => l_rec.information_param_item_id2
2262 ,p_information_param_item_id3 => l_rec.information_param_item_id3
2263 ,p_information_param_item_id4 => l_rec.information_param_item_id4
2264 ,p_information_param_item_id5 => l_rec.information_param_item_id5
2265 ,p_insert_allowed => l_rec.insert_allowed
2266 ,p_prompt_alignment_offset => l_rec.prompt_alignment_offset
2267 ,p_prompt_display_style => l_rec.prompt_display_style
2268 ,p_prompt_edge => l_rec.prompt_edge
2269 ,p_prompt_edge_alignment => l_rec.prompt_edge_alignment
2270 ,p_prompt_edge_offset => l_rec.prompt_edge_offset
2271 ,p_prompt_text_alignment => l_rec.prompt_text_alignment
2272 ,p_query_allowed => l_rec.query_allowed
2273 ,p_required => l_rec.required
2274 ,p_update_allowed => l_rec.update_allowed
2275 ,p_validation_formula_id => l_rec.validation_formula_id
2276 ,p_validation_param_item_id1 => l_rec.validation_param_item_id1
2277 ,p_validation_param_item_id2 => l_rec.validation_param_item_id2
2278 ,p_validation_param_item_id3 => l_rec.validation_param_item_id3
2279 ,p_validation_param_item_id4 => l_rec.validation_param_item_id4
2280 ,p_validation_param_item_id5 => l_rec.validation_param_item_id5
2281 ,p_visible => l_rec.visible
2282 ,p_width => l_rec.width
2283 ,p_x_position => l_rec.x_position
2284 ,p_y_position => l_rec.y_position
2285 ,p_information_category => l_rec.information_category
2286 ,p_information1 => l_rec.information1
2287 ,p_information2 => l_rec.information2
2288 ,p_information3 => l_rec.information3
2289 ,p_information4 => l_rec.information4
2290 ,p_information5 => l_rec.information5
2291 ,p_information6 => l_rec.information6
2292 ,p_information7 => l_rec.information7
2293 ,p_information8 => l_rec.information8
2294 ,p_information9 => l_rec.information9
2295 ,p_information10 => l_rec.information10
2296 ,p_information11 => l_rec.information11
2297 ,p_information12 => l_rec.information12
2298 ,p_information13 => l_rec.information13
2299 ,p_information14 => l_rec.information14
2300 ,p_information15 => l_rec.information15
2301 ,p_information16 => l_rec.information16
2302 ,p_information17 => l_rec.information17
2303 ,p_information18 => l_rec.information18
2304 ,p_information19 => l_rec.information19
2305 ,p_information20 => l_rec.information20
2306 ,p_information21 => l_rec.information21
2307 ,p_information22 => l_rec.information22
2308 ,p_information23 => l_rec.information23
2309 ,p_information24 => l_rec.information24
2310 ,p_information25 => l_rec.information25
2311 ,p_information26 => l_rec.information26
2312 ,p_information27 => l_rec.information27
2313 ,p_information28 => l_rec.information28
2314 ,p_information29 => l_rec.information29
2315 ,p_information30 => l_rec.information30
2316 ,p_next_navigation_item_id => l_rec.next_navigation_item_id
2317 ,p_previous_navigation_item_id => l_rec.previous_navigation_item_id
2318 ,p_item_property_id => l_item_property_id
2319 ,p_object_version_number => l_object_version_number);
2320 --,p_override_value_warning => l_override_value_warning);
2321
2322 hr_utility.set_location('At:'|| l_proc, 30);
2323
2324 IF ( p_default_value <> hr_api.g_varchar2)
2325 AND ( p_information_prompt <> hr_api.g_varchar2)
2326 AND ( p_label <> hr_api.g_varchar2 )
2327 AND ( p_prompt_text <> hr_api.g_varchar2 )
2328 AND ( p_tooltip_text <> hr_api.g_varchar2 ) THEN
2329
2330 hr_utility.set_location('At:'|| l_proc, 35);
2331
2332 hr_ipt_ins.ins_tl(p_language_code => l_language_code
2333 ,p_item_property_id => l_item_property_id
2334 ,p_default_value => p_default_value
2335 ,p_information_prompt => p_information_prompt
2336 ,p_label => p_label
2337 ,p_prompt_text => p_prompt_text
2338 ,p_tooltip_text => p_tooltip_text);
2339
2340 ELSE
2341 hr_utility.set_location('At:'|| l_proc, 40);
2342
2343 FOR cur_rec in cur_item_tl LOOP
2344 IF cur_item_tl%ROWCOUNT = 1 THEN
2345 hr_utility.set_location('At:'|| l_proc, 45);
2346
2347 hr_ipt_ins.ins_tl(p_language_code => cur_rec.source_lang
2348 ,p_item_property_id => l_item_property_id
2349 ,p_default_value => cur_rec.default_value
2350 ,p_information_prompt => cur_rec.information_prompt
2351 ,p_label => cur_rec.label
2352 ,p_prompt_text => cur_rec.prompt_text
2353 ,p_tooltip_text => cur_rec.tooltip_text);
2354 ELSE
2355 hr_utility.set_location('At:'|| l_proc, 50);
2356
2357 hr_ipt_upd.upd_tl(p_language_code => cur_rec.source_lang
2358 ,p_item_property_id => l_item_property_id
2359 ,p_default_value => cur_rec.default_value
2360 ,p_information_prompt => cur_rec.information_prompt
2361 ,p_label => cur_rec.label
2362 ,p_prompt_text => cur_rec.prompt_text
2363 ,p_tooltip_text => cur_rec.tooltip_text);
2364 END IF;
2365 END LOOP;
2366 END IF;
2367 --
2368 -- Update properties common across all buttons of a radio group
2369 --
2370 update_radio_button_property
2371 (p_effective_date => TRUNC(p_effective_date)
2372 ,p_language_code => l_language_code
2373 ,p_form_item_id => NULL
2374 ,p_template_item_id => p_template_item_id_to
2375 ,p_template_item_context_id => NULL
2376 ,p_default_value => p_default_value
2377 ,p_information_formula_id => l_rec.information_formula_id
2378 ,p_information_param_item_id1 => l_rec.information_param_item_id1
2379 ,p_information_param_item_id2 => l_rec.information_param_item_id2
2380 ,p_information_param_item_id3 => l_rec.information_param_item_id3
2381 ,p_information_param_item_id4 => l_rec.information_param_item_id4
2382 ,p_information_param_item_id5 => l_rec.information_param_item_id5
2383 ,p_information_prompt => p_information_prompt
2384 ,p_insert_allowed => l_rec.insert_allowed
2385 ,p_next_navigation_item_id => l_rec.next_navigation_item_id
2386 ,p_previous_navigation_item_id => l_rec.previous_navigation_item_id
2387 ,p_query_allowed => l_rec.query_allowed
2388 ,p_tooltip_text => p_tooltip_text
2389 ,p_update_allowed => l_rec.update_allowed
2390 ,p_validation_formula_id => l_rec.validation_formula_id
2391 ,p_validation_param_item_id1 => l_rec.validation_param_item_id1
2392 ,p_validation_param_item_id2 => l_rec.validation_param_item_id2
2393 ,p_validation_param_item_id3 => l_rec.validation_param_item_id3
2394 ,p_validation_param_item_id4 => l_rec.validation_param_item_id4
2395 ,p_validation_param_item_id5 => l_rec.validation_param_item_id5
2396 ,p_object_version_number => l_object_version_number
2397 );
2398 --
2399 -- When in validation only mode raise the Validate_Enabled exception
2400 --
2401 hr_utility.set_location('At:'|| l_proc, 55);
2402
2403 if p_validate then
2404 raise hr_api.validate_enabled;
2405 end if;
2406 --
2407 -- Set all output arguments
2408 --
2409 p_item_property_id := l_item_property_id;
2410 p_object_version_number := l_object_version_number;
2411 --p_override_value_warning := l_override_value_warning;
2412 --
2413 hr_utility.set_location(' Leaving:'||l_proc, 70);
2414 exception
2415 when hr_api.validate_enabled then
2416 --
2417 -- As the Validate_Enabled exception has been raised
2418 -- we must rollback to the savepoint
2419 --
2420 rollback to copy_item_property;
2421 --
2422 -- Only set output warning arguments
2423 -- (Any key or derived arguments must be set to null
2424 -- when validation only mode is being used.)
2425 --
2426 p_item_property_id := null;
2427 --p_override_value_warning := null;
2428 hr_utility.set_location(' Leaving:'||l_proc, 80);
2429 when others then
2430 --
2431 -- A validation or unexpected error has occured
2432 --
2433 rollback to copy_item_property;
2434 hr_utility.set_location(' Leaving:'||l_proc, 90);
2435 raise;
2436 end copy_item_property;
2437 --
2438 --
2439 --
2440 -- ----------------------------------------------------------------------------
2441 -- |--------------------< copy_item_property - overload 3>--------------------|
2442 -- ----------------------------------------------------------------------------
2443 --
2444 procedure copy_item_property
2445 (p_validate in boolean default false
2446 ,p_effective_date in date
2447 ,p_language_code in varchar2 default hr_api.userenv_lang
2448 ,p_template_item_context_id_frm in number
2449 ,p_template_item_context_id_to in number
2450 ,p_alignment in number default hr_api.g_number
2451 ,p_bevel in number default hr_api.g_number
2452 ,p_case_restriction in number default hr_api.g_number
2453 ,p_default_value in varchar2 default hr_api.g_varchar2
2454 ,p_enabled in number default hr_api.g_number
2455 ,p_format_mask in varchar2 default hr_api.g_varchar2
2456 ,p_height in number default hr_api.g_number
2457 ,p_information_formula_id in number default hr_api.g_number
2458 ,p_information_param_item_id1 in number default hr_api.g_number
2459 ,p_information_param_item_id2 in number default hr_api.g_number
2460 ,p_information_param_item_id3 in number default hr_api.g_number
2461 ,p_information_param_item_id4 in number default hr_api.g_number
2462 ,p_information_param_item_id5 in number default hr_api.g_number
2463 ,p_information_prompt in varchar2 default hr_api.g_varchar2
2464 ,p_insert_allowed in number default hr_api.g_number
2465 ,p_label in varchar2 default hr_api.g_varchar2
2466 ,p_prompt_text in varchar2 default hr_api.g_varchar2
2467 ,p_prompt_alignment_offset in number default hr_api.g_number
2468 ,p_prompt_display_style in number default hr_api.g_number
2469 ,p_prompt_edge in number default hr_api.g_number
2470 ,p_prompt_edge_alignment in number default hr_api.g_number
2471 ,p_prompt_edge_offset in number default hr_api.g_number
2472 ,p_prompt_text_alignment in number default hr_api.g_number
2473 ,p_query_allowed in number default hr_api.g_number
2474 ,p_required in number default hr_api.g_number
2475 ,p_tooltip_text in varchar2 default hr_api.g_varchar2
2476 ,p_update_allowed in number default hr_api.g_number
2477 ,p_validation_formula_id in number default hr_api.g_number
2478 ,p_validation_param_item_id1 in number default hr_api.g_number
2479 ,p_validation_param_item_id2 in number default hr_api.g_number
2480 ,p_validation_param_item_id3 in number default hr_api.g_number
2481 ,p_validation_param_item_id4 in number default hr_api.g_number
2482 ,p_validation_param_item_id5 in number default hr_api.g_number
2483 ,p_visible in number default hr_api.g_number
2484 ,p_width in number default hr_api.g_number
2485 ,p_x_position in number default hr_api.g_number
2486 ,p_y_position in number default hr_api.g_number
2487 ,p_information_category in varchar2 default hr_api.g_varchar2
2488 ,p_information1 in varchar2 default hr_api.g_varchar2
2489 ,p_information2 in varchar2 default hr_api.g_varchar2
2490 ,p_information3 in varchar2 default hr_api.g_varchar2
2491 ,p_information4 in varchar2 default hr_api.g_varchar2
2492 ,p_information5 in varchar2 default hr_api.g_varchar2
2493 ,p_information6 in varchar2 default hr_api.g_varchar2
2494 ,p_information7 in varchar2 default hr_api.g_varchar2
2495 ,p_information8 in varchar2 default hr_api.g_varchar2
2496 ,p_information9 in varchar2 default hr_api.g_varchar2
2497 ,p_information10 in varchar2 default hr_api.g_varchar2
2498 ,p_information11 in varchar2 default hr_api.g_varchar2
2499 ,p_information12 in varchar2 default hr_api.g_varchar2
2500 ,p_information13 in varchar2 default hr_api.g_varchar2
2501 ,p_information14 in varchar2 default hr_api.g_varchar2
2502 ,p_information15 in varchar2 default hr_api.g_varchar2
2503 ,p_information16 in varchar2 default hr_api.g_varchar2
2504 ,p_information17 in varchar2 default hr_api.g_varchar2
2505 ,p_information18 in varchar2 default hr_api.g_varchar2
2506 ,p_information19 in varchar2 default hr_api.g_varchar2
2507 ,p_information20 in varchar2 default hr_api.g_varchar2
2508 ,p_information21 in varchar2 default hr_api.g_varchar2
2509 ,p_information22 in varchar2 default hr_api.g_varchar2
2510 ,p_information23 in varchar2 default hr_api.g_varchar2
2511 ,p_information24 in varchar2 default hr_api.g_varchar2
2512 ,p_information25 in varchar2 default hr_api.g_varchar2
2513 ,p_information26 in varchar2 default hr_api.g_varchar2
2514 ,p_information27 in varchar2 default hr_api.g_varchar2
2515 ,p_information28 in varchar2 default hr_api.g_varchar2
2516 ,p_information29 in varchar2 default hr_api.g_varchar2
2517 ,p_information30 in varchar2 default hr_api.g_varchar2
2518 ,p_next_navigation_item_id in number default hr_api.g_number
2519 ,p_previous_navigation_item_id in number default hr_api.g_number
2520 ,p_item_property_id out nocopy number
2521 ,p_object_version_number out nocopy number
2522 --,p_override_value_warning out boolean
2523 ) is
2524 --
2525 -- Declare cursors and local variables
2526 --
2527
2528 Type l_rec_type Is Record
2529 (alignment hr_item_properties_b.alignment%TYPE
2530 ,bevel hr_item_properties_b.bevel%TYPE
2531 ,case_restriction hr_item_properties_b.case_restriction%TYPE
2532 ,enabled hr_item_properties_b.enabled%TYPE
2533 ,format_mask hr_item_properties_b.format_mask%TYPE
2534 ,height hr_item_properties_b.height%TYPE
2535 ,information_formula_id hr_item_properties_b.information_formula_id%TYPE
2536 ,information_param_item_id1 hr_item_properties_b.information_parameter_item_id1%TYPE
2537 ,information_param_item_id2 hr_item_properties_b.information_parameter_item_id2%TYPE
2538 ,information_param_item_id3 hr_item_properties_b.information_parameter_item_id3%TYPE
2539 ,information_param_item_id4 hr_item_properties_b.information_parameter_item_id4%TYPE
2540 ,information_param_item_id5 hr_item_properties_b.information_parameter_item_id5%TYPE
2541 ,insert_allowed hr_item_properties_b.insert_allowed%TYPE
2542 ,prompt_alignment_offset hr_item_properties_b.prompt_alignment_offset%TYPE
2543 ,prompt_display_style hr_item_properties_b.prompt_display_style%TYPE
2544 ,prompt_edge hr_item_properties_b.prompt_edge%TYPE
2545 ,prompt_edge_alignment hr_item_properties_b.prompt_edge_alignment%TYPE
2546 ,prompt_edge_offset hr_item_properties_b.prompt_edge_offset%TYPE
2547 ,prompt_text_alignment hr_item_properties_b.prompt_text_alignment%TYPE
2548 ,query_allowed hr_item_properties_b.query_allowed%TYPE
2549 ,required hr_item_properties_b.required%TYPE
2550 ,update_allowed hr_item_properties_b.update_allowed%TYPE
2551 ,validation_formula_id hr_item_properties_b.validation_formula_id%TYPE
2552 ,validation_param_item_id1 hr_item_properties_b.validation_parameter_item_id1%TYPE
2553 ,validation_param_item_id2 hr_item_properties_b.validation_parameter_item_id2%TYPE
2554 ,validation_param_item_id3 hr_item_properties_b.validation_parameter_item_id3%TYPE
2555 ,validation_param_item_id4 hr_item_properties_b.validation_parameter_item_id4%TYPE
2556 ,validation_param_item_id5 hr_item_properties_b.validation_parameter_item_id5%TYPE
2557 ,visible hr_item_properties_b.visible%TYPE
2558 ,width hr_item_properties_b.width%TYPE
2559 ,x_position hr_item_properties_b.x_position%TYPE
2560 ,y_position hr_item_properties_b.y_position%TYPE
2561 ,information_category hr_item_properties_b.information_category%TYPE
2562 ,information1 hr_item_properties_b.information1%TYPE
2563 ,information2 hr_item_properties_b.information2%TYPE
2564 ,information3 hr_item_properties_b.information3%TYPE
2565 ,information4 hr_item_properties_b.information4%TYPE
2566 ,information5 hr_item_properties_b.information5%TYPE
2567 ,information6 hr_item_properties_b.information6%TYPE
2568 ,information7 hr_item_properties_b.information7%TYPE
2569 ,information8 hr_item_properties_b.information8%TYPE
2570 ,information9 hr_item_properties_b.information9%TYPE
2571 ,information10 hr_item_properties_b.information10%TYPE
2572 ,information11 hr_item_properties_b.information11%TYPE
2573 ,information12 hr_item_properties_b.information12%TYPE
2574 ,information13 hr_item_properties_b.information13%TYPE
2575 ,information14 hr_item_properties_b.information14%TYPE
2576 ,information15 hr_item_properties_b.information15%TYPE
2577 ,information16 hr_item_properties_b.information16%TYPE
2578 ,information17 hr_item_properties_b.information17%TYPE
2579 ,information18 hr_item_properties_b.information18%TYPE
2580 ,information19 hr_item_properties_b.information19%TYPE
2581 ,information20 hr_item_properties_b.information20%TYPE
2582 ,information21 hr_item_properties_b.information21%TYPE
2583 ,information22 hr_item_properties_b.information22%TYPE
2584 ,information23 hr_item_properties_b.information23%TYPE
2585 ,information24 hr_item_properties_b.information24%TYPE
2586 ,information25 hr_item_properties_b.information25%TYPE
2587 ,information26 hr_item_properties_b.information26%TYPE
2588 ,information27 hr_item_properties_b.information27%TYPE
2589 ,information28 hr_item_properties_b.information28%TYPE
2590 ,information29 hr_item_properties_b.information29%TYPE
2591 ,information30 hr_item_properties_b.information30%TYPE
2592 ,next_navigation_item_id hr_item_properties_b.next_navigation_item_id%TYPE
2593 ,previous_navigation_item_id hr_item_properties_b.previous_navigation_item_id%TYPE
2594 );
2595
2596 l_rec l_rec_type;
2597
2598 CURSOR cur_check
2599 IS
2600 SELECT tiw.form_item_id
2601 FROM hr_template_item_contexts tic
2602 , hr_template_items_b tiw
2603 WHERE tic.template_item_id = tiw.template_item_id
2604 AND tic.template_item_context_id = p_template_item_context_id_frm
2605 INTERSECT
2606 SELECT tiw.form_item_id
2607 FROM hr_template_item_contexts tic
2608 , hr_template_items_b tiw
2609 WHERE tic.template_item_id = tiw.template_item_id
2610 AND tic.template_item_context_id = p_template_item_context_id_to;
2611
2612 CURSOR cur_item_prop
2613 IS
2614 SELECT DECODE(p_alignment,hr_api.g_number,itp.alignment,p_alignment)
2615 ,DECODE(p_bevel,hr_api.g_number,itp.bevel,p_bevel)
2616 ,DECODE(p_case_restriction,hr_api.g_number,itp.case_restriction,p_case_restriction)
2617 ,DECODE(p_enabled,hr_api.g_number,itp.enabled,p_enabled)
2618 ,DECODE(p_format_mask,hr_api.g_varchar2,itp.format_mask,p_format_mask)
2619 ,DECODE(p_height,hr_api.g_number,itp.height,p_height)
2620 ,DECODE(p_information_formula_id,hr_api.g_number,itp.information_formula_id,p_information_formula_id)
2621 ,DECODE(p_information_param_item_id1,hr_api.g_number,itp.information_parameter_item_id1,p_information_param_item_id1)
2622 ,DECODE(p_information_param_item_id2,hr_api.g_number,itp.information_parameter_item_id2,p_information_param_item_id2)
2623 ,DECODE(p_information_param_item_id3,hr_api.g_number,itp.information_parameter_item_id3,p_information_param_item_id3)
2624 ,DECODE(p_information_param_item_id4,hr_api.g_number,itp.information_parameter_item_id4,p_information_param_item_id4)
2625 ,DECODE(p_information_param_item_id5,hr_api.g_number,itp.information_parameter_item_id5,p_information_param_item_id5)
2626 ,DECODE(p_insert_allowed,hr_api.g_number,itp.insert_allowed,p_insert_allowed)
2627 ,DECODE(p_prompt_alignment_offset,hr_api.g_number,itp.prompt_alignment_offset,p_prompt_alignment_offset)
2628 ,DECODE(p_prompt_display_style,hr_api.g_number,itp.prompt_display_style,p_prompt_display_style)
2629 ,DECODE(p_prompt_edge,hr_api.g_number,itp.prompt_edge,p_prompt_edge)
2630 ,DECODE(p_prompt_edge_alignment,hr_api.g_number,itp.prompt_edge_alignment,p_prompt_edge_alignment)
2631 ,DECODE(p_prompt_edge_offset,hr_api.g_number,itp.prompt_edge_offset,p_prompt_edge_offset)
2632 ,DECODE(p_prompt_text_alignment,hr_api.g_number,itp.prompt_text_alignment,p_prompt_text_alignment)
2633 ,DECODE(p_query_allowed,hr_api.g_number,itp.query_allowed,p_query_allowed)
2634 ,DECODE(p_required,hr_api.g_number,itp.required,p_required)
2635 ,DECODE(p_update_allowed,hr_api.g_number,itp.update_allowed,p_update_allowed)
2636 ,DECODE(p_validation_formula_id,hr_api.g_number,itp.validation_formula_id,p_validation_formula_id)
2637 ,DECODE(p_validation_param_item_id1,hr_api.g_number,itp.validation_parameter_item_id1,p_validation_param_item_id1)
2638 ,DECODE(p_validation_param_item_id2,hr_api.g_number,itp.validation_parameter_item_id2,p_validation_param_item_id2)
2639 ,DECODE(p_validation_param_item_id3,hr_api.g_number,itp.validation_parameter_item_id3,p_validation_param_item_id3)
2640 ,DECODE(p_validation_param_item_id4,hr_api.g_number,itp.validation_parameter_item_id4,p_validation_param_item_id4)
2641 ,DECODE(p_validation_param_item_id5,hr_api.g_number,itp.validation_parameter_item_id5,p_validation_param_item_id5)
2642 ,DECODE(p_visible,hr_api.g_number,itp.visible,p_visible)
2643 ,DECODE(p_width,hr_api.g_number,itp.width,p_width)
2644 ,DECODE(p_x_position,hr_api.g_number,itp.x_position,p_x_position)
2645 ,DECODE(p_y_position,hr_api.g_number,itp.y_position,p_y_position)
2646 ,DECODE(p_information_category,hr_api.g_varchar2,itp.information_category,p_information_category)
2647 ,DECODE(p_information1,hr_api.g_varchar2,itp.information1,p_information1)
2648 ,DECODE(p_information2,hr_api.g_varchar2,itp.information2,p_information2)
2649 ,DECODE(p_information3,hr_api.g_varchar2,itp.information3,p_information3)
2650 ,DECODE(p_information4,hr_api.g_varchar2,itp.information4,p_information4)
2651 ,DECODE(p_information5,hr_api.g_varchar2,itp.information5,p_information5)
2652 ,DECODE(p_information6,hr_api.g_varchar2,itp.information6,p_information6)
2653 ,DECODE(p_information7,hr_api.g_varchar2,itp.information7,p_information7)
2654 ,DECODE(p_information8,hr_api.g_varchar2,itp.information8,p_information8)
2655 ,DECODE(p_information9,hr_api.g_varchar2,itp.information9,p_information9)
2656 ,DECODE(p_information10,hr_api.g_varchar2,itp.information10,p_information10)
2657 ,DECODE(p_information11,hr_api.g_varchar2,itp.information11,p_information11)
2658 ,DECODE(p_information12,hr_api.g_varchar2,itp.information12,p_information12)
2659 ,DECODE(p_information13,hr_api.g_varchar2,itp.information13,p_information13)
2660 ,DECODE(p_information14,hr_api.g_varchar2,itp.information14,p_information14)
2661 ,DECODE(p_information15,hr_api.g_varchar2,itp.information15,p_information15)
2662 ,DECODE(p_information16,hr_api.g_varchar2,itp.information16,p_information16)
2663 ,DECODE(p_information17,hr_api.g_varchar2,itp.information17,p_information17)
2664 ,DECODE(p_information18,hr_api.g_varchar2,itp.information18,p_information18)
2665 ,DECODE(p_information19,hr_api.g_varchar2,itp.information19,p_information19)
2666 ,DECODE(p_information20,hr_api.g_varchar2,itp.information20,p_information20)
2667 ,DECODE(p_information21,hr_api.g_varchar2,itp.information21,p_information21)
2668 ,DECODE(p_information22,hr_api.g_varchar2,itp.information22,p_information22)
2669 ,DECODE(p_information23,hr_api.g_varchar2,itp.information23,p_information23)
2670 ,DECODE(p_information24,hr_api.g_varchar2,itp.information24,p_information24)
2671 ,DECODE(p_information25,hr_api.g_varchar2,itp.information25,p_information25)
2672 ,DECODE(p_information26,hr_api.g_varchar2,itp.information26,p_information26)
2673 ,DECODE(p_information27,hr_api.g_varchar2,itp.information27,p_information27)
2674 ,DECODE(p_information28,hr_api.g_varchar2,itp.information28,p_information28)
2675 ,DECODE(p_information29,hr_api.g_varchar2,itp.information29,p_information29)
2676 ,DECODE(p_information30,hr_api.g_varchar2,itp.information30,p_information30)
2677 ,DECODE(p_next_navigation_item_id,hr_api.g_number,itp.next_navigation_item_id,p_next_navigation_item_id)
2678 ,DECODE(p_previous_navigation_item_id,hr_api.g_number,itp.previous_navigation_item_id,p_previous_navigation_item_id)
2679 FROM hr_item_properties_b itp
2680 , hr_template_item_contexts_b tic
2681 WHERE itp.template_item_context_id = tic.template_item_context_id
2682 AND tic.template_item_context_id = p_template_item_context_id_frm;
2683
2684 CURSOR cur_item_tl
2685 IS
2686 SELECT COUNT(0) t_count
2687 ,itptl.source_lang
2688 ,DECODE(p_default_value,hr_api.g_varchar2,itptl.default_value,p_default_value) default_value
2689 ,DECODE(p_information_prompt,hr_api.g_varchar2,itptl.information_prompt,p_information_prompt) information_prompt
2690 ,DECODE(p_label,hr_api.g_varchar2,itptl.label,p_label) label
2691 ,DECODE(p_prompt_text,hr_api.g_varchar2,itptl.prompt_text,p_prompt_text) prompt_text
2692 ,DECODE(p_tooltip_text,hr_api.g_varchar2,itptl.tooltip_text,p_tooltip_text) tooltip_text
2693 FROM hr_item_properties_tl itptl
2694 ,hr_item_properties_b itp
2695 WHERE itptl.item_property_id = itp.item_property_id
2696 AND itp.template_item_context_id = p_template_item_context_id_frm
2697 GROUP BY itptl.source_lang
2698 ,DECODE(p_default_value,hr_api.g_varchar2,itptl.default_value,p_default_value)
2699 ,DECODE(p_information_prompt,hr_api.g_varchar2,itptl.information_prompt,p_information_prompt)
2700 ,DECODE(p_label,hr_api.g_varchar2,itptl.label,p_label)
2701 ,DECODE(p_prompt_text,hr_api.g_varchar2,itptl.prompt_text,p_prompt_text)
2702 ,DECODE(p_tooltip_text,hr_api.g_varchar2,itptl.tooltip_text,p_tooltip_text)
2703 ORDER BY 1;
2704
2705 l_language_code fnd_languages.language_code%TYPE;
2706
2707 l_check number;
2708 l_item_property_id number ;
2709 l_object_version_number number;
2710 l_override_value_warning boolean;
2711 l_proc varchar2(72) := g_package||'copy_item_property';
2712 begin
2713 hr_utility.set_location('Entering:'|| l_proc, 10);
2714 --
2715 -- Issue a savepoint
2716 --
2717 savepoint copy_item_property;
2718 --
2719 -- Truncate the time portion from all IN date parameters
2720 --
2721
2722 --
2723 -- Validate the language parameter. l_language_code should be passed
2724 -- instead of p_language_code from now on, to allow an IN OUT parameter to
2725 -- be passed through.
2726 --
2727 l_language_code := p_language_code;
2728 hr_api.validate_language_code(p_language_code => l_language_code);
2729 --
2730 hr_utility.set_location(l_proc, 20);
2731 --
2732 --
2733 -- Validation in addition to Row Handlers
2734 --
2735 hr_utility.set_location('At:'|| l_proc, 15);
2736
2737 OPEN cur_check;
2738 FETCH cur_check INTO l_check;
2739 IF cur_check%NOTFOUND THEN
2740 CLOSE cur_check;
2741 -- error message
2742 fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2743 fnd_message.set_token('PROCEDURE', l_proc);
2744 fnd_message.set_token('STEP','10');
2745 fnd_message.raise_error;
2746 END IF;
2747 CLOSE cur_check;
2748 --
2749 -- Process Logic
2750 --
2751 hr_utility.set_location('At:'|| l_proc, 20);
2752
2753 OPEN cur_item_prop;
2754 FETCH cur_item_prop INTO l_rec;
2755 CLOSE cur_item_prop;
2756
2757 hr_utility.set_location('At:'|| l_proc, 30);
2758
2759 hr_itp_ins.ins(p_effective_date => TRUNC(p_effective_date)
2760 ,p_template_item_context_id => p_template_item_context_id_to
2761 ,p_alignment => l_rec.alignment
2762 ,p_bevel => l_rec.bevel
2763 ,p_case_restriction => l_rec.case_restriction
2764 ,p_enabled => l_rec.enabled
2765 ,p_format_mask => l_rec.format_mask
2766 ,p_height => l_rec.height
2767 ,p_information_formula_id => l_rec.information_formula_id
2768 ,p_information_param_item_id1 => l_rec.information_param_item_id1
2769 ,p_information_param_item_id2 => l_rec.information_param_item_id2
2770 ,p_information_param_item_id3 => l_rec.information_param_item_id3
2771 ,p_information_param_item_id4 => l_rec.information_param_item_id4
2772 ,p_information_param_item_id5 => l_rec.information_param_item_id5
2773 ,p_insert_allowed => l_rec.insert_allowed
2774 ,p_prompt_alignment_offset => l_rec.prompt_alignment_offset
2775 ,p_prompt_display_style => l_rec.prompt_display_style
2776 ,p_prompt_edge => l_rec.prompt_edge
2777 ,p_prompt_edge_alignment => l_rec.prompt_edge_alignment
2778 ,p_prompt_edge_offset => l_rec.prompt_edge_offset
2779 ,p_prompt_text_alignment => l_rec.prompt_text_alignment
2780 ,p_query_allowed => l_rec.query_allowed
2781 ,p_required => l_rec.required
2782 ,p_update_allowed => l_rec.update_allowed
2783 ,p_validation_formula_id => l_rec.validation_formula_id
2784 ,p_validation_param_item_id1 => l_rec.validation_param_item_id1
2785 ,p_validation_param_item_id2 => l_rec.validation_param_item_id2
2786 ,p_validation_param_item_id3 => l_rec.validation_param_item_id3
2787 ,p_validation_param_item_id4 => l_rec.validation_param_item_id4
2788 ,p_validation_param_item_id5 => l_rec.validation_param_item_id5
2789 ,p_visible => l_rec.visible
2790 ,p_width => l_rec.width
2791 ,p_x_position => l_rec.x_position
2792 ,p_y_position => l_rec.y_position
2793 ,p_information_category => l_rec.information_category
2794 ,p_information1 => l_rec.information1
2795 ,p_information2 => l_rec.information2
2796 ,p_information3 => l_rec.information3
2797 ,p_information4 => l_rec.information4
2798 ,p_information5 => l_rec.information5
2799 ,p_information6 => l_rec.information6
2800 ,p_information7 => l_rec.information7
2801 ,p_information8 => l_rec.information8
2802 ,p_information9 => l_rec.information9
2803 ,p_information10 => l_rec.information10
2804 ,p_information11 => l_rec.information11
2805 ,p_information12 => l_rec.information12
2806 ,p_information13 => l_rec.information13
2807 ,p_information14 => l_rec.information14
2808 ,p_information15 => l_rec.information15
2809 ,p_information16 => l_rec.information16
2810 ,p_information17 => l_rec.information17
2811 ,p_information18 => l_rec.information18
2812 ,p_information19 => l_rec.information19
2813 ,p_information20 => l_rec.information20
2814 ,p_information21 => l_rec.information21
2815 ,p_information22 => l_rec.information22
2816 ,p_information23 => l_rec.information23
2817 ,p_information24 => l_rec.information24
2818 ,p_information25 => l_rec.information25
2819 ,p_information26 => l_rec.information26
2820 ,p_information27 => l_rec.information27
2821 ,p_information28 => l_rec.information28
2822 ,p_information29 => l_rec.information29
2823 ,p_information30 => l_rec.information30
2824 ,p_next_navigation_item_id => l_rec.next_navigation_item_id
2825 ,p_previous_navigation_item_id => l_rec.previous_navigation_item_id
2826 ,p_item_property_id => l_item_property_id
2827 ,p_object_version_number => l_object_version_number);
2828 --,p_override_value_warning => l_override_value_warning);
2829
2830 hr_utility.set_location('At:'|| l_proc, 35);
2831
2832 IF ( p_default_value <> hr_api.g_varchar2)
2833 AND ( p_information_prompt <> hr_api.g_varchar2)
2834 AND ( p_label <> hr_api.g_varchar2 )
2835 AND ( p_prompt_text <> hr_api.g_varchar2 )
2836 AND ( p_tooltip_text <> hr_api.g_varchar2 ) THEN
2837
2838 hr_utility.set_location('At:'|| l_proc, 40);
2839
2840 hr_ipt_ins.ins_tl(p_language_code => l_language_code
2841 ,p_item_property_id => l_item_property_id
2842 ,p_default_value => p_default_value
2843 ,p_information_prompt => p_information_prompt
2844 ,p_label => p_label
2845 ,p_prompt_text => p_prompt_text
2846 ,p_tooltip_text => p_tooltip_text);
2847
2848 ELSE
2849 hr_utility.set_location('At:'|| l_proc, 45);
2850
2851 FOR cur_rec in cur_item_tl LOOP
2852 IF cur_item_tl%ROWCOUNT = 1 THEN
2853 hr_utility.set_location('At:'|| l_proc, 50);
2854
2855 hr_ipt_ins.ins_tl(p_language_code => cur_rec.source_lang
2856 ,p_item_property_id => l_item_property_id
2857 ,p_default_value => cur_rec.default_value
2858 ,p_information_prompt => cur_rec.information_prompt
2859 ,p_label => cur_rec.label
2860 ,p_prompt_text => cur_rec.prompt_text
2861 ,p_tooltip_text => cur_rec.tooltip_text);
2862 ELSE
2863 hr_utility.set_location('At:'|| l_proc, 55);
2864
2865 hr_ipt_upd.upd_tl(p_language_code => cur_rec.source_lang
2866 ,p_item_property_id => l_item_property_id
2867 ,p_default_value => cur_rec.default_value
2868 ,p_information_prompt => cur_rec.information_prompt
2869 ,p_label => cur_rec.label
2870 ,p_prompt_text => cur_rec.prompt_text
2871 ,p_tooltip_text => cur_rec.tooltip_text);
2872 END IF;
2873 END LOOP;
2874 END IF;
2875 --
2876 -- Update properties common across all buttons of a radio group
2877 --
2878 update_radio_button_property
2879 (p_effective_date => TRUNC(p_effective_date)
2880 ,p_language_code => l_language_code
2881 ,p_form_item_id => NULL
2882 ,p_template_item_id => NULL
2883 ,p_template_item_context_id => p_template_item_context_id_to
2884 ,p_default_value => p_default_value
2885 ,p_information_formula_id => l_rec.information_formula_id
2886 ,p_information_param_item_id1 => l_rec.information_param_item_id1
2887 ,p_information_param_item_id2 => l_rec.information_param_item_id2
2888 ,p_information_param_item_id3 => l_rec.information_param_item_id3
2889 ,p_information_param_item_id4 => l_rec.information_param_item_id4
2890 ,p_information_param_item_id5 => l_rec.information_param_item_id5
2891 ,p_information_prompt => p_information_prompt
2892 ,p_insert_allowed => l_rec.insert_allowed
2893 ,p_next_navigation_item_id => l_rec.next_navigation_item_id
2894 ,p_previous_navigation_item_id => l_rec.previous_navigation_item_id
2895 ,p_query_allowed => l_rec.query_allowed
2896 ,p_tooltip_text => p_tooltip_text
2897 ,p_update_allowed => l_rec.update_allowed
2898 ,p_validation_formula_id => l_rec.validation_formula_id
2899 ,p_validation_param_item_id1 => l_rec.validation_param_item_id1
2900 ,p_validation_param_item_id2 => l_rec.validation_param_item_id2
2901 ,p_validation_param_item_id3 => l_rec.validation_param_item_id3
2902 ,p_validation_param_item_id4 => l_rec.validation_param_item_id4
2903 ,p_validation_param_item_id5 => l_rec.validation_param_item_id5
2904 ,p_object_version_number => p_object_version_number
2905 );
2906 --
2907 -- When in validation only mode raise the Validate_Enabled exception
2908 --
2909 hr_utility.set_location('At:'|| l_proc, 60);
2910
2911 if p_validate then
2912 raise hr_api.validate_enabled;
2913 end if;
2914 --
2915 -- Set all output arguments
2916 --
2917 p_item_property_id := l_item_property_id;
2918 p_object_version_number := l_object_version_number;
2919 --p_override_value_warning := l_override_value_warning;
2920 --
2921 hr_utility.set_location(' Leaving:'||l_proc, 70);
2922 exception
2923 when hr_api.validate_enabled then
2924 --
2925 -- As the Validate_Enabled exception has been raised
2926 -- we must rollback to the savepoint
2927 --
2928 rollback to copy_item_property;
2929 --
2930 -- Only set output warning arguments
2931 -- (Any key or derived arguments must be set to null
2932 -- when validation only mode is being used.)
2933 --
2934 p_item_property_id := null;
2935 --p_override_value_warning := null;
2936 hr_utility.set_location(' Leaving:'||l_proc, 80);
2937 when others then
2938 --
2939 -- A validation or unexpected error has occured
2940 --
2941 rollback to copy_item_property;
2942 hr_utility.set_location(' Leaving:'||l_proc, 90);
2943 raise;
2944 end copy_item_property;
2945 --
2946 end hr_item_properties_bsi;