APPS.PQH_PQHUSUCE_XMLP_PKG dependencies on PQH_TENURE_DETAIL

Line 21: L_MANAGER_ID := PQH_TENURE_DETAIL.GETPERSONSUPERVISOR(P_PERSON_ID);

17: L_MANAGER_ID NUMBER;
18: BEGIN
19: --HR_STANDARD.EVENT('BEFORE REPORT');
20: CP_BUSINESS_GROUP_NAME := GET_BUSINESS_GROUP(P_BUSINESS_GROUP_ID);
21: L_MANAGER_ID := PQH_TENURE_DETAIL.GETPERSONSUPERVISOR(P_PERSON_ID);
22: PQH_TENURE_DETAIL.GETPERSONINFO(P_PERSON_ID
23: ,CP_EMPLOYEE_ID
24: ,CP_FACULTY_MEMBER_NAME
25: ,L_LNAME

Line 22: PQH_TENURE_DETAIL.GETPERSONINFO(P_PERSON_ID

18: BEGIN
19: --HR_STANDARD.EVENT('BEFORE REPORT');
20: CP_BUSINESS_GROUP_NAME := GET_BUSINESS_GROUP(P_BUSINESS_GROUP_ID);
21: L_MANAGER_ID := PQH_TENURE_DETAIL.GETPERSONSUPERVISOR(P_PERSON_ID);
22: PQH_TENURE_DETAIL.GETPERSONINFO(P_PERSON_ID
23: ,CP_EMPLOYEE_ID
24: ,CP_FACULTY_MEMBER_NAME
25: ,L_LNAME
26: ,L_TITLE

Line 29: PQH_TENURE_DETAIL.GETPERSONINFO(L_MANAGER_ID

25: ,L_LNAME
26: ,L_TITLE
27: ,L_EMAIL
28: ,L_HIREDATE);
29: PQH_TENURE_DETAIL.GETPERSONINFO(L_MANAGER_ID
30: ,L_EMPID
31: ,CP_ACADEMIC_MANAGER_NAME
32: ,L_LNAME
33: ,L_TITLE

Line 36: PQH_TENURE_DETAIL.GETREPORTBODYTEXT('CE'

32: ,L_LNAME
33: ,L_TITLE
34: ,L_EMAIL
35: ,L_HIREDATE);
36: PQH_TENURE_DETAIL.GETREPORTBODYTEXT('CE'
37: ,L_REGARDS
38: ,CP_BODY_TEXT
39: ,L_BODY_TEXT2
40: ,L_BODY_TEXT3