[Home] [Help]
PACKAGE BODY: APPS.IRC_IPC_INS
Source
1 Package Body irc_ipc_ins as
2 /* $Header: iripcrhi.pkb 120.0 2005/07/26 15:08:54 mbocutt noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- | Private Global Definitions |
6 -- ----------------------------------------------------------------------------
7 --
8 g_package varchar2(33) := ' irc_ipc_ins.'; -- Global package name
9 --
10 -- The following global variables are only to be used by
11 -- the set_base_key_value and pre_insert procedures.
12 --
13 g_posting_content_id_i number default null;
14 --
15 -- ----------------------------------------------------------------------------
16 -- |------------------------< set_base_key_value >----------------------------|
17 -- ----------------------------------------------------------------------------
18 procedure set_base_key_value
19 (p_posting_content_id in number) is
20 --
21 l_proc varchar2(72) := g_package||'set_base_key_value';
22 --
23 Begin
24 hr_utility.set_location('Entering:'||l_proc, 10);
25 --
26 irc_ipc_ins.g_posting_content_id_i := p_posting_content_id;
27 --
28 hr_utility.set_location(' Leaving:'||l_proc, 20);
29 End set_base_key_value;
30 --
31 --
32 -- ----------------------------------------------------------------------------
33 -- |------------------------------< insert_dml >------------------------------|
34 -- ----------------------------------------------------------------------------
35 -- {Start Of Comments}
36 --
37 -- Description:
38 -- This procedure controls the actual dml insert logic. The processing of
39 -- this procedure are as follows:
40 -- 1) Initialise the object_version_number to 1 if the object_version_number
41 -- is defined as an attribute for this entity.
42 -- 2) To set and unset the g_api_dml status as required (as we are about to
43 -- perform dml).
44 -- 3) To insert the row into the schema.
45 -- 4) To trap any constraint violations that may have occurred.
46 -- 5) To raise any other errors.
47 --
48 -- Prerequisites:
49 -- This is an internal private procedure which must be called from the ins
50 -- procedure and must have all mandatory attributes set (except the
51 -- object_version_number which is initialised within this procedure).
52 --
53 -- In Parameters:
54 -- A Pl/Sql record structre.
55 --
56 -- Post Success:
57 -- The specified row will be inserted into the schema.
58 --
59 -- Post Failure:
60 -- On the insert dml failure it is important to note that we always reset the
61 -- g_api_dml status to false.
62 -- If a check, unique or parent integrity constraint violation is raised the
63 -- constraint_error procedure will be called.
64 -- If any other error is reported, the error will be raised after the
65 -- g_api_dml status is reset.
66 --
67 -- Developer Implementation Notes:
68 -- None.
69 --
70 -- Access Status:
71 -- Internal Row Handler Use Only.
72 --
73 -- {End Of Comments}
74 -- ----------------------------------------------------------------------------
75 Procedure insert_dml
76 (p_rec in out nocopy irc_ipc_shd.g_rec_type
77 ) is
78 --
79 l_proc varchar2(72) := g_package||'insert_dml';
80 --
81 Begin
82 hr_utility.set_location('Entering:'||l_proc, 5);
83 p_rec.object_version_number := 1; -- Initialise the object version
84 --
85 irc_ipc_shd.g_api_dml := true; -- Set the api dml status
86 --
87 -- Insert the row into: irc_posting_contents
88 --
89 insert into irc_posting_contents
90 (posting_content_id
91 ,display_manager_info
92 ,display_recruiter_info
93 ,attribute_category
94 ,attribute1
95 ,attribute2
96 ,attribute3
97 ,attribute4
98 ,attribute5
99 ,attribute6
100 ,attribute7
101 ,attribute8
102 ,attribute9
103 ,attribute10
104 ,attribute11
105 ,attribute12
106 ,attribute13
107 ,attribute14
108 ,attribute15
109 ,attribute16
110 ,attribute17
111 ,attribute18
112 ,attribute19
113 ,attribute20
114 ,attribute21
115 ,attribute22
116 ,attribute23
117 ,attribute24
118 ,attribute25
119 ,attribute26
120 ,attribute27
121 ,attribute28
122 ,attribute29
123 ,attribute30
124 ,ipc_information_category
125 ,ipc_information1
126 ,ipc_information2
127 ,ipc_information3
128 ,ipc_information4
129 ,ipc_information5
130 ,ipc_information6
131 ,ipc_information7
132 ,ipc_information8
133 ,ipc_information9
134 ,ipc_information10
135 ,ipc_information11
136 ,ipc_information12
137 ,ipc_information13
138 ,ipc_information14
139 ,ipc_information15
140 ,ipc_information16
141 ,ipc_information17
142 ,ipc_information18
143 ,ipc_information19
144 ,ipc_information20
145 ,ipc_information21
146 ,ipc_information22
147 ,ipc_information23
148 ,ipc_information24
149 ,ipc_information25
150 ,ipc_information26
151 ,ipc_information27
152 ,ipc_information28
153 ,ipc_information29
154 ,ipc_information30
155 ,object_version_number
156 ,date_approved
157 ,recruiter_full_name
158 ,recruiter_email
159 ,recruiter_work_telephone
160 ,manager_full_name
161 ,manager_email
162 ,manager_work_telephone
163 )
164 Values
165 (p_rec.posting_content_id
166 ,p_rec.display_manager_info
167 ,p_rec.display_recruiter_info
168 ,p_rec.attribute_category
169 ,p_rec.attribute1
170 ,p_rec.attribute2
171 ,p_rec.attribute3
172 ,p_rec.attribute4
173 ,p_rec.attribute5
174 ,p_rec.attribute6
175 ,p_rec.attribute7
176 ,p_rec.attribute8
177 ,p_rec.attribute9
178 ,p_rec.attribute10
179 ,p_rec.attribute11
180 ,p_rec.attribute12
181 ,p_rec.attribute13
182 ,p_rec.attribute14
183 ,p_rec.attribute15
184 ,p_rec.attribute16
185 ,p_rec.attribute17
186 ,p_rec.attribute18
187 ,p_rec.attribute19
188 ,p_rec.attribute20
189 ,p_rec.attribute21
190 ,p_rec.attribute22
191 ,p_rec.attribute23
192 ,p_rec.attribute24
193 ,p_rec.attribute25
194 ,p_rec.attribute26
195 ,p_rec.attribute27
196 ,p_rec.attribute28
197 ,p_rec.attribute29
198 ,p_rec.attribute30
199 ,p_rec.ipc_information_category
200 ,p_rec.ipc_information1
201 ,p_rec.ipc_information2
202 ,p_rec.ipc_information3
203 ,p_rec.ipc_information4
204 ,p_rec.ipc_information5
205 ,p_rec.ipc_information6
206 ,p_rec.ipc_information7
207 ,p_rec.ipc_information8
208 ,p_rec.ipc_information9
209 ,p_rec.ipc_information10
210 ,p_rec.ipc_information11
211 ,p_rec.ipc_information12
212 ,p_rec.ipc_information13
213 ,p_rec.ipc_information14
214 ,p_rec.ipc_information15
215 ,p_rec.ipc_information16
216 ,p_rec.ipc_information17
217 ,p_rec.ipc_information18
218 ,p_rec.ipc_information19
219 ,p_rec.ipc_information20
220 ,p_rec.ipc_information21
221 ,p_rec.ipc_information22
222 ,p_rec.ipc_information23
223 ,p_rec.ipc_information24
224 ,p_rec.ipc_information25
225 ,p_rec.ipc_information26
226 ,p_rec.ipc_information27
227 ,p_rec.ipc_information28
228 ,p_rec.ipc_information29
229 ,p_rec.ipc_information30
230 ,p_rec.object_version_number
231 ,p_rec.date_approved
232 ,p_rec.recruiter_full_name
233 ,p_rec.recruiter_email
234 ,p_rec.recruiter_work_telephone
235 ,p_rec.manager_full_name
236 ,p_rec.manager_email
237 ,p_rec.manager_work_telephone
238 );
239 --
240 irc_ipc_shd.g_api_dml := false; -- Unset the api dml status
241 --
242 hr_utility.set_location(' Leaving:'||l_proc, 10);
243 Exception
244 When hr_api.check_integrity_violated Then
245 -- A check constraint has been violated
246 irc_ipc_shd.g_api_dml := false; -- Unset the api dml status
247 --
248 irc_ipc_shd.constraint_error
249 (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
250 When hr_api.parent_integrity_violated Then
251 -- Parent integrity has been violated
252 irc_ipc_shd.g_api_dml := false; -- Unset the api dml status
253 --
254 irc_ipc_shd.constraint_error
255 (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
256 When hr_api.unique_integrity_violated Then
257 -- Unique integrity has been violated
258 irc_ipc_shd.g_api_dml := false; -- Unset the api dml status
259 --
260 irc_ipc_shd.constraint_error
261 (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
262 When Others Then
263 irc_ipc_shd.g_api_dml := false; -- Unset the api dml status
264 --
265 Raise;
266 End insert_dml;
267 --
268 -- ----------------------------------------------------------------------------
269 -- |------------------------------< pre_insert >------------------------------|
270 -- ----------------------------------------------------------------------------
271 -- {Start Of Comments}
272 --
273 -- Description:
274 -- This private procedure contains any processing which is required before
275 -- the insert dml. Presently, if the entity has a corresponding primary
276 -- key which is maintained by an associating sequence, the primary key for
277 -- the entity will be populated with the next sequence value in
278 -- preparation for the insert dml.
279 --
280 -- Prerequisites:
281 -- This is an internal procedure which is called from the ins procedure.
282 --
283 -- In Parameters:
284 -- A Pl/Sql record structure.
285 --
286 -- Post Success:
287 -- Processing continues.
288 --
289 -- Post Failure:
290 -- If an error has occurred, an error message and exception will be raised
291 -- but not handled.
292 --
293 -- Developer Implementation Notes:
294 -- Any pre-processing required before the insert dml is issued should be
295 -- coded within this procedure. As stated above, a good example is the
296 -- generation of a primary key number via a corresponding sequence.
297 -- It is important to note that any 3rd party maintenance should be reviewed
298 -- before placing in this procedure.
299 --
300 -- Access Status:
301 -- Internal Row Handler Use Only.
302 --
303 -- {End Of Comments}
304 -- ----------------------------------------------------------------------------
305 Procedure pre_insert
306 (p_rec in out nocopy irc_ipc_shd.g_rec_type
307 ) is
308 --
309 Cursor C_Sel1 is select irc_posting_contents_s.nextval from sys.dual;
310 --
311 Cursor C_Sel2 is
312 Select null
313 from irc_posting_contents
314 where posting_content_id =
315 irc_ipc_ins.g_posting_content_id_i;
316 --
317 l_proc varchar2(72) := g_package||'pre_insert';
318 l_exists varchar2(1);
319 --
320 Begin
321 hr_utility.set_location('Entering:'||l_proc, 5);
322 --
323 If (irc_ipc_ins.g_posting_content_id_i is not null) Then
324 --
325 -- Verify registered primary key values not already in use
326 --
327 Open C_Sel2;
328 Fetch C_Sel2 into l_exists;
329 If C_Sel2%found Then
330 Close C_Sel2;
331 --
332 -- The primary key values are already in use.
333 --
334 fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
335 fnd_message.set_token('TABLE_NAME','irc_posting_contents');
336 fnd_message.raise_error;
337 End If;
338 Close C_Sel2;
339 --
340 -- Use registered key values and clear globals
341 --
342 p_rec.posting_content_id :=
343 irc_ipc_ins.g_posting_content_id_i;
344 irc_ipc_ins.g_posting_content_id_i := null;
345 Else
346 --
347 -- No registerd key values, so select the next sequence number
348 --
349 --
350 -- Select the next sequence number
351 --
352 Open C_Sel1;
353 Fetch C_Sel1 Into p_rec.posting_content_id;
354 Close C_Sel1;
355 End If;
356 --
357 hr_utility.set_location(' Leaving:'||l_proc, 10);
358 End pre_insert;
359 --
360 -- ----------------------------------------------------------------------------
361 -- |-----------------------------< post_insert >------------------------------|
362 -- ----------------------------------------------------------------------------
363 -- {Start Of Comments}
364 --
365 -- Description:
366 -- This private procedure contains any processing which is required after
367 -- the insert dml.
368 --
369 -- Prerequisites:
370 -- This is an internal procedure which is called from the ins procedure.
371 --
372 -- In Parameters:
373 -- A Pl/Sql record structre.
374 --
375 -- Post Success:
376 -- Processing continues.
377 --
378 -- Post Failure:
379 -- If an error has occurred, an error message and exception will be raised
380 -- but not handled.
381 --
382 -- Developer Implementation Notes:
383 -- Any post-processing required after the insert dml is issued should be
384 -- coded within this procedure. It is important to note that any 3rd party
385 -- maintenance should be reviewed before placing in this procedure.
386 --
387 -- Access Status:
388 -- Internal Row Handler Use Only.
389 --
390 -- {End Of Comments}
391 -- ----------------------------------------------------------------------------
392 Procedure post_insert
393 (p_rec in irc_ipc_shd.g_rec_type
394 ) is
395 --
396 l_proc varchar2(72) := g_package||'post_insert';
397 --
398 Begin
399 hr_utility.set_location('Entering:'||l_proc, 5);
400 begin
401 --
402 irc_ipc_rki.after_insert
403 (p_posting_content_id
404 => p_rec.posting_content_id
405 ,p_display_manager_info
406 => p_rec.display_manager_info
407 ,p_display_recruiter_info
408 => p_rec.display_recruiter_info
409 ,p_attribute_category
410 => p_rec.attribute_category
411 ,p_attribute1
412 => p_rec.attribute1
413 ,p_attribute2
414 => p_rec.attribute2
415 ,p_attribute3
416 => p_rec.attribute3
417 ,p_attribute4
418 => p_rec.attribute4
419 ,p_attribute5
420 => p_rec.attribute5
421 ,p_attribute6
422 => p_rec.attribute6
423 ,p_attribute7
424 => p_rec.attribute7
425 ,p_attribute8
426 => p_rec.attribute8
427 ,p_attribute9
428 => p_rec.attribute9
429 ,p_attribute10
430 => p_rec.attribute10
431 ,p_attribute11
432 => p_rec.attribute11
433 ,p_attribute12
434 => p_rec.attribute12
435 ,p_attribute13
436 => p_rec.attribute13
437 ,p_attribute14
438 => p_rec.attribute14
439 ,p_attribute15
440 => p_rec.attribute15
441 ,p_attribute16
442 => p_rec.attribute16
443 ,p_attribute17
444 => p_rec.attribute17
445 ,p_attribute18
446 => p_rec.attribute18
447 ,p_attribute19
448 => p_rec.attribute19
449 ,p_attribute20
450 => p_rec.attribute20
451 ,p_attribute21
452 => p_rec.attribute21
453 ,p_attribute22
454 => p_rec.attribute22
455 ,p_attribute23
456 => p_rec.attribute23
457 ,p_attribute24
458 => p_rec.attribute24
459 ,p_attribute25
460 => p_rec.attribute25
461 ,p_attribute26
462 => p_rec.attribute26
463 ,p_attribute27
464 => p_rec.attribute27
465 ,p_attribute28
466 => p_rec.attribute28
467 ,p_attribute29
468 => p_rec.attribute29
469 ,p_attribute30
470 => p_rec.attribute30
471 ,p_ipc_information_category
472 => p_rec.ipc_information_category
473 ,p_ipc_information1
474 => p_rec.ipc_information1
475 ,p_ipc_information2
476 => p_rec.ipc_information2
477 ,p_ipc_information3
478 => p_rec.ipc_information3
479 ,p_ipc_information4
480 => p_rec.ipc_information4
481 ,p_ipc_information5
482 => p_rec.ipc_information5
483 ,p_ipc_information6
484 => p_rec.ipc_information6
485 ,p_ipc_information7
486 => p_rec.ipc_information7
487 ,p_ipc_information8
488 => p_rec.ipc_information8
489 ,p_ipc_information9
490 => p_rec.ipc_information9
491 ,p_ipc_information10
492 => p_rec.ipc_information10
493 ,p_ipc_information11
494 => p_rec.ipc_information11
495 ,p_ipc_information12
496 => p_rec.ipc_information12
497 ,p_ipc_information13
498 => p_rec.ipc_information13
499 ,p_ipc_information14
500 => p_rec.ipc_information14
501 ,p_ipc_information15
502 => p_rec.ipc_information15
503 ,p_ipc_information16
504 => p_rec.ipc_information16
505 ,p_ipc_information17
506 => p_rec.ipc_information17
507 ,p_ipc_information18
508 => p_rec.ipc_information18
509 ,p_ipc_information19
510 => p_rec.ipc_information19
511 ,p_ipc_information20
512 => p_rec.ipc_information20
513 ,p_ipc_information21
514 => p_rec.ipc_information21
515 ,p_ipc_information22
516 => p_rec.ipc_information22
517 ,p_ipc_information23
518 => p_rec.ipc_information23
519 ,p_ipc_information24
520 => p_rec.ipc_information24
521 ,p_ipc_information25
522 => p_rec.ipc_information25
523 ,p_ipc_information26
524 => p_rec.ipc_information26
525 ,p_ipc_information27
526 => p_rec.ipc_information27
527 ,p_ipc_information28
528 => p_rec.ipc_information28
529 ,p_ipc_information29
530 => p_rec.ipc_information29
531 ,p_ipc_information30
532 => p_rec.ipc_information30
533 ,p_object_version_number
534 => p_rec.object_version_number
535 ,p_date_approved
536 => p_rec.date_approved
537 ,p_recruiter_full_name
538 => p_rec.recruiter_full_name
539 ,p_recruiter_email
540 => p_rec.recruiter_email
541 ,p_recruiter_work_telephone
542 => p_rec.recruiter_work_telephone
543 ,p_manager_full_name
544 => p_rec.manager_full_name
545 ,p_manager_email
546 => p_rec.manager_email
547 ,p_manager_work_telephone
548 => p_rec.manager_work_telephone
549 );
550 --
551 exception
552 --
553 when hr_api.cannot_find_prog_unit then
554 --
555 hr_api.cannot_find_prog_unit_error
556 (p_module_name => 'IRC_POSTING_CONTENTS'
557 ,p_hook_type => 'AI');
558 --
559 end;
560 --
561 hr_utility.set_location(' Leaving:'||l_proc, 10);
562 End post_insert;
563 --
564 -- ----------------------------------------------------------------------------
565 -- |---------------------------------< ins >----------------------------------|
566 -- ----------------------------------------------------------------------------
567 Procedure ins
568 (p_rec in out nocopy irc_ipc_shd.g_rec_type
569 ) is
570 --
571 l_proc varchar2(72) := g_package||'ins';
572 --
573 Begin
574 hr_utility.set_location('Entering:'||l_proc, 5);
575 --
576 -- Call the supporting insert validate operations
577 --
578 irc_ipc_bus.insert_validate
579 (p_rec
580 );
581 --
582 -- Call the supporting pre-insert operation
583 --
584 irc_ipc_ins.pre_insert(p_rec);
585 --
586 -- Insert the row
587 --
588 irc_ipc_ins.insert_dml(p_rec);
589 --
590 -- Call the supporting post-insert operation
591 --
592 irc_ipc_ins.post_insert
593 (p_rec
594 );
595 --
596 hr_utility.set_location('Leaving:'||l_proc, 20);
597 end ins;
598 --
599 -- ----------------------------------------------------------------------------
600 -- |---------------------------------< ins >----------------------------------|
601 -- ----------------------------------------------------------------------------
602 Procedure ins
603 (p_display_manager_info in varchar2
604 ,p_display_recruiter_info in varchar2
605 ,p_attribute_category in varchar2 default null
606 ,p_attribute1 in varchar2 default null
607 ,p_attribute2 in varchar2 default null
608 ,p_attribute3 in varchar2 default null
609 ,p_attribute4 in varchar2 default null
610 ,p_attribute5 in varchar2 default null
611 ,p_attribute6 in varchar2 default null
612 ,p_attribute7 in varchar2 default null
613 ,p_attribute8 in varchar2 default null
614 ,p_attribute9 in varchar2 default null
615 ,p_attribute10 in varchar2 default null
616 ,p_attribute11 in varchar2 default null
617 ,p_attribute12 in varchar2 default null
618 ,p_attribute13 in varchar2 default null
619 ,p_attribute14 in varchar2 default null
620 ,p_attribute15 in varchar2 default null
621 ,p_attribute16 in varchar2 default null
622 ,p_attribute17 in varchar2 default null
623 ,p_attribute18 in varchar2 default null
624 ,p_attribute19 in varchar2 default null
625 ,p_attribute20 in varchar2 default null
626 ,p_attribute21 in varchar2 default null
627 ,p_attribute22 in varchar2 default null
628 ,p_attribute23 in varchar2 default null
629 ,p_attribute24 in varchar2 default null
630 ,p_attribute25 in varchar2 default null
631 ,p_attribute26 in varchar2 default null
632 ,p_attribute27 in varchar2 default null
633 ,p_attribute28 in varchar2 default null
634 ,p_attribute29 in varchar2 default null
635 ,p_attribute30 in varchar2 default null
636 ,p_ipc_information_category in varchar2 default null
637 ,p_ipc_information1 in varchar2 default null
638 ,p_ipc_information2 in varchar2 default null
639 ,p_ipc_information3 in varchar2 default null
640 ,p_ipc_information4 in varchar2 default null
641 ,p_ipc_information5 in varchar2 default null
642 ,p_ipc_information6 in varchar2 default null
643 ,p_ipc_information7 in varchar2 default null
644 ,p_ipc_information8 in varchar2 default null
645 ,p_ipc_information9 in varchar2 default null
646 ,p_ipc_information10 in varchar2 default null
647 ,p_ipc_information11 in varchar2 default null
648 ,p_ipc_information12 in varchar2 default null
649 ,p_ipc_information13 in varchar2 default null
650 ,p_ipc_information14 in varchar2 default null
651 ,p_ipc_information15 in varchar2 default null
652 ,p_ipc_information16 in varchar2 default null
653 ,p_ipc_information17 in varchar2 default null
654 ,p_ipc_information18 in varchar2 default null
655 ,p_ipc_information19 in varchar2 default null
656 ,p_ipc_information20 in varchar2 default null
657 ,p_ipc_information21 in varchar2 default null
658 ,p_ipc_information22 in varchar2 default null
659 ,p_ipc_information23 in varchar2 default null
660 ,p_ipc_information24 in varchar2 default null
661 ,p_ipc_information25 in varchar2 default null
662 ,p_ipc_information26 in varchar2 default null
663 ,p_ipc_information27 in varchar2 default null
664 ,p_ipc_information28 in varchar2 default null
665 ,p_ipc_information29 in varchar2 default null
666 ,p_ipc_information30 in varchar2 default null
667 ,p_date_approved in date default null
668 ,p_recruiter_full_name in varchar2 default null
669 ,p_recruiter_email in varchar2 default null
670 ,p_recruiter_work_telephone in varchar2 default null
671 ,p_manager_full_name in varchar2 default null
672 ,p_manager_email in varchar2 default null
673 ,p_manager_work_telephone in varchar2 default null
674 ,p_posting_content_id out nocopy number
675 ,p_object_version_number out nocopy number
676 ) is
677 --
678 l_rec irc_ipc_shd.g_rec_type;
679 l_proc varchar2(72) := g_package||'ins';
680 --
681 Begin
682 hr_utility.set_location('Entering:'||l_proc, 5);
683 --
684 -- Call conversion function to turn arguments into the
685 -- p_rec structure.
686 --
687 l_rec :=
688 irc_ipc_shd.convert_args
689 (null
690 ,p_display_manager_info
691 ,p_display_recruiter_info
692 ,p_attribute_category
693 ,p_attribute1
694 ,p_attribute2
695 ,p_attribute3
696 ,p_attribute4
697 ,p_attribute5
698 ,p_attribute6
699 ,p_attribute7
700 ,p_attribute8
701 ,p_attribute9
702 ,p_attribute10
703 ,p_attribute11
704 ,p_attribute12
705 ,p_attribute13
706 ,p_attribute14
707 ,p_attribute15
708 ,p_attribute16
709 ,p_attribute17
710 ,p_attribute18
711 ,p_attribute19
712 ,p_attribute20
713 ,p_attribute21
714 ,p_attribute22
715 ,p_attribute23
716 ,p_attribute24
717 ,p_attribute25
718 ,p_attribute26
719 ,p_attribute27
720 ,p_attribute28
721 ,p_attribute29
722 ,p_attribute30
723 ,p_ipc_information_category
724 ,p_ipc_information1
725 ,p_ipc_information2
726 ,p_ipc_information3
727 ,p_ipc_information4
728 ,p_ipc_information5
729 ,p_ipc_information6
730 ,p_ipc_information7
731 ,p_ipc_information8
732 ,p_ipc_information9
733 ,p_ipc_information10
734 ,p_ipc_information11
735 ,p_ipc_information12
736 ,p_ipc_information13
737 ,p_ipc_information14
738 ,p_ipc_information15
739 ,p_ipc_information16
740 ,p_ipc_information17
741 ,p_ipc_information18
742 ,p_ipc_information19
743 ,p_ipc_information20
744 ,p_ipc_information21
745 ,p_ipc_information22
746 ,p_ipc_information23
747 ,p_ipc_information24
748 ,p_ipc_information25
749 ,p_ipc_information26
750 ,p_ipc_information27
751 ,p_ipc_information28
752 ,p_ipc_information29
753 ,p_ipc_information30
754 ,null
755 ,p_date_approved
756 ,p_recruiter_full_name
757 ,p_recruiter_email
758 ,p_recruiter_work_telephone
759 ,p_manager_full_name
760 ,p_manager_email
761 ,p_manager_work_telephone
762 );
763 --
764 -- Having converted the arguments into the irc_ipc_rec
765 -- plsql record structure we call the corresponding record business process.
766 --
767 irc_ipc_ins.ins
768 (l_rec
769 );
770 --
771 -- As the primary key argument(s)
772 -- are specified as an OUT's we must set these values.
773 --
774 p_posting_content_id := l_rec.posting_content_id;
775 p_object_version_number := l_rec.object_version_number;
776 --
777 hr_utility.set_location(' Leaving:'||l_proc, 10);
778 End ins;
779 --
780 end irc_ipc_ins;