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_IRF_UPD dependencies on HR_API

Line 70: If (p_datetrack_mode = hr_api.g_correction) then

66: --
67: Begin
68: hr_utility.set_location('Entering:'||l_proc, 5);
69: --
70: If (p_datetrack_mode = hr_api.g_correction) then
71: hr_utility.set_location(l_proc, 10);
72: --
73: -- Because we are updating a row we must get the next object
74: -- version number.

Line 144: When hr_api.check_integrity_violated Then

140: End If;
141: --
142: hr_utility.set_location(' Leaving:'||l_proc, 15);
143: Exception
144: When hr_api.check_integrity_violated Then
145: -- A check constraint has been violated
146: --
147: irc_irf_shd.constraint_error
148: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 148: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

144: When hr_api.check_integrity_violated Then
145: -- A check constraint has been violated
146: --
147: irc_irf_shd.constraint_error
148: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
149: When hr_api.unique_integrity_violated Then
150: -- Unique integrity has been violated
151: --
152: irc_irf_shd.constraint_error

Line 149: When hr_api.unique_integrity_violated Then

145: -- A check constraint has been violated
146: --
147: irc_irf_shd.constraint_error
148: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
149: When hr_api.unique_integrity_violated Then
150: -- Unique integrity has been violated
151: --
152: irc_irf_shd.constraint_error
153: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 153: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

149: When hr_api.unique_integrity_violated Then
150: -- Unique integrity has been violated
151: --
152: irc_irf_shd.constraint_error
153: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
154: When Others Then
155: --
156: Raise;
157: End dt_update_dml;

Line 270: If (p_datetrack_mode <> hr_api.g_correction) then

266: l_dummy_version_number number;
267: --
268: Begin
269: hr_utility.set_location('Entering:'||l_proc, 5);
270: If (p_datetrack_mode <> hr_api.g_correction) then
271: --
272: -- Update the current effective end date
273: --
274: irc_irf_shd.upd_end_date

Line 281: If (p_datetrack_mode = hr_api.g_update_override) then

277: ,p_new_end_date => p_validation_start_date
278: ,p_object_version_number => l_dummy_version_number
279: );
280: --
281: If (p_datetrack_mode = hr_api.g_update_override) then
282: --
283: -- As the datetrack mode is 'UPDATE_OVERRIDE' then we must
284: -- delete any future rows
285: --

Line 506: when hr_api.cannot_find_prog_unit then

502: );
503: --
504: exception
505: --
506: when hr_api.cannot_find_prog_unit then
507: --
508: hr_api.cannot_find_prog_unit_error
509: (p_module_name => 'IRC_REFERRAL_INFO'
510: ,p_hook_type => 'AU');

Line 508: hr_api.cannot_find_prog_unit_error

504: exception
505: --
506: when hr_api.cannot_find_prog_unit then
507: --
508: hr_api.cannot_find_prog_unit_error
509: (p_module_name => 'IRC_REFERRAL_INFO'
510: ,p_hook_type => 'AU');
511: --
512: end;

Line 571: If (p_rec.object_id = hr_api.g_number) then

567: -- p_rec plsql record structure
568: -- to see if a system default is being used. If a system default
569: -- is being used then we must set to the 'current' argument value.
570: --
571: If (p_rec.object_id = hr_api.g_number) then
572: p_rec.object_id :=
573: irc_irf_shd.g_old_rec.object_id;
574: End If;
575: If (p_rec.object_type = hr_api.g_varchar2) then

Line 575: If (p_rec.object_type = hr_api.g_varchar2) then

571: If (p_rec.object_id = hr_api.g_number) then
572: p_rec.object_id :=
573: irc_irf_shd.g_old_rec.object_id;
574: End If;
575: If (p_rec.object_type = hr_api.g_varchar2) then
576: p_rec.object_type :=
577: irc_irf_shd.g_old_rec.object_type;
578: End If;
579: If (p_rec.start_date = hr_api.g_date) then

Line 579: If (p_rec.start_date = hr_api.g_date) then

575: If (p_rec.object_type = hr_api.g_varchar2) then
576: p_rec.object_type :=
577: irc_irf_shd.g_old_rec.object_type;
578: End If;
579: If (p_rec.start_date = hr_api.g_date) then
580: p_rec.start_date :=
581: irc_irf_shd.g_old_rec.start_date;
582: End If;
583: If (p_rec.end_date = hr_api.g_date) then

Line 583: If (p_rec.end_date = hr_api.g_date) then

579: If (p_rec.start_date = hr_api.g_date) then
580: p_rec.start_date :=
581: irc_irf_shd.g_old_rec.start_date;
582: End If;
583: If (p_rec.end_date = hr_api.g_date) then
584: p_rec.end_date :=
585: irc_irf_shd.g_old_rec.end_date;
586: End If;
587: If (p_rec.source_type = hr_api.g_varchar2) then

Line 587: If (p_rec.source_type = hr_api.g_varchar2) then

583: If (p_rec.end_date = hr_api.g_date) then
584: p_rec.end_date :=
585: irc_irf_shd.g_old_rec.end_date;
586: End If;
587: If (p_rec.source_type = hr_api.g_varchar2) then
588: p_rec.source_type :=
589: irc_irf_shd.g_old_rec.source_type;
590: End If;
591: If (p_rec.source_name = hr_api.g_varchar2) then

Line 591: If (p_rec.source_name = hr_api.g_varchar2) then

587: If (p_rec.source_type = hr_api.g_varchar2) then
588: p_rec.source_type :=
589: irc_irf_shd.g_old_rec.source_type;
590: End If;
591: If (p_rec.source_name = hr_api.g_varchar2) then
592: p_rec.source_name :=
593: irc_irf_shd.g_old_rec.source_name;
594: End If;
595: If (p_rec.source_criteria1 = hr_api.g_varchar2) then

Line 595: If (p_rec.source_criteria1 = hr_api.g_varchar2) then

591: If (p_rec.source_name = hr_api.g_varchar2) then
592: p_rec.source_name :=
593: irc_irf_shd.g_old_rec.source_name;
594: End If;
595: If (p_rec.source_criteria1 = hr_api.g_varchar2) then
596: p_rec.source_criteria1 :=
597: irc_irf_shd.g_old_rec.source_criteria1;
598: End If;
599: If (p_rec.source_value1 = hr_api.g_varchar2) then

Line 599: If (p_rec.source_value1 = hr_api.g_varchar2) then

595: If (p_rec.source_criteria1 = hr_api.g_varchar2) then
596: p_rec.source_criteria1 :=
597: irc_irf_shd.g_old_rec.source_criteria1;
598: End If;
599: If (p_rec.source_value1 = hr_api.g_varchar2) then
600: p_rec.source_value1 :=
601: irc_irf_shd.g_old_rec.source_value1;
602: End If;
603: If (p_rec.source_criteria2 = hr_api.g_varchar2) then

