1229:
1230:
1231: -- Bug 3863508 : Start
1232:
1233: --Procedure to obtain the user display name from EDR_PSIG_DETAILS if
1234: --the value is not null. Else it is fetched from FND tables
1235: PROCEDURE FETCH_USER_DISPLAY_NAME(P_USER_NAME IN VARCHAR2,
1236: P_SIGNATURE_ID IN NUMBER,
1237: X_USER_DISPLAY_NAME OUT NOCOPY VARCHAR2)
1239: l_displayname varchar2(400);
1240:
1241: BEGIN
1242:
1243: select user_display_name into l_displayname from edr_psig_details where
1244: signature_id=p_signature_id;
1245: x_user_display_name:=nvl(l_displayname,edr_utilities.getuserdisplayname(p_user_name));
1246:
1247: --Bug 3101047 : END