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.

[Home] [Help]

APPS.GHR_MASS_SEL_NOA dependencies on PER_PEOPLE_F

Line 52: l_name per_people_f.full_name%TYPE;

48: (p_person_id IN number
49: , p_effective_date IN date
50: , p_first_noa_code IN varchar2) RETURN boolean IS
51:
52: l_name per_people_f.full_name%TYPE;
53: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;
54: l_employee_number per_people_f.employee_number%TYPE;
55:
56: CURSOR csr_action_taken IS

Line 54: l_employee_number per_people_f.employee_number%TYPE;

50: , p_first_noa_code IN varchar2) RETURN boolean IS
51:
52: l_name per_people_f.full_name%TYPE;
53: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;
54: l_employee_number per_people_f.employee_number%TYPE;
55:
56: CURSOR csr_action_taken IS
57: SELECT pr.pa_request_id
58: , max (pa_routing_history_id) pa_routing_history_id

Line 313: , p_person_id IN per_people_f.person_id%TYPE

309:
310: PROCEDURE refresh_ei_details
311: (p_noa_action IN ghr_pa_requests.first_noa_code%TYPE
312: , p_effective_date IN date
313: , p_person_id IN per_people_f.person_id%TYPE
314: , p_work_schedule IN ghr_pa_requests.work_schedule%TYPE
315: , p_pa_request_id IN ghr_pa_requests.pa_request_id%TYPE) IS
316:
317: l_proc varchar2(72);

Line 582: , p_full_name IN per_people_f.full_name%TYPE

