APPS.PER_PRT_BUS dependencies on HR_API

Line 53: hr_api.argument_changed_error

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

Line 127: hr_api.g_number)

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

Line 128: <> nvl(p_appraisal_id,hr_api.g_number)

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:

Line 237: hr_api.mandatory_arg_error

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

Line 255: hr_api.g_number)

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

Line 256: <> nvl(p_objective_id,hr_api.g_number)

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:

Line 408: hr_api.mandatory_arg_error

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

Line 427: nvl(per_prt_shd.g_old_rec.performance_level_id, hr_api.g_number)

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:

Line 428: <> nvl(p_performance_level_id, hr_api.g_number))

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

Line 479: nvl(per_prt_shd.g_old_rec.performance_level_id, hr_api.g_number)

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:

Line 480: <> nvl(p_performance_level_id, hr_api.g_number))

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

Line 573: hr_api.mandatory_arg_error

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

Line 651: nvl(per_prt_shd.g_old_rec.person_id, hr_api.g_number) <>

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

Line 652: nvl(p_rec.person_id, hr_api.g_number) or

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

Line 653: nvl(per_prt_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

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

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

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

Line 655: nvl(per_prt_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

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

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

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

Line 657: nvl(per_prt_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

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

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

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

Line 659: nvl(per_prt_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

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

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

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

Line 661: nvl(per_prt_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

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

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

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

Line 663: nvl(per_prt_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

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

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

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

Line 665: nvl(per_prt_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

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

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

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

Line 667: nvl(per_prt_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

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

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

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

Line 669: nvl(per_prt_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

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

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

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

Line 671: nvl(per_prt_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

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

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

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

Line 673: nvl(per_prt_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

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

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

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

Line 675: nvl(per_prt_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

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

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

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

Line 677: nvl(per_prt_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

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

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

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

Line 679: nvl(per_prt_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

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

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

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

Line 681: nvl(per_prt_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

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

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

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

Line 683: nvl(per_prt_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

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

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

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

Line 685: nvl(per_prt_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

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

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

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

Line 687: nvl(per_prt_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

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

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

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

Line 689: nvl(per_prt_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

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

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

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

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

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

Line 693: nvl(per_prt_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

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:

Line 694: nvl(p_rec.attribute20, 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:
698: -- Only execute the validation if absolutely necessary:

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

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;