APPS.PER_PRT_BUS dependencies on PER_PRT_SHD

Line 15: procedure chk_non_updateable_args(p_rec in per_prt_shd.g_rec_type) is

11: -- -------------------------------------------------------------------+
12: -- --------------------< chk_non_updateable_args >--------------------+
13: -- -------------------------------------------------------------------+
14:
15: procedure chk_non_updateable_args(p_rec in per_prt_shd.g_rec_type) is
16:
17: l_proc varchar2(72) := g_package||'chk_non_updateable_args';
18: l_error exception;
19: l_argument varchar2(30);

Line 27: if not per_prt_shd.api_updating

23:
24: -- Only proceed with validation if a row exists for the current record
25: -- in the HR schema
26:
27: if not per_prt_shd.api_updating
28: (p_performance_rating_id => p_rec.performance_rating_id
29: ,p_object_version_number => p_rec.object_version_number
30: ) then
31: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 38: if p_rec.appraisal_id <> per_prt_shd.g_old_rec.appraisal_id then

34: end if;
35:
36: hr_utility.set_location(l_proc, 30);
37:
38: if p_rec.appraisal_id <> per_prt_shd.g_old_rec.appraisal_id then
39: l_argument := 'appraisal_id';
40: raise l_error;
41: end if;
42:

Line 45: if p_rec.objective_id <> per_prt_shd.g_old_rec.objective_id then

41: end if;
42:
43: hr_utility.set_location(l_proc, 40);
44:
45: if p_rec.objective_id <> per_prt_shd.g_old_rec.objective_id then
46: l_argument := 'objective_id';
47: raise l_error;
48: end if;
49:

Line 56: ,p_base_table => per_prt_shd.g_tab_nam);

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
58: raise;
59: hr_utility.set_location(' Leaving:'||l_proc, 50);
60: end chk_non_updateable_args;

Line 122: l_api_updating := per_prt_shd.api_updating

118: end if;
119:
120: hr_utility.set_location(l_proc, 20);
121:
122: l_api_updating := per_prt_shd.api_updating
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,

Line 126: if ( (l_api_updating and nvl(per_prt_shd.g_old_rec.appraisal_id,

122: l_api_updating := per_prt_shd.api_updating
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)

Line 250: l_api_updating := per_prt_shd.api_updating

246: end if;
247:
248: hr_utility.set_location(l_proc, 20);
249:
250: l_api_updating := per_prt_shd.api_updating
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,

Line 254: if ( (l_api_updating and nvl(per_prt_shd.g_old_rec.objective_id,

250: l_api_updating := per_prt_shd.api_updating
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)

Line 416: l_api_updating := per_prt_shd.api_updating

412: );
413:
414: -- check if the record is being updated
415:
416: l_api_updating := per_prt_shd.api_updating
417: (p_performance_rating_id => p_performance_rating_id
418: ,p_object_version_number => p_object_version_number);
419:
420: hr_utility.set_location(l_proc, 20);

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 468: l_api_updating := per_prt_shd.api_updating

464: end if;
465:
466: hr_utility.set_location(l_proc, 60);
467:
468: l_api_updating := per_prt_shd.api_updating
469: (p_performance_rating_id => p_performance_rating_id
470: ,p_object_version_number => p_object_version_number);
471:
472: hr_utility.set_location(l_proc, 70);

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

639: -- {End Of Comments}
640: -- ---------------------------------------------------------------------------+
641:
642: procedure chk_df
643: (p_rec in per_prt_shd.g_rec_type) is
644:
645: l_proc varchar2(72) := g_package||'chk_df';
646:
647: begin

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 755: Procedure insert_validate(p_rec in per_prt_shd.g_rec_type, p_effective_date in date) is

751:
752: -- ---------------------------------------------------------------------------+
753: -- |---------------------------< insert_validate >----------------------------|
754: -- ---------------------------------------------------------------------------+
755: Procedure insert_validate(p_rec in per_prt_shd.g_rec_type, p_effective_date in date) is
756:
757: l_proc varchar2(72) := g_package||'insert_validate';
758:
759: Begin

Line 765: ,p_associated_column1 => per_prt_shd.g_tab_nam || '.APPRAISAL_ID');

761:
762: per_apr_bus.set_security_group_id
763: (
764: p_appraisal_id => p_rec.appraisal_id
765: ,p_associated_column1 => per_prt_shd.g_tab_nam || '.APPRAISAL_ID');
766:
767: --
768: hr_multi_message.end_validation_set;
769: --

Line 826: Procedure update_validate(p_rec in per_prt_shd.g_rec_type, p_effective_date in date) is

822:
823: -- ---------------------------------------------------------------------------+
824: -- |---------------------------< update_validate >----------------------------|
825: -- ---------------------------------------------------------------------------+
826: Procedure update_validate(p_rec in per_prt_shd.g_rec_type, p_effective_date in date) is
827:
828: l_proc varchar2(72) := g_package||'update_validate';
829:
830: Begin

Line 836: ,p_associated_column1 => per_prt_shd.g_tab_nam || '.APPRAISAL_ID');

832:
833: per_apr_bus.set_security_group_id
834: (
835: p_appraisal_id => p_rec.appraisal_id
836: ,p_associated_column1 => per_prt_shd.g_tab_nam || '.APPRAISAL_ID');
837:
838: --
839: hr_multi_message.end_validation_set;
840: --

Line 874: Procedure delete_validate(p_rec in per_prt_shd.g_rec_type) is

870:
871: -- ---------------------------------------------------------------------------+
872: -- |---------------------------< delete_validate >----------------------------|
873: -- ---------------------------------------------------------------------------+
874: Procedure delete_validate(p_rec in per_prt_shd.g_rec_type) is
875:
876: l_proc varchar2(72) := g_package||'delete_validate';
877:
878: Begin