578: PROCEDURE fetch_and_validate_emp
579: (p_action IN varchar2
580: , p_mass_salary_id IN number
581: , p_mass_salary_name IN varchar2
582: , p_full_name IN per_people_f.full_name%TYPE
583: , p_national_identifier IN per_people_f.national_identifier%TYPE
584: , p_employee_number IN per_people_f.employee_number%TYPE
585: , p_assignment_id IN per_assignments_f.assignment_id%TYPE
586: , p_person_id IN per_assignments_f.person_id%TYPE

Line 583: , p_national_identifier IN per_people_f.national_identifier%TYPE

579: (p_action IN varchar2
580: , p_mass_salary_id IN number
581: , p_mass_salary_name IN varchar2
582: , p_full_name IN per_people_f.full_name%TYPE
583: , p_national_identifier IN per_people_f.national_identifier%TYPE
584: , p_employee_number IN per_people_f.employee_number%TYPE
585: , p_assignment_id IN per_assignments_f.assignment_id%TYPE
586: , p_person_id IN per_assignments_f.person_id%TYPE
587: , p_position_id IN per_assignments_f.position_id%TYPE

Line 584: , p_employee_number IN per_people_f.employee_number%TYPE

580: , p_mass_salary_id IN number
581: , p_mass_salary_name IN varchar2
582: , p_full_name IN per_people_f.full_name%TYPE
583: , p_national_identifier IN per_people_f.national_identifier%TYPE
584: , p_employee_number IN per_people_f.employee_number%TYPE
585: , p_assignment_id IN per_assignments_f.assignment_id%TYPE
586: , p_person_id IN per_assignments_f.person_id%TYPE
587: , p_position_id IN per_assignments_f.position_id%TYPE
588: , p_grade_id IN per_assignments_f.grade_id%TYPE

Line 1633: , per_people_f ppf

1629: , paf.organization_id organization_id
1630: , paf.business_group_id business_group_id
1631: , paf.assignment_status_type_id assignment_status_type_id
1632: FROM per_assignments_f paf
1633: , per_people_f ppf
1634: , per_person_types ppt
1635: , hr_organization_units hou
1636: , per_assignment_status_types past
1637: WHERE ppf.person_id = paf.person_id

Line 1676: , per_people_f ppf

1672: , paf.organization_id organization_id
1673: , paf.business_group_id business_group_id
1674: , paf.assignment_status_type_id assignment_status_type_id
1675: FROM per_assignments_f paf
1676: , per_people_f ppf
1677: , per_person_types ppt
1678: , hr_organization_units hou
1679: , per_assignment_status_types past
1680: WHERE ppf.person_id = paf.person_id

Line 1716: , per_people_f ppf

1712: , paf.organization_id organization_id
1713: , paf.business_group_id business_group_id
1714: , paf.assignment_status_type_id assignment_status_type_id
1715: FROM per_assignments_f paf
1716: , per_people_f ppf
1717: , per_person_types ppt
1718: , hr_organization_units hou
1719: , per_assignment_status_types past
1720: WHERE ppf.person_id = paf.person_id

Line 1756: , per_people_f ppf

1752: , paf.organization_id organization_id
1753: , paf.business_group_id business_group_id
1754: , paf.assignment_status_type_id assignment_status_type_id
1755: FROM per_assignments_f paf
1756: , per_people_f ppf
1757: , per_person_types ppt
1758: , hr_organization_units hou
1759: , per_assignment_status_types past
1760: WHERE ppf.person_id = paf.person_id

Line 1796: , per_people_f ppf

1792: , paf.organization_id organization_id
1793: , paf.business_group_id business_group_id
1794: , paf.assignment_status_type_id assignment_status_type_id
1795: FROM per_assignments_f paf
1796: , per_people_f ppf
1797: , per_person_types ppt
1798: , hr_organization_units hou
1799: , per_assignment_status_types past
1800: WHERE ppf.person_id = paf.person_id

Line 1836: , per_people_f ppf

1832: , paf.organization_id organization_id
1833: , paf.business_group_id business_group_id
1834: , paf.assignment_status_type_id assignment_status_type_id
1835: FROM per_assignments_f paf
1836: , per_people_f ppf
1837: , per_person_types ppt
1838: , hr_organization_units hou
1839: , per_assignment_status_types past
1840: WHERE ppf.person_id = paf.person_id

Line 1877: , per_people_f ppf

1873: , paf.organization_id organization_id
1874: , paf.business_group_id business_group_id
1875: , paf.assignment_status_type_id assignment_status_type_id
1876: FROM per_assignments_f paf
1877: , per_people_f ppf
1878: , per_person_types ppt
1879: , hr_organization_units hou
1880: WHERE ppf.person_id = paf.person_id
1881: AND l_effective_date

Line 1922: FROM per_people_f p, per_assignments_f a

1918: and pop.organization_id = punits.organization_id
1919: and not exists
1920: (
1921: SELECT 'X'
1922: FROM per_people_f p, per_assignments_f a
1923: WHERE trunc(effective_date) between a.effective_start_date and a.effective_end_date
1924: AND a.primary_flag = 'Y'
1925: AND a.assignment_type <> 'B'
1926: AND p.current_employee_flag = 'Y'

Line 2009: , p_first_name IN per_people_f.first_name%TYPE

2005: , p_business_group_id IN per_assignments_f.business_group_id%TYPE
2006: , p_location_id IN per_assignments_f.location_id%TYPE
2007: , p_organization_id IN per_assignments_f.organization_id%TYPE
2008: , p_date_of_birth IN date
2009: , p_first_name IN per_people_f.first_name%TYPE
2010: , p_last_name IN per_people_f.last_name%TYPE
2011: , p_full_name IN per_people_f.full_name%TYPE
2012: , p_middle_names IN per_people_f.middle_names%TYPE
2013: , p_national_identifier IN per_people_f.national_identifier%TYPE

Line 2010: , p_last_name IN per_people_f.last_name%TYPE

2006: , p_location_id IN per_assignments_f.location_id%TYPE
2007: , p_organization_id IN per_assignments_f.organization_id%TYPE
2008: , p_date_of_birth IN date
2009: , p_first_name IN per_people_f.first_name%TYPE
2010: , p_last_name IN per_people_f.last_name%TYPE
2011: , p_full_name IN per_people_f.full_name%TYPE
2012: , p_middle_names IN per_people_f.middle_names%TYPE
2013: , p_national_identifier IN per_people_f.national_identifier%TYPE
2014: , p_employee_number IN per_people_f.employee_number%TYPE

Line 2011: , p_full_name IN per_people_f.full_name%TYPE

2007: , p_organization_id IN per_assignments_f.organization_id%TYPE
2008: , p_date_of_birth IN date
2009: , p_first_name IN per_people_f.first_name%TYPE
2010: , p_last_name IN per_people_f.last_name%TYPE
2011: , p_full_name IN per_people_f.full_name%TYPE
2012: , p_middle_names IN per_people_f.middle_names%TYPE
2013: , p_national_identifier IN per_people_f.national_identifier%TYPE
2014: , p_employee_number IN per_people_f.employee_number%TYPE
2015: , p_personnel_office_id IN varchar2

Line 2012: , p_middle_names IN per_people_f.middle_names%TYPE

2008: , p_date_of_birth IN date
2009: , p_first_name IN per_people_f.first_name%TYPE
2010: , p_last_name IN per_people_f.last_name%TYPE
2011: , p_full_name IN per_people_f.full_name%TYPE
2012: , p_middle_names IN per_people_f.middle_names%TYPE
2013: , p_national_identifier IN per_people_f.national_identifier%TYPE
2014: , p_employee_number IN per_people_f.employee_number%TYPE
2015: , p_personnel_office_id IN varchar2
2016: , p_org_structure_id IN varchar2

Line 2013: , p_national_identifier IN per_people_f.national_identifier%TYPE

2009: , p_first_name IN per_people_f.first_name%TYPE
2010: , p_last_name IN per_people_f.last_name%TYPE
2011: , p_full_name IN per_people_f.full_name%TYPE
2012: , p_middle_names IN per_people_f.middle_names%TYPE
2013: , p_national_identifier IN per_people_f.national_identifier%TYPE
2014: , p_employee_number IN per_people_f.employee_number%TYPE
2015: , p_personnel_office_id IN varchar2
2016: , p_org_structure_id IN varchar2
2017: , p_position_title IN varchar2

Line 2014: , p_employee_number IN per_people_f.employee_number%TYPE

2010: , p_last_name IN per_people_f.last_name%TYPE
2011: , p_full_name IN per_people_f.full_name%TYPE
2012: , p_middle_names IN per_people_f.middle_names%TYPE
2013: , p_national_identifier IN per_people_f.national_identifier%TYPE
2014: , p_employee_number IN per_people_f.employee_number%TYPE
2015: , p_personnel_office_id IN varchar2
2016: , p_org_structure_id IN varchar2
2017: , p_position_title IN varchar2
2018: , p_position_number IN varchar2

Line 2464: , p_first_name IN per_people_f.first_name%TYPE

2460: , p_business_group_id IN per_assignments_f.business_group_id%TYPE
2461: , p_location_id IN per_assignments_f.location_id%TYPE
2462: , p_organization_id IN per_assignments_f.organization_id%TYPE
2463: , p_date_of_birth IN date
2464: , p_first_name IN per_people_f.first_name%TYPE
2465: , p_last_name IN per_people_f.last_name%TYPE
2466: , p_full_name IN per_people_f.full_name%TYPE
2467: , p_middle_names IN per_people_f.middle_names%TYPE
2468: , p_national_identifier IN per_people_f.national_identifier%TYPE

Line 2465: , p_last_name IN per_people_f.last_name%TYPE

2461: , p_location_id IN per_assignments_f.location_id%TYPE
2462: , p_organization_id IN per_assignments_f.organization_id%TYPE
2463: , p_date_of_birth IN date
2464: , p_first_name IN per_people_f.first_name%TYPE
2465: , p_last_name IN per_people_f.last_name%TYPE
2466: , p_full_name IN per_people_f.full_name%TYPE
2467: , p_middle_names IN per_people_f.middle_names%TYPE
2468: , p_national_identifier IN per_people_f.national_identifier%TYPE
2469: , p_employee_number IN per_people_f.employee_number%TYPE

Line 2466: , p_full_name IN per_people_f.full_name%TYPE

2462: , p_organization_id IN per_assignments_f.organization_id%TYPE
2463: , p_date_of_birth IN date
2464: , p_first_name IN per_people_f.first_name%TYPE
2465: , p_last_name IN per_people_f.last_name%TYPE
2466: , p_full_name IN per_people_f.full_name%TYPE
2467: , p_middle_names IN per_people_f.middle_names%TYPE
2468: , p_national_identifier IN per_people_f.national_identifier%TYPE
2469: , p_employee_number IN per_people_f.employee_number%TYPE
2470: , p_personnel_office_id IN varchar2

Line 2467: , p_middle_names IN per_people_f.middle_names%TYPE

2463: , p_date_of_birth IN date
2464: , p_first_name IN per_people_f.first_name%TYPE
2465: , p_last_name IN per_people_f.last_name%TYPE
2466: , p_full_name IN per_people_f.full_name%TYPE
2467: , p_middle_names IN per_people_f.middle_names%TYPE
2468: , p_national_identifier IN per_people_f.national_identifier%TYPE
2469: , p_employee_number IN per_people_f.employee_number%TYPE
2470: , p_personnel_office_id IN varchar2
2471: , p_org_structure_id IN varchar2

Line 2468: , p_national_identifier IN per_people_f.national_identifier%TYPE

2464: , p_first_name IN per_people_f.first_name%TYPE
2465: , p_last_name IN per_people_f.last_name%TYPE
2466: , p_full_name IN per_people_f.full_name%TYPE
2467: , p_middle_names IN per_people_f.middle_names%TYPE
2468: , p_national_identifier IN per_people_f.national_identifier%TYPE
2469: , p_employee_number IN per_people_f.employee_number%TYPE
2470: , p_personnel_office_id IN varchar2
2471: , p_org_structure_id IN varchar2
2472: , p_position_title IN varchar2

Line 2469: , p_employee_number IN per_people_f.employee_number%TYPE

2465: , p_last_name IN per_people_f.last_name%TYPE
2466: , p_full_name IN per_people_f.full_name%TYPE
2467: , p_middle_names IN per_people_f.middle_names%TYPE
2468: , p_national_identifier IN per_people_f.national_identifier%TYPE
2469: , p_employee_number IN per_people_f.employee_number%TYPE
2470: , p_personnel_office_id IN varchar2
2471: , p_org_structure_id IN varchar2
2472: , p_position_title IN varchar2
2473: , p_position_number IN varchar2

Line 4365: l_name per_people_f.full_name%TYPE;

4361: l_rowid varchar2(30);
4362: l_pa_rowid varchar2(30);
4363: l_pa_request_id number;
4364: l_can_pa_request_id number;
4365: l_name per_people_f.full_name%TYPE;
4366: l_employee_number per_people_f.employee_number%TYPE;
4367: l_total_recs number DEFAULT 0;
4368: l_recs_failed number DEFAULT 0;
4369: l_pa_req_rec ghr_pa_requests%ROWTYPE;

Line 4366: l_employee_number per_people_f.employee_number%TYPE;

4362: l_pa_rowid varchar2(30);
4363: l_pa_request_id number;
4364: l_can_pa_request_id number;
4365: l_name per_people_f.full_name%TYPE;
4366: l_employee_number per_people_f.employee_number%TYPE;
4367: l_total_recs number DEFAULT 0;
4368: l_recs_failed number DEFAULT 0;
4369: l_pa_req_rec ghr_pa_requests%ROWTYPE;
4370: l_effective_date date;

Line 4377: p_full_name per_people_f.full_name%TYPE;

4373: l_ovn number;
4374: l_lac_sf52_rec ghr_pa_requests%ROWTYPE;
4375: l_errbuf varchar2(2000);
4376: l_retcode number;
4377: p_full_name per_people_f.full_name%TYPE;
4378: p_employee_number per_people_f.employee_number%TYPE;
4379: l_routing_group_id ghr_pa_requests.routing_group_id%TYPE;
4380: l_groupbox_id ghr_groupboxes.groupbox_id%TYPE;
4381: l_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%TYPE;

Line 4378: p_employee_number per_people_f.employee_number%TYPE;

4374: l_lac_sf52_rec ghr_pa_requests%ROWTYPE;
4375: l_errbuf varchar2(2000);
4376: l_retcode number;
4377: p_full_name per_people_f.full_name%TYPE;
4378: p_employee_number per_people_f.employee_number%TYPE;
4379: l_routing_group_id ghr_pa_requests.routing_group_id%TYPE;
4380: l_groupbox_id ghr_groupboxes.groupbox_id%TYPE;
4381: l_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%TYPE;
4382: l_prh_object_version_number ghr_pa_routing_history.object_version_number%TYPE;

Line 4387: l_personnel_officer_name per_people_f.full_name%TYPE;

4383: l_u_prh_object_version_number number;
4384: l_i_pa_routing_history_id number;
4385: l_i_prh_object_version_number number;
4386: l_object_version_number ghr_pa_requests.object_version_number%TYPE;
4387: l_personnel_officer_name per_people_f.full_name%TYPE;
4388: l_approving_off_work_title ghr_pa_requests.approving_official_work_title%TYPE;
4389: rec_busy EXCEPTION;
4390: PRAGMA EXCEPTION_INIT(rec_busy, -54);
4391: l_proc varchar2(72) DEFAULT 'GHR_MASS_CANCEL.'|| '.execute_mcancel';

Line 4444: FROM per_people_f

4440: (p_person_id IN number
4441: , p_effective_date IN date) IS
4442: SELECT full_name
4443: , employee_number
4444: FROM per_people_f
4445: WHERE person_id = p_person_id
4446: AND p_effective_date
4447: BETWEEN effective_start_date
4448: AND effective_end_date;