Line 603: If (p_rec.source_criteria2 = hr_api.g_varchar2) then

599: If (p_rec.source_value1 = hr_api.g_varchar2) then
600: p_rec.source_value1 :=
601: irc_irf_shd.g_old_rec.source_value1;
602: End If;
603: If (p_rec.source_criteria2 = hr_api.g_varchar2) then
604: p_rec.source_criteria2 :=
605: irc_irf_shd.g_old_rec.source_criteria2;
606: End If;
607: If (p_rec.source_value2 = hr_api.g_varchar2) then

Line 607: If (p_rec.source_value2 = hr_api.g_varchar2) then

603: If (p_rec.source_criteria2 = hr_api.g_varchar2) then
604: p_rec.source_criteria2 :=
605: irc_irf_shd.g_old_rec.source_criteria2;
606: End If;
607: If (p_rec.source_value2 = hr_api.g_varchar2) then
608: p_rec.source_value2 :=
609: irc_irf_shd.g_old_rec.source_value2;
610: End If;
611: If (p_rec.source_criteria3 = hr_api.g_varchar2) then

Line 611: If (p_rec.source_criteria3 = hr_api.g_varchar2) then

607: If (p_rec.source_value2 = hr_api.g_varchar2) then
608: p_rec.source_value2 :=
609: irc_irf_shd.g_old_rec.source_value2;
610: End If;
611: If (p_rec.source_criteria3 = hr_api.g_varchar2) then
612: p_rec.source_criteria3 :=
613: irc_irf_shd.g_old_rec.source_criteria3;
614: End If;
615: If (p_rec.source_value3 = hr_api.g_varchar2) then

Line 615: If (p_rec.source_value3 = hr_api.g_varchar2) then

611: If (p_rec.source_criteria3 = hr_api.g_varchar2) then
612: p_rec.source_criteria3 :=
613: irc_irf_shd.g_old_rec.source_criteria3;
614: End If;
615: If (p_rec.source_value3 = hr_api.g_varchar2) then
616: p_rec.source_value3 :=
617: irc_irf_shd.g_old_rec.source_value3;
618: End If;
619: If (p_rec.source_criteria4 = hr_api.g_varchar2) then

Line 619: If (p_rec.source_criteria4 = hr_api.g_varchar2) then

615: If (p_rec.source_value3 = hr_api.g_varchar2) then
616: p_rec.source_value3 :=
617: irc_irf_shd.g_old_rec.source_value3;
618: End If;
619: If (p_rec.source_criteria4 = hr_api.g_varchar2) then
620: p_rec.source_criteria4 :=
621: irc_irf_shd.g_old_rec.source_criteria4;
622: End If;
623: If (p_rec.source_value4 = hr_api.g_varchar2) then

Line 623: If (p_rec.source_value4 = hr_api.g_varchar2) then

619: If (p_rec.source_criteria4 = hr_api.g_varchar2) then
620: p_rec.source_criteria4 :=
621: irc_irf_shd.g_old_rec.source_criteria4;
622: End If;
623: If (p_rec.source_value4 = hr_api.g_varchar2) then
624: p_rec.source_value4 :=
625: irc_irf_shd.g_old_rec.source_value4;
626: End If;
627: If (p_rec.source_criteria5 = hr_api.g_varchar2) then

Line 627: If (p_rec.source_criteria5 = hr_api.g_varchar2) then

623: If (p_rec.source_value4 = hr_api.g_varchar2) then
624: p_rec.source_value4 :=
625: irc_irf_shd.g_old_rec.source_value4;
626: End If;
627: If (p_rec.source_criteria5 = hr_api.g_varchar2) then
628: p_rec.source_criteria5 :=
629: irc_irf_shd.g_old_rec.source_criteria5;
630: End If;
631: If (p_rec.source_value5 = hr_api.g_varchar2) then

Line 631: If (p_rec.source_value5 = hr_api.g_varchar2) then

627: If (p_rec.source_criteria5 = hr_api.g_varchar2) then
628: p_rec.source_criteria5 :=
629: irc_irf_shd.g_old_rec.source_criteria5;
630: End If;
631: If (p_rec.source_value5 = hr_api.g_varchar2) then
632: p_rec.source_value5 :=
633: irc_irf_shd.g_old_rec.source_value5;
634: End If;
635: If (p_rec.source_person_id = hr_api.g_number) then

Line 635: If (p_rec.source_person_id = hr_api.g_number) then

631: If (p_rec.source_value5 = hr_api.g_varchar2) then
632: p_rec.source_value5 :=
633: irc_irf_shd.g_old_rec.source_value5;
634: End If;
635: If (p_rec.source_person_id = hr_api.g_number) then
636: p_rec.source_person_id :=
637: irc_irf_shd.g_old_rec.source_person_id;
638: End If;
639: If (p_rec.candidate_comment = hr_api.g_varchar2) then

Line 639: If (p_rec.candidate_comment = hr_api.g_varchar2) then

635: If (p_rec.source_person_id = hr_api.g_number) then
636: p_rec.source_person_id :=
637: irc_irf_shd.g_old_rec.source_person_id;
638: End If;
639: If (p_rec.candidate_comment = hr_api.g_varchar2) then
640: p_rec.candidate_comment :=
641: irc_irf_shd.g_old_rec.candidate_comment;
642: End If;
643: If (p_rec.employee_comment = hr_api.g_varchar2) then

Line 643: If (p_rec.employee_comment = hr_api.g_varchar2) then

639: If (p_rec.candidate_comment = hr_api.g_varchar2) then
640: p_rec.candidate_comment :=
641: irc_irf_shd.g_old_rec.candidate_comment;
642: End If;
643: If (p_rec.employee_comment = hr_api.g_varchar2) then
644: p_rec.employee_comment :=
645: irc_irf_shd.g_old_rec.employee_comment;
646: End If;
647: If (p_rec.irf_attribute_category = hr_api.g_varchar2) then

Line 647: If (p_rec.irf_attribute_category = hr_api.g_varchar2) then

643: If (p_rec.employee_comment = hr_api.g_varchar2) then
644: p_rec.employee_comment :=
645: irc_irf_shd.g_old_rec.employee_comment;
646: End If;
647: If (p_rec.irf_attribute_category = hr_api.g_varchar2) then
648: p_rec.irf_attribute_category :=
649: irc_irf_shd.g_old_rec.irf_attribute_category;
650: End If;
651: If (p_rec.irf_attribute1 = hr_api.g_varchar2) then

Line 651: If (p_rec.irf_attribute1 = hr_api.g_varchar2) then

647: If (p_rec.irf_attribute_category = hr_api.g_varchar2) then
648: p_rec.irf_attribute_category :=
649: irc_irf_shd.g_old_rec.irf_attribute_category;
650: End If;
651: If (p_rec.irf_attribute1 = hr_api.g_varchar2) then
652: p_rec.irf_attribute1 :=
653: irc_irf_shd.g_old_rec.irf_attribute1;
654: End If;
655: If (p_rec.irf_attribute2 = hr_api.g_varchar2) then

