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_IID_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 134: When hr_api.check_integrity_violated Then

130: End If;
131: --
132: hr_utility.set_location(' Leaving:'||l_proc, 15);
133: Exception
134: When hr_api.check_integrity_violated Then
135: -- A check constraint has been violated
136: --
137: irc_iid_shd.constraint_error
138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

134: When hr_api.check_integrity_violated Then
135: -- A check constraint has been violated
136: --
137: irc_iid_shd.constraint_error
138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
139: When hr_api.unique_integrity_violated Then
140: -- Unique integrity has been violated
141: --
142: irc_iid_shd.constraint_error

Line 139: When hr_api.unique_integrity_violated Then

135: -- A check constraint has been violated
136: --
137: irc_iid_shd.constraint_error
138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
139: When hr_api.unique_integrity_violated Then
140: -- Unique integrity has been violated
141: --
142: irc_iid_shd.constraint_error
143: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

139: When hr_api.unique_integrity_violated Then
140: -- Unique integrity has been violated
141: --
142: irc_iid_shd.constraint_error
143: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
144: When Others Then
145: --
146: Raise;
147: End dt_update_dml;

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

256: l_dummy_version_number number;
257: --
258: Begin
259: hr_utility.set_location('Entering:'||l_proc, 5);
260: If (p_datetrack_mode <> hr_api.g_correction) then
261: --
262: -- Update the current effective end date
263: --
264: irc_iid_shd.upd_end_date

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

267: ,p_new_end_date => p_validation_start_date
268: ,p_object_version_number => l_dummy_version_number
269: );
270: --
271: If (p_datetrack_mode = hr_api.g_update_override) then
272: --
273: -- As the datetrack mode is 'UPDATE_OVERRIDE' then we must
274: -- delete any future rows
275: --

Line 541: when hr_api.cannot_find_prog_unit then

537: );
538: --
539: exception
540: --
541: when hr_api.cannot_find_prog_unit then
542: --
543: hr_api.cannot_find_prog_unit_error
544: (p_module_name => 'IRC_INTERVIEW_DETAILS'
545: ,p_hook_type => 'AU');

Line 543: hr_api.cannot_find_prog_unit_error

539: exception
540: --
541: when hr_api.cannot_find_prog_unit then
542: --
543: hr_api.cannot_find_prog_unit_error
544: (p_module_name => 'IRC_INTERVIEW_DETAILS'
545: ,p_hook_type => 'AU');
546: --
547: end;

Line 606: If (p_rec.status = hr_api.g_varchar2) then

602: -- p_rec plsql record structure
603: -- to see if a system default is being used. If a system default
604: -- is being used then we must set to the 'current' argument value.
605: --
606: If (p_rec.status = hr_api.g_varchar2) then
607: p_rec.status :=
608: irc_iid_shd.g_old_rec.status;
609: End If;
610: If (p_rec.feedback = hr_api.g_varchar2) then

Line 610: If (p_rec.feedback = hr_api.g_varchar2) then

606: If (p_rec.status = hr_api.g_varchar2) then
607: p_rec.status :=
608: irc_iid_shd.g_old_rec.status;
609: End If;
610: If (p_rec.feedback = hr_api.g_varchar2) then
611: p_rec.feedback :=
612: irc_iid_shd.g_old_rec.feedback;
613: End If;
614: If (p_rec.notes = hr_api.g_varchar2) then

Line 614: If (p_rec.notes = hr_api.g_varchar2) then

610: If (p_rec.feedback = hr_api.g_varchar2) then
611: p_rec.feedback :=
612: irc_iid_shd.g_old_rec.feedback;
613: End If;
614: If (p_rec.notes = hr_api.g_varchar2) then
615: p_rec.notes :=
616: irc_iid_shd.g_old_rec.notes;
617: End If;
618: If (p_rec.notes_to_candidate = hr_api.g_varchar2) then

Line 618: If (p_rec.notes_to_candidate = hr_api.g_varchar2) then

614: If (p_rec.notes = hr_api.g_varchar2) then
615: p_rec.notes :=
616: irc_iid_shd.g_old_rec.notes;
617: End If;
618: If (p_rec.notes_to_candidate = hr_api.g_varchar2) then
619: p_rec.notes_to_candidate :=
620: irc_iid_shd.g_old_rec.notes_to_candidate;
621: End If;
622: If (p_rec.category = hr_api.g_varchar2) then

Line 622: If (p_rec.category = hr_api.g_varchar2) then

618: If (p_rec.notes_to_candidate = hr_api.g_varchar2) then
619: p_rec.notes_to_candidate :=
620: irc_iid_shd.g_old_rec.notes_to_candidate;
621: End If;
622: If (p_rec.category = hr_api.g_varchar2) then
623: p_rec.category :=
624: irc_iid_shd.g_old_rec.category;
625: End If;
626: If (p_rec.result = hr_api.g_varchar2) then

