17: L_BODY_TEXT8 VARCHAR2(2);
18: L_HIREDATE DATE;
19: L_MANAGER_ID NUMBER;
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
74: ,'COLLEGE_UNIVERSITY_NAME'
75: ,CP_BUSINESS_GROUP_NAME);
76:
77: CP_BODY_TEXT1 := REPLACE(CP_BODY_TEXT1
78: ,fnd_global.local_chr(38)
79: ,'');
80: CP_BODY_TEXT2 := REPLACE(CP_BODY_TEXT2
81: ,fnd_global.local_chr(38)
82: ,'');
77: CP_BODY_TEXT1 := REPLACE(CP_BODY_TEXT1
78: ,fnd_global.local_chr(38)
79: ,'');
80: CP_BODY_TEXT2 := REPLACE(CP_BODY_TEXT2
81: ,fnd_global.local_chr(38)
82: ,'');
83: CP_BODY_TEXT4 := REPLACE(CP_BODY_TEXT4
84: ,fnd_global.local_chr(38)
85: ,'');
80: CP_BODY_TEXT2 := REPLACE(CP_BODY_TEXT2
81: ,fnd_global.local_chr(38)
82: ,'');
83: CP_BODY_TEXT4 := REPLACE(CP_BODY_TEXT4
84: ,fnd_global.local_chr(38)
85: ,'');
86:
87: RETURN (TRUE);
88: END BEFOREREPORT;