DBA Data[Home] [Help]

APPS.PQH_PQHUSASR_XMLP_PKG dependencies on FND_GLOBAL

Line 47: P_CONC_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;

43: ,12)
44: AND PAP.PERSON_ID = P_PERSON_ID
45: AND PE.BUSINESS_GROUP_ID + 0 = P_BUSINESS_GROUP_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

Line 106: ,fnd_global.local_chr(38)

102: CP_BODY_TEXT1 := REPLACE(CP_BODY_TEXT1
103: ,'TENURE_DATE'
104: ,L_ADJUSTED_TENURE_DATE);
105: CP_BODY_TEXT1 := REPLACE(CP_BODY_TEXT1
106: ,fnd_global.local_chr(38)
107: ,'');
108: IF L_REVIEW_DATE IS NOT NULL THEN
109: CP_BODY_TEXT2 := REPLACE(CP_BODY_TEXT2
110: ,' REVIEW_DATE'