eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IRC_IPD_UPD dependencies on HR_API

Line 130: When hr_api.check_integrity_violated Then

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));

Line 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

Line 135: When hr_api.parent_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
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 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

Line 140: When hr_api.unique_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
144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 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;

Line 451: when hr_api.cannot_find_prog_unit then

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');

Line 453: hr_api.cannot_find_prog_unit_error

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;

Line 516: If (p_rec.email_address = hr_api.g_varchar2) then

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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 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

Line 717: If (p_rec.visitor_resp_key = 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
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

Line 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

Line 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: --

Line 787: ,p_email_address in varchar2 default hr_api.g_varchar2

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

Line 788: ,p_last_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

Line 789: ,p_first_name 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

Line 790: ,p_user_password 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

Line 791: ,p_resume_file_name 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

Line 792: ,p_resume_description 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

Line 793: ,p_resume_mime_type 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
797: ,p_person_id in number default hr_api.g_number

Line 794: ,p_source_type 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
798: ,p_processed in varchar2 default hr_api.g_varchar2

Line 795: ,p_job_post_source_name 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

Line 796: ,p_posting_content_id in number default hr_api.g_number

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

Line 797: ,p_person_id in number default hr_api.g_number

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

Line 798: ,p_processed 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

Line 799: ,p_sex 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

Line 800: ,p_date_of_birth in date default hr_api.g_date

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

Line 801: ,p_per_information_category 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

Line 802: ,p_per_information1 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

Line 803: ,p_per_information2 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

Line 804: ,p_per_information3 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

Line 805: ,p_per_information4 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

Line 806: ,p_per_information5 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

Line 807: ,p_per_information6 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

Line 808: ,p_per_information7 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

Line 809: ,p_per_information8 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

Line 810: ,p_per_information9 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

Line 811: ,p_per_information10 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

Line 812: ,p_per_information11 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

Line 813: ,p_per_information12 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

Line 814: ,p_per_information13 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

Line 815: ,p_per_information14 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

Line 816: ,p_per_information15 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

Line 817: ,p_per_information16 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

Line 818: ,p_per_information17 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

Line 819: ,p_per_information18 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

Line 820: ,p_per_information19 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

Line 821: ,p_per_information20 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

Line 822: ,p_per_information21 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

Line 823: ,p_per_information22 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

Line 824: ,p_per_information23 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

Line 825: ,p_per_information24 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

Line 826: ,p_per_information25 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

Line 827: ,p_per_information26 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

Line 828: ,p_per_information27 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

Line 829: ,p_per_information28 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

Line 830: ,p_per_information29 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
834: ,p_allow_access in varchar2 default hr_api.g_varchar2

Line 831: ,p_per_information30 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

Line 832: ,p_error_message 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
836: ,p_visitor_resp_key in varchar2 default hr_api.g_varchar2

Line 833: ,p_last_update_date in date default hr_api.g_date

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

Line 834: ,p_allow_access 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
838: ,p_security_group_key in varchar2 default hr_api.g_varchar2

Line 836: ,p_visitor_resp_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: --

Line 837: ,p_visitor_resp_appl_id in number default hr_api.g_number

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;

Line 838: ,p_security_group_key in varchar2 default hr_api.g_varchar2

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';

Line 854: ,hr_api.g_number

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

Line 900: ,hr_api.g_date

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