[Home] [Help]
PACKAGE BODY: APPS.PQH_CER_SHD
Source
1 Package Body pqh_cer_shd as
2 /* $Header: pqcerrhi.pkb 120.1 2011/11/17 12:10:50 sidsaxen ship $ */
3 --
4 g_package varchar2(33) := ' pqh_cer_shd.'; -- Global package name
5 -- ----------------------------------------------------------------------------
6 -- |---------------------------< constraint_error >---------------------------|
7 -- ----------------------------------------------------------------------------
8 Procedure constraint_error
9 (p_constraint_name in all_constraints.constraint_name%TYPE) Is
10 --
11 l_proc varchar2(72) := g_package||'constraint_error';
12 --
13 Begin
14 hr_utility.set_location('Entering:'||l_proc, 5);
15 --
16 If (p_constraint_name = 'PQH_COPY_ENTITY_RESULTS_FK1') Then
17 hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
18 hr_utility.set_message_token('PROCEDURE', l_proc);
19 hr_utility.set_message_token('STEP','5');
20 hr_utility.raise_error;
21 ElsIf (p_constraint_name = 'PQH_COPY_ENTITY_RESULTS_FK2') Then
22 hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
23 hr_utility.set_message_token('PROCEDURE', l_proc);
24 hr_utility.set_message_token('STEP','10');
25 hr_utility.raise_error;
26 ElsIf (p_constraint_name = 'PQH_COPY_ENTITY_RESULTS_PK') Then
27 hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
28 hr_utility.set_message_token('PROCEDURE', l_proc);
29 hr_utility.set_message_token('STEP','15');
30 hr_utility.raise_error;
31 Else
32 hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
33 hr_utility.set_message_token('PROCEDURE', l_proc);
34 hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
35 hr_utility.raise_error;
36 End If;
37 --
38 hr_utility.set_location(' Leaving:'||l_proc, 10);
39 End constraint_error;
40 --
41 -- ----------------------------------------------------------------------------
42 -- |-----------------------------< api_updating >-----------------------------|
43 -- ----------------------------------------------------------------------------
44 Function api_updating
45 (
46 p_copy_entity_result_id in number,
47 p_object_version_number in number
48 ) Return Boolean Is
49 --
50 --
51 -- Cursor selects the 'current' row from the HR Schema
52 --
53 Cursor C_Sel1 is
54 select
55 copy_entity_result_id,
56 copy_entity_txn_id,
57 result_type_cd,
58 number_of_copies,
59 status,
60 src_copy_entity_result_id,
61 information_category,
62 information1,
63 information2,
64 information3,
65 information4,
66 information5,
67 information6,
68 information7,
69 information8,
70 information9,
71 information10,
72 information11,
73 information12,
74 information13,
75 information14,
76 information15,
77 information16,
78 information17,
79 information18,
80 information19,
81 information20,
82 information21,
83 information22,
84 information23,
85 information24,
86 information25,
87 information26,
88 information27,
89 information28,
90 information29,
91 information30,
92 information31,
93 information32,
94 information33,
95 information34,
96 information35,
97 information36,
98 information37,
99 information38,
100 information39,
101 information40,
102 information41,
103 information42,
104 information43,
105 information44,
106 information45,
107 information46,
108 information47,
109 information48,
110 information49,
111 information50,
112 information51,
113 information52,
114 information53,
115 information54,
116 information55,
117 information56,
118 information57,
119 information58,
120 information59,
121 information60,
122 information61,
123 information62,
124 information63,
125 information64,
126 information65,
127 information66,
128 information67,
129 information68,
130 information69,
131 information70,
132 information71,
133 information72,
134 information73,
135 information74,
136 information75,
137 information76,
138 information77,
139 information78,
140 information79,
141 information80,
142 information81,
143 information82,
144 information83,
145 information84,
146 information85,
147 information86,
148 information87,
149 information88,
150 information89,
151 information90,
152 information91,
153 information92,
154 information93,
155 information94,
156 information95,
157 information96,
158 information97,
159 information98,
160 information99,
161 information100,
162 information101,
163 information102,
164 information103,
165 information104,
166 information105,
167 information106,
168 information107,
169 information108,
170 information109,
171 information110,
172 information111,
173 information112,
174 information113,
175 information114,
176 information115,
177 information116,
178 information117,
179 information118,
180 information119,
181 information120,
182 information121,
183 information122,
184 information123,
185 information124,
186 information125,
187 information126,
188 information127,
189 information128,
190 information129,
191 information130,
192 information131,
193 information132,
194 information133,
195 information134,
196 information135,
197 information136,
198 information137,
199 information138,
200 information139,
201 information140,
202 information141,
203 information142,
204 information143,
205 information144,
206 information145,
207 information146,
208 information147,
209 information148,
210 information149,
211 information150,
212 information151,
213 information152,
214 information153,
215 information154,
216 information155,
217 information156,
218 information157,
219 information158,
220 information159,
221 information160,
222 information161,
223 information162,
224 information163,
225 information164,
226 information165,
227 information166,
228 information167,
229 information168,
230 information169,
231 information170,
232 information171,
233 information172,
234 information173,
235 information174,
236 information175,
237 information176,
238 information177,
239 information178,
240 information179,
241 information180,
242 information181,
243 information182,
244 information183,
245 information184,
246 information185,
247 information186,
248 information187,
249 information188,
250 information189,
251 information190,
252 mirror_entity_result_id,
253 mirror_src_entity_result_id,
254 parent_entity_result_id,
255 table_route_id,
256 long_attribute1,
257 object_version_number
258 from pqh_copy_entity_results
259 where copy_entity_result_id = p_copy_entity_result_id;
260 --
261 l_proc varchar2(72) := g_package||'api_updating';
262 l_fct_ret boolean;
263 --
264 Begin
265 hr_utility.set_location('Entering:'||l_proc, 5);
266 --
267 If (
268 p_copy_entity_result_id is null and
269 p_object_version_number is null
270 ) Then
271 --
272 -- One of the primary key arguments is null therefore we must
273 -- set the returning function value to false
274 --
275 l_fct_ret := false;
276 Else
277 If (
278 p_copy_entity_result_id = g_old_rec.copy_entity_result_id and
279 p_object_version_number = g_old_rec.object_version_number
280 ) Then
281 hr_utility.set_location(l_proc, 10);
282 --
283 -- The g_old_rec is current therefore we must
284 -- set the returning function to true
285 --
286 l_fct_ret := true;
287 Else
288 --
289 -- Select the current row into g_old_rec
290 --
291 Open C_Sel1;
292 Fetch C_Sel1 Into g_old_rec;
293 If C_Sel1%notfound Then
294 Close C_Sel1;
295 --
296 -- The primary key is invalid therefore we must error
297 --
298 hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
299 hr_utility.raise_error;
300 End If;
301 Close C_Sel1;
302 If (p_object_version_number <> g_old_rec.object_version_number) Then
303 hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
304 hr_utility.raise_error;
305 End If;
306 hr_utility.set_location(l_proc, 15);
307 l_fct_ret := true;
308 End If;
309 End If;
310 hr_utility.set_location(' Leaving:'||l_proc, 20);
311 Return (l_fct_ret);
312 --
313 End api_updating;
314 --
315 -- ----------------------------------------------------------------------------
316 -- |---------------------------------< lck >----------------------------------|
317 -- ----------------------------------------------------------------------------
318 Procedure lck
319 (
320 p_copy_entity_result_id in number,
321 p_object_version_number in number
322 ) is
323 --
324 -- Cursor selects the 'current' row from the HR Schema
325 --
326 Cursor C_Sel1 is
327 select copy_entity_result_id,
328 copy_entity_txn_id,
329 result_type_cd,
330 number_of_copies,
331 status,
332 src_copy_entity_result_id,
333 information_category,
334 information1,
335 information2,
336 information3,
337 information4,
338 information5,
339 information6,
340 information7,
341 information8,
342 information9,
343 information10,
344 information11,
345 information12,
346 information13,
347 information14,
348 information15,
349 information16,
350 information17,
351 information18,
352 information19,
353 information20,
354 information21,
355 information22,
356 information23,
357 information24,
358 information25,
359 information26,
360 information27,
361 information28,
362 information29,
363 information30,
364 information31,
365 information32,
366 information33,
367 information34,
368 information35,
369 information36,
370 information37,
371 information38,
372 information39,
373 information40,
374 information41,
375 information42,
376 information43,
377 information44,
378 information45,
379 information46,
380 information47,
381 information48,
382 information49,
383 information50,
384 information51,
385 information52,
386 information53,
387 information54,
388 information55,
389 information56,
390 information57,
391 information58,
392 information59,
393 information60,
394 information61,
395 information62,
396 information63,
397 information64,
398 information65,
399 information66,
400 information67,
401 information68,
402 information69,
403 information70,
404 information71,
405 information72,
406 information73,
407 information74,
408 information75,
409 information76,
410 information77,
411 information78,
412 information79,
413 information80,
414 information81,
415 information82,
416 information83,
417 information84,
418 information85,
419 information86,
420 information87,
421 information88,
422 information89,
423 information90,
424 information91,
425 information92,
426 information93,
427 information94,
428 information95,
429 information96,
430 information97,
431 information98,
432 information99,
433 information100,
434 information101,
435 information102,
436 information103,
437 information104,
438 information105,
439 information106,
440 information107,
441 information108,
442 information109,
443 information110,
444 information111,
445 information112,
446 information113,
447 information114,
448 information115,
449 information116,
450 information117,
451 information118,
452 information119,
453 information120,
454 information121,
455 information122,
456 information123,
457 information124,
458 information125,
459 information126,
460 information127,
461 information128,
462 information129,
463 information130,
464 information131,
465 information132,
466 information133,
467 information134,
468 information135,
469 information136,
470 information137,
471 information138,
472 information139,
473 information140,
474 information141,
475 information142,
476 information143,
477 information144,
478 information145,
479 information146,
480 information147,
481 information148,
482 information149,
483 information150,
484 information151,
485 information152,
486 information153,
487 information154,
488 information155,
489 information156,
490 information157,
491 information158,
492 information159,
493 information160,
494 information161,
495 information162,
496 information163,
497 information164,
498 information165,
499 information166,
500 information167,
501 information168,
502 information169,
503 information170,
504 information171,
505 information172,
506 information173,
507 information174,
508 information175,
509 information176,
510 information177,
511 information178,
512 information179,
513 information180,
514 information181,
515 information182,
516 information183,
517 information184,
518 information185,
519 information186,
520 information187,
521 information188,
522 information189,
523 information190,
524 mirror_entity_result_id,
525 mirror_src_entity_result_id,
526 parent_entity_result_id,
527 table_route_id,
528 long_attribute1,
529 object_version_number
530 from pqh_copy_entity_results
531 where copy_entity_result_id = p_copy_entity_result_id
532 for update nowait;
533 --
534 l_proc varchar2(72) := g_package||'lck';
535 --
536 Begin
537 hr_utility.set_location('Entering:'||l_proc, 5);
538 --
539 -- Add any mandatory argument checking here:
540 -- Example:
541 -- hr_api.mandatory_arg_error
542 -- (p_api_name => l_proc,
543 -- p_argument => 'object_version_number',
544 -- p_argument_value => p_object_version_number);
545 --
546 Open C_Sel1;
547 Fetch C_Sel1 Into g_old_rec;
548 If C_Sel1%notfound then
549 Close C_Sel1;
550 --
551 -- The primary key is invalid therefore we must error
552 --
553 hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
554 hr_utility.raise_error;
555 End If;
556 Close C_Sel1;
557 If (p_object_version_number <> g_old_rec.object_version_number) Then
558 hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
559 hr_utility.raise_error;
560 End If;
561 --
562 hr_utility.set_location(' Leaving:'||l_proc, 10);
563 --
564 -- We need to trap the ORA LOCK exception
565 --
566 Exception
567 When HR_Api.Object_Locked then
568 --
569 -- The object is locked therefore we need to supply a meaningful
570 -- error message.
571 --
572 hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
573 hr_utility.set_message_token('TABLE_NAME', 'pqh_copy_entity_results');
574 hr_utility.raise_error;
575 End lck;
579 -- ----------------------------------------------------------------------------
576 --
577 -- ----------------------------------------------------------------------------
578 -- |-----------------------------< convert_args >-----------------------------|
580 Function convert_args
581 (
582 p_copy_entity_result_id in number,
583 p_copy_entity_txn_id in number,
584 p_result_type_cd in varchar2,
585 p_number_of_copies in number,
586 p_status in varchar2,
587 p_src_copy_entity_result_id in number,
588 p_information_category in varchar2,
589 p_information1 in varchar2,
590 p_information2 in varchar2,
591 p_information3 in varchar2,
592 p_information4 in varchar2,
593 p_information5 in varchar2,
594 p_information6 in varchar2,
595 p_information7 in varchar2,
596 p_information8 in varchar2,
597 p_information9 in varchar2,
598 p_information10 in varchar2,
599 p_information11 in varchar2,
600 p_information12 in varchar2,
601 p_information13 in varchar2,
602 p_information14 in varchar2,
603 p_information15 in varchar2,
604 p_information16 in varchar2,
605 p_information17 in varchar2,
606 p_information18 in varchar2,
607 p_information19 in varchar2,
608 p_information20 in varchar2,
609 p_information21 in varchar2,
610 p_information22 in varchar2,
611 p_information23 in varchar2,
612 p_information24 in varchar2,
613 p_information25 in varchar2,
614 p_information26 in varchar2,
615 p_information27 in varchar2,
616 p_information28 in varchar2,
617 p_information29 in varchar2,
618 p_information30 in varchar2,
619 p_information31 in varchar2,
620 p_information32 in varchar2,
621 p_information33 in varchar2,
622 p_information34 in varchar2,
623 p_information35 in varchar2,
624 p_information36 in varchar2,
625 p_information37 in varchar2,
626 p_information38 in varchar2,
627 p_information39 in varchar2,
628 p_information40 in varchar2,
629 p_information41 in varchar2,
630 p_information42 in varchar2,
631 p_information43 in varchar2,
632 p_information44 in varchar2,
633 p_information45 in varchar2,
634 p_information46 in varchar2,
635 p_information47 in varchar2,
636 p_information48 in varchar2,
637 p_information49 in varchar2,
638 p_information50 in varchar2,
639 p_information51 in varchar2,
640 p_information52 in varchar2,
641 p_information53 in varchar2,
642 p_information54 in varchar2,
643 p_information55 in varchar2,
644 p_information56 in varchar2,
645 p_information57 in varchar2,
646 p_information58 in varchar2,
647 p_information59 in varchar2,
648 p_information60 in varchar2,
649 p_information61 in varchar2,
650 p_information62 in varchar2,
651 p_information63 in varchar2,
652 p_information64 in varchar2,
653 p_information65 in varchar2,
654 p_information66 in varchar2,
655 p_information67 in varchar2,
656 p_information68 in varchar2,
657 p_information69 in varchar2,
658 p_information70 in varchar2,
659 p_information71 in varchar2,
660 p_information72 in varchar2,
661 p_information73 in varchar2,
662 p_information74 in varchar2,
663 p_information75 in varchar2,
664 p_information76 in varchar2,
665 p_information77 in varchar2,
666 p_information78 in varchar2,
667 p_information79 in varchar2,
668 p_information80 in varchar2,
669 p_information81 in varchar2,
670 p_information82 in varchar2,
671 p_information83 in varchar2,
672 p_information84 in varchar2,
673 p_information85 in varchar2,
674 p_information86 in varchar2,
675 p_information87 in varchar2,
676 p_information88 in varchar2,
677 p_information89 in varchar2,
678 p_information90 in varchar2,
679 p_information91 in varchar2,
680 p_information92 in varchar2,
681 p_information93 in varchar2,
682 p_information94 in varchar2,
683 p_information95 in varchar2,
684 p_information96 in varchar2,
685 p_information97 in varchar2,
686 p_information98 in varchar2,
687 p_information99 in varchar2,
688 p_information100 in varchar2,
689 p_information101 in varchar2,
690 p_information102 in varchar2,
691 p_information103 in varchar2,
692 p_information104 in varchar2,
693 p_information105 in varchar2,
694 p_information106 in varchar2,
695 p_information107 in varchar2,
696 p_information108 in varchar2,
697 p_information109 in varchar2,
698 p_information110 in varchar2,
699 p_information111 in varchar2,
700 p_information112 in varchar2,
701 p_information113 in varchar2,
702 p_information114 in varchar2,
703 p_information115 in varchar2,
704 p_information116 in varchar2,
705 p_information117 in varchar2,
706 p_information118 in varchar2,
707 p_information119 in varchar2,
708 p_information120 in varchar2,
709 p_information121 in varchar2,
710 p_information122 in varchar2,
711 p_information123 in varchar2,
712 p_information124 in varchar2,
713 p_information125 in varchar2,
714 p_information126 in varchar2,
715 p_information127 in varchar2,
716 p_information128 in varchar2,
717 p_information129 in varchar2,
718 p_information130 in varchar2,
719 p_information131 in varchar2,
720 p_information132 in varchar2,
721 p_information133 in varchar2,
722 p_information134 in varchar2,
723 p_information135 in varchar2,
724 p_information136 in varchar2,
725 p_information137 in varchar2,
726 p_information138 in varchar2,
727 p_information139 in varchar2,
728 p_information140 in varchar2,
729 p_information141 in varchar2,
730 p_information142 in varchar2,
731 p_information143 in varchar2,
732 p_information144 in varchar2,
733 p_information145 in varchar2,
734 p_information146 in varchar2,
735 p_information147 in varchar2,
736 p_information148 in varchar2,
737 p_information149 in varchar2,
738 p_information150 in varchar2,
739 p_information151 in varchar2,
740 p_information152 in varchar2,
741 p_information153 in varchar2,
742 p_information154 in varchar2,
743 p_information155 in varchar2,
744 p_information156 in varchar2,
745 p_information157 in varchar2,
746 p_information158 in varchar2,
747 p_information159 in varchar2,
748 p_information160 in varchar2,
749 p_information161 in varchar2,
750 p_information162 in varchar2,
751 p_information163 in varchar2,
752 p_information164 in varchar2,
753 p_information165 in varchar2,
754 p_information166 in varchar2,
755 p_information167 in varchar2,
756 p_information168 in varchar2,
757 p_information169 in varchar2,
758 p_information170 in varchar2,
759 p_information171 in varchar2,
760 p_information172 in varchar2,
761 p_information173 in varchar2,
762 p_information174 in varchar2,
763 p_information175 in varchar2,
764 p_information176 in varchar2,
765 p_information177 in varchar2,
769 p_information181 in varchar2,
766 p_information178 in varchar2,
767 p_information179 in varchar2,
768 p_information180 in varchar2,
770 p_information182 in varchar2,
771 p_information183 in varchar2,
772 p_information184 in varchar2,
773 p_information185 in varchar2,
774 p_information186 in varchar2,
775 p_information187 in varchar2,
776 p_information188 in varchar2,
777 p_information189 in varchar2,
778 p_information190 in varchar2,
779 p_mirror_entity_result_id in number,
780 p_mirror_src_entity_result_id in number,
781 p_parent_entity_result_id in number,
782 p_table_route_id in number,
783 p_long_attribute1 in clob,
784 p_object_version_number in number
785 )
786 Return g_rec_type is
787 --
788 l_rec g_rec_type;
789 l_proc varchar2(72) := g_package||'convert_args';
790 --
791 Begin
792 --
793 hr_utility.set_location('Entering:'||l_proc, 5);
794 --
795 -- Convert arguments into local l_rec structure.
796 --
797 l_rec.copy_entity_result_id := p_copy_entity_result_id;
798 l_rec.copy_entity_txn_id := p_copy_entity_txn_id;
799 l_rec.result_type_cd := p_result_type_cd;
800 l_rec.number_of_copies := p_number_of_copies;
801 l_rec.status := p_status;
802 l_rec.src_copy_entity_result_id := p_src_copy_entity_result_id;
803 l_rec.information_category := p_information_category;
804 l_rec.information1 := p_information1;
805 l_rec.information2 := p_information2;
806 l_rec.information3 := p_information3;
807 l_rec.information4 := p_information4;
808 l_rec.information5 := p_information5;
809 l_rec.information6 := p_information6;
810 l_rec.information7 := p_information7;
811 l_rec.information8 := p_information8;
812 l_rec.information9 := p_information9;
813 l_rec.information10 := p_information10;
814 l_rec.information11 := p_information11;
815 l_rec.information12 := p_information12;
816 l_rec.information13 := p_information13;
817 l_rec.information14 := p_information14;
818 l_rec.information15 := p_information15;
819 l_rec.information16 := p_information16;
820 l_rec.information17 := p_information17;
821 l_rec.information18 := p_information18;
822 l_rec.information19 := p_information19;
823 l_rec.information20 := p_information20;
824 l_rec.information21 := p_information21;
825 l_rec.information22 := p_information22;
826 l_rec.information23 := p_information23;
827 l_rec.information24 := p_information24;
828 l_rec.information25 := p_information25;
829 l_rec.information26 := p_information26;
830 l_rec.information27 := p_information27;
831 l_rec.information28 := p_information28;
832 l_rec.information29 := p_information29;
833 l_rec.information30 := p_information30;
834 l_rec.information31 := p_information31;
835 l_rec.information32 := p_information32;
836 l_rec.information33 := p_information33;
837 l_rec.information34 := p_information34;
838 l_rec.information35 := p_information35;
839 l_rec.information36 := p_information36;
840 l_rec.information37 := p_information37;
841 l_rec.information38 := p_information38;
842 l_rec.information39 := p_information39;
843 l_rec.information40 := p_information40;
844 l_rec.information41 := p_information41;
845 l_rec.information42 := p_information42;
846 l_rec.information43 := p_information43;
847 l_rec.information44 := p_information44;
848 l_rec.information45 := p_information45;
849 l_rec.information46 := p_information46;
850 l_rec.information47 := p_information47;
851 l_rec.information48 := p_information48;
852 l_rec.information49 := p_information49;
853 l_rec.information50 := p_information50;
854 l_rec.information51 := p_information51;
855 l_rec.information52 := p_information52;
856 l_rec.information53 := p_information53;
857 l_rec.information54 := p_information54;
858 l_rec.information55 := p_information55;
859 l_rec.information56 := p_information56;
860 l_rec.information57 := p_information57;
861 l_rec.information58 := p_information58;
862 l_rec.information59 := p_information59;
863 l_rec.information60 := p_information60;
864 l_rec.information61 := p_information61;
865 l_rec.information62 := p_information62;
866 l_rec.information63 := p_information63;
867 l_rec.information64 := p_information64;
868 l_rec.information65 := p_information65;
869 l_rec.information66 := p_information66;
870 l_rec.information67 := p_information67;
871 l_rec.information68 := p_information68;
872 l_rec.information69 := p_information69;
873 l_rec.information70 := p_information70;
874 l_rec.information71 := p_information71;
875 l_rec.information72 := p_information72;
876 l_rec.information73 := p_information73;
877 l_rec.information74 := p_information74;
878 l_rec.information75 := p_information75;
879 l_rec.information76 := p_information76;
880 l_rec.information77 := p_information77;
881 l_rec.information78 := p_information78;
882 l_rec.information79 := p_information79;
883 l_rec.information80 := p_information80;
884 l_rec.information81 := p_information81;
885 l_rec.information82 := p_information82;
886 l_rec.information83 := p_information83;
887 l_rec.information84 := p_information84;
888 l_rec.information85 := p_information85;
889 l_rec.information86 := p_information86;
890 l_rec.information87 := p_information87;
891 l_rec.information88 := p_information88;
892 l_rec.information89 := p_information89;
893 l_rec.information90 := p_information90;
894 l_rec.information91 := p_information91;
895 l_rec.information92 := p_information92;
896 l_rec.information93 := p_information93;
897 l_rec.information94 := p_information94;
898 l_rec.information95 := p_information95;
899 l_rec.information96 := p_information96;
900 l_rec.information97 := p_information97;
901 l_rec.information98 := p_information98;
902 l_rec.information99 := p_information99;
903 l_rec.information100 := p_information100;
904 l_rec.information101 := p_information101;
905 l_rec.information102 := p_information102;
906 l_rec.information103 := p_information103;
907 l_rec.information104 := p_information104;
908 l_rec.information105 := p_information105;
909 l_rec.information106 := p_information106;
910 l_rec.information107 := p_information107;
911 l_rec.information108 := p_information108;
912 l_rec.information109 := p_information109;
913 l_rec.information110 := p_information110;
914 l_rec.information111 := p_information111;
915 l_rec.information112 := p_information112;
916 l_rec.information113 := p_information113;
917 l_rec.information114 := p_information114;
918 l_rec.information115 := p_information115;
919 l_rec.information116 := p_information116;
920 l_rec.information117 := p_information117;
921 l_rec.information118 := p_information118;
922 l_rec.information119 := p_information119;
923 l_rec.information120 := p_information120;
924 l_rec.information121 := p_information121;
925 l_rec.information122 := p_information122;
926 l_rec.information123 := p_information123;
927 l_rec.information124 := p_information124;
928 l_rec.information125 := p_information125;
929 l_rec.information126 := p_information126;
930 l_rec.information127 := p_information127;
931 l_rec.information128 := p_information128;
932 l_rec.information129 := p_information129;
933 l_rec.information130 := p_information130;
934 l_rec.information131 := p_information131;
935 l_rec.information132 := p_information132;
936 l_rec.information133 := p_information133;
937 l_rec.information134 := p_information134;
938 l_rec.information135 := p_information135;
939 l_rec.information136 := p_information136;
940 l_rec.information137 := p_information137;
941 l_rec.information138 := p_information138;
942 l_rec.information139 := p_information139;
943 l_rec.information140 := p_information140;
944 l_rec.information141 := p_information141;
945 l_rec.information142 := p_information142;
946 l_rec.information143 := p_information143;
947 l_rec.information144 := p_information144;
948 l_rec.information145 := p_information145;
949 l_rec.information146 := p_information146;
950 l_rec.information147 := p_information147;
951 l_rec.information148 := p_information148;
952 l_rec.information149 := p_information149;
953 l_rec.information150 := p_information150;
954 l_rec.information151 := p_information151;
955 l_rec.information152 := p_information152;
956 l_rec.information153 := p_information153;
957 l_rec.information154 := p_information154;
958 l_rec.information155 := p_information155;
959 l_rec.information156 := p_information156;
960 l_rec.information157 := p_information157;
961 l_rec.information158 := p_information158;
962 l_rec.information159 := p_information159;
963 l_rec.information160 := p_information160;
964 l_rec.information161 := p_information161;
965 l_rec.information162 := p_information162;
966 l_rec.information163 := p_information163;
967 l_rec.information164 := p_information164;
968 l_rec.information165 := p_information165;
969 l_rec.information166 := p_information166;
970 l_rec.information167 := p_information167;
971 l_rec.information168 := p_information168;
972 l_rec.information169 := p_information169;
973 l_rec.information170 := p_information170;
974 l_rec.information171 := p_information171;
975 l_rec.information172 := p_information172;
976 l_rec.information173 := p_information173;
977 l_rec.information174 := p_information174;
978 l_rec.information175 := p_information175;
979 l_rec.information176 := p_information176;
980 l_rec.information177 := p_information177;
981 l_rec.information178 := p_information178;
982 l_rec.information179 := p_information179;
983 l_rec.information180 := p_information180;
984 l_rec.information181 := p_information181;
985 l_rec.information182 := p_information182;
986 l_rec.information183 := p_information183;
987 l_rec.information184 := p_information184;
988 l_rec.information185 := p_information185;
989 l_rec.information186 := p_information186;
990 l_rec.information187 := p_information187;
991 l_rec.information188 := p_information188;
992 l_rec.information189 := p_information189;
993 l_rec.information190 := p_information190;
994 l_rec.mirror_entity_result_id := p_mirror_entity_result_id;
995 l_rec.mirror_src_entity_result_id := p_mirror_src_entity_result_id;
996 l_rec.parent_entity_result_id := p_parent_entity_result_id;
997 l_rec.table_route_id := p_table_route_id;
998 l_rec.long_attribute1 := p_long_attribute1;
999 l_rec.object_version_number := p_object_version_number;
1000 --
1001 -- Return the plsql record structure.
1002 --
1003 hr_utility.set_location(' Leaving:'||l_proc, 10);
1004 Return(l_rec);
1005 --
1006 End convert_args;
1007 --
1008 end pqh_cer_shd;