[Home] [Help]
PACKAGE BODY: APPS.HR_ITP_INS
Source
1 Package Body hr_itp_ins as
2 /* $Header: hritprhi.pkb 120.1 2011/04/28 11:51:30 sidsaxen ship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- | Private Global Definitions |
6 -- ----------------------------------------------------------------------------
7 --
8 g_package varchar2(33) := ' hr_itp_ins.'; -- Global package name
9 --
10 -- ----------------------------------------------------------------------------
11 -- |------------------------------< insert_dml >------------------------------|
12 -- ----------------------------------------------------------------------------
13 -- {Start Of Comments}
14 --
15 -- Description:
16 -- This procedure controls the actual dml insert logic. The processing of
17 -- this procedure are as follows:
18 -- 1) Initialise the object_version_number to 1 if the object_version_number
19 -- is defined as an attribute for this entity.
20 -- 2) To set and unset the g_api_dml status as required (as we are about to
21 -- perform dml).
22 -- 3) To insert the row into the schema.
23 -- 4) To trap any constraint violations that may have occurred.
24 -- 5) To raise any other errors.
25 --
26 -- Prerequisites:
27 -- This is an internal private procedure which must be called from the ins
28 -- procedure and must have all mandatory attributes set (except the
29 -- object_version_number which is initialised within this procedure).
30 --
31 -- In Parameters:
32 -- A Pl/Sql record structre.
33 --
34 -- Post Success:
35 -- The specified row will be inserted into the schema.
36 --
37 -- Post Failure:
38 -- On the insert dml failure it is important to note that we always reset the
39 -- g_api_dml status to false.
40 -- If a check, unique or parent integrity constraint violation is raised the
41 -- constraint_error procedure will be called.
42 -- If any other error is reported, the error will be raised after the
43 -- g_api_dml status is reset.
44 --
45 -- Developer Implementation Notes:
46 -- None.
47 --
48 -- Access Status:
49 -- Internal Row Handler Use Only.
50 --
51 -- {End Of Comments}
52 -- ----------------------------------------------------------------------------
53 Procedure insert_dml
54 (p_rec in out nocopy hr_itp_shd.g_rec_type
55 ) is
56 --
57 l_proc varchar2(72) := g_package||'insert_dml';
58 --
59 Begin
60 hr_utility.set_location('Entering:'||l_proc, 5);
61 hr_utility.set_location('Entering:'||to_char(p_rec.previous_navigation_item_id), 5);
62 hr_utility.set_location('Entering:'||to_char(p_rec.next_navigation_item_id), 5);
63 p_rec.object_version_number := 1; -- Initialise the object version
64 --
65 --
66 --
67 -- Added the following code as a part of Zero Downtime Patching Project.
68 -- Code Starts Here.
69 --
70 --
71 PER_RIC_PKG.chk_integrity (
72 p_entity_name=>'HR_ITEM_PROPERTIES_B',
73 p_ref_entity_info=>
74 PER_RIC_PKG.ref_entity_tbl(
75 PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
76 PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.form_item_id,NULL))),
77 PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
78 PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.validation_parameter_item_id1,NULL))),
79 PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
80 PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.validation_parameter_item_id2,NULL))),
81 PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
82 PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.validation_parameter_item_id3,NULL))),
83 PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
84 PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.validation_parameter_item_id4,NULL))),
85 PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
86 PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.validation_parameter_item_id5,NULL))),
87 PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
88 PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.information_parameter_item_id1,NULL))),
89 PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
90 PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.information_parameter_item_id2,NULL))),
91 PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
92 PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.information_parameter_item_id3,NULL))),
93 PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
94 PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.information_parameter_item_id4,NULL))),
95 PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
96 PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.information_parameter_item_id5,NULL))),
97 PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
98 PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.next_navigation_item_id ,NULL))),
99 PER_RIC_PKG.ref_info_rec('HR_FORM_ITEMS_B',PER_RIC_PKG.column_info_tbl(
100 PER_RIC_PKG.col_info_rec('FORM_ITEM_ID', NULL,p_rec.previous_navigation_item_id,NULL))),
101 PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEMS_B', PER_RIC_PKG.column_info_tbl(
102 PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_ID',NULL,p_rec.template_item_id,NULL))),
103 PER_RIC_PKG.ref_info_rec('HR_TEMPLATE_ITEM_CONTEXTS_B',PER_RIC_PKG.column_info_tbl(
104 PER_RIC_PKG.col_info_rec('TEMPLATE_ITEM_CONTEXT_ID',NULL,p_rec.template_item_context_id ,NULL)))),
105 p_ref_type=>'INS');
106 --
107 -- Code Ends Here
108 --
109 --
110 -- Insert the row into: hr_item_properties_b
111 --
112 insert into hr_item_properties_b
113 (item_property_id
114 ,object_version_number
115 ,form_item_id
116 ,template_item_id
117 ,template_item_context_id
118 ,alignment
119 ,bevel
120 ,case_restriction
121 ,enabled
122 ,format_mask
123 ,height
124 ,information_formula_id
125 ,information_parameter_item_id1
126 ,information_parameter_item_id2
127 ,information_parameter_item_id3
128 ,information_parameter_item_id4
129 ,information_parameter_item_id5
130 ,insert_allowed
131 ,prompt_alignment_offset
132 ,prompt_display_style
133 ,prompt_edge
134 ,prompt_edge_alignment
135 ,prompt_edge_offset
136 ,prompt_text_alignment
137 ,query_allowed
138 ,required
139 ,update_allowed
140 ,validation_formula_id
141 ,validation_parameter_item_id1
142 ,validation_parameter_item_id2
143 ,validation_parameter_item_id3
144 ,validation_parameter_item_id4
145 ,validation_parameter_item_id5
146 ,visible
147 ,width
148 ,x_position
149 ,y_position
150 ,information_category
151 ,information1
152 ,information2
153 ,information3
154 ,information4
155 ,information5
156 ,information6
157 ,information7
158 ,information8
159 ,information9
160 ,information10
161 ,information11
162 ,information12
163 ,information13
164 ,information14
165 ,information15
166 ,information16
167 ,information17
168 ,information18
169 ,information19
170 ,information20
171 ,information21
172 ,information22
173 ,information23
174 ,information24
175 ,information25
176 ,information26
177 ,information27
178 ,information28
179 ,information29
180 ,information30
181 ,next_navigation_item_id
182 ,previous_navigation_item_id
183 )
184 Values
185 (p_rec.item_property_id
186 ,p_rec.object_version_number
187 ,p_rec.form_item_id
188 ,p_rec.template_item_id
189 ,p_rec.template_item_context_id
190 ,p_rec.alignment
191 ,p_rec.bevel
192 ,p_rec.case_restriction
193 ,p_rec.enabled
194 ,p_rec.format_mask
195 ,p_rec.height
196 ,p_rec.information_formula_id
197 ,p_rec.information_parameter_item_id1
198 ,p_rec.information_parameter_item_id2
199 ,p_rec.information_parameter_item_id3
200 ,p_rec.information_parameter_item_id4
201 ,p_rec.information_parameter_item_id5
202 ,p_rec.insert_allowed
203 ,p_rec.prompt_alignment_offset
204 ,p_rec.prompt_display_style
205 ,p_rec.prompt_edge
206 ,p_rec.prompt_edge_alignment
207 ,p_rec.prompt_edge_offset
208 ,p_rec.prompt_text_alignment
209 ,p_rec.query_allowed
210 ,p_rec.required
211 ,p_rec.update_allowed
212 ,p_rec.validation_formula_id
213 ,p_rec.validation_parameter_item_id1
214 ,p_rec.validation_parameter_item_id2
215 ,p_rec.validation_parameter_item_id3
216 ,p_rec.validation_parameter_item_id4
217 ,p_rec.validation_parameter_item_id5
218 ,p_rec.visible
219 ,p_rec.width
220 ,p_rec.x_position
221 ,p_rec.y_position
222 ,p_rec.information_category
223 ,p_rec.information1
224 ,p_rec.information2
225 ,p_rec.information3
226 ,p_rec.information4
227 ,p_rec.information5
228 ,p_rec.information6
229 ,p_rec.information7
230 ,p_rec.information8
231 ,p_rec.information9
232 ,p_rec.information10
233 ,p_rec.information11
234 ,p_rec.information12
235 ,p_rec.information13
236 ,p_rec.information14
237 ,p_rec.information15
238 ,p_rec.information16
239 ,p_rec.information17
240 ,p_rec.information18
241 ,p_rec.information19
242 ,p_rec.information20
243 ,p_rec.information21
244 ,p_rec.information22
245 ,p_rec.information23
246 ,p_rec.information24
247 ,p_rec.information25
248 ,p_rec.information26
249 ,p_rec.information27
250 ,p_rec.information28
251 ,p_rec.information29
252 ,p_rec.information30
253 ,p_rec.next_navigation_item_id
254 ,p_rec.previous_navigation_item_id
255 );
256 --
257 --
258 --
259 hr_utility.set_location(' Leaving:'||l_proc, 10);
260 Exception
261 When hr_api.check_integrity_violated Then
262 -- A check constraint has been violated
263 --
264 hr_itp_shd.constraint_error
265 (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
266 When hr_api.parent_integrity_violated Then
267 -- Parent integrity has been violated
268 --
269 hr_itp_shd.constraint_error
270 (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
271 When hr_api.unique_integrity_violated Then
272 -- Unique integrity has been violated
273 --
274 hr_itp_shd.constraint_error
275 (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
276 When Others Then
277 --
278 Raise;
279 End insert_dml;
280 --
281 -- ----------------------------------------------------------------------------
282 -- |------------------------------< pre_insert >------------------------------|
283 -- ----------------------------------------------------------------------------
284 -- {Start Of Comments}
285 --
286 -- Description:
287 -- This private procedure contains any processing which is required before
288 -- the insert dml. Presently, if the entity has a corresponding primary
289 -- key which is maintained by an associating sequence, the primary key for
290 -- the entity will be populated with the next sequence value in
291 -- preparation for the insert dml.
292 --
293 -- Prerequisites:
294 -- This is an internal procedure which is called from the ins procedure.
295 --
296 -- In Parameters:
297 -- A Pl/Sql record structre.
298 --
299 -- Post Success:
300 -- Processing continues.
301 --
302 -- Post Failure:
303 -- If an error has occurred, an error message and exception will be raised
304 -- but not handled.
305 --
306 -- Developer Implementation Notes:
307 -- Any pre-processing required before the insert dml is issued should be
308 -- coded within this procedure. As stated above, a good example is the
309 -- generation of a primary key number via a corresponding sequence.
310 -- It is important to note that any 3rd party maintenance should be reviewed
311 -- before placing in this procedure.
312 --
313 -- Access Status:
314 -- Internal Row Handler Use Only.
315 --
316 -- {End Of Comments}
317 -- ----------------------------------------------------------------------------
318 Procedure pre_insert
319 (p_rec in out nocopy hr_itp_shd.g_rec_type
320 ) is
321 --
322 l_proc varchar2(72) := g_package||'pre_insert';
323 --
324 Cursor C_Sel1 is select hr_item_properties_b_s.nextval from sys.dual;
325 --
326 Begin
327 hr_utility.set_location('Entering:'||l_proc, 5);
328 --
329 --
330 -- Select the next sequence number
331 --
332 Open C_Sel1;
333 Fetch C_Sel1 Into p_rec.item_property_id;
334 Close C_Sel1;
335 --
336 hr_utility.set_location(' Leaving:'||l_proc, 10);
337 End pre_insert;
338 --
339 -- ----------------------------------------------------------------------------
340 -- |-----------------------------< post_insert >------------------------------|
341 -- ----------------------------------------------------------------------------
342 -- {Start Of Comments}
343 --
344 -- Description:
345 -- This private procedure contains any processing which is required after the
346 -- insert dml.
347 --
348 -- Prerequisites:
349 -- This is an internal procedure which is called from the ins procedure.
350 --
351 -- In Parameters:
352 -- A Pl/Sql record structre.
353 --
354 -- Post Success:
355 -- Processing continues.
356 --
357 -- Post Failure:
358 -- If an error has occurred, an error message and exception will be raised
359 -- but not handled.
360 --
361 -- Developer Implementation Notes:
362 -- Any post-processing required after the insert dml is issued should be
363 -- coded within this procedure. It is important to note that any 3rd party
364 -- maintenance should be reviewed before placing in this procedure.
365 --
366 -- Access Status:
367 -- Internal Row Handler Use Only.
368 --
369 -- {End Of Comments}
370 -- ----------------------------------------------------------------------------
371 Procedure post_insert
372 (p_effective_date in date
373 ,p_rec in hr_itp_shd.g_rec_type
374 ) is
375 --
376 l_proc varchar2(72) := g_package||'post_insert';
377 --
378 Begin
379 hr_utility.set_location('Entering:'||l_proc, 5);
380 begin
381 --
382 hr_itp_rki.after_insert
383 (p_effective_date => p_effective_date
384 ,p_object_version_number
385 => p_rec.object_version_number
386 ,p_item_property_id
387 => p_rec.item_property_id
388 ,p_form_item_id
389 => p_rec.form_item_id
390 ,p_template_item_id
391 => p_rec.template_item_id
392 ,p_template_item_context_id
393 => p_rec.template_item_context_id
394 ,p_alignment
395 => p_rec.alignment
396 ,p_bevel
397 => p_rec.bevel
398 ,p_case_restriction
399 => p_rec.case_restriction
400 ,p_enabled
401 => p_rec.enabled
402 ,p_format_mask
403 => p_rec.format_mask
404 ,p_height
405 => p_rec.height
406 ,p_information_formula_id
407 => p_rec.information_formula_id
408 ,p_information_param_item_id1
409 => p_rec.information_parameter_item_id1
410 ,p_information_param_item_id2
411 => p_rec.information_parameter_item_id2
412 ,p_information_param_item_id3
413 => p_rec.information_parameter_item_id3
414 ,p_information_param_item_id4
415 => p_rec.information_parameter_item_id4
416 ,p_information_param_item_id5
417 => p_rec.information_parameter_item_id5
418 ,p_insert_allowed
419 => p_rec.insert_allowed
420 ,p_prompt_alignment_offset
421 => p_rec.prompt_alignment_offset
422 ,p_prompt_display_style
423 => p_rec.prompt_display_style
424 ,p_prompt_edge
425 => p_rec.prompt_edge
426 ,p_prompt_edge_alignment
427 => p_rec.prompt_edge_alignment
428 ,p_prompt_edge_offset
429 => p_rec.prompt_edge_offset
430 ,p_prompt_text_alignment
431 => p_rec.prompt_text_alignment
432 ,p_query_allowed
433 => p_rec.query_allowed
434 ,p_required
435 => p_rec.required
436 ,p_update_allowed
437 => p_rec.update_allowed
438 ,p_validation_formula_id
439 => p_rec.validation_formula_id
440 ,p_validation_param_item_id1
441 => p_rec.validation_parameter_item_id1
442 ,p_validation_param_item_id2
443 => p_rec.validation_parameter_item_id2
444 ,p_validation_param_item_id3
445 => p_rec.validation_parameter_item_id3
446 ,p_validation_param_item_id4
447 => p_rec.validation_parameter_item_id4
448 ,p_validation_param_item_id5
449 => p_rec.validation_parameter_item_id5
450 ,p_visible
451 => p_rec.visible
452 ,p_width
453 => p_rec.width
454 ,p_x_position
455 => p_rec.x_position
456 ,p_y_position
457 => p_rec.y_position
458 ,p_information_category
459 => p_rec.information_category
460 ,p_information1
461 => p_rec.information1
462 ,p_information2
463 => p_rec.information2
464 ,p_information3
465 => p_rec.information3
466 ,p_information4
467 => p_rec.information4
468 ,p_information5
469 => p_rec.information5
470 ,p_information6
471 => p_rec.information6
472 ,p_information7
473 => p_rec.information7
474 ,p_information8
475 => p_rec.information8
476 ,p_information9
477 => p_rec.information9
478 ,p_information10
479 => p_rec.information10
480 ,p_information11
481 => p_rec.information11
482 ,p_information12
483 => p_rec.information12
484 ,p_information13
485 => p_rec.information13
486 ,p_information14
487 => p_rec.information14
488 ,p_information15
489 => p_rec.information15
490 ,p_information16
491 => p_rec.information16
492 ,p_information17
493 => p_rec.information17
494 ,p_information18
495 => p_rec.information18
496 ,p_information19
497 => p_rec.information19
498 ,p_information20
499 => p_rec.information20
500 ,p_information21
501 => p_rec.information21
502 ,p_information22
503 => p_rec.information22
504 ,p_information23
505 => p_rec.information23
506 ,p_information24
507 => p_rec.information24
508 ,p_information25
509 => p_rec.information25
510 ,p_information26
511 => p_rec.information26
512 ,p_information27
513 => p_rec.information27
514 ,p_information28
515 => p_rec.information28
516 ,p_information29
517 => p_rec.information29
518 ,p_information30
519 => p_rec.information30
520 ,p_next_navigation_item_id
521 => p_rec.next_navigation_item_id
522 ,p_previous_navigation_item_id
523 => p_rec.previous_navigation_item_id
524 );
525 --
526 exception
527 --
528 when hr_api.cannot_find_prog_unit then
529 --
530 hr_api.cannot_find_prog_unit_error
531 (p_module_name => 'HR_ITEM_PROPERTIES_B'
532 ,p_hook_type => 'AI');
533 --
534 end;
535 --
536 hr_utility.set_location(' Leaving:'||l_proc, 10);
537 End post_insert;
538 --
539 -- ----------------------------------------------------------------------------
540 -- |---------------------------------< ins >----------------------------------|
541 -- ----------------------------------------------------------------------------
542 Procedure ins
543 (p_effective_date in date
544 ,p_rec in out nocopy hr_itp_shd.g_rec_type
545 ) is
546 --
547 l_proc varchar2(72) := g_package||'ins';
548 --
549 Begin
550 hr_utility.set_location('Entering:'||l_proc, 5);
551 --
552 -- Call the supporting insert validate operations
553 --
554 hr_itp_bus.insert_validate
555 (p_effective_date
556 ,p_rec
557 );
558 --
559 -- Call the supporting pre-insert operation
560 --
561 hr_itp_ins.pre_insert(p_rec);
562 --
563 -- Insert the row
564 --
565 hr_itp_ins.insert_dml(p_rec);
566 --
567 -- Call the supporting post-insert operation
568 --
569 hr_itp_ins.post_insert
570 (p_effective_date
571 ,p_rec
572 );
573 --
574 hr_utility.set_location('Leaving:'||l_proc, 20);
575 end ins;
576 --
577 -- ----------------------------------------------------------------------------
578 -- |---------------------------------< ins >----------------------------------|
579 -- ----------------------------------------------------------------------------
580 Procedure ins
581 (p_effective_date in date
582 ,p_form_item_id in number default null
583 ,p_template_item_id in number default null
584 ,p_template_item_context_id in number default null
585 ,p_alignment in number default null
586 ,p_bevel in number default null
587 ,p_case_restriction in number default null
588 ,p_enabled in number default null
589 ,p_format_mask in varchar2 default null
590 ,p_height in number default null
591 ,p_information_formula_id in number default null
592 ,p_information_param_item_id1 in number default null
593 ,p_information_param_item_id2 in number default null
594 ,p_information_param_item_id3 in number default null
595 ,p_information_param_item_id4 in number default null
596 ,p_information_param_item_id5 in number default null
597 ,p_insert_allowed in number default null
598 ,p_prompt_alignment_offset in number default null
599 ,p_prompt_display_style in number default null
600 ,p_prompt_edge in number default null
601 ,p_prompt_edge_alignment in number default null
602 ,p_prompt_edge_offset in number default null
603 ,p_prompt_text_alignment in number default null
604 ,p_query_allowed in number default null
605 ,p_required in number default null
606 ,p_update_allowed in number default null
607 ,p_validation_formula_id in number default null
608 ,p_validation_param_item_id1 in number default null
609 ,p_validation_param_item_id2 in number default null
610 ,p_validation_param_item_id3 in number default null
611 ,p_validation_param_item_id4 in number default null
612 ,p_validation_param_item_id5 in number default null
613 ,p_visible in number default null
614 ,p_width in number default null
615 ,p_x_position in number default null
616 ,p_y_position in number default null
617 ,p_information_category in varchar2 default null
618 ,p_information1 in varchar2 default null
619 ,p_information2 in varchar2 default null
620 ,p_information3 in varchar2 default null
621 ,p_information4 in varchar2 default null
622 ,p_information5 in varchar2 default null
623 ,p_information6 in varchar2 default null
624 ,p_information7 in varchar2 default null
625 ,p_information8 in varchar2 default null
626 ,p_information9 in varchar2 default null
627 ,p_information10 in varchar2 default null
628 ,p_information11 in varchar2 default null
629 ,p_information12 in varchar2 default null
630 ,p_information13 in varchar2 default null
631 ,p_information14 in varchar2 default null
632 ,p_information15 in varchar2 default null
633 ,p_information16 in varchar2 default null
634 ,p_information17 in varchar2 default null
635 ,p_information18 in varchar2 default null
636 ,p_information19 in varchar2 default null
637 ,p_information20 in varchar2 default null
638 ,p_information21 in varchar2 default null
639 ,p_information22 in varchar2 default null
640 ,p_information23 in varchar2 default null
641 ,p_information24 in varchar2 default null
642 ,p_information25 in varchar2 default null
643 ,p_information26 in varchar2 default null
644 ,p_information27 in varchar2 default null
645 ,p_information28 in varchar2 default null
646 ,p_information29 in varchar2 default null
647 ,p_information30 in varchar2 default null
648 ,p_next_navigation_item_id in number default null
649 ,p_previous_navigation_item_id in number default null
650 ,p_item_property_id out nocopy number
651 ,p_object_version_number out nocopy number
652 ) is
653 --
654 l_rec hr_itp_shd.g_rec_type;
655 l_proc varchar2(72) := g_package||'ins';
656 --
657 Begin
658 hr_utility.set_location('Entering:'||l_proc, 5);
659 --
660 -- Call conversion function to turn arguments into the
661 -- p_rec structure.
662 --
663 l_rec :=
664 hr_itp_shd.convert_args
665 (null
666 ,p_object_version_number
667 ,p_form_item_id
668 ,p_template_item_id
669 ,p_template_item_context_id
670 ,p_alignment
671 ,p_bevel
672 ,p_case_restriction
673 ,p_enabled
674 ,p_format_mask
675 ,p_height
676 ,p_information_formula_id
677 ,p_information_param_item_id1
678 ,p_information_param_item_id2
679 ,p_information_param_item_id3
680 ,p_information_param_item_id4
681 ,p_information_param_item_id5
682 ,p_insert_allowed
683 ,p_prompt_alignment_offset
684 ,p_prompt_display_style
685 ,p_prompt_edge
686 ,p_prompt_edge_alignment
687 ,p_prompt_edge_offset
688 ,p_prompt_text_alignment
689 ,p_query_allowed
690 ,p_required
691 ,p_update_allowed
692 ,p_validation_formula_id
693 ,p_validation_param_item_id1
694 ,p_validation_param_item_id2
695 ,p_validation_param_item_id3
696 ,p_validation_param_item_id4
697 ,p_validation_param_item_id5
698 ,p_visible
699 ,p_width
700 ,p_x_position
701 ,p_y_position
702 ,p_information_category
703 ,p_information1
704 ,p_information2
705 ,p_information3
706 ,p_information4
707 ,p_information5
708 ,p_information6
709 ,p_information7
710 ,p_information8
711 ,p_information9
712 ,p_information10
713 ,p_information11
714 ,p_information12
715 ,p_information13
716 ,p_information14
717 ,p_information15
718 ,p_information16
719 ,p_information17
720 ,p_information18
721 ,p_information19
722 ,p_information20
723 ,p_information21
724 ,p_information22
725 ,p_information23
726 ,p_information24
727 ,p_information25
728 ,p_information26
729 ,p_information27
730 ,p_information28
731 ,p_information29
732 ,p_information30
733 ,p_next_navigation_item_id
734 ,p_previous_navigation_item_id
735 );
736 --
737 -- Having converted the arguments into the hr_itp_rec
738 -- plsql record structure we call the corresponding record business process.
739 --
740 hr_itp_ins.ins
741 (p_effective_date
742 ,l_rec
743 );
744 --
745 -- As the primary key argument(s)
746 -- are specified as an OUT's we must set these values.
747 --
748 p_item_property_id := l_rec.item_property_id;
749 p_object_version_number := l_rec.object_version_number;
750 --
751 hr_utility.set_location(' Leaving:'||l_proc, 10);
752 End ins;
753 --
754 end hr_itp_ins;