Line 626: If (p_rec.result = hr_api.g_varchar2) then

622: If (p_rec.category = hr_api.g_varchar2) then
623: p_rec.category :=
624: irc_iid_shd.g_old_rec.category;
625: End If;
626: If (p_rec.result = hr_api.g_varchar2) then
627: p_rec.result :=
628: irc_iid_shd.g_old_rec.result;
629: End If;
630: If (p_rec.iid_information_category = hr_api.g_varchar2) then

Line 630: If (p_rec.iid_information_category = hr_api.g_varchar2) then

626: If (p_rec.result = hr_api.g_varchar2) then
627: p_rec.result :=
628: irc_iid_shd.g_old_rec.result;
629: End If;
630: If (p_rec.iid_information_category = hr_api.g_varchar2) then
631: p_rec.iid_information_category :=
632: irc_iid_shd.g_old_rec.iid_information_category;
633: End If;
634: If (p_rec.iid_information1 = hr_api.g_varchar2) then

Line 634: If (p_rec.iid_information1 = hr_api.g_varchar2) then

630: If (p_rec.iid_information_category = hr_api.g_varchar2) then
631: p_rec.iid_information_category :=
632: irc_iid_shd.g_old_rec.iid_information_category;
633: End If;
634: If (p_rec.iid_information1 = hr_api.g_varchar2) then
635: p_rec.iid_information1 :=
636: irc_iid_shd.g_old_rec.iid_information1;
637: End If;
638: If (p_rec.iid_information2 = hr_api.g_varchar2) then

Line 638: If (p_rec.iid_information2 = hr_api.g_varchar2) then

634: If (p_rec.iid_information1 = hr_api.g_varchar2) then
635: p_rec.iid_information1 :=
636: irc_iid_shd.g_old_rec.iid_information1;
637: End If;
638: If (p_rec.iid_information2 = hr_api.g_varchar2) then
639: p_rec.iid_information2 :=
640: irc_iid_shd.g_old_rec.iid_information2;
641: End If;
642: If (p_rec.iid_information3 = hr_api.g_varchar2) then

Line 642: If (p_rec.iid_information3 = hr_api.g_varchar2) then

638: If (p_rec.iid_information2 = hr_api.g_varchar2) then
639: p_rec.iid_information2 :=
640: irc_iid_shd.g_old_rec.iid_information2;
641: End If;
642: If (p_rec.iid_information3 = hr_api.g_varchar2) then
643: p_rec.iid_information3 :=
644: irc_iid_shd.g_old_rec.iid_information3;
645: End If;
646: If (p_rec.iid_information4 = hr_api.g_varchar2) then

Line 646: If (p_rec.iid_information4 = hr_api.g_varchar2) then

642: If (p_rec.iid_information3 = hr_api.g_varchar2) then
643: p_rec.iid_information3 :=
644: irc_iid_shd.g_old_rec.iid_information3;
645: End If;
646: If (p_rec.iid_information4 = hr_api.g_varchar2) then
647: p_rec.iid_information4 :=
648: irc_iid_shd.g_old_rec.iid_information4;
649: End If;
650: If (p_rec.iid_information5 = hr_api.g_varchar2) then

Line 650: If (p_rec.iid_information5 = hr_api.g_varchar2) then

646: If (p_rec.iid_information4 = hr_api.g_varchar2) then
647: p_rec.iid_information4 :=
648: irc_iid_shd.g_old_rec.iid_information4;
649: End If;
650: If (p_rec.iid_information5 = hr_api.g_varchar2) then
651: p_rec.iid_information5 :=
652: irc_iid_shd.g_old_rec.iid_information5;
653: End If;
654: If (p_rec.iid_information6 = hr_api.g_varchar2) then

Line 654: If (p_rec.iid_information6 = hr_api.g_varchar2) then

650: If (p_rec.iid_information5 = hr_api.g_varchar2) then
651: p_rec.iid_information5 :=
652: irc_iid_shd.g_old_rec.iid_information5;
653: End If;
654: If (p_rec.iid_information6 = hr_api.g_varchar2) then
655: p_rec.iid_information6 :=
656: irc_iid_shd.g_old_rec.iid_information6;
657: End If;
658: If (p_rec.iid_information7 = hr_api.g_varchar2) then

Line 658: If (p_rec.iid_information7 = hr_api.g_varchar2) then

654: If (p_rec.iid_information6 = hr_api.g_varchar2) then
655: p_rec.iid_information6 :=
656: irc_iid_shd.g_old_rec.iid_information6;
657: End If;
658: If (p_rec.iid_information7 = hr_api.g_varchar2) then
659: p_rec.iid_information7 :=
660: irc_iid_shd.g_old_rec.iid_information7;
661: End If;
662: If (p_rec.iid_information8 = hr_api.g_varchar2) then