Line 655: If (p_rec.irf_attribute2 = hr_api.g_varchar2) then

651: If (p_rec.irf_attribute1 = hr_api.g_varchar2) then
652: p_rec.irf_attribute1 :=
653: irc_irf_shd.g_old_rec.irf_attribute1;
654: End If;
655: If (p_rec.irf_attribute2 = hr_api.g_varchar2) then
656: p_rec.irf_attribute2 :=
657: irc_irf_shd.g_old_rec.irf_attribute2;
658: End If;
659: If (p_rec.irf_attribute3 = hr_api.g_varchar2) then

Line 659: If (p_rec.irf_attribute3 = hr_api.g_varchar2) then

655: If (p_rec.irf_attribute2 = hr_api.g_varchar2) then
656: p_rec.irf_attribute2 :=
657: irc_irf_shd.g_old_rec.irf_attribute2;
658: End If;
659: If (p_rec.irf_attribute3 = hr_api.g_varchar2) then
660: p_rec.irf_attribute3 :=
661: irc_irf_shd.g_old_rec.irf_attribute3;
662: End If;
663: If (p_rec.irf_attribute4 = hr_api.g_varchar2) then

Line 663: If (p_rec.irf_attribute4 = hr_api.g_varchar2) then

659: If (p_rec.irf_attribute3 = hr_api.g_varchar2) then
660: p_rec.irf_attribute3 :=
661: irc_irf_shd.g_old_rec.irf_attribute3;
662: End If;
663: If (p_rec.irf_attribute4 = hr_api.g_varchar2) then
664: p_rec.irf_attribute4 :=
665: irc_irf_shd.g_old_rec.irf_attribute4;
666: End If;
667: If (p_rec.irf_attribute5 = hr_api.g_varchar2) then

Line 667: If (p_rec.irf_attribute5 = hr_api.g_varchar2) then

663: If (p_rec.irf_attribute4 = hr_api.g_varchar2) then
664: p_rec.irf_attribute4 :=
665: irc_irf_shd.g_old_rec.irf_attribute4;
666: End If;
667: If (p_rec.irf_attribute5 = hr_api.g_varchar2) then
668: p_rec.irf_attribute5 :=
669: irc_irf_shd.g_old_rec.irf_attribute5;
670: End If;
671: If (p_rec.irf_attribute6 = hr_api.g_varchar2) then

Line 671: If (p_rec.irf_attribute6 = hr_api.g_varchar2) then

667: If (p_rec.irf_attribute5 = hr_api.g_varchar2) then
668: p_rec.irf_attribute5 :=
669: irc_irf_shd.g_old_rec.irf_attribute5;
670: End If;
671: If (p_rec.irf_attribute6 = hr_api.g_varchar2) then
672: p_rec.irf_attribute6 :=
673: irc_irf_shd.g_old_rec.irf_attribute6;
674: End If;
675: If (p_rec.irf_attribute7 = hr_api.g_varchar2) then

Line 675: If (p_rec.irf_attribute7 = hr_api.g_varchar2) then

671: If (p_rec.irf_attribute6 = hr_api.g_varchar2) then
672: p_rec.irf_attribute6 :=
673: irc_irf_shd.g_old_rec.irf_attribute6;
674: End If;
675: If (p_rec.irf_attribute7 = hr_api.g_varchar2) then
676: p_rec.irf_attribute7 :=
677: irc_irf_shd.g_old_rec.irf_attribute7;
678: End If;
679: If (p_rec.irf_attribute8 = hr_api.g_varchar2) then

Line 679: If (p_rec.irf_attribute8 = hr_api.g_varchar2) then

675: If (p_rec.irf_attribute7 = hr_api.g_varchar2) then
676: p_rec.irf_attribute7 :=
677: irc_irf_shd.g_old_rec.irf_attribute7;
678: End If;
679: If (p_rec.irf_attribute8 = hr_api.g_varchar2) then
680: p_rec.irf_attribute8 :=
681: irc_irf_shd.g_old_rec.irf_attribute8;
682: End If;
683: If (p_rec.irf_attribute9 = hr_api.g_varchar2) then

Line 683: If (p_rec.irf_attribute9 = hr_api.g_varchar2) then

679: If (p_rec.irf_attribute8 = hr_api.g_varchar2) then
680: p_rec.irf_attribute8 :=
681: irc_irf_shd.g_old_rec.irf_attribute8;
682: End If;
683: If (p_rec.irf_attribute9 = hr_api.g_varchar2) then
684: p_rec.irf_attribute9 :=
685: irc_irf_shd.g_old_rec.irf_attribute9;
686: End If;
687: If (p_rec.irf_attribute10 = hr_api.g_varchar2) then

Line 687: If (p_rec.irf_attribute10 = hr_api.g_varchar2) then

683: If (p_rec.irf_attribute9 = hr_api.g_varchar2) then
684: p_rec.irf_attribute9 :=
685: irc_irf_shd.g_old_rec.irf_attribute9;
686: End If;
687: If (p_rec.irf_attribute10 = hr_api.g_varchar2) then
688: p_rec.irf_attribute10 :=
689: irc_irf_shd.g_old_rec.irf_attribute10;
690: End If;
691: If (p_rec.irf_information_category = hr_api.g_varchar2) then

Line 691: If (p_rec.irf_information_category = hr_api.g_varchar2) then

687: If (p_rec.irf_attribute10 = hr_api.g_varchar2) then
688: p_rec.irf_attribute10 :=
689: irc_irf_shd.g_old_rec.irf_attribute10;
690: End If;
691: If (p_rec.irf_information_category = hr_api.g_varchar2) then
692: p_rec.irf_information_category :=
693: irc_irf_shd.g_old_rec.irf_information_category;
694: End If;
695: If (p_rec.irf_information1 = hr_api.g_varchar2) then

Line 695: If (p_rec.irf_information1 = hr_api.g_varchar2) then

691: If (p_rec.irf_information_category = hr_api.g_varchar2) then
692: p_rec.irf_information_category :=
693: irc_irf_shd.g_old_rec.irf_information_category;
694: End If;
695: If (p_rec.irf_information1 = hr_api.g_varchar2) then
696: p_rec.irf_information1 :=
697: irc_irf_shd.g_old_rec.irf_information1;
698: End If;
699: If (p_rec.irf_information2 = hr_api.g_varchar2) then

Line 699: If (p_rec.irf_information2 = hr_api.g_varchar2) then

