APPS.IRC_IID_BUS dependencies on HR_API

Line 97: nvl(irc_iid_shd.g_old_rec.iid_information_category, hr_api.g_varchar2) <>

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

Line 98: nvl(p_rec.iid_information_category, hr_api.g_varchar2) or

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

Line 99: nvl(irc_iid_shd.g_old_rec.iid_information1, hr_api.g_varchar2) <>

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

Line 100: nvl(p_rec.iid_information1, hr_api.g_varchar2) or

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

Line 101: nvl(irc_iid_shd.g_old_rec.iid_information2, hr_api.g_varchar2) <>

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

Line 102: nvl(p_rec.iid_information2, hr_api.g_varchar2) or

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

Line 103: nvl(irc_iid_shd.g_old_rec.iid_information3, hr_api.g_varchar2) <>

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

Line 104: nvl(p_rec.iid_information3, hr_api.g_varchar2) or

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

Line 105: nvl(irc_iid_shd.g_old_rec.iid_information4, hr_api.g_varchar2) <>

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

Line 106: nvl(p_rec.iid_information4, hr_api.g_varchar2) or

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

Line 107: nvl(irc_iid_shd.g_old_rec.iid_information5, hr_api.g_varchar2) <>

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

Line 108: nvl(p_rec.iid_information5, hr_api.g_varchar2) or

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

Line 109: nvl(irc_iid_shd.g_old_rec.iid_information6, hr_api.g_varchar2) <>

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

Line 110: nvl(p_rec.iid_information6, hr_api.g_varchar2) or

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

Line 111: nvl(irc_iid_shd.g_old_rec.iid_information7, hr_api.g_varchar2) <>

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

Line 112: nvl(p_rec.iid_information7, hr_api.g_varchar2) or

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

Line 113: nvl(irc_iid_shd.g_old_rec.iid_information8, hr_api.g_varchar2) <>

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

Line 114: nvl(p_rec.iid_information8, hr_api.g_varchar2) or

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

Line 115: nvl(irc_iid_shd.g_old_rec.iid_information9, hr_api.g_varchar2) <>

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

Line 116: nvl(p_rec.iid_information9, hr_api.g_varchar2) or

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

Line 117: nvl(irc_iid_shd.g_old_rec.iid_information10, hr_api.g_varchar2) <>

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

Line 118: nvl(p_rec.iid_information10, hr_api.g_varchar2) or

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

Line 119: nvl(irc_iid_shd.g_old_rec.iid_information11, hr_api.g_varchar2) <>

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

Line 120: nvl(p_rec.iid_information11, hr_api.g_varchar2) or

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

Line 121: nvl(irc_iid_shd.g_old_rec.iid_information12, hr_api.g_varchar2) <>

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

Line 122: nvl(p_rec.iid_information12, hr_api.g_varchar2) or

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

Line 123: nvl(irc_iid_shd.g_old_rec.iid_information13, hr_api.g_varchar2) <>

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

Line 124: nvl(p_rec.iid_information13, hr_api.g_varchar2) or

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

Line 125: nvl(irc_iid_shd.g_old_rec.iid_information14, hr_api.g_varchar2) <>

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

Line 126: nvl(p_rec.iid_information14, hr_api.g_varchar2) or

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

Line 127: nvl(irc_iid_shd.g_old_rec.iid_information15, hr_api.g_varchar2) <>

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

Line 128: nvl(p_rec.iid_information15, hr_api.g_varchar2) or

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

Line 129: nvl(irc_iid_shd.g_old_rec.iid_information16, hr_api.g_varchar2) <>

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

Line 130: nvl(p_rec.iid_information16, hr_api.g_varchar2) or

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

Line 131: nvl(irc_iid_shd.g_old_rec.iid_information17, hr_api.g_varchar2) <>

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

Line 132: nvl(p_rec.iid_information17, hr_api.g_varchar2) or

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

Line 133: nvl(irc_iid_shd.g_old_rec.iid_information18, hr_api.g_varchar2) <>

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

Line 134: nvl(p_rec.iid_information18, hr_api.g_varchar2) or

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

Line 135: nvl(irc_iid_shd.g_old_rec.iid_information19, 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

Line 136: nvl(p_rec.iid_information19, hr_api.g_varchar2) or

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

Line 137: nvl(irc_iid_shd.g_old_rec.iid_information20, hr_api.g_varchar2) <>

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:

Line 138: nvl(p_rec.iid_information20, 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:
142: -- a) During update, the structure column value or any

Line 253: hr_api.argument_changed_error

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

Line 304: hr_api.mandatory_arg_error

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

Line 314: hr_api.mandatory_arg_error

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

Line 320: /*hr_api.mandatory_arg_error

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: );*/

Line 386: hr_api.mandatory_arg_error

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

Line 395: If (p_datetrack_mode = hr_api.g_delete or

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

Line 396: p_datetrack_mode = hr_api.g_zap) then

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

Line 401: hr_api.mandatory_arg_error

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

Line 407: /*hr_api.mandatory_arg_error

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: );*/

Line 413: hr_api.mandatory_arg_error

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

Line 450: l_not_exists := hr_api.not_exists_in_hr_lookups

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

Line 479: l_not_exists := hr_api.not_exists_in_hr_lookups

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