APPS.PQH_PQHUSNTS_XMLP_PKG dependencies on PQH_TENURE_DETAIL

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

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

Line 22: CP_ACADEMIC_MANAGER_ADDRESS := PQH_TENURE_DETAIL.GETPERSONADDRESS(L_MANAGER_ID

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

Line 24: CP_FACULTY_MEMBER_ADDRESS := PQH_TENURE_DETAIL.GETPERSONADDRESS(P_PERSON_ID

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

Line 26: PQH_TENURE_DETAIL.GETPERSONINFO(P_PERSON_ID

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

Line 33: PQH_TENURE_DETAIL.GETPERSONINFO(L_MANAGER_ID

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

Line 40: PQH_TENURE_DETAIL.GETREPORTBODYTEXT('TS'

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