695: If (p_rec.irf_information1 = hr_api.g_varchar2) then
696: p_rec.irf_information1 :=
697: irc_irf_shd.g_old_rec.irf_information1;
698: End If;
699: If (p_rec.irf_information2 = hr_api.g_varchar2) then
700: p_rec.irf_information2 :=
701: irc_irf_shd.g_old_rec.irf_information2;
702: End If;
703: If (p_rec.irf_information3 = hr_api.g_varchar2) then

Line 703: If (p_rec.irf_information3 = hr_api.g_varchar2) then

699: If (p_rec.irf_information2 = hr_api.g_varchar2) then
700: p_rec.irf_information2 :=
701: irc_irf_shd.g_old_rec.irf_information2;
702: End If;
703: If (p_rec.irf_information3 = hr_api.g_varchar2) then
704: p_rec.irf_information3 :=
705: irc_irf_shd.g_old_rec.irf_information3;
706: End If;
707: If (p_rec.irf_information4 = hr_api.g_varchar2) then

Line 707: If (p_rec.irf_information4 = hr_api.g_varchar2) then

703: If (p_rec.irf_information3 = hr_api.g_varchar2) then
704: p_rec.irf_information3 :=
705: irc_irf_shd.g_old_rec.irf_information3;
706: End If;
707: If (p_rec.irf_information4 = hr_api.g_varchar2) then
708: p_rec.irf_information4 :=
709: irc_irf_shd.g_old_rec.irf_information4;
710: End If;
711: If (p_rec.irf_information5 = hr_api.g_varchar2) then

Line 711: If (p_rec.irf_information5 = hr_api.g_varchar2) then

707: If (p_rec.irf_information4 = hr_api.g_varchar2) then
708: p_rec.irf_information4 :=
709: irc_irf_shd.g_old_rec.irf_information4;
710: End If;
711: If (p_rec.irf_information5 = hr_api.g_varchar2) then
712: p_rec.irf_information5 :=
713: irc_irf_shd.g_old_rec.irf_information5;
714: End If;
715: If (p_rec.irf_information6 = hr_api.g_varchar2) then

Line 715: If (p_rec.irf_information6 = hr_api.g_varchar2) then

711: If (p_rec.irf_information5 = hr_api.g_varchar2) then
712: p_rec.irf_information5 :=
713: irc_irf_shd.g_old_rec.irf_information5;
714: End If;
715: If (p_rec.irf_information6 = hr_api.g_varchar2) then
716: p_rec.irf_information6 :=
717: irc_irf_shd.g_old_rec.irf_information6;
718: End If;
719: If (p_rec.irf_information7 = hr_api.g_varchar2) then

Line 719: If (p_rec.irf_information7 = hr_api.g_varchar2) then

715: If (p_rec.irf_information6 = hr_api.g_varchar2) then
716: p_rec.irf_information6 :=
717: irc_irf_shd.g_old_rec.irf_information6;
718: End If;
719: If (p_rec.irf_information7 = hr_api.g_varchar2) then
720: p_rec.irf_information7 :=
721: irc_irf_shd.g_old_rec.irf_information7;
722: End If;
723: If (p_rec.irf_information8 = hr_api.g_varchar2) then

Line 723: If (p_rec.irf_information8 = hr_api.g_varchar2) then

719: If (p_rec.irf_information7 = hr_api.g_varchar2) then
720: p_rec.irf_information7 :=
721: irc_irf_shd.g_old_rec.irf_information7;
722: End If;
723: If (p_rec.irf_information8 = hr_api.g_varchar2) then
724: p_rec.irf_information8 :=
725: irc_irf_shd.g_old_rec.irf_information8;
726: End If;
727: If (p_rec.irf_information9 = hr_api.g_varchar2) then

Line 727: If (p_rec.irf_information9 = hr_api.g_varchar2) then

723: If (p_rec.irf_information8 = hr_api.g_varchar2) then
724: p_rec.irf_information8 :=
725: irc_irf_shd.g_old_rec.irf_information8;
726: End If;
727: If (p_rec.irf_information9 = hr_api.g_varchar2) then
728: p_rec.irf_information9 :=
729: irc_irf_shd.g_old_rec.irf_information9;
730: End If;
731: If (p_rec.irf_information10 = hr_api.g_varchar2) then

Line 731: If (p_rec.irf_information10 = hr_api.g_varchar2) then

727: If (p_rec.irf_information9 = hr_api.g_varchar2) then
728: p_rec.irf_information9 :=
729: irc_irf_shd.g_old_rec.irf_information9;
730: End If;
731: If (p_rec.irf_information10 = hr_api.g_varchar2) then
732: p_rec.irf_information10 :=
733: irc_irf_shd.g_old_rec.irf_information10;
734: End If;
735: If (p_rec.object_created_by = hr_api.g_varchar2) then

Line 735: If (p_rec.object_created_by = hr_api.g_varchar2) then

731: If (p_rec.irf_information10 = hr_api.g_varchar2) then
732: p_rec.irf_information10 :=
733: irc_irf_shd.g_old_rec.irf_information10;
734: End If;
735: If (p_rec.object_created_by = hr_api.g_varchar2) then
736: p_rec.object_created_by :=
737: irc_irf_shd.g_old_rec.object_created_by;
738: End If;
739: --

Line 834: ,p_source_type in varchar2 default hr_api.g_varchar2

