APPS.HR_WNP_BUS dependencies on HR_API

Line 69: hr_api.mandatory_arg_error

65: hr_utility.set_location('Entering:'|| l_proc, 10);
66: --
67: -- Ensure that all the mandatory parameter are not null
68: --
69: hr_api.mandatory_arg_error
70: (p_api_name => l_proc
71: ,p_argument => 'window_property_id'
72: ,p_argument_value => p_window_property_id
73: );

Line 75: if ( nvl(hr_wnp_bus.g_window_property_id, hr_api.g_number)

71: ,p_argument => 'window_property_id'
72: ,p_argument_value => p_window_property_id
73: );
74: --
75: if ( nvl(hr_wnp_bus.g_window_property_id, hr_api.g_number)
76: = p_window_property_id) then
77: --
78: -- The legislation code has already been found with a previous
79: -- call to this function. Just return the value in the global

Line 150: nvl(hr_wnp_shd.g_old_rec.information_category, hr_api.g_varchar2) <>

146: begin
147: hr_utility.set_location('Entering:'||l_proc,10);
148: --
149: if ((p_rec.window_property_id is not null) and (
150: nvl(hr_wnp_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
151: nvl(p_rec.information_category, hr_api.g_varchar2) or
152: nvl(hr_wnp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
153: nvl(p_rec.information1, hr_api.g_varchar2) or
154: nvl(hr_wnp_shd.g_old_rec.information2, hr_api.g_varchar2) <>

Line 151: nvl(p_rec.information_category, hr_api.g_varchar2) or

147: hr_utility.set_location('Entering:'||l_proc,10);
148: --
149: if ((p_rec.window_property_id is not null) and (
150: nvl(hr_wnp_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
151: nvl(p_rec.information_category, hr_api.g_varchar2) or
152: nvl(hr_wnp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
153: nvl(p_rec.information1, hr_api.g_varchar2) or
154: nvl(hr_wnp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
155: nvl(p_rec.information2, hr_api.g_varchar2) or

Line 152: nvl(hr_wnp_shd.g_old_rec.information1, hr_api.g_varchar2) <>

148: --
149: if ((p_rec.window_property_id is not null) and (
150: nvl(hr_wnp_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
151: nvl(p_rec.information_category, hr_api.g_varchar2) or
152: nvl(hr_wnp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
153: nvl(p_rec.information1, hr_api.g_varchar2) or
154: nvl(hr_wnp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
155: nvl(p_rec.information2, hr_api.g_varchar2) or
156: nvl(hr_wnp_shd.g_old_rec.information3, hr_api.g_varchar2) <>

Line 153: nvl(p_rec.information1, hr_api.g_varchar2) or

149: if ((p_rec.window_property_id is not null) and (
150: nvl(hr_wnp_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
151: nvl(p_rec.information_category, hr_api.g_varchar2) or
152: nvl(hr_wnp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
153: nvl(p_rec.information1, hr_api.g_varchar2) or
154: nvl(hr_wnp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
155: nvl(p_rec.information2, hr_api.g_varchar2) or
156: nvl(hr_wnp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
157: nvl(p_rec.information3, hr_api.g_varchar2) or

Line 154: nvl(hr_wnp_shd.g_old_rec.information2, hr_api.g_varchar2) <>

150: nvl(hr_wnp_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
151: nvl(p_rec.information_category, hr_api.g_varchar2) or
152: nvl(hr_wnp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
153: nvl(p_rec.information1, hr_api.g_varchar2) or
154: nvl(hr_wnp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
155: nvl(p_rec.information2, hr_api.g_varchar2) or
156: nvl(hr_wnp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
157: nvl(p_rec.information3, hr_api.g_varchar2) or
158: nvl(hr_wnp_shd.g_old_rec.information4, hr_api.g_varchar2) <>

Line 155: nvl(p_rec.information2, hr_api.g_varchar2) or

151: nvl(p_rec.information_category, hr_api.g_varchar2) or
152: nvl(hr_wnp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
153: nvl(p_rec.information1, hr_api.g_varchar2) or
154: nvl(hr_wnp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
155: nvl(p_rec.information2, hr_api.g_varchar2) or
156: nvl(hr_wnp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
157: nvl(p_rec.information3, hr_api.g_varchar2) or
158: nvl(hr_wnp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
159: nvl(p_rec.information4, hr_api.g_varchar2) or

Line 156: nvl(hr_wnp_shd.g_old_rec.information3, hr_api.g_varchar2) <>

152: nvl(hr_wnp_shd.g_old_rec.information1, hr_api.g_varchar2) <>
153: nvl(p_rec.information1, hr_api.g_varchar2) or
154: nvl(hr_wnp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
155: nvl(p_rec.information2, hr_api.g_varchar2) or
156: nvl(hr_wnp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
157: nvl(p_rec.information3, hr_api.g_varchar2) or
158: nvl(hr_wnp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
159: nvl(p_rec.information4, hr_api.g_varchar2) or
160: nvl(hr_wnp_shd.g_old_rec.information5, hr_api.g_varchar2) <>

Line 157: nvl(p_rec.information3, hr_api.g_varchar2) or

153: nvl(p_rec.information1, hr_api.g_varchar2) or
154: nvl(hr_wnp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
155: nvl(p_rec.information2, hr_api.g_varchar2) or
156: nvl(hr_wnp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
157: nvl(p_rec.information3, hr_api.g_varchar2) or
158: nvl(hr_wnp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
159: nvl(p_rec.information4, hr_api.g_varchar2) or
160: nvl(hr_wnp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
161: nvl(p_rec.information5, hr_api.g_varchar2) or

Line 158: nvl(hr_wnp_shd.g_old_rec.information4, hr_api.g_varchar2) <>

154: nvl(hr_wnp_shd.g_old_rec.information2, hr_api.g_varchar2) <>
155: nvl(p_rec.information2, hr_api.g_varchar2) or
156: nvl(hr_wnp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
157: nvl(p_rec.information3, hr_api.g_varchar2) or
158: nvl(hr_wnp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
159: nvl(p_rec.information4, hr_api.g_varchar2) or
160: nvl(hr_wnp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
161: nvl(p_rec.information5, hr_api.g_varchar2) or
162: nvl(hr_wnp_shd.g_old_rec.information6, hr_api.g_varchar2) <>

Line 159: nvl(p_rec.information4, hr_api.g_varchar2) or

155: nvl(p_rec.information2, hr_api.g_varchar2) or
156: nvl(hr_wnp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
157: nvl(p_rec.information3, hr_api.g_varchar2) or
158: nvl(hr_wnp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
159: nvl(p_rec.information4, hr_api.g_varchar2) or
160: nvl(hr_wnp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
161: nvl(p_rec.information5, hr_api.g_varchar2) or
162: nvl(hr_wnp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
163: nvl(p_rec.information6, hr_api.g_varchar2) or

Line 160: nvl(hr_wnp_shd.g_old_rec.information5, hr_api.g_varchar2) <>

156: nvl(hr_wnp_shd.g_old_rec.information3, hr_api.g_varchar2) <>
157: nvl(p_rec.information3, hr_api.g_varchar2) or
158: nvl(hr_wnp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
159: nvl(p_rec.information4, hr_api.g_varchar2) or
160: nvl(hr_wnp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
161: nvl(p_rec.information5, hr_api.g_varchar2) or
162: nvl(hr_wnp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
163: nvl(p_rec.information6, hr_api.g_varchar2) or
164: nvl(hr_wnp_shd.g_old_rec.information7, hr_api.g_varchar2) <>

Line 161: nvl(p_rec.information5, hr_api.g_varchar2) or

157: nvl(p_rec.information3, hr_api.g_varchar2) or
158: nvl(hr_wnp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
159: nvl(p_rec.information4, hr_api.g_varchar2) or
160: nvl(hr_wnp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
161: nvl(p_rec.information5, hr_api.g_varchar2) or
162: nvl(hr_wnp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
163: nvl(p_rec.information6, hr_api.g_varchar2) or
164: nvl(hr_wnp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
165: nvl(p_rec.information7, hr_api.g_varchar2) or

Line 162: nvl(hr_wnp_shd.g_old_rec.information6, hr_api.g_varchar2) <>

158: nvl(hr_wnp_shd.g_old_rec.information4, hr_api.g_varchar2) <>
159: nvl(p_rec.information4, hr_api.g_varchar2) or
160: nvl(hr_wnp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
161: nvl(p_rec.information5, hr_api.g_varchar2) or
162: nvl(hr_wnp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
163: nvl(p_rec.information6, hr_api.g_varchar2) or
164: nvl(hr_wnp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
165: nvl(p_rec.information7, hr_api.g_varchar2) or
166: nvl(hr_wnp_shd.g_old_rec.information8, hr_api.g_varchar2) <>

Line 163: nvl(p_rec.information6, hr_api.g_varchar2) or

159: nvl(p_rec.information4, hr_api.g_varchar2) or
160: nvl(hr_wnp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
161: nvl(p_rec.information5, hr_api.g_varchar2) or
162: nvl(hr_wnp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
163: nvl(p_rec.information6, hr_api.g_varchar2) or
164: nvl(hr_wnp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
165: nvl(p_rec.information7, hr_api.g_varchar2) or
166: nvl(hr_wnp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
167: nvl(p_rec.information8, hr_api.g_varchar2) or

Line 164: nvl(hr_wnp_shd.g_old_rec.information7, hr_api.g_varchar2) <>

160: nvl(hr_wnp_shd.g_old_rec.information5, hr_api.g_varchar2) <>
161: nvl(p_rec.information5, hr_api.g_varchar2) or
162: nvl(hr_wnp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
163: nvl(p_rec.information6, hr_api.g_varchar2) or
164: nvl(hr_wnp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
165: nvl(p_rec.information7, hr_api.g_varchar2) or
166: nvl(hr_wnp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
167: nvl(p_rec.information8, hr_api.g_varchar2) or
168: nvl(hr_wnp_shd.g_old_rec.information9, hr_api.g_varchar2) <>

Line 165: nvl(p_rec.information7, hr_api.g_varchar2) or

161: nvl(p_rec.information5, hr_api.g_varchar2) or
162: nvl(hr_wnp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
163: nvl(p_rec.information6, hr_api.g_varchar2) or
164: nvl(hr_wnp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
165: nvl(p_rec.information7, hr_api.g_varchar2) or
166: nvl(hr_wnp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
167: nvl(p_rec.information8, hr_api.g_varchar2) or
168: nvl(hr_wnp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
169: nvl(p_rec.information9, hr_api.g_varchar2) or

Line 166: nvl(hr_wnp_shd.g_old_rec.information8, hr_api.g_varchar2) <>

162: nvl(hr_wnp_shd.g_old_rec.information6, hr_api.g_varchar2) <>
163: nvl(p_rec.information6, hr_api.g_varchar2) or
164: nvl(hr_wnp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
165: nvl(p_rec.information7, hr_api.g_varchar2) or
166: nvl(hr_wnp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
167: nvl(p_rec.information8, hr_api.g_varchar2) or
168: nvl(hr_wnp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
169: nvl(p_rec.information9, hr_api.g_varchar2) or
170: nvl(hr_wnp_shd.g_old_rec.information10, hr_api.g_varchar2) <>

Line 167: nvl(p_rec.information8, hr_api.g_varchar2) or

163: nvl(p_rec.information6, hr_api.g_varchar2) or
164: nvl(hr_wnp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
165: nvl(p_rec.information7, hr_api.g_varchar2) or
166: nvl(hr_wnp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
167: nvl(p_rec.information8, hr_api.g_varchar2) or
168: nvl(hr_wnp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
169: nvl(p_rec.information9, hr_api.g_varchar2) or
170: nvl(hr_wnp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
171: nvl(p_rec.information10, hr_api.g_varchar2) or

Line 168: nvl(hr_wnp_shd.g_old_rec.information9, hr_api.g_varchar2) <>

164: nvl(hr_wnp_shd.g_old_rec.information7, hr_api.g_varchar2) <>
165: nvl(p_rec.information7, hr_api.g_varchar2) or
166: nvl(hr_wnp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
167: nvl(p_rec.information8, hr_api.g_varchar2) or
168: nvl(hr_wnp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
169: nvl(p_rec.information9, hr_api.g_varchar2) or
170: nvl(hr_wnp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
171: nvl(p_rec.information10, hr_api.g_varchar2) or
172: nvl(hr_wnp_shd.g_old_rec.information11, hr_api.g_varchar2) <>

Line 169: nvl(p_rec.information9, hr_api.g_varchar2) or

165: nvl(p_rec.information7, hr_api.g_varchar2) or
166: nvl(hr_wnp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
167: nvl(p_rec.information8, hr_api.g_varchar2) or
168: nvl(hr_wnp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
169: nvl(p_rec.information9, hr_api.g_varchar2) or
170: nvl(hr_wnp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
171: nvl(p_rec.information10, hr_api.g_varchar2) or
172: nvl(hr_wnp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
173: nvl(p_rec.information11, hr_api.g_varchar2) or

Line 170: nvl(hr_wnp_shd.g_old_rec.information10, hr_api.g_varchar2) <>

166: nvl(hr_wnp_shd.g_old_rec.information8, hr_api.g_varchar2) <>
167: nvl(p_rec.information8, hr_api.g_varchar2) or
168: nvl(hr_wnp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
169: nvl(p_rec.information9, hr_api.g_varchar2) or
170: nvl(hr_wnp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
171: nvl(p_rec.information10, hr_api.g_varchar2) or
172: nvl(hr_wnp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
173: nvl(p_rec.information11, hr_api.g_varchar2) or
174: nvl(hr_wnp_shd.g_old_rec.information12, hr_api.g_varchar2) <>

Line 171: nvl(p_rec.information10, hr_api.g_varchar2) or

167: nvl(p_rec.information8, hr_api.g_varchar2) or
168: nvl(hr_wnp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
169: nvl(p_rec.information9, hr_api.g_varchar2) or
170: nvl(hr_wnp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
171: nvl(p_rec.information10, hr_api.g_varchar2) or
172: nvl(hr_wnp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
173: nvl(p_rec.information11, hr_api.g_varchar2) or
174: nvl(hr_wnp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
175: nvl(p_rec.information12, hr_api.g_varchar2) or

Line 172: nvl(hr_wnp_shd.g_old_rec.information11, hr_api.g_varchar2) <>

168: nvl(hr_wnp_shd.g_old_rec.information9, hr_api.g_varchar2) <>
169: nvl(p_rec.information9, hr_api.g_varchar2) or
170: nvl(hr_wnp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
171: nvl(p_rec.information10, hr_api.g_varchar2) or
172: nvl(hr_wnp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
173: nvl(p_rec.information11, hr_api.g_varchar2) or
174: nvl(hr_wnp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
175: nvl(p_rec.information12, hr_api.g_varchar2) or
176: nvl(hr_wnp_shd.g_old_rec.information13, hr_api.g_varchar2) <>

Line 173: nvl(p_rec.information11, hr_api.g_varchar2) or

169: nvl(p_rec.information9, hr_api.g_varchar2) or
170: nvl(hr_wnp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
171: nvl(p_rec.information10, hr_api.g_varchar2) or
172: nvl(hr_wnp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
173: nvl(p_rec.information11, hr_api.g_varchar2) or
174: nvl(hr_wnp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
175: nvl(p_rec.information12, hr_api.g_varchar2) or
176: nvl(hr_wnp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
177: nvl(p_rec.information13, hr_api.g_varchar2) or

Line 174: nvl(hr_wnp_shd.g_old_rec.information12, hr_api.g_varchar2) <>

170: nvl(hr_wnp_shd.g_old_rec.information10, hr_api.g_varchar2) <>
171: nvl(p_rec.information10, hr_api.g_varchar2) or
172: nvl(hr_wnp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
173: nvl(p_rec.information11, hr_api.g_varchar2) or
174: nvl(hr_wnp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
175: nvl(p_rec.information12, hr_api.g_varchar2) or
176: nvl(hr_wnp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
177: nvl(p_rec.information13, hr_api.g_varchar2) or
178: nvl(hr_wnp_shd.g_old_rec.information14, hr_api.g_varchar2) <>

Line 175: nvl(p_rec.information12, hr_api.g_varchar2) or

171: nvl(p_rec.information10, hr_api.g_varchar2) or
172: nvl(hr_wnp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
173: nvl(p_rec.information11, hr_api.g_varchar2) or
174: nvl(hr_wnp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
175: nvl(p_rec.information12, hr_api.g_varchar2) or
176: nvl(hr_wnp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
177: nvl(p_rec.information13, hr_api.g_varchar2) or
178: nvl(hr_wnp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
179: nvl(p_rec.information14, hr_api.g_varchar2) or

Line 176: nvl(hr_wnp_shd.g_old_rec.information13, hr_api.g_varchar2) <>

172: nvl(hr_wnp_shd.g_old_rec.information11, hr_api.g_varchar2) <>
173: nvl(p_rec.information11, hr_api.g_varchar2) or
174: nvl(hr_wnp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
175: nvl(p_rec.information12, hr_api.g_varchar2) or
176: nvl(hr_wnp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
177: nvl(p_rec.information13, hr_api.g_varchar2) or
178: nvl(hr_wnp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
179: nvl(p_rec.information14, hr_api.g_varchar2) or
180: nvl(hr_wnp_shd.g_old_rec.information15, hr_api.g_varchar2) <>

Line 177: nvl(p_rec.information13, hr_api.g_varchar2) or

173: nvl(p_rec.information11, hr_api.g_varchar2) or
174: nvl(hr_wnp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
175: nvl(p_rec.information12, hr_api.g_varchar2) or
176: nvl(hr_wnp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
177: nvl(p_rec.information13, hr_api.g_varchar2) or
178: nvl(hr_wnp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
179: nvl(p_rec.information14, hr_api.g_varchar2) or
180: nvl(hr_wnp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
181: nvl(p_rec.information15, hr_api.g_varchar2) or

Line 178: nvl(hr_wnp_shd.g_old_rec.information14, hr_api.g_varchar2) <>

174: nvl(hr_wnp_shd.g_old_rec.information12, hr_api.g_varchar2) <>
175: nvl(p_rec.information12, hr_api.g_varchar2) or
176: nvl(hr_wnp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
177: nvl(p_rec.information13, hr_api.g_varchar2) or
178: nvl(hr_wnp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
179: nvl(p_rec.information14, hr_api.g_varchar2) or
180: nvl(hr_wnp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
181: nvl(p_rec.information15, hr_api.g_varchar2) or
182: nvl(hr_wnp_shd.g_old_rec.information16, hr_api.g_varchar2) <>

Line 179: nvl(p_rec.information14, hr_api.g_varchar2) or

175: nvl(p_rec.information12, hr_api.g_varchar2) or
176: nvl(hr_wnp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
177: nvl(p_rec.information13, hr_api.g_varchar2) or
178: nvl(hr_wnp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
179: nvl(p_rec.information14, hr_api.g_varchar2) or
180: nvl(hr_wnp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
181: nvl(p_rec.information15, hr_api.g_varchar2) or
182: nvl(hr_wnp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
183: nvl(p_rec.information16, hr_api.g_varchar2) or

Line 180: nvl(hr_wnp_shd.g_old_rec.information15, hr_api.g_varchar2) <>

176: nvl(hr_wnp_shd.g_old_rec.information13, hr_api.g_varchar2) <>
177: nvl(p_rec.information13, hr_api.g_varchar2) or
178: nvl(hr_wnp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
179: nvl(p_rec.information14, hr_api.g_varchar2) or
180: nvl(hr_wnp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
181: nvl(p_rec.information15, hr_api.g_varchar2) or
182: nvl(hr_wnp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
183: nvl(p_rec.information16, hr_api.g_varchar2) or
184: nvl(hr_wnp_shd.g_old_rec.information17, hr_api.g_varchar2) <>

Line 181: nvl(p_rec.information15, hr_api.g_varchar2) or

177: nvl(p_rec.information13, hr_api.g_varchar2) or
178: nvl(hr_wnp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
179: nvl(p_rec.information14, hr_api.g_varchar2) or
180: nvl(hr_wnp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
181: nvl(p_rec.information15, hr_api.g_varchar2) or
182: nvl(hr_wnp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
183: nvl(p_rec.information16, hr_api.g_varchar2) or
184: nvl(hr_wnp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
185: nvl(p_rec.information17, hr_api.g_varchar2) or

Line 182: nvl(hr_wnp_shd.g_old_rec.information16, hr_api.g_varchar2) <>

178: nvl(hr_wnp_shd.g_old_rec.information14, hr_api.g_varchar2) <>
179: nvl(p_rec.information14, hr_api.g_varchar2) or
180: nvl(hr_wnp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
181: nvl(p_rec.information15, hr_api.g_varchar2) or
182: nvl(hr_wnp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
183: nvl(p_rec.information16, hr_api.g_varchar2) or
184: nvl(hr_wnp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
185: nvl(p_rec.information17, hr_api.g_varchar2) or
186: nvl(hr_wnp_shd.g_old_rec.information18, hr_api.g_varchar2) <>

Line 183: nvl(p_rec.information16, hr_api.g_varchar2) or

179: nvl(p_rec.information14, hr_api.g_varchar2) or
180: nvl(hr_wnp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
181: nvl(p_rec.information15, hr_api.g_varchar2) or
182: nvl(hr_wnp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
183: nvl(p_rec.information16, hr_api.g_varchar2) or
184: nvl(hr_wnp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
185: nvl(p_rec.information17, hr_api.g_varchar2) or
186: nvl(hr_wnp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
187: nvl(p_rec.information18, hr_api.g_varchar2) or

Line 184: nvl(hr_wnp_shd.g_old_rec.information17, hr_api.g_varchar2) <>

180: nvl(hr_wnp_shd.g_old_rec.information15, hr_api.g_varchar2) <>
181: nvl(p_rec.information15, hr_api.g_varchar2) or
182: nvl(hr_wnp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
183: nvl(p_rec.information16, hr_api.g_varchar2) or
184: nvl(hr_wnp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
185: nvl(p_rec.information17, hr_api.g_varchar2) or
186: nvl(hr_wnp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
187: nvl(p_rec.information18, hr_api.g_varchar2) or
188: nvl(hr_wnp_shd.g_old_rec.information19, hr_api.g_varchar2) <>

Line 185: nvl(p_rec.information17, hr_api.g_varchar2) or

181: nvl(p_rec.information15, hr_api.g_varchar2) or
182: nvl(hr_wnp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
183: nvl(p_rec.information16, hr_api.g_varchar2) or
184: nvl(hr_wnp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
185: nvl(p_rec.information17, hr_api.g_varchar2) or
186: nvl(hr_wnp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
187: nvl(p_rec.information18, hr_api.g_varchar2) or
188: nvl(hr_wnp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
189: nvl(p_rec.information19, hr_api.g_varchar2) or

Line 186: nvl(hr_wnp_shd.g_old_rec.information18, hr_api.g_varchar2) <>

182: nvl(hr_wnp_shd.g_old_rec.information16, hr_api.g_varchar2) <>
183: nvl(p_rec.information16, hr_api.g_varchar2) or
184: nvl(hr_wnp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
185: nvl(p_rec.information17, hr_api.g_varchar2) or
186: nvl(hr_wnp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
187: nvl(p_rec.information18, hr_api.g_varchar2) or
188: nvl(hr_wnp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
189: nvl(p_rec.information19, hr_api.g_varchar2) or
190: nvl(hr_wnp_shd.g_old_rec.information20, hr_api.g_varchar2) <>

Line 187: nvl(p_rec.information18, hr_api.g_varchar2) or

183: nvl(p_rec.information16, hr_api.g_varchar2) or
184: nvl(hr_wnp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
185: nvl(p_rec.information17, hr_api.g_varchar2) or
186: nvl(hr_wnp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
187: nvl(p_rec.information18, hr_api.g_varchar2) or
188: nvl(hr_wnp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
189: nvl(p_rec.information19, hr_api.g_varchar2) or
190: nvl(hr_wnp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
191: nvl(p_rec.information20, hr_api.g_varchar2) or

Line 188: nvl(hr_wnp_shd.g_old_rec.information19, hr_api.g_varchar2) <>

184: nvl(hr_wnp_shd.g_old_rec.information17, hr_api.g_varchar2) <>
185: nvl(p_rec.information17, hr_api.g_varchar2) or
186: nvl(hr_wnp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
187: nvl(p_rec.information18, hr_api.g_varchar2) or
188: nvl(hr_wnp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
189: nvl(p_rec.information19, hr_api.g_varchar2) or
190: nvl(hr_wnp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
191: nvl(p_rec.information20, hr_api.g_varchar2) or
192: nvl(hr_wnp_shd.g_old_rec.information21, hr_api.g_varchar2) <>

Line 189: nvl(p_rec.information19, hr_api.g_varchar2) or

185: nvl(p_rec.information17, hr_api.g_varchar2) or
186: nvl(hr_wnp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
187: nvl(p_rec.information18, hr_api.g_varchar2) or
188: nvl(hr_wnp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
189: nvl(p_rec.information19, hr_api.g_varchar2) or
190: nvl(hr_wnp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
191: nvl(p_rec.information20, hr_api.g_varchar2) or
192: nvl(hr_wnp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
193: nvl(p_rec.information21, hr_api.g_varchar2) or

Line 190: nvl(hr_wnp_shd.g_old_rec.information20, hr_api.g_varchar2) <>

186: nvl(hr_wnp_shd.g_old_rec.information18, hr_api.g_varchar2) <>
187: nvl(p_rec.information18, hr_api.g_varchar2) or
188: nvl(hr_wnp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
189: nvl(p_rec.information19, hr_api.g_varchar2) or
190: nvl(hr_wnp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
191: nvl(p_rec.information20, hr_api.g_varchar2) or
192: nvl(hr_wnp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
193: nvl(p_rec.information21, hr_api.g_varchar2) or
194: nvl(hr_wnp_shd.g_old_rec.information22, hr_api.g_varchar2) <>

Line 191: nvl(p_rec.information20, hr_api.g_varchar2) or

187: nvl(p_rec.information18, hr_api.g_varchar2) or
188: nvl(hr_wnp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
189: nvl(p_rec.information19, hr_api.g_varchar2) or
190: nvl(hr_wnp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
191: nvl(p_rec.information20, hr_api.g_varchar2) or
192: nvl(hr_wnp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
193: nvl(p_rec.information21, hr_api.g_varchar2) or
194: nvl(hr_wnp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
195: nvl(p_rec.information22, hr_api.g_varchar2) or

Line 192: nvl(hr_wnp_shd.g_old_rec.information21, hr_api.g_varchar2) <>

188: nvl(hr_wnp_shd.g_old_rec.information19, hr_api.g_varchar2) <>
189: nvl(p_rec.information19, hr_api.g_varchar2) or
190: nvl(hr_wnp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
191: nvl(p_rec.information20, hr_api.g_varchar2) or
192: nvl(hr_wnp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
193: nvl(p_rec.information21, hr_api.g_varchar2) or
194: nvl(hr_wnp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
195: nvl(p_rec.information22, hr_api.g_varchar2) or
196: nvl(hr_wnp_shd.g_old_rec.information23, hr_api.g_varchar2) <>

Line 193: nvl(p_rec.information21, hr_api.g_varchar2) or

189: nvl(p_rec.information19, hr_api.g_varchar2) or
190: nvl(hr_wnp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
191: nvl(p_rec.information20, hr_api.g_varchar2) or
192: nvl(hr_wnp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
193: nvl(p_rec.information21, hr_api.g_varchar2) or
194: nvl(hr_wnp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
195: nvl(p_rec.information22, hr_api.g_varchar2) or
196: nvl(hr_wnp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
197: nvl(p_rec.information23, hr_api.g_varchar2) or

Line 194: nvl(hr_wnp_shd.g_old_rec.information22, hr_api.g_varchar2) <>

190: nvl(hr_wnp_shd.g_old_rec.information20, hr_api.g_varchar2) <>
191: nvl(p_rec.information20, hr_api.g_varchar2) or
192: nvl(hr_wnp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
193: nvl(p_rec.information21, hr_api.g_varchar2) or
194: nvl(hr_wnp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
195: nvl(p_rec.information22, hr_api.g_varchar2) or
196: nvl(hr_wnp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
197: nvl(p_rec.information23, hr_api.g_varchar2) or
198: nvl(hr_wnp_shd.g_old_rec.information24, hr_api.g_varchar2) <>

Line 195: nvl(p_rec.information22, hr_api.g_varchar2) or

191: nvl(p_rec.information20, hr_api.g_varchar2) or
192: nvl(hr_wnp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
193: nvl(p_rec.information21, hr_api.g_varchar2) or
194: nvl(hr_wnp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
195: nvl(p_rec.information22, hr_api.g_varchar2) or
196: nvl(hr_wnp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
197: nvl(p_rec.information23, hr_api.g_varchar2) or
198: nvl(hr_wnp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
199: nvl(p_rec.information24, hr_api.g_varchar2) or

Line 196: nvl(hr_wnp_shd.g_old_rec.information23, hr_api.g_varchar2) <>

192: nvl(hr_wnp_shd.g_old_rec.information21, hr_api.g_varchar2) <>
193: nvl(p_rec.information21, hr_api.g_varchar2) or
194: nvl(hr_wnp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
195: nvl(p_rec.information22, hr_api.g_varchar2) or
196: nvl(hr_wnp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
197: nvl(p_rec.information23, hr_api.g_varchar2) or
198: nvl(hr_wnp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
199: nvl(p_rec.information24, hr_api.g_varchar2) or
200: nvl(hr_wnp_shd.g_old_rec.information25, hr_api.g_varchar2) <>

Line 197: nvl(p_rec.information23, hr_api.g_varchar2) or

193: nvl(p_rec.information21, hr_api.g_varchar2) or
194: nvl(hr_wnp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
195: nvl(p_rec.information22, hr_api.g_varchar2) or
196: nvl(hr_wnp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
197: nvl(p_rec.information23, hr_api.g_varchar2) or
198: nvl(hr_wnp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
199: nvl(p_rec.information24, hr_api.g_varchar2) or
200: nvl(hr_wnp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
201: nvl(p_rec.information25, hr_api.g_varchar2) or

Line 198: nvl(hr_wnp_shd.g_old_rec.information24, hr_api.g_varchar2) <>

194: nvl(hr_wnp_shd.g_old_rec.information22, hr_api.g_varchar2) <>
195: nvl(p_rec.information22, hr_api.g_varchar2) or
196: nvl(hr_wnp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
197: nvl(p_rec.information23, hr_api.g_varchar2) or
198: nvl(hr_wnp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
199: nvl(p_rec.information24, hr_api.g_varchar2) or
200: nvl(hr_wnp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
201: nvl(p_rec.information25, hr_api.g_varchar2) or
202: nvl(hr_wnp_shd.g_old_rec.information26, hr_api.g_varchar2) <>

Line 199: nvl(p_rec.information24, hr_api.g_varchar2) or

195: nvl(p_rec.information22, hr_api.g_varchar2) or
196: nvl(hr_wnp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
197: nvl(p_rec.information23, hr_api.g_varchar2) or
198: nvl(hr_wnp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
199: nvl(p_rec.information24, hr_api.g_varchar2) or
200: nvl(hr_wnp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
201: nvl(p_rec.information25, hr_api.g_varchar2) or
202: nvl(hr_wnp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
203: nvl(p_rec.information26, hr_api.g_varchar2) or

Line 200: nvl(hr_wnp_shd.g_old_rec.information25, hr_api.g_varchar2) <>

196: nvl(hr_wnp_shd.g_old_rec.information23, hr_api.g_varchar2) <>
197: nvl(p_rec.information23, hr_api.g_varchar2) or
198: nvl(hr_wnp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
199: nvl(p_rec.information24, hr_api.g_varchar2) or
200: nvl(hr_wnp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
201: nvl(p_rec.information25, hr_api.g_varchar2) or
202: nvl(hr_wnp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
203: nvl(p_rec.information26, hr_api.g_varchar2) or
204: nvl(hr_wnp_shd.g_old_rec.information27, hr_api.g_varchar2) <>

Line 201: nvl(p_rec.information25, hr_api.g_varchar2) or

197: nvl(p_rec.information23, hr_api.g_varchar2) or
198: nvl(hr_wnp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
199: nvl(p_rec.information24, hr_api.g_varchar2) or
200: nvl(hr_wnp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
201: nvl(p_rec.information25, hr_api.g_varchar2) or
202: nvl(hr_wnp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
203: nvl(p_rec.information26, hr_api.g_varchar2) or
204: nvl(hr_wnp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
205: nvl(p_rec.information27, hr_api.g_varchar2) or

Line 202: nvl(hr_wnp_shd.g_old_rec.information26, hr_api.g_varchar2) <>

198: nvl(hr_wnp_shd.g_old_rec.information24, hr_api.g_varchar2) <>
199: nvl(p_rec.information24, hr_api.g_varchar2) or
200: nvl(hr_wnp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
201: nvl(p_rec.information25, hr_api.g_varchar2) or
202: nvl(hr_wnp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
203: nvl(p_rec.information26, hr_api.g_varchar2) or
204: nvl(hr_wnp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
205: nvl(p_rec.information27, hr_api.g_varchar2) or
206: nvl(hr_wnp_shd.g_old_rec.information28, hr_api.g_varchar2) <>

Line 203: nvl(p_rec.information26, hr_api.g_varchar2) or

199: nvl(p_rec.information24, hr_api.g_varchar2) or
200: nvl(hr_wnp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
201: nvl(p_rec.information25, hr_api.g_varchar2) or
202: nvl(hr_wnp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
203: nvl(p_rec.information26, hr_api.g_varchar2) or
204: nvl(hr_wnp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
205: nvl(p_rec.information27, hr_api.g_varchar2) or
206: nvl(hr_wnp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
207: nvl(p_rec.information28, hr_api.g_varchar2) or

Line 204: nvl(hr_wnp_shd.g_old_rec.information27, hr_api.g_varchar2) <>

200: nvl(hr_wnp_shd.g_old_rec.information25, hr_api.g_varchar2) <>
201: nvl(p_rec.information25, hr_api.g_varchar2) or
202: nvl(hr_wnp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
203: nvl(p_rec.information26, hr_api.g_varchar2) or
204: nvl(hr_wnp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
205: nvl(p_rec.information27, hr_api.g_varchar2) or
206: nvl(hr_wnp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
207: nvl(p_rec.information28, hr_api.g_varchar2) or
208: nvl(hr_wnp_shd.g_old_rec.information29, hr_api.g_varchar2) <>

Line 205: nvl(p_rec.information27, hr_api.g_varchar2) or

201: nvl(p_rec.information25, hr_api.g_varchar2) or
202: nvl(hr_wnp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
203: nvl(p_rec.information26, hr_api.g_varchar2) or
204: nvl(hr_wnp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
205: nvl(p_rec.information27, hr_api.g_varchar2) or
206: nvl(hr_wnp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
207: nvl(p_rec.information28, hr_api.g_varchar2) or
208: nvl(hr_wnp_shd.g_old_rec.information29, hr_api.g_varchar2) <>
209: nvl(p_rec.information29, hr_api.g_varchar2) or

Line 206: nvl(hr_wnp_shd.g_old_rec.information28, hr_api.g_varchar2) <>

202: nvl(hr_wnp_shd.g_old_rec.information26, hr_api.g_varchar2) <>
203: nvl(p_rec.information26, hr_api.g_varchar2) or
204: nvl(hr_wnp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
205: nvl(p_rec.information27, hr_api.g_varchar2) or
206: nvl(hr_wnp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
207: nvl(p_rec.information28, hr_api.g_varchar2) or
208: nvl(hr_wnp_shd.g_old_rec.information29, hr_api.g_varchar2) <>
209: nvl(p_rec.information29, hr_api.g_varchar2) or
210: nvl(hr_wnp_shd.g_old_rec.information30, hr_api.g_varchar2) <>

Line 207: nvl(p_rec.information28, hr_api.g_varchar2) or

203: nvl(p_rec.information26, hr_api.g_varchar2) or
204: nvl(hr_wnp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
205: nvl(p_rec.information27, hr_api.g_varchar2) or
206: nvl(hr_wnp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
207: nvl(p_rec.information28, hr_api.g_varchar2) or
208: nvl(hr_wnp_shd.g_old_rec.information29, hr_api.g_varchar2) <>
209: nvl(p_rec.information29, hr_api.g_varchar2) or
210: nvl(hr_wnp_shd.g_old_rec.information30, hr_api.g_varchar2) <>
211: nvl(p_rec.information30, hr_api.g_varchar2) )

Line 208: nvl(hr_wnp_shd.g_old_rec.information29, hr_api.g_varchar2) <>

204: nvl(hr_wnp_shd.g_old_rec.information27, hr_api.g_varchar2) <>
205: nvl(p_rec.information27, hr_api.g_varchar2) or
206: nvl(hr_wnp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
207: nvl(p_rec.information28, hr_api.g_varchar2) or
208: nvl(hr_wnp_shd.g_old_rec.information29, hr_api.g_varchar2) <>
209: nvl(p_rec.information29, hr_api.g_varchar2) or
210: nvl(hr_wnp_shd.g_old_rec.information30, hr_api.g_varchar2) <>
211: nvl(p_rec.information30, hr_api.g_varchar2) )
212: or (p_rec.window_property_id is null) ) then

Line 209: nvl(p_rec.information29, hr_api.g_varchar2) or

205: nvl(p_rec.information27, hr_api.g_varchar2) or
206: nvl(hr_wnp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
207: nvl(p_rec.information28, hr_api.g_varchar2) or
208: nvl(hr_wnp_shd.g_old_rec.information29, hr_api.g_varchar2) <>
209: nvl(p_rec.information29, hr_api.g_varchar2) or
210: nvl(hr_wnp_shd.g_old_rec.information30, hr_api.g_varchar2) <>
211: nvl(p_rec.information30, hr_api.g_varchar2) )
212: or (p_rec.window_property_id is null) ) then
213: --

Line 210: nvl(hr_wnp_shd.g_old_rec.information30, hr_api.g_varchar2) <>

206: nvl(hr_wnp_shd.g_old_rec.information28, hr_api.g_varchar2) <>
207: nvl(p_rec.information28, hr_api.g_varchar2) or
208: nvl(hr_wnp_shd.g_old_rec.information29, hr_api.g_varchar2) <>
209: nvl(p_rec.information29, hr_api.g_varchar2) or
210: nvl(hr_wnp_shd.g_old_rec.information30, hr_api.g_varchar2) <>
211: nvl(p_rec.information30, hr_api.g_varchar2) )
212: or (p_rec.window_property_id is null) ) then
213: --
214: -- Only execute the validation if absolutely necessary:

Line 211: nvl(p_rec.information30, hr_api.g_varchar2) )

207: nvl(p_rec.information28, hr_api.g_varchar2) or
208: nvl(hr_wnp_shd.g_old_rec.information29, hr_api.g_varchar2) <>
209: nvl(p_rec.information29, hr_api.g_varchar2) or
210: nvl(hr_wnp_shd.g_old_rec.information30, hr_api.g_varchar2) <>
211: nvl(p_rec.information30, hr_api.g_varchar2) )
212: or (p_rec.window_property_id is null) ) then
213: --
214: -- Only execute the validation if absolutely necessary:
215: -- a) During update, the structure column value or any

Line 338: IF (nvl(p_rec.form_window_id,hr_api.g_number) <>

334: fnd_message.set_token('STEP ', '5');
335: fnd_message.raise_error;
336: END IF;
337: --
338: IF (nvl(p_rec.form_window_id,hr_api.g_number) <>
339: nvl(hr_wnp_shd.g_old_rec.form_window_id,hr_api.g_number)
340: ) THEN
341: l_argument := 'form_window_id';
342: RAISE l_error;

Line 339: nvl(hr_wnp_shd.g_old_rec.form_window_id,hr_api.g_number)

335: fnd_message.raise_error;
336: END IF;
337: --
338: IF (nvl(p_rec.form_window_id,hr_api.g_number) <>
339: nvl(hr_wnp_shd.g_old_rec.form_window_id,hr_api.g_number)
340: ) THEN
341: l_argument := 'form_window_id';
342: RAISE l_error;
343: END IF;

Line 345: IF (nvl(p_rec.template_window_id,hr_api.g_number) <>

341: l_argument := 'form_window_id';
342: RAISE l_error;
343: END IF;
344: --
345: IF (nvl(p_rec.template_window_id,hr_api.g_number) <>
346: nvl(hr_wnp_shd.g_old_rec.template_window_id,hr_api.g_number)
347: ) THEN
348: l_argument := 'template_window_id';
349: RAISE l_error;

Line 346: nvl(hr_wnp_shd.g_old_rec.template_window_id,hr_api.g_number)

342: RAISE l_error;
343: END IF;
344: --
345: IF (nvl(p_rec.template_window_id,hr_api.g_number) <>
346: nvl(hr_wnp_shd.g_old_rec.template_window_id,hr_api.g_number)
347: ) THEN
348: l_argument := 'template_window_id';
349: RAISE l_error;
350: END IF;

Line 354: hr_api.argument_changed_error

350: END IF;
351: --
352: EXCEPTION
353: WHEN l_error THEN
354: hr_api.argument_changed_error
355: (p_api_name => l_proc
356: ,p_argument => l_argument);
357: WHEN OTHERS THEN
358: RAISE;