[Home] [Help]
PACKAGE BODY: APPS.HR_TEMPLATE_ITEM_CONTEXTS_API
Source
1 Package Body hr_template_item_contexts_api as
2 /* $Header: hrticapi.pkb 115.7 2003/10/31 06:55:09 bsubrama noship $ */
3 --
4 -- Package Variables
5 --
6 g_package varchar2(33) := ' hr_template_item_contexts_api.';
7 --
8 -- ----------------------------------------------------------------------------
9 -- |------------------< copy_template_item_context >--------------------------|
10 -- ----------------------------------------------------------------------------
11 --
12 procedure copy_template_item_context
13 (p_validate in boolean default false
14 ,p_effective_date in date
15 ,p_language_code in varchar2 default hr_api.userenv_lang
16 ,p_template_item_context_id_frm in number
17 ,p_template_item_id in number
18 ,p_template_item_context_id_to out nocopy number
19 ,p_object_version_number out nocopy number
20 ,p_item_context_id out nocopy number
21 ,p_concatenated_segments out nocopy varchar2
22 ) is
23 --
24 -- Declare cursors and local variables
25 --
26 Type l_rec_type Is Record (
27 context_type hr_template_item_contexts.context_type%TYPE
28 ,segment1 hr_item_contexts.segment1%TYPE
29 ,segment2 hr_item_contexts.segment2%TYPE
30 ,segment3 hr_item_contexts.segment3%TYPE
31 ,segment4 hr_item_contexts.segment4%TYPE
32 ,segment5 hr_item_contexts.segment5%TYPE
33 ,segment6 hr_item_contexts.segment6%TYPE
34 ,segment7 hr_item_contexts.segment7%TYPE
35 ,segment8 hr_item_contexts.segment8%TYPE
36 ,segment9 hr_item_contexts.segment9%TYPE
37 ,segment10 hr_item_contexts.segment10%TYPE
38 ,segment11 hr_item_contexts.segment11%TYPE
39 ,segment12 hr_item_contexts.segment12%TYPE
40 ,segment13 hr_item_contexts.segment13%TYPE
41 ,segment14 hr_item_contexts.segment14%TYPE
42 ,segment15 hr_item_contexts.segment15%TYPE
43 ,segment16 hr_item_contexts.segment16%TYPE
44 ,segment17 hr_item_contexts.segment17%TYPE
45 ,segment18 hr_item_contexts.segment18%TYPE
46 ,segment19 hr_item_contexts.segment19%TYPE
47 ,segment20 hr_item_contexts.segment20%TYPE
48 ,segment21 hr_item_contexts.segment21%TYPE
49 ,segment22 hr_item_contexts.segment22%TYPE
50 ,segment23 hr_item_contexts.segment23%TYPE
51 ,segment24 hr_item_contexts.segment24%TYPE
52 ,segment25 hr_item_contexts.segment25%TYPE
53 ,segment26 hr_item_contexts.segment26%TYPE
54 ,segment27 hr_item_contexts.segment27%TYPE
55 ,segment28 hr_item_contexts.segment28%TYPE
56 ,segment29 hr_item_contexts.segment29%TYPE
57 ,segment30 hr_item_contexts.segment30%TYPE);
58
59 l_rec l_rec_type;
60
61 CURSOR cur_item_contexts
62 IS
63 SELECT tic.context_type
64 ,icx.segment1
65 ,icx.segment2
66 ,icx.segment3
67 ,icx.segment4
68 ,icx.segment5
69 ,icx.segment6
70 ,icx.segment7
71 ,icx.segment8
72 ,icx.segment9
73 ,icx.segment10
74 ,icx.segment11
75 ,icx.segment12
76 ,icx.segment13
77 ,icx.segment14
78 ,icx.segment15
79 ,icx.segment16
80 ,icx.segment17
81 ,icx.segment18
82 ,icx.segment19
83 ,icx.segment20
84 ,icx.segment21
85 ,icx.segment22
86 ,icx.segment23
87 ,icx.segment24
88 ,icx.segment25
89 ,icx.segment26
90 ,icx.segment27
91 ,icx.segment28
92 ,icx.segment29
93 ,icx.segment30
94 FROM hr_item_contexts icx
95 ,hr_template_item_contexts tic
96 WHERE icx.item_context_id = tic.item_context_id
97 AND tic.template_item_context_id = p_template_item_context_id_frm;
98
99 CURSOR cur_tmplt_tab
100 IS
101 SELECT ttp2.template_tab_page_id
102 FROM hr_template_tab_pages ttp2
103 ,hr_template_canvases tcn
104 ,hr_template_windows twn
105 ,hr_template_items tit
106 ,hr_template_tab_pages ttp1
107 ,hr_template_item_context_pages tcp
108 WHERE ttp2.form_tab_page_id = ttp1.form_tab_page_id
109 AND ttp2.template_canvas_id = tcn.template_canvas_id
110 AND tcn.template_window_id = twn.template_window_id
111 AND twn.form_template_id = tit.form_template_id
112 AND tit.template_item_id = p_template_item_id
113 AND ttp1.template_tab_page_id = tcp.template_tab_page_id
114 AND tcp.template_item_context_id = p_template_item_context_id_frm;
115
116 l_temp number;
117
118 CURSOR cur_api_val
119 IS
120 SELECT source_form_template_id
121 FROM hr_source_form_templates hsf
122 ,hr_template_items_b hti
123 WHERE hsf.form_template_id_to = hti.form_template_id
124 AND hti.template_item_id = p_template_item_id;
125
126 l_override_value_warning boolean;
127 l_tic_id number;
128 l_ovn_item number;
129 l_item_property_id number;
130 l_template_item_context_id_to number;
131 l_object_version_number number;
132 l_item_context_id number;
133 l_concatenated_segments varchar2(2000);
134 l_language_code fnd_languages.language_code%TYPE;
135
136 l_proc varchar2(72) := g_package||'copy_template_item_context';
137 begin
138 hr_utility.set_location('Entering:'|| l_proc, 10);
139 --
140 -- Issue a savepoint
141 --
142 savepoint copy_template_item_context;
143 --
144 -- Truncate the time portion from all IN date parameters
145 --
146 -- p_effective_date := TRUNC(p_effective_date);
147 --
148 -- Validate the language parameter. l_language_code should be passed
149 -- instead of p_language_code from now on, to allow an IN OUT parameter to
150 -- be passed through.
151 --
152 l_language_code := p_language_code;
153 hr_api.validate_language_code(p_language_code => l_language_code);
154 --
155 hr_utility.set_location(l_proc, 20);
156 --
157 --
158 -- Call Before Process User Hook
159 --
160 begin
161 hr_template_item_contexts_bk1.copy_template_item_context_b
162 (p_effective_date => TRUNC(p_effective_date)
163 ,p_language_code => l_language_code
164 ,p_template_item_context_id_frm => p_template_item_context_id_frm
165 ,p_template_item_id => p_template_item_id
166 );
167 exception
168 when hr_api.cannot_find_prog_unit then
169 hr_api.cannot_find_prog_unit_error
170 (p_module_name => 'copy_template_item_context'
171 ,p_hook_type => 'BP'
172 );
173 end;
174 --
175 -- Validation in addition to Row Handlers
176 --
177 hr_utility.set_location('At:'|| l_proc, 15);
178
179 OPEN cur_api_val;
180 FETCH cur_api_val INTO l_temp;
181 IF (cur_api_val%NOTFOUND AND
182 hr_form_templates_api.g_session_mode <> 'SEED_DATA') THEN
183 CLOSE cur_api_val;
184 -- error message
185 fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
186 fnd_message.set_token('PROCEDURE', l_proc);
187 fnd_message.set_token('STEP','10');
188 fnd_message.raise_error;
189 END IF;
190 CLOSE cur_api_val;
191 --
192 --
193 -- Process Logic
194 --
195 hr_utility.set_location('At:'|| l_proc, 20);
196
197 OPEN cur_item_contexts;
198 FETCH cur_item_contexts INTO l_rec;
199 CLOSE cur_item_contexts;
200
201 hr_utility.set_location('At:'|| l_proc, 25);
202
203 hr_icx_ins.ins_or_sel(
204 p_context_type => l_rec.context_type
205 ,p_segment1 => l_rec.segment1
206 ,p_segment2 => l_rec.segment2
207 ,p_segment3 => l_rec.segment3
208 ,p_segment4 => l_rec.segment4
209 ,p_segment5 => l_rec.segment5
210 ,p_segment6 => l_rec.segment6
211 ,p_segment7 => l_rec.segment7
212 ,p_segment8 => l_rec.segment8
213 ,p_segment9 => l_rec.segment9
214 ,p_segment10 => l_rec.segment10
215 ,p_segment11 => l_rec.segment11
216 ,p_segment12 => l_rec.segment12
217 ,p_segment13 => l_rec.segment13
218 ,p_segment14 => l_rec.segment14
219 ,p_segment15 => l_rec.segment15
220 ,p_segment16 => l_rec.segment16
221 ,p_segment17 => l_rec.segment17
222 ,p_segment18 => l_rec.segment18
223 ,p_segment19 => l_rec.segment19
224 ,p_segment20 => l_rec.segment20
225 ,p_segment21 => l_rec.segment21
226 ,p_segment22 => l_rec.segment22
227 ,p_segment23 => l_rec.segment23
228 ,p_segment24 => l_rec.segment24
229 ,p_segment25 => l_rec.segment25
230 ,p_segment26 => l_rec.segment26
231 ,p_segment27 => l_rec.segment27
232 ,p_segment28 => l_rec.segment28
233 ,p_segment29 => l_rec.segment29
234 ,p_segment30 => l_rec.segment30
235 ,p_item_context_id => l_item_context_id
236 ,p_concatenated_segments => l_concatenated_segments);
237
238 hr_utility.set_location('At:'|| l_proc, 30);
239
240 hr_tic_ins.ins( p_template_item_id => p_template_item_id
241 ,p_context_type => l_rec.context_type
242 ,p_item_context_id => l_item_context_id
243 ,p_template_item_context_id => l_template_item_context_id_to
244 ,p_object_version_number => l_object_version_number);
245
246 hr_utility.set_location('At:'|| l_proc, 35);
247
248 hr_item_properties_bsi.copy_item_property(
249 p_effective_date => TRUNC(p_effective_date)
250 ,p_language_code => l_language_code
251 ,p_template_item_context_id_frm => p_template_item_context_id_frm
252 ,p_template_item_context_id_to => l_template_item_context_id_to
253 ,p_item_property_id => l_item_property_id
254 ,p_object_version_number => l_object_version_number);
255 --,p_override_value_warning => l_override_value_warning);
256
257 hr_utility.set_location('At:'|| l_proc, 40);
258
259 FOR cur_rec IN cur_tmplt_tab LOOP
260 hr_tcp_api.create_tcp
261 (p_effective_date => TRUNC(p_effective_date)
262 ,p_template_item_context_id => l_template_item_context_id_to
263 ,p_template_tab_page_id => cur_rec.template_tab_page_id
264 ,p_template_item_context_page_i => l_tic_id
265 ,p_object_version_number => l_ovn_item);
266 END LOOP;
267
268 hr_utility.set_location('At:'|| l_proc, 45);
269
270 --
271 -- Call After Process User Hook
272 --
273 begin
274 hr_template_item_contexts_bk1.copy_template_item_context_a
275 (p_effective_date => TRUNC(p_effective_date)
276 ,p_language_code => l_language_code
277 ,p_template_item_context_id_frm => p_template_item_context_id_frm
278 ,p_template_item_id => p_template_item_id
279 ,p_template_item_context_id_to => l_template_item_context_id_to
280 ,p_object_version_number => l_object_version_number
281 ,p_item_context_id => l_item_context_id
282 ,p_concatenated_segments => l_concatenated_segments
283 );
284 exception
285 when hr_api.cannot_find_prog_unit then
286 hr_api.cannot_find_prog_unit_error
287 (p_module_name => 'copy_template_item_context'
288 ,p_hook_type => 'AP'
289 );
290 end;
291 --
292 -- When in validation only mode raise the Validate_Enabled exception
293 --
294 hr_utility.set_location('At:'|| l_proc, 50);
295
296 if p_validate then
297 raise hr_api.validate_enabled;
298 end if;
299 --
300 -- Set all output arguments
301 --
302 p_template_item_context_id_to := l_template_item_context_id_to;
303 p_object_version_number := l_object_version_number;
304 p_item_context_id := l_item_context_id;
305 p_concatenated_segments := l_concatenated_segments;
306 --
307 hr_utility.set_location(' Leaving:'||l_proc, 70);
308 exception
309 when hr_api.validate_enabled then
310 --
311 -- As the Validate_Enabled exception has been raised
312 -- we must rollback to the savepoint
313 --
314 rollback to copy_template_item_context;
315 --
316 -- Only set output warning arguments
317 -- (Any key or derived arguments must be set to null
318 -- when validation only mode is being used.)
319 --
320 p_template_item_context_id_to := null;
321 p_object_version_number := null;
322 p_item_context_id := null;
323 p_concatenated_segments := null;
324 hr_utility.set_location(' Leaving:'||l_proc, 80);
325 when others then
326 --
327 -- A validation or unexpected error has occured
328 --
329 p_template_item_context_id_to := null;
330 p_object_version_number := null;
331 p_item_context_id := null;
332 p_concatenated_segments := null;
333
334 rollback to copy_template_item_context;
335 hr_utility.set_location(' Leaving:'||l_proc, 90);
336 raise;
337 end copy_template_item_context;
338 --
339 -- ----------------------------------------------------------------------------
340 -- |----------------------< create_template_item_context >--------------------|
341 -- ----------------------------------------------------------------------------
342 --
343 procedure create_template_item_context
344 (p_validate in boolean default false
345 ,p_effective_date in date
346 ,p_language_code in varchar2 default hr_api.userenv_lang
347 ,p_template_item_id in number
348 ,p_context_type in varchar2
349 ,p_segment1 in varchar2 default null
350 ,p_segment2 in varchar2 default null
351 ,p_segment3 in varchar2 default null
352 ,p_segment4 in varchar2 default null
353 ,p_segment5 in varchar2 default null
354 ,p_segment6 in varchar2 default null
355 ,p_segment7 in varchar2 default null
356 ,p_segment8 in varchar2 default null
357 ,p_segment9 in varchar2 default null
358 ,p_segment10 in varchar2 default null
359 ,p_segment11 in varchar2 default null
360 ,p_segment12 in varchar2 default null
361 ,p_segment13 in varchar2 default null
362 ,p_segment14 in varchar2 default null
363 ,p_segment15 in varchar2 default null
364 ,p_segment16 in varchar2 default null
365 ,p_segment17 in varchar2 default null
366 ,p_segment18 in varchar2 default null
367 ,p_segment19 in varchar2 default null
368 ,p_segment20 in varchar2 default null
369 ,p_segment21 in varchar2 default null
370 ,p_segment22 in varchar2 default null
371 ,p_segment23 in varchar2 default null
372 ,p_segment24 in varchar2 default null
373 ,p_segment25 in varchar2 default null
374 ,p_segment26 in varchar2 default null
375 ,p_segment27 in varchar2 default null
376 ,p_segment28 in varchar2 default null
377 ,p_segment29 in varchar2 default null
378 ,p_segment30 in varchar2 default null
379 ,p_template_tab_page_id in number default null
380 ,p_alignment in number default hr_api.g_number
381 ,p_bevel in number default hr_api.g_number
382 ,p_case_restriction in number default hr_api.g_number
383 ,p_default_value in varchar2 default hr_api.g_varchar2
384 ,p_enabled in number default hr_api.g_number
385 ,p_format_mask in varchar2 default hr_api.g_varchar2
386 ,p_height in number default hr_api.g_number
387 ,p_information_formula_id in number default hr_api.g_number
388 ,p_information_param_item_id1 in number default hr_api.g_number
389 ,p_information_param_item_id2 in number default hr_api.g_number
390 ,p_information_param_item_id3 in number default hr_api.g_number
391 ,p_information_param_item_id4 in number default hr_api.g_number
392 ,p_information_param_item_id5 in number default hr_api.g_number
393 ,p_information_prompt in varchar2 default hr_api.g_varchar2
394 ,p_insert_allowed in number default hr_api.g_number
395 ,p_label in varchar2 default hr_api.g_varchar2
396 ,p_prompt_text in varchar2 default hr_api.g_varchar2
397 ,p_prompt_alignment_offset in number default hr_api.g_number
398 ,p_prompt_display_style in number default hr_api.g_number
399 ,p_prompt_edge in number default hr_api.g_number
400 ,p_prompt_edge_alignment in number default hr_api.g_number
401 ,p_prompt_edge_offset in number default hr_api.g_number
402 ,p_prompt_text_alignment in number default hr_api.g_number
403 ,p_query_allowed in number default hr_api.g_number
404 ,p_required in number default hr_api.g_number
405 ,p_tooltip_text in varchar2 default hr_api.g_varchar2
406 ,p_update_allowed in number default hr_api.g_number
407 ,p_validation_formula_id in number default hr_api.g_number
408 ,p_validation_param_item_id1 in number default hr_api.g_number
409 ,p_validation_param_item_id2 in number default hr_api.g_number
410 ,p_validation_param_item_id3 in number default hr_api.g_number
411 ,p_validation_param_item_id4 in number default hr_api.g_number
412 ,p_validation_param_item_id5 in number default hr_api.g_number
413 ,p_visible in number default hr_api.g_number
414 ,p_width in number default hr_api.g_number
415 ,p_x_position in number default hr_api.g_number
416 ,p_y_position in number default hr_api.g_number
417 ,p_information_category in varchar2 default hr_api.g_varchar2
418 ,p_information1 in varchar2 default hr_api.g_varchar2
419 ,p_information2 in varchar2 default hr_api.g_varchar2
420 ,p_information3 in varchar2 default hr_api.g_varchar2
421 ,p_information4 in varchar2 default hr_api.g_varchar2
422 ,p_information5 in varchar2 default hr_api.g_varchar2
423 ,p_information6 in varchar2 default hr_api.g_varchar2
424 ,p_information7 in varchar2 default hr_api.g_varchar2
425 ,p_information8 in varchar2 default hr_api.g_varchar2
426 ,p_information9 in varchar2 default hr_api.g_varchar2
427 ,p_information10 in varchar2 default hr_api.g_varchar2
428 ,p_information11 in varchar2 default hr_api.g_varchar2
429 ,p_information12 in varchar2 default hr_api.g_varchar2
430 ,p_information13 in varchar2 default hr_api.g_varchar2
431 ,p_information14 in varchar2 default hr_api.g_varchar2
432 ,p_information15 in varchar2 default hr_api.g_varchar2
433 ,p_information16 in varchar2 default hr_api.g_varchar2
434 ,p_information17 in varchar2 default hr_api.g_varchar2
435 ,p_information18 in varchar2 default hr_api.g_varchar2
436 ,p_information19 in varchar2 default hr_api.g_varchar2
437 ,p_information20 in varchar2 default hr_api.g_varchar2
438 ,p_information21 in varchar2 default hr_api.g_varchar2
439 ,p_information22 in varchar2 default hr_api.g_varchar2
440 ,p_information23 in varchar2 default hr_api.g_varchar2
441 ,p_information24 in varchar2 default hr_api.g_varchar2
442 ,p_information25 in varchar2 default hr_api.g_varchar2
443 ,p_information26 in varchar2 default hr_api.g_varchar2
444 ,p_information27 in varchar2 default hr_api.g_varchar2
445 ,p_information28 in varchar2 default hr_api.g_varchar2
446 ,p_information29 in varchar2 default hr_api.g_varchar2
447 ,p_information30 in varchar2 default hr_api.g_varchar2
448 ,p_next_navigation_item_id in number default hr_api.g_number
449 ,p_previous_navigation_item_id in number default hr_api.g_number
450 ,p_template_item_context_id out nocopy number
451 ,p_object_version_number out nocopy number
452 ,p_item_context_id out nocopy number
453 ,p_concatenated_segments out nocopy varchar2
454 ,p_override_value_warning out nocopy boolean
455 ) is
456 --
457 -- Declare cursors and local variables
458 --
459
460 l_required_override number := null;
461 l_form_tab_page_id_override number := null;
462 l_visible_override number := null;
463
464 CURSOR cur_override
465 IS
466 SELECT required_override
467 ,visible_override
468 FROM hr_form_items_b hfi
469 ,hr_template_items_b hti
470 WHERE hfi.form_item_id = hti.form_item_id
471 AND hti.template_item_id = p_template_item_id;
472
473 l_temp number;
474
475 CURSOR cur_api_val
476 IS
477 SELECT source_form_template_id
478 FROM hr_source_form_templates hsf
479 ,hr_template_items_b hti
480 WHERE hsf.form_template_id_to = hti.form_template_id
481 AND hti.template_item_id = p_template_item_id;
482
483 l_tic_id number;
484 l_ovn_item number;
485 l_item_property_id number;
486 l_override_value_warning boolean := FALSE;
487 l_template_item_context_id number;
488 l_object_version_number number;
489 l_item_context_id number;
490 l_concatenated_segments varchar2(2000);
491 l_language_code fnd_languages.language_code%TYPE;
492
493 l_proc varchar2(72) := g_package||'create_template_item_context';
494 begin
495 hr_utility.set_location('Entering:'|| l_proc, 10);
496 --
497 -- Issue a savepoint
498 --
499 savepoint create_template_item_context;
500 --
501 -- Truncate the time portion from all IN date parameters
502 --
503 -- p_effective_date := TRUNC(p_effective_date);
504 --
505 -- Validate the language parameter. l_language_code should be passed
506 -- instead of p_language_code from now on, to allow an IN OUT parameter to
507 -- be passed through.
508 --
509 l_language_code := p_language_code;
510 hr_api.validate_language_code(p_language_code => l_language_code);
511 --
512 hr_utility.set_location(l_proc, 20);
513 --
514 --
515 -- Call Before Process User Hook
516 --
517 begin
518 hr_template_item_contexts_bk2.create_template_item_context_b
519 (p_effective_date => TRUNC(p_effective_date)
520 ,p_language_code => l_language_code
521 ,p_template_item_id => p_template_item_id
522 ,p_context_type => p_context_type
523 ,p_segment1 => p_segment1
524 ,p_segment2 => p_segment2
525 ,p_segment3 => p_segment3
526 ,p_segment4 => p_segment4
527 ,p_segment5 => p_segment5
528 ,p_segment6 => p_segment6
529 ,p_segment7 => p_segment7
530 ,p_segment8 => p_segment8
531 ,p_segment9 => p_segment9
532 ,p_segment10 => p_segment10
533 ,p_segment11 => p_segment11
534 ,p_segment12 => p_segment12
535 ,p_segment13 => p_segment13
536 ,p_segment14 => p_segment14
537 ,p_segment15 => p_segment15
538 ,p_segment16 => p_segment16
539 ,p_segment17 => p_segment17
540 ,p_segment18 => p_segment18
541 ,p_segment19 => p_segment19
542 ,p_segment20 => p_segment20
543 ,p_segment21 => p_segment21
544 ,p_segment22 => p_segment22
545 ,p_segment23 => p_segment23
546 ,p_segment24 => p_segment24
547 ,p_segment25 => p_segment25
548 ,p_segment26 => p_segment26
549 ,p_segment27 => p_segment27
550 ,p_segment28 => p_segment28
551 ,p_segment29 => p_segment29
552 ,p_segment30 => p_segment30
553 ,p_template_tab_page_id => p_template_tab_page_id
554 ,p_alignment => p_alignment
555 ,p_bevel => p_bevel
556 ,p_case_restriction => p_case_restriction
557 ,p_default_value => p_default_value
558 ,p_enabled => p_enabled
559 ,p_format_mask => p_format_mask
560 ,p_height => p_height
561 ,p_information_formula_id => p_information_formula_id
562 ,p_information_param_item_id1 => p_information_param_item_id1
563 ,p_information_param_item_id2 => p_information_param_item_id2
564 ,p_information_param_item_id3 => p_information_param_item_id3
565 ,p_information_param_item_id4 => p_information_param_item_id4
566 ,p_information_param_item_id5 => p_information_param_item_id5
567 ,p_information_prompt => p_information_prompt
568 ,p_insert_allowed => p_insert_allowed
569 ,p_label => p_label
570 ,p_prompt_text => p_prompt_text
571 ,p_prompt_alignment_offset => p_prompt_alignment_offset
572 ,p_prompt_display_style => p_prompt_display_style
573 ,p_prompt_edge => p_prompt_edge
574 ,p_prompt_edge_alignment => p_prompt_edge_alignment
575 ,p_prompt_edge_offset => p_prompt_edge_offset
576 ,p_prompt_text_alignment => p_prompt_text_alignment
577 ,p_query_allowed => p_query_allowed
578 ,p_required => p_required
579 ,p_tooltip_text => p_tooltip_text
580 ,p_update_allowed => p_update_allowed
581 ,p_validation_formula_id => p_validation_formula_id
582 ,p_validation_param_item_id1 => p_validation_param_item_id1
583 ,p_validation_param_item_id2 => p_validation_param_item_id2
584 ,p_validation_param_item_id3 => p_validation_param_item_id3
585 ,p_validation_param_item_id4 => p_validation_param_item_id4
586 ,p_validation_param_item_id5 => p_validation_param_item_id5
587 ,p_visible => p_visible
588 ,p_width => p_width
589 ,p_x_position => p_x_position
590 ,p_y_position => p_y_position
591 ,p_information_category => p_information_category
592 ,p_information1 => p_information1
593 ,p_information2 => p_information2
594 ,p_information3 => p_information3
595 ,p_information4 => p_information4
596 ,p_information5 => p_information5
597 ,p_information6 => p_information6
598 ,p_information7 => p_information7
599 ,p_information8 => p_information8
600 ,p_information9 => p_information9
601 ,p_information10 => p_information10
602 ,p_information11 => p_information11
603 ,p_information12 => p_information12
604 ,p_information13 => p_information13
605 ,p_information14 => p_information14
606 ,p_information15 => p_information15
607 ,p_information16 => p_information16
608 ,p_information17 => p_information17
609 ,p_information18 => p_information18
610 ,p_information19 => p_information19
611 ,p_information20 => p_information20
612 ,p_information21 => p_information21
613 ,p_information22 => p_information22
614 ,p_information23 => p_information23
615 ,p_information24 => p_information24
616 ,p_information25 => p_information25
617 ,p_information26 => p_information26
618 ,p_information27 => p_information27
619 ,p_information28 => p_information28
620 ,p_information29 => p_information29
621 ,p_information30 => p_information30
622 ,p_next_navigation_item_id => p_next_navigation_item_id
623 ,p_previous_navigation_item_id => p_previous_navigation_item_id);
624 exception
625 when hr_api.cannot_find_prog_unit then
626 hr_api.cannot_find_prog_unit_error
627 (p_module_name => 'create_template_item_context'
628 ,p_hook_type => 'BP'
629 );
630 end;
631 --
632 -- Validation in addition to Row Handlers
633 --
634 hr_utility.set_location('At:'|| l_proc, 15);
635
636 OPEN cur_override;
637 FETCH cur_override INTO l_required_override,l_visible_override;
638 CLOSE cur_override;
639
640 hr_utility.set_location('At:'|| l_proc, 20);
641
642 IF p_required <> hr_api.g_number AND
643 ( l_required_override is not null AND p_required is not null ) THEN
644 l_override_value_warning := TRUE;
645 END IF;
646
647 hr_utility.set_location('At:'|| l_proc, 25);
648
649 IF p_visible <> hr_api.g_number AND
650 ( l_visible_override is not null AND p_visible is not null ) THEN
651 l_override_value_warning := TRUE;
652 END IF;
653
654 hr_utility.set_location('At:'|| l_proc, 30);
655
656 OPEN cur_api_val;
657 FETCH cur_api_val INTO l_temp;
658 IF (cur_api_val%NOTFOUND AND
659 hr_form_templates_api.g_session_mode <> 'SEED_DATA') THEN
660 CLOSE cur_api_val;
661 -- error message
662 fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
663 fnd_message.set_token('PROCEDURE', l_proc);
664 fnd_message.set_token('STEP','10');
665 fnd_message.raise_error;
666 END IF;
667 CLOSE cur_api_val;
668
669 hr_utility.set_location('At:'|| l_proc, 35);
670
671 --
672 --
673 -- Process Logic
674 --
675
676 hr_icx_ins.ins_or_sel(
677 p_context_type => p_context_type
678 ,p_segment1 => p_segment1
679 ,p_segment2 => p_segment2
680 ,p_segment3 => p_segment3
681 ,p_segment4 => p_segment4
682 ,p_segment5 => p_segment5
683 ,p_segment6 => p_segment6
684 ,p_segment7 => p_segment7
685 ,p_segment8 => p_segment8
686 ,p_segment9 => p_segment9
687 ,p_segment10 => p_segment10
688 ,p_segment11 => p_segment11
689 ,p_segment12 => p_segment12
690 ,p_segment13 => p_segment13
691 ,p_segment14 => p_segment14
692 ,p_segment15 => p_segment15
693 ,p_segment16 => p_segment16
694 ,p_segment17 => p_segment17
695 ,p_segment18 => p_segment18
696 ,p_segment19 => p_segment19
697 ,p_segment20 => p_segment20
698 ,p_segment21 => p_segment21
699 ,p_segment22 => p_segment22
700 ,p_segment23 => p_segment23
701 ,p_segment24 => p_segment24
702 ,p_segment25 => p_segment25
703 ,p_segment26 => p_segment26
704 ,p_segment27 => p_segment27
705 ,p_segment28 => p_segment28
706 ,p_segment29 => p_segment29
707 ,p_segment30 => p_segment30
708 ,p_item_context_id => l_item_context_id
709 ,p_concatenated_segments => l_concatenated_segments);
710
711 hr_utility.set_location('At:'|| l_proc, 40);
712
713 hr_tic_ins.ins( p_template_item_id => p_template_item_id
714 ,p_context_type => p_context_type
715 ,p_item_context_id => l_item_context_id
716 ,p_template_item_context_id => l_template_item_context_id
717 ,p_object_version_number => l_object_version_number);
718
719 hr_utility.set_location('At:'|| l_proc, 45);
720
721 hr_item_properties_bsi.copy_item_property(
722 p_effective_date => TRUNC(p_effective_date)
723 ,p_language_code => l_language_code
724 ,p_template_item_id => p_template_item_id
725 ,p_template_item_context_id => l_template_item_context_id
726 ,p_alignment => p_alignment
727 ,p_bevel => p_bevel
728 ,p_case_restriction => p_case_restriction
729 ,p_default_value => p_default_value
730 ,p_enabled => p_enabled
731 ,p_format_mask => p_format_mask
732 ,p_height => p_height
733 ,p_information_formula_id => p_information_formula_id
734 ,p_information_param_item_id1 => p_information_param_item_id1
735 ,p_information_param_item_id2 => p_information_param_item_id2
736 ,p_information_param_item_id3 => p_information_param_item_id3
737 ,p_information_param_item_id4 => p_information_param_item_id4
738 ,p_information_param_item_id5 => p_information_param_item_id5
739 ,p_information_prompt => p_information_prompt
740 ,p_insert_allowed => p_insert_allowed
741 ,p_label => p_label
742 ,p_prompt_text => p_prompt_text
743 ,p_prompt_alignment_offset => p_prompt_alignment_offset
744 ,p_prompt_display_style => p_prompt_display_style
745 ,p_prompt_edge => p_prompt_edge
746 ,p_prompt_edge_alignment => p_prompt_edge_alignment
747 ,p_prompt_edge_offset => p_prompt_edge_offset
748 ,p_prompt_text_alignment => p_prompt_text_alignment
749 ,p_query_allowed => p_query_allowed
750 ,p_required => p_required
751 ,p_tooltip_text => p_tooltip_text
752 ,p_update_allowed => p_update_allowed
753 ,p_validation_formula_id => p_validation_formula_id
754 ,p_validation_param_item_id1 => p_validation_param_item_id1
755 ,p_validation_param_item_id2 => p_validation_param_item_id2
756 ,p_validation_param_item_id3 => p_validation_param_item_id3
757 ,p_validation_param_item_id4 => p_validation_param_item_id4
758 ,p_validation_param_item_id5 => p_validation_param_item_id5
759 ,p_visible => p_visible
760 ,p_width => p_width
761 ,p_x_position => p_x_position
762 ,p_y_position => p_y_position
763 ,p_information_category => p_information_category
764 ,p_information1 => p_information1
765 ,p_information2 => p_information2
766 ,p_information3 => p_information3
767 ,p_information4 => p_information4
768 ,p_information5 => p_information5
769 ,p_information6 => p_information6
770 ,p_information7 => p_information7
771 ,p_information8 => p_information8
772 ,p_information9 => p_information9
773 ,p_information10 => p_information10
774 ,p_information11 => p_information11
775 ,p_information12 => p_information12
776 ,p_information13 => p_information13
777 ,p_information14 => p_information14
778 ,p_information15 => p_information15
779 ,p_information16 => p_information16
780 ,p_information17 => p_information17
781 ,p_information18 => p_information18
782 ,p_information19 => p_information19
783 ,p_information20 => p_information20
784 ,p_information21 => p_information21
785 ,p_information22 => p_information22
786 ,p_information23 => p_information23
787 ,p_information24 => p_information24
788 ,p_information25 => p_information25
789 ,p_information26 => p_information26
790 ,p_information27 => p_information27
791 ,p_information28 => p_information28
792 ,p_information29 => p_information29
793 ,p_information30 => p_information30
794 ,p_next_navigation_item_id => p_next_navigation_item_id
795 ,p_previous_navigation_item_id => p_previous_navigation_item_id
796 ,p_item_property_id => l_item_property_id
797 ,p_object_version_number => l_object_version_number);
798 --,p_override_value_warning => l_override_value_warning);
799
800 hr_utility.set_location('At:'|| l_proc, 50);
801
802 IF p_template_tab_page_id is not null THEN
803
804 hr_tcp_api.create_tcp(
805 p_effective_date => TRUNC(p_effective_date)
806 ,p_template_item_context_id => l_template_item_context_id
807 ,p_template_tab_page_id => p_template_tab_page_id
808 ,p_template_item_context_page_i => l_tic_id
809 ,p_object_version_number => l_ovn_item);
810 END IF;
811 hr_utility.set_location('At:'|| l_proc, 55);
812
813 --
814 -- Call After Process User Hook
815 --
816 begin
817 hr_template_item_contexts_bk2.create_template_item_context_a
818 (p_effective_date => TRUNC(p_effective_date)
819 ,p_language_code => l_language_code
820 ,p_template_item_id => p_template_item_id
821 ,p_context_type => p_context_type
822 ,p_segment1 => p_segment1
823 ,p_segment2 => p_segment2
824 ,p_segment3 => p_segment3
825 ,p_segment4 => p_segment4
826 ,p_segment5 => p_segment5
827 ,p_segment6 => p_segment6
828 ,p_segment7 => p_segment7
829 ,p_segment8 => p_segment8
830 ,p_segment9 => p_segment9
831 ,p_segment10 => p_segment10
832 ,p_segment11 => p_segment11
833 ,p_segment12 => p_segment12
834 ,p_segment13 => p_segment13
835 ,p_segment14 => p_segment14
836 ,p_segment15 => p_segment15
837 ,p_segment16 => p_segment16
838 ,p_segment17 => p_segment17
839 ,p_segment18 => p_segment18
840 ,p_segment19 => p_segment19
841 ,p_segment20 => p_segment20
842 ,p_segment21 => p_segment21
843 ,p_segment22 => p_segment22
844 ,p_segment23 => p_segment23
845 ,p_segment24 => p_segment24
846 ,p_segment25 => p_segment25
847 ,p_segment26 => p_segment26
848 ,p_segment27 => p_segment27
849 ,p_segment28 => p_segment28
850 ,p_segment29 => p_segment29
851 ,p_segment30 => p_segment30
852 ,p_template_tab_page_id => p_template_tab_page_id
853 ,p_alignment => p_alignment
854 ,p_bevel => p_bevel
855 ,p_case_restriction => p_case_restriction
856 ,p_default_value => p_default_value
857 ,p_enabled => p_enabled
858 ,p_format_mask => p_format_mask
859 ,p_height => p_height
860 ,p_information_formula_id => p_information_formula_id
861 ,p_information_param_item_id1 => p_information_param_item_id1
862 ,p_information_param_item_id2 => p_information_param_item_id2
863 ,p_information_param_item_id3 => p_information_param_item_id3
864 ,p_information_param_item_id4 => p_information_param_item_id4
865 ,p_information_param_item_id5 => p_information_param_item_id5
866 ,p_information_prompt => p_information_prompt
867 ,p_insert_allowed => p_insert_allowed
868 ,p_label => p_label
869 ,p_prompt_text => p_prompt_text
870 ,p_prompt_alignment_offset => p_prompt_alignment_offset
871 ,p_prompt_display_style => p_prompt_display_style
872 ,p_prompt_edge => p_prompt_edge
873 ,p_prompt_edge_alignment => p_prompt_edge_alignment
874 ,p_prompt_edge_offset => p_prompt_edge_offset
875 ,p_prompt_text_alignment => p_prompt_text_alignment
876 ,p_query_allowed => p_query_allowed
877 ,p_required => p_required
878 ,p_tooltip_text => p_tooltip_text
879 ,p_update_allowed => p_update_allowed
880 ,p_validation_formula_id => p_validation_formula_id
881 ,p_validation_param_item_id1 => p_validation_param_item_id1
882 ,p_validation_param_item_id2 => p_validation_param_item_id2
883 ,p_validation_param_item_id3 => p_validation_param_item_id3
884 ,p_validation_param_item_id4 => p_validation_param_item_id4
885 ,p_validation_param_item_id5 => p_validation_param_item_id5
886 ,p_visible => p_visible
887 ,p_width => p_width
888 ,p_x_position => p_x_position
889 ,p_y_position => p_y_position
890 ,p_information_category => p_information_category
891 ,p_information1 => p_information1
892 ,p_information2 => p_information2
893 ,p_information3 => p_information3
894 ,p_information4 => p_information4
895 ,p_information5 => p_information5
896 ,p_information6 => p_information6
897 ,p_information7 => p_information7
898 ,p_information8 => p_information8
899 ,p_information9 => p_information9
900 ,p_information10 => p_information10
901 ,p_information11 => p_information11
902 ,p_information12 => p_information12
903 ,p_information13 => p_information13
904 ,p_information14 => p_information14
905 ,p_information15 => p_information15
906 ,p_information16 => p_information16
907 ,p_information17 => p_information17
908 ,p_information18 => p_information18
909 ,p_information19 => p_information19
910 ,p_information20 => p_information20
911 ,p_information21 => p_information21
912 ,p_information22 => p_information22
913 ,p_information23 => p_information23
914 ,p_information24 => p_information24
915 ,p_information25 => p_information25
916 ,p_information26 => p_information26
917 ,p_information27 => p_information27
918 ,p_information28 => p_information28
919 ,p_information29 => p_information29
920 ,p_information30 => p_information30
921 ,p_next_navigation_item_id => p_next_navigation_item_id
922 ,p_previous_navigation_item_id => p_previous_navigation_item_id
923 ,p_template_item_context_id => l_template_item_context_id
924 ,p_object_version_number => l_object_version_number
925 ,p_item_context_id => l_item_context_id
926 ,p_concatenated_segments => l_concatenated_segments
927 ,p_override_value_warning => l_override_value_warning
928 );
929 exception
930 when hr_api.cannot_find_prog_unit then
931 hr_api.cannot_find_prog_unit_error
932 (p_module_name => 'create_template_item_context'
933 ,p_hook_type => 'AP'
934 );
935 end;
936 --
937 -- When in validation only mode raise the Validate_Enabled exception
938 --
939 if p_validate then
940 raise hr_api.validate_enabled;
941 end if;
942 --
943 -- Set all output arguments
944 --
945 p_template_item_context_id := l_template_item_context_id;
946 p_object_version_number := l_object_version_number;
947 p_item_context_id := l_item_context_id;
948 p_concatenated_segments := l_concatenated_segments;
949 p_override_value_warning := l_override_value_warning;
950 --
951 hr_utility.set_location(' Leaving:'||l_proc, 70);
952 exception
953 when hr_api.validate_enabled then
954 --
955 -- As the Validate_Enabled exception has been raised
956 -- we must rollback to the savepoint
957 --
958 rollback to create_template_item_context;
959 --
960 -- Only set output warning arguments
961 -- (Any key or derived arguments must be set to null
962 -- when validation only mode is being used.)
963 --
964 p_template_item_context_id := null;
965 p_object_version_number := null;
966 p_item_context_id := null;
967 p_concatenated_segments := null;
968 p_override_value_warning := l_override_value_warning;
969 hr_utility.set_location(' Leaving:'||l_proc, 80);
970 when others then
971 --
972 -- A validation or unexpected error has occured
973 --
974 p_template_item_context_id := null;
975 p_object_version_number := null;
976 p_item_context_id := null;
977 p_concatenated_segments := null;
978 p_override_value_warning := null;
979
980 rollback to create_template_item_context;
981 hr_utility.set_location(' Leaving:'||l_proc, 90);
982 raise;
983 end create_template_item_context;
984 --
985 -- ----------------------------------------------------------------------------
986 -- |----------------< delete_template_item_context >--------------------------|
987 -- ----------------------------------------------------------------------------
988 --
989 procedure delete_template_item_context
990 (p_validate in boolean default false
991 ,p_template_item_context_id in number
992 ,p_object_version_number in number
993 --,p_delete_children_flag in varchar2 default 'N'
994 ) is
995 --
996 -- Declare cursors and local variables
997 --
998
999 CURSOR cur_tmplt_item
1000 IS
1001 SELECT template_item_context_page_id
1002 ,object_version_number
1003 FROM hr_template_item_context_pages
1004 WHERE template_item_context_id = p_template_item_context_id;
1005
1006 l_temp number;
1007
1008 CURSOR cur_api_val
1009 IS
1010 SELECT source_form_template_id
1011 FROM hr_source_form_templates hsf
1012 ,hr_template_items_b hti
1013 ,hr_template_item_contexts_b tic
1014 WHERE hsf.form_template_id_to = hti.form_template_id
1015 AND hti.template_item_id = tic.template_item_id
1016 AND tic.template_item_context_id = p_template_item_context_id;
1017
1018 l_proc varchar2(72) := g_package||'delete_template_item_context';
1019 begin
1020 hr_utility.set_location('Entering:'|| l_proc, 10);
1021 --
1022 -- Issue a savepoint
1023 --
1024 savepoint delete_template_item_context;
1025 --
1026 -- Call Before Process User Hook
1027 --
1028 begin
1029 hr_template_item_contexts_bk3.delete_template_item_context_b
1030 (p_template_item_context_id => p_template_item_context_id
1031 ,p_object_version_number => p_object_version_number
1032 --,p_delete_children_flag => p_delete_children_flag
1033 );
1034 exception
1035 when hr_api.cannot_find_prog_unit then
1036 hr_api.cannot_find_prog_unit_error
1037 (p_module_name => 'delete_template_item_context'
1038 ,p_hook_type => 'BP'
1039 );
1040 end;
1041 --
1042 -- Validation in addition to Row Handlers
1043 --
1044 hr_utility.set_location('At:'|| l_proc, 15);
1045
1046 OPEN cur_api_val;
1047 FETCH cur_api_val INTO l_temp;
1048 IF (cur_api_val%NOTFOUND AND
1049 hr_form_templates_api.g_session_mode <> 'SEED_DATA') THEN
1050 CLOSE cur_api_val;
1051 -- error message
1052 fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1053 fnd_message.set_token('PROCEDURE', l_proc);
1054 fnd_message.set_token('STEP','10');
1055 fnd_message.raise_error;
1056 END IF;
1057 CLOSE cur_api_val;
1058 --
1059 --
1060 -- Process Logic
1061 --
1062 hr_utility.set_location('At:'|| l_proc, 20);
1063
1064 hr_utility.set_location('At:'|| l_proc, 25);
1065
1066 FOR cur_rec IN cur_tmplt_item LOOP
1067 hr_tcp_api.delete_tcp(
1068 p_template_item_context_page_i => cur_rec.template_item_context_page_id
1069 ,p_object_version_number => cur_rec.object_version_number);
1070 --,p_delete_all_flag => 'Y');
1071 END LOOP;
1072
1073 hr_utility.set_location('At:'|| l_proc, 30);
1074
1075 hr_item_properties_bsi.delete_item_property(
1076 p_template_item_context_id => p_template_item_context_id
1077 ,p_object_version_number => p_object_version_number);
1078
1079 hr_utility.set_location('At:'|| l_proc, 35);
1080
1081 hr_tic_del.del( p_template_item_context_id => p_template_item_context_id
1082 ,p_object_version_number => p_object_version_number);
1083
1084 --
1085 -- Call After Process User Hook
1086 --
1087 hr_utility.set_location('At:'|| l_proc, 40);
1088
1089 begin
1090 hr_template_item_contexts_bk3.delete_template_item_context_a
1091 (p_template_item_context_id => p_template_item_context_id
1092 ,p_object_version_number => p_object_version_number
1093 --,p_delete_children_flag => p_delete_children_flag
1094 );
1095 exception
1096 when hr_api.cannot_find_prog_unit then
1097 hr_api.cannot_find_prog_unit_error
1098 (p_module_name => 'delete_template_item_context'
1099 ,p_hook_type => 'AP'
1100 );
1101 end;
1102 --
1103 -- When in validation only mode raise the Validate_Enabled exception
1104 --
1105 hr_utility.set_location('At:'|| l_proc, 45);
1106
1107 if p_validate then
1108 raise hr_api.validate_enabled;
1109 end if;
1110 --
1111 hr_utility.set_location(' Leaving:'||l_proc, 70);
1112 exception
1113 when hr_api.validate_enabled then
1114 --
1115 -- As the Validate_Enabled exception has been raised
1116 -- we must rollback to the savepoint
1117 --
1118 rollback to delete_template_item_context;
1119 --
1120 -- Only set output warning arguments
1121 -- (Any key or derived arguments must be set to null
1122 -- when validation only mode is being used.)
1123 --
1124 hr_utility.set_location(' Leaving:'||l_proc, 80);
1125 when others then
1126 --
1127 -- A validation or unexpected error has occured
1128 --
1129 rollback to delete_template_item_context;
1130 hr_utility.set_location(' Leaving:'||l_proc, 90);
1131 raise;
1132 end delete_template_item_context;
1133 --
1134 -- ----------------------------------------------------------------------------
1135 -- |--------------------------< update_template_item_context >----------------|
1136 -- ----------------------------------------------------------------------------
1137 --
1138 procedure update_template_item_context
1139 (p_validate in boolean default false
1140 ,p_effective_date in date
1141 ,p_language_code in varchar2 default hr_api.userenv_lang
1142 --,p_context_type in varchar2 default hr_api.g_varchar2
1143 ,p_template_item_context_id in number
1144 ,p_object_version_number in out nocopy number
1145 --,p_segment1 in varchar2 default hr_api.g_varchar2
1146 --,p_segment2 in varchar2 default hr_api.g_varchar2
1147 --,p_segment3 in varchar2 default hr_api.g_varchar2
1148 --,p_segment4 in varchar2 default hr_api.g_varchar2
1149 --,p_segment5 in varchar2 default hr_api.g_varchar2
1150 --,p_segment6 in varchar2 default hr_api.g_varchar2
1151 --,p_segment7 in varchar2 default hr_api.g_varchar2
1152 --,p_segment8 in varchar2 default hr_api.g_varchar2
1153 --,p_segment9 in varchar2 default hr_api.g_varchar2
1154 --,p_segment10 in varchar2 default hr_api.g_varchar2
1155 --,p_segment11 in varchar2 default hr_api.g_varchar2
1156 --,p_segment12 in varchar2 default hr_api.g_varchar2
1157 --,p_segment13 in varchar2 default hr_api.g_varchar2
1158 --,p_segment14 in varchar2 default hr_api.g_varchar2
1159 --,p_segment15 in varchar2 default hr_api.g_varchar2
1160 --,p_segment16 in varchar2 default hr_api.g_varchar2
1161 --,p_segment17 in varchar2 default hr_api.g_varchar2
1162 --,p_segment18 in varchar2 default hr_api.g_varchar2
1163 --,p_segment19 in varchar2 default hr_api.g_varchar2
1164 --,p_segment20 in varchar2 default hr_api.g_varchar2
1165 --,p_segment21 in varchar2 default hr_api.g_varchar2
1166 --,p_segment22 in varchar2 default hr_api.g_varchar2
1167 --,p_segment23 in varchar2 default hr_api.g_varchar2
1168 --,p_segment24 in varchar2 default hr_api.g_varchar2
1169 --,p_segment25 in varchar2 default hr_api.g_varchar2
1170 --,p_segment26 in varchar2 default hr_api.g_varchar2
1171 --,p_segment27 in varchar2 default hr_api.g_varchar2
1172 --,p_segment28 in varchar2 default hr_api.g_varchar2
1173 --,p_segment29 in varchar2 default hr_api.g_varchar2
1174 --,p_segment30 in varchar2 default hr_api.g_varchar2
1175 ,p_template_tab_page_id in number default hr_api.g_number
1176 ,p_alignment in number default hr_api.g_number
1177 ,p_bevel in number default hr_api.g_number
1178 ,p_case_restriction in number default hr_api.g_number
1179 ,p_default_value in varchar2 default hr_api.g_varchar2
1180 ,p_enabled in number default hr_api.g_number
1181 ,p_format_mask in varchar2 default hr_api.g_varchar2
1182 ,p_height in number default hr_api.g_number
1183 ,p_information_formula_id in number default hr_api.g_number
1184 ,p_information_param_item_id1 in number default hr_api.g_number
1185 ,p_information_param_item_id2 in number default hr_api.g_number
1186 ,p_information_param_item_id3 in number default hr_api.g_number
1187 ,p_information_param_item_id4 in number default hr_api.g_number
1188 ,p_information_param_item_id5 in number default hr_api.g_number
1189 ,p_information_prompt in varchar2 default hr_api.g_varchar2
1190 ,p_insert_allowed in number default hr_api.g_number
1191 ,p_label in varchar2 default hr_api.g_varchar2
1192 ,p_prompt_text in varchar2 default hr_api.g_varchar2
1193 ,p_prompt_alignment_offset in number default hr_api.g_number
1194 ,p_prompt_display_style in number default hr_api.g_number
1195 ,p_prompt_edge in number default hr_api.g_number
1196 ,p_prompt_edge_alignment in number default hr_api.g_number
1197 ,p_prompt_edge_offset in number default hr_api.g_number
1198 ,p_prompt_text_alignment in number default hr_api.g_number
1199 ,p_query_allowed in number default hr_api.g_number
1200 ,p_required in number default hr_api.g_number
1201 ,p_tooltip_text in varchar2 default hr_api.g_varchar2
1202 ,p_update_allowed in number default hr_api.g_number
1203 ,p_validation_formula_id in number default hr_api.g_number
1204 ,p_validation_param_item_id1 in number default hr_api.g_number
1205 ,p_validation_param_item_id2 in number default hr_api.g_number
1206 ,p_validation_param_item_id3 in number default hr_api.g_number
1207 ,p_validation_param_item_id4 in number default hr_api.g_number
1208 ,p_validation_param_item_id5 in number default hr_api.g_number
1209 ,p_visible in number default hr_api.g_number
1210 ,p_width in number default hr_api.g_number
1211 ,p_x_position in number default hr_api.g_number
1212 ,p_y_position in number default hr_api.g_number
1213 ,p_information_category in varchar2 default hr_api.g_varchar2
1214 ,p_information1 in varchar2 default hr_api.g_varchar2
1215 ,p_information2 in varchar2 default hr_api.g_varchar2
1216 ,p_information3 in varchar2 default hr_api.g_varchar2
1217 ,p_information4 in varchar2 default hr_api.g_varchar2
1218 ,p_information5 in varchar2 default hr_api.g_varchar2
1219 ,p_information6 in varchar2 default hr_api.g_varchar2
1220 ,p_information7 in varchar2 default hr_api.g_varchar2
1221 ,p_information8 in varchar2 default hr_api.g_varchar2
1222 ,p_information9 in varchar2 default hr_api.g_varchar2
1223 ,p_information10 in varchar2 default hr_api.g_varchar2
1224 ,p_information11 in varchar2 default hr_api.g_varchar2
1225 ,p_information12 in varchar2 default hr_api.g_varchar2
1226 ,p_information13 in varchar2 default hr_api.g_varchar2
1227 ,p_information14 in varchar2 default hr_api.g_varchar2
1228 ,p_information15 in varchar2 default hr_api.g_varchar2
1229 ,p_information16 in varchar2 default hr_api.g_varchar2
1230 ,p_information17 in varchar2 default hr_api.g_varchar2
1231 ,p_information18 in varchar2 default hr_api.g_varchar2
1232 ,p_information19 in varchar2 default hr_api.g_varchar2
1233 ,p_information20 in varchar2 default hr_api.g_varchar2
1234 ,p_information21 in varchar2 default hr_api.g_varchar2
1235 ,p_information22 in varchar2 default hr_api.g_varchar2
1236 ,p_information23 in varchar2 default hr_api.g_varchar2
1237 ,p_information24 in varchar2 default hr_api.g_varchar2
1238 ,p_information25 in varchar2 default hr_api.g_varchar2
1239 ,p_information26 in varchar2 default hr_api.g_varchar2
1240 ,p_information27 in varchar2 default hr_api.g_varchar2
1241 ,p_information28 in varchar2 default hr_api.g_varchar2
1242 ,p_information29 in varchar2 default hr_api.g_varchar2
1243 ,p_information30 in varchar2 default hr_api.g_varchar2
1244 ,p_next_navigation_item_id in number default hr_api.g_number
1245 ,p_previous_navigation_item_id in number default hr_api.g_number
1246 --,p_item_context_id out number
1247 --,p_concatenated_segments out varchar2
1248 ,p_override_value_warning out nocopy boolean
1249 ) is
1250 --
1251 -- Declare cursors and local variables
1252 --
1253
1254 l_required_override number := null;
1255 l_form_tab_page_id_override number := null;
1256 l_visible_override number := null;
1257
1258
1259 CURSOR cur_override
1260 IS
1261 SELECT required_override
1262 ,visible_override
1263 FROM hr_form_items_b hfi
1264 ,hr_template_items_b hti
1265 ,hr_template_item_contexts_b tic
1266 WHERE hfi.form_item_id = hti.form_item_id
1267 AND hti.template_item_id = tic.template_item_id
1268 AND tic.template_item_context_id = p_template_item_context_id;
1269
1270 l_temp number;
1271
1272 CURSOR cur_api_val
1273 IS
1274 SELECT source_form_template_id
1275 FROM hr_source_form_templates hsf
1276 ,hr_template_items_b hti
1277 ,hr_template_item_contexts_b tic
1278 WHERE hsf.form_template_id_to = hti.form_template_id
1279 AND hti.template_item_id = tic.template_item_id
1280 AND tic.template_item_context_id = p_template_item_context_id;
1281
1282 --CURSOR cur_context
1283 --IS
1284 --SELECT DECODE(context_type,hr_api.g_varchar2,context_type,p_context_type)
1285 --FROM hr_template_item_contexts_b
1286 --WHERE template_item_context_id = p_template_item_context_id;
1287
1288 --l_context_type varchar2(30);
1289 l_object_version_number number;
1290 -- l_item_context_id number;
1291 --l_concatenated_segments varchar2(2000);
1292 l_override_value_warning boolean := FALSE;
1293
1294 l_language_code fnd_languages.language_code%TYPE;
1295
1296 l_proc varchar2(72) := g_package||'update_template_item_context';
1297 begin
1298 hr_utility.set_location('Entering:'|| l_proc, 10);
1299 --
1300 -- Issue a savepoint
1301 --
1302 savepoint update_template_item_context;
1303 --
1304 -- Truncate the time portion from all IN date parameters
1305 --
1306 -- p_effective_date := TRUNC(p_effective_date);
1307 l_object_version_number := p_object_version_number;
1308 --
1309 -- Validate the language parameter. l_language_code should be passed
1310 -- instead of p_language_code from now on, to allow an IN OUT parameter to
1311 -- be passed through.
1312 --
1313 l_language_code := p_language_code;
1314 hr_api.validate_language_code(p_language_code => l_language_code);
1315 --
1316 hr_utility.set_location(l_proc, 20);
1317 --
1318 --
1319 -- Call Before Process User Hook
1320 --
1321 begin
1322 hr_template_item_contexts_bk4.update_template_item_context_b
1323 (p_effective_date => TRUNC(p_effective_date)
1324 ,p_language_code => l_language_code
1325 --,p_context_type => p_context_type
1326 ,p_template_item_context_id => p_template_item_context_id
1327 ,p_object_version_number => l_object_version_number
1328 -- ,p_segment1 => p_segment1
1329 -- ,p_segment2 => p_segment2
1330 -- ,p_segment3 => p_segment3
1331 -- ,p_segment4 => p_segment4
1332 -- ,p_segment5 => p_segment5
1333 -- ,p_segment6 => p_segment6
1334 -- ,p_segment7 => p_segment7
1335 -- ,p_segment8 => p_segment8
1336 -- ,p_segment9 => p_segment9
1337 -- ,p_segment10 => p_segment10
1338 -- ,p_segment11 => p_segment11
1339 -- ,p_segment12 => p_segment12
1340 -- ,p_segment13 => p_segment13
1341 -- ,p_segment14 => p_segment14
1342 -- ,p_segment15 => p_segment15
1343 -- ,p_segment16 => p_segment16
1344 -- ,p_segment17 => p_segment17
1345 -- ,p_segment18 => p_segment18
1346 -- ,p_segment19 => p_segment19
1347 -- ,p_segment20 => p_segment20
1348 -- ,p_segment21 => p_segment21
1349 -- ,p_segment22 => p_segment22
1350 -- ,p_segment23 => p_segment23
1351 -- ,p_segment24 => p_segment24
1352 -- ,p_segment25 => p_segment25
1353 -- ,p_segment26 => p_segment26
1354 -- ,p_segment27 => p_segment27
1355 -- ,p_segment28 => p_segment28
1356 -- ,p_segment29 => p_segment29
1357 -- ,p_segment30 => p_segment30
1358 ,p_template_tab_page_id => p_template_tab_page_id
1359 ,p_alignment => p_alignment
1360 ,p_bevel => p_bevel
1361 ,p_case_restriction => p_case_restriction
1362 ,p_default_value => p_default_value
1363 ,p_enabled => p_enabled
1364 ,p_format_mask => p_format_mask
1365 ,p_height => p_height
1366 ,p_information_formula_id => p_information_formula_id
1367 ,p_information_param_item_id1 => p_information_param_item_id1
1368 ,p_information_param_item_id2 => p_information_param_item_id2
1369 ,p_information_param_item_id3 => p_information_param_item_id3
1370 ,p_information_param_item_id4 => p_information_param_item_id4
1371 ,p_information_param_item_id5 => p_information_param_item_id5
1372 ,p_information_prompt => p_information_prompt
1373 ,p_insert_allowed => p_insert_allowed
1374 ,p_label => p_label
1375 ,p_prompt_text => p_prompt_text
1376 ,p_prompt_alignment_offset => p_prompt_alignment_offset
1377 ,p_prompt_display_style => p_prompt_display_style
1378 ,p_prompt_edge => p_prompt_edge
1379 ,p_prompt_edge_alignment => p_prompt_edge_alignment
1380 ,p_prompt_edge_offset => p_prompt_edge_offset
1381 ,p_prompt_text_alignment => p_prompt_text_alignment
1382 ,p_query_allowed => p_query_allowed
1383 ,p_required => p_required
1384 ,p_tooltip_text => p_tooltip_text
1385 ,p_update_allowed => p_update_allowed
1386 ,p_validation_formula_id => p_validation_formula_id
1387 ,p_validation_param_item_id1 => p_validation_param_item_id1
1388 ,p_validation_param_item_id2 => p_validation_param_item_id2
1389 ,p_validation_param_item_id3 => p_validation_param_item_id3
1390 ,p_validation_param_item_id4 => p_validation_param_item_id4
1391 ,p_validation_param_item_id5 => p_validation_param_item_id5
1392 ,p_visible => p_visible
1393 ,p_width => p_width
1394 ,p_x_position => p_x_position
1395 ,p_y_position => p_y_position
1396 ,p_information_category => p_information_category
1397 ,p_information1 => p_information1
1398 ,p_information2 => p_information2
1399 ,p_information3 => p_information3
1400 ,p_information4 => p_information4
1401 ,p_information5 => p_information5
1402 ,p_information6 => p_information6
1403 ,p_information7 => p_information7
1404 ,p_information8 => p_information8
1405 ,p_information9 => p_information9
1406 ,p_information10 => p_information10
1407 ,p_information11 => p_information11
1408 ,p_information12 => p_information12
1409 ,p_information13 => p_information13
1410 ,p_information14 => p_information14
1411 ,p_information15 => p_information15
1412 ,p_information16 => p_information16
1413 ,p_information17 => p_information17
1414 ,p_information18 => p_information18
1415 ,p_information19 => p_information19
1416 ,p_information20 => p_information20
1417 ,p_information21 => p_information21
1418 ,p_information22 => p_information22
1419 ,p_information23 => p_information23
1420 ,p_information24 => p_information24
1421 ,p_information25 => p_information25
1422 ,p_information26 => p_information26
1423 ,p_information27 => p_information27
1424 ,p_information28 => p_information28
1425 ,p_information29 => p_information29
1426 ,p_information30 => p_information30
1427 ,p_next_navigation_item_id => p_next_navigation_item_id
1428 ,p_previous_navigation_item_id => p_previous_navigation_item_id);
1429 exception
1430 when hr_api.cannot_find_prog_unit then
1431 hr_api.cannot_find_prog_unit_error
1432 (p_module_name => 'update_template_item_context'
1433 ,p_hook_type => 'BP'
1434 );
1435 end;
1436 --
1437 -- Validation in addition to Row Handlers
1438 --
1439 hr_utility.set_location('At:'|| l_proc, 15);
1440
1441 OPEN cur_override;
1442 FETCH cur_override INTO l_required_override,l_visible_override;
1443 CLOSE cur_override;
1444
1445 hr_utility.set_location('At:'|| l_proc, 20);
1446
1447 IF p_required <> hr_api.g_number AND
1448 ( l_required_override is not null AND p_required is not null ) THEN
1449 l_override_value_warning := TRUE;
1450 END IF;
1451
1452 hr_utility.set_location('At:'|| l_proc, 25);
1453
1454 IF p_visible <> hr_api.g_number AND
1455 ( l_visible_override is not null AND p_visible is not null ) THEN
1456 l_override_value_warning := TRUE;
1457 END IF;
1458
1459 hr_utility.set_location('At:'|| l_proc, 30);
1460
1461 OPEN cur_api_val;
1462 FETCH cur_api_val INTO l_temp;
1463 IF (cur_api_val%NOTFOUND AND
1464 hr_form_templates_api.g_session_mode <> 'SEED_DATA') THEN
1465 CLOSE cur_api_val;
1466 -- error message
1467 fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1468 fnd_message.set_token('PROCEDURE', l_proc);
1469 fnd_message.set_token('STEP','10');
1470 fnd_message.raise_error;
1471 END IF;
1472 CLOSE cur_api_val;
1473 hr_utility.set_location('At:'|| l_proc, 35);
1474
1475 --
1476 --
1477 -- Process Logic
1478 --
1479
1480 --
1481 --
1482 --OPEN cur_context;
1483 --FETCH cur_context into l_context_type;
1484 --CLOSE cur_context;
1485 --
1486 --
1487 -- hr_icx_upd.upd_or_sel(
1488 -- p_context_type => l_context_type
1489 -- ,p_segment1 => p_segment1
1490 -- ,p_segment2 => p_segment2
1491 -- ,p_segment3 => p_segment3
1492 -- ,p_segment4 => p_segment4
1493 -- ,p_segment5 => p_segment5
1494 -- ,p_segment6 => p_segment6
1495 -- ,p_segment7 => p_segment7
1496 -- ,p_segment8 => p_segment8
1497 -- ,p_segment9 => p_segment9
1498 -- ,p_segment10 => p_segment10
1499 -- ,p_segment11 => p_segment11
1500 -- ,p_segment12 => p_segment12
1501 -- ,p_segment13 => p_segment13
1502 -- ,p_segment14 => p_segment14
1503 -- ,p_segment15 => p_segment15
1504 -- ,p_segment16 => p_segment16
1505 -- ,p_segment17 => p_segment17
1506 -- ,p_segment18 => p_segment18
1507 -- ,p_segment19 => p_segment19
1508 -- ,p_segment20 => p_segment20
1509 -- ,p_segment21 => p_segment21
1510 -- ,p_segment22 => p_segment22
1511 -- ,p_segment23 => p_segment23
1512 -- ,p_segment24 => p_segment24
1513 -- ,p_segment25 => p_segment25
1514 -- ,p_segment26 => p_segment26
1515 -- ,p_segment27 => p_segment27
1516 -- ,p_segment28 => p_segment28
1517 -- ,p_segment29 => p_segment29
1518 --,p_segment30 => p_segment30
1519 --,p_item_context_id => l_item_context_id
1520 --,p_concatenated_segments => l_concatenated_segments);
1521
1522 --hr_tic_upd.upd(p_template_item_context_id => p_template_item_context_id
1523 --,p_object_version_number => l_object_version_number
1524 --,p_context_type => l_context_type
1525 --,p_item_context_id => l_item_context_id);
1526
1527 hr_utility.set_location('At:'|| l_proc, 40);
1528
1529 hr_utility.set_location('At:'|| l_proc, 45);
1530
1531 hr_item_properties_bsi.update_item_property(
1532 p_effective_date => TRUNC(p_effective_date)
1533 ,p_language_code => l_language_code
1534 ,p_object_version_number => l_object_version_number
1535 ,p_template_item_context_id => p_template_item_context_id
1536 ,p_alignment => p_alignment
1537 ,p_bevel => p_bevel
1538 ,p_case_restriction => p_case_restriction
1539 ,p_default_value => p_default_value
1540 ,p_enabled => p_enabled
1541 ,p_format_mask => p_format_mask
1542 ,p_height => p_height
1543 ,p_information_formula_id => p_information_formula_id
1544 ,p_information_param_item_id1 => p_information_param_item_id1
1545 ,p_information_param_item_id2 => p_information_param_item_id2
1546 ,p_information_param_item_id3 => p_information_param_item_id3
1547 ,p_information_param_item_id4 => p_information_param_item_id4
1548 ,p_information_param_item_id5 => p_information_param_item_id5
1549 ,p_information_prompt => p_information_prompt
1550 ,p_insert_allowed => p_insert_allowed
1551 ,p_label => p_label
1552 ,p_prompt_text => p_prompt_text
1553 ,p_prompt_alignment_offset => p_prompt_alignment_offset
1554 ,p_prompt_display_style => p_prompt_display_style
1555 ,p_prompt_edge => p_prompt_edge
1556 ,p_prompt_edge_alignment => p_prompt_edge_alignment
1557 ,p_prompt_edge_offset => p_prompt_edge_offset
1558 ,p_prompt_text_alignment => p_prompt_text_alignment
1559 ,p_query_allowed => p_query_allowed
1560 ,p_required => p_required
1561 ,p_tooltip_text => p_tooltip_text
1562 ,p_update_allowed => p_update_allowed
1563 ,p_validation_formula_id => p_validation_formula_id
1564 ,p_validation_param_item_id1 => p_validation_param_item_id1
1565 ,p_validation_param_item_id2 => p_validation_param_item_id2
1566 ,p_validation_param_item_id3 => p_validation_param_item_id3
1567 ,p_validation_param_item_id4 => p_validation_param_item_id4
1568 ,p_validation_param_item_id5 => p_validation_param_item_id5
1569 ,p_visible => p_visible
1570 ,p_width => p_width
1571 ,p_x_position => p_x_position
1572 ,p_y_position => p_y_position
1573 ,p_information_category => p_information_category
1574 ,p_information1 => p_information1
1575 ,p_information2 => p_information2
1576 ,p_information3 => p_information3
1577 ,p_information4 => p_information4
1578 ,p_information5 => p_information5
1579 ,p_information6 => p_information6
1580 ,p_information7 => p_information7
1581 ,p_information8 => p_information8
1582 ,p_information9 => p_information9
1583 ,p_information10 => p_information10
1584 ,p_information11 => p_information11
1585 ,p_information12 => p_information12
1586 ,p_information13 => p_information13
1587 ,p_information14 => p_information14
1588 ,p_information15 => p_information15
1589 ,p_information16 => p_information16
1590 ,p_information17 => p_information17
1591 ,p_information18 => p_information18
1592 ,p_information19 => p_information19
1593 ,p_information20 => p_information20
1594 ,p_information21 => p_information21
1595 ,p_information22 => p_information22
1596 ,p_information23 => p_information23
1597 ,p_information24 => p_information24
1598 ,p_information25 => p_information25
1599 ,p_information26 => p_information26
1600 ,p_information27 => p_information27
1601 ,p_information28 => p_information28
1602 ,p_information29 => p_information29
1603 ,p_information30 => p_information30
1604 ,p_next_navigation_item_id => p_next_navigation_item_id
1605 ,p_previous_navigation_item_id => p_previous_navigation_item_id);
1606 --,p_override_value_warning => l_override_value_warning);
1607
1608 hr_utility.set_location('At:'|| l_proc, 50);
1609
1610 --
1611 -- Call After Process User Hook
1612 --
1613 begin
1614 hr_template_item_contexts_bk4.update_template_item_context_a
1615 (p_effective_date => TRUNC(p_effective_date)
1616 ,p_language_code => l_language_code
1617 --,p_context_type => p_context_type
1618 ,p_template_item_context_id => p_template_item_context_id
1619 ,p_object_version_number => l_object_version_number
1620 -- ,p_segment1 => p_segment1
1621 -- ,p_segment2 => p_segment2
1622 -- ,p_segment3 => p_segment3
1623 -- ,p_segment4 => p_segment4
1624 -- ,p_segment5 => p_segment5
1625 -- ,p_segment6 => p_segment6
1626 -- ,p_segment7 => p_segment7
1627 -- ,p_segment8 => p_segment8
1628 -- ,p_segment9 => p_segment9
1629 -- ,p_segment10 => p_segment10
1630 -- ,p_segment11 => p_segment11
1631 -- ,p_segment12 => p_segment12
1632 -- ,p_segment13 => p_segment13
1633 -- ,p_segment14 => p_segment14
1634 -- ,p_segment15 => p_segment15
1635 -- ,p_segment16 => p_segment16
1636 -- ,p_segment17 => p_segment17
1637 -- ,p_segment18 => p_segment18
1638 -- ,p_segment19 => p_segment19
1639 -- ,p_segment20 => p_segment20
1640 -- ,p_segment21 => p_segment21
1641 -- ,p_segment22 => p_segment22
1642 -- ,p_segment23 => p_segment23
1643 -- ,p_segment24 => p_segment24
1644 -- ,p_segment25 => p_segment25
1645 -- ,p_segment26 => p_segment26
1646 -- ,p_segment27 => p_segment27
1647 -- ,p_segment28 => p_segment28
1648 -- ,p_segment29 => p_segment29
1649 -- ,p_segment30 => p_segment30
1650 ,p_template_tab_page_id => p_template_tab_page_id
1651 ,p_alignment => p_alignment
1652 ,p_bevel => p_bevel
1653 ,p_case_restriction => p_case_restriction
1654 ,p_default_value => p_default_value
1655 ,p_enabled => p_enabled
1656 ,p_format_mask => p_format_mask
1657 ,p_height => p_height
1658 ,p_information_formula_id => p_information_formula_id
1659 ,p_information_param_item_id1 => p_information_param_item_id1
1660 ,p_information_param_item_id2 => p_information_param_item_id2
1661 ,p_information_param_item_id3 => p_information_param_item_id3
1662 ,p_information_param_item_id4 => p_information_param_item_id4
1663 ,p_information_param_item_id5 => p_information_param_item_id5
1664 ,p_information_prompt => p_information_prompt
1665 ,p_insert_allowed => p_insert_allowed
1666 ,p_label => p_label
1667 ,p_prompt_text => p_prompt_text
1668 ,p_prompt_alignment_offset => p_prompt_alignment_offset
1669 ,p_prompt_display_style => p_prompt_display_style
1670 ,p_prompt_edge => p_prompt_edge
1671 ,p_prompt_edge_alignment => p_prompt_edge_alignment
1672 ,p_prompt_edge_offset => p_prompt_edge_offset
1673 ,p_prompt_text_alignment => p_prompt_text_alignment
1674 ,p_query_allowed => p_query_allowed
1675 ,p_required => p_required
1676 ,p_tooltip_text => p_tooltip_text
1677 ,p_update_allowed => p_update_allowed
1678 ,p_validation_formula_id => p_validation_formula_id
1679 ,p_validation_param_item_id1 => p_validation_param_item_id1
1680 ,p_validation_param_item_id2 => p_validation_param_item_id2
1681 ,p_validation_param_item_id3 => p_validation_param_item_id3
1682 ,p_validation_param_item_id4 => p_validation_param_item_id4
1683 ,p_validation_param_item_id5 => p_validation_param_item_id5
1684 ,p_visible => p_visible
1685 ,p_width => p_width
1686 ,p_x_position => p_x_position
1687 ,p_y_position => p_y_position
1688 ,p_information_category => p_information_category
1689 ,p_information1 => p_information1
1690 ,p_information2 => p_information2
1691 ,p_information3 => p_information3
1692 ,p_information4 => p_information4
1693 ,p_information5 => p_information5
1694 ,p_information6 => p_information6
1695 ,p_information7 => p_information7
1696 ,p_information8 => p_information8
1697 ,p_information9 => p_information9
1698 ,p_information10 => p_information10
1699 ,p_information11 => p_information11
1700 ,p_information12 => p_information12
1701 ,p_information13 => p_information13
1702 ,p_information14 => p_information14
1703 ,p_information15 => p_information15
1704 ,p_information16 => p_information16
1705 ,p_information17 => p_information17
1706 ,p_information18 => p_information18
1707 ,p_information19 => p_information19
1708 ,p_information20 => p_information20
1709 ,p_information21 => p_information21
1710 ,p_information22 => p_information22
1711 ,p_information23 => p_information23
1712 ,p_information24 => p_information24
1713 ,p_information25 => p_information25
1714 ,p_information26 => p_information26
1715 ,p_information27 => p_information27
1716 ,p_information28 => p_information28
1717 ,p_information29 => p_information29
1718 ,p_information30 => p_information30
1719 ,p_next_navigation_item_id => p_next_navigation_item_id
1720 ,p_previous_navigation_item_id => p_previous_navigation_item_id
1721 --,p_item_context_id => l_item_context_id
1722 --,p_concatenated_segments => l_concatenated_segments
1723 ,p_override_value_warning => l_override_value_warning);
1724 exception
1725 when hr_api.cannot_find_prog_unit then
1726 hr_api.cannot_find_prog_unit_error
1727 (p_module_name => 'update_template_item_context'
1728 ,p_hook_type => 'AP'
1729 );
1730 end;
1731 --
1732 -- When in validation only mode raise the Validate_Enabled exception
1733 --
1734 hr_utility.set_location('At:'|| l_proc, 55);
1735
1736 if p_validate then
1737 raise hr_api.validate_enabled;
1738 end if;
1739 --
1740 -- Set all output arguments
1741 --
1742 --p_item_context_id := l_item_context_id;
1743 --p_concatenated_segments := l_concatenated_segments;
1744 p_override_value_warning := l_override_value_warning;
1745 p_object_version_number := l_object_version_number;
1746 --
1747 hr_utility.set_location(' Leaving:'||l_proc, 70);
1748 exception
1749 when hr_api.validate_enabled then
1750 --
1751 -- As the Validate_Enabled exception has been raised
1752 -- we must rollback to the savepoint
1753 --
1754 rollback to update_template_item_context;
1755 --
1756 -- Only set output warning arguments
1757 -- (Any key or derived arguments must be set to null
1758 -- when validation only mode is being used.)
1759 --
1760 --p_item_context_id := null;
1761 --p_concatenated_segments := null;
1762 p_override_value_warning := l_override_value_warning;
1763 hr_utility.set_location(' Leaving:'||l_proc, 80);
1764 when others then
1765 --
1766 -- A validation or unexpected error has occured
1767 --
1768 p_override_value_warning := null ;
1769
1770 rollback to update_template_item_context;
1771 hr_utility.set_location(' Leaving:'||l_proc, 90);
1772 raise;
1773 end update_template_item_context;
1774 --
1775 end hr_template_item_contexts_api;