830: (p_effective_date in date
831: ,p_datetrack_mode in varchar2
832: ,p_referral_info_id in number
833: ,p_object_version_number in out nocopy number
834: ,p_source_type in varchar2 default hr_api.g_varchar2
835: ,p_source_name in varchar2 default hr_api.g_varchar2
836: ,p_source_criteria1 in varchar2 default hr_api.g_varchar2
837: ,p_source_value1 in varchar2 default hr_api.g_varchar2
838: ,p_source_criteria2 in varchar2 default hr_api.g_varchar2

Line 835: ,p_source_name in varchar2 default hr_api.g_varchar2

831: ,p_datetrack_mode in varchar2
832: ,p_referral_info_id in number
833: ,p_object_version_number in out nocopy number
834: ,p_source_type in varchar2 default hr_api.g_varchar2
835: ,p_source_name in varchar2 default hr_api.g_varchar2
836: ,p_source_criteria1 in varchar2 default hr_api.g_varchar2
837: ,p_source_value1 in varchar2 default hr_api.g_varchar2
838: ,p_source_criteria2 in varchar2 default hr_api.g_varchar2
839: ,p_source_value2 in varchar2 default hr_api.g_varchar2

Line 836: ,p_source_criteria1 in varchar2 default hr_api.g_varchar2

832: ,p_referral_info_id in number
833: ,p_object_version_number in out nocopy number
834: ,p_source_type in varchar2 default hr_api.g_varchar2
835: ,p_source_name in varchar2 default hr_api.g_varchar2
836: ,p_source_criteria1 in varchar2 default hr_api.g_varchar2
837: ,p_source_value1 in varchar2 default hr_api.g_varchar2
838: ,p_source_criteria2 in varchar2 default hr_api.g_varchar2
839: ,p_source_value2 in varchar2 default hr_api.g_varchar2
840: ,p_source_criteria3 in varchar2 default hr_api.g_varchar2

Line 837: ,p_source_value1 in varchar2 default hr_api.g_varchar2

833: ,p_object_version_number in out nocopy number
834: ,p_source_type in varchar2 default hr_api.g_varchar2
835: ,p_source_name in varchar2 default hr_api.g_varchar2
836: ,p_source_criteria1 in varchar2 default hr_api.g_varchar2
837: ,p_source_value1 in varchar2 default hr_api.g_varchar2
838: ,p_source_criteria2 in varchar2 default hr_api.g_varchar2
839: ,p_source_value2 in varchar2 default hr_api.g_varchar2
840: ,p_source_criteria3 in varchar2 default hr_api.g_varchar2
841: ,p_source_value3 in varchar2 default hr_api.g_varchar2

Line 838: ,p_source_criteria2 in varchar2 default hr_api.g_varchar2

834: ,p_source_type in varchar2 default hr_api.g_varchar2
835: ,p_source_name in varchar2 default hr_api.g_varchar2
836: ,p_source_criteria1 in varchar2 default hr_api.g_varchar2
837: ,p_source_value1 in varchar2 default hr_api.g_varchar2
838: ,p_source_criteria2 in varchar2 default hr_api.g_varchar2
839: ,p_source_value2 in varchar2 default hr_api.g_varchar2
840: ,p_source_criteria3 in varchar2 default hr_api.g_varchar2
841: ,p_source_value3 in varchar2 default hr_api.g_varchar2
842: ,p_source_criteria4 in varchar2 default hr_api.g_varchar2

Line 839: ,p_source_value2 in varchar2 default hr_api.g_varchar2

835: ,p_source_name in varchar2 default hr_api.g_varchar2
836: ,p_source_criteria1 in varchar2 default hr_api.g_varchar2
837: ,p_source_value1 in varchar2 default hr_api.g_varchar2
838: ,p_source_criteria2 in varchar2 default hr_api.g_varchar2
839: ,p_source_value2 in varchar2 default hr_api.g_varchar2
840: ,p_source_criteria3 in varchar2 default hr_api.g_varchar2
841: ,p_source_value3 in varchar2 default hr_api.g_varchar2
842: ,p_source_criteria4 in varchar2 default hr_api.g_varchar2
843: ,p_source_value4 in varchar2 default hr_api.g_varchar2

Line 840: ,p_source_criteria3 in varchar2 default hr_api.g_varchar2

836: ,p_source_criteria1 in varchar2 default hr_api.g_varchar2
837: ,p_source_value1 in varchar2 default hr_api.g_varchar2
838: ,p_source_criteria2 in varchar2 default hr_api.g_varchar2
839: ,p_source_value2 in varchar2 default hr_api.g_varchar2
840: ,p_source_criteria3 in varchar2 default hr_api.g_varchar2
841: ,p_source_value3 in varchar2 default hr_api.g_varchar2
842: ,p_source_criteria4 in varchar2 default hr_api.g_varchar2
843: ,p_source_value4 in varchar2 default hr_api.g_varchar2
844: ,p_source_criteria5 in varchar2 default hr_api.g_varchar2

Line 841: ,p_source_value3 in varchar2 default hr_api.g_varchar2

837: ,p_source_value1 in varchar2 default hr_api.g_varchar2
838: ,p_source_criteria2 in varchar2 default hr_api.g_varchar2
839: ,p_source_value2 in varchar2 default hr_api.g_varchar2
840: ,p_source_criteria3 in varchar2 default hr_api.g_varchar2
841: ,p_source_value3 in varchar2 default hr_api.g_varchar2
842: ,p_source_criteria4 in varchar2 default hr_api.g_varchar2
843: ,p_source_value4 in varchar2 default hr_api.g_varchar2
844: ,p_source_criteria5 in varchar2 default hr_api.g_varchar2
845: ,p_source_value5 in varchar2 default hr_api.g_varchar2

Line 842: ,p_source_criteria4 in varchar2 default hr_api.g_varchar2

838: ,p_source_criteria2 in varchar2 default hr_api.g_varchar2
839: ,p_source_value2 in varchar2 default hr_api.g_varchar2
840: ,p_source_criteria3 in varchar2 default hr_api.g_varchar2
841: ,p_source_value3 in varchar2 default hr_api.g_varchar2
842: ,p_source_criteria4 in varchar2 default hr_api.g_varchar2
843: ,p_source_value4 in varchar2 default hr_api.g_varchar2
844: ,p_source_criteria5 in varchar2 default hr_api.g_varchar2
845: ,p_source_value5 in varchar2 default hr_api.g_varchar2
846: ,p_source_person_id in number default hr_api.g_number

Line 843: ,p_source_value4 in varchar2 default hr_api.g_varchar2

839: ,p_source_value2 in varchar2 default hr_api.g_varchar2
840: ,p_source_criteria3 in varchar2 default hr_api.g_varchar2
841: ,p_source_value3 in varchar2 default hr_api.g_varchar2
842: ,p_source_criteria4 in varchar2 default hr_api.g_varchar2
843: ,p_source_value4 in varchar2 default hr_api.g_varchar2
844: ,p_source_criteria5 in varchar2 default hr_api.g_varchar2
845: ,p_source_value5 in varchar2 default hr_api.g_varchar2
846: ,p_source_person_id in number default hr_api.g_number
847: ,p_candidate_comment in varchar2 default hr_api.g_varchar2

Line 844: ,p_source_criteria5 in varchar2 default hr_api.g_varchar2

840: ,p_source_criteria3 in varchar2 default hr_api.g_varchar2
841: ,p_source_value3 in varchar2 default hr_api.g_varchar2
842: ,p_source_criteria4 in varchar2 default hr_api.g_varchar2
843: ,p_source_value4 in varchar2 default hr_api.g_varchar2
844: ,p_source_criteria5 in varchar2 default hr_api.g_varchar2
845: ,p_source_value5 in varchar2 default hr_api.g_varchar2
846: ,p_source_person_id in number default hr_api.g_number
847: ,p_candidate_comment in varchar2 default hr_api.g_varchar2
848: ,p_employee_comment in varchar2 default hr_api.g_varchar2

Line 845: ,p_source_value5 in varchar2 default hr_api.g_varchar2

841: ,p_source_value3 in varchar2 default hr_api.g_varchar2
842: ,p_source_criteria4 in varchar2 default hr_api.g_varchar2
843: ,p_source_value4 in varchar2 default hr_api.g_varchar2
844: ,p_source_criteria5 in varchar2 default hr_api.g_varchar2
845: ,p_source_value5 in varchar2 default hr_api.g_varchar2
846: ,p_source_person_id in number default hr_api.g_number
847: ,p_candidate_comment in varchar2 default hr_api.g_varchar2
848: ,p_employee_comment in varchar2 default hr_api.g_varchar2
849: ,p_irf_attribute_category in varchar2 default hr_api.g_varchar2

Line 846: ,p_source_person_id in number default hr_api.g_number

842: ,p_source_criteria4 in varchar2 default hr_api.g_varchar2
843: ,p_source_value4 in varchar2 default hr_api.g_varchar2
844: ,p_source_criteria5 in varchar2 default hr_api.g_varchar2
845: ,p_source_value5 in varchar2 default hr_api.g_varchar2
846: ,p_source_person_id in number default hr_api.g_number
847: ,p_candidate_comment in varchar2 default hr_api.g_varchar2
848: ,p_employee_comment in varchar2 default hr_api.g_varchar2
849: ,p_irf_attribute_category in varchar2 default hr_api.g_varchar2
850: ,p_irf_attribute1 in varchar2 default hr_api.g_varchar2

Line 847: ,p_candidate_comment in varchar2 default hr_api.g_varchar2

843: ,p_source_value4 in varchar2 default hr_api.g_varchar2
844: ,p_source_criteria5 in varchar2 default hr_api.g_varchar2
845: ,p_source_value5 in varchar2 default hr_api.g_varchar2
846: ,p_source_person_id in number default hr_api.g_number
847: ,p_candidate_comment in varchar2 default hr_api.g_varchar2
848: ,p_employee_comment in varchar2 default hr_api.g_varchar2
849: ,p_irf_attribute_category in varchar2 default hr_api.g_varchar2
850: ,p_irf_attribute1 in varchar2 default hr_api.g_varchar2
851: ,p_irf_attribute2 in varchar2 default hr_api.g_varchar2

Line 848: ,p_employee_comment in varchar2 default hr_api.g_varchar2

844: ,p_source_criteria5 in varchar2 default hr_api.g_varchar2
845: ,p_source_value5 in varchar2 default hr_api.g_varchar2
846: ,p_source_person_id in number default hr_api.g_number
847: ,p_candidate_comment in varchar2 default hr_api.g_varchar2
848: ,p_employee_comment in varchar2 default hr_api.g_varchar2
849: ,p_irf_attribute_category in varchar2 default hr_api.g_varchar2
850: ,p_irf_attribute1 in varchar2 default hr_api.g_varchar2
851: ,p_irf_attribute2 in varchar2 default hr_api.g_varchar2
852: ,p_irf_attribute3 in varchar2 default hr_api.g_varchar2

Line 849: ,p_irf_attribute_category in varchar2 default hr_api.g_varchar2

845: ,p_source_value5 in varchar2 default hr_api.g_varchar2
846: ,p_source_person_id in number default hr_api.g_number
847: ,p_candidate_comment in varchar2 default hr_api.g_varchar2
848: ,p_employee_comment in varchar2 default hr_api.g_varchar2
849: ,p_irf_attribute_category in varchar2 default hr_api.g_varchar2
850: ,p_irf_attribute1 in varchar2 default hr_api.g_varchar2
851: ,p_irf_attribute2 in varchar2 default hr_api.g_varchar2
852: ,p_irf_attribute3 in varchar2 default hr_api.g_varchar2
853: ,p_irf_attribute4 in varchar2 default hr_api.g_varchar2

Line 850: ,p_irf_attribute1 in varchar2 default hr_api.g_varchar2

846: ,p_source_person_id in number default hr_api.g_number
847: ,p_candidate_comment in varchar2 default hr_api.g_varchar2
848: ,p_employee_comment in varchar2 default hr_api.g_varchar2
849: ,p_irf_attribute_category in varchar2 default hr_api.g_varchar2
850: ,p_irf_attribute1 in varchar2 default hr_api.g_varchar2
851: ,p_irf_attribute2 in varchar2 default hr_api.g_varchar2
852: ,p_irf_attribute3 in varchar2 default hr_api.g_varchar2
853: ,p_irf_attribute4 in varchar2 default hr_api.g_varchar2
854: ,p_irf_attribute5 in varchar2 default hr_api.g_varchar2

Line 851: ,p_irf_attribute2 in varchar2 default hr_api.g_varchar2

847: ,p_candidate_comment in varchar2 default hr_api.g_varchar2
848: ,p_employee_comment in varchar2 default hr_api.g_varchar2
849: ,p_irf_attribute_category in varchar2 default hr_api.g_varchar2
850: ,p_irf_attribute1 in varchar2 default hr_api.g_varchar2
851: ,p_irf_attribute2 in varchar2 default hr_api.g_varchar2
852: ,p_irf_attribute3 in varchar2 default hr_api.g_varchar2
853: ,p_irf_attribute4 in varchar2 default hr_api.g_varchar2
854: ,p_irf_attribute5 in varchar2 default hr_api.g_varchar2
855: ,p_irf_attribute6 in varchar2 default hr_api.g_varchar2

Line 852: ,p_irf_attribute3 in varchar2 default hr_api.g_varchar2

848: ,p_employee_comment in varchar2 default hr_api.g_varchar2
849: ,p_irf_attribute_category in varchar2 default hr_api.g_varchar2
850: ,p_irf_attribute1 in varchar2 default hr_api.g_varchar2
851: ,p_irf_attribute2 in varchar2 default hr_api.g_varchar2
852: ,p_irf_attribute3 in varchar2 default hr_api.g_varchar2
853: ,p_irf_attribute4 in varchar2 default hr_api.g_varchar2
854: ,p_irf_attribute5 in varchar2 default hr_api.g_varchar2
855: ,p_irf_attribute6 in varchar2 default hr_api.g_varchar2
856: ,p_irf_attribute7 in varchar2 default hr_api.g_varchar2

Line 853: ,p_irf_attribute4 in varchar2 default hr_api.g_varchar2

849: ,p_irf_attribute_category in varchar2 default hr_api.g_varchar2
850: ,p_irf_attribute1 in varchar2 default hr_api.g_varchar2
851: ,p_irf_attribute2 in varchar2 default hr_api.g_varchar2
852: ,p_irf_attribute3 in varchar2 default hr_api.g_varchar2
853: ,p_irf_attribute4 in varchar2 default hr_api.g_varchar2
854: ,p_irf_attribute5 in varchar2 default hr_api.g_varchar2
855: ,p_irf_attribute6 in varchar2 default hr_api.g_varchar2
856: ,p_irf_attribute7 in varchar2 default hr_api.g_varchar2
857: ,p_irf_attribute8 in varchar2 default hr_api.g_varchar2

Line 854: ,p_irf_attribute5 in varchar2 default hr_api.g_varchar2

850: ,p_irf_attribute1 in varchar2 default hr_api.g_varchar2
851: ,p_irf_attribute2 in varchar2 default hr_api.g_varchar2
852: ,p_irf_attribute3 in varchar2 default hr_api.g_varchar2
853: ,p_irf_attribute4 in varchar2 default hr_api.g_varchar2
854: ,p_irf_attribute5 in varchar2 default hr_api.g_varchar2
855: ,p_irf_attribute6 in varchar2 default hr_api.g_varchar2
856: ,p_irf_attribute7 in varchar2 default hr_api.g_varchar2
857: ,p_irf_attribute8 in varchar2 default hr_api.g_varchar2
858: ,p_irf_attribute9 in varchar2 default hr_api.g_varchar2

Line 855: ,p_irf_attribute6 in varchar2 default hr_api.g_varchar2

851: ,p_irf_attribute2 in varchar2 default hr_api.g_varchar2
852: ,p_irf_attribute3 in varchar2 default hr_api.g_varchar2
853: ,p_irf_attribute4 in varchar2 default hr_api.g_varchar2
854: ,p_irf_attribute5 in varchar2 default hr_api.g_varchar2
855: ,p_irf_attribute6 in varchar2 default hr_api.g_varchar2
856: ,p_irf_attribute7 in varchar2 default hr_api.g_varchar2
857: ,p_irf_attribute8 in varchar2 default hr_api.g_varchar2
858: ,p_irf_attribute9 in varchar2 default hr_api.g_varchar2
859: ,p_irf_attribute10 in varchar2 default hr_api.g_varchar2

Line 856: ,p_irf_attribute7 in varchar2 default hr_api.g_varchar2

852: ,p_irf_attribute3 in varchar2 default hr_api.g_varchar2
853: ,p_irf_attribute4 in varchar2 default hr_api.g_varchar2
854: ,p_irf_attribute5 in varchar2 default hr_api.g_varchar2
855: ,p_irf_attribute6 in varchar2 default hr_api.g_varchar2
856: ,p_irf_attribute7 in varchar2 default hr_api.g_varchar2
857: ,p_irf_attribute8 in varchar2 default hr_api.g_varchar2
858: ,p_irf_attribute9 in varchar2 default hr_api.g_varchar2
859: ,p_irf_attribute10 in varchar2 default hr_api.g_varchar2
860: ,p_irf_information_category in varchar2 default hr_api.g_varchar2

Line 857: ,p_irf_attribute8 in varchar2 default hr_api.g_varchar2

853: ,p_irf_attribute4 in varchar2 default hr_api.g_varchar2
854: ,p_irf_attribute5 in varchar2 default hr_api.g_varchar2
855: ,p_irf_attribute6 in varchar2 default hr_api.g_varchar2
856: ,p_irf_attribute7 in varchar2 default hr_api.g_varchar2
857: ,p_irf_attribute8 in varchar2 default hr_api.g_varchar2
858: ,p_irf_attribute9 in varchar2 default hr_api.g_varchar2
859: ,p_irf_attribute10 in varchar2 default hr_api.g_varchar2
860: ,p_irf_information_category in varchar2 default hr_api.g_varchar2
861: ,p_irf_information1 in varchar2 default hr_api.g_varchar2

Line 858: ,p_irf_attribute9 in varchar2 default hr_api.g_varchar2

854: ,p_irf_attribute5 in varchar2 default hr_api.g_varchar2
855: ,p_irf_attribute6 in varchar2 default hr_api.g_varchar2
856: ,p_irf_attribute7 in varchar2 default hr_api.g_varchar2
857: ,p_irf_attribute8 in varchar2 default hr_api.g_varchar2
858: ,p_irf_attribute9 in varchar2 default hr_api.g_varchar2
859: ,p_irf_attribute10 in varchar2 default hr_api.g_varchar2
860: ,p_irf_information_category in varchar2 default hr_api.g_varchar2
861: ,p_irf_information1 in varchar2 default hr_api.g_varchar2
862: ,p_irf_information2 in varchar2 default hr_api.g_varchar2

Line 859: ,p_irf_attribute10 in varchar2 default hr_api.g_varchar2

855: ,p_irf_attribute6 in varchar2 default hr_api.g_varchar2
856: ,p_irf_attribute7 in varchar2 default hr_api.g_varchar2
857: ,p_irf_attribute8 in varchar2 default hr_api.g_varchar2
858: ,p_irf_attribute9 in varchar2 default hr_api.g_varchar2
859: ,p_irf_attribute10 in varchar2 default hr_api.g_varchar2
860: ,p_irf_information_category in varchar2 default hr_api.g_varchar2
861: ,p_irf_information1 in varchar2 default hr_api.g_varchar2
862: ,p_irf_information2 in varchar2 default hr_api.g_varchar2
863: ,p_irf_information3 in varchar2 default hr_api.g_varchar2

Line 860: ,p_irf_information_category in varchar2 default hr_api.g_varchar2

856: ,p_irf_attribute7 in varchar2 default hr_api.g_varchar2
857: ,p_irf_attribute8 in varchar2 default hr_api.g_varchar2
858: ,p_irf_attribute9 in varchar2 default hr_api.g_varchar2
859: ,p_irf_attribute10 in varchar2 default hr_api.g_varchar2
860: ,p_irf_information_category in varchar2 default hr_api.g_varchar2
861: ,p_irf_information1 in varchar2 default hr_api.g_varchar2
862: ,p_irf_information2 in varchar2 default hr_api.g_varchar2
863: ,p_irf_information3 in varchar2 default hr_api.g_varchar2
864: ,p_irf_information4 in varchar2 default hr_api.g_varchar2

Line 861: ,p_irf_information1 in varchar2 default hr_api.g_varchar2

857: ,p_irf_attribute8 in varchar2 default hr_api.g_varchar2
858: ,p_irf_attribute9 in varchar2 default hr_api.g_varchar2
859: ,p_irf_attribute10 in varchar2 default hr_api.g_varchar2
860: ,p_irf_information_category in varchar2 default hr_api.g_varchar2
861: ,p_irf_information1 in varchar2 default hr_api.g_varchar2
862: ,p_irf_information2 in varchar2 default hr_api.g_varchar2
863: ,p_irf_information3 in varchar2 default hr_api.g_varchar2
864: ,p_irf_information4 in varchar2 default hr_api.g_varchar2
865: ,p_irf_information5 in varchar2 default hr_api.g_varchar2

Line 862: ,p_irf_information2 in varchar2 default hr_api.g_varchar2

858: ,p_irf_attribute9 in varchar2 default hr_api.g_varchar2
859: ,p_irf_attribute10 in varchar2 default hr_api.g_varchar2
860: ,p_irf_information_category in varchar2 default hr_api.g_varchar2
861: ,p_irf_information1 in varchar2 default hr_api.g_varchar2
862: ,p_irf_information2 in varchar2 default hr_api.g_varchar2
863: ,p_irf_information3 in varchar2 default hr_api.g_varchar2
864: ,p_irf_information4 in varchar2 default hr_api.g_varchar2
865: ,p_irf_information5 in varchar2 default hr_api.g_varchar2
866: ,p_irf_information6 in varchar2 default hr_api.g_varchar2

Line 863: ,p_irf_information3 in varchar2 default hr_api.g_varchar2

859: ,p_irf_attribute10 in varchar2 default hr_api.g_varchar2
860: ,p_irf_information_category in varchar2 default hr_api.g_varchar2
861: ,p_irf_information1 in varchar2 default hr_api.g_varchar2
862: ,p_irf_information2 in varchar2 default hr_api.g_varchar2
863: ,p_irf_information3 in varchar2 default hr_api.g_varchar2
864: ,p_irf_information4 in varchar2 default hr_api.g_varchar2
865: ,p_irf_information5 in varchar2 default hr_api.g_varchar2
866: ,p_irf_information6 in varchar2 default hr_api.g_varchar2
867: ,p_irf_information7 in varchar2 default hr_api.g_varchar2

Line 864: ,p_irf_information4 in varchar2 default hr_api.g_varchar2

860: ,p_irf_information_category in varchar2 default hr_api.g_varchar2
861: ,p_irf_information1 in varchar2 default hr_api.g_varchar2
862: ,p_irf_information2 in varchar2 default hr_api.g_varchar2
863: ,p_irf_information3 in varchar2 default hr_api.g_varchar2
864: ,p_irf_information4 in varchar2 default hr_api.g_varchar2
865: ,p_irf_information5 in varchar2 default hr_api.g_varchar2
866: ,p_irf_information6 in varchar2 default hr_api.g_varchar2
867: ,p_irf_information7 in varchar2 default hr_api.g_varchar2
868: ,p_irf_information8 in varchar2 default hr_api.g_varchar2

Line 865: ,p_irf_information5 in varchar2 default hr_api.g_varchar2

861: ,p_irf_information1 in varchar2 default hr_api.g_varchar2
862: ,p_irf_information2 in varchar2 default hr_api.g_varchar2
863: ,p_irf_information3 in varchar2 default hr_api.g_varchar2
864: ,p_irf_information4 in varchar2 default hr_api.g_varchar2
865: ,p_irf_information5 in varchar2 default hr_api.g_varchar2
866: ,p_irf_information6 in varchar2 default hr_api.g_varchar2
867: ,p_irf_information7 in varchar2 default hr_api.g_varchar2
868: ,p_irf_information8 in varchar2 default hr_api.g_varchar2
869: ,p_irf_information9 in varchar2 default hr_api.g_varchar2

Line 866: ,p_irf_information6 in varchar2 default hr_api.g_varchar2

862: ,p_irf_information2 in varchar2 default hr_api.g_varchar2
863: ,p_irf_information3 in varchar2 default hr_api.g_varchar2
864: ,p_irf_information4 in varchar2 default hr_api.g_varchar2
865: ,p_irf_information5 in varchar2 default hr_api.g_varchar2
866: ,p_irf_information6 in varchar2 default hr_api.g_varchar2
867: ,p_irf_information7 in varchar2 default hr_api.g_varchar2
868: ,p_irf_information8 in varchar2 default hr_api.g_varchar2
869: ,p_irf_information9 in varchar2 default hr_api.g_varchar2
870: ,p_irf_information10 in varchar2 default hr_api.g_varchar2

Line 867: ,p_irf_information7 in varchar2 default hr_api.g_varchar2

863: ,p_irf_information3 in varchar2 default hr_api.g_varchar2
864: ,p_irf_information4 in varchar2 default hr_api.g_varchar2
865: ,p_irf_information5 in varchar2 default hr_api.g_varchar2
866: ,p_irf_information6 in varchar2 default hr_api.g_varchar2
867: ,p_irf_information7 in varchar2 default hr_api.g_varchar2
868: ,p_irf_information8 in varchar2 default hr_api.g_varchar2
869: ,p_irf_information9 in varchar2 default hr_api.g_varchar2
870: ,p_irf_information10 in varchar2 default hr_api.g_varchar2
871: ,p_start_date out nocopy date

Line 868: ,p_irf_information8 in varchar2 default hr_api.g_varchar2

864: ,p_irf_information4 in varchar2 default hr_api.g_varchar2
865: ,p_irf_information5 in varchar2 default hr_api.g_varchar2
866: ,p_irf_information6 in varchar2 default hr_api.g_varchar2
867: ,p_irf_information7 in varchar2 default hr_api.g_varchar2
868: ,p_irf_information8 in varchar2 default hr_api.g_varchar2
869: ,p_irf_information9 in varchar2 default hr_api.g_varchar2
870: ,p_irf_information10 in varchar2 default hr_api.g_varchar2
871: ,p_start_date out nocopy date
872: ,p_end_date out nocopy date

Line 869: ,p_irf_information9 in varchar2 default hr_api.g_varchar2

865: ,p_irf_information5 in varchar2 default hr_api.g_varchar2
866: ,p_irf_information6 in varchar2 default hr_api.g_varchar2
867: ,p_irf_information7 in varchar2 default hr_api.g_varchar2
868: ,p_irf_information8 in varchar2 default hr_api.g_varchar2
869: ,p_irf_information9 in varchar2 default hr_api.g_varchar2
870: ,p_irf_information10 in varchar2 default hr_api.g_varchar2
871: ,p_start_date out nocopy date
872: ,p_end_date out nocopy date
873: ) is

