APPS.PQH_PQHUSNRW_XMLP_PKG dependencies on PQH_TENURE_DETAIL

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

39: BEGIN
40: P_CONC_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
41: CP_BUSINESS_GROUP_NAME := GET_BUSINESS_GROUP(P_BUSINESS_GROUP_ID);
42: CP_LOGGED_USER_NAME := FND_PROFILE.VALUE('USERNAME');
43: L_MANAGER_ID := PQH_TENURE_DETAIL.GETPERSONSUPERVISOR(P_PERSON_ID);
44: CP_ACADEMIC_MANAGER_ADDRESS := PQH_TENURE_DETAIL.GETPERSONADDRESS(L_MANAGER_ID
45: ,P_BUSINESS_GROUP_ID);
46: CP_FACULTY_MEMBER_ADDRESS := PQH_TENURE_DETAIL.GETPERSONADDRESS(P_PERSON_ID
47: ,P_BUSINESS_GROUP_ID);

Line 44: CP_ACADEMIC_MANAGER_ADDRESS := PQH_TENURE_DETAIL.GETPERSONADDRESS(L_MANAGER_ID

40: P_CONC_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
41: CP_BUSINESS_GROUP_NAME := GET_BUSINESS_GROUP(P_BUSINESS_GROUP_ID);
42: CP_LOGGED_USER_NAME := FND_PROFILE.VALUE('USERNAME');
43: L_MANAGER_ID := PQH_TENURE_DETAIL.GETPERSONSUPERVISOR(P_PERSON_ID);
44: CP_ACADEMIC_MANAGER_ADDRESS := PQH_TENURE_DETAIL.GETPERSONADDRESS(L_MANAGER_ID
45: ,P_BUSINESS_GROUP_ID);
46: CP_FACULTY_MEMBER_ADDRESS := PQH_TENURE_DETAIL.GETPERSONADDRESS(P_PERSON_ID
47: ,P_BUSINESS_GROUP_ID);
48: PQH_TENURE_DETAIL.GETPERSONINFO(P_PERSON_ID

Line 46: CP_FACULTY_MEMBER_ADDRESS := PQH_TENURE_DETAIL.GETPERSONADDRESS(P_PERSON_ID

42: CP_LOGGED_USER_NAME := FND_PROFILE.VALUE('USERNAME');
43: L_MANAGER_ID := PQH_TENURE_DETAIL.GETPERSONSUPERVISOR(P_PERSON_ID);
44: CP_ACADEMIC_MANAGER_ADDRESS := PQH_TENURE_DETAIL.GETPERSONADDRESS(L_MANAGER_ID
45: ,P_BUSINESS_GROUP_ID);
46: CP_FACULTY_MEMBER_ADDRESS := PQH_TENURE_DETAIL.GETPERSONADDRESS(P_PERSON_ID
47: ,P_BUSINESS_GROUP_ID);
48: PQH_TENURE_DETAIL.GETPERSONINFO(P_PERSON_ID
49: ,L_EMPID
50: ,CP_FACULTY_MEMBER_NAME

Line 48: PQH_TENURE_DETAIL.GETPERSONINFO(P_PERSON_ID

44: CP_ACADEMIC_MANAGER_ADDRESS := PQH_TENURE_DETAIL.GETPERSONADDRESS(L_MANAGER_ID
45: ,P_BUSINESS_GROUP_ID);
46: CP_FACULTY_MEMBER_ADDRESS := PQH_TENURE_DETAIL.GETPERSONADDRESS(P_PERSON_ID
47: ,P_BUSINESS_GROUP_ID);
48: PQH_TENURE_DETAIL.GETPERSONINFO(P_PERSON_ID
49: ,L_EMPID
50: ,CP_FACULTY_MEMBER_NAME
51: ,CP_FACULTY_MEMBER_LNAME
52: ,CP_FACULTY_MEMBER_TITLE

Line 55: PQH_TENURE_DETAIL.GETPERSONINFO(L_MANAGER_ID

51: ,CP_FACULTY_MEMBER_LNAME
52: ,CP_FACULTY_MEMBER_TITLE
53: ,CP_FACULTY_MEMBER_EMAIL
54: ,CP_CONTRACT_START_DATE);
55: PQH_TENURE_DETAIL.GETPERSONINFO(L_MANAGER_ID
56: ,L_EMPID
57: ,CP_ACADEMIC_MANAGER_NAME
58: ,L_LNAME
59: ,L_TITLE

Line 62: PQH_TENURE_DETAIL.GETREPORTBODYTEXT('RW'

58: ,L_LNAME
59: ,L_TITLE
60: ,CP_ACADEMIC_MANAGER_EMAIL
61: ,L_HIREDATE);
62: PQH_TENURE_DETAIL.GETREPORTBODYTEXT('RW'
63: ,CP_REGARDS
64: ,CP_BODY_TEXT1
65: ,CP_BODY_TEXT2
66: ,L_BODY_TEXT3