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.GHR_PA_REQUESTS_PKG dependencies on PER_PEOPLE_F

Line 200: p_person_id per_people_f.person_id%TYPE

196:
197: END get_routing_group_name;
198:
199: FUNCTION get_full_name(
200: p_person_id per_people_f.person_id%TYPE
201: ,p_effective_date date)
202: RETURN VARCHAR2 IS
203: l_ret_val VARCHAR2(240) := NULL;
204: -- last name is 40 long, first name is 20 long and middles names is 60 long

Line 209: FROM per_people_f per

205: -- therfore plus ',' and ' ' max length is 122!
206:
207: CURSOR cur_per IS
208: SELECT per.last_name||','|| per.first_name||' '|| per.middle_names full_name
209: FROM per_people_f per
210: WHERE per.person_id = p_person_id
211: AND NVL(p_effective_date,TRUNC(sysdate)) between per.effective_start_date and per.effective_end_date;
212:
213: BEGIN

Line 224: p_person_id per_people_f.person_id%TYPE

220: END get_full_name;
221:
222:
223: FUNCTION get_full_name_unsecure(
224: p_person_id per_people_f.person_id%TYPE
225: ,p_effective_date date )
226: RETURN VARCHAR2 IS
227: l_ret_val VARCHAR2(240):=NULL;
228:

Line 620: PROCEDURE get_person_details (p_person_id IN per_people_f.person_id%TYPE

616: RAISE;
617:
618: END get_roles;
619:
620: PROCEDURE get_person_details (p_person_id IN per_people_f.person_id%TYPE
621: ,p_effective_date IN DATE
622: ,p_national_identifier IN OUT NOCOPY per_people_f.national_identifier%TYPE
623: ,p_date_of_birth IN OUT NOCOPY per_people_f.date_of_birth%TYPE
624: ,p_last_name IN OUT NOCOPY per_people_f.last_name%TYPE

Line 622: ,p_national_identifier IN OUT NOCOPY per_people_f.national_identifier%TYPE

618: END get_roles;
619:
620: PROCEDURE get_person_details (p_person_id IN per_people_f.person_id%TYPE
621: ,p_effective_date IN DATE
622: ,p_national_identifier IN OUT NOCOPY per_people_f.national_identifier%TYPE
623: ,p_date_of_birth IN OUT NOCOPY per_people_f.date_of_birth%TYPE
624: ,p_last_name IN OUT NOCOPY per_people_f.last_name%TYPE
625: ,p_first_name IN OUT NOCOPY per_people_f.first_name%TYPE
626: ,p_middle_names IN OUT NOCOPY per_people_f.middle_names%TYPE) IS

Line 623: ,p_date_of_birth IN OUT NOCOPY per_people_f.date_of_birth%TYPE

619:
620: PROCEDURE get_person_details (p_person_id IN per_people_f.person_id%TYPE
621: ,p_effective_date IN DATE
622: ,p_national_identifier IN OUT NOCOPY per_people_f.national_identifier%TYPE
623: ,p_date_of_birth IN OUT NOCOPY per_people_f.date_of_birth%TYPE
624: ,p_last_name IN OUT NOCOPY per_people_f.last_name%TYPE
625: ,p_first_name IN OUT NOCOPY per_people_f.first_name%TYPE
626: ,p_middle_names IN OUT NOCOPY per_people_f.middle_names%TYPE) IS
627:

Line 624: ,p_last_name IN OUT NOCOPY per_people_f.last_name%TYPE

620: PROCEDURE get_person_details (p_person_id IN per_people_f.person_id%TYPE
621: ,p_effective_date IN DATE
622: ,p_national_identifier IN OUT NOCOPY per_people_f.national_identifier%TYPE
623: ,p_date_of_birth IN OUT NOCOPY per_people_f.date_of_birth%TYPE
624: ,p_last_name IN OUT NOCOPY per_people_f.last_name%TYPE
625: ,p_first_name IN OUT NOCOPY per_people_f.first_name%TYPE
626: ,p_middle_names IN OUT NOCOPY per_people_f.middle_names%TYPE) IS
627:
628: l_national_identifier per_people_f.national_identifier%TYPE;

Line 625: ,p_first_name IN OUT NOCOPY per_people_f.first_name%TYPE

621: ,p_effective_date IN DATE
622: ,p_national_identifier IN OUT NOCOPY per_people_f.national_identifier%TYPE
623: ,p_date_of_birth IN OUT NOCOPY per_people_f.date_of_birth%TYPE
624: ,p_last_name IN OUT NOCOPY per_people_f.last_name%TYPE
625: ,p_first_name IN OUT NOCOPY per_people_f.first_name%TYPE
626: ,p_middle_names IN OUT NOCOPY per_people_f.middle_names%TYPE) IS
627:
628: l_national_identifier per_people_f.national_identifier%TYPE;
629: l_date_of_birth per_people_f.date_of_birth%TYPE;

Line 626: ,p_middle_names IN OUT NOCOPY per_people_f.middle_names%TYPE) IS

