61: fnd_message.set_token('STEP ', '5');
62: fnd_message.raise_error;
63: END IF;
64: --
65: IF nvl(p_rec.start_Date, hr_api.g_date) <>
66: nvl(per_cag_shd.g_old_rec.start_date,hr_api.g_date) THEN
67: --
68: l_argument := 'start_date';
69: RAISE l_error;
62: fnd_message.raise_error;
63: END IF;
64: --
65: IF nvl(p_rec.start_Date, hr_api.g_date) <>
66: nvl(per_cag_shd.g_old_rec.start_date,hr_api.g_date) THEN
67: --
68: l_argument := 'start_date';
69: RAISE l_error;
70: --
71: END IF;
72:
73: EXCEPTION
74: WHEN l_error THEN
75: hr_api.argument_changed_error
76: (p_api_name => l_proc
77: ,p_argument => l_argument);
78: WHEN OTHERS THEN
79: RAISE;
306: begin
307: hr_utility.set_location('Entering:'||l_proc, 10);
308: --
309: if ((p_rec.collective_agreement_id is NULL) and (
310: nvl(per_cag_shd.g_old_rec.attribute_category, hr_api.g_varchar2)<>
311: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
312: nvl(per_cag_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
313: nvl(p_rec.attribute1, hr_api.g_varchar2) or
314: nvl(per_cag_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
307: hr_utility.set_location('Entering:'||l_proc, 10);
308: --
309: if ((p_rec.collective_agreement_id is NULL) and (
310: nvl(per_cag_shd.g_old_rec.attribute_category, hr_api.g_varchar2)<>
311: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
312: nvl(per_cag_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
313: nvl(p_rec.attribute1, hr_api.g_varchar2) or
314: nvl(per_cag_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
315: nvl(p_rec.attribute2, hr_api.g_varchar2) or
308: --
309: if ((p_rec.collective_agreement_id is NULL) and (
310: nvl(per_cag_shd.g_old_rec.attribute_category, hr_api.g_varchar2)<>
311: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
312: nvl(per_cag_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
313: nvl(p_rec.attribute1, hr_api.g_varchar2) or
314: nvl(per_cag_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
315: nvl(p_rec.attribute2, hr_api.g_varchar2) or
316: nvl(per_cag_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
309: if ((p_rec.collective_agreement_id is NULL) and (
310: nvl(per_cag_shd.g_old_rec.attribute_category, hr_api.g_varchar2)<>
311: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
312: nvl(per_cag_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
313: nvl(p_rec.attribute1, hr_api.g_varchar2) or
314: nvl(per_cag_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
315: nvl(p_rec.attribute2, hr_api.g_varchar2) or
316: nvl(per_cag_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
317: nvl(p_rec.attribute3, hr_api.g_varchar2) or
310: nvl(per_cag_shd.g_old_rec.attribute_category, hr_api.g_varchar2)<>
311: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
312: nvl(per_cag_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
313: nvl(p_rec.attribute1, hr_api.g_varchar2) or
314: nvl(per_cag_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
315: nvl(p_rec.attribute2, hr_api.g_varchar2) or
316: nvl(per_cag_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
317: nvl(p_rec.attribute3, hr_api.g_varchar2) or
318: nvl(per_cag_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
311: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
312: nvl(per_cag_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
313: nvl(p_rec.attribute1, hr_api.g_varchar2) or
314: nvl(per_cag_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
315: nvl(p_rec.attribute2, hr_api.g_varchar2) or
316: nvl(per_cag_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
317: nvl(p_rec.attribute3, hr_api.g_varchar2) or
318: nvl(per_cag_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
319: nvl(p_rec.attribute4, hr_api.g_varchar2) or
312: nvl(per_cag_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
313: nvl(p_rec.attribute1, hr_api.g_varchar2) or
314: nvl(per_cag_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
315: nvl(p_rec.attribute2, hr_api.g_varchar2) or
316: nvl(per_cag_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
317: nvl(p_rec.attribute3, hr_api.g_varchar2) or
318: nvl(per_cag_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
319: nvl(p_rec.attribute4, hr_api.g_varchar2) or
320: nvl(per_cag_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
313: nvl(p_rec.attribute1, hr_api.g_varchar2) or
314: nvl(per_cag_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
315: nvl(p_rec.attribute2, hr_api.g_varchar2) or
316: nvl(per_cag_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
317: nvl(p_rec.attribute3, hr_api.g_varchar2) or
318: nvl(per_cag_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
319: nvl(p_rec.attribute4, hr_api.g_varchar2) or
320: nvl(per_cag_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
321: nvl(p_rec.attribute5, hr_api.g_varchar2) or
314: nvl(per_cag_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
315: nvl(p_rec.attribute2, hr_api.g_varchar2) or
316: nvl(per_cag_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
317: nvl(p_rec.attribute3, hr_api.g_varchar2) or
318: nvl(per_cag_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
319: nvl(p_rec.attribute4, hr_api.g_varchar2) or
320: nvl(per_cag_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
321: nvl(p_rec.attribute5, hr_api.g_varchar2) or
322: nvl(per_cag_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
315: nvl(p_rec.attribute2, hr_api.g_varchar2) or
316: nvl(per_cag_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
317: nvl(p_rec.attribute3, hr_api.g_varchar2) or
318: nvl(per_cag_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
319: nvl(p_rec.attribute4, hr_api.g_varchar2) or
320: nvl(per_cag_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
321: nvl(p_rec.attribute5, hr_api.g_varchar2) or
322: nvl(per_cag_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
323: nvl(p_rec.attribute6, hr_api.g_varchar2) or
316: nvl(per_cag_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
317: nvl(p_rec.attribute3, hr_api.g_varchar2) or
318: nvl(per_cag_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
319: nvl(p_rec.attribute4, hr_api.g_varchar2) or
320: nvl(per_cag_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
321: nvl(p_rec.attribute5, hr_api.g_varchar2) or
322: nvl(per_cag_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
323: nvl(p_rec.attribute6, hr_api.g_varchar2) or
324: nvl(per_cag_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
317: nvl(p_rec.attribute3, hr_api.g_varchar2) or
318: nvl(per_cag_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
319: nvl(p_rec.attribute4, hr_api.g_varchar2) or
320: nvl(per_cag_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
321: nvl(p_rec.attribute5, hr_api.g_varchar2) or
322: nvl(per_cag_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
323: nvl(p_rec.attribute6, hr_api.g_varchar2) or
324: nvl(per_cag_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
325: nvl(p_rec.attribute7, hr_api.g_varchar2) or
318: nvl(per_cag_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
319: nvl(p_rec.attribute4, hr_api.g_varchar2) or
320: nvl(per_cag_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
321: nvl(p_rec.attribute5, hr_api.g_varchar2) or
322: nvl(per_cag_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
323: nvl(p_rec.attribute6, hr_api.g_varchar2) or
324: nvl(per_cag_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
325: nvl(p_rec.attribute7, hr_api.g_varchar2) or
326: nvl(per_cag_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
319: nvl(p_rec.attribute4, hr_api.g_varchar2) or
320: nvl(per_cag_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
321: nvl(p_rec.attribute5, hr_api.g_varchar2) or
322: nvl(per_cag_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
323: nvl(p_rec.attribute6, hr_api.g_varchar2) or
324: nvl(per_cag_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
325: nvl(p_rec.attribute7, hr_api.g_varchar2) or
326: nvl(per_cag_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
327: nvl(p_rec.attribute8, hr_api.g_varchar2) or
320: nvl(per_cag_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
321: nvl(p_rec.attribute5, hr_api.g_varchar2) or
322: nvl(per_cag_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
323: nvl(p_rec.attribute6, hr_api.g_varchar2) or
324: nvl(per_cag_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
325: nvl(p_rec.attribute7, hr_api.g_varchar2) or
326: nvl(per_cag_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
327: nvl(p_rec.attribute8, hr_api.g_varchar2) or
328: nvl(per_cag_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
321: nvl(p_rec.attribute5, hr_api.g_varchar2) or
322: nvl(per_cag_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
323: nvl(p_rec.attribute6, hr_api.g_varchar2) or
324: nvl(per_cag_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
325: nvl(p_rec.attribute7, hr_api.g_varchar2) or
326: nvl(per_cag_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
327: nvl(p_rec.attribute8, hr_api.g_varchar2) or
328: nvl(per_cag_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
329: nvl(p_rec.attribute9, hr_api.g_varchar2) or
322: nvl(per_cag_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
323: nvl(p_rec.attribute6, hr_api.g_varchar2) or
324: nvl(per_cag_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
325: nvl(p_rec.attribute7, hr_api.g_varchar2) or
326: nvl(per_cag_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
327: nvl(p_rec.attribute8, hr_api.g_varchar2) or
328: nvl(per_cag_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
329: nvl(p_rec.attribute9, hr_api.g_varchar2) or
330: nvl(per_cag_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
323: nvl(p_rec.attribute6, hr_api.g_varchar2) or
324: nvl(per_cag_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
325: nvl(p_rec.attribute7, hr_api.g_varchar2) or
326: nvl(per_cag_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
327: nvl(p_rec.attribute8, hr_api.g_varchar2) or
328: nvl(per_cag_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
329: nvl(p_rec.attribute9, hr_api.g_varchar2) or
330: nvl(per_cag_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
331: nvl(p_rec.attribute10, hr_api.g_varchar2) or
324: nvl(per_cag_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
325: nvl(p_rec.attribute7, hr_api.g_varchar2) or
326: nvl(per_cag_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
327: nvl(p_rec.attribute8, hr_api.g_varchar2) or
328: nvl(per_cag_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
329: nvl(p_rec.attribute9, hr_api.g_varchar2) or
330: nvl(per_cag_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
331: nvl(p_rec.attribute10, hr_api.g_varchar2) or
332: nvl(per_cag_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
325: nvl(p_rec.attribute7, hr_api.g_varchar2) or
326: nvl(per_cag_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
327: nvl(p_rec.attribute8, hr_api.g_varchar2) or
328: nvl(per_cag_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
329: nvl(p_rec.attribute9, hr_api.g_varchar2) or
330: nvl(per_cag_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
331: nvl(p_rec.attribute10, hr_api.g_varchar2) or
332: nvl(per_cag_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
333: nvl(p_rec.attribute11, hr_api.g_varchar2) or
326: nvl(per_cag_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
327: nvl(p_rec.attribute8, hr_api.g_varchar2) or
328: nvl(per_cag_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
329: nvl(p_rec.attribute9, hr_api.g_varchar2) or
330: nvl(per_cag_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
331: nvl(p_rec.attribute10, hr_api.g_varchar2) or
332: nvl(per_cag_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
333: nvl(p_rec.attribute11, hr_api.g_varchar2) or
334: nvl(per_cag_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
327: nvl(p_rec.attribute8, hr_api.g_varchar2) or
328: nvl(per_cag_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
329: nvl(p_rec.attribute9, hr_api.g_varchar2) or
330: nvl(per_cag_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
331: nvl(p_rec.attribute10, hr_api.g_varchar2) or
332: nvl(per_cag_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
333: nvl(p_rec.attribute11, hr_api.g_varchar2) or
334: nvl(per_cag_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
335: nvl(p_rec.attribute12, hr_api.g_varchar2) or
328: nvl(per_cag_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
329: nvl(p_rec.attribute9, hr_api.g_varchar2) or
330: nvl(per_cag_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
331: nvl(p_rec.attribute10, hr_api.g_varchar2) or
332: nvl(per_cag_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
333: nvl(p_rec.attribute11, hr_api.g_varchar2) or
334: nvl(per_cag_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
335: nvl(p_rec.attribute12, hr_api.g_varchar2) or
336: nvl(per_cag_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
329: nvl(p_rec.attribute9, hr_api.g_varchar2) or
330: nvl(per_cag_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
331: nvl(p_rec.attribute10, hr_api.g_varchar2) or
332: nvl(per_cag_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
333: nvl(p_rec.attribute11, hr_api.g_varchar2) or
334: nvl(per_cag_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
335: nvl(p_rec.attribute12, hr_api.g_varchar2) or
336: nvl(per_cag_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
337: nvl(p_rec.attribute13, hr_api.g_varchar2) or
330: nvl(per_cag_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
331: nvl(p_rec.attribute10, hr_api.g_varchar2) or
332: nvl(per_cag_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
333: nvl(p_rec.attribute11, hr_api.g_varchar2) or
334: nvl(per_cag_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
335: nvl(p_rec.attribute12, hr_api.g_varchar2) or
336: nvl(per_cag_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
337: nvl(p_rec.attribute13, hr_api.g_varchar2) or
338: nvl(per_cag_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
331: nvl(p_rec.attribute10, hr_api.g_varchar2) or
332: nvl(per_cag_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
333: nvl(p_rec.attribute11, hr_api.g_varchar2) or
334: nvl(per_cag_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
335: nvl(p_rec.attribute12, hr_api.g_varchar2) or
336: nvl(per_cag_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
337: nvl(p_rec.attribute13, hr_api.g_varchar2) or
338: nvl(per_cag_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
339: nvl(p_rec.attribute14, hr_api.g_varchar2) or
332: nvl(per_cag_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
333: nvl(p_rec.attribute11, hr_api.g_varchar2) or
334: nvl(per_cag_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
335: nvl(p_rec.attribute12, hr_api.g_varchar2) or
336: nvl(per_cag_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
337: nvl(p_rec.attribute13, hr_api.g_varchar2) or
338: nvl(per_cag_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
339: nvl(p_rec.attribute14, hr_api.g_varchar2) or
340: nvl(per_cag_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
333: nvl(p_rec.attribute11, hr_api.g_varchar2) or
334: nvl(per_cag_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
335: nvl(p_rec.attribute12, hr_api.g_varchar2) or
336: nvl(per_cag_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
337: nvl(p_rec.attribute13, hr_api.g_varchar2) or
338: nvl(per_cag_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
339: nvl(p_rec.attribute14, hr_api.g_varchar2) or
340: nvl(per_cag_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
341: nvl(p_rec.attribute15, hr_api.g_varchar2) or
334: nvl(per_cag_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
335: nvl(p_rec.attribute12, hr_api.g_varchar2) or
336: nvl(per_cag_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
337: nvl(p_rec.attribute13, hr_api.g_varchar2) or
338: nvl(per_cag_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
339: nvl(p_rec.attribute14, hr_api.g_varchar2) or
340: nvl(per_cag_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
341: nvl(p_rec.attribute15, hr_api.g_varchar2) or
342: nvl(per_cag_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
335: nvl(p_rec.attribute12, hr_api.g_varchar2) or
336: nvl(per_cag_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
337: nvl(p_rec.attribute13, hr_api.g_varchar2) or
338: nvl(per_cag_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
339: nvl(p_rec.attribute14, hr_api.g_varchar2) or
340: nvl(per_cag_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
341: nvl(p_rec.attribute15, hr_api.g_varchar2) or
342: nvl(per_cag_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
343: nvl(p_rec.attribute16, hr_api.g_varchar2) or
336: nvl(per_cag_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
337: nvl(p_rec.attribute13, hr_api.g_varchar2) or
338: nvl(per_cag_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
339: nvl(p_rec.attribute14, hr_api.g_varchar2) or
340: nvl(per_cag_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
341: nvl(p_rec.attribute15, hr_api.g_varchar2) or
342: nvl(per_cag_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
343: nvl(p_rec.attribute16, hr_api.g_varchar2) or
344: nvl(per_cag_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
337: nvl(p_rec.attribute13, hr_api.g_varchar2) or
338: nvl(per_cag_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
339: nvl(p_rec.attribute14, hr_api.g_varchar2) or
340: nvl(per_cag_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
341: nvl(p_rec.attribute15, hr_api.g_varchar2) or
342: nvl(per_cag_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
343: nvl(p_rec.attribute16, hr_api.g_varchar2) or
344: nvl(per_cag_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
345: nvl(p_rec.attribute17, hr_api.g_varchar2) or
338: nvl(per_cag_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
339: nvl(p_rec.attribute14, hr_api.g_varchar2) or
340: nvl(per_cag_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
341: nvl(p_rec.attribute15, hr_api.g_varchar2) or
342: nvl(per_cag_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
343: nvl(p_rec.attribute16, hr_api.g_varchar2) or
344: nvl(per_cag_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
345: nvl(p_rec.attribute17, hr_api.g_varchar2) or
346: nvl(per_cag_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
339: nvl(p_rec.attribute14, hr_api.g_varchar2) or
340: nvl(per_cag_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
341: nvl(p_rec.attribute15, hr_api.g_varchar2) or
342: nvl(per_cag_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
343: nvl(p_rec.attribute16, hr_api.g_varchar2) or
344: nvl(per_cag_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
345: nvl(p_rec.attribute17, hr_api.g_varchar2) or
346: nvl(per_cag_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
347: nvl(p_rec.attribute18, hr_api.g_varchar2) or
340: nvl(per_cag_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
341: nvl(p_rec.attribute15, hr_api.g_varchar2) or
342: nvl(per_cag_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
343: nvl(p_rec.attribute16, hr_api.g_varchar2) or
344: nvl(per_cag_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
345: nvl(p_rec.attribute17, hr_api.g_varchar2) or
346: nvl(per_cag_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
347: nvl(p_rec.attribute18, hr_api.g_varchar2) or
348: nvl(per_cag_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
341: nvl(p_rec.attribute15, hr_api.g_varchar2) or
342: nvl(per_cag_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
343: nvl(p_rec.attribute16, hr_api.g_varchar2) or
344: nvl(per_cag_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
345: nvl(p_rec.attribute17, hr_api.g_varchar2) or
346: nvl(per_cag_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
347: nvl(p_rec.attribute18, hr_api.g_varchar2) or
348: nvl(per_cag_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
349: nvl(p_rec.attribute19, hr_api.g_varchar2) or
342: nvl(per_cag_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
343: nvl(p_rec.attribute16, hr_api.g_varchar2) or
344: nvl(per_cag_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
345: nvl(p_rec.attribute17, hr_api.g_varchar2) or
346: nvl(per_cag_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
347: nvl(p_rec.attribute18, hr_api.g_varchar2) or
348: nvl(per_cag_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
349: nvl(p_rec.attribute19, hr_api.g_varchar2) or
350: nvl(per_cag_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
343: nvl(p_rec.attribute16, hr_api.g_varchar2) or
344: nvl(per_cag_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
345: nvl(p_rec.attribute17, hr_api.g_varchar2) or
346: nvl(per_cag_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
347: nvl(p_rec.attribute18, hr_api.g_varchar2) or
348: nvl(per_cag_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
349: nvl(p_rec.attribute19, hr_api.g_varchar2) or
350: nvl(per_cag_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
351: nvl(p_rec.attribute20, hr_api.g_varchar2)))
344: nvl(per_cag_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
345: nvl(p_rec.attribute17, hr_api.g_varchar2) or
346: nvl(per_cag_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
347: nvl(p_rec.attribute18, hr_api.g_varchar2) or
348: nvl(per_cag_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
349: nvl(p_rec.attribute19, hr_api.g_varchar2) or
350: nvl(per_cag_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
351: nvl(p_rec.attribute20, hr_api.g_varchar2)))
352: or (p_rec.collective_agreement_id is null) then
345: nvl(p_rec.attribute17, hr_api.g_varchar2) or
346: nvl(per_cag_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
347: nvl(p_rec.attribute18, hr_api.g_varchar2) or
348: nvl(per_cag_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
349: nvl(p_rec.attribute19, hr_api.g_varchar2) or
350: nvl(per_cag_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
351: nvl(p_rec.attribute20, hr_api.g_varchar2)))
352: or (p_rec.collective_agreement_id is null) then
353: --
346: nvl(per_cag_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
347: nvl(p_rec.attribute18, hr_api.g_varchar2) or
348: nvl(per_cag_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
349: nvl(p_rec.attribute19, hr_api.g_varchar2) or
350: nvl(per_cag_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
351: nvl(p_rec.attribute20, hr_api.g_varchar2)))
352: or (p_rec.collective_agreement_id is null) then
353: --
354: -- Only execute the validation if absolutely necessary:
347: nvl(p_rec.attribute18, hr_api.g_varchar2) or
348: nvl(per_cag_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
349: nvl(p_rec.attribute19, hr_api.g_varchar2) or
350: nvl(per_cag_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
351: nvl(p_rec.attribute20, hr_api.g_varchar2)))
352: or (p_rec.collective_agreement_id is null) then
353: --
354: -- Only execute the validation if absolutely necessary:
355: -- a) During update, the structure column value or any
452: --
453: if (p_rec.collective_agreement_id is null)
454: or ((p_rec.collective_agreement_id is not null)
455: and
456: nvl(per_cag_shd.g_old_rec.cag_information_category, hr_api.g_varchar2) <>
457: nvl(p_rec.cag_information_category, hr_api.g_varchar2) or
458: nvl(per_cag_shd.g_old_rec.cag_information1, hr_api.g_varchar2) <>
459: nvl(p_rec.cag_information1, hr_api.g_varchar2) or
460: nvl(per_cag_shd.g_old_rec.cag_information2, hr_api.g_varchar2) <>
453: if (p_rec.collective_agreement_id is null)
454: or ((p_rec.collective_agreement_id is not null)
455: and
456: nvl(per_cag_shd.g_old_rec.cag_information_category, hr_api.g_varchar2) <>
457: nvl(p_rec.cag_information_category, hr_api.g_varchar2) or
458: nvl(per_cag_shd.g_old_rec.cag_information1, hr_api.g_varchar2) <>
459: nvl(p_rec.cag_information1, hr_api.g_varchar2) or
460: nvl(per_cag_shd.g_old_rec.cag_information2, hr_api.g_varchar2) <>
461: nvl(p_rec.cag_information2, hr_api.g_varchar2) or
454: or ((p_rec.collective_agreement_id is not null)
455: and
456: nvl(per_cag_shd.g_old_rec.cag_information_category, hr_api.g_varchar2) <>
457: nvl(p_rec.cag_information_category, hr_api.g_varchar2) or
458: nvl(per_cag_shd.g_old_rec.cag_information1, hr_api.g_varchar2) <>
459: nvl(p_rec.cag_information1, hr_api.g_varchar2) or
460: nvl(per_cag_shd.g_old_rec.cag_information2, hr_api.g_varchar2) <>
461: nvl(p_rec.cag_information2, hr_api.g_varchar2) or
462: nvl(per_cag_shd.g_old_rec.cag_information3, hr_api.g_varchar2) <>
455: and
456: nvl(per_cag_shd.g_old_rec.cag_information_category, hr_api.g_varchar2) <>
457: nvl(p_rec.cag_information_category, hr_api.g_varchar2) or
458: nvl(per_cag_shd.g_old_rec.cag_information1, hr_api.g_varchar2) <>
459: nvl(p_rec.cag_information1, hr_api.g_varchar2) or
460: nvl(per_cag_shd.g_old_rec.cag_information2, hr_api.g_varchar2) <>
461: nvl(p_rec.cag_information2, hr_api.g_varchar2) or
462: nvl(per_cag_shd.g_old_rec.cag_information3, hr_api.g_varchar2) <>
463: nvl(p_rec.cag_information3, hr_api.g_varchar2) or
456: nvl(per_cag_shd.g_old_rec.cag_information_category, hr_api.g_varchar2) <>
457: nvl(p_rec.cag_information_category, hr_api.g_varchar2) or
458: nvl(per_cag_shd.g_old_rec.cag_information1, hr_api.g_varchar2) <>
459: nvl(p_rec.cag_information1, hr_api.g_varchar2) or
460: nvl(per_cag_shd.g_old_rec.cag_information2, hr_api.g_varchar2) <>
461: nvl(p_rec.cag_information2, hr_api.g_varchar2) or
462: nvl(per_cag_shd.g_old_rec.cag_information3, hr_api.g_varchar2) <>
463: nvl(p_rec.cag_information3, hr_api.g_varchar2) or
464: nvl(per_cag_shd.g_old_rec.cag_information4, hr_api.g_varchar2) <>
457: nvl(p_rec.cag_information_category, hr_api.g_varchar2) or
458: nvl(per_cag_shd.g_old_rec.cag_information1, hr_api.g_varchar2) <>
459: nvl(p_rec.cag_information1, hr_api.g_varchar2) or
460: nvl(per_cag_shd.g_old_rec.cag_information2, hr_api.g_varchar2) <>
461: nvl(p_rec.cag_information2, hr_api.g_varchar2) or
462: nvl(per_cag_shd.g_old_rec.cag_information3, hr_api.g_varchar2) <>
463: nvl(p_rec.cag_information3, hr_api.g_varchar2) or
464: nvl(per_cag_shd.g_old_rec.cag_information4, hr_api.g_varchar2) <>
465: nvl(p_rec.cag_information4, hr_api.g_varchar2) or
458: nvl(per_cag_shd.g_old_rec.cag_information1, hr_api.g_varchar2) <>
459: nvl(p_rec.cag_information1, hr_api.g_varchar2) or
460: nvl(per_cag_shd.g_old_rec.cag_information2, hr_api.g_varchar2) <>
461: nvl(p_rec.cag_information2, hr_api.g_varchar2) or
462: nvl(per_cag_shd.g_old_rec.cag_information3, hr_api.g_varchar2) <>
463: nvl(p_rec.cag_information3, hr_api.g_varchar2) or
464: nvl(per_cag_shd.g_old_rec.cag_information4, hr_api.g_varchar2) <>
465: nvl(p_rec.cag_information4, hr_api.g_varchar2) or
466: nvl(per_cag_shd.g_old_rec.cag_information5, hr_api.g_varchar2) <>
459: nvl(p_rec.cag_information1, hr_api.g_varchar2) or
460: nvl(per_cag_shd.g_old_rec.cag_information2, hr_api.g_varchar2) <>
461: nvl(p_rec.cag_information2, hr_api.g_varchar2) or
462: nvl(per_cag_shd.g_old_rec.cag_information3, hr_api.g_varchar2) <>
463: nvl(p_rec.cag_information3, hr_api.g_varchar2) or
464: nvl(per_cag_shd.g_old_rec.cag_information4, hr_api.g_varchar2) <>
465: nvl(p_rec.cag_information4, hr_api.g_varchar2) or
466: nvl(per_cag_shd.g_old_rec.cag_information5, hr_api.g_varchar2) <>
467: nvl(p_rec.cag_information5, hr_api.g_varchar2) or
460: nvl(per_cag_shd.g_old_rec.cag_information2, hr_api.g_varchar2) <>
461: nvl(p_rec.cag_information2, hr_api.g_varchar2) or
462: nvl(per_cag_shd.g_old_rec.cag_information3, hr_api.g_varchar2) <>
463: nvl(p_rec.cag_information3, hr_api.g_varchar2) or
464: nvl(per_cag_shd.g_old_rec.cag_information4, hr_api.g_varchar2) <>
465: nvl(p_rec.cag_information4, hr_api.g_varchar2) or
466: nvl(per_cag_shd.g_old_rec.cag_information5, hr_api.g_varchar2) <>
467: nvl(p_rec.cag_information5, hr_api.g_varchar2) or
468: nvl(per_cag_shd.g_old_rec.cag_information6, hr_api.g_varchar2) <>
461: nvl(p_rec.cag_information2, hr_api.g_varchar2) or
462: nvl(per_cag_shd.g_old_rec.cag_information3, hr_api.g_varchar2) <>
463: nvl(p_rec.cag_information3, hr_api.g_varchar2) or
464: nvl(per_cag_shd.g_old_rec.cag_information4, hr_api.g_varchar2) <>
465: nvl(p_rec.cag_information4, hr_api.g_varchar2) or
466: nvl(per_cag_shd.g_old_rec.cag_information5, hr_api.g_varchar2) <>
467: nvl(p_rec.cag_information5, hr_api.g_varchar2) or
468: nvl(per_cag_shd.g_old_rec.cag_information6, hr_api.g_varchar2) <>
469: nvl(p_rec.cag_information6, hr_api.g_varchar2) or
462: nvl(per_cag_shd.g_old_rec.cag_information3, hr_api.g_varchar2) <>
463: nvl(p_rec.cag_information3, hr_api.g_varchar2) or
464: nvl(per_cag_shd.g_old_rec.cag_information4, hr_api.g_varchar2) <>
465: nvl(p_rec.cag_information4, hr_api.g_varchar2) or
466: nvl(per_cag_shd.g_old_rec.cag_information5, hr_api.g_varchar2) <>
467: nvl(p_rec.cag_information5, hr_api.g_varchar2) or
468: nvl(per_cag_shd.g_old_rec.cag_information6, hr_api.g_varchar2) <>
469: nvl(p_rec.cag_information6, hr_api.g_varchar2) or
470: nvl(per_cag_shd.g_old_rec.cag_information7, hr_api.g_varchar2) <>
463: nvl(p_rec.cag_information3, hr_api.g_varchar2) or
464: nvl(per_cag_shd.g_old_rec.cag_information4, hr_api.g_varchar2) <>
465: nvl(p_rec.cag_information4, hr_api.g_varchar2) or
466: nvl(per_cag_shd.g_old_rec.cag_information5, hr_api.g_varchar2) <>
467: nvl(p_rec.cag_information5, hr_api.g_varchar2) or
468: nvl(per_cag_shd.g_old_rec.cag_information6, hr_api.g_varchar2) <>
469: nvl(p_rec.cag_information6, hr_api.g_varchar2) or
470: nvl(per_cag_shd.g_old_rec.cag_information7, hr_api.g_varchar2) <>
471: nvl(p_rec.cag_information7, hr_api.g_varchar2) or
464: nvl(per_cag_shd.g_old_rec.cag_information4, hr_api.g_varchar2) <>
465: nvl(p_rec.cag_information4, hr_api.g_varchar2) or
466: nvl(per_cag_shd.g_old_rec.cag_information5, hr_api.g_varchar2) <>
467: nvl(p_rec.cag_information5, hr_api.g_varchar2) or
468: nvl(per_cag_shd.g_old_rec.cag_information6, hr_api.g_varchar2) <>
469: nvl(p_rec.cag_information6, hr_api.g_varchar2) or
470: nvl(per_cag_shd.g_old_rec.cag_information7, hr_api.g_varchar2) <>
471: nvl(p_rec.cag_information7, hr_api.g_varchar2) or
472: nvl(per_cag_shd.g_old_rec.cag_information8, hr_api.g_varchar2) <>
465: nvl(p_rec.cag_information4, hr_api.g_varchar2) or
466: nvl(per_cag_shd.g_old_rec.cag_information5, hr_api.g_varchar2) <>
467: nvl(p_rec.cag_information5, hr_api.g_varchar2) or
468: nvl(per_cag_shd.g_old_rec.cag_information6, hr_api.g_varchar2) <>
469: nvl(p_rec.cag_information6, hr_api.g_varchar2) or
470: nvl(per_cag_shd.g_old_rec.cag_information7, hr_api.g_varchar2) <>
471: nvl(p_rec.cag_information7, hr_api.g_varchar2) or
472: nvl(per_cag_shd.g_old_rec.cag_information8, hr_api.g_varchar2) <>
473: nvl(p_rec.cag_information8, hr_api.g_varchar2) or
466: nvl(per_cag_shd.g_old_rec.cag_information5, hr_api.g_varchar2) <>
467: nvl(p_rec.cag_information5, hr_api.g_varchar2) or
468: nvl(per_cag_shd.g_old_rec.cag_information6, hr_api.g_varchar2) <>
469: nvl(p_rec.cag_information6, hr_api.g_varchar2) or
470: nvl(per_cag_shd.g_old_rec.cag_information7, hr_api.g_varchar2) <>
471: nvl(p_rec.cag_information7, hr_api.g_varchar2) or
472: nvl(per_cag_shd.g_old_rec.cag_information8, hr_api.g_varchar2) <>
473: nvl(p_rec.cag_information8, hr_api.g_varchar2) or
474: nvl(per_cag_shd.g_old_rec.cag_information9, hr_api.g_varchar2) <>
467: nvl(p_rec.cag_information5, hr_api.g_varchar2) or
468: nvl(per_cag_shd.g_old_rec.cag_information6, hr_api.g_varchar2) <>
469: nvl(p_rec.cag_information6, hr_api.g_varchar2) or
470: nvl(per_cag_shd.g_old_rec.cag_information7, hr_api.g_varchar2) <>
471: nvl(p_rec.cag_information7, hr_api.g_varchar2) or
472: nvl(per_cag_shd.g_old_rec.cag_information8, hr_api.g_varchar2) <>
473: nvl(p_rec.cag_information8, hr_api.g_varchar2) or
474: nvl(per_cag_shd.g_old_rec.cag_information9, hr_api.g_varchar2) <>
475: nvl(p_rec.cag_information9, hr_api.g_varchar2) or
468: nvl(per_cag_shd.g_old_rec.cag_information6, hr_api.g_varchar2) <>
469: nvl(p_rec.cag_information6, hr_api.g_varchar2) or
470: nvl(per_cag_shd.g_old_rec.cag_information7, hr_api.g_varchar2) <>
471: nvl(p_rec.cag_information7, hr_api.g_varchar2) or
472: nvl(per_cag_shd.g_old_rec.cag_information8, hr_api.g_varchar2) <>
473: nvl(p_rec.cag_information8, hr_api.g_varchar2) or
474: nvl(per_cag_shd.g_old_rec.cag_information9, hr_api.g_varchar2) <>
475: nvl(p_rec.cag_information9, hr_api.g_varchar2) or
476: nvl(per_cag_shd.g_old_rec.cag_information10, hr_api.g_varchar2) <>
469: nvl(p_rec.cag_information6, hr_api.g_varchar2) or
470: nvl(per_cag_shd.g_old_rec.cag_information7, hr_api.g_varchar2) <>
471: nvl(p_rec.cag_information7, hr_api.g_varchar2) or
472: nvl(per_cag_shd.g_old_rec.cag_information8, hr_api.g_varchar2) <>
473: nvl(p_rec.cag_information8, hr_api.g_varchar2) or
474: nvl(per_cag_shd.g_old_rec.cag_information9, hr_api.g_varchar2) <>
475: nvl(p_rec.cag_information9, hr_api.g_varchar2) or
476: nvl(per_cag_shd.g_old_rec.cag_information10, hr_api.g_varchar2) <>
477: nvl(p_rec.cag_information10, hr_api.g_varchar2) or
470: nvl(per_cag_shd.g_old_rec.cag_information7, hr_api.g_varchar2) <>
471: nvl(p_rec.cag_information7, hr_api.g_varchar2) or
472: nvl(per_cag_shd.g_old_rec.cag_information8, hr_api.g_varchar2) <>
473: nvl(p_rec.cag_information8, hr_api.g_varchar2) or
474: nvl(per_cag_shd.g_old_rec.cag_information9, hr_api.g_varchar2) <>
475: nvl(p_rec.cag_information9, hr_api.g_varchar2) or
476: nvl(per_cag_shd.g_old_rec.cag_information10, hr_api.g_varchar2) <>
477: nvl(p_rec.cag_information10, hr_api.g_varchar2) or
478: nvl(per_cag_shd.g_old_rec.cag_information11, hr_api.g_varchar2) <>
471: nvl(p_rec.cag_information7, hr_api.g_varchar2) or
472: nvl(per_cag_shd.g_old_rec.cag_information8, hr_api.g_varchar2) <>
473: nvl(p_rec.cag_information8, hr_api.g_varchar2) or
474: nvl(per_cag_shd.g_old_rec.cag_information9, hr_api.g_varchar2) <>
475: nvl(p_rec.cag_information9, hr_api.g_varchar2) or
476: nvl(per_cag_shd.g_old_rec.cag_information10, hr_api.g_varchar2) <>
477: nvl(p_rec.cag_information10, hr_api.g_varchar2) or
478: nvl(per_cag_shd.g_old_rec.cag_information11, hr_api.g_varchar2) <>
479: nvl(p_rec.cag_information11, hr_api.g_varchar2) or
472: nvl(per_cag_shd.g_old_rec.cag_information8, hr_api.g_varchar2) <>
473: nvl(p_rec.cag_information8, hr_api.g_varchar2) or
474: nvl(per_cag_shd.g_old_rec.cag_information9, hr_api.g_varchar2) <>
475: nvl(p_rec.cag_information9, hr_api.g_varchar2) or
476: nvl(per_cag_shd.g_old_rec.cag_information10, hr_api.g_varchar2) <>
477: nvl(p_rec.cag_information10, hr_api.g_varchar2) or
478: nvl(per_cag_shd.g_old_rec.cag_information11, hr_api.g_varchar2) <>
479: nvl(p_rec.cag_information11, hr_api.g_varchar2) or
480: nvl(per_cag_shd.g_old_rec.cag_information12, hr_api.g_varchar2) <>
473: nvl(p_rec.cag_information8, hr_api.g_varchar2) or
474: nvl(per_cag_shd.g_old_rec.cag_information9, hr_api.g_varchar2) <>
475: nvl(p_rec.cag_information9, hr_api.g_varchar2) or
476: nvl(per_cag_shd.g_old_rec.cag_information10, hr_api.g_varchar2) <>
477: nvl(p_rec.cag_information10, hr_api.g_varchar2) or
478: nvl(per_cag_shd.g_old_rec.cag_information11, hr_api.g_varchar2) <>
479: nvl(p_rec.cag_information11, hr_api.g_varchar2) or
480: nvl(per_cag_shd.g_old_rec.cag_information12, hr_api.g_varchar2) <>
481: nvl(p_rec.cag_information12, hr_api.g_varchar2) or
474: nvl(per_cag_shd.g_old_rec.cag_information9, hr_api.g_varchar2) <>
475: nvl(p_rec.cag_information9, hr_api.g_varchar2) or
476: nvl(per_cag_shd.g_old_rec.cag_information10, hr_api.g_varchar2) <>
477: nvl(p_rec.cag_information10, hr_api.g_varchar2) or
478: nvl(per_cag_shd.g_old_rec.cag_information11, hr_api.g_varchar2) <>
479: nvl(p_rec.cag_information11, hr_api.g_varchar2) or
480: nvl(per_cag_shd.g_old_rec.cag_information12, hr_api.g_varchar2) <>
481: nvl(p_rec.cag_information12, hr_api.g_varchar2) or
482: nvl(per_cag_shd.g_old_rec.cag_information13, hr_api.g_varchar2) <>
475: nvl(p_rec.cag_information9, hr_api.g_varchar2) or
476: nvl(per_cag_shd.g_old_rec.cag_information10, hr_api.g_varchar2) <>
477: nvl(p_rec.cag_information10, hr_api.g_varchar2) or
478: nvl(per_cag_shd.g_old_rec.cag_information11, hr_api.g_varchar2) <>
479: nvl(p_rec.cag_information11, hr_api.g_varchar2) or
480: nvl(per_cag_shd.g_old_rec.cag_information12, hr_api.g_varchar2) <>
481: nvl(p_rec.cag_information12, hr_api.g_varchar2) or
482: nvl(per_cag_shd.g_old_rec.cag_information13, hr_api.g_varchar2) <>
483: nvl(p_rec.cag_information13, hr_api.g_varchar2) or
476: nvl(per_cag_shd.g_old_rec.cag_information10, hr_api.g_varchar2) <>
477: nvl(p_rec.cag_information10, hr_api.g_varchar2) or
478: nvl(per_cag_shd.g_old_rec.cag_information11, hr_api.g_varchar2) <>
479: nvl(p_rec.cag_information11, hr_api.g_varchar2) or
480: nvl(per_cag_shd.g_old_rec.cag_information12, hr_api.g_varchar2) <>
481: nvl(p_rec.cag_information12, hr_api.g_varchar2) or
482: nvl(per_cag_shd.g_old_rec.cag_information13, hr_api.g_varchar2) <>
483: nvl(p_rec.cag_information13, hr_api.g_varchar2) or
484: nvl(per_cag_shd.g_old_rec.cag_information14, hr_api.g_varchar2) <>
477: nvl(p_rec.cag_information10, hr_api.g_varchar2) or
478: nvl(per_cag_shd.g_old_rec.cag_information11, hr_api.g_varchar2) <>
479: nvl(p_rec.cag_information11, hr_api.g_varchar2) or
480: nvl(per_cag_shd.g_old_rec.cag_information12, hr_api.g_varchar2) <>
481: nvl(p_rec.cag_information12, hr_api.g_varchar2) or
482: nvl(per_cag_shd.g_old_rec.cag_information13, hr_api.g_varchar2) <>
483: nvl(p_rec.cag_information13, hr_api.g_varchar2) or
484: nvl(per_cag_shd.g_old_rec.cag_information14, hr_api.g_varchar2) <>
485: nvl(p_rec.cag_information14, hr_api.g_varchar2) or
478: nvl(per_cag_shd.g_old_rec.cag_information11, hr_api.g_varchar2) <>
479: nvl(p_rec.cag_information11, hr_api.g_varchar2) or
480: nvl(per_cag_shd.g_old_rec.cag_information12, hr_api.g_varchar2) <>
481: nvl(p_rec.cag_information12, hr_api.g_varchar2) or
482: nvl(per_cag_shd.g_old_rec.cag_information13, hr_api.g_varchar2) <>
483: nvl(p_rec.cag_information13, hr_api.g_varchar2) or
484: nvl(per_cag_shd.g_old_rec.cag_information14, hr_api.g_varchar2) <>
485: nvl(p_rec.cag_information14, hr_api.g_varchar2) or
486: nvl(per_cag_shd.g_old_rec.cag_information15, hr_api.g_varchar2) <>
479: nvl(p_rec.cag_information11, hr_api.g_varchar2) or
480: nvl(per_cag_shd.g_old_rec.cag_information12, hr_api.g_varchar2) <>
481: nvl(p_rec.cag_information12, hr_api.g_varchar2) or
482: nvl(per_cag_shd.g_old_rec.cag_information13, hr_api.g_varchar2) <>
483: nvl(p_rec.cag_information13, hr_api.g_varchar2) or
484: nvl(per_cag_shd.g_old_rec.cag_information14, hr_api.g_varchar2) <>
485: nvl(p_rec.cag_information14, hr_api.g_varchar2) or
486: nvl(per_cag_shd.g_old_rec.cag_information15, hr_api.g_varchar2) <>
487: nvl(p_rec.cag_information15, hr_api.g_varchar2) or
480: nvl(per_cag_shd.g_old_rec.cag_information12, hr_api.g_varchar2) <>
481: nvl(p_rec.cag_information12, hr_api.g_varchar2) or
482: nvl(per_cag_shd.g_old_rec.cag_information13, hr_api.g_varchar2) <>
483: nvl(p_rec.cag_information13, hr_api.g_varchar2) or
484: nvl(per_cag_shd.g_old_rec.cag_information14, hr_api.g_varchar2) <>
485: nvl(p_rec.cag_information14, hr_api.g_varchar2) or
486: nvl(per_cag_shd.g_old_rec.cag_information15, hr_api.g_varchar2) <>
487: nvl(p_rec.cag_information15, hr_api.g_varchar2) or
488: nvl(per_cag_shd.g_old_rec.cag_information16, hr_api.g_varchar2) <>
481: nvl(p_rec.cag_information12, hr_api.g_varchar2) or
482: nvl(per_cag_shd.g_old_rec.cag_information13, hr_api.g_varchar2) <>
483: nvl(p_rec.cag_information13, hr_api.g_varchar2) or
484: nvl(per_cag_shd.g_old_rec.cag_information14, hr_api.g_varchar2) <>
485: nvl(p_rec.cag_information14, hr_api.g_varchar2) or
486: nvl(per_cag_shd.g_old_rec.cag_information15, hr_api.g_varchar2) <>
487: nvl(p_rec.cag_information15, hr_api.g_varchar2) or
488: nvl(per_cag_shd.g_old_rec.cag_information16, hr_api.g_varchar2) <>
489: nvl(p_rec.cag_information16, hr_api.g_varchar2) or
482: nvl(per_cag_shd.g_old_rec.cag_information13, hr_api.g_varchar2) <>
483: nvl(p_rec.cag_information13, hr_api.g_varchar2) or
484: nvl(per_cag_shd.g_old_rec.cag_information14, hr_api.g_varchar2) <>
485: nvl(p_rec.cag_information14, hr_api.g_varchar2) or
486: nvl(per_cag_shd.g_old_rec.cag_information15, hr_api.g_varchar2) <>
487: nvl(p_rec.cag_information15, hr_api.g_varchar2) or
488: nvl(per_cag_shd.g_old_rec.cag_information16, hr_api.g_varchar2) <>
489: nvl(p_rec.cag_information16, hr_api.g_varchar2) or
490: nvl(per_cag_shd.g_old_rec.cag_information17, hr_api.g_varchar2) <>
483: nvl(p_rec.cag_information13, hr_api.g_varchar2) or
484: nvl(per_cag_shd.g_old_rec.cag_information14, hr_api.g_varchar2) <>
485: nvl(p_rec.cag_information14, hr_api.g_varchar2) or
486: nvl(per_cag_shd.g_old_rec.cag_information15, hr_api.g_varchar2) <>
487: nvl(p_rec.cag_information15, hr_api.g_varchar2) or
488: nvl(per_cag_shd.g_old_rec.cag_information16, hr_api.g_varchar2) <>
489: nvl(p_rec.cag_information16, hr_api.g_varchar2) or
490: nvl(per_cag_shd.g_old_rec.cag_information17, hr_api.g_varchar2) <>
491: nvl(p_rec.cag_information17, hr_api.g_varchar2) or
484: nvl(per_cag_shd.g_old_rec.cag_information14, hr_api.g_varchar2) <>
485: nvl(p_rec.cag_information14, hr_api.g_varchar2) or
486: nvl(per_cag_shd.g_old_rec.cag_information15, hr_api.g_varchar2) <>
487: nvl(p_rec.cag_information15, hr_api.g_varchar2) or
488: nvl(per_cag_shd.g_old_rec.cag_information16, hr_api.g_varchar2) <>
489: nvl(p_rec.cag_information16, hr_api.g_varchar2) or
490: nvl(per_cag_shd.g_old_rec.cag_information17, hr_api.g_varchar2) <>
491: nvl(p_rec.cag_information17, hr_api.g_varchar2) or
492: nvl(per_cag_shd.g_old_rec.cag_information18, hr_api.g_varchar2) <>
485: nvl(p_rec.cag_information14, hr_api.g_varchar2) or
486: nvl(per_cag_shd.g_old_rec.cag_information15, hr_api.g_varchar2) <>
487: nvl(p_rec.cag_information15, hr_api.g_varchar2) or
488: nvl(per_cag_shd.g_old_rec.cag_information16, hr_api.g_varchar2) <>
489: nvl(p_rec.cag_information16, hr_api.g_varchar2) or
490: nvl(per_cag_shd.g_old_rec.cag_information17, hr_api.g_varchar2) <>
491: nvl(p_rec.cag_information17, hr_api.g_varchar2) or
492: nvl(per_cag_shd.g_old_rec.cag_information18, hr_api.g_varchar2) <>
493: nvl(p_rec.cag_information18, hr_api.g_varchar2) or
486: nvl(per_cag_shd.g_old_rec.cag_information15, hr_api.g_varchar2) <>
487: nvl(p_rec.cag_information15, hr_api.g_varchar2) or
488: nvl(per_cag_shd.g_old_rec.cag_information16, hr_api.g_varchar2) <>
489: nvl(p_rec.cag_information16, hr_api.g_varchar2) or
490: nvl(per_cag_shd.g_old_rec.cag_information17, hr_api.g_varchar2) <>
491: nvl(p_rec.cag_information17, hr_api.g_varchar2) or
492: nvl(per_cag_shd.g_old_rec.cag_information18, hr_api.g_varchar2) <>
493: nvl(p_rec.cag_information18, hr_api.g_varchar2) or
494: nvl(per_cag_shd.g_old_rec.cag_information19, hr_api.g_varchar2) <>
487: nvl(p_rec.cag_information15, hr_api.g_varchar2) or
488: nvl(per_cag_shd.g_old_rec.cag_information16, hr_api.g_varchar2) <>
489: nvl(p_rec.cag_information16, hr_api.g_varchar2) or
490: nvl(per_cag_shd.g_old_rec.cag_information17, hr_api.g_varchar2) <>
491: nvl(p_rec.cag_information17, hr_api.g_varchar2) or
492: nvl(per_cag_shd.g_old_rec.cag_information18, hr_api.g_varchar2) <>
493: nvl(p_rec.cag_information18, hr_api.g_varchar2) or
494: nvl(per_cag_shd.g_old_rec.cag_information19, hr_api.g_varchar2) <>
495: nvl(p_rec.cag_information19, hr_api.g_varchar2) or
488: nvl(per_cag_shd.g_old_rec.cag_information16, hr_api.g_varchar2) <>
489: nvl(p_rec.cag_information16, hr_api.g_varchar2) or
490: nvl(per_cag_shd.g_old_rec.cag_information17, hr_api.g_varchar2) <>
491: nvl(p_rec.cag_information17, hr_api.g_varchar2) or
492: nvl(per_cag_shd.g_old_rec.cag_information18, hr_api.g_varchar2) <>
493: nvl(p_rec.cag_information18, hr_api.g_varchar2) or
494: nvl(per_cag_shd.g_old_rec.cag_information19, hr_api.g_varchar2) <>
495: nvl(p_rec.cag_information19, hr_api.g_varchar2) or
496: nvl(per_cag_shd.g_old_rec.cag_information20, hr_api.g_varchar2) <>
489: nvl(p_rec.cag_information16, hr_api.g_varchar2) or
490: nvl(per_cag_shd.g_old_rec.cag_information17, hr_api.g_varchar2) <>
491: nvl(p_rec.cag_information17, hr_api.g_varchar2) or
492: nvl(per_cag_shd.g_old_rec.cag_information18, hr_api.g_varchar2) <>
493: nvl(p_rec.cag_information18, hr_api.g_varchar2) or
494: nvl(per_cag_shd.g_old_rec.cag_information19, hr_api.g_varchar2) <>
495: nvl(p_rec.cag_information19, hr_api.g_varchar2) or
496: nvl(per_cag_shd.g_old_rec.cag_information20, hr_api.g_varchar2) <>
497: nvl(p_rec.cag_information20, hr_api.g_varchar2))
490: nvl(per_cag_shd.g_old_rec.cag_information17, hr_api.g_varchar2) <>
491: nvl(p_rec.cag_information17, hr_api.g_varchar2) or
492: nvl(per_cag_shd.g_old_rec.cag_information18, hr_api.g_varchar2) <>
493: nvl(p_rec.cag_information18, hr_api.g_varchar2) or
494: nvl(per_cag_shd.g_old_rec.cag_information19, hr_api.g_varchar2) <>
495: nvl(p_rec.cag_information19, hr_api.g_varchar2) or
496: nvl(per_cag_shd.g_old_rec.cag_information20, hr_api.g_varchar2) <>
497: nvl(p_rec.cag_information20, hr_api.g_varchar2))
498: then
491: nvl(p_rec.cag_information17, hr_api.g_varchar2) or
492: nvl(per_cag_shd.g_old_rec.cag_information18, hr_api.g_varchar2) <>
493: nvl(p_rec.cag_information18, hr_api.g_varchar2) or
494: nvl(per_cag_shd.g_old_rec.cag_information19, hr_api.g_varchar2) <>
495: nvl(p_rec.cag_information19, hr_api.g_varchar2) or
496: nvl(per_cag_shd.g_old_rec.cag_information20, hr_api.g_varchar2) <>
497: nvl(p_rec.cag_information20, hr_api.g_varchar2))
498: then
499: --
492: nvl(per_cag_shd.g_old_rec.cag_information18, hr_api.g_varchar2) <>
493: nvl(p_rec.cag_information18, hr_api.g_varchar2) or
494: nvl(per_cag_shd.g_old_rec.cag_information19, hr_api.g_varchar2) <>
495: nvl(p_rec.cag_information19, hr_api.g_varchar2) or
496: nvl(per_cag_shd.g_old_rec.cag_information20, hr_api.g_varchar2) <>
497: nvl(p_rec.cag_information20, hr_api.g_varchar2))
498: then
499: --
500: hr_dflex_utility.ins_or_upd_descflex_attribs
493: nvl(p_rec.cag_information18, hr_api.g_varchar2) or
494: nvl(per_cag_shd.g_old_rec.cag_information19, hr_api.g_varchar2) <>
495: nvl(p_rec.cag_information19, hr_api.g_varchar2) or
496: nvl(per_cag_shd.g_old_rec.cag_information20, hr_api.g_varchar2) <>
497: nvl(p_rec.cag_information20, hr_api.g_varchar2))
498: then
499: --
500: hr_dflex_utility.ins_or_upd_descflex_attribs
501: (p_appl_short_name => 'PER'
561: hr_utility.set_location('Entering:'||l_proc, 5);
562: --
563: -- Validate Business Group Id
564: --
565: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
566: --
567: --
568: -- Call all supporting business operations
569: --
637: hr_utility.set_location('Entering:'||l_proc, 5);
638: --
639: -- Call all supporting business operations
640: --
641: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
642: --
643: chk_non_updateable_args
644: (p_rec => p_rec);
645: --
805: hr_utility.set_location('Entering:'|| l_proc, 10);
806: --
807: -- Ensure that all the mandatory parameter are not null
808: --
809: hr_api.mandatory_arg_error(p_api_name => l_proc,
810: p_argument => 'collective_agreement_id',
811: p_argument_value => p_collective_agreement_id);
812: --
813: if nvl(g_collective_agreement_id, hr_api.g_number) = p_collective_agreement_id then
809: hr_api.mandatory_arg_error(p_api_name => l_proc,
810: p_argument => 'collective_agreement_id',
811: p_argument_value => p_collective_agreement_id);
812: --
813: if nvl(g_collective_agreement_id, hr_api.g_number) = p_collective_agreement_id then
814: --
815: -- The legislation code has already been found with a previous
816: -- call to this function. Just return the value in the global
817: -- variable.