APPS.PER_JOB_BUS dependencies on HR_API

Line 78: hr_api.mandatory_arg_error

74: hr_utility.set_location('Entering:'||l_proc, 1);
75: --
76: -- Check mandatory parameters have been set
77: --
78: hr_api.mandatory_arg_error
79: (p_api_name => l_proc
80: ,p_argument => 'job_definition_id'
81: ,p_argument_value => p_job_definition_id
82: );

Line 170: hr_api.mandatory_arg_error

166: --
167: -- Check mandatory parameters have been set
168: --
169:
170: hr_api.mandatory_arg_error
171: (p_api_name => l_proc
172: ,p_argument => 'date_from'
173: ,p_argument_value => p_date_from
174: );

Line 186: (nvl(per_job_shd.g_old_rec.date_to,hr_api.g_eot) <>

182: (p_job_id => p_job_id
183: ,p_object_version_number => p_object_version_number);
184: --
185: if (((l_api_updating and
186: (nvl(per_job_shd.g_old_rec.date_to,hr_api.g_eot) <>
187: nvl(p_date_to,hr_api.g_eot)) or
188: (per_job_shd.g_old_rec.date_from <> p_date_from)) or
189: (NOT l_api_updating))) then
190: --

Line 187: nvl(p_date_to,hr_api.g_eot)) or

183: ,p_object_version_number => p_object_version_number);
184: --
185: if (((l_api_updating and
186: (nvl(per_job_shd.g_old_rec.date_to,hr_api.g_eot) <>
187: nvl(p_date_to,hr_api.g_eot)) or
188: (per_job_shd.g_old_rec.date_from <> p_date_from)) or
189: (NOT l_api_updating))) then
190: --
191: -- Check that date_from <= date_to

Line 195: if p_date_from > nvl(p_date_to,hr_api.g_eot) then

191: -- Check that date_from <= date_to
192: --
193: hr_utility.set_location(l_proc, 3);
194: --
195: if p_date_from > nvl(p_date_to,hr_api.g_eot) then
196: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
197: hr_utility.set_message_token('PROCEDURE', l_proc);
198: hr_utility.set_message_token('STEP', '3');
199: hr_utility.raise_error;