622: ,p_national_identifier IN OUT NOCOPY per_people_f.national_identifier%TYPE
623: ,p_date_of_birth IN OUT NOCOPY per_people_f.date_of_birth%TYPE
624: ,p_last_name IN OUT NOCOPY per_people_f.last_name%TYPE
625: ,p_first_name IN OUT NOCOPY per_people_f.first_name%TYPE
626: ,p_middle_names IN OUT NOCOPY per_people_f.middle_names%TYPE) IS
627:
628: l_national_identifier per_people_f.national_identifier%TYPE;
629: l_date_of_birth per_people_f.date_of_birth%TYPE;
630: l_last_name per_people_f.last_name%TYPE;

Line 628: l_national_identifier per_people_f.national_identifier%TYPE;

624: ,p_last_name IN OUT NOCOPY per_people_f.last_name%TYPE
625: ,p_first_name IN OUT NOCOPY per_people_f.first_name%TYPE
626: ,p_middle_names IN OUT NOCOPY per_people_f.middle_names%TYPE) IS
627:
628: l_national_identifier per_people_f.national_identifier%TYPE;
629: l_date_of_birth per_people_f.date_of_birth%TYPE;
630: l_last_name per_people_f.last_name%TYPE;
631: l_first_name per_people_f.first_name%TYPE;
632: l_middle_names per_people_f.middle_names%TYPE;

Line 629: l_date_of_birth per_people_f.date_of_birth%TYPE;

625: ,p_first_name IN OUT NOCOPY per_people_f.first_name%TYPE
626: ,p_middle_names IN OUT NOCOPY per_people_f.middle_names%TYPE) IS
627:
628: l_national_identifier per_people_f.national_identifier%TYPE;
629: l_date_of_birth per_people_f.date_of_birth%TYPE;
630: l_last_name per_people_f.last_name%TYPE;
631: l_first_name per_people_f.first_name%TYPE;
632: l_middle_names per_people_f.middle_names%TYPE;
633:

Line 630: l_last_name per_people_f.last_name%TYPE;

626: ,p_middle_names IN OUT NOCOPY per_people_f.middle_names%TYPE) IS
627:
628: l_national_identifier per_people_f.national_identifier%TYPE;
629: l_date_of_birth per_people_f.date_of_birth%TYPE;
630: l_last_name per_people_f.last_name%TYPE;
631: l_first_name per_people_f.first_name%TYPE;
632: l_middle_names per_people_f.middle_names%TYPE;
633:
634: CURSOR cur_per IS

Line 631: l_first_name per_people_f.first_name%TYPE;

627:
628: l_national_identifier per_people_f.national_identifier%TYPE;
629: l_date_of_birth per_people_f.date_of_birth%TYPE;
630: l_last_name per_people_f.last_name%TYPE;
631: l_first_name per_people_f.first_name%TYPE;
632: l_middle_names per_people_f.middle_names%TYPE;
633:
634: CURSOR cur_per IS
635: SELECT per.national_identifier

Line 632: l_middle_names per_people_f.middle_names%TYPE;

628: l_national_identifier per_people_f.national_identifier%TYPE;
629: l_date_of_birth per_people_f.date_of_birth%TYPE;
630: l_last_name per_people_f.last_name%TYPE;
631: l_first_name per_people_f.first_name%TYPE;
632: l_middle_names per_people_f.middle_names%TYPE;
633:
634: CURSOR cur_per IS
635: SELECT per.national_identifier
636: ,per.date_of_birth

Line 640: FROM per_people_f per

636: ,per.date_of_birth
637: ,per.last_name
638: ,per.first_name
639: ,per.middle_names
640: FROM per_people_f per
641: WHERE per.person_id = p_person_id
642: AND NVL(p_effective_date,TRUNC(sysdate)) between per.effective_start_date and per.effective_end_date;
643:
644: BEGIN

