93: begin
94: hr_utility.set_location('Entering:'||l_proc,10);
95: --
96: if ((p_rec.interview_details_id is not null) and (
97: nvl(irc_iid_shd.g_old_rec.iid_information_category, hr_api.g_varchar2) <>
98: nvl(p_rec.iid_information_category, hr_api.g_varchar2) or
99: nvl(irc_iid_shd.g_old_rec.iid_information1, hr_api.g_varchar2) <>
100: nvl(p_rec.iid_information1, hr_api.g_varchar2) or
101: nvl(irc_iid_shd.g_old_rec.iid_information2, hr_api.g_varchar2) <>
94: hr_utility.set_location('Entering:'||l_proc,10);
95: --
96: if ((p_rec.interview_details_id is not null) and (
97: nvl(irc_iid_shd.g_old_rec.iid_information_category, hr_api.g_varchar2) <>
98: nvl(p_rec.iid_information_category, hr_api.g_varchar2) or
99: nvl(irc_iid_shd.g_old_rec.iid_information1, hr_api.g_varchar2) <>
100: nvl(p_rec.iid_information1, hr_api.g_varchar2) or
101: nvl(irc_iid_shd.g_old_rec.iid_information2, hr_api.g_varchar2) <>
102: nvl(p_rec.iid_information2, hr_api.g_varchar2) or
95: --
96: if ((p_rec.interview_details_id is not null) and (
97: nvl(irc_iid_shd.g_old_rec.iid_information_category, hr_api.g_varchar2) <>
98: nvl(p_rec.iid_information_category, hr_api.g_varchar2) or
99: nvl(irc_iid_shd.g_old_rec.iid_information1, hr_api.g_varchar2) <>
100: nvl(p_rec.iid_information1, hr_api.g_varchar2) or
101: nvl(irc_iid_shd.g_old_rec.iid_information2, hr_api.g_varchar2) <>
102: nvl(p_rec.iid_information2, hr_api.g_varchar2) or
103: nvl(irc_iid_shd.g_old_rec.iid_information3, hr_api.g_varchar2) <>
96: if ((p_rec.interview_details_id is not null) and (
97: nvl(irc_iid_shd.g_old_rec.iid_information_category, hr_api.g_varchar2) <>
98: nvl(p_rec.iid_information_category, hr_api.g_varchar2) or
99: nvl(irc_iid_shd.g_old_rec.iid_information1, hr_api.g_varchar2) <>
100: nvl(p_rec.iid_information1, hr_api.g_varchar2) or
101: nvl(irc_iid_shd.g_old_rec.iid_information2, hr_api.g_varchar2) <>
102: nvl(p_rec.iid_information2, hr_api.g_varchar2) or
103: nvl(irc_iid_shd.g_old_rec.iid_information3, hr_api.g_varchar2) <>
104: nvl(p_rec.iid_information3, hr_api.g_varchar2) or
97: nvl(irc_iid_shd.g_old_rec.iid_information_category, hr_api.g_varchar2) <>
98: nvl(p_rec.iid_information_category, hr_api.g_varchar2) or
99: nvl(irc_iid_shd.g_old_rec.iid_information1, hr_api.g_varchar2) <>
100: nvl(p_rec.iid_information1, hr_api.g_varchar2) or
101: nvl(irc_iid_shd.g_old_rec.iid_information2, hr_api.g_varchar2) <>
102: nvl(p_rec.iid_information2, hr_api.g_varchar2) or
103: nvl(irc_iid_shd.g_old_rec.iid_information3, hr_api.g_varchar2) <>
104: nvl(p_rec.iid_information3, hr_api.g_varchar2) or
105: nvl(irc_iid_shd.g_old_rec.iid_information4, hr_api.g_varchar2) <>
98: nvl(p_rec.iid_information_category, hr_api.g_varchar2) or
99: nvl(irc_iid_shd.g_old_rec.iid_information1, hr_api.g_varchar2) <>
100: nvl(p_rec.iid_information1, hr_api.g_varchar2) or
101: nvl(irc_iid_shd.g_old_rec.iid_information2, hr_api.g_varchar2) <>
102: nvl(p_rec.iid_information2, hr_api.g_varchar2) or
103: nvl(irc_iid_shd.g_old_rec.iid_information3, hr_api.g_varchar2) <>
104: nvl(p_rec.iid_information3, hr_api.g_varchar2) or
105: nvl(irc_iid_shd.g_old_rec.iid_information4, hr_api.g_varchar2) <>
106: nvl(p_rec.iid_information4, hr_api.g_varchar2) or
99: nvl(irc_iid_shd.g_old_rec.iid_information1, hr_api.g_varchar2) <>
100: nvl(p_rec.iid_information1, hr_api.g_varchar2) or
101: nvl(irc_iid_shd.g_old_rec.iid_information2, hr_api.g_varchar2) <>
102: nvl(p_rec.iid_information2, hr_api.g_varchar2) or
103: nvl(irc_iid_shd.g_old_rec.iid_information3, hr_api.g_varchar2) <>
104: nvl(p_rec.iid_information3, hr_api.g_varchar2) or
105: nvl(irc_iid_shd.g_old_rec.iid_information4, hr_api.g_varchar2) <>
106: nvl(p_rec.iid_information4, hr_api.g_varchar2) or
107: nvl(irc_iid_shd.g_old_rec.iid_information5, hr_api.g_varchar2) <>
100: nvl(p_rec.iid_information1, hr_api.g_varchar2) or
101: nvl(irc_iid_shd.g_old_rec.iid_information2, hr_api.g_varchar2) <>
102: nvl(p_rec.iid_information2, hr_api.g_varchar2) or
103: nvl(irc_iid_shd.g_old_rec.iid_information3, hr_api.g_varchar2) <>
104: nvl(p_rec.iid_information3, hr_api.g_varchar2) or
105: nvl(irc_iid_shd.g_old_rec.iid_information4, hr_api.g_varchar2) <>
106: nvl(p_rec.iid_information4, hr_api.g_varchar2) or
107: nvl(irc_iid_shd.g_old_rec.iid_information5, hr_api.g_varchar2) <>
108: nvl(p_rec.iid_information5, hr_api.g_varchar2) or
101: nvl(irc_iid_shd.g_old_rec.iid_information2, hr_api.g_varchar2) <>
102: nvl(p_rec.iid_information2, hr_api.g_varchar2) or
103: nvl(irc_iid_shd.g_old_rec.iid_information3, hr_api.g_varchar2) <>
104: nvl(p_rec.iid_information3, hr_api.g_varchar2) or
105: nvl(irc_iid_shd.g_old_rec.iid_information4, hr_api.g_varchar2) <>
106: nvl(p_rec.iid_information4, hr_api.g_varchar2) or
107: nvl(irc_iid_shd.g_old_rec.iid_information5, hr_api.g_varchar2) <>
108: nvl(p_rec.iid_information5, hr_api.g_varchar2) or
109: nvl(irc_iid_shd.g_old_rec.iid_information6, hr_api.g_varchar2) <>
102: nvl(p_rec.iid_information2, hr_api.g_varchar2) or
103: nvl(irc_iid_shd.g_old_rec.iid_information3, hr_api.g_varchar2) <>
104: nvl(p_rec.iid_information3, hr_api.g_varchar2) or
105: nvl(irc_iid_shd.g_old_rec.iid_information4, hr_api.g_varchar2) <>
106: nvl(p_rec.iid_information4, hr_api.g_varchar2) or
107: nvl(irc_iid_shd.g_old_rec.iid_information5, hr_api.g_varchar2) <>
108: nvl(p_rec.iid_information5, hr_api.g_varchar2) or
109: nvl(irc_iid_shd.g_old_rec.iid_information6, hr_api.g_varchar2) <>
110: nvl(p_rec.iid_information6, hr_api.g_varchar2) or
103: nvl(irc_iid_shd.g_old_rec.iid_information3, hr_api.g_varchar2) <>
104: nvl(p_rec.iid_information3, hr_api.g_varchar2) or
105: nvl(irc_iid_shd.g_old_rec.iid_information4, hr_api.g_varchar2) <>
106: nvl(p_rec.iid_information4, hr_api.g_varchar2) or
107: nvl(irc_iid_shd.g_old_rec.iid_information5, hr_api.g_varchar2) <>
108: nvl(p_rec.iid_information5, hr_api.g_varchar2) or
109: nvl(irc_iid_shd.g_old_rec.iid_information6, hr_api.g_varchar2) <>
110: nvl(p_rec.iid_information6, hr_api.g_varchar2) or
111: nvl(irc_iid_shd.g_old_rec.iid_information7, hr_api.g_varchar2) <>
104: nvl(p_rec.iid_information3, hr_api.g_varchar2) or
105: nvl(irc_iid_shd.g_old_rec.iid_information4, hr_api.g_varchar2) <>
106: nvl(p_rec.iid_information4, hr_api.g_varchar2) or
107: nvl(irc_iid_shd.g_old_rec.iid_information5, hr_api.g_varchar2) <>
108: nvl(p_rec.iid_information5, hr_api.g_varchar2) or
109: nvl(irc_iid_shd.g_old_rec.iid_information6, hr_api.g_varchar2) <>
110: nvl(p_rec.iid_information6, hr_api.g_varchar2) or
111: nvl(irc_iid_shd.g_old_rec.iid_information7, hr_api.g_varchar2) <>
112: nvl(p_rec.iid_information7, hr_api.g_varchar2) or
105: nvl(irc_iid_shd.g_old_rec.iid_information4, hr_api.g_varchar2) <>
106: nvl(p_rec.iid_information4, hr_api.g_varchar2) or
107: nvl(irc_iid_shd.g_old_rec.iid_information5, hr_api.g_varchar2) <>
108: nvl(p_rec.iid_information5, hr_api.g_varchar2) or
109: nvl(irc_iid_shd.g_old_rec.iid_information6, hr_api.g_varchar2) <>
110: nvl(p_rec.iid_information6, hr_api.g_varchar2) or
111: nvl(irc_iid_shd.g_old_rec.iid_information7, hr_api.g_varchar2) <>
112: nvl(p_rec.iid_information7, hr_api.g_varchar2) or
113: nvl(irc_iid_shd.g_old_rec.iid_information8, hr_api.g_varchar2) <>
106: nvl(p_rec.iid_information4, hr_api.g_varchar2) or
107: nvl(irc_iid_shd.g_old_rec.iid_information5, hr_api.g_varchar2) <>
108: nvl(p_rec.iid_information5, hr_api.g_varchar2) or
109: nvl(irc_iid_shd.g_old_rec.iid_information6, hr_api.g_varchar2) <>
110: nvl(p_rec.iid_information6, hr_api.g_varchar2) or
111: nvl(irc_iid_shd.g_old_rec.iid_information7, hr_api.g_varchar2) <>
112: nvl(p_rec.iid_information7, hr_api.g_varchar2) or
113: nvl(irc_iid_shd.g_old_rec.iid_information8, hr_api.g_varchar2) <>
114: nvl(p_rec.iid_information8, hr_api.g_varchar2) or
107: nvl(irc_iid_shd.g_old_rec.iid_information5, hr_api.g_varchar2) <>
108: nvl(p_rec.iid_information5, hr_api.g_varchar2) or
109: nvl(irc_iid_shd.g_old_rec.iid_information6, hr_api.g_varchar2) <>
110: nvl(p_rec.iid_information6, hr_api.g_varchar2) or
111: nvl(irc_iid_shd.g_old_rec.iid_information7, hr_api.g_varchar2) <>
112: nvl(p_rec.iid_information7, hr_api.g_varchar2) or
113: nvl(irc_iid_shd.g_old_rec.iid_information8, hr_api.g_varchar2) <>
114: nvl(p_rec.iid_information8, hr_api.g_varchar2) or
115: nvl(irc_iid_shd.g_old_rec.iid_information9, hr_api.g_varchar2) <>
108: nvl(p_rec.iid_information5, hr_api.g_varchar2) or
109: nvl(irc_iid_shd.g_old_rec.iid_information6, hr_api.g_varchar2) <>
110: nvl(p_rec.iid_information6, hr_api.g_varchar2) or
111: nvl(irc_iid_shd.g_old_rec.iid_information7, hr_api.g_varchar2) <>
112: nvl(p_rec.iid_information7, hr_api.g_varchar2) or
113: nvl(irc_iid_shd.g_old_rec.iid_information8, hr_api.g_varchar2) <>
114: nvl(p_rec.iid_information8, hr_api.g_varchar2) or
115: nvl(irc_iid_shd.g_old_rec.iid_information9, hr_api.g_varchar2) <>
116: nvl(p_rec.iid_information9, hr_api.g_varchar2) or
109: nvl(irc_iid_shd.g_old_rec.iid_information6, hr_api.g_varchar2) <>
110: nvl(p_rec.iid_information6, hr_api.g_varchar2) or
111: nvl(irc_iid_shd.g_old_rec.iid_information7, hr_api.g_varchar2) <>
112: nvl(p_rec.iid_information7, hr_api.g_varchar2) or
113: nvl(irc_iid_shd.g_old_rec.iid_information8, hr_api.g_varchar2) <>
114: nvl(p_rec.iid_information8, hr_api.g_varchar2) or
115: nvl(irc_iid_shd.g_old_rec.iid_information9, hr_api.g_varchar2) <>
116: nvl(p_rec.iid_information9, hr_api.g_varchar2) or
117: nvl(irc_iid_shd.g_old_rec.iid_information10, hr_api.g_varchar2) <>
110: nvl(p_rec.iid_information6, hr_api.g_varchar2) or
111: nvl(irc_iid_shd.g_old_rec.iid_information7, hr_api.g_varchar2) <>
112: nvl(p_rec.iid_information7, hr_api.g_varchar2) or
113: nvl(irc_iid_shd.g_old_rec.iid_information8, hr_api.g_varchar2) <>
114: nvl(p_rec.iid_information8, hr_api.g_varchar2) or
115: nvl(irc_iid_shd.g_old_rec.iid_information9, hr_api.g_varchar2) <>
116: nvl(p_rec.iid_information9, hr_api.g_varchar2) or
117: nvl(irc_iid_shd.g_old_rec.iid_information10, hr_api.g_varchar2) <>
118: nvl(p_rec.iid_information10, hr_api.g_varchar2) or
111: nvl(irc_iid_shd.g_old_rec.iid_information7, hr_api.g_varchar2) <>
112: nvl(p_rec.iid_information7, hr_api.g_varchar2) or
113: nvl(irc_iid_shd.g_old_rec.iid_information8, hr_api.g_varchar2) <>
114: nvl(p_rec.iid_information8, hr_api.g_varchar2) or
115: nvl(irc_iid_shd.g_old_rec.iid_information9, hr_api.g_varchar2) <>
116: nvl(p_rec.iid_information9, hr_api.g_varchar2) or
117: nvl(irc_iid_shd.g_old_rec.iid_information10, hr_api.g_varchar2) <>
118: nvl(p_rec.iid_information10, hr_api.g_varchar2) or
119: nvl(irc_iid_shd.g_old_rec.iid_information11, hr_api.g_varchar2) <>
112: nvl(p_rec.iid_information7, hr_api.g_varchar2) or
113: nvl(irc_iid_shd.g_old_rec.iid_information8, hr_api.g_varchar2) <>
114: nvl(p_rec.iid_information8, hr_api.g_varchar2) or
115: nvl(irc_iid_shd.g_old_rec.iid_information9, hr_api.g_varchar2) <>
116: nvl(p_rec.iid_information9, hr_api.g_varchar2) or
117: nvl(irc_iid_shd.g_old_rec.iid_information10, hr_api.g_varchar2) <>
118: nvl(p_rec.iid_information10, hr_api.g_varchar2) or
119: nvl(irc_iid_shd.g_old_rec.iid_information11, hr_api.g_varchar2) <>
120: nvl(p_rec.iid_information11, hr_api.g_varchar2) or
113: nvl(irc_iid_shd.g_old_rec.iid_information8, hr_api.g_varchar2) <>
114: nvl(p_rec.iid_information8, hr_api.g_varchar2) or
115: nvl(irc_iid_shd.g_old_rec.iid_information9, hr_api.g_varchar2) <>
116: nvl(p_rec.iid_information9, hr_api.g_varchar2) or
117: nvl(irc_iid_shd.g_old_rec.iid_information10, hr_api.g_varchar2) <>
118: nvl(p_rec.iid_information10, hr_api.g_varchar2) or
119: nvl(irc_iid_shd.g_old_rec.iid_information11, hr_api.g_varchar2) <>
120: nvl(p_rec.iid_information11, hr_api.g_varchar2) or
121: nvl(irc_iid_shd.g_old_rec.iid_information12, hr_api.g_varchar2) <>
114: nvl(p_rec.iid_information8, hr_api.g_varchar2) or
115: nvl(irc_iid_shd.g_old_rec.iid_information9, hr_api.g_varchar2) <>
116: nvl(p_rec.iid_information9, hr_api.g_varchar2) or
117: nvl(irc_iid_shd.g_old_rec.iid_information10, hr_api.g_varchar2) <>
118: nvl(p_rec.iid_information10, hr_api.g_varchar2) or
119: nvl(irc_iid_shd.g_old_rec.iid_information11, hr_api.g_varchar2) <>
120: nvl(p_rec.iid_information11, hr_api.g_varchar2) or
121: nvl(irc_iid_shd.g_old_rec.iid_information12, hr_api.g_varchar2) <>
122: nvl(p_rec.iid_information12, hr_api.g_varchar2) or
115: nvl(irc_iid_shd.g_old_rec.iid_information9, hr_api.g_varchar2) <>
116: nvl(p_rec.iid_information9, hr_api.g_varchar2) or
117: nvl(irc_iid_shd.g_old_rec.iid_information10, hr_api.g_varchar2) <>
118: nvl(p_rec.iid_information10, hr_api.g_varchar2) or
119: nvl(irc_iid_shd.g_old_rec.iid_information11, hr_api.g_varchar2) <>
120: nvl(p_rec.iid_information11, hr_api.g_varchar2) or
121: nvl(irc_iid_shd.g_old_rec.iid_information12, hr_api.g_varchar2) <>
122: nvl(p_rec.iid_information12, hr_api.g_varchar2) or
123: nvl(irc_iid_shd.g_old_rec.iid_information13, hr_api.g_varchar2) <>
116: nvl(p_rec.iid_information9, hr_api.g_varchar2) or
117: nvl(irc_iid_shd.g_old_rec.iid_information10, hr_api.g_varchar2) <>
118: nvl(p_rec.iid_information10, hr_api.g_varchar2) or
119: nvl(irc_iid_shd.g_old_rec.iid_information11, hr_api.g_varchar2) <>
120: nvl(p_rec.iid_information11, hr_api.g_varchar2) or
121: nvl(irc_iid_shd.g_old_rec.iid_information12, hr_api.g_varchar2) <>
122: nvl(p_rec.iid_information12, hr_api.g_varchar2) or
123: nvl(irc_iid_shd.g_old_rec.iid_information13, hr_api.g_varchar2) <>
124: nvl(p_rec.iid_information13, hr_api.g_varchar2) or
117: nvl(irc_iid_shd.g_old_rec.iid_information10, hr_api.g_varchar2) <>
118: nvl(p_rec.iid_information10, hr_api.g_varchar2) or
119: nvl(irc_iid_shd.g_old_rec.iid_information11, hr_api.g_varchar2) <>
120: nvl(p_rec.iid_information11, hr_api.g_varchar2) or
121: nvl(irc_iid_shd.g_old_rec.iid_information12, hr_api.g_varchar2) <>
122: nvl(p_rec.iid_information12, hr_api.g_varchar2) or
123: nvl(irc_iid_shd.g_old_rec.iid_information13, hr_api.g_varchar2) <>
124: nvl(p_rec.iid_information13, hr_api.g_varchar2) or
125: nvl(irc_iid_shd.g_old_rec.iid_information14, hr_api.g_varchar2) <>
118: nvl(p_rec.iid_information10, hr_api.g_varchar2) or
119: nvl(irc_iid_shd.g_old_rec.iid_information11, hr_api.g_varchar2) <>
120: nvl(p_rec.iid_information11, hr_api.g_varchar2) or
121: nvl(irc_iid_shd.g_old_rec.iid_information12, hr_api.g_varchar2) <>
122: nvl(p_rec.iid_information12, hr_api.g_varchar2) or
123: nvl(irc_iid_shd.g_old_rec.iid_information13, hr_api.g_varchar2) <>
124: nvl(p_rec.iid_information13, hr_api.g_varchar2) or
125: nvl(irc_iid_shd.g_old_rec.iid_information14, hr_api.g_varchar2) <>
126: nvl(p_rec.iid_information14, hr_api.g_varchar2) or
119: nvl(irc_iid_shd.g_old_rec.iid_information11, hr_api.g_varchar2) <>
120: nvl(p_rec.iid_information11, hr_api.g_varchar2) or
121: nvl(irc_iid_shd.g_old_rec.iid_information12, hr_api.g_varchar2) <>
122: nvl(p_rec.iid_information12, hr_api.g_varchar2) or
123: nvl(irc_iid_shd.g_old_rec.iid_information13, hr_api.g_varchar2) <>
124: nvl(p_rec.iid_information13, hr_api.g_varchar2) or
125: nvl(irc_iid_shd.g_old_rec.iid_information14, hr_api.g_varchar2) <>
126: nvl(p_rec.iid_information14, hr_api.g_varchar2) or
127: nvl(irc_iid_shd.g_old_rec.iid_information15, hr_api.g_varchar2) <>
120: nvl(p_rec.iid_information11, hr_api.g_varchar2) or
121: nvl(irc_iid_shd.g_old_rec.iid_information12, hr_api.g_varchar2) <>
122: nvl(p_rec.iid_information12, hr_api.g_varchar2) or
123: nvl(irc_iid_shd.g_old_rec.iid_information13, hr_api.g_varchar2) <>
124: nvl(p_rec.iid_information13, hr_api.g_varchar2) or
125: nvl(irc_iid_shd.g_old_rec.iid_information14, hr_api.g_varchar2) <>
126: nvl(p_rec.iid_information14, hr_api.g_varchar2) or
127: nvl(irc_iid_shd.g_old_rec.iid_information15, hr_api.g_varchar2) <>
128: nvl(p_rec.iid_information15, hr_api.g_varchar2) or
121: nvl(irc_iid_shd.g_old_rec.iid_information12, hr_api.g_varchar2) <>
122: nvl(p_rec.iid_information12, hr_api.g_varchar2) or
123: nvl(irc_iid_shd.g_old_rec.iid_information13, hr_api.g_varchar2) <>
124: nvl(p_rec.iid_information13, hr_api.g_varchar2) or
125: nvl(irc_iid_shd.g_old_rec.iid_information14, hr_api.g_varchar2) <>
126: nvl(p_rec.iid_information14, hr_api.g_varchar2) or
127: nvl(irc_iid_shd.g_old_rec.iid_information15, hr_api.g_varchar2) <>
128: nvl(p_rec.iid_information15, hr_api.g_varchar2) or
129: nvl(irc_iid_shd.g_old_rec.iid_information16, hr_api.g_varchar2) <>
122: nvl(p_rec.iid_information12, hr_api.g_varchar2) or
123: nvl(irc_iid_shd.g_old_rec.iid_information13, hr_api.g_varchar2) <>
124: nvl(p_rec.iid_information13, hr_api.g_varchar2) or
125: nvl(irc_iid_shd.g_old_rec.iid_information14, hr_api.g_varchar2) <>
126: nvl(p_rec.iid_information14, hr_api.g_varchar2) or
127: nvl(irc_iid_shd.g_old_rec.iid_information15, hr_api.g_varchar2) <>
128: nvl(p_rec.iid_information15, hr_api.g_varchar2) or
129: nvl(irc_iid_shd.g_old_rec.iid_information16, hr_api.g_varchar2) <>
130: nvl(p_rec.iid_information16, hr_api.g_varchar2) or
123: nvl(irc_iid_shd.g_old_rec.iid_information13, hr_api.g_varchar2) <>
124: nvl(p_rec.iid_information13, hr_api.g_varchar2) or
125: nvl(irc_iid_shd.g_old_rec.iid_information14, hr_api.g_varchar2) <>
126: nvl(p_rec.iid_information14, hr_api.g_varchar2) or
127: nvl(irc_iid_shd.g_old_rec.iid_information15, hr_api.g_varchar2) <>
128: nvl(p_rec.iid_information15, hr_api.g_varchar2) or
129: nvl(irc_iid_shd.g_old_rec.iid_information16, hr_api.g_varchar2) <>
130: nvl(p_rec.iid_information16, hr_api.g_varchar2) or
131: nvl(irc_iid_shd.g_old_rec.iid_information17, hr_api.g_varchar2) <>
124: nvl(p_rec.iid_information13, hr_api.g_varchar2) or
125: nvl(irc_iid_shd.g_old_rec.iid_information14, hr_api.g_varchar2) <>
126: nvl(p_rec.iid_information14, hr_api.g_varchar2) or
127: nvl(irc_iid_shd.g_old_rec.iid_information15, hr_api.g_varchar2) <>
128: nvl(p_rec.iid_information15, hr_api.g_varchar2) or
129: nvl(irc_iid_shd.g_old_rec.iid_information16, hr_api.g_varchar2) <>
130: nvl(p_rec.iid_information16, hr_api.g_varchar2) or
131: nvl(irc_iid_shd.g_old_rec.iid_information17, hr_api.g_varchar2) <>
132: nvl(p_rec.iid_information17, hr_api.g_varchar2) or
125: nvl(irc_iid_shd.g_old_rec.iid_information14, hr_api.g_varchar2) <>
126: nvl(p_rec.iid_information14, hr_api.g_varchar2) or
127: nvl(irc_iid_shd.g_old_rec.iid_information15, hr_api.g_varchar2) <>
128: nvl(p_rec.iid_information15, hr_api.g_varchar2) or
129: nvl(irc_iid_shd.g_old_rec.iid_information16, hr_api.g_varchar2) <>
130: nvl(p_rec.iid_information16, hr_api.g_varchar2) or
131: nvl(irc_iid_shd.g_old_rec.iid_information17, hr_api.g_varchar2) <>
132: nvl(p_rec.iid_information17, hr_api.g_varchar2) or
133: nvl(irc_iid_shd.g_old_rec.iid_information18, hr_api.g_varchar2) <>
126: nvl(p_rec.iid_information14, hr_api.g_varchar2) or
127: nvl(irc_iid_shd.g_old_rec.iid_information15, hr_api.g_varchar2) <>
128: nvl(p_rec.iid_information15, hr_api.g_varchar2) or
129: nvl(irc_iid_shd.g_old_rec.iid_information16, hr_api.g_varchar2) <>
130: nvl(p_rec.iid_information16, hr_api.g_varchar2) or
131: nvl(irc_iid_shd.g_old_rec.iid_information17, hr_api.g_varchar2) <>
132: nvl(p_rec.iid_information17, hr_api.g_varchar2) or
133: nvl(irc_iid_shd.g_old_rec.iid_information18, hr_api.g_varchar2) <>
134: nvl(p_rec.iid_information18, hr_api.g_varchar2) or
127: nvl(irc_iid_shd.g_old_rec.iid_information15, hr_api.g_varchar2) <>
128: nvl(p_rec.iid_information15, hr_api.g_varchar2) or
129: nvl(irc_iid_shd.g_old_rec.iid_information16, hr_api.g_varchar2) <>
130: nvl(p_rec.iid_information16, hr_api.g_varchar2) or
131: nvl(irc_iid_shd.g_old_rec.iid_information17, hr_api.g_varchar2) <>
132: nvl(p_rec.iid_information17, hr_api.g_varchar2) or
133: nvl(irc_iid_shd.g_old_rec.iid_information18, hr_api.g_varchar2) <>
134: nvl(p_rec.iid_information18, hr_api.g_varchar2) or
135: nvl(irc_iid_shd.g_old_rec.iid_information19, hr_api.g_varchar2) <>
128: nvl(p_rec.iid_information15, hr_api.g_varchar2) or
129: nvl(irc_iid_shd.g_old_rec.iid_information16, hr_api.g_varchar2) <>
130: nvl(p_rec.iid_information16, hr_api.g_varchar2) or
131: nvl(irc_iid_shd.g_old_rec.iid_information17, hr_api.g_varchar2) <>
132: nvl(p_rec.iid_information17, hr_api.g_varchar2) or
133: nvl(irc_iid_shd.g_old_rec.iid_information18, hr_api.g_varchar2) <>
134: nvl(p_rec.iid_information18, hr_api.g_varchar2) or
135: nvl(irc_iid_shd.g_old_rec.iid_information19, hr_api.g_varchar2) <>
136: nvl(p_rec.iid_information19, hr_api.g_varchar2) or
129: nvl(irc_iid_shd.g_old_rec.iid_information16, hr_api.g_varchar2) <>
130: nvl(p_rec.iid_information16, hr_api.g_varchar2) or
131: nvl(irc_iid_shd.g_old_rec.iid_information17, hr_api.g_varchar2) <>
132: nvl(p_rec.iid_information17, hr_api.g_varchar2) or
133: nvl(irc_iid_shd.g_old_rec.iid_information18, hr_api.g_varchar2) <>
134: nvl(p_rec.iid_information18, hr_api.g_varchar2) or
135: nvl(irc_iid_shd.g_old_rec.iid_information19, hr_api.g_varchar2) <>
136: nvl(p_rec.iid_information19, hr_api.g_varchar2) or
137: nvl(irc_iid_shd.g_old_rec.iid_information20, hr_api.g_varchar2) <>
130: nvl(p_rec.iid_information16, hr_api.g_varchar2) or
131: nvl(irc_iid_shd.g_old_rec.iid_information17, hr_api.g_varchar2) <>
132: nvl(p_rec.iid_information17, hr_api.g_varchar2) or
133: nvl(irc_iid_shd.g_old_rec.iid_information18, hr_api.g_varchar2) <>
134: nvl(p_rec.iid_information18, hr_api.g_varchar2) or
135: nvl(irc_iid_shd.g_old_rec.iid_information19, hr_api.g_varchar2) <>
136: nvl(p_rec.iid_information19, hr_api.g_varchar2) or
137: nvl(irc_iid_shd.g_old_rec.iid_information20, hr_api.g_varchar2) <>
138: nvl(p_rec.iid_information20, hr_api.g_varchar2) ))
131: nvl(irc_iid_shd.g_old_rec.iid_information17, hr_api.g_varchar2) <>
132: nvl(p_rec.iid_information17, hr_api.g_varchar2) or
133: nvl(irc_iid_shd.g_old_rec.iid_information18, hr_api.g_varchar2) <>
134: nvl(p_rec.iid_information18, hr_api.g_varchar2) or
135: nvl(irc_iid_shd.g_old_rec.iid_information19, hr_api.g_varchar2) <>
136: nvl(p_rec.iid_information19, hr_api.g_varchar2) or
137: nvl(irc_iid_shd.g_old_rec.iid_information20, hr_api.g_varchar2) <>
138: nvl(p_rec.iid_information20, hr_api.g_varchar2) ))
139: or (p_rec.event_id is null) then
132: nvl(p_rec.iid_information17, hr_api.g_varchar2) or
133: nvl(irc_iid_shd.g_old_rec.iid_information18, hr_api.g_varchar2) <>
134: nvl(p_rec.iid_information18, hr_api.g_varchar2) or
135: nvl(irc_iid_shd.g_old_rec.iid_information19, hr_api.g_varchar2) <>
136: nvl(p_rec.iid_information19, hr_api.g_varchar2) or
137: nvl(irc_iid_shd.g_old_rec.iid_information20, hr_api.g_varchar2) <>
138: nvl(p_rec.iid_information20, hr_api.g_varchar2) ))
139: or (p_rec.event_id is null) then
140: --
133: nvl(irc_iid_shd.g_old_rec.iid_information18, hr_api.g_varchar2) <>
134: nvl(p_rec.iid_information18, hr_api.g_varchar2) or
135: nvl(irc_iid_shd.g_old_rec.iid_information19, hr_api.g_varchar2) <>
136: nvl(p_rec.iid_information19, hr_api.g_varchar2) or
137: nvl(irc_iid_shd.g_old_rec.iid_information20, hr_api.g_varchar2) <>
138: nvl(p_rec.iid_information20, hr_api.g_varchar2) ))
139: or (p_rec.event_id is null) then
140: --
141: -- Only execute the validation if absolutely necessary:
134: nvl(p_rec.iid_information18, hr_api.g_varchar2) or
135: nvl(irc_iid_shd.g_old_rec.iid_information19, hr_api.g_varchar2) <>
136: nvl(p_rec.iid_information19, hr_api.g_varchar2) or
137: nvl(irc_iid_shd.g_old_rec.iid_information20, hr_api.g_varchar2) <>
138: nvl(p_rec.iid_information20, hr_api.g_varchar2) ))
139: or (p_rec.event_id is null) then
140: --
141: -- Only execute the validation if absolutely necessary:
142: -- a) During update, the structure column value or any
249: -- not been updated.
250: --
251: if p_rec.event_id <> irc_iid_shd.g_old_rec.event_id
252: then
253: hr_api.argument_changed_error
254: (p_api_name => l_proc
255: ,p_argument => 'EVENT_ID'
256: ,p_base_table => irc_iid_shd.g_tab_name
257: );
300: Begin
301: --
302: -- Ensure that the p_datetrack_mode argument is not null
303: --
304: hr_api.mandatory_arg_error
305: (p_api_name => l_proc
306: ,p_argument => 'datetrack_mode'
307: ,p_argument_value => p_datetrack_mode
308: );
310: -- Mode will be valid, as this is checked at the start of the upd.
311: --
312: -- Ensure the arguments are not null
313: --
314: hr_api.mandatory_arg_error
315: (p_api_name => l_proc
316: ,p_argument => 'validation_start_date'
317: ,p_argument_value => p_validation_start_date
318: );
316: ,p_argument => 'validation_start_date'
317: ,p_argument_value => p_validation_start_date
318: );
319: --
320: /*hr_api.mandatory_arg_error
321: (p_api_name => l_proc
322: ,p_argument => 'validation_end_date'
323: ,p_argument_value => p_validation_end_date
324: );*/
382: Begin
383: --
384: -- Ensure that the p_datetrack_mode argument is not null
385: --
386: hr_api.mandatory_arg_error
387: (p_api_name => l_proc
388: ,p_argument => 'datetrack_mode'
389: ,p_argument_value => p_datetrack_mode
390: );
391: --
392: -- Only perform the validation if the datetrack mode is either
393: -- DELETE or ZAP
394: --
395: If (p_datetrack_mode = hr_api.g_delete or
396: p_datetrack_mode = hr_api.g_zap) then
397: --
398: --
399: -- Ensure the arguments are not null
392: -- Only perform the validation if the datetrack mode is either
393: -- DELETE or ZAP
394: --
395: If (p_datetrack_mode = hr_api.g_delete or
396: p_datetrack_mode = hr_api.g_zap) then
397: --
398: --
399: -- Ensure the arguments are not null
400: --
397: --
398: --
399: -- Ensure the arguments are not null
400: --
401: hr_api.mandatory_arg_error
402: (p_api_name => l_proc
403: ,p_argument => 'validation_start_date'
404: ,p_argument_value => p_validation_start_date
405: );
403: ,p_argument => 'validation_start_date'
404: ,p_argument_value => p_validation_start_date
405: );
406: --
407: /*hr_api.mandatory_arg_error
408: (p_api_name => l_proc
409: ,p_argument => 'validation_end_date'
410: ,p_argument_value => p_validation_end_date
411: );*/
409: ,p_argument => 'validation_end_date'
410: ,p_argument_value => p_validation_end_date
411: );*/
412: --
413: hr_api.mandatory_arg_error
414: (p_api_name => l_proc
415: ,p_argument => 'interview_details_id'
416: ,p_argument_value => p_interview_details_id
417: );
446: l_not_exists boolean;
447: Begin
448: hr_utility.set_location('Entering:'||l_proc, 5);
449: --
450: l_not_exists := hr_api.not_exists_in_hr_lookups
451: (p_effective_date
452: ,'IRC_INTERVIEW_STATUS'
453: ,p_rec.status
454: );
475: --
476: Begin
477: hr_utility.set_location('Entering:'||l_proc, 5);
478: --
479: l_not_exists := hr_api.not_exists_in_hr_lookups
480: (p_effective_date
481: ,'IRC_INTERVIEW_RESULTS'
482: ,p_rec.result
483: );