APPS.PER_PRV_BUS dependencies on HR_API

Line 54: and nvl(p_performance_review_id,hr_api.g_number)

50: (p_performance_review_id => p_performance_review_id,
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: --

Line 129: and nvl(p_event_id,hr_api.g_number)

125: (p_performance_review_id => p_performance_review_id
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

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 191: hr_api.mandatory_arg_error

187: hr_utility.set_location('Entering:'||l_proc,5);
188: --
189: -- Check mandatory parameters have being set.
190: --
191: hr_api.mandatory_arg_error
192: (p_api_name => l_proc
193: ,p_argument => 'review_date'
194: ,p_argument_value => p_review_date
195: );

Line 197: hr_api.mandatory_arg_error

193: ,p_argument => 'review_date'
194: ,p_argument_value => p_review_date
195: );
196: --
197: hr_api.mandatory_arg_error
198: (p_api_name => l_proc
199: ,p_argument => 'person_id'
200: ,p_argument_value => p_person_id
201: );

Line 208: and ( nvl(p_person_id,hr_api.g_number)

204: (p_performance_review_id => p_performance_review_id,
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

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 210: or nvl(p_review_date,hr_api.g_date)

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);
214: --

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 278: hr_api.mandatory_arg_error

274: hr_utility.set_location('Entering:'||l_proc, 5);
275: --
276: -- Check mandatory parameters have being set.
277: --
278: hr_api.mandatory_arg_error
279: (p_api_name => l_proc
280: ,p_argument => 'review_date'
281: ,p_argument_value => p_review_date
282: );

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 290: nvl(p_next_perf_review_date,hr_api.g_date)

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

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 292: <> nvl(p_review_date,hr_api.g_date))

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);
296: if(p_next_perf_review_date<=p_review_date) then

Line 344: hr_api.mandatory_arg_error

340: hr_utility.set_location('Entering:'||l_proc, 5);
341: --
342: -- Check mandatory parameters have being set.
343: --
344: hr_api.mandatory_arg_error
345: (p_api_name => l_proc
346: ,p_argument => 'review_date'
347: ,p_argument_value => p_review_date
348: );

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 356: <> nvl(p_review_date,hr_api.g_date))

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);
360: if(p_assignment_id is not null

Line 435: hr_api.mandatory_arg_error

431: hr_utility.set_location('Entering:'|| l_proc, 5);
432: --
433: -- Check mandatory parameters have being set.
434: --
435: hr_api.mandatory_arg_error
436: (p_api_name => l_proc
437: ,p_argument => 'performance_rating'
438: ,p_argument_value => p_performance_rating
439: );

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 450: nvl(p_performance_rating,hr_api.g_varchar2)) OR not l_api_updating) then

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

Line 455: if hr_api.not_exists_in_hr_lookups