Line 662: If (p_rec.iid_information8 = hr_api.g_varchar2) then

658: If (p_rec.iid_information7 = hr_api.g_varchar2) then
659: p_rec.iid_information7 :=
660: irc_iid_shd.g_old_rec.iid_information7;
661: End If;
662: If (p_rec.iid_information8 = hr_api.g_varchar2) then
663: p_rec.iid_information8 :=
664: irc_iid_shd.g_old_rec.iid_information8;
665: End If;
666: If (p_rec.iid_information9 = hr_api.g_varchar2) then

Line 666: If (p_rec.iid_information9 = hr_api.g_varchar2) then

662: If (p_rec.iid_information8 = hr_api.g_varchar2) then
663: p_rec.iid_information8 :=
664: irc_iid_shd.g_old_rec.iid_information8;
665: End If;
666: If (p_rec.iid_information9 = hr_api.g_varchar2) then
667: p_rec.iid_information9 :=
668: irc_iid_shd.g_old_rec.iid_information9;
669: End If;
670: If (p_rec.iid_information10 = hr_api.g_varchar2) then

Line 670: If (p_rec.iid_information10 = hr_api.g_varchar2) then

666: If (p_rec.iid_information9 = hr_api.g_varchar2) then
667: p_rec.iid_information9 :=
668: irc_iid_shd.g_old_rec.iid_information9;
669: End If;
670: If (p_rec.iid_information10 = hr_api.g_varchar2) then
671: p_rec.iid_information10 :=
672: irc_iid_shd.g_old_rec.iid_information10;
673: End If;
674: If (p_rec.iid_information11 = hr_api.g_varchar2) then

Line 674: If (p_rec.iid_information11 = hr_api.g_varchar2) then

670: If (p_rec.iid_information10 = hr_api.g_varchar2) then
671: p_rec.iid_information10 :=
672: irc_iid_shd.g_old_rec.iid_information10;
673: End If;
674: If (p_rec.iid_information11 = hr_api.g_varchar2) then
675: p_rec.iid_information11 :=
676: irc_iid_shd.g_old_rec.iid_information11;
677: End If;
678: If (p_rec.iid_information12 = hr_api.g_varchar2) then

Line 678: If (p_rec.iid_information12 = hr_api.g_varchar2) then

674: If (p_rec.iid_information11 = hr_api.g_varchar2) then
675: p_rec.iid_information11 :=
676: irc_iid_shd.g_old_rec.iid_information11;
677: End If;
678: If (p_rec.iid_information12 = hr_api.g_varchar2) then
679: p_rec.iid_information12 :=
680: irc_iid_shd.g_old_rec.iid_information12;
681: End If;
682: If (p_rec.iid_information13 = hr_api.g_varchar2) then

Line 682: If (p_rec.iid_information13 = hr_api.g_varchar2) then

678: If (p_rec.iid_information12 = hr_api.g_varchar2) then
679: p_rec.iid_information12 :=
680: irc_iid_shd.g_old_rec.iid_information12;
681: End If;
682: If (p_rec.iid_information13 = hr_api.g_varchar2) then
683: p_rec.iid_information13 :=
684: irc_iid_shd.g_old_rec.iid_information13;
685: End If;
686: If (p_rec.iid_information14 = hr_api.g_varchar2) then

Line 686: If (p_rec.iid_information14 = hr_api.g_varchar2) then

682: If (p_rec.iid_information13 = hr_api.g_varchar2) then
683: p_rec.iid_information13 :=
684: irc_iid_shd.g_old_rec.iid_information13;
685: End If;
686: If (p_rec.iid_information14 = hr_api.g_varchar2) then
687: p_rec.iid_information14 :=
688: irc_iid_shd.g_old_rec.iid_information14;
689: End If;
690: If (p_rec.iid_information15 = hr_api.g_varchar2) then

Line 690: If (p_rec.iid_information15 = hr_api.g_varchar2) then

686: If (p_rec.iid_information14 = hr_api.g_varchar2) then
687: p_rec.iid_information14 :=
688: irc_iid_shd.g_old_rec.iid_information14;
689: End If;
690: If (p_rec.iid_information15 = hr_api.g_varchar2) then
691: p_rec.iid_information15 :=
692: irc_iid_shd.g_old_rec.iid_information15;
693: End If;
694: If (p_rec.iid_information16 = hr_api.g_varchar2) then

Line 694: If (p_rec.iid_information16 = hr_api.g_varchar2) then

690: If (p_rec.iid_information15 = hr_api.g_varchar2) then
691: p_rec.iid_information15 :=
692: irc_iid_shd.g_old_rec.iid_information15;
693: End If;
694: If (p_rec.iid_information16 = hr_api.g_varchar2) then
695: p_rec.iid_information16 :=
696: irc_iid_shd.g_old_rec.iid_information16;
697: End If;
698: If (p_rec.iid_information17 = hr_api.g_varchar2) then

