APPS.HR_PERSON_API dependencies on PER_ALL_PEOPLE_F

Line 167: l_old_person_type_id per_all_people_f.person_type_id%type;

163: p_person_type_id;
164: l_person_type_id1 per_person_types.person_type_id%type :=
165: p_person_type_id;
166: l_business_group_id per_people_f.business_group_id%type;
167: l_old_person_type_id per_all_people_f.person_type_id%type;
168: l_current_system_person_type per_person_types.system_person_type%type;
169: l_validate boolean := false;
170: l_discard_varchar2 varchar2(40);
171: l_applicant_number per_people_f.applicant_number%TYPE;

Line 227: and phn.parent_table = 'PER_ALL_PEOPLE_F'

223: object_version_number,
224: date_to --Line added for bug# 878827
225: from per_phones phn
226: where phn.parent_id = p_person_id
227: and phn.parent_table = 'PER_ALL_PEOPLE_F'
228: and phn.phone_type = 'W1'
229: and p_effective_date between phn.date_from and
230: nvl(phn.date_to,p_effective_date);
231:

Line 436: (ie per_all_people_f stores only a person type of OTHER) this

432: end if;
433: --
434: /*
435: This is obsolete. With introduction of Contingent Workers using the PTU model
436: (ie per_all_people_f stores only a person type of OTHER) this
437: check raises erroneous errors. Comment out nocopy also person_type_id in the call to per_per_upd
438: This ensures that PT is unchanged on per_all_people_f
439: Instead added validation before the PTU call below.
440:

Line 438: This ensures that PT is unchanged on per_all_people_f

434: /*
435: This is obsolete. With introduction of Contingent Workers using the PTU model
436: (ie per_all_people_f stores only a person type of OTHER) this
437: check raises erroneous errors. Comment out nocopy also person_type_id in the call to per_per_upd
438: This ensures that PT is unchanged on per_all_people_f
439: Instead added validation before the PTU call below.
440:
441: if p_person_type_id <> hr_api.g_number then
442: open csr_current_type;

Line 624: -- get the current system person type from per_all_people_f

620: -- Bug# 2777435
621:
622: if p_person_type_id <> hr_api.g_number then
623: --
624: -- get the current system person type from per_all_people_f
625: -- Bug 4030116
626: -- modifed the following SQL to check whether the person_type_id
627: -- is already exists for the PTU table instead of per_all_people_f
628: l_old_person_type_id := null;

Line 627: -- is already exists for the PTU table instead of per_all_people_f

623: --
624: -- get the current system person type from per_all_people_f
625: -- Bug 4030116
626: -- modifed the following SQL to check whether the person_type_id
627: -- is already exists for the PTU table instead of per_all_people_f
628: l_old_person_type_id := null;
629: begin
630: select person_type_id into l_old_person_type_id
631: from per_person_type_usages_f ptu

Line 781: ,p_parent_table => 'PER_ALL_PEOPLE_F'

777: ,p_date_to => null
778: ,p_phone_type => 'W1'
779: ,p_phone_number => p_work_telephone
780: ,p_parent_id => p_person_id
781: ,p_parent_table => 'PER_ALL_PEOPLE_F'
782: ,p_validate => FALSE
783: ,p_effective_date => l_effective_date
784: ,p_object_version_number => l_phn_object_version_number --out
785: ,p_phone_id => l_phone_id --out

Line 860: ,p_parent_table => 'PER_ALL_PEOPLE_F'

856: --replaced null with l_phn_date_to for bug# 878827
857: ,p_phone_type => 'W1'
858: ,p_phone_number => p_work_telephone
859: ,p_parent_id => p_person_id
860: ,p_parent_table => 'PER_ALL_PEOPLE_F'
861: ,p_validate => FALSE
862: ,p_effective_date => l_effective_date
863: ,p_object_version_number => l_phn_object_version_number --out
864: ,p_phone_id => l_phone_id --out

Line 1788: l_party_id per_all_people_f.party_id%type;

1784: --
1785:
1786: l_effective_date date;
1787: l_validate boolean;
1788: l_party_id per_all_people_f.party_id%type;
1789: --
1790: l_proc varchar2(72) := g_package||'delete_person';
1791: --
1792: begin

Line 1795: select party_id into l_party_id from per_all_people_f

1791: --
1792: begin
1793:
1794: -- Fetch party Id for the TCA bug 3945358
1795: select party_id into l_party_id from per_all_people_f
1796: where person_id = p_person_id and rownum =1;
1797: --
1798:
1799: -- added for bug 7369431