Line 710: PROCEDURE get_SF52_person_ddf_details (p_person_id IN per_people_f.person_id%TYPE

706:
707: END get_duty_station_details;
708: --
709: --
710: PROCEDURE get_SF52_person_ddf_details (p_person_id IN per_people_f.person_id%TYPE
711: ,p_date_effective IN date default sysdate
712: ,p_citizenship OUT NOCOPY varchar2
713: ,p_veterans_preference OUT NOCOPY varchar2
714: ,p_veterans_pref_for_rif OUT NOCOPY varchar2

Line 1616: ,per_people_f per

1612: --Bug# 6711759 Included the person type EX_EMP_APL
1613: CURSOR c_per_app IS
1614: SELECT 1
1615: FROM per_person_types pet
1616: ,per_people_f per
1617: WHERE nvl(p_effective_date,trunc(sysdate)) between per.effective_start_date and per.effective_end_date
1618: AND pet.person_type_id = per.person_type_id
1619: AND pet.system_person_type in ('APL','EX_EMP','EX_EMP_APL')
1620: AND per.business_group_id = p_business_group_id

Line 1628: ,per_people_f per

1624: -- Bug 4217510/ 4377361 added person type EMP_APL also
1625: CURSOR c_per_emp IS
1626: SELECT 1
1627: FROM per_person_types pet
1628: ,per_people_f per
1629: WHERE nvl(p_effective_date,trunc(sysdate)) between per.effective_start_date and per.effective_end_date
1630: AND pet.person_type_id = per.person_type_id
1631: AND (pet.system_person_type in ('EMP', 'EMP_APL')
1632: OR (pet.system_person_type = 'EX_EMP' and p_noa_family_code = 'CONV_APP')

Line 1671: ,per_people_f per

1667: --
1668: CURSOR c_per_app IS
1669: SELECT 1
1670: FROM per_person_types pet
1671: ,per_people_f per
1672: WHERE nvl(p_effective_date,trunc(sysdate)) between per.effective_start_date and per.effective_end_date
1673: AND pet.person_type_id = per.person_type_id
1674: AND pet.system_person_type in ('APL','EX_EMP')
1675: AND per.business_group_id = p_business_group_id

Line 1683: ,per_people_f per

1679: -- Bug 4217510/4377361 added person type EMP_APL also
1680: CURSOR c_per_emp IS
1681: SELECT 1
1682: FROM per_person_types pet
1683: ,per_people_f per
1684: WHERE nvl(p_effective_date,trunc(sysdate)) between per.effective_start_date and per.effective_end_date
1685: AND pet.person_type_id = per.person_type_id
1686: AND (pet.system_person_type in ('EMP', 'EMP_APL')
1687: OR (pet.system_person_type = 'EX_EMP' and p_noa_family_code = 'CONV_APP')

Line 2002: l_name per_people_f.full_name%type;

1998: p_effective_date in date default trunc(sysdate)
1999: ) RETURN varchar2 IS
2000:
2001: l_proc varchar2(72) := 'get_person_full_name';
2002: l_name per_people_f.full_name%type;
2003:
2004: CURSOR c_full_name is
2005: SELECT per.first_name || decode(per.middle_names,null,null, ' ' ||substr(per.middle_names,1,1) || '.') || ' ' ||per.last_name full_name
2006: FROM per_people_f per

Line 2006: FROM per_people_f per

2002: l_name per_people_f.full_name%type;
2003:
2004: CURSOR c_full_name is
2005: SELECT per.first_name || decode(per.middle_names,null,null, ' ' ||substr(per.middle_names,1,1) || '.') || ' ' ||per.last_name full_name
2006: FROM per_people_f per
2007: WHERE per.person_id = p_person_id
2008: AND trunc(nvl(p_effective_date,sysdate))between per.effective_start_date and per.effective_end_date;
2009:
2010:

Line 2022: FUNCTION get_upd34_pay_basis (p_person_id IN per_people_f.person_id%TYPE

2018: hr_utility.set_location('Leaving ' || l_proc,15);
2019: return(l_name);
2020: END get_full_name_fml;
2021:
2022: FUNCTION get_upd34_pay_basis (p_person_id IN per_people_f.person_id%TYPE
2023: ,p_position_id IN per_positions.position_id%type
2024: ,p_prd IN ghr_pa_requests.pay_rate_determinant%TYPE
2025: ,p_noa_code IN varchar2 DEFAULT NULL
2026: ,p_pa_request_id IN NUMBER DEFAULT NULL