Line 698: If (p_rec.iid_information17 = hr_api.g_varchar2) then

694: If (p_rec.iid_information16 = hr_api.g_varchar2) then
695: p_rec.iid_information16 :=
696: irc_iid_shd.g_old_rec.iid_information16;
697: End If;
698: If (p_rec.iid_information17 = hr_api.g_varchar2) then
699: p_rec.iid_information17 :=
700: irc_iid_shd.g_old_rec.iid_information17;
701: End If;
702: If (p_rec.iid_information18 = hr_api.g_varchar2) then

Line 702: If (p_rec.iid_information18 = hr_api.g_varchar2) then

698: If (p_rec.iid_information17 = hr_api.g_varchar2) then
699: p_rec.iid_information17 :=
700: irc_iid_shd.g_old_rec.iid_information17;
701: End If;
702: If (p_rec.iid_information18 = hr_api.g_varchar2) then
703: p_rec.iid_information18 :=
704: irc_iid_shd.g_old_rec.iid_information18;
705: End If;
706: If (p_rec.iid_information19 = hr_api.g_varchar2) then

Line 706: If (p_rec.iid_information19 = hr_api.g_varchar2) then

702: If (p_rec.iid_information18 = hr_api.g_varchar2) then
703: p_rec.iid_information18 :=
704: irc_iid_shd.g_old_rec.iid_information18;
705: End If;
706: If (p_rec.iid_information19 = hr_api.g_varchar2) then
707: p_rec.iid_information19 :=
708: irc_iid_shd.g_old_rec.iid_information19;
709: End If;
710: If (p_rec.iid_information20 = hr_api.g_varchar2) then

Line 710: If (p_rec.iid_information20 = hr_api.g_varchar2) then

706: If (p_rec.iid_information19 = hr_api.g_varchar2) then
707: p_rec.iid_information19 :=
708: irc_iid_shd.g_old_rec.iid_information19;
709: End If;
710: If (p_rec.iid_information20 = hr_api.g_varchar2) then
711: p_rec.iid_information20 :=
712: irc_iid_shd.g_old_rec.iid_information20;
713: End If;
714: If (p_rec.start_date = hr_api.g_date) then

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

710: If (p_rec.iid_information20 = hr_api.g_varchar2) then
711: p_rec.iid_information20 :=
712: irc_iid_shd.g_old_rec.iid_information20;
713: End If;
714: If (p_rec.start_date = hr_api.g_date) then
715: p_rec.start_date :=
716: irc_iid_shd.g_old_rec.start_date;
717: End If;
718: If (p_rec.end_date = hr_api.g_date) then

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

714: If (p_rec.start_date = hr_api.g_date) then
715: p_rec.start_date :=
716: irc_iid_shd.g_old_rec.start_date;
717: End If;
718: If (p_rec.end_date = hr_api.g_date) then
719: p_rec.end_date :=
720: irc_iid_shd.g_old_rec.end_date;
721: End If;
722: If (p_rec.event_id = hr_api.g_number) then

Line 722: If (p_rec.event_id = hr_api.g_number) then

718: If (p_rec.end_date = hr_api.g_date) then
719: p_rec.end_date :=
720: irc_iid_shd.g_old_rec.end_date;
721: End If;
722: If (p_rec.event_id = hr_api.g_number) then
723: p_rec.event_id :=
724: irc_iid_shd.g_old_rec.event_id;
725: End If;
726: --

Line 821: ,p_status in varchar2 default hr_api.g_varchar2

