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