126: --
127: hr_utility.set_location(' Leaving:'||l_proc, 10);
128: --
129: Exception
130: When hr_api.check_integrity_violated Then
131: -- A check constraint has been violated
132: --
133: irc_ipd_shd.constraint_error
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
130: When hr_api.check_integrity_violated Then
131: -- A check constraint has been violated
132: --
133: irc_ipd_shd.constraint_error
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
135: When hr_api.parent_integrity_violated Then
136: -- Parent integrity has been violated
137: --
138: irc_ipd_shd.constraint_error
131: -- A check constraint has been violated
132: --
133: irc_ipd_shd.constraint_error
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
135: When hr_api.parent_integrity_violated Then
136: -- Parent integrity has been violated
137: --
138: irc_ipd_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
135: When hr_api.parent_integrity_violated Then
136: -- Parent integrity has been violated
137: --
138: irc_ipd_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When hr_api.unique_integrity_violated Then
141: -- Unique integrity has been violated
142: --
143: irc_ipd_shd.constraint_error
136: -- Parent integrity has been violated
137: --
138: irc_ipd_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When hr_api.unique_integrity_violated Then
141: -- Unique integrity has been violated
142: --
143: irc_ipd_shd.constraint_error
144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When hr_api.unique_integrity_violated Then
141: -- Unique integrity has been violated
142: --
143: irc_ipd_shd.constraint_error
144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
145: When Others Then
146: --
147: Raise;
148: End update_dml;
447: );
448: --
449: exception
450: --
451: when hr_api.cannot_find_prog_unit then
452: --
453: hr_api.cannot_find_prog_unit_error
454: (p_module_name => 'IRC_PENDING_DATA'
455: ,p_hook_type => 'AU');
449: exception
450: --
451: when hr_api.cannot_find_prog_unit then
452: --
453: hr_api.cannot_find_prog_unit_error
454: (p_module_name => 'IRC_PENDING_DATA'
455: ,p_hook_type => 'AU');
456: --
457: end;
512: -- p_rec plsql record structure
513: -- to see if a system default is being used. If a system default
514: -- is being used then we must set to the 'current' argument value.
515: --
516: If (p_rec.email_address = hr_api.g_varchar2) then
517: p_rec.email_address :=
518: irc_ipd_shd.g_old_rec.email_address;
519: End If;
520: If (p_rec.vacancy_id = hr_api.g_number) then
516: If (p_rec.email_address = hr_api.g_varchar2) then
517: p_rec.email_address :=
518: irc_ipd_shd.g_old_rec.email_address;
519: End If;
520: If (p_rec.vacancy_id = hr_api.g_number) then
521: p_rec.vacancy_id :=
522: irc_ipd_shd.g_old_rec.vacancy_id;
523: End If;
524: If (p_rec.last_name = hr_api.g_varchar2) then
520: If (p_rec.vacancy_id = hr_api.g_number) then
521: p_rec.vacancy_id :=
522: irc_ipd_shd.g_old_rec.vacancy_id;
523: End If;
524: If (p_rec.last_name = hr_api.g_varchar2) then
525: p_rec.last_name :=
526: irc_ipd_shd.g_old_rec.last_name;
527: End If;
528: If (p_rec.first_name = hr_api.g_varchar2) then
524: If (p_rec.last_name = hr_api.g_varchar2) then
525: p_rec.last_name :=
526: irc_ipd_shd.g_old_rec.last_name;
527: End If;
528: If (p_rec.first_name = hr_api.g_varchar2) then
529: p_rec.first_name :=
530: irc_ipd_shd.g_old_rec.first_name;
531: End If;
532: If (p_rec.user_password = hr_api.g_varchar2) then
528: If (p_rec.first_name = hr_api.g_varchar2) then
529: p_rec.first_name :=
530: irc_ipd_shd.g_old_rec.first_name;
531: End If;
532: If (p_rec.user_password = hr_api.g_varchar2) then
533: p_rec.user_password :=
534: irc_ipd_shd.g_old_rec.user_password;
535: End If;
536: If (p_rec.resume_file_name = hr_api.g_varchar2) then
532: If (p_rec.user_password = hr_api.g_varchar2) then
533: p_rec.user_password :=
534: irc_ipd_shd.g_old_rec.user_password;
535: End If;
536: If (p_rec.resume_file_name = hr_api.g_varchar2) then
537: p_rec.resume_file_name :=
538: irc_ipd_shd.g_old_rec.resume_file_name;
539: End If;
540: If (p_rec.resume_description = hr_api.g_varchar2) then
536: If (p_rec.resume_file_name = hr_api.g_varchar2) then
537: p_rec.resume_file_name :=
538: irc_ipd_shd.g_old_rec.resume_file_name;
539: End If;
540: If (p_rec.resume_description = hr_api.g_varchar2) then
541: p_rec.resume_description :=
542: irc_ipd_shd.g_old_rec.resume_description;
543: End If;
544: If (p_rec.resume_mime_type = hr_api.g_varchar2) then
540: If (p_rec.resume_description = hr_api.g_varchar2) then
541: p_rec.resume_description :=
542: irc_ipd_shd.g_old_rec.resume_description;
543: End If;
544: If (p_rec.resume_mime_type = hr_api.g_varchar2) then
545: p_rec.resume_mime_type :=
546: irc_ipd_shd.g_old_rec.resume_mime_type;
547: End If;
548: If (p_rec.source_type = hr_api.g_varchar2) then
544: If (p_rec.resume_mime_type = hr_api.g_varchar2) then
545: p_rec.resume_mime_type :=
546: irc_ipd_shd.g_old_rec.resume_mime_type;
547: End If;
548: If (p_rec.source_type = hr_api.g_varchar2) then
549: p_rec.source_type :=
550: irc_ipd_shd.g_old_rec.source_type;
551: End If;
552: If (p_rec.job_post_source_name = hr_api.g_varchar2) then
548: If (p_rec.source_type = hr_api.g_varchar2) then
549: p_rec.source_type :=
550: irc_ipd_shd.g_old_rec.source_type;
551: End If;
552: If (p_rec.job_post_source_name = hr_api.g_varchar2) then
553: p_rec.job_post_source_name :=
554: irc_ipd_shd.g_old_rec.job_post_source_name;
555: End If;
556: If (p_rec.posting_content_id = hr_api.g_number) then
552: If (p_rec.job_post_source_name = hr_api.g_varchar2) then
553: p_rec.job_post_source_name :=
554: irc_ipd_shd.g_old_rec.job_post_source_name;
555: End If;
556: If (p_rec.posting_content_id = hr_api.g_number) then
557: p_rec.posting_content_id :=
558: irc_ipd_shd.g_old_rec.posting_content_id;
559: End If;
560: If (p_rec.person_id = hr_api.g_number) then
556: If (p_rec.posting_content_id = hr_api.g_number) then
557: p_rec.posting_content_id :=
558: irc_ipd_shd.g_old_rec.posting_content_id;
559: End If;
560: If (p_rec.person_id = hr_api.g_number) then
561: p_rec.person_id :=
562: irc_ipd_shd.g_old_rec.person_id;
563: End If;
564: If (p_rec.processed = hr_api.g_varchar2) then
560: If (p_rec.person_id = hr_api.g_number) then
561: p_rec.person_id :=
562: irc_ipd_shd.g_old_rec.person_id;
563: End If;
564: If (p_rec.processed = hr_api.g_varchar2) then
565: p_rec.processed :=
566: irc_ipd_shd.g_old_rec.processed;
567: End If;
568: If (p_rec.sex = hr_api.g_varchar2) then
564: If (p_rec.processed = hr_api.g_varchar2) then
565: p_rec.processed :=
566: irc_ipd_shd.g_old_rec.processed;
567: End If;
568: If (p_rec.sex = hr_api.g_varchar2) then
569: p_rec.sex :=
570: irc_ipd_shd.g_old_rec.sex;
571: End If;
572: If (p_rec.date_of_birth = hr_api.g_date) then
568: If (p_rec.sex = hr_api.g_varchar2) then
569: p_rec.sex :=
570: irc_ipd_shd.g_old_rec.sex;
571: End If;
572: If (p_rec.date_of_birth = hr_api.g_date) then
573: p_rec.date_of_birth :=
574: irc_ipd_shd.g_old_rec.date_of_birth;
575: End If;
576: If (p_rec.per_information_category = hr_api.g_varchar2) then
572: If (p_rec.date_of_birth = hr_api.g_date) then
573: p_rec.date_of_birth :=
574: irc_ipd_shd.g_old_rec.date_of_birth;
575: End If;
576: If (p_rec.per_information_category = hr_api.g_varchar2) then
577: p_rec.per_information_category :=
578: irc_ipd_shd.g_old_rec.per_information_category;
579: End If;
580: If (p_rec.per_information1 = hr_api.g_varchar2) then
576: If (p_rec.per_information_category = hr_api.g_varchar2) then
577: p_rec.per_information_category :=
578: irc_ipd_shd.g_old_rec.per_information_category;
579: End If;
580: If (p_rec.per_information1 = hr_api.g_varchar2) then
581: p_rec.per_information1 :=
582: irc_ipd_shd.g_old_rec.per_information1;
583: End If;
584: If (p_rec.per_information2 = hr_api.g_varchar2) then
580: If (p_rec.per_information1 = hr_api.g_varchar2) then
581: p_rec.per_information1 :=
582: irc_ipd_shd.g_old_rec.per_information1;
583: End If;
584: If (p_rec.per_information2 = hr_api.g_varchar2) then
585: p_rec.per_information2 :=
586: irc_ipd_shd.g_old_rec.per_information2;
587: End If;
588: If (p_rec.per_information3 = hr_api.g_varchar2) then
584: If (p_rec.per_information2 = hr_api.g_varchar2) then
585: p_rec.per_information2 :=
586: irc_ipd_shd.g_old_rec.per_information2;
587: End If;
588: If (p_rec.per_information3 = hr_api.g_varchar2) then
589: p_rec.per_information3 :=
590: irc_ipd_shd.g_old_rec.per_information3;
591: End If;
592: If (p_rec.per_information4 = hr_api.g_varchar2) then
588: If (p_rec.per_information3 = hr_api.g_varchar2) then
589: p_rec.per_information3 :=
590: irc_ipd_shd.g_old_rec.per_information3;
591: End If;
592: If (p_rec.per_information4 = hr_api.g_varchar2) then
593: p_rec.per_information4 :=
594: irc_ipd_shd.g_old_rec.per_information4;
595: End If;
596: If (p_rec.per_information5 = hr_api.g_varchar2) then
592: If (p_rec.per_information4 = hr_api.g_varchar2) then
593: p_rec.per_information4 :=
594: irc_ipd_shd.g_old_rec.per_information4;
595: End If;
596: If (p_rec.per_information5 = hr_api.g_varchar2) then
597: p_rec.per_information5 :=
598: irc_ipd_shd.g_old_rec.per_information5;
599: End If;
600: If (p_rec.per_information6 = hr_api.g_varchar2) then
596: If (p_rec.per_information5 = hr_api.g_varchar2) then
597: p_rec.per_information5 :=
598: irc_ipd_shd.g_old_rec.per_information5;
599: End If;
600: If (p_rec.per_information6 = hr_api.g_varchar2) then
601: p_rec.per_information6 :=
602: irc_ipd_shd.g_old_rec.per_information6;
603: End If;
604: If (p_rec.per_information7 = hr_api.g_varchar2) then
600: If (p_rec.per_information6 = hr_api.g_varchar2) then
601: p_rec.per_information6 :=
602: irc_ipd_shd.g_old_rec.per_information6;
603: End If;
604: If (p_rec.per_information7 = hr_api.g_varchar2) then
605: p_rec.per_information7 :=
606: irc_ipd_shd.g_old_rec.per_information7;
607: End If;
608: If (p_rec.per_information8 = hr_api.g_varchar2) then
604: If (p_rec.per_information7 = hr_api.g_varchar2) then
605: p_rec.per_information7 :=
606: irc_ipd_shd.g_old_rec.per_information7;
607: End If;
608: If (p_rec.per_information8 = hr_api.g_varchar2) then
609: p_rec.per_information8 :=
610: irc_ipd_shd.g_old_rec.per_information8;
611: End If;
612: If (p_rec.per_information9 = hr_api.g_varchar2) then
608: If (p_rec.per_information8 = hr_api.g_varchar2) then
609: p_rec.per_information8 :=
610: irc_ipd_shd.g_old_rec.per_information8;
611: End If;
612: If (p_rec.per_information9 = hr_api.g_varchar2) then
613: p_rec.per_information9 :=
614: irc_ipd_shd.g_old_rec.per_information9;
615: End If;
616: If (p_rec.per_information10 = hr_api.g_varchar2) then
612: If (p_rec.per_information9 = hr_api.g_varchar2) then
613: p_rec.per_information9 :=
614: irc_ipd_shd.g_old_rec.per_information9;
615: End If;
616: If (p_rec.per_information10 = hr_api.g_varchar2) then
617: p_rec.per_information10 :=
618: irc_ipd_shd.g_old_rec.per_information10;
619: End If;
620: If (p_rec.per_information11 = hr_api.g_varchar2) then
616: If (p_rec.per_information10 = hr_api.g_varchar2) then
617: p_rec.per_information10 :=
618: irc_ipd_shd.g_old_rec.per_information10;
619: End If;
620: If (p_rec.per_information11 = hr_api.g_varchar2) then
621: p_rec.per_information11 :=
622: irc_ipd_shd.g_old_rec.per_information11;
623: End If;
624: If (p_rec.per_information12 = hr_api.g_varchar2) then
620: If (p_rec.per_information11 = hr_api.g_varchar2) then
621: p_rec.per_information11 :=
622: irc_ipd_shd.g_old_rec.per_information11;
623: End If;
624: If (p_rec.per_information12 = hr_api.g_varchar2) then
625: p_rec.per_information12 :=
626: irc_ipd_shd.g_old_rec.per_information12;
627: End If;
628: If (p_rec.per_information13 = hr_api.g_varchar2) then
624: If (p_rec.per_information12 = hr_api.g_varchar2) then
625: p_rec.per_information12 :=
626: irc_ipd_shd.g_old_rec.per_information12;
627: End If;
628: If (p_rec.per_information13 = hr_api.g_varchar2) then
629: p_rec.per_information13 :=
630: irc_ipd_shd.g_old_rec.per_information13;
631: End If;
632: If (p_rec.per_information14 = hr_api.g_varchar2) then
628: If (p_rec.per_information13 = hr_api.g_varchar2) then
629: p_rec.per_information13 :=
630: irc_ipd_shd.g_old_rec.per_information13;
631: End If;
632: If (p_rec.per_information14 = hr_api.g_varchar2) then
633: p_rec.per_information14 :=
634: irc_ipd_shd.g_old_rec.per_information14;
635: End If;
636: If (p_rec.per_information15 = hr_api.g_varchar2) then
632: If (p_rec.per_information14 = hr_api.g_varchar2) then
633: p_rec.per_information14 :=
634: irc_ipd_shd.g_old_rec.per_information14;
635: End If;
636: If (p_rec.per_information15 = hr_api.g_varchar2) then
637: p_rec.per_information15 :=
638: irc_ipd_shd.g_old_rec.per_information15;
639: End If;
640: If (p_rec.per_information16 = hr_api.g_varchar2) then
636: If (p_rec.per_information15 = hr_api.g_varchar2) then
637: p_rec.per_information15 :=
638: irc_ipd_shd.g_old_rec.per_information15;
639: End If;
640: If (p_rec.per_information16 = hr_api.g_varchar2) then
641: p_rec.per_information16 :=
642: irc_ipd_shd.g_old_rec.per_information16;
643: End If;
644: If (p_rec.per_information17 = hr_api.g_varchar2) then
640: If (p_rec.per_information16 = hr_api.g_varchar2) then
641: p_rec.per_information16 :=
642: irc_ipd_shd.g_old_rec.per_information16;
643: End If;
644: If (p_rec.per_information17 = hr_api.g_varchar2) then
645: p_rec.per_information17 :=
646: irc_ipd_shd.g_old_rec.per_information17;
647: End If;
648: If (p_rec.per_information18 = hr_api.g_varchar2) then
644: If (p_rec.per_information17 = hr_api.g_varchar2) then
645: p_rec.per_information17 :=
646: irc_ipd_shd.g_old_rec.per_information17;
647: End If;
648: If (p_rec.per_information18 = hr_api.g_varchar2) then
649: p_rec.per_information18 :=
650: irc_ipd_shd.g_old_rec.per_information18;
651: End If;
652: If (p_rec.per_information19 = hr_api.g_varchar2) then
648: If (p_rec.per_information18 = hr_api.g_varchar2) then
649: p_rec.per_information18 :=
650: irc_ipd_shd.g_old_rec.per_information18;
651: End If;
652: If (p_rec.per_information19 = hr_api.g_varchar2) then
653: p_rec.per_information19 :=
654: irc_ipd_shd.g_old_rec.per_information19;
655: End If;
656: If (p_rec.per_information20 = hr_api.g_varchar2) then
652: If (p_rec.per_information19 = hr_api.g_varchar2) then
653: p_rec.per_information19 :=
654: irc_ipd_shd.g_old_rec.per_information19;
655: End If;
656: If (p_rec.per_information20 = hr_api.g_varchar2) then
657: p_rec.per_information20 :=
658: irc_ipd_shd.g_old_rec.per_information20;
659: End If;
660: If (p_rec.per_information21 = hr_api.g_varchar2) then
656: If (p_rec.per_information20 = hr_api.g_varchar2) then
657: p_rec.per_information20 :=
658: irc_ipd_shd.g_old_rec.per_information20;
659: End If;
660: If (p_rec.per_information21 = hr_api.g_varchar2) then
661: p_rec.per_information21 :=
662: irc_ipd_shd.g_old_rec.per_information21;
663: End If;
664: If (p_rec.per_information22 = hr_api.g_varchar2) then
660: If (p_rec.per_information21 = hr_api.g_varchar2) then
661: p_rec.per_information21 :=
662: irc_ipd_shd.g_old_rec.per_information21;
663: End If;
664: If (p_rec.per_information22 = hr_api.g_varchar2) then
665: p_rec.per_information22 :=
666: irc_ipd_shd.g_old_rec.per_information22;
667: End If;
668: If (p_rec.per_information23 = hr_api.g_varchar2) then
664: If (p_rec.per_information22 = hr_api.g_varchar2) then
665: p_rec.per_information22 :=
666: irc_ipd_shd.g_old_rec.per_information22;
667: End If;
668: If (p_rec.per_information23 = hr_api.g_varchar2) then
669: p_rec.per_information23 :=
670: irc_ipd_shd.g_old_rec.per_information23;
671: End If;
672: If (p_rec.per_information24 = hr_api.g_varchar2) then
668: If (p_rec.per_information23 = hr_api.g_varchar2) then
669: p_rec.per_information23 :=
670: irc_ipd_shd.g_old_rec.per_information23;
671: End If;
672: If (p_rec.per_information24 = hr_api.g_varchar2) then
673: p_rec.per_information24 :=
674: irc_ipd_shd.g_old_rec.per_information24;
675: End If;
676: If (p_rec.per_information25 = hr_api.g_varchar2) then
672: If (p_rec.per_information24 = hr_api.g_varchar2) then
673: p_rec.per_information24 :=
674: irc_ipd_shd.g_old_rec.per_information24;
675: End If;
676: If (p_rec.per_information25 = hr_api.g_varchar2) then
677: p_rec.per_information25 :=
678: irc_ipd_shd.g_old_rec.per_information25;
679: End If;
680: If (p_rec.per_information26 = hr_api.g_varchar2) then
676: If (p_rec.per_information25 = hr_api.g_varchar2) then
677: p_rec.per_information25 :=
678: irc_ipd_shd.g_old_rec.per_information25;
679: End If;
680: If (p_rec.per_information26 = hr_api.g_varchar2) then
681: p_rec.per_information26 :=
682: irc_ipd_shd.g_old_rec.per_information26;
683: End If;
684: If (p_rec.per_information27 = hr_api.g_varchar2) then
680: If (p_rec.per_information26 = hr_api.g_varchar2) then
681: p_rec.per_information26 :=
682: irc_ipd_shd.g_old_rec.per_information26;
683: End If;
684: If (p_rec.per_information27 = hr_api.g_varchar2) then
685: p_rec.per_information27 :=
686: irc_ipd_shd.g_old_rec.per_information27;
687: End If;
688: If (p_rec.per_information28 = hr_api.g_varchar2) then
684: If (p_rec.per_information27 = hr_api.g_varchar2) then
685: p_rec.per_information27 :=
686: irc_ipd_shd.g_old_rec.per_information27;
687: End If;
688: If (p_rec.per_information28 = hr_api.g_varchar2) then
689: p_rec.per_information28 :=
690: irc_ipd_shd.g_old_rec.per_information28;
691: End If;
692: If (p_rec.per_information29 = hr_api.g_varchar2) then
688: If (p_rec.per_information28 = hr_api.g_varchar2) then
689: p_rec.per_information28 :=
690: irc_ipd_shd.g_old_rec.per_information28;
691: End If;
692: If (p_rec.per_information29 = hr_api.g_varchar2) then
693: p_rec.per_information29 :=
694: irc_ipd_shd.g_old_rec.per_information29;
695: End If;
696: If (p_rec.per_information30 = hr_api.g_varchar2) then
692: If (p_rec.per_information29 = hr_api.g_varchar2) then
693: p_rec.per_information29 :=
694: irc_ipd_shd.g_old_rec.per_information29;
695: End If;
696: If (p_rec.per_information30 = hr_api.g_varchar2) then
697: p_rec.per_information30 :=
698: irc_ipd_shd.g_old_rec.per_information30;
699: End If;
700: If (p_rec.error_message = hr_api.g_varchar2) then
696: If (p_rec.per_information30 = hr_api.g_varchar2) then
697: p_rec.per_information30 :=
698: irc_ipd_shd.g_old_rec.per_information30;
699: End If;
700: If (p_rec.error_message = hr_api.g_varchar2) then
701: p_rec.error_message :=
702: irc_ipd_shd.g_old_rec.error_message;
703: End If;
704: If (p_rec.creation_date= hr_api.g_date) then
700: If (p_rec.error_message = hr_api.g_varchar2) then
701: p_rec.error_message :=
702: irc_ipd_shd.g_old_rec.error_message;
703: End If;
704: If (p_rec.creation_date= hr_api.g_date) then
705: p_rec.creation_date :=
706: irc_ipd_shd.g_old_rec.creation_date;
707: End If;
708: If (p_rec.last_update_date = hr_api.g_date) then
704: If (p_rec.creation_date= hr_api.g_date) then
705: p_rec.creation_date :=
706: irc_ipd_shd.g_old_rec.creation_date;
707: End If;
708: If (p_rec.last_update_date = hr_api.g_date) then
709: p_rec.last_update_date :=
710: irc_ipd_shd.g_old_rec.last_update_date;
711: End If;
712: If (p_rec.allow_access = hr_api.g_varchar2) then
708: If (p_rec.last_update_date = hr_api.g_date) then
709: p_rec.last_update_date :=
710: irc_ipd_shd.g_old_rec.last_update_date;
711: End If;
712: If (p_rec.allow_access = hr_api.g_varchar2) then
713: p_rec.allow_access :=
714: irc_ipd_shd.g_old_rec.allow_access;
715: End If;
716: -- don't handle USER_GUID as we don't have a default value for RAW
713: p_rec.allow_access :=
714: irc_ipd_shd.g_old_rec.allow_access;
715: End If;
716: -- don't handle USER_GUID as we don't have a default value for RAW
717: If (p_rec.visitor_resp_key = hr_api.g_varchar2) then
718: p_rec.visitor_resp_key :=
719: irc_ipd_shd.g_old_rec.visitor_resp_key;
720: End If;
721: If (p_rec.visitor_resp_appl_id = hr_api.g_number) then
717: If (p_rec.visitor_resp_key = hr_api.g_varchar2) then
718: p_rec.visitor_resp_key :=
719: irc_ipd_shd.g_old_rec.visitor_resp_key;
720: End If;
721: If (p_rec.visitor_resp_appl_id = hr_api.g_number) then
722: p_rec.visitor_resp_appl_id :=
723: irc_ipd_shd.g_old_rec.visitor_resp_appl_id;
724: End If;
725: If (p_rec.security_group_key = hr_api.g_varchar2) then
721: If (p_rec.visitor_resp_appl_id = hr_api.g_number) then
722: p_rec.visitor_resp_appl_id :=
723: irc_ipd_shd.g_old_rec.visitor_resp_appl_id;
724: End If;
725: If (p_rec.security_group_key = hr_api.g_varchar2) then
726: p_rec.security_group_key :=
727: irc_ipd_shd.g_old_rec.security_group_key;
728: End If;
729: --
783: -- |---------------------------------< upd >----------------------------------|
784: -- ----------------------------------------------------------------------------
785: Procedure upd
786: (p_pending_data_id in number
787: ,p_email_address in varchar2 default hr_api.g_varchar2
788: ,p_last_name in varchar2 default hr_api.g_varchar2
789: ,p_first_name in varchar2 default hr_api.g_varchar2
790: ,p_user_password in varchar2 default hr_api.g_varchar2
791: ,p_resume_file_name in varchar2 default hr_api.g_varchar2
784: -- ----------------------------------------------------------------------------
785: Procedure upd
786: (p_pending_data_id in number
787: ,p_email_address in varchar2 default hr_api.g_varchar2
788: ,p_last_name in varchar2 default hr_api.g_varchar2
789: ,p_first_name in varchar2 default hr_api.g_varchar2
790: ,p_user_password in varchar2 default hr_api.g_varchar2
791: ,p_resume_file_name in varchar2 default hr_api.g_varchar2
792: ,p_resume_description in varchar2 default hr_api.g_varchar2
785: Procedure upd
786: (p_pending_data_id in number
787: ,p_email_address in varchar2 default hr_api.g_varchar2
788: ,p_last_name in varchar2 default hr_api.g_varchar2
789: ,p_first_name in varchar2 default hr_api.g_varchar2
790: ,p_user_password in varchar2 default hr_api.g_varchar2
791: ,p_resume_file_name in varchar2 default hr_api.g_varchar2
792: ,p_resume_description in varchar2 default hr_api.g_varchar2
793: ,p_resume_mime_type in varchar2 default hr_api.g_varchar2
786: (p_pending_data_id in number
787: ,p_email_address in varchar2 default hr_api.g_varchar2
788: ,p_last_name in varchar2 default hr_api.g_varchar2
789: ,p_first_name in varchar2 default hr_api.g_varchar2
790: ,p_user_password in varchar2 default hr_api.g_varchar2
791: ,p_resume_file_name in varchar2 default hr_api.g_varchar2
792: ,p_resume_description in varchar2 default hr_api.g_varchar2
793: ,p_resume_mime_type in varchar2 default hr_api.g_varchar2
794: ,p_source_type in varchar2 default hr_api.g_varchar2
787: ,p_email_address in varchar2 default hr_api.g_varchar2
788: ,p_last_name in varchar2 default hr_api.g_varchar2
789: ,p_first_name in varchar2 default hr_api.g_varchar2
790: ,p_user_password in varchar2 default hr_api.g_varchar2
791: ,p_resume_file_name in varchar2 default hr_api.g_varchar2
792: ,p_resume_description in varchar2 default hr_api.g_varchar2
793: ,p_resume_mime_type in varchar2 default hr_api.g_varchar2
794: ,p_source_type in varchar2 default hr_api.g_varchar2
795: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
788: ,p_last_name in varchar2 default hr_api.g_varchar2
789: ,p_first_name in varchar2 default hr_api.g_varchar2
790: ,p_user_password in varchar2 default hr_api.g_varchar2
791: ,p_resume_file_name in varchar2 default hr_api.g_varchar2
792: ,p_resume_description in varchar2 default hr_api.g_varchar2
793: ,p_resume_mime_type in varchar2 default hr_api.g_varchar2
794: ,p_source_type in varchar2 default hr_api.g_varchar2
795: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
796: ,p_posting_content_id in number default hr_api.g_number
789: ,p_first_name in varchar2 default hr_api.g_varchar2
790: ,p_user_password in varchar2 default hr_api.g_varchar2
791: ,p_resume_file_name in varchar2 default hr_api.g_varchar2
792: ,p_resume_description in varchar2 default hr_api.g_varchar2
793: ,p_resume_mime_type in varchar2 default hr_api.g_varchar2
794: ,p_source_type in varchar2 default hr_api.g_varchar2
795: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
796: ,p_posting_content_id in number default hr_api.g_number
797: ,p_person_id in number default hr_api.g_number
790: ,p_user_password in varchar2 default hr_api.g_varchar2
791: ,p_resume_file_name in varchar2 default hr_api.g_varchar2
792: ,p_resume_description in varchar2 default hr_api.g_varchar2
793: ,p_resume_mime_type in varchar2 default hr_api.g_varchar2
794: ,p_source_type in varchar2 default hr_api.g_varchar2
795: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
796: ,p_posting_content_id in number default hr_api.g_number
797: ,p_person_id in number default hr_api.g_number
798: ,p_processed in varchar2 default hr_api.g_varchar2
791: ,p_resume_file_name in varchar2 default hr_api.g_varchar2
792: ,p_resume_description in varchar2 default hr_api.g_varchar2
793: ,p_resume_mime_type in varchar2 default hr_api.g_varchar2
794: ,p_source_type in varchar2 default hr_api.g_varchar2
795: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
796: ,p_posting_content_id in number default hr_api.g_number
797: ,p_person_id in number default hr_api.g_number
798: ,p_processed in varchar2 default hr_api.g_varchar2
799: ,p_sex in varchar2 default hr_api.g_varchar2
792: ,p_resume_description in varchar2 default hr_api.g_varchar2
793: ,p_resume_mime_type in varchar2 default hr_api.g_varchar2
794: ,p_source_type in varchar2 default hr_api.g_varchar2
795: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
796: ,p_posting_content_id in number default hr_api.g_number
797: ,p_person_id in number default hr_api.g_number
798: ,p_processed in varchar2 default hr_api.g_varchar2
799: ,p_sex in varchar2 default hr_api.g_varchar2
800: ,p_date_of_birth in date default hr_api.g_date
793: ,p_resume_mime_type in varchar2 default hr_api.g_varchar2
794: ,p_source_type in varchar2 default hr_api.g_varchar2
795: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
796: ,p_posting_content_id in number default hr_api.g_number
797: ,p_person_id in number default hr_api.g_number
798: ,p_processed in varchar2 default hr_api.g_varchar2
799: ,p_sex in varchar2 default hr_api.g_varchar2
800: ,p_date_of_birth in date default hr_api.g_date
801: ,p_per_information_category in varchar2 default hr_api.g_varchar2
794: ,p_source_type in varchar2 default hr_api.g_varchar2
795: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
796: ,p_posting_content_id in number default hr_api.g_number
797: ,p_person_id in number default hr_api.g_number
798: ,p_processed in varchar2 default hr_api.g_varchar2
799: ,p_sex in varchar2 default hr_api.g_varchar2
800: ,p_date_of_birth in date default hr_api.g_date
801: ,p_per_information_category in varchar2 default hr_api.g_varchar2
802: ,p_per_information1 in varchar2 default hr_api.g_varchar2
795: ,p_job_post_source_name in varchar2 default hr_api.g_varchar2
796: ,p_posting_content_id in number default hr_api.g_number
797: ,p_person_id in number default hr_api.g_number
798: ,p_processed in varchar2 default hr_api.g_varchar2
799: ,p_sex in varchar2 default hr_api.g_varchar2
800: ,p_date_of_birth in date default hr_api.g_date
801: ,p_per_information_category in varchar2 default hr_api.g_varchar2
802: ,p_per_information1 in varchar2 default hr_api.g_varchar2
803: ,p_per_information2 in varchar2 default hr_api.g_varchar2
796: ,p_posting_content_id in number default hr_api.g_number
797: ,p_person_id in number default hr_api.g_number
798: ,p_processed in varchar2 default hr_api.g_varchar2
799: ,p_sex in varchar2 default hr_api.g_varchar2
800: ,p_date_of_birth in date default hr_api.g_date
801: ,p_per_information_category in varchar2 default hr_api.g_varchar2
802: ,p_per_information1 in varchar2 default hr_api.g_varchar2
803: ,p_per_information2 in varchar2 default hr_api.g_varchar2
804: ,p_per_information3 in varchar2 default hr_api.g_varchar2
797: ,p_person_id in number default hr_api.g_number
798: ,p_processed in varchar2 default hr_api.g_varchar2
799: ,p_sex in varchar2 default hr_api.g_varchar2
800: ,p_date_of_birth in date default hr_api.g_date
801: ,p_per_information_category in varchar2 default hr_api.g_varchar2
802: ,p_per_information1 in varchar2 default hr_api.g_varchar2
803: ,p_per_information2 in varchar2 default hr_api.g_varchar2
804: ,p_per_information3 in varchar2 default hr_api.g_varchar2
805: ,p_per_information4 in varchar2 default hr_api.g_varchar2
798: ,p_processed in varchar2 default hr_api.g_varchar2
799: ,p_sex in varchar2 default hr_api.g_varchar2
800: ,p_date_of_birth in date default hr_api.g_date
801: ,p_per_information_category in varchar2 default hr_api.g_varchar2
802: ,p_per_information1 in varchar2 default hr_api.g_varchar2
803: ,p_per_information2 in varchar2 default hr_api.g_varchar2
804: ,p_per_information3 in varchar2 default hr_api.g_varchar2
805: ,p_per_information4 in varchar2 default hr_api.g_varchar2
806: ,p_per_information5 in varchar2 default hr_api.g_varchar2
799: ,p_sex in varchar2 default hr_api.g_varchar2
800: ,p_date_of_birth in date default hr_api.g_date
801: ,p_per_information_category in varchar2 default hr_api.g_varchar2
802: ,p_per_information1 in varchar2 default hr_api.g_varchar2
803: ,p_per_information2 in varchar2 default hr_api.g_varchar2
804: ,p_per_information3 in varchar2 default hr_api.g_varchar2
805: ,p_per_information4 in varchar2 default hr_api.g_varchar2
806: ,p_per_information5 in varchar2 default hr_api.g_varchar2
807: ,p_per_information6 in varchar2 default hr_api.g_varchar2
800: ,p_date_of_birth in date default hr_api.g_date
801: ,p_per_information_category in varchar2 default hr_api.g_varchar2
802: ,p_per_information1 in varchar2 default hr_api.g_varchar2
803: ,p_per_information2 in varchar2 default hr_api.g_varchar2
804: ,p_per_information3 in varchar2 default hr_api.g_varchar2
805: ,p_per_information4 in varchar2 default hr_api.g_varchar2
806: ,p_per_information5 in varchar2 default hr_api.g_varchar2
807: ,p_per_information6 in varchar2 default hr_api.g_varchar2
808: ,p_per_information7 in varchar2 default hr_api.g_varchar2
801: ,p_per_information_category in varchar2 default hr_api.g_varchar2
802: ,p_per_information1 in varchar2 default hr_api.g_varchar2
803: ,p_per_information2 in varchar2 default hr_api.g_varchar2
804: ,p_per_information3 in varchar2 default hr_api.g_varchar2
805: ,p_per_information4 in varchar2 default hr_api.g_varchar2
806: ,p_per_information5 in varchar2 default hr_api.g_varchar2
807: ,p_per_information6 in varchar2 default hr_api.g_varchar2
808: ,p_per_information7 in varchar2 default hr_api.g_varchar2
809: ,p_per_information8 in varchar2 default hr_api.g_varchar2
802: ,p_per_information1 in varchar2 default hr_api.g_varchar2
803: ,p_per_information2 in varchar2 default hr_api.g_varchar2
804: ,p_per_information3 in varchar2 default hr_api.g_varchar2
805: ,p_per_information4 in varchar2 default hr_api.g_varchar2
806: ,p_per_information5 in varchar2 default hr_api.g_varchar2
807: ,p_per_information6 in varchar2 default hr_api.g_varchar2
808: ,p_per_information7 in varchar2 default hr_api.g_varchar2
809: ,p_per_information8 in varchar2 default hr_api.g_varchar2
810: ,p_per_information9 in varchar2 default hr_api.g_varchar2
803: ,p_per_information2 in varchar2 default hr_api.g_varchar2
804: ,p_per_information3 in varchar2 default hr_api.g_varchar2
805: ,p_per_information4 in varchar2 default hr_api.g_varchar2
806: ,p_per_information5 in varchar2 default hr_api.g_varchar2
807: ,p_per_information6 in varchar2 default hr_api.g_varchar2
808: ,p_per_information7 in varchar2 default hr_api.g_varchar2
809: ,p_per_information8 in varchar2 default hr_api.g_varchar2
810: ,p_per_information9 in varchar2 default hr_api.g_varchar2
811: ,p_per_information10 in varchar2 default hr_api.g_varchar2
804: ,p_per_information3 in varchar2 default hr_api.g_varchar2
805: ,p_per_information4 in varchar2 default hr_api.g_varchar2
806: ,p_per_information5 in varchar2 default hr_api.g_varchar2
807: ,p_per_information6 in varchar2 default hr_api.g_varchar2
808: ,p_per_information7 in varchar2 default hr_api.g_varchar2
809: ,p_per_information8 in varchar2 default hr_api.g_varchar2
810: ,p_per_information9 in varchar2 default hr_api.g_varchar2
811: ,p_per_information10 in varchar2 default hr_api.g_varchar2
812: ,p_per_information11 in varchar2 default hr_api.g_varchar2
805: ,p_per_information4 in varchar2 default hr_api.g_varchar2
806: ,p_per_information5 in varchar2 default hr_api.g_varchar2
807: ,p_per_information6 in varchar2 default hr_api.g_varchar2
808: ,p_per_information7 in varchar2 default hr_api.g_varchar2
809: ,p_per_information8 in varchar2 default hr_api.g_varchar2
810: ,p_per_information9 in varchar2 default hr_api.g_varchar2
811: ,p_per_information10 in varchar2 default hr_api.g_varchar2
812: ,p_per_information11 in varchar2 default hr_api.g_varchar2
813: ,p_per_information12 in varchar2 default hr_api.g_varchar2
806: ,p_per_information5 in varchar2 default hr_api.g_varchar2
807: ,p_per_information6 in varchar2 default hr_api.g_varchar2
808: ,p_per_information7 in varchar2 default hr_api.g_varchar2
809: ,p_per_information8 in varchar2 default hr_api.g_varchar2
810: ,p_per_information9 in varchar2 default hr_api.g_varchar2
811: ,p_per_information10 in varchar2 default hr_api.g_varchar2
812: ,p_per_information11 in varchar2 default hr_api.g_varchar2
813: ,p_per_information12 in varchar2 default hr_api.g_varchar2
814: ,p_per_information13 in varchar2 default hr_api.g_varchar2
807: ,p_per_information6 in varchar2 default hr_api.g_varchar2
808: ,p_per_information7 in varchar2 default hr_api.g_varchar2
809: ,p_per_information8 in varchar2 default hr_api.g_varchar2
810: ,p_per_information9 in varchar2 default hr_api.g_varchar2
811: ,p_per_information10 in varchar2 default hr_api.g_varchar2
812: ,p_per_information11 in varchar2 default hr_api.g_varchar2
813: ,p_per_information12 in varchar2 default hr_api.g_varchar2
814: ,p_per_information13 in varchar2 default hr_api.g_varchar2
815: ,p_per_information14 in varchar2 default hr_api.g_varchar2
808: ,p_per_information7 in varchar2 default hr_api.g_varchar2
809: ,p_per_information8 in varchar2 default hr_api.g_varchar2
810: ,p_per_information9 in varchar2 default hr_api.g_varchar2
811: ,p_per_information10 in varchar2 default hr_api.g_varchar2
812: ,p_per_information11 in varchar2 default hr_api.g_varchar2
813: ,p_per_information12 in varchar2 default hr_api.g_varchar2
814: ,p_per_information13 in varchar2 default hr_api.g_varchar2
815: ,p_per_information14 in varchar2 default hr_api.g_varchar2
816: ,p_per_information15 in varchar2 default hr_api.g_varchar2
809: ,p_per_information8 in varchar2 default hr_api.g_varchar2
810: ,p_per_information9 in varchar2 default hr_api.g_varchar2
811: ,p_per_information10 in varchar2 default hr_api.g_varchar2
812: ,p_per_information11 in varchar2 default hr_api.g_varchar2
813: ,p_per_information12 in varchar2 default hr_api.g_varchar2
814: ,p_per_information13 in varchar2 default hr_api.g_varchar2
815: ,p_per_information14 in varchar2 default hr_api.g_varchar2
816: ,p_per_information15 in varchar2 default hr_api.g_varchar2
817: ,p_per_information16 in varchar2 default hr_api.g_varchar2
810: ,p_per_information9 in varchar2 default hr_api.g_varchar2
811: ,p_per_information10 in varchar2 default hr_api.g_varchar2
812: ,p_per_information11 in varchar2 default hr_api.g_varchar2
813: ,p_per_information12 in varchar2 default hr_api.g_varchar2
814: ,p_per_information13 in varchar2 default hr_api.g_varchar2
815: ,p_per_information14 in varchar2 default hr_api.g_varchar2
816: ,p_per_information15 in varchar2 default hr_api.g_varchar2
817: ,p_per_information16 in varchar2 default hr_api.g_varchar2
818: ,p_per_information17 in varchar2 default hr_api.g_varchar2
811: ,p_per_information10 in varchar2 default hr_api.g_varchar2
812: ,p_per_information11 in varchar2 default hr_api.g_varchar2
813: ,p_per_information12 in varchar2 default hr_api.g_varchar2
814: ,p_per_information13 in varchar2 default hr_api.g_varchar2
815: ,p_per_information14 in varchar2 default hr_api.g_varchar2
816: ,p_per_information15 in varchar2 default hr_api.g_varchar2
817: ,p_per_information16 in varchar2 default hr_api.g_varchar2
818: ,p_per_information17 in varchar2 default hr_api.g_varchar2
819: ,p_per_information18 in varchar2 default hr_api.g_varchar2
812: ,p_per_information11 in varchar2 default hr_api.g_varchar2
813: ,p_per_information12 in varchar2 default hr_api.g_varchar2
814: ,p_per_information13 in varchar2 default hr_api.g_varchar2
815: ,p_per_information14 in varchar2 default hr_api.g_varchar2
816: ,p_per_information15 in varchar2 default hr_api.g_varchar2
817: ,p_per_information16 in varchar2 default hr_api.g_varchar2
818: ,p_per_information17 in varchar2 default hr_api.g_varchar2
819: ,p_per_information18 in varchar2 default hr_api.g_varchar2
820: ,p_per_information19 in varchar2 default hr_api.g_varchar2
813: ,p_per_information12 in varchar2 default hr_api.g_varchar2
814: ,p_per_information13 in varchar2 default hr_api.g_varchar2
815: ,p_per_information14 in varchar2 default hr_api.g_varchar2
816: ,p_per_information15 in varchar2 default hr_api.g_varchar2
817: ,p_per_information16 in varchar2 default hr_api.g_varchar2
818: ,p_per_information17 in varchar2 default hr_api.g_varchar2
819: ,p_per_information18 in varchar2 default hr_api.g_varchar2
820: ,p_per_information19 in varchar2 default hr_api.g_varchar2
821: ,p_per_information20 in varchar2 default hr_api.g_varchar2
814: ,p_per_information13 in varchar2 default hr_api.g_varchar2
815: ,p_per_information14 in varchar2 default hr_api.g_varchar2
816: ,p_per_information15 in varchar2 default hr_api.g_varchar2
817: ,p_per_information16 in varchar2 default hr_api.g_varchar2
818: ,p_per_information17 in varchar2 default hr_api.g_varchar2
819: ,p_per_information18 in varchar2 default hr_api.g_varchar2
820: ,p_per_information19 in varchar2 default hr_api.g_varchar2
821: ,p_per_information20 in varchar2 default hr_api.g_varchar2
822: ,p_per_information21 in varchar2 default hr_api.g_varchar2
815: ,p_per_information14 in varchar2 default hr_api.g_varchar2
816: ,p_per_information15 in varchar2 default hr_api.g_varchar2
817: ,p_per_information16 in varchar2 default hr_api.g_varchar2
818: ,p_per_information17 in varchar2 default hr_api.g_varchar2
819: ,p_per_information18 in varchar2 default hr_api.g_varchar2
820: ,p_per_information19 in varchar2 default hr_api.g_varchar2
821: ,p_per_information20 in varchar2 default hr_api.g_varchar2
822: ,p_per_information21 in varchar2 default hr_api.g_varchar2
823: ,p_per_information22 in varchar2 default hr_api.g_varchar2
816: ,p_per_information15 in varchar2 default hr_api.g_varchar2
817: ,p_per_information16 in varchar2 default hr_api.g_varchar2
818: ,p_per_information17 in varchar2 default hr_api.g_varchar2
819: ,p_per_information18 in varchar2 default hr_api.g_varchar2
820: ,p_per_information19 in varchar2 default hr_api.g_varchar2
821: ,p_per_information20 in varchar2 default hr_api.g_varchar2
822: ,p_per_information21 in varchar2 default hr_api.g_varchar2
823: ,p_per_information22 in varchar2 default hr_api.g_varchar2
824: ,p_per_information23 in varchar2 default hr_api.g_varchar2
817: ,p_per_information16 in varchar2 default hr_api.g_varchar2
818: ,p_per_information17 in varchar2 default hr_api.g_varchar2
819: ,p_per_information18 in varchar2 default hr_api.g_varchar2
820: ,p_per_information19 in varchar2 default hr_api.g_varchar2
821: ,p_per_information20 in varchar2 default hr_api.g_varchar2
822: ,p_per_information21 in varchar2 default hr_api.g_varchar2
823: ,p_per_information22 in varchar2 default hr_api.g_varchar2
824: ,p_per_information23 in varchar2 default hr_api.g_varchar2
825: ,p_per_information24 in varchar2 default hr_api.g_varchar2
818: ,p_per_information17 in varchar2 default hr_api.g_varchar2
819: ,p_per_information18 in varchar2 default hr_api.g_varchar2
820: ,p_per_information19 in varchar2 default hr_api.g_varchar2
821: ,p_per_information20 in varchar2 default hr_api.g_varchar2
822: ,p_per_information21 in varchar2 default hr_api.g_varchar2
823: ,p_per_information22 in varchar2 default hr_api.g_varchar2
824: ,p_per_information23 in varchar2 default hr_api.g_varchar2
825: ,p_per_information24 in varchar2 default hr_api.g_varchar2
826: ,p_per_information25 in varchar2 default hr_api.g_varchar2
819: ,p_per_information18 in varchar2 default hr_api.g_varchar2
820: ,p_per_information19 in varchar2 default hr_api.g_varchar2
821: ,p_per_information20 in varchar2 default hr_api.g_varchar2
822: ,p_per_information21 in varchar2 default hr_api.g_varchar2
823: ,p_per_information22 in varchar2 default hr_api.g_varchar2
824: ,p_per_information23 in varchar2 default hr_api.g_varchar2
825: ,p_per_information24 in varchar2 default hr_api.g_varchar2
826: ,p_per_information25 in varchar2 default hr_api.g_varchar2
827: ,p_per_information26 in varchar2 default hr_api.g_varchar2
820: ,p_per_information19 in varchar2 default hr_api.g_varchar2
821: ,p_per_information20 in varchar2 default hr_api.g_varchar2
822: ,p_per_information21 in varchar2 default hr_api.g_varchar2
823: ,p_per_information22 in varchar2 default hr_api.g_varchar2
824: ,p_per_information23 in varchar2 default hr_api.g_varchar2
825: ,p_per_information24 in varchar2 default hr_api.g_varchar2
826: ,p_per_information25 in varchar2 default hr_api.g_varchar2
827: ,p_per_information26 in varchar2 default hr_api.g_varchar2
828: ,p_per_information27 in varchar2 default hr_api.g_varchar2
821: ,p_per_information20 in varchar2 default hr_api.g_varchar2
822: ,p_per_information21 in varchar2 default hr_api.g_varchar2
823: ,p_per_information22 in varchar2 default hr_api.g_varchar2
824: ,p_per_information23 in varchar2 default hr_api.g_varchar2
825: ,p_per_information24 in varchar2 default hr_api.g_varchar2
826: ,p_per_information25 in varchar2 default hr_api.g_varchar2
827: ,p_per_information26 in varchar2 default hr_api.g_varchar2
828: ,p_per_information27 in varchar2 default hr_api.g_varchar2
829: ,p_per_information28 in varchar2 default hr_api.g_varchar2
822: ,p_per_information21 in varchar2 default hr_api.g_varchar2
823: ,p_per_information22 in varchar2 default hr_api.g_varchar2
824: ,p_per_information23 in varchar2 default hr_api.g_varchar2
825: ,p_per_information24 in varchar2 default hr_api.g_varchar2
826: ,p_per_information25 in varchar2 default hr_api.g_varchar2
827: ,p_per_information26 in varchar2 default hr_api.g_varchar2
828: ,p_per_information27 in varchar2 default hr_api.g_varchar2
829: ,p_per_information28 in varchar2 default hr_api.g_varchar2
830: ,p_per_information29 in varchar2 default hr_api.g_varchar2
823: ,p_per_information22 in varchar2 default hr_api.g_varchar2
824: ,p_per_information23 in varchar2 default hr_api.g_varchar2
825: ,p_per_information24 in varchar2 default hr_api.g_varchar2
826: ,p_per_information25 in varchar2 default hr_api.g_varchar2
827: ,p_per_information26 in varchar2 default hr_api.g_varchar2
828: ,p_per_information27 in varchar2 default hr_api.g_varchar2
829: ,p_per_information28 in varchar2 default hr_api.g_varchar2
830: ,p_per_information29 in varchar2 default hr_api.g_varchar2
831: ,p_per_information30 in varchar2 default hr_api.g_varchar2
824: ,p_per_information23 in varchar2 default hr_api.g_varchar2
825: ,p_per_information24 in varchar2 default hr_api.g_varchar2
826: ,p_per_information25 in varchar2 default hr_api.g_varchar2
827: ,p_per_information26 in varchar2 default hr_api.g_varchar2
828: ,p_per_information27 in varchar2 default hr_api.g_varchar2
829: ,p_per_information28 in varchar2 default hr_api.g_varchar2
830: ,p_per_information29 in varchar2 default hr_api.g_varchar2
831: ,p_per_information30 in varchar2 default hr_api.g_varchar2
832: ,p_error_message in varchar2 default hr_api.g_varchar2
825: ,p_per_information24 in varchar2 default hr_api.g_varchar2
826: ,p_per_information25 in varchar2 default hr_api.g_varchar2
827: ,p_per_information26 in varchar2 default hr_api.g_varchar2
828: ,p_per_information27 in varchar2 default hr_api.g_varchar2
829: ,p_per_information28 in varchar2 default hr_api.g_varchar2
830: ,p_per_information29 in varchar2 default hr_api.g_varchar2
831: ,p_per_information30 in varchar2 default hr_api.g_varchar2
832: ,p_error_message in varchar2 default hr_api.g_varchar2
833: ,p_last_update_date in date default hr_api.g_date
826: ,p_per_information25 in varchar2 default hr_api.g_varchar2
827: ,p_per_information26 in varchar2 default hr_api.g_varchar2
828: ,p_per_information27 in varchar2 default hr_api.g_varchar2
829: ,p_per_information28 in varchar2 default hr_api.g_varchar2
830: ,p_per_information29 in varchar2 default hr_api.g_varchar2
831: ,p_per_information30 in varchar2 default hr_api.g_varchar2
832: ,p_error_message in varchar2 default hr_api.g_varchar2
833: ,p_last_update_date in date default hr_api.g_date
834: ,p_allow_access in varchar2 default hr_api.g_varchar2
827: ,p_per_information26 in varchar2 default hr_api.g_varchar2
828: ,p_per_information27 in varchar2 default hr_api.g_varchar2
829: ,p_per_information28 in varchar2 default hr_api.g_varchar2
830: ,p_per_information29 in varchar2 default hr_api.g_varchar2
831: ,p_per_information30 in varchar2 default hr_api.g_varchar2
832: ,p_error_message in varchar2 default hr_api.g_varchar2
833: ,p_last_update_date in date default hr_api.g_date
834: ,p_allow_access in varchar2 default hr_api.g_varchar2
835: ,p_user_guid in raw default NULL
828: ,p_per_information27 in varchar2 default hr_api.g_varchar2
829: ,p_per_information28 in varchar2 default hr_api.g_varchar2
830: ,p_per_information29 in varchar2 default hr_api.g_varchar2
831: ,p_per_information30 in varchar2 default hr_api.g_varchar2
832: ,p_error_message in varchar2 default hr_api.g_varchar2
833: ,p_last_update_date in date default hr_api.g_date
834: ,p_allow_access in varchar2 default hr_api.g_varchar2
835: ,p_user_guid in raw default NULL
836: ,p_visitor_resp_key in varchar2 default hr_api.g_varchar2
829: ,p_per_information28 in varchar2 default hr_api.g_varchar2
830: ,p_per_information29 in varchar2 default hr_api.g_varchar2
831: ,p_per_information30 in varchar2 default hr_api.g_varchar2
832: ,p_error_message in varchar2 default hr_api.g_varchar2
833: ,p_last_update_date in date default hr_api.g_date
834: ,p_allow_access in varchar2 default hr_api.g_varchar2
835: ,p_user_guid in raw default NULL
836: ,p_visitor_resp_key in varchar2 default hr_api.g_varchar2
837: ,p_visitor_resp_appl_id in number default hr_api.g_number
830: ,p_per_information29 in varchar2 default hr_api.g_varchar2
831: ,p_per_information30 in varchar2 default hr_api.g_varchar2
832: ,p_error_message in varchar2 default hr_api.g_varchar2
833: ,p_last_update_date in date default hr_api.g_date
834: ,p_allow_access in varchar2 default hr_api.g_varchar2
835: ,p_user_guid in raw default NULL
836: ,p_visitor_resp_key in varchar2 default hr_api.g_varchar2
837: ,p_visitor_resp_appl_id in number default hr_api.g_number
838: ,p_security_group_key in varchar2 default hr_api.g_varchar2
832: ,p_error_message in varchar2 default hr_api.g_varchar2
833: ,p_last_update_date in date default hr_api.g_date
834: ,p_allow_access in varchar2 default hr_api.g_varchar2
835: ,p_user_guid in raw default NULL
836: ,p_visitor_resp_key in varchar2 default hr_api.g_varchar2
837: ,p_visitor_resp_appl_id in number default hr_api.g_number
838: ,p_security_group_key in varchar2 default hr_api.g_varchar2
839: ) is
840: --
833: ,p_last_update_date in date default hr_api.g_date
834: ,p_allow_access in varchar2 default hr_api.g_varchar2
835: ,p_user_guid in raw default NULL
836: ,p_visitor_resp_key in varchar2 default hr_api.g_varchar2
837: ,p_visitor_resp_appl_id in number default hr_api.g_number
838: ,p_security_group_key in varchar2 default hr_api.g_varchar2
839: ) is
840: --
841: l_rec irc_ipd_shd.g_rec_type;
834: ,p_allow_access in varchar2 default hr_api.g_varchar2
835: ,p_user_guid in raw default NULL
836: ,p_visitor_resp_key in varchar2 default hr_api.g_varchar2
837: ,p_visitor_resp_appl_id in number default hr_api.g_number
838: ,p_security_group_key in varchar2 default hr_api.g_varchar2
839: ) is
840: --
841: l_rec irc_ipd_shd.g_rec_type;
842: l_proc varchar2(72) := g_package||'upd';
850: l_rec :=
851: irc_ipd_shd.convert_args
852: (p_pending_data_id
853: ,p_email_address
854: ,hr_api.g_number
855: ,p_last_name
856: ,p_first_name
857: ,p_user_password
858: ,p_resume_file_name
896: ,p_per_information28
897: ,p_per_information29
898: ,p_per_information30
899: ,p_error_message
900: ,hr_api.g_date
901: ,p_last_update_date
902: ,p_allow_access
903: ,p_user_guid
904: ,p_visitor_resp_key