451: hr_utility.set_location(l_proc, 10);
452: --
453: -- check that the p_performance_rating exists in hr_lookups.
454: --
455: if hr_api.not_exists_in_hr_lookups
456: (p_effective_date => p_review_date
457: ,p_lookup_type => 'PERFORMANCE_RATING'
458: ,p_lookup_code => p_performance_rating
459: ) then

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 508: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

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) <>
512: nvl(p_rec.attribute2, hr_api.g_varchar2) or

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 510: nvl(p_rec.attribute1, hr_api.g_varchar2) or

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) <>
514: nvl(p_rec.attribute3, hr_api.g_varchar2) or

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 512: nvl(p_rec.attribute2, hr_api.g_varchar2) or

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) <>
516: nvl(p_rec.attribute4, hr_api.g_varchar2) or

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 514: nvl(p_rec.attribute3, hr_api.g_varchar2) or

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) <>
518: nvl(p_rec.attribute5, hr_api.g_varchar2) or

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 516: nvl(p_rec.attribute4, hr_api.g_varchar2) or

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) <>
520: nvl(p_rec.attribute6, hr_api.g_varchar2) or

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 518: nvl(p_rec.attribute5, hr_api.g_varchar2) or

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) <>
522: nvl(p_rec.attribute7, hr_api.g_varchar2) or

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 520: nvl(p_rec.attribute6, hr_api.g_varchar2) or

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) <>
524: nvl(p_rec.attribute8, hr_api.g_varchar2) or

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 522: nvl(p_rec.attribute7, hr_api.g_varchar2) or

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) <>
526: nvl(p_rec.attribute9, hr_api.g_varchar2) or

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 524: nvl(p_rec.attribute8, hr_api.g_varchar2) or

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) <>
528: nvl(p_rec.attribute10, hr_api.g_varchar2) or

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 526: nvl(p_rec.attribute9, hr_api.g_varchar2) or

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) <>
530: nvl(p_rec.attribute11, hr_api.g_varchar2) or

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 528: nvl(p_rec.attribute10, hr_api.g_varchar2) or

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) <>
532: nvl(p_rec.attribute12, hr_api.g_varchar2) or

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 530: nvl(p_rec.attribute11, hr_api.g_varchar2) or

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) <>
534: nvl(p_rec.attribute13, hr_api.g_varchar2) or

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 532: nvl(p_rec.attribute12, hr_api.g_varchar2) or

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) <>
536: nvl(p_rec.attribute14, hr_api.g_varchar2) or

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 534: nvl(p_rec.attribute13, hr_api.g_varchar2) or

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) <>
538: nvl(p_rec.attribute15, hr_api.g_varchar2) or

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 536: nvl(p_rec.attribute14, hr_api.g_varchar2) or

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) <>
540: nvl(p_rec.attribute16, hr_api.g_varchar2) or

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 538: nvl(p_rec.attribute15, hr_api.g_varchar2) or

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) <>
542: nvl(p_rec.attribute17, hr_api.g_varchar2) or

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 540: nvl(p_rec.attribute16, hr_api.g_varchar2) or

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) <>
544: nvl(p_rec.attribute18, hr_api.g_varchar2) or

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 542: nvl(p_rec.attribute17, hr_api.g_varchar2) or

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) <>
546: nvl(p_rec.attribute19, hr_api.g_varchar2) or

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 544: nvl(p_rec.attribute18, hr_api.g_varchar2) or

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) <>
548: nvl(p_rec.attribute20, hr_api.g_varchar2) or

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 546: nvl(p_rec.attribute19, hr_api.g_varchar2) or

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) <>
550: nvl(p_rec.attribute21, hr_api.g_varchar2) or

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 548: nvl(p_rec.attribute20, hr_api.g_varchar2) or

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) <>
552: nvl(p_rec.attribute22, hr_api.g_varchar2) or

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 550: nvl(p_rec.attribute21, hr_api.g_varchar2) or

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) <>
554: nvl(p_rec.attribute23, hr_api.g_varchar2) or

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 552: nvl(p_rec.attribute22, hr_api.g_varchar2) or

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) <>
556: nvl(p_rec.attribute24, hr_api.g_varchar2) or

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 554: nvl(p_rec.attribute23, hr_api.g_varchar2) or

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) <>
558: nvl(p_rec.attribute25, hr_api.g_varchar2) or

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 556: nvl(p_rec.attribute24, hr_api.g_varchar2) or

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) <>
560: nvl(p_rec.attribute26, hr_api.g_varchar2) or

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 558: nvl(p_rec.attribute25, hr_api.g_varchar2) or

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) <>
562: nvl(p_rec.attribute27, hr_api.g_varchar2) or

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 560: nvl(p_rec.attribute26, hr_api.g_varchar2) or

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) <>
564: nvl(p_rec.attribute28, hr_api.g_varchar2) or

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 562: nvl(p_rec.attribute27, hr_api.g_varchar2) or

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) <>
566: nvl(p_rec.attribute29, hr_api.g_varchar2) or

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 564: nvl(p_rec.attribute28, hr_api.g_varchar2) or

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) <>
568: nvl(p_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 566: nvl(p_rec.attribute29, hr_api.g_varchar2) or

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
570: (p_rec.performance_review_id is null) then

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 568: nvl(p_rec.attribute30, 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: --
572: -- Only execute the validation if absolutely necessary:

Line 697: if nvl(p_rec.person_id, hr_api.g_number) <>

693: END IF;
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;

Line 699: ,hr_api.g_number) then

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

Line 707: hr_api.argument_changed_error

703: --
704: --
705: EXCEPTION
706: WHEN l_error THEN
707: hr_api.argument_changed_error
708: (p_api_name => l_proc
709: ,p_argument => l_argument);
710: WHEN OTHERS THEN
711: RAISE;

Line 732: hr_api.mandatory_arg_error

728: Begin
729: --
730: hr_utility.set_location('Entering:'||l_proc, 5);
731: --
732: hr_api.mandatory_arg_error
733: (p_api_name => l_proc
734: ,p_argument => 'performance_review_id'
735: ,p_argument_value => p_performance_review_id
736: );

Line 915: hr_api.mandatory_arg_error

911: l_legislation_code varchar2(150);
912: l_proc varchar2(72) := 'return_legislation_code';
913: begin
914: hr_utility.set_location('Entering: '||l_proc,10);
915: hr_api.mandatory_arg_error
916: (p_api_name => l_proc
917: ,p_argument => 'performance_review_id'
918: ,p_argument_value => p_performance_review_id
919: );

Line 920: if nvl(g_performance_review_id, hr_api.g_number) = p_performance_review_id then

916: (p_api_name => l_proc
917: ,p_argument => 'performance_review_id'
918: ,p_argument_value => p_performance_review_id
919: );
920: if nvl(g_performance_review_id, hr_api.g_number) = p_performance_review_id then
921: --
922: -- The legislation code has already been found with a previous
923: -- call to this function. Just return the value in the global
924: -- variable.