DBA Data[Home] [Help]

APPS.PER_PEA_BUS dependencies on PER_PEA_SHD

Line 234: l_api_updating := per_pea_shd.api_updating

230: );
231: --
232: hr_utility.set_location(l_proc,10);
233: --
234: l_api_updating := per_pea_shd.api_updating
235: (p_person_analysis_id => p_person_analysis_id
236: ,p_object_version_number => p_object_version_number);
237: --
238: -- Check for valid analysis criteria id

Line 242: (per_pea_shd.g_old_rec.analysis_criteria_id <> p_analysis_criteria_id)

238: -- Check for valid analysis criteria id
239: --
240: if ((l_api_updating
241: and
242: (per_pea_shd.g_old_rec.analysis_criteria_id <> p_analysis_criteria_id)
243: or
244: (per_pea_shd.g_old_rec.id_flex_num <> p_id_flex_num))
245: or
246: (NOT l_api_updating)) then

Line 244: (per_pea_shd.g_old_rec.id_flex_num <> p_id_flex_num))

240: if ((l_api_updating
241: and
242: (per_pea_shd.g_old_rec.analysis_criteria_id <> p_analysis_criteria_id)
243: or
244: (per_pea_shd.g_old_rec.id_flex_num <> p_id_flex_num))
245: or
246: (NOT l_api_updating)) then
247: --
248: hr_utility.set_location(l_proc,15);

Line 450: l_api_updating := per_pea_shd.api_updating

