APPS.PER_CAG_BUS dependencies on PER_CAG_SHD

Line 44: (p_rec in per_cag_shd.g_rec_type) IS

40: --
41: -- {End Of Comments}
42: -- ----------------------------------------------------------------------------
43: Procedure chk_non_updateable_args
44: (p_rec in per_cag_shd.g_rec_type) IS
45: --
46: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
47: l_error EXCEPTION;
48: l_argument varchar2(30);

Line 55: IF NOT per_cag_shd.api_updating

51: --
52: -- Only proceed with the validation if a row exists for the current
53: -- record in the HR Schema.
54: --
55: IF NOT per_cag_shd.api_updating
56: (p_collective_agreement_id => p_rec.collective_agreement_id
57: ,p_object_version_number => p_rec.object_version_number
58: ) THEN
59: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

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 206: per_cag_shd.g_old_rec.employer_organization_id <> p_employer_organization_id) Then

202: /* for each insert or in update only if the employer_organization_id value is different */
203:
204: if (p_collective_agreement_id is null and p_employer_organization_id IS NOT NULL) OR
205: (p_collective_agreement_id is NOT null AND
206: per_cag_shd.g_old_rec.employer_organization_id <> p_employer_organization_id) Then
207: begin
208: open csr_employers;
209: fetch csr_employers into l_dummy;
210: if csr_employers%notfound then

Line 256: per_cag_shd.g_old_rec.bargaining_organization_id <> p_bargaining_organization_id) Then

252: /* The validation check for the BARGAINING_ORGANIZATION_ID will be done (if a value is given) against the HR_FR_BARGAINING_UNITS_V view */
253: /* for each insert or in update only if the employer_organization_id value is different */
254: if (p_collective_agreement_id is null and p_bargaining_organization_id IS NOT NULL) OR
255: (p_collective_agreement_id is NOT null AND
256: per_cag_shd.g_old_rec.bargaining_organization_id <> p_bargaining_organization_id) Then
257: begin
258: open csr_bargaining_units;
259: fetch csr_bargaining_units into l_dummy;
260: if csr_bargaining_units%notfound then

Line 302: (p_rec in per_cag_shd.g_rec_type) is

298: -- Access Status:
299: -- Internal Row Handler Use Only.
300: --
301: procedure chk_df
302: (p_rec in per_cag_shd.g_rec_type) is
303: --
304: l_proc varchar2(72) := g_package||'chk_df';
305: --
306: begin

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 442: (p_rec in per_cag_shd.g_rec_type) is

438: -- {End Of Comments}
439: -- ----------------------------------------------------------------------------
440: --
441: procedure chk_ddf
442: (p_rec in per_cag_shd.g_rec_type) is
443: --
444: l_proc varchar2(72) := g_package||'chk_ddf';
445: l_error exception;
446: --

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 556: Procedure insert_validate(p_rec in per_cag_shd.g_rec_type) is

552: --
553: -- ----------------------------------------------------------------------------
554: -- |---------------------------< insert_validate >----------------------------|
555: -- ----------------------------------------------------------------------------
556: Procedure insert_validate(p_rec in per_cag_shd.g_rec_type) is
557: --
558: l_proc varchar2(72) := g_package||'insert_validate';
559: --
560: Begin

Line 632: Procedure update_validate(p_rec in per_cag_shd.g_rec_type) is

628: --
629: -- ----------------------------------------------------------------------------
630: -- |---------------------------< update_validate >----------------------------|
631: -- ----------------------------------------------------------------------------
632: Procedure update_validate(p_rec in per_cag_shd.g_rec_type) is
633: --
634: l_proc varchar2(72) := g_package||'update_validate';
635: --
636: Begin

Line 690: Procedure delete_validate(p_rec in per_cag_shd.g_rec_type) is

686: --
687: -- ----------------------------------------------------------------------------
688: -- |---------------------------< delete_validate >----------------------------|
689: -- ----------------------------------------------------------------------------
690: Procedure delete_validate(p_rec in per_cag_shd.g_rec_type) is
691:
692: cursor csr_assignment is select '1'
693: from per_all_assignments_f paa
694: where paa.collective_agreement_id = p_rec.collective_agreement_id;