49:
50:
51: exception
52: when l_error then
53: hr_api.argument_changed_error
54: (p_api_name => l_proc
55: ,p_argument => l_argument
56: ,p_base_table => per_prt_shd.g_tab_nam);
57: when others then
123: (p_performance_rating_id => p_performance_rating_id
124: ,p_object_version_number => p_object_version_number);
125:
126: if ( (l_api_updating and nvl(per_prt_shd.g_old_rec.appraisal_id,
127: hr_api.g_number)
128: <> nvl(p_appraisal_id,hr_api.g_number)
129: ) or
130: (NOT l_api_updating)
131: ) then
124: ,p_object_version_number => p_object_version_number);
125:
126: if ( (l_api_updating and nvl(per_prt_shd.g_old_rec.appraisal_id,
127: hr_api.g_number)
128: <> nvl(p_appraisal_id,hr_api.g_number)
129: ) or
130: (NOT l_api_updating)
131: ) then
132:
233: begin
234:
235: hr_utility.set_location('Entering:'|| l_proc, 10);
236:
237: hr_api.mandatory_arg_error
238: (p_api_name => l_proc
239: ,p_argument => 'appraisal_id'
240: ,p_argument_value => p_appraisal_id
241: );
251: (p_performance_rating_id => p_performance_rating_id
252: ,p_object_version_number => p_object_version_number);
253:
254: if ( (l_api_updating and nvl(per_prt_shd.g_old_rec.objective_id,
255: hr_api.g_number)
256: <> nvl(p_objective_id,hr_api.g_number)
257: ) or
258: (NOT l_api_updating)
259: ) then
252: ,p_object_version_number => p_object_version_number);
253:
254: if ( (l_api_updating and nvl(per_prt_shd.g_old_rec.objective_id,
255: hr_api.g_number)
256: <> nvl(p_objective_id,hr_api.g_number)
257: ) or
258: (NOT l_api_updating)
259: ) then
260:
404: begin
405:
406: hr_utility.set_location('Entering:'|| l_proc, 10);
407:
408: hr_api.mandatory_arg_error
409: (p_api_name => l_proc
410: ,p_argument => 'appraisal_id'
411: ,p_argument_value => p_appraisal_id
412: );
423: -- a) The current g_old_rec is current and
424: -- b) The value for the rating_level_id has changed
425:
426: if ((l_api_updating AND
427: nvl(per_prt_shd.g_old_rec.performance_level_id, hr_api.g_number)
428: <> nvl(p_performance_level_id, hr_api.g_number))
429: or (not l_api_updating))
430: then
431:
424: -- b) The value for the rating_level_id has changed
425:
426: if ((l_api_updating AND
427: nvl(per_prt_shd.g_old_rec.performance_level_id, hr_api.g_number)
428: <> nvl(p_performance_level_id, hr_api.g_number))
429: or (not l_api_updating))
430: then
431:
432: hr_utility.set_location(l_proc, 30);
475: -- a) The current g_old_rec is current and
476: -- b) The value for the rating_level_id has changed
477:
478: if ((l_api_updating AND
479: nvl(per_prt_shd.g_old_rec.performance_level_id, hr_api.g_number)
480: <> nvl(p_performance_level_id, hr_api.g_number))
481: or (not l_api_updating))
482: then
483:
476: -- b) The value for the rating_level_id has changed
477:
478: if ((l_api_updating AND
479: nvl(per_prt_shd.g_old_rec.performance_level_id, hr_api.g_number)
480: <> nvl(p_performance_level_id, hr_api.g_number))
481: or (not l_api_updating))
482: then
483:
484: hr_utility.set_location(l_proc, 80);
569: begin
570:
571: hr_utility.set_location('Entering:'|| l_proc, 10);
572:
573: hr_api.mandatory_arg_error
574: (p_api_name => l_proc
575: ,p_argument => 'appraisal_id'
576: ,p_argument_value => p_appraisal_id
577: );
647: begin
648: hr_utility.set_location('Entering:'||l_proc, 10);
649:
650: if ((p_rec.performance_rating_id is not null) and (
651: nvl(per_prt_shd.g_old_rec.person_id, hr_api.g_number) <>
652: nvl(p_rec.person_id, hr_api.g_number) or
653: nvl(per_prt_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
654: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
655: nvl(per_prt_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
648: hr_utility.set_location('Entering:'||l_proc, 10);
649:
650: if ((p_rec.performance_rating_id is not null) and (
651: nvl(per_prt_shd.g_old_rec.person_id, hr_api.g_number) <>
652: nvl(p_rec.person_id, hr_api.g_number) or
653: nvl(per_prt_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
654: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
655: nvl(per_prt_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
656: nvl(p_rec.attribute1, hr_api.g_varchar2) or
649:
650: if ((p_rec.performance_rating_id is not null) and (
651: nvl(per_prt_shd.g_old_rec.person_id, hr_api.g_number) <>
652: nvl(p_rec.person_id, hr_api.g_number) or
653: nvl(per_prt_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
654: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
655: nvl(per_prt_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
656: nvl(p_rec.attribute1, hr_api.g_varchar2) or
657: nvl(per_prt_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
650: if ((p_rec.performance_rating_id is not null) and (
651: nvl(per_prt_shd.g_old_rec.person_id, hr_api.g_number) <>
652: nvl(p_rec.person_id, hr_api.g_number) or
653: nvl(per_prt_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
654: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
655: nvl(per_prt_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
656: nvl(p_rec.attribute1, hr_api.g_varchar2) or
657: nvl(per_prt_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
658: nvl(p_rec.attribute2, hr_api.g_varchar2) or
651: nvl(per_prt_shd.g_old_rec.person_id, hr_api.g_number) <>
652: nvl(p_rec.person_id, hr_api.g_number) or
653: nvl(per_prt_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
654: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
655: nvl(per_prt_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
656: nvl(p_rec.attribute1, hr_api.g_varchar2) or
657: nvl(per_prt_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
658: nvl(p_rec.attribute2, hr_api.g_varchar2) or
659: nvl(per_prt_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
652: nvl(p_rec.person_id, hr_api.g_number) or
653: nvl(per_prt_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
654: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
655: nvl(per_prt_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
656: nvl(p_rec.attribute1, hr_api.g_varchar2) or
657: nvl(per_prt_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
658: nvl(p_rec.attribute2, hr_api.g_varchar2) or
659: nvl(per_prt_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
660: nvl(p_rec.attribute3, hr_api.g_varchar2) or
653: nvl(per_prt_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
654: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
655: nvl(per_prt_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
656: nvl(p_rec.attribute1, hr_api.g_varchar2) or
657: nvl(per_prt_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
658: nvl(p_rec.attribute2, hr_api.g_varchar2) or
659: nvl(per_prt_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
660: nvl(p_rec.attribute3, hr_api.g_varchar2) or
661: nvl(per_prt_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
654: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
655: nvl(per_prt_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
656: nvl(p_rec.attribute1, hr_api.g_varchar2) or
657: nvl(per_prt_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
658: nvl(p_rec.attribute2, hr_api.g_varchar2) or
659: nvl(per_prt_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
660: nvl(p_rec.attribute3, hr_api.g_varchar2) or
661: nvl(per_prt_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
662: nvl(p_rec.attribute4, hr_api.g_varchar2) or
655: nvl(per_prt_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
656: nvl(p_rec.attribute1, hr_api.g_varchar2) or
657: nvl(per_prt_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
658: nvl(p_rec.attribute2, hr_api.g_varchar2) or
659: nvl(per_prt_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
660: nvl(p_rec.attribute3, hr_api.g_varchar2) or
661: nvl(per_prt_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
662: nvl(p_rec.attribute4, hr_api.g_varchar2) or
663: nvl(per_prt_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
656: nvl(p_rec.attribute1, hr_api.g_varchar2) or
657: nvl(per_prt_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
658: nvl(p_rec.attribute2, hr_api.g_varchar2) or
659: nvl(per_prt_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
660: nvl(p_rec.attribute3, hr_api.g_varchar2) or
661: nvl(per_prt_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
662: nvl(p_rec.attribute4, hr_api.g_varchar2) or
663: nvl(per_prt_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
664: nvl(p_rec.attribute5, hr_api.g_varchar2) or
657: nvl(per_prt_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
658: nvl(p_rec.attribute2, hr_api.g_varchar2) or
659: nvl(per_prt_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
660: nvl(p_rec.attribute3, hr_api.g_varchar2) or
661: nvl(per_prt_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
662: nvl(p_rec.attribute4, hr_api.g_varchar2) or
663: nvl(per_prt_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
664: nvl(p_rec.attribute5, hr_api.g_varchar2) or
665: nvl(per_prt_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
658: nvl(p_rec.attribute2, hr_api.g_varchar2) or
659: nvl(per_prt_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
660: nvl(p_rec.attribute3, hr_api.g_varchar2) or
661: nvl(per_prt_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
662: nvl(p_rec.attribute4, hr_api.g_varchar2) or
663: nvl(per_prt_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
664: nvl(p_rec.attribute5, hr_api.g_varchar2) or
665: nvl(per_prt_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
666: nvl(p_rec.attribute6, hr_api.g_varchar2) or
659: nvl(per_prt_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
660: nvl(p_rec.attribute3, hr_api.g_varchar2) or
661: nvl(per_prt_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
662: nvl(p_rec.attribute4, hr_api.g_varchar2) or
663: nvl(per_prt_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
664: nvl(p_rec.attribute5, hr_api.g_varchar2) or
665: nvl(per_prt_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
666: nvl(p_rec.attribute6, hr_api.g_varchar2) or
667: nvl(per_prt_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
660: nvl(p_rec.attribute3, hr_api.g_varchar2) or
661: nvl(per_prt_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
662: nvl(p_rec.attribute4, hr_api.g_varchar2) or
663: nvl(per_prt_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
664: nvl(p_rec.attribute5, hr_api.g_varchar2) or
665: nvl(per_prt_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
666: nvl(p_rec.attribute6, hr_api.g_varchar2) or
667: nvl(per_prt_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
668: nvl(p_rec.attribute7, hr_api.g_varchar2) or
661: nvl(per_prt_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
662: nvl(p_rec.attribute4, hr_api.g_varchar2) or
663: nvl(per_prt_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
664: nvl(p_rec.attribute5, hr_api.g_varchar2) or
665: nvl(per_prt_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
666: nvl(p_rec.attribute6, hr_api.g_varchar2) or
667: nvl(per_prt_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
668: nvl(p_rec.attribute7, hr_api.g_varchar2) or
669: nvl(per_prt_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
662: nvl(p_rec.attribute4, hr_api.g_varchar2) or
663: nvl(per_prt_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
664: nvl(p_rec.attribute5, hr_api.g_varchar2) or
665: nvl(per_prt_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
666: nvl(p_rec.attribute6, hr_api.g_varchar2) or
667: nvl(per_prt_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
668: nvl(p_rec.attribute7, hr_api.g_varchar2) or
669: nvl(per_prt_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
670: nvl(p_rec.attribute8, hr_api.g_varchar2) or
663: nvl(per_prt_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
664: nvl(p_rec.attribute5, hr_api.g_varchar2) or
665: nvl(per_prt_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
666: nvl(p_rec.attribute6, hr_api.g_varchar2) or
667: nvl(per_prt_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
668: nvl(p_rec.attribute7, hr_api.g_varchar2) or
669: nvl(per_prt_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
670: nvl(p_rec.attribute8, hr_api.g_varchar2) or
671: nvl(per_prt_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
664: nvl(p_rec.attribute5, hr_api.g_varchar2) or
665: nvl(per_prt_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
666: nvl(p_rec.attribute6, hr_api.g_varchar2) or
667: nvl(per_prt_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
668: nvl(p_rec.attribute7, hr_api.g_varchar2) or
669: nvl(per_prt_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
670: nvl(p_rec.attribute8, hr_api.g_varchar2) or
671: nvl(per_prt_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
672: nvl(p_rec.attribute9, hr_api.g_varchar2) or
665: nvl(per_prt_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
666: nvl(p_rec.attribute6, hr_api.g_varchar2) or
667: nvl(per_prt_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
668: nvl(p_rec.attribute7, hr_api.g_varchar2) or
669: nvl(per_prt_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
670: nvl(p_rec.attribute8, hr_api.g_varchar2) or
671: nvl(per_prt_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
672: nvl(p_rec.attribute9, hr_api.g_varchar2) or
673: nvl(per_prt_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
666: nvl(p_rec.attribute6, hr_api.g_varchar2) or
667: nvl(per_prt_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
668: nvl(p_rec.attribute7, hr_api.g_varchar2) or
669: nvl(per_prt_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
670: nvl(p_rec.attribute8, hr_api.g_varchar2) or
671: nvl(per_prt_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
672: nvl(p_rec.attribute9, hr_api.g_varchar2) or
673: nvl(per_prt_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
674: nvl(p_rec.attribute10, hr_api.g_varchar2) or
667: nvl(per_prt_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
668: nvl(p_rec.attribute7, hr_api.g_varchar2) or
669: nvl(per_prt_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
670: nvl(p_rec.attribute8, hr_api.g_varchar2) or
671: nvl(per_prt_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
672: nvl(p_rec.attribute9, hr_api.g_varchar2) or
673: nvl(per_prt_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
674: nvl(p_rec.attribute10, hr_api.g_varchar2) or
675: nvl(per_prt_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
668: nvl(p_rec.attribute7, hr_api.g_varchar2) or
669: nvl(per_prt_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
670: nvl(p_rec.attribute8, hr_api.g_varchar2) or
671: nvl(per_prt_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
672: nvl(p_rec.attribute9, hr_api.g_varchar2) or
673: nvl(per_prt_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
674: nvl(p_rec.attribute10, hr_api.g_varchar2) or
675: nvl(per_prt_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
676: nvl(p_rec.attribute11, hr_api.g_varchar2) or
669: nvl(per_prt_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
670: nvl(p_rec.attribute8, hr_api.g_varchar2) or
671: nvl(per_prt_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
672: nvl(p_rec.attribute9, hr_api.g_varchar2) or
673: nvl(per_prt_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
674: nvl(p_rec.attribute10, hr_api.g_varchar2) or
675: nvl(per_prt_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
676: nvl(p_rec.attribute11, hr_api.g_varchar2) or
677: nvl(per_prt_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
670: nvl(p_rec.attribute8, hr_api.g_varchar2) or
671: nvl(per_prt_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
672: nvl(p_rec.attribute9, hr_api.g_varchar2) or
673: nvl(per_prt_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
674: nvl(p_rec.attribute10, hr_api.g_varchar2) or
675: nvl(per_prt_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
676: nvl(p_rec.attribute11, hr_api.g_varchar2) or
677: nvl(per_prt_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
678: nvl(p_rec.attribute12, hr_api.g_varchar2) or
671: nvl(per_prt_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
672: nvl(p_rec.attribute9, hr_api.g_varchar2) or
673: nvl(per_prt_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
674: nvl(p_rec.attribute10, hr_api.g_varchar2) or
675: nvl(per_prt_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
676: nvl(p_rec.attribute11, hr_api.g_varchar2) or
677: nvl(per_prt_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
678: nvl(p_rec.attribute12, hr_api.g_varchar2) or
679: nvl(per_prt_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
672: nvl(p_rec.attribute9, hr_api.g_varchar2) or
673: nvl(per_prt_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
674: nvl(p_rec.attribute10, hr_api.g_varchar2) or
675: nvl(per_prt_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
676: nvl(p_rec.attribute11, hr_api.g_varchar2) or
677: nvl(per_prt_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
678: nvl(p_rec.attribute12, hr_api.g_varchar2) or
679: nvl(per_prt_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
680: nvl(p_rec.attribute13, hr_api.g_varchar2) or
673: nvl(per_prt_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
674: nvl(p_rec.attribute10, hr_api.g_varchar2) or
675: nvl(per_prt_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
676: nvl(p_rec.attribute11, hr_api.g_varchar2) or
677: nvl(per_prt_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
678: nvl(p_rec.attribute12, hr_api.g_varchar2) or
679: nvl(per_prt_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
680: nvl(p_rec.attribute13, hr_api.g_varchar2) or
681: nvl(per_prt_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
674: nvl(p_rec.attribute10, hr_api.g_varchar2) or
675: nvl(per_prt_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
676: nvl(p_rec.attribute11, hr_api.g_varchar2) or
677: nvl(per_prt_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
678: nvl(p_rec.attribute12, hr_api.g_varchar2) or
679: nvl(per_prt_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
680: nvl(p_rec.attribute13, hr_api.g_varchar2) or
681: nvl(per_prt_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
682: nvl(p_rec.attribute14, hr_api.g_varchar2) or
675: nvl(per_prt_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
676: nvl(p_rec.attribute11, hr_api.g_varchar2) or
677: nvl(per_prt_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
678: nvl(p_rec.attribute12, hr_api.g_varchar2) or
679: nvl(per_prt_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
680: nvl(p_rec.attribute13, hr_api.g_varchar2) or
681: nvl(per_prt_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
682: nvl(p_rec.attribute14, hr_api.g_varchar2) or
683: nvl(per_prt_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
676: nvl(p_rec.attribute11, hr_api.g_varchar2) or
677: nvl(per_prt_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
678: nvl(p_rec.attribute12, hr_api.g_varchar2) or
679: nvl(per_prt_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
680: nvl(p_rec.attribute13, hr_api.g_varchar2) or
681: nvl(per_prt_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
682: nvl(p_rec.attribute14, hr_api.g_varchar2) or
683: nvl(per_prt_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
684: nvl(p_rec.attribute15, hr_api.g_varchar2) or
677: nvl(per_prt_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
678: nvl(p_rec.attribute12, hr_api.g_varchar2) or
679: nvl(per_prt_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
680: nvl(p_rec.attribute13, hr_api.g_varchar2) or
681: nvl(per_prt_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
682: nvl(p_rec.attribute14, hr_api.g_varchar2) or
683: nvl(per_prt_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
684: nvl(p_rec.attribute15, hr_api.g_varchar2) or
685: nvl(per_prt_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
678: nvl(p_rec.attribute12, hr_api.g_varchar2) or
679: nvl(per_prt_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
680: nvl(p_rec.attribute13, hr_api.g_varchar2) or
681: nvl(per_prt_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
682: nvl(p_rec.attribute14, hr_api.g_varchar2) or
683: nvl(per_prt_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
684: nvl(p_rec.attribute15, hr_api.g_varchar2) or
685: nvl(per_prt_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
686: nvl(p_rec.attribute16, hr_api.g_varchar2) or
679: nvl(per_prt_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
680: nvl(p_rec.attribute13, hr_api.g_varchar2) or
681: nvl(per_prt_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
682: nvl(p_rec.attribute14, hr_api.g_varchar2) or
683: nvl(per_prt_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
684: nvl(p_rec.attribute15, hr_api.g_varchar2) or
685: nvl(per_prt_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
686: nvl(p_rec.attribute16, hr_api.g_varchar2) or
687: nvl(per_prt_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
680: nvl(p_rec.attribute13, hr_api.g_varchar2) or
681: nvl(per_prt_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
682: nvl(p_rec.attribute14, hr_api.g_varchar2) or
683: nvl(per_prt_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
684: nvl(p_rec.attribute15, hr_api.g_varchar2) or
685: nvl(per_prt_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
686: nvl(p_rec.attribute16, hr_api.g_varchar2) or
687: nvl(per_prt_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
688: nvl(p_rec.attribute17, hr_api.g_varchar2) or
681: nvl(per_prt_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
682: nvl(p_rec.attribute14, hr_api.g_varchar2) or
683: nvl(per_prt_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
684: nvl(p_rec.attribute15, hr_api.g_varchar2) or
685: nvl(per_prt_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
686: nvl(p_rec.attribute16, hr_api.g_varchar2) or
687: nvl(per_prt_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
688: nvl(p_rec.attribute17, hr_api.g_varchar2) or
689: nvl(per_prt_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
682: nvl(p_rec.attribute14, hr_api.g_varchar2) or
683: nvl(per_prt_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
684: nvl(p_rec.attribute15, hr_api.g_varchar2) or
685: nvl(per_prt_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
686: nvl(p_rec.attribute16, hr_api.g_varchar2) or
687: nvl(per_prt_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
688: nvl(p_rec.attribute17, hr_api.g_varchar2) or
689: nvl(per_prt_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
690: nvl(p_rec.attribute18, hr_api.g_varchar2) or
683: nvl(per_prt_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
684: nvl(p_rec.attribute15, hr_api.g_varchar2) or
685: nvl(per_prt_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
686: nvl(p_rec.attribute16, hr_api.g_varchar2) or
687: nvl(per_prt_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
688: nvl(p_rec.attribute17, hr_api.g_varchar2) or
689: nvl(per_prt_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
690: nvl(p_rec.attribute18, hr_api.g_varchar2) or
691: nvl(per_prt_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
684: nvl(p_rec.attribute15, hr_api.g_varchar2) or
685: nvl(per_prt_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
686: nvl(p_rec.attribute16, hr_api.g_varchar2) or
687: nvl(per_prt_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
688: nvl(p_rec.attribute17, hr_api.g_varchar2) or
689: nvl(per_prt_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
690: nvl(p_rec.attribute18, hr_api.g_varchar2) or
691: nvl(per_prt_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
692: nvl(p_rec.attribute19, hr_api.g_varchar2) or
685: nvl(per_prt_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
686: nvl(p_rec.attribute16, hr_api.g_varchar2) or
687: nvl(per_prt_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
688: nvl(p_rec.attribute17, hr_api.g_varchar2) or
689: nvl(per_prt_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
690: nvl(p_rec.attribute18, hr_api.g_varchar2) or
691: nvl(per_prt_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
692: nvl(p_rec.attribute19, hr_api.g_varchar2) or
693: nvl(per_prt_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
686: nvl(p_rec.attribute16, hr_api.g_varchar2) or
687: nvl(per_prt_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
688: nvl(p_rec.attribute17, hr_api.g_varchar2) or
689: nvl(per_prt_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
690: nvl(p_rec.attribute18, hr_api.g_varchar2) or
691: nvl(per_prt_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
692: nvl(p_rec.attribute19, hr_api.g_varchar2) or
693: nvl(per_prt_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
694: nvl(p_rec.attribute20, hr_api.g_varchar2)))
687: nvl(per_prt_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
688: nvl(p_rec.attribute17, hr_api.g_varchar2) or
689: nvl(per_prt_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
690: nvl(p_rec.attribute18, hr_api.g_varchar2) or
691: nvl(per_prt_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
692: nvl(p_rec.attribute19, hr_api.g_varchar2) or
693: nvl(per_prt_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
694: nvl(p_rec.attribute20, hr_api.g_varchar2)))
695: or
688: nvl(p_rec.attribute17, hr_api.g_varchar2) or
689: nvl(per_prt_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
690: nvl(p_rec.attribute18, hr_api.g_varchar2) or
691: nvl(per_prt_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
692: nvl(p_rec.attribute19, hr_api.g_varchar2) or
693: nvl(per_prt_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
694: nvl(p_rec.attribute20, hr_api.g_varchar2)))
695: or
696: (p_rec.performance_rating_id is null) then
689: nvl(per_prt_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
690: nvl(p_rec.attribute18, hr_api.g_varchar2) or
691: nvl(per_prt_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
692: nvl(p_rec.attribute19, hr_api.g_varchar2) or
693: nvl(per_prt_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
694: nvl(p_rec.attribute20, hr_api.g_varchar2)))
695: or
696: (p_rec.performance_rating_id is null) then
697:
690: nvl(p_rec.attribute18, hr_api.g_varchar2) or
691: nvl(per_prt_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
692: nvl(p_rec.attribute19, hr_api.g_varchar2) or
693: nvl(per_prt_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
694: nvl(p_rec.attribute20, hr_api.g_varchar2)))
695: or
696: (p_rec.performance_rating_id is null) then
697:
698: -- Only execute the validation if absolutely necessary:
909: hr_utility.set_location('Entering:'||l_proc, 5);
910:
911: -- Ensure that all the mandatory parameters are not null
912:
913: hr_api.mandatory_arg_error (p_api_name => l_proc,
914: p_argument => 'performance_rating_id',
915: p_argument_value => p_performance_rating_id );
916: open csr_leg_code;
917: fetch csr_leg_code into l_legislation_code;