446: -- Only proceed with validation if :
447: -- a) The current g_old_rec is current and
448: -- b) The DATE_TO value has changed
449: --
450: l_api_updating := per_pea_shd.api_updating
451: (p_person_analysis_id => p_person_analysis_id
452: ,p_object_version_number => p_object_version_number);
453: --
454: if (((l_api_updating

Line 456: (nvl(per_pea_shd.g_old_rec.date_from,hr_api.g_eot) <>nvl(p_date_from,hr_api.g_eot))

452: ,p_object_version_number => p_object_version_number);
453: --
454: if (((l_api_updating
455: and
456: (nvl(per_pea_shd.g_old_rec.date_from,hr_api.g_eot) <>nvl(p_date_from,hr_api.g_eot))
457: or
458: (nvl(per_pea_shd.g_old_rec.date_to,hr_api.g_eot) <> nvl(p_date_to,hr_api.g_eot)))
459: or
460: (NOT l_api_updating))) then

Line 458: (nvl(per_pea_shd.g_old_rec.date_to,hr_api.g_eot) <> nvl(p_date_to,hr_api.g_eot)))

454: if (((l_api_updating
455: and
456: (nvl(per_pea_shd.g_old_rec.date_from,hr_api.g_eot) <>nvl(p_date_from,hr_api.g_eot))
457: or
458: (nvl(per_pea_shd.g_old_rec.date_to,hr_api.g_eot) <> nvl(p_date_to,hr_api.g_eot)))
459: or
460: (NOT l_api_updating))) then
461: --
462: -- Check DATE_FROM.If the DATE_TO has value,DATE_FROM is not null.

Line 500: Procedure check_non_updateable_args(p_rec in per_pea_shd.g_rec_type)

496: --
497: -- ----------------------------------------------------------------------------
498: -- |--------------------< check_non_updateable_args >-------------------------|
499: -- ----------------------------------------------------------------------------
500: Procedure check_non_updateable_args(p_rec in per_pea_shd.g_rec_type)
501: is
502: --
503: l_proc varchar2(72) := g_package||'check_non_updateable_args';
504: --

Line 511: if not per_pea_shd.api_updating

507: --
508: -- Only proceed with validation if a row exists for
509: -- the current record in the HR Schema
510: --
511: if not per_pea_shd.api_updating
512: (p_person_analysis_id => p_rec.person_analysis_id
513: ,p_object_version_number => p_rec.object_version_number
514: ) then
515: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 525: per_pea_shd.g_old_rec.business_group_id then

521: hr_utility.set_location(l_proc,10);
522: --
523: --
524: if nvl(p_rec.business_group_id, hr_api.g_number) <>
525: per_pea_shd.g_old_rec.business_group_id then
526: hr_api.argument_changed_error
527: (p_api_name => l_proc
528: ,p_argument => 'BUSINESS_GROUP_ID'
529: ,p_base_table => per_pea_shd.g_tab_nam

Line 529: ,p_base_table => per_pea_shd.g_tab_nam

525: per_pea_shd.g_old_rec.business_group_id then
526: hr_api.argument_changed_error
527: (p_api_name => l_proc
528: ,p_argument => 'BUSINESS_GROUP_ID'
529: ,p_base_table => per_pea_shd.g_tab_nam
530: );
531: end if;
532: --
533: if nvl(p_rec.person_id, hr_api.g_number) <>

Line 534: per_pea_shd.g_old_rec.person_id then

530: );
531: end if;
532: --
533: if nvl(p_rec.person_id, hr_api.g_number) <>
534: per_pea_shd.g_old_rec.person_id then
535: hr_api.argument_changed_error
536: (p_api_name => l_proc
537: ,p_argument => 'PERSON_ID'
538: ,p_base_table => per_pea_shd.g_tab_nam

Line 538: ,p_base_table => per_pea_shd.g_tab_nam

534: per_pea_shd.g_old_rec.person_id then
535: hr_api.argument_changed_error
536: (p_api_name => l_proc
537: ,p_argument => 'PERSON_ID'
538: ,p_base_table => per_pea_shd.g_tab_nam
539: );
540: end if;
541: hr_utility.set_location(' Leaving:'||l_proc, 15);
542: end check_non_updateable_args;

Line 572: (p_rec in per_pea_shd.g_rec_type) is

568: -- Access Status:
569: -- Internal Row Handler Use Only.
570: --
571: procedure chk_df
572: (p_rec in per_pea_shd.g_rec_type) is
573: --
574: l_proc varchar2(72) := g_package||'chk_df';
575: --
576: begin

Line 580: nvl(per_pea_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>

576: begin
577: hr_utility.set_location('Entering:'||l_proc, 10);
578: --
579: if ((p_rec.person_analysis_id is not null) and (
580: nvl(per_pea_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
581: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
582: nvl(per_pea_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
583: nvl(p_rec.attribute1, hr_api.g_varchar2) or
584: nvl(per_pea_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

Line 582: nvl(per_pea_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

578: --
579: if ((p_rec.person_analysis_id is not null) and (
580: nvl(per_pea_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
581: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
582: nvl(per_pea_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
583: nvl(p_rec.attribute1, hr_api.g_varchar2) or
584: nvl(per_pea_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
585: nvl(p_rec.attribute2, hr_api.g_varchar2) or
586: nvl(per_pea_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

Line 584: nvl(per_pea_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>

580: nvl(per_pea_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
581: nvl(p_rec.attribute_category, hr_api.g_varchar2) or
582: nvl(per_pea_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
583: nvl(p_rec.attribute1, hr_api.g_varchar2) or
584: nvl(per_pea_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
585: nvl(p_rec.attribute2, hr_api.g_varchar2) or
586: nvl(per_pea_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
587: nvl(p_rec.attribute3, hr_api.g_varchar2) or
588: nvl(per_pea_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

Line 586: nvl(per_pea_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>

582: nvl(per_pea_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>
583: nvl(p_rec.attribute1, hr_api.g_varchar2) or
584: nvl(per_pea_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
585: nvl(p_rec.attribute2, hr_api.g_varchar2) or
586: nvl(per_pea_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
587: nvl(p_rec.attribute3, hr_api.g_varchar2) or
588: nvl(per_pea_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
589: nvl(p_rec.attribute4, hr_api.g_varchar2) or
590: nvl(per_pea_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

Line 588: nvl(per_pea_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>

584: nvl(per_pea_shd.g_old_rec.attribute2, hr_api.g_varchar2) <>
585: nvl(p_rec.attribute2, hr_api.g_varchar2) or
586: nvl(per_pea_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
587: nvl(p_rec.attribute3, hr_api.g_varchar2) or
588: nvl(per_pea_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
589: nvl(p_rec.attribute4, hr_api.g_varchar2) or
590: nvl(per_pea_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
591: nvl(p_rec.attribute5, hr_api.g_varchar2) or
592: nvl(per_pea_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

Line 590: nvl(per_pea_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>

586: nvl(per_pea_shd.g_old_rec.attribute3, hr_api.g_varchar2) <>
587: nvl(p_rec.attribute3, hr_api.g_varchar2) or
588: nvl(per_pea_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
589: nvl(p_rec.attribute4, hr_api.g_varchar2) or
590: nvl(per_pea_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
591: nvl(p_rec.attribute5, hr_api.g_varchar2) or
592: nvl(per_pea_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
593: nvl(p_rec.attribute6, hr_api.g_varchar2) or
594: nvl(per_pea_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

Line 592: nvl(per_pea_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>

588: nvl(per_pea_shd.g_old_rec.attribute4, hr_api.g_varchar2) <>
589: nvl(p_rec.attribute4, hr_api.g_varchar2) or
590: nvl(per_pea_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
591: nvl(p_rec.attribute5, hr_api.g_varchar2) or
592: nvl(per_pea_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
593: nvl(p_rec.attribute6, hr_api.g_varchar2) or
594: nvl(per_pea_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
595: nvl(p_rec.attribute7, hr_api.g_varchar2) or
596: nvl(per_pea_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

Line 594: nvl(per_pea_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>

590: nvl(per_pea_shd.g_old_rec.attribute5, hr_api.g_varchar2) <>
591: nvl(p_rec.attribute5, hr_api.g_varchar2) or
592: nvl(per_pea_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
593: nvl(p_rec.attribute6, hr_api.g_varchar2) or
594: nvl(per_pea_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
595: nvl(p_rec.attribute7, hr_api.g_varchar2) or
596: nvl(per_pea_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
597: nvl(p_rec.attribute8, hr_api.g_varchar2) or
598: nvl(per_pea_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

Line 596: nvl(per_pea_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>

592: nvl(per_pea_shd.g_old_rec.attribute6, hr_api.g_varchar2) <>
593: nvl(p_rec.attribute6, hr_api.g_varchar2) or
594: nvl(per_pea_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
595: nvl(p_rec.attribute7, hr_api.g_varchar2) or
596: nvl(per_pea_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
597: nvl(p_rec.attribute8, hr_api.g_varchar2) or
598: nvl(per_pea_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
599: nvl(p_rec.attribute9, hr_api.g_varchar2) or
600: nvl(per_pea_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

Line 598: nvl(per_pea_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>

594: nvl(per_pea_shd.g_old_rec.attribute7, hr_api.g_varchar2) <>
595: nvl(p_rec.attribute7, hr_api.g_varchar2) or
596: nvl(per_pea_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
597: nvl(p_rec.attribute8, hr_api.g_varchar2) or
598: nvl(per_pea_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
599: nvl(p_rec.attribute9, hr_api.g_varchar2) or
600: nvl(per_pea_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
601: nvl(p_rec.attribute10, hr_api.g_varchar2) or
602: nvl(per_pea_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

Line 600: nvl(per_pea_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>

596: nvl(per_pea_shd.g_old_rec.attribute8, hr_api.g_varchar2) <>
597: nvl(p_rec.attribute8, hr_api.g_varchar2) or
598: nvl(per_pea_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
599: nvl(p_rec.attribute9, hr_api.g_varchar2) or
600: nvl(per_pea_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
601: nvl(p_rec.attribute10, hr_api.g_varchar2) or
602: nvl(per_pea_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
603: nvl(p_rec.attribute11, hr_api.g_varchar2) or
604: nvl(per_pea_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

Line 602: nvl(per_pea_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>

598: nvl(per_pea_shd.g_old_rec.attribute9, hr_api.g_varchar2) <>
599: nvl(p_rec.attribute9, hr_api.g_varchar2) or
600: nvl(per_pea_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
601: nvl(p_rec.attribute10, hr_api.g_varchar2) or
602: nvl(per_pea_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
603: nvl(p_rec.attribute11, hr_api.g_varchar2) or
604: nvl(per_pea_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
605: nvl(p_rec.attribute12, hr_api.g_varchar2) or
606: nvl(per_pea_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

Line 604: nvl(per_pea_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>

600: nvl(per_pea_shd.g_old_rec.attribute10, hr_api.g_varchar2) <>
601: nvl(p_rec.attribute10, hr_api.g_varchar2) or
602: nvl(per_pea_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
603: nvl(p_rec.attribute11, hr_api.g_varchar2) or
604: nvl(per_pea_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
605: nvl(p_rec.attribute12, hr_api.g_varchar2) or
606: nvl(per_pea_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
607: nvl(p_rec.attribute13, hr_api.g_varchar2) or
608: nvl(per_pea_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

Line 606: nvl(per_pea_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>

602: nvl(per_pea_shd.g_old_rec.attribute11, hr_api.g_varchar2) <>
603: nvl(p_rec.attribute11, hr_api.g_varchar2) or
604: nvl(per_pea_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
605: nvl(p_rec.attribute12, hr_api.g_varchar2) or
606: nvl(per_pea_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
607: nvl(p_rec.attribute13, hr_api.g_varchar2) or
608: nvl(per_pea_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
609: nvl(p_rec.attribute14, hr_api.g_varchar2) or
610: nvl(per_pea_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

Line 608: nvl(per_pea_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>

604: nvl(per_pea_shd.g_old_rec.attribute12, hr_api.g_varchar2) <>
605: nvl(p_rec.attribute12, hr_api.g_varchar2) or
606: nvl(per_pea_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
607: nvl(p_rec.attribute13, hr_api.g_varchar2) or
608: nvl(per_pea_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
609: nvl(p_rec.attribute14, hr_api.g_varchar2) or
610: nvl(per_pea_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
611: nvl(p_rec.attribute15, hr_api.g_varchar2) or
612: nvl(per_pea_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

Line 610: nvl(per_pea_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>

606: nvl(per_pea_shd.g_old_rec.attribute13, hr_api.g_varchar2) <>
607: nvl(p_rec.attribute13, hr_api.g_varchar2) or
608: nvl(per_pea_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
609: nvl(p_rec.attribute14, hr_api.g_varchar2) or
610: nvl(per_pea_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
611: nvl(p_rec.attribute15, hr_api.g_varchar2) or
612: nvl(per_pea_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
613: nvl(p_rec.attribute16, hr_api.g_varchar2) or
614: nvl(per_pea_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

Line 612: nvl(per_pea_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>

608: nvl(per_pea_shd.g_old_rec.attribute14, hr_api.g_varchar2) <>
609: nvl(p_rec.attribute14, hr_api.g_varchar2) or
610: nvl(per_pea_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
611: nvl(p_rec.attribute15, hr_api.g_varchar2) or
612: nvl(per_pea_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
613: nvl(p_rec.attribute16, hr_api.g_varchar2) or
614: nvl(per_pea_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
615: nvl(p_rec.attribute17, hr_api.g_varchar2) or
616: nvl(per_pea_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

Line 614: nvl(per_pea_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>

610: nvl(per_pea_shd.g_old_rec.attribute15, hr_api.g_varchar2) <>
611: nvl(p_rec.attribute15, hr_api.g_varchar2) or
612: nvl(per_pea_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
613: nvl(p_rec.attribute16, hr_api.g_varchar2) or
614: nvl(per_pea_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
615: nvl(p_rec.attribute17, hr_api.g_varchar2) or
616: nvl(per_pea_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
617: nvl(p_rec.attribute18, hr_api.g_varchar2) or
618: nvl(per_pea_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

Line 616: nvl(per_pea_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>

612: nvl(per_pea_shd.g_old_rec.attribute16, hr_api.g_varchar2) <>
613: nvl(p_rec.attribute16, hr_api.g_varchar2) or
614: nvl(per_pea_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
615: nvl(p_rec.attribute17, hr_api.g_varchar2) or
616: nvl(per_pea_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
617: nvl(p_rec.attribute18, hr_api.g_varchar2) or
618: nvl(per_pea_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
619: nvl(p_rec.attribute19, hr_api.g_varchar2) or
620: nvl(per_pea_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

Line 618: nvl(per_pea_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>

614: nvl(per_pea_shd.g_old_rec.attribute17, hr_api.g_varchar2) <>
615: nvl(p_rec.attribute17, hr_api.g_varchar2) or
616: nvl(per_pea_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
617: nvl(p_rec.attribute18, hr_api.g_varchar2) or
618: nvl(per_pea_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
619: nvl(p_rec.attribute19, hr_api.g_varchar2) or
620: nvl(per_pea_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
621: nvl(p_rec.attribute20, hr_api.g_varchar2)))
622: or

Line 620: nvl(per_pea_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>

616: nvl(per_pea_shd.g_old_rec.attribute18, hr_api.g_varchar2) <>
617: nvl(p_rec.attribute18, hr_api.g_varchar2) or
618: nvl(per_pea_shd.g_old_rec.attribute19, hr_api.g_varchar2) <>
619: nvl(p_rec.attribute19, hr_api.g_varchar2) or
620: nvl(per_pea_shd.g_old_rec.attribute20, hr_api.g_varchar2) <>
621: nvl(p_rec.attribute20, hr_api.g_varchar2)))
622: or
623: (p_rec.person_analysis_id is null) then
624: --

Line 684: (p_rec in per_pea_shd.g_rec_type,

680: -- ----------------------------------------------------------------------------
681: -- |---------------------------< insert_validate >----------------------------|
682: -- ----------------------------------------------------------------------------
683: Procedure insert_validate
684: (p_rec in per_pea_shd.g_rec_type,
685: p_effective_date in date) is
686: --
687: l_proc varchar2(72) := g_package||'insert_validate';
688: --

Line 696: ,p_associated_column1 => per_pea_shd.g_tab_nam || '.BUSINESS_GROUP_ID'

692: -- Validate Important Attributes
693: --
694: hr_api.validate_bus_grp_id
695: (p_business_group_id => p_rec.business_group_id
696: ,p_associated_column1 => per_pea_shd.g_tab_nam || '.BUSINESS_GROUP_ID'
697: ); -- Validate Bus Grp
698: --
699: --After validating the set of important attributes,
700: --if multiple message detection is enabled and atleast

Line 778: (p_rec in per_pea_shd.g_rec_type) is

774: -- ----------------------------------------------------------------------------
775: -- |---------------------------< update_validate >----------------------------|
776: -- ----------------------------------------------------------------------------
777: Procedure update_validate
778: (p_rec in per_pea_shd.g_rec_type) is
779: --
780: l_proc varchar2(72) := g_package||'update_validate';
781: --
782: Begin

Line 789: ,p_associated_column1 => per_pea_shd.g_tab_nam || '.BUSINESS_GROUP_ID'

785: -- Validate Important Attributes
786: --
787: hr_api.validate_bus_grp_id
788: (p_business_group_id => p_rec.business_group_id
789: ,p_associated_column1 => per_pea_shd.g_tab_nam || '.BUSINESS_GROUP_ID'
790: ); -- Validate Bus Grp
791: --
792: --After validating the set of important attributes,
793: --if multiple message detection is enabled and atleast

Line 866: Procedure delete_validate(p_rec in per_pea_shd.g_rec_type) is

862: --
863: -- ----------------------------------------------------------------------------
864: -- |---------------------------< delete_validate >----------------------------|
865: -- ----------------------------------------------------------------------------
866: Procedure delete_validate(p_rec in per_pea_shd.g_rec_type) is
867: --
868: l_proc varchar2(72) := g_package||'delete_validate';
869: --
870: Begin