APPS.PQH_PQHUSNTT_XMLP_PKG dependencies on PQH_TENURE_DETAIL

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

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

Line 25: CP_ACADEMIC_MANAGER_ADDRESS := PQH_TENURE_DETAIL.GETPERSONADDRESS(L_MANAGER_ID

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

Line 27: CP_FACULTY_MEMBER_ADDRESS := PQH_TENURE_DETAIL.GETPERSONADDRESS(P_PERSON_ID

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

Line 29: PQH_TENURE_DETAIL.GETPERSONINFO(P_PERSON_ID

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

Line 36: PQH_TENURE_DETAIL.GETPERSONINFO(L_MANAGER_ID

32: ,CP_FACULTY_MEMBER_LNAME
33: ,CP_FACULTY_MEMBER_TITLE
34: ,CP_FACULTY_MEMBER_EMAIL
35: ,CP_CONTRACT_START_DATE);
36: PQH_TENURE_DETAIL.GETPERSONINFO(L_MANAGER_ID
37: ,L_EMPID
38: ,CP_ACADEMIC_MANAGER_NAME
39: ,L_LNAME
40: ,L_TITLE

Line 43: PQH_TENURE_DETAIL.GETREPORTBODYTEXT('TT'

39: ,L_LNAME
40: ,L_TITLE
41: ,CP_ACADEMIC_MANAGER_EMAIL
42: ,L_HIREDATE);
43: PQH_TENURE_DETAIL.GETREPORTBODYTEXT('TT'
44: ,CP_REGARDS
45: ,CP_BODY_TEXT1
46: ,CP_BODY_TEXT2
47: ,CP_BODY_TEXT3

Line 53: PQH_TENURE_DETAIL.GETPERSONTENURE(P_PERSON_ID

49: ,L_BODY_TEXT5
50: ,L_BODY_TEXT6
51: ,L_BODY_TEXT7
52: ,L_BODY_TEXT8);
53: PQH_TENURE_DETAIL.GETPERSONTENURE(P_PERSON_ID
54: ,L_TENURE_STATUS
55: ,L_STATUS_DATE
56: ,L_TENURE_DATE
57: ,L_REMAIN_YEAR