Line 870: ,p_irf_information10 in varchar2 default hr_api.g_varchar2

866: ,p_irf_information6 in varchar2 default hr_api.g_varchar2
867: ,p_irf_information7 in varchar2 default hr_api.g_varchar2
868: ,p_irf_information8 in varchar2 default hr_api.g_varchar2
869: ,p_irf_information9 in varchar2 default hr_api.g_varchar2
870: ,p_irf_information10 in varchar2 default hr_api.g_varchar2
871: ,p_start_date out nocopy date
872: ,p_end_date out nocopy date
873: ) is
874: --

Line 887: ,hr_api.g_number

883: --
884: l_rec :=
885: irc_irf_shd.convert_args
886: (p_referral_info_id
887: ,hr_api.g_number
888: ,hr_api.g_varchar2
889: ,p_start_date
890: ,p_end_date
891: ,p_source_type

Line 888: ,hr_api.g_varchar2

884: l_rec :=
885: irc_irf_shd.convert_args
886: (p_referral_info_id
887: ,hr_api.g_number
888: ,hr_api.g_varchar2
889: ,p_start_date
890: ,p_end_date
891: ,p_source_type
892: ,p_source_name

Line 928: ,hr_api.g_varchar2

924: ,p_irf_information7
925: ,p_irf_information8
926: ,p_irf_information9
927: ,p_irf_information10
928: ,hr_api.g_varchar2
929: ,p_object_version_number
930: );
931: --
932: -- Having converted the arguments into the