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_ISC_BUS dependencies on IRC_ISC_SHD

Line 104: (p_rec in irc_isc_shd.g_rec_type

100: -- Internal Row Handler Use Only.
101: --
102: -- ----------------------------------------------------------------------------
103: procedure chk_ddf
104: (p_rec in irc_isc_shd.g_rec_type
105: ) is
106: --
107: l_proc varchar2(72) := g_package || 'chk_ddf';
108: --

Line 113: nvl(irc_isc_shd.g_old_rec.isc_information_category, hr_api.g_varchar2) <>

109: begin
110: hr_utility.set_location('Entering:'||l_proc,10);
111: --
112: if ((p_rec.search_criteria_id is not null) and (
113: nvl(irc_isc_shd.g_old_rec.isc_information_category, hr_api.g_varchar2) <>
114: nvl(p_rec.isc_information_category, hr_api.g_varchar2) or
115: nvl(irc_isc_shd.g_old_rec.isc_information1, hr_api.g_varchar2) <>
116: nvl(p_rec.isc_information1, hr_api.g_varchar2) or
117: nvl(irc_isc_shd.g_old_rec.isc_information2, hr_api.g_varchar2) <>

Line 115: nvl(irc_isc_shd.g_old_rec.isc_information1, hr_api.g_varchar2) <>

111: --
112: if ((p_rec.search_criteria_id is not null) and (
113: nvl(irc_isc_shd.g_old_rec.isc_information_category, hr_api.g_varchar2) <>
114: nvl(p_rec.isc_information_category, hr_api.g_varchar2) or
115: nvl(irc_isc_shd.g_old_rec.isc_information1, hr_api.g_varchar2) <>
116: nvl(p_rec.isc_information1, hr_api.g_varchar2) or
117: nvl(irc_isc_shd.g_old_rec.isc_information2, hr_api.g_varchar2) <>
118: nvl(p_rec.isc_information2, hr_api.g_varchar2) or
119: nvl(irc_isc_shd.g_old_rec.isc_information3, hr_api.g_varchar2) <>

Line 117: nvl(irc_isc_shd.g_old_rec.isc_information2, hr_api.g_varchar2) <>

113: nvl(irc_isc_shd.g_old_rec.isc_information_category, hr_api.g_varchar2) <>
114: nvl(p_rec.isc_information_category, hr_api.g_varchar2) or
115: nvl(irc_isc_shd.g_old_rec.isc_information1, hr_api.g_varchar2) <>
116: nvl(p_rec.isc_information1, hr_api.g_varchar2) or
117: nvl(irc_isc_shd.g_old_rec.isc_information2, hr_api.g_varchar2) <>
118: nvl(p_rec.isc_information2, hr_api.g_varchar2) or
119: nvl(irc_isc_shd.g_old_rec.isc_information3, hr_api.g_varchar2) <>
120: nvl(p_rec.isc_information3, hr_api.g_varchar2) or
121: nvl(irc_isc_shd.g_old_rec.isc_information4, hr_api.g_varchar2) <>

Line 119: nvl(irc_isc_shd.g_old_rec.isc_information3, hr_api.g_varchar2) <>

115: nvl(irc_isc_shd.g_old_rec.isc_information1, hr_api.g_varchar2) <>
116: nvl(p_rec.isc_information1, hr_api.g_varchar2) or
117: nvl(irc_isc_shd.g_old_rec.isc_information2, hr_api.g_varchar2) <>
118: nvl(p_rec.isc_information2, hr_api.g_varchar2) or
119: nvl(irc_isc_shd.g_old_rec.isc_information3, hr_api.g_varchar2) <>
120: nvl(p_rec.isc_information3, hr_api.g_varchar2) or
121: nvl(irc_isc_shd.g_old_rec.isc_information4, hr_api.g_varchar2) <>
122: nvl(p_rec.isc_information4, hr_api.g_varchar2) or
123: nvl(irc_isc_shd.g_old_rec.isc_information5, hr_api.g_varchar2) <>

Line 121: nvl(irc_isc_shd.g_old_rec.isc_information4, hr_api.g_varchar2) <>

117: nvl(irc_isc_shd.g_old_rec.isc_information2, hr_api.g_varchar2) <>
118: nvl(p_rec.isc_information2, hr_api.g_varchar2) or
119: nvl(irc_isc_shd.g_old_rec.isc_information3, hr_api.g_varchar2) <>
120: nvl(p_rec.isc_information3, hr_api.g_varchar2) or
121: nvl(irc_isc_shd.g_old_rec.isc_information4, hr_api.g_varchar2) <>
122: nvl(p_rec.isc_information4, hr_api.g_varchar2) or
123: nvl(irc_isc_shd.g_old_rec.isc_information5, hr_api.g_varchar2) <>
124: nvl(p_rec.isc_information5, hr_api.g_varchar2) or
125: nvl(irc_isc_shd.g_old_rec.isc_information6, hr_api.g_varchar2) <>

Line 123: nvl(irc_isc_shd.g_old_rec.isc_information5, hr_api.g_varchar2) <>

119: nvl(irc_isc_shd.g_old_rec.isc_information3, hr_api.g_varchar2) <>
120: nvl(p_rec.isc_information3, hr_api.g_varchar2) or
121: nvl(irc_isc_shd.g_old_rec.isc_information4, hr_api.g_varchar2) <>
122: nvl(p_rec.isc_information4, hr_api.g_varchar2) or
123: nvl(irc_isc_shd.g_old_rec.isc_information5, hr_api.g_varchar2) <>
124: nvl(p_rec.isc_information5, hr_api.g_varchar2) or
125: nvl(irc_isc_shd.g_old_rec.isc_information6, hr_api.g_varchar2) <>
126: nvl(p_rec.isc_information6, hr_api.g_varchar2) or
127: nvl(irc_isc_shd.g_old_rec.isc_information7, hr_api.g_varchar2) <>

Line 125: nvl(irc_isc_shd.g_old_rec.isc_information6, hr_api.g_varchar2) <>

121: nvl(irc_isc_shd.g_old_rec.isc_information4, hr_api.g_varchar2) <>
122: nvl(p_rec.isc_information4, hr_api.g_varchar2) or
123: nvl(irc_isc_shd.g_old_rec.isc_information5, hr_api.g_varchar2) <>
124: nvl(p_rec.isc_information5, hr_api.g_varchar2) or
125: nvl(irc_isc_shd.g_old_rec.isc_information6, hr_api.g_varchar2) <>
126: nvl(p_rec.isc_information6, hr_api.g_varchar2) or
127: nvl(irc_isc_shd.g_old_rec.isc_information7, hr_api.g_varchar2) <>
128: nvl(p_rec.isc_information7, hr_api.g_varchar2) or
129: nvl(irc_isc_shd.g_old_rec.isc_information8, hr_api.g_varchar2) <>

Line 127: nvl(irc_isc_shd.g_old_rec.isc_information7, hr_api.g_varchar2) <>

123: nvl(irc_isc_shd.g_old_rec.isc_information5, hr_api.g_varchar2) <>
124: nvl(p_rec.isc_information5, hr_api.g_varchar2) or
125: nvl(irc_isc_shd.g_old_rec.isc_information6, hr_api.g_varchar2) <>
126: nvl(p_rec.isc_information6, hr_api.g_varchar2) or
127: nvl(irc_isc_shd.g_old_rec.isc_information7, hr_api.g_varchar2) <>
128: nvl(p_rec.isc_information7, hr_api.g_varchar2) or
129: nvl(irc_isc_shd.g_old_rec.isc_information8, hr_api.g_varchar2) <>
130: nvl(p_rec.isc_information8, hr_api.g_varchar2) or
131: nvl(irc_isc_shd.g_old_rec.isc_information9, hr_api.g_varchar2) <>

Line 129: nvl(irc_isc_shd.g_old_rec.isc_information8, hr_api.g_varchar2) <>

125: nvl(irc_isc_shd.g_old_rec.isc_information6, hr_api.g_varchar2) <>
126: nvl(p_rec.isc_information6, hr_api.g_varchar2) or
127: nvl(irc_isc_shd.g_old_rec.isc_information7, hr_api.g_varchar2) <>
128: nvl(p_rec.isc_information7, hr_api.g_varchar2) or
129: nvl(irc_isc_shd.g_old_rec.isc_information8, hr_api.g_varchar2) <>
130: nvl(p_rec.isc_information8, hr_api.g_varchar2) or
131: nvl(irc_isc_shd.g_old_rec.isc_information9, hr_api.g_varchar2) <>
132: nvl(p_rec.isc_information9, hr_api.g_varchar2) or
133: nvl(irc_isc_shd.g_old_rec.isc_information10, hr_api.g_varchar2) <>

Line 131: nvl(irc_isc_shd.g_old_rec.isc_information9, hr_api.g_varchar2) <>

127: nvl(irc_isc_shd.g_old_rec.isc_information7, hr_api.g_varchar2) <>
128: nvl(p_rec.isc_information7, hr_api.g_varchar2) or
129: nvl(irc_isc_shd.g_old_rec.isc_information8, hr_api.g_varchar2) <>
130: nvl(p_rec.isc_information8, hr_api.g_varchar2) or
131: nvl(irc_isc_shd.g_old_rec.isc_information9, hr_api.g_varchar2) <>
132: nvl(p_rec.isc_information9, hr_api.g_varchar2) or
133: nvl(irc_isc_shd.g_old_rec.isc_information10, hr_api.g_varchar2) <>
134: nvl(p_rec.isc_information10, hr_api.g_varchar2) or
135: nvl(irc_isc_shd.g_old_rec.isc_information11, hr_api.g_varchar2) <>

Line 133: nvl(irc_isc_shd.g_old_rec.isc_information10, hr_api.g_varchar2) <>

129: nvl(irc_isc_shd.g_old_rec.isc_information8, hr_api.g_varchar2) <>
130: nvl(p_rec.isc_information8, hr_api.g_varchar2) or
131: nvl(irc_isc_shd.g_old_rec.isc_information9, hr_api.g_varchar2) <>
132: nvl(p_rec.isc_information9, hr_api.g_varchar2) or
133: nvl(irc_isc_shd.g_old_rec.isc_information10, hr_api.g_varchar2) <>
134: nvl(p_rec.isc_information10, hr_api.g_varchar2) or
135: nvl(irc_isc_shd.g_old_rec.isc_information11, hr_api.g_varchar2) <>
136: nvl(p_rec.isc_information11, hr_api.g_varchar2) or
137: nvl(irc_isc_shd.g_old_rec.isc_information12, hr_api.g_varchar2) <>

Line 135: nvl(irc_isc_shd.g_old_rec.isc_information11, hr_api.g_varchar2) <>

131: nvl(irc_isc_shd.g_old_rec.isc_information9, hr_api.g_varchar2) <>
132: nvl(p_rec.isc_information9, hr_api.g_varchar2) or
133: nvl(irc_isc_shd.g_old_rec.isc_information10, hr_api.g_varchar2) <>
134: nvl(p_rec.isc_information10, hr_api.g_varchar2) or
135: nvl(irc_isc_shd.g_old_rec.isc_information11, hr_api.g_varchar2) <>
136: nvl(p_rec.isc_information11, hr_api.g_varchar2) or
137: nvl(irc_isc_shd.g_old_rec.isc_information12, hr_api.g_varchar2) <>
138: nvl(p_rec.isc_information12, hr_api.g_varchar2) or
139: nvl(irc_isc_shd.g_old_rec.isc_information13, hr_api.g_varchar2) <>

Line 137: nvl(irc_isc_shd.g_old_rec.isc_information12, hr_api.g_varchar2) <>

133: nvl(irc_isc_shd.g_old_rec.isc_information10, hr_api.g_varchar2) <>
134: nvl(p_rec.isc_information10, hr_api.g_varchar2) or
135: nvl(irc_isc_shd.g_old_rec.isc_information11, hr_api.g_varchar2) <>
136: nvl(p_rec.isc_information11, hr_api.g_varchar2) or
137: nvl(irc_isc_shd.g_old_rec.isc_information12, hr_api.g_varchar2) <>
138: nvl(p_rec.isc_information12, hr_api.g_varchar2) or
139: nvl(irc_isc_shd.g_old_rec.isc_information13, hr_api.g_varchar2) <>
140: nvl(p_rec.isc_information13, hr_api.g_varchar2) or
141: nvl(irc_isc_shd.g_old_rec.isc_information14, hr_api.g_varchar2) <>

Line 139: nvl(irc_isc_shd.g_old_rec.isc_information13, hr_api.g_varchar2) <>

135: nvl(irc_isc_shd.g_old_rec.isc_information11, hr_api.g_varchar2) <>
136: nvl(p_rec.isc_information11, hr_api.g_varchar2) or
137: nvl(irc_isc_shd.g_old_rec.isc_information12, hr_api.g_varchar2) <>
138: nvl(p_rec.isc_information12, hr_api.g_varchar2) or
139: nvl(irc_isc_shd.g_old_rec.isc_information13, hr_api.g_varchar2) <>
140: nvl(p_rec.isc_information13, hr_api.g_varchar2) or
141: nvl(irc_isc_shd.g_old_rec.isc_information14, hr_api.g_varchar2) <>
142: nvl(p_rec.isc_information14, hr_api.g_varchar2) or
143: nvl(irc_isc_shd.g_old_rec.isc_information15, hr_api.g_varchar2) <>

Line 141: nvl(irc_isc_shd.g_old_rec.isc_information14, hr_api.g_varchar2) <>

137: nvl(irc_isc_shd.g_old_rec.isc_information12, hr_api.g_varchar2) <>
138: nvl(p_rec.isc_information12, hr_api.g_varchar2) or
139: nvl(irc_isc_shd.g_old_rec.isc_information13, hr_api.g_varchar2) <>
140: nvl(p_rec.isc_information13, hr_api.g_varchar2) or
141: nvl(irc_isc_shd.g_old_rec.isc_information14, hr_api.g_varchar2) <>
142: nvl(p_rec.isc_information14, hr_api.g_varchar2) or
143: nvl(irc_isc_shd.g_old_rec.isc_information15, hr_api.g_varchar2) <>
144: nvl(p_rec.isc_information15, hr_api.g_varchar2) or
145: nvl(irc_isc_shd.g_old_rec.isc_information16, hr_api.g_varchar2) <>

Line 143: nvl(irc_isc_shd.g_old_rec.isc_information15, hr_api.g_varchar2) <>

139: nvl(irc_isc_shd.g_old_rec.isc_information13, hr_api.g_varchar2) <>
140: nvl(p_rec.isc_information13, hr_api.g_varchar2) or
141: nvl(irc_isc_shd.g_old_rec.isc_information14, hr_api.g_varchar2) <>
142: nvl(p_rec.isc_information14, hr_api.g_varchar2) or
143: nvl(irc_isc_shd.g_old_rec.isc_information15, hr_api.g_varchar2) <>
144: nvl(p_rec.isc_information15, hr_api.g_varchar2) or
145: nvl(irc_isc_shd.g_old_rec.isc_information16, hr_api.g_varchar2) <>
146: nvl(p_rec.isc_information16, hr_api.g_varchar2) or
147: nvl(irc_isc_shd.g_old_rec.isc_information17, hr_api.g_varchar2) <>

Line 145: nvl(irc_isc_shd.g_old_rec.isc_information16, hr_api.g_varchar2) <>

141: nvl(irc_isc_shd.g_old_rec.isc_information14, hr_api.g_varchar2) <>
142: nvl(p_rec.isc_information14, hr_api.g_varchar2) or
143: nvl(irc_isc_shd.g_old_rec.isc_information15, hr_api.g_varchar2) <>
144: nvl(p_rec.isc_information15, hr_api.g_varchar2) or
145: nvl(irc_isc_shd.g_old_rec.isc_information16, hr_api.g_varchar2) <>
146: nvl(p_rec.isc_information16, hr_api.g_varchar2) or
147: nvl(irc_isc_shd.g_old_rec.isc_information17, hr_api.g_varchar2) <>
148: nvl(p_rec.isc_information17, hr_api.g_varchar2) or
149: nvl(irc_isc_shd.g_old_rec.isc_information18, hr_api.g_varchar2) <>

Line 147: nvl(irc_isc_shd.g_old_rec.isc_information17, hr_api.g_varchar2) <>

143: nvl(irc_isc_shd.g_old_rec.isc_information15, hr_api.g_varchar2) <>
144: nvl(p_rec.isc_information15, hr_api.g_varchar2) or
145: nvl(irc_isc_shd.g_old_rec.isc_information16, hr_api.g_varchar2) <>
146: nvl(p_rec.isc_information16, hr_api.g_varchar2) or
147: nvl(irc_isc_shd.g_old_rec.isc_information17, hr_api.g_varchar2) <>
148: nvl(p_rec.isc_information17, hr_api.g_varchar2) or
149: nvl(irc_isc_shd.g_old_rec.isc_information18, hr_api.g_varchar2) <>
150: nvl(p_rec.isc_information18, hr_api.g_varchar2) or
151: nvl(irc_isc_shd.g_old_rec.isc_information19, hr_api.g_varchar2) <>

Line 149: nvl(irc_isc_shd.g_old_rec.isc_information18, hr_api.g_varchar2) <>

145: nvl(irc_isc_shd.g_old_rec.isc_information16, hr_api.g_varchar2) <>
146: nvl(p_rec.isc_information16, hr_api.g_varchar2) or
147: nvl(irc_isc_shd.g_old_rec.isc_information17, hr_api.g_varchar2) <>
148: nvl(p_rec.isc_information17, hr_api.g_varchar2) or
149: nvl(irc_isc_shd.g_old_rec.isc_information18, hr_api.g_varchar2) <>
150: nvl(p_rec.isc_information18, hr_api.g_varchar2) or
151: nvl(irc_isc_shd.g_old_rec.isc_information19, hr_api.g_varchar2) <>
152: nvl(p_rec.isc_information19, hr_api.g_varchar2) or
153: nvl(irc_isc_shd.g_old_rec.isc_information20, hr_api.g_varchar2) <>

Line 151: nvl(irc_isc_shd.g_old_rec.isc_information19, hr_api.g_varchar2) <>

147: nvl(irc_isc_shd.g_old_rec.isc_information17, hr_api.g_varchar2) <>
148: nvl(p_rec.isc_information17, hr_api.g_varchar2) or
149: nvl(irc_isc_shd.g_old_rec.isc_information18, hr_api.g_varchar2) <>
150: nvl(p_rec.isc_information18, hr_api.g_varchar2) or
151: nvl(irc_isc_shd.g_old_rec.isc_information19, hr_api.g_varchar2) <>
152: nvl(p_rec.isc_information19, hr_api.g_varchar2) or
153: nvl(irc_isc_shd.g_old_rec.isc_information20, hr_api.g_varchar2) <>
154: nvl(p_rec.isc_information20, hr_api.g_varchar2) or
155: nvl(irc_isc_shd.g_old_rec.isc_information21, hr_api.g_varchar2) <>

Line 153: nvl(irc_isc_shd.g_old_rec.isc_information20, hr_api.g_varchar2) <>

149: nvl(irc_isc_shd.g_old_rec.isc_information18, hr_api.g_varchar2) <>
150: nvl(p_rec.isc_information18, hr_api.g_varchar2) or
151: nvl(irc_isc_shd.g_old_rec.isc_information19, hr_api.g_varchar2) <>
152: nvl(p_rec.isc_information19, hr_api.g_varchar2) or
153: nvl(irc_isc_shd.g_old_rec.isc_information20, hr_api.g_varchar2) <>
154: nvl(p_rec.isc_information20, hr_api.g_varchar2) or
155: nvl(irc_isc_shd.g_old_rec.isc_information21, hr_api.g_varchar2) <>
156: nvl(p_rec.isc_information21, hr_api.g_varchar2) or
157: nvl(irc_isc_shd.g_old_rec.isc_information22, hr_api.g_varchar2) <>

Line 155: nvl(irc_isc_shd.g_old_rec.isc_information21, hr_api.g_varchar2) <>

151: nvl(irc_isc_shd.g_old_rec.isc_information19, hr_api.g_varchar2) <>
152: nvl(p_rec.isc_information19, hr_api.g_varchar2) or
153: nvl(irc_isc_shd.g_old_rec.isc_information20, hr_api.g_varchar2) <>
154: nvl(p_rec.isc_information20, hr_api.g_varchar2) or
155: nvl(irc_isc_shd.g_old_rec.isc_information21, hr_api.g_varchar2) <>
156: nvl(p_rec.isc_information21, hr_api.g_varchar2) or
157: nvl(irc_isc_shd.g_old_rec.isc_information22, hr_api.g_varchar2) <>
158: nvl(p_rec.isc_information22, hr_api.g_varchar2) or
159: nvl(irc_isc_shd.g_old_rec.isc_information23, hr_api.g_varchar2) <>

Line 157: nvl(irc_isc_shd.g_old_rec.isc_information22, hr_api.g_varchar2) <>

153: nvl(irc_isc_shd.g_old_rec.isc_information20, hr_api.g_varchar2) <>
154: nvl(p_rec.isc_information20, hr_api.g_varchar2) or
155: nvl(irc_isc_shd.g_old_rec.isc_information21, hr_api.g_varchar2) <>
156: nvl(p_rec.isc_information21, hr_api.g_varchar2) or
157: nvl(irc_isc_shd.g_old_rec.isc_information22, hr_api.g_varchar2) <>
158: nvl(p_rec.isc_information22, hr_api.g_varchar2) or
159: nvl(irc_isc_shd.g_old_rec.isc_information23, hr_api.g_varchar2) <>
160: nvl(p_rec.isc_information23, hr_api.g_varchar2) or
161: nvl(irc_isc_shd.g_old_rec.isc_information24, hr_api.g_varchar2) <>

Line 159: nvl(irc_isc_shd.g_old_rec.isc_information23, hr_api.g_varchar2) <>

155: nvl(irc_isc_shd.g_old_rec.isc_information21, hr_api.g_varchar2) <>
156: nvl(p_rec.isc_information21, hr_api.g_varchar2) or
157: nvl(irc_isc_shd.g_old_rec.isc_information22, hr_api.g_varchar2) <>
158: nvl(p_rec.isc_information22, hr_api.g_varchar2) or
159: nvl(irc_isc_shd.g_old_rec.isc_information23, hr_api.g_varchar2) <>
160: nvl(p_rec.isc_information23, hr_api.g_varchar2) or
161: nvl(irc_isc_shd.g_old_rec.isc_information24, hr_api.g_varchar2) <>
162: nvl(p_rec.isc_information24, hr_api.g_varchar2) or
163: nvl(irc_isc_shd.g_old_rec.isc_information25, hr_api.g_varchar2) <>

Line 161: nvl(irc_isc_shd.g_old_rec.isc_information24, hr_api.g_varchar2) <>

157: nvl(irc_isc_shd.g_old_rec.isc_information22, hr_api.g_varchar2) <>
158: nvl(p_rec.isc_information22, hr_api.g_varchar2) or
159: nvl(irc_isc_shd.g_old_rec.isc_information23, hr_api.g_varchar2) <>
160: nvl(p_rec.isc_information23, hr_api.g_varchar2) or
161: nvl(irc_isc_shd.g_old_rec.isc_information24, hr_api.g_varchar2) <>
162: nvl(p_rec.isc_information24, hr_api.g_varchar2) or
163: nvl(irc_isc_shd.g_old_rec.isc_information25, hr_api.g_varchar2) <>
164: nvl(p_rec.isc_information25, hr_api.g_varchar2) or
165: nvl(irc_isc_shd.g_old_rec.isc_information26, hr_api.g_varchar2) <>

Line 163: nvl(irc_isc_shd.g_old_rec.isc_information25, hr_api.g_varchar2) <>

159: nvl(irc_isc_shd.g_old_rec.isc_information23, hr_api.g_varchar2) <>
160: nvl(p_rec.isc_information23, hr_api.g_varchar2) or
161: nvl(irc_isc_shd.g_old_rec.isc_information24, hr_api.g_varchar2) <>
162: nvl(p_rec.isc_information24, hr_api.g_varchar2) or
163: nvl(irc_isc_shd.g_old_rec.isc_information25, hr_api.g_varchar2) <>
164: nvl(p_rec.isc_information25, hr_api.g_varchar2) or
165: nvl(irc_isc_shd.g_old_rec.isc_information26, hr_api.g_varchar2) <>
166: nvl(p_rec.isc_information26, hr_api.g_varchar2) or
167: nvl(irc_isc_shd.g_old_rec.isc_information27, hr_api.g_varchar2) <>

Line 165: nvl(irc_isc_shd.g_old_rec.isc_information26, hr_api.g_varchar2) <>

161: nvl(irc_isc_shd.g_old_rec.isc_information24, hr_api.g_varchar2) <>
162: nvl(p_rec.isc_information24, hr_api.g_varchar2) or
163: nvl(irc_isc_shd.g_old_rec.isc_information25, hr_api.g_varchar2) <>
164: nvl(p_rec.isc_information25, hr_api.g_varchar2) or
165: nvl(irc_isc_shd.g_old_rec.isc_information26, hr_api.g_varchar2) <>
166: nvl(p_rec.isc_information26, hr_api.g_varchar2) or
167: nvl(irc_isc_shd.g_old_rec.isc_information27, hr_api.g_varchar2) <>
168: nvl(p_rec.isc_information27, hr_api.g_varchar2) or
169: nvl(irc_isc_shd.g_old_rec.isc_information28, hr_api.g_varchar2) <>

Line 167: nvl(irc_isc_shd.g_old_rec.isc_information27, hr_api.g_varchar2) <>

163: nvl(irc_isc_shd.g_old_rec.isc_information25, hr_api.g_varchar2) <>
164: nvl(p_rec.isc_information25, hr_api.g_varchar2) or
165: nvl(irc_isc_shd.g_old_rec.isc_information26, hr_api.g_varchar2) <>
166: nvl(p_rec.isc_information26, hr_api.g_varchar2) or
167: nvl(irc_isc_shd.g_old_rec.isc_information27, hr_api.g_varchar2) <>
168: nvl(p_rec.isc_information27, hr_api.g_varchar2) or
169: nvl(irc_isc_shd.g_old_rec.isc_information28, hr_api.g_varchar2) <>
170: nvl(p_rec.isc_information28, hr_api.g_varchar2) or
171: nvl(irc_isc_shd.g_old_rec.isc_information29, hr_api.g_varchar2) <>

Line 169: nvl(irc_isc_shd.g_old_rec.isc_information28, hr_api.g_varchar2) <>

165: nvl(irc_isc_shd.g_old_rec.isc_information26, hr_api.g_varchar2) <>
166: nvl(p_rec.isc_information26, hr_api.g_varchar2) or
167: nvl(irc_isc_shd.g_old_rec.isc_information27, hr_api.g_varchar2) <>
168: nvl(p_rec.isc_information27, hr_api.g_varchar2) or
169: nvl(irc_isc_shd.g_old_rec.isc_information28, hr_api.g_varchar2) <>
170: nvl(p_rec.isc_information28, hr_api.g_varchar2) or
171: nvl(irc_isc_shd.g_old_rec.isc_information29, hr_api.g_varchar2) <>
172: nvl(p_rec.isc_information29, hr_api.g_varchar2) or
173: nvl(irc_isc_shd.g_old_rec.isc_information30, hr_api.g_varchar2) <>

Line 171: nvl(irc_isc_shd.g_old_rec.isc_information29, hr_api.g_varchar2) <>

167: nvl(irc_isc_shd.g_old_rec.isc_information27, hr_api.g_varchar2) <>
168: nvl(p_rec.isc_information27, hr_api.g_varchar2) or
169: nvl(irc_isc_shd.g_old_rec.isc_information28, hr_api.g_varchar2) <>
170: nvl(p_rec.isc_information28, hr_api.g_varchar2) or
171: nvl(irc_isc_shd.g_old_rec.isc_information29, hr_api.g_varchar2) <>
172: nvl(p_rec.isc_information29, hr_api.g_varchar2) or
173: nvl(irc_isc_shd.g_old_rec.isc_information30, hr_api.g_varchar2) <>
174: nvl(p_rec.isc_information30, hr_api.g_varchar2) ))
175: or (p_rec.search_criteria_id is null) then

Line 173: nvl(irc_isc_shd.g_old_rec.isc_information30, hr_api.g_varchar2) <>

169: nvl(irc_isc_shd.g_old_rec.isc_information28, hr_api.g_varchar2) <>
170: nvl(p_rec.isc_information28, hr_api.g_varchar2) or
171: nvl(irc_isc_shd.g_old_rec.isc_information29, hr_api.g_varchar2) <>
172: nvl(p_rec.isc_information29, hr_api.g_varchar2) or
173: nvl(irc_isc_shd.g_old_rec.isc_information30, hr_api.g_varchar2) <>
174: nvl(p_rec.isc_information30, hr_api.g_varchar2) ))
175: or (p_rec.search_criteria_id is null) then
176: --
177: -- Only execute the validation if absolutely necessary:

Line 281: (p_rec in irc_isc_shd.g_rec_type

277: -- Internal Row Handler Use Only.
278: --
279: -- ----------------------------------------------------------------------------
280: procedure chk_df
281: (p_rec in irc_isc_shd.g_rec_type
282: ) is
283: --
284: l_proc varchar2(72) := g_package || 'chk_df';
285: --

Line 290: nvl(irc_isc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

286: begin
287: hr_utility.set_location('Entering:'||l_proc,10);
288: --
289: if ((p_rec.search_criteria_id is not null) and (
290: nvl(irc_isc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
291: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
292: nvl(irc_isc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
293: nvl(p_rec.attribute1, hr_api.g_varchar2) or
294: nvl(irc_isc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 292: nvl(irc_isc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

288: --
289: if ((p_rec.search_criteria_id is not null) and (
290: nvl(irc_isc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
291: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
292: nvl(irc_isc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
293: nvl(p_rec.attribute1, hr_api.g_varchar2) or
294: nvl(irc_isc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
295: nvl(p_rec.attribute2, hr_api.g_varchar2) or
296: nvl(irc_isc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 294: nvl(irc_isc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

290: nvl(irc_isc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
291: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
292: nvl(irc_isc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
293: nvl(p_rec.attribute1, hr_api.g_varchar2) or
294: nvl(irc_isc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
295: nvl(p_rec.attribute2, hr_api.g_varchar2) or
296: nvl(irc_isc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
297: nvl(p_rec.attribute3, hr_api.g_varchar2) or
298: nvl(irc_isc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 296: nvl(irc_isc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

292: nvl(irc_isc_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
293: nvl(p_rec.attribute1, hr_api.g_varchar2) or
294: nvl(irc_isc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
295: nvl(p_rec.attribute2, hr_api.g_varchar2) or
296: nvl(irc_isc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
297: nvl(p_rec.attribute3, hr_api.g_varchar2) or
298: nvl(irc_isc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
299: nvl(p_rec.attribute4, hr_api.g_varchar2) or
300: nvl(irc_isc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 298: nvl(irc_isc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

294: nvl(irc_isc_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
295: nvl(p_rec.attribute2, hr_api.g_varchar2) or
296: nvl(irc_isc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
297: nvl(p_rec.attribute3, hr_api.g_varchar2) or
298: nvl(irc_isc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
299: nvl(p_rec.attribute4, hr_api.g_varchar2) or
300: nvl(irc_isc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
301: nvl(p_rec.attribute5, hr_api.g_varchar2) or
302: nvl(irc_isc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 300: nvl(irc_isc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

296: nvl(irc_isc_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
297: nvl(p_rec.attribute3, hr_api.g_varchar2) or
298: nvl(irc_isc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
299: nvl(p_rec.attribute4, hr_api.g_varchar2) or
300: nvl(irc_isc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
301: nvl(p_rec.attribute5, hr_api.g_varchar2) or
302: nvl(irc_isc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
303: nvl(p_rec.attribute6, hr_api.g_varchar2) or
304: nvl(irc_isc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 302: nvl(irc_isc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

298: nvl(irc_isc_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
299: nvl(p_rec.attribute4, hr_api.g_varchar2) or
300: nvl(irc_isc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
301: nvl(p_rec.attribute5, hr_api.g_varchar2) or
302: nvl(irc_isc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
303: nvl(p_rec.attribute6, hr_api.g_varchar2) or
304: nvl(irc_isc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
305: nvl(p_rec.attribute7, hr_api.g_varchar2) or
306: nvl(irc_isc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 304: nvl(irc_isc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

300: nvl(irc_isc_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
301: nvl(p_rec.attribute5, hr_api.g_varchar2) or
302: nvl(irc_isc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
303: nvl(p_rec.attribute6, hr_api.g_varchar2) or
304: nvl(irc_isc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
305: nvl(p_rec.attribute7, hr_api.g_varchar2) or
306: nvl(irc_isc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
307: nvl(p_rec.attribute8, hr_api.g_varchar2) or
308: nvl(irc_isc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 306: nvl(irc_isc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

302: nvl(irc_isc_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
303: nvl(p_rec.attribute6, hr_api.g_varchar2) or
304: nvl(irc_isc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
305: nvl(p_rec.attribute7, hr_api.g_varchar2) or
306: nvl(irc_isc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
307: nvl(p_rec.attribute8, hr_api.g_varchar2) or
308: nvl(irc_isc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
309: nvl(p_rec.attribute9, hr_api.g_varchar2) or
310: nvl(irc_isc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 308: nvl(irc_isc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

304: nvl(irc_isc_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
305: nvl(p_rec.attribute7, hr_api.g_varchar2) or
306: nvl(irc_isc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
307: nvl(p_rec.attribute8, hr_api.g_varchar2) or
308: nvl(irc_isc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
309: nvl(p_rec.attribute9, hr_api.g_varchar2) or
310: nvl(irc_isc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
311: nvl(p_rec.attribute10, hr_api.g_varchar2) or
312: nvl(irc_isc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

Line 310: nvl(irc_isc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

306: nvl(irc_isc_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
307: nvl(p_rec.attribute8, hr_api.g_varchar2) or
308: nvl(irc_isc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
309: nvl(p_rec.attribute9, hr_api.g_varchar2) or
310: nvl(irc_isc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
311: nvl(p_rec.attribute10, hr_api.g_varchar2) or
312: nvl(irc_isc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
313: nvl(p_rec.attribute11, hr_api.g_varchar2) or
314: nvl(irc_isc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

Line 312: nvl(irc_isc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

308: nvl(irc_isc_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
309: nvl(p_rec.attribute9, hr_api.g_varchar2) or
310: nvl(irc_isc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
311: nvl(p_rec.attribute10, hr_api.g_varchar2) or
312: nvl(irc_isc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
313: nvl(p_rec.attribute11, hr_api.g_varchar2) or
314: nvl(irc_isc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
315: nvl(p_rec.attribute12, hr_api.g_varchar2) or
316: nvl(irc_isc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

Line 314: nvl(irc_isc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

310: nvl(irc_isc_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
311: nvl(p_rec.attribute10, hr_api.g_varchar2) or
312: nvl(irc_isc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
313: nvl(p_rec.attribute11, hr_api.g_varchar2) or
314: nvl(irc_isc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
315: nvl(p_rec.attribute12, hr_api.g_varchar2) or
316: nvl(irc_isc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
317: nvl(p_rec.attribute13, hr_api.g_varchar2) or
318: nvl(irc_isc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

Line 316: nvl(irc_isc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

312: nvl(irc_isc_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
313: nvl(p_rec.attribute11, hr_api.g_varchar2) or
314: nvl(irc_isc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
315: nvl(p_rec.attribute12, hr_api.g_varchar2) or
316: nvl(irc_isc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
317: nvl(p_rec.attribute13, hr_api.g_varchar2) or
318: nvl(irc_isc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
319: nvl(p_rec.attribute14, hr_api.g_varchar2) or
320: nvl(irc_isc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

Line 318: nvl(irc_isc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

314: nvl(irc_isc_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
315: nvl(p_rec.attribute12, hr_api.g_varchar2) or
316: nvl(irc_isc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
317: nvl(p_rec.attribute13, hr_api.g_varchar2) or
318: nvl(irc_isc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
319: nvl(p_rec.attribute14, hr_api.g_varchar2) or
320: nvl(irc_isc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
321: nvl(p_rec.attribute15, hr_api.g_varchar2) or
322: nvl(irc_isc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

Line 320: nvl(irc_isc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

316: nvl(irc_isc_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
317: nvl(p_rec.attribute13, hr_api.g_varchar2) or
318: nvl(irc_isc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
319: nvl(p_rec.attribute14, hr_api.g_varchar2) or
320: nvl(irc_isc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
321: nvl(p_rec.attribute15, hr_api.g_varchar2) or
322: nvl(irc_isc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
323: nvl(p_rec.attribute16, hr_api.g_varchar2) or
324: nvl(irc_isc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

Line 322: nvl(irc_isc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

318: nvl(irc_isc_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
319: nvl(p_rec.attribute14, hr_api.g_varchar2) or
320: nvl(irc_isc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
321: nvl(p_rec.attribute15, hr_api.g_varchar2) or
322: nvl(irc_isc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
323: nvl(p_rec.attribute16, hr_api.g_varchar2) or
324: nvl(irc_isc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
325: nvl(p_rec.attribute17, hr_api.g_varchar2) or
326: nvl(irc_isc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

Line 324: nvl(irc_isc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

320: nvl(irc_isc_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
321: nvl(p_rec.attribute15, hr_api.g_varchar2) or
322: nvl(irc_isc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
323: nvl(p_rec.attribute16, hr_api.g_varchar2) or
324: nvl(irc_isc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
325: nvl(p_rec.attribute17, hr_api.g_varchar2) or
326: nvl(irc_isc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
327: nvl(p_rec.attribute18, hr_api.g_varchar2) or
328: nvl(irc_isc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

Line 326: nvl(irc_isc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

322: nvl(irc_isc_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
323: nvl(p_rec.attribute16, hr_api.g_varchar2) or
324: nvl(irc_isc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
325: nvl(p_rec.attribute17, hr_api.g_varchar2) or
326: nvl(irc_isc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
327: nvl(p_rec.attribute18, hr_api.g_varchar2) or
328: nvl(irc_isc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
329: nvl(p_rec.attribute19, hr_api.g_varchar2) or
330: nvl(irc_isc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

Line 328: nvl(irc_isc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

324: nvl(irc_isc_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
325: nvl(p_rec.attribute17, hr_api.g_varchar2) or
326: nvl(irc_isc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
327: nvl(p_rec.attribute18, hr_api.g_varchar2) or
328: nvl(irc_isc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
329: nvl(p_rec.attribute19, hr_api.g_varchar2) or
330: nvl(irc_isc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
331: nvl(p_rec.attribute20, hr_api.g_varchar2) or
332: nvl(irc_isc_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>

Line 330: nvl(irc_isc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

326: nvl(irc_isc_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
327: nvl(p_rec.attribute18, hr_api.g_varchar2) or
328: nvl(irc_isc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
329: nvl(p_rec.attribute19, hr_api.g_varchar2) or
330: nvl(irc_isc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
331: nvl(p_rec.attribute20, hr_api.g_varchar2) or
332: nvl(irc_isc_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
333: nvl(p_rec.attribute21, hr_api.g_varchar2) or
334: nvl(irc_isc_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>

Line 332: nvl(irc_isc_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>

328: nvl(irc_isc_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
329: nvl(p_rec.attribute19, hr_api.g_varchar2) or
330: nvl(irc_isc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
331: nvl(p_rec.attribute20, hr_api.g_varchar2) or
332: nvl(irc_isc_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
333: nvl(p_rec.attribute21, hr_api.g_varchar2) or
334: nvl(irc_isc_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
335: nvl(p_rec.attribute22, hr_api.g_varchar2) or
336: nvl(irc_isc_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>

Line 334: nvl(irc_isc_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>

330: nvl(irc_isc_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
331: nvl(p_rec.attribute20, hr_api.g_varchar2) or
332: nvl(irc_isc_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
333: nvl(p_rec.attribute21, hr_api.g_varchar2) or
334: nvl(irc_isc_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
335: nvl(p_rec.attribute22, hr_api.g_varchar2) or
336: nvl(irc_isc_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
337: nvl(p_rec.attribute23, hr_api.g_varchar2) or
338: nvl(irc_isc_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>

Line 336: nvl(irc_isc_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>

332: nvl(irc_isc_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
333: nvl(p_rec.attribute21, hr_api.g_varchar2) or
334: nvl(irc_isc_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
335: nvl(p_rec.attribute22, hr_api.g_varchar2) or
336: nvl(irc_isc_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
337: nvl(p_rec.attribute23, hr_api.g_varchar2) or
338: nvl(irc_isc_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
339: nvl(p_rec.attribute24, hr_api.g_varchar2) or
340: nvl(irc_isc_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>

Line 338: nvl(irc_isc_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>

334: nvl(irc_isc_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
335: nvl(p_rec.attribute22, hr_api.g_varchar2) or
336: nvl(irc_isc_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
337: nvl(p_rec.attribute23, hr_api.g_varchar2) or
338: nvl(irc_isc_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
339: nvl(p_rec.attribute24, hr_api.g_varchar2) or
340: nvl(irc_isc_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
341: nvl(p_rec.attribute25, hr_api.g_varchar2) or
342: nvl(irc_isc_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>

Line 340: nvl(irc_isc_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>

336: nvl(irc_isc_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
337: nvl(p_rec.attribute23, hr_api.g_varchar2) or
338: nvl(irc_isc_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
339: nvl(p_rec.attribute24, hr_api.g_varchar2) or
340: nvl(irc_isc_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
341: nvl(p_rec.attribute25, hr_api.g_varchar2) or
342: nvl(irc_isc_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
343: nvl(p_rec.attribute26, hr_api.g_varchar2) or
344: nvl(irc_isc_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>

Line 342: nvl(irc_isc_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>

338: nvl(irc_isc_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
339: nvl(p_rec.attribute24, hr_api.g_varchar2) or
340: nvl(irc_isc_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
341: nvl(p_rec.attribute25, hr_api.g_varchar2) or
342: nvl(irc_isc_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
343: nvl(p_rec.attribute26, hr_api.g_varchar2) or
344: nvl(irc_isc_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
345: nvl(p_rec.attribute27, hr_api.g_varchar2) or
346: nvl(irc_isc_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>

Line 344: nvl(irc_isc_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>

340: nvl(irc_isc_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
341: nvl(p_rec.attribute25, hr_api.g_varchar2) or
342: nvl(irc_isc_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
343: nvl(p_rec.attribute26, hr_api.g_varchar2) or
344: nvl(irc_isc_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
345: nvl(p_rec.attribute27, hr_api.g_varchar2) or
346: nvl(irc_isc_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
347: nvl(p_rec.attribute28, hr_api.g_varchar2) or
348: nvl(irc_isc_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>

Line 346: nvl(irc_isc_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>

342: nvl(irc_isc_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
343: nvl(p_rec.attribute26, hr_api.g_varchar2) or
344: nvl(irc_isc_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
345: nvl(p_rec.attribute27, hr_api.g_varchar2) or
346: nvl(irc_isc_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
347: nvl(p_rec.attribute28, hr_api.g_varchar2) or
348: nvl(irc_isc_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
349: nvl(p_rec.attribute29, hr_api.g_varchar2) or
350: nvl(irc_isc_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>

Line 348: nvl(irc_isc_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>

344: nvl(irc_isc_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
345: nvl(p_rec.attribute27, hr_api.g_varchar2) or
346: nvl(irc_isc_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
347: nvl(p_rec.attribute28, hr_api.g_varchar2) or
348: nvl(irc_isc_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
349: nvl(p_rec.attribute29, hr_api.g_varchar2) or
350: nvl(irc_isc_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
351: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
352: or (p_rec.search_criteria_id is null) then

Line 350: nvl(irc_isc_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>

346: nvl(irc_isc_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
347: nvl(p_rec.attribute28, hr_api.g_varchar2) or
348: nvl(irc_isc_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
349: nvl(p_rec.attribute29, hr_api.g_varchar2) or
350: nvl(irc_isc_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
351: nvl(p_rec.attribute30, hr_api.g_varchar2) ))
352: or (p_rec.search_criteria_id is null) then
353: --
354: -- Only execute the validation if absolutely necessary:

Line 458: ,p_rec in irc_isc_shd.g_rec_type

454: -- {End Of Comments}
455: -- ----------------------------------------------------------------------------
456: Procedure chk_non_updateable_args
457: (p_effective_date in date
458: ,p_rec in irc_isc_shd.g_rec_type
459: ) IS
460: --
461: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
462: --

Line 468: IF NOT irc_isc_shd.api_updating

464: --
465: -- Only proceed with the validation if a row exists for the current
466: -- record in the HR Schema.
467: --
468: IF NOT irc_isc_shd.api_updating
469: (p_search_criteria_id => p_rec.search_criteria_id
470: ,p_object_version_number => p_rec.object_version_number
471: ) THEN
472: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 482: irc_isc_shd.g_old_rec.search_criteria_id then

478: -- Add checks to ensure non-updateable args have
479: -- not been updated.
480: --
481: if p_rec.search_criteria_id <>
482: irc_isc_shd.g_old_rec.search_criteria_id then
483: hr_api.argument_changed_error
484: (p_api_name => l_proc
485: ,p_argument => 'SEARCH_CRITERIA_ID'
486: ,p_base_table => irc_isc_shd.g_tab_nam

Line 486: ,p_base_table => irc_isc_shd.g_tab_nam

482: irc_isc_shd.g_old_rec.search_criteria_id then
483: hr_api.argument_changed_error
484: (p_api_name => l_proc
485: ,p_argument => 'SEARCH_CRITERIA_ID'
486: ,p_base_table => irc_isc_shd.g_tab_nam
487: );
488: end if;
489: --
490: --

Line 491: if p_rec.object_id <> irc_isc_shd.g_old_rec.object_id then

487: );
488: end if;
489: --
490: --
491: if p_rec.object_id <> irc_isc_shd.g_old_rec.object_id then
492: if p_rec.object_type = 'PERSON' then
493: hr_api.argument_changed_error
494: ( p_api_name => l_proc
495: ,p_argument => 'PERSON_ID'

Line 496: ,p_base_table => irc_isc_shd.g_tab_nam

492: if p_rec.object_type = 'PERSON' then
493: hr_api.argument_changed_error
494: ( p_api_name => l_proc
495: ,p_argument => 'PERSON_ID'
496: ,p_base_table => irc_isc_shd.g_tab_nam
497: );
498: elsif p_rec.object_type = 'VACANCY' then
499: hr_api.argument_changed_error
500: ( p_api_name => l_proc

Line 502: ,p_base_table => irc_isc_shd.g_tab_nam

498: elsif p_rec.object_type = 'VACANCY' then
499: hr_api.argument_changed_error
500: ( p_api_name => l_proc
501: ,p_argument => 'VACANCY_ID'
502: ,p_base_table => irc_isc_shd.g_tab_nam
503: );
504: end if;
505: end if;
506: End chk_non_updateable_args;

Line 684: l_api_updating := irc_isc_shd.api_updating

680: hr_utility.set_location('Entering:'||l_proc,10);
681: if p_search_name is not null then
682: --
683: hr_utility.set_location(l_proc,20);
684: l_api_updating := irc_isc_shd.api_updating
685: (p_search_criteria_id => p_search_criteria_id
686: ,p_object_version_number => p_object_version_number
687: );
688: hr_utility.set_location(l_proc,30);

Line 691: NVL(irc_isc_shd.g_old_rec.search_name,hr_api.g_varchar2)

687: );
688: hr_utility.set_location(l_proc,30);
689: if (l_api_updating and
690: p_search_name <>
691: NVL(irc_isc_shd.g_old_rec.search_name,hr_api.g_varchar2)
692: ) or (NOT l_api_updating) then
693: -- Check that search_name is unique for a person_id
694: hr_utility.set_location(l_proc,40);
695: open csr_search_name;

Line 763: l_api_updating := irc_isc_shd.api_updating

759: hr_utility.set_location('Entering:'||l_proc,10);
760: if p_distance_to_location is not null then
761: --
762: hr_utility.set_location(l_proc,20);
763: l_api_updating := irc_isc_shd.api_updating
764: (p_search_criteria_id => p_search_criteria_id
765: ,p_object_version_number => p_object_version_number
766: );
767: --

Line 771: NVL(irc_isc_shd.g_old_rec.distance_to_location,hr_api.g_number))

767: --
768: hr_utility.set_location(l_proc,30);
769: if (l_api_updating and
770: p_distance_to_location <>
771: NVL(irc_isc_shd.g_old_rec.distance_to_location,hr_api.g_number))
772: or (NOT l_api_updating) then
773: -- Check that distance_to_location is a valid positive number.
774: hr_utility.set_location(l_proc,40);
775: if p_distance_to_location < 0 then

Line 849: l_api_updating := irc_isc_shd.api_updating

845: hr_utility.set_location('Entering:'||l_proc,10);
846: if p_location_id is not null then
847: --
848: hr_utility.set_location(l_proc,20);
849: l_api_updating := irc_isc_shd.api_updating
850: (p_search_criteria_id => p_search_criteria_id
851: ,p_object_version_number => p_object_version_number
852: );
853: --

Line 857: NVL(irc_isc_shd.g_old_rec.location_id,hr_api.g_number))

853: --
854: hr_utility.set_location(l_proc,30);
855: if (l_api_updating and
856: p_location_id <>
857: NVL(irc_isc_shd.g_old_rec.location_id,hr_api.g_number))
858: or (NOT l_api_updating) then
859: -- Check that location_id is a valid
860: hr_utility.set_location(l_proc,40);
861: open chk_loc;

Line 968: l_api_updating := irc_isc_shd.api_updating

964: hr_utility.set_location('Entering:'||l_proc,10);
965: if p_use_for_matching is not null then
966: --
967: hr_utility.set_location(l_proc,20);
968: l_api_updating := irc_isc_shd.api_updating
969: (p_search_criteria_id => p_search_criteria_id
970: ,p_object_version_number => p_object_version_number
971: );
972: --

Line 976: NVL(irc_isc_shd.g_old_rec.use_for_matching,hr_api.g_varchar2)

972: --
973: hr_utility.set_location(l_proc,30);
974: if (l_api_updating and
975: p_use_for_matching <>
976: NVL(irc_isc_shd.g_old_rec.use_for_matching,hr_api.g_varchar2)
977: ) or (NOT l_api_updating) then
978: -- Check that use_for_matching is having a valid value of 'Y' or 'N'
979: hr_utility.set_location(l_proc,40);
980: if not p_use_for_matching in ('Y','N') then

Line 1038: l_api_updating := irc_isc_shd.api_updating

1034: begin
1035: hr_utility.set_location('Entering:'||l_proc,10);
1036: if p_match_competence is not null then
1037: hr_utility.set_location(l_proc,20);
1038: l_api_updating := irc_isc_shd.api_updating
1039: (p_search_criteria_id => p_search_criteria_id
1040: ,p_object_version_number => p_object_version_number
1041: );
1042: --

Line 1046: NVL(irc_isc_shd.g_old_rec.match_competence,hr_api.g_varchar2)

1042: --
1043: hr_utility.set_location(l_proc,30);
1044: if (l_api_updating and
1045: p_match_competence <>
1046: NVL(irc_isc_shd.g_old_rec.match_competence,hr_api.g_varchar2)
1047: ) or (NOT l_api_updating) then
1048: -- Check that match_competence is having a valid value of 'Y' or 'N'
1049: hr_utility.set_location(l_proc,40);
1050: if not p_match_competence in ('Y','N') then

Line 1109: l_api_updating := irc_isc_shd.api_updating

1105: hr_utility.set_location('Entering:'||l_proc,10);
1106: if p_match_qualification is not null then
1107: --
1108: hr_utility.set_location(l_proc,20);
1109: l_api_updating := irc_isc_shd.api_updating
1110: (p_search_criteria_id => p_search_criteria_id
1111: ,p_object_version_number => p_object_version_number
1112: );
1113: --

Line 1117: NVL(irc_isc_shd.g_old_rec.match_qualification,hr_api.g_varchar2)

1113: --
1114: hr_utility.set_location(l_proc,30);
1115: if (l_api_updating and
1116: p_match_qualification <>
1117: NVL(irc_isc_shd.g_old_rec.match_qualification,hr_api.g_varchar2)
1118: ) or (NOT l_api_updating) then
1119: -- Check that match_qualification is having a valid value of 'Y' or 'N'
1120: hr_utility.set_location(l_proc,40);
1121: if not p_match_qualification in ('Y','N') then

Line 1253: l_api_updating := irc_isc_shd.api_updating

1249: hr_utility.set_location('Entering:'||l_proc,10);
1250: if p_min_qual_level is not null then
1251: --
1252: hr_utility.set_location(l_proc,20);
1253: l_api_updating := irc_isc_shd.api_updating
1254: (p_search_criteria_id => p_search_criteria_id
1255: ,p_object_version_number => p_object_version_number
1256: );
1257: --

Line 1261: NVL(irc_isc_shd.g_old_rec.min_qual_level,hr_api.g_number)

1257: --
1258: hr_utility.set_location(l_proc,30);
1259: if (l_api_updating and
1260: p_min_qual_level <>
1261: NVL(irc_isc_shd.g_old_rec.min_qual_level,hr_api.g_number)
1262: ) or (NOT l_api_updating) then
1263: hr_utility.set_location(l_proc,40);
1264: open csr_min_qual_level;
1265: fetch csr_min_qual_level into l_min_qual_level ;

Line 1408: l_api_updating := irc_isc_shd.api_updating

1404: hr_utility.set_location('Entering:'||l_proc,10);
1405: if p_min_salary is not null then
1406: --
1407: hr_utility.set_location(l_proc,20);
1408: l_api_updating := irc_isc_shd.api_updating
1409: (p_search_criteria_id => p_search_criteria_id
1410: ,p_object_version_number => p_object_version_number
1411: );
1412: --

Line 1416: NVL(irc_isc_shd.g_old_rec.min_salary,hr_api.g_number)

1412: --
1413: hr_utility.set_location(l_proc,30);
1414: if (l_api_updating and
1415: p_min_salary <>
1416: NVL(irc_isc_shd.g_old_rec.min_salary,hr_api.g_number)
1417: ) or (NOT l_api_updating) then
1418: -- Check that min_salary is a valid positive number.
1419: hr_utility.set_location(l_proc,40);
1420: if p_min_salary < 0 then

Line 1491: l_api_updating := irc_isc_shd.api_updating

1487: ) then
1488: if p_max_salary is not null then
1489: --
1490: hr_utility.set_location(l_proc,20);
1491: l_api_updating := irc_isc_shd.api_updating
1492: (p_search_criteria_id => p_search_criteria_id
1493: ,p_object_version_number => p_object_version_number
1494: );
1495: --

Line 1499: NVL(irc_isc_shd.g_old_rec.max_salary,hr_api.g_number)

1495: --
1496: hr_utility.set_location(l_proc,30);
1497: if (l_api_updating and
1498: p_max_salary <>
1499: NVL(irc_isc_shd.g_old_rec.max_salary,hr_api.g_number)
1500: ) or (NOT l_api_updating) then
1501: -- Check that max_salary is greater then min salary.
1502: hr_utility.set_location(l_proc,40);
1503: if p_max_salary < 0 or p_max_salary < NVL(p_min_salary,hr_api.g_number)

Line 1566: l_api_updating := irc_isc_shd.api_updating

1562: l_api_updating boolean;
1563: --
1564: begin
1565: hr_utility.set_location('Entering:'||l_proc,10);
1566: l_api_updating := irc_isc_shd.api_updating
1567: (p_search_criteria_id => p_search_criteria_id
1568: ,p_object_version_number => p_object_version_number
1569: );
1570: --

Line 1572: if (l_api_updating and p_employee <> irc_isc_shd.g_old_rec.employee)

1568: ,p_object_version_number => p_object_version_number
1569: );
1570: --
1571: hr_utility.set_location(l_proc,20);
1572: if (l_api_updating and p_employee <> irc_isc_shd.g_old_rec.employee)
1573: or (NOT l_api_updating) then
1574: -- Check that employee is having a valid value of 'Y' or 'N'
1575: hr_utility.set_location(l_proc,30);
1576: if (p_employee is null) or (p_employee Not in ('Y','N')) then

Line 1629: l_api_updating := irc_isc_shd.api_updating

1625: l_api_updating boolean;
1626: --
1627: begin
1628: hr_utility.set_location('Entering:'||l_proc,10);
1629: l_api_updating := irc_isc_shd.api_updating
1630: (p_search_criteria_id => p_search_criteria_id
1631: ,p_object_version_number => p_object_version_number
1632: );
1633: hr_utility.set_location(l_proc,20);

Line 1634: if (l_api_updating and p_contractor <> irc_isc_shd.g_old_rec.contractor)

1630: (p_search_criteria_id => p_search_criteria_id
1631: ,p_object_version_number => p_object_version_number
1632: );
1633: hr_utility.set_location(l_proc,20);
1634: if (l_api_updating and p_contractor <> irc_isc_shd.g_old_rec.contractor)
1635: or (NOT l_api_updating) then
1636: -- Check that contractor is having a valid value of 'Y' or 'N'
1637: hr_utility.set_location(l_proc,30);
1638: if (p_contractor is null) or (p_contractor Not in ('Y','N')) then

Line 1694: l_api_updating := irc_isc_shd.api_updating

1690: l_ret boolean;
1691: --
1692: begin
1693: hr_utility.set_location('Entering:'||l_proc,10);
1694: l_api_updating := irc_isc_shd.api_updating
1695: (p_search_criteria_id => p_search_criteria_id
1696: ,p_object_version_number => p_object_version_number
1697: );
1698: hr_utility.set_location(l_proc,20);

Line 1703: NVL(irc_isc_shd.g_old_rec.professional_area,hr_api.g_varchar2)

1699: if p_professional_area is not null then
1700: hr_utility.set_location(l_proc,30);
1701: if (l_api_updating and
1702: p_professional_area <>
1703: NVL(irc_isc_shd.g_old_rec.professional_area,hr_api.g_varchar2)
1704: ) or (NOT l_api_updating) then
1705: -- Check that professional_area exists in hr_lookups
1706: hr_utility.set_location(l_proc,40);
1707: l_ret := hr_api.not_exists_in_hr_lookups(

Line 1772: l_api_updating := irc_isc_shd.api_updating

1768: hr_utility.set_location('Entering:'||l_proc,10);
1769: if p_employment_category is not null then
1770: --
1771: hr_utility.set_location(l_proc,20);
1772: l_api_updating := irc_isc_shd.api_updating
1773: (p_search_criteria_id => p_search_criteria_id
1774: ,p_object_version_number => p_object_version_number
1775: );
1776: --

Line 1780: NVL(irc_isc_shd.g_old_rec.employment_category,hr_api.g_varchar2)

1776: --
1777: hr_utility.set_location(l_proc,30);
1778: if (l_api_updating and
1779: p_employment_category <>
1780: NVL(irc_isc_shd.g_old_rec.employment_category,hr_api.g_varchar2)
1781: ) or (NOT l_api_updating) then
1782: -- Check that employment_category exists in hr_lookups
1783: hr_utility.set_location(l_proc,40);
1784: l_ret := hr_api.not_exists_in_hr_lookups(

Line 1849: l_api_updating := irc_isc_shd.api_updating

1845: hr_utility.set_location('Entering:'||l_proc,10);
1846: if p_work_at_home is not null then
1847: --
1848: hr_utility.set_location(l_proc,20);
1849: l_api_updating := irc_isc_shd.api_updating
1850: (p_search_criteria_id => p_search_criteria_id
1851: ,p_object_version_number => p_object_version_number
1852: );
1853: --

Line 1857: NVL(irc_isc_shd.g_old_rec.work_at_home,hr_api.g_varchar2)

1853: --
1854: hr_utility.set_location(l_proc,30);
1855: if (l_api_updating and
1856: p_work_at_home <>
1857: NVL(irc_isc_shd.g_old_rec.work_at_home,hr_api.g_varchar2)
1858: ) or (NOT l_api_updating) then
1859: -- Check that work_at_home exists in hr_lookups
1860: hr_utility.set_location(l_proc,40);
1861: l_ret := hr_api.not_exists_in_hr_lookups(

Line 1926: l_api_updating := irc_isc_shd.api_updating

1922: hr_utility.set_location('Entering:'||l_proc,10);
1923: if p_travel_percentage is not null then
1924: --
1925: hr_utility.set_location(l_proc,20);
1926: l_api_updating := irc_isc_shd.api_updating
1927: (p_search_criteria_id => p_search_criteria_id
1928: ,p_object_version_number => p_object_version_number
1929: );
1930: --

Line 1934: NVL(irc_isc_shd.g_old_rec.travel_percentage,hr_api.g_number))

1930: --
1931: hr_utility.set_location(l_proc,30);
1932: if (l_api_updating and
1933: p_travel_percentage <>
1934: NVL(irc_isc_shd.g_old_rec.travel_percentage,hr_api.g_number))
1935: or (NOT l_api_updating) then
1936: -- Check that travel_percentage exists in hr_lookups
1937: hr_utility.set_location(l_proc,40);
1938: l_ret := hr_api.not_exists_in_hr_lookups(

Line 2004: l_api_updating := irc_isc_shd.api_updating

2000: l_ret boolean;
2001: --
2002: begin
2003: hr_utility.set_location('Entering:'||l_proc,10);
2004: l_api_updating := irc_isc_shd.api_updating
2005: (p_search_criteria_id => p_search_criteria_id
2006: ,p_object_version_number => p_object_version_number
2007: );
2008: hr_utility.set_location(l_proc,20);

Line 2010: l_max_salary :=irc_isc_shd.g_old_rec.max_salary;

2006: ,p_object_version_number => p_object_version_number
2007: );
2008: hr_utility.set_location(l_proc,20);
2009: if (p_max_salary = hr_api.g_number) then
2010: l_max_salary :=irc_isc_shd.g_old_rec.max_salary;
2011: else
2012: l_max_salary := p_max_salary;
2013: end if;
2014: --

Line 2016: l_min_salary :=irc_isc_shd.g_old_rec.min_salary;

2012: l_max_salary := p_max_salary;
2013: end if;
2014: --
2015: if (p_min_salary = hr_api.g_number) then
2016: l_min_salary :=irc_isc_shd.g_old_rec.min_salary;
2017: else
2018: l_min_salary := p_min_salary;
2019: end if;
2020: --

Line 2024: NVL(irc_isc_shd.g_old_rec.salary_period,hr_api.g_varchar2)

2020: --
2021: hr_utility.set_location(l_proc,30);
2022: if (l_api_updating and
2023: p_salary_period <>
2024: NVL(irc_isc_shd.g_old_rec.salary_period,hr_api.g_varchar2)
2025: ) or (NOT l_api_updating) then
2026: -- Check that p_salary_period is not null if there is a salary
2027: if ((l_max_salary is not null or l_min_salary is not null)
2028: and p_salary_period is null) then

Line 2117: l_api_updating := irc_isc_shd.api_updating

2113: ( p_check_column1 => 'IRC_SEARCH_CRITERIA.MIN_SALARY'
2114: ,p_check_column2 => 'IRC_SEARCH_CRITERIA.MAX_SALARY'
2115: ) then
2116: --
2117: l_api_updating := irc_isc_shd.api_updating
2118: (p_search_criteria_id => p_search_criteria_id
2119: ,p_object_version_number => p_object_version_number
2120: );
2121: --

Line 2125: NVL(irc_isc_shd.g_old_rec.salary_currency,hr_api.g_varchar2))

2121: --
2122: hr_utility.set_location(l_proc,20);
2123: if (l_api_updating and
2124: (NVL(p_salary_currency,hr_api.g_varchar2) <>
2125: NVL(irc_isc_shd.g_old_rec.salary_currency,hr_api.g_varchar2))
2126: or
2127: (NVL(p_max_salary,hr_api.g_number) <>
2128: NVL(irc_isc_shd.g_old_rec.max_salary,hr_api.g_number))
2129: or

Line 2128: NVL(irc_isc_shd.g_old_rec.max_salary,hr_api.g_number))

2124: (NVL(p_salary_currency,hr_api.g_varchar2) <>
2125: NVL(irc_isc_shd.g_old_rec.salary_currency,hr_api.g_varchar2))
2126: or
2127: (NVL(p_max_salary,hr_api.g_number) <>
2128: NVL(irc_isc_shd.g_old_rec.max_salary,hr_api.g_number))
2129: or
2130: (NVL(p_min_salary,hr_api.g_number) <>
2131: NVL(irc_isc_shd.g_old_rec.min_salary,hr_api.g_number))
2132: )

Line 2131: NVL(irc_isc_shd.g_old_rec.min_salary,hr_api.g_number))

2127: (NVL(p_max_salary,hr_api.g_number) <>
2128: NVL(irc_isc_shd.g_old_rec.max_salary,hr_api.g_number))
2129: or
2130: (NVL(p_min_salary,hr_api.g_number) <>
2131: NVL(irc_isc_shd.g_old_rec.min_salary,hr_api.g_number))
2132: )
2133: or (NOT l_api_updating) then
2134: --
2135: -- Check that salary currency is not null if either min_sal or max_sal is

Line 2223: l_api_updating := irc_isc_shd.api_updating

2219: hr_utility.set_location('Entering:'||l_proc,10);
2220: if p_date_posted is not null then
2221: --
2222: hr_utility.set_location(l_proc,20);
2223: l_api_updating := irc_isc_shd.api_updating
2224: (p_search_criteria_id => p_search_criteria_id
2225: ,p_object_version_number => p_object_version_number
2226: );
2227: --

Line 2231: NVL(irc_isc_shd.g_old_rec.date_posted,hr_api.g_varchar2)

2227: --
2228: hr_utility.set_location(l_proc,30);
2229: if (l_api_updating and
2230: p_date_posted <>
2231: NVL(irc_isc_shd.g_old_rec.date_posted,hr_api.g_varchar2)
2232: ) or (NOT l_api_updating) then
2233: -- Check that date_posted exists in hr_lookups
2234: hr_utility.set_location(l_proc,40);
2235: l_ret := hr_api.not_exists_in_hr_lookups(

Line 2348: l_api_updating := irc_isc_shd.api_updating

2344: hr_utility.set_location('Entering:'||l_proc,10);
2345: if p_keywords is not null then
2346: --
2347: hr_utility.set_location(l_proc,20);
2348: l_api_updating := irc_isc_shd.api_updating
2349: (p_search_criteria_id => p_search_criteria_id
2350: ,p_object_version_number => p_object_version_number
2351: );
2352: --

Line 2356: NVL(irc_isc_shd.g_old_rec.keywords,hr_api.g_varchar2)

2352: --
2353: hr_utility.set_location(l_proc,30);
2354: if ((l_api_updating and
2355: p_keywords <>
2356: NVL(irc_isc_shd.g_old_rec.keywords,hr_api.g_varchar2)
2357: ) or (NOT l_api_updating)) then
2358: hr_utility.set_location(l_proc,40);
2359: --
2360: -- Check the validity of the keywords by using the

Line 2389: ,p_rec in irc_isc_shd.g_rec_type

2385: -- |---------------------------< insert_validate >----------------------------|
2386: -- ----------------------------------------------------------------------------
2387: Procedure insert_validate
2388: (p_effective_date in date
2389: ,p_rec in irc_isc_shd.g_rec_type
2390: ) is
2391: --
2392: l_proc varchar2(72) := g_package||'insert_validate';
2393: --

Line 2640: ,p_rec in irc_isc_shd.g_rec_type

2636: -- |---------------------------< update_validate >----------------------------|
2637: -- ----------------------------------------------------------------------------
2638: Procedure update_validate
2639: (p_effective_date in date
2640: ,p_rec in irc_isc_shd.g_rec_type
2641: ) is
2642: --
2643: l_proc varchar2(72) := g_package||'update_validate';
2644: --

Line 2873: (p_rec in irc_isc_shd.g_rec_type

2869: -- ----------------------------------------------------------------------------
2870: -- |---------------------------< delete_validate >----------------------------|
2871: -- ----------------------------------------------------------------------------
2872: Procedure delete_validate
2873: (p_rec in irc_isc_shd.g_rec_type
2874: ) is
2875: --
2876: l_proc varchar2(72) := g_package||'delete_validate';
2877: --