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_ASSIGNMENT_API dependencies on PER_ALL_PEOPLE_F

Line 256: from per_all_people_f

252: where business_group_id = p_business_group_id;
253:
254: cursor csr_chk_person_exists is
255: select 1
256: from per_all_people_f
257: where business_group_id = p_business_group_id
258: and person_id = p_person_id
259: and p_effective_date between effective_start_date and effective_end_date;
260:

Line 491: DELETE FROM per_all_people_f papf

487: hr_utility.set_location('Entering:'|| l_proc, 110);
488:
489: -- Maintain the Person data by deleting the Ex-Appl Record and the same with PTU Data.
490:
491: DELETE FROM per_all_people_f papf
492: WHERE papf.person_id = p_person_id
493: AND papf.business_group_id + 0 = p_Business_group_id
494: AND papf.effective_start_date > l_date_end;
495: --

Line 499: UPDATE per_all_people_f papf

495: --
496:
497: hr_utility.set_location('reverse_term_apln_fut - l_date_end:'|| l_date_end, 120);
498:
499: UPDATE per_all_people_f papf
500: SET papf.effective_end_date = l_eot
501: WHERE papf.person_id = p_person_id
502: AND papf.BUSINESS_GROUP_ID + 0 = p_Business_group_id
503: AND papf.effective_end_date = l_date_end;

Line 710: FROM PER_ALL_PEOPLE_F PAPF

706: and a.assignment_status_type_id = b.assignment_status_type_id) ;
707:
708: cursor c3(p_date_end date) is
709: SELECT 1
710: FROM PER_ALL_PEOPLE_F PAPF
711: WHERE PAPF.PERSON_ID = P_PERSON_ID
712: AND PAPF.EFFECTIVE_START_DATE > p_DATE_END + 1 ;
713:
714:

Line 734: from per_all_people_f

730: where business_group_id = p_business_group_id;
731:
732: cursor csr_chk_person_exists is
733: select 1
734: from per_all_people_f
735: where business_group_id = p_business_group_id
736: and person_id = p_person_id
737: and p_effective_date between effective_start_date and effective_end_date;
738:

Line 965: DELETE FROM per_all_people_f papf

961: hr_utility.set_location('Entering:'|| l_proc, 110);
962:
963: -- Maintain the Person data by deleting the Ex-Appl Record and the same with PTU Data.
964:
965: DELETE FROM per_all_people_f papf
966: WHERE papf.person_id = p_person_id
967: AND papf.business_group_id + 0 = p_Business_group_id
968: AND papf.effective_start_date = l_date_end + 1;
969: --

Line 973: UPDATE per_all_people_f papf

969: --
970:
971: hr_utility.set_location('REVERSE_TERM_APLN - l_date_end:'|| l_date_end, 120);
972:
973: UPDATE per_all_people_f papf
974: SET papf.effective_end_date = l_eot
975: WHERE papf.person_id = p_person_id
976: AND papf.BUSINESS_GROUP_ID + 0 = p_Business_group_id
977: AND papf.effective_end_date = l_date_end;

Line 5076: from per_all_people_f per

5072: --
5073: cursor csr_get_derived_details is
5074: select bus.business_group_id
5075: , bus.legislation_code
5076: from per_all_people_f per
5077: , per_business_groups_perf bus
5078: where per.person_id = p_person_id
5079: and l_effective_date between per.effective_start_date
5080: and per.effective_end_date

Line 6503: from per_all_people_f per

6499: --
6500: cursor csr_get_derived_details is
6501: select bus.business_group_id
6502: , bus.legislation_code
6503: from per_all_people_f per
6504: , per_business_groups_perf bus
6505: where per.person_id = p_person_id
6506: and l_effective_date between per.effective_start_date
6507: and per.effective_end_date

Line 20073: l_applicant_number per_all_people_f.applicant_number%TYPE;

20069: lv_cagr_grade_def_id number := p_cagr_grade_def_id ;
20070: lv_people_group_id number := p_people_group_id ;
20071: lv_soft_coding_keyflex_id number := p_people_group_id ;
20072: --
20073: l_applicant_number per_all_people_f.applicant_number%TYPE;
20074: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
20075: l_appl_override_warning boolean;
20076: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;
20077: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;

Line 20074: l_per_object_version_number per_all_people_f.object_version_number%TYPE;

