APPS.PER_PTU_BUS dependencies on PER_PERSON_TYPE_USAGES_F

Line 503: per_ptu_shd.constraint_error('PER_PERSON_TYPE_USAGES_F_FK1');

499: open csr_valid_person_id;
500: fetch csr_valid_person_id into l_person_id;
501: if csr_valid_person_id%notfound then
502: close csr_valid_person_id;
503: per_ptu_shd.constraint_error('PER_PERSON_TYPE_USAGES_F_FK1');
504: end if;
505: close csr_valid_person_id;
506:
507: hr_utility.set_location('Leaving: '||l_proc,10);

Line 570: from per_person_type_usages_f

566: -- We are doing this check regardless of the enabled flag
567: -- as even old records must be used for this validation
568: cursor csr_check_uniqueness is
569: select person_type_usage_id
570: from per_person_type_usages_f
571: where person_type_id in ( select person_type_id
572: from per_person_types
573: where system_person_type = l_person_type
574: and business_group_id = l_business_group_id )

Line 615: per_ptu_shd.constraint_error('PER_PERSON_TYPE_USAGES_F_FK2');

611: open csr_valid_person_type(p_person_type_id);
612: fetch csr_valid_person_type into l_person_type , l_business_group_id;
613: if csr_valid_person_type%notfound then
614: close csr_valid_person_type;
615: per_ptu_shd.constraint_error('PER_PERSON_TYPE_USAGES_F_FK2');
616: end if;
617: close csr_valid_person_type;
618:
619: hr_utility.set_location('At: '||l_proc,15);

Line 634: per_ptu_shd.constraint_error('PER_PERSON_TYPE_USAGES_F_FK2');

630: l_person_type = 'EX_APL' or
631: l_person_type = 'EMP_APL' or
632: l_person_type = 'EX_EMP_APL' or
633: l_person_type = 'APL_EX_APL') then
634: per_ptu_shd.constraint_error('PER_PERSON_TYPE_USAGES_F_FK2');
635: end if;
636: --
637: --
638: hr_utility.set_location('At: '||l_proc,20);

Line 669: per_ptu_shd.constraint_error('PER_PERSON_TYPE_USAGES_F_FK2');

665: open csr_valid_person_type(per_ptu_shd.g_old_rec.person_type_id);
666: fetch csr_valid_person_type into l_old_person_type , l_business_group_id;
667: if csr_valid_person_type%notfound then
668: close csr_valid_person_type;
669: per_ptu_shd.constraint_error('PER_PERSON_TYPE_USAGES_F_FK2');
670: end if;
671: close csr_valid_person_type;
672: --
673: -- PTU changes: now allow transitions between type and ex_type

Line 829: , per_person_type_usages_f ptu

825: --
826: cursor csr_leg_code is
827: select pbg.legislation_code
828: from per_business_groups pbg
829: , per_person_type_usages_f ptu
830: , per_all_people_f per
831: where ptu.person_type_usage_id = p_person_type_usage_id
832: and ptu.person_id = per.person_id
833: and pbg.business_group_id = per.business_group_id;