APPS.PER_PRV_BUS dependencies on PER_PRV_SHD

Line 49: l_api_updating := per_prv_shd.api_updating

45: Begin
46: --
47: hr_utility.set_location('Entering:'||l_proc, 5);
48: --
49: l_api_updating := per_prv_shd.api_updating
50: (p_performance_review_id => p_performance_review_id,
51: p_object_version_number => p_object_version_number);
52: --
53: if (l_api_updating

Line 55: <> per_prv_shd.g_old_rec.performance_review_id) then

51: p_object_version_number => p_object_version_number);
52: --
53: if (l_api_updating
54: and nvl(p_performance_review_id,hr_api.g_number)
55: <> per_prv_shd.g_old_rec.performance_review_id) then
56: --
57: -- raise error as PK has changed
58: --
59: per_prv_shd.constraint_error('PER_PERFORMANCE_REVIEWS_PK');

Line 59: per_prv_shd.constraint_error('PER_PERFORMANCE_REVIEWS_PK');

55: <> per_prv_shd.g_old_rec.performance_review_id) then
56: --
57: -- raise error as PK has changed
58: --
59: per_prv_shd.constraint_error('PER_PERFORMANCE_REVIEWS_PK');
60: --
61: elsif not l_api_updating then
62: --
63: -- check if PK is null

Line 69: per_prv_shd.constraint_error('PER_PERFORMANCE_REVIEWS_PK');

65: if p_performance_review_id is not null then
66: --
67: -- raise error as PK is not null
68: --
69: per_prv_shd.constraint_error('PER_PERFORMANCE_REVIEWS_PK');
70: --
71: end if;
72: --
73: end if;

Line 124: l_api_updating := per_prv_shd.api_updating

120: --
121: hr_utility.set_location('Entering:'||l_proc,5);
122: --
123: if (p_event_id is not null) then
124: l_api_updating := per_prv_shd.api_updating
125: (p_performance_review_id => p_performance_review_id
126: ,p_object_version_number => p_object_version_number);
127: --
128: if (l_api_updating

Line 130: <> nvl(per_prv_shd.g_old_rec.event_id,hr_api.g_number)

126: ,p_object_version_number => p_object_version_number);
127: --
128: if (l_api_updating
129: and nvl(p_event_id,hr_api.g_number)
130: <> nvl(per_prv_shd.g_old_rec.event_id,hr_api.g_number)
131: or not l_api_updating) then
132: --
133: -- check if event_id value exists in per_events table
134: --

Line 145: per_prv_shd.constraint_error('PER_PERFORMANCE_REVIEWS_FK2');

141: --
142: -- raise error as FK does not relate to PK in per_events
143: -- table.
144: --
145: per_prv_shd.constraint_error('PER_PERFORMANCE_REVIEWS_FK2');
146: --
147: end if;
148: --
149: close get_event;

Line 203: l_api_updating := per_prv_shd.api_updating

199: ,p_argument => 'person_id'
200: ,p_argument_value => p_person_id
201: );
202: --
203: l_api_updating := per_prv_shd.api_updating
204: (p_performance_review_id => p_performance_review_id,
205: p_object_version_number => p_object_version_number);
206: --
207: if (l_api_updating

Line 209: <> nvl(per_prv_shd.g_old_rec.person_id,hr_api.g_number)

205: p_object_version_number => p_object_version_number);
206: --
207: if (l_api_updating
208: and ( nvl(p_person_id,hr_api.g_number)
209: <> nvl(per_prv_shd.g_old_rec.person_id,hr_api.g_number)
210: or nvl(p_review_date,hr_api.g_date)
211: <> nvl(per_prv_shd.g_old_rec.review_date,hr_api.g_date))
212: or not l_api_updating) then
213: hr_utility.set_location(l_proc,10);

Line 211: <> nvl(per_prv_shd.g_old_rec.review_date,hr_api.g_date))

