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.PA_UTILS dependencies on PER_ALL_PEOPLE_F

Line 7: L_PERSON_ID per_all_people_f.person_id%TYPE;

3: -- ==========================================================================
4: -- Added for bug 5067511 : These global variables should be only used in the
5: -- function GetPersonInfo
6: -- ==========================================================================
7: L_PERSON_ID per_all_people_f.person_id%TYPE;
8: L_PERSON_FULL_NAME per_all_people_f.full_name%TYPE;
9: L_PERSON_LAST_NAME per_all_people_f.last_name%TYPE;
10: L_PERSON_FIRST_NAME per_all_people_f.first_name%TYPE;
11: L_PERSON_MIDDLE_NAMES per_all_people_f.middle_names%TYPE;

Line 8: L_PERSON_FULL_NAME per_all_people_f.full_name%TYPE;

4: -- Added for bug 5067511 : These global variables should be only used in the
5: -- function GetPersonInfo
6: -- ==========================================================================
7: L_PERSON_ID per_all_people_f.person_id%TYPE;
8: L_PERSON_FULL_NAME per_all_people_f.full_name%TYPE;
9: L_PERSON_LAST_NAME per_all_people_f.last_name%TYPE;
10: L_PERSON_FIRST_NAME per_all_people_f.first_name%TYPE;
11: L_PERSON_MIDDLE_NAMES per_all_people_f.middle_names%TYPE;
12: L_PERSON_EMPLOYEE_NUMBER per_all_people_f.employee_number%TYPE;

Line 9: L_PERSON_LAST_NAME per_all_people_f.last_name%TYPE;

5: -- function GetPersonInfo
6: -- ==========================================================================
7: L_PERSON_ID per_all_people_f.person_id%TYPE;
8: L_PERSON_FULL_NAME per_all_people_f.full_name%TYPE;
9: L_PERSON_LAST_NAME per_all_people_f.last_name%TYPE;
10: L_PERSON_FIRST_NAME per_all_people_f.first_name%TYPE;
11: L_PERSON_MIDDLE_NAMES per_all_people_f.middle_names%TYPE;
12: L_PERSON_EMPLOYEE_NUMBER per_all_people_f.employee_number%TYPE;
13:

Line 10: L_PERSON_FIRST_NAME per_all_people_f.first_name%TYPE;

6: -- ==========================================================================
7: L_PERSON_ID per_all_people_f.person_id%TYPE;
8: L_PERSON_FULL_NAME per_all_people_f.full_name%TYPE;
9: L_PERSON_LAST_NAME per_all_people_f.last_name%TYPE;
10: L_PERSON_FIRST_NAME per_all_people_f.first_name%TYPE;
11: L_PERSON_MIDDLE_NAMES per_all_people_f.middle_names%TYPE;
12: L_PERSON_EMPLOYEE_NUMBER per_all_people_f.employee_number%TYPE;
13:
14: -- ==========================================================================

Line 11: L_PERSON_MIDDLE_NAMES per_all_people_f.middle_names%TYPE;

7: L_PERSON_ID per_all_people_f.person_id%TYPE;
8: L_PERSON_FULL_NAME per_all_people_f.full_name%TYPE;
9: L_PERSON_LAST_NAME per_all_people_f.last_name%TYPE;
10: L_PERSON_FIRST_NAME per_all_people_f.first_name%TYPE;
11: L_PERSON_MIDDLE_NAMES per_all_people_f.middle_names%TYPE;
12: L_PERSON_EMPLOYEE_NUMBER per_all_people_f.employee_number%TYPE;
13:
14: -- ==========================================================================
15: -- = PROCEDURE GetProjInfo

Line 12: L_PERSON_EMPLOYEE_NUMBER per_all_people_f.employee_number%TYPE;

8: L_PERSON_FULL_NAME per_all_people_f.full_name%TYPE;
9: L_PERSON_LAST_NAME per_all_people_f.last_name%TYPE;
10: L_PERSON_FIRST_NAME per_all_people_f.first_name%TYPE;
11: L_PERSON_MIDDLE_NAMES per_all_people_f.middle_names%TYPE;
12: L_PERSON_EMPLOYEE_NUMBER per_all_people_f.employee_number%TYPE;
13:
14: -- ==========================================================================
15: -- = PROCEDURE GetProjInfo
16: -- ==========================================================================

Line 2002: FUNCTION GetPersonInfo( p_person_id IN per_all_people_f.person_id%TYPE,

1998: -- found or invalid l_data
1999: -- This Function Can also be used whenever pa_employees is not scanned by index and we want to force index scan on pa_employees view.
2000: -- ==========================================================================
2001:
2002: FUNCTION GetPersonInfo( p_person_id IN per_all_people_f.person_id%TYPE,
2003: p_data IN VARCHAR2 DEFAULT 'PERSON_ID') RETURN VARCHAR2
2004: IS
2005: BEGIN
2006: If NVL(L_PERSON_ID, 0) <> p_person_id Then