eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 2121: l_party_id per_all_people_f.party_id%type;

2117: --
2118:
2119: l_effective_date date;
2120: l_validate boolean;
2121: l_party_id per_all_people_f.party_id%type;
2122: --
2123: l_proc varchar2(72) := g_package||'delete_person';
2124: --
2125: begin

Line 2128: select party_id into l_party_id from per_all_people_f

2124: --
2125: begin
2126:
2127: -- Fetch party Id for the TCA bug 3945358
2128: select party_id into l_party_id from per_all_people_f
2129: where person_id = p_person_id and rownum =1;
2130: --
2131:
2132: -- added for bug 7369431

Line 2708: FROM per_all_people_f per,

2704: AND c_apl_ass_start_date BETWEEN effective_start_date AND effective_end_date;
2705:
2706: CURSOR csr_sys_person_type(c_person_id NUMBER) IS
2707: SELECT pet.system_person_type
2708: FROM per_all_people_f per,
2709: per_person_types pet
2710: WHERE per.person_type_id = pet.person_type_id
2711: AND per.person_id = c_person_id
2712: AND trunc(sysdate) BETWEEN per.effective_start_date AND per.effective_end_date;

Line 2793: FROM per_all_people_f

2789: CLOSE csr_sys_person_type;
2790:
2791: SELECT business_group_id
2792: INTO l_bg_id
2793: FROM per_all_people_f
2794: WHERE person_id = p_source_person_id
2795: AND effective_start_date = start_date;
2796:
2797: BEGIN

Line 2904: FROM per_all_people_f

2900: end if;
2901:
2902: SELECT start_date,party_id
2903: INTO l_t_start_date,l_t_party_id
2904: FROM per_all_people_f
2905: WHERE person_id = p_target_person_id
2906: AND effective_start_date = start_date;
2907:
2908:

Line 3530: l_effective_start_date per_all_people_f.effective_start_date%TYPE;

3526: end if;
3527:
3528: DECLARE
3529: l_object_version_number NUMBER;
3530: l_effective_start_date per_all_people_f.effective_start_date%TYPE;
3531: l_effective_end_date per_all_people_f.effective_end_date%TYPE;
3532: l_person_org_manager_warning VARCHAR2(1000);
3533: BEGIN
3534: IF p_term_or_purge_s = 'TERM' THEN

Line 3531: l_effective_end_date per_all_people_f.effective_end_date%TYPE;

3527:
3528: DECLARE
3529: l_object_version_number NUMBER;
3530: l_effective_start_date per_all_people_f.effective_start_date%TYPE;
3531: l_effective_end_date per_all_people_f.effective_end_date%TYPE;
3532: l_person_org_manager_warning VARCHAR2(1000);
3533: BEGIN
3534: IF p_term_or_purge_s = 'TERM' THEN
3535: hr_applicant_api.Terminate_applicant(p_validate => false,

Line 3583: select person_id,business_group_id from per_all_people_f

3579: ,p_term_or_purge_s in varchar2 default null
3580: ,p_create_new_application in varchar2 default 'Y') is
3581:
3582: cursor c_get_per_details(c_party_id number) is
3583: select person_id,business_group_id from per_all_people_f
3584: where party_id=c_party_id;
3585:
3586: l_t_person_id number;
3587: l_t_bg_id number;

Line 3621: from per_all_people_f

3617: -- if not, update the party_id of source person with target party_id.
3618:
3619: select distinct person_id,business_group_id
3620: into l_t_person_id,l_t_bg_id
3621: from per_all_people_f
3622: where party_id=p_target_party_id
3623: and business_group_id=s_per_det.business_group_id;
3624:
3625:

Line 3639: update per_all_people_f paaf

3635: if g_debug then
3636: hr_utility.set_location(l_proc, 7);
3637: end if;
3638:
3639: update per_all_people_f paaf
3640: set party_id=p_target_party_id
3641: where party_id=p_source_party_id
3642: and not exists(select 1 from per_all_people_f
3643: where business_group_id=paaf.business_group_id

Line 3642: and not exists(select 1 from per_all_people_f

3638:
3639: update per_all_people_f paaf
3640: set party_id=p_target_party_id
3641: where party_id=p_source_party_id
3642: and not exists(select 1 from per_all_people_f
3643: where business_group_id=paaf.business_group_id
3644: and party_id=p_target_party_id);
3645:
3646: if p_validate then