207: if (l_api_updating
208: and ( nvl(p_person_id,hr_api.g_number)
209: <> nvl(per_prv_shd.g_old_rec.person_id,hr_api.g_number)
210: or nvl(p_review_date,hr_api.g_date)
211: <> nvl(per_prv_shd.g_old_rec.review_date,hr_api.g_date))
212: or not l_api_updating) then
213: hr_utility.set_location(l_proc,10);
214: --
215: -- check if the person exists on this date

Line 228: per_prv_shd.constraint_error('PER_PERFORMANCE_REVIEWS_DT1');

224: --
225: -- raise error as FK does not relate to PK in per_events
226: -- table.
227: --
228: per_prv_shd.constraint_error('PER_PERFORMANCE_REVIEWS_DT1');
229: --
230: end if;
231: --
232: close get_person;

Line 284: l_api_updating := per_prv_shd.api_updating

280: ,p_argument => 'review_date'
281: ,p_argument_value => p_review_date
282: );
283: --
284: l_api_updating := per_prv_shd.api_updating
285: (p_performance_review_id => p_performance_review_id
286: ,p_object_version_number => p_object_version_number);
287: --
288: if (l_api_updating AND

Line 289: (nvl(per_prv_shd.g_old_rec.next_perf_review_date,hr_api.g_date) <>

285: (p_performance_review_id => p_performance_review_id
286: ,p_object_version_number => p_object_version_number);
287: --
288: if (l_api_updating AND
289: (nvl(per_prv_shd.g_old_rec.next_perf_review_date,hr_api.g_date) <>
290: nvl(p_next_perf_review_date,hr_api.g_date)
291: or nvl(per_prv_shd.g_old_rec.review_date ,hr_api.g_date)
292: <> nvl(p_review_date,hr_api.g_date))
293: or not l_api_updating) then

Line 291: or nvl(per_prv_shd.g_old_rec.review_date ,hr_api.g_date)

287: --
288: if (l_api_updating AND
289: (nvl(per_prv_shd.g_old_rec.next_perf_review_date,hr_api.g_date) <>
290: nvl(p_next_perf_review_date,hr_api.g_date)
291: or nvl(per_prv_shd.g_old_rec.review_date ,hr_api.g_date)
292: <> nvl(p_review_date,hr_api.g_date))
293: or not l_api_updating) then
294: --
295: hr_utility.set_location(l_proc, 10);

Line 350: l_api_updating := per_prv_shd.api_updating

346: ,p_argument => 'review_date'
347: ,p_argument_value => p_review_date
348: );
349: --
350: l_api_updating := per_prv_shd.api_updating
351: (p_performance_review_id => p_performance_review_id
352: ,p_object_version_number => p_object_version_number);
353: --
354: if (l_api_updating AND

Line 355: (nvl(per_prv_shd.g_old_rec.review_date ,hr_api.g_date)

351: (p_performance_review_id => p_performance_review_id
352: ,p_object_version_number => p_object_version_number);
353: --
354: if (l_api_updating AND
355: (nvl(per_prv_shd.g_old_rec.review_date ,hr_api.g_date)
356: <> nvl(p_review_date,hr_api.g_date))
357: or not l_api_updating) then
358: --
359: hr_utility.set_location(l_proc, 10);

Line 445: l_api_updating := per_prv_shd.api_updating

441: -- Only proceed with validation if :
442: -- a) The current g_old_rec is current and
443: -- b) The value for performance_rating has changed
444: --
445: l_api_updating := per_prv_shd.api_updating
446: (p_performance_review_id => p_performance_review_id
447: ,p_object_version_number => p_object_version_number);
448: --
449: if (l_api_updating AND (nvl(per_prv_shd.g_old_rec.performance_rating,hr_api.g_varchar2) <>

Line 449: if (l_api_updating AND (nvl(per_prv_shd.g_old_rec.performance_rating,hr_api.g_varchar2) <>

445: l_api_updating := per_prv_shd.api_updating
446: (p_performance_review_id => p_performance_review_id
447: ,p_object_version_number => p_object_version_number);
448: --
449: if (l_api_updating AND (nvl(per_prv_shd.g_old_rec.performance_rating,hr_api.g_varchar2) <>
450: nvl(p_performance_rating,hr_api.g_varchar2)) OR not l_api_updating) then
451: hr_utility.set_location(l_proc, 10);
452: --
453: -- check that the p_performance_rating exists in hr_lookups.

Line 499: (p_rec in per_prv_shd.g_rec_type) is

495: -- Access Status:
496: -- Internal Row Handler Use Only.
497: --
498: procedure chk_df
499: (p_rec in per_prv_shd.g_rec_type) is
500: --
501: l_proc varchar2(72) := g_package||'chk_df';
502: --
503: begin

Line 507: nvl(per_prv_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

503: begin
504: hr_utility.set_location('Entering:'||l_proc, 10);
505: --
506: if ((p_rec.performance_review_id is not null) and (
507: nvl(per_prv_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
508: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
509: nvl(per_prv_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
510: nvl(p_rec.attribute1, hr_api.g_varchar2) or
511: nvl(per_prv_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 509: nvl(per_prv_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

505: --
506: if ((p_rec.performance_review_id is not null) and (
507: nvl(per_prv_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
508: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
509: nvl(per_prv_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
510: nvl(p_rec.attribute1, hr_api.g_varchar2) or
511: nvl(per_prv_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
512: nvl(p_rec.attribute2, hr_api.g_varchar2) or
513: nvl(per_prv_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 511: nvl(per_prv_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

507: nvl(per_prv_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
508: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
509: nvl(per_prv_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
510: nvl(p_rec.attribute1, hr_api.g_varchar2) or
511: nvl(per_prv_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
512: nvl(p_rec.attribute2, hr_api.g_varchar2) or
513: nvl(per_prv_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
514: nvl(p_rec.attribute3, hr_api.g_varchar2) or
515: nvl(per_prv_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 513: nvl(per_prv_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

509: nvl(per_prv_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
510: nvl(p_rec.attribute1, hr_api.g_varchar2) or
511: nvl(per_prv_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
512: nvl(p_rec.attribute2, hr_api.g_varchar2) or
513: nvl(per_prv_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
514: nvl(p_rec.attribute3, hr_api.g_varchar2) or
515: nvl(per_prv_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
516: nvl(p_rec.attribute4, hr_api.g_varchar2) or
517: nvl(per_prv_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 515: nvl(per_prv_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

511: nvl(per_prv_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
512: nvl(p_rec.attribute2, hr_api.g_varchar2) or
513: nvl(per_prv_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
514: nvl(p_rec.attribute3, hr_api.g_varchar2) or
515: nvl(per_prv_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
516: nvl(p_rec.attribute4, hr_api.g_varchar2) or
517: nvl(per_prv_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
518: nvl(p_rec.attribute5, hr_api.g_varchar2) or
519: nvl(per_prv_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 517: nvl(per_prv_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

513: nvl(per_prv_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
514: nvl(p_rec.attribute3, hr_api.g_varchar2) or
515: nvl(per_prv_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
516: nvl(p_rec.attribute4, hr_api.g_varchar2) or
517: nvl(per_prv_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
518: nvl(p_rec.attribute5, hr_api.g_varchar2) or
519: nvl(per_prv_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
520: nvl(p_rec.attribute6, hr_api.g_varchar2) or
521: nvl(per_prv_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 519: nvl(per_prv_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

515: nvl(per_prv_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
516: nvl(p_rec.attribute4, hr_api.g_varchar2) or
517: nvl(per_prv_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
518: nvl(p_rec.attribute5, hr_api.g_varchar2) or
519: nvl(per_prv_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
520: nvl(p_rec.attribute6, hr_api.g_varchar2) or
521: nvl(per_prv_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
522: nvl(p_rec.attribute7, hr_api.g_varchar2) or
523: nvl(per_prv_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 521: nvl(per_prv_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

517: nvl(per_prv_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
518: nvl(p_rec.attribute5, hr_api.g_varchar2) or
519: nvl(per_prv_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
520: nvl(p_rec.attribute6, hr_api.g_varchar2) or
521: nvl(per_prv_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
522: nvl(p_rec.attribute7, hr_api.g_varchar2) or
523: nvl(per_prv_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
524: nvl(p_rec.attribute8, hr_api.g_varchar2) or
525: nvl(per_prv_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 523: nvl(per_prv_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

519: nvl(per_prv_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
520: nvl(p_rec.attribute6, hr_api.g_varchar2) or
521: nvl(per_prv_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
522: nvl(p_rec.attribute7, hr_api.g_varchar2) or
523: nvl(per_prv_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
524: nvl(p_rec.attribute8, hr_api.g_varchar2) or
525: nvl(per_prv_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
526: nvl(p_rec.attribute9, hr_api.g_varchar2) or
527: nvl(per_prv_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 525: nvl(per_prv_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

521: nvl(per_prv_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
522: nvl(p_rec.attribute7, hr_api.g_varchar2) or
523: nvl(per_prv_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
524: nvl(p_rec.attribute8, hr_api.g_varchar2) or
525: nvl(per_prv_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
526: nvl(p_rec.attribute9, hr_api.g_varchar2) or
527: nvl(per_prv_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
528: nvl(p_rec.attribute10, hr_api.g_varchar2) or
529: nvl(per_prv_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

Line 527: nvl(per_prv_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

523: nvl(per_prv_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
524: nvl(p_rec.attribute8, hr_api.g_varchar2) or
525: nvl(per_prv_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
526: nvl(p_rec.attribute9, hr_api.g_varchar2) or
527: nvl(per_prv_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
528: nvl(p_rec.attribute10, hr_api.g_varchar2) or
529: nvl(per_prv_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
530: nvl(p_rec.attribute11, hr_api.g_varchar2) or
531: nvl(per_prv_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

Line 529: nvl(per_prv_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

525: nvl(per_prv_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
526: nvl(p_rec.attribute9, hr_api.g_varchar2) or
527: nvl(per_prv_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
528: nvl(p_rec.attribute10, hr_api.g_varchar2) or
529: nvl(per_prv_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
530: nvl(p_rec.attribute11, hr_api.g_varchar2) or
531: nvl(per_prv_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
532: nvl(p_rec.attribute12, hr_api.g_varchar2) or
533: nvl(per_prv_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

Line 531: nvl(per_prv_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

527: nvl(per_prv_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
528: nvl(p_rec.attribute10, hr_api.g_varchar2) or
529: nvl(per_prv_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
530: nvl(p_rec.attribute11, hr_api.g_varchar2) or
531: nvl(per_prv_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
532: nvl(p_rec.attribute12, hr_api.g_varchar2) or
533: nvl(per_prv_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
534: nvl(p_rec.attribute13, hr_api.g_varchar2) or
535: nvl(per_prv_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

Line 533: nvl(per_prv_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

529: nvl(per_prv_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
530: nvl(p_rec.attribute11, hr_api.g_varchar2) or
531: nvl(per_prv_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
532: nvl(p_rec.attribute12, hr_api.g_varchar2) or
533: nvl(per_prv_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
534: nvl(p_rec.attribute13, hr_api.g_varchar2) or
535: nvl(per_prv_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
536: nvl(p_rec.attribute14, hr_api.g_varchar2) or
537: nvl(per_prv_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

Line 535: nvl(per_prv_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

531: nvl(per_prv_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
532: nvl(p_rec.attribute12, hr_api.g_varchar2) or
533: nvl(per_prv_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
534: nvl(p_rec.attribute13, hr_api.g_varchar2) or
535: nvl(per_prv_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
536: nvl(p_rec.attribute14, hr_api.g_varchar2) or
537: nvl(per_prv_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
538: nvl(p_rec.attribute15, hr_api.g_varchar2) or
539: nvl(per_prv_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

Line 537: nvl(per_prv_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

533: nvl(per_prv_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
534: nvl(p_rec.attribute13, hr_api.g_varchar2) or
535: nvl(per_prv_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
536: nvl(p_rec.attribute14, hr_api.g_varchar2) or
537: nvl(per_prv_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
538: nvl(p_rec.attribute15, hr_api.g_varchar2) or
539: nvl(per_prv_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
540: nvl(p_rec.attribute16, hr_api.g_varchar2) or
541: nvl(per_prv_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

Line 539: nvl(per_prv_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

535: nvl(per_prv_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
536: nvl(p_rec.attribute14, hr_api.g_varchar2) or
537: nvl(per_prv_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
538: nvl(p_rec.attribute15, hr_api.g_varchar2) or
539: nvl(per_prv_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
540: nvl(p_rec.attribute16, hr_api.g_varchar2) or
541: nvl(per_prv_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
542: nvl(p_rec.attribute17, hr_api.g_varchar2) or
543: nvl(per_prv_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

Line 541: nvl(per_prv_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

537: nvl(per_prv_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
538: nvl(p_rec.attribute15, hr_api.g_varchar2) or
539: nvl(per_prv_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
540: nvl(p_rec.attribute16, hr_api.g_varchar2) or
541: nvl(per_prv_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
542: nvl(p_rec.attribute17, hr_api.g_varchar2) or
543: nvl(per_prv_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
544: nvl(p_rec.attribute18, hr_api.g_varchar2) or
545: nvl(per_prv_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

Line 543: nvl(per_prv_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

539: nvl(per_prv_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
540: nvl(p_rec.attribute16, hr_api.g_varchar2) or
541: nvl(per_prv_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
542: nvl(p_rec.attribute17, hr_api.g_varchar2) or
543: nvl(per_prv_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
544: nvl(p_rec.attribute18, hr_api.g_varchar2) or
545: nvl(per_prv_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
546: nvl(p_rec.attribute19, hr_api.g_varchar2) or
547: nvl(per_prv_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

Line 545: nvl(per_prv_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

541: nvl(per_prv_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
542: nvl(p_rec.attribute17, hr_api.g_varchar2) or
543: nvl(per_prv_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
544: nvl(p_rec.attribute18, hr_api.g_varchar2) or
545: nvl(per_prv_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
546: nvl(p_rec.attribute19, hr_api.g_varchar2) or
547: nvl(per_prv_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
548: nvl(p_rec.attribute20, hr_api.g_varchar2) or
549: nvl(per_prv_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>

Line 547: nvl(per_prv_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

543: nvl(per_prv_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
544: nvl(p_rec.attribute18, hr_api.g_varchar2) or
545: nvl(per_prv_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
546: nvl(p_rec.attribute19, hr_api.g_varchar2) or
547: nvl(per_prv_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
548: nvl(p_rec.attribute20, hr_api.g_varchar2) or
549: nvl(per_prv_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
550: nvl(p_rec.attribute21, hr_api.g_varchar2) or
551: nvl(per_prv_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>

Line 549: nvl(per_prv_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>

545: nvl(per_prv_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
546: nvl(p_rec.attribute19, hr_api.g_varchar2) or
547: nvl(per_prv_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
548: nvl(p_rec.attribute20, hr_api.g_varchar2) or
549: nvl(per_prv_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
550: nvl(p_rec.attribute21, hr_api.g_varchar2) or
551: nvl(per_prv_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
552: nvl(p_rec.attribute22, hr_api.g_varchar2) or
553: nvl(per_prv_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>

Line 551: nvl(per_prv_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>

547: nvl(per_prv_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
548: nvl(p_rec.attribute20, hr_api.g_varchar2) or
549: nvl(per_prv_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
550: nvl(p_rec.attribute21, hr_api.g_varchar2) or
551: nvl(per_prv_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
552: nvl(p_rec.attribute22, hr_api.g_varchar2) or
553: nvl(per_prv_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
554: nvl(p_rec.attribute23, hr_api.g_varchar2) or
555: nvl(per_prv_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>

Line 553: nvl(per_prv_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>

549: nvl(per_prv_shd.g_old_rec.attribute21, hr_api.g_varchar2) <>
550: nvl(p_rec.attribute21, hr_api.g_varchar2) or
551: nvl(per_prv_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
552: nvl(p_rec.attribute22, hr_api.g_varchar2) or
553: nvl(per_prv_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
554: nvl(p_rec.attribute23, hr_api.g_varchar2) or
555: nvl(per_prv_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
556: nvl(p_rec.attribute24, hr_api.g_varchar2) or
557: nvl(per_prv_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>

Line 555: nvl(per_prv_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>

551: nvl(per_prv_shd.g_old_rec.attribute22, hr_api.g_varchar2) <>
552: nvl(p_rec.attribute22, hr_api.g_varchar2) or
553: nvl(per_prv_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
554: nvl(p_rec.attribute23, hr_api.g_varchar2) or
555: nvl(per_prv_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
556: nvl(p_rec.attribute24, hr_api.g_varchar2) or
557: nvl(per_prv_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
558: nvl(p_rec.attribute25, hr_api.g_varchar2) or
559: nvl(per_prv_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>

Line 557: nvl(per_prv_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>

553: nvl(per_prv_shd.g_old_rec.attribute23, hr_api.g_varchar2) <>
554: nvl(p_rec.attribute23, hr_api.g_varchar2) or
555: nvl(per_prv_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
556: nvl(p_rec.attribute24, hr_api.g_varchar2) or
557: nvl(per_prv_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
558: nvl(p_rec.attribute25, hr_api.g_varchar2) or
559: nvl(per_prv_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
560: nvl(p_rec.attribute26, hr_api.g_varchar2) or
561: nvl(per_prv_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>

Line 559: nvl(per_prv_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>

555: nvl(per_prv_shd.g_old_rec.attribute24, hr_api.g_varchar2) <>
556: nvl(p_rec.attribute24, hr_api.g_varchar2) or
557: nvl(per_prv_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
558: nvl(p_rec.attribute25, hr_api.g_varchar2) or
559: nvl(per_prv_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
560: nvl(p_rec.attribute26, hr_api.g_varchar2) or
561: nvl(per_prv_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
562: nvl(p_rec.attribute27, hr_api.g_varchar2) or
563: nvl(per_prv_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>

Line 561: nvl(per_prv_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>

557: nvl(per_prv_shd.g_old_rec.attribute25, hr_api.g_varchar2) <>
558: nvl(p_rec.attribute25, hr_api.g_varchar2) or
559: nvl(per_prv_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
560: nvl(p_rec.attribute26, hr_api.g_varchar2) or
561: nvl(per_prv_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
562: nvl(p_rec.attribute27, hr_api.g_varchar2) or
563: nvl(per_prv_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
564: nvl(p_rec.attribute28, hr_api.g_varchar2) or
565: nvl(per_prv_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>

Line 563: nvl(per_prv_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>

559: nvl(per_prv_shd.g_old_rec.attribute26, hr_api.g_varchar2) <>
560: nvl(p_rec.attribute26, hr_api.g_varchar2) or
561: nvl(per_prv_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
562: nvl(p_rec.attribute27, hr_api.g_varchar2) or
563: nvl(per_prv_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
564: nvl(p_rec.attribute28, hr_api.g_varchar2) or
565: nvl(per_prv_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
566: nvl(p_rec.attribute29, hr_api.g_varchar2) or
567: nvl(per_prv_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>

Line 565: nvl(per_prv_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>

561: nvl(per_prv_shd.g_old_rec.attribute27, hr_api.g_varchar2) <>
562: nvl(p_rec.attribute27, hr_api.g_varchar2) or
563: nvl(per_prv_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
564: nvl(p_rec.attribute28, hr_api.g_varchar2) or
565: nvl(per_prv_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
566: nvl(p_rec.attribute29, hr_api.g_varchar2) or
567: nvl(per_prv_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
568: nvl(p_rec.attribute30, hr_api.g_varchar2)))
569: or

Line 567: nvl(per_prv_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>

563: nvl(per_prv_shd.g_old_rec.attribute28, hr_api.g_varchar2) <>
564: nvl(p_rec.attribute28, hr_api.g_varchar2) or
565: nvl(per_prv_shd.g_old_rec.attribute29, hr_api.g_varchar2) <>
566: nvl(p_rec.attribute29, hr_api.g_varchar2) or
567: nvl(per_prv_shd.g_old_rec.attribute30, hr_api.g_varchar2) <>
568: nvl(p_rec.attribute30, hr_api.g_varchar2)))
569: or
570: (p_rec.performance_review_id is null) then
571: --

Line 674: (p_rec in per_prv_shd.g_rec_type ) IS

670: --
671: -- {End Of Comments}
672: -- ----------------------------------------------------------------------------
673: Procedure chk_non_updateable_args
674: (p_rec in per_prv_shd.g_rec_type ) IS
675: --
676: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
677: l_error EXCEPTION;
678: l_argument varchar2(30);

Line 685: IF NOT per_prv_shd.api_updating

681: --
682: -- Only proceed with the validation if a row exists for the current
683: -- record in the HR Schema.
684: --
685: IF NOT per_prv_shd.api_updating
686: (p_performance_review_id => p_rec.performance_review_id
687: ,p_object_version_number => p_rec.object_version_number
688: ) THEN
689: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 698: nvl(per_prv_shd.g_old_rec.person_id

694: --
695: hr_utility.set_location(l_proc, 30);
696: --
697: if nvl(p_rec.person_id, hr_api.g_number) <>
698: nvl(per_prv_shd.g_old_rec.person_id
699: ,hr_api.g_number) then
700: l_argument := 'person_id';
701: raise l_error;
702: end if;

Line 755: Procedure insert_validate(p_rec in per_prv_shd.g_rec_type

751: --
752: -- ----------------------------------------------------------------------------
753: -- |---------------------------< insert_validate >----------------------------|
754: -- ----------------------------------------------------------------------------
755: Procedure insert_validate(p_rec in per_prv_shd.g_rec_type
756: ,p_next_review_date_warning out nocopy boolean ) is
757: --
758: l_proc varchar2(72) := g_package||'insert_validate';
759: --

Line 815: Procedure update_validate(p_rec in per_prv_shd.g_rec_type

811: --
812: -- ----------------------------------------------------------------------------
813: -- |---------------------------< update_validate >----------------------------|
814: -- ----------------------------------------------------------------------------
815: Procedure update_validate(p_rec in per_prv_shd.g_rec_type
816: ,p_next_review_date_warning out nocopy boolean ) is
817: --
818: l_proc varchar2(72) := g_package||'update_validate';
819: --

Line 879: Procedure delete_validate(p_rec in per_prv_shd.g_rec_type) is

875: --
876: -- ----------------------------------------------------------------------------
877: -- |---------------------------< delete_validate >----------------------------|
878: -- ----------------------------------------------------------------------------
879: Procedure delete_validate(p_rec in per_prv_shd.g_rec_type) is
880: --
881: l_proc varchar2(72) := g_package||'delete_validate';
882: --
883: Begin