APPS.PQH_PQHUSASR_XMLP_PKG dependencies on PQH_TENURE_DETAIL

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

46: BEGIN
47: P_CONC_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
48: CP_BUSINESS_GROUP_NAME := GET_BUSINESS_GROUP(P_BUSINESS_GROUP_ID);
49: CP_LOGGED_USER_NAME := FND_PROFILE.VALUE('USERNAME');
50: L_MANAGER_ID := PQH_TENURE_DETAIL.GETPERSONSUPERVISOR(P_PERSON_ID);
51: CP_ACADEMIC_MANAGER_ADDRESS := PQH_TENURE_DETAIL.GETPERSONADDRESS(L_MANAGER_ID
52: ,P_BUSINESS_GROUP_ID);
53: CP_FACULTY_MEMBER_ADDRESS := PQH_TENURE_DETAIL.GETPERSONADDRESS(P_PERSON_ID
54: ,P_BUSINESS_GROUP_ID);

Line 51: CP_ACADEMIC_MANAGER_ADDRESS := PQH_TENURE_DETAIL.GETPERSONADDRESS(L_MANAGER_ID

47: P_CONC_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
48: CP_BUSINESS_GROUP_NAME := GET_BUSINESS_GROUP(P_BUSINESS_GROUP_ID);
49: CP_LOGGED_USER_NAME := FND_PROFILE.VALUE('USERNAME');
50: L_MANAGER_ID := PQH_TENURE_DETAIL.GETPERSONSUPERVISOR(P_PERSON_ID);
51: CP_ACADEMIC_MANAGER_ADDRESS := PQH_TENURE_DETAIL.GETPERSONADDRESS(L_MANAGER_ID
52: ,P_BUSINESS_GROUP_ID);
53: CP_FACULTY_MEMBER_ADDRESS := PQH_TENURE_DETAIL.GETPERSONADDRESS(P_PERSON_ID
54: ,P_BUSINESS_GROUP_ID);
55: PQH_TENURE_DETAIL.GETPERSONINFO(P_PERSON_ID

Line 53: CP_FACULTY_MEMBER_ADDRESS := PQH_TENURE_DETAIL.GETPERSONADDRESS(P_PERSON_ID

49: CP_LOGGED_USER_NAME := FND_PROFILE.VALUE('USERNAME');
50: L_MANAGER_ID := PQH_TENURE_DETAIL.GETPERSONSUPERVISOR(P_PERSON_ID);
51: CP_ACADEMIC_MANAGER_ADDRESS := PQH_TENURE_DETAIL.GETPERSONADDRESS(L_MANAGER_ID
52: ,P_BUSINESS_GROUP_ID);
53: CP_FACULTY_MEMBER_ADDRESS := PQH_TENURE_DETAIL.GETPERSONADDRESS(P_PERSON_ID
54: ,P_BUSINESS_GROUP_ID);
55: PQH_TENURE_DETAIL.GETPERSONINFO(P_PERSON_ID
56: ,L_EMPID
57: ,CP_FACULTY_MEMBER_NAME

Line 55: PQH_TENURE_DETAIL.GETPERSONINFO(P_PERSON_ID

51: CP_ACADEMIC_MANAGER_ADDRESS := PQH_TENURE_DETAIL.GETPERSONADDRESS(L_MANAGER_ID
52: ,P_BUSINESS_GROUP_ID);
53: CP_FACULTY_MEMBER_ADDRESS := PQH_TENURE_DETAIL.GETPERSONADDRESS(P_PERSON_ID
54: ,P_BUSINESS_GROUP_ID);
55: PQH_TENURE_DETAIL.GETPERSONINFO(P_PERSON_ID
56: ,L_EMPID
57: ,CP_FACULTY_MEMBER_NAME
58: ,CP_FACULTY_MEMBER_LNAME
59: ,CP_FACULTY_MEMBER_TITLE

Line 62: PQH_TENURE_DETAIL.GETPERSONINFO(L_MANAGER_ID

58: ,CP_FACULTY_MEMBER_LNAME
59: ,CP_FACULTY_MEMBER_TITLE
60: ,CP_FACULTY_MEMBER_EMAIL
61: ,CP_CONTRACT_START_DATE);
62: PQH_TENURE_DETAIL.GETPERSONINFO(L_MANAGER_ID
63: ,L_EMPID
64: ,CP_ACADEMIC_MANAGER_NAME
65: ,L_LNAME
66: ,L_TITLE

Line 69: PQH_TENURE_DETAIL.GETREPORTBODYTEXT('AS'

65: ,L_LNAME
66: ,L_TITLE
67: ,CP_ACADEMIC_MANAGER_EMAIL
68: ,L_HIREDATE);
69: PQH_TENURE_DETAIL.GETREPORTBODYTEXT('AS'
70: ,CP_REGARDS
71: ,CP_BODY_TEXT1
72: ,CP_BODY_TEXT2
73: ,CP_BODY_TEXT3

Line 79: PQH_TENURE_DETAIL.GETPERSONTENURE(P_PERSON_ID

75: ,CP_BODY_TEXT5
76: ,L_BODY_TEXT6
77: ,L_BODY_TEXT7
78: ,L_BODY_TEXT8);
79: PQH_TENURE_DETAIL.GETPERSONTENURE(P_PERSON_ID
80: ,L_TENURE_STATUS
81: ,L_DETERMINE_DATE
82: ,L_ADJUSTED_TENURE_DATE
83: ,L_REMAIN_YEAR

Line 87: CP_ACADEMIC_RANK := PQH_TENURE_DETAIL.GETPERSONRANK(P_PERSON_ID);

83: ,L_REMAIN_YEAR
84: ,L_REMAIN_MONTH
85: ,L_COMPLETED_YEAR
86: ,L_COMPLETED_MONTH);
87: CP_ACADEMIC_RANK := PQH_TENURE_DETAIL.GETPERSONRANK(P_PERSON_ID);
88: OPEN EMP_REVU_CUR;
89: FETCH EMP_REVU_CUR
90: INTO
91: L_REVIEW_DATE;