DBA Data[Home] [Help]

APPS.EDR_UTILITIES dependencies on EDR_PSIG_DETAILS

Line 1233: --Procedure to obtain the user display name from EDR_PSIG_DETAILS if

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)

Line 1243: select user_display_name into l_displayname from edr_psig_details where

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