APPS.PQH_PQHUSNNT_XMLP_PKG dependencies on PQH_TENURE_DETAIL

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

16: BEGIN
17: P_CONC_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
18: CP_BUSINESS_GROUP_NAME := GET_BUSINESS_GROUP(P_BUSINESS_GROUP_ID);
19: CP_LOGGED_USER_NAME := FND_PROFILE.VALUE('USERNAME');
20: L_MANAGER_ID := PQH_TENURE_DETAIL.GETPERSONSUPERVISOR(P_PERSON_ID);
21: CP_ACADEMIC_MANAGER_ADDRESS := PQH_TENURE_DETAIL.GETPERSONADDRESS(L_MANAGER_ID
22: ,P_BUSINESS_GROUP_ID);
23: CP_FACULTY_MEMBER_ADDRESS := PQH_TENURE_DETAIL.GETPERSONADDRESS(P_PERSON_ID
24: ,P_BUSINESS_GROUP_ID);

Line 21: CP_ACADEMIC_MANAGER_ADDRESS := PQH_TENURE_DETAIL.GETPERSONADDRESS(L_MANAGER_ID

17: P_CONC_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
18: CP_BUSINESS_GROUP_NAME := GET_BUSINESS_GROUP(P_BUSINESS_GROUP_ID);
19: CP_LOGGED_USER_NAME := FND_PROFILE.VALUE('USERNAME');
20: L_MANAGER_ID := PQH_TENURE_DETAIL.GETPERSONSUPERVISOR(P_PERSON_ID);
21: CP_ACADEMIC_MANAGER_ADDRESS := PQH_TENURE_DETAIL.GETPERSONADDRESS(L_MANAGER_ID
22: ,P_BUSINESS_GROUP_ID);
23: CP_FACULTY_MEMBER_ADDRESS := PQH_TENURE_DETAIL.GETPERSONADDRESS(P_PERSON_ID
24: ,P_BUSINESS_GROUP_ID);
25: PQH_TENURE_DETAIL.GETPERSONINFO(P_PERSON_ID

Line 23: CP_FACULTY_MEMBER_ADDRESS := PQH_TENURE_DETAIL.GETPERSONADDRESS(P_PERSON_ID

19: CP_LOGGED_USER_NAME := FND_PROFILE.VALUE('USERNAME');
20: L_MANAGER_ID := PQH_TENURE_DETAIL.GETPERSONSUPERVISOR(P_PERSON_ID);
21: CP_ACADEMIC_MANAGER_ADDRESS := PQH_TENURE_DETAIL.GETPERSONADDRESS(L_MANAGER_ID
22: ,P_BUSINESS_GROUP_ID);
23: CP_FACULTY_MEMBER_ADDRESS := PQH_TENURE_DETAIL.GETPERSONADDRESS(P_PERSON_ID
24: ,P_BUSINESS_GROUP_ID);
25: PQH_TENURE_DETAIL.GETPERSONINFO(P_PERSON_ID
26: ,L_EMPID
27: ,CP_FACULTY_MEMBER_NAME

Line 25: PQH_TENURE_DETAIL.GETPERSONINFO(P_PERSON_ID

21: CP_ACADEMIC_MANAGER_ADDRESS := PQH_TENURE_DETAIL.GETPERSONADDRESS(L_MANAGER_ID
22: ,P_BUSINESS_GROUP_ID);
23: CP_FACULTY_MEMBER_ADDRESS := PQH_TENURE_DETAIL.GETPERSONADDRESS(P_PERSON_ID
24: ,P_BUSINESS_GROUP_ID);
25: PQH_TENURE_DETAIL.GETPERSONINFO(P_PERSON_ID
26: ,L_EMPID
27: ,CP_FACULTY_MEMBER_NAME
28: ,CP_FACULTY_MEMBER_LNAME
29: ,CP_FACULTY_MEMBER_TITLE

Line 32: PQH_TENURE_DETAIL.GETPERSONINFO(L_MANAGER_ID

28: ,CP_FACULTY_MEMBER_LNAME
29: ,CP_FACULTY_MEMBER_TITLE
30: ,CP_FACULTY_MEMBER_EMAIL
31: ,CP_CONTRACT_START_DATE);
32: PQH_TENURE_DETAIL.GETPERSONINFO(L_MANAGER_ID
33: ,L_EMPID
34: ,CP_ACADEMIC_MANAGER_NAME
35: ,L_LNAME
36: ,L_TITLE

Line 39: PQH_TENURE_DETAIL.GETREPORTBODYTEXT('NT'

35: ,L_LNAME
36: ,L_TITLE
37: ,CP_ACADEMIC_MANAGER_EMAIL
38: ,L_HIREDATE);
39: PQH_TENURE_DETAIL.GETREPORTBODYTEXT('NT'
40: ,CP_REGARDS
41: ,CP_BODY_TEXT
42: ,L_BODY_TEXT2
43: ,L_BODY_TEXT3