APPS.PER_CAG_BUS dependencies on HR_API

Line 65: IF nvl(p_rec.start_Date, hr_api.g_date) <>

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;

Line 66: nvl(per_cag_shd.g_old_rec.start_date,hr_api.g_date) THEN

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: --

Line 75: hr_api.argument_changed_error

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;

Line 310: nvl(per_cag_shd.g_old_rec.attribute_category, hr_api.g_varchar2)<>

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) <>

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

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

Line 312: nvl(per_cag_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

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) <>

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

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

Line 314: nvl(per_cag_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

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) <>

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

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

Line 316: nvl(per_cag_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

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) <>

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

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

Line 318: nvl(per_cag_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

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) <>

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

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

Line 320: nvl(per_cag_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

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) <>

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

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

Line 322: nvl(per_cag_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

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) <>

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

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

Line 324: nvl(per_cag_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

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) <>

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

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

Line 326: nvl(per_cag_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

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) <>

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

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

Line 328: nvl(per_cag_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

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) <>

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

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

Line 330: nvl(per_cag_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

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) <>

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

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

Line 332: nvl(per_cag_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

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) <>

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

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

Line 334: nvl(per_cag_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

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) <>

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

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

Line 336: nvl(per_cag_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

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) <>

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

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

Line 338: nvl(per_cag_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

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) <>

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

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

Line 340: nvl(per_cag_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

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) <>

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

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

Line 342: nvl(per_cag_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

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) <>

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

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

Line 344: nvl(per_cag_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

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) <>

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

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

Line 346: nvl(per_cag_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

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) <>

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

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)))

Line 348: nvl(per_cag_shd.g_old_rec.attribute19, 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

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

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: --

Line 350: nvl(per_cag_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

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:

Line 351: nvl(p_rec.attribute20, 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:
355: -- a) During update, the structure column value or any

Line 456: nvl(per_cag_shd.g_old_rec.cag_information_category, hr_api.g_varchar2) <>

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) <>

Line 457: nvl(p_rec.cag_information_category, hr_api.g_varchar2) or

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

Line 458: nvl(per_cag_shd.g_old_rec.cag_information1, hr_api.g_varchar2) <>

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) <>

Line 459: nvl(p_rec.cag_information1, hr_api.g_varchar2) or

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

Line 460: nvl(per_cag_shd.g_old_rec.cag_information2, hr_api.g_varchar2) <>

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) <>

Line 461: nvl(p_rec.cag_information2, hr_api.g_varchar2) or

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

Line 462: nvl(per_cag_shd.g_old_rec.cag_information3, hr_api.g_varchar2) <>

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) <>

Line 463: nvl(p_rec.cag_information3, hr_api.g_varchar2) or

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

Line 464: nvl(per_cag_shd.g_old_rec.cag_information4, hr_api.g_varchar2) <>

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) <>

Line 465: nvl(p_rec.cag_information4, hr_api.g_varchar2) or

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

Line 466: nvl(per_cag_shd.g_old_rec.cag_information5, hr_api.g_varchar2) <>

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) <>

Line 467: nvl(p_rec.cag_information5, hr_api.g_varchar2) or

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

Line 468: nvl(per_cag_shd.g_old_rec.cag_information6, hr_api.g_varchar2) <>

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) <>

Line 469: nvl(p_rec.cag_information6, hr_api.g_varchar2) or

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

Line 470: nvl(per_cag_shd.g_old_rec.cag_information7, hr_api.g_varchar2) <>

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) <>

Line 471: nvl(p_rec.cag_information7, hr_api.g_varchar2) or

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

Line 472: nvl(per_cag_shd.g_old_rec.cag_information8, hr_api.g_varchar2) <>

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) <>

Line 473: nvl(p_rec.cag_information8, hr_api.g_varchar2) or

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

Line 474: nvl(per_cag_shd.g_old_rec.cag_information9, hr_api.g_varchar2) <>

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) <>

Line 475: nvl(p_rec.cag_information9, hr_api.g_varchar2) or

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

Line 476: nvl(per_cag_shd.g_old_rec.cag_information10, hr_api.g_varchar2) <>

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) <>

Line 477: nvl(p_rec.cag_information10, hr_api.g_varchar2) or

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

Line 478: nvl(per_cag_shd.g_old_rec.cag_information11, hr_api.g_varchar2) <>

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) <>

Line 479: nvl(p_rec.cag_information11, hr_api.g_varchar2) or

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

Line 480: nvl(per_cag_shd.g_old_rec.cag_information12, hr_api.g_varchar2) <>

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) <>

Line 481: nvl(p_rec.cag_information12, hr_api.g_varchar2) or

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

Line 482: nvl(per_cag_shd.g_old_rec.cag_information13, hr_api.g_varchar2) <>

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) <>

Line 483: nvl(p_rec.cag_information13, hr_api.g_varchar2) or

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

Line 484: nvl(per_cag_shd.g_old_rec.cag_information14, hr_api.g_varchar2) <>

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) <>

Line 485: nvl(p_rec.cag_information14, hr_api.g_varchar2) or

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

Line 486: nvl(per_cag_shd.g_old_rec.cag_information15, hr_api.g_varchar2) <>

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) <>

Line 487: nvl(p_rec.cag_information15, hr_api.g_varchar2) or

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

Line 488: nvl(per_cag_shd.g_old_rec.cag_information16, hr_api.g_varchar2) <>

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) <>

Line 489: nvl(p_rec.cag_information16, hr_api.g_varchar2) or

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

Line 490: nvl(per_cag_shd.g_old_rec.cag_information17, hr_api.g_varchar2) <>

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) <>

Line 491: nvl(p_rec.cag_information17, hr_api.g_varchar2) or

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

Line 492: nvl(per_cag_shd.g_old_rec.cag_information18, hr_api.g_varchar2) <>

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) <>

Line 493: nvl(p_rec.cag_information18, hr_api.g_varchar2) or

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))

Line 494: nvl(per_cag_shd.g_old_rec.cag_information19, 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

Line 495: nvl(p_rec.cag_information19, hr_api.g_varchar2) or

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: --

Line 496: nvl(per_cag_shd.g_old_rec.cag_information20, hr_api.g_varchar2) <>

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

Line 497: nvl(p_rec.cag_information20, 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
501: (p_appl_short_name => 'PER'

Line 565: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

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: --

Line 641: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

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: --

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

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

Line 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.