20070: lv_people_group_id number := p_people_group_id ;
20071: lv_soft_coding_keyflex_id number := p_people_group_id ;
20072: --
20073: l_applicant_number per_all_people_f.applicant_number%TYPE;
20074: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
20075: l_appl_override_warning boolean;
20076: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;
20077: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;
20078: l_apl_object_version_number per_applications.object_version_number%TYPE;

Line 20076: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;

20072: --
20073: l_applicant_number per_all_people_f.applicant_number%TYPE;
20074: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
20075: l_appl_override_warning boolean;
20076: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;
20077: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;
20078: l_apl_object_version_number per_applications.object_version_number%TYPE;
20079: --
20080:

Line 20077: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;

20073: l_applicant_number per_all_people_f.applicant_number%TYPE;
20074: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
20075: l_appl_override_warning boolean;
20076: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;
20077: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;
20078: l_apl_object_version_number per_applications.object_version_number%TYPE;
20079: --
20080:
20081: cursor csr_get_derived_details is

Line 20085: from per_all_people_f per

20081: cursor csr_get_derived_details is
20082: select bus.business_group_id
20083: , bus.legislation_code
20084: , per.applicant_number, per.object_version_number --3652025
20085: from per_all_people_f per
20086: , per_business_groups_perf bus
20087: where per.person_id = p_person_id
20088: and l_effective_date between per.effective_start_date
20089: and per.effective_end_date

Line 22394: from per_all_assignments_f paf, fnd_user usr, per_all_people_f ppf,

22390: ,p_effective_date IN DATE
22391: )
22392: IS
22393: select user_id
22394: from per_all_assignments_f paf, fnd_user usr, per_all_people_f ppf,
22395: per_all_people_f linkppf
22396: where p_effective_date between paf.effective_start_date and
22397: paf.effective_end_date
22398: and p_effective_date between usr.start_date and

Line 22395: per_all_people_f linkppf

22391: )
22392: IS
22393: select user_id
22394: from per_all_assignments_f paf, fnd_user usr, per_all_people_f ppf,
22395: per_all_people_f linkppf
22396: where p_effective_date between paf.effective_start_date and
22397: paf.effective_end_date
22398: and p_effective_date between usr.start_date and
22399: nvl(usr.end_date,p_effective_date)

Line 22490: l_person_type_id per_all_people_f.person_type_id%type;

22486:
22487: l_emp_min_start_date per_all_assignments_f.effective_start_date%type;
22488: l_apl_min_start_date per_all_assignments_f.effective_start_date%type;
22489: l_ae_assignment_id per_all_assignments_f.assignment_id%type;
22490: l_person_type_id per_all_people_f.person_type_id%type;
22491: l_exists varchar2(10);
22492: -- Start changes for bug 9875744
22493:
22494: -- <<

Line 23250: ,p_person_id IN per_all_people_f.person_id%TYPE

23246: --
23247: PROCEDURE set_new_primary_asg
23248: (p_validate IN BOOLEAN
23249: ,p_effective_date IN DATE
23250: ,p_person_id IN per_all_people_f.person_id%TYPE
23251: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
23252: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
23253: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
23254: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE

Line 23304: (p_person_id IN per_all_people_f.person_id%TYPE

23300: ,pds.actual_termination_date;
23301: l_new_assignment csr_new_assignment%ROWTYPE;
23302: --
23303: CURSOR csr_old_assignment
23304: (p_person_id IN per_all_people_f.person_id%TYPE
23305: ,p_effective_date IN DATE
23306: )
23307: IS
23308: SELECT asg.assignment_id

Line 23593: ,p_person_id IN per_all_people_f.person_id%TYPE

23589: --
23590: PROCEDURE set_new_primary_cwk_asg
23591: (p_validate IN BOOLEAN
23592: ,p_effective_date IN DATE
23593: ,p_person_id IN per_all_people_f.person_id%TYPE
23594: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
23595: ,p_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
23596: ,p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
23597: ,p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE

Line 23645: (p_person_id IN per_all_people_f.person_id%TYPE

23641: ,asg.effective_end_date
23642: ,pop.actual_termination_date;
23643: --
23644: CURSOR csr_old_assignment
23645: (p_person_id IN per_all_people_f.person_id%TYPE
23646: ,p_effective_date IN DATE) IS
23647: SELECT asg.assignment_id
23648: ,asg.assignment_type
23649: ,asg.period_of_placement_date_start