817: (p_effective_date in date
818: ,p_datetrack_mode in varchar2
819: ,p_interview_details_id in number
820: ,p_object_version_number in out nocopy number
821: ,p_status in varchar2 default hr_api.g_varchar2
822: ,p_feedback in varchar2 default hr_api.g_varchar2
823: ,p_notes in varchar2 default hr_api.g_varchar2
824: ,p_notes_to_candidate in varchar2 default hr_api.g_varchar2
825: ,p_category in varchar2 default hr_api.g_varchar2

Line 822: ,p_feedback in varchar2 default hr_api.g_varchar2

818: ,p_datetrack_mode in varchar2
819: ,p_interview_details_id in number
820: ,p_object_version_number in out nocopy number
821: ,p_status in varchar2 default hr_api.g_varchar2
822: ,p_feedback in varchar2 default hr_api.g_varchar2
823: ,p_notes in varchar2 default hr_api.g_varchar2
824: ,p_notes_to_candidate in varchar2 default hr_api.g_varchar2
825: ,p_category in varchar2 default hr_api.g_varchar2
826: ,p_result in varchar2 default hr_api.g_varchar2

Line 823: ,p_notes in varchar2 default hr_api.g_varchar2

819: ,p_interview_details_id in number
820: ,p_object_version_number in out nocopy number
821: ,p_status in varchar2 default hr_api.g_varchar2
822: ,p_feedback in varchar2 default hr_api.g_varchar2
823: ,p_notes in varchar2 default hr_api.g_varchar2
824: ,p_notes_to_candidate in varchar2 default hr_api.g_varchar2
825: ,p_category in varchar2 default hr_api.g_varchar2
826: ,p_result in varchar2 default hr_api.g_varchar2
827: ,p_iid_information_category in varchar2 default hr_api.g_varchar2

Line 824: ,p_notes_to_candidate in varchar2 default hr_api.g_varchar2

820: ,p_object_version_number in out nocopy number
821: ,p_status in varchar2 default hr_api.g_varchar2
822: ,p_feedback in varchar2 default hr_api.g_varchar2
823: ,p_notes in varchar2 default hr_api.g_varchar2
824: ,p_notes_to_candidate in varchar2 default hr_api.g_varchar2
825: ,p_category in varchar2 default hr_api.g_varchar2
826: ,p_result in varchar2 default hr_api.g_varchar2
827: ,p_iid_information_category in varchar2 default hr_api.g_varchar2
828: ,p_iid_information1 in varchar2 default hr_api.g_varchar2

Line 825: ,p_category in varchar2 default hr_api.g_varchar2

821: ,p_status in varchar2 default hr_api.g_varchar2
822: ,p_feedback in varchar2 default hr_api.g_varchar2
823: ,p_notes in varchar2 default hr_api.g_varchar2
824: ,p_notes_to_candidate in varchar2 default hr_api.g_varchar2
825: ,p_category in varchar2 default hr_api.g_varchar2
826: ,p_result in varchar2 default hr_api.g_varchar2
827: ,p_iid_information_category in varchar2 default hr_api.g_varchar2
828: ,p_iid_information1 in varchar2 default hr_api.g_varchar2
829: ,p_iid_information2 in varchar2 default hr_api.g_varchar2

Line 826: ,p_result in varchar2 default hr_api.g_varchar2

822: ,p_feedback in varchar2 default hr_api.g_varchar2
823: ,p_notes in varchar2 default hr_api.g_varchar2
824: ,p_notes_to_candidate in varchar2 default hr_api.g_varchar2
825: ,p_category in varchar2 default hr_api.g_varchar2
826: ,p_result in varchar2 default hr_api.g_varchar2
827: ,p_iid_information_category in varchar2 default hr_api.g_varchar2
828: ,p_iid_information1 in varchar2 default hr_api.g_varchar2
829: ,p_iid_information2 in varchar2 default hr_api.g_varchar2
830: ,p_iid_information3 in varchar2 default hr_api.g_varchar2

Line 827: ,p_iid_information_category in varchar2 default hr_api.g_varchar2

823: ,p_notes in varchar2 default hr_api.g_varchar2
824: ,p_notes_to_candidate in varchar2 default hr_api.g_varchar2
825: ,p_category in varchar2 default hr_api.g_varchar2
826: ,p_result in varchar2 default hr_api.g_varchar2
827: ,p_iid_information_category in varchar2 default hr_api.g_varchar2
828: ,p_iid_information1 in varchar2 default hr_api.g_varchar2
829: ,p_iid_information2 in varchar2 default hr_api.g_varchar2
830: ,p_iid_information3 in varchar2 default hr_api.g_varchar2
831: ,p_iid_information4 in varchar2 default hr_api.g_varchar2

Line 828: ,p_iid_information1 in varchar2 default hr_api.g_varchar2

824: ,p_notes_to_candidate in varchar2 default hr_api.g_varchar2
825: ,p_category in varchar2 default hr_api.g_varchar2
826: ,p_result in varchar2 default hr_api.g_varchar2
827: ,p_iid_information_category in varchar2 default hr_api.g_varchar2
828: ,p_iid_information1 in varchar2 default hr_api.g_varchar2
829: ,p_iid_information2 in varchar2 default hr_api.g_varchar2
830: ,p_iid_information3 in varchar2 default hr_api.g_varchar2
831: ,p_iid_information4 in varchar2 default hr_api.g_varchar2
832: ,p_iid_information5 in varchar2 default hr_api.g_varchar2

Line 829: ,p_iid_information2 in varchar2 default hr_api.g_varchar2

825: ,p_category in varchar2 default hr_api.g_varchar2
826: ,p_result in varchar2 default hr_api.g_varchar2
827: ,p_iid_information_category in varchar2 default hr_api.g_varchar2
828: ,p_iid_information1 in varchar2 default hr_api.g_varchar2
829: ,p_iid_information2 in varchar2 default hr_api.g_varchar2
830: ,p_iid_information3 in varchar2 default hr_api.g_varchar2
831: ,p_iid_information4 in varchar2 default hr_api.g_varchar2
832: ,p_iid_information5 in varchar2 default hr_api.g_varchar2
833: ,p_iid_information6 in varchar2 default hr_api.g_varchar2

Line 830: ,p_iid_information3 in varchar2 default hr_api.g_varchar2

826: ,p_result in varchar2 default hr_api.g_varchar2
827: ,p_iid_information_category in varchar2 default hr_api.g_varchar2
828: ,p_iid_information1 in varchar2 default hr_api.g_varchar2
829: ,p_iid_information2 in varchar2 default hr_api.g_varchar2
830: ,p_iid_information3 in varchar2 default hr_api.g_varchar2
831: ,p_iid_information4 in varchar2 default hr_api.g_varchar2
832: ,p_iid_information5 in varchar2 default hr_api.g_varchar2
833: ,p_iid_information6 in varchar2 default hr_api.g_varchar2
834: ,p_iid_information7 in varchar2 default hr_api.g_varchar2

Line 831: ,p_iid_information4 in varchar2 default hr_api.g_varchar2

827: ,p_iid_information_category in varchar2 default hr_api.g_varchar2
828: ,p_iid_information1 in varchar2 default hr_api.g_varchar2
829: ,p_iid_information2 in varchar2 default hr_api.g_varchar2
830: ,p_iid_information3 in varchar2 default hr_api.g_varchar2
831: ,p_iid_information4 in varchar2 default hr_api.g_varchar2
832: ,p_iid_information5 in varchar2 default hr_api.g_varchar2
833: ,p_iid_information6 in varchar2 default hr_api.g_varchar2
834: ,p_iid_information7 in varchar2 default hr_api.g_varchar2
835: ,p_iid_information8 in varchar2 default hr_api.g_varchar2

Line 832: ,p_iid_information5 in varchar2 default hr_api.g_varchar2

828: ,p_iid_information1 in varchar2 default hr_api.g_varchar2
829: ,p_iid_information2 in varchar2 default hr_api.g_varchar2
830: ,p_iid_information3 in varchar2 default hr_api.g_varchar2
831: ,p_iid_information4 in varchar2 default hr_api.g_varchar2
832: ,p_iid_information5 in varchar2 default hr_api.g_varchar2
833: ,p_iid_information6 in varchar2 default hr_api.g_varchar2
834: ,p_iid_information7 in varchar2 default hr_api.g_varchar2
835: ,p_iid_information8 in varchar2 default hr_api.g_varchar2
836: ,p_iid_information9 in varchar2 default hr_api.g_varchar2

Line 833: ,p_iid_information6 in varchar2 default hr_api.g_varchar2

829: ,p_iid_information2 in varchar2 default hr_api.g_varchar2
830: ,p_iid_information3 in varchar2 default hr_api.g_varchar2
831: ,p_iid_information4 in varchar2 default hr_api.g_varchar2
832: ,p_iid_information5 in varchar2 default hr_api.g_varchar2
833: ,p_iid_information6 in varchar2 default hr_api.g_varchar2
834: ,p_iid_information7 in varchar2 default hr_api.g_varchar2
835: ,p_iid_information8 in varchar2 default hr_api.g_varchar2
836: ,p_iid_information9 in varchar2 default hr_api.g_varchar2
837: ,p_iid_information10 in varchar2 default hr_api.g_varchar2

Line 834: ,p_iid_information7 in varchar2 default hr_api.g_varchar2

830: ,p_iid_information3 in varchar2 default hr_api.g_varchar2
831: ,p_iid_information4 in varchar2 default hr_api.g_varchar2
832: ,p_iid_information5 in varchar2 default hr_api.g_varchar2
833: ,p_iid_information6 in varchar2 default hr_api.g_varchar2
834: ,p_iid_information7 in varchar2 default hr_api.g_varchar2
835: ,p_iid_information8 in varchar2 default hr_api.g_varchar2
836: ,p_iid_information9 in varchar2 default hr_api.g_varchar2
837: ,p_iid_information10 in varchar2 default hr_api.g_varchar2
838: ,p_iid_information11 in varchar2 default hr_api.g_varchar2

Line 835: ,p_iid_information8 in varchar2 default hr_api.g_varchar2

831: ,p_iid_information4 in varchar2 default hr_api.g_varchar2
832: ,p_iid_information5 in varchar2 default hr_api.g_varchar2
833: ,p_iid_information6 in varchar2 default hr_api.g_varchar2
834: ,p_iid_information7 in varchar2 default hr_api.g_varchar2
835: ,p_iid_information8 in varchar2 default hr_api.g_varchar2
836: ,p_iid_information9 in varchar2 default hr_api.g_varchar2
837: ,p_iid_information10 in varchar2 default hr_api.g_varchar2
838: ,p_iid_information11 in varchar2 default hr_api.g_varchar2
839: ,p_iid_information12 in varchar2 default hr_api.g_varchar2

Line 836: ,p_iid_information9 in varchar2 default hr_api.g_varchar2

832: ,p_iid_information5 in varchar2 default hr_api.g_varchar2
833: ,p_iid_information6 in varchar2 default hr_api.g_varchar2
834: ,p_iid_information7 in varchar2 default hr_api.g_varchar2
835: ,p_iid_information8 in varchar2 default hr_api.g_varchar2
836: ,p_iid_information9 in varchar2 default hr_api.g_varchar2
837: ,p_iid_information10 in varchar2 default hr_api.g_varchar2
838: ,p_iid_information11 in varchar2 default hr_api.g_varchar2
839: ,p_iid_information12 in varchar2 default hr_api.g_varchar2
840: ,p_iid_information13 in varchar2 default hr_api.g_varchar2

Line 837: ,p_iid_information10 in varchar2 default hr_api.g_varchar2

833: ,p_iid_information6 in varchar2 default hr_api.g_varchar2
834: ,p_iid_information7 in varchar2 default hr_api.g_varchar2
835: ,p_iid_information8 in varchar2 default hr_api.g_varchar2
836: ,p_iid_information9 in varchar2 default hr_api.g_varchar2
837: ,p_iid_information10 in varchar2 default hr_api.g_varchar2
838: ,p_iid_information11 in varchar2 default hr_api.g_varchar2
839: ,p_iid_information12 in varchar2 default hr_api.g_varchar2
840: ,p_iid_information13 in varchar2 default hr_api.g_varchar2
841: ,p_iid_information14 in varchar2 default hr_api.g_varchar2

Line 838: ,p_iid_information11 in varchar2 default hr_api.g_varchar2

834: ,p_iid_information7 in varchar2 default hr_api.g_varchar2
835: ,p_iid_information8 in varchar2 default hr_api.g_varchar2
836: ,p_iid_information9 in varchar2 default hr_api.g_varchar2
837: ,p_iid_information10 in varchar2 default hr_api.g_varchar2
838: ,p_iid_information11 in varchar2 default hr_api.g_varchar2
839: ,p_iid_information12 in varchar2 default hr_api.g_varchar2
840: ,p_iid_information13 in varchar2 default hr_api.g_varchar2
841: ,p_iid_information14 in varchar2 default hr_api.g_varchar2
842: ,p_iid_information15 in varchar2 default hr_api.g_varchar2

Line 839: ,p_iid_information12 in varchar2 default hr_api.g_varchar2

835: ,p_iid_information8 in varchar2 default hr_api.g_varchar2
836: ,p_iid_information9 in varchar2 default hr_api.g_varchar2
837: ,p_iid_information10 in varchar2 default hr_api.g_varchar2
838: ,p_iid_information11 in varchar2 default hr_api.g_varchar2
839: ,p_iid_information12 in varchar2 default hr_api.g_varchar2
840: ,p_iid_information13 in varchar2 default hr_api.g_varchar2
841: ,p_iid_information14 in varchar2 default hr_api.g_varchar2
842: ,p_iid_information15 in varchar2 default hr_api.g_varchar2
843: ,p_iid_information16 in varchar2 default hr_api.g_varchar2

Line 840: ,p_iid_information13 in varchar2 default hr_api.g_varchar2

836: ,p_iid_information9 in varchar2 default hr_api.g_varchar2
837: ,p_iid_information10 in varchar2 default hr_api.g_varchar2
838: ,p_iid_information11 in varchar2 default hr_api.g_varchar2
839: ,p_iid_information12 in varchar2 default hr_api.g_varchar2
840: ,p_iid_information13 in varchar2 default hr_api.g_varchar2
841: ,p_iid_information14 in varchar2 default hr_api.g_varchar2
842: ,p_iid_information15 in varchar2 default hr_api.g_varchar2
843: ,p_iid_information16 in varchar2 default hr_api.g_varchar2
844: ,p_iid_information17 in varchar2 default hr_api.g_varchar2

Line 841: ,p_iid_information14 in varchar2 default hr_api.g_varchar2

837: ,p_iid_information10 in varchar2 default hr_api.g_varchar2
838: ,p_iid_information11 in varchar2 default hr_api.g_varchar2
839: ,p_iid_information12 in varchar2 default hr_api.g_varchar2
840: ,p_iid_information13 in varchar2 default hr_api.g_varchar2
841: ,p_iid_information14 in varchar2 default hr_api.g_varchar2
842: ,p_iid_information15 in varchar2 default hr_api.g_varchar2
843: ,p_iid_information16 in varchar2 default hr_api.g_varchar2
844: ,p_iid_information17 in varchar2 default hr_api.g_varchar2
845: ,p_iid_information18 in varchar2 default hr_api.g_varchar2

Line 842: ,p_iid_information15 in varchar2 default hr_api.g_varchar2

838: ,p_iid_information11 in varchar2 default hr_api.g_varchar2
839: ,p_iid_information12 in varchar2 default hr_api.g_varchar2
840: ,p_iid_information13 in varchar2 default hr_api.g_varchar2
841: ,p_iid_information14 in varchar2 default hr_api.g_varchar2
842: ,p_iid_information15 in varchar2 default hr_api.g_varchar2
843: ,p_iid_information16 in varchar2 default hr_api.g_varchar2
844: ,p_iid_information17 in varchar2 default hr_api.g_varchar2
845: ,p_iid_information18 in varchar2 default hr_api.g_varchar2
846: ,p_iid_information19 in varchar2 default hr_api.g_varchar2

Line 843: ,p_iid_information16 in varchar2 default hr_api.g_varchar2

839: ,p_iid_information12 in varchar2 default hr_api.g_varchar2
840: ,p_iid_information13 in varchar2 default hr_api.g_varchar2
841: ,p_iid_information14 in varchar2 default hr_api.g_varchar2
842: ,p_iid_information15 in varchar2 default hr_api.g_varchar2
843: ,p_iid_information16 in varchar2 default hr_api.g_varchar2
844: ,p_iid_information17 in varchar2 default hr_api.g_varchar2
845: ,p_iid_information18 in varchar2 default hr_api.g_varchar2
846: ,p_iid_information19 in varchar2 default hr_api.g_varchar2
847: ,p_iid_information20 in varchar2 default hr_api.g_varchar2

Line 844: ,p_iid_information17 in varchar2 default hr_api.g_varchar2

840: ,p_iid_information13 in varchar2 default hr_api.g_varchar2
841: ,p_iid_information14 in varchar2 default hr_api.g_varchar2
842: ,p_iid_information15 in varchar2 default hr_api.g_varchar2
843: ,p_iid_information16 in varchar2 default hr_api.g_varchar2
844: ,p_iid_information17 in varchar2 default hr_api.g_varchar2
845: ,p_iid_information18 in varchar2 default hr_api.g_varchar2
846: ,p_iid_information19 in varchar2 default hr_api.g_varchar2
847: ,p_iid_information20 in varchar2 default hr_api.g_varchar2
848: ,p_event_id in number default hr_api.g_number

Line 845: ,p_iid_information18 in varchar2 default hr_api.g_varchar2

841: ,p_iid_information14 in varchar2 default hr_api.g_varchar2
842: ,p_iid_information15 in varchar2 default hr_api.g_varchar2
843: ,p_iid_information16 in varchar2 default hr_api.g_varchar2
844: ,p_iid_information17 in varchar2 default hr_api.g_varchar2
845: ,p_iid_information18 in varchar2 default hr_api.g_varchar2
846: ,p_iid_information19 in varchar2 default hr_api.g_varchar2
847: ,p_iid_information20 in varchar2 default hr_api.g_varchar2
848: ,p_event_id in number default hr_api.g_number
849: ,p_start_date out nocopy date

Line 846: ,p_iid_information19 in varchar2 default hr_api.g_varchar2

842: ,p_iid_information15 in varchar2 default hr_api.g_varchar2
843: ,p_iid_information16 in varchar2 default hr_api.g_varchar2
844: ,p_iid_information17 in varchar2 default hr_api.g_varchar2
845: ,p_iid_information18 in varchar2 default hr_api.g_varchar2
846: ,p_iid_information19 in varchar2 default hr_api.g_varchar2
847: ,p_iid_information20 in varchar2 default hr_api.g_varchar2
848: ,p_event_id in number default hr_api.g_number
849: ,p_start_date out nocopy date
850: ,p_end_date out nocopy date

Line 847: ,p_iid_information20 in varchar2 default hr_api.g_varchar2

843: ,p_iid_information16 in varchar2 default hr_api.g_varchar2
844: ,p_iid_information17 in varchar2 default hr_api.g_varchar2
845: ,p_iid_information18 in varchar2 default hr_api.g_varchar2
846: ,p_iid_information19 in varchar2 default hr_api.g_varchar2
847: ,p_iid_information20 in varchar2 default hr_api.g_varchar2
848: ,p_event_id in number default hr_api.g_number
849: ,p_start_date out nocopy date
850: ,p_end_date out nocopy date
851: ) is

Line 848: ,p_event_id in number default hr_api.g_number

844: ,p_iid_information17 in varchar2 default hr_api.g_varchar2
845: ,p_iid_information18 in varchar2 default hr_api.g_varchar2
846: ,p_iid_information19 in varchar2 default hr_api.g_varchar2
847: ,p_iid_information20 in varchar2 default hr_api.g_varchar2
848: ,p_event_id in number default hr_api.g_number
849: ,p_start_date out nocopy date
850: ,p_end_date out nocopy date
851: ) is
852: --