Line 243: nvl(per_job_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

239: begin
240: hr_utility.set_location('Entering:'||l_proc, 10);
241: --
242: if ((p_rec.job_id is not null) and (
243: nvl(per_job_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
244: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
245: nvl(per_job_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
246: nvl(p_rec.attribute1, hr_api.g_varchar2) or
247: nvl(per_job_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 244: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

240: hr_utility.set_location('Entering:'||l_proc, 10);
241: --
242: if ((p_rec.job_id is not null) and (
243: nvl(per_job_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
244: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
245: nvl(per_job_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
246: nvl(p_rec.attribute1, hr_api.g_varchar2) or
247: nvl(per_job_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
248: nvl(p_rec.attribute2, hr_api.g_varchar2) or

Line 245: nvl(per_job_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

241: --
242: if ((p_rec.job_id is not null) and (
243: nvl(per_job_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
244: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
245: nvl(per_job_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
246: nvl(p_rec.attribute1, hr_api.g_varchar2) or
247: nvl(per_job_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
248: nvl(p_rec.attribute2, hr_api.g_varchar2) or
249: nvl(per_job_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 246: nvl(p_rec.attribute1, hr_api.g_varchar2) or

242: if ((p_rec.job_id is not null) and (
243: nvl(per_job_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
244: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
245: nvl(per_job_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
246: nvl(p_rec.attribute1, hr_api.g_varchar2) or
247: nvl(per_job_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
248: nvl(p_rec.attribute2, hr_api.g_varchar2) or
249: nvl(per_job_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
250: nvl(p_rec.attribute3, hr_api.g_varchar2) or

Line 247: nvl(per_job_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

243: nvl(per_job_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
244: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
245: nvl(per_job_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
246: nvl(p_rec.attribute1, hr_api.g_varchar2) or
247: nvl(per_job_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
248: nvl(p_rec.attribute2, hr_api.g_varchar2) or
249: nvl(per_job_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
250: nvl(p_rec.attribute3, hr_api.g_varchar2) or
251: nvl(per_job_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 248: nvl(p_rec.attribute2, hr_api.g_varchar2) or

244: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
245: nvl(per_job_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
246: nvl(p_rec.attribute1, hr_api.g_varchar2) or
247: nvl(per_job_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
248: nvl(p_rec.attribute2, hr_api.g_varchar2) or
249: nvl(per_job_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
250: nvl(p_rec.attribute3, hr_api.g_varchar2) or
251: nvl(per_job_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
252: nvl(p_rec.attribute4, hr_api.g_varchar2) or

Line 249: nvl(per_job_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

245: nvl(per_job_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
246: nvl(p_rec.attribute1, hr_api.g_varchar2) or
247: nvl(per_job_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
248: nvl(p_rec.attribute2, hr_api.g_varchar2) or
249: nvl(per_job_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
250: nvl(p_rec.attribute3, hr_api.g_varchar2) or
251: nvl(per_job_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
252: nvl(p_rec.attribute4, hr_api.g_varchar2) or
253: nvl(per_job_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 250: nvl(p_rec.attribute3, hr_api.g_varchar2) or

246: nvl(p_rec.attribute1, hr_api.g_varchar2) or
247: nvl(per_job_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
248: nvl(p_rec.attribute2, hr_api.g_varchar2) or
249: nvl(per_job_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
250: nvl(p_rec.attribute3, hr_api.g_varchar2) or
251: nvl(per_job_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
252: nvl(p_rec.attribute4, hr_api.g_varchar2) or
253: nvl(per_job_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
254: nvl(p_rec.attribute5, hr_api.g_varchar2) or

Line 251: nvl(per_job_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

247: nvl(per_job_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
248: nvl(p_rec.attribute2, hr_api.g_varchar2) or
249: nvl(per_job_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
250: nvl(p_rec.attribute3, hr_api.g_varchar2) or
251: nvl(per_job_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
252: nvl(p_rec.attribute4, hr_api.g_varchar2) or
253: nvl(per_job_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
254: nvl(p_rec.attribute5, hr_api.g_varchar2) or
255: nvl(per_job_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 252: nvl(p_rec.attribute4, hr_api.g_varchar2) or

248: nvl(p_rec.attribute2, hr_api.g_varchar2) or
249: nvl(per_job_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
250: nvl(p_rec.attribute3, hr_api.g_varchar2) or
251: nvl(per_job_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
252: nvl(p_rec.attribute4, hr_api.g_varchar2) or
253: nvl(per_job_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
254: nvl(p_rec.attribute5, hr_api.g_varchar2) or
255: nvl(per_job_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
256: nvl(p_rec.attribute6, hr_api.g_varchar2) or

Line 253: nvl(per_job_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

249: nvl(per_job_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
250: nvl(p_rec.attribute3, hr_api.g_varchar2) or
251: nvl(per_job_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
252: nvl(p_rec.attribute4, hr_api.g_varchar2) or
253: nvl(per_job_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
254: nvl(p_rec.attribute5, hr_api.g_varchar2) or
255: nvl(per_job_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
256: nvl(p_rec.attribute6, hr_api.g_varchar2) or
257: nvl(per_job_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 254: nvl(p_rec.attribute5, hr_api.g_varchar2) or

250: nvl(p_rec.attribute3, hr_api.g_varchar2) or
251: nvl(per_job_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
252: nvl(p_rec.attribute4, hr_api.g_varchar2) or
253: nvl(per_job_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
254: nvl(p_rec.attribute5, hr_api.g_varchar2) or
255: nvl(per_job_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
256: nvl(p_rec.attribute6, hr_api.g_varchar2) or
257: nvl(per_job_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
258: nvl(p_rec.attribute7, hr_api.g_varchar2) or

Line 255: nvl(per_job_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

251: nvl(per_job_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
252: nvl(p_rec.attribute4, hr_api.g_varchar2) or
253: nvl(per_job_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
254: nvl(p_rec.attribute5, hr_api.g_varchar2) or
255: nvl(per_job_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
256: nvl(p_rec.attribute6, hr_api.g_varchar2) or
257: nvl(per_job_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
258: nvl(p_rec.attribute7, hr_api.g_varchar2) or
259: nvl(per_job_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 256: nvl(p_rec.attribute6, hr_api.g_varchar2) or

252: nvl(p_rec.attribute4, hr_api.g_varchar2) or
253: nvl(per_job_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
254: nvl(p_rec.attribute5, hr_api.g_varchar2) or
255: nvl(per_job_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
256: nvl(p_rec.attribute6, hr_api.g_varchar2) or
257: nvl(per_job_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
258: nvl(p_rec.attribute7, hr_api.g_varchar2) or
259: nvl(per_job_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
260: nvl(p_rec.attribute8, hr_api.g_varchar2) or

Line 257: nvl(per_job_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

253: nvl(per_job_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
254: nvl(p_rec.attribute5, hr_api.g_varchar2) or
255: nvl(per_job_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
256: nvl(p_rec.attribute6, hr_api.g_varchar2) or
257: nvl(per_job_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
258: nvl(p_rec.attribute7, hr_api.g_varchar2) or
259: nvl(per_job_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
260: nvl(p_rec.attribute8, hr_api.g_varchar2) or
261: nvl(per_job_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 258: nvl(p_rec.attribute7, hr_api.g_varchar2) or

254: nvl(p_rec.attribute5, hr_api.g_varchar2) or
255: nvl(per_job_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
256: nvl(p_rec.attribute6, hr_api.g_varchar2) or
257: nvl(per_job_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
258: nvl(p_rec.attribute7, hr_api.g_varchar2) or
259: nvl(per_job_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
260: nvl(p_rec.attribute8, hr_api.g_varchar2) or
261: nvl(per_job_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
262: nvl(p_rec.attribute9, hr_api.g_varchar2) or

Line 259: nvl(per_job_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

255: nvl(per_job_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
256: nvl(p_rec.attribute6, hr_api.g_varchar2) or
257: nvl(per_job_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
258: nvl(p_rec.attribute7, hr_api.g_varchar2) or
259: nvl(per_job_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
260: nvl(p_rec.attribute8, hr_api.g_varchar2) or
261: nvl(per_job_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
262: nvl(p_rec.attribute9, hr_api.g_varchar2) or
263: nvl(per_job_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 260: nvl(p_rec.attribute8, hr_api.g_varchar2) or

256: nvl(p_rec.attribute6, hr_api.g_varchar2) or
257: nvl(per_job_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
258: nvl(p_rec.attribute7, hr_api.g_varchar2) or
259: nvl(per_job_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
260: nvl(p_rec.attribute8, hr_api.g_varchar2) or
261: nvl(per_job_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
262: nvl(p_rec.attribute9, hr_api.g_varchar2) or
263: nvl(per_job_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
264: nvl(p_rec.attribute10, hr_api.g_varchar2) or

Line 261: nvl(per_job_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

257: nvl(per_job_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
258: nvl(p_rec.attribute7, hr_api.g_varchar2) or
259: nvl(per_job_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
260: nvl(p_rec.attribute8, hr_api.g_varchar2) or
261: nvl(per_job_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
262: nvl(p_rec.attribute9, hr_api.g_varchar2) or
263: nvl(per_job_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
264: nvl(p_rec.attribute10, hr_api.g_varchar2) or
265: nvl(per_job_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

Line 262: nvl(p_rec.attribute9, hr_api.g_varchar2) or

258: nvl(p_rec.attribute7, hr_api.g_varchar2) or
259: nvl(per_job_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
260: nvl(p_rec.attribute8, hr_api.g_varchar2) or
261: nvl(per_job_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
262: nvl(p_rec.attribute9, hr_api.g_varchar2) or
263: nvl(per_job_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
264: nvl(p_rec.attribute10, hr_api.g_varchar2) or
265: nvl(per_job_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
266: nvl(p_rec.attribute11, hr_api.g_varchar2) or

Line 263: nvl(per_job_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

259: nvl(per_job_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
260: nvl(p_rec.attribute8, hr_api.g_varchar2) or
261: nvl(per_job_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
262: nvl(p_rec.attribute9, hr_api.g_varchar2) or
263: nvl(per_job_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
264: nvl(p_rec.attribute10, hr_api.g_varchar2) or
265: nvl(per_job_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
266: nvl(p_rec.attribute11, hr_api.g_varchar2) or
267: nvl(per_job_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

Line 264: nvl(p_rec.attribute10, hr_api.g_varchar2) or

260: nvl(p_rec.attribute8, hr_api.g_varchar2) or
261: nvl(per_job_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
262: nvl(p_rec.attribute9, hr_api.g_varchar2) or
263: nvl(per_job_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
264: nvl(p_rec.attribute10, hr_api.g_varchar2) or
265: nvl(per_job_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
266: nvl(p_rec.attribute11, hr_api.g_varchar2) or
267: nvl(per_job_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
268: nvl(p_rec.attribute12, hr_api.g_varchar2) or

Line 265: nvl(per_job_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

261: nvl(per_job_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
262: nvl(p_rec.attribute9, hr_api.g_varchar2) or
263: nvl(per_job_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
264: nvl(p_rec.attribute10, hr_api.g_varchar2) or
265: nvl(per_job_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
266: nvl(p_rec.attribute11, hr_api.g_varchar2) or
267: nvl(per_job_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
268: nvl(p_rec.attribute12, hr_api.g_varchar2) or
269: nvl(per_job_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

Line 266: nvl(p_rec.attribute11, hr_api.g_varchar2) or

262: nvl(p_rec.attribute9, hr_api.g_varchar2) or
263: nvl(per_job_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
264: nvl(p_rec.attribute10, hr_api.g_varchar2) or
265: nvl(per_job_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
266: nvl(p_rec.attribute11, hr_api.g_varchar2) or
267: nvl(per_job_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
268: nvl(p_rec.attribute12, hr_api.g_varchar2) or
269: nvl(per_job_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
270: nvl(p_rec.attribute13, hr_api.g_varchar2) or

Line 267: nvl(per_job_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

263: nvl(per_job_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
264: nvl(p_rec.attribute10, hr_api.g_varchar2) or
265: nvl(per_job_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
266: nvl(p_rec.attribute11, hr_api.g_varchar2) or
267: nvl(per_job_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
268: nvl(p_rec.attribute12, hr_api.g_varchar2) or
269: nvl(per_job_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
270: nvl(p_rec.attribute13, hr_api.g_varchar2) or
271: nvl(per_job_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

Line 268: nvl(p_rec.attribute12, hr_api.g_varchar2) or

264: nvl(p_rec.attribute10, hr_api.g_varchar2) or
265: nvl(per_job_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
266: nvl(p_rec.attribute11, hr_api.g_varchar2) or
267: nvl(per_job_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
268: nvl(p_rec.attribute12, hr_api.g_varchar2) or
269: nvl(per_job_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
270: nvl(p_rec.attribute13, hr_api.g_varchar2) or
271: nvl(per_job_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
272: nvl(p_rec.attribute14, hr_api.g_varchar2) or

Line 269: nvl(per_job_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

265: nvl(per_job_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
266: nvl(p_rec.attribute11, hr_api.g_varchar2) or
267: nvl(per_job_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
268: nvl(p_rec.attribute12, hr_api.g_varchar2) or
269: nvl(per_job_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
270: nvl(p_rec.attribute13, hr_api.g_varchar2) or
271: nvl(per_job_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
272: nvl(p_rec.attribute14, hr_api.g_varchar2) or
273: nvl(per_job_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

Line 270: nvl(p_rec.attribute13, hr_api.g_varchar2) or

266: nvl(p_rec.attribute11, hr_api.g_varchar2) or
267: nvl(per_job_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
268: nvl(p_rec.attribute12, hr_api.g_varchar2) or
269: nvl(per_job_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
270: nvl(p_rec.attribute13, hr_api.g_varchar2) or
271: nvl(per_job_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
272: nvl(p_rec.attribute14, hr_api.g_varchar2) or
273: nvl(per_job_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
274: nvl(p_rec.attribute15, hr_api.g_varchar2) or

Line 271: nvl(per_job_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

267: nvl(per_job_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
268: nvl(p_rec.attribute12, hr_api.g_varchar2) or
269: nvl(per_job_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
270: nvl(p_rec.attribute13, hr_api.g_varchar2) or
271: nvl(per_job_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
272: nvl(p_rec.attribute14, hr_api.g_varchar2) or
273: nvl(per_job_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
274: nvl(p_rec.attribute15, hr_api.g_varchar2) or
275: nvl(per_job_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

Line 272: nvl(p_rec.attribute14, hr_api.g_varchar2) or

268: nvl(p_rec.attribute12, hr_api.g_varchar2) or
269: nvl(per_job_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
270: nvl(p_rec.attribute13, hr_api.g_varchar2) or
271: nvl(per_job_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
272: nvl(p_rec.attribute14, hr_api.g_varchar2) or
273: nvl(per_job_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
274: nvl(p_rec.attribute15, hr_api.g_varchar2) or
275: nvl(per_job_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
276: nvl(p_rec.attribute16, hr_api.g_varchar2) or

Line 273: nvl(per_job_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

269: nvl(per_job_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
270: nvl(p_rec.attribute13, hr_api.g_varchar2) or
271: nvl(per_job_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
272: nvl(p_rec.attribute14, hr_api.g_varchar2) or
273: nvl(per_job_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
274: nvl(p_rec.attribute15, hr_api.g_varchar2) or
275: nvl(per_job_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
276: nvl(p_rec.attribute16, hr_api.g_varchar2) or
277: nvl(per_job_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

Line 274: nvl(p_rec.attribute15, hr_api.g_varchar2) or

270: nvl(p_rec.attribute13, hr_api.g_varchar2) or
271: nvl(per_job_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
272: nvl(p_rec.attribute14, hr_api.g_varchar2) or
273: nvl(per_job_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
274: nvl(p_rec.attribute15, hr_api.g_varchar2) or
275: nvl(per_job_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
276: nvl(p_rec.attribute16, hr_api.g_varchar2) or
277: nvl(per_job_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
278: nvl(p_rec.attribute17, hr_api.g_varchar2) or

Line 275: nvl(per_job_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

271: nvl(per_job_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
272: nvl(p_rec.attribute14, hr_api.g_varchar2) or
273: nvl(per_job_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
274: nvl(p_rec.attribute15, hr_api.g_varchar2) or
275: nvl(per_job_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
276: nvl(p_rec.attribute16, hr_api.g_varchar2) or
277: nvl(per_job_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
278: nvl(p_rec.attribute17, hr_api.g_varchar2) or
279: nvl(per_job_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

Line 276: nvl(p_rec.attribute16, hr_api.g_varchar2) or

272: nvl(p_rec.attribute14, hr_api.g_varchar2) or
273: nvl(per_job_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
274: nvl(p_rec.attribute15, hr_api.g_varchar2) or
275: nvl(per_job_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
276: nvl(p_rec.attribute16, hr_api.g_varchar2) or
277: nvl(per_job_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
278: nvl(p_rec.attribute17, hr_api.g_varchar2) or
279: nvl(per_job_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
280: nvl(p_rec.attribute18, hr_api.g_varchar2) or

Line 277: nvl(per_job_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

273: nvl(per_job_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
274: nvl(p_rec.attribute15, hr_api.g_varchar2) or
275: nvl(per_job_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
276: nvl(p_rec.attribute16, hr_api.g_varchar2) or
277: nvl(per_job_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
278: nvl(p_rec.attribute17, hr_api.g_varchar2) or
279: nvl(per_job_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
280: nvl(p_rec.attribute18, hr_api.g_varchar2) or
281: nvl(per_job_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

Line 278: nvl(p_rec.attribute17, hr_api.g_varchar2) or

274: nvl(p_rec.attribute15, hr_api.g_varchar2) or
275: nvl(per_job_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
276: nvl(p_rec.attribute16, hr_api.g_varchar2) or
277: nvl(per_job_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
278: nvl(p_rec.attribute17, hr_api.g_varchar2) or
279: nvl(per_job_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
280: nvl(p_rec.attribute18, hr_api.g_varchar2) or
281: nvl(per_job_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
282: nvl(p_rec.attribute19, hr_api.g_varchar2) or

Line 279: nvl(per_job_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

275: nvl(per_job_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
276: nvl(p_rec.attribute16, hr_api.g_varchar2) or
277: nvl(per_job_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
278: nvl(p_rec.attribute17, hr_api.g_varchar2) or
279: nvl(per_job_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
280: nvl(p_rec.attribute18, hr_api.g_varchar2) or
281: nvl(per_job_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
282: nvl(p_rec.attribute19, hr_api.g_varchar2) or
283: nvl(per_job_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

Line 280: nvl(p_rec.attribute18, hr_api.g_varchar2) or

276: nvl(p_rec.attribute16, hr_api.g_varchar2) or
277: nvl(per_job_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
278: nvl(p_rec.attribute17, hr_api.g_varchar2) or
279: nvl(per_job_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
280: nvl(p_rec.attribute18, hr_api.g_varchar2) or
281: nvl(per_job_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
282: nvl(p_rec.attribute19, hr_api.g_varchar2) or
283: nvl(per_job_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
284: nvl(p_rec.attribute20, hr_api.g_varchar2)))

Line 281: nvl(per_job_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

277: nvl(per_job_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
278: nvl(p_rec.attribute17, hr_api.g_varchar2) or
279: nvl(per_job_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
280: nvl(p_rec.attribute18, hr_api.g_varchar2) or
281: nvl(per_job_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
282: nvl(p_rec.attribute19, hr_api.g_varchar2) or
283: nvl(per_job_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
284: nvl(p_rec.attribute20, hr_api.g_varchar2)))
285: or

Line 282: nvl(p_rec.attribute19, hr_api.g_varchar2) or

278: nvl(p_rec.attribute17, hr_api.g_varchar2) or
279: nvl(per_job_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
280: nvl(p_rec.attribute18, hr_api.g_varchar2) or
281: nvl(per_job_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
282: nvl(p_rec.attribute19, hr_api.g_varchar2) or
283: nvl(per_job_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
284: nvl(p_rec.attribute20, hr_api.g_varchar2)))
285: or
286: (p_rec.job_id is null) then

Line 283: nvl(per_job_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

279: nvl(per_job_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
280: nvl(p_rec.attribute18, hr_api.g_varchar2) or
281: nvl(per_job_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
282: nvl(p_rec.attribute19, hr_api.g_varchar2) or
283: nvl(per_job_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
284: nvl(p_rec.attribute20, hr_api.g_varchar2)))
285: or
286: (p_rec.job_id is null) then
287: --

Line 284: nvl(p_rec.attribute20, hr_api.g_varchar2)))

280: nvl(p_rec.attribute18, hr_api.g_varchar2) or
281: nvl(per_job_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
282: nvl(p_rec.attribute19, hr_api.g_varchar2) or
283: nvl(per_job_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
284: nvl(p_rec.attribute20, hr_api.g_varchar2)))
285: or
286: (p_rec.job_id is null) then
287: --
288: -- Only execute the validation if absolutely necessary:

Line 379: nvl(per_job_shd.g_old_rec.job_information_category, hr_api.g_varchar2) <>

375: begin
376: hr_utility.set_location('Entering:'||l_proc, 10);
377: --
378: if ((p_rec.job_id is not null) and (
379: nvl(per_job_shd.g_old_rec.job_information_category, hr_api.g_varchar2) <>
380: nvl(p_rec.job_information_category, hr_api.g_varchar2) or
381: nvl(per_job_shd.g_old_rec.job_information1, hr_api.g_varchar2) <>
382: nvl(p_rec.job_information1, hr_api.g_varchar2) or
383: nvl(per_job_shd.g_old_rec.job_information2, hr_api.g_varchar2) <>

Line 380: nvl(p_rec.job_information_category, hr_api.g_varchar2) or

376: hr_utility.set_location('Entering:'||l_proc, 10);
377: --
378: if ((p_rec.job_id is not null) and (
379: nvl(per_job_shd.g_old_rec.job_information_category, hr_api.g_varchar2) <>
380: nvl(p_rec.job_information_category, hr_api.g_varchar2) or
381: nvl(per_job_shd.g_old_rec.job_information1, hr_api.g_varchar2) <>
382: nvl(p_rec.job_information1, hr_api.g_varchar2) or
383: nvl(per_job_shd.g_old_rec.job_information2, hr_api.g_varchar2) <>
384: nvl(p_rec.job_information2, hr_api.g_varchar2) or

Line 381: nvl(per_job_shd.g_old_rec.job_information1, hr_api.g_varchar2) <>

377: --
378: if ((p_rec.job_id is not null) and (
379: nvl(per_job_shd.g_old_rec.job_information_category, hr_api.g_varchar2) <>
380: nvl(p_rec.job_information_category, hr_api.g_varchar2) or
381: nvl(per_job_shd.g_old_rec.job_information1, hr_api.g_varchar2) <>
382: nvl(p_rec.job_information1, hr_api.g_varchar2) or
383: nvl(per_job_shd.g_old_rec.job_information2, hr_api.g_varchar2) <>
384: nvl(p_rec.job_information2, hr_api.g_varchar2) or
385: nvl(per_job_shd.g_old_rec.job_information3, hr_api.g_varchar2) <>

Line 382: nvl(p_rec.job_information1, hr_api.g_varchar2) or

378: if ((p_rec.job_id is not null) and (
379: nvl(per_job_shd.g_old_rec.job_information_category, hr_api.g_varchar2) <>
380: nvl(p_rec.job_information_category, hr_api.g_varchar2) or
381: nvl(per_job_shd.g_old_rec.job_information1, hr_api.g_varchar2) <>
382: nvl(p_rec.job_information1, hr_api.g_varchar2) or
383: nvl(per_job_shd.g_old_rec.job_information2, hr_api.g_varchar2) <>
384: nvl(p_rec.job_information2, hr_api.g_varchar2) or
385: nvl(per_job_shd.g_old_rec.job_information3, hr_api.g_varchar2) <>
386: nvl(p_rec.job_information3, hr_api.g_varchar2) or

Line 383: nvl(per_job_shd.g_old_rec.job_information2, hr_api.g_varchar2) <>

379: nvl(per_job_shd.g_old_rec.job_information_category, hr_api.g_varchar2) <>
380: nvl(p_rec.job_information_category, hr_api.g_varchar2) or
381: nvl(per_job_shd.g_old_rec.job_information1, hr_api.g_varchar2) <>
382: nvl(p_rec.job_information1, hr_api.g_varchar2) or
383: nvl(per_job_shd.g_old_rec.job_information2, hr_api.g_varchar2) <>
384: nvl(p_rec.job_information2, hr_api.g_varchar2) or
385: nvl(per_job_shd.g_old_rec.job_information3, hr_api.g_varchar2) <>
386: nvl(p_rec.job_information3, hr_api.g_varchar2) or
387: nvl(per_job_shd.g_old_rec.job_information4, hr_api.g_varchar2) <>

Line 384: nvl(p_rec.job_information2, hr_api.g_varchar2) or

380: nvl(p_rec.job_information_category, hr_api.g_varchar2) or
381: nvl(per_job_shd.g_old_rec.job_information1, hr_api.g_varchar2) <>
382: nvl(p_rec.job_information1, hr_api.g_varchar2) or
383: nvl(per_job_shd.g_old_rec.job_information2, hr_api.g_varchar2) <>
384: nvl(p_rec.job_information2, hr_api.g_varchar2) or
385: nvl(per_job_shd.g_old_rec.job_information3, hr_api.g_varchar2) <>
386: nvl(p_rec.job_information3, hr_api.g_varchar2) or
387: nvl(per_job_shd.g_old_rec.job_information4, hr_api.g_varchar2) <>
388: nvl(p_rec.job_information4, hr_api.g_varchar2) or

Line 385: nvl(per_job_shd.g_old_rec.job_information3, hr_api.g_varchar2) <>

381: nvl(per_job_shd.g_old_rec.job_information1, hr_api.g_varchar2) <>
382: nvl(p_rec.job_information1, hr_api.g_varchar2) or
383: nvl(per_job_shd.g_old_rec.job_information2, hr_api.g_varchar2) <>
384: nvl(p_rec.job_information2, hr_api.g_varchar2) or
385: nvl(per_job_shd.g_old_rec.job_information3, hr_api.g_varchar2) <>
386: nvl(p_rec.job_information3, hr_api.g_varchar2) or
387: nvl(per_job_shd.g_old_rec.job_information4, hr_api.g_varchar2) <>
388: nvl(p_rec.job_information4, hr_api.g_varchar2) or
389: nvl(per_job_shd.g_old_rec.job_information5, hr_api.g_varchar2) <>

Line 386: nvl(p_rec.job_information3, hr_api.g_varchar2) or

382: nvl(p_rec.job_information1, hr_api.g_varchar2) or
383: nvl(per_job_shd.g_old_rec.job_information2, hr_api.g_varchar2) <>
384: nvl(p_rec.job_information2, hr_api.g_varchar2) or
385: nvl(per_job_shd.g_old_rec.job_information3, hr_api.g_varchar2) <>
386: nvl(p_rec.job_information3, hr_api.g_varchar2) or
387: nvl(per_job_shd.g_old_rec.job_information4, hr_api.g_varchar2) <>
388: nvl(p_rec.job_information4, hr_api.g_varchar2) or
389: nvl(per_job_shd.g_old_rec.job_information5, hr_api.g_varchar2) <>
390: nvl(p_rec.job_information5, hr_api.g_varchar2) or

Line 387: nvl(per_job_shd.g_old_rec.job_information4, hr_api.g_varchar2) <>

383: nvl(per_job_shd.g_old_rec.job_information2, hr_api.g_varchar2) <>
384: nvl(p_rec.job_information2, hr_api.g_varchar2) or
385: nvl(per_job_shd.g_old_rec.job_information3, hr_api.g_varchar2) <>
386: nvl(p_rec.job_information3, hr_api.g_varchar2) or
387: nvl(per_job_shd.g_old_rec.job_information4, hr_api.g_varchar2) <>
388: nvl(p_rec.job_information4, hr_api.g_varchar2) or
389: nvl(per_job_shd.g_old_rec.job_information5, hr_api.g_varchar2) <>
390: nvl(p_rec.job_information5, hr_api.g_varchar2) or
391: nvl(per_job_shd.g_old_rec.job_information6, hr_api.g_varchar2) <>

Line 388: nvl(p_rec.job_information4, hr_api.g_varchar2) or

384: nvl(p_rec.job_information2, hr_api.g_varchar2) or
385: nvl(per_job_shd.g_old_rec.job_information3, hr_api.g_varchar2) <>
386: nvl(p_rec.job_information3, hr_api.g_varchar2) or
387: nvl(per_job_shd.g_old_rec.job_information4, hr_api.g_varchar2) <>
388: nvl(p_rec.job_information4, hr_api.g_varchar2) or
389: nvl(per_job_shd.g_old_rec.job_information5, hr_api.g_varchar2) <>
390: nvl(p_rec.job_information5, hr_api.g_varchar2) or
391: nvl(per_job_shd.g_old_rec.job_information6, hr_api.g_varchar2) <>
392: nvl(p_rec.job_information6, hr_api.g_varchar2) or

Line 389: nvl(per_job_shd.g_old_rec.job_information5, hr_api.g_varchar2) <>

385: nvl(per_job_shd.g_old_rec.job_information3, hr_api.g_varchar2) <>
386: nvl(p_rec.job_information3, hr_api.g_varchar2) or
387: nvl(per_job_shd.g_old_rec.job_information4, hr_api.g_varchar2) <>
388: nvl(p_rec.job_information4, hr_api.g_varchar2) or
389: nvl(per_job_shd.g_old_rec.job_information5, hr_api.g_varchar2) <>
390: nvl(p_rec.job_information5, hr_api.g_varchar2) or
391: nvl(per_job_shd.g_old_rec.job_information6, hr_api.g_varchar2) <>
392: nvl(p_rec.job_information6, hr_api.g_varchar2) or
393: nvl(per_job_shd.g_old_rec.job_information7, hr_api.g_varchar2) <>

Line 390: nvl(p_rec.job_information5, hr_api.g_varchar2) or

386: nvl(p_rec.job_information3, hr_api.g_varchar2) or
387: nvl(per_job_shd.g_old_rec.job_information4, hr_api.g_varchar2) <>
388: nvl(p_rec.job_information4, hr_api.g_varchar2) or
389: nvl(per_job_shd.g_old_rec.job_information5, hr_api.g_varchar2) <>
390: nvl(p_rec.job_information5, hr_api.g_varchar2) or
391: nvl(per_job_shd.g_old_rec.job_information6, hr_api.g_varchar2) <>
392: nvl(p_rec.job_information6, hr_api.g_varchar2) or
393: nvl(per_job_shd.g_old_rec.job_information7, hr_api.g_varchar2) <>
394: nvl(p_rec.job_information7, hr_api.g_varchar2) or

Line 391: nvl(per_job_shd.g_old_rec.job_information6, hr_api.g_varchar2) <>

387: nvl(per_job_shd.g_old_rec.job_information4, hr_api.g_varchar2) <>
388: nvl(p_rec.job_information4, hr_api.g_varchar2) or
389: nvl(per_job_shd.g_old_rec.job_information5, hr_api.g_varchar2) <>
390: nvl(p_rec.job_information5, hr_api.g_varchar2) or
391: nvl(per_job_shd.g_old_rec.job_information6, hr_api.g_varchar2) <>
392: nvl(p_rec.job_information6, hr_api.g_varchar2) or
393: nvl(per_job_shd.g_old_rec.job_information7, hr_api.g_varchar2) <>
394: nvl(p_rec.job_information7, hr_api.g_varchar2) or
395: nvl(per_job_shd.g_old_rec.job_information8, hr_api.g_varchar2) <>

Line 392: nvl(p_rec.job_information6, hr_api.g_varchar2) or

388: nvl(p_rec.job_information4, hr_api.g_varchar2) or
389: nvl(per_job_shd.g_old_rec.job_information5, hr_api.g_varchar2) <>
390: nvl(p_rec.job_information5, hr_api.g_varchar2) or
391: nvl(per_job_shd.g_old_rec.job_information6, hr_api.g_varchar2) <>
392: nvl(p_rec.job_information6, hr_api.g_varchar2) or
393: nvl(per_job_shd.g_old_rec.job_information7, hr_api.g_varchar2) <>
394: nvl(p_rec.job_information7, hr_api.g_varchar2) or
395: nvl(per_job_shd.g_old_rec.job_information8, hr_api.g_varchar2) <>
396: nvl(p_rec.job_information8, hr_api.g_varchar2) or

Line 393: nvl(per_job_shd.g_old_rec.job_information7, hr_api.g_varchar2) <>

389: nvl(per_job_shd.g_old_rec.job_information5, hr_api.g_varchar2) <>
390: nvl(p_rec.job_information5, hr_api.g_varchar2) or
391: nvl(per_job_shd.g_old_rec.job_information6, hr_api.g_varchar2) <>
392: nvl(p_rec.job_information6, hr_api.g_varchar2) or
393: nvl(per_job_shd.g_old_rec.job_information7, hr_api.g_varchar2) <>
394: nvl(p_rec.job_information7, hr_api.g_varchar2) or
395: nvl(per_job_shd.g_old_rec.job_information8, hr_api.g_varchar2) <>
396: nvl(p_rec.job_information8, hr_api.g_varchar2) or
397: nvl(per_job_shd.g_old_rec.job_information9, hr_api.g_varchar2) <>

Line 394: nvl(p_rec.job_information7, hr_api.g_varchar2) or

390: nvl(p_rec.job_information5, hr_api.g_varchar2) or
391: nvl(per_job_shd.g_old_rec.job_information6, hr_api.g_varchar2) <>
392: nvl(p_rec.job_information6, hr_api.g_varchar2) or
393: nvl(per_job_shd.g_old_rec.job_information7, hr_api.g_varchar2) <>
394: nvl(p_rec.job_information7, hr_api.g_varchar2) or
395: nvl(per_job_shd.g_old_rec.job_information8, hr_api.g_varchar2) <>
396: nvl(p_rec.job_information8, hr_api.g_varchar2) or
397: nvl(per_job_shd.g_old_rec.job_information9, hr_api.g_varchar2) <>
398: nvl(p_rec.job_information9, hr_api.g_varchar2) or

Line 395: nvl(per_job_shd.g_old_rec.job_information8, hr_api.g_varchar2) <>

391: nvl(per_job_shd.g_old_rec.job_information6, hr_api.g_varchar2) <>
392: nvl(p_rec.job_information6, hr_api.g_varchar2) or
393: nvl(per_job_shd.g_old_rec.job_information7, hr_api.g_varchar2) <>
394: nvl(p_rec.job_information7, hr_api.g_varchar2) or
395: nvl(per_job_shd.g_old_rec.job_information8, hr_api.g_varchar2) <>
396: nvl(p_rec.job_information8, hr_api.g_varchar2) or
397: nvl(per_job_shd.g_old_rec.job_information9, hr_api.g_varchar2) <>
398: nvl(p_rec.job_information9, hr_api.g_varchar2) or
399: nvl(per_job_shd.g_old_rec.job_information10, hr_api.g_varchar2) <>

Line 396: nvl(p_rec.job_information8, hr_api.g_varchar2) or

392: nvl(p_rec.job_information6, hr_api.g_varchar2) or
393: nvl(per_job_shd.g_old_rec.job_information7, hr_api.g_varchar2) <>
394: nvl(p_rec.job_information7, hr_api.g_varchar2) or
395: nvl(per_job_shd.g_old_rec.job_information8, hr_api.g_varchar2) <>
396: nvl(p_rec.job_information8, hr_api.g_varchar2) or
397: nvl(per_job_shd.g_old_rec.job_information9, hr_api.g_varchar2) <>
398: nvl(p_rec.job_information9, hr_api.g_varchar2) or
399: nvl(per_job_shd.g_old_rec.job_information10, hr_api.g_varchar2) <>
400: nvl(p_rec.job_information10, hr_api.g_varchar2) or

Line 397: nvl(per_job_shd.g_old_rec.job_information9, hr_api.g_varchar2) <>

393: nvl(per_job_shd.g_old_rec.job_information7, hr_api.g_varchar2) <>
394: nvl(p_rec.job_information7, hr_api.g_varchar2) or
395: nvl(per_job_shd.g_old_rec.job_information8, hr_api.g_varchar2) <>
396: nvl(p_rec.job_information8, hr_api.g_varchar2) or
397: nvl(per_job_shd.g_old_rec.job_information9, hr_api.g_varchar2) <>
398: nvl(p_rec.job_information9, hr_api.g_varchar2) or
399: nvl(per_job_shd.g_old_rec.job_information10, hr_api.g_varchar2) <>
400: nvl(p_rec.job_information10, hr_api.g_varchar2) or
401: nvl(per_job_shd.g_old_rec.job_information11, hr_api.g_varchar2) <>

Line 398: nvl(p_rec.job_information9, hr_api.g_varchar2) or

394: nvl(p_rec.job_information7, hr_api.g_varchar2) or
395: nvl(per_job_shd.g_old_rec.job_information8, hr_api.g_varchar2) <>
396: nvl(p_rec.job_information8, hr_api.g_varchar2) or
397: nvl(per_job_shd.g_old_rec.job_information9, hr_api.g_varchar2) <>
398: nvl(p_rec.job_information9, hr_api.g_varchar2) or
399: nvl(per_job_shd.g_old_rec.job_information10, hr_api.g_varchar2) <>
400: nvl(p_rec.job_information10, hr_api.g_varchar2) or
401: nvl(per_job_shd.g_old_rec.job_information11, hr_api.g_varchar2) <>
402: nvl(p_rec.job_information11, hr_api.g_varchar2) or

Line 399: nvl(per_job_shd.g_old_rec.job_information10, hr_api.g_varchar2) <>

395: nvl(per_job_shd.g_old_rec.job_information8, hr_api.g_varchar2) <>
396: nvl(p_rec.job_information8, hr_api.g_varchar2) or
397: nvl(per_job_shd.g_old_rec.job_information9, hr_api.g_varchar2) <>
398: nvl(p_rec.job_information9, hr_api.g_varchar2) or
399: nvl(per_job_shd.g_old_rec.job_information10, hr_api.g_varchar2) <>
400: nvl(p_rec.job_information10, hr_api.g_varchar2) or
401: nvl(per_job_shd.g_old_rec.job_information11, hr_api.g_varchar2) <>
402: nvl(p_rec.job_information11, hr_api.g_varchar2) or
403: nvl(per_job_shd.g_old_rec.job_information12, hr_api.g_varchar2) <>

Line 400: nvl(p_rec.job_information10, hr_api.g_varchar2) or

396: nvl(p_rec.job_information8, hr_api.g_varchar2) or
397: nvl(per_job_shd.g_old_rec.job_information9, hr_api.g_varchar2) <>
398: nvl(p_rec.job_information9, hr_api.g_varchar2) or
399: nvl(per_job_shd.g_old_rec.job_information10, hr_api.g_varchar2) <>
400: nvl(p_rec.job_information10, hr_api.g_varchar2) or
401: nvl(per_job_shd.g_old_rec.job_information11, hr_api.g_varchar2) <>
402: nvl(p_rec.job_information11, hr_api.g_varchar2) or
403: nvl(per_job_shd.g_old_rec.job_information12, hr_api.g_varchar2) <>
404: nvl(p_rec.job_information12, hr_api.g_varchar2) or

Line 401: nvl(per_job_shd.g_old_rec.job_information11, hr_api.g_varchar2) <>

397: nvl(per_job_shd.g_old_rec.job_information9, hr_api.g_varchar2) <>
398: nvl(p_rec.job_information9, hr_api.g_varchar2) or
399: nvl(per_job_shd.g_old_rec.job_information10, hr_api.g_varchar2) <>
400: nvl(p_rec.job_information10, hr_api.g_varchar2) or
401: nvl(per_job_shd.g_old_rec.job_information11, hr_api.g_varchar2) <>
402: nvl(p_rec.job_information11, hr_api.g_varchar2) or
403: nvl(per_job_shd.g_old_rec.job_information12, hr_api.g_varchar2) <>
404: nvl(p_rec.job_information12, hr_api.g_varchar2) or
405: nvl(per_job_shd.g_old_rec.job_information13, hr_api.g_varchar2) <>

Line 402: nvl(p_rec.job_information11, hr_api.g_varchar2) or

398: nvl(p_rec.job_information9, hr_api.g_varchar2) or
399: nvl(per_job_shd.g_old_rec.job_information10, hr_api.g_varchar2) <>
400: nvl(p_rec.job_information10, hr_api.g_varchar2) or
401: nvl(per_job_shd.g_old_rec.job_information11, hr_api.g_varchar2) <>
402: nvl(p_rec.job_information11, hr_api.g_varchar2) or
403: nvl(per_job_shd.g_old_rec.job_information12, hr_api.g_varchar2) <>
404: nvl(p_rec.job_information12, hr_api.g_varchar2) or
405: nvl(per_job_shd.g_old_rec.job_information13, hr_api.g_varchar2) <>
406: nvl(p_rec.job_information13, hr_api.g_varchar2) or

Line 403: nvl(per_job_shd.g_old_rec.job_information12, hr_api.g_varchar2) <>

399: nvl(per_job_shd.g_old_rec.job_information10, hr_api.g_varchar2) <>
400: nvl(p_rec.job_information10, hr_api.g_varchar2) or
401: nvl(per_job_shd.g_old_rec.job_information11, hr_api.g_varchar2) <>
402: nvl(p_rec.job_information11, hr_api.g_varchar2) or
403: nvl(per_job_shd.g_old_rec.job_information12, hr_api.g_varchar2) <>
404: nvl(p_rec.job_information12, hr_api.g_varchar2) or
405: nvl(per_job_shd.g_old_rec.job_information13, hr_api.g_varchar2) <>
406: nvl(p_rec.job_information13, hr_api.g_varchar2) or
407: nvl(per_job_shd.g_old_rec.job_information14, hr_api.g_varchar2) <>

Line 404: nvl(p_rec.job_information12, hr_api.g_varchar2) or

400: nvl(p_rec.job_information10, hr_api.g_varchar2) or
401: nvl(per_job_shd.g_old_rec.job_information11, hr_api.g_varchar2) <>
402: nvl(p_rec.job_information11, hr_api.g_varchar2) or
403: nvl(per_job_shd.g_old_rec.job_information12, hr_api.g_varchar2) <>
404: nvl(p_rec.job_information12, hr_api.g_varchar2) or
405: nvl(per_job_shd.g_old_rec.job_information13, hr_api.g_varchar2) <>
406: nvl(p_rec.job_information13, hr_api.g_varchar2) or
407: nvl(per_job_shd.g_old_rec.job_information14, hr_api.g_varchar2) <>
408: nvl(p_rec.job_information14, hr_api.g_varchar2) or

Line 405: nvl(per_job_shd.g_old_rec.job_information13, hr_api.g_varchar2) <>

401: nvl(per_job_shd.g_old_rec.job_information11, hr_api.g_varchar2) <>
402: nvl(p_rec.job_information11, hr_api.g_varchar2) or
403: nvl(per_job_shd.g_old_rec.job_information12, hr_api.g_varchar2) <>
404: nvl(p_rec.job_information12, hr_api.g_varchar2) or
405: nvl(per_job_shd.g_old_rec.job_information13, hr_api.g_varchar2) <>
406: nvl(p_rec.job_information13, hr_api.g_varchar2) or
407: nvl(per_job_shd.g_old_rec.job_information14, hr_api.g_varchar2) <>
408: nvl(p_rec.job_information14, hr_api.g_varchar2) or
409: nvl(per_job_shd.g_old_rec.job_information15, hr_api.g_varchar2) <>

Line 406: nvl(p_rec.job_information13, hr_api.g_varchar2) or

402: nvl(p_rec.job_information11, hr_api.g_varchar2) or
403: nvl(per_job_shd.g_old_rec.job_information12, hr_api.g_varchar2) <>
404: nvl(p_rec.job_information12, hr_api.g_varchar2) or
405: nvl(per_job_shd.g_old_rec.job_information13, hr_api.g_varchar2) <>
406: nvl(p_rec.job_information13, hr_api.g_varchar2) or
407: nvl(per_job_shd.g_old_rec.job_information14, hr_api.g_varchar2) <>
408: nvl(p_rec.job_information14, hr_api.g_varchar2) or
409: nvl(per_job_shd.g_old_rec.job_information15, hr_api.g_varchar2) <>
410: nvl(p_rec.job_information15, hr_api.g_varchar2) or

Line 407: nvl(per_job_shd.g_old_rec.job_information14, hr_api.g_varchar2) <>

403: nvl(per_job_shd.g_old_rec.job_information12, hr_api.g_varchar2) <>
404: nvl(p_rec.job_information12, hr_api.g_varchar2) or
405: nvl(per_job_shd.g_old_rec.job_information13, hr_api.g_varchar2) <>
406: nvl(p_rec.job_information13, hr_api.g_varchar2) or
407: nvl(per_job_shd.g_old_rec.job_information14, hr_api.g_varchar2) <>
408: nvl(p_rec.job_information14, hr_api.g_varchar2) or
409: nvl(per_job_shd.g_old_rec.job_information15, hr_api.g_varchar2) <>
410: nvl(p_rec.job_information15, hr_api.g_varchar2) or
411: nvl(per_job_shd.g_old_rec.job_information16, hr_api.g_varchar2) <>

Line 408: nvl(p_rec.job_information14, hr_api.g_varchar2) or

404: nvl(p_rec.job_information12, hr_api.g_varchar2) or
405: nvl(per_job_shd.g_old_rec.job_information13, hr_api.g_varchar2) <>
406: nvl(p_rec.job_information13, hr_api.g_varchar2) or
407: nvl(per_job_shd.g_old_rec.job_information14, hr_api.g_varchar2) <>
408: nvl(p_rec.job_information14, hr_api.g_varchar2) or
409: nvl(per_job_shd.g_old_rec.job_information15, hr_api.g_varchar2) <>
410: nvl(p_rec.job_information15, hr_api.g_varchar2) or
411: nvl(per_job_shd.g_old_rec.job_information16, hr_api.g_varchar2) <>
412: nvl(p_rec.job_information16, hr_api.g_varchar2) or

Line 409: nvl(per_job_shd.g_old_rec.job_information15, hr_api.g_varchar2) <>

405: nvl(per_job_shd.g_old_rec.job_information13, hr_api.g_varchar2) <>
406: nvl(p_rec.job_information13, hr_api.g_varchar2) or
407: nvl(per_job_shd.g_old_rec.job_information14, hr_api.g_varchar2) <>
408: nvl(p_rec.job_information14, hr_api.g_varchar2) or
409: nvl(per_job_shd.g_old_rec.job_information15, hr_api.g_varchar2) <>
410: nvl(p_rec.job_information15, hr_api.g_varchar2) or
411: nvl(per_job_shd.g_old_rec.job_information16, hr_api.g_varchar2) <>
412: nvl(p_rec.job_information16, hr_api.g_varchar2) or
413: nvl(per_job_shd.g_old_rec.job_information17, hr_api.g_varchar2) <>

Line 410: nvl(p_rec.job_information15, hr_api.g_varchar2) or

406: nvl(p_rec.job_information13, hr_api.g_varchar2) or
407: nvl(per_job_shd.g_old_rec.job_information14, hr_api.g_varchar2) <>
408: nvl(p_rec.job_information14, hr_api.g_varchar2) or
409: nvl(per_job_shd.g_old_rec.job_information15, hr_api.g_varchar2) <>
410: nvl(p_rec.job_information15, hr_api.g_varchar2) or
411: nvl(per_job_shd.g_old_rec.job_information16, hr_api.g_varchar2) <>
412: nvl(p_rec.job_information16, hr_api.g_varchar2) or
413: nvl(per_job_shd.g_old_rec.job_information17, hr_api.g_varchar2) <>
414: nvl(p_rec.job_information17, hr_api.g_varchar2) or

Line 411: nvl(per_job_shd.g_old_rec.job_information16, hr_api.g_varchar2) <>

407: nvl(per_job_shd.g_old_rec.job_information14, hr_api.g_varchar2) <>
408: nvl(p_rec.job_information14, hr_api.g_varchar2) or
409: nvl(per_job_shd.g_old_rec.job_information15, hr_api.g_varchar2) <>
410: nvl(p_rec.job_information15, hr_api.g_varchar2) or
411: nvl(per_job_shd.g_old_rec.job_information16, hr_api.g_varchar2) <>
412: nvl(p_rec.job_information16, hr_api.g_varchar2) or
413: nvl(per_job_shd.g_old_rec.job_information17, hr_api.g_varchar2) <>
414: nvl(p_rec.job_information17, hr_api.g_varchar2) or
415: nvl(per_job_shd.g_old_rec.job_information18, hr_api.g_varchar2) <>

Line 412: nvl(p_rec.job_information16, hr_api.g_varchar2) or

408: nvl(p_rec.job_information14, hr_api.g_varchar2) or
409: nvl(per_job_shd.g_old_rec.job_information15, hr_api.g_varchar2) <>
410: nvl(p_rec.job_information15, hr_api.g_varchar2) or
411: nvl(per_job_shd.g_old_rec.job_information16, hr_api.g_varchar2) <>
412: nvl(p_rec.job_information16, hr_api.g_varchar2) or
413: nvl(per_job_shd.g_old_rec.job_information17, hr_api.g_varchar2) <>
414: nvl(p_rec.job_information17, hr_api.g_varchar2) or
415: nvl(per_job_shd.g_old_rec.job_information18, hr_api.g_varchar2) <>
416: nvl(p_rec.job_information18, hr_api.g_varchar2) or

Line 413: nvl(per_job_shd.g_old_rec.job_information17, hr_api.g_varchar2) <>

409: nvl(per_job_shd.g_old_rec.job_information15, hr_api.g_varchar2) <>
410: nvl(p_rec.job_information15, hr_api.g_varchar2) or
411: nvl(per_job_shd.g_old_rec.job_information16, hr_api.g_varchar2) <>
412: nvl(p_rec.job_information16, hr_api.g_varchar2) or
413: nvl(per_job_shd.g_old_rec.job_information17, hr_api.g_varchar2) <>
414: nvl(p_rec.job_information17, hr_api.g_varchar2) or
415: nvl(per_job_shd.g_old_rec.job_information18, hr_api.g_varchar2) <>
416: nvl(p_rec.job_information18, hr_api.g_varchar2) or
417: nvl(per_job_shd.g_old_rec.job_information19, hr_api.g_varchar2) <>

Line 414: nvl(p_rec.job_information17, hr_api.g_varchar2) or

410: nvl(p_rec.job_information15, hr_api.g_varchar2) or
411: nvl(per_job_shd.g_old_rec.job_information16, hr_api.g_varchar2) <>
412: nvl(p_rec.job_information16, hr_api.g_varchar2) or
413: nvl(per_job_shd.g_old_rec.job_information17, hr_api.g_varchar2) <>
414: nvl(p_rec.job_information17, hr_api.g_varchar2) or
415: nvl(per_job_shd.g_old_rec.job_information18, hr_api.g_varchar2) <>
416: nvl(p_rec.job_information18, hr_api.g_varchar2) or
417: nvl(per_job_shd.g_old_rec.job_information19, hr_api.g_varchar2) <>
418: nvl(p_rec.job_information19, hr_api.g_varchar2) or

Line 415: nvl(per_job_shd.g_old_rec.job_information18, hr_api.g_varchar2) <>

411: nvl(per_job_shd.g_old_rec.job_information16, hr_api.g_varchar2) <>
412: nvl(p_rec.job_information16, hr_api.g_varchar2) or
413: nvl(per_job_shd.g_old_rec.job_information17, hr_api.g_varchar2) <>
414: nvl(p_rec.job_information17, hr_api.g_varchar2) or
415: nvl(per_job_shd.g_old_rec.job_information18, hr_api.g_varchar2) <>
416: nvl(p_rec.job_information18, hr_api.g_varchar2) or
417: nvl(per_job_shd.g_old_rec.job_information19, hr_api.g_varchar2) <>
418: nvl(p_rec.job_information19, hr_api.g_varchar2) or
419: nvl(per_job_shd.g_old_rec.job_information20, hr_api.g_varchar2) <>

Line 416: nvl(p_rec.job_information18, hr_api.g_varchar2) or

412: nvl(p_rec.job_information16, hr_api.g_varchar2) or
413: nvl(per_job_shd.g_old_rec.job_information17, hr_api.g_varchar2) <>
414: nvl(p_rec.job_information17, hr_api.g_varchar2) or
415: nvl(per_job_shd.g_old_rec.job_information18, hr_api.g_varchar2) <>
416: nvl(p_rec.job_information18, hr_api.g_varchar2) or
417: nvl(per_job_shd.g_old_rec.job_information19, hr_api.g_varchar2) <>
418: nvl(p_rec.job_information19, hr_api.g_varchar2) or
419: nvl(per_job_shd.g_old_rec.job_information20, hr_api.g_varchar2) <>
420: nvl(p_rec.job_information20, hr_api.g_varchar2)))

Line 417: nvl(per_job_shd.g_old_rec.job_information19, hr_api.g_varchar2) <>

413: nvl(per_job_shd.g_old_rec.job_information17, hr_api.g_varchar2) <>
414: nvl(p_rec.job_information17, hr_api.g_varchar2) or
415: nvl(per_job_shd.g_old_rec.job_information18, hr_api.g_varchar2) <>
416: nvl(p_rec.job_information18, hr_api.g_varchar2) or
417: nvl(per_job_shd.g_old_rec.job_information19, hr_api.g_varchar2) <>
418: nvl(p_rec.job_information19, hr_api.g_varchar2) or
419: nvl(per_job_shd.g_old_rec.job_information20, hr_api.g_varchar2) <>
420: nvl(p_rec.job_information20, hr_api.g_varchar2)))
421: or

Line 418: nvl(p_rec.job_information19, hr_api.g_varchar2) or

414: nvl(p_rec.job_information17, hr_api.g_varchar2) or
415: nvl(per_job_shd.g_old_rec.job_information18, hr_api.g_varchar2) <>
416: nvl(p_rec.job_information18, hr_api.g_varchar2) or
417: nvl(per_job_shd.g_old_rec.job_information19, hr_api.g_varchar2) <>
418: nvl(p_rec.job_information19, hr_api.g_varchar2) or
419: nvl(per_job_shd.g_old_rec.job_information20, hr_api.g_varchar2) <>
420: nvl(p_rec.job_information20, hr_api.g_varchar2)))
421: or
422: (p_rec.job_id is null) then

Line 419: nvl(per_job_shd.g_old_rec.job_information20, hr_api.g_varchar2) <>

415: nvl(per_job_shd.g_old_rec.job_information18, hr_api.g_varchar2) <>
416: nvl(p_rec.job_information18, hr_api.g_varchar2) or
417: nvl(per_job_shd.g_old_rec.job_information19, hr_api.g_varchar2) <>
418: nvl(p_rec.job_information19, hr_api.g_varchar2) or
419: nvl(per_job_shd.g_old_rec.job_information20, hr_api.g_varchar2) <>
420: nvl(p_rec.job_information20, hr_api.g_varchar2)))
421: or
422: (p_rec.job_id is null) then
423: --

Line 420: nvl(p_rec.job_information20, hr_api.g_varchar2)))

416: nvl(p_rec.job_information18, hr_api.g_varchar2) or
417: nvl(per_job_shd.g_old_rec.job_information19, hr_api.g_varchar2) <>
418: nvl(p_rec.job_information19, hr_api.g_varchar2) or
419: nvl(per_job_shd.g_old_rec.job_information20, hr_api.g_varchar2) <>
420: nvl(p_rec.job_information20, hr_api.g_varchar2)))
421: or
422: (p_rec.job_id is null) then
423: --
424: -- Only execute the validation if absolutely necessary:

Line 494: hr_api.validate_bus_grp_id(p_rec.business_group_id);

490: -- Call all supporting business operations
491: --
492: -- Validate Business Group
493: --
494: hr_api.validate_bus_grp_id(p_rec.business_group_id);
495: --
496: hr_utility.set_location(l_proc, 6);
497: --
498: -- Validate date from and date_to

Line 583: hr_api.validate_bus_grp_id(p_rec.business_group_id);

579: -- Call all supporting business operations
580: --
581: -- Validate Business Group
582: --
583: hr_api.validate_bus_grp_id(p_rec.business_group_id);
584: --
585: hr_utility.set_location(l_proc, 10);
586: --
587: -- chk_non_updateable_args

Line 715: hr_api.mandatory_arg_error(p_api_name => l_proc,

711: hr_utility.set_location('Entering:'|| l_proc, 10);
712: --
713: -- Ensure that all the mandatory parameter are not null
714: --
715: hr_api.mandatory_arg_error(p_api_name => l_proc,
716: p_argument => 'job_id',
717: p_argument_value => p_job_id);
718: --
719: if nvl(g_job_id, hr_api.g_number) = p_job_id then

Line 719: if nvl(g_job_id, hr_api.g_number) = p_job_id then

715: hr_api.mandatory_arg_error(p_api_name => l_proc,
716: p_argument => 'job_id',
717: p_argument_value => p_job_id);
718: --
719: if nvl(g_job_id, hr_api.g_number) = p_job_id then
720: --
721: -- The legislation code has already been found with a previous
722: -- call to this function. Just return the value in the global
723: -- variable.

Line 779: IF (nvl(p_rec.business_group_id,hr_api.g_number) <>

775: fnd_message.set_token('STEP ', '5');
776: fnd_message.raise_error;
777: END IF;
778: --
779: IF (nvl(p_rec.business_group_id,hr_api.g_number) <>
780: nvl(per_job_shd.g_old_rec.business_group_id,hr_api.g_number)
781: ) THEN
782: l_argument := 'business_group_id';
783: RAISE l_error;

Line 780: nvl(per_job_shd.g_old_rec.business_group_id,hr_api.g_number)

776: fnd_message.raise_error;
777: END IF;
778: --
779: IF (nvl(p_rec.business_group_id,hr_api.g_number) <>
780: nvl(per_job_shd.g_old_rec.business_group_id,hr_api.g_number)
781: ) THEN
782: l_argument := 'business_group_id';
783: RAISE l_error;
784: END IF;

Line 786: IF (nvl(p_rec.job_group_id,hr_api.g_number) <>

782: l_argument := 'business_group_id';
783: RAISE l_error;
784: END IF;
785:
786: IF (nvl(p_rec.job_group_id,hr_api.g_number) <>
787: nvl(per_job_shd.g_old_rec.job_group_id,hr_api.g_number)
788: ) THEN
789: l_argument := 'job_group_id';
790: RAISE l_error;

Line 787: nvl(per_job_shd.g_old_rec.job_group_id,hr_api.g_number)

783: RAISE l_error;
784: END IF;
785:
786: IF (nvl(p_rec.job_group_id,hr_api.g_number) <>
787: nvl(per_job_shd.g_old_rec.job_group_id,hr_api.g_number)
788: ) THEN
789: l_argument := 'job_group_id';
790: RAISE l_error;
791: END IF;

Line 793: IF (nvl(p_rec.job_id,hr_api.g_number) <>

789: l_argument := 'job_group_id';
790: RAISE l_error;
791: END IF;
792:
793: IF (nvl(p_rec.job_id,hr_api.g_number) <>
794: nvl(per_job_shd.g_old_rec.job_id,hr_api.g_number)
795: ) THEN
796: l_argument := 'job_id';
797: RAISE l_error;

Line 794: nvl(per_job_shd.g_old_rec.job_id,hr_api.g_number)

790: RAISE l_error;
791: END IF;
792:
793: IF (nvl(p_rec.job_id,hr_api.g_number) <>
794: nvl(per_job_shd.g_old_rec.job_id,hr_api.g_number)
795: ) THEN
796: l_argument := 'job_id';
797: RAISE l_error;
798: END IF;

Line 802: hr_api.argument_changed_error

798: END IF;
799:
800: EXCEPTION
801: WHEN l_error THEN
802: hr_api.argument_changed_error
803: (p_api_name => l_proc
804: ,p_argument => l_argument);
805: WHEN OTHERS THEN
806: RAISE;

Line 827: (nvl(per_job_shd.g_old_rec.emp_rights_flag,hr_api.g_varchar2) <>

823: (p_job_id => p_rec.job_id
824: ,p_object_version_number => p_rec.object_version_number);
825:
826: if (l_api_updating and
827: (nvl(per_job_shd.g_old_rec.emp_rights_flag,hr_api.g_varchar2) <>
828: nvl(p_emp_rights_flag,hr_api.g_varchar2)) or NOT l_api_updating) then
829:
830: if (p_emp_rights_flag <> 'Y' and p_emp_rights_flag <> 'N' and
831: p_emp_rights_flag is not null) then

Line 828: nvl(p_emp_rights_flag,hr_api.g_varchar2)) or NOT l_api_updating) then

824: ,p_object_version_number => p_rec.object_version_number);
825:
826: if (l_api_updating and
827: (nvl(per_job_shd.g_old_rec.emp_rights_flag,hr_api.g_varchar2) <>
828: nvl(p_emp_rights_flag,hr_api.g_varchar2)) or NOT l_api_updating) then
829:
830: if (p_emp_rights_flag <> 'Y' and p_emp_rights_flag <> 'N' and
831: p_emp_rights_flag is not null) then
832: hr_utility.set_message(801,'HR_289476_EMP_RIGHTS_FLAG');

Line 896: (nvl(per_job_shd.g_old_rec.approval_authority,hr_api.g_number) <>

892: (p_job_id => p_rec.job_id
893: ,p_object_version_number => p_rec.object_version_number);
894:
895: if (l_api_updating and
896: (nvl(per_job_shd.g_old_rec.approval_authority,hr_api.g_number) <>
897: nvl(p_approval_authority,hr_api.g_number)) or
898: NOT l_api_updating) then
899:
900: if (l_approval_authority < 0) then

Line 897: nvl(p_approval_authority,hr_api.g_number)) or

893: ,p_object_version_number => p_rec.object_version_number);
894:
895: if (l_api_updating and
896: (nvl(per_job_shd.g_old_rec.approval_authority,hr_api.g_number) <>
897: nvl(p_approval_authority,hr_api.g_number)) or
898: NOT l_api_updating) then
899:
900: if (l_approval_authority < 0) then
901: hr_utility.set_message(801, 'HR_289991_APPROVAL_AUTHORITY');

Line 932: (nvl(per_job_shd.g_old_rec.benchmark_job_id, hr_api.g_number) <>

928:
929: if (l_api_updating and
930: (nvl(per_job_shd.g_old_rec.benchmark_job_flag,'N') <>
931: nvl(p_benchmark_job_flag, 'N')) or
932: (nvl(per_job_shd.g_old_rec.benchmark_job_id, hr_api.g_number) <>
933: nvl(p_benchmark_job_id, hr_api.g_number)) or
934: NOT l_api_updating) then
935:
936: if (p_benchmark_job_flag = 'Y' and p_benchmark_job_id is not null) then

Line 933: nvl(p_benchmark_job_id, hr_api.g_number)) or

929: if (l_api_updating and
930: (nvl(per_job_shd.g_old_rec.benchmark_job_flag,'N') <>
931: nvl(p_benchmark_job_flag, 'N')) or
932: (nvl(per_job_shd.g_old_rec.benchmark_job_id, hr_api.g_number) <>
933: nvl(p_benchmark_job_id, hr_api.g_number)) or
934: NOT l_api_updating) then
935:
936: if (p_benchmark_job_flag = 'Y' and p_benchmark_job_id is not null) then
937: hr_utility.set_message(801, 'HR_289474_BENCHMARK_JOB_FLAG');

Line 965: and p_benchmark_job_id <> nvl(p_job_id,hr_api.g_number)

961: -- Changed where clause to filter based on benchmark_job_id
962: -- and relaxed check on business group.
963: --
964: where job_id = p_benchmark_job_id
965: and p_benchmark_job_id <> nvl(p_job_id,hr_api.g_number)
966: and benchmark_job_flag = 'Y';
967:
968: l_benchmark_job_id per_jobs.benchmark_job_id%TYPE;
969: l_proc varchar2(72) := g_package||'chk_benchmark_job_id';

Line 981: (nvl(per_job_shd.g_old_rec.benchmark_job_id,hr_api.g_number) <>

977: (p_job_id => p_rec.job_id
978: ,p_object_version_number => p_rec.object_version_number);
979:
980: if (l_api_updating and
981: (nvl(per_job_shd.g_old_rec.benchmark_job_id,hr_api.g_number) <>
982: nvl(p_benchmark_job_id,hr_api.g_number)) or NOT l_api_updating) then
983:
984: if (p_benchmark_job_id is not null) then
985:

Line 982: nvl(p_benchmark_job_id,hr_api.g_number)) or NOT l_api_updating) then

978: ,p_object_version_number => p_rec.object_version_number);
979:
980: if (l_api_updating and
981: (nvl(per_job_shd.g_old_rec.benchmark_job_id,hr_api.g_number) <>
982: nvl(p_benchmark_job_id,hr_api.g_number)) or NOT l_api_updating) then
983:
984: if (p_benchmark_job_id is not null) then
985:
986: open csr_benchmark_job_id;

Line 1435: nvl(p_job_date_from, hr_api.g_sot) and

1431: if p_jobid is not null then
1432: for l_job_evaluation in csr_job_evaluations(
1433: p_job_id => p_jobid) loop
1434: if l_job_evaluation.date_evaluated not between
1435: nvl(p_job_date_from, hr_api.g_sot) and
1436: nvl(p_job_date_to, hr_api.g_eot) then
1437: fnd_message.set_name('PER', 'HR_52603_JOB_JBE_OUT_PERIOD');
1438: hr_utility.raise_error;
1439: end if;

Line 1436: nvl(p_job_date_to, hr_api.g_eot) then

1432: for l_job_evaluation in csr_job_evaluations(
1433: p_job_id => p_jobid) loop
1434: if l_job_evaluation.date_evaluated not between
1435: nvl(p_job_date_from, hr_api.g_sot) and
1436: nvl(p_job_date_to, hr_api.g_eot) then
1437: fnd_message.set_name('PER', 'HR_52603_JOB_JBE_OUT_PERIOD');
1438: hr_utility.raise_error;
1439: end if;
1440: end loop;