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);
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
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
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
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
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